how the age is being calculated in the AR aging detail report and how to reflect the same formula in a saved search for open payments

AI generated answer (using internal Slack threads):

The age in the AR Aging Detail Report is calculated based on the difference between the current date and the invoice date. If you want to reflect the same formula in a saved search for open payments, you can create a formula field in your saved search with the following formula:

FLOOR(NVL({paymentdate},{today})-{invoicedate})

. This formula calculates the difference between the payment date and the invoice date. If the payment date is null (which means the payment is still open), it uses the current date (

{today}

) instead. The

FLOOR

function is used to round down the result to the nearest whole number, effectively giving you the number of days that the payment has been open. Please note that you should set the summary type of the field to 'average' and enable 'show totals' for the saved search. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******