This error seems to just pop up now and again. It is not restricted to a single table and even happens on tables it just created. Anybody else see this weird behavior? [Edit w/solution] It turns out that this query is used to determine if the table exists. Apparently it is much quicker to query an invalid column than just check for a...
Hello, I can't find much information around the web about it. Has anyone used both eConnect and the Dynamics web services to interact (read/write) with Great Plains. I am looking for the pros and cons of both approaches. This product will be installed and configured on various sites, so ease of configuration is really important. I usua...
I have an issue occurring in Microsoft Dynamics GP, and am doing research to see if this is the cause,but this could be a Access to SQL Server issue. GP stores data in SQL Server, and MS Access is being used to access the table data. Some data appears to be going missing in the production database. Unfortunately, I don't know what is bei...
Hello, Simply trying to create via eConnect the EFT Bank informations on a customer. You go inside a customer - > address - > EFT Bank. I cannot find any informations in the eConnect documentation or on the web of the correct method to use. Trying my chance here. Thanks! ...
Hi there, I am coding in ASP.NET C#. I have Microsoft Dynamics GP hosted at a server and my database hosted at another server. I would like the GP database take value from some table there and synchronise it with my database. Which is the best alternative? Data transmission Service(DTS)? ...
Hi all, I am not able to install GP 10.0 in my system, pls somebody help me with the steps how can i install GP 10.0 in my system. I have windows XP service pack 2 OS. Going to work with GP 10.0 with SQL 2000 Database. I will be really appreciate if somebody help me with installation steps of GP 10.0 and SQL 2000. I am really fed up with...
Hi all, Problem with filtering Dropdown list. The scenario is : in scroll window there are two fields Document types and type id: Document type is Dropdown list: As per document type selection type id look should display the values. For ex. If I select quote type from document type and if I open type id look up it should display on...
We use webservices to integrate our Dynamics CRM 4.0 with GP 10.0. We do alot of integration using GP webservices like creating invoices, customers and vendors. However, we just faced a problem. We need to use the web services to add some notes to the invoice. I have searched a lot but couldn't find a way to do so. Can anybody guide me ...