How to Define Return Item Cost for Cross-Location Returns in NetSuite?

For NetSuite accounts provisioned with Version 2007.1.0 or later, NetSuite can use the exact cost from the original sale for returns that are linked to the sale, even if the return location differs from the original sale location. However, for specific costing requirements or in scenarios where returns are not directly linked to the original sale, defining the value of returned inventory may require alternative approaches. The following options are available to define the value of inventory returned to a different location:

1. Manual Override:

   Users can manually enter a value in the Override Rate column on the Return Authorization (RMA)'s Item Receipt. This is a standard column that must be made visible on the form to allow for manual input.

2. Default Return Cost by Location:

   A Default Return Cost can be set by location directly on the item record. When this is configured, NetSuite automatically populates this rate into the Override Rate column when an item is returned to a different location. If the item's cost fluctuates, a mass update can be utilized periodically to adjust this default value.

3. Automated Scripting:

   For organizations requiring the exact original value to be re-added into inventory without manual user intervention, a script can be developed. This script can be designed to search for and retrieve the original Sales Order's fulfillment cost, then automatically set this value on the RMA's Receipt lines. This automation can be triggered on the BeforeSubmit event of the RMA Receipt, ensuring the exact value is applied without additional user steps beyond receiving the items.