Stopping Cash Refunds from Restocking Refunded Items
NetSuite Connector refund sync supports refund syncing either to or from NetSuite. The sync works only in one direction at a time per connector and the supported directions can vary by connector. When syncing refunds from NetSuite, you can decide whether an item will be restocked before NetSuite Connector refund sync is involved. However, when syncing refunds to NetSuite, you can make NetSuite automatically restock the refunded items that display in the cash refund records.
If you do not want NetSuite to automatically restock items when they appear on a cash refund, use one of the following options:
Creating a Return Location
You can create a return location in NetSuite for returned or refunded items and set that location on the line items of your cash refunds. You can create a mapping in NetSuite Connector to set that location on the items in the cash refund. This does not affect your salable inventory.
The following are the advantages and disadvantages of using this option:
-
Advantages:
-
Simple setup and configuration.
-
Lets you view the item record and see the quantity of item returned by looking at the quantity available in your return location.
-
Lets you dynamically decide whether to set the location using the data provided by the marketplace or cart.
-
-
Disadvantages:
-
Requires Multi-Location Inventory feature enabled in NetSuite.
-
Reports or other processes that tally inventory across locations must be adjusted to exclude the return location.
-
Before creating the return location in NetSuite Connector, identify or create a location that you want to use for returns in NetSuite.
To map a location for cash refund records:
-
Log in to app.farapp.com.
-
Select the connector and the relevant account.
-
Go to Mappings > Other Transactions.
-
Click the Transaction Item tab.
-
Click Add Mapping.
-
From the Transaction Type list, select Cash Refund.
-
From the NetSuite Field list, select Location.
-
Click Add Mapping.
The mapping is added to the Other Transaction Item Mappings page.
-
Click Close.
-
From the newly added row, click the dropdown list in the NetSuite Field/Fixed Value column and select the location that you want to use for returns.
If you created a new location in NetSuite and do not see it in the NetSuite Field/Fixed Value dropdown list, click Reload NetSuite Lists. After the reload process completes, check the list again.
-
Click Save.
Setting the Item Quantity to 0
An advantage of using this option is the simple setup and configuration. However, it comes with the following disadvantages:
-
You will not be able to tell how much quantity of the item was returned. This limitation may have reporting impact.
-
This option is not applicable to items that need inventory detail in NetSuite. The refund will result in an error because the required inventory details will not be found because the quantity has been set to 0.
To set the item quantity to 0:
-
Log in to app.farapp.com.
-
Select the connector and the relevant account.
-
Go to Mappings > Other Transactions.
-
Click the Transaction Item tab.
-
Click Add Mapping.
-
From the Transaction Type list, select Cash Refund.
-
From the NetSuite Field list, select Quantity.
-
Click Add Mapping.
The mapping is added to the Other Transaction Item Mappings page.
-
Click Close.
-
From the newly added row, in the NetSuite Field/Fixed Value column enter 0.
-
Click Save.