Overview
Stripe has a limitation that only allows the creation of invoices with up to 250 items. On the other hand, NetSuite can handle invoices with up to 10,000 items. With this new feature, if a NetSuite invoice has more than 250 items, we can now create the invoice in Stripe with a default item.
This enhancement makes it easier to manage large invoices without any issues.
Configuration
This feature is part of the NetSuite Invoice to Stripe Invoice Add Flow. This flow retrieves invoices from NetSuite and creates them in Stripe.
Find the flow here
Navigate to Flows → Invoices → NetSuite Invoice to Stripe Invoice Add Flow.
- Navigate to Settings → Invoices → NetSuite to Stripe Tab
Enter the NetSuite Internal ID of the item in the field "Add internal ID of NetSuite Non-inventory Sale Item if the invoice has more than 250 line items." (This should be a Non-inventory item & will be used as the single item on the invoice when it is exported to Stripe)
How the Feature Works
The logic is handled in the NetSuite Export - Pre send Hook.
When the NetSuite Invoice to Stripe Invoice flow is run, it triggers the Pre send script. The script logic will first check whether the item's internal ID is present in the invoice settings. If it is present, the script will then check the number of items in the invoice.
If the invoice has more than 250 line items, the script will fetch the name of the item from NetSuite using the internal ID provided in the Invoice Settings. This default item will then be used when creating invoice items in Stripe, and it will store the total amount of the invoice.
If the invoice has less than 250 line items, all the NetSuite items will be sent to Stripe when creating the invoice items.
Conclusion
This new feature streamlines the process of handling large invoices by allowing the use of a default item when the invoice exceeds 250 line items. It ensures that invoices can be created in Stripe seamlessly while maintaining accuracy and simplicity in managing large invoices.