Archives

 

Does anyone have any experince with this course? Worth it? It's $249

https://www.microsoftelearning.com/eLearning/offerDetail.aspx?offerPriceId=213222 

Anyone reccomend a course?

TIA

Gi 

 

 

I created a company (through Dynamics 9.0 Utilities) and then used a DB sync tool to make sure that all the objects were created.

 

WS Support says that I should have launched Wennsoft Utilities before the sync process by dropping WSUTIL.SET on top of DYNAMICS.EXE.

 

This document, and all our eConnect documentation, is available on the eConnect menu.  

The most frequently asked question here is 'how do I get started with eConnect?'. I've long known that the first example with any programing paradigm is the hardest thing to do - it's as true with VB.NET or ASP.NET as it is with eConnect. Here is a step by step walk through on how to get started.

Assumptions

The sample code provided written in Visual Studio 2008, VB.NET, ASP.NET in VB, and written against Dynamics GP 10.0. We assume familiarity with that environment.

The sample code is SAMPLE CODE ONLY, NOT FIT FOR PRODUCTION USE. It is intended to teach eConnect, and should not be used for any other purpose.

The files provided are compacted with WinRAR.

Introduction

First, read this, it's a conceptual primer for eConnect. It will tell you what eConnect does. http://dyndeveloper.com/Thread.aspx?threadid=350

Help File

Download and read the help file, which is here. Yes, read it. Every word.
eConnectIndex
Next, go back to the step above. You really need to do this.  

Serialization vs Manual coding

Serialization

 Serialization means that we instantiate eConnect objects and populate them, then use those objects to create the XML document that eConnect needs. That's an advanced topic, so we'll skip it for now.

Manual Coding

By 'manual coding', I mean that we're going to create an XML document by hand and then feed it to eConnect. The document that we're going to use will create/update a customer record.

eConnect has a 'client - server' relationship with Dynamics, meaning that your code frequently does not reside on the SQL Server. That can cause issues if you try to send a transaction from your client machine to the server, you have to set up 'DCOM' to make that work. I've had issues with this, so I don't do it. On all my jobs I set up a web service on the SQL Server and send that service an XML doc. It is very easy to do, and works without issue. That's what we're going to do here.

Download the VB.NET solution here
eConnectIndex
and open it up in VS2008. THE CODE MUST BE INSTALLED ON THE SQL SERVER to work. Once you get it working, you can publish the web service to the SQL Server, set a reference to it, and then move the client code off the server. For this example we're going to do it as simply as possible.

There are three projects in the sample solution. eConnect10 is the main library, Econnect Service is the Web Service, and Tester is a VB application that call the eConnect code and service.

 

Hi!

I am trying to use a gp adding project to limit the visible customers from the Customer ID Dropdown to only show the ACTIVE customers....

 Is that doable ?  How difficult is it ?  Any samples to give me a head start ?

 

Thanks

 

Fred

Hello everyone!

I'm writing an application in VB.NET that allows users to enter information for a Receivings Transaction. I follow the schema provided in the programmers guide, but even when the code shows no error, when I try to see the transaction in GP, this doesn't show. I look at the tables (POP10330, POP10310, POP10500) and the transaction is there, but not the header(POP10300). I don't know why the header is missing.

 The XML shows this:

<?xml version="1.0" encoding="utf-8" ?>

- <eConnect xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
- <POPReceivingsType>
  <eConnectProcessInfo xsi:nil="true" />
  <taRequesterTrxDisabler_Items xsi:nil="true" />
  <taUpdateCreateItemRcd xsi:nil="true" />
  <taUpdateCreateVendorRcd xsi:nil="true" />
  <taCreateVendorAddress_Items xsi:nil="true" />
- <taPopRcptLotInsert_Items>
- <taPopRcptLotInsert>
  <POPRCTNM>RCT00000000011960</POPRCTNM>
  <ITEMNMBR>TEST ITEM</ITEMNMBR>
  <SERLTNUM>ABC</SERLTNUM>
  <SERLTQTY>10</SERLTQTY>
  <RCPTLNNM>16384</RCPTLNNM>
  <LOCNCODE>GENERAL</LOCNCODE>
  <EXPNDATE>12/12/2008</EXPNDATE>
  </taPopRcptLotInsert>
  </taPopRcptLotInsert_Items>
  <taPopRcptSerialInsert_Items xsi:nil="true" />
- <taPopRcptLineInsert_Items>
- <taPopRcptLineInsert>
  <POPTYPE>1</POPTYPE>
  <POPRCTNM>RCT00000000011960</POPRCTNM>
  <PONUMBER>TEST PO</PONUMBER>
  <ITEMNMBR>TEST ITEM</ITEMNMBR>
  <VENDORID>TEST VENDOR ID</VENDORID>
  <RCPTLNNM>16384</RCPTLNNM>
  <UOFM>U</UOFM>
  <QTYSHPPD>10</QTYSHPPD>
  <AUTOCOST>1</AUTOCOST>
  <LOCNCODE>GENERAL</LOCNCODE>
  <POLNENUM>16384</POLNENUM>
  <receiptdate>09/01/2008</receiptdate>
  </taPopRcptLineInsert>
  </taPopRcptLineInsert_Items>
  <taPopRcptMultiBin_Items xsi:nil="true" />
- <taPopRcptLineTaxInsert_Items>
- <taPopRcptLineTaxInsert>
  <VENDORID>TEST VENDOR ID</VENDORID>
  <POPRCTNM>RCT00000000011960</POPRCTNM>
  <TAXDTLID>TEST TAX</TAXDTLID>
  <TAXTYPE>0</TAXTYPE>
  <RCPTLNNM>16384</RCPTLNNM>
  </taPopRcptLineTaxInsert>
  </taPopRcptLineTaxInsert_Items>
  <taPopRctUserDefined xsi:nil="true" />
  <taPopDistribution_Items xsi:nil="true" />
  <taAnalyticsDistribution_Items xsi:nil="true" />
- <taPopRcptHdrInsert>
  <POPRCTNM>RCT00000000011960</POPRCTNM>
  <POPTYPE>1</POPTYPE>
  <VNDDOCNM>12345</VNDDOCNM>
  <receiptdate>09/01/2008</receiptdate>
  <BACHNUMB>REC09/01/2009</BACHNUMB>
  <VENDORID>TEST VENDOR ID</VENDORID>
  <AUTOCOST>1</AUTOCOST>
  <TAXSCHID>TEST TAX</TAXSCHID>
  </taPopRcptHdrInsert>
  <taMdaUpdate_Items xsi:nil="true" />
  </POPReceivingsType>
  </eConnect>
 
Thanks in advance for your help.

Dear All,

 

I have a problem uding visual studio 2005 tools for Gp with GP 10

whenever I try to add a datagrid column through the designer the whole visual studio hangs, though it works fine with normal windows applications

Any Idea ?

hi:

i develop for both dynamics GP version 9 and 10. i installed both VSTDG SDKs
and they override each other... how can i setup my system to develop for both
versions?

thanks!

Dear ALL

Dose E-connect support Manufacturing?

 

Please advice

 

 Hello All,

 

I am asking if there is a ready made tool that can flip forms and reports.

I want a tool that will do the following

 

Name : Textbox

to be changed to

Textbox : Name

 

I heard there is a ready made tool to do so instead of redeveloping each form and report.

 

Anyone going to Convergence? It'll be a great event - you should go if you can. Lots to learn, lots to see.

From Microsoft:

  • Early Registration discount date has been extended to January 21, 2009.  Save $300 by registering early, secure your favorite hotels while they are still available and take advantage of better airline rates.
  • The session catalog (containing 225 sessions) is now live on the Convergence marketing site.   
  • The Convergence Customer Excellence Awards recognize, honor and celebrate customers who have achieved outstanding success with their Microsoft solutions as well as Microsoft partners' solutions.  Customer Excellence Award nominations are now being accepted through January 20, 2009.  

Convergence 2009 New Orleans Conversation ideas:
Networking.
The Microsoft Dynamics® Convergence® 2009 New Orleans conference is an opportunity for business decision makers (BDMs) to interact with other members of the Microsoft Dynamics community. At Convergence, BDMs will meet with other decision makers, Microsoft employees, and industry experts to gain knowledge, gather business insights, and increase their understanding of Microsoft Dynamics business management solutions.
 
Gain insights.
At Convergence 2009 New Orleans, BDMs can gain insights into their Microsoft Dynamics business and learn strategies business potential for the coming year.
 
Learn how to thrive in a challenging economy.
In today’s difficult economic environment, there has never been more value in attending Convergence. This year is geared toward helping attendees leverage their Microsoft Dynamics solutions to increase visibility into operations and maximize efficiencies. Convergence attendees will get exposure to new technologies, will better understand their current business management software, and will have the insights they need to unleash their solution’s
full capabilities.
 
Visit a fun and affordable locale.
This year’s premier Microsoft Dynamics event takes place in New Orleans, a historic, entertaining, and economically friendly city, which allows for affordable travel costs. Attendees can plan for what is sure to be a memorable time without putting too much strain on the travel budget.
Additionally, BDMs will have the opportunity to:
•    Learn how to more effectively use Microsoft Dynamics solutions to easily analyze financial data and respond to changing business conditions.
•    Gain clearer understanding of reporting and process automation capabilities to more effectively forecast and manage cash flow and compliance.
•    Learn how Microsoft Dynamics solutions can give their advisors and representatives access to comprehensive client information and insight.
•    Discover new ways Microsoft Dynamics can help improve fiscal responsibility and the delivery of public services.
•    Use accurate financial tracking and reporting to boost efficiencies and improve accountability.
 
Partners can get help with planning and promotion.  
The Complete Guide to Convergence for Partners (PartnerSource access is required to access this link) is a valuable planning resource on PartnerSource.  There are tips, tools and templates to help partners create the most worthwhile Convergence experience for their company and their customers’ companies.

Sql procedure error codes returned:
Error Number = 3565  Stored Procedure tasmGetNextNoteIndex  Error Description =
Error updating SY01500 table with next note index
Node Identifier Parameters: tasmGetNextNoteIndex
Related Error Code Parameters for Node : tasmGetNextNoteIndex

Error Number = 6541  Stored Procedure taUpdateCreateCustomerRcd  Error Descripti
on = Unable to obtain the next note index
Node Identifier Parameters: taUpdateCreateCustomerRcd
CUSTNMBR = TEST
Related Error Code Parameters for Node : taUpdateCreateCustomerRcd

 

<taUpdateCreateCustomerRcd><CUSTNMBR>TEST</CUSTNMBR><CUSTNAME>Test Insert</CUSTN
AME><SHRTNAME>Test Insert</SHRTNAME><STMTNAME>Test Insert</STMTNAME><ADRSCODE>NE
WT</ADRSCODE><CNTCPRSN>ert</CNTCPRSN><ADDRESS1>wert</ADDRESS1><ADDRESS2>wet</ADD
RESS2><ADDRESS3>wet</ADDRESS3><CITY>wet</CITY><STATE>wer</STATE><PRSTADCD>NEWT</
PRSTADCD><PRBTADCD>NEWT</PRBTADCD><STADDRCD>NEWT</STADDRCD><CCRDXPDT>1900-01-01T
00:00:00</CCRDXPDT></taUpdateCreateCustomerRcd>Exception

This is the XML document sended to the eConnObject.eConnect_EntryPoint!
 
<?xml version="1.0"?><eConnect xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
<RMCustomerMasterType>
<eConnectProcessInfo xsi:nil="true" />
<taRequesterTrxDisabler_Items xsi:nil="true" />
<taUpdateCreateCustomerRcd>
<CUSTNMBR>TEST</CUSTNMBR>
<CUSTNAME>Test Insert</CUSTNAME>
<SHRTNAME>Test Insert</SHRTNAME>
<STMTNAME>Test Insert</STMTNAME>
<ADRSCODE>NEWT</ADRSCODE>
<CNTCPRSN>ert</CNTCPRSN>
<ADDRESS1>wert</ADDRESS1>
<ADDRESS2>wet</ADDRESS2>
<ADDRESS3>wet</ADDRESS3>
<CITY>wet</CITY>
<STATE>wer</STATE>
<PRSTADCD>NEWT</PRSTADCD>
<PRBTADCD>NEWT</PRBTADCD>
<STADDRCD>NEWT</STADDRCD>
<CCRDXPDT>1900-01-01T00:00:00</CCRDXPDT>
</taUpdateCreateCustomerRcd>
<taCreateCustomerAddress_Items>
<taCreateCustomerAddress>
<CUSTNMBR>TEST</CUSTNMBR>
<ADRSCODE>NEWT</ADRSCODE>
<CNTCPRSN>ert</CNTCPRSN>
<ADDRESS1>wert</ADDRESS1>
<ADDRESS2>wet</ADDRESS2>
<ADDRESS3>wet</ADDRESS3>
<CITY>wet</CITY>
<STATE>wer</STATE>
</taCreateCustomerAddress>
</taCreateCustomerAddress_Items>
<taCreateParentID xsi:nil="true" />
<taParentIDChild_Items xsi:nil="true" />
</RMCustomerMasterType>
</eConnect>
Thanks before hand

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

 I'm importing PA projects using eConnect 10 and have an unusual circumstance where the client uses GL accounts where not all segments are used completely, and where some accounts segments are left blank.  GP certainly supports this via the UI, but I've never had to deal with this using eConnect and now that I'm getting errors trying I'm wondering if it is possible, or if there is a trick to doing it.

 

 Some examples:

1200-1-123456-123  (full account)

1800-1-123456-___ (last segment blank)

1800-_-______-____ (3 segments blank)

 4000-1-1_____-___ (3rd segment partially used,  4th segment blank)

 

So far I've tried sending the full account string using spaces and dashes to fill out the string, like:

 "4000-1-1     -   "

And I've also tried eliminating the spaces:

"4000-1-1-"

And tried eliminating the trailing dash:

"4000-1-1"

For kicks, I even tried eliminating the dashes:

"400011"

 

All of these generate the same error:

Error Number = 4980  Stored Procedure taPAAccountsSetup  Error Description = Account number string does not exist
Node Identifier Parameters: taPAAccountsSetup            
                      

 

Anyone ever used eConnect to  import these type of "partial" account number strings?

 [:^)]

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