Description:

Get the list of paid invoices from Stripe and create Customer Payment record in NetSuite

• Once the flow is scheduled it gets the list of invoices from Stripe with the Delta Export type (Delta – export only data created/updated since the last time the flow ran, based on a given date field) by the last export date and then using an output filter only paid invoices pass to the next import
• Creates a customer payment in NetSuite and applies it on the invoice. It also updates the Stripe Charge Id and Stripe Payment Id on the Customer Payment record in NetSuite

Configure IO Settings:

•  Click on Settings - Invoice Status - Stripe to NetSuite 

• Account for NetSuite Payments
  • Select the account to map for customer payments in NetSuite
• Select Payment Method for NetSuite Payments
  • Select the payment method used to the payment in Netsuite

IO Mappings: 

• NetSuite Customer Payment Add
  • Gets the customer using a dynamic lookup with internal Id as field value with the filter ["custentity_nm_stripe_customer_id","is","{{{customer}}}"]. If the customer is not found the import errors out.
  • Subsidiary, account and class name values are mapped
  • Stripe Charge Id field is mapped to the charge from Stripe
  • A dynamic lookup is used to get the Invoice to apply the payment on it. The following filter is used to get the Invoice and the Internal id as the field value ["custbody_nm_stripe_invoice_id","is","{{{id}}}"]
  • If the invoice doesn’t exist this import errors out
  • Invoices Apply and Accounts are set to “true” in the mappings
  • Stripe Payment Id and external id would be “payment”(string) concatenated with the payment id joined by “_” (payment_<id>)