Re: [GNC] Finance::Quotes stopped working for me

[Bruno Acklin]

Hi John,

Sorry if I was unclear: the sudo cpan -i Finance::Quote install seemed to have 
succeeded without error messages, but execution still fails as before.

I upgraded Xcode to 10.2 and there seems no longer an option to add command 
line tools from Preferences.
My Library/Developer only contained /PrivateFrameworks/CoreSimulator.framework 
and /ROCKit.framework.
So I followed instructions from the link 
https://donatstudios.com/MojaveMissingHeaderFile 

to install /CommandLineTools, where I found and installed the 
macOS_SDK_headers_for_macOS_10.14.pkg you suggested. 

I would not know where to look if this fixed ExtUtils::MakeMaker, as other than 
for the /CommandLineTools my /Library/Developer and /Library/Perl folders 
looked unchanged. So I deleted Finance-Quote* and Date-Manip* again in 
Library/Perl and ~/.cpan/build, and reinstalled Date::Manip and Finance::Quote 
from clan.
Now my Library/Perl/5.18 contains: /CPAN, /Date, /Devel, /ExtUtils, /Finance, 
/HTML, /JSON, /Mozilla, /Parse, /Pod, /Test, /Darwin-thread-multi-2level, as 
well as AppendToPath and JSON.pm, butno /LWP /DateTime (still at 10.14.3, but 
like your new 10.14.4 install) or a /Perl/Extras/5.18 folder.

Unfortunately, again no success:
/Applications/Gnucash.app/Contents/Resources/bin/gnc-fq-dump -v yahoo_json aapl
Still fails and returns:
..
All fields returned by Finance::Quote for stock aapl

stock   field  value
-   -  -
aapl errormsg: Error retrieving quote for aapl. Attempt to fetch the 
URL https://query1.finance.yahoo.com/v7/finance/quote?symbols=aapl resulted in 
HTTP response 500 (Internal Server Error)
aapl last: **missing**
aapl  nav: **missing**
aaplprice: **missing**
aapl  success: 0
aapl   symbol: aapl

Interestingly though, calling the same URL from the Safari browser instantly 
returns successful quotes..

I am still stuck with the fact that selecting “Get Quotes” from the "Price 
Editor” in Gnucash worked fine one week, and not a week later from the same 
Gnucash instance still open and running on my desktop, without closing the 
program, installing any software, or modifying my system, other than installing 
a new router… Does that not point to something outside the OSX and Perl 
installation?

Thanks and Best,
Bruno


> On Mar 25, 2019, at 10:44 PM, John Ralls  
> wrote:
> 
> Bruno,
> 
> It turns out that Apple decided to put the perl headers exclusively in the 
> Xcode SDK but their perl patch doesn't quite work. Gory details may be read 
> at https://rt.cpan.org/Public/Bug/Display.html?id=127028.
> 
> The work-around in the last post to that bug, installing command-line tools 
> and then installing 
> /Library/Developer/CommandLineTools/Packages/macOS_SDK_headers_for_macOS_10.14.pkg
>  got me a clean ExtUtils::MakeMaker install without the whining about 
> EXTERNAL.h. With that in place Date::Manip will also install correctly.
> 
> I just found /System/Library/Perl/Extras/5.18/. It has DateTime and LWP, 
> explaining why F::Q doesn't complain about not finding them when they're not 
> in /Library/Perl. In fact in the course of installing Command Line Tools I 
> also got a system upgrade (from 10.14.4beta to 10.14.4) and that removed 
> DateTime and LWP from /Library/Perl/5.18 on my system. It didn't break 
> Finance::Quote, so I guess LWP is ruled out as the source of your problem.
> 
> When you say that Finance::Quote seems to work without problem does that mean 
> that stockdump.pl works but gnc-fq-dump still reports a 500 error?
> 
> Regards,
> John Ralls
> 
> 
> 
>> On Mar 25, 2019, at 4:37 PM, Bruno Acklin  wrote:
>> 
>> Hi John,
>> 
>> I was referring to MacHD/Library/Perl, so proceeded following your 
>> suggestions.
>> 
>> The rm commands worked.
>> Tried installing Date::Manip, as you suggested, which generated a long log 
>> (attached in full), but seems to have failed for the following reasons (I 
>> noticed):
>> 'YAML' not installed, will not store persistent state
>> ..
>> # Test.xs:1:10: fatal error: 'EXTERN.h' file not found
>> # #include "EXTERN.h"
>> #  ^~
>> # 1 error generated. (several times)
>> ..
>> Test Summary Report
>> ---
>> t/02-xsdynamic.t(Wstat: 3072 Tests: 72 Failed: 12)
>> Failed tests:  4, 10, 16, 22, 28, 34, 40, 46, 52, 58, 64
>>   70
>> Non-zero exit status: 12
>> Files=67, Tests=1335, 42 wallclock secs ( 0.34 usr  0.15 sys + 25.66 cusr  
>> 9.00 csys = 35.15 CPU)
>> Result: FAIL
>> Failed 1/67 test programs. 12/1335 subtests failed.
>> make: *** [test_dynamic] Error 255
>> BINGOS/ExtUtils-MakeMaker-7.34.tar.gz
>> /usr/bin/make test -- NOT OK
>> //hint// to see the cpan-testers results for installing this module, try:
>> reports BINGOS/ExtUtils-MakeMaker-7.34.tar.gz
>> Running make install
>> make test had returned bad status, won't install without force
>> Running make for 

Re: [GNC] How to suppress automatic refund fill-in for overpayment

[Adrien Monteleone]

No other benefit I can think of. It’s just a preference for treating the funds 
as a liability (until earned) rather than a negative asset.

Regards,
Adrien

> On Mar 26, 2019, at 3:10 PM, Tim Quinn  wrote:
> 
> What you described is exactly what I do, applying the “left-over” funds to 
> future invoices for that same customer. I know about and use credit memos, 
> although not exactly in the way you described.
> 
> I was really looking just for fewer key clicks during payment processing to 
> simplify things for myself, so I’m inclined not to create another Customer 
> Deposits account which seems to complicate things unless I’m missing some 
> other benefit. 
> 
> Thanks.
> 
> - Tim 


___
gnucash-user mailing list
gnucash-user@gnucash.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] XML data file load times

[Rare Bear]

I just upgraded from 3.3 to 3.4 and noticed a dramatic improvement in the
loading time of the XML datafile.  Was this an improvement in the code or
just my imagination?

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

Re: [GNC] How to suppress automatic refund fill-in for overpayment

[Tim Quinn]

What you described is exactly what I do, applying the “left-over” funds to 
future invoices for that same customer. I know about and use credit memos, 
although not exactly in the way you described.

I was really looking just for fewer key clicks during payment processing to 
simplify things for myself, so I’m inclined not to create another Customer 
Deposits account which seems to complicate things unless I’m missing some other 
benefit. 

Thanks.

- Tim

> On Mar 26, 2019, at 1:50 PM, Adrien Monteleone 
>  wrote:
> 
> I don’t think there is a way. I just zero it out manually too and let it all 
> go to A/R and then use the funds as a pre-payment that I later apply.
> 
> If you create a credit memo first since you know they’ll be getting that 
> discount, you can ‘pay’ it as part of the process.
> 
> Another option is to book the payment against a Customer Deposits liability 
> account and then pay out invoices from there as you go using just the exact 
> amount needed.
> 
> Regards,
> Adrien
> 
>> On Mar 26, 2019, at 11:50 AM, Tim Quinn  wrote:
>> 
>> Hi, all. I’m running GC Build ID: 3.4+ (2018-12-30) on Mac (High Sierra).
>> 
>> My wife offers clients a discount if they pay for several tutoring sessions 
>> in advance.
>> 
>> When I process the payment (which exceeds the first session’s invoice 
>> amount), GnuCash always computes and fills in the “Refund” amount with the 
>> excess payment.
>> 
>> This is never what I want, so I always have to clear out the Refund field 
>> manually before proceeding.
>> 
>> I have not found a preference setting to control this behavior, nor did I 
>> find anything in the mailing list archive. Have I missed it?
>> 
>> Clearly this is not a huge problem, but it’s a frequent mild annoyance I 
>> would like to avoid if I could.
>> 
>> Thanks.
>> 
>> - Tim
> 
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

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

Re: [GNC] How to change register colors in gnucash 3.x?

[Geert Janssens]

Op dinsdag 26 maart 2019 20:38:24 CET schreef Adrien Monteleone:
> My bad. I was misreading both the wiki page and the chart. Both %APPDATA%
> and %LOCALAPPDATA% are used, but one for GNC_CONFIG_HOME and the other for
> GTK_CONFIG_HOME and I was confused thinking both locations were used for
> both purposes. (though the wiki page and chart clearly indicate which is
> used where)
> 
> Just my trying to read the page too fast.
> 
> Sorry for the confusion.
> 
Well, I don't blame you. The various locations where config files can be stored 
are pretty 
complicated. David's diagrams do help IMO.

> As for the original problem, unless there is an issue with the CSS file, I
> don’t think I have any more ideas as to why it is not working.

Neither do I...

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

Re: [GNC] How to change register colors in gnucash 3.x?

[Adrien Monteleone]

My bad. I was misreading both the wiki page and the chart. Both %APPDATA% and 
%LOCALAPPDATA% are used, but one for GNC_CONFIG_HOME and the other for 
GTK_CONFIG_HOME and I was confused thinking both locations were used for both 
purposes. (though the wiki page and chart clearly indicate which is used where)

Just my trying to read the page too fast.

Sorry for the confusion.

As for the original problem, unless there is an issue with the CSS file, I 
don’t think I have any more ideas as to why it is not working.

Regards,
Adrien

> On Mar 26, 2019, at 2:29 PM, Geert Janssens  
> wrote:
> 
> Op dinsdag 26 maart 2019 20:08:10 CET schreef Adrien Monteleone:
>> Hmmm.. The wiki lists both \Roaming and \Local, only reason why I suggested
>> it.
> 
> Where did you see this ? If it does that would be a wiki bug :)
> 
> Geert

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

Re: [GNC] How to change register colors in gnucash 3.x?

[Geert Janssens]

Op dinsdag 26 maart 2019 20:08:10 CET schreef Adrien Monteleone:
> Hmmm.. The wiki lists both \Roaming and \Local, only reason why I suggested
> it.

Where did you see this ? If it does that would be a wiki bug :)

Geert


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

Re: [GNC] How to change register colors in gnucash 3.x?

[Adrien Monteleone]

Hmmm.. The wiki lists both \Roaming and \Local, only reason why I suggested it.

Regards,
Adrien

> On Mar 26, 2019, at 2:01 PM, Geert Janssens  
> wrote:
> 
> Op dinsdag 26 maart 2019 19:45:35 CET schreef Adrien Monteleone:
>> Interesting, the preference works the opposite for me. I’m on a Mac, but
>> that shouldn’t matter.
>> 
>> Windows has two locations you can put that file.
>> 
>> C:\Users\\AppData\Local\GnuCash
> 
> No, this location is not used by gnucash.
> 
> There is
> C:\Users\\AppData\Local\Gtk
> to store Gtk related config files and you may try and use that one as well. 
> Do 
> note in this case Gtk uses a different file name for its css configuration. 
> overrides.
> 
> Regards,
> 
> Geert
> 
> 
> 


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

Re: [GNC] How to change register colors in gnucash 3.x?

[Geert Janssens]

Op dinsdag 26 maart 2019 19:45:35 CET schreef Adrien Monteleone:
> Interesting, the preference works the opposite for me. I’m on a Mac, but
> that shouldn’t matter.
> 
> Windows has two locations you can put that file.
> 
> C:\Users\\AppData\Local\GnuCash

No, this location is not used by gnucash.

There is
C:\Users\\AppData\Local\Gtk
to store Gtk related config files and you may try and use that one as well. Do 
note in this case Gtk uses a different file name for its css configuration. 
overrides.

Regards,

Geert


___
gnucash-user mailing list
gnucash-user@gnucash.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] Registrare gli affitti attivi

[Adrien Monteleone]

GnuCash allows you to create ‘Customers’ that you can run a report to show 
their AR due along with aging figures. (+30days, +60days, +90days etc.)

I’d scrap the individual ’tenant name’ accounts and create them as Customers. 
Then invoice the Customers(tenants). Everything will book to AR against 
Income:Rents, until paid.
 
You can then run a Customer Report or a Receivables Report to see how each 
stands. Note, the dates of those reports are important. If you’ve posted future 
‘rental invoices’ you might have to set the end date of the report to the end 
of the year as I think it defaults to ’today’.

You might consider separate invoices per period/month, that way your aging 
figures will show how long they are overdue on a particular payment and you can 
also see a total of what remains due for the year if you like. But if you make 
one invoice for the entire year, you’ll lose that ability to see monthly 
overdue days information.

I don’t think you can create scheduled invoices, but you can go ahead and 
create and post them with future dates. Then when looking at either registers 
or reports, be sure to filter or exclude (or include) for the date range you 
want.

Along with this you can probably scrap the Assets:Credits and 
Assets:Credits:Rentals Due accounts because AR will hold all of that 
automatically.

You’ll need to turn on Business Features if you haven’t already done so.

There are others on the list who track rental properties, perhaps they can 
offer some additional info.

Regards,
Adrien

> On Mar 26, 2019, at 11:59 AM, Maurizio Campagnano 
>  wrote:
> 
> Good afternoon. I rented some apartments and I collect the relative rentals.
> I register the rents due annually in the account: assets / credits / rentals 
> due / tenant name.
> I register receipts in the account: income / rents / tenant name.
> I can't build a report that gives me the overall situation, ie the one from 
> which I can see if the tenants are up to date with the payments. Is there a 
> solution? From the accounting point of view, is the structure I built 
> correct? Thanks for your answer.
> Maurizio Campagnano


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

Re: [GNC] How to suppress automatic refund fill-in for overpayment

[Geert Janssens]

Op dinsdag 26 maart 2019 17:50:58 CET schreef Tim Quinn:
> Hi, all. I’m running GC Build ID: 3.4+ (2018-12-30) on Mac (High Sierra).
> 
> My wife offers clients a discount if they pay for several tutoring sessions
> in advance.
> 
> When I process the payment (which exceeds the first session’s invoice
> amount), GnuCash always computes and fills in the “Refund” amount with the
> excess payment.
> 
> This is never what I want, so I always have to clear out the Refund field
> manually before proceeding.
> 
> I have not found a preference setting to control this behavior, nor did I
> find anything in the mailing list archive. Have I missed it?
> 
> Clearly this is not a huge problem, but it’s a frequent mild annoyance I
> would like to avoid if I could.

Hi Tim,

Just to be sure I understand correctly what's happening:

So you have at some point used the Process Payment window to enter a 
prepayment for a customer.
That at some point later you write the first invoice for that customer.
As the customer has already paid in advance you'd now like to link part of the 
prepayment to that invoice.
If you use the process payment window to do so (by selecting both the 
prepayment and the invoice) it will fill the Refund field.

When doing this manually it will always fill that field indeed. The only way I 
have  found to avoid this is to configure gnucash to automatically pay 
invoices on posting. You can enable this via
Edit->Preferences->Business->(Invoices)Process Payments on Posting

Regards,

Geert


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

Re: [GNC] How to suppress automatic refund fill-in for overpayment

[Adrien Monteleone]

I don’t think there is a way. I just zero it out manually too and let it all go 
to A/R and then use the funds as a pre-payment that I later apply.

If you create a credit memo first since you know they’ll be getting that 
discount, you can ‘pay’ it as part of the process.

Another option is to book the payment against a Customer Deposits liability 
account and then pay out invoices from there as you go using just the exact 
amount needed.

Regards,
Adrien

> On Mar 26, 2019, at 11:50 AM, Tim Quinn  wrote:
> 
> Hi, all. I’m running GC Build ID: 3.4+ (2018-12-30) on Mac (High Sierra).
> 
> My wife offers clients a discount if they pay for several tutoring sessions 
> in advance.
> 
> When I process the payment (which exceeds the first session’s invoice 
> amount), GnuCash always computes and fills in the “Refund” amount with the 
> excess payment.
> 
> This is never what I want, so I always have to clear out the Refund field 
> manually before proceeding.
> 
> I have not found a preference setting to control this behavior, nor did I 
> find anything in the mailing list archive. Have I missed it?
> 
> Clearly this is not a huge problem, but it’s a frequent mild annoyance I 
> would like to avoid if I could.
> 
> Thanks.
> 
> - Tim

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

Re: [GNC] How to change register colors in gnucash 3.x?

[Adrien Monteleone]

Interesting, the preference works the opposite for me. I’m on a Mac, but that 
shouldn’t matter.

Windows has two locations you can put that file.

C:\Users\\AppData\Local\GnuCash
C:\Users\\AppData\Roaming\GnuCash

You tried the second one. Try the first. (or both?)

Other than that, perhaps there is a problem with the css file itself. What app 
did you use to create it? (be sure it has a .css extension and not .css.txt and 
that your app is set to linux/unix line endings.)

Also double-check the syntax on that particular css rule, maybe even change the 
declaration to something more glaring like ‘red’ or ‘pink’ as ’seagreen’ is not 
far off from the default color. (it is a bit darker though)

You can also try storing that file in the main GTK locations and unchecking the 
preference. Note, this will likely affect other GTK apps if you have them 
installed.

Regards,
Adrien

> On Mar 26, 2019, at 11:13 AM, dsp1024 via gnucash-user 
>  wrote:
> 
> 
> I tried your suggestion and I still have no luck. I'm either missing
> something basic or the instructions are not correct or clear enough. I
> copied the text of the instructions below. I'm leaning towards me missing
> something. But I don't see what.
> 
> This is what the tool tip says:
> "GnuCash uses a yellow/green theme by default for registered windows.
> Uncheck this if you want to use the system color theme instead."
> 
> 
> 
> --- instructions start
> ---
> Register Appearance
> The GnuCash registers use a yellow/green theme by default for register
> windows. Users must disable this default theme in order to change register
> appearance.
> 
> To override this, one first has to disable this custom theme by disabling
> "Use GnuCash built-in color theme" in the GnuCash Preferences.
> 
> Next, create or change the GTK css file for further styling tweaks. The
> location and name of the resource file is explained in Configuration
> Locations.
> 
> For adjusting register colors, you can override the relevant css style
> definitions in your own GTK3 resource file. See GTK css example for example
> settings.
> --- instructions end
> ---
> 


___
gnucash-user mailing list
gnucash-user@gnucash.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] Actual income

[Adrien Monteleone]

Income = Revenue - Expenses

The Income Statement is showing you the correct amount.

Your issue with it is that you are using an accrual method of accounting but 
you want a cash-basis figure. (You are booking Revenue when you earn it with 
invoices — proper for the accrual method, but you only want to book it when you 
actually receive payment — that’s cash-basis)

You can abandon the Business Features and change your workflow, or...

Either play with the Cash Flow report to get where you want, or even better, 
investigate the use of a special account called “Allowance for Doubtful 
Accounts”. There is plenty of literature online to help with how that account 
is used. You will be estimating the amount of A/R that is uncollectible and 
then making adjustments as you determine exact values in later periods.

The Balance Sheet is not intended to report annual Income, it is a snapshot of 
Assets, Liabilities and Equity on a specific date. (If you are in the habit of 
closing the revenue and expense accounts each year as Retained Earnings to 
Equity, this will show you the aggregate retained, but not for any particular 
fiscal year or calendar year)

Also, I highly recommend you speak to a local CPA. They can guide you on how to 
keep your books, set up your chart of accounts, and which reports give you 
which information and they can do so with your local laws and requirements in 
mind for your particular situation.

Regards,
Adrien

> On Mar 26, 2019, at 9:45 AM, Martijn Heuts  wrote:
> 
> Hello,
> I am trying to understand my 2018 reports and the actual (net) 2018 income.
> I realize that the 'Cash Flow' report does not subtract any refunds from the 
> total. 
> The 'Income Statement' and 'Balance Sheet' reports do include the refunds, 
> however these reports also include any invoices charged out whether they were 
> (partly) paid or not. This unpaid balance goes to AR. Probably 60% of the AR 
> is written off at our office as we work with insurance write-offs which we 
> process at the time of the insurance payment (usually 30-90 days later, so 
> part of our AR payments and write-off's are processed in 2019).
> The point I am trying to make is that the 'Cash Flow' report doesn't show how 
> much income we really hadas we had refunds in 2018 and the 'Income Statement' 
> and/or 'balance sheet' report doesn't show how muchincome we had as these 
> reports do not show 'income' but they show 'charges'.
> Is there a report what shows the actual income I had in 2018 without the 
> refunds and AR?Perhaps in the Cash Flow report can I filter out refunds? If 
> so that would be the answer, I guess?
> Thanks for all you do!
> Martijn

___
gnucash-user mailing list
gnucash-user@gnucash.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] How to suppress automatic refund fill-in for overpayment

[Tim Quinn]

Hi, all. I’m running GC Build ID: 3.4+ (2018-12-30) on Mac (High Sierra).

My wife offers clients a discount if they pay for several tutoring sessions in 
advance.

When I process the payment (which exceeds the first session’s invoice amount), 
GnuCash always computes and fills in the “Refund” amount with the excess 
payment.

This is never what I want, so I always have to clear out the Refund field 
manually before proceeding.

I have not found a preference setting to control this behavior, nor did I find 
anything in the mailing list archive. Have I missed it?

Clearly this is not a huge problem, but it’s a frequent mild annoyance I would 
like to avoid if I could.

Thanks.

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

Re: [GNC] How to change register colors in gnucash 3.x?

[dsp1024 via gnucash-user]

I tried your suggestion and I still have no luck. I'm either missing
something basic or the instructions are not correct or clear enough. I
copied the text of the instructions below. I'm leaning towards me missing
something. But I don't see what.

This is what the tool tip says:
"GnuCash uses a yellow/green theme by default for registered windows.
Uncheck this if you want to use the system color theme instead."



--- instructions start
---
Register Appearance
The GnuCash registers use a yellow/green theme by default for register
windows. Users must disable this default theme in order to change register
appearance.

To override this, one first has to disable this custom theme by disabling
"Use GnuCash built-in color theme" in the GnuCash Preferences.

Next, create or change the GTK css file for further styling tweaks. The
location and name of the resource file is explained in Configuration
Locations.

For adjusting register colors, you can override the relevant css style
definitions in your own GTK3 resource file. See GTK css example for example
settings.
--- instructions end
---



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

Re: [GNC] Actual income

[Christopher Lam]

The cash flow report is not very well documented nor understood. There are
users who report bugs based on incomplete understanding of issues and
design decisions made by the report writers.

I strongly recommend tweaking the Transaction Report which is much more
predictable, and if you select the *correct* source accounts, will never
fail to produce predictable reports.

With regards to your business processes above I am very sorry it's not
exactly detailed enough to show the accounts, account-types, and
transaction flow of amounts. Your best bet would be to recreate a sample
datafile and submit in bugzilla.

On Tue, 26 Mar 2019 at 22:48, Martijn Heuts 
wrote:

> Hello,
> I am trying to understand my 2018 reports and the actual (net) 2018 income.
> I realize that the 'Cash Flow' report does not subtract any refunds from
> the total.
> The 'Income Statement' and 'Balance Sheet' reports do include the refunds,
> however these reports also include any invoices charged out whether they
> were (partly) paid or not. This unpaid balance goes to AR. Probably 60% of
> the AR is written off at our office as we work with insurance write-offs
> which we process at the time of the insurance payment (usually 30-90 days
> later, so part of our AR payments and write-off's are processed in 2019).
> The point I am trying to make is that the 'Cash Flow' report doesn't show
> how much income we really hadas we had refunds in 2018 and the 'Income
> Statement' and/or 'balance sheet' report doesn't show how muchincome we had
> as these reports do not show 'income' but they show 'charges'.
> Is there a report what shows the actual income I had in 2018 without the
> refunds and AR?Perhaps in the Cash Flow report can I filter out refunds? If
> so that would be the answer, I guess?
> Thanks for all you do!
> Martijn
>
>
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.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] Actual income

[Martijn Heuts]

Hello,
I am trying to understand my 2018 reports and the actual (net) 2018 income.
I realize that the 'Cash Flow' report does not subtract any refunds from the 
total. 
The 'Income Statement' and 'Balance Sheet' reports do include the refunds, 
however these reports also include any invoices charged out whether they were 
(partly) paid or not. This unpaid balance goes to AR. Probably 60% of the AR is 
written off at our office as we work with insurance write-offs which we process 
at the time of the insurance payment (usually 30-90 days later, so part of our 
AR payments and write-off's are processed in 2019).
The point I am trying to make is that the 'Cash Flow' report doesn't show how 
much income we really hadas we had refunds in 2018 and the 'Income Statement' 
and/or 'balance sheet' report doesn't show how muchincome we had as these 
reports do not show 'income' but they show 'charges'.
Is there a report what shows the actual income I had in 2018 without the 
refunds and AR?Perhaps in the Cash Flow report can I filter out refunds? If so 
that would be the answer, I guess?
Thanks for all you do!
Martijn



___
gnucash-user mailing list
gnucash-user@gnucash.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.