Re: [GNC] Profit & Retained Earning don't match

The Transaction Report has an 'Add options summary' flag, but it sadly does not show *all* options, very few of them in fact. Regards, Adrien On 2/25/22 4:01 PM, David Carlson wrote: I can't check right now but I think there is an enhancement request to show in a printable form all the setting

Re: [GNC] Setting up Government Bond

What I read is to *not* set it up as a stock or fund, but rather just 'Asset'. Enter the purchase price. Record interest as it is accrued or at cash-out. No need to hassle with price-per-unit. If you buy another of the same bond and want to track them all in the same account, just add another

Re: [GNC] Keeping tenant accounts on Gnucash - periodic 'rent owing' ?

Arthur, Yes. You can do this, but you'll need to decide based on your situation the best workflow. What you are describing is Accounts Receivable (AR). The Rent is due at a certain date and thus owing to you. Ideally, you want to 'book' the rent payment as due in the AR account as of that du

Re: [GNC] mac fails to open gnucash file

If you are getting a crash, you should file it on bugs.gnucash.org and attach your crash report there. Also, check the wiki about obtaining a TraceFile. That might be helpful as well. But first... I'm guessing you can start GnuCash since it crashes on exit. Can you navigate to File > Open a

Re: [GNC] accounts receivable for rent..

On 3/5/22 12:50 AM, arthur brogard via gnucash-user wrote: We have only one property.  Only one tenant.  Simplest possible case I guess. I'm thinking I must: . Create an 'accounts receivable'  account.That would be an income account I guess.  'Other income' ? Accounts Receivable is an Asset a

Re: [GNC] Keeping tenant accounts on Gnucash - periodic 'rent owing' ?

On 3/5/22 2:20 AM, flywire wrote: My concern is A/R is a lot of work just to get tenant statements if it's not used elsewhere. It is similar to the issue raised last month regarding tracking vehicles except for the regular rent due: https://lists.gnucash.org/pipermail/gnucash-user/2022-February

Re: [GNC] Keeping tenant accounts on Gnucash - periodic 'rent owing' ?

And on that note, I highly stress to anyone getting started (or even old hands) to not try to artificially combine receipts for convenience. You could if you wanted to, but I guarantee, you'll want to 'refactor' some of those line items one day, or wish you could. Just enter receipts as mult

Re: [GNC] accounts receivable for rent..

On 3/5/22 10:32 AM, Michael or Penny Novack wrote: On 3/5/2022 4:03 AM, Adrien Monteleone wrote: On 3/5/22 12:50 AM, arthur brogard via gnucash-user wrote: We have only one property.  Only one tenant.  Simplest possible case I guess. I'm thinking I must: . Create an 'accounts

Re: [GNC] don't know..

On 3/5/22 2:26 PM, arthur brogard via gnucash-user wrote: Not sure if I'm doing this right.  Hitting 'reply' on the email address of a poster that I want to respond to and putting a 'cc' in for gnucash-user@gnucash.org I see some people's posts seem to have been made to 'list gnucash' or someth

Re: [GNC] reports

I think pretty much most if not all reports have the 'Accounts' tab in 'Options' where you select which accounts you want to report on. (the 'Account Report' being the one exception I can think of, since the account is already specified) You need to click the Options button on the toolbar, the

Re: [GNC] Keeping tenant accounts on Gnucash - periodic 'rent owing' ?

On 3/7/22 5:06 AM, flywire wrote: An invoice must be prepared for every rent due transaction and the payment processed. The 'preparing' is only the first time. After that, you just hit 'Duplicate' and enter the new posting date. 'Processing Payment' is how you apply a specific payment to a spe

Re: [GNC] Gnucash 3.8 Questions

The other questions were well answered, but I thought it important to mention about upgrading that you don't need to upgrade through each *minor* version, just the major versions. 3.x is a major version. 4.x is a major version. 5.x (due 2023) will be a major version. It is a good idea to upgra

Re: [GNC] Fwd: GnuCash page FAQ has been changed by Flywire

I second moving it to Using GnuCash. Regards, Adrien On 3/8/22 6:13 AM, D. via gnucash-user wrote: Geoff, Your points are valid. If we accept your assertions (and I'm willing to), my thinking is that this information might be better placed on the Using Gnucash page. David T. _

Re: [GNC] Changes in gnucash 4 vs 3

On 3/10/22 9:12 AM, Peter Ratzlaff wrote: Income accounts now have negative balances. Same for equity. Liability balance signs are flipped as well. That's a preference. Did other preferences not carry over? Investigate the Wiki for GnuCash storage locations and check to see if your preference

Re: [GNC] Changes in gnucash 4 vs 3

4.9 itself is a released version, but the packager may have built it against an earlier Ubuntu target, so it might not work properly. (the GnuCash team doesn't release .debs or maintain the Ubuntu repo version) Glad to hear you got it straight with a custom build. Maybe let the package maintai

Re: [GNC] How To Put Opening Balance in Acc Rev Account?

Usually entering manual transactions in the AR/AP accounts is discouraged because if you are using (or later decide to use) the Business Features, they will not see those transactions. The proper thing to do would be to Process Payment for the overpayment amount for the tenant (customer). Wh

Re: [GNC] How To Put Opening Balance in Acc Rev Account?5

Arthur, If you enter a negative amount into a register it will swap it to the other column. (debit/credit if using formal labels, left/right respectively otherwise - the labels change based on the account type.) The opening balance transaction should have been a credit (right column) to your

Re: [GNC] Script error message when searching

The attachment didn't come through. (it appears you're using Outlook and have an improper setting) But the search feature on the mailing list page does not work. Instead, you can view archives by topic, author, or time period. (and use your browser's Find feature from there) Or, you can go t

Re: [GNC] IRA/401K income detection

I could be missing something, but I thought that was already covered by one of the answers. Also, I'm pretty sure the proper place to record and track that is in an Asset account, not Equity. As for the transactions, if you need to do virtual 'extra tracking' beyond just the physical withdrawa

Re: [GNC] IRA/401K income detection

GnuCash also lets you mark accounts as tax implicated and you can I think tie them to certain 'lines' or certain 'forms'. That's used for personal taxes as well. I wasn't even thinking about the sales tax features for invoices/bills which is something entirely separate. If simply marking the

Re: [GNC] IRA/401K income detection

Good to know, thanks for the clarification. Regards, Adrien On 3/16/22 6:49 PM, D. via gnucash-user wrote: Oh, I know about using the tax flag and TXF report. Done it for years. But unless you figure out how to do what Mike has mentioned (consistently over the years), if you flag these accoun

Re: [GNC] IRA/401K income detection

And Stan has now given the breakdown of the splits to accomplish it. That would be followed up with: Dr. Liability:Taxes payable Cr. Checking when they are physically paid. Regards, Adrien On 3/16/22 7:54 PM, D. via gnucash-user wrote: Yeah, I get that an accountant doesn't call this income,

Re: [GNC] MySQL back-end access failed @ MACOS 12 after MySQL server upgrade to 8.0.28

You have to install MySQL/MariaDB on MacOS separately as far as I recall. (then save the file in that backend format) But before you go through all of that trouble, what advantages do you think you will gain by using the MySQL backend vs. XML or SQLite? Regards, Adrien On 3/16/22 8:31 PM, Ne

Re: [GNC] Question about Assemblies

If you're looking for 'inventory control/manangement' or 'item tracking' by quantity, no, GnuCash can't do it. (out of the box) Some people have finagled it to do so using user-defined commodity accounts, but that seems like more trouble than it is worth. Inventory management should be done i

Re: [GNC] MySQL back-end access failed @ MACOS 12 after MySQL server upgrade to 8.0.28

As John mentioned, the db name seems incorrect. Did you register the db on MacOS? Error 2026 deals with SSL certificate issues. A web search should provide some guidance. Maybe try without SSL to see if that resolves it? Then you can troubleshoot the SSL problem. - And again, why do you

Re: [GNC] Question about Assemblies

Fred, please be sure to always copy the list address on all replies so the discussion stays on the list. That way, others can benefit from the discussion, as well as chime in and help out. Also keep in mind, we don't give accounting advice here. If you need such advice, you need the services

Re: [GNC] Printing checks

Someone more familiar with printing checks will hopefully chime in, but I seem to recall a recent thread where it was noted that if your Vendor/Employee/Customer 'payee' is already set up with name and address, *and* you try to 'Print Checks' with the existing transaction selected, GnuCash *sho

Re: [GNC] gnucash-user Digest, Vol 228, Issue 33

As I noted in another reply today, if this is just a handful of products, you can likely set up a simple spreadsheet to do the assembly math for you, and then import the result to GnuCash. While spreadsheets aren't part of GnuCash, we can help with how to set that math up, and in a form ready

Re: [GNC] Question Re: Transaction Report on Expenses, All Children, for 2021

Fran, Do a bit of reading on 'Accrual' vs. 'Cash' accounting. The Business Features of GnuCash are designed for the Accrual method. With a bit of small fuss, they can be used for the Cash method too. Expenses in the Accrual method are 'recognized' when 'incurred'. That is, when you 'owe' the

Re: [GNC] How to create Transaction Report Filter on Checking to only show Accounts Payable Transactions?

Fran On the Accounts tab in Options for the report, choose "Filter Type: Include Transactions to/from Filter Accounts" and then in Filter By... choose the Accounts Payable account. You can further refine the results using the Filter tab, to specific Description/Notes/Memo as you are already

Re: [GNC] Report Help

The Account Summary is a snapshot, that's why it doesn't let you select a range. (similar to a Balance Sheet) Your other options are an Income Statement/P&L (which won't show anything but Expense & Income accounts) or perhaps an Equity Statement or the Balance Sheet which includes Equity, Asse

Re: [GNC] Report Help

I have some custom reports (not my own, from other users posted on this list) that have worked in 3.x. But they did need some tweaks to get them working in 4.x. This is due to changes in the report system. Also try to reach out on IRC. The devs hang out there (as well as here) and can assist m

Re: [GNC] Report - Income Statement - Layout problem

I can reproduce with 4.9 on BigSur. Investigating using Firefox Inspector to view the HTML, I see that there is padding being added to the Expenses section. For me, this only happens at depths 5,6, & ALL. It seems the left hand column where the labels are, is expanding to fit the depth of ac

Re: [GNC] Have you abandoned gnuCash email list? U were so helpful!

Yeah, I got one too. I'm still here of course. I took a break last fall, but have been fairly active since returning. Regards, Adrien On 3/21/22 3:17 PM, David Carlson wrote: Fran_3, I did not see your original message. Did you send it directly to Christopher instead of the list? That is

Re: [GNC] Have you abandoned gnuCash email list? U were so helpful!

It can, you just have to be mindful to make your posting dates (AR and AP) match your payment dates. This requires either delayed posting, (and losing the Due Reminders feature) or un-posting and re-posting as payments are made and received. Regards, Adrien On 3/21/22 4:00 PM, Michael or Pen

Re: [GNC] Report - Income Statement - Layout problem

sly doubt it as that affects overflow usually, not expanding something smaller. Regards, Adrien On 3/21/22 9:47 PM, Adrien Monteleone wrote: For me, this only happens at depths 5,6, & ALL. ___ gnucash-user mailing list gnucash-user@gnucash.org

Re: [GNC] GNC] Question about Assemblies

On 3/22/22 8:46 AM, davidvernonl...@gmail.com wrote: On your points, of course GnuCash can track costs of inventory in its G/L, but when it comes to recording inventory levels to manage a manufacturing business, quantities are really needed ,either in the system , or in an external system. As

Re: [GNC] new subaccounts and updating saved reports

Precisely. There's no way to know the user didn't intend to keep the new sub account out of the report. Certainly, the assumption should never be made to automatically include it. The best implementation I can think of would be to check if new accounts have been added since report last run,

Re: [GNC] How to apply overpayment to new invoice?

If you have both a pre-payment and an invoice unpaid, simply select both of them in the Process Payments window. If the net is zero then they will both be cleared out. If there is still pre-payment left, that remainder will be their next time. If there is still invoice left, it will continue t

Re: [GNC] Report - Income Statement - Layout problem

Carl-Kensaku, No need to dig into Scheme or HTML to fix this. The devs will address it soon enough I'm sure, but this is a 'presentation' issue. That can always be fixed in the short term by either exporting and opening in a spreadsheet, or Select-All & Copy/Paste to a spreadsheet. From th

Re: [GNC] Report - Income Statement - Layout problem

. Then simply multi-select and apply those styles to the relevant cells. The amount of setup work you need to do just depends on how you want it to look and how often you need to do this. Templates can help here considerably. Regards, Adrien On 3/23/22 12:34 PM, Adrien Monteleone wrote: Carl

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

Jonathan, You should be able to build a current version of Gnucash on your 32bit machine. See the instructions here: https://wiki.gnucash.org/wiki/Building And you can update to current on your 64bit machine to match. You might also be able to use the Flatpak if you don't want to build. (I

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

. If nothing works, consider possibly using RDP or VNC to your 64bit machine rather than a local install. Regards, Adrien On 3/24/22 8:00 PM, Adrien Monteleone wrote: Jonathan, You should be able to build a current version of Gnucash on your 32bit machine. See the instructions here:

Re: [GNC] Unable to obtain Price data

Les, Could be. I was having trouble with a freeze condition trying to Get Quotes two days ago. Sometimes gnc-fq-dump would return 'unknown' for currencies. Then it would work, then it wouldn't. (GnuCash would always freeze though) I just tried gnc-fq-dump again for several currencies and it

Re: [GNC] change default behavior of ctrl-PgDn

I don't think the date itself is relevant. What you want is to get to a new blank transaction, correct? I have the same problem using 4.9 on MacOS BigSur. I'm not sure when this started. As far as I know, there is no preference. There is a preference for using the 'Enter' key for this functio

Re: [GNC] change default behavior of ctrl-PgDn

Indeed, shift-fn-down_arrow drops me to a blank transaction with the focus on the date field. Thanks! I still think it a bug that the official key combo doesn't work properly. I thought one was filed already but can't seem to find it. Note, it isn't just the key combo not working. Using Actio

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

You want an application icon or for the individual data files (books)? The application is a bit of work if it is Flatpak, but I would think the data files should be no issue. Regards, Adrien On 3/25/22 2:38 AM, Jeff wrote: I have never had a problem creating desktop icons for multiple books f

Re: [GNC] change default behavior of ctrl-PgDn

Actions > Blank Transaction has cmd-pgdn as the key combo. I'd hazard it is ctrl-pgdn other than Mac. I recall now one of your replies in a previous thread or maybe a bug about this. And indeed shift-pgdn does bring you to the Blank Transaction with focus on the date field. But the one listed

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

I think David Whiting's reply should get you there. (I didn't notice it when I sent mine) If that doesn't work, report back what happens instead. Regards, Adrien On 3/25/22 6:24 PM, Jeff wrote: I would like to have individual icons that execute GNC for a specific set of books. IE: icon (GNC

Re: [GNC] Report - Income Statement - Layout problem

Carl-Kensaku, It looks like the fix has been implemented for v4.10 due out tomorrow. I just finished testing Chris's fix and so far it seems to do the trick. Your P&L/Income Statements should line up now regardless of the account depth or the length of account names. Regards, Adrien On 3/23

Re: [GNC] gnucash-user Digest, Vol 228, Issue 46

Eric, First, as a matter of 'safe', I'd always edit a transaction from the non-AR/AP account, that is, from your cash, check, et cetera account where the funds originated/ended-up. You *can* edit transactions in AR/AP, but you have to be careful about doing so. Chris' suggestion to use the Ed

Re: [GNC] Report - Income Statement - Layout problem

And there is always the Flatpak. So if you aren't comfortable with building, it is a bit easier to install. Since freeze on Ubuntu 22.04 Jammy has already happened (release targeted to 4/21/22), I doubt it will include GnuCash 4.10, lucky if it is 4.9. You *might* be able to get a special re

Re: [GNC] Customizing invoices

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 t

Re: [GNC] Customizing invoices (Helmut Eller

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] how to put loan downpayments in budgets

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

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

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] create desktop icons for GNC 4.9 Flatpak on Ubuntu

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) https://wiki.gnucash.or

Re: [GNC] Customizing invoices (Helmut Eller

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] how to put loan downpayments in budgets

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 accoun

Re: [GNC] Customizing invoices (Helmut Eller

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] creating a Tranaction report

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

Re: [GNC] Customizing invoices (Helmut Eller

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. (s

Re: [GNC] Customizing invoices (Helmut Eller

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 OPs

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

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 f

Re: [GNC] Loss one of my file

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] creating a Tranaction report

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

Re: [GNC] Stock pricing

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 can

Re: [GNC] Loss one of my file

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 fi

Re: [GNC] Loss one of my file

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] create desktop icons for GNC 4.9 Flatpak on Ubuntu - solved

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 resol

Re: [GNC] creating a Tranaction report

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 previousl

Re: [GNC] creating a Tranaction report

saved that 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

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

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 credit

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

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 a

Re: [GNC] Reconciliation discrepancies

What *exactly* do you mean by 'what GnuCash shows'? Where are you seeing this number that you are comparing to the bank, and what amount is this from the bank? (not the figures, but what is their term for this number?) Regards, Adrien On 4/11/22 4:36 PM, Rich Shepard wrote: Every now and t

Re: [GNC] Reconciliation discrepancies

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] Auto-save failure

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 mi

Re: [GNC] Scheduled transactions feature or bug?

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 di

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

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?

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 date

Re: [GNC] REPORT CONFIGURATION

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 als

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

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] Linux. Mysql and Gnucash 4.1

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

Re: [GNC] Linux. Mysql and Gnucash 4.1

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

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

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 her

Re: [GNC] Trouble opening ancient files

That first 2002 file is indeed ancient. (the 2005 file is no spring chicken either) For both cases, you’d have to find the ’newest’ version of GnuCash that will open each file, then upgrade GnuCash in steps (possibly some leaps skipping bug-fix releases) and open each file with each version. At

Re: [GNC] Training the classifier of imported transactions in GnuCash

Cliff, did you not see my reply or the one from Liz? Making the corrections *after* the import is never going to teach GnuCash how to match those transactions correctly. The corrections are to be done as part of the import matching process. The documentation covers this. See the Help Guide "§6.

Re: [GNC] Trouble opening ancient files

I’d suspect if you walked a bit more slowly through the versions, you wouldn’t get that message, but I can’t say that with certainty. Maybe the Tracefile has more info. (see the wiki about finding the Tracefile on your system) So you might have to step back from the original copy through the 2.x

Re: [GNC] New Bill: Bill ID vs Billing ID

Indeed, those two definitions (Invoice ID/Billing ID) are so similar as to be the same thing in probably most cases, especially for Vendors. I could see how they may be different from an AR perspective. (you may be importing invoices generated in an invoicing app that has its own numbering schem

Re: [GNC] New Bill: Bill ID vs Billing ID

Ah yes, I forgot that one. I can see that keeping your own internal ID and the Vendor’s might be desirable. So there’s another case. Fran, In case you missed that point, the reason ‘InvoiceID’ is ‘optional’ is because if you leave it blank, GnuCash will use the rules from Properties > Counter

Re: [GNC] Question marks instead of currency in reports

Your font probably doesn’t have that symbol. Check your custom CSS file and find a different font. I’d use either the Mac Character Viewer or Font Book to find a suitable one. It looks like that is Unicode 20B1. A simple search in Character Viewer for ‘peso’ brought it right up. Select the chara

Re: [GNC] Lost all data after install

#1 - if you indeed have a backup, then no information has been lost. #2 - What operating system?* Also, you mentioned ‘latest’ version of GnuCash. Is that 3.10? #3 - The LCK file is a lock file. Its very presence will normally trigger a warning when starting GnuCash (or opening that associated

Re: [GNC] Lost all data after install

First, please send replies to the list, not just me personally. That way others can help, and everyone can benefit from the discussion. (use reply-list or reply-all if that is easier) - The file can be located anywhere you want. It doesn’t need to be in a particular folder. If the previou

Re: [GNC] Disappearing entries

What operating system and what version of GnuCash? Note that changing just about anything in a transaction will unreconcile it, though this should not affect the balance. As for ‘missing’ transactions, do you ever use a filtered view? (I believe an indication the register is filtered will show

Re: [GNC] Question marks instead of currency in reports

Also, are you using a custom/modified stylesheet for the report with a different font for the totals? Regards, Adrien > On Jun 18, 2020 w25d170, at 1:20 AM, Christopher Lam > wrote: > > The only technical difference between regular lines and total lines is that > the latter is in bold. Try ch

Re: [GNC] Will Image Attachments go through the email list server?

In a worst case, use a free file host and post the link. Regards, Adrien > On Jun 18, 2020 w25d170, at 11:24 AM, Derek Atkins wrote: > > The list server will strip out HTML (with embedded images) and only send > through the text, but if you actually *attach* the file it'll make it > through. >

Re: [GNC] Style Sheets - general questions

You don’t even have to export to CSV. You can ’save’ the report which will be HTML formatted and open it in a spreadsheet app, or just copy/paste to a spreadsheet. If your are having issues with pagination/line-breaks, that is the way to go. There are some issues (especially on MacOS) with the

Re: [GNC] Style Sheets - general questions

I’ll add that extensive work is currently being done on many reports to improve them. (you can see some of these efforts in Reports > Experimental) But think of the GnuCash reports as getting you the basic form, and then if you want something different, export to spreadsheet and manipulate furt

Re: [GNC] Style Sheets - general questions

Interesting. I haven’t looked at the standard inline report CSS lately, so I didn’t realize there was a background specified. How is it interfering with adding columns in LO Calc? I’ll offer this: I always select the entire sheet (clicking that empty cell in both row/column headers) and remove

Re: [GNC] Style Sheets - general questions

> On Jun 19, 2020 w25d171, at 12:14 AM, flywire wrote: > >> How is it interfering with adding columns in LO Calc? > > Only different formatting. > >> select the entire sheet (clicking that empty cell in both row/column > headers) and remove *all* styling. > > No luck with that, Just selected

<    3   4   5   6   7   8   9   10   11   12   >