Often, we install Visual Studio (latest) on a client's server, and the older version of the Dynamics GP SDK didn't install the templates for my version of Visual Studio. What to do?

Migrate them. Where are the Visual Studio templates stored?

This article will list where the files are for each version, so that you'll know how to migrate between versions. 


A client has reported that someone is entering a setup form and editing something as the 'sa' user, and asked if there is any way to track it. 

I'd be interested if your approach would have been different than mine, feel free to chime in.

The script below will email every time a user logs on as the 'sa' user and report the machine name that they logged in from


This piece of code is a 'proof of concept for a larger project, the completed project will grab images from the clipboard using ASP.NET (think: POs, Credit apps, signed delivery tickets) and save them. 

This code saves to the file system (on the client, not the web server), but the production code will save to a SQL table. 


This is the home page for our free Send eConnect application. 

Currently it is in beta, we'd love for you to download and test. Can we make a change to have it work for you?

In a nutshell, you paste in an eConnect document and click 'Process' and the document attempts an integration. 


I am getting an error while saving a Sales Order through EConnect and trying to track down what it means. the first one is just the lots that have already been allocated that I am gonna delete prior to the save. its the second one that i keep trying to duplicate. Everything seems to match up, and we dont even use the sop10101 table.




Error: Unable to update amount remaining on the invoice

Want to apply a $7,888 credit memo to a $78,900 invoice that I applied $10 previously now I want to apply $100.

Using GP2016(R2)


Input parameters:


Exception type:



Exception message:

Sql procedure error codes returned:


Error Number = 670  Stored Procedure= taRMApply  Error Description = Payment/Return is already applied to the invoice












Stack Trace:

   at Microsoft.Dynamics.GP.eConnect.ServiceProxy.CreateEntity(String connectionString, String xml)

   at Microsoft.Dynamics.GP.eConnect.eConnectMethods.EntityImportImplementation(String connectionString, String sXML, Boolean isTransaction)

   at Microsoft.Dynamics.GP.eConnect.eConnectMethods.ProcessEntityImport(String connectionString, String sXML, Boolean isTransaction)

   at Microsoft.Dynamics.GP.eConnect.eConnectMethods.CreateEntity(String connectionString, String sXML)


Event Xml:

<Event xmlns="">


    <Provider Name="Microsoft.Dynamics.GP.eConnect" />

    <EventID Qualifiers="0">0</EventID>




    <TimeCreated SystemTime="2017-10-12T19:26:02.377539200Z" />




    <Security />





I have an invoice in EURO, payment was made in USD [Functional currency]. I can't seem to apply and write off Gain/Loss on the same screen

Any help would be appreciated



Error: Unable to insert duplicate Manual Check Keys record in the Payroll Keys Table - UPR10309

Error Number = 5370  Stored Procedure= taCreateManualCheckLineInsert  Error Description = Unable to insert duplicate Manual Check Keys record in the Payroll Keys Table - UPR10309
Node Identifier Parameters: taCreateManualCheckLineInsert
PYADNMBR = 900049
EMPLOYID = 07052

Trying to troubleshoot error from smartconnect map - any guidance would be awesome.

We had an unposted batch that was accidentally deleted.

Although we had backups of the  database before the deletion, when I gave the affected user the info from RM20101 she said these entries had been posted the month before.     What table would I want to give her unposted data?


Hi all,

our crappy gp parter did a report for us, which is Received But Not Invoiced report.   What they failed to do was include the exchange rate calculation method (divide or multiply) in the SSRS report, so now we have a bunch of entries that aren't calculating the exchange rate correctly.  And, since we have historical data in there now, this cannot be changed.

So I found the appropriate tables in the Dynamics database, but I have no idea how to join in a table to a report (or query) that comes from two different databases.   The only thing I can think of is to create a DataMart database (maybe in Access -- yuck), that can pull from two different data sources. 

Can anyone think of a cleaner method to do this?  All  I need is the flag for RTCLCMTD from the table MC40300 to make the report right.  Maybe Management Reporter can do this?



hi all,

so I have been diving into some of these stored procs and reports.  the thing that always gets me is that we have to constantly union join in history and working tables to get results that we expect.   we all know this is a throwback to Great Pains of old, where 8 character table names and 8 character field names were common in those days....who didn't love DOS?  but i'm sure memory constraints and all that made this necessary.

so what if I was to create a query that combined the history and working into a view or stored proc, and then just joining to that for reporting purposes?  is this something that would help clean up all those joins? 



Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables