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
Assembly Reports - Stock Control
Viewed 1845 times since Tue, Jun 19, 2012
Update Batch Cost on Receipt of Additional Items
Viewed 1979 times since Mon, Jun 11, 2012
Stock File FULL Screen Design (Premier) - Stock Control
Viewed 2291 times since Tue, Jun 19, 2012
Stock Valuation and Cost Prices
Viewed 9118 times since Mon, Jun 18, 2012
Stock FIFO 1 / Assy - Stock Control
Viewed 1850 times since Tue, Jun 19, 2012
Transaction Entry - Additional Options for User 1/2 Items
Viewed 1801 times since Fri, Nov 22, 2013
Goods Returns - Update FIFO Cost Table
Viewed 2892 times since Fri, Jun 8, 2012
Assemblies - Decimal Precision for Component Quantity
Viewed 9879 times since Fri, Jun 8, 2012
Set Auto Expand Data Files - Batch Tracking
Viewed 1811 times since Tue, Jun 19, 2012
Calculate Estimated Usage - Stock Control
Viewed 1886 times since Mon, Jun 18, 2012