Very strange problems with OFX imported dividend reinvestment transactions from Fidelity

[Jack]

On 2024.09.05 10:39, Thomas Baumgart via KMyMoney-devel wrote:
> On Sonntag, 1. September 2024 22:07:10 CEST Jack via KMyMoney-devel  
> wrote:
> 
> > On 2024.09.01 06:47, Thomas Baumgart via KMyMoney-devel wrote:
> > > On Samstag, 31. August 2024 21:22:23 CEST Jack Ostroff via
> > > KMyMoney-devel wrote:
> > >
> > >> I've been having problems with consistency check for a long time,
> > >> but never bothered to track down the cause.  I'm trying to do  
> that
> > >> now, and everything I see just confuses me more.  I do assume  
> that
> > >> the initial issue is introduced with the ofx import from  
> Fidelity,
> > >> but I also think KMM is doing something funny here.
> > > >
> > > > For one transaction, consistency check says:
> > > >   * Split S0002 in transaction 'T000000000000000258' contains
> > > different
> > > > signs for shares and value. Please fix manually
> > >
> > > I assume you do all this with the current master version. Can you
> > > send me the details of an unaltered transaction (screenshot of the
> > > Transaction detail output) via PM and maybe the plain XML of it?
> >
> > Yes, compiled a few days ago, although --version only shows me  
> kmymoney
> > 5.1.80- which happens sometimens, although I've never figured out  
> why.
> >
> > Even better, I'm attaching a much smaller xml file which shows the
> > problem.  I created a new file, including checking (not actually  
> used,)
> > invest, and broker accounts.  I then imported the following lines,
> > which I copied from the actual download csv from Fidelity:
> >
> >     Run Date,Account,Action,Symbol,Description,Type,Quantity,Price
> > ($),Commission ($),Fees ($),Accrued Interest ($),Amount  
> ($),Settlement
> > Date
> >     05/31/2024,"Corporation" Z46095109," REINVESTMENT FIDELITY
> > GOVERNMENT CASH RESERVES (FDRXX) (Cash)", FDRXX," FIDELITY  
> GOVERNMENT
> > CASH RESERVES",Cash,153.89,1,,,,-153.89,
> 
> That is where the problem starts: the sign between shares (153.89)  
> and amount
> (-153.89) differs!
> 
> I made some changes to master (already pushed to Gitlab) which is now  
> capable
> of correcting this situation. The best would be to fix the CSV  
> importer to
> handle that, but I don't want to touch that right now.
> 
> So when you import the above into the testfile, you now end up with  
> the
> scenario in attached screenshot1.png. It shows a difference of 307.78  
> which
> is "2 * 153.89".
> 
> Simply double click on the transaction and immediately save it solves  
> the
> problem by adjusting the sign of the amount (see attached  
> screenshot2.png)
> 
> Simply loading your existing transactions into the editor and saving  
> them
> should correct those existing transactions.
> 
> Hope that helps.
> 
> Thomas
Yes, I just imported from Fidelity for the August transactions, and  
noticed this.  I also vaguely recall a "switch signs" type setting, but  
I suppose that is part of the  OFX importer, and I agree we would  
prefer to not mess with the CSV importer if possible.  I will test the  
new version shortly.

[snipped the rest....]