Transaction Descriptions & POP to PM MS Connect Suggestion

Time for one of those obscure issue blogs, that won’t affect very many people, but the odd person might find this very useful to clarify what they are or are not seeing happen (and give me a couple of years, I’ll forget, and find my blog post!).

This story starts at a client, who requested that the Transaction Description prints on a cheque/EFT remittance. Sounds easy right? Well, the client found out at some point when first using GP that any descriptions in POP transactions they typed in were not updating PM tables, therefore no descriptions for the reviewers or vendors. So, they called their VAR for help.

Cue the VAR, who at some point early in their original implementation with Dynamics GP 2010, added an Extender window on the Invoice Match Entry window, for A/P Clerks to type in a transaction description, and a SQL trigger on the POP30300 table, to update the PM20000 table with that description after posting completes. Last year, during an upgrade to Dynamics GP 2013, I was new to this client and the issue came up during testing because (of course) the trigger wasn’t upgraded/replaces after the upgrade, no one knew it existed, and the descriptions stopped populating PM tables again.

When the client noticed the problem, I made a note to look into this in the future. First of all, they didn’t need an Extender window when there is an out of the box Reference field in all the POP transaction windows! Second of all, why should we be using a trigger on something so basic? It warranted looking into further to see why this was needed in the first place. (I understand the end goal of the description pushing down to payables but the smelled like something that should just occur out of the box, no trigger, no add-on windows…)

(more…)

Why Edit Lists are important

A few years ago, I had an idea for a post about batches and why I recommend them but I never followed through on the idea. I had written a short post last year about Transaction vs. Batch posting but that’s as close as I got to elaborating on my blog thought.

I was reminded today of why I wanted to write this article, which isn’t about batches specifically but about edit lists, which you only can use if you use batches in Dynamics GP. Two incidents in recent weeks have re-affirmed my belief that using batches, reviewing your work prior to posting and specifically, using the edit lists, is an important practice to follow.

(more…)

By | 2017-08-13T11:46:23+00:00 January 5th, 2017|General Stuff, Troubleshooting|0 Comments

Dynamics GP Word Template Error & Compatibility Mode

A client of mine is implementing Dynamics GP EFT for Payables (yay, no more cheques soon!)… and I needed to modify the Remittance Form that gets emailed to the vendors when they are paid. If nothing else, I needed to change the title “Check Remittance” to anything but the US spelling of cheque!

I did my modifications – pretty basic ones. I changed the title, I altered the size of a couple of header boxes to line some things up and removed some fields that the client didn’t need. (Who really needs Document Amount, Discount Amount, Net Amount and Amount Paid anyway?). Overall, pretty basic stuff, and nothing I hadn’t done before at other clients.

(more…)

By | 2017-08-13T11:46:24+00:00 August 11th, 2016|How To & Tips, Troubleshooting|2 Comments

Microsoft Connect – Obscure Smartlist Reminder Issue

Tonight I decided to clean up my “future blog posts” folder, where I dump in screen shots and brief snippets of text for future posts, hoping I remember what I was thinking at the time the entire topic would look like!  This one is a snippet and a URL that I’m lacking screen shots on so I’ll do my best to describe it.

(more…)

By | 2017-08-13T11:46:24+00:00 August 8th, 2016|Microsoft Connect, Troubleshooting|0 Comments

8 Tips for Using Forums Effectively

Over the past few months, I’ve put more of a concentrated effort on helping answer questions on various #MSDYNGP forums. I’ve responded off and on over the years, but only in the last few months have I attempted to regularly work at contributing in that way. I’ve noticed a few things that are either pet peeves or simply my opinion on right and wrong ways to use public forums for advice when it comes to your Dynamics GP question. Most of these items can easily be applied to any forum experience but mine are more specific to ERP forums in general.

(more…)

By | 2017-08-13T11:46:24+00:00 August 7th, 2016|How To & Tips, Troubleshooting|4 Comments

Mgmt. Reporter Quirk – unposted entries

I have been working with a client recently where the focus is to minimize any manual reporting in Excel and use Management Reporter more, to the extent that they are able to leverage it. They are using Dynamics GP 2013 R2 and of course, Management Reporter (MR) comes with Dynamics GP so it’s theoretically “free”.  It is hard to argue against using a product that comes with your ERP solution right?  Realistically now I see it as a good stepping stone to, perhaps, ultimately a more robust reporting tool in the future.

In this part of the project, the client is booking entries to “last year” (a closed year) to record opening IFRS balance sheet adjustments that they have been doing manually in Excel to produce IFRS statements.  They are also now using an “elimination” company in Dynamics GP to hold entries they don’t want to really book in production, like consolidation entries between their entities, and the odd IFRS reclassification they don’t want permanently in production just for the sake of financial statement presentation.

If the client was using FRx, everything I’ve been trying to do, based on what I have done in the past, would be easy to do and it would be relatively smooth sailing. I was a loyal FRx proponent for years and as much as that product had some warts, my memories of it grow fonder with every day I work with Management Reporter so far.  It’s that frustrating at times. (more…)

By | 2017-08-13T11:46:25+00:00 March 29th, 2016|Financial Reporting, General Ledger, Troubleshooting|0 Comments

Restore issue on GP 2015 drove me nuts!

I lost an evening that I’ll never get back over something so stupid I wish I had just stopped to think about this issue a little more.

The situation was this: I just upgraded a client from GP 2010 to GP 2015. I didn’t upgrade the test companies, because it’s a waste of time right? So I finish the upgrade and proceed to create new test companies and take fresh backups of the new production companies and restore to the test companies. (more…)

By | 2017-08-13T11:46:27+00:00 August 13th, 2015|How To & Tips, Installation, Troubleshooting|4 Comments

FRx with Dynamics GP 2015

Recently I’ve been playing with Microsoft Azure and installing Dynamics GP 2015 on Azure, upgrading my GP 2010 test environment etc.

One of the things I needed to try to get working was FRx. I haven’t gotten to the point of adding Active Directory on Azure yet, therefore I don’t have a domain and can’t install Management Reporter. Same. Old. Problem. I hate that MR requires a domain, it really limits test and demo capabilities in my opinion… but I won’t rant on that right now!

(more…)

By | 2017-08-13T11:46:27+00:00 April 23rd, 2015|How To & Tips, Troubleshooting|17 Comments

Don’t forget about your reminders!

As most of my blog topics start, this begins with fairly standard question from a client asking why their taxes are not defaulting on their Purchase Order in Dynamics GP.

This situation is something I see a lot of in various clients:

  • Something isn’t working
  • They try to troubleshoot it themselves but can’t find the answer
  • They are getting more and more frustrated at the “randomness” of GP by the minute (their words not mine!)
  • They email me with the equivalent of a “WTF?” with screen shots showing me when something works fine and when it doesn’t, assuming it’s completely randomly doing something just to piss them off.

The answer nearly always ends up with some variation of one of these:

  • Someone did something they shouldn’t have done
  • Someone didn’t do something they should have done

Sound familiar?

(more…)

By | 2017-08-13T11:46:28+00:00 December 22nd, 2014|How To & Tips, Troubleshooting|1 Comment