Re: [GNC] Data storage location for GnuCash 4.12

2022-10-06 Thread fliegersonic.net
Hi Jim from The Other Jim Looks like I have to eat a bit of crow. I did read that earlier but somehow when looking at the 'save as' menu item I managed to interpret it as being a tool to 'save as' individual accounts, not the entire database. I'll give that a shot tomorrow morning and offer

[GNC] CoGS on Income Statement

2022-10-06 Thread Jared Squires
I'm trying to find a way to implement the Cost of Goods Sold in the Income Statement. Right now I have it as it's own Expense Top Level Account but it messes up my Income Statement for my actual Gross Profit. I tried to make CoGS as an "Income" but then when I enter bills from vendors, I can't

Re: [GNC] Orphan- and Imbalance- splits created on stock transaction when closing & reopening GnuCash data file

2022-10-06 Thread john
I can reproduce this with your sample file, and I discovered another facet: If one does a File>Save As, either to XML or SQlite3, the new file doesn't exhibit the behavior. I also found that if I remove the extra splits in the original file they don't come back. It's not a last-transaction

Re: [GNC] CSV transaction import settings

2022-10-06 Thread Geoff
Hi David On Windows 10**, there is a directory called: C:\Users\{YOUR_NAME}\AppData\Roaming\GnuCash\books\ Which contains a file for each set of books called: {BOOK_NAME}.gnucash.gcm In that file, there are, inter alia, sections for your saved CSV Import configurations that look like this:

Re: [GNC] CSV transaction import settings

2022-10-06 Thread fliegersonic.net
Ack - newbie screwup. Please disregard my last. Sigh. Ji On 7 Oct 2022 at 8:04, Christopher Lam wrote: > In release 4.12 - try Help > About > > On Fri, 7 Oct 2022 at 05:26, Adrien Monteleone < > adrien.montele...@lusfiber.net> wrote: > > > David, > > > > It looks like you want the chart

Re: [GNC] CSV transaction import settings

2022-10-06 Thread fliegersonic.net
Thank you, I did (I actually read the faq before calling for help). The data is not going to the location shown in 'About', it's going to the directory from which the installer was run. Very puzzling. Thre were a couple of entries in the registry which had a '/' (forward slash) in the path

Re: [GNC] Data storage location for GnuCash 4.12

2022-10-06 Thread Jim DeLaHunt
Hello, Jim, this is Jim. On 2022-10-06 16:36, fliegersonic.net wrote: I just updated from 3.8 to 4.12 In the process, the install indicated it would delete the existing GnuCash - which is ok as I had full backups. After the install, the data is being stored in the same directory into which

Re: [GNC] CSV transaction import settings

2022-10-06 Thread Christopher Lam
In release 4.12 - try Help > About On Fri, 7 Oct 2022 at 05:26, Adrien Monteleone < adrien.montele...@lusfiber.net> wrote: > David, > > It looks like you want the chart here: > > https://wiki.gnucash.org/wiki/Configuration_Diagrams_-_Linux > > 1. /home//.local/share/gnucash > 2.

[GNC] Data storage location for GnuCash 4.12

2022-10-06 Thread fliegersonic.net
I just updated from 3.8 to 4.12 In the process, the install indicated it would delete the existing GnuCash - which is ok as I had full backups. After the install, the data is being stored in the same directory into which I downloaded the installer, not to the directory indicated in the About

Re: [GNC] Gnucash invoicing and payment - questions on process

2022-10-06 Thread Adrien Monteleone
On 10/6/22 1:59 PM, Charles Vincent wrote: Hello Gnucash users list members, I come back on the issue of invoicing clients and payment by the clients or a third party. As background: For info, I am keeping the accounts for a small not for profit school in Cambodia. I have done the 70 invoices,

Re: [GNC] CSV transaction import settings

2022-10-06 Thread David Carlson
I didn't find that diagram. Thanks. Maybe what I want is under USER_CONFIG_HOME On Thu, Oct 6, 2022 at 4:27 PM Adrien Monteleone < adrien.montele...@lusfiber.net> wrote: > David, > > It looks like you want the chart here: > > https://wiki.gnucash.org/wiki/Configuration_Diagrams_-_Linux > > 1.

Re: [GNC] Import Map Editor

2022-10-06 Thread Liz Dodd
On Thu, 6 Oct 2022 14:28:21 -0700 Jim DeLaHunt wrote: > On 2022-10-06 05:58, Carl S. wrote: > > > I'm curious about the Import Map Editor and what it's for. > > Have you read the documentation about it, at >

Re: [GNC] Import Map Editor

2022-10-06 Thread Jim DeLaHunt
On 2022-10-06 05:58, Carl S. wrote: I'm curious about the Import Map Editor and what it's for. Have you read the documentation about it, at , yet? It does say I've got something like 300 invalid mapping

Re: [GNC] CSV transaction import settings

2022-10-06 Thread Adrien Monteleone
David, It looks like you want the chart here: https://wiki.gnucash.org/wiki/Configuration_Diagrams_-_Linux 1. /home//.local/share/gnucash 2. /home//.local/share/gtk-3.0 3. /home//.config/gnucash 4. /home//.config/gtk-3.0 One of those four directories should have the file you are looking for.

Re: [GNC] Chase OFXdirect connect - another one bites the dust

2022-10-06 Thread Kalpesh Patel
I wonder if OFX will die by thousand cuts. Slowly but surely large financial orgs are restricting direct retrieval of OFX formatted data or outright abandoning it. Web browser is a tool to just do that ... albeit not an efficient one for that specific purpose . I was utilizing very old

Re: [GNC] CSV transaction import settings

2022-10-06 Thread David Carlson
I went through that part of the FAQ and I got lost with locations and paths and relative paths but no hard filename to search for with my filemanager. If it is there I gave up in frustration before I found it. On Thu, Oct 6, 2022 at 1:08 PM Adrien Monteleone < adrien.montele...@lusfiber.net>

Re: [GNC] Chase OFXdirect connect - another one bites the dust

2022-10-06 Thread Gyle McCollam
I stopped using aqbanking because only a handful of my financial intuitions seemed to work with aqbanking. I also didn't like that my password information was stored in gnucash. I know you can elect not to store, but that renders it less useful. I have chosen to download from each of my

[GNC] Gnucash invoicing and payment - questions on process

2022-10-06 Thread Charles Vincent
Hello Gnucash users list members, I come back on the issue of invoicing clients and payment by the clients or a third party. As background: For info, I am keeping the accounts for a small not for profit school in Cambodia. I have done the 70 invoices, one for each child, using a standard

Re: [GNC] Troubleshooting and/or database repair

2022-10-06 Thread Adrien Monteleone
Glad to hear you don't need to reinstall the entire system! Now, to troubleshoot the OneDrive problem... I don't use it, so sorry if I can't be of further help, but I'm sure others here on the list do and might be able to assist. Search the list archives for 'OneDrive' and you might find

Re: [GNC] Troubleshooting and/or database repair

2022-10-06 Thread Jim Kolodziej
Okay based on your question I copied the database to a thumb drive (was on OneDrive). Problem disappeared. Thanks. On Thu, Oct 6, 2022 at 2:18 PM Adrien Monteleone < adrien.montele...@lusfiber.net> wrote: > If you try to add a transaction with a split to a non-existent account, > do you get

Re: [GNC] HELP!!! How to purge everything from my windows pc before attempting a new re-install

2022-10-06 Thread Murugan Muruganandam
gnucash stores the file location in a registry Computer\HKEY_CURRENT_USER\Software\GSettings\org\gnucash\GnuCash\history Saludos Cordiales Murugan From: gnucash-user on behalf of jmy...@gmail.com Sent: Thursday, October 6, 2022 11:31 AM To:

Re: [GNC] Saved report configurations

2022-10-06 Thread Adrien Monteleone
It looks like you were putting screenshots inline rather than as attachments. Those images did not come through, so we can't see what you are referring to. Your saved configuration should be under: Reports > Saved Report Configurations. You'll then get a pop-up with a list of your saved

Re: [GNC] Saved report configurations

2022-10-06 Thread Murugan Muruganandam
Not to be overt, did you check the start and end date in the report options. Saludos Cordiales Murugan From: gnucash-user on behalf of Mahon Finbar Sent: Thursday, October 6, 2022 3:03 PM To: Gnucash Users Subject: [GNC] Saved report configurations

Re: [GNC] Reconciling subaccounts

2022-10-06 Thread Adrien Monteleone
Thanks for the details. I'd say this is a bug, as the expected result would be to have the reconcile status of sub-accounts updated. You should file that on bugs.gnucash.org It *might* be designed that way however. I could be wrong, but I think the idea for this feature is to be used for

Re: [GNC] Troubleshooting and/or database repair

2022-10-06 Thread Adrien Monteleone
If you try to add a transaction with a split to a non-existent account, do you get the option to create that account? If so, and you choose to create it, does the new-account window show up? And one additional 'environment' question: Is this a local file, or stored on an

Re: [GNC] Import CSV transactions into GC

2022-10-06 Thread Carl S.
What got me to use Linux (Ubuntu and now Debian) was back in 2008 bankety-blank Intuit/Quacken (sic) began allowing only a two year direct connect from Quicken to download transactions before you had to purchase another license (or whatever it's called)  to get the same direct connect.

Re: [GNC] CSV transaction import settings

2022-10-06 Thread Adrien Monteleone
David, The Wiki FAQ has a section on file locations. I don't have the exact answer off-hand, but I'm sure one of those locations has what you are looking for. (allegedly, there are no other places used by GnuCash) Regards, Adrien On 10/6/22 8:49 AM, David Carlson wrote: Where are the

[GNC] Saved report configurations

2022-10-06 Thread Mahon Finbar
Hello, I have saved the report configurations for my annual P over the years, or I thought I had. It being the time I should make my annual tax return I went looking for the configuration for 2021 that I had started and found - but when I selected and clicked the 2021 one I get - Etc,

[GNC] Bulk check box A U+C C

2022-10-06 Thread Carl S.
In the screen Match Transactions screen is there a quick way to check off all of the boxes in column A or U+C or C all at once? Thanks, Carl S. OpenPGP_0x19B6B68457884FFB.asc Description: OpenPGP public key OpenPGP_signature Description: OpenPGP digital signature

Re: [GNC] Chase OFXdirect connect - another one bites the dust

2022-10-06 Thread Glenn Serre
Good morning, On Thu, Oct 6, 2022 at 9:53 AM Jean Laroche wrote: > > Any of you know whether something else is in the works to replace direct > connect? Manual downloading can be a pain when you have many accounts in > different institutions... I have the same issue. I had some success

Re: [GNC] Chase OFXdirect connect - another one bites the dust

2022-10-06 Thread Jean Laroche
Any of you know whether something else is in the works to replace direct connect? Manual downloading can be a pain when you have many accounts in different institutions... J. On 10/6/22 9:46 AM, David Reiser via gnucash-user wrote: As of today, aqbanking reports that

[GNC] Chase OFXdirect connect - another one bites the dust

2022-10-06 Thread David Reiser via gnucash-user
As of today, aqbanking reports that “ofx.chase.com ” is an unknown host. Banktivity reports that today is the start of Chase enforcing data access only through Open Banking APIs. OFX data format transaction downloads are still available from the Chase online web

Re: [GNC] Import CSV transactions into GC

2022-10-06 Thread R Losey
While the convenience of importing transactions is nice, I've been doing manual reconciliation and entry -- it's fast enough, providing that I haven't missed a transaction. On Thu, Oct 6, 2022 at 8:11 AM David Carlson wrote: > OK. I just checked and now they only offer PDF,

Re: [GNC] HELP!!! How to purge everything from my windows pc before attempting a new re-install

2022-10-06 Thread David Carlson
Before resorting to such invasive surgery, have you used Task Manager to verify that "Nothing happens" or is Gnucash doing something in the background? On Thu, Oct 6, 2022 at 9:32 AM wrote: > Somehow my gnucash is behaving very badly. a lot of the functionality from > the main menu does not

[GNC] HELP!!! How to purge everything from my windows pc before attempting a new re-install

2022-10-06 Thread jmybal
Somehow my gnucash is behaving very badly. a lot of the functionality from the main menu does not work. For example, if I select export the account tree - nothing happens. If I selected add an account or edit an account nothing happens. I tried to uninstall and reinstall everything I could

[GNC] CSV transaction import settings

2022-10-06 Thread David Carlson
Where are the settings stored? I thought I copied all the GnuCash stuff from one computer to another Ubuntu machine. I got my memorized reports but not the CSV Transactions import settings. -- David Carlson ___ gnucash-user mailing list

Re: [GNC] Import CSV transactions into GC

2022-10-06 Thread David Carlson
OK. I just checked and now they only offer PDF, Spreadsheet(whatever that means) and CSV download formats for my account. I guess they don't need our business. On Thu, Oct 6, 2022 at 7:51 AM Carl S. wrote: > Whooops.you're right QFX and not QDF > -- > *From:*

[GNC] Import Map Editor

2022-10-06 Thread Carl S.
I'm curious about the Import Map Editor and what it's for.  It does say I've got something like 300 invalid mapping and asks if I want to delete them. No idea what to do with itand certainly don't want to create a disaster. Thanks, Carl OpenPGP_0x19B6B68457884FFB.asc Description:

Re: [GNC] Import CSV transactions into GC

2022-10-06 Thread Carl S.
Whooops.you're right  QFX and not QDF *From:* David Carlson [mailto:david.carlson@gmail.com] *Subject:* [GNC] Import CSV transactions into GC *Date:* Thursday, October 6, 2022 at 12:17 AM *To:* Carl S. *Cc:*

Re: [GNC] Import CSV transactions into GC

2022-10-06 Thread David Cousens
Carl, The A checkbox (Add) indicates that the transaction is to be imported as it hasn't matched any existing transaction. If it was checked and that transaction was previously imported, then for some reason the Import Matcher did not automatically match the existing transaction. One possible