QuickBooks HelpQuickBooksHelpIntuit

Use the Inventory Stock Status by Lot Number report in QuickBooks Enterprise 24.0

by Intuit Updated 6 months ago

Learn how to track all of your inventory items grouped by lot numbers, using the Inventory Stock Status by Lot Number report.

You'll need to turn on Lot number tracking first, then you can run the report. Here's how:

  1. Go to Edit, then select Preferences.
  2. Select Items & Inventory, then select Company Preferences.
  3. Select Inventory and purchase orders are active.
  4. Select Advanced Inventory Settings, then select Serial/Lot Number & Expiration Dates.
  5. Select Activate Lot or Serial Numbers then select Lot Numbers.

Add Item with Lot number(s) and quantity

  1. Go to Lists then Item List.
  2. Select Item, then New.
  3. Select Type then Inventory Part. Enter the item name into Item Name/Number.
  4. Select the income account you want the item to associate with and select OK.

To receive items,

  1. Go to Inventory.
  2. Select Receive Items, then Bill received.
  3. Go to Vendor then select a vendor or Add New to create a new one.
  4. Go to Items and select the items received.
  5. Enter the quantity received, costs, and Lot numbers for the item(s).
  6. Select Save & Close.

Use Lot numbers in sales orders

  1. Select Customers then Create Sales Orders.
  2. Go to Customer/Job then select a customer or Add New to create a new one.
  3. Go to Item then select the items to be sold.
  4. Enter the Ordered quantity, then select the Lot number and rthe Rate.
  5. Select Save & Close.
  1. Go to Customers and select Create Sales Orders.
  2. Select a Customer/Job or Add New to create a new one.
  3. Select Item to be sold.
  4. Enter the Ordered quantity and select the Lot number and the Rate.
  5. Select Save & Close.

Open the report

  1. Go to Reports and select Inventory.
  2. Select the Inventory Stock Status by Lot Number report.

Now you should be able to see the report with the item, the Lot number(s) it has, its Quantity on Hand, the associated Sales Order, and what’s available for each.

How does this new report help you?

The new Inventory Stock Status by Lot number helps y0u:

  • Get enhanced visibility into your inventory levels including quantity on hand, quantity on the sales order, and quantity available.
  • See all your inventory items grouped by lot number right from QuickBooks and make informed decisions.
  • Use the customize report filter to find the relevant lot number, rather than checking all lot numbers.
  • Watch expiration dates of inventory items by lot number and reduce the possibility of selling expired items.
QuickBooks Enterprise Accountant QuickBooks Enterprise DiamondQuickBooks Enterprise GoldQuickBooks Enterprise Platinum

Sign in now for personalized help

See articles customized for your product and join our large community of QuickBooks users.

More like this