This forum has been archived. All content is frozen. Please use KDE Discuss instead.

MT940 transactions have wrong dates

Tags: None
(comma "," separated)
diederick76
Registered Member
Posts
6
Karma
0
OS

MT940 transactions have wrong dates

Fri Jun 14, 2013 7:31 pm
Hi,

I'm new to KMyMoney, so perhaps i'm missing something. I have set up a checking, a savings and a credit card account, several payees and all my monthly bills as periodical transactions. Then I downloaded a Swift/mt940 file from my bank's website with all the transactions of januari 2013. However, when I imported it using the AqBanking tool, all the dates of every transaction was 01/01/13. Looking into the file itself, I see the correct dates. Also, GNUCash imports the same file without that problem.

Is there some setting (in KMyMoney or KDE) I should be aware off, or is there some problem with the importer? Is there a way for me to find out what's going on in the importer?

I'm using KMyMoney 4.6.3 under KDE 4.10.4.

Thanks for any help!
User avatar
ipwizard
KDE Developer
Posts
1359
Karma
6
OS
diederick76 wrote:However, when I imported it using the AqBanking tool, all the dates of every transaction was 01/01/13. Looking into the file itself, I see the correct dates. Also, GNUCash imports the same file without that problem.
Strange. Looks like it picks up the year and month correctly but not the day. That could be coincidence. Can you check which date is used if you import transactions of February only?

diederick76 wrote:Is there some setting (in KMyMoney or KDE) I should be aware off, or is there some problem with the importer? Is there a way for me to find out what's going on in the importer?
There's no setting that I know of. Can you post how the date format looks like inside the swift data? Also important: the version of the packages aqbanking and gwenhywfar.


ipwizard, proud to be a member of the KMyMoney forum since its beginning. :-D
openSuSE Leap 15.4 64bit, KF5
diederick76
Registered Member
Posts
6
Karma
0
OS
When I import a file with only February transactions, they all get the date "01/02/13", and when I import a file with transactions from January and February, they all get the date "01/01/13", even the transactions from February.

This is me, buying something a a store on January 4th (the 61-record starts with the date):

Code: Select all
:61:130104D11,68N000NONREF
:86:000>100000000000
>20KRUIDVAT 7406 \AMSTERDAM \ >21BETAALAUTOMAAT 03-01-13 15:
>2209 PASNR. 001>310198451679


According to my package manager, I am using aqbanking 5.0.25-1 and gwenhywfar 4.3.3-2.
diederick76
Registered Member
Posts
6
Karma
0
OS
Any ideas? Or should I file a bug report?

The fact that GNUCash also uses aqbanking and imports the file correctly makes me concluded that this is indeed a KMyMoney problem, agreed?
User avatar
ipwizard
KDE Developer
Posts
1359
Karma
6
OS
Sounds most like it. I am in close contact with the aqbanking author as I cannot explain the behavior on the KMyMoney side alone. Having the info that GnuCash works correctly indeed points the arrow in direction of KMyMoney. If only I had more time for this to solve.


ipwizard, proud to be a member of the KMyMoney forum since its beginning. :-D
openSuSE Leap 15.4 64bit, KF5
diederick76
Registered Member
Posts
6
Karma
0
OS
ipwizard wrote:Sounds most like it. I am in close contact with the aqbanking author as I cannot explain the behavior on the KMyMoney side alone. Having the info that GnuCash works correctly indeed points the arrow in direction of KMyMoney. If only I had more time for this to solve.


Understood. Any idea when you will have the time? Should I submit a bug report?
User avatar
ipwizard
KDE Developer
Posts
1359
Karma
6
OS
diederick76 wrote:Understood. Any idea when you will have the time? Should I submit a bug report?
Probably a good idea, since otherwise it might get lost here on the forum.


ipwizard, proud to be a member of the KMyMoney forum since its beginning. :-D
openSuSE Leap 15.4 64bit, KF5


Bookmarks



Who is online

Registered users: Bing [Bot], Evergrowing, Google [Bot], q.ignora, watchstar