I am looking to perform a mass update of GL accounts that need to be marked inactive ( all three segments) and USERDEF2 marked as 'AllExclude'
I would like to get this scripted so that it becomes a routine I can run as needed.
Unfortunately GL00100 is comprised of multiple segments (ACTNUMBR_1, 2, 3 . . .), our GL accounts have three segments so I ran the following to update by range ( I sorted the ranges for each segment in Excel and added a comma at the end of each )
update gl00100 set active=0 where actnumbr_3= ' range of segments'
While I was able to run this and it worked I do however need to update one more field USERDEFINED2, I am not sure fo the most efficient way to do this as
ACTNUMBR 1, 2 & 3 are not unique, I am not sure the best means to update the 300 accounts to 'AllExclude".
Could someone lend me a hand, I'm almost there.