Click here to view the Multi-Site Warehouse Configuration menu.

Click here to view the complete Optifacts User Documentation Index.

Click here to contact us.

Introduction

This document describes the changes that have been made to the Lens Orders application to accommodate the Multi-Site Inventory update.

Procedure

Upon execution of the program, a check gets made that the “MULTI LENS INVENTORY” custom configuration is present and enabled for the system the program connects. If enabled, the “Order From Warehouse” drop-down list in the upper left-hand corner of the application will be visible. The list gets populated with the warehouses with the “TRANSFER IDENTITY” custom configuration enabled, and the sys_name field in the Warehouse table is set either to null or matches the cfg_csetting field from the “TRANSFER IDENTITY” custom configuration. If the “MULTI LENS INVENTORY” custom configuration is not enabled, the application will not have the “Order From Warehouse” drop-down list, and the program will run as usual.

When a warehouse gets chosen, and the user searches for a specific lens, the quantities available are displayed.  

Printer Setup

When the “Orders List” button gets clicked, the Orders list dialog opens. Here the user can set up printer routing to different warehouses. Next, clicking the “Printer Setup...” button will open the printer setup dialog. Here the user can enter the Site Name (may want to include the warehouse number as well) and also choose the printer for that Site Name from a drop-down list. The drop-down list should contain every printer configured for that system.

After the Printer Setup dialog is saved and closed, the user gets returned to the View Orders dialog. If they choose to print, they can choose a warehouse from the drop-down menu and click Print. If the “MULTI LENS INVENTORY” custom configuration is not turned on for this system, the printing will work as usual without the option to set up printer routing.

Lens Transfers

The Lens Orders application also can make and submit Lens Transfer Orders. The accounts chosen in the “Bill To” and “Ship To” text boxes determine if the order is a transfer order or not. When an account is selected, a query executes to determine if  the asn_flag field in the ar_xml table is set to “I.” If it is, the job gets locked in as a Transfer job, and no other lens order type can be chosen.

The previous example was for manually entered jobs. The program also can read in an OMA-formatted file for transfer orders. By selecting the “Open” button and then navigating to a specific location in the open file dialog, the user can select a .txt order file to populate in the application. The program will populate the account information given in the file and lock in the “Transfer” order type if that account is a Transfer account. Upon creating the Order, the qty_on_order field in the invt_rec table gets incremented for the lenses in the order. In the BackOrders dialog, this field gets decremented for any lenses deleted from an order. 

The “STK” field or stocked field in the Lens Order dialog populates for the given warehouse from the warehouse drop-down list. If, by slim chance, a sku is not in the invt_rec table for that warehouse, the sku gets highlighted in red. This will let the user know that the sku needs to be added to the invt_rec table and will most likely need to be ordered. However, this will not prevent the user from creating the order.  

These SKUs appear in red in the Back Orders dialog to let the user know they aren’t available at that warehouse and need to be added to the invt_rec table if they haven’t already. After the order is created, an “EOE Archive” directory is created in the directory where the original file was stored. This directory will hold all files created from this current file location. This is to keep the order files that have been created separate from those that haven’t. For this reason, it is important to save all incoming OMA order files to the same location.

To view and download these instructions as a PDF file, click on the following document image.

Click here to return to the top of the page.