Skip to main content
Solved

PO History tab shows receipted qty in Base UOM rather than UOM in Purchase Receipt

A
Varsity I
Forum|alt.badge.img

Hi,

One of our clients has many items with a base of UOM and a Purchase Unit of M2. These items are set up with conversion factors (as shown in the first image below) to correctly convert based on their formulas.

This conversion setup seems to be causing some confusion in the PO History tab of the Purchase Orders screen, as a Purchase Receipt was processed using the M2 UoM, but the PO History tab in the Purchase Order is displaying the Receipted Qty in the EACH UoM, which is a much larger number after the conversion (second image below).

After looking into the makeup of this field, I found that this PO History tab field is set up to use the Base Unit. Is there a way to ensure that this field always shows what was processed in the main Purchase Receipt record instead of converting to the Base UOM?

Let me know if I can provide any other information.

Kind regards,

Andrew

 

This is the conversion set up for the item shown in the PO and Purchase Receipt below
Purchase Order displays receipt in Base UoM

 

Purchase Receipt uses M2 UoM
Receipted Qty field seems to use Base UOM

 

Best answer by PaulMainard55

It would be nice to be able to see both Purchase UOM and Base UOM as this is often confusing, even for a long-time consultant as myself.  It looks like your only options are custom fields or customizing the attributes as you’ve identified.  
 

You might want to try adding the “Base Received Qty” to your Details grid.  This would be a good no-code customization that you could do that will at least allow the users to see both the base qty ordered and base qty received without having to inspect the PO History tab.

 

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

2 replies

PaulMainard55
Varsity I
Forum|alt.badge.img+2
  • PaulMainard55
  • Varsity I
  • 49 replies
  • Answer
  • January 22, 2025

It would be nice to be able to see both Purchase UOM and Base UOM as this is often confusing, even for a long-time consultant as myself.  It looks like your only options are custom fields or customizing the attributes as you’ve identified.  
 

You might want to try adding the “Base Received Qty” to your Details grid.  This would be a good no-code customization that you could do that will at least allow the users to see both the base qty ordered and base qty received without having to inspect the PO History tab.

 

Chris Hackett
A
2 people like this
  • Chris Hackett
    Chris Hackett
  • A
    AndrewA
A
Varsity I
Forum|alt.badge.img
  • AndrewA
  • Author
  • Varsity I
  • 81 replies
  • January 22, 2025

Hi Paul,

Thanks for that suggestion, I will see what they think of this no-code option. If they want something different, I will see how some customising goes.

Kind regards,

Andrew

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