Re: [GNC] gnucash-5.5-1.setup.exe

2024-02-20 Thread Geoff
P.S.  Further to my previous test results, I have now run all reports 
(there are 51 excluding those on the Business menu (I don't use Business 
functionality)) on my own books (41MB uncompressed XML) and, although I 
didn't do a line by line reconciliation with my current version of 
GnuCash, all the reports looked OK and there was no unexpected behaviour.


Thanks again

Geoff
=

On 21/02/2024 4:46 pm, John Ralls wrote:

Having finally beaten WebKitGtk on Windows into submission so that it runs 
JavaScript without crashing, at least in my not very extensive tests, I've 
built a new Windows gnucash-5.5-1.setup.exe and uploaded it to the usual places.

The sea-256 is 720a60dca57e4199f28b5449158ddc89e62012f042a62c43b16c569fa0890275.

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] gnucash-5.5-1.setup.exe

2024-02-20 Thread John Ralls
Having finally beaten WebKitGtk on Windows into submission so that it runs 
JavaScript without crashing, at least in my not very extensive tests, I've 
built a new Windows gnucash-5.5-1.setup.exe and uploaded it to the usual places.

The sea-256 is 720a60dca57e4199f28b5449158ddc89e62012f042a62c43b16c569fa0890275.

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.


Re: [GNC] Finance::Quote docs out of date?

2024-02-20 Thread john
No, your Gnucash is outdated. The current release is 5.5. You need the docs for 
4.x. Go to https://www.gnucash.org/docs.phtml and scroll down to "Old Stable 
Release".

Regards,
John Ralls

> On Feb 19, 2024, at 05:48, Stephen Blackwell  wrote:
> 
> I'm following the docs here:
> https://gnucash.org/docs/v5/C/gnucash-manual/fq-install.html
> which say in step 3 of 11.4 "Run the *gnucash-cli --quotes info* command to
> verify that the program is already in a directory that is entered in the
> PATH environment variable."
> What I get is:
> $ gnucash-cli --quotes info
> Unknown quotes command 'info'
> 
> gnucash-cli [options] [datafile] - GnuCash, accounting for personal and
> small business finance:
> 
> Common Options: ...
> 
> Is this expected? Are these docs outdated?
> My gnucash version is 1:4.13-1. (Latest version for my distribution)
> 
> Steve
> ___
> 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] Bank Balance Higher Than Actual

2024-02-20 Thread Murugan Muruganandam
hi Paul

one way of checking is running reconciliation on the bank account and check 
your bank statement.

also, when you create invoice it will be affecting only the receivables, on 
payment it will update the balances in your bank account




Saludos Cordiales


Murugan


From: gnucash-user 
 on behalf of Paul 
Roberts 
Sent: Monday, February 19, 2024 1:02 PM
To: gnucash-user@gnucash.org 
Subject: [GNC] Bank Balance Higher Than Actual

The bank balance in gnucash is much higher than the actual balance. Is
there some way that I can find out why? When an invoice is created does
that amount add to the bank balance?

--

Paul L Roberts, Ph.D.

Head of School

Bay Islands International School

East Sandy Bay Beach Road, Sandy Bay

Roatan, Islas de la Bahia, Honduras

+504 9817-0344

+504 9335-5272

www.roatanschools.org

Education That Will Take You Anywhere
___
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] Bank Balance Higher Than Actual

2024-02-20 Thread Paul Roberts
The bank balance in gnucash is much higher than the actual balance. Is
there some way that I can find out why? When an invoice is created does
that amount add to the bank balance?

-- 

Paul L Roberts, Ph.D.

Head of School

Bay Islands International School

East Sandy Bay Beach Road, Sandy Bay

Roatan, Islas de la Bahia, Honduras

+504 9817-0344

+504 9335-5272

www.roatanschools.org

Education That Will Take You Anywhere
___
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 docs out of date?

2024-02-20 Thread Stephen Blackwell
I'm following the docs here:
https://gnucash.org/docs/v5/C/gnucash-manual/fq-install.html
which say in step 3 of 11.4 "Run the *gnucash-cli --quotes info* command to
verify that the program is already in a directory that is entered in the
PATH environment variable."
What I get is:
$ gnucash-cli --quotes info
Unknown quotes command 'info'

gnucash-cli [options] [datafile] - GnuCash, accounting for personal and
small business finance:

Common Options: ...

Is this expected? Are these docs outdated?
My gnucash version is 1:4.13-1. (Latest version for my distribution)

Steve
___
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 install Finance::Quote

2024-02-20 Thread Kalpesh Patel
Slight correction ...

Instead of:
- Run 'sudo find . -name Quote | xargs ls -al | grep Finance' to find the
location where it is installed.

It should be:
- Run 'sudo find / -name Quote | xargs ls -al | grep Finance' to find the
location where it is installed.


-- Replace dot after the find string with a forward slash.


-Original Message-
From: Kalpesh Patel  
Sent: Monday, February 19, 2024 1:11 PM
To: 'Gustavo Taouil' 
Cc: 'gnucash-user@gnucash.org' 
Subject: RE: [GNC] Problem install Finance::Quote

I am on Windows platform but most likely one of two issues likely on the
Perl front as it seems to be universal across platform:

Since you forced installed LWP::Protocol::https module, it skipped install
of one or more under lying dependent modules so it is broken at its heart
even though physically it is present. IMHO, if Perl is configured correctly
then there is hardly need to force install modules other than in extremely
few rare cases. This also means your CPAN module for Perl is not likely to
be configured correctly to retrieve dependent modules and install them as
necessary. 

-- OR --

Your GNC install is looking at Perl that is entirely located in a different
location and it isn't finding all the required modules there.

Former is likely to issue. Also may I ask how you came to conclusion that
installing OpenSSL via brew package manager will be sufficient on Mac to get
F::Q up and running? You may want to review documentation at
https://finance-quote.sourceforge.net/index.html to become familiar. 

While commands you listed might work, I like to use following (not sure how
they will behave on your system at this point though) after Perl CPAN module
is properly configured:

sudo env ARCHFLAGS='-arch arm64 -arch arm64e -arch x86_64' perl -MCPAN -e
'install Test2'
sudo env ARCHFLAGS='-arch arm64 -arch arm64e -arch x86_64' perl -MCPAN -e
'install Finance::Quote'
sudo env ARCHFLAGS='-arch arm64 -arch arm64e -arch x86_64' perl -MCPAN -e
'install JSON::Parse'

If things are broken in the process of install then fix them; don't skip
them!

As for Perl's CPAN module, normally if the CPAN's 'prerequisites_policy'
setting (configured with 'follow' option), 'build_requires_install_policy'
setting (with 'yes') and 'make' settings (with fully qualified path to a
make that is found by search or compatible one) are properly set then that
should have installed all pre-requisite dependencies automatically. These
are the sane defaults that gets configures with when CPAN module is
initialized. In case there is interest for the CPAN module configuration
settings, refer to https://metacpan.org/pod/CPAN#Config-Variables link.

Perl sadly does not have a way to uninstall a module on its own. The
unofficial way to do is to delete (safer to rename!?!?) the module's Perl
files and then attempt to install it again.

- Run 'sudo find . -name Quote | xargs ls -al | grep Finance' to find the
location where it is installed.
- Rename 'Finance' directory under .../lib/perl5/... subtree (with perhaps
.bak extension).
- Rerun the installer as mentioned above using modified commands.
 
With the current state of it, YMMV though.

-Original Message-
From: Gustavo Taouil  
Sent: Friday, February 16, 2024 5:34 AM
To: gnucash-user@gnucash.org
Subject: [GNC] Problem install Finance::Quote

Hi Guys, I tried to install Finance::Quote in my new mac (M3) with Sonoma
macOs. I Use these lines of command to install:

sudo env ARCHFLAGS='-arch arm64 -arch arm64e -arch x86_64'cpan -f -i Test2
sudo env ARCHFLAGS='-arch arm64 -arch arm64e -arch x86_64'cpan -f -i
Finance::Quote
sudo env ARCHFLAGS='-arch arm64 -arch arm64e -arch x86_64'cpan -f -i
JSON::Parse

Now, I was receiving theses kind of messages when I tried to update quotes:


* B3:IVVB11.SA Finance::Quote reported failure with error: 501 Protocol
scheme 'https' is not supported (LWP::Protocol::https not installed)


I already force the install of LWP::Protocol::https and I installed the
opensll with the command: brew install openssl, but it's not working.

My perl is installed in /usr/bin/perl and my version is 5.30.3

anyone can help me?






___
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 to reimport an ofx file?

2024-02-20 Thread john
If the OFX files are made correctly then that means the transactions are 
already recorded in the account.

Each transaction in an OFX import has an FITID that is supposed to be unique 
for the source institution. When creating a new transaction or matching an 
existing one GnuCash records the FITID as the transaction's online-id after 
first searching all transactions in the account for that FITID and finding no 
match.

A few users have reported that their banks' software screws up the FITIDs so 
that they're unique within the downloaded file but are repeated across multiple 
files and that breaks GnuCash's duplicate detection. Check your OFX files 
(they're plain text) and see if the FITIDs are being reused. If they are you 
can write a simple program in your favorite scripting language to add something 
uniique--maybe the file's date as MMDD or a serial number--to every FITID. 
Keep the script around, you'll need to apply it to all future imports from that 
bank until they fix their OFX export software.

Regards,
John Ralls


> On Feb 19, 2024, at 22:25, jeffrey black  wrote:
> 
> I'll give it a try. The last time I tried it I was told that all transactions 
> had ben imported.
> 

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