Articles in this section

Change NetSuite creation date to Amazon "Posted Date" for settlement payments and settlement refunds transactions

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.Amazon_settlement.png

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".

Screen_Shot_2018-03-01_at_2.37.50_PM.png
Was this article helpful?
1 out of 1 found this helpful

Comments

0 comments

Please sign in to leave a comment.