Views:

Resolution:
Message appears multiple times when clicking on Payables Transaction Inquiry by Document number. Inquiry window will populate however, there are corrupt records in the PM00400.

Back up the company database before proceeding.
 

  1. Run Check Links on the Payables Transaction Logical Files.
  2. Check to see if you still receive the error messages
  3. If you still receive the error message, run this query in SQL

Select * from PM00400  Order by CNTRLNUM= ‘’

  1. If blank records exist, delete them by running this:

Delete from PM00400 where CNTRLNUM= ‘ ‘ 

  1. Close the inquiry window and re open. The error message should now be gone.