When the Bank File to NetSuite flow fails due to an external issue, such as, NetSuite down error or IO down error, there are possibilities of creating duplicate transactions on Batch records in NetSuite while you retry the flow.
To avoid the duplicate transaction while you retry the error flow, you need to perform the following steps in your IO account:
Note: Following steps should be performed before you retry the error Bank File to NetSuite flow. These steps need not be reverted after the errors retire.
- Click on the Edit mapping icon under Mappings of Bank Transactions to NetSuite flow of the respective Bank.
- Click on the Settings icon of Celigo Lockbox Transaction : Transaction Hash field mapping.
- Enable the Use as a key field to find existing lines checkbox.