RSS

Monthly Archives: April 2016

Import Opening Balance Through AX 2012 Data import/Export Framework

Yesterday I came across the following issue  and thought I’d share my findings and solution.

Customer asked me to import opening balances from their existing legacy system.Data Migration is the key point for any implementation and Data Import/Export tool is most powerful tool with in Dynamics AX 2012 for data migration.

There are so many blogs written corresponding to this topic”How to import Opening balance through DIXF”.But everyone explained the feature of Dynamics AX Data Import/Export Framework and gave example importing of financial dimensions into a ledger journal for ledger accounts only But my customer requirement is different he wants to import financial dimensions into a ledger journal for customer,Vendor,Project account as well.

Unfortunately, I could not find any article which helps me to import financial dimensions into a ledger journal for Project,Bank & customer/vendor accounts.

Here I would not explain from the scratch how to import opening balance by using Dynamics AX 2012 data import/export framework.

You can refer Hai Nguyen’s Blog, How to start with Opening balances through DIXF

Importing a General Journal using Data Import/Export Framework AX 2012

I have been trying to import data from an CSV file using Data Import Export Framework and generated a sample file.

DIXF1.png

To demonstrate this,I am using AX 2012 R3 CU8 INMF Company.I am taking Bank Account “IND OPER”and Default dimension 024-003 where 024 is Deparment and 003 is Bussines unit.On other side Offset Account is ledger account 110125-024-005.Here 110125 is Main Account,024 Department and 005 is Business unit because my account structure is configured like below

Dixf2.png

Important note:If you want to import financial default dimension corresponding to then you have to choose extra field Default dimension for Account and for offset account choose field OffsetDefaultDimension while generating sample file(screenshot above).

So here question can arise why i am taking DefaultDimension field  for bank only and why not for ledger account.Because framework is capable to import financial dimensions without any issue for ledgers.

So lets take forward with the issue and solution,Even though the mapping  and staging data is validated successfully but when I try to import the data into target table – I get the below error:

Results. Record (‘INMF-00392-VN00000002-1.00’) . Unable to return DimensionAttributeValue record for 024
Data written to target ‘Opening balance’ (‘0’ records created, ‘0’ records updated)

When I tried to debug GenerateDefaultDimension methods in DMFLedgerBalanceEntityClass then I found cause.

As I mentioned above chart of account structure is with sequence Main Account-Department-Business Unit So Ledger accounts(offset account) should be according to account structure only.

Dixf3.png

But why its not working for Bank,even we have used same sequence for Default Dimension as well?? Big question ??

After debugging multiple time i got to know the reason that system not able to generate default dimension rec id then   I found DIXF framework is taking in alphabatical order of Source Data format Dimension code which is different from account structure. 🙂

Dixf4.png

 

So I changed the DefaultDimension value with Business Unit-Department(003-024) instead of Department-Business Unit(024-003).

Dixf5.pngDixf5.png

Now system won’t give you any error this time and opening balance is imported successfully. 🙂

Dixf6.png

Happy Daxing. 🙂

Advertisements
 

MB6-890 Devlopment Introduction and MB6-893 Microsoft Dynamics AX Financials Dynamics AX7 Exam

I was participated reviwewing the tehnical exam and designing of finance domain exam for the next version of Dynamics AX “7” Code name Rainer. I am felling honored  to be asked to participate on reviewing the technical and desiging functional exam.Like other previous version exams ,its also starting with code MB6 and Microsoft named it MB6-890 Dynamics AX7 and MB6-893 Microsoft Dynamics AX Financials Exam. I have been nominated by my boss.

In future, we will start working on the next version, and in fact spending time to explore about more about Dynamics AX “7” Code name Rainer.

I can’t disclose details of exam, but surely  I will come up  with new article after exploration of Dynamics AX “7” technical and functional side both.

Happy Daxing  🙂

 

Role Center Cues in Dynamics AX 2012

Unfortunately, Dynamics AX 2012 or Enterprise Portal does not web part for cues although that doesn’t mean that you cannot create cues from their data,because the Advanced Filter editor also has the ability to publish filtered data as cues.

So first of all we will understand Advanced Filter editor feature available in Dynamics AX.

Advanced Filter editor

Let me give you a good example to understand this, Your Purchase Manager role centre user profile frequently navigate to the All Purchase orders list page and then filter the list by name so that only ‘Contoso Europe’ Purchase orders are listed.

He would like a quicker and easier way to access the above filter list of purchase orders whenever he wants to see and he don’t prefer to have to filter the list of each time.Dynamics AX provided easiest way to achieve this through filters.

In simple words,You can use filtering to find and work with a subset of the data in a form. When you apply a filter on a form, you see only the records that meet the criteria that you had specified.There are multiple ways to filter records see  How to Filter records [AX 2012]

There are two ways to use the filters as per above example

1.Save the filters records and use as Favorites.

2.Save the filters list as cues

Manages cues through the Advanced Filter editor

A cue is a type of part that represents a query in Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2, Microsoft Dynamics AX 2012 Feature Pack, Microsoft Dynamics AX 2012. A cue to show a count of data records that the query retrieves. Cues can be placed in cue groups in the Fact Box pane and on a Dynamics AX/Enterprise role center page. When you double-click a cue on your Role Center page in the Microsoft Dynamics AX client, the associated page opens and the filtered view is displayed records accessed by the cues. Cues helps you increase efficiency and productivity see How to: Create a Cue Through AOT  [AX 2012]

Your role center is defined by your User profile. Systems administration > Common > Users > User profiles.

user profiles

 

Dynamics AX comes with a wide range of standard Role centers. They’re customizable, but I don’t want to get into technical details – so I’m going to assign myself a nice simple Role center, the Chief Executive officer without thinking of use of user profile. Click on the ‘View role center’ button above and you’ll see:

Role center.png

The cues are those icons that look like good old fashioned in-trays.they’re links to Dynamics AX forms with a filter applied. If you open your role center in the Dynamics AX client you’ll be taken to the form. If you open your role center in the Enterprise portal, you’ll only be able to click on the cue if there is an Enterprise portal version of the form.

But the really neat feature is that you can create your own cues. You need to be on a form that has direct access from a menu, and you need to be able to write a filter query. Let’s open the sales order form and setup a simple query. Sales and marketing > Common > Sales orders > All sales orders:

Filtered Sales Invoice Orders.png

The filter drop-list menu gives you the option of saving this filter as a cue:

Save as cue.png

Click on that option and you’ll see:

Invoiced Sales Orderd.png

Give it a name, and set the other options. Incidentally, if you want to change these options later, go to Organisation > Setup > Role center > Edit cues.

Now back to your Role center:

Invoiced Sales Orders.png

you’re done.Happy Daxing. 🙂

Reference :Cues in AX 2012

 

Enterprise Portal and Role Center is Not Working on Dynamics AX 2012 Hyper-V Image

If you ever started working on the image downloaded from the Microsoft Partner Source of Microsoft Dynamics AX 2012, you might face a trouble while trying to explore Role Centers or Enterprise Portals.

EP Error 1_1EP Error 1_2.PNG

The AX Enterprise Portal is set to http://sharepoint/ep in Microsoft Dynamics AX VPC and combined with 192.168.0.1 IP.

The EP site cannot be accessed after changing the initial IP to other internal IPs.

This error is due to the configuration setup in the AX2012 image that let’s DNS points to contoso.com domain. What has to be done is to redirect that domain to the current machine (which is the same virtual machine you’re using).

To do so you must add a loop back IP to your” Hosts” file. You can think of that files a Roloded for your computer. Its where a computer looks first to translate the URL of a website into a numerical IP address that it can actually use. You can find the “Hosts” file in: “C:\Windows\System32\drivers\etc\Hosts”.

To fix the issue, open the Hosts file a notepad and add this line to the end of the file:

127.0.0.1       intranet.contoso.com

In the beginning, you might encounter the below error…

EP Error2.PNG

but it will be fixed with “refresh”:

Ep Success.PNG

 

Restart your AX environment,Now you will be able to see your role center.

Ep Success_2.png

 

Happy Daxing. 🙂

 

 

Import Chart of accounts in AX 2012 R3 – Step by Step using Data Import Framework

Masood's - Dynamics AX Space

To track and maintain financial information in an organization, we can set up a chart of accounts, which is a collection of accounts that define a financial framework. A chart of accounts can be shared and used by any legal entity in an organization. However, main accounts must be unique to a legal entity. We can select the chart of accounts that can be used by a legal entity in the Ledger form.

Several factors must be consider in creating the structure of chart of accounts for organization, including the following:

  • The reporting requirements of the country/region where the organization is based
  • The reporting requirements of the legal entity
  • The degree of specification needed, for both external organizations and our organization

Chart of Account is very easy to import using DIXF in AX. I will show you how to do it step by step.

First go to General ledger>Setup>Chart of…

View original post 324 more words

 
Leave a comment

Posted by on April 2, 2016 in Uncategorized