I have an item that we purchase through MRP and use in manufacturing. This item is in base unit LF and we purchase in Rolls. When purchasing in Rolls, you must buy a full roll - it is not divisible.
In the Create PO pop-up, it converts the LF to Roll which is great but it doesn’t seem to round up and so the PO can’t be created.
I must be missing something here. How can I get the quantity to round up? It should always be a full number (1,2,3,4,5 rolls, etc.)
Hi
To round up the Purchase Qty., this can be done manually by the user.
There is not a setting currently that will round up the quantity automatically.
However, check out this existing Product Idea that is marked as Pending Review:
https://community.acumatica.com/ideas/inventory-replenishment-round-up-1195
Please consider voting for the idea and adding your feedback for our product managers.
I hope this helped!
Try setting the purchase units to EA and the base unit as LF and add a conversion, let’s say it’s 100LF in a Roll, from there set Vendor Lot Size as 1. MRP should then suggest purchase quantities equal to a whole roll (100LF).
A simple example, I sell CONBABY3 by the EA but I purchase by the BOX. Each Box has 100 EAs in it.
My item is set up as follows:
On the vendors tab I have:
I create a sales Order for Qty 75EA but I have 0 on hand. So MRP suggests I buy 1 Box
Hope this helps!
Sincerely,
Andre St. Amour
Try setting the purchase units to EA and the base unit as LF and add a conversion, let’s say it’s 100LF in a Roll, from there set Vendor Lot Size as 1. MRP should then suggest purchase quantities equal to a whole roll (100LF).
A simple example, I sell CONBABY3 by the EA but I purchase by the BOX. Each Box has 100 EAs in it.
My item is set up as follows:
On the vendors tab I have:
I create a sales Order for Qty 75EA but I have 0 on hand. So MRP suggests I buy 1 Box
Hope this helps!
Sincerely,
Andre St. Amour
Thanks for this response Andre - I’m desperate to see this same functionality as you but not sure why MRP is suggesting 0.33 rolls instead of 1 roll.
Here’s my simple example:
Item Set-Up
Vendors Tab
I have demand from production orders for 100 LF and 375LF. If I purchase the 100LF, I see 0.33EA.
In your case, you added 75 units to a SO but it shows 100 units on the MRP Display?
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.