Skip to main content

Notifications

Announcements

No record found.

Small and medium business | Business Central, N...
Answered

GL Summary Trial Balance

(0) ShareShare
ReportReport
Posted on by 295

Hi,

Can i know if there is any table in BC that keeps the GL account summary period balances with fields such as GL Account, Period Year, Period Month and Period Balance (Net Change) similar to Dynamics GP Table GL10110 (open) and GL10111 (History)?

We are required to push monthly Trial Balance from Dynamics BC to a 3rd party Consolidation system and wondering where we can pick up the data to push to them.

Appreciate advise.

Thanks

May, Tang

  • Suggested answer
    Dallefeld Profile Picture
    Dallefeld 11,425 User Group Leader on at
    RE: GL Summary Trial Balance

    There is no such table, the data for GL balances comes from the GL Entries table. You could filter the Chart of Accounts Page for the month desired, Open in Excel, take the Net Change column which would give you a sum of the activity by account for the period and use that for your push.

    You could also use a Financial Report to do the same thing.

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,391 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,445 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans