Skip to main content

Notifications

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

Beginning Balance Table

(0) ShareShare
ReportReport
Posted on by 3,484

Hi:

In the Chart of Accounts table, I see the following tables:

Balance at Date, Net Change, and Balance.

I notice that Balance at Date and Balance have the same data.  This appears to be true for Net Change.  At least, that's what it looks like.

Also, the GL Entries table contains the Debit and Credit fields.

I'm going to want to derive the following columns in a reporting app, such as Power BI:

Beginning Balance, Debit, Credit, Net Change, Ending Balance.

I can calculate Net Change, based on the Debit and Credit fields.  And, it should be relatively easy to calculate Ending Balance.

With that in mind, from which table do you derive Beginning Balance?

Thanks!

John

  • Suggested answer
    Inge M. Bruvik Profile Picture
    Inge M. Bruvik 995 Super User 2024 Season 1 on at
    RE: Beginning Balance Table

    I wrote a blog post a while ago about those fields. Maybe you will find some useful information there.

    bc365.co/.../

  • Suggested answer
    Amit Baru Profile Picture
    Amit Baru 3,027 on at
    RE: Beginning Balance Table

    Hi,

    Take data form G/L entry table. And for filter pls check the Flowfield property. In that property you will get the filters logic.

    Regards

    Amit Sharma

  • Suggested answer
    Dallefeld Profile Picture
    Dallefeld 171 User Group Leader on at
    RE: Beginning Balance Table

    John until you apply date filters they will all have the same dial because they are look ups or flow fields into other tables you can apply filters to them and then the numbers will change To get the information that you want For your report you’re going to need to apply date filters and filters for a greater than zero or less than zero for debits and credits.

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

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,979 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 230,848 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans