Determining Role Access To Extender Objects

An Extender case came up recently where the customer was having security issues with Extender forms. To solve the issue, we needed to determine which Security Roles have access to particular Extender forms. Note: This method uses the DYNAMICS.dbo.EXT00001 table which was added for version 10.0 Service Pack 4 and later. We were able to…

1

Dexterity: Cannot See Table Buffer Values in 10.0 SP5 or 2010 SP1

A long standing pain point for ISV’s has been the inability to see 3rd party table buffers while debugging ISV code in runtime. Most development – I assume – is in test mode where your customization and Dynamics are on a level playing field and the ISV can see anything they like easily. However for…

1

Missing HR Menu Items In Dynamics

So you think you know all about menus?  I thought I did too until I resolved a case today. The customer was having an issue with some HR menus. For some users (including sa) when logged into some companies, some of their HR menus wouldn’t show.  The ones the user notes are Compensation Management &…

2

Writing to An Event Log in a Visual Studio Tools Customization

So you are writing your top notch, one-of-a-kind Visual Studio Tools for Microsoft Dynamics GP customization. You’ve covered all the bases for any potential errors and just in case you miss any and an exception is thrown, you are catching the exception to write into an event log. This works great until you test this…

0

SQL Server Express Failing To Start Revisited

David Musgrave posted an interesting article a few days ago where compressed SQL Server database files caused the SQL Server service not to start. Happily, the event log message tells us exactly the issue and solution and when I read this I noted that this was SQL Server Express being used by the customer. Beth,…

6

Stored Procedure Executing In Wrong Database

We ran into an odd issue recently that I’d like to share today. An ISV reported that in their customer was getting an error when the ISV application attempted to execute a stored procedure. [SQL Server] Could not find stored procedure DYNAMICS.dbo.SomeStoredProcedure Easy you say – the proc doesn’t exist.  Just create it and you’ll…

0

Revisited – Modal Windows Issues in GP 10.0 Fixed in 10.0 SP5

At the beginning of this year, I posted an article that detailed a couple of the known issues involving VBA and a Visual Studio Tools window displayed as a Modal Window. The issues were: 1. Not being able to tab in a GP window 2. Not being able to click/select a field with the mouse…

4

Using SQL DB Update Trigger With Text Fields

An ISV had a goal of creating an audit table of the Dynamics record notes table – SY03900 – but was running into an issue. He mentioned that he was using an “instead of update” SQL trigger and not just a normal “update” trigger.  The specific issue was that while his audit table was being…

1

PSTL 2010 – Duplicate Customer PO Numbers in SOP Entry

In last weeks post, I outlined several tools that were previously freely available from Professional Services but now are bundled under PSTL 2010 as free tools. There is one more free tool I did purposely omit for a couple reasons: This one wasn’t previously free  It is a pretty cool tool that deserves a bit more…

11

Free Tools Added To PSTL 2010

Today’s blog post is a public service announcement. With the release of Dynamics 2010, the Professional Services Tools Library (PSTL) has been enhanced with the addition of previously free tools that were available from Professional Services. This means that you no longer have to contact Professional Services for these applications, you can just load PSTL from…

1

VSTools 2010: Adding Company Name to Dynamics GP Home Page

A few years ago, the question came up (partner, customer, Convergence – I don’t recall) about being able to identify the current company on the Dynamics Home Page of the Navigation pane. Currently at the top of the Home Page, the page will default to: %user%’s Home which after substituting the user id we would…

2

Using 3rd Party Series Reports in the Report Template Maintenance Lookup Window

A few weeks ago we ran into an interesting case regarding the new Word Report Templates in Dynamics GP 2010. An ISV was working on adding templates to her Dynamics GP customization but was stymied by the “Reports” window which is the report lookup window for the Report Template Maintenance window. In her customization, all…

5

SQL Temp Table Opening As Ctree

An ISV opened a support incident with me as one of his customers was running across an odd issue with his application.  None of his existing customers with the same application were experiencing this issue. In his application, a SQL temp table was opened and filled via a stored procedure call using code similar to:…

1

Avoiding VBA Circular References when using a Dynamics GP Lookup

Honestly, I struggled a bit on the title of this article. Is this article to show one way to use a Dynamics GP lookup window in your Modifier/VBA customization?  Or is it an article that shows a way to work around the circular reference problem that you can get yourself into when using VBA across projects in…

4

Failed to check in resources into Dexterity DSCCS

This happened to me again the other day – and it took me a few minutes to resolve (and re-solve!) it again. To me that sounds like blog material. I had just finished creating and testing my new Dexterity integrating application and needed to check it into source control.  As I’ve noted previously, we use…

3

SQL DB Insert Trigger Breaks Dexterity Active Locking

An issue came up recently that I thought I’d share with our readership. The customer is using SQL insert database triggers on various Dynamics GP tables and running into an issue. I don’t have the full details on the “how, why, and what” but I do know the result of the issue they ran across as…

7

Dexterity DSCCS 2010 RTM should not be used

Several weeks ago, an ISV posted to the forums that he had thrown caution to the window and upgraded his Dexterity DSCCS 7.5 to DSCCS 2010.  The install went OK for him (unlike my own install that I discussed in a previous post) but what he found was that he wasn’t able to check in…

1

Dynamics GP Lists: Exports slowly to Excel

Breaking with my recent series on Smartlist and specifically the Smartlist: Exports slowly to Excel – Part 1 post, a comment and followup question to that post was: This is great!  But is there a similar switch for the Dynamics GP lists such as the “All Sales Transactions” or “Accounts” list? Good question and honestly…

4