Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Load Purchasing Invoic...
Microsoft Dynamics GP (Archived)

Load Purchasing Invoice via Integration Manager

(0) ShareShare
ReportReport
Posted on by ScottAnderson 40

We have been creating Purchase Orders with Integration Manager and also using the Receivings Transaction Entry destination to load a Shipment.  We have then been manually matching up the vendor's invoice once we have received the paper invoice.

I would like to load it in via Integration Manager if possible.  I thought I would need to use the Receivings Transaction Entry and set the Type to "Invoice".  However, I see that the only options are "1 - Shipment" and "3 - Shipment/Invoice".

I was hoping to see "2 - Invoice".  Can I manually put in a 2, or do I need to do something else?  Thanks.

*This post is locked for comments

  • ScottAnderson Profile Picture
    ScottAnderson 40 on at
    Re: Re: Load Purchasing Invoice via Integration Manager

    We are building systems and processes to verify that the amount matches within a tolerance and to handle the delta if there is one. Other invoices that aren't within  the tolerance will be routed to an exception report, and will then be handled manually. 

    We have vendor invoices coming in via EDI into a different system.  We should be able to automate the process if I can figure out how to get the Invoice loaded into GP.

    How are other people handling this when they use POs and then receive invoices via EDI?

  • Richard Whaley Profile Picture
    Richard Whaley 25,195 on at
    Re: Load Purchasing Invoice via Integration Manager

    The problem with what you want to do is this.  The process of matching the invoice to the receipt is supposed to be a visual validation that the vendor billed correct or the receiving clerk received correctly and all the numbers match, including expected cost vs invoiced cost, etc.  Importing skips all this.

  • sandipdjadhav Profile Picture
    sandipdjadhav 18,265 on at
    Re: Load Purchasing Invoice via Integration Manager

    In integration manager I too didn't found Matching Invoice for your Po Receipt option, but eConnect and Dynamics GP WebService has that option here is link for GP WebService : http://msdn.microsoft.com/en-us/library/cc508601.aspx

    eConnect : http://msdn.microsoft.com/en-us/library/bb625181.aspx

    http://msdn.microsoft.com/en-us/library/bb625290.aspx  for Header Schema

    http://msdn.microsoft.com/en-us/library/bb625291.aspx  line items Schema

    http://msdn.microsoft.com/en-us/library/bb625292.aspx  line items Schema

     

    Need to do coding to use eConnect or WebService.

    Happy coding .. !!!


    Thanks

    Sandip

     

     

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

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans