RE: Update Account Descriptions
This is a little contrived, but it will work without custom code:
1. add another segment to your account format.
2. go to mass modify and make a copy of your current coa with only the added segment showing a value in the account mask. BE SURE to check the box that instructs Mass Modify to build the descriptions from the segment descriptions.
3. open smartlist and sort your account list by the extra segment you created.
4. dump the smartlist to excel.
5. take the accounts with the added character and line them up with the original accounts.
6. delete the extra columns in the spreadsheet so that you have an 'old account/new account' layout
7. run the PSTL tool and combine the original accounts with the new accounts. reconcile your years
8. reverse the PSTL tool and convert the new account numbers into the old account numbers
9. reconcile your years
10. Now, to get rid of the extra segment, which should now be blank, simply reconcile the Account Format Setup window.
11.check your account format and run reconcile (and check links) on the accounts.
You really are only going to do this once (hopefully). Using this method will keep you from having to have a custom written module. What do you think?
Kind regards,
Leslie