InventDimJoinMacro InventDimJoin is used to link any table with an InventDimId field with the inventDim table.
The macro accepts four to five parameters
InventDimId
InventDim
InventDimCriteria
InventDimParm
Index hint (optional)
InventDimId
This is the unique key to the inventory dimension table and used to join InventDim table.
InventDim
Buffer of the inventDim table, you like to use in the join.
InventDimCriteria
This is also a inventDim buffer, with the selected dimension criteria like WMSLocation = ’12’, InventSiteId = ‘2’ and so on.
InventDimParm
InventDimParm is a temporary table, with the selected dimension ‘flags’. You can flag or unflag the dimensions here.
An example of the use of the InventDimParm table we can see in Ax 2012 at module: Inventory and warehouse management | Inquiries | On-hand | button “Dimension Display”.
Example how to use the inventDimJoin macro (example is job).
