Skip to main content


Showing posts from September, 2013

Table keys: Replacement key in AX 2012

Hello guys J today am going to walk through the different table keys in AX 2012 R2.As we know many different tables’ keys exist in AX 2012 such as Surrogate key, Alternate key, Primary key, foreign key etc.Since many of them are briefly explained on MSDN.But there are certain table keys which are difficult to understand just by the definition, something like “Replacement key”. So let me then showcase the practical scenario like how you can use it and the benefit of having that property in your table.What is replacement key??A replacement key is an alternate key that the system can display on forms instead of a meaningless numeric primary key value. Each table can have a maximum of one replacement key.The replacement key is chosen by setting theReplacementKeyproperty on the table. The drop-down list offers every alternate key as an available value. The drop-down list contains every index that has its AlternateKey property set to Yes.You might change the default blank value to an index …

SSRS Reports in MS AX 2012 - Basic understanding

Hi Friends J Hope All is well…J

These days I’ve been focusing on the BI and reporting aspects that come as part ofMicrosoft Dynamics AX 2012. So just thought of throwing some light on SSRSreporting in AX 2012. Let me first start with the introduction on AX SSRS Reports, and later with different kind of designing and developing of the reports.
What is SSRS..??? SQL Server Reporting Services (SSRS): is a server-based report generation software system. It can be used to prepare and deliver a variety of interactive and printed reports. It is administered via a web interface. Report Server: This is the primary database that stores all the information about reports that was originally provided from the RDL files used to create and publish the reports to the ReportServer database. In addition to report properties (such as data sources) and report parameters, ReportServer also stores folder hierarchy and report execution log information.
ReportServerTempDB: This database houses cached copies of re…

Workflow differences in MS AX Versions

AX 2009 AX 2012

> Separate workflow component have to be installed  > Requires IIS and .NET Business Connector > Requires additional security setup > Simplify workflow deployment and installation > Host the .NET Workflow runtime in AOS   > Separate installation no longer required. > Workflow server components need to be installed on a web server running Internet Information Services (IIS). >  Workflow server components are now automatically installed when installing the Microsoft Dynamics AX AOS. This new deployment significantly simplifies the administrative effort required to set up the workflow infrastructure. > Forward only, sequential workflows.  > Only interactive elements (tasks and approvals)  > Support for sub-workflows >  Expand workflow capabilities by providing broader applicability   > Introduce branching   > Introduce automated tasks  > Introduce line-item workflow support   > Introduce line-it…

Terminology - MS AX Technical

Write:   This method is invoked when a user inserts a new record or updates an existing one. If there are several data sources on a form and they are joined then the sequence of methods invoked on "save" is something like this: parent_ds.validateWrite() child1_ds.validateWrite() child2_ds.validateWrite() child1_ds.write() child2_ds.write() parent_ds.write()

Validate write: Determines whether data is valid and ready to be written. Returns true if data is valid; otherwise, false. This method is called from FormDataSource.write. If false is returned, the write operation is aborted and an error message is displayed. This method will get to fire when we update a record.

Insert & doInsert: Insert method is the normal method which get called when data insertion occur in table. Whereas doInnsert is the forceful insertion in to AX Tables I.e., it bypasses all the validation when inserting in to tables. ├śCalling DoInsert ensures that any Axapta X++ code written in insert method of the record is…