NetSuite Sync Error | Too many vendors with name {vendor_name} at realm {realm_id}

What's Happening

• Ramp is detecting a duplicate vendor in NetSuite with the same Name/ID or Company Name.
• If multi-subsidiary, the Vendor may not have all associated subsidiaries added to their record.

How to Resolve

1. In NetSuite as an Admin , locate your Vendor in the Global Search using Ven: Vendor Name+ (the + searches for inactives).
2. The dropdown may contain multiple Vendors or an existing Vendor.
3. View the Vendor profile.
4. In the System Information tab, confirm that Inactive is not selected.
5. In the Subsidiaries tab, confirm that all subsidiaries are added to this Vendor record.
6. Ensure the Name/ID and Company Name are not duplicates of the Vendor record being created in Ramp .
7. Go back to Ramp and refresh your accounting settings. The vendor should now appear for selection.
8. If the vendor still doesn’t appear, manually link the Ramp merchant to the existing NetSuite vendor.
9. Retry the sync in Ramp .

OR

1. In NetSuite as an Admin , navigate to List > Relationships > Vendors .
2. Enable the Show Inactives checkbox.
3. Locate and view the Vendor record.
4. In the System Information tab, confirm that Inactive is not selected.
5. In the Subsidiaries tab, confirm that all subsidiaries are added to this Vendor record.
6. Ensure the Name/ID and Company Name are not duplicates of the Vendor record being created in Ramp .
7. Go back to Ramp and refresh your accounting settings. The vendor should now appear for selection.
8. If the vendor still doesn’t appear, manually link the Ramp merchant to the existing NetSuite vendor.
9. Retry the sync in Ramp .

OR

For multi-subsidiary Vendors:

1. In NetSuite , locate the Vendor record.
2. Navigate to the Subsidiaries tab.
3. Confirm all subsidiaries are added to the Vendor record. If not, proceed to add the subsidiaries.
4. Save the changes.
5. Navigate back to Ramp and retry the sync.