-
SQL Alerts with HTML email body
Today’s #TipTuesday is a bit different from my normal type of post. In the course of monitoring some integrations, I wanted to change the emails I get when there are issues. What I inherited was email alerts with attachments, without any data that I could use as an Outlook filter to tell me if something…
-
Fun with XML, the end
(At least I hope it’s the end, LOL!). Here are the various parts of my mini-series so far: The story behind all of this (part 1) The technical deep dive into the SQL query (part 2) A bit about namespaces in the FOR XML (part 3) A bit about validating an XML file against an…
-
Fun with XML, part 4
The last of the “technical” parts of this mini-series is about how to validate an XML file with a parser, against an XSD schema. This would complete the list of things I learned in this journey to create a T5 XML file, that I didn’t know before I started. For those interested in the previous…
-
Fun with XML, part 3
The fun continues! Today’s post is about the namespaces. I was unable to figure this out for the longest time and ended up giving up, manually pasting in the values I needed for submission. It was only in prepping this post that I came up with a way to get the namespace attributes in the…
-
Fun with XML, part 2
Today’s post is a continuation of the mini-series I started on Feb 28th. Read the first part here which contains the story behind this. In this post, I’ll be getting into the technical details of what I learned. This is about the guts of the XML itself, in SQL, where I ended up writing this…
-
Fun with XML, part 1
This is going to be a short series of posts (short series, not short posts!) about my journey with creating an XML file for T5 filing with the Canada Revenue Agency (CRA for short). So many things happened in the last couple of weeks on this, that there were plenty of lessons learned to share…
-
Clear Companies script & custom tables
This is a funny story… or funny now that I’ve figured out the problem I had earlier today. This story begins with a DEV/TEST environment for Dynamics GP where I was setting up some scripts to automate the process of restoring from PROD to DEV. I posted a blog article about this earlier this year…
-
GP Utilities user permissions
Today’s #TipTuesday post is about GP Utilities and what permissions are required. For those going through any service pack install or upgrade, there might be a lot of workstations that need to be updated! In our case, we just upgraded the Dynamics GP environment and wanted all hands on deck to help with installs, including…
-
Start/Stop SQL by Batch File
Today’s #TipTuesday post is for anyone who might be running more than one local instance of SQL Server. I often have at least a couple of instances on my laptop, as historically I would want to have the ability to mimic some client installs, as close as I can. While I am no longer a…
-
SSRS 2016 Report Builder Permissions
Today’s #TipTuesday is around the permissions required for either creating reports or publishing reports in SSRS. These are permissions as they relate to Report Builder 3.0 at least, as I haven’t tested that the same is true via Business Intelligence Development Studio (BIDS). I assume the same applies but haven’t tested that myself so YMMV.…
-
Sample SQL Views for Smartlists
Today’s #TipTuesday has been on my list for a while and it’s a great resource that many people don’t know exists. Microsoft has created a “living” document that has embedded links to SQL views that an admin can run and tweak in their Dynamics GP environment to create custom SmartLists. The document says it is…
-
Do you know when a SQL trigger is dropped?
Today’s story starts with a SQL trigger, and a Dynamics GP service pack which dropped the trigger, unbeknownst to me. Fortunately, I had planned ahead, not wanting to rely on my (or anyone’s) memory to remember to check for issues after installing service packs! A few months ago, I posted about the issue that led…
-
Looking for special characters in SQL
Recently, a client was starting a SafePay & EFT implementation for Dynamics GP and one of the requirements of the bank was that the vendors cannot have any special characters outside of a handful of “regular” special characters. Their specifications and instructions had a list of acceptable characters and a longer list of unacceptable characters.…
