Advanced PDF Template for Customer Statements: Calculating Date Differences for Invoice Aging

This FreeMarker script is designed to categorize overdue invoices on a customer statement by calculating the number of days between the invoice due date and the statement date. Here’s a concise breakdown of the process: Extract and Convert Dates: The script retrieves the due date (line.duedate) and statement date (statement.trandate), converting them into strings. Check… Continue reading Advanced PDF Template for Customer Statements: Calculating Date Differences for Invoice Aging

Difference of As Of and Age As Of on Aging Reports

As Of refers to the date that the report will capture transactions.  If As Of is set to yesterday, then the transactions that the Aging report will include will be all the transactions dated up to yesterday’s date. Age As Of refers to the date from which the report will count the age of transactions.  If Age As Of is set… Continue reading Difference of As Of and Age As Of on Aging Reports