[Kmymoney] Database errors
Dave
diacobel at yahoo.com
Fri May 29 14:50:41 UTC 2015
I have been using Kmymoney since 2005. I am currently using version 4.7.2 and use the .kmy database. After an upgrade a couple of months back I started receiving consistency check errors which I am pasting to this email.
* Opening date of Account 'Opening Balances' cannot be changed to support transaction 'T000000000000000040' post date. * Transaction 'T000000000000000040' has a post date '12/05/05' before one of the referenced account's opening date. Referenced accounts: Opening Balances The post date was not updated to '12/13/05'. * Transaction 'T000000000000000041' has a post date '12/05/05' before one of the referenced account's opening date. Referenced accounts: Opening Balances The post date was not updated to '12/13/05'. * Transaction 'T000000000000000042' has a post date '12/05/05' before one of the referenced account's opening date. Referenced accounts: Opening Balances The post date was not updated to '12/13/05'.
Finished: 0 problems corrected. 4 problems still present. The account opening date is 12/05/05 so I then looked at a copy of the .kmy file with an editor. Below are the transactions in question.
<TRANSACTION postdate="2005-12-05" commodity="USD" memo="" id="T000000000000000040" entrydate="2005-12-13"> <SPLITS> <SPLIT payee="" reconcileflag="2" shares="118491/50" reconciledate="2006-04-02" action="" bankid="" account="A000200" number="" value="118491/50" memo="" id="S0001"/> <SPLIT payee="" reconcileflag="0" shares="-118491/50" reconciledate="" action="" bankid="" account="A000201" number="" value="-118491/50" memo="" id="S0002"/> </SPLITS> </TRANSACTION> <TRANSACTION postdate="2005-12-05" commodity="USD" memo="" id="T000000000000000041" entrydate="2005-12-13"> <SPLITS> <SPLIT payee="" reconcileflag="2" shares="66441/100" reconciledate="2006-04-02" action="" bankid="" account="A000202" number="" value="66441/100" memo="" id="S0001"/> <SPLIT payee="" reconcileflag="0" shares="-66441/100" reconciledate="" action="" bankid="" account="A000201" number="" value="-66441/100" memo="" id="S0002"/> </SPLITS> </TRANSACTION>
What I find unusual is that there are no payees for these transactions. They do not show up in Kmymoney so I am unable to edit them in the program. With the character set being used I cannot find an external editor that will work either. How can I fix these transactions so that I do not get consistency check errors every time I save the file.
Thanks,
Dave
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.kde.org/pipermail/kmymoney/attachments/20150529/abbd3611/attachment.html>
More information about the KMyMoney
mailing list