GNOME Bugzilla – Bug 740955
"Use Split Action Field For Number" setting breaks journal report.
Last modified: 2018-06-29 23:36:29 UTC
Created attachment 291868 [details] trace file when the error occurred When i go to reports -> assets and liabilities and choose either general ledger or general journal it gives me an error message that says 'error occurred while running the report' Almost exactly the same issue is this bug report https://bugzilla.gnome.org/show_bug.cgi?id=732938 except that i am on windows 7 and i believe that report was for linux. But its the same issue. It sounds to me like the same issue concerning the stack overflow error in guile 2 My trace file is attached. This is what i tried so far to fix this: I am running 2.6.3, first i did try to download 2.6.4 but every mirror still shows 2.6.3 so i tried to do this via github just replacing the ledger and journal and report scm files but then the software would not load and it crashed so i put the original files back. can i update my scm files from github without the software crashing on me, what is the best way to proceed since i cant seem to get 2.6.4 access via normal download. Please advise thanks dave
Thank you for your report. I have opened gnucash 2.6.5 on Windows XP and ran both the General Ledger and the General Journal report. Neither gives me the error you get. Can you first try this version and report back if that still produces the error on your system ?
ok i just updated to 2.6.5 and it gives me same error. I also tried the compatibility at xp sp3 and run as admin, neither helped, it still will not run the ledger or the journal but all the other reports are fine. any ideas... thanks
I have this problem too. You can find my logs attached. I have tested this report on other data with Stock account (mine is without Stock account) and there it generates without errors. OS Slackware 14.1 GnuCash 2.6.6
Created attachment 300869 [details] Crash of generating General Journal report
Thank you for the additional information. I tried again but still couldn't reproduce it. It did make me dig a bit deeper though. And if I set the book option "Use Split Action Field For Number" it did result in the same trace file as both of you have added. It appears this setting somehow changes the way the "Num" option is interpreted and the General Journal report has issues with this. Unfortunately this is not my area, so I don't know how to fix it. I'll change the bug's title to reflect the cause and cc the author of the "Use Split Action Field For Number".
I can confirm - After uncheck "Use Split Action Field For Number" report is generated.
Thank you for reporting these problems. I have duplicated both of these report problems and have, I believe, fixed them. I attach revised versions of both reports, general-journal.scm and general-ledger.scm. I ask that you confirm that they fix the problems you saw. When you confirm the fix, I will close the bug. I have already committed the fixes. To test, first shut down gnucash. Then go to the directory/folder where your gnucash is installed, for example: Windows: C:\Program Files (x86)\gnucash\share\gnucash\scm\gnucash\report\standard-reports Linux: /usr/share/gnucash/scm/gnucash/report/standard-reports/ Rename the current versions of the reports as follows: general-journal.scm -> general-journal.scm.orig general-ledger.scm -> general-ledger.scm.orig You will need to have administrative priveleges in order to do this (in other words, open your file browser with admin priveleges; also, for windows explorer, it will help if you configure explorer to see file extensions). Then copy the new versions into this same directory/folder. Restart gnucash and it will use the new versions of the reports. When your data file is open, set File-Properties to "Use Split Action Field for Number", then run the reports. If you find this works, just leave the new versions where they are. If you are using a version that is earlier than the just released version 2.6.6, upgrading to that release will overwrite the files you just copied and the bug will reappear. Just repeat this process. The corrected versions will be in the next release.
Created attachment 301157 [details] Corrected General Journal Report
Created attachment 301158 [details] Corrected General Ledger Report
you are AWESOME!!!! Alex it works fantastic thanks sooooo much.. I cant tell you how much i appreciate what you have done here. I thought it might be years before this was finally fixed and you did a wonderful job. My accountant will be so happy now that i can share with him a GJ and GL. High five :) FYI my files were located in gnucash/share/gnucash/scm/gnucash/report/standard-reports hope this helps someone. Thanks again, great job :)
It's working for me too. Thank you for your job.
GnuCash bug tracking has moved to a new Bugzilla host. This bug has been copied to https://bugs.gnucash.org/show_bug.cgi?id=740955. Please update any external references or bookmarks.