Mapping Restock Field for Item Receipts in NetSuite

TL;DR Opening

This article explains how to map the restock field on item receipts created during refund transactions in NetSuite to prevent items from being automatically restocked. Proper mapping is essential, especially for Amazon FBA orders processed with settlement sync.

How Does the Restock Field Mapping Work?

NetSuite Connector facilitates the creation of return authorizations and item receipts for Amazon FBA orders, particularly during refund transactions. As of recent updates, customers using connectors that previously created return authorizations with refunds will find that automatic functionality for this has been discontinued. Therefore, it's essential to manually configure the restock field mapping to ensure refunded items are not restocked inadvertently.

Here’s a simple procedure for mapping the restock field on refund item receipts:

Steps to Map the Restock Field

1. Log in to app.farapp.com.
2. Select the Amazon connector and then choose the relevant account.
3. Navigate to Mappings > Settlements.
   Note: For other connectors, go to Mappings > Other Transactions.
4. Click the Settlement Item tab.
   Note: For other connectors, click the Transaction Item tab.
5. Click Add Mapping to open the Add NetSuite Mapping popup window.
6. From the Transaction Type list, select Item Receipt.
7. From the NetSuite Field list, select Restock.
8. Click Add Mapping. A success message will confirm the action.
9. Click Close to finish this step.
10. Locate your new mapping in the settlement or transaction item mappings list. Under the NetSuite Field/Fixed Value column, select Unchecked to inform NetSuite not to restock items.
11. Finally, click Save to apply your changes.

Advanced Mappings

You can also create more complex conditional mappings by selecting Logic under the Mapping Type column in step 10. Keep in mind that these conditional mappings require specific data from the marketplace or cart on the refund receipt to function correctly. However, Amazon does not provide such data, so additional integration may be necessary for more advanced mappings with other connectors.

Who This Affects

• Administrators: Responsible for handling mapping settings and configurations.
• Developers: May need to customize connectors and logic for transaction handling.
• Order Management Teams: Ensure that refunds are processed accurately without affecting inventory management.

Key Takeaways

• Manually mapping the restock field prevents automatic restocking of refunded items in NetSuite.
• The procedure varies slightly for different connectors but follows similar basic steps.
• Advanced mapping allows for conditional logic but may depend on available data from external platforms.

Source: This article is based on Oracle's official NetSuite documentation.