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)
  Stock EIF:CA

I had changed the chart of accounts to:
Assets
  Asset Fidelity (in USD)
Asset Canada (in USD)
  Cash CAD (in CAD)
  Stock EIF:CA
so both the CAD cash and the Canada stock are a child of
an asset accout in USD.  The Advanced portfolio report is OK
(once I removed the USD price quote for the CAD stock).

Based upon your post, I have changed the chart of accounts to:
Assets
  Asset Fidelity (in USD)
Asset Canada (in CAD)
  Cash CAD (in CAD)
  Stock EIF:CA
so both the CAD cash and the Canada stock are a child of
an asset accout in CAD.  The Advanced portfolio report is OK.

On Mon, Oct 21, 2024 at 3:34 PM Derek Atkins  wrote:

> 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 9:06 am, Fred Tydeman wrote:
> > 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 stock was very wrong.
> > I left clicked on the blue highlighted Price.
> > The popup shows a date of last January.
> > I opened Tools: Price Database
> > There is a price for last January (but in USD, not CAD like the rest of
> > the
> > prices).
> > There is a CAD price for Oct 18, yet it is not being used in the report.
> >
> > I have removed the USD price entry from the Price Database and the report
> > is OK (after Reload).
> > Seems wrong to use a price from 9 months ago when there is a current
> > price.
> >
> > Also, not sure how USD prices are mixed in with CAD prices for a CAD
> > stock.
> > ___
> > 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.
> >
>
>
> --
>Derek Atkins 617-623-3745
>de...@ihtfp.com www.ihtfp.com
>Computer and Internet Security Consultant
>
>
___
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.


[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-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] 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 used for anything? For reports or something else?
[...]
> NOW  what element of THIS description of a split transaction are you
> referring to?  (when you day "different action")   For example, the
> action to close/enter/complete the transaction is the action "post to
> ledger". But I can't think of an action affecting just ONE of the lines.

Sorry, but I don't think this is a very helpful answer. The OP is clearly 
asking about the long list of Actions applicable to splits. Telling 
him/her about paper ledgers doesn't illuminate the matter, any more than 
it would if the question were about the format of the Date column.

Having said which, I can't answer the question either, except that AFAICT 
they don't affect the workings of the program.
___
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] 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 Wang  wrote:
> 
> 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/Contents/MacOS/gnucash-cli --quotes dump
> currency USD JPY
> ```
> gives
> ```
> JPY Finance::Quote returned no data and set no error.
> ```
> The same error message also appears in GUI (I have entered the API key
> in the preferences).
> 
> However, if I write a Perl script that directly calls Finance::Quote
> with my API key, I can get the USDJPY rate successfully.
> 
> * I'm also unable to change the quote source of currency rates from
> the security editor. The default is "Single - currency." When I change
> it to something else and hit OK, next time I open it, the source is
> reverted back to single.
> 
> I think this might be caused by GnuCash itself? Any hint on how I can
> circumvent this problem? Thanks!
> 
> Best,
> Chang
> ___
> 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] 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 convert everything... but if it is based in the UK,
I assume you would want it in GBP.

If I travel to Europe and purchase things there, I just enter it as USD
when I see the USD amount on the transaction.



On Mon, Oct 21, 2024 at 5:11 AM Jason Seegers 
wrote:

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


-- 
_
Richard Losey
rlo...@gmail.com
Micah 6:8
___
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] 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 field - you can type in
whatever you like. I tend to use Transfer, Check, DirectDebit, and Online.
I don't tend to use Actions for credit card entries.



On Mon, Oct 21, 2024 at 9:44 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
> ___
> 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.
>


-- 
_
Richard Losey
rlo...@gmail.com
Micah 6:8
___
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] 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 attachment, the links are stored in the 
'slots' table.


~mark petryk
~w:http://www.lorimarksolutions.com

On 10/21/24 13:25, Brook Milligan via gnucash-user wrote:

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 code on Github to try to figure out where the 
document links are handled, but I’m not finding anything.  Can anyone point me 
to the document link code?

If that is reasonable, it seems easy to add document links as a field to the 
export file, although there would have to be some way to detect the difference 
between prior exports and those with the extra field.  How have changes in 
export format be handled in the past?

Thanks for any pointers.

Cheers,
Brook

___
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] 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.  All the callbacks make that code unclear to me.

If anyone has a better sense of how importing works, please let me know how an 
extra field (doc links) can be added to the process.

Thanks a lot.

Cheers,
Brook



--- gnucash/import-export/csv-exp/csv-transactions-export.cpp.orig  
2024-10-21 13:06:24
+++ gnucash/import-export/csv-exp/csv-transactions-export.cpp   2024-10-21 
13:15:05
@@ -198,6 +198,14 @@
GNC_HOW_DENOM_SIGFIGS(6) | 
GNC_HOW_RND_ROUND_HALF_UP)
 : xaccSplitGetSharePrice (split)};
 return xaccPrintAmount (cf, gnc_default_price_print_info (curr));
+}
+
+// Document link
+static std::string
+get_document_link (Transaction *trans)
+{
+auto link{xaccTransGetDocLink (trans)};
+return (link ? link : "");
 }
 
 
/**/
@@ -243,7 +251,8 @@
 get_value (split, t_void, false),
 get_reconcile (split),
 get_reconcile_date (split),
-get_price (split, t_void)
+get_price (split, t_void),
+get_document_link (trans)
 };
 }
 
@@ -389,6 +398,7 @@
 _("Reconcile"),
 _("Reconcile Date"),
 _("Rate/Price"),
+_("Document link"),
 };
 
 /* Write header line */

___
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] 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 Mariappan 
Cc: gnucash-user@gnucash.org 
Subject: Re: [GNC] Changing currency and raising foreign currency invoices


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@gnucash.org 
Subject: Re: [GNC] Changing currency and raising foreign currency invoices

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



From: gnucash-user 
 on behalf of 
Jason Seegers 
Sent: 21 October 2024 15:35
To: R Losey 
Cc: gnucash-user@gnucash.org 
Subject: Re: [GNC] Changing currency and raising foreign currency invoices



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

So I think I have figured it out for now.

From: R Losey 
Sent: 21 October 2024 12:13
To: Jason Seegers 
Cc: gnucash-user@gnucash.org 
Subject: Re: [GNC] Changing currency and raising foreign currency invoices

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 convert everything... but if it is based in the UK, I 
assume you would want it in GBP.

If I travel to Europe and purchase things there, I just enter it as USD when I 
see the USD amount on the transaction.



On Mon, Oct 21, 2024 at 5:11 AM Jason Seegers 
mailto:jason.onl...@outlook.com>> wrote:
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.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://na01.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.gnucash.org%2Fmailman%2Flistinfo%2Fgnucash-user&data=05%7C02%7C%7C7506ca0128c440779ab208dcf1ff5b77%7C84df9e7fe9f640afb435%7C1%7C0%7C638651326270601036%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C0%7C%7C%7C&sdata=rG4MaKGUsb507eXI6H9Azuvl96YoisbJ3sNjaC3Ps3I%3D&reserved=0
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


--
_
Richard Losey
rlo...@gmail.com
Micah 6:8
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://na01.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.gnucash.org%2Fmailman%2Flistinfo%2Fgnucash-user&data=05%7C02%7C%7C7506ca0128c440779ab208dcf1ff5b77%7C84df9e7fe9f640afb435%7C1%7C0%7C638651326270618297%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C0%7C%7C%7C&sdata=SXd%2FKYbDAcQwm9inBCVjj%2BH748%2BPk7uKVFKexwmLp88%3D&reserved=0
-
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] 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. 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 Oct 2024, at 14:45, Derek Atkins  wrote:
>>
>> 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 Prescott wrote:
>>> 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 returned from a trip where I
>>> used
>>> Apple Pay on my phone to pay for everything. So every minor thing I
>did
>>> was a separate transaction. I had 72 lines on my credit card
>statement.
>>>
>>> I imported it into Gnucash with no problem.  The only thing  that
>could
>>> have been better was setting the account for all of the
>transactions.
>>> One
>>> side was the credit card account and that worked fine. But it set
>the
>>> other side to "Imbalance-USD". I didn't see a way to change that on
>all
>>> of
>>> them before the import. So I went through and changed them all
>manually
>>> after the import. It was still a lot easier than entering them
>manually.
>>>
>>> In hindsight, I think I probably could have imported just one of
>them,
>>> set
>>> the account correctly on it. Then imported the rest and it might
>have
>>> known better what to do with them.
>>>
>>> I any event, learning to use the import function was a big time
>saver
>>> that
>>> I will make more use of in the future. And I wanted to thank the
>>> developers for providing it.
>>>
>>> Thank you.
>>>
>>> Best wishes,
>>> Will
>>>
>>> ___
>>> 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.
>>>
>>
>>
>> --
>>   Derek Atkins 617-623-3745
>>   de...@ihtfp.com www.ihtfp.com
>>   Computer and Internet Security Consultant
>>
>>
>> ___
>> 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.
>>
>
>
>-- 
>   Derek Atkins 617-623-3745
>   de...@ihtfp.com www.ihtfp.com
>   Computer and Internet Security Consultant
>
>___
>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] 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 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 although I think it will be redacted by the server.

[I have removed the image as the original post was returned as rejected. How do 
we post images in the mailing system?]


___
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] 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 9:06 am, Fred Tydeman wrote:
> 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 stock was very wrong.
> I left clicked on the blue highlighted Price.
> The popup shows a date of last January.
> I opened Tools: Price Database
> There is a price for last January (but in USD, not CAD like the rest of
> the
> prices).
> There is a CAD price for Oct 18, yet it is not being used in the report.
>
> I have removed the USD price entry from the Price Database and the report
> is OK (after Reload).
> Seems wrong to use a price from 9 months ago when there is a current
> price.
>
> Also, not sure how USD prices are mixed in with CAD prices for a CAD
> stock.
> ___
> 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.
>


-- 
   Derek Atkins 617-623-3745
   de...@ihtfp.com www.ihtfp.com
   Computer and Internet Security Consultant

___
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] 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 Users 
Subject: [GNC] Advanced portfolio

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 stock was very wrong.
I left clicked on the blue highlighted Price.
The popup shows a date of last January.
I opened Tools: Price Database
There is a price for last January (but in USD, not CAD like the rest of the
prices).
There is a CAD price for Oct 18, yet it is not being used in the report.

I have removed the USD price entry from the Price Database and the report
is OK (after Reload).
Seems wrong to use a price from 9 months ago when there is a current price.

Also, not sure how USD prices are mixed in with CAD prices for a CAD stock.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://na01.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.gnucash.org%2Fmailman%2Flistinfo%2Fgnucash-user&data=05%7C02%7C%7C8c82322afc964f6ed1ee08dcf1d17939%7C84df9e7fe9f640afb435%7C1%7C0%7C638651129214349087%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C0%7C%7C%7C&sdata=jx%2BZMo%2FZFts4Jd%2FJkxpEik%2FH1d2yK4CKXp155XUOu%2FQ%3D&reserved=0
-
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] 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 although I think it will be redacted by the server.
> 
> [I have removed the image as the original post was returned as
> rejected. How do we post images in the mailing system?]

The Gnucash server for mail has been disconnected from the internet for
a couple of days.
I think that is why you have struck some difficulties.

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


[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 stock was very wrong.
I left clicked on the blue highlighted Price.
The popup shows a date of last January.
I opened Tools: Price Database
There is a price for last January (but in USD, not CAD like the rest of the
prices).
There is a CAD price for Oct 18, yet it is not being used in the report.

I have removed the USD price entry from the Price Database and the report
is OK (after Reload).
Seems wrong to use a price from 9 months ago when there is a current price.

Also, not sure how USD prices are mixed in with CAD prices for a CAD stock.
___
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.


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


[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
point everything should have come back.

This outage affected code, which runs email, wiki, and git (among others).
 If you still see any issues please let me know.

Sorry for any inconvenience..

-derek

-- 
   Derek Atkins 617-623-3745
   de...@ihtfp.com www.ihtfp.com
   Computer and Internet Security Consultant

___
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] 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 can be attached (not MIME-included) to make it through the list.

Enjoy!

-derek

On Mon, October 21, 2024 6:26 am, Liz wrote:
> 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 although I think it will be redacted by the server.
>>
>> [I have removed the image as the original post was returned as
>> rejected. How do we post images in the mailing system?]
>
> The Gnucash server for mail has been disconnected from the internet for
> a couple of days.
> I think that is why you have struck some difficulties.
>
> Liz
> ___
> 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.
>


-- 
   Derek Atkins 617-623-3745
   de...@ihtfp.com www.ihtfp.com
   Computer and Internet Security Consultant

___
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] 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 somewhere like a sweep account. I cannot tell if you have both
a USD sweep and a CHF sweep; if you do, I'd create a subaccount for each.
Then I'd create an entry in the Security for the VT mutual fund, and create
a subaccount in IBKR something like IBKR-VT that tracks the VT shares you
own. Each buy or sell of VT will be its own transaction, with the funds
coming from the USD sweep.  Money you send to IBKR will, I assume, go into
the CHF sweep, and then either manually or automatically, get converted to
USD as you make purchases.

Dividends are just another transaction; if you are reinvesting dividends,
you'll add the transaction, but the "other" account will be some dividend
income account - for me, I have an "Income:Investment
Income:Taxable:Dividends" account for these things. Dividends that are not
reinvested, will be entered in the sweep fund instead of purchasing more of
the mutual fund, but would still be assigned to the dividend account.



On Sun, Oct 20, 2024 at 7:04 PM Boniforti Flavio 
wrote:

> Hi all.
>
> I'd like to get some suggestions/guidance and eventually validate if my way
> of doing this is correct.
>
> I've put some money into IBKR (CHF) which I then converted into USD to buy
> VT. For the time being, I've just added the transactions in the "CHF Cash"
> account on IBKR, where I now see the actual money I put there. Now there's
> a few questions I can't answer on my own.
>
> As of today there is still some cash left on both CHF and USD accounts
> (peanuts, just to cover currency conversion fees), and the rest is invested
> in VT, how should I proceed to enter the various transactions, so that it
> finally reflects the actual status (some CHF Cash, come USD Cash and the
> rest in VT)?
>
> I bought VT like 4 or 5 times, of course at different stock prices.
>
> Should I create a sub-account called "VT" (type "mutual funds"), then add
> each purchase transaction by taking the money from my "USD Cash" account,
> until the balance corresponds to the actual one on IBKR?
> Of course, in advance I would need to add the CHF-to-USD currency
> conversion for each time I bought VT shares. Here I don't know if I should
> add a sub-account related to conversion fees or not.
>
> Last but not least: when I will have set things right (which means having
> the CHF and USD cash accounts showing the actual/real amount and also the
> VT number of shares), will it be enough to update the VT share price
> manually to see how much I do have on IBKR?
>
> And how do I deal with dividends? Should I add another sub-account for the
> dividends? I automatically reinvest dividends in VT - how to deal with
> this?
>
> I know it's a bunch of questions, but maybe some kind soul will be able to
> help me walking through this :-)
>
> Thanks,
> F.
>
>
> https://www.instagram.com/boniforti_music
> https://soundcloud.com/boniforti_music
> https://bonny-j.bandcamp.com
> ___
> 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.
>


-- 
_
Richard Losey
rlo...@gmail.com
Micah 6:8
___
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] 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 on the New Book Options dialog for the Use Split
Action Field for Number
setting will be selected and, if saved, the book option for the new file
will be set so that the "Num" field
on registers shows/updates the split-action field and the transaction-num
field is shown on the second
line in double line mode (and is not visible in single line mode).
Otherwise, the displayed setting on
the dialog will not be selected and, if saved, the book option for the new
file will be set so that the
"Num" field on registers shows/updates the transaction-num field. See the
discussion in the section
called “Book Options” about how to set book options including the option
for the section called “Use
Split Action Field for Number”. Regardless of the setting of this
preference, the user can modify the
initially displayed setting for this option on the New Book Options dialog
before saving the options."

However, it does not cover a list of actions that might appear there as the
OP is asking for information about.
I too cannot find more information than this.



On Mon, Oct 21, 2024 at 12:20 PM R Losey  wrote:

> 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 field - you can type in
> whatever you like. I tend to use Transfer, Check, DirectDebit, and Online.
> I don't tend to use Actions for credit card entries.
>
>
>
> On Mon, Oct 21, 2024 at 9:44 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
> > ___
> > 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.
> >
>
>
> --
> _
> Richard Losey
> rlo...@gmail.com
> Micah 6:8
> ___
> 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.
>


-- 
David Carlson
___
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] 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 you are asking about. What "different actions"?

In a case like this can be useful to consider the JOURNAL ENTRY as it 
would have been done in the days of pen and ink on paper. After all, 
when you enter a "split transaction" in gnucash you are in Journal Entry 
mode. With large space meaning new line.


Date   check number    postedimmediately posted to ledger>                  debit account1  amountd1 
debit account2  amountd2   debit accountn amountdn 
                < indented>   credit account1   amountc1    
. credit accountcm amountcm              
         description of transaction


When posted to the ledger, the line for each account will appear in the 
ledger for the corresponding  account, same description (there only was 
one for the entire transaction)  and when on paper that line  would have 
a  Journal page number << not used by gnucash, the journal is virtual 
and unpaged: in pen and paper days, this Journal page number told you 
where to go to see the rest of the transaction>>


NOW  what element of THIS description of a split transaction are you 
referring to?  (when you day "different action")   For example, the 
action to close/enter/complete the transaction is the action "post to 
ledger". But I can't think of an action affecting just ONE of the lines.


Michael D Novack


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


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 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  hotmail@gnucash.org> on behalf of Fred Tydeman  >
> *Sent:* 21 October 2024 10:06
> *To:* Gnucash Users 
> *Subject:* [GNC] Advanced portfolio
>
> 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 stock was very wrong.
> I left clicked on the blue highlighted Price.
> The popup shows a date of last January.
> I opened Tools: Price Database
> There is a price for last January (but in USD, not CAD like the rest of the
> prices).
> There is a CAD price for Oct 18, yet it is not being used in the report.
>
> I have removed the USD price entry from the Price Database and the report
> is OK (after Reload).
> Seems wrong to use a price from 9 months ago when there is a current price.
>
> Also, not sure how USD prices are mixed in with CAD prices for a CAD stock.
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
>
> https://na01.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.gnucash.org%2Fmailman%2Flistinfo%2Fgnucash-user&data=05%7C02%7C%7C8c82322afc964f6ed1ee08dcf1d17939%7C84df9e7fe9f640afb435%7C1%7C0%7C638651129214349087%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C0%7C%7C%7C&sdata=jx%2BZMo%2FZFts4Jd%2FJkxpEik%2FH1d2yK4CKXp155XUOu%2FQ%3D&reserved=0
> 
> -
> 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.


[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/Contents/MacOS/gnucash-cli --quotes dump
currency USD JPY
```
gives
```
JPY Finance::Quote returned no data and set no error.
```
The same error message also appears in GUI (I have entered the API key
in the preferences).

However, if I write a Perl script that directly calls Finance::Quote
with my API key, I can get the USDJPY rate successfully.

* I'm also unable to change the quote source of currency rates from
the security editor. The default is "Single - currency." When I change
it to something else and hit OK, next time I open it, the source is
reverted back to single.

I think this might be caused by GnuCash itself? Any hint on how I can
circumvent this problem? Thanks!

Best,
Chang
___
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] 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 of us wanting to download Australian share 
prices without the heavy lifting 😩?

Ernie


Sent from my iPhone

> On 21 Oct 2024, at 1:44 PM, Kalpesh Patel  wrote:
> 
> I looked at it and sadly the tech that they are using requires client 
> side java script side processing. I couldn't find a java script 
> interpreter that lived strictly within Perl so would have to tie into 
> virtual browser (like Selenium framework) launched from Perl but that 
> dependencies are a no go with F::Q since it would require heavy lift from the 
> end-user.
> 
> -Original Message-
> From: John Ralls 
> Sent: Saturday, October 19, 2024 10:42 PM
> To: sunfish62--- via gnucash-user 
> Subject: [GNC] Australian Stock Exchange Module in Finance::Quote
> 
> I know we have a number of Australians here who have stock traded on 
> the Australian Stock Exchange and use Finance::Quote.  Bruce called my 
> attention today to 
> https://github.com/finance-quote/finance-quote/issues/404 and that he 
> intends to remove the ASX module from the next release. If any of you have 
> the perl chops to take on finding a solution, now is the time.
> 
> Regards,
> John Ralls
> '
> 
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> 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.


[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 code on Github to try to figure out where the 
document links are handled, but I’m not finding anything.  Can anyone point me 
to the document link code?

If that is reasonable, it seems easy to add document links as a field to the 
export file, although there would have to be some way to detect the difference 
between prior exports and those with the extra field.  How have changes in 
export format be handled in the past?

Thanks for any pointers.

Cheers,
Brook

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

So I think I have figured it out for now.

From: R Losey 
Sent: 21 October 2024 12:13
To: Jason Seegers 
Cc: gnucash-user@gnucash.org 
Subject: Re: [GNC] Changing currency and raising foreign currency invoices

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 convert everything... but if it is based in the UK, I 
assume you would want it in GBP.

If I travel to Europe and purchase things there, I just enter it as USD when I 
see the USD amount on the transaction.



On Mon, Oct 21, 2024 at 5:11 AM Jason Seegers 
mailto:jason.onl...@outlook.com>> wrote:
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.
___
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.


--
_
Richard Losey
rlo...@gmail.com
Micah 6:8
___
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] 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 registers, and to select them in some reports. The 
business module might use them, I’m not sure about that. There are GnuCash 
features that will set them, for example the Stock Assistant, Stock Split 
Assistant, Lot Scrubber, and bill/invoice processing code.

David is half right that there’s an option to flip the action and number fields 
but it’s in File>Properiies on the Accounts tab, not in Preferences. That’s 
more useful only if you don’t use actions much but do need to assign different 
numbers to splits in a single transaction.

Regards,
John Ralls


> On Oct 21, 2024, at 11:05, David Carlson  wrote:
> 
> 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 on the New Book Options dialog for the Use Split
> Action Field for Number
> setting will be selected and, if saved, the book option for the new file
> will be set so that the "Num" field
> on registers shows/updates the split-action field and the transaction-num
> field is shown on the second
> line in double line mode (and is not visible in single line mode).
> Otherwise, the displayed setting on
> the dialog will not be selected and, if saved, the book option for the new
> file will be set so that the
> "Num" field on registers shows/updates the transaction-num field. See the
> discussion in the section
> called “Book Options” about how to set book options including the option
> for the section called “Use
> Split Action Field for Number”. Regardless of the setting of this
> preference, the user can modify the
> initially displayed setting for this option on the New Book Options dialog
> before saving the options."
> 
> However, it does not cover a list of actions that might appear there as the
> OP is asking for information about.
> I too cannot find more information than this.
> 
> 
> 
> On Mon, Oct 21, 2024 at 12:20 PM R Losey  wrote:
> 
>> 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 field - you can type in
>> whatever you like. I tend to use Transfer, Check, DirectDebit, and Online.
>> I don't tend to use Actions for credit card entries.
>> 
>> 
>> 
>> On Mon, Oct 21, 2024 at 9:44 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
>>> ___
>>> 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.
>>> 
>> 
>> 
>> --
>> _
>> Richard Losey
>> rlo...@gmail.com
>> Micah 6:8
>> ___
>> 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.
>> 
> 
> 
> -- 
> David Carlson
> ___
> 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.


[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 dates from underlying text. I found "dense calendar setting" that can
be placed in gtk-3.0.css (right file name?) but the issue is not with the
calendar, it is actually with the pop-up box transparent background.
Is there a way to make the pop-up box opaque?

System info: Linux - Gnucash all versions 4 and 5 built from tar.gz
downloads
Kernel: 6.10.8-1-liquorix-amd64 x86_64 bits, desktop: Xfce v:
4.18.1 tk: Gtk v: 3.24.36, Distro: MX-23.4_ahs_x64, base: Debian GNU/Linux
12 (bookworm)
Desktop: Xfce v: 4.18.1 tk: Gtk v: 3.24.36  Distro: MX-23.4_ahs_x64
Libretto July 31  2023 base: Debian GNU/Linux 12 (bookworm)

-- 
Mike
___
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] 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 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 dates from underlying text. I found "dense calendar setting" that can
> be placed in gtk-3.0.css (right file name?) but the issue is not with the
> calendar, it is actually with the pop-up box transparent background.
> Is there a way to make the pop-up box opaque?
> 
> System info: Linux - Gnucash all versions 4 and 5 built from tar.gz
> downloads
>Kernel: 6.10.8-1-liquorix-amd64 x86_64 bits, desktop: Xfce v:
> 4.18.1 tk: Gtk v: 3.24.36, Distro: MX-23.4_ahs_x64, base: Debian GNU/Linux
> 12 (bookworm)
>Desktop: Xfce v: 4.18.1 tk: Gtk v: 3.24.36  Distro: MX-23.4_ahs_x64
> Libretto July 31  2023 base: Debian GNU/Linux 12 (bookworm)
> 
> -- 
> Mike
> ___
> 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] 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 is meaningful/particular, 
because if you have more than one, and you edit the payment, it seems 
GnuCash uses this action label to alert you that there is more than one 
'payment' in this transaction, and then asks you to choose which one you 
want to edit. (there could also be a hidden key affecting this, but I 
haven't investigated that. The action field is certainly not hidden though)


Regards,
Adrien

On 10/21/24 10:03 PM, Adrien Monteleone wrote:
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)


___
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] 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 "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 or not at all. Sometimes
>>  that bites me.
>> 
>>  Will it remember assignments next time?
>> 
>>  Best wishes,
>>  Will
>> 
>>  On 21 Oct 2024, at 14:45, Derek Atkins  wrote:
>> 
>>  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 Prescott wrote:
>>>  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 returned from a trip where I
>>>  used
>>>  Apple Pay on my phone to pay for everything. So every minor thing I did
>>>  was a separate transaction. I had 72 lines on my credit card statement.
>>> 
>>>  I imported it into Gnucash with no problem.  The only thing  that could
>>>  have been better was setting the account for all of the transactions.
>>>  One
>>>  side was the credit card account and that worked fine. But it set the
>>>  other side to "Imbalance-USD". I didn't see a way to change that on all
>>>  of
>>>  them before the import. So I went through and changed them all manually
>>>  after the import. It was still a lot easier than entering them manually.
>>> 
>>>  In hindsight, I think I probably could have imported just one of them,
>>>  set
>>>  the account correctly on it. Then imported the rest and it might have
>>>  known better what to do with them.
>>> 
>>>  I any event, learning to use the import function was a big time saver
>>>  that
>>>  I will make more use of in the future. And I wanted to thank the
>>>  developers for providing it.
>>> 
>>>  Thank you.
>>> 
>>>  Best wishes,
>>>  Will
>>> 
>>> 
>>>  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.
>> 
>> 
>> 
>>  --
>>Derek Atkins 617-623-3745
>>de...@ihtfp.com www.ihtfp.com 
>>Computer and Internet Security Consultant
>> 
>> 
>> 
>>  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] 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 wrote:
The business module might use them, I’m not sure about that.

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


From: gnucash-user 
 on behalf of 
Jason Seegers 
Sent: 21 October 2024 15:35
To: R Losey 
Cc: gnucash-user@gnucash.org 
Subject: Re: [GNC] Changing currency and raising foreign currency invoices

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

So I think I have figured it out for now.

From: R Losey 
Sent: 21 October 2024 12:13
To: Jason Seegers 
Cc: gnucash-user@gnucash.org 
Subject: Re: [GNC] Changing currency and raising foreign currency invoices

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 convert everything... but if it is based in the UK, I 
assume you would want it in GBP.

If I travel to Europe and purchase things there, I just enter it as USD when I 
see the USD amount on the transaction.



On Mon, Oct 21, 2024 at 5:11 AM Jason Seegers 
mailto:jason.onl...@outlook.com>> wrote:
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.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://na01.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.gnucash.org%2Fmailman%2Flistinfo%2Fgnucash-user&data=05%7C02%7C%7C7506ca0128c440779ab208dcf1ff5b77%7C84df9e7fe9f640afb435%7C1%7C0%7C638651326270601036%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C0%7C%7C%7C&sdata=rG4MaKGUsb507eXI6H9Azuvl96YoisbJ3sNjaC3Ps3I%3D&reserved=0
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


--
_
Richard Losey
rlo...@gmail.com
Micah 6:8
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://na01.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.gnucash.org%2Fmailman%2Flistinfo%2Fgnucash-user&data=05%7C02%7C%7C7506ca0128c440779ab208dcf1ff5b77%7C84df9e7fe9f640afb435%7C1%7C0%7C638651326270618297%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C0%7C%7C%7C&sdata=SXd%2FKYbDAcQwm9inBCVjj%2BH748%2BPk7uKVFKexwmLp88%3D&reserved=0
-
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.


[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 returned from a trip where I used Apple 
Pay on my phone to pay for everything. So every minor thing I did was a 
separate transaction. I had 72 lines on my credit card statement.

I imported it into Gnucash with no problem.  The only thing  that could have 
been better was setting the account for all of the transactions. One side was 
the credit card account and that worked fine. But it set the other side to 
"Imbalance-USD". I didn't see a way to change that on all of them before the 
import. So I went through and changed them all manually after the import. It 
was still a lot easier than entering them manually.

In hindsight, I think I probably could have imported just one of them, set the 
account correctly on it. Then imported the rest and it might have known better 
what to do with them.

I any event, learning to use the import function was a big time saver that I 
will make more use of in the future. And I wanted to thank the developers for 
providing it.

Thank you.

Best wishes,
Will

___
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] 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 Oct 2024, at 14:45, Derek Atkins  wrote:

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 Prescott wrote:
> 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 returned from a trip where I used
> Apple Pay on my phone to pay for everything. So every minor thing I did
> was a separate transaction. I had 72 lines on my credit card statement.
> 
> I imported it into Gnucash with no problem.  The only thing  that could
> have been better was setting the account for all of the transactions. One
> side was the credit card account and that worked fine. But it set the
> other side to "Imbalance-USD". I didn't see a way to change that on all of
> them before the import. So I went through and changed them all manually
> after the import. It was still a lot easier than entering them manually.
> 
> In hindsight, I think I probably could have imported just one of them, set
> the account correctly on it. Then imported the rest and it might have
> known better what to do with them.
> 
> I any event, learning to use the import function was a big time saver that
> I will make more use of in the future. And I wanted to thank the
> developers for providing it.
> 
> Thank you.
> 
> Best wishes,
> Will
> 
> ___
> 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.
> 


-- 
  Derek Atkins 617-623-3745
  de...@ihtfp.com www.ihtfp.com
  Computer and Internet Security Consultant


___
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] 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@gnucash.org 
Subject: Re: [GNC] Changing currency and raising foreign currency invoices
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


From: gnucash-user 
 on behalf of 
Jason Seegers 
Sent: 21 October 2024 15:35
To: R Losey 
Cc: gnucash-user@gnucash.org 
Subject: Re: [GNC] Changing currency and raising foreign currency invoices

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

So I think I have figured it out for now.

From: R Losey 
Sent: 21 October 2024 12:13
To: Jason Seegers 
Cc: gnucash-user@gnucash.org 
Subject: Re: [GNC] Changing currency and raising foreign currency invoices

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 convert everything... but if it is based in the UK, I 
assume you would want it in GBP.

If I travel to Europe and purchase things there, I just enter it as USD when I 
see the USD amount on the transaction.



On Mon, Oct 21, 2024 at 5:11 AM Jason Seegers 
mailto:jason.onl...@outlook.com>> wrote:
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.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://na01.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.gnucash.org%2Fmailman%2Flistinfo%2Fgnucash-user&data=05%7C02%7C%7C7506ca0128c440779ab208dcf1ff5b77%7C84df9e7fe9f640afb435%7C1%7C0%7C638651326270601036%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C0%7C%7C%7C&sdata=rG4MaKGUsb507eXI6H9Azuvl96YoisbJ3sNjaC3Ps3I%3D&reserved=0
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


--
_
Richard Losey
rlo...@gmail.com
Micah 6:8
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://na01.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.gnucash.org%2Fmailman%2Flistinfo%2Fgnucash-user&data=05%7C02%7C%7C7506ca0128c440779ab208dcf1ff5b77%7C84df9e7fe9f640afb435%7C1%7C0%7C638651326270618297%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C0%7C%7C%7C&sdata=SXd%2FKYbDAcQwm9inBCVjj%2BH748%2BPk7uKVFKexwmLp88%3D&reserved=0
-
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] 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 or not at all. Sometimes
> that bites me.
>
> Will it remember assignments next time?
>
> Best wishes,
> Will
>
> On 21 Oct 2024, at 14:45, Derek Atkins  wrote:
>
> 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 Prescott wrote:
>> 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 returned from a trip where I
>> used
>> Apple Pay on my phone to pay for everything. So every minor thing I did
>> was a separate transaction. I had 72 lines on my credit card statement.
>>
>> I imported it into Gnucash with no problem.  The only thing  that could
>> have been better was setting the account for all of the transactions.
>> One
>> side was the credit card account and that worked fine. But it set the
>> other side to "Imbalance-USD". I didn't see a way to change that on all
>> of
>> them before the import. So I went through and changed them all manually
>> after the import. It was still a lot easier than entering them manually.
>>
>> In hindsight, I think I probably could have imported just one of them,
>> set
>> the account correctly on it. Then imported the rest and it might have
>> known better what to do with them.
>>
>> I any event, learning to use the import function was a big time saver
>> that
>> I will make more use of in the future. And I wanted to thank the
>> developers for providing it.
>>
>> Thank you.
>>
>> Best wishes,
>> Will
>>
>> ___
>> 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.
>>
>
>
> --
>   Derek Atkins 617-623-3745
>   de...@ihtfp.com www.ihtfp.com
>   Computer and Internet Security Consultant
>
>
> ___
> 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.
>


-- 
   Derek Atkins 617-623-3745
   de...@ihtfp.com www.ihtfp.com
   Computer and Internet Security Consultant

___
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] 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, 2024 8:59 AM
To: gnucash-user@gnucash.org
Subject: [GNC] How do I do a back up of Gnucash?

Could someone write a step by step of Instruction on how to Back up all my 
Gnucash files together with the program, in case my computer dies.Thanks,Heidi 
LatchSent from my Verizon, Samsung Galaxy smartphone
 Original message From: gnucash-user-requ...@gnucash.org Date: 
10/15/24  12:06 PM  (GMT-05:00) To: gnucash-user@gnucash.org Subject: 
gnucash-user Digest, Vol 259, Issue 31 Send gnucash-user mailing list 
submissions to   gnucash-user@gnucash.orgTo subscribe or unsubscribe via 
the World Wide Web, visit   
https://lists.gnucash.org/mailman/listinfo/gnucash-useror, via email, send a 
message with subject or body 'help' to gnucash-user-request@gnucash.orgYou 
can reach the person managing the list at   gnucash-user-owner@gnucash.orgWhen 
replying, please edit your Subject line so it is more specificthan "Re: 
Contents of gnucash-user digest..."Today's Topics:   1. Re:  What files in my 
in my business folder need to be backed  up? (R Losey)   2. Re:  ANNOUNCE: 
GnuCash 5.9 Released (R Losey)   3. Re:  ANNOUNCE: GnuCash 5.9 Released (R 
Losey)   4. Re:  Reconciling duplicate entries of same transaction (R 
Losey)--Mes
 sage: 1Date: Mon, 14 Oct 2024 19:06:00 -0500From: R Losey 
To: Dan a1TNC Cc: 
gnucash-user@gnucash.orgSubject: Re: [GNC] What files in my in my business 
folder need to be backed up?Message-ID:   
Content-Type:
 text/plain; charset="UTF-8"What to back up in part is a factor of how hard it 
would be to re-createthe data if lost...Family pictures with kids when they 
were young, or of relatives who are nolonger around are irreplaceable, and thus 
are VERY important to have thesevery secure. A picture of a local attraction 
that is still there -- well,if the picture is lost, you can take another one.In 
the matter of GnuCash, the absolutely must back up is the data file withthe 
transactions, since this would incredibly difficult (if not impossible)to 
re-create.  Most of us don't need to back up the backup files or the 
logfiles.But then there are the in-between files: any saved report 
configurations
 and your GnuCash preferences. If these were lost, they could be redone, butit 
may be a level of inconvenience.  I was zealously backing up my datafile, and 
didn't even think about my preferences or saved report files...the computer 
died and I lost those.  But since the preferences were mine, Ijust re-tweaked 
GnuCash on the new computer to be how I wanted it. Thereports I lost were more 
irksome, but I was also able to re-create them.They are backed up now, but 
still not with the same level of assurance asthe data file is backed up.As 
another user wrote, the documentation is good about where these threethings can 
be found.On Sat, Oct 12, 2024 at 11:50?AM Dan a1TNC  wrote:> 
What files in my in my business folder  need to be backed up?>> I'm running my 
Gnu Cash on a windows machine which have to be stored on the> local drive. 
Backing up the needed files in case of computer failure is> always a good 
practice. I have been learning how to use GnuC and found the> files there 
 are better than 100 files for 4 days of use. Will the last Text> file and the 
last "GNUCash Financial Data" file be all I need to copy to a> cloud? Or do I 
need to copy all of them? Thx in advance>> --> This email has been 
checked for viruses by AVG antivirus software.> www.avg.com> 
___> 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.>-- _Richard 
Loseyrlosey@gmail.comMicah 6:8--Message: 2Date: 
Mon, 14 Oct 2024 19:09:15 -0500From: R Losey To: Boniforti 
Flavio Cc: adrien.montele...@lusfiber.net, 
gnucash-user@lists.gnucash.orgSubject: Re: [GNC] ANNOUNCE: GnuCash 5.9 
ReleasedMessage-ID: Content-Type: text/plain; 
charset="UTF-8"You can't get it from gnucash.org?On Sun, Oct 13, 2024 at 
5:44?AM Boniforti Flavio wrote:> Hi all.> Does anybody 
know when the latest 5.9 release will be available for Windows> via winget?> 
F.>> Adrien Monteleone  schrieb am So., 13.> 
Okt.> 2024, 03:20:>> > Joseph,> >> > Those are the direct download links in the 
e-mail, which eventually> > appear on the website. They usually are already 
there by the time this> > announcement goes out, but occasional

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 Prescott wrote:
> 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 returned from a trip where I used
> Apple Pay on my phone to pay for everything. So every minor thing I did
> was a separate transaction. I had 72 lines on my credit card statement.
>
> I imported it into Gnucash with no problem.  The only thing  that could
> have been better was setting the account for all of the transactions. One
> side was the credit card account and that worked fine. But it set the
> other side to "Imbalance-USD". I didn't see a way to change that on all of
> them before the import. So I went through and changed them all manually
> after the import. It was still a lot easier than entering them manually.
>
> In hindsight, I think I probably could have imported just one of them, set
> the account correctly on it. Then imported the rest and it might have
> known better what to do with them.
>
> I any event, learning to use the import function was a big time saver that
> I will make more use of in the future. And I wanted to thank the
> developers for providing it.
>
> Thank you.
>
> Best wishes,
> Will
>
> ___
> 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.
>


-- 
   Derek Atkins 617-623-3745
   de...@ihtfp.com www.ihtfp.com
   Computer and Internet Security Consultant

___
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] 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 Monteleone <
adrien.montele...@lusfiber.net> wrote:

> 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 is meaningful/particular,
> because if you have more than one, and you edit the payment, it seems
> GnuCash uses this action label to alert you that there is more than one
> 'payment' in this transaction, and then asks you to choose which one you
> want to edit. (there could also be a hidden key affecting this, but I
> haven't investigated that. The action field is certainly not hidden though)
>
> Regards,
> Adrien
>
> On 10/21/24 10:03 PM, Adrien Monteleone wrote:
> > 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)
>
> ___
> 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.
>


-- 
David Carlson
___
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] 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 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 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 dates from underlying text. I found "dense calendar setting" that can
>  > be placed in gtk-3.0.css (right file name?) but the issue is not with the
>  > calendar, it is actually with the pop-up box transparent background.
>  > Is there a way to make the pop-up box opaque?
>  >
>  > System info: Linux - Gnucash all versions 4 and 5 built from tar.gz
>  > downloads
>  >Kernel: 6.10.8-1-liquorix-amd64 x86_64 bits, desktop: Xfce v:
>  > 4.18.1 tk: Gtk v: 3.24.36, Distro: MX-23.4_ahs_x64, base: Debian GNU/Linux
>  > 12 (bookworm)
>  >Desktop: Xfce v: 4.18.1 tk: Gtk v: 3.24.36  Distro: MX-23.4_ahs_x64
>  > Libretto July 31  2023 base: Debian GNU/Linux 12 (bookworm)
>  >
>  > --
>  > Mike
>  > ___
>  > 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.
>


signature.asc
Description: OpenPGP digital signature
___
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.