Skip to main content

Get 50% OFF QuickBooks for 3 months*

Buy now
Switch to QuickBooks and 70% off for 3 Months
Talk to Sales: 877-683-3280
Hours
Mon - Fri, 5am - 6pm PST
Sat - Sun, 7am - 4pm PST
Product support & help
Need help signing in?
N
NickACNB
July 30, 2025
Question

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

  • July 30, 2025
  • 1 reply
  • 2 views

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 reply

C
Carneil_C
Level 6
July 30, 2025

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 QuickBooks guidance?
Log in to access expert advice and community support instantly.
Terms & ConditionsAccessibility statement