Re: [GNC] importing csv and negative numbers

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

Re: [GNC] importing csv and negative numbers

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,

[GNC] importing csv and negative numbers

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

Re: [GNC] questions on 4.1

> 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

Re: [GNC] questions on 4.1

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

Re: [GNC] register description field width

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

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

Re: [GNC] questions on 4.1

From: gnucash-user mailto:gmail@gnucash.org> =gmail@gnucash.org > > on behalf of Top Cat mailto:t...@fractalcat.io> > > Sent:

Re: [GNC] questions on 4.1

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

Re: [GNC] Entry Point Not Found error

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, >

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

Re: [GNC] Entry Point Not Found error

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

Re: [GNC] Entry Point Not Found error

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

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

Re: [GNC] questions on 4.1

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

Re: [GNC] questions on 4.1

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

Re: [GNC] questions on 4.1

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,

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

Re: [GNC] How to reorganize the account tree

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

Re: [GNC] questions on 4.1

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,

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,

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

Re: [GNC] Startup issue - two windows

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

Re: [GNC] Entry Point Not Found error

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

Re: [GNC] How to reorganize the account tree

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

Re: [GNC] questions on 4.1

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

Re: [GNC] How to reorganize the account tree

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)

Re: [GNC] How to reorganize the account tree

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

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 Sent: Sunday, June 12, 2022 10:38 AM To:

Re: [GNC] questions on 4.1

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

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

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

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

Re: [GNC] How to reorganize the account tree

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.