How do I remove Thousands of invalid voided checks from peach tree

Of course this can be done much easier than what Peachtree said to do.

Install Btrieve's ODBC drivers, and creake link tables to the files you want to delete data from. Then write a delete query to delete the undesired data. If you are an access developer I am sure you know how to do this.

One word of caution -- there is no way I know of to know what files in Peachtree should be affected when you manually purge one of these transactions. You need to discover this somehow, and write your queries to affect all files associated with a void check.

Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports

Continuing my quest to solve the thousands of invalid voided checks generated in Peachtree 2003. I have been given some good directions (thanks for the help) yet I still need some specifics. Being an Access developer, I can link to the table in Peachtree but I need to know a few things. Where do I get the Btrieve's ODBC drivers (is there a free one), and what tables do I link to delete the check data from. Just getting the ODBC drive would allow me to perform some testing on what tables so any help would be greatly appreciated. Don Lynch.

I do not believe there is a free ODBC driver, and I am unsure where to purhcase what you want. I have only vague ideas of what atables oyu need to modify. Certainly the JrnlHdr and JrnlRow tables, beyong that I cannot say. You need to speak with a Peachtree guru to get this for certain.

Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports

I am not sure if this was resolved in the 8 months since you posted this thread, but its easy to do.

Export all tables to their respective csv files

Edit payment.csv in excel, sort so all voids are grouped together and delete those transactions

Now open a new company and import all files. If the financials prints identical then you have successfully removed the voided checks

Good luck
Mickey Shekdar