Skip to main content

BSM Transactions: Deleting payment transactions from the database viewer

There is a knock-off error because the open credit amount exceeds the received amount. The bill cannot be deleted as the system requires a knock-off reversal, but the transaction cannot be reversed since no bills were actually knocked off.

Updated over a month ago

Before proceeding, please back up your data. You can restore it if any mistakes occur while executing the commands. Also, ensure that all related knock-off bills have been reversed before applying this solution. To delete a Payment transaction from the database table, please follow the steps below:

  1. Open Housekeeping, Administrative Tools, and select Database Viewer.

  2. Select Query.

  3. Type in the command "USE PAYHEAD" and click Execute. (PAYHEAD is the data table name).

  4. Type in the command "BROWSE FOR RECPTNO='PAY0026xxxx' and click Execute. (RECPTNO is the payment transaction reference no)

  5. Type in the command "DELETE ALL FOR RECPTNO='PAY0026xxxx' and click Execute.

  6. EXIT.

  7. Open Payment and rekey in the transaction.

Related Articles
Accounting Transactions: Open-Item bill payment ledger guide
BSM Transactions: Guide on deleting invoices from the database viewer
BSM Transactions: Payment showing applied amount without knock-off
BSM Transactions: Outstanding amount shows wrong value despite full payment
Did this answer your question?