Bug 495088

Summary: Reconciled transaction are no longer displayed in one account
Product: [Applications] kmymoney Reporter: Ösel <spooning>
Component: databaseAssignee: KMyMoney Devel Mailing List <kmymoney-devel>
Status: RESOLVED NOT A BUG    
Severity: normal    
Priority: NOR    
Version: 5.1.2   
Target Milestone: ---   
Platform: Ubuntu   
OS: Linux   
Latest Commit: Version Fixed In:
Sentry Crash Report:

Description Ösel 2024-10-20 13:36:04 UTC 
SUMMARY
I have been managing my current account including call money account, clearing account and depot in kmymoney since 2011.

So far, the account reconciliation has always worked well.
However, for some time now I have had the problem that I can no longer reconcile one account (the call money account).
Today I got to the bottom of the problem and noticed that all my transactions from 2011 to the end of 2022 are completely missing.
However, there are still lots of bookings in the current account that show the call money account as the destination.

Can anyone tell me what has happened here?
And how can I fix the error?
I still have a lot of backup files from the last few years that I could fall back on if necessary. 
However, I'm afraid that if I import the old postings again, I'll have the postings in there twice, because the old postings must still be there somewhere, right?

And if I really had deleted the 10 years' worth of entries from the call deposit account, wouldn't the offsetting entries have been removed from my current account as well?

By the way: all other account work fine and show the correct amount.

Thank you very much.


STEPS TO REPRODUCE
1. Open the "call money account"
2. check the ledger overview (that there are no other entries)
3. Or try to do a Reconcile and see the wrong values at the bottom of the overview (Last reconciled / Cleared / Balanced).

OBSERVED RESULT
Finding no entries since the end of 2022

EXPECTED RESULT
Finding all entries since 2011


SOFTWARE/OS VERSIONS
Linux/KDE Plasma: Ubuntu 22.04.5 LTS
KDE Plasma Version: ???
KDE Frameworks Version: Version 5.92.0
Qt Version: Version 5.15.3 (built against 5.15.3)

ADDITIONAL INFORMATION
Comment 1 Thomas Baumgart 2024-10-20 16:21:23 UTC 
> However, there are still lots of bookings in the current account
> that show the call money account as the destination.

That means, that they are still there, but they might not be shown for some reason. KMyMoney provides a few filters that can hide transactions. One thing you could do is to reset the whole configuration. Here's how to do that

1. Exit KMyMoney
2. Find the file kmymoneyrc in your home directory (possibly in ~/.config/kmymoney but maybe a different location for your version of it).
3. Rename it so that you keep it (e.g. add -ori or something similar). 
4. Start KMyMoney while providing the name of your current file as argument
5. Check if transactions become visible.
6. Let us know what happens.
Comment 2 Ösel 2024-10-20 16:59:33 UTC 
Dear Thomas,
Thank you for your quick response.
After closing and restarting the software a few times and removing / setting a few checkboxes, all old entries are now displayed again.

But the basic problem remains that I can't make a reconciliation.
When I enter the "ending balance" in the pop-up window, it is also displayed as a Difference at the bottom right side on the next side, but with a minus. (“Cleared” stands at 0.00.)
However, the values (difference and cleared) do not change, regardless of which value I enter as the ending balance.

But now I have seen the following note in the pop-up window:
Last reconciled statement: Thursday, November 1, 1923

I didn't see before that the date is 100 years in the past, because the input window only shows the following: “01.10.23”.

After the date has been adjusted to the correct date, I can now make the adjustment again. 

So the problem has been solved and my bug can be closed.
Thanks for your help and sorry that I didn't see the date before.