Have you ever wanted to put a schedule together in Excel with planned dates for something over a period of time, and then manually reviewed the formula, to change dates so they didn’t fall on a holiday?
A client of mine prepares a billing schedule a year in advance where they have to incorporate certain specific holding periods and factor in different holidays of both themselves and their service providers (mostly the same holidays but some different). For example, their data is read by a third party service and it takes so many business days after a scheduled read date to get the data back for billing; then they have a window of so many business days to finish and post the billing cycle etc. All these dates are based on a start date and a factor of so many days – business working days – but excluding holidays.
Continue reading “Cool Excel Tip: Dates without holidays included”
If you are a client using Dynamics GP Canadian Payroll, and use GP’s ROE functionality, this may be of use to you.
If you didn’t need the mid-year 2016 tax update, and only installed the year end 2015 tax update, there were a number of fixes in the ROE (Record of Employment) functions in a January hotfix that you may not have noticed or installed.
A client of mine showed me one issue and I’ve verified with Microsoft that is it one of the fixes in the January hotfix. The specific issue is when creating an ROE, the postal code isn’t being populated in the right box on the ROE window, and it’s a required field.
Continue reading “CanPay ROE Issue with postal code”
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.
Continue reading “Looking for special characters in SQL”
I was working with a new Dynamics GP user recently, and one of the issues that they asked me about was an error they received when they tried to post a cash receipt transaction.
Continue reading “Transaction vs. Batch Posting”
I made the rookie mistake of forgetting I left my VM on earlier this week and now I’m out of credits and have to wait another few days to use it again. Draaaaaag!
Prior to that I had taken some screen shots to demonstrate how to find and use some settings around IP addresses and DNS names. Some of these things have changed since I wrote about my Azure experiences around this time last year, so this is an update if you are using the new Resource Manager approach to managing VMs.
Continue reading “More Azure – Part 3”
Last year I wrote about what happens when you forget to turn your machine off. Well, I did it again. The good news is, this time the message is a lot less cryptic!
Continue reading “More Azure – Part 2”
Day 3 at Amplify was short and sweet, to enable the travelers to avoid the traffic that the Donald Trump rally might bring, which was scheduled to be at the Anaheim convention center next door! Originally we were supposed to start the day with a 9am breakout session followed by the closing keynote, ending the day at noon-ish. Everything got moved up by an hour, so we could get out of dodge without possible traffic delays.
Continue reading “GPUG Amplify 2016 – Day 3”
The second day at Amplify was a little more streamlined than day 1, with 5 breakout session time-slots and a wide-open evening. 🙂
Here are the sessions I attended and some more GP Live fun!
Continue reading “GPUG Amplify 2016 – Day 2”
The remainder of the first day at Amplify consisted of breakout sessions (4 timeslots throughout the day), with expo time and lunch in the middle and a social/mingle sponsored welcome reception in the evening. Each session timeslot, there seemed to be 5 choices of session content, with one breakout timeslot being entirely ISV presentations. Overall the pace of the day was good, not quite a “full” feeling as previous conferences. The only negative in my mind was the extremely long break between in the middle of the day. The 2nd session ended at 11:15am and the third session started at 1:45pm. The intention was to have specific expo hours and a separate lunch break but that just felt way too long and in my opinion, could have been abbreviated to 90 minutes or perhaps even 2 hours but 2.5 hours just seemed excessive for a break in the middle of the day. I’d be curious how the expo vendors felt as they should have been the ones who benefited from that extreme amount of time.
Continue reading “GPUG Amplify 2016 – Day 1 – Rest of the day”
Day 1 of the inaugural Amplify 2016 conference started with a general session at 8:30am. The general session followed the familiar format of introductions and general administrative things, followed by Dynamics GP product strategy, roadmap and GP 2016 product demos. I won’t get into details on “breakfast”. The organizers got an earful of feedback on the disappointing breakfast each day so I won’t add on with more on that. Let’s just say thank goodness for the Starbucks beside the meeting rooms! On the bright side, there was a wide selection of tea for me each day! 🙂
Continue reading “GPUG Amplify 2016 – Day 1 – General Session”