The Replenishment Item Quantity table contains data used by the Replenishment module. The table displays the inventory for each item and variant at each location, in addition to what is expected to be received at the location (Quantity on Purchase Order and Quantity in Transfer In) and what is to be shipped out from the location (Quantity on Sales Order and Quantity in Transfer Out). It also contains information about Average Daily Sales and the No. of days Out of Stock if the Stock Out functionality is in use.
Calculation of Replenishment Quantity
The Replenishment Item Quantity table provides the input to the function Add Items to the Purchase and Transfer Replenishment Journals. The Replenishment Item Quantity records can be calculated as a pre-process to adding lines to the journals, but would most likely be calculated in an automatic Scheduler Job during overnight processing.
The Replenishment Item Quantity calculation process only creates records for valid items and valid locations for the replenishment process.
Fields
| Field Name | Description |
|---|---|
| Item No. | This field specifies the Item Number. |
| Variant Code | This field specifies the Variant Code. |
| Location Code | This field specifies the Location Code of a Store that is valid for replenishment and the location code of a warehouse that is the default warehouse as defined in the Replenishment From Warehouse table. |
| Inventory | This field specifies the Inventory Status of records Location Code. If the field Calc. Qty. Sold not Posted in the Replenishment Setup record is set, the value of the field Qty. Sold not Posted has been subtracted from the Inventory status. |
| Quantity on Purchase Order | This field specifies the sum of the field Outstanding Qty. (Base) in all Purchase Order Lines. |
| Quantity on Sales Order | This field specifies the sum of the field Outstanding Qty. (Base) in all Sales Order Lines. |
| Quantity in Transfer In | This field specifies the sum Outstanding Qty. (Base) and Qty. in Transit (Base) of all Transfer Order Lines where the Location Code is filtered to the field Transfer-to Code. |
| Quantity in Transfer Out | This field specifies the sum Outstanding Qty. (Base) of all Transfer Order Lines where the Location Code is filtered to the field Transfer-from Code. |
| Date Modified | This field specifies the date when the record was last modified. |
| Time Modified | This field specifies the time when the record was last modified. |
| Daily Sales | This field specifies the calculated average daily sales. |
| Sales Date From | This field specifies the From Date used in the average daily sales calculation. This is influenced by the used Sales Profile and first date of sale. |
| Sales Date To | This field specifies the To Date used in the average daily sales calculation. This is influenced by the used Sales Profile. |
| No. of Sales Dates | This field specifies the number of days in the calculation of the Daily Sale. |
| No. of Days Out of Stock | This field specifies the number of days of zero stock days. |
| Date of First Sale | This field specifies the date when the item was sold for the first time. |
| Adjusted Sales | This field specifies the quantity the sales quantity was adjusted by, according to entries in the Replenishment Sales History Adjustments. |
| Qty. Sold not Posted | This field specifies the quantity of Transaction records that have not been posted in a Statement. This field is only calculated if the field Calc. Qty. Sold not Posted is set in the Replenishment Setup record. |
| Replenish From Warehouse | This field specifies the Location Code of the warehouse the record will be replenished from. |
| Item Division Code | This field specifies the Division Code of the Item No. It is used for filtering when adding items to journals. |
| Item Category Code | This field specifies the Item Category Code of the Item No. It is used for filtering when adding items to journals. |
| Retail Product Code | This field specifies the Retail Product Group Code of the Item No. It is used for filtering when adding items to journals. |
| Vendor No. | This field specifies the Vendor No. that is going to be used when creating a Purchase Order. |
| Replenishment Calculation Type | This field specifies the Replenishment Calculation Type to be used in the replenishment process. Available options are: Automatic, Average Usage, Manual Estimate, Stock Levels, Like for Like, and LS Forecast. |
| Replenish as Location Code | This field specifies the Location Code where the sales history is used. |
| Season Code | This field specifies the Season Code of the Item No. |
| Replenish as Item No. | This field specifies the Item No. where the sales history is used. |
| Planned Sales Demand | This field specifies the quantity from the Replenishment Planned Sales Demand records to overwrite the calculated daily sales amount from sales history. |
| PO Blocked | This field specifies whether the Item No. is blocked for Purchase Orders from the Item Status table. |
| TO Blocked | This field specifies whether the Item No. is blocked for Transfer Orders from the Item Status table. |
| Is a Whse | This field specifies whether the Location Code of the record is a warehouse. |
| Replen. Whse Data Exists | This field specifies if the Item Store record exists for the warehouse. |
| Replen. Source | This field specifies if the Replenishment Data is from the Item, Item Store or Data Profile record. |
| Replen. Code | This field specifies the Item No. or the Data Profile Code. |
| Replen. Variant | This field specifies the Variant Code. |
| Replen. Location | This field specifies the Location Code of the Item Store record. |
| Replen. Valid | This field specifies the Valid from date for the Item Store or the Data Profile record. |
| In Distribution | This field specifies if the Item No is in distribution for the Location. |
| Data Source | This field specifies if the location belongs to the local company or another company, and if it consists of child locations. This field also specifies if the location has no physical store present and the stocks are directly consumed from the warehouse, or if the location belongs to a company that resides in another database. |
| Data Source Company | This field specifies the name of the company to which the location belongs. |
| Is Child Location | This field specifies if the location is a child of another location. |
Calculation of Replenishment Quantity
The calculation of the Replenishment Item Quantity table can be run overnight by using the Scheduler Job.
See also
Calculation of Replenishment Item Quantity