Serial number change results in accounting not balanced (again)

We just had the same problem. I noticed that your comment “again” makes me think this happened to you at least one other time. Did you figure out how to fix it?

We contacted an IFS senior analyst and the only thing we could do was write an sql script to delete the transactions in error from mpccom_accounting_tab

Yes, we had to do that too. It’s been a while, so when I look at the data repair we did I almost don’t understand it anymore. But basically it looks like our strategy was to:

• Adjust the (new) M191 postings with the values from the M3s, both on debit and credit side, so everything is in balance
• After that, update the M3 postings to the use M191 as transaction code. This is to prevent the whole thing to happen again.

I guess you can do things different ways, but as I remember it you don’t want any M3s left in there, since that will trigger new errors.

For us, we didn’t want the M191 postings. But we had to find all of the unbalanced transactions and delete them. The only reason we could do this was because the value of the transactions was less than $1USD. If it had been for a lot more money, we probably couldn’t have gotten away with this.

This script helped us find the unbalanced transactions. 

SELECT *
FROM mpccom_accounting_tab a
WHERE status_code = '99' AND trans_reval_event_id = '85450';