Skip to main content

Posts

Blogging Keywords topics for MSD Axapta ERP x++ alphabetically

If you are blogger then this post may help to select your interesting topic from following list. This is collection of keywords and topic categorise related to Microsoft dynamics axapta. .cus .doc file .Net business connector .NET Business Connector Overview .net framework 2.0 3-Tier Setup components 6.0 and SQL Material 64 bit machine deployment A Brief History of Axapta abort transaction about Recycle Bin abstract access in axapta Access the Current Row and Field value in Enterprise portal Accessing Microsoft Outlook from Axapta using COM account name account number etc account payable account receivable accountnum Accounts payable Invoice Journal Creation accounts receivable action menuitem action properties active directory active directory Active directory configurations setting in axapta active directory group active directory users active join active method Add a form list control. in form at runtime using axapta add company range add control ...

How to improve performance of Import data through Excel template in MSD axapta

There are two ways to improve performance of Import data through Excel template in axapta. Method one: You can Import the excel data into table in a dummy database of sql server or other dummy table in same database. Then you need to Create a odbc connection to the dummy database in the machine After that you need to Create a job in Axapta with odbc connectivity and pull the data by sql query. After reading the data then insert into respective tables of Axapta. You need to write database connectivity script. You can get that code on this blog too. Just use search box. Method two: Second method is you can use standard import functionality but  Don't use excel, you can use custom type importing option then convert your excel data into CSV format and define the table & columns and import the data.I am sure approx 20k records will be import few minutes.I hope This is the better way to import bulk records.

Peroformance improvement points in axapta

If you are facing performance issues in axapta then you can take following action. 1. Re-Indexing. 2. Create new indexes by getting hints from long query and select queries. 3. Check unwanted data in log tables and clear them if not required. 4. Increase RAM Size in sql database. 5. Check your disc where application and database installed. Required to check whether its free or not. 6. Check blocking processes from sql at working time. 7. Load balancing of AOS. I hope you get good hints from here for performance tuning.

Microsoft Dynamics customer numbers by product

This is probable details of Breakdown of the Microsoft Dynamics customer numbers by product. Microsoft Dynamics® CRM 39,000 companies with 3 million users  Microsoft Dynamics® AX 18,000 companies  Microsoft Dynamics® GP 43,000 companies  Microsoft Dynamics® NAV 94,000 companies  Microsoft Dynamics® SL 13,500 companies Currently CRM,AX,GP,NAV and SL are famous product of Micrsoft dynamics ERP.