Skip to main content

Notifications

Dynamics 365 Community / Forums / Finance forum / Trial Balance to equal...
Finance forum
Unanswered

Trial Balance to equal inventsum/inventtrans tables

Posted on by
My 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
  • JacobRoder Profile Picture
    JacobRoder 1,268 on at
    Trial Balance to equal inventsum/inventtrans tables
    are all the item model groups using the "include physical value"?  are there any manual postings into the trial balance accounts that weren't driven from the subledger?
  • Martin Dráb Profile Picture
    Martin Dráb 224,463 Super User on at
    Trial Balance to equal inventsum/inventtrans tables
    Moved from D365 general forum to D365 Finance forum, because it seems to be about F&O and not about D365 in general. Please let me know if you disagree.

Helpful resources

Quick Links

Can you answer this forum question?

You could make someone's day!

Community Newsletter - May 2024

Kudos to our community stars!

Community Spotlight of the Month

Kudos to Mohamed Amine Mahmoudi!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 283,623 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 224,463 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,146

Featured topics

Product updates

Dynamics 365 release plans