Currently running Sage 300 2019 and have noticed a number of errors during the data integrity check. Balance due $ is not equal to the sum of open documents for vendor. Restoration of data is not an option as the errors go a long ways back before my time. Some vendors do not have open invoices but they are showing up in the selection window of the payment batch. Is there a way to edit the database to remove/add them of correct the issues.

Any help would be appreciated