Re: [GNC] Transaction Report Default Account

2020-05-10 Thread Michael or Penny Novack
On 5/10/2020 3:25 AM, flywire wrote: A Transaction Report is grouped by Account. The Default Display selecting Account Name and not Other Account Name seems wrong, the whole group has that account name. The setting is contrary to the equivalent report in other Financial packages. Any concerns

Re: [GNC] Transaction Report Default Account

2020-05-10 Thread Michael or Penny Novack
On 5/10/2020 3:43 AM, flywire wrote: Something must have changed eg: https://www.gnucash.org/docs/v3/C/gnucash-guide/figures/cbook_TransactionRptAssets.png I know I can change the report setting. Can someone point me to the guile file on my computer for that report? I'd like to tweak it.

Re: [GNC] Transaction Report Default Account

2020-05-10 Thread flywire
Something must have changed eg: https://www.gnucash.org/docs/v3/C/gnucash-guide/figures/cbook_TransactionRptAssets.png I know I can change the report setting. Can someone point me to the guile file on my computer for that report? I'd like to tweak it.

[GNC] Transaction Report Default Account

2020-05-10 Thread flywire
A Transaction Report is grouped by Account. The Default Display selecting Account Name and not Other Account Name seems wrong, the whole group has that account name. The setting is contrary to the equivalent report in other Financial packages. Any concerns with me listing it as a bug?

[GNC] Transaction Report Filter ?

2020-03-06 Thread Long
Hello, I want to use Filter to filter My Transactions included with "words" i want. For example : transaction-report-1.png i spent some money for gas in "gas account" 1 for "car" 1 for anythings else So when i

Re: [GNC] Transaction Report: 1)Print only totals 2)Add comment to print out ?

2019-11-02 Thread Adrien Monteleone
CoA: Chart of Accounts It has the simple label ‘Accounts’ and is the default tab in GnuCash if you have none open. (I also don’t think you can close it) Some Find operations only work properly when done if that tab has focus. Some of those cases should probably be filed as bugs, but sometimes

Re: [GNC] Transaction Report: 1)Print only totals 2)Add comment to print out ?

2019-11-02 Thread Fran_3 via gnucash-user
Adrien, What is the CoA tab for all accounts? Where is it? (This is what is so great about gnuCash, it is so rich in features that you can almost learn something new abut it's capabilities every day :-) Fran3 On Friday, November 1, 2019, 10:01:07 PM EDT, Adrien Monteleone wrote:

Re: [GNC] Transaction Report: 1)Print only totals 2)Add comment to print out ?

2019-11-02 Thread Gareth Davies via gnucash-user
: Re: [GNC] Transaction Report: 1)Print only totals 2)Add comment to print out ? Gareth, I'm not sure you can use the Transaction Report to search an account... say the checking account... for a value greater than X. I also don't see a way using the Customer Report. But, you can

Re: [GNC] Transaction Report: 1)Print only totals 2)Add comment to print out ?

2019-11-01 Thread Adrien Monteleone
As Fran notes, the Transaction report has several filters and sorting means, but using an amount cut-off is not one of them. But you can run a Find on a particular register (or from the CoA tab for all accounts) and then use multiple criteria to narrow down your search. (no need to run

Re: [GNC] Transaction Report: 1)Print only totals 2)Add comment to print out ?

2019-11-01 Thread Michael or Penny Novack
On 11/1/2019 9:46 AM, Fran_3 wrote: Michael, no request for added features to GC was intended. I was just exploring the existing capabilities of the program. Understood. But I come to this from a different position. When I took over as treasurer (of the first organization) I asked the

Re: [GNC] Transaction Report: 1)Print only totals 2)Add comment to print out ?

2019-11-01 Thread Fran_3 via gnucash-user
k Sent: 01 November 2019 13:28 To: gnucash-user@gnucash.org Subject: Re: [GNC] Transaction Report: 1)Print only totals 2)Add comment to print out ? On 11/1/2019 8:46 AM, Fran_3 via gnucash-user wrote: > I think I know the answer to this but I wanted to double check. > . > 2 - Is t

Re: [GNC] Transaction Report: 1)Print only totals 2)Add comment to print out ?

2019-11-01 Thread Gareth Davies via gnucash-user
or Penny Novack Sent: 01 November 2019 13:28 To: gnucash-user@gnucash.org Subject: Re: [GNC] Transaction Report: 1)Print only totals 2)Add comment to print out ? On 11/1/2019 8:46 AM, Fran_3 via gnucash-user wrote: > I think I know the answer to this but I wanted to double check. > ...

Re: [GNC] Transaction Report: 1)Print only totals 2)Add comment to print out ?

2019-11-01 Thread Adrien Monteleone
No, *not* the Easy stylesheet. I didn’t suggest it for a reason. You need to use the "Head or Tail" stylesheet. As for renaming a field - not without creating a custom version of a stylesheet or hacking the report itself. > On Nov 1, 2019 w44d305, at 9:01 AM, Fran_3 wrote: > > Adrien, > > I

Re: [GNC] Transaction Report: 1)Print only totals 2)Add comment to print out ?

2019-11-01 Thread Fran_3 via gnucash-user
Adrien, I tried to  check out style sheets and have a couple of questions... 1 - Under Edit > Style Sheets I clicked on Easy > Edit And expected to be able to either add a field or edit the name of a field... like change the name of Prepared By to something like Comments or Notes... But I

Re: [GNC] Transaction Report: 1)Print only totals 2)Add comment to print out ?

2019-11-01 Thread Adrien Monteleone
But the abilities *have* been added via stylesheets. (as noted) Regards, Adrien > On Nov 1, 2019 w44d305, at 8:28 AM, Michael or Penny Novack > wrote: > > On 11/1/2019 8:46 AM, Fran_3 via gnucash-user wrote: >> I think I know the answer to this but I wanted to double check. >> . >> 2

Re: [GNC] Transaction Report: 1)Print only totals 2)Add comment to print out ?

2019-11-01 Thread Fran_3 via gnucash-user
Michael, no request for added features to GC was intended. I was just exploring the existing capabilities of the program. Having been involved in product development I have experienced countless meetings, discussions and passionate exchanges about nailing down product design spec's and later

Re: [GNC] Transaction Report: 1)Print only totals 2)Add comment to print out ?

2019-11-01 Thread Michael or Penny Novack
On 11/1/2019 8:46 AM, Fran_3 via gnucash-user wrote: I think I know the answer to this but I wanted to double check. . 2 - Is there any way to add a comment to the report before you print it... other than making the title long? 3 - Can you include HTML tags like and to have a report's

Re: [GNC] Transaction Report: 1)Print only totals 2)Add comment to print out ?

2019-11-01 Thread Fran_3 via gnucash-user
Thanks Adrien, I'll give that a go. FYI, this HTML for the Transaction Report "Report Name" seem to work but then it creates a long name and clutter when finding and opening a saved report. Transaction Report: HTML Demo2nd line normal text demo Again, I'll be switching to "the right way to do

Re: [GNC] Transaction Report: 1)Print only totals 2)Add comment to print out ?

2019-11-01 Thread Adrien Monteleone
> On Nov 1, 2019 w44d305, at 7:46 AM, Fran_3 via gnucash-user > wrote: > > I think I know the answer to this but I wanted to double check. > 1 - Can I print a Transaction Report and exclude the line items and only show > the total(s) ? Options > Sorting > Show Subtotals Only (hide

[GNC] Transaction Report: 1)Print only totals 2)Add comment to print out ?

2019-11-01 Thread Fran_3 via gnucash-user
I think I know the answer to this but I wanted to double check. 1 - Can I print a Transaction Report and exclude the line items and only show the total(s) ? 2 - Is there any way to add a comment to the report before you print it... other than making the title long? 3 - Can you include HTML tags

Re: [GNC] Transaction Report Sign Reverses

2019-08-13 Thread Adrien Monteleone via gnucash-user
> On Aug 13, 2019, at 12:12 AM, Christopher Lam > wrote: > > Maybe I'm being thick here, but it's still not easy. We need to start with > the knowledge that *internally* income amounts are negative -- after all they > usually balance with positive asset amounts. Also, liability amounts are

Re: [GNC] Transaction Report Sign Reverses

2019-08-12 Thread Christopher Lam
Maybe I'm being thick here, but it's still not easy. We need to start with the knowledge that *internally* income amounts are negative -- after all they usually balance with positive asset amounts. Also, liability amounts are also internally negative, but no one seems to have a problem with that.

Re: [GNC] Transaction Report Sign Reverses

2019-08-12 Thread David T. via gnucash-user
Well, it seems odd to me that "Double" display (as Adrien noted)(thank you, Adrien!) is able to display the figures as the user prefers. It is also odd to me that the report knows to switch the values of the individual transactions, but is unable to remember that fact when it comes to the

Re: [GNC] Transaction Report Sign Reverses

2019-08-11 Thread Adrien Monteleone
David, Try Display > Amount > Double (default is ’Single’) I’m not sure why this works when both debit & credit columns are visible, and not when only the credit column is visible, but it does. I have my Global preference for Sign Reverses set to ‘Credit Accounts’ and I set the report to

Re: [GNC] Transaction Report Sign Reverses

2019-08-11 Thread Christopher Lam
https://wiki.gnucash.org/wiki/FAQ#Q:_Why_does_the_Transaction_Report_.27Sign_Reversal.27_setting_not_work_on_subtotals This issue could be fixed if the scenario addressed in this FAQ can be resolved. I don't really know how to handle that particular case. On Mon., 12 Aug. 2019, 13:02 David T.

[GNC] Transaction Report Sign Reverses

2019-08-11 Thread David T. via gnucash-user
Hello, I am trying to create a YTD Capital Gains report, and am encountering a problem with how the Transaction Report implements the Sign Reverses setting. I recall some time back a discussion about the fact that the Sign Reverses setting reverses signs in these reports in a confusing way.

Re: [GNC] Transaction Report with ver.3.5 not working?

2019-04-16 Thread Denis
Thanks for your comments I will fill a bug report. After testing different approachs, checking preferences, and since all sorting keys are working just fine EXCEPT the month, it's to me obvious that there is a bug. I want to thank everybody for their comments. You were a precious help. Denis

Re: [GNC] Transaction Report with ver.3.5 not working?

2019-04-16 Thread Adrien Monteleone
Also, any time you get an error message in the future, including the text of that error message in your original post will assist anyone helping you with narrowing down the problem faster than the several back and forth exchanges already endured to get to this point. Regards, Adrien > On Apr

Re: [GNC] Transaction Report with ver.3.5 not working?

2019-04-16 Thread Christopher Lam
Ok if there is a error message on a blank page then we want the https://wiki.gnucash.org/wiki/Tracefile and a bug report in https://bugs.gnucash.org/ On Tue, 16 Apr 2019 at 14:35, Denis wrote: > I may have found a problem with my "french" version of Gnucash ? It would > be > a question of date

Re: [GNC] Transaction Report with ver.3.5 not working?

2019-04-16 Thread Adrien Monteleone
Be certain in your preferences under Date/Time that you have the proper locale set. And if you don’t mind, please report it back here. If there is a bug and it is known, someone might see the reference. Regards, Adrien > On Apr 16, 2019, at 9:33 AM, Denis wrote: > > I may have found a

Re: [GNC] Transaction Report with ver.3.5 not working?

2019-04-16 Thread Justin Mathew via gnucash-user
I am not sure I understand. > First, I can produce a complete list of all transactions for what ever dates > I want. How are your producing it? Do you mean opening an account register? - Regards, Justin Mathew mjus...@protonmail.com Sent with ProtonMail Secure Email. ‐‐‐ Original Message

Re: [GNC] Transaction Report with ver.3.5 not working?

2019-04-16 Thread Denis
I may have found a problem with my "french" version of Gnucash ? It would be a question of date format maybe. (Date format: -mm-dd) First, I can produce a complete list of all transactions for what ever dates I want. Next, in the General Tab I can get transaction from 2017 until now. Then

Re: [GNC] Transaction Report with ver.3.5 not working?

2019-04-15 Thread Adrien Monteleone
That would affect the Account Report, no? The Transaction Report, I don’t think, is in any way affected by the register view filter. Regards, Adrien > On Apr 15, 2019, at 5:15 PM, David Carlson > wrote: > > Denis, > > Did you try opening the register of the account you are interested in,

Re: [GNC] Transaction Report with ver.3.5 not working?

2019-04-15 Thread David Carlson
Denis, Did you try opening the register of the account you are interested in, and setting thefilter to the date range you want before you run the report? David Carlson On Mon, Apr 15, 2019, 4:40 PM Denis wrote: > The only thing I can produce is a report of all transactions with no >

Re: [GNC] Transaction Report with ver.3.5 not working?

2019-04-15 Thread Adrien Monteleone
When you first run the report, it is blank, telling you no accounts are selected with a link to “Edit report options” —click that link. (or click the Options button in the toolbar) In the Accounts tab of the options dialog, select the account(s) you want to report on. I presume in this case,

Re: [GNC] Transaction Report with ver.3.5 not working?

2019-04-15 Thread Denis
The only thing I can produce is a report of all transactions with no total/month. It's obvious I just don't know how to create that report... Help please Denis -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html ___

Re: [GNC] Transaction Report with ver.3.5 not working?

2019-04-15 Thread Adrien Monteleone
Can you describe in more detail “the Transaction report is not working for me”? I can successfully run that report on my fuel expenses with monthly totals. Are you getting an error message? Are you not seeing the data you thought you would see? Is it not arranged how you thought it would be

[GNC] Transaction Report with ver.3.5 not working?

2019-04-15 Thread Denis
A few days ago I upgraded from ver.2.6.16 to ver. 3.5 (no problem) I like ver.3.5 but the Transaction report is not working for me. How can I produce a *monthy totals *of car fuel expenses ? With version 2.6.16 it was simple to do. Denis -- Sent from:

Re: [GNC] Transaction Report Preference missing?

2019-01-16 Thread Christopher Lam
It's fine to make recommendations. During the transaction upgrade I remembered some wishlist items and was able to implement them. The limitations for reversing subtotals stem from the fact that subtotal & grouping is not limited to account types, but can also be organised by date and other keys.

Re: [GNC] Transaction Report Preference missing?

2019-01-16 Thread Adrien Monteleone
It seems the Balance sheet honors the setting, but using the ’None’ option in Preferences produces a disconcerting result. With the option set to Credit Accounts, all amounts (normally balanced) are positive. With the option set to None, the Liability and Equity line items are negative, but

Re: [GNC] Transaction Report Preference missing?

2019-01-16 Thread David T. via gnucash-user
Chris,  Thanks for the offer, but readers of these lists over the years can vouch for my utter inability to contribute meaningfully to any code. That's why I've tried to contribute to the documentation (although to be truthful, even that is a stretch). I apologize for suggesting tasks for you

Re: [GNC] Transaction Report Preference missing?

2019-01-16 Thread Christopher Lam
I don't know, sorry. You're very welcome to dive into code and try. https://github.com/Gnucash/gnucash/pull/229 will be a good place to start research. On Thu., 17 Jan. 2019, 10:24 David T. Chris, > > While I understand and respect the goal of backward compatibility, I'll > point out that your

Re: [GNC] Transaction Report Preference missing?

2019-01-16 Thread David T. via gnucash-user
Chris, While I understand and respect the goal of backward compatibility, I'll point out that your changes to this report have already broken backward compatibility, as evidenced by my original example.  Settings which worked previously yield meaningless results now, and I have had to go

Re: [GNC] Transaction Report Preference missing?

2019-01-16 Thread Christopher Lam
Sadly, the gnucash project has a long history of never removing features. The amount sign reversal is still functional for the transactional amounts. Only the subtotals are unaffected. On Thu., 17 Jan. 2019, 09:08 D Then why include the option? It no longer does anything, except imply to > the

Re: [GNC] Transaction Report Preference missing?

2019-01-16 Thread D via gnucash-user
Then why include the option? It no longer does anything, except imply to the user that they have control over something they Nik longer can control. David On January 17, 2019, at 6:27 AM, Christopher Lam wrote: This is by design. Previously a transaction report including *all* accounts for

Re: [GNC] Transaction Report Preference missing?

2019-01-16 Thread Christopher Lam
This is by design. Previously a transaction report including *all* accounts for a specified period would erroneously add the sign-reversed amounts as displayed, which would lead to the grand total being a nonsensical number. Eg income $100 expense $50. Amounts: Bank $100 -$50 Income $100 Expense

Re: [GNC] Transaction Report Preference missing?

2019-01-16 Thread David T. via gnucash-user
Chris, I do note one issue with the new transaction report: it doesn’t seem to utilize the Sign Reverses option—at least, not that I can see. Cheers, David > On Jan 16, 2019, at 7:29 PM, David T. via gnucash-user > wrote: > > Chris, > > Thank you for the lead. > > It turns out that I

Re: [GNC] Transaction Report Preference missing?

2019-01-16 Thread David T. via gnucash-user
Chris, Thank you for the lead. It turns out that I can get almost exactly the same result using the hide transactional data option, when I combine it with "Amount - Single”. The only difference is that the Account name is not presented before the total line. I consider that to be an

Re: [GNC] Transaction Report Preference missing?

2019-01-16 Thread Christopher Lam
There's "Sorting / Show subtotals only (hide transactional data)" You may be right that 'Display / Amount' = none is not completely handled as before. Please file a bug, and screenshot a sample report, anonymised; please enable 'General / Add options summary' to display options used. Also,

[GNC] Transaction Report Preference missing?

2019-01-16 Thread David T. via gnucash-user
Hello, Long time user; MacOS Mojave, GnuCash 3.4. I have a saved report I use around this time of year (I call it “W-2 - David”) that shows me the total amounts assigned to a subset of my expense accounts (i.e., my tax expense accounts). The purpose of this report is to allow me to compare my

[GNC] Transaction Report

2019-01-06 Thread Stephen M. Butler
When doing double columns for the amount (DR/CR), the sub-totals/totals only show the combined total.  Is there an option to show the totals per column?  (similar to what the Reconciliation report shows). --Steve -- Stephen M Butler, PMP, PSM stephen.m.butle...@gmail.com kg...@arrl.net

[GNC] Transaction Report

2019-01-06 Thread Stephen M. Butler
Just filed bug 797018 for the below: O/S: Ubuntu 18.04 GnC: 3.4-18 (git maint branch) Unable to location option on Transaction Report to split amount column into Debit/Credit columns when creating a new Transaction report. If I run a saved version from 3.3, the amount column is split. But still

Re: [GNC] transaction report missing subtotals

2018-08-09 Thread Christopher Lam
Can you attach a screenshot of the problem? Use MSPaint or something to hide any sensitive data. Also switch on "General / Add options summary" to "Always" to show us which options were set. On Wed, 8 Aug 2018, 20:08 lebyarules via gnucash-user < gnucash-user@gnucash.org> wrote: > hi all > >

[GNC] transaction report missing subtotals

2018-08-08 Thread lebyarules via gnucash-user
hi all under the transaction report, i am able to get a view of any accounts i want per month, but doesn't show a per month grand total (its blank). i am only shown a total for all the months combined. i am also shown on the per month transaction report, a separate total per account and no

<    1   2