Skip to main content
Solved

PO Receipt rounding issue related to UOMs

  • December 5, 2024
  • 2 replies
  • 24 views
sangland
Varsity I
Forum|alt.badge.img

I am hoping someone can suggest something for this rounding issue in PO Receipting. POs are normally in Purchasing Units, but Drop Shipment POs created from Sales Orders are in Selling unit for some reason.  So create a PO with UOM of EACH and Qty 2 for an item set up like this. Then create the PO Receipt from the PO. The receipt qty is correct by there is a decimal open qty calculated. You have to do a second PO Receipt for the remainder. Is this really necessary? Even if you increase company qty decimals you will get the same problem in the last percentile. 
 

 

 

Best answer by meganfriesen37

The only think I’d maybe try is to switch around your conversion to use multiply from Case to Each to see if that changes things?  (Another option might be to use Each as the base unit, but since you’ve already transacted with this item, I think you’re stuck with what you’ve picked).

This seems buggy and I’d submit it as a case to Acumatica, especially has you have the “Each” unit as non-divisible, so I would have expected that would force it to be a round number?  I agree with your assessment about the decimal place issue.  And if you had 4 units to a case it wouldn’t be an issue since it would round off nicely, but it’s just unlucky that you end up with the repeating decimals on this one.

View original
Regards Simon
    Did this topic help you find an answer to your question?

    2 replies

    meganfriesen37
    Captain II
    Forum|alt.badge.img+12
    • meganfriesen37
    • Captain II
    • 621 replies
    • Answer
    • December 5, 2024

    The only think I’d maybe try is to switch around your conversion to use multiply from Case to Each to see if that changes things?  (Another option might be to use Each as the base unit, but since you’ve already transacted with this item, I think you’re stuck with what you’ve picked).

    This seems buggy and I’d submit it as a case to Acumatica, especially has you have the “Each” unit as non-divisible, so I would have expected that would force it to be a round number?  I agree with your assessment about the decimal place issue.  And if you had 4 units to a case it wouldn’t be an issue since it would round off nicely, but it’s just unlucky that you end up with the repeating decimals on this one.

    Megan Friesen, Contego Software Solutions, Canada
    Chris Hackett
    1 person likes this
    • Chris Hackett
      Chris Hackett
    sangland
    Varsity I
    Forum|alt.badge.img
    • sangland
    • Author
    • Varsity I
    • 36 replies
    • December 6, 2024

    Thanks Megan, I’ll submit a case. The client particularly wants to stock in CASE’s but sell EACH’s.  

    Regards Simon
    Chris Hackett
    1 person likes this
    • Chris Hackett
      Chris Hackett

    Reply


    Most helpful members this week

    Terms & ConditionsCookie settings

    Cookie policy

    We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

     
    Cookie settings
    About Acumatica ERP system
    Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
    © 2008 — 2024  Acumatica, Inc. All rights reserved