Re: [GNC] Slow migration

2022-10-15 Thread Adrien Monteleone
Please forgive me if this is too non-specific and generalized, I'm sure someone else who's made the MSmoney –> GnuCash migration can lend assistance (there are threads from the past on this subject, so it has been done) but I'll offer some general considerations and ideas. #1 Can MSmoney

Re: [GNC] Follow up on Gnucash invoicing and payment - questions on process

2022-10-14 Thread Adrien Monteleone
As far as I know, that exact report doesn't exist in GnuCash, but there are various ways to see this information. #1 Invoices Due Reminder This is a dialog window, not a report. (and sadly no way to get that data to a report as far as I know.) It shows the Invoice, Customer, Date Due &

Re: [GNC] Sub-Accounting (Was: Problem with missing balance in a parent account **FINAL POST**)

2022-10-13 Thread Adrien Monteleone
I agree. Some years ago, there were a few threads here that delved into various means of implementing an envelope method in GnuCash and my personal take-away was, while it can be done, the only sane method is lots of work. (you mention a not so sane method, or rather, one that could quickly

Re: [GNC] Creating/Modifying a Budget Report

2022-10-10 Thread Adrien Monteleone
Abe, please remember to reply-all or reply-list that way others can benefit from the conversation, and may be able to help where I can't. - You should be able to edit everything in a spreadsheet app with ease. Every report is just an HTML table, so it has cells with labels and data which

Re: [GNC] Creating/Modifying a Budget Report

2022-10-10 Thread Adrien Monteleone
I forgot to add, if you go the CSS route (or use CSS customizations before going to a spreadsheet) you'll want to focus on learning the basics of headings, fonts, colors, and tables. That should be sufficient for working with GnuCash reports. (there might be a few others, but this will get you

Re: [GNC] Creating/Modifying a Budget Report

2022-10-10 Thread Adrien Monteleone
While you *could* learn Scheme or Guile and craft our own version, these are presentational details, and can more easily be handled by other means. #1 - Options > General Report name - This allows you to change the report name. Note for this report, the entire displayed name is 'Report

Re: [GNC] Creating/Modifying a Budget Report

2022-10-10 Thread Adrien Monteleone
Can you describe the modification? What you want to change might make a difference in the offered possible solutions and ideas. Regards, Adrien On 10/10/22 11:07 AM, Abe Sternberg wrote: I have been using GnuCash for about a year and am not a very sophisticated user.  I am the treasurer for

Re: [GNC] Mac Installation 4.12 issue

2022-10-09 Thread Adrien Monteleone
Dragging .app packages from a .dmg to /Applications (or ~/Applications) is standard for all MacOS apps not installed by the AppStore. It is not particular to GnuCash. Many Apps have made a handy /Applications shortcut in their .dmg main folder to prompt the user to do so, but that is not

Re: [GNC] Saved report configurations

2022-10-07 Thread Adrien Monteleone
are viewing. 'Save Config As...' saves the current config as a *new* config, and you get to name it. There are also Reports menu items for both actions, and keyboard shortcuts for both. (though similar save for one extra key - so be careful!) Regards, Adrien On 10/7/22 7:42 AM, Adrien

Re: [GNC] Saved report configurations

2022-10-07 Thread Adrien Monteleone
You have to set your mail app to 'attach' rather than pasting the images within the text. (known as 'inline') The mailman software that this list runs on will strip out inline images, but does allow attachments. A usually more robust method is to store the images on a 3rd party site and

Re: [GNC] Gnucash invoicing and payment - questions on process

2022-10-07 Thread Adrien Monteleone
Thanks Geert for the correction & clarification. I think you've had to set me straight more than once on that point. I'm not sure why I have it stuck it my head. Apologies. Regards, Adrien On 10/7/22 2:18 AM, Geert Janssens wrote: That's not a GnuCash restriction. You can have multiple.

Re: [GNC] CoGS on Income Statement

2022-10-07 Thread Adrien Monteleone
On 10/6/22 8:35 PM, Jared Squires wrote: I'm trying to find a way to implement the Cost of Goods Sold in the Income Statement. Right now I have it as it's own Expense Top Level Account but it messes up my Income Statement for my actual Gross Profit. How does it 'mess up' your statement for

Re: [GNC] Gnucash invoicing and payment - questions on process

2022-10-06 Thread Adrien Monteleone
On 10/6/22 1:59 PM, Charles Vincent wrote: Hello Gnucash users list members, I come back on the issue of invoicing clients and payment by the clients or a third party. As background: For info, I am keeping the accounts for a small not for profit school in Cambodia. I have done the 70 invoices,

Re: [GNC] CSV transaction import settings

2022-10-06 Thread Adrien Monteleone
David, It looks like you want the chart here: https://wiki.gnucash.org/wiki/Configuration_Diagrams_-_Linux 1. /home//.local/share/gnucash 2. /home//.local/share/gtk-3.0 3. /home//.config/gnucash 4. /home//.config/gtk-3.0 One of those four directories should have the file you are looking for.

Re: [GNC] Troubleshooting and/or database repair

2022-10-06 Thread Adrien Monteleone
Glad to hear you don't need to reinstall the entire system! Now, to troubleshoot the OneDrive problem... I don't use it, so sorry if I can't be of further help, but I'm sure others here on the list do and might be able to assist. Search the list archives for 'OneDrive' and you might find

Re: [GNC] Saved report configurations

2022-10-06 Thread Adrien Monteleone
It looks like you were putting screenshots inline rather than as attachments. Those images did not come through, so we can't see what you are referring to. Your saved configuration should be under: Reports > Saved Report Configurations. You'll then get a pop-up with a list of your saved

Re: [GNC] Reconciling subaccounts

2022-10-06 Thread Adrien Monteleone
Thanks for the details. I'd say this is a bug, as the expected result would be to have the reconcile status of sub-accounts updated. You should file that on bugs.gnucash.org It *might* be designed that way however. I could be wrong, but I think the idea for this feature is to be used for

Re: [GNC] Troubleshooting and/or database repair

2022-10-06 Thread Adrien Monteleone
If you try to add a transaction with a split to a non-existent account, do you get the option to create that account? If so, and you choose to create it, does the new-account window show up? And one additional 'environment' question: Is this a local file, or stored on an

Re: [GNC] CSV transaction import settings

2022-10-06 Thread Adrien Monteleone
David, The Wiki FAQ has a section on file locations. I don't have the exact answer off-hand, but I'm sure one of those locations has what you are looking for. (allegedly, there are no other places used by GnuCash) Regards, Adrien On 10/6/22 8:49 AM, David Carlson wrote: Where are the

Re: [GNC] Reconciliation Report -> Trade Debtors -> pairing transactions

2022-10-03 Thread Adrien Monteleone
If you are looking for 'aging', that is, how much of an amount owed is say 30days, 60days, or 90+days due, then that is at the bottom each Customer or Vendor report. (and also shows any unused pre-payments/deposits in the case you use that feature) It doesn't show any sort of average, but it

Re: [GNC] Reconciling subaccounts

2022-10-03 Thread Adrien Monteleone
Ah, scratch that last question. I see you've put in the chart which accounts show a reconciled date and it appears sub-accounts never do when using that option. In that case, yes, I think you found a bug. Please file it. The instructions are here on the wiki if you aren't familiar with the

Re: [GNC] Reconciling subaccounts

2022-10-03 Thread Adrien Monteleone
Okay, so now we see the account structure, but now, can you give an example of which parent account you were trying to reconcile with sub-accounts that did not update their last-reconciled dates? Regards, Adrien On 10/3/22 8:41 AM, Uttam Chakravorty wrote: Dear Adrien, This is what I use

Re: [GNC] Reconciliation Report -> Trade Debtors -> pairing transactions

2022-10-01 Thread Adrien Monteleone
Glad to have pointed you in the right direction. And in that case of 'breadcrumbs' the entirety of GnuCash is an audit trail, as that is how double-entry accounting works. If you are looking for some record of exactly who entered which transactions and the date/time stamps, no, that is not

Re: [GNC] Reconciling subaccounts

2022-10-01 Thread Adrien Monteleone
What account *exactly* are you selecting that is a placeholder? It sounds like you're trying to reconcile a very top-level account and then including sub-accounts. If so, I don't think that is how the feature was intended to work. (though maybe it *could* regardless, I honestly never thought

Re: [GNC] Reconciliation Report -> Trade Debtors -> pairing transactions

2022-10-01 Thread Adrien Monteleone
The Business Features handle all of that with ease. There is no need for myriad accounts or convoluted account structure. "invoices as sub-categories for each business"? What is that about? The official process is fairly simple and straightforward. Set up Customers. Post Invoices linked to

Re: [GNC] Reconciliation Report -> Trade Debtors -> pairing transactions

2022-09-30 Thread Adrien Monteleone
On 9/30/22 12:48 PM, Uttam Chakravorty wrote: Dear All, I am using the Reconciliation Report configured as: Accounts = Trade Debtors ->Currency / Display / Filter = defaults -> General - current period selected -> Sorting by Description then Date. Is there a way to use this pool of

Re: [GNC] Register sort order

2022-09-26 Thread Adrien Monteleone
On 9/26/22 10:35 AM, Derek Atkins wrote: The "number" column is actually treated as a number! So it is not sorted lexically but sorted numerically. That means 090 will come before 0190. If you have a "number" with a non-numeric piece, it will only sort up to that non-numeric piece, so 1a and

Re: [GNC] Created transactions post after review

2022-09-25 Thread Adrien Monteleone
I haven't looked at the Help in some time, I thought this was documented, but it may still be on someone's to-do list. Preferences > Scheduled Transactions > Since Last Run > Review created transactions that will set a new 'default' for you. In the Since Last Run dialog itself, if there

Re: [GNC] Expense chart matching description

2022-09-24 Thread Adrien Monteleone
Presently, you can try these steps: 1. Run a Find as you have already done, 2. Run an Account Report from the results tab or 1. Run a Transaction Report using the Filter tab in the report Options then, Copy/Paste or Export, or Save/Open the resulting report in a spreadsheet app and create a

Re: [GNC] More UI downgrades

2022-09-21 Thread Adrien Monteleone
a 'gray box'? If you are running 'stock' everything, without a screenshot of the problem area, I'm not sure I can be of any help. Regards, Adrien On 9/15/22 4:31 PM, Adrien Monteleone wrote: Russell, Please use Reply-list or Reply-all so that all messages go through the list and everyone can see

Re: [GNC] Moving to a new computer

2022-09-19 Thread Adrien Monteleone
Dan, You should visit the GnuCash Wiki and read over the sections about Storage Locations & Backups --- https://wiki.gnucash.org/wiki/Backup (pay particular attention to the 'related files' section so you bring over any saved reports as well as your preferences.

Re: [GNC] Deposits

2022-09-18 Thread Adrien Monteleone
If you are using the 'business features' rather than manually keeping track of 'customer' accounts, then the best way to handle deposits (a.k.a. 'pre-payments') is as a payment. Simply use the Business > Customer > Process Payment feature to record the pre-payment. You don't select an

Re: [GNC] More UI downgrades

2022-09-15 Thread Adrien Monteleone
. (see the wiki about 'netiquette') As to your question, "I use the Mate version of Mint. Did you install Cinnamon?" yes, I installed Cinnamon, but I can certainly test with MATE. I'll get back to you here when that is done. Regards, Adrien On 9/13/22 12:27 PM, Adrien Montel

Re: [GNC] Issue Opening GnuCash in versions above 4.9 on Windows 11

2022-09-15 Thread Adrien Monteleone
Richard, (your message about downloading from gnucash.org doesn't seem to be appearing for me via gmane - so I'll just reply to this message) Okay, now that we've eliminated non-official sources, and since this looks like a dll most likely provided by GnuCash, I'd suggest the following: 1.

Re: [GNC] Wrong Regedit key in Wiki for setting MRU maxfiles on Windows version 4.11

2022-09-15 Thread Adrien Monteleone
It is a wiki, so you are free to register an account and make the change. Regards, Adrien On 9/14/22 11:58 AM, Vincent Dawans wrote: Was happy to see it is now possible to change the number of recent files in the menu as per instructions in the FAQ

Re: [GNC] Issue Opening GnuCash in versions above 4.9 on Windows 11

2022-09-15 Thread Adrien Monteleone
Ah true, I forgot. And more than likely, the recommendation would be to try v4.12 to see if the issue is resolved. As for dll damage. Windows has the System File Checker. But I think that is only for stock files. I'm not sure it works for 3rd party software. I'd say the easiest route would

Re: [GNC] Issue Opening GnuCash in versions above 4.9 on Windows 11

2022-09-14 Thread Adrien Monteleone
that used to work very well, at least several years ago. On Mon, Sep 12, 2022 at 3:03 PM Adrien Monteleone < adrien.montele...@lusfiber.net> wrote: Richard (Clarkson), You mentioned in the other thread that you also tried from PowerShell. Is there no output there when it fails to completel

Re: [GNC] More UI downgrades

2022-09-13 Thread Adrien Monteleone
Russell, I happen to have a Mint21 VM using VirtualBox I've been trying out so I installed GnuCash to test and see if I get the same issue. I don't. Everything works as expected. There is no gray box and I can highlight amounts from the left or right with no problems. Note, I tested this

Re: [GNC] Color of register placeholder text and hiding register header

2022-09-13 Thread Adrien Monteleone
Damn, I did have the leading period! Mailman seems to be stripping it out. Apologies. So the class is properly ".register-secondary" for hopefully the final time. Regards, Adrien On 9/13/22 1:08 AM, Adrien Monteleone wrote: Sorry, I swore I had a period in front of the class:

Re: [GNC] Color of register placeholder text and hiding register header

2022-09-13 Thread Adrien Monteleone
Sorry, I swore I had a period in front of the class: register-secondary in my prior post. It is a class, not a node/entity. Regards, Adrien On 9/13/22 1:04 AM, Adrien Monteleone wrote: Also note those color definitions I mentioned still have to be used in a rule. Simply defining them

Re: [GNC] Color of register placeholder text and hiding register header

2022-09-13 Thread Adrien Monteleone
Maybe try: cursor entry { color: (whatever you like); } The comments at the top of the sample CSS file from the Wiki define 'cursor entry' as an entity/node that affects the active cell. That declaration should override everything else. Be sure to test with commenting out or removing your

Re: [GNC] Color of register placeholder text and hiding register header

2022-09-12 Thread Adrien Monteleone
On 9/11/22 1:16 PM, Glenn Fowler wrote: I found this will change the input text color: gnc-id-cursor entry { color: green; } ...and it works but it gets overridden whenever you change *.gnc-class-register-cursor color but not sure why. Not sure either, maybe reverse them in the file?

Re: [GNC] Opening Gnucash

2022-09-12 Thread Adrien Monteleone
Kudos for still maintaining track of your finances at 90! Your welcome. I'm glad you got into your proper file. Regards, Adrien On 9/12/22 3:34 PM, Richard Barmann wrote: I may have been double clicking because my hands shake and I find myself typing double letters when I type. I carefully

Re: [GNC] new to Gnucash - help with general information

2022-09-12 Thread Adrien Monteleone
Donna, Others have sufficiently answered, but I'll add some points about backups: There is the maxim, for least risk, that if your data does not exist in three places, on three different types of media, you can consider it 'not existing at all.' That might be extreme for some folks. As

Re: [GNC] Pre-Payments into Liabilities

2022-09-12 Thread Adrien Monteleone
And to add to what Stan & Gyle said, Several years ago, I played around with pre-payments using a Liabilities:Customer Deposits account but that was a mess. The way the Business Features of GnuCash work, it is *much* easier to just Process Payment, letting it post to AR and then apply it

Re: [GNC] Opening Gnucash

2022-09-12 Thread Adrien Monteleone
Richard (Barmann), To open GnuCash, just use the shortcut *for the app*, and *do not* double-click your data file. This will open the last used file. If this gets you what you want - great, the problem is solved. Open GnuCash this way from now on. If this isn't the version of data you

Re: [GNC] Issue Opening GnuCash in versions above 4.9 on Windows 11

2022-09-12 Thread Adrien Monteleone
Richard (Clarkson), You mentioned in the other thread that you also tried from PowerShell. Is there no output there when it fails to completely open? Have you tried to view the Windows Logs to see if any warnings or errors were reported about the time you tried to start GnuCash? Of course,

Re: [GNC] Opening Gnucash

2022-09-12 Thread Adrien Monteleone
Holy Cow. This thread is a disaster. Richard Clarkson, please, unless you can help Richard Barmann, do not reply any longer in this thread. Please, start a new one or if still applicable, reply in your own old thread. The two of you are replying to questions meant for the other and others

Re: [GNC] "Deleted" Invoices or Bills

2022-09-07 Thread Adrien Monteleone
I already answered about them not 'disappearing' and how to mark them to easily find them again, *and* how to find them again for reuse. If you didn't mark them as advised in some fashion and simply left them unposted when closing the tab, then learn to play with 'Find'. Menu: Business >

Re: [GNC] Saved Reports Location Question

2022-09-06 Thread Adrien Monteleone
Yes, sorry. Geert set me straight. (and offered pointers for you to get it to work) Regards, Adrien On 9/6/22 8:11 AM, butterands...@gmail.com wrote: Well, obviously it is NOT "hard coded" cause I've been using my dropbox box location on my Windows desktop for saved reports for years on both

Re: [GNC] Saved Reports Location Question

2022-09-06 Thread Adrien Monteleone
On 9/6/22 7:37 AM, Geert Janssens wrote: Op dinsdag 6 september 2022 06:13:45 CEST schreef Adrien Monteleone: I'm pretty sure those locations are hard coded. They are not :) Awesome, good to know, thanks! Regards, Adrien ___ gnucash-user

Re: [GNC] Saved Reports Location Question

2022-09-05 Thread Adrien Monteleone
I'm pretty sure those locations are hard coded. It might be worth investigating the Windows equivalent of a symbolic link. Regards, Adrien On 9/5/22 8:22 PM, butterands...@gmail.com wrote: In the C:\Program Files (x86)\gnucash\etc directory, in the gnucash subdirectory, where there is an

Re: [GNC] Mutual Fund Dividend After Sale

2022-09-05 Thread Adrien Monteleone
On 9/5/22 12:13 PM, Jack Frillman via gnucash-user wrote: No I didn't delete the account? Why would I do silly thing like that and lose all that history? The account is hidden because it's balance is 0. Reappearing means exactly what it says. I was no longer in the account tree, i.e. list,

Re: [GNC] Mutual Fund Dividend After Sale

2022-09-05 Thread Adrien Monteleone
You deleted the account holding the fund after selling it? Otherwise, and unless you marked it 'hidden' it will always be there. Having activity in it doesn't change that. But you wouldn't have activity in it anyway from a dividend. What *exactly* do you mean by 'reappearing in my account

Re: [GNC] Display report values in whole curremcy units

2022-09-02 Thread Adrien Monteleone
Export or copy/paste the report to a spreadsheet and manipulate from there. Regards, Adrien On 9/2/22 12:43 AM, Richard Gaede via gnucash-user wrote: I would like to be able to print reports which display numbers in whole currency unit values. I have experimented with Preferences which only

Re: [GNC] gnucash reconcile doesn't respect "Decimal places"

2022-09-02 Thread Adrien Monteleone
3.11 or 4.11? 4.11 is the current version. That is odd behavior regardless, I must agree. Do you happen to have Preferences > Numbers, Date, Time > Numbers > 'Automatic Decimal Point' checked by any chance? If so, it might be dropping '.00' Regards, Adrien On 9/2/22 7:42 AM, rsbrux via

Re: [GNC] Question - Applying Credit notes to an outstanding invoice

2022-09-01 Thread Adrien Monteleone
Menu: Business > Customer > Process Payment Look up the customer Select both the desired credit note and the desired invoice Set the other appropriate info, but unless also taking another form of payment leave the payment field unchanged. The credit note will be used to partially/fully

Re: [GNC] "Deleted" Invoices or Bills

2022-09-01 Thread Adrien Monteleone
Menu: Business > Customer/Vendor > Find Invoice/Bill > 'Invoice/Bill ID' > 'contains' > "Use Next" or whatever text you changed it to. (without quotes) Then you can select the one you want and use the view/edit button to adjust from there. Regards, Adrien On 9/1/22 1:25 PM, Eric Hammond

Re: [GNC] "Deleted" Invoices or Bills

2022-08-31 Thread Adrien Monteleone
They remain forever. (There was a decent explanation as to why recently on IRC - the short of it is that deleting them cleanly is simply too messy with the current code.) My workflow in such cases is to change their ID to 'use next'. You can either create a dummy vendor/customer for them as

Re: [GNC] Mailing list options (was Re: gnucash-user Digest, Vol 233, Issue 90)

2022-08-31 Thread Adrien Monteleone
Usenet doesn't exist for a large swath of users as ISPs have dropped access to it. Though if it ever was resurrected, I would prefer it too. In the meantime, I'm accessing the list via Gmane. (which reminds me, I am seriously derelict in writing up a How To on the Wiki) Regards, Adrien On

Re: [GNC] Using the List

2022-08-31 Thread Adrien Monteleone
Phyllis, There is no 'list' of topics to choose from. All messages are simply e-mail that go through the mailing list server. If you have turned off digest mode, then you'll get a new e-mail every time someone starts a new topic or replies to an existing topic. Some days, it is rather

Re: [GNC] Reports: Account ending balances

2022-08-31 Thread Adrien Monteleone
Great! Thanks for reporting back what worked. Regards, Adrien On 8/31/22 6:36 AM, Pa In wrote: Perfect Adrian! Setting the budget option 'beginning on' to the dated I want the budget report to start works even if I do not enter any budget amounts. Thanks again for your help. I can now

Re: [GNC] Reports: Account ending balances

2022-08-30 Thread Adrien Monteleone
Ah, you may indeed have to create a budget even if there are no budgeted figures. My memory is a bit fuzzy on that point, but I think the budget report will require you specify a budget, which defines what the periods are, and those are fixed with absolute dates. It is not a sliding window

Re: [GNC] gnucash-user Digest, Vol 233, Issue 88

2022-08-30 Thread Adrien Monteleone
I would think Flatpak would be *way* easier than messing with Wine in this case. (one thing to install directly, not one direct & one indirect) *And* there are folks on the list using the Flatpak who can help. Those who went the Wine route, while I'm sure there may be some, I would think are

Re: [GNC] Reports: Account ending balances

2022-08-30 Thread Adrien Monteleone
Did you try the Budget Report? That one can show assets & liabilities too. Regards, Adrien On 8/30/22 4:45 PM, Pa In wrote: Would be great if it wasn't just limited to income and expenses but also included all other accounts so I could track how asserts and liabilities change from month to

Re: [GNC] Fixing incorrect Vendor for invoices

2022-08-29 Thread Adrien Monteleone
I could be mistaken, but I think a bug report was already filed on this. (It may have just been a list discussion though) I tend to agree. The 'Edit' buttons that appear next to the Vendor/Customer and Job do not 'speak' to me as allowing me to edit the details of the Vendor/Customer or Job

Re: [GNC] Reports: Account ending balances

2022-08-28 Thread Adrien Monteleone
A Budget Report can do that. Not certain if you need a budget set up, but I don't think so. Include only the 'actual' column(s). I think there is also an experimental multi-period P (Income Statement) which is probably more of what you are looking for. Regards, Adrien On 8/28/22 3:13 PM, Pa

Re: [GNC] GC 3.11 crashes during "Check & Repair"

2022-08-28 Thread Adrien Monteleone
The Check & Repair is to be done after each major version upgrade. Since you're getting a crash, (on more than one data file?) I'd recommend obtaining the output the devs are looking for using the links David sent. (all documented on the Wiki) I don't know if they need just the Windows info,

Re: [GNC] Accounting Equation Mismatch for Foreign Currency/Security

2022-08-27 Thread Adrien Monteleone
That's how GnuCash works. Your issue as David pointed out is that you want (or have a need to) record *unrealized* gains/losses. Usually, most people only record a gain or loss after a transaction, not just after a 'price change' on some listing. The price you paid remains the price (your

Re: [GNC] reconciling an account and paying the balance

2022-08-27 Thread Adrien Monteleone
The Interest entry is per-account. With the target account selected in the Accounts tab, use the Edit button on the toolbar (or the Edit menu, or right click) to change that setting. Examine each Card account by using the Edit window as well. Make sure each one is set to 'type' (bottom left

Re: [GNC] GnuCash 3 for Ubuntu Studio 22.04 LTS

2022-08-27 Thread Adrien Monteleone
I likely would as well, which leaves Flatpak or building from source as the only options to get a proper GnuCash upgrade path via 3.x. And building might be quite messy with respect to dependencies in this case. Regards, Adrien On 8/26/22 4:19 PM, David Carlson wrote: It's not me, But if it

Re: [GNC] GnuCash 3 for Ubuntu Studio 22.04 LTS

2022-08-26 Thread Adrien Monteleone
Interesting question. Perhaps try a 3.x flatpak? Otherwise, if you haven't yet jumped from 18.04 to 22.04 maybe an interim stop at 20.04 will get you GnuCash 3.x. (Can you even go directly from 18.04 to 22.04? I didn't think it would even give you the option) Be sure to review the Wiki

Re: [GNC] Example of importing Stock transactions from CSV

2022-08-24 Thread Adrien Monteleone
As for using the Expenses account, unless you intentionally made it *not* a placeholder account, you can't put transactions in it. I'll hazard a guess that is why the importer is not assigning it. Create a sub-account of Expenses for tracking the commissions/fees and try to assign that one in

Re: [GNC] Example of importing Stock transactions from CSV

2022-08-24 Thread Adrien Monteleone
Unless I've confused something, purchasing or selling a stock/fund/etc. should be between 2 asset accounts. Considering a split for a commission or such, (like the first line of your CSV) it would be a *specific* expense account, not the parent and placeholder "Expenses" account. Regards,

Re: [GNC] Change GnuCash scrollbar color in CSS?

2022-08-16 Thread Adrien Monteleone
the instructions but it didn't work. On Tue, Aug 16, 2022 at 8:44 PM Adrien Monteleone < adrien.montele...@lusfiber.net> wrote: Glenn, check the wiki with respect to the GTKInspector which might be able to help you find the proper id/class/object to target. From the Inspector you can als

Re: [GNC] Confusing and inconsistent headers in transaction entry and report forms

2022-08-16 Thread Adrien Monteleone
Peter, I think the problem stems from your choice of report options. Namely, by default, 'Account Name' under the Display tab is *not* selected, while the 'other account' is. This is because by default the Sort options are: Primary: account Secondary: register order So by default, the

Re: [GNC] Confusing and inconsistent headers in transaction entry and report forms

2022-08-16 Thread Adrien Monteleone
Sorry, while I did send screenshots on 8/2, my reply on 8/3 contains the annotated versions. Regards, Adrien On 8/16/22 8:25 PM, Adrien Monteleone wrote: I sent a reply on 8/2 with annotated screenshots showing the issue using default options save for the account selection

Re: [GNC] Saving Gnucash data and back ups

2022-08-16 Thread Adrien Monteleone
Thanks Geoff, good to know! Regards, Adrien On 8/16/22 8:17 PM, Geoff wrote: Both Microsoft Windows 10 & 11 have a comprehensive automated file based backup and restore utility built in.  Read this article for an overview:

Re: [GNC] Confusing and inconsistent headers in transaction entry and report forms

2022-08-16 Thread Adrien Monteleone
Peter, You are reading the report incorrectly. I sent a reply on 8/2 with annotated screenshots showing the issue using default options save for the account selection. John replied this afternoon saying the same thing using significantly less words than I did on 8/2. The reports are all

Re: [GNC] How to bulk import about 130 Securities entries?

2022-08-16 Thread Adrien Monteleone
Indeed, my apologies David. I got lost in the thread, which it seems has now broken again (2 new messages I see are threaded separately as a new topic) and one reply from Chris Good concerning OFX import having the auto-creation option somehow ended up in a thread "Due Invoices Reminder form"!

Re: [GNC] Saving Gnucash data and back ups

2022-08-16 Thread Adrien Monteleone
On 8/16/22 1:33 PM, dsamo...@shaw.ca wrote: I am new to Gnucash and have a few questions regarding saving data. I use Windows 10 and Gnucash Version: 4.11 Build ID: 4.11+(2022-06-25) 1. I would like to save everything in one folder named Gnucash. I think I will use the xml format.

Re: [GNC] Change GnuCash scrollbar color in CSS?

2022-08-16 Thread Adrien Monteleone
Glenn, check the wiki with respect to the GTKInspector which might be able to help you find the proper id/class/object to target. From the Inspector you can also make changes in real time to experiment. I'm pretty sure that GnuCash doesn't expose this element to styling, but customizing the

Re: [GNC] How to bulk import about 130 Securities entries?

2022-08-16 Thread Adrien Monteleone
David, This thread keeps breaking, but unless I've lost track as a result, I thought this was flywire's thread from the start. (who also has several other related threads dealing with specific aspects of the task at hand.) The goal was to import transactions for, and as a result, mass create

Re: [GNC] Due Invoices Reminder form

2022-08-15 Thread Adrien Monteleone
Same place: Preferences > Business You've set Preferences > Business > Bills > Notify when due with a # of days, simply do the same for Invoice right above that. The two numbers can of course be different. Regards, Adrien On 8/15/22 10:53 AM, Eric Hammond wrote: When I enable the "Due

Re: [GNC] gnucash-user Digest, Vol 233, Issue 50

2022-08-14 Thread Adrien Monteleone
Not officially. There was a 'GnuCash for Android' created by someone else that is no longer maintained for a few years now. (it was never a part of the same project) There may be other apps that can export their transactions which you can then import to GnuCash on your computer. Maybe

Re: [GNC] How to bulk import about 130 Securities entries?

2022-08-14 Thread Adrien Monteleone
Check the 'Using GnuCash' page perhaps. Regards, Adrien On 8/14/22 9:50 AM, Tom Browder wrote: P.S. Is there a spot on the Wiki to list things like Geoff's suggestion and flycatcher's program? If not, I will be glad to start one--suggestions welcomed.

Re: [GNC] Using GnuCash with Portfolio Performance Share Software

2022-08-14 Thread Adrien Monteleone
If the issue is creating the security, why not set that up in GnuCash before the import? Am I missing something? Regards, Adrien On 8/14/22 3:06 AM, flywire wrote: Portfolio Performance also exports broker account transactions that can be normalised with a python script to import into

Re: [GNC] Strange Error Message

2022-08-12 Thread Adrien Monteleone
Apologies, that was a different user. The other thread involved editing a payment with a job assigned. Is that your case too? Regards, Adrien On 8/12/22 7:40 PM, Robert Simmons wrote: If I use the process payment feature on an invoice to a customer, and then go to the checking account the

Re: [GNC] Strange Error Message

2022-08-12 Thread Adrien Monteleone
Does this invoice involve a job? I thought this was what you were reporting the other day. Regards, Adrien On 8/12/22 7:40 PM, Robert Simmons wrote: If I use the process payment feature on an invoice to a customer, and then go to the checking account the payment was processed to, and then

Re: [GNC] Scheduled transactions do not appear in the register until is pressed

2022-08-12 Thread Adrien Monteleone
Yet another example of how awesome the GnuCash team is. Thanks John! Regards, Adrien On 8/12/22 3:11 PM, John Ralls wrote: That was it: The registers weren't refreshed unless the SLR dialog runs and the user clicks OK. I've pushed a fix that will be in tomorrow's nightlies

Re: [GNC] Share Values recording

2022-08-12 Thread Adrien Monteleone
I'm pretty sure the Guide (or Help) covers other/multi-currency questions with regards to stocks. The account has to be of the same currency as the stocks. So even if you buy the same stock but in different currencies, you'll need separate accounts for each stock & for each currency—e.g.,

Re: [GNC] Share Values recording

2022-08-11 Thread Adrien Monteleone
Do you simply want to track activity but are not concerned with individual share counts and prices? If that is the case, then a basic account of type Asset would do. You then make your entries as needed just like the Pen & Paper method. I'm sure there are plenty of resources online to

Re: [GNC] Scheduled transactions do not appear in the register until is pressed

2022-08-11 Thread Adrien Monteleone
I thought one was already opened. (but I admit I didn't search for it) If I recall correctly, it has to do with refreshing the register view. This seems to happen with registers that are left open at the last close and which re-open before the Since Last Run dialog fires. Though hitting

Re: [GNC] Possible Bug in Credit Note Display

2022-08-11 Thread Adrien Monteleone
Robert, Done: https://bugs.gnucash.org/show_bug.cgi?id=798598 However, it seems you're on quite a streak finding bugs. Consider registering an account. Regards, Adrien On 8/11/22 7:03 AM, Robert Simmons wrote: do you need me to file it? I don't have an account. Can you file it?

Re: [GNC] gnucash-user Digest, Vol 233, Issue 34

2022-08-10 Thread Adrien Monteleone
If I'm not mistaken, Mint has a backup utility. So you can just set it up and make sure the GnuCash locations noted in the Wiki and Guide are included in the paths to be backed up. Regards, Adrien On 8/10/22 9:29 PM, davidcousen...@gmail.com wrote: James

Re: [GNC] Possible Bug in Credit Note Display

2022-08-10 Thread Adrien Monteleone
Correct. You can register an account at bugs.gnucash.org. Regards, Adrien On 8/10/22 4:02 PM, Robert Simmons wrote: No Bugzilla account. Github account, but it looks like you all only handle PRs there, not issues. ___ gnucash-user mailing list

Re: [GNC] Possible Bug in Credit Note Display

2022-08-10 Thread Adrien Monteleone
you need me to file it? Regards, Adrien On 8/10/22 3:45 PM, Adrien Monteleone wrote: Nope, I already had a credit note that I ended up not using. (but since you can't delete them, it was available for testing) I had previously deleted the line items so I added some dummy data and couldn't

Re: [GNC] Possible Bug in Credit Note Display

2022-08-10 Thread Adrien Monteleone
Nope, I already had a credit note that I ended up not using. (but since you can't delete them, it was available for testing) I had previously deleted the line items so I added some dummy data and couldn't reproduce the effect you described. However, this credit note is to a customer, not from

Re: [GNC] Possible Bug in Credit Note Display

2022-08-10 Thread Adrien Monteleone
I cannot duplicate this on v4.11 running on BigSur. The highlights change as they should, but the values remain correct and do not change to 0.00. (There is a Subtotal column, and a Subtotal 'total' at the top, neither change for me) What is your GnuCash & OS version? Regards, Adrien On

Re: [GNC] Monthly period in charts should use end-of-month values, not start

2022-08-10 Thread Adrien Monteleone
I guess I read the chart differently. It does make sense to know what you started a period with in regards to an asset like a bank account or cash on hand. (And I also see your point of wanting to know where you ended up.) Though I suppose an option could be added, clearly, your position on

<    5   6   7   8   9   10   11   12   13   14   >