Skip to main content

BSM Transactions: Vendor payment cannot find matching vendor invoice

Unable to match payment with vendor invoice, but is available from database viewer

Updated over 3 weeks ago

This occurs when there is corruption of the database. Please check:

  1. Open from Transaction, Vendor's Invoice.

  2. The Invoice has missing information in the Vendor. Please update it and save.

    1. You may need to delete the transaction and create it again if the vendor payment is still unable to detect the invoices

  3. If the invoice is missing from Transaction, Vendor's Invoice, but it is available in Housekeeping, Administrative Tools, Database Viewer, you need to delete the Invoice from Database Viewer.

  4. Look for the table Sbill and SbillL and click edit.

  5. To delete that entry, mark it 'black' at the 1st empty column on the left.

  6. Click on 'X' to exit and click the Exit button.

  7. Open from Transaction, Vendor's Invoice, and create the transaction again for the Vendor's invoice.

Did this answer your question?