While creating deposits in NetSuite, the Shopify “Payout to Reconciliation” add-on now considers the line-level mappings that are added for payments, cashback, and other deposits. You can now add line-level details on the deposit record by adding the required line mappings to the Shopify Payout Transactions to NetSuite Deposit flow.
By default, the Integration App considers the “cashback” line-level mappings to map all the cashback or other line items. If the cashback line-level mapping is not available, then the Integration App checks for any other import mappings provided by you and update all the other cashback and other line items.
The Shopify Payout Transactions to NetSuite Deposit flow considers the line-level mappings as follows:
- If the custom line-level mappings are added only for the cashback lines, all the cashback and other deposit lines on the deposit record will have details as per the cashback line-level mappings.
- If the custom line-level mappings are added only for the other deposit lines along with the required reference mappings, all the cashback and other deposit lines on the deposit record will have details as per the other deposit line-level mappings.
- It is recommended not to add custom line-level mappings for cashback and other deposits simultaneously. If the custom line-level mappings are added for both cashback and other deposits, the flow doesn’t consider any of the mappings and sync empty record value.
Example: As per the below table, the “Department internal ID” that is 5 is mapped to all the cashback and other deposit lines.
|
Export field (Shopify) |
Import field (NetSuite) |
|
“5” |
Cash Back : Department (InternalId) |
|
“1” |
Payments : Currency (InternalId) |
|
“6” |
Other Deposits : Location (InternalId) |
|
“4” |
Other Deposits : Department (InternalId) |
The mapped value is applied to all the other lines within the same tab while creating the deposit record.
Important: If you’ve not added the cashback custom line-level mappings, the Shopify Payout Transactions to NetSuite Deposit flow checks for the “other deposits” mappings. The recommended format for the “other deposits” mappings is:
|
Export field (Shopify) |
Import field (NetSuite) |
|
other[*].account |
Other Deposits : Account (InternalId) |
|
other[*].amount |
Other Deposits : Amount |
|
“20” |
Other Deposits : Class (InternalId) |
|
“4” |
Other Deposits : Department (InternalId) |
As per the above table,
- For cash back, the Cash Back : Account (InternalId) and Cash Back : Amount mappings already exist by default in the backend code. You need not add it again in the flow mappings. The flow verifies the Other Deposits : Account (InternalId) and Other Deposits : Amount mappings for reference.
- The Other Deposits : Class (InternalId) and Other Deposits : Department (InternalId) mappings are mapped under the “Other Deposits” and “Cashback” tabs in NetSuite.
You can add the line-level mappings either for cashback or payment or other deposits. If you add the same property for cashback, and other deposits, the preference is given to the “cashback” mappings.
- As mentioned in the above table, if you have the same mapping (Department) for cashback and other deposits, the preference is given to the Cash Back : Department (InternalId) mapping.
- The Cash Back : Account (InternalId) and Cash Back : Amount mappings already exist by default in the backend code. It is recommended to not add these mappings again in the flow’s mappings. If you add, the flow does not sync the custom values for any of these mappings to NetSuite, under the Cashback and Other Deposits tabs.
- If a mapping already exists in the backend code (example: _keys, docnumber, id), and if you’re adding it again via import mappings, in that case, the preference is given to the mappings that are already present in the backend code.
Comments
0 comments
Please sign in to leave a comment.