AX 2012 Developer Resources

AX 2012 Developer Resources

In this post i am sharing AX 2012 resources links, including development helps, Downloads, Articles  Blogs. All links are grouped by Topic
 

Events
Introduction
Eventing Basics (code walkthrough)
Managed Handlers for Pre/Post events (code walkthrough)
Managed Code Handlers for Delegates (limitations) (code walkthrough)
Microsoft Whitepaper: Eventing (download)
Eventing Terminology and Keywords (MSDN Article)
Naming Conventions for Delegates and Event Handlers (MSDN 

X++ Language
X++ as a Managed Language in the .NET Runtime (code walkthrough)
AX 2012 X++ Language Changes, Stricter Syntax (MSDN Article)
.NET Interop to X++ Issues when X++ runs as CIL (MSDN Blog)
Deploying AX 2012 Code
New Query Object Features (code walkthrough)
Creating Code Snippets and method templates (code walkthrough)


Data Access
Computed View Columns (code walkthrough)
Valid Time State/Date Effective Framework - Part 1: Creating the table (code walkthrough)
Valid Time State/Date Effective Framework - Part 2: Querying time state tables (code walkthrough)
Microsoft Whitepaper: Using Date Effective Patterns (download)


Debugging
Debugging X++ Running in CLR using Visual Studio (code walkthrough)



General Topics
Microsoft Guide: What's New for Developers (download) [fixed link - thanks to reader Waldemar Pross]
Microsoft Guide: New, Changed and Deprecated Features (download)
Microsoft Whitepaper: Deploying Customizations Across Environments (download)
Dynamics AX 2012 System Requirements (download)
Deploying AX 2012 Code
Importing Data Using the Excel Add-Ins


Reporting
Multiple instances of Reporting Services on the same machine (TechNet Article)
Microsoft Whitepaper: Report Programming Model for Dynamics AX 2012 (download)


SysOperation Framework
From RunBase to SysOperation: Business Operation Framework (code walkthrough)
From RunBase to SysOperation: Business Operation Framework (SysOperation query and customizing BOF dialog) (code walkthrough)
MSDN SysOperation Framework (MSDN Article)
SysOperation Framework Whitepaper (download)


UnitOfWork
Unit of Work Magic (code walkthrough)


Table Inheritance
Microsoft Whitepaper: Developing with Table Inheritance (download)


Model Architecture
Models and Layers Basics (code walkthrough)
Powerful Combination of Models and Events for No-Merge Code Solutions (code walkthrough)
Deploying AX 2012 Code


Managed Code
Using Visual Studio 2010 with AX 2012 (code walkthrough)
Writing and Calling Managed Code from AX (code walkthrough)
Limitations for Managed Code Event Handlers (code walkthrough)
Proxy Classes Gotcha (code walkthrough)
Creating Proxies for Kernel Classes (classes not visible in the AOT) (code walkthrough)
Microsoft Whitepaper: Selecting the Best Development Technology for Your Scenario (download)
X++ as a Managed Language in the .NET Runtime (code walkthrough)
.NET Assembly Deployment in AX 2012
.NET Interop to X++ Issues when X++ runs as CIL (MSDN Blog)


Services
From RunBase to SysOperation: Business Operation Framework (code walkthrough)
Using System Query Service in WPF (code walkthrough)
MSDN Business Operation Framework (MSDN Article)
Microsoft Whitepaper: Services (download)
Consuming External Webservices (code walkthrough)
Trusted Intermediary in AIF (code walkthrough)


Security
Trusted Intermediary in AIF (code walkthrough)
Microsoft Whitepaper: Developing Extensible Data Security Policies (download)
Microsoft Whitepaper: Using The Policy Framework (download)


Various
10-minute AX 2012 App: WPF (code walkthrough)
10-minute AX 2012 App: Windows Azure (code walkthrough)
10-minute AX 2012 App: Windows Phone 7 PART1 (code walkthrough)
10-minute AX 2012 App: Windows Phone 7 PART2 (code walkthrough)
10-minute AX 2012 App: Windows Phone 7 PART3 (code walkthrough)app.html

Foreign-Key Table Relationships
RecIds as Foreign Keys (code walkthrough)
Microsoft Whitepaper: Migrating EDT Relations (download)
-Harry

Get Current Company in AX

Get Current Company in AX

Below is the example on how to get current company in AX 2009.
In AOT > Jobs, paste the following code:

static void curExtExample(Args _arg)
{
    str curCompany;
    ;
    // Sets curCompany to the extension of the current company.
    curCompany= curExt();
    print "Current extension is " + curCompany;
    pause;
}

You can use this code in your forms and reports also to parameterized your reports/Forms.

-Harry

Get the latest exchange rates in Dynamics AX 2012 [Using X++]

Get the latest exchange rates in Dynamics AX 2012 Using X++

Below small snippet will help you to get the latest exchange rates as on today.
I am using x-rates URL to pull the exchange rates for this example. 
Note: Please check and verify this web URL before using it [free source or not].



static void SR_getExchangeRates(Args _args)
{
int curPos, endPos, startPos;
TextBuffer tb = new TextBuffer();
System.Net.WebRequest webRequest;
System.Net.WebResponse webResponse;
str page;
System.IO.StreamReader streamReader;
try
{
webRequest = System.Net.WebRequest::Create("http://www.x-rates.com/d/INR/table.html");
// this will throw an webexception if cannot be reached.
webResponse = webRequest.GetResponse();
streamReader = newSystem.IO.StreamReader(webResponse.GetResponseStream());
tb.setText(”);
page = streamReader.ReadToEnd();
streamReader.Close();
tb.setText(page);
curpos = 1;
startPos = 1;
tb.regularExpressions(false);
tb.find(‘<a href="/d/INR/USD/graph120.html" class="menu">’, curpos);
startpos = tb.matchPos();
tb.find(‘</a>&nbsp;</font></td>’, startpos);
endpos = tb.matchPos();
page = tb.subStr(startpos, endpos – startpos);
info(strFmt("1 USD = %1 INR",strreplace(page,‘<a href="/d/INR/USD/graph120.html" class="menu">’,”)));
// Close the webResonse
webResponse.Close();
}
catch(Exception::CLRError)
{
throw error(AifUtil::getClrErrorMessage());
}
}
Below is the output:



You can integrating the exchange rates in to the tablesExchangeRate , ExchangeRateType , ExchangeRateCurrencyPair

To get exchange rates for other currencies you may need to modify the URL  as shown below. [Change INR to EUR etc.]




Enjoy...........

-Harry

How to handle SSRS reports which will take long time

How to handle SSRS reports which will take long time

We know that there are/will be some reports which will take more time to render due to the many rows/transactions. This post will help you to show appropriate warning/error messages to the end user while running the report.

The number of records that are processed by report might be large and the user experience will be affected, because the client will be locked up if printing to the screen. 

In this case, you might want to return a warning message to the user that indicates that time to process the report might be long and confirm that they want to run the report. 

Another case could be where the number of records being processed is very large and a time-out might occur in report processing and clearly, we should not run this report.

In this case, we should not run the report and therefore, should return anSrsReportPreRunState::Error enumeration value with the error message.

In AX 2012, SSRS reports, through SrsReportRunController we can easily let the user know the report will take more time with warnings or error messages through preRunValidate method.

Example : General Journals report

Take the standard example of Print journal from General Ledger >> Reports >> Journal >> Print journal.

Use standard LedgerJournalController class to help you understand preRunValidate method: this validates container before running the report. Override this method to do custom pre-validation for any report. Typical use of this method will be to validate if the time taken to run the report is acceptable.

In this standard example: If the query is going to retrieve more than 1000 rows, a confirmation Box will be displayed to the user as shown below.

To get the confirmation box and for the sake of the demo/understanding: I have hardcoded the rows count to 1001 as shown below. There is a new static method in QueryRun::getQueryRowCount that will get the row Count of the query.

Please note: Remove hardcoded values later. This is hardcoded only for the sake of demo/Walk through

Clearly in the below standard example : warning limit is 1000 and error limit is 100000. 

Run this report as shown below...

Here comes the confirmation Box: 

If your report is long running, it may time-out. Do you want to continue?

Note: In order to resolve/by pass this confirmation Box, a developer can change the macro #define.warningLimit to greater value

Example : #define.warningLimit(2000);

you can increase the row count : to 1000001.



Let us run the report One more time as shown below.

Here comes the error message: Running the report has been cancelled due to the time it will take to run. Adjust the parameters of the report and retry.

In order to resolve this problem, Increase the ErrorLimit macro value in thepreRunValidate method.

Please note, it is not recommended to increase as it will take more time and your box cannot handle load.

Example : #define.ErrorLimit(150000);

Click below for original post...

how-to-handle-ssrs-reports-which-will-take-long-time-to-run-with-the-messages-to-the-user-dynamics-ax-2012-prerunvalidate-method 

-Harry