web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Cannot Populate the De...
Microsoft Dynamics AX (Archived)

Cannot Populate the Default (financial) dimensions in GL journal using DIEF

(0) ShareShare
ReportReport
Posted on by PasanM 175

Hi,

I am trying to load the General journal using DIEF. i was able to populate the journal and journal line but it does not populate the default dimensions (financial dims) of the customer account.

I used the 'DefaultDimension' field in my template and the dimension values were separated using the hyphen (-).

Really appreciate if someone can help sort out this issue.

Thanks

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Community Member Profile Picture
    Community Member on at

    you need a to write a data transformation function so that you can convert the Default Dimension (Hyphen separated) value to int64 value.

    Please review one of the standard implementation related to this...

    Check class called DNFInventJournalEntityClass\GenerateDefaultDimension()

    One more thing you need to consider related to this.

    Please check the Source data formats setup...

    under Application tab we define what is the sequence of dimension value and what is the separator..

    Please verify if your setup is good enough as per you data in template.

    Please review and update with your findings...

  • dolee Profile Picture
    dolee 11,279 on at

    Hi,

    Is it the AX2012 R2 CU7 version of DMF/DIXF you using?

    Can you post the code found in \Classes\DMFLedgerBalanceEntityClass\GenerateDefaultDimension here?

    Regards,

    Dominic

  • Verified answer
    aahmednafea Profile Picture
    aahmednafea 135 on at

    Hi There,

    I am using AX 2012 R2 CU7 and was able to load a General Journal with default dimensions for the customer.

    The solution is:

    1. Navigate to Data Import Export Framework>> Setup>> Source Data Formats>> Application

        a. Choose the Dimension Code

        b. Ensure that the Dimension Format matches the structure of the Account Structure in the GL

    2. I have entered the following journal

    8666.Capture2.PNG

    JournalNum: automatically inserted

    Line Number: auto inserted

    JournalName: GenJrn

    CurrencyCode: AUD

    Voucher:0000001 (depending on your number sequence setup)

    Company: BP

    AccountType: Customer

    LedgerDimension: Customer Account Code

    DefaultDimension: this is where you place your financial dimensions separated by (-) or based on configuration of DIEF source data type

    AmmountCurDebit:0

    AmmountCurCredit: 120

    OffsetCompany:BP

    OffsetAccountType:Bank

    OffsetLedgerDimension:ANZ-AUS

    1425.Capture22.PNG

     

    Tip: 1. When migrating journals for Vendors or Customers in the Account Type, you need to use the DefaultDimension field for populating financial dimensions.

           2. When migrating journals with account type and offset account type is Ledger, then use the LedgerDimension field for the main account and default dimensions separated by (-) such as below

     

     

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 301,037 Super User 2025 Season 2 on at

    Nice answer from Aahmednafea! Try this first. In the first beta of DIXF I had troubles with the dimensions as well. Then I had to enable the 'Run business....' tickboxes on the processing group and Entity structure (Can be opened from the Target entity form). You have to enable the both then.

  • PasanM Profile Picture
    PasanM 175 on at

    Hi All,

    Thanks a lot for all of your replies!!

    I was testing this in CU6 enviroment and i had all the source data format configurations correctly set up.

    Today I got the chance to get my hands on CU7 environment and i loaded the exact same file with the same set ups and it worked.

    So i guess this is an issue in CU6 and as some of you mentioned above we might need a small customization to fix it.

  • dolee Profile Picture
    dolee 11,279 on at

    Hi,

    IF it's CU6, there's a bug I remember in

    \Classes\DMFLedgerBalanceEntityClass\GenerateDefaultDimension, and

    \Classes\DMFLedgerBalanceEntityClass\GenerateOffsetDefaultDimension

    methods.

    they calls res = conNull(); all the time which is why the value aren't getting in.

    Regards,

    Dominic

  • Community Member Profile Picture
    Community Member on at

    I'm on CU8 and followed these instructions - it allowed me to pass the value in the DefaultDimension field - but when I went into the journal to look, none of the values were actually set.  Are others having this issue in CU8?

  • Community Member Profile Picture
    Community Member on at

    Hi Pasan,

    how step by step to update CU6 to CU7?

    I have a trouble with it,

    can you help me ?

    thanks

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#1
Priya_K Profile Picture

Priya_K 4

#3
MyDynamicsNAV Profile Picture

MyDynamicsNAV 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans