cancel
Showing results for 
Search instead for 
Did you mean: 
bbutler1
Level 3

Inventory Use by Job Totals

Hi,

 

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?

 

Thanks,
B

 

1 Comment 1
AlexV
QuickBooks Team

Inventory Use by Job Totals

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.

Capture.PNG

I've also added this article for more details: Customize reports in QuickBooks Desktop.

 

Let me know if you need anything else. Stay safe!

Need to get in touch?

Contact us
Sign in for the best experience
Ask questions, get answers, and join our large community of QuickBooks users.
Sign In / Sign Up