Tracking individual Stripe transaction types into separate accounts within NetSuite Deposit, including those specified in the configuration settings, would be a valuable integration for improving payout tracking and reconciliation.
The following changes are made to accommodate the above functionality.
Addition of Mappings in Settings
Below are the additional Mappings provided to transfer individual Stripe transaction types into specific Netsuite Accounts.
Settings
To configure this feature go to Settings => Stripe Type to NetSuite Account Mappings
- Select the individual stripe fee type name along with the corresponding NetSuite account name and save the mappings.
- This setting supports the following Stripe transaction types:
- Application Fee (application_fee)
- Stripe Fee (stripe_fee)
- Payment Refund (payment_refund)
- Payment Failure Refund (payment_failure_refund)
- Adjustment (adjustment)
- Refund (refund)
- Charge (charge)
- Payment (payment)
- Transfer (transfer)
- Transfer Refund (transfer_refund)
- Reserve Transaction (reserve_transaction)
- Application Fee Refund (application_fee_refund)
- Financing Paydown (financing_paydown)
- Network Cost (network_cost)
Flow mapping changes
Import - Add a Deposit into NetSuite Mapping:
Account mappings for payment, deposit, and cash sale are added and the value is read dynamically whereas the cashback account which was previously hardcoded to a value is now being passed dynamically.
Import - Add Stripe Refund Transactions into Deposit Mapping:
Account mappings for payment and cash refund are added and the value is read dynamically from the mapping of refund accounts present in settings.
The source record field of the above-highlighted fields is modified
from
{{#compare pageIndex "==" 0}}{{#compare depositId "!=" ""}}true{{else}}false{{/compare}}{{else}}false{{/compare}}
to
{{#compare pageIndex "==" 0}}{{#if depositId}}false{{else}}true{{/if}}{{else}}false{{/compare}}
Script Changes
- The financing paydown pay type is removed from functionality and change for this is made in the post map hook of the flow
- If any extra mappings are added in the Celigo platform, the mappings are passed to NetSuite Deposit record.