Dynamic refund location mapping depending upon shopify order source or netsuite parent transaction
In the current shopify netsuite integration app, the shopify refund to netsuite refund flow can have the refund location mapping. This flow creates credit memo if the parent transaction was sales order else it creates cash refund it the parent transaction was cash sale. Following are the requirements that I need to accommodate:
1. If parent transaction was sales order and refund transaction to be created is credit memo then we have to use a hard coded location at header level in credit memo. This location is same as parent sales order header level location (which is also hardcoded). I believe using a dynamic lookup to find the parent transaction and use its header location will work in this case as well.
2. If parent transaction was cash sale and refund transaction to be created is cash refund then we have to use a dynamic lookup such that the cash refund can import the header level location from parent cash sale by looking up the shopify order id.
Does anyone know how to accommodate both of these requirements in one flow?
Comments
Hello Sujit Desai
This is Khaisar from Celigo Engineering team. Let me try to reply to your case.
As per my review you want to source the Refund Location based on the record type. I would like to confirm the IA flow as well works in the same way. We transform the respective billing record to form the refund record i.e., Credit Memo is created by just transforming the Invoice and similarly Cash Refund by transforming the Cash Sale.
So during transformation, all the details are just forwarded to the resultant record from the source record, unless we are trying write a new value.
Are you observing any issue in this scenario i.e., flow is not transforming the location as like it's source record ??
Please review and let me know if anything is required.
Thanks,
KHAISAR AHMAD
Thank you for the suggestion. It would be great if you can suggest the actual mapping that I should use in the import steps of the Shopify to NetSuite refund flow. Since source bill record is different for Cash refunds and Credit memos I do not know what will be the mapping. Thank you.
My current mapping in the Credit Memo/ Cash Sale import step is as follows:
Please sign in to leave a comment.