EDI integration

(0) Share

Report

Posted on by Rosey

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

I have the same question (0)

All responses (8)

Answers (0)

Guy Terry 28,944 Moderator on at

Like (0)

Report
Copy link

Link copied!

How are you getting the orders into AX?

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

Was this reply helpful? Yes No
Rosey on at

Like (0)

Report
Copy link

Link copied!

Hi guy,

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

Thanks.

Was this reply helpful? Yes No
Suggested answer

Guy Terry 28,944 Moderator on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
rajeev tiwari 440 on at

Like (0)

Report
Copy link

Link copied!

hi nitesh ,

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

Please Please send me at tiwarirajeev27@gmail.com

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Nitesh / Raj,

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

Thanks in advance.

Was this reply helpful? Yes No
Ilse Cronje on at

Like (0)

Report
Copy link

Link copied!

Hi Nitesh

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

Was this reply helpful? Yes No
Ilse Cronje on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No