Error when completing a Munis side only match between a Journal and AP or PR Check in Bank Reconciliation Manager
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.
Bank Reconciliation Manager
The work ticket MUN-435136 is currently open with Development to address this issue.
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.