AX - EDI Integration

Get our Free Newletter

Don't you have the time to be online here at DUG every day? So how do you follow what is going on in the Dynamics industry and community?
If you subscribe to the DUG Newsletter then you can relax! We will make sure that you don't miss the big news!

Check out our
Newsletter Subscription Center
page a complete list of our different newsletters.

Not Answered This post has 0 verified solutions | 6 Replies | 2 Followers

Male
1,051 Posts
18,080 Points
Joined: 2011-9-5
Last Online:
2013-5-24 18:23
Location: India
Pranav Kumar posted on 2012-9-4 15:37

Hi Friends,

Has anybody done AX-EDI integration.

I am having issues with PO invoicing using EDI.

Please share your views.

Thanks,

Pranav...

-- 

Expect the best, plan for the worst and prepare to be surprised

http://pranavkumaar.wordpress.com/

All Replies

Male
2,084 Posts
33,927 Points
Joined: 2003-1-21
Last Online:
2013-5-24 19:22
Location: Herts, England
DynamicsAXMVP
Moderator

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?

Harish Mohanbabu
Long way to go before I sleep ..

View Harish Mohanbabu's profile on LinkedIn

Male
1,051 Posts
18,080 Points
Joined: 2011-9-5
Last Online:
2013-5-24 18:23
Location: India
Pranav Kumar replied on 2012-9-4 16:33

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

-- 

Expect the best, plan for the worst and prepare to be surprised

http://pranavkumaar.wordpress.com/

Male
2,084 Posts
33,927 Points
Joined: 2003-1-21
Last Online:
2013-5-24 19:22
Location: Herts, England
DynamicsAXMVP
Moderator

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.

 

Harish Mohanbabu
Long way to go before I sleep ..

View Harish Mohanbabu's profile on LinkedIn

Male
1,051 Posts
18,080 Points
Joined: 2011-9-5
Last Online:
2013-5-24 18:23
Location: India
Pranav Kumar replied on 2012-9-7 19:49

Hi Harish,

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

Thanks,

Pranav

 

-- 

Expect the best, plan for the worst and prepare to be surprised

http://pranavkumaar.wordpress.com/

Male
2,084 Posts
33,927 Points
Joined: 2003-1-21
Last Online:
2013-5-24 19:22
Location: Herts, England
DynamicsAXMVP
Moderator
Harish Mohanbabu replied on 2012-9-10 11:22

Hi Pranav,

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

Harish Mohanbabu
Long way to go before I sleep ..

View Harish Mohanbabu's profile on LinkedIn

Male
1,051 Posts
18,080 Points
Joined: 2011-9-5
Last Online:
2013-5-24 18:23
Location: India
Pranav Kumar replied on 2012-9-10 11:56

Hi Harish,

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

Thanks,

Pranav

-- 

Expect the best, plan for the worst and prepare to be surprised

http://pranavkumaar.wordpress.com/

Page 1 of 1 (7 items) | Get this RSS feed | Bookmark and Share