DynDeveloper.com

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. 

so...

This is what Mercury BI looks like when you open it

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

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

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. 

Good Afternoon,

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

Thank you

Tina