Configure - Stripe Credit Note to NetSuite Credit Memo Add and Customer Refund Add

  • Updated
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>)