Category: GP Financials

Microsoft Dynamics GP GL Report for your CPA

Do you need to dump your General Ledger Transactions from Microsoft Dynamics GP into Microsoft Excel for your CPA, either for your annual audit or monthly?  This video shows you how to do just that.  We’ll useSmartList in GP and the Subtotal feature of Excel.

Originally Posted 2/20/12

Do you need to dump your General Ledger Transactions from Microsoft Dynamics GP into Microsoft Excel for your CPA, either for your annual audit or monthly?  This video shows you how to do just that.  We’ll useSmartList in GP and the Subtotal feature of Excel.

Continue reading “Microsoft Dynamics GP GL Report for your CPA”

Where’s the cash Account for this Microsoft Dynamics GP Cash Receipt?

Last week I was working at a client’s office helping entering receivables payments in Microsoft Dynamics GP. While entering I noticed that more often than not the cash account did not default. I realized that the customer card file had been set to pull the cash account from the customer instead of the checkbook.

Last week I was working at a client’s office helping entering receivables payments in Microsoft Dynamics GP. While entering I noticed that more often than not the cash account did not default. I realized that the customer card file had been set to pull the cash account from the customer instead of the checkbook.

Posted 2012

Last week I was working at a client’s office helping entering receivables payments in Microsoft Dynamics GP. While entering I noticed that more often than not the cash account did not default. I realized that the customer card file had been set to pull the cash account from the customer instead of the checkbook.
This is something I strongly advise against. If you use Bank Reconciliation to balance your checkbook, you could easily cause your balances to go out of balance if you do not pull the checkbook account from the checkbook ID rather than the customer ID.
In your Customer Maintenance Window, click on the Accounts button and at the top of the Customer Accounts Maintenance window you’ll see this option. (Note that you can look this up in mass using Smart List.)

ALWAYS USE THE GL ACCOUNTS FROM THEIR MASTER RECORDS TO HELP KEEP SUB-MODULES BALANCED TO THE GENERAL LEDGER!

(Belinda-ism)

 

What the Date (in Microsoft Dynamics GP)????

When you void a Microsoft Dynamics GP Payables check or transaction and you just click the box then the void button you’ll be voiding in the GL and in Payables the same date the transaction was originally posted. This may or may not work for you.

When you void a Microsoft Dynamics GP Payables check or transaction and you just click the box then the void button you’ll be voiding in the GL and in Payables the same date the transaction was originally posted. This may or may not work for you.

Posted in 2012

When you void a Microsoft Dynamics GP Payables check or transaction and you just click the box then the void button you’ll be voiding in the GL and in Payables the same date the transaction was originally posted. This may or may not work for you.

Continue reading “What the Date (in Microsoft Dynamics GP)????”

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 Prepare for your 1099’s

November/December is the perfect time to start preparing for those pesky, yet required 1099’s in Microsoft Dynamics GP.

Originally Posted November 9, 2011
 First step is making sure you have a Tax ID for all your 1099 vendors. In this video I’ll show you how to:

Continue reading “Microsoft Dynamics GP Prepare for your 1099’s”

Microsoft Dynamics GP: You asked about prepaying an invoice?

A Follower asked me: “What would you do if there are no invoices in the system for that particular vendor? I can’t get the vendor to show because we currently do not owe them for any invoices.” This comment was in reference to prepaying an invoice in Microsoft Dynamics GP. Here is a specific video just for this follower.

Originally posted 10/21/11

A Follower asked me: “What would you do if there are no invoices in the system for that particular vendor? I can’t get the vendor to show because we currently do not owe them for any invoices.” This comment was in reference to prepaying an invoice in Microsoft Dynamics GP. Here is a specific video just for this follower.

Continue reading “Microsoft Dynamics GP: You asked about prepaying an invoice?”

Microsoft Dynamics GP Payables Management Batch Review using Excel

The attached videos and steps show how to use Microsoft Excel to check unposted Payables entries along with their distributions for Microsoft Dynamics GP.

Originally Posted October 14, 2011

The attached videos and steps show how to use Microsoft Excel to check unposted Payables entries along with their distributions for Microsoft Dynamics GP.

Continue reading “Microsoft Dynamics GP Payables Management Batch Review using Excel”

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 Source Documents and Audit Trail Codes

Let’s talk about the Source Document and Audit Trail in Microsoft Dynamics GP posting:

Originally posted 9/27/2011

Let’s talk about the Source Document and Audit Trail in Microsoft Dynamics GP posting:
• Where is created?
• Where is it used?
• Why is an audit trail code important?
• How can I use the Source Document code in Smartlist?

Continue reading “Microsoft Dynamics GP Source Documents and Audit Trail Codes”