Microsoft Dynamics Axapta Technical,Functional Coverage

To   create record buffer at runtime in axapta you can get hints from below code. DictTable dictTable = new DictTable(tableId); Common targetTable = dictTable.makeRecord(); It will create buffer dynamically.

If you are getting below error on workflow . Stopped (error): X++ Exception: Could not find user at SysWorkflowDueDateProvider-resolve SysWorkflowDueDateProvider-resolveDueDate Then you need to check following things. 1. Check workflow configuration is user assigned for workflow approval elements . 2. Check user relation form if there is not employee assigned then you need to assign employee on user relation form.

To Execute or call SQL Stored Procedure in Axapta by code you can get hints from below code. You can also pass parameter with stored procedure in string format. UserConnection Conn; Statement Stmt; str SqlStmt; SqlSystem sqlSystem; SqlStatementExecutePermission sqlPermission; ResultSet resultSet; str StrFromdate,StTodate; StrFromdate =strFmt("2010-01-01"); StTodate =strFmt("2014-03-31"); sqlSystem =new SqlSystem(); SqlStmt =strFmt('Exec SP_StoredProc \'%1\',\'%2\'',StrFromdate,StTodate) ; Conn =new UserConnection(); Stmt = Conn.createStatement(); sqlPermission =new SqlStatementExecutePermission(SqlStmt); sqlPermission.assert(); Stmt.executeUpdate(SqlStmt); CodeAccessPermission::revertAssert();

To Call query in Axapta by code you can try below code. You need to create query in aot query node then pass query using querystr method in queryrun object. QueryRun queryRun; int cnt; ; queryRun = new QueryRun(queryStr(Query1)); if (queryRun.prompt()) { while (queryRun.next()) { cnt++; }

The inventory settlements table is to store information generated during inventory closing and periodic adjust  job run. This table can be cleaned up or compressed using the following menu in Axapta. Inventory management--->Periodic--->Clean up--->Inventory settlements clean up.

Some data stores in Axapta tables on posting of Sales order and the temporary lines not deleted then need to clean manually by following job. Accounts receivable --> Periodic --> Clean up --> Sales update history clean up. Delete both executed and erroneous data.

To Re-Index All Tables or All Indexes in Axapta You can do from this menu path. Go to Administration -> Periodic -> SQL Administration ->Select All Table/All Indexes->Go to Index Action button_>Re-index. Re-Index All tables from SQL Database

To see all fields of table in Axapta mostly we go to table element of AOT and browse table to get all fields name but if you are in any form and want to see all fields then its very easy. Just right click on form control go to recordinfo then click on show all fields you can see all fields in form. I hope it will save your time.

You can try following  Code to Post Production Journal BOM in axapta. ProdJournalCheckPostBOM PJCPostBOM; ; ttsbegin; PJCPostBOM = ProdJournalCheckPostBOM::newPostJournal(“Prod0003“,true); PJCPostBOM.run(); ttscommit;

You  can use expression in select query in axapta following way. LedgerTable LedgerTable ; info(strfmt('%1',(select firstonly AccountNum from LedgerTable order by AccountNum desc ).AccountNum));