how to add the bill age in a saved search

AI generated answer (using internal Slack threads):

To add the bill age in a saved search, you can follow these steps: 1. Create a new Transaction Saved Search. 2. In the Criteria subtab, add the following filters: - Type is Bill - Status is Open 3. In the Results subtab, add the following fields: - Document Number - Date - Amount - Name (Vendor) 4. Add a Formula (Numeric) field with the following formula to calculate the bill age:

TO_DAYS({today}) - TO_DAYS({trandate})

5. Label this field as 'Bill Age'. This will give you a saved search that includes the age of each bill in days. Here is a sample of how the formula field should look like in the Results subtab:

Field: Formula (Numeric)
Summary Type: Group
Formula: TO_DAYS({today}) - TO_DAYS({trandate})
Label: Bill Age

Please note that the

{today}

function returns the current date, and the

{trandate}

field refers to the transaction date of the bill. The

TO_DAYS()

function converts a date value to the number of days since year 0. The difference between the two gives the age of the bill in days. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******