Calling SQL Server stored procedures from Microsoft Dexterity - revisited
Back in January of 2009, I wrote an article showing a method of calling a SQL Server stored procedure from Dexterity by calling a stored pro...
Read the post →
Building Microsoft Dexterity Cross-Dictionary Applications with GP Power Tools - Part 2/2
In Part 1 of this two-part series, we saw how to use the Resource Information and the Runtime Execute Setup features in GP Power Tools to...
Read the post →Unhandled database exception Save operation on table 'ASI_SOP_HDR_MSTR_Explorer" has caused an unknown error (39)
What if you end up creating a reminder based on a long running SmartList? It had to happen, right? As it turns out, if you create a reminder...
Read the post →
Copying Quick Links from one Microsoft Dynamics GP user to another
Just recently, I ran across a question on the Microsoft Dynamics GP Community forum asking for a way to copy Quick Links from one user to a...
Read the post →Using Microsoft Dynamics GP Business Intelligence deployment utility to deploy custom SSRS reports
Using Microsoft Dynamics GP Business Intelligence deployment utility to deploy custom SSRS reports - Part 2 In the previous installment ,...
Read the post →
Using Microsoft Dynamics GP Business Intelligence deployment utility to deploy custom SSRS reports
Using Microsoft Dynamics GP Business Intelligence deployment utility to deploy custom SSRS reports - Part 1 I was in Johannesburg, South...
Read the post →KB Article 878449 Capture Login script gets a much needed rehaul
We live by it, we die by it. KB article 878449, How to transfer an existing Microsoft Dynamics GP, Microsoft Small Business Financials, or M...
Read the post →SmartList Builder: Sales Summary By Quarter
Just recently I was approached by a partner wanting to leverage the info in the Receivables Summary table (RM00104) to build a smart list sh...
Read the post →Listing all eConnect Modified PRE and POST stored procedures
As of recent, I was ask of a simple method to determine which eConnect PRE and POST stored procedures had been modified. After all, with a c...
Read the post →
Extracting data from Microsoft Dynamics GP company databases using SQL Server FOR XML and XMLNAMESPACES
I truly love what I do. Really! My job takes me just about everywhere around this great country of ours and beyond its borders in the ques...
Read the post →SSRS: GL Trial Balance Summary report returns no data - Follow Up
Back in July of last year, I wrote an article on a reported issue with the SSRS GL Trial Balance reports were not returning any data with Mi...
Read the post →1099 reports: the devil is in the details
It's certainly that time of the year and if you haven't sent out those 1099's you are running out of time. I was working on a ca...
Read the post →
Granting Access and Binding Defaults when recreating SQL Tables: a follow up
In his most recent article, Granting Access and Binding Defaults when recreating SQL Tables , my good friend, David Musgrave, points out how...
Read the post →Copying Smartlists favorites from one user to another
I get this question asked very often and sometimes have to dig up my notes on the subject, so I figured I would just post the SQL script tha...
Read the post →Year-to-year Inventory Margin Report using the PIVOT operator in T-SQL - Follow up!
Ok, of course my dear friend Corey in Louisville, Ohio had to challenge my post from yesterday and ask a question that is, frankly, a logica...
Read the post →Year-to-year Inventory Margin Report using the PIVOT operator in T-SQL
As of late I have been camping out at the SQL Developer Center's Transact-SQL Forum and I have to say, I have learned a great deal fr...
Read the post →
Running Fixed Assets Depreciation causes Microsoft Dynamics GP to "hang"
I just completed a full upgrade of Microsoft Dynamics GP from version 9 to version 2010 R2 for a client and they were going through their fi...
Read the post →