SSRS Reports are not working in AX 2012R2 or Report server crashes in AX 2012 R2

When ever we face such kind of a problem we need to delete XPPIL files from the Bin folder except folders which is availble in the Bin folder.

so that we can fix the problem as well as we have to generate the Full CIL.
      
DynamicsAx2012\Ax6.0\msdax\server\bin\xppil(except folders delete all files), for our security take all the backup before any action.

Specific user problem in ax 2009 or 2012.

When ever we face a problem for a specific user in AX 2009 or 2012. We have to delete *.auc files then the problem may resolve.

I  am going to mention how to delete the files kindly follow below 3 points and check.

1. Stop AOS.
2. Delete the *.auc files from users\\Appdata\ folder
3. Restart AOS.

Error while running workflow automation report in AX 2012 EP version

AX 2012 FP version

I am getting the error "The 'Maindata_StartDate' parameter is missing a value" when i run the report from CEU/Organization administration/Reports/WorkFlowAutomation

even if i run workflowElementsAutomation same error i am getting.

Basically wherever there is a StartDate and EndDate what ever the date format i am entering it is not accepting and no drop down is coming to select the date.

 

Answer: 

         Open Dynamics Ax

         Navigate to System Administration

         In system Administration ->setup ->Business Intelligence ->Analysis services click on Date imension

         It will open the date dimension settings there change the end date to this year last date.

        Close the Window.

         Process the cubes again.

 

 

 

What is sure step methodology in ax 2012

Microsoft Dynamics Sure Step is the prescribed methodology for deploying Microsoft Dynamics AX. The Sure Step application
provides product-specific and general project-based templates, workflows, process maps and tools to assist the implementation partners. Sure Step is currently available as an online tool or for download from Partner Source.

The Sure Step methodology is divided into the following phases:

        Try to observe the above picture and explained below briefly.

Diagnostic
Evaluate a customer's business processes and infrastructure Assist the customer with their due diligence cycle, including
ascertaining requirements and their fit with the solution,and assessing the resource needs for the solution delivery Prepare
the project plan, proposal, and the Statement of Work.

Analysis
Analyze current business model and finalize the Functional Requirements document Finalize the fit-gap analysis Develop
the Environment Specification documentation.

Design
Develop the Functional Design, Technical Design, and Solution Design documents Finalize the data migration design Establish
test criteria.

Development
Finalize configurations and setup of the standard solution Develop and finalize the custom code that is required to support
the solution Conduct functional and feature testing of the solution Create the user training documentation.

Deployment
Set up the production environment Migrate data to the production environment Conduct user acceptance test of the system Train
users and finalize the user documentation Conduct go-live check and promote the system to production.

Operation
Resolve pending issues Finalize user documentation and knowledge transfer Conduct a post-mortem of the project Provide on-going
support (activities that continue through any future involvement with the customer after the project is closed).

The Sure Step methodology also provides guidance for the following areas:

Optimization
Leverage Review Offerings to determine proactively if the system is being designed and delivered optimally to meet the customer’s
requirements Analyze the system to determine how it can be optimized for the best performance based on customer's needs.

Upgrade
Assess the customer's current business processes and solution Document the requirements for new functionality Upgrade the system
to new release—including the addition of new functionality, promotion of existing customization that are required, and elimination
of custom code no longer required.

What is Full text index in ax 2012

A full text index contains location information about each significant word in a string field of a table.
Some queries can use this information to run more efficiently and complete much sooner.
These are queries that search for words that are embedded in the middle of string fields
A regular index on a long string field can help a query complete quickly only if the query
searches for the word that is at the start of the string field.
In X++ SQL this is done with the like keyword and the * wildcard character, such as in the code phrase like "*van*".

What is index in ax 2009 and 2012

There are two types of indexes:
Unique and Non-Unique.
Whether an index is unique is defined by the index's Allow Duplicates property.
When this property is set to No, a unique index is created.
The database uses the unique index to ensure that no duplicate key values occur.
The database prevents you from inserting records with duplicate key values by rejecting the insert
Setting the index's Allow Duplicates property to Yes creates a non-unique index.
These indexes allow you to enter duplicate values for the indexed fields and are used for performance reasons.


Microsoft Dynamics AX requires a unique index on each table
so if there are no indexes on a table or all the indexes are disabled,
a system index is automatically created. The system index is created
on the RecId and DataAreaId fields if the DataAreaId field exists.
Otherwise the system index is created on the RecId field.
You can see system indexes in the database but they aren't visible in the AOT.
If there are indexes on a table but none of them are unique,
 the runtime estimates the average key length of the existing indexes,
chooses the index with the smallest key length and appends the RecId column to create a unique index.

 

How to create RDP report in Ax 2012

http://www.dynamics101.com/2013/09/developing-ssrs-report-using-report-data-provider-microsoft-dynamics-ax-2012/

Layer Configuration In AX 2012

Changing Layer in Dynamics AX 2012:

1.      Click Start, point to Administrative Tools, and then click Microsoft Dynamics AX 2012 Configuration. The Microsoft Dynamics AX Configuration Utility opens.

 

 

 

In the Microsoft Dynamics AX Configuration Utility, click Manage, and then click Create configuration. The Create Configuration window opens

 

 

In the Configuration name field, enter a name for the configuration, and then click OK. The Create Configuration window closes

 

 

On the Developer tab, in the Application object layer to open field, select a new layer from the drop-down list.

 

 

In the Development license code field type the license code and  confirm license field also give the same

 

Click Apply and  Click OK to save the configuration. The Microsoft Dynamics AX Configuration Utility window closes.

Close and restart the client in the new layer.

Thanku

 

 

How to debug Code in Visual Studio in AX 2012

AX 2012 - How to debug Code in Visual Studio
This post basically addresses how to debug code in Visual studio.
Most of code running on AOS runs in CIL environment, so it cannot be debugg in Microsoft Dynamics AX Debugger.
You might have confused/surprised why ax debugger is not opening inspite of  inserting breakpoint at particular place. It means code might be running in CIL and to debug visual studio 2010 is required.

Step1:
Make sure AOS Service runs on account which you logged in. Right click on AOS Service and change log on property to logged in windows credentials.
Log off windows and then re log in. 
        
Step2:
Open visual studio and click on AX Application explorer (Shortcut Ctrl + D)
AOT opens and you can browse nodes as you used to do in Dynamics AX.
Open the object which you want to debug and insert breakpoint.

Step3:
Then in Visual studio, Click on Debug->Attach process

 

As shown in above image, First make sure two check boxes at bottom are marked.
Then only you can find and able to select AX32Serv.exe(AOS)  process and click on attach button.

Note : When you are doing this step 3 for first time it prompts you to Restart Visual studio, kindly select the same option.

 

Step4:    You done with setting up visual studio to debug code running in CIL.
Now restrart process in Dynamics AX which you want to debugg and you can find Visual studio debugger opened for you.
Continue debugging with hotkeys as you use to do in AX debugger like F10/F11.

Architecture of Dynamics AX 2012

It is nothing but the flow of data from one part of the application to the other part of the application to complete the operation and get expected result any program will have its own way of working and its own architecture.

In Microsoft dynamics ax, there is a  3-tier infrastructure with a database server, an AOS  and a 

client.

In the above  figure client is called as Morphx, this is IDE which is used to communicate with AX server . custom AX development  and modification is done with its own IDE , Morphx.                 

                   

Morphx is an integrated development environment in ax that allows developer to graphically design data types, base enums , tables, queries , forms, menus and reports.                                                    

In AOS is a core component of the Microsoft dynamics ax 2012 installation and is installed by using setup . An AOS enforces security , manage connections between clients and the database .                

Finally backend tier is used to store the data . AOS will not store any data except execution business logic and communicate with backend to get and store data . Usually SQL server 2005 is used for ax   2009 and SQL 2008 used for AX 2012 to store data.                                                                             

OOPS meterial in AX 2012 and 2009

1.Class]]
2.Object]]
3.Inheritance]]
4.Polymorphism]]
5.Encapsulation]]

In Dynamics AX, objects are usually created in the base class using a static method called ‘construct'. The construct method usually accepts parameters like table buffers or other types of variables. The construct method acts like an object factory 'producing' objects depending on the input parameters.

You might be asking yourself if isn’t it easier to put all the code in one place? That might be the case if you want to produce code in a hurry. Rest assured, this approach might be faster but it is certainly not better. The reason is simple: if code is written in an unstructured manner, finding and solving bugs is more difficult and quite often results in code that is broken in one place when fixing it in another place. This can also occur when using OOP except that it very easy to avoid if the programmer is aware of this.

This is one of the many pitfalls that OOP helps to solve. With OOP, the code pertaining to a specific purpose is encapsulated in its own class. This means maintaining the code can be done in a specific class only. If the code is changed in a class, sibling classes are not affected but children classes are. If desired, it is simple to propagate code changes to all child classes by changing the code in a single place, the base class. All child classes will automatically inherit the new code.

 1. Class:

In object-oriented programming a class is a programming language construct that contains properties and methods. The properties represent the attributes of an object and the methods represent the actions that an object can perform. A common design pattern is to have a parent class and child classes that specialize the methods of the parent class.

2. Object.

In object-oriented programming an object is an instance of a class   and is created using the new operator. In Dynamics AX a commonly used pattern is the factory method using a static construct method.

3.Inheritance.
In object-oriented programming inheritance means that a class  can inherit properties and methods from another class. This is a powerful feature because code changes in the parent class are propagated to all child classes. The advantage of that is that code only has to be changed in the parent class for the all the child classes to benefit from it.

4.Polymorphism.

Polymorphism is a core concept in oop and goes hand in hand with Inheritance. You can use an object from type of a subclass always like an object from type of a superclass. By example if you create a class that extends RunBaseBatch you can use it always like a RunBaseBatch Object.

 5.Encapsulation.

In object-oriented programming encapsulation means that code that logically belongs together is placed in a single entity, namely a class. Accessing code and modifying class variables is achieved by using public class methods.

Exceptions in micro soft axapta 2012 erp videos

Exceptions in micro soft axapta 2012 erp videos

by clicking the below link you can able to navigate the youtube

https://www.youtube.com/watch?v=dh_hOeFNFqU&feature=youtu.be

Dynamic linking in AX 2012 VIDEOS

Dynamic linking in  AX 2012 VIDEOS

by clicking the below link we can view this video

https://www.youtube.com/watch?v=n2XYGMopg9Y&feature=youtu.be

Date time composite array container in AX 2012 VIDEOS

Date time and composite array container in  AX 2012 VIDEOS
by clicking the link it will shou you in the you tube

https://www.youtube.com/watch?v=VC_K1EnpaS0&feature=youtu.be

Installation and opening debugger in AX 2012 VIDEOS

Installation and opening debugger in AX 2012 VIDEOS

Please click the below link to view the video in you tube

https://www.youtube.com/watch?v=HzGNdR1K6IY&feature=youtu.be

Date effectiveness in ax 2012 video

Date effectiveness in ax 2012 video
by clicking the below link date effectiveness in ax 2012 video in ax 2012 video...
https://www.youtube.com/watch?v=OcOGLdPLBRs&feature=youtu.be

Creating Menu and Menu Items in ax 2012 video

Creating  Menu and  Menu Items in ax 2012 video
By clicking the below link we can see all the creation of menus and menu items in the ax 2012 video
https://www.youtube.com/watch?v=SbAyAJ5ZM_Q&feature=youtu.be

Forms with Multiple DataSources in ax 2012 video

 Forms with Multiple DataSources in ax 2012 video
in the below link will show you all about the multiple datasources in the forms
 https://www.youtube.com/watch?v=ZdQsN69_zcw&feature=youtu.be

Forms with Single Data Source in ax 2012

 Forms with Single Data Source in ax 2012

by clicking the below link we can get to know about form with adding datasource

https://www.youtube.com/watch?v=8mtLW9NS5AY&feature=youtu.be

Views concept in ax 2012 video

 Views concept in ax 2012
 by clicking the below link we we can see all about the view concept in the ax 2012 video
https://www.youtube.com/watch?v=NW3jeyBbfM8&feature=youtu.be

Maps concepts in ax 2012

Maps concepts in ax 2012
By clicking the below link we can understand all the concepts about to MAPs in ax 2012
https://www.youtube.com/watch?v=E14tRYVPtRE&feature=youtu.be

Creating a label and label ids in ax 2012 video.

Creating a label and label ids in ax 2012 video
By clicking the below link we can easily understand all the label concepts in ax 2012
https://www.youtube.com/watch?v=UL-Oov1riLM&feature=youtu.be

Creating a model and changing between models in axapta 2012 video

Creating a model and changing between models in axapta 2012 video. providing by santhosh p in the YouTube channel by clicking the below link it will show you the particular video and get full knowledge on your subject .
https://www.youtube.com/watch?v=xiFNPeNC2vI&feature=youtu.be

Changing the layers in ax 2012

By clicking the below link easily we will get to know about the layers and their concepts

https://www.youtube.com/watch?v=UL-Oov1riLM&feature=youtu.be

Exel formate wrong in the report Ax 2012

The format always its take as a stranded but some cases it show like up and down in the excel when we are converting into the excel.
In that case we have to check properties in the design part in visual studio Location property in that top if we adjust it will get clear and print in the correct format.

Thanks
Santhosh P

ssrs report in dynamics ax 2012

Diffrent Type of Joins and Linked Type in AX 2009

Car Table

CarId	ModelYear	CarBrand	Model	Mileage	ModelYear	CarId
CA101	2008	Mahindra	Scorpio	15	2008	CA101
CA102	2009	Suzuki	800	12	2009	CA102
CA103	2007	Hundai	i20	5	2007	CA103
CA104	2007	Toyato	Inova	3	2007	CA104
CA105	2009	BMW		5	2009	CA105
CA106	2010	Benz	AZ12	10	2010	CA106

Rental Table

RentalId	CustAccount	CarId	FromDate	ToDate	ToDate	FromDate
RE101	1104	CA101	10/12/2010	10/29/2010	10/29/2010	10/12/2010
RE102	1102	CA102	11/17/2010	12/14/2010	12/14/2010	11/17/2010
RE103	1203	CA103	11/24/2010	12/15/2010	12/15/2010	11/24/2010
RE104	1301	CA104	12/10/2010	1/5/2011	1/5/2011	12/10/2010
RE105	1304	CA101	1/3/2011	1/18/2011	1/18/2011	1/3/2011
RE108	1303
RE107	1202
RE106	2024	CA103	1/10/2011	1/29/2011	1/29/2011	1/10/2011

Inner Join

Select records from main table that have matching record form join table.

Main table record and join table records are joined together  and show as single record.

Code                                                                                                              

static void JoinExamples(Args _args)                                                                        

{                                                                                  

    CarTable carTable;                                                                        

    RentalTable rentalTable;                                                                           

    ;                                                                              

    while select carTable join rentalTable                                                                              

        order by carTable.CarId                                                                        

        where carTable.CarId == rentalTable.CarId                                                                             

                                                                                   

        {                                                                          

            info(strfmt("Car id is %1 renatla id is %2",carTable.CarId, rentalTable.RentalId));                                                                         

        }                                                                          

}

           

Output