Discussions
What is the actual formula for auto-calculated preferred stock level and reorder Point
Hi Gurus,
In Item Master, by default, it ticked auto calculated for both preferred stock level and reorder point.
In "Current Inventory Snapshot" for FO location only, the reorder point 107 and preferred stock level is 153
Item | Reorder point | Preferred stock level | on hand | committed | in transit | current qty available | |
|---|---|---|---|---|---|---|---|
F101AMM0112 | 107 | 153 | 4222 | 116 | 12 | 4106 | |
Item sold quantity for 3 mths is 565 for FO location.
Item sold quantity for 6 mths is 969 for FO location.
We couldn't get the figure of the reorder point and preferred stock level using the formula.
Appreciated any valuable advice.
Thanks & Regards,
Bee Yook