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:

  1. Additions with & without YTD/LTD amortization
  2. Depreciation/Amortization
Continue reading “Fixed Assets GL Posting Flow Part 3”

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:

Continue reading “Fixed Assets GL Posting Flow Part 2”

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!

Continue reading “Back-dating Fixed Asset Retirements”

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.

Continue reading “Cdn Payroll Basic Personal Amount calculator”

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.

Continue reading “Canadian Payroll 2019 YE Update Round 2”

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!

Continue reading “Excel Background Refresh & Pivot Tables”

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!”.

Continue reading “New Year’s Resolutions 2020”

Top 10 Blog Posts from 2019

This is a look back at what posts had the most views during 2019. I believe it’s the 3rd year I’ve done this and it is always interesting what old posts continue to be relevant (or at least “hit” via search). The first year I did this, only 4 posts from that year made the top 10, and last year 7 of my 2018 posts hit the top 10. This year 6 posts from 2019 made the top 10… and once again, a post from 2011 made the list.

Continue reading “Top 10 Blog Posts from 2019”

Posts navigation

1 2 3 4 5 6 7 8 9 38 39 40
Scroll to top