Skip to main content

Resolving Duplicate Customer Records in NetSuite

S
Written by Support

If your team has recently reorganized or rebuilt customer records in NetSuite (e.g., during a re-implementation or cleanup), you may end up with two customer records representing the same trading partner — for example, two separate "UNFI - East" customers with different NetSuite internal IDs (one older, one newer). This is most commonly seen with large distributors/retailers like UNFI, KeHE, and Grocery Outlet.

If both customer records have open invoices and only one is mapped in Confido, invoices on the older/unmapped record won't be picked up.

Resolving Duplicate Customers

  1. Identify which customer record is currently mapped in Confido (this is typically the newer/current record)

  2. In NetSuite, set the older, duplicate customer record as a child of the customer record mapped in Confido

  3. Once the parent/child relationship is set, Confido will pick up the open invoices from the child customer automatically, since they roll up to the parent

Note: This same fix applies to any duplicate customer pair where both records have open invoices, not just the example above.

Did this answer your question?