This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
I have been working on a recent support case that had a situation that makes me want to raise this topic again.
ADO
Failed eConnect document leaves orphaned records
This is a reposting of an article Patrick Roth originally wrote on my Developing for Dynamics GP blog.
I assisted on an eConnect incident today that was quite interesting and I thought I’d share the case and the solution.
Dynamics Report Writer is the Best Report Writer in the World cont.
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
This is a follow up post to my earlier post, which demonstrated how Report Writer when combined with the power of Visual Basic for Applications (VBA) was able to create a customisation that would not have been possible with Report Writer alone.
Dynamics Report Writer is the Best Report Writer in the World
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
Alright, maybe I am stretching the truth a little, but I do get frustrated when people discount the Dynamics Report Writer as a useful tool. [Edit] I am not biased at all…. honest.
Removing Extender Data when deleting Transactions or Lines
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
I was recently asked to assist a colleague with an Extender case. The problem was that Extender data was not being removed from the Extender SQL tables when its parent record was deleted.
VBA – Determining the company name selected in the Company Login window
This is a reposting of an article Patrick Roth originally wrote on my Developing for Dynamics GP blog.
A question came up a while back where the user wanted to know what company the user was logging into in order to give them a message depending on the company selected.
RW – Showing the Full Item Description on Invoices Example
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
When the inventory module of Microsoft Dynamics GP was first written the Item Description field was 60 characters long. A few versions ago it was extended to 100 characters.
RW – Can I print Page Numbers including the Total Number of Pages?
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
The question in more detail is whether it is possible to print “Page: Y/X” or “Page: Y of X” on a Report Writer report, where Y is the current page number and X is the total number of pages for the report.
Modifier – Reading and Writing Data with ADO Example
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
It has been a while since I posted some example code, so here is one which demonstrates how to write back data using ADO.
Using ADO with VBA with Report Writer
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
As a follow on to the Using VBA with Report Writer post, I would like to discuss using ActiveX Data Objects to access data from SQL Server while using the Report Writer.
Using VBA with Report Writer
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
Most people are aware that you can use Visual Basic for Applications (VBA) with Microsoft Dynamics GP forms and the Modifier, but not everyone is aware that VBA can be used with the Report Writer as well.
Why does Microsoft Dynamics GP encrypt passwords?
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
Why doesn’t the password I use for Microsoft Dynamics GP work for me to access the data in SQL from <insert application name here>?
Why does my password sometimes fail to work from one workstation when it works from another?
Why does the password policy feature only allow one failed attempt before locking me out?
Why is the User ID case sensitive on Microsoft Dynamics GP v10.00?
What is the Password field in the SY_Users_MSTR (SY01400) table used for?
Can I use my Windows or Active Directory Login to access Microsoft Dynamics GP?
I hope to answer all these questions and more by explaining the password encryption that is used by Microsoft Dynamics GP for all users except ‘sa’.
Modifier – Adding a field to a scrolling window using ADO Example
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
The following VBA example adds the Sales Order Processing User Defined 3 field onto the Receivables Transaction Inquiry window.
Modifying Reports which use Temporary Tables
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
I often get told that it is impossible to customize a report which uses a temporary table, and in particular a temporary table which uses single fields for multiple purposes. While I admit that these reports are more challenging to customize they are far from impossible.
RW – Accessing any SQL data from a Report Example
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
The following Report Writer and VBA example demonstrates how data from any SQL table can pulled into a report regardless of the product the table is related to. This technique can also be used when it is not possible to create the table relationship needed to add the report in the Report Writer. It works as long as you can create a query that will uniquely select the data you need based on the data on the report or from the already linked tables.
RW – Accessing any SQL data from a Report Example
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
The following Report Writer and VBA example demonstrates how data from any SQL table can pulled into a report regardless of the product the table is related to. This technique can also be used when it is not possible to create the table relationship needed to add the report in the Report Writer. It works as long as you can create a query that will uniquely select the data you need based on the data on the report or from the already linked tables.
Winthrop Development Consultants Blog 