Dynamics GP on Microsoft Azure – Part 2

As I sat up til nearly 1:00am last night (er, this morning) playing with the new Azure VM, I was thinking “this is going SO smoothly!”. I should have known it wasn’t going to be that easy. 🙂

See yesterday’s “Part 1” post for the introduction to this journey I’m on, which covers why I’m doing this, going from a new subscription to provisioning a SQL server VM. At the end of yesterday’s post, I stopped at “I’ve provisioned my VM”. After that I tried some things, and ran into a problem.

Dynamics GP on Microsoft Azure – Part 1

I feel that I’m a bit behind the curve… I haven’t installed GP2015 in my environment yet, I haven’t tried anything on Microsoft Azure yet, and I figure it is about time I started to look at both.

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?

GP & Lowercase Database IDs

Some days I feel like I’m on a game show, where troubleshooting is a contest… “I’ll take strange GP errors for $400 Alex!”.

Today is one of those days!

One of my clients imports in SOP and Payables transactions via eConnect and then uses Postmaster Enterprise to post the batches.  Today one of the QA users was doing some testing of GP and their integrations after a recent database refresh from the production company. She calls me and says something isn’t working right. Postmaster keeps logging posting errors but the batches look fine and nothing has changed except refreshing the environment.

Fun with Windows 8

I’ve been using Windows 8 now on my new laptop for about a couple of weeks.  I *love* it!  What baffles me is the sheer volume of blogs and articles I run into that are crapping all over this new operating system… it’s hilarious really.  “How to make windows 8 look like windows 7”??  Are you serious?  Why bother upgrading if you’re going to do that?

Enough of that.  Part of the learning curve has fortunately been handled by reading other users’ experiences and searching out tips and tricks to understand how to get things to work for you.  None of what I’m putting in here is new or revolutionary, but hopefully it helps someone out!

Key note for all of these tips: I am not using a touch device so these tips are 100% for keyboard and mouse users… some might work for touch too, I have no idea!

Windows 8 install tips and tricks

Time has flown by, as it does tend to do when you are not paying attention!  One minute I’m in Fargo at the Technical Airlift, dropping a perfectly functioning laptop on a hard tile floor (yes, boy, that was fun!), and the next, it’s nearly Christmas and I’m loading Windows 8 on a even more perfectly functioning new laptop. It’s wrapped in bubble wrap to protect it from myself, just so ya know… ; )

When the Windows 8 previews and betas came out, I fully intended to install them on a virtual image or something, and get to know the new features.  So much for that!  The, ahem, fortunate timing of dropping a laptop and having my other functional Dell brick fail to boot led me to a just-in-time-for-Christmas new shiny laptop.  While my American friends were eating Thanksgiving turkey, I was doing some timely Black Friday shopping.  It seems Canadian retailers have adopted the sale weekend much to our price advantage!

Report Writer Series: The End!

Well, it’s been fun but it’s time to focus on more interesting areas of Microsoft Dynamics GP.  This is the last official article in the Report Writer series of posts I’ve written, although I’m sure there may be the odd article pop up that has some Report Writer content.

Report Writer Series: Keys, Restrictions, Sorting, Grids

Here, at long last, is my next-to-last blog post in the Report Writer series. It’s not that I’ve covered everything you could possibly know about Report Writer, not by a long shot, but what I’ve found is some of the basic information I’ve shared thus far wasn’t as easy to find as the more advanced stuff was.  Do you want to know about using VBA with Report Writer? Editing package files? Adding Extender fields to a Report Writer report? There are many things like these that are already covered by the Dynamics GP community. In my last article I will summarize my series and include a few links to other Report Writer resources if you haven’t found them already!

Now onto this article… This one is a bit of a hodge-podge of things, there is no particular reason why these are all lumped together in one!  The items here probably deserve more in-depth discussion but for the purposes of this blog I just wanted to highlight a few key things about them rather than dig deep into their usefulness.

Report Writer Series: Custom Reports

The next in my series of blog posts about Report Writer is a brief article on Custom reports.

Why would you create a custom report in Report Writer?  (really… why?) I’ve done it a handful of times, and don’t particularly recommend it (with all due respect to David Musgrave 🙂 ) but there are a couple simple reasons why it makes sense sometimes.  The types of reports you would create with it would need to be extremely simple due to the fact there is no end user option for sorting or filtering results and no parameter input.

Report Writing Series: Sections

I’m continuing the Report Writer series with a brief article on Sections in Report Writer.  Every once in a while I see a question on a forum “my field didn’t print and I don’t know why!”.  Hopefully this will help answer that kind of question!