Cloud Wars
  • Home
  • Top 10
  • CW Minute
  • CW Podcast
  • Categories
    • AI and Copilots
    • Innovation & Leadership
    • Cybersecurity
    • Data
  • Member Resources
    • Cloud Wars AI Agent
    • Digital Summits
    • Guidebooks
    • Reports
  • About Us
    • Our Story
    • Tech Analysts
    • Marketing Services
  • Summit NA
  • Dynamics Communities
  • Ask Copilot
Twitter Instagram
  • Summit NA
  • Dynamics Communities
  • AI Copilot Summit NA
  • Ask Cloud Wars
Twitter LinkedIn
Cloud Wars
  • Home
  • Top 10
  • CW Minute
  • CW Podcast
  • Categories
    • AI and CopilotsWelcome to the Acceleration Economy AI Index, a weekly segment where we cover the most important recent news in AI innovation, funding, and solutions in under 10 minutes. Our goal is to get you up to speed – the same speed AI innovation is taking place nowadays – and prepare you for that upcoming customer call, board meeting, or conversation with your colleague.
    • Innovation & Leadership
    • CybersecurityThe practice of defending computers, servers, mobile devices, electronic systems, networks, and data from malicious attacks.
    • Data
  • Member Resources
    • Cloud Wars AI Agent
    • Digital Summits
    • Guidebooks
    • Reports
  • About Us
    • Our Story
    • Tech Analysts
    • Marketing Services
    • Login / Register
Cloud Wars
    • Login / Register
Home » Tip Tuesdays 2019
News

Tip Tuesdays 2019

Jen KuntzBy Jen KuntzJanuary 16, 2021Updated:June 18, 20212 Mins Read
Facebook Twitter LinkedIn Email
Share
Facebook Twitter LinkedIn Email

Hi everyone,

I had been accumulating these posts in a thread in the Open Forum throughout 2019 but it’s time to summarize in this blog for the year.

My 2018 tips blog is here: https://www.gpug.com/blogs/jen-kuntz/2019/03/12/tip-tuesdays-2018

My 2019 tips were:

January 2019

  • no tips! (boooooo! Ya, life got in the way… !)

February 2019

  • Why your RM HATB Write Off doesn’t seem to add up
  • SmartList Options window
  • Smartlist-based Reminders in Dynamics GP using new GL Accounts as an example
  • Additional menus in Dynamics GP

March 2019

  • Canadian Payroll T4 XML with multiple employers
  • SQL tip: what permissions are in those rpt_* roles in SQL (for GP SSRS reports etc.)?
  • Mass update Canadian Payroll Basic Personal Exemption amounts
  • SmartConnect Define Company feature

April 2019

  • Fixed Assets – IDs vs Asset Labels
  • SmartConnect error: Object reference not set to an instance of an object
  • SmartConnect: 2 tips in 1 around variables
  • eConnect & duplicate GL distributions on PM Trx
  • “Originating” fields in Account Transaction SmartList

May 2019

  • How to remove stuck Smartlist favourites from your MyReports pane
  • How to send SQL db mail with an HTML table in the body of the email
  • Office 365 & 256 char passwords – Reset Password doesn’t work yet
  • Excel Paste Special operations

June 2019

  • Are you using what you purchased with Dynamics GP?
  • No mid-year CanPay tax update
  • Outlook credentials issue
  • Dynamics GP & Office 365 Email

July 2019

  • Excel “Corner Copy”
  • Excel VLOOKUP with numbers and text 
  • Excel IFERROR 
  • Excel Navigation Tips 

August 2019

  • Sad trombone… no tips!

September 2019

  • Where did my Navigation Pane go?
  • Hyphens or Dashes in Fixed Assets
  • Show Required Fields
  • Smartlist Tips – “the basics”

October 2019

  • SmartList Tips – printing & exporting
  • SmartList Tips – working with columns
  • SmartList Tips – favorites 
  • SmartList Tips – search 

November 2019

  • Excel tip – checking if something is valid (is “X” in the list?)
  • How to copy a budget in Dynamics GP
  • SmartList Tips – SmartList Export Options
  • Year End tax update planning (especially for GP 2018 users!)

December 2019

  • no tips! 

Dynamics GP
Share. Facebook Twitter LinkedIn Email
Jen Kuntz

I am a Chartered Professional Accountant (CPA, CGA), a Microsoft MVP in Business Applications, a GPUG All-Star, and an Advanced Credentialed Professional for Dynamics GP. I have been working with Microsoft Dynamics GP (formerly called Great Plains) since 1999! I'm a regular blogger (my website is https://jenkuntz.ca) and occasionally am presenting on a GPUG webinar, at a local user group meeting or at a GP-related conference.

Related Posts

Oracle and AWS Ceasefire Triggers 10 Big Benefits for Customers

July 14, 2025

Microsoft, Gong Detail How AI and Integration Partnership Drives Higher Sales Performance

June 24, 2025

Enterprises Ramp Up Use of Multiple AI Models, Third-Party Apps, and AI-Native Innovators

June 20, 2025

Microsoft Showcases Real-World Use of Model Context Protocol (MCP) In Vertical Industry App

June 19, 2025
Add A Comment

Comments are closed.

Recent Posts
  • U.K. Government Partners with Google Cloud to Modernize Infrastructure and Upskill 100,000 Workers
  • Thailand Turns to Microsoft Azure AI for Legal System Overhaul
  • SAP Q2 Outlook: I Expect Cloud Revenue to Rise 27%, Cloud Backlog 29%
  • Microsoft Drives AI and Copilot Functionality Deeper Into Top Security Platforms
  • SAP Q2 Preview: Cloud Revenue Will Grow 27%, Cloud Backlog 29%

  • Ask Cloud Wars AI Agent
  • Tech Guidebooks
  • Industry Reports
  • Newsletters

Join Today

Most Popular Guidebooks and Reports

SAP Business Network: A B2B Trading Partner Platform for Resilient Supply Chains

July 10, 2025

Using Agents and Copilots In M365 Modern Work

March 11, 2025

AI Data Readiness and Modernization: Tech and Organizational Strategies to Optimize Data For AI Use Cases

February 21, 2025

Special Report: Cloud Wars 2025 CEO Outlook

February 12, 2025

Advertisement
Cloud Wars
Twitter LinkedIn
  • Home
  • About Us
  • Privacy Policy
  • Get In Touch
  • Marketing Services
  • Do not sell my information
© 2025 Cloud Wars.

Type above and press Enter to search. Press Esc to cancel.

  • Login
Forgot Password?
Lost your password? Please enter your username or email address. You will receive a link to create a new password via email.
body::-webkit-scrollbar { width: 7px; } body::-webkit-scrollbar-track { border-radius: 10px; background: #f0f0f0; } body::-webkit-scrollbar-thumb { border-radius: 50px; background: #dfdbdb }