Bug 321045 - Unable to approve account balance
Summary: Unable to approve account balance
Status: RESOLVED WORKSFORME
Alias: None
Product: kmymoney
Classification: Applications
Component: general (show other bugs)
Version: 4.6.3
Platform: Microsoft Windows Microsoft Windows
: NOR major
Target Milestone: ---
Assignee: KMyMoney Devel Mailing List
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2013-06-11 21:54 UTC by Jan Pešta
Modified: 2013-09-12 21:34 UTC (History)
3 users (show)

See Also:
Latest Commit:
Version Fixed In:


Attachments
Screen shoot with noticable problem (173.11 KB, image/png)
2013-06-11 22:04 UTC, Jan Pešta
Details
Anonymed data file (84.79 KB, application/xml)
2013-06-12 11:18 UTC, Jan Pešta
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Jan Pešta 2013-06-11 21:54:07 UTC
I have create normal bank account with some starting amount. (I am not sure, but I think that I added this starting amount manually from 'Starting balance' account).
Currently when I am trying to aprove this starting balance, I am getting wrong numbers, like that start amount is not 0, but some counted number, but I am not sure where could be a problem.



Reproducible: Always

Steps to Reproduce:
1. Go to 'Bezny ucet' account
2. try approve acction
3. as date use 31.5.2013, end end value same number as account balance in this date.
Actual Results:  
The approved ballance is not 0, there are some diferences.

Expected Results:  
I am expecting that if there is only approved opening ballance, it difference will be 0.
Comment 1 Jan Pešta 2013-06-11 22:04:20 UTC
Created attachment 80461 [details]
Screen shoot with noticable problem

On screen shot is visible, that there is no transaction before 1.4 opening transaction.
When I am in this account not in approve mode, I see balance as 12.692,36, but in approve mode not.
Comment 2 allan 2013-06-11 23:27:59 UTC
(In reply to comment #1)
> Created attachment 80461 [details]
> Screen shoot with noticable problem
> 
> On screen shot is visible, that there is no transaction before 1.4 opening
> transaction.
> When I am in this account not in approve mode, I see balance as 12.692,36,
> but in approve mode not.

Looking at the entry for 1.4.2013, I assume the 12.692,36 is your manual opening balance entry.  However, the balance column shows 770,36, which suggests there is a prior entry.  Edit that account and check the balance figure shown there.
Comment 3 Jan Pešta 2013-06-12 06:01:27 UTC
Hi,

As I stated in comment with an image, I see this balance 770.36 only in approve mode. When I am editing account normally, the balance is as same value as opening entry 12692,36.

Currently I have no idea why this is happening. I didn't see any previous entries.
Comment 4 allan 2013-06-12 10:25:28 UTC
(In reply to comment #3)
> Hi,
> 
> As I stated in comment with an image, I see this balance 770.36 only in
> approve mode. When I am editing account normally, the balance is as same
> value as opening entry 12692,36.
> 
> Currently I have no idea why this is happening. I didn't see any previous
> entries.

At the moment, I don't understand that.

However, in comment #2, I asked you to edit the account to check the balance there.  What I meant was, open Accounts view and right click on the account in question.  Is there an amount in the 'Balance' field?

Now, going back to your original comment, you said -  "3. as date use 31.5.2013, end end value same number as account balance in this date."  I'm not clear if, when you entered the end date, the amount was supplied by KMyMoney or if you entered it?

Now, in the screen-shot, below the ledger, there is an amount of 770.36 showing, which I believe is the 'Cleared' amount, so the difference of 11922,00 is uncleared.  In Ledger view, top right, there is a Status combobox.  Select 'uncleared' to see where that amount comes from.

If there is still a problem for you, we may need to see your file.  You can save it as an anonymous file to protect your data, compress it and add it to this bug as an attachment.
Comment 5 Jan Pešta 2013-06-12 11:18:21 UTC
Created attachment 80473 [details]
Anonymed data file
Comment 6 Jan Pešta 2013-06-12 11:19:56 UTC
may be a problem is when I start approve mode, I am getting popup where I can define date of approve and ending ammount on account, but starting ammount is defined to -11922, and I can not found where this number comes from.
Comment 7 allan 2013-06-12 12:11:16 UTC
(In reply to comment #6)
> may be a problem is when I start approve mode, I am getting popup where I
> can define date of approve and ending ammount on account, but starting
> ammount is defined to -11922, and I can not found where this number comes
> from.

I can't immediately see which account has a problem, and the entries are disguised.  Can you load the anonymous file (KMM can read it as is) and identify which is the account involved.
Comment 8 Jack 2013-06-12 12:40:48 UTC
I have not looked at this in detail, but now that I recognize "approve" mode is "reconcile" I think the question may be about where KMM gets the starting and ending balances on the reconcile  pop-up.  This has been discussed on the mailing list several times, but when things are not as you expect them, the differences are usually with transactions being in a state (not marked, cleared, or reconciled) that is either wrong, or at least one you don't expect it to be in.

If I remember correctly, the starting balance on the reconcile popup is the balance of all transactions marked as already reconciled.  If you have a filter set to  not display reconciled transactions, or not to display transactions before a certain date, you might try changing those until you figure out the problem.
Comment 9 Jan Pešta 2013-06-12 12:46:44 UTC
@jack, Yes, it is about "reconcile" sorry for my English.
But I want reconcile only Opening Balances which doesn't work for me. I have no filter set (set it to show all).
Comment 10 allan 2013-06-12 13:24:07 UTC
(In reply to comment #7)
> (In reply to comment #6)
> > may be a problem is when I start approve mode, I am getting popup where I
> > can define date of approve and ending ammount on account, but starting
> > ammount is defined to -11922, and I can not found where this number comes
> > from.
> 
> I can't immediately see which account has a problem, and the entries are
> disguised.  Can you load the anonymous file (KMM can read it as is) and
> identify which is the account involved.

I've been having a further look at this and wonder if the account in question is the one in the anon. file named there as "A000001".  Attempting to reconcile that shows an opening balance amount which equates to two reconciled items, on 13 and 16 June.  Clearing the 'Reconcile' mark clears the opening balance amount.
Comment 11 Jan Pešta 2013-06-12 18:38:44 UTC
Thanks for investigation.

Problem was caused by reconciled transactions in future. Is it correct behaviour that those transactions are counted.

You can close this bug if you think that it is correct behaviour.

Thanks,

Jan
Comment 12 Jack 2013-06-12 19:04:13 UTC
In general, there should not be any transactions in the future, although the program does not  prevent it.  (If you try to create a transaction in the future, the program offers to create it as a schedule instead of actually creating the transaction.)  A developer would have to say whether the current behavior is correct, or perhaps if this bug should become a wishlist for some sort of warning if the user tries to mark a future transaction as reconciled (or maybe even cleared).
Comment 13 Jan Pešta 2013-06-12 20:10:37 UTC
Currently this was caused by scheduled transactions.

I have set the transaction to be added as reconciled, as I didn't know the affection.

I have also some future transaction accepted, and those create problem. May be there should be not possible to create scheduled transaction as reconciled.

But for sure I have no problem now when I reworked all scheduled and reconciled transactions.
Comment 14 allan 2013-06-12 20:45:02 UTC
(In reply to comment #13)
> Currently this was caused by scheduled transactions.
> 
> I have set the transaction to be added as reconciled, as I didn't know the
> affection.
> 
> I have also some future transaction accepted, and those create problem. May
> be there should be not possible to create scheduled transaction as
> reconciled.
> 
> But for sure I have no problem now when I reworked all scheduled and
> reconciled transactions.

Yes, having those scheduled transactions set up as Reconciled is certainly one factor.  Another is that those two transactions had actually been entered into the ledger in advance of the current date.

@Thomas
Tracing the program's execution, it does appear that those future dated items have been taken into account, which possibly should not, or at least without issuing a warning.