Home » Categories » Multiple Categories |
Extra Lookup Options in Order Header Input |
Article Number: 343 | Rating: Unrated | Last Updated: Wed, Jun 14, 2023 at 5:23 PM
|
Datafile Software Extra Lookup Options in Order Header Input The Sales and Purchase Order Processing header entry screens allow you to define a lookup to another database. This new feature allows you to define a further nine lookups to that same database and define a further two new lookup databases. InstallationApplication User FacilitiesThe lookup database options are configured within the order header screen design and defined by selecting the option Look-up from the Tools pull-down menu. Database Pathname - Enter the pathname for the database to look-up to.<F4-Select> is available if required. Lookup Format - Enter the format for the prime-index of the lookup database – i.e. AAA999, UUUUUUUUUU, etc. Item for Lookup (1-10) - Select the data item on the order header database you wish to lookup from. The first item is the primary lookup item and this is the only lookup item, against this database, that action the set copy items. The remaining nine items can lookup to the database for code validation but will not action any copy items. Items to List When Selecting Records - Here you define the items to be listed from the lookup database when the operator presses <F4-Select>. Note this defines the items in the list; the items that can be searched upon are the prime and secondary indexes of the database concerned. Items to Copy from Lookup - This option allows you to define copy items from the lookup database to the order header file. As discussed above any copy items are only actioned on the first lookup item, the remaining nine lookup items being used for validation purposes only. The first lookup database allows the definition of twenty copy items; the second and third databases allow the definition of ten copy items each. After confirming the first lookup database the process is repeated for the second and third lookup databases. Notes The lookup databases on the first screen of the order header entry are shared between the ‘add’ and ‘amend’ screens – even where designed with separate layouts. The lookup databases are defined separately for the second screen. The selective order header entry screen continues to allow one lookup database. |
Attachments
![]() There are no attachments for this article.
|
Instant Print Document Selection
Viewed 1477 times since Wed, Jun 13, 2012
Order Detail Pick Lists – Select by Order Reference
Viewed 32 times since Thu, Oct 24, 2024
Print Invoices / Purchase Invoices - Application User Facilities
Viewed 1557 times since Wed, Jul 4, 2012
Manual Document Processing
Viewed 1310 times since Tue, Jul 3, 2012
Omit Application of Discount Matrix Entries on Price Band (SOP Only)
Viewed 1742 times since Wed, Jun 13, 2012
System Status - Application User Facilities
Viewed 1517 times since Wed, Jul 4, 2012
Scan Supplier Delivery Notes on Goods Receipt
Viewed 4855 times since Tue, Jun 12, 2012
Alternative Order Status Codes
Viewed 1162 times since Fri, Jun 19, 2020
Set Auto Expand Data Files
Viewed 1471 times since Wed, Jul 4, 2012
Quick Form Order Entry
Viewed 1445 times since Fri, Nov 22, 2013
|