Inventory Doesn't Match Up to Physical Stock

I noticed this issue several times where my inventory doesn't actually match up to the physical stock we're supposed to have

In the Fifo Cost Lot Tracking repot - For a specific SKU item in the report it shows for a specific invoice I sold 88 units of that item. But when I click into the actual invoice the units sold for that item in that invoice is 110 units

If I remember correctly, the marginal error is usually by increments of how much units are in one item.

Most of the time it shows I have one case more than what I actually have

Here are Google Drive links to the screenshots (Information omitted for privacy)

Screenshot of Report:

https://drive.google.com/file/d/1H20kuixuvqfHHoCZ5XxCPBXzv2DqZZX6/view?usp=share_link

Screenshot of Invoice:

https://drive.google.com/file/d/1w_ATtTBkAMaBRvMIGUCsqmROxTPrnSlR/view?usp=share_link

Discrepancy highlighted in yellow. As you can see in the report it shows that for INV-84710 sold 88lbs/units

But on the actual invoice when I click into INV-84710 shows 110lbs/units were sold. Now I am left with an incorrect inventory balance

It has caused a lot of problems. We still have not fully migrated over to Zoho for this very reason. The inventory in Zoho oftentimes doesn't matche up to the inventory to our old system (which is usually the accurate one)

Does anyone know what the problem might be? Thanks for your help in advance

Zoho Desk Resources

Desk Community Learning Series
Digest
Functions
Meetups
Kbase
Resources
Glossary
Desk Marketplace
MVP Corner
Word of the Day

Topic Participants
Mike
Akshaya G

Sticky Posts
Zoho Inventory will discontinue support for older browser versions soon
Hello users, Starting from May 15, 2024, Zoho Inventory will no longer support the following browser versions: Browsers Version Restrictions Firefox Browser Versions older than 100 Google Chrome Versions older than 100 Microsoft Edge Versions older than
Zoho Finance Workshop 2023 is coming to the USA. Meet the experts, get exclusive training on Zoho Finance apps and more.
Hello all, We'd like to invite you to our biggest Zoho Finance workshop in the United States. After a brief break, we are excited to be back. This year, we're bringing together our customers and community members for two days of curated hands-on sessions,
Celebrating our Zoho Community SuperBuds
The SuperBud program recognizes the efforts Zoho users put in to help the rest of the community thrive and grow in their individual Zoho journeys. Be it the ZUG meetups or these forums, several Zoho users including our MVPs andZUG leaders, have stepped
Authtoken Deprecation for Zoho Inventory APIs
UPDATE (7 July 2021): We've extended the deadline to 30 August 2021 for converting Authtokens to OAuth. Hello everyone, The usage of Authtokens to authenticate API calls is being deprecated on 30 August 2021 across Zoho's Finance suite of products,
ZOHO Inventory - Early Access
https://twitter.com/zoho/status/646715717849493504