Re: [GNC] No Stock Quotes - OS Monterey, Gnucash 4.8(Build ID: 4.8a+(2021-09-28))

[David Reiser via gnucash-user]

Matthias Fasching noted last summer that he needed to install Mozilla::CA to 
get quotes working for him in Big Sur.

That missing certificate collection was what had been keeping my office mac 
from being able retrieve quotes for at least a couple Gnucash versions. 
That change was after dealing with the B::Keywords test failures and needing to 
upgrade the Test2 module.


--
Dave Reiser
dbrei...@icloud.com





> On Feb 9, 2022, at 11:51 PM, john  wrote: 
> 
> Your dump looks pretty much llke a rerun of the same problem except that now 
> you also have an SSL certificate problem.
> 
> /usr/bin is right where you'd expect it, but you can't see it with Finder, 
> only from the terminal. For example you can type
>   ls -l /usr/bin/make
> and if it's there get back something like
>   -rwxr-xr-x  1 root  wheel  167088 Dec  7 15:39 /usr/bin/make*
> 
> Did you install Xcode in /Applications without messing with the name? If not 
> you might try
>  sudo xcode-select -s /Path/to Xcode.app
> making the obvious substitution. 
> Or, since something seems confused, maybe run that even if you *did* install 
> it in /Applications.
> 
> Since make is in the Xcode bundle you might be able to work around the 
> problem for Finance::Quote with 
>  export PATH="$PATH:/Path/to/Xcode.app/Contents/Developer/usr/bin"
> and then running gnc-fq-update again.
> 
> Regards,
> John Ralls
> 
> 
>> On Feb 9, 2022, at 8:05 PM, dennis adams  wrote:
>> 
>> John, thanks for the response.  I believe I have the full XCode (32GB worth) 
>> but don’t know for sure since I don’t use it.  I only have it because of GC. 
>>  I hadn’t opened it but did after your response and told it to install the 
>> “additional components”.  After that, I ran the “gnc-fq-update” command 
>> again and got the “You need to install the following Perl modules: 
>> Finance::Quote” result when I ran a check, like before.  Terminal info is 
>> attached.  (Note: I changed the GC app name from Gnucash 4.8.app to just 
>> Gnucash.app so you will see that change in the sudo command line). 
>> 
>> You stated that on your mac, “xcrun” and “make”are in the /usr/bin.  Not 
>> sure where that is but I right clicked the xCode app and then clicked show 
>> contents.  With this following path: xCode.app/Contents/Developer/usr/bin   
>> I did find “make” but did not find “xcrun”.  Is that the correct location 
>> where they should be?  There are a lot of other xc—— commands but no “xcrun”
>> 
>> You stated I could install command-line tools by running  “xcode-select 
>> —install”.  Even though I think I have the full xCode with 32.12 GB, I went 
>> ahead and ran the command.  Since I am on slow DSL (2.87Mbps) it showed 215 
>> hours remaining to download so I stopped it.  
>> 
>> Any other thoughts or ways to get “xcrun”?
>> 
>> 
>> 
>> 
>> 
>> 
>> 
>>> On Feb 9, 2022, at 18:54, john >> > wrote:
>>> 
>>> 
>>> 
 On Feb 9, 2022, at 1:36 PM, dennis adams >>> > wrote:
 
 Upgraded to Monterey (V12.2) and got black screen for GC.  Read mailing 
 list and saw  where I needed to get GC 4.8 which I did.  Installed 4.8 and 
 GC came up and displayed correctly but am now unable to get stock quotes.  
 The Price Database Get Quotes button is greyed out.
 
 Went to Applications, GC 4.8, Contents, Resources, bin and clicked on 
 gnc-fq-check which said:
 
 “Last login: Wed Feb 9 13:18:07 on ttys000
 /Applications/Gnucash\ 4.8.app/Contents/Resources/bin/gnc-fq-check ; exit; 
 dwa1@dwa1 ~ % /Applications/Gnucash\ 
 4.8.app/Contents/Resources/bin/gnc-fq-check
 ; exit;
 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
 Saving session...
 ...copying shared history...
 ...saving history...truncating history files... ...completed.
 [Process completed] “
 
 I had old version of XCode which didn’t work with Monterey so updated to 
 version 13.2.1 and then ran “sudo /Applications/Gnucash\ 
 4.8.app/Contents/Resources/bin/gnc-fq- update”.  Terminal info from that 
 run is attached, but basically it didn’t work since when I ran the 
 gnc-fq-check again, I got the same message as above.
 
 I’m well out of my depth with all this and not sure where to go from here. 
  The Terminal information does not really make sense to me but there were 
 several statements like “missing xcrun at: 
 /Library/Developer/CommandLineTools/usr/bin/xcrun “  and “the following 
 files are missing in your kit: .travis.yml “ as well as others
 
 It would seem that if I had all the FQ commands in 
 /Applications/Gnucash\4.8.app/Contents/Resources/bin/ xxx then I have FQ 
 installed but the check says no.  Don’t know where to go from here.  Any 
 help would be appreciated.
>>> 
>>> Most of the modules failed to 

[GNC] Settings in environment.local does not work

[redfrog2...@outlook.com]

Gnucash Developers & Maintainers:



    Hello! I am a Chinese user of your product. Recently, I have changed 

language settings, and placed them in my custom environment.local file.

However, I found that display language in gnucash are still not changed.

Could you please help me solving this problem?



Yours,



Bite Gao

Jan 28th, 2022

Attachment:
content in environment.local:
# Gnucash's language settings:
LANG=zh_CN
LANGUAGE=en_US
___
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] No Stock Quotes - OS Monterey, Gnucash 4.8(Build ID: 4.8a+(2021-09-28))

[john]

Your dump looks pretty much llke a rerun of the same problem except that now 
you also have an SSL certificate problem.

/usr/bin is right where you'd expect it, but you can't see it with Finder, only 
from the terminal. For example you can type
   ls -l /usr/bin/make
and if it's there get back something like
   -rwxr-xr-x  1 root  wheel  167088 Dec  7 15:39 /usr/bin/make*

Did you install Xcode in /Applications without messing with the name? If not 
you might try
  sudo xcode-select -s /Path/to Xcode.app
making the obvious substitution. 
Or, since something seems confused, maybe run that even if you *did* install it 
in /Applications.

Since make is in the Xcode bundle you might be able to work around the problem 
for Finance::Quote with 
  export PATH="$PATH:/Path/to/Xcode.app/Contents/Developer/usr/bin"
and then running gnc-fq-update again.

Regards,
John Ralls


> On Feb 9, 2022, at 8:05 PM, dennis adams  wrote:
> 
> John, thanks for the response.  I believe I have the full XCode (32GB worth) 
> but don’t know for sure since I don’t use it.  I only have it because of GC.  
> I hadn’t opened it but did after your response and told it to install the 
> “additional components”.  After that, I ran the “gnc-fq-update” command again 
> and got the “You need to install the following Perl modules: Finance::Quote” 
> result when I ran a check, like before.  Terminal info is attached.  (Note: I 
> changed the GC app name from Gnucash 4.8.app to just Gnucash.app so you will 
> see that change in the sudo command line). 
>  
> You stated that on your mac, “xcrun” and “make”are in the /usr/bin.  Not sure 
> where that is but I right clicked the xCode app and then clicked show 
> contents.  With this following path: xCode.app/Contents/Developer/usr/bin   I 
> did find “make” but did not find “xcrun”.  Is that the correct location where 
> they should be?  There are a lot of other xc—— commands but no “xcrun”
> 
> You stated I could install command-line tools by running  “xcode-select 
> —install”.  Even though I think I have the full xCode with 32.12 GB, I went 
> ahead and ran the command.  Since I am on slow DSL (2.87Mbps) it showed 215 
> hours remaining to download so I stopped it.  
> 
> Any other thoughts or ways to get “xcrun”?
> 
> 
> 
> 
> 
> 
> 
>> On Feb 9, 2022, at 18:54, john > > wrote:
>> 
>> 
>> 
>>> On Feb 9, 2022, at 1:36 PM, dennis adams >> > wrote:
>>> 
>>> Upgraded to Monterey (V12.2) and got black screen for GC.  Read mailing 
>>> list and saw  where I needed to get GC 4.8 which I did.  Installed 4.8 and 
>>> GC came up and displayed correctly but am now unable to get stock quotes.  
>>> The Price Database Get Quotes button is greyed out.
>>> 
>>> Went to Applications, GC 4.8, Contents, Resources, bin and clicked on 
>>> gnc-fq-check which said:
>>> 
>>> “Last login: Wed Feb 9 13:18:07 on ttys000
>>> /Applications/Gnucash\ 4.8.app/Contents/Resources/bin/gnc-fq-check ; exit; 
>>> dwa1@dwa1 ~ % /Applications/Gnucash\ 
>>> 4.8.app/Contents/Resources/bin/gnc-fq-check
>>> ; exit;
>>> 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
>>> Saving session...
>>> ...copying shared history...
>>> ...saving history...truncating history files... ...completed.
>>> [Process completed] “
>>> 
>>> I had old version of XCode which didn’t work with Monterey so updated to 
>>> version 13.2.1 and then ran “sudo /Applications/Gnucash\ 
>>> 4.8.app/Contents/Resources/bin/gnc-fq- update”.  Terminal info from that 
>>> run is attached, but basically it didn’t work since when I ran the 
>>> gnc-fq-check again, I got the same message as above.
>>> 
>>> I’m well out of my depth with all this and not sure where to go from here.  
>>> The Terminal information does not really make sense to me but there were 
>>> several statements like “missing xcrun at: 
>>> /Library/Developer/CommandLineTools/usr/bin/xcrun “  and “the following 
>>> files are missing in your kit: .travis.yml “ as well as others
>>> 
>>> It would seem that if I had all the FQ commands in 
>>> /Applications/Gnucash\4.8.app/Contents/Resources/bin/ xxx then I have FQ 
>>> installed but the check says no.  Don’t know where to go from here.  Any 
>>> help would be appreciated.
>> 
>> Most of the modules failed to install and it looks like it was because there 
>> was no `make` either on the path or in the command-line tools directory. You 
>> could install command-line tools by running 
>>  xcode-select --install
>> but that should be superfluous if you've installed the full Xcode. Having 
>> installed it have you run it so that it can install it's "additional 
>> components"? On my mac xcrun and make are in /usr/bin.
>> 
>> Regards,
>> John Ralls
>> 
> 
> 

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

Re: [GNC] No Stock Quotes - OS Monterey, Gnucash 4.8(Build ID: 4.8a+(2021-09-28))

[dennis adams]

John, thanks for the response.  I believe I have the full XCode (32GB worth) 
but don’t know for sure since I don’t use it.  I only have it because of GC.  I 
hadn’t opened it but did after your response and told it to install the 
“additional components”.  After that, I ran the “gnc-fq-update” command again 
and got the “You need to install the following Perl modules: Finance::Quote” 
result when I ran a check, like before.  Terminal info is attached.  (Note: I 
changed the GC app name from Gnucash 4.8.app to just Gnucash.app so you will 
see that change in the sudo command line).



You stated that on your mac, “xcrun” and “make”are in the /usr/bin.  Not sure 
where that is but I right clicked the xCode app and then clicked show contents. 
 With this following path: xCode.app/Contents/Developer/usr/bin   I did find 
“make” but did not find “xcrun”.  Is that the correct location where they 
should be?  There are a lot of other xc—— commands but no “xcrun”

You stated I could install command-line tools by running  “xcode-select 
—install”.  Even though I think I have the full xCode with 32.12 GB, I went 
ahead and ran the command.  Since I am on slow DSL (2.87Mbps) it showed 215 
hours remaining to download so I stopped it.

Any other thoughts or ways to get “xcrun”?







On Feb 9, 2022, at 18:54, john mailto:jra...@ceridwen.us>> 
wrote:



On Feb 9, 2022, at 1:36 PM, dennis adams 
mailto:smad...@hotmail.com>> wrote:

Upgraded to Monterey (V12.2) and got black screen for GC.  Read mailing list 
and saw  where I needed to get GC 4.8 which I did.  Installed 4.8 and GC came 
up and displayed correctly but am now unable to get stock quotes.  The Price 
Database Get Quotes button is greyed out.

Went to Applications, GC 4.8, Contents, Resources, bin and clicked on 
gnc-fq-check which said:

“Last login: Wed Feb 9 13:18:07 on ttys000
/Applications/Gnucash\ 4.8.app/Contents/Resources/bin/gnc-fq-check ; exit; 
dwa1@dwa1 ~ % /Applications/Gnucash\ 4.8.app/Contents/Resources/bin/gnc-fq-check
; exit;
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
Saving session...
...copying shared history...
...saving history...truncating history files... ...completed.
[Process completed] “

I had old version of XCode which didn’t work with Monterey so updated to 
version 13.2.1 and then ran “sudo /Applications/Gnucash\ 
4.8.app/Contents/Resources/bin/gnc-fq- update”.  Terminal info from that run is 
attached, but basically it didn’t work since when I ran the gnc-fq-check again, 
I got the same message as above.

I’m well out of my depth with all this and not sure where to go from here.  The 
Terminal information does not really make sense to me but there were several 
statements like “missing xcrun at: 
/Library/Developer/CommandLineTools/usr/bin/xcrun “  and “the following files 
are missing in your kit: .travis.yml “ as well as others

It would seem that if I had all the FQ commands in 
/Applications/Gnucash\4.8.app/Contents/Resources/bin/ xxx then I have FQ 
installed but the check says no.  Don’t know where to go from here.  Any help 
would be appreciated.

Most of the modules failed to install and it looks like it was because there 
was no `make` either on the path or in the command-line tools directory. You 
could install command-line tools by running
 xcode-select --install
but that should be superfluous if you've installed the full Xcode. Having 
installed it have you run it so that it can install it's "additional 
components"? On my mac xcrun and make are in /usr/bin.

Regards,
John Ralls




Update4 FQ 2-9-22.pdf
Description: Update4 FQ 2-9-22.pdf
___
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] No Stock Quotes - OS Monterey, Gnucash 4.8(Build ID: 4.8a+(2021-09-28))

[john]

> On Feb 9, 2022, at 1:36 PM, dennis adams  wrote:
> 
> Upgraded to Monterey (V12.2) and got black screen for GC.  Read mailing list 
> and saw  where I needed to get GC 4.8 which I did.  Installed 4.8 and GC came 
> up and displayed correctly but am now unable to get stock quotes.  The Price 
> Database Get Quotes button is greyed out.
> 
> Went to Applications, GC 4.8, Contents, Resources, bin and clicked on 
> gnc-fq-check which said:
> 
> “Last login: Wed Feb 9 13:18:07 on ttys000
> /Applications/Gnucash\ 4.8.app/Contents/Resources/bin/gnc-fq-check ; exit; 
> dwa1@dwa1 ~ % /Applications/Gnucash\ 
> 4.8.app/Contents/Resources/bin/gnc-fq-check
> ; exit;
> 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
> Saving session...
> ...copying shared history...
> ...saving history...truncating history files... ...completed.
> [Process completed] “
> 
> I had old version of XCode which didn’t work with Monterey so updated to 
> version 13.2.1 and then ran “sudo /Applications/Gnucash\ 
> 4.8.app/Contents/Resources/bin/gnc-fq- update”.  Terminal info from that run 
> is attached, but basically it didn’t work since when I ran the gnc-fq-check 
> again, I got the same message as above.
> 
> I’m well out of my depth with all this and not sure where to go from here.  
> The Terminal information does not really make sense to me but there were 
> several statements like “missing xcrun at: 
> /Library/Developer/CommandLineTools/usr/bin/xcrun “  and “the following files 
> are missing in your kit: .travis.yml “ as well as others
> 
> It would seem that if I had all the FQ commands in 
> /Applications/Gnucash\4.8.app/Contents/Resources/bin/ xxx then I have FQ 
> installed but the check says no.  Don’t know where to go from here.  Any help 
> would be appreciated.

Most of the modules failed to install and it looks like it was because there 
was no `make` either on the path or in the command-line tools directory. You 
could install command-line tools by running 
  xcode-select --install
but that should be superfluous if you've installed the full Xcode. Having 
installed it have you run it so that it can install it's "additional 
components"? On my mac xcrun and make are in /usr/bin.

Regards,
John Ralls

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Question about stock entry

[David Carlson]

 Κωνσταντίνος,
you are not the first to have this trouble.  See
https://bugs.gnucash.org/show_bug.cgi?id=769256.

On Wed, Feb 9, 2022 at 5:18 PM Κωνσταντίνος  wrote:

> Yeah, i found it and it works!
> I misunderstood that this option (and the option next to it) was by
> default the same with the account's option you choose to do the new account
> action.
> And the guide mentions it clearly, but i thought that was been selected by
> default.
>
> Maybe i read to much for one day...
>
> Really thank you all of you guys, for the help, quick reaction and the
> friendly atmosphere!
>
> Have a great day!
>
> 10 Φεβ 2022 01:02:20 David Carlson :
>
> As Fred hinted, the Account type box where you need to select security (in
> English?) is on the lower left, not near the top or right where you might
> expect to see it.
>
> On Wed, Feb 9, 2022 at 4:26 PM Fred Bone  wrote:
>
>> On 09 February 2022 at 20:47, Κωνσταντίνος said:
>>
>> > And how i can set it in stock?
>>
>> The "Account Type" dropdown is at the bottom left of the "New Account"
>> window, which I think is the one you showed (part of) in your original
>> message. You will probably need to scroll down to find the entry for
>> "Stock". You need to do this before clicking "Select", and then you will
>> get a "Select security" window instead of "Select currency".
>>
>> Sorry for not making this clear earlier: I thought it was mentioned in
>> the documentation.
>>
>> ___
>> 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
>
>

-- 
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] Question about stock entry

[Κωνσταντίνος]

Yeah, i found it and it works!
I misunderstood that this option (and the option next to it) was by default the 
same with the account's option you choose to do the new account action.
And the guide mentions it clearly, but i thought that was been selected by 
default.

Maybe i read to much for one day...

Really thank you all of you guys, for the help, quick reaction and the friendly 
atmosphere!

Have a great day!

10 Φεβ 2022 01:02:20 David Carlson :

> As Fred hinted, the Account type box where you need to select security (in 
> English?) is on the lower left, not near the top or right where you might 
> expect to see it.
> 
> On Wed, Feb 9, 2022 at 4:26 PM Fred Bone  wrote:
>> On 09 February 2022 at 20:47, Κωνσταντίνος said:
>> 
>>> And how i can set it in stock?
>> 
>> The "Account Type" dropdown is at the bottom left of the "New Account"
>> window, which I think is the one you showed (part of) in your original
>> message. You will probably need to scroll down to find the entry for
>> "Stock". You need to do this before clicking "Select", and then you will
>> get a "Select security" window instead of "Select currency".
>> 
>> Sorry for not making this clear earlier: I thought it was mentioned in
>> the documentation.
>> 
>> ___
>> 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] Question about stock entry

[David Carlson]

As Fred hinted, the Account type box where you need to select security (in
English?) is on the lower left, not near the top or right where you might
expect to see it.

On Wed, Feb 9, 2022 at 4:26 PM Fred Bone  wrote:

> On 09 February 2022 at 20:47, Κωνσταντίνος said:
>
> > And how i can set it in stock?
>
> The "Account Type" dropdown is at the bottom left of the "New Account"
> window, which I think is the one you showed (part of) in your original
> message. You will probably need to scroll down to find the entry for
> "Stock". You need to do this before clicking "Select", and then you will
> get a "Select security" window instead of "Select currency".
>
> Sorry for not making this clear earlier: I thought it was mentioned in
> the documentation.
>
> ___
> 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] Question about stock entry

[Fred Bone]

On 09 February 2022 at 20:47, Κωνσταντίνος said:

> And how i can set it in stock?

The "Account Type" dropdown is at the bottom left of the "New Account" 
window, which I think is the one you showed (part of) in your original 
message. You will probably need to scroll down to find the entry for 
"Stock". You need to do this before clicking "Select", and then you will 
get a "Select security" window instead of "Select currency".

Sorry for not making this clear earlier: I thought it was mentioned in 
the documentation.

___
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] filtering in report

[Andreas Hentze]

Hi Geoff,


I think that the logical complement of this is:
(See https://en.wikipedia.org/wiki/De_Morgan%27s_laws)

NOT Second-Last character is 'u' AND
NOT Second-Last character is 'o'
  OR
NOT Last character is 'b' AND
NOT Last character is 'r'

Which, as a regular expression, is:

([^uo].)|(.[^br])$

I think this should work, give it a try!


this does not work, becaus of the OR "|" this expression filters both to
the last character. Due to deMorgan I would need a NOT to the complete
expression. I played around, but find no working combination.

As the negotiation only works with one character, I will use the special
character "_" at the end of the name. This works for me, because I have
an association where I have only two groups of accounts: my main
accounts and some other groups. Another possibility ist to write some
account names in capital letters as regEx is case sensitive.

thanks a lot for your effort and even if this was not the solution, you
gave me the hint to the workaround.

best regards
Andy

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

[GNC] No Stock Quotes - OS Monterey, Gnucash 4.8(Build ID: 4.8a+(2021-09-28))

[dennis adams]

Upgraded to Monterey (V12.2) and got black screen for GC.  Read mailing list 
and saw  where I needed to get GC 4.8 which I did.  Installed 4.8 and GC came 
up and displayed correctly but am now unable to get stock quotes.  The Price 
Database Get Quotes button is greyed out.

Went to Applications, GC 4.8, Contents, Resources, bin and clicked on 
gnc-fq-check which said:

“Last login: Wed Feb 9 13:18:07 on ttys000
/Applications/Gnucash\ 4.8.app/Contents/Resources/bin/gnc-fq-check ; exit; 
dwa1@dwa1 ~ % /Applications/Gnucash\ 4.8.app/Contents/Resources/bin/gnc-fq-check
; exit;
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
Saving session...
...copying shared history...
...saving history...truncating history files... ...completed.
[Process completed] “

I had old version of XCode which didn’t work with Monterey so updated to 
version 13.2.1 and then ran “sudo /Applications/Gnucash\ 
4.8.app/Contents/Resources/bin/gnc-fq- update”.  Terminal info from that run is 
attached, but basically it didn’t work since when I ran the gnc-fq-check again, 
I got the same message as above.

I’m well out of my depth with all this and not sure where to go from here.  The 
Terminal information does not really make sense to me but there were several 
statements like “missing xcrun at: 
/Library/Developer/CommandLineTools/usr/bin/xcrun “  and “the following files 
are missing in your kit: .travis.yml “ as well as others

It would seem that if I had all the FQ commands in 
/Applications/Gnucash\4.8.app/Contents/Resources/bin/ xxx then I have FQ 
installed but the check says no.  Don’t know where to go from here.  Any help 
would be appreciated.



Update3 FQ 2-9-22.pdf
Description: Update3 FQ 2-9-22.pdf
___
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 out of order

[Gyle McCollam]

In the COA you can still click (single) on a heading to sort by alpha or 
reverse alpha.  If the account code is not showing, you can click on the arrow 
on the extreme right to show columns that you are able to display.  Account 
Code is one of them.  Once displayed you can click on the heading to show in 
order or reverse order.


Thank You,
Gyle McCollam

Gyle McCollam

609.680.2326 Mobile

gmccol...@live.com   email


From: gnucash-user  on 
behalf of David Carlson 
Sent: Wednesday, February 9, 2022 1:25 PM
To: Bruce Irving 
Cc: Gnucash Users 
Subject: Re: [GNC] Accounts out of order

In older versions of GnuCash you could click or double click [I forgot
which] on almost any column head and the window sorted alphabetical ly or
reverse alphabetical ly.  Has that changed ?  Also, in the COA there was a
column for account numbers which could be used for sorting.



On Wed, Feb 9, 2022, 12:10 PM Bruce Irving  wrote:

> I learned accounting BC (Before Computer).
> By prefixing the account Name with the pcode sorted as I was used to.
> Unfortunately, they are no longer in order.  And the Account Summary Report
> is in a different order!
> Is it possible to get these back to alphanumeric order?
> I'm using Build ID: Flathub 4.9-2
>
> Bruce
> ___
> 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] Question about stock entry

[Κωνσταντίνος]

And how i can set it in stock?

(No accounting to the ancient greek lessons... what a same! Haha Yeah, 
translating accounting is difficult. Thankfully i had some lessons at the 
universe so it is easier to understand the ngucash. Ευχαριστώ/thanks!).

9 Φεβ 2022 22:35:03 Fred Bone :

> On 09 February 2022 at 19:16, Κωνσταντίνος said:
> 
>> Hello, 
>> I am glad that I am starting using the Gnucash. I read the guide and
>> seams quite easy and friendly to use.  My question is about the stock
>> entries.  
>> 
>> In the guide  
>> https://code.gnucash.org/docs/C/gnucash-guide/invest-setup1.html#invest-se
>> tup-stockaccounts2  it is clearly what it needs, but when I go to the
>> Gnucash I can’t find other option than currency for the type of the
>> stock. 
> 
> You need to make sure the "account type" is set to "stock", first. Sorry
> I don't know this in Greek (I did do Ancient Greek at school, many years
> ago, but the syllabus strangely omitted any mention of accounting).
___
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 about stock entry

[Fred Bone]

On 09 February 2022 at 19:16, Κωνσταντίνος said:

> Hello, 
> I am glad that I am starting using the Gnucash. I read the guide and
> seams quite easy and friendly to use.  My question is about the stock
> entries.  
> 
> In the guide  
> https://code.gnucash.org/docs/C/gnucash-guide/invest-setup1.html#invest-se
> tup-stockaccounts2  it is clearly what it needs, but when I go to the
> Gnucash I can’t find other option than currency for the type of the
> stock. 

You need to make sure the "account type" is set to "stock", first. Sorry 
I don't know this in Greek (I did do Ancient Greek at school, many years 
ago, but the syllabus strangely omitted any mention of accounting).

___
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] Flatpak 4.9-2 Online Quotes not working (name resolution issue?)

[Guille Lopez]

Hi Frank and David,

Thanks for confirming my suspicion that this had indeed something to do with my 
environment and not GnuCash. For some reason org.gnome.Platform 41 does not 
work with the contents of my /etc/resolv.conf.

Either commenting out 1 particular server in /etc/resolv.conf (a local server) 
or downgrading and therefore using org.gnome.Platform 40 solves the issue. So 
it seems a problem in the interaction between the org.gnome.Platform and that 
particular DNS server.

In any case, that would be a question for a different forum, not the GnuCash 
mail-list.

Thanks a lot!!

Guille

On 07/02/2022 21:55, David H wrote:

Frank/Guille,

I'm using Flatpak version 4.9-2 on both Linux Mint 20.3 and Ubuntu 
21.10 - quotes retrieval is fine...


Cheers David H.

On Tue, 8 Feb 2022 at 06:48, Frank H. Ellenberger 
 wrote:


Hello Guille,

you can see the changes at
https://github.com/flathub/org.gnucash.GnuCash/commits/master
They contain:
org.gnome.Platform 41 instead of 40;
…

HTH
Frank

P.S.
I wonder why nobody else reported  problems as the changes were tested
before in the nighlies:
https://github.com/Gnucash/gnucash-on-flatpak/commits/master


Am 06.02.22 um 21:54 schrieb Guille Lopez:
> Hello,
>
> Since I updated to GnuCash Flatpak 4.9-2 I cannot get the Online
quote
> retrieval to work. Reverting to Flatpak 4.9-1 fixes de problem.
>
> I tried to do a little bit of "debugging" starting the /bin/sh
inside
> the Flatpak and running some network-related commands (not much is
> available though).
>
> - In 4.9-1  "wget google.com " returns 200 OK
> - In 4.9-1  "wget 172.217.18.110" return 200 OK
> - in 4.9-2  "wget google.com " returns
"unable to resolve host address
> ‘google.com ’"
> - In 4.9-2  "wget 172.217.18.110" return 301 Moved permanently
and then
> "unable to resolve host address ‘www.google.com
’".
> - In 4.9-2  "wget 192.168.X.Y(local network)" return 200 OK so the
> network seems to be working.
>
> It looks to me that the name resolution is not working properly.
> Normally I would assume this to be a problem linked Flatpak
installation
> rather than GnuCash but when I upgrade/downgrade for debugging
only the
> GnuCash Flatpak is changing.
>
> Does anyone have any idea about this issue? I am reluctant to
raise a
> bug yet since I cannot really exclude my own environment here...
>
> Thanks!
> Guille

___
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 Digest, Vol 227, Issue 15

[Κωνσταντίνος]

Oops, sorry!
My name is Konstantinos Kekkas, about the topic "Question about stock entry".

9 Φεβ 2022 21:42:43 Bruce Irving :

> Thank you, David for reminding me what I had read many moons ago and hadn't
> needed til now.
> Clicking on the header did correct the sort order.
> Bruce
> 
> -- Forwarded message --
> From: David Carlson 
> To: Bruce Irving 
> Cc: Gnucash Users 
> Bcc:
> Date: Wed, 9 Feb 2022 12:25:35 -0600
> Subject: Re: [GNC] Accounts out of order
> In older versions of GnuCash you could click or double click [I forgot
> which] on almost any column head and the window sorted alphabetical ly or
> reverse alphabetical ly.  Has that changed ?  Also, in the COA there was a
> column for account numbers which could be used for sorting.
> 
> 
> 
> On Wed, Feb 9, 2022, 12:10 PM Bruce Irving  wrote:
> 
>> I learned accounting BC (Before Computer).
>> By prefixing the account Name with the pcode sorted as I was used to.
>> Unfortunately, they are no longer in order.  And the Account Summary
> Report
>> is in a different order!
>> Is it possible to get these back to alphanumeric order?
>> I'm using Build ID: Flathub 4.9-2
>> 
>> Bruce
>> ___
>> 
> 
> On Wed, Feb 9, 2022 at 12:18 PM  wrote:
> 
>> Send gnucash-user mailing list submissions to
>>     gnucash-user@gnucash.org
>> 
>> To subscribe or unsubscribe via the World Wide Web, visit
>>     https://lists.gnucash.org/mailman/listinfo/gnucash-user
>> or, via email, send a message with subject or body 'help' to
>>     gnucash-user-requ...@gnucash.org
>> 
>> You can reach the person managing the list at
>>     gnucash-user-ow...@gnucash.org
>> 
>> When replying, please edit your Subject line so it is more specific
>> than "Re: Contents of gnucash-user digest..."
>> Today's Topics:
>> 
>>    1.  Accounts out of order (Bruce Irving)
>>    2. Re:  Accounts out of order (David Carlson)
>>    3.  Question about stock entry ()
>> 
>> 
>> 
>> -- Forwarded message --
>> From: Bruce Irving 
>> To: Gnucash Users 
>> Cc:
>> Bcc:
>> Date: Wed, 9 Feb 2022 11:09:28 -0700
>> Subject: [GNC] Accounts out of order
>> I learned accounting BC (Before Computer).
>> By prefixing the account Name with the pcode sorted as I was used to.
>> Unfortunately, they are no longer in order.  And the Account Summary Report
>> is in a different order!
>> Is it possible to get these back to alphanumeric order?
>> I'm using Build ID: Flathub 4.9-2
>> 
>> Bruce
>> 
>> 
>> 
>> 
>> -- Forwarded message --
>> From: David Carlson 
>> To: Bruce Irving 
>> Cc: Gnucash Users 
>> Bcc:
>> Date: Wed, 9 Feb 2022 12:25:35 -0600
>> Subject: Re: [GNC] Accounts out of order
>> In older versions of GnuCash you could click or double click [I forgot
>> which] on almost any column head and the window sorted alphabetical ly or
>> reverse alphabetical ly.  Has that changed ?  Also, in the COA there was a
>> column for account numbers which could be used for sorting.
>> 
>> 
>> 
>> On Wed, Feb 9, 2022, 12:10 PM Bruce Irving  wrote:
>> 
>>> I learned accounting BC (Before Computer).
>>> By prefixing the account Name with the pcode sorted as I was used to.
>>> Unfortunately, they are no longer in order.  And the Account Summary
>> Report
>>> is in a different order!
>>> Is it possible to get these back to alphanumeric order?
>>> I'm using Build ID: Flathub 4.9-2
>>> 
>>> Bruce
>>> ___
>>> 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.
>>> 
>> 
>> 
>> 
>> 
>> -- Forwarded message --
>> From: "Κωνσταντίνος" 
>> To: gnucash-user@gnucash.org
>> Cc:
>> Bcc:
>> Date: Wed, 9 Feb 2022 19:16:11 + (UTC)
>> Subject: [GNC] Question about stock entry
>> Hello,
>> I am glad that I am starting using the Gnucash. I read the guide and seams
>> quite easy and friendly to use.
>> My question is about the stock entries.
>> 
>> In the guide
>> 
>> https://code.gnucash.org/docs/C/gnucash-guide/invest-setup1.html#invest-setup-stockaccounts2
>> 
>> it is clearly what it needs, but when I go to the Gnucash I can’t find
>> other option than currency for the type of the stock.
>> 
>> What supposes to be shown…
>>   [cid:f7328306-5524-425a-b076-2a89de6a8cd5]
>> 
>> ...and that is shown
>> [cid:da7d58e4-b612-4195-b92b-68d61da7217a]
>> 
>> Can you tell me what to do to have the other option than currency?
>> 
>> Few translation to be easier for you:
>> Μετοχή= Stock
>> Τύπος= Type
>> Νομίσματα= Currency
>> 
>> Thank you in advance,
>> 
>> 
>> ___
>> 

Re: [GNC] gnucash-user Digest, Vol 227, Issue 15

[Bruce Irving]

Thank you, David for reminding me what I had read many moons ago and hadn't
needed til now.
Clicking on the header did correct the sort order.
Bruce

-- Forwarded message --
From: David Carlson 
To: Bruce Irving 
Cc: Gnucash Users 
Bcc:
Date: Wed, 9 Feb 2022 12:25:35 -0600
Subject: Re: [GNC] Accounts out of order
In older versions of GnuCash you could click or double click [I forgot
which] on almost any column head and the window sorted alphabetical ly or
reverse alphabetical ly.  Has that changed ?  Also, in the COA there was a
column for account numbers which could be used for sorting.



On Wed, Feb 9, 2022, 12:10 PM Bruce Irving  wrote:

> I learned accounting BC (Before Computer).
> By prefixing the account Name with the pcode sorted as I was used to.
> Unfortunately, they are no longer in order.  And the Account Summary
Report
> is in a different order!
> Is it possible to get these back to alphanumeric order?
> I'm using Build ID: Flathub 4.9-2
>
> Bruce
> ___
>

On Wed, Feb 9, 2022 at 12:18 PM  wrote:

> Send gnucash-user mailing list submissions to
> gnucash-user@gnucash.org
>
> To subscribe or unsubscribe via the World Wide Web, visit
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> or, via email, send a message with subject or body 'help' to
> gnucash-user-requ...@gnucash.org
>
> You can reach the person managing the list at
> gnucash-user-ow...@gnucash.org
>
> When replying, please edit your Subject line so it is more specific
> than "Re: Contents of gnucash-user digest..."
> Today's Topics:
>
>1.  Accounts out of order (Bruce Irving)
>2. Re:  Accounts out of order (David Carlson)
>3.  Question about stock entry ()
>
>
>
> -- Forwarded message --
> From: Bruce Irving 
> To: Gnucash Users 
> Cc:
> Bcc:
> Date: Wed, 9 Feb 2022 11:09:28 -0700
> Subject: [GNC] Accounts out of order
> I learned accounting BC (Before Computer).
> By prefixing the account Name with the pcode sorted as I was used to.
> Unfortunately, they are no longer in order.  And the Account Summary Report
> is in a different order!
> Is it possible to get these back to alphanumeric order?
> I'm using Build ID: Flathub 4.9-2
>
> Bruce
>
>
>
>
> -- Forwarded message --
> From: David Carlson 
> To: Bruce Irving 
> Cc: Gnucash Users 
> Bcc:
> Date: Wed, 9 Feb 2022 12:25:35 -0600
> Subject: Re: [GNC] Accounts out of order
> In older versions of GnuCash you could click or double click [I forgot
> which] on almost any column head and the window sorted alphabetical ly or
> reverse alphabetical ly.  Has that changed ?  Also, in the COA there was a
> column for account numbers which could be used for sorting.
>
>
>
> On Wed, Feb 9, 2022, 12:10 PM Bruce Irving  wrote:
>
> > I learned accounting BC (Before Computer).
> > By prefixing the account Name with the pcode sorted as I was used to.
> > Unfortunately, they are no longer in order.  And the Account Summary
> Report
> > is in a different order!
> > Is it possible to get these back to alphanumeric order?
> > I'm using Build ID: Flathub 4.9-2
> >
> > Bruce
> > ___
> > 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.
> >
>
>
>
>
> -- Forwarded message --
> From: "Κωνσταντίνος" 
> To: gnucash-user@gnucash.org
> Cc:
> Bcc:
> Date: Wed, 9 Feb 2022 19:16:11 + (UTC)
> Subject: [GNC] Question about stock entry
> Hello,
> I am glad that I am starting using the Gnucash. I read the guide and seams
> quite easy and friendly to use.
> My question is about the stock entries.
>
> In the guide
>
> https://code.gnucash.org/docs/C/gnucash-guide/invest-setup1.html#invest-setup-stockaccounts2
>
> it is clearly what it needs, but when I go to the Gnucash I can’t find
> other option than currency for the type of the stock.
>
> What supposes to be shown…
>   [cid:f7328306-5524-425a-b076-2a89de6a8cd5]
>
>  ...and that is shown
>  [cid:da7d58e4-b612-4195-b92b-68d61da7217a]
>
> Can you tell me what to do to have the other option than currency?
>
> Few translation to be easier for you:
> Μετοχή= Stock
> Τύπος= Type
> Νομίσματα= Currency
>
> Thank you in advance,
>
>
> ___
>
> 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 

Re: [GNC] Question about stock entry

[Derek Atkins]

HI,

On Wed, February 9, 2022 2:16 pm, Κωνσταντίνος wrote:
> Hello, 
> I am glad that I am starting using the Gnucash. I read the guide and seams
> quite easy and friendly to use. 
> My question is about the stock entries.  
>
> In the guide  
> https://code.gnucash.org/docs/C/gnucash-guide/invest-setup1.html#invest-setup-stockaccounts2
>  
> it is clearly what it needs, but when I go to the Gnucash I can’t find
> other option than currency for the type of the stock. 
>
> What supposes to be shown…
>   [cid:f7328306-5524-425a-b076-2a89de6a8cd5] 
>
>  ...and that is shown
>  [cid:da7d58e4-b612-4195-b92b-68d61da7217a]
>  
> Can you tell me what to do to have the other option than currency?  

You need to change the account type to either Stock or Mutual first, and
only then will you be able to select a commodity that is not a currency.

> Few translation to be easier for you:
> Μετοχή= Stock 
> Τύπος= Type 
> Νομίσματα= Currency  
>
> Thank you in advance, 

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

Re: [GNC] Accounts out of order

[David Carlson]

In older versions of GnuCash you could click or double click [I forgot
which] on almost any column head and the window sorted alphabetical ly or
reverse alphabetical ly.  Has that changed ?  Also, in the COA there was a
column for account numbers which could be used for sorting.



On Wed, Feb 9, 2022, 12:10 PM Bruce Irving  wrote:

> I learned accounting BC (Before Computer).
> By prefixing the account Name with the pcode sorted as I was used to.
> Unfortunately, they are no longer in order.  And the Account Summary Report
> is in a different order!
> Is it possible to get these back to alphanumeric order?
> I'm using Build ID: Flathub 4.9-2
>
> Bruce
> ___
> 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.

[GNC] Accounts out of order

[Bruce Irving]

I learned accounting BC (Before Computer).
By prefixing the account Name with the pcode sorted as I was used to.
Unfortunately, they are no longer in order.  And the Account Summary Report
is in a different order!
Is it possible to get these back to alphanumeric order?
I'm using Build ID: Flathub 4.9-2

Bruce
___
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] Managing multiple vehicles

[Michael Hendry]

I do the bookkeeping for my Rotary Club, and have to keep track of individual 
donations from members in order to claim Gift Aid on these donations.

I’m constrained in that I need to keep the donors’ names confidential in 
reports to the club but need to identify the donors for the claim to HMRC.

I worked around this by using the Memo field to identify the member concerned, 
and disabling the Memo field in routine reports to the club. When the time 
comes to make the Gift Aid claim (annually) I use a Transaction Report on the 
Income:Gift Aid account sorted with “Memo” as the Primary Key.

This gives me a subtotal table listing the members and their contributions in 
alphabetical order, with a total, followed by full reports of the donations 
from each individual.

I think this would work for Fernando, with a single Expenses:Vehicles account 
separated into expenses for each vehicle using the Memo field.

If you want Expenses:Vehicles:Fuel, Expenses:Vebicles:Repairs etc, just select 
all of the relevant accounts in the Accounts tab when setting up the 
Transaction Report.

If you forget to fill the Memo field of any transaction, or are inconsistent in 
spelling it will become obvious in the report, allocating a separate section 
for Tractor-1, Tractor_1 and Tractor1 etc.

Michael


> On 8 Feb 2022, at 22:16, Adrien Monteleone  
> wrote:
> 
> Play with your tags and the Transaction Report, particularly the Regex filter 
> option.
> 
> This won't get you a single report with all vehicles, but you can isolate 
> transactions by vehicle that way. (and maybe get something useful out of the 
> Multi-Column Report for more than one vehicle, if not all of them)
> 
> Note, not all fields are filterable, so be sure to check that Report option's 
> tooltip for specifics. (if Notes is an option, turn on Double-Line mode and 
> use that field, it is well suited for it)
> 
> You may not end up with exactly the format you want, but you should be able 
> to get the data.
> 
> Another option would be to do a Find and filter on your tags, then run an 
> Account Report on the result. Unfortunately, there is no current facility to 
> save Find criteria for repetition like there is for customized Reports, so 
> you'd have to do those Finds every time for every vehicle, which might be too 
> much work for 10 vehicles.
> 
> Regards,
> Adrien
> 
> On 2/3/22 1:41 PM, Fernando Castro wrote:
>> Hello everyone,
>> I'm having a rather intense discussion with a friend on a topic that might
>> be common knowledge to most people with accounting experience, and since we
>> are both newbies on accounting and GnuCash, I decided to ask around.
>> We are working on a GnuCash file to keep up with expenses and incomes of a
>> farm. This farm has over 10 vehicles that we'd like to keep track of gas,
>> maintenance and tax expenses. From my point of view creating accounts and
>> subaccounts for this (no matter the hierarchy you chose) would be
>> unmanageable and full of redundancy. This also represents only a small
>> fraction of the farm's finance, but it is important being able to produce a
>> chart with gas expenses for each vehicle.
>> I've read that using other softwares one can benefit from "category" to
>> better filter the information you want and create reports, I've tried using
>> the description field for that using a simple structure like Expenses:Gas
>> and placing the vehicle details as description but it just doesn't work, or
>> maybe I'm doing something wrong?
>> I've also considered making accounts for the vehicles as assets, but
>> honestly I have no idea if this would be a viable solution and even correct
>> from an accounting point of view...
>> Does anyone have any tips on how to go about it?
> 
> 
> ___
> 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.