When the NetSuite Settlement Transaction to NetSuite Refund Add flow is run to sync the refund transactions with NetSuite, you may have received the “Credit Memo not created. Cannot refund line item [Amazon SKU: XXXXXX, Amazon Order Item Code: XXXXXXXXX]. Please bill this line in NetSuite before importing its refund. Settlement details: Settlement Id# XXXXX, Amazon MFN Order# XXX-XXXXXXX-XXXXXXX.” error. This is due to an error faced at Amazon end with respect to the order item API where the order item IDs updated for the returned transaction item lines differ from the order item IDs associated with the transaction item lines when the order was created. As the incorrect order item IDs are updated, the records are not updated and the “Credit Memo not created. Cannot refund line item” error is received.
A sample of how a refund transaction is displayed in NetSuite with the incorrect order item IDs updated for the transaction line items is shown below:
In this sample, you can see that the Exported to IO checkbox is checked. However, the record is not exported to IO as the incorrect order item IDs have been assigned to the transaction line items of the refund transaction. The Error Code and Error Message fields display this information.
To overcome this issue and to ensure that the correct order item IDs are reflected for the returned items, you need to run the Amazon - NetSuite refund errors custom flow. This will ensure that the correct order item ID is mapped for the returned items.
Important: Do not retry the “Credit Memo not created. Cannot refund line item” errors received while running the NetSuite Settlement Transaction to NetSuite Refund Add flow for the first time. Resolve those errors, run the Amazon - NetSuite refund errors custom flow, and then run the NetSuite Settlement Transaction to NetSuite Refund Add flow again. This will ensure that the refund transactions are synced successfully with NetSuite.
- If there are multiple item lines with the same SKU and the same order item ID, the correct order item ID cannot be identified. Such records have to be updated in NetSuite manually
- In case of partial payments or partial refunds, the custom flow will sync the transactions each time Amazon generates a new report. This may result in duplication of payments or refunds. These duplicate records need to be deleted in NetSuite manually.
- In case of full payments / refunds, the custom flow will sync the transactions each time Amazon generates a new report. If this happens, you will receive the “Invoice record is already paid in full. Settlement details: Settlement Id# XXXXXXX, Amazon MFN Order# XXX-XXXXXXX-XXXXXXX.” error in the IO dashboard as the custom flow would have already synced the payments/Refunds.
Install and configure custom flow
Before you install the Amazon - NetSuite refund errors custom flow, download the zip file to your local drive.
You need to install and configure the custom flow in order to run it. To install and configure the custom flow, follow the steps mentioned in the Install integration section and Configure integration section of the Install integration or download integration zip article.
Create saved search for order item IDs
After the custom flow is configured, you need to create a new saved search in the Celigo Amazon Settlement Transaction Search screen in NetSuite with the following parameters:
- In the Criteria tab, select the following parameters:
| Filter | Description |
|---|---|
| Transaction Type | is Refund |
| Error Code | is Missing Order Item Info |
| Inactive | is false |
| Posted Date | is on or after 1/7/2023 |
- In the Results tab, select the following fields:
- Order Id
- Celigo Amazon Settlement Item Price: Internal ID
- Celigo Amazon Settlement Item Price: SKU
Run the Amazon - NetSuite refund errors custom flow
Run the Amazon - NetSuite refund errors custom flow in integrator.io. The correct order item IDs will now be mapped to the refund transaction line items.
A sample of how a refund transaction is displayed in NetSuite with the correct order item IDs updated for the transaction line items after running the Amazon - NetSuite refund errors custom flow is shown below:
In this sample, you can see that the Exported to IO checkbox is not checked and the correct order item IDs are mapped to the transaction line items in the refund transaction. The information displayed in the Error Code and Error Message fields will be updated once the NetSuite Settlement Transaction to NetSuite Refund Add flow is run again and the transaction is successfully synced in NetSuite.
Run the NetSuite Settlement Transaction to NetSuite Refund Add flow
Run the NetSuite Settlement Transaction to NetSuite Refund Add flow again. The refund transactions will be synced in NetSuite with the correct order item IDs for the transaction line items.
Comments
Please sign in to leave a comment.