1099 for Dynamics GP

I've been really impressed with a lot of our clients this year. I usually don't start the 1099 rush until January 30th but I have been getting a lot of calls already about the 1099 process. I did a blog last year about 1099's found here. This is a good overview of the 1099 process.

A couple of comments about the 1099 process that I've come across this year are listed below.

1. I find it easiest to look at the yearly summary (still under Cards>>purchasing>>summary>>yearly tab>>change to calendar year view) and see how much was paid during the year versus the 1099 amount
2. To edit the 1099 amount it will have to be done in the 1099 detail window
3. If you only see zero's on your edit list you need to install SP2 or higher for 10.0
4. If you have a vendor listed as 1099 and it shouldn't be, delete the amounts in the 1099 window before changing the status to be "Not a 1099 Vendor". It will still show up on your 1099's otherwise
5. If you have a vendor listed as dividend and not the usuall miscellaneous you will have to zero out all dividend amounts and replace it in the miscellaneous window in the 1099 detail window
6. If you haven't listed the vendor as a 1099 vendor you will have to edit the amounts in the 1099 detail window as it doesn't go back and calculate for anything previous to the change
7. The minimum amount setting is under payables setup (Microsoft Dyanmics GP>>tools>>setup>>purchasing>>payables>>1099 setup). This used to be in the print 1099 window.
8. If you have a vendor that was paid $600, change the minimum in payables setup to be $599.99 or no 1099 will be printed for that vendor.
9. For 9.0 and before you edit 1099 details in the period view (cards>>purchasing>>summary>>period tab)
10. GP does not produce the 1096 summary form. Go figure.

Anyone else come across 1099 process issues not listed above?

Dynamics GP 1099 printing for 9.0 and 10.0

Significant improvements/changes have been made to Great Plains 1099 printing process for version 10.0 versus previous releases of Dynamics (basically any version before 10.0). I've had several calls over the past week about printing 1099's so I thought I'd shed some light on the subject here.

First off there is a new setup window in Payables for 1099's. On the purchasing homepage look under setup and choose payables (tools>>setup>>purchasing>>payables). See screen shot below (click on picture to see better detail). You can now set the minimum 1099 amount in the 1099 setup window for each tax type and box number desired. (In 9.0 you would choose the minimum amount right on the print 1099 screen.)

Another change is the 1099 box added to the vendor options window. (cards>>purchasing>>vendor>>options). When you change the tax type to be a 1099 type you now can identify where the 1099 box will default to for the vendor. Nice little addition.

One of the biggest changes to this process is previous to 10.0 you could not split the 1099 amount between any needed boxes. You basically had to print out seperate 1099's for each box needed per vendor, updating the 1099 amount previous to each printing (or use a type writer, ha). In 10.0 you have the 1099 detail window as shown below. This window is a new place you can update the 1099 amounts as well and is found on the purchasing homepage under cards (instead of going to Cards>>purchasing>>summary>>period, in 9.0).

The 1099 detail window could also be used to correct the 1099 amount in 10.0. (Note that you need to choose the monthly view instead of yearly view to update any numbers.) In 10.0 you can still go in the old way which is Cards>>purchasing>>summary>>period (for homepage non users) but the 1099 detail window looks like that may be where I do this from now on. However, in 9.0 I usually tell people to see what the yearly number is (Cards>>purchasing>>summary>>yearly) and then update one of the periods with the amount desired so not sure how easy this will be in 10.0 with this new window. (Anyone have any thoughts on this???) Alternately you can go through each period and put the appropriate amount...but that's a pain and the 1099's will just use a summary total anyways.

You still print the 1099 edit list on the print 1099 window by choosing the printer icon in the upper right hand corner of the screen. The print 1099 window looks a little different as the payables setup area is where you change the 1099 minimum amounts now.

There is really no changes made to the 1099 form this year other than some 1099-R Distribution code changes. Not significant. So no year end update is really required. Still recommend being on the most recent SP but as I said, not really critical. One note on SP's, if you are not on SP 2 or beyond for 10.0 your edit list will print all zero's. So either update your SP version or print the 1099's to screen and browse numbers that way. May have 50 pages with 2 vendors on a page but at least you can see numbers etc.

I always get asked about forms and alignment. You can purchase forms from a store like Office Depot.

If the 1099 doesn't align correctly (sometimes off depending on the printer etc.), use these guidelines to make adjustments in the Print Dialog Box (tech doc #870140):

Horizontal: If you enter a positive number, the information on the paper will move to the right. If you enter a negative number, it will move to the left.

Vertical: If you enter a positive number, the information on the paper will move down. If you enter a negative number, it will move up.

Very rarely do I see you having to adjust the actual report writer report but have had to do it on occasion.

Last bit of advice. January 30th is fast approaching and the heat is usually on to get these done. Don't wait until January 29th to do your 1099's. It's a simple process but Murphy's Law definitely applies here.

Good Luck.