After an evaluation, GNOME has moved from Bugzilla to GitLab. Learn more about GitLab.
No new issues can be reported in GNOME Bugzilla anymore.
To report an issue in a GNOME project, go to GNOME GitLab.
Do not go to GNOME Gitlab for: Bluefish, Doxygen, GnuCash, GStreamer, java-gnome, LDTP, NetworkManager, Tomboy.
Bug 740955 - "Use Split Action Field For Number" setting breaks journal report.
"Use Split Action Field For Number" setting breaks journal report.
Status: RESOLVED FIXED
Product: GnuCash
Classification: Other
Component: Reports
2.6.3
Other Windows
: Normal normal
: ---
Assigned To: gnucash-reports-maint
gnucash-reports-maint
Depends on:
Blocks:
 
 
Reported: 2014-12-01 08:27 UTC by dave
Modified: 2018-06-29 23:36 UTC
See Also:
GNOME target: ---
GNOME version: ---


Attachments
trace file when the error occurred (3.82 KB, text/plain)
2014-12-01 08:27 UTC, dave
Details
Crash of generating General Journal report (5.69 KB, text/plain)
2015-04-03 08:09 UTC, tdenev
Details
Corrected General Journal Report (4.84 KB, text/x-scheme)
2015-04-08 18:46 UTC, Alex Aycinena
Details
Corrected General Ledger Report (5.66 KB, text/x-scheme)
2015-04-08 18:47 UTC, Alex Aycinena
Details

Description dave 2014-12-01 08:27:00 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
Comment 1 Geert Janssens 2015-02-11 16:29:25 UTC
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 ?
Comment 2 dave 2015-02-12 21:11:40 UTC
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
Comment 3 tdenev 2015-04-03 08:07:55 UTC
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
Comment 4 tdenev 2015-04-03 08:09:09 UTC
Created attachment 300869 [details]
Crash of generating General Journal report
Comment 5 Geert Janssens 2015-04-03 09:04:37 UTC
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".
Comment 6 tdenev 2015-04-03 09:21:32 UTC
I can confirm - After uncheck "Use Split Action Field For Number" report is generated.
Comment 7 Alex Aycinena 2015-04-08 18:43:57 UTC
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.
Comment 8 Alex Aycinena 2015-04-08 18:46:13 UTC
Created attachment 301157 [details]
Corrected General Journal Report
Comment 9 Alex Aycinena 2015-04-08 18:47:01 UTC
Created attachment 301158 [details]
Corrected General Ledger Report
Comment 10 dave 2015-04-08 21:41:02 UTC
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 :)
Comment 11 tdenev 2015-04-09 05:52:04 UTC
It's working for me too.

Thank you for your job.
Comment 12 John Ralls 2018-06-29 23:36:29 UTC
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.