We have activated batch tracking in Zoho Inventory.

To reconcile our inventory with the physical stock reported by our 3PL, we need a report showing the total physical quantity still present in each warehouse, broken down by batch.

This quantity is the sum of:

• the available batch quantity; and
• the batch quantity packed but not yet shipped.

Unfortunately, the standard Batch Details report seems to show only the available batch quantity. Quantities already assigned to Packages are no longer available, even though they are still physically present at the 3PL until shipment.

Has anyone faced the same issue? Is there a standard report or a simple workaround to obtain the physical stock by warehouse and batch?