Canadian Payroll News: No Mid-Year Tax Update

On May 30, 2019, Canada Revenue Agency announced that there would not be a July 2019 edition of the Payroll Deductions Tables guide (T4032), Payroll Deductions Supplementary Tables guide (T4008) and the Payroll Deductions Formulas guide (T4127) as there are no legislative changes or updates required.

For customers using Dynamics GP Canadian payroll, that means there will be no mid-year tax update! The next update will be at the calendar year end.

Sign up for our newsletter to stay current on Dynamics GP news!

GP Tips: Dynamics GP Canadian Payroll with ePayStub

Dynamics GP includes the Canadian Payroll module.  There is no limit to the number of employees you can pay with GP. The payroll module can also be used in conjunction with GP’s Human Resources module, making it an excellent tool to track basic and more detailed employee information.

Dynamics GP Canadian Payroll allows you to process employee earnings, benefits and deductions. T4s and Records of employment are also generated by the module.  Both the T4 and Record of Employment routines create electronic files to be uploaded to either Canada Revenue Agency or Services Canada. Detailed reports for Workers’ Compensation, Employer Health Tax and Canada Revenue Agency remittances can be generated. When paired with the ePayStub module (separate purchase), employee pay stubs and T4s can be password protected and emailed to each employee. 

Processing payroll with GP will update your general ledger, and thereby financial statements with actual payroll costs. You may choose a very general costing method for payroll; such as separating direct and indirect employee costs. You may also track payroll costs at a more detailed level, perhaps by adding employee departments. This detail will then show on your Income Statement.

Smartlist is an excellent tool to use with payroll as it enables you to export your payroll data to Excel for analysis.

Payroll Area page

Reporting for Remittances

  1. WCB – can be configured to calculate multiple Workers compensation rates
  2. EHT – will calculate Employer Health tax by province where applicable
  3. Receiver General information in Summary or by Employee. Also allows for multiple Business Numbers

Emailing PayStubs

Adding the ePayStub Module, allows you to email Paystubs, T4s, etc.

Cost Allocation

Direct and Indirect costs can be allocated to a departmental level.

Smartlist Views

New views can be added to the standard SmartLists.  These can also be exported to Excel for data analysis.

If you would like to learn more about Dynamics GP functions and features, please contact us. Our experienced consultants are always available to help you streamline your business processes.

Employee Spotlight: Azair Sheikh

The Rimrock Corporation team is made up of many hard working, talented individuals with interesting stories to tell. In our Employee Spotlight series, you’ll meet some of these people, learn what they do, and how they keep Rimrock exciting and fun. This month we shine the light on Azair Sheikh, our Client Services and Operations Manager.

Azair was born in Saudi Arabia but his background is Pakistani. He first visited Canada at the age of 5 and travelled to Dartmouth, Nova Scotia. A few years later his family returned and settled in Kitchener, Ontario. Azair came to Toronto 8 years later, and has been an unsatisfied sports fan ever since (unless the Raptors win it this year!).  Prior to working at Rimrock, Azair worked at another ERP Consulting firm as well as in the accounting industry as a Financial Analyst.

In his free time, Azair likes working out, spending time with family, reading, writing, playing guitar, and gaming.

Read on to learn more about Azair.  

What do you love most about working at Rimrock & how long have you been here? I love the culture that Jonathan has created here, as well as the autonomy and trust to get a task done without micromanagement. In my career, I have always treated the company I’ve worked for as my own – which has not always played out well. Feathers can be ruffled, and toes can be stepped on. However, Rimrock has been the only firm that has fully embraced that. Jonathan has empowered me and all of the Rimrock staff to feel like owners of the business.

What is your favorite place that you have visited and where is your next dream vacation spot? I unfortunately have not traveled much for leisure – but am hoping to change that in the coming years. My favourite place that I have visited so far would have to be Muree, Pakistan. It’s a mountain resort town that is surrounded by incredible natural beauty.

My dream vacation would be having a guided expedition of the Amazon rain forest in Brazil. A close second is an all-inclusive resort anywhere in the Caribbean where I can lay around and revert back to habits I had as a five-year-old in Nova Scotia.

If you could do another job for just one day, what would it be? I would want to be a stand-up comedian or a professional fighter. Less risk in the former than the latter but both require a lot of courage!

What TV shows/music/apps/Podcasts are you currently obsessed with right now? There are too many to list, but here are a few:

Podcasts: The Tim Ferris Show, The Mindvalley Podcast, Kwik Brain, Consulting Success Podcast, Managing Up, Microsoft Business Applications Podcasts

Apps: Amazon Kindle, RedFlagDeals, Tasker, Microsoft Flow, Duolingo, Headspace, Aware, SkiptheDish and Uber Eats

TV Shows: Arrested Development, Always Sunny in Philadelphia, Kings and American Gods – new season was disappointing.

If you could have a drink with anyone (fictional, alive, dead, famous, non-famous) who would it be and why? I would have a drink with Roger Bannister – first athlete/Olympian to run a sub 4-minute mile, which was considered impossible. After he broke that record, it was broken 46 days later and a sub 4-minute mile is now common among athletes. He is a fantastic example of achieving the “impossible” and how a shift in perspective can completely change your limitations. He was also a very accomplished neurologist and performed tests on Anthony Burgess – the writer of the Clockwork Orange.

GP Lifecycle Support: What’s the Difference Between Mainstream and Extended Support?

You may have heard the terms mainstream support and extended support in relation to your version of Dynamics GP, but do you know the difference between the two?

Companies that use Dynamics GP for payroll may be aware that the most significant difference between mainstream and extended support is that once mainstream support ends, they will no longer receive payroll and tax updates from Microsoft. If you are currently on Dynamics GP 2015, you should be talking to your IT department about upgrading GP in the next few months as this version is approaching the end of the mainstream support phase.  

What else is impacted when mainstream support transitions to extended support? Let’s have a look at what both mainstream support and extended support entail and what changes after the transition.

Mainstream product support includes annual product enhancements (including the tax and payroll updates previously mentioned), security updates, product warranty claims, no charge incident reporting for known issues (including assistance in determining work arounds while resolving the issue) as well as accepting design or new feature requests.  Once mainstream support ends, Microsoft will no longer provide enhancements to Dynamics GP, however security related updates will continue to be available, as long as you maintain a Microsoft support annual plan.  Once extended support ends, security updates and patches will no longer be available for that version of Dynamics GP.

Below is a table of what versions of Dynamics GP are on mainstream and extended support, as well as the dates mainstream and extended support expire.

  Mainstream Support End Date Extended Support End Date
Dynamics GP 2010 10/13/2015 10/13/2020
Dynamics GP 2013 R2 4/10/2018 4/11/2023
Dynamics GP 2015 4/14/2020 4/8/2025
Dynamics GP 2015 R2 4/14/2020 4/8/2025
Dynamics GP 2016 7/13/2021 7/14/2026
Dynamics GP 2016 R2 7/13/2021 7/14/2026
Dynamics GP 2018 1/10/2023 1/11/2028
Dynamics GP 2018 R2 1/10/2023 1/11/2028

 If you have any questions about your current version of Dynamics GP, or if you are considering an upgrade at this time, please do not hesitate to contact us.

2 Functions for Error-Free Data Entry in GP

Data entry errors can be very time consuming to find and correct, and therefore, costly. To combat this problem, there are two easily-configurable functions in GP to help maintain control and keep data entry error-free. These simple controls come with the application and can save you time in correcting mistakes, while reconciling your subledgers.

  1. Eliminate Wrong Account Selection

a. Allow Account Entry

Using this check box can help keep your control accounts in balance with the general ledger. In the chart of account, you can uncheck ‘Allow Account Entry’ for all your control accounts such as your Accounts Payable, Accounts Receivable, bank accounts or any account that should be only used in a subledger.  Unchecking the box will prevent users from selecting that account in the transaction distribution or using it in a General Journal Entry. The system will default where appropriate based on the Posting Account setup, or Vendor, Customer, Chequebook or Item setup.

Microsoft Dynamics GP

Once the check box is cleared, any attempt to use a GL account that is linked to a bank in an invoice entry the user will get a warning dialog (as displayed below) and the entry will not be allowed. This eliminates the time wasted trying to reconcile the chequebook with the Bank GL account.

Dynamics GP General Ledger

b. Include in Lookup

On the same account screen, you will find the ‘Include in Lookup’ option. This limits the accounts that the users see in each module. For example, all expense accounts can be limited to only be displayed in the payables screens, and all revenue accounts will only show up in the receivables screens.

Include In Lookup GP

If ‘Include in Lookup’ is not set up, the user will see a list of all accounts (see example below), which increases the risk of selecting the wrong account. (See example below when ‘Include in Lookup’ is set up vs not set up) The screen to the right is what the user sees when trying to select an account in a sales transaction.

2. Account Security

This is a step you can take not only to prevent users from using the wrong account, but also to limit which accounts are visible to each user, including the reports and inquiry screen. In order to activate account level security, go to:

Microsoft Dynamics GP >>Tools >>Setup >>Company: Account Security

Dynamics GP Account Security

Go to Tools>>Setup>>System>>Organizational Structure and define the groups as needed:

Microsoft Dynamics GP Organizational Structure Setup

Go to Cards>>System>>Organizational Assignments and select the department to assign accounts to:

  • Select the department that you want to link the accounts to
  • Select the accounts range
  • Click ‘Details’ if you want to exclude accounts from the range you added
  • Click Process
Microsoft Dynamics GP Organizational Assignments

Then assign each user to the respective department.

Dynamics GP Organizational Structure Assignment

Now, each user will only see the accounts assigned to them, not only in the transaction screens, but also in inquiry and reports:

GP Assigned Accounts

Even when printing the trial balance for all the accounts, the user will only see the balances for the accounts assigned:

Microsoft Dynamics GP Assigned Accounts

If you would like to learn more about Dynamics GP functions and features, please contact us. Our experienced consultants are always available to help you streamline your business processes.

Curious about the Intelligent Cloud offering in GP 2018, R2 ?

Business Central- Intelligent Cloud

The Cloud sync offers you the ability to use Business Central 365 without leaving your on-premise solution, allowing you to take advantage of cloud-based tools that display results on your GP Home Page. To take advantage of this functionality, you must have Dynamics GP version 2018 R2.

Dynamics GP Intelligent Cloud- Business Central

On your Home page, open the “Customize this page” and select the new Dynamics 365 Business Central Insights home page.

The Intelligent Cloud allows on-premise implementations of GP to harness the power of Business Central by replicating your data and providing powerful insights back to you on your Home Page using business intelligence and machine learning.  Replicated data brought across includes: GL accounts and balance, Customers and Open Receivable Transactions, Vendors and Open Payables Transactions, Items and Quantity on Hand.  You also have the ability to schedule the replication; daily, weekly, monthly and the time of day.

Business Central does not have a segmented account structure.  The main segment comes across as the account and all additional segments are represented automatically as Dimensions.  Summary balances are not distributed to the Dimensions, rather they are summarized at the account level. 

First, create your free 30-day trial by selecting Microsoft Dynamics 365 Business Central in the Microsoft Store. 

Microsoft Dynamics 365 Business Central

Then, on your new Intelligent Cloud home page, scroll to the bottom and select the “TRY IT OUT” button to create your connection.

Dynamics 365 Business Central Insights

Next, select Business Central. 

Dynamics 365 Business Central

You will be prompted to log in to Business Central. From there, use the Intelligent Cloud Wizard to create your connection from Dynamics GP.  Please note, data will write from GP to Business Central only.  Nothing can or will be written back to GP.  Only a SUPER user has permissions to run the setup wizard.

Intelligent Cloud Setup

Follow the steps within the Wizard to create a secure pipeline between your on-premise Dynamics GP data and the Business Central cloud tenant.  If you have multiple companies in GP, the wizard will create all the companies you need prior to replication.  If you need assistance, reach out and one of our experts will assist you.  Microsoft has created a short YouTube video which may also help get you started:

Once the replication has finished, your GP home page will benefit from the Intelligent Cloud insights – these insights are available in both GP and Business Central:

In GP:

Intelligent Cloud Insights GP

In Business Central:

Intelligent Cloud Insights Business Central

If you would like more information on the benefits of the Intelligent Cloud, please contact us. Our experienced consultants are always available to help you find a suitable solution for your business.

Top 5 New Features of Dynamics 365 Business Central

Microsoft Dynamics 365 Business Central

Since its launch in April 2018, Dynamics 365 Business Central has seen increasing adoption by organizations looking to digitally transform their businesses. The April 2019 release brings an update to Business Central that aims to enhance current customer satisfaction. Along with innovative new features, Microsoft invested heavily in boosting performance, reliability, and scalability of Business Central, across the platform and business application.

The April 2019 Dynamics Business Central release is the latest in a string of releases that has seen Microsoft continuously improve their end user experience. Microsoft has made it a priority to improve performance in areas of the product which are used most, like entry of transactions, orders, and other data. This was accomplished with new tools and features like the ability to bookmark list views, the Quick Entry tool, and other components that simplify every day work.

Here are five exciting new features:

1. Character Limitations

Description and Name fields character lengths will be increased from 50 to 100 characters. You’ll be seeing this change on master records (Customers, Vendors, Items, Contacts and Resources), Journal Descriptions, Ledger Entry Descriptions, and description fields on documents such as Sales and Purchase Orders.

2. List Views

This simple, but highly requested list improvement idea came directly from the community of Business Central users. Users and organizations will now be able to name and save different sets of filters they use to view and break down long lists of data. Personal views can be saved such as “My Top Accounts” as well as company-wide filters like “Products with the Most Recurring Orders”, making it much easier for users to slice through data. In addition to this, load time when scrolling through lists will be greatly reduced, as the way the rows fetch and display data was rewritten to increase responsiveness.

3. Vendor Invoice Numbers

We will now be able to view the vendor invoice number on the Purchase Invoice and Credit Memo lists. A Vendor Invoice Number column will be added to these pages.

4. Personalized Actions and Navigation

With personalization enhancements we can reorder or hide actions on the action bar and change what appears on the navigation pane on our role centers. This will make it easier to find tasks, lists, and cards that we use every day.

5. Quick Entry

Repeatedly entering data into business systems is one of the most time-consuming processes any company deals with. To optimize the data entry process, Business Central gives users a new way of moving though the required fields in a record by changing the click behaviour of the ‘Enter’ key. The key will now move users from one Quick Entry (required) field to another while skipping over the information fields deemed nonessential. In an effort to increase readability, Microsoft is introducing the ability to change the importance of any field within a record. This quick entry improvement streamlines the entry of transactions by making the process as “mouse-free” as possible.

Looking for more information on the April 2019 Dynamics Business Central Release? Contact our experienced consultants for more information. We are always available to help!

What is Microsoft Azure Cloud Services?

Azure Sphere

Microsoft Azure is a cost effective and highly available infrastructure platform to host your Dynamics GP instance. Azure can be quickly provisioned and gives you access to a reliable cloud infrastructure which removes the need for in-house hardware thereby reducing IT overhead costs.

Azure has enterprise grade security and is coupled with disaster recovery features that can accommodate complex environments securely with full redundancy while meeting tenant data compliance requirements.

For companies who would like to upgrade Dynamics GP to the cloud, Rimrock can provide a complete end-to-end business solution. For more information on Azure, or to find out which option is the best fit for your business, contact us today.

Have You Received a Call from Microsoft at 615-283-7450?


We have recently been notified by several clients that they have received a call from Microsoft USA regarding the License Renewal for Dynamics GP (Great Plains). The call is in reference to a campaign from Microsoft with the objective to have customers renew their Software Assurance, Enhancement Plan or License Renewal for Dynamics GP. Please note that this outsourced Microsoft tele-sales team DOES NOT have access to the status of your renewal.

If you are receiving calls from 615-283-7450, advise them that Rimrock, your Microsoft Partner, will be managing your renewals and to remove you from their call list.

If the calls continue or if you feel you are being harassed by these agents, please let us know so that we can escalate this issue with Microsoft.

Employee Spotlight: JP Sebastian

Employee Spotlight: JP Sebastian

The Rimrock Corporation team is made up of many hard working, talented individuals with interesting stories to tell. In our Employee Spotlight series, you’ll meet some of these people, learn what they do, and how they keep Rimrock exciting and fun.

This month we shine the light on JP Sebastian, our Dynamics GP Account Manager. JP was born in Manila, Philippines, but moved to the GTA when he was 2 years old, and has been living in Toronto since 2010. Prior to working at Rimrock, JP worked as a Finance Manager at ESKA Water.

In his free time, JP enjoys running, golfing, fishing (he can let you in on some of the best fishing spots in the city!), trying new restaurants, and attending as many sporting events as he can.

Read on to learn more about JP.

What do you love most about working at Rimrock & how long have you been here

I’ve been with Rimrock for 3 months.  I think the most enjoyable part of the job is helping identify solutions to make our clients jobs easier.

What is your favorite place that you have visited and where is your next dream vacation spot?

Port Antonio Jamaica. The food, the culture and the vibe of the people is contagious. 

If you could do another job for just one day, what would it be?

Professional Fisherman like Bob Izumi. Being paid to travel to fish is kind of amazing!

If Hollywood made a movie about your life, who would you like to see cast as you?

Tough choice, but it would be Dwayne ‘The Rock’ Johnson.  Of course, the resemblance is almost uncanny!

What TV shows/music/apps/Podcasts are you currently obsessed with right now?

I really got into the show “A Million Little Things” this year. I am also a big fan of The Walking Dead.  

If you could have a drink with anyone (fictional, alive, dead, famous, non-famous) who would it be and why?

I would love to have a drink with LeBron James.  He is an athlete who has been in the spotlight since he was 18 years old, and is always being compared to basketball greats, Jordan and Kobe. I would love to hear about how he deals with juggling the demands of being a high-profile athlete, his family, reputation and legacy.  All in his own words- unplugged.

Tell us a “fun fact” about yourself or your “secret talent” that your colleagues might not already know.

A few years ago, when I worked for Toronto FC, I had to stand in for a player who was injured and back home in France for the annual team picture.  One of the other players asked if I was a new player and why the team would sign someone so fat ☹

Any pet peeves?

Slow drivers in the passing lane, people who do not shovel or salt their sidewalks, and people that place large food/drink orders in the drive-through.

For More Information or a Demo