Sage 100

Vendor Database Error: 138. Client on 4.5 running a custom report - primary file is AR Invoice History Detail linked to ARIHHeader, which is linked to a UDT. Report is run monthly in multiple companies. Today, it fails in one of the companies, so I assume a data change in that company. Can anyone tell me what the Error 138 means? Could it be a date thing like Error code 9?

If they have VI, do an export to a CSV and look for it to look for the bad date. I bet you are able to do this in your sleep. But I don't have a clue what Error 138 means...

Before I go down that road, I thought I'd see if anyone know if the date is the right road.

Good point. If you are bored while waiting for a definite answer, a quick way to verify to do an Excel query on the date fields for those files. If it blows, you now for sure it is a corrupted date. Then all you have to do is find and fix.

Excel query of ar_invoicehistoryheader produces results, but if I dfdm the file, I get error 11 svmntb 1562. Sage KB says to rebuild keys.