Re: [GNC] edit --> find --> description contains fails to show accounts receivable items

2022-06-09 Thread Adrien Monteleone
Interesting, I've never noticed it work that way. Regards, Adrien On 6/8/22 10:12 PM, Liz Dodd wrote: On Wed, 8 Jun 2022 21:25:54 -0500 Adrien Monteleone wrote: You don't need to 'select' an account before doing a search. (it has no bearing on the search at all) Always conduct searches

Re: [GNC] edit --> find --> description contains fails to show accounts receivable items

2022-06-08 Thread Adrien Monteleone
You don't need to 'select' an account before doing a search. (it has no bearing on the search at all) Always conduct searches when viewing the main accounts tab, and if you want to specify accounts, do that in your search criteria. Regards, Adrien On 6/6/22 10:30 AM, John Griessen wrote:

Re: [GNC] Problems accessing anything on gnucash website

2022-06-07 Thread Adrien Monteleone
Eric, Please always 'reply-to-list' or 'reply-all' and always send new messages to the list address rather than to individual users. This keeps the discussion on the list for all to see so anyone can help out, and others might benefit from the suggestions. As to your question, I'm not sure

Re: [GNC] Export as text or CSV

2022-06-07 Thread Adrien Monteleone
Reports are HTML. They open quite easily in spreadsheet apps. You can then massage as needed to remove extraneous spacing columns and then convert to CSV. (you can also select-all and then paste non-formatted text into a spreadsheet if you don't want to save first) If you do the

Re: [GNC] Transfer Dates

2022-06-07 Thread Adrien Monteleone
Then edit the CSV for the proper Descriptions & Accounts before importing. More than likely, that can be scripted or at least accomplished with some creative copy/paste (or spreadsheet formulas/macros) to speed things up if the file is really large. *Note! - it is always advised to import

Re: [GNC] Transfer Dates

2022-06-07 Thread Adrien Monteleone
That's what the Description line is for. I suppose you can use it for all sorts of things, but personally I only use it as a 'payee' line, that is, whomever is receiving my funds. If I'm the one receiving, then it is a 'payor' line, the one giving me money. Sticking to that, you should

Re: [GNC] Startup issue - two windows

2022-06-05 Thread Adrien Monteleone
X causing the problem) Regards, Adrien On 6/5/22 11:22 AM, Fred Tydeman wrote: On Sun, Jun 5, 2022 at 8:03 AM Adrien Monteleone < adrien.montele...@lusfiber.net> wrote: Your screenshot came through, thanks. Here is another one after moving some of the windows around, shutdown, restart.

Re: [GNC] Startup issue - two windows

2022-06-05 Thread Adrien Monteleone
and/or the Tip of the Day if they are causing problems. (Preferences > General) Regards, Adrien On 6/3/22 11:42 AM, Adrien Monteleone wrote: Thanks. That's weird. I use the same resolution with no issues. (though on a Mac) I'll do some Linux testing later to see what I can find. Regards, Adrien On

Re: [GNC] need help getting started

2022-06-03 Thread Adrien Monteleone
Eric, Check the Help and the Tutorial (linked from the website, but should be available from within GnuCash). I don't recall which, but one describes the CSV format for importing bills/invoices. I don't *think* you can import them as paid, because it isn't just a flag on the transaction.

Re: [GNC] Mass Reconcile

2022-06-03 Thread Adrien Monteleone
I suppose they could be added, but those are standard for just about any OS. They aren't specific to GnuCash. Regards, Adrien On 6/3/22 10:43 AM, Fred Tydeman wrote: I got a private email to me (would have been better if it went to the list), telling me that in Reconcile, one can do Ctrl-a to

Re: [GNC] Startup issue - two windows

2022-06-03 Thread Adrien Monteleone
Thanks. That's weird. I use the same resolution with no issues. (though on a Mac) I'll do some Linux testing later to see what I can find. Regards, Adrien On 6/3/22 9:43 AM, Fred Tydeman wrote: On Fri, Jun 3, 2022 at 7:12 AM Adrien Monteleone < adrien.montele...@lusfiber.net> wrote:

Re: [GNC] Odd Invoice Total (Rounding Issue Maybe)

2022-06-03 Thread Adrien Monteleone
I'd file a bug, label it as 'Regression' since a change broke something that worked. Be sure to indicate the version that worked and the tested versions that do not. I vaguely recall some work done to 'improve' rounding due to other bugs around the 3.x series. I guess this slipped through

Re: [GNC] Invoice showing balance due

2022-06-03 Thread Adrien Monteleone
There is another option: If you already have processed a pre-payment/over-payment, the result will be a credit on the customer's account. If you check the box for Preferences > Business > Invoices > 'Process payments on posting', then when you post the next invoice for that customer,

Re: [GNC] Startup issue - two windows

2022-06-03 Thread Adrien Monteleone
Per my other reply, send over the current screen resolution. I can play with this later today to see if I can duplicate the effects. Regards, Adrien On 6/3/22 8:10 AM, Fred Tydeman wrote: I was wrong. The reason I had no problems recently was: In Preferences, I had unchecked: Run when

Re: [GNC] Startup issue - two windows

2022-06-03 Thread Adrien Monteleone
Sorry, last spec: What resolution? Regards, Adrien On 6/3/22 8:09 AM, Fred Tydeman wrote: On Fri, May 13, 2022 at 11:05 AM Adrien Monteleone < adrien.montele...@lusfiber.net> wrote: What distro and version? Linux: Fedora 35 What version of GnuCash? 4.10+(2022-03-26) Does e

Re: [GNC] Odd Invoice Total (Rounding Issue Maybe)

2022-06-03 Thread Adrien Monteleone
Looks like a rounding issue when using inclusive tax. The latest GnuCash is 4.10. You can get a .deb for it in the Debian Archives (see the wiki) or try the Flatpak to see if the issue still exists. Regards, Adrien On 6/3/22 2:07 AM, Jeff wrote: Hi Group. I am just doing some testing

Re: [GNC] Balance Sheet mismatch

2022-06-03 Thread Adrien Monteleone
If I recall correctly, there is a known limitation of the current Balance Sheet with respect to multiple currencies. I also recall there is only one price option that 'works', mostly, but I don't recall which one it is. (I thought it was 'nearest' but not certain) There are older threads on

Re: [GNC] Strange incorrect due date calculated on a duplicated bill

2022-06-02 Thread Adrien Monteleone
Thanks, done: https://bugs.gnucash.org/show_bug.cgi?id=798547 Regards, Adrien On 6/2/22 11:48 AM, Geert Janssens via gnucash-user wrote: Op donderdag 2 juni 2022 18:22:40 CEST schreef Adrien Monteleone: Indeed, testing both 2020 and 2022 November dates result in a 19day due date rather than

Re: [GNC] Invoice showing balance due

2022-06-02 Thread Adrien Monteleone
Yes, it is Preferences > Business > Invoices/Bills > 'Process payments on posting'. I use it and it auto-applies outstanding pre-payment/over-payment credit situations. Of course, one has to have already 'processed payment' for that vendor/customer for the feature to 'see' the amount to

Re: [GNC] Strange incorrect due date calculated on a duplicated bill

2022-06-02 Thread Adrien Monteleone
Indeed, testing both 2020 and 2022 November dates result in a 19day due date rather than 20. I also tested the March dates for moving from standard to daylight time and those worked correctly. (they didn't add a day) Should I go ahead and file a bug? Regards, Adrien On 6/2/22 1:14 AM,

Re: [GNC] Strange incorrect due date calculated on a duplicated bill

2022-06-01 Thread Adrien Monteleone
It changed on the posting day, 11/7/21, but that occurred in the wee morning and the posting time is 10:59. And I didn't enter the bill in GC until just before posting the thread. Regards, Adrien On 6/1/22 2:21 PM, Geert Janssens wrote: Was there a switch from summertime to standard time

[GNC] Nifty Feature for Examining Report HTML for Customization

2022-05-31 Thread Adrien Monteleone
Until now, if I wanted to examine the HTML behind a report, I exported, opened it in a browser and used the built-in inspector, or just opened it with an editor. (using an inspector lets you play with changes and get instant feedback) I happened to be right-clicking around a report just now,

Re: [GNC] Strange incorrect due date calculated on a duplicated bill

2022-05-31 Thread Adrien Monteleone
date. (not that it really matters, since it was long ago paid, but just for consistency) Regards, Adrien On 5/31/22 1:03 PM, Adrien Monteleone wrote: Interestingly, I tried unposting and reposting several times yesterday to no avail. I normally do not shut down GC when done, but I had a few

Re: [GNC] Strange incorrect due date calculated on a duplicated bill

2022-05-31 Thread Adrien Monteleone
and the moon. (I know another alternative was to remove the terms for this one invoice and manually set the date, but I didn't need to in this case) Regards, Adrien On 5/31/22 12:58 PM, Adrien Monteleone wrote: I checked. I've posted every day of the week, and Net20 can thus be on any day

Re: [GNC] Strange incorrect due date calculated on a duplicated bill

2022-05-31 Thread Adrien Monteleone
I checked. I've posted every day of the week, and Net20 can thus be on any day of the week, and indeed, it is, for every invoice except this one. Regards, Adrien On 5/31/22 12:23 PM, Adrien Monteleone wrote: I'll check that too, but really, it shouldn't matter should it? Net20 is Net20

Re: [GNC] Strange incorrect due date calculated on a duplicated bill

2022-05-31 Thread Adrien Monteleone
I'll check that too, but really, it shouldn't matter should it? Net20 is Net20. If a company independently wants to give leeway for weekends or holidays, I don't see why GnuCash should assume it. Regards, Adrien On 5/31/22 9:42 AM, Derek Atkins wrote: Maybe you usually don't post on Sunday

Re: [GNC] Strange incorrect due date calculated on a duplicated bill

2022-05-31 Thread Adrien Monteleone
Interesting idea. I'll check to see if any others fall on a weekend and got changed, but strange I haven't seen it before after several years of use. Regards, Adrien On 5/31/22 4:18 AM, Fred Bone wrote: An override for days falling at the weekend? (2021-11-27 was a Saturday).

Re: [GNC] Duplicating a bill with a linked document duplicates the link as well

2022-05-30 Thread Adrien Monteleone
Trying to edit one of these document links produced a crash. It is filed here for anyone interested: https://bugs.gnucash.org/show_bug.cgi?id=798545 Regards, Adrien On 5/30/22 8:25 PM, Adrien Monteleone wrote: Not sure if this is intended behavior. I use the 'Duplicate' bill/invoice feature

[GNC] Duplicating a bill with a linked document duplicates the link as well

2022-05-30 Thread Adrien Monteleone
Not sure if this is intended behavior. I use the 'Duplicate' bill/invoice feature to repeat something that requires little or no change, save for the relevant dates. But I just realized, I've got a chain of duplicated vendor bills off one bill that already had a linked PDF copy of the bill.

Re: [GNC] Strange incorrect due date calculated on a duplicated bill

2022-05-30 Thread Adrien Monteleone
I'm using SQLite, but the time stamp for posting is: 2021-11-07 10:59:00 Which seems to be a regularly used stamp, for this vendor at least. A subsequent duplicated bill (off of this one) for December correctly calculated Net20 from 12/7 as 12/27. (also using the 10:59:00 stamp) Regards,

Re: [GNC] Finance::Quote on Mac Air

2022-05-30 Thread Adrien Monteleone
The fq-update & manual quote commands should work if it is installed properly. It may not be. How did you install it? What API are you using? Alphavantage? You need to put your API key in GnuCash preferences for GnuCash to be able to use it. Regards, Adrien On 5/30/22 4:09 PM, Dieter Kip

Re: [GNC] Reports blank - after some account changes?

2022-05-26 Thread Adrien Monteleone
Try the 4.10 flatpak, or build from source. This should be fixed. Regards, Adrien On 5/26/22 9:42 AM, Nick Meyne wrote: Hi There. I'm on Ubuntu, Gnucash Version: 4.4, Build ID: 4.4+(2020-12-28) - a newbie to Gnucash, and was getting on just fine until... All the reports in my gnucash

Re: [GNC] Mass Reconcile

2022-05-22 Thread Adrien Monteleone
Interesting approach. Some reports let you search on several fields for specific matches, so for those, you could simply include your 'tags' in the Description, Notes, or Memo fields. That would save lots of effort maintaining and including in each transaction 'dummy' splits as 'tags'.

Re: [GNC] Create multiple taxes

2022-05-22 Thread Adrien Monteleone
Is it a real tax, or just a 'service fee' that *you* are charging? (something you don't have to remit to some other entity) If that's not the case, I'm not understanding why you want to call it a 'tax' and why you are wanting to book it to an asset. (as opposed to a pass-through liability or

Re: [GNC] Running Reports - Failure

2022-05-21 Thread Adrien Monteleone
Did you have any Webkit updates? That is what GC uses for rendering the reports. If so, maybe roll-back and pin that package for now, then file a bug report with the details. Regards, Adrien On 5/21/22 10:53 AM, Martin Booth via gnucash-user wrote: Hi, Running reports has suddenly stopped

Re: [GNC] Deleting an account

2022-05-20 Thread Adrien Monteleone
Gyle, File it as an RFE (Request for Enhancement) on Bugzilla. (see the Gnucash wiki for more info) That way, the suggestion is documented and progress can be tracked when/if it is taken up. Regards, Adrien On 5/20/22 8:09 PM, Gyle McCollam wrote: The change I suggested still is a

Re: [GNC] How to convert between currency and assets and record change of value

2022-05-20 Thread Adrien Monteleone
If you're doing this regularly, this sounds like a retail operation. Purchase: Dr. Assets::Inventory Cr. Assets::Checking Sale: Dr. Assets::Undeposited Funds (for amount of sale) Cr. Income::Sales (for amount of sale) Dr. Expenses::Cost of Goods Sold (for value of inventory) Cr. Inventory

Re: [GNC] Startup issue - two windows

2022-05-18 Thread Adrien Monteleone
In my original reply of suggestions to try, I was working on the assumption that the user had inadvertently raised focus while the controlling window was generated. The only way around that is to not touch anything till all windows load. But if a window that demands control is not also

Re: [GNC] Integration between Freshbooks and Gnucash?

2022-05-16 Thread Adrien Monteleone
On 5/16/22 3:48 PM, Jim DeLaHunt wrote: One tedious aspect of this combination is that I need to re-author my invoices in GnuCash after I author them in Freshbooks and send them to the customer. Can Freshbooks export your invoices to CSV? (or other spreadsheet format) If so, you can then

Re: [GNC] Startup issue - two windows

2022-05-13 Thread Adrien Monteleone
What distro and version? What version of GnuCash? Does exiting full screen help? Does not starting in full screen help? Are you using a second display, or have you used a second display, in between the time it worked fine and this problem appeared? (a window might be appearing on a 'ghost'

Re: [GNC] Changing the default Font

2022-05-11 Thread Adrien Monteleone
I'm pretty sure the file is supposed to be: gtk-3.0.css, not gtk-30.css Also, it doesn't go in your 'My Documents' folder. The wiki explains how to make these adjustments, the proper file name, and the proper file location for each operating system.

Re: [GNC] Reconcile Finish button

2022-05-11 Thread Adrien Monteleone
Right on the confirmation dialog, because there are plenty enough threads here from those who dismissed them permanently as a nuisance and months/years later report they weren't warned when making an edit. Regards, Adrien On 5/11/22 9:51 AM, David T. via gnucash-user wrote: Yeah. I've never

Re: [GNC] Reconcile Finish button

2022-05-11 Thread Adrien Monteleone
That's Google being 'helpful' by 'suggesting' substitutions so as not to be allegedly offensive. I guess it reads okay, but that doesn't mean it conveys what you intended. (I wonder, does it edit *incoming* mail too?) Since you brought up visual impairment, the choice of Green is a really bad

Re: [GNC] Reconcile Finish button

2022-05-10 Thread Adrien Monteleone
You can file an RFE (Request for Enhancement) on Bugzilla. See the Wiki for more on bug reporting. Regards, Adrien On 5/10/22 9:41 PM, Fred Tydeman wrote: It would be nice if in the Reconcile window, when the Difference is zero, the Finish button would turn green.

Re: [GNC] Startup issue - two windows

2022-05-10 Thread Adrien Monteleone
The issue with not being able to close the tip of the day window is the Scheduled Transactions window has stolen focus. First click on the Tip of the Day window to raise it to the 'top of the window stack' and then close it. Then use whatever means of your OS to reveal windows hidden beneath

Re: [GNC] default local currency (Liz)

2022-05-10 Thread Adrien Monteleone
If it is greyed out, something is definitely wrong. I'm going with a read-only preference file as mentioned by David H. But that should imply other preferences also being greyed out. If not, more digging is required... Permissions issue on Win10 perhaps? (Not sure why that would affect only

Re: [GNC] default local currency

2022-05-09 Thread Adrien Monteleone
Preferences > Accounts > Default Currency. Your choices are: 1. Locale (set by your OS preferences) 2. Specify one from the drop down. Regards, Adrien On 5/9/22 10:20 PM, David Long wrote: I have been using GnuCash on a Desktop, and installed it on my laptop too. It was a messy installation

Re: [GNC] List of securities with Get Online Quotes

2022-05-09 Thread Adrien Monteleone
Except it didn't matter if I waited a minute or so in between each call. It even failed some days on the first call. That's what had me stumped. But yeah, if another sources works reliably, it is probably the source and not F::Q. Regards, Adrien On 5/9/22 9:49 PM, David T. via gnucash-user

Re: [GNC] GnuCash 4.10

2022-05-09 Thread Adrien Monteleone
So you originally jumped from 3.11 to 4.10? If 4.0 works, did you run Actions > Check & Repair > Check & Repair all after the upgrade to 4.0? (you should do that after each major version jump) Regards, Adrien On 5/9/22 1:16 PM, Richard Clarkson via gnucash-user wrote: Reverting to GnuCash

Re: [GNC] Budget Reporting

2022-05-09 Thread Adrien Monteleone
On 5/7/22 8:39 AM, iwaddo via gnucash-user wrote: I’m new to gnucash so please let me know if this is not the correct way to get support. This is *one* of the right places. IRC is another option. I have successfully entered all my transactions back to Oct 21, everything balances as I

Re: [GNC] List of securities with Get Online Quotes

2022-05-09 Thread Adrien Monteleone
Fred, See my reply in your 'Hang' thread. As soon as I got my second hang in GnuCash, I resorted to CLI, keeping GnuCash Price DB open to check each of the symbols one-by-one. F::Q/Alphavantage would hang on the CLI too for random symbols. Sometimes it would instantly retrieve say USD->EUR,

Re: [GNC] gnucash v 2.6.19 or newer on 32bit linux

2022-05-09 Thread Adrien Monteleone
Check out the GnuCash Wiki concerning using the Debian Archive: https://wiki.gnucash.org/wiki/Ubuntu#GnuCash_.40_Debian_Archive It is linked there, but you can look at the list of available .deb packages here: http://ftp.us.debian.org/debian/pool/main/g/gnucash/ Theoretically, you could

Re: [GNC] gnucash v 2.6.19 or newer on 32bit linux

2022-05-09 Thread Adrien Monteleone
of Ubuntu might affect your options here. And if your older system has a version greater than 2.6.19 on it, something else has gone wrong, and more info would be needed. On March 24, 2022 9:20:25 PM EDT, Adrien Monteleone wrote: Caveat: You can have some dependency issues on that old ma

Re: [GNC] Large GnuCash file very slow to write to

2022-05-09 Thread Adrien Monteleone
'Saves' with SQLite are supposed to be instant. That is, all commits on changes happen right away, not on a schedule or only on exit. (same with the other two db backends, and those are more difficult to manage/administer) If you've removed Piecash temporarily from the workflow, and it still

Re: [GNC] Get Quotes hangs

2022-05-09 Thread Adrien Monteleone
I had similar problems on MacoS BigSur just before and after the release of 4.10, and it would hang either via GnuCash or via CLI. I figured it was just a F::Q or Alphavantage problem. And indeed, it cleared up, but I haven't tried it lately. Regards, Adrien On 5/8/22 9:17 PM, Fred Tydeman

Re: [GNC] QIF import error

2022-05-07 Thread Adrien Monteleone
Good to know. I'm sure many here will be happy if it picks back up. Regards, Adrien On 5/6/22 10:37 PM, davidcousen...@gmail.com wrote: There is a bit of recent correspondence on the github site with a possible new project manager interested. I gather the main problem is in getting Ngewi Fet

Re: [GNC] QIF import error

2022-05-06 Thread Adrien Monteleone
GnuCash for Android is a separate project. Last I heard, it isn't even an active one. (no commits since mid-2018) You can try their GitHub page: https://github.com/codinguser/gnucash-android Regards, Adrien On 5/6/22 11:15 AM, Shaun Parsons wrote: Hi I have recently come across GnuCash which

Re: [GNC] Change layout and font sizes in Transaction Report - how?

2022-05-05 Thread Adrien Monteleone
. (best I can tell, I didn't play with all options) Give that a go. I do see prominent Account Totals but I agree, the initial Account Name starting each section should be more noticeable. Regards, Adrien On 5/5/22 12:59 PM, Adrien Monteleone wrote: The old built-in 'stylesheets' probably do

Re: [GNC] Change layout and font sizes in Transaction Report - how?

2022-05-05 Thread Adrien Monteleone
The old built-in 'stylesheets' probably do not. But there is a CSS-based (experimental) sheet that is just open text. You spec any id or class or element you want with your chosen rules. Mind you, GnuCash uses Webkit for rendering, so you need to check caniuse.com if you are unsure about a

Re: [GNC] Can one save report option defaults?

2022-05-05 Thread Adrien Monteleone
I use this method for a monthly P for a running 'at a glance' when I want it. Since the report is set to reference dates (start/end of this month) rather than specific dates, I don't have to change any options. It just rolls over to the new month when the date changes. Regards, Adrien On

Re: [GNC] Is there a way to handle same-named GnuCash files sensibly?

2022-05-05 Thread Adrien Monteleone
XCIF is your friend! You can back-date the meta for those images and scans with something like `exiftool`. No definitive word of if it runs on Linux, but it does on MacOS and other Unix systems. Otherwise there is a web implementation: https://exif.tools Regards, Adrien On 5/5/22 11:39 AM,

Re: [GNC] Issues with Payables

2022-05-05 Thread Adrien Monteleone
he receipt or payment date incorrectly and then changed the date in the Bank Account Register. On Mon, 2022-05-02 at 21:24 -0500, Adrien Monteleone wrote: How are you entering these payments? That should be done with the 'Process Payments' feature where you select the document (bill/invoice) to be p

Re: [GNC] Change layout and font sizes in Transaction Report - how?

2022-05-05 Thread Adrien Monteleone
Export the report. The format is HTML, then you can examine it with a text editor and/or open it in a browser and use its inspector. Alternatively, just open it in a spreadsheet app and manipulate it from there. Regards, Adrien On 5/4/22 5:40 AM, Chris Green wrote: The Transaction Report

Re: [GNC] Can one save report option defaults?

2022-05-05 Thread Adrien Monteleone
No there is not unfortunately. I've seen it discussed and there is probably an RFE filed on it. Regards, Adrien On 5/4/22 9:31 AM, Chris Green wrote: I find I nearly always change the same five or six report options every time I want a new report. For example I nearly always want to select

Re: [GNC] Is there a way to handle same-named GnuCash files sensibly?

2022-05-03 Thread Adrien Monteleone
So you've chosen an organization method that creates the problem but then ask for how to avoid it? The answer seems pretty obvious to me: Don't start a new file each year. But before that, to your original question, what files exactly in ~/.local/... are you concerned about? One rarely needs

Re: [GNC] Change account in Transfer column - how?

2022-05-03 Thread Adrien Monteleone
Chris, You can install the latest version via following these instructions from David Cousens: https://lists.gnucash.org/pipermail/gnucash-user/2022-April/100771.html Regards, Adrien On 5/3/22 10:45 AM, Chris Green wrote: On Tue, May 03, 2022 at 04:05:26PM +0100, david whiting wrote: Yes,

Re: [GNC] Is there a report with transactions by date and accounts in columns?

2022-05-03 Thread Adrien Monteleone
The Transaction Report can get you the info broken down that way, but not quite arranged in 'landscape'/'spreadsheet' fashion. You can set the primary sort order by Account, and then secondary sort by Date. This will group transactions by account and then list them in date order and you can

Re: [GNC] Issues with Payables

2022-05-02 Thread Adrien Monteleone
How are you entering these payments? That should be done with the 'Process Payments' feature where you select the document (bill/invoice) to be paid, enter a payment amount, and select the source/destination account. For existing transactions you can right-click them and choose Edit Payment

Re: [GNC] Account Summary report - cannot use CTRL to select accounts one by one.

2022-04-28 Thread Adrien Monteleone
I can report that it works properly on MacOS BigSur. (4.10) Anyone using Ubuntu 22.04 or other distros with the same problem? Since this works on Win & Mac, I'd bet the issue is a dependency version on Linux that has an issue. Regards, Adrien On 4/28/22 6:10 AM, Elmar wrote: Sadly no joy

Re: [GNC] Linux. Mysql and Gnucash 4.1

2022-04-26 Thread Adrien Monteleone
See my previous reply to Chris Green, and also check the Wiki. Plenty of users are on various backends under various OS. Regards, Adrien On 4/26/22 1:36 AM, grant wrote: So I have rebuilt my laptop, recovered my databases and installed Gnucash 4.1 but I cannot connect to mysql databases.

Re: [GNC] Linux. Mysql and Gnucash 4.1

2022-04-26 Thread Adrien Monteleone
It offers 4 backends: XML (default) SQLite MySQL/MariaDB PostgreSQL You have to install the desired backend libs in most cases to be offered the option of using it. The default requires no special effort. Many Linux distros also come with SQLite support by default, so mileage varies.

Re: [GNC] File browser file type filter and bookmarks

2022-04-20 Thread Adrien Monteleone
The File menu has a 'recent files' list at the bottom. That gets populated on each File > Open of a different file. (or the same file in a different location) You only need to do File > Open once per file, and then afterwards, just select it from the list. GnuCash remembers where it saved it,

Re: [GNC] REPORT CONFIGURATION

2022-04-13 Thread Adrien Monteleone
You can define (add) style sheets for each special instance and tie them to a saved configuration. You can also achieve some of the same results using the General Tab of most reports with or without involving saved configurations. (thus the rest of the style sheet stays the same) You can

Re: [GNC] Scheduled transactions feature or bug?

2022-04-12 Thread Adrien Monteleone
I agree, the behavior should not be changed, but perhaps the UI could be improved if people aren't realizing what is going on. Of course, there is a responsibility for the user to learn the software, how it works, and pay attention to things. (such as noticing last run and next occurrence

Re: [GNC] Can't find the file sometimes

2022-04-12 Thread Adrien Monteleone
That would tell me you moved the file using Finder. You can say 'yes' to remove it from the list if you like. When you choose File > Open and find its new location, GnuCash will add it back to the list with the new path. If you move data files, GnuCash will give you this message. If you want

Re: [GNC] Scheduled transactions feature or bug?

2022-04-12 Thread Adrien Monteleone
This sounds like a good case of not auto-creating them, but rather approving them each time. There are options for this. Regards, Adrien On 4/12/22 9:55 AM, Dale Alspach wrote: I had a scheduled transfer to savings that I disabled for a few months. When I re-enabled the scheduled transfer I

Re: [GNC] Auto-save failure

2022-04-12 Thread Adrien Monteleone
In Preferences > General there are some Auto-Save options. If those are set correctly, then something else is amiss. Unfortunately, if you've already re-started GnuCash, the Tracefile was overwritten, so if there is info there to help, it is gone. I take note you're using the Flatpak. This

Re: [GNC] Reconciliation discrepancies

2022-04-12 Thread Adrien Monteleone
Do you by chance have sub-accounts at play, and are you including them in the reconcile? Sub-accounts *shouldn't* matter because 'if done correctly' they shouldn't affect the parent balance, and serve just as a segregation/classification tool. But the caveat is that transactions there might be

Re: [GNC] Debit and Credit columns wrong way round on one transaction report but not the other

2022-04-08 Thread Adrien Monteleone
If indeed your transactions were entered backwards, you can go through each one and put a minus sign in front of each and every debit and credit amount and they will swap sides after tabbing through. (there might be an easier way to swap them, but I'm not aware of such) There's no such thing

Re: [GNC] Debit and Credit columns wrong way round on one transaction report but not the other

2022-04-08 Thread Adrien Monteleone
I suspect you have way more accounts than just 2! (seriously, read the manual) What do you mean by "wrong way 'round"? Debit is always the left-hand column, Credit is always the right-hand column. They never swap. Your *data* might be swapped though. (you've entered debits instead of

Re: [GNC] creating a Tranaction report

2022-04-06 Thread Adrien Monteleone
hat but can not find it. Does Anyone know what the sequence is? Chuck On Wed, Apr 6, 2022 at 2:36 PM Adrien Monteleone < adrien.montele...@lusfiber.net> wrote: I'm not 100% certain what specifically you are asking for, but if you want to save a particular report configuration (such as after

Re: [GNC] creating a Tranaction report

2022-04-06 Thread Adrien Monteleone
I'm not 100% certain what specifically you are asking for, but if you want to save a particular report configuration (such as after selecting desired accounts) you can do that from the Reports menu. At the bottom are three options: 1. Saved Report Configurations - brings up a list of

Re: [GNC] create desktop icons for GNC 4.9 Flatpak on Ubuntu - solved

2022-04-04 Thread Adrien Monteleone
I think that was the 'high bit characters' Jeff was referring to. Since they were in the path, most definitely, that was the problem with opening the file. (still not sure why that would make the icon fail) How they got there is anyone's guess, maybe a bad copy/paste? Glad to hear it is

Re: [GNC] Loss one of my file

2022-04-01 Thread Adrien Monteleone
For completeness and clarity, this is only an issue (so far as I know) with *GnuCash* on MacOS. It is not generally a MacOS problem. I have often double-clicked other files which resulted in them being opened in their proper app. Regards, Adrien

Re: [GNC] Loss one of my file

2022-04-01 Thread Adrien Monteleone
Yes, sorry Stan, since the OP was on a Mac I was replying for just that case. I should have made the caveat more specific. Frank kindly did so for posterity. Regards, Adrien On 4/1/22 9:51 AM, Stan Brown wrote: On 2022-03-31 16:05, Adrien Monteleone wrote: You can't double-click the file

Re: [GNC] Stock pricing

2022-04-01 Thread Adrien Monteleone
John, That definitely doesn't sound right with the download. Are you letting Sourceforge auto-download for you? Try the direct link: https://sourceforge.net/projects/gnucash/files/gnucash%20%28stable%29/4.10/gnucash-4.10-1.setup.exe/download You can get to that on your own if you want by

Re: [GNC] creating a Tranaction report

2022-03-31 Thread Adrien Monteleone
As for 'help' go to gnucash.org, left hand menu, you find 'Documentation', 'FAQ', and 'Wiki' links. 'Documentation' offers a 'Help Guide' and a 'Tutorial & Concepts Guide'. The Help Guide is geared more toward screen/UI explanations, key combos, etc. The Tutorial & Concepts Guide is about

Re: [GNC] Loss one of my file

2022-03-31 Thread Adrien Monteleone
You can't double-click the file to open it, if that is what you are doing. GnuCash will always open the last used file. Use File > Open > and then navigate to where file #2 is and open it. Afterwards, both should appear in your 'recent file list' at the bottom of the File Menu. Always start

Re: [GNC] create desktop icons for GNC 4.9 Flatpak on Ubuntu

2022-03-31 Thread Adrien Monteleone
Ha! Best of luck with the keyboard! Check into (Ubuntu) Settings > Universal Access > Typing > Screen Keyboard. This will pop-up an on-screen keyboard when a typing field has focus. That's not the best workaround, but it will help a bit. - As for GnuCash, what about the USB access info

Re: [GNC] Customizing invoices (Helmut Eller

2022-03-31 Thread Adrien Monteleone
John, Sorry I guess I misunderstood your suggestion wrong. What's throwing me off is that setting up a non-currency commodity isn't going to help as I see it. Quantity is not a commodity. It is the multiplier of one. A line-item on an invoice is always some multiplier of a currency. The

Re: [GNC] Customizing invoices (Helmut Eller

2022-03-30 Thread Adrien Monteleone
Helmut, It isn't a matter of using securities on invoices. The Security Editor is simply where you set the smallest fraction of a currency. (and thus the number of digits displayed) John is proposing tying that setting in to be used outside of securities, in this case for invoices amounts.

Re: [GNC] creating a Tranaction report

2022-03-29 Thread Adrien Monteleone
Try: Accounts > Filter Type > "Do not do any filtering" and un-select every account in that part of the dialog. (the top section should have the desired accounts selected, 'All' is fine of course) Did you get a report? Then try: General > Add Options Summary > "If no transactions matched"

Re: [GNC] Customizing invoices (Helmut Eller

2022-03-29 Thread Adrien Monteleone
Thanks to you and Chris for investigating. Hopefully, this will resolve the discrepancy. Regards, Adrien On 3/29/22 10:50 PM, john wrote: Chris has created https://bugs.gnucash.org/show_bug.cgi?id=798496 to document working on that.

Re: [GNC] how to put loan downpayments in budgets

2022-03-29 Thread Adrien Monteleone
Perhaps my wording was poor. Yes, I see it the same way. (hence my comment about envelope method budgeting) Regards, Adrien On 3/29/22 10:43 PM, john wrote: I think you're conflating two separate things. Saving up for a down payment is not buying a house. There's no property value to

Re: [GNC] Customizing invoices (Helmut Eller

2022-03-29 Thread Adrien Monteleone
On 3/29/22 5:14 PM, John Ralls wrote: On Mar 29, 2022, at 10:33 AM, Adrien Monteleone wrote: The report should simply print the data from the invoice unchanged. Be careful what you ask for. The data from the invoice is a rational number, meaning a numerator and a denominator. The print

Re: [GNC] create desktop icons for GNC 4.9 Flatpak on Ubuntu

2022-03-29 Thread Adrien Monteleone
For the icon issue, while Flatpak apps are sandboxed and might not have access to that icon location, have you tried copying it to somewhere in your home folder and seeing if that works? (it is the Desktop file using it, so this would be weird, but I guess worth a shot)

Re: [GNC] create desktop icons for GNC 4.9 Flatpak on Ubuntu

2022-03-29 Thread Adrien Monteleone
The 'no suitable backend' is clueing me to an issue with that particular file and not having the right backend installed/enabled. But Jeffrey already said opening the file directly works fine and is using XML. (usually one sees that error when trying to use one of the db backends since XML is

Re: [GNC] how to put loan downpayments in budgets

2022-03-29 Thread Adrien Monteleone
Tough one. The property value doesn't increase because you didn't borrow the full price and paid cash up front for a portion of it. The liability doesn't change because that's after (net) the down-payment. I'd hazard either an asset or equity account for something like 'savings goals'

Re: [GNC] Customizing invoices (Helmut Eller

2022-03-29 Thread Adrien Monteleone
David, it seems the list-thread is broken, so for completeness, I'm posting there that I filed bug: https://bugs.gnucash.org/show_bug.cgi?id=798493 on this issue. This also happens for the Unit Price column. The report should simply print the data from the invoice unchanged. Regards, Adrien

Re: [GNC] Customizing invoices

2022-03-29 Thread Adrien Monteleone
Helmut, I just filed bug: https://bugs.gnucash.org/show_bug.cgi?id=798493 This is also a problem with the Unit Price field. The invoice itself contains the desired precision as you noted, but the Report alters it. Rather than a preference or option to edit the report directly (a Herculean

<    7   8   9   10   11   12   13   14   15   16   >