Re: [GNC] Transaction Date issues during import OFX file (TD Bank)

[David Carlson]

That -5 EST relates local time to universal time and may come into play if
the local computer clock is not set to the local time zone.  Usually it
clarifies the source time reference of the data.

On Tue, Jan 11, 2022, 2:07 PM Jean Laroche  wrote:

> > I wonder what happens if the "[-5:EST]" gets removed.  The dates seem to
> have 0200 as their time; subtracting 5 hours from that would return -3
> o'clock (and presumably shift the date back one).
>
> You could do a test where you modify your OFX file to remove [-5:EST]
> from all transactions (you can do that easily in an editor), then try to
> import it and see whether this fixes the dates.
>
> After that the question is whether that [-5:EST] is valid or not.
> Jean
>
>
> On 1/11/22 11:59 AM, D. via gnucash-user wrote:
> > But EFT transactions (which are the bulk of my txns these days)
> shouldn't get shifted around much at all. I'd be miffed if every EFT entry
> were a day off.
> >
> >
> >  Original Message 
> > From: Gyle McCollam 
> > Sent: Tue Jan 11 13:33:51 EST 2022
> > To: "D." 
> > Cc: "gnucash-user@gnucash.org" 
> > Subject: Re: Re: [GNC] Transaction Date issues during import OFX file
> (TD Bank)
> >
> > I find my dates usualy do not agree with the bank dates.  I record
> credit card bills when I pay them (electronically) and they are recorded by
> the payee on the same date.  However, they usually hit my bank the next
> banking day.  This isn't and shouldn't be a problem or concern.  Actual
> physical checks take even longer to show up at the bank.  This is all
> normal.
> >
> >
> > Thank You,
> > Gyle McCollam
> >
> > Gyle McCollam
> >
> > 609.680.2326 Mobile
> >
> > gmccol...@live.com<mailto:gmccol...@gyleshomes.com>   email
> >
> > 
> > From: gnucash-user 
> on behalf of D. via gnucash-user 
> > Sent: Tuesday, January 11, 2022 1:20 PM
> > To: David Carlson 
> > Cc: GnuCash 
> > Subject: Re: [GNC] Transaction Date issues during import OFX file (TD
> Bank)
> >
> > I'd be annoyed at the shift.
> >
> > I wonder what happens if the "[-5:EST]" gets removed.  The dates seem to
> have 0200 as their time; subtracting 5 hours from that would return -3
> o'clock (and presumably shift the date back one).
> >
> >
> >  Original Message 
> > From: David Carlson 
> > Sent: Tue Jan 11 12:53:59 EST 2022
> > To: "xraive ." 
> > Cc: Gnucash Users 
> > Subject: Re: [GNC] Transaction Date issues during import OFX file (TD
> Bank)
> >
> > Your bank creates the Ofx file.   Gnucash just accepts what they give
> you.
> > Sometimes it may appear to be incorrect when it is a misunderstanding
> about
> > whether transactions are posted on the same day they occur.
> >
> > Does it really make a difference?
> >
> >
> >
> >
> > On Tue, Jan 11, 2022, 10:12 AM xraive .  wrote:
> >
> >> I downloaded transactions from my bank (TD) in Canada and when I tried
> >> importing the file into GNUCASH all the dates were set to one day
> earlier
> >> then the actual transactions.  I'm including sample transactions below.
> >>
> >> OFX file imported to GNUCASH
> >>
> >> 
> >> DEBIT
> >> 2021072202[-5:EST]
> >> -14.64
> >> 21203175847980020
> >> Best Buy
> >> 
> >> 
> >> CREDIT
> >> 2021072602[-5:EST]
> >> 21.83
> >> 2120719980010
> >> Home Depot
> >> 
> >>
> >> Any help would be greatly appreciated.  If you need additional
> information
> >> please let me know.
> >>
> >> Thanks
> >> ___
> >> 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://li

Re: [GNC] Transaction Date issues during import OFX file (TD Bank)

[David Carlson]

And do you live in the Eastern Standard Time zone?


On Tue, Jan 11, 2022, 4:49 PM xraive .  wrote:

> If I haven't mentioned it, I'm running GNUCASH Version: 4.9 Build ID:
> 4.9+(2021-12-18) on a Windows 10 PC.  The time settings on this PC are
> correct as far as I can tell.
>
> Thanks in advance.
>
> --
> *From:* xraive . 
> *Sent:* Tuesday, January 11, 2022 10:33 PM
> *To:* David Carlson ; Jean Laroche <
> rip...@gmail.com>
> *Cc:* gnucash-user@gnucash.org 
> *Subject:* Re: [GNC] Transaction Date issues during import OFX file (TD
> Bank)
>
> Sorry for the late response.  I tried removing [-5:EST] and the issue
> still persists. All the dates are still reported as one day earlier.  I
> imported the same file in MSMoney and the dates matched the banks if that
> helps.
>
> Thanks for your assistance so far.
>
> *From:* gnucash-user 
> on behalf of David Carlson 
> *Sent:* Tuesday, January 11, 2022 9:33 PM
> *To:* Jean Laroche 
> *Cc:* gnucash-user@gnucash.org 
> *Subject:* Re: [GNC] Transaction Date issues during import OFX file (TD
> Bank)
>
> That -5 EST relates local time to universal time and may come into play if
> the local computer clock is not set to the local time zone.  Usually it
> clarifies the source time reference of the data.
>
> On Tue, Jan 11, 2022, 2:07 PM Jean Laroche  wrote:
>
> > > I wonder what happens if the "[-5:EST]" gets removed.  The dates seem
> to
> > have 0200 as their time; subtracting 5 hours from that would return -3
> > o'clock (and presumably shift the date back one).
> >
> > You could do a test where you modify your OFX file to remove [-5:EST]
> > from all transactions (you can do that easily in an editor), then try to
> > import it and see whether this fixes the dates.
> >
> > After that the question is whether that [-5:EST] is valid or not.
> > Jean
> >
> >
> > On 1/11/22 11:59 AM, D. via gnucash-user wrote:
> > > But EFT transactions (which are the bulk of my txns these days)
> > shouldn't get shifted around much at all. I'd be miffed if every EFT
> entry
> > were a day off.
> > >
> > >
> > >  Original Message 
> > > From: Gyle McCollam 
> > > Sent: Tue Jan 11 13:33:51 EST 2022
> > > To: "D." 
> > > Cc: "gnucash-user@gnucash.org" 
> > > Subject: Re: Re: [GNC] Transaction Date issues during import OFX file
> > (TD Bank)
> > >
> > > I find my dates usualy do not agree with the bank dates.  I record
> > credit card bills when I pay them (electronically) and they are recorded
> by
> > the payee on the same date.  However, they usually hit my bank the next
> > banking day.  This isn't and shouldn't be a problem or concern.  Actual
> > physical checks take even longer to show up at the bank.  This is all
> > normal.
> > >
> > >
> > > Thank You,
> > > Gyle McCollam
> > >
> > > Gyle McCollam
> > >
> > > 609.680.2326 Mobile
> > >
> > > gmccol...@live.com<mailto:gmccol...@gyleshomes.com
> >   email
> > >
> > > 
> > > From: gnucash-user 
> > on behalf of D. via gnucash-user 
> > > Sent: Tuesday, January 11, 2022 1:20 PM
> > > To: David Carlson 
> > > Cc: GnuCash 
> > > Subject: Re: [GNC] Transaction Date issues during import OFX file (TD
> > Bank)
> > >
> > > I'd be annoyed at the shift.
> > >
> > > I wonder what happens if the "[-5:EST]" gets removed.  The dates seem
> to
> > have 0200 as their time; subtracting 5 hours from that would return -3
> > o'clock (and presumably shift the date back one).
> > >
> > >
> > >  Original Message 
> > > From: David Carlson 
> > > Sent: Tue Jan 11 12:53:59 EST 2022
> > > To: "xraive ." 
> > > Cc: Gnucash Users 
> > > Subject: Re: [GNC] Transaction Date issues during import OFX file (TD
> > Bank)
> > >
> > > Your bank creates the Ofx file.   Gnucash just accepts what they give
> > you.
> > > Sometimes it may appear to be incorrect when it is a misunderstanding
> > about
> > > whether transactions are posted on the same day they occur.
> > >
> > > Does it really make a difference?
> > >
> > >
> > >
> > >
> > > On Tue, Jan 11, 2022, 10:12 AM xraive .  wrote:
> >

Re: [GNC] Transaction Date issues during import OFX file (TD Bank)

[David Carlson]

Xraive,
Your test proves that GnuCash in the release that you are using does not
perform that import function correctly.  You have found a work-around which
will work for you temporarily.  Now that the developers are aware of this,
hopefully there should be a fix applied in the next update. Unfortunately
in real life a fix for one problem sometimes creates a regression in some
other area.  Perhaps that is what happened here.

On Wed, Jan 12, 2022 at 10:54 AM Mattia Rizzolo  wrote:

> On Wed, Jan 12, 2022 at 5:46 PM xraive .  wrote:
> > I changed [-5:EST] to [+2:EST] and the dates are working.  But I don't
> know why that would work.
>
> FWIW, +2:EST doesn't make sense.  If you want UTC+2, that would be
> +2:EET (for example).
>
> (though TBH I'm not sure what are the actual parsing rules (according
> to the standard) of that datetime string, so it might or might not
> change the result)
>
> --
> regards,
> Mattia Rizzolo
>
> GPG Key: 66AE 2B4A FCCF 3F52 DA18  4D18 4B04 3FCD B944 4540  .''`.
> more about me:  https://mapreri.org : :'  :
> Launchpad user: https://launchpad.net/~mapreri  `. `'`
> Debian QA page: https://qa.debian.org/developer.php?login=mattia  `-
> ___
> 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] Transaction Date issues during import OFX file (TD Bank)

[David Carlson]

doing a little research I found this history, but no current bug.

https://bugs.gnucash.org/show_bug.cgi?id=636340

On Wed, Jan 12, 2022 at 11:17 AM Derek Atkins  wrote:

> Hi,
>
> On Wed, January 12, 2022 12:03 pm, David Carlson wrote:
> > Xraive,
> > Your test proves that GnuCash in the release that you are using does not
> > perform that import function correctly.  You have found a work-around
> > which
> > will work for you temporarily.  Now that the developers are aware of
> this,
> > hopefully there should be a fix applied in the next update. Unfortunately
> > in real life a fix for one problem sometimes creates a regression in some
> > other area.  Perhaps that is what happened here.
>
> Is there a Bugzilla Bug# for this issue?
>
> -derek
>
> >
> > On Wed, Jan 12, 2022 at 10:54 AM Mattia Rizzolo 
> > wrote:
> >
> >> On Wed, Jan 12, 2022 at 5:46 PM xraive .  wrote:
> >> > I changed [-5:EST] to [+2:EST] and the dates are working.  But I don't
> >> know why that would work.
> >>
> >> FWIW, +2:EST doesn't make sense.  If you want UTC+2, that would be
> >> +2:EET (for example).
> >>
> >> (though TBH I'm not sure what are the actual parsing rules (according
> >> to the standard) of that datetime string, so it might or might not
> >> change the result)
> >>
> >> --
> >> regards,
> >> Mattia Rizzolo
> >>
> >> GPG Key: 66AE 2B4A FCCF 3F52 DA18  4D18 4B04 3FCD B944 4540  .''`.
> >> more about me:  https://mapreri.org : :'  :
> >> Launchpad user: https://launchpad.net/~mapreri  `. `'`
> >> Debian QA page: https://qa.debian.org/developer.php?login=mattia  `-
> >> ___
> >> 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.
> >
>
>
> --
>Derek Atkins 617-623-3745
>de...@ihtfp.com www.ihtfp.com
>Computer and Internet Security Consultant
>
>

-- 
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] Transaction Date issues during import OFX file (TD Bank)

[David Carlson]

The OFX standard is very complex but that should not be an excuse for some
of the mistakes that sometimes happen.

It could be worse.   I have one credit card that reverses the sign on
charges and payments or the names of charges and payments,  so everything
comes in backwards.   I will probably try switching to QIF for that one,
but I vaguely recall there is a problem with that format too. I think even
CSV has issues there.




On Wed, Jan 12, 2022, 12:03 PM xraive .  wrote:

> I forgot to mention the file from RBC works fine.
>
> 
> From: xraive . 
> Sent: Wednesday, January 12, 2022 6:00 PM
> To: Mattia Rizzolo ; gnucash-user@gnucash.org <
> gnucash-user@gnucash.org>
> Subject: Re: [GNC] Transaction Date issues during import OFX file (TD Bank)
>
> Thanks for correcting me, I tried your suggestion and it came to the same
> result.  I've looked at my other financial institution and download their
> transactions.  They also have the same format the only difference being the
> transaction time.
>
> TD:  2021072202[-5:EST]
> RBC:  2021102512[-5:EST]
>
> 
> From: gnucash-user 
> on behalf of Mattia Rizzolo 
> Sent: Wednesday, January 12, 2022 4:53 PM
> To: gnucash-user@gnucash.org 
> Subject: Re: [GNC] Transaction Date issues during import OFX file (TD Bank)
>
> On Wed, Jan 12, 2022 at 5:46 PM xraive .  wrote:
> > I changed [-5:EST] to [+2:EST] and the dates are working.  But I don't
> know why that would work.
>
> FWIW, +2:EST doesn't make sense.  If you want UTC+2, that would be
> +2:EET (for example).
>
> (though TBH I'm not sure what are the actual parsing rules (according
> to the standard) of that datetime string, so it might or might not
> change the result)
>
> --
> regards,
> Mattia Rizzolo
>
> GPG Key: 66AE 2B4A FCCF 3F52 DA18  4D18 4B04 3FCD B944 4540  .''`.
> more about me:  https://mapreri.org : :'  :
> Launchpad user: https://launchpad.net/~mapreri  `. `'`
> Debian QA page: https://qa.debian.org/developer.php?login=mattia  `-
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Transaction Date issues during import OFX file (TD Bank)

[David Carlson]

You as a user have no way of knowing the history that the developers have
already done on that problem.   I would hope  that one of them will look at
it and get back to us with an answer whether the solution committed last
year didn't work,  never made it to release 4.9,  or what happened.



On Wed, Jan 12, 2022, 2:41 PM xraive .  wrote:

> I've never filled out a bug report.  Can anyone confirm if need to submit
> one or are the developers aware of this issue.
>
> ------
> *From:* David Carlson 
> *Sent:* Wednesday, January 12, 2022 8:25 PM
> *To:* xraive . 
> *Cc:* Mattia Rizzolo ; Gnucash Users <
> gnucash-user@gnucash.org>
> *Subject:* Re: [GNC] Transaction Date issues during import OFX file (TD
> Bank)
>
> The OFX standard is very complex but that should not be an excuse for some
> of the mistakes that sometimes happen.
>
> It could be worse.   I have one credit card that reverses the sign on
> charges and payments or the names of charges and payments,  so everything
> comes in backwards.   I will probably try switching to QIF for that one,
> but I vaguely recall there is a problem with that format too. I think even
> CSV has issues there.
>
>
>
>
> On Wed, Jan 12, 2022, 12:03 PM xraive .  wrote:
>
> I forgot to mention the file from RBC works fine.
>
> 
> From: xraive . 
> Sent: Wednesday, January 12, 2022 6:00 PM
> To: Mattia Rizzolo ; gnucash-user@gnucash.org <
> gnucash-user@gnucash.org>
> Subject: Re: [GNC] Transaction Date issues during import OFX file (TD Bank)
>
> Thanks for correcting me, I tried your suggestion and it came to the same
> result.  I've looked at my other financial institution and download their
> transactions.  They also have the same format the only difference being the
> transaction time.
>
> TD:  2021072202[-5:EST]
> RBC:  2021102512[-5:EST]
>
> 
> From: gnucash-user 
> on behalf of Mattia Rizzolo 
> Sent: Wednesday, January 12, 2022 4:53 PM
> To: gnucash-user@gnucash.org 
> Subject: Re: [GNC] Transaction Date issues during import OFX file (TD Bank)
>
> On Wed, Jan 12, 2022 at 5:46 PM xraive .  wrote:
> > I changed [-5:EST] to [+2:EST] and the dates are working.  But I don't
> know why that would work.
>
> FWIW, +2:EST doesn't make sense.  If you want UTC+2, that would be
> +2:EET (for example).
>
> (though TBH I'm not sure what are the actual parsing rules (according
> to the standard) of that datetime string, so it might or might not
> change the result)
>
> --
> regards,
> Mattia Rizzolo
>
> GPG Key: 66AE 2B4A FCCF 3F52 DA18  4D18 4B04 3FCD B944 4540  .''`.
> more about me:  https://mapreri.org : :'  :
> Launchpad user: https://launchpad.net/~mapreri  `. `'`
> Debian QA page: https://qa.debian.org/developer.php?login=mattia  `-
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Transaction Date issues during import OFX file (TD Bank)

[David Carlson]

Derek is a developer.   Follow his advice

On Wed, Jan 12, 2022, 2:56 PM David Carlson 
wrote:

> You as a user have no way of knowing the history that the developers have
> already done on that problem.   I would hope  that one of them will look at
> it and get back to us with an answer whether the solution committed last
> year didn't work,  never made it to release 4.9,  or what happened.
>
>
>
> On Wed, Jan 12, 2022, 2:41 PM xraive .  wrote:
>
>> I've never filled out a bug report.  Can anyone confirm if need to submit
>> one or are the developers aware of this issue.
>>
>> --
>> *From:* David Carlson 
>> *Sent:* Wednesday, January 12, 2022 8:25 PM
>> *To:* xraive . 
>> *Cc:* Mattia Rizzolo ; Gnucash Users <
>> gnucash-user@gnucash.org>
>> *Subject:* Re: [GNC] Transaction Date issues during import OFX file (TD
>> Bank)
>>
>> The OFX standard is very complex but that should not be an excuse for
>> some of the mistakes that sometimes happen.
>>
>> It could be worse.   I have one credit card that reverses the sign on
>> charges and payments or the names of charges and payments,  so everything
>> comes in backwards.   I will probably try switching to QIF for that one,
>> but I vaguely recall there is a problem with that format too. I think even
>> CSV has issues there.
>>
>>
>>
>>
>> On Wed, Jan 12, 2022, 12:03 PM xraive .  wrote:
>>
>> I forgot to mention the file from RBC works fine.
>>
>> 
>> From: xraive . 
>> Sent: Wednesday, January 12, 2022 6:00 PM
>> To: Mattia Rizzolo ; gnucash-user@gnucash.org <
>> gnucash-user@gnucash.org>
>> Subject: Re: [GNC] Transaction Date issues during import OFX file (TD
>> Bank)
>>
>> Thanks for correcting me, I tried your suggestion and it came to the same
>> result.  I've looked at my other financial institution and download their
>> transactions.  They also have the same format the only difference being the
>> transaction time.
>>
>> TD:  2021072202[-5:EST]
>> RBC:  2021102512[-5:EST]
>>
>> 
>> From: gnucash-user 
>> on behalf of Mattia Rizzolo 
>> Sent: Wednesday, January 12, 2022 4:53 PM
>> To: gnucash-user@gnucash.org 
>> Subject: Re: [GNC] Transaction Date issues during import OFX file (TD
>> Bank)
>>
>> On Wed, Jan 12, 2022 at 5:46 PM xraive .  wrote:
>> > I changed [-5:EST] to [+2:EST] and the dates are working.  But I don't
>> know why that would work.
>>
>> FWIW, +2:EST doesn't make sense.  If you want UTC+2, that would be
>> +2:EET (for example).
>>
>> (though TBH I'm not sure what are the actual parsing rules (according
>> to the standard) of that datetime string, so it might or might not
>> change the result)
>>
>> --
>> regards,
>> Mattia Rizzolo
>>
>> GPG Key: 66AE 2B4A FCCF 3F52 DA18  4D18 4B04 3FCD B944 4540  .''`.
>> more about me:  https://mapreri.org : :'  :
>> Launchpad user: https://launchpad.net/~mapreri  `. `'`
>> Debian QA page: https://qa.debian.org/developer.php?login=mattia  `-
>> ___
>> gnucash-user mailing list
>> gnucash-user@gnucash.org
>> To update your subscription preferences or to unsubscribe:
>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>> If you are using Nabble or Gmane, please see
>> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
>> -
>> Please remember to CC this list on all your replies.
>> You can do this by using Reply-To-List or Reply-All.
>> ___
>> gnucash-user mailing list
>> gnucash-user@gnucash.org
>> To update your subscription preferences or to unsubscribe:
>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>> If you are using Nabble or Gmane, please see
>> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
>> -
>> Please remember to CC this list on all your replies.
>> You can do this by using Reply-To-List or Reply-All.
>>
>>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Transaction Date issues during import OFX file (TD Bank)

[David Carlson]

The most important thing is to report your own results with files from your
banks and the rest of your details about the versions of Gnucash etc.  If
you start a new bug report you could even reference those other bug
reports.

Over the years there have been issues with daylight time adjustment s
affecting the transactions date s in certain time zones  and sometimes bank
data is questionable.

If the developer s need more information they will ask.

On Wed, Jan 12, 2022, 3:37 PM xraive .  wrote:

>
> There seems to be two reports already with somewhat similar issues but I
> could be mistaken.
>
> https://bugs.gnucash.org/show_bug.cgi?id=797848
> and a much older one
> https://bugs.gnucash.org/show_bug.cgi?id=137017
>
> If they aren't related then I can go ahead and submit a new bug.  What do
> you think?
>
> ------
> *From:* David Carlson 
> *Sent:* Wednesday, January 12, 2022 8:58 PM
> *To:* xraive . 
> *Cc:* Mattia Rizzolo ; Gnucash Users <
> gnucash-user@gnucash.org>
> *Subject:* Re: [GNC] Transaction Date issues during import OFX file (TD
> Bank)
>
> Derek is a developer.   Follow his advice
>
> On Wed, Jan 12, 2022, 2:56 PM David Carlson 
> wrote:
>
> You as a user have no way of knowing the history that the developers have
> already done on that problem.   I would hope  that one of them will look at
> it and get back to us with an answer whether the solution committed last
> year didn't work,  never made it to release 4.9,  or what happened.
>
>
>
> On Wed, Jan 12, 2022, 2:41 PM xraive .  wrote:
>
> I've never filled out a bug report.  Can anyone confirm if need to submit
> one or are the developers aware of this issue.
>
> --
> *From:* David Carlson 
> *Sent:* Wednesday, January 12, 2022 8:25 PM
> *To:* xraive . 
> *Cc:* Mattia Rizzolo ; Gnucash Users <
> gnucash-user@gnucash.org>
> *Subject:* Re: [GNC] Transaction Date issues during import OFX file (TD
> Bank)
>
> The OFX standard is very complex but that should not be an excuse for some
> of the mistakes that sometimes happen.
>
> It could be worse.   I have one credit card that reverses the sign on
> charges and payments or the names of charges and payments,  so everything
> comes in backwards.   I will probably try switching to QIF for that one,
> but I vaguely recall there is a problem with that format too. I think even
> CSV has issues there.
>
>
>
>
> On Wed, Jan 12, 2022, 12:03 PM xraive .  wrote:
>
> I forgot to mention the file from RBC works fine.
>
> 
> From: xraive . 
> Sent: Wednesday, January 12, 2022 6:00 PM
> To: Mattia Rizzolo ; gnucash-user@gnucash.org <
> gnucash-user@gnucash.org>
> Subject: Re: [GNC] Transaction Date issues during import OFX file (TD Bank)
>
> Thanks for correcting me, I tried your suggestion and it came to the same
> result.  I've looked at my other financial institution and download their
> transactions.  They also have the same format the only difference being the
> transaction time.
>
> TD:  2021072202[-5:EST]
> RBC:  2021102512[-5:EST]
>
> 
> From: gnucash-user 
> on behalf of Mattia Rizzolo 
> Sent: Wednesday, January 12, 2022 4:53 PM
> To: gnucash-user@gnucash.org 
> Subject: Re: [GNC] Transaction Date issues during import OFX file (TD Bank)
>
> On Wed, Jan 12, 2022 at 5:46 PM xraive .  wrote:
> > I changed [-5:EST] to [+2:EST] and the dates are working.  But I don't
> know why that would work.
>
> FWIW, +2:EST doesn't make sense.  If you want UTC+2, that would be
> +2:EET (for example).
>
> (though TBH I'm not sure what are the actual parsing rules (according
> to the standard) of that datetime string, so it might or might not
> change the result)
>
> --
> regards,
> Mattia Rizzolo
>
> GPG Key: 66AE 2B4A FCCF 3F52 DA18  4D18 4B04 3FCD B944 4540  .''`.
> more about me:  https://mapreri.org : :'  :
> Launchpad user: https://launchpad.net/~mapreri  `. `'`
> Debian QA page: https://qa.debian.org/developer.php?login=mattia  `-
> ___
> 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] Transaction Date issues during import OFX file (TD Bank)

[David Carlson]

I have kept copies of OFX exports from several FI's for my personal data
for several years.  I could make a few of them available for testing if
needed.  They are from several different US banks, credit union, or credit
card companies.

I quoted the October 16 2020 edition of the OFX standard in
https://bugs.gnucash.org/show_bug.cgi?id=798418 which surprisingly states
that the datetime elements that libofx uses are expressed in FI local time
rather than Universal time and the burden is on the client software to
determine dates in the user's perspective.

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] Post crash recovery log file suggestion

[David Carlson]

Of course you could do a File > Save just before embarking upon some more
risky activity such as a OFX import or after downloading security prices...

On Sat, Jan 15, 2022 at 4:22 PM john  wrote:

>
> > On Jan 15, 2022, at 11:10 AM, David G. Pickett via gnucash-user <
> gnucash-user@gnucash.org> wrote:
> >
> > As 4.9 does abort ungracefully from time to time, I grow weary of
> reentering my unsaved transactions.  I suggest that you post them to a new
> sort of log file as I go, so I do not have to save megabytes of almost
> duplicate files so often to avoid this.  Of course, if I leave the cursor
> on a modified line, I still might lose that line, unless you can log that
> along with its state when I change tabs.   (Maybe I should be warned when I
> change tabs that I left an uncommitted transaction, not later when I
> save?)  When the app starts, it can check the file and replay.  When there
> is a save and the normal files are closed or flushed to disk, the new log
> file can be truncated.  It'd be very much like an RDBMS log.  And perhaps a
> way to allow us to save less often?
>
> We do, that's what the *.log files in the same directory as your data file
> are. Note, though, that they log only transactions and their splits.
> Nothing else, especially not the business stuff, is logged.
>
>
> To re-enter them use File>Import>Replay GnuCash Log File.
>
> You could enable auto-save in preferences, but when that runs it blocks
> the UI so it can be a bit tedious if you have a large file. You might also
> consider the SQLite3 backend that writes the database immediately when you
> complete a transaction, at the expense of not making a backup file and not
> being able to quit without saving if you decide you've made a mess of a
> session.
>
> Regards,
> John Ralls
>
> ___
> 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] Exiting GNUCash

[David Carlson]

It is not clear what you think happened.  It seems that more than one thing
did not transpire as you expected, since abandoning an edit, the presumed
cause of the shutdown without saving warning, and the attempt to open a
file already in use are different events.
Then how did you ascertain that, in fact, GnuCash did not save.  What,
exactly did it not save?  Did you allow sufficient time for GnuCash to
actually complete the entire shutdown?  Sometimes it takes a really long
time to shut down.  For example, when Linux decides to put some of
GnuCash's virtual RAM onto hard drive swap space, it may take over a minute
for the OS to recover and close the open file.



On Mon, Jan 17, 2022 at 6:04 PM Gyle McCollam  wrote:

> I usually don't forget to save first so I don't know how long this has
> been happening.  Today I didn't save, so when the dialogue box came up, I
> selected "cancel".  GNUCash shutdown without saving and when I tried to
> open it thought there was another instance running, but I said open
> anyway.  I tested this again with the same result.  Then I tried it again,
> this time telling the system to save.  It shut down again, but it did not
> save!  I got the same message about the file already in use.
>
> Has anyone else encounter this error?  I am using Win11 and GNUCash 4.9.
>
>
> Thank You,
> Gyle McCollam
>
> Gyle McCollam
>
> 609.680.2326 Mobile
>
> gmccol...@live.com<mailto:gmccol...@gyleshomes.com>   email
> ___
> 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] Exiting GNUCash

[David Carlson]

David T,

Is One Drive able to hide all the file system lags that it introduces from
programs like GnuCash?  If so, I need to consider using it.  That is why I
am asking for more comments here.

On Tue, Jan 18, 2022, 12:11 PM D.  wrote:

> David,
>
> What Gyle is describing has nothing to do with OneDrive. Gnucash shouldn't
> exit the program when he closes the "Save/Close without Saving/Cancel"
> dialog box by clicking the "X" for the dialog-- and it sure shouldn't leave
> the lock file in place when it does so. That the lock file still exists
> supports the idea of a crash.
>
> Gyle: what happens if you click Cancel?
>
> David T.
> --
> *From:* David Carlson
> *Sent:* Tue Jan 18 12:01:53 EST 2022
> *To:* Gyle McCollam
> *Cc:* "gnucash-user@gnucash.org"
> *Subject:* Re: [GNC] Exiting GNUCash
>
> That is an issue with the way you have your file system organized, but it
> is not necessarily bad or wrong, just an artifact, I think.  I do not use
> OneDrive or equivalent yet myself because I have not decided how to manage
> that very issue of the lag while background updates are happening to my
> data file storage system.
>
> You are getting that lock warning because your OneDrive has not caught up
> with you yet.  If you open anyway, you are burdening the OneDrive with more
> work to keep the data intact, and I do not know if it can handle that, thus
> I do not try it.  Perhaps other users of that type of arrangement can give
> us their experience.That is probably also the cause of the Save Changes
> warning.  That may actually lose your recent work just as warned.  Again,
> perhaps others have experience with OneDrive.
>
> On Tue, Jan 18, 2022 at 10:38 AM Gyle McCollam  wrote:
>
>  David, Hopefully I can clarify what is happening.  I did not abandon an
>>  edit.  I finished an entry, but clicked on the "x" to shutdown before
>>  saving.  Included is a screenshot of a test entry that was completed (see
>>  last line).  Then, I clicked on the "x" to shutdown and the dialogue popped
>>  up.
>>  I seem to remember that "cancel" brought you back into GNUCash and "save"
>>  atctually save the current state of the file.  Now, it doesn't matter which
>>  option I choose it, I think it crashes GNUCash.  Then on the next startup
>>  it tells me:
>>
>>  I select "Open Anyway" and the test entry is gone.  I hope this make it
>>  more clear.
>>
>>
>>  Thank You,
>>  *Gyle McCollam*
>>
>>  Gyle McCollam
>>
>>  609.680.2326 Mobile
>>
>>  gmccol...@live.comemail
>> --
>>
>>  *From:* David Carlson 
>>  *Sent:* Monday, January 17, 2022 8:46 PM
>>  *To:* Gyle McCollam 
>>  *Cc:* gnucash-user@gnucash.org 
>>  *Subject:* Re: [GNC] Exiting GNUCash
>>
>>  It is not clear what you think happened.  It seems that more than one
>>  thing did not transpire as you expected, since abandoning an edit, the
>>  presumed cause of the shutdown without saving warning, and the attempt to
>>  open a file already in use are different events.
>>  Then how did you ascertain that, in fact, GnuCash did not save.  What,
>>  exactly did it not save?  Did you allow sufficient time for GnuCash to
>>  actually complete the entire shutdown?  Sometimes it takes a really long
>>  time to shut down.  For example, when Linux decides to put some of
>>  GnuCash's virtual RAM onto hard drive swap space, it may take over a minute
>>  for the OS to recover and close the open file.
>>
>>
>>
>>  On Mon, Jan 17, 2022 at 6:04 PM Gyle McCollam  wrote:
>>
>>  I usually don't forget to save first so I don't know how long this has
>>  been happening.  Today I didn't save, so when the dialogue box came up, I
>>  selected "cancel".  GNUCash shutdown without saving and when I tried to
>>  open it thought there was another instance running, but I said open
>>  anyway.  I tested this again with the same result.  Then I tried it again,
>>  this time telling the system to save.  It shut down again, but it did not
>>  save!  I got the same message about the file already in use.
>>
>>  Has anyone else encounter this error?  I am using Win11 and GNUCash 4.9.
>>
>>
>>  Thank You,
>>  Gyle McCollam
>>
>>  Gyle McCollam
>>
>>  609.680.2326     Mobile
>>
>>  gmccol...@live.com<mailto:gmccol...@gyleshomes.com>   email
>> --
>>
>

[GNC] OneDrive and GnuCash

[David Carlson]

Are there any GnuCash users that store their data files in One Drive?

Are there any issues slow response or keeping a few weeks of backup and log
files?
___
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] Exiting GNUCash

[David Carlson]

On Tue, Jan 18, 2022 at 1:29 PM Gyle McCollam  wrote:

> First, I would like to say that when I was referring to clicking the "x"
> it was for GNUCash, which the brings up the dialog for "Save/Close without
> Saving/Cancel".  However, if I click the cancel button it "crashes" as
> well.  Also, even if I click the Save, it does the same thing.  All
> instances "crash" GNUCash and any entries not saved since the last
> automatic save are lost.  I also feel it has nothing to do with OneDrive as
> it worked fine until this last problem.
>
> One way to ascertain whether there are any OS or file system issues
working in the background at the same time that GnuCash is doing something
is to keep a task manager running on the same system monitoring volatile
memory and non-volatile 'Drive' activity (and network activity).  Then try
to time your test to happen when there is little or no other activity to
interfere with your test.


>
> Thank You,
> Gyle McCollam
>
> Gyle McCollam
>
> 609.680.2326 Mobile
>
> gmccol...@live.com<mailto:gmccol...@gyleshomes.com>   email
>
> 
> From: D. 
> Sent: Tuesday, January 18, 2022 1:46 PM
> To: David Carlson 
> Cc: Gyle McCollam ; D. via gnucash-user <
> gnucash-user@gnucash.org>
> Subject: Re: [GNC] Exiting GNUCash
___
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] Exiting gnucash Lock file Vol 226, Issue 57

[David Carlson]

Peter,

Your message has gotten detached from the thread..

We need more information to hazard a guess whether your issue is the same
as that of Gyle or if it is just similar.

Do you save your data file on a hard drive?  Do you encrypt it?

Do you use cloud storage for backup?

Do you use Windows or another OS?

Can you think of any other commonality when the lock file is not deleted?



On Tue, Jan 18, 2022, 11:05 PM Peter  wrote:

> This is interesting.
>
> I have had this problem of gnucash intermittently not removing the LOCK
> file for some time.
> My method of closing gnucash is firstly to save the data and the close
> using the menu. I always follow this process and never use the 'X' method.
>
> August 24, 2021 gnucash ver 4.6, I investigated using SQLlite instead of
> the compressed XML for data storage.
> SQLite worked but the resultant file(s) were much larger than the XML
> compressed version so I decided to continue to use the compressed XML.
>
>  From that date (August 24, 2021) to today I still get gnucash
> intermittently not removing the LOCK file.
> This includes ver4.7, ver4.8 and ver4.9. It may happen ver4.6 but unsure.
> Ever time I updated I hoped it would resolve the issue but it still
> happens.
> About 20 days ago I deleted the SQL subdirectory and files from my local
> data disk. This seemed to make no difference to the issue.
>
>
>
> On 19/01/2022 06:17, gnucash-user-requ...@gnucash.org wrote:
> > Send gnucash-user mailing list submissions to
> >   gnucash-user@gnucash.org
> >
> > To subscribe or unsubscribe via the World Wide Web, visit
> >   https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > or, via email, send a message with subject or body 'help' to
> >   gnucash-user-requ...@gnucash.org
> >
> > You can reach the person managing the list at
> >   gnucash-user-ow...@gnucash.org
> >
> > When replying, please edit your Subject line so it is more specific
> > than "Re: Contents of gnucash-user digest..."
> >
> > Today's Topics:
> >
> > 1. Re:  Exiting GNUCash (D.)
> > 2. Re:  Exiting GNUCash (David Carlson)
> > 3.  OneDrive (men...@fastmail.fm)
> > 4. Re:  gnucash-user Digest, Vol 226, Issue 48 (Heide Wang)
> > 5. Re:  OneDrive and GnuCash (davidcousen...@gmail.com)
> >
> > ___
> >
> > gnucash-user mailing list
> > gnucash-user@gnucash.org
> > To update your subscription preferences or to unsubscribe:
> > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> > -
> > Please remember to CC this list on all your replies.
> > You can do this by using Reply-To-List or Reply-All.
>
> --
>
> ___
> 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] Exiting gnucash Lock file Vol 226, Issue 57

[David Carlson]

lighted
> and complying with the dialogue to SAVE the Data file.
> Test#2 and Test#6
>
> Four methods of exiting that do delete the LOCK file and SAVE the latest
> changes
> A:Waiting to exit after an Autosave  then File->Quit
> B:forcing a Save by using the SAVE button then File->Quit
> C:Waiting to exit after an Autosave  then the X method
> D:forcing a Save by using the SAVE button then the X method
>
>   X method works if you do a SAVE using the Save Button or wait till
> after an Autosave then exit via the X method
>
> There is an issue with exiting and relying on gnucash to save the data
> if gnucash produces the dialogue to SAVE the data then File->Quit or the
> X method
> The Save does not work and the LOCK file is not deleted.
>
>   I cannot safely say I do not use the X method as I now have doubts
> about it, I may use it or I may not.
>
> Hope this helps someone as now I understand why sometimes it does work
> and does NOT work, there is a bug in it or is it a misinterpreted
> enhancement.
>
>
>
> ___
> 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] Split transaction

[David Carlson]

Heidi,

One day last month you went to the grocery store and bought $200.00 worth
of groceries, paying for them with your credit card.  Another day you went
to the furniture store and bought two chairs, paying with your credit
card.  Those two separate transactions would be recorded between your
credit card liability account and your grocery expense account and your
furniture expense account in transactions dated on the days that you made
those purchases.  Then at the end of the month you paid your credit card
bill from your bank account.  That was a different transaction, but it was
simply a payment to the credit card company.

Just keep each transaction separate in Gnucash, like you did in real life.
Then those other suggestions will make more sense.



On Sat, Jan 22, 2022 at 4:56 AM Liz  wrote:

> On Fri, 21 Jan 2022 21:16:35 -0800
> "Stephen M. Butler"  wrote:
>
> > Heidi,
> >
> > Also, this sounds like a credit card being used for several purchases
> > throughout the month.  In which case it is better to record the
> > individual purchases as they occur.  Or, download the individual
> > lines to import.
> >
> > In that case, you will have a Liability:Credit Card:nameofcc account
> > against which all the transactions will post with the other side of
> > the post (the other split) being the relevant expense account.
> >
> > When you pay the credit card off, you record the payment against the
> > checking account on the one side and the Liability account on the
> > other.
> >
> > Otherwise, if you have a lot of purchases throughout the month there
> > would be one humongous transaction with gobs of splits and you would
> > lose the date for each purchase.
>
> This is the best way to proceed, once you have followed David Cousen's
> suggestion and read the tutorial and concepts guide.
>
> Liz
> ___
> 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] CSV Price Import: Saving Colum Assignments

[David Carlson]

Is the CSV transaction importer equally forgetful in that release?

On Tue, Jan 25, 2022 at 4:18 PM Stephen M. Butler <
stephen.m.butle...@gmail.com> wrote:

> I used to use the csv file import in version 3.8.  That remembered the
> column assignments, date format, and the main account (a liability
> account).
>
> Sounds like this is a bug.
>
> --Steve
>
>
> On 1/25/22 13:40, Thomas wrote:
> > Dear list,
> >
> > I have a fixed format of CSV-files to import prices for securities and
> > I saved the respective preset in the CSV import wizard.
> > Unfortunately, only the assignment for the date is "remembered", while
> > the other column assignments (e.g., namespace, symbol, value) are
> > always set to none when I load the said preset.
> >
> > Is this normal behavior and/or is there a way to also save the other
> > assignments?
> >
> > GnuCash
> > Version: 4.9
> > Version-ID: 4.9+(2021-12-18)
> > on ArchLinux
> >
> >
> > Thanks a lot in advance!
> >
> > Best,
> > Thomas
> >
> >
> >
> > ___
> > 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.
>
>
> --
> Stephen M Butler, PMP, PSM
> stephen.m.butle...@gmail.com
> kg...@arrl.net
> 253-350-0166
> ---
> GnuPG Fingerprint:  8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8
>
> ___
> 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] Printing reports

[David Carlson]

Also, if you choose to use your operating system printer dialog, that can
remember your last printer choice as Print to file and it will probably
remember your last destination folder.



On Wed, Jan 26, 2022 at 12:51 PM Glenn Fowler  wrote:

> In addition, there is a built-in "Make PDF" so you don't have to use a
> print-to-file PDF in  your printer selection
>
>
> On Wed, Jan 26, 2022 at 1:16 PM Stephen M. Butler <
> stephen.m.butle...@gmail.com> wrote:
>
> > You have to open the "saved configuration" rather than the normal report.
> >
> > When you click on the REPORTS main menu item, scan down and click on
> > "Saved Report Configurations", then pick the one you saved.
> >
> > --Steve
> >
> >
> > On 1/26/22 10:06, One-time queries wrote:
> > > Back to using Gnucash after many years absence.  It seems to have
> > changed from what I remember.
> > >
> > > My  problem is that I want to set ‘Print to File’ as my default on the
> > Print window.
> > >
> > > Additionally I want to save the choices for a report so that I can
> print
> > that report again without having to set in all the variables.  I want,
> for
> > example, all accounts to be selected.  I want the default dates to be
> from
> > the beginning of the previous year to the end of the previous year-  I
> have
> > tried to save these using both Save Config and Save Config As… but when I
> > try to open the report it is back to default, that is no accounts,
> > beginning of this year and end of this year.
> > >
> > > What am I missing?
> > > ___
> > > 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.
> >
> >
> > --
> > Stephen M Butler, PMP, PSM
> > stephen.m.butle...@gmail.com
> > kg...@arrl.net
> > 253-350-0166
> > ---
> > GnuPG Fingerprint:  8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8
> >
> > ___
> > 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] CSV Price Import: Saving Colum Assignments

[David Carlson]

Back in prehistoric times we called that amnesia.  Today it might be called
Alzheimer’s or software bug.

On Wed, Jan 26, 2022 at 2:51 PM Thomas 
wrote:

> No, the CSV transaction importer seems to load all column assignments.
>
> On 1/25/22 23:32, David Carlson wrote:
> > Is the CSV transaction importer equally forgetful in that release?
> >
> > On Tue, Jan 25, 2022 at 4:18 PM Stephen M. Butler <
> > stephen.m.butle...@gmail.com> wrote:
> >
> >> I used to use the csv file import in version 3.8.  That remembered the
> >> column assignments, date format, and the main account (a liability
> >> account).
> >>
> >> Sounds like this is a bug.
> >>
> >> --Steve
> >>
> >>
> >> On 1/25/22 13:40, Thomas wrote:
> >>> Dear list,
> >>>
> >>> I have a fixed format of CSV-files to import prices for securities and
> >>> I saved the respective preset in the CSV import wizard.
> >>> Unfortunately, only the assignment for the date is "remembered", while
> >>> the other column assignments (e.g., namespace, symbol, value) are
> >>> always set to none when I load the said preset.
> >>>
> >>> Is this normal behavior and/or is there a way to also save the other
> >>> assignments?
> >>>
> >>> GnuCash
> >>> Version: 4.9
> >>> Version-ID: 4.9+(2021-12-18)
> >>> on ArchLinux
> >>>
> >>>
> >>> Thanks a lot in advance!
> >>>
> >>> Best,
> >>> Thomas
> >>>
> >>>
> >>>
> >>> ___
> >>> 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.
> >>
> >>
> >> --
> >> Stephen M Butler, PMP, PSM
> >> stephen.m.butle...@gmail.com
> >> kg...@arrl.net
> >> 253-350-0166
> >> ---
> >> GnuPG Fingerprint:  8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8
> >>
> >> ___
> >> 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] Mutual Funds

[David Carlson]

Maybe someone at your local library can help.  I haven't seen W11 yet
myself.

Long term solution might be to switch to Linux.

On Fri, Jan 28, 2022, 10:12 AM John Lawton via gnucash-user <
gnucash-user@gnucash.org> wrote:

> I'm having issues installing GnuCash online financial quotes on Windows
> 11.  I don't see the "GnuCash Group" in my start menu.  Can you install
> this program remotely?  What do you suggest?John Lawton
> ___
> 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] Can't get Scheduled Transactions to work

[David Carlson]

Jed,

Scheduled transactions have had an issue for a long time that may explain
part of what you are seeing, as it involves templates showing up
unexpectedly in certain situations.  see
https://bugs.gnucash.org/show_bug.cgi?id=741674, which, coincidentally is
just now being addressed, but it does not explain everything that you are
describing.  One other characteristic of scheduled transactions that is not
obvious is the fact that when an existing transaction is taken as a
template to create a new scheduled transaction, that transaction does not
become a vector to use to point the editor to the template for further
editing like transactions which have actually been created by the Since
Last Run demon.  In other words, I can add a little information but I do
not have enough information to solve your concern.  Sorry that I cannot
help more.



On Fri, Jan 28, 2022 at 8:38 PM Jed Taylor  wrote:

> Second update -
>
> Well, more issues.
>
> I went into the ST editor to look at what I've done so far, and for each of
> the five I've created so far, the template is empty.  If the template is
> empty, instead of having the correct accounts to post the transaction to,
> how is it going work on 2022-02-01?
>
>
> -Original Message-
> From: gnucash-user  offthedial@gnucash.org>
> On Behalf Of Jed Taylor
> Sent: Friday, January 28, 2022 15:49
> To: gnucash-user@gnucash.org
> Subject: [GNC] Can't get Scheduled Transactions to work
>
> GnuCash v4.6 on Windows 10.
>
>
>
> I'm working on setting up the books for my condo association, which has 20
> units.  With 20 units, I'd like to have GnuCash automatically post the
> monthly assessment due from each unit, which is a different amount for
> each,
> on the first of the month to the G/J.
>
>
>
> I've read the Help on STs, and followed the steps, as well as gotten into
> editing the ST.  So far, I simply can't get this feature to work.
>
>
>
> I'm testing this feature using only one unit to start.  The books open in
> late 2020-09, so the first entry for assessments is dated 2020-10-01.
>
>
>
> I created a G/J entry that posts the amount for the unit to its A/R &
> Income
> accounts.  So far, so good.  Then, I select that transaction and click on
> the "Schedule" button and tell the dialog I want a monthly transaction.
> I've tried this using both 10-01 and 11-01 as the start date for the ST,
> and
> I'm getting the same results.  I have also tried this using the current
> date
> for my PC's date as well as resetting my PCs date to 2020-11-01.
>
>
>
> Each time I can get the ST to post, the two account fields are filled with
> hexadecimal characters rather than actual accounts from the template
> transaction.  The account balances remain unchanged.  If I go to the G/J
> and
> click on the entry, GC tells me the account doesn't exist and asks me if I
> want to create it.
>
>
>
> If I examine the entry for the ST, when I go to the Template window, the
> information for the transaction is blank.  When I fill in the information
> there, it accepts it, but when it posts, again, I get the same nonsense hex
> for the accounts rather than what I've assigned.
>
>
>
> What I expected to happen when I set up the ST is for every month between
> 2020-10-01 and 2022-01-01 to post to the G/J and have the ST slice of the
> app tell me that the next one ready to post would be for 2022-02.
>
>
>
> Clearly, I'm missing something.  What is it?
>
>
>
> TIA.
>
>
>
> ___
> 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] GNC used side by side with GNC Andriod

[David Carlson]

Jeff,

When you 'upgraded' your cellphone did you re-install the GnuCash Android
app or do something else?  Do you have details of what actual data may have
triggered the error or the precise error message?  Is it repeatable?  Did
you keep copies of the import files?  Have you tried to create a trace
file? - I know that is difficult in a Windows environment, and I do not
know where the instructions are buried, I think they are in the website FAQ
somewhere.

On Sat, Jan 29, 2022 at 1:22 AM Jeff  wrote:

> I know that they are entirely separate and discrete applications.  So no
> lambasting please.
>
> I have successfully imported more qif files than I care to count from
> Android to GNC up until I "upgraded" my cell phone.  Great cooperation
> between you and the developers of the Android version.  Pat on many
> backs of both development teams.
>
> Now I am getting an error of invalid stock entries on import into GNC,
> when there are no stock entries on the Android side  ( I have looked at
> the qif file and there are no stock exchanges, nor do I own or sell sell
> stocks yet).  Only day to day cash, bank, or credit card transactions.
> I'll be flipped if I can find a stock entry in the Android qif files.
>
> Has anyone else encountered this or a similar issue?
>
> --
> --JEffrey Black M.B.A.
>
> ___
> 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] Canadian Mortgage

[David Carlson]

If there is a way (and there definitely is) to congregate between two cents
and six cents of rounding losses per account times millions of accounts per
year, count on bankers to find it.

On Mon, Jan 31, 2022 at 3:56 AM Liz  wrote:

> On Sun, 30 Jan 2022 21:40:37 -0500
> Al Maloney  wrote:
>
> > Thanks.
> > What you say about formulae and bank practice makes sense to me.
> > Your advice says to me: "Don't sweat the small stuff".
>
> Some years ago, in Australia a number of people took to the courts to
> get the banks to recalculate their mortgages according to the contracts.
> I can't find an online reference in a 2 minute search, but before the
> days of a powerful home computer the calculations were beyond most
> people.
> Of course, you only need to take a couple of cents extra each month to
> make a worthwhile profit, and that is hard to find.
>
> While I agree, don't sweat the small stuff, there are those who are
> hoping you won't notice a little bit often.
>
> Liz
> ___
> 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] Warning account contains splits whose reconcile date is after statement date

[David Carlson]

If that is the exact wording of the warning then the offending reconciled
split may be in a different account. One thing you could try is to open
Tools > General Journal and select View > Filter by..  > Status and uncheck
everything except Reconciled.  If there really is an oddball that should
make it easy to find.

On Mon, Jan 31, 2022 at 1:39 PM Cricket Onebit 
wrote:

> I get this warning each time I reconcile my credit card statement. It's
> happened for several months now.
>
> The balance is fine. There was a bit of confusion over similar lines, but
> the balances are now fine. (it was a really good series of $10.19 books.)
>
> The latest statement was Jan 10. The last transaction was Jan 9, and I
> double-checked the years.
>
> Is there any way I can find out which transactions are the problem, or
> clear the error going forward?
>
> Thanks,
>
> Cricket / Sandy
>
> --
> +++
>
> Not as a ladder from earth to Heaven, not as a witness to any creed,
> But simple service simply given to his own kind in their common need.
> -- Rudyard Kipling
> ___
> 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.

[GNC] Bayesian Matching is not working very well

[David Carlson]

I am currently running GnuCash 3.8 in Ubuntu 20.04.  This release has the
'New' generic importer with the revised Bayesian matching.  I have found
that sometimes it is good at assigning accounts to incoming transactions
and other times it is awful.  One example is transactions where Starbucks
recharges my wife's online app with $25.00 two or three times a month,
GnuCash has seen this transaction 130 times according to the Import Map
Editor, yet it cannot assign this transaction to the correct expense
account.  There are several other common transactions at certain businesses
that do not get assigned even though they have appeared many times.  It
used to work better in the old version that was in the 2.6.x releases. Is
this a bug?

-- 
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] Possible to display two account registers on

[David Carlson]

The Windows  menu choice is just to the left of the Help menu choice.
There are two choices in the drop down,  New Window and New Window with
Page.  I just tried the first choice and I got a blank window with one menu
choice Close the Currently Active Page, which is literally not doing
anything.  According to Htop GnuCaash is process #3918 and it has 31% of
RAM but 0 % of CPU right now.  It has been a couple of minutes now.   Htop
can distinguish 8 individual threads in the GnuCash process.  The main one
has used 1.38.30 clock time and it is getting a few CPU cycles.  None of
the other threads seem to be getting any additional time.   How long should
I wait?

On Fri, Feb 4, 2022 at 6:40 PM Art Chimes  wrote:

> I don't understand the "with Page" phrase. What does that mean?
>
> The suggestion of changing the default behavior to ALWAYS open a new
> window would seem to result in quite a bit of desktop clutter, at
> least for me. In nearly all cases in the three years I've been using
> Gnucash, having all accounts open in one window is definitely
> preferable, but good to know it's an option for those who need/want
> it.
>
> On Fri, Feb 4, 2022 at 4:26 PM Ken Pyzik  wrote:
> >
> > Using windows 11 (and probably 10) ver. 4.9, in the top menu there is an
> menu called WINDOWS.  If you click on that menu and click the New Window
> with page option -- you will get two windows for the same account.  This
> will get you the desired results I believe you want.
> >
> > Cheers!  -- Ken
> >
> > -Original Message-
> > From: gnucash-user 
> On Behalf Of Stan Brown
> > Sent: Friday, February 4, 2022 12:18 PM
> > To: 'gnucash-user' 
> > Cc: Kalpesh Patel 
> > Subject: Re: [GNC] Possible to display two account registers on
> >
> >
> > On 2022-02-04 10:29, Kalpesh Patel wrote:
> > > In Windows 10 (and probably all other host OSes?), if you double click
> > > on any account in the Accounts Page window (windows  that opens when
> > > GNC is launched) then it will open a new floating window for that
> > > specific account
> >
> > That may have been added in a later GC version, but for me when I
> double-click on an account in the Accounts page that account's register
> opens in a new tab in the same window as the Accounts page. I don't find
> any selection for that behavior in Preferences.
> >
> > Yes, I'm running GC in Windows 10.
> >
> > --
> > Stan Brown
> > Tehachapi, CA, USA
> > https://BrownMath.com
> > ___
> > gnucash-user mailing list
> > gnucash-user@gnucash.org
> > To update your subscription preferences or to unsubscribe:
> > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> > -
> > Please remember to CC this list on all your replies.
> > You can do this by using Reply-To-List or Reply-All.
> > ___
> > 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] Possible to display two account registers on

[David Carlson]

Geoff,  Thank you for that suggestion,  That seems to have unlocked it.
There are some oddities jumping from one window to the other, but I could
close the second window.

On Fri, Feb 4, 2022 at 11:30 PM Geoff  wrote:

> Hi David
>
>  From your new "blank" window, use the toolbar menu and choose:
>View / New Accounts Page
> This should open the main "Chart of Accounts" page in your new window,
> and then you can proceed as usual.
>
> IMHO this should be the default whenever you choose Window / New Window.
>
> Hope this helps.
>
> Regards
>
> Geoff
> =
>
> On 5/02/2022 1:38 pm, David Carlson wrote:
> > The Windows  menu choice is just to the left of the Help menu choice.
> > There are two choices in the drop down,  New Window and New Window with
> > Page.  I just tried the first choice and I got a blank window with one
> menu
> > choice Close the Currently Active Page, which is literally not doing
> > anything.  According to Htop GnuCaash is process #3918 and it has 31% of
> > RAM but 0 % of CPU right now.  It has been a couple of minutes now.
>  Htop
> > can distinguish 8 individual threads in the GnuCash process.  The main
> one
> > has used 1.38.30 clock time and it is getting a few CPU cycles.  None of
> > the other threads seem to be getting any additional time.   How long
> should
> > I wait?
> >
> > On Fri, Feb 4, 2022 at 6:40 PM Art Chimes  wrote:
> >
> >> I don't understand the "with Page" phrase. What does that mean?
> >>
> >> The suggestion of changing the default behavior to ALWAYS open a new
> >> window would seem to result in quite a bit of desktop clutter, at
> >> least for me. In nearly all cases in the three years I've been using
> >> Gnucash, having all accounts open in one window is definitely
> >> preferable, but good to know it's an option for those who need/want
> >> it.
> >>
> >> On Fri, Feb 4, 2022 at 4:26 PM Ken Pyzik  wrote:
> >>>
> >>> Using windows 11 (and probably 10) ver. 4.9, in the top menu there is
> an
> >> menu called WINDOWS.  If you click on that menu and click the New Window
> >> with page option -- you will get two windows for the same account.  This
> >> will get you the desired results I believe you want.
> >>>
> >>> Cheers!  -- Ken
> >>>
> >>> -Original Message-
> >>> From: gnucash-user  >
> >> On Behalf Of Stan Brown
> >>> Sent: Friday, February 4, 2022 12:18 PM
> >>> To: 'gnucash-user' 
> >>> Cc: Kalpesh Patel 
> >>> Subject: Re: [GNC] Possible to display two account registers on
> >>>
> >>>
> >>> On 2022-02-04 10:29, Kalpesh Patel wrote:
> >>>> In Windows 10 (and probably all other host OSes?), if you double click
> >>>> on any account in the Accounts Page window (windows  that opens when
> >>>> GNC is launched) then it will open a new floating window for that
> >>>> specific account
> >>>
> >>> That may have been added in a later GC version, but for me when I
> >> double-click on an account in the Accounts page that account's register
> >> opens in a new tab in the same window as the Accounts page. I don't find
> >> any selection for that behavior in Preferences.
> >>>
> >>> Yes, I'm running GC in Windows 10.
> >>>
> >>> --
> >>> Stan Brown
> >>> Tehachapi, CA, USA
> >>> https://BrownMath.com
> >>> ___
> >>> gnucash-user mailing list
> >>> gnucash-user@gnucash.org
> >>> To update your subscription preferences or to unsubscribe:
> >>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> >>> If you are using Nabble or Gmane, please see
> >> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> >>> -
> >>> Please remember to CC this list on all your replies.
> >>> You can do this by using Reply-To-List or Reply-All.
> >>> ___
> >>> 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.
> >>

Re: [GNC] Help with reconcile menu

[David Carlson]

Martin,  as. David pointed out,  it counts every reconciled transaction,
including future transactions.   Perhaps there is a future reconcile d
transaction.



On Sat, Feb 5, 2022, 11:53 AM D via gnucash-user 
wrote:

> The opening balance tallies every transaction that was previously
> reconciled, regardless of date. The Guide notes that the starting balance
> is less important than the closing balance. If the closing balance is
> correct, proceed with your reconciliation and finish when the difference is
> zero.
>
> On Feb 5, 2022, 11:41, at 11:41, Martin Dupras 
> wrote:
> >Hi,
> >
> >I'm still relatively new to GnuCash, so I may be misunderstanding
> >something.
> >
> >I have an account for which I have entered several years of
> >transactions
> >(not as they happening, as an exercise to look at my expenses for the
> >last
> >three years.)
> >
> >All of the transaction amounts on the account are correct; but
> >somewhere
> >along the way something happened which broke the reconciliation. What
> >seems
> >to happen is that whenever I try to reconcile, the ending balance is
> >correct, but the opening balance is wrong.
> >
> >The opening balance on the account is right, and it's the first
> >transaction
> >for the account. Yet, when I try to reconcile it, the dialogue window
> >shows
> >"Starting Balance: £1000.00".
> >
> >I can't see an invisible transaction anywhere (all boxes ticked in the
> >"status" tab of "Sort By").
> >
> >Can anyone clarify how GnuCash figures out this £1000? If I knew where
> >to
> >look, I might be able to fix it.
> >
> >Thanks!
> >
> >- martin
> >___
> >gnucash-user mailing list
> >gnucash-user@gnucash.org
> >To update your subscription preferences or to unsubscribe:
> >https://lists.gnucash.org/mailman/listinfo/gnucash-user
> >If you are using Nabble or Gmane, please see
> >https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> >-
> >Please remember to CC this list on all your replies.
> >You can do this by using Reply-To-List or Reply-All.
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Accounts out of order

[David Carlson]

In older versions of GnuCash you could click or double click [I forgot
which] on almost any column head and the window sorted alphabetical ly or
reverse alphabetical ly.  Has that changed ?  Also, in the COA there was a
column for account numbers which could be used for sorting.



On Wed, Feb 9, 2022, 12:10 PM Bruce Irving  wrote:

> I learned accounting BC (Before Computer).
> By prefixing the account Name with the pcode sorted as I was used to.
> Unfortunately, they are no longer in order.  And the Account Summary Report
> is in a different order!
> Is it possible to get these back to alphanumeric order?
> I'm using Build ID: Flathub 4.9-2
>
> Bruce
> ___
> 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] Question about stock entry

[David Carlson]

As Fred hinted, the Account type box where you need to select security (in
English?) is on the lower left, not near the top or right where you might
expect to see it.

On Wed, Feb 9, 2022 at 4:26 PM Fred Bone  wrote:

> On 09 February 2022 at 20:47, Κωνσταντίνος said:
>
> > And how i can set it in stock?
>
> The "Account Type" dropdown is at the bottom left of the "New Account"
> window, which I think is the one you showed (part of) in your original
> message. You will probably need to scroll down to find the entry for
> "Stock". You need to do this before clicking "Select", and then you will
> get a "Select security" window instead of "Select currency".
>
> Sorry for not making this clear earlier: I thought it was mentioned in
> the documentation.
>
> ___
> 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] Question about stock entry

[David Carlson]

 Κωνσταντίνος,
you are not the first to have this trouble.  See
https://bugs.gnucash.org/show_bug.cgi?id=769256.

On Wed, Feb 9, 2022 at 5:18 PM Κωνσταντίνος  wrote:

> Yeah, i found it and it works!
> I misunderstood that this option (and the option next to it) was by
> default the same with the account's option you choose to do the new account
> action.
> And the guide mentions it clearly, but i thought that was been selected by
> default.
>
> Maybe i read to much for one day...
>
> Really thank you all of you guys, for the help, quick reaction and the
> friendly atmosphere!
>
> Have a great day!
>
> 10 Φεβ 2022 01:02:20 David Carlson :
>
> As Fred hinted, the Account type box where you need to select security (in
> English?) is on the lower left, not near the top or right where you might
> expect to see it.
>
> On Wed, Feb 9, 2022 at 4:26 PM Fred Bone  wrote:
>
>> On 09 February 2022 at 20:47, Κωνσταντίνος said:
>>
>> > And how i can set it in stock?
>>
>> The "Account Type" dropdown is at the bottom left of the "New Account"
>> window, which I think is the one you showed (part of) in your original
>> message. You will probably need to scroll down to find the entry for
>> "Stock". You need to do this before clicking "Select", and then you will
>> get a "Select security" window instead of "Select currency".
>>
>> Sorry for not making this clear earlier: I thought it was mentioned in
>> the documentation.
>>
>> ___
>> 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
>
>

-- 
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] Download GnuCash issue

[David Carlson]

That sounds like you are trying to drive a Tesla on a cow path.  Why try?

On Sat, Feb 12, 2022 at 7:37 AM  wrote:

> Hi, I downloaded the latest version of GnuCash  (4.9) onto an older laptop
> running Windows 8.1 , but when I tried to run the setup got a message that
> it could not run on this machine. Same thing with an older version of
> GnuCash. I have about 11 GB of disk space remaining on this machine. What
> could be the issue?
>
> Thanks
>
> David Long
>
> ___
> 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] Download GnuCash issue

[David Carlson]

If Windows 8.1 is a 32 bit OS there could be file size issues, as it could
only look at 2 gig spaces

On Sat, Feb 12, 2022 at 10:33 AM john  wrote:

> No, GnuCash is built for 32-bit on Windows so that it will work on older
> machines.
>
> Regards,
> John Ralls
>
>
> > On Feb 12, 2022, at 8:13 AM, Jon Schewe  wrote:
> >
> > Maybe that's all that is available.
> > Can you post the specific text of the dialog here? That may help in
> > determining what the issue is.
> > GnuCash does say it supports Windows 8. One possibility is that GnuCash
> > is built as a 64-bit application and you have a 32-bit version of
> > Windows. You can follow the instructions here to verify if you have a
> > 32-bit or 64-bit version of Windows
> >
> https://softwaregroup.zendesk.com/hc/en-us/articles/115012567728-How-to-check-if-Windows-8-and-8-1-is-32-bit-or-64-bit
> > I'm not sure if GnuCash for Windows is built as 64-bit only. Can
> > someone using Windows confirm this?
> >
> >
> > On Sat, 2022-02-12 at 10:01 -0600, David Carlson wrote:
> >> That sounds like you are trying to drive a Tesla on a cow path.  Why
> >> try?
> >> On Sat, Feb 12, 2022 at 7:37 AM  wrote:
> >>> Hi, I downloaded the latest version of GnuCash  (4.9) onto an older
> >>> laptoprunning Windows 8.1 , but when I tried to run the setup got a
> >>> message thatit could not run on this machine. Same thing with an
> >>> older version ofGnuCash. I have about 11 GB of disk space remaining
> >>> on this machine. Whatcould be the issue?
> >>> Thanks
> >>> David Long
> >>> ___gnucash-user mailing
> >>> listgnucash-u...@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] reconciling specific credit cards in an account

[David Carlson]

If the OP "scum buster" does not track the details in the credit cards at
all, only the monthly payments from the bank account to the credit cards,
then he may not even be tracking them as individual liability accounts.
Perhaps they are just expense accounts.  My sister does it that way, it
works for her.

In that case the payments could very well look too similar in the bank
account download even for the bayesian matching algorithm to assign them
correctly.  In my personal experience, GnuCash is always confusing
restaurant and gasoline purchases even when many are at the same few
merchants.  While I could suggest manually tracking by date and amount even
to the point of managing the payments to different cards to always be for
different amounts, GnuCash may still not be able to automatically assign
them correctly.  Then the user simply has to develop a procedure to
individually inspect each transaction carefully during the matching step of
the import to be sure that it is correctly assigned.  Again, from my own
experience, for one bank account I actually print out the register from the
online banking page in order to see every word in each transaction item
before I import it to GnuCash.  Sometimes I even markup that printout to be
sure I can import it correctly.  Can't do that on a computer screen,
[unless I use dry erase markers].

As for manually entering every transaction, few of us have time for that.
We mostly just scan the printout for items that look suspicious, like that
purchase of a computer and TV in Florida when we were not there or a string
of several out-of-town or online purchases on the same day.

On Wed, Feb 16, 2022 at 8:28 PM Adrien Monteleone <
adrien.montele...@lusfiber.net> wrote:

> If you have multiple cards from the same bank, you'll need to
> differentiate them in GnuCash somehow. Some people use the last digits,
> some the card 'brand' which can be different, even from the same bank.
> (not just card 'type' though that may be sufficient)
>
> Your Bank *might* offer you the ability to tag or nickname your
> transactions before import. Your Card company might offer the same,
> though more than likely, you'll have to do that well in advance of the
> transaction going through for such info to be sent to the bank.
>
> Another option would be to manually edit the import file, appending your
> differentiation prior to import.
>
> -
>
> As for the 'right way', I'd say the 'best way' is to always enter all of
> your transactions by hand. Importing should be part of the 'clearing'
> process prior to reconciliation.
>
> Clear (and if possible Reconcile) the Card accounts first, then do
> Checking.
>
> Reconciliation is making sure your books agree with your institution's
> version of your account(s). There's little point if all you are doing is
> importing their version anyway.
>
> Regards,
> Adrien
>
> On 2/16/22 7:02 PM, scum buster wrote:
> > I have been using Gnucash for years..currently version 3.7.  I very
> much
> > appreciate the program.I used quicken for years til I started using
> > Gnucash.
> >
> > Have never used this forum before, so I hope I don't screw this up. LOL
> >
> > I am not a Gnucash expertI know I do some things wrong but I get
> by
> >
> > One thing I always seem to have issues with (I am sure it is user
> > error).is with my checking account and credit card charges that come
> > through that account
> >
> > I download my checking account data as a quicken file and "import" that.
> >
> > I have a few credit cards with one company.  The charges come through as
> "
> > bankname online payment" when they hit my checking account.
> >
> > That would be fine if I had only one credit card with that bank.
> >
> > But with a few different cards, I have issues trying to get them to
> > auto-reconcile correctly and end up having to manually add the items and
> > manually pick the right account..and that ends up making duplicate
> > charges somehow.
> >
> > What is the right way to set things up so that Gnucash knows what credit
> > card account is being referenced when the charges hit my checking
> account?
>
> ___
> 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

Re: [GNC] Stock Merger

[David Carlson]

You are very close!  Yes, you do need to create a new security and security
account under your broker account for AMD first.  Then you could re enter
or possibly just edit your split transaction to output in AMD instead of
XLNX.

On Wed, Feb 16, 2022 at 10:31 PM Al  wrote:

> I'm having trouble getting my head around setting up a stock merger. The
> merger in question is the recent Xilinx AMD merger.
>
> Pre-merger I held 800 shares of XLNX. After the merger I have received
> 1.7234 shares of AMD for each XLNX share (1378.72 shares). I received
> $85.65 "Cash in Lieu" for the .72 shares leaving a total of 1378 shares.
>
> Using the Gnucash Stock Split Assistant to the best of my abilities
> results in me now having 1378 shares of XLNX along with the $85.65
> correctly added to the cash account at my brokerage.
>
> So how does XLNX become AMD? Am I supposed to create a new AMD entry and
> transfer the shares somehow? Or maybe just change the name and ticker
> symbol?
>
> Any help greatly appreciated!
>
> Al
> ___
> 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] Selecting older transactions to unreconcile

[David Carlson]

It is very easy to adjust the register display settings to show only
reconciled or unreconciled transactions dated  within a certain range.
That should help.

On Thu, Feb 17, 2022, 9:02 AM Mahon Finbar  wrote:

> True, but since I don't know where the error is, I thought of doing it
> per month, and that way finding it.
>
> That is why I need to find a way to display the reconciled transactions
> on a month by month basis.
>
>
> It is usually a transaction in the wrong column.
>
>
> Thanks Barry
>
>
> On 16/02/2022 17:54, Gyle McCollam wrote:
> > If you only have a few errors, it would be easier to just Click on the
> > "y" in the reconciled column of the transaction in the appropriate
> > account and select unreconcile.
> >
> > Thank You,
> > *Gyle McCollam*
> >
> > Gyle McCollam
> >
> > 609.680.2326Mobile
> >
> > gmccol...@live.com email
> >
> > 
> > *From:* gnucash-user
> >  on behalf of Mahon
> > Finbar 
> > *Sent:* Wednesday, February 16, 2022 9:05 AM
> > *To:* Gnucash Users 
> > *Subject:* [GNC] Selecting older transactions to unreconcile
> > End of year issue.
> >
> > I have reconciled most of 2021 but inevitably I have subsequently found
> > a few errors.
> >
> > So, I want to select a reconcile date and then "unreconcile" some
> > transactions.
> >
> > I assumed using the suggested ctrl-A and spacebar technique would enable
> > me to do it using a date I specified for the reconciliation, but the
> > reconcile window only shows the latest unreconiled data.
> >
> > Is there a technique for arriving at the data set for a specific
> > reconcile date?
> >
> > Tnks
> >
> > ___
> > gnucash-user mailing list
> > gnucash-user@gnucash.org
> > To update your subscription preferences or to unsubscribe:
> > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > If you are using Nabble or Gmane, please see
> > https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> > -
> > Please remember to CC this list on all your replies.
> > You can do this by using Reply-To-List or Reply-All.
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Potential Computational Errors

[David Carlson]

It would also help to explain how to reproduce the problem and what to look
for.

On Thu, Feb 17, 2022, 9:16 AM Derek Atkins  wrote:

> HI,
>
> On Thu, February 17, 2022 9:08 am, Gao Bite wrote:
> > GnuCash Developers & Maintainers:
> >
> >  Hello! I have recently found a mismatch computation result from
> > your software.
> >
> > It may be a computational mistake, or a special accounting standard. I
> > would like to know
> >
> > whether it is.
> >
> >
> >  Yours,
> >
> >  Bite Gao
> >
> > Feb 17th, 2021
> >
> > Attachment:
> >
> > Image which describes potential error:
> >
>
> This list scraps all HTML and embedded images.  You need to attach them to
> get them through the list.  As a result, we cannot see what potential
> computation error you seem to be seeing.
>
> > Please remember to CC this list on all your replies.
> > You can do this by using Reply-To-List or Reply-All.
>
> -derek
>
> --
>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] reconciling specific credit cards in an account

[David Carlson]

I bet it is one of those banks that begins with the letter 'C'.  I have
that problem too.  I have to rely on timing and amount to differentiate,
and GnuCash is not good with using amounts to differentiate.

On Fri, Feb 18, 2022 at 9:30 AM scum buster  wrote:

> Hi
>
> Thanks for the reply.
>
> No, I don't use debit cards.
>
> The issue is that one bank services a few of my credit cards.   And the
> downloads show them all the same ---  "bankname online payment" with no
> differentiation of what specific credit card account that line item is for.
>
> Gnucash doesn't show any other info than that upon reconciling, probably
> because the bank doesn't provide it.
>
> My only other solution would be to have only one credit card per bank
> name...then it's a no brainer which credit card account goes with what.
>
> But that's not practical for me.
>
>
> -Original Message-
> From: John Layman [mailto:john.lay...@laymanandlayman.com]
> Sent: Thursday, February 17, 2022 12:56 PM
> To: 'scum buster'; gnucash-user@gnucash.org
> Subject: RE: [GNC] reconciling specific credit cards in an account
>
> Sounds like you are confusing your bank account debit card with a credit
> card.  They may look the same, but the debit card will directly draw funds
> from the checking account.  If you are having to enter a PIN number when
> you
> use that card, it's almost certainly a debit card.
>
> -Original Message-
> From: gnucash-user 
> On Behalf Of scum buster
> Sent: Wednesday, February 16, 2022 8:03 PM
> To: gnucash-user@gnucash.org
> Subject: Re: [GNC] reconciling specific credit cards in an account
>
> I have been using Gnucash for years..currently version 3.7.  I very
> much
> appreciate the program.I used quicken for years til I started using
> Gnucash.
>
> Have never used this forum before, so I hope I don't screw this up. LOL
>
> I am not a Gnucash expertI know I do some things wrong but I get by
>
> One thing I always seem to have issues with (I am sure it is user
> error).is with my checking account and credit card charges that come
> through that account
>
> I download my checking account data as a quicken file and "import" that.
>
> I have a few credit cards with one company.  The charges come through as "
> bankname online payment" when they hit my checking account.
>
> That would be fine if I had only one credit card with that bank.
>
> But with a few different cards, I have issues trying to get them to
> auto-reconcile correctly and end up having to manually add the items and
> manually pick the right account..and that ends up making duplicate
> charges somehow.
>
> What is the right way to set things up so that Gnucash knows what credit
> card account is being referenced when the charges hit my checking account?
>
> Thanks for your help!
>
>
> -Original Message-
> From: gnucash-user
> [mailto:gnucash-user-bounces+scumbuster=comcast@gnucash.org] On Behalf
> Of gnucash-user-requ...@gnucash.org
> Sent: Wednesday, February 16, 2022 12:00 PM
> To: gnucash-user@gnucash.org
> Subject: gnucash-user Digest, Vol 227, Issue 32
>
> Send gnucash-user mailing list submissions to
> gnucash-user@gnucash.org
>
> To subscribe or unsubscribe via the World Wide Web, visit
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> or, via email, send a message with subject or body 'help' to
> gnucash-user-requ...@gnucash.org
>
> You can reach the person managing the list at
> gnucash-user-ow...@gnucash.org
>
> When replying, please edit your Subject line so it is more specific than
> "Re: Contents of gnucash-user digest..."
>
>
> --
> 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 f

Re: [GNC] Automatic sales tax

[David Carlson]

Here in Illinois it varies by county, city, merchandise category, service
category, seller category and sometimes by such arcane variables as library
district (well, that last one may be a slight exaggeration).

On Sun, Feb 20, 2022, 6:33 PM Michael or Penny Novack <
stepbystepf...@comcast.net> wrote:

> On 2/20/2022 4:33 PM, Don Robertson wrote:
> > Seems most other software will do this - Xero, MYOB etc. For open
> > source fans, Kmymoney seems pretty good.
> >
> > And before you start mailing me personally, if you don't want to hear
> > what people think of your software, perhaps you should consider
> > removing this from all your posts:
>
> Correctly? I doubt that ANY software does sales tax absolutely correctly.
>
> Here in the US the issue is sales tax which varies by state (both rate
> and what tax is or is not applied to).  For internet sales, that would
> be the state of the location where delivery is to be made.
>
> Well ..has any vendor with whom you have done business ever
> collected that information? Yes of course, asked for you address, but
> did the vendor ALSO ask you "what state is that address in?". I rather
> suspect most vendors as well as most writers of the relevant software
> are aware of the fact that postal address (mail delivery) does NOT
> respect state boundaries and so the "tax state" of all addresses located
> close to a state boundary are suspect (might be different than the PO
> state).
>
> To be absolutely correct, would need to collect that information from
> the customer OR use mapping databases to locate the (physical) address
> and see what state that was in.
>
> Michael D Novack
>
> PS -- My working days was doing software for a life insurance company.
> We DID collect "contract state" for the policy record because could make
> a very big difference which state's laws would apply.
>
>
> ___
> 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] Can't play log files

[David Carlson]

The data file is the comparatively large file ending in [dot]gnucash,
assuming you are not using one of the database formats.

I can't see the rest of your question as I am on my smartphone.

On Sun, Feb 20, 2022, 7:27 PM Stan Brown  wrote:

>
> On 2022-02-20 12:39, Donald R Slaughter via gnucash-user wrote:
> >
> > I changed my laptop from Linux to Windows and reinstalled GnuCash.
> > I am unable to import and play my log files. I saved them on my Mac
> computer’s external hard drive (formatted Ex-Fat).  It looks like I will
> have to start from scratch and rebuild my  Bookkeeping system unless I can
> learn what I am doing wrong.
>
> Why do you need to import your log files? Your data file should have
> everything in it.
>
> --
> Stan Brown
> Tehachapi, CA, USA
> https://BrownMath.com
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
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] Directly posting payments

[David Carlson]

Do you intend to use GnuCash for personal finances or business use?  If for
personal use, don't bother with those business features.

On Mon, Feb 21, 2022 at 4:10 PM  wrote:

> I am a newbie on GnuCash, currently running it side-by-side with my
> previous software which I can't install on Win10 without a very expensive
> upgrade [currently logging into my old Win7 machine using Remote Desktop
> but old machine is becoming unreliable].
>
> In my old software, I could directly post incidental payments without
> first creating an invoice. In GnuCash, it appears I need to create an
> invoice prior to posting a payment. For a simple transaction like a store
> or restaurant purchase, this seems somewhat cumbersome.
>
> I can create the transaction directly in the General Journal; however,
> then I don't have a vendor summary.
>
> What am I overlooking?
>
> Regards,
>
> Jim
>
> James E. Gochnauer
> Independent Claims Adjuster
> Licensed/bonded/Xactimate certified
> 132 Cleveland St. Flr 1
> Brooklyn, NY  11208
> CELL & TXT:  646-465-4800
> j...@paradisepro.com
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>


-- 
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] (no subject)

[David Carlson]

Mario,

The GnuCash developers are not keeping any secrets about where your data is
stored.   If you read your help manual and refer to the very detailed FAQ
on the website you will find out that GnuCash stores some "user" type
information in a location separate from your data.

Your custom report settings and other settings that could apply to multiple
data sets if you have any  and seldom change after you set them up are
included.

It is not a secret location known only to Linus Pauling and a few of his
friends.

Over the years the details have evolved and they vary depending on the
operating system environment and GnuCash release schedule.

There are instructions on what is stored,  where it is stored and how to
back it up.

There are also instructions for migrating the settings from one OS to
another  should you ever need them.

I don't think they suggest a specific backup schedule,  but if you rarely
change your saved report settings,  then once a month would probably work
fine.  For me, twice a year and after I change my datakeeping habits is
fine.

On Tue, Feb 22, 2022, 12:32 PM Steve Butler  wrote:

> Please plan a compressive backup strategy for your entire system.  Include
> email, Libre Office documents, other misc files and not just GnuCash.
>
> That way it won't matter where files are "hidden" as you will have a
> complete backup strategy that isn't specific to any particular application.
>
> On Tue, Feb 22, 2022, 09:51 Mario Nigrovic  wrote:
>
> > Many years ago, I had used gnucash, and was pretty happy with it. I was
> > very careful to make regular backups of my data, and so, when my disk
> > inevitably crashed, I was not too worried. However, I was mortified to
> > discover that, although all my transaction data had been saved, all my
> > custom reports were lost, as they had been stored separately in a secret
> > undisclosed location, I later discovered to be elsewhere in my home
> > directory.
> >
> > Recently, I have decided to try again to use gnucash, but I would like
> very
> > much to ensure ALL my data is backed up. So I hit upon the idea of
> running
> > the tool under a custom value of $HOME, but I was then shocked to
> discover
> > that even with this method, gnucash was able to remember previous
> locations
> > of my database file, which suggests that the tool is also using some kind
> > of other mechanism to save historical data, and that makes me very
> nervous
> > about actually being able to do proper backups of everything related to
> the
> > tool.
> > Doing some sleuthing using strace, I was able to find the previous
> database
> > location delivered through some socket connection, and that really scares
> > me, since it is now possible critical data is stored via some other Linux
> > service and I will have no way to trace out where this may be to avoid
> > future nasty surprises.
> > I have not seen any documentation about backup strategies other than the
> > aromatic saving of previous data files, yet I do see that there was data
> > being stored at least in ~/.local, so I'm hoping someone on this list may
> > be able to point me to some more thorough discussion of ALL the places
> user
> > data from gnucash may be stored.
> > Thanks for your help!
> >
> > -- Mario
> >
> > -- Mario
> > ___
> > gnucash-user mailing list
> > gnucash-user@gnucash.org
> > To update your subscription preferences or to unsubscribe:
> > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > If you are using Nabble or Gmane, please see
> > https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> > -
> > Please remember to CC this list on all your replies.
> > You can do this by using Reply-To-List or Reply-All.
> >
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Linus Pauling's friends

[David Carlson]

That shows my age.  Linus Pauling was imprinted into my brain in the 1960's.

On Tue, Feb 22, 2022 at 4:22 PM Geoff  wrote:

> Good one David, you have made my day! I am nominating you for the Answer
> of the Month Award.
>
> ;--))
>
> Geoff
> =
> P.S. Is it true that Linus Torvalds was one of Linus Pauling's friends too?
>
> On 23/02/2022 6:50 am, David Carlson wrote:
> >
> > It is not a secret location known only to Linus Pauling and a few of his
> > friends.
> >
>
> >>> much to ensure ALL my data is backed up. So I hit upon the idea of
> >> running
> >>> the tool under a custom value of $HOME, but I was then shocked to
> >> discover
> >>> that even with this method, gnucash was able to remember previous
> >> locations
> >>> of my database file, which suggests that the tool is also using some
> kind
> >>> of other mechanism to save historical data, and that makes me very
> >> nervous
> >>> about actually being able to do proper backups of everything related to
> >> the
> >>> tool.
> >>> Doing some sleuthing using strace, I was able to find the previous
> >> database
> >>> location delivered through some socket connection, and that really
> scares
> >>> me, since it is now possible critical data is stored via some other
> Linux
> >>> service and I will have no way to trace out where this may be to avoid
> >>> future nasty surprises.
> >>> I have not seen any documentation about backup strategies other than
> the
> >>> aromatic saving of previous data files, yet I do see that there was
> data
> >>> being stored at least in ~/.local, so I'm hoping someone on this list
> may
> >>> be able to point me to some more thorough discussion of ALL the places
> >> user
> >>> data from gnucash may be stored.
>


-- 
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] reconcile problem?

[David Carlson]

ap digits, which causes the
> >>> result to be off.
> >>> Every once in a while I have to cancel the reconcile and start over and
> >>> CAREFULLY watch the numbers to find where I entered something
> >>> incorrectly.
> >>>
> >>> If you find you're off, then check again -- most likely something was
> >>> entered wrong.  Either that or you modified an existing, reconciled
> >>> transaction (from the other side) which caused a break in that starting
> >>> balance.
> >>>
> >>>> Ideas?
> >>>>
> >>>> TIA!
> >>>> Please remember to CC this list on all your replies.
> >>>> You can do this by using Reply-To-List or Reply-All.
> >>> -derek
> >>>
> >> ___
> >> 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] Report question

[David Carlson]

That procedure generates a mess, in my opinion.  Wouldn't it be simpler to
just run a register report?

On Thu, Feb 24, 2022 at 12:57 PM Paul Kinzelman  wrote:

> If I do a Search for the transactions I want, and then Export
> Active Register, I can look at the CSV in a spreadsheet, but
> both accounts of the transaction appear in the same column
> so the sum of the amount column is always zero.
>
> How do I export just one account's amount of each transaction
> without the other side of the transaction being there so that
> the sum of the column actually represents the sum of the
> expenses of that Search?
>
> TIA!
>
>
>
>
> ___
> 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] reconcile problem?

[David Carlson]

That came up in another thread a couple of weeks ago.  As far as I know,
the only solution is to be very careful in the matching step of the import.
  You can help yourself when making the payments to be sure they have
different dates or amounts, or even paying out of different checking
accounts.

On Fri, Feb 25, 2022 at 8:11 AM scum buster  wrote:

> Sidebar question --- do any of you have more than one credit card with the
> same bank?   That is where I am running into issues when I import and
> "clear" (I have always called this "reconciling" but I guess there is a
> difference?)
>
> The bank just has a line item "bankname payment"  , same for each card
> account.
>
> That is where I run into issues trying to manually "clear" and that throws
> my account balances in GC off
>
> -Original Message-
> From: Adrien Monteleone [mailto:adrien.montele...@lusfiber.net]
> Sent: Wednesday, February 23, 2022 2:15 PM
> To: gnucash-u...@lists.gnucash.org
> Subject: Re: [GNC] reconcile problem?
>
> Transactions won't reconcile themselves, but you can clear them either
> manually or via an import.
>
> If you opened a backup by mistake, that would result in something
> showing 'unreconciled' if the backup was before the reconciliation.
>
> The only way to get the 'y' to appear in the register is through a
> reconciliation. Which means you in fact checked it off a previous time.
>
> You can re-do a reconciliation by changing all of the affected
> transactions back to 'n' or 'c', and then trying again. Be sure to
> remove any adjusting transactions you made during the last
> reconciliation. You probably don't need them. (but can always re-create
> if you do)
>
> Then proceed with this months reconciliation.
>
> In the future, if you ever notice transactions appearing 'c' or 'n' when
> you know they should be 'y' means you've edited them in a manner that
> will change the flag. (either in that register or one connected to the
> transaction)
>
> If you don't get warnings about this, go to Actions > Reset Warnings...
> and adjust as needed.
>
> When you edit a transaction and the flag changes (or you discover it
> later) simply re-reconcile and clear the affected transaction(s). (and
> if you are editing amounts, double check you didn't make an adjusting
> entry, because again, you might no longer need it!)
>
> Regards,
> Adrien
>
> On 2/23/22 9:33 AM, Paul Kinzelman wrote:
> > That's a good question and I think that could be an explanation
> > for the resurrection of the reconciled transactions which happened
> > quite awhile ago when I was new to GC.
> >
> > But that doesn't explain how a transaction could become
> > reconciled on its own like the one that happened this month, which
> > tipped me over the edge to post about it.
>
>
>
>
> --
> 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.
>


-- 
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] Profit & Retained Earning don't match

[David Carlson]

I can't check right now but I think there is an enhancement request to show
in a printable form all the settings for a given report.

On Fri, Feb 25, 2022, 3:57 PM Derek Atkins  wrote:

> HI,
>
> On Fri, February 25, 2022 4:49 pm, Stan Brown wrote:
> >
> > On 2022-02-25 13:14, Derek Atkins wrote:
> >> For example, if you ran the report, then added an account, that new
> >> account would not be included by default in the report if you refresh
> >> it.
> >> You need to manually add the new account into the report.
> >>
> >> This also applies to saved reports.
> >
> > Wow -- I did not know this, but it explains why my balance sheet and
> > income statement sometimes miss accounts. (With the income statement in
> > particular, I run it only at the end of the year, so any accounts could
> > have been added almost a whole year ago, and I wouldn't remember when I
> > added them.)
> >
> > I select accounts for my saved reports in what seems like a sensible
> > way: all Income And Expense accounts for the income statement, and all
> > Assets, Liabilities, and Equities for the balance sheet.
> >
> > I don't know how hard this would be to do, but it would be nice if GC
> > would keep track in a saved report of how accounts were selected. If the
> > selection was by a hierarchy rather than individual accounts, GC could
> > then automatically include all accounts within that hierarchy when
> > running the saved report.
>
> Yeah, sorry -- that's not how it works.  It honestly doesn't know anything
> about "accounts" per se, let along hierachies.  It just knows "Object
> GUIDs".
>
> The good news is that it's only a few clicks to get "all accounts" added.
>
> But yeah, if you save a report, or have a report "open", it wont learn
> about new accounts.
>
> This has been the case since, oh... 2003?  2005?  Something like that.
>
> > Please remember to CC this list on all your replies.
> > You can do this by using Reply-To-List or Reply-All.
>
> -derek
>
> --
>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] Automatic sales tax

[David Carlson]

At least you have the best opera house on the planet.

On Mon, Feb 28, 2022 at 5:28 PM Liz  wrote:

> On Mon, 28 Feb 2022 06:58:08 -0800
> Stan Brown  wrote:
>
> > On 2022-02-28 06:34, Michael or Penny Novack wrote:
> > > But if not a remote sale, if person living in state A buys
> > > something at a seller in state B (and state B has sales tax)
> > > collected based on that. Now the buyer might still owe sales tax to
> > > state A when bringing the whatever home.
> >
> > The tax the buyer pays to their home state after "importing" goods for
> > personal use is called use tax in every state I've lived in.
> >
> > You didn't mention the case where buyer and seller are in different
> > taxing jurisdictions within the same state. I don't know how other
> > states do it, but when you live in county C in California, go to a
> > dealer in county D in California, and buy a car, the dealer is
> > required to charge sales tax at county C's rate, not county D's.
> > Probably the same is true for boats. For smaller items, you pay at
> > the rate of the seller's county, and there's no credit if you take
> > the goods back to your home in a lower-tax county.
> >
> > > When they pay that on their state return, they can claim
> > > credit for the sales tax (if any) already paid for that thing to
> > > state B.
> >
> > Maybe. Some states don't allow it, or allow it only up to the home
> > state's tax rate.
>
> It's incredibly complex. And Australians have all been led to believe
> that we have the most complex tax system on the planet.
>
> Liz
> ___
> 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] Scheduled Transactions creating but not posting in register

[David Carlson]

The screen shot did not make it into the list, but it is normal for the
'Created' message to be greyed out because there is no way for the user to
change the status to any of the other settings once the transaction is
created.  If you really do want to change the status the only way would be
to close the data file without saving any changes at all.

I think, however, in your case you are saving the file with changes but
finding the changes missing, which is a different matter.  There is another
place to look.  If you edit the scheduled transaction it tells you the last
date for which the transaction was created.  Then look in the register and
see if it is there for that date.  If not, you have a bug for which I am no
help as I neither have a Mac nor do I use release 4.8.



On Mon, Mar 7, 2022 at 9:05 PM  wrote:

> MacOS Monterey Version 12.2.1
> Gnucash Version: Version: 4.8  Build ID: 4.8a+(2021-09-28)
>
> My scheduled transactions have suddenly stopped posting in the applicable
> registers.  The Since Last Run window shows them being created, but the
> created word is greyed, not dark.  See example below for Powder River #2
> Test created on 3/7 or ten days ahead of pay date of 3/17.
>
> Screen shot of Since Last Run showing Sched Trans was created.
>
>
>
>
> Below is the log when GnuCash was opened on 3/7 when Scheduled Transaction
> Powder River #2 Test was to be created.  Log shows nothing for transaction
> Powder River #2 Test even though Since Last Run window shows it was
> created.  The date shows but there is no name for the transaction.  The
> template rightly does not include numbers yet because there are no values
> in the template, only accounts.
>
> mod trans_guid  split_guid  time_nowdate_entered
> date_posted acc_guidacc_namenum description
>  notes   memoaction  reconciled  amount  value   date_reconciled
> -
> = START
> D   7185ad9215f74efa8db5062eef5a4bc7
> d292a5b0688446c7bbf380b7bcc2f2642022-03-07 21:29:11 2022-03-07
> 21:29:11 2022-03-07 10:59:00
>  n   0/1 0/100   1970-01-01 00:00:00
> = END
> = START
> D   e35c7289e14b46429743d3ab9bfc4007
> ec413581da974bd085e2ab1caeb739532022-03-07 21:29:11 2022-03-07
> 21:29:11 2022-03-07 10:59:00
>  n   0/1 0/100   1970-01-01 00:00:00
> = END
> = START
> D   addf95dc00a245f29f90d0b0510816f0
> 0b4cd8ef76b84ba7a30d4bd55a0fcf2d2022-03-07 21:29:11 2022-03-07
> 21:29:11 2022-03-07 10:59:00
>  n   0/1 0/100   1970-01-01 00:00:00
> = END
>
>
>
>
> The Settings are:
> GnuCash preferences: Auto-create new Transaction is checked
> Overview settings in Scheduled Transaction for this transaction are:
>
> Under Options: Enabled, create automatically, Notify me when created and
> create in advance 10 days all checked.
>
> Under Occurrences it shows last created 3/17/22 with Forever checked.
>
> 3.  Calendar in Scheduled Transactions also shows the dark blue
> indicator gone for todays transaction but shows transaction is still
> scheduled for future months.
>
> I also opened GnuCash in the Terminal hoping to see what happened when it
> opened.  Gnucash opened, but I got no output using command:
>
>  open -a Gnucash.app
>
> Is there something else I need to add to this command to get terminal
> output when opening Gnucash from Terminal?
>
> This may be something simple that I am overlooking so any help would be
> appreciated.
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>


-- 
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] Scheduled Transactions creating but not posting in register

[David Carlson]

I did forget to mention a couple of things.  If there is only a small
number of scheduled transactions being automatically created by mistake, it
would probably be easier to just delete them and edit the corresponding
SX's, which you probably would need to do anyway if that were your problem.

Secondly, when transactions are automatically created when the file is
opened but you do not want them to be created, say, when opening a very old
backup for some reason, it's possible to edit Preferences > Scheduled
Transactions > and uncheck Run when Data File Opened, then close the file
without saving.  You may find that preference stuck and the next time you
open the file, the SLR does not run.

On Mon, Mar 7, 2022 at 11:00 PM David Carlson 
wrote:

> The screen shot did not make it into the list, but it is normal for the
> 'Created' message to be greyed out because there is no way for the user to
> change the status to any of the other settings once the transaction is
> created.  If you really do want to change the status the only way would be
> to close the data file without saving any changes at all.
>
> I think, however, in your case you are saving the file with changes but
> finding the changes missing, which is a different matter.  There is another
> place to look.  If you edit the scheduled transaction it tells you the last
> date for which the transaction was created.  Then look in the register and
> see if it is there for that date.  If not, you have a bug for which I am no
> help as I neither have a Mac nor do I use release 4.8.
>
>
>
> On Mon, Mar 7, 2022 at 9:05 PM  wrote:
>
>> MacOS Monterey Version 12.2.1
>> Gnucash Version: Version: 4.8  Build ID: 4.8a+(2021-09-28)
>>
>> My scheduled transactions have suddenly stopped posting in the applicable
>> registers.  The Since Last Run window shows them being created, but the
>> created word is greyed, not dark.  See example below for Powder River #2
>> Test created on 3/7 or ten days ahead of pay date of 3/17.
>>
>> Screen shot of Since Last Run showing Sched Trans was created.
>>
>>
>>
>>
>> Below is the log when GnuCash was opened on 3/7 when Scheduled
>> Transaction Powder River #2 Test was to be created.  Log shows nothing for
>> transaction Powder River #2 Test even though Since Last Run window shows it
>> was created.  The date shows but there is no name for the transaction.  The
>> template rightly does not include numbers yet because there are no values
>> in the template, only accounts.
>>
>> mod trans_guid  split_guid  time_nowdate_entered
>> date_posted acc_guidacc_namenum description
>>  notes   memoaction  reconciled  amount  value   date_reconciled
>> -
>> = START
>> D   7185ad9215f74efa8db5062eef5a4bc7
>> d292a5b0688446c7bbf380b7bcc2f2642022-03-07 21:29:11 2022-03-07
>> 21:29:11 2022-03-07 10:59:00
>>  n   0/1 0/100   1970-01-01 00:00:00
>> = END
>> = START
>> D   e35c7289e14b46429743d3ab9bfc4007
>> ec413581da974bd085e2ab1caeb739532022-03-07 21:29:11 2022-03-07
>> 21:29:11 2022-03-07 10:59:00
>>  n   0/1 0/100   1970-01-01 00:00:00
>> = END
>> = START
>> D   addf95dc00a245f29f90d0b0510816f0
>> 0b4cd8ef76b84ba7a30d4bd55a0fcf2d2022-03-07 21:29:11 2022-03-07
>> 21:29:11 2022-03-07 10:59:00
>>  n   0/1 0/100   1970-01-01 00:00:00
>> = END
>>
>>
>>
>>
>> The Settings are:
>> GnuCash preferences: Auto-create new Transaction is checked
>> Overview settings in Scheduled Transaction for this transaction are:
>>
>> Under Options: Enabled, create automatically, Notify me when created and
>> create in advance 10 days all checked.
>>
>> Under Occurrences it shows last created 3/17/22 with Forever checked.
>>
>> 3.  Calendar in Scheduled Transactions also shows the dark blue
>> indicator gone for todays transaction but shows transaction is still
>> scheduled for future months.
>>
>> I also opened GnuCash in the Terminal hoping to see what happened when it
>> opened.  Gnucash opened, but I got no output using command:
>>
>>  open -a Gnucash.app
>>
>> Is there something else I need to add to this command to get terminal
>> output when opening Gnucash from Terminal?
>>
>> This may be something simple that I am overlooking so any help would be
>> appreciated.
>>
>> _______
>> gnucash-user m

Re: [GNC] Scheduled Transactions creating but not posting in register

[David Carlson]

I suspected as much.  I was giving a generic suggestion so others might
find it useful.  The behavior is not exactly intuitively obvious to the
most casual observer.

On Tue, Mar 8, 2022 at 12:54 PM  wrote:

> My problem is not SXs being created by mistake, it is that they are being
> shown as created (both in the SLR and SX editor last created box for the
> SX) but not being populated in the register at all.  So seems I may have a
> bug.  Appreciate the help.
>
> On Mar 7, 2022, at 22:24, David Carlson 
> wrote:
>
> I did forget to mention a couple of things.  If there is only a small
> number of scheduled transactions being automatically created by mistake, it
> would probably be easier to just delete them and edit the corresponding
> SX's, which you probably would need to do anyway if that were your problem.
>
> Secondly, when transactions are automatically created when the file is
> opened but you do not want them to be created, say, when opening a very old
> backup for some reason, it's possible to edit Preferences > Scheduled
> Transactions > and uncheck Run when Data File Opened, then close the file
> without saving.  You may find that preference stuck and the next time you
> open the file, the SLR does not run.
>
> On Mon, Mar 7, 2022 at 11:00 PM David Carlson 
> wrote:
>
>> The screen shot did not make it into the list, but it is normal for the
>> 'Created' message to be greyed out because there is no way for the user to
>> change the status to any of the other settings once the transaction is
>> created.  If you really do want to change the status the only way would be
>> to close the data file without saving any changes at all.
>>
>> I think, however, in your case you are saving the file with changes but
>> finding the changes missing, which is a different matter.  There is another
>> place to look.  If you edit the scheduled transaction it tells you the last
>> date for which the transaction was created.  Then look in the register and
>> see if it is there for that date.  If not, you have a bug for which I am no
>> help as I neither have a Mac nor do I use release 4.8.
>>
>>
>>
>> On Mon, Mar 7, 2022 at 9:05 PM  wrote:
>>
>>> MacOS Monterey Version 12.2.1
>>> Gnucash Version: Version: 4.8  Build ID: 4.8a+(2021-09-28)
>>>
>>> My scheduled transactions have suddenly stopped posting in the
>>> applicable registers.  The Since Last Run window shows them being created,
>>> but the created word is greyed, not dark.  See example below for Powder
>>> River #2 Test created on 3/7 or ten days ahead of pay date of 3/17.
>>>
>>> Screen shot of Since Last Run showing Sched Trans was created.
>>>
>>>
>>>
>>>
>>> Below is the log when GnuCash was opened on 3/7 when Scheduled
>>> Transaction Powder River #2 Test was to be created.  Log shows nothing for
>>> transaction Powder River #2 Test even though Since Last Run window shows it
>>> was created.  The date shows but there is no name for the transaction.  The
>>> template rightly does not include numbers yet because there are no values
>>> in the template, only accounts.
>>>
>>> mod trans_guid  split_guid  time_nowdate_entered
>>> date_posted acc_guidacc_namenum description
>>>  notes   memoaction  reconciled  amount  value   date_reconciled
>>> -
>>> = START
>>> D   7185ad9215f74efa8db5062eef5a4bc7
>>> d292a5b0688446c7bbf380b7bcc2f2642022-03-07 21:29:11 2022-03-07
>>> 21:29:11 2022-03-07 10:59:00
>>>  n   0/1 0/100   1970-01-01 00:00:00
>>> = END
>>> = START
>>> D   e35c7289e14b46429743d3ab9bfc4007
>>> ec413581da974bd085e2ab1caeb739532022-03-07 21:29:11 2022-03-07
>>> 21:29:11 2022-03-07 10:59:00
>>>  n   0/1 0/100   1970-01-01 00:00:00
>>> = END
>>> = START
>>> D   addf95dc00a245f29f90d0b0510816f0
>>> 0b4cd8ef76b84ba7a30d4bd55a0fcf2d2022-03-07 21:29:11 2022-03-07
>>> 21:29:11 2022-03-07 10:59:00
>>>  n   0/1 0/100   1970-01-01 00:00:00
>>> = END
>>>
>>>
>>>
>>>
>>> The Settings are:
>>> GnuCash preferences: Auto-create new Transaction is checked
>>> Overview settings in Scheduled Transaction for this transaction are:
>>>
>>> Under Options: Enabled, create automatically, Notify me when create

Re: [GNC] Is the directory .gnucash still used by v4.9?

[David Carlson]

Dean,

You will probably find the answer in here.

https://wiki.gnucash.org/wiki/FAQ#Configuring_and_Managing

If you have a more specific question someone here can help.

On Wed, Mar 9, 2022 at 3:05 PM Dean Gibson 
wrote:

> Is the directory .gnucash still used by v4.9?
> ___
> 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] MySQL

[David Carlson]

Henrik,

The GnuCash program alone is very stable and reliable.  It can work with
local data files directly or remote data files using third party or network
software.  Whatever reliability issue you are having is most likely an
external one.

It is not required to use the mysql database format to access the same data
file from multiple computers,  but not simultaneously in that or any other
format.

The developers focus mainly on the program rather than the user's
environment,  but they or other users here can often help with specific
details in a given situation.

It would help to know what version of GnuCash you are using,  what OS you
are running it in, and, since you want to access your data remotely,  how
you are trying to do that.

On Sun, Mar 13, 2022, 1:38 PM Henrik Morsing  wrote:

>
> Hi,
>
> I'm new to GnuCash but really wanted it to save to MySQL so I could easily
> access it form different locations. It seems extremely un-reliable though,
> is this expected? Half the time is just hangs and says "The server
> experienced and error..." even though I can connect and log in manually
> with no issues.
>
> Thanks for any tips
> --
>
> ___
> 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] Have you abandoned gnuCash email list? U were so helpful!

[David Carlson]

That looks to me like it was an exceptionally well crafted phishing email

On Sun, Mar 20, 2022 at 8:20 PM Christopher Lam 
wrote:

> On Sun, 20 Mar 2022 at 14:34, Fran_3  wrote:
>
> > (snip).
> >
> Now I don't see you participating and it seems traffic on the list is way
> > down.
> > Have the developers abandoned the project?
> >
>
> Thank you Fran; no, the project is alive as long as there is interest in
> it. The number of live bugs seems to be decreasing, hence the slow decline
> in traffic. It seems the community is being very helpful, thus there's
> little need to intervene.
> ___
> 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] Have you abandoned gnuCash email list? U were so helpful!

[David Carlson]

Fran_3,

I did not see your original message.  Did you send it directly to
Christopher instead of the list?  That is seriously discouraged, and the
primary reason that I thought that was phishing.

On Mon, Mar 21, 2022 at 1:58 PM Fran_3  wrote:

> Not phishing. I use gnuCash each year for a 2 or 3 weeks to help 3 very
> small entities here in Florida.
> They make the data inputs during the year and I try and help them organize
> their annual financials for their tax guy to do their taxes.
>
> That said, I am not an accountant but I know enough to get by with a
> little help from the great gnuCash forum members.
>
> And, I will say that I am a big fan of the program... even though I wish
> it could also generate reports on a cash basis... as opposed to an accrual
> basis... but I can get there by exporting select gnuCash accounts and
> Transaction Reports to cvs files and then loading them into Google Sheets
> or Excel.
>
> Thanks.
> Fran Lee
> Florida
>
>
>
> On Monday, March 21, 2022, 10:45:36 AM EDT, David Carlson <
> david.carlson@gmail.com> wrote:
>
>
> That looks to me like it was an exceptionally well crafted phishing email
>
> On Sun, Mar 20, 2022 at 8:20 PM Christopher Lam 
> wrote:
>
> On Sun, 20 Mar 2022 at 14:34, Fran_3  wrote:
>
> > (snip).
> >
> Now I don't see you participating and it seems traffic on the list is way
> > down.
> > Have the developers abandoned the project?
> >
>
> Thank you Fran; no, the project is alive as long as there is interest in
> it. The number of live bugs seems to be decreasing, hence the slow decline
> in traffic. It seems the community is being very helpful, thus there's
> little need to intervene.
>
> ___
> 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
>
>

-- 
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] Upgrade problem

[David Carlson]

5 Mar 2022 20:23:53 -0500
> > From: Adrien Monteleone 
> > To: gnucash-u...@lists.gnucash.org
> > Subject: Re: [GNC] change default behavior of ctrl-PgDn
> > Message-ID: 
> > Content-Type: text/plain; charset=UTF-8; format=flowed
> >
> > Actions > Blank Transaction has cmd-pgdn as the key combo. I'd hazard it
> > is ctrl-pgdn other than Mac.
> >
> > I recall now one of your replies in a previous thread or maybe a bug
> > about this. And indeed shift-pgdn does bring you to the Blank
> > Transaction with focus on the date field. But the one listed as in the
> > menu does not.
> >
> > So maybe the bug is the wrong key-combo is shown in the menu? Except
> > choosing the menu option directly drops you to the first Action field
> > rather than the Date. So while you end up in the same new blank
> > transaction, you end up in a different field.
> >
> > Regards,
> > Adrien
> >
> > On 3/25/22 1:42 PM, John Ralls wrote:
> >> Since when is control-page down the "official key combo"? See
> https://www.gnucash.org/docs/v4/C/gnucash-guide/chapter_txns.html#txns-register-oview,
> section 2.9.2.4 Using Entry Shortcuts:
> >> "
> >> ? To move around the register, use these keys to save time:
> >>
> >> ? Tab to move to the next field, Shift+Tab to move to the
> previous field
> >>
> >> ? Home to move to the beginning of the field, End to move to
> the end of the field
> >>
> >> ? Enter or ? to move to the next transaction, ? to move to the
> previous transaction
> >>
> >> ? Page Up to move up one screen, Page Down to move down one
> screen
> >>
> >> ? Shift+Page Up to go to the first transaction, Shift+Page Down
> to go to the last transaction
> >
> >
> >
> > --
> >
> > Message: 8
> > Date: Fri, 25 Mar 2022 20:24:45 -0500
> > From: Adrien Monteleone 
> > To: gnucash-u...@lists.gnucash.org
> > Subject: Re: [GNC] create desktop icons for GNC 4.9 Flatpak on Ubuntu
> > Message-ID: 
> > Content-Type: text/plain; charset=UTF-8; format=flowed
> >
> > I think David Whiting's reply should get you there. (I didn't notice it
> > when I sent mine)
> >
> > If that doesn't work, report back what happens instead.
> >
> > Regards,
> > Adrien
> >
> > On 3/25/22 6:24 PM, Jeff wrote:
> >> I would like to have individual icons that execute GNC for a specific
> >> set of books.
> >>
> >> IE: icon (GNC parents books) ?? icon (GNC personal books) ? ? icon (GNC
> >> company books) etc.
> >>
> >>
> >
> >
> >
> > --
> >
> > Message: 9
> > Date: Sat, 26 Mar 2022 12:52:04 +1000
> > From: davidcousen...@gmail.com
> > To: gnucash-user@gnucash.org
> > Subject: Re: [GNC] create desktop icons for GNC 4.9 Flatpak on Ubuntu
> > Message-ID: <5be937d1e2f18fc024d1982af340638f4463465e.ca...@gmail.com>
> > Content-Type: text/plain; charset="UTF-8"
> >
> > Jeff,
> >
> > Follow David Whitings suggestion creating multiple desktop entries in
> the file,
> > one for each separate datafile you need to open, changing the name in
> the Name
> > entry and the filepath in the Exec entry as appropriate.
> >
> > You can locate/put the desktop file in your home directory at
> > /home//.local/share/applications/gnucash.desktop.
> >
> > If you need it available to all users on the system you can similarly
> modify the
> > gnucash.desktop file at /usr/local/share /applications/gnucash.desktop
> to append
> > the additional entries to the file there but you will need sudo
> privileges to do
> > that. (There are a lot of multilanguage entries in the system file so it
> will be
> > simpler to create the single user entry in your home directory.
> >
> > David Cousens
> >
> > On Fri, 2022-03-25 at 18:24 -0500, Jeff wrote:
> >> I would like to have individual icons that execute GNC for a specific
> >> set of books.
> >>
> >> IE: icon (GNC parents books)icon (GNC personal books)icon (GNC
> >> company books) etc.
> >>
> >>
> >
> >
> >
> > --
> >
> > Message: 10
> > Date: Sat, 26 Mar 2022 03:24:51 -0500
> > From: Jeff 
> > To: david whiting 
> > Cc: Gnucash userlist 
> > Subject: Re: [GNC] create desktop icons for GNC 4.9 Flatpak on Ubuntu
> > Message-ID:
> > <
> sj0pr05mb82319277a9c08cfe7da11ee187...@sj0pr05mb8231.namprd05.prod.outlook.com
> >
> >
> > Content-Type: text/plain; charset=utf-8; format=flowed
> >
> >
> > I tried this but I cannot locate the actual GNC icon file.? I do have
> > one where I attempted, unsuccessfully, to build GNC 4.9 from source.
> >
> > I changed the path to the icon in the build directory.? And gave the
> > exec the path to one of my .gnucash files but the desktop link still
> > refuses to work.
> >
> >
> > --
> > --JEffrey Black M.B.A.
> >
> >
> >
> > On 3/25/22 3:45 AM, david whiting wrote:
> >> Hi Jeff,
> >>
> >> The following works for me, with gnucash installed for a user:
> >>
> >> 1. Create a desktop file (using a text editor) with the entry shown
> below
> >> 2. On the Exec line, change Documents/test-2.gnucash to the path to
> >> your gnucash file
> >> 3. On the Name line, change this to whatever you want to call it, i.e.
> >> what you want to see on the desktop
> >> 4. Change the path for the icon to the correct location (perhaps
> >> changing /home/david to /home/jeff)
> >> 5. Save the file as whatever-you-want-to-call-it.desktop
> >> 6. Go to your desktop
> >> 7. Right-click on the file on the desktop and select "Allow launching"
> >> (this step is important)
> >> 8. Repeat this process for other files, changing the Exec line and
> >> Name lines accordingly
> >>
> >>
> >> [Desktop Entry]
> >> Type=Application
> >> Terminal=false
> >> Exec=flatpak run org.gnucash.GnuCash Documents/test-2.gnucash
> >> Name=GnuCash 4.9 FLATPAK test-2
> >> Comment=Manage home and small business accounts
> >>
> Icon=/home/david/.local/share/flatpak/app/org.gnucash.GnuCash/x86_64/stable/active/files/share/gnucash/pixmaps/gnucash-icon.ico
> >>
> >>
> >> David
> >>
> >>
> >> On Fri, 25 Mar 2022 at 07:38, Jeff  wrote:
> >>> I have never had a problem creating desktop icons for multiple books
> for
> >>> GNC on Ubuntu 20.04 LTS prior to installing the FlatPak version for
> GNC 4.9.
> >>>
> >>> Everything I have tried for the desktop icon has failed miserably on
> the
> >>> Flatpak version of GNC 4.9.  Is there someone who can guide me on
> >>> creating the desktop icons for this version on Ubuntu version 20.04
> >>> LTS.  I have multiple sets of books to maintain for family members.
> >>>
> >>> --
> >>> --JEffrey Black M.B.A.
> >>>
> >>> ___
> >>> 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.
> >>
> >>
> >
> >
> >
> > --
> >
> > Subject: Digest Footer
> >
> > ___
> >
> > 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.
> >
> >
> > --
> >
> > End of gnucash-user Digest, Vol 228, Issue 50
> > *
> >
> > ___
> > gnucash-user mailing list
> > gnucash-user@gnucash.org
> > To update your subscription preferences or to unsubscribe:
> > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> > -
> > Please remember to CC this list on all your replies.
> > You can do this by using Reply-To-List or Reply-All.
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>


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

Re: [GNC] Fw: Re: Upgrade problem

[David Carlson]

Hint: If GnuCash popped up a message saying it could not find the file and
offered to remove it from the history list, that is the name of the file.
Since GnuCash couldn't find it, it is no longer in the folder that your OS
(Windows) thinks it used to be in.  That is where you need to figure out
what the new name of that folder is.  You need to explore the naming scheme
that your computer is using for USB and network folders.

On Tue, Mar 29, 2022 at 5:22 AM Fred Bone  wrote:

> On 29 March 2022 at 9:40, avigr...@juno.com said:
>
> > What is the filename that GnuCash uses to store the data?  I need to know
> > what filename I am looking for when I do my search for it.
>
> It stores it under the filename you told it to use.
>
>
> ___
> 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] I try to set up GNUCash and it says that my attempt to save the file is denied

[David Carlson]

Is this problem unique to GnuCAsh?

On Thu, Mar 31, 2022 at 4:22 AM W. Neal Lewis  wrote:

> I am trying to set up GNUCash on a Mac Pro running Mojave.
>
> I just downloaded the latest release for Intel Mac.
>
> After doing the preliminary work and setting up the files, I try to save
> it.
>
> It always tells me that the save attempt is denied.
>
> I am running Intego AntiVirus software. I own the computer and am the
> administrator.
>
> Any thoughts or comments?
>
> Thanks,
>
> Neal Lewis
> ___
> 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] Reconciliation discrepancies

[David Carlson]

A possibility that has not been mentioned yet is if there are transactions
in more than one currency or involving securities.  If so, there are many
possible additional sources of discrepancy.  Also, if the discrepancies
suddenly appeared, say, after updating GnuCash to release 4.10, for
example, that release is very new and may have 'bugs', known or unknown.

David Carlson

On Mon, Apr 11, 2022 at 11:30 PM  wrote:

> Rich
>
> Have been using GnuCash for a similar period of time and have not noticed
> any
> reconciliation problems (other than those reported as bugs on the list -
> any
> that are are generally fixed pretty quickly) up to v4.9, particulaarly in
> recent
> versions.  Haven't yet done a reconciliation with 4.10.
>
> Anytime I have had a problem it has usually been a transposition, date
> errors
> and or missing transaction from the reconciliation period and different
> ordering
> in GnuCash and in the banks record leading to me missing a transaction.
> Scheduled transactions if you have them might have different values from
> the
> bank's as might interest calculations if you calculate them yourself. I
> have had
> problems where the bank has a completely different order from my own
> entries and
> even the imported OFX entries because of clearance requirements for entry
> into
> the statement at the bank end.
>
> Have you tried checking the bank's balance by importing their opening and
> closing balances and transactions into a spread sheet and summing them?
> Unfortunately most pdfs will not import tables cleanly into most
> spreadsheets
> but I have resorted to entering the numbers by hand (individually cut and
> paste)
> to check. Only once have I discovered a bank error and they were most
> apologetic.
>
> David Cousens
>
> On Mon, 2022-04-11 at 16:09 -0700, Rich Shepard wrote:
> > On Mon, 11 Apr 2022, Gyle McCollam wrote:
> >
> > > These may not apply, but check that your reconciliation date is the
> same
> > > as the bank's. Also, check the dates of the transactions as GC shows
> > > transaction past the reconciliation date, that you don't want to
> > > reconcile. The ending balance that GC shows for the reconciliation can
> be
> > > changed, so put in the bank's balance and see if you get a zero
> > > difference.
> >
> > Gyle,
> >
> > I check both the reconciliation date and that date's balance. There are
> > discrepancies between the purchase date entered in GnuCash and when the
> > transaction cleared the bank but those are immaterial.
> >
> > As an aside, I've used GnuCash for more than two decades, starting in
> 1997.
> > These large, sporatic discrepancies appeared only a few years ago, long
> > after I moved my business and personal accounts to my current bank. I did
> > catch the bank several years ago for charging me twice for the same
> Amazon
> > purchase and my banker had that quickly fixed. That was the only obvious
> > error I've seen.
> >
> > Thanks,
> >
> > Rich
> > ___
> > 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] Scheduled transactions feature or bug?

[David Carlson]

When you open the scheduled transaction in the transaction editor, you get
hit in the face with the listing of the last occurred date under the
Occurrences section.  I think that pretty obviously suggests that the next
occurrence will follow the defined sequence from that date unless it is
edited.  Further, in the Scheduled Transactions list there is a column
titled Next Occurrence.  I wonder what date is listed there?

The most one could ask for is minor updates to the UI to make that even
more obvious.

On Tue, Apr 12, 2022 at 3:45 PM Stan Brown 
wrote:

> On 2022-04-12 11:59, Glenn Fowler wrote:
> > However, I do agree with the OP in that you would think the expected
> > behavior would be to pause when disabled, and then when reenabled to not
> go
> > back to prior to that point.
>
> I wouldn't think that. If I re-enable a scheduled transaction, keeping
> the original start date, I would _expect_ it to make up the missed
> transactions.
>
> Just another data point.
>
> --
> Stan Brown
> Tehachapi, CA, USA
> https://BrownMath.com
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>


-- 
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] New to GnuCash SQLite on Windows: I have questions

[David Carlson]

I would like to add a question to Tom's list.  Is there any way to easily
make periodic backups of SQLite data files?

On Tue, Apr 19, 2022 at 8:21 PM Derek Atkins  wrote:

> Hi,
>
> On Tue, April 19, 2022 7:55 pm, Tom Browder wrote:
> > I just updated my MS Windows GnuCash version to 4.10 and see the new
> > option
> > to save my GnuCash xml file in SQLite format. In general, I like it!
> >
> > However, I had a few moments of panic when Windows wanted to save the
> file
> > without a name change.  I also forgot the changes in the SQLite file are
> > done without notice.
> > (When I first started withGnuCash on Windows, I was able to unzip the xml
> > file and save it unzipped as "myGnuCash.gnucash" successfully so I get
> > version control over a text file for readable diffs.)
> >
> > 1. Is there any way to get GnuCash to save its file, by default, with an
> > appropriate suffix other than "gnucash?"
>
> Sure, tell it to do that.  It only adds ".gnucash" by default, but it
> won't override what you tell it.
>
> > 2. Is there any hope of some kind of "commit" button to use with the
> > SQLite
> > version?
>
> The benefit of the SQL backend is that it writes all changes when you
> commit (enter) a transaction.  So no, there will not be a "Save" button.
> The "commit" button is the "Enter" key (or exiting out of a transaction
> edit).
>
> > 3. I assume the binary SQLite file is usable with a binary copy from
> > Windows, is that true?
>
> I'm not sure I understand this question, but the SQLite data file is
> usable from any platform.
>
> > 4. Is there any Perl program on Windows to convert the xml file to
> SQLite?
> > Is there one on Linux?
>
> No.  Open the XML in GnuCash and then File -> Save As to save it as SQLite.
>
> > My immediate goal is to continue using my xml fille on Windows as the
> > master data source until I'm comfortable with the SQLite version. During
> > that time, I will periodically produce an SQLite version as a read-only
> > one
> > to experiment with on Linux.
> >
> > I would love to do that automatically.
>
> You mean without using File -> Save As?
>
> > I have briefly looked at the (ugh) Python support and may go down that
> > route, but not until I've looked at compiling from github on Linux and
> > looked at what's available.
>
> Yes, you may be able to use the Python bindings to open the XML file and
> SaveAs SQL.  I've never tried it.
>
> > Thanks for any help or suggestions.
> >
> > -Tom
>
> > Please remember to CC this list on all your replies.
> > You can do this by using Reply-To-List or Reply-All.
>
> -derek
>
> --
>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.
>


-- 
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] New to GnuCash SQLite on Windows: I have questions

[David Carlson]

Somewhere I lost track of the reasoning to save a file under a filename
without an extension.  Since there has never been a standard method to
assign an extended attribute for filetype that, unlike file extensions, is
consistent over all common file storage formats, in my opinion it would
still be very confusing if there were no extensions.  As for depending on
the name of the folder for that type of information, I just discovered that
a month ago I misfiled a few PDF's in a folder that is not intended to
contain any such files.  I only found them by accident when I was looking
for something else.  Oh, remember OS/2 Warp?

On Thu, Apr 21, 2022 at 12:26 PM Bert Riding  wrote:

> On Thu, 21 Apr 2022 18:08:47 +0100
> Chris Green  wrote:
>
> > On Thu, Apr 21, 2022 at 06:54:11PM +0200, Geert Janssens wrote:
> > > Op donderdag 21 april 2022 16:36:36 CEST schreef Bert Riding:
> > > > On Thu, 21 Apr 2022 08:45:20 +0100
> > > >
> > > > Chris Green  wrote:
> > > > > On Wed, Apr 20, 2022 at 05:54:31PM -0700, john wrote:
> > > > > > > On Apr 20, 2022, at 1:58 AM, Liz  wrote:
> > > > > > >
> > > > > > > On Wed, 20 Apr 2022 09:02:16 +0100
> > > > > > >
> > > > > > > Chris Green  wrote:
> > > > > > >> On Tue, Apr 19, 2022 at 09:20:56PM -0400, Derek Atkins
> > > > > > >> wrote:
> > > > > > >>>> 1. Is there any way to get GnuCash to save its file, by
> > > > > > >>>> default, with an appropriate suffix other than
> > > > > > >>>> "gnucash?"
> > > > > > >>>
> > > > > > >>> Sure, tell it to do that.  It only adds ".gnucash" by
> > > > > > >>> default, but it won't override what you tell it.
> > > > > > >>
> > > > > > >> Where do you tell it that?
> > > > > > >
> > > > > > > "Save As" in the menu should do it.
> > > > > >
> > > > > > Be careful to switch back to the "primary" file after doing
> > > > > > that, otherwise the primary will become the snapshot and new
> > > > > > work will go into the new file.
> > > > >
> > > > > But that's the ultimate aim! :-
> > > > >
> > > > > Instead of having the long, clumsy, "gnucash" suffix one wants
> > > > > something tidier like "gc".
> > > > >
> > > > > Remember on Linux the whole filename is always displayed so all
> > > > > those "gnucash" suffixes get a bit wearing after a while.
> > > >
> > > > In my experience gnucash doesn't care what your data file is
> > > > called, with or without any suffix you care to use.  Personally I
> > > > use none. Once you have opened the file and gnucash knows of it,
> > > > it will show up in the recents list automatically.
> > >
> > > True. GnuCash doesn't care. However operating system file managers
> > > in general do care. They use the extension to figure out which
> > > application to launch when you double-click a file. But if you
> > > don't use that feature (and many don't with GnuCash as it remembers
> > > which file you last opened) you're ok without file extension.
> > However this all begs the question.  *How* do I get GnuCash to save a
> > file without a file extension?  As I said back up this thread
> > somewhere it insists on adding ".gnucash" whatever I do to try and
> > discourage it.
> >
> > Are people who say they save without an extension just seeing the
> > Windows default of not showing extensions maybe?
> >
>
> If I need to make a new file, I save it in gnucash and it gets the
> .gnucash extension.  I close the file, rename it without an extension,
> then open it by using the Open dialog under File or by directly calling
> gnucash from the command line with the new filename as a parameter.
>
> I use linux/X, YMMV.
>
> --
> Bert Riding
> rerid...@xmission.com
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>


-- 
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] Reinstall GnuCash after Ubuntu upgrade to 22.04

[David Carlson]

Thank you David W.  Now for myself and other users that are not comfortable
with Flatpak or with DIY solutions but willing to accept backports, what is
the probability of seeing more recent 4.x releases as backports to the
Ubuntu distro?

On Sun, Apr 24, 2022 at 2:06 PM david whiting  wrote:

> You have at least three options:
>
> 1) Install version 4.8a that ships with Ubuntu 22.04: sudo apt install
> gnucash
>
> 2) Use flatpack, this will get you a more recent version. See
> https://wiki.gnucash.org/wiki/Flatpak
>
> 3) Build it yourself, and get 4.9 or the maintenance release (or other
> releases). See
> https://wiki.gnucash.org/wiki/Building_On_Ubuntu#Build_Instructions
>
> David
>
> On Sun, 24 Apr 2022 at 17:59, Steve Cohen  wrote:
> >
> > I just upgraded my system to Ubuntu 22.04 (from 21.10). As a non-official
> > application, GNUcash seems to have been removed from the system or
> rendered
> > non-functional though a launch icon remains and does nothing.  Prior to
> > install, I was running GNC 4.9.
> >
> > Can someone please point me in the right direction for building or
> > installing the best version of GNUcash on my new system?
> >
> > Thanks.
> > ___
> > 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 Whiting
> ___
> 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] Shutdown using the "X" in windows 11

[David Carlson]

I have found that in one instance of of GnuCash 3.8 in a Ubuntu 21.04
laptop and in another instance of GnuCash 3.8 in a virtualbox instance of
Linux Lite based, I think, on the same release of Ubuntu, that if the
machines are allowed to to develop swap files larger than a few hundred
Megs before rebooting, then GnuCash sometimes fails to clear the lock file
even when it is closed several minutes before rebooting.  I suspect that
newer releases of GnuCash may also fail to close the lock file if there is
a possibility that they are involved with a swap file.  Further, it would
be easy to conclude that somehow this is interpreted either accurately or
erroneously as depending on whether the program is closed by clicking on
the "X" icon or using Alt-F, Q or Ctrl-Q.  I also believe that if there
happens to be a pending edit left open, it is very easy to overlook the
warning in the rush to close GnuCash.  That can also prevent clearing the
lock file.

On Sun, Apr 24, 2022 at 6:19 PM Gyle McCollam  wrote:

> Using Windows 11 and GnuCash 4.10
>
> Also had this issue in an older version.  Clicked on the "X" to shut down
> and had not saved first.  In the dialogue I clicked on Cancel, but it still
> shutdown.  I expected "Cancel" to cancel the operation (shutdown), am I
> wrong.  What operation is it canceling?  All 3 options have the same
> result,  They all close the program without saving and upon restart, I got
> the message that "GnuCash could not obtain the lock for
> C:\Users\*\OneDrive\Documents\GNUCash\**.gnucash." (see pic 2)  "***"
> for my specific system names.
>
> [cid:5ce6c5d0-06c4-4be7-88c9-51e0ab733c10]
>
> [cid:5082774d-7534-4039-ace7-d5b0d8aa2efa]
>
> I will try to remember to "Save" first, however when I do forget it is
> frustrating that this built in safeguard doesn't work.
>
>
> Thank You,
> Gyle McCollam
>
> Gyle McCollam
>
> 609.680.2326 Mobile
>
> gmccol...@live.com<mailto:gmccol...@gyleshomes.com>   email
> ___
> 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] Setting currency on share accounts

[David Carlson]

Securities (stocks) are held in brokerage accounts which reside under
assets.  The brokerage account determines the currency for it's securities
and transactions.  GnuCash assumes that a given brokerage account deals in
only one currency, so another brokerage account is needed for an additional
currency.  The same security can be held in multiple brokerage accounts.
See the help and tutorials for examples of accounts and transactions.

Prices get entered into the price data by several means including actual
prices from transactions, prices downloaded from the Internet or imported
from a file, or even manually entered into the database.

Reports can pick prices out of the price data by different algorithms
depending on your choice.  If there is no price for a given report date
GnuCash will use the method you choose to pick or calculate a price for the
report.

I am deliberately not being detailed because there is a huge universe of
choices depending on your needs.  If you have specific questions ask them
here to get specific answers.

On Wed, Apr 27, 2022 at 10:12 PM Phillip Duff  wrote:

> Hi,
>
> I cannot see where you set the currency for a stock account. I have stocks
> in multiple currencies, but the currency/secuity field seems dual purpose,
> therefore assumes the stock is in base currency, which is not always the
> case.
>
> Anyone know how to do it?
>
> Also, I can’t fund in the documentation whether the system uses the latest
> price/currency in the price database or does it require the price to exist
> for the day on which it is being calculated. Example: If the latest price I
> have in the price database is on 14-MAr will the system use this price to
> calculate value on the 31-Mar
>
> Cheers Phil
> ___
> 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] Feature Request/Workaround Info: Preserve "Notes" Field?

[David Carlson]

Eric,

The 'Append' button is a fairly recently added feature, probably around
release 4.6 or thereabouts. If you are still using an older version perhaps
you should update GnuCash.

On Fri, Apr 29, 2022, 9:16 PM Jean L  wrote:

> Again: the "append" check mark in the import dialog appends notes from
> the OFX to the notes you put in instead of replacing them if 'u+c' is
> selected.
>
>
> On 4/29/2022 6:51 PM, Eric H. Bowen via gnucash-user wrote:
> > Gyle,
> >
> > I do this when I remember, especially with regard to checks. But I've
> > still had data overwritten later when I imported data, the import
> > brought in data which I had already entered, and I neglected to go
> > through the whole list and change everything to 'c'. I still think
> > that a settings switch which preserves the 'Notes' field by default
> > when importing data would be a worthwhile additionEric.
> >
> > On 4/29/22 20:18, Gyle McCollam wrote:
> >> Eric,
> >> I know you probably tried this , but when you are importing Are you
> >> checking the "c" box and not the "u+c" box.  The "c" only clears,
> >> whereas the "u+c" UPDATES and clears.
> >>
> >> Thank You,
> >> *Gyle McCollam*
> >>
> >> Gyle McCollam
> >>
> >> 609.680.2326Mobile
> >>
> >> gmccol...@live.com email
> >>
> >> 
> >> *From:* gnucash-user
> >>  on behalf of Eric
> >> H. Bowen via gnucash-user 
> >> *Sent:* Friday, April 29, 2022 8:09 PM
> >> *To:* gnucash-user@gnucash.org 
> >> *Subject:* [GNC] Feature Request/Workaround Info: Preserve "Notes"
> >> Field?
> >> There is an issue which has been bugging me for some time with regard to
> >> OFX/QFX imports: At least from my credit cards/financial institution,
> >> when data is imported it overwrites the existing data in both the
> >> "Description" and the "Notes" field...and, nine times out of ten, the
> >> QFX "Notes" field is essentially a rehash of the "Description" field.
> >>
> >> I like to leave transaction identification information in the "Notes"
> >> field so that months later (Tax time!) I can recall the exact purpose of
> >> a purchase without having to do a search through my email logs or PayPal
> >> transactions in order to identify what that eBay purchase was actually
> >> for. But at present any information I put there gets overwritten unless
> >> I remember to manually re-enter it after the transaction clears when I
> >> do an import from my financial institution.
> >>
> >> I'd like to have a switch somewhere in "Settings" where you could
> >> customize the QFX (and possibly QIF, although I don't use that much)
> >> import so that if the Notes field is non-blank it does not get
> >> overwritten by the imported data. Perhaps there already is such a switch
> >> and I've just missed it; if so could someone enlighten me? Otherwise I'd
> >> like to make this a formal feature request; how do I go about doing
> >> that?
> >>
> >> Eric H. Bowen
> >>
> >>
> >> ___
> >> gnucash-user mailing list
> >> gnucash-user@gnucash.org
> >> To update your subscription preferences or to unsubscribe:
> >> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> >> If you are using Nabble or Gmane, please see
> >> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> >> -
> >> Please remember to CC this list on all your replies.
> >> You can do this by using Reply-To-List or Reply-All.
> >
> > ___
> > gnucash-user mailing list
> > gnucash-user@gnucash.org
> > To update your subscription preferences or to unsubscribe:
> > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > If you are using Nabble or Gmane, please see
> > https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> > -
> > Please remember to CC this list on all your replies.
> > You can do this by using Reply-To-List or Reply-All.
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Tab in Reconcile window

[David Carlson]

Fred and Gyle,

For comparison, in Release 3.8 running in Ubuntu 20.04.  The Tab and Shift
Tab work as described.  Interestingly, however, when using the mouse to fly
over the menu key icons, the fly-over descriptions appear when hovering
over all of the menu key icons, but only the key icons in the center and
right highlight while hovering.  The key icons on the left do not
highlight.  This tidbit of information may help the developers when
diagnosing the problem in release 4.10.

On Sun, May 1, 2022 at 10:17 AM Gyle McCollam  wrote:

> Fred, I'm running Windows 11 so it may be different, but The tab & Shift
> tab work.  However, when the reconciliation window opens you have a hrd
> time seeing just where the selector is at.  Once the window opens, if you
> use the down arrow the 1st item in the left window (funds in) is
> highlighted in blue.  When you tab, there is an almost invisible dotted box
> around the 1st item in the right window (funds out).  Again, if you down
> arrow the item will be highlighted.  Same with shift-tab.  Hope it is the
> same in your Linux version.
>
>
> Thank You,
> Gyle McCollam
>
> Gyle McCollam
>
> 609.680.2326 Mobile
>
> gmccol...@live.com<mailto:gmccol...@gyleshomes.com>   email
>
> 
> From: gnucash-user  on
> behalf of Fred Tydeman 
> Sent: Sunday, May 1, 2022 12:35 AM
> To: Gnucash Users 
> Subject: [GNC] Tab in Reconcile window
>
> The Tip of the Day says that Tab and Shift-Tab should move between
> deposits and withdrawals in the reconcile window.  For me, they appear
> to be ignored -- I have to mouse click between windows/panes.
> I am running Fedora Linux, Gnucash 4.10.
> ___
> 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] Credit Card Opening Balance

[David Carlson]

I keep PDF's of monthly credit card statements and lots of other important
things on a dedicated server on my LAN, backed up offline.  I do have a
spreadsheet tracking which items are on this server.  All of that was
started even before I started using GnuCash, and there is no need to put
that information into GnuCash.

On Sun, May 1, 2022 at 7:24 PM Jim DeLaHunt  wrote:

> On 2022-05-01 16:27, Smartner LLC wrote:
>
> > …I tend to maintain the following structure for every credit card
> >
> > Liability:Credit Card
> > Liability: > Liability: >
> > This helps me keep the transactions and statements separate and ensure
> > that I can track the expenses since the last generated statement
> > separately. Meanwhile, I can track total outstanding on the card  on
> > the rolled up balance for the liability account for the credit card.…
>
> If that works for you, great. However, it is not the structure I use,
> and I don't understand how you use the separation between statements and
> transactions.
>
> My structure is a single GnuCash "account" for
> Liability:Credit Card. I enter all transactions on that
> card in that account. When statements come in, I use the GnuCash
> "reconciliation" feature to mark the transactions which the card company
> confirms on its statement as "reconciled" in my GnuCash books. The
> expenses since the last generated statement are simply those which do
> not have the status of "reconciled". The View… Filter… dialogue allows
> me to hide all the reconciled transactions if I want.
>
> What do you do with the transactions in your
> Liability:CreditCard:Transactions account when the
> following month's statement comes in?  Do you edit each transaction so
> that it moves to the Liability:CreditCard:Statements
> account instead?  That looks to me like more work than using the
> reconciliation feature, and I don't see what extra utility it would give
> you.
>
> By the way, I am keeping books for my personal finances and a small
> self-proprietership business. My stakes are low, and I have no auditor
> to satisfy. I see no need to close my books at the end of the year; some
> of my account registers span 10-20 years.
>
> Best regards,
>   —Jim DeLaHunt
>
> ___
> 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] GnuCash 3.905 Released

[David Carlson]

the Scheduled Transaction
> Template dialog.
> • [balance-sheet] hide trading-accounts if use-trading-accts? is
> unset
> • Fix a null parent error in the New Account Hierarchy Assistant.
> Updated Translations: German
>
> Known Problems
>
> • Bug 797786 - New Balance Sheet does not balance when multiple
> currencies and commodities (stock holdings) are included
> • Bug 797800 - [help screen items] clarification welcome
> Complete list of all open bugs.
>
> .
> Documentation
>
> Between 3.904 and 3.905, the following bugfixes were accomplished:
>
> • Bug 770132 - Price editor does not find ASX:XRO
> • Bug 797783 - [PATCH] The "over" and "under" estimate in the
> unrealized capital gain chapter should be reversed.
> The following fixes and improvements were not associated with bug reports:
>
> • L12N:it, pt update: Vanguard is part of AlphaVantage
> This changed already, when yahoo shut csv interface
>
> • Update fq-sources.html: asx source is working again
> Also explain why you need F::Q 1.41
>
> • Tell travis to use ubuntu-18.04-docker file
> • Appendix: add "Ticker" to distinguish from security numbers
> • Note on dots in yahoo symbols
> Getting GnuCash for Windows and MacOS
>
> GnuCash is provided for both Microsoft Windows 8.1® and later and MacOS
> 10.13 (High Sierra)® and later in pre-built, all-in-one packages. An
> installer is provided for Microsoft Windows® while the MacOS® package is a
> disk image containing a drag-and-drop application bundle.
>
> The SHA256 Hashes for the downloadable files are:
>
> •
> 20409d89f7e2af6756dcec85b7321b0cbe68e8c6eaaf300c6741136a58d9e2a0
> gnucash-3.905.tar.bz2
> •
> 7a95263708bc0960d870f50d29fd20cfb3d7fcedbb16ee6d1aaac8f91b9a93d0
> gnucash-3.905.tar.gz
> •
> 9a92191796416cce934aebd0458dbf84e326a633fae9d457a1fd0d4fd55050fa
> gnucash-3.905.setup.exe
> •
> b0a9a4f69bdc33defe5f29a5d7956fcf42001ba04f62ec72b07ff401e853bd7a
> Gnucash-Intel-3.905-1.dmg
> •
> 565bd71b89dbce29f6ae9530cf44d9290df89000500f0a68602a056f95caa6c6
> gnucash-docs-3.905.tar.gz
>
> Windows:
>
> https://github.com/Gnucash/gnucash/releases/download/3.905/gnucash-3.905.setup.exe
>
> https://downloads.sourceforge.net/gnucash/gnucash%20%28unstable%29/gnucash-3.905.setup.exe
>
> MacOS:
>
> https://github.com/Gnucash/gnucash/releases/download/3.905/Gnucash-Intel-3.905-1.dmg
>
> https://downloads.sourceforge.net/gnucash/gnucash%20%28unstable%29/Gnucash-Intel-3.905-1.dmg
>
> GnuCash is now available as a flatpak from Flathub.org. Instructions for
> installing and running.
>
> Getting GnuCash as source code
> If you want to compile GnuCash 3.905 for yourself, the source code can be
> downloaded from:
>
> https://github.com/Gnucash/gnucash/releases/download/3.905/gnucash-3.905.tar.bz2
>
> https://github.com/Gnucash/gnucash/releases/download/3.905/gnucash-3.905.tar.gz
>
> https://downloads.sourceforge.net/gnucash/gnucash%20%28unstable%29/gnucash-3.905.tar.bz2
>
> https://downloads.sourceforge.net/gnucash/gnucash%20%28unstable%29/gnucash-3.905.tar.gz
>
> You can also checkout the sources directly from the git repository, see
> https://wiki.gnucash.org/wiki/Git for instructions.
>
> To compile GnuCash from the source code by yourself, you will need at
> least Gtk+ 3.22.29, Guile 2.0, Boost 1.67, WebKitGtk 2.4, GoogleTest 1.8.0,
> cmake 3.10 and SWIG 2.0.12 if compiling from git. Please consult the
> README.dependencies file in the sources for the exact list of dependencies
> and versions.
>
> Getting the documentation
>
> If you want to compile the GnuCash Documentation 3.905 for yourself, the
> source code can be downloaded from:
>
> https://github.com/Gnucash/gnucash/releases/download/3.905/gnucash-docs-3.905.tar.gz
>
> https://downloads.sourceforge.net/gnucash/gnucash%20%28unstable%29/gnucash-docs-3.905-1.tar.gz
>
> Note that the documentation for unstable releases is not on the GnuCash
> website. It is built daily and may be found on the development server under
> the locale directory; "C" is English, "de" is German, and so on.
>
> The documentation is included in the MacOS and Windows application bundles.
> About the Program
>
> GnuCash is a free, open source accounting program released under the GNU
> General Public License (GPL) and available for GNU/Linux, *BSD, Solaris,
> MacOS, and Microsoft Windows. Programming on GnuCash began in 1997, and its
> first stable release was in 1998.
> ___
> 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] Error Retrieving Price Quotes - Windows 10

[David Carlson]

It would be helpful to know what release  of GnuCash you are running and
when it last worked ok for you.

On Tue, Jun 16, 2020, 11:39 AM Davy Roid  wrote:

> I got the following errors while running gnucash --add-price-quotes (under
> windows environment)
>
> WARN  Could not kill child process: Access is denied.
> ERROR  There was a system error while retrieving the price quotes.
>
> The system was working perfectly fine the day before. I hard reset the PC
> once as it was completely frozen.
>
> Any idea how to fix it ?
>
> Davy
> ___
> 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] Lost all data after install

[David Carlson]

As for the data file location, it should be in your user space.  A
sub-folder of documents is a good choice.

On Wed, Jun 17, 2020 at 1:40 PM Adrien Monteleone <
adrien.montele...@lusfiber.net> wrote:

> First, please send replies to the list, not just me personally. That way
> others can help, and everyone can benefit from the discussion. (use
> reply-list or reply-all if that is easier)
>
> -
>
> The file can be located anywhere you want. It doesn’t need to be in a
> particular folder.
>
> If the previous version was 2.6.19 or 2.6.21, you may have found a bug.
> (or you may need to step up more slowly)
>
> The recommended upgrade path from 2.6.x is to first get to 2.6.19 or
> 2.6.21, then upgrade to 3.0, then upgrade to 3.10. (you might be able to
> use 3.1 instead of 3.0, and maybe even jump straight from 2.6.19/21 -->
> 3.10, but a developer or someone more versed in this would have to comment)
>
> If the version was 2.4, or even older like 2.2, then you’ll have to step
> through each of those first.
>
> For example, 2.2 --> 2.4 --> 2.6 --> 2.6.21 --> 3.0 --> 3.10
>
> -
>
> See the Wiki FAQ on upgrading paths:
> https://wiki.gnucash.org/wiki/FAQ#Using_Different_Versions.2C_Up_And_Downgrade
>
> Note that it recommends you run Actions > Check & Repair after each time
> you open the file with the next higher version.
>
> Of course, work with a *copy* of the file. Once it is squared away, you
> can make a new backup of the converted file, and then delete the older
> backup.
>
> Regards,
> Adrien
>
>
> > On Jun 17, 2020 w25d169, at 1:24 PM, sinclair turrell <
> sinclairturr...@gmail.com> wrote:
> >
> > Hello Adrian and thank you for your reply.
> >
> > I am using Windows 10 and the version of GnuCash that I installed was
> indeed 3.10. The version I replaced was 2.something - it was a good few
> years old
> >
> > My original save file still appears in the history but GnuCash can't
> find it - neither can I.
> >
> > I can open the file that I backed up OK, this is .gnucash, but the
> problem is that the accounts are blank - please see attachment .
> >
> > I'm not sure if this is relevant but the backup file is located in
> Documents rather than Gnucash itself.
>
>
> ___
> 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] Disappearing entries

[David Carlson]

Most probably no complete transactions have actually disappeared,  yet your
email suggests that you have not ruled out that possibility in your case.

If that had actually happened,  some other account would also have
changed.  Granted, if it were an income or expense account, it might not
jump out as an error.

Has the anomaly  always appeared as a starting balance error in a
reconciliation,  or has it appeared as a discrepancy in a total running
balance?

Has it ever corrected itself or has it ever been necessary to add a
transaction rather than simply re-do the last reconciliation?



On Wed, Jun 17, 2020, 7:18 PM Adrien Monteleone <
adrien.montele...@lusfiber.net> wrote:

> What operating system and what version of GnuCash?
>
> Note that changing just about anything in a transaction will unreconcile
> it, though this should not affect the balance.
>
> As for ‘missing’ transactions, do you ever use a filtered view? (I believe
> an indication the register is filtered will show near the top right)
>
> Regards,
> Adrien
>
>
>
> > On Jun 17, 2020 w25d169, at 6:34 PM, Carl  wrote:
> >
> >   Hello all,
> >
> >   For many years a recurring, but not too frequent, problem has been that
> >   in a credit card account entries will disappear or a previously
> >   reconciled balance will be wrong even though I did nothing to change
> >   the account or the bank account it might be associated with.
> >
> >   Today, for example, I looked at one of my VISA credit card accounts
> >   (that I rarely use),  and to my surprise the balance was $4,350.25 even
> >   though, last week, I had reconciled the account and the balance was
> >   zero. And, no, I hadn't changed any of the other accounts in GC or
> >   imported any transactions so there's no reason from my usage that
> >   could've caused this.
> >
> >   This same sort of problem has happened enough to make ya' pretty
> >   nervous in thinking, "what surprises am I going to find this time?"
> >
> >   Any idea how to fix this?
>
>
> ___
> 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] Cursor Focus on Wrong Tab

[David Carlson]

I suspect that there are actually other instances in the code where
pointers get out of sync, and I am sure that it is incredibly difficult to
test every case, especially in the existing code.  Hopefully, in release
4.0 it will start to get easier to test these things.

One tool that I use for a different circumstance where the working focus is
not visible on the screen is to hit the Tab key, which usually causes the
current window to show the location of the curser.  That does not address
the underlying issues.

On Fri, Jun 19, 2020 at 10:32 AM David T. via gnucash-user <
gnucash-user@gnucash.org> wrote:

> Hello,
>
> I swear I reported troubles with this a long time ago, and I could have
> sworn I added a bug about it. My recollection was that I was the only
> person who could duplicate the issue, and so it never went anywhere
> further. However, I find no evidence on Bugzilla or in the lists. Alas.
> My search skills are clearly lacking.
>
> The issue is this: when I am in Tab "H" and duplicate a transaction by
> clicking the toolbar Duplicate button, once I have concluded the process
> by selecting a new date and pressing Enter, my cursor appears to be in
> tab "H", but is actually on Tab "B" (which is the first register
> account, after the COA). If I attempt to edit the transaction at this
> point, the transaction that receives input is NOT the visible
> transaction in tab H, but rather the hidden transaction on tab B.
>
> In the attached image, "Base Salary" is the aforementioned tab H, in
> which I have just created a new transaction by clicking the Duplicate
> button, choosing today's date and pressing Enter, which has created the
> 06/19/2020 transaction that is visible on screen.
>
> If you look down where the big arrow is pointing, however, you will see
> "66.59" clearly displayed. "66.59" is actually the value of a
> transaction in the Checking register. If I start typing, the
> transaction that receives input *is in the Checking register and NOT the
> visible transaction in the Base Salary register.* I have to remember to
> use the mouse to actively click in the on screen transaction in order to
> "select" the transaction I just created on the currently-visible
> register and which appears to currently have focus.
>
> To say this is confusing is an understatement--and it only gets worse if
> I start typing, fail to see any change, and then remember to click the
> current register. Now, the visible register gets focus--and the hidden
> register (which has changes I unwittingly have made) gets a commit.
> Obviously, this can have significant negative effects: the transaction I
> blindly edited has changed and been saved. Maybe that transaction is now
> unreconciled. Maybe I put gibberish into the description. Maybe I put
> gibberish into the transfer account, and GnuCash will send me a
> mysterious message that the account doesn't exist, would I like to
> create it. Maybe I have changed the amount on that transaction.
>
> I hope that this email provides enough information that others can now
> see the problem that I have seen for a long time; if others can
> duplicate this, I'll enter a bug report.
>
> David T.
>
> ___
> 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] Finance::Quote enters previous day's price as today's

[David Carlson]

I am not sure that this is your problem or not, but I have found that I
need to wait several hours after the markets have closed before downloading
mutual fund prices.  It seems to take hours for some of them to get posted
at Yahoo.com. One way to check would be to see what Yahoo.com is reporting
early after hours vs later.

GnuCash only keeps one downloaded price per day, and repeated prices are
discarded.  If you see that is what is happening, you might file a RFE to
keep the last price reported instead of the first.



.

On Tue, Jun 23, 2020 at 2:19 PM Colin  wrote:

> First off, I just installed GnuCash a couple weeks ago, after trying a few
> other options and finding they simply weren't mature enough or
> feature-complete enough for what I need. I can't say thank you enough to
> everyone who's developed this program, everyone who continues to develop it
> and everyone who provides support here. It's an incredible accomplishment!
>
> I have an issue with Finance::Quote. It brings in prices for my three
> Vanguard funds when I run the following command, and I've been planning on
> setting up a cron job for it:
> gnucash --add-price-quotes path/to/my/gnucash/file
> However, for one fund (VTSAX) it enters the prior day's price again as
> today's. This requires me to look it up and fix it manually. Its settings
> under Security editor are the same as the other two (VTIAX and VWELX).
> They're set to get online quotes from a single source, Alphavantage.
> Can anyone provide guidance on what may be going on here?
> Second question:
> I have a Raspberry Pi and it would make sense to run the cron job there
> since it's always up. I also use Syncthing for syncing files between
> devices. However, the latest version in their repo's is GnuCash 3.4 and
> Finance::Quote 1.47. Would this introduce problems to have the Pi update my
> GnuCash file with price quotes?
>
> Thank you,
> Colin
>
> ___
> 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] Finance::Quote enters previous day's price as today's

[David Carlson]

Frank, good points.  I was on a smartphone and not trying to be 100%
accurate (reigning in the spell checker is already more than I can
handle).  I think GnuCash does differentiate at least some of those types
and maybe save one of each, but I was not able to test.

David Carlson

On Wed, Jun 24, 2020 at 11:44 AM Frank H. Ellenberger <
frank.h.ellenber...@gmail.com> wrote:

> Am 23.06.20 um 22:10 schrieb David Carlson:
> > I am not sure that this is your problem or not, but I have found that I
> > need to wait several hours after the markets have closed before
> downloading
> > mutual fund prices.  It seems to take hours for some of them to get
> posted
> > at Yahoo.com. One way to check would be to see what Yahoo.com is
> reporting
> > early after hours vs later.
> >
> > GnuCash only keeps one downloaded price per day, and repeated prices are
> > discarded.  If you see that is what is happening, you might file a RFE to
> > keep the last price reported instead of the first.
>
> There are also different dimensions of quotes:
>
> for shares, ...:
> by time:  open, last, close,
> by range: min, max,
> by direction: ask, bid,
> all determinated by the market.
>
> for mutual funds:
> net asset value (nav): is calculated by the fund company after markets
> closed and used the next day as payment for returned parts. If you buy
> parts, you pay an agio.
>
> Frank
>


-- 
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] Bulk moving transactions

[David Carlson]

Back around the time the register2 rewrite was started I believe that I
suggested replacing the complex register code with a basic data input
pop-up window for the selected transaction or other input requirement such
as stock purchase, or business feature more like one would likely find in a
database application.  I will suggest a similar design change today to
whomever decides to take up this task.  Unfortunately, I only know Basic
and Fortran IV, which wouldn't get me very far today, so my help would be
very limited.

On Wed, Jul 1, 2020 at 3:38 PM Jean Laroche  wrote:

> I started looking at that a little while before 4.0 and stopped because
> no new features could be added. I'm going to re-start, as this strikes
> me as a must-have feature.
> The other elephant in the room is the undo/redo support, but that's for
> another thread
> J.
>
> On 7/1/20 1:32 PM, Derek Atkins wrote:
> >
> > On Wed, July 1, 2020 4:27 pm, Jean Laroche wrote:
> >> Does it not trike you as insane that we have to go through these hoops
> >> just to bulk move transactions? Something that should be as simple as
> >> shift-select, right-click, move?
> >> I'm not sure how support for multi-select operations was never seriously
> >> looked at.
> >
> > Patches always welcome!
> >
> > Seriously, it's not that easy due to the design and implementation of the
> > register.  The register-2 rewrite was supposed to make it easier, but
> that
> > effort (started about a decade ago) stalled and never finished, so we're
> > still using the same Canvas-based register code.
> >
> >> J.
> >
> >> Please remember to CC this list on all your replies.
> >> You can do this by using Reply-To-List or Reply-All.
> >
> > -derek
> >
> ___
> 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] Bulk moving transactions

[David Carlson]

Maybe I don't know the correct terminology.  I envision the currently
selected transaction automatically appearing in a data entry window instead
of in the register.

On Wed, Jul 1, 2020 at 4:09 PM Derek Atkins  wrote:

> Popups are a very inefficient entry method.
>
> You already have the Ctrl-T (Enter Transfer) popup if you really want to
> use pop-ups for entry.
>
> -derek
>
> On Wed, July 1, 2020 5:05 pm, David Carlson wrote:
> > Back around the time the register2 rewrite was started I believe that I
> > suggested replacing the complex register code with a basic data input
> > pop-up window for the selected transaction or other input requirement
> such
> > as stock purchase, or business feature more like one would likely find in
> > a
> > database application.  I will suggest a similar design change today to
> > whomever decides to take up this task.  Unfortunately, I only know Basic
> > and Fortran IV, which wouldn't get me very far today, so my help would be
> > very limited.
> >
> > On Wed, Jul 1, 2020 at 3:38 PM Jean Laroche  wrote:
> >
> >> I started looking at that a little while before 4.0 and stopped because
> >> no new features could be added. I'm going to re-start, as this strikes
> >> me as a must-have feature.
> >> The other elephant in the room is the undo/redo support, but that's for
> >> another thread
> >> J.
> >>
> >> On 7/1/20 1:32 PM, Derek Atkins wrote:
> >> >
> >> > On Wed, July 1, 2020 4:27 pm, Jean Laroche wrote:
> >> >> Does it not trike you as insane that we have to go through these
> >> hoops
> >> >> just to bulk move transactions? Something that should be as simple as
> >> >> shift-select, right-click, move?
> >> >> I'm not sure how support for multi-select operations was never
> >> seriously
> >> >> looked at.
> >> >
> >> > Patches always welcome!
> >> >
> >> > Seriously, it's not that easy due to the design and implementation of
> >> the
> >> > register.  The register-2 rewrite was supposed to make it easier, but
> >> that
> >> > effort (started about a decade ago) stalled and never finished, so
> >> we're
> >> > still using the same Canvas-based register code.
> >> >
> >> >> J.
> >> >
> >> >> Please remember to CC this list on all your replies.
> >> >> You can do this by using Reply-To-List or Reply-All.
> >> >
> >> > -derek
> >> >
> >> ___
> >> 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
> >
>
>
> --
>Derek Atkins 617-623-3745
>de...@ihtfp.com www.ihtfp.com
>Computer and Internet Security Consultant
>
>

-- 
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] Register entry method. was: Bulk moving transactions

[David Carlson]

Sorry, I didn't expect my comment to turn into a discussion.  Therefore I
am splitting it off of the original thread

On Wed, Jul 1, 2020 at 4:14 PM David Carlson 
wrote:

> Maybe I don't know the correct terminology.  I envision the currently
> selected transaction automatically appearing in a data entry window instead
> of in the register.
>
> On Wed, Jul 1, 2020 at 4:09 PM Derek Atkins  wrote:
>
>> Popups are a very inefficient entry method.
>>
>> You already have the Ctrl-T (Enter Transfer) popup if you really want to
>> use pop-ups for entry.
>>
>> -derek
>>
>> On Wed, July 1, 2020 5:05 pm, David Carlson wrote:
>> > Back around the time the register2 rewrite was started I believe that I
>> > suggested replacing the complex register code with a basic data input
>> > pop-up window for the selected transaction or other input requirement
>> such
>> > as stock purchase, or business feature more like one would likely find
>> in
>> > a
>> > database application.  I will suggest a similar design change today to
>> > whomever decides to take up this task.  Unfortunately, I only know Basic
>> > and Fortran IV, which wouldn't get me very far today, so my help would
>> be
>> > very limited.
>> >
>> > On Wed, Jul 1, 2020 at 3:38 PM Jean Laroche  wrote:
>> >
>> >> I started looking at that a little while before 4.0 and stopped because
>> >> no new features could be added. I'm going to re-start, as this strikes
>> >> me as a must-have feature.
>> >> The other elephant in the room is the undo/redo support, but that's for
>> >> another thread
>> >> J.
>> >>
>> >> On 7/1/20 1:32 PM, Derek Atkins wrote:
>> >> >
>> >> > On Wed, July 1, 2020 4:27 pm, Jean Laroche wrote:
>> >> >> Does it not trike you as insane that we have to go through these
>> >> hoops
>> >> >> just to bulk move transactions? Something that should be as simple
>> as
>> >> >> shift-select, right-click, move?
>> >> >> I'm not sure how support for multi-select operations was never
>> >> seriously
>> >> >> looked at.
>> >> >
>> >> > Patches always welcome!
>> >> >
>> >> > Seriously, it's not that easy due to the design and implementation of
>> >> the
>> >> > register.  The register-2 rewrite was supposed to make it easier, but
>> >> that
>> >> > effort (started about a decade ago) stalled and never finished, so
>> >> we're
>> >> > still using the same Canvas-based register code.
>> >> >
>> >> >> J.
>> >> >
>> >> >> Please remember to CC this list on all your replies.
>> >> >> You can do this by using Reply-To-List or Reply-All.
>> >> >
>> >> > -derek
>> >> >
>> >> ___
>> >> 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
>> >
>>
>>
>> --
>>Derek Atkins 617-623-3745
>>de...@ihtfp.com www.ihtfp.com
>>Computer and Internet Security Consultant
>>
>>
>
> --
> David Carlson
>


-- 
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] Register entry method. was: Bulk moving transactions

[David Carlson]

Around 10 years ago I experimented with a competitive product to GnuCash
called "MyMoney" produced by MTH Software.  It was (is) based on a database
format.  The primary register view had a large area at the bottom of the
main window that served as the data entry window, and contained as many
fields as necessary to enter or edit a transaction.  This software is still
available today and there is a user manual available at
http://wiki.mthbuilt.com/.  There were multiple reasons then that I decided
early on to switch to GnuCash as my primary financial software, but their
User Interface is beautiful and efficient, in my opinion.  I would not want
to suggest design details to our developers beyond looking at their
interface as an example of what can be done.  Also, their software is
proprietary, so it cannot be copied outright.

The advantage of separating the data entry from the register is that the
data fields can not only be tailored to work within a SQL format, but they
can be designed with more layout freedom when not constrained in the
register format.  The register portion of the window does not need to show
all the transaction details, just the basic elements necessary to identify
each transaction and a running balance. And the underlying code does not
have to jump through all the U I hoops that are needed to keep everything
synchronized in all the GnuCash register variations.

I have not fired up their software in about a decade, but if I recall, it
handled simple two account transactions, complex multi-split transactions,
stock purchase and sales with capital gains all in variations of their
basic window.

David Carlson

On Wed, Jul 1, 2020 at 4:53 PM Michael or Penny Novack <
stepbystepf...@comcast.net> wrote:

> On 7/1/2020 5:24 PM, David Carlson wrote:
>
> >> Maybe I don't know the correct terminology.  I envision the currently
> >> selected transaction automatically appearing in a data entry window
> instead
> >> of in the register.
>
> What do you see when you are entering a "split" transaction?
>
> That is a "view" you are are allowed to choose to be on all the time,
> yes? Isn't that what you just asked for?
>
> Michael D Novack
>
> PS: Because this view is appearing AS IF it were in the account
> register, you might think of it as being there. It isn't. It's what
> would appear as the journal entry that will result in a line in that
> account register when it gets posted (on completion)
>
> ___
> 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] Scheduled Transactions with Securities

[David Carlson]

Not sure what you mean by template.  In older releases one could just use
an existing stock transaction to copy to a new SX and then, when Since Last
Run entered it, Gnucash would ask for a price.  Not sure if 3.11 or 4.0 is
different.   I never tried fixing a price in the SX.



On Fri, Jul 3, 2020, 10:55 AM Adrien Monteleone <
adrien.montele...@lusfiber.net> wrote:

> Does it not have a place to enter anything at all for those?
>
> In that case, no, even variables would not work.
>
> Regards,
> Adrien
>
> > On Jul 3, 2020 w27d185, at 10:49 AM, Adrien Monteleone <
> adrien.montele...@lusfiber.net> wrote:
> >
> > You should be able to use variables in SX templates. Then it will prompt
> you for a price.
> >
> > Regards,
> > Adrien
> >
> >> On Jul 3, 2020 w27d185, at 10:42 AM, Dale Alspach 
> wrote:
> >>
> >> The template for a scheduled transaction does not allow for shares or
> >> share price. When a scheduled transaction includes an account which has
> >> shares it defaults to $1 price per share. Is there anyway to get it to
> >> use something more reasonable such as the last known price?
> >
>
>
> ___
> 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] Scheduled Transactions with Securities

[David Carlson]

Now I understand your question .  True, there is no place to enter shares
or price in the SX.  Thus it is assumed that whatever total amount is
calculated by the currency part of a transaction buys or sells as many
shares as calculated by the price that the user manually enters when the
Since. Last Run assistant creates the transaction.   I am not sure if
variables can be added, but since it is possible to build scheduled loan
transactions , that may also be possible in stock transactions.   I have
never tried it.  Historically,  variables in scheduled transactions were so
poorly documented it was hard to imagine how to structure them.  I think
the improved documentation may help with that, but I am way behind with
that part of Gnucash.

On Fri, Jul 3, 2020, 12:59 PM Dale Alspach  wrote:

> This is  gnucash 3.6 on Mint 18. If I click Schedule, I get the same
> window as if I had opened the scheduled transaction editor and for the
> template tab I get a template with only 6 columns: Date (Scheduled),
> Num, Description/Notes, Unlabelled (should be Transfer), Tot Debit, Tot
> Credit.
> If I start from the security account, there is a slightly different
> first window (frequency) that opens, but clicking Advanced ends in the
> same place.
>
> Dale
>
> On 7/3/20 12:17 PM, David Carlson wrote:
> > Not sure what you mean by template.  In older releases one could just use
> > an existing stock transaction to copy to a new SX and then, when Since
> Last
> > Run entered it, Gnucash would ask for a price.  Not sure if 3.11 or 4.0
> is
> > different.   I never tried fixing a price in the SX.
> >
> >
> >
> > On Fri, Jul 3, 2020, 10:55 AM Adrien Monteleone <
> > adrien.montele...@lusfiber.net> wrote:
> >
> >> Does it not have a place to enter anything at all for those?
> >>
> >> In that case, no, even variables would not work.
> >>
> >> Regards,
> >> Adrien
> >>
> >>> On Jul 3, 2020 w27d185, at 10:49 AM, Adrien Monteleone <
> >> adrien.montele...@lusfiber.net> wrote:
> >>>
> >>> You should be able to use variables in SX templates. Then it will
> prompt
> >> you for a price.
> >>>
> >>> Regards,
> >>> Adrien
> >>>
> >>>> On Jul 3, 2020 w27d185, at 10:42 AM, Dale Alspach <
> alspac...@gmail.com>
> >> wrote:
> >>>>
> >>>> The template for a scheduled transaction does not allow for shares or
> >>>> share price. When a scheduled transaction includes an account which
> has
> >>>> shares it defaults to $1 price per share. Is there anyway to get it to
> >>>> use something more reasonable such as the last known price?
> >>>
> >>
> >>
> >> ___
> >> gnucash-user mailing list
> >> gnucash-user@gnucash.org
> >> To update your subscription preferences or to unsubscribe:
> >> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> >> If you are using Nabble or Gmane, please see
> >> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> >> -
> >> Please remember to CC this list on all your replies.
> >> You can do this by using Reply-To-List or Reply-All.
> >>
> > ___
> > gnucash-user mailing list
> > gnucash-user@gnucash.org
> > To update your subscription preferences or to unsubscribe:
> > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> > -
> > Please remember to CC this list on all your replies.
> > You can do this by using Reply-To-List or Reply-All.
> >
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Help required

[David Carlson]

Will,

In many. Cases it is better to follow the the adage "If it ain't broke,
don't fix it."

David Carlson

On Mon, Jul 6, 2020, 7:55 AM w...@theprescotts.com 
wrote:

> "Decide from those whether there are new features that you want. If not,
> there is no reason to abandon a release that you are using successfully."
>
> I would disagree. I think it is better to keep all software current. You
> may not want new features in the current latest release, but down the road
> there may be a release with features you want. If your software is many
> versions out of date, updating is always harder.
>
> Will
> ___
> 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] Help required

[David Carlson]

This thread was started by a newbie who is still learning how it works.
That person doesn't need the extra burden of finding things changing,
sometimes for the worse, while still learning.

On Mon, Jul 6, 2020 at 9:33 AM w...@theprescotts.com 
wrote:

> David,
>
> There is no one answer for everybody but I find it is better to pick a
> time when I have no emergencies and update, even if it will "fix something
> that ain't broke".
>
> Either you skip all updates until you have to, then it is a pain because
> you are way out of date and there may be no direct update path.
> Or you break working systems with updates you may not need right now and
> it is pain fixing things that weren't broken.
>
> The only guarantee is that it will be a pain either way.
>
> Will
>
> On 2020 Jul 6, at 07-06 08:35:03, David Carlson <
> david.carlson@gmail.com> wrote:
>
> Will,
>
> In many. Cases it is better to follow the the adage "If it ain't broke,
> don't fix it."
>
> David Carlson
>
> On Mon, Jul 6, 2020, 7:55 AM w...@theprescotts.com 
> wrote:
>
>> "Decide from those whether there are new features that you want. If not,
>> there is no reason to abandon a release that you are using successfully."
>>
>> I would disagree. I think it is better to keep all software current. You
>> may not want new features in the current latest release, but down the road
>> there may be a release with features you want. If your software is many
>> versions out of date, updating is always harder.
>>
>> Will
>> ___
>> 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] Gnucash - user

[David Carlson]

There has not been much warning lately about the actually very common
phishing technique of getting the malefactors ' webpage listing above the
legitimate webpage listing in searches.  David, your observation is keen.

On Tue, Jul 7, 2020, 9:15 AM david whiting  wrote:

> If you do a google search for "gnucash forum" the top two hits are results
> from nabble. If you click on either one of these you'll see the
> login/register link top left that sign you up to nabble.
>
> Perhaps this is how some people think that this is the correct way to sign
> up. They are doing something that is normal these days, a google search for
> what they want to find (gnucash forum) and aren't aware of the subtle
> difference between using nabble and signing up to the mailing list. There's
> a very good chance they won't get close to the wiki so perhaps it will make
> no difference how clearly it is described in the wiki.
>
> See attached.
>
> David
>
> On Tue, 7 Jul 2020, 14:37 Derek Atkins,  wrote:
>
> > Dear Adrian,
> >
> > On Tue, July 7, 2020 2:46 am, Adrian Holbrook wrote:
> > > Liz, I tried to respond to a posting by David Cousens [via GnuCash] and
> > it
> > > was rejected by Nabble. Could you pass on the following -
> >
> > Instead of responding via Nabble, you should just respond via Email.
> >
> > > I have also tried to contact Hugo a number of times. In frustration I
> > have
> > > used a different email address and name and registered again following
> > the
> > > instructions on the gnucashe wiki. I have the same problem. I do not
> > > unders
> > > tand the difference between posting
> > >  on the Gnucash list vs posting by Nabble - certainly following the
> wiki
> > > in
> > > structions forces you to use Nabble. as soon as you register you are
> sent
> > > an
> > > email to click on and it takes you to the Nabble subscribe form.
> >
> > This has *me* confused.  If you subscribe via any link at
> > https://lists.gnucash.org/ then I do not see how you could get an email
> > that would link to Nabble.  It sounds like you went in via Nabble the
> > first time and tried to "subscribe" via Nabble.
> >
> > > I
> > > am very confused and would love a simple
> > >  process that worked like a normal forum without having to go through
> > > hoops
> >
> > The GnuCash lists are, currently, just that: email lists.
> >
> > The GnuCash mailing lists do not have a forum or any supported forum-like
> > interface.  Nabble, a 3rd-party service, tries to present that, but as
> > you've seen they appear to be having... issues..
> >
> > This will change when (if) we migrate to mailman3, which includes the
> > "hyperkitty" forum-like interface, but at this point in time we do not
> > have a timeline for when this will happen.
> >
> > > Please remember to CC this list on all your replies.
> > > You can do this by using Reply-To-List or Reply-All.
> >
> > -derek
> >
> > --
> >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.
>
___
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 list: gmane

[David Carlson]

Using a 300 baud modem, perhaps?  I had a Radio Shack model 100

On Tue, Jul 7, 2020 at 11:27 AM Adrien Monteleone <
adrien.montele...@lusfiber.net> wrote:

> Yep, those were the days. I first cut my teeth on anything ‘internet’ via
> Usenet, before my first browser experience.
>
> Regards,
> Adrien
>
> > On Jul 7, 2020 w28d189, at 11:09 AM, Frank H. Ellenberger <
> frank.h.ellenber...@gmail.com> wrote:
> >
> > Am 07.07.20 um 16:54 schrieb Adrien Monteleone:
> >> If it is dead, we should remove the reference.
> >
> > It is not really dead, but you can currently only access it by a news
> > reader. Do you remember that kind of software?
> >
> > Regards
> > Frank
> >
> >
>
>
> ___
> 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] Reconcile also opens Interest Payment box?

[David Carlson]

While I do not use those features  myself,  if there are some who do, I
would say to keep them.  If not

On Sun, Jul 12, 2020, 11:41 AM John Ralls  wrote:

> Frank and I have both opined on
> https://bugs.gnucash.org/show_bug.cgi?id=797854 that the whole interest
> payment as part of reconciling is stupid. I want to add to that opinion
> that so is the payment transfer that optionally pops up when one finishes
> reconciling a credit card account. It's a lot of program complexity that
> relieves the user of very little work indeed: Those interest and payment
> transactions can just as easily--maybe more easily--be created in the
> register before and after reconciling, and in the case of interest they're
> an obvious candidate for a scheduled transaction.
>
> But that's a UI change and UI changes tend to generate heated
> disagreement. I want to get that out of the way up front: Who here objects
> to removing the interest and payment transfer automatic popups and the
> interest payment button on the reconcile info dialog, and what compelling
> reason do you have for objecting?
>
> Regards,
> John Ralls
>
>
> > On Jul 10, 2020, at 6:59 PM, Adrien Monteleone <
> adrien.montele...@lusfiber.net> wrote:
> >
> > Thanks Jean,
> >
> > I filed bug: https://bugs.gnucash.org/show_bug.cgi?id=797854 for the
> issue with the global preference not being honored.
> >
> > And bug: https://bugs.gnucash.org/show_bug.cgi?id=797855 for the button
> issue on the two dialogs.
> >
> > Feel free to combine them if you like. I wasn't sure of developers'
> intent with the global preference, so I filed them separately.
> >
> > Regards,
> > Adrien
> >
> > On 7/10/20 5:52 PM, Jean Laroche wrote:
> >> If you open a bug about it, I can try to fix that (move things to the
> right place etc). At the very least, the global option should be either
> fixed, or removed.
> >> Jean
> >> On 7/10/20 3:35 PM, Adrien Monteleone wrote:
> >>> For consistency, that very wide button should probably either be
> changed to a checkbox, then moved or copied to the Account Edit page as a
> per-account preference. (it could remain in the dialog for discoverability
> I suppose, which is what I mean by 'copied') One could change it in either
> place, but ideally, it should be in one place.
> >>>
> >>> I'm not sure a global preference (especially one that is ignored) is
> necessary if each account can be set separately.
> >>>
> >>> Regards,
> >>> Adrien
> >>>
> >>> On 7/10/20 5:16 PM, lj wrote:
>  I figured it out. Duh.
> 
>  There is a button on the Reconcile dialog that says "Enter Interest
> Payment". In addition to letting you enter an interest payment, clicking
> that button sets a per-account flag to always prompt for an interest
> payment when you reconcile.
> 
>  On the Interest Payment dialog, there is a button "No Auto Interest
> Payments for this Account". (It's very wide, and I didn't realize it was a
> button.) That cancels the dialog, and also clears the per-account flag so
> GnuCash will no longer prompt for interest payment when you reconcile.
> 
>  And the global preference Register, Reconciling, Automatic interest
> transfer? It does NOTHING at all. It sets a preference flag which is never
> used. It's supposed to be the default for accounts without the
> auto-interest-payment flag, but it doesn't work. Note that in
> libgnucash/engine/Account.cpp, the function
> xaccAccountGetAutoInterestXfer() ignores its default_value argument.
> >>>
> >>> ___
> >>> gnucash-user mailing list
> >>> gnucash-user@gnucash.org
> >>> To update your subscription preferences or to unsubscribe:
> >>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> >>> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> >>> -
> >>> Please remember to CC this list on all your replies.
> >>> You can do this by using Reply-To-List or Reply-All.
> >> ___
> >> gnucash-user mailing list
> >> gnucash-user@gnucash.org
> >> To update your subscription preferences or to unsubscribe:
> >> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> >> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> >> -
> >> Please remember to CC this list on all your replies.
> >> You can do this by using Reply-To-List or Reply-All.
> >
> > ___
> > gnucash-user mailing list
> > gnucash-user@gnucash.org
> > To update your subscription preferences or to unsubscribe:
> > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> > -
> > Please remember to CC this list on all your replies.
> > You can do this by using Reply-To-List or Reply-All.
>
> __

Re: [GNC] Confused About Budgeting monthly transfers

[David Carlson]

Jon,

Larry has suggested a perfectly good method to account for both your cash
flow in your budget as well as tracking the value of your IRA.

There are other methods which may be suggested by others.  One thing to
watch for is that whatever method you choose for accounting for your real
time transactions, you need to make your budget projections follow exactly
the same method.  Thus, if you show the IRA contribution as an expense in
your primary cash database, it should be shown that way in your budget.
Conversely, if you show it as a transfer to an asset account, show it that
way in your budget.

David CArlson

On Thu, Jul 16, 2020 at 5:00 PM larry johnston 
wrote:

> Jon,
>
> If I understand your question, it relates to transferring or spending money
> going into an IRA. I had a similar problem with RRSP's in Canada. When you
> transfer funds they aren't actually spent even though you have them in an
> account that you can't use. My solution which I am sure is not proper
> accounting, but seems to work for me, was to set up a separate  GNUCash
> file for RRSP's and then instead of transferring the money I spent it in my
> main file and recorded it in the RRSP file. Then my budget worked for me.
>
> Larry
>
> On Wed, Jul 15, 2020 at 3:17 AM Jon Griffith  wrote:
>
> > I'm a first time user of gnucash and I've run into a challenge that I
> can't
> > figure out.
> >
> > Preface:  My budget is a plan.  My budget is a zero based budget, meaning
> > that I start with the income I'm expecting, and I "spend" all of it until
> > nothing is left every month.  Part of that "spending" is transferring $$
> > into savings, which is a net zero Income/Expense transaction.
> >
> > Hypothetical:  Every month I receive $3000 net.  I need to "spend" 15% of
> > that by moving it to my Roth IRA.  So, I transfer $450.00 to my IRA from
> my
> > Checking account (Liquid to Non-liquid asset transfer).
> >
> > I would figure that on my Budget, I could enter $450.00 as a value for
> the
> > IRA asset account and it would be subtracted from the total at the bottom
> > of the budget in the "transfer" row thereby reducing what I have left to
> > spend for that month.
> >
> > Problem:  Some asset accounts affect the transfer value on the budget and
> > some don't.
> >
> > I understand how to do a transfer from a register, but "planning" for
> that
> > transfer such that it affects the budget bottom line seems to be spotty.
> > What am I missing?
> > ___
> > 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] Regarding a issue with GNUcash

[David Carlson]

1.  Which version of GnuCash did you install in PureOS?  Did you use a PPA
or one of the alternative installation methods?
2.  I don't understand what you mean by " I pasted that file into the
account I created".  Ordinarily you just copy the last .gnucash data file
into your new user folder.  If you had other settings to retain you might
also copy them as outlined in the wiki.
3.  That leads me to the question. Which version of GnuCash were you using
in Windows 10?  If you migrated to a different release there are
potentially other issues to watch out for.

David Carlson

On Thu, Jul 16, 2020 at 10:43 PM Dhanadhya Group 
wrote:

> Hello,
> I am quite new to the mailing list and don't know how to operate, even
> after reading the Getting Help & Mailing List pages of GNU cash. If this is
> not the correct way to request a solution regarding issues please let me
> know here.
>
> Query: I just switched from Windows 10 to PureOS. In a hurry, I took the
> latest .gnucash and .log file with me. After installing GNU cash in PureOS,
> I pasted that file into the account I created. Fortunately, all worked out
> and I got my data back. But when I enter any entry into any accounts, GNU
> cash automatically creates another entry reverting the account balance to
> the previous stage. So two entries are created by creating one, which
> results in 0 change. Deleting any one entry, deletes another one also. I am
> confused about what to do. Please assist me.
>
> Hoping to hear from you soon,
>
> Regards,
> Dhanadhya Group
> ___
> 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] simple search

[David Carlson]

There are a couple of additional details to consider:

Be sure to start either from the Accounts list window if you want to search
transaction splits in any account or from your selected account if you want
to find splits only in one account.  Remember that the search works on
individual split lines, so it will not find transfer split lines that meet
the desired criterion.

When you add criteria pay attention to whether you choose the All option or
the Any option.

When you select a value, there are choices to choose from less, equal or
more than the entered value.

David Carlosn

On Sat, Jul 18, 2020 at 9:33 PM Max Hyre  wrote:

>
> > I wish to do a search in one account for all
> > the listings of $31.99
>
>
> o Select the menu Edit > Find, which brings up a search dialogue.
> o Click the radio button `New Search'
> o Pull down the menu below `Add' and select `Account', then select the
> account you want ( or  in your example)
> o Click `Add' to get an additional search line
> o Select `Value' on the new line, then enter 31.99
> o Click the `Find' button and you'll get a new tab with the desired entries
>
>
>HTH,
>
>  Max Hyre
>
>
>
>
> ___
> 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] Unhide column

[David Carlson]

Alan,

If your computer CPU goes to 100% for a long enough time to notice, it will
not be reliable to perform any task.  That also goes for disk accesses or
any other function.  this may happen if you have several programs open, or
if some of them are resource hogs.  Web browsers often hog resources.

On Sat, Jul 18, 2020 at 2:40 PM Alan A Holmes 
wrote:

> Thanks John.
>
> I'll forget all about it.
>
>
> Alan A Holmes
>
> -Original Message-
> From: John Ralls [mailto:jra...@ceridwen.us]
> Sent: 18 July 2020 20:35
> To: Alan A Holmes
> Cc: gnucash-u...@lists.gnucash.org
> Subject: Re: [GNC] Unhide column
>
>
>
> > On Jul 18, 2020, at 12:07 PM, Alan A Holmes 
> wrote:
> >
> > Windows 10 Pro Version 2004 Build 19041.333, GnuCash Version: 3.11 Build
> ID:
> > 3.11+(2020-06-26)
> >
> >
> >
> > I've recently been having problems with my system, the system gets it's
> > knickers into a twist about which firewall it is meant to be using. The
> > system hangs as the disk is 100% active, so the system won't allow me do
> > anything. After some effort I'm gradually sorting the problem out, seems
> to
> > have been caused by the latest Windows 10 Version upgrade, but I ended up
> > running full virus scans, malware scans, getting rids of cookies etc.,
> and
> > used Spybot to get rid of anything remotely suspicious.
> >
> >
> >
> > A consequence of doing all the above is that when I started GnuCash it
> had
> > forgotten about all my open account tabs, and column widths within those
> > tabs. No major problem re-opening the tabs and adjusting the column
> widths,
> > just an inconvenience that's not the fault of GnuCash.
> >
> >
> >
> > However one thing I noticed is that when I opened my "Cash-in-Hand"
> account
> > there was an extra column to the right of "Balance". I think it might
> have
> > been called "Rate", but I'm not certain. I was resizing all the columns
> in
> > autopilot mode and accidentally moved the right hand border of this
> column
> > to the left with the result that it's now zero width. I want to resize
> the
> > column but I'm unable to do this, as when I grab the most right hand
> border
> > it just resizes the "Balance" column.
> >
> >
> >
> > I've tried deleting the account tab and re-opening it, and it opens it
> with
> > the new remembered settings.
> >
> >
> >
> > How can I resize this column please, so that I can see what it is. I
> might
> > not want it even when I have resized it, but I'd like to see what it is.
>
> You actually do want that column to remain hidden. It's for GnuCash's
> internal use.
>
> Regards,
> John Ralls=
>
>
> --
> 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.
>


-- 
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] Unhide column

[David Carlson]

Glad you figured it out.

On Sun, Jul 19, 2020, 6:32 AM Alan A Holmes 
wrote:

> Thanks David. In my case it’s the disk that’s at 100%, and the problem is
> firewall related. When the PC starts both my own firewall (Avast Firewall)
> and Windows Firewall are trying to run, however there’s a windows process
> that runs that thinks neither is running and in situation just kills the
> disk so that it’s difficult to do anything.
>
>
>
> The latest Windows upgrade has done something that affects Windows
> firewall so that it doesn’t detect that another firewall is running
> correctly. Microsoft have sort of acknowledged there’s a problem, as there
> are many 000’s having similar problems, but are claiming innocence of any
> change. It doesn’t seem to be related to a specific personal firewall, it
> seems to be any as others are using other products rather than Avast.
>
> It looks as though it’s the order that the various start-up processes run,
> as this isn’t always consistent. If the Windows process starts first it
> then doesn’t detect when a 2nd one starts. If the other starts first then
> Windows firewall does seem to detect the other is running so doesn’t start.
>
>
>
> I’ve got a temporary work around. Start the PC. If it starts okay then
> carry on as normal. If it has the problem then restart (which can take
> 20-30 minutes to get the restart option up and then to action) and it
> usually works okay, though I have once had to restart twice.
>
>
>
> I’m moving away from Avast shortly anyway, so hopefully the situation will
> improve. Until then I only shutdown or restart my laptop when it’s
> absolutely necessaryJ
>
>
>
>
>
> Alan A Holmes
>
>
>
> *From:* David Carlson [mailto:david.carlson@gmail.com]
> *Sent:* 19 July 2020 09:05
> *To:* Alan A Holmes
> *Cc:* John Ralls; GnuCash List
> *Subject:* Re: [GNC] Unhide column
>
>
>
> Alan,
>
>
>
> If your computer CPU goes to 100% for a long enough time to notice, it
> will not be reliable to perform any task.  That also goes for disk accesses
> or any other function.  this may happen if you have several programs open,
> or if some of them are resource hogs.  Web browsers often hog resources.
>
>
>
> On Sat, Jul 18, 2020 at 2:40 PM Alan A Holmes 
> wrote:
>
> Thanks John.
>
> I'll forget all about it.
>
>
> Alan A Holmes
>
> -Original Message-
> From: John Ralls [mailto:jra...@ceridwen.us]
> Sent: 18 July 2020 20:35
> To: Alan A Holmes
> Cc: gnucash-u...@lists.gnucash.org
> Subject: Re: [GNC] Unhide column
>
>
>
> > On Jul 18, 2020, at 12:07 PM, Alan A Holmes 
> wrote:
> >
> > Windows 10 Pro Version 2004 Build 19041.333, GnuCash Version: 3.11 Build
> ID:
> > 3.11+(2020-06-26)
> >
> >
> >
> > I've recently been having problems with my system, the system gets it's
> > knickers into a twist about which firewall it is meant to be using. The
> > system hangs as the disk is 100% active, so the system won't allow me do
> > anything. After some effort I'm gradually sorting the problem out, seems
> to
> > have been caused by the latest Windows 10 Version upgrade, but I ended up
> > running full virus scans, malware scans, getting rids of cookies etc.,
> and
> > used Spybot to get rid of anything remotely suspicious.
> >
> >
> >
> > A consequence of doing all the above is that when I started GnuCash it
> had
> > forgotten about all my open account tabs, and column widths within those
> > tabs. No major problem re-opening the tabs and adjusting the column
> widths,
> > just an inconvenience that's not the fault of GnuCash.
> >
> >
> >
> > However one thing I noticed is that when I opened my "Cash-in-Hand"
> account
> > there was an extra column to the right of "Balance". I think it might
> have
> > been called "Rate", but I'm not certain. I was resizing all the columns
> in
> > autopilot mode and accidentally moved the right hand border of this
> column
> > to the left with the result that it's now zero width. I want to resize
> the
> > column but I'm unable to do this, as when I grab the most right hand
> border
> > it just resizes the "Balance" column.
> >
> >
> >
> > I've tried deleting the account tab and re-opening it, and it opens it
> with
> > the new remembered settings.
> >
> >
> >
> > How can I resize this column please, so that I can see what it is. I
> might
> > not want it even when I have resized it, but I'd like to see what it is.

Re: [GNC] Bug in account selection section of register

[David Carlson]

Colin,

What is the bug number?

On Mon, Jul 20, 2020, 2:21 AM Colin  wrote:

> Hi John,
>
> Thanks for the quick reply. I can see my description of the issue was not
> very clear, because what I experienced was a clear and annoying bug. But I
> solved it after recognizing the type-ahead search was only searching among
> top-level account names. And then inferred the issue was the result of
> using a custom account separator character. I had set it to "." because
> that only takes 1 keystroke on a US keyboard, whereas ":" takes 2
> keystrokes.
>
> When I changed "." back to the default ":" the issue went away. I've gone
> ahead and filed a bug so this issue in type-ahead search can be addressed
> for anyone else using a period as their separator. For me changing back to
> the default is satisfactory. The new type ahead is great, because it means
> I don't *need *to type the separator most of the time.
>
> Interestingly, the issue didn't happen when I set the separator to a comma.
> I didn't do any more testing than that, so can't say if it happens with
> more than just a period as the separator.
>
> https://bugs.gnucash.org/show_bug.cgi?id=797864
>
> Thanks again,
> Colin
>
>
>
> On Sun, Jul 19, 2020 at 11:14 PM John Ralls  wrote:
>
> >
> >
> > > On Jul 19, 2020, at 12:44 PM, Colin  wrote:
> > >
> > > I just upgraded to 4.0 on my Mac and Linux machine, and have this bug
> on
> > > both.
> > >
> > > When entering a new item in the register of any account, if I type the
> > > account name using the old logic (type first few characters of the top
> > > account name, press the separator key, type the first few characters of
> > the
> > > next subaccount name etc) it works fine. I see a pop-up box above the
> > field
> > > with all the account names as before.
> > >
> > > If I try to use that box using the new logic (i.e. type the first few
> > > letters of the final level sub account) it doesn't work. It will not
> fill
> > > in or display that account as an option. Moreover, the popup list that
> > > shows up above displays only about 20 of my first accounts, all the
> rest
> > > are gone. This is conspicuous because I probably have close to 100
> > accounts
> > > in total.
> > >
> > > At this point, if I press delete while in that box, I can clear the
> > field.
> > > But the missing accounts in the pop-up window don't return. I have to
> > > discard the transaction entirely and start over before I can get a full
> > > account list again.
> > >
> > > I did a search of the bugzilla but didn't see this listed there since
> 4.0
> > > came out.
> >
> > Colin,
> >
> > The first part is the way the typeahead feature works: It filters the
> drop
> > down list to those accounts that contain the letters you've typed. It
> does
> > recognize your account separator so e.g. if you type "qui:bal" then
> > Equity:Opening Balances will be in the list.
> >
> > It doesn't fill in the entry with the selection, but if you've typed
> > enough so that the top item in the list is the one you want then if you
> tab
> > out it will fill in with that one. Otherwise you can use the up and down
> > arrows to select an item from the drop down. Whatever is selected will be
> > put in the entry when you tab out.
> >
> > The backspace problem is probably
> > https://bugs.gnucash.org/show_bug.cgi?id=797845 that I fixed a few
> > minutes ago.
> >
> > Regards,
> > John Ralls
> ___
> 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] Bug in account selection section of register

[David Carlson]

That's odd  I did not see that when I read it on my phone.  I do see it on
my laptop.

On Mon, Jul 20, 2020 at 7:15 AM Colin  wrote:

> Hi David,
>
> I included a link to the bug report at the end of my message. It's #797864.
>
> On Jul 20 2020, at 12:49 pm, David Carlson 
> wrote:
>
> Colin,
>
> What is the bug number?
>
> [image: Sent from Mailspring]
> On Mon, Jul 20, 2020, 2:21 AM Colin  wrote:
>
> Hi John,
>
> Thanks for the quick reply. I can see my description of the issue was not
> very clear, because what I experienced was a clear and annoying bug. But I
> solved it after recognizing the type-ahead search was only searching among
> top-level account names. And then inferred the issue was the result of
> using a custom account separator character. I had set it to "." because
> that only takes 1 keystroke on a US keyboard, whereas ":" takes 2
> keystrokes.
>
> When I changed "." back to the default ":" the issue went away. I've gone
> ahead and filed a bug so this issue in type-ahead search can be addressed
> for anyone else using a period as their separator. For me changing back to
> the default is satisfactory. The new type ahead is great, because it means
> I don't *need *to type the separator most of the time.
>
> Interestingly, the issue didn't happen when I set the separator to a comma.
> I didn't do any more testing than that, so can't say if it happens with
> more than just a period as the separator.
>
> https://bugs.gnucash.org/show_bug.cgi?id=797864
>
> Thanks again,
> Colin
>
>
>
> On Sun, Jul 19, 2020 at 11:14 PM John Ralls  wrote:
>
> >
> >
> > > On Jul 19, 2020, at 12:44 PM, Colin  wrote:
> > >
> > > I just upgraded to 4.0 on my Mac and Linux machine, and have this bug
> on
> > > both.
> > >
> > > When entering a new item in the register of any account, if I type the
> > > account name using the old logic (type first few characters of the top
> > > account name, press the separator key, type the first few characters of
> > the
> > > next subaccount name etc) it works fine. I see a pop-up box above the
> > field
> > > with all the account names as before.
> > >
> > > If I try to use that box using the new logic (i.e. type the first few
> > > letters of the final level sub account) it doesn't work. It will not
> fill
> > > in or display that account as an option. Moreover, the popup list that
> > > shows up above displays only about 20 of my first accounts, all the
> rest
> > > are gone. This is conspicuous because I probably have close to 100
> > accounts
> > > in total.
> > >
> > > At this point, if I press delete while in that box, I can clear the
> > field.
> > > But the missing accounts in the pop-up window don't return. I have to
> > > discard the transaction entirely and start over before I can get a full
> > > account list again.
> > >
> > > I did a search of the bugzilla but didn't see this listed there since
> 4.0
> > > came out.
> >
> > Colin,
> >
> > The first part is the way the typeahead feature works: It filters the
> drop
> > down list to those accounts that contain the letters you've typed. It
> does
> > recognize your account separator so e.g. if you type "qui:bal" then
> > Equity:Opening Balances will be in the list.
> >
> > It doesn't fill in the entry with the selection, but if you've typed
> > enough so that the top item in the list is the one you want then if you
> tab
> > out it will fill in with that one. Otherwise you can use the up and down
> > arrows to select an item from the drop down. Whatever is selected will be
> > put in the entry when you tab out.
> >
> > The backspace problem is probably
> > https://bugs.gnucash.org/show_bug.cgi?id=797845 that I fixed a few
> > minutes ago.
> >
> > Regards,
> > John Ralls
> ___
> 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] Importing Transactions from Bank

[David Carlson]

That depends on the method used.  OFX imports of well formed data do not
import transactions more than once because each transaction has a unique
identifier.  QIF imports and CSV imports depend on 'training' to recognize
duplicates because there is no unique identifier in each transaction.

On Mon, Jul 20, 2020 at 5:04 PM Jean Laroche  wrote:

> GC does not re-import transactions that have previously been imported.
>
> On 7/20/20 2:43 PM, Jon Griffith wrote:
> > Is Gnucash smart enough to recognize transactions that have already been
> > imported, or do we have to keep tight tabs on the import date range?
> >
> ___
> 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] $0 total balances wrongly appearing on Balance Sheet.

[David Carlson]

I am curious.  Is it possible for this behavior to occur if

1) a commodity account has a balance of zero shares but a residual value
because it has a unrealized gain or loss.

2) a commodity account actually has a tiny share balance or residual value
below the threshold visible at the account display resolution, likely due
to rounding errors in transactions.

David Carlson

On Mon, Jul 27, 2020 at 12:12 PM Adrien Monteleone <
adrien.montele...@lusfiber.net> wrote:

> Sorry, the report appears to be working correctly for me on MacOS
> (10.15.6) using GnuCash 4.1.
>
> The 1st option should be the only one you need to toggle the zero
> balanced accounts from appearing.
>
> The 2nd option will remove just the zero figure but retain the account
> name if the 1st option is checked.
>
> Let's use an example where 'Cash' has a 0.00 balance,
>
>
> If you uncheck both options you'll see:
>
> Cash 0.00
>
> If 1st option is unchecked, second option checked, you'll see:
>
> Cash
>
> If 1st option is checked, the second option is now irrelevant, and
> you'll see nothing about 'Cash' at all.
>
> Or at least that is the way I think it is supposed to work.
>
> Regards,
> Adrien
>
> On 7/27/20 11:01 AM, peterb wrote:
> > I've encountered a bit of a Scooby Doo mystery, and I'm hoping someone
> can
> > help me figure it out.
> >
> > My Balance Sheet report consistently includes commodity accounts with 0
> > balance figures for me, even when I've unchecked "Include accounts with
> > zero total balances."  Trying to reproduce this with a brand-new book for
> > demo purposes doesn't show this behavior, so I'm left assuming there's
> > something about my file that is odd.
> >
> > Specifically, there are two options under "Display" for Balance sheet, to
> > wit:
> >
> > • Include accounts with zero total balances
> > • Omit zero balance figures
> >
> > I would expect that having the first option UN-checked and the second
> > option checked would result in my stock accounts with 0 shares in them
> > appearing; sadly, they're all over the report.
> >
> > In contrast, the "Balance Sheet using eguile-gnc" report has an option
> > (under "Accounts", not "Display" this time) of "Exclude accounts with
> zero
> > total balances".  Checking this option achieves what I'd consider the
> right
> > result - no zero balance values are shown.
> >
> > After further experimentation, there seems to be an interaction with the
> > "Levels of Subaccounts" control on the Accounts tab of the report
> options.
> > If I increase the levels of subaccounts accordingly, or flatten the list
> to
> > the depth limit, the 0 balance figures don't appear - again, only (so
> far)
> > in this one file.
> >
> > So I have two workarounds to the problem (either using the eguile report,
> > or adjusting the depth limit/flattening options), but I am still
> concerned
> > that I don't understand why the behavior is happening in the first place.
> >
> > My questions are:
> > (1) Has anyone else seen this behavior?
> > (2) If so, do you understand what's triggering it?
>
> ___
> 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] Import Transaction Matcher issue in v4

[David Carlson]

> perhaps it's a Citibank issue, but I did not have this problem on
> v2
> >> or
> >> > v3.
> >> > >>
> >> > >> Thanks all.  I appreciate the help.
> >> > >>
> >> > >> Michael
> >> > >>
> >> > >>
> >> > >> On Sat, Jul 4, 2020 at 9:48 AM Fross, Michael 
> >> > wrote:
> >> > >>
> >> > >>> Hello all,
> >> > >>>
> >> > >>> I typically download QFX files from my banks every day or two,
> >> import
> >> > them
> >> > >>> to clear them in Gnucash.  Worked great.  However, ever since
> >> > upgrading to
> >> > >>> v4, the importer seems to have trouble matching.  Most of the
> >> imported
> >> > >>> transactions are listed in the importer as (A)dd, but when I
> select
> >> > >>> (C)lear for them it says match missing.
> >> > >>>
> >> > >>> This has occurred for several accounts.  Here is a simple credit
> >> card
> >> > >>> example, although for my checking account, there are dozens like
> >> > this.  The
> >> > >>> top portion shows the register with the Sprint bill cleared.  The
> >> date,
> >> > >>> amount, and name (mostly) match.
> >> > >>>
> >> > >>> [image: image.png]
> >> > >>>
> >> > >>> Not sure if there is just something wrong with my setup or not.
> >> > Perhaps a
> >> > >>> bug?  Are others experiencing this?  Any ideas to get the matcher
> >> > matching
> >> > >>> again?  Something need to get cleared out?
> >> > >>>
> >> > >>> For those of us in the US, happy Independence Day.  Thank you all
> >> for
> >> > your
> >> > >>> assistance.
> >> > >>>
> >> > >>> Michael
> >> > >>>
> >> > >> ___
> >> > >> gnucash-user mailing list
> >> > >> gnucash-user@gnucash.org
> >> > >> To update your subscription preferences or to unsubscribe:
> >> > >> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> >> > >> If you are using Nabble or Gmane, please see
> >> > https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> >> > >> -
> >> > >> Please remember to CC this list on all your replies.
> >> > >> You can do this by using Reply-To-List or Reply-All.
> >> > > ___
> >> > > gnucash-user mailing list
> >> > > gnucash-user@gnucash.org
> >> > > To update your subscription preferences or to unsubscribe:
> >> > > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> >> > > If you are using Nabble or Gmane, please see
> >> > https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> >> > > -
> >> > > Please remember to CC this list on all your replies.
> >> > > You can do this by using Reply-To-List or Reply-All.
> >> >
> >> > ___
> >> > gnucash-user mailing list
> >> > gnucash-user@gnucash.org
> >> > To update your subscription preferences or to unsubscribe:
> >> > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> >> > If you are using Nabble or Gmane, please see
> >> > https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> >> > -
> >> > Please remember to CC this list on all your replies.
> >> > You can do this by using Reply-To-List or Reply-All.
> >> >
> >> ___
> >> gnucash-user mailing list
> >> gnucash-user@gnucash.org
> >> To update your subscription preferences or to unsubscribe:
> >> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> >> If you are using Nabble or Gmane, please see
> >> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> >> -
> >> Please remember to CC this list on all your replies.
> >> You can do this by using Reply-To-List or Reply-All.
> >>
> >
> ___
> 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] Import Transaction Matcher issue in v4

[David Carlson]

There is another use case which GnuCash also needs to handle.  Some OFX
files may contain both sides of an inter-account transfer between two
accounts within the same bank because the OFX file can include multiple
accounts.  In fact, I do that on a regular basis at one of my banks.  I do
not test GnuCash's handling of these because I want to get the separate
notes associated with each side and merge them together into the same
transaction in my data file.  Thus I deliberately call both of them New
rather than try to match them within the import process.  I have not
checked to see if they have unique FITID's, but they would be under
different ACCOUNTID's  and both can be accepted as New in release 2.6.19
and prior, which is the latest version that I use.  I suppose ideally I
would like gnuCash to detect this case and automatically apply the
corresponding notes to both sides of the  transfer, so I don't have to do
it manually.

David Carlson

On Mon, Jul 27, 2020 at 5:23 PM Fross, Michael  wrote:

> Got it. Thanks.  Now I understand why it used to work.  And I certainly
> wouldn't expect GnuCash to correct a bank's horrible behavior.  I'll keep
> an eye on the FITID and see if that's what they are doing.
>
> Thanks everyone for your help.  Much appreciated.
>
> Michael
>
> On Mon, Jul 27, 2020 at 5:13 PM Jean Laroche  wrote:
>
> > Ah, OK I get it now!
> > Yes, you should check that from one day to the next, the FTID returned
> > by citibank remains the same (for the same transaction). If not, then
> > that's going to be a problem.
> > What has changed recently with GC is that it not will not match a new
> > imported transaction with one from the register that has an online id.
> > Previous versions allowed that, so in your case, it's quite possible
> > that from one day to the next, the same transaction would be given a
> > different ID, but GC matched it to the same register transaction that
> > was previously matched.
> > So, on day 1, you'd match OFX1->Reg1, and on day two, you'd still match
> > OFX2 -> reg1, even though reg1 had already been matched to OFX1 the
> > previous day. So you'd see OFX2 appear as "match" and not "Add".
> >
> > The correct behavior is that OFX2 actually has the same ID as OFX1, and
> > it's entirely skipped by GC. But it seems that your bank is messing
> > their online ID, and this is what's causing the issue for you, along
> > with the new GC behavior.
> >
> > I'm not sure how to fix your problem. It's clearly a bank issue but
> > that's not terribly helpful as far as your problem goes. We should
> > probably add an option to defeat the new GC import behavior,
> > specifically for users like you whose bank send unreliable FTIDs/
> >
> > FYI, the new GC behavior was added because the old behavior was causing
> > issues with people who had recurring daily transactions: imagine buying
> > a cup of coffee every day: in that case GC will match all daily cups of
> > coffee to the same register transaction (within a date range, of course)
> > instead of adding the new one every day (which really is the correct way
> > to do it).
> >
> >
> >
> > Jean
> >
> >
> > On 7/27/20 2:45 PM, Fross, Michael wrote:
> > > Hi Jean.  Let me try to better explain my issue.
> > >
> > > On most days, I download QFX files from my Checking and Credit Card
> > > accounts and import them.  In this way I clear transactions and I can
> > > see what's going on.  The next day I'll do so again, and the importer
> > > skips those that have already been matched per your comment.s  I've
> been
> > > doing this for years and it's worked well.
> > >
> > > Since I updated to V4 the transactions that would have matched
> > > previously now come up with "Match Missing!" in the importer.  I don't
> > > want to add them as they would create duplicates.  Transactions that
> are
> > > not cleared seem to be able to be matched.  But those that are
> > > previously cleared get the "Match Missing!" issue.
> > >
> > > Now, based on what you told me, the QFX file for a problem transaction
> > > has a FITID that is one higher than the ONLINE_ID in the gnucash file
> > > for the same transaction.  So the Match Missing items seems to be
> > correct.
> > >
> > > If I duplicate the transaction, delete the original, it matches which I
> > > assume is because there is not an ONLINE_ID associated with the new
> one.
> > >
> >

Re: [GNC] Import Transaction Matcher issue in v4

[David Carlson]

Michael,

Exactly.  The QFX file only contains the information that the bank would
put on your monthly account statement along with the necessary
infrastructure to identify which bank created the file and which account
and the time frame which the file describes and sometimes some additional
information that GnuCash may or may not use.  GnuCash has to synthesize the
rest in order to create a list of full double-entry qualified
transactions.  That is why the import wizard is so difficult for users to
work with and even more difficult for developers to code.

Unfortunately most of us are very sloppy technically in talking of the file
as if it is a transaction list when it is really more like a bank
statement.

On Mon, Jul 27, 2020 at 8:57 PM Fross, Michael  wrote:

> Hello David,
>
> In looking at the QFX file, I only see one side of the transaction.  This
> file has 3 distinct transactions ( records) that are not related
> and only one account ID is listed.
>
> Michael
>
> On Mon, Jul 27, 2020 at 5:56 PM David Carlson 
> wrote:
>
>> There is another use case which GnuCash also needs to handle.  Some OFX
>> files may contain both sides of an inter-account transfer between two
>> accounts within the same bank because the OFX file can include multiple
>> accounts.  In fact, I do that on a regular basis at one of my banks.  I do
>> not test GnuCash's handling of these because I want to get the separate
>> notes associated with each side and merge them together into the same
>> transaction in my data file.  Thus I deliberately call both of them New
>> rather than try to match them within the import process.  I have not
>> checked to see if they have unique FITID's, but they would be under
>> different ACCOUNTID's  and both can be accepted as New in release 2.6.19
>> and prior, which is the latest version that I use.  I suppose ideally I
>> would like gnuCash to detect this case and automatically apply the
>> corresponding notes to both sides of the  transfer, so I don't have to do
>> it manually.
>>
>> David Carlson
>>
>> On Mon, Jul 27, 2020 at 5:23 PM Fross, Michael  wrote:
>>
>>> Got it. Thanks.  Now I understand why it used to work.  And I certainly
>>> wouldn't expect GnuCash to correct a bank's horrible behavior.  I'll keep
>>> an eye on the FITID and see if that's what they are doing.
>>>
>>> Thanks everyone for your help.  Much appreciated.
>>>
>>> Michael
>>>
>>> On Mon, Jul 27, 2020 at 5:13 PM Jean Laroche  wrote:
>>>
>>> > Ah, OK I get it now!
>>> > Yes, you should check that from one day to the next, the FTID returned
>>> > by citibank remains the same (for the same transaction). If not, then
>>> > that's going to be a problem.
>>> > What has changed recently with GC is that it not will not match a new
>>> > imported transaction with one from the register that has an online id.
>>> > Previous versions allowed that, so in your case, it's quite possible
>>> > that from one day to the next, the same transaction would be given a
>>> > different ID, but GC matched it to the same register transaction that
>>> > was previously matched.
>>> > So, on day 1, you'd match OFX1->Reg1, and on day two, you'd still match
>>> > OFX2 -> reg1, even though reg1 had already been matched to OFX1 the
>>> > previous day. So you'd see OFX2 appear as "match" and not "Add".
>>> >
>>> > The correct behavior is that OFX2 actually has the same ID as OFX1, and
>>> > it's entirely skipped by GC. But it seems that your bank is messing
>>> > their online ID, and this is what's causing the issue for you, along
>>> > with the new GC behavior.
>>> >
>>> > I'm not sure how to fix your problem. It's clearly a bank issue but
>>> > that's not terribly helpful as far as your problem goes. We should
>>> > probably add an option to defeat the new GC import behavior,
>>> > specifically for users like you whose bank send unreliable FTIDs/
>>> >
>>> > FYI, the new GC behavior was added because the old behavior was causing
>>> > issues with people who had recurring daily transactions: imagine buying
>>> > a cup of coffee every day: in that case GC will match all daily cups of
>>> > coffee to the same register transaction (within a date range, of
>>> course)
>>> > instead of adding the new one every day (which really is the correct
>>> way
&

Re: [GNC] Can't find file

[David Carlson]

Use your operating system file manager to check the folder where you
normally keep your file.

What has recently changed?  We can give more specific suggestions if you
tell us which version of GnuCash you have and your computer operating
system.

David Carlson

On Thu, Jul 30, 2020, 5:08 AM Dan Bilich  wrote:

> Been using Gnucash for years. Tried to open today and got the message that
> it couldn’t find the file and it opened to a new, blank slate. What do I do
> to recover?
> ___
> 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.