Inventory Stock Status Report

Userlevel 3

I’m trying to create a Generic Inquiry in Acumatica for a inventory stock status report. One of the requirements of this report is to show the 12 month rolling avg of the quantity sold for each item. Is there a way to do this in Acumatica? We just need to see the 12mo average quantity sold. I do not see any fields that would provide this information. 


Best answer by kristianharianja 29 September 2021, 09:03

View original

5 replies

Userlevel 1

Try attached GI.

Hey @kristianharianja . I notice that you use group by in your GI. However, there’s no aggregate function in use. As @markusray17 suggested, I think we want to use AVG for ARTran.Qty row. Or perhaps I’m missing something?



Userlevel 6
Badge +5

You should be able to just create a GI for ARTran and group it by inventory item and filter for dates within the last 12 months then use the AVG aggregate function on  the quantity. You may want to add a condition for released transactions only.


If you are trying to include this in another generic inquiry(and don’t want to group everything by inventory item) you could add it as a side panel. As far as I know Acumatica does not support nested GIs so outside of creating a custom table and populating it with the necessary statistics that would be your best option. 

Userlevel 2

I would suggest that you can create a raw data with GI , then using pivot table to group as column for that. 

Userlevel 5
Badge +3

Try attached GI.

Did you ever get an answer to this? My VAR can’t find the easy option either.


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