AX - EDI Integration

Finance and Operations/AX Developer Forum
1

Hi Friends,

Has anybody done AX-EDI integration.

I am having issues with PO invoicing using EDI.

Please share your views.

Thanks,

Pranav…

2

Hi Pranav,

I have worked on quite a few integrations in various versions of AX. Usually I tend to use AIF for such purposes.

Can you please explain your requirement?

3

Hi Harish,

Thanks for the reply. Actually in one of our project we have to integrate AX 2012 with vendor system through EDI. The integration has two points:

  1. When PO is confirmed at AX, the PO will be sent to customer’s database through EDI.

  2. When customer invoices SO(at their end), we need to post the invoice in AX accordingly.

The issue is, how do we know that what data has to be invoiced in AX. PO Packing slip will be posted manually, and we have to post the invoice as per data we receive from EDI. I am considering PO invoicing based on packing slip, but not sure what data i will get.

They also use ODBC connection for integration.

So what approach should i follow here?

If you have any experience with EDI integration, please share.

Thanks,

Pranav

4

Hi Pranav,

Since the PO will be sent to the customer first, can the customer send this reference with item number, qty etc back to you? Once this data is received from customer, then the integration can post packing slip as well as invoice the PO.

As far as the integration, my understanding is this is 2 way integration -

  1. You send PO confirmation to customer
  2. Then customer sends sales order invoice detail back to you.

If the customer can accept XML, then pure AIF solution can be deployed. Otherwise if customer can accept CSV, even then AIF solution can be deployed; but on top this would need some transformation i.e. CSV to table.

5

Hi Harish,

Can you tell me which service can be used to invoice PO in AX if i use AIF?

Thanks,

Pranav

6

Hi Pranav,

I believe it is ‘VendVendInvoiceService’. More info here - http://technet.microsoft.com/EN-US/library/hh242384

7

Hi Harish,

Thanks for the reply. I will try it and will update.

Thanks,

Pranav

8

Hi Pranav,

I also want to create EDI file in ax 2009. (EDI-AX Integration)

Please help me…

Thanks

Darshana