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 / Finance | Project Operations, Human Resources, ... / Best option to read CS...
Finance | Project Operations, Human Resources, ...
Answered

Best option to read CSV to Ax for creating journal entries.

(0) ShareShare
ReportReport
Posted on by Mav

Hi Experts.

I have requirement of reading CSV file & creating journal entry. I could thought of below options. could you please suggest which option would work best.

Option 1 

DIXIF - Positive

             MS suggested approach, Out of box, Min coding hence min customization , Security is  managed by using out of box control,i.e. processing groups.

             Negative

             User interface which end users who are prone to just dropping a file in a folder may not like.

Option 2 

AIF -  Positive

          MS suggested approach ,Out of box ,Simple UI all user need to do is drop a file in the folder, Security is managed by out of box control available in AIF inbound port form.

          Negative

          Medium level customization required.

Option 3

CustomX++solution for reading CSV into Ax

                    Positive - 

                     As it is design & coded end to end by you , you have full control .

                    Negative 

                    Fully customized solution. UI is not as simple as AIF also not complex like DIXIF, user would need to click , browser & upload the CSV file. 

                    You have to define your security & will be unable to use out of box security control unlike DIXIF & AIF.

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Best option to read CSV to Ax for creating journal entries.

    Hello Mav,

    Here is another option 4

    ax2012exceldataimport.blogspot.com/.../dynamics-ax-2012-ledger.html

    Best regards,

    Ludwig

  • Mav Profile Picture
    Mav on at
    RE: Best option to read CSV to Ax for creating journal entries.

    Thanks for your response.  Yes this one is for Ax2012.

    Much thanks for that Dixif link , one quick question though I am unable to enter processing directory & completed directory in i staging data execution form like mentioned in the article.


    What would you suggest to be used in my scenario where end users are going to repeatedly import CSV into Ax to create journal entries.

    Thanks to this Microsoft article using which i was able to build ,deploy & use the transformation

    I am afraid  my partners would not be comfortable in using AIF as they have sighted AIF performance & debugging issue always & tend to be comfortable  with Dixif & Custom X++  in Ax2012 & Odata in D365.

  • Verified answer
    Martin Dráb Profile Picture
    Martin Dráb 232,038 Most Valuable Professional on at
    RE: Best option to read CSV to Ax for creating journal entries.

    This is about AX 2012, right?

    If you want just to drop a file to a folder and get it processed, both DIXF and custom development can do that (for DIXF check this).

    A big disadvantage of a custom solution is that there is a lot of infrastructure you must build if it's more than an one-off job: exception handling, logging, data validation, security, table relations and so on. If you want a fully universal solution (dealing with surrogate keys, date-effective data, table inheritances and so on), it's likely not worth the effort. It may be meaningful when the scope is quite narrow.

    AIF is based on XML, not CSV. You would need a transformation from CSV to XML. You also must respect the structure defined by AIF documents.

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

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 293,280 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 232,038 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156 Moderator

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans