DynDeveloper.com

DynDeveloper.com

Sign Up Now!Log In
cthury 1/11/2018 6:53:13 PM

Tax Line, Freight Line, and Misc Line

I'm uploading PO data into GP using eConnect.  Part of this upload is header taxes, freight, and misc.  All the data is uploading, but the TYPE is not being set correctly.  They all show TAX.  But if you look at the XML, the TAXTYPE is set correctly for each line. 

TaxType=0=Regular
TaxType=1=Freight
TaxType=2=Misc

I then found out that setting the <FRTAMNT> and <MISCAMNT> will create the types I want, but I need those account string assigned to that FREIGHT line.  That is why I created 3 TAX lines in the XML.

Am I missing something in the Tax Lines?  Or the Header Line? 

<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>CDW</VENDORID>
        <POPRCTNM>NLNRCT0007120</POPRCTNM>
        <TAXDTLID>CITY OF BRYAN</TAXDTLID>
        <TAXTYPE>0</TAXTYPE>
        <ACTINDX>32004</ACTINDX>
        <ACTNUMST>00-82034-6060-015-00000</ACTNUMST>
        <TAXAMNT>2.00</TAXAMNT>
        <TAXPURCH>32.50</TAXPURCH>
      </taPopRcptLineTaxInsert>
      <taPopRcptLineTaxInsert>
        <VENDORID>CDW</VENDORID>
        <POPRCTNM>NLNRCT0007120</POPRCTNM>
        <TAXDTLID>CITY OF BRYAN</TAXDTLID>
        <TAXTYPE>1</TAXTYPE>
        <ACTINDX>31553</ACTINDX>
        <ACTNUMST>00-82034-6030-010-00000</ACTNUMST>
        <TAXPURCH>32.50</TAXPURCH>
        <FRTTXAMT>1.00</FRTTXAMT>
      </taPopRcptLineTaxInsert>
      <taPopRcptLineTaxInsert>
        <VENDORID>CDW</VENDORID>
        <POPRCTNM>NLNRCT0007120</POPRCTNM>
        <TAXDTLID>CITY OF BRYAN</TAXDTLID>
        <TAXTYPE>2</TAXTYPE>
        <ACTINDX>31554</ACTINDX>
        <ACTNUMST>00-82034-6030-017-00000</ACTNUMST>
        <TAXPURCH>32.50</TAXPURCH>
        <MSCTXAMT>1.50</MSCTXAMT>
      </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>NLNRCT0007120</POPRCTNM>
        <POPMtchShpRcpt>NLNRCT0007037</POPMtchShpRcpt>
        <ShipRCPTLNNM>16384</ShipRCPTLNNM>
        <PONUMBER>NLNPO0002538</PONUMBER>
        <QTYINVCD>2.00</QTYINVCD>
        <ITEMNMBR>88011-99</ITEMNMBR>
        <VENDORID>CDW</VENDORID>
        <VNDITNUM>88011-99</VNDITNUM>
        <UNITCOST>0</UNITCOST>
        <EXTDCOST>0</EXTDCOST>
        <NONINVEN>1</NONINVEN>
        <AUTOCOST>1</AUTOCOST>
        <POLNENUM>1</POLNENUM>
      </taPopEnterMatchInvLine>
    </taPopEnterMatchInvLine_Items>
    <taPopEnterMatchInvToShpMultiLine_Items/>
    <taPopEnterMatchInvHdr>
      <POPRCTNM>NLNRCT0007120</POPRCTNM>
      <VNDDOCNM>test123cpt1</VNDDOCNM>
      <receiptdate>12/17/2017</receiptdate>
      <BACHNUMB>TAP-01/11/2018</BACHNUMB>
      <VENDORID>CDW</VENDORID>
      <SUBTOTAL>0</SUBTOTAL>
      <FRTAMNT>1.00</FRTAMNT>
      <MISCAMNT>1.50</MISCAMNT>
      <TAXAMNT>2.00</TAXAMNT>
      <AUTOCOST>1</AUTOCOST>
      <TAXSCHID>LAWRENCEVILLE</TAXSCHID>
      <Purchase_Freight_Taxable>1</Purchase_Freight_Taxable>
      <Purchase_Misc_Taxable>1</Purchase_Misc_Taxable>
      <FRTSCHID>LAWRENCEVILLE</FRTSCHID>
      <MSCSCHID>LAWRENCEVILLE</MSCSCHID>
      <FRTTXAMT>1.00</FRTTXAMT>
      <MSCTXAMT>1.50</MSCTXAMT>
      <USINGHEADERLEVELTAXES>1</USINGHEADERLEVELTAXES>
    </taPopEnterMatchInvHdr>
    <taMdaUpdate_Items xsi:nil="true"/>
  </POPEnterMatchInvoiceType>
</eConnect>

 

 

In this screen shot, I want the FREIGHT Line to contain the Account String from one of those TAX lines.  Same with the MISC Line.

Version: GP 2013
Section: eConnect