No ideas? The Knowledgebase for this version doesn't exist anymore, so I'm SOL without some help here.

I'm going to take a shot at this but with the rate technology changes this might not hit the mark. You may be better off contacting your partner for assistance. I no longer have version 3.71 access to look at the code or the tools that I had available back then. Generally, error 47 requires a rebuild (not in SQL). Does it reference the ARO table? Do you have a key referenced? I would suggest doing a query on this table and find the key referenced. If it does not reference the key, search for the original invoice, item being returned and Lot # which you are trying to select in the ARO table. The Lot# records are stored in ARO (InvoiceHistoryDetail) file and the 9 or A record types(one for lot & other for serial), which you may see as part of the key. I suggest you look for a corrupt record and edit or remove and reenter the record in your SQL database. We hope you are thinking of upgrading to a current, non-retired version soon. You will have access to all of the knowledge entries to resolve your issues independently and enjoy all of the new features that could improve productivity and effeciency in running your business.