-
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 to 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…
-
Report Writer Series – Custom Reports
The next in my series of blog posts about Report Writer is a brief article on Custom reports. Why 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 of simple reasons…
-
Canadian Payroll – Transmission Header Incorrect Length error
This is a repeat of an article I wrote in November 2011 with updated information. Issue #2 in that blog was regarding permissions during the Generate Cheques routine and the message “There is an error in the Transmission Header – Incorrect Length”. At that time, the fix seemed pretty obvious and it worked during testing…
-
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! Generally speaking, a report will have at least 5 sections to it, in…
-
Report Writer Series – Drawing Options tips
Way back in February 2011 (yikes!), I wrote about some Report Writer toolbox items and focused on the Arrange tab of tools. Today, at long last, I am concluding that article with some notes and tips on the drawing options (most font options), hopefully clearing up some mysteries. What are Drawing Options? These are the options one…
-
Free Stuff for GP!
You read that correctly! Microsoft has decided to change the way they work with some of their utilities and tools. Previously there were charges to get access to tools or utilities like Customer Modifier and Customer Combiner (and Vendor, Account, Item etc.). On the partner side, we had to purchase those outside of the normal ordering processes (they…
-
eConnect, GL Transactions & Multicurrency
What I’m posting today is hopefully of use to someone out there who runs into this same problem. Admittedly it’s rare but it took me a while to find the answer. The Issue I was attempting to import General Ledger transactions using eConnect via SmartConnect. My client had multi-currency enabled and there was a default currency…
-
Some Canadian Payroll & Project Accounting gotchas!
Recently, a client of mine experienced a couple of weird things when we started to configure another Dynamics GP company for them with Canadian Payroll and Project Accounting in action. One of them is something to look out for if using the Canadian Payroll import processes; the second is more of a head-scratcher type of…
-
Why does the JE description say “Receivings Transaction Entry”?
A question similar to this came up in a forum recently, essentially the question was “Where can you change the description of a transaction from a Dynamics GP Receivings Shipment or Shipment/Invoice”? The short answer is, that it’s very well hidden but it is there, and most users don’t see it and generally, it stays…
-
Quick Tip – SmartList Builder & Account Numbers
This is a very short tip for those who use SmartList Builder. I must say I see this ALL THE TIME. I hope to expand on little nuggets inside SmartList Builder in the coming months because there are numerous time savers in there, that people have gone to great lengths to work around manually &…
-
New Year’s Resolutions 2012
Happy New Year everyone! It’s January 1st, 2012 and it’s time again to review last year and make some resolutions for this year. The Year 2011 in Review Last year I started the year with a blog article about my resolutions, business-wise. How did I fare? Well… some good and some not-so-good answers on that! Blogging once…
-
Canadian Payroll issues and fixes
Today I have 2 issues to write about relating specifically to Canadian Payroll in Dynamics GP; things that a couple of my clients have recently run into that are fairly common and easy fixes. Issue #1 is regarding stuck batches and the message “The batch is currently in use – Please wait until the other user…
-
How secure are your passwords?
A recent scenario at a client got me thinking about security – or lack thereof – that exists at some clients for various reasons as well as the flip side of ridiculous security that was going too far the other way. The Background I’ve been documenting the configuration of a third-party reporting & budgeting tool one…
-
A new season begins…
Yesterday I went golfing, and it was the first day that had that “autumn turning to winter” feel about it. It was about 8 degrees Celsius when I teed off, and yes, I froze my backside off in the process. But the sun came out and gradually I only needed 3 layers to keep warm. 😏 (Such is…
-
Quick Comparison Report Testing Tip
I am working on an upgrade right now with a client and have a quick tip to share, that may save a little bit of time in testing, depending on how many company databases there are. Common Time Wasters One very common problem with upgrades that I’ve seen is specific to people who, shall we…
-
Bug month! Issues with Project Accounting employee vendors & EFT
It must be “bug month” for me, as I have another issue. One is reported as a bug – kind of – and the other, reading between the lines, will not be considered a bug when all is said and done. The Issue There are 2 actual problems but both are caused by the same thing…
-
Canadian Payroll – some ROE fields demystified
A client of mine had a great question for me last week on the ROE (Record of Employment) form that I couldn’t answer off the top of my head. I took the opportunity to research and test to answer the question and figured it is not an uncommon question, so I may as well share the…
-
Excel Report Builder – bug in SQL views created
I’m not sure why, but I always seem to find the obscure bugs in GP, the ones that don’t affect many others. I guess it’s called a gift. 😄 Today, I found another one that affects GP10 (although has been resolved – I can’t verify that yet) and a slight variation of the same for…
-
Client Updates & Archiving old service packs
What usually is a typical service pack install client visit started on the wrong foot. I am installing SP2 for GP2010 plus related hotfixes for a client, and the last time I was here was in January for the year-end tax updates. While I was doing my usual preparation, before I even started the process of installing…
-
Kudos to all the regular bloggers out there!
A very short off-topic article. When I first started blogging, I thought weekly posts were a good goal, and it seemed pretty easy to keep up with. I had a long list of things I wanted to talk about at some point, no shortage of ideas! I was set! All was good until I went…
-
Fun with changing a server name!
I write this with a little embarrassment at the solution to a problem I had. Earlier this week I renamed a server I’m using for GP2010 to prepare for a new network and improve my network naming conventions. I’ve changed server names before at clients and the steps and places I need to make updates are…
-
Disenchanted with support? I understand your pain!
Is it me or is getting support sometimes like pulling teeth? I’ve had a couple of experiences lately which remind me of why I am in this business and why my clients are so appreciative of the way I deal with them and respond to their issues. The reminder for me is NEVER to let…
-
GP Tech Conference Day 3
Today is day 3 in Fargo, and the majority of the day is wrap-up and some chances for the vendor sponsors to present their wares. The room is emptying gradually as the day progresses as people are heading to the airport to catch their flights. This is mostly some observations of the overall conference and a…
-
GP Tech Conference Day 2
Day 2 at the Dynamics GP Technical Conference in Fargo: It was another long day, with a lot of information presented in the sessions. On the weather side of things, it was quite a bit warmer today vs day 1, which I have come to learn was unseasonably cold for this time of year. Great…. it reminds…
-
GP Tech Conference Day 1
Today was day 1 at the Dynamics GP Technical Conference in Fargo. It was a long day of sessions, lots of interesting information to be had. It was also bitterly cold outside, and it’s safe to say not too many people ventured outside between sessions today! These update posts won’t have a TON of detail…