consolidation multi currency companies

2017-09-30 Thread Robert Hoogendoorn
Hi,

Does GNU-cash do multi currency company consolidation, i.e. if I have three
companies: Company A the holding Local Currency ("LC") HKD, Reporting
Currency ("RC") USD, Company B: LC EUR, RC USD and Company C: LC GBP, RC
USD.

Can this be all consolidated into the holding company in USD for reporting
purposes, or if not into the holding company, maybe into a 4th company
(Company D), just for reporting purposes into USD?

Kind regards,
Robert
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: Default terms

2017-09-30 Thread David T. via gnucash-user
Bob,

I’m no expert, but the Guide at 14.5 says:

"You can specify the billing terms on each invoice/bill. Invoice billing terms 
will default from the customer billing terms. Bill billing terms will default 
from the vendor billing terms.”

It makes no statement about setting up default terms for customers, however. To 
me, that would imply that you had to set each customer up with terms yourself, 
unfortunately. That sounds like it would be a useful enhancement, though. 

I will let others, who use the business features expand on my answer.

David


> On Sep 29, 2017, at 7:28 PM, Bob Brush  wrote:
> 
> Is there a way to make new customers or vendors automatically have terms set 
> to a default?  And is there a way to set all existing customers to a default 
> terms?
> 
> Thanks, Bob
> 
> Raleigh Tile of Beckley ** West Virginia
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> 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
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Default terms

2017-09-30 Thread Maf. King
On Saturday, 30 September 2017 10:15:29 BST David T. via gnucash-user wrote:
> Bob,
> 
> I’m no expert, but the Guide at 14.5 says:
> 
> "You can specify the billing terms on each invoice/bill. Invoice billing
> terms will default from the customer billing terms. Bill billing terms will
> default from the vendor billing terms.”
> 
> It makes no statement about setting up default terms for customers, however.
> To me, that would imply that you had to set each customer up with terms
> yourself, unfortunately. That sounds like it would be a useful enhancement,
> though.
> 
> I will let others, who use the business features expand on my answer.
> 

Hi,

Indeed, the "new customer" dialog (and, by extension I presume, but haven't 
actually checked, the Edit Customer box)  allows for a default terms setting.  
It is on the 2nd tab, "billing information"

HTH,
Maf.


-- 
Maf. King
PGP Key fingerprint = 8D68 A91F 733B 2C1F 43B7  2B7C E591 E8E1 0DE7 C542



___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Default terms

2017-09-30 Thread Geert Janssens
On zaterdag 30 september 2017 12:17:11 CEST Maf. King wrote:
> On Saturday, 30 September 2017 10:15:29 BST David T. via gnucash-user wrote:
> > Bob,
> > 
> > I’m no expert, but the Guide at 14.5 says:
> > 
> > "You can specify the billing terms on each invoice/bill. Invoice billing
> > terms will default from the customer billing terms. Bill billing terms
> > will
> > default from the vendor billing terms.”
> > 
> > It makes no statement about setting up default terms for customers,
> > however. To me, that would imply that you had to set each customer up
> > with terms yourself, unfortunately. That sounds like it would be a useful
> > enhancement, though.
> > 
> > I will let others, who use the business features expand on my answer.
> 
> Hi,
> 
> Indeed, the "new customer" dialog (and, by extension I presume, but haven't
> actually checked, the Edit Customer box)  allows for a default terms
> setting. It is on the 2nd tab, "billing information"
> 
> HTH,
> Maf.

That's right. However what is missing is a book wide setting similar to how 
you can set a book wide default for which tax table to use by default for 
bills and invoices (in File->Properties->Business). So you have to remember to 
set a term each time you create a new customer/vendor.

Geert

___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Default terms

2017-09-30 Thread David T. via gnucash-user

> On Sep 30, 2017, at 3:31 PM, Geert Janssens  
> wrote:
> 
> On zaterdag 30 september 2017 12:17:11 CEST Maf. King wrote:
>> On Saturday, 30 September 2017 10:15:29 BST David T. via gnucash-user wrote:
>>> Bob,
>>> 
>>> I’m no expert, but the Guide at 14.5 says:
>>> 
>>> "You can specify the billing terms on each invoice/bill. Invoice billing
>>> terms will default from the customer billing terms. Bill billing terms
>>> will
>>> default from the vendor billing terms.”
>>> 
>>> It makes no statement about setting up default terms for customers,
>>> however. To me, that would imply that you had to set each customer up
>>> with terms yourself, unfortunately. That sounds like it would be a useful
>>> enhancement, though.
>>> 
>>> I will let others, who use the business features expand on my answer.
>> 
>> Hi,
>> 
>> Indeed, the "new customer" dialog (and, by extension I presume, but haven't
>> actually checked, the Edit Customer box)  allows for a default terms
>> setting. It is on the 2nd tab, "billing information"
>> 
>> HTH,
>> Maf.
> 
> That's right. However what is missing is a book wide setting similar to how 
> you can set a book wide default for which tax table to use by default for 
> bills and invoices (in File->Properties->Business). So you have to remember 
> to 
> set a term each time you create a new customer/vendor.
> 
> Geert

…which I believe the original poster was after—a default that would preclude 
his having to set terms for every new customer he was creating.

David

> 
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> 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
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Default terms

2017-09-30 Thread Geert Janssens
On zaterdag 30 september 2017 13:17:48 CEST David T. wrote:
> > On Sep 30, 2017, at 3:31 PM, Geert Janssens 
> > wrote:> 
> > On zaterdag 30 september 2017 12:17:11 CEST Maf. King wrote:
> >> On Saturday, 30 September 2017 10:15:29 BST David T. via gnucash-user 
wrote:
> >>> Bob,
> >>> 
> >>> I’m no expert, but the Guide at 14.5 says:
> >>> 
> >>> "You can specify the billing terms on each invoice/bill. Invoice billing
> >>> terms will default from the customer billing terms. Bill billing terms
> >>> will
> >>> default from the vendor billing terms.”
> >>> 
> >>> It makes no statement about setting up default terms for customers,
> >>> however. To me, that would imply that you had to set each customer up
> >>> with terms yourself, unfortunately. That sounds like it would be a
> >>> useful
> >>> enhancement, though.
> >>> 
> >>> I will let others, who use the business features expand on my answer.
> >> 
> >> Hi,
> >> 
> >> Indeed, the "new customer" dialog (and, by extension I presume, but
> >> haven't
> >> actually checked, the Edit Customer box)  allows for a default terms
> >> setting. It is on the 2nd tab, "billing information"
> >> 
> >> HTH,
> >> Maf.
> > 
> > That's right. However what is missing is a book wide setting similar to
> > how
> > you can set a book wide default for which tax table to use by default for
> > bills and invoices (in File->Properties->Business). So you have to
> > remember to set a term each time you create a new customer/vendor.
> > 
> > Geert
> 
> …which I believe the original poster was after—a default that would preclude
> his having to set terms for every new customer he was creating.

Indeed, which is why I chose to add my answer. I should have addressed the 
question more directly probably, like you did.

Geert
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Report Question

2017-09-30 Thread Joseph Hesse

Hi,

I am using the latest version 2.6.17 of gnucash.  I just ran the report 
"Expense Over Time = Expense Barchart" with the maximum number of 
vertical bars selected. The report lists all my expense items including 
one called "Other". Since the amount of "Other" is high, I would like to 
get a breakdown of the expense items included under "Other".


Is there a way to do this?

Thank you,

Joe Hesse

___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Report Question

2017-09-30 Thread Christopher Lam
Edit > Report Options > Display > Maximum Bars (default 8)
Set it to a higher number, the maximum is 24

On 30 September 2017 at 20:22, Joseph Hesse  wrote:

> Hi,
>
> I am using the latest version 2.6.17 of gnucash.  I just ran the report
> "Expense Over Time = Expense Barchart" with the maximum number of vertical
> bars selected. The report lists all my expense items including one called
> "Other". Since the amount of "Other" is high, I would like to get a
> breakdown of the expense items included under "Other".
>
> Is there a way to do this?
>
> Thank you,
>
> Joe Hesse
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> 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
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


[MAINT] Network Work on Code Sunday, Oct 1, 1-4pm EDT

2017-09-30 Thread Derek Atkins
Hi,

tl;dr:  AT&T is coming to fix some network issues tomorrow, Sunday,
between 1-4pm EDT; service can last up to 2 hours and may involve
several network outages.

LONG VERSION:

As some of you may have noticed, there have been some network issues to
code which started just over a week ago.  One of the downsides was
significant packet loss and gncbot disappearing from IRC.  Alas, I had
been out of the country while this was happening and couldn't start to
really look into it; I restarted gncbot several times while I was away
but due to the persistent network issues it regularly would lost
contact.

I'm seeing anywhere from 20-40% packet loss and ping times to my
immediate router anywhere from 200-1000ms (whereas it's usually 3-4ms).
I called AT&T, my ISP, and they are sending a tech tomorrow, Sunday,
October 1, between 1-4pm EDT.  The maintenance could potentially take 2
hours once they arrive, but of course it all depends on what the issue
is.

This will affect code, lists, and wiki services including email, gncbot,
etc.

I'll attempt to keep people informed over IRC, assuming of course that I
can get online prior to the work being done.

Please let me know if you have any questions.

-derek
-- 
   Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory
   Member, MIT Student Information Processing Board  (SIPB)
   URL: http://web.mit.edu/warlord/PP-ASEL-IA N1NWH
   warl...@mit.eduPGP key available
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.