OFX investment transactions don't ever match

[Greg Darke-4]

Greetings

KMyMoney CVS head
kubuntu 8.04 64-bit

I have some problems when downloading investment transactions from my
broker.  The KM accounts were setup with the wizard as normal: 2
accounts "XYZ Investment" with type=Investment and "XYZ Investment
(Brokerage)" with type = Checking.

When downloading a Dividend payment the first time, one transaction is
correctly created in each account and everything appears correct.

However, every time I reload the same details, the OFX transaction does
not match, and duplicate identical transactions are created in each account.

This is an example of the relevant fragment of the OFX download.

<INCOME>
<INVTRAN>
<FITID>080926_DIV_0
<DTTRADE>20080926160000.000
<MEMO>DIV - JPMORGAN MUNICIPAL - MONEY MARKET FD E TRADE CLASS - MONTHLY
DIVIDEND
</INVTRAN>
<SECID>
<UNIQUEID>ETJMEXXE
<UNIQUEIDTYPE>CUSIP
</SECID>
<INCOMETYPE>DIV
<TOTAL>0.05
<SUBACCTSEC>CASH
<SUBACCTFUND>CASH
</INCOME>

There are other, more serious problems with reinvested dividends -- see
next message.

Greg

-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
KMyMoney2-developer mailing list
KMyMoney2-developer@...
https://lists.sourceforge.net/lists/listinfo/kmymoney2-developer

[Brendan Coupe]

I (a user) have been working on the duplicate dividend transaction matching problem with Thomas Baumgart (a developer) offline for the past couple of months.

Over the weekend Thomas added code so that the new dividends will match the category from previous dividend transactions. I tested it and it worked fine for me. Get the latest CVS to test this change.

The duplicate dividend transaction problem has not been fixed. Thomas does not have a bank that provides OFX files so it's tricky for him to troubleshoot this.

I do not have any dividends being reinvested so I have not run into that problem.

A couple of months ago I sent the list two scripts that I use to download/compile the CVS and to uninstall the old binaries and install the new binaries. In the download and compile script I have code that allows me to modify the source code before it's compiled. I changed the default OXF time frame from 2 months to 1 month to deal with one of my banks that was not allowing the OFX download for more than one month of data. I have now change the default to 7 days so that the duplicate dividend problem is not as annoying.

--
Brendan


On Mon, Oct 6, 2008 at 8:33 AM, Greg Darke <skunktrader@...> wrote:
>
> Greetings
>
> KMyMoney CVS head
> kubuntu 8.04 64-bit
>
> I have some problems when downloading investment transactions from my
> broker.  The KM accounts were setup with the wizard as normal: 2
> accounts "XYZ Investment" with type=Investment and "XYZ Investment
> (Brokerage)" with type = Checking.
>
> When downloading a Dividend payment the first time, one transaction is
> correctly created in each account and everything appears correct.
>
> However, every time I reload the same details, the OFX transaction does
> not match, and duplicate identical transactions are created in each account.
>
> This is an example of the relevant fragment of the OFX download.
>
> <INCOME>
> <INVTRAN>
> <FITID>080926_DIV_0
> <DTTRADE>20080926160000.000
> <MEMO>DIV - JPMORGAN MUNICIPAL - MONEY MARKET FD E TRADE CLASS - MONTHLY
> DIVIDEND
> </INVTRAN>
> <SECID>
> <UNIQUEID>ETJMEXXE
> <UNIQUEIDTYPE>CUSIP
> </SECID>
> <INCOMETYPE>DIV
> <TOTAL>0.05
> <SUBACCTSEC>CASH
> <SUBACCTFUND>CASH
> </INCOME>
>
> There are other, more serious problems with reinvested dividends -- see
> next message.
>
> Greg
>
> -------------------------------------------------------------------------
> This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
> Build the coolest Linux based applications with Moblin SDK & win great prizes
> Grand prize is a trip for two to an Open Source event anywhere in the world
> http://moblin-contest.org/redirect.php?banner_id=100&url=/
> _______________________________________________
> KMyMoney2-developer mailing list
> KMyMoney2-developer@...
> https://lists.sourceforge.net/lists/listinfo/kmymoney2-developer

-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
KMyMoney2-developer mailing list
KMyMoney2-developer@...
https://lists.sourceforge.net/lists/listinfo/kmymoney2-developer

[Brendan Coupe]

I think Thomas fixed this today. Download the latest CVS and see if it fixes your duplicate transaction problem. On some of mine that had already been downloaded I got a duplicate the first time but not after that so try it at least twice if it fails the first time.
--
Brendan

On Mon, Oct 6, 2008 at 1:47 PM, Brendan Coupe <brendan@...> wrote:

I (a user) have been working on the duplicate dividend transaction matching problem with Thomas Baumgart (a developer) offline for the past couple of months.

Over the weekend Thomas added code so that the new dividends will match the category from previous dividend transactions. I tested it and it worked fine for me. Get the latest CVS to test this change.

The duplicate dividend transaction problem has not been fixed. Thomas does not have a bank that provides OFX files so it's tricky for him to troubleshoot this.

I do not have any dividends being reinvested so I have not run into that problem.

A couple of months ago I sent the list two scripts that I use to download/compile the CVS and to uninstall the old binaries and install the new binaries. In the download and compile script I have code that allows me to modify the source code before it's compiled. I changed the default OXF time frame from 2 months to 1 month to deal with one of my banks that was not allowing the OFX download for more than one month of data. I have now change the default to 7 days so that the duplicate dividend problem is not as annoying.

--
Brendan

On Mon, Oct 6, 2008 at 8:33 AM, Greg Darke <skunktrader@...> wrote:
>
> Greetings
>
> KMyMoney CVS head
> kubuntu 8.04 64-bit
>
> I have some problems when downloading investment transactions from my
> broker.  The KM accounts were setup with the wizard as normal: 2
> accounts "XYZ Investment" with type=Investment and "XYZ Investment
> (Brokerage)" with type = Checking.
>
> When downloading a Dividend payment the first time, one transaction is
> correctly created in each account and everything appears correct.
>
> However, every time I reload the same details, the OFX transaction does
> not match, and duplicate identical transactions are created in each account.
>
> This is an example of the relevant fragment of the OFX download.
>
> <INCOME>
> <INVTRAN>
> <FITID>080926_DIV_0
> <DTTRADE>20080926160000.000
> <MEMO>DIV - JPMORGAN MUNICIPAL - MONEY MARKET FD E TRADE CLASS - MONTHLY
> DIVIDEND
> </INVTRAN>
> <SECID>
> <UNIQUEID>ETJMEXXE
> <UNIQUEIDTYPE>CUSIP
> </SECID>
> <INCOMETYPE>DIV
> <TOTAL>0.05
> <SUBACCTSEC>CASH
> <SUBACCTFUND>CASH
> </INCOME>
>
> There are other, more serious problems with reinvested dividends -- see
> next message.
>
> Greg
>
> -------------------------------------------------------------------------
> This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
> Build the coolest Linux based applications with Moblin SDK & win great prizes
> Grand prize is a trip for two to an Open Source event anywhere in the world
> http://moblin-contest.org/redirect.php?banner_id=100&url=/
> _______________________________________________
> KMyMoney2-developer mailing list
> KMyMoney2-developer@...
> https://lists.sourceforge.net/lists/listinfo/kmymoney2-developer

-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
KMyMoney2-developer mailing list
KMyMoney2-developer@...
https://lists.sourceforge.net/lists/listinfo/kmymoney2-developer