Home » Categories » Solutions by Business Process » Stock Control and Batch Tracking

Additional Lookup Options in Stock Maintenance Screens

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.

Custom Fields
  • Release ID: 6.1
Attachments Attachments
There are no attachments for this article.
Related Articles RSS Feed
Default Batch Type for New Stock Items
Viewed 1812 times since Fri, Jun 8, 2012
Batch Reports - Batch Tracking
Viewed 1781 times since Wed, Jun 20, 2012
Application User Facilities - Stock Control
Viewed 1633 times since Tue, Jun 19, 2012
Update Last Sale / Purchase Dates with Assembly Build
Viewed 310 times since Wed, Oct 16, 2024
Sales Issues / Reservation Listing - Stock Control
Viewed 1737 times since Mon, Jun 18, 2012
Mark Stock Records for Year End Delete - Stock Control
Viewed 1800 times since Mon, Jun 18, 2012
Controls and Audit Manager - Stock Control
Viewed 1805 times since Tue, Jun 19, 2012
Transaction / Detail Enquiries - Stock Control
Viewed 1788 times since Tue, Jun 19, 2012
Stock FIFO 1 / Assy - Stock Control
Viewed 1764 times since Tue, Jun 19, 2012
Sales Issues - Stock Control
Viewed 2222 times since Mon, Jun 18, 2012