Issue
When we run the Celigo Settlement flow, there occurs an error which shows a settlement_order_not_found with message “NetSuite transaction could not be found. Settlement details: Settlement Id# 15460107661, Amazon AFN Order# 114-8511691-4140214.”
Solution
In this case, we need to copy the Amazon AFN Order# from the error list and need to import that id to the Netsuite using Celigo directly.
To import the Order Id, Go to Order(FBA) -> Settings -> Order and then paste the Order Id you copied from the error list to the Amazon Order Ids and click SAVE.
When we save this Order Id, there will be a flow named “Amazon (FBA) order to NetSuite order Add (on-demand sync)” which will run automatically and on successful completion of the flow, the corresponding transaction will be created in Netsuite with the same Order ID.
Then we can retry the error occurred in the settlement flow and it will be resolved.
NOTE: We can pass a maximum of 10 Order Ids in the Amazon Order Id(s) section at a time by separating the Ids with comma.