Hello
Want to create an “InventOnHand” view in AX2012 R3, with similar information / fields on the InventOnhandItem form, the Fieldlist in the view should look like:
ItemId
InventLocationId
WMSLocationId
InventStatusId
PhysicalInvent
ReservPhysical
AvailPhysical
OrderedSum
OnOrder
ReservOrdered
I am aware that changes has been made in R3 so you just cant select values directly from InventSum, but has to utilize the InventAvailablility Framework. Well this is ok for Forms, reports ect where Display methods can be used, but how can I get the correct figures in my view using e.g view methods and SysComputedColumn. As far as I can see I need InventSum, InventDim and WHSInventReserve table to my view. Are there any existing views or queries already offer this information - so I dont have to build all up from schratch ?