Once the NetSuite Settlement Transaction to NetSuite Refund Add flow has run successfully, the integration app automatically triggers this flow. When this flow is run, the integration app accesses all settlement report records created within 2 months duration from flow run date and updates the summary record with updated values. The updated summary record provides the information needed to reconcile the settlement. To post the settlement amounts to NetSuite G/L accounts, run the NetSuite Settlement Summary Record to NetSuite Journal Entry flow, which creates a journal entry from the summary record. For more information, see Manage journal entries in NetSuite.
Criteria for settlement summary report selection during flow run
The Celigo AmazonIO Settlement Summary Processing record in NetSuite controls which payment transaction records, among all the Celigo Amazon Settlement Summary records present in NetSuite, are selected by the flow to be updated. The following screenshot of Celigo AmazonIO Settlement Summary Processing in NetSuite displays the criteria based on which the summary record is selected:
Impact of flow on transaction record in NetSuite
-
Celigo Amazon Settlement Summary record before the flow run
The following screen displays the Celigo Amazon Settlement Summary record after the Amazon Settlement Report to NetSuite Add flow run. You can see that none of the fields except the values in the General and Deposits pane have any value. Even no value exists in the Transactions, Fees, and Other Transactions tabs.
-
Impact of this flow runs on the Celigo Amazon Settlement Summary record
When you run the NetSuite Settlement Summary Report Update flow, it updates the following panels and tabs in the Celigo Amazon Settlement Summary record as shown in the following screenshot:- Deposits
- Orders
- Refunds
- Non Transactions (Other Charges and Misc Fees)
- Transactions
- Fees
- Other Transactions