User Support Forum

I did it again. I forgot to switch from CASH contributions to CHECKS.
Keyed ALL the rest of the stuff wrong, and then noticed that the Bank Deposit looked different.

I'd like to know of a quick way to hilite the entries I did wrong, and switch them to CHECKS from CASH in one fell swoop. Since almost all our contribution detail is CHECK, I'd even settle for changing ALL to CHECKS, and then just adjust the CASH entries (fewer of them).

Is there a quickie way to do this? If not, can you show the SQL for updating the UNPOSTED contribution entries to CHECKS?

(I keep thinking I'm paying attention, and then ZAP. Gets me a few times a year... Ususally when extra people show up to help.)

Thanks-G

Whenever you do something like this, always make a backup first!!

From the Database Manager (utilities)

use cotrans (enter)
repl all cash with "N" for cash = "Y" (enter)

exit the Database Manager and reindex.