Inventory is not matching up

Thank you for providing the screenshot, gjy. It appears there is some inconsistency in the information displayed. Let's address this issue by following the troubleshooting steps I'll outline below.

Given the inconsistency observed in your inventory data, a Verify and Rebuild operation in QuickBooks is recommended. This process will scan your company file for any potential data issues and repair them. With the inventory counts not aligning as expected in Lot #100, this procedure is crucial.

To Verify your company file, here's how:

1. Go to Window and Close All. 
2. Navigate to File, then select Utilities. 
3. Click Verify Data. Moreover, if you see:

• QuickBooks detected no problems with your data - this means that your data is clean, and you don't need to do anything. 
• If there is an error showing - search it on our QuickBooks Desktop support site to know how to resolve it.
• Your data has lost integrity - There is a data damage in your file. If this happens, consider rebuilding your data.

To Rebuild your company file, please follow the steps below:

1. Navigate to File, choose Utilities, and then select Rebuild Data.
2. QuickBooks will prompt you to create a backup before rebuilding your company file. Click OK. A backup is mandatory before proceeding.
3. Choose a location to save your backup and click OK. Ensure you don't overwrite an existing backup file. Provide a new name in the File Name field and click Save.
4. Once the rebuild is complete, you will see a message indicating Rebuild has completed. Click OK.
5. To check for further issues, go back to File, select Utilities, and then choose Verify Data.

• If the verification process detects more errors, you'll need to address them manually. Locate the errors in the qbwin.log by searching the QuickBooks Desktop support site for solutions.
• If the error isn't listed or persists, consider restoring from a recent backup. Go to File and select Open or Restore Company.

For reference, here's an article you can check: Verify and Rebuild Data.

Additionally, below are some helpful articles that you can review and bookmark for guidance on managing your inventory stock in QuickBooks:

• Adjust your inventory quantity or value in QuickBooks Desktop
• Fix negative inventory issues in QuickBooks Desktop

You're free to comment on this post if you have further questions about managing your inventory items in QuickBooks, gjy. I'll be here to help you out anytime.

@gjy 

Run the Verify/Rebuild Data utility. Any error message?