Microsoft Dynamics Axapta Technical,Functional Coverage

 To Set Employee  for Relating to user in axapta you can follow below steps. 1. Click Area Page node: Administration -> Users. Form name: User Fig 1 2. Make sure the selection is changed in table User Information to: Alias Network domain User ID User name Company Enabled External test A bc.com test sk Singh test true false 3. Click the User relations button then go to general tab Form name: User relations Fig 2. 4. Switch to the General tab on the User relations form. Fig 3 5.  Change Employee from '' to ' 1005'. 6. Save the record in the User relations form. 7. Close the User relations form. 8. Close the User form.

Sometimes Ax forms and module becomes slow due to high usage data so that you can clear usage data to improve performance of Ax client. 1. Click the Microsoft Dynamics AX -> Tools -> Options... menu item. Fig-1 2. Click the OK button. 3. Click the Usage data button. Fig2 4. Click the Reset button. 5. Click Yes in the Reset Usage Data form. 6. Close the Usage data form.

If  You need to import any table data through template then you need to export template then fill the data then you need to import that template. To Get template of particular table  you can follow steps below.. 1. Click Navigation Pane node: Administration -> Periodic -> Data export/import -> Excel spreadsheets -> Template Wizard. Form name: Microsoft Office Excel Template Wizard Fig 1. 2. Click the Next > button. 3. Switch to the Open workbook tab on the Microsoft Office Excel Template Wizard form. Fig2 4. Change File name from '' to ' E:\test\doc\filename.xls'. 5. Click the Next > button. 6. Switch to the Select tables tab on the Microsoft Office Excel Template Wizard form. Fig3 7. Click the > button. 8. Click the Next > button. 9. Switch to the Generate field list tab on the Microsoft Office Excel Template Wizard form. Fig4 10. Click the Next > button. 1

If you are facing any amount mismatch problem in trial balance report then you can cross check data with ledgertrans and ledgerbalancedimtrans table. You can check amount dimension wise. You can get hints from below query. select Sum(AmountMST) from _LedgerTrans group by AccountNum,transdate,Dimension[1],Dimension[2] ; select sum(DebitMst),Sum(CreditMst) from _LedgerBalancesDimTrans where LedgerBalancesDimTrans.AccountNum ==_LedgerTrans.AccountNum && _LedgerBalancesDimTrans.transdate==_LedgerTrans.transdate && _LedgerBalancesDimTrans.Dimension[1]==_LedgerTrans.Dimension[1] && _LedgerBalancesDimTrans.Dimension[2]==_LedgerTrans.Dimension[2]; amt= _LedgerBalancesDimTrans.DebitMST + _LedgerBalancesDimTrans.CreditMST

Following Tax classes used to calculate tax for sales order in axapta 1. Taxsales 2. Tax 3. TaxRegulation. In Tax class there is  a method CalcTax on which tax calculate for particular tax code. First tax itemgroup takes from Sales Line then its take formula then formula evaluated by using evabuf method. tmptaxworkTrans is a temporary table which shows temporary tax calculation.If there is tax adjustment then you need to apply tax button on salestax form to get effects.  Corrected Tax or tax adjustment stored in field SourceRegulateAmountCur of Tmptaxworktrans and  Regular tax  field is  sourceTaxAmountCur. Before posting table is  tmptax and tmptaxworktrans,tmptaxregulation After posting Tax table is  TaxTrans,ledgerTrans,CustInvoiceJour.

To gett total Tax amount of sales order in axapta you can try below code in job . SalesTotals salesTotals; SalesTotals_Trans salesTotals1; SalesTable salesTable; SalesLine salesLine; TaxAmountCur Amount,amt1; Tax tax; ; salesTable = SalesTable::find("S0000343_052"); salesLine = SalesLine::find(salesTable.SalesId); salesTotals = SalesTotals::construct(salesTable); tax = Tax::construct(NoYes::No); Amount = salesTotals.totalTaxAmount(); info(Strfmt("The tax amount is %1",Amount ));

If you want to get SQL database name in axapta which is connected with your current Ax application then you can write below code to check the same. Sqlsystem sys = new Sqlsystem(); info(sys.logindatabase());