Forum Discussion
Calculation of Order Qty based on Minimum Level
Hi, in below table, I would like to calculate Order Status, Daily Balance (inc. Ordered Qty) (kg) and Stock Day(s) (with Ordered Qty). Note: Stock Day(s) should always above Standard Safety Stock Da...
Irwan
Super User
Super Userhello TanLC
i might be missed the information but how do you define 'Order Status'?
On what condition will it become "Yes"?
Thank you.
Hi Irwan , Order Status will show "Yes" if Stock Day(s) < Standard Safety Stock Day(s). Thus, Standard Order Qty to be added onto Daily Balance (kg).
Thank you.
- Irwan
hello TanLC
i see, so what condition when the addition becomes double/triple?
in 4/4/25, the value will add Standar Order Qty once (6974.43+3000=9974.43).
But in 14/4/25, it will add Standar Order Qty twice (4957.45+2x3000=10957.45).
then in 29/4/25, it will add Standar Order Qty three times (1931.99+3x3000=10931.95).
Thank you.