Today’s #TipTuesday is a security tip to help you identify what exact permissions the SQL fixed database roles have, that start with rpt*. If you’re granting access to some of your windows users or groups, you want to know what they can get into, right?
The purpose behind the rpt* roles is generally for SSRS (SQL Reporting Services) reports that ship with Dynamics GP since users running those reports are outside of GP, not tying into GP permissions. There are plenty of other posts out there about GP & SSRS, so I am not going to get into that here. Instead I am going to show you a SQL query I’ve used to see what permissions are granted to what role, login, user or group in SQL.
Continue reading “What’s included in those SQL rpt roles?”
Today’s #TipTuesday is too late for 2018 filings but hopefully those this applies to will file it away for next year. The post is as a result of a question from a consultant who works for one of the Dynamics GP VARs in the Toronto area, whose client asked how to get 1 XML T4 file for multiple employers.
TL;DR version: it does that out of the box although the UI doesn’t make it seem like it would! Since some people may stumble across this post and use other ERP systems, this post is specific to Dynamics GP and the Canadian Payroll module.
Continue reading “Cdn Payroll T4 XML & Multiple Employers”
(At least I hope it’s the end, LOL!). Here are the various parts to my mini-series so far, which is 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) and finally a bit about validating an XML file against an XSD schema (part 4).
So, what is this post about? This is taking a step back to describe the process itself. The part 1 story tells you what I’m doing, and ultimately I am all about the process. It’s one thing to create some code in order to create an XML file, but ultimately the best solution for an ongoing, repeatable process is to think about the end to end steps from the point of view of the user. This is about the “solution” that I created, which may give you some ideas on either the thought process behind it, or ideas on how to mimic the same thing yourself for a process of your own on something else.
Continue reading “Fun with XML, the end”
Today’s #TipTuesday is a pretty simple one, it’s about the Additional menus in GP windows that appear when you use Extender (from eOne Solutions) or other ISV solutions or customizations that add functionality to existing Dynamics GP windows. I learned something that shouldn’t have been new to me, so I either didn’t know this or had forgotten about how security worked, as it relates to Extender. I can’t say 100% that this applies generically to all Additional menu items but I believe it does. Someone can comment if I’m incorrect here!
Continue reading “Additional menu in GP windows”
This phrase was uttered in the office recently, by the person who is tracking final changes to the year end Financial Statements. Her statements were out of balance, which turned out to be a new G/L Account. The next phrase was “Oh sorry, I forgot to tell you I added that. There must be some way to to alert you because I won’t always remember to tell you!”
Yes, there must be a way! Cue the SmartList-based Home Page Reminders. This is the subject of today’s #TipTuesday post.
Continue reading “When did that G/L Account get added?”
Today’s #TipTuesday is a hidden gem, and if you didn’t know what you could do with it, you’re going to love this post! The misconception is some of the things I’m describing might require using SmartList Designer or Builder to create new SmartLists. Many useful tweaks can be made without any of those tools.
Continue reading “SmartList Options”
Or does it? Today’s post is the first #TipTuesday of 2019, and a little bit of an obscure one at that. The short version is, if you use the write-off feature while you are applying payments or credit notes in Dynamics GP Receivables Management, the results display rather oddly on the RM Historical Aged Trial Balance. In fact, at first glance, it seems like the report is actually wrong, but it’s not, and here’s why.
Continue reading “My write-off doesn’t add up!”
Will you look at that? It’s nearly Christmas and year-end and that means it’s time for some tax updates. Today the last of the updates were released for US English and they cover GP 2015, GP 2016 and GP 2018. Hopefully if you are reading this and still running GP 2013, you’ve got a backup plan in place!
Continue reading “Canadian Payroll 2018 Year End Update”
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 in fact, but I didn’t get into the Clear Companies script.
Continue reading “Clear Companies script & custom tables”
The last couple of #TipTuesday posts have been around some older “new” features – copy journal entry and backout/correct journal entry. Today I thought I would write a quick tip post around one of the lesser known options for creating journal entries in Dynamics GP: quick journals. Next week for my last #TipTuesday of the year, I’ll have a post about the other option which is clearing entries.
Continue reading “Quick Journals”