Discussions
Read on for the latest updates including:
• Agenda Builder launch
• SuiteWorld On Air registration
• New NetSuite Prompt Studio Contest
• And more!
Check out this thread to learn more!
Reporting on customers with counts of child records
We have a record type called Asset. Each Asset has a Customer as its parent. (It's a one to many relationship - Customer to Assets.)
Each Asset has a field called Colour, with possible values Red, Green and Blue.
I want to make a saved search or report to show me a list of all the Customers, and for each Customer the number of Red Assets, Green Assets and Blue Assets.
I can't see how to do this without adding three custom fields to Customer, to store the number of Red Assets, Green Assets and Blue assets respectively, and then adding these fields to the results of a Customer saved search.