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,625 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,625 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!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

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

#1
André Arnaud de Calavon Profile Picture

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

#2
Giorgio Bonacorsi Profile Picture

Giorgio Bonacorsi 408

#3
Adis Profile Picture

Adis 267 Super User 2026 Season 1

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans