[The following is from Lynn Sikora who is having some problems we are working out with her new forum account]
I am preparing to delete from Millennium, 43 funds both the Chart of Accounts and an associated Fund Info Record that has been created in corebio for each of these 43 funds. The purpose of this request, is so that the fund numbers for these particular funds, which have no associated gift records, can be re-used by Foundation Accounting.
While we would have preferred to either inactivate the funds, or rename the funds to “Unused Fund” until which time they be re-used, we discussed these options with our customers, and they feel that neither option will suit the purposes of Foundation Accounting, or External Relations.
Because this process has never been done before by us, and we don’t have the time to fully investigate all of the Millennium tables that could potentially store these fund numbers (chart_code from chart_of_accounts), we wanted to check with Sage [and other users] to see if there are any known technical ramifications (perhaps with triggers, etc.) of deleting funds that don’t have any associated gift records, or if this is just simply a bad database practice in general.
Please let me know what you find out.