News and Announcements icon

Dynamics 365 CommunityForums Small and medium business | Business Central, N... Change existing report...

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

Unanswered

Change existing report 106 "Customer Detailed Aging"

(1) Share

Report

Report

Posted on by Paul-W

2

Hello experts,

I have been asked to make a "minor" change to the existing report 106 - Customer Detailed Aging.

The current report uses an overdue time in months. We would like to see this in days.

In the dataset I see an OverDueMonths field. How do I get an OverdueDays field in the dataset?

Thanks,

Paul

Categories:

Business Central

Business Central

All responses Img

All responses (1)

Answers Img

Answers (0)

Mustafa Omerbegović 1,079 on at

Like (1)

Report

Change existing report 106 "Customer Detailed Aging"

Hello Paul,

You should write a little bit of code for that, but it shouldn't be hard if you are a developer.

You can create a copy of this report and write settings for OverDueDays based on the OverDueMonths.
Essentially, the only difference in your new field when you compare it to existing OverDueMonths is a new procedure that will calculate your OverDueDays.

The formula for procedure is ToDate - FromDate, and you need to call it (same as it is called native procedure CalcFullMonthsBetweenDates) on the onAfterGetRecord on the Cust_Ledger_Entry_Remaining_Amt_LCY_ column.

Also, add a new column in your RDLC file.

If you have a specific question feel free to ask.

Greetings

Helpful resources

Quick Links

Leaderboard

#1

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

#2

Martin Dráb 230,214 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans