testuser 8/9/2011 7:19:54 AM

creating taSopLineIvcTaxInsert_ItemsTaSopLineIvcTaxInsert and uploading a Sales transaction into GP

I can econnect sales transctions that do not have tax into GP succesfully. By choosing a specific customer and the tax schedule ID I can manually enter a sales transcation in GP, and GP autmatically calculates tax for me.

However when the sales transactions are brought in through econnect, I either get an error or the transaction gets posted but tax is not reflected in GP.  

Could some one point me to some sample econnect code or xml document that will show me what are the fields that need to be passed and what value needs to be passed. The code I have so far is as follows:

Dim objtaSOPTax(1) As taSopLineIvcTaxInsert_ItemsTaSopLineIvcTaxInsert

Dim objTax As New taSopLineIvcTaxInsert_ItemsTaSopLineIvcTaxInsertobjTax.SOPTYPE = objtaSopHdrIvcInsert.SOPTYPE

objTax.SOPNUMBE = objtaSopHdrIvcInsert.SOPNUMBE

objTax.CUSTNMBR = ConfigurationSettings.AppSettings("GPCustomer546TAX").ToString()

objTax.TAXDTLID = ConfigurationSettings.AppSettings("TAXDTLID546").ToString()

objTax.TDTTXSLS = decTotal - decSalesTax

objTax.TDTTXSLSSpecified = True

objTax.TXDTOTTX = decSalesTax

objTax.TXDTOTTXSpecified = True

objTax.SALESAMT = decTotal - decSalesTax

objTax.STAXAMNT = decSalesTax

objTax.LNITMSEQ = 0

objtaSOPTax(0) = objTax

In the header:

objtaSopHdrIvcInsert.SUBTOTAL = decTotal - decSalesTax

objtaSopHdrIvcInsert.TAXSCHID = ConfigurationSettings.AppSettings(
"TAXDTLID546").ToString()

objtaSopHdrIvcInsert.TAXAMNT = decSalesTax

objtaSopHdrIvcInsert.USINGHEADERLEVELTAXES = 1

objtaSopHdrIvcInsert.CREATETAXES = 0

 

Version: Unknown or N/A
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
3