Re: [GNC] gnucash-user Digest, Vol 225, Issue 32
Most apps also have those items on right click menus. And double clicks are a major contributor/exacerbater of repetitive stress injuries, so I avoid them as much as possible. -- Ron Dec. 13, 2021 18:45:47 Kalpesh Patel : > That may be so, but it's news to me. I've been in the tech business for a > long time, but I've done my best to avoid Windows as much as possible (long > boring story why I'm on it now). Might work on Linux too for all I know. Most > apps I've used default to reasonable column widths (including the somewhat > dated gnucash I was using on Debian until recently). > -- > Ron > > Dec. 13, 2021 18:40:43 Kalpesh Patel : > >> I believe double clicking on the right side divider line of a column to >> resize best fit for the largest content in that column is known practice in >> PC world since ages (I recall being able to do so since text based Lotus 123 >> times when mouse navigation was introduced in DOS mode) and behavior is >> universal on most, if not all, applications on PC. This also holds true for >> bottom row divider in most, if not all, applications on PC (at least on >> Windows for sure) where it resizes best fit for the highest content size in >> that column. >> >> >> Message: 1 >> Date: Sun, 12 Dec 2021 22:22:01 -0600 >> From: Adrien Monteleone >> To: gnucash-u...@lists.gnucash.org >> Subject: Re: [GNC] How to fix zero-length register column? >> Message-ID: >> Content-Type: text/plain; charset=UTF-8; format=flowed >> >> I could be mistaken, but I'm fairly certain you don't have to 'stumble' >> on that 'trick' or any other as it is a designed feature. It should be >> documented in Help or the Guide. There is a section devoted to resizing >> columns. >> >> There was some work done on setting widths for all 'similar' registers, but >> I think it was reverted due to bugs. I think it is still currently available >> for Bills/Invoices, however. (by 'similar' registers, I mean by main GnuCash >> type, thus, you could set all 'asset' registers with certain particular >> column widths, and those widths could be different for 'liability', >> 'equity', 'income' or 'expense' registers) >> >> Regards, >> Adrien >> >> On 12/12/21 6:06 PM, Ron Hunter-Duvar wrote: >>> Thanks, David. Somehow I never stumbled across the double-click trick. >>> >>> It resizes to the smaller of the header text or the column contents, >>> so it still makes "Tot Withdrawal" unnecessarily wide, and for some >>> reason on Description it pushes the right-most parts out of the >>> window, introducing a horizontal scroll bar. I think it must assume >>> the window is full screen instead of using the actual window size. But >>> it reduces it to only a couple of columns I need to manually resize, >>> so it's an improvement. >>> >>> Now if only it would set all registers at once (at least as an option) >>> and not change them after I set them. Hey, I can dream. >>> >>> Ron ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] gnucash-user Digest, Vol 225, Issue 32
That may be so, but it's news to me. I've been in the tech business for a long time, but I've done my best to avoid Windows as much as possible (long boring story why I'm on it now). Might work on Linux too for all I know. Most apps I've used default to reasonable column widths (including the somewhat dated gnucash I was using on Debian until recently). -- Ron Dec. 13, 2021 18:40:43 Kalpesh Patel : > I believe double clicking on the right side divider line of a column to > resize best fit for the largest content in that column is known practice in > PC world since ages (I recall being able to do so since text based Lotus 123 > times when mouse navigation was introduced in DOS mode) and behavior is > universal on most, if not all, applications on PC. This also holds true for > bottom row divider in most, if not all, applications on PC (at least on > Windows for sure) where it resizes best fit for the highest content size in > that column. > > > Message: 1 > Date: Sun, 12 Dec 2021 22:22:01 -0600 > From: Adrien Monteleone > To: gnucash-u...@lists.gnucash.org > Subject: Re: [GNC] How to fix zero-length register column? > Message-ID: > Content-Type: text/plain; charset=UTF-8; format=flowed > > I could be mistaken, but I'm fairly certain you don't have to 'stumble' > on that 'trick' or any other as it is a designed feature. It should be > documented in Help or the Guide. There is a section devoted to resizing > columns. > > There was some work done on setting widths for all 'similar' registers, but > I think it was reverted due to bugs. I think it is still currently available > for Bills/Invoices, however. (by 'similar' registers, I mean by main GnuCash > type, thus, you could set all 'asset' registers with certain particular > column widths, and those widths could be different for 'liability', > 'equity', 'income' or 'expense' registers) > > Regards, > Adrien > > On 12/12/21 6:06 PM, Ron Hunter-Duvar wrote: >> Thanks, David. Somehow I never stumbled across the double-click trick. >> >> It resizes to the smaller of the header text or the column contents, >> so it still makes "Tot Withdrawal" unnecessarily wide, and for some >> reason on Description it pushes the right-most parts out of the >> window, introducing a horizontal scroll bar. I think it must assume >> the window is full screen instead of using the actual window size. But >> it reduces it to only a couple of columns I need to manually resize, >> so it's an improvement. >> >> Now if only it would set all registers at once (at least as an option) >> and not change them after I set them. Hey, I can dream. >> >> Ron ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] How to fix zero-length register column?
Cool, thanks for the tip, Glenn. With a little command line scripting in Cygwin I should even be able to achieve my dream of setting my desired column widths once for all registers. Ron On 2021-12-12 13:52, Glenn Fowler wrote: Hi, If your mouse is too sensitive and you aren't able to adjust via the other solutions, you can navigate to: C:\Users\\AppData\Roaming\GnuCash\books\YourBookName.gcm and open your book config in this folder. Look for "reconcile_width=" and just make it 50 and save. It'll now be wide enough to manipulate via mouse. On Sun, Dec 12, 2021 at 1:34 PM Ron Hunter-Duvar wrote: Hi, Background: I was resizing the columns in my chequing account register (yet again, because GnuCash 4.x on Windows 10 keeps resizing the date, number, and amount columns to more than double the needed size and shrinking the memo and account columns too small to read what's in them, but that's a separate issue). I grabbed the wrong resize spot at one point (another separate issue, but why is the top part of the separator between the account and clear columns invisible?). Anyway, I shrank the clear column to zero width before I realized what I was doing. Now it's impossible to grab the invisible resize spot and enlarge it again. It only changes the size of the account column. I haven't been able to find any way bring it back. So now I can't mark transactions cleared in my chequing account. Does anyone here know how to fix this? Thanks, Ron ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] How to fix zero-length register column?
Thanks, David. Somehow I never stumbled across the double-click trick. It resizes to the smaller of the header text or the column contents, so it still makes "Tot Withdrawal" unnecessarily wide, and for some reason on Description it pushes the right-most parts out of the window, introducing a horizontal scroll bar. I think it must assume the window is full screen instead of using the actual window size. But it reduces it to only a couple of columns I need to manually resize, so it's an improvement. Now if only it would set all registers at once (at least as an option) and not change them after I set them. Hey, I can dream. Ron On 2021-12-12 13:14, David H wrote: Ron, See Gyle's email to fix your issue. A couple of things to note - it is generally easiest to double click the column header to resize a column to an appropriate size assuming you don't have any really long column contents and always adjust the "Description" column last as it's set to automatically fill the remaining space but if you've adjusted other column widths you need to just click and hold on the right side Description column header delimiter and just move it a little bit left or right and let it go to get it to recognise your adjusted other columns. Cheers David H. On Mon, 13 Dec 2021 at 04:35, Ron Hunter-Duvar wrote: Hi, Background: I was resizing the columns in my chequing account register (yet again, because GnuCash 4.x on Windows 10 keeps resizing the date, number, and amount columns to more than double the needed size and shrinking the memo and account columns too small to read what's in them, but that's a separate issue). I grabbed the wrong resize spot at one point (another separate issue, but why is the top part of the separator between the account and clear columns invisible?). Anyway, I shrank the clear column to zero width before I realized what I was doing. Now it's impossible to grab the invisible resize spot and enlarge it again. It only changes the size of the account column. I haven't been able to find any way bring it back. So now I can't mark transactions cleared in my chequing account. Does anyone here know how to fix this? Thanks, Ron ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] How to fix zero-length register column?
Thanks, Gyle. I had noticed the double line, and tried several times unsuccessfully (another aside, why do they have to make the grab zones so small, apparently 1 pixel wide, below the resolution of the trackpad, mouse or trackball I have?). I decided to give it one more shot, and wouldn't you know, this time it worked. Ron On 2021-12-12 12:48, Gyle McCollam wrote: Ron, I tried duplicating your issue. When I tried to reduce the Reconcile Column to a zero width I noticed it appeared to have a double line or at least a darker line. If you mouse over very carefully from the right side and as soon as you see the doubled headed arrow, click and drag to the right, it should restore the column to where you can double click to automatically resize the column. It may take several tries, but it does work. Thank You, *Gyle McCollam* Gyle McCollam 609.680.2326Mobile gmccol...@live.com <mailto:gmccol...@gyleshomes.com>email *From:* gnucash-user on behalf of Ron Hunter-Duvar *Sent:* Sunday, December 12, 2021 1:34 PM *To:* gnucash-user@gnucash.org *Subject:* [GNC] How to fix zero-length register column? Hi, Background: I was resizing the columns in my chequing account register (yet again, because GnuCash 4.x on Windows 10 keeps resizing the date, number, and amount columns to more than double the needed size and shrinking the memo and account columns too small to read what's in them, but that's a separate issue). I grabbed the wrong resize spot at one point (another separate issue, but why is the top part of the separator between the account and clear columns invisible?). Anyway, I shrank the clear column to zero width before I realized what I was doing. Now it's impossible to grab the invisible resize spot and enlarge it again. It only changes the size of the account column. I haven't been able to find any way bring it back. So now I can't mark transactions cleared in my chequing account. Does anyone here know how to fix this? Thanks, Ron ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] How to fix zero-length register column?
Hi, Background: I was resizing the columns in my chequing account register (yet again, because GnuCash 4.x on Windows 10 keeps resizing the date, number, and amount columns to more than double the needed size and shrinking the memo and account columns too small to read what's in them, but that's a separate issue). I grabbed the wrong resize spot at one point (another separate issue, but why is the top part of the separator between the account and clear columns invisible?). Anyway, I shrank the clear column to zero width before I realized what I was doing. Now it's impossible to grab the invisible resize spot and enlarge it again. It only changes the size of the account column. I haven't been able to find any way bring it back. So now I can't mark transactions cleared in my chequing account. Does anyone here know how to fix this? Thanks, Ron ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] Adjusted Trial Balance
Trying to figure out what the best practice is for Adjustment Entries and Adjusted Trial Balance is in GnuCash. My main requirement is to be able to easily produce a (Non-Adjusted) Trial Balance and a Adjusted Trial Balance report. I was thinking of creating a temporary Adjustment Account to hold changes and I could restore/delete this account to generate the above report. Seeking help on best practice for this. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] Register layout
How do I re-arrange the layout of the check register to my liking? How do I get auto-fill for the payee? Ron ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] Failed import
I thought I had this figured out and have been importing small chunks from Quicken. I imported 6 months twice from a credit card and it was fine. Tried to import the last 2 months and it failed. I removed 2 duplicate transactions, but still happened. Any ideas? Ron ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] payees?
I do see any mention of a list of payees? I have in the past wanted to report on payees, and also used autofill for payee name so that it was consistent. Ron ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Multiple copies of gnucash-user messages from the list
I think I have my communication problem resolved. As I understand it, I email questions to gnucash-user, and I see all gnucash-user messages in my email: I am receiving individual messages which is my choice. If I wanted to see a collection of messages, then I would look at archives. I have set my preferences in settings. Can I restrict messages received to only my questions? Did not see that option. I am not getting duplicate messages. Thank you! Ron -Original Message- From: gnucash-user On Behalf Of Liz Sent: Saturday, February 15, 2020 2:33 AM To: gnucash-user@gnucash.org Subject: Re: [GNC] Multiple copies of gnucash-user messages from the list On Wed, 12 Feb 2020 16:47:20 -0600 Adrien Monteleone wrote: > What do you mean by ‘archive messages’? > > Are you set to receive in digest form, or individually? > > Otherwise, there are 3 preferences I can see that would possibly > result in ‘duplicates’. > > 1 - Avoid duplicate copies of messages? (you’d want to set this to > ‘yes’ to *avoid* duplicates. That is, if you are in the To: or CC: > fields, the list will try not to send one to you in addition.) > > 2 - Receive your own posts to the list? (you’d want to set this to > ’no’ to not have the list send you a copy of what you just posted. > You can use your Sent box/folder or thread it appropriately according > to however your mail client works) This would only apply to your own > posts, not those of others. > > 3 - Receive acknowledgement mail when you send mail to the list? > (again, you’d want to set this to ’no’ to not receive a ‘hey, you just > sent this to the list’ message) Again, this only applies to your own > posts, not those of others. > > Otherwise, I can’t see any reason why you’re getting more than 1 or > even 2 or more copies of every post. And it seems the problem is on > your end, because you’re the only one (so far) saying it is happening. > > (note, I can imagine such a mess if you had the above three > preferences set wrong, were not using digest mode, and sent messages > to the list by hitting ‘reply-all’ and you were also in the To: or > CC: fields, which might generate as many as 4 copies of your own > messages to the list.) > > If the list were spamming members with duplicates, triplicates, and > worse, it would be noticed and addressed. I did check Alan's message settings from gnucash-user. At the time that I checked he was set the receive mails individually, and have no duplicates. Liz Moderator ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] Failed - import of QIF files from Quicken
Liz sent me a message but I do not know how to do a Reply. Windows version. Quicken - latest Online subscription - that is why I want out. Gnucash just downloaded 3.8. I read that it might be better to import small files so I exported one account (category) and it still failed. Log was not helpful. Ron ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] Failed - import of QIF files from Quicken
I have tried importing one account at a time with one option selected for export, and lots of other options. All tell me they Failed. Some Log files Say "No suitable backend was found for .Failed.gnucash.202002121500956.log" Others just are empty. Nothing in documentation. Ron Carr ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] Multi-select on import - OSX
Thank you for all the hard work maintaining and developing Gnucash. I expect running an open source project can feel thankless at times. The effort is greatly appreciated. I have a quick question about the new multi-select on import feature. On OSX, the default right-click is CTRL-tap, which is also one of the multi-select options in the import dialog, When I make a multi selection (say, SHIFT-tap) and then CTRL-tap it does not bring up the account select dialog. Instead, it just unselects the entries in the multi-select except the one under the pointer and brings up the account select dialog for the single entry. Am I missing something obvious here? Ron ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] How do I display the accumulated total Assets on the balance sheet?
On Sat, May 25, 2019 at 4:01 PM Christopher Lam wrote: > You'll have to explore the Display -> Parent account subtotals/balances > options. > That's what I thought as well, so I have it set to "Show subtotals" but it still shows C$0.00 only. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Assets don't display in CasgFlow report
On Sat, Apr 20, 2019 at 12:58 PM Adrien Monteleone < adrien.montele...@lusfiber.net> wrote: > Ron, > > I think I might understand now what you are describing. > > There are three sections to the report: > > 1. Selected Accounts > 2. Money into selected accounts comes from > 3. Money out of selected accounts goes to > > #1 is just a list - no figures > > The actual ‘report’ is sections #2 & #3. Some of those *might* be asset > accounts and the should show amounts when they appear in those two > sections. If they are not, then you have other problems. (they shouldn’t > even show up at all if no activity occurred with them) > > If you want to see the value of your assets, run a Balance Sheet. > h okay, Got it! Great (y) - makes sense - as I said, I'm a newbie ;) > Hope that helps. > It did, Thanks a lot! :) Ron > On Apr 20, 2019, at 1:20 PM, Ron Eggler wrote: > > > > Hi Adrien, > > > > Thanks for your response! > > > > Edit your report options to include the accounts you want. There is an > ‘Accounts’ tab where you make the selection. > > > > I have selected them and they do show up in the "Selected Accounts" list > only there's no number amount to the right of the name. > > > > Be mindful of the account depth setting as well. > > > > Yes, I've set that to 3 (to include the accounts I need) > > > > Note, of course, the accounts in question have to have transactions > during the same period as the report in order to show up. > > > > If I do click onto the link in the "Selected Accounts" list, it will > take me to the account and display transactions as recorded within the > selected period but still, I see no number displayed to the right - mind > this is just for Assets, Money In & Money Out looks correct. > > > > Ron > > > > > > > > > On Apr 19, 2019, at 4:52 PM, Ron Eggler wrote: > > > > > > Hi, > > > GnuCash newbie here, sorry if the answer to my question is obvious. > > > When I create a Cash Flow report, Money In & Money Out seems to display > > > properly but the Assets don't. In accounts, I have some "Bank"-Type > > > accounts under "Asset". > > > My assets kind of look like (the account Type is in []): > > > Assets [Asset] > > > Deposits in Can banks/instit - Can currency [Asset[ > > >account1 [Bank] > > >account2 [Bank] > > >Deposit in Can banks/instit - Foreign currency > > >account1 (USD) [Bank] > > >account2 (USD) [Bank] > > > > > > why would this not work as expected and show up in the report > accordingly? > > > And more importantly, how can I make my assets show up? > > > > > > Thanks a lot! > > > Ron > > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. > ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Assets don't display in CasgFlow report
Hi Adrien, Thanks for your response! > > Edit your report options to include the accounts you want. There is an > ‘Accounts’ tab where you make the selection. > I have selected them and they do show up in the "Selected Accounts" list only there's no number amount to the right of the name. > > Be mindful of the account depth setting as well. > Yes, I've set that to 3 (to include the accounts I need) > > Note, of course, the accounts in question have to have transactions during > the same period as the report in order to show up. > If I do click onto the link in the "Selected Accounts" list, it will take me to the account and display transactions as recorded within the selected period but still, I see no number displayed to the right - mind this is just for Assets, Money In & Money Out looks correct. Ron > > > On Apr 19, 2019, at 4:52 PM, Ron Eggler wrote: > > > > Hi, > > GnuCash newbie here, sorry if the answer to my question is obvious. > > When I create a Cash Flow report, Money In & Money Out seems to display > > properly but the Assets don't. In accounts, I have some "Bank"-Type > > accounts under "Asset". > > My assets kind of look like (the account Type is in []): > > Assets [Asset] > > Deposits in Can banks/instit - Can currency [Asset[ > >account1 [Bank] > >account2 [Bank] > >Deposit in Can banks/instit - Foreign currency > >account1 (USD) [Bank] > >account2 (USD) [Bank] > > > > why would this not work as expected and show up in the report > accordingly? > > And more importantly, how can I make my assets show up? > > > > Thanks a lot! > > Ron > > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. > ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] Fwd: Assets don't display in CasgFlow report
Hi, GnuCash newbie here, sorry if the answer to my question is obvious. I'm using version 2.6.12 When I create a Cash Flow report, Money In & Money Out seems to display properly but the Assets don't or better, the report doesn't show an amount behind the account name. In the report options, I selected Account Display Depth 3 (instead of 2) and if I click onto the account names (the links) it takes me correctly to the corresponding account with all transactions but still, no balance for the accounting period shows up why is this? In accounts, I have some "Bank"-Type accounts under "Asset". My assets kind of look like (the account Type is in []): Assets [Asset] Deposits in Can banks/instit - Can currency [Asset] account1 [Bank] account2 [Bank] Deposit in Can banks/instit - Foreign currency account1 (USD) [Bank] account2 (USD) [Bank] why would this not work as expected and show up in the report accordingly? And more importantly, how can I make my assets' balances show up? Thanks a lot! Ron ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] Assets don't display in CasgFlow report
Hi, GnuCash newbie here, sorry if the answer to my question is obvious. When I create a Cash Flow report, Money In & Money Out seems to display properly but the Assets don't. In accounts, I have some "Bank"-Type accounts under "Asset". My assets kind of look like (the account Type is in []): Assets [Asset] Deposits in Can banks/instit - Can currency [Asset[ account1 [Bank] account2 [Bank] Deposit in Can banks/instit - Foreign currency account1 (USD) [Bank] account2 (USD) [Bank] why would this not work as expected and show up in the report accordingly? And more importantly, how can I make my assets show up? Thanks a lot! Ron ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] print account names for Grand total in reports
Hi, I'm interested in breaking the totals up by account and showing the account names especially for the Grand Total (for tax purposes) Currently, the transaction record displays the Grand Total on the bottom as follows: Grand Total 500 GOOG -333 APPL -150 SPY $12345.67 100 QQQ $987654.32 The stocks I can account for by the symbol name but I'm not sure what the amounts belong to. How do I display the account names and the totals from each account with transactions during the period? Thanks, Ron ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] report: group account activity by accounting period instead of by month
Thanks, guys! I'm a GnuCash newbie regarding the creation of reports & sorting and stuff. I think setting primary to Date by Month and Secondary to Date by year gives me what I needed. However, the totals don't say which account the numbers belongs to, how do I add that? On Sun, Apr 7, 2019 at 8:15 PM David T. wrote: > > Indeed. I read that backwards, and advised how to get monthly subtotals. > > If you are in the US, you might explore the Tax Options settings, which, > when combined with the TXF report, can make tax reporting very easy. > > David > > On Mon, Apr 8, 2019 at 8:25, John Ralls > wrote: > > > > On Apr 7, 2019, at 6:53 PM, Ron Eggler wrote: > > > > Hi, > > > > I'm using GnuCash 2.6.12 and would like to create an annual report for > tax > > reporting purposes. For that, I would like to create a report where > > transactions are grouped for the whole year, accounting period but > instead, > > I get them grouped by month. How can I change this? > > Assuming the transaction report, click report options and select the > sorting tab. > > If your period is 1 year you can just uncheck "secondary subtotal". If the > period is longer and you want yearly subtotals, change secondary key > to Date and Secondary Subtotal for Date Key to Yearly. > > Regards, > John Ralls > > > > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists > for more information. > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. > > ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] Fwd: report: group account activity by accounting period instead of by month
Hi, I'm using GnuCash 2.6.12 and would like to create an annual report for tax reporting purposes. For that, I would like to create a report where transactions are grouped for the whole year, accounting period but instead, I get them grouped by month. How can I change this? Thanks, Ron ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] report: group account activity by accounting period instead of by month
Hi, I'm using GnuCash 2.6.12 and would like to create an annual report for tax reporting purposes. For that, I would like to create a report where transactions are grouped for the whole year, accounting period but instead, I get them grouped by month. How can I change this? Thanks, Ron ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Check for negative amount in scheduled transaction formula
Thanks for this Derek. I'm on a Mac and only see one copy of fin.scm in the application bundle. Seems any edits to this would be lost at the next upgrade. Should I be defining another one somewhere under ~/Library/Application Support/GnuCash or elsewhere? Ron - Original Message - From: "Derek Atkins" To: "gnucash dgr9z" Cc: "Gnucash Users" Sent: Monday, January 21, 2019 3:16:52 PM Subject: Re: [GNC] Check for negative amount in scheduled transaction formula gnucash.dg...@ncf.ca writes: > Hi, > > Is it possible to convert negative numbers to 0 in a formula? something like: > a-b < 0 ? 0 : a-b > > If this needs to be defined as a function someplace, what would it > look like, where would it go, and how would it be called from the > template? Look at fin.scm and copy the functions in there. > Many thanks, > Ron > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. -derek -- Derek Atkins 617-623-3745 de...@ihtfp.com www.ihtfp.com Computer and Internet Security Consultant ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] Counter formats not saving
I am using Gnucash 3.4 on OSX 10.14.2. I am creating a new book and trying to set up the invoice counter to use I-%05li as the format. If I click Apply and switch to another tab and back, the new format appears as it should in the Invoice Number Format text field. But if I click OK, the field is cleared. Saving the file after clicking OK makes no difference. The format string disappears. None of the other formats (vendor, bill, order, employee etc) save either. Any suggestions on how to get this working are greatly appreciated. Thanks, Ron ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Converting a manual transaction to an AP payment
Yes. I am highlighting the transaction in the bank register and right-clicking. All I see are Cut, Copy, Paste, Delete and Select All. Ron - Original Message - From: "Adrien Monteleone" To: "Gnucash Users" Sent: Wednesday, September 12, 2018 11:58:28 AM Subject: Re: [GNC] Converting a manual transaction to an AP payment Strange, it’s there for me on that same version and system. Are you choosing the transaction from the register you chose to make the payment from? If I try to select a payment in the AP/AR registers I get the “Edit Payment” option. The only time neither shows up is if I try to right-click on the bill/invoice transaction. (because you can’t assign a bill/invoice as payment to itself) Regards, Adrien > On Sep 12, 2018, at 5:55 AM, gnucash.dg...@ncf.ca wrote: > > Thanks for the quick reply. > > No. The transaction is definitely not associated with an invoice. I've since > discovered that the feature is available from Edit > Assign as Payment ..., > but not from the right-click context menu as mentioned in the document I > linked to previously; at least not in 3.2 on OSX 10.13.6. > > - Original Message - > From: "Geert Janssens" > To: gnucash-user@gnucash.org, "Ron Stone" > Sent: Wednesday, September 12, 2018 6:23:41 AM > Subject: Re: [GNC] Converting a manual transaction to an AP payment > > Op woensdag 12 september 2018 11:14:28 CEST schreef Ron Stone: >> The page https://wiki.gnucash.org/wiki/Business_Features_Issues has a >> section called "I entered a payment directly instead of using Process >> Payment" and the instruction to fix these transactions for Gnucash 3.x is >> to right click them in the checking account and select "Assign as >> payment...". That entry is not available from the context menu. Has the >> feature been removed? > > No. Do you have an "Edit Payment..." option ? That would suggest gnucash > already has this transaction associated to an invoice. > > Regards, > > Geert > > > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. > ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] Converting a manual transaction to an AP payment
The page https://wiki.gnucash.org/wiki/Business_Features_Issues has a section called "I entered a payment directly instead of using Process Payment" and the instruction to fix these transactions for Gnucash 3.x is to right click them in the checking account and select "Assign as payment...". That entry is not available from the context menu. Has the feature been removed? Thanks, Ron ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] help setting accounts to track contributions
I suggest you don't do this unless you both suffer from OCD. It will lead to disharmony and discord because no matter how hard you try there is never true "equality" in any relationship. Instead, live, love, enjoy and support each other. Do things together and don't worry about who's wallet it comes from. Do something every day to show your partner how much you appreciate the fact they are in your life, and don't expect them to pay half. At the end of your life where the money came from won't be important, but if you make it important now it will kill the relationship. If you insist on doing this, then stick to the major fixed expenses like rent/mortgage and insurance. And then, prepare to be flexible on these targets because life will intervene and there will be times when you or your partner will not be able to meet them, and trying to reduce these events to a spreadsheet or financial program will only make bad situations more toxic. Sure, your partner needs to contribute to the other, variable expenses. And you need to talk about it if you don't feel they are doing their part. This will be a continuing and recurring process. But if you start trying to reduce those things to a fixed mathematical construct then you will find yourself on the road to frustration. I will give you just one example: Grocery budget. Sure, you can set a figure and stipulate that each partner pays 50% (or a percentage based upon respective incomes...but on that path lies madness). But what if you eat 7 eggs out of the dozen? Or your partner drinks three glasses of wine to your one? Do you then go back and recalculate the value of "contributing equally"? What if your tracking of these things has greater granularity than your partner's? If you insist on reducing every household expenditure to a set distribution pattern your partnership becomes a business. Is that what you want out of a personal relationship? RBM On 05/04/2018 02:13 AM, Gio Bacareza wrote: Hi, My partner and I are moving in together and we'd like to share expenses like groceries, rent, etc. So we'd like to track expenses as well as our appropriate contributions to make sure that we both are contributing equally to house expenses. How should I set up the contribution? Under what main account type should it be? Any recommendations? ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Discover Card Working
There was a post earlier this week about downloading Discover Card. I was able to get it working: You first have to manually add the account in aqbanking setup. Discover won't automatically download the account list. When you set up the connection use 'Discover Card Account Center' for ORG and '9625' for FID. I got those values from my Quicken log. After that it worked. I hope that works for you. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Using Online Banking features
I've just set up GnuCash (Linux). I have all my accounts set up (a lot of work). I have moved over all the data from Quicken (a lot more work) and everything balances. I have gone through the online banking setup and can connect to my bank just fine. The setup recognized the three accounts I have this bank and I associated them to the corresponding GnuCash accounts. But I'm excited and confused. It seems there is quite a bit of information about setting up online banking but hardly anything on how to actually use it. When I read GnuCash has online banking my expectation is that it would work similar to Quicken? So here I am just starting to use GnuCash: 1) Now I want to send several bill payments to the bank. With Q, I setup the online payees first and then just put 'send' in the check number to make a payment. What do I do in GnuCash? How do I make payments? 2) I have three separate accounts at the same bank. With Q, I just just click on "Ron's Bank". It then downloads all the transactions and sends all the payments for all three accounts at one time. How do I do that with GnuCash? 3) I have several scheduled online payments set up in Q. I set it up once and then every month it automatically pays the same amount on the scheduled date. I don't have to do anything else. How do I do that with GnuCash? I'd appreciate some help on how to use these online features. Thanks. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Reports crashing
With version 2.6.17 and up to 2.6.19, the Reports crash whenever I try to generate any report. It seems a report actually is generated as an html report and residing in \user\app data\local\temp but GnuCash does not launch a browser and GnuCash itself crashes. I am using data from 2.6.12 and it works fine up to and including 2.6.16. I have tried on two computers with Win 10 Home and Win 10 Pro. I have tried changing the default system browser to IE, Edge and FireFox. I have also tried removing GnuCash completely, cleaning the registry with CCleaner, and manually editing through regedit to remove all traces of GnuCash, then rebooting and reinstalling 2.6.17. Can someone please point me towards a possible fix ?? thanks ... Ron ___ gnucash-user mailing list gnucash-user@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.
GnuCash > 2.6.16 Reports crashing
I am currently using ver. 2.6.12 and decided to upgrade to 2.6.19 on Win 10 Pro (fully updated). When I use any version greater than 2.6.16 and try to generate any report, the program crashes. Ver 2.6.16 and back down to 2.6.12 work perfectly. Not certain if this is correct but I found a trace report in \user\app data\local\temp\gnucash.trace.M3PICZ.log with the following line "* 18:31:13 WARN Could not spawn perl: Failed to execute child process (No such file or directory) ". Can someone please point me towards possible fixes. Yes, I have tried searching throughout the mail list and elsewhere but have not found a solution. thanks ... Ron ___ gnucash-user mailing list gnucash-user@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.
GNU Reports
Hello, I am new to Gnucash and was wondering if it's possible to produce a profit and loss report that shows individual months as well as a total. *Regards* *Ron Buchan **"If you have to choose between drinking wine every day or being skinny which would you choose? Red or White?"* ___ gnucash-user mailing list gnucash-user@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.