Re: [GNC] Saved Reports

[Stephen C. Camidge]

Interesting. That location did work.

Further, some data went to /home/steve/.var/app/org.gnucash.GnuCash/data/ 
<http://org.gnucash.gnucash/data/>

But /home/steve/.var/app/org.gnucash.GnuCash/data/gnucash/ 
<http://org.gnucash.gnucash/data/gnucash/> is more complete.

Thank you very much for your help.
Steve




On Mon, Jun 27, 2022, at 8:43 PM, David H wrote:
> Just rebooted into Mint Linux and mine are in 
> $HOME/.var/app/org.gnucash.GnuCash/data/gnucash - did you drill down far 
> enough ?  I seem to recall I would have manually copied my saved-reports-2.8 
> file into that directory as Flatpak obviously doesn't know about them 
> initially...
> 
> Cheers David H.
> 
> On Tue, 28 Jun 2022 at 10:34, Stephen C. Camidge  wrote:
>> __
>> Thank you, but I do not have any entries here:
>> $HOME/.local/share/flatpak/app/org.gnucash.GnuCash/
>> 
>> and the other is where I was looking, but the saved reports was not updated 
>> for 4.11
>> $HOME/.var/app/org.gnucash.GnuCash/
>> 
>> 
>> 
>> On Mon, Jun 27, 2022, at 3:34 PM, David H wrote:
>>> The wiki is your friend - https://wiki.gnucash.org/wiki/Flatpak
>>> 
>>> Cheers David H.
>>> 
>>> 
>>> On Tue, 28 Jun 2022 at 04:05, Stephen C. Camidge  
>>> wrote:
>>>> When using gnucash 4.10 installed from Linux Manjaro repository, my saved 
>>>> reports are stored here:
>>>>  /home/steve/.local/share/gnucash/
>>>> 
>>>> I installed gnucash 4.11 from flathub and saved a newly created report.  I 
>>>> cannot find where the report is stored on my hard drive. My plan was to 
>>>> move my old settings over to the flatbed version so I could properly test 
>>>> the latest version.
>>>> 
>>>> How do I find where 4.11 is storing the preferences?
>>>> ___
>>>> gnucash-user mailing list
>>>> gnucash-user@gnucash.org
>>>> To update your subscription preferences or to unsubscribe:
>>>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>>>> If you are using Nabble or Gmane, please see 
>>>> https://wiki.gnucash.org/wiki/Mailing_Lists for 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] Saved Reports

[Stephen C. Camidge]

Thank you, but I do not have any entries here:
$HOME/.local/share/flatpak/app/org.gnucash.GnuCash/

and the other is where I was looking, but the saved reports was not updated for 
4.11
$HOME/.var/app/org.gnucash.GnuCash/



On Mon, Jun 27, 2022, at 3:34 PM, David H wrote:
> The wiki is your friend - https://wiki.gnucash.org/wiki/Flatpak
> 
> Cheers David H.
> 
> 
> On Tue, 28 Jun 2022 at 04:05, Stephen C. Camidge  wrote:
>> When using gnucash 4.10 installed from Linux Manjaro repository, my saved 
>> reports are stored here:
>>  /home/steve/.local/share/gnucash/
>> 
>> I installed gnucash 4.11 from flathub and saved a newly created report.  I 
>> cannot find where the report is stored on my hard drive. My plan was to move 
>> my old settings over to the flatbed version so I could properly test the 
>> latest version.
>> 
>> How do I find where 4.11 is storing the preferences?
>> ___
>> gnucash-user mailing list
>> gnucash-user@gnucash.org
>> To update your subscription preferences or to unsubscribe:
>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>> If you are using Nabble or Gmane, please see 
>> https://wiki.gnucash.org/wiki/Mailing_Lists for 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] Saved Reports

[Stephen C. Camidge]

When using gnucash 4.10 installed from Linux Manjaro repository, my saved 
reports are stored here:
 /home/steve/.local/share/gnucash/

I installed gnucash 4.11 from flathub and saved a newly created report.  I 
cannot find where the report is stored on my hard drive. My plan was to move my 
old settings over to the flatbed version so I could properly test the latest 
version.

How do I find where 4.11 is storing the preferences?
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for 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] Linux still at 4.5

[Stephen C. Camidge]

It sort of worked.

I find my 4.5 data stored at either (I have files in both?)
/home/steve/.local/share/gnucash/
or
/home/steve/.local/share/GnuCash/

The flatpack data is stored at
/home/steve/.var/app/org.gnucash.GnuCash/data/

My reports now appear, and the open tabs are there (but accross the top of the 
screen instead of at the side), so I am not sure is all the preferences 
migrated.

But this helps. 

Thank you!



On Sun, Jul 25, 2021, at 6:53 AM, Guille Lopez wrote:
> Hi Stephen,
> 
> The problem you are seeing is caused by the fact that the normal distro 
> installation of GnuCash stores all the user data (e.g. custom reports) 
> typically under $HOME/.local/share/gnucash (or similar), and the flatpak 
> installation saves (and tries to find) the information under 
> $HOME/.var/app/org.gnucash.GnuCash/data (More info here: 
> https://wiki.gnucash.org/wiki/Configuration_Locations)
> 
> If you want to have the same environment when using the flatpak version, 
> you need to copy that information to the expected folder.
> 
> In order to prevent any kind of data loss, I would do the following:
> 
> 0) Backup your Gnucash file!!
> 
> 1) Backup your $HOME/.local/share/gnucash (check first that for your 
> distro, the gnucash is using that location).
> 
> 2) If you have already done some work from the flatpak version, backup 
> also $HOME/.var/app/org.gnucash.GnuCash/data.
> 
> 3) Copy the contents from $HOME/.local/share/gnucash into 
> $HOME/.var/app/org.gnucash.GnuCash/data.
> 
> 4) Try to open gnucash flatpak a try to open your saved reports. (They 
> should be there).
> 
> Best Regards,
> 
> Guille
> 
> On 25/07/2021 11:49, Stephen C. Camidge wrote:
> > I should add that there is also a gnucash-xbt 4.6-1 available, but I have 
> > not tried it. Not sure why there is another build.
> >
> > On Sun, Jul 25, 2021, at 5:46 AM, Stephen C. Camidge wrote:
> >> I am running Linux Manjaro and see that the aux distribution only gives 
> >> version 4.5 of Gnucash. There is a flatpack version of 4.6, but if I 
> >> install it, I do not have my saved reports and only the default preference.
> >>
> >> Where are the preferences stored? I would like to make them match what I 
> >> have when using the aux version?
> >>
> >> I am a newbie on Linux so need clear instructions.
> >>
> >> Thank you.
> > ___
> > gnucash-user mailing list
> > gnucash-user@gnucash.org
> > To update your subscription preferences or to unsubscribe:
> > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > If you are using Nabble or Gmane, please see 
> > https://wiki.gnucash.org/wiki/Mailing_Lists for 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] Linux still at 4.5

[Stephen C. Camidge]

I should add that there is also a gnucash-xbt 4.6-1 available, but I have not 
tried it. Not sure why there is another build.

On Sun, Jul 25, 2021, at 5:46 AM, Stephen C. Camidge wrote:
> I am running Linux Manjaro and see that the aux distribution only gives 
> version 4.5 of Gnucash. There is a flatpack version of 4.6, but if I install 
> it, I do not have my saved reports and only the default preference.
> 
> Where are the preferences stored? I would like to make them match what I have 
> when using the aux version? 
> 
> I am a newbie on Linux so need clear instructions.
> 
> Thank you.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for 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] Linux still at 4.5

[Stephen C. Camidge]

I am running Linux Manjaro and see that the aux distribution only gives version 
4.5 of Gnucash. There is a flatpack version of 4.6, but if I install it, I do 
not have my saved reports and only the default preference.

Where are the preferences stored? I would like to make them match what I have 
when using the aux version? 

I am a newbie on Linux so need clear instructions.

Thank you.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for 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] Moving to Linux

[Stephen C. Camidge]

Thank you.
Steve


On Fri, Mar 19, 2021, at 7:13 AM, Frank H. Ellenberger wrote:
> 
> 
> Am 13.03.21 um 20:42 schrieb Stephen C. Camidge:
> > Gnucash 3.0 and newer: The contents of GNC_DATA_HOME and GNC_CONFIG_HOME.
> > 
> > Linux: HOME/.gnucash - most of your preferences, adjusted report settings, 
> > column withs, window positions, etc.
> 
> Youu skipped the line
> * Gnucash 2.x and older:
> 
> There was a HOME/.gnucash, but not in GC >= 3.0
> 
> HTH
> Frank
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] gnucash-user Digest, Vol 216, Issue 27 re Linux

[Stephen C. Camidge]

Thank you all for the help I have received, but nothing helped me to locate the 
reports. I will try to recreate them.

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

Re: [GNC] gnucash-user Digest, Vol 216, Issue 27

[Stephen C. Camidge]

No Jim. I copied my files on my Mac to an external FAT32 (I think it is called) 
drive and opened it in Linux.

On Sat, Mar 13, 2021, at 4:52 PM, gnucash-user-requ...@gnucash.org wrote:
> Send gnucash-user mailing list submissions to
>   gnucash-user@gnucash.org
> 
> To subscribe or unsubscribe via the World Wide Web, visit
>   https://lists.gnucash.org/mailman/listinfo/gnucash-user
> or, via email, send a message with subject or body 'help' to
>   gnucash-user-requ...@gnucash.org
> 
> You can reach the person managing the list at
>   gnucash-user-ow...@gnucash.org
> 
> When replying, please edit your Subject line so it is more specific
> than "Re: Contents of gnucash-user digest..."
> 
> 
> Today's Topics:
> 
>1. Re:  Moving to Linux (John Ralls)
>2. Re:  Strange message on launching app (John Ralls)
>    3. Re:  Moving to Linux (Stephen C. Camidge)
>4. Re:  Moving to Linux (Stephen C. Camidge)
>5. Re:  Moving to Linux (David H)
>6. Re:  Moving to Linux (Stephen C. Camidge)
>7. Re:  Moving to Linux (D.)
>8. Re:  Moving to Linux (Alan Hopkins)
>9. Re:  Moving to Linux (David H)
>   10. Re:  Moving to Linux (Jim DeLaHunt)
> 
> 
> --------------
> 
> Message: 1
> Date: Sat, 13 Mar 2021 10:29:10 -0800
> From: John Ralls 
> To: "Stephen C. Camidge" 
> Cc: GNUCASH devel 
> Subject: Re: [GNC] Moving to Linux
> Message-ID: <156da4c6-8a4e-4ccc-8909-05f9997ea...@ceridwen.us>
> Content-Type: text/plain; charset=us-ascii
> 
> 
> 
> > On Mar 13, 2021, at 2:14 AM, Stephen C. Camidge  
> > wrote:
> > 
> > I am moving my data from Mac OS to Linux Manjaro.
> > 
> > I copied over the datafile, no problem.
> > 
> > How do I copy over my Saved Reports?
> > 
> > Also, since the Mac creates invisible '._*' files for each datafile, is 
> > there a Linux terminal command I can issue to get rid of all of them?
> 
> https://wiki.gnucash.org/wiki/Backup#Related_Files
> 
> I've never encountered ._* files, but you can get rid of them all with 
> `find path -name ._* -delete`, substituting the actual path you wand to 
> search for path.
> 
> Regards,
> John Ralls
> 
> 
> 
> --
> 
> Message: 2
> Date: Sat, 13 Mar 2021 10:47:54 -0800
> From: John Ralls 
> To: Mahon Finbar 
> Cc: Gnucash Users 
> Subject: Re: [GNC] Strange message on launching app
> Message-ID: <986dd69e-e6d7-417e-bc93-3a2301bf3...@ceridwen.us>
> Content-Type: text/plain; charset=us-ascii
> 
> The important thing is to make sure that you don't restore an old 
> version of GnuCash dlls. The most straightforward way is to leave 
> executables out of the backup plan because you can always download them 
> again from their respective sources. A bit less simple is to have a 
> separate backup set for them so that you can easily roll back after an 
> update or restore more quickly after a disk failure.
> 
> Regards,
> John Ralls
> 
> 
> > On Mar 13, 2021, at 6:06 AM, Mahon Finbar  wrote:
> > 
> > OK, I'll try that, thanks.
> > 
> > I have the most recent version for Windows 10, afaik. Haven't recently 
> > downloaded any update and have been using the current version for a while, 
> > like since last q 2020. Could be a storage glitch, I suppose.
> > 
> > Should I make a specific backup? I have backblaze for backup, but do I need 
> > to ensure files are the latest?
> > 
> > Finbar
> > 
> > On 12/03/2021 21:08, John Ralls wrote:
> >> You don't say what version of GnuCash, but GnuCash 4.x renamed 
> >> libgncmod-app-utils.dll to libgnc-app-utils.dll, so it seems that you have 
> >> some leftover bits from an earlier installation. Try uninstalling GnuCash 
> >> with Apps & Settings then delete the installation directory--it defaults 
> >> to C:\Program Files (x86)\gnucash--before reinstalling GnuCash 4.4.
> >> 
> >> Regards,
> >> John Ralls
> >> 
> >> 
> >>> On Mar 12, 2021, at 3:20 AM, Mahon Finbar  wrote:
> >>> 
> >>> Oops the screen grab didn't transfer -
> >>> 
> >>> "the procedure entry point gmc_scm_call_1_symbol_to_string could not be 
> >>> located in the dll C:\programfiles(x86)\gnucash\libgncmod-app-utils.dll"
> >>> 
> >>> On 12/03/2021 10:52, Mahon Finbar wrote:
> >>>> Sorry, sent this with the wrong email ad

Re: [GNC] Moving to Linux

[Stephen C. Camidge]

yes

On Sat, Mar 13, 2021, at 4:05 PM, David H wrote:
> Have you turned "Show Hidden files" on ???
> 
> Cheers David H.
> 
> 
> On Sun, 14 Mar 2021 at 05:43, Stephen C. Camidge  wrote:
>> I assumed that
>> 
>> General Configuration data
>> Gnucash 3.0 and newer: The contents of GNC_DATA_HOME and GNC_CONFIG_HOME.
>> 
>> Linux: HOME/.gnucash - most of your preferences, adjusted report settings, 
>> column withs, window positions, etc.
>> 
>> means that in HOME, I should find a directory called .gnucash but I do not 
>> see one?
>> 
>> 
>> 
>> On Sat, Mar 13, 2021, at 1:29 PM, John Ralls wrote:
>> > 
>> > 
>> > > On Mar 13, 2021, at 2:14 AM, Stephen C. Camidge  
>> > > wrote:
>> > > 
>> > > I am moving my data from Mac OS to Linux Manjaro.
>> > > 
>> > > I copied over the datafile, no problem.
>> > > 
>> > > How do I copy over my Saved Reports?
>> > > 
>> > > Also, since the Mac creates invisible '._*' files for each datafile, is 
>> > > there a Linux terminal command I can issue to get rid of all of them?
>> > 
>> > https://wiki.gnucash.org/wiki/Backup#Related_Files
>> > 
>> > I've never encountered ._* files, but you can get rid of them all with 
>> > `find path -name ._* -delete`, substituting the actual path you wand to 
>> > search for path.
>> > 
>> > Regards,
>> > John Ralls
>> > 
>> >
>> ___
>> gnucash-user mailing list
>> gnucash-user@gnucash.org
>> To update your subscription preferences or to unsubscribe:
>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>> If you are using Nabble or Gmane, please see 
>> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
>> -
>> Please remember to CC this list on all your replies.
>> You can do this by using Reply-To-List or Reply-All.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Moving to Linux

[Stephen C. Camidge]

I assumed that

General Configuration data
Gnucash 3.0 and newer: The contents of GNC_DATA_HOME and GNC_CONFIG_HOME.

Linux: HOME/.gnucash - most of your preferences, adjusted report settings, 
column withs, window positions, etc.

means that in HOME, I should find a directory called .gnucash but I do not see 
one?



On Sat, Mar 13, 2021, at 1:29 PM, John Ralls wrote:
> 
> 
> > On Mar 13, 2021, at 2:14 AM, Stephen C. Camidge  
> > wrote:
> > 
> > I am moving my data from Mac OS to Linux Manjaro.
> > 
> > I copied over the datafile, no problem.
> > 
> > How do I copy over my Saved Reports?
> > 
> > Also, since the Mac creates invisible '._*' files for each datafile, is 
> > there a Linux terminal command I can issue to get rid of all of them?
> 
> https://wiki.gnucash.org/wiki/Backup#Related_Files
> 
> I've never encountered ._* files, but you can get rid of them all with 
> `find path -name ._* -delete`, substituting the actual path you wand to 
> search for path.
> 
> 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] Moving to Linux

[Stephen C. Camidge]

Thank you very much. I will give the prefs a try!

Rather than actual path I would like to do the whole drive (remove all files 
that begin with '._*')

Steve


On Sat, Mar 13, 2021, at 1:29 PM, John Ralls wrote:
> 
> 
> > On Mar 13, 2021, at 2:14 AM, Stephen C. Camidge  
> > wrote:
> > 
> > I am moving my data from Mac OS to Linux Manjaro.
> > 
> > I copied over the datafile, no problem.
> > 
> > How do I copy over my Saved Reports?
> > 
> > Also, since the Mac creates invisible '._*' files for each datafile, is 
> > there a Linux terminal command I can issue to get rid of all of them?
> 
> https://wiki.gnucash.org/wiki/Backup#Related_Files
> 
> I've never encountered ._* files, but you can get rid of them all with 
> `find path -name ._* -delete`, substituting the actual path you wand to 
> search for path.
> 
> 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.

[GNC] Moving to Linux

[Stephen C. Camidge]

I am moving my data from Mac OS to Linux Manjaro.

I copied over the datafile, no problem.

How do I copy over my Saved Reports?

Also, since the Mac creates invisible '._*' files for each datafile, is there a 
Linux terminal command I can issue to get rid of all of them?

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

Re: [GNC] gnucash-user Digest, Vol 216, Issue 1

[Stephen C. Camidge]

Sorry Will, Gnucash does not supporrt that. I meant multiple registers. Derek 
provided the answer I needed.


On Mon, Mar 1, 2021, at 12:00 PM, gnucash-user-requ...@gnucash.org wrote:
> Send gnucash-user mailing list submissions to
>   gnucash-user@gnucash.org
> 
> To subscribe or unsubscribe via the World Wide Web, visit
>   https://lists.gnucash.org/mailman/listinfo/gnucash-user
> or, via email, send a message with subject or body 'help' to
>   gnucash-user-requ...@gnucash.org
> 
> You can reach the person managing the list at
>   gnucash-user-ow...@gnucash.org
> 
> When replying, please edit your Subject line so it is more specific
> than "Re: Contents of gnucash-user digest..."
> 
> 
> Today's Topics:
> 
>1. Re:  Wrong numeric separators in new file (Tony Vanson)
>2. Re:  gnucash finance quote not installed properly (David H)
>3. Re:  USAA FSB requires newer QWIN support (hmp3)
>4.  File locations to restore when migrating Linux computers?
>   (Adam Funk)
>5.  Linux question (Stephen C. Camidge)
>6. Re:  Linux question (Derek Atkins)
>7. Re:  Linux question (Stephen C. Camidge)
>8. Re:  Linux question (w...@theprescotts.com)
>9. Re:  Linux question (Derek Atkins)
> 
> 
> --
> 
> Message: 1
> Date: Mon, 1 Mar 2021 11:30:52 +0700
> From: Tony Vanson 
> To: John Ralls 
> Cc: GnuCash-User 
> Subject: Re: [GNC] Wrong numeric separators in new file
> Message-ID:
>   
> Content-Type: text/plain; charset="UTF-8"
> 
> Thank you all - fixed.
> In Windows 10 Region/Additional Settings/Customise Format did the trick.
> Beats me why the format was changed in the first place - but that is
> Windows for ya' :-)
> Cheers
> 
> <https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail>
> Virus-free.
> www.avast.com
> <https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail>
> <#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>
> 
> On Mon, Mar 1, 2021 at 11:08 AM John Ralls  wrote:
> 
> > That's for accounts, e.g. Assets:Current:Bank of America:Checking.
> >
> > Tony is asking about ',' and '.' to separate parts of a number. That's
> > driven by locale settings, so have a look at
> > https://wiki.gnucash.org/wiki/Locale_Settings. Remember that GnuCash is
> > *not* a native Windows app and doesn't understand custom settings in Region
> > & Language.
> >
> > Regards,
> > John Ralls
> >
> > > On Feb 28, 2021, at 7:28 PM, Adrien Monteleone <
> > adrien.montele...@lusfiber.net> wrote:
> > >
> > > Preferences > Accounts > Separator Character
> > >
> > > Regards,
> > > Adrien
> > >
> > > On 2/28/21 9:11 PM, Tony Vanson wrote:
> > >> Hi All,
> > >> On Windows 10 and Gnucash 4.4
> > >> After a catastrophic failure of my laptop, which also took out my
> > external
> > >> backup drive, I found a 2 year old backup on another drive.
> > >> The data loss is not a huge problem as it is solely for my own use.
> > >> I closed that old file and used it to create a new file hierarchy with
> > >> every account in the new file showing zero - all good.
> > >> However I notice when entering amounts now that the thousands separator
> > is
> > >> a decimal point and the decimal point is a comma e.g. $10.000.000,00.
> > >> I've dug around some but haven't been able to find where I can change
> > the
> > >> separators.
> > >> Any advice is much appreciated
> > >> Cheers
> > >
> > > ___
> > > gnucash-user mailing list
> > > gnucash-user@gnucash.org
> > > To update your subscription preferences or to unsubscribe:
> > > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > > If you are using Nabble or Gmane, please see
> > https://wiki.gnucash.org/wiki/Mailing_Lists for 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/gnu

Re: [GNC] Linux question

[Stephen C. Camidge]

Got it. Thank you very much. I missed it. Now all is working as expected.


On Mon, Mar 1, 2021, at 11:57 AM, Derek Atkins wrote:
> Hi,
> 
> On Mon, March 1, 2021 11:49 am, Stephen C. Camidge wrote:
> > I am looking to modify Gnucash preferences on Linux.
> 
> Like I said... Edit -> Preference.
> 
> If it's not being stored persistently, then you don't have the dconf
> service running.
> 
> > I mean multiple registers open.
> 
> It absolutely supports this.  You may need to flip the preference from Tab
> to Window or Window to Tab depending on how you want it to behave.  Edit
> -> Preferences -> Register Defaults, "Register opens in new window"
> 
> > Thank you,
> > Steve
> 
> -derek
> -- 
>Derek Atkins 617-623-3745
>de...@ihtfp.com www.ihtfp.com
>Computer and Internet Security Consultant
> 
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Linux question

[Stephen C. Camidge]

I am looking to modify Gnucash preferences on Linux.

I mean multiple registers open.

Thank you,
Steve


On Mon, Mar 1, 2021, at 11:46 AM, Derek Atkins wrote:
> Hi,
> 
> On Mon, March 1, 2021 11:39 am, Stephen C. Camidge wrote:
> > I am starting to learn about Linux (I use Gnucash on my Mac) and copied my
> > datafile over to Gnucash installed on Manjaro Linux via a flashdrive.
> >
> > On the Mac I have preferences I can tweak and I can have mutiple data
> > accounts open at once. I do not see this under Linux.
> 
> Linux has preferences you can tweak.  Edit -> Preferences.
> 
> As for "multiple data accounts" -- do you mean "multiple files" open, or
> just multiple registers open?  You can absolutely have multiple registers
> open..  For multiple data files, on Linux, you need to run GnuCash
> multiple times -- I wasn't sure you could even DO that on a Mac?
> 
> >
> > Please advise.
> 
> Hope this helps..
> 
> >
> > Thank you
> > Steve
> 
> > Please remember to CC this list on all your replies.
> > You can do this by using Reply-To-List or Reply-All.
> 
> -derek
> -- 
>Derek Atkins 617-623-3745
>de...@ihtfp.com www.ihtfp.com
>Computer and Internet Security Consultant
> 
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] Linux question

[Stephen C. Camidge]

I am starting to learn about Linux (I use Gnucash on my Mac) and copied my 
datafile over to Gnucash installed on Manjaro Linux via a flashdrive.

On the Mac I have preferences I can tweak and I can have mutiple data accounts 
open at once. I do not see this under Linux. 

Please advise.

Thank you
Steve
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for 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] Mac OS 11

[Stephen C. Camidge]

Has anyone reached a conclusion as to whether Gnucash works properly under Big 
Sur?
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for 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] journal entries

[Stephen C. Camidge]

Enter the date and description. On the first time Credit Cash for the amount. 
On the second line, Debit Drugs for the amount.

That should do it.


On Mon, Aug 12, 2019, at 10:50 AM, Harold via gnucash-user wrote:
> I have searched, looked, and read what I could find about journal entries in 
> GC but I am no closer to understanding what I need to do to enter a journal 
> entry. I am not an accountant and am using GC for my personal bookkeeping. I 
> have entered journal entries in Quickbooks in the past but don't understand 
> how to do it in GC. Can anyone nudge me in the right direction?Thanks,Harold
> 
>  On Sunday, August 11, 2019, 5:15:41 PM CDT, John Ralls  
> wrote: 
> 
> 
> 
> > On Aug 11, 2019, at 11:56 AM, Harold via gnucash-user 
> >  wrote:
> > 
> > I want to start tracking the cash payments that I make for drugs. I have 
> > been searching about making a journal entry in Gnucash but haven't found 
> > anything yet. Where do I find how to enter a journal entry in Gnucash using 
> > Linux?
> > ___
> 
> Have you studied the Tutorial and Concepts Guide [1]?
> 
> Regards,
> John Ralls
> 
> [1] http://www.gnucash.org/viewdoc.phtml?rev=3⟨=C&doc=guide or Help>Tutorial 
> and Concepts Guide from inside 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.
> 
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for 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] Include Account Numbers on Trial Balance

[Stephen C. Camidge]

Your accountant does not need account numbers. He will have his own software to 
generate his workpapers. He can work without them.

He may find it a convenience to have numbers to make sure that any adjusting 
entries later given to you go to the right place, but that is optional.


On Mon, Jul 22, 2019, at 6:28 AM, Charles Peter Avery wrote:
> Thank you. I have raised an enhancement.
> I do not know how to respond to Liz as there is no email address? My reply
> to her is that it is a requirement from my accountant.
> 
> Charles Avery
> 
> -Original Message-
> From: gnucash-user
> [mailto:gnucash-user-bounces+cavery=bigpond.net...@gnucash.org] On Behalf Of
> Liz
> Sent: Monday, 22 July 2019 7:43 PM
> To: gnucash-user@gnucash.org
> Subject: Re: [GNC] Include Account Numbers on Trial Balance
> 
> On Mon, 22 Jul 2019 08:00:00 +
> Christopher Lam  wrote:
> 
> > This is not currently possible in the Trial Balance. Please file an
> > enhancement on https://bugs.gnucash.org/
> > 
> > 
> > On Sun, 21 Jul 2019 at 09:33, Charles Peter Avery
> >  wrote:
> > 
> > > Hello,
> > >
> > > I am a new user to GNUcash and I need to include account numbers on
> > > my trial
> > > balance report for my accountant and I cannot figure out how to do
> > > this. Would you be able to provide some advice please? I have
> > > established the accounting tree with account numbers. I am not a
> > > programmer and have no knowledge of programming languages.
> > >
> > > Regards
> > > Charles Avery
> > > _
> 
> Workaround
> Export to a file which you open in a spreadsheet
> Add in the account numbers...
> 
> It's slightly better than printing and writing them in.
> 
> Is this a requirement of your jurisdiction or of your accountant?
> 
> Liz
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
> 
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for 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] Multi column Income Statement

[Stephen C. Camidge]

No change, subaccounts still double size & black.


On Fri, Jul 5, 2019, at 11:59 PM, Christopher Lam wrote:
> Glad you like it. The subtotals are styled as such to highlight they include 
> >1 account totals.
> Try Display/Parent account amounts include children option.
> 
> On Fri, 5 Jul 2019 at 12:54, Stephen Camidge  wrote:
>> Most welcome report!
>> 
>>  Flaw - subaccount totals are double size & black
>> 
>> 
>>  -- 
>> 
>>  Stephen C. camidgescami...@fastmail.fm(519) 363-3912
>> 
>> 
>> 
>> 
>>  
>>  ___
>>  gnucash-user mailing list
>> gnucash-user@gnucash.org
>>  To update your subscription preferences or to unsubscribe:
>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>>  If you are using Nabble or Gmane, please see 
>> https://wiki.gnucash.org/wiki/Mailing_Lists for 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] Reconcile bug

[Stephen C. Camidge]

Definitely.

Steve


On Fri, Jun 14, 2019, at 11:49 AM, Colin Law wrote:
> Are you sure you are running 3.5? I seem to remember such a bug in one
> of the early 3.x releases.
> 
> Colin
> 
> On Fri, 14 Jun 2019 at 13:52, Stephen C. Camidge  wrote:
> >
> > Using version 3.5 on Mac OS, I find the following:
> >
> > Reconcile a bank or credit card, but at the end, hit postpone. I do this so 
> > that I can keep track of what is currently reconciled. I do the full 
> > reconcile at monthend.
> >
> > Save the file.
> >
> > Close the file.
> >
> > Re-open the file.
> >
> > Reconcile the bank or credit card. The previously partially reconciled 
> > items are no longer partially reconciled.
> >
> > This happens most of the time - sometimes it stays partially reconciled. To 
> > me, it should stay partially reconciled.
> >
> > Is this a known feature?
> >
> > ___
> > gnucash-user mailing list
> > gnucash-user@gnucash.org
> > To update your subscription preferences or to unsubscribe:
> > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > If you are using Nabble or Gmane, please see 
> > https://wiki.gnucash.org/wiki/Mailing_Lists for 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] Reconcile bug

[Stephen C. Camidge]

The transactions retain the 'c' but are not always checked off when I resume 
the reconciliation vis the reconcile window.



On Fri, Jun 14, 2019, at 9:41 AM, Adrien Monteleone wrote:
> Not sure, but ‘partially reconciled’ is simply ‘cleared’ as you can 
> change the individual transactions in the register to ‘c’ without using 
> the reconciliation procedure. When you start that process, all 
> transactions marked ‘c’ will be checked off for you.
> 
> That status *should* be saved however, I would think, even if they 
> aren’t checked off manually. (that is, via the reconcile window)
> 
> Regards,
> Adrien
> 
> > On Jun 14, 2019, at 7:50 AM, Stephen C. Camidge  
> > wrote:
> > 
> > Using version 3.5 on Mac OS, I find the following:
> > 
> > Reconcile a bank or credit card, but at the end, hit postpone. I do this so 
> > that I can keep track of what is currently reconciled. I do the full 
> > reconcile at monthend.
> > 
> > Save the file.
> > 
> > Close the file.
> > 
> > Re-open the file.
> > 
> > Reconcile the bank or credit card. The previously partially reconciled 
> > items are no longer partially reconciled. 
> > 
> > This happens most of the time - sometimes it stays partially reconciled. To 
> > me, it should stay partially reconciled.
> > 
> > Is this a known feature?
> 
> 
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for 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] Reconcile bug

[Stephen C. Camidge]

Using version 3.5 on Mac OS, I find the following:

Reconcile a bank or credit card, but at the end, hit postpone. I do this so 
that I can keep track of what is currently reconciled. I do the full reconcile 
at monthend.

Save the file.

Close the file.

Re-open the file.

Reconcile the bank or credit card. The previously partially reconciled items 
are no longer partially reconciled. 

This happens most of the time - sometimes it stays partially reconciled. To me, 
it should stay partially reconciled.

Is this a known feature?

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for 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] Unsplitting a transaction

[Stephen C. Camidge]

For personal use and for most businesses, this would be the appropriate method. 
For larger businesses with EDP Auditors (do they still exist?) and regulations 
with accountability for the how data is maintained, the transactions should be 
locked. However, in that kind of environment, a free program like GNU Cash 
would not likely meet their needs or be permitted. So, it is safe to continue 
not to support that feature.

-- 
Stephen C. Camidge scami...@fastmail.fm   (519) 363-3912

On Thu, Jun 6, 2019, at 9:18 AM, Mike or Penny Novack wrote:
> On 6/5/2019 3:45 PM, Stephen M. Butler wrote:
> 
> >
> >> If you did that, then you didn't properly remove the other splits.  You
> >> need to go into each cell and manually remove the data, then tab out..
> >> Then use the arrow key to move up and the split will disappear.  Continue
> >> until all the extra splits are gone.
> 
> Not a practical "how to do" answer but it might be a good time to 
> mention that "how to correct" in general involves the question "how 
> formal is your process"?
> 
> In the old days, pen and ink on paper,  erroneous transactions were 
> never removed. They were offset (enter the reverse transaction) and then 
> the correct transaction entered. In other words, preserving an audit 
> trail that there was an error that was corrected << the description 
> fields would explain/refer to the erroneous transaction >>
> 
> THIS PROCESS is still what is done by those of us required to maintain 
> formal books. SOME accounting software will require it, not allow 
> existing transactions to be deleted/altered. Might be required in some 
> jurisdictions. There has been discussion in this forum that gnucash 
> being unable to prevent deletion/alteration is a fault << that is, not 
> offering this option -- in effect, open source software cannot provide 
> this sort of security as those with programming ability could use an 
> altered version of the program to defeat it >>
> 
> HOWEVER -- most of us using gnucash are not following the formal 
> process. WE will simply delete/alter erroneous transactions.
> 
> Michael
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Libre Office question - worth a shot

[Stephen C. Camidge]

I found a workaround that I can live with. Move the worksheet in workbook A to  
workbook B. Then it can automatically update to/from the other worksheets in 
workbook B.

Excel can do this even if I leave it in workbook A - pity LO cannot, but I 
should not complain about the limitations of free software, just be grateful 
for what it can do (which is a lot).

Thank you to all,
Steve

-- 


On Thu, May 23, 2019, at 4:40 PM, Adrien Monteleone wrote:
> Steve,
> 
> In LO preferences, set links to update Automatically (for trusted 
> sources)
> Under Macro Security, make sure you are *not* using the “Very High” 
> setting, “High" or less is fine.
> Then under Macro Security, Trusted Sources, in the file section, add a 
> local path where your files are stored. (I just added /, which might 
> not be safe, but it is fine for me, also, adding a path isn’t necessary 
> with the Low security setting)
> 
> Now, when you open the file with the links, it will simply update them 
> without asking.
> 
> If you want to have the links update without having to close and 
> re-open a file, such as having both spreadsheets open at the same time 
> and getting changes in one while updating the other, then instead of 
> copy/pasting or using normal references to other files, use the DDE 
> feature:
> 
> https://help.libreoffice.org/index.php?title=Calc/Spreadsheet_Functions&Language=en-GB&System=WIN&Version=5.1#bm_id3154680
> 
> Now, when you edit the source file and save it (that’s important) when 
> you click in the file with the links, they will auto-update. The help 
> document linked above says you have to use File > Reload (or close, 
> open) but I just tested this and it works simply by making that window 
> active. (this might be a preference I set and forgot about however)
> 
> Note the limitation that cross-platform links are not allowed using 
> DDE. (you can’t link a Linux spreadsheet from a Windows spreadsheet)
> 
> Unfortunately, LO does not have a keyboard shortcut for Reload, or Edit 
> > Links > Update, either of which would be very convenient and get you 
> the same ease of use without DDE.
> 
> Regards,
> Adrien
> 
> > On May 23, 2019, at 11:50 AM, Stephen C. Camidge  
> > wrote:
> > 
> > Sorry, this is off topic but I am quite frustrated and several of you will 
> > know Libre Office.
> > 
> > I have 2 spreadsheets that are linked, but unlike the behaviour in Excel, 
> > Libre Office will not refresh the links automatically when I make a change. 
> > I have set the preferences under Calc Tools and under Macro Security  to 
> > refresh. This allows undates when the file is opened. 
> > 
> > How do I get automatically refreshed links when both files are open?
> > 
> > Thank you.
> > Steve
> 
> 
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for 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] Libre Office question - worth a shot

[Stephen C. Camidge]

Thank you very much. I will experiment.
Steve

-- 
Stephen C. Camidge scami...@fastmail.fm   (519) 363-3912

On Thu, May 23, 2019, at 4:40 PM, Adrien Monteleone wrote:
> Steve,
> 
> In LO preferences, set links to update Automatically (for trusted 
> sources)
> Under Macro Security, make sure you are *not* using the “Very High” 
> setting, “High" or less is fine.
> Then under Macro Security, Trusted Sources, in the file section, add a 
> local path where your files are stored. (I just added /, which might 
> not be safe, but it is fine for me, also, adding a path isn’t necessary 
> with the Low security setting)
> 
> Now, when you open the file with the links, it will simply update them 
> without asking.
> 
> If you want to have the links update without having to close and 
> re-open a file, such as having both spreadsheets open at the same time 
> and getting changes in one while updating the other, then instead of 
> copy/pasting or using normal references to other files, use the DDE 
> feature:
> 
> https://help.libreoffice.org/index.php?title=Calc/Spreadsheet_Functions&Language=en-GB&System=WIN&Version=5.1#bm_id3154680
> 
> Now, when you edit the source file and save it (that’s important) when 
> you click in the file with the links, they will auto-update. The help 
> document linked above says you have to use File > Reload (or close, 
> open) but I just tested this and it works simply by making that window 
> active. (this might be a preference I set and forgot about however)
> 
> Note the limitation that cross-platform links are not allowed using 
> DDE. (you can’t link a Linux spreadsheet from a Windows spreadsheet)
> 
> Unfortunately, LO does not have a keyboard shortcut for Reload, or Edit 
> > Links > Update, either of which would be very convenient and get you 
> the same ease of use without DDE.
> 
> Regards,
> Adrien
> 
> > On May 23, 2019, at 11:50 AM, Stephen C. Camidge  
> > wrote:
> > 
> > Sorry, this is off topic but I am quite frustrated and several of you will 
> > know Libre Office.
> > 
> > I have 2 spreadsheets that are linked, but unlike the behaviour in Excel, 
> > Libre Office will not refresh the links automatically when I make a change. 
> > I have set the preferences under Calc Tools and under Macro Security  to 
> > refresh. This allows undates when the file is opened. 
> > 
> > How do I get automatically refreshed links when both files are open?
> > 
> > Thank you.
> > Steve
> 
> 
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for 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] Libre Office question - worth a shotx

[Stephen C. Camidge]

version 6.2.3.2 on Mac OS

Thank you for the tip re mail list.

Steve


-- 
Stephen C. Camidge scami...@fastmail.fm   (519) 363-3912

On Thu, May 23, 2019, at 1:09 PM, Rich Shepard wrote:
> On Thu, 23 May 2019, Stephen C. Camidge wrote:
> 
> > I have 2 spreadsheets that are linked, but unlike the behaviour in Excel,
> > Libre Office will not refresh the links automatically when I make a
> > change. I have set the preferences under Calc Tools and under Macro
> > Security  to refresh. This allows undates when the file is opened.
> >
> > How do I get automatically refreshed links when both files are open?
> 
> Steve,
> 
> Automagically? I don't know. However, I get Excel spreadsheets from clients
> and regulators and immediately save them as .ods files. When I open one that
> has links among the tabs a dialog box opens asking if I want to upgrade the
> links. Since it does no harm I usually let it do so.
> 
> What version of LO are you running? Mine currently is libreoffice-6.2.3 on
> Slackware-14.2. But, this behavior has not changed as far as I can remember.
> 
> Also, consider posting on the LO mail list: List-Subscribe:
> <mailto:users+subscr...@global.libreoffice.org>
> 
> Regards,
> 
> Rich
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] Libre Office question - worth a shot

[Stephen C. Camidge]

Sorry, this is off topic but I am quite frustrated and several of you will know 
Libre Office.

I have 2 spreadsheets that are linked, but unlike the behaviour in Excel, Libre 
Office will not refresh the links automatically when I make a change. I have 
set the preferences under Calc Tools and under Macro Security  to refresh. This 
allows undates when the file is opened. 

How do I get automatically refreshed links when both files are open?

Thank you.
Steve

-- 
Stephen C. Camidge scami...@fastmail.fm   (519) 363-3912

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for 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] Upcoming report deprecation

[Stephen C. Camidge]

I am a Mac user - I like options.

No, I do not use those report.

Steve


-- 
Stephen C. Camidge scami...@fastmail.fm   (519) 363-3912

On Sat, May 18, 2019, at 1:14 PM, D wrote:
> Steve,
> 
> Do you use any of these reports?
> 
> If not, then you won't suffer from the loss. The whole point of hiding 
> these reports is that they aren't generally used.
> 
> David
> 
> On May 18, 2019, at 9:27 PM, "Stephen C. Camidge"  
> wrote:
> 
> How will this work for those of us who do not use a command line? A new 
> preference?
> 
> Steve
> 
> 
> -- 
> Stephen C. Camidge scami...@fastmail.fm   (519) 363-3912
> 
> On Sat, May 18, 2019, at 8:21 AM, Geert Janssens wrote:
> > Hi,
> > 
> > I'm looking at https://bugs.gnucash.org/show_bug.cgi?id=773198
> > This bug proposes to remove a number of reports from the reports menu on 
> > the 
> > assumption these reports are primarily demo's of what can be achieved in 
> > gnucash, but have limited actual value. This is about the following reports:
> > 
> > Average Balance
> > Expenses vs. Day of Week
> > Income vs. Day of Week
> > Sample Report with Examples
> > 
> > Instead of completely removing them I plan to move them to a separate 
> > "Examples" sub menu (the former "Sample & Custom" menu) and hide this menu 
> > by 
> > default. It could be made visible by running gnucash with the '--extra' 
> > command line switch.
> > 
> > If you are actively using any of these reports please let us know which 
> > ones 
> > and also how these reports benefit you in practice.
> > 
> > Regards,
> > 
> > Geert
> > 
> > 
> > ___
> > gnucash-user mailing list
> > gnucash-user@gnucash.org
> > To update your subscription preferences or to unsubscribe:
> > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > If you are using Nabble or Gmane, please see 
> > https://wiki.gnucash.org/wiki/Mailing_Lists for 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] Upcoming report deprecation

[Stephen C. Camidge]

How will this work for those of us who do not use a command line? A new 
preference?

Steve


-- 
Stephen C. Camidge scami...@fastmail.fm   (519) 363-3912

On Sat, May 18, 2019, at 8:21 AM, Geert Janssens wrote:
> Hi,
> 
> I'm looking at https://bugs.gnucash.org/show_bug.cgi?id=773198
> This bug proposes to remove a number of reports from the reports menu on the 
> assumption these reports are primarily demo's of what can be achieved in 
> gnucash, but have limited actual value. This is about the following reports:
> 
> Average Balance
> Expenses vs. Day of Week
> Income vs. Day of Week
> Sample Report with Examples
> 
> Instead of completely removing them I plan to move them to a separate 
> "Examples" sub menu (the former "Sample & Custom" menu) and hide this menu by 
> default. It could be made visible by running gnucash with the '--extra' 
> command line switch.
> 
> If you are actively using any of these reports please let us know which ones 
> and also how these reports benefit you in practice.
> 
> Regards,
> 
> Geert
> 
> 
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for 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] Questions

[Stephen C. Camidge]

Sounds like you wrote the program - I am new to this and do not know the 
history.

As a recently retired accountant, I am use GNU Cash as a replacement for 
Quickbooks. I like what I see, but would like the reporting capabilities of 
Quickbooks where possible. To me, monthly P&L and comparative P&L to prior year 
are very useful. I would never tell you not to implement it. I would rather 
request it.

Yes, I now see that I can export to a spreadsheet and modify it, but I do not 
think I should have to. The program should do it for me. My view may not match 
that of other people, so will use the workaround.

Thank you very much for the comments and advice (to all) and for the program!

-- 
Stephen C. Camidge scami...@fastmail.fm   (519) 363-3912

On Wed, May 8, 2019, at 8:59 AM, Michael or Penny Novack wrote:
> On 5/7/2019 11:22 PM, Adrien Monteleone wrote:
> 
> > Comparative-period P&L is not yet implemented in GnuCash. (but as Chris 
> > Lamm noted, he has a testing version of the report that *might* fit your 
> > needs - if you can try it, please do so)
> 
> One reason it has not been implemented is that when I began (2007) using 
> gnucash for organizational accounting I was advised not to bother.  A 
> non-profit, for annual reports, always shows this year vs last year 
> Balance Sheet and Statement of Revenues and Expenses (what a non-profit 
> calls P&L). As a recently retired senior analyst, decades 
> designing/writing financial systems software, and able to at least read 
> LISP, I could presumably have managed the scheme for these special 
> reports. And if I wrote them, I would have shared them.
> 
> The lawyer/accountant who said "do it outside of gnucash with a full 
> power editor" was persuasive, correct that there would STILL be a lot of 
> editing remaining to be done, so better to do all editing at one time 
> with one tool designed for the purpose.
> 
> Michael D Novack, FLMI
> 
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for 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] Questions

[Stephen C. Camidge]

I used Libre Office and it worked. Thank you very much for the workaround!

Steve


-- 
Stephen C. Camidge scami...@fastmail.fm   (519) 363-3912

On Wed, May 8, 2019, at 8:55 AM, Maf. King wrote:
> On Wednesday, 8 May 2019 12:33:34 BST Stephen C. Camidge wrote:
> > I tried that. I added an autosum command totalling a column with a result of
> > $0 (wrong total). It is like it treats the cell as text. I tried opening
> > with excels' Data buttons for From HTML and From Text - still no success.
> > > On Wednesday, 8 May 2019 12:13:05 BST Stephen C. Camidge wrote:
> > > > Thank you to both of you. I have not figured out how to export to a
> > > > spreadsheet - I tried but only could export to html, added a sum of the
> > > > column, but the sum gave a total of $0.
> > > 
> 
> 
> Sorry, yes.  Forgot a step.
> 
> the HTML has £123.45 in the cells.  Libre Office imports these as text. 
>  Doing a 
> Find and Replace on the whole sheet and replacing £ with  
> works in 
> Libre Office.  Hope Excel is similar.
> 
> HTH,
> Maf.
>  
> 
> 
> 
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for 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] Questions

[Stephen C. Camidge]

I tried that. I added an autosum command totalling a column with a result of $0 
(wrong total). It is like it treats the cell as text. I tried opening with 
excels' Data buttons for From HTML and From Text - still no success.


-- 
Stephen C. Camidge scami...@fastmail.fm   (519) 363-3912

On Wed, May 8, 2019, at 7:25 AM, Maf. King wrote:
> On Wednesday, 8 May 2019 12:13:05 BST Stephen C. Camidge wrote:
> > Thank you to both of you. I have not figured out how to export to a
> > spreadsheet - I tried but only could export to html, added a sum of the
> > column, but the sum gave a total of $0.
> 
> Hi Stephen
> 
> 2 suggestions:
> 
> 1. I believe that most popular, modern spreadsheets can open (or import) html.
> 
> 2. Copy & Paste the GC output into a blank spreadsheet
> 
> HTH,
> Maf.
> 
> 
> 
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for 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] Questions

[Stephen C. Camidge]

Thank you to both of you. I have not figured out how to export to a spreadsheet 
- I tried but only could export to html, added a sum of the column, but the sum 
gave a total of $0.


-- 
Stephen C. Camidge scami...@fastmail.fm   (519) 363-3912

On Tue, May 7, 2019, at 11:44 PM, Christopher Lam wrote:
> Thanks Adrien.
> I've realised that unless the multicolumn report is merged into mainstream,
> it will never gain enough exposure for bug reports. So perhaps it'll be
> better to merge for 3.6 into an 'experimental' submenu within reports.
> C
> 
> 
> On Wed, 8 May 2019 at 13:24, Adrien Monteleone <
> adrien.montele...@lusfiber.net> wrote:
> 
> > Stephen,
> >
> > Comparative-period P&L is not yet implemented in GnuCash. (but as Chris
> > Lamm noted, he has a testing version of the report that *might* fit your
> > needs - if you can try it, please do so)
> >
> > You *can* run a multi-column report with each period in its own column,
> > but it will get messy with each column having its own row headers, as
> > you’ve likely discovered. (you could set all columns to use all accounts,
> > show zero balance accounts, and then copy/paste or export to spreadsheet
> > and then manipulate from there)
> >
> > Probably an easier route is to maintain a spreadsheet of your P&L’s and
> > paste in each column every period. Be sure to include all account including
> > zero balance accounts so everything lines up on the proper rows in the
> > spreadsheet. (I use this method along with percentage and variance columns
> > that I add)
> >
> > Regards,
> > Adrien
> >
> > > On May 6, 2019, at 8:35 AM, Stephen C. Camidge 
> > wrote:
> > >
> > > 2) Yes, I can get multi column reports with the Transaction Report, show
> > totals monthly by account, but it will not display monthly totals and it
> > will not display Revenue separately from Expenses with totals for Revenue
> > and for Expenses.
> >
> >
> > ___
> > gnucash-user mailing list
> > gnucash-user@gnucash.org
> > To update your subscription preferences or to unsubscribe:
> > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > If you are using Nabble or Gmane, please see
> > https://wiki.gnucash.org/wiki/Mailing_Lists for 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] Questions

[Stephen C. Camidge]

Sorry. I followed the instructions but do not see the report in the Reports 
Menu.

Steve

--
Stephen C. Camidge scami...@fastmail.fm (519) 363-3912




On Mon, May 6, 2019, at 7:05 PM, Christopher Lam wrote:
> Oops it's set to "Experimental" menu.
> Just delete the 2 lines towards the end of the file as follows:
> 
> 'menu-path (list gnc:menuname-experimental)
> 
> On Tue, 7 May 2019 at 01:31, Stephen C. Camidge  wrote:
>> __
>> Thank you. I found the location but could not locate the report in the 
>> Reports Menu.
>> 
>> --
>> Stephen C. Camidge scami...@fastmail.fm (519) 363-3912
>> 
>> 
>> 
>> 
>> On Mon, May 6, 2019, at 10:31 AM, Christopher Lam wrote:
>>> Hi Stephen
>>> 
>>> You are very welcome to try the following report. Save it into 
>>> standard-reports folder, found deep within the Gnucash.app package, and it 
>>> will automatically add a new multicolumn income-statement and balance-sheet 
>>> report as you describe.
>>> 
>>> https://raw.githubusercontent.com/christopherlam/gnucash/maint-balsheet-pnl/gnucash/report/standard-reports/balsheet-pnl.scm
>>> 
>>> Your input will be very welcome regarding foreign-currency conversions, 
>>> realized/unrealized gain/loss, retained-earnings reporting. I'm sure you 
>>> know these definitions are a deep rabbit-hole. This report is a 
>>> work-in-progress for nearly 1 month due to unresolved questions.
>>> 
>>> Regards, Chris
>>> 
>>> On Mon, 6 May 2019 at 13:37, Stephen C. Camidge  
>>> wrote:
>>>> 2) Yes, I can get multi column reports with the Transaction Report, show 
>>>> totals monthly by account, but it will not display monthly totals and it 
>>>> will not display Revenue separately from Expenses with totals for Revenue 
>>>> and for Expenses.
>>>> 
>>>> 3) I did make the multiple selection. Thank you for confirming that 
>>>> something is indeed going on.
>>>> 
>>>> 
>>>> -- 
>>>> Stephen C. Camidge scami...@fastmail.fm (519) 363-3912
>>>> 
>>>> On Mon, May 6, 2019, at 9:17 AM, David T. wrote:
>>>> > 3 - I spoke too soon. There is something weird going on there. I can 
>>>> > select multiple accounts, and some will display, while others do not. 
>>>> > Not sure what is going on there.
>>>> > 
>>>> > > On May 6, 2019, at 6:38 PM, David T. via gnucash-user 
>>>> > >  wrote:
>>>> > > 
>>>> > > 2 - Multicolumn reports are already part of GnuCash.
>>>> > > 3 - I just loaded 3.5, ran the G/L report, selected a random set of 
>>>> > > disjoint accounts, and received sane results. Is it possible that when 
>>>> > > you attempted to select multiple accounts, you actually selected only 
>>>> > > the last account you clicked? Many’s the time that I have thought I 
>>>> > > had the Command key held down, only to discover that I’d succeeded in 
>>>> > > picking only that last account…
>>>> > > 
>>>> > > 
>>>> > > David
>>>> > > 
>>>> > >> On May 6, 2019, at 6:15 PM, Stephen C. Camidge  
>>>> > >> wrote:
>>>> > >> 
>>>> > >> 1) OK
>>>> > >> 
>>>> > >> 2) yes - this would be most useful
>>>> > >> 
>>>> > >> 3) General Ledger - I can select multiple accounts, but for me (Mac, 
>>>> > >> 3.5) only the first selected account appears in the General Ledger 
>>>> > >> Report.
>>>> > >> 
>>>> > >> -- 
>>>> > >> Stephen C. Camidge scami...@fastmail.fm (519) 363-3912
>>>> > >> 
>>>> > >> On Mon, May 6, 2019, at 8:41 AM, David T. wrote:
>>>> > >>> 1 - As I mentioned, account codes will work for this. Assign each 
>>>> > >>> account a numeric code, add the code column to the COA, and sort on 
>>>> > >>> it. 
>>>> > >>> Done.
>>>> > >>> 2 - Multicolumn reports.
>>>> > >>> 3 - Are you talking about the “General Ledger” report, or the 
>>>> > >>> “General 
>>>> > >>> Journal” report? My version of the former report (GC 3.4 under 
>>>> > &

Re: [GNC] Questions

[Stephen C. Camidge]

Thank you. I found the location but could not locate the report in the Reports 
Menu.

--
Stephen C. Camidge scami...@fastmail.fm (519) 363-3912




On Mon, May 6, 2019, at 10:31 AM, Christopher Lam wrote:
> Hi Stephen
> 
> You are very welcome to try the following report. Save it into 
> standard-reports folder, found deep within the Gnucash.app package, and it 
> will automatically add a new multicolumn income-statement and balance-sheet 
> report as you describe.
> 
> https://raw.githubusercontent.com/christopherlam/gnucash/maint-balsheet-pnl/gnucash/report/standard-reports/balsheet-pnl.scm
> 
> Your input will be very welcome regarding foreign-currency conversions, 
> realized/unrealized gain/loss, retained-earnings reporting. I'm sure you know 
> these definitions are a deep rabbit-hole. This report is a work-in-progress 
> for nearly 1 month due to unresolved questions.
> 
> Regards, Chris
> 
> On Mon, 6 May 2019 at 13:37, Stephen C. Camidge  wrote:
>> 2) Yes, I can get multi column reports with the Transaction Report, show 
>> totals monthly by account, but it will not display monthly totals and it 
>> will not display Revenue separately from Expenses with totals for Revenue 
>> and for Expenses.
>> 
>>  3) I did make the multiple selection. Thank you for confirming that 
>> something is indeed going on.
>> 
>> 
>>  -- 
>>  Stephen C. Camidge scami...@fastmail.fm (519) 363-3912
>> 
>>  On Mon, May 6, 2019, at 9:17 AM, David T. wrote:
>>  > 3 - I spoke too soon. There is something weird going on there. I can 
>>  > select multiple accounts, and some will display, while others do not. 
>>  > Not sure what is going on there.
>>  > 
>>  > > On May 6, 2019, at 6:38 PM, David T. via gnucash-user 
>>  wrote:
>>  > > 
>>  > > 2 - Multicolumn reports are already part of GnuCash.
>>  > > 3 - I just loaded 3.5, ran the G/L report, selected a random set of 
>> disjoint accounts, and received sane results. Is it possible that when you 
>> attempted to select multiple accounts, you actually selected only the last 
>> account you clicked? Many’s the time that I have thought I had the Command 
>> key held down, only to discover that I’d succeeded in picking only that last 
>> account…
>>  > > 
>>  > > 
>>  > > David
>>  > > 
>>  > >> On May 6, 2019, at 6:15 PM, Stephen C. Camidge  
>> wrote:
>>  > >> 
>>  > >> 1) OK
>>  > >> 
>>  > >> 2) yes - this would be most useful
>>  > >> 
>>  > >> 3) General Ledger - I can select multiple accounts, but for me (Mac, 
>> 3.5) only the first selected account appears in the General Ledger Report.
>>  > >> 
>>  > >> -- 
>>  > >> Stephen C. Camidge scami...@fastmail.fm (519) 363-3912
>>  > >> 
>>  > >> On Mon, May 6, 2019, at 8:41 AM, David T. wrote:
>>  > >>> 1 - As I mentioned, account codes will work for this. Assign each 
>>  > >>> account a numeric code, add the code column to the COA, and sort on 
>> it. 
>>  > >>> Done.
>>  > >>> 2 - Multicolumn reports.
>>  > >>> 3 - Are you talking about the “General Ledger” report, or the 
>> “General 
>>  > >>> Journal” report? My version of the former report (GC 3.4 under MacOX) 
>>  > >>> behaves exactly like the generic “Transaction Report” you mention 
>>  > >>> (indeed, I suspect that under the hood, that’s what it is). IOW, I am 
>>  > >>> able to select accounts for inclusion on the report. Can you explain 
>>  > >>> more specifically what you are doing and seeing, and what you expect 
>> to 
>>  > >>> find that you are not?
>>  > >>> 
>>  > >>> David
>>  > >>> 
>>  > >>>> On May 6, 2019, at 5:56 PM, Stephen C. Camidge 
>>  wrote:
>>  > >>>> 
>>  > >>>> 1) different order to reflect what I am used to seeing in other 
>> accounting programs
>>  > >>>> 
>>  > >>>> 2) I agree that comparative reports would be useful - other programs 
>> offer them as option, the program should too
>>  > >>>> 
>>  > >>>> 3) multiple accounts in a G/L report are standard elsewhere - the 
>> transaction report can do this, but the G/L detail report should.
>>  > >>>> 
>>  > >>>> 
>> 

Re: [GNC] Questions

[Stephen C. Camidge]

2 Thank you. I am not yet comfortable with using that report - can't get it to 
work. Will experiment later.

-- 
Stephen C. Camidge scami...@fastmail.fm   (519) 363-3912

On Mon, May 6, 2019, at 10:11 AM, David T. wrote:
> 2 - You misunderstand me. I am not speaking about using the Transaction 
> Report with subtotals. I am speaking about using multiple instances of 
> the Income report you desire, each set for the period you want. Go to 
> Reports->Sample & Custom Reports->Custom Multicolumn Report and set it 
> up with (for example) two columns, with an Income report for the 
> previous quarter in the first column, and an Income Report for the 
> current quarter in the second column.
> 
> 3 - There is something fishy with the General Ledger report. It doesn’t 
> seem to recognize certain accounts, and there doesn’t seem rhyme or 
> reason to the accounts it includes or omits. This is true in both 3.4 
> and 3.5. It doesn’t seem to be the currency of the accounts (that is, I 
> can see some but not all accounts denominated in different currencies). 
> It doesn’t seem to be the depth of the accounts selected (I can see 
> some but not all accounts at numerous different levels of the 
> hierarchy). I will note that it will not display a selected account if 
> there are no transactions in the period selected. However, that doesn’t 
> explain everything that’s going on here…
> 
> David
> 
> 
> > On May 6, 2019, at 7:05 PM, Stephen C. Camidge  wrote:
> > 
> > 2) Yes, I can get multi column reports with the Transaction Report, show 
> > totals monthly by account, but it will not display monthly totals and it 
> > will not display Revenue separately from Expenses with totals for Revenue 
> > and for Expenses.
> > 
> > 3) I did make the multiple selection. Thank you for confirming that 
> > something is indeed going on.
> > 
> > 
> > -- 
> > Stephen C. Camidge scami...@fastmail.fm   (519) 363-3912
> > 
> > On Mon, May 6, 2019, at 9:17 AM, David T. wrote:
> >> 3 - I spoke too soon. There is something weird going on there. I can 
> >> select multiple accounts, and some will display, while others do not. 
> >> Not sure what is going on there.
> >> 
> >>> On May 6, 2019, at 6:38 PM, David T. via gnucash-user 
> >>>  wrote:
> >>> 
> >>> 2 - Multicolumn reports are already part of GnuCash.
> >>> 3 - I just loaded 3.5, ran the G/L report, selected a random set of 
> >>> disjoint accounts, and received sane results. Is it possible that when 
> >>> you attempted to select multiple accounts, you actually selected only the 
> >>> last account you clicked? Many’s the time that I have thought I had the 
> >>> Command key held down, only to discover that I’d succeeded in picking 
> >>> only that last account…
> >>> 
> >>> 
> >>> David
> >>> 
> >>>> On May 6, 2019, at 6:15 PM, Stephen C. Camidge  
> >>>> wrote:
> >>>> 
> >>>> 1) OK
> >>>> 
> >>>> 2) yes - this would be most useful
> >>>> 
> >>>> 3) General Ledger - I can select multiple accounts, but for me (Mac, 
> >>>> 3.5) only the first selected account appears in the General Ledger 
> >>>> Report.
> >>>> 
> >>>> -- 
> >>>> Stephen C. Camidge scami...@fastmail.fm   (519) 363-3912
> >>>> 
> >>>> On Mon, May 6, 2019, at 8:41 AM, David T. wrote:
> >>>>> 1 - As I mentioned, account codes will work for this. Assign each 
> >>>>> account a numeric code, add the code column to the COA, and sort on it. 
> >>>>> Done.
> >>>>> 2 - Multicolumn reports.
> >>>>> 3 - Are you talking about the “General Ledger” report, or the “General 
> >>>>> Journal” report? My version of the former report (GC 3.4 under MacOX) 
> >>>>> behaves exactly like the generic “Transaction Report” you mention 
> >>>>> (indeed, I suspect that under the hood, that’s what it is). IOW, I am 
> >>>>> able to select accounts for inclusion on the report. Can you explain 
> >>>>> more specifically what you are doing and seeing, and what you expect to 
> >>>>> find that you are not?
> >>>>> 
> >>>>> David
> >>>>> 
> >>>>>> On May 6, 2019, at 5:56 PM, Stephen C. Camidge  
> >>>>>> wrote:
> >>>>

Re: [GNC] Questions

[Stephen C. Camidge]

Understood, thank you.

-- 
Stephen C. Camidge scami...@fastmail.fm   (519) 363-3912

On Mon, May 6, 2019, at 11:03 AM, wheelercsg-li...@yahoo.com wrote:
> I'm still using GnuCash 2.6.15, so it may be different in later 
> releases, but in 2.6.15 you can change the sort order of the top-level 
> accounts by clicking on the header labelled "Account Name".
> 
> > Date: Mon, 6 May 2019 07:13:17 -0400
> > From: Stephen Camidge
> > To:gnucash-user@gnucash.org
> > Subject: [GNC] Questions
> > Message-ID:<51dc21db-a256-9b77-a0a0-911a821d9...@fastmail.fm>
> > Content-Type: text/plain; charset=utf-8; format=flowed
> >
> > 1) I set up a new book on the Mac version of gnucash using "A Simple
> > Checkbook". The Chart of Accounts places Income below Expenses - why? I
> > added Top Level Accounts for Liabilities and it was put below Income.?
> > The Transaction Report shows Income below Expenses.? How do I change the
> > order?
> >
> > [snip]
> >
> > What am I missing?
> >
> > Thank you.
> 
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for 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] Questions

[Stephen C. Camidge]

2) Yes, I can get multi column reports with the Transaction Report, show totals 
monthly by account, but it will not display monthly totals and it will not 
display Revenue separately from Expenses with totals for Revenue and for 
Expenses.

3) I did make the multiple selection. Thank you for confirming that something 
is indeed going on.


-- 
Stephen C. Camidge scami...@fastmail.fm   (519) 363-3912

On Mon, May 6, 2019, at 9:17 AM, David T. wrote:
> 3 - I spoke too soon. There is something weird going on there. I can 
> select multiple accounts, and some will display, while others do not. 
> Not sure what is going on there.
> 
> > On May 6, 2019, at 6:38 PM, David T. via gnucash-user 
> >  wrote:
> > 
> > 2 - Multicolumn reports are already part of GnuCash.
> > 3 - I just loaded 3.5, ran the G/L report, selected a random set of 
> > disjoint accounts, and received sane results. Is it possible that when you 
> > attempted to select multiple accounts, you actually selected only the last 
> > account you clicked? Many’s the time that I have thought I had the Command 
> > key held down, only to discover that I’d succeeded in picking only that 
> > last account…
> > 
> > 
> > David
> > 
> >> On May 6, 2019, at 6:15 PM, Stephen C. Camidge  
> >> wrote:
> >> 
> >> 1) OK
> >> 
> >> 2) yes - this would be most useful
> >> 
> >> 3) General Ledger - I can select multiple accounts, but for me (Mac, 3.5) 
> >> only the first selected account appears in the General Ledger Report.
> >> 
> >> -- 
> >> Stephen C. Camidge scami...@fastmail.fm   (519) 363-3912
> >> 
> >> On Mon, May 6, 2019, at 8:41 AM, David T. wrote:
> >>> 1 - As I mentioned, account codes will work for this. Assign each 
> >>> account a numeric code, add the code column to the COA, and sort on it. 
> >>> Done.
> >>> 2 - Multicolumn reports.
> >>> 3 - Are you talking about the “General Ledger” report, or the “General 
> >>> Journal” report? My version of the former report (GC 3.4 under MacOX) 
> >>> behaves exactly like the generic “Transaction Report” you mention 
> >>> (indeed, I suspect that under the hood, that’s what it is). IOW, I am 
> >>> able to select accounts for inclusion on the report. Can you explain 
> >>> more specifically what you are doing and seeing, and what you expect to 
> >>> find that you are not?
> >>> 
> >>> David
> >>> 
> >>>> On May 6, 2019, at 5:56 PM, Stephen C. Camidge  
> >>>> wrote:
> >>>> 
> >>>> 1) different order to reflect what I am used to seeing in other 
> >>>> accounting programs
> >>>> 
> >>>> 2) I agree that comparative reports would be useful - other programs 
> >>>> offer them as option, the program should too
> >>>> 
> >>>> 3) multiple accounts in a G/L report are standard elsewhere - the 
> >>>> transaction report can do this, but the G/L detail report should.
> >>>> 
> >>>> 
> >>>> -- 
> >>>> Stephen C. Camidge scami...@fastmail.fm   (519) 363-3912
> >>>> 
> >>>> On Mon, May 6, 2019, at 8:08 AM, Michael or Penny Novack wrote:
> >>>>> On 5/6/2019 7:13 AM, Stephen Camidge wrote:
> >>>>>> 1) I set up a new book on the Mac version of gnucash using "A Simple 
> >>>>>> Checkbook". The Chart of Accounts places Income below Expenses - why? 
> >>>>>> I added Top Level Accounts for Liabilities and it was put below 
> >>>>>> Income.  The Transaction Report shows Income below Expenses.  How do I 
> >>>>>> change the order?
> >>>>> Collating sequence ( L > I)   Just curious, but why do you want a 
> >>>>> different order?
> >>>>> 
> >>>>>> 2) Income Statement show the selected period in the right order but 
> >>>>>> cannot show columns by month. Same with Profit and Loss. Transaction 
> >>>>>> report can, but in the wrong order (see 1).
> >>>>> You are asking for a series of "Income Statement" reports for 
> >>>>> consecutive periods displayed side by side (each P&L aka Statement of 
> >>>>> Revenues and Expenses < what called depends on entity, same report >. 
> >>>>>

Re: [GNC] Questions

[Stephen C. Camidge]

I am an accountant and am quite familiar with this information. I just expected 
to be able to select all transactions for a period in a number of accounts with 
the General Ledger report.

-- 
Stephen C. Camidge scami...@fastmail.fm   (519) 363-3912

On Mon, May 6, 2019, at 9:18 AM, Michael or Penny Novack wrote:
> On 5/6/2019 8:22 AM, Stephen C. Camidge wrote:
> 
> >
> > 3 - G/L is General Ledger
> >
> 
> Ah. being misled by the name of the report.
> 
> This is a situation where useful to understand how traditional pen and 
> ink on paper bookkeeping worked. You FIRST entered transactions in 
> chronological order into a "book" called the Journal. These entries were 
> then "posted" to the Ledger (to the ledger accounts affected).
> 
> Gnucash allows us to enter the transactions beginning in any of the 
> affected ledger accounts. We don't even see something resembling a 
> journal entry unless entering a "split transaction". In other words, the 
> journal is virtual.
> 
> But gnucash CAN show you the journal if you ask it to. As a report. Your 
> problem is with your expectation of what you are looking at when you ask 
> gnucash to give you a G/L or General Journal report.
> 
> 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] Questions

[Stephen C. Camidge]

1) OK

2) yes - this would be most useful

3) General Ledger - I can select multiple accounts, but for me (Mac, 3.5) only 
the first selected account appears in the General Ledger Report.

-- 
Stephen C. Camidge scami...@fastmail.fm   (519) 363-3912

On Mon, May 6, 2019, at 8:41 AM, David T. wrote:
> 1 - As I mentioned, account codes will work for this. Assign each 
> account a numeric code, add the code column to the COA, and sort on it. 
> Done.
> 2 - Multicolumn reports.
> 3 - Are you talking about the “General Ledger” report, or the “General 
> Journal” report? My version of the former report (GC 3.4 under MacOX) 
> behaves exactly like the generic “Transaction Report” you mention 
> (indeed, I suspect that under the hood, that’s what it is). IOW, I am 
> able to select accounts for inclusion on the report. Can you explain 
> more specifically what you are doing and seeing, and what you expect to 
> find that you are not?
> 
> David
> 
> > On May 6, 2019, at 5:56 PM, Stephen C. Camidge  wrote:
> > 
> > 1) different order to reflect what I am used to seeing in other accounting 
> > programs
> > 
> > 2) I agree that comparative reports would be useful - other programs offer 
> > them as option, the program should too
> > 
> > 3) multiple accounts in a G/L report are standard elsewhere - the 
> > transaction report can do this, but the G/L detail report should.
> > 
> > 
> > -- 
> > Stephen C. Camidge scami...@fastmail.fm   (519) 363-3912
> > 
> > On Mon, May 6, 2019, at 8:08 AM, Michael or Penny Novack wrote:
> >> On 5/6/2019 7:13 AM, Stephen Camidge wrote:
> >>> 1) I set up a new book on the Mac version of gnucash using "A Simple 
> >>> Checkbook". The Chart of Accounts places Income below Expenses - why? 
> >>> I added Top Level Accounts for Liabilities and it was put below 
> >>> Income.  The Transaction Report shows Income below Expenses.  How do I 
> >>> change the order?
> >> Collating sequence ( L > I)   Just curious, but why do you want a 
> >> different order?
> >> 
> >>> 2) Income Statement show the selected period in the right order but 
> >>> cannot show columns by month. Same with Profit and Loss. Transaction 
> >>> report can, but in the wrong order (see 1).
> >> You are asking for a series of "Income Statement" reports for 
> >> consecutive periods displayed side by side (each P&L aka Statement of 
> >> Revenues and Expenses < what called depends on entity, same report >. In 
> >> other words, EACH has a defined start and end date since this report is 
> >> for an interval.
> >> 
> >> To produce such a (finished) report, use an editor capable of supporting 
> >> columns and export each, then bring into its proper column. WHY not 
> >> "within" gnucash? Stop a moment and think. Think of all the possible 
> >> variations that would be wanted (how many to show in parallel, somebody 
> >> else might want quarters or years, not months). Think about the after 
> >> editing required (the CoA might have had changes, not exactly the same 
> >> in each interval).
> >> 
> >> BTW -- since I keep books for non-profits, usually doing two years in 
> >> parallel
> >> 
> >>> 
> >>> 3) G/L report shows one account only, no matter how many I select. 
> >>> Transaction Report can select all.
> >> Why would you expect different reports to be the same in this regard?
> >> 
> >> 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.
> 
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for 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] Questions

[Stephen C. Camidge]

1) different order to reflect what I am used to seeing in other accounting 
programs

2) I agree that comparative reports would be useful - other programs offer them 
as option, the program should too

3) multiple accounts in a G/L report are standard elsewhere - the transaction 
report can do this, but the G/L detail report should.


-- 
Stephen C. Camidge scami...@fastmail.fm   (519) 363-3912

On Mon, May 6, 2019, at 8:08 AM, Michael or Penny Novack wrote:
> On 5/6/2019 7:13 AM, Stephen Camidge wrote:
> > 1) I set up a new book on the Mac version of gnucash using "A Simple 
> > Checkbook". The Chart of Accounts places Income below Expenses - why? 
> > I added Top Level Accounts for Liabilities and it was put below 
> > Income.  The Transaction Report shows Income below Expenses.  How do I 
> > change the order?
> Collating sequence ( L > I)   Just curious, but why do you want a 
> different order?
> 
> > 2) Income Statement show the selected period in the right order but 
> > cannot show columns by month. Same with Profit and Loss. Transaction 
> > report can, but in the wrong order (see 1).
> You are asking for a series of "Income Statement" reports for 
> consecutive periods displayed side by side (each P&L aka Statement of 
> Revenues and Expenses < what called depends on entity, same report >. In 
> other words, EACH has a defined start and end date since this report is 
> for an interval.
> 
> To produce such a (finished) report, use an editor capable of supporting 
> columns and export each, then bring into its proper column. WHY not 
> "within" gnucash? Stop a moment and think. Think of all the possible 
> variations that would be wanted (how many to show in parallel, somebody 
> else might want quarters or years, not months). Think about the after 
> editing required (the CoA might have had changes, not exactly the same 
> in each interval).
> 
> BTW -- since I keep books for non-profits, usually doing two years in 
> parallel
> 
> >
> > 3) G/L report shows one account only, no matter how many I select. 
> > Transaction Report can select all.
> Why would you expect different reports to be the same in this regard?
> 
> 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] Questions

[Stephen C. Camidge]

2 - The Transaction Report is a workaround, but does not give a subtotal for 
income and a subtotal for expenses.

3 - G/L is General Ledger


--
Stephen C. Camidge scami...@fastmail.fm (519) 363-3912




On Mon, May 6, 2019, at 7:47 AM, David T. wrote:
> 1 - it's alphabetical. You could rename the accounts with numeric prefixes or 
> use account codes and story on them. 
> 
> 2 - the income statement isn't set up to accommodate those breakdowns. You 
> might try creating a multi column report with income statements for different 
> time periods.
> 
> 3 - don't even know what "G/L" stands for here, so can't help. 
> 
> David
> 
> 
> 
>> On Mon, May 6, 2019 at 16:44, Stephen Camidge
>>  wrote:
>> 1) I set up a new book on the Mac version of gnucash using "A Simple 
>> Checkbook". The Chart of Accounts places Income below Expenses - why? I 
>> added Top Level Accounts for Liabilities and it was put below Income. 
>> The Transaction Report shows Income below Expenses. How do I change the 
>> order?
>> 
>> 2) Income Statement show the selected period in the right order but 
>> cannot show columns by month. Same with Profit and Loss. Transaction 
>> report can, but in the wrong order (see 1).
>> 
>> 3) G/L report shows one account only, no matter how many I select. 
>> Transaction Report can select all.
>> 
>> What am I missing?
>> 
>> Thank you.
>> 
>> 
>> 
>> 
>> <https://www.postbox-inc.com>
>> ___
>> gnucash-user mailing list
>> gnucash-user@gnucash.org
>> To update your subscription preferences or to unsubscribe:
>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>> If you are using Nabble or Gmane, please see 
>> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
>> -
>> Please remember to CC this list on all your replies.
>> You can do this by using Reply-To-List or Reply-All.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] Liabilities

[Stephen C. Camidge]

New user, may be obvious.

For some reason the parent account Liabilities shows up after Income. Income 
shows up after Expenses. How do I reposition them? 

Thank you.




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