Re: [GNC] Be careful with `petty cash'

2020-09-11 Thread Chris Green
On Thu, Sep 10, 2020 at 05:54:26PM -0400, Michael or Penny Novack wrote:
> 
> But unwise to trust honor too far. My normal practice is every few hours to
> remove some amount of currency leaving just enough for change and replacing
> what I took out with a signed, dated, time stamped slip for what I have
> removed. Those included with the (witnessed) currency count.
> 
If only!  We simply don't have that sort of level of income, at any
time or place.  Our major fund-raising event are mostly events run in
the village hall where people have bought tickets and, anyway, the
money is handled by the organisers (not me).

The only cash I get to see is Sunday collections and the contents of
the offertory box.

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


Re: [GNC] I'm still a bit confused about when things get saved.

2020-09-11 Thread Chris Green
On Thu, Sep 10, 2020 at 07:25:33PM -0700, John Ralls wrote:
> Tried that with GnuCash? It isn't a macOS native app and probably doesn't 
> benefit from those features. I'd go for the UPS, but since recent financial 
> activity is generally pretty easy to recover and re-enter maybe the 
> risk/payback 
> works out differently for you. 
> 
I run incremental backups of all the important data one my system,
in particular I run hourly incremental backups of my 'home' directory
(I use Linux) and this contains just about everything of significance.

Thus I can never lose more than an hour's work and, if I want to go
back to an earlier situation it's easy.  Since they're incremental
backups if nothing changes then no extra space is consumed (except for
a little overhead).

Thus, on a separate drive, on my desktop system I have the following
backups:-
day-2  day-4  day-6  hour-1   hour-2  hour-4  hour-6  hour-8 week-1  week-3 
 week-5
day-1  day-3  day-5  day-7  hour-10  hour-3  hour-5  hour-7  hour-9  week-2 
 week-4

On a separate system, out in the garage well away from the house, I
have another 'layer' of incremental backups at longer intervals (day,
month, year) going back several years.

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


Re: [GNC] reindex?

2020-09-11 Thread Adrien Monteleone
That I do not know off hand. Maybe the wiki or help/guide have something 
for you...


Regards,
Adrien

On 9/10/20 11:48 PM, ToddAndMargo via gnucash-user wrote:


Is there some log or other report that will tell me
the outcome of such a repair?

Many thanks,
-T




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


Re: [GNC] Short cuts for things

2020-09-11 Thread Liz Dodd
On Thu, 10 Sep 2020 16:48:22 -0500
Adrien Monteleone  wrote:

> I also can see a use case for not wanting that transaction to be 
> committed instantly. You might need to investigate documentation, 
> investigate another account, do a find to make sure this isn't a 
> duplicate, see what reference or memo you used last time you entered
> a similar transaction, check a report, etc. Only when you have all
> the info, might you want the transaction to commit.


I second this, when I do my quarterly BAS for tax in AU
I have to juggle through about 8 accounts and sift the answer down to
about 3 totals. Just a little problem, they only deal in whole dollars
and I have to round up and down as well as take percentages out of my
vehicle expenses GST.
In theory I could automate the items through a report system but I
still need to make multi-split entries to keep my books in order.

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


Re: [GNC] I'm still a bit confused about when things get saved.

2020-09-11 Thread Fross, Michael
What backup software did you decide to use Chris? I’ve written some scripts
to backup my Gnucash files, but have been looking at a more comprehensive
solution.

Michael

On Fri, Sep 11, 2020 at 3:02 AM Chris Green  wrote:

> On Thu, Sep 10, 2020 at 07:25:33PM -0700, John Ralls wrote:
>
> > Tried that with GnuCash? It isn't a macOS native app and probably
> doesn't
>
> > benefit from those features. I'd go for the UPS, but since recent
> financial
>
> > activity is generally pretty easy to recover and re-enter maybe the
> risk/payback
>
> > works out differently for you.
>
> >
>
> I run incremental backups of all the important data one my system,
>
> in particular I run hourly incremental backups of my 'home' directory
>
> (I use Linux) and this contains just about everything of significance.
>
>
>
> Thus I can never lose more than an hour's work and, if I want to go
>
> back to an earlier situation it's easy.  Since they're incremental
>
> backups if nothing changes then no extra space is consumed (except for
>
> a little overhead).
>
>
>
> Thus, on a separate drive, on my desktop system I have the following
>
> backups:-
>
> day-2  day-4  day-6  hour-1   hour-2  hour-4  hour-6  hour-8 week-1
> week-3  week-5
>
> day-1  day-3  day-5  day-7  hour-10  hour-3  hour-5  hour-7  hour-9
> week-2  week-4
>
>
>
> On a separate system, out in the garage well away from the house, I
>
> have another 'layer' of incremental backups at longer intervals (day,
>
> month, year) going back several years.
>
>
>
> --
>
> Chris Green
>
> ___
>
> gnucash-user mailing list
>
> gnucash-user@gnucash.org
>
> To update your subscription preferences or to unsubscribe:
>
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
>
> -
>
> Please remember to CC this list on all your replies.
>
> You can do this by using Reply-To-List or Reply-All.
>
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: [GNC] I'm still a bit confused about when things get saved.

2020-09-11 Thread Chris Green
On Fri, Sep 11, 2020 at 06:17:14AM -0500, Fross, Michael wrote:
> 
> > I run incremental backups of all the important data one my system,
> > in particular I run hourly incremental backups of my 'home' directory
> > (I use Linux) and this contains just about everything of significance.
> >
[snip details]
> >
> What backup software did you decide to use Chris? I’ve written some scripts
> to backup my Gnucash files, but have been looking at a more comprehensive
> solution.
> 
Both the 'local' hourly backup and the remote (to the garage) daily
one basically use rsync with linux 'hard links' to provide the
incremental backup.  There's a 'prebackup' and a 'postbackup' script
that do the directory manipulation and to weed out some of the backups
as they get older.  The scripts are written in Python but are only a
few tens of lines long.  All d-i-y.

So, for example, the hourly 'local' backup is:-

#!/bin/bash
#
#
# Local snapshots to the /bak disk drive
#
#
#
# Run the pre-backup script
#
/home/chris/.cfg/esprimo/bin/prebak.py
#
#
# Backup files using rsync
#
rsync -a --exclude-from /etc/rsync.doNotCopy \
--link-dest=/bak/snapshot/cur  /etc /home /bak/snapshot/new/
#
#
# Run the post-backup script
#
/home/chris/.cfg/esprimo/bin/postbak.py

If you're interested (or anyone else is) we can go 'off list' to
discuss further, I'm quite happy for others to use my code.

The big advantage of the rsync 'hard-links' is that the backups are
all 'complete' copies of what's backed up, you don't have to unpack
anything or run a program.  You can find what looks exactly like your
home directory (and /etc as you can see) in the backup, except that
it's how it was x hours or y days ago.

It works because a file that doesn't change only exists in one place
and the files you see in each hourly/daily/weekly backup are [hard]
links to the same file, so it only uses space for one copy of the file.

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


Re: [GNC] I'm still a bit confused about when things get saved.

2020-09-11 Thread Frank H. Ellenberger
Hello Chris,

Am 10.09.20 um 15:22 schrieb Chris Green:
> On Thu, Sep 10, 2020 at 08:58:04AM -0400, Derek Atkins wrote:
>> Hi,
>>
>> On Thu, September 10, 2020 8:32 am, Chris Green wrote:
>>> When does data entered get saved?  Also are there different 'levels'
>>> of save as it were?
>> Yes, there are different levels of data storage, per se.  There are:
>>
>> * Data Entry -- the data only lives in the UI
>> * Commit -- the data is stored into the in-memory cache of your data
>> * Save -- the in-memory cache is written to disk
>>
> Excellent, thank you, it seems odd that this isn't made explicit
> anywhere in the documentation (or is it?).  Maybe it's just my
> software engineering rather than accounting background! :-)
> 
> [snip]

Perhaps the question is, what are the right place for storing and
linking that info?

https://code.gnucash.org/docs/C/gnucash-guide/basics-entry1.html?
Parts are already in
https://code.gnucash.org/docs/C/gnucash-guide/basics-files1.html#basics-storage-comparison-table

OTOH as a technical detail it would belong into
https://code.gnucash.org/docs/C/gnucash-help/

Awaiting your Pull Request ;-)

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


Re: [GNC] Import transactions with expenses in a different currency

2020-09-11 Thread andrepd via gnucash-user
Hmm I see. Thanks for the suggestion. However I don't think this solves the
issue. I would still need to go manually through all the accounts, and also
this would introduce a layer of complexity in importing my monthly
statements that I don't really want...



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


[GNC] Is there a Report for All Expenses Paid between Date A & Date B

2020-09-11 Thread Fran_3 via gnucash-user
I'm looking for an easy way list all paid expenses for a defined period.
I poked around under Reports and maybe I missed it.
How can I do this?
Thanks for any help.

___
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] Is there a Report for All Expenses Paid between Date A & Date B

2020-09-11 Thread Adrien Monteleone
Use the Income Statement (Profit & Loss) but only select Expense 
accounts. Set your date range as desired in the General tab. You can 
then click the account links to examine which transactions were 
affecting the report.


If you instead want just a list of individual transactions, run the 
Transaction report with those same options. (choose only expense 
accounts and then set dates accordingly)


The Transaction report also lets you group them, so you can group by 
Payee (description) or by Month for example.



Regards,
Adrien

On 9/11/20 11:45 AM, Fran_3 via gnucash-user wrote:

I'm looking for an easy way list all paid expenses for a defined period.
I poked around under Reports and maybe I missed it.
How can I do this?
Thanks for any help.


___
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] Is there a Report for All Expenses Paid between Date A & Date B

2020-09-11 Thread Michael or Penny Novack

On 9/11/2020 12:45 PM, Fran_3 via gnucash-user wrote:

I'm looking for an easy way list all paid expenses for a defined period.
I poked around under Reports and maybe I missed it.
How can I do this?
Thanks for any help.

If you want a report that shows, for a defined time period, the 
transactions in a set of accounts and the account total, you use the 
"Transaction Report". The options you want in this case are under 
"accounts" and "general". For accounts you select "expense" and then 
"all children" << if you wanted just some expenses, different selection 
criteria >>  In general you can set the begin date and the end date.


Michael D Novack


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


Re: [GNC] Finance quote troubleshooting

2020-09-11 Thread John Ralls
Dear Mr. Vyrides,

Please remember to copy the list on all replies.

Try testing Finance::Quote directly:

set ALPHAVANTAGE_API_KEY=
perl c:\strawberry\cpan\build\Finance-Quote-1.49-0\Examples\currency-lookup.pl 
GBP EUR

If that fails, try 
perl c:\strawberry\cpan\build\Finance-Quote-1.49-0\Examples\stockdump.pl 
alphavantage CSCO
to make sure that you can successfully query alphavantage.

Regards,
John Ralls



> On Sep 9, 2020, at 10:27 PM, Andreas Vyrides  wrote:
> 
> Dear Mr Ralls,
> 
> Thank you for your prompt response
> 
> Yes I have been through both gnc-fq-check which does not produce any errors
> 
> "
> 
> C:\Program Files (x86)\gnucash\bin>perl gnc-fq-check
> ("1.49" "adig" "aex" "aiahk" "alphavantage" "amfiindia" "asegr" "asx" 
> "aufunds" "australia" "bamosz" "bet" "bmonesbittburns" "bourso" "bse" "bsero" 
> "canada" "canadamutual" "citywire" "cominvest" "cse" "deka" "dutch" 
> "dwsfunds" "europe" "fetch_live_currencies" "fidelity" "fidelity_direct" 
> "fidelityfixed" "financecanada" "finanzpartner" "finland" "fool" "france" 
> "ftfunds" "ftportfolios" "ftportfolios_direct" "fundlibrary" "goldmoney" 
> "greece" "hex" "hu" "hufund" "hungary" "hustock" "iexcloud" "indiamutual" 
> "known_currencies" "lerevenu" "maninv" "morningstar" "morningstarau" 
> "morningstarch" "morningstarjp" "mstaruk" "nasdaq" "nyse" "nz" "nzx" 
> "platinum" "romania" "seb_funds" "sixfunds" "sixshares" 
> "stockhousecanada_fund" "tdefunds" "tdwaterhouse" "tiaacref" "tnetuk" 
> "troweprice" "troweprice_direct" "trustnet" "tsp" "tsx" "uk_unit_trusts" 
> "ukfunds" "unionfunds" "usa" "usfedbonds" "vanguard" "vwd" "yahoo_json" 
> "yahoo_yql" "za" "za_unittrusts")
> 
> "
> 
> and echo (yahoo_json "CSCO") | perl gnc-fq-helper which produces the 
> following result:
> 
> "
> 
> C:\Program Files (x86)\gnucash\bin>echo (yahoo_json "CSCO") | perl 
> gnc-fq-helper
> (("CSCO" (symbol . "CSCO") (gnc:time-no-zone . "2020-09-09 12:00:00") (last . 
> #e40.13) (currency . "USD")))
> 
> "
> 
> I forgot to mention in my previous email that I have already tried completely 
> removing and reinstalling both gnucash, and strawberryperl with not avail.
> 
> I hope this was helpful.
> 
> Kind Regards
> 
> DNR
> 
> On 10/09/2020 03:30, John Ralls wrote:
>> 
>>> On Sep 9, 2020, at 6:44 AM, Andreas Vyrides 
>>>  wrote:
>>> 
>>> Dear Sir,
>>> 
>>> I have been having some trouble retrieving currency quotes from Perl using 
>>> Finance::Quote. I am only interested in currency exchange rates (have not 
>>> attempted using anything else). I have been going through all steps of the 
>>> wiki, such as running "Install online price Retrieval", even changing my 
>>> alpha-vantage key by requesting a new one. I have also tried to get quotes 
>>> from outside gnucash by using the terminal with the following result
>>> 
>>> "
>>> 
>>> C:\Program Files (x86)\gnucash\bin>gnucash-cli.exe --quotes get 
>>> file://C:\Users\EoL\Documents\gnuCash\test\test.gnucash
>>> 
>>> Found Finance::Quote version 1.49.
>>> * 14:35:49  WARN  Unable to retrieve quotes for these items:
>>> CURRENCY:USD
>>>   CURRENCY:EUR
>>> Continuing with good quotes.
>>> 
>>> "
>>> 
>>> In my attempts to get a single exchange rate from the terminal I get the 
>>> following results
>>> 
>>> "
>>> 
>>> C:\Program Files (x86)\gnucash\bin>perl gnc-fq-dump currency EUR GBP
>>> 1 EUR =  GBP
>>> 
>>> "
>>> 
>>> I would like to ensure that I have tried using both API keys in the 
>>> appropriate "online quote" in the preferences settings, but every time I 
>>> try to get quotes I get an error with "unable to retrieve quotes for these 
>>> items: Currency: USD, Currency:EUR"
>>> 
>>> I am currently using F::Q v1.49, and gnucash v4.1
>>> 
>>> Thank you for your time and all your support
>>> 
>> Have you read https://wiki.gnucash.org/wiki/Online_Quotes, in particular 
>> https://wiki.gnucash.org/wiki/Online_Quotes#Trouble_Shooting
>> ?
>> 
>> 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] Is there a Report for All Expenses Paid between Date A & Date B

2020-09-11 Thread Fran_3 via gnucash-user
 How can I limit the report to "Paid Expenses" during the period?
Thanks

On Friday, September 11, 2020, 3:43:40 PM EDT, Adrien Monteleone 
 wrote:  
 
 Use the Income Statement (Profit & Loss) but only select Expense 
accounts. Set your date range as desired in the General tab. You can 
then click the account links to examine which transactions were 
affecting the report.

If you instead want just a list of individual transactions, run the 
Transaction report with those same options. (choose only expense 
accounts and then set dates accordingly)

The Transaction report also lets you group them, so you can group by 
Payee (description) or by Month for example.


Regards,
Adrien

On 9/11/20 11:45 AM, Fran_3 via gnucash-user wrote:
> I'm looking for an easy way list all paid expenses for a defined period.
> I poked around under Reports and maybe I missed it.
> How can I do this?
> Thanks for any help.

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

2020-09-11 Thread Andreas Vyrides

Dear Mr Ralls,

It turn out you were able to correctly identify the issue for me since I 
am not able to access the server. I am copying below the results after 
running each command provided. I would be grateful if you could guide me 
to resolve this issue.


"

C:\Program Files (x86)\gnucash\bin>perl 
c:\strawberry\cpan\build\Finance-Quote-1.49-0\Examples\currency-lookup.pl 
GBP EUR

Urgh!  Nothing back

"

and

"

C:\Program Files (x86)\gnucash\bin>perl 
c:\strawberry\cpan\build\Finance-Quote-1.49-0\Examples\stockdump.pl 
alphavantage CSCO

$VAR1 = {
  'CSCO∟errormsg' => 'Internal Server Error',
  'CSCO∟success' => 0
    };

"

I apreciate all your help.

Kind Regards

Andreas Vyrides

On 11/09/2020 22:03, John Ralls wrote:

Dear Mr. Vyrides,

Please remember to copy the list on all replies.

Try testing Finance::Quote directly:

set ALPHAVANTAGE_API_KEY=
perl c:\strawberry\cpan\build\Finance-Quote-1.49-0\Examples\currency-lookup.pl 
GBP EUR

If that fails, try
perl c:\strawberry\cpan\build\Finance-Quote-1.49-0\Examples\stockdump.pl 
alphavantage CSCO
to make sure that you can successfully query alphavantage.

Regards,
John Ralls




On Sep 9, 2020, at 10:27 PM, Andreas Vyrides  wrote:

Dear Mr Ralls,

Thank you for your prompt response

Yes I have been through both gnc-fq-check which does not produce any errors

"

C:\Program Files (x86)\gnucash\bin>perl gnc-fq-check
("1.49" "adig" "aex" "aiahk" "alphavantage" "amfiindia" "asegr" "asx" "aufunds" "australia" "bamosz" "bet" "bmonesbittburns" "bourso" "bse" "bsero" "canada" "canadamutual" "citywire" "cominvest" "cse" "deka" "dutch" "dwsfunds" "europe" "fetch_live_currencies" "fidelity" "fidelity_direct" "fidelityfixed" "financecanada" "finanzpartner" "finland" "fool" "france" "ftfunds" "ftportfolios" "ftportfolios_direct" "fundlibrary" "goldmoney" "greece" "hex" "hu" "hufund" "hungary" 
"hustock" "iexcloud" "indiamutual" "known_currencies" "lerevenu" "maninv" "morningstar" "morningstarau" "morningstarch" "morningstarjp" "mstaruk" "nasdaq" "nyse" "nz" "nzx" "platinum" "romania" "seb_funds" "sixfunds" "sixshares" "stockhousecanada_fund" "tdefunds" "tdwaterhouse" "tiaacref" "tnetuk" "troweprice" "troweprice_direct" "trustnet" "tsp" "tsx" "uk_unit_trusts" "ukfunds" "unionfunds" "usa" "usfedbonds" "vanguard" "vwd" "yahoo_json" "yahoo_yql" "za" "za_unittrusts")

"

and echo (yahoo_json "CSCO") | perl gnc-fq-helper which produces the following 
result:

"

C:\Program Files (x86)\gnucash\bin>echo (yahoo_json "CSCO") | perl gnc-fq-helper
(("CSCO" (symbol . "CSCO") (gnc:time-no-zone . "2020-09-09 12:00:00") (last . #e40.13) 
(currency . "USD")))

"

I forgot to mention in my previous email that I have already tried completely 
removing and reinstalling both gnucash, and strawberryperl with not avail.

I hope this was helpful.

Kind Regards

DNR

On 10/09/2020 03:30, John Ralls wrote:

On Sep 9, 2020, at 6:44 AM, Andreas Vyrides 
  wrote:

Dear Sir,

I have been having some trouble retrieving currency quotes from Perl using 
Finance::Quote. I am only interested in currency exchange rates (have not attempted using 
anything else). I have been going through all steps of the wiki, such as running 
"Install online price Retrieval", even changing my alpha-vantage key by 
requesting a new one. I have also tried to get quotes from outside gnucash by using the 
terminal with the following result

"

C:\Program Files (x86)\gnucash\bin>gnucash-cli.exe --quotes get
file://C:\Users\EoL\Documents\gnuCash\test\test.gnucash

Found Finance::Quote version 1.49.
* 14:35:49  WARN  Unable to retrieve quotes for these items:
CURRENCY:USD
   CURRENCY:EUR
Continuing with good quotes.

"

In my attempts to get a single exchange rate from the terminal I get the 
following results

"

C:\Program Files (x86)\gnucash\bin>perl gnc-fq-dump currency EUR GBP
1 EUR =  GBP

"

I would like to ensure that I have tried using both API keys in the appropriate "online 
quote" in the preferences settings, but every time I try to get quotes I get an error with 
"unable to retrieve quotes for these items: Currency: USD, Currency:EUR"

I am currently using F::Q v1.49, and gnucash v4.1

Thank you for your time and all your support


Have you read https://wiki.gnucash.org/wiki/Online_Quotes, in particular 
https://wiki.gnucash.org/wiki/Online_Quotes#Trouble_Shooting
?

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] Location of gtk css file on MacOS

2020-09-11 Thread w...@theprescotts.com
John,

I'm just getting back to investigating this. I have tried making changes to 
both of those two files and I don't see any change when I open Gnucash. I have 
done a search for gtk-3.0.css. Most of the ones it finds are in the Gnucash 
applications themselves. I have a bunch of old Gnucash apps on my machine. 
Could they be causing problems.

/Users/[user]/Library/Application Support/Gnucash/gtk-3.0.css
/Users/[user]/Library/Application Support/Gnucash/config/gtk-3.0/gtk-3.0.css
/Applications/Gnucash//Gnucash-3.10/Gnucash.app/Contents/Resources/share/doc/gnucash/gtk-3.0.css
/Applications/Gnucash//Gnucash-3.4/Gnucash.app/Contents/Resources/share/doc/gnucash/gtk-3.0.css
/Applications/Gnucash//Gnucash-3.0-1/Gnucash.app/Contents/Resources/share/doc/gnucash/gtk-3.0.css
/Applications/Gnucash//Gnucash-4.1.4/Gnucash.app/Contents/Resources/share/doc/gnucash/gtk-3.0.css
/Applications/Gnucash//Gnucash-4.0/Gnucash.app/Contents/Resources/share/doc/gnucash/gtk-3.0.css
/Applications/Gnucash//Gnucash-4.1/Gnucash.app/Contents/Resources/share/doc/gnucash/gtk-3.0.css

Will


On 2020 Sep 1, at 09-01 22:10:44, John Ralls  wrote:

As long as you haven't messed with anything the two documented locations are:
~/Library/Application Support/Gnucash/gtk-3.0.css
~/Library/Application Support/Gnucash/config/gtk-3.0/gtk.css

The second is because GnuCash.app/Contents/Resources/etc/gnucash/environment 
sets XDG_CONFIG_HOME to $HOME/Library/Application Support/Gnucash/config.

Documentation aside, older versions of Gtk would look in other places for 
backwards compatibility, like ~/.config/gtk-3.0 and ~/.gtk-3.0, and 
~/.themes/Adwaita. You might to a global search for files named gtk.css to make 
sure that there isn't a leftover somewhere overriding the one you want to use.

Regards,
John Ralls


> On Sep 1, 2020, at 7:33 PM, David H  wrote:
> 
> Will,
> 
> The other file ~/Library/Application Support/Gnucash/config/gtk-3.0.css
> that you said also existed only exists as an empty folder on my system ???
> 
> Cheers David H.
> 
> On Wed, 2 Sep 2020 at 11:28, w...@theprescotts.com 
> wrote:
> 
>> David,
>> 
>> Thanks for the response. It is curious. But I have tried that numerous
>> times with no effect.
>> 
>> Will
>> 
>> On 2020 Sep 1, at 09-01 18:50:05, David H  wrote:
>> 
>> Hi Will,
>> 
>> I'm running 4.1 on the latest Big Sur Public Beta - it's picking up the
>> first one (/Users/davidh/Library/Application Support/Gnucash/gtk-3.0.css)
>> which only has the following in it ...
>> 
>> * {
>> font-size: 12px;
>> }
>> 
>> If I change the 12px to 18 px and restart GnuCash I can see the difference
>> right away.
>> 
>> Cheers David H.
>> 
>> 
>> 
>> On Wed, 2 Sep 2020 at 08:58, w...@theprescotts.com > w...@theprescotts.com> > w...@theprescotts.com>> wrote:
>> I am running Gnucash 4.1.4 on MacOS 10.15.6 and I am looking for the
>> location of the gtk.css file that is controlling the display. I have seen
>> discussion of it here and have looked at the wiki but I am still having
>> trouble.
>> 
>> I have files:
>> ~/Library/Application Support/Gnucash/gtk-3.0.css
>> ~/Library/Application Support/Gnucash/config/gtk-3.0.css
>> 
>> However, it doesn't look like Gnucash is reading or paying attention to
>> either. If I run Gnucash in the gtk debugger with:
>> 
>> GTK_DEBUG=interactive
>> /Applications/Gnucash/Gnucash-4.1.4/Gnucash.app/Contents/MacOS/Gnucash
>> 
>> It does appear to read the first one, but not when I run Gnucash normally
>> (i.e. by double clicking on the Gnucash.app or from the command line).
>> 
>> Any suggestions?
>> 
>> Thanks,
>> Will
>> ___
>> gnucash-user mailing list
>> gnucash-user@gnucash.org 
>> To update your subscription preferences or to unsubscribe:
>> https://lists.gnucash.org/mailman/listinfo/gnucash-user <
>> https://lists.gnucash.org/mailman/listinfo/gnucash-user>
>> If you are using Nabble or Gmane, please see
>> https://wiki.gnucash.org/wiki/Mailing_Lists <
>> 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 mo

Re: [GNC] Is there a Report for All Expenses Paid between Date A & Date B

2020-09-11 Thread Michael or Penny Novack

On 9/11/2020 5:16 PM, Fran_3 via gnucash-user wrote:

  How can I limit the report to "Paid Expenses" during the period?
Thanks



WHAT do you mean? The books are not a "budget". They are a record of 
transactions that have actually taken place. If you did not pay some 
expense there should not be a record of its payment in your books.


What ARE you meaning by the "paid" in "paid expenses"?

Michael D Novack

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


Re: [GNC] Location of gtk css file on MacOS

2020-09-11 Thread David H
Will,

As I said 10 days ago, I only have the one in
/Users/[user]/Library/Application Support/Gnucash/gtk-3.0.css and it works.
/Users/[user]/Library/Application Support/Gnucash/config/gtk-3.0/ is just
an empty folder on my mac.  Why don't you try moving all those old apps to
some other storage or deleting them altogether - why keep them around
anyway ?  Or you could rename all the other gtk-3.0.css files to
gtk-3.0.bak temporarily if you really want to keep them around 

Cheers David H.


On Sat, 12 Sep 2020 at 07:52, w...@theprescotts.com 
wrote:

> John,
>
> I'm just getting back to investigating this. I have tried making changes
> to both of those two files and I don't see any change when I open Gnucash.
> I have done a search for gtk-3.0.css. Most of the ones it finds are in the
> Gnucash applications themselves. I have a bunch of old Gnucash apps on my
> machine. Could they be causing problems.
>
> /Users/[user]/Library/Application Support/Gnucash/gtk-3.0.css
> /Users/[user]/Library/Application
> Support/Gnucash/config/gtk-3.0/gtk-3.0.css
>
> /Applications/Gnucash//Gnucash-3.10/Gnucash.app/Contents/Resources/share/doc/gnucash/gtk-3.0.css
>
> /Applications/Gnucash//Gnucash-3.4/Gnucash.app/Contents/Resources/share/doc/gnucash/gtk-3.0.css
>
> /Applications/Gnucash//Gnucash-3.0-1/Gnucash.app/Contents/Resources/share/doc/gnucash/gtk-3.0.css
>
> /Applications/Gnucash//Gnucash-4.1.4/Gnucash.app/Contents/Resources/share/doc/gnucash/gtk-3.0.css
>
> /Applications/Gnucash//Gnucash-4.0/Gnucash.app/Contents/Resources/share/doc/gnucash/gtk-3.0.css
>
> /Applications/Gnucash//Gnucash-4.1/Gnucash.app/Contents/Resources/share/doc/gnucash/gtk-3.0.css
>
> Will
>
>
> On 2020 Sep 1, at 09-01 22:10:44, John Ralls  wrote:
>
> As long as you haven't messed with anything the two documented locations
> are:
> ~/Library/Application Support/Gnucash/gtk-3.0.css
> ~/Library/Application Support/Gnucash/config/gtk-3.0/gtk.css
>
> The second is because
> GnuCash.app/Contents/Resources/etc/gnucash/environment sets XDG_CONFIG_HOME
> to $HOME/Library/Application Support/Gnucash/config.
>
> Documentation aside, older versions of Gtk would look in other places for
> backwards compatibility, like ~/.config/gtk-3.0 and ~/.gtk-3.0, and
> ~/.themes/Adwaita. You might to a global search for files named gtk.css to
> make sure that there isn't a leftover somewhere overriding the one you want
> to use.
>
> Regards,
> John Ralls
>
>
> > On Sep 1, 2020, at 7:33 PM, David H  wrote:
> >
> > Will,
> >
> > The other file ~/Library/Application Support/Gnucash/config/gtk-3.0.css
> > that you said also existed only exists as an empty folder on my system
> ???
> >
> > Cheers David H.
> >
> > On Wed, 2 Sep 2020 at 11:28, w...@theprescotts.com <
> w...@theprescotts.com>
> > wrote:
> >
> >> David,
> >>
> >> Thanks for the response. It is curious. But I have tried that numerous
> >> times with no effect.
> >>
> >> Will
> >>
> >> On 2020 Sep 1, at 09-01 18:50:05, David H  wrote:
> >>
> >> Hi Will,
> >>
> >> I'm running 4.1 on the latest Big Sur Public Beta - it's picking up the
> >> first one (/Users/davidh/Library/Application
> Support/Gnucash/gtk-3.0.css)
> >> which only has the following in it ...
> >>
> >> * {
> >> font-size: 12px;
> >> }
> >>
> >> If I change the 12px to 18 px and restart GnuCash I can see the
> difference
> >> right away.
> >>
> >> Cheers David H.
> >>
> >>
> >>
> >> On Wed, 2 Sep 2020 at 08:58, w...@theprescotts.com  >> w...@theprescotts.com>  >> w...@theprescotts.com>> wrote:
> >> I am running Gnucash 4.1.4 on MacOS 10.15.6 and I am looking for the
> >> location of the gtk.css file that is controlling the display. I have
> seen
> >> discussion of it here and have looked at the wiki but I am still having
> >> trouble.
> >>
> >> I have files:
> >> ~/Library/Application Support/Gnucash/gtk-3.0.css
> >> ~/Library/Application Support/Gnucash/config/gtk-3.0.css
> >>
> >> However, it doesn't look like Gnucash is reading or paying attention to
> >> either. If I run Gnucash in the gtk debugger with:
> >>
> >> GTK_DEBUG=interactive
> >> /Applications/Gnucash/Gnucash-4.1.4/Gnucash.app/Contents/MacOS/Gnucash
> >>
> >> It does appear to read the first one, but not when I run Gnucash
> normally
> >> (i.e. by double clicking on the Gnucash.app or from the command line).
> >>
> >> Any suggestions?
> >>
> >> Thanks,
> >> Will
> >> ___
> >> gnucash-user mailing list
> >> gnucash-user@gnucash.org 
> >> To update your subscription preferences or to unsubscribe:
> >> https://lists.gnucash.org/mailman/listinfo/gnucash-user <
> >> https://lists.gnucash.org/mailman/listinfo/gnucash-user>
> >> If you are using Nabble or Gmane, please see
> >> https://wiki.gnucash.org/wiki/Mailing_Lists <
> >> 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-Al

Re: [GNC] Is there a Report for All Expenses Paid between Date A & Date B

2020-09-11 Thread Adrien Monteleone
Ah, are you using the Business features and you want to only show those 
expenses (from invoices) that are paid?


That's a tougher call.

With accrual accounting, you book expenses when incurred, not 
necessarily when paid. That transaction is separate from the payment.


Paying a vendor may or may not completely cover any particular line item 
expense. The idea with accruals isn't just following the Recognition 
Principle, but also separating the concept of paying expenses 
individually. (you might be so lucky, but likely not)


So you can either track each expense and if it is paid, or you can track 
if you've paid invoices, but not really both, at least not without lots 
of work.


This would be similar to a credit card. You purchase using the card as 
payment. The expense is realized right away though technically you 
didn't pay for them, you used a line of credit. (similar to with vendors)


When you do make payment, you track the balance of the account as a 
whole, not each individual use of the credit line.


It is of course possible to see what invoices have been paid and with 
what payment transactions. Use the Vendor Report. You can run it 
directly and choose a vendor, or Run the Payables Aging report, then 
click the total amount for that Vendor (not their name) and you'll get 
the Vendor report for that vendor. I keep a Payables Aging tab open at 
all times and just click to run their reports as needed. (same for 
Receivables)


You can go to Options and turn on Display Columns > Links > 'Simple' or 
'Detailed' as desired to see the payment transaction links to each 
invoice. (and vice versa)


From there, you can pull up those paid (or unpaid) invoices to see what 
was covered by payments.


That sounds daunting at first, but there is a slight bit of time saving 
that is possible here, though it requires some spreadsheet KungFu:


#1 - you need to not 'accumulate splits' when posting bills. This means 
that each line item on the bill will show up in the AP and associated 
expense registers rather than being consolidated. (so if you had 
multiple line items for 'supplies' each line would show up, rather than 
just one split for supplies)


#2 - Export/Copy-Paste that Transaction Report to a spreadsheet

#3 - Do the same for the Vendor Report in another sheet in the same 
workbook.


#4 - Either on the Transaction Report sheet, or a 3rd sheet, write some 
IF statement formulas (or SUMIF forumals) to show you only expense 
splits that have matching payments for their bills (or do not) as 
desired. Note, the bill numbers should show up next to the date as the 
NUM field. (you might have to make this visible in the Transaction 
Report when you run it)




For any expenses not paid through Bills, you then have to check to see 
if you made credit card payments, or you can check to see if paid by 
Checking or Cash and then include them in the summary data.



Another option is to learn Scheme and design this report from within 
GnuCash, or hire someone to do so. But I'd first play with spreadsheets 
so you see exactly how the data appears and the minimum parts of it you 
need to make the determination.



You can narrow down your expense list by filtering the Accounts used for 
the Transaction Report to only include transactions that also include 
say Checking or Cash, then you know those are paid.


A separate report could show you expenses that also include AP, so you 
know those are Bills.


A third could show you expenses that also include credit card accounts, 
so you know you'd have to handle those accordingly.


Regards,
Adrien

On 9/11/20 4:16 PM, Fran_3 via gnucash-user wrote:

  How can I limit the report to "Paid Expenses" during the period?
Thanks

 On Friday, September 11, 2020, 3:43:40 PM EDT, Adrien Monteleone 
 wrote:
  
  Use the Income Statement (Profit & Loss) but only select Expense

accounts. Set your date range as desired in the General tab. You can
then click the account links to examine which transactions were
affecting the report.

If you instead want just a list of individual transactions, run the
Transaction report with those same options. (choose only expense
accounts and then set dates accordingly)

The Transaction report also lets you group them, so you can group by
Payee (description) or by Month for example.


___
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] Location of gtk css file on MacOS

2020-09-11 Thread Adrien Monteleone
If you think you *really* need to keep an older version, I'd install 
that to your own ~/Applications directory, then delete the rest save for 
the most recent 4.1. Otherwise, just grab another copy of that version's 
dmg and save it somewhere just in case. It is trivial to re-install if 
needed. That way, you eliminate all chance of overrides.


The rest shouldn't technically interfere because they shouldn't be 
looking in each other's application bundles, but are you certain you are 
always opening 4.1? How do you tell them apart?


Do you have anything regarding GnuCash or GTK in ~/.config? If so, I'd 
move that out of there for later triaging, or if you know you don't need 
it, delete.


Regards,
Adrien

On 9/11/20 4:50 PM, w...@theprescotts.com wrote:

John,

I'm just getting back to investigating this. I have tried making changes to 
both of those two files and I don't see any change when I open Gnucash. I have 
done a search for gtk-3.0.css. Most of the ones it finds are in the Gnucash 
applications themselves. I have a bunch of old Gnucash apps on my machine. 
Could they be causing problems.

/Users/[user]/Library/Application Support/Gnucash/gtk-3.0.css
/Users/[user]/Library/Application Support/Gnucash/config/gtk-3.0/gtk-3.0.css
/Applications/Gnucash//Gnucash-3.10/Gnucash.app/Contents/Resources/share/doc/gnucash/gtk-3.0.css
/Applications/Gnucash//Gnucash-3.4/Gnucash.app/Contents/Resources/share/doc/gnucash/gtk-3.0.css
/Applications/Gnucash//Gnucash-3.0-1/Gnucash.app/Contents/Resources/share/doc/gnucash/gtk-3.0.css
/Applications/Gnucash//Gnucash-4.1.4/Gnucash.app/Contents/Resources/share/doc/gnucash/gtk-3.0.css
/Applications/Gnucash//Gnucash-4.0/Gnucash.app/Contents/Resources/share/doc/gnucash/gtk-3.0.css
/Applications/Gnucash//Gnucash-4.1/Gnucash.app/Contents/Resources/share/doc/gnucash/gtk-3.0.css

Will


On 2020 Sep 1, at 09-01 22:10:44, John Ralls  wrote:

As long as you haven't messed with anything the two documented locations are:
~/Library/Application Support/Gnucash/gtk-3.0.css
~/Library/Application Support/Gnucash/config/gtk-3.0/gtk.css

The second is because GnuCash.app/Contents/Resources/etc/gnucash/environment 
sets XDG_CONFIG_HOME to $HOME/Library/Application Support/Gnucash/config.

Documentation aside, older versions of Gtk would look in other places for 
backwards compatibility, like ~/.config/gtk-3.0 and ~/.gtk-3.0, and 
~/.themes/Adwaita. You might to a global search for files named gtk.css to make 
sure that there isn't a leftover somewhere overriding the one you want to use.

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] Is there a Report for All Expenses Paid between Date A & Date B

2020-09-11 Thread Fran_3 via gnucash-user
 Michael, maybe I got my words mixed up. 
What we want is a report that shows paid expenses for a defined period. 
Thanks


On Friday, September 11, 2020, 6:02:48 PM EDT, Michael or Penny Novack 
 wrote:  
 
 On 9/11/2020 5:16 PM, Fran_3 via gnucash-user wrote:
>  How can I limit the report to "Paid Expenses" during the period?
> Thanks


WHAT do you mean? The books are not a "budget". They are a record of 
transactions that have actually taken place. If you did not pay some 
expense there should not be a record of its payment in your books.

What ARE you meaning by the "paid" in "paid expenses"?

Michael D Novack

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


Re: [GNC] Is there a Report for All Expenses Paid between Date A & Date B

2020-09-11 Thread Fran_3 via gnucash-user
 Thanks Adrian. You zeroed in on the issue. 
This particular entity is reporting on a cash basis... not accrual.And, sadly, 
in this case using Invoices that were posted and paid to vendors won't get the 
entire picture as some incidental purchases/expenses were paid without posting 
an invoice from the vendor...But, in both cases... they do show up in expenses. 
So, I guess we are stuck with a lot of work to figure this out.I will read your 
last reply more carefully this weekend and see if I discover any hint's to make 
it easier.Thanks again for the help.



On Friday, September 11, 2020, 6:11:54 PM EDT, Adrien Monteleone 
 wrote:  
 
 Ah, are you using the Business features and you want to only show those 
expenses (from invoices) that are paid?

That's a tougher call.

With accrual accounting, you book expenses when incurred, not 
necessarily when paid. That transaction is separate from the payment.

Paying a vendor may or may not completely cover any particular line item 
expense. The idea with accruals isn't just following the Recognition 
Principle, but also separating the concept of paying expenses 
individually. (you might be so lucky, but likely not)

So you can either track each expense and if it is paid, or you can track 
if you've paid invoices, but not really both, at least not without lots 
of work.

This would be similar to a credit card. You purchase using the card as 
payment. The expense is realized right away though technically you 
didn't pay for them, you used a line of credit. (similar to with vendors)

When you do make payment, you track the balance of the account as a 
whole, not each individual use of the credit line.

It is of course possible to see what invoices have been paid and with 
what payment transactions. Use the Vendor Report. You can run it 
directly and choose a vendor, or Run the Payables Aging report, then 
click the total amount for that Vendor (not their name) and you'll get 
the Vendor report for that vendor. I keep a Payables Aging tab open at 
all times and just click to run their reports as needed. (same for 
Receivables)

You can go to Options and turn on Display Columns > Links > 'Simple' or 
'Detailed' as desired to see the payment transaction links to each 
invoice. (and vice versa)

 From there, you can pull up those paid (or unpaid) invoices to see what 
was covered by payments.

That sounds daunting at first, but there is a slight bit of time saving 
that is possible here, though it requires some spreadsheet KungFu:

#1 - you need to not 'accumulate splits' when posting bills. This means 
that each line item on the bill will show up in the AP and associated 
expense registers rather than being consolidated. (so if you had 
multiple line items for 'supplies' each line would show up, rather than 
just one split for supplies)

#2 - Export/Copy-Paste that Transaction Report to a spreadsheet

#3 - Do the same for the Vendor Report in another sheet in the same 
workbook.

#4 - Either on the Transaction Report sheet, or a 3rd sheet, write some 
IF statement formulas (or SUMIF forumals) to show you only expense 
splits that have matching payments for their bills (or do not) as 
desired. Note, the bill numbers should show up next to the date as the 
NUM field. (you might have to make this visible in the Transaction 
Report when you run it)



For any expenses not paid through Bills, you then have to check to see 
if you made credit card payments, or you can check to see if paid by 
Checking or Cash and then include them in the summary data.


Another option is to learn Scheme and design this report from within 
GnuCash, or hire someone to do so. But I'd first play with spreadsheets 
so you see exactly how the data appears and the minimum parts of it you 
need to make the determination.


You can narrow down your expense list by filtering the Accounts used for 
the Transaction Report to only include transactions that also include 
say Checking or Cash, then you know those are paid.

A separate report could show you expenses that also include AP, so you 
know those are Bills.

A third could show you expenses that also include credit card accounts, 
so you know you'd have to handle those accordingly.

Regards,
Adrien

On 9/11/20 4:16 PM, Fran_3 via gnucash-user wrote:
>  How can I limit the report to "Paid Expenses" during the period?
> Thanks
> 
>      On Friday, September 11, 2020, 3:43:40 PM EDT, Adrien Monteleone 
> wrote:
>  
>  Use the Income Statement (Profit & Loss) but only select Expense
> accounts. Set your date range as desired in the General tab. You can
> then click the account links to examine which transactions were
> affecting the report.
> 
> If you instead want just a list of individual transactions, run the
> Transaction report with those same options. (choose only expense
> accounts and then set dates accordingly)
> 
> The Transaction report also lets you group them, so you can group by
> Payee (description) or by Month for exa

Re: [GNC] Is there a Report for All Expenses Paid between Date A & Date B

2020-09-11 Thread Adrien Monteleone
The Business features were designed for accrual accounting, but you can 
use them on a cash basis if you don't post until you make payment.


In that case, anything in your expense accounts would be paid. They 
won't show up otherwise.


If you have bills posted that are not yet paid, you should unpost them 
because posting realizes the expenses as of the posting date rather than 
the payment date - thus violating the cash basis rule.


Once that is cleared up, a simple transaction report will do the trick, 
or if you want it by account, then do a P&L with only the expense 
accounts selected.


Note, even without unposting the bills at all, a Transaction Report set 
to include only accounts that both match an Expenses *and* Checking/Cash 
will show you those transactions that are paid. Then you'd just have to 
do the same for those that match Expenses and AP to see what might be 
left to find or filter out.


To get this filtered report:

1. Go to Options > Accounts
2. Select the Expense parent account
3. Click the Select Children button
4. Set Filter > 'Include Transactions to/from Filter Accounts'
5. Select just the 'Checking' and 'Cash' accounts (and any other 
relevant ones where payment is made on the spot - but not AP or Credit 
Card accounts, unless you want to consider Credit Card use as 'paid' 
expenses)

6. Go to General and set your date range.

Regards,
Adrien

On 9/11/20 6:04 PM, Fran_3 via gnucash-user wrote:

  Thanks Adrian. You zeroed in on the issue.
This particular entity is reporting on a cash basis... not accrual.And, sadly, 
in this case using Invoices that were posted and paid to vendors won't get the 
entire picture as some incidental purchases/expenses were paid without posting 
an invoice from the vendor...But, in both cases... they do show up in expenses.
So, I guess we are stuck with a lot of work to figure this out.I will read your 
last reply more carefully this weekend and see if I discover any hint's to make 
it easier.Thanks again for the help.


___
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] Is there a Report for All Expenses Paid between Date A & Date B

2020-09-11 Thread Adrien Monteleone
I'll add that if you are posting bills in order to utilize the Due 
Reminder feature (and track your account with a Vendor), you can still 
do this on a cash-basis with a work around.


Let's take the example of vendor that has you on Net30 terms.

You receive a bill dated today, 9/11/20, due on 9/21/20 and you 
reasonably expect to make payment in 30 days by 10/21/20, in full.


Enter the bill as normal.

Post the bill with the 10/21/20 date, which is your expected date of 
payment, and 30 days from the due date. But put the Date Due as the 
correct 9/21/20.


It will now show up in the Due Reminder and in the Payables Aging report 
correctly.


When you make actual payment, if not on 10/21/20, unpost and repost with 
that days date, prior to entering the payment in GnuCash, otherwise just 
process the payment. (If you don't pay in full, you'll have more 
gymnastics to do.)


The expense accounts will still get posted to, but with a future date 
(10/21/20) to match the expected payment date. (which will eventually be 
the actual payment date when it happens)


Those transactions in AP and in the various Expense accounts will show 
up underneath a blue line, indicating they are in the future. (their 
dates will reflect this too, but the blue line makes it easy to spot)


Note, there is a preference for 'Blank Transaction before Future 
Transactions' so you can make new entries 'today' without having to 
scroll past the future dated transactions.


Now, a simple Transaction Report for a date range ending in 'Today' will 
show you all expenses (or whatever else) that are 'paid'.


You can now also run a report to show future expenses if desired.

Regards,
Adrien

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


Re: [GNC] Finance quote troubleshooting

2020-09-11 Thread Geoff

Dear Andreas

Did you set your Alphavantage key as an environment variable before you 
ran this test script?  Try entering these commands first:


set ALPHAVANTAGE_API_KEY=__Your_Actual_Key__
echo %ALPHAVANTAGE_API_KEY%

See attached screenshot.

See also this long thread on resolving a perl related currency problem 
on Windows:


http://gnucash.1415818.n4.nabble.com/GNC-Difficulty-with-online-price-retrieval-John-Ralls-tc4720222.html

Regards

Geoff
=


On 12/09/2020 7:34 am, Andreas Vyrides wrote:

Dear Mr Ralls,

It turn out you were able to correctly identify the issue for me since I 
am not able to access the server. I am copying below the results after 
running each command provided. I would be grateful if you could guide me 
to resolve this issue.


"

C:\Program Files (x86)\gnucash\bin>perl 
c:\strawberry\cpan\build\Finance-Quote-1.49-0\Examples\currency-lookup.pl GBP 
EUR

Urgh!  Nothing back

"

and

"

C:\Program Files (x86)\gnucash\bin>perl 
c:\strawberry\cpan\build\Finance-Quote-1.49-0\Examples\stockdump.pl 
alphavantage CSCO

$VAR1 = {
   'CSCO∟errormsg' => 'Internal Server Error',
   'CSCO∟success' => 0
     };

"

I apreciate all your help.

Kind Regards

Andreas Vyrides

On 11/09/2020 22:03, John Ralls wrote:

Dear Mr. Vyrides,

Please remember to copy the list on all replies.

Try testing Finance::Quote directly:

set ALPHAVANTAGE_API_KEY=
perl 
c:\strawberry\cpan\build\Finance-Quote-1.49-0\Examples\currency-lookup.pl 
GBP EUR


If that fails, try
perl 
c:\strawberry\cpan\build\Finance-Quote-1.49-0\Examples\stockdump.pl 
alphavantage CSCO

to make sure that you can successfully query alphavantage.

Regards,
John Ralls




On Sep 9, 2020, at 10:27 PM, Andreas Vyrides  wrote:

Dear Mr Ralls,

Thank you for your prompt response

Yes I have been through both gnc-fq-check which does not produce any 
errors


"

C:\Program Files (x86)\gnucash\bin>perl gnc-fq-check
("1.49" "adig" "aex" "aiahk" "alphavantage" "amfiindia" "asegr" "asx" 
"aufunds" "australia" "bamosz" "bet" "bmonesbittburns" "bourso" "bse" 
"bsero" "canada" "canadamutual" "citywire" "cominvest" "cse" "deka" 
"dutch" "dwsfunds" "europe" "fetch_live_currencies" "fidelity" 
"fidelity_direct" "fidelityfixed" "financecanada" "finanzpartner" 
"finland" "fool" "france" "ftfunds" "ftportfolios" 
"ftportfolios_direct" "fundlibrary" "goldmoney" "greece" "hex" "hu" 
"hufund" "hungary" "hustock" "iexcloud" "indiamutual" 
"known_currencies" "lerevenu" "maninv" "morningstar" "morningstarau" 
"morningstarch" "morningstarjp" "mstaruk" "nasdaq" "nyse" "nz" "nzx" 
"platinum" "romania" "seb_funds" "sixfunds" "sixshares" 
"stockhousecanada_fund" "tdefunds" "tdwaterhouse" "tiaacref" "tnetuk" 
"troweprice" "troweprice_direct" "trustnet" "tsp" "tsx" 
"uk_unit_trusts" "ukfunds" "unionfunds" "usa" "usfedbonds" "vanguard" 
"vwd" "yahoo_json" "yahoo_yql" "za" "za_unittrusts")


"

and echo (yahoo_json "CSCO") | perl gnc-fq-helper which produces the 
following result:


"

C:\Program Files (x86)\gnucash\bin>echo (yahoo_json "CSCO") | perl 
gnc-fq-helper
(("CSCO" (symbol . "CSCO") (gnc:time-no-zone . "2020-09-09 12:00:00") 
(last . #e40.13) (currency . "USD")))


"

I forgot to mention in my previous email that I have already tried 
completely removing and reinstalling both gnucash, and strawberryperl 
with not avail.


I hope this was helpful.

Kind Regards

DNR

On 10/09/2020 03:30, John Ralls wrote:

On Sep 9, 2020, at 6:44 AM, Andreas Vyrides 
  wrote:

Dear Sir,

I have been having some trouble retrieving currency quotes from 
Perl using Finance::Quote. I am only interested in currency 
exchange rates (have not attempted using anything else). I have 
been going through all steps of the wiki, such as running "Install 
online price Retrieval", even changing my alpha-vantage key by 
requesting a new one. I have also tried to get quotes from outside 
gnucash by using the terminal with the following result


"

C:\Program Files (x86)\gnucash\bin>gnucash-cli.exe --quotes get
file://C:\Users\EoL\Documents\gnuCash\test\test.gnucash

Found Finance::Quote version 1.49.
* 14:35:49  WARN  Unable to retrieve quotes for these items:
CURRENCY:USD
   CURRENCY:EUR
Continuing with good quotes.

"

In my attempts to get a single exchange rate from the terminal I 
get the following results


"

C:\Program Files (x86)\gnucash\bin>perl gnc-fq-dump currency EUR GBP
1 EUR =  GBP

"

I would like to ensure that I have tried using both API keys in the 
appropriate "online quote" in the preferences settings, but every 
time I try to get quotes I get an error with "unable to retrieve 
quotes for these items: Currency: USD, Currency:EUR"


I am currently using F::Q v1.49, and gnucash v4.1

Thank you for your time and all your support

Have you read https://wiki.gnucash.org/wiki/Online_Quotes, in 
particular https://wiki.gnucash.org/wiki/Online_Quotes#Trouble_Shooting

?

Regards,
John Ralls



___
gnucash-user maili

Re: [GNC] Location of gtk css file on MacOS

2020-09-11 Thread John Ralls
Will,

No, macOS since 10.11 won't let a program from one app bundle look at anything 
in another one. That's why the old Update Finance Quote applet stopped working.

Regards,
John Ralls

> On Sep 11, 2020, at 2:50 PM, w...@theprescotts.com wrote:
> 
> John,
> 
> I'm just getting back to investigating this. I have tried making changes to 
> both of those two files and I don't see any change when I open Gnucash. I 
> have done a search for gtk-3.0.css. Most of the ones it finds are in the 
> Gnucash applications themselves. I have a bunch of old Gnucash apps on my 
> machine. Could they be causing problems.
> 
> /Users/[user]/Library/Application Support/Gnucash/gtk-3.0.css
> /Users/[user]/Library/Application Support/Gnucash/config/gtk-3.0/gtk-3.0.css
> /Applications/Gnucash//Gnucash-3.10/Gnucash.app/Contents/Resources/share/doc/gnucash/gtk-3.0.css
> /Applications/Gnucash//Gnucash-3.4/Gnucash.app/Contents/Resources/share/doc/gnucash/gtk-3.0.css
> /Applications/Gnucash//Gnucash-3.0-1/Gnucash.app/Contents/Resources/share/doc/gnucash/gtk-3.0.css
> /Applications/Gnucash//Gnucash-4.1.4/Gnucash.app/Contents/Resources/share/doc/gnucash/gtk-3.0.css
> /Applications/Gnucash//Gnucash-4.0/Gnucash.app/Contents/Resources/share/doc/gnucash/gtk-3.0.css
> /Applications/Gnucash//Gnucash-4.1/Gnucash.app/Contents/Resources/share/doc/gnucash/gtk-3.0.css
> 
> Will
> 
> 
> On 2020 Sep 1, at 09-01 22:10:44, John Ralls  wrote:
> 
> As long as you haven't messed with anything the two documented locations are:
> ~/Library/Application Support/Gnucash/gtk-3.0.css
> ~/Library/Application Support/Gnucash/config/gtk-3.0/gtk.css
> 
> The second is because GnuCash.app/Contents/Resources/etc/gnucash/environment 
> sets XDG_CONFIG_HOME to $HOME/Library/Application Support/Gnucash/config.
> 
> Documentation aside, older versions of Gtk would look in other places for 
> backwards compatibility, like ~/.config/gtk-3.0 and ~/.gtk-3.0, and 
> ~/.themes/Adwaita. You might to a global search for files named gtk.css to 
> make sure that there isn't a leftover somewhere overriding the one you want 
> to use.
> 
> Regards,
> John Ralls
> 
> 
>> On Sep 1, 2020, at 7:33 PM, David H  wrote:
>> 
>> Will,
>> 
>> The other file ~/Library/Application Support/Gnucash/config/gtk-3.0.css
>> that you said also existed only exists as an empty folder on my system ???
>> 
>> Cheers David H.
>> 
>> On Wed, 2 Sep 2020 at 11:28, w...@theprescotts.com 
>> wrote:
>> 
>>> David,
>>> 
>>> Thanks for the response. It is curious. But I have tried that numerous
>>> times with no effect.
>>> 
>>> Will
>>> 
>>> On 2020 Sep 1, at 09-01 18:50:05, David H  wrote:
>>> 
>>> Hi Will,
>>> 
>>> I'm running 4.1 on the latest Big Sur Public Beta - it's picking up the
>>> first one (/Users/davidh/Library/Application Support/Gnucash/gtk-3.0.css)
>>> which only has the following in it ...
>>> 
>>> * {
>>> font-size: 12px;
>>> }
>>> 
>>> If I change the 12px to 18 px and restart GnuCash I can see the difference
>>> right away.
>>> 
>>> Cheers David H.
>>> 
>>> 
>>> 
>>> On Wed, 2 Sep 2020 at 08:58, w...@theprescotts.com >> w...@theprescotts.com> >> w...@theprescotts.com>> wrote:
>>> I am running Gnucash 4.1.4 on MacOS 10.15.6 and I am looking for the
>>> location of the gtk.css file that is controlling the display. I have seen
>>> discussion of it here and have looked at the wiki but I am still having
>>> trouble.
>>> 
>>> I have files:
>>> ~/Library/Application Support/Gnucash/gtk-3.0.css
>>> ~/Library/Application Support/Gnucash/config/gtk-3.0.css
>>> 
>>> However, it doesn't look like Gnucash is reading or paying attention to
>>> either. If I run Gnucash in the gtk debugger with:
>>> 
>>> GTK_DEBUG=interactive
>>> /Applications/Gnucash/Gnucash-4.1.4/Gnucash.app/Contents/MacOS/Gnucash
>>> 
>>> It does appear to read the first one, but not when I run Gnucash normally
>>> (i.e. by double clicking on the Gnucash.app or from the command line).
>>> 
>>> Any suggestions?
>>> 
>>> Thanks,
>>> Will
>>> ___
>>> gnucash-user mailing list
>>> gnucash-user@gnucash.org 
>>> To update your subscription preferences or to unsubscribe:
>>> https://lists.gnucash.org/mailman/listinfo/gnucash-user <
>>> https://lists.gnucash.org/mailman/listinfo/gnucash-user>
>>> If you are using Nabble or Gmane, please see
>>> https://wiki.gnucash.org/wiki/Mailing_Lists <
>>> 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

Re: [GNC] Location of gtk css file on MacOS

2020-09-11 Thread John Ralls
Will,

Assuming that $HOME/.gtk-3.0.css, $HOME/.gtk-3.0/gtk.css, and 
$HOME/.config/gtk-3.0/gtk.css don't exist and that you haven't overridden the 
definition of XDG_CONFIG_DIRS in 
Gnucash.app/Contents/Resources/etc/gnucash/environment I think that the only 
files that Gtk would look at are $HOME/Library/Application 
Support/Gnucash/gtk-3.0.css and $HOME/Library/Application 
Support/Gnucash/config/gtk-3.0/gtk.css

Note that your attempt to use that last path isn't right because you named the 
file gtk-3.0.css.

Regards,
John Ralls


> On Sep 11, 2020, at 7:29 PM, John Ralls  wrote:
> 
> Will,
> 
> No, macOS since 10.11 won't let a program from one app bundle look at 
> anything in another one. That's why the old Update Finance Quote applet 
> stopped working.
> 
> Regards,
> John Ralls
> 
>> On Sep 11, 2020, at 2:50 PM, w...@theprescotts.com wrote:
>> 
>> John,
>> 
>> I'm just getting back to investigating this. I have tried making changes to 
>> both of those two files and I don't see any change when I open Gnucash. I 
>> have done a search for gtk-3.0.css. Most of the ones it finds are in the 
>> Gnucash applications themselves. I have a bunch of old Gnucash apps on my 
>> machine. Could they be causing problems.
>> 
>> /Users/[user]/Library/Application Support/Gnucash/gtk-3.0.css
>> /Users/[user]/Library/Application Support/Gnucash/config/gtk-3.0/gtk-3.0.css
>> /Applications/Gnucash//Gnucash-3.10/Gnucash.app/Contents/Resources/share/doc/gnucash/gtk-3.0.css
>> /Applications/Gnucash//Gnucash-3.4/Gnucash.app/Contents/Resources/share/doc/gnucash/gtk-3.0.css
>> /Applications/Gnucash//Gnucash-3.0-1/Gnucash.app/Contents/Resources/share/doc/gnucash/gtk-3.0.css
>> /Applications/Gnucash//Gnucash-4.1.4/Gnucash.app/Contents/Resources/share/doc/gnucash/gtk-3.0.css
>> /Applications/Gnucash//Gnucash-4.0/Gnucash.app/Contents/Resources/share/doc/gnucash/gtk-3.0.css
>> /Applications/Gnucash//Gnucash-4.1/Gnucash.app/Contents/Resources/share/doc/gnucash/gtk-3.0.css
>> 
>> Will
>> 
>> 
>> On 2020 Sep 1, at 09-01 22:10:44, John Ralls  wrote:
>> 
>> As long as you haven't messed with anything the two documented locations are:
>> ~/Library/Application Support/Gnucash/gtk-3.0.css
>> ~/Library/Application Support/Gnucash/config/gtk-3.0/gtk.css
>> 
>> The second is because GnuCash.app/Contents/Resources/etc/gnucash/environment 
>> sets XDG_CONFIG_HOME to $HOME/Library/Application Support/Gnucash/config.
>> 
>> Documentation aside, older versions of Gtk would look in other places for 
>> backwards compatibility, like ~/.config/gtk-3.0 and ~/.gtk-3.0, and 
>> ~/.themes/Adwaita. You might to a global search for files named gtk.css to 
>> make sure that there isn't a leftover somewhere overriding the one you want 
>> to use.
>> 
>> Regards,
>> John Ralls
>> 
>> 
>>> On Sep 1, 2020, at 7:33 PM, David H  wrote:
>>> 
>>> Will,
>>> 
>>> The other file ~/Library/Application Support/Gnucash/config/gtk-3.0.css
>>> that you said also existed only exists as an empty folder on my system ???
>>> 
>>> Cheers David H.
>>> 
>>> On Wed, 2 Sep 2020 at 11:28, w...@theprescotts.com 
>>> wrote:
>>> 
 David,
 
 Thanks for the response. It is curious. But I have tried that numerous
 times with no effect.
 
 Will
 
 On 2020 Sep 1, at 09-01 18:50:05, David H  wrote:
 
 Hi Will,
 
 I'm running 4.1 on the latest Big Sur Public Beta - it's picking up the
 first one (/Users/davidh/Library/Application Support/Gnucash/gtk-3.0.css)
 which only has the following in it ...
 
 * {
 font-size: 12px;
 }
 
 If I change the 12px to 18 px and restart GnuCash I can see the difference
 right away.
 
 Cheers David H.
 
 
 
 On Wed, 2 Sep 2020 at 08:58, w...@theprescotts.com >>> w...@theprescotts.com> >>> w...@theprescotts.com>> wrote:
 I am running Gnucash 4.1.4 on MacOS 10.15.6 and I am looking for the
 location of the gtk.css file that is controlling the display. I have seen
 discussion of it here and have looked at the wiki but I am still having
 trouble.
 
 I have files:
 ~/Library/Application Support/Gnucash/gtk-3.0.css
 ~/Library/Application Support/Gnucash/config/gtk-3.0.css
 
 However, it doesn't look like Gnucash is reading or paying attention to
 either. If I run Gnucash in the gtk debugger with:
 
 GTK_DEBUG=interactive
 /Applications/Gnucash/Gnucash-4.1.4/Gnucash.app/Contents/MacOS/Gnucash
 
 It does appear to read the first one, but not when I run Gnucash normally
 (i.e. by double clicking on the Gnucash.app or from the command line).
 
 Any suggestions?
 
 Thanks,
 Will
 ___
 gnucash-user mailing list
 gnucash-user@gnucash.org 
 To update your subscription preferences or to unsubscribe:
 https://lists.gnucash.org/mailman/listinfo/gnucash-user <
 https://lists.gnucash

Re: [GNC] Location of gtk css file on MacOS

2020-09-11 Thread w...@theprescotts.com
All (John, Adrien and David),

John wins the lottery on this question with his sharp eye, noticing that 

> /Users/[user]/Library/Application Support/Gnucash/config/gtk-3.0/gtk-3.0.css

should be named 

/Users/[user]/Library/Application Support/Gnucash/config/gtk-3.0/gtk.css

Changes to this file, now that it is correctly named, show up in Gnucash. Thank 
you to all of you who spent time thinking about this.

Will


On 2020 Sep 11, at 09-11 21:38:37, John Ralls  wrote:

Will,

Assuming that $HOME/.gtk-3.0.css, $HOME/.gtk-3.0/gtk.css, and 
$HOME/.config/gtk-3.0/gtk.css don't exist and that you haven't overridden the 
definition of XDG_CONFIG_DIRS in 
Gnucash.app/Contents/Resources/etc/gnucash/environment I think that the only 
files that Gtk would look at are $HOME/Library/Application 
Support/Gnucash/gtk-3.0.css and $HOME/Library/Application 
Support/Gnucash/config/gtk-3.0/gtk.css

Note that your attempt to use that last path isn't right because you named the 
file gtk-3.0.css.

Regards,
John Ralls


> On Sep 11, 2020, at 7:29 PM, John Ralls  wrote:
> 
> Will,
> 
> No, macOS since 10.11 won't let a program from one app bundle look at 
> anything in another one. That's why the old Update Finance Quote applet 
> stopped working.
> 
> Regards,
> John Ralls
> 
>> On Sep 11, 2020, at 2:50 PM, w...@theprescotts.com wrote:
>> 
>> John,
>> 
>> I'm just getting back to investigating this. I have tried making changes to 
>> both of those two files and I don't see any change when I open Gnucash. I 
>> have done a search for gtk-3.0.css. Most of the ones it finds are in the 
>> Gnucash applications themselves. I have a bunch of old Gnucash apps on my 
>> machine. Could they be causing problems.
>> 
>> /Users/[user]/Library/Application Support/Gnucash/gtk-3.0.css
>> /Users/[user]/Library/Application Support/Gnucash/config/gtk-3.0/gtk-3.0.css
>> /Applications/Gnucash//Gnucash-3.10/Gnucash.app/Contents/Resources/share/doc/gnucash/gtk-3.0.css
>> /Applications/Gnucash//Gnucash-3.4/Gnucash.app/Contents/Resources/share/doc/gnucash/gtk-3.0.css
>> /Applications/Gnucash//Gnucash-3.0-1/Gnucash.app/Contents/Resources/share/doc/gnucash/gtk-3.0.css
>> /Applications/Gnucash//Gnucash-4.1.4/Gnucash.app/Contents/Resources/share/doc/gnucash/gtk-3.0.css
>> /Applications/Gnucash//Gnucash-4.0/Gnucash.app/Contents/Resources/share/doc/gnucash/gtk-3.0.css
>> /Applications/Gnucash//Gnucash-4.1/Gnucash.app/Contents/Resources/share/doc/gnucash/gtk-3.0.css
>> 
>> Will
>> 
>> 
>> On 2020 Sep 1, at 09-01 22:10:44, John Ralls  wrote:
>> 
>> As long as you haven't messed with anything the two documented locations are:
>> ~/Library/Application Support/Gnucash/gtk-3.0.css
>> ~/Library/Application Support/Gnucash/config/gtk-3.0/gtk.css
>> 
>> The second is because GnuCash.app/Contents/Resources/etc/gnucash/environment 
>> sets XDG_CONFIG_HOME to $HOME/Library/Application Support/Gnucash/config.
>> 
>> Documentation aside, older versions of Gtk would look in other places for 
>> backwards compatibility, like ~/.config/gtk-3.0 and ~/.gtk-3.0, and 
>> ~/.themes/Adwaita. You might to a global search for files named gtk.css to 
>> make sure that there isn't a leftover somewhere overriding the one you want 
>> to use.
>> 
>> Regards,
>> John Ralls
>> 
>> 
>>> On Sep 1, 2020, at 7:33 PM, David H  wrote:
>>> 
>>> Will,
>>> 
>>> The other file ~/Library/Application Support/Gnucash/config/gtk-3.0.css
>>> that you said also existed only exists as an empty folder on my system ???
>>> 
>>> Cheers David H.
>>> 
>>> On Wed, 2 Sep 2020 at 11:28, w...@theprescotts.com 
>>> wrote:
>>> 
 David,
 
 Thanks for the response. It is curious. But I have tried that numerous
 times with no effect.
 
 Will
 
 On 2020 Sep 1, at 09-01 18:50:05, David H  wrote:
 
 Hi Will,
 
 I'm running 4.1 on the latest Big Sur Public Beta - it's picking up the
 first one (/Users/davidh/Library/Application Support/Gnucash/gtk-3.0.css)
 which only has the following in it ...
 
 * {
 font-size: 12px;
 }
 
 If I change the 12px to 18 px and restart GnuCash I can see the difference
 right away.
 
 Cheers David H.
 
 
 
 On Wed, 2 Sep 2020 at 08:58, w...@theprescotts.com >>> w...@theprescotts.com> >>> w...@theprescotts.com>> wrote:
 I am running Gnucash 4.1.4 on MacOS 10.15.6 and I am looking for the
 location of the gtk.css file that is controlling the display. I have seen
 discussion of it here and have looked at the wiki but I am still having
 trouble.
 
 I have files:
 ~/Library/Application Support/Gnucash/gtk-3.0.css
 ~/Library/Application Support/Gnucash/config/gtk-3.0.css
 
 However, it doesn't look like Gnucash is reading or paying attention to
 either. If I run Gnucash in the gtk debugger with:
 
 GTK_DEBUG=interactive
 /Applications/Gnucash/Gnucash-4.1.4/Gnucash.app/Contents/MacOS/Gnucash
 
 It does appear to read the first

Re: [GNC] Negative numbers

2020-09-11 Thread ToddAndMargo via gnucash-user

On 2020-09-10 21:42, ToddAndMargo via gnucash-user wrote:



On 9/9/20 1:05 PM, Adrien Monteleone wrote:

Not that I'm aware of, but just tab or shift-tab to the other column.
A negative credit is a positive debit and vice versa. If you try
entering a negative, you'll see GnuCash moves it to the other column
as a positive anyway.

Regards,
Adrien

On 9/9/20 12:31 PM, ToddAndMargo via gnucash-user wrote:

Fedora 32
gnucash-4.1-1.fc32.x86_64

I have a number of program that accept negative numbers
with the minus sign at the end `123.45-` or inside
parenthesis `(123.56)`.

Is there a way to tell GnuCash to do this also?  I
keep entering it the other way and having to go back
and put the minus sign in the front.


On 2020-09-09 13:18, Stephen M. Butler wrote:
 > You may also enter an enhancement request in bugzilla.
 >

Will do!

RFE: add ledger style negative number input
https://bugs.gnucash.org/show_bug.cgi?id=797939

RFE: please give the ability to add notes to simple ledger view
https://bugs.gnucash.org/show_bug.cgi?id=797940


Both were duplicates of four year or more old bugs.
Shades of Libre Office and Wine.  User input
is ignored unless you can pony up.  This is sad.
But it is the open source model.  Give the code away
for free and charge for maintenance



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