[Kmymoney-devel] [kmymoney4] [Bug 315072] New: Transactions not matched from OFX direct download for one account, not others
Mike Wolfe
wolfemi1 at gmail.com
Wed Feb 13 14:50:58 UTC 2013
https://bugs.kde.org/show_bug.cgi?id=315072
Bug ID: 315072
Summary: Transactions not matched from OFX direct download for
one account, not others
Classification: Unclassified
Product: kmymoney4
Version: git master
Platform: Debian testing
OS: Linux
Status: UNCONFIRMED
Severity: normal
Priority: NOR
Component: general
Assignee: kmymoney-devel at kde.org
Reporter: wolfemi1 at gmail.com
I have four accounts mapped for automatic OFX download (three credit cards and
a checking account). As of just a few days ago, when I update the checking
account (but not any of the other three), every transaction is treated as a new
one and is added instead of matched with the already matched transactions. In
other words, the last 25 transactions are all imported and highlighted in
yellow next to the cleared transactions that they're duplicates of.
If I manually match all of them and update again, the same thing happens: I get
another 25 new yellow-highlighted transactions.
Reproducible: Always
Steps to Reproduce:
1. Run direct download of OFX data.
Actual Results:
Duplicate transactions are created
Expected Results:
Transactions are matched
Here's a dump of ofxlog.txt in my home directory, sanitized for account info
(hopefully):
rl: https://ofx.schwab.com/bankcgi_dev/ofx_server
request:
OFXHEADER:100
DATA:OFXSGML
VERSION:103
SECURITY:NONE
ENCODING:USASCII
CHARSET:1252
COMPRESSION:NONE
OLDFILEUID:NONE
NEWFILEUID:20130213084344.000
<OFX>
<SIGNONMSGSRQV1>
<SONRQ>
<DTCLIENT>20130213084344.000
<USERID>XXXXXXXXXXXXX
<USERPASS>XXXXXXXXXXXXXXXX
<LANGUAGE>ENG
<FI>
<ORG>ISC
<FID>101
</FI>
<APPID>QWIN
<APPVER>2000
</SONRQ>
</SIGNONMSGSRQV1>
<BANKMSGSRQV1>
<STMTTRNRQ>
<TRNUID>20130213084344.000
<CLTCOOKIE>1
<STMTRQ>
<BANKACCTFROM>
<BANKID>XXXXXXXXXXXX
<ACCTID>XXXXXXXXXXXXXX
<ACCTTYPE>CHECKING
</BANKACCTFROM>
<INCTRAN>
<DTSTART>20130114
<INCLUDE>Y
</INCTRAN>
</STMTRQ>
</STMTTRNRQ>
</BANKMSGSRQV1>
</OFX>
response:
OFXHEADER:100
DATA:OFXSGML
VERSION:103
SECURITY:NONE
ENCODING:USASCII
CHARSET:1252
COMPRESSION:NONE
OLDFILEUID:NONE
NEWFILEUID:20130213084344.000
<OFX>
<SIGNONMSGSRSV1>
<SONRS>
<STATUS>
<CODE>0
<SEVERITY>INFO
<MESSAGE>SUCCESS
</STATUS>
<DTSERVER>20130213084344.000
<LANGUAGE>ENG
<FI>
<ORG>ISC
<FID>101
</FI>
</SONRS>
</SIGNONMSGSRSV1>
<BANKMSGSRSV1>
<STMTTRNRS>
<TRNUID>20130213084344.000
<STATUS>
<CODE>0
<SEVERITY>INFO
<MESSAGE>SUCCESS
</STATUS>
<STMTRS>
<CURDEF>USD
<BANKACCTFROM>
<BANKID>XXXXXXXXXXXX
<ACCTID>XXXXXXXXXXXX
<ACCTTYPE>CHECKING
</BANKACCTFROM>
<BANKTRANLIST>
<DTSTART>20130114
<DTEND>20130213
<STMTTRN>
<TRNTYPE>PAYMENT
<DTPOSTED>20130213120000
<TRNAMT>-99.73
<FITID>00000440013402761201302131200001231
<CORRECTACTION>REPLACE
<NAME>NICOR GAS ONLINE PMT 130213
<MEMO>NICOR GAS ONLINE PMT 130213
</STMTTRN>
<STMTTRN>
<TRNTYPE>DIRECTDEP
<DTPOSTED>20130213120000
<TRNAMT>715.00
<FITID>00000440013402761201302131200001230
<CORRECTACTION>REPLACE
<NAME>US TREASURY 312 TAX REF 021313
<MEMO>US TREASURY 312 TAX REF 021313
</STMTTRN>
<STMTTRN>
<TRNTYPE>POS
<DTPOSTED>20130212120000
<TRNAMT>-99.85
<FITID>00000440013402761201302121200001229
<CORRECTACTION>REPLACE
<NAME>WOODMAN'S FOOD MRKT #03 ROCKFORD
<MEMO>WOODMAN'S FOOD MRKT #03 ROCKFORD
</STMTTRN>
<STMTTRN>
<TRNTYPE>POS
<DTPOSTED>20130209120000
<TRNAMT>-22.53
<FITID>00000440013402761201302091200001228
<CORRECTACTION>REPLACE
<NAME>WOODMAN'S FOOD MRKT #03 ROCKFORD
<MEMO>WOODMAN'S FOOD MRKT #03 ROCKFORD
</STMTTRN>
<STMTTRN>
<TRNTYPE>POS
<DTPOSTED>20130209120000
<TRNAMT>-9.71
<FITID>00000440013402761201302091200001227
<CORRECTACTION>REPLACE
<NAME>WOODMAN'S FOOD MRKT #03 ROCKFORD
<MEMO>WOODMAN'S FOOD MRKT #03 ROCKFORD
</STMTTRN>
<STMTTRN>
<TRNTYPE>ATM
<DTPOSTED>20130208120000
<TRNAMT>-42.75
<FITID>00000440013402761201302081200001226
<CORRECTACTION>REPLACE
<NAME>ALPINE BANK-133 1700 N ROCKFORD
<MEMO>ALPINE BANK-133 1700 N ROCKFORD
</STMTTRN>
<STMTTRN>
<TRNTYPE>DEBIT
<DTPOSTED>20130208120000
<TRNAMT>-118.00
<FITID>00000440013402761201302081200001225
<CORRECTACTION>REPLACE
<NAME>DISCOVER E-PAYMENT 130207
<MEMO>DISCOVER E-PAYMENT 130207
</STMTTRN>
<STMTTRN>
<TRNTYPE>PAYMENT
<DTPOSTED>20130208120000
<TRNAMT>-78.71
<FITID>00000440013402761201302081200001224
<CORRECTACTION>REPLACE
<NAME>COMMONWEALTH ED ONLINE PMT 1302
<MEMO>COMMONWEALTH ED ONLINE PMT 130208
</STMTTRN>
<STMTTRN>
<TRNTYPE>DEBIT
<DTPOSTED>20130208120000
<TRNAMT>-834.91
<FITID>00000440013402761201302081200001223
<CORRECTACTION>REPLACE
<NAME>CHASE EPAY 130207
<MEMO>CHASE EPAY 130207
</STMTTRN>
<STMTTRN>
<TRNTYPE>POS
<DTPOSTED>20130206120000
<TRNAMT>-136.58
<FITID>00000440013402761201302061200001222
<CORRECTACTION>REPLACE
<NAME>WOODMAN'S FOOD MRKT #03 ROCKFORD
<MEMO>WOODMAN'S FOOD MRKT #03 ROCKFORD
</STMTTRN>
<STMTTRN>
<TRNTYPE>CHECK
<DTPOSTED>20130206120000
<TRNAMT>-66.00
<FITID>00000440013402761201302061200001221
<CORRECTACTION>REPLACE
<CHECKNUM>1124
<NAME>Check Paid #1124
<MEMO>Check Paid #1124
</STMTTRN>
<STMTTRN>
<TRNTYPE>DEBIT
<DTPOSTED>20130205120000
<TRNAMT>-1037.58
<FITID>00000440013402761201302051200001220
<CORRECTACTION>REPLACE
<NAME>WF HOME MTG AUTO PAY 020113
<MEMO>WF HOME MTG AUTO PAY 020113
</STMTTRN>
<STMTTRN>
<TRNTYPE>POS
<DTPOSTED>20130201120000
<TRNAMT>-76.00
<FITID>00000440013402761201302011200001219
<CORRECTACTION>REPLACE
<NAME>WOODMAN'S FOOD MRKT #03 ROCKFORD
<MEMO>WOODMAN'S FOOD MRKT #03 ROCKFORD
</STMTTRN>
<STMTTRN>
<TRNTYPE>INT
<DTPOSTED>20130131120000
<TRNAMT>0.36
<FITID>00000440013402761201301311200001218
<CORRECTACTION>REPLACE
<NAME>Interest Paid
<MEMO>Interest Paid
</STMTTRN>
<STMTTRN>
<TRNTYPE>DIRECTDEP
<DTPOSTED>20130131120000
<TRNAMT>2214.30
<FITID>00000440013402761201301311200001217
<CORRECTACTION>REPLACE
<NAME>UT HAMILTON STAN PAYROLL 042784
<MEMO>UT HAMILTON STAN PAYROLL 042784
</STMTTRN>
<STMTTRN>
<TRNTYPE>POS
<DTPOSTED>20130129120000
<TRNAMT>-87.69
<FITID>00000440013402761201301291200001216
<CORRECTACTION>REPLACE
<NAME>WOODMAN'S FOOD MRKT #03 ROCKFORD
<MEMO>WOODMAN'S FOOD MRKT #03 ROCKFORD
</STMTTRN>
<STMTTRN>
<TRNTYPE>POS
<DTPOSTED>20130127120000
<TRNAMT>-170.79
<FITID>00000440013402761201301271200001215
<CORRECTACTION>REPLACE
<NAME>WOODMAN'S FOOD MRKT #03 ROCKFORD
<MEMO>WOODMAN'S FOOD MRKT #03 ROCKFORD
</STMTTRN>
<STMTTRN>
<TRNTYPE>DEBIT
<DTPOSTED>20130124120000
<TRNAMT>-327.98
<FITID>00000440013402761201301241200001214
<CORRECTACTION>REPLACE
<NAME>AM-HONDA PMT 130123
<MEMO>AM-HONDA PMT 130123
</STMTTRN>
<STMTTRN>
<TRNTYPE>POS
<DTPOSTED>20130122120000
<TRNAMT>-91.18
<FITID>00000440013402761201301221200001213
<CORRECTACTION>REPLACE
<NAME>WOODMAN'S FOOD MRKT #03 ROCKFORD
<MEMO>WOODMAN'S FOOD MRKT #03 ROCKFORD
</STMTTRN>
<STMTTRN>
<TRNTYPE>DEBIT
<DTPOSTED>20130122120000
<TRNAMT>-1500.00
<FITID>00000440013402761201301221200001212
<CORRECTACTION>REPLACE
<NAME>AMEX EPayment ACH PMT 130119
<MEMO>AMEX EPayment ACH PMT 130119
</STMTTRN>
<STMTTRN>
<TRNTYPE>POS
<DTPOSTED>20130117120000
<TRNAMT>-139.41
<FITID>00000440013402761201301171200001211
<CORRECTACTION>REPLACE
<NAME>WOODMAN'S FOOD MRKT #03 ROCKFORD
<MEMO>WOODMAN'S FOOD MRKT #03 ROCKFORD
</STMTTRN>
<STMTTRN>
<TRNTYPE>DEBIT
<DTPOSTED>20130115120000
<TRNAMT>-67.52
<FITID>00000440013402761201301151200001210
<CORRECTACTION>REPLACE
<NAME>DEPT EDUCATION STUDENT LN 130114
<MEMO>DEPT EDUCATION STUDENT LN 130114
</STMTTRN>
<STMTTRN>
<TRNTYPE>DIRECTDEP
<DTPOSTED>20130115120000
<TRNAMT>2214.30
<FITID>00000440013402761201301151200001209
<CORRECTACTION>REPLACE
<NAME>UT HAMILTON STAN PAYROLL 028082
<MEMO>UT HAMILTON STAN PAYROLL 028082
</STMTTRN>
<STMTTRN>
<TRNTYPE>DEBIT
<DTPOSTED>20130114120000
<TRNAMT>-119.00
<FITID>00000440013402761201301141200001208
<CORRECTACTION>REPLACE
<NAME>DISCOVER E-PAYMENT 130111
<MEMO>DISCOVER E-PAYMENT 130111
</STMTTRN>
</BANKTRANLIST>
<LEDGERBAL>
<BALAMT>2206.52
<DTASOF>20130213120000
</LEDGERBAL>
<AVAILBAL>
<BALAMT>2206.52
<DTASOF>20130213120000
</AVAILBAL>
</STMTRS>
</STMTTRNRS>
</BANKMSGSRSV1>
</OFX>
Completed
--
You are receiving this mail because:
You are the assignee for the bug.
More information about the KMyMoney-devel
mailing list