Cool Excel Tip: Dates without holidays included

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”

CanPay ROE Issue with postal code

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”

More Azure – Part 3

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”

GPUG Amplify 2016 – Day 3

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”

GPUG Amplify 2016 – Day 1 – Rest of the day

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”

Posts navigation

1 2 3 17 18 19 20 21 22 23 30 31 32
Scroll to top