Finance | Project Operations, Human Resources, ...

How to generate customer aging report only for 60+ days due customers.

(0) Share

Report

Posted on by Test529

Hi team,

we are trying generate report only 60+ days due customers, how to exclude 1-60 days data in the report. the report should show only 60+,90+,120+.

1. Aging definition.

2. with above aging definitions below report generation..

3. Expecting report. should not print yellow marked (1-60) data in the report, please help here to achieve in standard customer aging report.

I have the same question (0)

All responses (5)

Answers (0)

Sort by

Suggested answer

BillurSamdancioglu 21,389 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

Hi,

You may delete that line on the definition.

Was this reply helpful? Yes No
Frank Hamelly | MVP... 46,633 Moderator on at

Like (0)

Report
Copy link

Link copied!

You can create multiple Aging period definitions, configured the way different users need them and select the appropriate definition when entering report parameters.

Was this reply helpful? Yes No
Test529 15 on at

Like (0)

Report
Copy link

Link copied!

Hi Billur,

if i delete the Line (1-60) on the aging definition, report will shows due for all customers with they are fall under 1 day to till 90 days in one column rest shows based on aging bucket.

how to achieve to generate report only for customers which due date are more than 60+ days, we dont want to print customers on the report which payment due date below 60+ days.

Thank you.

Was this reply helpful? Yes No
Test529 15 on at

Like (0)

Report
Copy link

Link copied!

Hello Community members,

could any one provide solution on this.

Thank you.

Was this reply helpful? Yes No
Frank Hamelly | MVP... 46,633 Moderator on at

Like (0)

Report
Copy link

Link copied!

This might require a customization. I tested in Contoso and couldn't get it to work either. It always picked up newer invoices in the 60+ aging period. You could run the report, export to Excel and delete the aging columns you don't want to see.

Was this reply helpful? Yes No