Re: [GNC] What is the purpose of hidden accounts?

[Jim DeLaHunt]

On 2021-08-21 22:13, Tim Hume via gnucash-user wrote:


Hi everyone,

In GnuCash one can create a hidden account. What legitimate purposes are there 
for hidden accounts?

Regards,

Tim.


Hi, Tim!

In GnuCash one can also create an account that is not hidden, use it for 
several years and many many transactions, and then decide you will no 
longer use it.


For instance, I have accounts which correspond to credit cards I 
cancelled long ago, and to expense categories which I no longer track. I 
don't want to delete all the transactions in the no-longer-used account, 
or live with the account cluttering up my Accounts tab.


Instead, one can change the account from not hidden to hidden. It is no 
longer in the way.


Another way I handle this situation is to rename the account to prefix 
its name by "ZZZ". That makes the account sort to the end of the list 
within its parent account, which keeps it mostly out of the way.


Also, bear in mind that "legitimate" is a function of the bookkeeper and 
the accounting rules they must follow. There are purposes which might be 
legitimate for the personal books of an individual, which might not be 
legitimate for the audited books of a corporation.


Does that answer your question?

  —Jim DeLaHunt

___
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] What is the purpose of hidden accounts?

[pyz01]

I can think of at least two tax account reasons for hidden accounts: 

1.  If you close or transfer an interest baring account in the middle of the
year and want to account for the interest you earned when you do you taxes
at the end of the year - rather than close the account - you would hide the
0 balance account for ease

2.  I pay off a loan account in the middle of the year where I paid
deductible interest and want to account for that deductible interest at the
end of the year for tax purpose - again rather than close the account I
would hide the 0 balance loan account


I can think of one aesthetics reason:

If I had several accounts grouped into one large "accumulation account" -- I
could hide the underlying accounts where I do the allocation of funds and
keep only the group account to show the overall balance. 

Ken 



-Original Message-
From: gnucash-user  On
Behalf Of Tim Hume via gnucash-user
Sent: Saturday, August 21, 2021 10:13 PM
To: GnuCash-User 
Subject: [GNC] What is the purpose of hidden accounts?

Hi everyone,

In GnuCash one can create a hidden account. What legitimate purposes are
there for hidden accounts?

Regards,

Tim.

Sent with ProtonMail Secure Email.
___
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] What is the purpose of hidden accounts?

[Tim Hume via gnucash-user]

Hi everyone,

In GnuCash one can create a hidden account. What legitimate purposes are there 
for hidden accounts?

Regards,

Tim.

Sent with ProtonMail Secure Email.
___
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 Quotes for BRKB

[dullege]

I'm using latest version GC with latest version Finance:Quote.  I use 
"Alphavantage" as my source for NYSE and NASDAQ stock prices.

In the Security Editor for GC, I created security as follows ... under parent 
NYSE ...

Full name: Berskshire Hathaway
Symbol: BRK.B
Display symbol: BRK.B
Type NYSE

Select option "Get Online Quotes"

Type of quote: 
Choose Single and  "Alphavantage, US"


This works assuming you have set up Alphavantage correctly (in GC->Edit 
Preferences->Online Quotes, you must supply your "Alpha Vantage API Key")

Regards,
Bill


-Original Message-
From: gnucash-user  On 
Behalf Of Larry Long
Sent: Sunday, 22 August 2021 1:21 AM
To: Gnucash Users 
Subject: [GNC] Getting Quotes for BRKB

Whenever I run the "Get Quotes" feature of the Price Database tool, the 
response is "Unable to get quotes..." message for Berkshire Hathaway, Inc. B 
stock.  Other stock prices are reporting okay.
I've tried editing it's Symbol/Abbreviation to read various ways (BRKB, BRK.B, 
BRK/B), but still no luck.Does anyone have a recommendation for what I need to 
change?
This is on a Windows 10 PC, using GC: Version: 4.4 Build ID: 4.4+(2020-12-28)
Finance::Quote: 1.49Using Single Quote Source:  Yahoo as JSON Thanks!
Larry
  
___
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] Finance::Quote on Mac M1

[Peter West]

I try to ensure that my Finder-initiated processes share the same environment 
as my shell processes by loading envvars with launchctl setenv with every 
invocation of my .profile. In order to fully test that, I need to create an app 
that just reports its environment. I haven’t done that.

Incidentally, it would be useful if there were an option in GnuCash to report 
the environment.

Peter
—
Peter West
p...@ehealth.id.au
“On these two commandments depend all the Law and the Prophets.”

> On 22 Aug 2021, at 10:40 am, Peter West  wrote:
> 
> It also works with my MacPorts perl promoted above the system perl.
> 
> Maybe just not finding gnc-fq-check, if that was the case, was enough to 
> generate that message.
> 
> Peter
> —
> Peter West
> p...@ehealth.id.au
> “On these two commandments depend all the Law and the Prophets.”
> 
>> On 21 Aug 2021, at 2:30 am, Peter West  wrote:
>> 
>> It’s working, using the system perl.
>> 
>> When I started to tinker, I copies the gnc-* binaries from 
>> Contents/Resources/bin to my local directory, so that I could run them 
>> without having to delve into GnuCash.app. I renamed that bin to bin~, and 
>> forgot about it. Your mention of 
>> /Applications/Gnucash.app/Contents/Resources/bin sent me to have a look in 
>> there.
>> 
>> I’ll experiment with the MacPorts perl (currently 5.34, whereas system perl 
>> is 5.30) and let you know. Thanks for your patience, which I hope you still 
>> have.
>> 
>> Peter
>> 
>> —
>> Peter West
>> p...@ehealth.id.au 
>> “On these two commandments depend all the Law and the Prophets.”
>> 
>>> On 21 Aug 2021, at 1:54 am, John Ralls >> > wrote:
>>> 
>>> That's what "Perl from other sources may or may not work and will 
>>> regardless require modifying 
>>> Gnucash.app/Contents/Resources/etc/gnucash/environment to set the perl path 
>>> and @INC so that GnuCash can find the right F::Q. If you insist on that 
>>> you're on your own." is about.
>>> 
>>> The issue is that when you launch from Finder there's no shell so GnuCash 
>>> can't see your MacPorts environment changes. Try launching GnuCash from a 
>>> shell window that does have the MacPorts environment.
>>> 
>>> Regards,
>>> John Ralls
>>> 
 On Aug 20, 2021, at 3:55 AM, Peter West >>> > wrote:
 
 Doesn’t work for me.
 
 Note: I’m assuming that the message Finance::Quote not installed properly, 
 when Add is invoked in the security editor, means that it’s not installed 
 properly.
 
 I depend a lot on MacPorts. I’ve tried forcing the installation with 
 MacPorts perl 5.34 foremost in my path, and with it (and all other perl 
 binaries) relegated in my path. It makes no difference to the appearance 
 of that message.
 
 In each case I have checked the installation paths of perl. In the first 
 the installation paths are in /opt/local, in the latter they are in /usr, 
 /Library, /System, /Network and /usr/local.
 
 Peter
 —
 Peter West
 p...@ehealth.id.au 
 “On these two commandments depend all the Law and the Prophets.”
 
> On 20 Aug 2021, at 2:21 pm, Colin  wrote:
> 
> Thank you John! I ran the commands you provided and Finance::Quote works 
> for the first time since I got my M1 MacBook Air! I’ve been watching the 
> Finance::Quote threads on the list the last few months, always hoping for 
> a solution I could manage to I implement to fix the issue. No doubt I 
> could have missed this if it was posted before, regardless you just made 
> my day.
> 
> For what it’s worth, my install of GnuCash was done the standard way - 
> downloading the DMG from the website. 
> 
> Also, to make the solution crystal clear to those who are not as good on 
> the command line, there was a typo in John’s most recent advice of the 
> commands to run. It is B::Keywords (capital K):
> 
> sudo cpan -i Test2; sudo cpan -f -i B::Keywords; sudo cpan -i 
> Finance::Quote
> 
> Very gratefully, 
> Colin
> 
>> On Aug 19, 2021, at 8:36 PM, gnucash-user-requ...@gnucash.org wrote:
>> 
>> Message: 5
>> Date: Thu, 19 Aug 2021 20:36:28 -0700
>> From: John Ralls mailto:jra...@ceridwen.us>>
>> To: davel...@mac.com 
>> Cc: Mailing List Gnucash > >
>> Subject: Re: [GNC] Finance::Quote on Mac M1
>> Message-ID: <4e108262-4136-47b2-ac7e-5ed553442...@ceridwen.us 
>> >
>> Content-Type: text/plain;charset=utf-8
>> 
>> You didn't read my letter very carefully: You should be able to get 
>> quotes now if you do `sudo cpan -i Test2; sudo cpan -f -i B::keywords; 
>> sudo cpan -i Finance::Quote`. The system perl is a universal binary and 
>> works in both native and Ros

Re: [GNC] Finance::Quote on Mac M1

[Peter West]

It also works with my MacPorts perl promoted above the system perl.

Maybe just not finding gnc-fq-check, if that was the case, was enough to 
generate that message.

Peter
—
Peter West
p...@ehealth.id.au
“On these two commandments depend all the Law and the Prophets.”

> On 21 Aug 2021, at 2:30 am, Peter West  wrote:
> 
> It’s working, using the system perl.
> 
> When I started to tinker, I copies the gnc-* binaries from 
> Contents/Resources/bin to my local directory, so that I could run them 
> without having to delve into GnuCash.app. I renamed that bin to bin~, and 
> forgot about it. Your mention of 
> /Applications/Gnucash.app/Contents/Resources/bin sent me to have a look in 
> there.
> 
> I’ll experiment with the MacPorts perl (currently 5.34, whereas system perl 
> is 5.30) and let you know. Thanks for your patience, which I hope you still 
> have.
> 
> Peter
> 
> —
> Peter West
> p...@ehealth.id.au 
> “On these two commandments depend all the Law and the Prophets.”
> 
>> On 21 Aug 2021, at 1:54 am, John Ralls > > wrote:
>> 
>> That's what "Perl from other sources may or may not work and will regardless 
>> require modifying Gnucash.app/Contents/Resources/etc/gnucash/environment to 
>> set the perl path and @INC so that GnuCash can find the right F::Q. If you 
>> insist on that you're on your own." is about.
>> 
>> The issue is that when you launch from Finder there's no shell so GnuCash 
>> can't see your MacPorts environment changes. Try launching GnuCash from a 
>> shell window that does have the MacPorts environment.
>> 
>> Regards,
>> John Ralls
>> 
>>> On Aug 20, 2021, at 3:55 AM, Peter West >> > wrote:
>>> 
>>> Doesn’t work for me.
>>> 
>>> Note: I’m assuming that the message Finance::Quote not installed properly, 
>>> when Add is invoked in the security editor, means that it’s not installed 
>>> properly.
>>> 
>>> I depend a lot on MacPorts. I’ve tried forcing the installation with 
>>> MacPorts perl 5.34 foremost in my path, and with it (and all other perl 
>>> binaries) relegated in my path. It makes no difference to the appearance of 
>>> that message.
>>> 
>>> In each case I have checked the installation paths of perl. In the first 
>>> the installation paths are in /opt/local, in the latter they are in /usr, 
>>> /Library, /System, /Network and /usr/local.
>>> 
>>> Peter
>>> —
>>> Peter West
>>> p...@ehealth.id.au 
>>> “On these two commandments depend all the Law and the Prophets.”
>>> 
 On 20 Aug 2021, at 2:21 pm, Colin  wrote:
 
 Thank you John! I ran the commands you provided and Finance::Quote works 
 for the first time since I got my M1 MacBook Air! I’ve been watching the 
 Finance::Quote threads on the list the last few months, always hoping for 
 a solution I could manage to I implement to fix the issue. No doubt I 
 could have missed this if it was posted before, regardless you just made 
 my day.
 
 For what it’s worth, my install of GnuCash was done the standard way - 
 downloading the DMG from the website. 
 
 Also, to make the solution crystal clear to those who are not as good on 
 the command line, there was a typo in John’s most recent advice of the 
 commands to run. It is B::Keywords (capital K):
 
 sudo cpan -i Test2; sudo cpan -f -i B::Keywords; sudo cpan -i 
 Finance::Quote
 
 Very gratefully, 
 Colin
 
> On Aug 19, 2021, at 8:36 PM, gnucash-user-requ...@gnucash.org wrote:
> 
> Message: 5
> Date: Thu, 19 Aug 2021 20:36:28 -0700
> From: John Ralls mailto:jra...@ceridwen.us>>
> To: davel...@mac.com 
> Cc: Mailing List Gnucash  >
> Subject: Re: [GNC] Finance::Quote on Mac M1
> Message-ID: <4e108262-4136-47b2-ac7e-5ed553442...@ceridwen.us 
> >
> Content-Type: text/plain; charset=utf-8
> 
> You didn't read my letter very carefully: You should be able to get 
> quotes now if you do `sudo cpan -i Test2; sudo cpan -f -i B::keywords; 
> sudo cpan -i Finance::Quote`. The system perl is a universal binary and 
> works in both native and Rosetta2 environments. Perl from other sources 
> may or may not work and will regardless require modifying 
> Gnucash.app/Contents/Resources/etc/gnucash/environment to set the perl 
> path and @INC so that GnuCash can find the right F::Q. If you insist on 
> that you're on your own.
> 
> As for a native M1 build, I haven't decided yet whether to do that before 
> the next major nettle release. I really don't like pushing development 
> software at ordinary users, it tends to make for unpleasant surprises. 
> Meanwhile GnuCash seems to work well under Rosetta2 so there's not a 
> strong argument for doing a native build until nettle's 

Re: [GNC] Job Costing as now available

[John Ralls]

I'll respond now: No, nothing like that has been contributed nor is it being 
contemplated by any of the core devs AFAIK. Well designed and written pull 
requests welcome.

Regards,
John Ralls


> On Aug 21, 2021, at 9:42 AM, Mike Butcher  wrote:
> 
> Don, have you seen any response to this message or find a solution
> otherwise? I too need this function in a big way. Making a new account for
> every order is horribly messy and cumbersome. It's been a year and a half
> and I was hoping someone on the development team might have an answer. I
> love GNUcash for my personal life but cannot use it for business without
> some form of jobcosting.  I have to reenter info into a database I
> assembled for that.
> 
> Take care,
> ~Mike Butcher
> 
> On Sat, May 23, 2020 at 4:04 PM doncram  wrote:
> 
>> Hi, I recently installed and am using GnuCash (Version: 3.10 / Build ID:
>> 3.10+(2020-04-11), on Windows). I am happy to see some functionality for
>> Job Costing has been added in recent years.  This is very important to
>> develop so that many more small businesses could possibly use GnuCash.  But
>> what is available vs. what is missing and critically needed?
>> 
>> Job Costing allows for projects to be defined for, say, construction firms
>> building individual houses, or catering firms doing catering jobs, or
>> manufacturing firms building batches of product.  Or it allows a nonprofit
>> or business to define a job for a specific grant or other restricted
>> funding source.  And then to track and match the revenues and expenses
>> specific to each project.
>> 
>> This is terribly important so that management can attempt to figure out
>> which jobs have been more profitable and why.  And I have seen arriving
>> users turned away from GnuCash (e.g. a catering firm a few years ago)
>> because it has been so clear that GnuCash can't serve them.  The catering
>> firm needed to do separate accounting & reports for each job, but if i
>> recall correctly was told that it should do it by creating new accounts
>> specific to each job.  So its Chart of Accounts would grow longer and
>> longer as its Sales and various Expense types of accounts would have to be
>> duplicated for each repetitive client/job.  It would need to create a new
>> account, e.g. Sales-Job#013 for the payments it received for job number 13,
>> and a new Food purchases-Job#13 and a new Labor-Job#13 etc. for each of its
>> standard type of expenses.  This would rapidly become totally unworkable,
>> and it does not allow for side-by-side comparison of
>> revenues/expenses/profitability of jobs, so of course the catering person
>> went away.  And for existing firms that do use GnuCash but have not tracked
>> separate projects/jobs to date, many of them could benefit if they could be
>> allowed to start doing so.
>> 
>> In the current stable version of GnuCash, it is now possible to create
>> jobs.  For example, I created a "test b company" with several expense
>> transactions, and created a "job1" underneath "customer A".  I can't see
>> yet how to assign job codes to any specific revenue or expense item.  In
>> any account register, a new Customer:Job column needs to appear, where I
>> would enter the relevant job for each line ("split"). I should not be
>> _required_ to enter anything into the Customer:Job column, but for any
>> split where I do want to assign the expense or revenue to a specific job, I
>> should be able to do so.  And, say if I pay $200 to one contractor for work
>> done on two jobs, I would create two splits, one for each job, and record,
>> say $120 of contractor expense for job#13 and $80 for job #14.
>> 
>> Then I want/need an Income Statement By Job report, which would be a
>> regular Income Statement in its first columns, and would report
>> job-specific income statements for each job in following columns.  So this
>> would possibly become a very wide report, but that is okay by me, as long
>> as I can scroll over to see any specific job.  And like for other reports,
>> I should be able to set Options / Display to show only the rows where there
>> is any non-zero data, and also only the columns where there is any non-zero
>> data (so in a report for Fiscal Year 2020, I don't have to see a column for
>> a job completed in 2018).
>> 
>> The only report I find, though, is the one at Reports/Business/Job, which
>> turns out to be some kind of Aging of Receivables report for just one job.
>> Instead of allowing me to run this report for all jobs (like should be
>> available in a general Aging of Receivables report, that should be able to
>> report on each customer and, for customers with more than one job, for each
>> job), it makes me pick just one job.
>> 
>> And I get only the following report (formatted more nicely than reflected
>> here):
>> 
>> Job Report: job1
>> 
>> test b company
>> 05/23/2020
>> customer A
>> 101 main st
>> 
>> Date Range: 01/01/2020 - 12/31/2020
>> Date Due Date Reference Type Description Amount
>> Total D

Re: [GNC] Getting Quotes for BRKB

[Derek Atkins]

Does anything else work, because this works for me.

$ gnc-fq-dump -v yahoo_json BRK-B
Finance::Quote fields Gnucash uses:
symbol: BRK-B<=== required
  date: 08/20/2021   <=== recommended
  currency: USD  <=== required
  last: 285.27   <=\
   nav:  <=== one of these
 price:  <=/
  timezone:  <=== optional

-derek


On Sat, August 21, 2021 11:57 am, Larry Long wrote:
>  Thanks for suggestion, but same result. 
> Larry
>
>
>
> On Saturday, August 21, 2021, 11:40:37 AM EDT, Derek Atkins
>  wrote:
>
>  Try BRK-B?
>
> -derek
>
> On Sat, August 21, 2021 11:20 am, Larry Long wrote:
>> Whenever I run the "Get Quotes" feature of the Price Database tool, the
>> response is "Unable to get quotes..." message for Berkshire Hathaway,
>> Inc.
>> B stock.  Other stock prices are reporting okay.
>> I've tried editing it's Symbol/Abbreviation to read various ways (BRKB,
>> BRK.B, BRK/B), but still no luck.Does anyone have a recommendation for
>> what I need to change?
>> This is on a Windows 10 PC, using GC: Version: 4.4
>> Build ID: 4.4+(2020-12-28)
>> Finance::Quote: 1.49Using Single Quote Source:  Yahoo as JSON
>> Thanks!
>> Larry
>>
>> ___
>> 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.
>>
>
>
> --
>       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.
>


-- 
   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] Getting Quotes for BRKB

[Colin]

Hi Larry,

As a sanity check, do online quotes work for other symbols? 

My online quotes work (thanks to John’s recent posts for us M1 Mac users :) and 
BRK-B worked without an issue.

This was with the default source, Alphavantage, US (the API must be set under 
Preference - Online Quotes). It also works using Yahoo as JSON as the source.

Here are all the settings in my Security Editor for BRK-B:

Name: Berkshire Hathway
Symbol: BRK-B
Display symbol: BRK-B
Type: NYSE

Get Online Quotes: Checked
Source: Single: Alphavantage US (or Yahoo as JSON)

Best,
Colin

> On Aug 21, 2021, at 9:00 AM, gnucash-user-requ...@gnucash.org wrote:
> 
> Message: 6
> Date: Sat, 21 Aug 2021 15:57:31 + (UTC)
> From: Larry Long mailto:llon...@gmail.com>>
> To: Derek Atkins mailto:de...@ihtfp.com>>
> Cc: Gnucash Users mailto:gnucash-user@gnucash.org>>
> Subject: Re: [GNC] Getting Quotes for BRKB
> Message-ID: <8073167.701853.1629561451...@mail.yahoo.com 
> >
> Content-Type: text/plain; charset=UTF-8
> 
> Thanks for suggestion, but same result.? 
> Larry
> 
> 
> 
>On Saturday, August 21, 2021, 11:40:37 AM EDT, Derek Atkins 
> mailto:de...@ihtfp.com>> wrote:  
> 
> Try BRK-B?
> 
> -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.

Re: [GNC] Job Costing as now available

[Mike Butcher]

Don, have you seen any response to this message or find a solution
otherwise? I too need this function in a big way. Making a new account for
every order is horribly messy and cumbersome. It's been a year and a half
and I was hoping someone on the development team might have an answer. I
love GNUcash for my personal life but cannot use it for business without
some form of jobcosting.  I have to reenter info into a database I
assembled for that.

Take care,
~Mike Butcher

On Sat, May 23, 2020 at 4:04 PM doncram  wrote:

> Hi, I recently installed and am using GnuCash (Version: 3.10 / Build ID:
> 3.10+(2020-04-11), on Windows). I am happy to see some functionality for
> Job Costing has been added in recent years.  This is very important to
> develop so that many more small businesses could possibly use GnuCash.  But
> what is available vs. what is missing and critically needed?
>
> Job Costing allows for projects to be defined for, say, construction firms
> building individual houses, or catering firms doing catering jobs, or
> manufacturing firms building batches of product.  Or it allows a nonprofit
> or business to define a job for a specific grant or other restricted
> funding source.  And then to track and match the revenues and expenses
> specific to each project.
>
> This is terribly important so that management can attempt to figure out
> which jobs have been more profitable and why.  And I have seen arriving
> users turned away from GnuCash (e.g. a catering firm a few years ago)
> because it has been so clear that GnuCash can't serve them.  The catering
> firm needed to do separate accounting & reports for each job, but if i
> recall correctly was told that it should do it by creating new accounts
> specific to each job.  So its Chart of Accounts would grow longer and
> longer as its Sales and various Expense types of accounts would have to be
> duplicated for each repetitive client/job.  It would need to create a new
> account, e.g. Sales-Job#013 for the payments it received for job number 13,
> and a new Food purchases-Job#13 and a new Labor-Job#13 etc. for each of its
> standard type of expenses.  This would rapidly become totally unworkable,
> and it does not allow for side-by-side comparison of
> revenues/expenses/profitability of jobs, so of course the catering person
> went away.  And for existing firms that do use GnuCash but have not tracked
> separate projects/jobs to date, many of them could benefit if they could be
> allowed to start doing so.
>
> In the current stable version of GnuCash, it is now possible to create
> jobs.  For example, I created a "test b company" with several expense
> transactions, and created a "job1" underneath "customer A".  I can't see
> yet how to assign job codes to any specific revenue or expense item.  In
> any account register, a new Customer:Job column needs to appear, where I
> would enter the relevant job for each line ("split"). I should not be
> _required_ to enter anything into the Customer:Job column, but for any
> split where I do want to assign the expense or revenue to a specific job, I
> should be able to do so.  And, say if I pay $200 to one contractor for work
> done on two jobs, I would create two splits, one for each job, and record,
> say $120 of contractor expense for job#13 and $80 for job #14.
>
> Then I want/need an Income Statement By Job report, which would be a
> regular Income Statement in its first columns, and would report
> job-specific income statements for each job in following columns.  So this
> would possibly become a very wide report, but that is okay by me, as long
> as I can scroll over to see any specific job.  And like for other reports,
> I should be able to set Options / Display to show only the rows where there
> is any non-zero data, and also only the columns where there is any non-zero
> data (so in a report for Fiscal Year 2020, I don't have to see a column for
> a job completed in 2018).
>
> The only report I find, though, is the one at Reports/Business/Job, which
> turns out to be some kind of Aging of Receivables report for just one job.
> Instead of allowing me to run this report for all jobs (like should be
> available in a general Aging of Receivables report, that should be able to
> report on each customer and, for customers with more than one job, for each
> job), it makes me pick just one job.
>
> And I get only the following report (formatted more nicely than reflected
> here):
>
> Job Report: job1
>
> test b company
> 05/23/2020
> customer A
> 101 main st
>
> Date Range: 01/01/2020 - 12/31/2020
> Date Due Date Reference Type Description Amount
> Total Due $0.00
> 0-30 days 31-60 days 61-90 days 91+ days
> $0.00 $0.00 $0.00 $0.00
>
> Yikes, that is not what Job Costing is, at all!  Has better functionality
> been added in unstable new versions of GnuCash?  If not, could it please be
> added quickly?  (allow assignment of job code to any split, allow reporting
> of Balance Sheet By Job and Income Statement

Re: [GNC] Getting Quotes for BRKB

[Larry Long]

 Thanks for suggestion, but same result.  
Larry



On Saturday, August 21, 2021, 11:40:37 AM EDT, Derek Atkins 
 wrote:  
 
 Try BRK-B?

-derek

On Sat, August 21, 2021 11:20 am, Larry Long wrote:
> Whenever I run the "Get Quotes" feature of the Price Database tool, the
> response is "Unable to get quotes..." message for Berkshire Hathaway, Inc.
> B stock.  Other stock prices are reporting okay.
> I've tried editing it's Symbol/Abbreviation to read various ways (BRKB,
> BRK.B, BRK/B), but still no luck.Does anyone have a recommendation for
> what I need to change?
> This is on a Windows 10 PC, using GC: Version: 4.4
> Build ID: 4.4+(2020-12-28)
> Finance::Quote: 1.49Using Single Quote Source:  Yahoo as JSON
> Thanks!
> Larry
>
> ___
> 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.
>


-- 
      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] Getting Quotes for BRKB

[Derek Atkins]

Try BRK-B?

-derek

On Sat, August 21, 2021 11:20 am, Larry Long wrote:
> Whenever I run the "Get Quotes" feature of the Price Database tool, the
> response is "Unable to get quotes..." message for Berkshire Hathaway, Inc.
> B stock.  Other stock prices are reporting okay.
> I've tried editing it's Symbol/Abbreviation to read various ways (BRKB,
> BRK.B, BRK/B), but still no luck.Does anyone have a recommendation for
> what I need to change?
> This is on a Windows 10 PC, using GC: Version: 4.4
> Build ID: 4.4+(2020-12-28)
> Finance::Quote: 1.49Using Single Quote Source:  Yahoo as JSON
> Thanks!
> Larry
>
> ___
> 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.
>


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

[GNC] Getting Quotes for BRKB

[Larry Long]

Whenever I run the "Get Quotes" feature of the Price Database tool, the 
response is "Unable to get quotes..." message for Berkshire Hathaway, Inc. B 
stock.  Other stock prices are reporting okay.
I've tried editing it's Symbol/Abbreviation to read various ways (BRKB, BRK.B, 
BRK/B), but still no luck.Does anyone have a recommendation for what I need to 
change?
This is on a Windows 10 PC, using GC: Version: 4.4
Build ID: 4.4+(2020-12-28)
Finance::Quote: 1.49Using Single Quote Source:  Yahoo as JSON
Thanks!
Larry
  
___
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] Reports in Alternate Language

[Paul Kroitor]

Duplicate please ignore!

Sent from my iPad

> On Aug 21, 2021, at 5:49 AM, p...@kroitor.ca wrote:
> 
> Hello all. This may have already been covered, but after the death of Nabble
> I can't see how to do searches throughout the archive.
> 
> 
> 
> I need to produce accounting reports in a different language (French), but I
> would prefer to use a single installation of Gnucash (all my other sets of
> books are English). 
> 
> 
> 
> 1.Can I switch languages just for printing the reports? If yes, how? I
> understand that the Account Names, Descriptions, and so on are all going to
> need to be recorded in French in this set of books.
> 
> 
> 
> 2.If that's not possible, how can I install two versions of GnuCash on
> Windows? Can I open the books in English Gnucash, work on them, then close
> and reopen the same books in the French GnuCash?
> 
> 
> 
> Thanks as always for all help and suggestions,
> 
> Paul
> 
> ___
> 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] Reports in Alternate Language

[paul]

Hello all. This may have already been covered, but after the death of Nabble
I can't see how to do searches throughout the archive.

 

I need to produce accounting reports in a different language (French), but I
would prefer to use a single installation of Gnucash (all my other sets of
books are English). 

 

1.  Can I switch languages just for printing the reports? If yes, how? I
understand that the Account Names, Descriptions, and so on are all going to
need to be recorded in French in this set of books.

 

2.  If that's not possible, how can I install two versions of GnuCash on
Windows? Can I open the books in English Gnucash, work on them, then close
and reopen the same books in the French GnuCash?

 

Thanks as always for all help and suggestions,

Paul

___
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] Finance::Quote on Mac M1

[David Reed via gnucash-user]

So does this mean a future official build of gnucash will have an ARM version 
and we'll be able to get quotes again? That would be great!

Thanks,
Dave


> On Aug 19, 2021, at 5:43 PM, John Ralls  wrote:
> 
> You can't escape the problems. ;-)
> 
> FWIW I just completed building on an M1 with Monterey. Amazingly, there were 
> only a few minor problems, one of which has nothing to do with M1 or 
> Monterey: Boost's download site changed.
> 
> Libdbi and libdbi-drivers last release tarballs were made in 2013 and include 
> linker arguments that aren't supported. I switched the build to git clones so 
> that the build can be regenerated from scratch. Both that and the Boost 
> change are committed to gnucash-on-osx.
> 
> The other problem, and perhaps the one that stopped you on MacPorts, is that 
> even the latest release of Nettle from last month doesn't support ARM64. It 
> tries to compile ARM32 and fails noisily for hundreds of unrecognized 
> assembler instructions. The solution is to clone the master branch from 
> http://git.lysator.liu.se/nettle/nettle and build that instead.
> 
> BTW, on Finance::Quote I force-installed B::Keywords and installed Test2, 
> after which everything else built correctly. Once F::Q was installed in 
> /Library/Perl GnuCash was able to recognize it and enable the Get Quotes 
> button.
> 
> Regards,
> John Ralls
> 
> 
> 
> 
>> On Aug 19, 2021, at 1:40 AM, Peter West  wrote:
>> 
>> Hi John,
>> 
>> I had already run into problems trying to build GnuCash on MacPorts. I was 
>> encouraged to try to build by reading 
>> .
>> 
>> Peter
>> —
>> Peter West
>> p...@ehealth.id.au
>> “For behold, when the sound of your greeting came to my ears, the baby in my 
>> womb leaped for joy.”
>> 
>>> On 17 Aug 2021, at 1:02 am, John Ralls  wrote:
>>> 
>>> 
>>> Support for gtk-osx is on its mailing list, 
>>> https://mail.gnome.org/mailman/listinfo/gtk-osx-users-list, but before you 
>>> go there I'll remind you that one of gtk-osx's basic requirements is that 
>>> you must not have Homebrew or MacPorts visible to it.
>>> 
>>> Since you have MacPorts installed already the simplest way forward is to 
>>> use that to build GnuCash. 
>>> 
>>> That said there's no shared code between anything to do with GnuCash and 
>>> perl or any CPAN modules beyond the macOS SDK. Building GnuCash from source 
>>> won't help you get Finance::Quote going.
>>> 
>>> Regards,
>>> John Ralls
>>> 
 On Aug 16, 2021, at 7:18 AM, Peter West  wrote:
 
 I removed the offending PREFIX line from jhbuildrc-custom, and immediately 
 ran into a similar problem.
 
 File "/Users/gtkdev/Source/jhbuild/jhbuild/config.py", line 194, in load
  execfile(filename, config)
 File "/Users/gtkdev/Source/jhbuild/jhbuild/utils/compat.py", line 67, in 
 execfile
  exec(code, globals, locals)
 File "/Users/gtkdev/.config/jhbuildrc", line 470, in 
  exec(compile(open(_user_rc, "rb").read(), _user_rc, 'exec'))
 File "/Users/gtkdev/.config/jhbuildrc-custom", line 26, in 
  module_extra_env['icu'] = {'CXXFLAGS':os.environ['CXXFLAGS'] + ' 
 -std=c++17'}
 File 
 "/opt/local/Library/Frameworks/Python.framework/Versions/3.8/lib/python3.8/os.py",
  line 675, in __getitem__
  raise KeyError(key) from None
 KeyError: 'CXXFLAGS'
 jhbuild: could not load config file
 
 In this one, there is obviously a default value, but the Error is 
 propagating all the way up.
 
 Peter
 
 
 —
 Peter West
 p...@ehealth.id.au
 “For behold, when the sound of your greeting came to my ears, the baby in 
 my womb leaped for joy.”
 
> On 16 Aug 2021, at 8:21 pm, Peter West  wrote:
> 
> I’ve decided to go the whole hog and build GNC. Hopefully, I can get 
> M1-specific GNC and Finance::Quote working together without any 
> mysterious issues.
> 
> After gtk-osx-setup.sh, I try to run jhbuild bootstrap-gtk-osx, and it 
> fails immediately.
> 
> ~ 20:14:24$ jhbuild bootstrap-gtk-osx
> Loading .env environment variables...
> Traceback (most recent call last):
> File "/Users/gtkdev/Source/jhbuild/jhbuild/config.py", line 194, in load
>  execfile(filename, config)
> File "/Users/gtkdev/Source/jhbuild/jhbuild/utils/compat.py", line 67, in 
> execfile
>  exec(code, globals, locals)
> File "/Users/gtkdev/.config/jhbuildrc", line 470, in 
>  exec(compile(open(_user_rc, "rb").read(), _user_rc, 'exec'))
> File "/Users/gtkdev/.config/jhbuildrc-custom", line 3, in 
>  prefix = os.environ['PREFIX']
> File 
> "/opt/local/Library/Frameworks/Python.framework/Versions/3.8/lib/python3.8/os.py",
>  line 675, in __getitem__
>  raise KeyError(key) from None
> KeyError: 'PREFIX'
> jhbuild: could not load config file
> 
> 
> I'
> 
> The first thing in .config/jhbuildrc-custom is
> prefix = os.e