Go to Settings > Templates > Reports > Additional Tab, then click New Template (Aged Receivables (Line Items)).
Alternatively, in Reports > Aged Receivables (Line Items), click the template selector (top right) and choose New Template.
The Aged Receivables (Line Items) template has three tabs: General and PDF.
General: Edit template name, baseline period, header, and footer.
PDF: Customize layout, header, and footer for PDF version of the report.
Note: PDF preview and export are only supported for up to 8 columns.
The Aged Receivables (Line Items) template supports the following columns:
Adjustable:
Transaction Date (locked)
Due Date (locked)
Customer Name (locked)
Transaction
Reference
Current (PHP)
< 1 Month (PHP)
1 Month (PHP)
2 Months (PHP)
3 Months (PHP)
Older (PHP)
Balance (PHP)
Currency
Current (Source)
< 1 Month (Source)
1 Month (Source)
2 Months (Source)
3 Months (Source)
Older (Source)
Contact Group
Contact Relationship
Note: Transaction Date, Due Date, and Customer Name are locked. This means you cannot hide or re-arrange them. (PHP) pertains to the org’s default currency.
To show or hide columns:
Click the column icon at the top right of the template.
In the panel, you’ll see two lists: Hidden Columns and Selected Columns.
To show a column, move it from Hidden Columns to Selected Columns.
To hide a column, hover over it in the Selected Columns list and click the hide icon.
To arrange columns:
Click the column icon at the top right of the template.
In the Selected Columns list, hover over a row and drag it to your preferred position.
Go to Settings > Templates > Reports > Additional Tab, hover over the template, click the three-dot icon, and select Duplicate.
Changes apply automatically. For previously downloaded reports, redownload them to apply updates.
