QuickBooks Inventory Software
Other Resources
QB OH is the quantity on hand within QuickBooks. All Orders will update QB QOH when ship docs, receivers, adjustments and work orders are recorded in QuickBooks.
Quantity Available is the quantity that All Orders computes. Quantity is updated when ship docs, receivers, adjustments and work orders are saved. There may be a time lag between the time when ship docs, receivers, adjustments and work orders are saved and when they are recorded in QuickBooks. This is called a timing difference. You can see the transactions that are causing timing differences between All Orders and QuickBooks by selecting from the main menu: Company ---> Synchronize QuickBooks ---> Reconcile with QuickBooks ---> Inventory Reconciliation Detail.
If you have posted an invoice, customer return, bill, credit memo or Adjustment directly through QuickBooks with out it originating through All Orders you will get a difference that needs to be reconciled. You can view which items are in this state by selecting from the main menu: Company ---> Synchronize QuickBooks ---> Reconcile with QuickBooks ---> Inventory Reconciliation Summary. Any item with a reconcile amount not equal to 0 needs to be reconciled.
There are a couple of ways to reconcile:
1. Go through the transactions in each system. Hint, use the Inventory Valuation Detail in QuickBooks and Inventory Movement Detail in All Orders.
2. Use the reconciliation feature in All Orders by selecting from the main menu: Company ---> Synchronize QuickBooks ---> Reconcile with QuickBooks ---> Reconcile to QuickBooks (if the QuickBooks #s are correct) or Reconcile to All Orders (if the All Orders #s are correct)
Consider the following QuickBooks preferences which will assist.
1. Send all unsent Transaction to QuickBooks will automatically post ship docs, receivers, adjustments and finished work orders.
2. Reconcile quantities on sync. Note, this may increase synchronization time as all your inventory items and assemblies will be analyzed.