Description:

The "NetSuite Invoice to Stripe Invoice Add " flow transfers data from NetSuite invoices to Stripe invoices.

• Once the flow is scheduled it gets the list of Invoices from NetSuite using “Novamodule Stripe Invoice Export Customer Main Template” where the Stirpe Invoice Id is empty and the invoice status is neither paid nor voided.A script is used to prepare invoice data for export from NetSuite by validating due dates and adjusting invoice line items to handle prepayment or refund adjustments.

Customer

• A filter checks if the customer Id is empty only then it creates a customer in Stripe
• Updates NetSuite customer with Stripe Customer Id. It identifies the existing customer using the filter ["internalid","is","{{{[NS Customer]}}}"]

Invoice

• Creates a dummy invoice item for Stripe for the NetSuite Item
• Imports invoice to Stripe and a post submit script is used to add more details to invoice data, like the total amount and customer details, to the basic response.
• Deletes the created dummy item in Stripe
• Creates invoice items in Stripe
• Then finalize the invoice in Stripe
• The flow first checks if the invoice exists using the following filter ["internalid","is","{{{internalid}}}"]. Then updates the invoice in NetSuite with Stripe Invoice Id

Configure IO Settings:

•  Click on Settings - Invoices - NetSuite to Stripe

• Select the NetSuite saved search for invoices which have the invoice status as neither of “paid in full” nor “voided”. This search will be available after the bundle installation “Novamodule Stripe Invoice Export Customer Main Template ”. Make a copy of the saved search and use the copied saved search for any additional criteria or results

IO Mappings: 

• Update Invoice in NetSuite

  • Mapping invoice id, invoice url, invoice number, amount due, amount paid and due date
  • Setting NM Stripe Invoice Payment Links : Replace All Lines to “true”
  • Mapping NM Stripe Invoice Payment Links : Stripe Invoice Id to the stripe hostel url
  • NM Stripe Invoice Payment Links : Stripe Payment Link (Plain Text) to the stripe hostel url
  • NM Stripe Invoice Payment Links : Stripe Payment Link to the stripe hostel url

● Adjust the mappings if needed like location mapping.