Microsoft Dynamics Axapta Technical,Functional Coverage

To Show all tables name and Total number of record of AOT in axapta you can write following code in job . When you run the job you will get all tables with record count in info log. #AOT Name TableName; NumberOf TotalRecord; TrNode TrNode; SysDictTable SysDictTab; ; TrNode = TrNode::findNode(#TablesPath); TrNode = TrNode.AOTfirstChild(); while (TrNode) { TableName = TrNode.AOTname(); SysDictTab = SysDictTable::newTableId(TrNode.applObjectId()); TotalRecord = SysDictTab.recordCount(false); if (TotalRecord) info (strfmt("Table Name - Record count", TableName, TotalRecord)); TrNode = TrNode.AOTnextSibling(); }

In Axapta LedgerJournalTable is main table to store header information of of Journal and ledgerJournalTrans table used to store line level data. After posting of journal data entered in following tables. LedgerTrans If Tax information exists then its stored in taxtrans table if Vendor accounts used in ledger account field then information will be store in vendtrans also. Same way customer related information will store in custTrans table and bankaccounttrans table used to stored bank account details. If there is license for India then tax related information will also stored in taxTrans_In table.

This is list of Microsoft dynamics axapta companies and website. You can add in comments if any other has been left by me. Godrej Infotech www.godrejinfotech.com TCS www.tcs.com NDS InfoTech www.ndsusallc.com Tectura www.tectura.com Blue Star InfoTech www.bsil.com Onward Technologies www.onwardgroup.com Capemini www.capgemini.com L&T InfoTech w www.lntinfotech.com Wipro InfoTech www.wipro.com Corporate Serve www.corporateserve.com Logica Worldwide www.logica.com Persistent Systems Limited www.persistentsys.com Dev Information technology Pvt. Ltd, Ahmedabad www.Devitpl.com columbus IT www.columbusglobal.com

To define budget rate type in axapta 2012 you can read following tips. Problem:A budget rate type is not defined for the ledger.How to  Select a budget rate type for the ledger before you record budget register entries? Solution:  Go to General Ledger > Setup > ledger parameter and choose the budget rate type. Budget rate is the exchange rate you used to define what rate you will use in your budget go for ledger parameters and assign the same one available for you . The reason for this is required is companies sometime have a different policy for budget exchange rate so AX will allow you to track this rate as well as the original transaction rate.

Mostly ERP Does not allow to change posted records in the system but by importing data through template posted data can be change that is the main reason Importing data through template does comes under best practices. Lot of effects goes to tables during manual entry in the system but if you use templates then that effect may loss or you need to do extra coding on import criteria to maintain effects. There may be data redundancy through templates. So better way if user do manual entries in the ERP System that is more secure to save data for long time and its also good to get occuracy in the report.

This is the code to send email from axapta with attachment.You can write this code in method of any class and simple call it. InteropPermission IntCPermission = new InteropPermission(InteropKind::ComInterop); InteropPermission IntCPermission1 = new InteropPermission(InteropKind::ClrInterop); InteropPermission IntCPermission2 = new InteropPermission(InteropKind::DllInterop); str body,mailto, mailfrom; System.Net.Mail.AttachmentCollection attachementCollection; str FileName; FileIOPermission FilePerm; SysMailer mailer; SysEmailParameters parameters = SysEmailParameters::find(); ; try { IntCPermission.assert(); mailer = new SysMailer(); if (parameters.SMTPRelayServerName) { mailer.SMTPRelayServer(parameters.SMTPRelayServerName, parameters.SMTPPortNumber, parameters.SMTPUserName, SysEmailParameters::password(), parameters.NTLM); } else { mailer.SMTPRelayServer(parameters.SMTPServerIPAddress,...