Skip to main content

I am trying to accomplish the following:
Store and Sell item in EAches
Order in CARrtons
Round up to full CARton on PO

Example:
Carton of 2
Customer needs 3 EA
I need the PO to be 2 CARtons
Customer will then get 3 and 1 will end up in stock.

I can get it to order 1 case if the customer only needs 1 EA. But if the customer needs 3, it will put 1.5 on the PO. I can't order half a case.

How do I get the PO to round to full Cases?

I tried Lot size of 1 (and of 2) neither works.

 

This may be the same issue as: Create PO Screen and UOM Conversion | Community (acumatica.com)

 


Hi Debbie - I believe the Lot Size is incremented in the base unit, not the purchase unit on the vendor’s tab (very confusing and duplicates the UOM conversion)

 

Get rid of the MOQ and try increasing the Lot Size to 3 to match the UOM conversion 

 


@kyle90 Thank you for taking the time to respond.  Unfortunately, this does not return the expected results either.

Case summary:

 

Sell Item in Eaches

Purchase Item in Carton (2 each per carton).

Link to PO from SO - Customer needs 3 EA.  The PO needs to be 2 Cartons.

Upon receipt, 1 the Carton is split  - the customer gets their 3 and the remainder of 1 goes to stock


Ok - We often purchase rope or wire on spools of say 500 feet but sell the inventory by the foot. We use reorder points and replenishment primarily, so I was familiar with the impact of Lot Size for those requirements, but I see what you’re saying now and also getting unexpected results when testing

 

If I mark a line item or 749 ft for Purchase to Order, the Create Purchase Orders process screen is rounding that down to 1x 500 ft spool, where as if I put increase the qty to 750 ft the system correctly rounds up to 2x 500 ft spools. If the Lot Size is 500 ft, the system should be rounding up anytime the demand is greater than 500 ft

 

This seems like an error in the logic of the system to me - Lot Size seems to have no impact. If I buy 1x 500 ft spool it won’t be enough to satisfy the customer’s needs the same as if you only buy 1x carton.

 

 

 


@kyle90 Exactly - same issue.  Perhaps you could upvote this request: Create PO Screen and UOM Conversion | Community (acumatica.com)

 

Thanks!


Hi @debbiereed72 were you able to find a solution? Thank you!


@Chris Hackett - thank you for checking. There is no valid solution at this time. This appears to be an open request for 2 years:

Create PO Screen and UOM Conversion | Community (acumatica.com)

 


Reply