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
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








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