Re: [GNC] Auto Complete "pick from list" enhancement

2022-12-05 Thread gnu Gord
> > > On Dec 5, 2022, at 3:08 PM, gnu Gord wrote: > > I'm wondering if anyone else would find it useful, or if anyone else has > already suggested an enhancement to GnuCash whereby it would display a list > of memorized transactions when one was being entered. > Currently if

[GNC] Auto Complete "pick from list" enhancement

2022-12-05 Thread gnu Gord
I'm wondering if anyone else would find it useful, or if anyone else has already suggested an enhancement to GnuCash whereby it would display a list of memorized transactions when one was being entered. Currently if I start typing in the description field GC finishes the field and if I hit tab it

Re: [GNC] Finance::Quote and TMX.pm

2022-11-12 Thread gnu Gord
e changed every > instance of tmx to tsx as part of your modifications it should get added to > the sources list from gnc-fq-check and enable the tsx item in GnuCash's > security editor. > > Regards, > John Ralls > > > On Nov 12, 2022, at 9:07 AM, gnu Gord wrote: >

Re: [GNC] Finance::Quote and TMX.pm

2022-11-12 Thread gnu Gord
Thanks for the suggestion but the TMX module is already listed in Quote.pm. It existed before I started so there must be some other way GnuCash decides whether a module is available for use or not... I just don't know how. Thanks again, Gord On Sat, Nov 12, 2022 at 7:20 AM Ken Farley wrote: >

Re: [GNC] Finance::Quote and TMX.pm

2022-11-11 Thread gnu Gord
ot;, after you test your TMX.pm file, > copy the file with the name TSX.pm , then it will get enabled , good luck > > > > Saludos Cordiales > > > Murugan > > -- > *From:* gnu Gord > *Sent:* Thursday, November 10, 2022 10:35 PM > *To:* M

Re: [GNC] Finance::Quote and TMX.pm

2022-11-10 Thread gnu Gord
wrote: > it would be great if you could share tmx.pm file so it can help others > > > > Saludos Cordiales > > > Murugan > ------ > *From:* gnu Gord > *Sent:* Thursday, November 10, 2022 5:51 PM > *To:* Murugan Muruganandam > *Cc:* gn

Re: [GNC] Finance::Quote and TMX.pm

2022-11-10 Thread gnu Gord
aludos Cordiales > > > Murugan > -- > *From:* gnucash-user hotmail@gnucash.org> on behalf of gnu Gord > *Sent:* Thursday, November 10, 2022 3:47 PM > *To:* gnucash-user@gnucash.org > *Subject:* [GNC] Finance::Quote and TMX.pm > > Hi All,

[GNC] Finance::Quote and TMX.pm

2022-11-10 Thread gnu Gord
Hi All, I've been playing with the Perl module for the Toronto Stock Exchange (TMX.pm) and think I may have it working again. I'd like to try it in GnuCash but the option to select it as a source in the securities editor is grayed out. Does anyone know how to re-enable that option? Thanks, Gord

Re: [GNC] Scheduled transaction frequency?

2021-03-16 Thread gnu Gord
Thanks to all that replied. I have set it up as 'last day of the month', that's one of the options, because it is an expense. I'll have to remember, or better yet, add a comment that says something like "change the date to the real date before posting". It's not a huge problem but an interesting

[GNC] Scheduled transaction frequency?

2021-03-16 Thread gnu Gord
I'm trying to add a scheduled transaction that occurs 21 days after the 10th of each month. With this timing, the transaction does not occur on a specific date in the month. Some months it's on the 31st and some months it's on the first of the next month, ETC I can't figure out how to enter that

Re: [GNC] Capital Gains

2021-03-03 Thread gnu Gord
Thanks David, you always give me lots to think about. As of right now, the data is purely for my own consumption so I don't really have any tax implications to worry about, but I may follow your advice just in case. Perhaps the example in the documentation could be clarified to include capital

Re: [GNC] Capital Gains

2021-03-02 Thread gnu Gord
Thanks for the explanation. I was trying to follow the example in Chapter 11 of the GnuCash Documentation that seems to indicate the unrealized capital gains are recorded in Assets:Fixed Assets... and I would record a transfer from Income:Unrealized Gains... However, I didn't understand how to

[GNC] Capital Gains

2021-03-02 Thread gnu Gord
Are capital gains (and losses), both realized and unrealized, always recorded as income, both positive and negative? Thanks. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe:

Re: [GNC] Assets vs. expenses vs. income entry

2021-02-21 Thread gnu Gord
OK, it's starting to sink in, slowly. I read chapter 11 in the GC documentation (I didn't realize I was asking about Capital Gains) and used the example to create the accounts and transactions in my own accounts. It seems to work... like magic. I'll have to think about it some more and will

[GNC] Assets vs. expenses vs. income entry

2021-02-21 Thread gnu Gord
I'm unsure of the best way to record the adding/modifying of an asset. Should the transaction go directly to an asset account or an expense account then create an asset? Let me explain. If, for example, I buy a car that costs me $1000 and pay for it from my chequing account, no loan involved.

Re: [GNC] Expense Over Time report

2021-02-21 Thread gnu Gord
and is quite fast. > > I still use placeholder accounts for category headings, but for > transactions, use the numbers almost exclusively. > > Check to see the numbering scheme for something like Sage Simply > Accounting and add the numbers to your account name and number fields, &

Re: [GNC] Expense Over Time report

2021-02-20 Thread gnu Gord
ing, and then update the docs with information. > > > > Best, > > David T. > > > > > > > > Original Message > > From: Geoff > > Sent: Fri Feb 19 18:37:21 EST 2021 > > To: gnu Gord , gnucash-user@gnucash.org > > Sub

[GNC] Expense Over Time report

2021-02-19 Thread gnu Gord
I'm trying to understand this report and it just isn't working the way I expect. Below is a screenshot of my test chart of accounts, for reference. I have one expense of $100 in account L3 and one expense of $500 in account L4 If I ask for an Expense Over Time report and select L3 and* "Show

Re: [GNC] Asset vs Equity accounts? (Stan Brown)

2021-02-15 Thread gnu Gord
Thank you very much to all that replied. There are, obviously, a lot of people out there with a much deeper understanding of this than I currently have (or probably ever will) and I thank you for sharing your knowledge and experience. I am slowly getting a handle on the overall concepts and

[GNC] Asset vs Equity accounts?

2021-02-14 Thread gnu Gord
First off I'll say I have no formal accounting training so I don't really understand accounting terminology or how it is represented in GnuCash. I understand the basic idea that Equity = Assets - Liabilities, but I'm unsure how this should be entered in GnuCash. Specifically, my question is; how

[GNC] Trouble getting stock quotes from TSX

2021-02-05 Thread gnu Gord
Is anyone using the stock quotes in GnuCash from the TSX (Toronto Stock Exchange)? I can not get it to work. I have it working from Yahoo but not the TSX. I tried testing it using gnc-fq-dump and did not have any more luck. It seems to work if I use Yahoo but not the TSX. I don't know what I'm

Re: [GNC] mysql setup in linux (debian)

2021-02-02 Thread gnu Gord
I would be happy to open a bug report but I have no idea how to do it. Can you point me in the right direction? On Mon, Feb 1, 2021 at 7:25 PM Jim DeLaHunt wrote: > Good catch, Gord! > > On 2021-02-01 10:36, gnu Gord wrote: > > …It appears that mysql (or somewhere in the bac

Re: [GNC] mysql setup in linux (debian)

2021-02-01 Thread gnu Gord
Thanks to all that commented on this and thanks to the '/tmp/gnucash.trace' file, I think I have discovered the problem. It appears that mysql (or somewhere in the backend of gnuCash) does not like a back slash character as the last character in a field. The data I was trying to save had one entry

Re: [GNC] mysql setup in linux (debian)

2021-01-31 Thread gnu Gord
Thank you very much for the information. It seems the problem was that I had not installed the libdbd-mysql package. I did have the libdbi but not the mysql package. I also did not have the libdbd packages for pgsql or sqlite3 ... but I do now! and they now show up in gnucash as options for the

Re: [GNC] mysql setup in linux (debian)

2021-01-31 Thread gnu Gord
Thanks for the reply. When I go to 'save as' the Data Format drop-down only has XML as an option, unlike my Windows version that has Mysql and others. I installed the Linux version using apt so I did not build it myself. Perhaps the official package was built without this support? If so, would I

[GNC] mysql setup in linux (debian)

2021-01-31 Thread gnu Gord
Having some problems with mysql setup for linux. I got the Windows version to work but don't seem to have the option to "save as" mysql in my linux version. Are there some instructions somewhere that talk about using/setting up mysql in linux? ___

[GNC] find and replace

2021-01-30 Thread gnu Gord
Is it possible to find a specific split transaction based on the memo field and assign the account to transfer for that split item? Let me explain. I'm new to GnuCash and have just imported my Quicken data QIF file but it appears that some transactions within splits have no transfer account

[GNC] multiple attachments

2021-01-25 Thread gnu Gord
Hi List, I'm trying to find a replacement for Quicken and brand new to GnuCash, so please excuse any protocol errors I may generate. ;) I'm wondering if it's possible in GnuCash to attach multiple files to one transaction record (like I can do in Quicken). Most of the files I would want to