Home » Categories » Solutions by Business Process » Finance » Sales and Purchase Ledgers |
Show History on Order Entry |
Article Number: 2398 | Rating: Unrated | Last Updated: Thu, Jan 2, 2025 at 11:06 AM
|
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. |
Attachments
![]() There are no attachments for this article.
|
Transaction Reports - Application User Facilities
Viewed 1673 times since Mon, Jul 2, 2012
Account Turnover - Database Profiles
Viewed 2285 times since Mon, Jul 2, 2012
Credit Control Manager (S/L Only)
Viewed 27284 times since Wed, Jun 13, 2012
Additional Lookups on Account Maintenance
Viewed 2093 times since Wed, Jun 13, 2012
Set Company Details
Viewed 1738 times since Mon, Jul 2, 2012
Aged Analysis - Debtor Memo and Transaction Notes to Excel
Viewed 11548 times since Fri, Jun 8, 2012
Trans Optional 2 - Database Profiles
Viewed 1957 times since Mon, Jul 2, 2012
Increased Size of User-2 / User-3 Items
Viewed 1723 times since Wed, Jun 13, 2012
Multi-Period Allocations
Viewed 2030 times since Wed, Jun 13, 2012
STOP – Flag Accounts with Stop Status
Viewed 1105 times since Mon, Jul 2, 2012
|