Scenario
Users may experience having a Sales Order and when they click on the "Fulfill" button, it generates a record with pre-populated Serial Numbers in the Inventory Detail, however, when trying to save the Item Fulfillment, the error "The following inventory numbers are not available: XXX"
Solution
When this happens, it is possible that the serial numbers have been added in multiple Sales Orders/transactions before any fulfillment and later on one of the Sales Orders is fulfilled.
The first approach we can do is to
- ) Go to the Item record > Inventory Detail
- ) Click on any of the affected Serial Number hyperlink. A pop-up will appear showing the Serial Number Record
- ) Click on the Search Transactions button
It will show you the list of transactions where this Serial Number is associated. We can start reviewing the list if another Item Fulfillment is already associated to it.
Here is an example:
Let's use NSC Serialized Item with Serial Numbers NSC1, NSC2, NSC3 for Location California.
Item Record:
First Sales Order:
Second Sales Order:
Let's say for example that we have already fulfilled the first order. Now, let's try to fulfill the second order.
Upon clicking the Fulfill button, IF form pops up and when we check the Inventory Detail, Serial Numbers are already populated.
But when we save the record, this error pops up:
Let's apply the tip above.
1.) Go to the Item record > Inventory Detail and click on any of the affected Serial Number hyperlink.
2.) A pop-up will appear showing the Serial Number Record
3.) Click on the Search Transactions button
We can confirm from the list that this specific Serial Number is already associated with an Item Fulfillment.
Do you have easier approach on how to discover similar instances? Feel free share them in the comment section!