You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

How to get consolidated data for multiple Batch number in Inventory Discrepancies screen?

edited Nov 5, 2025 7:43AM in Warehouse Management

Summary:

We have Inventory Discrepancies screen in WMS which shows the on hand Discrepancies between WMS and Fusion Inventory. But we are getting the on hand divided as per batch number (lot number), we are looking for an option to get a consolidated on hand discrepancy for a set of Item, Organization and Subinventory.

For example,

If there is Item '00132-00', Organization 'G' and ERP Bucket 'ENT'. Total on hand is 16400 Qty with 6150 Qty under batch number 156252 and 10250 qty under 155853. For this we are getting two records (lines) but We need a single consolidated record with total 16400 Qty without Batch Number details.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!