Question
We created invoice for this item, then deleted it . After that, we recreated the invoice with a different quantity, item balance became negative in the inventory report.
I hope you are doing well.
We are facing an issue in QuickBooks Online related to the Inventory Valuation Detail report and the inventory quantity balance for one inventory item.
The item name is:
Tide Pink Bag 5 KG
We created a sales invoice for this item, then deleted it because the quantity was incorrect. After that, we recreated the invoice with a different quantity, but we had to delete it again due to another mistake. This process was repeated several times.
After deleting the invoices, we noticed that the inventory quantity was not restored correctly. The quantity continued to decrease, and the item balance eventually became negative in the inventory report.
In the Inventory Valuation Detail report, the same item appears multiple times under invoice transactions, even though it should reflect only the correct final transaction. It seems that the deleted or repeated invoice transactions may still be affecting the inventory quantity or valuation.
Could you please help us investigate and advise how to correct this issue?
We would appreciate your support with the following:
Confirm whether deleted invoices can still affect the Inventory Valuation Detail report or inventory quantity.
Advise how to identify and remove any duplicated or incorrect inventory movements.
Explain the correct way to restore the inventory quantity and valuation for this item.
Confirm whether an inventory adjustment is required, or if the issue should be corrected from the original invoice transactions.
Attached is a screenshot of the Inventory Valuation Detail report showing the issue.
Thank you for your support.