bad transaction match on OFX import

[Jack]

On 12/16/19 2:58 AM, Thomas Baumgart wrote:
> Jack,
>
> On Montag, 16. Dezember 2019 01:29:32 CET Jack wrote:
>
>> On 2019.12.15 16:48, Jack wrote:
>>> On 2019.12.05 10:15, Thomas Baumgart wrote:
>>>> On Montag, 2. Dezember 2019 21:24:31 CET Jack wrote:
>>>>
>>>>> I'm reconciling my Merrill Lynch accounts, and in one account, one
>>>>> transaction shows in my statement but not in the account.  I
>>>>> finally ran KMM from command line and got
>>>>>
>>>>> Processing transactions (Account Name)
>>>>> Process on: '2019-11-25', id: 'ID 20191125CA051143461091498',
>>>> amount:
>>>>> '68.00', fees: '0.00'
>>>>> Looking for a match with transaction:  "2019-11-25" , "" , "-68.00"
>>>>> (referenced account:  "Dividends" )
>>>>> Considering 1 existing transaction(s) for matching
>>>>> Detected transaction duplicate
>>>>> Processing transactions done (Account Name)
>>>>> Importing statement for 'Account Name' done
>>>>>
>>>>> The problem is that it matched against an otherwise identical
>>>>> transaction in a different account (also Merrill Lynch Investment
>>>>> account.)
>>>>>
>>>>> It turns out I own the same number of shares of the same stock in
>>>>> both accounts, but I would not have expected to match a transaction
>>>>> in a different account.  Should I open a bug report for this?
>>>> Before you do, I have some more questions:
>>>>
>>>> - what type of matching do you use on both accounts (FITID or hash)?
>>> FITID (and I'm quite sure these are consistent with Merrill Lynch)
>>>> - in either case, what is the FITID/hash of the stored and the
>>>> imported transaction   (I agree the hash for the imported
>>>> transaction can become tricky, but you can    look into the
>>>> kmm-statement....txt file)
>>> Unfortunately, I had done some more work after the problem showed up
>>> and before I started checking.  I do have an automatic save of 10
>>> versions, but I really couldn't make any sense of what I was seeing.
>>> I haven't given up on this, but at some point, I'm going to have to
>>> find my most recent backup prior to the problem, do an import
>>> including the first account with that transaction, then import for
>>> the other account, keeping careful track of the actual transaction
>>> records in the file at each step.   I'll post back when I have
>>> something to act on.
>>>> Is there a match?
>> Very very strange.  I started with a backup from September.  I imported
>> a downloaded OFX for 11/25 for the first account.  Transaction shown up
>> in the .xml file showing the correct bankid, for one of the three
>> splits.  Clear that transaction, and the reconcileflag for that split
>> changes from 0 to 1, but the bankid is now blank.  Also, the split
>> numbers changed.  If I now import the downloaded OFX file for that date
>> for the second account, the console says it matched the transaction in
>> the first account.  That account now shows the bankid for the second
>> account as both the bankid for the split and for the match.
> Yes, very strange. What do you mean by "the split numbers changed"? Do you refer to
> the ID of the split? That is not important as long as the number of splits remains.
> Seeing the bankId vanishing may explain the problem as it is now available for
> matching to other transactions.
Yes, the number of splits did not change, just the splits' IDs. I'll try 
have to check for consistent repeatability.  I use a combination of 5.0 
git heat and a recent appimage.  I sometimes use the appimage version 
(from a week or so ago) because I still have the problem with 5.0 git 
head that sometimes some transaction fields are disabled, such as 
category.  I can use the split editor, but it's sometimes just easier to 
use the appimage.
>> I'll be glad to send a file with those three transaction versions if it
>> would help.
> Yes, please. Send to me as PM. Also, the version you do this with is important.
I will sent it to you.
> Can you duplicate the problem with the bankId disappearing? Maybe in an anonymized version
> of your file? Then you can provide that file to me and I can take a look.
I don't know if anonymizing will help.  It might show the bankId 
disappear on clearing the transaction, but I'd have to be able to 
identify the transaction in the anonymized version.  I'll see if I can 
do it.
>> By the way - I tried this with a clean file, and the second import did
>> not match, it just imported to the second account.  I'll try a few more
>> times, but this just doesn't make any sense to me.
Jack