Search the GP Tables
Search by TABLE NAME
Search by FIELD NAME
These are our SOP scripts. All of our scripts for Dynamics GP can be found here
DynDeveloper.com

DynDeveloper.com

Table Edits Forum Articles
Table Edits 0 Table Edits 0 Table Edits 0
Sign Up Now!Log In
trindocs 9/21/2018 4:58:07 PM

Econnect enter match payables with variances

Hello!

We are creating enter match invoices vie econnect and having issues with inventory line items. When we pass in the below XMLs for noninventory GP is setting the distributions correctly with createdist=1 (meaning we are letting GP create them) when we pass in the same XML for inventory items GP never creates the distribution correctly and will leave out the purchase line or the calculate the wrong variance. We cannot use AUTO cost because the EXT cost can be different, thus the reason for the variance. Any help will be appreciated. 

Noninventory that is working fine

<?xml version="1.0" encoding="utf-16"?>
<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>
      <taPopRcptLineTaxInsert>
        <VENDORID>XXXXX</VENDORID>
        <POPRCTNM>RCPT00000001823</POPRCTNM>
        <TAXDTLID>P-94533        </TAXDTLID>
        <TAXTYPE>0</TAXTYPE>
        <ACTINDX>1933</ACTINDX>
        <TAXAMNT>100.82</TAXAMNT>
        <TOTPURCH>1206.24</TOTPURCH>
      </taPopRcptLineTaxInsert>
    </taPopRcptLineTaxInsert_Items>
    <taPopDistribution_Items xsi:nil="true" />
    <taAnalyticsDistribution_Items xsi:nil="true" />
    <taPopEnterMatchLotInsert_Items xsi:nil="true" />
    <taPopEnterMatchSerialInsert_Items xsi:nil="true" />
    <taPopEnterMatchInvLine_Items>
      <taPopEnterMatchInvLine>
        <POPRCTNM>RCPT00000001823</POPRCTNM>
        <POPMtchShpRcpt>R172502</POPMtchShpRcpt>
        <ShipRCPTLNNM>16384</ShipRCPTLNNM>
        <PONUMBER>PO124340</PONUMBER>
        <QTYINVCD>12</QTYINVCD>
        <ITEMNMBR>R90101701</ITEMNMBR>
        <VENDORID>XXXXX</VENDORID>
        <VNDITNUM>
        </VNDITNUM>
        <UNITCOST>2.92</UNITCOST>
        <EXTDCOST>35.04</EXTDCOST>
        <NONINVEN>1</NONINVEN>
        <POLNENUM>32768</POLNENUM>
      </taPopEnterMatchInvLine>
      <taPopEnterMatchInvLine>
        <POPRCTNM>RCPT00000001823</POPRCTNM>
        <POPMtchShpRcpt>R172502</POPMtchShpRcpt>
        <ShipRCPTLNNM>32768</ShipRCPTLNNM>
        <PONUMBER>PO124340</PONUMBER>
        <QTYINVCD>6</QTYINVCD>
        <ITEMNMBR>4WE6J6X/EG24N9K4/62</ITEMNMBR>
        <VENDORID>VALIN</VENDORID>
        <VNDITNUM>
        </VNDITNUM>
        <UNITCOST>195.20</UNITCOST>
        <EXTDCOST>1171.20</EXTDCOST>
        <NONINVEN>1</NONINVEN>
        <POLNENUM>49152</POLNENUM>
      </taPopEnterMatchInvLine>
    </taPopEnterMatchInvLine_Items>
    <taPopEnterMatchInvToShpMultiLine_Items xsi:nil="true" />
    <taPopEnterMatchInvHdr>
      <POPRCTNM>RCPT00000001823</POPRCTNM>
      <VNDDOCNM>3339572</VNDDOCNM>
      <receiptdate>09/12/2018</receiptdate>
      <BACHNUMB>TD-09212018</BACHNUMB>
      <VENDORID>XXXXX</VENDORID>
      <SUBTOTAL>1206.24</SUBTOTAL>
      <FRTAMNT>38.51</FRTAMNT>
      <TAXAMNT>100.82</TAXAMNT>
      <TAXSCHID>XXXXX </TAXSCHID>
      <USINGHEADERLEVELTAXES>1</USINGHEADERLEVELTAXES>
    </taPopEnterMatchInvHdr>
    <taMdaUpdate_Items xsi:nil="true" />
  </POPEnterMatchInvoiceType>
</eConnect>

Inventory that does not work

<?xml version="1.0" encoding="utf-16"?>
<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>
      <taPopRcptLineTaxInsert>
        <VENDORID>XXXXX</VENDORID>
        <POPRCTNM>RCPT00000001723</POPRCTNM>
        <TAXDTLID>P-94533        </TAXDTLID>
        <TAXTYPE>0</TAXTYPE>
        <ACTINDX>1896</ACTINDX>
        <TAXAMNT>135.83</TAXAMNT>
        <TOTPURCH>1658.92</TOTPURCH>
      </taPopRcptLineTaxInsert>
    </taPopRcptLineTaxInsert_Items>
    <taPopDistribution_Items xsi:nil="true" />
    <taAnalyticsDistribution_Items xsi:nil="true" />
    <taPopEnterMatchLotInsert_Items xsi:nil="true" />
    <taPopEnterMatchSerialInsert_Items xsi:nil="true" />
    <taPopEnterMatchInvLine_Items>
      <taPopEnterMatchInvLine>
        <POPRCTNM>RCPT00000001723</POPRCTNM>
        <POPMtchShpRcpt>R172271</POPMtchShpRcpt>
        <ShipRCPTLNNM>16384</ShipRCPTLNNM>
        <PONUMBER>PO124381</PONUMBER>
        <QTYINVCD>4</QTYINVCD>
        <ITEMNMBR>XXXXX<</ITEMNMBR>
        <VENDORID>XXXXX<</VENDORID>
        <VNDITNUM>
        </VNDITNUM>
        <UNITCOST>414.73</UNITCOST>
        <EXTDCOST>1658.92</EXTDCOST>
        <NONINVEN>1</NONINVEN>
        <POLNENUM>16384</POLNENUM>
      </taPopEnterMatchInvLine>
    </taPopEnterMatchInvLine_Items>
    <taPopEnterMatchInvToShpMultiLine_Items xsi:nil="true" />
    <taPopEnterMatchInvHdr>
      <POPRCTNM>RCPT00000001723</POPRCTNM>
      <VNDDOCNM>30448212</VNDDOCNM>
      <receiptdate>08/31/2018</receiptdate>
      <BACHNUMB>TD-09212018</BACHNUMB>
      <VENDORID>XXXXX<</VENDORID>
      <SUBTOTAL>1658.92</SUBTOTAL>
      <FRTAMNT>18.00</FRTAMNT>
      <TAXAMNT>135.83</TAXAMNT>
      <TAXSCHID>XXXXX<  </TAXSCHID>
      <USINGHEADERLEVELTAXES>1</USINGHEADERLEVELTAXES>
    </taPopEnterMatchInvHdr>
    <taMdaUpdate_Items xsi:nil="true" />
  </POPEnterMatchInvoiceType>
</eConnect>

Version: GP 2015, GP 2013, GP 2010
Section: .NET Development, Dynamics GP, eConnect, Visual Studio Tools for Dynamics GP, Web Services








Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables