Dynamics GP Tips

Tips, Tricks and Shortcuts for Microsoft Dynamics GP.

Microsoft Dynamics GP with Excel Tip: Use Conditional Formatting to View Item Quantities

Once you have your data from Microsoft Dynamics GP into Microsoft Excel, there is so much more you can do with it. This short video will show you how to use formatting tools to pin point Item Quantities. Learn how to; quickly format your database as a table and use Conditional Formatting to automatically draw attention to specific quantities.

By |2022-03-22T16:04:41-04:00November 6th, 2014|Dynamics GP Tips, ERP Tips & Tricks Blog, GP with Excel/Word Tips, Microsoft Dynamics GP, Video Tips|Comments Off on Microsoft Dynamics GP with Excel Tip: Use Conditional Formatting to View Item Quantities

SalesPad Tip: Search Faster and View User Defined Fields in Dynamics GP with Additions GP from SalesPad

Additions GP is a fairly new, but very cool, offering from SalesPad for Microsoft Dynamics GP. It was originally designed to work with SalesPad Card Control but now it is sold separately in a site license based model. It comes in two “flavors”: Search and User Defined Fields.

By |2023-08-07T20:04:48-04:00November 3rd, 2014|Add On Tool Tips, Cavallo, Cavallo Tips, Distribution Industry, ERP Tips & Tricks Blog, Marketplace/ISV Partners, Microsoft Dynamics GP|Comments Off on SalesPad Tip: Search Faster and View User Defined Fields in Dynamics GP with Additions GP from SalesPad

Microsoft Dynamics GP with Excel Tip: Filter Unreconciled Bank Transactions using Pivot Tables and Slicers

Microsoft Dynamics GP was built to work with Microsoft Dynamics Excel. In this short video you will learn how to: Create a PivotTable, Quickly reproduce Pivot table background data and Insert and use Slicers to filter data from Microsoft Dynamics GP.

By |2021-11-09T10:45:37-05:00October 23rd, 2014|Dynamics GP Tips, ERP Tips & Tricks Blog, GP with Excel/Word Tips, Microsoft Dynamics GP, Video Tips|Comments Off on Microsoft Dynamics GP with Excel Tip: Filter Unreconciled Bank Transactions using Pivot Tables and Slicers

Microsoft Dynamics GP with Excel Tip: Create a Pivot Table for General Ledger Data

Once you export your General Ledger report from Microsoft Dynamics GP to Microsoft Excel there is so much you can do with it. This video will show you a few helpful tricks around pivot tables. Pivot tables are the best way to summarize large amounts of data and focus on the information you need.

By |2021-11-09T10:45:38-05:00October 7th, 2014|Dynamics GP Tips, ERP Tips & Tricks Blog, General Ledger Tips, GP with Excel/Word Tips, Microsoft Dynamics GP, Video Tips|Comments Off on Microsoft Dynamics GP with Excel Tip: Create a Pivot Table for General Ledger Data

Dynamics GP WOW Moments: Using SmartList to Find Data Fast

See Microsoft Dynamics GP SmartLists in action. SmartLists help you to quickly find the information you need within your accounting software and then easily use that information in Microsoft Office Excel and Microsoft Office Word.

By |2022-03-25T14:19:42-04:00May 30th, 2013|Dynamics GP Demo/Videos, Dynamics GP Tips, ERP Tips & Tricks Blog, Microsoft Dynamics GP, SmartList Tips, Video Tips|Comments Off on Dynamics GP WOW Moments: Using SmartList to Find Data Fast

Dynamics GP WOW Moments: Excel Reports with Refreshable Data-Always LIVE, All the Time

Today’s financial reports are out of date almost before they are sent out. Microsoft Dynamics GP with Microsoft Office Data Connection for Excel 2007 is the answer. Excel users within your organization can have secure access to up-to-date live reports from your Microsoft Dynamics GP accounting software – all the time.

By |2022-03-25T14:22:00-04:00May 30th, 2013|Dynamics GP Demo/Videos, Dynamics GP Tips, ERP Tips & Tricks Blog, GP with Excel/Word Tips, Microsoft Dynamics GP, Video Tips|Comments Off on Dynamics GP WOW Moments: Excel Reports with Refreshable Data-Always LIVE, All the Time

Dynamics GP WOW Moments: 3 Steps to Writing a Collections Letter

The tight integration between Dynamics GP and Microsoft Office Word make it easy to prepare professional customer and vendor letters from your ERP system.  Learn how to prepare a customized collections letter in 3 quick steps.

By |2022-03-25T14:19:18-04:00May 30th, 2013|Dynamics GP Demo/Videos, Dynamics GP Tips, ERP Tips & Tricks Blog, Microsoft Dynamics GP, Video Tips|Comments Off on Dynamics GP WOW Moments: 3 Steps to Writing a Collections Letter
Go to Top