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.

(more…)

By | 2017-08-13T11:46:24+00:00 July 13th, 2016|Excel Tips, How To & Tips|0 Comments

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.

(more…)

By | 2017-08-13T11:46:24+00:00 July 12th, 2016|Canadian Payroll, News|0 Comments