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)

Sort by

Mustafa Omerbegović 1,481 Moderator on at

Like (3)

Report
Copy link

Link copied!

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,698 Moderator on at

Like (2)

Report
Copy link

Link copied!

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,178 Super User 2026 Season 1 on at

Like (2)

Report
Copy link

Link copied!

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,178 Super User 2026 Season 1 on at

Like (2)

Report
Copy link

Link copied!

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. 23,136 Super User 2026 Season 2 on at

Like (2)

Report
Copy link

Link copied!

Agree you can achieve this by extending report.

Hope this helps: Bing Videos

Bing Videos

Bing Videos

Was this reply helpful? Yes No