[GNC] Scheduled Transactions Window Sorting

2023-01-13 Thread David T. via gnucash-user
Hello, Gnucash 4.13 Windows 10. As I reacquaint myself with scheduled transactions, I find myself opening that window regularly. Each time I open the window, transactions are listed in last created order. This despite my having sorted the list alphabetically the previous time. My question

Re: [GNC] Scheduled Transactions Question

2023-01-13 Thread Adrien Monteleone
I seem to recall having done that once or twice too! Regards, Adrien On 1/14/23 12:37 AM, David T. via gnucash-user wrote: Thanks. I did a little testing, trying both your suggestion and Stan's. Both seemed to have the same result: I was only prompted once. I suspect that "formula-izing" the

Re: [GNC] Scheduled Transactions Question

2023-01-13 Thread David T. via gnucash-user
Thanks. I did a little testing, trying both your suggestion and Stan's. Both seemed to have the same result: I was only prompted once. I suspect that "formula-izing" the transaction doesn't materially change anything here. In retrospect, I suspect user error in the first place. I now believe

Re: [GNC] Recommended Method of Entry for IRA Distributions

2023-01-13 Thread David T. via gnucash-user
Michael, Thanks again for your perspective. I admit to being a little confused by your comments here. My breakdown was based on an earlier post that emphasized the need to isolate the initial deposits into a "deferred income" account and add the extra entries at distribution time. I

Re: [GNC] exporting from gnucash to Excel

2023-01-13 Thread Peter West
How can this be enforced except by obliging you to use only software they (inland revenue?) endorse? — Peter West p...@pbw.id.au “Which is easier, to say to the paralytic, ‘Your sins are forgiven,’ or to say, ‘Rise, take up your bed and walk’?” > On 14 Jan 2023, at 6:40 am, Maf. King wrote: >

Re: [GNC] GC 4.9

2023-01-13 Thread Les
Thanks, David.  I'll bid my time. On 1/13/23 17:39, David H wrote: Les, If you mean "4.900" there already is.  Be careful though as it's a beta version and NOT recommended for daily/production use.  So not an upgrade yet.  I'm having issues with it on Ubuntu 22.10 flatpak and Win 10 so

Re: [GNC] GnuCash 4.900 Released

2023-01-13 Thread David H
Hi again John and Devs, I've just updated my Ubuntu 22.10 flatpak to the Gnucash 4.900 beta and am having the same issues as on Win 10. Attached are trace files from each OS in case it helps. Regards David H On Thu, 12 Jan 2023 at 08:25, David H wrote: > Hi John and devs, > > Thanks for the

Re: [GNC] GC 4.9

2023-01-13 Thread David H
Les, If you mean "4.900" there already is. Be careful though as it's a beta version and NOT recommended for daily/production use. So not an upgrade yet. I'm having issues with it on Ubuntu 22.10 flatpak and Win 10 so wouldn't recommend it just yet :-) Cheers David H. On Sat, 14 Jan 2023 at

Re: [GNC] GnuCash 4.900 Released

2023-01-13 Thread David H
I don't know, one of the devs might have an answer for you :-) Cheers David H. On Sat, 14 Jan 2023 at 09:23, Fred Tydeman wrote: > > > On Fri, Jan 13, 2023 at 3:00 PM David H wrote: > >> Yeah seems to be a typo which will cause the remote-add to fail if you >> already have the flathub

Re: [GNC] GnuCash 4.900 Released

2023-01-13 Thread Fred Tydeman
On Fri, Jan 13, 2023 at 3:00 PM David H wrote: > Yeah seems to be a typo which will cause the remote-add to fail if you > already have the flathub repository installed as follows:- > > Wiki says - flatpak remote-add --user --if-not-exists *flathub* >

Re: [GNC] reports not working unless exported [solved]

2023-01-13 Thread Jeff
On 1/13/23 4:30 PM, David H wrote: Jeff, I seem to recall just doing a "Flatpak Update" fixed an issue with blank reports a little while ago - from memory it updated something else but I don't remember the details. So give that a shot and see if it fixes the issue. Cheers David H. On Sat,

[GNC] GC 4.9

2023-01-13 Thread Les
When will there be a Flatpak version for GC 4.9? Thanks, Les ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please

Re: [GNC] Scheduled Transactions Question

2023-01-13 Thread Adrien Monteleone
I had the same problem and I think I solved it by making all of the variables part of a formula, so your transaction would look like: DB Checking TOTALAMT*1 CR Asset TOTALAMT*1 CR Income A TOTALAMT*1 DB Income B TOTALAMT*1 Regards, Adrien On 1/13/23 10:48 AM, David T. via gnucash-user wrote:

Re: [GNC] GnuCash 4.900 Released

2023-01-13 Thread David H
Hi Fred, Yeah seems to be a typo which will cause the remote-add to fail if you already have the flathub repository installed as follows:- Wiki says - flatpak remote-add --user --if-not-exists *flathub* https://flathub.org/beta-repo/flathub-beta.flatpakrepo Should be - flatpak remote-add --user

Re: [GNC] reports not working unless exported

2023-01-13 Thread Jeff
On 1/13/23 4:13 PM, Michael or Penny Novack wrote: I went to generate some reports for the year 2022 and not one of the standard reports will work within GNC now. Explain what you mean by "will not work" Are you having a DATE problem? (you don't know how to specify the effective

Re: [GNC] Scheduled Transactions Question

2023-01-13 Thread Stan Brown (using GC 2.6.19)
That may have been me. I'm running 2.6.19, and I could swear that I tried a scheduled transaction over a year ago, and I got prompted multiple times. When I posted about that again a few days ago, I tried again and found that I had misinterpreted what I was seeing on screen. In fact, GC was

Re: [GNC] Scheduled Transactions Question

2023-01-13 Thread David Carlson
I do recall this same issue came up in another thread and I thought there was already a solution mentioned, but it is really difficult to search for it on a phone . Perhaps someone else remembers where to find it? On Fri, Jan 13, 2023, 12:52 PM David Carlson wrote: > Never mind, I can't read

Re: [GNC] reports not working unless exported

2023-01-13 Thread David H
Jeff, I seem to recall just doing a "Flatpak Update" fixed an issue with blank reports a little while ago - from memory it updated something else but I don't remember the details. So give that a shot and see if it fixes the issue. Cheers David H. On Sat, 14 Jan 2023 at 07:12, Jeff wrote: >

Re: [GNC] reports not working unless exported

2023-01-13 Thread Michael or Penny Novack
I went to generate some reports for the year 2022 and not one of the standard reports will work within GNC now. Explain what you mean by "will not work" Are you having a DATE problem? (you don't know how to specify the effective date(s) for a report?) Michael D Novack

Re: [GNC] Recommended Method of Entry for IRA Distributions

2023-01-13 Thread Michael or Penny Novack
On 1/13/2023 11:48 AM, R Losey wrote: Thanks. The only minor drawback is that I seem to be entering the data twice under "Income" just to keep track of IRA distributions on their own. But hey, it's one way to make it work. And, as has been pointed out, since this is not really "income", it

[GNC] reports not working unless exported

2023-01-13 Thread Jeff
Running: Version: 4.13 Build ID: Flathub 4.13 Finance::Quote: 1.5301 on: Ubuntu 22.04.1 LTS I went to generate some reports for the year 2022 and not one of the standard reports will work within GNC now.  ALL of the reports built into GNC now have to be exported to see them and time wise

[GNC] reports not working unless exported

2023-01-13 Thread Jeff
Running: Version: 4.13 Build ID: Flathub 4.13 Finance::Quote: 1.5301 on: Ubuntu 22.04.1 LTS I went to generate some reports for the year 2022 and not one of the standard reports will work within GNC now.  (Not sure from which version from Flathub this started.)  ALL of the reports built

Re: [GNC] exporting from gnucash to Excel

2023-01-13 Thread Maf. King
On Friday, 13 January 2023 04:45:20 GMT David T. via gnucash-user wrote: > Indeed. > > I don't have to comply with this either, but it seems to me that "pressing a > button" to export to Excel provides exactly the same automated reliability > as CTRL-C/CTRL-V (two buttons, if you will) into

Re: [GNC] exporting from gnucash to Excel

2023-01-13 Thread Maf. King
On Thursday, 12 January 2023 14:05:04 GMT Paul W via gnucash-user wrote: > To submit VAT data to HMRC here in the UK I am obliged to use a method which > is automatic. So I need to find a way to trasnfer the balances from a > couple of accounts to an Excel spreadsheet automatically ie not by

Re: [GNC] Scheduled Transactions Question

2023-01-13 Thread David Carlson
Never mind, I can't read your whole message at once on my phone On Fri, Jan 13, 2023, 12:50 PM David Carlson wrote: > David, > > Which version of GnuCash are you using? > > On Fri, Jan 13, 2023, 10:49 AM David T. via gnucash-user < > gnucash-user@gnucash.org> wrote: > >> Hi, >> >> Gnucash 4.13

Re: [GNC] Scheduled Transactions Question

2023-01-13 Thread David Carlson
David, Which version of GnuCash are you using? On Fri, Jan 13, 2023, 10:49 AM David T. via gnucash-user < gnucash-user@gnucash.org> wrote: > Hi, > > Gnucash 4.13 Windows 10. Long time user. > > I am trying out using a variable in a scheduled transaction for the > first time, and it's not

Re: [GNC] Recommended Method of Entry for IRA Distributions

2023-01-13 Thread R Losey
I suppose a way to handle the "Income but not really income" would be ao follows (see what people think about this): CR - Assets: IRA $1000 DB - Income: IRA Distribution $1000 CR - Income: IRA Distribution $1000 DB - Assets: Checking $1000 This way, the income change is zero, but I can still

Re: [GNC] Recommended Method of Entry for IRA Distributions

2023-01-13 Thread R Losey
Sorry about "category" versus "account" -- I still, after 7 years, have Quicken habits... but I would argue that many people see an "account" as something that has both debits and credits (like a bank account), as opposed to "categories", which, for the most part, only have credits or debits (like

Re: [GNC] Recommended Method of Entry for IRA Distributions

2023-01-13 Thread R Losey
Thanks. The only minor drawback is that I seem to be entering the data twice under "Income" just to keep track of IRA distributions on their own. But hey, it's one way to make it work. And, as has been pointed out, since this is not really "income", it makes sense that the transaction has no net

[GNC] Scheduled Transactions Question

2023-01-13 Thread David T. via gnucash-user
Hi, Gnucash 4.13 Windows 10. Long time user. I am trying out using a variable in a scheduled transaction for the first time, and it's not behaving the way I expect. I am creating a multi-entry transaction that transfers a single amount between two pairs of accounts. in other words: DB

Re: [GNC] exporting from gnucash to Excel

2023-01-13 Thread Thomas Forrester
Scripts can also make redundant tasks less of a burden through hands-off automation. That's what scripts do well, too. I'm seeing a few posts in this topic verging on berating the OP for wanting to do something and asking if there's a way. Maybe you stop second-guessing the OP's needs and

Re: [GNC] Recommended Method of Entry for IRA Distributions

2023-01-13 Thread Mark Penner via gnucash-user
Jan 11, 2023 18:07:03 R Losey : I apologize for not using "debit" and "credit" terms, but I'm not sure I'd get them right. I also have to think a bit sometimes to get them right. As someone(s) said, debits are always on the left, credits on the right. I just remember that money flows

Re: [GNC] exporting from gnucash to Excel

2023-01-13 Thread Liz Dodd
On Fri, 13 Jan 2023 07:45:20 +0300 "David T. via gnucash-user" wrote: > Indeed. > > I don't have to comply with this either, but it seems to me that > "pressing a button" to export to Excel provides exactly the same > automated reliability as CTRL-C/CTRL-V (two buttons, if you will) > into