New Microsoft Dynamics Salary Survey Tracks Benefits, Profile, Attitude of Dynamics Professionals | MSDynamicsWorld.com

NigelFrank have done a recent survey on Microsoft Dynamics Salary across the globe. In this downturn economy it seems like Dynamics Professionals are getting more secured. More in the link below.

New Microsoft Dynamics Salary Survey Tracks Benefits, Profile, Attitude of Dynamics Professionals | MSDynamicsWorld.com

Dynamics AX EP Development Cookbook

Following is a great EP development book that can be used to jump start EP development,

http://blogs.msdn.com/b/epblog/archive/2010/01/05/ax-2009-ep-development-cookbook.aspx

Dynamics AX Enterprise Portal Videos,

Query:

I am new too Dynamics AX EP, how to jump start to EP?

Answer:

Well you should start with videos, few of the best links are below,

1- Enterprise Portal Development Webinar

2- Dynamics AX "How do I " video's

Then you can look into EP part of book, "Inside Dynamics AX 2009"

Sage ERP X3 Verses Microsoft Dynamics AX - jeremywire's blog

Sage ERP X3 Verses Microsoft Dynamics AX - jeremywire's blog

Container and unbounded string (text) fields are not allowed in a WHERE expression.

Container and unbounded string (text) fields are not allowed in a WHERE expression

"Here is a really simple error / solution. I came back to writing X after a few weeks of down time and actually forgot about this as I am predominately a C# programmer.
The problem:
Axapta does not want you to use an unbounded string in a where clause.�
The solution:
You must use a ‘bounded’ string.� To do this you must declare your string with a numerical limiter e.g. str 30.
Example:
PurchTable getFirstByCustomerPOId(str 30 customerPOId)
{
PurchTable purchTable;
;
purchTable.selectForUpdate(true);
select firstonly purchTable
where purchTable.My_CustomerPurchaseOrderId == customerPOId;
return purchTable;
}"

Workflow Dynamics AX

Following are some great sites for dealing with Dynamics AX Workflows,

http://workflowax.wordpress.com/category/testing/

http://workflowax.wordpress.com/category/installation/

http://blogs.msdn.com/b/emeadaxsupport/archive/2010/06/09/workflow-error-system-componentmodel-win32exception-access-is-denied.aspx

Displaying the text format of an AX Query

Question: How can you print the query associated with an AX Query?

Answer:
static void printQuery(Args _args)
{
Query query = new Query(querystr(MyQuery));
;
info(query.dataSourceNo(1).toString());
}

date in american standard format

Question: How can I get date in american standard format.

Answer: I have created a class that can be used to get the date in american standard format. Also there is a global method date2StrXpp that does exactly the same.

THe project can be downloaded here.

Assiging a lookup method to a control

Question: I want to add a runtime control and override a lookup method of it.
Answer: I have created a tutorial on form that can be used for this purpose. The form adds a control at run time and override the lookup method of it at runtime.

The form can be downloaded from here.

A form to display container values

Many times during debugging of container objects we normally have to view the current object list contained in the container. Normally we do it using debugger. The linked dynamics ax project will help you analyze the state of container by displaying all the container values in a form. The project contains a class and a job to use this class.
Click here to download the project.