Monday, October 1, 2018

Add Aging Buckets to the A/R Aging Detail Report


1. Instead of customizing the A/R Aging Detail report, customize the A/R Aging Summary report (Reports > Customer/Receivables > A/R Aging > Customize Summary) and add the columns of the A/R Aging Details.

2. On Edit Columns tab, add the following:
- Transaction Type (Unpaid Receivables: Transaction Type: Long Name)
- Transaction Date (Unpaid Receivables: Transaction Date)
- Transaction Number (Unpaid Receivables: Transaction Number)
- Reference Number (Unpaid Receivables: Reference Number)
- Due Date (Unpaid Receivables: Due Date)
- Age (Unpaid Receivables: Age)

3. Move the 'Current' and 'Open Balance' columns to the far right side.

4. Enter a Name for the report.

5. Click the Save button.

No comments:

Post a Comment