Re: [GNC] re-adding billable expenses to an invoice

2018-09-06 Thread Matthew Pounsett
On 6 September 2018 at 12:04, Derek Atkins  wrote:

> Matthew Pounsett  writes:
>
> > I accidentally flubbed some keyboard entry while putting together an
> > invoice and messed up a billable expense item which had been
> automatically
> > added when the invoice was created.  Since there is no "Undo" the best
> > option seemed to be to delete the entry and start over, but I can't find
> a
> > way to instruct GnuCash to add billable items to an invoice.  It seems to
> > do it automatically at invoice creation, and no other way.
> >
> > Am I missing something?
>
> When you are editing the invoice, just click in the "Billable" column
> when adding the line-item to mark it as billable.
>

I think you've misunderstood the question.   There are already billable
expenses in the system.  I'm generating the invoice in which those billable
items will be passed on to the client.

I need to re-add the billable expenses to the invoice.  There doesn't
appear to be a way to do that... it looks like they are only added when the
invoice is first created.. I can't find any button, menu, or anything else
that would trigger adding billable expenses to an existing invoice.
___
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] GAU as currency or commodity

2018-09-06 Thread Frank H. Ellenberger


Am 06.09.2018 um 21:33 schrieb David T. via gnucash-user:
> Of course, Michael, you are right--except for the fact that the ISO currency 
> codes include entries for gold, silver, as well as one or two others, which 
> is what I was referring to. I was anticipating Muhammad's next question.
> Muhammad, there won't be any way for you to obtain daily prices for a gram of 
> gold,  other than to enter it manually. 

Why not?
As told before currently it can not be used as currency
(https://bugs.gnucash.org/show_bug.cgi?id=657215 - Need ability to
declare new currencies), but as commodity. So you can at least use it as
asset.

The easy way would set a fixed rate for 1 XAU = 31.1034768 GAU in both
directions and query the currency XAU with F::Q

On long term one could write a new Finance::Quote module to get quotes
from i.e. https://www.investing.com/currencies/gau-eur.

> David
>  
>  
>   On Thu, Sep 6, 2018 at 14:15, Muhammad Bashir Al-Noimi 
> wrote:     On 09/06/2018 09:09 PM, Mike or Penny Novack wrote:
> 
>     Not a currency but a commodity. The reason no currency symbol is at
>     present there is no jurisdiction using gram Au as its CURRENCY.
> 
>   How can I use it in GNC (I didn't use a commodity before)?
>   The most important thing about using GAU is getting updated quote on
>   daily basis.
> --
> Best Regards,
> Muhammad Bashir Al-Noimi
> Skype+Telegram+GMail: mbnoimi

___
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] Reconciliation Question

2018-09-06 Thread David T. via gnucash-user
Assuming that everything else is reconciled,  all you really need to do is add 
the missing transactions and re-reconcile. Ignore the starting balance, and 
enter the same closing balance as your last statement.  Those three items will 
appear in the reconciliation window,  you check them off,  and everything is 
back. Nothing too difficult. 
David
P.S. how in goodness did you discover that you were missing three transactions 
from 2015 that all balanced out? 

 
 
  On Thu, Sep 6, 2018 at 15:37, David Carlson 
wrote:   Mark,

I suggest trying your proposed fix on a test copy of your datafile.  You
may find that you also need to re-reconcile other months or "indulge" in
some creative temporary offsetting transactions to get August or September
reconciliations to end with the correct ending balance.  I have not tried
that sort of thing in a couple of years, so my experience is very stale.

Starting balances do not need to match your statements, as there is no way
to view which month any particular transaction was actually reconciled to.

David C

On Thu, Sep 6, 2018 at 11:57 AM Mark Phillips 
wrote:

> I was reconciling my bank statement for August 2018 the other day, and
> everything balanced. Yeah!!
>
> However, I also discovered that three transactions were inadvertently
> deleted from October 2015 - two debits and one credit. Everything balances
> because magically, the sum of the debits equals the credit for these three
> deleted transactions.
>
> I assume to fix the problem,
>
> (1) I would re-enter the transactions, and then
> (2) re-reconcile October 2015,
>
> and that would be it.
>
> I wanted to check with those more experienced in GnuCash to make sure I am
> not missing an important step to get these transactions back into GnuCash
> with the satisfying little "y" in the Reconciled column.
>
> Thanks!
>
> Mark
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.
  
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Reconciliation Question

2018-09-06 Thread David Carlson
Mark,

I suggest trying your proposed fix on a test copy of your datafile.  You
may find that you also need to re-reconcile other months or "indulge" in
some creative temporary offsetting transactions to get August or September
reconciliations to end with the correct ending balance.  I have not tried
that sort of thing in a couple of years, so my experience is very stale.

Starting balances do not need to match your statements, as there is no way
to view which month any particular transaction was actually reconciled to.

David C

On Thu, Sep 6, 2018 at 11:57 AM Mark Phillips 
wrote:

> I was reconciling my bank statement for August 2018 the other day, and
> everything balanced. Yeah!!
>
> However, I also discovered that three transactions were inadvertently
> deleted from October 2015 - two debits and one credit. Everything balances
> because magically, the sum of the debits equals the credit for these three
> deleted transactions.
>
> I assume to fix the problem,
>
> (1) I would re-enter the transactions, and then
> (2) re-reconcile October 2015,
>
> and that would be it.
>
> I wanted to check with those more experienced in GnuCash to make sure I am
> not missing an important step to get these transactions back into GnuCash
> with the satisfying little "y" in the Reconciled column.
>
> Thanks!
>
> Mark
> ___
> 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] GAU as currency

2018-09-06 Thread David T. via gnucash-user
Of course, Michael, you are right--except for the fact that the ISO currency 
codes include entries for gold, silver, as well as one or two others, which is 
what I was referring to. I was anticipating Muhammad's next question.
Muhammad, there won't be any way for you to obtain daily prices for a gram of 
gold,  other than to enter it manually. 
David
 
 
  On Thu, Sep 6, 2018 at 14:15, Muhammad Bashir Al-Noimi 
wrote:     On 09/06/2018 09:09 PM, Mike or Penny Novack wrote:

    Not a currency but a commodity. The reason no currency symbol is at
    present there is no jurisdiction using gram Au as its CURRENCY.

  How can I use it in GNC (I didn't use a commodity before)?
  The most important thing about using GAU is getting updated quote on
  daily basis.
--
Best Regards,
Muhammad Bashir Al-Noimi
Skype+Telegram+GMail: mbnoimi
___
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] Currency exchange rates retrieval with GC 3.2

2018-09-06 Thread John Ralls


> On Sep 6, 2018, at 9:21 AM, Manfred Usselmann  wrote:
> 
> Am 06.09.2018 16:33, schrieb John Ralls:
> 
>> 
>> 
>>> On Sep 6, 2018, at 12:15 AM, Manfred Usselmann >> > wrote:
>>> 
>>> 
>>> 
>>> Hi, 
>>> 
>>> I'm using GnuCash 3.2 with Finance::Quote 1.47 on Ubuntu 18.04. 
>>> 
>>> When trying to download currency exchange rates this fails with "Unknown
>>> error". 
>>> 
>>> I've registered an ALPHAVANTAGE_API_KEY and entered it on the settings
>>> screen. 
>>> 
>>> Some tests from the command line: 
>>> 
>>> $ GNC-FQ-DUMP -V ALPHAVANTAGE CHFEUR=X
>>> Finance::Quote fields Gnucash uses:
>>> symbol: CHFEUR=X <=== required
>>> date: 09/06/2018 <=== recommended
>>> currency: USD <=== required
>>> last: 0.8842 <=\ 
>>> nav: <=== one of these
>>> price: <=/ 
>>> timezone: <=== optional 
>>> 
>>> All fields returned by Finance::Quote for stock CHFEUR=X 
>>> 
>>> stock field value
>>> - - -
>>> CHFEUR=X close: 0.8842
>>> CHFEUR=X currency: USD
>>> CHFEUR=X currency_set_by_fq: 1
>>> CHFEUR=X date: 09/06/2018
>>> CHFEUR=X high: 0.8847
>>> CHFEUR=X isodate: 2018-09-06
>>> CHFEUR=X last: 0.8842
>>> CHFEUR=X low: 0.8840
>>> CHFEUR=X method: alphavantage
>>> CHFEUR=X open: 0.8845
>>> CHFEUR=X success: 1
>>> CHFEUR=X symbol: CHFEUR=X
>>> CHFEUR=X volume: 0 
>>> 
>>> $ ECHO '(ALPHAVANTAGE "CSCO")' | GNC-FQ-HELPER
>>> (("CSCO" (symbol . "CSCO") (gnc:time-no-zone . "2018-09-05 12:00:00")
>>> (last . 47.2700) (currency . "USD")))
>> 
>> Does the CSCO price retrieval work in GnuCash?
>>  
>  
>  
> No, also got unknown error. I'm not sure though that I set it up correctly. 
> The command line was just copied from somewhere, the wiki I believe.
>  
>  
>  
>>  
>> 
>> I created a CHFEUR=X security, set it to retrieve quotes from Alphavantage, 
>> and successfully retrieved the price in GnuCash.
>>  
>  
> I did not create a security, just a currency account.
>  
>  
>>  
>> Note, however, that it's not a meaningful value: CHFEUR=X retrieves the 
>> price in EUR of 1CHF, but Finance::Quote treats it as USD because 
>> Alphavantage doesn't tell it otherwise.
>>  
>  
>  
> Mmh, but the manual says to use Alphavantage for currencies?
>  
> Are there any instructions which should work. I just want to download 
> exchange rates... ;-)
>  
> Unknown error  is not really helpful...  The exact error message is "Beim 
> Herunterladen der Börsenkurse ist ein unbekannter Fehler aufgetragen.”

Currency quotes are taken care of separately and use a different syntax in 
gnc-fq-dump and gnc-fq-helper:

gnc-fq-dump currency CHF EUR 
echo ‘(currency “CHF” “EUR”)’ | gnc-fq-helper 

It does use Alphavantage, but that part is built in to Finance::Quote and 
GnuCash sends the query shown to gnc-fq-helper for currency accounts.

Yes, we know that "unknown error" isn’t very helpful. Unfortunately there's no 
good way to get more detail about the error from perl to scheme so that's the 
best we can do. Double check that you correctly copied the API key into GnuCash 
Preferences, that's the most likely cause of being able to get quotes from the 
command line but not from within GnuCash.

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.

[GNC] (no subject)

2018-09-06 Thread Barry Nichol via gnucash-user
???
Sent from Mail for Windows 10




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


[GNC] (no subject)

2018-09-06 Thread Barry Nichol via gnucash-user
 

Sent from Mail for Windows 10




---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus
___
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] GAU as currency

2018-09-06 Thread Muhammad Bashir Al-Noimi
   On 09/06/2018 09:09 PM, Mike or Penny Novack wrote:

 Not a currency but a commodity. The reason no currency symbol is at
 present there is no jurisdiction using gram Au as its CURRENCY.

   How can I use it in GNC (I didn't use a commodity before)?
   The most important thing about using GAU is getting updated quote on
   daily basis.
--
Best Regards,
Muhammad Bashir Al-Noimi
Skype+Telegram+GMail: mbnoimi
___
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] GAU as currency

2018-09-06 Thread Mike or Penny Novack

On 9/6/2018 12:26 PM, David T. via gnucash-user wrote:

I am not an expert, but my understanding is that the currency codes are derived 
from the ISO standards. GAU isn't among those.
David
  
  
   On Thu, Sep 6, 2018 at 12:19, Muhammad Bashir Al-Noimi wrote: Hi,

   How can use GAU (gold gram) as a currency in GNC instead of XAU (gold
   ounce)?
   I'm using GAU on daily basis.
--
Best Regards,
Muhammad Bashir Al-Noimi
Not a currency but a commodity. The reason no currency symbol is at 
present there is no jurisdiction using gram Au as its CURRENCY.


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.


[GNC] Reconciliation Question

2018-09-06 Thread Mark Phillips
I was reconciling my bank statement for August 2018 the other day, and
everything balanced. Yeah!!

However, I also discovered that three transactions were inadvertently
deleted from October 2015 - two debits and one credit. Everything balances
because magically, the sum of the debits equals the credit for these three
deleted transactions.

I assume to fix the problem,

(1) I would re-enter the transactions, and then
(2) re-reconcile October 2015,

and that would be it.

I wanted to check with those more experienced in GnuCash to make sure I am
not missing an important step to get these transactions back into GnuCash
with the satisfying little "y" in the Reconciled column.

Thanks!

Mark
___
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] GAU as currency

2018-09-06 Thread David T. via gnucash-user

I am not an expert, but my understanding is that the currency codes are derived 
from the ISO standards. GAU isn't among those.
David
 
 
  On Thu, Sep 6, 2018 at 12:19, Muhammad Bashir Al-Noimi 
wrote:     Hi,
  How can use GAU (gold gram) as a currency in GNC instead of XAU (gold
  ounce)?
  I'm using GAU on daily basis.
--
Best Regards,
Muhammad Bashir Al-Noimi
Skype+Telegram+GMail: mbnoimi
___
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] Currency exchange rates retrieval with GC 3.2

2018-09-06 Thread Manfred Usselmann
 

Am 06.09.2018 16:33, schrieb John Ralls: 

>> On Sep 6, 2018, at 12:15 AM, Manfred Usselmann  wrote:
>> 
>> Hi, 
>> 
>> I'm using GnuCash 3.2 with Finance::Quote 1.47 on Ubuntu 18.04. 
>> 
>> When trying to download currency exchange rates this fails with "Unknown
>> error". 
>> 
>> I've registered an ALPHAVANTAGE_API_KEY and entered it on the settings
>> screen. 
>> 
>> Some tests from the command line: 
>> 
>> $ GNC-FQ-DUMP -V ALPHAVANTAGE CHFEUR=X
>> Finance::Quote fields Gnucash uses:
>> symbol: CHFEUR=X <=== required
>> date: 09/06/2018 <=== recommended
>> currency: USD <=== required
>> last: 0.8842 <=\ 
>> nav: <=== one of these
>> price: <=/ 
>> timezone: <=== optional 
>> 
>> All fields returned by Finance::Quote for stock CHFEUR=X 
>> 
>> stock field value
>> - - -
>> CHFEUR=X close: 0.8842
>> CHFEUR=X currency: USD
>> CHFEUR=X currency_set_by_fq: 1
>> CHFEUR=X date: 09/06/2018
>> CHFEUR=X high: 0.8847
>> CHFEUR=X isodate: 2018-09-06
>> CHFEUR=X last: 0.8842
>> CHFEUR=X low: 0.8840
>> CHFEUR=X method: alphavantage
>> CHFEUR=X open: 0.8845
>> CHFEUR=X success: 1
>> CHFEUR=X symbol: CHFEUR=X
>> CHFEUR=X volume: 0 
>> 
>> $ ECHO '(ALPHAVANTAGE "CSCO")' | GNC-FQ-HELPER
>> (("CSCO" (symbol . "CSCO") (gnc:time-no-zone . "2018-09-05 12:00:00")
>> (last . 47.2700) (currency . "USD")))
> 
> Does the CSCO price retrieval work in GnuCash?

No, also got unknown error. I'm not sure though that I set it up
correctly. The command line was just copied from somewhere, the wiki I
believe. 

> I created a CHFEUR=X security, set it to retrieve quotes from Alphavantage, 
> and successfully retrieved the price in GnuCash.

I did not create a security, just a currency account. 

> Note, however, that it's not a meaningful value: CHFEUR=X retrieves the price 
> in EUR of 1CHF, but Finance::Quote treats it as USD because Alphavantage 
> doesn't tell it otherwise.

Mmh, but the manual says to use Alphavantage for currencies? 

Are there any instructions which should work. I just want to download
exchange rates... ;-) 

Unknown error is not really helpful... The exact error message is "Beim
Herunterladen der Börsenkurse ist ein unbekannter Fehler aufgetragen." 

Regards,
Manfred 

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

[GNC] GAU as currency

2018-09-06 Thread Muhammad Bashir Al-Noimi
   Hi,
   How can use GAU (gold gram) as a currency in GNC instead of XAU (gold
   ounce)?
   I'm using GAU on daily basis.
--
Best Regards,
Muhammad Bashir Al-Noimi
Skype+Telegram+GMail: mbnoimi
___
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] re-adding billable expenses to an invoice

2018-09-06 Thread Derek Atkins
Hi,

Matthew Pounsett  writes:

> I accidentally flubbed some keyboard entry while putting together an
> invoice and messed up a billable expense item which had been automatically
> added when the invoice was created.  Since there is no "Undo" the best
> option seemed to be to delete the entry and start over, but I can't find a
> way to instruct GnuCash to add billable items to an invoice.  It seems to
> do it automatically at invoice creation, and no other way.
>
> Am I missing something?

When you are editing the invoice, just click in the "Billable" column
when adding the line-item to mark it as billable.

> GnuCash 2.6.21.
>
> Thanks!
>Matt

> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

-derek

-- 
   Derek Atkins, 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
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] Negative assets!

2018-09-06 Thread Muhammad Bashir Al-Noimi
   On 09/06/2018 05:07 PM, Muhammad Bashir Al-Noimi wrote:

   On 09/06/2018 02:49 PM, Adrien Monteleone wrote:

Credit Cards are usually liabilities, not Assets.

   Actually it's an asset because it's very special card provided by my
   company.

Click that credit card account in the CoA and then click the Edit Account button
. What fundamental type is it? Asset? Liability?

   Asset

Also, out of curiosity, does a Balance Sheet also show negative Current Assets?

   In the attachment you can find my Balance Sheet all the red values are
   incorrect.
   I may discovered the problem.
   In the attachment you can find that "Imbalance-USD" contains on
   duplicated incorrect transactions which I didn't create them!!!
   Do you have any suggestion for this strange case?
   Thanks very much guys I could fix the problem by following these steps:
1. Manually deleted all the duplicated transactions in "Imbalance-USD"
2. Manually deleted all empty transactions in "Imbalance-USD"
3. Emptied "Assets:Current Assets:GAU" then re-entered same
   transactions once again.

   It seems that my database entries corrupted because I didn't point to a
   correct account during deleting the old accounts.
--
Best Regards,
Muhammad Bashir Al-Noimi
Skype+Telegram+GMail: mbnoimi
___
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] Currency exchange rates retrieval with GC 3.2

2018-09-06 Thread John Ralls


> On Sep 6, 2018, at 12:15 AM, Manfred Usselmann  wrote:
> 
> 
> 
> Hi, 
> 
> I'm using GnuCash 3.2 with Finance::Quote 1.47 on Ubuntu 18.04. 
> 
> When trying to download currency exchange rates this fails with "Unknown
> error". 
> 
> I've registered an ALPHAVANTAGE_API_KEY and entered it on the settings
> screen. 
> 
> Some tests from the command line: 
> 
> $ GNC-FQ-DUMP -V ALPHAVANTAGE CHFEUR=X
> Finance::Quote fields Gnucash uses:
> symbol: CHFEUR=X <=== required
> date: 09/06/2018 <=== recommended
> currency: USD <=== required
> last: 0.8842 <=\ 
> nav: <=== one of these
> price: <=/ 
> timezone: <=== optional 
> 
> All fields returned by Finance::Quote for stock CHFEUR=X 
> 
> stock field value
> - - -
> CHFEUR=X close: 0.8842
> CHFEUR=X currency: USD
> CHFEUR=X currency_set_by_fq: 1
> CHFEUR=X date: 09/06/2018
> CHFEUR=X high: 0.8847
> CHFEUR=X isodate: 2018-09-06
> CHFEUR=X last: 0.8842
> CHFEUR=X low: 0.8840
> CHFEUR=X method: alphavantage
> CHFEUR=X open: 0.8845
> CHFEUR=X success: 1
> CHFEUR=X symbol: CHFEUR=X
> CHFEUR=X volume: 0 
> 
> $ ECHO '(ALPHAVANTAGE "CSCO")' | GNC-FQ-HELPER
> (("CSCO" (symbol . "CSCO") (gnc:time-no-zone . "2018-09-05 12:00:00")
> (last . 47.2700) (currency . "USD"))) 

Does the CSCO price retrieval work in GnuCash?
I created a CHFEUR=X security, set it to retrieve quotes from Alphavantage, and 
successfully retrieved the price in GnuCash.

Note, however, that it’s not a meaningful value: CHFEUR=X retrieves the price 
in EUR of 1CHF, but Finance::Quote treats it as USD because Alphavantage 
doesn’t tell it otherwise.

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] Negative assets!

2018-09-06 Thread Muhammad Bashir Al-Noimi
   On 09/06/2018 05:25 PM, Geert Janssens wrote:

Yes, that means the transactions you deleted were transferred to imbalance-USD
because you didn't assign them to a new account.

Does your book use multiple currencies ?

   Yes, I use multi-currencies
--
Best Regards,
Muhammad Bashir Al-Noimi
Skype+Telegram+GMail: mbnoimi
___
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] Negative assets!

2018-09-06 Thread Geert Janssens
Op donderdag 6 september 2018 16:07:35 CEST schreef Muhammad Bashir Al-Noimi:
>I may discovered the problem.
>In the attachment you can find that "Imbalance-USD" contains on
>duplicated incorrect transactions which I didn't create them!!!
>Do you have any suggestion for this strange case?

Yes, that means the transactions you deleted were transferred to imbalance-USD 
because you didn't assign them to a new account.

Does your book use multiple currencies ?

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] Online Price Retrieval Fails

2018-09-06 Thread John Ralls


> On Sep 5, 2018, at 8:49 PM, nvsoar  wrote:
> 
> On 09/05/18 17:27, John Ralls wrote:
>> 
>>> On Sep 5, 2018, at 12:26 PM, nvsoar  wrote:
>>> 
>>> Running Win 10 - Install online price retrieval (GnuCash version 2.6.21) 
>>> reports DateManip could not be found; reports the following at the end.
>>> 
>>> * Run gnc-fq-helper
>>> Can't locate Date/Manip.pm in @INC (you may need to install the Date::Manip 
>>> module) (@INC contains: C:/strawberry/perl/site/lib 
>>> C:/strawberry/perl/vendor/lib C:/strawberry/perl/lib .) at gnc-fq-helper 
>>> line 29.
>>> BEGIN failed--compilation aborted at gnc-fq-helper line 29.
>>> An error occurred, see above.
>>> Press any key to continue . . .
>>> 
>>> Have know idea for the meaning of @INC, or where to put the Date::Manip 
>>> module.
>>> 
>>> Same fault for GnuCash version 2.6.17
>>> 
>> Run the Online Price Retrieval Setup program. Date::Manip is a required perl 
>> module.
>> 
>> Regards,
>> John Ralls
>> 
>> 
>> 
> That's what did not work.  Downloaded v2.6.21; went GnuCash menu and selected 
> "Install Online Price Retrieval for GnuCash."  This action resulted in the 
> message above at the end of the process. Observing the process running on the 
> terminal showed a message similar to "could not find DateManip" part way 
> through.
> 
> I apologize for not being clear in the initial report.

Hmm. Date::Manip is in the CPAN repository, 
https://cpan.metacpan.org/authors/id/S/SB/SBECK/Date-Manip-6.73.tar.gz 
. The 
URL has changed, though, from cpan.org to metacpan.org . 
That’s just the last couple of months, I think.

Try opening a Strawberry Perl window from the Start menu and run the command
  cpan -i Date::Manip

There are likely multiple error messages and having the output in a window that 
doesn’t disappear at the end will help you see them all.

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] Negative assets!

2018-09-06 Thread Adrien Monteleone
Credit Cards are usually liabilities, not Assets.

To not see a balance as a ‘Current Asset’ for an account that isn’t really a 
current asset makes sense. Though I’m not sure the code involved is paying 
attention to account type more than the sub-account’s location in the tree.

Click that credit card account in the CoA and then click the Edit Account 
button. What fundamental type is it? Asset? Liability?

Also, out of curiosity, does a Balance Sheet also show negative Current Assets?

Regards,
Adrien

> On Sep 6, 2018, at 4:05 AM, Muhammad Bashir Al-Noimi  
> wrote:
> 
>   On 09/06/2018 11:55 AM, Geert Janssens wrote:
> 
> Most transactions not showing a balance is odd.
> 
>   See this transaction as example:
>   When I open it from "Assets:Current Assets:TRY:Kocamustafapasa -
>   CreditCard" it appears correctly as shown below:
>   But when I open same transaction from "Current Assets and select
>   Edit>Open Subaccounts" it appears without a balance as shown below:
> --
> Best Regards,
> Muhammad Bashir Al-Noimi
> Skype+Telegram+GMail: mbnoimi
> ___
> 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] Old dates preferred to near future

2018-09-06 Thread Thomas Klausner
On Thu, Sep 06, 2018 at 10:53:45AM +0200, Geert Janssens wrote:
> Perhaps you are experiencing a change in the Date completion settings.
> 
> Can you check Edit->Preferences->Date/Time->Date Completion and adjust to 
> your 
> preferences.

Indeed, setting that from 11 to 3 makes it match what I want.

Thank you!
 Thomas
___
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] Negative assets!

2018-09-06 Thread Muhammad Bashir Al-Noimi
   On 09/06/2018 11:55 AM, Geert Janssens wrote:

Most transactions not showing a balance is odd.

   See this transaction as example:
   When I open it from "Assets:Current Assets:TRY:Kocamustafapasa -
   CreditCard" it appears correctly as shown below:
   But when I open same transaction from "Current Assets and select
   Edit>Open Subaccounts" it appears without a balance as shown below:
--
Best Regards,
Muhammad Bashir Al-Noimi
Skype+Telegram+GMail: mbnoimi
___
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] Negative assets!

2018-09-06 Thread Muhammad Bashir Al-Noimi
   On 09/06/2018 11:55 AM, Geert Janssens wrote:

Most transactions not showing a balance is odd.
Have you tried to run check & repair on your assets account and its children ?

   I did, nothing changed.
--
Best Regards,
Muhammad Bashir Al-Noimi
Skype+Telegram+GMail: mbnoimi
___
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] Negative assets!

2018-09-06 Thread Geert Janssens
Op donderdag 6 september 2018 10:47:56 CEST schreef Muhammad Bashir Al-Noimi:
>On 09/06/2018 05:37 AM, John Ralls wrote:
> 
>Well, make completely sure. With the accounts page open, select
>View>Filter By... and make sure that all of the account types are
>selected on the “Account Type" tab and that Show hidden accounts is
>selected on the “Other” tab. There’s another way to get there as well:
>You can select Current Assets and select Edit>Open Subaccounts, which
>will open a register showing all of the transactions from Current
>Assets and all of its sub accounts in the normal order. That might help
>you see the transactions that drive it to a negative balance.
> 
>I did that, I couldn't find any negative transactions (only a tiny one
>which I already know it). But I noticed most transactions don't reflect
>any balance while others did, does this related to my problem?
> 
>How much is the discrepancy? IOW, if you add up all of the (positive)
>totals showing in the first-level sub accounts and then add the
>opposite of the (negative) total showing in Current Assets, what’s the
>difference?
> 
>The discrepancy is big because when I calculate all my assets manually
>(multi-currencies) they did match the sub-accounts.
> 
>Are there any transactions in Current Assets? Being a placeholder
>prevents you from adding transactions from the register, but there are
>other ways that transactions can get into it, including being
>transferred there when you delete a sub-account. Double clicking on it
>won’t work because it’s a placeholder so you have to use Edit>Open
>Account or pick Open from the context menu when Current Assets is
>selected.
> 
>When I disabled "Placeholder" feature for "Current Assets" and "Assets"
>I found both of them are empty.
>THIS IS REALLY STRANGE I DID NOT FACE ANY PROBLEM WITH GNC BEFORE
>ALTHOUGH I USE IT SINCE YEARS AGO
>Thanks a lot John for the patience.

Most transactions not showing a balance is odd.
Have you tried to run check & repair on your assets account and its children ?

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] Old dates preferred to near future

2018-09-06 Thread Geert Janssens
Op donderdag 6 september 2018 10:29:58 CEST schreef Thomas Klausner:
> Hi!
> 
> Something changed in one of the last versions of gnucash (now using
> 3.2).
> 
> ISTR that when I type Oct 10, it would choose Oct 10 2018. Now it uses
> Oct 10 2017, which is almost never what I want.
> 
> Do I misremember?
> 
> If not, can I please have the old behaviour back, or at least
> something more like the old behaviour?

Perhaps you are experiencing a change in the Date completion settings.

Can you check Edit->Preferences->Date/Time->Date Completion and adjust to your 
preferences.

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] Negative assets!

2018-09-06 Thread Muhammad Bashir Al-Noimi
   On 09/06/2018 05:37 AM, John Ralls wrote:

   Well, make completely sure. With the accounts page open, select
   View>Filter By... and make sure that all of the account types are
   selected on the “Account Type" tab and that Show hidden accounts is
   selected on the “Other” tab. There’s another way to get there as well:
   You can select Current Assets and select Edit>Open Subaccounts, which
   will open a register showing all of the transactions from Current
   Assets and all of its sub accounts in the normal order. That might help
   you see the transactions that drive it to a negative balance.

   I did that, I couldn't find any negative transactions (only a tiny one
   which I already know it). But I noticed most transactions don't reflect
   any balance while others did, does this related to my problem?

   How much is the discrepancy? IOW, if you add up all of the (positive)
   totals showing in the first-level sub accounts and then add the
   opposite of the (negative) total showing in Current Assets, what’s the
   difference?

   The discrepancy is big because when I calculate all my assets manually
   (multi-currencies) they did match the sub-accounts.

   Are there any transactions in Current Assets? Being a placeholder
   prevents you from adding transactions from the register, but there are
   other ways that transactions can get into it, including being
   transferred there when you delete a sub-account. Double clicking on it
   won’t work because it’s a placeholder so you have to use Edit>Open
   Account or pick Open from the context menu when Current Assets is
   selected.

   When I disabled "Placeholder" feature for "Current Assets" and "Assets"
   I found both of them are empty.
   THIS IS REALLY STRANGE I DID NOT FACE ANY PROBLEM WITH GNC BEFORE
   ALTHOUGH I USE IT SINCE YEARS AGO
   Thanks a lot John for the patience.
--
Best Regards,
Muhammad Bashir Al-Noimi
Skype+Telegram+GMail: mbnoimi
___
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] Old dates preferred to near future

2018-09-06 Thread Thomas Klausner
Hi!

Something changed in one of the last versions of gnucash (now using
3.2).

ISTR that when I type Oct 10, it would choose Oct 10 2018. Now it uses
Oct 10 2017, which is almost never what I want.

Do I misremember?

If not, can I please have the old behaviour back, or at least
something more like the old behaviour?

Thanks,
 Thomas
___
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] [OT] Why is Debit abbreviated Dr?

2018-09-06 Thread Geoff Jankowski via gnucash-user
Happily

I am not married to my accountant!



Geoff Jankowski
+33 6 22 93 00 53
+44 7770 584838

iPhone 5SE

> On 5 Sep 2018, at 21:37, Stephen M. Butler  wrote:
> 
>> On 09/05/2018 12:05 PM, Christian Kluge wrote:
>>> Am 05.09.2018 um 20:42 schrieb Geoff Jankowski via gnucash-user:
>>> David
>>> 
>>> I would love to agree with you but…..
>>> 
>>> In standard journal notation cr is a debt and dr an asset.  This is because 
>>> it is nothing to do with credit (+ve) and debit (-ve) in any sense (or 
>>> tense) but to do with a creditor (to whom we owe) and a debtor (who owes 
>>> us).  Hence dr and cr relate to debtor and creditor and not to any form of 
>>> debit or credit.
>>> 
>>> For example, if I take cash from the cash box and deposit it at the bank I 
>>> enter a cr to the cashbook and a dr to the bank account. 
>> Actually you should a transit account for the period in between taking
>> and out of the cash box and that journal entry and the day the bank
>> actually books this deposit on your banking statement.
>> 
>>> Totally counterintuitive which is why accountancy is a black art and should 
>>> be banned.
>>> 
> 
> Which is why I, as a software/database guy, just cringe when my wife,
> the accountant, yells out, "You reversed the journal entries again!"
> 
> I tried to reason it out know I got it wrong last time by trying to
> reason it out from the time before when I also got it wrong.  I'm no
> longer sure that three rights make a left.  I'm pretty sure that two
> rights make a U turn of which I am doing a lot lately.
>> Every form of accounting assumes that the debit side will give its value
>> back one day as the original Italian formulations «deve dare» “shall
>> give“ and «deve avere» “shall have”, everyone knows that’s never going
>> to happen but still, nothing counterintuitive there.
>> 
>> Kind regards
>> 
>> 
>> Christian Kluge
>> 
>> ___
>> 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.
> 
> 
> -- 
> Stephen M Butler, PMP, PSM
> stephen.m.butle...@gmail.com
> kg...@arrl.net
> 253-350-0166
> ---
> GnuPG Fingerprint:  8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8
> 
> ___
> 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] Currency exchange rates retrieval with GC 3.2

2018-09-06 Thread Manfred Usselmann
 

Hi, 

I'm using GnuCash 3.2 with Finance::Quote 1.47 on Ubuntu 18.04. 

When trying to download currency exchange rates this fails with "Unknown
error". 

I've registered an ALPHAVANTAGE_API_KEY and entered it on the settings
screen. 

Some tests from the command line: 

$ GNC-FQ-DUMP -V ALPHAVANTAGE CHFEUR=X
Finance::Quote fields Gnucash uses:
symbol: CHFEUR=X <=== required
date: 09/06/2018 <=== recommended
currency: USD <=== required
last: 0.8842 <=\ 
nav: <=== one of these
price: <=/ 
timezone: <=== optional 

All fields returned by Finance::Quote for stock CHFEUR=X 

stock field value
- - -
CHFEUR=X close: 0.8842
CHFEUR=X currency: USD
CHFEUR=X currency_set_by_fq: 1
CHFEUR=X date: 09/06/2018
CHFEUR=X high: 0.8847
CHFEUR=X isodate: 2018-09-06
CHFEUR=X last: 0.8842
CHFEUR=X low: 0.8840
CHFEUR=X method: alphavantage
CHFEUR=X open: 0.8845
CHFEUR=X success: 1
CHFEUR=X symbol: CHFEUR=X
CHFEUR=X volume: 0 

$ ECHO '(ALPHAVANTAGE "CSCO")' | GNC-FQ-HELPER
(("CSCO" (symbol . "CSCO") (gnc:time-no-zone . "2018-09-05 12:00:00")
(last . 47.2700) (currency . "USD"))) 

Thanks and regards,
Manfred 

-- 
 Manfred Usselmann 

 
___
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] compiling 3.2 stops at core-utils.go ( non-urgent -- can use debian package 2.6.15-1

2018-09-06 Thread David Cousens
John

With the commands you used, you created a source directory gnucash with parent 
directory moresource, but you did not
create a build directory and you ran cmake in the source directory gnucash not 
in a separate build directory. cmake
requires an empty build directory. It can either be a child of moresource or of 
the source directory gnucash. This works
for compiling the program (but if you were compiling the documentation it would 
have to be a child of moresource because
of a dependency problem with the documentation sources).

The commands you need are:

cd /moresource
git clone https://github.com/Gnucash/gnucash.git gnucash
mkdir build-gnucash
cd build-gnucash
cmake -D CMAKE_INSTALL_PREFIX=$HOME/.local /moresource/gnucash
make
make install

This will create build as a child of moresource, put the build files in the 
build directory and then install to
$HOME/.local.

To uninstall from $HOME/.local (assuming you don't change the build directory 
after installing (make uses a file
install.manifest created in the build directory, build-gnucash to uninstall) 
open a shell, then type. 

cd /moresource/build-gnucash
make uninstall

Hope this makes it a bit clearer

David

On Tue, 2018-09-04 at 11:12 -0500, John Griessen wrote:
> On 09/02/2018 10:40 AM, Colin Law wrote:
> > Don't try and install to the source or build directory, if that is
> > what you are trying to do.
> 
> No, they were not the same dir.  This is not urgent now, but a mystery.
> I have started using 2.6.15-1 gnucash successfully, so not urgent.
> 
> Today I also tried from scratch from git and same result almost:
> 
> cd /moresource
> git clone https://github.com/Gnucash/gnucash.git gnucash
> git checkout -b gnucash3.2 3.2
> cmake -D CMAKE_INSTALL_PREFIX=$HOME/.local /moresource/gnucash
> make
> 
> 
> .
> .
> .
> [ 28%] Building C object 
> libgnucash/app-utils/CMakeFiles/gncmod-app-utils.dir/guile-util.c.o
> [ 28%] Building C object 
> libgnucash/app-utils/CMakeFiles/gncmod-app-utils.dir/option-util.c.o
> [ 28%] Building C object 
> libgnucash/app-utils/CMakeFiles/gncmod-app-utils.dir/swig-app-utils-guile.c.o
> [ 28%] Linking C shared library ../../lib/gnucash/libgncmod-app-utils.so
> [ 28%] Built target gncmod-app-utils
> Scanning dependencies of target swig-app-utils-python
> [ 28%] Generating swig-app-utils-python.c, sw_app_utils.py
> [ 28%] Built target swig-app-utils-python
> Scanning dependencies of target scm-gnc-module
> [ 28%] Generating ../../lib/gnucash/scm/ccache/2.2/gnucash/gnc-module.go
> wrote 
> `/mosource/gnucash/build/lib/gnucash/scm/ccache/2.2/gnucash/gnc-module.go'
> [ 28%] Built target scm-gnc-module
> Scanning dependencies of target scm-core-utils
> [ 28%] Generating ../../lib/gnucash/scm/ccache/2.2/gnucash/core-utils.go
> Backtrace:
> In /usr/bin/guild:
>  72:17 19 (main _)
> In srfi/srfi-1.scm:
>  640:9 18 (for-each # …)
> In scripts/compile.scm:
> 259:26 17 (_ _)
> In system/base/target.scm:
>   57:6 16 (with-target _ _)
> In system/base/compile.scm:
>  152:6 15 (compile-file _ #:output-file _ #:from _ #:to _ #:env _ …)
>   43:4 14 (call-once _)
> In ice-9/boot-9.scm:
>  841:4 13 (with-throw-handler _ _ _)
> In system/base/compile.scm:
>  59:11 12 (_)
> 155:11 11 (_ #)
> 235:18 10 (read-and-compile # #:from _ # …)
> 183:32  9 (compile-fold (#) …)
> In ice-9/boot-9.scm:
> 2312:4  8 (save-module-excursion #)
> In language/scheme/compile-tree-il.scm:
>  31:15  7 (_)
> In ice-9/psyntax.scm:
>1235:36  6 (expand-top-sequence ((re-export #)) _ _ #f c (# load …) …)
>1182:24  5 (parse _ (("placeholder" placeholder)) ((top) #(# # …)) …)
> 285:10  4 (parse _ (("placeholder" placeholder)) (()) _ c (# #) #)
> In ice-9/boot-9.scm:
>2071:24  3 (call-with-deferred-observers #)
> 260:13  2 (for-each # …)
> In unknown file:
> 1 (scm-error misc-error #f "~A ~S" ("Undefined variab…" …) …)
> In ice-9/boot-9.scm:
> 752:25  0 (dispatch-exception _ _ _)
> 
> ice-9/boot-9.scm:752:25: In procedure dispatch-exception:
> Undefined variable: gnc-build-userdata-path
> make[2]: *** 
> [libgnucash/core-utils/CMakeFiles/scm-core-utils.dir/build.make:62:
> lib/gnucash/scm/ccache/2.2/gnucash/core-utils.go] 
> Error 1
> make[1]: *** [CMakeFiles/Makefile2:4053: 
> libgnucash/core-utils/CMakeFiles/scm-core-utils.dir/all] Error 2
> make: *** [Makefile:163: all] Error 2
> 
> ___
> 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