Post categories
business
personal
2023
Moving website to Hugo & Azure
2022 Year in review
2022
Canadian Payroll 2022 Year End Update
Resource not found in dictionary error
MVP Renewal for 2022/2023
Dynamics GP Email - Login Failed error
Enabling the Canadian Payroll module
Where can I find my registration keys on CustomerSource?
Power BI, Excel & GP - SQL sources
Power BI, Excel & GP - Data Access
Power BI, Excel & GP - Starting from scratch
Maximum columns in a SmartList
Power BI, Excel & Dynamics GP
Top 10 Blog Posts from 2021
2021 year in review
2021
Canadian Payroll 2021 Year End Update
ROE issue in Canadian Payroll
Pagination in Power Query (follow up)
Clear Recent Items list in Power BI Desktop
Pagination in Power Query (Part 2)
Connecting to ClickUp in Power Query
Power BI number formatting tips
Pagination in Power Query (Part 1)
Connecting to Harvest in Power Query
Power BI matrix column width sizing
GP Upgrades - series wrap-up
GP Upgrades - testing
GP Upgrades - know your environment wrap-up
GP Upgrades - know your environment part 5
GP Upgrades - know your environment part 4
MVP Renewal for 2021/2022
GP Upgrades - know your environment part 3
Canadian Payroll Mid-Year Update 2021
GP Upgrades - know your environment part 2
GP Upgrades - know your environment
SmartList Export: Excel content error
GP Upgrades - process overview
GP Upgrade Tips series intro
Remove all notes in PowerPoint
New Year's Resolutions 2021
2020
Issues with Word Templates
What happened to TipTuesday?
Excel - where did my workbook go?
MVP Renewal for 2020/2021
Canadian Payroll 2020 Mid-Year Tax Update
SmartList Export: Excel cannot open error
Thunderbolt dock problem? Try this.
Testing email functionality
Owning up to your mistakes
Fixed Assets GL Posting Flow Part 8
Fixed Assets GL Posting Flow Part 7
Fixed Assets GL Posting Flow Part 6
Fixed Assets GL Posting Flow Part 5
Fixed Assets GL Posting Flow Part 4
Canadian Payroll 2019 T4 issue
Fixed Assets GL Posting Flow Part 3
Fixed Assets GL Posting Flow Part 2
Back-dating Fixed Asset Retirements
Checklinks "the keys record has been removed"
Cdn Payroll Basic Personal Amount calculator
Canadian Payroll 2019 YE Update Round 2
Excel Background Refresh & Pivot Tables
New Year's Resolutions 2020
2019
Top 10 Blog Posts from 2019
Canadian Payroll 2019 Year End Update
Year End Tax Updates - plan ahead!
SmartList Export Options
How to copy budgets
Excel tip - is X in the list?
SmartList Tips - search
SmartList Tips - favorites
SmartList Tips - working with columns
SmartList Tips - printing & exporting
SmartList Export Oddities
GP "Next" aka what's in a name?
SmartList Tips - the basics
Fixed Assets GL Posting Flow Part 1
Show Required Fields
GP Tech 2019 - Day 3
Hyphens in Dynamics GP Fixed Assets
GP Tech 2019 - Day 2
GP Tech 2019 - Pre-Day
GP Tech 2019 - Day 1
Where'd my navigation pane go?
Celebrating 10 years!
GPUG All*Star 2019 Voting
Excel Navigation tips
Excel's hidden gem: IFERROR
Excel VLOOKUP - numbers as text & vice versa
Excel tip - "corner" copy
MVP Renewal for 2019/2020
Dynamics GP & Office 365
Outlook credentials issue
No Canadian Payroll 2019 Mid-Year Tax Update!
Back to consulting!
Are you using what you've purchased?
Excel Paste Special - Operations
How to set a longer password on Office 365
SQL Alerts with HTML email body
In search of the perfect credit card
SmartList stuck on My Reports pane
Originating fields in SmartList
eConnect Distributions: Double Trouble?
SmartConnect, Variables & Quotes
Object reference not set to an instance of an object
Fixed Asset Labelling
SmartConnect Define Company
Mass Update CPY Basic Personal Exemption
What's included in those SQL rpt roles?
Cdn Payroll T4 XML & Multiple Employers
Fun with XML, the end
Fun with XML, part 4
Fun with XML, part 3
Fun with XML, part 2
Fun with XML, part 1
Additional menu in GP windows
Prepaid Visa Card rip-off
When did that G/L Account get added?
SmartList Options
Changing Password Managers
My write-off doesn't add up!
Keeping up with the MVP firehose
New Year's Resolutions 2019
2018
Top 10 Blog Posts from 2018
Clear Companies script & custom tables
Canadian Payroll 2018 Year End Update
Quick Journals
Backout or Correct Journal Entry
Copy Journal Entry
AutoComplete Tips
Getting a list of write-offs follow up
Getting a list of write-offs
My Reports in GP
Connecting a 2nd PC as a second monitor
Take company offline
GPUG Summit 2018 Recap
GPUG Summit 2018 Day 2
GPUG Summit 2018 Day 1
How to follow a conference or event
GPUG Summit 2018 Pre-Day
Dynamics GP is on docs.microsoft.com!
Two Factor Authentication, part 2
GP & Intelligent Cloud - first impressions
GP 2018 R2 Intelligent Cloud
Two Factor Authentication, part 1
Advanced Lookups
Excel tip: Copy & Paste Unique Values
Surface Go - First Impressions
GP Utilities user permissions part 2
Duplicate payments & internal controls
Flash Fill in Excel
PowerApps Newbie - home screen
PowerApps Newbie - project background
GP Utilities user permissions
GP Tech 2018 Wrap-up & Pennies for Taylor
GP Tech 2018 - Day 3
GP Tech 2018 - Day 2
Start/Stop SQL by Batch File
GP Tech 2018 - Day 1+
Send Message to Users
Budget Transactions vs Budget Upload
Retained Earnings account is inactive error
SSRS 2016 Report Builder Permissions
PowerApps Newbie - getting started
Getting rid of Day in Mgmt. Reporter date format
Touring the Old Post Office in Galt
Lookup window tips
Hidden shortcut on Item lookup window
MVP Renewal for 2018/2019
Remote Desktop & Multiple Monitors
Canadian Payroll 2018 Mid-Year Tax Update
Navigation Pane Options
User Preferences tips
MVP emails gone mad!
Sample SQL Views for Smartlists
Tax Schedule Tip
Upload Pending issue in Excel with OneDrive
Launching GP with alternate Dynamics.set file
Unassigned Security Report & Superuser roles
Mystery Window! Export Data (Solved!)
What does Web Client User Only do?
Forcing a SQL login in Web Client
Web Client & Account Level Security
Upgrade your company names!
Reset Home Page
Miscellaneous Check doesn't support multicurrency
Unnecessary restrictions in report options window
Currency symbols in Dynamics GP
View options for multicurrency
Multi-select serial numbers
What the MVP NDA means to me
Multicurrency troubleshooting tip
Microsoft Treehouses!
MVP Summit 2018
Tips for refreshing a test company
Assigning an item to multiple sites
Account Maintenance Options
Reverse Fiscal Year End Close
Updated documentation for CanPay Import/Export
Clear Recurring Batch Amounts
Write Off Small Customer Balances
Canadian Payroll January 2018 Hotfix
Tips for Dates in Dynamics GP
Top 10 Blog Posts from 2017
New Year’s Resolutions 2018
2017
Do you know when a SQL trigger is dropped?
Canadian Payroll 2017 Year End Update
How to tell Gin from Vodka
Collaborate Canada 2017 Follow Up
Puzzles!
Dynamics GP 2018 is released!
Collaborate Canada 2017 Vancouver
Collaborate Canada 2017 Calgary
Collaborate Canada 2017 Toronto
Collaborate Canada 2017 Montreal
WordPress Plugin "Add From Server"
Collaborate Canada 2017
Curious about presenting?
GPUG Summit 2017 - Getting Home & Recap
GPUG Summit 2017 - Day 3
GPUG Summit 2017 - Day 2
GPUG Summit 2017 - Day 1
GPUG Summit 2017 - Pre-Conference
My First Year as an MVP, part 2
My First Year as an MVP, part 1
GPUG Summit 2017 - My Presentations
GP Tech 2017 – Recap & Getting Home
GP Tech 2017 – Day 3
GP Tech 2017 - Day 2
GP Tech 2017 - Day 1
GP Tech 2017 - Getting to Fargo!
Copy & Paste Journal Entry from Excel
Combine Budgets
Fixed Assets Year End Close Report
Backups from within Dynamics GP
Reconcile a Chequebook without Transactions
GL Account Tables & Account Framework
Canadian Payroll 2017 Mid-Year Update
Transaction Descriptions & POP to PM MS Connect Suggestion
GPUG Amplify - Post Conference
GPUG Amplify 2017 - Day 2
GPUG Amplify 2017 - Day 1
GPUG Amplify 2017 - Getting here
What's your Dynamics GP story?
Women in Tech Week 2017 & Female MVPs
GPUG Amplify 2017 coming soon!
Why Edit Lists are important
Top 10 Blog Posts from 2016
New Year's Resolutions 2017
2016
Multiple instances of GP & applying service packs
Canadian Payroll 2016 Year End Update
Does Dynamics 365 mean the death of Dynamics GP?
Microsoft Connect - change the PM Payment window names!
GPUG Summit 2016 - Wrap Up
GPUG Summit 2016 - Day 3
GPUG Summit 2016 - Day 2
GPUG Summit 2016 - Day 1
GPUG Summit 2016 - Pre-Conference
GPUG Summit 2016 - Keynote Day
Becoming a Microsoft MVP for the first time
reImagine 2016 - Recap
reImagine 2016 - Day 3
reImagine 2016 - Day 2, Part 2
reImagine 2016 - Day 2, Part 1
reImagine 2016 - Day 1, Part 3
reImagine 2016 - Day 1, Part 2
reImagine 2016 - Day 1, Part 1
reImagine 2016 - Pre-Conference Training Day
reImagine 2016 - Travel Day
Fun with Writing Dynamics Pros Exam Questions
Mgmt. Reporter Quirk - Tree Filters & Unit Restrictions
Mgmt. Reporter & Reporting Ledgers
Dynamics GP Word Template Error & Compatibility Mode
Microsoft Connect - Obscure Smartlist Reminder Issue
8 Tips for Using Forums Effectively
Year End Close & the Inactive Account Myth
Cool Excel Tip: Dates without holidays included
CanPay ROE Issue with postal code
Looking for special characters in SQL
Transaction vs. Batch Posting
More Azure - Part 3
More Azure - Part 2
GPUG Amplify 2016 - Day 3
GPUG Amplify 2016 - Day 2
GPUG Amplify 2016 - Day 1 - Rest of the day
GPUG Amplify 2016 - Day 1 - General Session
GPUG Amplify 2016 - Pre-Conference
More Azure - part 1
Poor man's dashboard?
Re-branding "me" - changing my twitter handle
Mgmt. Reporter Quirk - unposted entries
Tales of shopping for a new car
How to add the Employer Address to T4 Forms
New Year's Resolutions 2016
2015
How YTD CPP & EI factor into Tax calcs
Diary of a day in jury duty
More fun with Integration Manager
The quick way to register Integration Manager
reImagine 2015 - wrap-up
reImagine 2015 - Day 3
reImagine 2015 - Day 2
reImagine 2015 - Day 1
reImagine 2015 - Arrival Day
reImagine 2015 - preparing to go to Fargo
Azure - when you forget to turn your vm off!
Pet Peeves
I'm the first Professional Member of Dynamics Pros!
Restore issue on GP 2015 drove me nuts!
Dynamics GP on Microsoft Azure - Wrap-Up
FRx with Dynamics GP 2015
Dynamics GP on Microsoft Azure - Part 6
Dynamics GP on Microsoft Azure - Part 5
Dynamics GP on Microsoft Azure - Part 4
Dynamics GP on Microsoft Azure - Part 3
Dynamics GP on Microsoft Azure - Part 2
Dynamics GP on Microsoft Azure - Part 1
Learning new things the hard way
Spammers, go away!
New Year's Resolutions 2015
2014
Don't forget about your reminders!
GP & Lowercase Database IDs
GP 2015 is released!
reImagine 2014 - Day 4
reImagine 2014 - Day 3
reImagine 2014 - Day 2
reImagine 2014 - Day before the fun begins!
reImagine 2014 - Day 1
Project Accounting mystery COGS account
Cdn Payroll - Things that make you go hmmmm
New Year’s Resolutions 2014
2013
eConnect error, but not the real error!
GP Airlift 2013 - Day 3 - Part 2 of 2
GP Airlift 2013 - Day 3 - Part 1 of 2
GP Airlift 2013 - Day 2
GP Airlift 2013 - Day 1
GP Airlift 2013 - Getting to Fargo
eConnect error “configured identity is incorrect”
Full vs Light User licenses
Update on Account Number error in Canadian Payroll
New Year’s Resolutions 2013
2012
Bizarro world: Integration Mgr “use input” doesn’t work
Fun with Windows 8
Windows 8 install tips and tricks
Dynamics GP Technical Airlift 2012 - Web Client part 2
Dynamics GP Technical Airlift 2012 - Web Client part 1
Dynamics GP Technical Airlift 2012 - Pre-Conference
Canadian Payroll & US Payroll in the same environment
Project Accounting: Misc Log eConnect import issue
Project Accounting: Update Budget Lines - the good and the ugly
Report Writer Series: The End!
Report Writer Series: Keys, Restrictions, Sorting, Grids
Report Writer Series: Custom Reports
Canadian Payroll - Transmission Header Incorrect Length error
Report Writing Series: Sections
Report Writer Series: Drawing Options Tips
Free Stuff for GP!
eConnect, GL Transactions & Multicurrency
Some Canadian Payroll & Project Accounting gotchas!
Why does the JE description say “Receivings Transaction Entry”?
Quick Tip: Smartlist Builder & Account Numbers
New Year’s Resolutions 2012
2011
Canadian Payroll issues and fixes
How secure are your passwords?
A new season begins…
Quick Comparison Report Testing Tip
Bug month! Issues with Project Accounting employee vendors & EFT
Canadian Payroll - some ROE fields demystified
Excel Report Builder - bug in SQL views created
Kudos to all the regular bloggers out there!
Client Updates & Archiving old service packs
Fun with changing a server name!
I’m back with a bug!
Microsoft extends dates for new partner cert requirements
Disenchanted with support? I understand your pain!
GP Tech Conference Day 3
GP Tech Conference Day 2
GP Tech Conference Day 1
On my way to Fargo!
Report Writer Series: Toolbox Tips
Adopting new GP2010 features
Report Writer Series: Don’t settle for ugly reports! Part 2
What happens when you hit the max Journal Entry Number
Report Writer Series: Don’t settle for ugly reports! Part 1
New Year’s Resolutions 2011
2010
The cost of inefficient processes
The Support Debugging Tool is my new best friend
Remember me! New GP2010 feature
Issues with GP2010 and uninstalling
Do you want my business?
Report Writer series: Formatting Text
How is your customer service?
Report Writer demystified - part 2 - other considerations
Report Writer demystified - part 1 - dictionaries and launch files
Find the right G/L account with Aliases
Let the User Date be your friend!
Tips & Tricks - Date Shortcuts