Warehouse Tablet - Sales / Purchase Order Picks - Save User / Date / Time

New options have been added to allow the save of a sales/purchase order pick to record both the user who picked the order and the date/time the order was picked.

Installation

Database Changes

Changes are required to the Sales Order Header/Detail databases and the Purchase Order Header / Detail databases to record the user / date / time. To add these items, select Installation from the main menu followed by Application Manager and then Restructure A Database. Select the Order Processing application and elect to update the Live Files and then select the Header file.

To insert a new item press <Enter> against a blank entry, enter the title as required and press <Enter>, select the item type (using the drop-down list if required), and depending on item type select the size required.

Item Name      Type      Description

PICK-USER        X 6      Holds the user-id of the user who last picked the order.

PICK-DATE        E         Holds the date the order was last picked.

PICK-TIME        N         Holds the time the order was last picked.

Once the required items have been recorded press the <ESC> key and select the UPDATE button to save the database changes. When prompted respond ‘Y’ to the prompts to ‘Extract Existing Data to New Database Structure’ and, if appropriate, ‘Copy Table Entries from Old Database to New Database’. Final prompts ask to ‘Remove (.OLD) Database’ and to ‘Carry Out the Same Restructure on the BASE File as well’ – respond as required. If you select to update the base file, you need to manually insert the new items at the same data item positions as on the live file.

Once the header is updated repeat for the detail file if necessary.

Tablet Field Mappings

Within the SETTINGS option select Field Mappings and select the Sales Order Header mappings screen.

Reference the data items added against the ‘Data File Profile’ items on the left and then save. Repeat for the Sales Order Detail / Purchase Order Header and Detail files as required.