GP 2013 1099 Printing non-1099 vendors

(0) Share

Report

Posted on by Richard Wheeler

75,852 Moderator

I had a client who noticed many vendors were set to Miscellaneous as opposed to Not a 1099 Vendor who should not have been so dollar values were accumulating through the year. We set all of these back to Not a 1099 Vendor and zeroed out the period numbers using Cards->Purchasing->Vendor Summary. These vendors are still appearing on the 1099 report. How do I get them to no longer appear on this report? Will vendor reconcile take care of this.

*This post is locked for comments

I have the same question (0)

All responses (6)

Answers (1)

Verified answer

L Vail 65,271 on at

Like (0)

Report
Copy link

Link copied!

Hi Richard,

You need to zero out the monthly details. The 1099 forms are no longer sourced from the summary record. You'll need to mark them as 1099 vendors in order to get access to the 1099 screens.

Kind regards,

Leslie

Was this reply helpful? Yes No
Richard Wheeler 75,852 Moderator on at

Like (0)

Report
Copy link

Link copied!

Leslie, do you mean the records in the PM00201 table? I would assume that is the table behind the Cards->Purchasing->Summary screen and then period. I had them go to each month and zero out the numbers but the vendors who should not be there are still there. I ran reconcile on the vendor summary for last year and I will await them to tell me tomorrow whether that fixed them or not.

Was this reply helpful? Yes No
Richard Wheeler 75,852 Moderator on at

Like (0)

Report
Copy link

Link copied!

I have discovered that I need to manually correct the PM00204 table using SSMS to correct this. Even if I zero out the values using Cards->Purchasing->Summary->Period this only zeroes out the values in the PM00202 table. The 1099 report appears to pull the values from the PM00204 table. This looks like a bug.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

This is also GP2013. I have a client having a similar issue. They are doing a mid-year check for tax-year 2016. Vendors that are set as "not a 1099 vendor" are printing forms, even with no amounts (the 1099 reports no dollars). In some cases, vendors that have received no payments in 2016 are printing a 1099 AND these vendors are marked as "not a 1099 vendor". Where should I begin troubleshooting this issue.

Thanks! Amy

Was this reply helpful? Yes No
Althea ADS 10 on at

Like (0)

Report
Copy link

Link copied!

We are having this same issue with a customer on GP16. One of their 12 companies prints ALL vendors (most with $0.00) on their 1099 edit list and 1099 forms. (97% of all their vendors in this company are Not 1099 vendor and never have been. Many have $$ but never recorded any 1099 $$. They were never marked as 1099 type vendors. We have done checklinks, reconcile, looked in all related tables and cannot find anything. Neither report is modified and they are shared with all companies and the other companies are fine.

Any guidance is greatly appreciated!

Thanks!

Was this reply helpful? Yes No
Althea ADS 10 on at

Like (0)

Report
Copy link

Link copied!

Never asked in post - so what did you end up doing to fix this? This customer very worried as they need to print these by Friday.

Was this reply helpful? Yes No