Articles in this section

Substitute Item for Serialized, Bin, or Lot Item in NetSuite to execute settlement flows

The Substitute Item for Serialized/Bin/Lot Item in NetSuite field in  Settings > Settlements > Refunds tab, allows you to enter the internal id of an item record (Inventory or Non-inventory).  When the settlement flows are executed, the Integration App creates a credit memo for the invoice by replacing Serialized, Bin, or Lot Numbered Items with the item defined in this field. The amount on the credit memo remains the same as provided in the settlement report with the quantity listed as zero.

Steps depicting the flow run to handle

Let assume the settlement report contains the following data:

settlement-id

transaction-type

order-id

merchant-order-id

amount-type

amount

SKU

6348143372

Refund

106-7708283-3047234

106-7708283-3047234

ItemPrice

-13.49

OZ-BM-BB-1014A

  1. Navigate to the Settings > Settlement > Refunds tab.
  2. Enter the internal id of the item you wish to use as the default replacement item for Serialized, Bin, or Lot Items in the Substitute item for Serialized/Bin/Lot Item fieldBINSettings.png
  3. After making required configuration changes in the settings for the Settlement flows, click the Run button against the Amazon Settlement Report to NetSuite Custom Settlement Records flow.

    Settlement flows get triggered on the Dashboard page. Wait for flow to run successfully.DashboardSettlements.png

  4. Verify the line item details in the invoice against the line item details in the credit memo.

Line item information in the invoice: Displays the default item for which the order was placed.
AS3.jpg

Line Item information in Credit Memo: Displays the dummy item whose internal id you have entered in the field along with Refund amount matching with the amount in settlement report.
AS4.jpg

 

Was this article helpful?
0 out of 0 found this helpful

Comments

0 comments

Please sign in to leave a comment.