r20480 - gnucash/trunk/src/report/business-reports - Bug #645352: Customer and Vendor Reports should have separate income and expense subtotals per period; error if 'Amount' is not selected

[Christian Stimming]

Author: cstim
Date: 2011-03-25 15:57:20 -0400 (Fri, 25 Mar 2011)
New Revision: 20480
Trac: http://svn.gnucash.org/trac/changeset/20480

Modified:
   gnucash/trunk/src/report/business-reports/owner-report.scm
Log:
Bug #645352: Customer and Vendor Reports should have separate income and expense subtotals per period; error if 'Amount' is not selected

Patch by Chris Curtis:

Add 'Credit' and 'Debit' columns and options; fix error if 'Amount' is not
selected.

For tax purposes it would be helpful if the customer and vendor reports
included the totals for the amounts earned, received, or billed for a given
time period.

The reports currently give a total, which is (if you're lucky) zero because the
credits cancel out the debits.  But for verifying or providing the amounts of a
1099-MISC, for instance, the report should show just the amounts credited or
debited depending on your business' accounting method.


Secondarily, if the 'Amount' column is deselected the report fails with an
error.

The attached patch both corrects this problem and adds the requested features.


The new columns are labeled simply 'Credit' and 'Debit' and do not attempt
context-aware naming ("Paid", "Billed", etc.) for simplicity and applicability
(cash versus accrual accounting).  The columns contain a running total, and the
final totals appear in a line above the Amount (running) total.

If the beginning period splits an invoice/payment pair an opening balance
appears and is accounted for in the Amount total as before, but is not included
in the Credit/Debit totals as it is outside the reporting period.  If the
Amount column is not selected for display then neither is the opening balance,
even if it otherwise would have been.