Change refund 'Date (trandate)' to settlement transaction posted date or settlement deposit date

In general, when the transaction record is created in NetSuite, the transaction creation date is used for Settlement Deposit Date and Reconciliation Date rather than the date mentioned in the settlement report.

Perform the following steps to handle this issue and to update Settlement Deposit Date and Reconciliation Date as per the date mentioned in the settlement report:

• Changes required in the NetSuite Settlement Transaction to NetSuite Refund Add flow’s Field Mappings
  1. Go to Flows > Settlement > NetSuite Settlement Transaction to NetSuite Refund Add.
     
  2. Click Import Mapping.  The mappings page is displayed.
  3. Add new mapping as follows:
     

     Export Field (NetSuite)	Import Field (NetSuite)
     Transaction To Reconcile Date or Settlement Deposit Date	Select Date from the drop-down menu.

  4. Click the Settings icon. The Settings page is displayed.
     
     
  5. In the Export Date Format field select YYYY-MM-DD as the date format and click Save.
     
     
  6. On the Mappings page, click Save & Close.
     

To add the actual refunded date as the credit memo date, perform the following:

1. In the Settlement section, click on the Edit Mappings icon next to the "NetSuite Settlement Transaction to NetSuite Refund Add" flow.

2. On the "Please select which mapping you would like to edit" window, click Edit Mappings next to the "NetSuite Credit Memo Import".
3. Add the following mapping:
   

   Export Field (NetSuite)	Import Field (NetSuite)
   PostedDate	Date

4. Click Settings next to the newly added mapping.
5. On the Settings window, in the Export Date Format drop-down list, select YYYY-MM-DD.
6. Click Save.
7. On the mappings window, click Save & Close.

• Changes Required in Saved Search
  In NetSuite, open the Celigo AmazonIO Settlement Refund Transaction saved search and go to the Results sub-tab. From the list of columns available, ensure that the following columns are also available:
  
  If not add new rows and in the Formula column enter the following formula
  
  Settlement Deposit Date
  
  TO_CHAR({custrecord_celigo_amzio_set_summary.custrecord_celigo_amzio_set_sum_settl_dd}.’YYYY-MM-DD’)
  
  Transaction To Reconcile Date
  
  TO_CHAR({custrecord_celigo_amzio_set_ trans_to_rec.trandate}.’YYYY-MM-DD’)