Bug 428324 - Consistency check post import has issue
Summary: Consistency check post import has issue
Status: RESOLVED INTENTIONAL
Alias: None
Product: kmymoney
Classification: Applications
Component: general (show other bugs)
Version: 5.0.6
Platform: Microsoft Windows Microsoft Windows
: NOR normal
Target Milestone: ---
Assignee: KMyMoney Devel Mailing List
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2020-10-27 06:34 UTC by Suresh PB
Modified: 2020-11-21 15:31 UTC (History)
0 users

See Also:
Latest Commit:
Version Fixed In:


Attachments
attachment-1952-0.html (909 bytes, text/html)
2020-10-28 15:44 UTC, Suresh PB
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Suresh PB 2020-10-27 06:34:39 UTC
SUMMARY
Importing credit transactions with "Expense" type category works fine.  While saving "Consistency Check" kicks in and create the "category" under "Income". 

STEPS TO REPRODUCE
1. Import credit transactions to savings account type, ensure the category used is "Expense"
2. Verify the transactions imported, all looks fine.
3. Click on Save, you get an error, "Consistency check found the category as other type, so creating new category under income."


OBSERVED RESULT
The category are changed to Income type. 

EXPECTED RESULT
Category should remain the same as "Expense".

SOFTWARE/OS VERSIONS
Windows: Windows 10
macOS: 
Linux/KDE Plasma: 
(available in About System)
KDE Plasma Version: 
KDE Frameworks Version: 
Qt Version: 

ADDITIONAL INFORMATION
Comment 1 Jack 2020-10-27 17:25:53 UTC
What do you mean by "credit transactions?"  Savings accounts (all asset accounts) use deposits (in) and withdrawals (out.)  Credit card accounts (all liability accounts) use payments (in) and charges (out.)  Due to the bookkeeping involved, the signs sometimes seem reversed, but it is only a matter of perspective.
I am wondering if you are importing transactions that actually belong to a credit card account, so the signs seem reversed, and KMM seems to be swapping income/expense.

I just tried this manually - create a savings account, manually add two deposit transactions, one with an expense category and one with an income category.  Saving did not trigger any message from the consistency check, so it might well have something to do with the transactions being imported.  What type was the import?  OFX, csv, qif?
Comment 2 Suresh PB 2020-10-28 04:08:56 UTC
(In reply to Jack from comment #1)
> What do you mean by "credit transactions?"  Savings accounts (all asset
> accounts) use deposits (in) and withdrawals (out.)  Credit card accounts
> (all liability accounts) use payments (in) and charges (out.)  Due to the
> bookkeeping involved, the signs sometimes seem reversed, but it is only a
> matter of perspective.

Reference is to savings account, the term "Credit" refers to "Deposit".  I was using generic accounting terms.  This is not a credit card related transaction.

> I am wondering if you are importing transactions that actually belong to a
> credit card account, so the signs seem reversed, and KMM seems to be
> swapping income/expense.
> 
This is not the case here.

> I just tried this manually - create a savings account, manually add two
> deposit transactions, one with an expense category and one with an income
> category.  Saving did not trigger any message from the consistency check, so
> it might well have something to do with the transactions being imported. 
Manual entries does not trigger consistency check.  I tried again, it appears that when import data has category, this error occur on saving the file.

> What type was the import?  OFX, csv, qif?
This is import of csv.
Comment 3 Jack 2020-10-28 14:08:11 UTC
Can you provide a kmy file and csv file that exhibit the problem?
Comment 4 Suresh PB 2020-10-28 15:44:13 UTC
Created attachment 132842 [details]
attachment-1952-0.html

I don't have a dummy data.

Thank you,
PB Suresh

On Wed, Oct 28, 2020, 7:38 PM Jack <bugzilla_noreply@kde.org> wrote:

> https://bugs.kde.org/show_bug.cgi?id=428324
>
> --- Comment #3 from Jack <ostroffjh@users.sourceforge.net> ---
> Can you provide a kmy file and csv file that exhibit the problem?
>
> --
> You are receiving this mail because:
> You reported the bug.
Comment 5 Jack 2020-11-17 23:34:24 UTC
You can save your kmy file as anon.kmy [https://docs.kde.org/stable5/en/extragear-office/kmymoney/details.formats.anonymous.html] and you can alter any personal data in the csv file.  If someone else cannot replicate your problem, it is extremely hard to debug.
Comment 6 Thomas Baumgart 2020-11-21 13:36:58 UTC
In the original report, the error message "Consistency check found the category as other type, so creating new category under income." is referenced. I cannot find such a message in the source code. Please provide the original warning/error message without re-phrasing.

If you don't have dummy data, it would be very helpful and appreciated if you can create it so that we can duplicate the problem.
Comment 7 Suresh PB 2020-11-21 15:31:08 UTC
I don't have dummy data.  Let me close this for now.  Once the error resurface again, will update.