Microsoft Dynamics Axapta Technical,Functional Coverage

Performance Improvement for Ax Application. If you are facing performance problem in axapta then you can do following task to improve performance. 1. First you need to check which table has maximum transactions then you concentrate on those tables which has lot of records.  2. You can create index on tables which is taking long time on select query. 3. You can delete unwanted transaction log data and usage data if required. 4. You can set re-indexing job for all table through job in sql. 5. You can review logic and loop for customization tables you can tune logic to improve performance. 6. You can increase RAM in sql database if its not fulfilling transaction requirements. 7. You can install more AOS and do load balancing. I hope those points can help you to improve performance.

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.