How to: Calculate Replenishment Out of Stock Days

In this article

To enable Out of Stock calculation

To calculate Out of Stock Days manually

To schedule Out of Stock Days calculation

See also

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.

To enable Out of Stock calculation

  1. Click the icon, enter Replen. Setup, and select the relevant link.
  2. Select the Stock Out Functionality check box in the General FastTab.

The Out of Stock calculation uses an incremental approach, by storing the last processed Entry No. from the table Item Ledger Entry. Whenever a calculation is completed, the last processed Entry No. is stored and the next calculation will continue from that point. This is done to reduce the calculation time.

You can opt to have a different Out of Stock calculation scope by configuring the OOS Calc. Scope setting in the Replen. Setup page. The available options are:

Basic

  • All items will be considered for out of stock calculation, except items that have been set to Blocked in the Item card or Exclude from Replenishment in the Replenishment Control Data card.
  • All locations will be considered for out of stock calculation, except those locations that are used as in-transit locations.

Advanced

  • This option has the same criteria as the Basic calculation scope, and on top of that, only items and locations that are valid for Automatic Replenishment will be considered for out of stock calculation. The following are some of the conditions that qualify an item or location as active for Automatic Replenishment:
    • The store location must be set to active for Automatic Replenishment and have a valid Item Distribution setup.
    • An item, variant, or location has not been set to Exclude from Replenishment in the Replen. Item Store Record.
  • This option is beneficial if you want to have a more focused out of stock overview for items and locations that are active for Replenishment only.

Changing the OOS Calc. Scope setting will delete all the existing records in Replen. Out of Stock Log and Replen. Last Entr for OOS, which will initiate a full recalculation on the next out of stock calculation.

Alternatively, you can also have the system perform a full out of stock recalculation by following these steps:

  1. Click the icon, enter Replen. Setup, and select the relevant link.
  2. Click the value in the Last Entries for OOS Calc. field to open the Replen. Item Out of Stock Last Entry page.
  3. In the Replen. Item Out of Stock Last Entry page, click Delete all Entries. This will delete all records in tables Replen. Last Entr for OOS and Replen. Out of Stock Log. The value of Last Entry for Item Stock Out will be reset to 0 for all the items.
  4. Run the Replen. Upd Out of Stock report.

To calculate Out of Stock Days manually

You can run the calculation of Replenishment Out of Stock manually using the Replen. Upd Out of Stock report.

  • Click the icon, enter Replen. Upd Out of Stock, and select the relevant link.

To schedule Out of Stock Days calculation

The Replenishment Out of Stock calculation can be scheduled to run overnight by creating a Scheduler Job:

  1. Click the icon, enter Scheduler Job List, and select the relevant link.
  2. Create a new Scheduler job by clicking the New action, or select an existing job.
  3. In the General FastTab, define the Job ID and Description.
  4. In the Object Setup FastTab, select Codeunit in the Object Type field and assign the Object No. with 10012203 (LSC Replen. Out of Stock Mgt.).
  5. Go to the Schedule Details FastTab, and define the date and time for when you would like the job to be executed. This includes Time Units, Time Between Check, Next Check Date, and Next Check Time.

See also

Replenishment Out of Stock Days