GP 2013 1099 Report Includes All Vendors

(0) Share

Report

Posted on by Richard Wheeler

75,848 Moderator

Can anyone tell me all the tables involved in the creation of the 1099 report. I tried looking at the report but it uses a temporary table. The reason I am asking is because when we run the report it includes all vendors even though the cutoff threshold is set to $600. So even vendors with amount less than $600 are appearing.

*This post is locked for comments

All responses (2)

Answers (0)

Suggested answer

soma 24,410 on at

Like (0)

Report

RE: GP 2013 1099 Report Includes All Vendors

I was generated 1099 vendor report from SQL side in last week. The finance team was satisfied with this report. I have used the below tables for getting this report from SQL side.

PM00200 – Vendor Master

PM00201 – Vendor Master Summary

PM20000 – Open/Posted Transactions

PM30200 – Historical/Paid Transactions

Hope this helps!!!
L Vail 65,271 on at

Like (0)

Report

RE: GP 2013 1099 Report Includes All Vendors

Hi Richard,

I have not experienced this. Are the vendors on the report in fact marked as 1099 vendors?

Kind regards,

Leslie