Data Flow | Stripe Credit Note to NetSuite Credit Memo Add and Customer Refund Add |
Flow Type | Realtime |
NS Record | Credit Memo, Customer Refund |
Description:
Get the credit note from Stripe and create a credit memo it to , if the credit note includes a refund it creates a customer refund record in NetSuite
- Once a credit note is created in Stripe this flow gets triggered
- Gets the Invoice line items using Stripe Lookup
- A filter checks if a customer balance transaction exists for that customer and if yes, gets the customer balance transaction for the customer using Stripe Customer balance Transaction Lookup
- A filter checks if a refund exists for that credit note, if yes, it gets the refund using Stripe Lookup
- It creates a credit memo record for the credit note in NetSuite
- If the credit note has a refund to it it also creates a customer refund record in NetSuite
Configure IO Settings:
- Click on Settings - Refunds - Stripe to NetSuite
- Select the Netsuite Transaction Type i.e Cash Sale / Cash Refund or Customer Payment / Customer Refund
- Select the NetSuite saved search for dispute records
- Select account for NetSuite Customer Payment.
- Select Account for NetSuite Cash Sale.
- Enter the item internal id to track Stripe Disputes as a line item in NetSuite
IO Mappings:
- Create Credit Memo from Stripe Credit Note
- Mapping location, amount and item details
- Uses a dynamic lookup to get the created from invoice internal id using the following filter ["custbody_nm_stripe_invoice_id","is","{{{invoice}}}"]
- Stripe Credit note id and external id in NetSuite are mapped to the credit note Id from Stripe
- Update Stripe Credit note Metadata with NetSuite Customer Refund Id
Add the mappings as mentioned below
- Source record field (Stripe)
- Give the name of the field you want to get the value from
- Destination record field (Stripe)
- Enter metadata followed by the name you wish to give to the field
(metadata.<anyNameForTheField>)