Hi,
My finance staff put in 1099 adjustments for a lot of vendors and I need to remove them. I checked the PM00204 table and do not see the adjustments in their own column. Does anyone know where they are stored in SQL?
Hi,
My finance staff put in 1099 adjustments for a lot of vendors and I need to remove them. I checked the PM00204 table and do not see the adjustments in their own column. Does anyone know where they are stored in SQL?
Hi Ryan-
The adjustments are actually just in a TEMP table while the changes are made. Then the PM00204 table is updated accordingly, but the adjustment transaction itself is not stored anywhere in SQL once the window is closed. You would need to make an offsetting adjustment for each at this point.
Best Regards,
Adam Gaber
Microsoft Dynamics GP
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,280 Super User 2024 Season 2
Martin Dráb 230,214 Most Valuable Professional
nmaenpaa 101,156