Sign Up Now!Log In



SmartConnect can be used to integrate documents into your system (I use Dynamics GP and Business Central, it works with both)

If possible, I'd like the source table to be SQL, so that I can mark the records as having succeeded or failed. 

This tutorial will detail how to use the before/after document tasks to run a SQL task. 

*** if I've not provided enough information, please leave a comment and I'll clarify it.

Example of how to use the Telerik Winforms ItemDataBound Event
I need to have a Telerik Winforms radgrid filter by using a textbox outside the grid. This code example shows how

This request operation sent to net.pipe://localhost/Microsoft/Dynamics/GP/eConnect/EntityOperations did not receive a reply within the configured timeout (00:01:00).  The time allotted to this operation may have been a portion of a longer timeout.  This may be because the service is still processing the operation or because the service was unable to send a reply message.  Please consider increasing the operation timeout (by casting the channel/proxy to IContextChannel and setting the OperationTimeout property) and ensure that the service is able to connect to the client.

Standing orders from the boss (sigh) <smiles>

"Blog every error that you get"

So, here goes: I was adding a company to an existing client and got the error above. eConnect did a 30 second timeout and returned this message.





So, the deal is this: I'm developing for a phone, and I need the real estate. I need to get rid of this column. Here's how. 

There's no good native control that displays a hyperlink and behaves like a button... so I'll generally just use the code below. 

I'm coding a SmartConnect integration, I'm trying to write the error back to the source table using a SQL task, but the GlobalLastError variable is blank. 

This article describes the workaround. 

If your GlobalLastError has single quotes in it, you won't be able to (easily) save it back to the source table with SQL

This article describes the work around. 

Discerning viewers will note that this is the exact same piece of code as the previous article (smiles)

I need two articles because they're different problems and I need to put them on the SmartConnect menu. Sorry for the spam. 

Today I opened SmartConnect, and I get the message 

Could not log into the SQL Server

Login failed for user 'xxx'. Reason: The password of the account has expired.


Creating the service account for SmartConnect was an oversight... but it happened. So I went to fix it, and didn't have a record of what I had created. And, I couldn't find anyplace to reset it. 


I'm trying to integrate into Business Central using SmartConnect, and a lot of the lines are returning 

Failed to create record. Unable to call service: The Sales Header does not exist. Identification fields and values: Document Type='Quote', No=''

This article discusses this error


We are using Dynamics GP 2015, and I need to know which tables are used for the built-in smart list for Inventory Transactions.

Is there any SQL script that would highlight the difference between AP Sub Ledger and Payable account in GL? I have already tried the GL Reconciliation within GP but that didn't help.



Does anyone know the value definitions for MOPLOCKLOCATION and MOPLOCKLOCATION2?
I want to push po number, podate, vendorid,itemnmbr, qtyorder fields value push in dynamic GP purchase order  when user click save button in below screenshot.
using econnect . can you help regarding this?

I have a question regarding void date in the RM20101 (Open Transactions) Table.

When I go into GP, from "Posted Transactions", select my customer and payment, (Which brings me to the "Receivables Posted Transactions Maintenance" screen, I fill in the field "Void Date" with "January 1st, 2019", and I put "January 3rd, 2019", in the "Posting Date" field.  I then click Void.

Now, when I query the RM20101 Table for that document number, I see the "January 3rd, 2019" appearing in the "VOIDDATE" field.   And the date I entered as the void date, "January 1st, 2019" seems to be appearing in the "DINVPDOF" (Date invoice paid off field).

To make it even stranger, if go into Inquiry -> Transaction By Document, and drill down to my document, there is a field on there called "Date Voided", and it's also showing the proper date of "January 1st, 2019"  

Can anyone explain why this is behaving this way?  Why do the fields on the GP screens have a label of "VOIDDATE", but GP isn't actually storing the value in that "VOIDDATE" field in the table?