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

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) / GL Opening Balance Jou...
Microsoft Dynamics AX (Archived)

GL Opening Balance Journal Import using Data Migration Framework

(0) ShareShare
ReportReport
Posted on by Manikkam Ramasamy 140

I would be glad to know if anyone had any success in importing GL journals using DMF's opening balance entity. I am trying it in Ax2012 R2. I have tried quite a few options however without much success. Even though the staging data is validated successfully, DMF keeps popping up with the following :

Results. Record ('000420_10-32134-2.00') -. Unable to return DimensionAttributeValue record

Any help would be appreciated.

Thanks

Manikkam

*This post is locked for comments

I have the same question (0)
  • dolee Profile Picture
    dolee 11,279 on at

    Hi,

    I have worked on that recently and after working around a few issues it looks alright. Have you check if the desired DimensionAttributeValue record is available in DB?

  • Manikkam Ramasamy Profile Picture
    Manikkam Ramasamy 140 on at

    Dolee,

    Thanks for Ur quick reply.,

    I checked in DimensionAttributeValue but there is no record available for newly imported Payment Journal..kindly suggest me if u have any solution.

    Thanks,

    Manikkam

  • dolee Profile Picture
    dolee 11,279 on at

    Hi,

    Do you mean the you want to import dimension values and create on the fly if it's not found?

    I would suggest against doing that because any mis-typed dimension value will be added to the system, and if the user posts it right the way it'll probably be very troublesome to fix. It's better to have users populate the needed values into the dimensions first. Then during import typos can be caught.

    Having said that, you can check the GenerateLedgerDimension and GenerateDefaultDimension methods in DMFLedgerBalanceEntityClass. They are called by system to transform the dimension value string (XX-YY-ZZ) to the correct refRecId for LedgerDimension and DefaultDimension fields respectively. For example, you can add preEventHandlers to these two methods to create the missing dimension values.

  • Manikkam Ramasamy Profile Picture
    Manikkam Ramasamy 140 on at

    Actually u got exactly what we need, here i have seen that two method which u suggested, but i dono how to check whether  refRecId correct or not . kindly could u share ur code..so that it helps me a lot..

    Thanks,

    Manikkam.

  • dolee Profile Picture
    dolee 11,279 on at

    Hi Manikkam,

    Check the DMFDimensionHelper::generateDefaultDimension method to see how system get the list of dimension attribute and dimension value from your input. Then use the

    dimensionAttributeValue::findByDimensionAttributeAndValue method to check for existing record (set the 4th parameter to true will create a record if not found.)

    For DefaultDimension, check the DMFDimensionHelper::generateDefaultDimension method instead. It populate the Dimension Attribute list by looking at the paramter setup of DMF source data format settings.

    Then do the same as above.

  • Manikkam Ramasamy Profile Picture
    Manikkam Ramasamy 140 on at

    Hi Dolee,

    Thanks for Ur suggestion

    Now i cleared that error and imported successfully in Staging table(DMFLegerJournalEntity)  but the DefaultDimension field value  showing  '0' in Target table( LedgerJournalTrans ). kindly suggest me what i done wrong..

    Thanks and Regards,

    Mannikkam.

  • Verified answer
    dolee Profile Picture
    dolee 11,279 on at

    Have you put a breakpoint in the DMFDimensionHelper::generateDefaultDimension method?

    What was it returning?

  • Manikkam Ramasamy Profile Picture
    Manikkam Ramasamy 140 on at

    Hi Dolee,

    Finally i got exact output.

    Thanks

    Manikkam.

  • Manikkam Ramasamy Profile Picture
    Manikkam Ramasamy 140 on at

    Hi Dolee,

    Validate voucher by voucher and skip the whole voucher if error exists when importing opening balance using data import / export.

    Thanks and Regards,

    Manikkam

  • Suggested answer
    Community Member Profile Picture
    Community Member on at

    Hi Mani,

    You need to check field data for DefaultDimension and LedgerDimension. Either one of this is wrong or incorrect pertain to that record. And of course any error during import, the import process stops and exit.

    I also had the similar error. One of the line field DefaultDimension was having invalid to that record/row.

    Naushad. C. K

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the April Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
CP04-islander Profile Picture

CP04-islander 39

#2
Michel ROY Profile Picture

Michel ROY 14

#3
imran ul haq Profile Picture

imran ul haq 8

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans