Skip to main content

InventTable entity schema tables description of MSD axapta

InventTable entity schema tables description of axapta

InventTable
The InventTable table contains information about items.

InventItemGroup
 The InventItemGroup table contains information about item groups.

InventDimGroup
The InventDimGroup table contains information about a dimension group.

InventTableModule
The InventTableModule table contains information about purchase, sales, and inventory specific settings for items.

InventModelGroup
The InventModelGroup table contains information about inventory model groups.

InventItemSalesSetup
 The InventItemSalesSetup table contains default settings for items such as Site and Warehouse. The values are related to sales settings.

InventItemPurchSetup
 The InventItemPurchSetup table contains default settings for items such as Site and Warehouse. The values are related to purchase settings.

InventItemInventSetup
The InventItemInventSetup table contains default settings for items such as Site and Warehouse. The values are related to inventory settings.

InventItemLocation
The InventItemLocation table contains information about items and related warehouse and counting settings. The settings can be made specific based on the items configuration and vary from warehouse to warehouse.

InventDim
The InventDim table contains values for inventory dimensions.


Popular posts from this blog

strScan and Find a first occurrence of a string in a string using x++

strScan (Find a first occurrence of a string in a string) info("int strScan(str _text1,str _text2,int _position,int _number)"); info("Searches a text string for the occurrence of another string."); info("_text1 - The text string to search."); info("_text2 - The string to find."); info("_position - The position at which the search should start."); info("_number - The number of characters that should be searched."); info(int2str(strScan("ABCDEFGHIJ","DE",1,10)));

Get record from table on the basis of field id in Microsoft dynamics axapta x++

How to Get record from table on the basis of field id in dynamics axapta x++. just try following code in job to understand better way. emplTable emplTable; FieldId fieldId; ; fieldId = fieldNum(emplTable, Emplid); select emplTable; info(emplTable.(fieldId)); select emplTable where emplTable.(fieldId) == '1101'; info(emplTable.Name);

Code to get customer Primary Address in Ax 2012

Below Code to get customer Primary Address in Ax 2012. CustTable custTable_P; DirPartyTable dirPartyTable_P; DirPartyLocation dirPartyLocation_P; DirPartyLocationRole dirPartyLocationRole_P; LogisticsLocation logisticsLocation_P; LogisticsLocationRole logisticsLocationRole_P; LogisticsPostalAddress logisticsPostalAddress_P; LogisticsPostalAddress primaryAddress_P; while select custTable_P where custTable_P.AccountNum =='ED_01029' join dirPartyTable_P where dirPartyTable_P.RecId == custTable_P.Party join dirPartyLocation_P where dirPartyLocation_P.Party == custTable_P.Party && dirPartyLocation_P.IsPrimary==NoYes::Yes join dirPartyLocationRole_P where dirPartyLocationRole_P.PartyLocation == dirPartyLocation_P.RecId join logisticsLocationRole_P where logisticsLocationRole_P.RecId == dirPartyLocationRole