I need to inactivate all GL accounts (over 600 accounts) that have 02 as the last segment. Is there a way to do this without opening each card individually? I thought it could be accomplished through mass modify, but I can't find a way to do it there.
*This post is locked for comments
Thanks to both of you for your help. You have actually answered two of my questions. I do have access to SQL as I am the Dynamics GP administrator and support person in our company. I have a test environment to do this in first. I think I will go ahead and do the SQL fix this time. I just wasn't sure if that was a safe way to do it. That said, for other uses in the future, how do I get the sorting indexes in our system? I have always wondered why that didn't work :)
Thank you so much for your responses.
Marilyn
Hi Marylin,
You should be able to do it using Mass Modify if your installer added the sorting indexes (which he should have) to your account framework.
GPYoungGuns's (cute name) answer is the fastest, but if you don't have access to SQL, then you might need to use the built-in tools.
First, BACKUP YOUR COMPANY DATABASE, no matter which method you use.
Launch Mass Modify, change the Accounts Segment Sort to sort by your last segment. Put your account range from the lowest value to the highest value for accounts with 02 as the last segment. In my screenshot I used the value 9.
Display the Selected Range to make SURE it's going to modify the correct group of accounts. Set the Modify task to Inactivate and then Process.
That's it. Does you last segment not appear in your Accounts Segment Sort drop down? I have a solution for that too, if that's the case and you can't use SQL.
Kind regards,
Leslie
Do you have access to write a little SQL update script on your server? If so, you could use this script to inactivate those accounts in seconds:
update gl00100 set active=0 where actnumbr_3='02'
You would just need to replace the ACTNUMBR_3 with your last segment. If you only have 2 segments, that field would be ACTNUMBR_2, 4 segments you would use ACTNUMBR_4, etc.
#1
André Arnaud de Cal...
292,468
Super User 2025 Season 1
#2
Martin Dráb
231,287
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
