Using Microsoft Excel to create a Dynamics GP auto refreshing report (Video)

Last week, a Microsoft Dynamics GP User (Glenda) asked about making an Excel Refreshable Report refreshable.  She not only wanted the table to refresh, but she wanted the associated PivotTable to refresh as well. 

Last week, a Microsoft Dynamics GP User (Glenda) asked about making an Excel Refreshable Report refreshable.  She not only wanted the table to refresh, but she wanted the associated PivotTable to refresh as well.

Microsoft Dynamics GP User Group.

Continue reading “Using Microsoft Excel to create a Dynamics GP auto refreshing report (Video)”

It’s time to consider using Microsoft Dynamics GP Account Categories

With all the reporting options available that can easily access Microsoft Dynamics GP data, it’s time to consider using, if you are not already doing so, the General Ledger Account Category.

With all the reporting options available that can easily access Microsoft Dynamics GP data, it’s time to consider using, if you are not already doing so, the General Ledger Account Category.

With all the reporting options available that can easily access Microsoft Dynamics GP data, it’s time to consider using, if you are not already doing so, the General Ledger Account Category.

Continue reading “It’s time to consider using Microsoft Dynamics GP Account Categories”

Easy way to kind close a period in Microsoft Dynamics GP (with Video)

Need to stop people from entering and posting information Microsoft Dynamics GP for a period that has already completed with final Financial Statements?

Originally Posted 5/6/14

Need to stop people from entering and posting information Microsoft Dynamics GP for a period that has already completed with final Financial Statements?

Continue reading “Easy way to kind close a period in Microsoft Dynamics GP (with Video)”

Microsoft Dynamics GP 2013–Lookup feature (with video)

When looking up master records in Microsoft Dynamics GP, you can save any custom sort order you create.

Belinda Allen from Njevity, Inc. shares information on Microsoft Dynamics GP.

Originally Posted 11/13/13

When looking up master records in Microsoft Dynamics GP, you can save any custom sort order you create.   Watch this very short video on how to do it.

Continue reading “Microsoft Dynamics GP 2013–Lookup feature (with video)”

Balancing Payables to General Ledger Microsoft Dynamics GP

In this video I walk through the steps I use when I start a project balancing Payables to the General Ledger in Microsoft Dynamics GP.

Originally Posted August 8, 2013

In this video I walk through the steps I use when I start a project balancing Payables to the General Ledger in Microsoft Dynamics GP.

Continue reading “Balancing Payables to General Ledger Microsoft Dynamics GP”

When did it post in Microsoft Dynamics GP (with video)

I noticed today the following message from a Microsoft Dynamics GP user on GPUG Collaborate:

Does anyone know how to run a trial balance or JE listing out of GP or a Smartlist that shows the date that the entry was originally recorded?  For instance, all December 2012 entries that were recorded and posted after January 15, 2013. 

I noticed today the following message from a Microsoft Dynamics GP user on GPUG Collaborate: Does anyone know how to run a trial balance or JE listing out of GP or a Smartlist that shows the date that the entry was originally recorded?  For instance, all December 2012 entries that were recorded and posted after January 15, 2013. 

I noticed today the following message from a Microsoft Dynamics GP user on GPUG Collaborate:

Does anyone know how to run a trial balance or JE listing out of GP or a Smartlist that shows the date that the entry was originally recorded?  For instance, all December 2012 entries that were recorded and posted after January 15, 2013. 

Microsoft Partner Rod O’Connor from Briware Solutions gave a great answer regarding how to have this show in SmartList.

Continue reading “When did it post in Microsoft Dynamics GP (with video)”

Microsoft Dynamics GP Bank Rec out of balance to your GL?

There are two common reasons why the Microsoft Dynamics GP Bank Reconciliation Checkbook Balance and the General Ledger Checkbook Balance do not match.

Originally Posted 7/31/2012

Microsoft Dynamics GP User Group.

The following is an exerpt from the GPUG Tech Tips for August 2012.

There are two common reasons why the Microsoft Dynamics GP Bank Reconciliation Checkbook Balance and the General Ledger Checkbook Balance do not match.

Most Common Reasons for Variances in Balances
There are two common reasons why the Microsoft Dynamics GP Bank Reconciliation Checkbook Balance and the General Ledger Checkbook Balance do not match.

 

Continue reading “Microsoft Dynamics GP Bank Rec out of balance to your GL?”