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

Using Microsoft Dynamics GP Source Documents to identify GL entries

Today I want to talk about identifying journal entries in Microsoft Dynamics GP that come from a particular source. An example of this would be entries that come from your CPA.

Originally Posted 9/6/2012

Today I want to talk about identifying journal entries in Microsoft Dynamics GP that come from a particular source. An example of this would be entries that come from your CPA. Whether the entries are received after a month end financial statement review, end-of-the-year review or after an annual audit you may want to track that these entries come from your CPA rather than your internal team.

Today I want to talk about identifying journal entries in Microsoft Dynamics GP that come from a particular source. An example of this would be entries that come from your CPA.

The easiest way to accomplish this in Microsoft Dynamics GP is to create a new source document. Every journal entry in the general ledger is assigned a source document to identify where this entry originated. For example, if this entry came from payables management module and was an invoice the source document would PMTRX. So let’s create a source document called CPA to identify all transactions that we receive from our CPA.

Continue reading “Using Microsoft Dynamics GP Source Documents to identify GL entries”

Microsoft Dynamics GP – Voiding in Payables Management

This video reviews the date “Gotchas” in Dynamics GP Payables voiding.

Originally Posted 10/12/2011

This video reviews the date “Gotchas” in Dynamics GP Payables voiding.

Continue reading “Microsoft Dynamics GP – Voiding in Payables Management”

Microsoft Dynamics GP Payables and Intercompany

When you enter an Intercompany transaction in Microsoft Dynamics GP Payables Management, the posting must be set to update General Ledger.

Originally Posted October 6, 2011

When you enter an Intercompany transaction in Microsoft Dynamics GP Payables Management, the posting must be set to update General Ledger. Transactions are not posted to destination companies until they are posted in the originating company’s General Ledger.

Continue reading “Microsoft Dynamics GP Payables and Intercompany”

Microsoft Dynamics GP Sales Order Processing Deposits

Today I’ll show you how to enter Deposits with Microsoft Dynamics GP Sales Order Processing (SOP) Documents.

Originally Posted September 19, 2011

Today I’ll show you how to enter Deposits with Microsoft Dynamics GP Sales Order Processing (SOP) Documents. I’ll specifically show: 

Continue reading “Microsoft Dynamics GP Sales Order Processing Deposits”

Microsoft Dynamics GP Revenue/Expense Deferrals

Here I’ll show you how easy it is to defer Revenue over a specified period of time in Dynamics GP. I’ll setup a Deferral Profile to make a template for commonly used deferrals. No more manually deferring, let GP do it for you!

Originally Posted 8/23/11 

Here I’ll show you how easy it is to defer Revenue over a specified period of time in Dynamics GP. I’ll setup a Deferral Profile to make a template for commonly used deferrals. No more manually deferring, let GP do it for you!

Continue reading “Microsoft Dynamics GP Revenue/Expense Deferrals”

Microsoft Dynamics GP Activity Tracking

In this video I show you where to setup and print reports for various forms of activity tracking in Microsoft Dynamics GP v2010 r2

Originally Posted August 15, 2011

In this video I show you where to setup and print reports for various forms of activity tracking in Microsoft Dynamics GP v2010 r2. I show an example of tracking GL transaction posting, even printing the report that shows the results of my tracking. Need to know what is happening to your data or who is doing what? Then this video is for you. 

Continue reading “Microsoft Dynamics GP Activity Tracking”