Report Generation

[Christopher Lam]

I agree it's an oddity. I can run the original Transaction Report, and
select both Income and Expense accounts. The running total will add all of:
+ve numbers for incomes received
+ve numbers for monies spent (less refunds)
Which means the total amount at the bottom of the report gives the
meaningless value of Incomes+Expenses. I'd thought it should show
Incomes-Expenses as total.
Conclusion - although internally expenses are recorded with a positive
sign, and incomes with a negative sign, somewhere along the standard
Transaction Report the income sign is reversed.

On 12 March 2017 at 09:50, Cindy Doughty <dbdoughty at gmail.com> wrote:

> I'll have to think on it awhile - the fact it happens when consolidate
> transactions is unchecked makes me think it is in the code in the original
> transaction.scm file included with gnucash I started  with.   If you turn
> on running balance and uncheck the entry use old running balance (both at
> bottom of display tab under options)  does it give any clues?
>
> On Sat, Mar 11, 2017 at 12:23 PM, Edward Doolittle <
> edward.doolittle at gmail.com> wrote:
>
> > Yes, I just tested it.
> >
> > On 11 March 2017 at 11:20, Cindy Doughty <dbdoughty at gmail.com> wrote:
> >
> >> Does the interaction happen both when consolidate transactions is
> checked
> >> and when it is unchecked?  (under options display)
> >>
> >> Doug
> >>
> >> On Fri, Mar 10, 2017 at 11:05 PM, Edward Doolittle <
> >> edward.doolittle at gmail.com> wrote:
> >>
> >>> Hi Doug,
> >>>
> >>> I tried your Transaction by Payee Report today, and it works great. It
> >>> allows me to save searches, in particular the search for estimated
> >>> (scheduled) transactions which have managed to move above the blue line
> >>> into the past. Thank you for this work!
> >>>
> >>> I have noticed an oddity, however. I search all accounts, so total of
> >>> the transactions that I find should balance to zero. I noticed that
> >>> sometimes they don't. When I change the report option to Sign Reverses:
> >>> None, then everything does balance to zero like I expect.
> >>>
> >>> The issue is that my overall preference in the application is to set
> >>> "Reverse Balanced accounts" to "Credit accounts". I am puzzled by the
> >>> interaction between the overall preference setting and the setting in
> your
> >>> report.
> >>>
> >>> Edward
> >>>
> >>> On 8 March 2017 at 11:14, dadinva <dbdoughty at gmail.com> wrote:
> >>>
> >>>> Try using the find options in the transactions by payee report I
> >>>> uploaded
> >>>> today.
> >>>>
> >>>>
> >>>>
> >>>> --
> >>>> View this message in context: http://gnucash.1415818.n4.nabb
> >>>> le.com/Report-Generation-tp4688540p4690240.html
> >>>> Sent from the GnuCash - User mailing list archive at Nabble.com.
> >>>> _______________________________________________
> >>>> gnucash-user mailing list
> >>>> gnucash-user at gnucash.org
> >>>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> >>>> -----
> >>>> Please remember to CC this list on all your replies.
> >>>> You can do this by using Reply-To-List or Reply-All.
> >>>>
> >>>
> >>>
> >>>
> >>> --
> >>> Edward Doolittle
> >>> Associate Professor of Mathematics
> >>> First Nations University of Canada
> >>> 1 First Nations Way, Regina SK S4S 7K2
> >>>
> >>> « Toutes les fois que je donne une place vacante, je fais cent
> >>> mécontents et un ingrat. »
> >>> -- Louis XIV, dans Voltaire, Le Siècle de Louis XIV, Chap. XXVI
> >>>
> >>
> >>
> >
> >
> > --
> > Edward Doolittle
> > Associate Professor of Mathematics
> > First Nations University of Canada
> > 1 First Nations Way, Regina SK S4S 7K2
> >
> > « Toutes les fois que je donne une place vacante, je fais cent mécontents
> > et un ingrat. »
> > -- Louis XIV, dans Voltaire, Le Siècle de Louis XIV, Chap. XXVI
> >
> _______________________________________________
> gnucash-user mailing list
> gnucash-user at gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -----
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>