Microsoft Dynamics GP Generate Suggested Purchase Orders window

In this Video I will show you how the Generate Suggested Microsoft Dynamics GP Purchase Orders window generated a list of potential purchase order line items from which purchase orders can be created automatically to replenish inventory levels. Then I will turn 1 line item into a Purchase Order. 

Originally Posted 6/23/11

In this Video I will show you how the Generate Suggested Microsoft Dynamics GP Purchase Orders window generated a list of potential purchase order line items from which purchase orders can be created automatically to replenish inventory levels. Then I will turn 1 line item into a Purchase Order. 

In this Video I will show you how the Generate Suggested Microsoft Dynamics GP Purchase Orders window generated a list of potential purchase order line items from which purchase orders can be created automatically to replenish inventory levels. Then I will turn 1 line item into a Purchase Order.

Continue reading “Microsoft Dynamics GP Generate Suggested Purchase Orders window”

Receive Shipment or Receive Shipment AND Invoice in Microsoft Dynamics GP?

In this Video I highlight the differences and processes for Receiving a Microsoft Dynamics GP Purchase Order Processing Shipment and a Shipment with Invoice. 

In this Video I highlight the differences and processes for Receiving a Microsoft Dynamics GP Purchase Order Processing Shipment and a Shipment with Invoice. 

Originally Posted 6/16/11

In this Video I highlight the differences and processes for Receiving a Microsoft Dynamics GP Purchase Order Processing Shipment and a Shipment with Invoice.

Continue reading “Receive Shipment or Receive Shipment AND Invoice in Microsoft Dynamics GP?”

Receiving all Microsoft Dynamics GP Purchase Orders!

OK, I’m not receiving ALL purchase orders, just 1. Follow me through receiving an invoice and shipment in Microsoft Dynamics GP  for an actual Purchase Order for Smith & Allen Consulting, Inc. After I receive the invoice, I’ll close the PO to History and verify the invoice posted using Inquiry. 

OK, I’m not receiving ALL purchase orders, just 1. Follow me through receiving an invoice and shipment in Microsoft Dynamics GP  for an actual Purchase Order for Smith & Allen Consulting, Inc. After I receive the invoice, I’ll close the PO to History and verify the invoice posted using Inquiry. 

Originally Posted 6/13/11

OK, I’m not receiving ALL purchase orders, just 1. Follow me through receiving an invoice and shipment in Microsoft Dynamics GP  for an actual Purchase Order for Smith & Allen Consulting, Inc. After I receive the invoice, I’ll close the PO to History and verify the invoice posted using Inquiry.

Continue reading “Receiving all Microsoft Dynamics GP Purchase Orders!”

Microsoft Dynamics GP Intra-Company (Interfund) Setup and Transactions

We’ve looked at the Inter-company module in Microsoft Dynamics GP, so now let’s look at the Interfund Management Module.

We’ve looked at the Inter-company module in Microsoft Dynamics GP, so now let’s look at the Interfund Management Module.

Originally Posted 6/7/11

We’ve looked at the Inter-company module in Microsoft Dynamics GP, so now let’s look at the Interfund Management Module.

This module is used in Not for Profits to balance funds within the company AND is used at for Profit Companies to balance Due To/Due From accounts when multiple companies exist in a single database.

Continue reading “Microsoft Dynamics GP Intra-Company (Interfund) Setup and Transactions”

Microsoft Dynamics GP GL Trial Balance made easy with Excel Pivot Tables

This video shows how to create a very easy, REFRESHABLE, General Ledger Summary Trial Balance using Microsoft Dynamics GP Excel Refreshable Reports. The power’s in the Pivot! 

Originally Posted 6/6/11

This video shows how to create a very easy, REFRESHABLE, General Ledger Summary Trial Balance using Microsoft Dynamics GP Excel Refreshable Reports. The power’s in the Pivot!

Note this is an older post, but this method still exists and is super easy, so it’s still valuable.

Continue reading “Microsoft Dynamics GP GL Trial Balance made easy with Excel Pivot Tables”

Post To vs. Post Through in Microsoft Dynamics GP Posting Setup

What’s the difference between “Post To” and “Post Through” in Posting Setup in Microsoft Dynamics GP? I’ll show you now! 

What’s the difference between “Post To” and “Post Through” in Posting Setup in Microsoft Dynamics GP? I’ll show you now! 

Originally Posted 6/6/11

What’s the difference between “Post To” and “Post Through” in Posting Setup in Microsoft Dynamics GP? I’ll show you now!

Continue reading “Post To vs. Post Through in Microsoft Dynamics GP Posting Setup”

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”