InventDimOnHand Class AX 2012 R2

hello guys,

In the method “queryDimParm” of the clas “InventDimOnHand”.

How can I get the Products inventory Sorted by the available pyshical?

For example in the inventory I have this:

|Item| inventConfigId| InventSizeId | InventColorId | InventStyleId | InventSiteId | InventlocationId | InventBatchId | available

Item1 800 2 1 01 PT 00001 3

Item1 800 2 1 01 PT 00005 76

Item1 800 2 1 01 PT 000011 34

I wanna this order bye available:

|Item| inventConfigId| InventSizeId | InventColorId | InventStyleId | InventSiteId | InventlocationId | InventBatchId | available

Item1 800 2 1 01 PT 00001 3

Item1 800 2 1 01 PT 000011 34

Item1 800 2 1 01 PT 00005 76

help me please.

Thanks

|Item| ConfigId| SizeId | ColorId | StyleId | SiteId | locationId | BatchId | available

Item1 800 2 1 01 PT 00001 3

Item1 800 2 1 01 PT 00005 76

Item1 800 2 1 01 PT 00011 34

I wanna this:

|Item| ConfigId| SizeId | ColorId | StyleId | SiteId | locationId | BatchId | available

Item1 800 2 1 01 PT 00001 3

Item1 800 2 1 01 PT 00011 34

Item1 800 2 1 01 PT 00005 76

If you look at \Classes\InventOnHandQty\availPhysical, it been a calculation.

Use the inventDimOnHandIterator to loop through the onhand qty’s and store them in a temp table and then apply an order by on qty.

inventDimOnHand = InventDimOnHand::newAvailPhysical(…)

inventDimOnHandIterator = inventDimOnHand.onHandIterator();

while (inventDimOnHandIterator.more())

Reference, \Classes\WMSPalletListDP\processReport

A little late reply.

But that’s what I did.

Thanks anyway.