The way I develop is more unique than not, I'm a consultant that dials into a new customer every week, and it's convenient to have Visual Studio the way that I want it. 

Here is a list of the things that I frequently change to make it more like home

Who reads documentation? Not me. 

This will be a series of articles on how to use Mercury BI - a reporting tool for any data source, but they have a lot of prepackaged Dynamics GP reports. 

My overall first impressions: Nice, useful product and great support. It's pretty easy to get in touch with a dedicated and knowledgeable tech. 

I'm still learning the product, so I'll have to come back to this post later and be clearer, but I see a tool that takes SmartList and makes it easier and MUCH more functional. I would absolutely use this before Smart List Builder. 


This is what Mercury BI looks like when you open it


Short tutorial on how to run a report, alter it, and then save that altered report as a favorite.

In my way of doing things, you do all the work that you can in a stored procedure and then send the result to the reporting platform. 

Today we're creating a stored procedure and feeding it to a Pivot in Mercury BI

Part one of two, so that I can put the topics on the menu in different places. 

Today's topic is creating a date calendar in SQL to use in reports. I'll show the importance of this in the next post, for now, just the practical code. 

Creating a date dimension or calendar table in SQL Server (

I've copied the code below with only minor edits from the link above. 

The output will look like this. This is only about half the columns, though, it's way too wide to show here.

This is our wrapper procedure for inserting RM Taxes
This is the unencrypted code from the SOP taTaxEngine eConnect stored procedure
This is the unencrypted taRMTransaction Stored Procedure
This is the unencrypted taRMTransactionTaxInsert stored procedure

When doing a simple RMCustomerMasterType document in Dynamics GP, we're getting

Cannot insert the value NULL into column 'Caller_ID_String', table 'XXX.dbo.CN00100'; column does not allow nulls. INSERT fails.

Solution, discussion below

I'm sitting down, fanning myself, trying to not pass out.

I just did this in SSMS

Recently I needed a piece of TSQL that would strip leading zeros from a string. 

In other words, turn this '0001234' into this: '1234'

I found a clever piece of code, blogging it below. Works pretty well, and it short and simple. 

Does anyone have any experience with SQL Tables for GL Workflow approvals?

We have multiple subledger batches that are showing in GP as waiting for an alternative final approver. 

Our problem is the final alternative approver is a very old windows account that has been inactive for a long time.

I would like (if possible) to simply change the approver to a current user.

Here's a screen shot - tried using table finder but I don't think it listed the tables:

Good Afternoon,


Is there a script for the GP Trial Balance but using the work tables?


Thank you


Hi!  Does anyone have a copy of GP 10 installation media?   Doing a crazy upgrade.
Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables