Handling Household Relationships in NetSuite
Contact Management Configuration
- Use individual customer record and company customer records.
- Preferences: Check the preference to display Individual customer records as contacts
- Household Model
- Use the SubCustomers functionality
- Use this for transactional hierarchy
- How to create a household relationship record in NetSuite (e.g. Doe household):
- Parent Customer: Company Customer Type: "Smith Household"
- Sub-customer: Individual Customer Type: "Bill Smith"
- Sub-customer: Individual Customer Type: "Jane Smith"
- Sub-customer: Company Customer Type: "Smith Family Foundation"
- Sub-customer: Company Customer Type: "Smith Enterprises LLC"
- Often the company should not be included as a sub-customer of the household because it usually isn't exclusively associated with the household
- Sub-customer: Company Customer Type: "Bill Smith Donor Advised Fund"
***Transactions booked at the sub-customer level will be aggregated automatically at the parent customer level.
2. Sample Householding Procedures
Depending on your individual needs you may implement different procedures.
Individuals are always entered as individual customer records. Individuals are never entered as contact records.
Household containers are company customer records. They never have associated addresses, emails or contact information. Transactions are never booked to households.
Household containers are only created upon creation of the second customer record.
3. Householding Scenarios
Managing for Duplicate Mailings
A household container is ALWAYS created for every constituent.
All contact management records are recorded at the household level, never at the constituent level.
When a constituent is merged with another into a new household:
- Merge constituent 1 and household 1.
- Merge constituent 2 and household 2.
- Create a new household container and add constituents 1 & 2 as sub customers.