Re: [GNC] Delay during data entry

[AC]

Windows 10 is fully 64-bit just like Windows 11, there's no difference 
in how they handle RAM. The different flavors of each version of Windows 
(Home, Pro, Enterprise, etc.) have different maximum amounts but they 
are the same for 10 vs. 11. I have Pro which has support for a maximum 
of 2 TB installed. The Home versions have a maximum of 128 GB.


I do have autosave turned on but the frequency is set for 5 minutes so 
that shouldn't be interfering with several back to back entries that 
only take 5 to 10 seconds to enter.


As for why I'm using Version 4.12, because it works for what I need and 
upgrading is painful because the customizations I made (for example, 
theming the program to make it dark) doesn't transfer easily. As far as 
I can tell there's nothing in the change logs for later versions there 
is nothing that appears to affect me directly so I don't see a need to 
change. I don't use the online quote functions, nor the business 
functions, and I rarely run reports so the default reports seem to be fine.


On 2024-05-06 03:48, Maria Inmaculada de la Torre wrote:

Hello All,

I am running Windows 11 with 16Gb of RAM and Gnucash Build ID: 5.6+. The
only time I notice some delays during data entry is when it is doing
autosaves and in this version I'd say it is more like 1 or 2 seconds at
most (older versions in Windows 10 had maybe a 3 or 4 seconds delay at
most). Can Windows 10 even handle that amount of RAM properly? and why are
you running such an old version of Gnucash in that machine?

Thanking you.

Regards,


Inma


On Sun, 5 May 2024 at 21:57, AC  wrote:


No, I do mean 128 GB RAM. Storage is 20 TB locally and 160 TB on the
network (but the data for Gnucash is stored on the local disks). It's
one of three daily drivers, this one being the Windows one for some CAD
software and MS Office.

There's no latency anywhere else on the system, just in Gnucash after
I've entered a transaction and it does its own processing in the
background.

On 2024-05-02 01:49, WR D wrote:

128GB of ram?  Can I assume you actually mean disk storage, not "RAM",

or that's one beast of a machine.


I use the default install of Gnucash for windows (latest stable version)

- my local drives are NVME M.2 - so reasonably fast to boot up typically.


My Gnucash file is 3.5MB and my Win 11 desktop is about 3 years old with

16GB RAM and  Intel i5-9500 @3Ghz (in-built graphics).   I see variable 1-2
seconds delay while entering transaction data ... just enough to annoy me
as I don't notice it with any other software.


I just put it down to the gnucash software, and not my hardware.  For

example I run MS Office 2021 software without noticeable delays while
inputting.



-Original Message-
From: gnucash-user 

On Behalf Of AC

Sent: Thursday, 2 May 2024 5:13 PM
To: GnuCash users group 
Subject: Re: [GNC] Delay during data entry

On the machine running Gnucash it's a Win 10 with 128 GB of RAM. I'm

using version 4.12 with build ID 4.12+2022-09-24. According to the system
profiler the entire Gnucash process is occupying about 175 MB working set
RAM (physical in use), 119 MB active primary RAM (physical unable to be
used by other processes), 56 MB shared RAM, and 550 MB commit size
(allocated virtual by OS). I do notice a slightly higher cycle time
compared to other idle programs (most idle programs use 0 to

1 cycles while Gnucash is using 4 to 5 when idle).

I do not use an SQL backend and I don't have compression turned on. The

current file size is around 42 MB. It's on a spinning SAS drive local to
the computer so I'm not dealing with network latency (though with no SQL
backend it's entirely RAM transaction anyway).


On 2024-05-01 16:28, David Carlson wrote:

Those of us who are still running versions as old as 4.8, possibly
because we are not ready to tackle setting up a flatpak in Linux still
see horrible response times.  It gets worse when the data file when
loaded takes up over half of the RAM in our machine or if we are
running it in a virtual machine.  My version 4.8 Gnucash instance
takes about 11.3 Meg when saved or 2.4 Gig of RAM when loaded in Linux
Lite 6.6.  The entire virtual machine has 8 Gig of RAM but every time
I press enter it takes several seconds before the curser returns, or
15 seconds or more when I execute File >Save, which needs to be done
every few minutes.  Some of the delay comes from having too many
registers open.  I realize most of my misery is self inflicted, since
I have now tried working on the same data in release
5.6.1 on a Windoze 10 machine with 32 Gig RAM, which almost keeps up
with my slow typing.  It is still going to take a while to revise my
procedures to get away from GnuCash release 4.8 and have the level of
hardware and software redundancy that I want to keep backups, etc.

On Wed, May 1, 2024 at 4:36 PM R Losey  wrote:


I don't see any delays on either Windows (Win 10, 16G RAM), or my M1
iMac (Sonoma 14.4.1; 16G RAM), or or Linux (Ubunto 22.

Re: [GNC] Delay during data entry

[AC]

No, I do mean 128 GB RAM. Storage is 20 TB locally and 160 TB on the 
network (but the data for Gnucash is stored on the local disks). It's 
one of three daily drivers, this one being the Windows one for some CAD 
software and MS Office.


There's no latency anywhere else on the system, just in Gnucash after 
I've entered a transaction and it does its own processing in the background.


On 2024-05-02 01:49, WR D wrote:

128GB of ram?  Can I assume you actually mean disk storage, not "RAM",  or 
that's one beast of a machine.

I use the default install of Gnucash for windows (latest stable version) - my 
local drives are NVME M.2 - so reasonably fast to boot up typically.

My Gnucash file is 3.5MB and my Win 11 desktop is about 3 years old with 16GB 
RAM and  Intel i5-9500 @3Ghz (in-built graphics).   I see variable 1-2 seconds 
delay while entering transaction data ... just enough to annoy me as I don't 
notice it with any other software.

I just put it down to the gnucash software, and not my hardware.  For example I 
run MS Office 2021 software without noticeable delays while inputting.


-Original Message-
From: gnucash-user  On 
Behalf Of AC
Sent: Thursday, 2 May 2024 5:13 PM
To: GnuCash users group 
Subject: Re: [GNC] Delay during data entry

On the machine running Gnucash it's a Win 10 with 128 GB of RAM. I'm using 
version 4.12 with build ID 4.12+2022-09-24. According to the system profiler 
the entire Gnucash process is occupying about 175 MB working set RAM (physical 
in use), 119 MB active primary RAM (physical unable to be used by other 
processes), 56 MB shared RAM, and 550 MB commit size (allocated virtual by OS). 
I do notice a slightly higher cycle time compared to other idle programs (most 
idle programs use 0 to
1 cycles while Gnucash is using 4 to 5 when idle).

I do not use an SQL backend and I don't have compression turned on. The current 
file size is around 42 MB. It's on a spinning SAS drive local to the computer 
so I'm not dealing with network latency (though with no SQL backend it's 
entirely RAM transaction anyway).

On 2024-05-01 16:28, David Carlson wrote:

Those of us who are still running versions as old as 4.8, possibly
because we are not ready to tackle setting up a flatpak in Linux still
see horrible response times.  It gets worse when the data file when
loaded takes up over half of the RAM in our machine or if we are
running it in a virtual machine.  My version 4.8 Gnucash instance
takes about 11.3 Meg when saved or 2.4 Gig of RAM when loaded in Linux
Lite 6.6.  The entire virtual machine has 8 Gig of RAM but every time
I press enter it takes several seconds before the curser returns, or
15 seconds or more when I execute File >Save, which needs to be done
every few minutes.  Some of the delay comes from having too many
registers open.  I realize most of my misery is self inflicted, since
I have now tried working on the same data in release
5.6.1 on a Windoze 10 machine with 32 Gig RAM, which almost keeps up
with my slow typing.  It is still going to take a while to revise my
procedures to get away from GnuCash release 4.8 and have the level of
hardware and software redundancy that I want to keep backups, etc.

On Wed, May 1, 2024 at 4:36 PM R Losey  wrote:


I don't see any delays on either Windows (Win 10, 16G RAM), or my M1
iMac (Sonoma 14.4.1; 16G RAM), or or Linux (Ubunto 22.04LTS, 8G RAM).
In all cases, the file is stored on my NAS with spinning hard drives
(that is, not an SSD), and I am saving to a compressed file (I've not
changed this since I started, so I assume that these are the default
settings).  My file size is about 2.2M

Could it be that you are saving to a SQL database? I remember reading
here that (unlike the standard option) it saves after every
transaction. Maybe the database is on a slowish drive?

Otherwise, I don't know why there would be such a lengthy delay after
doing an entry.

I assume you've run the Check/Repair just to verify that there isn't
some file problem?



On Wed, May 1, 2024 at 12:00 AM AC  wrote:


Just as a curiosity what is going on under the hood that influences
the delay after entering data into a register row? I notice that
after I enter the details of a transaction into a register and
commit the changes (pressing enter or tabbing to next row) there is
a 5 to 7 second delay before I can enter the next transaction.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.




--
_
Richard Losey
rlo...@gmail.com
Micah 6:8
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mai

Re: [GNC] Delay during data entry

[AC]

On the machine running Gnucash it's a Win 10 with 128 GB of RAM. I'm 
using version 4.12 with build ID 4.12+2022-09-24. According to the 
system profiler the entire Gnucash process is occupying about 175 MB 
working set RAM (physical in use), 119 MB active primary RAM (physical 
unable to be used by other processes), 56 MB shared RAM, and 550 MB 
commit size (allocated virtual by OS). I do notice a slightly higher 
cycle time compared to other idle programs (most idle programs use 0 to 
1 cycles while Gnucash is using 4 to 5 when idle).


I do not use an SQL backend and I don't have compression turned on. The 
current file size is around 42 MB. It's on a spinning SAS drive local to 
the computer so I'm not dealing with network latency (though with no SQL 
backend it's entirely RAM transaction anyway).


On 2024-05-01 16:28, David Carlson wrote:

Those of us who are still running versions as old as 4.8, possibly because
we are not ready to tackle setting up a flatpak in Linux still see horrible
response times.  It gets worse when the data file when loaded takes up over
half of the RAM in our machine or if we are running it in a virtual
machine.  My version 4.8 Gnucash instance takes about 11.3 Meg when saved
or 2.4 Gig of RAM when loaded in Linux Lite 6.6.  The entire virtual
machine has 8 Gig of RAM but every time I press enter it takes several
seconds before the curser returns, or 15 seconds or more when I execute
File >Save, which needs to be done every few minutes.  Some of the delay
comes from having too many registers open.  I realize most of my misery is
self inflicted, since I have now tried working on the same data in release
5.6.1 on a Windoze 10 machine with 32 Gig RAM, which almost keeps up with
my slow typing.  It is still going to take a while to revise my procedures
to get away from GnuCash release 4.8 and have the level of hardware and
software redundancy that I want to keep backups, etc.

On Wed, May 1, 2024 at 4:36 PM R Losey  wrote:


I don't see any delays on either Windows (Win 10, 16G RAM), or my M1 iMac
(Sonoma 14.4.1; 16G RAM), or or Linux (Ubunto 22.04LTS, 8G RAM). In all
cases, the file is stored on my NAS with spinning hard drives (that is, not
an SSD), and I am saving to a compressed file (I've not changed this since
I started, so I assume that these are the default settings).  My file size
is about 2.2M

Could it be that you are saving to a SQL database? I remember reading here
that (unlike the standard option) it saves after every transaction. Maybe
the database is on a slowish drive?

Otherwise, I don't know why there would be such a lengthy delay after doing
an entry.

I assume you've run the Check/Repair just to verify that there isn't some
file problem?



On Wed, May 1, 2024 at 12:00 AM AC  wrote:


Just as a curiosity what is going on under the hood that influences the
delay after entering data into a register row? I notice that after I
enter the details of a transaction into a register and commit the
changes (pressing enter or tabbing to next row) there is a 5 to 7 second
delay before I can enter the next transaction.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.




--
_
Richard Losey
rlo...@gmail.com
Micah 6:8
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] Delay during data entry

[AC]

Just as a curiosity what is going on under the hood that influences the 
delay after entering data into a register row? I notice that after I 
enter the details of a transaction into a register and commit the 
changes (pressing enter or tabbing to next row) there is a 5 to 7 second 
delay before I can enter the next transaction.

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Transferring mutual funds

[AC]

Yes it is a total transfer as if I had a basket of widgets in my 
kitchen, picked it up and placed it in my neighbor's kitchen. The 
widgets didn't change, only the storage location.


I'm able to log into the new broker's website and see the entire history 
of each fund since I first purchased shares even though I've only been 
with the broker for a week. There just doesn't seem to be a good method 
for handling something like this or at least not one that is obvious.


Even if there's some kind of hackery/kludgery needed it would be useful 
to know how that works and maybe could be addressed as part of a future 
feature request. As I mentioned before it's academic because I don't use 
Gnucash's reports to perform any critical tasks like tax computations 
but if someone has done it in a way that worked I'd really like to know.


On 2023-07-06 19:09, R Losey wrote:

If it's truly some kind of rollover, Gnucash does allow an exchange of
shares without a price. But I don't know how you'd keep the cost basis in
the new account.


On Wed, Jul 5, 2023 at 5:49 PM David Carlson 
wrote:


AC,

Yes, to keep GnuCash happy you want to transfer the cost basis as well as
the securities to the new brokerage account.  By entering the transactions
as a sale at the same price that you purchased the the security and a new
purchase at that same price, you are transferring the cost basis, Since
that is not a real sale, there is no realized gain or loss to report to the
taxman until you really do sell

If you didn't transfer the cost, then GnuCash would think that the old
account still had a cost for a now non-existent asset and the new account
got the security free.  You may have to provide that same information to
your broker or custodian if they didn't get it automatically.



On Wed, Jul 5, 2023 at 3:31 PM AC  wrote:


Answering two at once:

Fred: No I did not work in split view. I was just working at the single
account level.

David: Are you saying I need to instruct GnuCash to treat the transfer
as a sale even though there was no sale thus no realized gains/losses
and no actual change in the cost basis?

On 2023-07-05 10:07, David Carlson wrote:

AC,

Fred implied, but didn't elaborate on the point that the shares in the
original brokerage account had a cost basis that was incurred when they
were purchased.  When you transfer them out, that is equivalent to a

sale

or closing transaction, and the cost basis should be adjusted

accordingly,

even though there were no funds involved.  Of course, that exact cost

basis

needs to be added to the receiving account as if the shares were

purchased

at the original price.  This used to be described in great detail in

one

of

the help manuals, including the somewhat tricky procedure to enter

realized

gains when an actual sale happens but I haven't checked lately to see

if

those parts are still there.  I know that if you do not do those things

and

later run a trial balance or if you use the Investment Portfolio

report,

you will quickly see the error of your ways.



On Wed, Jul 5, 2023 at 11:33 AM Fred Bone  wrote:


On 04 July 2023 at 16:29, AC said:


I recently moved some mutual funds from one brokerage to another. The
process did not involve a sale, it was just a transfer of control

from

the

old to the new.

In my current books I keep mutual funds listed as subaccount under

each

brokerage as such with their respective security/currency:

Investments
-Brokerage 1 (currency)
--Fund A (security A)
--Fund B (security B)
-Brokerage 2 (currency)
--Fund A (security A)
--Fund C (security C)
--Fund D (security D)

I wanted to expand this to add the new brokerage and then perform a
transfer of the funds from one to the other. Let's assume I moved the
funds under Brokerage 1 to Brokerage 3. So the tree would look like

the

simplified version below (leaving out Brokerage 2 as it is

unaffected):


Investments
-Brokerage 1 (currency)
--Fund A (security A)
--Fund B (security B)
-Brokerage 3 (currency)
--Fund A (security A)
--Fund B (security B)

The securities are the same because it's the same original mutual

funds,

just moved to another brokerage. The tree would be left intact with

the

funds under Brokerage 1 being zeroed out and the funds under

Brokerage

3

starting off with the incoming values.

My natural tendency was to create a transfer directly within

Brokerage

1

Fund A that moved all the shares over to Brokerage 3 Fund A but that
didn't create the transaction I expected.

By example, I transferred Fund A on July 1 which contained 10 shares

at

the price of the shares on that day. So in Brokerage 1 I entered -10
shares with a total sell price of X as listed on the statement from
Brokerage 1. The price is autocalculated and the balance correctly

goes

to

zero.

Looking inside the Brokerage 3 Fund A account I only see a

transaction

that has an amount in the buy column but no shares and a balance of

zero.

I can manually enter the same number

Re: [GNC] Transferring mutual funds

[AC]

I just took a look at the Advanced Portfolio report to see what GC 
thought about what I had done. It does appear that the basis was lost as 
part of the transfer because for each of the funds that transferred over 
the new basis is exactly the value at the time of the transfer instead 
of the original basis.


I'll try on a copy of my file just moving the investments over to see 
how the report behaves. I don't actually use this report (in fact this 
is the first time I've opened it).


I took a look at the tutorials but there isn't anything that covers 
outright transfer of a fund nor is there anything about how to update 
the basis costs and dates (or where the Advanced Portfolio report looks 
to get its basis data).


I'd like to understand the mechanism that I'd need to use for Gnucash to 
actually accomplish this type of transaction as an academic exercise. 
I'm not affected by the errors because anything having to do with taxes 
will use the original source materials/statements instead of a Gnucash 
report. It would be a useful piece of knowledge to also avoid painting 
myself into a corner where Gnucash actually breaks in some way because 
of conflicting entries. Plus, since the transfers occurred only this 
month there's very little data that I have to replace in order to make 
changes.


On 2023-07-06 08:40, David T. via gnucash-user wrote:

Kalpesh,

Your assessment regarding capital gains rates is accurate; it's been one of my problems 
with this issue for some time. It also comes up with stock splits, where the 
"new" shares should have the original acquisition date. Honestly, this is not 
an easy issue to finesse without a boatload of work.

For what it's worth (most likely not a lot), when I had a brokerage change many 
years back, I created a new account in GnuCash for that brokerage, and simply 
moved the stock accounts into that new brokerage account. It probably violates 
17 rules of accounting, but it worked for me.

⁣David T. ​

On Jul 6, 2023, 3:39 PM, at 3:39 PM, Kalpesh Patel  
wrote:

Hmmm. So I am a bit perplexed here.

Disclaimer: I am a new-bee when it comes minutiae's of the investment
transactions so I might be wrong what I am about to state. Feel free to
correct me.

If you note such factitious sale or closing of the transaction to
preserve the cost basis as you mentioned, are you not altering how long
the security is held which will impact capital gains reporting? If you
alter in such a way, I am not sure if that is same thing as
transferring the security to another account, at least not the way
brokerages do so in the US amongst them or within them.

Would you not want to simply move the original buy/sell transaction by
re-pointing one of the split line item from the old account to new one?
This I would think keeps the entire transaction intact as-is which what
the transfer should be about and then you can have a zero valued
transaction on the date of the transfer itself which would have no
impact on any reporting.


-Original Message-
From: David Carlson 
Sent: Wednesday, July 05, 2023 1:08 PM
To: f...@mandfb.me.uk
Cc: AC ; gnucash-user@gnucash.org
Subject: Re: [GNC] Transferring mutual funds

AC,

Fred implied, but didn't elaborate on the point that the shares in the
original brokerage account had a cost basis that was incurred when they
were purchased.  When you transfer them out, that is equivalent to a
sale or closing transaction, and the cost basis should be adjusted
accordingly, even though there were no funds involved.  Of course, that
exact cost basis needs to be added to the receiving account as if the
shares were purchased at the original price.  This used to be described
in great detail in one of the help manuals, including the somewhat
tricky procedure to enter realized gains when an actual sale happens
but I haven't checked lately to see if those parts are still there.  I
know that if you do not do those things and later run a trial balance
or if you use the Investment Portfolio report, you will quickly see the
error of your ways.



On Wed, Jul 5, 2023 at 11:33 AM Fred Bone  wrote:


On 04 July 2023 at 16:29, AC said:


I recently moved some mutual funds from one brokerage to another.
The process did not involve a sale, it was just a transfer of
control from

the

old to the new.

In my current books I keep mutual funds listed as subaccount under
each brokerage as such with their respective security/currency:

Investments
-Brokerage 1 (currency)
--Fund A (security A)
--Fund B (security B)
-Brokerage 2 (currency)
--Fund A (security A)
--Fund C (security C)
--Fund D (security D)

I wanted to expand this to add the new brokerage and then perform a



transfer of the funds from one to the other. Let's assume I moved
the funds under Brokerage 1 to Brokerage 3. So the tree would look
like the simplified version below (leaving out Brokerage 2 as it is

unaffected):


Investments
-Brokerage 1 (currency)
--Fund A (security A)
--Fund B (security B)

Re: [GNC] Transferring mutual funds

[AC]

Since these funds have been held since before I started using Gnucash I 
can't really carry over any cost basis within it. I won't worry about it 
too much because I am not using the reports directly and I don't use 
Gnucash for my taxes. However, it appears it handled it anyway because 
the top-level brokerage account shows a value of zero now because all 
the underlying funds have zeroed out and the new brokerage account shows 
roughly the original value of the old account.


Fortunately with ACATs (Automated Customer Account Transfer) all of the 
data and metadata transferred from one brokerage to the other. I'm able 
to see all of the historic basis values at the new brokerage site for 
all the funds. One less thing to worry about.


On 2023-07-05 15:48, David Carlson wrote:

AC,

Yes, to keep GnuCash happy you want to transfer the cost basis as well as
the securities to the new brokerage account.  By entering the transactions
as a sale at the same price that you purchased the the security and a new
purchase at that same price, you are transferring the cost basis, Since
that is not a real sale, there is no realized gain or loss to report to the
taxman until you really do sell

If you didn't transfer the cost, then GnuCash would think that the old
account still had a cost for a now non-existent asset and the new account
got the security free.  You may have to provide that same information to
your broker or custodian if they didn't get it automatically.



On Wed, Jul 5, 2023 at 3:31 PM AC  wrote:


Answering two at once:

Fred: No I did not work in split view. I was just working at the single
account level.

David: Are you saying I need to instruct GnuCash to treat the transfer
as a sale even though there was no sale thus no realized gains/losses
and no actual change in the cost basis?

On 2023-07-05 10:07, David Carlson wrote:

AC,

Fred implied, but didn't elaborate on the point that the shares in the
original brokerage account had a cost basis that was incurred when they
were purchased.  When you transfer them out, that is equivalent to a sale
or closing transaction, and the cost basis should be adjusted

accordingly,

even though there were no funds involved.  Of course, that exact cost

basis

needs to be added to the receiving account as if the shares were

purchased

at the original price.  This used to be described in great detail in one

of

the help manuals, including the somewhat tricky procedure to enter

realized

gains when an actual sale happens but I haven't checked lately to see if
those parts are still there.  I know that if you do not do those things

and

later run a trial balance or if you use the Investment Portfolio report,
you will quickly see the error of your ways.



On Wed, Jul 5, 2023 at 11:33 AM Fred Bone  wrote:


On 04 July 2023 at 16:29, AC said:


I recently moved some mutual funds from one brokerage to another. The
process did not involve a sale, it was just a transfer of control from

the

old to the new.

In my current books I keep mutual funds listed as subaccount under each
brokerage as such with their respective security/currency:

Investments
-Brokerage 1 (currency)
--Fund A (security A)
--Fund B (security B)
-Brokerage 2 (currency)
--Fund A (security A)
--Fund C (security C)
--Fund D (security D)

I wanted to expand this to add the new brokerage and then perform a
transfer of the funds from one to the other. Let's assume I moved the
funds under Brokerage 1 to Brokerage 3. So the tree would look like the
simplified version below (leaving out Brokerage 2 as it is unaffected):

Investments
-Brokerage 1 (currency)
--Fund A (security A)
--Fund B (security B)
-Brokerage 3 (currency)
--Fund A (security A)
--Fund B (security B)

The securities are the same because it's the same original mutual

funds,

just moved to another brokerage. The tree would be left intact with the
funds under Brokerage 1 being zeroed out and the funds under Brokerage

3

starting off with the incoming values.

My natural tendency was to create a transfer directly within Brokerage

1

Fund A that moved all the shares over to Brokerage 3 Fund A but that
didn't create the transaction I expected.

By example, I transferred Fund A on July 1 which contained 10 shares at
the price of the shares on that day. So in Brokerage 1 I entered -10
shares with a total sell price of X as listed on the statement from
Brokerage 1. The price is autocalculated and the balance correctly goes

to

zero.

Looking inside the Brokerage 3 Fund A account I only see a transaction
that has an amount in the buy column but no shares and a balance of

zero.

I can manually enter the same number of shares in that partially empty
transaction but why was my thought about the transfer incorrect? Should

it

have not transferred those shares over as well?


Did you work in split view?

I can replicate what I think you are saying if I don't enter the

separate

splits.

If I go about it the obvious way (in split view) and enter

Re: [GNC] Transferring mutual funds

[AC]

Answering two at once:

Fred: No I did not work in split view. I was just working at the single 
account level.


David: Are you saying I need to instruct GnuCash to treat the transfer 
as a sale even though there was no sale thus no realized gains/losses 
and no actual change in the cost basis?


On 2023-07-05 10:07, David Carlson wrote:

AC,

Fred implied, but didn't elaborate on the point that the shares in the
original brokerage account had a cost basis that was incurred when they
were purchased.  When you transfer them out, that is equivalent to a sale
or closing transaction, and the cost basis should be adjusted accordingly,
even though there were no funds involved.  Of course, that exact cost basis
needs to be added to the receiving account as if the shares were purchased
at the original price.  This used to be described in great detail in one of
the help manuals, including the somewhat tricky procedure to enter realized
gains when an actual sale happens but I haven't checked lately to see if
those parts are still there.  I know that if you do not do those things and
later run a trial balance or if you use the Investment Portfolio report,
you will quickly see the error of your ways.



On Wed, Jul 5, 2023 at 11:33 AM Fred Bone  wrote:


On 04 July 2023 at 16:29, AC said:


I recently moved some mutual funds from one brokerage to another. The
process did not involve a sale, it was just a transfer of control from

the

old to the new.

In my current books I keep mutual funds listed as subaccount under each
brokerage as such with their respective security/currency:

Investments
-Brokerage 1 (currency)
--Fund A (security A)
--Fund B (security B)
-Brokerage 2 (currency)
--Fund A (security A)
--Fund C (security C)
--Fund D (security D)

I wanted to expand this to add the new brokerage and then perform a
transfer of the funds from one to the other. Let's assume I moved the
funds under Brokerage 1 to Brokerage 3. So the tree would look like the
simplified version below (leaving out Brokerage 2 as it is unaffected):

Investments
-Brokerage 1 (currency)
--Fund A (security A)
--Fund B (security B)
-Brokerage 3 (currency)
--Fund A (security A)
--Fund B (security B)

The securities are the same because it's the same original mutual funds,
just moved to another brokerage. The tree would be left intact with the
funds under Brokerage 1 being zeroed out and the funds under Brokerage 3
starting off with the incoming values.

My natural tendency was to create a transfer directly within Brokerage 1
Fund A that moved all the shares over to Brokerage 3 Fund A but that
didn't create the transaction I expected.

By example, I transferred Fund A on July 1 which contained 10 shares at
the price of the shares on that day. So in Brokerage 1 I entered -10
shares with a total sell price of X as listed on the statement from
Brokerage 1. The price is autocalculated and the balance correctly goes

to

zero.

Looking inside the Brokerage 3 Fund A account I only see a transaction
that has an amount in the buy column but no shares and a balance of zero.
I can manually enter the same number of shares in that partially empty
transaction but why was my thought about the transfer incorrect? Should

it

have not transferred those shares over as well?


Did you work in split view?

I can replicate what I think you are saying if I don't enter the separate
splits.

If I go about it the obvious way (in split view) and enter balancing
amounts then it all works.

However, I'm still on 2.6.21 ...

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] Transferring mutual funds

[AC]

I recently moved some mutual funds from one brokerage to another. The 
process did not involve a sale, it was just a transfer of control from 
the old to the new.


In my current books I keep mutual funds listed as subaccount under each 
brokerage as such with their respective security/currency:


Investments
-Brokerage 1 (currency)
--Fund A (security A)
--Fund B (security B)
-Brokerage 2 (currency)
--Fund A (security A)
--Fund C (security C)
--Fund D (security D)

I wanted to expand this to add the new brokerage and then perform a 
transfer of the funds from one to the other. Let's assume I moved the 
funds under Brokerage 1 to Brokerage 3. So the tree would look like the 
simplified version below (leaving out Brokerage 2 as it is unaffected):


Investments
-Brokerage 1 (currency)
--Fund A (security A)
--Fund B (security B)
-Brokerage 3 (currency)
--Fund A (security A)
--Fund B (security B)

The securities are the same because it's the same original mutual funds, 
just moved to another brokerage. The tree would be left intact with the 
funds under Brokerage 1 being zeroed out and the funds under Brokerage 3 
starting off with the incoming values.


My natural tendency was to create a transfer directly within Brokerage 1 
Fund A that moved all the shares over to Brokerage 3 Fund A but that 
didn't create the transaction I expected.


By example, I transferred Fund A on July 1 which contained 10 shares at 
the price of the shares on that day. So in Brokerage 1 I entered -10 
shares with a total sell price of X as listed on the statement from 
Brokerage 1. The price is autocalculated and the balance correctly goes 
to zero.


Looking inside the Brokerage 3 Fund A account I only see a transaction 
that has an amount in the buy column but no shares and a balance of 
zero. I can manually enter the same number of shares in that partially 
empty transaction but why was my thought about the transfer incorrect? 
Should it have not transferred those shares over as well?

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Search and Replace

[AC]

I'm a bit disappointed that this thread went off in a different 
direction and never addressed actual search and replace.


Is it even on the roadmap or do I still have to resort to butchering the 
XML file?


On 2023-04-29 10:58, Stan Brown wrote:



On 2023-04-29 08:32, Gyle McCollam wrote:

On your second point, there’s also  menu option Transaction-> Cancel> 
Transaction to undo any unwanted changes.


I was unaware that this existed. The description in the help manual
makes it sound just like clicking Delete on an unfinished transaction.

By experiment I found that Cancel Transaction doesn't do anything on a
transaction that has been committed with the Enter key. Is that the only
difference between Cancel and Delete, or are there others?



___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Blue line in checking account register window

[AC]

Your case is specific but you stated it as a general fact that "Most 
computers do not have an AUTOMATIC sync to real time." That statement is 
demonstrably false and I'm pointing that out. When you are "speaking 
from the perspective of somebody who does NOT live in an urban area" 
then you are only referring to your case at hand which is not the same 
as the original blanket statement.


The mechanics of how a particular device determines the time and 
location is not material to the fact that it will TRY to do so in the 
way it was programmed. If it fails it will have fallback logic but it 
does try and refutes your original blanket statement. In many cases the 
fallback will assume the last timezone and just keep automatically 
updating its time using that previous timezone.


Since NTP doesn't care about timezones as it works entirely in UTC, any 
device looking for the time will get the correct UTC and simply apply 
the wrong offset at worst.  Cellphones near timezone borders have 
experienced this problem for years which is why you can change your 
timezone manually on the phone but automatic time updates will still 
happen.  Even some much older devices like alarm systems and door access 
controllers had dial-up time setting capabilities that would dial into 
NIST or USNO and set the time by modem. The UTC is transmitted and the 
local device accounts for timezone offset. With the availability of time 
via modem and NTP over the Internet, location has never been a concern 
for keeping a clock synchronized. The offset may be incorrect for human 
users of that device but the clock itself will be synchronized.


Geolocation is improving with time and for the purposes of determining a 
time zone will more likely than not return a correct result. There are 
always corner cases to any automated logic but that doesn't stop the 
device from trying.



On 2022-07-10 07:24, Michael or Penny Novack wrote:



Actually, out of the box both MacOS since around Sierra and Windows 
10/11 do indeed set up automatic clock synchronization as well as 
location tracking unless the user explicitly disables either or both 
of these features. So if you buy a shiny new laptop in New York state 
and boot up there, then without changing any settings fly to 
California and boot up again, your clock will change to display the 
correct local time. 


Actually, I am always speaking from the perspective of somebody who does 
NOT live in an urban area. Even a cell phone HERE (at my house) would 
not know where it was, as there is no cell service available. Nor, when 
various things try to figure out where I am by IP address, does that 
give MY location but instead the location of the server to which my 
connection goes. Reasonably close now but that would have been much 
farther away back before cable reached here as a dial-up provider or a 
satellite provider might be almost anywhere. Most PC's do not have GPS 
hardware.


Now in my case, the network is close enough (to determine time zone) But 
consider the similar mountainous rural area in TN where that state meets 
GA and AL (TN is not just in one time zone). Whether you were located in 
a "hollow" or up on a ridge would determine if you had cell service. If 
you did have cable internet, the server would likely be located some 
distance off, say the nearest decent size city, Chattanooga, but you 
might not be in that time zone (same likely if located just across the 
state line in AL). No cable yet so still connected by dial-up or 
satellite? Then the network to which connected could be FAR off.


Michael D Novack

PS -- For our business users - in rural areas along state boundaries 
ZIP code is not a reliable indication of the state in which that address 
is located. Postal mail delivery routes do not respect state boundaries. 
Because this is not widely known, you are unlikely to get into trouble 
with the authorities if this causes you to incorrectly charge sales tax. 
But be prepared for a customer to complain of you charge them sales tax 
on something their state does not tax << if you make the mistake in the 
other direction, they are unlikely to complain >> Few businesses collect 
"state" information. Where I used to work, did, but that involved 
contracts, and so which state's contract laws applied was important.


___
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 

Re: [GNC] Blue line in checking account register window

[AC]

On 2022-07-09 15:50, Michael or Penny Novack wrote:



c. (For the sake of completeness) Invent a time machine, jump forward
past the dates of the under-the-blue-line transactions, sync your
computer top a time source, and run GnuCash.


For further completeness, the time machine is not absolutely necessary. 
Most computers do not have an AUTOMATIC sync to real time. In other 
words, the internal "clock" of the computer is something you can set to 
whatever time/date you want. You typically tell the computer where it is 
located during set up (time zone, etc.). If you take the computer with 
you on a journey to the other coast, it won't "know" that.


Michael D Novack


Actually, out of the box both MacOS since around Sierra and Windows 
10/11 do indeed set up automatic clock synchronization as well as 
location tracking unless the user explicitly disables either or both of 
these features. So if you buy a shiny new laptop in New York state and 
boot up there, then without changing any settings fly to California and 
boot up again, your clock will change to display the correct local time.

___
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] Scrolling of the accounts tabs

[AC]

Yes, that's the context menu.

On 2022-01-09 22:09, David H wrote:

Yes long gone from memory ;-)  Try right clicking on a tab to bring up a
list of the current tabs and click on the tab you want.  Works for a
horizontal tab strip so I'm gueesing it works for the vertical tabs as well
?

cheers David H.


On Mon, 10 Jan 2022 at 15:56, AC  wrote:


So in 2.6 land I used to be able to scroll the list of account tabs with
the mouse wheel when the list (vertical list, to the left of the
register) was taller than the available space without causing the
currently selected account to change.  The arrows at the top and bottom
of the list of tabs would change the selected tab and work its way
through the list.

In 4.8 land the arrows still function as before but scrolling the tabs
with the wheel is gone. I'm only left with the context menu to browse
through the list. I'm going to assume yet another GTK-ism due to the
switch to the later GTK because I don't see a setting for that.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.





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

[GNC] Scrolling of the accounts tabs

[AC]

So in 2.6 land I used to be able to scroll the list of account tabs with 
the mouse wheel when the list (vertical list, to the left of the 
register) was taller than the available space without causing the 
currently selected account to change.  The arrows at the top and bottom 
of the list of tabs would change the selected tab and work its way 
through the list.


In 4.8 land the arrows still function as before but scrolling the tabs 
with the wheel is gone. I'm only left with the context menu to browse 
through the list. I'm going to assume yet another GTK-ism due to the 
switch to the later GTK because I don't see a setting for that.

___
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 Red negative numbers with gtk-theme enabled

[AC]

Yes, that worked.  Odd that the code itself isn't generating the red 
text when using the dark theme unless the built-in style sheet missed 
it.  At least the external CSS is available in this instance.


On 2022-01-09 17:46, Glenn Fowler wrote:

Right,

You have to add any overrides. Try:

/* Negative number color */
.gnc-class-negative-numbers {
color: red;
}

This may help as well to tweak other things:

https://github.com/Gnucash/gnucash/blob/maint/doc/gtk-3.0.css
https://wiki.gnucash.org/wiki/GTK3#Cascading_Style_Sheets_.28CSS.29

On Sun, Jan 9, 2022 at 8:10 PM AC  wrote:


Right, I already have that file for other items but I don't have
anything in there that's controlling the font color.  That's why I asked
if there is indeed a CSS class for negative numbers or if that's hard
coded into Gnucash itself.

On 2022-01-09 17:06, Glenn Fowler wrote:

On my Windows 10 machine I had to add "gtk-3.0.css" to
..\AppData\Roaming\GnuCash to override any defaults


On Sun, Jan 9, 2022 at 7:21 PM AC  wrote:


As part of trying to get a dark theme for Gnucash I enabled GTK's dark
theme:

gtk-application-prefer-dark-theme=true

But with that enabled negative numbers no longer show up in red, they're
all in white.  I don't have any customized CSS that selects for a font
color so it shouldn't be that.

Is this a CSS accessible property or a direct code-driven property?  If
it's code driven why is it not overriding the theme?

Where did the GTK themes get stashed on Windows?  I can't find a theme
anywhere in APPDATA (Local or Roaming), and nothing obvious in Program
Files (x86).
___

___
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] No Red negative numbers with gtk-theme enabled

[AC]

Right, I already have that file for other items but I don't have 
anything in there that's controlling the font color.  That's why I asked 
if there is indeed a CSS class for negative numbers or if that's hard 
coded into Gnucash itself.


On 2022-01-09 17:06, Glenn Fowler wrote:

On my Windows 10 machine I had to add "gtk-3.0.css" to
..\AppData\Roaming\GnuCash to override any defaults


On Sun, Jan 9, 2022 at 7:21 PM AC  wrote:


As part of trying to get a dark theme for Gnucash I enabled GTK's dark
theme:

gtk-application-prefer-dark-theme=true

But with that enabled negative numbers no longer show up in red, they're
all in white.  I don't have any customized CSS that selects for a font
color so it shouldn't be that.

Is this a CSS accessible property or a direct code-driven property?  If
it's code driven why is it not overriding the theme?

Where did the GTK themes get stashed on Windows?  I can't find a theme
anywhere in APPDATA (Local or Roaming), and nothing obvious in Program
Files (x86).
___

___
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] No Red negative numbers with gtk-theme enabled

[AC]

As part of trying to get a dark theme for Gnucash I enabled GTK's dark 
theme:


gtk-application-prefer-dark-theme=true

But with that enabled negative numbers no longer show up in red, they're 
all in white.  I don't have any customized CSS that selects for a font 
color so it shouldn't be that.


Is this a CSS accessible property or a direct code-driven property?  If 
it's code driven why is it not overriding the theme?


Where did the GTK themes get stashed on Windows?  I can't find a theme 
anywhere in APPDATA (Local or Roaming), and nothing obvious in Program 
Files (x86).

___
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] Coloring the Action field

[AC]

That's what I figured. No worries, I'll deal with the text-only fields. 
 I've adjusted the columns widths enough that, in combination with 
white text on a dark overall theme, the text is a little more pronounced 
than it was when it was the light green/yellow registers with black text.


It's still a fun thought but GTK's widgeting/layering system could use 
some work.


On 2021-12-17 13:32, John Ralls wrote:

It's not supported and it wouldn't be easy to implement in a general way. Gtk 
nodes aren't HTML or XML elements with attributes, so Gtk CSS styling can't 
query attributes as a selector.

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.

Re: [GNC] Coloring the Action field

[AC]

Sorry Michael, I didn't miss the suggestion, it's just not applicable to 
my question. I was not asking for advice on accounting methods or 
changing workflow.  I was asking about a specific 
programming/theming/coding question for the software itself.


I already have many account tabs open already, I don't want more. I also 
don't want to create new account structures for temporary holding 
accounts that I then have to open up to see what's happening (see 
previous statement in this paragraph). I don't even use the imbalance 
account because I never enter anything imbalanced in the first place.



On 2021-12-17 09:11, Michael or Penny Novack wrote:

On 12/17/2021 1:06 AM, AC wrote:


I DO NOT want to open yet another register every time I want to look 
for transactions that need to be updated. I prefer just to skim 
through the checking account register which has a variety of 
transactions both fully documented and some that are awaiting 
documentation (final split amounts, transaction IDs from the bank, etc.) 


I think you missed a very important part of the suggestion I was making.

Yes this involves another "register" (account) but you would not be 
"looking through it" to find which transactions needed to be fixed. ANY 
transaction that you found there would need to be fixed and once fixed 
would no longer be there. Think for a moment of how "Imbalance" works. 
Any transactions you find in Imbalance need to be fixed and once fixed 
disappears,  from Imbalance. This would work like that.


Part of the problem might be not ever having done bookkeeping the old 
fashioned way, entering transactions into the "journal" and then 
"posting" to the "ledger". Essentially what happens when you enter 
"split mode" is that you are seeing what would have been the journal 
entry for that transaction and when you complete that split what you 
have as that journal entry gets "posted" to the ledger.


Michael D Novack



___
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] Coloring the Action field

[AC]

Yeah, I know there's a good likelihood that it isn't supported but I 
figured with all the CSS support maybe I'd get lucky and there was 
support for attribute selection like there is in regular browser CSS. 
But then that's a GTK ask and not necessarily a GnuCash ask.


The general thought if such an attribute selector were supported would 
then be something like:


.gnc-register#registerid .gnc-action-field[value="Payment"] { 
background-color: rgba(255,0,0,0.5); }



Again, this is more likely a GTK ask since I'm sure it would take actual 
code in the notebook handler routines to have per register action colors.


On 2021-12-16 22:27, David Carlson wrote:

So far no developer has replied to this thread, so we do not know if there
are any 'hooks' under the hood to hang this request on, or if it would
require substantial development work to implement.

One path forward would be to create an Enhancement Request Bug Report in
the GnuCash Bugzilla https://wiki.gnucash.org/wiki/Bugzilla.

On Fri, Dec 17, 2021 at 12:09 AM AC  wrote:


No, I don't like the loan wizard.  I already tried it and I still need
to flag the transactions to find them later in the register so I can fix
the splits correctly.  The wizard doesn't save me any time.



Why not point to the loan wizard and how it can setup an automated
transaction schedule?  Sure, it is off a few pennies every so often but
if a person is looking at the loan details a their bank (or get a
monthly statement) it is easy to adjust the existing transactions.

Once you understand the resulting schedule formula, you can modify for
extra monthly payments and won't need the wizard to setup the next loan.



___
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] Coloring the Action field

[AC]

No, I don't like the loan wizard.  I already tried it and I still need 
to flag the transactions to find them later in the register so I can fix 
the splits correctly.  The wizard doesn't save me any time.




Why not point to the loan wizard and how it can setup an automated 
transaction schedule?  Sure, it is off a few pennies every so often but 
if a person is looking at the loan details a their bank (or get a 
monthly statement) it is easy to adjust the existing transactions.


Once you understand the resulting schedule formula, you can modify for 
extra monthly payments and won't need the wizard to setup the next loan.




___
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] Coloring the Action field

[AC]

No, actually I know exactly what I want to accomplish and the colored 
field to make the particular transaction stand out in the register is 
precisely what I want to do.  That's how I work.


I already have the splits set up exactly they way they need to be.  I 
just don't have the specific amounts in the splits, I have approximate 
amounts.  If it's the loan, it's exactly the same transaction as all the 
fully documented transactions, the total is the same because it's a 
fixed amount, I just have a nominal placeholder for loan principle and 
loan interest splits.  I just want to go back and edit those later.


I DO NOT want to open yet another register every time I want to look for 
transactions that need to be updated. I prefer just to skim through the 
checking account register which has a variety of transactions both fully 
documented and some that are awaiting documentation (final split 
amounts, transaction IDs from the bank, etc.)


On 2021-12-16 10:05, Michael or Penny Novack wrote:
It might perhaps be better to describe WHAT you want to accomplish 
instead of asking about possibilities for the first HOW that came to 
your mind. Why? Because there might be other "hows" even simpler.



On 12/16/2021 2:25 AM, AC wrote:


For example, I have a couple loans that are paid fixed amounts each 
month but the split of principal and interest varies (of course). I 
have automatic payments at the bank set up to pay those fixed amounts 
regularly and I have a matching scheduled transaction in GnuCash that 
is a placeholder for it so I know how much comes out of my checking 
account. What I don't know at that moment is the split between 
principal and interest.
I'll reword that -- you don't have access (in advance) to the 
amortization schedule and even if you did, would not help with an 
automated transaction (but would if a manual transaction_


  When the payment has gone through I will check the loan records 
wherever the loan is held to see how they distributed the payment and 
then go back and update the splits to reflect that.


I do a similar thing for my paychecks, setting up a scheduled 
transaction with an estimated amount across splits and then go back to 
update the splits with the various amounts withheld from the check (I 
mark these as "Deposit"). 


Let's stop here for a second to describe your PROCESS. In either case, 
you first need to be able to have an automatic transaction (unsplit) 
that you later need to go back to in order to split once you have the 
information to do that. You think you need a "marker" of some sort to 
find the transaction later, to mark the ones you have not yet done.


But what was the other side of the transaction?. Let's do the loan one 
first. That was an automatic (scheduled) transaction, credit to your 
bank account and debit to (there are always tow sides in double entry 
bookkeeping) what? Let's say for am moment you had an account under 
Expense with a name like "unallocated loan payments".


Every so often you look. Is the balance of this account zero? No, then 
you have a loan payment you have not yet allocated to principle and 
interest. Assuming enough time has passed that you have that 
information, Enter split mode. Change the account "unallocated loan 
payments" to "interest" and the amount to what that portion is. The 
remainder will now have an account Imbalance which you change to "loan 
principle".


Now THAT transaction will no longer appear in "unallocated loan 
payments" << and if there are no other payments still not allocated the 
balance of the account  will be zero >>


In  other words, the very presence of a transaction in "unallocated loan 
balance" can serve as your "marker" and is the transaction you want to 
split. You can do the same for your paychecks, except you would use an 
account under Income "unallocated paychecks".


Michael D Novack


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.

-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


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

[GNC] Coloring the Action field

[AC]

I don't think I see this anywhere within the accessible settings but is 
it possible for the background of the Action field in a register to 
change color based on its contents?


I don't use the Action field much but I've found one particular use: to 
flag entries for transactions that I've entered placeholders/estimates 
but that I need to go back later and update with new values.


For example, I have a couple loans that are paid fixed amounts each 
month but the split of principal and interest varies (of course). I have 
automatic payments at the bank set up to pay those fixed amounts 
regularly and I have a matching scheduled transaction in GnuCash that is 
a placeholder for it so I know how much comes out of my checking 
account. What I don't know at that moment is the split between principal 
and interest.


For these placeholders I add the Action flag "Payment" since text in the 
Action column is a little more obvious as the column is sparsely 
populated compared to the Description/Notes and other fields.  When the 
payment has gone through I will check the loan records wherever the loan 
is held to see how they distributed the payment and then go back and 
update the splits to reflect that.


I do a similar thing for my paychecks, setting up a scheduled 
transaction with an estimated amount across splits and then go back to 
update the splits with the various amounts withheld from the check (I 
mark these as "Deposit").


Having a colored field would be fantastic since I could make that stand 
out quickly.  It would have to be per register/account since I know that 
the Action field has a bunch of different preloaded values depending on 
the account type and I also understand that it's a free text field.


I figured it's not hard to ask if something like that is sort of 
possible and I'm not hurt if it can't or won't be done. This is more 
just a "hey this would be useful to me, maybe someone thought the same 
and tried it" post.

___
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] Colored account tabs in 4.8 don't show current selection

[AC]

Yeah, the inspector didn't help me much to find that so I'm probably 
just not going to worry about it.  I tried the one thing I thought was 
correct from the inspector output and it didn't change.


On 2021-12-13 12:46, Adrien Monteleone wrote:

That is likely the highlight color of the base theme.

Regards,
Adrien

On 12/13/21 2:40 PM, AC wrote:
That was it.  I added padding-right: 5px; to the tabs and the blue bar 
is now visible.


I'm not sure how to change that bar's color since I'd like to do 
something that stands out mroe against the dark gray but at least it's 
there so I know what I've selected.


___
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] Colored account tabs in 4.8 don't show current selection

[AC]

That was it.  I added padding-right: 5px; to the tabs and the blue bar 
is now visible.


I'm not sure how to change that bar's color since I'd like to do 
something that stands out mroe against the dark gray but at least it's 
there so I know what I've selected.


On 2021-12-13 10:57, Adrien Monteleone wrote:

Your CSS might be at play.

I'm using 4.8 and I have some tabs colored. They show the blue line just 
like the non-colored tabs.


However, I have some padding/margin around these colors, so it looks 
more like a high-lighter effect. (the base color of the tab is still 
visible around the custom color) Perhaps your margin or padding needs to 
be examined, particularly on the right. It might only take a few px to 
expose the blue line.


Regards,
Adrien

On 12/13/21 12:42 AM, AC wrote:
After having gotten the main registers to all use dark themes I tried 
using colored tabs for the first time.  That indeed has been helpful 
to make it easy to spot particular accounts from a big list of tabs 
(all bank accounts are one color, credit cards another, etc.)


But one thing I noticed is that for tabs that do not use color, the 
currently selected account tab has a vertical blue bar to its right 
(assuming the tabs are aligned on the left side of the screen) and the 
shade of the tab changes slightly (i.e. dark gray tabs in the dark 
theme turn a slightly lighter shade of gray).


However, when using color for the tabs, the blue bar does not appear 
when you select a colored tab.  The color completely overrides 
everything so you can't tell at a glance which of the tabs you've 
selected.


I'll have to go back and drop color from the accounts for now because 
it'll be too easy to not notice which account I'm using and start 
entering things. Has anyone else experienced this? Is there 
potentially a workaround to bring the selector color back while still 
using colored account tabs?


___
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] Colored account tabs in 4.8 don't show current selection

[AC]

I've only added some GTK CSS to control the register colors and to 
control the margin and padding of the tabs so they wouldn't take as much 
space.



The CSS I used is very minimal, this is its extent:

* {
color: white;
}

.gnc-class-user-register-primary {
background-color: #151515;
color: white;
}
.gnc-class-user-register-secondary {
background-color: #252525;
color: white;
}
.gnc-class-user-register-secondary:disabled {
  color: #050505;
}
.gnc-class-user-register-cursor {
  background-color: goldenrod;
  color: black;
  border-radius: 0px;
}

.gnc-class-register-split {
  background-color: #050505;
}

tabs, tab {
margin: 0px;
padding: 0px;
}

I also did add this setting for GTK to switch to the dark theme:
[Settings]
gtk-application-prefer-dark-theme=true

And that's it.  The blue highlight works fine with the above 
modifications as long as I have not assigned a color to an account.



On 2021-12-12 23:28, David Carlson wrote:

That is interesting, and not the way it used to be in release 3.8.  There
the colored tabs (mine are across the top) all get the blue highlight when
selected and the text of the selected tab is bold while the rest are not.
Did you do any customizing of the color scheme in your machine beyond what
you can do in the preferences?

On Mon, Dec 13, 2021 at 12:43 AM AC  wrote:


After having gotten the main registers to all use dark themes I tried
using colored tabs for the first time.  That indeed has been helpful to
make it easy to spot particular accounts from a big list of tabs (all
bank accounts are one color, credit cards another, etc.)

But one thing I noticed is that for tabs that do not use color, the
currently selected account tab has a vertical blue bar to its right
(assuming the tabs are aligned on the left side of the screen) and the
shade of the tab changes slightly (i.e. dark gray tabs in the dark theme
turn a slightly lighter shade of gray).

However, when using color for the tabs, the blue bar does not appear
when you select a colored tab.  The color completely overrides
everything so you can't tell at a glance which of the tabs you've selected.

I'll have to go back and drop color from the accounts for now because
it'll be too easy to not notice which account I'm using and start
entering things. Has anyone else experienced this? Is there potentially
a workaround to bring the selector color back while still using colored
account tabs?
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.






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

[GNC] Colored account tabs in 4.8 don't show current selection

[AC]

After having gotten the main registers to all use dark themes I tried 
using colored tabs for the first time.  That indeed has been helpful to 
make it easy to spot particular accounts from a big list of tabs (all 
bank accounts are one color, credit cards another, etc.)


But one thing I noticed is that for tabs that do not use color, the 
currently selected account tab has a vertical blue bar to its right 
(assuming the tabs are aligned on the left side of the screen) and the 
shade of the tab changes slightly (i.e. dark gray tabs in the dark theme 
turn a slightly lighter shade of gray).


However, when using color for the tabs, the blue bar does not appear 
when you select a colored tab.  The color completely overrides 
everything so you can't tell at a glance which of the tabs you've selected.


I'll have to go back and drop color from the accounts for now because 
it'll be too easy to not notice which account I'm using and start 
entering things. Has anyone else experienced this? Is there potentially 
a workaround to bring the selector color back while still using colored 
account tabs?

___
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] Version 4.6 Upgrade Oddities

[AC]

On 2021-12-11 10:10, Jack Frillman via gnucash-user wrote:
I just upgraded my Linux system to Fedora 34 and it in the process it 
upgraded GNC to 4.6 where previously it was 4.4.

Two of my settings/preferences were undone:

1 - The prices in an investment account is now in fractions, which BTW 
is unreadable, where before (in version 4.4)  I had it as a 5 place 
decimal number. I can't find were to set this.
2 - I have colors assigned to each account. In version 4.4 the color set 
both the tab color and background color of account names in the account 
tab. There is now no option to set the background color of account names 
in the account tab. So, how do I do this?


Thanks.



For decimal prices:
Edit Menu -> Preferences -> Numbers, Date & Time:
Checkbox: "Force prices to display as decimals"

For account colors:

Edit Menu -> Preferences -> Accounts:
Two checkboxes:
Show the Account Color as background
Show the Account Color on tabs
___
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] Changing colors and layout on 4.8

[AC]

That was exactly it, though I was not able to find this using the 
inspector. Everything was coming up as a GtkBox.


The font size was already small on my system, the tabs themselves were 
three times the height of the font.


Unfortunately the scroll wheel doesn't work on the tabs any longer to 
quickly move through the list but at least I can see more tabs.


Before making this CSS change I could only see nine tabs.  Now I can see 
24 (I have a total of 37 open).  So the padding was huge, I just 
couldn't find the padding anywhere in the inspector though that could 
mean I simply overlooked it without realizing it.


But I now have a nice dark themed application.  I'm also pleasantly 
surprised at the speed of loading and saving the file.  I recall mention 
of this being fixed and I can certainly appreciate it.  It took about 
two minutes for 2.6.3 (my previous version) to load my file and 4.8 
takes about ten seconds.


On 2021-12-10 19:42, D. via gnucash-user wrote:

A while back, someone (named Adrien!) shared tips on formatting the tabs at 
https://lists.gnucash.org/pipermail/gnucash-user/2020-January/088583.html


 Original Message 
From: Adrien Monteleone 
Sent: Fri Dec 10 21:45:51 EST 2021
To: gnucash-u...@lists.gnucash.org
Subject: Re: [GNC] Changing colors and layout on 4.8

Note too that there are some 'defined' register colors. The example CSS
files linked from the wiki should at least illustrate these. (though I
don't think there is much 'documentation' on them, their names should be
self-explanatory)

I'll dig into my own CSS file to see if I adjusted that tab-height
property. Or barring that, fire up the inspector myself. But you should
be able to see a property that affects it.

Caveat: respect the Cascade! thus, if a child of the tab, say a 'tab
label' has a 'font-size' specified in *any* independent measurement (not
in reference or dependent on the tab dimensions itself) that child
element will then 're-size' the tab if the tab is set to contain *all*
of its content. (I'm not describing that precisely correct for all
cases, but I think I'm conveying the right idea) This is a 'thing' in
Web CSS, but for some elements of GTK CSS, it is baked in. That is,
those elements always adjust to fit content of their children and you
don't have an easy means to change their behavior via CSS.

So you can set a tab height to 1px, but if your child tab-label is 12px,
(plus or not — margin/padding), then your resulting tab will be that
much larger regardless of the 'official' tab-height property.

I suspect that is the problem.

First, find a nice font-size for the entire UI. Stick with it. (there is
good reason for this)

Then adjust *padding* on the 'tab' or *margin and/or padding* on the
'label' of the tab as needed.

That's what I've done so far, and it works well enough for me, though
I'm not trying to shrink my tabs into near oblivion.

Regards,
Adrien

On 12/10/21 5:48 PM, AC wrote:

The syntax is roughly the same which is fine but what I'm finding harder
is identifying the appropriate selectors based on the output of the
inspector is harder.

I've gotten most of everything I wanted fixed except for the height of
the register tabs. The inspector so far isn't showing me anything
helpful to tweak that would let me reduce their height.


___
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] Changing colors and layout on 4.8

[AC]

The syntax is roughly the same which is fine but what I'm finding harder 
is identifying the appropriate selectors based on the output of the 
inspector is harder.


I've gotten most of everything I wanted fixed except for the height of 
the register tabs. The inspector so far isn't showing me anything 
helpful to tweak that would let me reduce their height.


On 2021-12-10 12:02, Adrien Monteleone wrote:
The wiki *should* warn about this, but be aware that GTK CSS and Web CSS 
are *not* the same thing. Thus rules, selectors, and properties won't 
necessarily translate from Web to GTK or even be available. But anyone 
familiar with Web CSS should be able to find their way around how to 
utilize the inspector.


It takes some getting used to figuring it out, but you should be able to 
see the current value of various UI element properties and adjust them 
on the fly to find what you like. (you can then write these changes as 
'live' CSS rules in their own tab) Not all values are addressable via 
CSS. Some are hard-coded.


You can also see the 'document tree' to discover node/selector names for 
targeting rules. (as well as see how a 'cascade' would work when 
targeting more general nodes/selectors)


Regards,
Adrien

On 12/10/21 1:44 PM, AC wrote:
Found it, there was a space just before the period in the file name. 
The inspector does come up now.


Now to understand how to translate what is in the inspector into 
viable CSS.


___
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] Changing colors and layout on 4.8

[AC]

I'm familiar with those distinctions but it gets more complicated than 
that.  In this particular case, my account is local (the machine is 
standalone and not part of a domain) yet some software still uses 
Roaming rather than Local for storage.


Local isn't just for local accounts.  Some data belonging to a domain 
user will also end up in Local for data that is specific to the machine 
you are using at the time which doesn't make sense to synchronize across 
machines.  In the end it's up to the application itself to decide where 
to write data by selecting the appropriate API calls, Windows doesn't 
enforce one over the other.


On 2021-12-10 13:26, p...@kroitor.ca wrote:

In Windows, the choice of AppData\Local vs AppData\Roaming is system-wide
and dependant upon the type of logon the user performed. A login to the
local machine account uses AppData\Local, while a domain login uses
AppData\Roaming.

There are numerous bits in Windows that deal with giving domain users
consistent settings and data when logging into a domain from a different
workstation (check out User Folder Redirection and Local / Roaming /
Mandatory / Temporary profiles). Somewhat deprecated, complex, poorly
understood, and frequently problematic, but it's still present.

Paul


-Original Message-
From: gnucash-user  On
Behalf Of AC
Sent: December 09, 2021 8:51 PM
To: D. 
Cc: D. via gnucash-user 
Subject: Re: [GNC] Changing colors and layout on 4.8

Well I'm getting closer, just need to find more documentation.

For example, when the window loses focus, the text all changes to a very
light gray which washes out but I can't seem to find anything that would
instruct gtk not to do that.

There seems to be some differences in the wiki documentation covering
configuration in a Windows environment.  The file locations described don't
quite match where the actual files are located (for example many files are
actually located in APPDATA/Roaming rather than APPDATA/Local)

This affects things like how to install a full theme or even editing some of
the CSS.  I got the gtk-3.0.css file working but that's actually in
Roaming\Gnucash despite the wiki saying it should be in Local\gtk-3.0.

On 2021-12-09 17:39, D. wrote:

As far as I know, yes.


 Original Message 
From: AC 
Sent: Thu Dec 09 20:14:47 EST 2021
To: "D." 
Cc: GnuCash users group 
Subject: Re: [GNC] Changing colors and layout on 4.8

I see information in the wiki on Gnucash 3.x because it changed to GTK3.
Is it safe to assume that Gnucash 4 is still using GTK3 so the
instructions would be the same?

On 2021-12-09 17:08, D. wrote:

Much of the interface (such as tab height) can be controlled through css.

The colors in the register may be special, however, and not as readily
changed (but I could be wrong). Others have documented these settings on the
lists and in the wiki. Searches in the list archives and on the wiki should
help you.



 Original Message ----
From: AC 
Sent: Thu Dec 09 19:01:05 EST 2021
To: GnuCash users group 
Subject: [GNC] Changing colors and layout on 4.8

Ok, finally got upgraded to 4.8, so far so good.

A couple things I want to change if at all possible:

First is the color schemes, I'd like to change the ledger to dark
grays and also change the overall UI to have a darker color if possible.

The other thing I was hoping to do is reduce the size of the tabs.
They seem to be using a touchscreen sizing (large areas of empty
space to allow for finger tapping) and I'd like to shrink that down,
especially the register tabs (I have them set to the left and they are

quite tall).


Where would I go about making these changes if possible?
___
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-Lis

Re: [GNC] Changing colors and layout on 4.8

[AC]

On 2021-12-10 11:31, AC wrote:

On 2021-12-10 11:16, Geert Janssens wrote:

Op vrijdag 10 december 2021 19:35:02 CET schreef AC:

Thanks Geert, that at leas would enable it but how do I bring up the
inspector to use it?  The link to gnome.org only discusses using the
inspector in a Linux environment but it doesn't say how to bring it up
in a Windows environment.

On my system it opens the inspector right before opening a gnucash 
window. Is
that not the case on your  system ? Note  the GnuCash window will open 
in front
of the inspector window, so you may have to look through your list of 
open

windows to find it.




That is correct, no additional windows open after Gnucash starts.

I've placed an environment.local file into Program Files 
(x86)/gnucash/etc with the contents as listed on the wiki.


Found it, there was a space just before the period in the file name. 
The inspector does come up now.


Now to understand how to translate what is in the inspector into viable CSS.
___
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] Changing colors and layout on 4.8

[AC]

On 2021-12-10 11:16, Geert Janssens wrote:

Op vrijdag 10 december 2021 19:35:02 CET schreef AC:

Thanks Geert, that at leas would enable it but how do I bring up the
inspector to use it?  The link to gnome.org only discusses using the
inspector in a Linux environment but it doesn't say how to bring it up
in a Windows environment.


On my system it opens the inspector right before opening a gnucash window. Is
that not the case on your  system ? Note  the GnuCash window will open in front
of the inspector window, so you may have to look through your list of open
windows to find it.




That is correct, no additional windows open after Gnucash starts.

I've placed an environment.local file into Program Files 
(x86)/gnucash/etc with the contents as listed on the wiki.

___
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] Changing colors and layout on 4.8

[AC]

Thanks Geert, that at leas would enable it but how do I bring up the 
inspector to use it?  The link to gnome.org only discusses using the 
inspector in a Linux environment but it doesn't say how to bring it up 
in a Windows environment.


On 2021-12-10 01:30, Geert Janssens wrote:

Op vrijdag 10 december 2021 06:00:44 CET schreef Adrien Monteleone:

The wiki has a 'file locations' map for each major OS. Be certain if you
are on Windows that you are following the map for the current version.
They changed at least from 2.x to 3.x, and may have been changed again.
(I don't use Windows, so can't advise, but it should be obvious in the Wiki)

As for non-focused issues, I can at least report that this does not
happen to me on MacOS. Something else might be amiss.

If I recall, each OS is on a different GTK+ version, so some CSS
directives will behave differently. (as well as the default GTK itself)
The key to solving this would be to use the GTK Inspector as the Wiki
describes, but I don't think that is available on Windows. You'd have to
fire up a virtual machine, install GnuCash in it, then inspect the
various tabs/windows of the app to find out what is going on. And then,
if the problem does not re-appear in Linux, then...

Another option "might" be to try WSL, but I don't know if the Inspector
will then work on a Windows app, or if you have to install GnuCash via
WSL too. (and then you're right back at the same problem with a VM and
different GTK versions)


WSL is a linux VM running under Windows. As such it has the same limitations 
with regards
to GnuCash and the Gtk Inspector. That is Gtk Inspector running under WSL can't 
'inspect'
GnuCash running natively on Windows.

But that's not important as the inspector is part of Gtk3 and available 
anywhere Gtk3 is used,
including Windows. The trick is to know how to enable it. The general idea is 
that if
environment variable "GTK_DEBUG" is set to "interactive" while gnucash is 
starting, the
inspector will be started. How to set environment variables is platform 
dependent, but the
mechanism works on all platforms (I have just tested Windows and linux).

For convenience I have just now added a snippet to our Gtk3 wiki [1] to 
illustrate how to set
the variable using the "environment.local" file in path/to/etc/gnucash. Again 
this path/to/etc/
gnucash varies per platform, but its contents will be the same everywhere. And 
it's only one
way to do it. Any way that sets the environment variable prior to gnucash 
startup will do the
trick.

Regards,

Geert

[1] https://wiki.gnucash.org/wiki/GTK3#Using_the_GTK_Inspector[1]


[1] https://wiki.gnucash.org/wiki/GTK3#Using_the_GTK_Inspector
___
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] Changing colors and layout on 4.8

[AC]

Fantastic, thanks.  This gives me the notebook class which I didn't know 
about and couldn't find explained anywhere.


On 2021-12-09 19:07, Ken Farley wrote:
The settings are almost the same from 3.x to 4.x, but coincidentally, 
the things to change Gnucash specific items (like register colors) are 
different. I'm attaching my own gtk.css with my own preferred settings. 
I spent a good amount of time delving into the interface settings 
available in general for GTK3 by looking at other much more complicated 
themes people have written, etc.


Hope it helps.

On 2021-12-09 20:14, AC wrote:
I see information in the wiki on Gnucash 3.x because it changed to 
GTK3.  Is it safe to assume that Gnucash 4 is still using GTK3 so the 
instructions would be the same?


On 2021-12-09 17:08, D. wrote:
Much of the interface (such as tab height) can be controlled through 
css. The colors in the register may be special, however, and not as 
readily changed (but I could be wrong). Others have documented these 
settings on the lists and in the wiki. Searches in the list archives 
and on the wiki should help you.



 Original Message 
From: AC 
Sent: Thu Dec 09 19:01:05 EST 2021
To: GnuCash users group 
Subject: [GNC] Changing colors and layout on 4.8

Ok, finally got upgraded to 4.8, so far so good.

A couple things I want to change if at all possible:

First is the color schemes, I'd like to change the ledger to dark grays
and also change the overall UI to have a darker color if possible.

The other thing I was hoping to do is reduce the size of the tabs.  They
seem to be using a touchscreen sizing (large areas of empty space to
allow for finger tapping) and I'd like to shrink that down, especially
the register tabs (I have them set to the left and they are quite tall).

Where would I go about making these changes if possible?
___
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] Changing colors and layout on 4.8

[AC]

Well I'm getting closer, just need to find more documentation.

For example, when the window loses focus, the text all changes to a very 
light gray which washes out but I can't seem to find anything that would 
instruct gtk not to do that.


There seems to be some differences in the wiki documentation covering 
configuration in a Windows environment.  The file locations described 
don't quite match where the actual files are located (for example many 
files are actually located in APPDATA/Roaming rather than APPDATA/Local)


This affects things like how to install a full theme or even editing 
some of the CSS.  I got the gtk-3.0.css file working but that's actually 
in Roaming\Gnucash despite the wiki saying it should be in Local\gtk-3.0.


On 2021-12-09 17:39, D. wrote:

As far as I know, yes.


 Original Message 
From: AC 
Sent: Thu Dec 09 20:14:47 EST 2021
To: "D." 
Cc: GnuCash users group 
Subject: Re: [GNC] Changing colors and layout on 4.8

I see information in the wiki on Gnucash 3.x because it changed to GTK3.
   Is it safe to assume that Gnucash 4 is still using GTK3 so the
instructions would be the same?

On 2021-12-09 17:08, D. wrote:

Much of the interface (such as tab height) can be controlled through css. The 
colors in the register may be special, however, and not as readily changed (but 
I could be wrong). Others have documented these settings on the lists and in 
the wiki. Searches in the list archives and on the wiki should help you.


 Original Message ----
From: AC 
Sent: Thu Dec 09 19:01:05 EST 2021
To: GnuCash users group 
Subject: [GNC] Changing colors and layout on 4.8

Ok, finally got upgraded to 4.8, so far so good.

A couple things I want to change if at all possible:

First is the color schemes, I'd like to change the ledger to dark grays
and also change the overall UI to have a darker color if possible.

The other thing I was hoping to do is reduce the size of the tabs.  They
seem to be using a touchscreen sizing (large areas of empty space to
allow for finger tapping) and I'd like to shrink that down, especially
the register tabs (I have them set to the left and they are quite tall).

Where would I go about making these changes if possible?
___
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] Changing colors and layout on 4.8

[AC]

I see information in the wiki on Gnucash 3.x because it changed to GTK3. 
 Is it safe to assume that Gnucash 4 is still using GTK3 so the 
instructions would be the same?


On 2021-12-09 17:08, D. wrote:

Much of the interface (such as tab height) can be controlled through css. The 
colors in the register may be special, however, and not as readily changed (but 
I could be wrong). Others have documented these settings on the lists and in 
the wiki. Searches in the list archives and on the wiki should help you.


 Original Message 
From: AC 
Sent: Thu Dec 09 19:01:05 EST 2021
To: GnuCash users group 
Subject: [GNC] Changing colors and layout on 4.8

Ok, finally got upgraded to 4.8, so far so good.

A couple things I want to change if at all possible:

First is the color schemes, I'd like to change the ledger to dark grays
and also change the overall UI to have a darker color if possible.

The other thing I was hoping to do is reduce the size of the tabs.  They
seem to be using a touchscreen sizing (large areas of empty space to
allow for finger tapping) and I'd like to shrink that down, especially
the register tabs (I have them set to the left and they are quite tall).

Where would I go about making these changes if possible?
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.



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

[GNC] Changing colors and layout on 4.8

[AC]

Ok, finally got upgraded to 4.8, so far so good.

A couple things I want to change if at all possible:

First is the color schemes, I'd like to change the ledger to dark grays 
and also change the overall UI to have a darker color if possible.


The other thing I was hoping to do is reduce the size of the tabs.  They 
seem to be using a touchscreen sizing (large areas of empty space to 
allow for finger tapping) and I'd like to shrink that down, especially 
the register tabs (I have them set to the left and they are quite tall).


Where would I go about making these changes if possible?
___
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] Compiling 2.6.19

[AC]

I'm having a bit of trouble compiling 2.6.19 (so that I can begin the
upgrade process for the data) but the dependencies are not being met.

All the base dependency packages are installed but the versioning seems
to be off or package names have changed and don't expose old library
names.  For example, I'm installing on Debian 9 Buster and I get errors
about webkit-1.0 despite having installed despite having
libwebkit2gtk-4.0-dev, libqtwebkit-dev, libqt5webkit5-dev,
libkf5webkit-dev, and just about every other webkit library I can find
installed.  I did also run the build-dep to pull in anything else.

There's probably going to be others but the configure script stops at
the webkit test.

The package manager only has up to 3.4 and I'm trying to make my way to 4.8.
___
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] Making the leap to latest

[AC]

The main problem is that you can't have side-by-side installations on a
Windows system (as has been pointed out to me).  So upgrading the
software means uninstalling the old one, installing the new one and, if
anything goes wrong, reversing that entire process.  A side-by-side
install would let me run both to make sure no issues and then I can
uninstall the older one later once I tested the new one.

However, I think I have a workaround, I'll install a Linux guest VM (I
already have other VMs running on the same box) and do the updates
through the VM first reading in the data each time to save to the new
formats.  If all goes well I'll install the Windows version on the
machine and move the newly converted data files back to the machine from
the VM.

On 2021-10-03 20:27, Peter West wrote:
> I would disagree with “don’t upgrade unless entirely necessary." Open source 
> software (OSS) requires a different approach. Proprietary software offers 
> guarantees of the support lifetime of the software you purchase, paid for by 
> your money. The resources for development and support are very limited and 
> voluntary. The benefits of OSS come with some implied responsibilities.
> 
> Keep your software up-to-date.
>   Keep the installer for you current version of the software. When the 
> next version is released, secure the backup of your date and install the new 
> software. If something goes wrong, re-install the working version, restore 
> your date, and report your problem. We recently had two successive install 
> difficulties, for example. You don’t need to keep the dud installers, 
> obviously.
> 
> Keep an eye on the mailing list, and offer your suggestions to other users if 
> yo think you know how to fix their problems.
> 
> Peter
> —
> Peter West
> p...@ehealth.id.au
> “The one who hears you hears me, and the one who rejects you rejects me, and 
> the one who rejects me rejects him who sent me.”
> 
> 
>> On 3 Oct 2021, at 8:11 am, AC  wrote:
>>
>> I agree don't upgrade if not absolutely necessary but I will likely be
>> replacing this computer in a few months so starting from a newer
>> installation is much more likely to happen in that case.
>>
>> So you're saying I should be able to do three stages of 2.6.last,
>> 3.x.last and then 4.x.last?
>>
>> Are there any big changes to basic functionality from 2.6 to 4.x?  I'm
>> making my way through the change logs but a lot of it is related to
>> various features I don't use (at least that which I've read thus far).
>>
>>
>> On 2021-10-02 15:06, Derek Atkins wrote:
>>>> From 2.6.3 you will need to jump to 2.6.last, then 3.x, then 4.x
>>>
>>> At every version you should load your data file and then save it.
>>>
>>> While there is no requirement to upgrade, and "if it ain't broke, don't
>>> fix it" may apply, if you have a system crash and need to rebuild your
>>> system, it'll be easier to use recent versions.
>>>
>>> -derek
>>> Sent using my mobile device. Please excuse any typos.
>>> On October 2, 2021 5:56:23 PM AC  wrote:
>>>
>>>> Ok, I've been running along on 2.6.3 on Win 10.  No issues to date that
>>>> I can see.
>>>>
>>>> I know there's been various changes throughout the rest of the 2.x and
>>>> 3.x series and we're now on 4.x which sparks some questions:
>>>>
>>>>
>>>> Do I really need to update?  I only use the basis ledgers for standard
>>>> banking accounts, credit cards, loans, mutual funds; scheduled
>>>> transactions; and basic reports (typically just the standard transaction
>>>> report when I need a list for taxes). I don't use online transactions,
>>>> imports, or business features.  Can I assume that the basics still work
>>>> the same way?
>>>>
>>>> If it's better for me to go ahead and update how painful will it be to
>>>> update?
>>>>
>>>> I recall some suggestions previously about upgrading in increments and
>>>> if that's the case how many increments am I going to need (hopefully not
>>>> one for every point version)?
>>>>
>>>> ___
>>>> 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] Making the leap to latest

[AC]

Thanks but this isn't my first rodeo with migrating computers.  It's
only my first migration with GnuCash to a later version and the primary
purpose of my question is to make sure that changes in the file storage
format get translated correctly since I'm well aware that the format has
changed at least once since 2.6.x.


On 2021-10-02 15:30, Michael or Penny Novack wrote:
> On 10/2/2021 6:11 PM, AC wrote:
>> I agree don't upgrade if not absolutely necessary but I will likely be
>> replacing this computer in a few months so starting from a newer
>> installation is much more likely to happen in that case.
>>
> a) Yes, you only want to be making one "change" at a time << FAR easier
> to "debug" if there are problems. Since you will not easily have your
> current gnucash version available for installation o  the new machine,
> best to update now, while still on the old machine, to a current version
> you will have available for installing on the new machine.
> 
> b) Going to a new computer, you will want to be saving ALL of your data
> (not just gnucash data). If the OS is remaining the same, this is
> relatively simple. If the OS will be changing (different on the new
> machine) this will not be simple unless the two OS's use the same user
> data structure.
> 
> c) In case "b" applies, do not immediately begin the "restore form
> backup". Get the software on, and in each case, see where it puts the
> application user data. You can then see what files to replace/where.
> 
> Michael D Novack
> 
___
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] Making the leap to latest

[AC]

Actually, related to this:  Is there a straightforward way to try a
version without having to go through a complete installation on Windows
and without disturbing the existing installation?

If it's possible then I could run 2.6.last and then 3.x stand-alone with
a test copy of the file before jumping to 4.x and committing to the full
install.

On 2021-10-02 15:11, AC wrote:
> I agree don't upgrade if not absolutely necessary but I will likely be
> replacing this computer in a few months so starting from a newer
> installation is much more likely to happen in that case.
> 
> So you're saying I should be able to do three stages of 2.6.last,
> 3.x.last and then 4.x.last?
> 
> Are there any big changes to basic functionality from 2.6 to 4.x?  I'm
> making my way through the change logs but a lot of it is related to
> various features I don't use (at least that which I've read thus far).
> 
> 
> On 2021-10-02 15:06, Derek Atkins wrote:
>>> From 2.6.3 you will need to jump to 2.6.last, then 3.x, then 4.x
>>
>> At every version you should load your data file and then save it.
>>
>> While there is no requirement to upgrade, and "if it ain't broke, don't
>> fix it" may apply, if you have a system crash and need to rebuild your
>> system, it'll be easier to use recent versions.
>>
>> -derek
>> Sent using my mobile device. Please excuse any typos.
>> On October 2, 2021 5:56:23 PM AC  wrote:
>>
>>> Ok, I've been running along on 2.6.3 on Win 10.  No issues to date that
>>> I can see.
>>>
>>> I know there's been various changes throughout the rest of the 2.x and
>>> 3.x series and we're now on 4.x which sparks some questions:
>>>
>>>
>>> Do I really need to update?  I only use the basis ledgers for standard
>>> banking accounts, credit cards, loans, mutual funds; scheduled
>>> transactions; and basic reports (typically just the standard transaction
>>> report when I need a list for taxes). I don't use online transactions,
>>> imports, or business features.  Can I assume that the basics still work
>>> the same way?
>>>
>>> If it's better for me to go ahead and update how painful will it be to
>>> update?
>>>
>>> I recall some suggestions previously about upgrading in increments and
>>> if that's the case how many increments am I going to need (hopefully not
>>> one for every point version)?
>>>
>>> ___
>>> 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] Making the leap to latest

[AC]

I agree don't upgrade if not absolutely necessary but I will likely be
replacing this computer in a few months so starting from a newer
installation is much more likely to happen in that case.

So you're saying I should be able to do three stages of 2.6.last,
3.x.last and then 4.x.last?

Are there any big changes to basic functionality from 2.6 to 4.x?  I'm
making my way through the change logs but a lot of it is related to
various features I don't use (at least that which I've read thus far).


On 2021-10-02 15:06, Derek Atkins wrote:
>> From 2.6.3 you will need to jump to 2.6.last, then 3.x, then 4.x
> 
> At every version you should load your data file and then save it.
> 
> While there is no requirement to upgrade, and "if it ain't broke, don't
> fix it" may apply, if you have a system crash and need to rebuild your
> system, it'll be easier to use recent versions.
> 
> -derek
> Sent using my mobile device. Please excuse any typos.
> On October 2, 2021 5:56:23 PM AC  wrote:
> 
>> Ok, I've been running along on 2.6.3 on Win 10.  No issues to date that
>> I can see.
>>
>> I know there's been various changes throughout the rest of the 2.x and
>> 3.x series and we're now on 4.x which sparks some questions:
>>
>>
>> Do I really need to update?  I only use the basis ledgers for standard
>> banking accounts, credit cards, loans, mutual funds; scheduled
>> transactions; and basic reports (typically just the standard transaction
>> report when I need a list for taxes). I don't use online transactions,
>> imports, or business features.  Can I assume that the basics still work
>> the same way?
>>
>> If it's better for me to go ahead and update how painful will it be to
>> update?
>>
>> I recall some suggestions previously about upgrading in increments and
>> if that's the case how many increments am I going to need (hopefully not
>> one for every point version)?
>>
>> ___
>> gnucash-user mailing list
>> gnucash-user@gnucash.org
>> To update your subscription preferences or to unsubscribe:
>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>> If you are using Nabble or Gmane, please see
>> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
>> -
>> Please remember to CC this list on all your replies.
>> You can do this by using Reply-To-List or Reply-All.
> 
> 

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

[GNC] Making the leap to latest

[AC]

Ok, I've been running along on 2.6.3 on Win 10.  No issues to date that
I can see.

I know there's been various changes throughout the rest of the 2.x and
3.x series and we're now on 4.x which sparks some questions:


Do I really need to update?  I only use the basis ledgers for standard
banking accounts, credit cards, loans, mutual funds; scheduled
transactions; and basic reports (typically just the standard transaction
report when I need a list for taxes). I don't use online transactions,
imports, or business features.  Can I assume that the basics still work
the same way?

If it's better for me to go ahead and update how painful will it be to
update?

I recall some suggestions previously about upgrading in increments and
if that's the case how many increments am I going to need (hopefully not
one for every point version)?

___
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] OT: DMARC / DKIM and the GC lists

[AC]

On 2019-06-16 15:12, Maf. King wrote:
> On Sunday, 16 June 2019 23:06:34 BST Adrien Monteleone wrote:
>> I think I might be understanding #2 more. The list is passing on your
>> message, and it looks like it is routing through gnucash.org instead of
>> directly from you. (which technically is true)
>>
>> In that case, I suppose yes, you could configure gnucash.org as a
>> whitelisted sender if just to eliminate the noise. (and likely the possible
>> bounces)
>>
>> Regards,
>> Adrien
>>
> 
> Yeah, that's my line of thought.  I'll see if there is any more input from 
> anyone else (or complaints about bounces from annoyed admin-types!)
> 
> thanks,
> Maf.

You should be able to whitelist the host rather than just the name.
That prevents other spoofing.
___
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] Need help with a Savings account

[AC]

On 2019-04-17 20:00, Adrien Monteleone wrote:
> And I also agree that the GnuCash defaults of informal labels and Basic View 
> are much simpler to comprehend.
> 
> However, once someone encounters a situation where they don’t understand 
> ’transfer’ account or the nature of double-entry, problems arise.
> 
> They arise because by default, GnuCash is hiding the double-entry nature of 
> the system from them. (something of a contra-selling point when comparing GC 
> to proprietary systems that do the same thing, very strange it is the GC 
> default)

How is it that using the "informal" labels (not the accounting labels)
is hiding the double-entry process?  It's fairly formal in everyday use
that people understand and flows from natural language pretty easily.  I
"withdraw" money from my bank and use it to make a "payment" to my
credit card.  I "charge" my card when I go buy gasoline which is an
"expense". The double entry is there, it's not hidden at all.

All of my banks (three) don't even use formal labels for the statements.
 They all write "Deposits" and "Withdrawls" right at the top of the
transaction logs.  The credit cards I have (six) all write "Charges" and
"Payments" on the statements.



___
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::Quotes stopped working for me

[AC]

LWP apparently will also self report a 500 status if the connection
fails for any reason.  The first suggestion would be to add lots of
debugging to the perl script to dump its internal state at various
points and also snoop on the connection.

I would also check to see if the malfunctioning router is utilizing a
proxy of some form.  Some tools are able to pick up on a proxy if the OS
has automatically put in the appropriate environmental variables but I
don't believe LWP can do that.  (Curl does look for the environment
variables and most browsers can query the OS for proxy information).

Admittedly it would be very odd to have a proxy running on a basic
router but not impossible.

On 2019-04-13 07:59, David Carlson wrote:
> There must be something else going on that hasn't been found yet.
> 
> David Carlson
> 
> On Sat, Apr 13, 2019, 9:18 AM John Ralls  wrote:
> 
>> The URL is given several times in the thread, it's http, port 80. That
>> aside, get real: A firewall that blocks a port when perl's LWP is the agent
>> but not when curl or a web browser is?
>>
>> Besides, the request isn't blocked, it's munged so that Yahoo! returns a
>> 500--server error response. So we have to imagine that the router can
>> somehow tell that the packets are coming from curl and not messing with
>> them or perl LWP and messing with them? That's a pretty amazing firewall.
>>
>> 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.

Re: [GNC] two lines for every entry

[AC]

On 2019-04-10 23:48, ToddAndMargo via gnucash-user wrote:
> So, do I set up two account for every credit card?  Will
> the link cover this?
> 

You set up one account for the card (Liabilities: Credit Card), one for
the bank (Assets: Bank) and then you have as many set up as you want for
expenses.

When you buy something, charge the card and have the "other" account be
Expenses: Groceries, Expenses: Gasoline, etc.  Whatever you want as long
as the "other" account is some kind of expense account.

When you pay the credit card, it comes from Assets: Bank

Things like Quicken and Microsoft Money hid this by using the Payee as
the "other" account so it was relatively automatic.  But GnuCash also
does auto-fill as you type so if your Description field was
"Supermarket" for the first time you set up a transaction between the
credit card and Expenses: Groceries, it'll remember that account
arrangement next time you enter "Supermarket" and then you only have to
change the amount.

For basic tracking the accounts will only have to be set up once and the
auto-fill will help you out afterwards (just change the amounts).

If you have more than one card just set it up as Liabilities: Card 1,
Liabilities Card 2, or other arrangements however you wish as long as
they're all liability accounts.  Same for multiple bank accounts, just
make sure they're all asset accounts.
___
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] Liabilities and Net Worth in Android app

[AC]

On 2019-02-01 11:42, Stephen M. Butler wrote:

> I forget which O/S you are on.  The config-user.scm goes into my
> $HOME/.config/gnucash folder.  The other three go into
> $HOME/.local/share/gnucash folder.

He's using the Android application

___
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] Liabilities and Net Worth in Android app

[AC]

On 2019-02-01 10:01, Maf. King wrote:
> On Friday, 1 February 2019 09:27:29 GMT Chris wrote:
>> Dear GnuCash community,
>>
>> I recently installed the Android app for the first time and played
>> around with it. I noticed two things that I am not sure about and wanted
>> to ask your opinion/advice.
>>
> 
> Hi,
> 
> I imagine that it will come as a surprise to you to find out that the GnuCash 
> Android app and the main Linux/Mac/Windows program are independent projects.
> 
> Despite the similarity of the name, the 2 projects are (as I understand it) 
> unrelated.  
> 
> This list is for the "full-fat" program, not the Android app.  You might get 
> more help if you use another support channel (especially for feature 
> enhancements tot the App).  I regret to say that I don't know where other 
> support might be found though.
> 
> HTH,
> Maf.


Feeback and support is implemented inside the application.  Under the
main menu there is a selection for "Help and Feedback" and within that
there is a "Contact Us" selection (provides a form to send a message to
the developers), a "Feedback Forum" selection (provides a form to post
to the forum), and a Knowledge Base for select questions/topics.

The Play Store entry does happen to list gnucash.org as the project
website but it also lists gnucash-android-...@googlegroups.com as its email.

Between the built-in mechanisms and the Google Groups email the OP
should be able to get some support.
___
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 QIF error (from Android to Windows)

[AC]

On 2019-01-19 12:32, David Cousens wrote:
> Have you tried any of the suggestions in the above posts? If so what were the
> results?
> 
> There won't be a magic solution and no-one is going to be able to diagnose
> the problem without additional information or if it really gets desperate a
> copy of the .qif.  file you are trying to import. 
> 
> Have you looked at the GnuCash log files? 
> https://wiki.gnucash.org/wiki/Logging. Was there anything indicating a
> problem?
> 
> Have you started GnuCash with the debug switch? ( start with $gnucash
> --debug at a terminal prompt  this gives more detail in the log files).
> Have you examined your file to find out whether it deviates from the QIF
> file formatting?https://www.w3.org/2000/10/swap/pim/qif-doc/QIF-doc.htm
> Were there any obvious deviations?
> 
> Try these and post your results and someone stands a chance of being able to
> help. 
> 
> The only major changes to the qif import between 2.6.19 and 3.1 were a shift
> from the guile1.8 to guile2.0 library, a change in the format of an example
> qif file and some changes to the matching of dates. There was nothing
> obvious that affected the parsing of the file in the commits that I could
> find.
> 
> David Cousens

This might be of interest from the GnuCash Android change log:

Version 2.3.0 (2018-01-10)
Improved #696: QIF files are now always zipped regardless of the export
destination

___
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] GNU crashes when any Report is selected

[AC]

On 2018-12-10 10:10, Arnie Reeves via gnucash-user wrote:
> Tend to agree Stephen regarding the possible effects of MS updates. My 
> reports have always opened within a couple of seconds, that's why I thought 1 
> to 2 minutes was a crash. It would be nice for beginners to see a small text 
> next to the "GNUCash not responding" message to advise them to wait longer. 
> The gut feeling of "external influences" was immediate which is why I thought 
> that reinstalling would perhaps fix a contaminated file. John's experience 
> was of course correct in identifying a hang rather than a crash, and I'm 
> grateful for his sound advice, but it's strange that this long delay was so 
> suddenly  imposed. I could understand a gradual progressive delay as files 
> got bigger. 

The "not responding" text is inserted by Windows itself, not the
individual software that is having issues.  This is Microsoft's hint to
the end user to wait for something to happen.  If the software stays in
that state for some period of time then Windows will offer a dialog box
that asks the user if they wish to continue waiting or forcibly
terminate the program.
___
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] Transaction reports with only debits or credits

[AC]

Is there a way to configure a transaction report (or any of the
available reports) to show only the debits or the credits (but not both)
of an 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-List or Reply-All.

Re: Fast reactions to 2.7.8

[AC]

On 2018-03-27 11:15, Geert Janssens wrote:
> Op dinsdag 27 maart 2018 18:44:38 CEST schreef Stan Brown:
>> (1) Not a fan of the toolbar showing icons without words. I _hate_ an
>> interface where you have to hover over every single icon until you can find
>> the one you want.
>>
> Not a fan of _hate_ (stress markers included) statements...
> 
>> Many programs offer "words only", "icons only", and "icons and words" as
>> choices. I couldn't find anything like that. Please add it.
> 
> It used to be there in the 2.4 series. I have removed it for 2.6 and up 
> because I don't think this should be an application level setting. It should 
> be a system level preference and in addition is strongly influenced by the 
> human interface guidelines on that platform.


This isn't always an OS level item.  It really depends on the complexity
of the software.  For example, the mainstream browsers are capable of
switching modes for the buttons/text for themselves.  LibreOffice is
similar, you can customize the toolbars with icon, text or both.

For some OSes, the window manager does not have this kind of control at
all (e.g.  Windows) so it makes no sense to query the OS for a
preference that doesn't exist.
___
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: 2.7.6 - Scrolling in Accounts-Tabs

[AC]

On 2018-03-17 10:12, Maf. King wrote:
> On Saturday, 17 March 2018 16:27:27 GMT Catscrash wrote:
>> Is no one else using / testing 2.7.6 or am I the only one with this
>> problem? Does the scrolling work for you?
>> I know, I should not expect a perfect release with the 2.7.x releases,
>> and I don't - I just want to make sure this won't be in the final 2.8
>>
>> Thanks!
>>
> 
> Hi,
> 
> you must have missed John Ralls' reply at 22:56 (GMT) on tuesday where he 
> said 
> it wasn't available in the toolkit...
> 
> Maf.

If anyone wants to compile their own copy of the GTK toolkit, the
modification that removed scrolling can be reverted:

https://gitlab.gnome.org/GNOME/gtk/commit/ad48f4d52bbac6139dd829fcc421ad16441f34d2
(line numbers might be a bit off but it should be possible to figure out
how to piece it back together)
___
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: Tracking credit card points

[AC]

On 2018-02-05 16:50, Adrien Monteleone wrote:
> Try pulling up a Google Search and entering this (without the quotes) as your 
> search term:
> 
> "site:lists.gnucash.org credit card points” or something similar.
> 
> You’ll see links to various threads here on the mailing list discussing the 
> subject.
> 

Already had done that, the threads that did appear were either not quite
what I was looking for or a bit conflicted.  In some cases the threads
were focused on reporting or tracking value (as opposed to just tracking
the balance).
___
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.

Tracking credit card points

[AC]

I've decided to start tracking my points on my cards because the monthly
statements do a poor job of  showing me the activity.  For this
application, is it better to set up the point tracking account as a
stock-type account or a currency?  The value when redeemed fluctuates
but I will always know how many points were redeemed (an integer number)
and the total dollar value that is being converted (e.g. I will know I
spent 1830 points on a purchase that would have totaled $23.95 today but
it may not be that same total tomorrow).

The only thing I don't want to have happen is for the system to see this
new tracking as some kind of value adjacent to my actual stock accounts
to include in reports.  For convenience it should live within the same
file but behave as an independent entity.
___
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: Filtered account report

[AC]

No, it's a roughly even distribution across the loans but, as mentioned
in my other email, transactions look different at different dates in
history because the majority were imported from other software before
switching to GnuCash.

On 2018-01-16 09:44, Adrien Monteleone wrote:
> On that note, if only one loan has 1000 interests splits but the other loans 
> are more manageable, then Michael just provided a workable solution.
> 
> Rename the current ‘loan interest’ account to match the name of the loan with 
> the most interest splits. (yes, everything will still be in it)
> 
> Then create the new parent and the other child loan interest accounts as he 
> indicated.
> 
> Run a Find on the newly renamed ‘loan interest 1’ account and filter for 
> memos/descriptions for one of the other loans. Now, you’re looking at a 
> subset of that account register for just one particular loan. Edit those 
> interest splits to their respective new child interest account.
> 
> Rinse, repeat for additional loans.
> 
> This will provide what you want, with the least amount of work and set you up 
> for more granular reporting in the future.
> 
> I did something similar on several occasions when I wanted to re-assign a 
> large block of expenses to child accounts as I was refining my CoA.
> 
> 
> Regards,
> Adrien
> 
>> On Jan 16, 2018, at 7:48 AM, Mike or Penny Novack 
>> <stepbystepf...@dialup4less.com> wrote:
>>
>> On 1/16/2018 3:04 AM, AC wrote:
>>> Thanks but not exactly simple in my case as there are over 1000
>>> transactions to the loan interest expense account.  The report was
>>> mainly for my own curiosity which is why I'd rather use an algorithmic
>>> method to generate the report.
>> This is an important point (what David just said)
>>
>> With any of these accounting packages you have to plan the CoA so that the 
>> information you need will be available. Essentially what you are saying is:
>>
>> "I did not design the CoA in such a way (a parent "loan interest" under 
>> which children "loan 1 interest", "loan 2 interest", ..) that I could 
>> see the interest for each loan separately. How can I NOW obtain that 
>> information?"
>>
>> The simple answer is, you can't. But that leads to a discussion about being 
>> alert to changes needed in our books. Such changes might be easy at the time 
>> but very difficult later. Using this situation as an example, you might have 
>> started out with just one loan, so natural to have just "loan interest". It 
>> is when first entering transactions related to a second loan that we need to 
>> notice "oops, won't be able to track the interest of the two loans 
>> separately" and so you:
>> 1) rename "loan interest" to "loan 1 interest"
>> 2) create parent account (placeholder) "loan interest"
>> 3) make "loan 1 interest" a child of this account.
>> 4) create "loan 2 interest" a child of this account.
>> If you realized this fairly speedily after loan 2 came into existence, not a 
>> lot of work re-entering transactions. But if you wait till there are 
>> hundreds or thousands that would need to be fixed .
>>
>> Michael D Novack
>>
>>
>> ___
>> gnucash-user mailing list
>> gnucash-user@gnucash.org
>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>> -
>> 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
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> 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
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Filtered account report

[AC]

On 2018-01-16 05:48, Mike or Penny Novack wrote:
> On 1/16/2018 3:04 AM, AC wrote:
>> Thanks but not exactly simple in my case as there are over 1000
>> transactions to the loan interest expense account.  The report was
>> mainly for my own curiosity which is why I'd rather use an algorithmic
>> method to generate the report.
> This is an important point (what David just said)
> 
> With any of these accounting packages you have to plan the CoA so that
> the information you need will be available. Essentially what you are
> saying is:
> 
> "I did not design the CoA in such a way (a parent "loan interest" under
> which children "loan 1 interest", "loan 2 interest", ..) that I
> could see the interest for each loan separately. How can I NOW obtain
> that information?"
> 
> The simple answer is, you can't. But that leads to a discussion about
> being alert to changes needed in our books. Such changes might be easy
> at the time but very difficult later. Using this situation as an
> example, you might have started out with just one loan, so natural to
> have just "loan interest". It is when first entering transactions
> related to a second loan that we need to notice "oops, won't be able to
> track the interest of the two loans separately" and so you:
> 1) rename "loan interest" to "loan 1 interest"
> 2) create parent account (placeholder) "loan interest"
> 3) make "loan 1 interest" a child of this account.
> 4) create "loan 2 interest" a child of this account.
> If you realized this fairly speedily after loan 2 came into existence,
> not a lot of work re-entering transactions. But if you wait till there
> are hundreds or thousands that would need to be fixed .
>

Yes except that's not how things started or ended up.  Many of the
transactions are from before GnuCash so they are historical records that
imported that way.  Second, I really wasn't paying attention to the
interest in any way other than to record it for record keeping as part
of a transaction mainly because I was more interested in the portion of
the payment that went to the principal and tracking the remaining amount
of payoff.

There were already over 500 transactions at the time I imported into
GnuCash for the first time.  So it's a bit off base to suggest I should
have "paid attention" when setting up the CoA when I didn't have a CoA
due to the original software.  I was lucky enough to get it to import
with few errors as is.

However, I was able to do it anyway without modifying the account
structure.  I just dumped the table and parsed it externally.
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Filtered account report

[AC]

Thanks but not exactly simple in my case as there are over 1000
transactions to the loan interest expense account.  The report was
mainly for my own curiosity which is why I'd rather use an algorithmic
method to generate the report.  With the distinct lack of global search
and replace, it would take way too long to do it so it's not worth the
time to refactor that many accounts for a off-the-cuff experiment.

On 2018-01-15 23:37, David T. wrote:
> AC,
> I went a different way.  I created Subaccounts for each grouping I wanted to 
> track. So, if I want to track interest on a particular loan (for example, if 
> I expected a 1099 for it), I created a subaccount under Expenses:Interest. 
> That made it simple to track individual loans. I also can assign the account 
> to a tax line, and have it turn up in the TXF report.
> It only takes a few minutes really, to restructure like this. 
> David
> 
>  
>  
>   On Tue, Jan 16, 2018 at 10:21, AC<gnuc...@acarver.net> wrote:   The 
> description for each split does have the specific loan to which it
> applies.  I used the search to filter on all of those but the
> transaction report still pulls everything in.
> 
> On 2018-01-15 21:14, Adrien Monteleone wrote:
>> Have you tagged each interest payment split with the loan name? You could 
>> use that as the filter, though I would think the memo field would suffice.
>>
>> Regards,
>> Adrien
>>
>>> On Jan 15, 2018, at 10:29 PM, AC <gnuc...@acarver.net> wrote:
>>>
>>> No, that didn't work.  It still pulls the interest payments from
>>> multiple loans and won't let me filter out the specific interest
>>> payments for one of the loans.
>>>
>>> On 2018-01-15 20:13, Christopher Lam wrote:
>>>> Try the Transaction Report which has an Account Filter in the first tab.
>>>>
>>>> On 16 Jan 2018 11:54 AM, "AC" <gnuc...@acarver.net> wrote:
>>>>
>>>>> I was looking at some of my loans and wanted to get an idea of how much
>>>>> I paid in interest to each loan over their life.  I've got one account
>>>>> that collects the amount of loan interest every time I pay (as part of a
>>>>> split transaction) while the principal portion of the payment goes to
>>>>> the specific loan account.
>>>>>
>>>>> There's a mix of different loans in the one interest paid account (Loan
>>>>> A, Loan B, Loan C, etc.) and I wanted to see, for example, only the
>>>>> interest paid on Loan B.
>>>>>
>>>>> I thought I could run an account report on a search window but that
>>>>> doesn't work because it also finds the principal payments and tabulates
>>>>> them as well in the final total.
>>>>>
>>>>> What report and/or filtering mechanism could/should I use to show this
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Filtered account report

[AC]

The description for each split does have the specific loan to which it
applies.  I used the search to filter on all of those but the
transaction report still pulls everything in.

On 2018-01-15 21:14, Adrien Monteleone wrote:
> Have you tagged each interest payment split with the loan name? You could use 
> that as the filter, though I would think the memo field would suffice.
> 
> Regards,
> Adrien
> 
>> On Jan 15, 2018, at 10:29 PM, AC <gnuc...@acarver.net> wrote:
>>
>> No, that didn't work.  It still pulls the interest payments from
>> multiple loans and won't let me filter out the specific interest
>> payments for one of the loans.
>>
>> On 2018-01-15 20:13, Christopher Lam wrote:
>>> Try the Transaction Report which has an Account Filter in the first tab.
>>>
>>> On 16 Jan 2018 11:54 AM, "AC" <gnuc...@acarver.net> wrote:
>>>
>>>> I was looking at some of my loans and wanted to get an idea of how much
>>>> I paid in interest to each loan over their life.  I've got one account
>>>> that collects the amount of loan interest every time I pay (as part of a
>>>> split transaction) while the principal portion of the payment goes to
>>>> the specific loan account.
>>>>
>>>> There's a mix of different loans in the one interest paid account (Loan
>>>> A, Loan B, Loan C, etc.) and I wanted to see, for example, only the
>>>> interest paid on Loan B.
>>>>
>>>> I thought I could run an account report on a search window but that
>>>> doesn't work because it also finds the principal payments and tabulates
>>>> them as well in the final total.
>>>>
>>>> What report and/or filtering mechanism could/should I use to show this
>>>> information?
>>>> ___
>>>> gnucash-user mailing list
>>>> gnucash-user@gnucash.org
>>>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>>>> -
>>>> 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
>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>> -
>> 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
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> 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
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Filtered account report

[AC]

I was looking at some of my loans and wanted to get an idea of how much
I paid in interest to each loan over their life.  I've got one account
that collects the amount of loan interest every time I pay (as part of a
split transaction) while the principal portion of the payment goes to
the specific loan account.

There's a mix of different loans in the one interest paid account (Loan
A, Loan B, Loan C, etc.) and I wanted to see, for example, only the
interest paid on Loan B.

I thought I could run an account report on a search window but that
doesn't work because it also finds the principal payments and tabulates
them as well in the final total.

What report and/or filtering mechanism could/should I use to show this
information?
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: NUM Column Defaults

[AC]

On 2018-01-12 08:19, Jack Slater wrote:

> 
> And a thought while I'm asking - 2 time saving capabilities in Quicken were:
> 
> 1 - in NUM cell - type "n" would lookup prior check entry and populate that
> number + 1.
> 2 - in DATE cell - type "t" would enter today's date

1:  Type "+" (the plus sign) twice to get the next check number
2:  Type "t" to get today's date.

___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Running balance stops working

[AC]

I deleted all the offending transactions and restarted Gnucash.  After
that it started working again.  So it probably is a very subtle bug but
how it gets tripped I have no clue.  The OS is Win 7.  I've seen this
happen once before in version 2.4 but it cleared up without a restart in
that case.  This was the first time I saw it since upgrading from 2.4 to
2.6.

I choose not to upgrade at this point because none of the bugs that have
been fixed (based on what is currently published in the change logs)
affects me.  However, if this sudden blank running balance happens to be
a side effect of a fixed bug then I would be inclined to upgrade.  Given
that it happens so rarely, though, I'd still rather hold off.

On 2018-01-07 07:50, farleykj wrote:
> You've not mentioned the operating system you are running on, which can be
> helpful if other people want to try and duplicate your problem.
> Either way, first off, I've got lots of added namespace entries for the
> securities, like ETF, ESOP, etc. They are just placeholders for
> categorizing, they don't affect the way the individual securities are
> presented, to the best of my knowledge.
> The only time I saw weird behavior in the Balance column of an account was
> when I botched up the "Smallest fraction" setting for the account, within
> the Edit Account feature. I don't know how you would set this to result in
> blanks, but maybe it's possible?
> Also, Version 2.6.3 is rather old (circa 2014?) given the current version is
> 2.6.19. There have been many bug fixes in the intervening years. Maybe if
> what you're seeing is the result of some bug it might have been addressed
> already. Wishful thinking, perhaps.
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Date entry quick keys

[AC]

Thanks, that does work.  It's not documented in the online manual.
Shifting by a a day (+ or -) or a month ([ or ]) is there, just not the
shifted versions.

On 2018-01-06 20:38, John Morris wrote:
> You don't say what operating system you use, and I don't know if this 
> particular feature is operating-system dependent, but shift + and shift - 
> give me one-week increments and decrements in 2.6.16 on Mac OS X.
> 
> Best,
> John
> 
>> On Jan 6, 2018, at 11:00 PM, AC <gnuc...@acarver.net> wrote:
>>
>> Are the quick keys for date entry in the register part of a GTK file
>> that can be edited or a compiled-in feature?  (These are the use of +/-,
>> [/] T, M/H, Y/R).  I wanted to add one that increments or decrements in
>> one week increments.
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Date entry quick keys

[AC]

Are the quick keys for date entry in the register part of a GTK file
that can be edited or a compiled-in feature?  (These are the use of +/-,
[/] T, M/H, Y/R).  I wanted to add one that increments or decrements in
one week increments.
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Fwd: Re: errir in SQL syntax

[AC]

You need to reply to all to make this back to the mailing list.
Forwarding for the list.





Thanks for hint. This is form the webpage https://wiki.gnucash.org/wiki/SQL
Maybe somebody can correct this?

Wolfgang

On Mon, Dec 18, 2017 at 8:30 AM, AC <gnuc...@acarver.net
<mailto:gnuc...@acarver.net>> wrote:

You misspelled AUTO_INCREMENT (note the underscore character).


On 2017-12-17 23:03, Wolfgang Paul Rauchholz wrote:
> My config:
> Linux CENTOS 7, mariadb-5.5.56-2.el7.x86_64
>
> Setting up the database on my home server. Will connect fomr
laptops in the
> network onto mariadb.
>
> When trying to execute this command.
>
> CREATE TABLE slots (
>     id integer PRIMARY KEY AUTOINCREMENT NOT NULL,
>     obj_guid            CHAR(32) NOT NULL,
>     name                text(4096) NOT NULL,
>     slot_type           integer NOT NULL,
>     int64_val           integer,
>     string_val          text(4096),
>     double_val          real,
>     timespec_val        CHAR(14),
>     guid_val            CHAR(32),
>     numeric_val_num     integer,
>     numeric_val_denom   integer
> );
>
> I get this error. I can't find anything in google, so I'd hoped I
get some
> help here. Thank you
>
>
> ERROR 1064 (42000): You have an error in your SQL syntax; check
the manual
> that corresponds to your MariaDB server version for the right
syntax to use
> near 'NOT NULL,
>     obj_guid            CHAR(32) NOT NULL,
>     name                tex' at line 2
>
>
> Thansk for your help
>
>

___
gnucash-user mailing list
gnucash-user@gnucash.org <mailto:gnucash-user@gnucash.org>
https://lists.gnucash.org/mailman/listinfo/gnucash-user
<https://lists.gnucash.org/mailman/listinfo/gnucash-user>
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.




-- 

Wolfgang Rauchholz



___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: errir in SQL syntax

[AC]

You misspelled AUTO_INCREMENT (note the underscore character).


On 2017-12-17 23:03, Wolfgang Paul Rauchholz wrote:
> My config:
> Linux CENTOS 7, mariadb-5.5.56-2.el7.x86_64
> 
> Setting up the database on my home server. Will connect fomr laptops in the
> network onto mariadb.
> 
> When trying to execute this command.
> 
> CREATE TABLE slots (
> id integer PRIMARY KEY AUTOINCREMENT NOT NULL,
> obj_guidCHAR(32) NOT NULL,
> nametext(4096) NOT NULL,
> slot_type   integer NOT NULL,
> int64_val   integer,
> string_val  text(4096),
> double_val  real,
> timespec_valCHAR(14),
> guid_valCHAR(32),
> numeric_val_num integer,
> numeric_val_denom   integer
> );
> 
> I get this error. I can't find anything in google, so I'd hoped I get some
> help here. Thank you
> 
> 
> ERROR 1064 (42000): You have an error in your SQL syntax; check the manual
> that corresponds to your MariaDB server version for the right syntax to use
> near 'NOT NULL,
> obj_guidCHAR(32) NOT NULL,
> nametex' at line 2
> 
> 
> Thansk for your help
> 
> 

___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Gnucash Portable

[AC]

No, he's talking about GnuCash Portable which is a copy of GnuCash
modified and packaged with all the necessary libraries to be able to run
directly from a memory stick or other portable storage device without
having to install the libraries.  It's packaged by PortableApps.com.

On 2017-12-06 20:21, Kurt Padilla wrote:
> I think you are referring to the Android version. It is a well designed app
> that works really well for recording the transactions you make throughout
> the day. You can import from or export to GnuCash for the desktop easily. I
> think the default setting is to only export transactions entered since your
> previous export. I usually use Resilio Sync to transmit files between my
> desktop and smartphone.
> 
> Kurt
> 
> On Wed, Dec 6, 2017, 18:57 Steve  wrote:
> 
>> I used it briefly a few years ago. Just noticed, unless I'm mistaken, it
>> was
>> updated in October of this year (2017).
>>
>> Curious to hear how others are using the portable version (eg, why and
>> under
>> what circumstances), and how you're handling the backup and/or transfer of
>> the data files from the memory stick to your desktop, cloud, etc.
>>
>>
>>
>> --
>> Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
>> ___
>> gnucash-user mailing list
>> gnucash-user@gnucash.org
>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>> -
>> 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
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Could not obtain the lock

[AC]

On 2017-11-21 00:46, David Carlson wrote:
> Moira,
> 
> The lock file is always in the same folder as the data file and it always
> has the same name as the data file with the suffix .LCK  Unless you are
> doing something very unusual, the files will be visible in your file
> explorer as long as you put them somewhere in your user folder on your
> local machine ('C' Drive) or on a removable device.  If you are using cloud
> storage, you may have a problem with the configuration.
> 
> In Windows the user name matters when there are more than one user on the
> same machine, but on single user machines it does not matter if the files
> were created in another machine under a different user name.



One small point, it *can* matter whether a file works on a single user
machine or not depending how it was copied from one to the other.  If a
transfer was performed with something like a USB memory stick that is
formatted using FAT or FAT32 then there should not be any problems as
ownership information is stripped when using those storage formats.
However, if the transfer was performed with an NTFS formatted memory
stick or if it was a network copy that can maintain NTFS attributes then
there will be a problem.

Windows stores ownership information internally as GUIDs which will be
unique across all machines assuming the user account was created
directly (not enterprise user management).  It doesn't matter whether
the machine is "single user" or "multi user", every locally created user
has a GUID that other machines won't know about.
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [MAINT] Network Work on Code Sunday, Oct 1, 1-4pm EDT

[AC]

Another shot in the dark:

I don't know how you scored an Arris modem with static IPs (I have the
annoying AT/2Wire HGV3801 for my statics) but I found that heavy
traffic filled the very small memory for the CONNTRACK connection
tracking table which would cause massive packet loss.  In the HGV, all
traffic goes through the CONNTRACK table as if it was NATted even though
I'm using a static public IP.  Traffic headed for the modem itself also
goes through the CONNTRACK table.  The CONNTRACK table is tiny, about
1024 entries maximum, and the state machine is fairly dumb, unable to
reuse connections and constantly adding to the table.  On top of all
that, the default TTL of the table is 24 hours.  Any heavy traffic in or
outbound will quickly fill the table.  I reduced that TTL to about one
hour (you'll have to fiddle with it to find the right number) and a lot
of mysterious drops went away.  No idea if the Arris has a similar issue
but it's a quick test.

On 2017-10-06 07:47, Derek Atkins wrote:
> Yes.  Replaced the cables.  Changed the ports on the switch..
> Only thing I haven't tried yet is replacing the network card.
> 
> -derek
> 
> On Fri, October 6, 2017 10:27 am, David Carlson wrote:
>> Derek,
>>
>> Did you try replacing the cable? Low hanging fruit...
>>
>> David C
>>
>> On Fri, Oct 6, 2017 at 8:39 AM, Derek Atkins  wrote:
>>
>>> David Carlson  writes:
>>>
 Derek,

 Is it possible to read event logs and determine that some pieces of
>>> equipment
 are definitely not causing the problem?
>>>
>>> Well, if I unplug or otherwise disable the VM server then the problem
>>> goes away.  Similarly, if I shutdown two of the VMs (the two that
>>> generate the most traffic, by the way), the problem goes away.  I tried
>>> rebuilding one of the VMs and swapped over to that one (to test if,
>>> perhaps, the VM had been hacked)..  The problem did not go away.
>>>
>>> SO..  I have ordered a new network card for the server which should
>>> arrive tomorrow.  HOPEFULLY that will solve the problem.  We'll know
>>> soon.
>>>
 David C
>>>
>>> -derek
>>>
>>> --
>>>Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory
>>>Member, MIT Student Information Processing Board  (SIPB)
>>>URL: http://web.mit.edu/warlord/PP-ASEL-IA N1NWH
>>>warl...@mit.eduPGP key available
>>>
>>
> 
> 

___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: population

[AC]

On 2017-08-01 08:30, John Ralls wrote:

> The date range is selected on the general tab of report options. You'll find 
> a convenient button in the report toolbar for opening that dialog.
> 
> 1899 is a weird value. Have you set an accounting period?
> 
>
Windows uses 1/1/1900 as the first second of its epoch rather than the
Unix epoch of 1/1/1970.  The year 1899 will sometimes show up if you
feed Windows a zero for epoch seconds (depending on the program it might
also display as January 0, 1900 instead of December 31, 1899, Excel does
this)
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Tracking a TIAA mixed fund account

[AC]

On 2017-07-26 12:17, Eric Siegerman wrote:
> (Lost the attribution; sorry):
>> Assets:TIAA (cash)
>> Assets:TIAA:Lifecycle 1 (commodity)
>> Assets:TIAA:Lifecycle 2 (commodity)
>> Assets:TIAA:TIAA Mutual Fund (commodity)
> 
> I've never heard of TIAA before, but from what's been said, I
> infer that an account there behaves enough like a normal
> investment account for what follows to make sense, i.e. that it
> can hold numerous securities, but can also directly hold cash.
> 
> If that's so, I'd make one small change to the suggested layout:
> track the cash holdings in a fourth subaccount, rather than
> dumping them into the parent account, like so:
> 
> Assets:TIAA (placeholder -- see below)
> Assets:TIAA:Cash (cash)
> Assets:TIAA:Lifecycle 1 (commodity)
> etc.
> 
> That way you can see at a glance how much uninvested cash the
> TIAA account holds, while the parent Assets:TIAA GNC account
> shows its total value.
> 
> In this scheme, you'd never enter transactions directly into
> Assets:TIAA, but only into its subaccounts.  Turning the former
> into a "placeholder account" would help prevent mistakes in that
> regard, but is entirely optional.


The account does not have the ability to hold cash, whatever is sent
over to them from my paycheck is directly invested in one of the three
commodities.  The only thing the account has is a current cash value
based on the current market values of the commodities.  I'm going to try
the structure in a new file and see how it behaves.  If everything looks
ok then I'll recreate the structure in my main file and start entering
the data.
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Tracking a TIAA mixed fund account

[AC]

Seems like it might but what I want is to have the top level account
(let's just call it TIAA) follow the entire value of the portfolio.
Underneath that I want to see what the three individual funds are doing
(the two lifecycles and the mutual).  In the case of the lifecycle,
you're correct that it sort of looks like a mutual fund except that I
don't know what's actually inside it unlike a traditional MF where I
know the individual distribution of shares that make up the overall MF.

In this case then there would be three under TIAA, TIAA LC 1, TIAA LC2
and TIAA MF and I would want to see the individual values (in dollars)
of those three including the contributions to each, whatever dividends
they earn and then, in the case of TIAA MF, I'd want to have the
underlying distributions recorded just like a normal MF account.

I suppose the sticky point is having the value tracking of the whole
portfolio in addition to the individual fund values and then the MF
distributions.  Trying to get the cascade to work right.

On 2017-07-22 21:17, David T. wrote:
> I may be misunderstanding,  but it seems like the following would work:
> 
> Assets:TIAA (cash)
> Assets:TIAA:Lifecycle 1 (commodity)
> Assets:TIAA:Lifecycle 2 (commodity)
> Assets:TIAA:TIAA Mutual Fund (commodity)
> 
> My experience of the so called "Lifecycle" funds is that they are just like 
> any 
> other mutual funds.
> 
> When I handle payroll deductions, the dollars go into the cash account, and a 
> separate purchase transaction moves the cash into fund shares. It's a little 
> cumbersome, but it allows me to ensure that the right numbers get in.
> 
> HTH,
> David
> 
> On Sun, Jul 23, 2017 at 8:38, AC
> <gnuc...@acarver.net> wrote:
> I want to start tracking my TIAA retirement portfolio for informational
> purposes (no reporting needs, filings, etc.) but I need some suggestions
> on structuring the account trees so that it doesn't affect my existing
> accounts.  However, possibly later I'll edit things so that the paycheck
> contributions are directed accordingly so I'd want the new accounts to
> allow that eventually (i.e. for now I'll add contributions manually
> using a virtual source and eventually go back through and move those to
> withdraw from my paycheck, the amount withheld is already accounted)
> 
> The trick with my TIAA portfolio is that it has three different products
> within it.  Two of them are TIAA funds (one of the lifecycle multi-asset
> funds) that does not have a breakdown of the individual holdings (like a
> mutual fund).  These two only document the employer contributions, my
> contributions, shares and interest/dividends.  The third product is a
> TIAA mutual fund for which the individual holdings are broken out with
> all the same data as a typical mutual fund (shares, prices, etc.)
> 
> What I expect to have is some type of top-level account that tracks the
> overall value of the portfolio in dollars and then either within that or
> somewhere nearby an account or account tree for each of the three
> products.  At first I had considered just making the two TIAA funds into
> an account that was basically a mutual fund with a single holding but I
> wasn't quite sure how to combine that with the one real mutual fund when
> each of the three funds receives different amounts of contributions and
> individual dividends.  Perhaps it would be a top-level account then
> three sub-accounts that are all mutual funds with two of them having one
> holding and the last is the broken out holding?
> 
> I don't plan on using this for any official reporting (I get those
> documents already), and I don't plan on downloading statements, quotes,
> or anything else.  I'll just manually track things as my statements come
> in and I enter the data from those, perhaps updating symbol share prices
> manually if I'm interested at a particular time.  I don't currently use
> much reporting as is with my existing accounts except an occasional cash
> flow report so as long as that isn't affected I'm fine.  I do currently
> have a mutual fund being tracked so I want to be careful not to cause
> trouble for that either.
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org <mailto:gnucash-user@gnucash.org>
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> 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
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Tracking a TIAA mixed fund account

[AC]

I want to start tracking my TIAA retirement portfolio for informational
purposes (no reporting needs, filings, etc.) but I need some suggestions
on structuring the account trees so that it doesn't affect my existing
accounts.  However, possibly later I'll edit things so that the paycheck
contributions are directed accordingly so I'd want the new accounts to
allow that eventually (i.e. for now I'll add contributions manually
using a virtual source and eventually go back through and move those to
withdraw from my paycheck, the amount withheld is already accounted)

The trick with my TIAA portfolio is that it has three different products
within it.  Two of them are TIAA funds (one of the lifecycle multi-asset
funds) that does not have a breakdown of the individual holdings (like a
mutual fund).  These two only document the employer contributions, my
contributions, shares and interest/dividends.  The third product is a
TIAA mutual fund for which the individual holdings are broken out with
all the same data as a typical mutual fund (shares, prices, etc.)

What I expect to have is some type of top-level account that tracks the
overall value of the portfolio in dollars and then either within that or
somewhere nearby an account or account tree for each of the three
products.  At first I had considered just making the two TIAA funds into
an account that was basically a mutual fund with a single holding but I
wasn't quite sure how to combine that with the one real mutual fund when
each of the three funds receives different amounts of contributions and
individual dividends.  Perhaps it would be a top-level account then
three sub-accounts that are all mutual funds with two of them having one
holding and the last is the broken out holding?

I don't plan on using this for any official reporting (I get those
documents already), and I don't plan on downloading statements, quotes,
or anything else.  I'll just manually track things as my statements come
in and I enter the data from those, perhaps updating symbol share prices
manually if I'm interested at a particular time.  I don't currently use
much reporting as is with my existing accounts except an occasional cash
flow report so as long as that isn't affected I'm fine.  I do currently
have a mutual fund being tracked so I want to be careful not to cause
trouble for that either.
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Successful data recovery (was Re: File signatures??)

[AC]

On 2017-06-30 14:01, m...@considine.net wrote:
[recovery snipped]

In an emergency, since you're on a linux box, you should consider
ddrescue as an option to recover data from the disk.  I have
successfully used it to recover entire hard drives that were having
mechanical failures.  You can recover to an image file (which you can
later mount) or to another physical drive which will completely clone
the disk.

Recovery with ddrescue will attempt to maintain all structures on disk
and only pad out anything that it can't recover at all after several
attempts.  It can be quite slow depending on the state of the disk.  My
last recovery took two weeks of continuous operation due to spindle and
head bearing failures but I had a 100% recovery from that disk.
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Gnucash file is getting long!

[AC]

On 2017-06-17 12:04, John Ralls wrote:
> 
>> On Jun 17, 2017, at 10:22 AM, AC <gnuc...@acarver.net 
>> <mailto:gnuc...@acarver.net>> wrote:
>>
>> On 2017-06-17 00:07, Colin Law wrote:
>>> On 17 June 2017 at 02:31, AC <gnuc...@acarver.net 
>>> <mailto:gnuc...@acarver.net>> wrote:
>>>> On 2017-06-16 09:35, Derek Atkins wrote:
>>>>> Adam Funk <a24...@ducksburg.com <mailto:a24...@ducksburg.com>> writes:
>>>>>
>>>>>>> Not necessarily.  The "default" backend would be SQLite, which is a DB
>>>>>>> that stores into a single file.  So it will act like the current XML
>>>>>>> backend in terms of storage, but not necessarily the same with backup
>>>>>>> files.  However no server is required.
>>>>>>
>>>>>> Great!  Thanks to you & Colin for that information.
>>>>>
>>>>> Also keep in mind that the mysql data isn't compressed, so your disk
>>>>> space usage will grow significantly when using a SQL backend vs the
>>>>> (compressed) XML.
>>>>>
>>>>
>>>> You can enable compression in MySQL 5.5.  This applies to InnoDB table
>>>> types using a file per table and the Barracuda file format.  This
>>>> configuration must be enabled before the tables are created.
>>>
>>> Given the small size (in MySQL terms) of a GC database and the complex
>>> nature of some of the queries I suggest we would be better to accept a
>>> larger database and (presumably) quicker access. Though I suppose if
>>> the db indices are arranged appropriately the overhead may be small.
>>>
>>> Colin
>>
>> The disk speed is going to be the major performance driver even if GC
>> were running fully transactional rather than as the full table load.
>> For a modern processor and the size of the GC tables and indicies it's
>> really only going to be maybe a 5% slowdown in the actual transaction
>> within the CPU but disk write is always going to be much slower in wall
>> clock time.  However, there would likely be a recovery of that speed
>> when it's only having to handle transactions rather than manipulating a
>> massive data structure in memory and pushing all that to the database at
>> once.  In transaction mode with compression, the order of operations is
>> compression in memory then disk write so there's less data to write to
>> disk.  The loss in speed from the compression process would be made up
>> by the reduction in wait time for the disk write.
>>
>> There's lots of documentation and tests of MySQL's compression
>> performance especially in the later versions (after 5.7 where some code
>> optimizations were made).  The savings they report in space is about 40%
>> compression on average which isn't bad for a minor speed bump.
> 
> It doesn’t “push all that to the database”. It runs update or insert queries 
> for 
> the tables in question, very stupidly. For example, adding a GnuCash 
> transaction 
> will do one insert for the transaction record, one for each slot in the 
> transaction, one for each split, and one for each slot in each split.
> I don’t remember offhand how many slots normal transactions and splits have, 
> but 
> it isn’t a lot. The whole mess is wrapped in a database transaction.

Well ok, it makes many insert/update/appends and then the transaction
causes a pile of writes.  The disk I/O is still the bottleneck for most
applications.


> GnuCash uses generic SQL commands that work on all 3 supported databases. 
> That 
> would have to change in order for it to support MySql compression. GnuCash 
> would 
> also need a way to determine that the server is correctly configured. Neither 
> is 
> likely to get implemented any time soon.


No, that's the point of me bringing it up.  MySQL compression is
transparent.  It's done server side and has no bearing on the
applications accessing the data.  You configure the server to support
compressed tables then create the tables.  There's an option to allow
compression on a table-by-table basis or to simply enable it for all
tables by default.  GC would have no idea the tables were compressed.
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: A transaction report showing only charges

[AC]

On 2017-05-26 16:35, Maf. King wrote:
> On Friday, 26 May 2017 22:57:12 BST AC wrote:
>> Is there a way to configure any of the available reports to show only
>> charges or payments for a set of accounts?  For example I want to
>> generate a report of all the charges made on my credit card while
>> excluding the payments.  Using the transaction report I don't see a way
>> to do this.
>>
> 
> 
> Hi,
> 
> IIRC the transaction report options account selection tab has a Filter By... 
> section.
> 
> If your credit card only has payments from your bank account, then you can 
> Filter by... Exclude transactions from... Bank

Thanks that gets me halfway there.  I suppose it's probably not possible
to combine both and filter on payments (e.g. report on credit cards and
the bank account both of which have "charges" and skip any payments into
them).

___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

A transaction report showing only charges

[AC]

Is there a way to configure any of the available reports to show only
charges or payments for a set of accounts?  For example I want to
generate a report of all the charges made on my credit card while
excluding the payments.  Using the transaction report I don't see a way
to do this.

Alternatively would be a report that sums the columns of charges and
payments independently so I could see the number I want at the bottom.
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.