Finding the Total Available and Available physical for an Item/Warehouse

axapta dynamics-ax-2009
AnthonyBlake picture AnthonyBlake · Jan 27, 2012 · Viewed 14.8k times · Source

I have a method for a display field which does the following;

return InventSum::find(_salesLine.ItemId, InventDim::_salesLine.InventDimId).AvailPhysical();

This gives me the on-hand Available Physical for the line site/warehouse/location.

I need to see the total available for just the site/warehouse. I think I need to search inventDim by Item/Warehouse to get my inventdimid, but I cannot find the method so I am suspicious that this is incorrect.

Can anyone help?

Answer

AnthonyBlake picture AnthonyBlake · Jan 30, 2012

My working solution... 

InventDimParm       invDimParm;
InventDim           warehouseInvDim;
InventDim           salesLineInventDim;
;

salesLineInventDim = _salesLine.inventDim();

warehouseInvDim.InventSiteId = salesLineInventDim.InventSiteId;
warehouseInvDim.InventLocationId = salesLineInventDim.InventLocationId;

warehouseInvDim = InventDim::findOrCreate(warehouseInvDim);
invDimParm.initFromInventDim(InventDim::find(warehouseInvDim.inventDimId));

return InventSum::findSum(_salesLine.ItemId,warehouseInvDim,invDimParm).availOrdered();

I know this is for availOrdered() but it works exactly the same for availPhysical()

Related questions

How to find a table name by ID in Dynamics AX

Each table in the AOT has an ID, how can I discover the table name given an ID?

Read More
Can I code in .NET/C# for Microsoft Dynamics AX?

I am a C# developer and want to start learning Dynamics AX. Please guide me can I use my .net/C# skills (knowledge of API) in Dynamics AX ? I know AX is developed in X++ but some one tell me …

Read More
How to pass a parameter between two forms in Axapta?

How can i pass a single parameter between a form in axapta ? I want to run a Form B from a clicked button event in a Form A and pass... for example the customer id ? How can i read it …

Read More