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

Reply via email to