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
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
290,552
Super User 2024 Season 2
#2
Martin Dráb
228,552
Most Valuable Professional
#3
nmaenpaa
101,148
Share
Report
All responses (
Answers (