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!!
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
#1
André Arnaud de Cal...
292,494
Super User 2025 Season 1
#2
Martin Dráb
231,307
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
