[GNC] P&L report for a specified period
Roger Lewry
lewry_bbc at yahoo.co.uk
Sat Aug 26 12:55:12 EDT 2023
Thank you to Michael Novack for his very clear guidance which has enabled me to generate a report for 2019.
Roger
Sent from Yahoo Mail on Android
On Sat, 26 Aug 2023 at 17:01, gnucash-user-request at gnucash.org<gnucash-user-request at gnucash.org> wrote: Send gnucash-user mailing list submissions to
gnucash-user at 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-request at gnucash.org
You can reach the person managing the list at
gnucash-user-owner at 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. Fwd: Gnucash (David Carlson)
2. Profit and loss report (Roger Lewry)
3. Re: Profit and loss report (Michael or Penny Novack)
4. Re: Issues with gnucash files (Maf. King)
5. Re: Fwd: Gnucash (Maf. King)
6. Re: Fwd: Gnucash (Stan Brown (using GC 4.14))
7. Re: Profit and loss report (Stan Brown (using GC 4.14))
8. Re: Fwd: Gnucash (Jeff)
9. Re: Fwd: Gnucash (David Cousens)
10. Re: Fwd: Gnucash (Adrien Monteleone)
----------------------------------------------------------------------
Message: 1
Date: Fri, 25 Aug 2023 11:09:54 -0500
From: David Carlson <david.carlson.417 at gmail.com>
To: "gnucash-user at gnucash.org" <gnucash-user at gnucash.org>
Subject: [GNC] Fwd: Gnucash
Message-ID:
<CADYgSbmkEVZWcWtqTU+dL1aY+bE=tME6Tq-cdvwmvRv0hrUZWQ at mail.gmail.com>
Content-Type: text/plain; charset="UTF-8"
Barry,
Please do not send messages to individuals on the Gnucash-user list.
I have no idea what did not go through in that prior email because it
didn't go through.
Then your next sentence confuses me too because I cannot tell if it is a
comment about the user list, about the GnuCash program. about your Email
app or about how permissions for users works in Windows.
---------- Forwarded message ---------
From: Barry Mahon <barrymahonb at gmail.com>
Date: Fri, Aug 25, 2023 at 10:24?AM
Subject: Gnucash
To: <david.carlson.417 at gmail.com>
Thanks to all.
On the issue of rights, I have never had any issues before this saga, so
should I assume I have had 'rights' to save documents under administrato??
When you say 'truncated' does that mean you cannot see the CaptureWiz
images?? I have had issues all along with Gnucash needing specific file
types to display files for messages, does that apply to gnucash-user?? For
reasons I don't understand I have never been able to copy files from Gnu in
my MS Windows10 to the 'required' format, for queries about Gnucash....!!
Quite frustrating.
Finbar
--
David Carlson
------------------------------
Message: 2
Date: Fri, 25 Aug 2023 19:31:53 +0000 (UTC)
From: Roger Lewry <lewry_bbc at yahoo.co.uk>
To: "gnucash-user at gnucash.org" <gnucash-user at gnucash.org>
Subject: [GNC] Profit and loss report
Message-ID: <272559447.654526.1692991913807 at mail.yahoo.com>
Content-Type: text/plain; charset=UTF-8
Please can anyone tell me if it is possible to generate a P&L report for a previous accounting period? I have been able to create a report for the period from 1 January 2023 to the present time but cannot see how to specify a different period. For example I would like to have a report for the calendar year 2019. Any help will be much appreciated.
I am using version 4.11 on Windows 10 Home 22H2.
Roger
Sent from Yahoo Mail on Android
------------------------------
Message: 3
Date: Fri, 25 Aug 2023 15:45:49 -0400
From: Michael or Penny Novack <stepbystepfarm at comcast.net>
To: gnucash-user at gnucash.org
Subject: Re: [GNC] Profit and loss report
Message-ID: <bdccf73b-135c-018c-98b6-9cd3eb894628 at comcast.net>
Content-Type: text/plain; charset=UTF-8; format=flowed
On 8/25/2023 3:31 PM, Roger Lewry via gnucash-user wrote:
> Please can anyone tell me if it is possible to generate a P&L report for a previous accounting period? I have been able to create a report for the period from 1 January 2023 to the present time but cannot see how to specify a different period. For example I would like to have a report for the calendar year 2019. Any help will be much appreciated.
> I am using version 4.11 on Windows 10 Home 22H2.
Rather basic --- you can run this report for ANY (valid) date interval.
edit => report options => general (remember, gnucash is peculiar in that
first you run a report and THEN you use report options to change it)
In the general specifications you get to choose start and stop date
(this report is always for a time interval). You don't have to be doing
the report for "current accounting period" but can change that to any
(valid) date range you desire.
Michael D Novack
* by valid I mean things like "start date must be before end date" and
"the date range is meaningful in terms of dates in your books".
------------------------------
Message: 4
Date: Sat, 26 Aug 2023 00:22:37 +0100
From: "Maf. King" <maf at chilwell.net>
To: Mahon Finbar <mahon.finbar at neuf.fr>
Cc: gnucash-user at gnucash.org
Subject: Re: [GNC] Issues with gnucash files
Message-ID: <3097604.U3zVgo479M at janus>
Content-Type: text/plain; charset="us-ascii"
On Friday, 25 August 2023 16:31:47 BST Mahon Finbar wrote:
> As I said, I have had unresolved issues with creating .jpg files from MS.
did you? sorry, must have missed that bit. is it easier to send a PNG? that
should get through as an attached image well enough.
>
> I'' try creating jpg from CaptureWiz and attach....
>
OK. or whatever file type CaptureWiz defaults to (I don't know that program).
I'd imagine that (some) others on the list and I can open the vast majority
of probable image formats this end.
good luck.
Maf.
------------------------------
Message: 5
Date: Sat, 26 Aug 2023 00:30:23 +0100
From: "Maf. King" <maf at chilwell.net>
To: "gnucash-user at gnucash.org" <gnucash-user at gnucash.org>
Subject: Re: [GNC] Fwd: Gnucash
Message-ID: <2803961.XrmoMso0CX at janus>
Content-Type: text/plain; charset="UTF-8"
I've just had a thought on a possible reason the original file could not be
saved. I may be barking up the wrong tree.....
Does Win have a maximum length for a filename?
If Barry (OP) has been repeatedly opening and working on backups and backups
of backups etc.., is it possible that repeated time-stamps have hit some sort
of string-length limit (either in Win, GC, Gnome-libs or whatever layer)??
Last time I was actively using MS for anything regularly, the filename length
limit was 8+3 ... so I'll defer to pretty much anyone's opinion on this!
Maf
On Friday, 25 August 2023 17:09:54 BST David Carlson wrote:
> Barry,
>
> Please do not send messages to individuals on the Gnucash-user list.
> I have no idea what did not go through in that prior email because it
> didn't go through.
> Then your next sentence confuses me too because I cannot tell if it is a
> comment about the user list, about the GnuCash program. about your Email
> app or about how permissions for users works in Windows.
>
> ---------- Forwarded message ---------
> From: Barry Mahon <barrymahonb at gmail.com>
> Date: Fri, Aug 25, 2023 at 10:24?AM
> Subject: Gnucash
> To: <david.carlson.417 at gmail.com>
>
>
> Thanks to all.
>
> On the issue of rights, I have never had any issues before this saga, so
> should I assume I have had 'rights' to save documents under administrato??
>
> When you say 'truncated' does that mean you cannot see the CaptureWiz
> images?? I have had issues all along with Gnucash needing specific file
> types to display files for messages, does that apply to gnucash-user?? For
> reasons I don't understand I have never been able to copy files from Gnu in
> my MS Windows10 to the 'required' format, for queries about Gnucash....!!
> Quite frustrating.
>
> Finbar
------------------------------
Message: 6
Date: Fri, 25 Aug 2023 18:46:53 -0700
From: "Stan Brown (using GC 4.14)" <stan+gc at fastmail.fm>
To: gnucash-user at gnucash.org
Subject: Re: [GNC] Fwd: Gnucash
Message-ID: <b5703058-e6c5-67e0-fb45-6b5f698d823d at fastmail.fm>
Content-Type: text/plain; charset=UTF-8
On 2023-08-25 16:30, Maf. King wrote:
> I've just had a thought on a possible reason the original file could not be
> saved. I may be barking up the wrong tree.....
>
> Does Win have a maximum length for a filename?
It does, both for filename specifically (see below) and for total of
path+filename. But recent versions of Windows have
increased it to the point where real-life use is unlikely to hit the limit.
However, "In the Windows API [for use by applications, as opposed to
components of Windows itself], the maximum length for a path is
MAX_PATH, which is defined as 260 characters. A local path is structured
in the following order: drive letter, colon, backslash, name components
separated by backslashes, and a terminating null character."
<https://learn.microsoft.com/en-us/windows/win32/fileio/maximum-file-path-limitation?tabs=registry>
I doubt that file save dialogs are be affected by that, since they're
part of Windows, but maybe.
Later in the same article, there is a procedure to remove that
limitation in the Windows API, if you're in Windows 10 or 11. I hesitate
to suggest that Barry try that procedure himself, because it involves
editing the Windows Registry. However, anyone who's comfortable with
Registry edits could easily follow the directions to do it for him.
> If Barry (OP) has been repeatedly opening and working on backups and backups
> of backups etc.., is it possible that repeated time-stamps have hit some sort
> of string-length limit (either in Win, GC, Gnome-libs or whatever layer)??
>
> Last time I was actively using MS for anything regularly, the filename length
> limit was 8+3 ... so I'll defer to pretty much anyone's opinion on this!
That limit was increased to 254 (or maybe 199) about 20 years ago, with
the release of Windows XP. No blame to you for not knowing, if you don't
use Windows.
<https://stackoverflow.com/questions/265769/maximum-filename-length-in-ntfs-windows-xp-and-windows-vista>
Stan Brown
Tehachapi, CA, USA
https://BrownMath.com
------------------------------
Message: 7
Date: Fri, 25 Aug 2023 18:54:10 -0700
From: "Stan Brown (using GC 4.14)" <stan+gc at fastmail.fm>
To: gnucash-user at gnucash.org
Subject: Re: [GNC] Profit and loss report
Message-ID: <ec4fed30-5ff0-a911-cf4d-06f16729ce3a at fastmail.fm>
Content-Type: text/plain; charset=UTF-8
On 2023-08-25 12:31, Roger Lewry via gnucash-user wrote:
> Please can anyone tell me if it is possible to generate a P&L report
> for a previous accounting period? I have been able to create a report
> for the period from 1 January 2023 to the present time but cannot see
> how to specify a different period. For example I would like to have a
> report for the calendar year 2019.
Create your report and press the Options icon in the top row. Select the
General tab, and you can select dates. Click Apply or OK.
If you don't want so much specific dates as "last month", you can select
those relative dates on that options screen. Having done that, you might
then want to select Save Report Configuration As, and then ion future
months you can use can select that report from the saved configurations
with no need to reset the dates.
Stan Brown
Tehachapi, CA, USA
https://BrownMath.com/
------------------------------
Message: 8
Date: Sat, 26 Aug 2023 12:52:37 +1000
From: Jeff <GnuCash-List at ratherbe.info>
To: gnucash-user at gnucash.org
Subject: Re: [GNC] Fwd: Gnucash
Message-ID: <54cd81f4-fa33-a8b7-990e-68561f362c3d at ratherbe.info>
Content-Type: text/plain; charset=UTF-8; format=flowed
On 26/8/23 11:46, Stan Brown (using GC 4.14) wrote:
> On 2023-08-25 16:30, Maf. King wrote:
>> I've just had a thought on a possible reason the original file could not be
>> saved. I may be barking up the wrong tree.....
>>
>> Does Win have a maximum length for a filename?
> It does, both for filename specifically (see below) and for total of
> path+filename. But recent versions of Windows have
> increased it to the point where real-life use is unlikely to hit the limit.
>
> However, "In the Windows API [for use by applications, as opposed to
> components of Windows itself], the maximum length for a path is
> MAX_PATH, which is defined as 260 characters. A local path is structured
> in the following order: drive letter, colon, backslash, name components
> separated by backslashes, and a terminating null character."
That limit does still exist, I have just been dealing with it where a
particular file would not open in LibreOffice Writer due to the limit
(actually it would open if LibreOffice was open and the file was opened
from inside LibreOffice, but it would not open if double clicked, while
all other (shorter) files opened fine via both methods).? It also did
strange things at the File Explorer level, such as not allowing the file
to copied to the same folder, with a suggested name change.? So the
issue affected both 3rd Party apps (LibreOffice) and Windows core apps
(Explorer).? I could see the possibility of the issue affecting GnuCash.
> I doubt that file save dialogs are be affected by that, since they're
> part of Windows, but maybe.
May well be, as above.
> Later in the same article, there is a procedure to remove that
> limitation in the Windows API, if you're in Windows 10 or 11. I hesitate
> to suggest that Barry try that procedure himself, because it involves
> editing the Windows Registry. However, anyone who's comfortable with
> Registry edits could easily follow the directions to do it for him.
Unfortunately the registry change isn't honoured by all apps.? Some have
the newly increased limit, and some don't.
This may or may not be the issue with OP, but there is a fair chance
that the maximum limit has been reached.
Regards,
Jeff.
------------------------------
Message: 9
Date: Sat, 26 Aug 2023 13:13:08 +1000
From: David Cousens <davidcousens49 at gmail.com>
To: gnucash-user at gnucash.org
Subject: Re: [GNC] Fwd: Gnucash
Message-ID: <296a0ea7fd4469f5b9b60fdbf8f768a03bfd6ecc.camel at gmail.com>
Content-Type: text/plain; charset="UTF-8"
Maf,
Windows after 95 had a maximum PATH length of 256 characters in Win32 apps but
after Windows 10 V1067 it is 32767 chars but use of this is apparently an option
(not a Windows user) requiring setting of the registry key
HKLM\SYSTEM\CurrentControlSet\Control\FileSystem LongPathsEnabled to a value of
1 (see post in
https://stackoverflow.com/questions/57807466/what-is-the-maximum-filename-length-in-windows-10-java-would-try-catch-would
for details)
Barry's problems seem to be more to do with Window's housekeeping than specific
GnuCash problems. I have GnuCash on a Windows 11 system my wife's) as well as
Linux Mint sharing the same data file from a dropbox server without any
difficulties. I have several sets of books (i.e. different GnuCash data files)
but I have made it a practice to keep each separate data file/set of books in
its own sub-directory/folder which keeps all the relevant backup and logfiles in
the one place. It also makes backing up the data easy as you just backup the
whole directory
Barry do you have all the gnucash data files and their associated backups and
log files in a single subdirectory/folder of your user directory. If you don't
it may be advisable to sort that out first.
The main data files have the format
<filename>.gnucash
the backup files
<filename>.gnucash.<timestamp>.gnucash
and the log files
<filename>,gnucash.<timestamp>.log
where <filename> is replaced by the name you gave your file and <timestamp> has
the format "yyyymmddhhmmss".
My practice is to keep there in a sub-directory with the name <filename> which
makes finding the datafiles easy and all of the separate datafile directories
are under a directory "GnuCash_Data_Files" in my user directory which makes them
easy to find.
If you have files with a double timestamp e.g.
<filename>.gnucash.<timestamp>.gnucash.<timestamp>.gnucash
it usually means you have opened up one of the backup files rather than the main
datafile <filename>.gnucash at some point.
If you do a
dir *.* /T:C >file_creation.txt
dir *.* /T:A > file_access.txt
in command window after changing directory to the directory your gnucash
datafiles are in and then attach the file_creation.txt and file_access.txt to a
message to the list we may be able to give you more assistance in sorting out
which files are which. This will list the filenames and their creation dates.
David Cousens
On Sat, 2023-08-26 at 00:30 +0100, Maf. King wrote:
> I've just had a thought on a possible reason the original file could not be
> saved.? I may be barking up the wrong tree.....
>
> Does Win have a maximum length for a filename?
>
> If Barry (OP) has been repeatedly opening and working on backups and backups
> of backups etc.., is it possible that repeated time-stamps have hit some sort
> of string-length limit (either in Win, GC, Gnome-libs or whatever layer)??
>
> Last time I was actively using MS for anything regularly, the filename length
> limit was 8+3 ... so I'll defer to pretty much anyone's opinion on this!
>
> Maf
>
>
>
>
> On Friday, 25 August 2023 17:09:54 BST David Carlson wrote:
> > Barry,
> >
> > Please do not send messages to individuals on the Gnucash-user list.
> > I have no idea what did not go through in that prior email because it
> > didn't go through.
> > Then your next sentence confuses me too because I cannot tell if it is a
> > comment about the user list, about the GnuCash program. about your Email
> > app or about how permissions for users works in Windows.
> >
> > ---------- Forwarded message ---------
> > From: Barry Mahon <barrymahonb at gmail.com>
> > Date: Fri, Aug 25, 2023 at 10:24?AM
> > Subject: Gnucash
> > To: <david.carlson.417 at gmail.com>
> >
> >
> > Thanks to all.
> >
> > On the issue of rights, I have never had any issues before this saga, so
> > should I assume I have had 'rights' to save documents under administrato??
> >
> > When you say 'truncated' does that mean you cannot see the CaptureWiz
> > images?? I have had issues all along with Gnucash needing specific file
> > types to display files for messages, does that apply to gnucash-user?? For
> > reasons I don't understand I have never been able to copy files from Gnu in
> > my MS Windows10 to the 'required' format, for queries about Gnucash....!!
> > Quite frustrating.
> >
> > Finbar
>
>
>
>
> _______________________________________________
> gnucash-user mailing list
> gnucash-user at gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -----
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
------------------------------
Message: 10
Date: Sat, 26 Aug 2023 02:03:12 -0500
From: Adrien Monteleone <adrien.monteleone at lusfiber.net>
To: gnucash-user at lists.gnucash.org
Subject: Re: [GNC] Fwd: Gnucash
Message-ID: <ucc83h$rij$2 at ciao.gmane.io>
Content-Type: text/plain; charset=UTF-8; format=flowed
Dimes to Dollars the permissions issue was that Barry was accessing the
file as one user (Barry Mahon) but it was saved in the tree of another.
(administrato)
Regards,
Adrien
On 8/25/23 6:30 PM, Maf. King wrote:
> I've just had a thought on a possible reason the original file could not be
> saved. I may be barking up the wrong tree.....
>
> Does Win have a maximum length for a filename?
>
> If Barry (OP) has been repeatedly opening and working on backups and backups
> of backups etc.., is it possible that repeated time-stamps have hit some sort
> of string-length limit (either in Win, GC, Gnome-libs or whatever layer)??
>
> Last time I was actively using MS for anything regularly, the filename length
> limit was 8+3 ... so I'll defer to pretty much anyone's opinion on this!
------------------------------
Subject: Digest Footer
_______________________________________________
gnucash-user mailing list
gnucash-user at gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-----
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.
------------------------------
End of gnucash-user Digest, Vol 245, Issue 58
*********************************************
More information about the gnucash-user
mailing list