How to correct screwed up initial balance transaction
We have an invalid Initial Balance transaction in our system. As you can see below, someone injected an Initial Balance transction of $-700 (txn 3663371) and then relised that they should have put in a credit which they did (txn 3663398)
If I attempt to reverse the Initial Balance transaction I get:
Any suggestions on how to clean up the problem?
[I found it because I was running checks on the Current and historical Outstanding Debtors reports and there was a $700 mismatch.]
Regards, Tim G
Re: How to correct screwed up initial balance transaction
We ended up adding in two transactions:
a) a Debit Adjustment with the Reason set to “Reverse incorrect Initial balance transaction 3,663,371 on 18/4/16” with the amount set to $700.
b) to forgive this debt (because the original problem was ours) we injected a further credit adjustment of $700 with the reason “Forgive $700 debt caused by incorrect Initial balance transaction 3,663,371 on 18/4/16”
Note that I still do not understand how the Initial Balance transaction was added. Experimentation shows (with the current version) that you can only enter an Opening Balance Transaction for a new customer. Perhaps this was a bug that got fixed.
Regards, Tim G
Re: How to correct screwed up initial balance transaction
There was a change introduced for 1.9 (OVPMS-1797) that prevents Initial Balance transactions being created if the customer has any other account acts.