Home » Categories » Solutions by Business Process » Stock Control and Batch Tracking |
Stock Mandatory - Stock Control |
Article Number: 518 | Rating: Unrated | Last Updated: Thu, Jun 22, 2023 at 10:51 PM
|
Datafile Software Stock Mandatory - Stock Control STOCK CODE X (16) The prime index of the stock file holding the Stock Code itself and, in the case of location stock, the first few characters identify the stock location code. In Premiersystems the stock code can be up to 32 characters in length. STOCK DESCRIPTION X (30) Holds the first line of description for the stock item. An optional second item is profiled later. UNIT OF ISSUE X (6) Holds a descriptive issue unit – i.e. EACH, GROSS etc. ON-ORDER QTY K, L, M Primarily the quantity ordered from suppliers through purchase order processing it can include purchase order transactions entered via Stock Control and the quantity of the finished item awaiting build within Bill of Materials. PHYSICAL QTY K, L, M The quantity held in stock. RESERVED QTY K, L, M Primarily the quantity ordered by customers through Sales Order Processing it can include reservation transactions entered via Stock Control and the quantity of components awaiting issue to Bill of Materials. FREE QUANTITY * A calculation of Physical plus On-Order less Reserved. PICK QTY (OPT) K, L, M An optional item that holds the quantity waiting to be ‘picked’. A Sales Order Processing acknowledgement increases this value, a delivery note decreases it. FIRST-TRANSACTION Y (6) Holds the record number of the first stock transaction for this stock item. LAST-TRANSACTION Y (6) Holds the record number of the last stock transaction for the stock item. B/F STOCK QTY K, L, M Updated at period end with the current value of the physical quantity (or Physical less Forward if forward stock processing in use). COST PRICE K, L, M Holds the cost price of the stock item used for valuation (unless FIFO in use) and cost-of-sales. This cost will be used as the next purchase order cost unless overridden by matrix entries or last order price. LAST TRANS DATE D, E Holds the date of the last entered transaction for the stock item. LAST SALE DATE D, E Holds the date of the last sales issue LAST PURCHASE DATE D, E Holds the date of the last goods receipt |
Attachments
![]() There are no attachments for this article.
|
Mandatory Extra Input Items
Viewed 1396 times since Wed, Sep 21, 2016
Delivery / Goods Received Note - Batch Tracking
Viewed 2307 times since Tue, Jun 19, 2012
Assemblies - Bulk Stock Items
Viewed 1758 times since Fri, Jun 8, 2012
Transaction Control Numbers - Stock Control
Viewed 1574 times since Tue, Jun 19, 2012
Recall Standard Text - Stock Control
Viewed 1389 times since Tue, Jun 19, 2012
Audit Pointers: Batch to Stock & Audit Pointers: Batch to Transactions - Batch Tracking
Viewed 1566 times since Tue, Jun 19, 2012
Assign Nominal Codes from Stock Location File
Viewed 2971 times since Fri, Jun 8, 2012
Document Design Manager - Print Preview and Test Print - Stock Control
Viewed 1575 times since Tue, Jun 19, 2012
Stock Adjustments - Stock Control
Viewed 1768 times since Mon, Jun 18, 2012
Set Application Code Formats - Stock Control
Viewed 1433 times since Mon, Jun 18, 2012
|