Back in the distant past when Great Plains Dynamics only ran on Ctree and Btrieve (which became Pervasive.SQL), accessing raw data was extremely difficult.  There were ODBC drivers, but they were difficult to use (Btrieve required DDF files generated and Ctree was read-only).

Then a tool call DBrowser was created. This tool used DDE (Dynamic Data Exchange) to log into a running Dynamics application session and read the list of tables from the Dexterity dictionary and then make the contents of each table visible.  It was read-only but at least we could now see the contents of the data files.  This was a huge advance for developers, who previously had not been able to easily confirm their code was writing the data they expected.

Then i…

I used to hear that Microsoft developed a tool the auto posts Dynamics GP transactions, but I never saw anything like this, few days ago I needed such tool to fulfill an automatic integration requested by one of my clients.

The integration uses eConnect to integrate GP forms, and the customer wanted to auto post the transactions to eliminate human interaction, where I started my researches and found a tool with Microsoft that fulfill this request, its a tool developed using Continuum API to post GP transactions, but unfortunately I couldn’t…

Due to compatibility issues between your installed frameworks and related SP’s, you might need to remove one of the installed versions, which sometimes couldn’t be removed as some applications still using it, to…