i want to make report show the days remains for the invoice to become due

AI generated answer (using internal Slack threads):

To create a report that shows the remaining days for an invoice to become due, you can use a saved search in NetSuite. Here's a step-by-step guide on how to do it: 1. Navigate to Reports > Saved Searches > All Saved Searches > New. 2. Select Transaction as the type of search. 3. Define your criteria. For example, you might want to include only invoices, and only those that are not paid. 4. In the Results subtab, add the fields you want to display in your report. You'll definitely want to include the Invoice Number, Due Date, and Status. 5. To calculate the remaining days until the invoice is due, you'll need to create a Formula (Numeric) field. In the formula field, enter

TO_DAYS({duedate}) - TO_DAYS({today})

. This will calculate the difference in days between the due date of the invoice and today's date. 6. Save your search. Now, when you run this saved search, it will show you a list of all unpaid invoices, along with the number of days remaining until each invoice is due. Remember, you can also add additional fields to your saved search to provide more information in your report, such as the customer name, invoice amount, and so on. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******