AX 2009 warehouse dropdown

[Justin Biggs]

I'm trying to figure out what's changed in how the dropdown is created for
the warehouse inventory dimension, but something has. If a user hits the *
key on an empty warehouse field, the lookup menu automatically opens, but
there's a problem. If the tab showing in the dropdown is the On Hand tab,
all of the records are summed into one record with an empty string as the
warehouse, which is not what is desired. Previously in version 4.0, hitting
the * key in this fashion would display all records and their on hand values.


Example: ItemA exists in warehouses 100, 200 and 300, with 50 qty each.

Version 4.0 results in dropdown grid:
Warehouse | Available Physical | Total Available
100 | 50 | 50
200 | 50 | 50
300 | 50 | 50

Version 2009 results in dropdown grid:
Warehouse | Available Physical | Total Available
| 150 | 150

Now switching tabs to the Warehouses tab, and back to On-Hand will then
display correctly, but that's two extra clicks that users have to perform.
In reality it's not a terrible workaround, but from a Salesperson's
perception (my users), AX 2009 has just trippled their workload
(exaggeration, yes, but that's the perception). I've been all over the
InventLocationIdLookup form, and I can't figure out what's different enough
that is causing this behavior. We do not have multi-site functionality
turned on, and the query for the InventDim datasource that's being executed
(which is joined to InventSum) is exactly the same as the equivalent 4.0
query (grouped on InventLocationId as expected). Any ideas would be
appreciated.

[a***@gmail.com]

Did you get solution for this Issue ?