I went to print my 1099's for 2004 and they are all wrong. In fact, they seem to be pulling 2003 data. Any idea why this is happening?

Hi Sherri,

The Print 1099 function is simply retrieving the information found within each Vendor. You can see the YTD 1099 amount by Editing/Viewing a vendor and looking at the bottom of the Statistics screen (second tab).

When the Print 1099 forms function is run, you are then asked if you want to clear the information. If it is not cleared, it will simply continue to accumulate until it is cleared. Perhaps at the end of last year, the 1099 information was not cleared.

The YTD 1099 values must be correct for the report to print the desired vendor amounts. If necessary, you can edit the YTD 1099 field to coincide with the required 2004 amounts.

For my clients who want to see a listing of all checks issued during a specific year by vendor, I tell them to use the Vendor Transaction report and deselect everything but "checks". The figures appear in the Original Amount column.

In the latest release of AP (the one dated in January 2005), there is a subtotal on the Original Amount column.

If this report had a feature to print the report only for those vendors with 1099 set to yes, this report would essentially be the support for the 1099 figures. (hint to Softrak)

Steve:

You could edit the stock report to add a filter to restrict to only the 1099 vendors. Save the report to the CustomReport directory (or is that the ModReport directory, I can never get those straight).

We must not have done something at the end of last year because all of my ytd numbers are wrong. I went to the tab that you indicated and it shows ptd and ytd totals to be the same which is not correct. What do I need to do in order to correct this. Thanks!!

Hi Sherri,

If the numbers are not correct, then the YTD 1099 fields on the Vendor Statistics page are editable - provided that the option to Edit Vendor Statistics is enabled in the Company Profile. This field is not being calculated from anywhere else (it is just an accumulated value), so if you know what the number needs to be, you can simply overwrite the incorrect value with the one you need.

If you have to do a lot of changes, it might be faster to Export Vendors (just the Vendor code, Name and YTD 1099 fields) to an Excel file, change the 1099 values to correct, then import that file (overwriting the bad values).
---
And just to be clear with what Doug posted: the Print 1099 forms is a specification, not a Crystal report, meaning it cannot be edited and placed in a separate directory for customization. The Vendor Transaction report can be customized to include a filter for those that track 1099s - of course if you want to turn off that filter you have to modify the report again. Edited reports in versions of Adagio prior to 8.0 are stored in the 'root' \softrak\xxWin directory (replacing the original report). Edited reports for Adagio 8.0A or later applications are stored in the \ModRP sub-directory (which you may need to create manually).

i am still somewhat confused (sorry). How do i get it to stop accumulating and actually be a ytd figure. I guess i just assumed that this program is using yrd figures meaning if I am looking at it as of 12/31/04, it should give me ytd figures of 1/1/04-12/31/04 but what you are telling me is that it is just an accumulated amount which doesn't make much sense to me. I understand that I somehow need to reset the 1099s so that they are correct, but when i go to each vendor and look at the ytd amounts they are also "accumulating" and not looking at just actual ytd figures.

Hi Sherry,

If a vendor has the 1099 option enabled, every time a check is posted, that check amount updates the YTD 1099 statistic field. It will keep getting added to until the 1099 forms are printed, at which time you have the option to clear. This is the only time you may clear the YTD 1099 values.

This field is not connected in any way to the check date. If you post a check today, it will still update the YTD 1099 amount on the vendor, adding to whatever value was there before posting.

So what to do?
1) Set all values to what they should have been as of Dec 31, 2004. Either edit the vendors or import to make the changes.

2) Print the 1099 forms and when completed, choose Yes to clearing the 1099 information. This resets all the amounts to zero.

3) If you have posted checks for 2005, those amounts have to be re-added back to the vendors. Edit or import vendors to do this.

After doing this, you should have all your 1099 forms with the correct amounts, and the vendors with the 2005 YTD amounts for 1099s.