- Set the stockoutind column to 1 in wpd table (wekly_prod_dmnd) when a pdl (product/location) runs out at any point during the week
- That will allow the ETL to calculate lost sales and revised demand as the difference between the forecast sales (expected sales) and the actual sales reported in wpd
- This will tell the application the pdl ran out during the week reported in wpd with the stockoutind field set to 1
- The lost sales calculation is typically in the wpd ETL and developed by the PS team or the client
- The stockout logic is independent of whether you use replenishment
- The standard logic is when stockoutind is 1 OR inventory 0, the ETL will apply the revised demand calculation and store it in wpd_rev table (wekly_prod_dmnd_rev) as revised demand
- This depends on how the ETL was written
For additional details you can also consult the following documentation:
- KCS-ONE Knowledge Centered Support article: KCS001281
- TDCM Table Interface Guide