Welcome to the QuickBooks Community, RichardsNguyen.
Thanks for adding a screenshot and all the information you've provided for me to understand the situation. I’d be glad to clarify why there are positive and negative entries on the Quick View report.
This can happen when the lot number is duplicated. Let’s run the Transactions List by Lot Number Report to check if this case.
Here's how:
- Go to Reports at the top menu bar, select Inventory.
- Choose Transaction List by Lot Number.
- Click the Item drop-down arrow and select the product you’re working on.
- Click the Lot Number drop-down arrow and select the appropriate lot.
- Select OK.
If the report shows that there’s a duplicate, remove the items and assign it to the correct Lot Number. I'll walk you through the steps:
- Go to Inventory at the top menu bar, then choose Adjust Quantity/Value on Hand.
- Click the Adjustment Type drop-down arrow and select Lot Number.
- Enter the date of the adjustment.
- Click the Item column to add items.
- Click the Lot Number field and enter the correct lot number.
- In the New Count field, enter the total number of items to assign or remove.
- To zero-out the quantity on an existing lot, enter 0.
- Then save the adjustment.
There you go. When running the Quick view report, the items should show the correct lot number and quantity as well.
Keep me posted on the results. I’ll be on the look out for your response.
