In the Inventory Summary screen(IN401000), only warehouses/locations with available quantity or on-hand quantity for an item are displayed in the grid section. Warehouses with zero quantity are not listed.
We have added some custom fields to the grid for calculating sales amounts, and we need to display these calculations for all warehouses, regardless of whether they have any quantity available.
However, we are unable to determine the logic that restricts warehouses with zero quantity from appearing in the results. There are some aggregate methods applied to the "Site" and "Location" fields. We’ve attempted to modify the logic but have not achieved the desired outcome.
Could anyone provide suggestions or guidance on what might be needed to display all warehouses for an item in the Inventory Summary screen?
Thank you in advance for your help!
