Wednesday, September 28, 2005

Rebuild Failure

I had a client this morning whose data file was corrupted (i.e. Verify Integrity failed). QuickBooks recommends that you Rebuild the data file. However, sometimes rebuilds don't work. If you want to look like a pro, you need to learn to use the built in diagnostic tools for QuickBooks - secret keystrokes that let you know what's going on behind the QuickBooks scenes. These are:
F2: to see what version and updates are installed and other numerical info on the file.
F2-Ctrl2-Open File, QBWinlog: shows the results of the last Verify Integrity check.
Usually when a rebuild fails, it's only due to one or two errant transactions. The Winlog helps you find those transactions. Then you can delete the corrupted transactions and re-enter them. Then run another integrity check and viola!

No comments: