Re: [GNC] Can one save report option defaults?
> On May 4, 2022, at 7:49 AM, Chris Green wrote: > > On Wed, May 04, 2022 at 09:36:19AM -0500, David Carlson wrote: >> On Wed, May 4, 2022 at 9:32 AM Chris Green wrote: >> >>> I find I nearly always change the same five or six report options >>> every time I want a new report. For example I nearly always want to >>> select all accounts (at least initially) and I want the secondary sort >>> key to be Date. >>> >>> Is there any way I can set up GnuCash so the report options always >>> start with the values I want? >>> >> At the top of the report there is a button labelled "Save Config/" >> > Yes, I know that. However it only saves the settings for one report > and when you retrieve it you get exactly the report you saved. What I > want is to be able to save the more general report settings so that > whenever I open a new report I get those settings. > > There's already a few things that can be configured 'system wide' in > Edit->Preferences->Reports, for example you can set the default > currency for *every* report there. I'd like to be able to set more > things like this so that they apply to every report. Then I won't have > to set/unset the same half-dozen or so things I have to change every > time I create a new report. The problem is that I sometimes forget > some of them! :-) The report option defaults are hard-coded in the report code. That design makes it impractical to add a lot of customizations to the preferences system. The route to custom report option defaults is custom reports: You can copy those files (in the sources in gnucash/report/reports/standard) edit the defaults to your liking and install them as custom reports, see https://wiki.gnucash.org/wiki/Custom_Reports <https://wiki.gnucash.org/wiki/Custom_Reports> for detailed instructions. But you can also get there with saved configurations too, because you can open a saved configuration, change some options, and save that as a new saved configuration. You'll need to work out a naming convention if you have a lot of them so that you can easily find the one you want in the saved config dialog. Regards, John Ralls ___ gnucash-user mailing list gnucash-user@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.
Re: [GNC] Large GnuCash file very slow to write to
Is this about your python program being slow or about GnuCash being slow? Note that Piecash isn't GnuCash and we don't provide any support for it, nor obviously can we provide any support for your program. If it's a GnuCash problem, please provide more details about exactly what you're doing and what step is taking 20 minutes. Regards, John Ralls > On May 8, 2022, at 4:50 AM, Tim Hume via gnucash-user > wrote: > > It is an SSD drive (I'm using a Mac Mini about one year old - with the M1 > chip). > > The slow part seems to be saving the database - inserting the transactions is > fast enough, the save operation is what takes so long. It may be 20 minutes - > I haven't timed it. Even closing GnuCash is slow - perhaps 30 seconds to a > minute. > > Sent with ProtonMail secure email. > --- Original Message --- > On Sunday, May 8th, 2022 at 11:40, Kenneth Schneider > mailto:kschnei...@bout-tyme.net>> wrote: > > >> I don’t believe the file is getting too large. If you haven’t looked into >> using an SSD drive at least for the database I highly recommend it. Not only >> will you amazed at how fast data will be written to the file but also how >> fast you will be able to generate reports. >> >> Ken Schneider >> >>> On May 8, 2022, at 7:24 AM, Tim Hume via gnucash-user >>> gnucash-user@gnucash.org wrote: >>> >>> Hi, >>> >>> My GnuCash file (SQLite format) has become rather large - 110 MBytes. Every >>> month or two I import a lot more transactions in CSV format. I use piecash >>> in a Python script I wrote, because the importing of CSV data built into >>> GnuCash crashes when I import too many transactions. >>> >>> I might be importing perhaps 4000 or 5000 transactions. Saving them into my >>> GnuCash file takes many many minutes. I know my file is getting too large, >>> but it surely shouldn't take 10+ minutes to do this operation? Whilst I do >>> it, I can see Python is taking 100% of a CPU core. >>> >>> Come the end of the financial year (30 June) I'm going to start a new file. >>> But this will quickly grow in size, and no doubt I'll run into this problem >>> again. Is there anything I can do to speed this up, or do I just have to >>> live with it? >>> >>> Cheers, >>> >>> Tim. >>> >>> Sent with ProtonMail secure email. >>> ___ >>> gnucash-user mailing list >>> gnucash-user@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@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@gnucash.org <mailto:gnucash-user@gnucash.org> > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > <https://lists.gnucash.org/mailman/listinfo/gnucash-user> > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists > <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@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.
Re: [GNC] Errors after restarting GnuCash 4.10 from terminal or bash script
> On May 9, 2022, at 9:50 PM, davidcousen...@gmail.com wrote:
>
> I have just setup getting finance quotes for Gnucash for the first time for GC
> 4.10 on Linux Mint 20.3. I was setting up a shell script to shutdown GnuCash,
> update the finance quotes and restart GnuCash after the quotes had been
> written
> to the datafile. The finance quote seems to work ok but when I restarted
> GnuCash
> from the script, the following appeared in the terminal after the script
> exited.
>
> $ Traceback (most recent call last):
> File "/usr/lib/python3/dist-packages/gnucash/gnucash_core_c.py", line 14, in
> swig_import_helper
>return importlib.import_module(mname)
> File "/usr/lib/python3.8/importlib/__init__.py", line 127, in import_module
>return _bootstrap._gcd_import(name[level:], package, level)
> File "", line 1014, in _gcd_import
> File "", line 991, in _find_and_load
> File "", line 975, in _find_and_load_unlocked
> File "", line 657, in _load_unlocked
> File "", line 556, in module_from_spec
> File "", line 1166, in create_module
> File "", line 219, in _call_with_frames_removed
> ImportError: libgncmod-app-utils.so: cannot open shared object file: No such
> file or directory
>
> During handling of the above exception, another exception occurred:
>
> Traceback (most recent call last):
> File "/usr/local/share/gnucash/python/init.py", line 2, in
>from gnucash import *
> File "/usr/lib/python3/dist-packages/gnucash/__init__.py", line 6, in
>
>from gnucash.gnucash_core import *
> File "/usr/lib/python3/dist-packages/gnucash/gnucash_core.py", line 31, in
>
>import gnucash.gnucash_core_c as gnucash_core_c
> File "/usr/lib/python3/dist-packages/gnucash/gnucash_core_c.py", line 17, in
>
>_gnucash_core_c = swig_import_helper()
> File "/usr/lib/python3/dist-packages/gnucash/gnucash_core_c.py", line 16, in
> swig_import_helper
>return importlib.import_module('_gnucash_core_c')
> File "/usr/lib/python3.8/importlib/__init__.py", line 127, in import_module
>return _bootstrap._gcd_import(name[level:], package, level)
> ModuleNotFoundError: No module named '_gnucash_core_c'
> Found Finance::Quote version 1.51.
>
> I get the same error with no additional info restarting GnuCash from the
> command
> line with --debug. It seems to be more associated with the python bindings
> than
> anything to do with getting online quotes. I do compile with -D
> WITH_PYTHON+ON
> when I build it. Haven't ever started GC from a script or terminal recently
> but
> I presume this happens from the desktop launcher as well, just isn't visible.
>
> Has anyone struck this before?
I see that sometimes when I build GnuCash with -D WITH_PYTHON=ON and run from
the build directory without installing.
It's safe to ignore, being about the python console feature and not affecting
anything in GnuCash proper.
Regards,
John Ralls
___
gnucash-user mailing list
gnucash-user@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.
Re: [GNC] Documentation changes needed
> On May 11, 2022, at 8:30 AM, Phillip Duff wrote: > > (Needs to have added here for Mac users that if you install XTools, you > already have both Git and make (which ic buried further down, too late). We > should simply recommend that Xtools is installed, whether it is 4Gb is > irrelevant in today’s world generally, and we should move away from command > line wherever possible for documenters. I think you mean Xcode that is indeed enormous. There's a smaller alternative for command line work called "the command line developer tools". You can install that directly with `Xcode-select --install` but since MacOS X 10.11 (El Capitan) or so there are stubs for the included commands that pop up a dialog box asking if you want to install them, so just type `git` at a terminal prompt and click OK. Regards, John Ralls ___ gnucash-user mailing list gnucash-user@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.
Re: [GNC] Documentation changes needed
> On May 11, 2022, at 8:30 AM, Phillip Duff wrote: > > For the Mac at least, CMake has a user interface, but for some reason the > author wants to bring everything back to command line level, so the Make > interface should be referenced. Not sure about Linux, so we can leave the > command line in for that. > > Except that when I run Cmake pointing to the src and build directories and > enabling Mobi, I get errors. > > Can’t find fop, you will be unable to generate pdf files. > > CMake Error in guide/C/CMakeLists.txt: > The custom command generating > > /Users/philduff/Documents/gnucash-build/share/gnome/help/gnucash-guide/C/fdl-appendix.xml > > is attached to multiple targets: > > C-gnucash-guide-check > C-gnucash-guide-ghelp > C-gnucash-guide-html > C-gnucash-guide-epub > > but none of these is a common dependency of the other(s). This is not > allowed by the Xcode "new build system”. > > Note that I set the environment to Xtools since it is installed and this > seemed like a reasonable assumption. > Any help ?? I'm not familiar with the Cmake GUI interface, but it doesn't look from what I find on the web that its able to run its build function from the GUI. The CMakeLists aren't set up in a way that's friendly for IDEs so you really are best off using the command line. After generating the build system with cmake you can use `cmake --build . --target html` but it's less typing to use `make html` or better (see next item) `ninja html`. I suggest that you also install ninja (https://ninja-build.org/ <https://ninja-build.org/>), it's much faster than make. Just tell cmake `-G Ninja` or select Ninja in the cmak-gui to get ninja build files instead of Makefiles. There's a binary available on the website or you can install it with either package manager. It's not necessary for documenters to build PDF, ePub, or MOBI documentation so don't worry about FOP. Regards, John Ralls ___ gnucash-user mailing list gnucash-user@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.
Re: [GNC] unrealized gain / losses for mutual funds
> On May 15, 2022, at 8:15 AM, Andrea Borgia wrote: > > Problem is, the example applies to a painting, that is an object whose value > changes, not shares whose number remains constant but whose value changes, > thus leading to a change in total valuation. There's no accounting difference between a painting and a share of stock, though using a painting for the example forecloses the opportunity to discuss a long-running account having multiple purchases and sales of the asset type because Degas paintings are one-offs while shares of, say, Apple are fungible. > On May 15, 2022, at 8:43 AM, Michael or Penny Novack > wrote: > > Likewise your "pictures" asset account (I take it that this is a mutual fund > investing in "unfungible assets" like artworks) No, it's about the example in the Tutorial and Concepts Guide. The author chose to be cute and use a painting as the example asset. ___ gnucash-user mailing list gnucash-user@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.
Re: [GNC] unrealized gain / losses for mutual funds
> On May 15, 2022, at 8:15 AM, Andrea Borgia wrote: > > Since the end goal is to derive unrealized P&L and then include those in the > economic result for the year, I thought I could record a fake sale, after all > at book opening the next year I do a fake purchase (with same price, just one > day apart). If this makes sense, how do I compute the P&L given the new > price? Must I do that manually with a split or is there some kind of > assistance by GnuCash? That's called marking to market and it's not directly supported by GnuCash. You'll have to manually "sell" your assets at the FMV on the last day of the old accounting period and buy them at that same FMV on the first day of the new period. You'll compute cap gains on the sale as usual but you'll maintain separate realized and unrealized cap gain income accounts. When you finally sell the asset for real you'll create a pair of splits that transfers all of the unrealized capital gains for those shares to the realized cap gains account. That won't be too hard as long as you buy and sell whole positions all at once--e.g. you bought 100 shares of AAPL and sold them all at once later without ever buying or selling in between. If that's not how you invest then you'll have to either invent a way of keeping track of each purchase lot or an average-cost model. For a discussion of the latter see https://bugs.gnucash.org/show_bug.cgi?id=797796 <https://bugs.gnucash.org/show_bug.cgi?id=797796>. The Balance Sheet report automatically computes an Equity:Unrealized Gains line item if you use the "price nearest to report date" price source option. You can compute that as an income value by comparing it to the same line item for the previous period. Regards, John Ralls ___ gnucash-user mailing list gnucash-user@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.
Re: [GNC] Am I in business?
I've been using * ^TO_gnucash-user@(lists\.)?gnucash\.org in my procmail file for 15 years or so. Hasn't failed me yet. Other lists have moved infrastructure and have needed recalibration, but it's never frequent enough to be a bother. Regards, John Ralls > On May 17, 2022, at 6:18 PM, arthur brogard via gnucash-user > wrote: > > You're right. I get just as many individual emails addressed to me either > way, don't I? > > But what do I use for the filter? Can't be 'from' if I want to catch both > for they differ. Can't be 'subject' for that differs. > > > >On Wednesday, 18 May 2022, 10:33:16 am ACST, Derek Atkins > wrote: > > Hi, > > On Tue, May 17, 2022 7:07 pm, arthur brogard wrote: >> >> Hello and thankyou. >> I'm 'replying to all' in response to your direct email I just got here. >> Great. >> Hope I'm doing it right. >> So it seems to me I should run two accounts with the list. Because I like >> to see what's being discussed at the same time as I don't like the hassle >> of responding to those who respond to me in the hassly way we have to do >> it when using the digests. >> So I can have the digests to open and peruse whenever I feel like it, no >> hurry. >> And I can be running a normal email - email thread about my queries at the >> same time in the second account. >> That'd be alright, I guess? > > Yes, you could subscribe twice (with two addresses). Although I don't > really see the point of doing that. You might as well just tell your > email client to file all the gnucash email into its own folder and then > you can peruse the subjects that way instead of using a digest AND > individual emails. Because you still need to *find* the individual email > to reply to... > > But hey, whatever works for you. > > -derek > > -- > Derek Atkins617-623-3745 > de...@ihtfp.comwww.ihtfp.com > Computer and Internet Security Consultant > > > ___ > gnucash-user mailing list > gnucash-user@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@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.
Re: [GNC] Crypto trade directly - not converting to local currency first
> On May 23, 2022, at 5:32 AM, Michael or Penny Novack > wrote: > > Are there any folks in Ithaca NY using gnucash to track the local "currency"? > << or in the other places where a "local currency" is in use >> For those who > don;t know what I am talking about, the "Ithaca Hour" is a work exchange > currency. Nominally pegged at $10/US but there is not supposed to be currency > exchange << is there a "black market" exchange rate? >> Using a non-currency for trade is barter. https://www.irs.gov/taxtopics/tc420 <https://www.irs.gov/taxtopics/tc420> sketches the reporting requirements for US taxpayers. Regards, John Ralls ___ gnucash-user mailing list gnucash-user@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.
Re: [GNC] Strange incorrect due date calculated on a duplicated bill
10:59:00 the canonical "neutral" time, chosen so that the date doesn't change regardless (almost) of time zone. Regards, John Ralls > On May 30, 2022, at 4:10 PM, Adrien Monteleone > wrote: > > I'm using SQLite, but the time stamp for posting is: > > 2021-11-07 10:59:00 > > Which seems to be a regularly used stamp, for this vendor at least. > > A subsequent duplicated bill (off of this one) for December correctly > calculated Net20 from 12/7 as 12/27. (also using the 10:59:00 stamp) > > Regards, > Adrien > > On 5/30/22 5:54 PM, Derek Atkins wrote: >> Hi, >> First, yes, the attachment came through. >> Second, you posted on the 7th and the due date is the 26th. >> My initial guess, as it's a Net20, is that there is a TimeOfDay issue at >> hand here, where the addition of 20 days is such that it thinks it's >> before the 27th. >> Did you actually post it? If so, can you take a look at the XML for the >> invoice and see what date/time is actually presented? > > ___ > gnucash-user mailing list > gnucash-user@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@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.
Re: [GNC] Program suddenly very slow
> On May 31, 2022, at 7:59 AM, David T. via gnucash-user > wrote: > > Hello, > > I'm a long time user, running 4.10 on Windows 10. All of a sudden, I am > finding significant lag (2-4 seconds) on every action I take, whether it is > changing a field or entering a transaction. > > I've tried killing all other applications and rebooting, but the lag remains. > > Has anyone else seen this behavior? > > David T. > > P.S. I tried googling the issue using "site:lists.gnucash.org", but ended up > with a ton of entries for the documentation. Why is the documentation > mirrored on lists.gnucash.org? What about your computer changed at the time of "all of a sudden"? Windows update, different hardware, installed a new program? Is there any indication of what's the source of the bottleneck in Task Manager's performance tab? Is the slowdown the same if you create a new book? Does "changing a field" include committing the transaction or is the slowdown apparent when typing into the field or tabbing to the next one? As for the PS, it's because lists.gnucash.org is just an alias for code.gnucash.org (so is wiki.gnucash.org). Try `site:lists.gnucash.org/pipermail` to restrict it to the mailing list archives. Regards, John Ralls ___ gnucash-user mailing list gnucash-user@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.
Re: [GNC] Securities Namespace
CURRENCY and NONCURRENCY are built in; the former applies to the ISO4217 currencies that are also built in, the latter is a default for everything else that a user hasn't created a namespace for. Regards, John Ralls > On Jun 5, 2022, at 6:44 AM, Fred Tydeman wrote: > > On Sun, Jun 5, 2022 at 1:20 AM Geoff wrote: > >> Q1. Use the Security Editor and type over the incorrect Namespace (in >> the "Type" field). >> > > I tried to change NONCURRENCY to Cash-Crypto by typing over NONCURRENTCY. > That did not change it. Instead, it left NONCURRENCY alone and made a new > Namespace: Cash-Crypto. > > >> Q2. I have found that if you delete all Securities for the Namespace, >> it disappears from the Securities Editor and the Price Editor. See >> attached screenshot. >> > > Agree > ___ > gnucash-user mailing list > gnucash-user@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@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.
Re: [GNC] Missing 2nd entry
No, it's called a stock split. Nothing new about it at all. Regards, John Ralls > On Jun 9, 2022, at 7:46 AM, David Carlson wrote: > > That screen shot appears to show a security purchase without a price. Is > this a new way to create wealth? > > On Thu, Jun 9, 2022, 9:28 AM David Carlson > wrote: > >> Clearly I did not recall correctly about when this became possible. >> >> On Thu, Jun 9, 2022, 8:53 AM Stan Brown >> wrote: >> >>> >>> On 2022-06-09 04:59, David Carlson wrote: >>>> The capability for zero value transactions with a single account line >>> was >>>> permitted starting in release 3 point something iirc as hinted by >>>> Christopher. >>>> >>>> I complained at the time, but it technically is not unbalanced. The >>>> reason it is allowed is that it can function as a vehicle for a comment >>>> entry. >>> >>> I create single-line transactions with zero value in 2.6.19, exactly for >>> the purpose of recording a comment. >>> >>> -- >>> Stan Brown >>> Tehachapi, CA, USA >>> https://BrownMath.com >>> ___ >>> gnucash-user mailing list >>> gnucash-user@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@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@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.
Re: [GNC] Startup issue - two windows
The "no scheduled transactions" dialog is modal (see https://en.wikipedia.org/wiki/Modal_window) so it blocks the rest of GnuCash until it's dismissed. Unfortunately that includes dismissing the splash screen so that you can see it. I think the splash screen is getting pushed to the front by the loading status bar. Adrien has already suggested that you turn off the status bar and the tip-of-the-day dialog in preferences; you could also disable Show notification window in the Scheduled Transactions tab in Preferences. That will suppress the "no scheduled transactions" dialog from displaying. Regards, John Ralls > On Jun 10, 2022, at 7:42 AM, Fred Tydeman wrote: > > Another screen shot to show when I get when things are "hung". > Now, I can move all the windows (except splash screen) around on the screen. > The little one hidden behind the splash screen says: > > There are no scheduled transactions to be entered at this time. > (2 transactions automatically created). > > Clicking on Close in the Tip of the Day window does nothing. > Clicking on the "X" of fjt-tex-check account does nothing. > Clicking on Close of the scheduled transactions window works > and it and the Splash screen disappear. > > Now, I can close the Tip of the Day window. > > On Fri, Jun 3, 2022 at 7:15 AM Adrien Monteleone < > adrien.montele...@lusfiber.net> wrote: > >> Per my other reply, send over the current screen resolution. >> >> I can play with this later today to see if I can duplicate the effects. >> > 07-31-31.png>___ > gnucash-user mailing list > gnucash-user@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@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.
Re: [GNC] Startup issue - two windows
Adrien, There are two dialogs. The regular SLR one that shows you the transactions that were created and gets you to input values for any variables in your SX isn't modal. The message box that comes up if you have nothing to review, shown in Fred's screenshot, is modal. Which one you get depends on how you've set up your SXes and which ones have fired since you last ran GnuCash or Actions>Scheduled Trasnsactions>Since Last Run. Regards, John Ralls > On Jun 10, 2022, at 6:30 PM, Adrien Monteleone > wrote: > > I find it odd though that the SX window is hogging focus. Perhaps this is a > Desktop/OS thing. > > Mine is not. (on MacOS BigSur) > > Though of course, I understand, all of us, regardless of OS are dealing with > GTK when using GnuCash, so I'm not *really* using Mac's desktop for this app. > (though maybe some code-translation rules apply?) > > I've played around with this issue and can't seem to duplicate the condition > where I get an SX window that tells me transactions were auto-created and > requiring me to dismiss it before anything else frees up. (modal) > > I'll play some more, but perhaps this is an SX setting issue? (I tell it to > remind me, and auto-create, and I opt to review, but I've turned various of > those off and on to no avail) > > Regards, > Adrien > > On 6/10/22 11:41 AM, john wrote: >> The "no scheduled transactions" dialog is modal (see >> https://en.wikipedia.org/wiki/Modal_window) so it blocks the rest of GnuCash >> until it's dismissed. Unfortunately that includes dismissing the splash >> screen so that you can see it. I think the splash screen is getting pushed >> to the front by the loading status bar. >> Adrien has already suggested that you turn off the status bar and the >> tip-of-the-day dialog in preferences; you could also disable Show >> notification window in the Scheduled Transactions tab in Preferences. That >> will suppress the "no scheduled transactions" dialog from displaying. > > ___ > gnucash-user mailing list > gnucash-user@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@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.
Re: [GNC] How to reorganize the account tree
Account type is a number, not a string. You can see what number goes with what type at https://github.com/Gnucash/gnucash/blob/65eae554bec2d360600c7ff62ac72d92665c1f59/libgnucash/engine/Account.h#L105. That shouldn't have anything to do with anything if you assign codes to accounts, display the account code column in the Accounts tab, and click on its header to sort by it. You can easily tell which column is used for sorting and in which direction by the arrow icon that appears on the right of the column's header. Regards, John Ralls > On Jun 13, 2022, at 12:09 PM, Gyle McCollam wrote: > > Alan, > I noticed that the accounts under assets are not sorted in alpha order when I > assign account codes to the major cats, namely the Assets (1), Liabilities > (2), Equity (3), Income (4), and Expense (5). I have determined this is due > to the Asset account type being broken down into Assets, Bank, and Cash. For > some reason Cash comes before Asset, which comes before Bank. I was thinking > it was sorting on Type even though I didn't have "Type" displayed, but having > Cash before Asset types negates that reasoning. > > Also, wanted to let you know that sorting this way also put the Imbalance and > Orphaned account as the first 2 entries. I have my accounts filtered by > View/Filter By.../Other and I removed all the check marks. The accounts only > display when they have a balance, which since they are at the top of the list > really makes them stand out. > > > Thank You, > Gyle McCollam > > Gyle McCollam > > 609.680.2326 Mobile > > gmccol...@live.com<mailto:gmccol...@gyleshomes.com> email > > > From: gnucash-user on > behalf of Alan A Holmes > Sent: Sunday, June 12, 2022 3:12 AM > To: ja...@comcast.net ; gnucash-user@gnucash.org > > Subject: Re: [GNC] How to reorganize the account tree > > As Adrien said in his reply if you sort on the Account Name column it should > be okay. > > Personally, I sort on the Hidden column which I have displayed, mainly > because it puts the Imbalance and Orphan accounts together at the bottom of > the list and enables me to find errors in transactions quickly. > What I do notice sorting this way is that within the top level accounts > (Assets, Expenses, Income, etc.) that the 2nd and subsequent level Accounts > under Assets AREN'T sorted alphabetically, while those under Expenses and > Income ARE. I have insufficient sub-accounts under Equity and Liabilities to > be able to say. > > > Alan A Holmes > > -Original Message- > From: gnucash-user > On Behalf Of > ja...@comcast.net > Sent: 11 June 2022 12:29 > To: gnucash-user@gnucash.org > Subject: [GNC] How to reorganize the account tree > > I have been using gnucash for nearly 20 years. My account lists were a mess > until this spring when somehow I spent a day or two reorganizing everything > into a new and very well organized account tree. For the life of me, I > don't remember how I was able to do that without losing the 20 years of data > stored in my accounts. I would like to reorganize the order in which my > bank accounts are listed to make them in alphabetical order but I cannot > find a way to move the accounts in the account tree. I can go to the parent > account but that does not give me control to move the accounts around. > >Can someone tell me how to move accounts around in the > account list. Thank you. Chin00kie > > ___ > gnucash-user mailing list > gnucash-user@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@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@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are usi
Re: [GNC] GnuCash 4.11 Release
Gyle, It's intentional, but it's the Gnome design team's intention not ours. The latest version of the standard Adwaita icon theme is all colorless. I've held back the revision on macOS and we're a version behind on flatpak, but we don't have any control over MSYS2 (for Windows) or the various Linux and BSD distros. Regards, John Ralls > On Jun 26, 2022, at 5:09 PM, Gyle McCollam wrote: > > John Ralls, > I want to thank you and the other developers for this great software (4.11). > I know I don't use many of the features available, but what I do use is > fantastic. I want to thank you for fixing the "close with the X" problem in > windows. The work around was OK, but having it work correctly is better. > > I did want to point out that the "Delete" button in the toolbar use to have a > red circle with an X, but ow it is just a black circle with an X. This may > have been intentional, I don't know. No need to respond. My main purpose > for this email is to thank you and the team for all your hard work! > > > Thank You, > > Gyle McCollam > > Gyle McCollam > > gmccol...@live.com<mailto:gmccol...@gyleshomes.com> email > > > From: gnucash-user on > behalf of John Ralls > Sent: Sunday, June 26, 2022 5:39 PM > To: gnucash-annou...@lists.gnucash.org > Cc: gnucash-devel ; Gnucash Users > > Subject: [GNC] GnuCash 4.11 Release > > The GnuCash development team announces GnuCash 4.11, the twelfth release in > the stable 4.x series > Between 4.10 and 4.11, the following bugfixes were accomplished: > >Bug 797163 - qof_book_get_option segfaults when retrieving a non-leaf frame >Bug 798053 - Accounts renumeration (renumbering) >Bug 798471 - Can't see or select Income or Expense accounts in Income Tax > Information GUI >Bug 798483 - GnuCash Crashing With SIGSEGV During QFX Import Transaction > Matching >Bug 798491 - MT940 of day 28.02.2022 ends in transactiondate 01.01.1970 >Bug 798493 - Invoice Report Quantity & Unit Price fields have limited > decimal precision on printed invoices >Bug 798496 - gncEntry Quantity and Discount are misusing commodity scu >Bug 798499 - Expense Chart data tables include extra columns of data >Bug 798500 - FTBFS (tests failure) on armhf >Bug 798501 - Balance wrong date end of period >Bug 798531 - Selecting "Print" from the file menu on a report crashes > gnucash >Bug 798533 - Crash when importing quicken @ currency >Bug 798535 - Crash when increasing the number of periods in a budget >Bug 798547 - Calculated Due Date is short 1 day when posting on day of > fall change from Daylight Time to Standard Time. > > The following fixes and improvements were not associated with bug reports: > >Partially fix Bug 771095 by inserting a help button in the Since-Last-Run > dialog. >Lock down GITHUB_TOKEN permissions on workflows. >[g_option_context_get_help() returns a char* which must be freed. >[assistant-stock-transaction] dividends must include stock account. >Fix arch linux CI build failures. >Add a help button to the financial calculator dialog. >[assistant-stock-transaction] avoid resetting txn_types unnecessarily. >[assistant-stock-transaction] reorder of Pages - date before type. >[import matcher] Only append description if there's something to append > to, Otherwise just set the new string. >[balsheet-pnl] test "lvl <= depth-limit" outside add-indented-row as a > first step trying to fix bug 798502. the bug likely resides in the (if) > conditional in (add-account-row). >[gnc-main-window] page->window is not main_window, skip warning. >[gnc-plugin-page-register] if account==NULL, skip AccountIsPriced because > gnc_plugin_page_register_ui_initial_state may be called for non-account > registers (eg the sx editor) and account may be null. >[gnc-account-sel.c] prepend & reverse while building acct list > >and don't use confusing double pointer >Fix use-after-free in unable to save database dialog. >[account.cpp] restore breadth-first search for 2 functions > >gnc_account_lookup_by_name and gnc_account_lookup_by_code were searching > breadth-first and accidentally changed to depth-first in 4.7. >[account.cpp] gnc_accounts_and_all_descendants converted from scm >[CI]Work around new git security measure. >[balsheet-pnl] faster definition of balance lists >[gnc-numeric.cpp] Reduce logging level of gnc_numeric exception message > because exceptions are expected in some use cases. >Redo icon hand
Re: [GNC] GnuCash 4.11 Release
I changed the wrong line in the header file. Should be fixed now. Regards, John Ralls > On Jun 26, 2022, at 4:02 PM, David H wrote: > > Try > https://sourceforge.net/projects/gnucash/files/gnucash%20(stable)/4.11/gnucash-4.11.setup.exe > - > there's an extra "-1" in the version of the published link as I discovered > a few minutes ago, I'm sure it'll get sorted b4 long :-) > > Cheers David H. > > On Mon, 27 Jun 2022 at 08:47, WD D wrote: > >> Am I too quick? I just tried to download from >> https://www.gnucash.org/download.phtml >> >> The link was trying to download this ... it said file could not be found? >> >> >> https://sourceforge.net/projects/gnucash/files/gnucash%20(stable)/4.11/gnucash-4.11-1.setup.exe >> >> -Original Message- >> From: gnucash-user >> On Behalf Of John Ralls >> Sent: Monday, 27 June 2022 7:39 AM >> To: gnucash-annou...@lists.gnucash.org >> Cc: gnucash-devel ; Gnucash Users < >> gnucash-user@gnucash.org> >> Subject: [GNC] GnuCash 4.11 Release >> >> The GnuCash development team announces GnuCash 4.11, the twelfth release >> in the stable 4.x series Between 4.10 and 4.11, the following bugfixes were >> accomplished: >> >>Bug 797163 - qof_book_get_option segfaults when retrieving a non-leaf >> frame >>Bug 798053 - Accounts renumeration (renumbering) >>Bug 798471 - Can't see or select Income or Expense accounts in Income >> Tax Information GUI >>Bug 798483 - GnuCash Crashing With SIGSEGV During QFX Import >> Transaction Matching >>Bug 798491 - MT940 of day 28.02.2022 ends in transactiondate 01.01.1970 >>Bug 798493 - Invoice Report Quantity & Unit Price fields have limited >> decimal precision on printed invoices >>Bug 798496 - gncEntry Quantity and Discount are misusing commodity scu >>Bug 798499 - Expense Chart data tables include extra columns of data >>Bug 798500 - FTBFS (tests failure) on armhf >>Bug 798501 - Balance wrong date end of period >>Bug 798531 - Selecting "Print" from the file menu on a report crashes >> gnucash >>Bug 798533 - Crash when importing quicken @ currency >>Bug 798535 - Crash when increasing the number of periods in a budget >>Bug 798547 - Calculated Due Date is short 1 day when posting on day of >> fall change from Daylight Time to Standard Time. >> >> The following fixes and improvements were not associated with bug reports: >> >>Partially fix Bug 771095 by inserting a help button in the >> Since-Last-Run dialog. >>Lock down GITHUB_TOKEN permissions on workflows. >>[g_option_context_get_help() returns a char* which must be freed. >>[assistant-stock-transaction] dividends must include stock account. >>Fix arch linux CI build failures. >>Add a help button to the financial calculator dialog. >>[assistant-stock-transaction] avoid resetting txn_types unnecessarily. >>[assistant-stock-transaction] reorder of Pages - date before type. >>[import matcher] Only append description if there's something to >> append to, Otherwise just set the new string. >>[balsheet-pnl] test "lvl <= depth-limit" outside add-indented-row as a >> first step trying to fix bug 798502. the bug likely resides in the (if) >> conditional in (add-account-row). >>[gnc-main-window] page->window is not main_window, skip warning. >>[gnc-plugin-page-register] if account==NULL, skip AccountIsPriced >> because gnc_plugin_page_register_ui_initial_state may be called for >> non-account registers (eg the sx editor) and account may be null. >>[gnc-account-sel.c] prepend & reverse while building acct list >> >>and don't use confusing double pointer >>Fix use-after-free in unable to save database dialog. >>[account.cpp] restore breadth-first search for 2 functions >> >>gnc_account_lookup_by_name and gnc_account_lookup_by_code were >> searching breadth-first and accidentally changed to depth-first in 4.7. >>[account.cpp] gnc_accounts_and_all_descendants converted from scm >>[CI]Work around new git security measure. >>[balsheet-pnl] faster definition of balance lists >>[gnc-numeric.cpp] Reduce logging level of gnc_numeric exception >> message because exceptions are expected in some use cases. >>Redo icon handling in cmake >> >>Using globs for file copying prevents cmake from discovering newly >> added icons. Writing rules that explicitly use lists of ic
Re: [GNC] gnucash-user Digest, Vol 231, Issue 70
Please do not reply to a message when you have a new topic: Start from with a new one. When you do reply to a message in a digest please trim out all but the one message you're replying to and change the subject of your reply to the subject of that one message. It's a major pain to figure out what you're talking about otherwise. I seldom bother. Regards, John Ralls > On Jun 29, 2022, at 5:00 PM, Eric Hammond wrote: > > Resending to proper group > > I set up GnuCash as best possible by extracting what I could from my crashed > Quicken, and many Excel spreadsheets. And 6 months of work. > I got all the info in, but not working properly. > I want to start fresh, almost. > I have created clean CSV files for the AR and AP; and transaction files to > fill in the bank ledgers. > What I need is to clean GnuCash of everything Except the account tree, vendor > and customer database. > (Maybe I missed something, but the exported version of vendor and customer > data has only name and ID number.) > > Any ideas on how to do this, or how to not need to do this are appreciated. > > Thanks, > Eric > > -Original Message- > From: gnucash-user On > Behalf Of gnucash-user-requ...@gnucash.org > Sent: Tuesday, June 28, 2022 9:00 AM > To: gnucash-user@gnucash.org > Subject: gnucash-user Digest, Vol 231, Issue 70 ___ gnucash-user mailing list gnucash-user@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.
Re: [GNC] Printing Chart of Accounts WITHOUT balances
> On Jul 1, 2022, at 7:20 PM, Stan Brown wrote: > > I know everyone coding GnuCash is a volunteer, but I really, really, > REALLY don't understand how anyone can call this "not a bug". Simple: It's an account summary report, not a list of accounts report. If you take away the line item balances then there's no summary going on. There are two options for balance on the Account Summary Report: Subaccount balances/roll-up/none and final balance. Maybe the name or tooltip of the last one could be more clear, but it doesn't mean produce a list of accounts with no actual financial information. Regards, John Ralls ___ gnucash-user mailing list gnucash-user@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.
Re: [GNC] 4.11 missing online banking and AqBanking in Windows
Because it hasn't been fixed. As I suspected the problem is that the GnuCash AQBanking module, libgncmod-aqbanking.dll, is failing to load. It loads correctly when run in a development shell som I'm pretty sure that something is missing from the installation bundle, but I haven't yet figured out what it is. When I have a working installer I'll post an announcement to gnucash-announce, copying gnucash-user and gnucash-devel with the sha256 and download URIs. Regards, John Ralls > On Jul 2, 2022, at 7:01 AM, Gyle McCollam wrote: > > I am correct in thinking that there will be a general announcement when this > has been fixed. I unfortunately, submitted a duplicate bug on this and have > received a couple of emails, but nothing stating this has been fixed. In the > meantime, I had to revert back to 4.10 as online banking, even though I have > been using it for less than a year, has been extremely helpful and speeds up > reconciliation tremendously. > > I will even put up with Gnucash crashing on the occasion where I didn't save > before closing. Can't wait to get back to 4.11 where this is fixed. > > > Thank You, > > Gyle McCollam > > Gyle McCollam > > gmccol...@live.com<mailto:gmccol...@gyleshomes.com> email > ___ > gnucash-user mailing list > gnucash-user@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@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.
Re: [GNC] [GNC-dev] Questions about Import Map Data
> On Jul 4, 2022, at 11:07 PM, Lincoln A Baxter wrote: > > Hi, > > It's been a very long time since I asked a question on this list serve, > and a very long time since I last did a "cleanup" of my GC file (with > perl scripts back then). > > I started keeping my accounting data in GC back in March of 2005. Now > I'm looking to reorganize my chart of expense accounts (again) to > simplify things... when I do that, I'll want to remove the obsolete > Bayes data (again). > > I have a general idea of how the Bayesian import mapper works... Years > ago I wrote some perl scripts to prune it out of the uncompressed XML > file, so I could start it over. But, I'm now looking at the Tools -> > Import Map Editor which I will (belatedly say) is a huge improvement > over mucking about with the xml slot data -- which now looks to be > simplified), especially if all one wants to do, is zero it out. But, > this has lead me to some questions: > > Most of the Bayes data is space tokenized transaction description data. > I get that part. My understanding is that it is scores in this data > that the matcher uses to map transactions to a balancing account. But > I see data, that could not of come from transaction descriptions. Why > are days of the week (Monday, Tuesday, etc) in the Bayes data? Where > does this data come from? How does this help the transaction mapper? > > It looks like the Non-Bayesian data consist of a full (non-tokenized) > transaction descriptions... at least a few of them (nowhere near all of > them... not even close). Given how few I've got (and how old they > appear to be), I don't under stand why this data is here. It is almost > like this was an early attempt to create transaction matching data, > that might have existed since before the bayesian matcher "matured." > So: > > Why does gnucash have these records (and how did they get created)? > Are these records used in transaction mapping? (anymore)... or does > this display exist simply for the purpose of allowing one to nuke them? The day of the week of the transaction posted date is one of the tokens, as are the "words" of the description and of each split's memo. The logic is coded in TransactionGetTokens, https://github.com/Gnucash/gnucash/blob/e9df8d41d2fc838046bc02aed0b05bde53ca9dcd/gnucash/import-export/import-backend.c#L442 and isn't significantly changed from the original contribution in GnuCash 1.9.1, see https://github.com/Gnucash/gnucash/commit/b2ccbf62cf04adddbf3464875c6521582b353964. You're correct that the non-Bayesian matching is just the transaction description. You might have those in your book because at some point you disabled Bayes matching in Preferences, but more likely you imported a QIF file or a CSV file before Geert re-wrote the CSV importer for GnuCash 3.0. The QIF importer doesn't support Bayesian matching so if you import a QIF file those match records are what the importer will use. Regards, John Ralls ___ gnucash-user mailing list gnucash-user@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.
Re: [GNC] Transaction imports
> On Jul 5, 2022, at 5:52 AM, Christian Lynbech wrote: > > Where is the information related to transaction imports saved? I am on a Mac. > > I have my books stored under revision control but when I wanted to do an > CSV import on a another machine, I did not see the import I have defined > when running Gnucash on my main computer. I am guessing/fearing that > this also applies to the learned matching of transactions to accounts. > > How would I replicate such information between computers? The transaction matching tokens are kept in "slots" records belonging to the account into which you were importing the transactions. This is part of the book (i.e. .gnucash) file so you need only copy or share it between machines. Saved report and CSV configurations are kept in the DOT-GNUCASH folder, which on macOS is ~/Library/Application Support/gnucash. See https://wiki.gnucash.org/wiki/Backup for more about where GnuCash keeps data and how to make thorough backups or share books between machines. Regards, John Ralls ___ gnucash-user mailing list gnucash-user@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.
Re: [GNC] Fiscal Year: Preferences vs Properties
> On Jul 7, 2022, at 7:05 AM, Paul Kroitor wrote: > > Hello again, > > > > Perhaps I missed earlier discussions about this, but is there a reason the > Accounting Period is an attribute in the Preferences menu (and thus > system-wide) rather than in the File Properties menu (as all the other > company-specific items are)? > > > > Am I correct that every time I open a set of books with a different fiscal > year, I have to go into Preferences to change the accounting period? If I > don't do this, all the reports use the wrong start and end dates. > > > > This is nuts - I work with four different fiscal years here! > > > > A related issue is why the accounting period specifies a year at all. Surely > it should just be the month and day, since an entity's fiscal period are the > same dates every year (e.g. Sept 1 - Aug 31). > > > > I have the feeling I'm missing something basic about this.. You're not missing anything basic, it's a design decision from the early days of GnuCash; the original design wasn't for business at all, that was bolted on later, and didn't put much emphasis on one user having multiple books nor sharing a book between users. Those design choices are deep and affect both code and stored data so changing them in a way that maintains some sort of compatibility is hard. If you look through the preferences and the way various configuration data are stored--online banking and report configurations for example--it's easy to find more instances of "user" data should be "book" data. No, fiscal years aren't always 365 1/4 days: The first and last fiscal years of an entity are usually truncated, as is one of the fiscal years when the entity changes the beginning of its fiscal year. Regards, John Ralls ___ gnucash-user mailing list gnucash-user@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.
Re: [GNC] Adding a new currency
> On Jul 7, 2022, at 9:23 AM, Esteban Maringolo wrote: > > Hi, > > Is it possible to manually add a new currency to the list of currencies? > > I will take care of updating the exchange rate. No. Currency in GnuCash is defined as "currencies recognized by ISO-4217". Everything else is a commodity. Regards, John Ralls ___ gnucash-user mailing list gnucash-user@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.
Re: [GNC] Saving window position (and size)
Setting aside the tone of Adrien's comments, I think that filing a bug report against the Wayland project would be seriously misplaced. They're just publishing a spec and a model implementaiton. The actual implementation for Gnome is https://gitlab.gnome.org/GNOME/mutter. KDE has a different compositor called Plasma. Compositors take bitmaps for different logical areas of the screen and blend them together to determine what color dot goes at what coordinate, then passes the result to the hardware. Mutter handles both Wayland and X11 protocols for sending the bitmaps and it's possible but unlikely that it's the source of the problem. It's far more likely that the problem is in Gtk's gdk-wayland backend. Gdk is the layer that converts the Window abstraction into drawing instructions that it passes to cairo to execute; it's what decides that an x-by-y window will be represented by what set of colored dots at some position on the screen. So in theory that would be the right place to aim your bug report. In theory. In practice, if you file a bug with Gtk saying "GnuCash remembers where to put my window on X11 but not on Wayland" they won't know what to do with it, so unless you're able to reduce it to a simple example they're not going to be able to figure out what's wrong with their code--if anything is. There's another problem, and it's that GnuCash's Gtk code is still warmed over Gtk2 code with the absolute minimum done to keep it working in Gtk3. There's tons of deprecated code that we haven't made time to update, partly for lack of time and partly because we support older distributions. It's entirely possible, likely even, that the reason that the window doesn't get put in the right place on Wayland is that GnuCash is calling a deprecated function that's implemented for X11 but not for Wayland. In a perfect world you should file a bug with GnuCash and let us devs figure out where the problem is and whether to push it upstream. Unfortunately there are at present only two core devs who know GUI coding enough to do that, Bob Fewell and me. I can't really speak for Bob but I have far too big a pile of higher priority work to put in the several hours of debugging that problem. It won't do any harm to file that bug but I can't offer much hope that it will get acted upon. Regards, John Ralls > On Jul 12, 2022, at 7:25 PM, Adrien Monteleone > wrote: > > RATS. I hate it when I proof a post but don't stop to think before hitting > 'send.' > > My apologies to the GnuCash team, the moderator, and any readers of this > thread. > > While I stand behind my comments, this is not the forum for such a > discussion. My sentiments aren't about 'using GnuCash' and don't advance the > original question posted. (though I do think a Wayland-related bug report is > in order, if it doesn't exist.) > > I'll strive to pause and reflect more before posting replies rather than just > proofreading. > > Tracy, I'm glad you found the cause and have a work around. Thanks to Martin > for providing a path for investigation, and thank you again Tracy for > reporting back your findings. These posts are what this User list is all > about. > > Regards, > Adrien > > On 7/12/22 9:14 PM, Adrien Monteleone wrote: >> For the simple reason they'll be annoyed and try to ignore the bug report, >> I'd file it. You never know who else has the same problem with various apps. >> Heck, I'd bet the bug is already filed, maybe even closed as 'won't fix'. >> That's even better. File another and make them spend their time marking it >> as a duplicate and closing it. (when their time could be better spent by >> FIXING *their* bug.) >> Normally, I'd never suggest such action, but these folks bring it on >> themselves with their dismissive and haughty attitudes, and you're doing >> nothing wrong reporting or reviving an obvious bug that is indeed, their >> fault. (why introduce Wayland as 'ready' when it isn't? If it works, why >> doesn't it work?) >> I'm sure I'll get admonished for the above, but really the admonishment >> belongs on sour attitudes. Such are not conducive to the Open Source model, >> community, and users providing much needed feedback. >> ** Special Note ** >> GnuCash devs are *not* like this. They'll (at their discretion of course) >> spend an inordinate amount of their personal, volunteer time helping users >> fix something, even if they've helped 10k people before you apply the same >> fix. These folks are golden and have more patienc
Re: [GNC] MariaDB?
None known; in fact we switched the connectors in the Gnucash-built bundles and in flatpak to MariaDB's because MySQL discontinued their C one and the C++ one won't work with libdbi. Regards, John Ralls > On Jul 15, 2022, at 7:40 PM, Thomas Forrester wrote: > > Are there issues with using MariaDB in place of MySQL? > > Thanks. > ___ > gnucash-user mailing list > gnucash-user@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@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.
Re: [GNC] GC4.10 on Win10 Crashing
Remember that you can get automatic save on each transaction by switching to
the Sqlite3 backend by using File>Save As... and selecting Sqlite3 from the
drop-down at the top of the dialog box.
Note that Sqlite3 changes the file in place so there are no GnuCash backups.
Set up File History or some other automatic backup program instead.
That's not to suggest that you shouldn't figure out as much as you can about
the cause of the crashes and then file a bug report. The absolute best
information is a stack trace, but that can be a bit challenging on Windows. See
https://wiki.gnucash.org/wiki/Stack_Trace#Windows for instructions.
Regards,
John Ralls
> On Jul 21, 2022, at 8:47 AM, A Harvey wrote:
>
> I have a similar problem. It occurs in both 4.10.x and 4.11. I think it
> also occurred in 4.9 but can't remember. I encountered it on windows 10
> and windows 11. I run Gnucash monthly. Importing CSV bank and credit card
> statements always works. I don't import investment transactions as
> massaging the data to import as a CSV would be more work than just entering
> them directly. Typically, I either start typing a transaction and then
> accept the suggested description and transfer account, or I duplicate an
> existing transaction and modify the amounts. Most of the transactions are
> automatic dividend/interest reinvestments for stock/bond funds.
> Here is the problem. I will enter several investment transactions, then
> type ctl-s or click the save button. Sometimes Gnucash exits without
> saving and without deleting the lock file. This will happen roughly 3
> times over the course of entering 25 or so transactions. Some subset of
> unsaved transactions are lost. I've developed the habit of saving after
> each transaction so that I never have more than one unsaved transaction
> when it crashes. I haven't been able to detect any pattern with respect to
> which accounts, what types of transaction or other factors may be
> involved. Restarting Gnucash and reentering the lost transaction exactly
> as before works fine.
>
> I will enable the logging (-debug and -extra? I'll read the Wiki on how to
> turn that stuff on) and check the trace file next time I run Gnucash to see
> whether it captures anything useful when and if it crashes again.
>
> Regards,
> -Arthur
>
> On Wed, Jul 20, 2022 at 2:16 AM David T. via gnucash-user <
> gnucash-user@gnucash.org> wrote:
>
>> I apologize if my response seemed testy. It's extremely frustrating to be
>> working on a large data set with lots of complex transactions ("How exactly
>> should the capital gains for a stock position with multiple purchase lots
>> and an intervening split be tracked?"), finally work out how those complex
>> transactions get recorded, enter them, go to save the result, only to have
>> the program crash out.
>>
>> I will certainly try closing at least the one report I have open, as your
>> idea that the report derives information from that reconciled account seems
>> a reasonable possibility.
>>
>>
>>
>> On July 20, 2022 12:42:42 AM GMT+03:00, Adrien Monteleone <
>> adrien.montele...@lusfiber.net> wrote:
>>> I wasn't trying to cause you work, just offering ideas on tracking down
>> the cause. Eliminating variables is part of that process. Lots of tabs and
>> especially reports open = variables.
>>>
>>> I'm going to hazard there is a report that feeds off one of those
>> registers (likely the one you are reconciling) that is a good candidate,
>> thus closing everything but that register should reveal if that is the case.
>>>
>>> But perhaps an upgrade to 4.11 would suit you better. You'll end up there
>> most likely anyway.
>>>
>>> Regards,
>>> Adrien
>>>
>>> On 7/19/22 1:41 PM, David T. via gnucash-user wrote:
>>>> Adrien,
>>>>
>>>> Thanks for the suggestions.
>>>>
>>>> It would seem to me that Finish/Ctrl-S is pretty reduced.
>>>>
>>>> I currently have about 12 tabs open. 10 registers, the CoA, and one
>> report (granted, it's a multicolumn report).
>>>>
>>>> Saving after every edit is a remarkably annoying idea, especially given
>> how long each save takes. I won't be doing that.
>>>>
>>>> As for a backup, I'm not sure why I'd go to a backup. The problem
>> doesn't always happen, so I don't believe it's a problem with data
>> corruption. I'm trying to move forward with my books, not backward.
>>>>
>>>> Nothing
Re: [GNC] Symbolic links (MacOSX)
> On Jul 23, 2022, at 10:38 AM, Peter S. Shenkin wrote: > > Hi, > > I'm getting back to gnucash after a long hiatus. I'm also starting up using > Gnucash on a different computer. So I copied the Gnucash directory to > ~/Documents/work/Foo/ on the new computer. (The name Foo was changed to > protect the innocent. Or is it the guilty?) > > Gnucash had been in ~/work/Foo on the old computer, so set up a symbolic > link in ~/work called Foo pointing to ~/Documents/work/Foo. To my surprise, > I got a msg that Gnucash couldn't parse the URL, and another, after > dismissing that dialog, that Gnucash could not open the file. > > Eventually, as kind of a Hail-Mary pass, I replaced the symlink with an > actual copy (cp -pR) of the Foo directory from ~/Documents/work to ~/work, > and then Gnucash could read it. > > This struck me as extremely bizarre. I have two questions. > > - Can Gnucash really not read through symlinks on MacOS? > - Note that my Privacy settings allow Gnucash to read the ~/Documents > directory, to which the symlink points. > - In retrospect, I guess I should have tried using a MacOS "alias" > instead of a symlink, but I don't know if that would have worked > any better. > - There is nothing in Privacy to specify that Gnucash can read ~ or > ~/work, but apparently this is not needed. > - Suppose I now want to tell Gnucash to use the data in > ~/Documents/Foo/Gnucash. Is there a way for me to do this without losing my > history? (Or my sanity?) I just tested a regular symlink and an alias. GnuCash had no trouble opening a file through the symlink using File/Open or subsequently reopening the file on launch. Perhaps you misspelled something when you made the symlink. Navigating through macOS alias files requires opening files through CFURL. boost::filesystem doesn't know how to do that so neither does GnuCash. FWIW bash and zsh don't either. GnuCash has access to Documents, Downloads, Desktop, and Network drives in System Settings>Privacy & Security>Files and Folders (I'm running macOS 13 developer beta on this mac). It does not have full disk access. I suppose that the history you have in mind is the list of most recently used files at the bottom of the File menu. The simplest way to migrate to the new directory is to use File>Open to open each in turn ***bottom to top***. Regards, John Rals ___ gnucash-user mailing list gnucash-user@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.
Re: [GNC] need to teak the default invoice script - new user
> On Jul 25, 2022, at 3:42 AM, peter wrote: > > Hello all, > > I am new to GNUcash - spent many hours getting to grips with the new system > (came from Quick Books) and finally got my small business accounts set up and > working reasonably well. > > However, I operate two trading names of the same business and need to be able > to invoice the two types of clients with different invoice layouts/content. > > Could someone please tell me the following:- > > Where is the default invoicing script stored, so that I can tweak the > code to my needs for client type 1 ? > > How can I add a print menu / toolbar item, that points to an alternative > "default" invoice script, that I can use for client type 2 ? > > I have spent many hours playing with the built in facility to change invoice > layout, but it doesn't quite meet my needs. > > I am using GNUcash 4.8 running on Ubuntu 22.04 > > Any help to point me in the right direction would be greatly appreciated. > The invoice report's source should be at /usr/share/guile/site/2.2/gnucash/reports/standard/invoice.scm. I suggest you copy it to a convenient place in your user directory and proceed to customize it into the two invoice reports you need. There's a pretty extensive page on custom reports at https://wiki.gnucash.org/wiki/Custom_Reports. Once you've modified and installed the custom reports according to the instructions on that page they'll appear on the Reports menu. It's not currently possible to use the Print Invoice button to run a custom invoice report, but Bob Fewell is working on adding that to GnuCash 5 that we'll release next spring, see https://github.com/Gnucash/gnucash/pull/1333. Regards, John Ralls ___ gnucash-user mailing list gnucash-user@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.
Re: [GNC] Stock Name Change Best Practices
> On Jul 25, 2022, at 5:58 AM, David T. via gnucash-user > wrote: > > Hello, > > I'm seeking advice from the group about the best way to handle a ticker/name > change for a held stock. > > For example, Facebook renamed itself Meta a while back, and in June they > changed their ticker from FB to META. Naturally, I wish the Gnucash books to > reflect these changes; I also want price retrieval to continue to work. > > The simple approach is to edit the account name and the security info and > change them to the new name. Facebook, the Gnucash security and the account > entries, get changed to META. This approach seemingly works fine; the > holdings change in the CoA and retrieval of prices resumes. > > However, something about this feels incomplete. It feels like some > information about the holdings gets lost this way. Or am I over thinking > this? That's what I've always done, so I think that you're over-thinking it. After all, the name change has no material effect on the underlying asset. If it really bugs you you could create a new security and account and transfer the shares. When you get around to selling the stock you'll have to look at the original account to get the basis, but that's not that big a deal; a bigger one might be that it will probably break the Advanced Portfolio Report. I don't use that, but if you do you'll probably prefer to just change the name on the existing security and account. Regards, John Ralls ___ gnucash-user mailing list gnucash-user@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.
Re: [GNC] Linked Documents on Import
Piecash isn't supported either, because it also doesn't use the GnuCash API to
write to the database.
The supported way--that works with either the XML or SQL backend--is to use the
Guile or Python bindings to the GnuCash libraries. You can also write your
program in any compiled language that can link to C libraries. The API
documentation can be found at https://code.gnucash.org/docs/MAINT.
Regards,
John Ralls
> On Jul 25, 2022, at 6:54 AM, Robert Simmons wrote:
>
> I definitely wouldn't expect this to be supported. I did take a look at
> PieCash and see how it handles working with the "slots" table. There
> doesn't appear to be any other housekeeping that is done other than the
> INSERT commands. As long as the INSERTS are properly formed and I'm not
> doing this with gnucash running at the same time, the outcome so far
> appears to satisfy my requirement to add linked documents programmatically.
>
> Thanks to the people who suggested PieCash.
>
> Here is one of the stretches of code in PieCash that deals with that
> particular table:
>
> https://github.com/sdementen/piecash/blob/fcf36d8e315bd13183b166ff928b691c622f1360/gnucash_books/reference/3_0/default_3_0_0_full_options.gnucash.sql#L252-L329
>
> On Mon, Jul 25, 2022 at 8:57 AM Derek Atkins wrote:
>
>> You are definitely doing something terrible.
>> You are modifying the database from under GnuCash.
>> That is completely not supported and you may destroy your data.
>> -derek
>> Sent using my mobile device. Please excuse any typos.
>>
>> On July 25, 2022 7:42:04 AM Robert Simmons wrote:
>>
>> This seems to do the trick. Not sure if I'm doing something terrible here.
>>> I don't recommend you do this unless you know what you're doing (I don't
>>> lol).
>>>
>>> https://gist.github.com/utkonos/1dad74716828c591c9839711fdb12f22
>>>
>>> import pathlib
>>> import sqlite3
>>>
>>> bills = [{'id': '01',
>>> 'date_opened': '12/31/2018',
>>> 'owner_id': '01',
>>> 'billingid': '123123123123',
>>> 'notes': '',
>>> 'date': '',
>>> 'desc': 'Widget',
>>> 'action': 'Material',
>>> 'account': 'Expenses:Office Supplies',
>>> 'quantity': 1,
>>> 'price': '1000.00',
>>> 'disc_type': '',
>>> 'disc_how': '',
>>> 'discount': '',
>>> 'taxable': '',
>>> 'taxincluded': '',
>>> 'tax_table': '',
>>> 'date_posted': '12/31/2018',
>>> 'due_date': '12/31/2018',
>>> 'account_posted': 'Liabilities:Accounts Payable',
>>> 'memo_posted': '',
>>> 'accu_splits': ''},
>>> {'id': '01',
>>> 'date_opened': '01/31/2019',
>>> 'owner_id': '01',
>>> 'billingid': '123123123126',
>>> 'notes': '',
>>> 'date': '',
>>> 'desc': 'Widget',
>>> 'action': 'Material',
>>> 'account': 'Expenses:Office Supplies',
>>> 'quantity': 1,
>>> 'price': '1000.00',
>>> 'disc_type': '',
>>> 'disc_how': '',
>>> 'discount': '',
>>> 'taxable': '',
>>> 'taxincluded': '',
>>> 'tax_table': '',
>>> 'date_posted': '01/31/2019',
>>> 'due_date': '01/31/2019',
>>> 'account_posted': 'Liabilities:Accounts Payable',
>>> 'memo_posted': '',
>>> 'accu_splits': ''}]
>>>
>>> doclinks = {
>>>'01': {
>>>'doclink': 'Path/To/Some1.pdf'
>>>},
>>>'02': {
>>>'doclink': 'Path/To/Some2.pdf'
>>>}
>>> }
>>>
>>> db_path = pathlib.Path('testfile.gnucash')
>>> con = .sqlite3connect(db_path)
>&g
Re: [GNC] tutorials or examples for connecting/programming for GnuCash data access
> On Jul 25, 2022, at 9:30 AM, Eric Hammond wrote: > > Are there tutorial examples / videos for using Python and/or Sqlite3 to work > with GnuCash. > I have never used Sqlite, and my Python experience is mostly industrial, and > outdated. > (Like, what are bindings?) Google found no GnuCash programming tutorials, though it did find some Piecash ones. There's https://wiki.gnucash.org/wiki/SQL-Requests_For_Direct_Database_Access for SQL. It's not specifically about SQLite3 but you can read their docs for using the command-line tool. Bindings are wrapper functions, in our case created by SWIG, that translate between e.g. Python and the C/C++ in which the GnuCash engine is written. There's some information in https://wiki.gnucash.org/wiki/Python_Bindings and a brief mention in https://www.gnucash.org/docs/v4/C/gnucash-guide/ch_python_bindings.html. There are some examples in https://github.com/Gnucash/gnucash/tree/maint/bindings/python/example_scripts. Regards, John Ralls ___ gnucash-user mailing list gnucash-user@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.
Re: [GNC] tutorials or examples for connecting/programming for GnuCash data access
Please remember to copy the list on all replies. While providing a stable library for other applications to use is a long-term goal we've still got a fair amount of work to do before we can support it. Until then we make absolutely no API or ABI stability guarantees for the shared libraries: On the contrary, we plan extensive API changes and internal redesigns that will substantially affect ABI as well. Because of the long-standing ability to write custom reports in Guile we will mark as deprecated changes in the Scheme API, including wrapped C/C++ functions. Deprecated functions will be removed at the subsequent major release, meaning that any Scheme function that raises a deprecation warning in 4.x will be removed in 5.0. No such warnings will be made for C/C++ API nor for the Python bindings. Regards, John Ralls > On Jul 26, 2022, at 7:13 AM, Esteban Maringolo wrote: > > I'm interested in this as well... > > Being able to use GNUCash as an "accounting engine" for other software > would be a great feature. > > The only thing I found was PieCash [1], but it seems to write directly > to the database and not by calling internal functions/shared libraries > of GnuCash. > > Regards, > > [1] https://github.com/sdementen/piecash > > Esteban A. Maringolo > > On Mon, Jul 25, 2022 at 3:08 PM john wrote: >> >> >> >>> On Jul 25, 2022, at 9:30 AM, Eric Hammond wrote: >>> >>> Are there tutorial examples / videos for using Python and/or Sqlite3 to >>> work with GnuCash. >>> I have never used Sqlite, and my Python experience is mostly industrial, >>> and outdated. >>> (Like, what are bindings?) >> >> Google found no GnuCash programming tutorials, though it did find some >> Piecash ones. >> >> There's >> https://wiki.gnucash.org/wiki/SQL-Requests_For_Direct_Database_Access for >> SQL. It's not specifically about SQLite3 but you can read their docs for >> using the command-line tool. >> Bindings are wrapper functions, in our case created by SWIG, that translate >> between e.g. Python and the C/C++ in which the GnuCash engine is written. >> There's some information in https://wiki.gnucash.org/wiki/Python_Bindings >> and a brief mention in >> https://www.gnucash.org/docs/v4/C/gnucash-guide/ch_python_bindings.html. >> There are some examples in >> https://github.com/Gnucash/gnucash/tree/maint/bindings/python/example_scripts. >> >> >> Regards, >> John Ralls >> >> ___ >> gnucash-user mailing list >> gnucash-user@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@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.
Re: [GNC] tutorials or examples for connecting/programming for GnuCash data access
If you mean the gnucash-x.x-setup.exe distributed as part of releases, it's built on Windows in the MSYS2 environment using gcc. You're correct that the Python bindings aren't included. That's also the case for the macOS GnuCash.app and flatpak. The reason is that the bindings must be linked against libpython so we'd have to include a full python instance in the bundle and we think that would add too much bloat to an already large download. Users who want to use the Python bindings will have to build GnuCash themselves; the recipes are published at https://github.com/gnucash/gnucash-on-windows, https://github.com/gnucash/gnucash-on-osx, and https://github.com/gnucash/gnucash-on-flatpak. Regards, John Ralls > On Jul 25, 2022, at 9:49 PM, flywire wrote: > > TLDR: GnuCash Windows version is compiled on linux so, considering the > note below, you are unlikely to get python bindings working in > Windows. > > >> Important > >> The Python extensions are an optional feature which creates additional >> dependencies. To be >> able to use Python scripts, GnuCash must have been built with the cmake >> -DWITH_PYTHON=ON … >> option enabled, otherwise all what follows won’t work. At present this >> option is not >> enabled by default, so if you need this, you may have to compile GnuCash >> from source >> yourself. But some distributions offer it also as a separate package with a >> name like >> python[version]-GnuCash > > > I'd happily be shown wrong about python bindings being easily > accessible under Windows. > > > Piecash is about the only alternative but iirc the demos are hidden in > the code repository. Try: > https://lists.gnucash.org/pipermail/gnucash-user/2021-July/097124.html > ___ > gnucash-user mailing list > gnucash-user@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@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.
Re: [GNC] Find
No, Edit>Find is not an option for finding an account, nor is it a bug. Read the dialog's title. Regasrds, John Ralls > On Jul 29, 2022, at 1:17 PM, Alan Magnus via gnucash-user > wrote: > > What version of GnuCash and on what operating system? > > I am using Gnucash 11.1 on Mac OS13 > > The account does appear I the account Tree but it was quicker to find it > using the Find Account feature. > > Another option is *from the Accounts tab* use Edit >Find (the plain one, not > Find Account) to search for transactions. > > > This does not bring up a list of accounts. > There are transactions in the account. > I think its a bug. >> On 28 Jul 2022, at 11:45 am, Alan Magnus via gnucash-user >> wrote: >> >> Somehow Find has stopped working for me. When I select Fins Account from the >> Edit list and type in the Account name it is not found. Any suggestions? >> ___ >> gnucash-user mailing list >> gnucash-user@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@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@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.
Re: [GNC] MacOS - could not complete critical test of libdbi
There may be some useful error messages in the trace file--see https://wiki.gnucash.org/wiki/Tracefile. If you're also on macOS and using version 11 or later console output is available again after many years of being sent to /dev/null. Open /Applications/Utilities/Console, select your computer from the sidebar, click start streaming in the middle of the window, and run your GnuCash or DBBrowser session. When done return to Console, click the pause button, and use the search bar for terms like gnucash and sqlite. I've been encountering the DBI error intermittently in the last year or so too. I can't make it happen consistently enough to debug it, and it has never stopped me from being able to open a Sqlite3 file. Regards, John Ralls > On Aug 2, 2022, at 8:47 AM, km22 wrote: > > I have downloaded DB Browser for Sqlite and have been trying different > combinations of opening the file and remounting the drive and/or rebooting > the system. As best as I can tell, after I open and close the file in > Gnucash once, I cannot then re-open it with Gnucash nor DBBrowser. It seems > the first time I open the file in Gnucash causes there to be a lock. I need > to reboot the machine to open it again. I’ll experiment more but any ideas > are welcome. > > Thanks, > Ken > > >> On 2 Aug 2022, at 23:15, km22 wrote: >> >> Hi, >> >> I am a new user of MacOS having recently bought a MacBook Air (after many >> years of being a Gnucash user on Windows and Linux). >> >> I was able to open my existing GnuCash file and add some transactions. But >> after closing GnuCash and trying to re-open the file I get the following >> error: >> >> GnuCash could not complete a critical test for the presence of a bug in the >> "libdbi" library. This may be caused by a permissions misconfiguration of >> your SQL database. Please see >> https://bugs.gnucash.org/show_bug.cgi?id=645216 >> <https://bugs.gnucash.org/show_bug.cgi?id=645216> for more information. >> >> This looks like a very old bug that was resolved long ago. I see comment >> #19 suggests to copy the file but that did not work for me. >> >> Any other advice I should consider? >> >> My system is: >> MacOS Monterey version 12.5. >> GnuCash Version: 4.11, Build ID: 4.11+(2022-06-25) >> >> Thanks, >> Ken >> >> > > ___ > 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. ___ 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.
Re: [GNC] gncJobNextID in gncJob.c not in gncJob.h
All of the incrementFooID functions are declared in the respective private headers, so that functionality is not intended to be public API. The why is lost to history, those functions were created in a drive-by contribution. Your workaround of writing directly to the database is ill-advised unless your script is going to create jobs and immediately exit. The engine loads the database into memory once at the beginning of the session and doesn't read it again, so any changes you make direct to the database like that are invisible to the current session. Regards, John Ralls > On Aug 7, 2022, at 1:14 PM, Robert Simmons wrote: > > Little error there. I improved the query while writing: "This sets the Job > ID counter to 3, but you would change that 3 to whatever the ID you want." > should be "This increments the Job ID to the next" > ___ > 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. ___ 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.
Re: [GNC] gncJobNextID in gncJob.c not in gncJob.h
The intended end-user process is to use the program, not the bindings. As to why the job-creating functions don't increment the counters, I think because the design allows the user to override the counter-based ids in the GUI. Derek wrote the code so he's the authority on the why's and wherefores. As a general statement GnuCash is not designed as a library around which you can implement your own program. Consequently it's a huge steaming pile of spaghetti with a lot of functionality implemented in the wrong places and many parts lack a carefully thought-out API. We're working on fixing that but we don't have a lot of resources so it's going to take a long time. We decided on the overall framework almost 10 years ago and haven't gotten very far. Regards, John Ralls > On Aug 8, 2022, at 5:45 AM, Robert Simmons wrote: > > If these functions are not public, why don't the proper functions for > creating Jobs and other objects increment the counters? > > If I'm understanding correctly, Python bindings provide no way to increment > counters (since exposing some of those incrementX functions were mistakenly > not in the private headers)? After running code based on Python bindings, > the user is expected to manually increment the counters in the UI? > > I just want to establish what the intended end user process is supposed to > be. > > On Sun, Aug 7, 2022 at 10:56 PM john wrote: > >> All of the incrementFooID functions are declared in the respective private >> headers, so that functionality is not intended to be public API. The why is >> lost to history, those functions were created in a drive-by contribution. >> >> Your workaround of writing directly to the database is ill-advised unless >> your script is going to create jobs and immediately exit. The engine loads >> the database into memory once at the beginning of the session and doesn't >> read it again, so any changes you make direct to the database like that are >> invisible to the current session. >> >> Regards, >> John Ralls >> >> >>> On Aug 7, 2022, at 1:14 PM, Robert Simmons wrote: >>> >>> Little error there. I improved the query while writing: "This sets the >> Job >>> ID counter to 3, but you would change that 3 to whatever the ID you >> want." >>> should be "This increments the Job ID to the next" >>> ___ >>> 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. >> >> > ___ > 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. ___ 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.
Re: [GNC] gncJobNextID in gncJob.c not in gncJob.h
There's no hidden feature in GnuCash. SQL: select count(*) from transactions; and select count(*) from splits; grep an uncompressed XML file: grep -c '' path/to/file.gnucash; use '' to count the splits. You can also look at the top of your XML file between the book slots and the commodities to find a block that looks like 406 757 34279 4 4505 1 1 1 1 1 Regards, John Ralls > On Aug 8, 2022, at 2:43 PM, R. Victor Klassen wrote: > > Just out of curiosity, how does one determine those numbers? An SQL query? > grep | wc on the xml? Some feature of gnuCash I’ve never > discovered? > >> On Aug 8, 2022, at 3:54 PM, Derek Atkins wrote: >> >> >> On Mon, August 8, 2022 3:21 pm, Robert Simmons wrote: >>>> Accounting systems primarily perform the same operation on large numbers >>> of data elements. >>> >>> I wish I had time to devote to this. I use graph databases in many of the >>> other systems that I develop. This would be a great pivot point on which >>> to >>> create a new open source project and see which paradigm really is better. >>> But really I need to get my data organized and then handed off to an >>> accountant (so I can get back to working on my real work). >> >> My GnuCash database, which has data going back to at least 2007, only >> contains 26781 transactions, with 59582 splits (at least 2 per >> transaction), over a total of 564 "accounts". >> >> Even if you increase by a factor of 10, I doubt you're going to see any >> significant performance differences between databases of similar nominal >> performance. >> >>> Please remember to CC this list on all your replies. >>> You can do this by using Reply-To-List or Reply-All. >> >> -derek >> >> -- >> Derek Atkins 617-623-3745 >> de...@ihtfp.com www.ihtfp.com >> Computer and Internet Security Consultant >> >> ___ >> 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. > > ___ > 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. ___ 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.
Re: [GNC] How To Get Job Object?
GUIDs belong to the parent class QofInstance, so you use qof_instance_get_guid(my_job) Regards, John Ralls > On Aug 10, 2022, at 5:42 PM, Robert Simmons wrote: > > I have created a number of Jobs. Now I want to associate an invoice with > one of the jobs. I can see there is a function "book.JobLookup()" but the > argument this takes is GncGUID. I don't know how to create this GUID > object, and the only way I can see to get the GUID is to just do a SQL > query directly to the DB. > > The other way that I have found to get to those job objects is to go from a > customer to the associated jobs using cust.GetJoblist(). This does return a > list of objects "". > Looking at the object's directory, there are not the expected methods for > showing the Job name or other attributes: > > ['__class__', > '__delattr__', > '__dir__', > '__doc__', > '__eq__', > '__format__', > '__ge__', > '__getattribute__', > '__gt__', > '__hash__', > '__init__', > '__init_subclass__', > '__int__', > '__le__', > '__lt__', > '__ne__', > '__new__', > '__reduce__', > '__reduce_ex__', > '__repr__', > '__setattr__', > '__sizeof__', > '__str__', > '__subclasshook__', > 'acquire', > 'append', > 'disown', > 'next', > 'own'] > > Can someone point out how to either make a GncGUID object or to get from > those GniJob objects to the job name? > ___ > 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. ___ 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.
Re: [GNC] How To Get Job Object?
And that's pretty much the way the GUI works too.
BTW do you know about the Doxygen-generated docs for the C API? It's a bit
patchy in parts, but there's a ton of useful info. You can build it yourself or
use our nightly builds at https://code.gnucash.org/docs/MAINT.
Regards,
John Ralls
> On Aug 10, 2022, at 5:59 PM, Robert Simmons wrote:
>
> When I'm done with all this, I'm going to contribute new example scripts.
> The current documentation for the Python bindings is very excellent. It's
> some of the best documentation I've ever seen. It's a pleasure to use and
> saves a ton of time.
>
> Here is the only way that I can find of getting from zero to the job that I
> want and then associate that job with an invoice:
>
> import gnucash
> import gnucash.gnucash_business
>
> def get_jobs(book):
>query = gnucash.Query()
>query.search_for('gncJob')
>query.set_book(book)
>job_list = list()
>for result in query.run():
>job_list.append(gnucash.gnucash_business.Job(instance=result))
>query.destroy()
>return job_list
>
> The resulting list is objects with the expected methods. You then loop
> through them and find the one you're looking for.
> ___
> 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.
___
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.
Re: [GNC] Tax Accounting for Trust Income Received in Following Fiscal Year
> On Aug 11, 2022, at 6:06 AM, flywire wrote: > > It's tax time again and I'm wondering if I can improve on the process I > described in > https://lists.gnucash.org/pipermail/gnucash-user/2021-August/097424.html > > It works and keeps my accountant happy but it just doesn't seem to sit well > with double-entry accounting to just ignore a few accounts at tax time and > slip in a funny-money cheat sheet for ETF (Mutual Fund?) investments. I'd > welcome any suggestions for a better way of doing it. > > Attached is an ETF statement. The total of each of the 10 Tax codes in the > top section for all ETFs is reported in the attached guide on p4. > > The Cash distributions are on the bottom left and the Attribution is on the > bottom right don't match. I understand the issue is summarising different > tax treatments for Dividends, Franking credits, Realised capital gains, > Interest, and Foreign Income categories. I'd prefer to enter what is > relevant into GnuCash but I don't understand the accounting. I also > understand there are different ways of accounting for tax but any guidance > would be welcome. > > I don't want to get into the detail of setting up an investment portfolio > as explained in the guide and I can't see that it addresses this issue. I'd > be happy to revalue the few funds at the end of each tax year (with > guidance) for the balance sheet. > > This should feed into the financial statements for the trust which owns the > ETF units and distributes the proceeds each year. The Cash distribution has > been distributed with pro-rata funny-money reported. > > [image: VAS-annual-tax-statement-2018.png] > Nobody here is qualified to give you either accounting or tax advice. You need to hire one or more locally licensed professional advisors to guide you. With the disclaimer out of the way, I guess it's down to what you have to report on your taxes. In the US neither an ETF nor a mutual fund (a Registered Investment Company or RIC in the US tax code) would give you a breakdown like that. In both cases the only tax event that either generates are periodic dividends. Those come in 4 flavors and one can simply set up an income account for each flavor. These instruments all represent a corporation that is responsible for filing and paying its own taxes so the internals are opaque to the investor just like common and preferred stock holders. Then there are pass-through entities. These may be small corporations in which the investor is actively involved or some flavor of partnership. There are very large partnerships called Master Limited Partnerships that trade on the stock exchanges. A lot of these are structured so that the periodic payouts are called "returns of capital" until the nominal basis of one's holdings is exhausted; in US tax law these reduce one's basis in the investment increasing the capital gain when the investment is liquidated but accruing no tax in the meantime. All of these pass-through entities report to the investors annually their share of the company's/partnership's internal results: Revenues, expenses, special tax items, etc. and those amounts are applied to the investors tax return. I don't think that it's sane to try and track those amounts in one's personal accounts. Transfer the numbers into your tax software or include the forms in the bundle you send to your tax preparer and be done with i t. Much less common than any of those is the investment pool, sometimes marketed as a "Managed Portfolio", generally as a way for banks and brokerages to extract more fees from trusts and high net-worth clients who otherwise pay a fixed percentage of their portfolio as an annual fee in lieu of commissions on trading. They typically have exorbitant management fees, often more than 5% compared to the .5-1.5% for actively-managed mutual funds or .1% and less for ETFs and index funds. These vehicles can invest in all manner of things and generally pay no taxes themselves, handing off the investors share of every income category to add to their own tax returns. The statement that you posted looks like it might be from one of these. As in the MLP case I don't think it's practical to try and set up accounts in your own books matching the investment pool's holdings. It's too hard. Make an income account for the gross payouts and leave the tax reporting details in your tax software or tax prepar er. Regards, John Ralls ___ 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.
Re: [GNC] Share Values recording
Not quite enough. STOCK and FUND accounts inherit the currency of their nearest non-STOCK/FUND parent, so if you trade in stocks on foreign exchanges you need to set up your tree like e.g. Assets:Investments (type ASSET in your home currency, e.g. ILS) Stocks-ILS (type ASSET, currency ILS) AZRM (type STOCK, commodity AZRM) Stocks-EUR (type ASSET, currency EUR) A5M (type STOCK, commodity A5M) DTE (type STOCK, commodity DTE) Stocks-GBP (type ASSET, currency GBP) RR. (type STOCK, commodity RR.) And so on. If you do happen to have some symbol overlap between exchanges, which isn't common but does happen, then it might be helpful to tag them with the currency as Adrien suggests. The alternative is to create the two in separate namespaces. Don't try to use the same security with different currencies: The pricing code isn't written with that in mind and you may get weird results. Use trading accounts. Juggling multiple currencies and commodities without them will make you crazy. Note that IFRS and most GAAPs require that you value all transactions in the book's home currency. GnuCash doesn't enforce that and for personal book-keeping it may or may not matter depending on what you need to prepare your taxes. Consult with a local tax expert if you're not sure. Regards, John Ralls > On Aug 12, 2022, at 7:59 AM, Adrien Monteleone > wrote: > > I'm pretty sure the Guide (or Help) covers other/multi-currency questions > with regards to stocks. > > The account has to be of the same currency as the stocks. So even if you buy > the same stock but in different currencies, you'll need separate accounts for > each stock & for each currency—e.g., > > TickerSymbol-GBP > TickerSymbol-EUR > > Regards, > Adrien > > On 8/12/22 5:23 AM, Mahon Finbar wrote: >> In the guide the assumptions seem to be US based?? >> For example I have one of my share which is quoted on the Israel Stock >> Exchange, and others on the Irish, UK, etc. >> How do I get those in? Another neophyte question. > > > ___ > 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. ___ 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.
Re: [GNC] Scheduled transactions do not appear in the register until is pressed
That's just the noise from GnuCash not finding perl when deciding whether it should enable online quote retrieval. I have a new hypothesis that I wrote up on bug 794584: That line in the SLR code only runs in the dialog's OK handler, and if you have only automatic-creation SXes that don't require human intervention that particular bit of code doesn't run. I haven't yet looked for the code that does run in that case, but I asked there if changing any of the SXes to "notify" so that that code does run causes the registers to refresh on their own. Regards, John Ralls > On Aug 11, 2022, at 8:02 PM, Tom Veik wrote: > > The last time this occurred would be the first run on the 10th. Here is the > contents of the trace file with the earliest time on that date: > > * 07:53:46 WARN [gnc_spawn_process_async()] Could not spawn > perl: Failed to execute child process (No such file or directory) > * 07:53:46 ERROR <> gnc_process_get_fd: assertion 'proc' failed > * 07:53:46 ERROR <> gnc_detach_process: assertion 'proc && proc->pid' failed > > Tom > > On 8/11/2022 8:05 PM, John Ralls wrote: >> I'd go with bug: It's supposed to refresh all of the registers, see >> https://github.com/Gnucash/gnucash/blob/41de4cefce621c214c0d6f6ff1c5ca05df8fd917/gnucash/gnome/dialog-sx-since-last-run.c#L1168 >> >> You may find in your trace file one or more error messages "suspend counter >> not zero" from gnc_gui_refresh_all on a session where the SLR ran. That >> would indicate that something else that's wrapping the SLR invocation has >> also blocked gui refreshes. If that message isn't there then there's >> something going wrong in gnc_gui_refresh_internal. >> >> Regards, >> John Ralls >> > ___ > 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. ___ 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.
Re: [GNC] Tax Accounting for Trust Income Received in Following Fiscal Year
One of these years I'll find time to rewrite that chapter. I don't know of any case where someone in GnuCash's target user base of individuals and very small companies would need to book unrealized gains that way; mostly only big financial companies need to do that. The normal way of tracking portfolio performance runs off of the price database. The account balances on the Accounts page are converted to the book's root currency at the most recent price in the price database and most reports default selection is to use the price nearest in time to the report date. You can create prices with the Add button in the Price Database dialog, Tools>Price Database. Regards, John Ralls > On Aug 12, 2022, at 8:33 PM, flywire wrote: > > Despite the example in my previous post, I'm inclined to just manage the > share portfolio value rather than the shares by revaluing annually as > described in > https://www.gnucash.org/docs/v4/C/gnucash-guide/capgain_example1.html#capgain_exampleunrealized2 > . It involves an Income:Unrealized Gains transaction and I'd prefer not to > generate that under income. How does revaluation work when shares are set > up directly? I can't see an Income:Unrealized Gains transaction. ___ 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.
Re: [GNC] Crash in Trial Balance report
> On Aug 13, 2022, at 6:12 AM, Fred Tydeman wrote: > > I am running Linux and GnuCash 4.11 > When I try to do a Trial Balance report, I get a crash. > Screenshot attached. > I assume it is due to bad data somewhere, > but I have no idea where or what it is. > 09-09-47.png>___ The failure is in computing the average cost of some security and I think it's hitting a failed conversion, maybe a divide-by-zero. You should be able to figure out which security by comparing the numbers in the list with the values of the first transactions in the security's register. Hope you don't have too many securities to examine. Regards, John Ralls ___ 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.
Re: [GNC] Zero balances in report
> On Aug 13, 2022, at 7:54 AM, Michael Hendry wrote: > > On 13 Aug 2022, at 14:08, Fred Tydeman wrote: >> >> I am running Linux and GnuCash 4.11 >> I do an Account Summary report. >> I have set the options to not show zero balances. >> Yet, the report shows many zero balances. >> The attached screen shot shows part of the report >> along with the options. >> > 09-01-37.png>___ >> 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. > > I’ve just tried this, and when I untick “Include accounts with zero total > balances” and tick “Omit zero balance figures” I get the desired output. > > Did you remember to hit the “Apply” button after changing these tick-boxes? That's not it, you can see that the apply button is greyed out in the screenshot. The report is summarizing all of the commodities held in some parent account including the zero balance ones. I'm not sure if that's a bug or a feature, but to get the display I think you want go to the Accounts tab of the report options dialog and increase the account depth so that the individual commodity accounts are displayed. Regards, John Ralls ___ 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.
Re: [GNC] Crash in Trial Balance
Try increasing the account depth to 6 so that Acciones Open End and $cop are included. What is the report currency? Regards, John Ralls > On Aug 14, 2022, at 7:07 AM, Fred Tydeman wrote: > > As suggested in other emails, I looked at the price data base. I did find > two 0 entries and one very strange entry. I removed them, but the Trial > Balance report still crashes. > > Also, I did figure out what was meant by "list of numbers" in the last line > of the trace. > Most of those were values in a couple of commodity accounts. I looked at > those accounts and did not see anything wrong. > > By playing with the Options and selecting different accounts, I was able to > get a crash with just one account selected. Now, it is a different kind of > crash. But, if we can figure out what is wrong here, we might fix the > other problem. > > Attached is a screen shot of the crash. And of the one account. > > USD is my default currency. That crashing account is in COP. > ___ > 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. ___ 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.
Re: [GNC] Crash in Trial Balance
> On Aug 14, 2022, at 7:18 AM, flywire wrote: > > They look big numbers. I wonder if it's an overflow issue. Not that big. Display is 64-bit integers with computation done in 128 bit, so 18 digits each for numerator and denominator for display and 36 digits each for computations. Regards, John Ralls ___ 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.
Re: [GNC] Crash in Trial Balance
> On Aug 14, 2022, at 1:07 PM, Fred Tydeman wrote: > > > > On Sun, Aug 14, 2022 at 1:43 PM john <mailto:jra...@ceridwen.us>> wrote: >> Try increasing the account depth to 6 so that Acciones Open End and $cop are >> included. > > I changed it to "All" levels and it still crashes. > >> What is the report currency? > > USD. > > If I switch to COP, then that crash goes away. > When the depth is "all" does crash make the same stack trace? Do you have a GBP->USD rate in pricedb? It's interesting though because IIUC that single account appears to be priced in USD. One would think that it would be the USD report that works and the GBP one that crashes. Regards, John Ralls ___ 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.
Re: [GNC] Online Currency Exchange Rates
Jim,
Interesting. that would require a couple of changes to
Finance/Quote/CurrencyRates/AlphaVantage.pm, so how's your Perl? PRs to
https://finance-quote/finance-quote/.
Regards,
John Ralls
> On Aug 14, 2022, at 8:25 PM, Jim DeLaHunt wrote:
>
> On 2022-08-14 14:42, John Ralls wrote:
>
>> We got a bug report,https://bugs.gnucash.org/show_bug.cgi?id=798599, this
>> morning reporting that currency exchange rates aren't working.
>>
>> After a bit of fiddling I got an intelligible error message:
>> Thank you for using Alpha Vantage! This is a premium endpoint. You may
>> subscribe to any of the premium plans athttps://www.alphavantage.co/premium/
>> to instantly unlock all premium endpoints.
>>
>> The cheapest one is $50/month. I don't think anyone here will find that
>> attractive. Finance Quote offers three other sources for exchange rates but
>> it will take a bit of work on our scripts to make that accessible to
>> GnuCash. In the meantime anyone needing currency exchange rates will have to
>> get them from the web and create prices manually.
>
> Thank you, John. I too noticed the problem retrieving rates. It is nice to
> have an explanation. Maybe AlphaVantage just recently reclassified this API
> endpoint from free to premium.
>
> Looking at the AlphaVantage API documentation, I see that the
> CURRENCY_EXCHANGE_RATE function[1] is (now) marked "Premium", but the
> FX_DAILY function[2] is not. It looks like Finance::Quote is using the
> former[3].
>
> I just tried using both endpoints, using my free API key. I see the same
> error message you cite for CURRENCY_EXCHANGE_RATE, but I got a response for
> FX_DAILY.
>
> Could Finance::Quote and GnuCash switch to using FX_DAILY? I would be
> delighted if one call to Get Quotes in GnuCash gave me 100 days of exchange
> rate history!
>
> I opened an issue #229 "AlphaVantage.co function CURRENCY_EXCHANGE_RATE no
> longer accepts free API keys." with Finance::Quote in Github[4].
>
> Example of exercising the AlphaVantage API functions with a free API key
> (elided here):
>
> %
> curl"https://www.alphavantage.co/query?function=CURRENCY_EXCHANGE_RATE&from_symbol=EUR&to_symbol=USD&apikey=elided";
> {
> "Information": "Thank you for using Alpha Vantage! This is a premium
> endpoint. You may subscribe to any of the premium
>plans athttps://www.alphavantage.co/premium/ to instantly unlock all
> premium endpoints"
> }
> %
> curl"https://www.alphavantage.co/query?function=FX_DAILY&from_symbol=EUR&to_symbol=USD&apikey=elided";
> {
>"Meta Data": {
>"1. Information": "Forex Daily Prices (open, high, low, close)",
>"2. From Symbol": "EUR",
>"3. To Symbol": "USD",
>"4. Output Size": "Compact",
>"5. Last Refreshed": "2022-08-15 03:00:00",
>"6. Time Zone": "UTC"
>},
>"Time Series FX (Daily)": {
>"2022-08-15": {
>"1. open": "1.02570",
>"2. high": "1.02683",
>"3. low": "1.02380",
>"4. close": "1.02470"
>},
>"2022-08-14": {
>
> …[elided]…
>
>},
>"2022-03-28": {
>"1. open": "1.09938",
>"2. high": "1.11363",
>"3. low": "1.09705",
>"4. close": "1.09938"
>}
>}
> }
>
> [1] <https://www.alphavantage.co/documentation/#currency-exchange>
> [2] <https://www.alphavantage.co/documentation/#fx-daily>
> [3]
> <https://github.com/finance-quote/finance-quote/blob/0cfaced5ca98e7cd01ede237a73d3a70f40e2403/lib/Finance/Quote/CurrencyRates/AlphaVantage.pm#L56>
> [4] <https://github.com/finance-quote/finance-quote/issues/229>
> ___
> 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.
___
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.
Re: [GNC] Crash in Trial Balance
> On Aug 14, 2022, at 9:00 PM, Fred Tydeman wrote: > > On Sun, Aug 14, 2022 at 11:22 PM john <mailto:jra...@ceridwen.us>> wrote: >> When the depth is "all" does crash make the same stack trace? > > The traces are the "same" except for the hex numbers after the word > "procedure" > >> Do you have a GBP->USD rate in pricedb? > > Yes, I do. But, I do not understand why you are asking about GBP. > >> It's interesting though because IIUC that single account appears to be >> priced in USD. One would think that it would be the USD report that works >> and the GBP one that crashes. > > The parent account is an Asset account in USD > One subaccount is a Cash account in COP > The other subaccount (the one that crashes) is a Mutual Fund account > in a stock symbol that I made up. > > They all have valid values in the pricedb. Sorry, I misread COP as GBP. So you have a security denominated in USD but the trades are in COP. If you open the $COP register and put a transaction in split view and do Edit Exchange Rate (it's in the right-click context menu) on each split, do they all have exchange rates? if not which one doesn't? Create a test book and insert just those transactions. Does the report still crash? If so open a bug and attach the test book so I can work on it directly. Regards, John Ralls ___ 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.
Re: [GNC] Saving a New Book doesn't allow format selection
Please remember to copy the list on all replies. Reply-all (often a double arrow pointing left) does it. Some mail programs also have a reply-list button or menu item. We generally mean "the book" to refer to a single GnuCash file and its accounts. That comes from the name an internal data structure, but it's also a bit of accounting jargon. You've no doubt heard phrases like "book value", "booking an invoice", and of course the infamous "two sets of books" and "cooking the books". Regards, John Ralls > On Aug 16, 2022, at 5:35 PM, Phyllis Bruce wrote: > > I’m new to GnuCash and prolly don’t know what you are talking about when you > say book? I might use that term book to describe a different file > altogether, like my GnuCash file and my playgnucash file. When I created the > play file I just saved my GnuCash file with a new name so I could test > scenarios. > >> On Aug 16, 2022, at 3:16 PM, John Ralls wrote: >> >> >> >>> On Aug 16, 2022, at 11:56 AM, David T. via gnucash-user >>> wrote: >>> >>> Hello, >>> >>> I was just testing something out with a new book, and when I went to save >>> this new book, I was unable to select the storage format for the new book. >>> I would have imagined that I would be able to tell GnuCash to use a >>> specific format (like SQLite3) when I save a new book, but this option only >>> appears on the Save As dialog. Should this be changed? >> >> Yeah. PR welcome. >> >> Regards, >> John Ralls >> >> ___ >> 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. ___ 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.
Re: [GNC] How to bulk import about 130 Securities entries?
> On Aug 16, 2022, at 2:11 PM, Robert Simmons wrote: > >> running the *.gnucash through gunzip, add in the text, and run it back > through gzip > > As a connoisseur of bad ideas for adding data to GnuCash myself, I have to > point out that one should use a programming language that has a library > with support for the structured data format that one wants to add to. You > use the parser provided by the language to generate objects in that > language. You then perform operations on those objects. Finally, you use > the library function to emit well formatted structured data. Not that I would suggest altering your GnuCash data outside of the GnuCash library... Gnome's libxml2 XML library is reasonably comprehensive, widely supported with bindings, and one heck of a lot less weighty than the Apache equivalent. You also don't need to re-gzip the file. As long as you don't break anything GnuCash doesn't care whether it's gzipped or not. OTOH I'm pretty sure that gnc_commodity is fully exposed to the Python bindings so you should be able to write a python script using them to do the same thing without voiding your warranty or needing to unzip the file or, for that matter, caring which backend is used. Regards, John Ralls ___ 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.
Re: [GNC] How to bulk import about 130 Securities entries?
> On Aug 16, 2022, at 8:18 PM, list+gnuc...@jdlh.com wrote: > > On 2022-08-16 19:54, john wrote: > >> OTOH I'm pretty sure that gnc_commodity is fully exposed to the Python >> bindings so you should >> be able to write a python script using them to do the same thing without >> voiding your warranty >> or needing to unzip the file or, for that matter, caring which backend is >> used. > > Ah! Thank you for this nudge, John. I like using Python. Doing my import via > Python would likely be very comfortable for me. > > This question may end up leading me to learn not just how to automate my mac > UI, but also how to use the Python bindings in GnuCash. > > I have been using the macOS GnuCash app downloaded via GnuCash.org, which I > understand does not include Python bindings. However, I use MacPorts all the > time, and it looks like MacPorts will be happy to provide me GnuCash with the > Python bindings enabled. > > I appreciate the pointer. (Well, not pointer exactly, because it is Python > after all, but… reference?) > Jim, It's python wrapped around C, so you may well bump into pointers. ;-) I don't include the python bindings in the macOS app bundle because every release of macOS has a different version of Python, and the bindings have to be linked against the same libpython as the interpreter. MacPorts custom builds everything on your machine so it's easier. If you wanted you could also build GnuCash the way I do and include the python bindings. The instructions are at https://wiki.gnucash.org/wiki/MacOS/Quartz. You didn't mention Homebrew, but I'm going to as a warning to others who might read this thread later: Homebrew's GnuCash is just a cask with my macOS bundle in it. It doesn't use any of the Homebrew infrastructure and so can't use the python bindings. Regards, John Ralls ___ 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.
Re: [GNC] Example of importing Stock transactions from CSV
> On Aug 21, 2022, at 6:37 AM, Jon Schewe wrote: > > On Sat, 2022-08-20 at 12:20 -0400, Michael or Penny Novack wrote: >> On 8/19/2022 10:33 PM, Jon Schewe wrote: >>> So I didn't get the CSV import tool to work. >> >> Perhaps a reminder on what CSV is and is not. >> >> CSV stands for "common separated variables. That means the data is in >> the form of a record consisting of a number of fields delineated by >> commas. Which means two important things. The fields (individual data >> elements) cannot contain commas but even more important, ORDER >> MATTERS. >> >> In other words, the record A,B,C,D is not the same a B,A,C,D << A, B, >> C, >> and D being elements of data, names, amounts, etc. >> >> >> The CSV data you are importing must not only be in CSV format but the >> data must be in the right order AND any data that is null (not >> present >> still has its space in the record. >> >> Thus if a record was supposed to include A, C, and D (B is not >> relevant >> to this record) it would look like A,,C,D and not A,C,D >> >> >> But even the "wrong" examples are in CSV format. >> >> > Yes, I know what a CSV file is and how it should be formatted. The > problem is not with the format of the file, that is handled by GnuCash > just fine. The problem is the mapping of columns in the CSV file to > fields in GnuCash. I cannot figure out the correct mapping to get the > correct transactions. > > > > I have tried all of the following possible mappings between GnuCash > fields and columns in my CSV file. In the end I finally wrote the > python script out of frustration of the import CSV transactions not > working. I'm hoping that someone on this list understands enough python > and the import CSV transactions functionality enough to tell me how to > get the mapping correct. > > # test 2 > > Transfer Account - FUND > Withdrawal - FUND UNITS > Account - Transfer Account > Transaction Commodity - Currency > > Shares are correct. > Close, need to get the dollars right now > > # test 3 > > Transfer Account - FUND > Withdrawal - FUND UNITS > Account - Transfer Account > Transaction Commodity - Currency > Deposit - AMOUNT > > None of the shares or cash lined up. > > # test 4 > > Try swapping withdrawal and deposit > > Transfer Account - FUND > Deposit - FUND UNITS > Account - Transfer Account > Transaction Commodity - Currency > Withdrawal - AMOUNT > > None of the shares or cash lined up. > > # test 5 > > Transfer Account - FUND > Withdrawal - FUND UNITS > Account - Transfer Account > Transaction Commodity - Currency > price - FUND UNITS > > Values don't line up with the price > > # test 6 > > Transfer Account - Transfer Account > Deposit - AMOUNT > Account - FUND > Transaction Commodity - Currency > > Price is right, Shares are the dollars > Shares times price equals dollars. > > > # test 7 > > Transfer Account - Transfer Account > Account - FUND > Transaction Commodity - Fund Commodity > Deposit - FUND UNITS > > Nothing is right, couldn't find the account to transfer from and price > is 1. > The CSV importer doesn't know how to calculate prices and there's no way to tell it the value (in the ttransaction currency), only the amount (in the account's commodity). You should supply the price instead. Ideally that will be the fraction value/amount (multiply both by the power of 10 needed to make them integers, so e.g you'd write $497.65 for 57 shares as 49765/5700. The difference between a deposit column and a withdrawal column is that the latter is sign-reversed. A positive deposit will increase the balance of an asset account and reduce the value of a liability or equity account; a positive withdrawal will do the opposite. Regards, John Ralls ___ 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.
Re: [GNC] USAA OFX Direct connect stopped working
> On Aug 21, 2022, at 7:54 PM, Daffy Duck wrote: > > Hello, > > A while back, USAA changed their OFX stuff and there had to be a > workaround with a PIN, etc. > > I did that, without a problem, but I just noticed today it has broken > again? > > This is the output: > > AqBanking v6.5.2.0stable > Sending jobs to the bank(s) > Sorting commands by account > Sorting account queues by provider > Send commands to providers > Send commands to provider "aqofxconnect" > Locking customer "1299" > Sending request... > Connecting to server... > Resolving hostname "df3cx-services.1fsapi.com" ... > IP address is "45.60.151.211" > Connecting to "df3cx-services.1fsapi.com" > Connected to "df3cx-services.1fsapi.com" > Using GnuTLS default ciphers. > TLS: SSL-Ciphers negotiated: TLS1.3:ECDHE-RSA-AES-128-GCM:AEAD > Connected. > Sending message... > Message sent. > Waiting for response... > Receiving response... > HTTP-Status: 200 () > Response received. > Disconnecting from server... > Disconnected. > Parsing response... > Status for signon request: Success (Code 0, severity "INFO") > The server successfully processed the request. > Status for transaction statement request: General error (Code 2000, > severity "ERROR") > Error other than those specified by the remaining error codes. (Note: > Servers should provide a more specific error whenever possible. Error > code 2000 should be reserved for cases in which a more specific code is > not available.) > Unlocking customer "1299" > -- > > any ideas? First, try again tomorrow on the off chance USAA had a server outage over the weekend. If it still fails, turn on OFX logging (see https://wiki.gnucash.org/wiki/AqBanking#Debugging) and capture the actual OFX response. Edit it to remove your actual account number and credentials then post it here. Regards, John Ralls ___ 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.
Re: [GNC] Recording stock holdings
> On Aug 21, 2022, at 11:30 PM, aeg via gnucash-user > wrote: > > I have been using GnuCash for about 6 years, starting with version 2.6 and > now use 3.5 on a Windows 10 laptop. I like it very much, but have a > persistent problem with entering stock investments. > The day-to day financial transactions cause me no problems at all, but I've > never been able to fully understand how stocks and shares are recorded and > managed, and I'm frustrated that, despite following the tutorials very > carefully, it never works for me as it does in the tutorial, so I hope > someone can explain what's going on. > I have a relatively small portfolio of shares that I've tried to enter, and > the following example should illustrate the problems I've faced: > > Having set up the various accounts according to sections 9.4.1 and 9.4.2 of > the tutorial, I then followed the instructions in section 9.5.1 to record 33 > National Grid shares (NG.L) that were valued at 7.833030 GBP on 5/4/2019 as > follows (note that I have used || to separate the columns): > Transaction date: 5/4/2019Split 1: Brokerage Account:Stock:NG.L || 33.00 || > 7.833030 || 258.49 ||Split 2: Equity:Opening Balances |||| > || || 258.49 > However, when I press Enter, GnuCash seeks to make corrections and adds three > more splits, leaving me with: > Split 1: Brokerage Account:Stock:NG.L || 33.00 || 0.903030303 || 258.49 || >Split 2: Trading:CURRENCY:GBP |||| || 258.49 > ||Split 3: Imbalance - GBP |||| || > 15,588,385,182,335.90 ||Split 4: Equity:Opening Balances |||| > || || 258.49Split 5: Trading:LSE:NG.L || > || || || 15,588,385,182,594.39 > Subtracting the large number in column 5 of split 5 from the large number in > column 4 of split 3 equals 258.49, so why is it making any of these changes? It's creating the splits because you have trading accounts enabled on the book, see https://wiki.gnucash.org/wiki/Trading_Accounts. I'd need to see the rest of your book to figure out why the value of that split is so large. The price change is strange too. Does it do that if you set up a new book and create just that transaction? What about upgrading to GnuCash 4.11? Regards, John Ralls ___ 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.
Re: [GNC] Recording stock holdings
Good that you've resolved the problem. Trading accounts are enabled and disabled on the first tab of File>Properties. You should make sure that it's disabled so that GnuCash doesn't create more trading accounts for you going forward. Regards, John Ralls > On Aug 23, 2022, at 2:37 AM, aeg wrote: > > PROBLEM RESOLVED (I think) > > - Forwarded message - > From: aeg > To: john > Cc: gnucash-user@gnucash.org > Sent: Tuesday, 23 August 2022 at 08:45:51 BST > Subject: Re: [GNC] Recording stock holdings > > >> On Aug 21, 2022, at 11:30 PM, aeg via gnucash-user >> wrote: >> >> I have been using GnuCash for about 6 years, starting with version 2.6 and >> now use 3.5 on a Windows 10 laptop. I like it very much, but have a >> persistent problem with entering stock investments. >> The day-to day financial transactions cause me no problems at all, but I've >> never been able to fully understand how stocks and shares are recorded and >> managed, and I'm frustrated that, despite following the tutorials very >> carefully, it never works for me as it does in the tutorial, so I hope >> someone can explain what's going on. >> I have a relatively small portfolio of shares that I've tried to enter, and >> the following example should illustrate the problems I've faced: >> >> Having set up the various accounts according to sections 9.4.1 and 9.4.2 of >> the tutorial, I then followed the instructions in section 9.5.1 to record 33 >> National Grid shares (NG.L) that were valued at 7.833030 GBP on 5/4/2019 as >> follows (note that I have used || to separate the columns): >> Transaction date: 5/4/2019Split 1: Brokerage Account:Stock:NG.L || 33.00 >> || 7.833030 || 258.49 ||Split 2: Equity:Opening Balances |||| >> || || 258.49 >> However, when I press Enter, GnuCash seeks to make corrections and adds >> three more splits, leaving me with: >> Split 1: Brokerage Account:Stock:NG.L || 33.00 || 0.903030303 || 258.49 >> ||Split 2: Trading:CURRENCY:GBP |||| || >> 258.49 ||Split 3: Imbalance - GBP |||| || >> 15,588,385,182,335.90 ||Split 4: Equity:Opening Balances |||| >>|| || 258.49Split 5: Trading:LSE:NG.L || >>|| || || 15,588,385,182,594.39 >> Subtracting the large number in column 5 of split 5 from the large number in >> column 4 of split 3 equals 258.49, so why is it making any of these changes? >> > > On Monday, 22 August 2022 at 16:52:08 BST, john wrote: > > It's creating the splits because you have trading accounts enabled on the > book, see https://wiki.gnucash.org/wiki/Trading_Accounts. I'd need to see the > rest of your book to figure out why the value of that split is so large. The > price change is strange too. > > Does it do that if you set up a new book and create just that transaction? > > What about upgrading to GnuCash 4.11? > > Regards, > John Ralls > > > > Thanks John. > > As far as I'm aware, all of my transactions are in GBP and I've never set up > any trading accounts manually, but they first appeared automatically when I > recorded my holding of Santander shares and added DRIP dividends. Although > that is a Spanish company, the shares and dividends are recorded in my book > in GBP. > > I set up a new book as you suggested, and was able to enter the transaction > without any problems, so when I returned to my current book, I decided to > delete the troublesome account and start again. This time, when I pressed > Enter, GnuCash inserted the trading account splits, but with a different set > of trading account numbers: 67,487,302.84 and 67,487,044.35. (Note that the > difference between those numbers is still 258.49) > > (Note also that I previously recorded other stocks in my original book > without problems. and without trading account splits) > > Regarding your suggested upgrade to GnuCash 4.11, I would normally have done > that by now but my last upgrade (to 3.5) resulted in the need for a > substantial amount of format tweaking to create the screen layout that works > for me, so I'm reluctant to rock the boat again unless I have to; (If it > ain't broke, etc...) > > Regards, > Alan G > > > > Dear John, > > After sending my previous message, I decided to delete the stock account for > the troublesome holding, as well as its associated trading account, then to > create a fresh stock account and re-enter transactions
Re: [GNC] Price editor
Yes, we changed the name in 2.6.11 to make clear the difference between the price database window and the price editor dialog. The latter is opened with the Add and Edit buttons on the former. Regards, John Ralls > On Aug 27, 2022, at 6:53 AM, David Carlson > wrote: > > Has the name changed? Yes, it seems to be called Price Database now, but > it is still the tool to edit, add and delete security prices. Doesn't that > work for you? > > On Sat, Aug 27, 2022 at 6:45 AM Roger Lewry wrote: > >> Previously I have been able to update share and fund prices manually using >> Price Editor which appeared in the Tools menu. It is no longer there, but >> Price Database and Security Editor are there. I tried updating to version >> 4.11 in the hope that this would solve the problem but it has not. >> >> >> >> I am using Microsoft Windows 10 Home 21H2. Please can anyone suggest a >> solution for me? >> >> >> >> Roger >> >> ___ >> 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. >> > > > -- > David Carlson > ___ > 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. ___ 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.
Re: [GNC] GC 3.11 crashes during "Check & Repair"
There's not much point in filing a bug report for a crash in 3.11. Install 4.11 and run check-and-repair on it there. If that crashes then try to get a stack trace (see https://wiki.gnucash.org/wiki/Stack_Trace and note that it's *much* easier under Linux than Windows) and file a bug on that. If it doesn't crash then you're probably good-to-go with 4.11. Regards, John Ralls > On Aug 28, 2022, at 4:25 AM, Adrien Monteleone > wrote: > > The Check & Repair is to be done after each major version upgrade. > > Since you're getting a crash, (on more than one data file?) I'd recommend > obtaining the output the devs are looking for using the links David sent. > (all documented on the Wiki) > > I don't know if they need just the Windows info, or if obtaining the same on > Ubuntu will help too. > > Then submit a bug report on Bugzilla: bugs.gnucash.org. > > You'll need to register an account there first of course. > > Describe the crash and attach the requested files. > > Regards, > Adrien > > On 8/28/22 4:15 AM, rsbrux via gnucash-user wrote: >> I ran GC 3.11 under Windows again, this time with the --debug argument, and >> then ran "Check & Repair All" in the hope of getting some useful >> information in the logfile. >> Again, GC crashed after about half an hour, but the logfile contains neither >> errors nor warnings. The Windows event log show the following: >>>> >> Faulting application name: gnucash.exe, version: 3.11.0.0, time stamp: >> 0x5ef7bbc2 >> Faulting module name: libglib-2.0-0.dll, version: 2.64.3.0, time stamp: >> 0x >> Exception code: 0x4015 >> Fault offset: 0x00057e1d >> Faulting process id: 0x275c >> Faulting application start time: 0x01d8bab03bae87f8 >> Faulting application path: C:\Program Files (x86)\gnucash\bin\gnucash.exe >> Faulting module path: C:\Program Files (x86)\gnucash\bin\libglib-2.0-0.dll >> Report Id: 91583241-2b39-4a20-b312-faa33c724463 >> Faulting package full name: >> Faulting package-relative application ID: >> << >> Each of the files on which I have run "Check & Repair All" in GC 3.x had >> already been run through "Check & Repair All" in GC 2.6.19 under Ubuntu >> Studio 18.04. > > > ___ > 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. ___ 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.
Re: [GNC] GC 3.11 crashes during "Check & Repair"
Open the file in a plain-text editor (or less on Linux) and find the 104th instance of "". Splits are part of elements. Prices are elements under and are all processed before any transactions, so whatever is causing the crash it isn't a price entry. Regards, John Ralls > On Aug 28, 2022, at 6:10 AM, rsbrux via gnucash-user > wrote: > > Thanks for all the references, particularly for reminding me to check the > trace file. Unfortunately, the only error messages logged in the trace file > were at the beginning of the process: > * 09:31:56 ERROR gnc_process_get_fd: assertion 'proc' failed > * 09:31:56 ERROR gnc_detach_process: assertion 'proc && > proc->pid' failed > I am reluctant to venture into gdb, much less compiling GC myself, but > perhaps these lines at the end of the trace file give a hint to which part of > the XML file is giving "Check & Repair" indigestion: > * 10:07:41 INFO [xaccAccountScrubImbalance] Finished > processing split 113 of 304 > * 10:07:41 INFO [xaccAccountScrubImbalance] Start > processing split 114 of 304 > Is there any way for me to identify what part of the XML file "split 114 of > 304" corresponds to? > Given that GC was started several times by mistake when price update were > running on the same file, I suspect that the bad records are in the price > history part of the DB. > I can readily do without the price history if there is some way of migrating > all of the transactions to the new file version. > ___ 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.
Re: [GNC] Problems upgrading to 4.8a
This is https://bugs.gnucash.org/show_bug.cgi?id=798612
I discovered while researching this that yelp v.42 just dropped support for the
ghelp: scheme. help:gnucash-help and help:gnucash-guide are able to find the
GnuCash docs so another option for the packager (and BTW I think the one in
question is the Debian packager, Dmitry Smirnov whom I've cc'd ) would be to
apply this:
diff --git a/gnucash/gnome-utils/gnc-gnome-utils.c
b/gnucash/gnome-utils/gnc-gnome-utils.c
index 2c3cfac02..6cfbf3473 100644
--- a/gnucash/gnome-utils/gnc-gnome-utils.c
+++ b/gnucash/gnome-utils/gnc-gnome-utils.c
@@ -277,7 +277,7 @@ gnc_gnome_help_yelp_anchor_fix (GtkWindow *parent, const
char *file_name, const
g_free (help_file);
if (full_path)
-uri = g_strconcat ("ghelp:", full_path, "?", anchor, NULL);
+uri = g_strconcat ("help:", full_path, "?", anchor, NULL);
else
{
gnc_error_dialog (parent, "%s\n%s", _(msg_no_help_found),
_(msg_no_help_reason));
@@ -475,7 +475,7 @@ gnc_gnome_help (GtkWindow *parent, const char *file_name,
const char *anchor)
if (anchor)
uri = gnc_gnome_help_yelp_anchor_fix (parent, file_name, anchor);
else
-uri = g_strconcat ("ghelp:", file_name, NULL);
+uri = g_strconcat ("help:", file_name, NULL);
DEBUG ("Attempting to opening help uri %s", uri);
We could elaborate that by making it conditional on the yelp version and put it
in GnuCash 4.12 that we'll release at the end of the month.
BTW the Gnome 43 runtime also releases in two weeks. IIRC Flathub will force us
to update our current 41 to 42 or 43 for the 4.12 release, meaning that we need
that change for the flatpak build too.
Regards,
John Ralls
> On Sep 5, 2022, at 9:03 AM, Geert Janssens wrote:
>
> Hi Phil,
>
> My response was not for flatpak. It's how the gnucash-docs build scripts
> (written by the
> gnucash developers) currently install things. And on Fedora 36 for example
> that is still the
> case.
>
> The documentation links you are listing are the html versions of our
> documentation and is
> not what is presented when invoking "Tutorial" or "Contents" from the GnuCash
> menus.
> GnuCash will look for the docbook version of the documentation, which at this
> point is still
> installed in /usr/share/gnome/help/C/gnucash-guide and
> /usr/shar/gnome/help/C/gnucash-
> help. (Well, pedantically it will ask yelp to look there by means of the
> "ghelp:xyz" construct,
> but yelp dropped support for that construct in version 42).
>
> I don't know what the Ubuntu packager for our documentation has decided on.
> But if
> Ubuntu only ships the html version of the gnucash documentation, I consider
> that a bug in
> that distribution. There are a few possible ways the Ubuntu packager could
> solve this:
> * either also patch the gnucash package to look for the html version of the
> documentation
> * revert the change in yelp that drops support for the "ghelp" search
> qualifier. Considering
> gnucash is probably the last application in the Gnome ecosystem to still
> depend on this, it's
> unlikely Ubuntu would go that route.
> * backport the patchset from the master branch in the gnucash and
> gnucash-docs
> repositories that rearrange our documentation output to work with yelp's
> "help" search
> qualifier. That way gnucash will be able to present the documentation again
> as you were
> used to in Ubuntu 20.04.
>
> I think the last option would be the most future proof one.
>
> Regards,
>
> Geert
>
>
> Op maandag 5 september 2022 17:01:22 CEST schreef Phil Wolff via gnucash-user:
>> Geert ~
>>
>> Thanks for responding!
>> That may be true for a Flatpak installation, but mine is what GNC calls
>> "pristine," and I've found the documents at
>> - file:///usr/share/doc/gnucash-docs/gnucash-guide-en/index.html
>> - file:///usr/share/doc/gnucash-docs/gnucash-help-en/help.html
>>
>> ~ Phil
>>
>> On 9/5/22 00:46, Geert Janssens wrote:
>>> Hi Phil,
>>>
>>> Regarding the documentation, it seems like Ubuntu 22.04.1 ships a newer
>>> help viewer that's not compatible with where GnuCash stores its guide and
>>> manual on disk. This has been fixed for the future GnuCash 5.0 but not
>>> for the current 4.x series.
>>>
>>> As temporary workarounds you could either
>>> - browse the documentation online (via the gnucash website) or
>>> - load the documentation from the command line using one of these commands
>>>
>>> yelp
Re: [GNC] Mutual Fund Dividend After Sale
> On Sep 5, 2022, at 4:05 PM, Jack Frillman via gnucash-user
> wrote:
>
>
>
> On 9/5/22 3:09 PM, John Ralls wrote:
>>> On Sep 5, 2022, at 10:32 AM, Adrien Monteleone
>>> wrote:
>>>
>>> On 9/5/22 12:13 PM, Jack Frillman via gnucash-user wrote:
>>>> No I didn't delete the account?
>>>> Why would I do silly thing like that and lose all that history?
>>>> The account is hidden because it's balance is 0.
>>>> Reappearing means exactly what it says.
>>>> I was no longer in the account tree, i.e. list, because after the sale
>>>> it's balance became 0. No matter how I record that late dividend the
>>>> balance becomes non 0 and the account reappears in the account tree or
>>>> list.
>>> I didn't think you deleted it, but wasn't sure what was going on.
>>>
>>> I can set an account with a non-zero balance to 'hidden' and it stays that
>>> way, even with subsequent activity. I can set it to hidden with a zero
>>> balance, add another transaction to make it non-zero, and it stays hidden.
>>> I'm not sure why your account is showing up.
>>>
>>> Did you by chance set a View filter on your Accounts tab that would affect
>>> this?
>>>> I don't under stand the last part.
>>>>
>>>>> A Dividend receipt would normally be between some asset account ('bank'
>>>>> or a brokerage cash account if direct deposit, 'undeposited funds' if by
>>>>> paper check) according to how you received the money, and an
>>>>> Income/Revenue account, say 'Dividends Received'. The FundXYZ account
>>>>> shouldn't be touched at all.
>>> As it states, 'normally' a dividend transaction doesn't involve the
>>> fund/stock at all. It is a separate transaction between asset & income
>>> accounts. Though David just informed me that there may be times you might
>>> record it there, which I had not thought of.
>> In both cases you record an empty split to the stock account. That doesn't
>> change the account's balance and therefore won't unhide it from the Accounts
>> page.
>>
> And how do I do that?
See
https://www.gnucash.org/docs/v4/C/gnucash-guide/invest-dividends1.html#invest-dividendcash.
Did you have dividend reinvestments turned on? Were you posting dividends the
way that the next section, Dividends Reinvested, recommends? Was that last
post-sale dividend reinvested so that you had to do a second sale?
Regards,
John Ralls
___
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.
Re: [GNC] Problems upgrading to 4.8a
> On Sep 5, 2022, at 2:01 PM, Frank H. Ellenberger > wrote: > > Hi, > > Am 05.09.22 um 22:27 schrieb Geert Janssens: >> Op maandag 5 september 2022 19:09:06 CEST schreef john: >>> This is https://bugs.gnucash.org/show_bug.cgi?id=798612 >>> >>> I discovered while researching this that yelp v.42 just dropped support for >>> the ghelp: scheme. help:gnucash-help and help:gnucash-guide are able to >>> find the GnuCash docs >> I'm surprised the help: scheme finds the documentation in the old ghelp >> locations, >> but that's good news really. >> I think we best add this in for gnucash 4.12 then, and conditional on the >> yelp >> version. > > Why conditional, IIRC help: is defined in yelp for about a decade. Because yelp v3.x (and maybe v40 and v41, I didn't have those handy to test) can't find the GnuCash docs in /usr/share/docs/gnucash-docs with help: so we have to use ghelp: on distros that are still shipping older versions of yelp. Regards, John Ralls ___ 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.
Re: [GNC] Mutual Fund Dividend After Sale
> On Sep 6, 2022, at 5:56 AM, Jack Frillman wrote:
>
>
>
> On 9/5/22 11:53 PM, john wrote:
>>
>>
>>> On Sep 5, 2022, at 4:05 PM, Jack Frillman via gnucash-user
>>> <mailto:gnucash-user@gnucash.org> wrote:
>>>
>>>
>>>
>>> On 9/5/22 3:09 PM, John Ralls wrote:
>>>>> On Sep 5, 2022, at 10:32 AM, Adrien Monteleone
>>>>> <mailto:adrien.montele...@lusfiber.net>
>>>>> wrote:
>>>>>
>>>>> On 9/5/22 12:13 PM, Jack Frillman via gnucash-user wrote:
>>>>>> No I didn't delete the account?
>>>>>> Why would I do silly thing like that and lose all that history?
>>>>>> The account is hidden because it's balance is 0.
>>>>>> Reappearing means exactly what it says.
>>>>>> I was no longer in the account tree, i.e. list, because after the sale
>>>>>> it's balance became 0. No matter how I record that late dividend the
>>>>>> balance becomes non 0 and the account reappears in the account tree or
>>>>>> list.
>>>>> I didn't think you deleted it, but wasn't sure what was going on.
>>>>>
>>>>> I can set an account with a non-zero balance to 'hidden' and it stays
>>>>> that way, even with subsequent activity. I can set it to hidden with a
>>>>> zero balance, add another transaction to make it non-zero, and it stays
>>>>> hidden. I'm not sure why your account is showing up.
>>>>>
>>>>> Did you by chance set a View filter on your Accounts tab that would
>>>>> affect this?
>>>>>> I don't under stand the last part.
>>>>>>
>>>>>>> A Dividend receipt would normally be between some asset account ('bank'
>>>>>>> or a brokerage cash account if direct deposit, 'undeposited funds' if
>>>>>>> by paper check) according to how you received the money, and an
>>>>>>> Income/Revenue account, say 'Dividends Received'. The FundXYZ account
>>>>>>> shouldn't be touched at all.
>>>>> As it states, 'normally' a dividend transaction doesn't involve the
>>>>> fund/stock at all. It is a separate transaction between asset & income
>>>>> accounts. Though David just informed me that there may be times you might
>>>>> record it there, which I had not thought of.
>>>> In both cases you record an empty split to the stock account. That doesn't
>>>> change the account's balance and therefore won't unhide it from the
>>>> Accounts page.
>>>>
>>> And how do I do that?
>>
>> See
>> https://www.gnucash.org/docs/v4/C/gnucash-guide/invest-dividends1.html#invest-dividendcash.
>>
>> Did you have dividend reinvestments turned on? Were you posting dividends
>> the way that the next section, Dividends Reinvested, recommends? Was that
>> last post-sale dividend reinvested so that you had to do a second sale?
> Not sure what you mean by "turned on" but the previous dividends were
> reinvested and were entered manually.
Dividend reinvestment is optional with most open-ended mutual funds, so "turned
on" means that you have accepted the option.
You didn't answer the last, most important, question: Was the last dividend,
the one that's the subject of your original question, reinvested so that you
had shares in the fund again and had to sell them to re-close the position?
Regards,
John Ralls
___
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.
Re: [GNC] Problems upgrading to 4.8a
> On Sep 6, 2022, at 8:54 AM, Phil Wolff via gnucash-user > wrote: > > A critical problem remains: scheduled transactions are not being > entered as they come due. The Scheduled Transaction Editor page > contains all of the expected entries, and none of the "Next Occur" > dates are older than the day that the version update took place. And > it's not just a problem with entries that were there prior to the > update; yesterday I created a new entry scheduled for today, and the > transaction did not get created. > > What else can I look at to diagnose this problem? First, run Actions>Scheduled Transactions>Since Last Run. If that runs your scheduled transactions then they're fine and you probably need only enable running Since Last Run when the data file is opened at the top of the Scheduled Transactions page in Preferences. If the SLR doesn't work then look in the trace file (see https://wiki.gnucash.org/wiki/Trace_File) for errors. Regards, John Ralls ___ 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.
Re: [GNC] help: vs. ghelp: was: Problems upgrading to 4.8a
I'm pretty sure that the whole Debian ecosystem uses the Debian packages
created by Dmitry Smirnov, which is why he's CC'd on this thread.
The file list for his testing Gnucash-docs package:
https://packages.debian.org/bookworm/all/gnucash-docs/filelist and for stable
it's
https://packages.debian.org/bullseye/all/gnucash-docs/filelistNote that stable
has the docbook docs and testing doesn't. Might we have caused this with our
cmake changes?
Regards,
John Ralls
.
> On Sep 7, 2022, at 12:48 AM, Geert Janssens
> wrote:
>
> Op dinsdag 6 september 2022 19:00:47 CEST schreef Frank H. Ellenberger:
> > Am 06.09.22 um 06:01 schrieb john:
> > >> On Sep 5, 2022, at 2:01 PM, Frank H. Ellenberger
> > >> wrote:
> > >>
> > >> Hi,
> > >>
> > >> Am 05.09.22 um 22:27 schrieb Geert Janssens:
> > >>> Op maandag 5 september 2022 19:09:06 CEST schreef john:
> > >>>> This is https://bugs.gnucash.org/show_bug.cgi?id=798612
> > >>>>
> > >>>> I discovered while researching this that yelp v.42 just dropped support
> > >>>> for
> > >>>> the ghelp: scheme. help:gnucash-help and help:gnucash-guide are able to
> > >>>> find the GnuCash docs
> > >>>
> > >>> I'm surprised the help: scheme finds the documentation in the old ghelp
> > >>> locations, but that's good news really.
> > >>> I think we best add this in for gnucash 4.12 then, and conditional on
> > >>> the yelp version.
> > >>
> > >> Why conditional, IIRC help: is defined in yelp for about a decade.
> > >
> > > Because yelp v3.x (and maybe v40 and v41, I didn't have those handy to
> > > test) can't find the GnuCash docs in /usr/share/docs/gnucash-docs with
> > > help: so we have to use ghelp: on distros that are still shipping older
> > > versions of yelp.
> > >
> > > Regards,
> > > John Ralls
> >
> > From https://gitlab.gnome.org/GNOME/yelp/-/blob/master/NEWS
> >
> > > Changes in 2.31.5:
> > > --
> > > * New "Read Later" feature
> > > * Support for proposed XDG help: URI scheme
> >
> > They should find /usr/share/help/{lang}/…
> >
> > Why do you want to unstall into /usr/share/docs/?
> > Also ghelp: did not recognitze that.
> > It used /usr/share/gnome/help/…
> >
> > Regards
> > Frank
>
> I've explained the difference in my other reply. I think this is a bug in
> ubuntu packaging; they seem to ship our html format and no longer our docbook
> format.
>
> Regards,
>
> Geert
___
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.
Re: [GNC] Crash when importing OFX file from Bank of America
> On Oct 1, 2022, at 8:26 AM, William Starrs wrote: > > Hello all, > > I have been downloading and importing OFX (QFX) files from BofA nightly for > many years. Starting a few days ago, it crashes when attempting. This is > for a checking account. > > I do the same for Chase and Amex Credit Cards without issue. Here is what > I see in the terminal: > > - > > > 1 ./gnucash_error.txt+ > Bufs > (Above message occurred on Line 2, Column 1) > LibOFX INFO: Created OfxDummyContainer to hold unsupported aggregate SONRS > (Above message occurred on Line 3, Column 1) > LibOFX INFO: Created OfxDummyContainer to hold unsupported aggregate FI > (Above message occurred on Line 11, Column 1) > LibOFX INFO: Created OfxDummyContainer to hold unsupported aggregate > BANKMSGSRSV1 > (Above message occurred on Line 17, Column 1) > LibOFX INFO: Created OfxDummyContainer to hold unsupported aggregate > STMTTRNRS > (Above message occurred on Line 18, Column 1) > free(): double free detected in tcache 2 > > [1] + 1959188 IOT instruction (core dumped) gnucash > > --- > > Here is the header of the OFX file that I download: > > OFXHEADER:100 > DATA:OFXSGML > VERSION:102 > SECURITY:NONE > ENCODING:USASCII > CHARSET:1252 > COMPRESSION:NONE > OLDFILEUID:NONE > NEWFILEUID:NONE > > > I tried running ofxdump (command line tool from libofx) against the > downloaded file and it gave those same INFO warnings but did not crash, and > successfully parsed out the account info, statement info, and transactions. > > The only error that appeared in the GNUcash trace that was not in the > ofxdump was the last line: > > free(): double free detected in tcache 2 > > I have no clue what that pertains to. > > > Any help would be much appreciated. The double-free detected error seems to be a feature of the Linux C runtime. It's a good clue, double-frees are a definite crasher. Please open a bug report[1] and attach a stack trace[2]. Regards, John Ralls [1] https://wiki.gnucash.org/wiki/Bugzilla#Commenting_on_existing_bugs_or_entering_new_ones [2] https://wiki.gnucash.org/wiki/Stack_Trace ___ 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.
Re: [GNC] Orphan- and Imbalance- splits created on stock transaction when closing & reopening GnuCash data file
That looks like a proper cap gains transaction. It's odd that the share balance differs by 250 between the two screenshots: Is there some other transaction that might be affecting things? The next thought is that there might be a non-AUD transaction currency involved. If you open the transaction in the CapitalLosses:CurrentYear:Realized account register, right-click on the split for that account, and select "Edit Exchange Rate" does it open the transfer dialog or pop an error box? If the former, what is the non-AUD currency/commodity it wants to price; if the latter, what's the error? Regards, John Ralls > On Oct 5, 2022, at 7:33 PM, Chris Grinton wrote: > > Good thought - but the problem still occurs even if the share count and > price are non-0. (The example transaction I've described is a simple > reduction in the cost base of the asset without changing the number of > shares held. But I think that is not directly relevant to the problem and > probably the example I described more complex than it needed to be.) > > Chris > > > On Thu, 6 Oct 2022 at 09:45, R Losey wrote: > >> Perhaps I'm missing something, but if there is a transaction that has a >> cost of 5000, and you have shares with a price of 0, that may be causing it >> to think there is an imbalance, and thus the transactions get added? >> >> On Wed, Oct 5, 2022 at 7:09 AM Chris Grinton wrote: >> >>> Hi GnuCashers, >>> >>> I have a strange situation where a transaction is automagically (and >>> unexpectedly) getting splits added to it against the "Orphan-" >>> and "Imbalance-" accounts when my GnuCash data file is closed >>> and >>> reopened. I can't work out why these splits are getting added, and would >>> love any insights that people might have on how to stop it from happening. >>> >>> The unexpected behavior here appears to be somehow related to having >>> trading accounts enabled, and a consequence of changing the namespace of a >>> security. >>> >>> Here are steps I do to reproduce this problem: >>> >>> 1. Create a transaction as follows: >>>Expenses:Realised capital losses DR 5000 >>>Assets:Stock account CR >>> 5000 (with shares & price = 0) >>> >>> This appears in GnuCash as per the following screenshot: >>> >>> [image: image.png] >>> >>> No change occurs to this transaction as long as I keep the GnuCash file >>> open. >>> >>> 2. Edit the UNLISTED:ACME security, and change its namespace. For example, >>> change the namespace from "UNLISTED" to "UNLISTED2". >>> >>> 3. Open a different GnuCash file (or close GnuCash), and then open the >>> original file again. The act of opening the file appears to cause the >>> transaction to be updated with additional splits to read as follows: >>> >>>Expenses:Realised capital losses DR 5000 >>> *Orphan-AUD DR 5000* >>>Assets:Stock account CR >>> 5000 (with shares & price = 0) >>> *Imbalance-AUD CR >>> 5000* >>> >>> Here's a screenshot showing this: >>> [image: image.png] >>> >>> 4. If I delete the Orphan & Imbalance splits, they continue to reappear >>> every time I reopen the GnuCash file. >>> >>> I have not seen this behavior occurring for securities that have not had a >>> namespace change, but is reliably reproducible for securities that have >>> had >>> a namespace change. >>> >>> I'm using GnuCash 4.8 on Windows with a SQLite data file. >>> >>> Thoughts? >>> >>> Thanks, >>> Chris >>> ___ >>> 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. >>> >> >> >> -- >> _ >> Richard Losey >> rlo...@gmail.com >> Micah 6:8 >> > ___ > 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. ___ 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.
Re: [GNC] Orphan- and Imbalance- splits created on stock transaction when closing & reopening GnuCash data file
I can reproduce this with your sample file, and I discovered another facet: If one does a File>Save As, either to XML or SQlite3, the new file doesn't exhibit the behavior. I also found that if I remove the extra splits in the original file they don't come back. It's not a last-transaction issue, either: If one creates two transactions in a session they'll both get the Orphan and Imbalance splits created. I''l try watching the program load in the debugger next. Regards, John Ralls > On Oct 5, 2022, at 9:33 PM, Chris Grinton wrote: > > Good spotting on the share balance difference! I hadn't intended that in the > screenshots; it was just a side effect of me playing around trying to get it > to work between the first and 2nd screenshot - I had added some other > transactions for testing that did adjust the share balance. > > Selecting "Edit Exchange Rate" on the CapitalLosses:CurrentYear:Realized > split in the CapitalLosses:CurrentYear:Realized account register shows an > error: "The two currencies involved equal each other". > > I can reproduce the problem by creating a brand new (empty) GnuCash file and > then following the steps I described, and using only a single currency in > that file. So I don't think a multi-currency factor is at play here. > > If it helps and I've inspired anybody to dig deeper, I've shared a .gnucash > file at https://app.box.com/s/xdrru5yr8gjm3r7ovatmsn92jcvme053 that can be > used to reproduce: simply create a new buy or sell transaction involving the > ACME security in the Assets:ACME Corp account, and new Orphan & Imbalance > splits will be created in your transaction the next time the file is opened. > > Chris > > On Thu, 6 Oct 2022 at 11:59, john <mailto:jra...@ceridwen.us>> wrote: >> That looks like a proper cap gains transaction. It's odd that the share >> balance differs by 250 between the two screenshots: Is there some other >> transaction that might be affecting things? >> >> The next thought is that there might be a non-AUD transaction currency >> involved. If you open the transaction in the >> CapitalLosses:CurrentYear:Realized account register, right-click on the >> split for that account, and select "Edit Exchange Rate" does it open the >> transfer dialog or pop an error box? If the former, what is the non-AUD >> currency/commodity it wants to price; if the latter, >> what's the error? >> >> Regards, >> John Ralls >> >> > On Oct 5, 2022, at 7:33 PM, Chris Grinton > > <mailto:cgrin...@gmail.com>> wrote: >> > >> > Good thought - but the problem still occurs even if the share count and >> > price are non-0. (The example transaction I've described is a simple >> > reduction in the cost base of the asset without changing the number of >> > shares held. But I think that is not directly relevant to the problem and >> > probably the example I described more complex than it needed to be.) >> > >> > Chris >> > >> > >> > On Thu, 6 Oct 2022 at 09:45, R Losey > > <mailto:rlo...@gmail.com>> wrote: >> > >> >> Perhaps I'm missing something, but if there is a transaction that has a >> >> cost of 5000, and you have shares with a price of 0, that may be causing >> >> it >> >> to think there is an imbalance, and thus the transactions get added? >> >> >> >> On Wed, Oct 5, 2022 at 7:09 AM Chris Grinton > >> <mailto:cgrin...@gmail.com>> wrote: >> >> >> >>> Hi GnuCashers, >> >>> >> >>> I have a strange situation where a transaction is automagically (and >> >>> unexpectedly) getting splits added to it against the "Orphan-" >> >>> and "Imbalance-" accounts when my GnuCash data file is closed >> >>> and >> >>> reopened. I can't work out why these splits are getting added, and would >> >>> love any insights that people might have on how to stop it from >> >>> happening. >> >>> >> >>> The unexpected behavior here appears to be somehow related to having >> >>> trading accounts enabled, and a consequence of changing the namespace of >> >>> a >> >>> security. >> >>> >> >>> Here are steps I do to reproduce this problem: >> >>> >> >>> 1. Create a transaction as follows: >> >>>Expenses:Realised ca
Re: [GNC] Gnucash invoicing and payment - questions on process
> On Oct 7, 2022, at 3:18 AM, Geert Janssens wrote: > > Only trading accounts are picky about their names (or did we fix that > already?) We've partly fixed Trading accounts and Opening Balance accounts, but there are still a few more "special" names. Orphan, Imbalance, and Orphan Gains come immediately to mind; there may be others. Regards, John Ralls ___ 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.
Re: [GNC] Problem with missing balance in a parent account
> On Oct 7, 2022, at 12:43 PM, Jay Ridgley wrote: > > Good Morning, > > BRAND NEW to the list, have been using GnuCash on my Ubuntu system for over > 20 years, this is the first problem I have encountered that I have not been > able to resolve. > > I discovered that the balance amount that should appear in a the parent > account for my bank is missing. Therefore I am unable to do this month's > reconcile. > > The account was proper last month, and I was able to balance my checkbook > successfully. In the meantime I upgraded to Ubuntu 22.04 LTS from 20.04 LTS > every thing seems to running properly, otherwise, including GnuCash. > > Today when I tried to reconcile my bank account I discovered the amount of > the balance is missing and the reconcile button is grayed out(naturally since > nothing shows). > > All the sub accounts point to the parent account and when I list my accounts > the balance appears there and is correct. > > What happened and how can I get it back? Can you attach (don't inline!) a screenshot of the problem? It's not clear from your description what balance is missing and what button is disabled. Regards, John Ralls ___ 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.
Re: [GNC] Problem with missing balance in a parent account **FINAL POST**
Please remember to copy the list on all replies. If you want the Reconcile button (and, contrary to what Robin Chatterjay wrote, Actions>Reconcile) to be active for your account, make it not a placeholder. Regards, John Ralls > On Oct 10, 2022, at 7:56 AM, Jay Ridgley wrote: > > Good morning, > > After some additional research I believe that the ONLY problem is the grayed > out reconcile button. > > I was confused about the balance showing in the Parent Account, Placeholder. > It shows in the Reconcile Popup window. > > The ACTUAL trouble is the grayed out Reconcile Button, that first appeared > for me in Ubuntu 22.04 LTS after the upgrade. > > Since I have found the workaround below, it is a matter of inconvenience. > However it would be preferable to have it as it was in earlier releases (not > grayed out). > > Regards > Jay > > On 10/9/22 15:49, Jay Ridgley wrote: >> Good afternoon, >> Up until Ubuntu 22.04 The reconcile button was NOT grayed out for the type >> of account I am using (Parent account and Placeholder). I am including an >> example of my account structure here: >> Banking Account (Parent Account, Placeholder) >> Checkbook (sub-account)(contains all checkbook transactions) >> Reserve (sub-account) (contains minimum account balance) >> Separate Purpose (sub account) (rental income & expenses) >> Checkbook Blind (sub-account) (amount held as a pad) >> All transactions take place in the sub-accounts. For me it has worked >> successfully since I began using GnuCash (over 25 years ago). >> I was advised of a workaround that allows me to continue using this >> arrangement until it can be fixed/changed to act as it did previously. >> It is as follows: >> Open Parent account >> right click and choose reconcile from the drop down >> Works just fine. >> Would not be necessary if the Reconcile button was not grayed out. >> My question boils down too: Is this change a bug or a "feature" and can it >> be put back the way it was? >> Please advise how I should proceed. >> Thanks, >> Jay >> On 10/8/22 07:50, David T. wrote: >>> That account register doesn't have any transactions in it, so it won't have >>> any value either. Is it possible that in the past, you used a report to see >>> the parent account balances, or even the Chart of Accounts? >>> >>> And if the account in the screen shot is a placeholder account, then you a) >>> wouldn't be able to open the account by double clicking, b) be told on >>> selecting Open that it was read only, and c) once opened, the entire >>> register would be greyed out. The screen shot seems to show a normal >>> account. It also shows a similarly-named tab next to the active tab. >>> >>> David T. >>> On Oct 8, 2022, at 1:51 PM, Jay Ridgley >> <mailto:jridgl...@austin.rr.com>> wrote: >>> >>> On 10/7/22 16:38, john wrote: >>> >>> >>> >>> On Oct 7, 2022, at 12:43 PM, Jay Ridgley >>> wrote: >>> >>> Good Morning, >>> >>> BRAND NEW to the list, have been using GnuCash on my Ubuntu >>> system for over 20 years, this is the first problem I have >>> encountered that I have not been able to resolve. >>> >>> I discovered that the balance amount that should appear in a >>> the parent account for my bank is missing. Therefore I am >>> unable to do this month's reconcile. >>> >>> The account was proper last month, and I was able to balance >>> my checkbook successfully. In the meantime I upgraded to >>> Ubuntu 22.04 LTS from 20.04 LTS every thing seems to running >>> properly, otherwise, including GnuCash. >>> >>> Today when I tried to reconcile my bank account I discovered >>> the amount of the balance is missing and the reconcile >>> button is grayed out(naturally since nothing shows). >>> >>> All the sub accounts point to the parent account and when I >>> list my accounts the balance appears there and is correct. >>> >>> What happened and how can I get it back? >>> >>> >>> >>> Can you attach (don't inline!) a screenshot of the problem? It's >>> not clear from your description what ba
Re: [GNC] Problem with missing balance in a parent account **FINAL POST**
Sorry, Robin Chattopadhyay not Chatterjay. Regards, John Ralls > On Oct 10, 2022, at 9:20 AM, john wrote: > > Please remember to copy the list on all replies. > > If you want the Reconcile button (and, contrary to what Robin Chatterjay > wrote, Actions>Reconcile) to be active for your account, make it not a > placeholder. > > Regards, > John Ralls > > >> On Oct 10, 2022, at 7:56 AM, Jay Ridgley wrote: >> >> Good morning, >> >> After some additional research I believe that the ONLY problem is the grayed >> out reconcile button. >> >> I was confused about the balance showing in the Parent Account, Placeholder. >> It shows in the Reconcile Popup window. >> >> The ACTUAL trouble is the grayed out Reconcile Button, that first appeared >> for me in Ubuntu 22.04 LTS after the upgrade. >> >> Since I have found the workaround below, it is a matter of inconvenience. >> However it would be preferable to have it as it was in earlier releases (not >> grayed out). >> >> Regards >> Jay >> >> On 10/9/22 15:49, Jay Ridgley wrote: >>> Good afternoon, >>> Up until Ubuntu 22.04 The reconcile button was NOT grayed out for the type >>> of account I am using (Parent account and Placeholder). I am including an >>> example of my account structure here: >>> Banking Account (Parent Account, Placeholder) >>>Checkbook (sub-account)(contains all checkbook transactions) >>>Reserve (sub-account) (contains minimum account balance) >>>Separate Purpose (sub account) (rental income & expenses) >>>Checkbook Blind (sub-account) (amount held as a pad) >>> All transactions take place in the sub-accounts. For me it has worked >>> successfully since I began using GnuCash (over 25 years ago). >>> I was advised of a workaround that allows me to continue using this >>> arrangement until it can be fixed/changed to act as it did previously. >>> It is as follows: >>> Open Parent account >>> right click and choose reconcile from the drop down >>> Works just fine. >>> Would not be necessary if the Reconcile button was not grayed out. >>> My question boils down too: Is this change a bug or a "feature" and can it >>> be put back the way it was? >>> Please advise how I should proceed. >>> Thanks, >>> Jay >>> On 10/8/22 07:50, David T. wrote: >>>> That account register doesn't have any transactions in it, so it won't >>>> have any value either. Is it possible that in the past, you used a report >>>> to see the parent account balances, or even the Chart of Accounts? >>>> >>>> And if the account in the screen shot is a placeholder account, then you >>>> a) wouldn't be able to open the account by double clicking, b) be told on >>>> selecting Open that it was read only, and c) once opened, the entire >>>> register would be greyed out. The screen shot seems to show a normal >>>> account. It also shows a similarly-named tab next to the active tab. >>>> >>>> David T. >>>> On Oct 8, 2022, at 1:51 PM, Jay Ridgley >>> <mailto:jridgl...@austin.rr.com>> wrote: >>>> >>>>On 10/7/22 16:38, john wrote: >>>> >>>> >>>> >>>>On Oct 7, 2022, at 12:43 PM, Jay Ridgley >>>> wrote: >>>> >>>>Good Morning, >>>> >>>>BRAND NEW to the list, have been using GnuCash on my Ubuntu >>>>system for over 20 years, this is the first problem I have >>>>encountered that I have not been able to resolve. >>>> >>>>I discovered that the balance amount that should appear in a >>>>the parent account for my bank is missing. Therefore I am >>>>unable to do this month's reconcile. >>>> >>>>The account was proper last month, and I was able to balance >>>>my checkbook successfully. In the meantime I upgraded to >>>> Ubuntu 22.04 LTS from 20.04 LTS every thing seems to running >>>>properly, otherwise, including GnuCash. >>>> >>>>Today when I tried to reconcile my bank account I discovered >>>>the amount of the balance is missing and the reconcile >>>>button is grayed out(naturally
Re: [GNC] Price update not working
The alphavantage module in Finance::Quote throttles the requests to comply with AlphaVantage's limit. Most stocks and funds supported by AlphaVantage are also available from yahoo_json, but currency exchange rates are not. For non-US exchanges the symbols might be different so check on finance.yahoo.com <http://finance.yahoo.com/> when switching sources. Yahoo_json isn't throttled. Note that most of the other sources rely on screen-scraping and are therefore a bit brittle in the face of layout changes to the source's websites. Regards, John Ralls > On Oct 10, 2022, at 1:43 AM, Ismael Smajli wrote: > > Hello Alpha Vantage's standard API usage is limited to five (5) API requests > per one (1) minute (https://www.alphavantage.co/premium/) My GnuCash (4.12) > Price Database lists 22 securities and it takes FINANCE::QUOTE (1.53) > slightly above 5min for the update. Regards Ismael On 2022-10-10 12:50, R > Losey wrote: > > I'm not fetching that many -- maybe > around 18 or so (I didn't count). In > the "old" days from the GUI, it would > only take seconds (that was pre-Alpha > Vantage) > > I'm not sure how busy > their servers are... but when I run the gnc-fq-dump > program using Alpha > Vantage and getting four quotes, it returns in 1-2 > seconds. I ran the full > gnucash-cli program using "time", and it shows over > 7 minutes to complete. > > > I doubt very much that my ISP is throttling me... I'm running Linux > > (Ubuntu) and it is mostly idle. > > Now the data file may be an idea... it's > about 1.5M... it's on a NAS, so it > has to go through the home network, so > that is slower... an d > > I don't know > how much parsing the gnucash-cli program has to do. > > The > GnuCash GUI is also very, very slow using "multiple" (which uses Alpha > > Vantage first). I didn't time it, but it was minutes. > > I don't think this > is network, but it may be... nothing else seems to be > slow... and the > gnc-fq-dump is very fast. > > > > On Sat, Oct 8, 2022 at 5:11 AM Geoff > wrote: > > > Hi Richard > > > > Glad to hear you > can now fetch prices. > > > > > It is supposed to take so long? There is a > long (7 minute) delay before > > > the update finishes... I've been using the > gnucash-cli command line. > > > > That does seem a long time, but how long is > a piece of string? (as my > > father used to say ;--) > > > > How many prices > are you fetching? > > How busy are Alpha Vantage's servers? > > Are Alpha > Vantage throttling you? > > Is your ISP throttling you? > > How fast, and how > busy, is your machine? > > How long does it take to fetch a single price > manually from the co > > mmand > > line? > > How long does it take to open and save your GnuCash data > file? > > Have you tried using the GnuCash GUI instead of the gnucash-cli > command > > line? > > > > > > As a benchmark, my 13 year old Windows 10 > desktop consistently retrieves > > prices for 30 odd securities in about 3 > seconds using the GnuCash GUI, > > but in my case Finance Quote pulls them > directly from the local stock > > exchange and doesn't use Alpha Vantage. > > > > > I did a few command line tests for a single security using Alpha Vantage > > > and it averages around 2.2 seconds from the other side of the world - > > > see attached screenshot. > > [Technically it is slightly quicker than this > which includes invoking > > the Python interpreter to measure the elapsed > time.] > > > > Perhaps others on this list who do use Alpha Vantage can > relate their > > own experiences? > > > > Finally, if you do know your way > around Linux, Wire Shark is your go to > > friend for network > troubleshooting: > > https://www .w > > ireshark.org/ > > > > > > Good luck! > > > > Regards > > > > Geoff > > = > > > > > > > On 8/10/2022 6:29 pm, R Losey wrote: > > > Hi... yes, I did not > have al ALPHAVANTAGE_API_KEY and that was the > > > issue. Things now seem to > be updating properly. > > > > > > It is supposed to take so long? There is a > long (7 minute) delay before > > > the update finishes... I've been using the > gnucash-cli command line. > > > > > > On Sat, Oct 8, 2022 at 1:03 AM Geoff > > > <mailto:cleanoutmys...@gmail.com>> wrote
Re: [GNC] Price update not working - Alpha Vantage's limit is five (5) API requests per one (1) minute
Alphavantage has always rate-limited free quotes to five quotes per minute. When we started using them the quote rate was the primary difference between account tiers. Regards, John Ralls > On Oct 10, 2022, at 2:34 AM, Geoff wrote: > > Thanks for letting us know Ismael. > > Richard - this looks like the explanation for the delays you are seeing. > > Alpha Vantage are gently tightening the screws on their free service... > > Geoff > = > > On 10/10/2022 4:50 pm, Ismael Smajli wrote: >> Hello Alpha Vantage's standard API usage is limited to five (5) API requests >> per one (1) minute (https://www.alphavantage.co/premium/) My GnuCash (4.12) >> Price Database lists 22 securities and it takes FINANCE::QUOTE (1.53) >> slightly above 5min for the update. Regards Ismael >> ___ >> 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. > ___ > 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. ___ 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.
Re: [GNC] Orphan- and Imbalance- splits created on stock transaction when closing & reopening GnuCash data file
Well, I've figured out at least part of what's going on: The database has no ACME trading account, so when it encounters the split for one in the first transaction it creates an Orphan-AUD account and sets that as the account for what used to be the trading split. Then it runs the balancing code on the transaction and that creates a new trading account for UNLISTED:ACME and an Imbalance--AUD to balance the Orphan-AUD split. So far so good, right? But the account creation happens during database load and to prevent attempts to insert duplicate records (which would fail, but in failing they'd substantially slow down the load that's already too slow and log a ton of errors that would slow things even more) the loading code sets a flag that disables writing to the db during the load. That causes those accounts not to get written so the same thing happens when you start the next session. Doing a save-as writes a new database from the contents of memory that includes the newly created accounts. So I need to figure out a clean way to tell the sql backend that the new accounts aren't in the db already and that it should go ahead and write them. Regards, John Ralls > On Oct 9, 2022, at 10:49 PM, Chris Grinton wrote: > > Good to know that this isn't just me. Using "File > Save As" works as a > workaround for me too - good find! > > Chris > > > On Fri, 7 Oct 2022 at 12:59, john <mailto:jra...@ceridwen.us>> wrote: >> I can reproduce this with your sample file, and I discovered another facet: >> If one does a File>Save As, either to XML or SQlite3, the new file doesn't >> exhibit the behavior. >> I also found that if I remove the extra splits in the original file they >> don't come back. It's not a last-transaction issue, either: If one creates >> two transactions in a session they'll both get the Orphan and Imbalance >> splits created. >> >> I''l try watching the program load in the debugger next. >> >> Regards, >> John Ralls >> >>> On Oct 5, 2022, at 9:33 PM, Chris Grinton >> <mailto:cgrin...@gmail.com>> wrote: >>> >>> Good spotting on the share balance difference! I hadn't intended that in >>> the screenshots; it was just a side effect of me playing around trying to >>> get it to work between the first and 2nd screenshot - I had added some >>> other transactions for testing that did adjust the share balance. >>> >>> Selecting "Edit Exchange Rate" on the CapitalLosses:CurrentYear:Realized >>> split in the CapitalLosses:CurrentYear:Realized account register shows an >>> error: "The two currencies involved equal each other". >>> >>> I can reproduce the problem by creating a brand new (empty) GnuCash file >>> and then following the steps I described, and using only a single currency >>> in that file. So I don't think a multi-currency factor is at play here. >>> >>> If it helps and I've inspired anybody to dig deeper, I've shared a .gnucash >>> file at https://app.box.com/s/xdrru5yr8gjm3r7ovatmsn92jcvme053 that can be >>> used to reproduce: simply create a new buy or sell transaction involving >>> the ACME security in the Assets:ACME Corp account, and new Orphan & >>> Imbalance splits will be created in your transaction the next time the file >>> is opened. >>> >>> Chris >>> >>> On Thu, 6 Oct 2022 at 11:59, john >> <mailto:jra...@ceridwen.us>> wrote: >>>> That looks like a proper cap gains transaction. It's odd that the share >>>> balance differs by 250 between the two screenshots: Is there some other >>>> transaction that might be affecting things? >>>> >>>> The next thought is that there might be a non-AUD transaction currency >>>> involved. If you open the transaction in the >>>> CapitalLosses:CurrentYear:Realized account register, right-click on the >>>> split for that account, and select "Edit Exchange Rate" does it open the >>>> transfer dialog or pop an error box? If the former, what is the non-AUD >>>> currency/commodity it wants to price; if the latter, >>>> what's the error? >>>> >>>> Regards, >>>> John Ralls >>>> >>>> > On Oct 5, 2022, at 7:33 PM, Chris Grinton >>> > <mailto:cgrin...@gmail.com>> wrote: >>>> > >>>> > Good thought - but the problem still occurs even if the share count and >>>>
Re: [GNC] Problem with missing balance in a parent account **FINAL POST**
Ah, I misunderstood. It's disabled in the Action menu when the placeholder account's register is open and focussed. It does indeed work from the accounts page, both in the Action and the context menus. That's an oversight and should be fixed. Regards, John Ralls > On Oct 10, 2022, at 5:04 PM, Robin Chattopadhyay wrote: > > At the risk of sounding defensive (I assure you I'm not, just confused) > what is wrong with what I suggested (using the right-click/context menu on > the placeholder account)? In the screen shot attached, you can see that the > account I've selected is marked as placeholder and I can select the > Reconcile option from that account. > > I'm using 4.12 on Ubuntu 22.04. > > Robin > > On Mon, Oct 10, 2022 at 8:21 AM john wrote: > >> Please remember to copy the list on all replies. >> >> If you want the Reconcile button (and, contrary to what Robin Chatterjay >> wrote, Actions>Reconcile) to be active for your account, make it not a >> placeholder. >> >> Regards, >> John Ralls >> >> >>> On Oct 10, 2022, at 7:56 AM, Jay Ridgley >> wrote: >>> >>> Good morning, >>> >>> After some additional research I believe that the ONLY problem is the >> grayed out reconcile button. >>> >>> I was confused about the balance showing in the Parent Account, >> Placeholder. It shows in the Reconcile Popup window. >>> >>> The ACTUAL trouble is the grayed out Reconcile Button, that first >> appeared for me in Ubuntu 22.04 LTS after the upgrade. >>> >>> Since I have found the workaround below, it is a matter of >> inconvenience. However it would be preferable to have it as it was in >> earlier releases (not grayed out). >>> >>> Regards >>> Jay >>> >>> On 10/9/22 15:49, Jay Ridgley wrote: >>>> Good afternoon, >>>> Up until Ubuntu 22.04 The reconcile button was NOT grayed out for the >> type of account I am using (Parent account and Placeholder). I am >> including an example of my account structure here: >>>> Banking Account (Parent Account, Placeholder) >>>> Checkbook (sub-account)(contains all checkbook transactions) >>>> Reserve (sub-account) (contains minimum account balance) >>>> Separate Purpose (sub account) (rental income & expenses) >>>> Checkbook Blind (sub-account) (amount held as a pad) >>>> All transactions take place in the sub-accounts. For me it has worked >> successfully since I began using GnuCash (over 25 years ago). >>>> I was advised of a workaround that allows me to continue using this >> arrangement until it can be fixed/changed to act as it did previously. >>>> It is as follows: >>>> Open Parent account >>>> right click and choose reconcile from the drop down >>>> Works just fine. >>>> Would not be necessary if the Reconcile button was not grayed out. >>>> My question boils down too: Is this change a bug or a "feature" and can >> it be put back the way it was? >>>> Please advise how I should proceed. >>>> Thanks, >>>> Jay >>>> On 10/8/22 07:50, David T. wrote: >>>>> That account register doesn't have any transactions in it, so it won't >> have any value either. Is it possible that in the past, you used a report >> to see the parent account balances, or even the Chart of Accounts? >>>>> >>>>> And if the account in the screen shot is a placeholder account, then >> you a) wouldn't be able to open the account by double clicking, b) be told >> on selecting Open that it was read only, and c) once opened, the entire >> register would be greyed out. The screen shot seems to show a normal >> account. It also shows a similarly-named tab next to the active tab. >>>>> >>>>> David T. >>>>> On Oct 8, 2022, at 1:51 PM, Jay Ridgley > <mailto:jridgl...@austin.rr.com>> wrote: >>>>> >>>>> On 10/7/22 16:38, john wrote: >>>>> >>>>> >>>>> >>>>> On Oct 7, 2022, at 12:43 PM, Jay Ridgley >>>>>wrote: >>>>> >>>>> Good Morning, >>>>> >>>>> BRAND NEW to the list, have been using GnuCash on my Ubuntu >>>>> system for over 20 years, this is the first problem I have >>>>> encounte
Re: [GNC] How to include images in the Wiki?
> On Oct 10, 2022, at 9:01 PM, Geoff wrote: > > So, how do I go about obtaining "uploadaccess", or finding a friendly and > patient Administrator to upload images on my behalf? Just ask! What's your wiki username? Regards, John Ralls ___ 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.
Re: [GNC] How to include images in the Wiki?
David, OK, done. Regards, John Ralls > On Oct 11, 2022, at 4:29 AM, David T. via gnucash-user > wrote: > > John, > > sunfish62 (that's me) is also asking for such access. > > On 10/11/2022 6:38 AM, john wrote: >> >>> On Oct 10, 2022, at 9:01 PM, Geoff wrote: >>> >>> So, how do I go about obtaining "uploadaccess", or finding a friendly and >>> patient Administrator to upload images on my behalf? >> Just ask! >> >> What's your wiki username? >> >> Regards, >> John Ralls >> >> ___ >> 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. > ___ > 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. ___ 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.
Re: [GNC] Using GnuCash Wiki: Add Stock Page: Screenshots Added
> On Oct 11, 2022, at 5:06 PM, Frank H. Ellenberger > wrote: > > > > Am 12.10.22 um 01:34 schrieb R Losey: >> In GnuCash 4.12 on my Mac, I don't have a "Type" field -- it's called "Name >> Space" instead... I thought one needed to put the correct exchange there, >> but now I'm not sure. > > Before we had used in different GUI elements different names for the same > thing. > > And we dropped the US centric and outdated list, which had confused many > users. Similar to the account code you can create your own system to > structure your investments. > > The name of the exchange has only to be set inn some cases as F::Q source. The namespace isn't even passed to F::Q. F::Q wouldn't know what to do with it. F::Q wants a quote source (e.g. yahoo_json, alphavantage, aex, etc.) and a symbol. If you're using F::Q you need to make sure that the symbol you set is the one that the quote source you choose understands for that particular security. Namespaces are useful for symbol disambiguation. Although I don't know of a specific example, it's easily conceivable that the same symbol is used in different price sources referring to different stocks. The price database generally uses namespace and symbol for lookups, so putting the two securities in different namespaces allows the price database to easily find the right one when creating prices. Absent duplication they're useful for you to categorize your holdings. You can use any arbitrary scheme you like: Exchange, industry, country, holding category (e.g. speculative, growth, value); however it makes sense to you to sort your investments. You can also use none at all, in which case GnuCash will create a Non-Currency category for you. Remember that the CURRENCY namespace is special, hard-conded, and restricted to currencies (including obsolete ones) recognized by the ISO-4217 committee. When the feature was originally written some 20 or so years ago the author hard-coded some US stock exchanges--NYSE, NASDEX, AMEX, etc.as examples. We've found that to confuse a lot of users, making them think that those were the only choices, or that the categories had to be exchanges, so we removed them a few releases ago while working on something related. Regards, John Ralls ___ 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.
Re: [GNC] transaction images and failed hard drives
> On Oct 13, 2022, at 11:24 PM, Jeff wrote:
>
> Is there any way, even the slightest, to attach a transaction image to a
> daemon instead of a specific file? That way I could use a database system in
> the background to hold images instead of the file system. That way images
> would still be available to GNC and searchable for me (never know when a
> rebate might show up {grin}).
There's https://github.com/MigNov/Fuse-db that uses mysql-connector (should
also work with mariadb's connector) to create a filesystem interface. There's
also a perl module, https://metacpan.org/pod/Fuse::DBI, that (like GnuCash)
uses libdbi so it's a bit more general; the problem is that it's only mountable
from inside perl so it won't work directly with GnuCash.
Alternatively the link field takes URIs as well as directory paths and IIRC it
can load http: or https: URIs. If you can run a local web server to serve the
URIs you can use PHP to query a supported database for the desired image.
Regards,
John Ralls
___
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.
Re: [GNC] Moving Securities from one Security Account to another
Is the savings plan account tax deferred? If it is then it's probably a taxable event to transfer the shares out of it and you'll indeed want to do a sell/buy dance so that you can book the gain/loss income. If not then there should be no tax event and you can just CR the savings plan account for the number of shares and DR the regular one. You could 0-price that transaction, but it will make your live easier when you eventually sell the shares to price it at the average basis so that that's recorded in the "regular" account. You could also just delete the savings plan account and tell GnuCash to move the transactions to the regular account. You'll lose the history that the savings plan account existed but gain that all of the relevant transactions are visible in the regular account. Regards, John Ralls > On Oct 14, 2022, at 6:07 PM, R Losey wrote: > > I would merely "sell" them in the savings plan and then "buy" them in the > regular account. > > If you want your gain/loss to be correct, it may be more work... you would > have to "sell" each at the price it was added, and then buy it in the > regular account at that price... I assume this is what the bank did when > they "merged" the two accounts. If need this level of information, you > should have all of this recorded... it may be tedious, but it is certainly > doable. > > However, if you don't need that information, you can just sell the > savings security at current price and buy them at the current price. > > > On Fri, Oct 14, 2022 at 5:51 PM Thomas > wrote: > >> Dear list, >> >> I have to different accounts for one security (regular and saving plan >> account) and recently canceled said saving plan and instructed my bank >> to merge the shares in the saving plan account into the regular account, >> which they did. >> Unfortunately, I am somewhat clueless on how I can book such a >> transaction as there seem only to be the buy/sell options in security >> accounts. >> Could you please give me a hint on how I can book such a transaction >> properly? Moving shares from one account to another without any fees or >> other expenses. >> >> Thanks a lot in advance for your help! >> >> I use GnuCash 4.12 (Version-ID: 4.12+(2022-09-24)) on ArchLinux >> >> Best regards, >> Thomas >> ___ >> 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. >> > > > -- > _ > Richard Losey > rlo...@gmail.com > Micah 6:8 > ___ > 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. ___ 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.
Re: [GNC] Price database
The easiest would be to save your book to SQLite3: File>Save As..., pick Sqlite3 from the drop-down at the top of the dialog, pick a file name and location. Then run a query on the prices table (see https://wiki.gnucash.org/wiki/SQL#Prices for the schema; you may want to join on commodities to get the security's symbol and namespace and the currency's ISO-4217 code). Note that the actual price is saved in two fields, value_num and value_denom, that represents a fraction. Sqlite3 has a -csv option to output csv and a -o option to write a file. Regards, John Ralls > On Oct 15, 2022, at 9:39 AM, Elmar wrote: > > Asking again - is there any way to get the accumulated data copied from the > price database into a spreadsheet? > > - Elmar > > ___ > 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. ___ 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.
Re: [GNC] Using GnuCash Wiki: Add Stock Page: Screenshots Added
I've renamed that page to GnuCash SQL Examples.
Regards,
John Ralls
> On Oct 15, 2022, at 11:54 PM, David T. via gnucash-user
> wrote:
>
> Looks good. And this is definitely a better placement. Now, one wonders
> whether the name of the page ("PostgreSQL- Requests For Direct Database
> Access") would be better as "SQL For Direct Access to GnuCash Data"...
>
> Alas, the power to rename pages reside with only an anointed few...
>
> David T.
>
> On Oct 16, 2022, 7:21 AM, at 7:21 AM, Geoff wrote:
>> CORRECTION: My latest contribution is now here:
>>
>> https://wiki.gnucash.org/wiki/PostgreSQL-Requests_For_Direct_Database_Access
>>
>> (Puts down fire extinguisher ;--))
>>
>> Geoff
>> =
>>
>> On 16/10/2022 12:54 pm, Geoff wrote:
>>> Looks good to me too, thank you David.
>>>
>>> NOTE I have just attempted another (more restrained) Wiki update
>> here:
>>>
>>> https://wiki.gnucash.org/wiki/SQL#Prices
>>>
>>> (Fastens asbestos suit ;--))
>>>
>>> Thanks
>>>
>>> Geoff
>>> =
>>>
>>> On 13/10/2022 6:05 am, Frank H. Ellenberger wrote:
>>>> Thanks, David! :-)
>>>>
>>>> Am 12.10.22 um 09:01 schrieb David T.:
>>>>> Frank,
>>>>>
>>>>> I've just rewritten the page extensively, and in the course of
>> doing
>>>>> so, I added back your category and headers.
>>>>>
>>>>> David T.
>>>>>
>>>>> On Oct 12, 2022, 2:31 AM, at 2:31 AM, "Frank H. Ellenberger"
>>>>> wrote:
>>>>>>
>>>>>>
>>>>>> Am 12.10.22 um 01:17 schrieb Geoff:
>>>>>>> I have reverted all of my changes.
>>>>>>
>>>>>> … and my also. :-(
>>>>>>
>>>>>> Thanks
>>>>>> Frank
>>>>>
>>>> ___
>>>> 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.
> ___
> 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.
___
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.
Re: [GNC] [GNC-dev] Clear all OFX/QFX import associations
> On Oct 16, 2022, at 5:35 PM, Bruce H wrote: > > I'm running GunCash 4.8 on Linux. I have an investment account with > E-Trade. They provide QFX files for importing data into Quicken/Gnucash > and I've used those files in the past. They only keep 90 days worth > available and I got behind and missed a lot of months. I used another 3rd > party program to convert CSV data to OFX format and was able to get the > missing data into Gnucash. But now I'm caught up and am trying to use the > E-Trade supplied files again, but I'm having trouble getting it to pull in > all the transactions from the QFX. > > I've researched this quite a bit already. I've saved the data file as > uncompressed XML and I've gone in and removed everything I think is related > to the import for the main E-Trade account and all of its individual stock > subaccounts including the "import-match-bayes" slots. I've made sure that > the commodity entries have the same unique identifier and name as reflected > in the QFX file. > > What happens when I try to import is: > 1) It asks me for the currency commodity to use for the import and I tell > it to use USD. > 2) It asks me what Gnucash account to associate with this import and I > point it to my E-Trade main account. > 3) It asks me for the account to use for the sweep transaction (interest). > 4) It then shows the matcher with just a single transaction for the > interest received and that's it. > 5) It imports that single transaction. > > But in the QFX file there are 3 or 4 dividend reinvestment transactions and > it just seems to completely ignore those and doesn't import them or > complain about them. > > I was expecting it to ask me about each security in the QFX file and which > Gnucash account to use for that security as well as which income account to > use for them, but it didn't > > I have no problem editing the file either manually or through some > automation I create, but I just can't figure out what it is I need to > modify to basically clean this out. I understand the structure of the > file, but there is obviously some relationship I'm not seeing. > > So I guess only the developers can tell me what entires get created when > importing a QFX/OFX for the first time. What would I expect to see changed > in the XML data file if I import a QFX for the first time with one > transaction on one security? Wrong list, this is a user question. I've changed the cc accordingly, please everyone, reply to this instead the original so that ti goes to gnucash-user. Bruce, For a first time ever OFX import you'd get online-id slots in the matched accounts. For every import you'll also get online-id slots in every new split in the target account, but not in the transfer accounts. The split online-ids correspond to the OFX FITID field and they must be unique in the account. One possibility is that you've got a collision of the FITID used by your bank and the one created by the CSV->OFX tool you used. The account online-ids correspond to the account ids in the OFX file, so it's also possible that that mapping got messed up by the CSV->OFX tool generated imports. You might try copying your GnuCash file and editing the copy to remove all of the online-id slots. Run xmllint on it when you're done to make sure that it's still well-formed and fix any problems, then open it with GnuCash and try the import again. Regards, John Ralls ___ 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.
Re: [GNC] Help please. Upgraded from 2.3.4 to 4.12. Worked fine. But database does not load. Win 11.
The oldest release still on SourceForge is 2.2.0 and it includes a Windows setup.exe; the oldest unstable release is 2.3.0 and it does not, but all from 2.3.2 do have a setup.exe. The first commit to gnucash-on-windows was on 25 August 2006, not quite a year before, and the first announcement of a setup.exe being available is for 2.1.1 on 28 April 2007. Regards, John Ralls > On Oct 20, 2022, at 1:00 AM, Maf. King wrote: > > Just an observation, from the depths of history... > > IIRC, 2.3.x I think was a development series; unstable and for bug testing > and > so on, and for "expert" users only (ie not me) > > it feels to me that having that running on win11 is unlikely, I'm not even > sure that 2.3 release were for windows - if they were available then they > would have been some of the very first releases of GC on winXP. > > I am pretty sure that if 2.3.4 was installed by the OP, then the GC database > would be in XML not SQL and so the usually auto-created backup files should > have been made and might be lurking in a corner of a hard disk? > > HTH, > Maf. > > > > On Thursday, 20 October 2022 06:52:54 BST Adrien Monteleone wrote: >> Unlikely, but you might get lucky. (You really don't have *any* backup >> at all? Really? You've been using a decades old version of GnuCash and >> you never make backups?) >> >> Note, the GnuCash file, by default unless you changed it, is a >> compressed XML file. Uncompressed, it is just plain text and human >> readable. (albeit in a markup language) How the file is arranged has >> changed over the years, but the raw data should still be there. >> >> As for 'developing a problem afterwards' it could be that GnuCash is >> proceeding with data migration in the background, but it may have gotten >> hung up on something, or it is just really taking a long time. >> >> As David noted, running from the command line, or getting a Trace File >> might shed some light as to what is going on. >> >> You *might* get lucky by removing 4.12, going back to 2.3.4, then >> proceeding as I outlined, *but* be darned sure to MAKE A COPY of your >> file before doing so! >> >> Honestly, I'd go the route David suggested first to get some output and >> then report back here what you get. >> >> Also, what do you mean by 'blank screen'? Can you take a screenshot and >> attach it in a reply? (do not paste in-line, it needs to be attached) >> >> Maybe do that FIRST, and then once we see what you see, we can advise >> further. >> >> Regards, >> Adrien >> >> On 10/19/22 10:13 PM, Rosepetals wrote: >>> I don’t have a backup of the 2.3.4 database. Is there a way to recover >>> data >>> from the current 4.12 database? >>> >>> Also why does Gnucash work fine after the database upgrade but then >>> develop >>> a fault afterwards? >> >> ___ >> 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. > > > > > ___ > 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. ___ 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.
Re: [GNC] Valuation of multi-currency accounts
Pretty insightful for a newbie with no accounting background. An excruciatingly detailed discussion of this topic can be found at https://bugs.gnucash.org/show_bug.cgi?id=797796. One of the participants, CDB-Man, is a Canadian accountant. While the details of the discussion center around a few transactions in a CAD book involving a USD brokerage account holding a US ETF, SPY, the general principles illustrated are widely applicable to multi-currency accounting. Regards, John Ralls > On Oct 21, 2022, at 5:49 AM, Patrick Pöndl wrote: > > I guess it always depends on what you want to accomplish. If you are bound > by certain rules in your jurisdiction for tax purposes, you need to think > how to set up your accounts in GnuCash to obey those rules. If you are > bound by more than one jurisdiction with incompatible rules, maybe you even > need to keep track of the same transactions in two separate set of books in > order to stay sane. > > I was just under the impression that the original poster who suggested that > GnuCash should automatically create multi-currency subaccounts for each > expense account was simply suggesting this in order to save time and > effort, but was not aware what that would do to the quality of the data the > more exchange rates change over time: ever larger balances on the trading > accounts (which tend to eliminate meaning from the numbers) and ever > smaller balances on the expense and income accounts in terms of the base > currency (which do give meaning to the numbers). > > I guess one approach for people who don't want to (or can't for regulatory > purposes) convert to base currency for every single transaction would be > this: Enter a transaction from the expense/income account denominated in a > non-base currency to the same expense/income account denominated in your > base currency every so often (like once a year, or whenever exchange rates > changed significantly) to reset those accounts to zero. This way, at least > the problem of ballooning balances on the trading accounts would be solved > and the degradation of meaning of the numbers limited. > > But as I said, I'm a newbie at GnuCash, and I don't have an accounting > background. I just realized that this problem exists while planning my own > initial setup of GnuCash, and I still hope that someone more experienced > shares a method that both minimizes work and the described problem. > > Patrick Poendl > > Am Fr., 21. Okt. 2022 um 04:45 Uhr schrieb > : > >> >> -- Forwarded message -- >> From: Michael or Penny Novack >> To: gnucash-user@gnucash.org >> Cc: >> Bcc: >> Date: Thu, 20 Oct 2022 17:59:20 -0400 >> Subject: Re: [GNC] gnucash-user Digest, Vol 235, Issue 46 >> On 10/20/2022 12:21 PM, Patrick Pöndl wrote: >> >> THAT is the major issue with trying to keep multiple currencies in the >> same set of books. WHEN is to be the time of evaluation (of one to the >> other in terms of exchange rates). This can even be an issue for >> accounts of type asset and liability for those who are rarely moving >> amounts between currencies << who have accounts in both places, who have >> income and expenses in both places --- say who live/work in one country >> part of the year and in another the rest of the year >> >> >> Since not applying to me, I have never investigated the rules of the >> various jurisdictions. You have income in country B but your primary tax >> country is A. What does A say about when "conversion" takes place (when >> evaluated for income in B, taxes paid in B for which A might give >> credit, etc.) OR if A allows you to choose the date (say the end of the >> reporting year) how do you do that unless separate books? << since you >> would NOT want evaluations to have been taking place as you went along >> >> >> Michael D Novack >> >> >> > ___ > 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. ___ 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.
Re: [GNC] Gnucash on MacOS 12.5 ?
> On Oct 23, 2022, at 10:41 AM, Jesse Ayers wrote: > > I have been using GnuCash on Mac for several years. I have purchased a new > MacBook that runs MacOS 12.5 “Monterey.” Can someone tell me if Gnucash will > run on this new OS? I haven’t been able to find an answer on the Gnucash > site or in the text files that come with version 4.12. The only issue specific to Apple Silicon is that Finance::Quote doesn't work, see https://bugs.gnucash.org/show_bug.cgi?id=798456. Regards, John Ralls ___ 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.
Re: [GNC] Gnucash on MacOS 12.5 ?
> On Oct 24, 2022, at 8:36 AM, David Reiser wrote: > >> >> On Oct 23, 2022, at 10:40 PM, john wrote: >> >> >> >>> On Oct 23, 2022, at 10:41 AM, Jesse Ayers wrote: >>> >>> I have been using GnuCash on Mac for several years. I have purchased a new >>> MacBook that runs MacOS 12.5 “Monterey.” Can someone tell me if Gnucash >>> will run on this new OS? I haven’t been able to find an answer on the >>> Gnucash site or in the text files that come with version 4.12. >> >> >> The only issue specific to Apple Silicon is that Finance::Quote doesn't >> work, see https://bugs.gnucash.org/show_bug.cgi?id=798456. >> >> Regards, >> John Ralls >> ___ > > > It works for me on a Mac Studio (M1). Getting F::Q installed was a major > pain, though. Eventually what worked for me was using xcode-select to install > a second set of CommandLineTools in the non-xcode default location, make sure > that was the path cpan was using, and then installing F::Q. > > I have no idea if there was a more sane way to point cpan to CommandLineTools > in the usual XCode-related location. This is not the first time I’ve had two > installations of CommandLineTools, but it doesn’t seem to interfere with what > I use them for. That gave me an idea. sudo arch -x86_64 /Applications/Gnucash.app/Contents/Resources/bin/gnc-fq-update Just Works. Yay! I've updated the wiki page. Regards, John Ralls ___ 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.
Re: [GNC] 4.12 ERROR: In procedure scm-error: no code for module (gnucash utilities)
> On Oct 25, 2022, at 8:06 AM, osbert wrote: > thanks for your reply. I have now run the install command, but no binary is > installed to /opt/gnucash/bin > I hope this makes sense to someone here, because it doesn't really to me. Because > -- Installing: /opt/bin/gnucash You told CMake -DCMAKE_INSTALL_PREFIX=/opt. If you want GnuCash installed in /opt/gnucash then you have to tell cmake -DCMAKE_INSTALL_PREFIX=/opt/gnucash. Regards, John Ralls ___ 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.
Re: [GNC] Translation issues
> On Oct 24, 2022, at 11:33 PM, עמרי אלפרון <omri-...@hotmail.com> wrote: > > Hello GnuCashers! > > As a begginer translator and a native Hebrew speaker, I've came across some > translation issues, which cannot be compreheded well unless compared to the > original AmEng version. > > Whom should I address with those specific issues with the localization? > > (BTW, I'm new to GnuCash) Omri, Welcome to GnuCash! We handle translations through a project at Weblate: https://hosted.weblate.org/projects/gnucash/ There's more information at https://wiki.gnucash.org/wiki/Translation. Your issue is with other Hebrew translators, so the best thing to do is to comment on the strings that trouble you on Weblate. That way you can interact directly with the translators and perhaps arrive at a clearer meaning. Regards, John Ralls ___ 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.
Re: [GNC] Finance::Quote and TMX.pm
There's a pair of hard-coded structures at https://github.com/Gnucash/gnucash/blob/e30c1fce70c04fab4507ac869351165b0d70ae48/libgnucash/engine/gnc-commodity.c#L177 that lists the sources that GnuCash knows about; anything not in one of those two shows up in the third "unknown" list. The lists were last updated 5 years ago and are in need of another. When GnuCash starts up it queries F::Q for the available sources using gnc-fq-check and bounces the two lists, enabling in the entries in the hard-coded structs for the matching sources from gnc-fq-check; after the bounce any remaining F::Q sources populate the Unknown list at the bottom of the dialog. Yes, it's obviously brittle, but that's necessary because there's at present no way to retrieve the exchange names for the sources nor to distinguish between single and multiple source names so the combos in the security editor can't be populated dynamically. You'll notice that the Toronto Stock Exchange module is entered as tsx (line 227), so it doesn't match the current name of the module, tmx, and it doesn't get enabled but tmx appears in the unknown list. If you add your modified TSX module to @MODULES in Quotes.pm and you've changed every instance of tmx to tsx as part of your modifications it should get added to the sources list from gnc-fq-check and enable the tsx item in GnuCash's security editor. Regards, John Ralls > On Nov 12, 2022, at 9:07 AM, gnu Gord wrote: > > Thanks for the suggestion but the TMX module is already listed in Quote.pm. > It existed before I started so there must be some other way GnuCash decides > whether a module is available for use or not... I just don't know how. > > Thanks again, > Gord > > > On Sat, Nov 12, 2022 at 7:20 AM Ken Farley wrote: > >> If I remember correctly, when I made my own module to grab US EE Bond >> prices, in order for GnuCash to allow my module to be used, I had to add >> it to the MODULES list in Quote.pm. I'm working on a Mac, so your path >> might differ, but for me it's in /Library/Perl/5.30/Finance. I added a >> line between two of the entries in Quote.pm. For example, here's the >> chunk of that file for me, where I've added "USBonds" to reference my >> Perl module "USBonds.pm". >> >> @MODULES = qw/ >> AEX >> ... (many many modules) >> Troweprice >> USBonds >> USFedBonds >> Union >> YahooJSON >> ZA >> /; >> >> If that's not helpful, and something more has to be done, I don't know >> what it might be. I don't recall having to do anything else except >> restarting GnuCash. >> ___ >> 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. >> > ___ > 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. ___ 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.
Re: [GNC] Finance::Quote and TMX.pm
Only if you fix it in your PR. Otherwise GnuCash needs to be updated to look for tmx instead of tsx. Regards, John Ralls > On Nov 12, 2022, at 2:23 PM, gnu Gord wrote: > > Thank you very much, that worked!! > I'm not sure how this is going to be dealt with if/when the repaired version > of the TMX module is approved. > > Gord > > > On Sat, Nov 12, 2022 at 11:07 AM john <mailto:jra...@ceridwen.us>> wrote: >> There's a pair of hard-coded structures at >> https://github.com/Gnucash/gnucash/blob/e30c1fce70c04fab4507ac869351165b0d70ae48/libgnucash/engine/gnc-commodity.c#L177 >> that lists the sources that GnuCash knows about; anything not in one of >> those two shows up in the third "unknown" list. The lists were last updated >> 5 years ago and are in need of another. >> >> When GnuCash starts up it queries F::Q for the available sources using >> gnc-fq-check and bounces the two lists, enabling in the entries in the >> hard-coded structs for the matching sources from gnc-fq-check; after the >> bounce any remaining F::Q sources populate the Unknown list at the bottom of >> the dialog. Yes, it's obviously brittle, but that's necessary because >> there's at present no way to retrieve the exchange names for the sources nor >> to distinguish between single and multiple source names so the combos in the >> security editor can't be populated dynamically. >> >> You'll notice that the Toronto Stock Exchange module is entered as tsx (line >> 227), so it doesn't match the current name of the module, tmx, and it >> doesn't get enabled but tmx appears in the unknown list. If you add your >> modified TSX module to @MODULES in Quotes.pm and you've changed every >> instance of tmx to tsx as part of your modifications it should get added to >> the sources list from gnc-fq-check and enable the tsx item in GnuCash's >> security editor. >> >> Regards, >> John Ralls >> >> >>> On Nov 12, 2022, at 9:07 AM, gnu Gord >> <mailto:gnucashg...@gmail.com>> wrote: >>> >>> Thanks for the suggestion but the TMX module is already listed in Quote.pm. >>> It existed before I started so there must be some other way GnuCash decides >>> whether a module is available for use or not... I just don't know how. >>> >>> Thanks again, >>> Gord >>> >>> >>> On Sat, Nov 12, 2022 at 7:20 AM Ken Farley >> <mailto:farle...@gmail.com>> wrote: >>> >>>> If I remember correctly, when I made my own module to grab US EE Bond >>>> prices, in order for GnuCash to allow my module to be used, I had to add >>>> it to the MODULES list in Quote.pm. I'm working on a Mac, so your path >>>> might differ, but for me it's in /Library/Perl/5.30/Finance. I added a >>>> line between two of the entries in Quote.pm. For example, here's the >>>> chunk of that file for me, where I've added "USBonds" to reference my >>>> Perl module "USBonds.pm". >>>> >>>> @MODULES = qw/ >>>> AEX >>>> ... (many many modules) >>>> Troweprice >>>> USBonds >>>> USFedBonds >>>> Union >>>> YahooJSON >>>> ZA >>>> /; >>>> >>>> If that's not helpful, and something more has to be done, I don't know >>>> what it might be. I don't recall having to do anything else except >>>> restarting GnuCash. >>>> ___ >>>> gnucash-user mailing list >>>> gnucash-user@gnucash.org <mailto: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. >>>> >>> ___ >>> gnucash-user mailing list >>> gnucash-user@gnucash.org <mailto: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. >> ___ 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.
Re: [GNC] Gnucash on macOS Ventura
It is indeed a Gtk bug, https://gitlab.gnome.org/GNOME/gtk/-/issues/5305#note_1592320. Regards, John Ralls > On Nov 14, 2022, at 7:50 AM, Adrien Monteleone > wrote: > > I'm forever locked on Monterey so I can't test, and I don't see that problem > with GnuCash, but, I do see it running Firefox on Monterey and Win10, and I > get it all over the UI in *buntu based VMs starting with the 22.04 release. > > I don't know if Firefox uses GTK+ code, but if so (and considering GnuCash & > the *buntu distros I tried do so as well) then I'd say it is possibly a GTK > bug, not GnuCash. > > Regards, > Adrien > > On 11/14/22 2:54 AM, Christian Lynbech wrote: >> Anybody here who has experience running Gnucash (4.12) on the newest >> macOS Ventura? >> It basically works, but the UI is a bit wonky. The cursor does not >> update correctly, sometimes you need to click twice or be very carefull >> ot hit the text inside buttons. > > ___ > 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. ___ 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.
Re: [GNC] Find account on macOS Ventura
Find account works as expected for me on Ventura. Perhaps Alan can describe step-by-step what he's doing, what he expects at each step, and what actually happens. Regards, John Ralls > On Nov 14, 2022, at 10:46 AM, Adrien Monteleone > wrote: > > That is very odd indeed as now this isn't necessarily a Find Account problem > as it is an Accounts Tab problem. > > Does this only happen after doing Find Account? > > Now that you know where the account is, can you open it without doing a Find > Account first? > > Regards, > Adrien > > On 11/14/22 12:41 PM, Alan Magnus via gnucash-user wrote: >> My mistake. I does not open the account it just brings up the account name >> then I click to open. > > ___ > 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. ___ 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.
Re: [GNC] compiled 4.12 get white background instead of green ruled. Also printable invoice is shown small scale.
> On Nov 14, 2022, at 3:40 PM, John Griessen wrote: > > This was compiled from the 4.12 tar.bz2 after checking the sha256sum on linux > mint 21 with guile 3.0. > > I tried this compiling since the 4.12 flatpak is not showing printable > invoice at all after a mint update. > > I ran ninja check and all passed. > > Any ideas on missing dependencies or bugs in library updates apreciated. > > The green rules like paper accounting ledgers from 1960 are so familiar it > makes me pause and slows down looking at the books not having them. There's a preference on the Register tab under Graphics, Use GnuCash built-in color theme that enables the green-bar look in the Register. See if that's gotten unchecked. Regards, John Ralls ___ 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.
Re: [GNC] Gnucash on macOS Ventura
> On Nov 14, 2022, at 4:07 PM, William Prescott wrote: > > I have 4-12.2 installed as wel That's interesting since I haven't built a 4.12-2 and MacPorts is still on 4.11. Are you sure you don't have GnuCash-Intel-4.12-1(2).dmg, which would just be another download of 4.12-1? Regards, John Ralls ___ 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.
