gnucash-user Digest, Vol 168, Issue 27

Sun Mar 12 09:18:13 EDT 2017

Encore et encore !!!!!!!!!!!!!!!!!!!!!!!!!

Le 12/03/2017 à 05:06, gnucash-user-request at gnucash.org a écrit :
> Send gnucash-user mailing list submissions to
> 	gnucash-user at gnucash.org
>
> To subscribe or unsubscribe via the World Wide Web, visit
> 	https://lists.gnucash.org/mailman/listinfo/gnucash-user
> or, via email, send a message with subject or body 'help' to
> 	gnucash-user-request at gnucash.org
>
> You can reach the person managing the list at
> 	gnucash-user-owner at gnucash.org
>
> When replying, please edit your Subject line so it is more specific
> than "Re: Contents of gnucash-user digest..."
>
>
> Today's Topics:
>
>     1. Re: Report Generation (Christopher Lam)
>     2. Re: Report Generation (Edward Doolittle)
>     3. Re: New transaction report - consolidates / creates composite
>        if same description, has find capability and can convert annual
>        data to daily amounts (Cindy Doughty)
>
>
> ----------------------------------------------------------------------
>
> Message: 1
> Date: Sun, 12 Mar 2017 11:17:41 +0800
> From: Christopher Lam <christopher.lck at gmail.com>
> To: Cindy Doughty <dbdoughty at gmail.com>
> Cc: Edward Doolittle <edward.doolittle at gmail.com>, gnucash-user
> 	<gnucash-user at gnucash.org>
> Subject: Re: Report Generation
> Message-ID:
> 	<CAKVAZZLX7g2p56N4KoBi3b2G_UxVruX6Z0-r8P15oje_6ni0BQ at mail.gmail.com>
> Content-Type: text/plain; charset=UTF-8
>
> 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.
>>
>
> ------------------------------
>
> Message: 2
> Date: Sat, 11 Mar 2017 21:18:18 -0600
> From: Edward Doolittle <edward.doolittle at gmail.com>
> To: Cindy Doughty <dbdoughty at gmail.com>
> Cc: gnucash-user <gnucash-user at gnucash.org>
> Subject: Re: Report Generation
> Message-ID:
> 	<CA+E35_5r5OMorbE1yz6hipHQgyCLQoyXZ9nfDbXiatyLPsr7ig at mail.gmail.com>
> Content-Type: text/plain; charset=UTF-8
>
> So, I've done some more testing on this. You're right, the problem is with
> the original transaction.scm report. I imagine no one has noticed the
> problem before because everyone has only used the transaction report with a
> limited set of accounts, all of the same account time (all assets, for
> example). With your new report, there are many more creative ways it can be
> used, which makes the bug more apparent.
>
> You can reproduce the problem reliably in the following manner: create the
> account Expenses:Test-Expenses. Create the account
> Liabilities:Test-Liabilities. Create a transfer from
> Liabilities:Test-Liabilities to Expenses:Test-Expenses of $100, say. Since
> everything balances, the net total of the two accounts should be $0.
>
> Run a transaction report including both accounts Expenses:Test-Expenses and
> Liabilities:Test-Liabilities. If Options -> Display -> Sign Reverses is set
> to None, the Grand Total on the report is $0, as expected. If Options ->
> Display -> Sign Reverses is set to Credit Accounts, the Grand Total on the
> report becomes $200, which is incorrect.
>
> No other setting seems to have an effect on this: not the global
> Preferences -> Account -> Reversed Balanced Accounts setting, not any other
> setting in the old transaction report. It is all about that one setting,
> Sign Reverses in the transaction report.
>
> How to fix this in the transaction report: When Options -> Display -> Sign
> Reverses is set to Credit Accounts, the correct way to calculate a grand
> total is by adding numbers from debit accounts (Assets and Expenses) and
> *subtracting* numbers from credit accounts (Equity, Income, Liabilities).
>
> Using the example I gave above, it is also clear that an analogous fix
> needs to be made when Options -> Display -> Sign Reverses is set to Income
> and Expense.
>
> This problem seems to exist in both the existing, longstanding Transaction
> Report, and your new Transaction by Payee Report.
>
> Since these reports seem to be in flux, I'm not sure whether to submit a
> bug report or not. If you fix your new report and submit it to replace the
> old transaction report, that should take care of the bug.
>
> Edward
>
> On 11 March 2017 at 19: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.
>>>>>