Issue: The date that the settlement is running is the date that transactions are posting rather than the date of the transaction from the settlement report.
Resolution: Insert additional columns to "Refund Saved Search" (Celigo AmazonIO Settlement Refund Transaction ...)
1. Go to "Payment Saved Search" (Celigo AmazonIO Settlement Payment Transaction ...)and add these two additional columns.
1. Settlement Deposit Date: The Deposit Date on Settlement Summary record.
2. Transaction To Reconcile Date: The 'trandate' Date of Transaction To Reconcile "Invoice" record.
2. Next, you can map the Date in the refund flow with either of the above columns, depending on your needs. Eg. We want to use the date on "Transaction to Reconcile".