There are chances that the Settlement report got missed to be processed by the Celigo flow. Then we have to upload the settlement report manually and run the flow which will create the settlement transactions in NetSuite.
- Login into the Amazon seller central account and download the settlement report in Flat file v2 format.
- In integrator.io, click Amazon – NetSuite Integration App tile.
- Go to Flows > Settlement.
- Disable the flow “Request Amazon Settlement Report List”.
- Now the flow “Amazon Settlement Report to NetSuite Custom Settlement Records” is enabled, click Run.
- Upload the downloaded settlement report.
- After you run the “Amazon Settlement Report to NetSuite Custom Settlement Records” flow successfully, the integration app automatically triggers the “NetSuite Settlement Transaction to NetSuite Payment Add” flow and the “NetSuite Settlement Transaction to NetSuite Refund Add” flow.
- Verify in NetSuite the corresponding Settlement summary record is created along with the associated settlement transactions, payments and refunds.