Microsoft Dynamics Axapta Technical,Functional Coverage

As we listen lot of time like multiple line voucher Entry and Single line voucher. If we want to understand this terms in better way than you can go on below points. 1. If you enter any journal line with offset account that means its single line entry. Voucher.  - Account- Debit- Credit- Offset account V00001   -AC01-1000-                     -O00001 2. If your Entry like this Voucher.  - Account- Debit- Credit- Offset account V00001   -AC01-1000-  V00001 -O00001 -          -10000         - This type of Entry is treated as multiple line voucher Entry.

This is a Code for Tax adjustment in Free text Invoice in axapta. You can try this code in job to check the effect of adjustment. CustInvoiceTable _custInvoiceTable; CustInvoiceCalcTax custInvoiceCalcTax; TaxFreeInvoice _taxFreeInvoice; TaxRegulation _taxRegulation; ; ttsbegin; select firstonly _custInvoiceTable where _custInvoiceTable.InvoiceId == "test5"; custInvoiceCalcTax = new CustInvoiceCalcTax_Table(_custInvoiceTable); _taxFreeInvoice = new TaxFreeInvoice(custInvoiceCalcTax); _taxFreeInvoice.calc(); _taxRegulation = TaxRegulation::newTaxRegulation(_taxFreeInvoice); _taxRegulation.allocateAmount(33.47); _taxRegulation.saveTaxRegulation();

This is a Code to Tax adjustment for Ledger Journal in axapta You can try this code in Job in AOT. I hope it can help you to get class and method details for tax adjustment. LedgerJOurnalTrans LJTrans; TaxLedgerJournalCalculate taxLedgerJournalCalculate; TaxLedgerJournal taxLedgerJournal; TaxRegulation TaxReg; ; ttsbegin; select firstonly LJTrans  where LJTrans.JournalNum == "000787_j"; taxLedgerJournal = TaxLedgerJournal::construct(TaxJournalCall::Journal, LJTrans, null); TaxReg = new TaxRegulation(); taxLedgerJournal.calcAndPost(); TaxReg.setTax(taxLedgerJournal); TaxReg.createSumsFromTmp(); TaxReg.allocateAmount(7.8); TaxReg.saveTaxRegulation();

If you want to know inventory value with dimension details then you can Go to Inventory Report from following menu path. Inventory Management -> Reports -> Status -> Inventory Value By Inventory Dimension In this report you can select dimension like batchid,warehouse, inventory location etc. Inventory value you will get correct after inventory recalculation and closing.

Trial balance report is to show closing balance of particular period. If you want to know opening debit,credit,current period debit and credit amount and balance till date for particular account then you can get details from following report. General Ledger -> Reports -> Transaction -> Periodic -> Trial Balance You can view  report by using summary and details option. You can check other option to know more details about report.

If you want to disable Dialog  to Report to display report output without opening of dialog box. You need to set Properties of report design . You can reset Interactive property of report to no at design.

If you are facing Buffer size error in Axapta during any process then you can resolve this error by increasing buffer size from AOS Server configuration. Buffer size setting is available in Application Object Server configuration.

To Change current session date in axapta you can find in following menu. Tools- > Session date If you will change session date for your client then it will change for your client session only it will not affect other users session. Once you will close your ax client then real current date will be set automatically.

First you need to check Amount global type has been set properly or not on following menu. Administration -> Setup -> System -> Adjust Global Types. Then you need to find EDT( Extended data type ) then you need to set Number of Decimals property on the Amount extended data type to as per your requirement.

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.