Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics AX (Archived)

EDI integration

(0) ShareShare
ReportReport
Posted on by

Hi everyone!

Has anyone dealt with how to handle EDI orders coming in that may have errors - so that they are not able to come into AX?  For example the part number is wrong...and it cannot come into AX as a sales order?  How are people catching these so that we know to notify the customer?

Thanks!

*This post is locked for comments

  • Ilse Cronje Profile Picture
    Ilse Cronje on at
    RE: EDI integration

    Hi Raj any useful info on your request, as I need to do the same?

  • Ilse Cronje Profile Picture
    Ilse Cronje on at
    RE: EDI integration

    Hi Nitesh

    I also need the details as requested by Raj below, any chance that you could also forward me the details?

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: EDI integration

    Nitesh / Raj,

    Would you be able to share any learnings on EDI implementation on AX 2012R2?

    Thanks in advance.

  • rajeev tiwari Profile Picture
    rajeev tiwari 410 on at
    RE: EDI integration

    hi nitesh ,

    do you have documents for using EDI in sending po to vendors using AIF.

    Please Please send me at tiwarirajeev27@gmail.com

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: EDI integration

    I have developed some of these kind of EDIs

    I have done following

    -Create a temporary table same as source file structure

    - Read the file and insert the data in temporary table

    - Write validation method, here in this method you can provide details which all records are having warning message and which are having error message

    if you find error message you can stop the further processing

    - if there is no error, you can write/call a method to insert the data in Sales order related tables

    Please review and let me now if you need any support to develop the EDI

  • Suggested answer
    Guy Terry Profile Picture
    Guy Terry 28,626 Super User 2024 Season 2 on at
    RE: EDI integration

    OK, but do you know how you will import them into AX?

    If you buy a tool to do it, it will have its own way of handling errors.

    Where I have seen customisations for this in the past, the solution typically uses a periodic job (which can be set to run in batch) to import files. Each file contains one sales order. The periodic job monitors a folder, importing files as they arrive in the folder. On a successful import, the job moves the file to a 'imported' folder. In the case of an error, the whole order fails to import, and the job moves the file to an error folder.

    In addition, the job writes success or fail messages to an infolog which can be viewed in the batch job history.

    This way, users simply need to look into the error folder for the exceptions. Because the files are moved, the job does not continually attempt to re-import them.

  • Rosey Profile Picture
    Rosey on at
    RE: EDI integration

    Hi guy,

    This is a customization that we have made to our legacy system.  

    Thanks.  

  • Guy Terry Profile Picture
    Guy Terry 28,626 Super User 2024 Season 2 on at
    RE: EDI integration

    How are you getting the orders into AX?

    AIF, a 3rd party EDI add-on, or some customisation or custom import?

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 Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,503 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans