Get 50% OFF QuickBooks for 3 months*

Buy now
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Work smarter and get more done with advanced tools that save you time. Discover QuickBooks Online Advanced.

Reply to message

View discussion in a popup

Replying to:
Angelyn_T
Moderator

Reply to message

Good day, alondon. Generating your report that displays the quantity of your item by lot number is my top priority today.

 

I know how important it is for you to generate a report in Advanced Reporting that sorts the quantity of each item by lot number. While the field is unavailable, you can run the Item Listing report to generate this information. Then, add the Lot NumberQuantity on Hand, and other columns you want to show to narrow down the result. Here's how:

 

  1. Open your QBDT file.
  2. Tap on Reports, then select Item Listing from the List menu.
  3. Customize and filter the data by clicking on Customize Report.
  4. Review the information provided.

 

From there, you may also click on each lot number to verify the item details.
 

For more tips while running your inventory reports in our system, you can open this article: Create and run inventory reports.

 

Moving forward, you may save the current customization settings of your report to save time in the future. See this article as your reference: Create, access, and modify memorized reports.

 

 If you have other questions in mind regarding your inventory entries, let me know by leaving a comment below. I'm more than happy to help you again. Have a good one!

Need to get in touch?

Contact us