"Another person is doing these stock transactions. They provide me with the QIF files." It sounds as though the other person is entering bad data, which is causing bad reports. It's not completely clear as to the origin of the QIF data, so I'm guessing a bit here. You mentioned Finance::Quote too, so there are a few different ways the data gets entered. The larger question is what to do moving forward. "In general, each weekend, I do: File: Import: Import QIF of the stock transactions that took place the previous week for a specific account. I do that for each of several accounts in several files/books." It would be easy if you were the one entering the data, as then I'd just suggest to remain aware of the situation, and check your entries. Educating the person entering the data might not be so easy. Since you're working with several accounts in several files/books, automating the process is probably worthwhile, but I don't have a specific suggestion as to a best way to check the data integrity, and manually reviewing data is not something that I'd suggest. Hopefully someone here can suggest an automated way to check for the multiple currency problem, and ideally provide an automated way to remove/correct the bad entries.
> On 11/03/2024 7:06 AM PST Fred Tydeman <tydeman.f...@gmail.com> wrote: > > > > > On Sat, Nov 2, 2024 at 6:16 PM Patrick James via gnucash-user > <gnucash-user@gnucash.org mailto:gnucash-user@gnucash.org> wrote: > > > Fred, > > > > The basic challenge here is that you don't seem to know how data gets into > > your GnuCash database. There are some very crafty people reading this list, > > so I'm not going to exclude the possibility that one might be able to > > explain how different currencies were entered into your GnuCash data, yet > > at the same time I'm going to bet that it would make things much easier if > > you could explain how both USD and CAD data ended up in your data. > > > > Even if you don't know when the specific entries were created, maybe you > > can explain your workflow. > > > > Note: I am listing dates in the form of YYYY/MM/DD. > That is not how they show on the screen. > > I renamed an older backup file (with this issue) to a new name so I could > look at it. > Looking at the price data base for this one CAD stock, > there is one entry for USD and about 20 entries for CAD. > The USD entry says user:split-import with a date of 2024/01/23. > There is also a CAD entry with the same date that says user:split-register. > There is one CAD entry with an earlier date (2024/01/03), also > user:split-register. > There are many CAD entries with later dates that say: user:split-register > There are many CAD entries with later dates that say: Finance::Quote > > Each of the user:split-register price entries correspond to a Buy of that > stock. > > Another person is doing these stock transactions. > They provide me with the QIF files. > > In general, each weekend, I do: File: Import: Import QIF > of the stock transactions that took place the previous week for a specific > account. > I do that for each of several accounts in several files/books. > I then try to run a Price update (does not always work). > > In looking at the GBP stock with this issue, I see three USD entries > and six GBP entries in the price history. > One USD entry is a user:price-editor. > The other two USD entries have both a USD and a GBP entry on the same date. > The GBP entries are: user:split-register > The USD entries are: user:split-import > > I was using GnuCash 4.14 on Fedora Linux 37 > I am now using GnuCash 5.9 on Fedora Linux 40 > I probably changed four months ago. > > _______________________________________________ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user ----- Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
