Bug 339233 - some transactions is not calculated in base currency in reports
Summary: some transactions is not calculated in base currency in reports
Status: RESOLVED FIXED
Alias: None
Product: kmymoney
Classification: Applications
Component: general (show other bugs)
Version: 4.6.4
Platform: Microsoft Windows Microsoft Windows
: NOR normal
Target Milestone: ---
Assignee: KMyMoney Devel Mailing List
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2014-09-20 13:43 UTC by fajarhaifani
Modified: 2018-03-28 08:00 UTC (History)
3 users (show)

See Also:
Latest Commit:
Version Fixed In: 5.0.0
Sentry Crash Report:


Attachments
Here are screenshots of what I have on kMyMoney (294.56 KB, application/vnd.openxmlformats-officedocument.wordprocessingml.document)
2014-09-21 06:22 UTC, fajarhaifani
Details
Here is a modified version of my data, I deleted most of the transactions leaving only some that I think can indicate bugs (6.76 KB, application/gzip)
2014-09-21 12:22 UTC, fajarhaifani
Details
Correctly displayed report (75.04 KB, image/png)
2017-03-26 04:49 UTC, wojnilowicz
Details

Note You need to log in before you can comment on or make changes to this bug.
Description fajarhaifani 2014-09-20 13:43:02 UTC
Previously, I had INDONESIAN RUPIAH as base currency. Then, I change into Euro.
I make a cash account in EURO. After several days entering data, I realized that some of the transaction items are shown in Indonesian Rupiah on reports(I tried Transactions By Week, Transactions By Account, etc(It maybe on every single report)). 

For example, I bought something priced 2 Euros. In the ledger(euro cash account), it is 2 euros. But on reports, it is around 30000. It happens only on less than 10 transations.


Reproducible: Always

Steps to Reproduce:
Special setups:
I am not sure whether there is a precondition. I feel like doing the right thing
Comment 1 Cristian Oneț 2014-09-21 00:26:05 UTC
Did you use the "Convert values to base currency" option?
http://docs.kde.org/stable/en/extragear-office/kmymoney/details.reports.config.html
Comment 2 fajarhaifani 2014-09-21 06:22:24 UTC
Created attachment 88769 [details]
Here are screenshots of what I have on kMyMoney

I hope it helps
Comment 3 Cristian Oneț 2014-09-21 09:39:31 UTC
OK, I'll take a look if I can reproduce this.
Comment 4 fajarhaifani 2014-09-21 12:22:55 UTC
Created attachment 88777 [details]
Here is a modified version of my data, I deleted most of the transactions leaving only some that I think can indicate bugs

I hope it helps.
Thanks
Comment 5 Thomas Baumgart 2014-09-21 14:54:47 UTC
The problem is, that all your expense categories are in IDR not in EUR.  See the categories tab of KMyMoney. It shows you the balance of each category in IDR and its value in EUR (which is calculated using the price/exchange rate information). To avoid the situation you are seeing, create expense categories in EUR.
Comment 6 Thomas Baumgart 2014-09-21 15:06:28 UTC
Never mind my previous comment: there is a real problem. Your data seems to be OK, but the reports really look incorrect. Not even the huge numbers you mention, but also looking at the "Transactions by week" report, the split transactions look a bit strange to me. I do have the  "Convert values to base currency" option turned on and use EUR as base currency.
Comment 7 fajarhaifani 2014-09-21 15:52:29 UTC
It just crossed my mind. I was actually not aware that all my expense categories are in IDR. so, what is the better practice when you are working with multiple currencies, making 1 expense categories into 2 or more(for example: Dining_IDR and Dining_EUR) or using only one category in one of the more preferred currency(just IDR or just EUR)?

In addition, when I tried deleting all of the transactions(by highlighting all transaction at the same time and clicking on "delete" button on the menu) included in a single split transaction from expense category, kmymoney crashed.
1. Using my data, go to categories, choose/double click Expense-Expenses-Dining
2. highlight all transactions with payee "LIDL Germany"
3. click Delete on KMyMoney user interface
4. Click Yes
5. It crashed

Thanks
Comment 8 wojnilowicz 2017-03-26 04:49:07 UTC
Created attachment 104735 [details]
Correctly displayed report