This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
I have seen this issue come up a number of times. Trying to automate processes which involve reports and wanting to automate the Report Destination window. Sometimes you can add the Report Destination to Visual Basic for Applications (VBA) and sometimes the system will not add the window to VBA. This post will explain the reason for this “weird” behavior.
This is a reposting of an article Patrick Roth originally wrote on my Developing for Dynamics GP blog.
Trivia question for today:
Given the following sequence of events:
In Microsoft Dynamics GP, in a control field such as Customer Number, the user types in “AARON”. The user then presses the associated lookup button.
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
In the past, I was known for my pioneering work with and promotion of Cross Dictionary Dexterity Development. More recently I have been talking up the benefits of Hybrid Development and Developing Outside of the Box.
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
I was recently asked how can you total a field in a report when that field is in a conditionally suppressed section. You might ask why should this be difficult. The reason for the complexity is this….
Suppressing a section just stops it being displayed at the last moment and does not exclude the section from other processing by the report writer.
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
When you use Integration Manager on a system with Analytical Accounting (AA) installed, integrations often fail because Analytical Accounting will open windows which are unhandled by Integration Manager. However, there are time when you still want to use Integration Manager to import transactions where the Analytical Accounting information is left blank. This post provides three methods of how to make Integration Manager work when Analytical Accounting is installed.
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
My colleague asked me for assistance with a Visual Basic for Applications (VBA) case yesterday.
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
In a recent forum post, the question of where the business logic for Dynamics GP resides was raised. This is an excellent question which, sadly, does not have a simple answer.
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
One of the customisations that I have heard requests for a number of times is to open the General Ledger Journal Entry (GL Transaction Entry) window’s scrolling window (grid) to its expanded state when the window is opened.
This is a reposting of an article Patrick Roth originally wrote on my Developing for Dynamics GP blog.
With password policies in place in Dynamics 10.0 RTM, it was easy to be able for your user to ‘lock themselves out’ after a mistyped password or two.
Because Dynamics GP doesn’t give you any kind of warning that the Caps Lock key is enabled, the user wouldn’t necessarily notice this is the real issue and not a typo and all of a sudden you are locked out.
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
Michael Johnson (the MBS Guru) has posted a great article about removing invalid references from a Visual Basic for Applications (VBA) project. This has prompted me to revisit the topic and gather together all the relevant resources from a number of blog authors.
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
Over the years that I have worked with Microsoft Dynamics GP, there are been a few occasions where we have had issues with so called “illegal” characters.
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
There is an issue with the Shift+F11 keyboard shortcut which is used by Visual Basic for Applications (VBA) to Add Fields to Visual Basic. I was asked about it again recently and so decided to post the details on the blog.
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.
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.
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
Another recent request was to provide a method to prevent backdated transactions from being entered into Microsoft Dynamics GP. This means that we needed to validate the document date of a transaction as it as entered and again when it is saved. This is a perfect opportunity to demonstrate how Visual Basic for Applications (VBA) can add custom business rules to the application.
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
The Dynamics GP Blogster, Mariano Gomez, has written a great article on the Dynamic User Object Store (DUOS).
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
Visual Basic for Applications (VBA) can use the Dynamics User Object Store (DUOS) table to store additional data such as user defined fields.
The SY_User_Object_Store (SY90000) DUOS table uses a single row for each field stored, It stores the data in a string field 132 characters long.
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
Recently I responded to a question on a newsgroup asking how to minimise a window from VBA (Visual Basic for Applications).
The short answer is that it is not possible. But just because a Microsoft Dynamics GP window VBA object does not expose any methods or properties for the window state does not mean we have to give up.
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
From the Translating Dexterity Applications Series.
The final topic in the series is one that was added later after I was asked about how to handle translated applications when writing customizations.
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
The great postings around the blogsphere just keep coming. I am not complaining as the body of knowledge they provide to community is growing all the time.
Winthrop Development Consultants Blog 