Re: [GNC] Configuring Securities Editor for a Tokyo Stock Exchange listed company.

[D. via gnucash-user]

I went to Yahoo! Finance and searched for your company there. Having located 
it, it was easy to see their notation on the page and in the URL.


 Original Message 
From: Richard Solomon 
Sent: Sun Dec 20 03:03:51 EST 2020
To: "D." 
Cc: David Reiser via gnucash-user 
Subject: Re: [GNC] Configuring Securities Editor for a Tokyo Stock Exchange 
listed company.

It works. Thanks! I I would never have guessed that in a million years.

On 12/20/2020 3:02 PM, D. wrote:
> Maybe try Yahoo Json with symbol 4922.T?
>
>
>  Original Message 
> From: Richard Solomon 
> Sent: Sun Dec 20 00:32:02 EST 2020
> To: "gnucash-user@gnucash.org" 
> Subject: [GNC] Configuring Securities Editor for a Tokyo Stock Exchange 
> listed company.
>
> I am trying to retrieve automatic price quotes for the Japan listed
> company Kose (ticker TYO: 4922). Within the Securities Editor I’ve set
> the Security Information “Type” to “TYO” and entered 4922 as the
> Symbol. I then click “Get Online Quotes” under Quote Source
> Information. But I’m not sure which Quote Source to select. Whatever I
> try, I fail to obtain a price quote within the Price Database. What
> could I be doing wrong? Are Tokyo Stock Prices not retrievable?
>
>
> Sent from [1]Mail for Windows 10
>
> References
>
> 1. https://go.microsoft.com/fwlink/?LinkId=550986
> ___
> 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] Configuring Securities Editor for a Tokyo Stock Exchange listed company.

[D. via gnucash-user]

Maybe try Yahoo Json with symbol 4922.T?


 Original Message 
From: Richard Solomon 
Sent: Sun Dec 20 00:32:02 EST 2020
To: "gnucash-user@gnucash.org" 
Subject: [GNC] Configuring Securities Editor for a Tokyo Stock Exchange listed 
company.

   I am trying to retrieve automatic price quotes for the Japan listed
   company Kose (ticker TYO: 4922). Within the Securities Editor I’ve set
   the Security Information “Type” to “TYO” and entered 4922 as the
   Symbol. I then click “Get Online Quotes” under Quote Source
   Information. But I’m not sure which Quote Source to select. Whatever I
   try, I fail to obtain a price quote within the Price Database. What
   could I be doing wrong? Are Tokyo Stock Prices not retrievable?


   Sent from [1]Mail for Windows 10

References

   1. https://go.microsoft.com/fwlink/?LinkId=550986
___
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] GnuCash Software Update

[D. via gnucash-user]

I will add to Adrien's note to say that there were particularly significant 
changes to the transaction report that have changed how that report manages the 
suppression or display of transaction detail as well as totals. If you've saved 
reports based on this, you will have to adjust them. 

Because of the many changes to the report system in recent versions, you most 
likely will have to revisit most of them to ensure compatibility. I'd expect 
the same for any of your custom-coded reports as well. 

David T. 


 Original Message 
From: Adrien Monteleone 
Sent: Fri Dec 11 07:26:44 EST 2020
To: gnucash-u...@lists.gnucash.org
Subject: Re: [GNC] GnuCash Software Update

You're 2 major versions behind. There have been significant changes.

Is it possible to save everything will little effort? Maybe, that 
depends on your specific customizations.

What do you mean by 'customized reports'? Are these just saved report 
configurations, as within GnuCash, or custom *coded* reports? (the 
latter will likely require tweaking their code to continue working) For 
'Saved Configurations' most should translate just fine, but there were 
some issues in either the 3.x or 4.x jump that required some fidgeting 
with their options to get them to work again. (doable, but not effortless)

The move to 3.x will also change some storage locations, especially for 
things like custom coded reports, and user configurations. (style sheets 
included) These should be preserved just fine and moved to their new 
homes by the upgrade, but there we some hiccups for some users. (for 
Windows users if I'm not mistaken)

The Wiki has more info on upgrading procedures and caveats. It also 
contains the storage locations before and after version 3.x. (so you'll 
know where things are now, where they should end up, and then if things 
don't go right, how to fix that)

Maybe someone else can help with specifics if they've encountered issues 
with Report Configurations or Style Sheets.

Otherwise, you'll first want to update to 2.6.21 which was the last of 
the 2.6 series.

Then update to 3.11, the last of the 3.x series. On first opening your 
file(s) with this version, run Actions > Check & Repair > Check & Repair 
All. Then look over everything carefully for any breakages. Do this for 
each data file or 'book' you keep in GnuCash.

If all is well (solve all issues 1st!) then proceed to 4.2 which is the 
current release. (4.3 due out just before end of year) Again, run the 
Actions > Check & Repair > Check & Repair All for each file.


Regards,
Adrien

On 12/10/20 5:09 PM, Don Earnhardt wrote:
> I have seen information about overwriting the current version of GnuCash
> (version 2.6.3) on my Windows PC with the latest version.  However, I am
> extremely nervous about doing so. I can back up the data, so that doesn't
> bother me. I have configured my software with many customized reports and
> style sheets and I would be very unhappy to lose any of them.  Is there
> ANYTHING that I might lose by installing a new version over my old one?  I
> have been using this software quite happily (with one exception) since the
> beginning of 2014 and I don't want to have to re-create anything that I have
> customized during that time.


___
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] Account report

[D. via gnucash-user]

View->Filter By

The account report shows all the visible transactions in the register. So 
filter by the date range. 


 Original Message 
From: David Long 
Sent: Tue Dec 08 16:39:32 EST 2020
To: "gnucash-user@gnucash.org" 
Subject: [GNC] Account report

Hi, how can I select just the last few months for an "Account Report". I am 
getting the whole history of the account from the first ever transaction?  I 
can use the "Transaction Report", instead and select which account and periods 
I want, but then I do not see the opening and closing balance.

I am using the accounts to control the member's accounts of a sailing club and 
wanted to use this report to produce member's statements.

Thanks

David
___
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] Possible Suggestion: Give transactions a default 'Jump to' target account

[D. via gnucash-user]

David, 

It's not a bad idea, but it sounds like a lot of work. When I do use this 
feature, I tend to open the transaction with the Split button, click the 
appropriate entry, and then click Jump. That's three mouse clicks; your fix 
would involve two. Would there be enough UI improvement to pursue this? I don't 
know...

David T. 


 Original Message 
From: David Carlson 
Sent: Tue Dec 08 11:18:28 EST 2020
To: Gnucash Users 
Subject: [GNC] Possible Suggestion: Give transactions a default 'Jump to' 
target account

I am considering proposing an enhancement to GnuCash to provide a default
'Jump to' target action. If there are only two split lines in the
transaction, it would be the transfer account.  In complex transactions
there would be a pop-up giving a list of the accounts in the transaction
and asking which account to 'Jump to'.  This action would be overridden by
the current 'Jump to' destination when the focus is in a split line.

The primary purpose of this proposal would be to define a 'Jump to'
destination that is invocable from the base fields of the transaction which
are often the only fields visible when the account register display is set
to 'Basic Ledger'.

Before I make the proposal, I would like comments on whether this is worth
pursuing.

-- 
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
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] bulk operations?

[D. via gnucash-user]

Of course, one can edit the data using SQL (for a file stored in one of the 
database formats) or even a text editor (for an uncompressed XML file). Many do 
so.  But bear in mind that any edits made outside the Gnucash API may affect 
the reliability of your data set, or even corrupt the data. 

Personally, I've never found that these solutions were worth the time it took 
to set up. By the time I had, I could have just gone through and changed the 
entries manually. 

David T. 

[For the problem of varying descriptions that the OP mentioned, for example, 
I've found it quite simple to put a register in Basic mode, sort by 
Description, highlight my preferred version, copy it, and then paste it into 
each transaction by turn, using the down arrow to go to the next transaction. 
This is very rapid, since it immediately highlights the next entry for pasting.]


 Original Message 
From: flywire 
Sent: Mon Dec 07 18:21:01 EST 2020
To: Gnucash Users 
Subject: [GNC] bulk operations?

>* If it's not possible through the GUI, how about via issuing SQL
*>* statements to a database backend?*

*Seems reasonable.*
___
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] Error with Asset Chart report

[D. via gnucash-user]

Further to this: you asked whether the problem occurs with level All. 
Interestingly, this option does result in the error occurring again. 

However, when All is selected, the default report triggers the error with a 
different option number and a different number of iterations. This time, the 
erroneous value is indicated as '11', and it only occurs once. When 6 is 
selected, increasing the number of slices changes the number of times the error 
is iterated, although there isn't an apparent correlation between the slices 
shown and the number of errors. In other words, when I increase the number of 
slices by one (from the default 8 to 9), the added slice in the display is not 
at the seventh level, but the error is now repeated twice. The iterations do 
not change with the All setting; they remain at 1 regardless of the number of 
slices. 

I've looked at this more extensively now. I tried other "Slice-based" reports, 
under the assumption that their logic would cause similar results. I include my 
observed results below. I list the setting, followed by the error iteration in 
parentheses when the default settings are used, with only the depth value 
changed. In all cases, the All error was for option 11, and the 6 error was for 
option 7.

Asset Chart (resulting tab is titled "Assets Over Time"): All (1)   6 (6)
Asset Piechart (resulting tab is titled "Assets"): All (0)   6 (5)
Liability Chart (resulting tab is titled "Liabilities Over Time"): All (1)    6 
(2)
Liability Piechart (resulting tab is titled "Liabilities"): All (1)  6 (2)

It is interesting that the Asset Piechart didn't trigger any errors with the 
All setting. That was the only clean version. 

I will note that when I initially ran the Liability reports, I received no 
errors. This was because I didn't have any liabilities accounts at level 7. To 
verify this, I added dummy levels to one of the liabilities to reach level 7, 
and the errors started up. Further, I am confident that the number of 
iterations for the error is directly related to the number of level 6 accounts 
with level 7 children. When I add a parallel set of dummy accounts down to 
level 7 on another branch in Liabilities, the error iteration goes up by one.

The mere presence of the level 7 account triggers errors. It didn't matter 
whether the dummy accounts had transactions in them, or whether the account was 
displayed in the resulting report. However, if the level 7 accounts are all 
empty, the error only triggers once. Adding a transaction to one of the dummy 
accounts increases the iteration to two, and adding to the other dummy also 
increases the iteration.  This suggests that there is some relation between the 
number of seventh level slices to be displayed (as opposed to simply existing), 
but a base problem with that level on principle. 

David


 Original Message 
From: Adrien Monteleone 
Sent: Sun Dec 06 15:22:14 EST 2020
To: gnucash-u...@lists.gnucash.org
Subject: Re: [GNC] Error with Asset Chart report

I have about a dozen or more level-6 asset accounts. I don't have 
anything greater than level-6.

Can you reproduce if you try level-All? (there'd still be a bug in the 
level-6 option of course)

Regards,
Adrien

On 12/6/20 2:17 PM, D. via gnucash-user wrote:
> Adrien,
> 
> Does your CoA have accounts deep enough to trigger level 6? I can trigger the 
> error consistently whenever I select a set of accounts that includes accounts 
> below the sixth, and then make it go away simply by selecting accounts that 
> don't range below that depth.

___
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] Error with Asset Chart report

[D. via gnucash-user]

If I had to guess, the observed phenomena here result when the code is required 
to probe below this setting, so if you don't get to the seventh circle of 
accounting hell, you won't see it. What has me confused is that the setting is 
clearly, obviously available to me-- even on the stock Asset Chart report. And 
if I can select it, I shouldn't receive an error choosing it. (Never mind how 
remarkably cryptic this message is!)

As I mentioned last year, I wonder whether Windows is using a 1-7 list, while 
*nix platforms (OsX is one of those) count them as 0-6. I can't imagine why 
else this error would crop up. It would be nice if someone else on Windows 
could try to replicate the error. 


 Original Message 
From: Adrien Monteleone 
Sent: Sun Dec 06 15:22:14 EST 2020
To: gnucash-u...@lists.gnucash.org
Subject: Re: [GNC] Error with Asset Chart report

I have about a dozen or more level-6 asset accounts. I don't have 
anything greater than level-6.

Can you reproduce if you try level-All? (there'd still be a bug in the 
level-6 option of course)

Regards,
Adrien

On 12/6/20 2:17 PM, D. via gnucash-user wrote:
> Adrien,
> 
> Does your CoA have accounts deep enough to trigger level 6? I can trigger the 
> error consistently whenever I select a set of accounts that includes accounts 
> below the sixth, and then make it go away simply by selecting accounts that 
> don't range below that depth.

___
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] Error with Asset Chart report

[D. via gnucash-user]

Adrien, 

Does your CoA have accounts deep enough to trigger level 6? I can trigger the 
error consistently whenever I select a set of accounts that includes accounts 
below the sixth, and then make it go away simply by selecting accounts that 
don't range below that depth. 

David


 Original Message 
From: Adrien Monteleone 
Sent: Sun Dec 06 14:00:54 EST 2020
To: gnucash-u...@lists.gnucash.org
Subject: Re: [GNC] Error with Asset Chart report

Still using 4.1 here (on MacOS), but sorry to say, I can't repeat the 
error. The Asset Chart works for me just fine with any accounts selected 
(all Assets are by default) and with any level selected.

Regards,
Adrien

On 12/5/20 12:10 PM, David T. via gnucash-user wrote:
> Hello,
> 
> I am on Windows 10, using Version: 4.2
> Build ID: git 4.2-213-g562b4be22+(2020-11-21)
> 
> Back in June 2019 
> (https://lists.gnucash.org/pipermail/gnucash-user/2019-June/085636.html), I 
> reported a problem with an odd error in a saved report. After some back 
> and forth, I don't believe that any resolution occurred, and I have 
> re-encountered the error.
> 
> This time, I am using the stock Asset Chart report, and again I 
> encounter the nonsensical error repeatedly:
> 
> "This report was saved using a later version of GnuCash. One of the 
> newer multichoice options '7' is not available, fallback to the option 
> '2'."
> 
> Testing reveals that this error is referring to the fact that I am 
> selecting the "Show Accounts until level" to use the provided value of 
> '6' (which is the seventh option in the list, which includes All and 
> 1-6). It pops up numerous times when I run the report, presumably 
> because it iterates through the accounts and barfs each time it gets to 
> a sixth-level account.
> 
> This error is nonsensical because:
> 
> 1) I am invoking the report from the Report menu for the first time in 
> THIS version of GnuCash; there are no saved versions of the report
> 
> 2) There are no newer versions of GnuCash that I have run on my machine, 
> and
> 
> 2) I am SELECTING THE VALUE THAT IS PROVIDED IN THE REPORT OPTIONS.
> 
> This error can easily be replicated; just open the base GnuCash Asset 
> Chart (Report->Assets & Liabilities->Asset Chart), select some accounts, 
> and choose '6' in the "Show Accounts until level" drop down. The error 
> will then trigger.
> 
> If there is a simple hack I can apply to remove this error, I'd 
> appreciate knowing it. As it stands, the result is annoying, and the 
> fact that it is embedded in the GnuCash-supplied report is problematic.
> 
> David T.

___
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] entry point error after recent automatic windows 10 update

[D. via gnucash-user]

Laurel,

I'm sorry you're having these troubles. Many windows users (myself included) 
are successfully using gnucash on windows. A search online showed several very 
old email threads with this error; however, they were from users of a 
repackaged version of Gnucash from a group called portableapps.

Is it at all possible that yoga are trying to use a portable version of 
Gnucash? 

David T. 


 Original Message 
From: nvsoar 
Sent: Wed Nov 25 22:47:47 EST 2020
To: gnucash-user@gnucash.org
Subject: Re: [GNC] entry point error after recent automatic windows 10 update

On 11/25/20 19:19, David Cousens wrote:
> Laurel,
>
> Uninstalling and reinstalling the Windows 10 system should be a last resort.
>
> *Before you do that, at least make a copy of all the data files in your user
> directory either on a USB stick or a copy to another computer*. *Don't let a
> technician reinstall it without doing this first*. Your user files will be
> stored in C:/Users// where you will need to substitute your
> actual user name on the computer for the placeholder  in the
> above path.  Copy all files in that location onto a USB stick or other
> medium before attempting a reinstall of Windows. You will then be able to
> restore your user data files from the USB stick if you do have to do a
> Windows reinstall and reinstall all programs.  That should prevent any loss
> of data stored in the GNuCash files.
>
> GnuCash 4.2 should not be looking for that file in that location which may
> suggest that the initial install of GC 4.2 has perhaps not completely
> removed all files from a previous version (which it should do during the
> install procedure) and that an outdated dll file is being accessed and in
> turn is looking for a routine in a dll which no longer exists.  AFAIK there
> have been some rewrites of the GnuCash library files recently which could
> lead to this.
>
> You could also try making sure any subsequent Windows updates are installed
> and that Windows 10 itself is fully up to date.
>
> Try manually removing GnuCash using the Control Panel  programs tab before
> reinstalling GnuCash from a fresh download of 4.2. If old files have not
> been removed properly this may unload them.
>
> If that doesn't work I would then try reinstalling the version you had
> previously and see if it works  Doing a manual uninstall of the previous
> version  from the control panel after a reinstall of the old version should
> then get rid of any previous program files which may have been left in
> place.  Then follow that by reinstalling GC 4.2.
>
> David
>
>
>
> -
> David Cousens
> --
> Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
snip - I support the above approach suggested by David Cousens. FWIW - I 
use the Revo Uninstaller because I found that the Windows uninstaller 
still leaves stuff hanging around.  As for file finding I use an 
application called Everything that indexes all windows files - much 
faster than Windows search.  (Links are 
https://www.revouninstaller.com/  and https://www.voidtools.com/) _nvsoar
___
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] Accounts for Tracking Dividends

[D. via gnucash-user]

I'll chime in to say that I started out using separate dividend accounts for 
each stock, but maintenance got to be a royal pain. I backtracked, and now I 
have umbrella dividend accounts for each brokerage account. So, 

Income:Dividends:Taxable:BrokerAccountA
Income:Dividends:Taxable:BrokerAccountB
Income:Dividends:Untaxed:BrokerAccountC
Income:Dividends:Untaxed:BrokerAccountD

This way, I can quickly match my records against the tax statement at the end 
of the year. 

For gains, I add another layer to separate long term and short term gains in 
the taxable accounts, since I need to distinguish them for tax purposes. You 
may want to separate Roth transactions from others-- again, for tax purposes. 

David T. 

Note: I am neither an accountant nor an expert. 


 Original Message 
From: John Ralls 
Sent: Tue Nov 24 13:21:45 EST 2020
To: Larry Long 
Cc: Gnucash Users 
Subject: Re: [GNC] Accounts for Tracking Dividends

Larry,

You're welcome, but please remember to copy the list on all replies.

Regards,
John Ralls

> On Nov 24, 2020, at 9:40 AM, Larry Long  wrote:
> 
> Thanks, John!
> 
> Until now, I've been using GnuCash to track only cash, checking, loans and 
> credit card accounts.
> Digging into tracking stock, dividends and other transactions is another 
> uphill learning curve for me.
> 
> 
> Larry
> 
> 
> 
> On Tuesday, November 24, 2020, 12:23:40 PM EST, John Ralls 
>  wrote:
> 
> 
> 
> 
> > On Nov 24, 2020, at 9:06 AM, Larry Long  wrote:
> > 
> > If you do automatic online retrieval of stock/dividend transactions, are 
> > the dividend accounts in GnuCash required to be structured in a specific 
> > manner?
> > 
> > In the “GnuCash Tutorial and Concepts Guide”, paragraph 9.4.1SetupAccounts 
> > for Stocks and Mutual Funds, thereis a Note which states:
> > “Ifyou want to track income (dividends/interest/capital gains) on 
> > aper-stock or fund basis, you will need to create 
> > anIncome:Dividends:STOCKSYMBOL, Income:Cap Gain 
> > (Long):STOCKSYMBOL,Income:Cap Gain (Short):STOCKSYMBOL and 
> > Income:Interest:STOCKSYMBOLaccount for each stock you own that pays 
> > dividends or interest.”
> > Isthis sequence of dividend account levels a hard-coded requirement 
> > forretrieving dividend transaction information automatically...oris it 
> > merely a recommendation toillustrate how you can track dividends?
> > 
> > I have someidentical stocks which are held in different accounts. For 
> > example,I hold some of the same stocks in my Traditional IRA account, my 
> > RothIRA account and also in my non-IRA brokerage account. Thus, I 
> > oftenreceive dividends from a given stock in all three accounts.
> > 
> > If I set up accountsfollowing the above example and connect to the 
> > brokerage firm toretrieve transaction information in the background, it 
> > appears thatGnuCash would record all of my IRA and non-IRA dividends into 
> > asingle account.
> > 
> > On the other hand,if I need to record dividend transactions manually, I 
> > think I wouldhave have my accounts something like this:
> > 
> >  -  Income:Dividends:Brokerage:AMZN
> >  -  Income:Dividends:Trad_IRA:AMZN
> >  -  Income:Dividends:Roth_IRA:AMZN
> > 
> > This would allow meto keep track of taxable and non-taxable dividends 
> > separately.
> > 
> > Thanks in advance for clarification on this aspect!
> 
> 
> You need only follow a particular way of recording dividends if you use the 
> Advanced Portfolio Report and that's what the guidance in the T is for. 
> Otherwise any way that makes sense to you is fine.
> 
> If the imported transaction descriptions indicate in some way which stock 
> account sourced the dividend then you'll be able to train the import matcher 
> to send them to the right account. If not and you use some other way (perhaps 
> by knowing that you have different numbers of AMZN shares in each account and 
> so being able to distinguish them by the amount of the dividend) then you'll 
> have to reassign them manually either in the matcher or by changing the 
> transfer account from the register.
> 
> 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] Wrong starting balance

[D. via gnucash-user]

https://bugs.gnucash.org/show_bug.cgi?id=710902 already covers this issue 
exactly. 


 Original Message 
From: David Carlson 
Sent: Sun Nov 22 00:51:01 EST 2020
To: GnuCash List 
Cc: Gnucash Users 
Subject: Re: [GNC] Wrong starting balance

Liz

I would suggest copying that entire message into a bug report.  Especially
be sure to include that you had said "Do not tell me again this session
that I am changing a
reconciled transaction" as that may be the key to the puzzle. The
developers can figure out which details don't matter and which are
important.  If they cannot reproduce the issue they will ask for more
information, so it speeds things up to be very detailed the first time.
Also include that the transactions were spawned from scheduled
transactions, in case that makes a difference, even though they were not
reconciled until some time later.  If you remember which account register
you were working in (X, Y, Z, Tax or perhaps General Journal) when you made
the changes, that may also help.

After You have filed the bug report, if you think others may wish to follow
the progress, you can report the bug number in this list. I suspect that
you already know the drill!



On Sat, Nov 21, 2020 at 11:16 PM Liz  wrote:

> On Sat, 21 Nov 2020 17:30:08 -0600
> David Carlson  wrote:
>
> > Liz:
> >
> > If I understand correctly, at some point intentionally or
> > unintentionally you were able to move a previously reconciled
> > transaction from one account to a different account without changing
> > the reconciliation status.  I just tried that in release 3.8 and I
> > received a warning that the reconciliation will be cancelled.
> >
> > Do you remember which release of GnuCash you were using at that time?
> >  I cannot test release 4.2 so I cannot check whether a new bug report
> > needs to be filed.
> >
> > I believe that user action is equivalent to my previous description of
> > changing the account GUID of a given split line which has a
> > reconciliation status of 'Y'.  If not, someone please enlighten me.
>
>
> Version: 4.2
> Build ID: 4.2+(2020-09-26)
> Finance::Quote: 1.47
>
> On Debian
>
> I was dealing with an intermediate account I made to help me follow a
> credit I have with the tax people.
>
> So I was moving payments made to the tax authority into an intermediate
> account, type Liability. They were moved from an Asset account, type
> Bank.
> They had been reconciled.
>
> So Tax has to be paid, counted in account X
> The liability to pay the tax is counted in account Y
> The payments are still made to the tax people from account Z
>
> Previously the system counted the tax in X and paid it from Y
> so instead of X <> Z
> the books now go X <> Y and Y <> Z
>
> To get the accounting correct I have had to move reconciled
> transactions from Z to Y (they were scheduled transactions).
> The change was made from X, a non-reconciled account
> I said "Do not tell me again this session that I am changing a
> reconciled transaction"
>
> When the transactions were reviewed in Y they remained reconciled, and
> the amounts were reconciled in Y, which was inappropriate.
>
> How much of this needs to go in the bug report?
>
> Liz
> ___
> 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.
>


-- 
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
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 Manually Match transactions

[D. via gnucash-user]

Option A is extensively documented, if you understand that once the first 
import is successfully completed with full assignment of destination accounts, 
then the second import is simply that: another import. Presumably, if you 
assign destination accounts upon import, then you can avoid most duplication. 

The Guide at 3.1.2 and Help at 6.16 cover these issues in some detail. 

David T.


 Original Message 
From: Griff 
Sent: Sat Nov 21 13:17:37 EST 2020
To: David Carlson 
Cc: GnuCash List , Adrien Monteleone 

Subject: Re: [GNC] How to Manually Match transactions

 Have some good news and an even better solution that can be added to the
FAQ or How-to.

2 Options that work for associating/matching a transaction that does not
import match:

1 - Import from Account A and assign to Account B at import or before
importing Account B. Then when importing Account B, the two transactions
will be matched to each other. This is the proactive correct solution. So
obvious.

2 - In the case import QFX from Account A and match is not made before
hand, then importing  Account B won't find a match. Fix is to assign either
Account A or Account B transaction to the other account respectively. Then
delete the duplicate transaction, lets say, account B has two entries
because Account A was assigned to Account B as the destination. Now,
re-import Account  B and the import matcher will now match those two
transactions, success.

For both options, use U+C. The match happened with a C but using U+C will
fix the transaction where the 2 dates don't match.

Again, option 1 is what you want and option 2 is a good recovery to fix the
issue.

Thanks again to everyone for your help.

On 11/19/2020 9:58 PM, Griff wrote:

Thanks for the great suggestions everyone.

I tried the idea of changing from A to C during import and then looking for
a match but no matches were present to select from in the matcher dialog. I
even manually changed the date of the transaction in account A to match the
date of account B before importing, then did the import and the matcher
still did not find anything to offer up.

Too bad GnuCash does not allow selecting the match from the full list of
transactions or matching at other times besides import. Hopefully this was
a special case match issue and the norm will be to find a match for the
transfers like your example of PayPal and the multi-day float.

Otherwise, I can manually fix the issue or use Frank's short-term float
account "money in transfer" to match the transactions.

I have the default import setting of bayesian and 1, 3, 6 for thresholds, I
tried changing the match display threshold to 0 but no impact.

As a side note, I tested the QIF file for the same transactions instead to
see if that worked better and had the strange issue of GnuCash hanging.
Tried it several times with the same issue.

David places like PayPal/Venmo still enjoy the float on their end and offer
a rapid no-float option for a fee, win-win for them.

On Thu, Nov 19, 2020 at 5:54 PM David Carlson 
wrote:

> In the olden days some people would even try to take advantage of having a
> lot of funds in "float" between various bank accounts.  來
>
> On Thu, Nov 19, 2020, 6:12 PM Adrien Monteleone <
> adrien.montele...@lusfiber.net> wrote:
>
> > Griff,
> >
> > Sorry, I misunderstood the original post. I thought it was a single
> > import, not two separate ones.
> >
> > David's suggestions should be the way to go in your case.
> >
> > As for retaining the second date, (presumably from the Credit Card
> > account) see my reply to Frank.
> >
> > Regards,
> > Adrien
> >
> > On 11/19/20 3:18 PM, Griff wrote:
> > > Thanks Adrien and Stephen.
> > >
> > > Both your solutions are good work arounds, sounds like the short answer
> > is
> > > it can't be done the nice way preserving data. The result will be to
> > > manually delete one of the import transactions and the new duplicate
> > > created won't have the date that matches one of the 2 banks for
> > correctness
> > > purposes.
> > >
> > > To your suggestion of importing it all at once, that is not possible as
> > one
> > > QFX file is from the credit card company download and the other QFX is
> > from
> > > the different bank company's download. They will be two files.
> > >
> > > This is unfortunate as the matcher is only run on QIF import and not
> > > OFX/QFX import.
> > > Should I be getting the data from the banks in QIF instead, does that
> > work
> > > better then OFX/QFX for GnuCash import?
> >
> >
> > ___
> > 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] Wrong starting balance

[D. via gnucash-user]

Not sure what the bug would be. You reconciled the transaction and then moved 
it. Should gnucash de-reconcile the entry? Personally, I don't really know; 
arguments could be made either way. 

One point to realize (and that others hinted at) is that the starting balance 
for the reconcile window is calculated by tallying *every* entry that is marked 
as reconciled-- regardless of the date of that entry. So, if you had an account 
opened in 2014, added reconciled transactions for 2020, and then asked to 
reconcile January 2014, the starting balance would include the reconciled 2020 
transactions.  This is strange, but known, behavior of the reconcile functions 
in GnuCash. 

David T. 


 Original Message 
From: Liz 
Sent: Fri Nov 20 21:23:18 EST 2020
To: gnucash-user@gnucash.org
Subject: Re: [GNC] Wrong starting balance

On Fri, 20 Nov 2020 17:58:38 -0800
"Stephen M. Butler"  wrote:

> Try to reconcile another account that has never been reconciled.  If 
> that comes up with a non-zero number then create a new account and 
> attempt to reconcile with no entries.  If that comes up with a
> non-zero amount then you have found a bug.
> 
> What I'm wondering is if there are no entries to add up the module
> might not be handling the results correctly.


I tested that possibility, and it was negative. Fortunately I found
where the problem was, and it is related to the user.

I did not expect when I moved transactions from the bank account to a
holding account that the reconcile flag for the bank account would
remain.

It may be a bug.

Liz
___
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] Using GnuCash with Dropbox

[D. via gnucash-user]

I imagine File->Save As might work. 


 Original Message 
From: davidvernonl...@gmail.com
Sent: Thu Nov 19 19:15:45 EST 2020
To: gnucash-user@gnucash.org
Subject: [GNC] Using GnuCash with Dropbox

My Gnucash is saving to C:\Users\my username\Documents.

 

However, Dropbox is synchronising with folders on my D Drive, which is where
I would like my Gnucash files to go.

Probably I should have thought of that in the setup process, but I didn't.

 

How can I now make that happen? I have setup a special sub  folder on my D
Drive under Dropbox folder in readiness. 

 

David

___
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] Strange behaviour

[D. via gnucash-user]

Tony, 

No need to dig much; there's an outstanding bug 
(https://bugs.gnucash.org/show_bug.cgi?id=797959) that addresses the issue at 
length. That bug is supposed to be fixed in the upcoming release. 

HTH,
David T.


 Original Message 
From: Tony Vanson 
Sent: Tue Nov 17 01:18:34 EST 2020
To: py...@cox.net
Cc: Gnucash Users 
Subject: Re: [GNC] Strange behaviour

Seems that the comma separator is the culprit here if it is left in when
committing the altered amount. In addition I find that if I use the
backspace key to try to alter a number before committing, GnuCash shuts
down immediately, however using the backspace to delete the comma separator
works fine.
Bit more digging to do.


Virus-free.
www.avast.com

<#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>

On Tue, Nov 17, 2020 at 10:47 AM  wrote:

> Tony -- just curious -- this seems very similar to the thousand separator
> issue of entries over $1,000 when you include the thousands separator
> (comma).  If you enter an entry that includes the comma and go to change
> the
> entry, it seems GNUCASH crashes -- but not entering the comma the issue
> does
> not happen.  Would be interested if your behavior is happening on items
> that
> are less than $1,000 (i.e., or do not include the separator).
>
> There is a reported issue with the separator issue that I think is already
> addressed for the next build.
>
> Ken
>
>
> -Original Message-
> From: gnucash-user  On
> Behalf Of Tony Vanson
> Sent: Monday, November 16, 2020 7:07 PM
> To: John Ralls 
> Cc: Gnucash Users 
> Subject: Re: [GNC] Strange behaviour
>
> Yes, same problem here on Windows 10 Home with Gnucash 4.2.
> I used to just copy and paste a previous entry, alter the amount as
> required, and then commit. However this now causes CNC to completely shut
> down, but I find if I commit the wrong amount and then alter it, things are
> fine.
> Regards
>
> <
> https://www.avast.com/sig-email?utm_medium=email_source=link_campai
> gn=sig-email_content=webmail
> 
> >
> Virus-free.
> www.avast.com
> <
> https://www.avast.com/sig-email?utm_medium=email_source=link_campai
> gn=sig-email_content=webmail
> 
> >
> <#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>
>
> On Tue, Nov 17, 2020 at 12:13 AM John Ralls  wrote:
>
> >
> >
> > > On Nov 16, 2020, at 7:46 AM, Mahon Finbar 
> wrote:
> > >
> > > Sorry, I think I posted this already in the wrong address.
> > >
> > > Hi,
> > >
> > > Just now I was making an entry in an account I use regularly, one of
> > > my
> > bank accounts. and was entering a salary cheque which required an
> > alteration of one figure.
> > >
> > > It worked fine, date, description, etc., until I tried to change the
> > digit on the figure. It put the cursor behind the digit but when I
> > tried to change it the blue circle appeared and gnucash closed,
> completely.
> > >
> > > I relaunched, having to do 'open anyway' at the lock question, and
> > opened the account, which was closed. The entry I was trying to make
> > was not there, although the previous entry was. I tried to enter the
> > salary entry, tried to change the digit and the same thing happened ,
> > blue circle, closed.
> > >
> > > Any ideas?
> >
> > It's probably https://bugs.gnucash.org/show_bug.cgi?id=797959.
> >
> > 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.
> >
>
>
> --
> *Tony Vanson*
>
> *The older I get,*
> *the better I was*
> ___
> 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.
>
>

-- 
*Tony Vanson*

*The older I get,*
*the better I was*
___
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, 

Re: [GNC] Button1 & Button2

[D. via gnucash-user]

I was under the impression that "Button1" refers to the primary button, and 
"Button2" refers to the secondary one. Those were typically called the left 
mouse and right mouse buttons, respectively, but with customizable hardware, 
directional references were discouraged. But, I'm not any sort of expert. 


 Original Message 
From: Adrien Monteleone 
Sent: Thu Oct 22 12:46:08 EDT 2020
To: gnucash-u...@lists.gnucash.org
Subject: Re: [GNC] Button1 & Button2

Looks like a documentation error where a translatable string 
'placeholder' was literally placed in the text rather than the proper 
language-specific label for the buttons.

A bug should probably be filed for this.

Regards,
Adrien

On 10/22/20 11:05 AM, Paul Konnersman wrote:
> On pages 75 & 76 (87 & 88 of the printer dialog) of the Help Manual there
> are references to "Button1" and "Button.2" I have not been able to
> identify either of these 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
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] Start up with security prices updated during launch

[D. via gnucash-user]

Further to your last statement, the syntax should I believe be: 

gnucash-cli.exe --add-price-quotes=

But I haven't used this feature in a long time, myself. 


 Original Message 
From: "D. via gnucash-user" 
Sent: Mon Oct 19 16:44:05 EDT 2020
To: Kalpesh Patel 
Cc: Fran_3 via gnucash-user 
Subject: Re: [GNC] Start up with security prices updated during launch

Not really. See 
https://lists.gnucash.org/pipermail/gnucash-user/2017-March/069738.html for a 
recent discussion, and https://bugs.gnucash.org/show_bug.cgi?id=628734 for an 
older one.

You can get behavior like this by writing a simple batch file that updates 
process before opening your data file in the GUI. 

David T 


 Original Message 
From: Kalpesh Patel 
Sent: Mon Oct 19 14:10:56 EDT 2020
To: gnucash-user@gnucash.org
Subject: [GNC] Start up with security prices updated during launch

Hi GNUCash User group -

 

Is there a way to launch GNUCash in Windows 10 such that it also updated
security prices from online sources for securities that are configured
before displaying the scheduled transactions? I am using version 4.2 on
Windows at the moment.

 

I don't believe it's:

 

gnucash-cli.exe --quotes get file://C:/path/to/file.gnucash

 

 

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.

___
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] Start up with security prices updated during launch

[D. via gnucash-user]

Not really. See 
https://lists.gnucash.org/pipermail/gnucash-user/2017-March/069738.html for a 
recent discussion, and https://bugs.gnucash.org/show_bug.cgi?id=628734 for an 
older one.

You can get behavior like this by writing a simple batch file that updates 
process before opening your data file in the GUI. 

David T 


 Original Message 
From: Kalpesh Patel 
Sent: Mon Oct 19 14:10:56 EDT 2020
To: gnucash-user@gnucash.org
Subject: [GNC] Start up with security prices updated during launch

Hi GNUCash User group -

 

Is there a way to launch GNUCash in Windows 10 such that it also updated
security prices from online sources for securities that are configured
before displaying the scheduled transactions? I am using version 4.2 on
Windows at the moment.

 

I don't believe it's:

 

gnucash-cli.exe --quotes get file://C:/path/to/file.gnucash

 

 

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] Account view question

[D. via gnucash-user]

David, 

I thought about using reports as well, but the OP clearly mentions a "delta" 
between days, suggesting that they may be looking for data entered out of 
sequence. Such data wouldn't be accurately displayed in a time slice report. 

To truly get a delta, I imagine one would have to process the log files 
somehow, or use the transaction entered data to see this set. I'm not sure 
whether there are any reports that allow a user to filter on the transaction 
entry date field. 

David T.


 Original Message 
From: David Carlson 
Sent: Wed Oct 07 23:37:58 EDT 2020
To: David Cousens 
Cc: gnucash-user@gnucash.org
Subject: Re: [GNC] Account view question

The Account view which we sometimes call the chart of accounts is simply a
list of all the accounts in the current book or data file.  It happens to
show the current balance of each account in it's assigned currency or
security.

To see additional information such as account balances on different dates
it is necessary to use a report that is configured to show that
information.   I believe there is a report with a name similar to account
balances over time that can be configured to show the information that you
requested.


On Wed, Oct 7, 2020, 8:56 PM David Cousens  wrote:

> There is no feature as you describe it but with the Account Register tab
> displayed you can use View-> Filter By in the menu to restrict the date
> range displayed or only show data from a specific number of days.
>
>
>
>
> -
> David Cousens
> --
> Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.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.

___
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] Report headings, can one separate the company name from the report name?

[D. via gnucash-user]

I don't use those reports, but I can't see why your solution is a "hack." Seems 
perfectly legitimate to me. 


 Original Message 
From: Chris Green 
Sent: Wed Sep 30 12:40:43 EDT 2020
To: gnucash-user@gnucash.org
Subject: Re: [GNC] Report headings, can one separate the company name from the 
report name?

On Mon, Sep 28, 2020 at 09:04:28PM +0100, Chris Green wrote:
> I have just been looking at and printing some reports, the 'Company
> Name' set in Properties is just put on the same line as the report
> name.
> 
> Is there any way to get the Company Name on a line by itself at the
> top of the report?
> 
No answers?  It seems such an obvious thing to want to do.

Anyway I've found a bit of a 'hack' that does what I want.  Since the
reports are all HTML then one can add HTML to the strings in options.

I just changed the business name from "This is my business name" to
"This is my business name" and now it appears in a line by itself
at the top of the report.

-- 
Chris Green
___
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] clip board paste across catagories

[D. via gnucash-user]

I've no idea. 


 Original Message 
From: ToddAndMargo via gnucash-user 
Sent: Tue Sep 29 20:58:30 EDT 2020
To: gnucash-user@gnucash.org
Subject: Re: [GNC] clip board paste across catagories

On 2020-09-29 13:29, David T. via gnucash-user wrote:
> I am not an expert, but perhaps if you're writing the format yourself, 
> maybe you could adopt an existing standard (e.g., QIF, QFX, CSV) and 
> import that into GnuCash?
> 
> Also, Chapter 18 in the Guide is all about importing business data. 
> Perhaps that might lead somewhere?

I have not read chapter 18 yet.

Do you know if there is a way to tell GnuCash to read
a CSV from the command line?


___
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] Can't "Save As" to sqlite, is it a compile option?

[D. via gnucash-user]

Yes. I did. 


 Original Message 
From: Geert Janssens 
Sent: Wed Sep 23 16:10:11 EDT 2020
To: gnucash-user@gnucash.org
Subject: Re: [GNC] Can't "Save As" to sqlite, is it a compile option?

Op dinsdag 22 september 2020 10:13:37 CEST schreef Chris Green:
> On Mon, Sep 21, 2020 at 01:12:38PM -0500, Adrien Monteleone wrote:
> > I'm pretty sure that *is* documented on the Wiki build pages, or at least
> > used to be. I once built on Ubuntu and found that option on the Wiki to
> > get
> > it working.
> 
> Ah, but it's nothing to do with 'building' really.
> 
> > I was lightly following some Wiki Build Instruction discussion on IRC
> > recently and I think that very option (with needed dependency) was pointed
> > out as not being quite obvious.
> > 
> > Check out the Build on Linux pages (along with the sub-pages about
> > dependencies) and read their Talk sections for more current info and state
> > of the edits.
> 
> As above, nothing to do with 'building' IMHO.  It should be in the
> basic 'installation' notes.

Did someone already refer to
https://www.gnucash.org/docs/v4/C/gnucash-guide/basics-files1.html#basics-storage-comparison-tblsect[1]
 

That's a section in the tutorial about storing your data. And the note on 
availability of the three 
sql backends mentions you may have to install libdbi and the appropriate dbd 
(sql) backends.

Regards,

Geert


[1] 
https://www.gnucash.org/docs/v4/C/gnucash-guide/basics-files1.html#basics-storage-comparison-tblsect
___
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] Reconcile Status Redux: New Odd Behavior, or Is It Me Again?

[D. via gnucash-user]

Sorry. I meant clicking the reconcile field itself (the spot in the register 
labeled "R" to the left of the transfer account field) is the only field that 
actually changes the status and sticks. 

Glad to know that I'm not imagining things...


 Original Message 
From: Adrien Monteleone 
Sent: Tue Sep 22 16:45:39 EDT 2020
To: gnucash-u...@lists.gnucash.org
Subject: Re: [GNC] Reconcile Status Redux: New Odd Behavior, or Is It Me Again?

I can confirm the same behavior on MacOS.

(however, which field do you mean by: "The only instance in which I've 
been able to reverse the reconcile flag is to directly click the field 
in the register"?)

I seem to recall that the fields which trigger flipping the flag to 'n' 
have changed. (not sure if 4.0 or 4.1)

I would think amount and date would do that as they are both critical to 
the reconciliation. (unless the date change is within the opening and 
closing date, but I'm not sure if that is stored or is part of the logic 
check)

Any other field I would think should be able to change without flipping 
the flag.

The fact that you are warned, and then the flag isn't changed, to me is 
a bug, either in the warning being generated when it doesn't need to be, 
or in the flag not being set to 'n' when it should. (and as noted, I 
believe date 'may' but amount always 'should' flip it)


Regards,
Adrien

On 9/22/20 2:37 PM, David T. via gnucash-user wrote:
> Hello,
> 
> I know no one wants to hear from me these days, but I've noticed strange 
> behavior with reconciled transaction entries in GnuCash 4.1 under 
> Windows 10.
> 
> Specifically, when I edit the amount of a reconciled transaction entry 
> (a.k.a. "split"), I receive a notice that I am attempting to edit a 
> reconciled split (as is appropriate). After I confirm that I wish to 
> change this entry, I am then taken into the entry, and I make my edit. 
> When I change the amount, the reconcile flag changes to "n", but when I 
> leave the split, *the split reverts to reconciled status.* I have tested 
> this in a couple of different register types (commodity, cash), and I 
> have tried both tabbing out of the split and using enter, with the same 
> result.
> 
> Similarly, trying to change the date of the transaction as a whole gives 
> this message; however, none of the reconcile status flags are changed in 
> this case. The only instance in which I've been able to reverse the 
> reconcile flag is to directly click the field in the register.
> 
> I don't recall now whether there has been a change in logic on this 
> front, such that reconciled transactions are left reconciled except when 
> the flag is directly changed. Previously, any attempts to alter a 
> transaction resulted in its reconcile flag being turned off.
> 
> Does anyone else see this behavior, is it intended to be this way, or is 
> it once again some odd setting that I have somehow managed to set?
> 
> David T.

___
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] Can't "Save As" to sqlite, is it a compile option?

[D. via gnucash-user]

No need.  https://www.gnucash.org/docs/v4/C/gnucash-guide/basics-files1.html


 Original Message 
From: Chris Green 
Sent: Mon Sep 21 03:47:20 EDT 2020
To: gnucash-user@gnucash.org
Subject: Re: [GNC] Can't "Save As" to sqlite, is it a compile option?

On Sun, Sep 20, 2020 at 11:19:42PM -0500, Adrien Monteleone wrote:
> See my other reply about versions and database support. I've been using
> SQlite3 since the 2.6.x days.
> 
> The build instructions on the wiki are very good. The most time will be
> spent reading and making sure you have the build environment and
> dependencies. If you get that right, the actual build is fairly quick and
> painless.
> 
It was all a bit of a non-event really, what I *actually* needed to do
was add a library that GnuCash needs for sqlite to work.  It (the
library) doesn't get installed by default because it's not listed as a
dependency.

For information the library needed is called libdbd-sqlite3 in the
Debian/Ubuntu Linux world.

Where should/would this be documented?  I'm happy to put things in
motion to get it done if it isn't already.

-- 
Chris Green
___
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] Error with Advanced portfolio report

[D. via gnucash-user]

Thanks. 


 Original Message 
From: John Ralls 
Sent: Sat Sep 19 16:46:42 EDT 2020
To: mike823 
Cc: gnucash-user@gnucash.org
Subject: Re: [GNC] Error with Advanced portfolio report



> On Sep 19, 2020, at 1:15 PM, mike823  wrote:
> 
> It is a bug and it was reported at least 5 times since 4.2 was released.
> Never got any attention for the dev team.

It's https://bugs.gnucash.org/show_bug.cgi?id=797891 and is fixed. The fix will 
be released in 4.2 so the five reports after that will indeed get no attention 
from the dev team as none will be necessary.

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] Tabs Behaviors in GNC4.1

[D. via gnucash-user]

Geert,

I stopped contributing in any way to the project at the beginning of 2019, in 
large part because of problems with the workflow, culture, and environment that 
GnuCash operates within. So, I can definitely relate to your feeling like you 
want to step back. 

Given that my observations regarding GnuCash features, use, and behavior are of 
no interest or importance to the developers, I'll just stop making attempts to 
share those observations, and instead be grateful to have the use of Gnucash 
(warts and all).

David T. 


 Original Message 
From: Geert Janssens 
Sent: Wed Sep 16 15:26:22 EDT 2020
To: "D." 
Cc: Gnucash Users , Stan Brown 
, David Carlson 
Subject: Re: [GNC] Tabs Behaviors in GNC4.1

Op woensdag 16 september 2020 14:46:58 CEST schreef D.:
> Thanks for pointing this bug out.
> 
> It's too bad that the suggestion in the bug to discuss this change on the
> lists was not apparently taken up. The devs would then have at least heard
> from some other users about their use cases and preferences, and users
> would have had a heads up about the change. Instead, a change gets pushed
> out based on one person's request, mainly because it involves "three lines
> of code." I'll set aside the wisdom of making changes to software based
> primarily on the complexity of the fix, or on a single user and the
> opinions of three devs...
> 
> While it might seem overkill to discuss something as seemingly minor as this
> change, I think *any* change in the user interface should be discussed
> more, rather than less.

David,

Yes, more discussion up front is useful. However if you want more discussion to 
happen (or more 
precisely if *you* want to be get involved more in such discussions) I suggest 
you actively 
choose to become more involved proactively rather than waiting until a finished 
release is 
presented to you. That doesn't mean you have to write or review code, but you 
can subscribe to 
the channels where the devs generally communicate to get an early idea of what 
lives there.

Some topics will be brought to the users, others not so much. And by the way, I 
don't think 
gnucash-user is the proper channel for this kind of discussion. I believe it 
should be held on 
gnucash-devel.

> 
> Now, we get to have that discussion.
> 
> At the risk of repeating myself, let me re-present. In my usage of Gnucash,
> I keep a core set of tabs always open. These tabs represent my primary
> active accounts: my checking account, savings account, credit card account,
> and a cash account.
> 
> I leave them open because they are involved in the vast majority of my
> transactions, and it is easier to click on one of the tabs than to go to
> the CoA, locate the account, and open it. I like to have them at the top of
> the list at all times because I can quickly locate them there. I know where
> they are.
> 
> With the latest change, I no longer can rely on this. My core tabs move
> down. If I open one of my more obscure accounts to look at things, it
> pushes its way in at the top. If I've opened several of them, they are all
> at the top, and when I am done with those tabs, I have to carefully close
> tabs, rather than close all tabs below a certain point on the screen.
> 
While I see what you mean with closing, I perceive this as a minor behavioural 
change. As all the 
new tabs will be on top, it should not be too hard to close them one by one by 
starting with the 
first one. You don't have to move your mouse for that. I can imagine you have 
to be a little bit 
more careful to stop clicking in time to avoid closing your first "always-open" 
tab. However if 
you have many always-open tabs that problem also exists when new tabs open at 
the end.

> None of this is particularly catastrophic, but it does affect me and my
> workflow every time I open or close an account, so I would prefer to have
> the option of restoring the old tab behavior.
> 
See my other replies here and on the bug. I don't think an option is a good 
solution.

> The idea of pinned tabs is interesting, although it doesn't remove the need
> for the preference. If I jump to a new account tab from a pinned one, will
> the new tab go at the end of the list, or bury itself in the middle of my
> pinned tabs? I think the user would still want the option of where the new
> tabs open.

That problem is not solved by adding an option.

> 
> I'll give a clear and unambiguous preference: I want to be able to choose
> this behavior with a preference setting. Put this setting on the same page
> as the tab location setting, and have it read:
> 
> Open new tabs: □ At the bottom of the tab list □ After the current tab
> 

Understood. My clear and unambiguous design standpoint is that an option is not 
the solution. 
It's a band-aid at best. I don't have a ready-made answer but I know this isn't 
it.

Geert

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription 

Re: [GNC] Tabs Behaviors in GNC4.1

[D. via gnucash-user]

Thanks for pointing this bug out. 

It's too bad that the suggestion in the bug to discuss this change on the lists 
was not apparently taken up. The devs would then have at least heard from some 
other users about their use cases and preferences, and users would have had a 
heads up about the change. Instead, a change gets pushed out based on one 
person's request, mainly because it involves "three lines of code." I'll set 
aside the wisdom of making changes to software based primarily on the 
complexity of the fix, or on a single user and the opinions of three devs... 

While it might seem overkill to discuss something as seemingly minor as this 
change, I think *any* change in the user interface should be discussed more, 
rather than less. 

Now, we get to have that discussion.

At the risk of repeating myself, let me re-present. In my usage of Gnucash, I 
keep a core set of tabs always open. These tabs represent my primary active 
accounts: my checking account, savings account, credit card account, and a cash 
account. 

I leave them open because they are involved in the vast majority of my 
transactions, and it is easier to click on one of the tabs than to go to the 
CoA, locate the account, and open it. I like to have them at the top of the 
list at all times because I can quickly locate them there. I know where they 
are. 

With the latest change, I no longer can rely on this. My core tabs move down. 
If I open one of my more obscure accounts to look at things, it pushes its way 
in at the top. If I've opened several of them, they are all at the top, and 
when I am done with those tabs, I have to carefully close tabs, rather than 
close all tabs below a certain point on the screen. 

None of this is particularly catastrophic, but it does affect me and my 
workflow every time I open or close an account, so I would prefer to have the 
option of restoring the old tab behavior. 

The idea of pinned tabs is interesting, although it doesn't remove the need for 
the preference. If I jump to a new account tab from a pinned one, will the new 
tab go at the end of the list, or bury itself in the middle of my pinned tabs? 
I think the user would still want the option of where the new tabs open. 

I'll give a clear and unambiguous preference: I want to be able to choose this 
behavior with a preference setting. Put this setting on the same page as the 
tab location setting, and have it read:

Open new tabs: □ At the bottom of the tab list □ After the current tab

David T. 


 Original Message 
From: Geert Janssens 
Sent: Wed Sep 16 03:35:35 EDT 2020
To: "D." , gnucash-user@gnucash.org
Cc: Gnucash Users , Stan Brown 
, David Carlson 
Subject: Re: [GNC] Tabs Behaviors in GNC4.1

Op woensdag 16 september 2020 01:21:19 CEST schreef 
David Carlson:
> It doesn't make sense to me either, and since it is a change 
from previous
> behavior, I  think it deserves a bug report.

https://bugs.gnucash.org/show_bug.cgi?id=797787[1] 


[1] https://bugs.gnucash.org/show_bug.cgi?id=797787

___
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] Tabs Behaviors in GNC4.1

[D. via gnucash-user]

Not sure about how tabs opened in previous versions when set in the top 
position; I've been using the left side for well over a decade. Currently, they 
open on the top in a similar manner as I described, with the new tab 
interpolating itself into the sequence. 

Tabs and windows can be moved, and are saved in their sequence, but new tabs 
open after the accounts window, no matter where it is placed. Opening a new tab 
in position 4 out of 7, just because the accounts tab is number 3 makes sense 
in some world, just not mine. 

David T. 


 Original Message 
From: David Carlson 
Sent: Tue Sep 15 18:24:53 EDT 2020
To: "D." 
Cc: Stan Brown , Gnucash Users 

Subject: Re: [GNC] Tabs Behaviors in GNC4.1

I need to ask if this change in sorting order also applies to the default
tabs at the top configuration.

Also, is it still possible to manually move tabs around with the mouse or
judicious use of arrow keys to put them in your preferred order.  The
corollary, of course, is does that order stick if you close and reopen the
same file. later.

On Tue, Sep 15, 2020 at 5:00 PM D. via gnucash-user <
gnucash-user@gnucash.org> wrote:

> On putting the Chart of Accounts at the end: presumably that would work,
> but it really messes with the Order of Things in my head.  ;)
>
> As for the size changes, well, I have been using gnucash a while...
>
>
>  Original Message 
> From: Stan Brown 
> Sent: Tue Sep 15 15:55:35 EDT 2020
> To: gnucash-user@gnucash.org
> Cc: D 
> Subject: Re: [GNC] Tabs Behaviors in GNC4.1
>
>
> On 2020-09-15 12:39, David T. via gnucash-user wrote:
> >The first issue I've noticed is that new tabs now open directly under
> > the Chart of Accounts tab on the screen. In the past, they opened at
> > the very end of the list. ... I much prefer [the old] approach, since
> > I usually have a default set of accounts always opened, and the tabs
> > below are for more situational information.
>
> 2.6.19 does indeed put the new tab at the end. Like you, I have a small
> set of tabs that I always keep open, and open additional accounts only
> for some brief use.
>
> Can you work around the problem by making the Chart of Accounts last in
> your normal group?
>
> > The second issue I have is that tabs shrink and expand to show the full
> > account name up to a certain point. In older versions, I believe that
> > the tab width was fixed,
>
> I just tried it in 2.6.19, and when I opened a account with along name
> the column of tabs expanded to fit the long name. (Like you, I have the
> account tabs at the left, not at the top.)
>
> That's not to say that it necessarily _should_ be that way, but it
> doesn't seem to be a recent change.
>
> --
> Regards,
> Stan Brown
> Tehachapi, CA, USA
> https://BrownMath.com
> https://OakRoadSystems.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.
>


-- 
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
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] Tabs Behaviors in GNC4.1

[D. via gnucash-user]

On putting the Chart of Accounts at the end: presumably that would work, but it 
really messes with the Order of Things in my head.  ;)

As for the size changes, well, I have been using gnucash a while...


 Original Message 
From: Stan Brown 
Sent: Tue Sep 15 15:55:35 EDT 2020
To: gnucash-user@gnucash.org
Cc: D 
Subject: Re: [GNC] Tabs Behaviors in GNC4.1


On 2020-09-15 12:39, David T. via gnucash-user wrote:
>The first issue I've noticed is that new tabs now open directly under
> the Chart of Accounts tab on the screen. In the past, they opened at
> the very end of the list. ... I much prefer [the old] approach, since
> I usually have a default set of accounts always opened, and the tabs
> below are for more situational information.

2.6.19 does indeed put the new tab at the end. Like you, I have a small
set of tabs that I always keep open, and open additional accounts only
for some brief use.

Can you work around the problem by making the Chart of Accounts last in
your normal group?

> The second issue I have is that tabs shrink and expand to show the full
> account name up to a certain point. In older versions, I believe that
> the tab width was fixed,

I just tried it in 2.6.19, and when I opened a account with along name
the column of tabs expanded to fit the long name. (Like you, I have the
account tabs at the left, not at the top.)

That's not to say that it necessarily _should_ be that way, but it
doesn't seem to be a recent change.

-- 
Regards,
Stan Brown
Tehachapi, CA, USA
https://BrownMath.com
https://OakRoadSystems.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.

Re: [GNC] Installing GnuCash 4.1 There is no Disk - Insert a Disk on Windows 7 x64

[D. via gnucash-user]

This has come up before. As I understand it, this is a problem with Windows and 
some applications. Past threads on this suggested a registry edit, among other 
solutions. 

I'll note that Windows 7 is no longer actively supported, which means that it 
might not be the best choice at this time to put your financial information 
on...


 Original Message 
From: Enrique Garza 
Sent: Tue Sep 08 09:04:44 EDT 2020
To: gnucash-user@gnucash.org
Subject: [GNC] Installing GnuCash 4.1 There is no Disk - Insert a Disk on 
Windows 7 x64

GnuCash

    I have installed the GnuCash 4.1 software in a Windows 7 x64
Professional. After the installation the program try to access to
different Disk Drives with an error message: There is no Disk in the
Drive - Insert a Disk. At the moment, when I start the program such
error messages have disapears, but I don´t know if this issue can happen
again. I have to run the install as Administrator? Has the program some
issue?
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] Import quicken

[D. via gnucash-user]

Hello, 

Reading the available help is a great way to start. 

Start with: 
https://www.gnucash.org/docs/v4/C/gnucash-guide/chapter_importing.html
Next: https://wiki.gnucash.org/wiki/Quicken_Migration




 Original Message 
From: PhilipChaban 
Sent: Thu Sep 03 08:57:11 EDT 2020
To: gnucash-user@gnucash.org
Subject: [GNC] Import quicken

What steps to go thru for a Quicken QIF file import to 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
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] Asset accounts: cost, or value?

[D. via gnucash-user]

Michael, 

Could you go into more detail about how one would enter, e.g., title insurance 
in GnuCash so that it would apply to the cost basis of a property? 

TIA,
David


 Original Message 
From: Michael or Penny Novack 
Sent: Wed Sep 02 09:53:54 EDT 2020
To: gnucash-user@gnucash.org
Subject: Re: [GNC] Asset accounts: cost, or value?

On 9/2/2020 8:28 AM, Marcus Winston wrote:
> OK, Thanks. So the "balance" in the asset account would reflect the 
> cost of the asset, not its value. That's fine, and is what I concluded 
> also.
>
> Next question: When I sell the house, I'm adding the costs to sell the 
> house (title insurance, reconveyance fees, etc) to the cost of the 
> house itself. In other words, this will increase the bottom line on 
> the fixed asset "House" account. For two-column accounting, where does 
> that money come from (what's the other account)? I tried using an 
> equity account, but then I end up with a positive equity value on the 
> house after I sell it, and that doesn't make sense (I think I should 
> have zero equity in the house once it's sold).
>
> MW

This isn't a gnucash question per se (you would have exactly the same 
question were we back in the days of pen and ink on paper accounting)

When these transactions occurred you may have entered them wrongly << 
BTW, maybe it is being in different jurisdictions, but you are listing 
things like "title insurance" and "conveyance fees" as SELLER costs. In 
my experience, it is the buyer who pays for those particular things. >>

But back to the other side of those transactions. What I suspect is that 
you entered them incorrectly with the other side as expenses, not 
changes to the basis.

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
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] Capital Gain Calculations on Split Stocks

[D. via gnucash-user]

Oh! I like that solution! 

I knew someone would have a way to make this work. Now, if only the assistant 
would handle it this way...


 Original Message 
From: Geoff 
Sent: Tue Aug 25 02:04:38 EDT 2020
To: "D." , peterb 
Cc: Gnucash Users 
Subject: Re: [GNC] Capital Gain Calculations on Split Stocks

David, this problem is caused by the stock split transaction.

I always do my stock splits the old fashioned way - manually reverse out 
the old and re-enter the new.  See screenshot 01.  Notice how the 
original lot is now closed and a new one is created (with the correct 
cost basis).

Once you have done this, just enter the sale and scrub the account to 
automatically calculate the correct capital gain of $16.55 - screenshot 02.

Hope this helps.

Geoff
=

On 25/08/2020 1:13 pm, D. via gnucash-user wrote:
> Peter,
> 
> I thought the same about partial sales, but have found now that almost all my 
> scenarios can be addressed in the lots tool. In my case, matching the 
> broker's sales record up to the correct lot yields accurate results, except 
> in this situation with a split stock. I agree with you generally about making 
> sure I'm tracking it all the same as the broker, since that's where the tax 
> folks are going.
> 
> David
> 
> 
>  Original Message 
> From: peterb 
> Sent: Mon Aug 24 22:52:23 EDT 2020
> To: "David T." 
> Cc: Gnucash Users 
> Subject: Re: [GNC] Capital Gain Calculations on Split Stocks
> 
> My experience is that the View Lots cap gain method is tractable right up
> to the point where you have partial lots, and is not really usable (or, at
> least, I don't find it usable) afterwards.  When I have a partial sale of a
> lot, I don't even try to use it.  Just add a gain/loss transaction by hand
> with the numbers that you know are correct (since these numbers are coming
> from your broker and will be *what is reported to your tax authority, *they're
> the best source of truth; if your trial balance is off after that,
> double-check that your cost basis in GnuCash agrees with your broker's
> records).
> 
> On Mon, Aug 24, 2020 at 9:41 PM David T. via gnucash-user <
> gnucash-user@gnucash.org> wrote:
> 
>> Hi,
>>
>> In the last couple of days, I have learned TONS about how to manage
>> capital gains with assorted lots in the GnuCash realm. The financial
>> institution I use has algorithms that adjust my accounts to minimize tax
>> implications. This results in sales against specific lots within
>> GnuCash, and I've been able to match sales with specific lots and
>> achieve numbers in GnuCash which match the institution's calculations.
>> All good!
>>
>> However, I have one account with a single purchase, followed by a two
>> for one split, followed by a partial sale. Using the lots in this case,
>> however, yields wildly variant and incorrect results. In the attached
>> image, you can see the full transaction history, along with the lots
>> window indicating the assignment of the February sale to Lot 0 with a
>> loss of $169.96.
>>
>> This happens because 7*53.29 (the original share price) = $373.03, and
>> 203.07 - 373.03 = -169.96
>>
>> If I choose to use Lot 2 for the match, the result is $203.07 gain
>> (7*0=$0 cost). This also is wrong.
>>
>> The correct calculation is: $203.07 - (7 * 53.29 / 2) = $16.55, which is
>> what the institution is reporting. I am hesitant to adjust the gain
>> value to match this amount, as I suspect that GnuCash will then report
>> the account as out of balance. I have seen in the past that incorrect
>> gains calculations can throw off the balance sheet, with painful
>> remedies and memories. My questions here are:
>>
>> 1) Is there a way to have GnuCash properly track cost basis in an
>> account with a stock split?
>>
>> 2) If I arbitrarily change the gains transaction, will subsequent
>> balance sheet numbers be in balance?
>>
>> 3) What is the proper way to handle a stock split?
>>
>> TIA,
>>
>> David T.
>>
>> ___
>> 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@gnu

Re: [GNC] Capital Gain Calculations on Split Stocks

[D. via gnucash-user]

Peter, 

I thought the same about partial sales, but have found now that almost all my 
scenarios can be addressed in the lots tool. In my case, matching the broker's 
sales record up to the correct lot yields accurate results, except in this 
situation with a split stock. I agree with you generally about making sure I'm 
tracking it all the same as the broker, since that's where the tax folks are 
going. 

David


 Original Message 
From: peterb 
Sent: Mon Aug 24 22:52:23 EDT 2020
To: "David T." 
Cc: Gnucash Users 
Subject: Re: [GNC] Capital Gain Calculations on Split Stocks

My experience is that the View Lots cap gain method is tractable right up
to the point where you have partial lots, and is not really usable (or, at
least, I don't find it usable) afterwards.  When I have a partial sale of a
lot, I don't even try to use it.  Just add a gain/loss transaction by hand
with the numbers that you know are correct (since these numbers are coming
from your broker and will be *what is reported to your tax authority, *they're
the best source of truth; if your trial balance is off after that,
double-check that your cost basis in GnuCash agrees with your broker's
records).

On Mon, Aug 24, 2020 at 9:41 PM David T. via gnucash-user <
gnucash-user@gnucash.org> wrote:

> Hi,
>
> In the last couple of days, I have learned TONS about how to manage
> capital gains with assorted lots in the GnuCash realm. The financial
> institution I use has algorithms that adjust my accounts to minimize tax
> implications. This results in sales against specific lots within
> GnuCash, and I've been able to match sales with specific lots and
> achieve numbers in GnuCash which match the institution's calculations.
> All good!
>
> However, I have one account with a single purchase, followed by a two
> for one split, followed by a partial sale. Using the lots in this case,
> however, yields wildly variant and incorrect results. In the attached
> image, you can see the full transaction history, along with the lots
> window indicating the assignment of the February sale to Lot 0 with a
> loss of $169.96.
>
> This happens because 7*53.29 (the original share price) = $373.03, and
> 203.07 - 373.03 = -169.96
>
> If I choose to use Lot 2 for the match, the result is $203.07 gain
> (7*0=$0 cost). This also is wrong.
>
> The correct calculation is: $203.07 - (7 * 53.29 / 2) = $16.55, which is
> what the institution is reporting. I am hesitant to adjust the gain
> value to match this amount, as I suspect that GnuCash will then report
> the account as out of balance. I have seen in the past that incorrect
> gains calculations can throw off the balance sheet, with painful
> remedies and memories. My questions here are:
>
> 1) Is there a way to have GnuCash properly track cost basis in an
> account with a stock split?
>
> 2) If I arbitrarily change the gains transaction, will subsequent
> balance sheet numbers be in balance?
>
> 3) What is the proper way to handle a stock split?
>
> TIA,
>
> David T.
>
> ___
> 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] Capital Gain Calculations on Split Stocks

[D. via gnucash-user]

Christopher, 

Thanks for the reply. 

I'll have to figure out how I'd trigger the --extra flag in Windows and take a 
look at that report. It may make the whole gains process a little easier. As it 
is, a statement with 10-15 sales transactions can take quite some time to work 
through. I understand generally how it all is working, although determining 
which lots the broker has designated for sale can be challenging. (It also took 
a while to figure out how to force the software to use a disparate set of lots 
for one sale. It turns out that you have to sequence the lot selection so that 
the open lot is the lot selected last. I could imagine an impossible-to-achieve 
in gnucash situation, where a sale used multiple incomplete lots, leaving them 
both open. Lots as currently implemented couldn't do this, although i honestly 
can't imagine a real world use for this.)

I tried to follow the discussion at bug 797796, but have to admit it didn't 
make a lot of sense to me. 

I'm more concerned about how the gains are recorded as valued transactions than 
with the reports, but I'll take a look at the report shortly. 

Thanks, 
David


 Original Message 
From: Christopher Lam 
Sent: Mon Aug 24 22:01:35 EDT 2020
To: "David T." 
Cc: Gnucash Users 
Subject: Re: [GNC] Capital Gain Calculations on Split Stocks

David, I don't use stock at all myself but have a couple of suggestions.

1) lots can be made much more visible with the "lot-viewer" report which is
hidden behind the --extra flag.

2) FIFO and LIFO are handled in advanced-portfolio, and adjusted cost basis
is a difficult task documented and being discussed in
https://github.com/Gnucash/gnucash/pull/763 and bug 797796.

3) stock splits are recognised and handled by advanced portfolio. I don't
understand this report myself.


On Tue, 25 Aug 2020, 9:40 am David T. via gnucash-user, <
gnucash-user@gnucash.org> wrote:

> Hi,
>
> In the last couple of days, I have learned TONS about how to manage
> capital gains with assorted lots in the GnuCash realm. The financial
> institution I use has algorithms that adjust my accounts to minimize tax
> implications. This results in sales against specific lots within
> GnuCash, and I've been able to match sales with specific lots and
> achieve numbers in GnuCash which match the institution's calculations.
> All good!
>
> However, I have one account with a single purchase, followed by a two
> for one split, followed by a partial sale. Using the lots in this case,
> however, yields wildly variant and incorrect results. In the attached
> image, you can see the full transaction history, along with the lots
> window indicating the assignment of the February sale to Lot 0 with a
> loss of $169.96.
>
> This happens because 7*53.29 (the original share price) = $373.03, and
> 203.07 - 373.03 = -169.96
>
> If I choose to use Lot 2 for the match, the result is $203.07 gain
> (7*0=$0 cost). This also is wrong.
>
> The correct calculation is: $203.07 - (7 * 53.29 / 2) = $16.55, which is
> what the institution is reporting. I am hesitant to adjust the gain
> value to match this amount, as I suspect that GnuCash will then report
> the account as out of balance. I have seen in the past that incorrect
> gains calculations can throw off the balance sheet, with painful
> remedies and memories. My questions here are:
>
> 1) Is there a way to have GnuCash properly track cost basis in an
> account with a stock split?
>
> 2) If I arbitrarily change the gains transaction, will subsequent
> balance sheet numbers be in balance?
>
> 3) What is the proper way to handle a stock split?
>
> TIA,
>
> David T.
>
> ___
> 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] help increasing size of font in GnuCash?

[D. via gnucash-user]

John, 

I wondered about that as well; a check of the wiki turns that location up in 
this section: 
https://wiki.gnucash.org/wiki/Configuration_Locations#GTK_DATA_HOME




 Original Message 
From: John Ralls 
Sent: Mon Aug 17 12:13:08 EDT 2020
To: Peter West 
Cc: gnucash-u...@lists.gnucash.org, adrien.montele...@lusfiber.net
Subject: Re: [GNC] help increasing size of font in GnuCash?



> On Aug 15, 2020, at 11:47 PM, Peter West  wrote:
> 
>> On 16 Aug 2020, at 1:29 pm, Adrien Monteleone 
>>  wrote:
> …
>> The file should be named:
>> 
>> gtk-3.0.css
> 
> That’s why I couldn’t get mine to work in either location. I was using 
> gtk.css.
> 
> I can say that the location ~/.local/share/gtk-3.0/gtk-3.0.css does NOT work, 
> in spite of the wiki.
>> 
>> The location should be:
>> 
>> ~/Library/Application Support/GnuCash
> 

Where does the wiki say that one can use ~/.local/share for anything?

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] Get quote - online price retrieval

[D. via gnucash-user]

Ah, yes. ISTR that AlphaVantage is used for all currency conversions. 

That would suggest that users should be told that outright somewhere.


 Original Message 
From: Geoff 
Sent: Mon Aug 17 08:32:10 EDT 2020
To: "D." 
Cc: David Reiser via gnucash-user , 
gnucash-user@gnucash.org
Subject: Re: [GNC] Get quote - online price retrieval

One would think so David, but my experience was otherwise.

When running Get Quotes on a brand new default database with no 
securities defined, and then after adding just one security for this 
mutual fund, in both cases I was prompted to enter an AlphaVantage API 
key - see attached screenshots.

I believe this behaviour is because I set up the database with a 
currency code of INR, as when I do the same with USD the error message 
doesn't manifest.

Anyway, for this particular issue, the root cause was the failed 
installation of the supporting perl modules.

Have a good day.

Regards

Geoff
=

On 17/08/2020 9:00 pm, D. wrote:
> Of course, if you're using amfiindia as your price source, it's not 
> technically necessary to add an AlphaVantage key, since you're not using 
> AlphaVantage as a source.
> 
> 
>  Original Message 
> From: Geoff 
> Sent: Mon Aug 17 01:41:22 EDT 2020
> To: gnucash-user@gnucash.org
> Subject: Re: [GNC] Get quote - online price retrieval
> 
> Ashok, I have tried to replicate your issue on a new Windows 10 installation.
> 
> You said:-
> "Did the cpan Date::Manip, but that freezes at the point of the below stage.
> Have to "Ctrl"+C, ugly exit."
> 
> You need to be more patient, it wasn't frozen, just having a rest!  The
> complete installation process of all the necessary perl modules for price
> quotes (if you use "gnc-fq-update" the recommended gnucash installer) took
> about 30 minutes on my machine, and there were a couple of significant
> pauses along the way.
> 
> Once you have successfully installed Finance::Quotes and all of its
> dependencies, you will be able to get a quote for your fund:
> 
> C:\Program Files (x86)\gnucash\bin>perl gnc-fq-dump -v amfiindia 106876
> Finance::Quote fields Gnucash uses:
>  symbol: 106876   <=== required
>date: 08/14/2020   <=== recommended
>currency: INR  <=== required
>last:  <=\
> nav: 17.6037  <=== one of these
>   price:  <=/
>timezone:  <=== optional
> 
> All fields returned by Finance::Quote for stock 106876
> 
> stock   field  value
> -   -  -
> 106876   currency: INR
> 106876   date: 08/14/2020
> 106876isodate: 2020-08-14
> 106876   link: https://www.amfiindia.com/spages/NAVAll.txt
> 106876 method: amfitable
> 106876   name: Aditya Birla Sun Life International Equity Fund -
> Plan B - Growth - Regular Plan
> 106876nav: 17.6037
> 106876 source: http://www.amfiindia.com/
> 106876success: 1
> 106876 symbol: 106876
> 
> 
> I have also attached a screenshot of getting a quote from within gnucash -
> don't forget to add your AlphaVantage API key first as explained here:
> https://wiki.gnucash.org/wiki/Online_Quotes
> 
> 
> DETAILED INSTRUCTIONS
> =
> Windows 10 Version 1903
> 
> Download gnucash 4.1 for Windows 10 from:
> https://sourceforge.net/projects/gnucash/files/gnucash%20(stable)/4.1/gnucash-4.1.setup.exe
> 
> Verify the checksum from https://www.gnucash.org/news.phtml
> We are expecting:
> "836b36be639caf61321c2df24dda48691e57ddeb6b7aa13db49f8eddd5b096e0" for
> gnucash-4.1.setup.exe
> 
> 08/17/2020  12:56 PM  ..
> 08/17/2020  12:56 PM   148,789,209 gnucash-4.1.setup.exe
> 
> C:>certutil -hashfile gnucash-4.1.setup.exe SHA256
> SHA256 hash of gnucash-4.1.setup.exe:
> 836b36be639caf61321c2df24dda48691e57ddeb6b7aa13db49f8eddd5b096e0
> CertUtil: -hashfile command completed successfully.
> 
> 
> Download strawberry perl from http://strawberryperl.com/
> http://strawberryperl.com/download/5.30.2.1/strawberry-perl-5.30.2.1-64bit.msi
> 
> 08/17/2020  01:04 PM  .
> 08/17/2020  01:04 PM   106,541,628 strawberry-perl-5.30.2.1-64bit.msi
> 
> C:>perl -v
> This is perl 5, version 30, subversion 2 (v5.30.2) built for
> MSWin32-x64-multi-thread
> 
> C:>cd "C:\Program Files (x86)\gnucash\bin"
> 
> C:\Program Files (x86)\gnucash\bin>perl gnc-fq-check
> 
> You need to install the following Perl modules:
>Finance::Quote
> 
> Use your system's package manager to install them,
> or run 'gnc-fq-update' as root.
> missing-lib
> 
> C:\Program Files (x86)\gnucash\bin>perl gnc-fq-update
> Fetching with LWP:
> http://cpan.strawberryperl.com/authors/01mailrc.txt.gz
> Fetching with LWP:
> http://cpan.strawberryperl.com/modules/02packages.details.txt.gz
> Fetching with LWP:
> http://cpan.strawberryperl.com/modules/03modlist.data.gz
> Creating database file ... Done!
> Running install 

Re: [GNC] Get quote - online price retrieval

[D. via gnucash-user]

Of course, if you're using amfiindia as your price source, it's not technically 
necessary to add an AlphaVantage key, since you're not using AlphaVantage as a 
source. 


 Original Message 
From: Geoff 
Sent: Mon Aug 17 01:41:22 EDT 2020
To: gnucash-user@gnucash.org
Subject: Re: [GNC] Get quote - online price retrieval

Ashok, I have tried to replicate your issue on a new Windows 10 installation.

You said:-
"Did the cpan Date::Manip, but that freezes at the point of the below stage.
Have to "Ctrl"+C, ugly exit."

You need to be more patient, it wasn't frozen, just having a rest!  The
complete installation process of all the necessary perl modules for price
quotes (if you use "gnc-fq-update" the recommended gnucash installer) took
about 30 minutes on my machine, and there were a couple of significant
pauses along the way.

Once you have successfully installed Finance::Quotes and all of its
dependencies, you will be able to get a quote for your fund:

C:\Program Files (x86)\gnucash\bin>perl gnc-fq-dump -v amfiindia 106876
Finance::Quote fields Gnucash uses:
symbol: 106876   <=== required
  date: 08/14/2020   <=== recommended
  currency: INR  <=== required
  last:  <=\
   nav: 17.6037  <=== one of these
 price:  <=/
  timezone:  <=== optional

All fields returned by Finance::Quote for stock 106876

stock   field  value
-   -  -
106876   currency: INR
106876   date: 08/14/2020
106876isodate: 2020-08-14
106876   link: https://www.amfiindia.com/spages/NAVAll.txt
106876 method: amfitable
106876   name: Aditya Birla Sun Life International Equity Fund -
Plan B - Growth - Regular Plan
106876nav: 17.6037
106876 source: http://www.amfiindia.com/
106876success: 1
106876 symbol: 106876


I have also attached a screenshot of getting a quote from within gnucash -
don't forget to add your AlphaVantage API key first as explained here:
https://wiki.gnucash.org/wiki/Online_Quotes


DETAILED INSTRUCTIONS
=
Windows 10 Version 1903

Download gnucash 4.1 for Windows 10 from:
https://sourceforge.net/projects/gnucash/files/gnucash%20(stable)/4.1/gnucash-4.1.setup.exe

Verify the checksum from https://www.gnucash.org/news.phtml
We are expecting:
"836b36be639caf61321c2df24dda48691e57ddeb6b7aa13db49f8eddd5b096e0" for
gnucash-4.1.setup.exe

08/17/2020  12:56 PM  ..
08/17/2020  12:56 PM   148,789,209 gnucash-4.1.setup.exe

C:>certutil -hashfile gnucash-4.1.setup.exe SHA256
SHA256 hash of gnucash-4.1.setup.exe:
836b36be639caf61321c2df24dda48691e57ddeb6b7aa13db49f8eddd5b096e0
CertUtil: -hashfile command completed successfully.


Download strawberry perl from http://strawberryperl.com/
http://strawberryperl.com/download/5.30.2.1/strawberry-perl-5.30.2.1-64bit.msi

08/17/2020  01:04 PM  .
08/17/2020  01:04 PM   106,541,628 strawberry-perl-5.30.2.1-64bit.msi

C:>perl -v
This is perl 5, version 30, subversion 2 (v5.30.2) built for
MSWin32-x64-multi-thread

C:>cd "C:\Program Files (x86)\gnucash\bin"

C:\Program Files (x86)\gnucash\bin>perl gnc-fq-check

You need to install the following Perl modules:
  Finance::Quote

Use your system's package manager to install them,
or run 'gnc-fq-update' as root.
missing-lib

C:\Program Files (x86)\gnucash\bin>perl gnc-fq-update
Fetching with LWP:
http://cpan.strawberryperl.com/authors/01mailrc.txt.gz
Fetching with LWP:
http://cpan.strawberryperl.com/modules/02packages.details.txt.gz
Fetching with LWP:
http://cpan.strawberryperl.com/modules/03modlist.data.gz
Creating database file ... Done!
Running install for module 'Date::Manip'
Fetching with LWP:
http://cpan.strawberryperl.com/authors/id/S/SB/SBECK/Date-Manip-6.82.tar.gz
Fetching with LWP:
HASH(0x5250c90)authors/id/S/SB/SBECK/CHECKSUMS
Fetching with LWP:
HASH(0x5250c90)authors/id/S/SB/SBECK/CHECKSUMS.gz
Fetching with LWP:
http://cpan.strawberryperl.com/authors/id/S/SB/SBECK/CHECKSUMS
Checksum for
C:\Strawberry\cpan\sources\authors\id\S\SB\SBECK\Date-Manip-6.82.tar.gz ok
Configuring S/SB/SBECK/Date-Manip-6.82.tar.gz with Makefile.PL
Checking if your kit is complete...
Looks good

~~~ snip ~~~

2900 lines later it should complete successfully with:

Installing C:\Strawberry\perl\site\lib\Finance\Quote\YahooYQL.pm
Installing C:\Strawberry\perl\site\lib\Finance\Quote\ZA.pm
Installing C:\Strawberry\perl\site\lib\Finance\Quote\ZA_UnitTrusts.pm
Appending installation info to C:\Strawberry\perl\lib/perllocal.pod
  ECOCODE/Finance-Quote-1.49.tar.gz
  C:\Strawberry\c\bin\gmake.exe install UNINST=1 -- OK

C:\Program Files (x86)\gnucash\bin>

Hope this helps.

Geoff
=
 



--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___

Re: [GNC] Difficulty with online price retrieval

[D. via gnucash-user]

Odd that the list isn't properly sorted...


 Original Message 
From: "Frank H. Ellenberger" 
Sent: Mon Aug 10 09:16:42 EDT 2020
To: Samantha Payn 
Cc: gnucash-user@gnucash.org
Subject: Re: [GNC] Difficulty with online price retrieval

Samanta,

Am 10.08.20 um 12:53 schrieb Samantha Payn:
>  But you lost me at the next bit.
> 
>PS C:\Users\User> Get-ChildItem -Path
>$Env:USERPROFILE\AppData\Local\Temp -filter gnucash.trace.* |
>Sort-Object -Property Date
>Directory: C:\Users\User\AppData\Local\Temp
>Mode LastWriteTime Length Name
> - -- 
>-a 05/08/2020 11:18 1576 gnucash.trace.WQ4HO0.log
>-a 10/08/2020 11:46 2448 gnucash.trace.VEQEP0.log
>-a 04/08/2020 15:12 0 gnucash.trace.SH4XO0.log
>-a 04/08/2020 12:26 0 gnucash.trace.ZJ8NO0.log
>-a 08/08/2020 12:54 0 gnucash.trace.XLZHO0.log
>-a 07/08/2020 13:19 196 gnucash.trace.WZBOO0.log
>-a 07/08/2020 08:23 0 gnucash.trace.DSTNO0.log
>-a 07/08/2020 08:38 265 gnucash.trace.AH40O0.log
>-a 08/08/2020 13:33 0 gnucash.trace.4DLHO0.log
>-a 05/08/2020 10:02 0 gnucash.trace.QBQJO0.log
>-a 08/08/2020 14:46 3615 gnucash.trace.NZUWO0.log
>-a 07/08/2020 15:58 20233 gnucash.trace.GFEZO0.log
>PS C:\Users\User>
>Where do I substitute the most recent file name from my listing? Which
>listing?
>Awaiting further guidance and thanks again.
>Samantha

In this case it is the 2nd: gnucash.trace.VEQEP0.log created 10/08/2020
11:46

HTH
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
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] Version 4.1 - Check & Repair problem and segfault on close GnuCash

[D. via gnucash-user]

LMGTFY

You *could* go to the non-sanctioned, flawed third party repackager Nabble at 
http://gnucash.1415818.n4.nabble.com/

Or you could go to the official sources at 
https://lists.gnucash.org/mailman/listinfo

Your choice. 

David


 Original Message 
From: Greg Feneis 
Sent: Mon Aug 10 07:21:09 EDT 2020
To: gnucash-user@gnucash.org
Subject: Re: [GNC] Version 4.1 - Check & Repair problem and segfault on close 
GnuCash

How do I access the web version of the mailing list?

Kind regards, Greg Feneis
(Pixel 3)


On Sun, Aug 9, 2020, 23:37 Michael Hendry  wrote:

>
> >>
> PS Found the links to the threads on the Web version of the mailing list,
> and have included these in the entries in Bugzilla.
> ___
> 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] Close account

[D. via gnucash-user]

Set it as a Placeholder account,  which freezes the account for new 
transactions, and optionally set it to hidden. Both are on the Account->Edit 
screen. 


 Original Message 
From: Chris Taylor 
Sent: Fri Aug 07 20:44:54 EDT 2020
To: gnucash-user@gnucash.org
Subject: [GNC] Close account

how is the best way to mark an account closed or can you
___
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] help to set up equity sub-accounts opening balances

[D. via gnucash-user]

Marilyn, 

Part of your problem, I think, is based on a misunderstanding of terminology. 
You keep referring to these virtual amounts as "Equity" when really they are 
*Assets*. In the gnucash world, these funds should be placed as Assets 
accounts. That you have set them aside in your mind as "not-assets" doesn't 
change this fact.

As for the fact that some of your virtual money is "in" one account, and more 
is "in" another, well, it's all virtual anyway. The reason for placing these 
virtual accounts as sub accounts of one real account is to make reconciliation 
of the real account easier, through the option to reconcile sub accounts in the 
reconcile process. Maintaining the virtual cash in multiple real accounts will 
defeat this, however. 

The only option I see, should you really insist on your approach, would involve 
some convolution wherein you "transfer" amounts from the respective real 
accounts manually (using a standard naming scheme perhaps) into the separate 
virtual asset account created for this. This would allow you to track the 
"balance" in your virtual account despite holding the funds in multiple real 
accounts. However, reconciling the real accounts would require you to remember 
to omit all of these virtual transfers. And then you'd have to work out how you 
wanted to reconcile the virtual transfers, so that your real reconciliations 
would continue to make sense. 

Best, 
David T. 




 Original Message 
From: Marilyn Graves Kimple via gnucash-user 
Sent: Fri Aug 07 07:11:50 EDT 2020
To: Adrien Monteleone 
Cc: GnuCash Users Group 
Subject: Re: [GNC] help to set up equity sub-accounts opening balances

>I wasn't quite clear if this is 'virtual' earmarking of funds or
>real-world separate accounts. (like a savings account, or as with some
>checking accounts, a special designation amount)

>If this is just for your informational purposes to see how much you've
>set aside, (but the money doesn't *yet* leave the physical checking
>account) then create a sub-account of checking and do a transfer between
>the parent and sub.
I thank you all for your suggestions, and this sounds like the simplest. These 
are indeed "virtual" accounts; the only problem is that they include funds from 
both my checking & savings "real-world" accounts. Maybe I could set them all up 
under savings and show a 'virtual deficit' which would represent funds that are 
actually in checking?
I tried making sub-accounts under the Equity>Opening Balance and entering 
initial amounts for my virtual accounts backwards so they would show up as 
negatives (part of the opening balance), but of course I could not write a 
check and credit the amount to both checking (asset) and a virtual account, so 
that did not work.
I miss my old (ancient) program, where I could set up equity accounts as 
"funds", allowing me to post to them as I would income or expense accounts.
How do others use Equity sub-accounts? Do they have to correspond to a 
"real-world" account?
Thanks-- mgk
___
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] Installing on Windows 10 (with Defender)

[D. via gnucash-user]

David, 

Gnucash doesn't use an MSI file. It's an EXE. 

Unfortunately for Peter's brother in law, I cannot help, since my Windows 10 
installation was without complication. 

David T. 


 Original Message 
From: David Carlson 
Sent: Mon Aug 03 10:44:08 EDT 2020
To: Peter West 
Cc: Gnucash Users 
Subject: Re: [GNC] Installing on Windows 10 (with Defender)

I am assuming your brother-in-law took the easy route, downloaded and tried
to install the .msi version.  Perhaps the Windows Defender interference
messed up the install .  The usual advice for Windows is to use the Windows
Control Panel Program removal feature to remove the GnuCash program,
download a fresh copy of the Windows version from the website, then, since
Defender caused a problem, disable it before running the installation
again.

David Carlson

On Sun, Aug 2, 2020 at 11:43 PM Peter West  wrote:

> My brother-in-law in the US (I’m in Oz) tried on my recommendation to
> install Gnucash 4.1 from the gnucash.org  site.
>
> The install was initially blocked by Defender, but he managed to overcome
> that. When he tried to run the program, the complaint was about missing
> .dll files in C:\Program files (x86)\gnucash\bin\
>
> As I don’t know about Windows 10, can someone please tell me the way to
> perform the install correctly in this case?
>
> Thanks.
>
>
>
> --
> Peter West
> p...@pbw.id.au 
> When he went ashore he saw a great crowd, and he had compassion on them
> and healed their sick.
>
> ___
> 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.
>


-- 
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
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] Export as PDF vs Print to PDF

[D. via gnucash-user]

Adrien,

As I understand it, the problem lies with the underlying WebKit rendering 
engine, which is known to have this problem on both Windows and Mac, as you've 
noted. Exporting pdf will only generate a pdf with the problem embedded in it. 
The solution is, as you've also noted, to export html and load that into a 
browser for printing. 

David T. 


 Original Message 
From: Adrien Monteleone 
Sent: Tue Jul 28 06:23:06 EDT 2020
To: gnucash-u...@lists.gnucash.org
Subject: Re: [GNC] Export as PDF vs Print to PDF

Long standing problem for Mac for sure and I think Windows as well.

A work around if you want to use export (I thought they provided the 
same result) is to open that export in a web browser and print from 
there. I've heard of decent mileage from Firefox and Chrome. I don't 
know about Safari, Edge, etc.

Though I think the work around involved the HTML export, not PDF export.

Regards,
Adrien

On 7/27/20 4:34 PM, Mike Brady wrote:
> Was recently doing some reports with v. 3.10 (yes, I know, update?), and
> found that "Export as PDF" doesn't respect page boundaries. Result is
> that some lines are broken horizontally at the bottom & top of pages.
> Doesn't happen, though, if I "Print to PDF" using a suitable (Windows
> 10) operating system driver to create a PDF from the print image. Is
> this an oversight? Should "Export to PDF" be more like "Print to PDF?"
> Thanks.
> 
> Updating is something I'm holding off about unless there's a real reason
> to do so, because the Portable Apps version is still stuck in the 3.x
> range. I found out in the past that when upgrading across a major
> version the files become incompatible with a lower one. So I have to
> wait for the Portable Apps version to update before I can do the rest.

___
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] Still no access to Gnucash Nabble

[D. via gnucash-user]

Jimmy, 

Nabble is not GnuCash. Go ask Nabble.


 Original Message 
From: J R via gnucash-user 
Sent: Thu Jul 23 18:10:00 EDT 2020
To: "gnucash-user@gnucash.org" 
Subject: [GNC] Still no access to Gnucash Nabble

After 6 weeksI still cannot post or reply on 
"http://gnucash.1415818.n4.nabble.com/"I send a message for Access request and 
request permission to postI get no responce to emailI don't like using a email 
client
I have closed  my account and then reopened new account
Jimmy
___
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] Getting prices at startup

[D. via gnucash-user]

If you have a "gnucash.bat" somewhere on your hard drive, you could just change 
the line there to use the new executable. Or create yourself a new bat file 
with the two commands in it-- gnucash-cli.exe on the first, and gnucash.exe on 
the second. 

David


 Original Message 
From: Rich Stanton 
Sent: Sat Jul 18 07:18:04 EDT 2020
To: "'D.'" 
Cc: 'Flyeta via gnucash-user' 
Subject: RE: [GNC] Getting prices at startup

How bizarre, I don't remember ever setting that up. Either way, looks like the 
new way is to go with gnucash-cli.exe --quotes get 
file://C:/path/to/file.gnucash, so I'll play with that for now.

Thanks!

> -Original Message-
> From: D. 
> Sent: 17 July 2020 21:05
> To: Rich Stanton 
> Cc: Flyeta via gnucash-user 
> Subject: Re: [GNC] Getting prices at startup
> 
> Given that GnuCash doesn't have such a feature implemented (see
> https://bugs.gnucash.org/show_bug.cgi?id=628734), I imagine that at some
> point in the past, you created a script that first invoked the command line
> update process before invoking the program itself. With the latest upgrade,
> the command for this was changed, which would result in no action in your
> script. At least, that's what I'd look at.
> 
> David T.
> 
> 
>  Original Message 
> From: Rich Stanton 
> Sent: Fri Jul 17 12:54:22 EDT 2020
> To: gnucash-user@gnucash.org
> Subject: [GNC] Getting prices at startup
> 
> Hi, I've been a long time user, and have had automatic prices set up for ages.
> Normally, they update automatically at startup, but just recently, although I
> still get a black command box that pops up (as though prices were being
> retrieved), they aren't updated. If I manually hit the 'get prices'
> button, they work fine, so they are set up correctly. I can't find a specific
> option to enable/disable retrieval at startup - is there one, that I might 
> have
> turned off somehow?
> 
> 
> 
> 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] Getting prices at startup

[D. via gnucash-user]

Given that GnuCash doesn't have such a feature implemented (see 
https://bugs.gnucash.org/show_bug.cgi?id=628734), I imagine that at some point 
in the past, you created a script that first invoked the command line update 
process before invoking the program itself. With the latest upgrade, the 
command for this was changed, which would result in no action in your script. 
At least, that's what I'd look at. 

David T. 


 Original Message 
From: Rich Stanton 
Sent: Fri Jul 17 12:54:22 EDT 2020
To: gnucash-user@gnucash.org
Subject: [GNC] Getting prices at startup

Hi, I've been a long time user, and have had automatic prices set up for
ages. Normally, they update automatically at startup, but just recently,
although I still get a black command box that pops up (as though prices were
being retrieved), they aren't updated. If I manually hit the 'get prices'
button, they work fine, so they are set up correctly. I can't find a
specific option to enable/disable retrieval at startup - is there one, that
I might have turned off somehow? 

 

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] Prevent register from auto-duplicating transactions?

[D. via gnucash-user]

My suggestion in this scenario is to *begin* the description with the variable 
text. That way, you type fewer characters. For example, you could have 
"Dividends - AAPL" or you could have "AAPL - Dividends" The latter requires 
only a couple of characters' typing to get the unique entry.?.


 Original Message 
From: "Stephen M. Butler" 
Sent: Sun Jul 12 23:54:17 EDT 2020
To: gnucash-user@gnucash.org
Subject: Re: [GNC] Prevent register from auto-duplicating transactions?

Use a slightly different description.  (store name + 4) for the 4 line
split and (store name + 1) for the single line split.

On 7/12/20 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
> register for my credit card:
> Description = (store name)
> Click the Split button.
> In each of four splits, Memo = details of what I bought, Account =
> (account for that type of expense), Debit = (amount)
> In the fifth split, Memo = blank, Account = (credit card), credit = (total)
> All of that is fine. (I don't divide that purchase into four
> transactions, because I want the credit amount to match what will be
> shown on my credit-card statement.)
>
> But here's the problem. On the next trip to that store, I buy only food.
> What I want to do, in the account register for my credit card, is enter
> Description = (store name), Transfer = "Groceries", Credit = (amount).
> But as soon as I enter the store name in description, GC creates five
> splits that duplicate that previous shopping trip. I have to click Split
> and manually delete three splits, one at a time.
>
> Is there some way to tell GC "don't finish this one transaction for me"?
>
> Or, almost as good, when it does do the auto-complete, is there some way
> to tell it "not this time, thank you", and have it delete all of what it
> helpfully created for me??
>

-- 
Stephen M Butler, PMP, PSM
stephen.m.butle...@gmail.com
kg...@arrl.net
253-350-0166
---
GnuPG Fingerprint:  8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8

___
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] Prevent register from auto-duplicating transactions?

[D. via gnucash-user]

I've often struggled with this problem as well. Another way to handle it would 
be to create two different transaction descriptions, each beginning with a 
different descriptive string or code, like "G- Store" and "M- Store". You could 
go with "Store- G" etc., but then you have to type more...

David T.


 Original Message 
From: John Ralls 
Sent: Sun Jul 12 16:03:18 EDT 2020
To: Stan Brown 
Cc: GnuCash User List 
Subject: Re: [GNC] Prevent register from auto-duplicating transactions?

Sort of. When it autocompletes hit right-arrow to move to the end of the 
autocompleted string and add an extra character, then tab. That will prevent 
GnuCash from copying in the transaction and you can fill in the account and 
credit/debit fields, then tab back to description and remove 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
> register for my credit card:
> Description = (store name)
> Click the Split button.
> In each of four splits, Memo = details of what I bought, Account =
> (account for that type of expense), Debit = (amount)
> In the fifth split, Memo = blank, Account = (credit card), credit = (total)
> All of that is fine. (I don't divide that purchase into four
> transactions, because I want the credit amount to match what will be
> shown on my credit-card statement.)
> 
> But here's the problem. On the next trip to that store, I buy only food.
> What I want to do, in the account register for my credit card, is enter
> Description = (store name), Transfer = "Groceries", Credit = (amount).
> But as soon as I enter the store name in description, GC creates five
> splits that duplicate that previous shopping trip. I have to click Split
> and manually delete three splits, one at a time.
> 
> Is there some way to tell GC "don't finish this one transaction for me"?
> 
> Or, almost as good, when it does do the auto-complete, is there some way
> to tell it "not this time, thank you", and have it delete all of what it
> helpfully created for me??
> 
> -- 
> Regards,
> Stan Brown
> Tehachapi, CA, USA
> https://BrownMath.com
> https://OakRoadSystems.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] Reconcile also opens Interest Payment box?

[D. via gnucash-user]

John, 

Count me as a supporter of removing these. I long ago disabled that feature on 
every account. I have always found it easier to enter these transactions 
myself, especially since I found that the dialog would present a strange subset 
of accounts that I would override every time. Simplifying in this case makes 
sense. 

David T.


 Original Message 
From: John Ralls 
Sent: Sun Jul 12 12:38:32 EDT 2020
To: Adrien Monteleone 
Cc: gnucash-u...@lists.gnucash.org
Subject: Re: [GNC] Reconcile also opens Interest Payment box?

Frank and I have both opined on https://bugs.gnucash.org/show_bug.cgi?id=797854 
that the whole interest payment as part of reconciling is stupid. I want to add 
to that opinion that so is the payment transfer that optionally pops up when 
one finishes reconciling a credit card account. It's a lot of program 
complexity that relieves the user of very little work indeed: Those interest 
and payment transactions can just as easily--maybe more easily--be created in 
the register before and after reconciling, and in the case of interest they're 
an obvious candidate for a scheduled transaction.

But that's a UI change and UI changes tend to generate heated disagreement. I 
want to get that out of the way up front: Who here objects to removing the 
interest and payment transfer automatic popups and the interest payment button 
on the reconcile info dialog, and what compelling reason do you 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 bug: https://bugs.gnucash.org/show_bug.cgi?id=797855 for the button issue 
> on the two dialogs.
> 
> Feel free to combine them if you like. I wasn't sure of developers' intent 
> with the global preference, so I filed them separately.
> 
> Regards,
> Adrien
> 
> On 7/10/20 5:52 PM, Jean Laroche wrote:
>> If you open a bug about it, I can try to fix that (move things to the right 
>> place etc). At the very least, the global option should be either fixed, or 
>> removed.
>> Jean
>> On 7/10/20 3:35 PM, Adrien Monteleone wrote:
>>> For consistency, that very wide button should probably either be changed to 
>>> a checkbox, then moved or copied to the Account Edit page as a per-account 
>>> preference. (it could remain in the dialog for discoverability I suppose, 
>>> which is what I mean by 'copied') One could change it in either place, but 
>>> ideally, it should be in one place.
>>> 
>>> I'm not sure a global preference (especially one that is ignored) is 
>>> necessary if each account can be set separately.
>>> 
>>> Regards,
>>> Adrien
>>> 
>>> On 7/10/20 5:16 PM, lj wrote:
 I figured it out. Duh.
 
 There is a button on the Reconcile dialog that says "Enter Interest 
 Payment". In addition to letting you enter an interest payment, clicking 
 that button sets a per-account flag to always prompt for an interest 
 payment when you reconcile.
 
 On the Interest Payment dialog, there is a button "No Auto Interest 
 Payments for this Account". (It's very wide, and I didn't realize it was a 
 button.) That cancels the dialog, and also clears the per-account flag so 
 GnuCash will no longer prompt for interest payment when you reconcile.
 
 And the global preference Register, Reconciling, Automatic interest 
 transfer? It does NOTHING at all. It sets a preference flag which is never 
 used. It's supposed to be the default for accounts without the 
 auto-interest-payment flag, but it doesn't work. Note that in 
 libgnucash/engine/Account.cpp, the function 
 xaccAccountGetAutoInterestXfer() ignores its default_value argument.
>>> 
>>> ___
>>> 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:
> 

Re: [GNC] Net Worth Linechart report issue

[D. via gnucash-user]

Attempting a five year and a ten year daily net worth linechart on Windows 10 
and GC 4.0 yield no display issues either in app or in browser (Chrome and Edge 
tested). 

David


 Original Message 
From: Adrien Monteleone 
Sent: Fri Jul 10 12:04:31 EDT 2020
To: gnucash-user@gnucash.org
Subject: Re: [GNC] Net Worth Linechart report issue

Is there something keeping you from upgrading to 4.0?

I don't have a Windows installation to test, but I can confirm that on 
Mac, using 4.0, a one-year/daily chart appears fine.


Regards,
Adrien

On 7/9/20 7:25 PM, Lipp F. wrote:
>   GnuCash 3.10 on Windows.
> 
> The  Net Worth Linechart report is not properly positioned on the canvas.
> 
> - when displayed in GnuCash about 15% of the canvas is not used on the
> right side part of the canvas and the left side of the chart is missing.
> - when exported and opened in a browser the opposite happens, the left side
> is missing and 15% right side not utilized.
> 
> This is only happening for high resolution charts - one year / daily as an
> example.  Low resolution charts,  one year / monthly as an example, seem to
> be working fine.

___
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] Gnucash - user: Google result

[D. via gnucash-user]

Both appear on the list archives. 

https://lists.gnucash.org/pipermail/gnucash-user/2020-July/091938.html
https://lists.gnucash.org/pipermail/gnucash-user/2020-July/091939.html





 Original Message 
From: Adrien Monteleone 
Sent: Tue Jul 07 13:32:08 EDT 2020
To: gnucash-user 
Subject: Re: [GNC] Gnucash - user: Google result

The two messages about your changes to the intro text and stub page, and the 
other where you thought those changes were rolled back. (quoted below)

Neither was sent to the list.

Nor was the message I’m replying to.

Regards,
Adrien

> On Jul 7, 2020 w28d189, at 12:15 PM, D.  wrote:
> 
> "those"?
> 
> 
>  Original Message 
> From: Adrien Monteleone 
> Sent: Tue Jul 07 12:53:18 EDT 2020
> To: gnucash-user 
> Subject: Re: [GNC] Gnucash - user: Google result
> 
> I see them still. And they might just do the trick.
> 
> Regards,
> Adrien
> 
> p.s. -you forgot to send those to the list?
> 
>> On Jul 7, 2020 w28d189, at 11:45 AM, D.  wrote:
>> 
>> Looks like I was slow on the uptake, and my changes have been rolled back.
>> 
>> 
>>  Original Message 
>> From: "D. via gnucash-user" 
>> Sent: Tue Jul 07 12:38:09 EDT 2020
>> 
>> I have modified the Mailing lists page (which opens ironically with the 
>> introductory phrase "The Official Forum") to include a brief sentence 
>> explicitly juxtaposing mailing lists from forums, with a new link to a 
>> simple stub page at "GnuCash Forum" that refers back to the mailing lists 
>> page. Perhaps this will short circuit the "gnucash forum" Google search.


___
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] Gnucash - user: Google result

[D. via gnucash-user]

"those"?


 Original Message 
From: Adrien Monteleone 
Sent: Tue Jul 07 12:53:18 EDT 2020
To: gnucash-user 
Subject: Re: [GNC] Gnucash - user: Google result

I see them still. And they might just do the trick.

Regards,
Adrien

p.s. -you forgot to send those to the list?

> On Jul 7, 2020 w28d189, at 11:45 AM, D.  wrote:
> 
> Looks like I was slow on the uptake, and my changes have been rolled back.
> 
> 
>  Original Message ----
> From: "D. via gnucash-user" 
> Sent: Tue Jul 07 12:38:09 EDT 2020
> 
> I have modified the Mailing lists page (which opens ironically with the 
> introductory phrase "The Official Forum") to include a brief sentence 
> explicitly juxtaposing mailing lists from forums, with a new link to a simple 
> stub page at "GnuCash Forum" that refers back to the mailing lists page. 
> Perhaps this will short circuit the "gnucash forum" Google search.

___
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] Gnucash - user: Google result

[D. via gnucash-user]

Looks like I was slow on the uptake, and my changes have been rolled back. 


 Original Message 
From: "D. via gnucash-user" 
Sent: Tue Jul 07 12:38:09 EDT 2020
To: Adrien Monteleone 
Cc: David Reiser via gnucash-user 
Subject: Re: [GNC] Gnucash - user: Google result

I have modified the Mailing lists page (which opens ironically with the 
introductory phrase "The Official Forum") to include a brief sentence 
explicitly juxtaposing mailing lists from forums, with a new link to a simple 
stub page at "GnuCash Forum" that refers back to the mailing lists page. 
Perhaps this will short circuit the "gnucash forum" Google search. 


 Original Message 
From: Adrien Monteleone 
Sent: Tue Jul 07 11:14:46 EDT 2020
To: gnucash-user 
Subject: Re: [GNC] Gnucash - user: Google result

Maybe so!

Maybe retitle the Mailman page that way?

Either or both might work eventually. (and you can ask various engines to 
re-index though they usually do so fairly often anyway)

Possibly set the excerpt text of the other official hits to include ‘forum’ 
somewhere.

Or just let it ride...

Regards,
Adrien

> On Jul 7, 2020 w28d189, at 10:06 AM, Derek Atkins  wrote:
> 
> We could make a Wiki page with the title "GnuCash Forum"  :-D
> 
> -derek


___
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] Gnucash - user: Google result

[D. via gnucash-user]

I have modified the Mailing lists page (which opens ironically with the 
introductory phrase "The Official Forum") to include a brief sentence 
explicitly juxtaposing mailing lists from forums, with a new link to a simple 
stub page at "GnuCash Forum" that refers back to the mailing lists page. 
Perhaps this will short circuit the "gnucash forum" Google search. 


 Original Message 
From: Adrien Monteleone 
Sent: Tue Jul 07 11:14:46 EDT 2020
To: gnucash-user 
Subject: Re: [GNC] Gnucash - user: Google result

Maybe so!

Maybe retitle the Mailman page that way?

Either or both might work eventually. (and you can ask various engines to 
re-index though they usually do so fairly often anyway)

Possibly set the excerpt text of the other official hits to include ‘forum’ 
somewhere.

Or just let it ride...

Regards,
Adrien

> On Jul 7, 2020 w28d189, at 10:06 AM, Derek Atkins  wrote:
> 
> We could make a Wiki page with the title "GnuCash Forum"  :-D
> 
> -derek


___
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] Gnucash-User

[D via gnucash-user]

David C.

I know what nabble is, and I know that nabble is not gnucash-user. 

People who use nabble to experience gnucash-user as a forum should pay 
attention to this fact, and place the blame for nabble's failings where they 
belong: with nabble. *

Personally, I find nabble's penchant for never letting me leave their site when 
I choose ("Don't go yet! Don't you want to use our resume service?") to be 
irritating in the extreme, and avoid it like the plague. But, hey to each their 
own.

David T.

* For those who say that these users are unaware of the difference between 
nabble and gnucash-user, I will note that every message that goes through the 
gnucash list server addresses this in the tag line.

On Jul 6, 2020, 18:10, at 18:10, David Cousens  wrote:
>David T,
>
>It is just a web interface to the mail listserver. I find it has some
>advantages in presentation of threaded posts
>particularly when looking back over archived material compared with my
>mail client. Someone has updated the signup
>instructions some time ago to point out that you have to be signed up
>to both the Nabble interface and the GnuCash
>mailing list and the the Nabble signup can now send an email to signup
>to the GnuCash mail listserver when you signup to
>Nabble. It otherwise operates independently of the gnucash mail
>listserver. It normally only creates a problem for the
>gnucash list when new users sign up without reading the instructions
>fully first.
>
>This appears to be some change in the Nabble access rules, possibly in
>a software update, which prevents registered
>users from creating new posts. The problem is whoever is administering
>it, if anyone, does not appear to be monitoring
>the emails to the administrator from users as I have now sent 5-10 over
>the last few weeks. Anyone can create a Nabble
>interface to any mailing list which seems an OK idea, until you get an
>orphan which no longer functions. There seems to
>be no way to contact whoever is running the servers which feed Nabble
>to point out that a particular mail listserver
>interface has been orphaned.
>
>I think it would probably be better to bring it into the fold so that
>the Gnucsh  mailing list administrators have
>someone to contact when the occasional problem like this occurs
>
>Nabble is still OK for browsing and archive searching but not posting
>so for the moment we have no choice but to get our
>Kool ade direct from the source rather than from the Soda Stream. The
>downside for me is I have to remember to swap
>email signatures from my professional persona to my gnucash persona
>when I swap hats.
>
>David Cousens
>
>On Sun, 2020-07-05 at 20:23 -0400, D. wrote:
>> I guess all that would recommend abandoning nabble altogether, and
>drinking the gnucash Kool ade directly from
>> lists.gnucash.org... just saying.?.
>> 
>> 
>>  Original Message 
>> From: David Cousens 
>> Sent: Sun Jul 05 17:01:40 EDT 2020
>> To: Liz , John Ralls 
>> Cc: GnuCash-User 
>> Subject: Re: [GNC] Gnucash-User
>> 
>> Liz, Adrian,
>> 
>> The Nabble interface seems to have a problem at the moment, I have
>been unable to post from it for a couple of weeks
>> now
>> and have had the same problem of no response to messages from whoever
>is administering it.
>> 
>> David Cousens
>> 
>> On Sun, 2020-07-05 at 20:08 +1000, Liz wrote:
>> > On Sat, 4 Jul 2020 07:54:56 -0700
>> > John Ralls  wrote:
>> > 
>> > > > 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 messages trying
>to
>> > > > get permission but with no response from the moderator.
>> > 
>> > Sorry Adrian, but I am not stopping you from posting. 
>> > I don't know where you have been sending messages requesting
>> > permission, but they haven't reached me as moderator.
>> > 
>> > Were you sending from Nabble beforehand? We don't control what
>happens
>> > with Nabble. Posts made through Nabble come straight through if the
>> > writer is registered with the Gnucash mailing list involved,
>otherwise
>> > they sit in the queue for me to check.
>> > At the bottom of every email from the Gnucash server is the
>> > instructions on how to join.
>> > https://lists.gnucash.org/mailman/listinfo/gnucash-user
>> > 
>> > Liz
>> > with Moderator hat in place.
>> > ___
>> > 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 

Re: [GNC] Help required

[D. via gnucash-user]

2.6.13 was released in 2016. While the user may not have engaged with the 
community actively over that time, I'd hesitate to refer to them as a "newbie."


 Original Message 
From: "w...@theprescotts.com" 
Sent: Mon Jul 06 10:57:21 EDT 2020
To: David Carlson 
Cc: GnuCash Users 
Subject: Re: [GNC] Help required

I agree.

Will

On 2020 Jul 6, at 07-06 09:40:50, David Carlson  
wrote:

This thread was started by a newbie who is still learning how it works.  That 
person doesn't need the extra burden of finding things changing, sometimes for 
the worse, while still learning.  

On Mon, Jul 6, 2020 at 9:33 AM w...@theprescotts.com 
mailto:w...@theprescotts.com>> wrote:
David,

There is no one answer for everybody but I find it is better to pick a time 
when I have no emergencies and update, even if it will "fix something that 
ain't broke". 

Either you skip all updates until you have to, then it is a pain because you 
are way out of date and there may be no direct update path.
Or you break working systems with updates you may not need right now and it is 
pain fixing things that weren't broken.

The only guarantee is that it will be a pain either way.

Will

On 2020 Jul 6, at 07-06 08:35:03, David Carlson mailto:david.carlson@gmail.com>> wrote:

Will,

In many. Cases it is better to follow the the adage "If it ain't broke, don't 
fix it."

David Carlson 

On Mon, Jul 6, 2020, 7:55 AM w...@theprescotts.com 
mailto:w...@theprescotts.com>> wrote:
"Decide from those whether there are new features that you want. If not,
there is no reason to abandon a release that you are using successfully."

I would disagree. I think it is better to keep all software current. You may 
not want new features in the current latest release, but down the road there 
may be a release with features you want. If your software is many versions out 
of date, updating is always harder.

Will
___
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.



-- 
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
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] Gnucash-User

[D. via gnucash-user]

I guess all that would recommend abandoning nabble altogether, and drinking the 
gnucash Kool ade directly from lists.gnucash.org... just saying.?.


 Original Message 
From: David Cousens 
Sent: Sun Jul 05 17:01:40 EDT 2020
To: Liz , John Ralls 
Cc: GnuCash-User 
Subject: Re: [GNC] Gnucash-User

Liz, Adrian,

The Nabble interface seems to have a problem at the moment, I have been unable 
to post from it for a couple of weeks now
and have had the same problem of no response to messages from whoever is 
administering it.

David Cousens

On Sun, 2020-07-05 at 20:08 +1000, Liz wrote:
> On Sat, 4 Jul 2020 07:54:56 -0700
> John Ralls  wrote:
> 
> > > 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 messages trying to
> > > get permission but with no response from the moderator.
> 
> Sorry Adrian, but I am not stopping you from posting. 
> I don't know where you have been sending messages requesting
> permission, but they haven't reached me as moderator.
> 
> Were you sending from Nabble beforehand? We don't control what happens
> with Nabble. Posts made through Nabble come straight through if the
> writer is registered with the Gnucash mailing list involved, otherwise
> they sit in the queue for me to check.
> At the bottom of every email from the Gnucash server is the
> instructions on how to join.
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> 
> Liz
> with Moderator hat in place.
> ___
> 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.
-- 
Dr David R Cousens
B.Sc, M.Prof. Acc., Ph.D., G.C.Ed

___
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] Cost Basis Report on Transaction

[D via gnucash-user]

Well, if you track your gains, it's simple to track using a transaction report.

On Jul 2, 2020, 18:59, at 18:59, gnuc...@runbox.com wrote:
>I'm evaluating gnuCash for tracking investments.  For my taxes I need a
>report of all stock sales during the year, showing the cost basis. 
>Perhaps even a report of the lots used in a sale.  I cannot find any of
>these on Standard Reports.  Am I missing it somewhere?  Are these
>reports called something different?
>___
>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] Split transaction on invoices in foreign currencies

[D. via gnucash-user]

Antonio, 

Your original description of the situation was clear, and the scenario John and 
Frank and I outlined was accurate. 

The point is this: if you enter the transaction from the GBP account, you can 
add the bank fee split without invoking the second exchange rate dialog. 


 Original Message 
From: Antonio Roberts 
Sent: Thu Jul 02 13:24:00 EDT 2020
To: "D." 
Cc: Adrien Monteleone , Vinayak Vatsal via 
gnucash-user 
Subject: Re: [GNC] Split transaction on invoices in foreign currencies

Hi David,

Yes, I think I confused you a bit with my description. Just so we're
on the same page I'll try.

I've transferred (as an example) €200 to my GBP account and it's now
£177. I had a £10 bank charge and so I'm trying to split the £177 but
when I do this it's asking me to do a currency conversion.

I guess 'cause the transaction I'm splitting originated from a EUR
transaction it's asking for a conversion.

On Thu, 2 Jul 2020 at 18:11, D.  wrote:
>
> Antonio,
>
> I think the point that John and Frank were making is that if you *entered* 
> the transaction in the EUR account, then it will have EUR as its currency, 
> and you will be asked to provide an exchange rate for every GBP split that is 
> subsequently entered, regardless of your current register. When I read your 
> original post, it looks like you created the transaction while in the EUR 
> account (you stated "transferred the EUR into my GBP Bank", which strongly 
> implies this). If this is in fact what you did, then you can either enter the 
> same exchange rate as John suggested, or enter the transaction from the GBP 
> account and avoid the subsequent request.
>
> David
>
>
>  Original Message 
> From: Antonio Roberts 
> Sent: Thu Jul 02 12:44:26 EDT 2020
> To: Adrien Monteleone 
> Cc: GnuCash Users 
> Subject: Re: [GNC] Split transaction on invoices in foreign currencies
>
> > Unless I read the original post wrong, and the OP could clarify, but it 
> > looks like they were entering this split in a GBP based account (the GBP 
> > bank account) and adding a GBP split for the bank charge.
>
> Yes, that is correct. I transferred the funds from EUR to GBP account
> and in that transaction line in the GBP account I'm attempting to do a
> split and it's prompting me about currency conversion.
>
> As suggested above I could just do a separate line in the GBP Bank
> Charges expense account but my preference is to split as it shows
> where the charge is inherited from.
>
> Kind regards,
>
> Antonio
>
> On Thu, 2 Jul 2020 at 17:40, Adrien Monteleone
>  wrote:
> >
> > Unless I read the original post wrong, and the OP could clarify, but it 
> > looks like they were entering this split in a GBP based account (the GBP 
> > bank account) and adding a GBP split for the bank charge.
> >
> > 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 in GBP (£) but in this case
> > >> I invoiced someone in EUR (€). Following the advice from here I sent
> > >> up a Bank in EUR, invoiced them in EUR and then transferred the EUR
> > >> into my GBP Bank with the current exchange rate (my bank supplies the
> > >> rate at the time of transaction).
> > >>
> > >> However, this conversion incurred a bank charge in GBP. In GNUcash
> > >> I've gone to my GBP Bank balance to the transaction line to split it
> > >> to deduct the bank transfer. When I do this it's asking me to do a
> > >> currency conversion from EUR to GBP.
> > >>
> > >> The funds are already in the GBP bank so why am I being asked to do
> > >> conversion again? Is there something I've done wrong?
> > >
> > > No, you haven't done anything wrong. Every transaction has a transaction 
> > > currency that's used 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 the EUR 
> > > payment to GBP.
> > >
> > > 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.
>
>
>
> --
> 
> anto...@hellocatfood.com
> http://www.hellocatfood.com
> 
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences 

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

[D. via gnucash-user]

Antonio, 

I think the point that John and Frank were making is that if you *entered* the 
transaction in the EUR account, then it will have EUR as its currency, and you 
will be asked to provide an exchange rate for every GBP split that is 
subsequently entered, regardless of your current register. When I read your 
original post, it looks like you created the transaction while in the EUR 
account (you stated "transferred the EUR into my GBP Bank", which strongly 
implies this). If this is in fact what you did, then you can either enter the 
same exchange rate as John suggested, or enter the transaction from the GBP 
account and avoid the subsequent request.

David


 Original Message 
From: Antonio Roberts 
Sent: Thu Jul 02 12:44:26 EDT 2020
To: Adrien Monteleone 
Cc: GnuCash Users 
Subject: Re: [GNC] Split transaction on invoices in foreign currencies

> Unless I read the original post wrong, and the OP could clarify, but it looks 
> like they were entering this split in a GBP based account (the GBP bank 
> account) and adding a GBP split for the bank charge.

Yes, that is correct. I transferred the funds from EUR to GBP account
and in that transaction line in the GBP account I'm attempting to do a
split and it's prompting me about currency conversion.

As suggested above I could just do a separate line in the GBP Bank
Charges expense account but my preference is to split as it shows
where the charge is inherited from.

Kind regards,

Antonio

On Thu, 2 Jul 2020 at 17:40, Adrien Monteleone
 wrote:
>
> Unless I read the original post wrong, and the OP could clarify, but it looks 
> like they were entering this split in a GBP based account (the GBP bank 
> account) and adding a GBP split for the bank charge.
>
> 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 in GBP (£) but in this case
> >> I invoiced someone in EUR (€). Following the advice from here I sent
> >> up a Bank in EUR, invoiced them in EUR and then transferred the EUR
> >> into my GBP Bank with the current exchange rate (my bank supplies the
> >> rate at the time of transaction).
> >>
> >> However, this conversion incurred a bank charge in GBP. In GNUcash
> >> I've gone to my GBP Bank balance to the transaction line to split it
> >> to deduct the bank transfer. When I do this it's asking me to do a
> >> currency conversion from EUR to GBP.
> >>
> >> The funds are already in the GBP bank so why am I being asked to do
> >> conversion again? Is there something I've done wrong?
> >
> > No, you haven't done anything wrong. Every transaction has a transaction 
> > currency that's used 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 the EUR 
> > payment to GBP.
> >
> > 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.



-- 

anto...@hellocatfood.com
http://www.hellocatfood.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.

Re: [GNC] Bulk moving transactions

[D. via gnucash-user]

Ah. I misread your original post. Having used GnuCash for over 15 years now, I 
am quite familiar with editing accounts, thank you. 

Still, editing a bunch of accounts seems like more complication than just 
editing the transactions themselves. I guess I assume that because a month of 
credit card transactions for me is something like 20 transactions total. 

Best. 


 Original Message 
From: Michael or Penny Novack 
Sent: Wed Jul 01 22:20:08 EDT 2020
To: "D." 
Cc: Matthew Forbis via gnucash-user 
Subject: Re: [GNC] Bulk moving transactions

On 7/1/2020 6:30 PM, D. wrote:
> Of course, once you've edited every transaction to put it into a child 
> account, you could have just changed them all to their proper account 
> altogether, and eliminated the entire account delete set of steps...
>
??   I wasn't talking about editing ANY transactions (or putting 
them in a child account)

I was talking about editing ACCOUNTS. I suspect that perhaps you have 
not edited accounts, changed their names or descriptions, changed what 
their parent was (move in the CoA) etc.

If you have transactions in an account that do not belong there (and no 
transactions that do belong there) and these transactions all should be 
in some different account you CAN "block move" them to that other 
account. You do this by trying to delete the account and when gnucash 
asks what you want done with the transactions (delete or move to another 
account) you select the move option. BUT if that first account has 
children, you have to first move the children elsewhere. You do that not 
by moving the transactions in these accounts but by respecifying what 
account is the parent.

I am frequently adding accounts to my CoAs, adding parent accounts, 
making existing accounts children, etc.

Michael D Novack

PS --- I will give an example. Let's say you have an account "automobile 
expenses" as a parent that has under it things like "fuel", "repairs", 
etc. You now get a second car. What to do? Well I would:

1) create new accounts "auto1 expenses" and "auto2 expenses" and make 
them children of "automobile expenses"

2) edit each of the existing children "fuel", "repairs", etc. changing 
their parent from "automobile expenses" to "auto1 expenses".

3) create new "fuel", "repairs", etc. as children of "auto2 expenses".

<< notice -- no moving of transactions was involved but those expenses 
related to auto 1 are where they belong >>


___
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] Bulk moving transactions

[D. via gnucash-user]

Of course, once you've edited every transaction to put it into a child account, 
you could have just changed them all to their proper account altogether, and 
eliminated the entire account delete set of steps...


 Original Message 
From: Michael or Penny Novack 
Sent: Wed Jul 01 15:56:49 EDT 2020
To: gnucash-user@gnucash.org
Subject: Re: [GNC] Bulk moving transactions

On 7/1/2020 12:07 PM, Adrien Monteleone wrote:
> I’ve twice now seen the advice to delete the account as a bulk move operation.
>
> Yes, that does work.
>
> However, this appears to be a parent account.
>
> Can a parent account be safely deleted without affecting the sub accounts?
>
> I guess I could try, just for kicks, (since I’m not the one needing to move 
> transactions) but my initial suspicion is —that way lies a mess.
>
Did you read what I wrote? The process?

YES, you would want to first make this account NOT be the parent of its 
children. Once you have given them a different parent, they will no 
longer be the children of the account you want to delete.

Create a new placeholder account. Edit each child account so that this 
account is now its parent. THEN delete the account that had been the 
parent.

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
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] [GnuCash 4.0] - Lost customizations from gtk-3.0.css

[D. via gnucash-user]

I tend to agree with GTI on this one; reinventing the CSS style wheel on a 
major upgrade is not likely to win fans. 

I'm also curious whether the Windows install, which uninstalls earlier versions 
automatically, removes these files...

Having been chided recently for remaining at 3.5 rather than updating to each 
new minor version, I drank the Kool aid and upgraded to 4.0. I probably 
shouldn't have.

David T. 


 Original Message 
From: Adrien Monteleone 
Sent: Tue Jun 30 16:17:01 EDT 2020
To: gnucash-user 
Subject: Re: [GNC] [GnuCash 4.0] - Lost customizations from gtk-3.0.css



> On Jun 30, 2020 w27d182, at 1:47 PM, GTI .H  wrote:
> 
> Thanks for the reply Adrien !
> 
> My GOD . . . 
> 
> Ok but, we cannot read all the release announcements in full of all the 
> software we use and that does not solve the issue created and please . . . I 
> also like to earn money and that's where I dedicate my readings.

If you don’t read release announcements and just upgrade anyway, especially 
from one major version to the next, I can’t help you there...

> 
> GTKInspector did not run on Windows, this leaves Windows users out of the 
> game and this leads us to the following question:
> 
> Who likes to keep solving the same issue over and over ?
> This takes a lot of work. Is it worth all this work to be thrown away ?

Remember, these are your customizations of GnuCash. While that can be done, the 
devs have designed the UI a particular way. If you want to customize, you’re on 
your own, though there may be other users who want to do so and they may lend 
some help. (like me, where I can) Although I don’t use Windows now, I do recall 
some apps that people loved to skin and the apps supported this. But I’d bet 
dimes to dollars they occasionally had to break their skin APIs from time to 
time as well.

Adhering to guidelines/standards for the UI is very likely worth it as this 
means customizations will now work more as expected comparable to other GTK 
apps, rather than the user having to learn something special just for GnuCash. 
This does mean that prior customizations may break, but that is because they 
were not ’standard.’


> 
> Well . . . Let's go to possible solutions:
> Is the information here https://wiki.gnucash.org/wiki/GTK3 up to date ?

I can’t speak to that specifically. I’ve just upgraded myself and notice at 
least my font size didn’t stick. My colors remained, however, so it looks like 
the GnuCash color variables still work.

When I get around to tweaking my CSS, I’ll see if that page needs updating. 
(unless someone beats me to it)

> Do we have a template gtk-3.0.css file that works ?

I don’t know if anything in that template changed.

Maybe posting your custom css file would be a better approach so we can see 
what rules you specified that aren’t working. (and of course, let us know, 
maybe with screenshots if possible) what isn’t working with 4.0.

Regards,
Adrien


___
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] QUESTION: transaction classes (tags) like QuickBooks?

[D. via gnucash-user]

Zi,

Welcome to the world of GnuCash. As a user of GnuCash for nearly 15 years, I 
can tell you that it's a feature-rich application with a great user community.

Unfortunately, "classes" is not one of those features. It has been discussed 
for as long as I can remember (e.g., 
https://lists.gnucash.org/pipermail/gnucash-user/2001-October/002612.html, 
https://lists.gnucash.org/pipermail/gnucash-user/2007-July/020856.html, 
https://lists.gnucash.org/pipermail/gnucash-user/2010-December/037498.html), 
and users have an established request for it to be added (see 
https://gnucash.uservoice.com/forums/101223-feature-request/suggestions/1543027-transaction-classifications).

The developers are aware of these requests and discussions, but have not to 
date found time to implement the feature. Since this is a volunteer-run open 
source project, we accept both the limitations of the program and the input of 
interested parties who may be able to add a given feature such as this to the 
program. Examining the threads through the years will yield a number of 
workarounds that users have cobbled together. 

Despite its limitations, GnuCash remains for me a powerful and useful program. 
I heartily recommend it. 

David T. 


 Original Message 
From: Zi via gnucash-user 
Sent: Sun Jun 21 15:18:25 EDT 2020
To: gnucash-user@gnucash.org
Subject: [GNC] QUESTION: transaction classes (tags) like QuickBooks?

Hi

I've used QuickBooks for years and am seriously considering finding a (*non*web 
based) alternative. GnuCash looks very promising, but here's the million-dollar 
question (and yes, I browsed the whole site, the manual, the FAQ, etc. trying 
to find an answer to this question!)

In addition to the accounts and sub-accounts that inform reconciliation and P 
type reporting, is there a way to *class* transactions the way QuickBooks does? 
In other words, can one, while entering a transaction, enter something like the 
following:

(vendor) Local Electricity Provider
(amount) $ total amount of bill
(split line one account) "utilities" AND THEN
(*class*) address of investment property and unit #
(split $ amount for this property)
(split line two account) "utilities"
(*class*) address of *other* investment property and unit #
(split $ amount for *that* property)
etc.
thus allowing a property manager to show expenditures around *each particular* 
property.

OR for instance one travels sometimes, and needs to record the expenses.
Like, the appropriate transaction accounts for such would include "meals", 
"lodging", etc. and the CLASS for each could be "Las Vegas 2020", or "Phoenix 
2019" thus giving one a way to show the expenditures for a *particular* trip.

If GnuCash provides this functionality, I will likely switch over to it! If, 
however, it does not, Intuit must, sadly, still win.

Thanks so much!

Sent from ProtonMail mobile
___
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] Cursor Focus on Wrong Tab

[D. via gnucash-user]

Adrien, 

A couple of reasons: I never hurry updates; I'm lazy; with the turmoil of 
recent versions, waiting seems prudent; I'm in no need of newer features or 
fixes. 

That being said, this behavior is weird enough and sporadic enough that I'm 
still not sure that I'm somehow causing it (as with my troubles getting custom 
reports to load and display), but I am reasonably sure that whatever it is, if 
it exists, it's been around for a long time. Like a snark maybe.

David


 Original Message 
From: Adrien Monteleone 
Sent: Sat Jun 20 04:44:33 EDT 2020
To: GnuCash Users 
Subject: Re: [GNC] Cursor Focus on Wrong Tab

Just out of curiosity, why stay with 3.5 on Win10? I understand some Linux 
users stick with old versions in their repo, and some people still haven’t 
migrated from 2.6, but I don’t see anything compelling with 3.5 over 3.10. I 
wonder if that behavior still exists in 3.10?

Regards,
Adrien

> On Jun 19, 2020 w25d171, at 9:56 PM, D. via gnucash-user 
>  wrote:
> 
> David, 
> 
> Thanks for the reply. Can't believe I forgot version info. GC3.5 Windows 10. 
> 
> I just found another piece of this. I reopened gnucash just now, and it 
> opened with the previous window settings. When I clicked the duplicate button 
> in tab H this time, however, I didn't get the same behavior. It all worked 
> fine. Odd! 
> 
> So, I backed out and recreated my original steps. First, I open my checking 
> account, and locate a transaction with a split connected to my other account. 
> Next, I highlight the split for that account, and jump to that account. Now, 
> when I click the duplicate button, I get the odd behavior. 
> 
> Further experiments yield seemingly random behavior. If I go to a different 
> tab C in the same session, and jump to a new register, tab J, tab B remains 
> the hidden tab to receive focus. If, instead, I restart gnucash and repeat 
> the steps, then tab C is the register with focus-- even if I repeat my steps 
> later in the session from tab B. It's almost as if the first register from 
> which you jump is the special register until restart. 
> 
> I did test to see which transaction would be deleted in this scenario; 
> thankfully, it's the one that's in the visible register. 
> 
> Your problem might correlate to mine, I believe, if your hidden account were 
> on the blank transaction while you were pressing tab and enter; in that case, 
> the hidden register would commit an empty transaction. Your clicks on other 
> entries in the visible register return thre focus to this register. 
> 
> I'll keep digging to see what the edges of this are...


___
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] Old version Gnucash

[D. via gnucash-user]

https://sourceforge.net/projects/gnucash/files/gnucash%20%28stable%29/


 Original Message 
From: James Fuller 
Sent: Fri Jun 19 22:52:20 EDT 2020
To: gnucash-user@gnucash.org
Subject: [GNC] Old version Gnucash

Hi,
Is there a website where I can find and download earlier versions of GnuCash?

Thanks,

James Fuller


Sent from my iPad
___
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] Cursor Focus on Wrong Tab

[D. via gnucash-user]

David, 

Thanks for the reply. Can't believe I forgot version info. GC3.5 Windows 10. 

I just found another piece of this. I reopened gnucash just now, and it opened 
with the previous window settings. When I clicked the duplicate button in tab H 
this time, however, I didn't get the same behavior. It all worked fine. Odd! 

So, I backed out and recreated my original steps. First, I open my checking 
account, and locate a transaction with a split connected to my other account. 
Next, I highlight the split for that account, and jump to that account. Now, 
when I click the duplicate button, I get the odd behavior. 

Further experiments yield seemingly random behavior. If I go to a different tab 
C in the same session, and jump to a new register, tab J, tab B remains the 
hidden tab to receive focus. If, instead, I restart gnucash and repeat the 
steps, then tab C is the register with focus-- even if I repeat my steps later 
in the session from tab B. It's almost as if the first register from which you 
jump is the special register until restart. 

I did test to see which transaction would be deleted in this scenario; 
thankfully, it's the one that's in the visible register. 

Your problem might correlate to mine, I believe, if your hidden account were on 
the blank transaction while you were pressing tab and enter; in that case, the 
hidden register would commit an empty transaction. Your clicks on other entries 
in the visible register return thre focus to this register. 

I'll keep digging to see what the edges of this are...


 Original Message 
From: David H 
Sent: Fri Jun 19 19:41:56 EDT 2020
To: "David T." 
Cc: Gnucash Users 
Subject: Re: [GNC] Cursor Focus on Wrong Tab

Hi David T.,

I seem to recall your original email but at the time I was unsure if what I
was seeing was the same issue and it seems to have gone away anyway, but
maybe it is the same thing :-)

My issue was that I was seeing the odd blank transaction in my savings
account register, coincidentally the register that is always next to the
accounts tab.  Additionally I used to have an issue with duplicating
transactions where the transaction was duplicated ok with today's date but
it seemed to be locked and I couldn't just tab across to update the
amount.  I probably tried both tabbing and hitting enter - perhaps that
created the blank transaction, who knows. I used to have to click on a
different transaction and then come back to the duplicate transaction to
update it for some reason so I was wondering if this was connected to the
blank transaction in some way.  Howsomever these little annoyances seem to
have gone away.  I'm pretty quick to update as soon as a new version comes
out and am currently running the latest test version (3.905) on Win 10, Win
7, MacOS Catalina.  I vaguely recall seeing a blank transaction as recently
as a couple of weeks ago which would have been on version 3.10 when I
opened gnucash on a pc I hadn't used for awhile.

I'm using Gnucash on multiple pc's - Win 7, Win 10, MacOS Catalina (x2),
Ubuntu Linux 20.04 and using dropbox to synchronise the file between
platforms.  My workflow consists of generally having 6 registers open in
addition to the accounts tab and I usually update a single register at a
time from right to left and normally always scroll down after updating each
register so the date in the blank transaction is highlighted when I tab to
the next register if it matters :-)

As I said I haven't seen one of these blank transactions for a while so
they may have gone away altogether.

What version of gnucash are you using and what os ?

Cheers David H.


On Sat, 20 Jun 2020 at 01:32, David T. via gnucash-user <
gnucash-user@gnucash.org> wrote:

> Hello,
>
> I swear I reported troubles with this a long time ago, and I could have
> sworn I added a bug about it. My recollection was that I was the only
> person who could duplicate the issue, and so it never went anywhere
> further. However, I find no evidence on Bugzilla or in the lists. Alas.
> My search skills are clearly lacking.
>
> The issue is this: when I am in Tab "H" and duplicate a transaction by
> clicking the toolbar Duplicate button, once I have concluded the process
> by selecting a new date and pressing Enter, my cursor appears to be in
> tab "H", but is actually on Tab "B" (which is the first register
> account, after the COA). If I attempt to edit the transaction at this
> point, the transaction that receives input is NOT the visible
> transaction in tab H, but rather the hidden transaction on tab B.
>
> In the attached image, "Base Salary" is the aforementioned tab H, in
> which I have just created a new transaction by clicking the Duplicate
> button, choosing today's date and pressing Enter, which has created the
> 06/19/2020 transaction that is visible on screen.
>
> If you look down where the big arrow is pointing, however, you will see
> "66.59" clearly displayed. "66.59" is actually the value of a
> transaction in 

Re: [GNC] Cursor Focus on Wrong Tab

[D. via gnucash-user]

In this case, tab moves you to other fields in the hidden tab. Only by clicking 
in the visible register does it change. 


 Original Message 
From: David Carlson 
Sent: Fri Jun 19 15:00:49 EDT 2020
To: "David T." 
Cc: Gnucash Users 
Subject: Re: [GNC] Cursor Focus on Wrong Tab

I suspect that there are actually other instances in the code where
pointers get out of sync, and I am sure that it is incredibly difficult to
test every case, especially in the existing code.  Hopefully, in release
4.0 it will start to get easier to test these things.

One tool that I use for a different circumstance where the working focus is
not visible on the screen is to hit the Tab key, which usually causes the
current window to show the location of the curser.  That does not address
the underlying issues.

On Fri, Jun 19, 2020 at 10:32 AM David T. via gnucash-user <
gnucash-user@gnucash.org> wrote:

> Hello,
>
> I swear I reported troubles with this a long time ago, and I could have
> sworn I added a bug about it. My recollection was that I was the only
> person who could duplicate the issue, and so it never went anywhere
> further. However, I find no evidence on Bugzilla or in the lists. Alas.
> My search skills are clearly lacking.
>
> The issue is this: when I am in Tab "H" and duplicate a transaction by
> clicking the toolbar Duplicate button, once I have concluded the process
> by selecting a new date and pressing Enter, my cursor appears to be in
> tab "H", but is actually on Tab "B" (which is the first register
> account, after the COA). If I attempt to edit the transaction at this
> point, the transaction that receives input is NOT the visible
> transaction in tab H, but rather the hidden transaction on tab B.
>
> In the attached image, "Base Salary" is the aforementioned tab H, in
> which I have just created a new transaction by clicking the Duplicate
> button, choosing today's date and pressing Enter, which has created the
> 06/19/2020 transaction that is visible on screen.
>
> If you look down where the big arrow is pointing, however, you will see
> "66.59" clearly displayed. "66.59" is actually the value of a
> transaction in the Checking register. If I start typing, the
> transaction that receives input *is in the Checking register and NOT the
> visible transaction in the Base Salary register.* I have to remember to
> use the mouse to actively click in the on screen transaction in order to
> "select" the transaction I just created on the currently-visible
> register and which appears to currently have focus.
>
> To say this is confusing is an understatement--and it only gets worse if
> I start typing, fail to see any change, and then remember to click the
> current register. Now, the visible register gets focus--and the hidden
> register (which has changes I unwittingly have made) gets a commit.
> Obviously, this can have significant negative effects: the transaction I
> blindly edited has changed and been saved. Maybe that transaction is now
> unreconciled. Maybe I put gibberish into the description. Maybe I put
> gibberish into the transfer account, and GnuCash will send me a
> mysterious message that the account doesn't exist, would I like to
> create it. Maybe I have changed the amount on that transaction.
>
> I hope that this email provides enough information that others can now
> see the problem that I have seen for a long time; if others can
> duplicate this, I'll enter a bug report.
>
> David T.
>
> ___
> 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.
>


-- 
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
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] Disappearing entries

[D. via gnucash-user]

Hard to say how bad this is. I'd start with the newest data file (by 
modification date) that does NOT include the 14-digit timestamp, and see what 
was there. That may or may not be the file named "GC January 12 2019.gnucash". 
More likely it's newer ("GC January 15 2020.gnucash", for example).

You would then be able to tell how many different times you opened a backup by 
seeing how many log files were created after that last file. Working on a spare 
copy of that last file, you could try running the log files dated afterward to 
recreate the work. This may or may not work, depending on whether you changed 
the account structure. If it works, great. If not, you'll have to recreate the 
transactions manually. 

I avoid this problem by only having one simply named basic data file in my data 
directory (in my case, "accounts.gnucash"). Backups and dated storage copies 
get placed in remote folders to keep the idiot from screwing things up (which 
he is very good at!).

David T. 


 Original Message 
From: l...@ipadring.net
Sent: Thu Jun 18 13:32:14 EDT 2020
To: "D." , Michael Hendry 
Cc: Derek Atkins , Gnucash Users 
Subject: Re: [GNC] Disappearing entries

Ok, how do I fix this...or what file should I use?

Carl

On June 18, 2020 4:50:11 PM UTC, "D."  wrote:
>I'd definitely agree that his data is forked. Both ways!
>
>
> Original Message 
>From: Michael Hendry 
>Sent: Thu Jun 18 12:27:13 EDT 2020
>To: Derek Atkins 
>Cc: gnucash-user@gnucash.org, Carl 
>Subject: Re: [GNC] Disappearing entries
>
>> On 18 Jun 2020, at 17:22, Derek Atkins  wrote:
>> 
>> Hi,
>> 
>> On Thu, June 18, 2020 11:48 am, Carl wrote:
>> 
>>>Here's the command that's used- gnucash %f
>> 
>> Hmm.. This could be part of the issue.  %f probably means "filename".
> So
>> if you click a file it'll open that one directly and not the main
>file.
>> 
>> 
>>> Below is the name of my GC file (regardless of the name of the  
>file
>>> below the date and time stamp on the file.on the far   right
>of
>>> the file manager...is current for when I last used the   file-
>June 17
>>> 2020 at 7 PM
>>>  GC January 12 2019.gnucash.20190518080326.gnucash
>> 
>> AND... here we have what could be part of your issue.  This is a
>backup
>> file.  Specifically, this is a backup file that was generated on May
>18,
>> 2019 (at 8:03 am).  So at SOME point you started working from a
>year-old
>> backup file.  It's unclear when that happened.  But you have most
>likely
>> forked your data.
>
>Is that a minced oath?
>
>Michael
>
>___
>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] Disappearing entries

[D. via gnucash-user]

I'd definitely agree that his data is forked. Both ways!


 Original Message 
From: Michael Hendry 
Sent: Thu Jun 18 12:27:13 EDT 2020
To: Derek Atkins 
Cc: gnucash-user@gnucash.org, Carl 
Subject: Re: [GNC] Disappearing entries

> On 18 Jun 2020, at 17:22, Derek Atkins  wrote:
> 
> Hi,
> 
> On Thu, June 18, 2020 11:48 am, Carl wrote:
> 
>>Here's the command that's used- gnucash %f
> 
> Hmm.. This could be part of the issue.  %f probably means "filename".  So
> if you click a file it'll open that one directly and not the main file.
> 
> 
>> Below is the name of my GC file (regardless of the name of the   file
>> below the date and time stamp on the file.on the far   right of
>> the file manager...is current for when I last used the   file- June 17
>> 2020 at 7 PM
>>  GC January 12 2019.gnucash.20190518080326.gnucash
> 
> AND... here we have what could be part of your issue.  This is a backup
> file.  Specifically, this is a backup file that was generated on May 18,
> 2019 (at 8:03 am).  So at SOME point you started working from a year-old
> backup file.  It's unclear when that happened.  But you have most likely
> forked your data.

Is that a minced oath?

Michael

___
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] Trouble opening ancient files

[D via gnucash-user]

Online resources indicate that Windows support was added for 2.2, so finding 
Windows binaries before that may be futile. According to the wikipedia article, 
that was in 2007.

On Jun 17, 2020, 12:17, at 12:17, Derek Atkins  wrote:
>Thomas Klausner  writes:
>
>> On Tue, Jun 16, 2020 at 10:22:33AM -0400, Derek Atkins wrote:
>>> This looks like it might be a GnuCash 1.2 or 1.4 binary datafile. 
>The
>>> ability to read those old binary files was removed more than a
>decade ago.
>>> 
>>> You'll need to import that using something probably as old (new?) as
>1.6
>>> in order to convert it to XML, but you'll probably need a very old
>OS in
>>> order to build it.
>>
>> Ok, I didn't find such an old binary.
>>
>> Does anyone still have such a binary running, or a Windows 2.0.x exe
>somewhere?
>
>You MAY be able to find them on sourceforge under the Files section.
>Either that or you'll need to install an old VM to build 2.0 yourself.
>Unfortunately the earliest Windows exe I've got is 2.4.0 which is way
>too new for you.
>
>>> [snip]
>>> > Any suggestions on how to get versions of these files that could
>be
>>> > opened by gnucash 3.10?
>>> 
>>> These later XML files are also relatively old.  My guess, you'll
>>> probably need to start with 1.6 (or maybe even 1.4 for the binary
>data)
>>> and then keep on doing File -> Open /  File -> Save As to translate
>the
>>> data files from version to version:
>>> 
>>> 1.4 -> 1.6 -> 1.8 (was there a 1.8?  I don't recall) -> 2.0 -> 2.2
>->
>>> 2.4 -> 2.6 -> 3.x
>>> 
>>> Expect this to take a while.
>>
>> Actually, this quite a bit easier than I expected. I downloaded the
>> Windows 2.2.9 binary and opened the newer file and saved it, then
>3.10
>> could open it successfully. :)
>
>Hmm.  Surprised that you could jump from 2.2.9 to 3.10 without any
>issues!  I would have expected that you'd have to hit 2.4 or 2.6 first.
>
>> Can you please fix this warning:
>>
>> "This file/URL appears to be from a newer version of GnuCash. You
>must
>> upgrade your version of GnuCash to work with this data."
>>
>> that appeared for this file?
>
>You would need to provide a copy of the file in (or possible work with
>the devs to recreate it) in order to get that warning fixed
>appropriately.
>
>> Thanks,
>>  Thomas
>
>> 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
>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] file storage location

[D. via gnucash-user]

1. File->Save As --- save into your new location. Exit Gnucash. 
2. From your favorite file manager, move all remaining gnucash files into the 
new location. Note that the base data file will already be there, since you 
saved it there in step 1, so you don't need that. 

You could of course do it all from your file manager, but gnucash would bark 
about the missing data file the next startup. This is remedied simply by 
ignoring the error and then opening the file from its new location, but thre 
first method avoids the error altogether. 


 Original Message 
From: Jamie Tolbert 
Sent: Mon Jun 15 11:07:52 EDT 2020
To: gnucash-user@gnucash.org
Subject: [GNC] file storage location

new user here, seems like all the files are in my document storage 
folder, I'd like to move them to their own separate folder, is that 
possible?
___
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] 1) View Transactions: Newest at Top 2) Larger Type

[D. via gnucash-user]

Further to 2: assuming GnuCash version 3.x, read 
https://wiki.gnucash.org/wiki/GTK3, which explains how to use the underlying 
CSS to modify thre appearance. 

There are also numerous discussions on the lists over the years that cover 
this. I'd try searching for discussions about css.


 Original Message 
From: David Carlson 
Sent: Fri Jun 12 09:32:02 EDT 2020
To: Fran_3 
Cc: Gnucash Users 
Subject: Re: [GNC] 1) View Transactions: Newest at Top 2) Larger Type

Fran,
1. If you select View > Sort By...  There is an option to sort in reverse
order near the bottom of the window.  It does not put the blank transaction
at the top, however.

2.  As for increasing the font size, there are different options depending
on your operating system and the version of GnuCash you are using.  If
other programs also have small text, stary with your OS font size setting.

On Fri, Jun 12, 2020 at 8:14 AM Fran_3 via gnucash-user <
gnucash-user@gnucash.org> wrote:

> 1 - Is there anyway... when looking at a register... like Check
> Register... to reverse the order & have the latest transaction on top?
> (Including the blank fields for the "next" transaction)
> 2 - Any way to make the type larger on the screen for easier viewing?
> If not are these in the "wish list' ?
> 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.
>


-- 
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
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] redoing reconciliation

[D. via gnucash-user]

You could fix the one error, then reconcile to the last statement you have. 
Presumably, it will only differ by the amount of the transactions you changed. 
That's a lot less work...



 Original Message 
From: Gio Bacareza 
Sent: Thu Jun 11 13:39:20 EDT 2020
To: Adrien Monteleone , GnuCash Users 

Subject: Re: [GNC] redoing reconciliation

Thanks Adrien. That's a great solution indeed. However I only discovered
about the fluke transaction which made it necessary for me to repeat the
reconciliation process months after. Therefore there have been many
transactions after that. Thanks.

On Fri, Jun 12, 2020, 1:17 AM Adrien Monteleone <
adrien.montele...@lusfiber.net> wrote:

> If you don’t have one this time, make a habit in the future of saving a
> copy of your datafile as a backup before each reconcile.
>
> Then rolling that back is as simple as opening the backup instead of the
> current file.
>
> Of course, that would be complicated by anything you enter between
> reconciling and when you decide to roll it back if you don’t do it right
> away.
>
> Regards,
> Adrien
>
> > On Jun 11, 2020 w24d163, at 5:11 AM, Gio Bacareza 
> wrote:
> >
> > Hi David,
> >
> > Sorry my question was a bit confusing after reading it again. What I
> meant
> > to say was that they are already reconciled, ie R. But then I want to
> > UN-Reconcile it because I needed to. I was just wondering if there's a
> > better way to UN-R transactions than having to click each back to N.
> >
> > 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.

___
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] Adjusting journal column widths

[D. via gnucash-user]

https://www.gnucash.org/docs/v3/C/gnucash-guide/basics-running-gnucash.html#basics-register2

In particular, the note regarding the description column is relevant. 


 Original Message 
From: rmom...@gmail.com
Sent: Mon Jun 01 13:24:43 EDT 2020
To: GnuCash 
Subject: [GNC] Adjusting journal column widths

I can adjust the column widths in the journal by double clicking the header.
I'd like to set the description narrower but can't seem to do it. It
occupies a lot of space that cramps the number columns off the right edge of
the page, the total or balance column. I tried dragging the right side of
the description column to the left but it just snaps back.

 

I'm running Version: 3.5, Build ID: 3.5+(2019-03-30) on a Windows 10 PC

 

Thanks,

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
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] Transaction report: selected date range

[D. via gnucash-user]

Further: if you want to use the Account Report,  first filter the register for 
the dates  (View->Filter by) and then run the report. If you want  to use the 
Transaction Report, once it informs you that you haven't selected any account, 
open the Options and select the account and date range. 


 Original Message 
From: Adrien Monteleone 
Sent: Sun May 24 13:39:03 EDT 2020
To: gnucash-user 
Subject: Re: [GNC] Transaction report: selected date range

The Transaction Report can be for multiple accounts, so it doesn’t matter what 
register is open at the time.

The Account Report is for the currently viewed register.

The two reports are quite different in their available options, however.

Regards,
Adrien

> On May 24, 2020 w22d145, at 12:08 PM, Rich Shepard  
> wrote:
> 
> On Sun, 24 May 2020, Fred Bone wrote:
> 
>> When I run the transaction report it points out that I need to select the
>> account in "Options".
> 
> Fred,
> 
> Huh! I saw the link but missed the instruction above it. Mea culpa!
> 
>> Having said which, I'm not on the latest version. What version are you
>> running?
> 
> 3.10
> 
> Thanks,
> 
> Rich

___
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] Report seems to pull wrong amount from transaction

[D. via gnucash-user]

I'd look at the price source used in the report (on the report options). It 
sounds to me like the report is converting the January shares sold at the 
February/March price. 


 Original Message 
From: Art Chimes 
Sent: Wed May 13 01:57:24 GMT+05:30 2020
To: Gnucash Users , Adrien Monteleone 

Subject: Re: [GNC] Report seems to pull wrong amount from transaction

Adrien's quick reply is below (edited) with my responses.

=

My first inklings would be to ask:

1. Do these transactions involve other currencies?
===No, all in USD

2. Are they part of a bill/invoice that has a tax applied to a line
item using the business tax tables?
===No, strictly personal account.


3. Do the specific transactions (when showing all splits) show the
amount for that account as exactly $150 or $146? If the latter, what
split(s) appear to balance out the $4 difference?
===That was the first think I looked at. All three transactions in my
register are structured identically, but the January split is
different than the two others, which are the same. (I made up the
numbers, so I hope everything balances. It does in my actual account.)

January transaction
Assets:Checking  buy 118.66 [net deposited in my checking account]
Expense:Withholding tax  buy 31.34 [sent to the IRS]
Assets:Fund ABCDX [source of withdrawal]  sell 150 [withdrawn from
financial institution]
(((Jan. shows on the Report as 146, NOT consistent with register)))

February and March transaction
Assets:Checking  buy 107.45 [net deposited in my checking account]
Expense:Withholding tax  buy 42.55 [sent to the IRS]
Assets:Fund ABCDX [source of withdrawal]  sell 150 [withdrawn from
financial institution]
(((Both Feb. and Mar. show on the Report as 150, consistent with register)))

4. Is your account selection in the Report Options limited to that one
account? Are you reporting on the account for the financial
institution, where the funds come from, or from the target account
where the funds land?
===Account selection in Report Options is limited to one account, the
one from which the funds are taken. All three transactions involved
the same dollar value (though the number of shares of the mutual fund
were different). The full amount was paid out of the account (no fee
charged) and received into my checking account after tax withholding
was deducted.


One other thing of possible relevance. I mentioned that the linked
amounts in the report took me to the right account but not to the
specific transaction. Now, the links go right to the corresponding
transaction. I changed up a couple of things in the report (currency
options), then went back to the previous options, and somehow that
fixed it.

Thanks for your efforts to troubleshoot this puzzling (to me) behavior!

Art


On Tue, May 12, 2020 at 12:29 PM Art Chimes  wrote:
>
> This seems like a bug to me, but maybe I'm missing something.
>
> I have an account from which I have a regular, automatic withdrawal
> scheduled with the financial institution. The amount is the same every
> month, let's say $150.
>
> My YTD report shows this year's three withdrawals to date (plus
> another transaction, unrelated to the automatic ones).  However, the
> January withdrawal on the report shows an incorrect amount, a few
> dollars less, $146.
>
> All three accounts were subject to tax withholding. The January
> withholding was different than the later withdrawals, but otherwise
> the amount withdrawn from the account was the same in all monthly
> withdrawals, i.e. $150.
>
> A possible clue: When I click on the hyperlinked amount in the report,
> it links to the correct account but not to the specific transactions.
> (In other reports I spot-checked, it takes me directly to the
> transaction.)
>
> I could not reproduce this error in a few other random reports I generated.
>
> Can you help?  Thanks.
>
> Art



-- 
Art Chimes
1117-B N. Stuart St.
Arlington, Va. 22201
___
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] XML vs SQL data integrity question

[D. via gnucash-user]

My experience matches David H. Windows 10, dropbox XML file. No crashes in 
years. Might want to figure out why Windows is hiccuping, rather than change 
data back ends. I can't imagine that recovering your corrupted gnucash data 
will be easier with an SQL back end. 

David T. 


 Original Message 
From: David H 
Sent: Thu May 07 12:06:28 GMT+05:30 2020
To: Jeff 
Cc: Gnucash userlist 
Subject: Re: [GNC] XML vs SQL data integrity question

I've only ever used the default compressed xml backend with gnucash on Win
10 Pro.  Been using it since about 2010 and never had an issue - always
update to the latest version as soon as it comes out.  Running on MacOS
Catalina, Win 10 Pro and Ubuntu 20.04 now, sharing file via freefilesync
and dropbox.  Dunno what you're doing to corrupt your file and make Win 10
kill gnucash, I've never had issues with Win 10 killing gnucash...

Cheers David H.


On Thu, 7 May 2020 at 15:09, Jeff  wrote:

> This has probably been discussed here before but; I'm going ask anyway.
> Which do most people find more reliable with GNC, SQL or the default
> XML?  And are there any features I would lose other than the rollback
> ability with SQL?
>
> I'm getting tired of having to track down account and report issues
> every time Windoze 10 hiccups.  I use the default XML, uncompressed.
> One set of books has been corrupted several times, I'm assuming when
> Windoze just simply kills the GNC program out of the blue.  I have
> another set of books for a business that so far, knock on wood,  the
> only problem is sometimes various buttons have to be selected multiple
> times to work then all of the windows open in GNC blur while processing
> then go back to normal display.
>
> My computers are all networked and dual boot Windoze and Ubuntu, so I
> would need SQL on both sides if I switch over.  I'm leaning towards
> PostgreSQL (pro's, con's?  Suggestions?).
>
> --
> --JEffrey Black M.B.A.
>
> ___
> 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] Porting the Tutorial & Concepts Guide to ReadTheDocs.org

[D. via gnucash-user]

Adrien, 

Being a past member of group 1, I can vouch for the challenges that the current 
tool set presents. Some might even call me the poster child on how difficult it 
can be. It does meet numerous disparate needs, however. 

Your group 2 users can and do contribute-- to the wiki and the user list. 
Remember that the GnuCash "culture" is to recommend reading the docs, check the 
wiki, and check the mailing list archives. 

I agree that there are disconnects and gaps. For example, stuff seems to get 
into the wiki and never go any further-- and they often remain in the wiki long 
after the documents get updated. Similarly, mailing list threads rarely 
migrate. To me, this is where the significant disconnect lies: in the fact that 
ideas discussed here in the lists rarely go further to the wiki and the docs. 

Underlying this, I think, is a sense that the docs are incomplete or inferior 
or outdated, and the best way to answer a problem is to ask on the lists. The 
tendency in the community is to reinforce this sense, unintentionally perhaps, 
by repeatedly answering basic questions in lengthy email threads, rather than 
either referring users to the existing documentation or by migrating the 
knowledge in those threads into the documentation. I know that you've been 
active in taking this on, and that the other Diligent Davids have been working 
to get major areas of the documentation updated, so all is not lost!

David T. 
Former documentarian


 Original Message 
From: Adrien Monteleone 
Sent: Thu May 07 05:49:14 GMT+05:30 2020
To: Gnucash Users 
Subject: Re: [GNC] Porting the Tutorial & Concepts Guide to ReadTheDocs.org



> On May 6, 2020 w19d127, at 5:53 PM, David Cousens  
> wrote:
> 
> The existing tool chain meets more than the need for a single document. There
> is translation into multiple languages, online versions, standalone pdf,
> epub etc. The Read theDoc' format is certainly quite nice but to be a
> replacement candidate for the current tool stream it has to offer
> considerable advantages over the current process while still meeting those
> needs. Maybe these can all be met with an alternative but his needs to be
> ascertained.
> 
> The current documenters have invested time and effort in coming to grips
> with what we currently use. Replacing part of the current tool chain means
> we are going to have to put time and effort into learning a new approach
> when in most case our available time for working on the documentation is
> better spent exploring GnuCash and how it works and the underlying code. It
> is not as though we are particularly well resourced in this area.


Sounds to me like there are at least two perspectives here:

1. Current documenters who have invested in the current toolchain but don’t 
have all the info necessary to re-write the docs.

2. Users who can provide the info for documentation based on how the app works 
in their experience (at the user level, not necessarily at a code level) but 
who haven’t invested in the toolchain and for whom such an investment is out of 
their scope, wheelhouse, time available, etc.

There is clearly a disconnect and a gap.

How to bridge it?

I’ll posit there doesn’t need to be ‘one toolchain to rule them all’ though 
that isn’t precluded should such a solution be discovered.

Perhaps there should be another entry-point for Group #2 where they can submit 
documentation improvements on no simpler a basis than standard word processing, 
wiki editing, markdown etc.

Then Group #1 takes that revised or newly added text and “sausages it” through 
the current project-preferred toolchain.

Presently, either you join Group 1, or you don’t contribute and the docs stay 
stale or incomplete.

Non-techy users can ask questions and report issues here on the list, and on 
Bugzilla. Maybe some similar process should be outlined for documentation and 
not just for functionality. (I know one can already file documentation bugs, 
the point is to clearly spell out that a similar process for documentation 
exists, or will.)

Is there no room for offering Group 2 an easier point of entry? Is there an 
option which doesn’t require Group 1 to have to re-invest time in a different 
toolchain?

Regards,
Adrien

> I support Frank's approach of defining and documenting what it is the
> documentation currently does and needs to do then looking at what the
> advantages/disadvantages of any alternative approach to the current tool
> chain actually are and whether it can mmet all the current needs. In doing
> this we also need to examine who is currently working on the documentation
> and how they might react to a significant  tool change. If a major effect is
> we lose a significant part of the current resource base in this area, is it
> really productive to make a change unless that change is really necessary
> and increases the resource availability and productivity.  My time spent of
> documentation is less on working out the intricacies of 

Re: [GNC] QIF file import still doesn't work with Gnucash 3.10

[D. via gnucash-user]

Alan, 

Thank you for clarifying. I have no interest in discussing either QFX or QIF. I 
was merely trying to help clarify the situation, since some users have 
encountered QFX data with duplicate FITIDs, which had caused them troubles. 

Good luck with your problem. 

David


 Original Message 
From: Alan 
Sent: Wed May 06 21:51:35 GMT+05:30 2020
To: 'D' , 'David Carlson' 
Cc: 'Gnucash Users' 
Subject: RE: [GNC] QIF file import still doesn't work with Gnucash 3.10

David,

This discussion is only about QIF file import issues.

Please take the QFX issues to another discussion thread.

-Original Message-
From: gnucash-user
[mailto:gnucash-user-bounces+alangnuc=bigtowers@gnucash.org] On Behalf Of D
via gnucash-user
Sent: Wednesday, May 06, 2020 10:17 AM
To: David Carlson 
Cc: Gnucash Users 
Subject: Re: [GNC] QIF file import still doesn't work with Gnucash 3.10

I'm trying to figure out whether the OP is referring to QIF or QFX. The original
message refers to the former. But subsequent messages refer to the latter.

If the problem is with QFX, perhaps the source file has FITID issues. Some
clarification is in order. 

David

On May 6, 2020, 16:48, at 16:48, David Carlson 
wrote:
>
___
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] QIF file import still doesn't work with Gnucash 3.10

[D via gnucash-user]

I'm trying to figure out whether the OP is referring to QIF or QFX. The 
original message refers to the former. But subsequent messages refer to the 
latter.

If the problem is with QFX, perhaps the source file has FITID issues. Some 
clarification is in order. 

David

On May 6, 2020, 16:48, at 16:48, David Carlson  
wrote:
>
___
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] Reporting transactions

[D. via gnucash-user]

If it works for you and it's clear to you, then that's what matters.


 Original Message 
From: Ruaraidh Sackville Hamilton 
Sent: Sun May 03 15:19:16 GMT+05:30 2020
To: Christopher Lam 
Cc: "D. via gnucash-user" 
Subject: Re: [GNC] Reporting transactions

FWIW, after further research on SIPPs I think I have the "correct" solution
for how to manage them in GnuCash. Basically, keep them in their own
GnuCash file separate from your other assets.

To quote https://www.ii.co.uk/ii-accounts/sipp/inheritance-tax , "Your
pension does not normally form part of your estate" (that is, it's not part
of your assets and liabilities whose net worth is assessed for inheritance
tax, and whose associated income and expenditure is assessed for income
tax).

It all fits and makes sense. A SIPP is a pension fund. Pension funds
themselves are not part of your assets, and their investment activities are
not part of your income and expenditure. When you pay into a pension fund,
this is an expense, which reduces your estate's net worth now and which you
can claim as an allowable expense against income tax. When you withdraw
funds from a pension fund, this is income, which is subject to income tax
and increases your estate's net worth. This applies to SIPPs in the same
way as to other pension funds.

The difference is, a SIPP is managed by you. As investor-manager of the
SIPP, you can specify who the SIPP will pass to when you die, but that is
done separately from your estate under different tax rules.

So, keep your estate assets and liabilities in one GnuCash file (your
estate file), and your SIPP in a separate file (your SIPP file). Payments
from your estate bank account into your SIPP appear correctly as expenses
in your estate file, and withdrawals from your SIPP into your bank account
appear correctly as income in your estate file - so they will be correctly
reported in your estate tax report. If you want the GnuCash tax report to
fully reflect all your expenses, including contributions made by employers
or by the government pay directly into your SIPP, you would need route them
through a notional asset in your estate file: record each
employer/government contribution as a (tax-free) income to the notional
asset, and then as an immediate expense from that asset, on the same date
as the income to the SIPP - i.e. zero net change in your estate net worth,
and an increase in the SIPP net worth.

If you still want to keep your estate and your SIPP in the same GnuCash
file, be aware that (1) the net worth shown in the GnuCash file will not be
your estate net worth; (2) GnuCash tax reports won't be able to show all
your reportable expenses while you are building up your SIPP; and (3)
GnuCash tax reports won't be able to show all your taxable income when you
withdraw funds from the SIPP.

Hope this is of interest to some.

Ruaraidh

On Fri, 1 May 2020 at 12:53, Ruaraidh Sackville Hamilton <
ruaraidh...@gmail.com> wrote:

> Yes :)
>
> They differ from other brokerage accounts in regulations on tax and on
> when and how you can withdraw funds. e.g. when you use it in retirement as
> your pension income, withdrawals from the fund into your normal bank
> account are taxed as income at the point of withdrawal (again, from a tax
> perspective, paying into a SIPP is a business expense, whereas withdrawing
> from a SIPP is a taxable income).
>
> But yes, they are brokerage accounts, to be managed as you say.
>
> On Fri, 1 May 2020 at 12:00, Christopher Lam 
> wrote:
>
>> IIUC the SIPP is simply a wrapper around stock-type and cash-type
>> investments, so, you'd handle it exactly the same as any Broker and Broker
>> investments.
>>
>> See https://www.gnucash.org/docs/v3/C/gnucash-guide/invest-setup1.html -
>> the SIPP wrapper would be the "Brokerage Accounts" asset. You may choose to
>> record each stock fluctuation, or (my preference) trust the SIPP statements
>> instead.
>>
>> Annually you'd print a Transaction Report from SIPP account. Or you can
>> run a cash flow report, originating from SIPP account and children.
>>
>> On Fri, 1 May 2020 at 10:26, Ruaraidh Sackville Hamilton <
>> ruaraidh...@gmail.com> wrote:
>>
>>> Yes sure that's one perspective and I agree with it, and that's why I
>>> have my SIPP in the same GC file as everything else. I was just noting that
>>> the way contributions are reported (i.e. as expenses eligible for tax
>>> rebates, not as income that is taxed) seems more in line with a
>>> different perspective, that the net worth of a SIPP is independent from
>>> personal net worth. Isn't a business's net worth different from personal
>>> net worth? Isn't it possible to view it both ways?
>>>
>>> Ignore me. I'm a novice to GnuCash and naive 

Re: [GNC] Scheduled transactions

[D. via gnucash-user]

What happens if you delete the two transactions and recreate them? 


 Original Message 
From: augras 
Sent: Sun May 03 18:59:08 GMT+05:30 2020
To: gnucash-user@gnucash.org
Subject: Re: [GNC] Scheduled transactions

Hello Jim,
thanks for your answer and your time.
You are right for points 1,2 and 3.
For the point 4 i can edit the transactions, but i can't make any change !
I always get the message "An error occured in the treatment of 1000,00." and
the choice is only to Close.
I have a lot of scheduled transactions and get this problem for 2.
Philippe



--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.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] Payroll Report

[D. via gnucash-user]

Since each of the lines has its own account, that should be eminently possible 
with a transaction report. I have something just like this to track my personal 
wage situation--a W-2 in US tax parlance. It's just a simple transaction report 
for the proper time period, using only the accounts in question, showing totals 
only. 

I can forward a sample if you need more detail. 

David T. 


 Original Message 
From: Aaron Laws 
Sent: Sun May 03 08:49:14 GMT+05:30 2020
To: Gnucash 
Subject: [GNC] Payroll Report

My accountant recently asked for a "payroll" report. I think he wants
something like this: https://imgur.com/tPemh4e.png (this is an image of the
attached PDF). What is the best way to create such a report? I'm hoping I
can do better than a set of Account Reports just showing the transactions.

One idea I have is to try to add this kind of report to Gnucash. I realize
I'm on the "user" list, so I'll stick to "user" solutions, and if nothing
compelling shows up, I'll go to the developer list and see if I can either
make something that will work for my needs or something I can contribute to
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
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 do I add stock trades?

[D. via gnucash-user]

Hear, hear! Thanks John! 

David


 Original Message 
From: Adrien Monteleone 
Sent: Sun May 03 07:59:18 GMT+05:30 2020
To: Gnucash Users 
Subject: Re: [GNC] How do I add stock trades?

An even more thorough explanation and understanding.

Thanks John!

Regards,
Adrien

> On May 2, 2020 w18d123, at 5:11 PM, John Ralls  wrote:
> 
> Not quite right. While it's correct that in GnuCash's code a currency is a 
> commodity with a special namespace, and that an account has only one 
> commodity member variable, it's not quite right about a non-currency 
> commodity account not having a currency.
> 
> Remember that a split has two commodity fields, amount and value, and that 
> transactions have a transaction currency field. It's called transaction 
> currency because it *must* be a currency, and it's the currency in which all 
> of the value fields are denominated.
> 
> If you begin a transaction in an account register whose commodity is 
> non-currency GnuCash will look up the hierarchy until it finds a parent 
> account in currency and use the first one it finds for the transaction 
> currency. It does the same in reports, in the Accounts page, and in the 
> summary bar when applying prices from the pricedb. That currency of the first 
> parent 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 
>> technical accuracy is no minor point, especially with accounting, and leads 
>> to clearer understanding.
>> 
>> Regards,
>> Adrien


___
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 do I add stock trades?

[D. via gnucash-user]

Adrien, 

I'm sure I have this wrong, but my understanding is that stock and currencies 
are both commodities, and that any given account is denominated in one. So a 
stock's "currency" is that commodity (that is, the ABC account is denominated 
in the ABC commodity). How it gets converted into a different currency (e.g., 
AUD) depends on the parent account. 

That is, of course, all technicalities. The rest is correct.

David


 Original Message 
From: Adrien Monteleone 
Sent: Sat May 02 21:55:02 GMT+05:30 2020
To: Gnucash Users 
Subject: Re: [GNC] How do I add stock trades?

As well, the currency of a stock or fund is determined by the currency of the 
parent account.

So if you set up a brokerage with sub-accounts, you set the brokerage to AUD 
and each sub-account is per fund/stock and those are set to their ticker 
symbol. If you own funds/stocks of different currencies with the same brokerage 
you have to set up a different brokerage parent with the proper currency 
assigned and likely put the currency in the brokerage account name for sanity, 
e.g.,

Assets:Current Assets:Investments:Morgan Stanley USD
-Assets:Current Assets:Investments:Morgan Stanley USD:Stock1
-Assets:Current Assets:Investments:Morgan Stanley USD:FundA

Assets:Current Assets:Investments:Morgan Stanley AUD
-Assets:Current Assets:Investments:Morgan Stanley AUD:Stock2
-Assets:Current Assets:Investments:Morgan Stanley AUD:FundB

I’m pretty sure this is covered in the Guide, however.

Regards,
Adrien

> On May 2, 2020 w18d123, at 2:08 AM, D. via gnucash-user 
>  wrote:
> 
> Hello, 
> 
> You have a number of misconceptions going here, beginning with the purpose 
> and implementation of Trading Accounts. If you go to the external article on 
> trading accounts referred to in the wiki, you should get a clearer picture. I 
> am no expert on trading accounts, so I'll let others clear the air on that 
> topic further. 
> 
> However, you would be best advised to go back to the chapter on investments 
> in the Tutorial & Concepts Guide, which is the official documentation for 
> GnuCash. There you will see, for example, that your ABC account should be set 
> up as a Stock or Mutual Fund type account, denominated in ABC commodity 
> (which you will have to add in the security editor), and not in AUD. That 
> account will indicate then how many shares of ABC you own. The price db will 
> be used to determine the value of those shares in your book currency.
> 
> When you sell those shares, you will need to account for the gain or loss, 
> which can be manually calculated and entered, or be done automatically using 
> the lots scrub feature. 
> 
> All of this is covered, as I said, in the Tutorial. Have a read of that, and 
> try again. 
> 
> HTH,
> David

___
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] Export Transaction Report as pdf Splits Last Line over 2 Pages

[D. via gnucash-user]

Yes. 

Save as html and open/print from browser. 



 Original Message 
From: flywire 
Sent: Sat May 02 16:52:56 GMT+05:30 2020
To: Gnucash Users 
Subject: [GNC] Export Transaction Report as pdf Splits Last Line over 2 Pages

Is exporting Transaction Report as pdf splitting the last line horizontally
over 2 pages a known issue? Occurs on 15 of 38 pages viewed in either
Chrome or Edge under Win10.
___
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 do I add stock trades?

[D. via gnucash-user]

Hello, 

You have a number of misconceptions going here, beginning with the purpose and 
implementation of Trading Accounts. If you go to the external article on 
trading accounts referred to in the wiki, you should get a clearer picture. I 
am no expert on trading accounts, so I'll let others clear the air on that 
topic further. 

However, you would be best advised to go back to the chapter on investments in 
the Tutorial & Concepts Guide, which is the official documentation for GnuCash. 
There you will see, for example, that your ABC account should be set up as a 
Stock or Mutual Fund type account, denominated in ABC commodity (which you will 
have to add in the security editor), and not in AUD. That account will indicate 
then how many shares of ABC you own. The price db will be used to determine the 
value of those shares in your book currency.

When you sell those shares, you will need to account for the gain or loss, 
which can be manually calculated and entered, or be done automatically using 
the lots scrub feature. 

All of this is covered, as I said, in the Tutorial. Have a read of that, and 
try again. 

HTH,
David


 Original Message 
From: armanschwarz 
Sent: Sat May 02 12:12:15 GMT+05:30 2020
To: gnucash-user@gnucash.org
Subject: [GNC] How do I add stock trades?

I would like to start recording my stock trades in GnuCash (3.10). Based on
the instructions I could find
(https://wiki.gnucash.org/wiki/Trading_Accounts) I enabled "Trading"
accounts and then created a top-level Trading account with the name
"Trading".

I tried to fumble through the instructions by creating a sub account with a
stock type "ABC". Then I clicked on "Transfer" and selected "Trading" as my
"From" Account (I had deposited $10,000 into it from my Equity account), and
"ABC" as my "To" account. For "Amount" I picked $10,000 and for "To Amount"
I selected 20,000, at which point GnuCash correctly calculated "1 ABC =
0.5 AUD" (Australian dollars is my currency).

At this point my accounts look like this:

- Trading ($10,000)
  - ASX (-$10,000)
- ABC (20,000- ABC)
  - CURRENCY ($10,000)
- AUD ($10,000)
  ABC (20,000 ABC)

I can't really tell whether this is right or not. In any case I now tried to
sell the stocks, say at $0.6 to simulate a 20% profit. So I hit "Transfer
funds" again and type $12,000 as the amount and select "Trading:ABC" as my
"From" account. However, now Gnucash incorrectly says "Currency AUD
(Australian Dollar)" for the "From" account, when the currency is actually
ABC stock. There's no option for me to select the number of stock or, if
"Amount" is already supposed to represent the number of stock (I can't tell)
then I have no option to select the price I achieved per stock on the sale.

The other thing I tried was sending a negative amount of money from
"Trading" to "Trading:ABC" to simulate the sale, so I typed "-12000" into
the amount column and -2 in the "To Amount" column, which results in the
message "1 ABC = 0.6 AUD" which seems right.

However, now my whole account appears to be in a somewhat buggy state; the
"Trading" account says $10,000 next to it when viewed from the main accounts
window, but when I enter the account, I can see 3 transactions ($10k
transfer from equity, $10k transfer to ABC and $12k transfer back in from
ABC from the sale) with a final balance of $12,000, which doesn't match up
with what I see in the main account. Also, if I click on any of the
transactions I get a popup saying "The current transaction is not balance."
with two options; "Balance it manually" and "Let GnuCash add an adjusting
split". Chosing either option or pressing cancel have no effect, and I can't
click anything else in the window without that popup coming back unless I
close the account or delete the transaction.

I can't inspect any transaction other than the first transfer from Equity as
the popup prevents me from looking at any other splits. However, if I click
on View -> Transaction Journal I can see that all f the transactions seem to
balance, with an equal number of "Increase" and "decrease" amounts for AUD
as well as for ABC.

I also tried this tutorial:
https://www.gnucash.org/docs/v3/C/gnucash-guide/invest-buy-stock1.html

However, the instructions on that wiki page don't match with what I see in
GnuCash (e.g. they have screenshots of "Shares", "Price", "Buy" and "Sell"
columns - I only have "Decrease" and "Increase"), so I wasn't really sure
how to make that work.

Any ideas on how I can use this feature?



--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.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.

Re: [GNC] Change account type by editing XML?

[D. via gnucash-user]

Just fishing, but wouldn't the signs change if you moved an asset account, say, 
to expenses? How would/should GnuCash handle existing transactions in such a 
moved account? 

David T. 


 Original Message 
From: Adrien Monteleone 
Sent: Sat May 02 11:53:19 GMT+05:30 2020
To: Gnucash Users 
Subject: Re: [GNC] Change account type by editing XML?

Indeed, I clicked Edit on an Asset account and I can only change it to:

Bank
Cash
Asset
Credit Card
Liability

I get the first three if there is going to be a limitation, but allowing the 
last 2 and not allowing even another debit balanced account like Expenses?

Strange.

I’m starting to wonder if this is a bug. If not, can someone shed light on the 
reasoning for not being able to refactor accounts except within their current 
parent type?

Regards,
Adrien

> On May 2, 2020 w18d123, at 12:43 AM, flywire  wrote:
> 
> The intent of my post was to report you can't reassign transactions between
> Asset and Expenses accounts either using the process previously described.
> Yes, the account in Asset was created by the import wizard.
> 
> It's nothing serious, went back to the previous file and imported again.


___
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] Working with dates in Postgresql DB

[D. via gnucash-user]

Was the problem that he entered variant dates, or that GnuCash reinterpreted 
his Perth transactions to a new date? My point is this: if he entered 
transactions in Perth for the 11th, and then returned to California, and they 
showed the 10th, wouldn't his problem have been solved if GnuCash had stored 
the local date time and then ignored the time zone? 


 Original Message 
From: John Ralls 
Sent: Sat May 02 03:53:01 GMT+05:30 2020
To: David H 
Cc: "D." , "Eric H. Bowen via gnucash-user" 

Subject: 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 in California on April 10 entering further txns using today's date ?  
> i.e. if you travelled to a timezone that was still the previous day ?
> 
> Cheers David H.
> 
> 
> On Sat, 2 May 2020 at 04:35, D. via gnucash-user  
> wrote:
> I understand that a lot of debate and discussion and heartache had gone into 
> this, so I really don't mean to be a pain, but it would seem to me that if I 
> entered April 10, 2020 for a transaction, and GnuCash then stored 2020-04-10 
> HH:MM:SS (where HH:MM:SS represents any arbitrary time), if GnuCash then 
> ignored the time portion from that point forth, then I'd see April 10, 2020 
> no matter how many times I crossed the date line. If I'm in California on 
> April 10, or in Perth on April 11, I'm presumably going to pick "today's" 
> date for my transaction. The two dates would be different, even if the 
> transactions were entered at the exact same time, but I could only see this 
> as a potential problem for a business with offices in both cities. 
> 
> As I said, I don't remember all the details, but I'm sure there were solid 
> reasons for choosing to take transaction dates and store them in UTC, to be 
> converted back to some arbitrary time zone at a later time. It makes my head 
> hurt, though. 
> 
> David
> 
> 
>  Original Message ----
> From: John Ralls 
> Sent: Fri May 01 23:30:37 GMT+05:30 2020
> To: "D." 
> Cc: finf...@gmail.com, "D. via gnucash-user" 
> Subject: Re: [GNC] Working with dates in Postgresql DB
> 
> David,
> 
> You're not thinking it through: It's about 11:00 on Friday 1 May here in 
> California but it's 03:00 on Saturday 2 May in Western Australia. Chopping 
> off the time doesn't solve anything, a point illustrated by Finfort when he 
> pointed out that just changing the time on the errant dates 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 underlying system. At least, conceptually!
> > 
> > Is there any option to simply ignore the time portion in these timestamps? 
> > It would seem to me that one could focus on that, and simplify the process 
> > piece by piece. Of course, not being a programmer, I'm just a silly voice 
> > in the wilderness.
> > 
> > David
> > 
> > 
> >  Original Message 
> > From: John Ralls 
> > Sent: Fri May 01 10:32:09 GMT+05:30 2020
> > To: "D." 
> > Cc: "finf...@gmail.com" , "D. via gnucash-user" 
> > 
> > Subject: Re: [GNC] Working with dates in Postgresql DB
> > 
> > David,
> > 
> > I don't know why the decision was made to use time, it was taken long 
> > before I joined the project, but it probably has to do with that being the 
> > way computers keep time, in UTC and the accompanying date-time manipulation 
> > functions in the C standard library were readily available. Over the years 
> > various developers have piled more manipulation functions on top of it, or 
> > added other libraries to the side because they made doing something easier, 
> > and splattered it all over the code so that changing the base design would 
> > involve chasing down and reworking all of those disparate functions. As I 
> > said, no one has expressed much enthusiasm for taking it on.
> > 
> > Knowing now that using time instead of date was a poor decision is just 
> > applying 20/20 hindsight to criticize Linas's decision 22 years ago. It 
> > can't change it. I can't say that I would have decided differently.
> > 
> > Regards,
> > John Ralls

Re: [GNC] Working with dates in Postgresql DB

[D. via gnucash-user]

First off, flight time between California and Australia is something like 17 
hours (to Hawaii, it's about 11), so if, after all that, you have energy to do 
your accounting in GnuCash, well, you're more of a masochist than I. 

Second, if I were to land on the 10th in California, I personally would enter 
those transactions for the tenth. Wouldn't you? 


 Original Message 
From: David H 
Sent: Sat May 02 03:46:28 GMT+05:30 2020
To: "D." 
Cc: John Ralls , "Eric H. Bowen via gnucash-user" 

Subject: Re: [GNC] Working with dates in Postgresql DB

Might be a problem if you were in Perth on April 11 entering txns and then
back in California on April 10 entering further txns using today's date ?
i.e. if you travelled to a timezone that was still the previous day ?

Cheers David H.


On Sat, 2 May 2020 at 04:35, D. via gnucash-user 
wrote:

> I understand that a lot of debate and discussion and heartache had gone
> into this, so I really don't mean to be a pain, but it would seem to me
> that if I entered April 10, 2020 for a transaction, and GnuCash then stored
> 2020-04-10 HH:MM:SS (where HH:MM:SS represents any arbitrary time), if
> GnuCash then ignored the time portion from that point forth, then I'd see
> April 10, 2020 no matter how many times I crossed the date line. If I'm in
> California on April 10, or in Perth on April 11, I'm presumably going to
> pick "today's" date for my transaction. The two dates would be different,
> even if the transactions were entered at the exact same time, but I could
> only see this as a potential problem for a business with offices in both
> cities.
>
> As I said, I don't remember all the details, but I'm sure there were solid
> reasons for choosing to take transaction dates and store them in UTC, to be
> converted back to some arbitrary time zone at a later time. It makes my
> head hurt, though.
>
> David
>
>
>  Original Message 
> From: John Ralls 
> Sent: Fri May 01 23:30:37 GMT+05:30 2020
> To: "D." 
> Cc: finf...@gmail.com, "D. via gnucash-user" 
> Subject: Re: [GNC] Working with dates in Postgresql DB
>
> David,
>
> You're not thinking it through: It's about 11:00 on Friday 1 May here in
> California but it's 03:00 on Saturday 2 May in Western Australia. Chopping
> off the time doesn't solve anything, a point illustrated by Finfort when he
> pointed out that just changing the time on the errant dates 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 underlying system. At least, conceptually!
> >
> > Is there any option to simply ignore the time portion in these
> timestamps? It would seem to me that one could focus on that, and simplify
> the process piece by piece. Of course, not being a programmer, I'm just a
> silly voice in the wilderness.
> >
> > David
> >
> >
> >  Original Message 
> > From: John Ralls 
> > Sent: Fri May 01 10:32:09 GMT+05:30 2020
> > To: "D." 
> > Cc: "finf...@gmail.com" , "D. via gnucash-user" <
> gnucash-user@gnucash.org>
> > Subject: Re: [GNC] Working with dates in Postgresql DB
> >
> > David,
> >
> > I don't know why the decision was made to use time, it was taken long
> before I joined the project, but it probably has to do with that being the
> way computers keep time, in UTC and the accompanying date-time manipulation
> functions in the C standard library were readily available. Over the years
> various developers have piled more manipulation functions on top of it, or
> added other libraries to the side because they made doing something easier,
> and splattered it all over the code so that changing the base design would
> involve chasing down and reworking all of those disparate functions. As I
> said, no one has expressed much enthusiasm for taking it on.
> >
> > Knowing now that using time instead of date was a poor decision is just
> applying 20/20 hindsight to criticize Linas's decision 22 years ago. It
> can't change it. I can't say that I would have decided differently.
> >
> > Regards,
> > 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 

Re: [GNC] Working with dates in Postgresql DB

[D. via gnucash-user]

I understand that a lot of debate and discussion and heartache had gone into 
this, so I really don't mean to be a pain, but it would seem to me that if I 
entered April 10, 2020 for a transaction, and GnuCash then stored 2020-04-10 
HH:MM:SS (where HH:MM:SS represents any arbitrary time), if GnuCash then 
ignored the time portion from that point forth, then I'd see April 10, 2020 no 
matter how many times I crossed the date line. If I'm in California on April 
10, or in Perth on April 11, I'm presumably going to pick "today's" date for my 
transaction. The two dates would be different, even if the transactions were 
entered at the exact same time, but I could only see this as a potential 
problem for a business with offices in both cities. 

As I said, I don't remember all the details, but I'm sure there were solid 
reasons for choosing to take transaction dates and store them in UTC, to be 
converted back to some arbitrary time zone at a later time. It makes my head 
hurt, though. 

David


 Original Message 
From: John Ralls 
Sent: Fri May 01 23:30:37 GMT+05:30 2020
To: "D." 
Cc: finf...@gmail.com, "D. via gnucash-user" 
Subject: Re: [GNC] Working with dates in Postgresql DB

David,

You're not thinking it through: It's about 11:00 on Friday 1 May here in 
California but it's 03:00 on Saturday 2 May in Western Australia. Chopping off 
the time doesn't solve anything, a point illustrated by Finfort when he pointed 
out that just changing the time on the errant dates 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 underlying system. At least, conceptually!
> 
> Is there any option to simply ignore the time portion in these timestamps? It 
> would seem to me that one could focus on that, and simplify the process piece 
> by piece. Of course, not being a programmer, I'm just a silly voice in the 
> wilderness.
> 
> David
> 
> 
>  Original Message 
> From: John Ralls 
> Sent: Fri May 01 10:32:09 GMT+05:30 2020
> To: "D." 
> Cc: "finf...@gmail.com" , "D. via gnucash-user" 
> 
> Subject: Re: [GNC] Working with dates in Postgresql DB
> 
> David,
> 
> I don't know why the decision was made to use time, it was taken long before 
> I joined the project, but it probably has to do with that being the way 
> computers keep time, in UTC and the accompanying date-time manipulation 
> functions in the C standard library were readily available. Over the years 
> various developers have piled more manipulation functions on top of it, or 
> added other libraries to the side because they made doing something easier, 
> and splattered it all over the code so that changing the base design would 
> involve chasing down and reworking all of those disparate functions. As I 
> said, no one has expressed much enthusiasm for taking it on.
> 
> Knowing now that using time instead of date was a poor decision is just 
> applying 20/20 hindsight to criticize Linas's decision 22 years ago. It can't 
> change it. I can't say that I would have decided differently.
> 
> Regards,
> 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 workarounds that take place to 
>> present the proper date around the world.
>> 
>> Wouldn't it be simpler just to store a bare date?
>> 
>> Or just ignore the time portion and drop the conversion between UTC and 
>> locale time altogether?
>> 
>> Everyone refers to them as dates ("transaction date" "invoice date" "posting 
>> date"). The software arbitrarily uses the same time for everything in a 
>> futile attempt to properly display dates for all timezones (the solution in 
>> this thread underscores that fact, insofar as you are recommending the user 
>> to arbitrarily change all other times to the "standard").
>> 
>> Of what use is it to store the added detail of an arbitrary timestamp in a 
>> field that is treated everywhere as a date? What is gained?
>> 
>> David T.
>> 
>> 
>>  Original Message 
>> From: John Ralls 
>> Sent: Fri May 01 00:48:57 GMT+05:30 2020
>> To: "finf...@gmail.com" 
>> Cc: Gnucash Users 
>> Subject: Re: [GNC] Working with dates in Postgresql DB
&g

Re: [GNC] Superannuation Co-Vid payment

[D. via gnucash-user]

Did you read thre recommendations that David Cousens gave in:

https://lists.gnucash.org/pipermail/gnucash-user/2020-May/090891.html

David T. 


 Original Message 
From: Chris Taylor 
Sent: Fri May 01 11:37:46 GMT+05:30 2020
To: gnucash-user@gnucash.org
Subject: [GNC] Superannuation Co-Vid payment

Hi everyone
Looking for some advice on how to setup a account system
Ok. What I have done is take up the Gov on the Co-Vid superannuation 
payment (withdrawal) of $10,000
What I wish to do is have it show up in bank account AAA that works day 
to day, I will be buying Gold this this money on a weekly basis that 
will come out of account AAA and got to AB company.
But I wish to know when I have transfered the 10,000.
Hope you can see what I want
Thanks for any input
Chris
I'm not asking if you think that what I'm doing is correct or not. That 
is MY decision not yours
I'm just asking the best way to manage it is 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
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] Adding Transactions From Another Program

[D. via gnucash-user]

That somehow seems to be an entirely justified substitution in my case! 


 Original Message 
From: John Ralls 
Sent: Fri May 01 10:34:54 GMT+05:30 2020
To: "D." 
Cc: Hal Vaughan , "D. via gnucash-user" 

Subject: 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 using! 
> 
> 
>  Original Message 
> From: "D. via gnucash-user" 
> Sent: Fri May 01 09:21:46 GMT+05:30 2020
> To: Hal Vaughan 
> Cc: "D. via gnucash-user" 
> Subject: Re: [GNC] Adding Transactions From Another Program
> 
> Hal, 
> 
> John Ralls, the person who manages the Mac end of GnuCash, has pointed out 
> that Homebrew simply uses the GnuCash dmg for its installation. That dmg does 
> not include python bindings, so the answer to your question is "No, Homebrew 
> does not include python. You would need to clozapine GnuCash yourself."
> 
> David T. 
> 
> 
>  Original Message 
> From: Hal Vaughan 
> Sent: Fri May 01 01:32:14 GMT+05:30 2020
> To: Gnucash 
> Subject: Re: [GNC] Adding Transactions From Another Program
> 
> Actually, this has me looking over what I am and am not still using.
> 
> Since Mac is still using Python 2.7, but Catalina is coming up and that 
> includes Python 3.x.  So I’m looking over what I use and what I don’t among 
> my decades of scripts.
> 
> Last I looked, pretty much every system like that usurped the originals.  At 
> the time, when I looked them over, it became clear to me why they did that 
> and it made sense.  But, again, that decision was something like 10 years ago 
> and I haven’t had time or cause to revisit it - until now.
> 
> Do you know if Homebrew can provide the Python bindings for GC?
> 
> 
> Hal
> 
>> On Apr 30, 2020, at 2:27 AM, Adrien Monteleone 
>>  wrote:
>> 
>> Have you investigated Homebrew vs. MacPorts?
>> 
>> Just curious if the Perl issues are the same.
>> 
>> Regards,
>> Adrien
>> 
>>> On Apr 30, 2020 w18d121, at 12:29 AM, Hal Vaughan  wrote:
>>> 
>>> I’ve checked out the bindings - as I mentioned in my original post, the 
>>> problem is that using the bindings on a Mac requires MacPorts.  I’ve had 
>>> issues before, since MacPorts (and other similar systems) usurp some of the 
>>> normal paths for things like Perl and Python.  I don’t use Perl for coding 
>>> anymore, but I have Perl scripts I’ve been using for over a decade that do 
>>> some simple work for me.  I had an important Perl script I was using that 
>>> used a specific Perl library.  I don’t remember which one it was, but when 
>>> I added MacPorts and tried to run my script a week later, it crashed.
>>> 
>>> I had no idea MacPorts, Fink, Homebrew, and similar systems usurped the 
>>> normal system paths for scripting languages.  When I installed it, and it 
>>> took over for Perl, it put in a system without all the libraries my scripts 
>>> used and some of the libraries that were available to me with a standard 
>>> Perl install (libraries I had installed from CPAN) would not install in the 
>>> new system.  I had to completely remove MacPorts to get my old scripts to 
>>> work.
>>> 
>>> I’d love to use MacPorts, since it makes a lot available to me that I can’t 
>>> easily add now (unless I start using a Linux VM), but that experience 
>>> taught me never to trust such a system.
>>> 
>>> I think it would be a lot easier for me to do this with Python bindings, 
>>> but I still use older scripts for things I need to do once a month or once 
>>> a year and I don’t want to risk breaking them again like they broke about a 
>>> decade ago when I installed MacPorts.
>>> 
>>> 
>>> Hal
>> 
>> 
>> ___
>> 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.
>> 
> 
> ___
> gnuc

Re: [GNC] Working with dates in Postgresql DB

[D. via gnucash-user]

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 underlying system. At least, conceptually! 

Is there any option to simply ignore the time portion in these timestamps? It 
would seem to me that one could focus on that, and simplify the process piece 
by piece. Of course, not being a programmer, I'm just a silly voice in the 
wilderness.

David


 Original Message 
From: John Ralls 
Sent: Fri May 01 10:32:09 GMT+05:30 2020
To: "D." 
Cc: "finf...@gmail.com" , "D. via gnucash-user" 

Subject: Re: [GNC] Working with dates in Postgresql DB

David,

I don't know why the decision was made to use time, it was taken long before I 
joined the project, but it probably has to do with that being the way computers 
keep time, in UTC and the accompanying date-time manipulation functions in the 
C standard library were readily available. Over the years various developers 
have piled more manipulation functions on top of it, or added other libraries 
to the side because they made doing something easier, and splattered it all 
over the code so that changing the base design would involve chasing down and 
reworking all of those disparate functions. As I said, no one has expressed 
much enthusiasm for taking it on.

Knowing now that using time instead of date was a poor decision is just 
applying 20/20 hindsight to criticize Linas's decision 22 years ago. It can't 
change it. I can't say that I would have decided differently.

Regards,
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 workarounds that take place to 
> present the proper date around the world.
> 
> Wouldn't it be simpler just to store a bare date?
> 
> Or just ignore the time portion and drop the conversion between UTC and 
> locale time altogether?
> 
> Everyone refers to them as dates ("transaction date" "invoice date" "posting 
> date"). The software arbitrarily uses the same time for everything in a 
> futile attempt to properly display dates for all timezones (the solution in 
> this thread underscores that fact, insofar as you are recommending the user 
> to arbitrarily change all other times to the "standard").
> 
> Of what use is it to store the added detail of an arbitrary timestamp in a 
> field that is treated everywhere as a date? What is gained?
> 
> David T.
> 
> 
>  Original Message 
> From: John Ralls 
> Sent: Fri May 01 00:48:57 GMT+05:30 2020
> To: "finf...@gmail.com" 
> Cc: Gnucash Users 
> Subject: 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 Apr 30, 2020, at 11:42 AM, finf...@gmail.com wrote:
>> 
>> It is not just adding one day, it depends on the time.
>> 
>> Looks like time 00:00:00 is the same date, not next.
>> 
>> From 21:00:00 is the next date in most cases, but I did not check all 
>> transactions manually =)
>> 
>> How the program converts this wrong dates to the correct ones in its GUI?
>> 
>> I believe I have found a correct way to convert all the dates including 
>> wrong ones to correct dates in Postgresql (pgAdmin 4):
>> 
>> 
>> date(t.post_date AT TIME ZONE 'UTC' AT TIME ZONE 'EEST') AS 
>> DATE_AT_timezone_EEST
>> 
>> EEST is a correct zone in my case. CEST does not work.
>> 
>> The transactions.post_date type is timestamp without timezone: 2017-12-31 
>> 21:00:00
>> 
>> t.post_date AT TIME ZONE 'EEST' AS timestamp_AT_timezone_EEST gives 
>> 2017-12-31 21:00:00+3
>> 
>> date(t.post_date AT TIME ZONE 'UTC' AT TIME ZONE 'EEST') AS 
>> DATE_AT_timezone_EEST gives 2018-01-01
>> 
>> Looks strange but works.
>> 
>> 2.
>> 
>> There are only 3 transactions with 22:00:00 not connected with invoices.
>> 
>> There is only 1 transaction with 21:00:00 not connected with invoices.
>> 
>> Thinking how to find them...
>> 
>> 
>> 
>> On 30/04/2020 21:25, John Ralls wrote:
>>> Hmm, true. Should be always, since you're in a time zone east of the prime 
>>> meridian. So you also want t

Re: [GNC] Adding Transactions From Another Program

[D. via gnucash-user]

"clozapine"="compile"

Not sure what dictionary my machine is using! 


 Original Message ----
From: "D. via gnucash-user" 
Sent: Fri May 01 09:21:46 GMT+05:30 2020
To: Hal Vaughan 
Cc: "D. via gnucash-user" 
Subject: Re: [GNC] Adding Transactions From Another Program

Hal, 

John Ralls, the person who manages the Mac end of GnuCash, has pointed out that 
Homebrew simply uses the GnuCash dmg for its installation. That dmg does not 
include python bindings, so the answer to your question is "No, Homebrew does 
not include python. You would need to clozapine GnuCash yourself."

David T. 


 Original Message 
From: Hal Vaughan 
Sent: Fri May 01 01:32:14 GMT+05:30 2020
To: Gnucash 
Subject: Re: [GNC] Adding Transactions From Another Program

Actually, this has me looking over what I am and am not still using.

Since Mac is still using Python 2.7, but Catalina is coming up and that 
includes Python 3.x.  So I’m looking over what I use and what I don’t among my 
decades of scripts.

Last I looked, pretty much every system like that usurped the originals.  At 
the time, when I looked them over, it became clear to me why they did that and 
it made sense.  But, again, that decision was something like 10 years ago and I 
haven’t had time or cause to revisit it - until now.

Do you know if Homebrew can provide the Python bindings for GC?


Hal

> On Apr 30, 2020, at 2:27 AM, Adrien Monteleone 
>  wrote:
> 
> Have you investigated Homebrew vs. MacPorts?
> 
> Just curious if the Perl issues are the same.
> 
> Regards,
> Adrien
> 
>> On Apr 30, 2020 w18d121, at 12:29 AM, Hal Vaughan  wrote:
>> 
>> I’ve checked out the bindings - as I mentioned in my original post, the 
>> problem is that using the bindings on a Mac requires MacPorts.  I’ve had 
>> issues before, since MacPorts (and other similar systems) usurp some of the 
>> normal paths for things like Perl and Python.  I don’t use Perl for coding 
>> anymore, but I have Perl scripts I’ve been using for over a decade that do 
>> some simple work for me.  I had an important Perl script I was using that 
>> used a specific Perl library.  I don’t remember which one it was, but when I 
>> added MacPorts and tried to run my script a week later, it crashed.
>> 
>> I had no idea MacPorts, Fink, Homebrew, and similar systems usurped the 
>> normal system paths for scripting languages.  When I installed it, and it 
>> took over for Perl, it put in a system without all the libraries my scripts 
>> used and some of the libraries that were available to me with a standard 
>> Perl install (libraries I had installed from CPAN) would not install in the 
>> new system.  I had to completely remove MacPorts to get my old scripts to 
>> work.
>> 
>> I’d love to use MacPorts, since it makes a lot available to me that I can’t 
>> easily add now (unless I start using a Linux VM), but that experience taught 
>> me never to trust such a system.
>> 
>> I think it would be a lot easier for me to do this with Python bindings, but 
>> I still use older scripts for things I need to do once a month or once a 
>> year and I don’t want to risk breaking them again like they broke about a 
>> decade ago when I installed MacPorts.
>> 
>> 
>> Hal
> 
> 
> ___
> 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.

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your su

Re: [GNC] Working with dates in Postgresql DB

[D. via gnucash-user]

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 workarounds that take place to present 
the proper date around the world. 

Wouldn't it be simpler just to store a bare date? 

Or just ignore the time portion and drop the conversion between UTC and locale 
time altogether?

Everyone refers to them as dates ("transaction date" "invoice date" "posting 
date"). The software arbitrarily uses the same time for everything in a futile 
attempt to properly display dates for all timezones (the solution in this 
thread underscores that fact, insofar as you are recommending the user to 
arbitrarily change all other times to the "standard"). 

Of what use is it to store the added detail of an arbitrary timestamp in a 
field that is treated everywhere as a date? What is gained? 

David T. 


 Original Message 
From: John Ralls 
Sent: Fri May 01 00:48:57 GMT+05:30 2020
To: "finf...@gmail.com" 
Cc: Gnucash Users 
Subject: 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 Apr 30, 2020, at 11:42 AM, finf...@gmail.com wrote:
> 
> It is not just adding one day, it depends on the time.
> 
> Looks like time 00:00:00 is the same date, not next.
> 
> From 21:00:00 is the next date in most cases, but I did not check all 
> transactions manually =)
> 
> How the program converts this wrong dates to the correct ones in its GUI?
> 
> I believe I have found a correct way to convert all the dates including wrong 
> ones to correct dates in Postgresql (pgAdmin 4):
> 
> 
> date(t.post_date AT TIME ZONE 'UTC' AT TIME ZONE 'EEST') AS 
> DATE_AT_timezone_EEST
> 
> EEST is a correct zone in my case. CEST does not work.
> 
> The transactions.post_date type is timestamp without timezone: 2017-12-31 
> 21:00:00
> 
> t.post_date AT TIME ZONE 'EEST' AS timestamp_AT_timezone_EEST gives 
> 2017-12-31 21:00:00+3
> 
> date(t.post_date AT TIME ZONE 'UTC' AT TIME ZONE 'EEST') AS 
> DATE_AT_timezone_EEST gives 2018-01-01
> 
> Looks strange but works.
> 
> 2.
> 
> There are only 3 transactions with 22:00:00 not connected with invoices.
> 
> There is only 1 transaction with 21:00:00 not connected with invoices.
> 
> Thinking how to find them...
> 
> 
> 
> On 30/04/2020 21:25, John Ralls wrote:
>> Hmm, true. Should be always, since you're in a time zone east of the prime 
>> meridian. So you also want to increment the day on those. I think it would 
>> be safest to do it in two queries, the first one being
>> 
>> update transactions post_date = post_date + interval '1 day' where 
>> post_date::TIME != '10: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.
>>> Setting all times to 10:59:00 will give wrong dates in the program.
>>> Now they are displayed correctly in the program somehow...
>>> 
>>> 
>>> 
 On Apr 30, 2020 at 20:59,  wrote:
 
 I don't think that's necessary.
 
 To fix the wrong times just do an update query, something like
 
 update transactions set post_date::TIME = 10:59:00 where post_date::TIME 
 != 10:59:00;
 
 I don't know Postgresql's date-time functions well enough to know if that 
 syntax works, you might have 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 help?
>  I can send you my gnucash file if it helps to find all the bugs.
>  And how can I change now my wrong dates in transactions?
>  
>> On Apr 30, 2020 at 20:41,  wrote:
>>  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:
>>>   Also I tried to unpost and post again. No changes.
>>> 
 On Apr 30, 2020 at 19:44,  wrote:
   Hi John,
   The result is:
   22:00:00   253
   00:00:00   18
   21:00:00   250
   23:00:00   22
   So wrong dates are only when I use invoices.

Re: [GNC] Adding Transactions From Another Program

[D. via gnucash-user]

Hal, 

John Ralls, the person who manages the Mac end of GnuCash, has pointed out that 
Homebrew simply uses the GnuCash dmg for its installation. That dmg does not 
include python bindings, so the answer to your question is "No, Homebrew does 
not include python. You would need to clozapine GnuCash yourself."

David T. 


 Original Message 
From: Hal Vaughan 
Sent: Fri May 01 01:32:14 GMT+05:30 2020
To: Gnucash 
Subject: Re: [GNC] Adding Transactions From Another Program

Actually, this has me looking over what I am and am not still using.

Since Mac is still using Python 2.7, but Catalina is coming up and that 
includes Python 3.x.  So I’m looking over what I use and what I don’t among my 
decades of scripts.

Last I looked, pretty much every system like that usurped the originals.  At 
the time, when I looked them over, it became clear to me why they did that and 
it made sense.  But, again, that decision was something like 10 years ago and I 
haven’t had time or cause to revisit it - until now.

Do you know if Homebrew can provide the Python bindings for GC?


Hal

> On Apr 30, 2020, at 2:27 AM, Adrien Monteleone 
>  wrote:
> 
> Have you investigated Homebrew vs. MacPorts?
> 
> Just curious if the Perl issues are the same.
> 
> Regards,
> Adrien
> 
>> On Apr 30, 2020 w18d121, at 12:29 AM, Hal Vaughan  wrote:
>> 
>> I’ve checked out the bindings - as I mentioned in my original post, the 
>> problem is that using the bindings on a Mac requires MacPorts.  I’ve had 
>> issues before, since MacPorts (and other similar systems) usurp some of the 
>> normal paths for things like Perl and Python.  I don’t use Perl for coding 
>> anymore, but I have Perl scripts I’ve been using for over a decade that do 
>> some simple work for me.  I had an important Perl script I was using that 
>> used a specific Perl library.  I don’t remember which one it was, but when I 
>> added MacPorts and tried to run my script a week later, it crashed.
>> 
>> I had no idea MacPorts, Fink, Homebrew, and similar systems usurped the 
>> normal system paths for scripting languages.  When I installed it, and it 
>> took over for Perl, it put in a system without all the libraries my scripts 
>> used and some of the libraries that were available to me with a standard 
>> Perl install (libraries I had installed from CPAN) would not install in the 
>> new system.  I had to completely remove MacPorts to get my old scripts to 
>> work.
>> 
>> I’d love to use MacPorts, since it makes a lot available to me that I can’t 
>> easily add now (unless I start using a Linux VM), but that experience taught 
>> me never to trust such a system.
>> 
>> I think it would be a lot easier for me to do this with Python bindings, but 
>> I still use older scripts for things I need to do once a month or once a 
>> year and I don’t want to risk breaking them again like they broke about a 
>> decade ago when I installed MacPorts.
>> 
>> 
>> Hal
> 
> 
> ___
> 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.