NetSuite Settlement Summary Report Update

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 access all settlement report records created within 2 months duration from flow run date and updates the summary record with updated values. The integration app does not perform the reconciliation by creating journal entries. You need to manually create the journal records in NetSuite, but the integration app does provide all the required information to make the reconciliation process easy and quick.

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