Re: [GNC] Upgrading to 5.3 from 2.6.15

You should be able to get close. You can see monthly periods, you can 'use accumulated totals' for each month as they progress. (YTD) You can show a yearly 'Totals' column set. For each set (period & total) you can see Budget, Actual, and Variance columns. I don't think it is exactly just

Re: [GNC] strange lack of exchange rates in a new currency cash account

Hi John, It turns out that I had the latest version of GnuCash that's supported by my version of Ubuntu (v3.8b). I installed Flatpak and used it to install GnuCash v5.3. I entered a grocery-store purchase for today, and entered the exchange rate manually as "1/23600." After I completed the

Re: [GNC] Upgrading to 5.3 from 2.6.15

I think we will stay in 4.14 for now. We found the 'use accumulated totals' function under budget reports and it gives us the basic information we need. In Phil's old YTD report you could have a nine column report that showed the current month, YTD and to the end of year, with the budgetted

Re: [GNC] Issue with Finance::Quote

It looks like your Alphavantage.pm got corrupted. Try opening the Strawberry Perl cpan shell and telling it `force install Finance::Quote` to reinstall it. Regards, John Ralls > On Jul 26, 2023, at 04:48, bern...@deprez.biz wrote: > > Hi Ken, > > I tried googleweb and get a response > >

Re: [GNC] Upgrading to 5.3 from 2.6.15

Good to know that you made it to 4.14. As for which version of 5.x to land on, that's up to you. Some folks aren't keen on the changes to the auto-fill for the Description field. (I like it personally) There were certainly kinks in 5.0 and 5.1 in that regard, It seems they have been fixed

Re: [GNC] Upgrading to 5.3 from 2.6.15

We started GnuCash from the shortcut on our desktop. We have now opened the 3.11 files and ran check and repair on them. All looks good. I notice that some people have issues with 5.3. Should we upgrade to 5.1 instead of 5.3? Also once we get into 5.x where do we find the 'Use Accumulated

Re: [GNC] Upgrading to 5.3 from 2.6.15

That sounds like the preferences didn't migrate. We had to change the GSettings schema from org.gnucash to org.gnucash.GnuCash to get preferences to work correctly in flatpak. We did that change in GnuCash 4.7, and there's a function that's supposed to transfer your preferences to the new

Re: [GNC] Upgrading to 5.3 from 2.6.15

That looks like GnuCash thought it wasn't opening your file, but starting a new book. How did you 'start' GnuCash *exactly* after the 4.14 install? Also note, you can click Cancel on that first screen, or if it doesn't show again, and you just get a blank app with either no book or a new

Re: [GNC] Upgrading to 5.3 from 2.6.15

We started the upgrade process from 2.6.15. The upgrade from 2.6.15 to 2.6.21 and from 2.6.21 to 3.11 seemed to go ok but the upgrade from 3.11 to 4.14 sees to have hit a snag. When we open 4.14 we get a dialog box that states: 'There are some predefined actions available that most new users

Re: [GNC] Account Tabs

Thank you, Derek. In this case the jump would be faster, but only because a recent payment caused the zero balance and I accidentally closed the tab at some point. Thank You, Gyle McCollam Gyle McCollam gmccol...@live.com email

Re: [GNC] Account Tabs

You could find a transaction that touches the zero balance account and then click "jump" to open it.. But the off/select/on us probably faster. -derek Sent using my mobile device. Please excuse any typos. On July 26, 2023 18:43:20 Gyle McCollam wrote: If my accounts page view does not show

[GNC] Account Tabs

If my accounts page view does not show zero balance accounts, but I want to open a zero-balance account is there a way to do this without changing the view, opening, and the changing the view back? Thank You, Gyle McCollam Gyle McCollam gmccol...@live.com

Re: [GNC] Upgrading to 5.3 from 2.6.15

On Wed, 26 Jul 2023 at 13:31, john wrote: > Yeah, it's gotten a lot faster since... > GnuCash V5.2 ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe:

Re: [GNC] Split Payments?

It is possible dating may play a role if A is indeed earlier than B, but I'm not certain. If that is the case, then you'll have to make a payment for the full amount as planned (1/4*A+B) but only choose Invoice B to apply it to. This will leave an unlinked over/pre-payment attached to that

Re: [GNC] GnuCash 5.3 autofill headaches

I'm not usually in the habit of shutting down GnuCash often, but I'll give it a few cycles and see what happens. So far, any new memos started to auto-fill for subsequent transactions. It might be linked to the key sequence when selecting a match for Description (Tab vs. Enter) but I haven't

Re: [GNC] GnuCash 5.3 autofill headaches

Still sitting on 5.1 because of this issue, Keep us posted on what you think is happening. Thanks David H. On Thu, 27 Jul 2023 at 06:56, R Losey wrote: > On Wed, Jul 26, 2023 at 2:07 PM Adrien Monteleone < > adrien.montele...@lusfiber.net> wrote: > > > On 6/30/23 10:31 AM, Adrien Monteleone

Re: [GNC] GnuCash 5.3 autofill headaches

On Wed, Jul 26, 2023 at 2:07 PM Adrien Monteleone < adrien.montele...@lusfiber.net> wrote: > On 6/30/23 10:31 AM, Adrien Monteleone wrote: > > On 6/30/23 6:04 AM, David H wrote: > >> I've just reverted to 5.1 on both MacOS and Windows because I have > >> found it > >> more time consuming to

[GNC] Split Payments?

I'm fairly new to using the Accounts Payable function. I have a vendor which is owed two invoices, one larger one which she has agreed to accept four monthly payments on plus one smaller invoice which I wanted to pay up front right now. I made a payment for 1/4*A + B, but when I attempted to

Re: [GNC] Scheduled Transaction - Loan Amortization

That stuff is explained in great detail somewhere on the GnuCash website but I am on my cellphone and unable to sesrch for it. On Wed, Jul 26, 2023, 2:17 PM Stephen M. Butler wrote: > GnC appears to keep track of the number of months and updates it without > any intervention on my end. > >

Re: [GNC] Scheduled Transaction - Loan Amortization

Stephen, Thanks for the example, I will give it a try. Thank You, Gyle McCollam Gyle McCollam gmccol...@live.com email From: Steve Butler on behalf of Stephen M. Butler Sent: Wednesday, July 26, 2023 3:17 PM To:

Re: [GNC] Scheduled Transaction - Loan Amortization

Not sure how GnC does it.  I do nothing. Stephen M Butler stephen.m.butle...@gmail.com kg...@arrl.net 253-350-0166 --- GnuPG Fingerprint: 8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8 On 7/26/23 12:12, Gyle McCollam wrote: Stephen, How does Gnucash

Re: [GNC] Scheduled Transaction - Loan Amortization

GnC appears to keep track of the number of months and updates it without any intervention on my end. Stephen M Butler stephen.m.butle...@gmail.com kg...@arrl.net 253-350-0166 --- GnuPG Fingerprint: 8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8 On

Re: [GNC] Scheduled Transaction - Loan Amortization

Stephen, How does Gnucash update the "i" value each month or do you have to do that manually? Thank You, Gyle McCollam Gyle McCollam gmccol...@live.com email From: gnucash-user on behalf of Stephen M. Butler

Re: [GNC] Scheduled Transaction - Loan Amortization

How does Gnucash update the "i" value each month or do you have to adjust manually? Thank You, Gyle McCollam Gyle McCollam gmccol...@live.com email From: gnucash-user on behalf of Stephen M. Butler Sent:

Re: [GNC] GnuCash 5.3 autofill headaches

On 6/30/23 10:31 AM, Adrien Monteleone wrote: On 6/30/23 6:04 AM, David H wrote: I've just reverted to 5.1 on both MacOS and Windows because I have found it more time consuming to manually type the full description on 3 or 4 split lines that I've used previously in the same txn type. If

Re: [GNC] Cannot write to file

Do you have enough disk space as the message suggests? The 'file' is a report? What *exactly* were you trying to do when you got the message? Regards, Adrien On 7/26/23 5:29 AM, Mahon Finbar via gnucash-user wrote: I have a message - "Could not write to file C: xxx check that you have

Re: [GNC] Check all

On Wed, Jul 26, 2023 at 5:50 AM Christopher Lam wrote: > On Wed, 26 Jul 2023 at 11:32, john wrote: > > > Yeah, it's gotten a lot faster since Chris Lam figured out it was > checking > > every transaction for every split in the transaction and fixed it to only > > traverse the transactions once.

Re: [GNC] Scheduled Transaction - Loan Amortization

Here are the entries (3 splits) I use on my scheduled transaction: Split 1:    Assets:Checking:xxx    Credit -- $326.97   (payment comes from checking account) Split 2:    Liabilities:Loans:yyy Debit -- 326.97 - ipmt( .04490 / 12.00 : i -2: 240.00 : 51,630.34 : 0 : 0 ) Split 3:  

Re: [GNC] Scheduled Transaction - Loan Amortization

There are pmt, ppmt, and ipmt functions. -derek Sent using my mobile device. Please excuse any typos. On July 25, 2023 15:41:01 Gyle McCollam wrote: Is there a formula I can enter in SX that will automatically calculate the principal or interest payment on a car loan? Then is there a way to

Re: [GNC] GnuCash preferred OS - Windows or Linux

I am a staunch Linux user, and came from the Quickbooks world as well. I am running a very small database, but have it in the sqlite, since that (for me) is very easy to work inside of if i need to poke around in the database (which I do). I much prefer the 'double entry' approach to things

Re: [GNC] GnuCash preferred OS - Windows or Linux

Welcome to GNC. I am on Windows 11 platform where I seem to find it that I get into less of troubles when it comes to getting it installed and, up and running. I have been versed in all three platforms (Windows, Linux and Mac) but I find it easier to work with it in Windows. There are some

Re: [GNC] Issue with Finance::Quote

Hi Ken, I tried googleweb and get a response C:\Program Files (x86)\gnucash\bin>gnucash-cli -Q dump googleweb QQQ Finance::Quote fields GnuCash uses:     symbol: QQQ <=== required   date: 07/25/2023  <=== recommended   currency: USD <=== required   last:

[GNC] Cannot write to file

I have a message - "Could not write to file C: xxx check that you have permission to write to this file and there is sufficient space to create it" The file is a report of annual P that I have open , but I am not working on it What is the problem?? Thanks Barry

Re: [GNC] Upgrading to 5.3 from 2.6.15

On Wed, 26 Jul 2023 at 11:32, john wrote: > Yeah, it's gotten a lot faster since Chris Lam figured out it was checking > every transaction for every split in the transaction and fixed it to only > traverse the transactions once. > This was only 1 part of the speedup: each typical (2 or more

Re: [GNC] GnuCash 'Help' returns "Dcoument not found" but I have gnucash-docs installed

On Wed, Jul 26, 2023 at 12:29:18AM +0200, Frank H. Ellenberger wrote: > > > I seem to recall reading in these lists that it's a matter of Linux putting > > the documents in a different place than where GnuCash is looking... I'm > > assuming that there is a way to fix this with a symbolic link (or