Does anyone here know how to show the “Invoice amount” instead of the total Sales Order amount if a billing schedule/ARM is enabled from a transactional saved search? It is showing the total unbilled amount but not the individual next Invoice amount in a saved search

you might not be able to show that because it would be a double join, since future invoice value is in the billing schedule (which is not an transaction). Try the search other way around

Got it - Thanks for sharing the insight! I might have to look into a revenue schedule search then..

you may be able to do that in analytics workbook - it does allow multijoin

good point, I will try that

https://system.netsuite.com/help/helpcenter/en_US/srbrowser/Browser2023_2/odbc/record/account.html look it up here