Stopping Cash Refunds from Restocking Refunded Items
NetSuite Connector refund sync lets you sync refunds either to or from NetSuite, but only one direction at a time per connector. The allowed directions can vary by connector. When syncing refunds from NetSuite, you can decide whether to restock an item before NetSuite Connector refund sync is involved. But when syncing refunds to NetSuite, you can have NetSuite automatically restock the refunded items shown in cash refund records.
If you don't want NetSuite to automatically restock items on a cash refund, use one of these options:
Creating a Return Location
You can create a return location in NetSuite for returned or refunded items and set that location on your cash refund line items. Then, create a mapping in NetSuite Connector to set that location on the cash refund items. This won't 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 decide on the location dynamically by using marketplace or cart data.
-
-
Disadvantages:
-
You'll need the Multi-Location Inventory feature enabled in NetSuite.
-
You'll need to adjust reports or other processes that tally inventory across locations to exclude the return location.
-
Before creating the return location in NetSuite Connector, pick or create a location in NetSuite for returns.
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 don't see it in the NetSuite Field/Fixed Value dropdown, click Reload NetSuite Lists. Once it finishes, check the list again.
-
Click Save.
Setting the Item Quantity to 0
An advantage of this option is it's simple to set up. However, there are some drawbacks:
-
You won't be able to see how much of the item was returned, which may affect your reports.
-
This option doesn't work for items that need inventory detail in NetSuite. The refund will error out because the required inventory details won't be found after setting the quantity 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.