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.