Bug 424486 - Transactions from Comdirect bank (over aqbanking) have incorrect timestamp
Summary: Transactions from Comdirect bank (over aqbanking) have incorrect timestamp
Status: RESOLVED WORKSFORME
Alias: None
Product: kmymoney
Classification: Applications
Component: onlinebanking (show other bugs)
Version: 5.0.8
Platform: Ubuntu Linux
: NOR normal
Target Milestone: ---
Assignee: KMyMoney Devel Mailing List
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2020-07-20 20:20 UTC by Jens
Modified: 2020-08-25 04:33 UTC (History)
0 users

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


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Jens 2020-07-20 20:20:04 UTC
SUMMARY
I configured an aqbanking connection to download transactions from my bank (Condirect). This works fine using various other software, e.g. iFinance on Mac.
The transactions are downloaded correctly. However, when I view them in KMyMoney, all timestamps are 2 years off. All transactions seem to have happened in 2018, but they were in fact in 2020.

I use kmymoney on KDE-Neon (based on Ubuntu) with the most current KDE version 5.14.2.
Comment 1 Thomas Baumgart 2020-07-21 13:35:59 UTC
This seems odd. I use the feature all the time and have no problems. The date of an imported transaction is taken from the data downloaded from the bank and not altered to my knowledge. Please do the following:

Turn on logging for imported statements in Settings/General/Support.

Then run an import which will show the problem.

Identify the corresponding logfile in

~/.aqbanking/backends/aqhbci/data/banks/de/<blz-comdirect>/logs

that contains the transaction. Apply the following to the logfile:

  grep :61: xxxx.log

Example:

$ grep :61: 20200622-082245-001.log
:61:2006220622D81,20NMSCNONREF
    ^^^^^^
    YYMMDD

Verify, what the date for the transaction in question shows in the statement log file (named kmm-statement-.... in the selected directory). Report your findings here. Once done, you can turn off the logging again.

Do you have scheduled transaction that could match the imported transaction and are overdue? The payee needs to match in this case.

Thanks in advance.
Comment 2 Jens 2020-07-21 18:25:41 UTC
This seems correct if I tell KMyMoney to start downloading transactions at a certain recent date.
:61:2007200720DR109,35NMSCNONREF//POS 2

But if I "let the bank decide" which transactions to transfer, then I get very old transcactions, it seems:
:61:1806050605DR89,06NMSCNONREF//POS 1047

I don't get this if I use other tools and "download all available transactions" via HBCI/FinTS.
Comment 3 Thomas Baumgart 2020-07-26 09:40:58 UTC
Well, if you let the bank decide what to send and they send you everything, then KMyMoney can't do anything about it. It just fulfills yours and the banks decision.

Switch the option to "Last download" and KMyMoney uses that date (and few days before) to retrieve transactions from the bank.

To me, this looks like everything is working as expected. Please confirm.
Comment 4 Bug Janitor Service 2020-08-10 04:33:10 UTC
Dear Bug Submitter,

This bug has been in NEEDSINFO status with no change for at least
15 days. Please provide the requested information as soon as
possible and set the bug status as REPORTED. Due to regular bug
tracker maintenance, if the bug is still in NEEDSINFO status with
no change in 30 days the bug will be closed as RESOLVED > WORKSFORME
due to lack of needed information.

For more information about our bug triaging procedures please read the
wiki located here:
https://community.kde.org/Guidelines_and_HOWTOs/Bug_triaging

If you have already provided the requested information, please
mark the bug as REPORTED so that the KDE team knows that the bug is
ready to be confirmed.

Thank you for helping us make KDE software even better for everyone!
Comment 5 Bug Janitor Service 2020-08-25 04:33:10 UTC
This bug has been in NEEDSINFO status with no change for at least
30 days. The bug is now closed as RESOLVED > WORKSFORME
due to lack of needed information.

For more information about our bug triaging procedures please read the
wiki located here:
https://community.kde.org/Guidelines_and_HOWTOs/Bug_triaging

Thank you for helping us make KDE software even better for everyone!