Amazon - NetSuite Unable to create credit memo even though now fully billed

Integrator.io
, ,
1

Hello
I have some credit memos which have failed to import into NetSuite from Amazon - all with the same issue that the invoice line hadn’t been fully billed.
The invoice is NetSuite was fully billed but hadn’t been fully settled. I thought this was the issue and amended the bill so it was paid in full.
Retrying hasn’t created the credit memo and refund though.
Can anyone help with what I have missed?

2

Hi Rachel,

I hope you're having a great day! Could you please share the specific error message you're seeing in your flow when trying to create the credit memo? That will help us identify what might be affecting the processing and suggest possible solutions.

In the meantime, you might also want to review this article NetSuite Settlement Transaction to NetSuite Refund Add to see if it provides any helpful insights. Thank you!

3

Hi Jacque

Thanks for replying! The error message I am seeing is:

’Credit Memo not created. Cannot refund line item [Amazon SKU: UR/BRNB/MW01, Amazon Order Item Code: 54246652337442]. Please bill this line in NetSuite before importing its refund.’

I have found the Celigo Amazon Settlement Transaction for the refund in NetSuite and it has a status of Unapplied - presumably because of the issue creating the Credit Memo. The error details on this are:image

But all of the items on the order have been invoiced…

4

Hi Rachel,

Yes, the refund is still showing as unapplied because the credit memo hasn’t been successfully created in NetSuite yet.

Instead of retrying the same error, could you please try to re-run the Refund Add Flow by following the steps below?

  1. In NetSuite, locate the Settlement Refund Transaction record for the relevant Order ID.

  2. Uncheck the Exported to IO checkbox.

  3. Once unchecked, re-run the Settlement Refund Add Flow and check if the same error appears during the Create Credit Memo step.

Please let me know if the issue persists, if so its would be better to review the data with our support team so we can further check by creating support ticket.

Thank you!