Microsoft Dynamics Axapta Technical,Functional Coverage

If you are facing client opening problem then you can try this to resolve the issue. You can delete *.auc file then retry to  open axapta instance this file will recreate automatically in same folder . c:\Documents and Settings\\local settings\application data\*.auc You can go for same folder for particular user. I hope your problem get resolved.

 Code To Create a New Table in axapta. Write following code in job and check table in aot after execution of job. TreeNode treenode; AOTTableFieldList fieldlist; #AOT ; treenode = TreeNode::findNode(#PathOfTable); //PathOfTable =\\Data Dictionary\\Tables\\TestTable\\Fields' treeNode.AoTadd("NameofTable"); sqlDataDictionary::Synchronize(); treeNode.AoTFindChild(NameofTable); filedlist = treenode::AOTfieldchild(NameofTable).AOTfindchild('Fileds'); fieldList.addString('Name'); fieldList.addInteger('Address'); fieldList.addReal('City'); Info(" Table Created"); By above code new table testTable will be created with Name,Address and city field. You can use this code in your form customization also.

Points to follow on Item Id rename process in axapta. If you are renaming item id in axapta then you need to keep following points in mind otherwise your system will get hangs. 1. Whenever the item id is to be renamed, that particular item id should be "stop" in the system and then the renaming process can be done. 2. Ideally item id should not be renamed and if only need be such process should be done . 3.This process of item id rename should be done in single user mode so that no other transaction is done in the system when this process is been done.  Please take note of my suggestion.

 Synchronization of  table forcefully in axapta Declare following variable. Application application; TableId tableId; ; tableId=1212; You can pass tableid following way to syncronize table forcefully. application.dbSynchronize(tableId, false, true, false); This will work in all version of axapta.

Declaration of variables. dict is object for dictionary class and tablecnt is method of that system class. You can get total number of tables in AOT by following way. Dictionary dict; int totalTables; dict = new Dictionary(); totalTables = dict.tableCnt(); info(strfmt("%1",totalTables));

First write code on button clicked event void clicked() { super(); new MenuFunction(menuitemactionstr(SysDataImportExcel),MenuItemType::Action).run(); } then select file to import data in table.

void createGraph1() { //SalesLine salesline; LedgerBudget ledgerBudget; int i,k; str month; // date createddate; #macrolib.ChartFx ; graphics1 = Graphics::newGraphicsTitlesLayout(ChartX1, 100, 200,'Title', 'X', 'Y', 'z',1 ,1, 1, 1); graphics1.create(); graphics1.parmTitle("MonthWise Comparison(G)"); graphics1.parmTitleXAxis('Month'); graphics1.parmTitleYAxis('Amount'); ChartX1.Chart3D(true); ChartX1.toolBar(true); //graphics.Gallery(9); graphics1.parmHeight(350); graphics1.parmWidth(450); AllocApr=0; AllocMay=0; AllocJun=0; AllocJul=0; AllocAug=0; AllocSept=0; AllocOct=0; AllocNov=0; AllocDec=0; AllocJan=0; AllocFeb=0; AllocMar=0; while select * from LedgerBudget where LedgerBudget.Key!="" //ledgerBudget.AccountNum==ledgerTable.AccountNum { // DivisionName=divnm; // if (salesline.createdDate >= fromDate &&