1099 Audit for 2018 vendors

(0) Share

Report

Posted on by Community Member Microsoft Employee

Hi,

We are in need of a report that pulls an itemized list of all payments to all 1099s in 2018, including the vendor name, check number, date of check, and amount.

Is this possible to pull in Smartlists?

Thank you!!

Categories:

Microsoft Dynamics GP

All responses (1)

Answers (0)

Suggested answer

Nicole Hellerud 1,712 on at

Like (0)

Report

RE: 1099 Audit for 2018 vendors

Hey BRG123-

Thank you for your post.

1099’s is pulled using the Payment Date column in the PM30200 table. You could create a SQL view off this table and then leverage that SQL view to create a SmartList using SmartList Designer.

How to create a SmartList Designer report using a SQL View
https://support.microsoft.com/en-us/help/4014658/how-to-create-a-smartlist-designer-report-using-a-sql-view

Hope this helps.

Let me know if you have further questions/concerns.

Wishing you the best week ahead!

Nicole Fiskum
Support Engineer
Microsoft Dynamics