Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Unanswered

Mismatch Trial Balance fields vs Voucher transactions - Wrong Closing Balance and Credit balance

(0) ShareShare
ReportReport
Posted on by 14
Dear all.

In AX2012 I have an issue about wrong Trial Balance sum up field value.
This is the scenario:
  • I re-opened the settlement period;
  • I created a new Invoice to re-opened period – OK

Now, there is a mismatch Trial Balance Credit and Closing Balance fields VS the real transactions.

Checking the Voucher details amount, I have a different import.
The Trial Balance form show me: -11.589,16 ,
the sum about Voucher transactions is 1.324,18 (this is correct).


I performed the “Rebuild balance” and “Update balance”, but not solved.
I tried to close the period but the amounts Closing Balance doubles
 
  • Exist any function to set or reset the Credit and Closing Balance fields?
  • Or how can I fix this field calculation? 
By my humble opinion it seems the temporary table fields.
I think I need to construct the base data.
 
The fileds 
LedgerTrialBalanceTmp.EndingBalance
LedgerTrialBalanceTmp.AmountCredit 
show wrong values.

Thanks in advance.
 
 
 
I already executued these functions, but without success
 

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Tip: Become a User Group leader!

Join the ranks of valued community UG leaders

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,489 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,305 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans