Microsoft Dynamics GP Vendor Analysis, made simple and cool

Today I want to show you how to use Excel Pivot tables and Microsoft Dynamics GP Excel Refreshable reports to create a Vendor Analysis Report that one of my customers requested. 

Today I want to show you how to use Excel Pivot tables and Microsoft Dynamics GP Excel Refreshable reports to create a Vendor Analysis Report that one of my customers requested. 

Originally Posted 6/6/11

Today I want to show you how to use Excel Pivot tables and Microsoft Dynamics GP Excel Refreshable reports to create a Vendor Analysis Report that one of my customers requested.

It provides you the total amount billed, showing paid and unpaid for a specified Time period. This is a great tool to assist in Budgeting and Month End Closings.

Continue reading “Microsoft Dynamics GP Vendor Analysis, made simple and cool”

Microsoft Dynamics GP Inter-Company Setup and Transactions

Today is all about setting up and using the Intercompany module in Microsoft Dynamics GP. I create a payables transaction as an example of how this module works. 

Today is all about setting up and using the Intercompany module in Microsoft Dynamics GP. I create a payables transaction as an example of how this module works. 

Originally Posted 6/2/11

Today is all about setting up and using the Inter-company module in Microsoft Dynamics GP. I create a Payables transaction as an example of how this module works.

Continue reading “Microsoft Dynamics GP Inter-Company Setup and Transactions”

Microsoft Dynamics GP Sales Order Processing Analysis in Excel

Use Microsoft Dynamics GP Excel Refreshable Reports to create amazing Sales Order Processing (SOP) analysis Reports. Pivot Tables never looked so good! 

Use Microsoft Dynamics GP Excel Refreshable Reports to create amazing Sales Order Processing (SOP) analysis Reports. Pivot Tables never looked so good! 

Originally Posted 6/1/2011

Use Microsoft Dynamics GP Excel Refreshable Reports to create amazing Sales Order Processing (SOP) analysis Reports. Pivot Tables never looked so good!

Continue reading “Microsoft Dynamics GP Sales Order Processing Analysis in Excel”

Write off Routine in Microsoft Dynamics GP Receivables

This video shows both methods of writing off invoices in Receivables Management and where it gets the GL account numbers to write off to using Microsoft Dynamics GP. 

This video shows both methods of writing off invoices in Receivables Management and where it gets the GL account numbers to write off to using Microsoft Dynamics GP. 

Originally Posted 5/31/11

This video shows both methods of writing off invoices in Receivables Management and where it gets the GL account numbers to write off to using Microsoft Dynamics GP.

Continue reading “Write off Routine in Microsoft Dynamics GP Receivables”

“Suggested Sales Items” – Microsoft Dynamics GP

Upselling with Microsoft Dynamics GP Suggested items in Sales Order Processing.

Upselling with Microsoft Dynamics GP Suggested items in Sales Order Processing.

Originally Posted 5/4/2011

We’ve all been to a restaurant and ordered an entrée only to have the wait person suggest some additional side or appetizer based on our entrée selection.  This is known as “upselling.”  We’ve also been in the situation where we have seen a newspaper advertisement for a product on sale only to get to the store to see another version of the sale product that is better but not on sale.  This is known as a “loss leader.”

It is probable that you’ve bought the extra side dish or the “non-sale” more expensive item in both of the situations above at least once.

Continue reading ““Suggested Sales Items” – Microsoft Dynamics GP”

Make Microsoft Dynamics GP SmartList work for you & Receivables

This video was made to show how to use Microsoft Dynamics GP SmartList for the practical tool of managing Documents.

Originally Posted March 18, 2011

This video was made to show how to use Microsoft Dynamics GP SmartList for the practical tool of managing what Credits, Returns and Payments need to be applied in Receivables Management. It also includes add SmartList to your menu bar and using Reminders on the Home Page.                         

Continue reading “Make Microsoft Dynamics GP SmartList work for you & Receivables”