Community Forum Portal/Portail du forum communautaire
The Inventory Adjustment account balances are not equal to the summary report (or the financial reports).
e.g. when I open the inventory report summary the amount for Canola will be $1000 but when I open the inventory adjustment window.... I've set the amount to $0 and the quantity to 0 and the total value is 0. ...... but the report still reads $1000.
I tried adjusting it through the general journal and playing around with unit/ quantity amounts but every approach I made has always adjusted both the inventory adjustment sub ledger and the General (Reports) ledger.. and ideas how to adjust the inventory without it posting to the reports or posting to the reports without it adjusting the inventory feature?
Hi Bazz,
You cannot adjust inventory without it showing on the reports. Where you're running into trouble is that the report your generating is as of a specific date, whereas the inventory adjustment window is always live (balance includes all transactions entered on the database, not just transactions as of a specific date). If you want to see the two numbers agree then you'll need to generate the inventory report as of the last date that exists on your database so that all transactions are included on the report. If you need assistance adjusting some historical numbers, just give us a quick call.