Description:

Get the paid payments from Stripe and import the payments on invoice

• Once the flow is scheduled it gets the list of paid payments from Stripe
• Using a lookup gets the list of customer payments which have the Stripe Payment Id as empty from Novamodule Stripe Customer Payment Lookup Template saved search

Customer Payment

• A filter checks if the Stripe Payment Id is empty in NetSuite and the Payment status is either paid or succeeded in Stripe
• Creates a customer payment in NetSuite and updates it with Stripe Payment Id and applies it on the respective invoice.
• Updates the payment metadata in Stripe with the NetSuite Customer Payment Id.

Configure IO Settings:

•  Click on Settings - Payments - Stripe to NetSuite 

• Account for NetSuite Payments
  • Select account to add for customer payments

• Select the NetSuite saved search for the list of customer payments which have the Stripe Payment Id as empty from “Novamodule Stripe Customer Payment Lookup Template” saved search. Make a copy of the saved search and use the copied saved search for any additional criteria or results

• Update NetSuite Payment Id to Stripe Metadata
  • Check this checkbox to update netsuite payment id into stripe metadata

IO Mappings: 

• Import Customer Payment on Invoice (Stand Alone)

  • Uses a Dynamic lookup to get the customer using the  Internal Id from the  filter ["custentity_nm_stripe_customer_id","is","{{{customer}}}"]
  • A Dynamic lookup is used to get the Invoice internal id using the filter ["custbody_nm_stripe_invoice_id","is","{{{new_invoice}}}"]  to map with the Invoice line Id
  • Mapping location, amount and payment method

• Update Stripe Payment Metadata with NetSuite Customer Payment 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>)