CommaIo urfile;
LedgerTrans LedgerTrans1;
Container container1;
sqlDictionary sqlDictionary;
TableName tablenm;
;
tablenm = "LedgerTrans1";
select * from sqlDictionary where Tablename2id(tablenm) == sqlDictionary.tabId;
if(sqlDictionary.RecId > 0)
{
urfile= new CommaIo("c:\\test.doc","w");
urfile.outFieldDelimiter("\t");/
while select LedgerTrans1
{
container1= [LedgerTrans1.AccountNum,LedgerTrans1.Txt];
urfile.writeExp(container1);
}
}
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...