Question

How To Run a Materials Spent By Job

Forum|Forum|7 years ago
January 9, 2019
7 replies
55 views

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#.

QuickBooks Accountant Desktop

A

Anonymous

Good day, @JeanPyer.

Thank you for posting again in the Community. I appreciate you telling us about the details of the report you need to run. I'm here to help share some information about running this specific report.

In QuickBooks Desktop, we can run a Build Assembly Transaction Detail Report, however, we can't track the specific job number. Please see attached screenshot below.

For more information about the different reports that cater your business, you can check out this helpful article: https://quickbooks.intuit.com/community/Reports-and-accounting/Understand-reports/m-p/202665.

It would be a great add to our features if we have this particular report in QuickBooks Desktop. I'd recommend sending this as a suggestion to our Product Developers. Just go to Help menu, then select Send Feedback Online and click Product Suggestion.

When you mean adjust the items, did you create an invoice for that separate item and assign it to a specific job? If so, I'd suggest contacting our Desktop Care Support to further check if we can do that. This may depend on the type of business you have. Our support can access your account in a secure environment and verify if you can use that as an option to pull up the specific report you want.

Here's how to get their contact information:

Go to: https://help.quickbooks.intuit.com/en_US/contact.
Choose your QuickBooks Product.
Select your QuickBooks Version.
On the Contact Us page, click a topic.
Click on the Get Phone Number button to see the support number.

Keep me posted how it goes. I'll be here to help if you have other questions.

qbteachmt

Level 11

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.

R

roy241

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.

Sign up

Login with SSO

Let's get you signed in

Login with SSO