RE: Inventory Reports Don’t match
When we compare the inventory valuation and the inventory by location, the total dollars tie, but the qty doesn’t. I have checked all the filters, and nothing is jumping out. There are no unposted transactions that I can see. There is no commonality between the SKUs that have qty variances.
The inventory valuation report is reporting on transactions where the GL impact is affecting your Inventory Asset accounts
Inventory by location is reporting on transactions containing items on lines and the qty in or out of those items
This discrepancy is normally from either journals or vendor bills posted directly against the inventory asset accounts without an item record assigned. This is commonly done when adding historical balances to NetSuite prior to go live
Create a saved search with criteria of posting = TRUE, account = [your inventory asset accounts], and item = None. This should be your variance
