AMProdMatl.QtyRemaining - Generic Inquiry issue

  • 29 November 2023
  • 4 replies


Materials Consumption GI was working fine for us then all of a sudden the ‘Actual Consumed QTY’ field stopped working properly (calculations are off).


If we pull up the Production Order GI the QTY for labels consumption is accurate on a specific order (2 and 544). 

Which should = 546 Actual Consumed QTY for labels.


However on our Materials Consumption GI for that same production order, only the most recent 2 Actual Consumed QTY is displayed.


The Materials Consumption GI is set up as AMProdMatl.QtyRemaining


We also tested reversing the 544 qty, and the total adjust to -542.


Our question is why isn’t the 544 being calculated properly in this GI? 


4 replies




Still trying to fix this issue. Essentially the Materials Consumption GI is displaying 0 counts for consumed quantity, but the materials are consumed. We only have this issue occasionally which leads us to believe root cause could be something process related.


any help is appreciated

Userlevel 6
Badge +3

@dylantheriault - Can you share the GI here?


@jamesh here is the xml file.


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