This feature allows you to display entries from a "history” database during order entry. The history database is a nominated DFD that contains a ‘link’ to the entered order detail. This allows, for example, the order entry to show a list of available batch/serial records for the stock item being entered or a list of previous sales of that stock item to the customer.
Note
This feature is only available on full screen order entry, not fast input, and only available when using the user-defined order entry screen.
Installation
Application User Facilities
New parameters have been added to the SOP Optional Features to allow for display of the history database.To update Installer users can right-click on the Order Entry option on the Sales Order menu and select Advanced Input Facilities and Optional Features.
Alternatively select Installation from the main menu followed by Application Manager and Application User Facilities. Select the Sales Order Processing application followed by Enter/Amend Orders, Advanced Input Facilities and Optional Features.
On screen 1 is new prompt ‘Show full screen design order history’ – set this option to configure the history parameters.
SOD Link Item – reference the item on the order detail database that will be the ‘match value’ for the history records to be displayed. <F4-Select> is available.
Data DFD Path – reference the DFD path/filename for the history DFD.
Data Link Item – reference the item on the ‘history’ DFD that will be matched against. Note that this item must be a secondary index.
Record Display Limit – set to limit the number of records returned, leave as 0 to return all matching records.
LIFO – set to display records in last-in-first-out order, leave blank to display in order added.
Selection Criteria – set any criteria to be applied to the records listed, show where physical not equal to 0 for example when listing batch items.
Master DFD Path – where the history file is a detail database, and the link item is the primary key of its master file then you can enter the master file pathname here. In the example above the configuration is looking at the batch records and matching on the stock code, the batch file is a detail of the stock file so we can reference the stock file here. If you were linking to previous sales of this item then you would leave this item blank.
Record Chain First – reference the first pointer data item on the master file.<F4-Select> is available as required.
Record Chain Next – reference the next pointer data item on the history file.<F4-Select> is available as required.
Display Items – set up to 10 items from the history dfd to be displayed. Note that display is limited to the space to the right-border of the order detail entry screen up to screen width.
Article ID: 2398
Created On: Thu, Jan 2, 2025 at 11:03 AM
Last Updated On: Thu, Jan 2, 2025 at 11:06 AM
Online URL: https://kb.datafile.co.uk/article/show-history-on-order-entry-2398.html