This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

we need a field on the customer record to show their current total orders value - is this likely to be a scriptable solution or could we use saved search/data sourcing?

say the customer has three orders, 100, 100, 100 - therefore the current total order value would be 300.

Any reason why the standard Unbilled Orders field won't work for your team?

Sorry, should have clarified - orders that have been fulfilled, therefore I should have said total value of all the invoices

You mean their current outstanding balance?

It seems like we are getting close to a definition...

why not just create a saved search for invoices with sum and show that saved search as sublist in a custom tab for the customer record. Make sure to set the customer as the filter in the search and available for sublist

Not the outstanding balance. Basically how much has we made from a particular customer...total sales.

<@U2A2VHL3W> yeah that's the kind of thing i was hoping would be possible. The end goal would be to determine price level based on sales hence why i figured having a field store the total sales would make sense. 