Topic: ‘Purchasing’

By now you  probably have heard of the Microsoft Dynamics GP Miscellaneous Check window.  A simple  to use window that  looks a little like it is from the QB (QuickBooks)family.  This window is easy to use and  quick for processing a check or multiple checks, however, there are some differences between using this window and using Payables Management to cut a check.  What you should know… Read the rest of this entry »

The New Year has arrived and with it the 1099 processing cycle has begun. In a previous blog series here at Dynamics Care we addressed processing 1099s in Dynamics GP.  Now that the actual work to get the 1099s out the door is at hand we would like to bring to light a few potential items to watch out for.

1. Be aware of changes to the 1099 tax type fields on the Vendor Master card during the year.   Go to Cards >> Purchasing >> Vendors >> Options Button.  There you will find the “Tax Type” and “1099 Box” fields.  Let’s say, for example, the Vendor was originally selected as “Not a 1099 Vendor” and payment transactions were posted.  Then at a later date these fields were changed to Miscellaneous, Dividend or Interest type.
   • Dynamics GP does not go back and capture the previous transactions to add to the 1099 amount.  It only accumulates amounts from the time of the change going forward. 
   • Amounts paid year to date can be queried by going to Smartlist >>Purchasing >> Vendors Smartlist.  Open and add the column Amount Paid YTD and compare the total to the 1099 total. 
   • To change 1099 amounts for a Vendor go to Cards >> Purchasing >> 1099 Details.  Here you can type in the amount in the 1099 category to print on the 1099.
2. Differences between Dynamics GP versions.  Previous to v.9 in order to have accurate 1099 data you had to close the payables module moving the totals to history.  In v9 and v10 this is not necessary as Dynamics GP captures 1099 data by year and month in a 1099 table.  Also, v9 and v10 allows you to print 1099s at any time during the year. 
3. If you try printing your 1099s and only zeros print.  In Dynamics GP 10 Service Pack 1 there was a bug which was corrected in Service Pack 2.  If you experience this you will have to install Service Pack 2 or greater.
4. Sometimes seen in Dynamics GP v10 if you have vendors with exactly a $600 amount that does not print out a 1099. Go to (Microsoft Dynamics GP >> Tools >> Setup >> Purchasing >> Payables >> 1099 Setup button.  Change the minimum from $600. to $599.99.

If you have additional items you have come across while processing your 1099s please feel free to leave a comment we want to hear from you.

Have you ever seen Negative Amounts in your Bank Reconciliation window?  They would look something like this…

What may cause negative amounts in the Bank Reconciliation Window? Read the rest of this entry »

(Part 4) of series Dynamics GP 10 and 1099s. 

IRS Regulations, 3^rd party applications and Dynamics GP 10.  Read the rest of this entry »

In continuation of our 4 part blog series “Dynamics GP 10 and 1099s” (Part 3) covers reviewing vendor’s 1099 information and how to make changes.  Read the rest of this entry »

Dynamics GP 10 and 1099s (Part 2) Tracking the W-9.  Tracking W-9s can be a tedious task in itself.  Make a list of 1099 vendors and mark off W-9s received. Send out W-9 notifications to vendors, receive some W-9s back, send out another notification, receive a few more and the cycle continues. 

Knowing that collecting W-9s  is a project here are some tips you can use to track W-9 received using Dynamics GP’s user defined fields and Smartlist. Read the rest of this entry »

So you implemented or upgraded to Dynamics GP 10.  Year End is approaching and you are wondering what to do about tracking W-9s and processing 1099s.  What are the options?

This 4 part blog series titled “Dynamics GP 10 and 1099s”  is an overview of the different options for those who upgraded this year and those who implemented, for the first time, Dynamics GP 10.  In this series, we will look at Dynamics GP 10 1099 functionality, W-9 information tracking, reviewing and updating the Vendor’s 1099 box, IRS rulings and other 3^rd party product add-ins to help you decide the most effective approach to handling your 1099s.  Read the rest of this entry »

If your company generates, basically, any type of letter(s) to customers, vendors or employees individually or in mass quanity then this Dynamics GP 10 functionality can save you a lot of time.  Read the rest of this entry »

Macros are like riding a bike. Let’s say for instance you have to get from point A to B quickly. Then factor in it is at least 20 miles to point B.  Your choices for getting to your destination B include either walking or riding a bike.  “Which would you choose?”  Let’s also say, for example, you have tons of data that needs to be entered or changed and you need a quick method to do so.  You could either manually key the data expending a lot of time and energy to complete the task or you could build a macro and coast along while letting the macro do the work for you.  “Which would you choose?”

Read the rest of this entry »

Sales Tax collection and remittance is an often covered issue but Use Tax is often overlooked or ignored. In these difficult times, governments are increasing collection efforts and we are definitely hearing about increased use tax audits. While Microsoft Dynamics GP doesn’t provide specific use tax funtionality beyond it’s built in sales tax strengths, the sales tax features can be used quite effectively to accomodate use tax calculation, reporting and allocation.

To improve awareness of these features, I’ve created The Complete Guide to Use Tax Functionality in Microsoft Dynamics GP 10. The guide provides specific instructions and screenshots detailing how to setup Dynamics GP for various use tax scenarios using only default system functionality.