The adjustment qty of Product D doesn’t show the correct number (the actual adjustment qty should only -1.8) .
The closing balance shows the correct number
I’m moving this to the bugs category but only because this report doesn’t allow to drill-down. When drilling-down is implemented you can review how the figure was calculated and it will be easier to figure out what’s wrong.
Please keep as it was; Add back the adjustments column and put the credit/debit notes and inventory write-off in adjustments. Credit/debit notes are refunds and should be reported separate from actual purchases/sales.
Previously transactions from credit notes, debit notes and inventory write-offs went to adjustments (gain/loss).
Now I see from the drill-down, debit notes are in purchases.
The report automatically shows only columns which are actually used. If you have no journal entries interacting with inventory items, the column won’t show.