Problem with eConnect POPTransactionType

(0) Share

Report

Posted on by Community Member Microsoft Employee

Hello.

I am trying to create a purchase orden with eConnect. I have Dynamics GP 2010 SP4. It is the XML that I use:

<?xml version=\"1.0\"?>
<eConnect xmlns:xsi=\"www.w3.org/.../XMLSchema-instance\" xmlns:xsd=\"www.w3.org/.../XMLSchema\">
	<POPTransactionType>
		<eConnectProcessInfo xsi:nil=\"true\" />
		<taRequesterTrxDisabler_Items xsi:nil=\"true\" />
		<taUpdateCreateItemRcd xsi:nil=\"true\" />
		<taUpdateCreateVendorRcd xsi:nil=\"true\" />
		<taCreateVendorAddress_Items xsi:nil=\"true\" />
		<taUpdateCreateCustomerRcd xsi:nil=\"true\" />
		<taCreateCustomerAddress_Items xsi:nil=\"true\" />
		<taPopIvcTaxInsert_Items xsi:nil=\"true\" />
		<taPopDistribution_Items xsi:nil=\"true\" />
		<taAnalyticsDistribution_Items xsi:nil=\"true\" />
		<taPoLine_Items>
		<taPoLine>
			<PONUMBER>242735CNPO0192</PONUMBER>
			<DOCDATE>2015-10-26</DOCDATE>
			<VENDORID>900621595</VENDORID>
			<VNDITNUM>REJILLA</VNDITNUM>
			<ITEMNMBR>REJILLA</ITEMNMBR>
			<QUANTITY>1.000</QUANTITY>
			<NONINVEN>1</NONINVEN>
			<UNITCOST>38901315</UNITCOST>
			<UOFM>Cada</UOFM>
			<ProjNum>2427-C000</ProjNum>
			<CostCatID>714051001</CostCatID>
		</taPoLine>
		</taPoLine_Items>
		<taPoHdr>
			<PONUMBER>242735CNPO0192</PONUMBER>
			<VENDORID>900621595</VENDORID>
			<DOCDATE>2015-10-26</DOCDATE>
			<ALLOWSOCMTS>0</ALLOWSOCMTS>
			<PRSTADCD>PRINCIPAL</PRSTADCD>
			<VADCDPAD>PRINCIPAL</VADCDPAD>
			<PRBTADCD>PRINCIPAL</PRBTADCD>
			<CURNCYID>COP</CURNCYID>
			<UpdateIfExists>1</UpdateIfExists>
			</taPoHdr>
	</POPTransactionType>
</eConnect>

When I use the CreateEntity or CreateTransactionEntity I get this error:

{"Sql procedure error codes returned: \n\rError Number = 9184  Stored Procedure= taPoHdr  Error Description = Document is currently being edited by another user.\r\nNode Identifier Parameters: taPoHdr\r\n\r\n\r\n<taPoHdr>\r\n  <PONUMBER>250999CNSO999</PONUMBER>\r\n  <VENDORID>900621595</VENDORID>\r\n  <DOCDATE>2015-10-26</DOCDATE>\r\n  <ALLOWSOCMTS>0</ALLOWSOCMTS>\r\n  <PRSTADCD>PRINCIPAL</PRSTADCD>\r\n  <VADCDPAD>PRINCIPAL</VADCDPAD>\r\n  <PRBTADCD>PRINCIPAL</PRBTADCD>\r\n  <CURNCYID>COP</CURNCYID>\r\n  <UpdateIfExists>1</UpdateIfExists>\r\n</taPoHdr>\r\n"}

But, the PO number not exist. It is a new PO Order.

Thank you for you help

*This post is locked for comments

All responses (9)

Answers (1)

Verified answer

GovindDevda 615 on at

Like (0)

Report

RE: Problem with eConnect POPTransactionType

Jaime if you don't mind can i ask you from which resource/ software you integrate the data into GP i mean you using econnect right ? This is a error of Company ID means that if you write any manually code with the ref of eConnect then please check you connection string (Database) because you just verify that in which company database you enter your data. and you also find your company ID

select * from SY01500 through this table.

Hope this is helpful for you !!

Regards,

Govind Devda
Community Member Microsoft Employee on at

Like (0)

Report
RE: Problem with eConnect POPTransactionType

Hi.

I deleted the record and I tried to add the record with eConnet and I get the same error:

{"Sql procedure error codes returned: \n\rError Number = 375 Stored Procedure= taPoHdr Error Description = Ship to Address ID does not exist\r\nNode Identifier Parameters: taPoHdr\r\nPONUMBER = 250999CNSO999\r\nVENDORID = 900621595\r\n\r\n\r\nError Number = 381 Stored Procedure= taPoHdr Error Description = Bill to Address ID (PRBTADCD) does not exist in the Company Location Master Table - SY00600\r\nNode Identifier Parameters: taPoHdr\r\nPONUMBER = 250999CNSO999\r\nVENDORID = 900621595\r\nRelated Error Code Parameters for Node : taPoHdr\r\nPRBTADCD = PRINCIPAL\r\n\r\n\r\n<taPoHdr>\r\n <PONUMBER>250999CNSO999</PONUMBER>\r\n <VENDORID>900621595</VENDORID>\r\n <DOCDATE>2015-10-26</DOCDATE>\r\n <ALLOWSOCMTS>0</ALLOWSOCMTS>\r\n <PRSTADCD>PRINCIPAL</PRSTADCD>\r\n <VADCDPAD>PRINCIPAL</VADCDPAD>\r\n <PRBTADCD>PRINCIPAL</PRBTADCD>\r\n <CURNCYID>COP</CURNCYID>\r\n</taPoHdr>\r\n"}
GovindDevda 615 on at

Like (0)

Report

RE: Problem with eConnect POPTransactionType

Jaime now you enter trx manually and delete it then after you integrate particular record right ? If yes then please share me full error description of eConnect which you are facing.

Regards,

Govind
Community Member Microsoft Employee on at

Like (0)

Report

RE: Problem with eConnect POPTransactionType

Hi.

I added manually the record through the PO Windows the GP, and I didn't have problema.
Community Member Microsoft Employee on at

Like (0)

Report

RE: Problem with eConnect POPTransactionType

Hi.

I'm looking at the LOCATNID

The collation is SQL_Latin1_General_CP1_CI_AS
GovindDevda 615 on at

Like (0)

Report

RE: Problem with eConnect POPTransactionType

Please use the existing "Ship to Address ID " & "Bill to Address ID (PRBTADCD)" which is exist into GP and one more thing is that if you want to verify your data is correct or not then manually enter into GP that particular record which you want to enter.

If GP accept that particular record then delete that record and then try to push into GP.

My suggestion you can also use VKonnact Product its really very good product to integrate data into GP.

Thanks & Regards,

Govind Devda
chadbruels 1,582 on at

Like (0)

Report

RE: Problem with eConnect POPTransactionType

Does "PRINCIPAL" exist for the correct company? Are you looking at the LOCATNID or the ADRSCODE? Is the database collation case sensitive and does the case your value match the value in the system?
Community Member Microsoft Employee on at

Like (0)

Report

RE: Problem with eConnect POPTransactionType

Thank you. But now It show me this error:

{"Sql procedure error codes returned: \n\rError Number = 375 Stored Procedure= taPoHdr Error Description = Ship to Address ID does not exist\r\nNode Identifier Parameters: taPoHdr\r\nPONUMBER = 250999CNSO999\r\nVENDORID = 900621595\r\n\r\n\r\nError Number = 381 Stored Procedure= taPoHdr Error Description = Bill to Address ID (PRBTADCD) does not exist in the Company Location Master Table - SY00600\r\nNode Identifier Parameters: taPoHdr\r\nPONUMBER = 250999CNSO999\r\nVENDORID = 900621595\r\nRelated Error Code Parameters for Node : taPoHdr\r\nPRBTADCD = PRINCIPAL\r\n\r\n\r\n<taPoHdr>\r\n <PONUMBER>250999CNSO999</PONUMBER>\r\n <VENDORID>900621595</VENDORID>\r\n <DOCDATE>2015-10-26</DOCDATE>\r\n <ALLOWSOCMTS>0</ALLOWSOCMTS>\r\n <PRSTADCD>PRINCIPAL</PRSTADCD>\r\n <VADCDPAD>PRINCIPAL</VADCDPAD>\r\n <PRBTADCD>PRINCIPAL</PRBTADCD>\r\n <CURNCYID>COP</CURNCYID>\r\n</taPoHdr>\r\n"}

I looked the SY00600 Table and the address id exist.

Any idea.

Thank you
chadbruels 1,582 on at

Like (0)

Report

RE: Problem with eConnect POPTransactionType

I know that with some of the eConnect nodes the UpdateIfExists flag does not actually work as one would expect. I'm not certain whether this is the case with taPOHdr or not, but if it is a new transaction there is no reason to send a value of 1 for this flag. I suggest sending 0 for this flag and seeing if you get a different result.