Adjust Invoices User Defined Edit MERGE statement error

Owned by Knowledge Assistant
Jan 28, 2022
1 min read





Description of Issue

Program stopped at 'TransactionItemReferenceAdapter.4gl', line number 406. SQL statement error number -6372 (-8672). [Microsoft][SQL Server Native Client 11.0][SQL Server]The MERGE statement attempted to UPDATE or DELETE the same row more than once



Context

  • Munis

  • General Billing

  • Adjust Invoices

  • User Defined Fields

  • User Def. Edit



Cause

In this scenario a user working in Adjust Invoices - User Def. Edit might be looking to update a record and will be met with an error upon looking to add text to a blank field. The error will display: Program stopped at 'TransactionItemReferenceAdapter.4gl', line number 406. SQL statement error number -6372 (-8672). [Microsoft][SQL Server Native Client 11.0][SQL Server]The MERGE statement attempted to UPDATE or DELETE the same row more than once.



Resolution

This defect is currently being researched internally and this article will be updated as more information becomes available. Please submit a case with Munis support. 



Additional Information