Re: [GNC] Find account

2024-03-30 Thread david whiting
Do you mean find all accounts with a given string in the account name?

Edit > Find Account (Ctrl+I) brings up a search window (it doesn't
work if you are in a report, so go to an account register or your
chart of accounts).

David


On Sat, 30 Mar 2024 at 01:36, Fred Tydeman  wrote:
>
> Is there a way to find all accounts that contain a given string?
> I am looking for *quote* somewhere in the account name.
>
> Gnucash 4.14 on Fedora Linux
> ___
> 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 Whiting
___
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] Find account

2024-03-30 Thread Fred Tydeman
Thank you.  That worked.
I was trying to use Ctrl-F while in Chart of Accounts.

On Sat, Mar 30, 2024 at 12:39 AM david whiting 
wrote:

> Do you mean find all accounts with a given string in the account name?
>
> Edit > Find Account (Ctrl+I) brings up a search window (it doesn't
> work if you are in a report, so go to an account register or your
> chart of accounts).
>
> David
>
>
> On Sat, 30 Mar 2024 at 01:36, Fred Tydeman  wrote:
> >
> > Is there a way to find all accounts that contain a given string?
> > I am looking for *quote* somewhere in the account name.
> >
> > Gnucash 4.14 on Fedora Linux
> > ___
> > 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 Whiting
>
___
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] Reconcile window Start Balance, & Reconciled became UnReconciled

2024-03-30 Thread Tom Balazs
I went to reconcile a recent credit card statement today. But I noticed
something was incorrect. I traced back a problem to about three months
prior. Apparently what happened is that my credit card statements were
reconciled. But recently I reconciled a few months worth of statements for
a checking account. I think what happened is I added or deleted a transfer
from checking to credit card (pay down the balance).

Fortunately on the last day of the statement period I add a transaction
Description: Balance here should be $150
Transaction amount = 0
Category Miscellaneous
Balance column: should show $150.
Usually it does. Today it was my indicator that something went wrong.

But now I'm having a problem reconciling my statements.
Somehow the work I did lead to a problem in Reconcile window Start Balance.
I marke all transactions as reconciled.
The reconcile window says that there is a difference of $19. So it won't
let me click Reconcile.
But when I look at my end of statement.
I see:
Description: Balance here should be $150
And the actual Balance column does show $150.

This is very confusing.
Is there something I can do to get the Reconcile Window Start Balance back
in order?
___
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] Segmentation fault while importing invoice data

2024-03-30 Thread Emir Herrera
Hello everyone.

So, I'm trying to load some billing data from Google Cloud into GNUCash. I
had made a script to get the data and parse it into a CSV. based on the
documentation (
https://code.gnucash.org/docs/C/gnucash-guide/import-invoices.html) I have
formatted it like this:

GCP-202308,2023-08-31,GOOGLE,ea,E2 Instance Ram running in
Americas,Expenses:Cloud Services:Compute Engine,17.00167,0.048897736
GCP-202308,2023-08-31,GOOGLE,ea,E2 Instance Ram running with free tier
discount,Expenses:Cloud Services:Compute Engine,12.56861,-0.048899277
GCP-202308,2023-08-31,GOOGLE,ea,E2 Instance Core running free tier
discount,Expenses:Cloud Services:Compute Engine,13,-0.091205385
GCP-202308,2023-08-31,GOOGLE,ea,Network Internet Egress from Americas to
Australia,Expenses:Cloud Services:Compute Engine,0.28376,2.960248097
GCP-202308,2023-08-31,GOOGLE,ea,Rounding Error,Expenses:Cloud
Services:Invoice,4,0.000258
GCP-202308,2023-08-31,GOOGLE,ea,Network Inter Zone Egress,Expenses:Cloud
Services:Compute Engine,0.40337,0.148746808
GCP-202308,2023-08-31,GOOGLE,ea,Network Egress via Carrier Peering Network
- Americas Based,Expenses:Cloud Services:Compute
Engine,0.60274,0.497727046
GCP-202308,2023-08-31,GOOGLE,ea,E2 Instance Core running in
Americas,Expenses:Cloud Services:Compute Engine,4.25056,0.364815371
GCP-202308,2023-08-31,GOOGLE,ea,Network Inter Region Egress from Americas
to Jakarta,Expenses:Cloud Services:Compute Engine,0.21752,2.482530342
GCP-202309,2023-09-30,GOOGLE,ea,Rounding Error,Expenses:Cloud
Services:Invoice,4,-0.00047925

and I use this REGEX to select the fields:

^(?[^,]*),(?[^,]*),(?[^,]*),(?[^,]*),(?[^,]*),(?[^,]*),(?[^,]*),(?[^,]*)$

So I have my CSV, open the import window, load the file, set the regex
expression and the sample data is displayed. So far, so good.

Anyway, if I click on "continue" to make the importation, after a couple
seconds the system crashes and I get a "Segmentation fault" message on the
terminal, and no detailed information if runned with the "debug" flag...
so... I'm stuck and I need help to import this data.

What could be done? Where is the problem?

P.S. I upgraded to 5.5 last night, just to be up to date and the problem is
there.

Thanks in advance
-- 
Emir Herrera
___
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] Reconcile window Start Balance, & Reconciled became UnReconciled

2024-03-30 Thread Tom Balazs
The problem with the Reconcile Window Start Balance went away after I did
more reconciling.
Searching for an error in a statement reconciled 6 months ago is a real
pain. I hope I don't have to do that again.

On Sat, Mar 30, 2024 at 11:14 AM Tom Balazs  wrote:

> I went to reconcile a recent credit card statement today. But I noticed
> something was incorrect. I traced back a problem to about three months
> prior. Apparently what happened is that my credit card statements were
> reconciled. But recently I reconciled a few months worth of statements for
> a checking account. I think what happened is I added or deleted a transfer
> from checking to credit card (pay down the balance).
>
> Fortunately on the last day of the statement period I add a transaction
> Description: Balance here should be $150
> Transaction amount = 0
> Category Miscellaneous
> Balance column: should show $150.
> Usually it does. Today it was my indicator that something went wrong.
>
> But now I'm having a problem reconciling my statements.
> Somehow the work I did lead to a problem in Reconcile window Start Balance.
> I marke all transactions as reconciled.
> The reconcile window says that there is a difference of $19. So it won't
> let me click Reconcile.
> But when I look at my end of statement.
> I see:
> Description: Balance here should be $150
> And the actual Balance column does show $150.
>
> This is very confusing.
> Is there something I can do to get the Reconcile Window Start Balance back
> in order?
>
>
>
>
___
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] Finance Quotes Yahoo off the rails again?

2024-03-30 Thread Adrien Monteleone

GnuCash 5.6 should be out tomorrow with F::Q 1.59.

Regards,
Adrien

On 3/29/24 10:32 AM, David G. Pickett via gnucash-user wrote:

  Yes, but as I went to flatpak to get a later release, it is discouraging that 
it fails to get updated for newer releases of Finance Quote and for all I can 
tell, newer GnuCash.  Maybe they update the GnuCash but ignore the Finance 
Quote update?


___
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] Segmentation fault while importing invoice data

2024-03-30 Thread Adrien Monteleone
See the wiki about crashes and bug reports. Take a look there as well 
about getting a Tracefile, then file a bug with the crash report and 
tracefile as attachments. (The Tracefile may or may not contain relevant 
info)


You don't mention your OS by the way.

Regards,
Adrien

On 3/30/24 10:56 AM, Emir Herrera wrote:

Anyway, if I click on "continue" to make the importation, after a couple
seconds the system crashes and I get a "Segmentation fault" message on the
terminal, and no detailed information if runned with the "debug" flag...
so... I'm stuck and I need help to import this data.


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


Re: [GNC] Find account

2024-03-30 Thread Stan Brown (using GC 4.14)
On 2024-03-30 07:28, Fred Tydeman wrote:
> Thank you.  That worked.
> I was trying to use Ctrl-F while in Chart of Accounts.

While in the Accounts pane you don't need to "use" anything. Just start
typing a part of the name you're looking for. (It doesn't need to be the
beginning.)

Stan Brown
Tehachapi, CA, USA
https://BrownMath.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.


Re: [GNC] Find account

2024-03-30 Thread Adrien Monteleone
That only works if the account is visible and not in a collapsed part of 
the tree.


Regards,
Adrien

On 3/30/24 12:03 PM, Stan Brown (using GC 4.14) wrote:

While in the Accounts pane you don't need to "use" anything. Just start
typing a part of the name you're looking for. (It doesn't need to be the
beginning.)


___
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] Reconcile window Start Balance, & Reconciled became UnReconciled

2024-03-30 Thread David H
Tom,

Did you use Filter By Status in the Credit Card register and select
"Unreconciled" ?

Cheers David H.


On Sun, 31 Mar 2024 at 01:59, Tom Balazs  wrote:

> The problem with the Reconcile Window Start Balance went away after I did
> more reconciling.
> Searching for an error in a statement reconciled 6 months ago is a real
> pain. I hope I don't have to do that again.
>
> On Sat, Mar 30, 2024 at 11:14 AM Tom Balazs 
> wrote:
>
> > I went to reconcile a recent credit card statement today. But I noticed
> > something was incorrect. I traced back a problem to about three months
> > prior. Apparently what happened is that my credit card statements were
> > reconciled. But recently I reconciled a few months worth of statements
> for
> > a checking account. I think what happened is I added or deleted a
> transfer
> > from checking to credit card (pay down the balance).
> >
> > Fortunately on the last day of the statement period I add a transaction
> > Description: Balance here should be $150
> > Transaction amount = 0
> > Category Miscellaneous
> > Balance column: should show $150.
> > Usually it does. Today it was my indicator that something went wrong.
> >
> > But now I'm having a problem reconciling my statements.
> > Somehow the work I did lead to a problem in Reconcile window Start
> Balance.
> > I marke all transactions as reconciled.
> > The reconcile window says that there is a difference of $19. So it won't
> > let me click Reconcile.
> > But when I look at my end of statement.
> > I see:
> > Description: Balance here should be $150
> > And the actual Balance column does show $150.
> >
> > This is very confusing.
> > Is there something I can do to get the Reconcile Window Start Balance
> back
> > in order?
> >
> >
> >
> >
> ___
> 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] Finance::Quote Default Currency Module

2024-03-30 Thread Bruce Schuck

Hello all,

I'm getting ready to release Finance::Quote v1.60 to CPAN. It appears 
that AlphaVantage has again changed how they deal with throttling for 
requests using the free API keys/tokens. This has affected some users 
that may have data that requires doing more than a handful of currency 
exchange calculations.


While the currency module used can be changed using the FQ_CURRENCY 
environment variable, I have been asked to change the default to 
YahooJSON instead of AlphaVantage.


Before I make such a change I wanted to get a general consensus from the 
GnuCash users.


Thank you.

Bruce S.
___
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] Finance::Quote Fidelity Module

2024-03-30 Thread Bruce Schuck
Fidelity has reworked their web pages sometime last year, breaking the 
Fidelity.pm module (fidelity method). I've done some digging using the 
Chrome/Firefox developer console and I'm not an expert but I think much 
of data now displayed comes through JavaScript calls. Unfortunately, it 
is likely being removed from F::Q in v1.60.


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