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 253
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?)
 
  • Suggested answer
    Frank Hamelly | MVP, MCP, CSA Profile Picture
    46,487 Super User 2025 Season 1 on at
    Can someone guide me a Souce of data for trial balance in a system?
    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.
  • Chomchanok Profile Picture
    253 on at
    Can someone guide me a Souce of data for trial balance in a system?
    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.
  • Frank Hamelly | MVP, MCP, CSA Profile Picture
    46,487 Super User 2025 Season 1 on at
    Can someone guide me a Souce of data for trial balance in a system?
    The Penny difference account is used to record rounding differences in transactions.  Are there any multicurrency transactions in your system?

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

🌸 Community Spring Festival 2025 Challenge 🌸

WIN Power Platform Community Conference 2025 tickets!

Jonas ”Jones” Melgaard – Community Spotlight

We are honored to recognize Jonas "Jones" Melgaard as our April 2025…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 294,137 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 232,879 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,158 Moderator

Leaderboard

Product updates

Dynamics 365 release plans