Re: [GNC] Editing, moving customer lists, possible child lists

2018-10-21 Thread Jonathan Ames
Thanks, David. Appreciate your contextual placement of Gnucash in the database/SQL environment. Helps focus my thoughts, notions, etc. On Sun, Oct 21, 2018 at 11:07 PM David Cousens wrote: > Johnathon, > > It is possible to host the data files but not the application on a cloud > data storage.

Re: [GNC] Editing, moving customer lists, possible child lists

2018-10-21 Thread David Cousens
Johnathon, It is possible to host the data files but not the application on a cloud data storage. I use a dropbox so I can edit my files either at home, on my laptop when I am mobile or away etc. I have also used Google Drive for the same purpose In that case it is synchronised from the local

Re: [GNC] MacOS Mojave Python Bindings - No module named gnucash

2018-10-21 Thread John Ralls
> On Oct 21, 2018, at 5:15 PM, Aaron Surrain > wrote: > > I'm just getting started, running macOS Mojave, and trying to import from > QuickBooks. I tried installing GNU Cash with Python Bindings per these > instructions… > > https://wiki.gnucash.org/wiki/MacOSX/MacPortsDetail > > …and

[GNC] MacOS Mojave Python Bindings - No module named gnucash

2018-10-21 Thread Aaron Surrain
I'm just getting started, running macOS Mojave, and trying to import from QuickBooks. I tried installing GNU Cash with Python Bindings per these instructions… https://wiki.gnucash.org/wiki/MacOSX/MacPortsDetail …and running the scripts from Jonathan Corbet's article…

Re: [GNC] Editing, moving customer lists, possible child lists

2018-10-21 Thread Jonathan Ames
David, Thanks for your informative overview. It raises the question of whether Gnucash can be cloud and/or server-hosted, w/o adding glitch potential. Also, whether a Gnucash client/customer file can be nested within a database (e.g., Filemaker or Access-originated) perhaps as a table, which can

[GNC] Currency showing zero

2018-10-21 Thread dunbrokin
Whenever I do a price database - get quotes, all my currencies come back as zero. This despite following the instructions to cut and paste my Alphavantage Key into the Preferences Online Quoteswhat am I doing wrong? ___ gnucash-user mailing list

[GNC] Report Loading GC 3.3

2018-10-21 Thread David T. via gnucash-user
Hello, I just noticed that on v.3.3, reports do not load on startup. In version 2.x, all open reports were loaded in the startup process. Now, they only load when the specific tabs are activated. Is this change intentional? David T. ___

Re: [GNC] Preferences for latest version

2018-10-21 Thread David T. via gnucash-user
Adrien, I’ve been following this thread, and decided to try some of it out. I’d like to report that my results have been less than stellar, and just a little bit confusing. I will begin by saying that I am a long time MacOS user, and I am running both 2.6.19 and 3.3 on MacOS Mojave (which

Re: [GNC] Report Loading GC 3.3

2018-10-21 Thread David Carlson
David T, I hope that is intentional to make GnuCash load faster. Does it save time for you? David C On Sun, Oct 21, 2018 at 3:05 AM David T. via gnucash-user < gnucash-user@gnucash.org> wrote: > Hello, > > I just noticed that on v.3.3, reports do not load on startup. In version > 2.x, all

[GNC] Feature request: Stock currency setting

2018-10-21 Thread rsbrux via gnucash-user
I have been repeatedly frustrated by my failure to remember this advice from https://wiki.gnucash.org/wiki/Stocks/add_stock#Stocks_noted_in_foreign_currency >> If you start your first (buy) transaction from your stock account, the currency of the parent account will be used. Assuming your

Re: [GNC] Capital losses in Advanced Portfolio Report

2018-10-21 Thread José A . Fernández Troncoso
Yes, when I create a sale transaction on the stock, a capital loss is calculated automatically by the report and shown as a negative amount in the Realized Gain column. That's fine by me. The problem is that when I add a split to record the loss manually on the Expenses:Capital Loss acount,

Re: [GNC] Report Loading GC 3.3

2018-10-21 Thread John Ralls
Sorry, not intentional on our part. Most likely an intentional change to GtkNotebook as part of Gtk3’s migration to a composited display model. Regards, John Ralls > On Oct 21, 2018, at 2:37 AM, David Carlson > wrote: > > David T, > > I hope that is intentional to make GnuCash load faster.

Re: [GNC] Problem retrieving exchange rates

2018-10-21 Thread John Ralls
You probably figured out that you couldn’t run gnc-fq-update directly because it’s not on $PATH. All of the gnc-fq-foo scripts are in Gnucash.app/Contents/Resources/bin. It’s disappointing that attempting to run xcrun no longer pops up a dialog offering to install command-line tools. It’s also

Re: [GNC] GNUCash fails to start on Windows 10 after windows update

2018-10-21 Thread Colin Law
Anything in the gnucash trace file? Colin On Sun, 21 Oct 2018 at 10:57, crysty sandu via gnucash-user wrote: > > Hi, > I cannot start GNUCash anymore on windows 10, I see the start image and tips > of the day box for a second then nothing happens.Everything worked fine until > the October

Re: [GNC] Custom Reports in GnuCash 3.x on Windows

2018-10-21 Thread Tim Quinn
I believe the file name changed from config.user to config-user.scm, maybe back in 2.6 but I’m not sure of the specific version. - Tim > On Oct 21, 2018, at 6:27 AM, km22 wrote: > > Hi GnuCash Community, > > Is the wiki on Custom Reports > (https://wiki.gnucash.org/wiki/Custom_Reports)

Re: [GNC] Capital losses in Advanced Portfolio Report

2018-10-21 Thread John Ralls
That’s because the Advanced Portfolio Report is hard-wired to expect capital gains and losses to be posted to an income report with gains as credits and losses as debits. Regards, John Ralls > On Oct 21, 2018, at 3:18 AM, José A. Fernández Troncoso > wrote: > > Yes, when I create a sale

Re: [GNC] Report Loading GC 3.3

2018-10-21 Thread Geert Janssens
Bob Fewell did work on report loading at some point. It may well be the source of this change. I can't check right now, but you could search the closed PRs for some discussion of this. Geert John Ralls schreef op 21 oktober 2018 16:17:09 CEST: >Sorry, not intentional on our part. Most likely

Re: [GNC] Preferences for latest version

2018-10-21 Thread David T. via gnucash-user
Adrien, Further comments. First, I’m learning that, for colors at least, the names used have no spaces in them. So, “lightsteelgrey”, not “light steel grey”. I found a different site that noted the unspaced name forms after my initial attempts. My mistake. [This does not, however, rectify

Re: [GNC] Preferences for latest version

2018-10-21 Thread David T. via gnucash-user
In addition to GTK INspector not inspecting, it causes my GnuCash to crash completely after a short time. > On Oct 21, 2018, at 8:32 PM, David T. wrote: > > Adrien, > > Further comments. > > First, I’m learning that, for colors at least, the names used have no spaces > in them. So,

Re: [GNC] Unable to retrieve quotes for these items:, CURRENCY:EUR

2018-10-21 Thread rsbrux via gnucash-user
Dear John, Thanks for the tip!  After a bit of experimentation, it seems that the problem has to do with the number of currency exchange rates requested.  If I reduce the number to five or fewer, the price update works.  I guess this has to do with the limitations of AlphaVantage, which I

[GNC] GNUCash fails to start on Windows 10 after windows update

2018-10-21 Thread crysty sandu via gnucash-user
Hi, I cannot start GNUCash anymore on windows 10, I see the start image and tips of the day box for a second then nothing happens.Everything worked fine until the October Windows 10 updates.I am using the portable version 3.2, but I also tried 2.6.19, 3.2, 3.3 installed on my computer. None

Re: [GNC] Custom Reports in GnuCash 3.x on Windows

2018-10-21 Thread km22
Hi Tim, I saw that filename in the wiki and tried it too but unfortunately it didn't solve the issue of my custom report being added to the reports menu. Thanks, Ken On October 21, 2018 1:10:54 PM UTC, Tim Quinn wrote: >I believe the file name changed from config.user to config-user.scm,

Re: [GNC] Capital losses in Advanced Portfolio Report

2018-10-21 Thread David T. via gnucash-user
Jose, Just to be clear, I believe John is pointing out that your capital losses should be recorded in an Income account, rather than an Expense account. David > On Oct 21, 2018, at 8:05 PM, John Ralls wrote: > > That’s because the Advanced Portfolio Report is hard-wired to expect capital >

Re: [GNC] Custom Reports in GnuCash 3.x on Windows

2018-10-21 Thread Geert Janssens
Not only the file name has changed, its location has as well. The wiki page does explain this, there are separate instructions for 2.6.x and 3.x Regards, Geert km22 schreef op 21 oktober 2018 15:38:33 CEST: >Hi Tim, >I saw that filename in the wiki and tried it too but unfortunately it

Re: [GNC] Report Loading GC 3.3

2018-10-21 Thread David T. via gnucash-user
OK, it’s not a big issue. I just wondered. I’ve always been able to allow a program to take whatever time it needs to start up, but have less patience for commands after that. Because of that, for the longest time, I have had a multi-column dashboard that summarizes key information for me,

Re: [GNC] Capital losses in Advanced Portfolio Report

2018-10-21 Thread Christian Kluge
Hi, isn’t this hard wiring and expecting bad style? Could you make in a way, to select the both account types for the report? I’d feel confortable making a debit entry to an income account if it isn’t either a contra-income account like rebates or cash discounts or as a correction entry on a

Re: [GNC] Bad URL: owner=c:76e7c13664c9ad99e. . . . . . . . .=c73e0385e4d13ab79. . . . . . .

2018-10-21 Thread Geert Janssens
That sounds a lot like the bug I fixed recently. However the correct bug link is: https://bugs.gnucash.org/show_bug.cgi?id=796772 Regards, Geert John Ralls schreef op 20 oktober 2018 16:11:33 CEST: > > >> On Oct 19, 2018, at 10:07 PM, Leonidas Giorgallis > wrote: >> >> Hello everybody , >>

Re: [GNC] GNUCash fails to start on Windows 10 after windows update

2018-10-21 Thread crysty sandu via gnucash-user
The file is empty if I run it normally. If I run the program with --debug --extra I got:* 13:12:24  INFO [main] System locale returned (null) * 13:12:24  INFO [main] Effective locale set to C. * 13:12:36  INFO [gnc_load_app_icons] The icon theme search path has 10 elements. * 13:12:36  INFO

[GNC] Custom Reports in GnuCash 3.x on Windows

2018-10-21 Thread km22
Hi GnuCash Community, Is the wiki on Custom Reports (https://wiki.gnucash.org/wiki/Custom_Reports) up-to-date for GnuCash version 3.x series? I tried making custom reports back in the 2.6 series and was able to load my custom report saved to C:\Users\Ken\.gnucash.  I am revisiting this now but

Re: [GNC] Problem retrieving exchange rates

2018-10-21 Thread Geoff Jankowski via gnucash-user
John I experienced similar problems with f:q. I tired to run gnc-fq-update through the terminal but it does not recognise the command. I re-mounted gnucash 3.2-2.dmg and ran FinanceQuote Update from there and this is the failed output I got (see yellow highlights): Last login: Sun Oct 21

Re: [GNC] Currency showing zero

2018-10-21 Thread John Ralls
You’re actually getting zero prices or you’re getting the “unable to retrieve quotes” error for those currencies? What is your book currency and for what currencies are you trying to get exchange rates? Regards, John Ralls > On Oct 20, 2018, at 10:38 PM, dunbrokin wrote: > > Whenever I do

Re: [GNC] Feature request: Stock currency setting

2018-10-21 Thread John Ralls
> On Oct 21, 2018, at 2:51 AM, rsbrux via gnucash-user > wrote: > > I have been repeatedly frustrated by my failure to remember this advice from > https://wiki.gnucash.org/wiki/Stocks/add_stock#Stocks_noted_in_foreign_currency > > >> > > If you start your first (buy) transaction from your

Re: [GNC] Capital losses in Advanced Portfolio Report

2018-10-21 Thread José A . Fernández Troncoso
Thank you, John and David: Using an income acount to record the loss solves the issue. I'm afraid I was misled by the Tutorial and Concepts Guide where it says: "Account for the profit or loss as coming from an Income:Capital Gains or Expenses:Capital Loss account. " (section 9.7.1.1).

Re: [GNC] Preferences for latest version

2018-10-21 Thread Adrien Monteleone
Ah, thanks for the clarification. Regards, Adrien > On Oct 20, 2018, at 4:24 PM, John Ralls wrote: > > No, we moved to Gtk3 because WebKitGtk no longer supports Gtk2 and we were > getting dropped from major distros for using an old version of WebKitGtk. > > Regards, > John Ralls > > >> On

Re: [GNC] Preferences for latest version

2018-10-21 Thread Adrien Monteleone
* On the question of errors, I’ve noticed something similar in some cases. It is spotty though. Sometimes the rest of the declaration works. Certainly, if your rule doesn’t terminate in a “;” or you accidentally terminated it with “:” then likely the entire declaration will fail. This is not

Re: [GNC] Preferences for latest version

2018-10-21 Thread Adrien Monteleone
David, I’ll address the inspector first and then send another reply to the specific CSS questions. The inspector most likely is opening (I use the same command) but it’s opening behind the GnuCash window. Do an Application Window spread and you’ll see it. (I have my top left hot corner set,

Re: [GNC] Preferences for latest version

2018-10-21 Thread Adrien Monteleone
Interesting. Might be something about Mohave, I’m still on HighSierra. Also, forgot to note, yes I too get those same output warnings in Terminal. Not sure if there is a problem there, or just a warning. I just recalled that for me too, the inspector did not launch initially. I had to install

Re: [GNC] Capital losses in Advanced Portfolio Report

2018-10-21 Thread David T. via gnucash-user
Jose, That is likely an error. It is interesting to see that none of the examples has the loss going into an expense account. Thanks for pointing this out. David > On Oct 21, 2018, at 9:28 PM, José A. Fernández Troncoso > wrote: > > Thank you, John and David: > > Using an income acount to

Re: [GNC] Editing, moving customer lists, possible child lists

2018-10-21 Thread David Cousens
Jonathon, The customer information is separate from any account information. It is not generally necessary to have an account for each customer that you have as the customer information can be linked to a specific transaction to an account. An account in Gnucash is a register which records the

[GNC] Editing, moving customer lists, possible child lists

2018-10-21 Thread Jonathan Ames
Hello, As a solo psychotherapist, wondering relation between "Customers" and "Accounts" (in QB, customers *are* accounts). Each client I see has their own billing account, and (mostly) their insurance-related account. Aging is different: insurers avoid payments frequently until dunned repeatedly.

Re: [GNC] Capital losses in Advanced Portfolio Report

2018-10-21 Thread Christopher Lam
It's hard wired because that's what the report writer wrote, and was merged into gnucash, as a voluntary contribution. It's rather difficult to modify these reports and maintain full compatibility with everyone who has used them previously and expect the report output to be predictable. Often