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.
I finally tested against the original file and as predicted, just
opening and saving the problem transactions removed the inconsistencies.
Thanks for the quick fix.
Jack
