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 225,155 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

Community Spotlight of the Month

Kudos to Mohamed Amine Mahmoudi!

Blog subscriptions now enabled!

Follow your favorite blogs

TechTalk: How Dataverse and Microsoft Fabric powers ...

Explore the latest advancements in data export and integration within ...

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 225,155 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,146

Featured topics

Product updates

Dynamics 365 release plans