web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Suggested Answer

Can someone guide me a Souce of data for trial balance in a system?

(0) ShareShare
ReportReport
Posted on by 282
Dear All,
 
I would like to ask questions about Trail balance based on standard function. Recently I just have a case with digits in a system (2-3 decimals). For this case is long story to me and now when I consult with audit. I and my team need to review all of GL Transaction in that period.
 
For all transaction list for now is balanced between Credit and Debit.
 
But when I run a trial balance report with this code it Show Closing balance 0.01. I want to know about the source of data or when I call this report do I miss something?
 
 
The step That I try to debug by myself but with my knowledge limitation I can't continue.
 
1.when I check a source form: LedgerTrialBalanceListPage
2. Datasouce:LedgerTrialBalanceTmp
3.Report output are from a button that user click(track to click action)
4.When I check this action it call “runUpdateBalanceInNewSession”
5.I found only the parameter that call for temp table(this is the last step that I can do?)
 
I have the same question (0)
  • Frank Hamelly | MVP, MCP, CSA Profile Picture
    46,631 Moderator on at
    The Penny difference account is used to record rounding differences in transactions.  Are there any multicurrency transactions in your system?
  • Chomchanok Profile Picture
    282 on at
    Recently I got a request form my users to change a currency digit from 2 digits to be 3 digits but with some impact from this request we need to change back to be 2 digits. (On this period take time 3-4 days to operate)
     
    All new transaction we cancel and reprocess again but for some transaction are flow in system already that i need to fix it.
    For Ledger Transactions now is ok
    For trial balance when we call a report we found that we got some diff 0.00x in a system and I want to tracking a table who keep this record and fix to meet my audit requirements.
     
    In addition now I think a table for balancesheet report is "DimensionFocusBalance" but when i track in details it really difficult to check a root records.
  • Suggested answer
    Frank Hamelly | MVP, MCP, CSA Profile Picture
    46,631 Moderator on at
    I see.  So the rounding difference appears to be the result of a customization?  You might need to submit a Microsoft support ticket for assistance on this one.

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Giorgio Bonacorsi Profile Picture

Giorgio Bonacorsi 689

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 478 Super User 2026 Season 1

#3
Syed Haris Shah Profile Picture

Syed Haris Shah 258 Super User 2026 Season 1

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans