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

Statement Balance Date Incorrect

Tags: None
(comma "," separated)
peterhemmings
Registered Member
Posts
5
Karma
0

Statement Balance Date Incorrect

Sat Dec 09, 2017 10:43 am
Hi,
I have been using kmymony for a few years without problems but it has developed a small problem.
When I do a balance (via ofx file) the date on the ledger is wrong. I did one today, the 9th of December, and it inserts it as the 4th!
This is a permanent problem and not a "one off" and the date on my Fedora 26 is correct.
FYI I am running kmymoney 4.8.0 using KDE Development Platform 4.14.32.

Could someone suggest how to correct this and what had could have caused this to happen?

Thanks

Peter H
User avatar
ipwizard
KDE Developer
Posts
1359
Karma
6
OS

Re: Statement Balance Date Incorrect

Sat Dec 09, 2017 10:55 am
The statement date is taken out of the data provided by the bank in the OFX data stream (online or file). Since you mention that you use a file can you check the date inside the file? Is it the one you see or the one you expect?


ipwizard, proud to be a member of the KMyMoney forum since its beginning. :-D
openSuSE Leap 15.4 64bit, KF5
peterhemmings
Registered Member
Posts
5
Karma
0

Re: Statement Balance Date Incorrect

Sat Dec 09, 2017 11:43 am
Hi,
If it is the DTSERVER then it seems correct (I think!), this is the first patr of my .ofx file which I think was downloaded about 10:12am:
OFXHEADER:100
DATA:OFXSGML
VERSION:102
SECURITY:NONE
ENCODING:USASCII
CHARSET:1252
COMPRESSION:NONE
OLDFILEUID:NONE
NEWFILEUID:NONE

<OFX>
<SIGNONMSGSRSV1>
<SONRS>
<STATUS>
<CODE>0</CODE>
<SEVERITY>INFO</SEVERITY>
</STATUS>
<DTSERVER>20171209101218</DTSERVER>
<LANGUAGE>ENG</LANGUAGE>
<INTU.BID>00508</INTU.BID>
</SONRS>
</SIGNONMSGSRSV1>
<BANKMSGSRSV1>
<STMTTRNRS>
<TRNUID>1</TRNUID>
<STATUS>
<CODE>0</CODE>
<SEVERITY>INFO</SEVERITY>
</STATUS>
<STMTRS>
<CURDEF>GBP</CURDEF>
<BANKACCTFROM>

Am I correct!? :)

Thanks
User avatar
ipwizard
KDE Developer
Posts
1359
Karma
6
OS
That is something else

<DTSERVER> Date and time of the server response, datetime

What you are looking for is contained in a different construct, the ledger balance aggregate:

<LEDGERBAL> Ledger balance aggregate
<BALAMT> Ledger balance amount, amount
<DTASOF> Balance date, datetime
</LEDGERBAL>

The above is from the OFX specs version 2.1.1


ipwizard, proud to be a member of the KMyMoney forum since its beginning. :-D
openSuSE Leap 15.4 64bit, KF5
peterhemmings
Registered Member
Posts
5
Karma
0
Hi,

Thanks for the info, I have 2 accounts and my favourite is dated 7th but mymoney is using my other account's date of 4th:
<LEDGERBAL>
<BALAMT>104.09</BALAMT>
<DTASOF>20171204</DTASOF>
</LEDGERBAL>
<AVAILBAL>
<BALAMT>.00</BALAMT>
<DTASOF>20171207</DTASOF>
</AVAILBAL>
</STMTRS>
</STMTTRNRS>
</BANKMSGSRSV1>
</OFX>


I would have thought it was automatically inserted and they would both be the same! Maybe my money uses the first one and ignores others afterwards?! ;D

Regards

Peter H


Bookmarks



Who is online

Registered users: Bing [Bot], Google [Bot], Yahoo [Bot]