2My Finance department are showing a Closing balance of $x, however, I cannot seem to be able to get the totals to balance exactly using inventsum or inventtrans export tables.
This is what I was expecting to use: sum(postedvalue) - sum(physicalvalue) = inventoryvalue from inventsum.
But we are still out by $5000 or so.
Am I missing something fundamental here please? I would have expected to be able to recreate those values in inventsum from inventtrans but even then I cannot get sum of costamountadjustment + sum of costamountposted to balance to the above calculation from inventsum.
Maybe someone is able to explain how the trial balance for that Department/Brand/Name combination can be validated against the inventsum table please?
Thankyou
