Viewing Lot Numbered Inventory Item Records

Use the following procedure to view lot numbered inventory item records.

To view lot numbered inventory item records:

  1. Go to List > Accounting > Items.

  2. Collapse the list of Filters and select Inventory Item as the Type.

  3. Beside the item, click View.

  4. The method to view lot numbered items by location depends on whether you use Bin Management or Advanced Bin / Numbered Inventory Management.

    If you use Bin Management, this information is located on the Purchasing/Inventory subtab.

    If you use Advanced Bin / Numbered Inventory Management, this information is located on the Inventory Detail subtab. This subtab also shows the purchase price of this lot item. All lots recorded on this item record use this purchase price for inventory costing purposes.

    Quantity On Hand

    Quantity On Order

    Value

    Quantity Committed

    Reorder Point

    Quantity Back Ordered

    Preferred Stock Level

     

  5. To view information about item lot numbers, click the Lot Numbers subtab.

    For example, quantity on hand per location.

  6. Click a lot number to open the lot number record.

    Lot number records identify item name, number, status, memos, and the following:

    • Inventory quantities – For each location the lot number record shows On Hand, On Order, and Available counts.

    • Expiration date – NetSuite can warn you when you sell a lot item that is close to its expiration.

    • Transaction history – On the lot number record, you can search transactions for specific information. Click Search Transactions to identify where and when each lot is received, stocked, transferred, built into assemblies, or sold. For example, you can use lot records to identify sales of a lot that needs to be recalled.

  7. (Optional) To keep track of a lot item’s expiration, you can do the following:

    • Identify items by printing labels that show lot numbers and expiration dates.

      To print labels, go to Transactions > Management > Print Checks and Forms.

    • Receive an expiration warning when a lot is about to expire.

      To set the preference to receive an expiration warning, go to Setup > Accounting > Preferences > Accounting Preferences. Click the Items/Transactions subtab. In the Days Before Lot Expiration Warning field, enter the number of days in advance of a lot item's expiration to receive a warning.

When you sell, receive, or fulfill an order, you can choose a specific lot. Then, lot numbers show on customer records in the list of items purchased. This lets you reference lot numbers to process returns or reply on support cases.

You can also assign a lot number to a group of assembly items you build, or include a lot item in a regular assembly build.

If you buy, stock, and sell lot items in differing quantities, you can enter a fractional amount of the item on transactions. For more information, see Selling and Fulfilling Lot Numbered Items.

You can use Multiple Units of Measure to assign units to lot numbered inventory.

You can use lot numbered inventory as members of Kit/Package items. For more information, see Entering Serial and Lot Components on the Item Record for the Kit.

Related Topics

Enabling Lot Numbered Inventory
Creating Lot Numbered Items
Receiving a Purchase Order With a Lot Numbered Item
Selling and Fulfilling Lot Numbered Items
Building a Lot Numbered Assembly
Selecting Lot Numbers on Transactions
Lot Auto Numbering SuiteApp
Allergen Statements SuiteApp
Lot Numbered Items

General Notices