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
3