Tag: Microsoft

It’s Microsoft Dynamics GP “Payables Management” NOT “Invoices I need to pay”

One of the most frustration situations I come across is when I walk into an existing user of Microsoft Dynamics GP only to find they are using Payables Management (PM) as a fancy check writer rather than a tool to manage payables. 

Originally Posted 3/29/2012

One of the most frustration situations I come across is when I walk into an existing user of Microsoft Dynamics GP only to find they are using Payables Management (PM) as a fancy check writer rather than a tool to manage payables. 
One of the most frustration situations I come across is when I walk into an existing user of Microsoft Dynamics GP only to find they are using Payables Management (PM) as a fancy check writer rather than a tool to manage payables.

I often wish I had a portable soap box to stand on when I say “enter all of your every day and you’ll reap all kinds of benefits!”

If you enter ALL invoices in PM every day, you can take advantage of tools. You can answer all of the following questions:
1) How much do we have outstanding right now?
2) What’s due through next week?
3) How much is past due?
and more…

This is what PM is all about. Bank Reconciliation can print a check, payables is designed to help you track invoices by vendor, update the GL of transactions from invoices and their payments, determine when an invoice is due and when it’s best to pay… Basically its a way to MANAGE your payables, hence the name Payables Management.

Did you know there is a report called Cash Requirements where you can enter a date and the system will show you all invoices due by that date with a total dollar amount?

Did you know the Cash Flow Module will look at PM and determine how much cash is due to flow out of the company by that due date?

Don’t do extra work, let PM help you!

Import of Payroll to Microsoft Dynamics GP from Outside Payroll Service

This video shows how I suggest data be imported if you use an outside payroll service like ADP, Paychex, etc. I show an Import I setup Integration Manager and Microsoft Dynamics GP.

Originally Posted 3/21/12

This video shows how I suggest data be imported if you use an outside payroll service like ADP, Paychex, etc. I show an Import I setup Integration Manager and Microsoft Dynamics GP.

Continue reading “Import of Payroll to Microsoft Dynamics GP from Outside Payroll Service”

Microsoft Dynamics GP Bi-Weekly Payroll vs. Monthly Deductions

Using Microsoft Dynamics GP, if you do Bi-weekly payrolls, you pay employees 26 times a year.  If you have monthly deductions, like health insurance, you have a monthly amount for each employee to deduct.

Using Microsoft Dynamics GP, if you do Bi-weekly payrolls, you pay employees 26 times a year.  If you have monthly deductions, like health insurance, you have a monthly amount for each employee to deduct.

Posted 2012

Using Microsoft Dynamics GP, if you do Bi-weekly payrolls, you pay employees 26 times a year.  If you have monthly deductions, like health insurance, you have a monthly amount for each employee to deduct.

Problem? If you annualized the monthly deductions and divide by 26 and use that amount each pay period, than you’ll have great difficulty balancing your payroll accounts in the General Ledger. Also, if an employee leaves your company, it’s likely you’ll have to settle up for the difference in the deductions, which usually means the employee will owe you money.
How to fix it? Divide the monthly deduction amount by half and take out of each pay period for the first 2 pay periods of the month.
If a month has 3 pay periods, use a different “Build Payroll Check” ID and on the Deduction and Benefit button, use the Selected radio button and do not select those monthly deductions. This means a couple of pay periods during the year the employee will get more money which will make them happy. Also, you’ll be able to balance your General Ledger payroll accounts more easily! Its a win win!

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

What’s up *.dic, Microsoft Dynamics GP Reports.dic that is

The Microsoft Dynamics GP Reports.dic is the file that holds all modifications and new reports that print directly from GP. More often than not, this file is stored on a shared drive so everyone accesses the same file. This saves a lot of commotion if a change to a report is made. 

The Microsoft Dynamics GP Reports.dic is the file that holds all modifications and new reports that print directly from GP. More often than not, this file is stored on a shared drive so everyone accesses the same file. This saves a lot of commotion if a change to a report is made. 

Posted in 2012

What is this file?
The Microsoft Dynamics GP Reports.dic is the file that holds all modifications and new reports that print directly from GP. More often than not, this file is stored on a shared drive so everyone accesses the same file. This saves a lot of commotion if a change to a report is made.

Continue reading “What’s up *.dic, Microsoft Dynamics GP Reports.dic that is”

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 Navigation Panel for Reporting

What can the Navigation Panel do you for? For one thing, it can make finding reports easier. Watch me make your Microsoft Dynamics GP reports for Payables Management easier to find!

Original Posted on October 24, 2011

What can the Navigation Panel do you for? For one thing, it can make finding reports easier. Watch me make your Microsoft Dynamics GP reports for Payables Management easier to find!

Continue reading “Microsoft Dynamics GP Navigation Panel for Reporting”

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