NetSuite Limitation of the Customer-Subcustomer Hierarchy In the Amazon-NetSuite Integration App

SteinChu

Updated February 04, 2021 12:32

Issue:

One of the configuration options in the Customer Import data flow is to set the imported Customers as child records of a default Parent Customer. Unfortunately, NetSuite places a limitation of a maximum of 10,000 sub customers (all levels included) in a customer hierarchy. Once this limit is reached, NetSuite will not allow the creation of a new sub customer. This will cause the Order Import data flow to fail.

Reference: NetSuite Help Guide

"NetSuite limits the maximum number of customers you can include in a customer-sub customer hierarchy. A customer hierarchy is comprised of the top-level parent customer, all of its sub customers, and all of its sub customers. You can have a maximum of 10,000 customers and sub customers in a customer hierarchy.

This limit is in place to improve performance. If you need to increase your account's limit, please contact NetSuite Customer Support. Going beyond the set hierarchy limit may cause a performance impact related to customer credit limits, customer balances and consolidated balances, as well as payments to the top-level customer."

There are two alternate solutions.

Solution 1:

The first solution is to configure the Customer Import data flow to add the Customers to a new, or different, Parent Customer record.

Solution 2:

Alternately, if the use of a Parent Customer is not needed, this issue can be resolved by removing the Parent Customer mapping.