AP EDI Invoices

(0) Share

Report

Posted on by Community Member

Has anyone loaded EDI Vendor invoices into AX and if you have, are you using the AIF Service, "PurchaseInvoiceService"?

I would like to understand your approach for loading miscellaneous charges and sales tax adjustments as per the vendors invoice if you are using this service? The service loads the invoices into the AP Invoice Register, however, there is not a place in the Invoice Register to put miscellaneous charges, the sales tax adjustments cannot be entered via the service either; there is a sales tax adjustment field in the invoice register, however the table associated to it is a temp table.

If you're not using this service, can you please explain the approach that you have taken to load EDI vendor invoices into AX?

*This post is locked for comments

I have the same question (0)

All responses (4)

Answers (0)

Adam Hartong 25 on at

Like (0)

Report

Unless you are doing some custom x++ or using the business connector to call into classes, you'll probably have a hard time doing what you need via AIF, unless you do it in multiple steps.
With your approach, I'm guessing you could do a purchase order update via AIF to add the charges(assuming AX 2009). AX 2009 allows updates via AIF. So, once the order is updated, you can then create the invoice, and that charge should get pulled to the invoice and removed from the order(depending on options).
We'll be doing sort of a hybrid of what I mentioned in my first paragraph by using the architecture that we have built for our EDI solution for AX. Let me know how this works out for you.

Adam
http://www.vsync.com/

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Adam,
With your solution, where are you loading the invoice (where is the entry point)? Which table? We are looking for a confirmation on the best approach to load the invoice into AX, 1- is it using the standard AIF service (LedgerPurchaseInvoiceService). This create an entry on the Invoice Register.2- Or, Use a different entry point – do you have any suggestions?

Was this reply helpful? Yes No
Adam Hartong 25 on at

Like (0)

Report

Well, we are in the same boat as you, we are still in planning stages, but I was looking at going into the VendInvoiceJour/Trans tables. Seems like a much cleaner entry point based on the data you would be receiving from an EDI standpoint. You could then do some custom logic to populate your xml with external data or purchase order fields that get used on the invoice.
As a side note, you'll have to consider issues with registering serial/lot items if you have them, and possibly the over/under delivery of goods too.
How does your process work for the creation of orders to send out to vendors? And, what types of issue are you dealing with for the invoice side of things?

Was this reply helpful? Yes No
tfell 7 on at

Like (0)

Report

We are trying to do something similar with AX 2012. Since this is an old post does anybody have updated information?

Was this reply helpful? Yes No

Community site session details

AP EDI Invoices

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

Featured topics

Product updates

Community site session details

AP EDI Invoices

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

Featured topics

Product updates