December 08, 2014

Exam MB6-704 Microsoft Dynamics AX 2012 R3 CU8 Development Introduction Certification

Exam MB6-704 Microsoft Dynamics AX 2012 R3 CU8 Development Introduction Certification 
Hi Friends,

Microsoft just released one more certification for Dynamics AX 2012 technical. Its still not available for registration but soon (within couple of days) it will be available for all of us.

Here is some details about this exam.

Study Guide

80670: Development I in Microsoft Dynamics AX 2012 R3 CU8
80671: Development II in Microsoft Dynamics AX 2012 R3 CU8
Exam Topics:
Describe the Dynamics AX Architecture, Manage the Data Dictionary, and Manage the User Interface (30% - 35%)
Describe the Dynamics AX architecture
This topic may include: Identify the features of Dynamics AX; describe the architecture of Dynamics AX; describe the development environment; describe licensing and configuration; describe the model-driven architecture.
Manage the data dictionary
This topic may include: Work with MorphX and the application object tree (AOT); describe primitive and extended data types; create tables; work with indexes, relations, enumerations, and views.
Manage the user interface
This topic may include: Create forms; join data sources; create menu items; create forms from form templates; work with list pages and FactBoxes.
Work with X++ (35% - 40%)
Describe X++
This topic may include: Identify the characteristics of X++; develop by using tools, such as the debugger and the Compare Tool; describe best practices; implement reverse engineering.
Work with X++ control statements
This topic may include: Work with variables, operators, conditional statements, and loops; use built-in functions; use communication tools.
Manage objects and classes
This topic may include: Work with objects, classes, and inheritance; work with scoping events and parameters.
Manage exception handling
This topic may include: Work with exceptions and optimistic concurrency exceptions; work with throw and try/catch statements.
Manage Security and Database Access (30% - 35%)
Work with role-based security
This topic may include: Set up a new user; assign roles to users; change duties on a role; change privileges on a duty; assign permissions to a privilege.
Understand security for developers
This topic may include: Understand permissions and security policies; work with Code Access Security; use display method authorization.
Access the database
This topic may include: Retrieve data; manipulate data; work with queries.

Soon I will share more details about this new certification.

-Harry

October 30, 2014

Get Default Workflow list in AX 2012

How to Fetch Default Workflow list in AX 2012

Hi Folks,

Here is a job to fetch existing workflows in AX 2012.

static void TheAxapta_WFList(Args _args)
{
#AOT
Treenode                workflowTypesNode, workFlowNode;
int                     i;
int                     nodeCount;
str                     workflowName;
SysDictWorkflowType     sysDictWorkflowType;
SysDictWorkflowCategory sysDictWorkflowCategory;
;
workflowTypesNode = treenode::findNode(#WorkflowTypesPath);
nodeCount = workflowTypesNode.AOTchildNodeCount();
workFlowNode = workflowTypesNode.AOTfirstChild();
for (i=1; i<=nodeCount; ++i)
{
workflowName = workFlowNode.AOTgetProperty("Name");
try
{
sysDictWorkflowType = SysDictWorkflowType::newTypeName(workflowName);
sysDictWorkflowCategory = new SysDictWorkflowCategory(sysDictWorkflowType.category());
info(sysDictWorkflowCategory.label() + ";"
+ sysDictWorkflowType.label() + ";"
+ sysDictWorkflowType.help());
}
catch ( Exception::Error)
{
exceptionTextFallThrough();
}
workFlowNode = workFlowNode.AOTnextSibling();
}
}

Your output must look like below

image
- Harry






October 11, 2014

Another year...... MVP

Hi All, 
I would like to share this golden moment with you all, Again I’m awarded by Microsoft as Most Valuable Professional (MVP) this year as well.
Its third time in row when I recognized by Microsoft for Dynamics AX. 
Thanks to each of you for your guidance and support.   
Old Post:
1st Year Award

-Harry Follow us on Facebook to keep in rhythm with us. @Facebook

October 09, 2014

ValidTimeStateFieldType Property on Table- AX 2012 R2, R3

ValidTimeStateFieldType Property on Table- AX 2012 R2, R3

What is the use of “ValidTimeStateFieldType” property on table

Date effective data is tracked in a table that has its ValidTimeStateFieldType changed from its default value of None. Also, an index with its ValidTimeStateKey set to Yes must be added on the table. The system automatically adds the fields named ValidFrom and ValidTo to the table, which will be of type date or utcdatetime. The system automatically prevents overlap between the date ranges in these two fields among rows that track the same entity.

clip_image001

clip_image003

How to fetch records from this type of tables

The following code sample returns the records that are effective during 1/1/2001 and Current date:

static void theAxapta_ValidTimeState (Args _args)

{

vendTable vendTable;

TaxRegistration TaxRegistration;

DirPartyLocation DirPartyLocation;

date ToDate = today();

date FromDate = 01\01\2001;

while select validtimestate(fromdate, ToDate) * from TaxRegistration

join DirPartyLocation

where TaxRegistration.DirPartyLocation == DirPartyLocation.RecId

{

select vendTable where vendTable.Party == DirPartyLocation.Party;

info(strfmt(“%1”, VendTable.Name));

}

}

For more details

http://msdn.microsoft.com/en-us/library/gg861781.aspx

White papers

http://download.microsoft.com/download/4/e/3/4e36b655-568e-4d4a-b161-152b28baaf30/using_date_effective_patterns_ax2012.pdf

http://www.microsoft.com/download/en/details.aspx?id=20864

 

-Harry