I am trying to pull a report that shows me how much of each item under an item class cost and was used for a certain time frame. Can we do that in acumatica?
Question
Item class transaction history
Hi
As per my understanding, do you want to check item cost related for the respective item class. If that’s correct you can simply apply group by condition as item class in the Acumatica report to get the list of items that respects.
I want to see how much we spent and how many used total for everything in that class but also want it broken down into each inventory ID.
Hi
You can pull the information from INTran and link InventoryItem table to get Item class information. One can build a Generic inquiry or report for the same.
Here is the output from a GI I prepared. You can alter or modify it further ( or can build a new one).
Regards,
Login to the community
No account yet? Create an account
Social Login
Login with your Acumatica accountEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.