Inventory Discrepancies

Modified on Sun, 26 Jul at 1:14 AM

Overview

QQube inventory quantity and valuation logic has been refined across many QuickBooks company files. Because the Intuit Software Development Kit does not provide direct access to all underlying inventory tables, QQube must reconstruct inventory results from the transaction data that Intuit makes available.

In some cases, QQube inventory results may not match a QuickBooks report. The difference is usually caused by synchronization problems, filter mismatches, QuickBooks configuration, legacy data conditions, or differences in valuation methodology.

Start with synchronization integrity

Always review the QQube synchronization logs first. A later successful synchronization does not repair an earlier interrupted or failed synchronization.

When reports were previously accurate and then become inconsistent, a complete Run All / Clear All reload is frequently required.

Inventory Reconciliation Checklist

Possible Cause	What to Check	Required Action
1. Synchronization issues	Review the synchronization logs for errors, crashes, aborted synchronizations, or other interruptions.	Resolve every synchronization error. When data may be incomplete, perform a complete Run All / Clear All reload.
2. Mismatched report filters	Confirm that the QuickBooks and QQube reports use the same active-status, posting-status, date, item, site, and other filters.	Use matching filters in both reports before comparing quantities or valuation.
3. Enhanced Inventory Receiving	Determine whether Enhanced Inventory Receiving is enabled in QuickBooks.	Filter out records where Document Transaction Type = Bill. With Enhanced Inventory Receiving, inventory is accrued through item receipts.
4. Legacy quantity and amount combinations	Older QuickBooks files may contain transactions with a blank or zero quantity and a nonzero amount, or other combinations no longer permitted by newer releases.	Inspect the underlying QuickBooks transactions and correct invalid quantity or amount combinations where appropriate.
5. Different valuation methods	QQube derives valuation from the actual posting amounts associated with inventory transactions. QuickBooks may calculate a report using current quantity multiplied by current average cost.	Confirm that the reports being compared use equivalent valuation assumptions. Differences from legacy quantity conditions can also affect the result.
6. Valuation by site	The Intuit SDK does not expose item-level average-cost tables by site. QQube therefore uses actual posting amounts by transaction.	Expect quantity by site to reconcile. Valuation by site may differ from QuickBooks by a small rounding amount.
7. Serial-number mismatch	For serialized items, compare the transaction quantity with the number of serial numbers assigned.	Maintain a one-to-one relationship between each inventory unit and its serial number.

Detailed Resolution

1. Review the Synchronization Logs

Synchronization errors must be resolved before inventory results can be evaluated. A successful synchronization after an earlier error does not mean the earlier problem corrected itself.

When inventory reports were accurate for an extended period and then become inconsistent, perform a complete clear and reload after resolving any log errors.

QQube synchronization log

2. Match the QuickBooks and QQube Filters

The two most common filter differences are:

Active and inactive items. An item should not be made inactive while it still has a positive or negative quantity. Make the required inventory adjustment before changing its status.
Posting status. In QQube, filter Document Current Posting State to Posted. Including Pending transactions can change the comparison.

3. Account for Enhanced Inventory Receiving

When Enhanced Inventory Receiving is enabled, filter out:

Document Transaction Type = Bill

The inventory activity is recorded through the item receipt. Including the related bill can overstate the inventory result.

4. Review Legacy QuickBooks Transactions

Very old QuickBooks company files may contain transaction combinations that newer QuickBooks releases no longer allow. For example, a transaction may contain a zero or blank quantity with a nonzero amount.

QQube extracts the values stored in QuickBooks. When the stored quantity and amount are inconsistent, the resulting quantity or valuation may also appear inconsistent.

5. Understand the Valuation Difference

QQube derives valuation from the actual posting amounts for each inventory transaction.
QuickBooks may derive a report value from current quantity multiplied by current average cost.

The Intuit SDK does not expose the underlying item tables needed to retrieve all specific average-cost values directly. QQube therefore uses the transaction posting amounts available through the SDK.

6. Understand Valuation by Site

Quantity by inventory site should reconcile when the source transactions and filters are correct.

Valuation by site may differ from QuickBooks by a small rounding amount because QQube uses actual posting amounts by transaction rather than an average-cost table by site.

7. Verify Serial Numbers

Serialized inventory should maintain a one-to-one relationship between quantity and serial numbers. A mismatch can produce an incorrect quantity-on-hand result because of how Intuit exposes serial-number data to third-party applications.

QuickBooks serialized inventory quantity and serial-number example

Expected Result

After synchronization errors are resolved, the QQube data is reloaded when necessary, and equivalent filters are applied, inventory quantity and total valuation should reconcile with the corresponding QuickBooks report.

Small valuation-by-site rounding differences may remain because QQube and QuickBooks use different calculation methods for that specific comparison.