[Kmymoney] Database errors

Thomas Baumgart thb at net-bembel.de
Fri May 29 18:41:07 UTC 2015


Dave,

On Friday 29 May 2015 14:50:41 Dave wrote:

> 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,

The payee is not a problem. There's no need for a transaction to have a payee.

The problem is, that the transactions mentioned have a post date which lies 
before the opening date of the 'Opening balances' account. You can try the 
following:

a) open the Settings/Configure KMyMoney/General/Filters tab and turn on the 
'Show equity accounts" and press OK
b) select the Accounts view. You should now see the 'Equity/Opening Balances' 
account
c) Use the RMB (right mouse button) on that account to select the 'Edit 
account' function
d) Change the date to 12/05/01

That should do the trick from what I see. You can now turn off the option set 
up in step a).

If this does not work, please let us know.


-- 

Regards

Thomas Baumgart

GPG-FP: E55E D592 F45F 116B 8429   4F99 9C59 DB40 B75D D3BA
-------------------------------------------------------------
Unix is simple and coherent, but it takes a genius – or at any rate a
programmer – to understand and appreciate the simplicity. (Dennis Ritchie)
-------------------------------------------------------------
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 225 bytes
Desc: This is a digitally signed message part.
URL: <http://mail.kde.org/pipermail/kmymoney/attachments/20150529/b0897eb8/attachment.sig>


More information about the KMyMoney mailing list