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 776517 - Trial Balance Report: Total Debits Issue re $0 Commodity Accounts and Price Source Mode Set to "Nearest in Time" or "Most Recent"
Trial Balance Report: Total Debits Issue re $0 Commodity Accounts and Price S...
Status: RESOLVED FIXED
Product: GnuCash
Classification: Other
Component: Reports
2.6.14
Other Windows
: Normal normal
: ---
Assigned To: gnucash-reports-maint
gnucash-reports-maint
Depends on:
Blocks:
 
 
Reported: 2016-12-27 01:23 UTC by CDB-Man
Modified: 2018-06-29 23:52 UTC
See Also:
GNOME target: ---
GNOME version: ---

Attachments
Sample GNUCash file with the issue described (15.36 KB, application/x-gnucash)
2016-12-27 01:23 UTC, CDB-Man 		Details

Description CDB-Man 2016-12-27 01:23:29 UTC 
Created attachment 342485 [details]
Sample GNUCash file with the issue described

See attached file for example.  Salient facts on situation:
- Multiple commodities (stocks in this case)
- 2 accounts (CNR.TO - QT, RY.PRW.TO - QT) have 0 balance on TB report run date
- The other 2 accounts have current stock balances
- Report currency is CAD

Scenario 1
==========
> Run report with commodity price source = "average cost" or "weighted average"

Result: a total debit balance is shown.  Amounts are not correct of course, since fx are based on historical rather than current.

Scenario 2 -- the bug
==========
> Run report with commodity price source = "nearest in time" or "most recent"

Result: a total debit balance is NOT shown.  In a more simplified account structure with less commodities, the issue does not exist.

If the accounts with 0 unit balances are excluded from the TB report, a total debit balance is shown.
Comment 1 John Ralls 2017-03-22 00:59:41 UTC 
This problem has been fixed in our software repository. The fix will go into the next software release. Once that release is available, you may want to check for a software upgrade provided by your Linux distribution.
Comment 2 John Ralls 2018-06-29 23:52:56 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=776517. Please update any external references or bookmarks.