Discussions
Stay up-to-date with the latest news from NetSuite. You’ll be in the know about how to connect with peers and take your business to new heights at our virtual, in-person, on demand events, and much more.
Now is the time to ask your NetSuite-savvy friends and colleagues to join the NetSuite Support Community! Refer now! Click here to watch and learn more!
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
0