364
I am trying to determine which tables, in case I wrote a script for the customer, I would need to update - My customer has a Salesperson retiring and so they want to move all of his customers to another existing salesperson. I was looking at the RM00102 TABLE as one that would need to be updated but are there any other tables that we would need to update as well?
I haven't used this tool in a long time but I believe it changes all the transaction history ... Works great if you want to be able to compare a customer's salesperson history over time, but can be confusing if that isn't the expected behavior. I have often updated the customer/customer address tables via SQL to default in the new salesperson going forward when the history needed to not be changed.) As you remind us often, testing and backups are your best friends when manipulating data.
Excellent Suggestion Lisa..... why re-invent the wheel?
The PSTL Salesperson Modifier is a great tool if you want everything assigned to the retiring salesperson now assigned to the new salesperson:
If you have access to SQL, run this script on your Database. It will show you every table that has the field name you are wanting to update and where it is located.
SELECT DISTINCT
TABLE_NAME
FROM
INFORMATION_SCHEMA.COLUMNS WHERE COLUMN_NAME = 'slprsnid'
Using GP Power Tools Resource Information window, I can tell you that based on a core Dynamics GP install (not with the same addon products you might have), the 'Saleperson ID' field appears in 32 tables.
There is also the 'Start Salesperson ID' and 'End Salesperson ID' field.
Using the Resource Finder window we could actually identify exactly which tables your retiring Salesperson exists in and then a simple SQL Update Statement can change the ID to their replacement.
To do this all manually, without the field filtering and many other features offered by GP Power Tools, you could look at the following article:
Regards
David
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,269
Super User 2024 Season 2
#2
Martin Dráb
230,198
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (