Scenario:
The user discovered that a Sales Order fulfilled several months earlier was shipped using the wrong serial number. The accounting period was already closed, and the goal was to correct inventory tracking and reporting so the correct serial number would be associated with the customer without creating unnecessary RMAs, credit memos, or transaction reversals.
Solution:
NetSuite does not provide a simple native method to directly replace or relink serial numbers on an already fulfilled Sales Order after fulfillment has been completed.
A recommended workaround is to use an Inventory Adjustment to correct the serial number inventory records.
Recommended process:
- Create an Inventory Adjustment to:
- Remove the incorrect serial number
- Add the correct serial number back into inventory
- Ensure the positive adjustment uses the same unit cost as the negative adjustment.
- If using Average Costing:
- Date the negative adjustment on Day 1
- Date the positive adjustment on Day 2
- This allows NetSuite to properly recalculate average costing
Important limitation:
- The corrected serial number will not become directly linked to the original Sales Order or Item Fulfillment transaction.
- Updating the historical fulfillment transaction itself would generally require:
- Deleting and recreating the original transactions
- Reopening accounting periods
- Reprocessing fulfillment activities
Because of the operational and accounting impact, recreating historical transactions is typically not recommended.
Best Practice:
- Use Inventory Adjustments to correct serial number inventory tracking
- Add detailed Memo or User Notes referencing:
- The original Sales Order
- Incorrect serial number
- Corrected serial number
- Reason for adjustment
This approach preserves inventory accuracy while minimizing disruption to historical financial and fulfillment records.