When attempting to change the post status of a stock payment from “Not posted” to “Do not post”, CRM users may encounter the error message below.
Error: Data could not be saved.
The MERGE statement attempted to UPDATE or DELETE the same row more than once. This happens when a target row matches more than one source row. A MERGE statement cannot UPDATE/DELETE the same row of the target table multiple times. Refine the ON clause to ensure a target row matches at most one source row, or use the GROUP BY clause to group the source rows.