Re: [GNC] Saving to MySQL 8.0.36

[Cam Ellison]

Ira, there's not enough information in what you have posted to assist in 
getting your problem solved.


What does "Saving to Windows on local network does not work" mean? What 
actually happens? What error message is generated?


Is there one MySQL database or two? If there is one, on which machine is 
it: the Mac, the Windows machine, or something else?


As far as I can tell, there are no current problems involving both 
GnuCash 5.1 and MySQL. At a guess, there's a library missing, or the 
link is not specified correctly.



On 2024-02-29 14:40, Tommy Trussell wrote:

Hi -- you replied to me yesterday but I don't know if version 5.1 is
significant so I am copying the list. Be sure to use REPLY ALL or CC the
list on all your replies.

You might also try saving as sqlite because I know that database format is
used by more folks (though I don't use it).

On Wed, Feb 28, 2024 at 9:14 PM Ira Fuchs  wrote:


Software came from gnucash.org and is Version: 5.1
Build ID: 5.1+(2023-04-30)

To reiterate, saving to MySQl instnace on the MAc (same machien running
Gnucash) works fine. Saving to Windows on local network does not work.

On Feb 28, 2024, at 9:28 PM, Tommy Trussell 
wrote:

On Wed, Feb 28, 2024 at 8:02 PM Ira Fuchs  wrote:


I am trying to save my Gbucash data to MySQl v8.0.36 on a newly installed
MySQL instance on WIndwos 10. Gnucash is running on a Mac and I also have a
MySQL instance on that machine running v .8.0.22. I have no problem saving
the gnucash data to the local MySQL instance but when I try to save it to
the WIndows instance, I get a non-specific error. My MySQL client can login
from the Mac to the Sinwows instance without problem so I know that I have
both connectivity and the correct userid/passwd.
Can anyone please help me to diagnose why gnucash will not save to the
Windows instance. I also tried creating a user entry for the same userid
but specifying the Mac ip and Standard authentication. This also failed to
work.  What am I missing?


What versions of GnuCash on the Mac and on Windows? And (if relevant) did
you download the software from anyplace other than gnucash.org ?

(please reply to the list as I know nothing about either the Windows or
Mac versions)



-
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
-
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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Saving to MySQL 8.0.36

[Cam Ellison]

On 2024-02-28 18:28, Tommy Trussell wrote:

On Wed, Feb 28, 2024 at 8:02 PM Ira Fuchs  wrote:


I am trying to save my Gbucash data to MySQl v8.0.36 on a newly installed
MySQL instance on WIndwos 10. Gnucash is running on a Mac and I also have a
MySQL instance on that machine running v .8.0.22. I have no problem saving
the gnucash data to the local MySQL instance but when I try to save it to
the WIndows instance, I get a non-specific error. My MySQL client can login
from the Mac to the Sinwows instance without problem so I know that I have
both connectivity and the correct userid/passwd.
Can anyone please help me to diagnose why gnucash will not save to the
Windows instance. I also tried creating a user entry for the same userid
but specifying the Mac ip and Standard authentication. This also failed to
work.  What am I missing?


What versions of GnuCash on the Mac and on Windows? And (if relevant) did
you download the software from anyplace other than gnucash.org ?

(please reply to the list as I know nothing about either the Windows or Mac
versions)


As importantly, which machine hosts the server?


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

Re: [GNC] iPhone or iPad app

[Cam Ellison]

On 2023-12-10 10:46, Adrien Monteleone wrote:

There is no official app other than the main GnuCash app for desktop.

Anything else you find is a 3rd Party project.


And they don't do much, frankly. I tried an Android version, and it was 
not helpful.


If dealing with more than a few items a day, you're better off using a 
spreadsheet and uploading a csv or converting it to a QIF or similar. 
Otherwise, it's actually quicker and easier to manually enter the items 
directly.


Cheers

Cam


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

Re: [GNC] Invoice emailing?

[Cam Ellison]

If you use GnuCash with a database, and have the coding skills, you 
could generate whatever invoice you want, and convert and email it. This 
would be straightforward in most cases, though not trivial. Access to 
the database is not confined to GnuCash itself. Just the same, you'd 
have to do it outside of GnuCash.


Cheers

Cam

On 2023-01-02 17:48, Adrien Monteleone wrote:

If by 'directly' you mean from 'within GnuCash', no, you can't.

Since the customer's e-mail address can appear on the invoice in their 
info block, you might be able to set up a script, possibly combined 
with a folder 'watcher' that can automate e-mailing a resulting PDF 
from printing the invoice to that e-mail address and crafting a 
subject line perhaps with the invoice number taken from the document.


You can of course do the same thing with HTML, via running the invoice 
report, then use the Export button rather than print-to-file.


How much of this you want to automate to reduce clicks is up to you.

Regards,
Adrien

On 1/2/23 7:15 PM, Simon Roberts wrote:

Can I directly email PDF, or was Adrien correct?





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

Re: [GNC] Can I export a list of vendors and customers?

[Cam Ellison]

On 2022-11-18 13:55, Adrien Monteleone wrote:

Unfortunately no.

Regards,
Adrien

On 11/18/22 12:11 PM, Dr. David Kirkby wrote:

Is it possible to export the customers as a .csv file in a database, and
also I'd like to export the vendors. There are no transactions with 
these

yet.



If you store your transactions in a database instead of the standard 
flat file, it's actually quite straightforward, especially with a 
web-based database manager. Trying to work from the command line may be 
a little more complicated.


Cheers

Cam


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

Re: [GNC] Is GnuCash right for me?

[Cam Ellison]

On 2022-08-20 09:08, Robert Heller wrote:

At Sat, 20 Aug 2022 10:32:03 -0400 d...@ditdit.us wrote:


HI Everyone,
Sorry for the totally noob uneducated question. I'm an engineer by
training, not an accountant!
I recently started a home business and everyone said "Quickbooks". It's
too expensive and I despise subscription software. Online/cloud options
are not an option, we have limited (and expensive) internet where we
live.

The business is repairing custom electronic equipment.
What I want/need:
Basic money tracking for the checking account.
Keep track of equipment based on serial number (I was thinking a
database). Here I will keep a record of owner(s), data like software
versions, and work done per RMA.
RMA tracking (another database?). Ability to generate RMA numbers or use
one supplied by the distributor.
Invoicing based on what was done on an RMA (labor, parts and state tax
if applicable).
Simple payroll (I'm the only employee).
Light duty inventory control. I have about 30 items, some are almost too
cheap to track, a few items are expensive, some of those are supplied by
the manufacturer so I need to settle with them at the end of the month.

I use GnuCash for my business and home finances.  Works well for me.

I am a computer programmer and Linux Admin.

GnuCash does not have support for "Payroll" functions, but with a single
"employee" (yourself), there really isn't any "payroll" in the full HR sense:
you are not going to need to bother with payroll taxes -- you are
"self-employed", so you might do quarterly estimates & payments to the IRS
(and your state) and pay SE tax when you file your 1040 schedule C. You just
need the numbers you will file on the 1040 schedule C, 1040SE, etc. GnuCash
will have those numbers.

Inventory management is "interesting" with GnuCash, but it sounds like you
could manage. GnuCash does not really have any proper tools for true inventory
management (eg for a proper storefront), but for a small scale it can be made
to work, possibly with a small database on the side. If you just want to keep
track of how much you owe the suppliers (and if you need resupply), GnuCash
can do that just fine (eg you just create account(s) for the inventory -- when
you acquire more inventory you add the value to the inventory account and
when you sell or use some inventory, you reduce the inventory account by the
amount used/sold.

Yes, using a proper database for keeping track of equipment and RMA tracking
makes sense.

GnuCash can manage your invoicing, etc.


My wife wants to run the entire business from Excel, and in one
spreadsheet I think? Databases seem more proper to me :-)

YES! People seem to think a spreadsheet program is a be-all-end-all
application (ARG!). This is like tossing out your whole toolbox and buying a
Swiss Army Knife as a replacement. Would you actually do that?  (Yes, a Swiss
Army Knife is great on a camping trip or if you are MacGiver, but otherwise,
probably not really.)  Using a spreadsheet for something like this is going to
cause trouble later on.  Spreadsheet software is not going to properly
validate "data" and you you could end up with missing or incompatible data
"fields" (I seen this happen and it leads to all sorts of weirdnesses).

I second what Robert is saying here. GnuCash plus a database is the way 
to go. Excel is good for analysis of data; terrible for pretty much 
anything else. A single database with multiple tables will do the trick: 
from what you wrote one for inventory, one for RMA, and one for your 
equipment if needed. Use Excel to pull information from Gnucash reports 
and database exports to reconcile the various data sources, if that 
becomes necessary.


Cheers

Cam

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

Re: [GNC] MariaDB?

[Cam Ellison]

On 2022-07-15 19:46, john wrote:

None known; in fact we switched the connectors in the Gnucash-built bundles and 
in flatpak to MariaDB's because MySQL discontinued their C one and the C++ one 
won't work with libdbi.

Regards,
John Ralls


On Jul 15, 2022, at 7:40 PM, Thomas Forrester  wrote:

Are there issues with using MariaDB in place of MySQL?

I'll second John's comment. My system is Debian, so when I switched to 
using a database, it was MariaDB from the start. Never a problem.


Cheers

Cam Ellison



___
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] AqBanking Online Set Up

[Cam Ellison]

On 2022-01-03 8:22 p.m., john wrote:

Nope. HBCI (now called FinTS) works *only* with *German* Banks. The Royal Bank 
of *Canada* is absolutely not a German bank and isn't likely to support HBCI.
EBICS is also German only.

https://www.rbcroyalbank.com/onlinebanking/bankingusertips/accountingsoftware/index.html 

 suggests that RBC might support OFX Direct Connect based on the list of software they 
claim to support, but they're not listed in https://www.ofxhome.com/ 
 so you'd have to find the connection parameters some other 
way. The simplest would be to find a friend who has Quicken and see if it knows how to 
connect.


Thanks, John - I stand corrected.

I've not had to do this for probably a decade, but seem to recall being 
able to make it work with a CSV file (from a credit union) - but that 
was a few versions of GnuCash ago. The CSV option is still in GnuCash - 
that might work well enough. I recall having to hand-bomb some of the 
entries to make it come out correctly.


Cheers

Cam



___
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] AqBanking Online Set Up

[Cam Ellison]

On 2022-01-03 5:39 p.m., Jesse MacDougall wrote:

Guy's, I'm stumped here.  My Bank is Royal Bank in Canada.  I have no idea
where to get this information from.  When I call the bank they talk to me
like I am a terrorist due to Iddiocracy.

Never seen this side of technology before.  I read the AqBanking wiki but
didn't advance.

Try selecting a range of transactions by date, and then downloading it. 
See what formats are available for download. The format of each line 
should tell you - or someone on this list with more knowledge than I - 
which of those options to use.  Most likely it's HBCI, but that's a wild 
guess on my part.


There is likely at least one member of this list with an RBC account, 
besides yourself. I have only a credit card with them, and that format 
is different.


Good luck with this

Cam



___
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] gnucash-cli --quotes get

[Cam Ellison]

On 2021-05-27 10:50 a.m., John Ralls wrote:



On May 27, 2021, at 10:35 AM, Cam Ellison  wrote:

On 2021-05-27 10:08 a.m., mike823 wrote:

Hi Robin,

I used your code to load quotes and I've noticed that when runs multiple
times, it will create multiple quote records for the same day. Any way to
avoid this behavior? I mean, if you re-run it, it should just update the
quote for the day, not create a new one.

Thanks.


And for those who do day trading, for example, and want to track prices at 
different times of day?

It does what it should, which is to create a record each time it is run.

But that's not what GnuCash is designed for and if you try to use it that way 
you'll pretty quickly run into performance problems. You're much better off 
getting a portfolio management tool for that kind of thing.

Of course - I should have added that disclaimer. Not many of us have 
unlimited bandwidth.


Cheers

Cam


___
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] gnucash-cli --quotes get

[Cam Ellison]

On 2021-05-27 10:08 a.m., mike823 wrote:

Hi Robin,

I used your code to load quotes and I've noticed that when runs multiple
times, it will create multiple quote records for the same day. Any way to
avoid this behavior? I mean, if you re-run it, it should just update the
quote for the day, not create a new one.

Thanks.

And for those who do day trading, for example, and want to track prices 
at different times of day?


It does what it should, which is to create a record each time it is run.

Cheers

Cam



___
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] Confused Entering A Refund To Credit Card Account

[Cam Ellison]

You should be replying to the list - this went directly to me

On 2021-03-30 9:22 a.m., Jack Frillman wrote:


I tried what you suggested and I can't get it to work.

I will try to illustrate this way. I have -- to indicate a column 
with no entry.


Original transaction

    Tot Payment   27.93
Sales Tax                  n       1.72  --
Books-Magazines     n     23.93  --
VISA    n ---  27.93


Refund
-
   27.93     Tot Change
VISA    n    27.93       --
Books-Magazines    n    23.93       --
Sales Tax  n     1.73        ---
Imbalance-USD   n     ---  53.05



Your numbers don't add up very well.  23.93 + 1.72 = 25.65

You have to put every single entry into the opposite column, like this:

Original Transaction

Sales Tax         1.72    

Books-Magazines   23.93   

VISA       25.65


Refund

Sales Tax   -   1.72

Books-Magazines  -  23.93

VISA    25.65 



On 3/30/21 11:57 AM, Cam Ellison wrote:

On 2021-03-30 8:43 a.m., Jack Frillman via gnucash-user wrote:


I'm trying to enter a refund split transaction to a credit card 
account and every time I do I get an Imbalance-USD amount. (see 
screen shots below)
Why is this happening? 



Screenshots don't work.

Easiest way for me to do the reversal is to duplicate the transaction 
and then cut-and-paste each amount from one side of the register to 
the other. Don't use . If you use arrow keys or  to move 
between fields nothing will change, but the imbalance will show at 
the bottom - with no account assigned. 




___
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] Confused Entering A Refund To Credit Card Account

[Cam Ellison]

On 2021-03-30 8:43 a.m., Jack Frillman via gnucash-user wrote:


I'm trying to enter a refund split transaction to a credit card 
account and every time I do I get an Imbalance-USD amount. (see screen 
shots below)
Why is this happening? 



Screenshots don't work.

Easiest way for me to do the reversal is to duplicate the transaction 
and then cut-and-paste each amount from one side of the register to the 
other. Don't use . If you use arrow keys or  to move between 
fields nothing will change, but the imbalance will show at the bottom - 
with no account assigned.


HTH

Cam


___
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] Trouble getting stock quotes from TSX

[Cam Ellison]

On 2021-02-05 15:23, Geoff wrote:

Hi Gord

You are not doing anything wrong.  The data sources / web pages used
by Finance Quote are constantly changing, and unless someone rolls up
their sleeves and puts in the work to fix it, we end up in this
situation with a number of sources broken, including TSX.


Use AlphaVantage. The only thing that does not work on TSX or TSX.V are 
warrants - and in my case it may simply be that the codes I use are not 
quite right.


Cheers

Cam
___
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] mysql setup in linux (debian)

[Cam Ellison]

On 2021-01-31 20:05, David Cousens wrote:
I don't have any experience of MySQL with GnuCash but I would try and 
look at
logs for the MySQL server in  /var/log/mysql. If the problem is with 
the

server rather than GnuCash itself, that may indicate it. Also check the
Gnucash,trace file ( https://wiki.gnucash.org/wiki/Tracefile) which 
should

be in /tmp but is also located in /var/tmp on some systems.


Looking in the logs will work only if logging is enabled, which in 
Debian it is not, by default. He'll have to set that.


It is possible that the DB was saved correctly. 3.1M in XML is not very 
large, and I seem to recall encountering an error msg of some sort when 
I converted from XML. Using PHPMyAdmin or similar, or logging into mysql 
via CL as root should allow for determining whether the tables were 
created and loaded. Alternatively, try to load the DB as a new file.


HTH

Cam

___
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] Bankrupt stock

[Cam Ellison]

On 2020-12-29 14:18, smada46 wrote:

I have a stock that went bankrupt, i.e. zero value.  I have tried
repeatedly to remove the stock by selling the shares at $0.00 per
share, but no matter what combination I use, it changes the cost or
amount so it does not remove the shares.  For example, I put -2000
shares in and $0.00 in cost and zero under the sell column.  After I
hit enter, the shares show 1980 not zero.  How do I get rid of this
stock?


Why would you want to remove it? Use the Price database to set its value 
to zero. The Portfolio reports will not include it unless you 
specifically select it.


Regardless of their value, you still own those shares - and will always 
own them. So you can't sell them - either in real life or in GnuCash.


HTH

Cam

___
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] Thank you for your patronage

[Cam Ellison]

On 2018-10-03 12:06 p.m., David Burleigh wrote:

On Wed, 2018-10-03 at 11:52 -0700, Cam Ellison wrote:

On 2018-10-03 10:51 a.m., David Burleigh wrote:

How can I permanently change the message "Thank you for your
patronage" that appears at the bottom of printed invoices? I am using
GnuCash version 3.2 under Linux (Debian).

The file is at: /usr/share/gnucash/scm/gnucash/invoice.scm. Look for
line 332 or somewhere around there.

Cheers

Cam


Well, thank you for that, but there's no "invoice.scm" in that folder. There are a dozen 
".scm" files there, but not "invoice.scm". There are also several folders there, none of 
which have the file either...

___


Whoops! Left out a directory.

Try

/usr/share/gnucash/scm/gnucash/report/invoice.scm

Cheers

Cam

___
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] Thank you for your patronage

[Cam Ellison]

On 2018-10-03 10:51 a.m., David Burleigh wrote:

How can I permanently change the message "Thank you for your
patronage" that appears at the bottom of printed invoices? I am using
GnuCash version 3.2 under Linux (Debian).


The file is at: /usr/share/gnucash/scm/gnucash/invoice.scm. Look for 
line 332 or somewhere around there.


Cheers

Cam


___
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: Price Retrieval Failure

[Cam Ellison]

On 24/01/18 11:26 AM, Geert Janssens wrote:

David,

Another thing to try is run gnucash from the command line (I  believe this is
also possible on OS X, though I don't know the details).

Normally gnucash prints the version of F::Q it finds to the console during
startup. That may give a hint already.



You can force discovery of the version by doing this on the command line:
gnucash --add-price-quotes /path/to/gnucash_file

It's probably better to do this when gnucash is not running, but it 
should work even when it does. It just won't access the file because 
it's already locked.


Cheers

Cam

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

Re: Finance:Quotes

[Cam Ellison]

On 20/01/18 07:54 PM, Paul Jones wrote:

Thanks Dave, I'll give that a try. Are you aware of which finance-quote
modules are working for Canadian stocks and mutual funds, or is it a case
of trial and error?


TSX and TSX.V are easily accessed using alphavantage. Also currency. For 
CSE (suffix .CN) you will need to use yahoo_json. I have not tried 
yahoo_json with TSX or TSX.V stocks, but it should work with them.


Ask if you have any further questions about this.

Cheers

Cam

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

Re: How to deal with RRSP's (Canada)

[Cam Ellison]

On 03/01/18 04:36 PM, Matthew Pounsett wrote:

I am not an accountant.. or even a bookkeeper.. but here's how I deal with
RRSPs.



For me, the RRSPs have been converted to Income Funds, but the principle

and procedure are still the same. Contribution is straightforward: from a
Current Asset account to the RRSP, like this:

Assets:Current Assets:Chequing Account$5,000
Assets:Investments:RRSP$5,000



RRSPs are investments–typically mutual funds–and not savings accounts (at
least, every RSP account I've ever had has been presented that way: as X
units worth $Y per unit).  So, when I buy in to my RRSPs it shows in my GC
books as a purchase of shares of a mutual fund.  Transfers out as a sale of
shares.




Withdrawal is more complex, because you have to show Income, Withholding
Tax, the receiving Account, and the RRSP account, so using an Equity
account for RSP/RIF withdrawals is needed to balance, like this:


It only needs to be more complex if you're trying to use GC to calculate
your tax for you.  If that's the case, then there's additional complexity
on both the purchase and sale of RRSP shares.  On purchase, you need to
reduce your income, but I'm not sure what that would be balanced against.
The most likely prospect seems to me to be a liability, probably.   On sale
there's no withholding, or any immediate tax activity.. that all comes at
the end of the year when you calculate your taxes.  This makes sense if you
think about the fact that (assuming you purchase RRSP shares from out of
your assets) there was no negative change to withholding when you bought
the RRSP shares in the first place.  That only occurs if your employer is
buying shares on your behalf pre-tax, which will still work out, because
that immediately reduces whatever you would have put in your income
(salary) account.

So on purchase of RRSP shares you'd reduce your effective income and
increase an offset (liability?) account.  On sale, do the reverse until
your chosen offset account hits zero, and then any other withdrawls are new
income (gains on the investment).  I believe the rest should come out in
the wash (tax forms).  The only question in my mind is what to balance the
income account against.. and I'm afraid for that I only have guesses.

The examples I used were (perhaps over-) simplifications. In practice, I 
actually have a number of stocks and money market accounts within two 
RIFs, like so:


Assets:investments:RIF:Stock1
Assets:Investments:RIF:Stock2
Assets:Investments:RIF:MoneyMarket1
Assets:Investments:RIF:Cash
etc.

A withdrawal from the RRSP/RIF is actually from the cash account within 
the RRSP/RIF subsequent to selling money market shares. Everything is a 
Stock, except the cash account. If you have mutual funds, substitute 
appropriately. I have RIFs, being over 71, but for our purposes here the 
difference between RRSP and RIF is in name only. If there is only one 
financial instrument, then you obviously would dispense with the 
detailed breakdown shown above.


The offset account can't be a liability - that would double the impact 
of the withdrawal and screw up your balance sheet. It pretty much needs 
to be either an Equity or an Expense account. As I think about it more, 
there is a certain logic to the latter, since it was originally Income. 
I may have been doing that part wrong. When I moved everything into 
GnuCash lo, these many years ago, I had to use Equity:Opening Balances 
as the offset to each item within the RRSP, and simply continued the 
practice, with a different sub-account


I am not an accountant, either, but perhaps a member of this list who is 
might weigh in on this last point.


I think if your employer contributes to your RRSP or a fund or other 
instrument within it, that probably needs to be dealt with as Income. 
Also, it may count as a taxable benefit.


Cheers

Cam

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

Re: How to deal with RRSP's (Canada)

[Cam Ellison]

On 02/01/18 06:52 PM, DaveC49 wrote:

Larry

If your withdrawals from the RRSP are taxable on withdrawal then I think
your approach of using two files recording transfers to your bank account
from the RRSP as Expenses in the RRSP account and  Income in your main
accounts should work fine as it will satisfy the accounting equation in both
files without any conflicts and will keep Gnucash happy.

With both the RRSP and your bank accounts in a single file, the decrease of
an asset (RRSP) is a credit to that account and an increase in Income (which
it would have to be to record it as income for taxation) is also a credit to
the income account in that same file, which would not be a balanced
transaction in which the sum of debits and credits is zero.


For me, the RRSPs have been converted to Income Funds, but the principle 
and procedure are still the same. Contribution is straightforward: from 
a Current Asset account to the RRSP, like this:


Assets:Current Assets:Chequing Account        $5,000
Assets:Investments:RRSP                $5,000

Withdrawal is more complex, because you have to show Income, Withholding 
Tax, the receiving Account, and the RRSP account, so using an Equity 
account for RSP/RIF withdrawals is needed to balance, like this:


Assets:Investments:RRSP                                $5,000
Assets:Current Assets:Chequing    $3,500
Expenses:Taxes:Income Tax            $1,500
Income:RRSP $5,000
Equity:RSP/RIF                                $5,000

At any rate, that's how I do it. YMMV.

Cheers

Cam

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

Re: Bank reconciliation

[Cam Ellison]

On 13/11/17 09:45 AM, David Goodenough wrote:

Does no-one else have this problem?

When we try to split the transaction in the imbalance account to allocate the 
payment to
invoices we notice that it almost lets us add one split, but it does not 
automatically
decrement the amount allocated to the imbalance account and so try to end up 
with an
unbalanced split.  It will also only allow us to allocate one payment (after we 
have made
the split balance), there is still an amount in the imbalance account which we 
can not
allocate to another payment.


I have dealt with this by setting up a separate Asset account for 
receiving payments, similar to what you have. When a payment is 
received, it goes into this "Payment" account, and then when the bank 
deposit is made the appropriate amount is debited from the Payment 
account. This process adds a step between receipt of the cheque (thus 
acknowledging the invoice as paid) and depositing it. In effect, it is a 
buffer. It works whether the invoice is paid in full or only in part. No 
need to do any splits, which is where things seem to go south for you.


Cheers

Cam

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

Re: Finance-Quote 1.47 released!

[Cam Ellison]

On 12/11/17 08:27 AM, Erik Colson wrote:

New version 1.47 of Finance-Quote is available with the following changes:

 * Use AlphaVantage for currency quotes instead of Yahoo (Mike 
Alexander)



FYI: USD->CAD now works, but not GBP->CAD.

Cheers

Cam

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

Re: Version 2.6 17 No Longer Downloads Quotes

[Cam Ellison]

On 11/11/17 11:10 AM, Robert L. Kief wrote:
For the past couple of weeks, GnuCash 2.6.17 no longer downloads stock 
quotes.  The accompanying error message originally listed the stocks 
quotes being requested with the indication they couldn't be 
downloaded.  Now the error reads "There was an unknown error while 
retrieving the price quotes.".  Are there any suggestion on how I can 
return to receiving quotes?


The problem is not with GnuCash. Look at the various threads over the 
last week or so relating to Finance::Quote. You will need to upgrade 
F::Q and change your source to Other->alphavantage. And get yourself an 
AlphaVantage key.


Cheers

Cam

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

Re: Finance-Quote 1.44 released!

[Cam Ellison]

For anyone who has been following this thread, and especially for Erik:

The problem turned out to be a couple of stocks that I no longer hold 
but are still in the table for historical reasons, whose quote 
assignments were incorrect. All good now.


Thank you again, Erik, for your patience,

Cam

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

Re: Finance-Quote 1.44 released!

[Cam Ellison]

Having re-read the FAQ, I think it may just be a time-out problem. I may 
have to change the cron job to the middle of the night - at least until 
there's a change in gnucash that will recognize this and allow for the 
extra time.


Thank you, once again,

Cam

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

Re: Finance-Quote 1.44 released!

[Cam Ellison]

On 10/11/17 05:21 AM, Erik Colson wrote:

Cam,

I don't know about gnucash itself since I don't use it.  F::Q handels
the symbols correctly as shown below for CMI.V:

~/.../finance-quote/Examples >>> perl stockdump.pl alphavantage CMI.V
$VAR1 = {
   'CMI.Vopen' => '1.1400',
   'CMI.Vclose' => '1.1000',
   'CMI.Vcurrency_set_by_fq' => 1,
   'CMI.Vvolume' => '5000',
   'CMI.Vmethod' => 'alphavantage',
   'CMI.Vhigh' => '1.1400',
   'CMI.Vlow' => '1.1000',
   'CMI.Vcurrency' => 'CAD',
   'CMI.Vsymbol' => 'CMI.V',
   'CMI.Vlast' => '1.1000',
   'CMI.Vsuccess' => 1,
   'CMI.Vdate' => '11/09/2017',
   'CMI.Visodate' => '2017-11-09'
 };

The required fields for gnucash return correct data.  So F::Q does the
job.  There will probably be something misconfigured in your gnucash
setup..


I am suspecting as much. There is no alphavantage key error, so it is 
clearly present in the bash environment. For example:

gnc-fq-dump alphavantage ALV.V
Finance::Quote fields Gnucash uses:
    symbol: ALV.V    <=== required
  date: 11/10/2017   <=== recommended
  currency: CAD  <=== required
  last: 0.1950   <=\
   nav:  <=== one of these
 price:  <=/
  timezone:  <=== optional

"nav" is not set, which may be the problem, or one of them.  I notice 
that it is blank when I test it with US stocks as well, so perhaps not.


Gnucash is throwing an error on something for which no or insufficient 
information is available.  I'll go look at bug reports.


Thank you very much for your time and effort

Cam

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

Re: Finance-Quote 1.44 released!

[Cam Ellison]

On 09/11/17 01:37 AM, Erik Colson wrote:

Cam Ellison <c...@ellisonet.ca> writes:


On 08/11/17 12:40 PM, Erik Colson wrote:


Please list some symbols you tried.



Here you go:

CMI.V
MBA.TO
QST.V
FCEL (on NASDAQ)

Hi Cam,

Please try again with F::Q v1.45.  It does work on my system.


So I did that. When I use the Get Quotes button on the Price Editor, I 
get a termination with this error: /There was an unknown error while 
retrieving the price quotes/. Closing GnuCash and running gnucash 
--get-price-quotes from the command line fails to produce any entries in 
the Price Editor - at least none are displayed. I have a debug trace but 
have no clue what I'm looking for. I'm using version 2.6.15 if that 
makes a difference.


Thank you again for your efforts.

Cam

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

Re: Finance-Quote 1.44 released!

[Cam Ellison]

On 08/11/17 12:40 PM, Erik Colson wrote:


Please list some symbols you tried.



Here you go:

CMI.V
MBA.TO
QST.V
FCEL (on NASDAQ)

I ran gnucash --add-price-quotes with debugging on and logged it. There 
are entries for currencies and for  stocks etc of this form (selected 
lines to show each exchange):
* 11:54:34  INFO  [gnc_commodity_table_insert] insert 
0x562c52344200 FCEL into nsp=0x562c516ae120 NASDAQ
* 11:54:34  INFO  [gnc_commodity_table_insert] insert 
0x562c52343fe0 VPLM into nsp=0x562c5233a860 OTC
* 11:54:34  INFO  [gnc_commodity_table_insert] insert 
0x562c523458b0 AVO.TO into nsp=0x562c5233a760 TSX
* 11:54:34  INFO  [gnc_commodity_table_insert] insert 
0x562c52348a30 ALV.V into nsp=0x562c5233a4c0 TSX.V


I'm not sure whether this is just part of the setup as gnucash loads, or 
whether this shows gnucash attempting to get quotes.


gnc-fq-dump gives this return:
Finance::Quote fields Gnucash uses:
    symbol: ALV.V    <=== required
  date: 11/08/2017   <=== recommended
  currency: ** missing **    <=== required
  last: 0.2000   <=\
   nav:  <=== one of these
 price:  <=/
  timezone:  <=== optional

** This stock quote cannot be used by GnuCash!

Anything else I can provide?

Thank you

Cam

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

Re: Finance-Quote 1.44 released!

[Cam Ellison]

On 08/11/17 11:15 AM, Erik Colson wrote:

? ??  writes:


Right now it works well with updating prices of my US stock.
But for my Asian stocks, such as Hong Kong stock, China stock, and Taiwan 
stock, it's still not working now.
Currency is not updated either.

Is there a way for updating currency and Asian stock price?

Currency support will probably be added during next weekend.

Concerning asian stocks: I can check it out if you send the symbols as
you retrieved them from yahoo.


While you're at it - and thank you very much for all your time and 
effort on this - I can't seem to get any TSXV (TSX Venture) stocks 
through alphavantage. gnc-fq-dump shows currency missing for the ones 
I've tried. Running gnucash --add-price-quotes with debugging (extra) 
enabled shows that the attempt is made to load all the quotes, but 
nothing is recorded and there is no error message.


If you can give me some direction as to additional analysis I can do, 
I'm willing to try it.


Cheers

Cam

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

Re: GnuCash quotes suddenly :- " Unable to retrieve quotes for these items:"

[Cam Ellison]

On 07/11/17 04:16 PM, WasserLand wrote:

Ubuntu 16.04. Gnu Cash ver  2.6.17

Price Editor suddenly "Unable to retrieve quotes for these items:" 
Yahoo  ASX.


Has been working very well for years but very recently has failed. I 
see there is an Finance::Quote update being discussed.  Does that have 
something to do with my problem?


In a word, yes. Read the Finance::Quote emails for possible actions you 
can take.


Cheers

Cam

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

Re: F::Q has been working but not anymore

[Cam Ellison]

On 03/11/17 07:56 PM, MGM wrote:
I am using latest version of F::Q ."1.38" .It  stopped  updating share 
prices 3 days ago. I am using  :  Type of source quote  as multiple ., 
Asia (Yahoo,..)as my shares are on Australian Stock Exchange ( .AX).


Yahoo has quit providing quotes, apparently, so while F::Q works well, 
there's nothing for it to download.



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