@User_1234 wrote:
Hello,
I'm trying to run a report that tells me the total usage of an Inventory Part. I have several Inventory Parts that are only used in Build Assemblies, so I know you can run a report that shows total sales of those build assemblies but, I want to know individually how much of one of those parts I used in an entire year.
So for example I use widget A in 4 different Build assemblies, what was the total amount of Widget A used for all those builds.
*Side note: I know the Inventory Valuation Report shows how much is used in each build, but I want something that can show me totals, not adding and subtracting based on builds and items received. Thanks!
There might be more that one way to get this information, however, the way I get it is to go to the item list and search for the item you are interested in. "Right click" the item to bring up the menu and select "quick report". This will pull up all transactions for that item. Filter the report for transaction type = builds and that should give you what you need. Select the date range you are interested in (eg. last fiscal year).
