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
View original
+3
Try attached GI.
I would suggest that you can create a raw data with GI , then using pivot table to group as column for that.
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.
Try attached GI.
Hey
Did you ever get an answer to this? My VAR can’t find the easy option either.
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
