Out of Stock Days is a table in the Replenishment suite, which tracks if an item had zero or negative stock in specific locations on a specific date. The system tracks the first date when the Out of Stock situation occurred and also when the item was available again. A day with sales and zero/negative stock is considered as out of stock.
The Out of Stock Days are used in the Average Usage calculation to exclude those days when the average is calculated. Considering those days would result in a too small an average sales quantity.
The result of the Out of Stock calculation can be seen in the Replen. Out of Stock Days page. You can access this page from the Replenishment Control Data page for an item and the Replen. Out of Stock Overview page. For more information, see How to: Set Up Replenishment Out of Stock Overview.
This page shows when an item has gone out of stock in a specific location. Whenever an Out of Stock situation occurs, a record with the starting date in the field Date Out of Stock is created.
When the item has been restocked and stock becomes positive again, the page shows the date it came back in stock in the field Date In Stock, as well as how many days the item was out of stock.
The field No. Of Days Out remains empty until the field Date In Stock is populated. It is calculated starting from the Date Out of Stock until the Date in Stock. If, however, the Date in Stock field is empty during the average usage calculation, the number of days out will be calculated starting from the Date Out of Stock until the WORKDATE.
A day will be considered as out of stock day for an item, if any of these happen:
- Inventory has reached zero or negative quantity.
- Inventory has reached zero or negative quantity right after sales on the same day.
- Inventory was zero or negative quantity before restock happened.
For the out of stock days where the stock has just gone out or been restocked, any sales or sales history adjustment will be excluded from the Average Usage calculation.
Note: Out of stock days are not calculated for BOM items with BOM Method set to Explode at Posting.
The following table describes a sequence of tasks with links to the topics that describe them.
| To | See |
|---|---|
| Perform Out of Stock Days calculation. | How to: Calculate Replenishment Out of Stock Days |
| Set up Replenishment Out of Stock Overview to show the grouped information of the out of stock situations. | How to: Set Up Replenishment Out of Stock Overview |
| Delete the Replen. Out of Stock Logs. | How to: Delete Replenishment Out of Stock Logs |
| View the out of stock statuses with the Replenishment Out of Stock Overview Charts and Replenishment Sales Chart. | Replenishment Out of Stock Charts |
See also
Calculation Process for Average Usage