Archives

 

Hi

I installed eConnect10 runtime ,i am not able to see the details in the c:Program files\Common Files\Microsoft Shared\eConnect10 folder .i could see  object,Release information,Requester Setup folders in the eConnect 10 folder.There is no XML Schemas,Services, eConnect Samples etc folders in the eConnect 10 folder.

I already have eConnect 9.0 in my system. Will this effect new instal

 

Hi

Can we use eConnect9.0 in GP10.0 install

if posible what are the modification we have to Do?.if not what is the limitation with this

Thanks

Roshan

 

Server was unable to process request. ---> Sql procedure error codes returned:
Error Number = 235  Stored Procedure taSopHdrIvcInsert  Error Description = Document amount does not equal (Subtotal+Freight+Misc+TaxAmt+FreightTax+MiscTax-TradeDisc)
Node Identifier Parameters: taSopHdrIvcInsert                                 
SOPNUMBE = STD00440275     
SOPTYPE = 2
Related Error Code Parameters for Node : taSopHdrIvcInsert                                 
SUBTOTAL = 1779.75
FREIGHT =  Note: This parameter was not passed in, no value for the parameter will be returned.
MISCAMNT =  Note: This parameter was not passed in, no value for the parameter will be returned.
TAXAMNT =  Note: This parameter was not passed in, no value for the parameter will be returned.
FRTTXAMT =  Note: This parameter was not passed in, no value for the parameter will be returned.
MSCTXAMT =  Note: This parameter was not passed in, no value for the parameter will be returned.
TRDISAMT = 0
DOCAMNT =  Note: This parameter was not passed in, no value for the parameter will be returned.

<taSopHdrIvcInsert><SOPTYPE>2</SOPTYPE><DOCID>STDORD         </DOCID>

<SOPNUMBE>STD00440275      </SOPNUMBE><LOCNCODE>001        </LOCNCODE><DOCDATE>7/3/2009</DOCDATE><TRDISAMT>0</TRDISAMT><CUSTNMBR>13498</CUSTNMBR>

<SUBTOTAL>1779.75</SUBTOTAL><BACHNUMB>GPI07032009</BACHNUMB><PRBTADCD>PRIMARY        </PRBTADCD><PRSTADCD>134980305112124</PRSTADCD><CREATETAXES>1</CREATETAXES>

<ReqShipDate>8/1/2009</ReqShipDate></taSopHdrIvcInsert>
<eConnect xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
  <SOPTransactionType>
    <eConnectProcessInfo xsi:nil="true" />
    <taRequesterTrxDisabler_Items xsi:nil="true" />
    <taUpdateCreateItemRcd xsi:nil="true" />
    <taUpdateCreateCustomerRcd xsi:nil="true" />
    <taCreateCustomerAddress_Items xsi:nil="true" />
    <taSopSerial_Items xsi:nil="true" />
    <taSopLotAuto_Items xsi:nil="true" />
    <taSopLineIvcInsert_Items>
      <taSopLineIvcInsert>
        <SOPTYPE>2</SOPTYPE>
        <SOPNUMBE>STD00440275      </SOPNUMBE>
        <CUSTNMBR>13498</CUSTNMBR>
        <DOCDATE>7/3/2009</DOCDATE>
        <ITEMNMBR>GENSH~TESTPROD~MS              </ITEMNMBR>
        <UNITPRCE>177.975</UNITPRCE>
        <XTNDPRCE>1779.75</XTNDPRCE>
        <QUANTITY>10</QUANTITY>
        <MRKDNAMT>0</MRKDNAMT>
        <UOFM>Cube     </UOFM>
      </taSopLineIvcInsert>
    </taSopLineIvcInsert_Items>
    <taSopLineIvcInsertComponent_Items xsi:nil="true" />
    <taSopTrackingNum_Items xsi:nil="true" />
    <taSopCommissions_Items xsi:nil="true" />
    <taSopLineIvcTaxInsert_Items xsi:nil="true" />
    <taCreateSopPaymentInsertRecord_Items xsi:nil="true" />
    <taSopUserDefined xsi:nil="true" />
    <taSopDistribution_Items xsi:nil="true" />
    <taAnalyticsDistribution_Items xsi:nil="true" />
    <taSopMultiBin_Items xsi:nil="true" />
    <taSopHdrIvcInsert>
      <SOPTYPE>2</SOPTYPE>
      <DOCID>STDORD         </DOCID>
      <SOPNUMBE>STD00440275      </SOPNUMBE>
      <LOCNCODE>001        </LOCNCODE>
      <DOCDATE>7/3/2009</DOCDATE>
      <TRDISAMT>0</TRDISAMT>
      <CUSTNMBR>13498</CUSTNMBR>
      <SUBTOTAL>1779.75</SUBTOTAL>
      <BACHNUMB>GPI07032009</BACHNUMB>
      <PRBTADCD>PRIMARY        </PRBTADCD>
      <PRSTADCD>134980305112124</PRSTADCD>
      <CREATETAXES>1</CREATETAXES>
      <ReqShipDate>8/1/2009</ReqShipDate>
    </taSopHdrIvcInsert>
    <taSopToPopLink xsi:nil="true" />
    <taSopUpdateCreateProcessHold xsi:nil="true" />
    <taCreateSOPTrackingInfo xsi:nil="true" />
    <taMdaUpdate_Items xsi:nil="true" />
  </SOPTransactionType>
</eConnect>

Hi ,

How we can Install eConnect10 in the Named Instance In my PC I have 3 Servers for GP10.While Installing eConnect9.0 eConnect installer will ask for the connection String After Giving this connection String It will install in the Respective Database.But in the eConnect10 install we are not Providing any Connection String .So please let me know how we can do It?

 

Thanks

Roshan

Is it possible to create new GL Accounts using eConnect?  If so which eConnect SP does the trick?

 

Thanks

Hi

i am getting error Message "Error converting data type char to numeric" while integrating with GP using PM Integration Please help me to solve this.

Thanks

Roshan

I am a complete newbie at E-Connect and I am trying to take Invoices & Credit Memos from our existing web based system and trying to get them into e-connect. For those of you with more experience, what Classes do I need use to create the Document that I submit to E-Connect ?? Also, and code examples in VB or c# to get me pointed in the right direction.. many Thanks. - Douglas

Error -214189155: Failed to open the connection.
Details: [Database Vendor Code: 4060]

Error - 2147189176: Login failed.
Details: [Database Vendor Code: 18456]
bad login

Both these errors came when trying to set up a Dynamics Report Manager (DRM) report. I needed to give the user that I was using access to the database.

 Edit 1/30/2013:

Added an additional error resolution for this error:

Dear AllI am working with GP 10 SP3 and eConnect.
I make the Sales Invoice with eConnect.
Everything is working fine.
But we notice that there are many errors in some Items Stocks/Quantities
So I am asking is there any probability that eConnect is making these problems.
FYI: I am working with SP1.

 

Please advise me.

 

I occasionally have to set up reports using Rockton Software's Dynamics Report Manager, and I want to be consistant across the reports in the settings that I use.

So, this is not meant as a walk through for their product, but more of a cheat sheet for me when I have to set up a new one. It's a great product, I'm very happy with how it works. The support is good, too.

There are two basic tasks, create the Report and create the Launch Point.

To start, open the DRM Report Explorer from the toolbar and click on New Report

Is there a way to catch eConnect exceptions before the eConnect call to the GP?  Maybe through pre stored procedure?

The problem I am running into is when the end user click the "integrate" button on the UI, eConnect goes through the business logic and checks the source data with GP setups.  If the Integration fails it throws an error which is far from what exactly happened.  The real error is logged in the event viewwe but the end user cannot see it. 

Anyone know the best practice to accomplish this?

 

Thanks 

 

 

Hi All,

I have an requirement to create invoivce in GP 9.0  using econnect
data should be pulled from oracle database and should be posted to GP 9.0 database

I an new to GP and i was not sure weither i should write an web service or an we application to do this work
any help is really Appreciated

 

 

 

 

Hello, Is there any way we can remove the menu item that we added using the 'AddMenuHandler' function of the formproxy? I have a requirement that has to refresh the menu items when the user switches companies. Any pointers, ideas would be very helpful. thanks in advance.

In the GP9 SOP Transaction Entry form, I need to run some code when the user saves the form. In GP10 there are explicit Save and Change events that you can trap, but I'm not seeing that in 9.

Anyone have a suggestion?

I am using the "taUpdateCreateAccountRcd" and it works great if I import each GL Account and then loop back for 2nd, 3rd, 4th ......

I am trying to change this logic and create one XML file for all the GL Accounts and then call the eConnect method to create new accounts.  For this reason I am using the array to store all the required fields.  But I am running into an error with the GLAccountType node  "Value of Type 1-Dimensional array of Microsoft.Dynamics.eConnect.Serialization.taUpdateCreateAccountRcd cannot be converted to Microsoft.Dynamics.eConnect.Serialization.taUpdateCreateAccountRcd "

Any suggestions?

 

 

Thanks

 

 

 

I am running into a dilemma.  I am using eConnect with integrated security and have the UI and eConnect Call method all in the same code.  This requires the user running the eConnect UI Interface to have integrated security on the domain as well as be part of the GP SQL Server.  I know there is also an option to create a Windows or Web Service.  This way you use a single domain account to call the eConnect method based on a specific folder on the server.  This way your eConnect UI is separate then the importing of XML file into GP.My IT department thinks there are risks associated with option #1 b/c users become part of the GP SQL Server.  If I use option #2  (using Windows or Web Service), how do I capture eConnect exceptions?  With a number of calls being made to eConnect using the service, how does one isolate errors and send them back to the eConnect UI (end user).Any thoughts?

 

Thanks

 

A functional currency does not exist for this company. Transactions cannot be entered

This is a common error that needs to be dealt with for most all Dynamics installs.

Here is the fix in GP10

When the job is simple, I'll usually just do it in VBA.

Here's a handy piece of code that demonstrates data access from Dynamics. It shows how to use USERINFOGET

We're upgrading here to econnect 10, and yesterday I got an error about to many decimals in a trx amount.  I rounded the 5 decimals to 4 and it worked.  I thought it was an econnect 10 thing but this morning our production econnect 9 box had the same error when sending it an invoice.  I rounded the numbers and it was accepted fine.  Later today I fired up testing the econnect 10 stuff again and the same error came back, this time I'm rounding to 2 decimal places and don't want to go smaller.  What is the deal?  The exect error message is posted below.  Any help please??

 

 - Sql procedure error codes returned:  Error Number = 7020  Stored Procedure taRMTransaction 

Error Description = One of the trx amounts has too many decimal places  Node Identifier Parameters: taRMTransaction                                     

Related Error Code Parameters for Node : taRMTransaction                                         

<taRMTransaction>
  <RMDTYPAL>1</RMDTYPAL>
  <DOCNUMBR>23432343</DOCNUMBR>
  <DOCDATE>07-30-2009</DOCDATE>
  <BACHNUMB>BAT20090500001151239</BACHNUMB>
  <CUSTNMBR>123445</CUSTNMBR>
  <DOCAMNT>127.26</DOCAMNT>
  <SLSAMNT>112.72</SLSAMNT>
  <FRTAMNT>14.54</FRTAMNT>
  <LSTUSRED>239</LSTUSRED>
</taRMTransaction>

I've seen this twice now, the differences are very small so read the error message carefully:

Unable to cast:

The current build operation (build key Build Key[Microsoft.Practices.EnterpriseLibrary.Data.Database, LSBC]) failed: Unable to cast object of type 'Microsoft.Practices.EnterpriseLibrary.Data.Configuration.DatabaseSettings' to type 'Microsoft.Practices.EnterpriseLibrary.Data.Configuration.DatabaseSettings'. (Strategy type ConfiguredObjectStrategy, index 2)

Type initializer failed:

The current build operation (build key Build Key[Microsoft.Practices.EnterpriseLibrary.Data.Database, LSBC]) failed: The type initializer for  'Microsoft.Practices.EnterpriseLibrary.Data.Database' threw an exception. (Strategy type ConfiguredObjectStrategy, index 2)

 

So I'm almost a complete noob when it comes to econnect and I am hoping the question I'm about to ask will be a simple one. Here it goes....

I am using C# with econnect to insert timesheets. Most of the timesheets post correctly. Occasionally I get this error:

Error Number = 1233  Stored Procedure taPATimeSheetLineInsert  Error Description = PA WIP IDX Account does not have access to Currency ID
Node Identifier Parameters: taPATimeSheetLineInsert

 I come to find out after some researching that this only happens on fixed price projects. I can enter time directly into GP on the same project but I cannot figure out why EConnect is not working with this.

Any ideas?

I am using GP 9. Let me know if you need anything else.

 

Thanks in advance

 

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