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

[Leo Vaccaneo]

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 terminology statement. "

is on the button of what I am hoping it is possible to do.

When I did my second import from CSV, on the matching screen, I chose the 
credit account, but I didn't really look for any other options.

I will do it again and look for some way to get to a transaction.
---

I 've checked on my bank site, and I do have the other export options
[cid:b41464d8-75f6-4406-bedc-1ab19a00d389]

SO, I will also try the imports again, from a QIF file

Thanks again

Leo Vaccaneo



From: D. 
Sent: Tuesday, 23 November 2021 1:37 PM
To: Leo Vaccaneo 
Cc: David Carlson ; D. via gnucash-user 

Subject: Re: 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 what I was getting at 
with the terminology statement.

I don't do much importing any more, but I thought there was a spot in the 
process where you were given the opportunity to match incoming transactions 
with ones that are already in the file. But maybe that isn't the case with csv?

David T.

From: Leo Vaccaneo
Sent: Mon Nov 22 20:46:16 EST 2021
To: "D." , David Carlson
Cc: Gnucash Users
Subject: Re: 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 loaded -

to an existing transaction in the 'destination' 'other side / end of the 
transaction' account -

instead of creating a replica of the trans being loaded - as the second split 
-in the 'destination' 'other side / end of the transaction' account
---

to David Carlson -

I will work my way through each of your suggestions, and give an update -

The GNU installer was downloaded yesterday.

The rest - I will need to work through.

Sounds like it will be well worth my while to try the QIF import if I can get 
that format export from my bank (have to check).

Thanks again to all

Leo Vaccaneo



From: D. 
Sent: Monday, 22 November 2021 9:47 PM
To: David Carlson 
Cc: Leo Vaccaneo ; Gnucash Users 

Subject: 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 replace it, 
which would eliminate that occurrence of a second transaction. Or perhaps I'm 
just getting senile.

David T.

From: David Carlson
Sent: Mon Nov 22 05:21:16 EST 2021
To: Leo Vaccaneo
Cc: "gnucash-user@gnucash.org"
Subject: 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.  Reread <
https://www.gnucash.org/docs/v4/C/gnucash-help/trans-import.html#trans-import-matcher







Third, there have been some issues with some parts of the CSV and Generic
importers that have been discussed here in the last several weeks.  The
exact release of your GnuCAsh program could make a difference.  Please tell
us which version and which OS you are using.

Fourth,  while the OFX/QFX and QIF importers have some issues as well, they
have the advantage of being more mature and their limitations are better
understood by users.  If your bank offers either of these types of exports,
try them.  The QIF seems to work well for initial imports, taken in fairly
small chunks, say a month's data at a time.

When you have distilled your results to more specific issues, users here
can give better advice to address your problems.

On Mon, Nov 22, 2021 at 3:20 AM Leo Vaccaneo  wrote:




 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 

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

[davidcousens49]

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 avoid having to
delete the duplicate transactions. I usually import my bank account data first
so when I import the credit card data I know any credit card payments should
already have been entered from my bank statement.

David Cousens

On Tue, 2021-11-23 at 01:46 +, Leo Vaccaneo wrote:
> 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 loaded -
> 
> to an existing transaction in the 'destination' 'other side / end of the
> transaction' account -
> 
> instead of creating a replica of the trans being loaded - as the second split
> -in the 'destination' 'other side / end of the transaction' account
> ---
> 
> to David Carlson -
> 
> I will work my way through each of your suggestions, and give an update -
> 
> The GNU installer was downloaded yesterday.
> 
> The rest - I will need to work through.
> 
> Sounds like it will be well worth my while to try the QIF import if I can get
> that format export from my bank (have to check).
> 
> Thanks again to all
> 
> Leo Vaccaneo
> 
> 
> 
> From: D. 
> Sent: Monday, 22 November 2021 9:47 PM
> To: David Carlson 
> Cc: Leo Vaccaneo ; Gnucash Users <
> gnucash-user@gnucash.org>
> Subject: 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 replace it,
> which would eliminate that occurrence of a second transaction. Or perhaps I'm
> just getting senile.
> 
> David T.
> 
> From: David Carlson
> Sent: Mon Nov 22 05:21:16 EST 2021
> To: Leo Vaccaneo
> Cc: "gnucash-user@gnucash.org"
> Subject: 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.  Reread <
> https://www.gnucash.org/docs/v4/C/gnucash-help/trans-import.html#trans-import-matcher
> 
> 
> Third, there have been some issues with some parts of the CSV and Generic
> importers that have been discussed here in the last several weeks.  The
> exact release of your GnuCAsh program could make a difference.  Please tell
> us which version and which OS you are using.
> 
> Fourth,  while the OFX/QFX and QIF importers have some issues as well, they
> have the advantage of being more mature and their limitations are better
> understood by users.  If your bank offers either of these types of exports,
> try them.  The QIF seems to work well for initial imports, taken in fairly
> small chunks, say a month's data at a time.
> 
> When you have distilled your results to more specific issues, users here
> can give better advice to address your problems.
> 
> On Mon, Nov 22, 2021 at 3:20 AM Leo Vaccaneo  wrote:
> 
>  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 duplicates
> 
>  I am somewhat aghast at the outcomes mentioned - deleting duplicates
>  and/or doing reversals.
> 
>  I am therefore going to be more verbose than the mail list items
>  questioners I found, to set out my frustration.
>  ---
> 
>  I created a new file to do this test. I completely deleted all
>  transactions from a previous file, the account balances all read zero, and
>  saved this as my new test file.
> 
>  In my accounts, I have an assets, savings acct.   I have a csv file of
>  savings account transactions export from my bank.
> 
>  In my accounts, I have a liabilities, credit card acct.   I have a csv
>  file of credit card transactions export from my bank.
> 
>  These are my first 2 imports.
> 
>  I imported the credit card transactions first, from CSV.
> 
>  In the matching stage, for payments into the credit card from the savings,
>  GnuCash did not offer any matches
>  I set the match to be the savings account.
>  Loaded, no errors, -
> 
>  And it created transactions 

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

[D. via gnucash-user]

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 gnucash. 

It would be better to make the account a placeholder account by default, and 
rewrite the business logic to push the changes into the account despite the 
placeholder setting, but I imagine that's a lot of work, and the people who 
know how to do the work will explain why my ideas are no good. 

David




 Original Message 
From: Adrien Monteleone 
Sent: Mon Nov 22 20:44:46 EST 2021
To: gnucash-u...@lists.gnucash.org
Subject: 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)

So I can reasonably edit this directly? (not officially supported, I 
understand)

I'm using the SQLite backend.

I'm guessing the db scheme in the wiki can point me to the I/P flag? Or 
is there some additional 'immutable' flag I need to change instead/also?

Perhaps I should file a bug on the report code taking the user to the 
AR/AP account directly since that might be troublesome, as well as on 
the immutability issue being triggered without warning?

Regards,
Adrien

On 11/22/21 7:28 PM, Derek Atkins wrote:
> 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 an I, the transaction is immutable from the register --
> because you are supposed to edit it by unposting the Invoice/Bill/etc and
> then re-posting it.
> 
> HOWEVER, the I/P/? column can be "clicked on" by a user, which will
> transition it to the "next" type, and, if you do this *manually* and it
> transitions to an I --- it becomes immutable... and there is no way in the
> UI to undo that.
> 
> So Chris was basically saying "don't do that".
> 
> MOST likely this is the cause of your issue.  The only fix is to go into
> the data file and remove the flag from the transaction under the covers.
> There is no UI way to fix it, because you're not supposed to go into AR/AP
> accounts.
> 
> -derek
> 
> On Mon, November 22, 2021 8:05 pm, Adrien Monteleone wrote:
>> 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 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 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 an "I"
 instead of a "P".

 Jumping to the Invoice shows it as PAID, and viewing lots shows both
 invoice and payment with a zero balance. (no balance really)

 Any ideas on what caused this and how to fix it?

 (using 4.7 on BigSur)
 --
 Regards,
 Adrien

___
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] Data load from CSV files - duplicates

[D. via gnucash-user]

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 what I was getting at 
with the terminology statement. 

I don't do much importing any more, but I thought there was a spot in the 
process where you were given the opportunity to match incoming transactions 
with ones that are already in the file. But maybe that isn't the case with csv?

David T.


 Original Message 
From: Leo Vaccaneo 
Sent: Mon Nov 22 20:46:16 EST 2021
To: "D." , David Carlson 
Cc: Gnucash Users 
Subject: Re: 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 loaded -

to an existing transaction in the 'destination' 'other side / end of the 
transaction' account -

instead of creating a replica of the trans being loaded - as the second split 
-in the 'destination' 'other side / end of the transaction' account
---

to David Carlson -

I will work my way through each of your suggestions, and give an update -

The GNU installer was downloaded yesterday.

The rest - I will need to work through.

Sounds like it will be well worth my while to try the QIF import if I can get 
that format export from my bank (have to check).

Thanks again to all

Leo Vaccaneo



From: D. 
Sent: Monday, 22 November 2021 9:47 PM
To: David Carlson 
Cc: Leo Vaccaneo ; Gnucash Users 

Subject: 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 replace it, 
which would eliminate that occurrence of a second transaction. Or perhaps I'm 
just getting senile.

David T.

From: David Carlson
Sent: Mon Nov 22 05:21:16 EST 2021
To: Leo Vaccaneo
Cc: "gnucash-user@gnucash.org"
Subject: 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.  Reread <
https://www.gnucash.org/docs/v4/C/gnucash-help/trans-import.html#trans-import-matcher


Third, there have been some issues with some parts of the CSV and Generic
importers that have been discussed here in the last several weeks.  The
exact release of your GnuCAsh program could make a difference.  Please tell
us which version and which OS you are using.

Fourth,  while the OFX/QFX and QIF importers have some issues as well, they
have the advantage of being more mature and their limitations are better
understood by users.  If your bank offers either of these types of exports,
try them.  The QIF seems to work well for initial imports, taken in fairly
small chunks, say a month's data at a time.

When you have distilled your results to more specific issues, users here
can give better advice to address your problems.

On Mon, Nov 22, 2021 at 3:20 AM Leo Vaccaneo  wrote:

 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 duplicates

 I am somewhat aghast at the outcomes mentioned - deleting duplicates
 and/or doing reversals.

 I am therefore going to be more verbose than the mail list items
 questioners I found, to set out my frustration.
 ---

 I created a new file to do this test. I completely deleted all
 transactions from a previous file, the account balances all read zero, and
 saved this as my new test file.

 In my accounts, I have an assets, savings acct.   I have a csv file of
 savings account transactions export from my bank.

 In my accounts, I have a liabilities, credit card acct.   I have a csv
 file of credit card transactions export from my bank.

 These are my first 2 imports.

 I imported the credit card transactions first, from CSV.

 In the matching stage, for payments into the credit card from the savings,
 GnuCash did not offer any matches
 I set the match to be the savings account.
 Loaded, no errors, -

 And it created transactions in the savings account (presumably the second
 split 

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

[David Carlson]

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 Importer to identify the correct existing transaction among the
possible matches in existing transactions and present them in the final
stage to be matched or not by the user.  When that does not happen, there
are many reasons to consider, and sometimes it can be difficult to
troubleshoot.  The other importers seem to be easier to troubleshoot when
they do not work, and it is less likely that there may be a bug in the
process itself as compared to a shortcoming in the data.  In too many cases
the data from the bank may not comply with the standards set by the
industry and it may need to be massaged with a text editor before it will
import.  I have two financial institutions that provide bad data files and
their data needs to be massaged before or after importing, even in the CSV
importer.  I was able to diagnose that with the OFX importer in my case,
but the QIF format is usually much easier to read.  I know David T. has
been using GnuCash for many years and he can sometimes see things that I
may overlook.

On Mon, Nov 22, 2021 at 7:46 PM Leo Vaccaneo  wrote:

> 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 loaded -
>
> to an existing transaction in the 'destination' 'other side / end of the
> transaction' account -
>
> instead of creating a replica of the trans being loaded - as the second
> split -in the 'destination' 'other side / end of the transaction' account
> ---
>
> to David Carlson -
>
> I will work my way through each of your suggestions, and give an update -
>
> The GNU installer was downloaded yesterday.
>
> The rest - I will need to work through.
>
> Sounds like it will be well worth my while to try the QIF import if I can
> get that format export from my bank (have to check).
>
> Thanks again to all
>
> Leo Vaccaneo
>
>
> --
> *From:* D. 
> *Sent:* Monday, 22 November 2021 9:47 PM
> *To:* David Carlson 
> *Cc:* Leo Vaccaneo ; Gnucash Users <
> gnucash-user@gnucash.org>
> *Subject:* 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
> replace it, which would eliminate that occurrence of a second transaction.
> Or perhaps I'm just getting senile.
>
> David T.
> --
> *From:* David Carlson
> *Sent:* Mon Nov 22 05:21:16 EST 2021
> *To:* Leo Vaccaneo
> *Cc:* "gnucash-user@gnucash.org"
> *Subject:* 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.  Reread <
> https://www.gnucash.org/docs/v4/C/gnucash-help/trans-import.html#trans-import-matcher
>
>
>
> Third, there have been some issues with some parts of the CSV and Generic
> importers that have been discussed here in the last several weeks.  The
> exact release of your GnuCAsh program could make a difference.  Please tell
> us which version and which OS you are using.
>
> Fourth,  while the OFX/QFX and QIF importers have some issues as well, they
> have the advantage of being more mature and their limitations are better
> understood by users.  If your bank offers either of these types of exports,
> try them.  The QIF seems to work well for initial imports, taken in fairly
> small chunks, say a month's data at a time.
>
> When you have distilled your results to more specific issues, users here
> can give better advice to address your problems.
>
> On Mon, Nov 22, 2021 at 3:20 AM Leo Vaccaneo  wrote:
>
>  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 duplicates
>
>  I am somewhat aghast at the outcomes mentioned - deleting duplicates
>  and/or doing reversals.
>
>  I am therefore going to be more verbose than the mail list items
>  questioners I found, to set out my frustration.
>  ---

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

[Adrien Monteleone]

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 even then, while I can't 100% recall if I ever made the faux pas of 
clicking on the letter, I might not have. (and wouldn't have been likely 
to do so) What might otherwise cause this would of course then be a 
bigger mystery. It probably isn't repeatable in such a case, at least 
not without lots of trials.


Since it is a known cause, I can't prove 100% otherwise as that was 
entered back in January, but...


Regards,
Adrien

On 11/22/21 8:25 PM, Christopher Lam wrote:

Agree, however we could argue that the software allowed the data file to be
damaged and should handle its own mess!


___
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] Gnucash 4.8: doesn't read or store config

[BrianHsu]

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 install GnuCash 4.8 through Gentoo's
official repository.

It should be a Gentoo package bug, not GnuCash's bug. I'll report it
to the package maintainer.

Thanks for your help.

David Carlson  於 2021年11月23日 週二 上午10:12寫道：
>
> 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, Nov 22, 2021 at 6:57 PM john  wrote:
>
> > David,
> >
> > He's using Gentoo eMerge. See
> > https://bugs.gnucash.org/attachment.cgi?id=374278 <
> > 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 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 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_DIRS
> > >> issue.
> > >>
> > >> And I also noticed some strange things, IIRC, after a fresh GnuCash is
> > >> installed and launched for first time, it should have the following
> > >> behavior:
> > >>
> > >> 1. Display a splash screen
> > >> 2. Show a dialog that contains tips
> > >> 3. When create a new file, it should have a account setting wizard
> > popped up.
> > >>
> > >> None of above happens when I launch my fresh installed GnuCash 4.8,
> > >> which is really strange.
> > >>
> > >> Also, it appears even if I manually ticked those checkbox in
> > >> Preference dialog, it just won't save and will not display splash /
> > >> tips dialog anyway.
> > >>
> > >> Here is my screen recording to demonstrate this problem:
> > >> https://www.youtube.com/watch?v=TZtVVvxxsME
> > >>
> > >> I've also checked settings mentioned at the bug ticket, but with no
> > >> luck. Everything seems correct on my system, but it just won't save my
> > >> preference.
> > >>
> > >> I've attached a detail reproduce / investigation steps on the ticket,
> > >> hope someone might figure out what happened and help me resolved this
> > >> issue.
> > >>
> > >
> > > ___
> > > 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.



-- 
Best regards,

許洛豪（Brian Hsu）
___
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] Accounts Payable payment entry is marked as an Invoice

[Christopher Lam]

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 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.
>
> Regards,
> Adrien
>
> On 11/22/21 7:37 PM, Christopher Lam wrote:
> > 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.
>
> ___
> 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] Gnucash 4.8: doesn't read or store config

[BrianHsu]

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 must be a Gentoo-specific issue, I'll report it to Gentoo's package
maintainers first.

Thanks for all of your help.


john  於 2021年11月23日 週二 上午8:57寫道：

>
> 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 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 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_DIRS
> >> issue.
> >>
> >> And I also noticed some strange things, IIRC, after a fresh GnuCash is
> >> installed and launched for first time, it should have the following
> >> behavior:
> >>
> >> 1. Display a splash screen
> >> 2. Show a dialog that contains tips
> >> 3. When create a new file, it should have a account setting wizard popped 
> >> up.
> >>
> >> None of above happens when I launch my fresh installed GnuCash 4.8,
> >> which is really strange.
> >>
> >> Also, it appears even if I manually ticked those checkbox in
> >> Preference dialog, it just won't save and will not display splash /
> >> tips dialog anyway.
> >>
> >> Here is my screen recording to demonstrate this problem:
> >> https://www.youtube.com/watch?v=TZtVVvxxsME
> >>
> >> I've also checked settings mentioned at the bug ticket, but with no
> >> luck. Everything seems correct on my system, but it just won't save my
> >> preference.
> >>
> >> I've attached a detail reproduce / investigation steps on the ticket,
> >> hope someone might figure out what happened and help me resolved this
> >> issue.
> >>
> >
> > ___
> > 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.



--
Best regards,

許洛豪（Brian Hsu）
___
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] Gnucash 4.8: doesn't read or store config

[David Carlson]

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, Nov 22, 2021 at 6:57 PM john  wrote:

> David,
>
> He's using Gentoo eMerge. See
> https://bugs.gnucash.org/attachment.cgi?id=374278 <
> 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 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 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_DIRS
> >> issue.
> >>
> >> And I also noticed some strange things, IIRC, after a fresh GnuCash is
> >> installed and launched for first time, it should have the following
> >> behavior:
> >>
> >> 1. Display a splash screen
> >> 2. Show a dialog that contains tips
> >> 3. When create a new file, it should have a account setting wizard
> popped up.
> >>
> >> None of above happens when I launch my fresh installed GnuCash 4.8,
> >> which is really strange.
> >>
> >> Also, it appears even if I manually ticked those checkbox in
> >> Preference dialog, it just won't save and will not display splash /
> >> tips dialog anyway.
> >>
> >> Here is my screen recording to demonstrate this problem:
> >> https://www.youtube.com/watch?v=TZtVVvxxsME
> >>
> >> I've also checked settings mentioned at the bug ticket, but with no
> >> luck. Everything seems correct on my system, but it just won't save my
> >> preference.
> >>
> >> I've attached a detail reproduce / investigation steps on the ticket,
> >> hope someone might figure out what happened and help me resolved this
> >> issue.
> >>
> >
> > ___
> > 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] Accounts Payable payment entry is marked as an Invoice

[Adrien Monteleone]

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.


Regards,
Adrien

On 11/22/21 7:37 PM, Christopher Lam wrote:

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.


___
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] Data load from CSV files - duplicates

[Leo Vaccaneo]

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

to an existing transaction in the 'destination' 'other side / end of the 
transaction' account -

instead of creating a replica of the trans being loaded - as the second split 
-in the 'destination' 'other side / end of the transaction' account
---

to David Carlson -

I will work my way through each of your suggestions, and give an update -

The GNU installer was downloaded yesterday.

The rest - I will need to work through.

Sounds like it will be well worth my while to try the QIF import if I can get 
that format export from my bank (have to check).

Thanks again to all

Leo Vaccaneo



From: D. 
Sent: Monday, 22 November 2021 9:47 PM
To: David Carlson 
Cc: Leo Vaccaneo ; Gnucash Users 

Subject: 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 replace it, 
which would eliminate that occurrence of a second transaction. Or perhaps I'm 
just getting senile.

David T.

From: David Carlson
Sent: Mon Nov 22 05:21:16 EST 2021
To: Leo Vaccaneo
Cc: "gnucash-user@gnucash.org"
Subject: 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.  Reread <
https://www.gnucash.org/docs/v4/C/gnucash-help/trans-import.html#trans-import-matcher


Third, there have been some issues with some parts of the CSV and Generic
importers that have been discussed here in the last several weeks.  The
exact release of your GnuCAsh program could make a difference.  Please tell
us which version and which OS you are using.

Fourth,  while the OFX/QFX and QIF importers have some issues as well, they
have the advantage of being more mature and their limitations are better
understood by users.  If your bank offers either of these types of exports,
try them.  The QIF seems to work well for initial imports, taken in fairly
small chunks, say a month's data at a time.

When you have distilled your results to more specific issues, users here
can give better advice to address your problems.

On Mon, Nov 22, 2021 at 3:20 AM Leo Vaccaneo  wrote:

 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 duplicates

 I am somewhat aghast at the outcomes mentioned - deleting duplicates
 and/or doing reversals.

 I am therefore going to be more verbose than the mail list items
 questioners I found, to set out my frustration.
 ---

 I created a new file to do this test. I completely deleted all
 transactions from a previous file, the account balances all read zero, and
 saved this as my new test file.

 In my accounts, I have an assets, savings acct.   I have a csv file of
 savings account transactions export from my bank.

 In my accounts, I have a liabilities, credit card acct.   I have a csv
 file of credit card transactions export from my bank.

 These are my first 2 imports.

 I imported the credit card transactions first, from CSV.

 In the matching stage, for payments into the credit card from the savings,
 GnuCash did not offer any matches
 I set the match to be the savings account.
 Loaded, no errors, -

 And it created transactions in the savings account (presumably the second
 split of the credit card account transactions)
 ---

 I then imported the savings account transactions from CSV.

 In the matching stage, for payments from the savings into the credit card,
 GnuCash did not offer any matches
 I set the match to be the credit card account.
 Loaded, no errors, -

 And it created transactions in the credit card account (presumably the
 second split of the savings account transactions)

 NOW, - I have 2 versions of each of these transactions, - which are in
 fact the same transaction, - in each of the savings, and, the credit card
 accounts!! completely fouling up balances.
 ---

 Have I done something wrong?

 I don't want to be manually trying to delete some transaction splits, or
 trying to delete or reverse some transactions -
   .  it would be just another 

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

[Adrien Monteleone]

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)


So I can reasonably edit this directly? (not officially supported, I 
understand)


I'm using the SQLite backend.

I'm guessing the db scheme in the wiki can point me to the I/P flag? Or 
is there some additional 'immutable' flag I need to change instead/also?


Perhaps I should file a bug on the report code taking the user to the 
AR/AP account directly since that might be troublesome, as well as on 
the immutability issue being triggered without warning?


Regards,
Adrien

On 11/22/21 7:28 PM, Derek Atkins wrote:

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 an I, the transaction is immutable from the register --
because you are supposed to edit it by unposting the Invoice/Bill/etc and
then re-posting it.

HOWEVER, the I/P/? column can be "clicked on" by a user, which will
transition it to the "next" type, and, if you do this *manually* and it
transitions to an I --- it becomes immutable... and there is no way in the
UI to undo that.

So Chris was basically saying "don't do that".

MOST likely this is the cause of your issue.  The only fix is to go into
the data file and remove the flag from the transaction under the covers.
There is no UI way to fix it, because you're not supposed to go into AR/AP
accounts.

-derek

On Mon, November 22, 2021 8:05 pm, Adrien Monteleone wrote:

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 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 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 an "I"
instead of a "P".

Jumping to the Invoice shows it as PAID, and viewing lots shows both
invoice and payment with a zero balance. (no balance really)

Any ideas on what caused this and how to fix it?

(using 4.7 on BigSur)
--
Regards,
Adrien


___
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] Accounts Payable payment entry is marked as an Invoice

[Christopher Lam]

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 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 an I, the transaction is immutable from the register --
> because you are supposed to edit it by unposting the Invoice/Bill/etc and
> then re-posting it.
>
> HOWEVER, the I/P/? column can be "clicked on" by a user, which will
> transition it to the "next" type, and, if you do this *manually* and it
> transitions to an I --- it becomes immutable... and there is no way in the
> UI to undo that.
>
> So Chris was basically saying "don't do that".
>
> MOST likely this is the cause of your issue.  The only fix is to go into
> the data file and remove the flag from the transaction under the covers.
> There is no UI way to fix it, because you're not supposed to go into AR/AP
> accounts.
>
> -derek
>
> On Mon, November 22, 2021 8:05 pm, Adrien Monteleone wrote:
> > 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 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 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 an "I"
> >>> instead of a "P".
> >>>
> >>> Jumping to the Invoice shows it as PAID, and viewing lots shows both
> >>> invoice and payment with a zero balance. (no balance really)
> >>>
> >>> Any ideas on what caused this and how to fix it?
> >>>
> >>> (using 4.7 on BigSur)
> >>> --
> >>> Regards,
> >>> Adrien
> >
> > ___
> > 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.
>
___
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] Accounts Payable payment entry is marked as an Invoice

[Derek Atkins]

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 an I, the transaction is immutable from the register --
because you are supposed to edit it by unposting the Invoice/Bill/etc and
then re-posting it.

HOWEVER, the I/P/? column can be "clicked on" by a user, which will
transition it to the "next" type, and, if you do this *manually* and it
transitions to an I --- it becomes immutable... and there is no way in the
UI to undo that.

So Chris was basically saying "don't do that".

MOST likely this is the cause of your issue.  The only fix is to go into
the data file and remove the flag from the transaction under the covers. 
There is no UI way to fix it, because you're not supposed to go into AR/AP
accounts.

-derek

On Mon, November 22, 2021 8:05 pm, Adrien Monteleone wrote:
> 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 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 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 an "I"
>>> instead of a "P".
>>>
>>> Jumping to the Invoice shows it as PAID, and viewing lots shows both
>>> invoice and payment with a zero balance. (no balance really)
>>>
>>> Any ideas on what caused this and how to fix it?
>>>
>>> (using 4.7 on BigSur)
>>> --
>>> Regards,
>>> Adrien
>
> ___
> 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] Accounts Payable payment entry is marked as an Invoice

[Adrien Monteleone]

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 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 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 an "I"
instead of a "P".

Jumping to the Invoice shows it as PAID, and viewing lots shows both
invoice and payment with a zero balance. (no balance really)

Any ideas on what caused this and how to fix it?

(using 4.7 on BigSur)
--
Regards,
Adrien


___
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] Accounts Payable payment entry is marked as an Invoice

[Adrien Monteleone]

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 register. Which is where I first saw the "I" and upon 
further investigation found the discrepancies with everything else 
showing a proper payment.


Regards,
Adrien

On 11/22/21 6:05 PM, Christopher Lam wrote:

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 Tue, 23 Nov 2021, 5:45 am Adrien Monteleone, <
adrien.montele...@lusfiber.net> wrote:


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 an "I"
instead of a "P".

Jumping to the Invoice shows it as PAID, and viewing lots shows both
invoice and payment with a zero balance. (no balance really)

Any ideas on what caused this and how to fix it?

(using 4.7 on BigSur)
--
Regards,
Adrien


___
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] Gnucash 4.8: doesn't read or store config

[john]

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 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 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_DIRS
>> issue.
>> 
>> And I also noticed some strange things, IIRC, after a fresh GnuCash is
>> installed and launched for first time, it should have the following
>> behavior:
>> 
>> 1. Display a splash screen
>> 2. Show a dialog that contains tips
>> 3. When create a new file, it should have a account setting wizard popped up.
>> 
>> None of above happens when I launch my fresh installed GnuCash 4.8,
>> which is really strange.
>> 
>> Also, it appears even if I manually ticked those checkbox in
>> Preference dialog, it just won't save and will not display splash /
>> tips dialog anyway.
>> 
>> Here is my screen recording to demonstrate this problem:
>> https://www.youtube.com/watch?v=TZtVVvxxsME
>> 
>> I've also checked settings mentioned at the bug ticket, but with no
>> luck. Everything seems correct on my system, but it just won't save my
>> preference.
>> 
>> I've attached a detail reproduce / investigation steps on the ticket,
>> hope someone might figure out what happened and help me resolved this
>> issue.
>> 
> 
> ___
> 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] Accounts Payable payment entry is marked as an Invoice

[Christopher Lam]

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 Tue, 23 Nov 2021, 5:45 am Adrien Monteleone, <
> adrien.montele...@lusfiber.net> wrote:
>
>> 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 an "I"
>> instead of a "P".
>>
>> Jumping to the Invoice shows it as PAID, and viewing lots shows both
>> invoice and payment with a zero balance. (no balance really)
>>
>> Any ideas on what caused this and how to fix it?
>>
>> (using 4.7 on BigSur)
>> --
>> Regards,
>> Adrien
>>
>> ___
>> 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] Accounts Payable payment entry is marked as an Invoice

[Christopher Lam]

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 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 an "I"
> instead of a "P".
>
> Jumping to the Invoice shows it as PAID, and viewing lots shows both
> invoice and payment with a zero balance. (no balance really)
>
> Any ideas on what caused this and how to fix it?
>
> (using 4.7 on BigSur)
> --
> Regards,
> Adrien
>
> ___
> 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] Gnucash 4.8: doesn't read or store config

[davidcousens49]

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 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_DIRS
> issue.
> 
> And I also noticed some strange things, IIRC, after a fresh GnuCash is
> installed and launched for first time, it should have the following
> behavior:
> 
> 1. Display a splash screen
> 2. Show a dialog that contains tips
> 3. When create a new file, it should have a account setting wizard popped up.
> 
> None of above happens when I launch my fresh installed GnuCash 4.8,
> which is really strange.
> 
> Also, it appears even if I manually ticked those checkbox in
> Preference dialog, it just won't save and will not display splash /
> tips dialog anyway.
> 
> Here is my screen recording to demonstrate this problem:
> https://www.youtube.com/watch?v=TZtVVvxxsME
> 
> I've also checked settings mentioned at the bug ticket, but with no
> luck. Everything seems correct on my system, but it just won't save my
> preference.
> 
> I've attached a detail reproduce / investigation steps on the ticket,
> hope someone might figure out what happened and help me resolved this
> issue.
> 

___
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] Accounts Payable payment entry is marked as an Invoice

[Adrien Monteleone]

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 an "I" 
instead of a "P".


Jumping to the Invoice shows it as PAID, and viewing lots shows both 
invoice and payment with a zero balance. (no balance really)


Any ideas on what caused this and how to fix it?

(using 4.7 on BigSur)
--
Regards,
Adrien

___
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] Gnucash 4.8: doesn't read or store config

[David Carlson]

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 BrianHsu  wrote:

> 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_DIRS
> issue.
>
> And I also noticed some strange things, IIRC, after a fresh GnuCash is
> installed and launched for first time, it should have the following
> behavior:
>
> 1. Display a splash screen
> 2. Show a dialog that contains tips
> 3. When create a new file, it should have a account setting wizard popped
> up.
>
> None of above happens when I launch my fresh installed GnuCash 4.8,
> which is really strange.
>
> Also, it appears even if I manually ticked those checkbox in
> Preference dialog, it just won't save and will not display splash /
> tips dialog anyway.
>
> Here is my screen recording to demonstrate this problem:
> https://www.youtube.com/watch?v=TZtVVvxxsME
>
> I've also checked settings mentioned at the bug ticket, but with no
> luck. Everything seems correct on my system, but it just won't save my
> preference.
>
> I've attached a detail reproduce / investigation steps on the ticket,
> hope someone might figure out what happened and help me resolved this
> issue.
>
> --
> Best regards,
>
> 許洛豪（Brian Hsu）
> ___
> 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] Gnucash 4.8: doesn't read or store config

[BrianHsu]

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_DIRS
issue.

And I also noticed some strange things, IIRC, after a fresh GnuCash is
installed and launched for first time, it should have the following
behavior:

1. Display a splash screen
2. Show a dialog that contains tips
3. When create a new file, it should have a account setting wizard popped up.

None of above happens when I launch my fresh installed GnuCash 4.8,
which is really strange.

Also, it appears even if I manually ticked those checkbox in
Preference dialog, it just won't save and will not display splash /
tips dialog anyway.

Here is my screen recording to demonstrate this problem:
https://www.youtube.com/watch?v=TZtVVvxxsME

I've also checked settings mentioned at the bug ticket, but with no
luck. Everything seems correct on my system, but it just won't save my
preference.

I've attached a detail reproduce / investigation steps on the ticket,
hope someone might figure out what happened and help me resolved this
issue.

-- 
Best regards,

許洛豪（Brian Hsu）
___
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] Data load from CSV files - duplicates

[D. via gnucash-user]

...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 replace it, 
which would eliminate that occurrence of a second transaction. Or perhaps I'm 
just getting senile. 

David T.


 Original Message 
From: David Carlson 
Sent: Mon Nov 22 05:21:16 EST 2021
To: Leo Vaccaneo 
Cc: "gnucash-user@gnucash.org" 
Subject: 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.  Reread <
https://www.gnucash.org/docs/v4/C/gnucash-help/trans-import.html#trans-import-matcher
>

Third, there have been some issues with some parts of the CSV and Generic
importers that have been discussed here in the last several weeks.  The
exact release of your GnuCAsh program could make a difference.  Please tell
us which version and which OS you are using.

Fourth,  while the OFX/QFX and QIF importers have some issues as well, they
have the advantage of being more mature and their limitations are better
understood by users.  If your bank offers either of these types of exports,
try them.  The QIF seems to work well for initial imports, taken in fairly
small chunks, say a month's data at a time.

When you have distilled your results to more specific issues, users here
can give better advice to address your problems.

On Mon, Nov 22, 2021 at 3:20 AM Leo Vaccaneo  wrote:

> 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 duplicates
>
> I am somewhat aghast at the outcomes mentioned - deleting duplicates
> and/or doing reversals.
>
> I am therefore going to be more verbose than the mail list items
> questioners I found, to set out my frustration.
> ---
>
> I created a new file to do this test. I completely deleted all
> transactions from a previous file, the account balances all read zero, and
> saved this as my new test file.
>
> In my accounts, I have an assets, savings acct.   I have a csv file of
> savings account transactions export from my bank.
>
> In my accounts, I have a liabilities, credit card acct.   I have a csv
> file of credit card transactions export from my bank.
>
> These are my first 2 imports.
>
> I imported the credit card transactions first, from CSV.
>
> In the matching stage, for payments into the credit card from the savings,
> GnuCash did not offer any matches
> I set the match to be the savings account.
> Loaded, no errors, -
>
> And it created transactions in the savings account (presumably the second
> split of the credit card account transactions)
> ---
>
> I then imported the savings account transactions from CSV.
>
> In the matching stage, for payments from the savings into the credit card,
> GnuCash did not offer any matches
> I set the match to be the credit card account.
> Loaded, no errors, -
>
> And it created transactions in the credit card account (presumably the
> second split of the savings account transactions)
>
> NOW, - I have 2 versions of each of these transactions, - which are in
> fact the same transaction, - in each of the savings, and, the credit card
> accounts!! completely fouling up balances.
> ---
>
> Have I done something wrong?
>
> I don't want to be manually trying to delete some transaction splits, or
> trying to delete or reverse some transactions -
>   .  it would be just another manual tedious process
>   .  I would likely do it wrong and break the transaction(s) completely.
> ---
>
> If I don't provide manual matching, the transactions all end up listed in
> the Imbalance acct.
> ---
>
> If I were to import the credit card transactions - without providing
> manual matching -
>
>  When I then import the savings account transactions -
>
> How to I tell it that -
> This transaction - x - being loaded into this savings account should be
> matched to that existing transaction - y - in that credit card account
> AND - remove that transaction - y - from the Imbalance acct
>
> I find it quite frustrating that it appears that I have to match during
> both imports, and then do more manual jiggery pokery to sort out the
> duplicates!
>
> There has to be a better way.
> ---
>
> I have not tried it - BUT -
> Could I import the credit card transactions, with no matching - second
> splits will be in Imbalance -
> THEN, when I do savings import, - is it possible to do the matching to the
> credit 

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

[David H]

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 possible Window
to switch to ?  Does Task Manager show it as running ?

Cheers David H.

On Mon, 22 Nov 2021 at 20:46, Barry Hansen  wrote:

> 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 upgraded to Windows 11 and the same thing happens.  I have also
> uninstalled the program and re-installed it with no change.  Has anybody
> seen this and is there some kind of fix?
> Thanks for any help
>
> Sent from Mail for Windows
>
>
>
> --
> This email has been checked for viruses by Avast antivirus software.
> https://www.avast.com/antivirus
> ___
> 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] Splash Screen and Tips flash on then disappear

[Barry Hansen]

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 upgraded to 
Windows 11 and the same thing happens.  I have also uninstalled the program and 
re-installed it with no change.  Has anybody seen this and is there some kind 
of fix?
Thanks for any help 

Sent from Mail for Windows



-- 
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus
___
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] Data load from CSV files - duplicates

[David Carlson]

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.  Reread <
https://www.gnucash.org/docs/v4/C/gnucash-help/trans-import.html#trans-import-matcher
>

Third, there have been some issues with some parts of the CSV and Generic
importers that have been discussed here in the last several weeks.  The
exact release of your GnuCAsh program could make a difference.  Please tell
us which version and which OS you are using.

Fourth,  while the OFX/QFX and QIF importers have some issues as well, they
have the advantage of being more mature and their limitations are better
understood by users.  If your bank offers either of these types of exports,
try them.  The QIF seems to work well for initial imports, taken in fairly
small chunks, say a month's data at a time.

When you have distilled your results to more specific issues, users here
can give better advice to address your problems.

On Mon, Nov 22, 2021 at 3:20 AM Leo Vaccaneo  wrote:

> 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 duplicates
>
> I am somewhat aghast at the outcomes mentioned - deleting duplicates
> and/or doing reversals.
>
> I am therefore going to be more verbose than the mail list items
> questioners I found, to set out my frustration.
> ---
>
> I created a new file to do this test. I completely deleted all
> transactions from a previous file, the account balances all read zero, and
> saved this as my new test file.
>
> In my accounts, I have an assets, savings acct.   I have a csv file of
> savings account transactions export from my bank.
>
> In my accounts, I have a liabilities, credit card acct.   I have a csv
> file of credit card transactions export from my bank.
>
> These are my first 2 imports.
>
> I imported the credit card transactions first, from CSV.
>
> In the matching stage, for payments into the credit card from the savings,
> GnuCash did not offer any matches
> I set the match to be the savings account.
> Loaded, no errors, -
>
> And it created transactions in the savings account (presumably the second
> split of the credit card account transactions)
> ---
>
> I then imported the savings account transactions from CSV.
>
> In the matching stage, for payments from the savings into the credit card,
> GnuCash did not offer any matches
> I set the match to be the credit card account.
> Loaded, no errors, -
>
> And it created transactions in the credit card account (presumably the
> second split of the savings account transactions)
>
> NOW, - I have 2 versions of each of these transactions, - which are in
> fact the same transaction, - in each of the savings, and, the credit card
> accounts!! completely fouling up balances.
> ---
>
> Have I done something wrong?
>
> I don't want to be manually trying to delete some transaction splits, or
> trying to delete or reverse some transactions -
>   .  it would be just another manual tedious process
>   .  I would likely do it wrong and break the transaction(s) completely.
> ---
>
> If I don't provide manual matching, the transactions all end up listed in
> the Imbalance acct.
> ---
>
> If I were to import the credit card transactions - without providing
> manual matching -
>
>  When I then import the savings account transactions -
>
> How to I tell it that -
> This transaction - x - being loaded into this savings account should be
> matched to that existing transaction - y - in that credit card account
> AND - remove that transaction - y - from the Imbalance acct
>
> I find it quite frustrating that it appears that I have to match during
> both imports, and then do more manual jiggery pokery to sort out the
> duplicates!
>
> There has to be a better way.
> ---
>
> I have not tried it - BUT -
> Could I import the credit card transactions, with no matching - second
> splits will be in Imbalance -
> THEN, when I do savings import, - is it possible to do the matching to the
> credit card second split in the imbalance account - and end up without
> duplicates, and the transaction cleared from Imbalance??
>
> Hoping for enlightenment
>
> Leo Vaccaneo
>
> ___
> 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 

[GNC] Data load from CSV files - duplicates

[Leo Vaccaneo]

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 duplicates

I am somewhat aghast at the outcomes mentioned - deleting duplicates and/or 
doing reversals.

I am therefore going to be more verbose than the mail list items questioners I 
found, to set out my frustration.
---

I created a new file to do this test. I completely deleted all transactions 
from a previous file, the account balances all read zero, and saved this as my 
new test file.

In my accounts, I have an assets, savings acct.   I have a csv file of savings 
account transactions export from my bank.

In my accounts, I have a liabilities, credit card acct.   I have a csv file of 
credit card transactions export from my bank.

These are my first 2 imports.

I imported the credit card transactions first, from CSV.

In the matching stage, for payments into the credit card from the savings,
GnuCash did not offer any matches
I set the match to be the savings account.
Loaded, no errors, -

And it created transactions in the savings account (presumably the second split 
of the credit card account transactions)
---

I then imported the savings account transactions from CSV.

In the matching stage, for payments from the savings into the credit card,
GnuCash did not offer any matches
I set the match to be the credit card account.
Loaded, no errors, -

And it created transactions in the credit card account (presumably the second 
split of the savings account transactions)

NOW, - I have 2 versions of each of these transactions, - which are in fact the 
same transaction, - in each of the savings, and, the credit card accounts!! 
completely fouling up balances.
---

Have I done something wrong?

I don't want to be manually trying to delete some transaction splits, or trying 
to delete or reverse some transactions -
  .  it would be just another manual tedious process
  .  I would likely do it wrong and break the transaction(s) completely.
---

If I don't provide manual matching, the transactions all end up listed in the 
Imbalance acct.
---

If I were to import the credit card transactions - without providing manual 
matching -

 When I then import the savings account transactions -

How to I tell it that -
This transaction - x - being loaded into this savings account should be matched 
to that existing transaction - y - in that credit card account
AND - remove that transaction - y - from the Imbalance acct

I find it quite frustrating that it appears that I have to match during both 
imports, and then do more manual jiggery pokery to sort out the duplicates!

There has to be a better way.
---

I have not tried it - BUT -
Could I import the credit card transactions, with no matching - second splits 
will be in Imbalance -
THEN, when I do savings import, - is it possible to do the matching to the 
credit card second split in the imbalance account - and end up without 
duplicates, and the transaction cleared from Imbalance??

Hoping for enlightenment

Leo Vaccaneo

___
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.