Fixed Assets GL Posting Flow Part 5

Today’s #TipTuesday is a continuation of what happens during Retirement transactions in Dynamics GP. Today: different retirement types and the impact on which Gain/Loss account is chosen.

The previous posts so far are:

  1. Additions with & without YTD/LTD amortization
  2. Depreciation/Amortization
  3. Retirements in the 1st year of ownership
  4. Retirements after the 1st year of ownership
Continue reading “Fixed Assets GL Posting Flow Part 5”

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”

Posts navigation

1 2 3 4 5 34 35 36
Scroll to top