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

Matrix Enquiry - Batch Tracking

Datafile Software

Matrix Enquiry - Batch Tracking

The Stock Ledger Enquiry allows you to view a list of the batches available for each stock item showing physical quantities etc., and the batch code enquiry allows you to see the quantity details for individual batches. Where you have a matrix item this option allows you a snapshot table enquiry of all the batches for an individual stock item.

Selecting this option asks for the stock code to enquiry upon and then asks how you want the table to be displayed, and then the quantity to view.

Stock Code

Select the stock code to be enquired upon; <F4-Select> is available if required. Only stock codes that are flagged as matrix / template items will be accepted.

Factor to Display in Rows
Factor to Display in Columns
Factor to Display per Screen

These parameters ask how to configure the enquiry – which of the factors is to be displayed across the screen, down the screen and which (for a three-factored matrix) is to be displayed on subsequent screens. On entry on the stock code the factors defined for that item are displayed for reference.

P) Phys, O) On-Order, R) Res or F) Free

This parameter asks which of the stock quantities you wish to enquire upon.

Once these details have been entered / confirmed then the matrix enquiry is displayed.

Here the first selected factor (colour) is displayed across the screen, the second selected factor (size) is displayed down the screen and the quantities are displayed as a grid – pressing <Enter> or the Zoom button will list the batch item(s) for that combination. For a three-factored matrix enquiry pressing <Page-Down> and <Page-Up> allows you to display the third factors variations.

Custom Fields
  • Release ID: Standard
Attachments Attachments
There are no attachments for this article.
Related Articles RSS Feed
Build Assembly (Physical) - Stock Control
Viewed 1546 times since Mon, Jun 18, 2012
Stock Statements / Enquiries - Stock Control
Viewed 1347 times since Tue, Jun 19, 2012
Replicate a Stock Record - Stock Control
Viewed 1291 times since Mon, Jun 18, 2012
Batch Enquiry - Batch Tracking
Viewed 1290 times since Wed, Jun 20, 2012
Separate Lookups for Second / Extra Maintenance Screens
Viewed 1294 times since Tue, Jun 12, 2012
Compact & Audit Database - Stock Control
Viewed 1270 times since Tue, Jun 19, 2012
Stock Transaction - Select Stock by Alternate Item
Viewed 620 times since Mon, Mar 2, 2020
Maintain Batch Matrix - Batch Tracking
Viewed 1271 times since Wed, Jun 20, 2012
Stock Enquiry
Viewed 1280 times since Mon, Jun 18, 2012
Audit Pointers: Batch to Stock & Audit Pointers: Batch to Transactions - Batch Tracking
Viewed 1380 times since Tue, Jun 19, 2012