How To Run a Materials Spent By Job

An Assembly Item, the same as any inventory item, is not Job Tracked. It's not direct and unique, but Stocked in anticipation of sales to the job or use on the job. So, the function of Inventory = having it on hand and ready.

Then, later, you Sell it, or you use Adjust inventory and in this screen you Job Track that this is relieved from stock directly for a specific job but not being Sold to that job.

The Build Assembly is Not the Job tracked stage. This is the Creation Stage.

For Noninventory two-sided items, you job track them at the time of the purchase. For inventory, which includes Assembly Item on hand, not the Build phase but Now available, that is the Sale or the Adjustment function, that creates the Costing event.

You will see this on the Job Cost reports, as long as you remove the Account filter that is "ordinary income/expense" to see Job Profitability Detail, for instance, include the adjustment in Costs.

Please see my attached Job Cost report.

Hi LilyC!

To answer your question that's a yes & no. 

We create an invoice and assign the invoice to a specific job number. That's pretty common, into Customer > New Customer & Job > Hit New Job or New Customer.  The customer can order 100PCS for Job#123 but wants 50PCS per month along with the invoice, so we send 2 invoices and those 2 invoices will be for job#123.

Adjusted the items out we go into Inventroy Adjustment and for some reason, this gives me the options to write down a specific job number and shows within that job number reports. 

In Build Assembly this does not give me that option, only option it gives me is just to write down the Part# however we have for example 20 different jobs using that Part# that we build and sell. So I had a feeling that that request they asked for is impossible to complete that's why I came here hoping for a solution. 

You are confusing two different Concepts:

Assembly item is an Inventory item. That means the value is in Asset. When you Build it from components on hand, which are in Asset, you didn't Change Anything financially. You changed Stuff into different Stuff. That's why there is no Job Tracking this. This is Inventory = Inventory. I take 4 legs, a Back and a Base and make a Chair.

Later, I sell the chairs. Now this is the Financial transaction that has to do with Customers and Sales and invoices or sales receipts. Or, I quoted that I would completely outfit your Dining room for $xx and you signed the Fixed Rate Contract. So, once I know we have made all the chairs and the table, I would Charge you the Contract fee, and use Adjust, to Relieve from stock the chairs and that table and Job Track that these were not Sold to you as Details, but Removed to fulfill your Contract Bid Fee.

You don't Job Track the Build, because you needed to make the products available First, before you can even have a Sale.

You can Justify the Build, by showing evidence that a Customer Order exists. And think about this: there might be 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, their info, required delivery date, etc.

You are trying to attach two Steps into One, but they exist separately. One is not Changing the financials; Build Assembly is not a Customer Activity. It is an Operational Activity to provide what is needed for Customers, as the Fulfillment step, which is Later.

And I showed Job Reporting will include the cost from the Build; because that is the Basis on Hands of the item Built, and then Sold to the customer. It doesn't matter if you sold it or adjusted it to relieve it from stock; that Movement carries Basis or Cost with it. That is reportable, because the Sale or the Adjustment is where you Job Tracked it.

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.

Hello there, @JeanPyer.

I appreciate you responding in this thread and adding more details.

As mentioned by LilyC, your request to run a report for each Specific Job Number with the material used to build it is currently unavailable. However, I have personally forwarded your feedback to our Product Development team. There are many other customers, just like you, who would benefit from this idea.

Your feedback helps us decide which features to implement into the product. I suggest you send your feedback too:

1. Click the Help menu bar.
2. Scroll down to Send Feedback Online.
3. Select Product Suggestion.
4. Choose Product Suggestion for the Type of Feedback.
5. Product Area is optional.
6. Enter your suggestion.
7. Click Send Feedback.

Of course, you can always drop by here in the Community for any questions you need help with. Have a good one.

In case anyone is here from QBO (happens to the best of us), then I'd recommend you actually find yourself a dedicated manufacturing app like Katana to help with tracking your assemblies.

Basically means you can track product recipes, manufacturing costs, inventory and production in a specialized platform, and then push invoices/bills to your QBO account.