Browse by Tags
All Tags » VBA ( RSS)
-
|
Another opportunity to learn the foundations of Developing for Dynamics GP is now available. Microsoft Dynamics GP's core application user interface is developed using the Dexterity development system. Knowledge of Dexterity and therefore how Dynamics...
|
-
|
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. The issue of Extender data being orphaned when the parent data...
|
-
|
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. The specific issue was that VBA cannot get the name of the company from the DDL (drop...
|
-
|
Well, it seems that things have not slowed down much over the Holiday season and that many of the blog authors in the community have been writing lots of great articles. There are a few that caught my interest, so I will highlight them below: Steve Endow...
|
-
|
I think the most customized window in VBA must be the SOP Entry window. If the customization is not saving custom data for the header/line items, then it is adding custom logic based on document type and any number of other factors. In all of this - especially...
|
-
|
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...
|
-
|
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. What happens? A. Focus moves...
|
-
|
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 . With all the tools available to...
|
-
|
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...
|
-
|
Now is your chance. If you have not attended a Dexterity Training class and are either new to Dexterity or want to get started with Dexterity, this is an opportunity that should not be missed. My good friend, Leslie Vail, will be training the 5 day Dexterity...
|
-
|
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...
|
-
|
My colleague asked me for assistance with a Visual Basic for Applications (VBA) case yesterday. The VBA code was being used to customise a report and use ActiveX Data Objects (ADO) to read a value from the SQL Server data and display it on the report...
|
-
|
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. When Great Plains Dynamics was first developed for the Ctree and Btrieve ISAM...
|
-
|
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. The method to make this...
|
-
|
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...
|
-
|
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...
|
-
|
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. While the use of these characters should work everywhere, there are times when the characters...
|
-
|
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. The issue is that Shift+F11...
|
-
|
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. While this allows for a longer description to be entered, it has created three...
|
-
|
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 question was asked again...
|
-
|
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...
|
-
|
You may has seen that Microsoft Dynamics GP v10.00 Service Pack 4 will include a number of new features to the Extender product. Please see the information on blog posts on the Inside Microsoft Dynamics GP blog and US Microsoft Dynamics GP Field Team...
|
-
|
MSDN® is sponsoring a coding contest for Office 2007, named OfficePalooza! This sweepstakes will run two weeks beginning April 20, 2009, and features ten fun Visual Basic of Applications™ (VBA) coding challenges in the form of puzzles and games. Each...
|
-
|
The Dynamics GP Blogster , Mariano Gomez, has written a great article on the Dynamic User Object Store (DUOS). One of the great things about the DUOS is that it is a table easily available for a developer to use however they want from Dexterity (table...
|
-
|
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...
|
More Posts Next page »
|
|
|
|
|
|
|