Archives

 

 hi
i have the following problem whit numeric data while integrating with econnect
the following node which is generated by the serialization class

<UNITPRCE>316.02</UNITPRCE>

is understood as 31602 in dynamics GP i guess that the cause is that i'm
using spanish languaje in sql.

i've been reading in the web that the period is a standard decimal separator for xml files

the workaround i found is to replace "." with "," in the xml, but i find it
not a quite good solution moreover if you have many numeric fields.

is there any good solution for this?

thanks.

I get asked lots of questions about SEO (search engine optimization). Here are a few good resources:

http://www.ssw.com.au/SSW/Standards/Rules/RulesToBetterGoogleRankings.aspx

 

http://www.marketposition.com/blog/archives/2006/04/how_urls_can_af.html

 

 

This code shows how to make a field a 'required field' in VS Tools

The following code uses a ValidateBeforeOriginal event on the SaveRecord field instead of on the Save button. The SaveRecord field is selected because the SaveRecord event is called by the Customer Maintenance window from multiple locations. The SaveRecord event is always invoked when you save a record in this window.

 

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

Tax table detail does not equal the tax amount error in a SOP transaction that includes manual taxes and distributions.

 

Hi,

 Im doing a customization in GP9 GL Transaction Entry window using Visual toolkit - enabling/disabling the CurrencyID field.

it just dont respond to the disable property. This is also true for Void button which I end up using the hide/show property.

 Please can someone help me or explain why or whats causing this behavior.

 

Thanks

 

Sheryl 

 

This is actually a VBA error, not VS Tools, but I ran across it and didn't want to lose it. Not suprisingly, David Musgrave provided the answer.

Method 'CreateADOConnection' of object 'DUserInfo' failed

I have upgraded a client from GP9 to GP10 and have replaced
retrieveglobals9.dll with UserInfoGet in the VBA code.  This works 100% when
logging in using the user 'sa' but give the following error when logging in
using any other user :-

Method 'CreateADOConnection' of object 'DUserInfo' failed

Below is the code I am using :-

Dim cnn as new ADODB.connection
Dim cmd as new ADODB.command
Set cnn = UserInfoGet.CreateADOConnection
cnn.DefaultDatabase = UserInfoGet.InterCompanyID
cmd.ActiveConnection = cnn

Please could anybody give me advice on what to do?

Thanks a lot

 

  

 

Dear All,

How are you? Hope you all doing alright..I have a small question regarding getting the user information of a currently logged in user in GP using Visual Studio. I found a thread in this forum stating that the use of Visual Studio Tools For GP will do the job since the use of "RetrieveGlobals.dll" won't work with GP 10. I downloaded VS Tools for GP but when I try to install it gives me an error msg saying that I dont have the .Net Framework 2.0 installed on my machine, But actully I do..However, I'll try install the Visual Studio 2005 SP1 and give it a shot again, hopefully it will work. So, any help or guidance would be greatly appreciated. Thanks for your attention.

Regards,

Yaser Mansour

 Hi,

kindly how can i access  analytical accounting tables using addin tools, i already have the dll files in my solutions(application.dynamics)

when i try one of those

1-Microsoft.Dexterity.Applications.Dynamics.Tables

2-Dynamics.Forms

 i can not find the tables (AAG00400  aatrxdimmstr  , AAG00401  aatrxdimcodesetp) 

 

 


Is there really no Posting Date property in taRMTransaction? 

 That seems really strange (since taPMTransaction has it), and would be mighty inconvenient.  I need to insert an AR invoice with different document date and posting dates.

Am I missing something?

Hi,

I am getting the below error when connecting to the  microsoft.greatplains.econnect :

 

Sql procedure error codes returned:
Error Number = 306  Stored Procedure taPMTransactionInsert  Error Description = Voucher Number (VCHNUMWK) already exists in PM Keys Master Table - PM00400
Node Identifier Parameters: taPMTransactionInsert                             
BACHNUMB = 461
VCHNUMWK = 7               
VENDORID = 461
DOCNUMBR = 144
DOCTYPE = 1
DOCDATE = 10/13/2008


<taPMTransactionInsert>
<BACHNUMB>461</BACHNUMB>
<VCHNUMWK>7                </VCHNUMWK>
<VENDORID>461</VENDORID>
<DOCNUMBR>144</DOCNUMBR>
<DOCDATE>10/13/2008</DOCDATE>
<DOCTYPE>1</DOCTYPE>
<DOCAMNT>16.66</DOCAMNT>
<PRCHAMNT>16.66</PRCHAMNT>
<CHRGAMNT>16.66</CHRGAMNT>
<TRXDSCRN>CROSSROADS HOSPITALITY CO</TRXDSCRN>
<CREATEDIST>0</CREATEDIST>
</taPMTransactionInsert>

Please help me out in this issue. 

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

Hi,

I am getting the below error when connecting to the econnect version 8.0 

 

Sql procedure error codes returned:
Error Number = 2516  Stored Procedure taPAPOReceiveInvoiceEntryLine  Error Description = Cost Category (PACOSTCATID) is not setup for this Project Number (PAPROJNUMBER)
Node Identifier Parameters: taPAPOReceiveInvoiceEntryLine                     
PAVIDN = 1               
RCPTLNNM = 16384
Related Error Code Parameters for Node : taPAPOReceiveInvoiceEntryLine                     
PACOSTCATID = MEALS
PAPROJNUMBER = 461-101708


Error Number = 2574  Stored Procedure taPAPOReceiveInvoiceEntryLine  Error Description = Invalid Purchase Item Taxable status (PAPurchase_Tax_Options) - (1=Taxable,2=Nontaxable,3=Base on Vendor)
Node Identifier Parameters: taPAPOReceiveInvoiceEntryLine                     
PAVIDN = 1               
RCPTLNNM = 16384
Related Error Code Parameters for Node : taPAPOReceiveInvoiceEntryLine                     
PAPurchase_Tax_Options =  Note: This parameter was not passed in, no value for the parameter will be returned.


Error Number = 3521  Stored Procedure taPAPOReceiveInvoiceEntryLine  Error Description = Invalid Inventory Account Index (INVINDX)
Node Identifier Parameters: taPAPOReceiveInvoiceEntryLine                     
PAVIDN = 1               
RCPTLNNM = 16384
Related Error Code Parameters for Node : taPAPOReceiveInvoiceEntryLine                     
INVINDX =  Note: This parameter was not passed in, no value for the parameter will be returned.


<taPAPOReceiveInvoiceEntryLine>
<POPTYPE>3</POPTYPE>
<PAVIDN>1                </PAVIDN>
<RCPTLNNM>16384</RCPTLNNM>
<PAPROJNUMBER>461-101708</PAPROJNUMBER>
<PACOSTCATID>MEALS</PACOSTCATID>
<VENDORID>461</VENDORID>
<ITEMNMBR>MEALS</ITEMNMBR>
<VNDITNUM>MEALS</VNDITNUM>
<ITEMDESC>MEALS</ITEMDESC>
<VNDITDSC>MEALS</VNDITDSC>
<LOCNCODE>TBM</LOCNCODE>
<NONINVEN>1</NONINVEN>
<QTYSHPPD>1</QTYSHPPD>
<QTYINVCD>1</QTYINVCD>
</taPAPOReceiveInvoiceEntryLine>

 

Please help me out on this 

Dear All

I am facing a problem with “Receivables transaction entry” and “Receivables Case Entry” screens

If a user creates, a document and then he/she save this document.

Then the user reopen the “Receivables transaction entry” screen and open the document, then in the field CASH he/she set the value to Zero.

Then the “Cash Receipt Number” in the “Receivables Case Entry” screen is taken to be the “Next Number” in the “Receivables Management Setup” screen.

Which is very wrong because this number may be added by the user for example:

1.       3000

2.       80

3.       Etc…

Mean while the default number is PYMNT000000000000001 and incremented for every documents.

How can I solve this issue and how can I know the tables used for this issue.

Please I need help.

Thank you,

 

I'm a c# developer and wish to start playing with econnect for GP.   Where can I download the .net assemblies for visual studio 2005 for GP econnect? 

 TIA

Gi

We have certain orders from our website that we wish do download as Orders. I am working on writing a VB program that will transfer these orders to invoices once the payment has been completed. I have all of my logic written as far as which orders are supposed to be transferred, etc. but am having trouble finding the eConnect code that will actually do the transferring part of the program. If anyone could point me in the right direction, I would really appreciate it. Even just a starting point would be great. Ashley
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