Skip to main content

Notifications

Announcements

No record found.

Finance | Project Operations, Human Resources, ...
Answered

Purchasing Distribution incorrect when matching with eConnect

Posted on by Microsoft Employee

I’m using eConnect to do invoice matching.  When there is a Purchase Price Variance, the amount for the Purchasing Distribution is incorrect.  Where should I look for the issue?

 I’m using these eConnect objects:

  1. taPopRcptLineTaxInsert
  2. taPopEnterMatchInvLine
    1. AUTOCOST = 0/Manual
    2. AutoInvoice  = 0/Manual
    3. EXTDCOST = Interface input is different from the PO
    4. UNITCOST  = Interface input is different from the PO (a new Unit Cost is calculated before input)
    5. QTYINVCD  = Interface input is the same as the PO 
  1. taPopEnterMatchInvHdr
    1. AUTOCOST = 0/Manual
    2. CreateDist = 1/Automatic

 

 Note that I am NOT using taPopDistribution.

Categories:
  • Suggested answer
    Terry R Heley Profile Picture
    Terry R Heley Microsoft Employee on at
    Purchasing Distribution incorrect when matching with eConnect
    Wanted to create awareness that we added a new section to our documentation of published eConnect procedures that have changed, and issues customer may run into.  The taPOPCreateDistributions is one of them on the list.
    Please review this area and download the procedure and test your situation further.
     
    Thanks
    Terry Heley 
    Microsoft
  • Suggested answer
    Isaac Olson Profile Picture
    Isaac Olson on at
    RE: Purchasing Distribution incorrect when matching with eConnect

    Hello Sandip,

    I would be my suggestion as a starting point, to open a case with us at Microsoft first as we have workaround stored procedures for this that has worked for most customers.  Since this is considered a quality issue on our end, the case would not be charged to you once we provide the workaround.  If you have too complex of a scenario and need to do your own customization like Connexus above, then at least you would be able to try our workaround without charge first before going that route.  

    Thanks,

    Isaac Olson

    Microsoft Support

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Purchasing Distribution incorrect when matching with eConnect

    Hi Sandip,

     No, I wasn’t able to resolve the issue – I had to do a (big) workaround instead. 

     I used TIBCO Scribe to create an interface to do our three-way match of Invoices, Purchase Orders, and Shipping Receipts.

    The Scribe interface consists of these main steps:

    1. Get the the next Purchase Receipt Number from GP
    2. eConnect taPopEnterMatchInvLine
      1. AutoCost = 0/manual
      2. AutoInvoice = 0/manual
    3. econnect taPopEnterMatchInvHdr
      1. UsingHeaderLevelTaxes = 1/true (even though we have line taxes)
      2. CreateDist = 0/manual
    4. Custom post-processor

     

    I did a lot of experimenting with the values for AutoCost, UsingHeaderLevelTaxes, and CreateDist.  I ended up writing a custom post-process (step 4) to calculate and verify the taxes and the distributions.  It was time-consuming and not pretty, but it works and we’ve been in Production for about a year now (Dynamics GP 2018 R2).

     Not the answer you wanted, I’m sure.  Good luck to you.

  • sandipdjadhav Profile Picture
    sandipdjadhav 18,265 on at
    RE: Purchasing Distribution incorrect when matching with eConnect

    Hello ,

    I am facing the same issue in GP2018 R2 enviornment.  eConnect throwing wrong Purchase Amount for LC invoice Match.

    Are you able to resolve the issue?

    Thanks much

    Sandip 

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Purchasing Distribution incorrect when matching with eConnect

    Hey Isaac,

    Thank you for your reply and for this information!  I don't have access to GP 2016 and so I will open a support case with Microsoft as you suggest.

  • Verified answer
    Isaac Olson Profile Picture
    Isaac Olson on at
    RE: Purchasing Distribution incorrect when matching with eConnect

    Hello,

    There is an issue with the taPOPCreateDistributions Stored Procedure which throws off the the PURCH amount (most of the time we see the total correct PURCH amount multiplied by the number of lines on the transaction).  Because eConnect Stored Procedures are encrypted it is not something that you can just update without a copy of the unencrypted version.   If you have access to the unencrypted version of this stored procedure from a version prior to GP 2016, you could put that into place to resolve the issue.  Otherwise I would recommend opening a support case which we would not charge due to this being a quality issue and we can get you a fix to implement.  

    Thanks,

    Isaac Olson

    Microsoft Support

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,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans