Hi Guys/Girls!

So I have a big issue, so I have to run a report, however, someone wants it very specific. He wants me to run a Materials Spent by Job# however he wants a report viewing the total Amount of item we used from a certain Period.

For Example: 

Job#111     Open: 01/01/2019   Closed: 01/05/2019 

Part# BEB1122           Items Used to Build: ABC, 1pcs & DEF, 2pcs

Let's say we send 1 Part# every day to our customer. so 5 days 5 pieces.

So he wants the report to show like this from the Date it was open to the day it was closed.

Job:          Part#               Items          Per Piece          Total QTY

111        BEB1122           ABC                  1                           5 

                                           DEF                  2                          10

I do Build The Part# under Build Assembly, however, It only tells me to write the Part# which we are building, give it an assembly number, and write down the QTY we are building and assign it out. After that, it will automatically take out the items within our inventory, but it doesn't keep track for a specific job number. I do notice I can adjust the items out and assign it to a specific Job#, am  I suppose to do that? It does record it for a specific job#.