DynDeveloper.com

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. 

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. 

Hi, 

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.

Thanks

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:

Microsoft.Dynamics.GP.eConnect.eConnectException

Exception message:

Sql procedure error codes returned:

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

<taRMApply>

  <APTODCNM>SMART0032384</APTODCNM>

  <APFRDCNM>EARNFY2016-0180</APFRDCNM>

  <APPTOAMT>100</APPTOAMT>

  <APFRDCTY>7</APFRDCTY>

  <APTODCTY>1</APTODCTY>

</taRMApply>

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="http://schemas.microsoft.com/win/2004/08/events/event">

  <System>

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

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

    <Level>2</Level>

    <Task>0</Task>

    <Keywords>0x80000000000000</Keywords>

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

    <EventRecordID>112</EventRecordID>

    <Channel>eConnect</Channel>

    <Computer>BSCHRAMM-7040.usbc.lan</Computer>

    <Security />

  </System>

  <EventData>

    <Data>Action:

Create

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

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

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?

thanks,

george