You are here:

Quicken & Other Budget/Accounting Software/Stock Production & Consumption Report in Quickbook Enterprise 2013

Advertisement


Question
Hi QB Expert Linda Saltz

I am using QB 2013 Ent. with manufacturing & advanced inventory management features. I Assembled a Assembly item i.e "20/1 CVC Yarn" with different inventory items like, " Comber Noil, Roving...etc".
Now i want to see reports:
1. Total Yarn Produced in Period e.g. a Month
2. Total Material Used in Producing that above Assembly item ( Qty & Value).
3. Net Yield for manufacturing the above item.

I have searched the entire QB reports but can't find the solution.

kindly give your expert advice to resolve the query.

Best Regards

Answer
Hi Bisharat,

You will need to export a report to excel and I recommend using the pivot table in excel
to get your reports

Start with the report menu > custom reports > detail report
Customize that report
filter for transaction type = build assembly
On the display tab add the columns for item, item description, quantity
Memorize this report for easy access next time.
Change the date range to the month you want to report on, then export to excel.
Remove blank columns and rows, then create a pivot table on that data

Linda Saltz, CPA
Advanced Certified QuickBooks Advisor
www.qbalance.com

We sell and support QuickBooks Enterprise
http://www.qbalance.com/enterprise_quickbooks.htm  

Quicken & Other Budget/Accounting Software

All Answers


Answers by Expert:


Ask Experts

Volunteer


Linda Saltz, CPA, QBalance.com

Expertise

QuickBooks best practices, troubleshooting, accounting, tax We have over 70 pages of website content about QuickBooks tips, running a business, tax and business startup at http://www.qbalance.com

Experience

Accountant and CPA over 20 years. Specializing in accounting software for over 12 years, Certified QuickBooks Pro Advisor, QuickBooks seminar instructor since 1997.
Producer of www.QBalance.com over 100 pages devoted to QuickBooks help and support and training for small business owners in tax and accounting issues.

©2016 About.com. All rights reserved.