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.
Solved
Safety stock max quantity
Best answer by KrunalDoshi
Hi
Safety Stock (AMSafetyStock) is of datatype decimal(25,6). It should accept 19 digits before decimal out of box, without any customizations. Please check if you have any customization or config settings which is restricting it.
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.
+6Hi
Safety Stock (AMSafetyStock) is of datatype decimal(25,6). It should accept 19 digits before decimal out of box, without any customizations. Please check if you have any customization or config settings which is restricting it.
+6Hi
I am glad it worked for you. Could you please mark my response as answer. Thanks
Login to the community
No account yet? Create an account
Social Login
Login with your Acumatica accountEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.