Error when completing a Munis side only match between a Journal and AP or PR Check in Bank Reconciliation Manager



Description of Issue

Error when completing a Munis side only match between a Journal and an Accounts Payable or Payroll Check:

Match Munis Item Error

{"data":\{"Message":"An error has occurred."}

,"status":500,"config":{"method":"POST","transformRequest":[null],"transformResponse":[null],"jsonpCallbackParam":"callback","url":"https: //munisservername.tylertech.com/train/munis/munisnet//AppApi/BankReconciliation/BankMatch/ProcessMunisMatch","data":[126835,0],"cache":false,"headers":{"Accept":"application/json, text/plain, /","Content-Type":"application/json;charset=utf-8","Authorization":"Bearer_


System Log Message:

INSERT [dbo].[BankJournalCorrections]([GroupId], [JournalDetailId], [CorrectionMatchDate], [Username])
_VALUES (N'807f5aeb-16f2-4243-8655-cccbd9975643', 0, N'3/31/2022 12:00:00 AM', N'jason.riley')
SELECT [Id], [Version]
FROM [dbo].[BankJournalCorrections]_
WHERE @@ROWCOUNT > 0 AND [Id] = scope_identity()


System Log Context:

The INSERT statement conflicted with the FOREIGN KEY constraint "FK_BankJournalCorrections_JournalLineItems". The conflict occurred in database "muntrain20191", table "dbo.JournalLineItems", column 'Id'.

The statement has been terminated.



Context

Bank Reconciliation Manager



Cause




Resolution

The work ticket MUN-435136 is currently open with Development to address this issue.



Additional Information

As a workaround, these items can be excluded. A clear date can be assigned to the AP or Payroll Check in the Check Reconciliation (Financials > Cash Management > Accounts Payable Checks > Check Reconciliation) or Manual Check Reconciliation (Financials > Cash Management > Payroll Checks > Manual Check Reconciliation) programs.