Home » Categories » Solutions by Business Process » Finance » Sales and Purchase Ledgers

Show History on Order Entry

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.

Graphical user interface, applicationDescription automatically generated

 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.

 

Graphical user interface, applicationDescription automatically generated

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.

Custom Fields
  • Release ID: 7.8
Attachments Attachments
There are no attachments for this article.
Related Articles RSS Feed
Ledger Enquiry
Viewed 1960 times since Mon, Jul 2, 2012
VAT Adjustments - Post-Dated Purchase Invoices
Viewed 4033 times since Thu, Oct 11, 2018
Sales/Purchase Accounts File – Full Screen Design (Premier only)
Viewed 1495 times since Mon, Jul 2, 2012
Account Turnover - Database Profiles
Viewed 2451 times since Mon, Jul 2, 2012
Foreign Currency Statement Print
Viewed 2127 times since Fri, Jun 8, 2012
Copy Items - Database Profiles
Viewed 1818 times since Mon, Jul 2, 2012
Automatic Payments (Purchase Ledger)
Viewed 1965 times since Mon, Jul 2, 2012
Cost Price Checks - Omit Warning if No Change in Selling Price (SOP Only)
Viewed 176 times since Thu, Jan 2, 2025
Control Report
Viewed 1928 times since Mon, Jul 2, 2012
Show Credit Values as Negative on Sales Statements
Viewed 182 times since Tue, Oct 15, 2024