Re: [GNC] Sequoia

[David Reiser via gnucash-user]

You will need version 5.10 (not just any 5.x). And make sure you have the 
version for your cpu (M-series or Intel).
--
Dave Reiser
dbrei...@icloud.com



> On Feb 15, 2025, at 07:15, John De Martino via gnucash-user 
>  wrote:
> 
> Hi
> I have recently upgraded to macOS Sequoia and Gnucash won’t load.  I was 
> using Gnucash 4 so upgraded to 5 with the same problem.  Is this a common 
> issue and is there a solution.
> Sent from my iPhone

___
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] Need help locating transaction(s) in advance portfolio

[Kalpesh Patel]

I was able to flag it down using Geoff's suggestion of binary divide and 
conquer method, although it took some time -- I wish there was a way to 
select/unselect multiple accounts by clicking on the parent account rather than 
individual ones without losing all the other ones selected but  

It is interesting case though. It was in a money market (MM) account with a 
brokerage with two entries for the same day: first was the purchase of the 
funds followed by a transfer of the same amount from another account to balance 
out. The MM account was already zero and since the purchase transaction came 
first it went to negative quantity and then the transfer of funds into the 
account set it back to zero amount. This transactions were imported ones.

Since this was a MM account, I was able to change the date to reorder the 
transactions since MM account normally do not deviate from a buck. But I would 
love to hear what is one to do if this was a transaction of a commodity where 
date is material and you want to change the order of transactions so that this 
condition does not arise.  

-Original Message-
From: Fred Tydeman  
Sent: Saturday, February 15, 2025 11:23 AM
To: Kalpesh Patel 
Cc: gnucash-user@gnucash.org
Subject: Re: [GNC] Need help locating transaction(s) in advance portfolio

I had this happen recently.  It was caused by the order of deposits / 
withdrawals in my cash account on the same day.
I excluded that account from the report and it worked ok.


On Thu, Feb 13, 2025 at 11:47 PM Kalpesh Patel 
wrote:

> I am running Advance Portfolio report and I noticed it display 
> following error message at the top:
>
>
>
> There is an error processing the transaction 'buying . share 
> units'.
> This may to be caused by a sell transaction causing a negative stock 
> balance, and a subsequent buy transaction causing a zero balance. This 
> leads to a division-by-zero error. It can be fixed by preventing 
> negative stock balances.
>
>
>
> I was hoping to track down this (these) transaction(s) which are in errors.
> I don't remember doing this for an account but I have not founds how 
> to locate these specific transactions. Any idea how to go about 
> finding it? Is the value error referring to one specific transaction? 
> I am hoping to avoid going through each and every investment account 
> manually which I don't even know how to do that given that the value 
> given in the error message could possibly be from variable number of 
> additions and subtractions in an account.
>
>
>
> Any help is welcome. Thanks.
>
> ___
> 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] Importing QIF, from Quicken 2016

[Wendy Verbeek]

Thanks!  Will try it on my husband's Linux machine.

Wendy

Get Outlook for Android

From: Roger Shilcock 
Sent: Saturday, February 15, 2025 8:28:50 AM
To: gnucash-user@gnucash.org ; Wendy Verbeek 
; gnucash-user@gnucash.org 
Subject: Re: [GNC] Importing QIF, from Quicken 2016

I had the same issue as there's a bug with imports on 5.10. I had to i the 
import into GnuCash on my wife's Linux laptop, then copy the main file over 
onto my W10 PC. GnuCash was happy loading it.


On 15 February 2025 13:56:01 GMT, Wendy Verbeek  wrote:

I have tried the QIF export file from Quicken 2016 to import to  GNUcash V5.10 
on WIndows 10.

It imports the accounts, but not the transactions.

Thanks for any help


* 17:35:01  WARN  Could not locate file AUTHORS
* 17:35:01  WARN  Could not locate file DOCUMENTERS
* 17:35:01  WARN  Could not locate file LICENSE
* 17:45:50 ERROR  GFileInfo created without standard::type
* 17:45:50 ERROR  file ../glib-2.78.3/gio/gfileinfo.c: line 1611 
(g_file_info_get_file_type): should not be reached
* 17:45:50 ERROR  GFileInfo created without standard::type
* 17:45:50 ERROR  file ../glib-2.78.3/gio/gfileinfo.c: line 1611 
(g_file_info_get_file_type): should not be reached
* 17:46:58 ERROR  GFileInfo created without standard::type
* 17:46:58 ERROR  file ../glib-2.78.3/gio/gfileinfo.c: line 1611 
(g_file_info_get_file_type): should not be reached
* 17:46:58 ERROR  GFileInfo created without standard::type
* 17:46:58 ERROR  file ../glib-2.78.3/gio/gfileinfo.c: line 1611 
(g_file_info_get_file_type): should not be reached
* 17:46:58 ERROR  GFileInfo created without standard::type
* 17:46:58 ERROR  file ../glib-2.78.3/gio/gfileinfo.c: line 1611 
(g_file_info_get_file_type): should not be reached
* 17:46:58 ERROR  GFileInfo created without standard::type
* 17:46:58 ERROR  file ../glib-2.78.3/gio/gfileinfo.c: line 1611 
(g_file_info_get_file_type): should not be reached
* 17:46:58 ERROR  GFileInfo created without standard::type
* 17:46:58 ERROR  file ../glib-2.78.3/gio/gfileinfo.c: line 1611 
(g_file_info_get_file_type): should not be reached
* 17:46:58 ERROR  GFileInfo created without standard::type
* 17:46:58 ERROR  file ../glib-2.78.3/gio/gfileinfo.c: line 1611 
(g_file_info_get_file_type): should not be reached
* 17:47:11 ERROR  [gnc_file_log_replay()] File header not 
recognised:
* 17:35:01  WARN  Could not locate file AUTHORS
* 17:47:11 ERROR  [gnc_file_log_replay()] Expected:
mod   trans_guid  split_guid  time_nowdate_entered  date_posted 
acc_guidacc_namenum   description notes memo  action  reconciled  
amount  value date_reconciled
* 17:47:23 ERROR  GFileInfo created without standard::type
* 17:47:23 ERROR  file ../glib-2.78.3/gio/gfileinfo.c: line 1611 
(g_file_info_get_file_type): should not be reached
* 17:47:23 ERROR  GFileInfo created without standard::type
* 17:47:23 ERROR  file ../glib-2.78.3/gio/gfileinfo.c: line 1611 
(g_file_info_get_file_type): should not be reached
* 17:47:23 ERROR  GFileInfo created without standard::type
* 17:47:23 ERROR  file ../glib-2.78.3/gio/gfileinfo.c: line 1611 
(g_file_info_get_file_type): should not be reached
* 17:47:23 ERROR  GFileInfo created without standard::type
* 17:47:23 ERROR  file ../glib-2.78.3/gio/gfileinfo.c: line 1611 
(g_file_info_get_file_type): should not be reached
* 17:47:23 ERROR  GFileInfo created without standard::type
* 17:47:23 ERROR  file ../glib-2.78.3/gio/gfileinfo.c: line 1611 
(g_file_info_get_file_type): should not be reached
* 17:47:23 ERROR  GFileInfo created without standard::type
* 17:47:23 ERROR  file ../glib-2.78.3/gio/gfileinfo.c: line 1611 
(g_file_info_get_file_type): should not be reached
* 17:47:35 ERROR  [gnc_file_log_replay()] File header not 
recognised:
* 17:35:01  WARN  Could not locate file AUTHORS
* 17:47:35 ERROR  [gnc_file_log_replay()] Expected:
mod   trans_guid  split_guid  time_nowdate_entered  date_posted 
acc_guidacc_namenum   description notes memo  action  reconciled  
amount  value date_reconciled
* 17:47:43 ERROR  GFileInfo created without standard::type
* 17:47:43 ERROR  file ../glib-2.78.3/gio/gfileinfo.c: line 1611 
(g_file_info_get_file_type): should not be reached
* 17:47:43 ERROR  GFileInfo created without standard::type
* 17:47:43 ERROR  file ../glib-2.78.3/gio/gfileinfo.c: line 1611 
(g_file_info_get_file_type): should not be reached
* 17:47:43 ERROR  GFileInfo created without standard::type
* 17:47:43 ERROR  file ../glib-2.78.3/gio/gfileinfo.c: line 1611 
(g_file_info_get_file_type): should not be reached
* 17:47:43 ERROR  GFileInfo created without standard::type
* 17:47:43 ERROR  file ../glib-2.78.3/gio/gfileinfo.c: line 1611 
(g_file_info_get_file_type): should not be reached
* 17:47:43 ERROR  GFileInfo created without standard::type
* 17:47:43 ERROR  file ../glib-2.78.3/gio/gfileinfo.c: line 1611 
(g_file_info_get_file_type): should not be reached
* 17:47:43 ERROR  GFileInfo cr

Re: [GNC] Need help locating transaction(s) in advance portfolio

[Geoff]

Hi Kalpesh

Now you mention it, this scenario happened to me:

> Since this was a MM account, I was able to change the date to reorder 
> the transactions since MM account normally do not deviate from a 
buck. > But I would love to hear what is one to do if this was a transaction
> of a commodity where date is material and you want to change the 
order > of transactions so that this condition does not arise.


I am pretty sure you just need to delete the first/negative transaction 
then key it in again, and then GnuCash will sequence them correctly, 
even though they both have the same date.


Regards

Geoff
=


On 17/02/2025 8:56 am, Kalpesh Patel wrote:

I was able to flag it down using Geoff's suggestion of binary divide and 
conquer method, although it took some time -- I wish there was a way to 
select/unselect multiple accounts by clicking on the parent account rather than 
individual ones without losing all the other ones selected but 

It is interesting case though. It was in a money market (MM) account with a 
brokerage with two entries for the same day: first was the purchase of the 
funds followed by a transfer of the same amount from another account to balance 
out. The MM account was already zero and since the purchase transaction came 
first it went to negative quantity and then the transfer of funds into the 
account set it back to zero amount. This transactions were imported ones.

Since this was a MM account, I was able to change the date to reorder the 
transactions since MM account normally do not deviate from a buck. But I would 
love to hear what is one to do if this was a transaction of a commodity where 
date is material and you want to change the order of transactions so that this 
condition does not arise.

-Original Message-
From: Fred Tydeman 
Sent: Saturday, February 15, 2025 11:23 AM
To: Kalpesh Patel 
Cc: gnucash-user@gnucash.org
Subject: Re: [GNC] Need help locating transaction(s) in advance portfolio

I had this happen recently.  It was caused by the order of deposits / 
withdrawals in my cash account on the same day.
I excluded that account from the report and it worked ok.


On Thu, Feb 13, 2025 at 11:47 PM Kalpesh Patel 
wrote:


I am running Advance Portfolio report and I noticed it display
following error message at the top:



There is an error processing the transaction 'buying . share
units'.
This may to be caused by a sell transaction causing a negative stock
balance, and a subsequent buy transaction causing a zero balance. This
leads to a division-by-zero error. It can be fixed by preventing
negative stock balances.



I was hoping to track down this (these) transaction(s) which are in errors.
I don't remember doing this for an account but I have not founds how
to locate these specific transactions. Any idea how to go about
finding it? Is the value error referring to one specific transaction?
I am hoping to avoid going through each and every investment account
manually which I don't even know how to do that given that the value
given in the error message could possibly be from variable number of
additions and subtractions in an account.



Any help is welcome. Thanks.

___
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] GBP shown in Balance sheet (setup is GHS)

[Financial EpGhana]

Dear team,
I have a problem with the Balance sheet report. I have set up GHS as a
currency but in a
Balance sheet report I also can see GBP. Why is this happening (please see
in attachment)?

I also can't understand why Description is a fixed column, it is so basic
and simple, and yet
again it is a problem

-- 
Petrovic Jovan, dipl.oec.
Financial Controller
Energoprojekt Ghana Limited

Spintex Road No. 98, Accra Ghana
Mob (Ghana): +233 20 9030 435
___
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] Sequoia

[Geoff Jankowski via gnucash-user]

John,

Find the machine chip type in 🍎:About. It will show on first page. 

GNC has worked on my macs since I started on version 3 I think. 

Geoff
+33 6 22 93 00 53
+44 7770 58 48 38

> On 16 Feb 2025, at 22:58, David Reiser via gnucash-user 
>  wrote:
> 
___
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] Need help locating transaction(s) in advance portfolio

[sunfish62--- via gnucash-user]

I believe it is enough simply to change some aspect of the mis-ordered 
transaction (e.g., adding a memo), which I believe will change the internal 
date stamp of the transaction and thus the register order. 

⁣David T. ​

On Feb 17, 2025, 2:08 AM, at 2:08 AM, Geoff  wrote:
>Hi Kalpesh
>
>Now you mention it, this scenario happened to me:
>
>> Since this was a MM account, I was able to change the date to reorder
>
> > the transactions since MM account normally do not deviate from a 
>buck. > But I would love to hear what is one to do if this was a
>transaction
> > of a commodity where date is material and you want to change the 
>order > of transactions so that this condition does not arise.
>
>I am pretty sure you just need to delete the first/negative transaction
>
>then key it in again, and then GnuCash will sequence them correctly, 
>even though they both have the same date.
>
>Regards
>
>Geoff
>=
>
>
>On 17/02/2025 8:56 am, Kalpesh Patel wrote:
>> I was able to flag it down using Geoff's suggestion of binary divide
>and conquer method, although it took some time -- I wish there was a
>way to select/unselect multiple accounts by clicking on the parent
>account rather than individual ones without losing all the other ones
>selected but 
>> 
>> It is interesting case though. It was in a money market (MM) account
>with a brokerage with two entries for the same day: first was the
>purchase of the funds followed by a transfer of the same amount from
>another account to balance out. The MM account was already zero and
>since the purchase transaction came first it went to negative quantity
>and then the transfer of funds into the account set it back to zero
>amount. This transactions were imported ones.
>> 
>> Since this was a MM account, I was able to change the date to reorder
>the transactions since MM account normally do not deviate from a buck.
>But I would love to hear what is one to do if this was a transaction of
>a commodity where date is material and you want to change the order of
>transactions so that this condition does not arise.
>> 
>> -Original Message-
>> From: Fred Tydeman 
>> Sent: Saturday, February 15, 2025 11:23 AM
>> To: Kalpesh Patel 
>> Cc: gnucash-user@gnucash.org
>> Subject: Re: [GNC] Need help locating transaction(s) in advance
>portfolio
>> 
>> I had this happen recently.  It was caused by the order of deposits /
>withdrawals in my cash account on the same day.
>> I excluded that account from the report and it worked ok.
>> 
>> 
>> On Thu, Feb 13, 2025 at 11:47 PM Kalpesh Patel
>
>> wrote:
>> 
>>> I am running Advance Portfolio report and I noticed it display
>>> following error message at the top:
>>>
>>>
>>>
>>> There is an error processing the transaction 'buying . share
>>> units'.
>>> This may to be caused by a sell transaction causing a negative stock
>>> balance, and a subsequent buy transaction causing a zero balance.
>This
>>> leads to a division-by-zero error. It can be fixed by preventing
>>> negative stock balances.
>>>
>>>
>>>
>>> I was hoping to track down this (these) transaction(s) which are in
>errors.
>>> I don't remember doing this for an account but I have not founds how
>>> to locate these specific transactions. Any idea how to go about
>>> finding it? Is the value error referring to one specific
>transaction?
>>> I am hoping to avoid going through each and every investment account
>>> manually which I don't even know how to do that given that the value
>>> given in the error message could possibly be from variable number of
>>> additions and subtractions in an account.
>>>
>>>
>>>
>>> Any help is welcome. Thanks.
>>>
>>> ___
>>> 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.
___
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] GBP shown in Balance sheet (setup is GHS)

[sunfish62--- via gnucash-user]

With regards to your first problem, I can't really say, since I don't have that 
problem. I wonder whether you set the GnuCash file up with GBP as the default 
currency.

As for the second issue, the tutorial explains the behavior of the Description 
column at 2.9.2.3 
(https://www.gnucash.org/docs/v5/C/gnucash-guide/chapter_txns.html#txns-register-oview).
 And it's discussed in the mailing lists rather regularly. 

⁣David T. ​

On Feb 16, 2025, 3:20 PM, at 3:20 PM, Financial EpGhana 
 wrote:
>Dear team,
>I have a problem with the Balance sheet report. I have set up GHS as a
>currency but in a
>Balance sheet report I also can see GBP. Why is this happening (please
>see
>in attachment)?
>
>I also can't understand why Description is a fixed column, it is so
>basic
>and simple, and yet
>again it is a problem
>
>-- 
>Petrovic Jovan, dipl.oec.
>Financial Controller
>Energoprojekt Ghana Limited
>
>Spintex Road No. 98, Accra Ghana
>Mob (Ghana): +233 20 9030 435
>
>
>
>
>___
>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] GBP shown in Balance sheet (setup is GHS)

[Murugan Mariappan]

please check in the following places for the choice of currency

In Preferences : Reports: Default Report Currency
In Report: Balance Sheet: Options: Commodities




Saludos Cordiales


Murugan


From: gnucash-user 
 on behalf of 
Financial EpGhana 
Sent: 16 February 2025 09:18
To: gnucash-user@gnucash.org 
Subject: [GNC] GBP shown in Balance sheet (setup is GHS)

Dear team,
I have a problem with the Balance sheet report. I have set up GHS as a
currency but in a
Balance sheet report I also can see GBP. Why is this happening (please see
in attachment)?

I also can't understand why Description is a fixed column, it is so basic
and simple, and yet
again it is a problem

--
Petrovic Jovan, dipl.oec.
Financial Controller
Energoprojekt Ghana Limited

Spintex Road No. 98, Accra Ghana
Mob (Ghana): +233 20 9030 435
___
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] Sequoia

[John De Martino via gnucash-user]

Hi
I have recently upgraded to macOS Sequoia and Gnucash won’t load.  I was using 
Gnucash 4 so upgraded to 5 with the same problem.  Is this a common issue and 
is there a solution.
Sent from my iPhone
___
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.