[GNC] Data load from CSV files - duplicates

Greetings from Cairns Qld Australia, I have my new accounts hierarchy data saved in a new file in the SQLite format. I have read the concepts guide & help docs. I have searched with our favourite search engine around the issue of imports from CSV etc files, and matching, and how to sort out dup

Re: [GNC] Data load from CSV files - duplicates

There are a number of things that may be impacting your results. First, check Edit > Preferences > Online Banking to be sure that options under Generic Importer are still checked and the values listed are reasonable. Second, the entire chapter 16 of the Help manual has details that come into play

[GNC] Splash Screen and Tips flash on then disappear

I installed GnuCash on Windows 10 pro and when I start the program the splash screen comes up for less than ¼ second then disappears. The Tips window then shows up for about the same length of time and disappears. If I try to show the Tip of the Day from the help menu nothing happens. I have

Re: [GNC] Splash Screen and Tips flash on then disappear

Barry, What version of Gnucash ? Do you have or have had dual monitors installed ? Any chance it's opening the main window off the screen - if so check out https://www.lifewire.com/how-to-move-a-window-that-is-off-screen-4772840 ? Does ALT + Tab allow you to switch to or show Gnucash as a possib

Re: [GNC] Data load from CSV files - duplicates

...Fifth, I think Leo is using the term "match" to refer to the process of *assigning* the second split to an account. ISTR that there is a step in the process where the user can actually match imported transactions to existing ones, along with the option to use the existing description or repla

[GNC] Gnucash 4.8: doesn't read or store config

Hi, I've encountered the issue that after install GnuCash 4.8, it won't read or store my preferences, as described at: https://bugs.gnucash.org/show_bug.cgi?id=798330 But there is a little different, since I just do a fresh OS install, I'm sure I don't have any other GnuCash version or XDG_DATA_

Re: [GNC] Gnucash 4.8: doesn't read or store config

Brian, Whatever your problem is, it cannot be the same as in that bug report as it was the result of a subtle mistake made by the OP. I am on a smartphone and I can't figure out how to reread your post, so I can't make any further suggestions about your problem. On Mon, Nov 22, 2021, 8:54 AM Bri

[GNC] Accounts Payable payment entry is marked as an Invoice

I was entering annual property tax bills, and noticed for one from last year, that it has a notation on the Vendor Report of: "Please note some transactions were not processed 1. Transaction has type invoice but no owner or lot" Viewing the AP register shows the payment entry, but marked with a

Re: [GNC] Gnucash 4.8: doesn't read or store config

Brian What operating Sytem are you using and how are you installing it (flatpack msi , build from source etc)? David Cousens On Mon, 2021-11-22 at 22:52 +0800, BrianHsu wrote: > Hi, > > I've encountered the issue that after install GnuCash 4.8, it won't > read or store my preferences, as descr

Re: [GNC] Accounts Payable payment entry is marked as an Invoice

You must have opened the AR register, and clicked on the Transaction type "I" payment split. This stupidly changes it to "P". The official fix is to not click on the AP/AR register. On Tue, 23 Nov 2021, 5:45 am Adrien Monteleone, < adrien.montele...@lusfiber.net> wrote: > I was entering annual pr

Re: [GNC] Accounts Payable payment entry is marked as an Invoice

No, the way around, P changes to I. Same fix. On Tue, 23 Nov 2021 at 00:04, Christopher Lam wrote: > You must have opened the AR register, and clicked on the Transaction type > "I" payment split. This stupidly changes it to "P". > The official fix is to not click on the AP/AR register. > > On Tu

Re: [GNC] Gnucash 4.8: doesn't read or store config

David, He's using Gentoo eMerge. See https://bugs.gnucash.org/attachment.cgi?id=374278 for a lot more detail. Regards, John Ralls > On Nov 22, 2021, at 1:53 PM, davidcousen...@gmail.com wrote: > > Brian > What operating Sytem are you using

Re: [GNC] Accounts Payable payment entry is marked as an Invoice

Not quite certain I follow, but if you mean by how I processed the payment, I did so through the official "Process Payment" function. And if you mean I might be looking at AR instead of AP, not that either. The 'error' presented appears on the Vendor Report. Clicking it brought me to the AP re

Re: [GNC] Accounts Payable payment entry is marked as an Invoice

I'll add that I'm not totally dense, and it seems like you're offering a fix, but either some important details are missing, or, we are misunderstanding one another. Regards, Adrien On 11/22/21 6:04 PM, Christopher Lam wrote: You must have opened the AR register, and clicked on the Transactio

Re: [GNC] Accounts Payable payment entry is marked as an Invoice

Adrien, The "I" means "Invoice" (which internally can mean Customer Invoice, Vendor Bill, etc). It is in both AR and AP accounts, and it is labled "I" in there in either case. NORMALLY when you make a payment it gets a P. If you post and Invoice (or Bill/Credit Note/etc) it gets an I. When it has

Re: [GNC] Accounts Payable payment entry is marked as an Invoice

The report could also be amended to silently handle these "invoice" type transactions without an attached invoice, and handle them as payment type instead. But this is a bad band aid. On Tue, 23 Nov 2021, 9:29 am Derek Atkins, wrote: > Adrien, > The "I" means "Invoice" (which internally can mean

Re: [GNC] Accounts Payable payment entry is marked as an Invoice

I'm aware of the label meanings, but I didn't realize clicking them would change anything. Sounds like a bug. I don't recall ever clicking on the "I/P" at any time however, but I think I get the picture now. (I never edit from AP/AR, always some other account or through the Edit Payment window

Re: [GNC] Data load from CSV files - duplicates

Thanks to David T and David Carlson - to David T (and David Carlson) - yes - I believe you have hit what I am looking for - so, trying to say it again in a hopefully helpful way - being able to assign / match (the term in the CSV importer process) the second split of the transaction being loade

Re: [GNC] Accounts Payable payment entry is marked as an Invoice

I wouldn't advocate for such a change, and at least in this case, it really is/was a payment. (I made the invoice when I received the bill, then entered the payment when I physically paid it) And had that band-aid been in place, I would have been unlikely to discover this discrepancy. Regard

Re: [GNC] Gnucash 4.8: doesn't read or store config

Sorry, from what I could easily see on my smartphone it appeared that Brian's problem was unrelated to the problem described in https://bugs.gnucash.org/show_bug.cgi?id=798330 and that it shouldn't be hijacking that bug report. Now I see a different bug report number, so maybe it's ok. On Mon, N

Re: [GNC] Gnucash 4.8: doesn't read or store config

Hi, Yes, I'm using Gentoo and install it directly from official Gentoo repository. I have tried reproduce this issue with a clean installed openSUSE which also has GnuCash 4.8 in their official repository. But everything is fine within OpenSUSE, preference could be correctly read and write. It m

Re: [GNC] Accounts Payable payment entry is marked as an Invoice

Agree, however we could argue that the software allowed the data file to be damaged and should handle its own mess! On Tue, 23 Nov 2021, 9:57 am Adrien Monteleone, < adrien.montele...@lusfiber.net> wrote: > I wouldn't advocate for such a change, and at least in this case, it > really is/was a pay

Re: [GNC] Gnucash 4.8: doesn't read or store config

Hi, Sorry to bother everybody again. I'm pretty sure this is a Gentoo-package specific bug instead of GnuCash now. When I build and install GnuCash 4.8 from source code downloaded from GitHub directly, everything works fine and this problem does not exist anymore. This bug only exists when I inst

Re: [GNC] Accounts Payable payment entry is marked as an Invoice

Yep, no argument there! Not sure if this is more than one bug yet before filing. At least I see it as first, the issue of changing the type without warning, then a second one with immutability. (changing is bad enough, but getting stuck when landing on a magic letter/flag is much worse) And

Re: [GNC] Data load from CSV files - duplicates

Leo, the way the new CSV importer is supposed to work is to give the user a rather free form way to structure the CSV input data into GnuCash transaction candidates for import through the Generic Importer, and if successful, it should then be possible in the second account import for the Generic Im

Re: [GNC] Data load from CSV files - duplicates

Leo, In case it helps clarify things, I'll note that in the second import, you're not trying to assign the split to an account-- you're trying to tell the importer that the transaction already exists in the file, and you want to match up the new transaction with the existing old one. That's wh

Re: [GNC] Accounts Payable payment entry is marked as an Invoice

Seems to me a bad design decision to allow a user to have UI access to change things one way, but not the other. It is also bad user design to allow users to change things in an account that will always break when the user changes anything, something that's been true for as long as I've used gnu

Re: [GNC] Data load from CSV files - duplicates

Leo, You can always manually override GnuCash's matching in the Import Matcher window by checking the "C" ("R" in older GnuCash versions) column if Gnucash has selected the "A" column to import the transaction and you do know it matches a transaction you have imported to another account. This will

Re: [GNC] Data load from CSV files - duplicates

Thanks again to all, David T's response note below - " clarify things - not trying to assign the split to an account-- you're trying to tell the importer that the transaction already exists in the file, and you want to match up the new transaction with the existing old one. - with the terminol