Sunday, October 30, 2011

Few days ago while working with importing customizations and re-freshing AOT in Dynamics AX 2009, we stuck with the following error "Illegal data conversion from original field [field names]Unable to convert data types to anything but character field type (0 to 4)." Found a great blog on that topic. Hope, will solve, if you  stuck with similar problem. Click on link read blog

Tuesday, September 6, 2011

Dynamics AX 2012 licensing

Every company must cope with software licenses these days. Good understanding of license programs can bring significant savings; unawareness can comprises needless expenditures or leads up to violating license agreements and relevant consequences.
Dynamics AX 2012 comes with a new license model, which is similar to licensing of other Microsoft products and it brings also other advantages. This article has set a target to introduce basic concepts of Dynamics AX 2012 licensing and to quote links to sources of more detailed information. Read complete blog at

Monday, August 1, 2011

Currency Setup in Dynamics AX 2009

Good Day!!!

Today we will be looking at Currency Setup in Dynamics AX 2009. Our agenda will be to learn following things.

1-      Create currencies in Dynamics AX

2-      Currency setup in General Ledger setup

3-      Setting company default currency

Ok, now let’s start

1-      Create currencies in Dynamics AX
To create currency:
Go to:  General Ledger à  Setup à Exchange Rates

As you can see in above screen shot we have five tabs on this form. First is the overview tab. In this tab we’ll create new currency. To create new currency press Ctrl + N, click on Currency field write new currency short name (3 characters limit), in Name field write descriptive name for new currency, in ISO field select ISO currency code for new currency and in Symbol field enter symbol for new currency created.
In second section of the Exchange rates form, are the exchange rates for currency. You can define exchange rates for each day. If you want to use one exchange rate leave Start date field blank. AX will automatically use last exchange rate add, if multiple exchange rate are available.
Next is the general tab which shows same information as in Overview tab except the Gender field (Optional if you are not using Spanish check).
Third tab is the Currency convertor. Enable currency conversion by check mark on Conversion.  Postfix and prefix are character you want to add after amount. Enter spaces before and after postfix and prefix fields to separate from amount.

After doing above setting we will get following result as in Chart of Accounts form in below screen shot. Refer to the currency format in "Balance" Column.

Third tab is Posting define Realized loss, Realized profit, Unrealized loss, Unrealized profit due to currency exchange rate.

These settings depends on your company policies and weather you are using foreign currency for billing and payments. I will be posting a detailed blog on this topic soon. 

Last tab is Round-off as the name shows it’s about rounding off currency.

General rounding-off applies to all modules and there are separate settings for Account Receivable, Payables and Prices. You can read more about rounding in the end of this document.
2-      Currency setup in General Ledger
Next, we will see Currency setup in General Ledger
In General Ledger module go to parameters then ledger tab you will see following settings:

In Express exchange rate Specify how much of your currency equals to 100 units of foreign currency. Maximum penny difference is for adjustment of penny after currency conversion in primary currency.
3-      Setting up company default currency
To set company default currency
Basic à Setup à Company Information à Other tab à Currency à Currency
You can select any currency you have created in currency exchange form.

Rounding in Exchange rates form:
We have amount 6827.28. Below table describe how Round Off and Rounding form works.
Rounding form
Round off .01
Round off .10
Round off 1.00
Round off 10.00
Round off 100.00

That’s all for now.
Good Bye!!

Wednesday, June 22, 2011

Chart of Accounts setting in GL Parameters.

Let’s start with the Charts of Accounts (COA). Before start creating your chart of accounts it is good to plan first, if you are upgrading from any legacy system it would be better to start with old COA.

You can create COA either 

  •      By importing data from other company 
  •           By creating each account one by one
  •      or  Use default data for that, which is in installation CD.
There are two important settings related to COA in GL parameters form.

Go to:  General Ledger àSetup à Parameters à Ledger à Account Length as in fig: 1.1

Fig: 1.1

Define Account Length in Account Length Field (for unlimited write set field to 0).

Define Control type on Account Length. This is basically an action to be taken, if account length increases from, what is defined in Account Length field.

Then we have Group total account length. Group Total is an account type in Chart of Accounts form It can be clarified by following example:

In your demo company, first, create an account with
Account Number:  ‘1’
Account Name: ‘Group Total of 1’
Account Type: ‘Group Total’.

Second set Group total account length in General Parameter form to ‘6’.

Dynamics AX will follow these steps to calculate this account. First, it will check Group total account length field in General ledger parameters form. From this field it will know the length of account to be considered for calculating total. Then, it will check the account number field in new account (which is ‘1’). Next it will total balances of all account whose Account Number starts with 1 and the length of account number is 6 characters.

Last for Chart of Accounts setup in Parameter form, we have Automatic account type selection if you enable it and create new account in COA form, Account Type field will automatically populate according the settings done in Automatic Account type selection form. To access this form

Goto: General Ledger à Setup à Posting à Automatic Account type selection

I hope this will be help full for you. If you feel like something is missing something more to be added to improve this topic do tell me and I add that to. Thank you for your time.

Have a nice day!!