We need to determine if our Parent Customers have any Transactions. I am attempting to customize a sublist following the steps in SuiteAnswer 12764 below
SuiteAnswer: 12764
Scenario
By default the parent Customer record displays all transactions for both parent and child customers via Customer record > Sales tab > Transactions subtab.
Solution
To view only transactions entered for the parent Customer, you need to customize the View.
- Navigate to Lists > Relationships > Customers
- Click View next to the parent Customer record
- Click Sales tab
- Click Transactions subtab
- Click Customize View
- Click Criteria tab
- Click Standard subtab
- Filter:
- Select Formula (Numeric)
- Formula: Enter case when {mainname} = {customer.parent} then 1 else 0 end
- Formula (Numeric): Select equal to
- Value: Enter 1
- Click Set
- Click Save
- Search Title: Enter Title for the custom View
but receive the error: Your formula has an unrecognized field in it. Please go back and correct the formula and resubmit.
I also tried this discussion https://community.oracle.com/netsuite/english/discussion/4244529/only-show-top-parent-customers-transactions-not-all-sub-customers but the view still returns all sub-customer transactions.
SuiteAnswer 61554 is not appropriate
Does anyone have any suggestions? Thanks.