Re: [GNC] Incorrect Trial Balance Amounts

2021-06-14 Thread Volker Englisch
Thank you for the explanation, John!  I did have the price source for the report set to "Nearest in time".  After setting the source to "Average Cost" the numbers came out as expected. Regarding your question about the proper recording of the capital gains, I'm still going through the document

Re: [GNC] Should the gnc-fq-* helper scripts be invoked as commands, or as an arg to perl?

2021-06-14 Thread Jim DeLaHunt
On 2021-06-14 17:45, Chris Good wrote: You have to set the key in the cmd environment before invoking gnc-fq-dump. E.g. cd \Program Files (x86)\gnucash\bin set ALPHAVANTAGE_API_KEY=## gnc-fq-dump alphavantage CSCO Oh, I see. Thank you for explaining that, Chris. --Jim DeLaHunt _

[GNC] GnuCash v3.7 - Trial Balance giving zeros

2021-06-14 Thread Adrian Yong
Hi, I am using v3.7 and for FY ending 2020; I am getting zeros in my Trial Balance. It was ok for 2019. Any advice on what I should do ? Regards, Adrian ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or t

Re: [GNC] Inconsistent meanings of "AsOfDate"?

2021-06-14 Thread Christopher Lam
Hi, On Tue, 15 Jun 2021 at 00:09, Hong Xu wrote: > I'm checking out the APIs of GnuCash. In > xaccAccountGetReconciledBalanceAsOfDate, AsOfDate seems to mean ON OR > BEFORE the date: > > > https://github.com/Gnucash/gnucash/blob/7fe78e7017b3cb397e6a2f5a63c56e1933521a68/libgnucash/engine/Account.

Re: [GNC] Should the gnc-fq-* helper scripts be invoked as commands, or as an arg to perl?

2021-06-14 Thread Chris Good
Message: 4 Date: Sun, 13 Jun 2021 23:43:03 -0700 From: Jim DeLaHunt To: gnucash-user@gnucash.org Subject: Re: [GNC] Should the gnc-fq-* helper scripts be invoked as commands, or as an arg to perl? Message-ID: <108f1340-0815-46e8-2107-73c50dba2...@jdlh.com> Content-Type: text/plain; charset

[GNC] Inconsistent meanings of "AsOfDate"?

2021-06-14 Thread Hong Xu
I'm checking out the APIs of GnuCash. In xaccAccountGetReconciledBalanceAsOfDate, AsOfDate seems to mean ON OR BEFORE the date: https://github.com/Gnucash/gnucash/blob/7fe78e7017b3cb397e6a2f5a63c56e1933521a68/libgnucash/engine/Account.cpp#L3572 In xaccAccountGetBalanceAsOfDate, AsOfDate se

Re: [GNC] Should the gnc-fq-* helper scripts be invoked as commands, or as an arg to perl?

2021-06-14 Thread Frank H. Ellenberger
Hello Jim, I fear this changes would go in the wrong direction. It would hide the important "normal" stuff behind a bunch of noise. Instead of adding aphavantage and probably other keys to each command, explain for your OSes, how to add them to the environment on each login. IIRC future FQ releas

Re: [GNC] On a Mac, where are the database configuration details stored?

2021-06-14 Thread John Ralls
Generally speaking the passwords are stored in Keyring and the user is prompted if the password isn't found. I'm not sure what it does if the connection doesn't have a password. You can examine the keyring with /Applications/Utilities/Keyring Access. If it does have an entry for your database t

Re: [GNC] Should the gnc-fq-* helper scripts be invoked as commands, or as an arg to perl?

2021-06-14 Thread John Ralls
> On Jun 13, 2021, at 8:53 PM, Jim DeLaHunt wrote: > > Imagine if cars or medicines or food were produced with that as a guiding > principle. They are. The state requires extensive training and licensing before one is allowed to operate a car or to prescribe medicine. There's no such requir

Re: [GNC] Incorrect Trial Balance Amounts

2021-06-14 Thread John Ralls
> On Jun 13, 2021, at 5:39 PM, Volker Englisch wrote: > > Hi there, > > I would like to check if I'm doing something wrong or if I'm correct in my > assumption that the Trial Balance report isn't displaying correct amounts in > all cases. > > I'm using Ubuntu 20.04.2 LTS with GnuCash 3.8. >

Re: [GNC] Check printing

2021-06-14 Thread R. Victor Klassen
That would depend upon the number you’re doing in a given period. I have payroll output to QIF which when imported gives me the stub I need. And it fits the window envelope just fine. I would hate to have to edit each and every cheque. Sent from my iPhone > On Jun 14, 2021, at 10:49 AM, M

Re: [GNC] Check printing

2021-06-14 Thread Michael or Penny Novack
On 6/14/2021 6:51 AM, R. Victor Klassen wrote: I have no experience with the three-part cheques, as the ones I use consume a full page (one third for the cheque, one third for each of the stubs). When I do what you describe - except for the format - it works fine. So someone else will have t

Re: [GNC] GnuCash very slow to start up and quit

2021-06-14 Thread Chris Green
On Mon, Jun 14, 2021 at 07:00:58AM -0400, R. Victor Klassen wrote: > When I had speed problems it was much more extreme. I had been using SQLite. > I switched to XML, and then switched back, and the effect of saving it > in a different format, and reading it back was enough to make a dramatic >

Re: [GNC] GnuCash very slow to start up and quit

2021-06-14 Thread R. Victor Klassen
When I had speed problems it was much more extreme. I had been using SQLite. I switched to XML, and then switched back, and the effect of saving it in a different format, and reading it back was enough to make a dramatic improvement. There was something in the data file that made it slow, and

Re: [GNC] Check printing

2021-06-14 Thread R. Victor Klassen
I have no experience with the three-part cheques, as the ones I use consume a full page (one third for the cheque, one third for each of the stubs). When I do what you describe - except for the format - it works fine. So someone else will have to chime in here. > On Jun 10, 2021, at 12:55 PM,

Re: [GNC] gnucash-cli says, "No quotes retrieved. Finance::Quote isn't installed properly" on macOS

2021-06-14 Thread list+gnucash
On 2021-06-12 23:49, Jim DeLaHunt wrote: …I submit that installing packages with MacPorts or Homebrew has aspects of installing application software, as well as aspects of altering the OS. Installing application software is a reasonable thing for people to do with their personal computers. I d