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.
Solved
Inventory Stock Status Report
I would suggest that you can create a raw data with GI , then using pivot table to group as column for that.
1 person likes this
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.
1 person likes this
kristianharianja wrote:
Try attached GI.
Hey
Joshua Fialkoff
1 person likes this
Reply
Rich Text Editor, editor1
Editor toolbars
Press ALT 0 for help
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.