Connect with and learn from others in the QuickBooks Community.
Goal: Run a report that totals quantity used by customer job (Inventory Adjustments)
I run the inventory adjustment report and can total by job, but the total is only based on cost, and not the "Qty" column. Is there a way to add this?
Good day, bbutler1.
Let me show you a way to get the inventory used by the job.
The best way to get the total quantity of the items is by exporting the report into an Excel file. From there, we can make it more presentable and to get the data we need.
Simply click the Excel drop-down and select Create New Worksheet.
I've also added this article for more details: Customize reports in QuickBooks Desktop.
Let me know if you need anything else. Stay safe!