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 636672 - Reports>Business>Receivable Aging error
Reports>Business>Receivable Aging error
Status: RESOLVED FIXED
Product: GnuCash
Classification: Other
Component: Business
git-master
Other Mac OS
: Normal normal
: ---
Assigned To: Derek Atkins
Derek Atkins
Depends on:
Blocks:
 
 
Reported: 2010-12-07 05:54 UTC by R Walasek
Modified: 2018-06-29 22:49 UTC
See Also:
GNOME target: ---
GNOME version: ---

Attachments
terminal output upon A/R Aging report failing to open (4.14 KB, text/plain)
2010-12-07 05:54 UTC, R Walasek 		  Details
Fix for this bug against trunk r19909 (1.38 KB, patch)
2010-12-07 19:36 UTC, Matthijs Kooijman 		committed Details | Review

Description R Walasek 2010-12-07 05:54:13 UTC 
Created attachment 175987 [details]
terminal output upon A/R Aging report failing to open

Report will not open; new window opens with "Report Error" "An error occurred while running the report."

Terminal output attached.

Mac 10.6.5 build 2.3.17 svn r19906 on 2010-12-03
Comment 1 Derek Atkins 2010-12-07 12:26:18 UTC 
If you go to line 311 of /Users/russ/local/share/gnucash/guile-modules/gnucash/report/aging.scm and change QOF-QUERY-AND to (QOF-QUERY-AND) does that fix the problem?  (You might need to do it on the next line, too, and then restart GnuCash).

Yes, the change I'm asking you to make it to put parens around the QOF-QUERY-AND symbol.  Could you try that and get back to me?
Comment 2 Matthijs Kooijman 2010-12-07 15:50:50 UTC 
I can reproduce this problem and adding the parenthesis seems to help (only to advance to the next problem with set-sort-order). Looking at src/engine/engine.i I do see:
   SET_ENUM("QOF-QUERY-AND");
so the parenthesis shouldn't be necessary.

Regarding the subsequent set-sort-order problem:

    /usr/local/gnucash/share/gnucash/guile-modules/gnucash/report aging.scm:313:5: In procedure qof-query-set-sort-order in expression (qof-query-set-sort-order query (list SPLIT-TRANS TRANS-DATE-POSTED) ...):
   /usr/local/gnucash/share/gnucash/guile-modules/gnucash/report/aging.scm:313:5: Wrong type argument in position 2: ("trans" "date-posted")

this might be related to r19890 (#635469).

I'm not 100% sure what version I've been using to test this, though, so I'll try a clean svn r19909 recompile now to further debug this.
Comment 3 Matthijs Kooijman 2010-12-07 19:36:38 UTC 
Created attachment 176026 [details] [review]
Fix for this bug against trunk r19909

Ok, I found the cause. Turns out one of my patches (adding qofquery bindings for invoices) broke it. I'm attaching a patch that fixes it (and contains more details about the problem).
Comment 4 John Ralls 2010-12-08 00:34:00 UTC 
Committed in r19913.

Reporter, please test.
Comment 5 John Ralls 2010-12-08 06:03:39 UTC 
Reported fixed.
Comment 6 John Ralls 2018-06-29 22:49:00 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=636672. Please update any external references or bookmarks.