Problem Number: 141
Affected System: Daily Reconciliation
Issue summary
Daily Reconciliation auto matches a posted payment transaction (cheque) to 2 different transactions in the system. This should not happen as it should be 1 transaction to 1 transaction in this case. The issue is found in DMS by the finance team.
Current Workaround
App support need to break the linka between the post transactions so the finance team can carry out the after work.
DATA FIX PROCESS - SIGNED OFF - deemed historic and has been run without issues.
1. Connect to database server VM01GENPRODBA04 in SSMS
2. Run the following query on Finance databse, update the PaymenIDs to correspond with those quoted in the incident:
USE FINANCE
SELECT *
FROM [Finance].[Reconciliation].[ItemRelationship]
WHERE PaymentID IN (2875798, 2912665)
This will return the linked records in Daily Rec.
3. To break the link the 'PRB-141 - Clear auto matched posted payment transactions.sql' script in the DatafixLibrary needs to be executed and provided with each ItemIDs associated with the PaymentID (Posted transaction).
Permanent Solution / Accepted Workaround
This occurs when a cheque is presented/cashed at the bank and then voided on the same day. The above workaround is now accepted, and part of process should this issue occur. As of December 2025, there have been no new occurrences of this and the issue is resolved. If it dose occur a Problem record solutions article will need to be provided to the end users