In the scripts, FireSQL is intended to be triggered following the 'After Cancel Transaction' event to update records in the designated table. However, it is not functioning as expected, and similar issues are also observed with the 'Before Cancel Transaction', 'After Save Transaction', and 'Before Save Transaction' events. Consequently, this problem is affecting all Screen Events. For your review, the 'Trace File' has been attached.
Steps to Reproduce:
1. Go to Finance and select General Ledger.
2. Navigate to Cash/Bank Transactions.
3. Open the Bank Reconciliation Statement (BRS) screen.
4. Create a DC1 entry.
5. Cancel the transaction.
6. Check the database: Use the provided script to verify if the cancelled transaction updated the specified table.
