Creating a credit memo with refund in NetSuite

Integrator.io
1

Hi All,

I am building a custom flow to handle returns. Currently, I have done the following:

  • Create/Post return authorisation.
  • Create an Item receipt from the RA.
  • Create a credit memo from the RA.

But I am struggling to create a refund to attach to the Credit memo (apply and apply document). What is the recommendation here? Should I create a refund before creating the credit memo?

Any documentation I can read on this?

2

Hi @Ovina_Peiris ,

Maybe worth having a look at the template described here:

https://docs.celigo.com/hc/en-us/articles/42062112641947-Shopify-NetSuite-Returns-exchanges-and-refunds-integration-template

3

Not exactly what I am looking for as that is specific to Shopify. So I am trying to create a refund and apply it to the Credit Memo I created. But I am getting the error:

Failed to create, update/transform record because You have attempted an invalid sublist or line item operation. You are either trying to access a field on a non-existent line or you are trying to add or remove lines from a static sublist. Tip: Please make sure that all the line items that you're trying to use exist on the record.

4

Hi,

Not sure if this fits your use case but what I did in our custom flow is that after creating the credit memo. I've added a results mapping to get the internal id of the credit memo transaction that gets created.

image
image1056×214 12.8 KB

image
image1819×221 34.2 KB

Then in the "Create Customer Refund" step. This is what the import mapping looks like.

image
image1317×704 29.2 KB

Mapped the internal id of the credit memo from the previous step to this destination field Credits : Hidden (Field ID : internalId).

5

Thank you Marco.

Hidden (Field ID : internalId) is the right mapping to use (and the same kind of mappiong when creating a customer payment, and mapping to .)