Opening Balance import through DIEF (Data Import Export Framework

Hi Guys and Happy Independence day to all my country mates and Happy Birth day to PAKISTAN

9

Okie, This exercise is about importing Opening Balance through DIEF (Data Import Export Framework, I am using Dynamics AX R3 CU8.

1 Create “Processing Group” – “Opening Balance”

7

2 Click Entities and select Entity as “Opening Balance”
3 Select Source data format as “Excel”
We need to create source data format record as this6

4 Click Generate Source file for generating the template, We can select all the needed fields here.

8

5 Click Modify Source Mapping,
Ops here I got the error

Error Message: Assembly containing type Microsoft.Dynamics.AX.Framework.Tools.DMF.ServiceProxy.DmfEntityProxy is not referenced.

Object ‘CLRObject’ could not be created

There can be multiple reason for this issue but I solved it through these steps.

Solution: Above mention error come because you are trying to set parameter without installing its component (Service, Server and Client). Just install those component from setup file and restart the AOS service. Now this error should not bother you this time. 🙂

After restarting the AX, I have open the parameter form, specified the correct shared working directory and validate the settings.

5

OK, NOW BACK TO MAIN TOPIC.

5 Click again on “Modify Source Mapping,”

As we need Journal Number to be Auto generated, I modify it by marking JournalNumber auto generated, and I also added the JournalName field in Query Criteria such that all the lines (with the same JournalName value) will be assigned the same JournalNumber

4

After this select the excel file with data in the ENTITIES form and click preview to viewing the data.

3

In the last for moving the data to staging table, click “Get staging data” then for copying the data to target, click on Copy data to target.

2

and here we have the end result

1

BIG THANK YOU AND HAPPY DAXING 🙂

Advertisements

One Response to Opening Balance import through DIEF (Data Import Export Framework

  1. mansoor ali says:

    What about the Dimension for Ledger Account 110110- -. To bring the dimension through Data Import is a big Challenge.. Have you tried it..

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: