Re: [GNC] Fractional Hours?

2020-07-01 Thread Adrien Monteleone
Sorry, I see that now. If it was working before, then this would be a change in the report's code. A bug report on GnuCash’s Bugzilla would be in order. In the meantime, you could download and ‘borrow’ the report from a previous version that worked. If you update before it is fixed, you’ll

Re: [GNC] Bulk moving transactions

2020-07-01 Thread D. via gnucash-user
Ah. I misread your original post. Having used GnuCash for over 15 years now, I am quite familiar with editing accounts, thank you. Still, editing a bunch of accounts seems like more complication than just editing the transactions themselves. I guess I assume that because a month of credit

Re: [GNC] Fractional Hours?

2020-07-01 Thread Andrew Clark
Sorry, I misspoke in my previous. That setting is already in place, but this isn't a price. It's an actual amount that really should be decimal. Saying I'm billing for 171/2 hours work is confusing. It shows in both the Tax Invoice report and the Australian Tax Invoice report. On Thu, 2 Jul

Re: [GNC] Bulk moving transactions

2020-07-01 Thread Vinayak Vatsal via gnucash-user
Thanks for your help. Nike > On Jun 30, 2020, at 2:21 PM, Derek Atkins wrote: > > Hi, > >> On Tue, June 30, 2020 4:46 pm, V. Vatsal via gnucash-user wrote: >> Hello, >> >> I am running GnuCash on Mac. >> >> Somehow a month’s worth of credit card transactions ended up in the top >> level

Re: [GNC] Bulk moving transactions

2020-07-01 Thread Michael or Penny Novack
On 7/1/2020 6:30 PM, D. wrote: Of course, once you've edited every transaction to put it into a child account, you could have just changed them all to their proper account altogether, and eliminated the entire account delete set of steps... ??   I wasn't talking about editing ANY

Re: [GNC] Fractional Hours?

2020-07-01 Thread Andrew Clark
That setting is in place. This is showing up under the hours column for an invoice, a dollar amount, not a fraction display in a conversion. On Tue, 23 Jun 2020 at 10:25, Adrien Monteleone < adrien.montele...@lusfiber.net> wrote: > Check Preferences > General > Numbers > Force prices to display

Re: [GNC] Register entry method. was: Bulk moving transactions

2020-07-01 Thread David Carlson
Around 10 years ago I experimented with a competitive product to GnuCash called "MyMoney" produced by MTH Software. It was (is) based on a database format. The primary register view had a large area at the bottom of the main window that served as the data entry window, and contained as many

Re: [GNC] Error retrieving price quotes

2020-07-01 Thread John Ralls
> On Jul 1, 2020, at 10:17 AM, John Haiducek wrote: > > When I try to fetch prices I get the error "There was a system error while > retrieving the price quotes". No error message is printed to the console. > > gnc-fq-dump is able to fetch quotes successfully. > > I'm running gnucash 3.10

Re: [GNC] Bulk moving transactions

2020-07-01 Thread D. via gnucash-user
Of course, once you've edited every transaction to put it into a child account, you could have just changed them all to their proper account altogether, and eliminated the entire account delete set of steps... Original Message From: Michael or Penny Novack Sent: Wed Jul 01

Re: [GNC] Bulk moving transactions

2020-07-01 Thread Stan Brown
I can attest to the joy of initiating a search while in the Accounts tab. It's quite fast, and opens up a new tab for results, so the Accounts tab is unaffected. (I used to do searches in General Ledger when I wasn't sure which account held my desired results. But those searches did NOT open a

Re: [GNC] Register entry method. was: Bulk moving transactions

2020-07-01 Thread Michael or Penny Novack
On 7/1/2020 5:24 PM, David Carlson wrote: Maybe I don't know the correct terminology. I envision the currently selected transaction automatically appearing in a data entry window instead of in the register. What do you see when you are entering a "split" transaction? That is a "view" you

Re: [GNC] Bulk moving transactions

2020-07-01 Thread David H
Adrien, Thanks for the heads up - hadn't noticed it until you asked the question - yes that's exactly what I need !!! Cheers David H. On Thu, 2 Jul 2020 at 07:18, Adrien Monteleone < adrien.montele...@lusfiber.net> wrote: > In the meantime, why not search from the Accounts tab? (you can also

Re: [GNC] Register entry method. was: Bulk moving transactions

2020-07-01 Thread David Carlson
Sorry, I didn't expect my comment to turn into a discussion. Therefore I am splitting it off of the original thread On Wed, Jul 1, 2020 at 4:14 PM David Carlson wrote: > Maybe I don't know the correct terminology. I envision the currently > selected transaction automatically appearing in a

Re: [GNC] Bulk moving transactions

2020-07-01 Thread David Carlson
Maybe I don't know the correct terminology. I envision the currently selected transaction automatically appearing in a data entry window instead of in the register. On Wed, Jul 1, 2020 at 4:09 PM Derek Atkins wrote: > Popups are a very inefficient entry method. > > You already have the Ctrl-T

[GNC] Transcation Search & Replace

2020-07-01 Thread listsub3
Is there any functionality to do bulk search & replace on transactions?  My old 2002 Quicken had this feature and it was really useful to do bulk changes/corrections. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription

Re: [GNC] Bulk moving transactions

2020-07-01 Thread Adrien Monteleone
In the meantime, why not search from the Accounts tab? (you can also refine searches either iteratively, or with multiple criteria) Regards, Adrien > On Jul 1, 2020 w27d183, at 4:03 PM, David H wrote: > > While you're at it can you add a search history so when I try to find > something under

Re: [GNC] Bulk moving transactions

2020-07-01 Thread Derek Atkins
Popups are a very inefficient entry method. You already have the Ctrl-T (Enter Transfer) popup if you really want to use pop-ups for entry. -derek On Wed, July 1, 2020 5:05 pm, David Carlson wrote: > Back around the time the register2 rewrite was started I believe that I > suggested replacing

Re: [GNC] Bulk moving transactions

2020-07-01 Thread David Carlson
Back around the time the register2 rewrite was started I believe that I suggested replacing the complex register code with a basic data input pop-up window for the selected transaction or other input requirement such as stock purchase, or business feature more like one would likely find in a

Re: [GNC] Bulk moving transactions

2020-07-01 Thread David H
While you're at it can you add a search history so when I try to find something under 1 credit card without luck and then go to another register to re-run the exact same search - would be handy :-) Cheers David H. On Thu, 2 Jul 2020 at 06:38, Jean Laroche wrote: > I started looking at that a

Re: [GNC] Bulk moving transactions

2020-07-01 Thread Jean Laroche
I started looking at that a little while before 4.0 and stopped because no new features could be added. I'm going to re-start, as this strikes me as a must-have feature. The other elephant in the room is the undo/redo support, but that's for another thread J. On 7/1/20 1:32 PM, Derek

Re: [GNC] Bulk moving transactions

2020-07-01 Thread Derek Atkins
On Wed, July 1, 2020 4:27 pm, Jean Laroche wrote: > Does it not trike you as insane that we have to go through these hoops > just to bulk move transactions? Something that should be as simple as > shift-select, right-click, move? > I'm not sure how support for multi-select operations was never

Re: [GNC] Bulk moving transactions

2020-07-01 Thread Jean Laroche
Does it not trike you as insane that we have to go through these hoops just to bulk move transactions? Something that should be as simple as shift-select, right-click, move? I'm not sure how support for multi-select operations was never seriously looked at. J. On 7/1/20 1:09 PM, Adrien

Re: [GNC] Bulk moving transactions

2020-07-01 Thread Adrien Monteleone
Sorry Michael, it was an oversight. I was not reading carefully. Geert pointed that out to me as well. Apologies for the noise. Regards, Adrien > On Jul 1, 2020 w27d183, at 2:56 PM, Michael or Penny Novack > wrote: > > On 7/1/2020 12:07 PM, Adrien Monteleone wrote: >> I’ve twice now seen

Re: [GNC] Bulk moving transactions

2020-07-01 Thread Michael or Penny Novack
On 7/1/2020 12:07 PM, Adrien Monteleone wrote: I’ve twice now seen the advice to delete the account as a bulk move operation. Yes, that does work. However, this appears to be a parent account. Can a parent account be safely deleted without affecting the sub accounts? I guess I could try,

Re: [GNC] Session Error: failed to get_backend using access method "C"

2020-07-01 Thread Lipp F.
Not for me. Getting another error now. C:\tools\gnucash\bin>gnucash-cli.exe --debug --report run --name="Net Worth Linechart" --output-file=r-nwl.html 'sqlite3://C:\Users\**\Downloads\gnuCash-test-2\t14.sqlite3.gnucash' * 14:46:12 INFO [gnc_module_init_backend_dbi] GNC_DBD_DIR not set:

Re: [GNC] Session Error: failed to get_backend using access method "C"

2020-07-01 Thread Chris Graves
Sorry, my bad. I can duplicate your failure. Does look like a bug. However, this works: 'C:\Program Files (x86)\gnucash\bin\gnucash-cli.exe' --report run --name='Net Worth Linechart' --output=rpt.html 'sqlite3://C:\Users\chris\Documents\sqlite.gnucash' On Wed, Jul 1, 2020 at 9:56 AM Lipp F.

[GNC] Error retrieving price quotes

2020-07-01 Thread John Haiducek
When I try to fetch prices I get the error "There was a system error while retrieving the price quotes". No error message is printed to the console. gnc-fq-dump is able to fetch quotes successfully. I'm running gnucash 3.10 with Finance::Quote 1.47 on Fedora 32. John

Re: [GNC] Session Error: failed to get_backend using access method "C"

2020-07-01 Thread Lipp F.
As long as the path to the book file does not have a directory, everything works fine. I mentioned that in an earlier message. On Wed, Jul 1, 2020 at 12:30 PM Chris Graves wrote: > Just as a point of reference, running the report on Win 10 from Powershell > works fine for me with GC files of

Re: [GNC] Bulk moving transactions

2020-07-01 Thread Adrien Monteleone
Ah, missed that, thanks! Regards, Adrien > On Jul 1, 2020 w27d183, at 11:27 AM, Geert Janssens > wrote: > > Op woensdag 1 juli 2020 18:07:16 CEST schreef Adrien Monteleone: > > I’ve twice now seen the advice to delete the account as a bulk move > > operation. > > > > Yes, that does work. > >

Re: [GNC] Customer Report - Account Receivable

2020-07-01 Thread Christopher Lam
On Thu, 2 Jul 2020, 12:28 am Geert Janssens, wrote: > Op woensdag 1 juli 2020 18:02:35 CEST schreef Adrien Monteleone: > In practice the most common use case for multiple AR accounts is as Frank > pointed out: you can > have one per currency you do business in. In that case you post invoices >

Re: [GNC] Session Error: failed to get_backend using access method "C"

2020-07-01 Thread Lipp F.
This works fine in 3.10: D:\>d:\tools\gnucash\bin\gnucash.exe "D:\Data\Banking\GnuCash\t14.sqlite3.gnucash" On Wed, Jul 1, 2020 at 12:28 PM Geert Janssens wrote: > Op woensdag 1 juli 2020 18:21:03 CEST schreef Lipp F.: > > > I have 3.10 installed and there is no gnucash-cli in this release.

Re: [GNC] Session Error: failed to get_backend using access method "C"

2020-07-01 Thread Chris Graves
Just as a point of reference, running the report on Win 10 from Powershell works fine for me with GC files of XML and Sqlite3. 'C:\Program Files (x86)\gnucash\bin\gnucash-cli.exe' --report run --name='Net Worth Linechart' --output=rpt.html sqlite.gnucash Chris On Wed, Jul 1, 2020 at 9:20 AM

Re: [GNC] Session Error: failed to get_backend using access method "C"

2020-07-01 Thread Geert Janssens
Op woensdag 1 juli 2020 18:21:03 CEST schreef Lipp F.: > I have 3.10 installed and there is no gnucash-cli in this release. What do > you want me to test? > Reread my examples. They try to load files in gnucash.exe instead of gnucash-cli.exe :) Regards, Geert > On Wed, Jul 1, 2020 at 12:18 PM

Re: [GNC] Bulk moving transactions

2020-07-01 Thread Geert Janssens
Op woensdag 1 juli 2020 18:07:16 CEST schreef Adrien Monteleone: > I’ve twice now seen the advice to delete the account as a bulk move > operation. > > Yes, that does work. > > However, this appears to be a parent account. > > Can a parent account be safely deleted without affecting the sub

Re: [GNC] Customer Report - Account Receivable

2020-07-01 Thread Adrien Monteleone
Thanks for the clarification. Regards, Adrien > On Jul 1, 2020 w27d183, at 11:25 AM, Geert Janssens > wrote: > > Op woensdag 1 juli 2020 18:02:35 CEST schreef Adrien Monteleone: > > Apologies, > > > > My understanding of the Business Features was that there is one Accounts > > Receivable

Re: [GNC] Customer Report - Account Receivable

2020-07-01 Thread Geert Janssens
Op woensdag 1 juli 2020 18:02:35 CEST schreef Adrien Monteleone: > Apologies, > > My understanding of the Business Features was that there is one Accounts > Receivable account of *type* ‘Accounts Receivable’ and there can be only > one account of that type, and that the Business Features are not

Re: [GNC] Session Error: failed to get_backend using access method "C"

2020-07-01 Thread Lipp F.
I have 3.10 installed and there is no gnucash-cli in this release. What do you want me to test? On Wed, Jul 1, 2020 at 12:18 PM Geert Janssens wrote: > Op woensdag 1 juli 2020 17:52:48 CEST schreef Lipp F.: > > > It is a bug indeed. Standard Windows path works fine in some parts of the > > >

Re: [GNC] Session Error: failed to get_backend using access method "C"

2020-07-01 Thread Geert Janssens
Op woensdag 1 juli 2020 17:52:48 CEST schreef Lipp F.: > It is a bug indeed. Standard Windows path works fine in some parts of the > code but not everywhere. You can see the book file loaded and identified as > sqlite3. See logs below. > While the logs may lead to that conclusion I'm not so sure

Re: [GNC] Session Error: failed to get_backend using access method "C"

2020-07-01 Thread Lipp F.
I have this version installed as well Version: 3.10 Build ID: 3.10+(2020-04-11) Finance::Quote: 1.49 What shall I check? On Wed, Jul 1, 2020 at 11:52 AM Lipp F. wrote: > It is a bug indeed. Standard Windows path works fine in some parts of the > code but not everywhere. You can see the book

Re: [GNC] Bulk moving transactions

2020-07-01 Thread Adrien Monteleone
I’ve twice now seen the advice to delete the account as a bulk move operation. Yes, that does work. However, this appears to be a parent account. Can a parent account be safely deleted without affecting the sub accounts? I guess I could try, just for kicks, (since I’m not the one needing to

Re: [GNC] Customer Report - Account Receivable

2020-07-01 Thread Adrien Monteleone
Apologies, My understanding of the Business Features was that there is one Accounts Receivable account of *type* ‘Accounts Receivable’ and there can be only one account of that type, and that the Business Features are not cognizant of ‘other Accounts Receivable’ accounts of type ‘asset’, and

Re: [GNC] Session Error: failed to get_backend using access method "C"

2020-07-01 Thread Lipp F.
It is a bug indeed. Standard Windows path works fine in some parts of the code but not everywhere. You can see the book file loaded and identified as sqlite3. See logs below. C:\tools\gnucash\bin>gnucash-cli.exe --debug --report run --name="Net Worth Linechart" --output-file=r-nwl.html

Re: [GNC] Session Error: failed to get_backend using access method "C"

2020-07-01 Thread Geert Janssens
Ok, this does look like a bug. Just to estimate the scope, can you open the data file in gnucash from the command line ? That is, does C:\tools\gnucash\bin>gnucash.exe /C/Users/*/Downloads/gnuCash-test-2/ t14.sqlite3.gnucash or C:\tools\gnucash\bin>gnucash-cli.exe

Re: [GNC] Auto reconcile on OFX Import

2020-07-01 Thread jean laroche
ah ah ah! No worries man! On 7/1/2020 5:31 AM, Matthew Forbis wrote: I found it right where you said.  It turns out when I thought I had already upgraded to 4.0, I had downloaded the installer, but not gone through the installation.  I was still running one of the testing releases that

Re: [GNC] Session Error: failed to get_backend using access method "C"

2020-07-01 Thread Lipp F.
Still not working, different error though. Tried uppercase C and lowercase c as well: C:\tools\gnucash\bin>gnucash-cli.exe --report run --name="Net Worth Linechart" --output-file=r-nwl.html /C/Users/*/Downloads/gnuCash-test-2/t14.sqlite3.gnucash * 11:16:08 WARN

Re: [GNC] Bulk moving transactions

2020-07-01 Thread Michael or Penny Novack
On 6/30/2020 4:46 PM, V. Vatsal via gnucash-user wrote: Hello, I am running GnuCash on Mac. Somehow a month’s worth of credit card transactions ended up in the top level Bank Accounts account. Is there some quick way to move or edit them to the appropriate credit card account? It’s not

Re: [GNC] Customer Report - Account Receivable

2020-07-01 Thread Geert Janssens
Op dinsdag 30 juni 2020 01:43:56 CEST schreef Vance Turnewitsch: > Good evening, > First off, thank-you to everyone who contributes to this software! > Due to a motherboard burn out, I booted up an old laptop and downloaded > GnuCash 4.0 on it. Build ID: 4.0+(2020-06-27 > > On my other computer,

Re: [GNC] Session Error: failed to get_backend using access method "C"

2020-07-01 Thread Geert Janssens
Op woensdag 1 juli 2020 15:08:29 CEST schreef Lipp F.: > Hi everyone, > > Just evaluating 4.0 on Windows 10, sqlite3 backend, before a full switch. I > have noticed that gnucash-cli.exe does not seem to work: > > C:\tools\gnucash\bin>gnucash-cli.exe --debug --quotes get > ... >

Re: [GNC] Bulk moving transactions

2020-07-01 Thread Frank H. Ellenberger
HI, Am 30.06.20 um 22:46 schrieb V. Vatsal via gnucash-user: > Somehow a month’s worth of credit card transactions ended up in the top level > Bank Accounts account. Is there some quick way to move or edit them to to avoid this in the future, you should consider to mark this account as

Re: [GNC] Customer Report - Account Receivable

2020-07-01 Thread Frank H. Ellenberger
Hi, Am 30.06.20 um 15:20 schrieb Adrien Monteleone: > What account other than the official AR account are you trying to select? there is no "official AR account". If you are invoicing in multiple currencies, you should have one per currency. Regards Frank

[GNC] Session Error: failed to get_backend using access method "C"

2020-07-01 Thread Lipp F.
Hi everyone, Just evaluating 4.0 on Windows 10, sqlite3 backend, before a full switch. I have noticed that gnucash-cli.exe does not seem to work: C:\tools\gnucash\bin>gnucash-cli.exe --debug --quotes get ... * 08:54:19 INFO [QofSessionImpl::load_backend] The provider providers

Re: [GNC] Auto reconcile on OFX Import

2020-07-01 Thread Matthew Forbis via gnucash-user
I found it right where you said.  It turns out when I thought I had already upgraded to 4.0, I had downloaded the installer, but not gone through the installation.  I was still running one of the testing releases that didn't have the option.  As soon as I upgraded, it showed up. Shame on me