160
Hi All,
In my understanding, inventory valuation report and GL balance by dimension will have different values because un-invoiced purchase and sales orders with items that have been received or shipped will appear in the Inventory Valuation report but will not be posted to the general ledger.
Any reply will be appreciated.
*This post is locked for comments
Hi Angelito,
there could be several reasons. In the order from "most probably" to "exotic":
1. You don't post expected cost to the G/L. This would be in the inventory setup, "Expected Cost". In this case Alexander's assumption is the same.
2. You don't have "Automatic Cost posting" enabled, and some value entries are not yet posted to the G/L.
3. "Adjust Cost - Item Entries" hasn't been run before posting to the G/L.
4. You report a value to date, but you have applications over this date border (and on the wrong side). Meaning for example, the shipment has been posted with your date range, but not the invoice (and vice versa).
5. Real bugs, like broken item ledger applications (it happens).
And one last question: Is Valuation posted to G/L + Amount Received not Invoiced + Amount Shipped not Invoiced the same as Inventory Value? If yes, then all is fine. Or a bug would be even more exotic.
with best regards
Jens
There is Cost posted to GL field in the report - does this differs from GL Balance?
They might give you different values, as the real cost of the item might not be yet invoiced, and there would be no cost, posted to GL. There might be still expected cost when you receive the items.
#1
André Arnaud de Cal...
293,207
Super User 2025 Season 1
#2
Martin Dráb
231,923
Most Valuable Professional
#3
nmaenpaa
101,156
Moderator
Share
Report
All responses (
Answers (
