Add a Lot-Numbered Unit with a NetSuite Inventory Adjustment

Add one unit with Adjust Inventory, assign the lot in Inventory Detail, and verify the assignment on the saved transaction.

The quick answer

On an Inventory Adjustment, enter the item, its line location and a positive Adjust Qty. By. Open Inventory Detail, assign the lot and quantity, then save. Reopen Inventory Detail on the saved transaction to verify the assignment.

A stock check finds one FG-40 Filter Cartridge at Harbor Depot. NetSuite shows zero on hand. The cartridge is lot-numbered, and the label shows FG-261113-A. This example uses Advanced Bin / Numbered Inventory Management and Inventory Status. The item does not use bins at Harbor Depot.

1. Set up the adjustment

Go to Transactions > Inventory > Adjust Inventory. Select your subsidiary and the approved Adjustment Account. Check the date and adjustment location. A memo such as “Found one cartridge during stock check” gives the next person a reason for the change.

2. Enter the item and quantity

On Adjustments, choose FG-40 Filter Cartridge. Select Harbor Depot on the line as well as on the header. Enter 1 in Adjust Qty. By. Check that Qty. On Hand shows 0 and New Quantity shows 1. Review the estimated unit cost for the increase.

Check the new quantity before assigning the lot.

3. Assign the lot in Inventory Detail

Open Inventory Detail on the line. Enter FG-261113-A in Serial/Lot Number and 1 in Quantity. Confirm Good in Status. Fill in the bin or expiration date when required for your item. Click Add in the popup, then OK. Back on Adjustments, click Add to commit the transaction line.

Click Add to commit the lot row, then OK to return to the adjustment.

4. Verify the saved assignment

Click Save. Check the confirmation and the new reference, 4120 in this example. Open Inventory Detail from the saved line. Verify FG-261113-A, Good, and quantity 1.

Use the saved reference to identify the adjustment.
Reopen Inventory Detail on the saved line and confirm the lot and quantity.

Common questions

What should the Inventory Detail quantities add up to?

For a positive adjustment, they should total the value in Adjust Qty. By. If you add units from more than one lot on the same line, assign each lot its own quantity.

Why is Inventory Detail missing or unavailable?

Confirm the item is numbered and Advanced Bin / Numbered Inventory Management is enabled. Enter the location and a quantity on the adjustment line before looking for its Inventory Detail icon.

Where do I verify the accounts and amounts?

Open GL Impact on the saved adjustment. Inventory Detail shows which lot, status, bin, and quantity the transaction used.