How to export data from table to word file in Axapta

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);
}
}
Posted by Santosh kumar Singh

When wanting to clear dynalinks between two forms, you can clear the dynalinks on the DS on the second form. See example below.

Clear DynaLinks public void init() { ; super(); if (element.args() && element.args().caller() && (element.args().caller().name() == formStr (PurchTable))) { InventTable_ds.query().dataSourceTable(tableNum(InventTable)).clearDynalinks(); } }

Dynamics Axapta: Sales Orders & Business Connector

Well, again folllowing my same idea of writting close to nothing and pasting code, I'll paste in some code to create a sales order from some basic data and the invoice it. I'll try to explain more in the future. AxaptaObject axSalesTable = ax.CreateAxaptaObject("AxSalesTable"); AxaptaRecord rcInventDim = ax.CreateAxaptaRecord("InventDim"); AxaptaRecord rcCustTable = ax.CreateAxaptaRecord("CustTable"); rcCustTable.ExecuteStmt("select * from %1 where %1.AccountNum == '" + MySalesOrderObject.CustAccount + "'"); if (MySalesOrderObject.CurrencyCode.Trim().Length == 0) MySalesOrderObject.CurrencyCode = rcCustTable.get_Field("Currency").ToString().Trim(); string sTaxGroup = rcCustTable.get_Field("taxgroup").ToString().Trim(); //set header level fields axSalesTable.Call("parmSalesName", MySalesOrderObject.SalesName.Trim()); axSalesTable.Call("parmCustAccount", M

Passing values between form and class

Class name is EmplDuplication and Form is EmplTable . void clicked() { MenuFunction mf; args args = new Args(); ; args.record(EmplTable); mf = new menufunction(identifierstr(EmplDuplication), MenuItemType::Action); mf.run(args); } Meanwhile, in the main() method of the EmplDuplication class, we need to put this Axapta x++ code to get the datasource: static void main(Args args) { EmplDuplication EmplDuplication; EmplTable localEmplTable; ; if(args.record().TableId == tablenum(EmplTable)) localEmplTable = args.record(); ... }

İsmail Ozcan

Search This Blog