Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics AX (Archived)

is there any dixf entity to load Recurring journals or Periodic journals in AX 2012 r2?

Posted on by 415

Hi 

Is there any DIXF entity for loading Recurring Journals or Periodic Journals in AX 2012 R2? 

If not, any suggestions on ways to do it? Thanks.  

*This post is locked for comments

  • DynamicsAXExplorer Profile Picture
    DynamicsAXExplorer 415 on at
    RE: is there any dixf entity to load Recurring journals or Periodic journals in AX 2012 r2?

    Hi 

    We dont have excel addin and we are used to DIXF. So for us its easy this way. 

    We are not doing any double work. This is something we do only when we are moving data from ax 2009 to ax 2012 or another system to ax 2012. 

    If we have four recurring journals and each recurring journal had 400 lines. Then we just simply create those 4 journal headers. and use those journal numbers in template and load all 1600 lines using Opening balance DIXF entity. Its simple and easy as we are used to using DIXF.

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: is there any dixf entity to load Recurring journals or Periodic journals in AX 2012 r2?

    Hi DynamicsAXExplorer,

    Do you really want to do that?

    To me this looks like double work because you upload the periodic journal lines first and then go into a GL journal to retrieve the lines from the periodic journal.

    If you use the excel addin then you make a single upload only and can directly post the journal.

    Maybe talk with your accounting colleagues what they prefer.

    Best regards,

    Ludwig

  • DynamicsAXExplorer Profile Picture
    DynamicsAXExplorer 415 on at
    RE: is there any dixf entity to load Recurring journals or Periodic journals in AX 2012 r2?

    There is a standard DIXF entity which i mentioned in my above answer which can be used to load Periodic Journal Lines.  We just need to created Journal headers and load all lines using Standard entity "Opening Balance".  You can verify my above answer.

  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: is there any dixf entity to load Recurring journals or Periodic journals in AX 2012 r2?

    Hello DynamicsAXExplorer,

    There is no DIXF entity for loading recurring / periodic journals.

    I would not customize that but rather use the Excel addin to upload your transactions on a regular basis.

    The Excel add in can be used without customization and does not require modifying existing entities.

    Best regards,

    Ludwig

  • Suggested answer
    DynamicsAXExplorer Profile Picture
    DynamicsAXExplorer 415 on at
    RE: is there any dixf entity to load Recurring journals or Periodic journals in AX 2012 r2?

    We added the Journal Header manually and for loading lines we used "Opening Balance" standard DIXF Entity.(Table: DMFLedgerJournalEntity, Class: DMFLedgerBalanceEntityClass, TargetEntity: DMFLedgerJournalTransEntity).

  • Sukrut Parab Profile Picture
    Sukrut Parab 71,647 Moderator on at
    RE: is there any dixf entity to load Recurring journals or Periodic journals in AX 2012 r2?

    If there is no entity available , you can create one

    docs.microsoft.com/.../create-a-custom-target-entity-for-the-data-import-export-framework-dixf-dmf

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans