Re: [GNC] Reconcile also opens Interest Payment box?

cares". To your points: A Scheduled Transaction is an even better reminder and quick fill (aka autocomplete) in the register will fill in the last payment account too. What quickfill won't do is pre-populate the credit field with the reconciled balance. Regards, John Ralls > On Jul 12, 202

Re: [GNC] Prevent register from auto-duplicating transactions?

the extra character and press Enter to complete the transaction. Regards, John Ralls > On Jul 12, 2020, at 12:27 PM, Stan Brown wrote: > > Example: In a trip to the supermarket I buy food, wine, flowers, and > cleaning supplies. To record that, I enter a transaction in GC, in the >

Re: [GNC] Reconcile also opens Interest Payment box?

Would it cause you any pain to enter the interest transaction in the register before clicking reconcile instead? Regards, John Ralls > On Jul 12, 2020, at 11:49 AM, w...@theprescotts.com wrote: > > I actually use the interest payment box to add a monthly interest transaction

Re: [GNC] Reconcile also opens Interest Payment box?

have for objecting? Regards, John Ralls > On Jul 10, 2020, at 6:59 PM, Adrien Monteleone > wrote: > > Thanks Jean, > > I filed bug: https://bugs.gnucash.org/show_bug.cgi?id=797854 for the issue > with the global preference not being honored. > > And bu

Re: [GNC] Keep the Reconciliation Feature (was Re: Gnucash 4.0 Paper Clip and Link glyphs for file/web transaction associations)

Of course not. Reconciliation is a basic accounting requirement. Regards, John Ralls > On Jul 11, 2020, at 5:01 AM, Jon Schewe wrote: > > Sorry for jumping in late on this, but are the developers seriously > considering removing the reconciliation feature? If it's about space on &

Re: [GNC] Database schema documentation

https://wiki.gnucash.org/wiki/SQL There's a linked ERD that also shows how the various key-value parameters (also called slots) relate to the data stored in tables. Regards, John Ralls > On Jul 9, 2020, at 7:29 PM, Tom Hatzigeorgiou wrote: > > has anyone created a data d

Re: [GNC] OFX setup

any banks to test against, so a bug report to AQBanking wouldn't be scoffed at but it wouldn't get a lot of attention because they can't even try to replicate it. I'm afraid that you're stuck with me for figuring this out. We can switch to a bug report if you like, but it'll still be me on the oth

Re: [GNC] OFX setup

t all about the server internal error in either. Was that from a different session? Regards, John Ralls ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listin

Re: [GNC] Net News

] succeeded! So if you want to go full retro, you still can. Regards, John Ralls > On Jul 7, 2020, at 9:11 AM, Adrien Monteleone > wrote: > > I followed the Gmane rabbit hole a bit. > > It seems whomever is the admin is setting up a new server @ news.gmane.io > > Th

Re: [GNC] Error retrieving price quotes

> On Jul 6, 2020, at 4:23 PM, John Haiducek wrote: > > > > On Wed, Jul 1, 2020 at 8:03 PM John Ralls wrote: > > > > On Jul 1, 2020, at 10:17 AM, John Haiducek wrote: > > > > When I try to fetch prices I get the error "There was a system

Re: [GNC] OFX setup

. Regards, John Ralls > On Jul 6, 2020, at 9:41 AM, Fleur Dragan wrote: > > > It didn't even occur to me I couldn't send an attachment to the list. I > facepalm. I'll go through it again with debugging and send you the output > directly tomorrow. Thanks. > > And o

Re: [GNC] OFX setup

to identify the account in the UI so you can enter whatever you like. The other fields are for HBCI/FinTS and can safely be left blank. Regards, John Ralls > On Jul 6, 2020, at 4:33 AM, Fleur Dragan wrote: > > > First I set: > > export GWEN_LOGLEVEL=debug > export AQBANKING_LO

Re: [GNC] Gnucash user Nabble

> On Jul 6, 2020, at 3:16 AM, Liz wrote: > > On Sun, 5 Jul 2020 07:20:17 -0700 > John Ralls wrote: > >> I'm not the list moderator nor do I have shell access to the mail >> server, so I can't help you. Your best recourse is to get on IRC >> (https://wi

Re: [GNC] Gnucash-User

ense, and doing so for commercial purposes (they run ads on the website). Regards, John Ralls P.S. Lessee, to make things more interesting: Copyright 2020 John Ralls, Fremont California. All rights reserved. Publication permission granted solely to lists.gnucash.org. _

Re: [GNC] Gnucash user Nabble

I'm not the list moderator nor do I have shell access to the mail server, so I can't help you. Your best recourse is to get on IRC (https://wiki.gnucash.org/wiki/IRC) and ping warlord. Regards, John Ralls > On Jul 5, 2020, at 4:24 AM, J R wrote: > > I too sorry for contacting yo

Re: [GNC] Accessing online currency rates

ntainers decided to make Alphavantage the currency source. At the time it wasn't clear that Yahoo! would continue the json service; that's sort of still true, AFAIK they've never said one way or the other. It could disappear without notice. Regards, John Ralls

Re: [GNC] Keep the Reconciliation Feature (was Re: Gnucash 4.0 Paper Clip and Link glyphs for file/web transaction associations)

But all of those accounts should be periodically reconciled unless you never post anything except by importing it. Regardless, that's a perfectly fine use-case, but I don't think that it's a common one or even that GnuCash is the best solution for it. Regards, John Ralls > On Jul 4, 2

Re: [GNC] OFX setup

. Regards, John Ralls > On Jul 4, 2020, at 5:46 AM, Fleur Dragan wrote: > > Ah! My mistake! I had 3.10 and was checking against that. > > I just tried to set up an OFX account with 4.0, which is as you said 6.2.1, > but still am having no luck. > > So when I try to

Re: [GNC] Keep the Reconciliation Feature (was Re: Gnucash 4.0 Paper Clip and Link glyphs for file/web transaction associations)

, of course, keep one's GnuCash book by downloading transactions from the bank. In that case you're not keeping a separate book and there's no point to reconciliation. But why bother with GnuCash if you're going to do that? Regards, John Ralls > On Jul 4, 2020, at 5:38 AM, py...@cox.net wr

Re: [GNC] Gnucash-User

hese price: <=/ timezone: <=== optional Regards, John Ralls > On Jul 3, 2020, at 11:03 PM, Adrian Holbrook wrote: > > I have been trying to post on the forum but for some reason am no longer > allowed to post. I have sent a number of

Re: [GNC] GunCash 4.0 Paper Clip and Link glyphs for file/web transaction associations

. You might remember Register2, Bob Fewell's attempt to rewrite it to use GtkTreeView for GnuCash 2.6. He wasn't able to make it stable enough and set it aside. It's still in the codebase: Run gnucash --extra and the Extra menu has "Open Account with Register2". Regards, John Ralls

Re: [GNC] Accessing online currency rates

Did you remember to run Install Online Price Retrieval for GnuCash from the GnuCash group in the Start Menu? Regards, John Ralls > On Jul 2, 2020, at 4:29 AM, Samantha Payn > wrote: > > I have had to change computers and have installed my existing Gnucash > set-up (i

Re: [GNC] Split transaction on invoices in foreign currencies

and is what made it an EUR transaction: It was that you created it in an EUR register or if you used the Transfer Dialog it was that of the From Account (the one on the left unless you're have "use formal accounting labels" in which case it's the one on the right). Regards, John R

Re: [GNC] Split transaction on invoices in foreign currencies

arge. > > Regards, > Adrien > > > > >> On Jul 2, 2020 w27d184, at 11:34 AM, John Ralls wrote: >> >> >> >>> On Jul 2, 2020, at 9:08 AM, Antonio Roberts >>> wrote: >>> >>> I'm in the UK doing most of my accounting i

Re: [GNC] Split transaction on invoices in foreign currencies

sed to balance the transaction. That currency is determined by the account from which the transaction is created, and in this case it's EUR, so GnuCash needs to know the value in EUR of the bank charge. Just use the same exchange rate that you used to convert

Re: [GNC] Custom invoices don't work after upgrade

e changes and since 3.0 functions that are removed are first deprecated so that they emit warnings, but you have to check the trace file to see the warnings. If you don't want to keep up with GnuCash development you have two choices: Never upgrade or don't use custom reports. Regards, John Ralls

Re: [GNC] Error retrieving price quotes

diately apparent, like an invalid source. If not, report back with the security and source that fails. Regards, John Ralls ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gn

Re: [GNC] Open Files Error with Chinese Path Name in V4.0

By File Explorer do you mean Windows Explorer or the File Chooser that you use from File>Open? Which ever it is, does the other way work? Regards, John Ralls > On Jun 29, 2020, at 5:25 PM, Chen Thomas wrote: > > Sorry, 3.11 instead of 3.9 mentioned below. > > ---

Re: [GNC] Gnucash 4.0 not available via Flathub

Thanks, the merge from beta didn't pick up that it needs the swig module. I've fixed that and started a new build. Regards, John Ralls > On Jun 29, 2020, at 12:48 PM, Guillermo Lopez > wrote: > > I am trying to try/use Gnucash 4.0 using Flatpak build. However, the most > r

Re: [GNC] 4.0.1 gnucash-cli seg faults on macOS Catalina

* 15:32:59 INFO [QofDbiBackendProvider::type_check] doesn't exist (errno=14) -> DBI * 15:32:59 ERROR gnc_uri_get_components: assertion 'uri != NULL && strlen (uri) > 0' failed Segmentation fault: 11 Please do file a bug report and attach the crash report from Applications>U

Re: [GNC] 4.0.1 attachments symbol

That change is indeed in 4.0, just checked that it works. Regards, John Ralls > On Jun 29, 2020, at 12:40 PM, Adrien Monteleone > wrote: > > I have a thread on the -devel list about this. > > There is an emoji visibility issue with GTK integration on MacOS. (the > pap

Re: [GNC] 4.0 and Change in Column Widths

of the Windows menu) and left the account registers as-is. We hope to sort out the issues with general registers and reintroduce it there in a few months. Unfortunately I didn't get the release notes adjusted correctly. I've since fixed them at www.gnucash.org and GitHub. Regards, John Ralls

Re: [GNC] Gnucash 4.0 doesn't launch on MacOS X 10.15.4

and that caused a complete failure for one user last week, though it doesn't seem to affect most users. Regards, John Ralls > On Jun 29, 2020, at 9:56 AM, w...@theprescotts.com wrote: > > Ditto on Mac OS 10.15.5. Opened without issues. > The first time it asked for the standard permission t

Re: [GNC] V4 installation messages/cautions

Thanks, we know about that. We've briefly discussed setting up code signing on Windows but haven't done anything about it as getting a suitable certificate is more involved than it is with Apple. Regards, John Ralls > On Jun 29, 2020, at 7:36 AM, Barry Dewhurst wrote: > > Just ins

[GNC] GnuCash 4.0 Released

The GnuCash development team announces GnuCash 4.0 Changes Baseline requirements Operating Systems: • Linux: Ubuntu 18.04LTS • MacOS: 10.13 • Windows: 8.1 Software Dependencies: • C++ standard is now C++17, requires gcc 8.0 or clang 6.0. • Cmake 3.10

Re: [GNC] error message with finance::quote gnc-path-check + problems with retrieving quotes for 2 symbols.

gnc-fq-helper, and gnc-fq-update. No gnc-path-check. What same answer does gnc-fq-dump give, that the symbol isn't found? What are the two symbols? Have you tried price source tiaacref? Regards, John Ralls ___ gnucash-user mailing list gnucash-user@gnucash.org

[GNC] GnuCash 3.906 Released

The GnuCash development team announces GnuCash 3.906, the fifth testing release for what will soon be GnuCash 4.0. This is the release-candidate: Barring any serious bugs it's what we'll release as 4.0 next weekend. Changes Baseline requirements Operating Systems: • Linux: Ubuntu

Re: [GNC] Question marks instead of currency in reports

Hard to tell for reports, that would be up to webkit and while I found where it's set in the webkit source I don't see any default value there. Gtk's default on MacOS is SystemDefaultFont (San Francisco on El Cap and later) 12pt. Regards, John Ralls > On Jun 19, 2020, at 4:47 AM, Gio Bacar

Re: [GNC] Price Database

$ bin/gnc-fq-dump currency HKD USD 1 HKD = 0.12903193 USD Regards, John Ralls > On Jun 17, 2020, at 11:15 AM, Les wrote: > > Thanks for your reply. However, the problem is I have a Hong Kong bank > account that has multiple currencies. The default is HKD, but I need Price

[GNC] GnuCash 3.905 Released

The GnuCash development team announces GnuCash 3.905, the fourth testing release for what will soon be GnuCash 4.0. Changes Baseline requirements Operating Systems: • Linux: Ubuntu 18.04LTS • MacOS: 10.13 • Windows: 8.1 Software Dependencies: • C++ standard is

Re: [GNC] Can Finance::Quote look up bond prices by CUSIP?

and binary-searching until I found it. They give F4955773 as the symbol, FWIW. Your best option seems to be to write a F::Q scraper module for empirasign.com. Regards, John Ralls > On Jun 8, 2020, at 11:40 AM, peterb wrote: > > Following up on this: I definitely am unable to look up

Re: [GNC] manuel en Français

Si vous voulez de l'aide en français, il vaut mieux demander sur la liste de diffusion française: https://lists.gnucash.org/mailman/listinfo/gnucash-fr. Cette liste est en anglais. Regards, John Ralls > On Jun 7, 2020, at 9:13 AM, Philippe POUMAILLOUX > wrote: > > Peut-être c

Re: [GNC] Download or change GNU Cash language to Spanish

gt; You already have, though if you're using a distro that has language packs you might have to find the right one with the GnuCash Spanish message catalog. You might find https://wiki.gnucash.org/wiki/Locale_Settings helpful. Regards, John Ralls ___ gnu

[GNC] GnuCash 3.904 Released

The GnuCash development team announces GnuCash 3.904, the third testing release for what will soon be GnuCash 4.0. Changes Baseline requirements Operating Systems: • Linux: Ubuntu 18.04LTS • MacOS: 10.13 • Windows: 8.1 Software Dependencies: • C++ standard is

Re: [GNC] --add-price-quotes prints nothing and always fails with no info

timezone: <=== optional > > Is there any way to get more debug information? My system is Debian 10, and > "gnucash -v" outputs: By default GnuCash logs to a file: https://wiki.gnucash.org/wiki/Tracefile. If you want the output to go to the terminal add `-

Re: [GNC] Importing XLM into GNUCash

is a language for creating data formats, not a format in itself. GnuCash can import invoices but they must be in something resembling a comma-separated-value format with the columns in a specific order. Regards, John Ralls ___ gnucash-user mailing list g

Re: [GNC] Libboost error upon upgrade to 20.04 from 19.10

Hah! So it was your own build, not Ubuntu's. You should go close your bug report. Regards, John Ralls > On Jun 2, 2020, at 12:03 PM, Tim Kallmer wrote: > > Actually, I was able to resolve my issue just now. I resolved it by deleting > a previous build still present in my f

Re: [GNC] Libboost error upon upgrade to 20.04 from 19.10

If you're able to build GnuCash from source that will resolve the problem. Regards, John Ralls > On Jun 2, 2020, at 11:53 AM, Tim Kallmer wrote: > > > ubuntu-bug gnucash > > Okay, I filed that bug. Thanks. In the meantime, would building a newer GC > like 3.10 mys

Re: [GNC] ANNOUNCE: GnuCash 3.903 Released

It's actually the second, but still... Regards, John Ralls > On Jun 1, 2020, at 5:17 PM, Ed Reeder wrote: > > John, > You might want to clarify that this is an experimental/unstable release. > > Thanks for all you do! > > > On Mon, Jun 1, 2020, at 4:38 PM, John Ra

Re: [GNC] Libboost error upon upgrade to 20.04 from 19.10

hose will be libboost_date_time, libboost_filesystem, libboost_locale, and libboost_regex. The right fix is to get the Ubuntu packager to rebuild the package with the new library versions. Regards, John Ralls ___ gnucash-user mailing list gnucash-user

Re: [GNC] Unable to set start and end date in Income Statement report

use they have nice demo code built in; the actual controls used in GnuCash are GtkRadioButton [3] and GtkCheckButton [4]. Regards, John Ralls [1] https://www.w3schools.com/tags/att_input_type_radio.asp [2] https://www.w3schools.com/tags/att_input_type_checkbox.asp [3] https://developer.gnome.or

Re: [GNC] GnuCash 3.903 Released

/gnucash/gnucash%20%28unstable%29/gnucash-docs-3.903-1.tar.gz;> https://github.com/Gnucash/gnucash/releases/download/3.903/gnucash-docs-3.903.tar.gz Regards, John Ralls ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscript

Re: [GNC] [GNC-dev] GnuCash 3.903 Released

> On Jun 1, 2020, at 11:51 AM, John Ralls wrote: > > GnuCash is now available as a flatpak from Flathub.org. Instructions for > installing and running. Are at https://wiki.gnucash.org/wiki/Flatpak Sorry. Regards, John Ralls ___

Re: [GNC] [GNC-dev] GnuCash 3.903 Released

> On Jun 1, 2020, at 11:51 AM, John Ralls wrote: > > The GnuCash development team announces GnuCash 3.903, the first testing > release for what will soon be GnuCash 4.0. A further note for developers: This release begins Feature Freeze, please commit only bug fix changes unti

[GNC] GnuCash 3.903 Released

The GnuCash development team announces GnuCash 3.903, the first testing release for what will soon be GnuCash 4.0. Changes Baseline requirements Operating Systems: • Linux: Ubuntu 18.04LTS • MacOS: 10.13 • Windows: 8.1 Software Dependencies: • C++ standard is

Re: [GNC] Using Quicken direct connect with USAA

Ah, that would explain why the Next button was disabled: You had no accounts to assign. So the issue would seem to be that the first account download didn't take, though the AQBanking dialog box indicated that it should have. Regards, John Ralls > On May 25, 2020, at 4:41 PM, Jon Sch

Re: [GNC] Using Quicken direct connect with USAA

When you first set up the User in the AQBanking Wizard did you check the Accounts tab after downloading the accounts the first time? Regards, John Ralls > On May 25, 2020, at 11:47 AM, Jon Schewe wrote: > > It just started working "magically". I tried manually cr

Re: [GNC] Using Quicken direct connect with USAA

Well, that's progress. The communication with USAA is clearly working. Maybe the flatpak sandbox isn't letting GnuCash see the results from AQBanking. Unfortunately I don't have time to investigate this further today. Regards, John Ralls > On May 25, 2020, at 9:29 AM, Jon Schewe wr

Re: [GNC] Using Quicken direct connect with USAA

ideal. Regards, John Ralls > On May 25, 2020, at 8:59 AM, Jon Schewe wrote: > > Alan, > > Thanks for the suggestion. I tried not setting any special settings and > make sure the SSL v3 is unchecked. Still no change. > > As far as security goes, this method for getting m

Re: [GNC] is there a transaction limit on converting xml to mysql

competence. Administering a database server is harder than it looks so we have a simple rule: In order to use one with GnuCash you must be a competent database admin for the server you choose or must have one working for you. Anything short of that puts your data at risk. Regards, John Ralls

Re: [GNC] What does OFX Direct Connect do?

to the bank website, log in, and get the download, then use File>Import>Import OFX/QFX to import it. Regards, John Ralls > On May 18, 2020, at 2:20 PM, Fran_3 wrote: > > Woops! No ill intent. I've seen the same response on other SIG's when someone > started a new thread that a grou

Re: [GNC] Use of Webkit-GTK in GNC

> On May 18, 2020, at 11:51 AM, Mark Sutton wrote: > > On Mon, May 18, 2020 at 10:48:12AM -0700, John Ralls wrote: >> Don't hijack threads, it's rude. Start a new one when you have a new >> question. >> >> OFX Direct Connect is just like importing an OFX or

Re: [GNC] What does OFX Direct Connect do?

Don't hijack threads, it's rude. Start a new one when you have a new question. OFX Direct Connect is just like importing an OFX or QFX file downloaded from your bank's website except that it will connect to the bank and get the OFX file for you. Regards, John Ralls > On May 18, 2020, at

Re: [GNC] wells fargo downloads

y with their products. GnuCash is able to work only with OFX Direct Connect. Regards, John Ralls ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinf

Re: [GNC] Reordering splits in a transaction

the changed value. > > But it sounds like this is just the way the cards have been dealt, so maybe > I'll file an enhancement request on the bug tracker and go on with my > life. Thanks! Change the amount to a variable in the SX template transaction, then the SLR dialog box will ask you

Re: [GNC] Is there a better way enter multi-currency split transaction?

Trading splits are ignored; they don't turn on the ---split transaction--- flag in the Transfer Account cell. I think what's causing grief is the no-value Asset:Stock:ABC split. Regards, John Ralls > On May 16, 2020, at 9:39 AM, Derek Atkins wrote: > > Arguably a transaction t

Re: [GNC] Is there a better way enter multi-currency split transaction?

ime)? Does GC create new Trading or Imbalance splits? Does it > alter the existing Trading splits? > It's not autofill, that finished when it filled in the transaction with a copy of the other one that matched. It's because if there's more than two splits GnuCash doesn't know how to appo

Re: [GNC] Stock "split" exchanging shares of different currencies?

F:DLR 200 10.00 2,000.00 When you commit the transaction GnuCash will add the trading account splits: Trading:FUND:DLR.U 200 10.00 2,000.00 Trading:FUND:DLR-200 10.00 2,000.00 Regards, John Ralls

Re: [GNC] Can't open app w MacOS Catalina

The problem is that GnuCash 2.6.x was built as 32-bit to support running on MacOSX 10.5 and 10.6. Apple removed 32-bit support from Catalina. You need to upgrade GnuCash to a 3.x release. Regards, John Ralls > On May 11, 2020, at 9:30 AM, Sean Perlmutter wrote: > > Thanks so much

Re: [GNC] Can't open app w MacOS Catalina

of GnuCash? What happens? Have you tried running it from Terminal? 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

Re: [GNC] Transaction Report Default Account

report configuration. If you decide that you really do need to customize the report you'll want to read https://wiki.gnucash.org/wiki/Custom_Reports. Regards, John Ralls ___ gnucash-user mailing list gnucash-user@gnucash.org To update your sub

Re: [GNC] Can't find GNC_CONFIG_HOME or USER_DATA_HOME on Linux

ut such a folder does not exist on Ubuntu 18.04. > Am I expected to create the GNC_CONFIG_HOME folder, and then create the > gtk-3.0.css inside it? No, GNC_CONFIG_HOME isn't a literal, it stands in for an OS-dependent location. See https://wiki.gnucash.org/wiki/Configuration_Locations#GNC

Re: [GNC] Adding Transactions From Another Program

les directly. Regards, John Ralls > On May 7, 2020, at 10:44 PM, Hal Vaughan wrote: > > > >> Begin forwarded message: >> >> From: Hal Vaughan >> Subject: Re: [GNC] Adding Transactions From Another Program >> Date: May 8, 2020 at 1:42:28 AM ED

Re: [GNC] Adding Transactions From Another Program

++ or Scheme programming skill, just some familiarity with build systems like Cmake. Yes, you will have to build a new GnuCash every time you want to upgrade, but once you have everything set up and working it's just running a single build script and waiting an hour or four. Regards, John Ralls

Re: [GNC] Gnucash logs

gt; https://wiki.gnucash.org/wiki/Release_Schedule > > but 4.11 is planned for 2022-12-18. > Feature freeze is the next beta release on 31 May, and you'll need to allow some time for your PR to get reviewed. Regards, John Ralls ___ gnucash-

Re: [GNC] Online banking breaks after upgrade to Fedora 32 - error on executing job. status: enqueued (1)

esn't work with OFX DirectConnect. https://bugzilla.redhat.com/show_bug.cgi?id=1830609 Regards, John Ralls ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org

Re: [GNC] How do I add stock trades?

account with a currency for its commodity is sometime referred to in the documentation as that child account's currency. Regards, John Ralls > On May 2, 2020, at 10:16 AM, Adrien Monteleone > wrote: > > Yes, I misspoke. Thank you. Technically it is denominated in itself. And

Re: [GNC] Working with dates in Postgresql DB

That's exactly what happened a few years ago to a guy from California who did some updates while visiting New Zealand. Regards, John Ralls > On May 1, 2020, at 3:16 PM, David H wrote: > > Might be a problem if you were in Perth on April 11 entering txns and then > back i

Re: [GNC] Working with dates in Postgresql DB

would put them in the wrong day. Regards, John Ralls > On Apr 30, 2020, at 10:24 PM, D. wrote: > > Thanks for the reply. I do understand the challenges this poses-- both from > the perspective of managing it on a daily basis, and from that of the > difficulty of changing the un

Re: [GNC] Adding Transactions From Another Program

Maybe one supplied by a drug manufacturer. Google tells me that Clozapine is an antipsychotic. Regards, John Ralls > On Apr 30, 2020, at 9:54 PM, D. via gnucash-user > wrote: > > "clozapine"="compile" > > Not sure what dictionary my machine is usi

Re: [GNC] Superannuation Co-Vid payment

No, but using the money to buy gold is. Regards, John Ralls > On Apr 30, 2020, at 9:31 PM, outlook_a062af9f159be...@outlook.com > wrote: > > The idea behind the Australian Govt. allowing early access to one’s > superannuation is economic stimulation NOT speculation. >

Re: [GNC] Working with dates in Postgresql DB

, John Ralls > On Apr 30, 2020, at 8:46 PM, D. wrote: > > John, > > I somewhat remember the discussion back in 2011 about the timestamp, but do > not recall all the details. Remind me why it is that GnuCash uses timestamps > in these date fields? All these steps and workar

Re: [GNC] Working with dates in Postgresql DB

major change and so far nobody's had the appetite to take it on. Regards, John Ralls > On Apr 30, 2020, at 1:06 PM, GWB wrote: > > Curious about this. So is the goal to show all times in UTC on > invoices along with local time? I tend to default most things to UTC > (includin

Re: [GNC] Working with dates in Postgresql DB

GnuCash stores all dates as UTC but displays them as local, applying the timezone rules for the date, not for today. So in EEST 2020-02-12 22:00:00 displays as 2020-02-13, 2020-06-12 21:00:00 displays as 2020-06-13, but 2020-02-21 21:00:00 displays as 2020-02-21. Regards, John Ralls > On

Re: [GNC] Working with dates in Postgresql DB

:59:00'; and the second to update the time as before. Regards, John Ralls > On Apr 30, 2020, at 11:07 AM, Finfort wrote: > > If post_date is 2017-12-31 22:00 or 23:00, it means (sometimes?) the real > date is 2018-01-01. At least in cases where I manually checked the invoices. &

Re: [GNC] Working with dates in Postgresql DB

to adjust it a bit. You might create a table with a DATETIME column and put a couple of rows in it to test against while you tweak. Make sure that GnuCash isn't connected to the database when you run that. Regards, John Ralls > On Apr 30, 2020, at 10:45 AM, Finfort wrote: > > How can I hel

Re: [GNC] Working with dates in Postgresql DB

Yeah, it's definitely a bug. I easily found the wrong code and I'll fix it for 3.903 and 3.11. The query actually accounts for only 543 of the 547 wrong times, so there's another error somewhere else. Regards, John Ralls > On Apr 30, 2020, at 10:27 AM, Finfort wrote: > > Als

Re: [GNC] Adding Transactions From Another Program

at https://github.com/Gnucash/gnucash-on-osx and https://github.com/Gnucash/gnucash-on-windows. The budget code is not wrapped for Python or Guile. Regards, John Ralls > On Apr 30, 2020, at 7:18 AM, Stu Perlman wrote: > > David, are the Python bindings not supported in Windows? I don'

Re: [GNC] Working with dates in Postgresql DB

on i.post_txn = t.guid group by t.post_date::TIME; Regards, John Ralls > On Apr 29, 2020, at 1:41 PM, Finfort wrote: > > But the program use business features like entering invoices or bills. > And we have this mess. > How we can manage that? > > > >> On

Re: [GNC] Working with dates in Postgresql DB

so `select distinct time(post_date) from transactions;` returns 10:59:00 07:00:00 If I say instead `select distinct time(post_date) from transactions where post_date > '2011-01-01';` I just get 10:59:00. But I don't use the business features, so if that's the problem my book won't show it.

Re: [GNC] Automatic Price Retrieval

> On Apr 29, 2020, at 9:54 AM, John Ralls wrote: > > > >> On Apr 29, 2020, at 3:08 AM, rsbrux via gnucash-user >> wrote: >> >> I would like GnuCah to retrieve prices automatically each time I open it. >> >> The documentation describe

Re: [GNC] Automatic Price Retrieval

r to open the Price Editor and click "Get Quotes". > > Is there a way to make price retrieval fully automatic? Use a cron job/scheduled task to run GnuCash with the --add-price-quotes=FILE argument, FILE being the path to your gnucash data file. Regards, John Ralls

Re: [GNC] Working with dates in Postgresql DB

midnight local, and which one is used *should* be determined by whether DST is in effect for the posted date in your locale. It seems that 40 transactions somehow used UK time instead of Cypress time. Did you enter all of the transactions from the GnuCash UI or did you import some of them? If you i

Re: [GNC] Working with dates in Postgresql DB

ght dates in 2200 UTC in winter and 2100 in summer. I didn't think that it forced anything to midnight UTC though. Might you have entered data while visiting somewhere with a UTC (aka GMT) timezone? Regards, John Ralls ___ gnucash-user mailing list

[GNC] GnuCash 3.902 released

The GnuCash development team announces GnuCash 3.902, the first testing release for what will soon be GnuCash 4.0. Changes Baseline requirements Operating Systems: • Linux: Ubuntu 18.04LTS • MacOS: 10.13 • Windows: 8.1 Software Dependencies: • C++ standard is

Re: [GNC] Net Worth Linechart report error

error messages and maybe a scheme stack trace with more details about the error. Regards, John Ralls ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/list

Re: [GNC] Rule based bank account transaction allocation

check the matches every time to make sure that it hasn't gone astray. 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-use

Re: [GNC] Trying to set up online banking

click next in the Online Banking Setup Assistant. If it doesn't work then no accounts are set up and you have to do so manually, and that's what the Accounts tab in the AQBanking setup dialog is for. Regards, John Ralls > On Apr 26, 2020, at 10:55 AM, jean laroche wrote: > > John, are you s

Re: [GNC] Trying to set up online banking

Probably because nobody had the same experience. If the automagic account download didn't work then you have to set up the accounts manually in the AQBanking setup window using the Accounts tab. Regards, John Ralls > On Apr 26, 2020, at 10:38 AM, jean laroche wrote: > > Oh absolu

Re: [GNC] How to install Gnucash 3.8 on Debian 10 "buster"?

you should use only Debian stable. The whole point of testing is to try out version upgrades to see what breaks. Regards, John Ralls > On Apr 26, 2020, at 7:33 AM, km22 wrote: > > As a follow up I have been running Gnucash 3.8 from the Debian testing > repo for a few months now. I

<    2   3   4   5   6   7   8   9   10   11   >