web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Small and medium business | Business Central, N... How to Get the custome...

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

Answered

How to Get the custome balance total based ont he customer no In RDLC REPORT

(0) Share

Report

Report

Posted on by Community Member

I have a custom report copy of the standard rdlc report customer balance to date -121

When I run the report with filter with customer no it shows the total correctly , When I run the report without any filter for every customers how can i get the customer total based on their Customer Number

Categories:

Dynamics 365 Business Central

All responses Img

All responses (2)

Answers Img

Answers (0)

Sort by

Suggested answer

IB-29041624-0 1,191 Moderator on at

Like (0)

Report
Copy link

Link copied!

You have to look at the date filters you set in your report.

Find this line in the code

SetRange("Date Filter", 0D, MaxDate);

And change it to

SetRange("Date Filter", 0D, today());

That should solve your problem. Then the report will always calc the balance to the current date.

You can also create a new simpler report.
Community Member on at

Like (1)

Report
Copy link

Link copied!

Thank you it helped

Join the conversation

Helpful resources

Quick Links

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1

OussamaSabbouh 743 Super User 2026 Season 2

#2

YUN ZHU 546 Super User 2026 Season 2

#3

AndrewThomas81 332 Super User 2026 Season 2

Last 30 days Overall leaderboard

Featured topics

Microsoft Training Manuals

Product updates

Dynamics 365 release plans