Tag: Great Plains

Creating a Microsoft SQL Server view from 2 Microsoft Dynamics GP Databases (Video)

In the following video I will show how to create a single Microsoft SQL Server View using 2 Microsoft Dynamics GP databases.

Someone reading my book asked me the following question:

Do you know or can point me in the right direction on how to join or union other company databases? For example we have 4 companies with separate databases and these queries will only pull from one company at a time

In the following video I will show how to create a single Microsoft SQL Server View using 2 Microsoft Dynamics GP databases. Continue reading “Creating a Microsoft SQL Server view from 2 Microsoft Dynamics GP Databases (Video)”

Using a separate Fulfillment Process in Microsoft Dynamics GP

In this Video I will show the various methods of fulfilling an Invoice in Microsoft Dynamics GP Sales Order processing.

Originally Posted 1/29/16

In this Video I will show the various methods of fulfilling an Invoice in Microsoft Dynamics GP Sales Order processing.

Continue reading “Using a separate Fulfillment Process in Microsoft Dynamics GP”

Date Shortcut & New Year Hack for Microsoft Dynamics GP

In this video I will show you how I enter dates in Microsoft Dynamics GP, saving entry time.

Originally Posted 1/4/2016

In this video I will show you how I enter dates in Microsoft Dynamics GP, saving entry time.

Continue reading “Date Shortcut & New Year Hack for Microsoft Dynamics GP”

GPUG Announces Three New All Stars during Summit 2014

By Katie Froeber posted 10-17-2014 02:24 PM

The Microsoft Dynamics GP User Group (GPUG®) recognized the 2014 GPUG All Star Award recipients during today during the Ask The All Stars closing session of GPUG Summit.

 

 

Continue reading “GPUG Announces Three New All Stars during Summit 2014”

Microsoft Dynamics GP Dropship Quantity Variance

Handling DropShip variances in Microsoft Dynamics GP.

Originally Posted 10/2/2014

You know I love questions on Microsoft Dynamics GP and recently I was asked the following question:

What happens when the drop-ship item in the SO is for quantity 10 and the vendor sends 11 and the PO invoice is received with 11. The inventory was already sent to the customer; the SOP Entry program will not allow you to change to 11. Since you already received, you cannot change the PO. Any thoughts? 

Inventory

Continue reading “Microsoft Dynamics GP Dropship Quantity Variance”

Microsoft Dynamics GP Accounts Payable Cool Idea for check!

I was entering cash receipts into my Microsoft Dynamics GP this morning when I noticed that one of my customers put their AP email address right on the address of the check.

Originally Posted 8/18/2014

I was entering cash receipts into my Microsoft Dynamics GP this morning when I noticed that one of my customers put their AP email address right on the address of the check.

Continue reading “Microsoft Dynamics GP Accounts Payable Cool Idea for check!”

Multi Select in Microsoft Dynamics GP POP Return

Using the Web Client in Microsoft Dynamics GP, I show the new GP2013 feature of being able to select multiple serial numbers using standard Windows commands.

Originally Posted 6/3/2014

Using the Web Client in Microsoft Dynamics GP, I show the new GP2013 feature of being able to select multiple serial numbers using standard Windows commands (CTRL to select non-sequential items and SHIFT to select sequential items.)

Continue reading “Multi Select in Microsoft Dynamics GP POP Return”

Microsoft Excel Power Maps in Power BI

This AWESOME Power BI tool allows you to “Visualize” your data not only in a map, but as a video over a period of time.

Originally Posted 6/2/14

This AWESOME Power BI tool allows you to “Visualize” your data not only in a map, but as a video over a period of time.  It allows you to SEE your data in ways you never even thought amount.  Take a tour with me of Elevator Complaints in New York City for Q1, 2014.

Continue reading “Microsoft Excel Power Maps in Power BI”

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)”