Question Status

Verified
jj_luca asked a question on 27 Feb 2015 1:54 PM

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>


Reply
Nickster responded on 28 Feb 2015 1:38 PM

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.

Reply
jj_luca responded on 6 Mar 2015 8:34 AM

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.

Reply
Verified Answer
jj_luca responded on 6 Mar 2015 8:45 AM

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*

Reply
jj_luca responded on 6 Mar 2015 11:09 AM

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.

Reply
jhofman responded on 31 Mar 2015 10:34 PM

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

Reply
Verified Answer
jj_luca responded on 6 Mar 2015 8:45 AM

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*

Reply