gnucash-user Digest, Vol 168, Issue 28
Jean Pierre & Martine Joubert
joubert.jeanpierre at orange.fr
Sun Mar 12 09:16:51 EDT 2017
Si ça t'amuse, pas moi
rendez-vous chez mon avocat
Bises
Martine
Le 12/03/2017 à 12: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 (Cindy Doughty)
> 2. Re: Report Generation (Cindy Doughty)
> 3. Re: Report Generation (Cindy Doughty)
> 4. Re: Owner's Draw setup under Equity group (Adrien Monteleone)
> 5. Re: Report Generation (Edward Doolittle)
> 6. Re: New transaction report - consolidates / creates composite
> if same description, has find capability and can convert annual
> data to daily amounts (Pedro Albuquerque)
> 7. Re: Report Generation (David T.)
>
>
> ----------------------------------------------------------------------
>
> Message: 1
> Date: Sat, 11 Mar 2017 23:36:21 -0500
> From: Cindy Doughty <dbdoughty at gmail.com>
> To: Edward Doolittle <edward.doolittle at gmail.com>
> Cc: gnucash-user <gnucash-user at gnucash.org>
> Subject: Re: Report Generation
> Message-ID:
> <CAB3Z30wqxbhZHnMshP1LnEbMynya3gJaNgpMZLbN1mJumf-iAA at mail.gmail.com>
> Content-Type: text/plain; charset=UTF-8
>
> I am wondering if an additional choice should be added to reverse all,
> would this solve the problem?
>
> On Sat, Mar 11, 2017 at 10:18 PM, Edward Doolittle <
> edward.doolittle at gmail.com> wrote:
>
>> 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.
>>>>>>
>> --
>> 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
>>
>
> ------------------------------
>
> Message: 2
> Date: Sat, 11 Mar 2017 23:45:13 -0500
> From: Cindy Doughty <dbdoughty at gmail.com>
> To: Edward Doolittle <edward.doolittle at gmail.com>
> Cc: gnucash-user <gnucash-user at gnucash.org>
> Subject: Re: Report Generation
> Message-ID:
> <CAB3Z30wogDDw8MbZYQEsAp6GBbN4NHZEub_+sziuWahfB=hQVw at mail.gmail.com>
> Content-Type: text/plain; charset=UTF-8
>
> the actual line of code says
>
>> (if (member account-type account-types-to-reverse)
>> (gnc-numeric-neg damount)
>>
>>> damount))
>>>
> which means when the entry is set to credit accounts they are checking if
> the account is a credit account and if so switching the value from positive
> to negative
>
> On Sat, Mar 11, 2017 at 11:36 PM, Cindy Doughty <dbdoughty at gmail.com> wrote:
>
>> I am wondering if an additional choice should be added to reverse all,
>> would this solve the problem?
>>
>> On Sat, Mar 11, 2017 at 10:18 PM, Edward Doolittle <
>> edward.doolittle at gmail.com> wrote:
>>
>>> 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.
>>>>>>>
>>> --
>>> 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
>>>
>>
>
> ------------------------------
>
> Message: 3
> Date: Sat, 11 Mar 2017 23:59:14 -0500
> From: Cindy Doughty <dbdoughty at gmail.com>
> To: Edward Doolittle <edward.doolittle at gmail.com>
> Cc: gnucash-user <gnucash-user at gnucash.org>
> Subject: Re: Report Generation
> Message-ID:
> <CAB3Z30wHyUJceG9ipQph8LweWyRn5cuvom0eP7Q-Jfv+tWQF_Q at mail.gmail.com>
> Content-Type: text/plain; charset=UTF-8
>
> the accounts to be reversed seem to match with the definition you see when
> hovering the mouse over the global preferences accounts reverse balanced
> accounts. The code is:
>
>> (define account-types-to-reverse-assoc-list
>> (list (cons 'none '())
>> (cons 'income-expense
>> (list ACCT-TYPE-INCOME ACCT-TYPE-EXPENSE))
>> (cons 'credit-accounts
>> (list ACCT-TYPE-LIABILITY ACCT-TYPE-PAYABLE ACCT-TYPE-EQUITY
>>
>>> ACCT-TYPE-CREDIT ACCT-TYPE-INCOME))))
>>>
> On Sat, Mar 11, 2017 at 11:45 PM, Cindy Doughty <dbdoughty at gmail.com> wrote:
>
>> the actual line of code says
>>
>>> (if (member account-type account-types-to-reverse)
>>> (gnc-numeric-neg damount)
>>>
>>>> damount))
>>>>
>> which means when the entry is set to credit accounts they are checking if
>> the account is a credit account and if so switching the value from positive
>> to negative
>>
>> On Sat, Mar 11, 2017 at 11:36 PM, Cindy Doughty <dbdoughty at gmail.com>
>> wrote:
>>
>>> I am wondering if an additional choice should be added to reverse all,
>>> would this solve the problem?
>>>
>>> On Sat, Mar 11, 2017 at 10:18 PM, Edward Doolittle <
>>> edward.doolittle at gmail.com> wrote:
>>>
>>>> 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.
>>>>>>>>
>>>> --
>>>> 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
>>>>
>>>
>
> ------------------------------
>
> Message: 4
> Date: Sat, 11 Mar 2017 23:08:15 -0600
> From: Adrien Monteleone <adrien.monteleone at gmail.com>
> To: gnucash-user at gnucash.org
> Subject: Re: Owner's Draw setup under Equity group
> Message-ID: <9C730811-2FD9-47B4-A028-2C25F755EC53 at gmail.com>
> Content-Type: text/plain; charset=utf-8
>
> Brian,
>
> Indeed Owner?s Draw is generally a temporary account, when dealing with paper. Temporary accounts are a ?feature? of paper books that derives from the need to ?close the books? due to the limitations of amount of paper in bound volumes and manual filing systems. Some people confound book closing with accounting controls, but this is generally not the usual case. With the advent of computerized accounting software, you have the option to close or not close ?the books? each accounting period. (annually, quarterly, monthly, etc.)
>
> If you do not close, each account remains a running total, however any individual report you run is for a specified time period and so has the flexibility to reflect only the data you want. (for a year, quarter, month, etc.)
>
> There are other threads and topics on the advantages and disadvantages to closing the books vs. not doing so, the primary disadvantage being that you end up with separate files for each closing, which means you can?t run historical reports easily, and can?t run reports for combined periods without export to a spreadsheet or other software.
>
> Can you provide example transactions or balances which illustrate why you don?t think things are working as intended?
>
> -Adrien
>
>
>> On Mar 11, 2017, at 8:54 PM, gnucash-user-request at gnucash.org wrote:
>>
>> From: Brian Hagen <bdhagen at fastmail.com <mailto:bdhagen at fastmail.com>>
>> Subject: Owner's Draw setup under Equity group
>> Date: March 11, 2017 at 2:25:22 PM CST
>> To: GNUCASH <gnucash-user at gnucash.org <mailto:gnucash-user at gnucash.org>>
>>
>>
>> Hello, all:
>>
>> I am using GNUCASH 2.6.14 under Linux Mint. I want
>> to add an account to the parent group "Equity".
>> I want to call it "Owner's Draw", but if need be I
>> will name it something else. What I want is a way to
>> register the funds withdrawn from Cash for personal
>> use, and have the transaction debit correctly from both
>> Cash and Equity accordingly. From what I have read for
>> standard accounting practices, this is the way professional
>> bookkeepers do these changes.
>>
>> According to what I have read, this should be a "temporary
>> account" in the sense that is to be closed out completely
>> at the end of a fiscal term, usually one year.
>>
>> So far, I have created an account as I just
>> described. However, I am not certain that it
>> is working as intended.
>>
>> Any suggestions are certainly welcome.
>>
>> Brian
>
>
> ------------------------------
>
> Message: 5
> Date: Sat, 11 Mar 2017 23:11:09 -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_5_05uByVpH2O-nBX3WNDDkTSFYZRXaTwmHT04eyU1tWA at mail.gmail.com>
> Content-Type: text/plain; charset=UTF-8
>
> Yes, that all seems to be right as far as I can tell. The error is in the
> code that accumulates amounts for totals. For sign reversed accounts (e.g.,
> credit accounts, if that is the setting), the amount of any transaction
> should be negated before adding it to the running total.
>
> On 11 March 2017 at 22:59, Cindy Doughty <dbdoughty at gmail.com> wrote:
>
>> the accounts to be reversed seem to match with the definition you see when
>> hovering the mouse over the global preferences accounts reverse balanced
>> accounts. The code is:
>>
>>> (define account-types-to-reverse-assoc-list
>>> (list (cons 'none '())
>>> (cons 'income-expense
>>> (list ACCT-TYPE-INCOME ACCT-TYPE-EXPENSE))
>>> (cons 'credit-accounts
>>> (list ACCT-TYPE-LIABILITY ACCT-TYPE-PAYABLE ACCT-TYPE-EQUITY
>>>
>>>> ACCT-TYPE-CREDIT ACCT-TYPE-INCOME))))
>>>>
>> On Sat, Mar 11, 2017 at 11:45 PM, Cindy Doughty <dbdoughty at gmail.com>
>> wrote:
>>
>>> the actual line of code says
>>>
>>>> (if (member account-type account-types-to-reverse)
>>>> (gnc-numeric-neg damount)
>>>>
>>>>> damount))
>>>>>
>>> which means when the entry is set to credit accounts they are checking
>>> if the account is a credit account and if so switching the value from
>>> positive to negative
>>>
>>> On Sat, Mar 11, 2017 at 11:36 PM, Cindy Doughty <dbdoughty at gmail.com>
>>> wrote:
>>>
>>>> I am wondering if an additional choice should be added to reverse all,
>>>> would this solve the problem?
>>>>
>>>> On Sat, Mar 11, 2017 at 10:18 PM, Edward Doolittle <
>>>> edward.doolittle at gmail.com> wrote:
>>>>
>>>>> 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.
>>>>>>>>>
>>>>> --
>>>>> 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
>>>>>
>>>>
>
More information about the gnucash-user
mailing list