December 6, 2011 in Blog, Dynamics AX by Amer

Dynamics Academy – An Academic Project for Microsoft Dynamics in Saudi Arabia

Everyone in the Dynamics filed remembers very well how hard it was to get into the track of any Microsoft Dynamics producttechnically or functionally. Apart from missing of  learning resources, qualified consultants were also missed.

A great initiative that we always missed since so long time is now live in Saudi Arabia. Dynamics Academy is an academic initiative that was taken to support the Microsoft Dynamics community in Saudi Arabia with academic programs in all kinds with Microsoft Dynamics AX, GP, NAV and CRM.

From its early days, Dynamics Academy has put an objective in mind that is helping  Microsoft Dynamics vendors and clients in the region to educate their resources and put them on the right track to increase the success probabilities. The academy is seriously taking the responsibility of such education programs by starting with fresh individuals who have no experience in ERP, CRM, nor any business solution implementation even. Those individuals will be ready to get involved as functional and technical consultants in junior levels in Dynamics AX, GP, NAV and CRM implementations.

This initiative was taken by three contributors from the community: Ahmad Maghraby (CPIM, CSCP, PMP, MCT),  Ahmad Yakan (MCT, MCBSP) and I.

For more information about the Dynamics Academy and to get announcements on the trainings, visit the academy website: http://www.dynamicsacademy.net/.

May 21, 2011 in Blog, Dynamics AX by Amer

Microsoft Dynamics AX Brains Event News

Two weeks ago, I was very pleased to announce our intend to conduct the Microsoft Dynamics AX Brains event in Riyadh at the 19th of May. Today and after the event, I’m really happy to say that the Dynamics AX Brains event was successfully delivered.  :)

During around five hours, 140 attendees has enjoyed the very new news about the Microsoft Dynamics AX 2012. In the welcoming note, I have welcomed the attendees and introduced to them Mainly we have covered three areas:

• What’s new in Microsoft Dynamics AX 2012 SCM and Manufacturing, by Ahmad Maghraby
• What’s new in Microsoft Dynamics AX 2012 Finance and Projects Accounting, by Ahmad Yakan
• What’s new in Microsoft Dynamics AX 2012 Technology, Architecture and IDE, by Amer Atiyah

I will leave you with some pics from the event .

May 17, 2011 in Blog, Dynamics AX by Amer

Reminder to Attend the Microsoft Dynamics AX Brains Community Event

If you have registered for our Dynamics AX Brains event, then we would like to thank you very much for registering to the “Microsoft Dynamics AX 2012, a New Generation of ERP Systems” event. If you did not register yet, then you can register now on the event Registration Page.

This email is to remind you with the event that be held in the 19^th of May, 2011 in the PSU – Riyadh. For more details about the event please check the Registration Page.

Location:

Old Management Building – Prince Sultan University
King Abdullag St. (Exit 10) Cross with Abu-Bakr AlSeddeeq St.
Riyadh, Saudi Arabia

(Click to enlarge the map)

Time:

Thursday 19th of May, 2011
Registration begins at 10:00 AM.
Remember the Prizes for the first five attendees.

We look forward to see you all there .

Best regards,,,
The Dynamics AX Brains Community Members

March 30, 2011 in Blog, Dynamics AX by Amer

List of “Whats New in Dynamics AX 2012″ Documents is Now on PartnerSource!

Finally Microsoft has released some documents about the long waited Microsoft Dynamics AX 2012. These new training materials highlight the new features in Microsoft Dynamics AX 2012.  These materials are currently downloadable on PartnerSource (Partner Service Plan required).   They will be orderable (can be purchased) beginning April 21.

• What’s New – Application in Microsoft Dynamics AX 2012 for Finance, PA, Case Mgmt., HRM and Public Sector Course Number 80164
• What’s New – Technical in Microsoft Dynamics AX 2012 for Implementation Course Number 80165
• What’s New – Application in Microsoft Dynamics AX 2012 for Supply Chain Management and Manufacturing Course Number 80163
• What’s New – Technical in Microsoft Dynamics AX 2012 for Development Course Number 80299
• What’s New – Local Functionality in Microsoft Dynamics AX 2012

Have fun .

February 26, 2011 in Blog, Dynamics AX by Amer

My AX Session at the ROCS2

Yesterday I provided an online session for the technical community in Saudi Arabia.

This session will be the beginning of a series of Dynamics sessions covering most of the technical areas like MorphX, Workflow, EP, Reporting… etc.

The session I gave yesterday provides an overview about the Dynamics AX from technical perspective. I described the Architecture, IDE, X++, EP, Reporting and BI, and Workflow.

You can download the PowerPoint file from here.

February 6, 2011 in Blog, Dynamics AX by Amer

Populating Data from Different Companies

I came across a case where I needed to select a field value from different companies in Dynamics AX.

Simply what you have to do is the following (I choose ItemId to be taken from different companies as an example):

1. Create a field in your table with an ExtendedDataType than has NO relation, MyNewItemIdEDT in our example
2. Create an ItemCompany field, put the extended data type as dataAreaId
3. Create a Relation in that table with the following elements (Normal relation elements):
   • <<NewTableName>>.MyNewItemId == InventTable.ItemId
   • <<NewTableName>>. ItemCompany = InventTable.dataAreaId

By this you would be able to select the ItemId field based on the selected dataareaid without writing any code even.

January 30, 2011 in Blog, Dynamics AX by Amer

Riyadh Online Community Summit February 2011

As part of Microsoft technical community contributions in Saudi Arabia, we are conducting a two days online event in February 10th and 11th.

Dynamics AX Brains will conduct a Dynamics AX session by the end of that event called: “The What, Why and How Answers of Dynamics AX” which will give an overview about the Dynamics AX 2009 from functional and technical perspectives.

There are going to be other topics to be covered like Windows Azure, Silverlight, SharePoint 2010, XNA, Windows Phone 7, Dynamics CRM 2011, and SSIS.

Wish you can attend! Remember that the Dynamics AX session will be on the 11th at 03:00 PM Riyadh time.

January 7, 2011 in Blog, Dynamics AX by Amer

Upcoming Microsoft Dynamics AX Webcasts from Microsoft

The great Microsoft Dynamics team is conducting some sessions in the coming period. Those online sessions will cover topics in all Dynamics products including Microsoft Dynamics AX.

The first coming event will be “Management Reporter and Performance Management with Microsoft Dynamics AX“ that will be held in the 12th of Jan. The next session will be “See the New Payroll for Microsoft Dynamics AX“, and I’m really excited to attend this session to see the new Payroll. The Payroll session will be in the 1st of Feb.

To see full list of those webcasts and to register, click here.

June 24, 2010 in Blog, Dynamics AX by Amer

Some Cool Statistics about Microsoft Dynamics AX

A study was done by Job Graphs (http://www.jobgraphs.com/) for Microsoft Dynamics AX as a global software product. I leave you with the graphs.

Modules demand trend

Salary Comparison

Role Wise Comparison

Experience based demand trend

Dynamics AX World Wide Demand

Source: http://jobgraphs.com/dynamics-ax/

June 14, 2010 in Blog, Dynamics AX by Amer

How to Use Number Sequence Engine Efficiently with Dynamics AX Forms

If you wanted to write a an X++ code to generate a number sequence and assign it to a field, you might use the following X ++ statement.

1

yourTableBuffer.Field = NumberSeq::newGetNum(NumberSequenceReference::find(TypeID2ExtendedTypeId(TypeId(YourExtendedDataType)))).num();

And for the continuous number sequence (notice the “true” parameter):

1

yourTableBuffer.Field = NumberSeq::newGetNum(NumberSequenceReference::find(TypeID2ExtendedTypeId(TypeId(YourExtendedDataType))), true).num();

But, what you could do if you have that field in form and you want to generate a number sequence while the user creates a new record is the class NumberSeqFormHandler.

NumberSeqFormHandler is a great class that doesn’t only take care of generating a new number sequence for your field… but also it takes care of removing or inserting that number in the Number Sequence List table when the number is not used (in case that the record hasn’t been inserted although the number has been already generated).

To use the NumberSeqFormHandler class, you have to declare a NumberSeqFormHandler object in the class declaration. Also you have to create a method at the Form level like the following:

1
2
3
4
5
6
7
8
9
10
11
12
13
14

//Form level method
NumberSeqFormHandler numberSeqFormHandler()
{;
    //you should have been declared numberSeqFormHandler variable in the ClassDeclaration of your form
    if (!numberSeqFormHandler)
    {
        numberSeqFormHandler = NumberSeqFormHandler::newForm(NumberSequenceReference::find(TypeID2ExtendedTypeId(TypeId(YourExtendedDataType))).NumberSequence,
                                                             element,
                                                             YourDataSourceName,
                                                             fieldnum(YourTableName, Field));
    }
 
    return numberSeqFormHandler;
}

Then you need to actually call the NumberSeqFormHandler class methods like:

1
2
3
4
5
6
7
8
9

//Form methods
public void close()
{
    if (numberSeqFormHandler)
    {
        numberSeqFormHandler.formMethodClose();
    }
    super();
}

1
2
3
4
5
6

//DataSource method
public void write()
{
    element.numberSeqFormHandler().formMethodDataSourceWrite();
    super();
}

1
2
3
4
5
6
7
8
9
10

//DataSource method
public boolean validateWrite()
{
    boolean ret;
 
    ret = super();
    ret = element.numberSeqFormHandler().formMethodDataSourceValidateWrite(ret) && ret;
 
    return ret;
}

1
2
3
4
5
6

//DataSource method
public void linkActive()
{
    element.numberSeqFormHandler().formMethodDataSourceLinkActive();
    super();
}

1
2
3
4
5
6

//DataSource method
public void delete()
{
    element.numberSeqFormHandler().formMethodDataSourceDelete();
    super();
}

1
2
3
4
5
6
7
8
9

//DataSource method
public void create(boolean _append = false)
{
    element.numberSeqFormHandler().formMethodDataSourceCreatePre();
 
    super(_append);
 
    element.numberSeqFormHandler().formMethodDataSourceCreate();
}

By this you will have your form works efficiently with the Number Sequence engine of Dynamics AX  and you don’t have to write any code at the table level… so remove all that code that you might have written at the initValue method of your table.

One last important thing, NumberSeqFormHandler works with Continuous and non-Continuous number sequences. But if you want to “regenerate” the unused numbers that have been previously generated, you have to set your number sequence as Continuous of course.

May 31, 2010 in Blog, Dynamics AX by Amer

How to Create a Primary Key for a Dynamics AX Table

This topic might not be new to most of you guys, but I always wondered how can I create a primary key to a Dynamics AX table?

You could easily create index in any table in Dynamics AX and you could specify that this index is “not duplicated”, which means that values of the field(s) should be unique among the table values. But this does not mean that you this index is a Primary Key index!

To create a Primary key you have to set the PrimaryIndex property in the list of that table properties.

When you choose the PrimaryIndex property you have to set that index as “not duplicated”. Once you do that, you will have the icon of that index changed to be like this:

January 18, 2010 in Blog, Dynamics AX by Amer

Microsoft Dynamics AX Industry Solution Event – Riyadh 17-01-2010

Today I attended the Microsoft Dynamics AX Industry Solution Event which was held in Marriott hotel in Riyadh. Microsoft Arabia MBS team was managing the show. Also five of Microsoft Dynamics AX partners in Saudi were there showing the business capabilities of Microsoft Dynamics AX 2009.

Mr. Emad Bakila, Microsoft Arabia MBS manager, started the event by describing Microsoft vision and strategy of Microsoft Dynamics in the market. He spoke about Microsoft Dynamics ERPs and Microsoft Dynamics AX roadmaps, high level features of Microsoft Dynamics AX, business market needs, adaptation of those needs with Microsoft Dynamics ERPs… etc.

After this partners started one by one to show features of Dynamics AX, each of them was showing one business field.

Partners and what they were speaking about is like the following:

 Finally, Housam Wafai from Microsoft Arabia, described the implementation methodology of Microsoft Dynamics ERPs: Microsoft Dynamics Sure Step. Also at the end, he was showing a 15 minutes video showing the amazing capabilities of Dynamics AX like the BI tools, communication stuff, workflow… etc. I will try to get that video and update you guys with this.

Here are some pics from sessions of today (click to enlarge):