I got task to extend the existing dynamics ax SSRS report. Client also wants to sustain the existing report. They want a new report that will be replicate the original one with extended features. Data provider classes are easily duplicated by right clicking on it and select duplicate, I renamed the duplicate classes in AOT. Initially I did not change anything in renamed classes so duplicate report will work with old data set.
But I did not find any duplicate option on AOT. After R&D I found that report can duplicate in visual studio. I create a new visual studio project Report project. Open Application Explore, Expand SSRS report node and drag it into visual studio project. Visual studio automatically duplicated the existing report
You can open Application explorer in Visual Studio è Viewè Application Explorer.
. Now the duplicated report will pointed to old Data provider class. Next step I copied the names of data set fields and parameters and properties into Notepad. When I point the data set to duplicated classes, a new data set created, and parameters became duplicate. I removed the old parameters and set the new parameters with new names and their properties to as they were in deleted parameter. After this I checked that report layout is working with new data Set, Now I started modification in report and classes with requirements.
During last couple of years, I have integrate data with Dynamics Ax both with SSIS and BizTalk. I common question is asked to me what is difference when every thing is possible in SSIS why we need BizTalk or what BizTalk provide different from SSIS. So My answer to this question is something like
Everything what BizTalk provide can be implemented in SSIS. But major difference is batch processing. Usually SSIS package are used to migrate large set of data or dataset. BizTalk provide the operations to be perform on one message at time or real time processing. Because everything in BizTalk is XML so BizTalk is very slow on large set of data. BizTalk provide large number of adapters, while In SSIS you have to use direct connection by Oldb, or Sql db to communicate with different database and depend on OlDb connections. In BizTalk large number of Adapter provided to communicate which may or may not be depend on OlDB connection. Build in Tracking system (BAM) and its display on BAM portal is also big advantage on SSIS. For this purpose you have to made custom tracking system in SSIS which require a lot of coding. Third advantage of BizTalk over SSIS is BRE. Business rule engine. BRE provide the condition whose value can be changed and complete follow of BizTalk application. These BRE roles can be used in multiple biztalk application while these functionality can be achieved on config files in SSIS.
In conclusion when we required less data integration/migration and require complex decision making we are used BizTalk for example we have to implement complex work flow on single record. BizTalk application also used route data, read from one location, transform it and drop on other location. Simple example of this transactional data, when one transaction is occur in one system and its impact or integration will required on other system we will used BizTalk. BizTalk is rapid development tool as compare to SSIS.
When we have large sum of data , required less complexity and requirement of integrated systems are based on Same technology then we have to use SSIS. Usually SSIS used to migrate or integrate the non-transaction data or step up data. The delay of migration and integration possible or example Batch processing. SSIS is built for ETL process, it is not rapid integration tool.
In Ax Dynamics usually work is pop out regarding customization of what is existing In Dynamics Ax. Usually is one of them is Report customization. If you are new in Dynamics Ax, Report locate and open mode will create more headache then modifying it. Let’s explore what steps require to open report in Edit Mode.
First step is determining the Name of report. You can identify it by menu item from it is running.
For example we want to edit the following report as per MSDN link
Menus > InventoryAndWarehouseManagement > Reports >BaseData > Quantity setup
Now Go to AOT and expend InventoryAndWareHouseManagement and right click to view the properties of Quantity Setup.
From Property you can identify the Name of MenuItem and its type. The menu item for Quantity setup is InventTableQuantity.
Now expand from AOT and Expend Menu Items and then Output Node. Because there are too many menu Items in AOT Node so you have to type when you reach on InventTableQuantity right click on it and explore the properties. You can find the Object property described the report Name of Quatity Setup is InventTableQuantity.
Now third step is go to locate the Visual Studio Projects and then Edit it.
For this purpose in the AOT, expand the node for Visual Studio Projects and then expand the node for Dynamics Ax Model Project. The project name will be similar to report Name, There are too much visual studio project so type InventTablQuantyReport. Right click on it and select edit.
Report project will be open to Visual studio, where you can modify.
Today I found the link on Microsoft website, where they upload the Entity Relationship diagrams for dynamics Ax 2012 table.
Further detail link is below.
Recently I made a new Virtual machine for dynamics Ax 2012. The issue was the VM was clean, no legal entity and no step up data present in it. Purpose of making this virtual machine is to study functional side of dynamics Ax 2012. On Searching start up data, I found excellent article by MVP Murray Fife.
Murray Fife identity following steps for configuration of dynamics Ax 2012
Configuring the Legal Entity:
This is require for Legal entity, form which everything will operate. In my Case it will be Lahore 01 i.e. lh01 Legal entity.
Configuring a Business Unit:
For ledger it is a better to create a new business unit for Legal Entity.
Configuring Account Structures:
Account structure will be required to post new company ledger from within the organization.
Configuring Company Ledger:
After configuration of account structure, company ledger will link to this structure and define the Account codes.
Configuring Automatic Transaction Accounts:
There is requirement of auto transaction accounts at organization level.
Creating a Bank Account:
Last step is configuration of Default Bank Account.
The complete article by MVP Murray Fife.
My Presentation on Dynamics AX 2012 Development Introduction.
Recently I update my dynamics Ax development Environment by restoring Database from Production Dynamics AX Db. After the restoring the database, when I run any SSRS report form Dynamics Ax, it starts to give error ”Only integrated security is supported for AX queries.”
The reporting Services are working perfectly other than Dynamics Ax reports.
One way to apply the Windows Integrated Security on required report. By following way
- Open Reporting Services Configuration Manager ( All Programs > Microsoft SQL Server 2008/2012 > Configuration Tools > Reporting Services Configuration Manager)
- Go to “Report Manager URL” Tab and click on URL
- Typically, URL will be in the format http://<ServerName>:80/Reports
- Select the Report under Dynamics Ax Folder
- In the opened page, select Data Sources on the left pane.
- And apply Windows integrated security and click Apply.
But I found that error on all SSRS reports for Dynamics Ax 2012. For this, best way to delete all reports and redeploy them.
Steps are as follows:
- First step to delete all reports, by selecting Dynamics Ax folder in Report server and delete it, this will all reports inside the reporting reports.
- Then go to Report servers form in Dynamics Ax 2012 and click on “create report folder” button to create the Folder Dynamics Ax again
- Now you can open Powershell (Administrative Tools > Microsoft Dynamics Ax 2012 Management Shell). Make sure you run Powershell as Administrator.
- Deploy all the reports with the help of command:
Publish-AXReport -ReportName *
- Wait for completing the report deployment after it all reports will run fine.
On Google search i found very beautiful png file belongs to cognitive group. It will really help for me and for others. It belongs to other, but i like to share it with reference of owner,
In Dynamics Ax 2012, there is form for configuration parameters. There parameters will further use in sending email. Following is the path of Step.
System Administrator è step upè Email parameters
These value stored in Dynamics ax 2012 table SysEmailParameters you can get these values by querying on this table using X++ code.
Consider following X++ job which read values form SysEmailParameters and send email using SysMailer api.
static void SendEmail(Args _args)
SysEmailParameters parameters = SysEmailParameters::find();
relayServer = parameters.SMTPRelayServerName;
relayServer = parameters.SMTPServerIPAddress;
portNumber = parameters.SMTPPortNumber;
userName = parameters.SMTPUserName;
password = SysEmailParameters::password();
subject = "Subject line for the email";
body = "<B>Body of the email</B>";
interopPermission = new InteropPermission(InteropKind::ComInterop);
mailer = new SysMailer();
info("Email has been send!");
e = ClrInterop::getLastException();
e = e.get_InnerException();
info ("Failed to Send Email some Error occure");