[GNC] Budgeting glitch after upgrading to 4.14

2023-07-27 Thread larry johnston
We just finished upgrading from 2.6.15 to 4.14 in Windows 10. Our budget has a glitch. In the bottom rows the Income, Expenses, Transfer and Remaining to Budget rows all read zeros. In 2.6.15 they totalled Income and Expenses and showed if there was something over or under budgeted in the Total

[GNC] Follow Up: Split Payments, was Re: gnucash-user Digest, Vol 244, Issue 64

2023-07-27 Thread Eric H Bowen via gnucash-user
I tried to follow your suggestions below, first entering a reversing transaction to clear my earlier entry. Then I applied the payment to invoice B, which left a "payment imbalance." I couldn't figure out a way to apply that to Invoice A directly. Of course, it may be there and I'm just

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

2023-07-27 Thread Scott Ellsworth
Hi John, Okay, thanks again. Be Well, Scott Scott Ellsworth || +1 (775) 386-2519 - Original message - From: john To: Scott Ellsworth Cc: GnuCash user forum Subject: Re: [GNC] strange lack of exchange rates in a new currency cash account Date: Thursday, July 27, 2023 23:09

Re: [GNC] Construction Billing By Project

2023-07-27 Thread NoobAlice
On 7/27/23 3:43 AM, Angela Haggerty wrote: Firstly, it's past 3 AM and I am arguing with myself on how to enter construction projects into GNUCash for a bookkeeping LLC client. Currently people tend to "tag" transactions by putting @job1 in the description of any transaction that affects Job

Re: [GNC] Question about billing

2023-07-27 Thread Angela Haggerty via gnucash-user
I think I understand your question. I work with several CPA's and lawyers in my area primarily in taxes as an Enrolled agent. However I do a lot of bookkeeping and corporate maintenance as well. Please forgive me if I break this down too much, or cover steps you already know, I just want to be

Re: [GNC] Account Tabs

2023-07-27 Thread David Carlson
I didn't realize that it is so easy to click View > Filter By > then do all sorts of things to hide or show as limited a selection of accounts as my heart desires, then wash, rinse and repeat... On Thu, Jul 27, 2023 at 2:01 PM R Losey wrote: > On Wed, Jul 26, 2023 at 7:42 PM Gyle McCollam

Re: [GNC] Issue with Finance::Quote

2023-07-27 Thread Bruce Schuck
On 7/27/23 10:46 AM, bern...@deprez.biz wrote: Just gave that a shot: C:\Strawberry\cpan\build\Finance-Quote-1.57-0>perl Examples\stockdump.pl alphavantage QQQ Can't use an undefined value as a HASH reference at C:/Strawberry/perl/site/lib/Finance/Quote/AlphaVantage.pm line 234. You left

Re: [GNC] Windows 11 GnuCash 4.14 vs 5.3

2023-07-27 Thread R Losey
On Thu, Jul 27, 2023 at 12:05 PM larry johnston wrote: > We have just upgraded from 2.6.15 to 4.14. We are trying to decide if we > should go to 5.3. We use GnuCash only for basic home finances. An important > feature that we want to use is the 'use accumulated totals' in our > budget reports.

Re: [GNC] Issue with Finance::Quote

2023-07-27 Thread John Ralls
Try this: Open a Strawberry Perl shell, and run C:\Windows>set ALPHAVANTAGE_API_KEY=A1B2C3D4E5 C:\Windows>c:\Strawberry\cpan\build\Finance-Quote-1.57-0\Examples\stockdump.pl alphavantage QQQ If you still get the "Can't get an undefined value" error you have good reason to open an issue at

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

2023-07-27 Thread R Losey
On Thu, Jul 27, 2023 at 2:59 AM Ben Kamen wrote: > On 7/25/23 9:31 PM, R Losey wrote: > > > > I'm not afraid of compiling stuff (I design FPGAs and regularly have to > write the Linux Kernel drivers for my FPGA device designs and then the > userland software to drive it. Oy!) > > but I do like

Re: [GNC] Account Tabs

2023-07-27 Thread R Losey
On Wed, Jul 26, 2023 at 7:42 PM Gyle McCollam wrote: > 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? > I don't know any easy way... I just

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

2023-07-27 Thread Kalpesh Patel
GNC uses single matcher engine for all imports which I must say is very, very good. Once it is trained up, it should suggest to put things into right buckets as the contra side of the transaction. There also ability to add, update, ignore and reconcile for each transaction imported via ofx/qfx

Re: [GNC] Issue with Finance::Quote

2023-07-27 Thread Bruce Schuck
On 7/27/23 10:37:17 -0400, Bernard wrote: Thanks for that suggestion - did that on 2 different Windows systems, both still fail the same way... C:\Program Files (x86)\gnucash\bin>gnucash-cli -Q dump alphavantage QQQ * 10:21:02 ERROR [parse_quotesource_error()] Unrecognized Finance::Quote

[GNC] Windows 11 GnuCash 4.14 vs 5.3

2023-07-27 Thread larry johnston
We have just upgraded from 2.6.15 to 4.14. We are trying to decide if we should go to 5.3. We use GnuCash only for basic home finances. An important feature that we want to use is the 'use accumulated totals' in our budget reports. This feature is available in 4.14 so we have stopped there. What

Re: [GNC] Upgrading to 5.3 from 2.6.15

2023-07-27 Thread larry johnston
Thanks. I have to put this project onhold for a while. Fortunately 'use accumulated totals' gives me the basics that I need and the rest is gravy if I can get it. Larry On Thu, Jul 27, 2023 at 9:43 AM Adrien Monteleone < adrien.montele...@lusfiber.net> wrote: > Note, I did some testing this

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

2023-07-27 Thread Adrien Monteleone
GnuCash won't let you make 'double entry errors'. It helpfully forces all transactions to balance. It does this by automatically creating a split assigned to either the Imbalance or Orphan accounts if you fail to balance the transaction properly and commit it anyway. (I don't recall the rules

Re: [GNC] Construction Billing By Project

2023-07-27 Thread Adrien Monteleone
That sounds outside of GnuCash's scope, but I could be mistaken. You might fare better with less stress finding a solution with a different software package for billing, and then import the resulting invoices in GnuCash for accounting and AR management. *note, 'Jobs' in GnuCash are really

Re: [GNC] Upgrading to 5.3 from 2.6.15

2023-07-27 Thread Adrien Monteleone
Note, I did some testing this morning and it seems there might be a bug in how the 'include collapsed periods after selected' works. Follow along here or subscribe to the bug: https://bugs.gnucash.org/show_bug.cgi?id=799046 If this can be resolved, you should be able to get close, but not

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

2023-07-27 Thread john
Scott, Aha! Yes, I recall some bug fixes around pricing and VND in particular in the last couple of years. Ubuntu updates application versions only at releases, so if you want to keep up with GnuCash that way you have to upgrade every April and October. You could switch to Debian Testing,

Re: [GNC] Cannot write to file

2023-07-27 Thread Fred Bone
On 26 July 2023 at 12:29, Mahon Finbar said: > 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

Re: [GNC] Issue with Finance::Quote

2023-07-27 Thread bern...@deprez.biz
Thanks for that suggestion - did that on 2 different Windows systems, both still fail the same way... C:\Program Files (x86)\gnucash\bin>gnucash-cli -Q dump alphavantage QQQ * 10:21:02 ERROR [parse_quotesource_error()] Unrecognized Finance::Quote Error Can't use an undefined value as a HASH

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

2023-07-27 Thread Doug
On Thu, 27 Jul 2023 03:14:07 -0500 my 2c worth: I have been running Gnucash on PCLinuxOS forever (or so it seems). They are usually up to date with releases. Currently Build ID: 5.3+(2023-06-26). Loaded weeks ago. Love both Gnucash, & PCLinuxOS: they both just work! Only thing I could have

Re: [GNC] Cannot write to file

2023-07-27 Thread Mahon Finbar via gnucash-user
The problem is I don't know): I suspect that I may have placed something on the keyboard, as you do when one is dealing with accounts); I think from the look at what happens when I click the link, a folder opens with the gnu set of files in it, headed (delete), that I opened some sort of gnu

[GNC] Construction Billing By Project

2023-07-27 Thread Angela Haggerty
Firstly, it's past 3 AM and I am arguing with myself on how to enter construction projects into GNUCash for a bookkeeping LLC client. This may have been asked before but I did not find it in the search of terms I used. This may not be the proper place to post feature ideas but again it's 3 AM and

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

2023-07-27 Thread Ben Kamen
On 7/26/23 7:55 AM, Mark at Lorimark wrote: 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). Which

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

2023-07-27 Thread Ben Kamen
On 7/26/23 7:37 AM, Kalpesh Patel wrote: 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

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

2023-07-27 Thread Ben Kamen
On 7/25/23 10:03 PM, Adrien Monteleone wrote: In addition to what R Losey mentioned, I'll add that while GnuCash can use MySQL, Postgres, or SQLite as an optional backend, it is not yet a true db application. For now, that is just a storage mechanism. Everything is loaded into RAM and edited

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

2023-07-27 Thread Ben Kamen
On 7/25/23 9:31 PM, R Losey wrote: Ben, welcome! Thanks! I have macOS, Linux (Ubuntu 22.04LTS), and Windows 10.  I love the fact that GnuCash runs on all these platforms; I have my data stored on a mirrored external drive, so all computers can see it. As an OS, I like Linux the best.

Re: [GNC] Upgrading to 5.3 from 2.6.15

2023-07-27 Thread larry johnston
Thanks, I will see what I can make of it. Larry On Wed, Jul 26, 2023, 9:48 p.m. Adrien Monteleone < adrien.montele...@lusfiber.net> wrote: > 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