Hi Andrew,
When I run a second integrity check it will run clear. It always does. I only wish there were some way that I could see what specifically was rebuilt. If I remember correctly, Accpac's mr. fix it used to create an error file that you could print out that gave a detailed report of what exactly was fixed. It gave us an opportunity to manually re-enter what was lost in the fixing process. An error in the index of the sales order detail is too vague. We have so many Pick Lists and Back Orders in circulation at any given time, I wouldn't know what to look for? I could restore the back up and run the integrity through OE and hope it doesn't rebuild and then if it finds the errors again I could call up every uncomplete order on our system and see if I can find anything unusual. I really don't know if this would be worth the time it would take when it's not clear what the problem is with the Sales Order Detail. My primary concern is preventing data loss or at least being able to identify what data was lost so that it can be restored through some sort of workaround.
_________________________
Susan Tennier
TDL Canada
Trenton, Ontario