Q1. How do I create a new Aged Receivables (Line Items) template?
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.
Q2. What settings can I customize in my Aged Receivables (Line Items) template?
The Aged Receivables (Line Items) template has two 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.
Q3. What columns are supported in the Aged Receivables (Line Items) template?
The Aged Receivables (Line Items) template supports the following columns:
Adjustable:
Transaction Date (locked)
Due Date (locked)
Customer Name (locked)
Transaction
Reference
Current (SGD)
< 1 Month (SGD)
1 Month (SGD)
2 Months (SGD)
3 Months (SGD)
Older (SGD)
Balance (SGD)
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. (SGD) pertains to the org’s default currency.
Q4. How do I select/hide/arrange columns in the Aged Receivables (Line Items) template?
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.
Q5. What is the decorator function in Template Style for?
Turning on decorators for Template styles adds a horizontal line on top of the report.
Q6. What is the uppercase function in Fonts for?
Turning on uppercase converts all text in the report to uppercase.
Q7. Can I add a logo to my Aged Receivables (Line Items) Template?
Yes, go to Template Settings > PDF > Add a logo
Logo file should only be up to 1mb with min width: 120px and min height: 60px
Q8. What is the dynamic string in the PDF Date Title for?
You can use the dynamic string for dates to configure your date title according to your preferred format.
Q9. How do I duplicate an Aged Receivables (Line Items) template?
Go to Settings > Templates > Reports > Additional Tab, hover over the template, click the three-dot icon, and select Duplicate.
Q6. What happens when I update an Aged Receivables (Line Items) template?
Changes apply automatically. For previously downloaded reports, redownload them to apply updates.
Q10. What happens when I update an Aged Receivables (Line Items) template?
Changes apply automatically. For previously downloaded reports, redownload them to apply updates.