Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / eConnect - taPOPDistri...
Microsoft Dynamics GP (Archived)

eConnect - taPOPDistribution is Ignored

(0) ShareShare
ReportReport
Posted on by Community Member Microsoft Employee

I am using Visual Studio 2012 and eConnect to integrate purchase order invoices into GP.  I am passing matched shipments in the taPopEnterMatchInvLine node along with a taPopDistribution node for freight.  The XML schema result is pasted below.  The document is created in GP and no errors are returned.  However, the freight distribution seems to be ignored.  The freight amount is entered at the header level, but the GL code is not inserted at the Distribution level and must be manually entered in GP after the fact.  Any ideas why?  I really need to be able to pass both the matched shipments (and sometimes even using taPopEnterMatchInvToShpMultiLine) along with a distribution line for freight.

<?xml version="1.0" encoding="UTF-8"?>

-<eConnect xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">


-<POPEnterMatchInvoiceType>

<eConnectProcessInfo xsi:nil="true"/>

<taRequesterTrxDisabler_Items xsi:nil="true"/>

<taUpdateCreateItemRcd xsi:nil="true"/>

<taUpdateCreateVendorRcd xsi:nil="true"/>

<taCreateVendorAddress_Items xsi:nil="true"/>

<taPopRcptLineTaxInsert_Items xsi:nil="true"/>


-<taPopDistribution_Items>


-<taPopDistribution>

<POPTYPE>2</POPTYPE>

<POPRCTNM>10000082</POPRCTNM>

<ACTNUMST>000-0000-0000-59910</ACTNUMST>

<DEBITAMT>16.620000</DEBITAMT>

<DISTTYPE>3</DISTTYPE>

<VENDORID>SAG00001</VENDORID>

</taPopDistribution>

</taPopDistribution_Items>

<taAnalyticsDistribution_Items xsi:nil="true"/>


-<taPopEnterMatchInvLine_Items>


-<taPopEnterMatchInvLine>

<POPRCTNM>10000082</POPRCTNM>

<PONUMBER>PO0302059</PONUMBER>

<QTYINVCD>1000</QTYINVCD>

<ITEMNMBR>391-10004</ITEMNMBR>

<VENDORID>SAG00001</VENDORID>

<UNITCOST>0</UNITCOST>

<EXTDCOST>0</EXTDCOST>

<AUTOCOST>1</AUTOCOST>

</taPopEnterMatchInvLine>

</taPopEnterMatchInvLine_Items>

<taPopEnterMatchInvToShpMultiLine_Items xsi:nil="true"/>


-<taPopEnterMatchInvHdr>

<POPRCTNM>10000082</POPRCTNM>

<VNDDOCNM>0006773106</VNDDOCNM>

<receiptdate>12/31/2014</receiptdate>

<BACHNUMB>COR360-2015225</BACHNUMB>

<VENDORID>SAG00001</VENDORID>

<SUBTOTAL>0</SUBTOTAL>

<FRTAMNT>16.62000</FRTAMNT>

<AUTOCOST>1</AUTOCOST>

</taPopEnterMatchInvHdr>

<taMdaUpdate_Items xsi:nil="true"/>

</POPEnterMatchInvoiceType>

</eConnect>


*This post is locked for comments

  • jhofman Profile Picture
    jhofman 5 on at
    RE: eConnect - taPOPDistribution is Ignored

    Hi JJ,

    I'm running into a similar issue and I'm interested in how you were able to solve it!  When you said you manually submitted all the distribution information, which distributions did you supply?  Certainly all 20 disttypes aren't required, are they?  I just went back and made sure to set autocost and createdist to zero.

    Right now, I'm just supplying distributions to the accounts that apply.  In my case, that's distributions to an Accrued Purchases, Accounts Payable,  Freight (if applicable), Miscellaneous (if applicable), and Other (if applicable).  Was there anything else special?

    Thanks!

    Jeremy

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: eConnect - taPOPDistribution is Ignored

    By the way - after adding way more code and queries into my solution than I wanted - I was able to successfully integrate this transaction by setting CREATDIST = 0 and manually submitting all the distribution information.

  • Verified answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: eConnect - taPOPDistribution is Ignored

    The issue is the CreateDist flag on the taPopEnterMatchInvHdr node.  If I set that to 1=Automatic then my PO lines automatically create the distributions required, but then the freight GL I pass is ignored.  If I set to 0=Manual then the freight line goes through, but I'm left without PO distributions.  I guess I'll have to work on manually passing the PO distributions as well.  *sigh*

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: eConnect - taPOPDistribution is Ignored

    Thanks for the suggestion, but no go.  I turned off AutoCost on the header and the line.  Then I passed amounts for UnitCost, ExtdCost, and SubTotal, but got the same exact result.  Everything went through except the freight GL account.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: eConnect - taPOPDistribution is Ignored

    Hi JJ,

    You are using autocost option on the header which is causing econnect to ignore the distribution lines you are sending.  It simply fills the distribution using vendor and system defaults and vendor probably does not have default freight account. In order to send distribution lines for po invoice I think you have to set AutoCost false but that requires all distribution lines to be send manually freight plus all the po related ones which means you loose any automatic coding that comes from po lines.

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