Re: [GNC] Advanced portfolio

2024-10-21 Thread Fred Tydeman
In the following, the first word on the COA is the Type of account. When I had the Canada stock as a child of CAD cash account, the Advanced Portfolio report did not include the CAD stock (even when I said to select all children of Fidelity). Assets Asset Fidelity (in USD) Cash CAD (in CAD)

[GNC] Split Actions

2024-10-21 Thread interesse
Hello everyone, can someone explain the meaning and consequences of the different actions that can be selected for each transaction split? What do they mean? Are they used for anything? For reports or something else? Kind regards Marco ___ gnucash

Re: [GNC] Split Actions

2024-10-21 Thread Fred Bone
On 21 October 2024 at 11:26, Michael or Penny Novack said: > On 10/21/2024 10:43 AM, interesse wrote: > > Hello everyone, > > > > can someone explain the meaning and consequences of the different > > actions that can be selected for each transaction split? > > What do they mean? > > > > Are they

Re: [GNC] Online quotes not working for currency rates (Perl library works)

2024-10-21 Thread John Ralls
It Is indeed caused by GnuCash itself, and it’s fixed in git for the next release. It’s available in nightly builds, but we don’t have those for MacOS. The simplest fix for you is to use GnuCash 5.8 until 5.10 is released in December. Regards, John Ralls > On Oct 21, 2024, at 07:55, Chang Wan

Re: [GNC] Changing currency and raising foreign currency invoices

2024-10-21 Thread R Losey
Regarding the company, I'm not sure -- you've "set it up"? Is it a company in the UK that does business in GBP? (or was GBP just some kind of mistake?) or a US business that could sell in GBP? Regarding sales/purchases, I have not run a business in a foreign currency, but I presume you could conve

Re: [GNC] Split Actions

2024-10-21 Thread R Losey
I think they are just to make record-keeping easier. I think these tags show up in some of the reports. I routinely do account transfers, so I tend to try hard to use the "Transfer" action (also note that the generated list changes depending upon the type of account... but it is also a freeform f

Re: [GNC] Export file lacks document links

2024-10-21 Thread Mark at Lorimark
Hi Brook, I've used doc-links 'a bit' so I have only a few examples. (see attached) I can tell you where the links are 'stored' but not how they get there. You would want to explore the code in the slots/mechanism (sorry I can't give better source references). But, as you can see in the att

Re: [GNC] Export file lacks document links

2024-10-21 Thread Brook Milligan via gnucash-user
OK, I found what appears to be the way to access document links in the code (see libgnucash/engine/Transaction.cpp). It seems that the attached patch (untested) will add the transaction link to exported files. However, I’m much less certain how to make the import code handle the extra field.

Re: [GNC] Changing currency and raising foreign currency invoices

2024-10-21 Thread Murugan Mariappan
Yes you need to edit the file and save it as environment.local You can read more detailed instruction in the following link https://wiki.gnucash.org/wiki/Locale_Settings Saludos Cordiales Murugan From: Jason Seegers Sent: 21 October 2024 18:04 To: Murugan

Re: [GNC] Thank you to developers

2024-10-21 Thread sunfish62--- via gnucash-user
But not after you've imported them. You assign them during import, and that's when it learns. ⁣David T. ​ On Oct 22, 2024, 12:18 AM, at 12:18 AM, Derek Atkins wrote: >Theoretically you can "train" it... >-derek > >On Mon, October 21, 2024 4:54 pm, William Prescott wrote: >> I used a .qfx file.

Re: [GNC] Problem with auto generation of entries

2024-10-21 Thread Adrien Monteleone
You need to *attach* the images, do not try pasting them into the message. I'm not certain of all of allowed formats off the top of my head, but JPG, BMP, & PNG should be fine. Regards, Adrien On 10/21/24 1:26 AM, Geoff Jankowski via gnucash-user wrote: I am not sure how to upload images and

Re: [GNC] Advanced portfolio

2024-10-21 Thread Derek Atkins
Hi, The Currency of a stock is based upon the currency of its parent account. How do you have your brokerage set up? To get this to work, you would need a "Foreign-Brokerage CAD" asset account as the parent for the CAD-enumerated stock account. Do you have that? -derek On Mon, October 21, 2024

Re: [GNC] Advanced portfolio

2024-10-21 Thread Murugan Mariappan
Couple of queries, 1. Is the stock enabled for auto price quotes? 2. The prices you have seen , does it say Finance:Quote or user:split Saludos Cordiales Murugan From: gnucash-user on behalf of Fred Tydeman Sent: 21 October 2024 10:06 To: Gnucash

Re: [GNC] Problem with auto generation of entries

2024-10-21 Thread Liz
On Mon, 21 Oct 2024 08:26:05 +0200 Geoff Jankowski via gnucash-user wrote: > I am not sure how to upload images and for some reason I cannot > connect to all the pages on the Gnucash.org website (Installation and > Getting Help are both stalling) so was unable to log there. > > Here is the image

[GNC] Advanced portfolio

2024-10-21 Thread Fred Tydeman
I am running Gnucash 5.9 on Fedora Linux 40 My home currency is USD My Fidelity brokerage account has one stock on a Canada stock exchange. I have run Reports: Assets&Liabilities: Advanced Portfolio. In the options, I changed the date to yesterday (Oct 19). The line in the report for that Canada st

[GNC] Changing currency and raising foreign currency invoices

2024-10-21 Thread Jason Seegers
Hi, I am wanting to run everything in USD but the company I setup is in GBP and changing the settings to USD has not changed this. How do I change the currency ot the company? Also, how does one raise sales or purchase invoices in a foreign currency? Thanks in advance for any assistance. _

[GNC] [MAINT] Unplanned network outage Saturday/Sunday

2024-10-21 Thread Derek Atkins
Hi, Many of you may have noticed that it was pretty quiet over the weekend. AT&T (my ISP) had a fiber cut around 1am Saturday Night (Sunday Morning) that took out my network. They kept pushing the expected resolution until 5am today, but the network was repaired at 7:09pm last night at which poi

Re: [GNC] Problem with auto generation of entries

2024-10-21 Thread Derek Atkins
FYI, the network returned at 7:09pm US/EDT last night, so it was offline for less than 24 hours. However that outage certainly would have affected access to the Wiki and some of the Documentation. The rejection could be due to the network outage -- can you send me the bounce message? FYI, images

Re: [GNC] Dealing with mutual funds

2024-10-21 Thread R Losey
Part of this is up to you, and GnuCash is flexible because configurations can change. I assume IBKR is your broker, and you have a single, normal brokerage account that deals in mutual funds and stocks. I would create a brokerage account and note that it is with IBKR; I assume cash is help somewh

Re: [GNC] Split Actions

2024-10-21 Thread David Carlson
There is a setting under Edit > Preferences > General regarding setting book options to use split action field... with the flyover note [quoted from the help manual] "Set book option on new files to use split "action" field for "Num" field on registers/reports: If selected, the displayed setting o

Re: [GNC] Split Actions

2024-10-21 Thread Michael or Penny Novack via gnucash-user
On 10/21/2024 10:43 AM, interesse wrote: Hello everyone, can someone explain the meaning and consequences of the different actions that can be selected for each transaction split? What do they mean? Are they used for anything? For reports or something else? Kind regards Marco Unclear what

Re: [GNC] Advanced portfolio

2024-10-21 Thread Fred Tydeman
The CAD stock is setup for Get Online Quotes from Yahoo as JSON. The price database is a mixture Finance::Quote user:splt-register user:split-import The USD entry is a user:split-import On Mon, Oct 21, 2024 at 3:36 PM Murugan Mariappan < m.muruganan...@hotmail.com> wrote: > > Couple o

[GNC] Online quotes not working for currency rates (Perl library works)

2024-10-21 Thread Chang Wang
Hi, I'm having trouble getting the quotes of currency exchange rates using Finance::Quote. The situation: * I can get quotes successfully for stocks using "Get Quotes" in the price database. But not the currency I'm using. * I'm on MacOS. ``` ALPHAVANTAGE_API_KEY=XXX /Applications/Gnucash.app/Co

Re: [GNC] Australian Stock Exchange Module in Finance::Quote

2024-10-21 Thread Kalpesh Patel
Sadly, manual labor ... -Original Message- From: Ernie Wakamatsu Sent: Monday, October 21, 2024 12:17 AM To: Kalpesh Patel Cc: John Ralls ; sunfish62--- via gnucash-user Subject: Re: [GNC] Australian Stock Exchange Module in Finance::Quote Hi All So, what are the options for those o

[GNC] Export file lacks document links

2024-10-21 Thread Brook Milligan via gnucash-user
As I was exploring export file issues recently, I realized that the export file lacks the document links. Consequently, an export + import will not round-trip the data and regenerate the original book. It seems it would be desireable for that to be possible. I was looking through the source c

Re: [GNC] Changing currency and raising foreign currency invoices

2024-10-21 Thread Jason Seegers
This is a USD business which invoices in USD and EUR predominantly. When I setup the company, I did select USA but everything defaulted to GBP. I've noticed that I create accounts in the currencies and that has somewhat solved my problem and I was also able to raise an invoice in a foreign curre

Re: [GNC] Split Actions

2024-10-21 Thread John Ralls
Interesse means the action field on splits. The action field is a free-text field with some predefined values that you can use; what the predefined values are depends on the register type (currency, stock, invoice, etc.). It can be used to select transactions in the Find dialog, to sort them in

[GNC] transaction register date-picker pop-up box is transparent, makes choosing dates cumbersome.

2024-10-21 Thread Mike Commissaris
Recent replies about small register font has prompted me to fix a nagging issue where the calendar pop-up box is transparent and the text under the pop-up mixes with the calendar dates causing difficulty picking the date. The pop-up has focus because I can select the date - just have to discern the

Re: [GNC] transaction register date-picker pop-up box is transparent, makes choosing dates cumbersome.

2024-10-21 Thread John Ralls
That’s been reported before: https://bugs.gnucash.org/show_bug.cgi?id=798693 . In that case it turned out to be a theme problem. Regards, John Ralls > On Oct 21, 2024, at 16:12, Mike Commissaris > wrote: > > Recent replies about small register font has prompted me to fix a nagging > issue wh

Re: [GNC] Split Actions

2024-10-21 Thread Adrien Monteleone
Also, when you post a bill/invoice, the line-item splits get assigned an action of 'bill'/'invoice' respectively. Another point about the 'payment' actions is that they get applied to both the AR/AP split, and the source account split. As far as I know, only the one assigned to the AR/AP split

Re: [GNC] Thank you to developers

2024-10-21 Thread William Prescott
That makes sense. Thanks. Will On 21 Oct 2024, at 15:42, sunfis...@yahoo.com wrote: But not after you've imported them. You assign them during import, and that's when it learns. David T. On Oct 22, 2024, at 12:18 AM, Derek Atkins mailto:de...@ihtfp.com>> wrote: > > Theoretically you can "tra

Re: [GNC] Split Actions

2024-10-21 Thread Adrien Monteleone
The business features, at the least, assign a 'payment' action when you link a transaction as a payment to a bill/invoice. (whether linked after the fact, or created as a payment initially) There might be others, but I recall that one off-hand. Regards, Adrien On 10/21/24 7:40 PM, John Ralls

Re: [GNC] Changing currency and raising foreign currency invoices

2024-10-21 Thread Murugan Mariappan
You can override the locale currency setting by changing the environment file (you can find this in the GNC_CONF path and save it as environment.local) Also please check the billing information on customer panel and you can change the currency for your purspose. Saludos Cordiales Murugan

[GNC] Thank you to developers

2024-10-21 Thread William Prescott
I have used Gnucash since 2011-01-01. I had never used the import function until this past weekend. I always made all the entries manually. But I recently realized that my bank allows downloading transactions in qfx format and I decided to try it. It was a good time to do so. I recently returne

Re: [GNC] Thank you to developers

2024-10-21 Thread William Prescott
I used a .qfx file. It didn't occur to me to right-click on them and I didn't see that in my short perusal of the documentation. I always try things first, then read the documentation later or not at all. Sometimes that bites me. Will it remember assignments next time? Best wishes, Will On 21

Re: [GNC] Changing currency and raising foreign currency invoices

2024-10-21 Thread Jason Seegers
Hi, Thanks for the response. I’m not entirely sure I understand. Is this changed somewhere in the settings or am I meant to edit the environment file somehow? Kind regards, Jason From: Murugan Mariappan Date: Monday, 21 October 2024 at 13:52 To: Jason Seegers , R Losey Cc: gnucash-user@gnucas

Re: [GNC] Thank you to developers

2024-10-21 Thread Derek Atkins
Theoretically you can "train" it... -derek On Mon, October 21, 2024 4:54 pm, William Prescott wrote: > I used a .qfx file. It didn't occur to me to right-click on them and I > didn't see that in my short perusal of the documentation. I always try > things first, then read the documentation later o

Re: [GNC] How do I do a backup of Gnucash?

2024-10-21 Thread Kalpesh Patel
Here is a link to YouTube video to setup the built-in backup on Windows. https://www.youtube.com/watch?v=d3iAiAqMtvg While the demo is shown performed on Windows 11, it is good for backing up on MS Windows 7 and up. -Original Message- From: halatch1008 Sent: Wednesday, October 16, 202

Re: [GNC] Thank you to developers

2024-10-21 Thread Derek Atkins
Which import mechanism did you use? For QIF, there is a mapper from QIF Account and Payee/Memo to target Income/Expense account. For OFX and CSV, the importer has a way to assign them, but you need to right-click on each line to assign the account. -derek On Mon, October 21, 2024 4:25 pm, William

Re: [GNC] Split Actions

2024-10-21 Thread David Carlson
Now I am confused because I found the check box with the text that I quoted under Edit > Preferences > General as I stated previously. John is also right though, but the fly-over help is different there. Strange that it is in two places Is this a bug? On Mon, Oct 21, 2024 at 10:10 PM Adrien

Re: [GNC] transaction register date-picker pop-up box is transparent, makes choosing dates cumbersome.

2024-10-21 Thread Richard Ullger via gnucash-user
I'm running gnucash 4.14 on Arch Linux, Xfce with the Arc Dark theme and don't see that issue. Regards, Richard Original Message On 22/10/2024 01:47, John Ralls wrote: > That’s been reported before: https://bugs.gnucash.org/show_bug.cgi?id=798693 > . In that case it tur