Re: [GNC] Posting sales in multiple currencies (2.6.21)

[Adrien Monteleone]

Good point, I didn’t think of that. And as Geert described, GC is designed to 
use separate A/R (and presumably A/P) for each currency and likely for that 
very reason among others.

Regards,
Adrien

> On Jun 2, 2018, at 11:40 PM, Matthew Pounsett  wrote:
> 
> 
> On Sat, Jun 2, 2018 at 00:14 Adrien Monteleone 
>  wrote:
> Just out of curiosity, can you not post a CAD invoice to an A/R account that 
> is set for USD?
> 
> I would have thought that GnuCash would have done the conversions for you.
> 
> I don’t think you would actually want to do this. The delay between posting 
> the invoice and receiving a payment leaves a huge potoetmtial for discrepancy 
> between any conversion done at post time and the conversion done at the time 
> of deposit. 
> 
> I have several A/R accounts now, but wires from my clients all go into an 
> account in my home currency.. so when I do the payment I just enter the 
> conversion rate that my bank gave me at deposit time and it all balances out 
> without having to go back and correct anything after the fact.  
> 
> 
> 
> Thankfully, I don’t have that problem (yet) but my first inclination would be 
> to do just that: maintain MY A/R account in my home currency but invoice 
> customers in their home currency. I don’t see why it would be any different 
> than any other transaction posted into an account with a different currency 
> default. Perhaps I’m misunderstanding something.
> 
> But if you can do as I suppose, you could eliminate the complication of extra 
> accounts and the placeholder issue and just use the A/R account as normal. 
> (save for the conversions done for foreign billing and the conversion on 
> several reports)
> 
> Regards,
> Adrien
> 
> > On Jun 1, 2018, at 8:39 AM, Matthew Pounsett  wrote:
> > 
> > A short aside.. I think there may still be a bug here.
> > 
> > Even though Assets:Accounts Receivable is set to Placeholder, it gets
> > offered as a choice for posting to when I'm posting an invoice... only when
> > I try to post to it I get an error that I'm trying to post to a placeholder
> > account.  It should probably be excluded from the list of choices.
> > 
> > I'll add that to the bugtracker.
> > ___
> > 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] Profit and Loss Spreadsheet

[Adrien Monteleone]

John,

I’ll have to interpret a bit, but my guess is you want a report that shows 
multiple months worth of P data, consolidated with each month in it’s own 
column. (and maybe even a YTD or QTD column at the end)

There is no such report.

You can run a multi-column report and put each column as a different month’s 
P, but that will repeat the account name header column.

More than likely, you’ll need to either export and import, or copy/paste 
individual months into a spreadsheet and work from there. (a simple select-all, 
copy/paste is usually sufficient)

Regards,
Adrien

> On Jun 2, 2018, at 10:51 AM, John  wrote:
> 
> Hi.
> 
> I have been looking through the report options and help files and I am unable 
> to work out how to create a month by month profit and loss spreadsheet. Is 
> this possible? and if so, do I need to download and install a plugin of some 
> kind.
> 
> Many thanks, John
> 
> ---
> John Robins
> 
> 
> 
> ___
> 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] Posting sales in multiple currencies (2.6.21)

[Matthew Pounsett]

On Sat, Jun 2, 2018 at 00:14 Adrien Monteleone <
adrien.montele...@lusfiber.net> wrote:

> Just out of curiosity, can you not post a CAD invoice to an A/R account
> that is set for USD?
>
> I would have thought that GnuCash would have done the conversions for you.


I don’t think you would actually want to do this. The delay between posting
the invoice and receiving a payment leaves a huge potoetmtial for
discrepancy between any conversion done at post time and the conversion
done at the time of deposit.

I have several A/R accounts now, but wires from my clients all go into an
account in my home currency.. so when I do the payment I just enter the
conversion rate that my bank gave me at deposit time and it all balances
out without having to go back and correct anything after the fact.


>
> Thankfully, I don’t have that problem (yet) but my first inclination would
> be to do just that: maintain MY A/R account in my home currency but invoice
> customers in their home currency. I don’t see why it would be any different
> than any other transaction posted into an account with a different currency
> default. Perhaps I’m misunderstanding something.
>
> But if you can do as I suppose, you could eliminate the complication of
> extra accounts and the placeholder issue and just use the A/R account as
> normal. (save for the conversions done for foreign billing and the
> conversion on several reports)
>
> Regards,
> Adrien
>
> > On Jun 1, 2018, at 8:39 AM, Matthew Pounsett  wrote:
> >
> > A short aside.. I think there may still be a bug here.
> >
> > Even though Assets:Accounts Receivable is set to Placeholder, it gets
> > offered as a choice for posting to when I'm posting an invoice... only
> when
> > I try to post to it I get an error that I'm trying to post to a
> placeholder
> > account.  It should probably be excluded from the list of choices.
> >
> > I'll add that to the bugtracker.
> > ___
> > 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.

[GNC] Profit and Loss Spreadsheet

[John]

Hi.

I have been looking through the report options and help files and I am 
unable to work out how to create a month by month profit and loss 
spreadsheet. Is this possible? and if so, do I need to download and 
install a plugin of some kind.


Many thanks, John

---
John Robins



___
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] Custom invoices don't work after upgrade

[Christopher Lam]

try

Sent from Mail for Windows 10

From: Jordan and Reidun Staudinger
Sent: Saturday, 2 June 2018 11:17 PM
To: Christopher Lam
Subject: Re: [GNC] Custom invoices don't work after upgrade

Thanks for your help with this, I really appreciate it. The new one you sent 
back gives a different error:

An error occurred when processing the template:
ERROR: In procedure car: Wrong type (expecting pair): 
#
In ice-9/eval.scm:
 432: 8 [eval # #]
 432: 7 [eval # #]
 436: 6 [eval # #]
In unknown file:
   ?: 5 [sort-list (# #) #]
In ice-9/eval.scm:
 387: 4 [eval # #]
In unknown file:
   ?: 3 [car #]


Something in the invoice needs to be tweaked a bit, I'm guessing.

Thanks again,
Reidun
On 06/01/2018 08:43 PM, Christopher Lam wrote:
Try this one... unfortunately most of the report uses eguile which I can't 
understand.
The Gnucash API does change from time to time and usually it'd best to ask the 
report creator for an update.

On 2 June 2018 at 07:33, Jordan and Reidun Staudinger 
 wrote:
Here they are. Thanks!

On 06/01/2018 05:11 PM, Christopher Lam wrote:
Could you send these customised invoices as an attachment?

On Sat, 2 Jun 2018, 02:34 Jordan and Reidun Staudinger 
 wrote:
Hi, I have had some pretty decent looking custom invoices set up in 
GnuCash for a few years now, and I've been quite happy with them. 
However, after the last update, I now get the following message when I 
try to load one of the saved invoice reports:


            An error occurred when processing the template:

            ERROR: Unbound variable: qof-book-get-slots
            In ice-9/eval.scm:
              432: 7 [eval # #]
              411: 6 [eval # #]
              386: 5 [eval #)> (() # # # ...)]
              393: 4 [eval # (() # # # ...)]
            In unknown file:
                ?: 3 [memoize-variable-access! # #]


In order to get the invoices working previously, I had to put custom 
.css and .scm files in the 
/usr/share/gnucash/guile-modules/gnucash/report/ folder, which I now see 
no longer exists. So I did some poking around, and found that the files 
are now in /usr/share/gnucash/scm/gnucash/report/. They were already 
there without me adding them. Not sure if this is the reason for the 
error or not.

Any help would be greatly appreciated, as this is preventing me from 
sending invoices to my customers.

Thanks much, Reidun



-- 
BEGIN-ANTISPAM-VOTING-LINKS
--

Teach CanIt if this mail (ID 01VRuwM0D) is spam:
Spam:        
Not spam:    
Forget vote: 
--
END-ANTISPAM-VOTING-LINKS

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









Spam
Not spam
Forget previous vote



GBM Invoice.eguile.scm
Description: Binary data
___
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] Add Price Quotes

[Robin Chattopadhyay]

Hi-

Using GC 3.1 with SQLite backend on Linux Mint 18.3...

When running "gnucash --add-price-quotes ~/Documents/file.gnucash", the
prices are loaded but the process doesn't appear to terminate.

The trace file doesn't having anything other than MESSG or INFO entries.

I only notice because I'm getting the lock message when I start gnucash for
regular data entry.

Thoughts on what's going on?

Thanks,
Robin
___
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] Downloading transaction using AQBanking - fails after upgrade.

[John Ralls]

I haven’t had any trouble using AQBanking with 3.1 on MacOS, but I download 
only bank information, no stocks.

If it’s hanging you can find the process in Applications:Utilities:Activity 
Monitor and then click the little gear at the top left and pick “sample 
process” to see what it’s up to.

Regards,
John Ralls

> On Jun 2, 2018, at 8:20 AM, Alun Champion  wrote:
> 
> System: MacOS High Sierra
> 
> In addition, it does seem as the install of 3.1 (in a separate location)
> has also broken the AQBanking in 2.6 (as in nothing appears when either
> clicking on the Actions -> Online Actions -> Get Transactions or even when
> click Tools -> Online Banking Setup...).
> Any idea how to fix that if I can't fix 3.1?
> 
>   -A.
> 
> 
> On 2 June 2018 at 08:05, Alun Champion  wrote:
> 
>> System: MacOS
>> Version: 3.1
>> 
>> This is working fine in 2.6.21 but after upgrade it causes gnucash to lock
>> up and max out the cpu.
>> 
>> Observed behaviour is from the connection window it connects successfully
>> and looks like it completes getting the data from the server and then locks
>> up. I assume this means that in trying to launch the transaction matching
>> window something is going wrong.
>> 
>> Anyone successfully managed to import transactions through AQBanking?
>> 
>>   -Alun.
>> 
>> 
>> 
>> 
> ___
> 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] AlphaVantage Stock Quotes

[John Ralls]

From https://www.alphavantage.co/documentation/ 
: 
"The batch stock quotes API enables the querying of multiple stock quotes with 
a single API request, updated realtime. It may serve as a lightweight 
alternative to our core stock time series APIs above (which have richer content 
but are symbol-specific).

“Given the specifications of our data provider (IEX), we currently only offer 
US stock quotes during US market hours through this API. If you would like to 
query international stocks, ETFs, and mutual funds traded on major global 
exchanges, please refer to our core stock time series APIs”

The documentation might be wrong or Erik and I might be misinterpreting it, but 
IIUC that’s what he’s relying on.

Regards,
John Ralls

> On Jun 2, 2018, at 8:40 AM, Alun Champion  wrote:
> 
> Hmm, that has not been my observation but I'm sure there are some nuances, 
> for me it shows the last price during the trading day (as in it doesn't show 
> after market prices) but the call can happen any time, e.g. here is the demo 
> linl: 
> https://www.alphavantage.co/query?function=BATCH_STOCK_QUOTES=MSFT,FB,AAPL=demo
>  
> 
>  and it shows MSFT, FB as of 16:01 yesterday. This is the same when I use my 
> API Key.
>-A.
> 
> On 2 June 2018 at 10:21, John Ralls  > wrote:
> It’s only live when that particular issue is trading; e.g. for a US stock 
> between 0930 and 1600 Eastern Time. That makes it unsuitable for F::Q.
> 
> Regards,
> John Ralls
> 
> 
> > On Jun 2, 2018, at 6:12 AM, Alun Champion  > > wrote:
> > 
> > Alphavantage does provide a batch stock api, which you only sends the
> > latest quote, you can send just one stock to that api call e.g. (
> > https://www.alphavantage.co/query?function=BATCH_STOCK_QUOTES=MSFT=
> >  
> > ),
> > which only returns the latest value.
> >-A.
> > 
> > On 31 May 2018 at 20:12, prl  > > wrote:
> > 
> >> On 31/05/2018 12:59, Dave Tapuska wrote:
> >> 
>  From the gnucash point of view it only uses the latest quote so even
> >>> returning the compact list (which is the last 100 days) is far overkill.
> >>> Perhaps a lighter weight request returning the last closing value would be
> >>> sufficient.
> >>> 
> >> That would be ideal, but as far as I can see, the compact list (last 100
> >> days) is the smallest amount of data that can be requested using the
> >> TIME_SERIES_DAILY function in the AlphaVantage API <
> >> https://www.alphavantage.co/documentation/ 
> >> >. The only alternative in the
> >> documentation is full, which returns daily opening and closing prices for
> >> up to the last 20 years.
> >> 
> >> Peter
> >> 
> >> 
> >> ___
> >> 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.

[GNC] Cash Flow report

[Martijn Heuts]

Hello,
I have the new version of GNU.
When I look at the options for the build-in 'cash flow' report,there is the 
option to turn "Always show sub-accounts" on and off.
When I turn the option off, the total 'money in' amount is differentas when 
it's on, even though the same accounts are checked.
When the option is checked, the report automatically includes these 
accounts:Assets
Assets:Accounts ReceivableAssets:Checking AccountAssets:Checking 
AccountAssets:Current Assets and subaccountsAssets:Current Assets and 
subaccountsImbalance-USDOrphan-USD
When it's not checked, the report automatically includes these accounts:Assets
Assets:Checking AccountAssets:Current Assets and selected 
subaccountsImbalance-USDOrphan-USD
I am not sure why it shows 'Assets:checking account' and 'Assets and sub 
accounts' twice
I made sure I didn't have Accounts Receivable highlighted/selected before 
generating the report, yet it shows up in the report when I turn "always show 
sub-accounts".
So leaves me with two questions:1. Is this a bug/error in the software? 
2. Should accounts receivable be included if i want to know how much money my 
business brought in?
Thanks and have a great day and weekend!
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] Profit and Loss Spreadsheet

[John Robins]

Hi.

I have been looking through the report options and help files and I am 
unable to work out how to create a month by month profit and loss 
spreadsheet. Is this possible? and if so, do I need to download and 
install a plugin of some kind.


Many thanks, John
---
John Robins
___
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] AlphaVantage Stock Quotes

[Alun Champion]

Hmm, that has not been my observation but I'm sure there are some nuances,
for me it shows the last price during the trading day (as in it doesn't
show after market prices) but the call can happen any time, e.g. here is
the demo linl:
https://www.alphavantage.co/query?function=BATCH_STOCK_QUOTES=MSFT,FB,AAPL=demo
and it shows MSFT, FB as of 16:01 yesterday. This is the same when I use my
API Key.
   -A.

On 2 June 2018 at 10:21, John Ralls  wrote:

> It’s only live when that particular issue is trading; e.g. for a US stock
> between 0930 and 1600 Eastern Time. That makes it unsuitable for F::Q.
>
> Regards,
> John Ralls
>
>
> > On Jun 2, 2018, at 6:12 AM, Alun Champion  wrote:
> >
> > Alphavantage does provide a batch stock api, which you only sends the
> > latest quote, you can send just one stock to that api call e.g. (
> > https://www.alphavantage.co/query?function=BATCH_STOCK_
> QUOTES=MSFT=),
> > which only returns the latest value.
> >-A.
> >
> > On 31 May 2018 at 20:12, prl  wrote:
> >
> >> On 31/05/2018 12:59, Dave Tapuska wrote:
> >>
>  From the gnucash point of view it only uses the latest quote so even
> >>> returning the compact list (which is the last 100 days) is far
> overkill.
> >>> Perhaps a lighter weight request returning the last closing value
> would be
> >>> sufficient.
> >>>
> >> That would be ideal, but as far as I can see, the compact list (last 100
> >> days) is the smallest amount of data that can be requested using the
> >> TIME_SERIES_DAILY function in the AlphaVantage API <
> >> https://www.alphavantage.co/documentation/>. The only alternative in
> the
> >> documentation is full, which returns daily opening and closing prices
> for
> >> up to the last 20 years.
> >>
> >> Peter
> >>
> >>
> >> ___
> >> 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] AlphaVantage Stock Quotes

[John Ralls]

It’s only live when that particular issue is trading; e.g. for a US stock 
between 0930 and 1600 Eastern Time. That makes it unsuitable for F::Q.

Regards,
John Ralls


> On Jun 2, 2018, at 6:12 AM, Alun Champion  wrote:
> 
> Alphavantage does provide a batch stock api, which you only sends the
> latest quote, you can send just one stock to that api call e.g. (
> https://www.alphavantage.co/query?function=BATCH_STOCK_QUOTES=MSFT=),
> which only returns the latest value.
>-A.
> 
> On 31 May 2018 at 20:12, prl  wrote:
> 
>> On 31/05/2018 12:59, Dave Tapuska wrote:
>> 
 From the gnucash point of view it only uses the latest quote so even
>>> returning the compact list (which is the last 100 days) is far overkill.
>>> Perhaps a lighter weight request returning the last closing value would be
>>> sufficient.
>>> 
>> That would be ideal, but as far as I can see, the compact list (last 100
>> days) is the smallest amount of data that can be requested using the
>> TIME_SERIES_DAILY function in the AlphaVantage API <
>> https://www.alphavantage.co/documentation/>. The only alternative in the
>> documentation is full, which returns daily opening and closing prices for
>> up to the last 20 years.
>> 
>> Peter
>> 
>> 
>> ___
>> 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] latest gnucash release (3.1) feedback

[Alun Champion]

I'm using a custom date.
And flipping back between 2.6.21 and 3.1 that date is lost (in both
directions).
   -A.

On 2 June 2018 at 09:36, Adrien Monteleone 
wrote:

> Nice find.
>
> On the report start date issue, are you using a specific custom date or
> one of the presets?
>
> Mine are all set to ’start of accounting period’ and my book’s accounting
> period is set to ’start of current year’. I’m not seeing any loss of start
> dates.
>
> Perhaps some other date setting is where the issue lies.
>
> Regards,
> Adrien
>
> > On Jun 2, 2018, at 7:29 AM, Alun Champion  wrote:
> >
> > Thank you all, this gave me enough information to track down and create
> > custom styling, having the tabs down the left side meant all the top and
> > bottom margin and padding was just wasted space.
> >
> > Note: One minor issue I found when switching between 2.6.21 and 3.1 is
> that
> > any open reports seems to lose the start date, no idea why.
> >
> > I’m on a Mac, was able to run the gtk3 inspector by running
> > GTK_DEBUG=interactive
> > /Applications/Gnucash.app/Contents/MacOS/Gnucash from the command line,
> > which shows the various css nodes (and you can experiment with the
> > styling). And created a ~/Library/Application\
> Support/Gnucash/gtk-3.0.css
> > for tight tabs:
> >
> > notebook tab {
> >  min-height: 0px;
> >  margin-top: 0px;
> >  margin-bottom: 0px;
> >  padding-left: 0px;
> >  padding-right: 0px;
> > }
> >
> > notebook tab box {
> >  padding-top: 2px;
> >  padding-bottom: 2px;
> > }
> >
> > I was also able to change the colors in the reports by changing the
> > base_colors in
> > /Applications/Gnucash.app/Contents/Resources/share/
> gnucash/scm/html-utilities.scm
> > .
> > ​
> >
> > On 30 May 2018 at 07:07, Mike Evans  wrote:
> >
> >> On Wed, 30 May 2018 10:00:56 +0100
> >> Mike Evans  wrote:
> >>
> >>> On Wed, 30 May 2018 00:12:00 -0500
> >>> Alun Champion  wrote:
> >>>
>  MacOS High Sierra, Gnucash 3.1-3.
> 
>  If anyone finds a way for reducing the padding around the tabs (left),
> >> I
>  would be very interested. 3.1 uses almost twice as much space as
> >> 2.6.X. I
>  keep a number of tabs open (reports, accounts, registers, etc.) and
> >> this
>  comfortably fits on the screen now in 3.1 this forces scrolling. The
> >> arrows
>  to scroll up and down are particularly slow and with also losing the
>  ability to scroll the tabs then this becomes very awkward.
>  Also it seems the stylesheets aren't working - or at a minimum there
> >> are no
>  color changes between the stylesheets and the new colours are quite
> >> 'prime'.
>  Changing settings also seems to be very slow, with quite a lag between
>  selecting an option and for the tick to appear or disappear.
> 
>  I guess I will need to figure out how to change the styles - colours
> >> and
>  fonts - default fonts for 2.6.X worked fine for me but the new fonts
> >> are
>  too spidery.
> 
>  But still a fantastic piece of software - thank you all for such great
> >> work.
> -A.
> 
> >>>
> >>> There's a theme here that helps a little.
> >>> https://www.gnome-look.org/p/1179399/
> >>>
> >> I went with Adwaita-Slim https://www.gnome-look.org/p/1181146/ after a
> >> little testing.
> >>
> >> If you want even narrower notebook tabs, edit
> >>
> >> ~/.themes/Adwaita Slim/gtk-3.0/gtk.css
> >>
> >> Search for "tabs" or "notebook"
> >>
> >> Mike E
> >>
> > ___
> > 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] latest gnucash release (3.1) feedback

[Adrien Monteleone]

Nice find.

On the report start date issue, are you using a specific custom date or one of 
the presets?

Mine are all set to ’start of accounting period’ and my book’s accounting 
period is set to ’start of current year’. I’m not seeing any loss of start 
dates.

Perhaps some other date setting is where the issue lies.

Regards,
Adrien

> On Jun 2, 2018, at 7:29 AM, Alun Champion  wrote:
> 
> Thank you all, this gave me enough information to track down and create
> custom styling, having the tabs down the left side meant all the top and
> bottom margin and padding was just wasted space.
> 
> Note: One minor issue I found when switching between 2.6.21 and 3.1 is that
> any open reports seems to lose the start date, no idea why.
> 
> I’m on a Mac, was able to run the gtk3 inspector by running
> GTK_DEBUG=interactive
> /Applications/Gnucash.app/Contents/MacOS/Gnucash from the command line,
> which shows the various css nodes (and you can experiment with the
> styling). And created a ~/Library/Application\ Support/Gnucash/gtk-3.0.css
> for tight tabs:
> 
> notebook tab {
>  min-height: 0px;
>  margin-top: 0px;
>  margin-bottom: 0px;
>  padding-left: 0px;
>  padding-right: 0px;
> }
> 
> notebook tab box {
>  padding-top: 2px;
>  padding-bottom: 2px;
> }
> 
> I was also able to change the colors in the reports by changing the
> base_colors in
> /Applications/Gnucash.app/Contents/Resources/share/gnucash/scm/html-utilities.scm
> .
> ​
> 
> On 30 May 2018 at 07:07, Mike Evans  wrote:
> 
>> On Wed, 30 May 2018 10:00:56 +0100
>> Mike Evans  wrote:
>> 
>>> On Wed, 30 May 2018 00:12:00 -0500
>>> Alun Champion  wrote:
>>> 
 MacOS High Sierra, Gnucash 3.1-3.
 
 If anyone finds a way for reducing the padding around the tabs (left),
>> I
 would be very interested. 3.1 uses almost twice as much space as
>> 2.6.X. I
 keep a number of tabs open (reports, accounts, registers, etc.) and
>> this
 comfortably fits on the screen now in 3.1 this forces scrolling. The
>> arrows
 to scroll up and down are particularly slow and with also losing the
 ability to scroll the tabs then this becomes very awkward.
 Also it seems the stylesheets aren't working - or at a minimum there
>> are no
 color changes between the stylesheets and the new colours are quite
>> 'prime'.
 Changing settings also seems to be very slow, with quite a lag between
 selecting an option and for the tick to appear or disappear.
 
 I guess I will need to figure out how to change the styles - colours
>> and
 fonts - default fonts for 2.6.X worked fine for me but the new fonts
>> are
 too spidery.
 
 But still a fantastic piece of software - thank you all for such great
>> work.
-A.
 
>>> 
>>> There's a theme here that helps a little.
>>> https://www.gnome-look.org/p/1179399/
>>> 
>> I went with Adwaita-Slim https://www.gnome-look.org/p/1181146/ after a
>> little testing.
>> 
>> If you want even narrower notebook tabs, edit
>> 
>> ~/.themes/Adwaita Slim/gtk-3.0/gtk.css
>> 
>> Search for "tabs" or "notebook"
>> 
>> Mike E
>> 
> ___
> 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] AlphaVantage Stock Quotes

[Alun Champion]

Alphavantage does provide a batch stock api, which you only sends the
latest quote, you can send just one stock to that api call e.g. (
https://www.alphavantage.co/query?function=BATCH_STOCK_QUOTES=MSFT=),
which only returns the latest value.
-A.

On 31 May 2018 at 20:12, prl  wrote:

> On 31/05/2018 12:59, Dave Tapuska wrote:
>
>> >From the gnucash point of view it only uses the latest quote so even
>> returning the compact list (which is the last 100 days) is far overkill.
>> Perhaps a lighter weight request returning the last closing value would be
>> sufficient.
>>
> That would be ideal, but as far as I can see, the compact list (last 100
> days) is the smallest amount of data that can be requested using the
> TIME_SERIES_DAILY function in the AlphaVantage API <
> https://www.alphavantage.co/documentation/>. The only alternative in the
> documentation is full, which returns daily opening and closing prices for
> up to the last 20 years.
>
> Peter
>
>
> ___
> 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] latest gnucash release (3.1) feedback

[Alun Champion]

Thank you all, this gave me enough information to track down and create
custom styling, having the tabs down the left side meant all the top and
bottom margin and padding was just wasted space.

Note: One minor issue I found when switching between 2.6.21 and 3.1 is that
any open reports seems to lose the start date, no idea why.

I’m on a Mac, was able to run the gtk3 inspector by running
GTK_DEBUG=interactive
/Applications/Gnucash.app/Contents/MacOS/Gnucash from the command line,
which shows the various css nodes (and you can experiment with the
styling). And created a ~/Library/Application\ Support/Gnucash/gtk-3.0.css
for tight tabs:

notebook tab {
  min-height: 0px;
  margin-top: 0px;
  margin-bottom: 0px;
  padding-left: 0px;
  padding-right: 0px;
}

notebook tab box {
  padding-top: 2px;
  padding-bottom: 2px;
}

I was also able to change the colors in the reports by changing the
base_colors in
/Applications/Gnucash.app/Contents/Resources/share/gnucash/scm/html-utilities.scm
.
​

On 30 May 2018 at 07:07, Mike Evans  wrote:

> On Wed, 30 May 2018 10:00:56 +0100
> Mike Evans  wrote:
>
> > On Wed, 30 May 2018 00:12:00 -0500
> > Alun Champion  wrote:
> >
> > > MacOS High Sierra, Gnucash 3.1-3.
> > >
> > > If anyone finds a way for reducing the padding around the tabs (left),
> I
> > > would be very interested. 3.1 uses almost twice as much space as
> 2.6.X. I
> > > keep a number of tabs open (reports, accounts, registers, etc.) and
> this
> > > comfortably fits on the screen now in 3.1 this forces scrolling. The
> arrows
> > > to scroll up and down are particularly slow and with also losing the
> > > ability to scroll the tabs then this becomes very awkward.
> > > Also it seems the stylesheets aren't working - or at a minimum there
> are no
> > > color changes between the stylesheets and the new colours are quite
> 'prime'.
> > > Changing settings also seems to be very slow, with quite a lag between
> > > selecting an option and for the tick to appear or disappear.
> > >
> > > I guess I will need to figure out how to change the styles - colours
> and
> > > fonts - default fonts for 2.6.X worked fine for me but the new fonts
> are
> > > too spidery.
> > >
> > > But still a fantastic piece of software - thank you all for such great
> work.
> > > -A.
> > >
> >
> > There's a theme here that helps a little.
> > https://www.gnome-look.org/p/1179399/
> >
> I went with Adwaita-Slim https://www.gnome-look.org/p/1181146/ after a
> little testing.
>
> If you want even narrower notebook tabs, edit
>
> ~/.themes/Adwaita Slim/gtk-3.0/gtk.css
>
> Search for "tabs" or "notebook"
>
> Mike E
>
___
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] Custom invoices don't work after upgrade

[Geert Janssens]

Op zaterdag 2 juni 2018 06:18:54 CEST schreef Adrien Monteleone:
> Just an FYI, the “qof-” ’interface’ will be phased out as development
> progresses on moving to a proper db based application, so I wouldn’t rely
> on it if at all possible. That particular variable/function very well might
> be a now deprecated part of the API. See the roadmap article on the wiki
> for more info.

That will probably still take a while.

What has been removed here specifically is the ability to access kvp frames 
and slot directly. Kvp slots are an implementation detail of the backends and 
should never have been exposed in the first place. All known uses of
qof-book-get-slots and related functions should have a higher level 
alternative access function.

Unfortunately the error message doesn't show exactly which slot your invoice 
report was trying to access, so I can't readily tell what the replacement 
function should be.

Considering the issue happens in an invoice report I suspect the report is 
trying to access company information or fancy date info. I haven't seen your 
original report (it looks like you sent it directly to Chris), but I expect 
that's what he replaced in his updated report.

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] Posting sales in multiple currencies (2.6.21)

[Geert Janssens]

Op zaterdag 2 juni 2018 06:13:40 CEST schreef Adrien Monteleone:
> Just out of curiosity, can you not post a CAD invoice to an A/R account that
> is set for USD?
> 

No. Gnucash was designed to require a different A/R account per currency. The 
invoices will be posted and printed in the customer's currency. Gnucash will 
do conversions between that currency and any entry/tax account's currency and 
between the customer's currency and any payment transfer account's currency.

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.