Prevent the Creation of Duplicate Records When Running NetSuite Connector
When a record is exported, part of the process is marking it as exported and populating the NetSuite Internal id in SuiteProjects Pro. There are instances where the export process is interrupted before SuiteProjects Pro receives the response from NetSuite. Records may be exported to NetSuite but will not complete marking it as exported and populating the NetSuite ID in SuiteProjects Pro. If this happens, the record will be exported again causing duplicate records.
The Auto recovery feature prevents the creation of duplicate records by identifying records included for export in the interrupted integration run that verifies if the record was already exported to NetSuite. If the record exists on NetSuite, the integration updates the record in SuiteProjects Pro. Otherwise, the record will be exported again.
Auto recovery supports the following records:
- Verify Customer export
- Verify Invoice export
- Verify Credit (negative invoice) export
- Verify Expense Report export
- Verify Project Export
- Verify Recognition transaction export
- Verify Timesheet export
Steps to enable this feature:
- Navigate to Administration > NetSuite Connector
- Click View tips located at the upper right with the bulb icon, then select NetSuite Connector Administration.
3. Go to Auto recovery section, check the record you need to enable this and click Save.