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

eConnect - getting the version info

Ever needed to get the eConnect version on the system that you're working on?

eConnect - The following errors were found while validating distributions:

I get this error occasionally, and it's usually self explanatory. Often I need to turn on the CREATEDIST parameter.

Today was different:

Note the suspicious lack of any error.

ASP.NET - Button clicks not firing on the home page

We noticed while working on this site (we actively develop the site, but we also use it all day long in our day job <smiles>) that the Search feature didn't work on the home page. But, it worked on any other page.

Put another way, if we were on http://DynDeveloper.com it would not work, but if we were on http://DynDeveloper.com/default.aspx it would work.

Grrr.

Regex - match part of a URL querystring

I struggle mightily with Regex, so every time that I achieve something I blog it.

Today, I wanted to look into the URL of a web site and remove part of the query string. Specifically, in these cases:

www.mysite.com?userid=123xy

www.mysite.com?userid=123xy&username=joe

www.mysite.com?tag=xyz&userid=1ww45

www.mysite.com?tag=xyz&userid=1g3x5&username=joe

I wanted to remove the 'userid=xxxxx' out of the url.

eConnect - Site ID and Price Level are disabled in Dynamics

I'm trying to run a SOP eConnect transaction into Dynamics GP, and I'm getting a series of errors that I've not seen before. (and I've seen a lot <smiles>)

When I open the SOP Entry window and expand the line, I see that Site ID and Price Level are disabled.

Also, the Item Setup is not being respected: when I key an item it populates with 'EACH' and no Unit Price but I clearly have a price level set up for this customer and item and the UOM should be EA and there should be a price.

I'm a developer with limited GP experience (but I do know how to set up customers and items), could anyone shed some light on why these things are happening?

GP Web Services authentication issue

I have (I believe) an authentication issue. Trying to use GP Web Services to push data into a GP database.

I have GP (2013), GP Web Services, and SQL Server (2008 R2) installed on one server, and I am hooked into the Web Service through VS2012 on a separate machine.

I have been able to retrieve data using the GetCompanyList() method; but any method requiring a policy object fails at the point of retrieving the policy object with GetPolicyByOperation() (I've tried with CreateCustomer() and CreateSalesInvoice() ).

I have been working with four different accounts -- DYNSA, sa, GPServices, and my AD user account. As far as I can tell, I have configured all four accounts with full access to SQL Server, GP, and GP Web Services. Nevertheless, I'm pretty sure that I have something configured wrong with one or all of these accounts.

I get two different error sequences, depending on which account I assign to the DynamicsGPClient object. Sequence one returns a client-side exception message "The caller was not authenticated by the service.", and nothing on the server. This guy had the same issue, but no one ever responded.

Sequence two returns the generic client-side "unhandled system exception" message, and on the server side (in the Dynamics Exception Console) I get "Microsoft.Dynamics.Security.NonExistentSecurityObjectException : The security object does not exist. Key = 0". It's my understanding that "Key = 0" refers to the Company ID. Our test company is ID 1, and that is definitely the value I am assigning in the Context parm ... so why the server is looking for Key 0, I don't know.

Thanks in advance for any help.

Parent Debtor ID

Here is a question that I hope has a simple answer!!

We have 22 GP databases and have a need to set up Parent Debtor ID;s across these databases; some debtors will exist in multiple databases and we want to combine and have 1 master Patent debtor ID for all company's

What is the best method of maintaining these ID's across all databases?

Many thanks

PM BCHSOURC Values

Does anybody know how to find the valid values assigned to BCHSOURCE in the PM tables (specifically PM20000/PM30200)? Is there a reliable way to identify Computer Check payments besides the BCHSOURCE field?

GP10 Integrating and Applying Credit Memos to invoices?

Hi,

I have a question about GP10's ability to import and apply credit memos to invoices.

1. Can it be done? I don't see any options.

2. eConnect can do it right? in GP10?

If it cannot be done in GP10 natively, what are the options? The client may not upgrade to a later version of GP due to the possibility of moving to a new product.

I know smart connect may work, and I have a question out to them on it.

Thanks in advance!!!

Mark

Get all SOP shipments for a date range.

I need a query that returns all shipments to customers for a given date range. It needs to include all usage scenarios, i.e. fulfillment orders, invoices.

Apologies for the newbie type of question.

Thanks.

It looks like I can just use IV30300 for Transaction Document Types = 6.

Winforms - Iterate through the grid

Code to iterate through a RadGridView