Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Answered

Running Balance

(0) ShareShare
ReportReport
Posted on by 105

Hi all,

In Latest BC, there is additional column for Running Balances in Bank Account Ledger Entry

pastedimage1668247982380v1.png

Can anyone please guide me, I want to archive the same concept for Vendor/customer ledger entry as well

Thank you Indeed

  • Verified answer
    YUN ZHU Profile Picture
    81,584 Super User 2025 Season 1 on at
    RE: Running Balance

    Hi, You can refer to the standard logic below to add custom fields to the Vendor/customer ledger entry.

    pastedimage1668386285237v1.png

    pastedimage1668386324965v2.png

    pastedimage1668386347309v3.png

    Hope this helps

    Thanks.

    ZHU

  • Suggested answer
    Amit_Sharma Profile Picture
    2,545 on at
    RE: Running Balance

    OpeningBalance

    RunningBalance := OpeningBalance + DrAmount - CrAmount

    Regards

    Amit Sharma

    www.erpconsultors.com

  • Suggested answer
    Dallefeld Profile Picture
    175 User Group Leader on at
    RE: Running Balance

    You face a challenge in the customer ledger but using the remaining amount field you can create the column, just know that the running balance you create is point in time (at the moment you open the screen/page) you cannot make it date filterable without some significant code. You can apply a date filter to the customer card and see the balance change and that balance is drillable.

  • Maro9595 Profile Picture
    105 on at
    RE: Running Balance

    Thank you Pushparaj,

    So in Customer ledger entry we can do some modifications to show something like that right?

  • Suggested answer
    Pushparaj P Profile Picture
    205 on at
    RE: Running Balance

    Hi,

    The Running Balance Field Is For The Consolidated Total.

    In the Below Image You Can See that It Summing Up All The Debit Amount And Giving You The Total And

    If The Ledger Entry Got Any Value On Credit Amount Field, Then It Will Subtract It.

    pastedimage1668256827023v1.png

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,165 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 232,968 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,158 Moderator

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans