Home » Categories » Solutions by Business Process » Stock Control and Batch Tracking |
Additional Lookup Options in Stock Maintenance Screens |
Article Number: 236 | Rating: Unrated | Last Updated: Thu, Jun 22, 2023 at 11:32 PM
|
Datafile Software Additional Lookup Options in Stock Maintenance Screens Previously, the Stock Maintenance screens allowed one lookup database. New in Release 6.1 the lookup options have been extended to allow three lookup databases with multiple lookup options to each database as per the similar options within the Sales/Purchase Ledger and Order Processing entry screens. Installation The lookup database options are configured within the stock maintenance screen design. To amend the layout select, from the main menu, Installation followed by Application Manager and then Application User Facilities. Select Stock Control and then select Maintain Stock File and then Add New Stock Record. The lookup databases are 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 customer/supplier database you wish to
look-up from. The first item is the
primary lookup item and it is the only lookup item, against this database, that
will action the set copy items. The
remaining nine items can look-up 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 Look-up– this option allows you to define up to ten copy items from the look-up database to the customer/supplier account record. As discussed above any copy items are only actioned for the first look-up item, the remaining nine look-up items being used for validation purposes only. After confirming the first look-up database the process is repeated for the second and third look-up databases. |
Attachments
![]() There are no attachments for this article.
|
Document Design Manager - E-Mail Settings - Stock Control
Viewed 1570 times since Tue, Jun 19, 2012
Stock Cost Values - Stock Control
Viewed 1470 times since Tue, Jun 19, 2012
Stock Checking Sheet - Stock Control
Viewed 1878 times since Mon, Jun 18, 2012
Matrix Enquiry - Batch Tracking
Viewed 1447 times since Tue, Jun 19, 2012
Stock Transfers Report - Stock Control
Viewed 1406 times since Mon, Jun 18, 2012
Base Date for Slow Moving Stock Report
Viewed 731 times since Fri, Jun 19, 2020
Import Batch Tracked Stock Lines
Viewed 1193 times since Fri, May 20, 2016
Stock Take / Forward - Stock Control
Viewed 40443 times since Tue, Jun 19, 2012
Ideal Buying Quantity
Viewed 1418 times since Mon, Jun 18, 2012
Transaction Control Numbers - Stock Control
Viewed 1544 times since Tue, Jun 19, 2012
|