Re: [GNC] transaction report I think

2024-12-17 Thread Robert Bower
Michael, Thanks for your help on understanding on how things work.  I think I understand now.  Also thanks for the work around. On 12/16/24 17:59, Michael or Penny Novack via gnucash-user wrote: What I would like the report to show is on deposits rather than accounts receivable show I would

Re: [GNC] transaction report I think

2024-12-16 Thread Michael or Penny Novack via gnucash-user
What I would like the report to show is on deposits rather than accounts receivable show I would like the Dues account to show or the appropriate income transfer account. Ah, you have run into the difficulty of using stuff intended for "accrual basis accounting", but like many orgs you want

Re: [GNC] Transaction Report: Table for Exporting

2024-10-27 Thread Fred Tydeman
I ran two reports with the only difference being Table for Exporting. What is on the screen is the "same", the only difference being some columns are a little different. The Exported html is the same except for 4 lines. On Sat, Oct 26, 2024 at 10:17 PM David H wrote: > Fred, > > No real idea on

Re: [GNC] Transaction Report: Table for Exporting

2024-10-27 Thread Fred Tydeman
You are correct. What is on the screen is the table. And it can be cut and pasted into a spreadsheet. I agree it is not well documented. One area where the documentation is "wrong" is "Primary Subtotal". For my report, the Primary Key is the Number field. I have checked the Primary Subtotal checkb

Re: [GNC] Transaction Report: Table for Exporting

2024-10-26 Thread David H
Fred, No real idea on this, but I think it only affects the report out display format so that when you click the export button after running the report to export the results it's more suited to displaying in a web browser or pasting into spreadsheet. Run your report with it unchecked and run the

Re: [GNC] Transaction Report: Table for Exporting

2024-10-26 Thread Jim DeLaHunt
Fred:… Pa Sometimes things are hidden in plain sight. On 2024-10-26 09:39, Fred Tydeman wrote: I am running Gnucash 5.9 on Fedora Linux 40 I have done a Transaction Report In the General Options I have checked Table for Exporting I do not see any table in either the report (at the bottom)

Re: [GNC] Transaction Report Shortcomings

2024-05-04 Thread Christopher Lam
istopher Lam > *Sent:* Thursday, May 2, 2024 1:09 AM > *To:* Paul Kroitor > *Cc:* Gnucash Users > *Subject:* Re: [GNC] Transaction Report Shortcomings > > > > Hi, > > See Sorting/Show Account Description. This is a bug which will be fixed > tomorrow. > > https

Re: [GNC] Transaction Report Shortcomings

2024-05-04 Thread Paul Kroitor
nightly builds, right? Is that right? Sorry for double-checking, I just want to be sure I understand, Paul From: Christopher Lam Sent: Thursday, May 2, 2024 1:09 AM To: Paul Kroitor Cc: Gnucash Users Subject: Re: [GNC] Transaction Report Shortcomings Hi, See Sorting/Show Account

Re: [GNC] Transaction Report Shortcomings

2024-05-01 Thread Christopher Lam
Hi, See Sorting/Show Account Description. This is a bug which will be fixed tomorrow. https://code.gnucash.org/builds/win32/stable/ HTH On Wed, 1 May 2024 at 22:07, Paul Kroitor wrote: > Is there a way to get the Transaction Report to show Account Description > rather than Account Name in the gr

Re: [GNC] Transaction Report Shortcomings

2024-05-01 Thread Paul Kroitor
Somehow I didn't notice that Show Full Account Name option does something in that direction: the group header now shows "Expenses:Rental Properties:House-1:Prop Tax" which does at least disambiguate but is still pretty clunky. My Account Description fields do already contain exactly the perfect des

Re: [GNC] Transaction Report - Split Transactions

2024-01-10 Thread John Dimitriadis
Hello Vincent, Happy New Year. Hope my email finds you well. Just wanted to touch base to see if you managed to take any action on the below? Many thanks in advance. > On 19 May 2023, at 08:16, John Dimitriadis wrote: > > Hello Vincent, > > Thank you very much for the detailed and quick re

Re: [GNC] Transaction Report Options menu bug report

2023-12-01 Thread Stephen M. Butler
Was there in 5.4-62 but fixed by 5.4-117.  I did a git pull and then a local build. Guess I should have tried that first. On 12/1/23 13:31, Glenn Fowler wrote: Hi, This has been fixed since the 5.4 release if you want to try a daily build: https://code.gnucash.org/builds/flatpak/stable/ On

Re: [GNC] Transaction Report Options menu bug report

2023-12-01 Thread Stephen M. Butler
I will update the bug report as I did a git pull for 5.4-117, did the build and all works as expected. I'm going to presume fixed between patch 62 and 117. On 12/1/23 13:34, Adrien Monteleone wrote: Might be something in a dependency in 23.10. I can report it also works fine on MacOS. Regards

Re: [GNC] Transaction Report Options menu bug report

2023-12-01 Thread Glenn Fowler
Hi, This has been fixed since the 5.4 release if you want to try a daily build: https://code.gnucash.org/builds/flatpak/stable/ On Fri, Dec 1, 2023 at 3:27 PM Stephen M. Butler wrote: > 799149 filed. After > initial set of options for Transacti

Re: [GNC] Transaction Report Options menu bug report

2023-12-01 Thread Adrien Monteleone
Might be something in a dependency in 23.10. I can report it also works fine on MacOS. Regards, Adrien On 12/1/23 2:52 PM, Murugan Muruganandam wrote: i am able to print and make pdf Gnucash 5.4 Build Flathub 5.4.1 Ubuntu 22.04.3 ___ gnucash-user

Re: [GNC] Transaction Report Options menu bug report

2023-12-01 Thread Murugan Muruganandam
i am able to print and make pdf Gnucash 5.4 Build Flathub 5.4.1 Ubuntu 22.04.3 Saludos Cordiales Murugan From: gnucash-user on behalf of Stephen M. Butler Sent: Friday, December 1, 2023 5:27 PM To: GnuCash Users Subject: [GNC] Transaction Report Options

Re: [GNC] Transaction Report - Split Transactions

2023-07-12 Thread Vincent Dawans
For those interested by this feature providing a more permissive match in the transaction report to reduce the number of "split transaction", I have implemented this feature in my custom "Transaction Report Extended" here https://github.com/dawansv/gnucash-custom-reports The option to enable the m

Re: [GNC] Transaction Report - Split Transactions

2023-05-19 Thread Vincent Dawans
I have submitted a draft PR with changes that would address your use case (as well as mine -- I have a set of books for a small nonprofit that I like to export in a Google Sheet ledger for simple reporting to the board -- but it shows a lot of sad looking "Split Transaction" as well). As you say it

Re: [GNC] Transaction Report - Split Transactions

2023-05-19 Thread John Dimitriadis
Hello Vincent, Thank you very much for the detailed and quick response! Splitting the transaction into two separate ones is something I thought of as well, however I concluded that I rather not have perfect reports but have my transactions properly organised. The tags report is something I c

Re: [GNC] Transaction Report - Split Transactions

2023-05-19 Thread Adrien Monteleone
As Vincent noted, you probably can't get there in one report, but consider experimenting with the multi-column report where you can have multiple transaction reports in one screen. Another alternative would be to run the report for each owner, and copy/paste or export to a spreadsheet for furt

Re: [GNC] Transaction Report - Split Transactions

2023-05-17 Thread Michael or Penny Novack
Look, we can tell you how to use gnucash to do double-entry bookkeeping. But it is beyond our remit to tell you how to set up books for this or that type of entity. For example, I lack the "qualifications" to advise you the way a CPA could. But I do know something about it, so I will give you

Re: [GNC] Transaction Report - Split Transactions

2023-05-17 Thread Vincent Dawans
The last one should show this for proper credit/debi sides Checking account 100 Electricity 60 #OwnerA in the split memo Electricity 40 #OwnerB in the split memo On Wed, May 17

Re: [GNC] Transaction Report - Split Transactions

2023-05-17 Thread Vincent Dawans
Unfortunately that is a limitation on how the splits work and I have run into this myself. When you look at it from the expense accounts, every transaction has a 3 way split because of the 2 owner accounts, so unfortunately there is no way to group by owner account as the secondary sort When you l

Re: [GNC] Transaction Report Advance Portfolio - Options - Account List

2023-05-07 Thread john
> On May 7, 2023, at 1:17 AM, Martin Booth via gnucash-user > wrote: > > > I am running GNUCash - 5.1 flatpak on debian 11.I have been using GC for > 15years now and the Advance Portfolio report does not list all the COA or > highlight the selected accounts the report is based on unlike ea

Re: [GNC] Transaction Report Advance Portfolio - Options - Account List

2023-05-07 Thread Murugan Muruganandam
martin The accounts selection windows is scrollable, it is not visible but you can scroll to see all the accounts. to check, you can click on select all button , which will display the full COA Saludos Cordiales Murugan From: gnucash-user on behalf of M

Re: [GNC] Transaction Report not working

2023-04-10 Thread Chris Ledbetter via gnucash-user
Thank you, I will try upgrading. > On Apr 10, 2023, at 4:08 PM, Tommy Trussell wrote: > > Hi! Please remember to copy the GnuCash List on all replies. Thanks for your > version information. > > Since you're using an older version, you might try a more recent version. > Version 5.0 is availabl

Re: [GNC] Transaction Report not working

2023-04-10 Thread Tommy Trussell
Hi! Please remember to copy the GnuCash List on all replies. Thanks for your version information. Since you're using an older version, you might try a more recent version. Version 5.0 is available, as well as the last of the 4.x versions, 4.14. If you want to be completely cautious you might try u

Re: [GNC] Transaction Report not working

2023-04-10 Thread Tommy Trussell
On Mon, Apr 10, 2023 at 11:13 AM Chris Ledbetter via gnucash-user < gnucash-user@gnucash.org> wrote: > Hi - New to gnucash and am inputting all accounts. Trying to run a > Transaction report but after hitting options, I am not able to choose any > options. It opens to the General Tab of options b

Re: [GNC] Transaction Report Overlaps Page Breaks

2023-03-10 Thread Adrien Monteleone
I usually have to Export, then open with a web browser and either Print to PDF or to a printer from there. Regards, Adrien On 3/10/23 12:37 PM, p...@kroitor.ca wrote: Hi all. Not for the first time I've run across an issue in which printing the Transaction Report (at least - there may be other

Re: [GNC] Transaction Report Overlaps Page Breaks

2023-03-10 Thread Vincent Dawans
7;t remember going through this kind of rigamarole > for several decades (at least, not for pagination issues). > > > > Thanks nonetheless, > > Paul > > > > From: Murugan Muruganandam > Sent: Friday, March 10, 2023 2:32 PM > To: p...@kroitor.ca; gnucash-us

Re: [GNC] Transaction Report Overlaps Page Breaks

2023-03-10 Thread paul
or several decades (at least, not for pagination issues). Thanks nonetheless, Paul From: Murugan Muruganandam Sent: Friday, March 10, 2023 2:32 PM To: p...@kroitor.ca; gnucash-user@gnucash.org Subject: Re: [GNC] Transaction Report Overlaps Page Breaks paul In File Page Setup reduce

Re: [GNC] Transaction Report Overlaps Page Breaks

2023-03-10 Thread Murugan Muruganandam
paul In File Page Setup reduce the Bottom Margin to 7 and try it out Saludos Cordiales Murugan From: gnucash-user on behalf of p...@kroitor.ca Sent: Friday, March 10, 2023 3:37 PM To: gnucash-user@gnucash.org Subject: [GNC] Transaction Report Overlaps P

Re: [GNC] Transaction Report << offline >>

2022-12-09 Thread Michael or Penny Novack
I solved my problem. I may not be using GNUCash the correct way but it works for my needs. ... All my deposits would go to income account and all my withdrawals would come out of my expense account. Since the expense account started with a zero balance it would always have a nega

Re: [GNC] Transaction Report << offline >>

2022-12-09 Thread rovero
transactions and all the income transactions, and then to show the Grand Total as Income minus Expense ( i.e balance) Thanks Everyone For the help provided Joe -Original Message- From: Michael or Penny Novack Sent: Friday, December 9, 2022 10:31 AM To: rov...@comcast.net Subject: Re: [GNC

Re: [GNC] Transaction Report

2022-12-09 Thread Derek Atkins
n ver 4.1.2 vs dollars > being negative in 2.6.6 > > Thanks > Joe > > -Original Message- > From: Derek Atkins > Sent: Thursday, December 8, 2022 4:56 PM > To: rov...@comcast.net > Cc: gnucash-user@gnucash.org > Subject: Re: [GNC] Transaction Rep

Re: [GNC] Transaction Report

2022-12-08 Thread rovero
.6 Thanks Joe -Original Message- From: Derek Atkins Sent: Thursday, December 8, 2022 4:56 PM To: rov...@comcast.net Cc: gnucash-user@gnucash.org Subject: Re: [GNC] Transaction Report HI, On Thu, December 8, 2022 7:32 pm, rov...@comcast.net wrote: > Hope this explains it better >

Re: [GNC] Transaction Report

2022-12-08 Thread Derek Atkins
HI, On Thu, December 8, 2022 7:32 pm, rov...@comcast.net wrote: > Hope this explains it better > > > > > > There are two accounts in the transaction report > > > > Expense Type A/Payable An A/Payable account is not an expense. It is a liability. > > IncomeType Bank Similarly, a Bank acc

Re: [GNC] Transaction Report

2022-12-08 Thread Michael or Penny Novack
I am not sure what you are asking or what your expectations might be. This is a "transaction report" against what account?  What is the "type" of that account? What is the normal state of the balance of that account in terms of the formal terms :debit" and "credit" -- in other words, if you we

Re: [GNC] Transaction Report

2022-12-08 Thread rovero
Fixed the account register balance column issue as well as account now showing negative amount instead of positive amount. The issue with the transaction report total showing positive vs negative still exist however. Joe -Original Message- From: gnucash-user On Behalf Of rov...@comcast.

Re: [GNC] Transaction report

2022-07-04 Thread David T. via gnucash-user
tarting and ending dates of the period I was >interested in. > > > >Thanks much, > >Roger > > > >From: David T. >Sent: Monday, July 4, 2022 8:48 AM >To: gnucash-user@gnucash.org; rmom...@gmail.com; GnuCash > >Subject: Re: [GNC] Transaction repo

Re: [GNC] Transaction report

2022-07-04 Thread rmomxtx
related to the journal entry. 3. General tab: set the starting and ending dates of the period I was interested in. Thanks much, Roger From: David T. Sent: Monday, July 4, 2022 8:48 AM To: gnucash-user@gnucash.org; rmom...@gmail.com; GnuCash Subject: Re: [GNC] Transaction report

Re: [GNC] Transaction report

2022-07-04 Thread David T. via gnucash-user
You can either use a generic Transaction Report and set the search parameters as you need (presumably, date, account, and description). Or you can use the Account Report from the search results register. I suspect you'll have more configuration options using the former approach. David T. On J

Re: [GNC] Transaction Report Account Name Style

2021-08-19 Thread Derek Atkins
Hi, On Thu, August 19, 2021 8:37 am, flywire wrote: > I want to change character style (font attributes), just for Account > Names. > >> Under Display tab, there are the "Use Full Account Name" options. Ah, that's probably not do-able with the current report implementation. > Please remember to

Re: [GNC] Transaction Report Account Name Style

2021-08-19 Thread flywire
I want to change character style (font attributes), just for Account Names. > Under Display tab, there are the "Use Full Account Name" options. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscri

Re: [GNC] Transaction Report Account Name Style

2021-08-19 Thread Derek Atkins
Under Display tab, there are the "Use Full Account Name" options. -derek On Thu, August 19, 2021 8:00 am, flywire wrote: > How can I change the Transaction Report Account Name Style? I can't see it > listed in Edit, Stylesheets or a unique class in the html. > > (The CSS-based stylesheet is a wel

Re: [GNC] Transaction report not seeing selected account

2021-06-27 Thread David Carlson
If you want to repeat a report later with the same or similar settings you need to memorize it with a name that makes sense to you. On Sun, Jun 27, 2021, 10:35 AM Rich Shepard wrote: > For some reason I need to learn a transaction report fails telling me it > needs an account name. I've selected

Re: [GNC] Transaction report export file type

2021-06-24 Thread David Cousens
Rich I just managed to get a balance sheet report into calc on LM20 by copying the html from the report to the clipboeard then used Edit->Paste Special- >Unformatted Text then selected only the tab separator (having comma or space selected is a disaster). It copied from the clipboard with no prob

Re: [GNC] Transaction report export file type

2021-06-24 Thread David H
Ah I didn't think of that - been a long while since I stopped writing design docs and had to link in an external object :-) So we're both still learning which is good !!! Cheers David H. On Fri, 25 Jun 2021 at 08:58, Rich Shepard wrote: > On Fri, 25 Jun 2021, David H wrote: > > > You'll proba

Re: [GNC] Transaction report export file type

2021-06-24 Thread Rich Shepard
On Fri, 25 Jun 2021, David H wrote: You'll probably have to do a bit of cleaning up whichever way you go if you want to get rid of all the extraneous headers the are in the html file to get to a true .csv looking file :-) David, Figured out how to do it. In Calc -> Sheet -> Link to external d

Re: [GNC] Transaction report export file type

2021-06-24 Thread David H
I just used Ubuntu's file explorer to open the folder with the .html file in and then right clicked which gives me a dialog box that I can choose lots of options one of which is what I want to do - it's actually the 2nd option down not the bottom one which says "Other Application"... Cheers David

Re: [GNC] Transaction report export file type

2021-06-24 Thread David H
You'll probably have to do a bit of cleaning up whichever way you go if you want to get rid of all the extraneous headers the are in the html file to get to a true .csv looking file :-) Cheers David H. On Fri, 25 Jun 2021 at 08:46, Rich Shepard wrote: > On Fri, 25 Jun 2021, David H wrote: > >

Re: [GNC] Transaction report export file type

2021-06-24 Thread Rich Shepard
On Fri, 25 Jun 2021, David H wrote: Er yes - I'm running LibreOffice Calc 7.1 on Ubuntu 21.04 and it will open the .html file directly and you can save it as .csv from there - you just have to make sure when you are asked what you want to open the .html file with you click on "Other Application"

Re: [GNC] Transaction report export file type

2021-06-24 Thread Rich Shepard
On Fri, 25 Jun 2021, David H wrote: Er yes - I'm running LibreOffice Calc 7.1 on Ubuntu 21.04 and it will open the .html file directly and you can save it as .csv from there - you just have to make sure when you are asked what you want to open the .html file with you click on "Other Application"

Re: [GNC] Transaction report export file type

2021-06-24 Thread Rich Shepard
On Fri, 25 Jun 2021, David H wrote: What about the cut and paste from html into Calc ? David, I'd first have to remove all the html markup. If I do that I have a plain, ASCII text file regardless of where it's used. And I can reformat it in emacs however I want. Regards, Rich __

Re: [GNC] Transaction report export file type

2021-06-24 Thread David H
Er yes - I'm running LibreOffice Calc 7.1 on Ubuntu 21.04 and it will open the .html file directly and you can save it as .csv from there - you just have to make sure when you are asked what you want to open the .html file with you click on "Other Application" at the bottom of the dialog box and sc

Re: [GNC] Transaction report export file type

2021-06-24 Thread David H
What about the cut and paste from html into Calc ? Cheers David H. On Fri, 25 Jun 2021 at 08:15, Rich Shepard wrote: > On Fri, 25 Jun 2021, David H wrote: > > > Don't know what your objective is but if it helps MS Excel on MacOS will > > David, > > That's fine if you run Apple and Microsoft sof

Re: [GNC] Transaction report export file type

2021-06-24 Thread Rich Shepard
On Fri, 25 Jun 2021, David H wrote: Don't know what your objective is but if it helps MS Excel on MacOS will David, That's fine if you run Apple and Microsoft software; the linux spreadsheets I use, gnumeric and LibreOffice's Calc won't work with .pdf or anything other than .xls(x) or .csv.

Re: [GNC] Transaction report export file type

2021-06-24 Thread Rich Shepard
On Thu, 24 Jun 2021, David Carlson wrote: I have not tested this, but sometimes one can either open a pdf file with a spreadsheet application or copy a PDF file and paste it into a new spreadsheet. Once that is done it is often relatively easy to clean up stray cells and save in CSV format. Da

Re: [GNC] Transaction report export file type

2021-06-24 Thread Rich Shepard
On Thu, 24 Jun 2021, John Ralls wrote: It usually works to copy-and-paste the report into a spreadsheet. John, Oh. Okay. Thanks, Rich ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe:

Re: [GNC] Transaction report export file type

2021-06-24 Thread David H
Rich, Don't know what your objective is but if it helps MS Excel on MacOS will open a txn report html directly - looks ok and you could probably save as csv from there ? Also Numbers won't open it directly but you can highlight everything and paste it into a blank sheet which you could export to

Re: [GNC] Transaction report export file type

2021-06-24 Thread David Carlson
I have not tested this, but sometimes one can either open a pdf file with a spreadsheet application or copy a PDF file and paste it into a new spreadsheet. Once that is done it is often relatively easy to clean up stray cells and save in CSV format. On Thu, Jun 24, 2021 at 4:32 PM Rich Shepard w

Re: [GNC] Transaction report export file type

2021-06-24 Thread John Ralls
> On Jun 24, 2021, at 2:31 PM, Rich Shepard wrote: > > Is there a way to export a transaction report as a .csv or .txt file? I > looked at all options and didn't see any place to select the export format. > When I did export the file it defaulted to .html; that would take a lot of > cleaning a

Re: [GNC] Transaction Report Question

2021-02-11 Thread Adrien Monteleone
Gareth, Can you provide a screenshot of the incorrect report? Can you describe *exactly* how you want it to look? That report has lots of options. The default sorting is by Account Name, then by Register Date for the current accounting period. (default for which is 'This Year') Also, please

Re: [GNC] Transaction Report Question

2021-02-11 Thread Gareth Davies via gnucash-user
2021 01:21 To: gnucash-u...@lists.gnucash.org Subject: Re: [GNC] Transaction Report Question Sounds like you need to fiddle with the Sort tab options. Regards, Adrien On 1/28/21 3:25 PM, Gareth Davies via gnucash-user wrote: > Windows 10 Gnucash 4.4 > > Hi, > My Laptop died on me

Re: [GNC] Transaction Report Question

2021-02-11 Thread Gareth Davies via gnucash-user
2021 01:21 To: gnucash-u...@lists.gnucash.org Subject: Re: [GNC] Transaction Report Question Sounds like you need to fiddle with the Sort tab options. Regards, Adrien On 1/28/21 3:25 PM, Gareth Davies via gnucash-user wrote: > Windows 10 Gnucash 4.4 > > Hi, > My Laptop died on me

Re: [GNC] Transaction Report Question

2021-01-28 Thread Adrien Monteleone
Sounds like you need to fiddle with the Sort tab options. Regards, Adrien On 1/28/21 3:25 PM, Gareth Davies via gnucash-user wrote: Windows 10 Gnucash 4.4 Hi, My Laptop died on me and although everything was backed up the Transaction Reports I had saved were lost. I have installed Ver 4.

Re: [GNC] transaction report missing subtotals

2020-10-17 Thread Fran_3 via gnucash-user
I see the problem. After some experimentation I failed to discover a solution. Hopefully someone else here can chip in. On Saturday, October 17, 2020, 3:57:15 AM EDT, Gal wrote: GnuCash - User mailing list wrote > .. On Sorting Tab - set Primary Key to Date to "enable " Primary Subtot

Re: [GNC] transaction report missing subtotals

2020-10-17 Thread Gal
GnuCash - User mailing list wrote > .. On Sorting Tab - set Primary Key to Date to "enable " Primary Subtotal > Date Key) When the primary key is the date, the primary subtotal are displayed. The issue arises when the date is chosen as the secondary key, in which case "secondary subtotal" checkbox

Re: [GNC] transaction report missing subtotals

2020-10-16 Thread Fran_3 via gnucash-user
I missed the OP but saw a followup on this question. Here is my attempt to explain Transaction Reports Monthly Totals. I'm running Windows 10 and GnuCash Version 4.1 and getting Transaction Reports Monthly Totals seems to work perfectly here. My Process: - Click Reports - Click Transaction Repor

Re: [GNC] transaction report missing subtotals

2020-10-16 Thread Gal
Christopher Lam wrote > 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. Having the same issue. can't get monthly sub totals. Here's a screenshot:

Re: [GNC] Transaction Report issue when using GC from 2 locations via Google Drive

2020-10-09 Thread John Ralls
No, that was about macOS just like it said. Unfortunately GnuCash has a variety of features that prevent it from being ported to mobile. We had a Google Summer of Code student a few years ago who wrote a companion app for Android but he's since moved on and it's no longer maintained. Regards, J

Re: [GNC] Transaction Report issue when using GC from 2 locations via Google Drive

2020-10-09 Thread Fran_3 via gnucash-user
In this case the PC"s are running the latest GnuCash download version for Windows. I haven't explored the "App" yet. I assume you are talking about an app to run on a smart phone... right? Regardless, I want to learn more about the  App but I think that will be another thread down the road. Th

Re: [GNC] Transaction Report issue when using GC from 2 locations via Google Drive

2020-10-09 Thread John Ralls
> On Oct 9, 2020, at 4:09 AM, Manfred Usselmann wrote: > > Under MacOS X the following directory is used: > ~/Library/Preferences/gnucash.plist. That depends on how you get GnuCash. If it's Gnucash.app then the preferences file is ~/Library/Preferences/org.gnucash.Gnucash.plist. gnucash.pli

Re: [GNC] Transaction Report issue when using GC from 2 locations via Google Drive

2020-10-09 Thread Manfred Usselmann
In addition: For syncing settings as well under Linux I use the following start script to import settings before running gnucash and export settings afterwards with dconf: 8< #!/bin/sh # Start GnuCash with import and export of settings # HOME_DIR="

Re: [GNC] Transaction Report issue when using GC from 2 locations via Google Drive

2020-10-08 Thread Adrien Monteleone
#1 yes (see the wiki about storage locations for your operating system) #2 I don't think you can change it, buy you can add it to your GoogleDrive sync list. Regards, Adrien On 10/8/20 12:13 PM, Fran_3 via gnucash-user wrote: The GnuCash file entityA.gnucash is saved on Google Drive.GnuCash

Re: [GNC] Transaction Report Filter for keyword in Description ?

2020-09-21 Thread Fran_3 via gnucash-user
I think the implied meaning of "Account" got me confused... Transaction Report - Accounts Tab:I selected the "Account" via the Accounts Tab to be... "Assets > Current Assets > Checking Account" Transaction Report - Filter Tab - Account Name Filter field: Is the "Account Name Filter" field expect

Re: [GNC] Transaction Report Filter for keyword in Description ?

2020-09-21 Thread John Ralls
> On Sep 21, 2020, at 8:57 AM, Fran_3 via gnucash-user > wrote: > > How can I create a Transaction Report for the Check Register... > set to only display transactions where a keyword appears in the Description > field? > I'm confused by the "Account Name" Filter and the "Transaction Filter"

Re: [GNC] Transaction report: selected date range

2020-05-24 Thread Adrien Monteleone
And if you want to really get fancy, you have more filtering options with a Find than with a Transaction Report, then running the Account Report on the resulting register tab. The Transaction Report however does provide some nice dimensional sorting the Account Report lacks. Regards, Adrien >

Re: [GNC] Transaction report: selected date range

2020-05-24 Thread D. via gnucash-user
te range. Original Message From: Adrien Monteleone Sent: Sun May 24 13:39:03 EDT 2020 To: gnucash-user Subject: Re: [GNC] Transaction report: selected date range The Transaction Report can be for multiple accounts, so it doesn’t matter what register is open at the time. The

Re: [GNC] Transaction report: selected date range

2020-05-24 Thread David Carlson
As Adrien points out, the Account report is only for the currently selected account. For that report use the account View > Sort and View >Filter options to limit the report to the desired transactions. On Sun, May 24, 2020 at 12:41 PM Adrien Monteleone < adrien.montele...@lusfiber.net> wrote: >

Re: [GNC] Transaction report: selected date range

2020-05-24 Thread Adrien Monteleone
The Transaction Report can be for multiple accounts, so it doesn’t matter what register is open at the time. The Account Report is for the currently viewed register. The two reports are quite different in their available options, however. Regards, Adrien > On May 24, 2020 w22d145, at 12:08 PM,

Re: [GNC] Transaction report: selected date range

2020-05-24 Thread Rich Shepard
On Sun, 24 May 2020, Fred Bone wrote: When I run the transaction report it points out that I need to select the account in "Options". Fred, Huh! I saw the link but missed the instruction above it. Mea culpa! Having said which, I'm not on the latest version. What version are you running? 3

Re: [GNC] Transaction report: selected date range

2020-05-24 Thread Fred Bone
On 24 May 2020 at 8:56, Rich Shepard said: > I'm missing something in my attempts to define a date range for a > transaction report on a single account. > > The account is displayed and has focus. I select Reports -> Account report > -> Options and do find where I can specify starting and ending

Re: [GNC] Transaction report: selected date range

2020-05-24 Thread Rich Shepard
On Sun, 24 May 2020, Rich Shepard wrote: -> Options and do find where I can specify starting and ending dates. When I ^ NOT ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubs

Re: [GNC] Transaction Report Filter Questions

2020-05-22 Thread Fran_3 via gnucash-user
Thanks Christopher. On Thursday, May 21, 2020, 1:58:52 AM EDT, Christopher Lam wrote: Until 4.x is ready, yes you'll have to use this syntax. On Thu, 21 May 2020, 12:19 am Fran_3 via gnucash-user, wrote: Transaction Filter seems to be case sensitive as searching for "Chevron" will

Re: [GNC] Transaction Report Filter Questions

2020-05-20 Thread Christopher Lam
Until 4.x is ready, yes you'll have to use this syntax. On Thu, 21 May 2020, 12:19 am Fran_3 via gnucash-user, < gnucash-user@gnucash.org> wrote: > Transaction Filter seems to be case sensitive as searching for "Chevron" > will not find "CHEVRON" so you must use regx like > [Cd][Hh][Er][Vv][Rr][O

Re: [GNC] Transaction Report Default Account

2020-05-10 Thread flywire
Thanks @John Ralls that wiki page was what prompted this thread, hoping to tweak report without going through the full report development process. > just save the report configuration The issue is Save Report Configuration saves those reports in a different part of the menu to the default reports

Re: [GNC] Transaction Report Default Account

2020-05-10 Thread John Ralls
> On May 10, 2020, at 12: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

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 wit

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. Quest

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. __

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 t

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: As

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. Bu

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 multiple

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 lawyer/

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

2019-11-01 Thread Fran_3 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 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 couldn'

  1   2   >