[Kmymoney] Database errors

[aga]

On 29/05/15 15:50, 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,
>
> Dave

There are two possible ways to tackle this, probably more.  One is 
within KMyMoney, and the other is in your xml editor, the former 
probably being the safest.

I'd try the Edit/Find transaction option in the menu bar, and look for 
the monetary amounts referenced - 66.441,say.  That should point you to 
the transactions.  Then look for the Opening Balances, they should tie 
in with what the Consistency check found.  It looks like that date is 
prior to the account opening date, then edit either and save. 
Obviously, use a copy file rather than your live file.

See if that sorts it for you.

Allan