Running Balance

(0) Share

Report

Posted on by Maro9595

107

Hi all,

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

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

Thank you Indeed

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (5)

Answers (1)

Sort by

Suggested answer

Pushparaj P 205 on at

Like (1)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Maro9595 107 on at

Like (0)

Report
Copy link

Link copied!

Thank you Pushparaj,

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

Was this reply helpful? Yes No
Suggested answer

Dallefeld 233 User Group Leader on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Suggested answer

Amit 2,563 on at

Like (0)

Report
Copy link

Link copied!

OpeningBalance

RunningBalance := OpeningBalance + DrAmount - CrAmount

Regards

Amit Sharma

www.erpconsultors.com

Was this reply helpful? Yes No
Verified answer

YUN ZHU 100,473 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

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

Hope this helps

Thanks.

ZHU

Was this reply helpful? Yes No