DynDeveloper.com - Your Dynamics GP Questions, Answered

	SOP Scripts
	eConnect
	taSopDeleteDocumentWrapper
	taSopLineDeleteWrapper
	taSOPLineIvcInsert Wrapper
	taSopLineIvcInsertComponent
	taSOPLotAuto - complete procedure
	Functions
	ddf_Address
	ddf_AllHoldsOnASOPDoc
	General
	Getting Email addresses from Dynamics GP
	Move a SOP transaction from open to history
	Posting Sequences
	SOP40200 'Allow' fields query
	sopGetIDNumber
	sopTrxDeleteWork
	Unvoid a SOP document
	Stored Procedures
	dd_SOP10102_UPD
	dd_SOPGetNextDocNumber/ sopGetIDNumber.
	dd_SOPPayment_INS
	dd_SOPRound - Round a SOP Multicurrency document to two decimal places
	dd_SOPTotal
	dd_SOPTotalTaxes
	dd_taSopVoidDocumentWrapper

Archives

Sql procedure error codes returned: Error Number = 3389 Stored Procedure taPopRcptLineInsert Error

Edit 9/17/15 View the main article for this error here

Sql procedure error codes returned: Error Number = 3389

Stored Procedure taPopRcptLineInsert Error

Description = The Serial/Lot Quantity in the POP10330 does not match the Quantity Shipped in the POP10500

with this document:

<eConnect xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xsd='http://www.w3.org/2001/XMLSchema'>

<POPReceivingsType>

<taPopRcptLotInsert_Items >

<taPopRcptLotInsert>

<POPRCTNM>0166729 </POPRCTNM>

<ITEMNMBR>DAVIDSBRICK2~~</ITEMNMBR>

<SERLTNUM>lot1</SERLTNUM>

<SERLTQTY>525</SERLTQTY>

<RCPTLNNM>0</RCPTLNNM>

</taPopRcptLotInsert>

</taPopRcptLotInsert_Items>

<taPopRcptLineInsert_Items>

<taPopRcptLineInsert>

<POPTYPE>1</POPTYPE>

<POPRCTNM>0166729 </POPRCTNM>

<PONUMBER>49771</PONUMBER>

<ITEMNMBR>DAVIDSBRICK2~~</ITEMNMBR>

<VENDORID>TEST VENDOR </VENDORID>

<RCPTLNNM>0</RCPTLNNM>

<VNDITNUM>DAVIDSBRICK2~~ </VNDITNUM>

<UOFM>Each </UOFM>

<AUTOCOST>1</AUTOCOST>

<QTYSHPPD>525</QTYSHPPD>

</taPopRcptLineInsert>

</taPopRcptLineInsert_Items>

<taPopRcptHdrInsert>

<POPRCTNM>0166729 </POPRCTNM>

<POPTYPE>1</POPTYPE>

<receiptdate>12/4/2007</receiptdate>

<ACTLSHIP>12/4/2007</ACTLSHIP>

<BACHNUMB>Yard Receipt</BACHNUMB>

<AUTOCOST>1</AUTOCOST>

<VENDORID>TEST VENDOR </VENDORID>

</taPopRcptHdrInsert>

</POPReceivingsType>

</eConnect>

eConnect timeout when connecting remotely

Hey all,

I've got an application that is using the eConnect .Net assemblies to create an SOP transaction (eConnect/GP version 9). When the application runs on the same machine as the Dynamics GP database, everything works just great. However, if the application runs on a different machine, then the call to eConnect_EntryPoint() fails with a SqlException: "Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding."

Here's the kicker: if I just use the .Net data access libraries to establish the a connection remotely using the same connection string, everything works just fine.

I've made sure that DTC is running on both boxes, and that remote connections are allowed to the SQL server. I've also turned off the firewalls on both boxes to no avail.

Anyone seen this before? How can I get the remote eConnect connection to work?

Thanks in advance.

Peter

Accessing Lookup window and the return value

Hi all,

I am trying to open the Purchase Orders Lookup window and let the user select a PO, then write the selected value back into my winform. I can see the window opening but it does not stay open, so I cannot make a selection.

Any ideas ?

I am using VS Tools for GP 10.0

Line items contain qauntity types that are not allowed for the Order DOCID entered

eConnect error:

Line items contain qauntity types that are not allowed for the Order DOCID entered

or, spelled correctly:

Line items contain quantity types that are not allowed for the Order DOCID entered

Item/vendor item/vendor combination is not available to receive from the PO Line

Server was unable to process request. ---> Sql procedure error codes returned:

Error Number = 9343 Stored Procedure taPopRcptLineInsert Error Description = Item/vendor item/vendor combination is not available to receive from the PO Line
Node Identifier Parameters: taPopRcptLineInsert POPTYPE = 1 POPRCTNM = 0167653 PONUMBER = 49771 ITEMNMBR = DAVIDSBRICK2~~
Related Error Code Parameters for Node : taPopRcptLineInsert VNDITNUM = DAVIDSBRICK2~~ VENDORID = TEST VENDOR

Edit 9/17/15 View the main article for this error here

Error Number = 3799 Stored Procedure taPopRcptLineInsert Error Description = VENDORID does not match the Purchase Order
Node Identifier Parameters: taPopRcptLineInsert POPTYPE = 1 POPRCTNM = 0167653 PONUMBER = 49771 ITEMNMBR = DAVIDSBRICK2~~
Related Error Code Parameters for Node : taPopRcptLineInsert PONUMBER = 49771 VENDORID = TEST VENDOR

Error Number = 4606 Stored Procedure taPopRcptLineInsert Error Description = UOFM can not be changed when receiving an Inventoried or Non-Inventoried Item against a PO Node Identifier Parameters: taPopRcptLineInsert POPTYPE = 1 POPRCTNM = 0167653 PONUMBER = 49771 ITEMNMBR = DAVIDSBRICK2~~
Related Error Code Parameters for Node : taPopRcptLineInsert PONUMBER = 49771 UOFM = Each

Edit 9/17/15 View the main article for this error here

Error Number = 2053 Stored Procedure taPopRcptLineInsert Error Description = Purchase Order Line Item does not exist
Node Identifier Parameters: taPopRcptLineInsert POPTYPE = 1 POPRCTNM = 0167653 PONUMBER = 49771 ITEMNMBR = DAVIDSBRICK2~~
Related Error Code Parameters for Node : taPopRcptLineInsert PONUMBER = 49771

This error came to me when attempting a PO Receipt integration on a lotted item.

It went away when I changed the LOCNCODE to the one on the PO, even though the other one was valid and worked in Dynamics.

Iterating through an XML file

Given the XML structure:

<employees>

<employee>

<firstname>John</firstname>

<lastname>Doe</lastname>

</employee>

<employee>

<firstname>James</firstname>

<lastname>Buck</lastname>

</employee>

<employees>

I sometimes need to loop (iterate) through the file and gather the first/last names

Here is a piece of code that will do that

Unable to validate data

I'm going to try putting

<%@ Page Language="vb" EnableViewStateMac="False"%>

In the page declaration at the top of the page, that seems to be the consensus when I searched on this error.

What is EnableViewStateMac?
Here is what MSDN documentation has to say about EnableViewStateMac:

EnableViewStateMac
Indicates that ASP.NET should run a machine authentication check (MAC) on the page's view state when the page is posted back from the client. true if view state should be MAC checked; otherwise, false. The default is false.

Note A view state MAC is an encrypted version the hidden variable that a page's view state is persisted to when sent to the browser. When you set this attribute to true, the encrypted view state is checked to verify that it has not been tampered with on the client.

More info here.