Category: Inventory

Another Way to Deal with Scrap in QuickBooks Manufacturing

| November 15, 2010 | 5 Comments

In his blog post “Dealing with Scrap in QuickBooks Manufacturing,” Charlie Russell offered five creative solutions to the problem of leftover parts and materials after a manufacturing project is complete. When manufacturers create a product from a bill of materials, they often find they didn’t need to use as much material as they had expected. […]

Continue Reading

QuickBooks 2011 – Improved Inventory Adjustments

| September 13, 2010 | 14 Comments

This is an improvement that is long overdue. The Adjust Quantity/Value on Hand has been one of the poorest functions in QuickBooks for years, and with this release they have made a dramatic improvement in usability.

Continue Reading

QuickBooks 2011: Advanced Inventory

| September 10, 2010 | 75 Comments

The Enterprise Edition of QuickBooks 2011 adds a new optional feature: Advanced Inventory. This allows you to manage multiple inventory locations without having to use an add-on product that stores data outside of your QuickBooks company file.

Continue Reading

QuickBooks Inventory Analysis with EZ Analytics

| May 25, 2010 | 3 Comments

Intuit has been promoting a new class of add-on applications that work with your QuickBooks desktop application, but are accessed via the web. In this article I’ll review one of these applications, EZ Analytics for Inventory, an excellent inventory planning and management tool that will work with your QuickBooks data.

Continue Reading

FAQ:I Can’t Add Inventory or Create Purchase Orders in QuickBooks

| May 21, 2010 | 0 Comments

If you cannot create an inventory part in your item list, and you don’t see purchase orders in the “home page”, most likely you have not enabled the inventory preference. Select Edit then Preferences and click on “Items & Inventory”. In the Company Preferences tab, make sure Inventory and purchase orders are active is checked.

Continue Reading

FAQ:Why Did QuickBooks Change My Builds To “Pending”?

| May 21, 2010 | 11 Comments

QuickBooks inventory is date sensitive. In addition, the build transaction requires that you have enough component parts on hand to issue the build.

Continue Reading

Understanding QuickBooks Total Bill of Materials Cost

| March 18, 2010 | 14 Comments

In a prior article I talked about the cost and avg cost fields in the item list. In this article I’ll talk about a related value, the Total Bill of Materials Cost which you will see listed at the end of a QuickBooks bill of material.

Continue Reading

Managing Service Truck Inventory in QuickBooks

| March 8, 2010 | 6 Comments

QuickBooks by itself does not support multiple locations. To do this properly you need to purchase an add-on program of some sort, which often will keep the inventory in a separate file. There are some simple workarounds that can be used, though. In this article I’ll explain one way that might work if you are […]

Continue Reading

Dealing with Scrap in QuickBooks Manufacturing

| February 9, 2010 | 6 Comments

Many manufacturers have to deal with scrap in their manufacturing process. That is, the consumption of component materials beyond what is defined in the bill of materials due to waste, trimmings, left over sections or other variable consumptions. QuickBooks doesn’t deal with this directly. Let’s talk about some ways to handle it.

Continue Reading

Printing a QuickBooks Inventory Adjustment Report

| December 7, 2009 | 16 Comments

Sometimes you want to be able to see a listing of all of the inventory adjustments made over a period of time. This may be helpful when trying to audit your inventory usage. The steps for getting this kind of information out of QuickBooks aren’t all that obvious, so I’ll give you some tips here.

Continue Reading