We are working on setting up MRP and seem to have run into an issue. The Safety Stock field in inventoryItem (AMSafetyStock) can only handle values up to 9,999,999. We have items that require a safety stock of anywhere from 10-50 million (possibly even more). In a sandbox, I updated the field to accept additional digits but we are still getting errors. I also do not know if that is a good way to go about it. Seems like an update that touches that table could change the field back and destroy that data.
Question
Safety stock max quantity
We are working on setting up MRP and seem to have run into an issue. The Safety Stock field in inventoryItem (AMSafetyStock) can only handle values up to 9,999,999. We have items that require a safety stock of anywhere from 10-50 million (possibly even more). In a sandbox, I updated the field to accept additional digits but we are still getting errors. I also do not know if that is a good way to go about it. Seems like an update that touches that table could change the field back and destroy that data.
Hi there
You could customize the Max Value of the Field.
Yet, I would argue (and obviously I do not know the industry or specific business practices), that maybe the Base UOM is set low and considering using a different Base UOM (think of inches versus feet, ea vs pack, mm versus cm) to resolve these issues.
As the Base UOM is also the counting Unit, I would argue counting millions of parts might be tedious and it would be more reasonable to update this.
Granted, once again I don’t know the business but just wanted to put that thought out there.
Otherwise, if you can share how you customized it and share the errors as well, we can try to get to the bottom of this.
A single lot of our material is 100,000-1,000,000 pieces. We run many times that per day which requires us to keep a safety stock of tens of millions of pieces. We attempted to adjust the DB field from 16,9 to 19,9 and received errors. I’m not sure if the system can handle that many digits when performing calculations, I’m not sure how this will affect future updates, etc.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.