Does anyone have the SQL script that can be used to update the 1099 type of historical transactions? The situation is this: User has 11 months of transactions that have the incorrect 1099 Type. They have correctly udated the Vendor record but would like to update the historical transactions as well. I'm aware that we can update the individual 1099 amounts but would like to update the transactions based on the vendor setup. Thanks, Debi
*This post is locked for comments
Thank you very much!
update
a set a.ten99type = b.ten99type from pm20000 a inner join pm00200 b on a.vendorid = b.vendorid;update
a set a.ten99type = b.ten99type from pm30200 a inner join pm00200 b on a.vendorid = b.vendorid;
Keep in mind that this script will only update the 1099 Type on the transactions, not the amounts.
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...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (