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
dwatkins 11/17/2011 7:46:26 AM

eConnect & Tax Report

Hi,

I'm posting an XML document to eConnect, but I'm having trouble getting it to create a record in two tables within Dynamics GP.

  1. PA10704
  2. POP10360

If I don't have records in those two tables then this purchase doesn't show on the VAT report.

If I view the record in the Receivings Transaction Entry screen within Dynamics it puts in a record, but doesn't calculate the values and just puts them as Zero.

I feel I maybe missing something so that even Dynamics can't work out the values correctly to insert them when I view the record, but I'm not really sure. I'm very new to this system!

My XML:

<?xml version="1.0" encoding="utf-16"?>
<eConnect xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
  <POPReceivingsType>
    <eConnectProcessInfo xsi:nil="true" />
    <taRequesterTrxDisabler_Items xsi:nil="true" />
    <taUpdateCreateItemRcd xsi:nil="true" />
    <taUpdateCreateVendorRcd xsi:nil="true" />
    <taCreateVendorAddress_Items xsi:nil="true" />
    <taPopRcptLotInsert_Items xsi:nil="true" />
    <taPopRcptSerialInsert_Items xsi:nil="true" />
    <taPopRcptLineInsert_Items>
      <taPopRcptLineInsert>
        <POPTYPE>3</POPTYPE>
        <POPRCTNM>RPT88</POPRCTNM>
        <ITEMNMBR>AFEE</ITEMNMBR>
        <ITEMDESC>AFEE</ITEMDESC>
        <VENDORID>UKN0001</VENDORID>
        <VNDITNUM>AGENT FEE</VNDITNUM>
        <VNDITDSC>AFEE</VNDITDSC>
        <UNITCOST>10.0000</UNITCOST>
        <EXTDCOST>10.0000</EXTDCOST>
        <NONINVEN>1</NONINVEN>
        <QTYSHPPD>1</QTYSHPPD>
        <QTYINVCD>1</QTYINVCD>
        <Purchase_IV_Item_Taxable>3</Purchase_IV_Item_Taxable>
        <Purchase_Item_Tax_Schedu>PX</Purchase_Item_Tax_Schedu>
        <Purchase_Site_Tax_Schedu>PX</Purchase_Site_Tax_Schedu>
        <LOCNCODE>ASSOSIA</LOCNCODE>
        <receiptdate>05 Oct 2011</receiptdate>
        <ProjNum>1004DRINUK     </ProjNum>
        <CostCatID>AGENT FEE</CostCatID>
      </taPopRcptLineInsert>
    </taPopRcptLineInsert_Items>
    <taPopRcptMultiBin_Items xsi:nil="true" />
    <taPopRcptLineTaxInsert_Items>
      <taPopRcptLineTaxInsert>
        <VENDORID>UKN0001</VENDORID>
        <POPRCTNM>RPT88</POPRCTNM>
        <TAXDTLID>PX</TAXDTLID>
        <TAXTYPE>0</TAXTYPE>
        <TOTPURCH>10.0000</TOTPURCH>
      </taPopRcptLineTaxInsert>
    </taPopRcptLineTaxInsert_Items>
    <taPopRctUserDefined xsi:nil="true" />
    <taPopDistribution_Items xsi:nil="true" />
    <taAnalyticsDistribution_Items xsi:nil="true" />
    <taPopRcptHdrInsert>
      <POPRCTNM>RPT88</POPRCTNM>
      <POPTYPE>3</POPTYPE>
      <VNDDOCNM>VDN88</VNDDOCNM>
      <receiptdate>05 Oct 2011</receiptdate>
      <BACHNUMB>BCH20111117122139</BACHNUMB>
      <VENDORID>UKN0001</VENDORID>
      <TRDISAMT>0</TRDISAMT>
      <DISAVAMT>0</DISAVAMT>
      <Tax_Date>17 Nov 2011</Tax_Date>
      <AUTOCOST>1</AUTOCOST>
      <TAXSCHID>PX</TAXSCHID>
      <Purchase_Freight_Taxable>3</Purchase_Freight_Taxable>
      <Purchase_Misc_Taxable>3</Purchase_Misc_Taxable>
      <USINGHEADERLEVELTAXES>1</USINGHEADERLEVELTAXES>
      <RATEEXPR>0</RATEEXPR>
      <DYSTINCR>0</DYSTINCR>
      <TRXDTDEF>0</TRXDTDEF>
      <RTCLCMTD>0</RTCLCMTD>
      <CDOCNMBR>PNO151223</CDOCNMBR>
    </taPopRcptHdrInsert>
    <taMdaUpdate_Items xsi:nil="true" />
  </POPReceivingsType>
</eConnect>

Any help greatly appreciated!

eConnect doesn't generate any errors when I post my XML document, but I don't get those records I need for the VAT Report. Any ideas anyone?

Regards,

David Watkins

Version: GP 2010
Section: Dynamics GP, 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