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] 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&L (Income Statement) which is probably more of what you are looking for. Regards, Adrien On 8/28/22 3:13 PM, P

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 as

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 mont

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 s

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 like

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 report

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 quiet,

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 8

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 we

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 wro

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 offset

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 gnuc

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 al

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 lis

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, beca

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 "envi

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

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] "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 > Cust

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 o

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, i

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 expe

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 later

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 noted

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 tri

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? (this

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

2022-09-12 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
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-12 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] 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 on

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

2022-09-14 Thread Adrien Monteleone
aller 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 comp

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 be

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 https://wiki.gnucash.org/wiki/FAQ#Q:_I_have_de

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] 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

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 'invoice

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. Upgr

Re: [GNC] More UI downgrades

2022-09-21 Thread Adrien Monteleone
'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

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] 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 were

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 1

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 informa

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

2022-09-30 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 th

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
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 av

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 f

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 pr

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 d

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 settin

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 external/network/cloud

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 'vi

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 con

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 some

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] 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, o

Re: [GNC] CoGS on Income Statement

2022-10-06 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 G

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. If

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 past

Re: [GNC] Saved report configurations

2022-10-07 Thread Adrien Monteleone
he one you 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/

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 requi

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] 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 Name:Bu

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
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] 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 d

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 & Balanc

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 expor

Re: [GNC] rounding of Invoice vs Accounts Receivable

2022-10-17 Thread Adrien Monteleone
The problem with advertising 'inclusive' sales tax is, except in limited circumstances, usually impossible. This is because in many jurisdictions, there are taxes that scale with the amount of the total purchase, or on the day of the purchase (tax holidays anyone?) or even who the buyer is, (ex

Re: [GNC] Help please. Upgraded from 2.3.4 to 4.12. Worked fine. But database does not load. Win 11.

2022-10-19 Thread Adrien Monteleone
Indeed, if you were truly running 2.3.4, you'll need to step to a 2.4.x version, then a 2.6.x version, then 3.x, then 4.12, running Actions > Check & Repair > Check & Repair All when first opening the file after each upgrade, and of course ideally, keeping backup versions each step along the wa

Re: [GNC] Help please. Upgraded from 2.3.4 to 4.12. Worked fine. But database does not load. Win 11.

2022-10-19 Thread Adrien Monteleone
Unlikely, but you might get lucky. (You really don't have *any* backup at all? Really? You've been using a decades old version of GnuCash and you never make backups?) Note, the GnuCash file, by default unless you changed it, is a compressed XML file. Uncompressed, it is just plain text and hum

Re: [GNC] Help please. Upgraded from 2.3.4 to 4.12. Worked fine. But database does not load. Win 11.

2022-10-20 Thread Adrien Monteleone
By 'backup' we don't mean something you do within GnuCash, we mean something you do with your entire computer/personal files. If you never make backups of any of your files, or only rarely, then I guess you're stuck rebuilding data if you can't recover this file. (this would be the case with A

Re: [GNC] Help please. Upgraded from 2.3.4 to 4.12. Worked fine. But database does not load. Win 11.

2022-10-20 Thread Adrien Monteleone
You can turn it off. Some may have and forgot. And I'm not sure when that was added. It may not have been available for 2.3.4. That version was never intended to be used regularly. It was a development/testing version only. Though such a file or files might be in the OPs data directory, we'll

Re: [GNC] invoicing

2022-10-25 Thread Adrien Monteleone
You might find it easier to invoice monthly sending that first. Then send a Customer Report each following week, which will reflect payments, and thus the amount outstanding, automatically. That would significantly reduce the effort on your part, and the number of invoices in your system. You'r

Re: [GNC] Total and Grand Total at the end of a Transaction Report

2022-10-25 Thread Adrien Monteleone
The Subtotal in this case is for one month. It represents the net (credit in this case) balance *for the chosen accounts* over that period. (you could have set subtotal by account first instead of date first) The Grand Total is the net debit/credit over the entire report range - *for those acc

Re: [GNC] Total and Grand Total at the end of a Transaction Report

2022-10-26 Thread Adrien Monteleone
You may be also interested in viewing the General Journal (Tools menu). This defaults to 30 days, but you can use View > Filter by... and change that to 'all'. (or your desired date range) Then run Reports > Account Report. You'll get a similar report with all transactions for all accounts in

Re: [GNC] invoicing

2022-10-26 Thread Adrien Monteleone
One trick I've heard works wonders from someone who has used it: Don't *just* charge a late fee. Bymp your rent to *include* the (former) late fee and still list the late fee. Then offer a discount (removing the original late fee) for early payment. For example: Current Rent $1000 Current L

Re: [GNC] Total and Grand Total at the end of a Transaction Report

2022-10-26 Thread Adrien Monteleone
On 10/26/22 1:58 PM, Peter S. Shenkin wrote: Thank you for the suggestion about General Journal. I like the way the Account Report is formatted; namely, in "hanging paragraphs" with the first split, only, labeled with the Description. This makes it easy to discern the boundaries between transact

Re: [GNC] The meaning of Running Balance in Transaction Report: bug or enhancement request?

2022-10-26 Thread Adrien Monteleone
Perhaps a clarification as you mentioned would be best and easiest for now. I'd dare ask, if you're sorting primarily by date, with multiple accounts selected, what do you want the running balance to be? Just those accounts? (is that even useful?) Or the entire Book? Any of those could get qu

Re: [GNC] The meaning of Running Balance in Transaction Report: bug or enhancement request?

2022-10-26 Thread Adrien Monteleone
Nope, the first one came through the list just fine. Regards, Adrien On 10/26/22 4:24 PM, Vincent Dawans wrote: [Ooops I think I messed up my reply to/cc mix, so trying again -- still new to this mailing list thing] ___ gnucash-user mailing list gnu

Re: [GNC] invoicing

2022-10-26 Thread Adrien Monteleone
Arthur, I'm copying you directly this time in addition to the list, not sure if you are subscribed to the list. (If not, you won't see replies sent only to the list that don't include you in the CC field) - You might find it much easier to just invoice monthly as normal and send a weekl

Re: [GNC] The meaning of Running Balance in Transaction Report: bug or enhancement request?

2022-10-26 Thread Adrien Monteleone
It could just be that you're providing a simplified example, but in that screenshot I noticed every single line had the Checking Account as the 'Transfer' account. (other account) Why not just run the report on the Checking Account only? It would then give you a running balance that makes sens

Re: [GNC] The meaning of Running Balance in Transaction Report: bug or enhancement request?

2022-10-26 Thread Adrien Monteleone
Yes, I think a clarification would be useful in the interim til the option is fixed. Regards, Adrien On 10/26/22 7:53 PM, Vincent Dawans wrote: Yes it is indeed a simplified example I was using. And your second example is the one that indeed I show as working (the one with all expense accounts

Re: [GNC] invoicing

2022-10-26 Thread Adrien Monteleone
Arthur, if you aren't seeing many messages a day from 'gnucash-user@gnucash.org' then, no, you aren't subscribed to the list. But your messages to it are getting through. If people happen to reply-all to your posts, then you get their messages, but if they reply-list then you don't. To fix th

Re: [GNC] Total and Grand Total at the end of a Transaction Report

2022-10-27 Thread Adrien Monteleone
On 10/27/22 2:12 AM, Peter S. Shenkin wrote: Hi, I don't think it is possible to create the "hanging paragraph" view from the Options menu, if one is displaying one transaction per line. At least, I could not find a way. That's why I said: >> Funny, the way to do that with the Transaction Rep

Re: [GNC] Automatic payments and interest during reconciliation?

2022-10-27 Thread Adrien Monteleone
You found all the right places for the settings, but are the accounts of the right 'type'? When you Edit an account, the Type is in the bottom left pane. I would think auto-interest would need to be of type 'Bank' and the auto-payment would need to be of type 'Credit Card'. **I'm pretty sure

Re: [GNC] Total and Grand Total at the end of a Transaction Report

2022-10-28 Thread Adrien Monteleone
in wrote: On Thu, Oct 27, 2022 at 10:08 AM Adrien Monteleone < adrien.montele...@lusfiber.net> wrote: On 10/27/22 2:12 AM, Peter S. Shenkin wrote: Print menu? There is none. Then what would you call the window labeled Print that appears when you enter Ctl-P from a Report?_

Re: [GNC] Total and Grand Total at the end of a Transaction Report

2022-10-28 Thread Adrien Monteleone
ment. While bugs are usually tackled by the devs first of course, some RFEs either aren't hard to implement, or might interest a developer enough to give it a shot. Regards, Adrien On 10/28/22 12:03 PM, Peter S. Shenkin wrote: On Fri, Oct 28, 2022 at 12:22 PM Adrien Monteleone <

Re: [GNC] Automatic payments and interest during reconciliation?

2022-10-28 Thread Adrien Monteleone
No worries Paul, I hope those replies are of some help. Regards, Adrien On 10/28/22 6:42 PM, Paul Kinzelman wrote: Re: The post, and Adrian's reply the next day, both show up here: https://lists.gnucash.org/pipermail/gnucash-user/2022-August/thread.html Oops, sorry, somehow I missed the rep

Re: [GNC] Paying invoices from the edit invoice screen

2022-10-31 Thread Adrien Monteleone
I'm guessing you mean the Transfer Account pane in the bottom right of the Payment dialog. I seem to recall that it defaults to no selection, then to whatever was last used, per customer or vendor. As to why it ever was used for Liabilities in your case, I have no idea. But intentionally chang

Re: [GNC] Invoice Template

2022-11-01 Thread Adrien Monteleone
Yes, any report can be copy/pasted or exported/imported into a spreadsheet app for further manipulation. However, most if not all of what you've described is achievable from within GnuCash. Explore and play with custom sytlesheets for reports. Particularly, play with Edit > Style Sheets > CS

Re: [GNC] Found a bug, accounts gone haywire.

2022-11-05 Thread Adrien Monteleone
Before getting too far in the weeds with other possibilities, I'd caution to closely examine your accounts/transactions first, particularly if you can hazard a reasonable guess as to when you first saw the balance go awry. From near that point, find a transaction with the allegedly correct ba

Re: [GNC] Found a bug, accounts gone haywire.

2022-11-06 Thread Adrien Monteleone
Sounds like an account was deleted and the transactions not moved, or moved somewhere not expected. Regards, Adrien On 11/6/22 9:32 AM, Michael Davis wrote: I was just about to do that and I realized I’d been reading it wrong, the credits do increase the balance and the debits decrease it. So

Re: [GNC] Credit Note to pay bill

2022-11-06 Thread Adrien Monteleone
Yes. Process Payment for that Vendor. Select both the Jan bill and the credit note. Set the date as desired. Put any note you want. Click 'OK' to commit the payment. The credit note will offset the bill as a payment. You can verify this with a Vendor Report for that vendor and use Options

Re: [GNC] Credit Note to pay bill

2022-11-07 Thread Adrien Monteleone
That might be a bug and I thought it was fixed in 4.11. If you are using an older version, that would explain it. There was a case where the "I" or "P" were changed to a "?". That field is supposed to be immutable. Clicking it should do nothing. It is for display/info only. Each transaction

Re: [GNC] Gnucash on macOS Ventura

2022-11-14 Thread Adrien Monteleone
I'm forever locked on Monterey so I can't test, and I don't see that problem with GnuCash, but, I do see it running Firefox on Monterey and Win10, and I get it all over the UI in *buntu based VMs starting with the 22.04 release. I don't know if Firefox uses GTK+ code, but if so (and considerin

Re: [GNC] Gnucash on macOS Ventura

2022-11-14 Thread Adrien Monteleone
What specifically do you mean by 'work'? Does the window not open at all? Are you using the Edit menu option, or the keyboard shortcut? If the window opens, does it just not find an account you know exists? Regards, Adrien On 11/14/22 9:58 AM, Alan Magnus via gnucash-user wrote: I can’t get

Re: [GNC] Gnucash on macOS Ventura

2022-11-14 Thread Adrien Monteleone
It should not open any account. It should show you in the Accounts tab where in the tree, that account exists, with it highlighted. Then you double click or choose Open on the toolbar to open that account register. Odd that it is opening any account at all from the Find window. Regards, Adrien

Re: [GNC] Gnucash on macOS Ventura

2022-11-14 Thread Adrien Monteleone
That is very odd indeed as now this isn't necessarily a Find Account problem as it is an Accounts Tab problem. Does this only happen after doing Find Account? Now that you know where the account is, can you open it without doing a Find Account first? Regards, Adrien On 11/14/22 12:41 PM, Al

Re: [GNC] Tracking Travel expenses

2022-11-14 Thread Adrien Monteleone
I'm not sure there is a 'recommended' method. (and that would be an 'accounting' question anyway) However, I have the following in my account tree: Expenses: -Entertainment: -Travel: -Food -Lodging -Transportation That way I can keep those separate from my 'everyday' ex

<    1   2   3   4   5   6   7   8   9   10   >