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