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

Change existing report 106 "Customer Detailed Aging"

(5) Share

Report

Posted on by Paul-W

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:

Dynamics 365 Business Central

I have the same question (0)

All responses (5)

Answers (0)

Mustafa Omerbegović 1,473 Super User 2025 Season 2 on at

Like (3)

Report

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

1 people found this reply helpful.

Was this reply helpful? Yes No
Suggested answer

Steven Renders 5,672 Moderator on at

Like (2)

Report

Do not clone (copy) the report, but create a report extension instead.

With a report extension you can easily add a column to a data item in the report, with a calculated value.

Report extension object - Business Central | Microsoft Learn

Report Extension Example - Business Central | Microsoft Learn

1 people found this reply helpful.

Was this reply helpful? Yes No
Suggested answer

Sohail Ahmed 11,136 Super User 2025 Season 2 on at

Like (2)

Report

You can’t directly change the standard dataset of report 106, but the recommended way is to extend the dataset using a report extension. That way you can add your own calculated field (e.g. OverdueDays) and use it in the layout.

Here’s a simple example from another report I extended, which might give you a hint:

✅ Mark this as the verified answer if helpful.

Was this reply helpful? Yes No
Suggested answer

Sohail Ahmed 11,136 Super User 2025 Season 2 on at

Like (2)

Report

I agree with @Steven — for small requirements like this, it’s always better to extend the report instead of creating a full copy of the standard one. With a report extension you can simply add your custom field with minimal code and keep the standard report behavior intact.

✅ Mark this as the verified answer if helpful.

Was this reply helpful? Yes No
Suggested answer

Khushbu Rajvi. 20,275 Super User 2025 Season 2 on at

Like (2)

Report

Agree you can achieve this by extending report.

Hope this helps: Bing Videos

Bing Videos

Bing Videos

Was this reply helpful? Yes No