Articles in this section

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.
      Settlement_transactions_import.png
    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.
      Transaction_date_mappings.png
    5. In the Export Date Format field select YYYY-MM-DD as the date format and click Save.
      Transaction_date_mapping_format.png
    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:
    15.jpg
    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’)
Was this article helpful?
1 out of 1 found this helpful

Comments

0 comments

Please sign in to leave a comment.