DynDeveloper.com

This is our first article on retrieving objects using eConnect, so this is all new ground. I expect we'll be fine tuning the code and developing wrapper classes... but this is what we have for now.

This is sample code to retrieve a customer from Dynamics using eConnect. The customer that we get back looks like this:

I never really knew that you could retrieve a customer from Dynamics, update something on the customer, and then update the customer in Dynamics. But you can...

There article is a complete set of sample code on how to retrieve a customer and then update a customer in .NET.

If this is new to you, please go through the example on how to retrieve a customer here:

http://dyndeveloper.com/articleview.aspx?ArticleID=172

Before doing this. That entire piece of code is used in this code.

This article is a complete example of a PA TimeSheet entry

It seems that I'm always using the same VBA snippits in Ingetration Manager. And I always have to look them up in help, because I don't do it that often and I have .NET and SQL code in my head; VBA is a distant cousin.

Here are a few of the snippets that I use... so I can find them quicker when I need them.

When doing a GP9 to GP 2010 upgrade, I got this error:

Msg 15148, Level 16, State 1, Procedure sp_bindefault, Line 230
The data type or table column '[eConnect_Out].[DBNAME]' does not exist or you do not have permission.

The following SQL statement produced an error:
EXEC sp_bindefault N'[dbo].[GPS_CHAR]', N'[eConnect_Out].[DOCTYPE]'
EXEC sp_bindefault N'[dbo].[TA_DATE]', N'[eConnect_Out].[DATE1]'
EXEC sp_bindefault N'[dbo].[GPS_CHAR]', N'[eConnect_Out].[TABLENAME]'
EXEC sp_bindefault N'[dbo].[GPS_INT]', N'[eConnect_Out].[DEX_ROW_ID]'
EXEC sp_bindefault N'[dbo].[GPS_CHAR]', N'[eConnect_Out].[INDEX1]'
EXEC sp_bindefault N'[dbo].[GPS_CHAR]', N'[eConnect_Out].[INDEX2]'
EXEC sp_bindefault N'[dbo].[GPS_CHAR]', N'[eConnect_Out].[INDEX3]'
EXEC sp_bindefault N'[dbo].[GPS_CHAR]', N'[eConnect_Out].[INDEX4]'
EXEC sp_bindefault N'[dbo].[GPS_CHAR]', N'[eConnect_Out].[INDEX5]'
EXEC sp_bindefault N'[dbo].[GPS_CHAR]', N'[eConnect_Out].[INDEX6]'
EXEC sp_bindefault N'[dbo].[GPS_CHAR]', N'[eConnect_Out].[INDEX7]'
EXEC sp_bindefault N'[dbo].[GPS_CHAR]', N'[eConnect_Out].[INDEX8]'
EXEC sp_bindefault N'[dbo].[GPS_CHAR]', N'[eConnect_Out].[INDEX9]'
EXEC sp_bindefault N'[dbo].[GPS_CHAR]', N'[eConnect_Out].[INDEX10]'
EXEC sp_bindefault N'[dbo].[GPS_CHAR]', N'[eConnect_Out].[INDEX11]'
EXEC sp_bindefault N'[dbo].[GPS_CHAR]', N'[eConnect_Out].[INDEX12]'
EXEC sp_bindefault N'[dbo].[GPS_CHAR]', N'[eConnect_Out].[INDEX13]'
EXEC sp_bindefault N'[dbo].[GPS_CHAR]', N'[eConnect_Out].[INDEX14]'
EXEC sp_bindefault N'[dbo].[GPS_CHAR]', N'[eConnect_Out].[INDEX15]'
EXEC sp_bindefault N'[dbo].[GPS_INT]', N'[eConnect_Out].[ACTION]'
EXEC sp_bindefault N'[dbo].[GPS_INT]', N'[eConnect_Out].[REPLICATE]'
EXEC sp_bindefault N'[dbo].[TA_DBNAME]', N'[eConnect_Out].[DBNAME]'

GRANT REFERENCES , SELECT , INSERT , DELETE , UPDATE ON dbo.eConnect_Out TO DYNGRP

I'm on a machine where Dynamics has been upgraded from GP 9 to GP 2010. I'm trying to upgrade the VS Tools project. I've encountered several errors that have been very frustrating... largely because I can't find any documentation on them. I'm going to document the errors here for the community.

Type 'IDexterityAddIn' is not defined.

Could not load file or assembly 'Microsoft.Dynamics.Framework.UI.WinForms.Controls, Version=1.4.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35' or one of its dependencies. The system cannot find the file specified.

Type 'Microsoft.Dexterity.Shell.UI.DexUIForm' is not defined

In a recent project, we needed to

• Get a line from a SOP document
• Delete the line
• Resubmit the line using the SOPTransactionType. (It allows you to submit a line only, and that will add a line to the SOP document)

This is the piece of code that we used to do step one, getting the SOP document line.

This function takes a SOP Number, Type, and Line Item Sequence as params and returns a 

Microsoft.Dynamics.GP.eConnect.Serialization.taSopLineIvcInsert_ItemsTaSopLineIvcInsert

 object. Since it's already in that form all we have to do is to edit it a little and re-submit it.

I love my job. Something new to figure out every day.

Today we needed to find a way to make Integration Manager work with Azox Extended Pricing. The script privided below makes use of a 'Pre' script, the taSopLineIvcInsertPre. This script fires before each line is inserted in a SOP ingegration. The basic idea is that we look up the price in Azox and substitute it for the price that is in the integrations.

*** There is only about an hour of work in this script. It will not work for all situations, probably even most situations. It is intended as a starting point. You'll need to carefully test this against your data and make improvements.

This article will show how to put a field onto a form in Dynamics GP using Modifier, and read/save data for that field in VBA

This article will add on to the video here http://dyndeveloper.com/articleview.aspx?ArticleID=27 that shows how to add a field to Dynamics GP and to read data. You'll want to review that first if you're not familiar with the technique

In this example we've added a field to the Item Maintenance form called 'Color', the code below assumes that you're already done that, and that you've added the form to VBA (again, see the video for instructions)

This article contains code for a trigger template.

I work for 4 or 5 customers a day on support calls, I'm coding on their system remotely; I don't have the luxury of setting up SQL Server SSMS the way that I like it and coding blissfully.

A basic task for me would be creating a trigger; but I really don't like the templates that come with SQL. 

I know if you want to create a shipment(1) or a shipment invoice(3) you use taPopRcptHdrInsert for the header.

if you have to create an invoice(2) you use taPopEnterMatchInvHdr.

What if I want to create a return(4), (5), (6), (7)?  Is there an econnect sproc for that and what is the best way to see if a screen has an econ sproc for it?

Hi everyone!

I'm trying to save a transaction using eConnect, the selected customer is on hold and eConnect crashes with this error message:

"Customer is on Hold, you must remove the Hold status to enter transactions"

But, if I try to save a transaction using the same customer in GP everything works great.

Is selling to held customers supported by the current version of eConnect?

Thanks in advance!

I am new to Modifier/VBA and have a project that requires the addition of a string field and a combo box to the Item Maintenance window and save the Item number and field values to a table (Ex. SSG_CALCOO), I would appreciate any help. 

This article will server as our place holder for code related to the Telerik ASPX GridNumericColumn