Category: Microsoft Dynamics GP

Dynamics GP Payables Management or Fancy Check Writing System?

Do not use Dynamics GP Payables Management for a fancy check writing system, use it for Managing Payables!

Tips on Microsoft Dynamics GP from Belinda Allen.

Originally Posted 8/1/2012

Do not use Dynamics GP Payables Management for a fancy check writing system, use it for Managing Payables!
Enter invoices in every day, use the correct payment terms (making sure they are setup right) and then the system will help you:
  • Determine when to pay an invoice, so you keep the cash flow as long as possible
  • Pay Invoices on time, so your credit stays good
  • Allow you use the system to manage disputed invoices (by using the hold feature)
  • Look Good to your boss, because at month end your work will be all done!

Microsoft Dynamics GP Inventory Item Cost

In this video I will walk you through the scenario where receiving items (both with and without Lot Numbers) in Microsoft Dynamics GP can create an entry where the Lot Number is duplicated with a quantity of 1 with a Cost much higher than the remaining items.

In this video I will walk you through the scenario where receiving items (both with and without Lot Numbers) in Microsoft Dynamics GP can create an entry where the Lot Number is duplicated with a quantity of 1 with a Cost much higher than the remaining items.

Originally Posted 8/1/2012

In this video I will walk you through the scenario where receiving items (both with and without Lot Numbers) in Microsoft Dynamics GP can create an entry where the Lot Number is duplicated with a quantity of 1 with a Cost much higher than the remaining items.

Continue reading “Microsoft Dynamics GP Inventory Item Cost”

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

Microsoft Dynamics GP – Add a Comment on Your Check (With Video)

While visiting with a client this week, I was asked how a comment can be placed on a Microsoft Dynamics GP AP check. Apparently this client needs to occasionally, for a few specific vendors, put information on the comment or memo field of the check itself.

While visiting with a client this week, I was asked how a comment can be placed on a Microsoft Dynamics GP AP check. Apparently this client needs to occasionally, for a few specific vendors, put information on the comment or memo field of the check itself.

Originally Posted 6/7/12

While visiting with a client this week, I was asked how a comment can be placed on a Microsoft Dynamics GP AP check. Apparently this client needs to occasionally, for a few specific vendors, put information on the comment or memo field of the check itself.

Continue reading “Microsoft Dynamics GP – Add a Comment on Your Check (With Video)”

Void a Partially Applied Payables Credit Memo in Microsoft Dynamics GP

Ever try to void a Payables Credit Memo, Return or Payment in Microsoft Dynamics GP only to receive the error message that is it either on hold or partially applied?

Ever try to void a Payables Credit Memo, Return or Payment in Microsoft Dynamics GP only to receive the error message that is it either on hold or partially applied?

Originally Posted 5/10/12

Ever try to void a Payables Credit Memo, Return or Payment in Microsoft Dynamics GP only to receive the error message that is it either on hold or partially applied?

Removing a hold is easy, but what do you do if it is partially applied.

In this video I will walk you through the easiest way I found to handle just this scenario!

Continue reading “Void a Partially Applied Payables Credit Memo in Microsoft Dynamics GP”

Microsoft Dynamics GP – Manage Purchase Orders with Excel

If you use Microsoft Dynamics GP and have ever wanted to easier way to monitor open purchase orders and line items that have been received and not invoiced, you’re in luck.

If you use Microsoft Dynamics GP and have ever wanted to easier way to monitor open purchase orders and line items that have been received and not invoiced, you’re in luck.

Originally Posted 5/7/2012

If you use Microsoft Dynamics GP and have ever wanted to easier way to monitor open purchase orders and line items that have been received and not invoiced, you’re in luck.

I will show you how to use Excel Refreshable Reports to monitor both Open and Historical Invoices.  It’s easier than you might think!

Continue reading “Microsoft Dynamics GP – Manage Purchase Orders with Excel”

Microsoft Dynamics GP – Miscellaneous Check

Need to print a single check for a one time purchase using Microsoft Dynamics GP?

In this video, I’ll show you how to do just that!  I’ll use the Miscellaneous Check Entry Window to avoid having to setup a vendor to get 1 check.

Originally Posted 5/4/2012

Need to print a single check for a one time purchase using Microsoft Dynamics GP?

In this video, I’ll show you how to do just that!  I’ll use the Miscellaneous Check Entry Window to avoid having to setup a vendor to get 1 check.

Continue reading “Microsoft Dynamics GP – Miscellaneous Check”

Microsoft Dynamics GP Inventory cost variance on PO’s (with video)

What happens if you receive a shipment in Microsoft Dynamics GP Purchase Order Processing and the invoice comes in for a different dollar amount? 

What happens if you receive a shipment in Microsoft Dynamics GP Purchase Order Processing and the invoice comes in for a different dollar amount? 

Originally Posted 5/2/12

Q:  What happens if you receive a shipment in Microsoft Dynamics GP Purchase Order Processing and the invoice comes in for a different dollar amount?
A:   That depends on how you set up the item in inventory.

Continue reading “Microsoft Dynamics GP Inventory cost variance on PO’s (with video)”

Microsoft Dynamics GP SmartList Comparison Fields

This is a cool way to use SmartList! Comparing 2 similar Microsoft Dynamics GP fields makes creating a list of Customers over their credit limit a snap! See how I do it.

Originally Posted 6/21/2011

This is a cool way to use SmartList! Comparing 2 similar Microsoft Dynamics GP  fields makes creating a list of Customers over their credit limit a snap! See how I do it.                         

Continue reading “Microsoft Dynamics GP SmartList Comparison Fields”

What’s the deal with the Apply Date in Microsoft Dynamics GP Payables?

The Apply Date that shows in the apply window for Microsoft Dynamics GP Payables has an important role. The apply date that is used when the invoice becomes fully applied will become the “Date Invoice Paid Off.”

The Apply Date that shows in the apply window for Microsoft Dynamics GP Payables has an important role. The apply date that is used when the invoice becomes fully applied will become the "Date Invoice Paid Off."
Posted April 2012
The Apply Date that shows in the apply window for Microsoft Dynamics GP Payables has an important role. The apply date that is used when the invoice becomes fully applied will become the “Date Invoice Paid Off.”
This field of “Date Invoice Paid Off” will determine when to display an invoice on a Historical Aged Trial Balance AND when to include the invoice’s 1099 amounts on the 1099.