Home » Categories » Multiple Categories |
Extra Lookup Options in Order Detail Input |
Article Number: 372 | Rating: Unrated | Last Updated: Wed, Jun 14, 2023 at 5:19 PM
|
Datafile Software Extra Lookup Options in Order Detail Input The Sales and Purchase Order Processing detail entry screens (in ‘design’ mode) allow the ability to define a lookup to another database. This new feature allows you to set a further nine lookups to that same database and define a further two new lookup databases. Installation
Application User Facilities The lookup database options are configured within the order detail screen design. To amend the screen design, select Installation on the main menu and then select Application Manager followed by Application User Facilities. Select the appropriate order processing application and then select Enter/Amend Orders and then Maintain Order Details. The lookup databases are defined by selecting the option Look-up from the tools pull-down menu. Database Pathname Enter pathname for 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, UUUUUUUUU, etc. Item for Lookup (1-10)
Select the data item on the order detail database that 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 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 After confirming the items for lookup you are prompted for the details to display from the lookup database when selecting via <F4>. Note that these items are for the list display, the items you can select on are the prime and secondary indexes of the lookup database. Copy Items This option allows you to define copy items from the lookup database to the order detail file. As discussed above any copy items are only actioned on the first lookup item, the remaining nine lookup items only being used for validation. The first lookup database allows the definition of 20 copy items; the second and third databases allow the definition of 10 copy items each. After confirming the first lookup database the process is
then repeated for the second and third lookup database. Notes These lookup items apply to the lookup definition for the main order detail screen, the selective detail screens continue to allow one lookup database to be defined. |
Attachments
![]() There are no attachments for this article.
|
Reports
Viewed 1468 times since Tue, Jul 3, 2012
Analyse Purchase Orders
Viewed 1438 times since Tue, Jul 3, 2012
Create New Delivery Address (SOP Only)
Viewed 2098 times since Fri, Jun 8, 2012
Reports and Analysis - Application User Facilities
Viewed 1617 times since Wed, Jul 4, 2012
Order Detail Items to be Printed – Comma’s in Values
Viewed 59 times since Tue, Oct 15, 2024
Batch Import Orders
Viewed 1388 times since Tue, Jul 3, 2012
Print Acknowledgement if no Details
Viewed 1826 times since Wed, Jun 13, 2012
Order Entry - Prevent Changes to Price/Discount (SOP Only)
Viewed 152 times since Thu, Jan 2, 2025
Order Call Off’s – Twice Monthly Frequency
Viewed 49 times since Tue, Oct 22, 2024
Increased Screen Width for Selective Order Screens
Viewed 145 times since Tue, Oct 15, 2024
|