Re: [GNC] How to reorganize the account tree

[Alan A Holmes]

As Adrien said in his reply if you sort on the Account Name column it should
be okay.

Personally, I sort on the Hidden column which I have displayed, mainly
because it puts the Imbalance and Orphan accounts together at the bottom of
the list and enables me to find errors in transactions quickly.
What I do notice sorting this way is that within the top level accounts
(Assets, Expenses, Income, etc.) that the 2nd and subsequent level Accounts
under Assets AREN'T sorted alphabetically, while those under Expenses and
Income ARE. I have insufficient sub-accounts under Equity and Liabilities to
be able to say.


Alan A Holmes

-Original Message-
From: gnucash-user
 On Behalf Of
ja...@comcast.net
Sent: 11 June 2022 12:29
To: gnucash-user@gnucash.org
Subject: [GNC] How to reorganize the account tree

I have been using gnucash for nearly 20 years. My account lists were a mess
until this spring when somehow I spent a day or two reorganizing everything
into a new and very well organized account tree.  For the life of me, I
don't remember how I was able to do that without losing the 20 years of data
stored in my accounts.  I would like to reorganize the order in which my
bank accounts are listed to make them in alphabetical order but I cannot
find a way to move the accounts in the account tree. I can go to the parent
account but that does not give me control to move the accounts around.  

Can someone tell me how to move accounts around in the
account list.  Thank you.  Chin00kie

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
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
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
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 reorganize the account tree

[Michael or Penny Novack]

What I do notice sorting this way is that within the top level accounts
(Assets, Expenses, Income, etc.) that the 2nd and subsequent level Accounts
under Assets AREN'T sorted alphabetically, while those under Expenses and
Income ARE. I have insufficient sub-accounts under Equity and Liabilities to
be able to say.


WHAT are you saying, exactly?

The CoA is a TREE structure. The accounts at the same level of the tree 
should be sorted in alpha-meric order. The sibling accounts (children of 
the same parent account) should also be sorted that way AMONG THEMSELVES 
(but not sorted that way with respect to children of different parents)


You aren't seeing the ultimate top level parent (aka "root") but "top 
level" accounts like "asset", "liability", "equity", "income", 
"expense", "Imbalance" are its children and so appear in sorted order. 
In other words, they are siblings at the highest level.


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
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] questions on 4.1

[Gyle McCollam]

Jay,
Happy you found this helpful.  I respond to questions because others have 
responded to me or I have found their responses to other helpful, as you did 
this response.  I don't know enough programing, just enough to be dangerous, so 
I help where I can.  I have picked up several tip/tricks along the way and I am 
grateful to those who take the time to respond to questions.  I picked this up 
from a previous question/answer session and feel it is part of my obligation to 
pass it on when I can.  Several names keep appearing in response to questions.  
Do you hear me: Adrein, David T, Michael, and others.  Thanks to you and 
everyone that takes the time!


Thank You,
Gyle McCollam

Gyle McCollam

609.680.2326 Mobile

gmccol...@live.com   email


From: ja...@comcast.net 
Sent: Sunday, June 12, 2022 7:57 AM
To: 'Gyle McCollam' 
Subject: RE: [GNC] questions on 4.1

Gyle, Thank you. I had overlooked that arrow and feature.

-Original Message-
From: gnucash-user  On
Behalf Of Gyle McCollam
Sent: Saturday, June 11, 2022 3:42 PM
To: Top Cat ; gnucash-user@gnucash.org
Subject: Re: [GNC] questions on 4.1

I'm sure your aware, but just in case.  Did you know there is a down arrow
at the far right of the account heading screen.  This allows you to add or
remove columns from the accounts page.  Maybe, the account code box is not
checked (3rd one down).


Thank You,
Gyle McCollam

Gyle McCollam

609.680.2326 Mobile

gmccol...@live.com   email


From: gnucash-user  on
behalf of Top Cat 
Sent: Saturday, June 11, 2022 12:44 PM
To: gnucash-user@gnucash.org 
Subject: [GNC] questions on 4.1

I have been using gnucash since 2.x with a MySQL database



I recently build a new machine and updated to 4.1, and have run into several
issues

1.  On the accounts page, I can no longer show the account numbers, or
sort by them
2.  On reconciliations, paired transactions (like transfers from one
subaccount to another) no longer clear "both sides" when one is checked - it
requires manually marking both sides separately.



Is this correct behavior? Are there settings I am missing? do I need to
reinstall/save and restore data?



Any help would be appreciated

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
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
If you are using Nabble or Gmane, please see
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
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
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] questions on 4.1

[Gyle McCollam]

I only initially responded to the 1st question you raised.  However, as for the 
2nd question, I feel, that the software is operating correctly.  When you are 
reconciling an account, say Bank A, you are reconciling only that account, not 
the accounts that the other side of the transactions are posted to.  When you 
reconcile those accounts, you would reconcile that half (or less depending on 
how many splits there are).  Say the other half of the split was Bank B, You 
wouldn't want to reconcile that transaction when you do Bank A because when you 
get Bank B's statement, they may not have credited your account (not likely, 
but) and it would make it harder to determine where the error is at.


Thank You,
Gyle McCollam

Gyle McCollam

609.680.2326 Mobile

gmccol...@live.com   email


From: gnucash-user  on 
behalf of Gyle McCollam 
Sent: Sunday, June 12, 2022 10:20 AM
To: ja...@comcast.net ; gnucash-user@gnucash.org 

Subject: Re: [GNC] questions on 4.1

Jay,
Happy you found this helpful.  I respond to questions because others have 
responded to me or I have found their responses to other helpful, as you did 
this response.  I don't know enough programing, just enough to be dangerous, so 
I help where I can.  I have picked up several tip/tricks along the way and I am 
grateful to those who take the time to respond to questions.  I picked this up 
from a previous question/answer session and feel it is part of my obligation to 
pass it on when I can.  Several names keep appearing in response to questions.  
Do you hear me: Adrein, David T, Michael, and others.  Thanks to you and 
everyone that takes the time!


Thank You,
Gyle McCollam

Gyle McCollam

609.680.2326 Mobile

gmccol...@live.com   email


From: ja...@comcast.net 
Sent: Sunday, June 12, 2022 7:57 AM
To: 'Gyle McCollam' 
Subject: RE: [GNC] questions on 4.1

Gyle, Thank you. I had overlooked that arrow and feature.

-Original Message-
From: gnucash-user  On
Behalf Of Gyle McCollam
Sent: Saturday, June 11, 2022 3:42 PM
To: Top Cat ; gnucash-user@gnucash.org
Subject: Re: [GNC] questions on 4.1

I'm sure your aware, but just in case.  Did you know there is a down arrow
at the far right of the account heading screen.  This allows you to add or
remove columns from the accounts page.  Maybe, the account code box is not
checked (3rd one down).


Thank You,
Gyle McCollam

Gyle McCollam

609.680.2326 Mobile

gmccol...@live.com   email


From: gnucash-user  on
behalf of Top Cat 
Sent: Saturday, June 11, 2022 12:44 PM
To: gnucash-user@gnucash.org 
Subject: [GNC] questions on 4.1

I have been using gnucash since 2.x with a MySQL database



I recently build a new machine and updated to 4.1, and have run into several
issues

1.  On the accounts page, I can no longer show the account numbers, or
sort by them
2.  On reconciliations, paired transactions (like transfers from one
subaccount to another) no longer clear "both sides" when one is checked - it
requires manually marking both sides separately.



Is this correct behavior? Are there settings I am missing? do I need to
reinstall/save and restore data?



Any help would be appreciated

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
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
If you are using Nabble or Gmane, please see
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
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
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
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
If you are using Nabble or Gmane, pl

Re: [GNC] questions on 4.1

[David Carlson]

I have not seen an answer to the second question yet.  The reconciliation
process in GnuCash has never marked any part of a transaction as
"Reconciled" other than the part that is in the account which is being
reconciled.  That may not match what happened in other financial programs.

On Sun, Jun 12, 2022 at 9:21 AM Gyle McCollam  wrote:

> Jay,
> Happy you found this helpful.  I respond to questions because others have
> responded to me or I have found their responses to other helpful, as you
> did this response.  I don't know enough programing, just enough to be
> dangerous, so I help where I can.  I have picked up several tip/tricks
> along the way and I am grateful to those who take the time to respond to
> questions.  I picked this up from a previous question/answer session and
> feel it is part of my obligation to pass it on when I can.  Several names
> keep appearing in response to questions.  Do you hear me: Adrein, David T,
> Michael, and others.  Thanks to you and everyone that takes the time!
>
>
> Thank You,
> Gyle McCollam
>
> Gyle McCollam
>
> 609.680.2326 Mobile
>
> gmccol...@live.com   email
>
> 
> From: ja...@comcast.net 
> Sent: Sunday, June 12, 2022 7:57 AM
> To: 'Gyle McCollam' 
> Subject: RE: [GNC] questions on 4.1
>
> Gyle, Thank you. I had overlooked that arrow and feature.
>
> -Original Message-
> From: gnucash-user  On
> Behalf Of Gyle McCollam
> Sent: Saturday, June 11, 2022 3:42 PM
> To: Top Cat ; gnucash-user@gnucash.org
> Subject: Re: [GNC] questions on 4.1
>
> I'm sure your aware, but just in case.  Did you know there is a down arrow
> at the far right of the account heading screen.  This allows you to add or
> remove columns from the accounts page.  Maybe, the account code box is not
> checked (3rd one down).
>
>
> Thank You,
> Gyle McCollam
>
> Gyle McCollam
>
> 609.680.2326 Mobile
>
> gmccol...@live.com   email
>
> 
> From: gnucash-user  on
> behalf of Top Cat 
> Sent: Saturday, June 11, 2022 12:44 PM
> To: gnucash-user@gnucash.org 
> Subject: [GNC] questions on 4.1
>
> I have been using gnucash since 2.x with a MySQL database
>
>
>
> I recently build a new machine and updated to 4.1, and have run into
> several
> issues
>
> 1.  On the accounts page, I can no longer show the account numbers, or
> sort by them
> 2.  On reconciliations, paired transactions (like transfers from one
> subaccount to another) no longer clear "both sides" when one is checked -
> it
> requires manually marking both sides separately.
>
>
>
> Is this correct behavior? Are there settings I am missing? do I need to
> reinstall/save and restore data?
>
>
>
> Any help would be appreciated
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> 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
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> 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
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> 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
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] questions on 4.1

[Top Cat]

I understand your thoughts, and don't disagree; the question was more that
it DID do this until I upgraded to 4.x

 

I'm not sure if something changed in gnucash4, or if I inadvertently broke
something in the migration and upgrade

 

From: Gyle McCollam  
Sent: Sunday, June 12, 2022 10:38 AM
To: Top Cat ; gnucash-user@gnucash.org
Subject: Re: [GNC] questions on 4.1

 

I only initially responded to the 1st question you raised.  However, as for
the 2nd question, I feel, that the software is operating correctly.  When
you are reconciling an account, say Bank A, you are reconciling only that
account, not the accounts that the other side of the transactions are posted
to.  When you reconcile those accounts, you would reconcile that half (or
less depending on how many splits there are).  Say the other half of the
split was Bank B, You wouldn't want to reconcile that transaction when you
do Bank A because when you get Bank B's statement, they may not have
credited your account (not likely, but) and it would make it harder to
determine where the error is at.

 

Thank You,   
Gyle McCollam

Gyle McCollam

609.680.2326 Mobile

  gmccol...@live.com   email

  _  

From: gnucash-user mailto:gnucash-user-bounces+gylemc=gmail@gnucash.org> > on behalf of
Gyle McCollam mailto:gmccol...@live.com> >
Sent: Sunday, June 12, 2022 10:20 AM
To: ja...@comcast.net   mailto:ja...@comcast.net> >; gnucash-user@gnucash.org
  mailto:gnucash-user@gnucash.org> >
Subject: Re: [GNC] questions on 4.1 

 

Jay,
Happy you found this helpful.  I respond to questions because others have
responded to me or I have found their responses to other helpful, as you did
this response.  I don't know enough programing, just enough to be dangerous,
so I help where I can.  I have picked up several tip/tricks along the way
and I am grateful to those who take the time to respond to questions.  I
picked this up from a previous question/answer session and feel it is part
of my obligation to pass it on when I can.  Several names keep appearing in
response to questions.  Do you hear me: Adrein, David T, Michael, and
others.  Thanks to you and everyone that takes the time!


Thank You,
Gyle McCollam

Gyle McCollam

609.680.2326 Mobile

gmccol...@live.com   email


From: ja...@comcast.net   mailto:ja...@comcast.net> >
Sent: Sunday, June 12, 2022 7:57 AM
To: 'Gyle McCollam' mailto:gmccol...@live.com> >
Subject: RE: [GNC] questions on 4.1

Gyle, Thank you. I had overlooked that arrow and feature.

-Original Message-
From: gnucash-user mailto:gnucash-user-bounces+jaypj=comcast@gnucash.org> > On
Behalf Of Gyle McCollam
Sent: Saturday, June 11, 2022 3:42 PM
To: Top Cat mailto:t...@fractalcat.io> >;
gnucash-user@gnucash.org  
Subject: Re: [GNC] questions on 4.1

I'm sure your aware, but just in case.  Did you know there is a down arrow
at the far right of the account heading screen.  This allows you to add or
remove columns from the accounts page.  Maybe, the account code box is not
checked (3rd one down).


Thank You,
Gyle McCollam

Gyle McCollam

609.680.2326 Mobile

gmccol...@live.com   email


From: gnucash-user mailto:gnucash-user-bounces+gylemc=gmail@gnucash.org> > on
behalf of Top Cat mailto:t...@fractalcat.io> >
Sent: Saturday, June 11, 2022 12:44 PM
To: gnucash-user@gnucash.org 
mailto:gnucash-user@gnucash.org> >
Subject: [GNC] questions on 4.1

I have been using gnucash since 2.x with a MySQL database



I recently build a new machine and updated to 4.1, and have run into several
issues

1.  On the accounts page, I can no longer show the account numbers, or
sort by them
2.  On reconciliations, paired transactions (like transfers from one
subaccount to another) no longer clear "both sides" when one is checked - it
requires manually marking both sides separately.



Is this correct behavior? Are there settings I am missing? do I need to
reinstall/save and restore data?



Any help would be appreciated

___
gnucash-user mailing list
gnucash-user@gnucash.org  
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
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 pref

Re: [GNC] How to reorganize the account tree

[Adrien Monteleone]

Alan,

All of my accounts *at each level* are sorted properly *amongst 
themselves* in all parts of the tree.


Maybe double check that you don't have an errant space before some names?

Regards,
Adrien

On 6/12/22 2:12 AM, Alan A Holmes wrote:

As Adrien said in his reply if you sort on the Account Name column it should
be okay.

Personally, I sort on the Hidden column which I have displayed, mainly
because it puts the Imbalance and Orphan accounts together at the bottom of
the list and enables me to find errors in transactions quickly.
What I do notice sorting this way is that within the top level accounts
(Assets, Expenses, Income, etc.) that the 2nd and subsequent level Accounts
under Assets AREN'T sorted alphabetically, while those under Expenses and
Income ARE. I have insufficient sub-accounts under Equity and Liabilities to
be able to say.


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
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 reorganize the account tree

[Adrien Monteleone]

Please remember to use 'reply-to-list' or 'reply-all' so the discussion 
stays on the list. Others may benefit, and others may be able to help 
out too.


As to your question, I'm guessing you want to move some accounts within 
the tree. Simply select the desired account (don't open its register) 
click the Edit button on the toolbar. (or right-click, then choose 
'edit') Finally, simply select the new parent account in the 
bottom-right pane of the edit window and click 'OK'.


The account has now moved to be a child of the new parent account.

Note that while you can move accounts to different main parts of the 
tree (such as moving an asset to a liability) you should also edit the 
account type (bottom-left pane of the account window) and if you have 
transactions in it, you'll possibly need to swap the columns containing 
amounts for *all* transactions.


In this case, I'd advise using View > Transaction Journal so you can 
always see all splits. Then work your way through each transaction 
moving the amounts from the left to the right and vice versa. That is 
easy to do by simply adding a minus sign in front of an amount. GnuCash 
will swap it for you.


Regards,
Adrien

On 6/11/22 1:58 PM, ja...@comcast.net wrote:

 Thank you Adrian,  That has helped me get the accounts in order.  Is
there a way to move accounts. Like a copy/paste process or is that not
allowed?  You are a lifesaver!



___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] questions on 4.1

[Adrien Monteleone]

What version were you previously using? I've never seen this behavior 
and I've been using GnuCash since the early 2.6 days.


Regards,
Adrien

On 6/12/22 10:17 AM, Top Cat wrote:

I understand your thoughts, and don't disagree; the question was more that
it DID do this until I upgraded to 4.x


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
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 reorganize the account tree

[Adrien Monteleone]

Note, I seem to vaguely recall a case where GnuCash is smart enough and 
helpful enough to swap the columns for you when changing account types, 
but I don't recall if this is when you simply edit, or if you delete the 
account and choose to move the transactions to an account of a different 
type.


Regards,
Adrien

On 6/12/22 10:30 AM, Adrien Monteleone wrote:
Note that while you can move accounts to different main parts of the 
tree (such as moving an asset to a liability) you should also edit the 
account type (bottom-left pane of the account window) and if you have 
transactions in it, you'll possibly need to swap the columns containing 
amounts for *all* transactions.


In this case, I'd advise using View > Transaction Journal so you can 
always see all splits. Then work your way through each transaction 
moving the amounts from the left to the right and vice versa. That is 
easy to do by simply adding a minus sign in front of an amount. GnuCash 
will swap it for you.


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Entry Point Not Found error

[Adrien Monteleone]

The wiki page on upgrading would be a good read here.

A few caveats:

1. version numbering scheme changed with 3.x, so if you were on say 2.4, 
you first need to upgrade to the last 2.6.x (which was 2.6.21, I think) 
then you can move to the last 3.x, then the current 4.x.


2. You don't have to go through every version, just the last of each 
major release. (you don't even have to install the x.0 versions either)


Regards,
Adrien

On 6/11/22 8:50 PM, Gyle McCollam wrote:

Kari,
You say you upgraded from an "ancient" version.  I have seen recommendations that users upgrade 
in steps , not a wholesale upgrade.  I would try uninstalling, then install the next major level, say 3.0.  
Try that and if it lets you in, run "Actions/Check & Repair/Check & Repair All".  Then 
upgrade to  v4.0 and repeat.  Once this is working, then upgrade to 4.1.  Good Luck!


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Startup issue - two windows

[Adrien Monteleone]

Thanks. I was chasing a ghost on that one.

John advised this has to do with the type of SLR window being used for 
SX. One is modal, the other not. Which one you see depends on if 
transactions were created and depends on your SX settings.


I guess my settings are such that I never get the modal window so I 
never see this problem. (I also turned off the splash screen and the Tip 
of the Day)


Regards,
Adrien

On 6/11/22 9:40 AM, Bruce Irving wrote:

Peppermint 10 does use LXDE as a DE.
PepermintOS has gone to XFCE and the same pattern exhibits itself there.
Brucce

On Fri, Jun 10, 2022 at 8:31 PM Adrien Monteleone <
adrien.montele...@lusfiber.net> wrote:


Would that Peppermint instance happen to be using LXDE as a DE by
chance? It appears the OP is using the same and I seem to recall
Peppermint once had it as a default.

I'm wondering if this has to do with certain package versions of parts
of GTK.


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
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 reorganize the account tree

[Alan A Holmes]

I wasn't complaining, it was just a comment.

But see the attachment, where "G" and "P" both come before "C". And there
are no leading spaces or non-printable characters.


Alan A Holmes

-Original Message-
From: gnucash-user
 On Behalf Of
Michael or Penny Novack
Sent: 12 June 2022 14:52
To: gnucash-user@gnucash.org
Subject: Re: [GNC] How to reorganize the account tree



> What I do notice sorting this way is that within the top level 
> accounts (Assets, Expenses, Income, etc.) that the 2nd and subsequent 
> level Accounts under Assets AREN'T sorted alphabetically, while those 
> under Expenses and Income ARE. I have insufficient sub-accounts under 
> Equity and Liabilities to be able to say.

WHAT are you saying, exactly?

The CoA is a TREE structure. The accounts at the same level of the tree
should be sorted in alpha-meric order. The sibling accounts (children of the
same parent account) should also be sorted that way AMONG THEMSELVES (but
not sorted that way with respect to children of different parents)

You aren't seeing the ultimate top level parent (aka "root") but "top level"
accounts like "asset", "liability", "equity", "income", "expense",
"Imbalance" are its children and so appear in sorted order. 
In other words, they are siblings at the highest level.

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
If you are using Nabble or Gmane, please see
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
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
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
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 reorganize the account tree

[Gyle McCollam]

Alan,
It sorts correctly in my GnuCash as well.  Are you sure it is sorting on the 
account column, it the only explanation I can think of?  Can't tell that from 
the narrow view in the attachment. I understand why the narrow view as you 
don't want to display the full account names.


Thank You,
Gyle McCollam

Gyle McCollam

609.680.2326 Mobile

gmccol...@live.com   email


From: gnucash-user  on 
behalf of Alan A Holmes 
Sent: Sunday, June 12, 2022 11:52 AM
To: stepbystepf...@comcast.net ; 
gnucash-user@gnucash.org 
Subject: Re: [GNC] How to reorganize the account tree

I wasn't complaining, it was just a comment.

But see the attachment, where "G" and "P" both come before "C". And there
are no leading spaces or non-printable characters.


Alan A Holmes

-Original Message-
From: gnucash-user
 On Behalf Of
Michael or Penny Novack
Sent: 12 June 2022 14:52
To: gnucash-user@gnucash.org
Subject: Re: [GNC] How to reorganize the account tree



> What I do notice sorting this way is that within the top level
> accounts (Assets, Expenses, Income, etc.) that the 2nd and subsequent
> level Accounts under Assets AREN'T sorted alphabetically, while those
> under Expenses and Income ARE. I have insufficient sub-accounts under
> Equity and Liabilities to be able to say.

WHAT are you saying, exactly?

The CoA is a TREE structure. The accounts at the same level of the tree
should be sorted in alpha-meric order. The sibling accounts (children of the
same parent account) should also be sorted that way AMONG THEMSELVES (but
not sorted that way with respect to children of different parents)

You aren't seeing the ultimate top level parent (aka "root") but "top level"
accounts like "asset", "liability", "equity", "income", "expense",
"Imbalance" are its children and so appear in sorted order.
In other words, they are siblings at the highest level.

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
If you are using Nabble or Gmane, please see
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
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
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] questions on 4.1

[D via gnucash-user]

Thanks for the kind words, Gyle.

On the topic, it'd be nice if the Accounts menu bar could somehow keep the 
options button (the aforementioned triangle) on screen, instead of being off 
screen to the far right. Maybe the button should go on the left?

David T. 

On Jun 12, 2022, 10:21, at 10:21, Gyle McCollam  wrote:
>Jay,
>Happy you found this helpful.  I respond to questions because others
>have responded to me or I have found their responses to other helpful,
>as you did this response.  I don't know enough programing, just enough
>to be dangerous, so I help where I can.  I have picked up several
>tip/tricks along the way and I am grateful to those who take the time
>to respond to questions.  I picked this up from a previous
>question/answer session and feel it is part of my obligation to pass it
>on when I can.  Several names keep appearing in response to questions. 
>Do you hear me: Adrein, David T, Michael, and others.  Thanks to you
>and everyone that takes the time!
>
>
>Thank You,
>Gyle McCollam
>
>Gyle McCollam
>
>609.680.2326 Mobile
>
>gmccol...@live.com   email
>
>
>From: ja...@comcast.net 
>Sent: Sunday, June 12, 2022 7:57 AM
>To: 'Gyle McCollam' 
>Subject: RE: [GNC] questions on 4.1
>
>Gyle, Thank you. I had overlooked that arrow and feature.
>
>-Original Message-
>From: gnucash-user 
>On
>Behalf Of Gyle McCollam
>Sent: Saturday, June 11, 2022 3:42 PM
>To: Top Cat ; gnucash-user@gnucash.org
>Subject: Re: [GNC] questions on 4.1
>
>I'm sure your aware, but just in case.  Did you know there is a down
>arrow
>at the far right of the account heading screen.  This allows you to add
>or
>remove columns from the accounts page.  Maybe, the account code box is
>not
>checked (3rd one down).
>
>
>Thank You,
>Gyle McCollam
>
>Gyle McCollam
>
>609.680.2326 Mobile
>
>gmccol...@live.com   email
>
>
>From: gnucash-user 
>on
>behalf of Top Cat 
>Sent: Saturday, June 11, 2022 12:44 PM
>To: gnucash-user@gnucash.org 
>Subject: [GNC] questions on 4.1
>
>I have been using gnucash since 2.x with a MySQL database
>
>
>
>I recently build a new machine and updated to 4.1, and have run into
>several
>issues
>
>1.  On the accounts page, I can no longer show the account numbers,
>or
>sort by them
>2.  On reconciliations, paired transactions (like transfers from
>one
>subaccount to another) no longer clear "both sides" when one is checked
>- it
>requires manually marking both sides separately.
>
>
>
>Is this correct behavior? Are there settings I am missing? do I need to
>reinstall/save and restore data?
>
>
>
>Any help would be appreciated
>
>___
>gnucash-user mailing list
>gnucash-user@gnucash.org
>To update your subscription preferences or to unsubscribe:
>https://lists.gnucash.org/mailman/listinfo/gnucash-user
>If you are using Nabble or Gmane, please see
>https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
>-
>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
>If you are using Nabble or Gmane, please see
>https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
>-
>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
>If you are using Nabble or Gmane, please see
>https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
>-
>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
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
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 reorganize the account tree

[Alan A Holmes]

Gyle,

 

As per my 1st reply

 

<< Personally, I sort on the Hidden column which I have displayed, mainly
because it puts the Imbalance and Orphan accounts together at the bottom of
the list and enables me to find errors in transactions quickly.

What I do notice sorting this way is that within the top level accounts
(Assets, Expenses, Income, etc.) that the 2nd and subsequent level Accounts
under Assets AREN'T sorted alphabetically, while those under Expenses and
Income ARE. I have insufficient sub-accounts under Equity and Liabilities to
be able to say.>>

 

 

 

Alan A Holmes

 

From: Gyle McCollam  
Sent: 12 June 2022 17:07
To: Alan A Holmes ; gnucash-user@gnucash.org
Subject: Re: [GNC] How to reorganize the account tree

 

Alan,

It sorts correctly in my GnuCash as well.  Are you sure it is sorting on the
account column, it the only explanation I can think of?  Can't tell that
from the narrow view in the attachment. I understand why the narrow view as
you don't want to display the full account names.

 

Thank You,   
Gyle McCollam

Gyle McCollam

609.680.2326 Mobile

  gmccol...@live.com   email

  _  

From: gnucash-user mailto:gnucash-user-bounces+gylemc=gmail@gnucash.org> > on behalf of
Alan A Holmes mailto:gnuc...@alanaholmes.me.uk>
>
Sent: Sunday, June 12, 2022 11:52 AM
To: stepbystepf...@comcast.net 
mailto:stepbystepf...@comcast.net> >;
gnucash-user@gnucash.org 
mailto:gnucash-user@gnucash.org> >
Subject: Re: [GNC] How to reorganize the account tree 

 

I wasn't complaining, it was just a comment.

But see the attachment, where "G" and "P" both come before "C". And there
are no leading spaces or non-printable characters.


Alan A Holmes

-Original Message-
From: gnucash-user
mailto:gnucash-user-bounces+gnucash=alanaholmes.me...@gnucash.org> > On
Behalf Of
Michael or Penny Novack
Sent: 12 June 2022 14:52
To: gnucash-user@gnucash.org  
Subject: Re: [GNC] How to reorganize the account tree



> What I do notice sorting this way is that within the top level 
> accounts (Assets, Expenses, Income, etc.) that the 2nd and subsequent 
> level Accounts under Assets AREN'T sorted alphabetically, while those 
> under Expenses and Income ARE. I have insufficient sub-accounts under 
> Equity and Liabilities to be able to say.

WHAT are you saying, exactly?

The CoA is a TREE structure. The accounts at the same level of the tree
should be sorted in alpha-meric order. The sibling accounts (children of the
same parent account) should also be sorted that way AMONG THEMSELVES (but
not sorted that way with respect to children of different parents)

You aren't seeing the ultimate top level parent (aka "root") but "top level"
accounts like "asset", "liability", "equity", "income", "expense",
"Imbalance" are its children and so appear in sorted order. 
In other words, they are siblings at the highest level.

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
If you are using Nabble or Gmane, please see
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
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
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] questions on 4.1

[Top Cat]

To clarify the situation I am having issues with:

*   I have Account A
*   I have two Subaccounts under A - B & C
*   I transferred funds from B to C (Transaction 1)
*   I then reconciled A and "include subaccounts"
*   When I mark Transaction 1B as reconciled on the reconciliation
screen, it used to mark 1C as reconciled as well; under 4.x it does not

 

I assume this to be my fault, but I cannot find any setting that would cause
this, nor does my data migration, since if I create a new transaction
(either as just a transaction or as an "official" transfer) it still
requires clearing both sides

 

It's not killing me; I just don't understand why it used to work and does
not now

 

From: Top Cat  
Sent: Sunday, June 12, 2022 11:18 AM
To: 'Gyle McCollam' ; 'Top Cat' ;
'gnucash-user@gnucash.org' 
Subject: RE: [GNC] questions on 4.1

 

I understand your thoughts, and don't disagree; the question was more that
it DID do this until I upgraded to 4.x

 

I'm not sure if something changed in gnucash4, or if I inadvertently broke
something in the migration and upgrade

 

From: Gyle McCollam mailto:gmccol...@live.com> > 
Sent: Sunday, June 12, 2022 10:38 AM
To: Top Cat mailto:t...@fractalcat.io> >;
gnucash-user@gnucash.org  
Subject: Re: [GNC] questions on 4.1

 

I only initially responded to the 1st question you raised.  However, as for
the 2nd question, I feel, that the software is operating correctly.  When
you are reconciling an account, say Bank A, you are reconciling only that
account, not the accounts that the other side of the transactions are posted
to.  When you reconcile those accounts, you would reconcile that half (or
less depending on how many splits there are).  Say the other half of the
split was Bank B, You wouldn't want to reconcile that transaction when you
do Bank A because when you get Bank B's statement, they may not have
credited your account (not likely, but) and it would make it harder to
determine where the error is at.

 

Thank You,   
Gyle McCollam

Gyle McCollam

609.680.2326 Mobile

  gmccol...@live.com   email

  _  

From: gnucash-user mailto:gnucash-user-bounces+gylemc=gmail@gnucash.org> > on behalf of
Gyle McCollam mailto:gmccol...@live.com> >
Sent: Sunday, June 12, 2022 10:20 AM
To: ja...@comcast.net   mailto:ja...@comcast.net> >; gnucash-user@gnucash.org
  mailto:gnucash-user@gnucash.org> >
Subject: Re: [GNC] questions on 4.1 

 

Jay,
Happy you found this helpful.  I respond to questions because others have
responded to me or I have found their responses to other helpful, as you did
this response.  I don't know enough programing, just enough to be dangerous,
so I help where I can.  I have picked up several tip/tricks along the way
and I am grateful to those who take the time to respond to questions.  I
picked this up from a previous question/answer session and feel it is part
of my obligation to pass it on when I can.  Several names keep appearing in
response to questions.  Do you hear me: Adrein, David T, Michael, and
others.  Thanks to you and everyone that takes the time!


Thank You,
Gyle McCollam

Gyle McCollam

609.680.2326 Mobile

gmccol...@live.com   email


From: ja...@comcast.net   mailto:ja...@comcast.net> >
Sent: Sunday, June 12, 2022 7:57 AM
To: 'Gyle McCollam' mailto:gmccol...@live.com> >
Subject: RE: [GNC] questions on 4.1

Gyle, Thank you. I had overlooked that arrow and feature.

-Original Message-
From: gnucash-user mailto:gnucash-user-bounces+jaypj=comcast@gnucash.org> > On
Behalf Of Gyle McCollam
Sent: Saturday, June 11, 2022 3:42 PM
To: Top Cat mailto:t...@fractalcat.io> >;
gnucash-user@gnucash.org  
Subject: Re: [GNC] questions on 4.1

I'm sure your aware, but just in case.  Did you know there is a down arrow
at the far right of the account heading screen.  This allows you to add or
remove columns from the accounts page.  Maybe, the account code box is not
checked (3rd one down).


Thank You,
Gyle McCollam

Gyle McCollam

609.680.2326 Mobile

gmccol...@live.com   email


From: gnucash-user mailto:gnucash-user-bounces+gylemc=gmail@gnucash.org> > on
behalf of Top Cat mailto:t...@fractalcat.io> >
Sent: Saturday, June 11, 2022 12:44 PM
To: gnucash-user@gnucash.org 
mailto:gnucash-user@gnucash.org> >
Subject: [GNC] questions on 4.1

I have been using gnucash since 2.x with a MySQL database



I recently build a new machine and updated to 4.1, and have run into several
issues

1.  On the accounts page, I can no longer show the account numbers, or
sort by them
2.  On reconci

Re: [GNC] questions on 4.1

[Top Cat]

I just tested against the same DB from three different machines -2 on 4.x
and 1 on 3.x

 

When I run it on Version: 3.7 Build ID: 3.7+(2019-09-07), it marks BOTH
transactions as reconciled

 

When I run it on Version: 4.10 Build ID: 4.10+(2022-03-26), it marks ONLY
the transaction that I mark, and I am required to reconcile both sides
separately

 

From: Top Cat  
Sent: Sunday, June 12, 2022 12:47 PM
To: 'gnucash-user@gnucash.org' 
Subject: RE: [GNC] questions on 4.1

 

To clarify the situation I am having issues with:

*   I have Account A
*   I have two Subaccounts under A - B & C
*   I transferred funds from B to C (Transaction 1)
*   I then reconciled A and "include subaccounts"
*   When I mark Transaction 1B as reconciled on the reconciliation
screen, it used to mark 1C as reconciled as well; under 4.x it does not

 

I assume this to be my fault, but I cannot find any setting that would cause
this, nor does my data migration, since if I create a new transaction
(either as just a transaction or as an "official" transfer) it still
requires clearing both sides

 

It's not killing me; I just don't understand why it used to work and does
not now

 

From: Top Cat mailto:t...@fractalcat.io> > 
Sent: Sunday, June 12, 2022 11:18 AM
To: 'Gyle McCollam' mailto:gmccol...@live.com> >; 'Top
Cat' mailto:t...@fractalcat.io> >;
'gnucash-user@gnucash.org' mailto:gnucash-user@gnucash.org> >
Subject: RE: [GNC] questions on 4.1

 

I understand your thoughts, and don't disagree; the question was more that
it DID do this until I upgraded to 4.x

 

I'm not sure if something changed in gnucash4, or if I inadvertently broke
something in the migration and upgrade

 

From: Gyle McCollam mailto:gmccol...@live.com> > 
Sent: Sunday, June 12, 2022 10:38 AM
To: Top Cat mailto:t...@fractalcat.io> >;
gnucash-user@gnucash.org  
Subject: Re: [GNC] questions on 4.1

 

I only initially responded to the 1st question you raised.  However, as for
the 2nd question, I feel, that the software is operating correctly.  When
you are reconciling an account, say Bank A, you are reconciling only that
account, not the accounts that the other side of the transactions are posted
to.  When you reconcile those accounts, you would reconcile that half (or
less depending on how many splits there are).  Say the other half of the
split was Bank B, You wouldn't want to reconcile that transaction when you
do Bank A because when you get Bank B's statement, they may not have
credited your account (not likely, but) and it would make it harder to
determine where the error is at.

 

Thank You,   
Gyle McCollam

Gyle McCollam

609.680.2326 Mobile

  gmccol...@live.com   email

  _  

From: gnucash-user mailto:gnucash-user-bounces+gylemc=gmail@gnucash.org> > on behalf of
Gyle McCollam mailto:gmccol...@live.com> >
Sent: Sunday, June 12, 2022 10:20 AM
To: ja...@comcast.net   mailto:ja...@comcast.net> >; gnucash-user@gnucash.org
  mailto:gnucash-user@gnucash.org> >
Subject: Re: [GNC] questions on 4.1 

 

Jay,
Happy you found this helpful.  I respond to questions because others have
responded to me or I have found their responses to other helpful, as you did
this response.  I don't know enough programing, just enough to be dangerous,
so I help where I can.  I have picked up several tip/tricks along the way
and I am grateful to those who take the time to respond to questions.  I
picked this up from a previous question/answer session and feel it is part
of my obligation to pass it on when I can.  Several names keep appearing in
response to questions.  Do you hear me: Adrein, David T, Michael, and
others.  Thanks to you and everyone that takes the time!


Thank You,
Gyle McCollam

Gyle McCollam

609.680.2326 Mobile

gmccol...@live.com   email


From: ja...@comcast.net   mailto:ja...@comcast.net> >
Sent: Sunday, June 12, 2022 7:57 AM
To: 'Gyle McCollam' mailto:gmccol...@live.com> >
Subject: RE: [GNC] questions on 4.1

Gyle, Thank you. I had overlooked that arrow and feature.

-Original Message-
From: gnucash-user mailto:gnucash-user-bounces+jaypj=comcast@gnucash.org> > On
Behalf Of Gyle McCollam
Sent: Saturday, June 11, 2022 3:42 PM
To: Top Cat mailto:t...@fractalcat.io> >;
gnucash-user@gnucash.org  
Subject: Re: [GNC] questions on 4.1

I'm sure your aware, but just in case.  Did you know there is a down arrow
at the far right of the account heading screen.  This allows you to add or
remove columns from the accounts page.  Maybe, the account code box is not
checked (3rd one down).


Thank You,
Gyle McCollam

Gyle McCollam

609.680.2326 Mobile

gmccol...@live.com 

Re: [GNC] questions on 4.1

[David Carlson]

What did it did?  I have never seen GnuCash reconciliation  mark any
transaction split account other than the account being reconciled since I
started using GnuCash 2.something less than 4 many years ago.

On Sun, Jun 12, 2022, 10:18 AM Top Cat  wrote:

> I understand your thoughts, and don't disagree; the question was more that
> it DID do this until I upgraded to 4.x
>
>
>
> I'm not sure if something changed in gnucash4, or if I inadvertently broke
> something in the migration and upgrade
>
>
>
> From: Gyle McCollam 
> Sent: Sunday, June 12, 2022 10:38 AM
> To: Top Cat ; gnucash-user@gnucash.org
> Subject: Re: [GNC] questions on 4.1
>
>
>
> I only initially responded to the 1st question you raised.  However, as for
> the 2nd question, I feel, that the software is operating correctly.  When
> you are reconciling an account, say Bank A, you are reconciling only that
> account, not the accounts that the other side of the transactions are
> posted
> to.  When you reconcile those accounts, you would reconcile that half (or
> less depending on how many splits there are).  Say the other half of the
> split was Bank B, You wouldn't want to reconcile that transaction when you
> do Bank A because when you get Bank B's statement, they may not have
> credited your account (not likely, but) and it would make it harder to
> determine where the error is at.
>
>
>
> Thank You,
> Gyle McCollam
>
> Gyle McCollam
>
> 609.680.2326 Mobile
>
>   gmccol...@live.com   email
>
>   _
>
> From: gnucash-user   > on behalf of
> Gyle McCollam mailto:gmccol...@live.com> >
> Sent: Sunday, June 12, 2022 10:20 AM
> To: ja...@comcast.net     >; gnucash-user@gnucash.org
>     >
> Subject: Re: [GNC] questions on 4.1
>
>
>
> Jay,
> Happy you found this helpful.  I respond to questions because others have
> responded to me or I have found their responses to other helpful, as you
> did
> this response.  I don't know enough programing, just enough to be
> dangerous,
> so I help where I can.  I have picked up several tip/tricks along the way
> and I am grateful to those who take the time to respond to questions.  I
> picked this up from a previous question/answer session and feel it is part
> of my obligation to pass it on when I can.  Several names keep appearing in
> response to questions.  Do you hear me: Adrein, David T, Michael, and
> others.  Thanks to you and everyone that takes the time!
>
>
> Thank You,
> Gyle McCollam
>
> Gyle McCollam
>
> 609.680.2326 Mobile
>
> gmccol...@live.com   email
>
> 
> From: ja...@comcast.net     >
> Sent: Sunday, June 12, 2022 7:57 AM
> To: 'Gyle McCollam' mailto:gmccol...@live.com> >
> Subject: RE: [GNC] questions on 4.1
>
> Gyle, Thank you. I had overlooked that arrow and feature.
>
> -Original Message-
> From: gnucash-user   > On
> Behalf Of Gyle McCollam
> Sent: Saturday, June 11, 2022 3:42 PM
> To: Top Cat mailto:t...@fractalcat.io> >;
> gnucash-user@gnucash.org 
> Subject: Re: [GNC] questions on 4.1
>
> I'm sure your aware, but just in case.  Did you know there is a down arrow
> at the far right of the account heading screen.  This allows you to add or
> remove columns from the accounts page.  Maybe, the account code box is not
> checked (3rd one down).
>
>
> Thank You,
> Gyle McCollam
>
> Gyle McCollam
>
> 609.680.2326 Mobile
>
> gmccol...@live.com   email
>
> 
> From: gnucash-user   > on
> behalf of Top Cat mailto:t...@fractalcat.io> >
> Sent: Saturday, June 11, 2022 12:44 PM
> To: gnucash-user@gnucash.org 
> mailto:gnucash-user@gnucash.org> >
> Subject: [GNC] questions on 4.1
>
> I have been using gnucash since 2.x with a MySQL database
>
>
>
> I recently build a new machine and updated to 4.1, and have run into
> several
> issues
>
> 1.  On the accounts page, I can no longer show the account numbers, or
> sort by them
> 2.  On reconciliations, paired transactions (like transfers from one
> subaccount to another) no longer clear "both sides" when one is checked -
> it
> requires manually marking both sides separately.
>
>
>
> Is this correct behavior? Are there settings I am missing? do I need to
> reinstall/save and restore data?
>
>
>
> Any help would be appreciated
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org 
> To update your subscripti

Re: [GNC] questions on 4.1

[David Carlson]

Oh, and Gyle very clearly explained why it it works the way it does.

On Sun, Jun 12, 2022, 12:48 PM David Carlson 
wrote:

> What did it did?  I have never seen GnuCash reconciliation  mark any
> transaction split account other than the account being reconciled since I
> started using GnuCash 2.something less than 4 many years ago.
>
> On Sun, Jun 12, 2022, 10:18 AM Top Cat  wrote:
>
>> I understand your thoughts, and don't disagree; the question was more that
>> it DID do this until I upgraded to 4.x
>>
>>
>>
>> I'm not sure if something changed in gnucash4, or if I inadvertently broke
>> something in the migration and upgrade
>>
>>
>>
>> From: Gyle McCollam 
>> Sent: Sunday, June 12, 2022 10:38 AM
>> To: Top Cat ; gnucash-user@gnucash.org
>> Subject: Re: [GNC] questions on 4.1
>>
>>
>>
>> I only initially responded to the 1st question you raised.  However, as
>> for
>> the 2nd question, I feel, that the software is operating correctly.  When
>> you are reconciling an account, say Bank A, you are reconciling only that
>> account, not the accounts that the other side of the transactions are
>> posted
>> to.  When you reconcile those accounts, you would reconcile that half (or
>> less depending on how many splits there are).  Say the other half of the
>> split was Bank B, You wouldn't want to reconcile that transaction when you
>> do Bank A because when you get Bank B's statement, they may not have
>> credited your account (not likely, but) and it would make it harder to
>> determine where the error is at.
>>
>>
>>
>> Thank You,
>> Gyle McCollam
>>
>> Gyle McCollam
>>
>> 609.680.2326 Mobile
>>
>>   gmccol...@live.com   email
>>
>>   _
>>
>> From: gnucash-user >  > on behalf of
>> Gyle McCollam mailto:gmccol...@live.com> >
>> Sent: Sunday, June 12, 2022 10:20 AM
>> To: ja...@comcast.net   >  >; gnucash-user@gnucash.org
>>   >  >
>> Subject: Re: [GNC] questions on 4.1
>>
>>
>>
>> Jay,
>> Happy you found this helpful.  I respond to questions because others have
>> responded to me or I have found their responses to other helpful, as you
>> did
>> this response.  I don't know enough programing, just enough to be
>> dangerous,
>> so I help where I can.  I have picked up several tip/tricks along the way
>> and I am grateful to those who take the time to respond to questions.  I
>> picked this up from a previous question/answer session and feel it is part
>> of my obligation to pass it on when I can.  Several names keep appearing
>> in
>> response to questions.  Do you hear me: Adrein, David T, Michael, and
>> others.  Thanks to you and everyone that takes the time!
>>
>>
>> Thank You,
>> Gyle McCollam
>>
>> Gyle McCollam
>>
>> 609.680.2326 Mobile
>>
>> gmccol...@live.com   email
>>
>> 
>> From: ja...@comcast.net   >  >
>> Sent: Sunday, June 12, 2022 7:57 AM
>> To: 'Gyle McCollam' mailto:gmccol...@live.com> >
>> Subject: RE: [GNC] questions on 4.1
>>
>> Gyle, Thank you. I had overlooked that arrow and feature.
>>
>> -Original Message-
>> From: gnucash-user >  > On
>> Behalf Of Gyle McCollam
>> Sent: Saturday, June 11, 2022 3:42 PM
>> To: Top Cat mailto:t...@fractalcat.io> >;
>> gnucash-user@gnucash.org 
>> Subject: Re: [GNC] questions on 4.1
>>
>> I'm sure your aware, but just in case.  Did you know there is a down arrow
>> at the far right of the account heading screen.  This allows you to add or
>> remove columns from the accounts page.  Maybe, the account code box is not
>> checked (3rd one down).
>>
>>
>> Thank You,
>> Gyle McCollam
>>
>> Gyle McCollam
>>
>> 609.680.2326 Mobile
>>
>> gmccol...@live.com   email
>>
>> 
>> From: gnucash-user >  > on
>> behalf of Top Cat mailto:t...@fractalcat.io> >
>> Sent: Saturday, June 11, 2022 12:44 PM
>> To: gnucash-user@gnucash.org 
>> mailto:gnucash-user@gnucash.org> >
>> Subject: [GNC] questions on 4.1
>>
>> I have been using gnucash since 2.x with a MySQL database
>>
>>
>>
>> I recently build a new machine and updated to 4.1, and have run into
>> several
>> issues
>>
>> 1.  On the accounts page, I can no longer show the account numbers, or
>> sort by them
>> 2.  On reconciliations, paired transactions (like transfers from one
>> subaccount to another) no longer clear "both sides" when one is checked -
>> it
>> requires manually marking both sides separately.
>>
>>
>>
>> Is this correct behavior? Are there 

Re: [GNC] questions on 4.1

[David Carlson]

TopCat,
Sorry for my seemingly dismissive reply earlier.

In my Gmail I completely missed your detailed description about how 3.7 and
4.1 actually work today on your machines until I finally found it by
drilling down into thread history.  I do not like how Gmail does that, but
I cannot solve that right now.

I personally do not have subaccounts under bank accounts that I reconcile
by that method so I have not seen your issue, but it appears to be a bug in
release 3.7 that has been fixed in release 4.1.  I doubt that the
developers would entertain a request to revert to previous behavior, but
you are free to ask.



On Sun, Jun 12, 2022 at 12:54 PM David Carlson 
wrote:

> Oh, and Gyle very clearly explained why it it works the way it does.
>
> On Sun, Jun 12, 2022, 12:48 PM David Carlson 
> wrote:
>
>> What did it did?  I have never seen GnuCash reconciliation  mark any
>> transaction split account other than the account being reconciled since I
>> started using GnuCash 2.something less than 4 many years ago.
>>
>> On Sun, Jun 12, 2022, 10:18 AM Top Cat  wrote:
>>
>>> I understand your thoughts, and don't disagree; the question was more
>>> that
>>> it DID do this until I upgraded to 4.x
>>>
>>>
>>>
>>> I'm not sure if something changed in gnucash4, or if I inadvertently
>>> broke
>>> something in the migration and upgrade
>>>
>>>
>>>
>>> From: Gyle McCollam 
>>> Sent: Sunday, June 12, 2022 10:38 AM
>>> To: Top Cat ; gnucash-user@gnucash.org
>>> Subject: Re: [GNC] questions on 4.1
>>>
>>>
>>>
>>> I only initially responded to the 1st question you raised.  However, as
>>> for
>>> the 2nd question, I feel, that the software is operating correctly.  When
>>> you are reconciling an account, say Bank A, you are reconciling only that
>>> account, not the accounts that the other side of the transactions are
>>> posted
>>> to.  When you reconcile those accounts, you would reconcile that half (or
>>> less depending on how many splits there are).  Say the other half of the
>>> split was Bank B, You wouldn't want to reconcile that transaction when
>>> you
>>> do Bank A because when you get Bank B's statement, they may not have
>>> credited your account (not likely, but) and it would make it harder to
>>> determine where the error is at.
>>>
>>>
>>>
>>> Thank You,
>>> Gyle McCollam
>>>
>>> Gyle McCollam
>>>
>>> 609.680.2326 Mobile
>>>
>>>   gmccol...@live.com   email
>>>
>>>   _
>>>
>>> From: gnucash-user >>  > on behalf
>>> of
>>> Gyle McCollam mailto:gmccol...@live.com> >
>>> Sent: Sunday, June 12, 2022 10:20 AM
>>> To: ja...@comcast.net   >>  >; gnucash-user@gnucash.org
>>>   >>  >
>>> Subject: Re: [GNC] questions on 4.1
>>>
>>>
>>>
>>> Jay,
>>> Happy you found this helpful.  I respond to questions because others have
>>> responded to me or I have found their responses to other helpful, as you
>>> did
>>> this response.  I don't know enough programing, just enough to be
>>> dangerous,
>>> so I help where I can.  I have picked up several tip/tricks along the way
>>> and I am grateful to those who take the time to respond to questions.  I
>>> picked this up from a previous question/answer session and feel it is
>>> part
>>> of my obligation to pass it on when I can.  Several names keep appearing
>>> in
>>> response to questions.  Do you hear me: Adrein, David T, Michael, and
>>> others.  Thanks to you and everyone that takes the time!
>>>
>>>
>>> Thank You,
>>> Gyle McCollam
>>>
>>> Gyle McCollam
>>>
>>> 609.680.2326 Mobile
>>>
>>> gmccol...@live.com   email
>>>
>>> 
>>> From: ja...@comcast.net   >>  >
>>> Sent: Sunday, June 12, 2022 7:57 AM
>>> To: 'Gyle McCollam' mailto:gmccol...@live.com> >
>>> Subject: RE: [GNC] questions on 4.1
>>>
>>> Gyle, Thank you. I had overlooked that arrow and feature.
>>>
>>> -Original Message-
>>> From: gnucash-user >>  > On
>>> Behalf Of Gyle McCollam
>>> Sent: Saturday, June 11, 2022 3:42 PM
>>> To: Top Cat mailto:t...@fractalcat.io> >;
>>> gnucash-user@gnucash.org 
>>> Subject: Re: [GNC] questions on 4.1
>>>
>>> I'm sure your aware, but just in case.  Did you know there is a down
>>> arrow
>>> at the far right of the account heading screen.  This allows you to add
>>> or
>>> remove columns from the accounts page.  Maybe, the account code box is
>>> not
>>> checked (3rd one down).
>>>
>>>
>>> Thank You,
>>> Gyle McCollam
>>>
>>> Gyle McCollam
>>>
>>> 609.680.2326 Mobile
>>>
>>> gmccol...@live.com   email
>>>
>>> 
>>>

Re: [GNC] Entry Point Not Found error

[Gyle McCollam]

Kari,
Do you use GnuCash standard file (XML) or do you use a DB program.  When you do 
a file open it defaults to file which is XML.  If you used a DB, after you did 
a File/Open, you would have the change the "Data Format" at the top middle of 
the "Open" dialogue.  I have never used a DB, so this may be totally off the 
mark.


Thank You,
Gyle McCollam

Gyle McCollam

609.680.2326 Mobile

gmccol...@live.com   email


From: Kari E 
Sent: Sunday, June 12, 2022 2:25 PM
To: Gyle McCollam 
Cc: gnucash-user@gnucash.org 
Subject: Re: [GNC] Entry Point Not Found error

Still struggling, but making progress!  So I uninstalled gnucash 4.10, 
rebooted, and reinstalled from a new download.  Now the app starts and seems to 
run correctly (I think I may have gotten a corrupted install file via 
download).  But when I run the app and choose FILE, OPEN and point it at my 
backed up file June2022.gnucash.gcm I get an error "no suitable backend was 
found for  D:\Documents\gnucash\books\June2022.gnucash.gcm"  I know this file 
is good, as it works with older versions of Gnucash on a W7 PC.  So I suspect 
it is a problem with using the new version app against an old version file.

The word "backend" is only found once in the gnucash help, so I am at a loss as 
to what to do next.  I have tried to import, but there doesnt seem to be any 
import function from older versions.  Any help would be greatly appreciated.

On Sat, Jun 11, 2022 at 9:50 PM Gyle McCollam 
mailto:gmccol...@live.com>> wrote:
Kari,
You say you upgraded from an "ancient" version.  I have seen recommendations 
that users upgrade in steps , not a wholesale upgrade.  I would try 
uninstalling, then install the next major level, say 3.0.  Try that and if it 
lets you in, run "Actions/Check & Repair/Check & Repair All".  Then upgrade to  
v4.0 and repeat.  Once this is working, then upgrade to 4.1.  Good Luck!


Thank You,
Gyle McCollam

Gyle McCollam

609.680.2326 Mobile

gmccol...@live.com   email


From: gnucash-user 
mailto:gmail@gnucash.org>>
 on behalf of Kari E 
mailto:kari.elliott...@gmail.com>>
Sent: Saturday, June 11, 2022 9:48 AM
To: gnucash-user@gnucash.org 
mailto:gnucash-user@gnucash.org>>
Subject: [GNC] Entry Point Not Found error

64 bit Windows 10 Home, I have been running ancient version of Gnucash, and
I updated to latest version, and when I attempt to run the app or double
click on the gnucash book, I get:

"The procedure entry point inflateValidate could not be located in the
dynamic link library D:\program Files\gnucash\bin\libpng16-16.dll"

Search brings me an unhelpful post from 5 years ago (
https://lists.gnucash.org/pipermail/gnucash-user/2018-June/077629.html )
but nothing else.  How do I get gnucash running again?

Kari Elliott
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
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
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Entry Point Not Found error

[Derek Atkins]

The GCM file is a GnuCash Metadata file.
It is not your data file, so you cannot open it.

-derek
Sent using my mobile device. Please excuse any typos.
On June 12, 2022 4:38:19 PM Gyle McCollam  wrote:


Kari,
Do you use GnuCash standard file (XML) or do you use a DB program.  When 
you do a file open it defaults to file which is XML.  If you used a DB, 
after you did a File/Open, you would have the change the "Data Format" at 
the top middle of the "Open" dialogue.  I have never used a DB, so this may 
be totally off the mark.



Thank You,
Gyle McCollam

Gyle McCollam

609.680.2326 Mobile

gmccol...@live.com   email


From: Kari E 
Sent: Sunday, June 12, 2022 2:25 PM
To: Gyle McCollam 
Cc: gnucash-user@gnucash.org 
Subject: Re: [GNC] Entry Point Not Found error

Still struggling, but making progress!  So I uninstalled gnucash 4.10, 
rebooted, and reinstalled from a new download.  Now the app starts and 
seems to run correctly (I think I may have gotten a corrupted install file 
via download).  But when I run the app and choose FILE, OPEN and point it 
at my backed up file June2022.gnucash.gcm I get an error "no suitable 
backend was found for  D:\Documents\gnucash\books\June2022.gnucash.gcm"  I 
know this file is good, as it works with older versions of Gnucash on a W7 
PC.  So I suspect it is a problem with using the new version app against an 
old version file.


The word "backend" is only found once in the gnucash help, so I am at a 
loss as to what to do next.  I have tried to import, but there doesnt seem 
to be any import function from older versions.  Any help would be greatly 
appreciated.


On Sat, Jun 11, 2022 at 9:50 PM Gyle McCollam 
mailto:gmccol...@live.com>> wrote:

Kari,
You say you upgraded from an "ancient" version.  I have seen 
recommendations that users upgrade in steps , not a wholesale upgrade.  I 
would try uninstalling, then install the next major level, say 3.0.  Try 
that and if it lets you in, run "Actions/Check & Repair/Check & Repair 
All".  Then upgrade to  v4.0 and repeat.  Once this is working, then 
upgrade to 4.1.  Good Luck!



Thank You,
Gyle McCollam

Gyle McCollam

609.680.2326 Mobile

gmccol...@live.com   email


From: gnucash-user 
mailto:gmail@gnucash.org>> 
on behalf of Kari E 
mailto:kari.elliott...@gmail.com>>

Sent: Saturday, June 11, 2022 9:48 AM
To: gnucash-user@gnucash.org 
mailto:gnucash-user@gnucash.org>>

Subject: [GNC] Entry Point Not Found error

64 bit Windows 10 Home, I have been running ancient version of Gnucash, and
I updated to latest version, and when I attempt to run the app or double
click on the gnucash book, I get:

"The procedure entry point inflateValidate could not be located in the
dynamic link library D:\program Files\gnucash\bin\libpng16-16.dll"

Search brings me an unhelpful post from 5 years ago (
https://lists.gnucash.org/pipermail/gnucash-user/2018-June/077629.html )
but nothing else.  How do I get gnucash running again?

Kari Elliott
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.

-
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
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.

-
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
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Entry Point Not Found error

[Kari E]

 Still struggling, but making progress!  So I uninstalled gnucash 4.10,
rebooted, and reinstalled from a new download.  Now the app starts and
seems to run correctly (I think I may have gotten a corrupted install file
via download).  But when I run the app and choose FILE, OPEN and point it
at my backed up file June2022.gnucash.gcm I get an error "no suitable
backend was found for  D:\Documents\gnucash\books\June2022.gnucash.gcm"  I
know this file is good, as it works with older versions of Gnucash on a W7
PC.  So I suspect it is a problem with using the new version app against an
old version file.

The word "backend" is only found once in the gnucash help, so I am at a
loss as to what to do next.  I have tried to import, but there doesnt seem
to be any import function from older versions.  Any help would be greatly
appreciated.

On Sat, Jun 11, 2022 at 9:50 PM Gyle McCollam  wrote:

> Kari,
> You say you upgraded from an "ancient" version.  I have seen
> recommendations that users upgrade in steps , not a wholesale upgrade.  I
> would try uninstalling, then install the next major level, say 3.0.  Try
> that and if it lets you in, run "Actions/Check & Repair/Check & Repair
> All".  Then upgrade to  v4.0 and repeat.  Once this is working, then
> upgrade to 4.1.  Good Luck!
>
> Thank You,
> *Gyle McCollam*
>
> Gyle McCollam
>
> 609.680.2326 Mobile
>
> gmccol...@live.comemail
> --
> *From:* gnucash-user 
> on behalf of Kari E 
> *Sent:* Saturday, June 11, 2022 9:48 AM
> *To:* gnucash-user@gnucash.org 
> *Subject:* [GNC] Entry Point Not Found error
>
> 64 bit Windows 10 Home, I have been running ancient version of Gnucash, and
> I updated to latest version, and when I attempt to run the app or double
> click on the gnucash book, I get:
>
> "The procedure entry point inflateValidate could not be located in the
> dynamic link library D:\program Files\gnucash\bin\libpng16-16.dll"
>
> Search brings me an unhelpful post from 5 years ago (
> https://lists.gnucash.org/pipermail/gnucash-user/2018-June/077629.html )
> but nothing else.  How do I get gnucash running again?
>
> Kari Elliott
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> 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
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Entry Point Not Found error

[Derek Atkins]

HI,

The file you want is "June2022.gnucash", not "June2022.gnucash.gcm"
The GCM file, as I mentioned earlier, is a GnuCash Metadata file, not your
actual data file.

-derek

On Sun, June 12, 2022 2:25 pm, Kari E wrote:
>  Still struggling, but making progress!  So I uninstalled gnucash 4.10,
> rebooted, and reinstalled from a new download.  Now the app starts and
> seems to run correctly (I think I may have gotten a corrupted install file
> via download).  But when I run the app and choose FILE, OPEN and point it
> at my backed up file June2022.gnucash.gcm I get an error "no suitable
> backend was found for  D:\Documents\gnucash\books\June2022.gnucash.gcm"  I
> know this file is good, as it works with older versions of Gnucash on a W7
> PC.  So I suspect it is a problem with using the new version app against
> an
> old version file.
>
> The word "backend" is only found once in the gnucash help, so I am at a
> loss as to what to do next.  I have tried to import, but there doesnt seem
> to be any import function from older versions.  Any help would be greatly
> appreciated.
>
> On Sat, Jun 11, 2022 at 9:50 PM Gyle McCollam  wrote:
>
>> Kari,
>> You say you upgraded from an "ancient" version.  I have seen
>> recommendations that users upgrade in steps , not a wholesale upgrade.
>> I
>> would try uninstalling, then install the next major level, say 3.0.  Try
>> that and if it lets you in, run "Actions/Check & Repair/Check & Repair
>> All".  Then upgrade to  v4.0 and repeat.  Once this is working, then
>> upgrade to 4.1.  Good Luck!
>>
>> Thank You,
>> *Gyle McCollam*
>>
>> Gyle McCollam
>>
>> 609.680.2326 Mobile
>>
>> gmccol...@live.comemail
>> --
>> *From:* gnucash-user 
>> on behalf of Kari E 
>> *Sent:* Saturday, June 11, 2022 9:48 AM
>> *To:* gnucash-user@gnucash.org 
>> *Subject:* [GNC] Entry Point Not Found error
>>
>> 64 bit Windows 10 Home, I have been running ancient version of Gnucash,
>> and
>> I updated to latest version, and when I attempt to run the app or double
>> click on the gnucash book, I get:
>>
>> "The procedure entry point inflateValidate could not be located in the
>> dynamic link library D:\program Files\gnucash\bin\libpng16-16.dll"
>>
>> Search brings me an unhelpful post from 5 years ago (
>> https://lists.gnucash.org/pipermail/gnucash-user/2018-June/077629.html )
>> but nothing else.  How do I get gnucash running again?
>>
>> Kari Elliott
>> ___
>> gnucash-user mailing list
>> gnucash-user@gnucash.org
>> To update your subscription preferences or to unsubscribe:
>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>> If you are using Nabble or Gmane, please see
>> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
>> -
>> 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
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> 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
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] questions on 4.1

[Top Cat]

As my children often say – zok

 

I really was not offended by the tone at all, nor was I trying to force a 
fallback. I was just baffled by the change, and couldn’t determine if I had 
missed a setting, or if it was change in behavior

 

I appreciate everything the gnucash team does – both product and support – and 
LOVE the product

 

Thanks for all the hard work from all of y’all

 

From: David Carlson  
Sent: Sunday, June 12, 2022 4:12 PM
To: Top Cat 
Cc: Gyle McCollam ; Gnucash Users 
Subject: Re: [GNC] questions on 4.1

 

TopCat,

Sorry for my seemingly dismissive reply earlier.

 

In my Gmail I completely missed your detailed description about how 3.7 and 4.1 
actually work today on your machines until I finally found it by drilling down 
into thread history.  I do not like how Gmail does that, but I cannot solve 
that right now.

 

I personally do not have subaccounts under bank accounts that I reconcile by 
that method so I have not seen your issue, but it appears to be a bug in 
release 3.7 that has been fixed in release 4.1.  I doubt that the developers 
would entertain a request to revert to previous behavior, but you are free to 
ask. 

 

  

 

On Sun, Jun 12, 2022 at 12:54 PM David Carlson mailto:david.carlson@gmail.com> > wrote:

Oh, and Gyle very clearly explained why it it works the way it does.

 

On Sun, Jun 12, 2022, 12:48 PM David Carlson mailto:david.carlson@gmail.com> > wrote:

What did it did?  I have never seen GnuCash reconciliation  mark any 
transaction split account other than the account being reconciled since I 
started using GnuCash 2.something less than 4 many years ago.

 

On Sun, Jun 12, 2022, 10:18 AM Top Cat mailto:t...@fractalcat.io> > wrote:

I understand your thoughts, and don't disagree; the question was more that
it DID do this until I upgraded to 4.x



I'm not sure if something changed in gnucash4, or if I inadvertently broke
something in the migration and upgrade



From: Gyle McCollam mailto:gmccol...@live.com> > 
Sent: Sunday, June 12, 2022 10:38 AM
To: Top Cat mailto:t...@fractalcat.io> >; 
gnucash-user@gnucash.org  
Subject: Re: [GNC] questions on 4.1



I only initially responded to the 1st question you raised.  However, as for
the 2nd question, I feel, that the software is operating correctly.  When
you are reconciling an account, say Bank A, you are reconciling only that
account, not the accounts that the other side of the transactions are posted
to.  When you reconcile those accounts, you would reconcile that half (or
less depending on how many splits there are).  Say the other half of the
split was Bank B, You wouldn't want to reconcile that transaction when you
do Bank A because when you get Bank B's statement, they may not have
credited your account (not likely, but) and it would make it harder to
determine where the error is at.



Thank You,   
Gyle McCollam

Gyle McCollam

609.680.2326 Mobile

  > 
gmccol...@live.com email

  _  

From: gnucash-user mailto:gmail@gnucash.org> 
 
=gmail@gnucash.org  > > on behalf of
Gyle McCollam mailto:gmccol...@live.com>  
 > >
Sent: Sunday, June 12, 2022 10:20 AM
To: ja...@comcast.net    >  mailto:ja...@comcast.net> 
 > >; 
gnucash-user@gnucash.org  
 >  
mailto:gnucash-user@gnucash.org> 
 > >
Subject: Re: [GNC] questions on 4.1 



Jay,
Happy you found this helpful.  I respond to questions because others have
responded to me or I have found their responses to other helpful, as you did
this response.  I don't know enough programing, just enough to be dangerous,
so I help where I can.  I have picked up several tip/tricks along the way
and I am grateful to those who take the time to respond to questions.  I
picked this up from a previous question/answer session and feel it is part
of my obligation to pass it on when I can.  Several names keep appearing in
response to questions.  Do you hear me: Adrein, David T, Michael, and
others.  Thanks to you and everyone that takes the time!


Thank You,
Gyle McCollam

Gyle McCollam

609.680.2326 Mobile

gmccol...@live.com  
   email


From: ja...@comcast.net    >  mailto:ja...@comcast.net> 
 

Re: [GNC] questions on 4.1

[Chris Good]

From: gnucash-user mailto:gmail@gnucash.org> 

=gmail@gnucash.org  > > on
behalf of Top Cat mailto:t...@fractalcat.io>
 > >
Sent: Saturday, June 11, 2022 12:44 PM
To: gnucash-user@gnucash.org 
 >
mailto:gnucash-user@gnucash.org>
 > >
Subject: [GNC] questions on 4.1

I have been using gnucash since 2.x with a MySQL database


I recently build a new machine and updated to 4.1, and have run into several
issues

1.  On the accounts page, I can no longer show the account numbers, or
sort by them
2.  On reconciliations, paired transactions (like transfers from one
subaccount to another) no longer clear "both sides" when one is checked - it
requires manually marking both sides separately.


Is this correct behavior? Are there settings I am missing? do I need to
reinstall/save and restore data?

Any help would be appreciated

___

Hi Top Cat,

Re 2.:
This behaviour changed in 3.9. and again in 3.11 as detailed in  Bug 797648
https://bugs.gnucash.org/show_bug.cgi?id=797648.

BTW,  The changes in each release are listed at 
https://www.gnucash.org/news.phtml.

Regards,
Chris Good

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] questions on 4.1

[David Carlson]

Chris,

Thank you for your input.  However, your reference to a bug that was
created in release 3.9 and reverted in 3.11 may not be identical to the
behavior that Top Cat saw in release 3.7 which seems to be different in
release 4.1.

Is it possible that the reversion in 3.11 did not exactly return to the
behavior of releases prior to release 3.9?  If so, which is correct or at
least preferable?

On Sun, Jun 12, 2022, 8:21 PM Chris Good  wrote:

> From: gnucash-user  
> 
> =gmail@gnucash.org  > > on
> behalf of Top Cat mailto:t...@fractalcat.io>
>  > >
> Sent: Saturday, June 11, 2022 12:44 PM
> To: gnucash-user@gnucash.org 
>  >
> mailto:gnucash-user@gnucash.org>
>  > >
> Subject: [GNC] questions on 4.1
>
> I have been using gnucash since 2.x with a MySQL database
>
>
> I recently build a new machine and updated to 4.1, and have run into
> several
> issues
>
> 1.  On the accounts page, I can no longer show the account numbers, or
> sort by them
> 2.  On reconciliations, paired transactions (like transfers from one
> subaccount to another) no longer clear "both sides" when one is checked -
> it
> requires manually marking both sides separately.
>
>
> Is this correct behavior? Are there settings I am missing? do I need to
> reinstall/save and restore data?
>
> Any help would be appreciated
>
> ___
>
> Hi Top Cat,
>
> Re 2.:
> This behaviour changed in 3.9. and again in 3.11 as detailed in  Bug 797648
> https://bugs.gnucash.org/show_bug.cgi?id=797648.
>
> BTW,  The changes in each release are listed at
> https://www.gnucash.org/news.phtml.
>
> Regards,
> Chris Good
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> 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
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] register description field width

[Glenn Fowler]

There isn't a value for the description field. You can set the others as
you found out. The description width is basically what is left over from
the width of the other columns you set.

On Fri, Jun 10, 2022 at 10:51 AM Kevin T  wrote:

> I have found the file in question.
> I edited the file in question, with vim a text editor, to make all the non
> description fields the same.  save the file.
> I start the tool.
> If I change anything, window size, or field size of some tab, any tab, the
> file is overwritten by the tool.  vim notifies me that the file has changed.
>
> I have learned more about the behavior of the tool which makes it
> understandable at least.  Not preferable, but understandable.
>
> Kevin
>
>
> On Thursday, May 26, 2022, 08:24:57 PM CDT, Kevin T 
> wrote:
>
>
> i have scanned the directories mentioned for entries with 'description'
> and 'width'.  I can find nothing that is specific to the 'Description'
> field in the support files that exist.
>
> again this is a windows install.
>
> do know what file, in what directory, with what content, you modified?
>
> Kevin
>
>
> On Thursday, May 26, 2022, 06:48:33 AM CDT, Glenn Fowler <
> gfowl...@outlook.com> wrote:
>
>
> Hi,
>
> If you want to hardcode the widths of columns, you can do that in user
> data. I wanted my books and accounts to all be exactly the same so I did it
> this way.
>
> Depending on your OS, the user data locations are described here:
> https://wiki.gnucash.org/wiki/Configuration_Locations
>
> On Thu, May 26, 2022 at 12:11 AM Kevin T via gnucash-user <
> gnucash-user@gnucash.org> wrote:
>
> I have found how to make the fonts large enough to read through inspection
> of the mailing list history.  it is now 14pt.
> This is great but now the gnucash window has to be almost, 80% of my
> screen width.  70% of that width is due to the width of the description
> field.   through the mailing lists I have found that double clicking the
> vertical bars between the fields will adjust them to the width of the
> data.  It works for all but the description field.  This field behaves as
> if there is an extra 200 spaces attached to the end of each entry.  Trying
> to pull the right hand vertical bar will move the header, temporarily, but
> the field width remains the same.
> Is there some way to hard code, force, change the width of the description
> field?
>
> Kevin
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> 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
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] questions on 4.1

[Chris Good]

Hi David,

 

In 3.9, it was changed so that changing 1 split for the bank account (or it’s 
subaccounts) changed all splits for the bank account (and it’s subaccounts) to 
the new status, rather than toggling the status of the other splits. Toggling 
means: c to n and n to c.

In 3.11 it was changed so that other splits are NOT modified so that the status 
of each split can be individually maintained in the reconcile window.

 

Regards,

Chris Good

 

From: David Carlson  
Sent: Monday, 13 June 2022 11:59 AM
To: Chris Good 
Cc: Gnucash Users ; Top Cat 
Subject: Re: [GNC] questions on 4.1

 

Chris,

 

Thank you for your input.  However, your reference to a bug that was created in 
release 3.9 and reverted in 3.11 may not be identical to the behavior that Top 
Cat saw in release 3.7 which seems to be different in release 4.1.

 

Is it possible that the reversion in 3.11 did not exactly return to the 
behavior of releases prior to release 3.9?  If so, which is correct or at least 
preferable?

 

On Sun, Jun 12, 2022, 8:21 PM Chris Good mailto:goodchri...@gmail.com> > wrote:

From: gnucash-user mailto:gmail@gnucash.org> 
 > 
  
 >
=gmail@gnucash.org   
 > > > on
behalf of Top Cat mailto:t...@fractalcat.io>  
 >
  
 > > >
Sent: Saturday, June 11, 2022 12:44 PM
To: gnucash-user@gnucash.org   
 >
  
 > >
mailto:gnucash-user@gnucash.org>  
 >
  
 > > >
Subject: [GNC] questions on 4.1

I have been using gnucash since 2.x with a MySQL database


I recently build a new machine and updated to 4.1, and have run into several
issues

1.  On the accounts page, I can no longer show the account numbers, or
sort by them
2.  On reconciliations, paired transactions (like transfers from one
subaccount to another) no longer clear "both sides" when one is checked - it
requires manually marking both sides separately.


Is this correct behavior? Are there settings I am missing? do I need to
reinstall/save and restore data?

Any help would be appreciated

___

Hi Top Cat,

Re 2.:
This behaviour changed in 3.9. and again in 3.11 as detailed in  Bug 797648
https://bugs.gnucash.org/show_bug.cgi?id=797648.

BTW,  The changes in each release are listed at 
https://www.gnucash.org/news.phtml.

Regards,
Chris Good

___
gnucash-user mailing list
gnucash-user@gnucash.org  
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
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
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] questions on 4.1

[Geoff]

> In 3.11 it was changed so that other splits are NOT modified so that 
the status of each split can be individually maintained in the reconcile 
window.


Which is for me a really useful feature!

Geoff
=

On 13/06/2022 12:24 pm, Chris Good wrote:

Hi David,

  


In 3.9, it was changed so that changing 1 split for the bank account (or it’s 
subaccounts) changed all splits for the bank account (and it’s subaccounts) to 
the new status, rather than toggling the status of the other splits. Toggling 
means: c to n and n to c.

In 3.11 it was changed so that other splits are NOT modified so that the status 
of each split can be individually maintained in the reconcile window.

  


Regards,

Chris Good

  


From: David Carlson 
Sent: Monday, 13 June 2022 11:59 AM
To: Chris Good 
Cc: Gnucash Users ; Top Cat 
Subject: Re: [GNC] questions on 4.1

  


Chris,

  


Thank you for your input.  However, your reference to a bug that was created in 
release 3.9 and reverted in 3.11 may not be identical to the behavior that Top 
Cat saw in release 3.7 which seems to be different in release 4.1.

  


Is it possible that the reversion in 3.11 did not exactly return to the 
behavior of releases prior to release 3.9?  If so, which is correct or at least 
preferable?

  


On Sun, Jun 12, 2022, 8:21 PM Chris Good mailto:goodchri...@gmail.com> > wrote:

From: gnucash-user mailto:gmail@gnucash.org>
 >
  
 >
=gmail@gnucash.org    > > > on
behalf of Top Cat mailto:t...@fractalcat.io>  
 >
   > > >
Sent: Saturday, June 11, 2022 12:44 PM
To: gnucash-user@gnucash.org   
 >
  
 > >
mailto:gnucash-user@gnucash.org>  
 >
  
 > > >
Subject: [GNC] questions on 4.1

I have been using gnucash since 2.x with a MySQL database


I recently build a new machine and updated to 4.1, and have run into several
issues

1.  On the accounts page, I can no longer show the account numbers, or
sort by them
2.  On reconciliations, paired transactions (like transfers from one
subaccount to another) no longer clear "both sides" when one is checked - it
requires manually marking both sides separately.


Is this correct behavior? Are there settings I am missing? do I need to
reinstall/save and restore data?

Any help would be appreciated

___

Hi Top Cat,

Re 2.:
This behaviour changed in 3.9. and again in 3.11 as detailed in  Bug 797648
https://bugs.gnucash.org/show_bug.cgi?id=797648.

BTW,  The changes in each release are listed at
https://www.gnucash.org/news.phtml.

Regards,
Chris Good

___
gnucash-user mailing list
gnucash-user@gnucash.org 
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
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
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
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
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] importing csv and negative numbers

[Kevin T via gnucash-user]

It seems that when importing CSV files, to a CC account, if the 'credit' 
column, which when imported is called the 'deposit' field, has a negative value 
in it, it is imported as a 'debit' transaction.  I have to refer to the 
statement, to find which of these transactions are supposed to be credits.   IE 
i can't trust the import.
is there any way to work around this behavior.
Kevin
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
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 csv and negative numbers

[Stan Brown]

On 2022-06-12 22:00, Kevin T via gnucash-user wrote:
> It seems that when importing CSV files, to a CC account, if the
> 'credit' column, which when imported is called the 'deposit' field,
> has a negative value in it, it is imported as a 'debit' transaction.
> I have to refer to the statement, to find which of these transactions
> are supposed to be credits.   IE i can't trust the import.> is there any way 
> to work around this behavior.

Can you clarify please?  Do you mean that
(a) a credit column in CSV contains minus $100.00, the import shows
POSITIVE $100.00 in the debit column and nothing in credit, or
(a) a credit column in CSV contains minus $100.00, the import shows
NEGATIVE $100.00 in the debit column and nothing in credit, or
(c) something else?

If it's (a), that's correct and consistent behavior. GC won't let you
manually enter a transaction with a negative number in credit or debit;
it changes that to a positive number in debit or credit respectively.
After all, a credit of minus $100 is equivalent to a debit of plus $100.
If this is what is happening, you _can_ trust the import. And while I
myself have had instances where I wanted to record something as a
negative credit rather than a positive debit, as far as I know there's
no way to do that. And after all, the two _are_ equivalent so it's
purely a matter of presentation and not of incorrect numbers.

If you mean (b), something seems off. I'll let others, who are more
familiar with the details of importing, ask you questions. (One thing
you could and should always do, when reporting a possible problem, is
state which version number of GC you're using, which operating system,
and whether you're using a prebuilt version or you compiled it yourself.)

If you mean (c), please explain all that is in the CSV file for this
transaction, and all that is in the transaction after import. Screen
shots might help; be sure to attach them, as opposed to including them
inline in HTML.

-- 
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
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
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 csv and negative numbers

[davidcousens49]

The difficulty is that the sign convention in a CSV file is normally determined
by the originating bank and there is no guarantee that it is what GnuCash thinks
it should be. 

Some banks will use a signed amount column to represent debits and credits,
others will provide a debit column and a credit column with an unsigned amount.
Most will use a convention where the file is prepared from there point of view,
i.e. deposits you make into the account will be credits and withdrawals from the
bank account will be debits in the file (and on the statement) but there are
always the banks who try to be helpful.

The importer has to be able to handle these combinations and any reversal of the
sign convention so there is some arbitrarinesss to the assignment of the Deposit
and Withdrawal headers to the appropriate columns in the CSV file in the
importer setup.

My bank uses a single signed amount column in which positive amounts are credits
on the statement and negative amounts are debits on the statement. Because the
statement is written from the banks accounting perspective and not yours the
positive amounts become debits and the negative amounts credits in your accounts
in GnuCash so I can assign the Deposit header to the single amount column in the
CSV file and it imports correctly. If I am importing a Credit card statement,
assigning the "Deposit" header also seems to work as GnuCash realizes it is
importing to a liability and not an asset account. If your bank follows the same
convention and has two columns you would assign the "Deposit" header to the
Credit column in the file and the "Withdrawal" header to the Debit column in the
file.

The best bet is to truncate a file to a couple of transactions and experiment to
get the setup right and then use that to import the complete file. Then if it
imports incorrectly you only have 1-2 transactions to delete before try the
other options.

David Cousens

On Mon, 2022-06-13 at 05:00 +, Kevin T via gnucash-user wrote:
> It seems that when importing CSV files, to a CC account, if the 'credit'
> column, which when imported is called the 'deposit' field, has a negative
> value in it, it is imported as a 'debit' transaction.  I have to refer to the
> statement, to find which of these transactions are supposed to be credits. 
>  IE i can't trust the import.
> is there any way to work around this behavior.
> Kevin
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> 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
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.