Skip to main content

Posts

Showing posts from November, 2012

Show all tables name and Total number of record of AOT in MSD axapta

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(); }

Tables Used in Journal Posting in MSD axapta

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.

Microsoft dynamics axapta companies Web Info in India

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

How to define budget rate type in MSD axapta 2012

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.

Why Importing data through Template is dangerous in MSD axapta

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.