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, [email protected]<[email protected]> wrote: Send gnucash-user mailing list submissions to [email protected] 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 [email protected] You can reach the person managing the list at [email protected] 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 <[email protected]> To: "[email protected]" <[email protected]> Subject: [GNC] Fwd: Gnucash Message-ID: <CADYgSbmkEVZWcWtqTU+dL1aY+bE=tme6tq-cdvwmvrv0hru...@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 <[email protected]> Date: Fri, Aug 25, 2023 at 10:24?AM Subject: Gnucash To: <[email protected]> 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 <[email protected]> To: "[email protected]" <[email protected]> Subject: [GNC] Profit and loss report Message-ID: <[email protected]> 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 <[email protected]> To: [email protected] Subject: Re: [GNC] Profit and loss report Message-ID: <[email protected]> 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" <[email protected]> To: Mahon Finbar <[email protected]> Cc: [email protected] Subject: Re: [GNC] Issues with gnucash files Message-ID: <3097604.U3zVgo479M@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" <[email protected]> To: "[email protected]" <[email protected]> Subject: Re: [GNC] Fwd: Gnucash Message-ID: <2803961.XrmoMso0CX@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 <[email protected]> > Date: Fri, Aug 25, 2023 at 10:24?AM > Subject: Gnucash > To: <[email protected]> > > > 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)" <[email protected]> To: [email protected] Subject: Re: [GNC] Fwd: Gnucash Message-ID: <[email protected]> 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)" <[email protected]> To: [email protected] Subject: Re: [GNC] Profit and loss report Message-ID: <[email protected]> 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 <[email protected]> To: [email protected] Subject: Re: [GNC] Fwd: Gnucash Message-ID: <[email protected]> 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 <[email protected]> To: [email protected] Subject: Re: [GNC] Fwd: Gnucash Message-ID: <[email protected]> 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 <[email protected]> > > Date: Fri, Aug 25, 2023 at 10:24?AM > > Subject: Gnucash > > To: <[email protected]> > > > > > > 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 > [email protected] > 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 <[email protected]> To: [email protected] Subject: Re: [GNC] Fwd: Gnucash Message-ID: <[email protected]> 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 [email protected] 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 ********************************************* _______________________________________________ gnucash-user mailing list [email protected] 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.
