Validate corrupts the "Manage Bill & Reminders Database

John, Geoff,

I'm with John on this one. I end up getting problems every time I run a validate. I don't select repair, because I want to see the data before Q messes it up.

Validate constantly reports things that are just plain wrong.

I ran a simple validate this morning right after my backup. I got four errors reported, and it says they were 'CORRECTED' even though I did not ask it to correct. All four are simple straight-forward BUY transactions which it says are 'incorrectly categorized as a realized gain. These transactions are from 4/3/2019 through 6/28/2019, all the same security.

Here's the interesting parts:

First, you can't even ENTER a category on a BUY transaction. So how can I enter an incorrect category?

Second, all four transactions are for the same security, for which I did in fact EDIT transactions last month to select the correct security from the list. The last few characters of the name had been hidden causing the selection of the wrong entry in the security list. Before the correctionI had history for BOTH spellings of the name. After the correction, there are no transactions with the incorrect spelling.

Now I understand that this causes a fairly complex recalculation for lot history for BOTH the old security and the new, but I never specify lots and let Q default to oldest lots on sales.

In any case, if I understand the concept of 'realized gains', they can't possibly occur on a BUY transaction.

So yes, I also think that validation can and does corrupt my data. OK, so tha argument is going to be that I'm still using QW2014 Premier. Probably will never upgrade because I won't subscribe, and the vendor will not even acknowledge that errors occur or that they are corrected. I will add, however, that I never had these issues PRIOR to QW2014.

All I've ever gotten is suggestions that my disk must be corrupted, but regular disk error check find NO problems there at all, and other applications have no errors.

I had a similar problem and finally fixed it. Upcoming Bills would get corrupted if I ran the One Step Update and then ran Validation. After running Validation and deleting all the "None" entries, a second Validation run was clean. If I did another One Step Update, the "None" entries would show up again.

I deactivated all the accounts and activated them again one by one. This step cleaned up the file. Previously, I had also deleted all the Bills. But this step alone did not fix anything. I don't know if deactivating alone would have also fixed the problem.

Good Luck!