Sage 100

Have a client with a bad record in AR_InvoiceHistoryDetail file. Can't pull it up in DFDM to delete it. Rebuilding the file doesn't delete it. Any other options?

Option 1. Export out. Delete the record. Import in..... Option 2. Write a ProvideX program to reads and deletes the bad record if you know the key (the key is probably damaged so this probably wont work), Option 3. Read each record and write out only the goods records to a new file, skipping the bad record when a read error is encountered.

Try copying it to another company and then rebuild it or access it through DFDM. I had to do that for a customer once and it worked.

I think I'm going with @ThereseLogeais first... then moving on to @DougHiggs ...

What happens when you try to pull it up in DFDM? Are you able to pull it up if you scroll to it using the arrow buttons?