We would like to make it easier for reps to find transactions for a customer that have a specific item on them. We've already created a custom version of the Item Transaction Sublist View to include a filter for Customer on it. With this, reps can open an item record, go to Related Records > Transactions and filter the results for a specific customer (and transaction type). That works great.
We tried to do the reverse by creating a custom version of the Transaction Default Sublist View to include a filter for Item on it with the hopes that reps could open a customer record, go to Sales > Transactions and filter the results for a specific item (and transaction type). But that doesn't work.
What is confusing is that the custom Transaction Default Sublist View works differently when run as a saved search vs when run in the actual sublist. When run as a saved search, there are multiple results with the same transaction document number, which makes sense since the saved search has no criteria for mainline.
However, the sublist viewed from customer records only has a single result for each document number.
Since this native NS sublist is in a native NS subtab, it's not possible to see how this is configured.
Why (or how) is the actual sublist summarizing the results when the underlying saved search does not?
Thank you,
Scott