Dynamics Axapta Coverage of Technical Tutorials Version 2009, 2012

Microsoft Dynamics Ax, Application Integration Framework, X++ programming, AX 2009 , 2012. Enterprise portal, SharePoint , BI Tools, OLAP, Performance Tuning, SSRS,SSIS,SSAS, Workflow.

Sunday, April 19, 2015

Entity Relationship diagram of General Ledger in Ax 2012

Entity Relationship diagram of General Ledger in Ax 2012

Wednesday, March 4, 2015

Create an Axapta Enterprise Portal extranet site,New Web Application in Sharepoint

Create an Enterprise Portal extra-net site

1. Click Administration > Setup > Internet > Enterprise Portal > Web sites.

2. Click the Create site button.

3. Enter information in the Web Application, Title and Description, and Web Site Address sections.

4. Under Template Selection, click the Custom tab.

5. Click Microsoft Dynamics AX Enterprise Portal.

6. Enter information in the Site Owners and Quota sections, and then click OK.

7. Use IIS to assign the SSL certificate to the Web site you just created (Start > Administrative Tools > Internet Information Services (IIS) Manager).

Under Web sites, right-click the new site and click Properties.

Click Directory Security.

Under Secure Communications, click Server Certificate.

Complete the Web Server Certificate Wizard

8. Restart IIS. Open a command prompt, type iisreset/noforce, and press ENTER.

9. Verify that the site is configured for SSL. Click Administration > Setup > Internet > Enterprise Portal > Web sites. Locate the site you just created and verify that the External URL field shows https.

10. View the site in a browser. Select the site in the Web sites form and click View in Browser.

Create a site using the Public template in Axapta Enterprise Portal

1. Open SharePoint Central Administration (Start > Programs > Administrative Tools > SharePoint 3.0 Central Administration).

2. Create a new site collection (Application Management > Create site collection).

3. In the Web Application section, select the application that you created in the "Create a new Web application in SharePoint Central Administration" procedure.

4. Enter a title and description

5. Specify a URL.

6. In the Template Selection section, click Custom, and then click Microsoft Dynamics Public.

7. Specify collection administrators and quota details.

8. Click OK.

9. After the new SharePoint site collection is created, open a command prompt, type iisreset /noforce, and press ENTER.

Create a new Web application in SharePoint Central Administration

1. Open SharePoint Central Administration (Start > Programs > Administrative Tools > SharePoint 3.0 Central Administration).


2. Create a new Web application (Application Management > Create or extend Web application > Create a new Web application).

3. Click Create a new IIS Web site.

4. In the Application Pool section, click Configurable, and then enter the credentials for the Business Connector proxy.

5. Enter information in the remaining sections and click OK.

Wednesday, February 25, 2015

Refresh Dictionary,Data,Element cache in Ax 2012

If you are facing any Cache Related issue in axapta then you can Refresh  Refresh Dictionary, Data, Element cache in Ax 2012.

Just Open Ax client then open Application object tree(AOT) then go to tools menu ->cache . Here you can see Refresh dictionary, Refresh data and Refresh element.

Sometimes you made some change in any object and its not reflecting to clients then you can use this option to correct the issue.

I want to attach screen of menu as below.

Refresh Dictionary,Data,Element cache in Ax 2012

Sunday, February 1, 2015

Compile forward in Axapta

compile class


















Compile Forward – Base Class in axapta 

When editing the method Class Declaration in a system base class which is inhirit by other classes, the compiler does not compile the inheriting classes, generating errors when the user attempt to call methods in the inherit class.

to do this also by code you can use the "compileForward" in "SysCompilerOutput" class

SysCompilerOutput::compileForward(className2Id('InventMovement'));

This is a example of one class you can compile forward other classes in AX. Happy daxing...

How to learn Microsoft Dynamics Axapta

To learn Microsoft Dynamics Axapta first you need to know basics of ERP ,Fundamental of business operation and some technical knowledge on basic language like c++. 

Object orientation programming knowledge is must.

 Them you try to know what is software engineering.

Then learn on software development life cycle and other key areas, don't go deep into software engineering. then learn what is ERP and go for module basics. 

As we know Ax is  an ERP Like SAP, ORACLE etc. I'll suggest you to Read some books about ERP Implementation and Its Lifecyles. Finally you come to know What type of Modules are there in ERP And what's their Importance in Configuring the System by reading Those books.Once you done all these things then you better to find which Module you can able to learn.

If you want to become ax technical then learn pdf for development  then start some little exercises to know about programming.

If you want to become ax functional then you need to learn all modules and functionality of ax ERP you need to attend some training also if required.


Wednesday, January 7, 2015

Top 10 ERP Providers in the Market

These are list for Top 10 ERP Providers in the Market.
Top 10 ERP Providers in the Market

Tuesday, December 2, 2014

Error : A currency to convert from is required to retrieve exchange rate information

If you are getting error "A currency to convert from is required to retrieve exchange rate information" on posting statement in Retail then following suggestion can be your solution.

It can be resolve you need to check tables-RetailTransactionSalesTrans -currency may be missing in table-RetailTransactionSalesTrans from the currency column .


Friday, November 7, 2014

Installation Steps for Enterprise portal in Axapta 2009,4.0

Following are Installation Steps for Enterprise portal in Axapta 2009/4.0.

1. Installation of .Net framework 2.0 and 3.0.

2. Installation of Client.

3. Installation of Business connector.

4. Installation of Enterprise portal server from Ax Server setup.

5. Installation of Sharepoint 3.0 administration.

6. Run Sharepoint product and technology wizard by using default selection.

7. After wizard completion run configuration wizard from ax (Administrator->setup->Internet->Configuration wizard->then run Manage deployment)

8. Create or register EP Site.

9. If site not created successfully then try with new name which is not used previously.

1. After that site will show in Ax client you can open it.

Friday, October 24, 2014

Error while starting Ax 2009 Instance

If you are facing below error while  while starting Ax 2009 Instance.

"Concurrent number of AOS for this application Exceeds the licensed number".

It means you have single AOS license but You have installed multiple AOS and trying to access using load balancing.

You can solve your error following way.

Open sql query editor and do following steps

SELECT * FROM dbo.SysServerSessions WHERE Status = 1;

Change the Status value by using following  update query:

UPDATE  dbo.SysServerSessions SET Status = 0 WHERE Status = 1;

Thursday, October 16, 2014

Workflow Known Error -Due date exceeded in Ax 2012

This is Workflow Known Error -Due date exceeded in Ax 2012 but solution still not found on searching on internet.

X++ Exception: invalid tracking submission expected context Workflow and expected type Submission actual context Workflow and actual type Fault.
 at SysWorkflow-faultWorkflowInstance
SysWorkflow-internalFault
SysWorkflow-fault
WorkflowTrackingTable-saveTracking
SysWorkflowWorkItem-escalate

X++ Exception: invalid tracking submission expected context Workflow and expected type Submission actual context WorkItem and actual type DueDateExceeded.
 at WorkflowTrackingTable-saveTracking

SysWorkflowWorkItem-escalate

Could any one give right comment and answer

I tried, IISReset,Full compilation of CIL and application,Restart AOS Services and Server but problem not resolved. Workflow stop working after this error.

Tuesday, September 30, 2014

Get Database information in Axapta


1. Click Area Page node: Administration -> Inquiries -> Database -> Database information.Switch to the General tab on the Database information form.

 2. Switch to the System variables tab on the Database information form. to get System variables  on form.

3. Switch to the ODBC tab on the Database information form to get ODBC  Details .









Monday, August 11, 2014

Post Sales Order from business connector with CSharp in axapta

This code can help you

AxaptaRecord AXSalesTable = ax.CreateAxaptaRecord("SalesTable");
AXSalesTable = ax.CallStaticRecordMethod("SalesTable", "find", SalesId) as AxaptaRecord;
AxaptaObject axSalesFormLetter_Invoice = ax.CreateAxaptaObject("SalesFormLetter_Invoice");
axSalesFormLetter_Invoice.Call("new");
axSalesFormLetter_Invoice.Call("update", AXSalesTable);

Thursday, July 24, 2014

Number sequence cleanup activity in Axapta


1. Click Navigation Pane node: Basic -> Setup -> Number sequences -> Number sequences.

2. Select the number sequence line.

3. To perform cleanup of number sequence of current selection Click the Clean up -> Click on Current menu button.

Form name: NumberSequenceCleanUp

4. To perform cleanup of number sequence of current selection Click the Clean up -> Click on All menu button.


5. Click the OK button.

How to Change User logon Ideal time in Axapta

To Change User logon Ideal time in Axapta you can choose below option.

1. Click Area Page node: Administration -> Users.

2. Click the User options button.

3. Change Automatic shutdown from '0' to '10 it means if user is ideal for 10 min then ax application will close after that.

Table reindex,Generate SQL scripts,truncate option from axapta


1. Click Navigation Pane node: Administration -> Periodic -> SQL administration.

Form name: SQL administration

2. Click the Table actions -> Browse table menu button.

Form name: Table browser: CustTable

3. Close the Table browser: CustTable form.

4. Click the Index actions -> Reindex menu button.

5. Click the Generate SQL scripts -> .... for creating tables menu button.

Same as you can check other option like truncate table,check synchronization etc.


Active Search Results Technology Blogs