Sage 100

Anyone ever run across this when trying to rebuild a file? This customer has a receipt of goods that supposedly updated but only some of the items show up in transaction history and most show as still on order. Thought I would rebuild receipt history and got this on both the header and PO_ReceiptHistoryDetail files. PO_ReceiptHistoryHeader.M4T has failed the read test. Do you want to rebuild the file? This was the rebuild log: PO_ReceiptHistoryHeader.M4T The read test failed. Error #11: Record not found or Duplicate key on write

Then I got this when trying to run a Crystal report on the history detail table.

Nothing good can come of that.... Can you DFDM it?

The error messages were on the integrity check and I did not go through with the rebuild. That's when I tried Crystal. Copied the data to a test company and simply rebuilt the file. There were 21 invalid records and now it works in Crystal. None of the records deleted were the ones I was looking for but the data is definitely hosed on this receipt. There are only 10 lines in three PO's that are affected. I'm guessing I will have to manually create/modify records through DFDM. GL updated correctly but that is about the only thing.

Isn't the database connector error often connected to an invalid date?