[GNC] Reports with amounts Re: gnucash-user Digest, Vol 224, Issue 11
Sharon Sydnor
sydnorbilling at bellsouth.net
Sat Nov 6 11:42:24 EDT 2021
Michael, thank you, all understood, I desire to print out an annual report that is a compilation of all account transaction entries for the entire year to use as a reference volume and for double checking accuracy of transactions assigned to specific accounts. When my EA tax preparer looks at the totals on the income statement and says such-and-such total seems high what’s different this year, I can go to this report and look through the transactions I assigned to that account and see if something sticks out as not belonging there. Interestingly explaining myself here caused me to confirm the difference of a general journal report and general ledger and the general journal seems what I would want except I have the report I was happy with having produced the year before and it has general ledger at the top. I’ll play around starting with the general journal to see if I can get what I want starting there.
I change the computer date because it was my understanding (and makes sense) that is the date the gnucash software program uses when saving backups and doing it’s thing there. It had a tip to close the program every night or data saved may not have the correct date when you roll over to a new day so I do it out of habit now anticipating what else might be affected and am sure to NAME the file the actual date period of the activity.
Sent from my iPhone
> On Nov 5, 2021, at 6:29 PM, gnucash-user-request at gnucash.org wrote:
>
> Send gnucash-user mailing list submissions to
> gnucash-user at gnucash.org
>
> To subscribe or unsubscribe via the World Wide Web, visit
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> or, via email, send a message with subject or body 'help' to
> gnucash-user-request at gnucash.org
>
> You can reach the person managing the list at
> gnucash-user-owner at gnucash.org
>
> When replying, please edit your Subject line so it is more specific
> than "Re: Contents of gnucash-user digest..."
>
>
> Today's Topics:
>
> 1. Re: General Ledger amounts missing (Michael or Penny Novack)
> 2. Re: Has bugs-admin been hacked? Re: [Bug 797953] RFE:
> provide access to filter-by on right-mouse-click in Accounts
> register (Frank H. Ellenberger)
> 3. Re: Updating from v 2.6.16. (Geert Janssens)
> 4. Re: General Ledger amounts missing (Geert Janssens)
> 5. Re: Has bugs-admin been hacked? Re: [Bug 797953] RFE:
> provide access to filter-by on right-mouse-click in Accounts
> register (Michael Hendry)
> 6. best way to upgrade on Ubuntu 20.04 [was Re: QFX import:
> transaction matching NOT learning to match] (David Mintz)
> 7. Re: best way to upgrade on Ubuntu 20.04 [was Re: QFX import:
> transaction matching NOT learning to match] (David H)
> 8. Update Online Quotes Section in Wiki (Rainer Dorsch)
> 9. Re: Price editor uses old entry (Rainer Dorsch)
> 10. Re: best way to upgrade on Ubuntu 20.04 [was Re: QFX import:
> transaction matching NOT learning to match] (davidcousens49 at gmail.com)
>
>
> ----------------------------------------------------------------------
>
> Message: 1
> Date: Fri, 5 Nov 2021 12:12:20 -0400
> From: Michael or Penny Novack <stepbystepfarm at comcast.net>
> To: gnucash-user at gnucash.org
> Subject: Re: [GNC] General Ledger amounts missing
> Message-ID: <71df293b-54f0-7976-a8d9-7d9b2784b7af at comcast.net>
> Content-Type: text/plain; charset=UTF-8; format=flowed
>
>> On 11/5/2021 11:22 AM, Sharon Sydnor wrote:
>> Gyle, yes thank you I considered that and did set the correct start and end dates and also thought to look to the PREFERENCES of the entire program and there is a place there to also set the start and end dates and select if they are RELATIVE or ABSOLUTE, and I chose the latter. I?ll change to relative and see if it makes a difference although I don?t understand why it would. Also since I do my books ?at one sitting? and block out a period of time and work straight through from Jan to Dec of usually the former year, I change the date and time on the entire computer as well, setting it back to Dec 31 of the required year.
>> Sharon
>>
> I think it might help clarify things if instead of referring to gnucash
> report names you said what reports you wanted in terms of their standard
> accounting names. Thus a "balance sheet" report has a DATE associated
> with it (the :as of" date) while a "statement of income and expenses"
> would have a DATE RANGE (start and stop date of the interval.
>
> BUT --- "I change the date and time on the entire computer as well" is
> not needed. Like most accounting software, gnucash does NOT assume
> either data entry of transactions nor dates for reports are in "real
> time'. You SPECIFY the date/dates.
>
> One oddity that MIGHT be tripping you up is that with gnucash specify
> dates for reports only after they exist! In other words, you first "run"
> the report with whatever default dates present and then use the "edit
> report options" to change things like the effective date (and
> formatting, etc.) This might seem like extra work but ensures that you
> explicitly set dates, etc. instead of forgetting this and mistakenly
> having the dates form the last time being used.
>
> Michael D Novack
>
>
>
>
> ------------------------------
>
> Message: 2
> Date: Fri, 5 Nov 2021 17:43:20 +0100
> From: "Frank H. Ellenberger" <frank.h.ellenberger at gmail.com>
> To: Michael Hendry <hendry.michael at gmail.com>, Derek Atkins
> <warlord at MIT.EDU>
> Cc: GnuCash users group <gnucash-user at gnucash.org>
> Subject: Re: [GNC] Has bugs-admin been hacked? Re: [Bug 797953] RFE:
> provide access to filter-by on right-mouse-click in Accounts register
> Message-ID: <f9de4243-154a-d010-caa2-2b2a6415e33e at gmail.com>
> Content-Type: text/plain; charset=UTF-8
>
> Hi Michael,
>
> there is no hack.Every body can create a bugzilla account and write
> nonsense there. Because the treshold is low - no captchas etc. -
> recently some "Search engine optimizers (SEOs)" found it a cheap way to
> propagate their client's URLs.
>
> It is not only GnuCash affected, it is a wave rolling through the net.
>
> It is usually fixed after short time, see
> https://wiki.gnucash.org/wiki/Bugzilla_Administration#Pending_Tasks
>
> In my feeling SEOs are thieves stealing developer time!
>
>> Am 05.11.21 um 11:22 schrieb Michael Hendry:
>> I?ve received several emails like this recently, all ostensibly related to bugs I had reported, but the text is not relevant to the bug, and has numerous suspicious URLs which I haven?t followed.
>>
>> The text doesn?t appear in the comments section relating to the bugs.
>>
>> Michael Hendry
>>
>>>> On 4 Nov 2021, at 14:04, bugs-admin at bugs.gnucash.org wrote:
>>>
>>> https://bugs.gnucash.org/show_bug.cgi?id=797953
>>>
>>> Ahmed Sayeed <ahmedsayeed1982 at yahoo.com> changed:
> CENSORED
>
> Never forward Spam to any Mailing-List! Now the links are in the archive.
>
> Warlord, can you fix that?
>
> Regards
> Frank
>
>
> ------------------------------
>
> Message: 3
> Date: Fri, 05 Nov 2021 09:42:51 +0100
> From: Geert Janssens <geert.gnucash at kobaltwit.be>
> To: gnucash-user at gnucash.org
> Subject: Re: [GNC] Updating from v 2.6.16.
> Message-ID: <1877196.PYKUYFuaPT at legolas.kobaltwit.lan>
> Content-Type: text/plain; charset="us-ascii"
>
> That's a good guide.
>
> I'll just nitpick on your description of our version number semantics. The versioning scheme
> you describe was only used up until gnucash 2.6.x and was copied from the versioning
> scheme used by gnome*. As of 3.x we have moved to a simplified scheme consisting of only
> two levels (major.minor). Minor numbers less than 900 now signify stable releases, numbers
> 900 and up are unstable releases. We no longer user micro numbers, though they could be
> helpful if we have to do emergency/hotfix releases.
>
> Note that installers or prebuilt packages (MacOS installer, Windows installer, Flatpak installer,
> rpm packages, deb packages,...) can have an extra qualifier:
>
> major.minor-package
>
> This 'package' qualifier denotes the same version of gnucash (major.minor) has been
> repackaged for other reasons. This can vary from updates to related packages (new version
> of aqbanking, gtk,...) to fixing bugs related to packaging. The 'package' qualifier can differ
> per platform. For example on MacOS we currently have 4.8-2 as the stable release while on
> Flathub the current gnucash is 4.8-1. The changes required in the MacOS package to warrant
> a '-2' have nothing to do with the changes required in the flathub package to warrant a '-1'
> there. While both ship gnucash 4.8, the both needed (different) tweaks to be able to package
> it in a way it works correctly on their respective platforms.
>
> Regards,
>
> Geert
>
>
> * And even gnome has dropped this old scheme now.
>
> Op donderdag 4 november 2021 23:52:17 CET schreef davidcousens49 at gmail.com:
>> Mike,
>>
>> There are three major issues associated with upgrading:
>>
>> Upgrading the data file format;
>> Relocation of user preference data/config data (changes of storage location
>> and methodology;
>> Preserving any saved reports/config changes;
>>
>> The first two generally take place, if at all at the major version
>> transitions 2->3->4.
>>
>> Release numbers are major.minor.micro
>>
>> The major component of the release number usually flags incompatible
>> architecture changes, changes to database schema and the API. Minor version
>> numberssignify stable releases if even and unstable releases if odd. These
>> are primarily bug fixes and minor feature releases. The micro numbers are
>> sequential for each release
>>
>> GnuCash generally includes an inbuilt, run once only procedure to update the
>> data file format and usually to relocate any config and reports to the new
>> locations from the last minor release.
>>
>> Since you ar on Windows, you won't need to build your files the programs.
>> You can find copies of all releases of GnuCash on SourceForge at this
>> location
>> https://sourceforge.net/projects/gnucash/files/gnucash%20%28stable%29/.
>>
>> Before starting it is a very good idea to make backup copies of your data
>> files,user data, config etc. File locations in GNuCash are discussed on the
>> wikipage https://wiki.gnucash.org/wiki/Configuration_Locations but this is a
>> fairly complex document as it covers all operating systems and GC versions.
>>
>> Your data files are located in your user directory where you have chosen to
>> locate them.
>>
>> The migration of user preferences, saved reports and online Banking data is
>> discussed in the wiki at
>> https://www.gnucash.org/docs/v4/C/gnucash-guide/basics-migrate-settings.html
>> .
>
> ------------------------------
>
> Message: 4
> Date: Fri, 05 Nov 2021 16:50:32 +0100
> From: Geert Janssens <geert.gnucash at kobaltwit.be>
> To: Adrian Yong <adrianyong.88park at gmail.com>,
> gnucash-user at gnucash.org
> Cc: Gyle McCollam <gmccollam at live.com>, gnucash-user at gnucash.org,
> Sharon Sydnor <sydnorbilling at bellsouth.net>
> Subject: Re: [GNC] General Ledger amounts missing
> Message-ID: <3399682.iIbC2pHGDl at legolas.kobaltwit.lan>
> Content-Type: text/plain; charset="UTF-8"
>
> If I remember correctly the General ledger only shows the last 30 days of transactions. You
> can use Edit->Filter by... to change that.
>
> Regards,
>
> Geert
>
> Op vrijdag 5 november 2021 16:22:14 CET schreef Sharon Sydnor:
>> Gyle, yes thank you I considered that and did set the correct start and end
>> dates and also thought to look to the PREFERENCES of the entire program and
>> there is a place there to also set the start and end dates and select if
>> they are RELATIVE or ABSOLUTE, and I chose the latter. I?ll change to
>> relative and see if it makes a difference although I don?t understand why
>> it would. Also since I do my books ?at one sitting? and block out a period
>> of time and work straight through from Jan to Dec of usually the former
>> year, I change the date and time on the entire computer as well, setting
>> it back to Dec 31 of the required year. Sharon
>>
>> Sent from my iPhone
>>
>>> On Nov 4, 2021, at 10:17 PM, Adrian Yong <adrianyong.88park at gmail.com>
>>> wrote:
>>>
>>> ?
>>> Hi All,
>>>
>>> I have raised this detail before...
>>>
>>> It was explained to me that the normal General Ledger which classified
>>> Assets, Liabilities, and Proprietorship with their total amounts so that
>>> the auditor can be sure that A = L + P is observed but GNUCash works on a
>>> double entry system so A = L + P will always be observed. However,
>>> sometimes an entry may be a negative Asset instead of being a positive
>>> Liability and this is not so easily picked up without a normal General
>>> Ledger...
>>>
>>> I have downloaded the General Ledger or Transaction Report and created my
>>> normal GL using Excel.
>>>
>>> Regards,
>>> Adrian
>>>
>>>> On Fri, Nov 5, 2021 at 10:23 AM Gyle McCollam <gmccollam at live.com> wrote:
>>>> Sharon, not sure, but the simple answer seems to be that under "edit
>>>> report options" you didn't change the start and end dates. The reports
>>>> default to the current accounting period and you need the start and end
>>>> of the year. Hope this helps.
>>>>
>>>>
>>>> Thank You,
>>>> Gyle McCollam
>>>>
>>>> Gyle McCollam
>>>>
>>>> 609.680.2326 Mobile
>>>>
>>>> gmccollam at live.com<mailto:gmccollam at gyleshomes.com> email
>>>>
>>>> ________________________________
>>>> From: gnucash-user <gnucash-user-bounces+gylemc=gmail.com at gnucash.org> on
>>>> behalf of sydnorbilling at bellsouth.net <sydnorbilling at bellsouth.net>
>>>> Sent: Thursday, November 4, 2021 7:05 PM
>>>> To: gnucash-user at gnucash.org <gnucash-user at gnucash.org>
>>>> Subject: [GNC] General Ledger amounts missing
>>>>
>>>> Relative newbie, even though using gnucash for four years, but only use
>>>> it
>>>> once a year to prepare for tax filing and by the next time filing comes
>>>> around the following year I forget a lot of how it worked.
>>>>
>>>>
>>>>
>
> ------------------------------
>
> Message: 5
> Date: Fri, 5 Nov 2021 17:37:30 +0000
> From: Michael Hendry <hendry.michael at gmail.com>
> To: "Frank H. Ellenberger" <frank.h.ellenberger at gmail.com>
> Cc: Derek Atkins <warlord at MIT.EDU>, GnuCash users group
> <gnucash-user at gnucash.org>, John Ralls <jralls at ceridwen.us>
> Subject: Re: [GNC] Has bugs-admin been hacked? Re: [Bug 797953] RFE:
> provide access to filter-by on right-mouse-click in Accounts register
> Message-ID: <AD895B2A-CC72-401F-8F17-B5548F37AA0D at gmail.com>
> Content-Type: text/plain; charset=utf-8
>
>
>> On 5 Nov 2021, at 16:43, Frank H. Ellenberger <frank.h.ellenberger at gmail.com> wrote:
>>
>> Hi Michael,
>>
>> there is no hack.Every body can create a bugzilla account and write
>> nonsense there. Because the treshold is low - no captchas etc. -
>> recently some "Search engine optimizers (SEOs)" found it a cheap way to
>> propagate their client's URLs.
>>
>> It is not only GnuCash affected, it is a wave rolling through the net.
>>
>> It is usually fixed after short time, see
>> https://wiki.gnucash.org/wiki/Bugzilla_Administration#Pending_Tasks
>>
>> In my feeling SEOs are thieves stealing developer time!
>>
>>> Am 05.11.21 um 11:22 schrieb Michael Hendry:
>>> I?ve received several emails like this recently, all ostensibly related to bugs I had reported, but the text is not relevant to the bug, and has numerous suspicious URLs which I haven?t followed.
>>>
>>> The text doesn?t appear in the comments section relating to the bugs.
>>>
>>> Michael Hendry
>>>
>>>> On 4 Nov 2021, at 14:04, bugs-admin at bugs.gnucash.org wrote:
>>>>
>>>> https://bugs.gnucash.org/show_bug.cgi?id=797953
>>>>
>>>> Ahmed Sayeed <ahmedsayeed1982 at yahoo.com> changed:
>> CENSORED
>>
>> Never forward Spam to any Mailing-List! Now the links are in the archive.
>>
>> Warlord, can you fix that?
>>
>> Regards
>> Frank
>
> Dear John and Frank,
>
> Thanks for the reassurance from both and the telling-off from Frank!
>
> I take it there?s no way I can delete the post I sent which includes all those unwanted URLs?
>
> Michael
>
> ------------------------------
>
> Message: 6
> Date: Fri, 05 Nov 2021 14:16:58 -0400
> From: "David Mintz" <david at davidmintz.org>
> To: gnucash-user at gnucash.org
> Subject: [GNC] best way to upgrade on Ubuntu 20.04 [was Re: QFX
> import: transaction matching NOT learning to match]
> Message-ID: <12c7ced6-aa40-499a-aa9e-21cc4a450f04 at www.fastmail.com>
> Content-Type: text/plain
>
> Thanks everyone. It looks like I should try upgrading to 4.8. I didn't realize that the official Ubuntu 20.04 repository provides 3.8, and that the ppa:sicklylife/gnucash repository is at 4.2. So one more question: do you recommend the flatpack approach, or attempting to compile from source?
>
>
> ---
> David Mintz
> https://davidmintz.org
> Capitalism has failed. https://wsws.org
>
>> On Thu, Nov 4, 2021, at 11:26 PM, davidcousens49 at gmail.com wrote:
>> David
>>
>> That should not be a problem at all. I used 3.7 and 3.8 before up grading to 4.8
>> and imported OFX files regularly without any problem and have recently been
>> importing them in 4.8 without any problems. Usually as long as the second
>> transfer account has been specified for all the transactions before the Import
>> button is pressed then the data for the import matching algorithm is stored
>> during the import process. If that does not complete then the imbalance account
>> will normally only be applied if no transfer account was specified when it was
>> imported. If you don't complete the import process however the data isn't
>> recorded.
>>
>> You can use the Tools->Import Map Editor to edit the stored data (Bayesian) and
>> look to see if an Imbalance account has actually been mapped at some stage but
>> AFAIK the matcher shouldn't store a mapping to an imbalance account in the
>> database. If you do find any data mapping to an Imbalance account in the "Mapped
>> to Account Name" column you can delete it in the editor by selecting the line
>> and pressing the "Delete" button at the bottom right of the window. Using the
>> Filter set to "Imbalance" should locate any such records. You can then multiply
>> select them and delete all of them.
>>
>> David Cousens
>>
>>
>>> On Thu, 2021-11-04 at 21:02 -0400, David Mintz wrote:
>>> Yes yes, I am talking about having to assign the accounts during the import
>>> process in the matching window. I understand that that is the point in the
>>> workflow where you have to do this. That's how I've been doing it -- over and
>>> over.
>>>
>>> ---
>>> David Mintz
>>> https://davidmintz.org
>>> Capitalism has failed. https://wsws.org
>>>
>>> On Thu, Nov 4, 2021, at 8:24 PM, Jean Laroche wrote:
>>>> Make sure you do the assignment during the matching, in the matching
>>>> window. Not after matching is all done in the registry (in which case GC
>>>> does not learn anything).
>>>>
>>>> Jean
>>>>
>>>> On 11/4/21 5:13 PM, David Mintz wrote:
>>>>> Hello,
>>>>>
>>>>> I am running Version: 3.8 Build ID: 3.8b+(2019-12-29) and when I import a
>>>>> QFX, nearly all the transactions are assigned to "Imbalanced" even though
>>>>> I have gone through multiple iterations of trying to teach GC to recognize
>>>>> transactions by assigning the accounts manually. I have seen earlier
>>>>> postings about this, but the most detailed discussions were serveral years
>>>>> ago, and the most recent says, in substance, "just keep trying". I
>>>>> hesitate to do that because I fear it's a fool's errand. How many times do
>>>>> I need to tell it "Stop & Shop" belongs to Expenses:groceries?
>>>>>
>>>>> One strange detail: I tend to neglect my financial record-keeping for
>>>>> months at a time, but as I recall, I was not having this problem a few
>>>>> months ago. It seems to be a case of *it used to work but now it doesn't.*
>>>>>
>>>>> I've read that it may be that it thinks "Imbalanced" is the answer, and
>>>>> cannot unlearn. Is there a any way to wipe the slate clean, so to speak,
>>>>> and force GC to start over so?
>>>>>
>>>>> I've also seen that people have written Perl scripts to run against their
>>>>> data files and yeah, I could try that -- but I'd much prefer to get
>>>>> GnuCash to work properly without having to intervene this way.
>>>>>
>>>>> Any suggestions?
>>>>>
>>>>> Gratefully,
>>>>>
>>>>> David
>>>>>
>>>>>
>>>>> ---
>>>>> David Mintz
>>>>> https://davidmintz.org
>>>>> Capitalism has failed. https://wsws.org
>>>>> _______________________________________________
>>>>> gnucash-user mailing list
>>>>> gnucash-user at gnucash.org
>>>>> To update your subscription preferences or to unsubscribe:
>>>>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>>>>> If you are using Nabble or Gmane, please see
>>>>> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
>>>>> -----
>>>>> Please remember to CC this list on all your replies.
>>>>> You can do this by using Reply-To-List or Reply-All.
>>>> _______________________________________________
>>>> gnucash-user mailing list
>>>> gnucash-user at gnucash.org
>>>> To update your subscription preferences or to unsubscribe:
>>>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>>>> If you are using Nabble or Gmane, please see
>>>> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
>>>> -----
>>>> Please remember to CC this list on all your replies.
>>>> You can do this by using Reply-To-List or Reply-All.
>>> _______________________________________________
>>> gnucash-user mailing list
>>> gnucash-user at gnucash.org
>>> To update your subscription preferences or to unsubscribe:
>>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>>> If you are using Nabble or Gmane, please see
>>> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
>>> -----
>>> Please remember to CC this list on all your replies.
>>> You can do this by using Reply-To-List or Reply-All.
>>
>> _______________________________________________
>> gnucash-user mailing list
>> gnucash-user at gnucash.org
>> To update your subscription preferences or to unsubscribe:
>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>> If you are using Nabble or Gmane, please see
>> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
>> -----
>> Please remember to CC this list on all your replies.
>> You can do this by using Reply-To-List or Reply-All.
>
>
> ------------------------------
>
> Message: 7
> Date: Sat, 6 Nov 2021 05:53:00 +1000
> From: David H <hellvee at gmail.com>
> To: David Mintz <david at davidmintz.org>
> Cc: Gnucash Users <gnucash-user at gnucash.org>
> Subject: Re: [GNC] best way to upgrade on Ubuntu 20.04 [was Re: QFX
> import: transaction matching NOT learning to match]
> Message-ID:
> <CA+5xQdpHKbA9LHuJh617g+oD=VC1uk4ZQ3ksbLJx0W1bsiCLzA at mail.gmail.com>
> Content-Type: text/plain; charset="UTF-8"
>
> David,
>
> I just use flatpak on linux as it's so easy and there's not much chance of
> user error :-) You might want to double check the flatpak limitations re
> printing etc (https://wiki.gnucash.org/wiki/Flatpak) however. However if
> you decide you want to compile it yourself David Whiting posted a script he
> developed to download and compile the latest sources (
> https://lists.gnucash.org/pipermail/gnucash-user/2021-October/097864.html)
> you might want to take a look at that and also the wiki on building Gnucash
> (https://wiki.gnucash.org/wiki/Building) as well.
>
> Cheers David H.
>
>
>
>> On Sat, 6 Nov 2021 at 04:18, David Mintz <david at davidmintz.org> wrote:
>>
>> Thanks everyone. It looks like I should try upgrading to 4.8. I didn't
>> realize that the official Ubuntu 20.04 repository provides 3.8, and that
>> the ppa:sicklylife/gnucash repository is at 4.2. So one more question: do
>> you recommend the flatpack approach, or attempting to compile from source?
>>
>>
>> ---
>> David Mintz
>> https://davidmintz.org
>> Capitalism has failed. https://wsws.org
>>
>>
>>
>
>
> ------------------------------
>
> Message: 8
> Date: Fri, 05 Nov 2021 21:43:31 +0100
> From: Rainer Dorsch <ml at bokomoko.de>
> To: gnucash Users <gnucash-user at gnucash.org>
> Subject: [GNC] Update Online Quotes Section in Wiki
> Message-ID: <3985757.gdFuSrbYpc at h370>
> Content-Type: text/plain; charset="us-ascii"
>
> Hi,
>
> I edited the Trouble Shooting section on the Online Quotes page in the Wiki.
>
> https://wiki.gnucash.org/wiki/Online_Quotes
>
> Since I am not a power user of gnucash, I would appreciate if somebody could
> review my changes
>
> https://wiki.gnucash.org/wiki/index.php?
> title=Online_Quotes&type=revision&diff=20374&oldid=20363
>
> Feel free to update wording and content if needed.
>
> Many thanks
> Rainer
>
> --
> Rainer Dorsch
> http://bokomoko.de/
>
>
>
>
> ------------------------------
>
> Message: 9
> Date: Fri, 05 Nov 2021 21:48:39 +0100
> From: Rainer Dorsch <ml at bokomoko.de>
> To: gnucash-user at gnucash.org
> Subject: Re: [GNC] Price editor uses old entry
> Message-ID: <3491719.3W3jnmERsc at h370>
> Content-Type: text/plain; charset="us-ascii"
>
> Am Freitag, 5. November 2021, 16:39:28 CET schrieben Sie:
>>> On Nov 5, 2021, at 4:22 AM, Rainer Dorsch via gnucash-user
>>> <gnucash-user at gnucash.org> wrote:
>>>
>>> Hi,
>>>
>>> I noticed that if the price editor has an entry in EUR and an entry in
>>> USD, it used the EUR entry, even if the USD entry has a newer date. My
>>> account currency is EUR.
>>>
>>> Is that intended and is there an option to change this behavior?
>>>
>>> I usually get the EUR entry, if I buy or sell stock or funds, which are
>>> accounted in USD.
>>
>> GnuCash always prefers a direct conversion over an indirect one regardless
>> of the date. It's not optional. I suppose the problem arises because you're
>> trading USD-priced stocks from an EUR-denominated brokerage account and the
>> trades create the EUR prices. The simplest work around is to remove those
>> EUR prices from the pricedb; it won't affect the transaction or reports
>> using the average-cost price source. To avoid the problem going forward
>> create an intermediary USD bank account in your brokerage account hierarchy
>> and when recording the trade make separate splits for USD<->EUR and
>> stock<->USD. Chris Lam is working on a stock trading assistant to make this
>> a bit less cumbersome; we hope it will be finished in time for GnuCash 5.
>>
>
> Thanks John for your quick reply.
>
> The scenario you describe matches well my use case.
>
> Yes, I manually delete the EUR entries in the pricedb
>
> I am looking forward to the stock trading assistant.
>
> Can you tell why GnuCash always prefers a direct conversion over an indirect
> one regardless of the date? Is this a bug or a feature :-) ?
>
> Thanks
> Rainer
>
> --
> Rainer Dorsch
> http://bokomoko.de/
>
>
>
>
> ------------------------------
>
> Message: 10
> Date: Sat, 06 Nov 2021 08:26:15 +1000
> From: davidcousens49 at gmail.com
> To: gnucash-user at gnucash.org
> Subject: Re: [GNC] best way to upgrade on Ubuntu 20.04 [was Re: QFX
> import: transaction matching NOT learning to match]
> Message-ID: <eb7893bb9b15acdd1fe5853ff961bb73ba7c640e.camel at gmail.com>
> Content-Type: text/plain; charset="UTF-8"
>
> David,
>
> Whether you choose to build from source or use a flatpack will depend on your experience and confidence with building software on Linux. The process is described fairly completely in the wiki https://wiki.gnucash.org/wiki/Building, https://wiki.gnucash.org/wiki/Building_On_Linux and their breakout pages.
> If you just want to use the software, then the flatpak is an easy entry. The
> flatpack is currently being maintained by the major developers so is currently
> being updated with new releases. Permissions issues associated with the flatpack
> use of system resources and different locations for config and stored reports
> etc seem to have been the main issues. See https://wiki.gnucash.org/wiki/Flatpak
> for more info. The major limitation is not having the Python bindings shipped
> in the flatpak, which is only a limitation if you wish to use external python
> programs to work on your data in GnuCash. The snadboxing provided by flatpack
> might give some protection from affecting or being affected by other installed
> software. I use a wide range of self built software and have never had any
> serious issues as Linux seems to do that fairly effectively anyway.
>
> My personal preference is to build from source. On Linux once you have all the
> dependency header files installed it is usually straight forward. The wiki
> instructions can be turned into a script to install them fairly readily and a
> number of people have posted scripts for this in the mailing list in the past.
> Sometimes the library header names can differ slightly on various distros for a
> few libraries. It allows me to stay with the most recent stable version for
> production work and as I have in the past done a few minor code developments and
> a little work on the documentation, building from source is a necessary part of
> that.
>
> David Cousens
>
>> On Fri, 2021-11-05 at 14:16 -0400, David Mintz wrote:
>> Thanks everyone. It looks like I should try upgrading to 4.8. I didn't
>> realize that the official Ubuntu 20.04 repository provides 3.8, and that the
>> ppa:sicklylife/gnucash repository is at 4.2. So one more question: do you
>> recommend the flatpack approach, or attempting to compile from source?
>>
>>
>> ---
>> David Mintz
>> https://davidmintz.org
>> Capitalism has failed. https://wsws.org
>>
>>> On Thu, Nov 4, 2021, at 11:26 PM, davidcousens49 at gmail.com wrote:
>>> David
>>>
>>> That should not be a problem at all. I used 3.7 and 3.8 before up grading to
>>> 4.8
>>> and imported OFX files regularly without any problem and have recently been
>>> importing them in 4.8 without any problems. Usually as long as the second
>>> transfer account has been specified for all the transactions before the
>>> Import
>>> button is pressed then the data for the import matching algorithm is stored
>>> during the import process. If that does not complete then the imbalance
>>> account
>>> will normally only be applied if no transfer account was specified when it
>>> was
>>> imported. If you don't complete the import process however the data isn't
>>> recorded.
>>>
>>> You can use the Tools->Import Map Editor to edit the stored data (Bayesian)
>>> and
>>> look to see if an Imbalance account has actually been mapped at some stage
>>> but
>>> AFAIK the matcher shouldn't store a mapping to an imbalance account in the
>>> database. If you do find any data mapping to an Imbalance account in the
>>> "Mapped
>>> to Account Name" column you can delete it in the editor by selecting the
>>> line
>>> and pressing the "Delete" button at the bottom right of the window. Using
>>> the
>>> Filter set to "Imbalance" should locate any such records. You can then
>>> multiply
>>> select them and delete all of them.
>>>
>>> David Cousens
>>>
>>>
>>> On Thu, 2021-11-04 at 21:02 -0400, David Mintz wrote:
>>>> Yes yes, I am talking about having to assign the accounts during the
>>>> import
>>>> process in the matching window. I understand that that is the point in the
>>>> workflow where you have to do this. That's how I've been doing it -- over
>>>> and
>>>> over.
>>>>
>>>> ---
>>>> David Mintz
>>>> https://davidmintz.org
>>>> Capitalism has failed. https://wsws.org
>>>>
>>>> On Thu, Nov 4, 2021, at 8:24 PM, Jean Laroche wrote:
>>>>> Make sure you do the assignment during the matching, in the matching
>>>>> window. Not after matching is all done in the registry (in which case
>>>>> GC
>>>>> does not learn anything).
>>>>>
>>>>> Jean
>>>>>
>>>>> On 11/4/21 5:13 PM, David Mintz wrote:
>>>>>> Hello,
>>>>>>
>>>>>> I am running Version: 3.8 Build ID: 3.8b+(2019-12-29) and when I
>>>>>> import a
>>>>>> QFX, nearly all the transactions are assigned to "Imbalanced" even
>>>>>> though
>>>>>> I have gone through multiple iterations of trying to teach GC to
>>>>>> recognize
>>>>>> transactions by assigning the accounts manually. I have seen earlier
>>>>>> postings about this, but the most detailed discussions were serveral
>>>>>> years
>>>>>> ago, and the most recent says, in substance, "just keep trying". I
>>>>>> hesitate to do that because I fear it's a fool's errand. How many
>>>>>> times do
>>>>>> I need to tell it "Stop & Shop" belongs to Expenses:groceries?
>>>>>>
>>>>>> One strange detail: I tend to neglect my financial record-keeping for
>>>>>> months at a time, but as I recall, I was not having this problem a few
>>>>>> months ago. It seems to be a case of *it used to work but now it
>>>>>> doesn't.*
>>>>>>
>>>>>> I've read that it may be that it thinks "Imbalanced" is the answer,
>>>>>> and
>>>>>> cannot unlearn. Is there a any way to wipe the slate clean, so to
>>>>>> speak,
>>>>>> and force GC to start over so?
>>>>>>
>>>>>> I've also seen that people have written Perl scripts to run against
>>>>>> their
>>>>>> data files and yeah, I could try that -- but I'd much prefer to get
>>>>>> GnuCash to work properly without having to intervene this way.
>>>>>>
>>>>>> Any suggestions?
>>>>>>
>>>>>> Gratefully,
>>>>>>
>>>>>> David
>>>>>>
>>>>>>
>>>>>> ---
>>>>>> David Mintz
>>>>>> https://davidmintz.org
>>>>>> Capitalism has failed. https://wsws.org
>>>>>> _______________________________________________
>>>>>> gnucash-user mailing list
>>>>>> gnucash-user at gnucash.org
>>>>>> To update your subscription preferences or to unsubscribe:
>>>>>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>>>>>> If you are using Nabble or Gmane, please see
>>>>>> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
>>>>>> -----
>>>>>> Please remember to CC this list on all your replies.
>>>>>> You can do this by using Reply-To-List or Reply-All.
>>>>> _______________________________________________
>>>>> gnucash-user mailing list
>>>>> gnucash-user at gnucash.org
>>>>> To update your subscription preferences or to unsubscribe:
>>>>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>>>>> If you are using Nabble or Gmane, please see
>>>>> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
>>>>> -----
>>>>> Please remember to CC this list on all your replies.
>>>>> You can do this by using Reply-To-List or Reply-All.
>>>> _______________________________________________
>>>> gnucash-user mailing list
>>>> gnucash-user at gnucash.org
>>>> To update your subscription preferences or to unsubscribe:
>>>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>>>> If you are using Nabble or Gmane, please see
>>>> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
>>>> -----
>>>> Please remember to CC this list on all your replies.
>>>> You can do this by using Reply-To-List or Reply-All.
>>>
>>> _______________________________________________
>>> gnucash-user mailing list
>>> gnucash-user at gnucash.org
>>> To update your subscription preferences or to unsubscribe:
>>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>>> If you are using Nabble or Gmane, please see
>>> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
>>> -----
>>> Please remember to CC this list on all your replies.
>>> You can do this by using Reply-To-List or Reply-All.
>> _______________________________________________
>> gnucash-user mailing list
>> gnucash-user at gnucash.org
>> To update your subscription preferences or to unsubscribe:
>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>> If you are using Nabble or Gmane, please see
>> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
>> -----
>> Please remember to CC this list on all your replies.
>> You can do this by using Reply-To-List or Reply-All.
>
>
>
> ------------------------------
>
> Subject: Digest Footer
>
> _______________________________________________
>
> gnucash-user mailing list
> gnucash-user at gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -----
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
>
> ------------------------------
>
> End of gnucash-user Digest, Vol 224, Issue 11
> *********************************************
More information about the gnucash-user
mailing list