Limited time only. 50% off QuickBooks for 6 months.
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
NickACNB
Level 1

Discrepancy between the inventory quantity displayed in the QuickBooks Online interface and the data returned via the API and Inventory Valuation Detail report.

We are observing a discrepancy between the inventory quantity displayed in the QuickBooks Online interface (UI) and the data returned via the API and Inventory Valuation Detail report for an inventory-type item. Using the query: SELECT * FROM Item WHERE Name = 'U1563' We receive: "QtyOnHand": 1 "TrackQtyOnHand": true "InvStartDate": "2025-07-18" "LastUpdatedTime": "2025-07-18T05:11:50-07:00" Fetched via the Reports API (covering dates from 2025-07-01 to 2025-07-29), we confirm: - A Bill was recorded on 2025-07-18 with Quantity = 1 - No inventory adjustments or sales occurred afterward - The report shows a total quantity of 1.00 and a value of 149,000.00 When viewing the item in Sales > Products and Services > U1563, the UI displays: - Quantity on hand = 0 - Status: Out of stock Steps Already Taken - Confirmed that the bill was correctly recorded using the "Item details" section, referencing U1563 - Verified there are no duplicate items with the same name but different IDs - Extended the Inventory Valuation Detail report up to today – no movement after the initial Bill - Cleared browser cache and tested in multiple browsers - Manually re-saved the item to force UI refresh – no change - Compared QtyOnHand API value vs UI value: they are not in sync We are looking at - Confirm whether this is expected behavior or a sync issue between the inventory engine, UI, and API metadata? - How to force a manual inventory recalculation is required?

1 Comment 1
Carneil_C
QuickBooks Team

Discrepancy between the inventory quantity displayed in the QuickBooks Online interface and the data returned via the API and Inventory Valuation Detail report.

We can enter an inventory adjustment if this is a sync issue within the QuickBooks Online (QBO), NickACNB.

 

There are times when QBO experiences internal sync issues where the displayed quantity doesn't accurately reflect the correct quantity. To get around this, here's how to adjust the item's quantity:

 

  1. Click + New and select Inventory qty adjustment.
  2. Enter the Adjustment date.
  3. In the Inventory adjustment account dropdown, select the appropriate account.
  4. For each item, enter either a new quantity or a change in quantity.
  5. In the Memo field, enter the details about the adjustment.
  6. Tick Save and close

 

On the other hand, if this is within the API sync issue, you can go to the Intuit Developer forum, where experts handle integrations, such as APIs, developments, and other related concerns. I suggest posting your situation on their platform, as they are the best gurus to help you with your concerns. You can also go to this link to find more discussions about this.

 

Feel free to update us in the thread if you have additional questions about managing your inventories. We're always here to lend a hand, NickACNB.

Need to get in touch?

Contact us