We're in the process of creating sub customers for different forms of financing, but all for the same customer. We decided to use sub customers to tie them all together, which works except at the top level parent customer (which is the main customer without any financing option attached) it shows all the sub customers transaction records. Our sales reps would like to only see that parent customers transactions when they are looking at that customer. Support sent us a work around which involves creating a custom sub list and saved search, however you still have to manually select the customer you want to view once you're in the sub list. The workaround is as follows:
A. Customize the View on the Customer Record
1. Go to the Customer Record > Sales tab > Transactions subtab
2. Click on the Customize View
3. Click on More Options button
- On the Criteria tab > Standard subtab > Add the following Filter:
Main Line is true
-On the Results tab Columns subtab > Add and remove fields. Add the following fields:
Customer/Project: Name
4. Click on the Available Filters tab > add Name as a filter and check the Show in Footer checkbox
5. Check the Available as Sublist View checkbox
6. Rename the saved search.
7. Save.
B. Create Custom Sublist
1. Go to Customization > Forms > Sublists
2. Click on the Entity tab
3. Look for the Saved Search created under the Search column (If it doesn't appear, make sure you have the sublist view checkbox checked for the search and in the available filters, remove all the other filters except name)
> Provide a label
> Tab Column = Sales
> Customer Column = Yes
4. Save.
Is there any way to do this that's more automated? For example, I was trying to create a formula field in the saved search that said if customer name == parent customer so it would only show the parent customer transactions. This didn't work, but I'm hoping there is a better way of viewing parent customer transactions? Thanks in advance.