Dear Rossco
If you made a backup just prior to deleting the cancelled invoices, the files you will need to restore are all files beginning QI (QI*.xxx, where 'xxx' represent the 3-char data file extension for this particular dataset).
It sounds as if there were/is damaged data (i.e. header could not be read on one of the records) prior to your deleting the cancelled invoices - this in turn has likely affected that particular archive batch and possibly the archive batch control file.
After restoring the files, you can do a Data Integrity Check to see what errors there are, and since you have a backup, you could choose to 'fix all errors that can be fixed' to see if this helps. If you have DataCare, you can run the Log report (in verbose mode) to see exactly what files are causing problems. (If there are no errors reported, that does not necessarily mean that your data is all ok.)
If you can pin the problem down to one or two invoices in the archive batch, you could try restoring these invoices (or the whole archive batch) to a new open invoice batch, then archive it again to see if this helps. Then try removing the cancelled invoices again.
If the above suggestions do not address the situation, or if you are still getting errors in your data, you can try renaming or removing some associated batch files to see if this helps. Depending on what files you rename or remove, you MAY lose any unposted batches and they will have to be re-entered from scratch. Let's see if we can avoid this though -
After restoring your files and performing the DIC:
1. Make a note of the archive batch number in question.
2. Close ACCPAC Plus
3. Using Explorer, go to this data directory
4. Look for the files that have the syntax 'QIA9999*.xxx'. These are your archive batches.
5. Are there ANY files of this type that are numbered different to your existing archive batch(es)? (i.e. you should only see 2 files for each batch that currently exists in your archive batch screen - an 'I' and an 'R' file, for Index & Random.) If there are any other numbered files in there, remove them - this could be causing the problem.
6. Open QIP and do another DIC. If all is ok, try your procedure again - if it goes well, then this was the problem - if there are still problems - then this last resort will unfortunately result in the loss of the open archive batch(es) and you will have to re-enter them from scratch.
7. Exit out of ACCPAC again and go back to your data directory.
8. Rename all the QIACTL*.xxx files
9. Go back into QIP, it will recreate the control files for you.
I cannot instruct you on how to fix data files, sorry. If you want the data repaired, Softrak offers that service here, and you can contact that department for a quotation - email: datarepair@softrak.com - phone: (604) 736-3741.
If you want to be able to keep that archive batch intact, a database repair may be the only way to do so, but this cannot be guaranteed. Your Dealer may also be able to provide this service to you.
Hope this helps!
Regards,
Softrak Support