formula to show the invoice Age as in the AR aging detail report

AI generated answer (using internal Slack threads):

To show the invoice age as in the AR aging detail report, you can create a transaction saved search with the following steps: 1. Navigate to Reports > Saved Searches > All Saved Searches > New. 2. Select Transaction. 3. On the Criteria subtab, filter by Type = Invoice. 4. On the Results subtab, add the following fields: - Name (this will show the customer name) - Document Number (this will show the invoice number) - Date (this will show the invoice date) - Amount (this will show the invoice amount) 5. Add a Formula (Numeric) field with the following formula to calculate the invoice age:

ROUND({today}-{trandate})

. This formula calculates the difference between today's date and the transaction date. 6. Save the search. This saved search will give you a list of invoices with their ages. Please note that this formula calculates the age of the invoice as the number of days since the invoice date. If you need the age in a different format (e.g., months, years), you will need to adjust the formula accordingly. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******