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

Notifications

Announcements

No record found.

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 276
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 Super User 2025 Season 2 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
    276 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 Super User 2025 Season 2 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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

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

#1
Martin Dráb Profile Picture

Martin Dráb 544 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 450 Super User 2025 Season 2

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 250 User Group Leader

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans