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 795702 - Payments not shown in Customer & Vendor reports using sqlite3
Payments not shown in Customer & Vendor reports using sqlite3
Status: RESOLVED OBSOLETE
Product: GnuCash
Classification: Other
Component: Backend - SQL
3.1
Other Mac OS
: Normal normal
: future
Assigned To: gnucash-core-maint
gnucash-core-maint
Depends on:
Blocks:
 
 
Reported: 2018-04-30 17:24 UTC by Adrien
Modified: 2018-06-30 00:09 UTC
See Also:
GNOME target: ---
GNOME version: ---


Description Adrien 2018-04-30 17:24:28 UTC 
I just tested 3.1.2 using my sqlite3 file. It opens fine and the figures in invoices and bills appear to be correct. However, running a Customer/Vendor report only lists invoices/bills and no payments. The aging summary at the bottom of the report is correct, but the balance due is wrong by the amount for the missing payments.

I marked this as backend-SQL rather than Business or Reports because those reports work correctly using the XML file.

Bringing up the process payment window doesn't show paid bills/invoices as outstanding, and the bill/invoice Find windows show them with the proper 'paid' checkmark. So far, this looks like just a report error tied to the SQL backend.

This was tested on:
MacOS 10.13.4 High Sierra
GnuCash 3.1 Build ID: 3.0-118-gd2ef5fd0f+ (2018-04-28)
Comment 1 Geert Janssens 2018-06-24 19:12:13 UTC 
Hmm, I can't reproduce this on linux with current maint (which will become gnucash 3.2 in a few days). Can you test with that version when it is released and report back ?
If it's still an issue, can you create a minimal book in which you can reproduce this ?
Comment 2 Adrien 2018-06-24 19:40:50 UTC 
I'll test once it is out and report back.
Comment 3 John Ralls 2018-06-30 00:09:20 UTC 
GnuCash bug tracking has moved to a new Bugzilla host. The new URL for this bug is https://bugs.gnucash.org/show_bug.cgi?id=795702. Please continue processing the bug there and please update any external references or bookmarks.