Hi qbteachmt,

I know what you're saying and I am aware of that. I am also aware that in the report the Job# will tell me the cost of materials or inventory however way you wanna put it, I have also done that report. 

How you are suggesting it that's too much to work unless you can make it smaller. We have over 300 jobs,  you are saying  "5 customers needing 100 each of that Product. That's why the Build is for 500; the Sales Order shows each of the 5 customers" that's easy math solving, however, we have over 300 jobs, each job uses different or the same materials.

Like my question (thanking LilyC for Answering) my bosses wanted a report for each Specific Job Number, and how many pieces of materials we used to build it.