Business – Page 6 – JenKuntz.ca

Fixed Assets GL Posting Flow Part 3

Today’s #TipTuesday is a continuation of my Fixed Assets series around G/L posting flow. This post will be the start of what happens during Retirement transactions in Dynamics GP. There are a lot of options around retirements, although in the end most selections don’t impact the results much as you will see. I will be breaking this into different posts to keep the length manageable. Today: retirements in the first year of ownership (acquisition year).

The previous posts so far are:

Fixed Assets GL Posting Flow Part 2

Back in September, I started a series and honestly figured I would not have taken this long to get to “part 2”! What I’m going to do is make this part of my #TipTuesday series and try to get through it a little bit faster!

Today’s post is what happens during the Depreciation routine in Fixed Assets, from a GL posting flow perspective. The previous post in this series was GL posting flow around additions, in 3 specific areas:

Back-dating Fixed Asset Retirements

Today’s #TipTuesday is about a message you may receive if you back-date a Fixed Asset retirement in Dynamics GP. I completed a project recently where the client was catching up on some IFRS asset derecognition that, in some cases, had occurred in prior years by the time we got around to doing the retirement in Dynamics GP. While this isn’t an everyday occurrence, if you have to do this yourself, you may get an odd message!

Checklinks “the keys record has been removed”

Today’s #TipTuesday is about Checklinks, and specifically about a message you may get if you run file maintenance against Sales > Receivables Open Transaction Files. Some general parts of this blog may apply to other errors in checklinks but I’ll focus on this one message for now to keep it simple.

Cdn Payroll Basic Personal Amount calculator

If you are reading this and a user of Microsoft Dynamics GP and Canadian Payroll, you’ll likely have already read my previous post where I’ve indicated that the Canadian Payroll module will not automatically calculate the Basic Personal Amount (Federal) for you.

If you are reading this and are not a user of Dynamics GP: don’t worry. The information in this post is generic and should be able to be used to calculate the Federal BPA for employees regardless of the payroll software you are using.

In this post, I’m simply going to outline a way to do the calculation and have included a spreadsheet for you to download if you want a quick starting point to manually determine what an employee’s Basic Personal Amount (Federal) should be, when they fall in the income range of $150,473 to $214,368.

Canadian Payroll 2019 YE Update Round 2

Microsoft released a “Round 2” update for Canadian Payroll for Dynamics GP. What is a round 2 update? It’s a change that wasn’t in the first update in December! Typically we don’t see this in Canadian Payroll but the CRA made a relatively last minute change to the federal basic personal amount (BPA for short) that necessitated an update. As it turns out, the update does not address that change from the CRA but it does fix 3 other bugs.

Here’s what you need to know and do if you are a Dynamics GP Canadian Payroll user.

Excel Background Refresh & Pivot Tables

Welcome to my first 2020 #TipTuesday post. Today’s topic is Excel and how a background refresh setting can impact refreshing pivot tables.

The background to this post is related to a report I was creating for a client to validate timesheets prior to approval. The report has a couple of queries in them (from SQL) and a pivot table to summarize the data. In order to make the refreshing easier, I created a tiny bit of VBA and a button for the users to click when they wanted to refresh the data, to pull in the latest timesheets. When testing it, it was doing everything except updating the pivot table. Here’s how I resolved that!

New Year’s Resolutions 2020

It’s time to look back on the year 2019 and the last 10 years. I won’t say “the last decade” lest the mansplainers get their shorts in a knot about it technically not being the end of the decade. 🙂

10 years ago, I was 4 months into my own consulting business. In 2019, I started the year in an employment role but went back to full time independent consulting in June. Long story short: I think I was meant to be a consultant. If you’d asked me 10 years ago if I thought I’d still be running my own business, I would have likely said “I’m not sure but I hope so!”.

Canadian Payroll 2019 Year End Update

This post is extremely late, but I wanted to get it out there anyway for those that have just concluded their last 2019 payrolls for the year.

The Canadian Payroll 2019 year end tax updates for Dynamics GP were released on December 18th. Here are some links to get you what you need for this year end.

1 2 3 4 5 6 7 8 9 … 38 39 40

Category: Business