📘 Scenario:
During a physical stock reconciliation, the client aimed to reset the inventory of specific items to zero. While performing the Inventory Adjustment in NetSuite, they encountered the error message:
“The following Bin numbers are not available.”
This happened when trying to select bins from the Inventory Detail window—even though those bins appeared in the dropdown, they had no available quantity. This mismatch between what was shown and what was actually available prevented successful adjustment.
🛠️ Root Cause:
The issue occurred due to mismatches between bin-level and location-level inventory balances, often caused by:
- Past bin transfers without proper updates,
- Negative quantities in some lots or bins,
- Residual bins still appearing due to historical transactions.
Even when the overall inventory at the location was zero, bins with leftover or incorrect lot associations still appeared, leading to the validation error.
✅ Solution:
- Inventory Balance Saved Search
- Created a saved search to check the actual quantity of bins and lots:
- Navigation: Lists > Search > Saved Searches > New > Inventory Balance
- Filtered on affected item IDs.
- This search helped identify bins/lots with negative or inconsistent quantities.
- Identify Bin/Lot Mismatches
- Used the saved search to find which bins or lots had incorrect quantities that didn’t align with the item or location totals.
- Bin Putaway (if needed)
- For items where a lot number had no associated bin, performed a Bin Putaway to associate the lot to a proper bin.
- Reverse Inventory Adjustment
- Adjusted bins or lots with negative quantities by adding the offset value to bring their total to zero.
- Final Zero Adjustment
- Once all bins and lots were cleaned and aligned, performed a final Inventory Adjustment to reset the item quantities to zero.
- Used Same IA Record for All Items when performed on same day
- Ensured all corrections and adjustments were done in a single Inventory Adjustment record for audit clarity.
Additional Notes:
- Refer: SuiteAnswer 62364 – Location and Bin On Hand Mismatch Solution