show invoice amount due in a saved search

AI generated answer (using internal Slack threads):

To show the invoice amount due in a saved search, you can use the 'Amount Remaining' field in the saved search on the transaction record for the Sales Order. This field will show the total amount that is yet to be paid on the invoice. Here are the steps to do this: 1. Navigate to Reports > Saved Searches > All Saved Searches > New. 2. Select Transaction as the record type for your new saved search. 3. In the Criteria subtab, add a new criterion where Type is Sales Order. 4. In the Results subtab, add a new column where Field is Amount Remaining. 5. Save and run your saved search. This will give you a list of all sales orders and the remaining amount to be paid on each one. Please note that if you are using a billing schedule/ARM, the total amount may not reflect the individual next Invoice amount. In this case, you might need to look into a revenue schedule search or use SuiteAnalytics Workbook, which allows multi-join. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******