Dynamics GP Tips

Tips, Tricks and Shortcuts for Microsoft Dynamics GP.

Dynamics GP Tip: Beware of Maintain Inactive Accounts Option in Year End Closing

One thing that I learned the hard way during the Year-End close process is related to a newer checkbox in the Year-End Closing window. I hope that sharing my “not so fun” story will help others avoid this in the future.

By |2022-03-25T12:01:07-04:00November 29th, 2016|Dynamics GP Tips, ERP Tips & Tricks Blog, Microsoft Dynamics GP, Year/Month End Closing Tips|Comments Off on Dynamics GP Tip: Beware of Maintain Inactive Accounts Option in Year End Closing

FRx Tip for Dynamics GP: Catalog Queued Successfully

Although FRx is no longer used in the newer versions of Microsoft Dynamics GP, there are still many companies out there that continue to rely on it in older versions. And we continue to support them. Here is a recent support question and the resolution.

By |2022-03-22T16:04:45-04:00September 6th, 2016|Dynamics GP Tips, ERP Tips & Tricks Blog, Mgmt Reporter/FRx Tips, Microsoft Dynamics GP|Comments Off on FRx Tip for Dynamics GP: Catalog Queued Successfully

Microsoft Dynamics GP Tip: Which Predefined Word Templates Are Included in Dynamics GP?

The following predefined Word templates are installed with Microsoft Dynamics GP. Predefined templates cannot be modified or removed. You can make copies of the predefined templates and make your changes such as changing the font. Predefined templates do not have logos assigned to them.

By |2022-03-22T16:07:57-04:00August 12th, 2016|Dynamics GP Tips, ERP Tips & Tricks Blog, GP with Excel/Word Tips, Microsoft Dynamics GP|Comments Off on Microsoft Dynamics GP Tip: Which Predefined Word Templates Are Included in Dynamics GP?

Microsoft Dynamics GP Tip: How To Set up E-mail Document Options in Dynamics GP

Use the Company E-mail Setup window to select options to use when sending documents in e-mail. You can select to embed documents, attach documents, or both.

By |2022-03-22T16:07:57-04:00August 12th, 2016|Accounts Payable Tips, Accounts Receivable Tips, Dynamics GP Tips, ERP Tips & Tricks Blog, Microsoft Dynamics GP, Set Up/Security/Admin Tips|Comments Off on Microsoft Dynamics GP Tip: How To Set up E-mail Document Options in Dynamics GP

Microsoft Dynamics GP with Excel Tip: How to Copy/Paste GL Transactions from Excel to Microsoft Dynamics GP in 4 Easy Steps

Using Microsoft Dynamics GP and Excel are a powerful combination for any finance team. Many of our clients are asking about the steps to copy and paste General Ledger transactions from Excel into Dynamics GP. Here is the process in four simple steps.

By |2022-03-22T16:07:57-04:00August 5th, 2016|Dynamics GP Tips, ERP Tips & Tricks Blog, General Ledger Tips, GP with Excel/Word Tips, Microsoft Dynamics GP|Comments Off on Microsoft Dynamics GP with Excel Tip: How to Copy/Paste GL Transactions from Excel to Microsoft Dynamics GP in 4 Easy Steps

Microsoft Dynamics GP Tip: Cheat Sheet for Accounts Receivable Month End Processes in Microsoft Dynamics GP

This tip will cover what you need to know about printing the trial balance, historical aged trial balance, aging accounts receivable, paid transaction removed, analysis reports, reconciling A/R, finance changes, waiving finance charges, statements and write off documents.

By |2022-03-22T16:07:57-04:00July 22nd, 2016|Accounts Receivable Tips, Dynamics GP Tips, ERP Tips & Tricks Blog, Microsoft Dynamics GP|Comments Off on Microsoft Dynamics GP Tip: Cheat Sheet for Accounts Receivable Month End Processes in Microsoft Dynamics GP

Microsoft Dynamics GP Tip: Cheat Sheet for Accounts Payable Month End Processes in Microsoft Dynamics GP

In this tip you will learn what you need to know about aged trial balance, aged trial balance with options, aged historical trial balance, reconcile to GL for AP and printing a month end check register.

By |2022-03-22T16:07:57-04:00July 9th, 2016|Accounts Payable Tips, Dynamics GP Tips, ERP Tips & Tricks Blog, Microsoft Dynamics GP|Comments Off on Microsoft Dynamics GP Tip: Cheat Sheet for Accounts Payable Month End Processes in Microsoft Dynamics GP

Microsoft Dynamics GP Tip: How to Fix Assets and Re-Depreciate After You Have Posted to The GL

One of our clients ran depreciation on Fixed Assets and then the General Ledger posting routine. She realized that some of the assets were set up incorrectly and she needed to make changes on the Fixed Asset book setup.

By |2022-03-22T16:04:44-04:00April 10th, 2016|Dynamics GP Tips, ERP Tips & Tricks Blog, General Ledger Tips, Microsoft Dynamics GP|Comments Off on Microsoft Dynamics GP Tip: How to Fix Assets and Re-Depreciate After You Have Posted to The GL

Microsoft Dynamics GP Tip: How to Create SmartList Builder Reports Based on SQL Views or Tables

Have you ever been working with a SmartList and needed to add just one more piece of information to make it complete, but when you look for it in the column chooser it is not there?

By |2022-03-22T16:04:44-04:00April 4th, 2016|Dynamics GP Tips, ERP Tips & Tricks Blog, Microsoft Dynamics GP, SmartList Tips|Comments Off on Microsoft Dynamics GP Tip: How to Create SmartList Builder Reports Based on SQL Views or Tables

77 Great Tips for Dynamics GP Users

Some are old, some are new, but I bet every Dynamics GP user can find something useful. You can see all our tips sorted by category at www.calszone.com/tips. While you are there sign up to receive our e-newsletter, or automatic email alerts from our blog, so that you will never miss a new Dynamics GP tip.

By |2024-04-01T21:03:07-04:00March 15th, 2016|Dynamics GP Tips, ERP Tips & Tricks Blog, Microsoft Dynamics GP, Why Choose CAL?|Comments Off on 77 Great Tips for Dynamics GP Users

Microsoft Dynamics GP Tip: How to Bring In Open AP/AR/Inventory in Microsoft Dynamics GP

Sometimes we get stuck in our ways. Over the last 15 years I had one process to bring in open AP/AR/Inventory in Microsoft Dynamics GP. But I have found a better way.

By |2022-03-22T16:04:43-04:00October 28th, 2015|Accounts Payable Tips, Accounts Receivable Tips, Dynamics GP Tips, ERP Tips & Tricks Blog, Inventory Tips, Microsoft Dynamics GP|Comments Off on Microsoft Dynamics GP Tip: How to Bring In Open AP/AR/Inventory in Microsoft Dynamics GP

Dynamics GP Video Tip: How to Merge Customer Accounts

What happens when you realize that two accounts were set up for the same customer in Microsoft Dynamics GP? You need to merge customer accounts in Dynamics GP. See how to do this you will use the Customer Combiner and Modifier utility (formerly part of the Professional Services Tools Library (PSTL) but can now accessed from the main Sales window in Dynamics GP.)

By |2022-03-22T16:07:56-04:00July 24th, 2015|Dynamics GP Tips, ERP Tips & Tricks Blog, Microsoft Dynamics GP, Navigation Tips, Video Tips|Comments Off on Dynamics GP Video Tip: How to Merge Customer Accounts

Dynamics GP Video Tip: How to Change Customer IDs

In the customer maintenance window you do not have the ability to edit or change the customer ID after it is created. See how to use this utility to allow you to change the ID. This change will effect all transactions for that customer – current and past. It will look like the other ID never existed.

By |2022-03-22T16:07:56-04:00July 21st, 2015|Dynamics GP Tips, ERP Tips & Tricks Blog, Microsoft Dynamics GP, Navigation Tips, Video Tips|Comments Off on Dynamics GP Video Tip: How to Change Customer IDs

Dynamics GP Video Tip: Professional Services Tools Library: Receivables Transaction Unapply

All of the tools in the Professional Services Tools Library, or PSTL, are now free! But many Microsoft Dynamics GP users don’t take advantage of them. In this video series I will show you my favorite PSTL tools. Tip #2 is how to use the RM (or Receivables Management) Unapply tool in Microsoft Dynamics GP.

By |2022-03-22T16:07:56-04:00July 15th, 2015|Dynamics GP Tips, ERP Tips & Tricks Blog, Microsoft Dynamics GP, Professional Services Tools/PSTL Tips, Video Tips|Comments Off on Dynamics GP Video Tip: Professional Services Tools Library: Receivables Transaction Unapply

Dynamics GP Video Tip – Professional Services Tools Library: How to Enable ‘Doc Date Verify’

All of the tools in the Professional Services Tools Library, or PSTL, are now free! But many Microsoft Dynamics GP users don’t take advantage of them. In this video series I will show you my favorite PSTL tools. Tip #1 is how to enable doc date verify in Microsoft Dynamics GP.

By |2022-03-22T16:07:56-04:00July 15th, 2015|Dynamics GP Tips, ERP Tips & Tricks Blog, Microsoft Dynamics GP, Professional Services Tools/PSTL Tips, Video Tips|Comments Off on Dynamics GP Video Tip – Professional Services Tools Library: How to Enable ‘Doc Date Verify’

Dynamics GP Video Tip – How To Clean Up Page Layouts in MICROSOFT Dynamics GP

You can restrict security for each user in Microsoft Dynamics GP. But by default there is lots of info that shows on the screen that they can’t use. For example, a user that was set up as an AP clerk will never have access to sales, inventory, payroll etc… So why clutter up their screen with things they can’t have? In this video you will learn how to clean up the screen to only show what you need.

By |2022-03-22T16:07:56-04:00July 9th, 2015|Dynamics GP Tips, ERP Tips & Tricks Blog, Microsoft Dynamics GP, Navigation Tips, Video Tips|Comments Off on Dynamics GP Video Tip – How To Clean Up Page Layouts in MICROSOFT Dynamics GP
Go to Top