Re: [GNC] Finance Quotes Yahoo off the rails again?

2024-03-26 Thread Adrien Monteleone
David, What makes your messages that contain quoted material difficult to read is your e-mail client doesn't indicate they are quoted, so it all appears as your new message. There is also some wacky formatting going on. That isn't the mailing list software, that is your client as the culprit.

Re: [GNC] Can't enter expense transactions after migrating

2024-03-21 Thread Adrien Monteleone
Are you 'TAB'ing through the transaction or attempting to 'ENTER' through the transaction? ENTER *commits* the transaction and could possibly generate the warning/dialog you mention. TAB is the documented method for moving from one field to the next without committing the full transaction, a

Re: [GNC] Setting font sizes in reports (specifically in Transaction Report)

2024-03-11 Thread Adrien Monteleone
Here's the bug link: https://bugs.gnucash.org/show_bug.cgi?id=799248 Your attachment seems to be a printed version of the report, rather than an HTML 'export'. (Use the Export button on the toolbar, don't try to 'print to file') I'm spinning up a VM with 4.8 to confirm. As of 5.5 at least, th

Re: [GNC] Bill total does not match real total

2024-03-11 Thread Adrien Monteleone
I'm not sure if it is still entirely open source, but it started that way. I think they've added on features that are closed. (some may simply be built with Odoo itself) The base package is still available as far as I'm aware, and it is pretty powerful, but likely overkill for most small busine

Re: [GNC] Setting font sizes in reports (specifically in Transaction Report)

2024-03-11 Thread Adrien Monteleone
n the Account Name sharing a class that makes it non-obvious what to change. Regards, Adrien On 3/11/24 5:30 AM, Chris Green wrote: On Fri, Mar 08, 2024 at 12:01:01PM -0600, Adrien Monteleone wrote: Chris, Once again, look into Edit > Stylesheets. For the record, I'm using defaults,

Re: [GNC] Max value during year

2024-03-11 Thread Adrien Monteleone
You can take that same report and copy/paste into a spreadsheet, then set up a MAX() function in another cell to look at whatever column. (Balance, I would presume in this case) Some spreadsheet apps have a configurable 'stats' bar at the bottom that can show preset analysis, such as MIN, MAX,

Re: [GNC] Importing Reports into LO Calc

2024-03-09 Thread Adrien Monteleone
You can certainly set that as a style in Calc. Regards, Adrien On 3/9/24 9:01 PM, Robert Heller wrote: I think the OP's issue is the fact that Calc does not preserve the red coloring of the negative numbers. The red coloring of the negative numbers is something *GnuCash* is doing as a "good ac

Re: [GNC] I'm getting started in Gnucash and want to list each item that I buy from one merchant

2024-03-09 Thread Adrien Monteleone
I'm not certain what you are describing, but I'll hazard a guess that you are seeing GnuCash auto-balance the transaction. That is normal. Every transaction has to be balanced. (Debits *must* equal Credits) You are free to enter the transaction however you like, as long as that holds true. If

Re: [GNC] I'm getting started in Gnucash and want to list each item that I buy from one merchant

2024-03-09 Thread Adrien Monteleone
Neal, You are welcome. But please remember to hit 'reply-all' or 'reply-list' rather than just 'reply' so everyone on the list benefits and can participate in this discussion. Individual users may not always be able to help fully with any issue or question, others may have better answers or

Re: [GNC] I'm getting started in Gnucash and want to list each item that I buy from one merchant

2024-03-09 Thread Adrien Monteleone
You can certainly do so. The exact work flow can vary depending on your precise needs. I don't often have very long transactions (30 or more items) but it does happen a few times a year. I frequently have transactions with at least 5 or so 'splits'. I'd recommend experimenting with either Vi

Re: [GNC] Separating tax years for payments in next year

2024-03-09 Thread Adrien Monteleone
Why not create a transaction for the appropriate year between tax expense and tax payable? Dr. Expenses:FederalTax Cr. Liabilities:FederalTaxPayable Then when you actually pay, Dr. Liabilities:FederalTaxPayable Cr. Checking (or whatever source account) That way, the expense shows up for t

Re: [GNC] trying to use good gnucash billing in personal books

2024-03-09 Thread Adrien Monteleone
Liabilities and Accounts Payable are not Equity type accounts so they don't belong there. They both are of type 'Liability' generally and belong in that part of the tree, but specifically, the Accounts Payable account is the special type 'Accounts Payable' in the GnuCash Edit Account dialog.

Re: [GNC] Importing Reports into LO Calc

2024-03-09 Thread Adrien Monteleone
1. Export Report 2. Open Calc 3. Open the report file in Calc. Result is the report imported into cells based on the html table. or 1. Export Report 2. Open Calc 3. Click 'Sheet' Menu, then 'Insert Sheet from file...' and select the exported report file. Answer the dialogs, result is same as

Re: [GNC] Importing Reports into LO Calc

2024-03-08 Thread Adrien Monteleone
Abe, next time, please start a new thread by sending a new message to the list rather than replying to someone else's. As for how to get reports into Calc, I usually copy/paste, but you can also just 'open' the exported report, or you can 'insert sheet from file' into an existing workbook. (ag

Re: [GNC] Setting font sizes in reports (specifically in Transaction Report)

2024-03-08 Thread Adrien Monteleone
Chris, Once again, look into Edit > Stylesheets. For the record, I'm using defaults, and the is 12pt bold and the lines are 10pt normal weight. The total lines match the . Regards, Adrien On 3/8/24 3:41 AM, Chris Green wrote: Maybe I have set something somwhere without knowing it but the

Re: [GNC] Error Retrieving Gold Price for Price Database

2024-03-08 Thread Adrien Monteleone
But XAU no longer works with Alphavantage at least. GC=F (SI=F for silver) works fine. Regards, Adrien On 3/7/24 10:50 AM, Kalpesh Patel wrote: Oh! XAU symbol is indeed named Gold in Currencies name space which seems ... ___ gnucash-user mailing

Re: [GNC] How to get a report in a format which is easy to edit?

2024-03-06 Thread Adrien Monteleone
That is installed by default in Ubuntu for many years now. I would suspect the same is true of its various flavors. Regards, Adrien On 3/6/24 4:17 AM, Alan Hopkins wrote: You just need CUPS-PDF installed as a print driver for producing pdf files. _

Re: [GNC] How to get a report in a format which is easy to edit?

2024-03-06 Thread Adrien Monteleone
Chris, LibreOffice uses Draw for PDF editing, not Writer. That doesn't mean the text isn't text. Everything is essentially in various text boxes. But having used it quite a bit, I can attest it is way more of a pain for large edits than either HTML or using Calc. For a small change though, it

Re: [GNC] How to get a report in a format which is easy to edit?

2024-03-05 Thread Adrien Monteleone
Yes, those PDFs are indeed reasonably editable. Even LibreOffice can pull it off. Otherwise, your answer is to either edit the HTML (which is the native format of the reports once rendered) or put them in a spreadsheet which relieves you of the HTML and leaves you with rows and cells that are

Re: [GNC] How to get a report in a format which is easy to edit?

2024-03-05 Thread Adrien Monteleone
You can also select-all and copy/paste into a spreadsheet while viewing any report. Regards, Adrien On 3/5/24 10:43 AM, Chris Green wrote: Is there any way to get a report from GnuCash in some sort of editable format? I have tried various ways, including printing to file as a PDF but I always

Re: [GNC] How to get a report in a format which is easy to edit?

2024-03-05 Thread Adrien Monteleone
The standard export/save of reports is an HTML table. You can edit that with any decent text editor, and/or open/import it into a spreadsheet app for further manipulation. Regards, Adrien On 3/5/24 10:43 AM, Chris Green wrote: Is there any way to get a report from GnuCash in some sort of edi

Re: [GNC] How can I book Sales when invoice is paid vs when posted?

2024-03-05 Thread Adrien Monteleone
On 3/4/24 11:34 PM, Blake Hannaford wrote: 1) At end of year, figure out the total dollar amount of unpaid invoices. Check the Receivables Aging Report. This should give you the total you want. 2) Create a new Income account "unpaid sales" 3) Debit sales by the unpaid total and credit "unpaid

Re: [GNC] split transaction description field length limit

2024-03-04 Thread Adrien Monteleone
You could employ custom 'tags' for each property either in the Notes, Action, Num, Memo, or Description fields, whatever works best for you. Then when you run a Transaction Report, you can filter the results that match your tag. The only downside to this method, at this time, over setting up s

Re: [GNC] split transaction description field length limit

2024-03-04 Thread Adrien Monteleone
Your example doesn't really need the business features. You can do that with a single transaction too, and that isn't 'kludging' the memo fields at all. That is what they are intended to be used for—info relating to just that particular split. ('Notes' would be info relating to the transaction

Re: [GNC] Reports Options: Unexpected Behavior

2024-03-04 Thread Adrien Monteleone
When the income statement is first run, it is including the hidden account. (but is not supposed to) Toggling the radio button is apparently 'fixing' this to work as intended. Therefore since the initial behavior is not as designed, I'd call it a bug. I just tested this on a Mac and it is work

Re: [GNC] split transaction description field length limit

2024-03-04 Thread Adrien Monteleone
Combined with the other suggestions of an outside log file, using vendor bills, or using the Notes field, consider this: If you are advised of work as it occurs, record transactions between the expense accounts and a liability account named something like "Work Payable". Put your detail in eac

Re: [GNC] split transaction description field length limit

2024-03-03 Thread Adrien Monteleone
That log file can also be attached to the transaction in GnuCash. Also, explore using View > Double Line as that exposes a Notes field for the entire transaction. Regards, Adrien On 3/3/24 7:08 PM, Jim DeLaHunt wrote: I suggest a workaround: write in separate log document your detailed descr

Re: [GNC] Multiple Fiscal Years

2024-03-02 Thread Adrien Monteleone
I'm still not understanding what change you are referring to. In both 4.x and 5.x you can set your Accounting Period to a relative date or an absolute date such as Jul 1 2024 to Jun 30 2024 and when you run reports, choose relative dates such as 'Start/End of Accounting Period' or 'start/end o

Re: [GNC] Multiple Fiscal Years

2024-03-02 Thread Adrien Monteleone
Wow, an accounting period of 54 years? I'm not sure I'd ever need to do so, but glad to know it works! Regards, Adrien On 3/2/24 12:26 AM, Geoff wrote: Maybe I am missing something here, but I created a book with a start date of 1-Jan-1970 and an end date of 31-Dec-2024, keyed transactions da

Re: [GNC] Multiple Fiscal Years

2024-03-01 Thread Adrien Monteleone
What do you mean this was removed? I'm on 5.5 and I still see Relative & Absolute Accounting Period settings. Regards, Adrien On 3/1/24 4:45 PM, flywire wrote: With Gnucash V5 current year with a configurable day/month/year was removed and hard-coded as calendar year. Alternatives: 1. Ru

Re: [GNC] reports

2024-03-01 Thread Adrien Monteleone
The 'best' is up to you to figure out based on your needs and what you want to see or do with the spreadsheet. Three possibilities immediately come to mind: 1. Budget Report — Even without using GnuCash to budget, it can still show consolidated Actuals by period, quarter, year, etc. 2. Accou

Re: [GNC] Trouble importing bills via csv

2024-02-26 Thread Adrien Monteleone
Yes, if your field contains the separator character you should double-quote it, but *only* in that case. Id's, dates, et cetera will not, so no reason to quote them. The OP had quotes on most if not all fields and none of them were necessary. Regards, Adrien On 2/26/24 8:23 AM, Kalpesh Patel

Re: [GNC] Trouble importing bills via csv

2024-02-24 Thread Adrien Monteleone
There is the caveat, noted in that link, that if you use the same delimiter for your account tree as the CSV, then (and only then) do you need to enclose account references in double-quotes. (this is generally a CSV thing, not something specific to GnuCash) Regards, Adrien On 2/24/24 6:02 PM,

Re: [GNC] Net Assets

2024-02-24 Thread Adrien Monteleone
And I'm pretty sure there is a bug filed on it. Regards, Adrien On 2/24/24 2:14 PM, David H wrote: Thank you for that as I don't think that in 10 or more years of using Gnucash that I've realised that it is a drop down list :-) I've always been puzzled as to why it always shows a zero amount f

Re: [GNC] Removing Scheduled Transaction From a Closed Year

2024-02-24 Thread Adrien Monteleone
That would be: Preferences > Scheduled Transactions > Since Last Run > Run when data file opened. So you want a dialog box to confirm the preference each time? What's the point of the preference then? Regards, Adrien On 2/24/24 2:03 PM, David H wrote: Strikes me that it wouldn't be a bad

Re: [GNC] Trouble importing bills via csv

2024-02-24 Thread Adrien Monteleone
Although you should be able to have header row(s), perhaps remove it and try again. The Documentation for this is worded oddly, but the samples provided don't show header info at all. https://www.gnucash.org/docs/v5/C/gnucash-guide/busnss-imp-bills-invoices.html Regards, Adrien On 2/24/24 1

Re: [GNC] Running mixed versions (okay?)

2024-02-24 Thread Adrien Monteleone
There are some changes between major versions. There are checks silently run when you first open your file with a new major version. You can run those checks explicitly via Actions > Check & Repair. The goal is usually to keep compatibility between the last minor release of a major version and

Re: [GNC] Removing Scheduled Transaction From a Closed Year

2024-02-23 Thread Adrien Monteleone
Stan gave you the answer, but also, please just start a new e-mail to the group when beginning a topic. It looks like you hit 'reply' on someone else's topic to start your own. I'll add to Stan's answer that other than deleting the Scheduled Transactions, if you are going to be in the habit of

Re: [GNC] How to fix error note on receivable aging report?

2024-02-23 Thread Adrien Monteleone
Note in the 2nd screenshot (of the register) that the 'type' column shows a "?". That's not supposed to happen, and you aren't supposed to be able to change it from the register. I don't know exactly what caused it, but for sure, there are problems with your Credit Note. Normally, an invoice

Re: [GNC] Install of GNC fails on Flatpak

2024-02-23 Thread Adrien Monteleone
Jeffrey, you referenced Snap, then Flatpak. I'm guessing the 'snap' was a mental typo. What are the commands you are using to install GnuCash via Flatpak? Regards, Adrien On 2/23/24 1:14 AM, jeffrey black wrote: I'm having to do this via my cell phone so please excuse typos. I had a complete

Re: [GNC] ANNOUNCE: gnucash-5.5-1.setup.exe

2024-02-22 Thread Adrien Monteleone
s location or to the main release location. Gmail does not show me the announcement that this thread follows. On Wed, Feb 21, 2024 at 9:35 PM Adrien Monteleone < adrien.montele...@lusfiber.net> wrote: I thought John made that pretty clear in the initial post of this thread. Regards, Adrien

Re: [GNC] ANNOUNCE: gnucash-5.5-1.setup.exe

2024-02-21 Thread Adrien Monteleone
I thought John made that pretty clear in the initial post of this thread. Regards, Adrien On 2/21/24 6:00 PM, David Carlson wrote: Was there an annoumcement about who should try this and whrre to find it? ___ gnucash-user mailing list gnucash-user@g

Re: [GNC] ANNOUNCE: gnucash-5.5-1.setup.exe

2024-02-21 Thread Adrien Monteleone
I'm pretty sure that release was to fix a Windows-specific issue. Pre-compiled Linux versions are available from various distributions. Otherwise, a flatpak is also available if you need something more recent than your distro's repo. Regards, Adrien On 2/21/24 4:50 AM, hc.stoellinger wrote:

Re: [GNC] Can't open old GnuCash file

2024-02-17 Thread Adrien Monteleone
Incremental updates, yes, but you jumped 4 major versions and skipped those incremental updates. The recommended process (in the wiki FAQ) is to upgrade in steps to each of the final releases of each major release, running Actions > Check & Repair > Check & Repair All upon first opening the fi

Re: [GNC] GNC UI problem...

2024-02-11 Thread Adrien Monteleone
I see now, these are likely replies to a digest that result in thread splitting. Regards, Adrien On 2/11/24 10:11 AM, Adrien Monteleone wrote: Not just Gmail. I replied too early to this thread before realizing it was split in 3 parts. Or maybe someone using Gmail is causing them to split

Re: [GNC] Repeatable crashes with 4.14 on 32-bit arm Linux

2024-02-11 Thread Adrien Monteleone
Under Preferences > Register > Reconciling there is "Automatic Credit Card Payment" For some other accounts (Liability type I think) in the account Edit screen there is an "Auto Interest Transfer" checkbox. Regards, Adrien On 2/11/24 8:02 AM, Robert Heller wrote: Can these dialogs be disabl

Re: [GNC] GNC UI problem...

2024-02-11 Thread Adrien Monteleone
Not just Gmail. I replied too early to this thread before realizing it was split in 3 parts. Or maybe someone using Gmail is causing them to split... Regards, Adrien On 2/10/24 2:07 PM, David Carlson wrote: In my Gmail these threads are getting disconnected. Gmail doesn't seem to know what t

Re: [GNC] GNC UI problem...

2024-02-11 Thread Adrien Monteleone
Robert, You can only size columns with the right-handed border in the header. To make them wider, click one and drag it to the right. To auto-size to 'fit' the content, double left-click a header. (any OS) Resize all columns other than Description first, then either double left-click the Des

Re: [GNC] New user error

2024-02-08 Thread Adrien Monteleone
Nice. I'm using 5.4 and it shows all transactions. I learn something new every day. Thanks! Regards, Adrien On 2/8/24 12:41 PM, Stan Brown (using GC 4.14) wrote: On 2024-02-08 08:59, Adrien Monteleone wrote: I'm aware of the report. There is also Tools > General Journal where

Re: [GNC] New user error

2024-02-08 Thread Adrien Monteleone
y Novack wrote: On 2/7/2024 11:11 PM, Adrien Monteleone wrote: Michael, Transaction Journal View is simply the same full transaction accessible via either 'Split' or 'Auto-Split' but for all transactions - *not* one at a time. Yes of course, can have on your screen "jo

Re: [GNC] New user error

2024-02-07 Thread Adrien Monteleone
No, you're not seeing the entire transaction in the view you are using, so you think you need to enter both splits as separate lines. That's not how GnuCash works by default and had you read the manual, you'd know this. If you want to see both splits in a simple transaction, you need to use Vi

Re: [GNC] New user error

2024-02-07 Thread Adrien Monteleone
Michael, Transaction Journal View is simply the same full transaction accessible via either 'Split' or 'Auto-Split' but for all transactions - *not* one at a time. Regards, Adrien On 2/7/24 4:26 PM, Michael or Penny Novack wrote: IF you select "journal view" you can enter transactions that

Re: [GNC] Import CSV settings location

2024-02-07 Thread Adrien Monteleone
They aren't in the data file itself, I don't think. Check the Wiki for 'File Locations' which describes the various directories used by GnuCash to store various settings, reports, and other bits. Copy those over from Computer A to B as needed. Regards, Adrien On 2/7/24 8:57 AM, Aryeh Gielchin

Re: [GNC] New user error

2024-02-07 Thread Adrien Monteleone
In both situations where you provided screenshots (Equity & Expenses) you have recorded equal and offsetting transactions, which balance to ZERO, which is why you see $0.00 on the Accounts tab. (note the respective account balance columns - that is what is reported on the Accounts tab) While

Re: [GNC] 'Total Period' shows 'Total' for one bank account

2024-02-03 Thread Adrien Monteleone
Not sure what you mean by 'un-commented'. There were a few message exchanges in each thread, though there was no resolution for any of them. I have the column turned on and I haven't noticed it not working properly, but I also haven't had any cases like yours or those in the other threads that

Re: [GNC] How can I visualize financial spending in gnucash?

2024-02-03 Thread Adrien Monteleone
That's a fairly broad question, and I'm not clear *exactly* what you mean by 'visualize' 'map out' and 'tweak'. GnuCash does have a Budget module that works much like a spreadsheet. Various Reports, Charts & Graphs are available based on the budget and can compare actuals as well as show varia

Re: [GNC] 'Total Period' shows 'Total' for one bank account

2024-02-02 Thread Adrien Monteleone
I found two threads: https://lists.gnucash.org/pipermail/gnucash-user/2023-January/104675.html https://lists.gnucash.org/pipermail/gnucash-user/2023-December/109930.html It seems there has been an issue with this column for at least a year, or it is working as intended, just not as expected.

Re: [GNC] 'Total Period' shows 'Total' for one bank account

2024-02-01 Thread Adrien Monteleone
This sounds familiar. Perhaps search the last few months of the list archive for 'Total(Period)' and you should find at least one more thread on this. It might be a bug. (and may be already filed, so a search on Bugzilla would be in order.) Regards, Adrien On 2/1/24 5:51 AM, G R Hewitt wrote:

Re: [GNC] SX

2024-01-31 Thread Adrien Monteleone
It works when I right click on the calendar and then as I move around a pop-up that follows the mouse changes to show SX info, or none, accordingly. Regards, Adrien On 1/31/24 8:27 AM, Gyle McCollam wrote: IIRC the calendar in SX used to show what transactions were due on each day when you mo

Re: [GNC] End of year

2024-01-30 Thread Adrien Monteleone
Michael, if I recall correctly, the OP was bifurcating their checking account *every year*. That is: Checking -2022 -2023 -2024 -etc. As a result (the same would happen with a new file), they were losing the benefits of auto-complete. The only workaround for that is simply don't star

Re: [GNC] End of year

2024-01-30 Thread Adrien Monteleone
You can't. I thought we described that already. If you start a new file/account each year, you will lose all auto-complete from the previous year's entries. The auto-complete list is generated on the fly from the other transactions in the register you have open at that time. If that register

Re: [GNC] How do you record the rounding of your netpay?

2024-01-29 Thread Adrien Monteleone
Yep, this is the 'principle of materiality' in accounting. The precision as to what is considered 'material' or not varies by entity, thus, some corporations don't even blink until a number gets into the $10k or even higher range. My personal rule is that if the amount is worth less than how

Re: [GNC] Receipt scanners and software

2024-01-26 Thread Adrien Monteleone
If by 'receipt scanners and software' you mean something that can OCR an image of a receipt and magically turn it into a transaction, then the answer is, "None." There is such software out there to allegedly perform such magic (I've never seen it in action) but if it can output either a CSV or

Re: [GNC] No suitable backend was found

2024-01-25 Thread Adrien Monteleone
That message is usually indicating you have the file saved in a database format rather than the default XML, and you don't have the proper database drivers installed. If you recently tried to save your file in one of those formats, this could be the cause. If not, then someone else might have s

Re: [GNC] Unable To Get Reports

2024-01-25 Thread Adrien Monteleone
There are known issues with reports on Windows with version 5.5. To get reports working again, roll back to v5.4. However, that version on Windows leaves an extra running process when you quit GnuCash. You can either just safely quit that process if it bothers you, or leave it be. (not sure if

Re: [GNC] Compare two sets of accounts?

2024-01-21 Thread Adrien Monteleone
And on MacOS, you have to use the full path into the app package, so assuming you installed in the system Applications directory: /Applications/Gnucash.app/Contents/MacOS/Gnucash --nofile would be the full command. Regards, Adrien On 1/21/24 10:17 AM, Fred Tydeman wrote: On Linux, on the com

Re: [GNC] QIF import ignore account

2024-01-21 Thread Adrien Monteleone
Michael, that is generally true and I'll hazard specifically true with respect to XML files. But MS does have some things they refuse to let you open with browsers other than Edge. It is a source of contention in the tech world and there are plenty of blogs and articles about it. As far as I am

Re: [GNC] QIF import ignore account

2024-01-20 Thread Adrien Monteleone
Yes, but why would a browser be involved at all? Perhaps that line in the tracefile was not pertinent to the particular issue at hand, and/or something else is amiss. Regards, Adrien On 1/20/24 5:38 PM, Geoff wrote: Beats me - apart from being the default Windows browser???

Re: [GNC] QIF import ignore account

2024-01-20 Thread Adrien Monteleone
There are various apps and services to convert QIF to CSV. Perhaps try one and see if that produces a better result. Regards, Adrien On 1/20/24 5:36 PM, Fred Tydeman wrote: I am getting the QIF file from Quicken for DOS v8.7 of 1996. It can only export as QIF. ___

Re: [GNC] QIF import ignore account

2024-01-20 Thread Adrien Monteleone
Why is Edge involved at all? Regards, Adrien On 1/20/24 5:02 PM, Geoff wrote: When I try importing that file into GnuCash 5.5 it crashes silently, and the trace file contains just one line: * 09:56:13  WARN Failed to open application manifest `C:\Program Files\WindowsApps\Microsoft.Microso

Re: [GNC] QIF import ignore account

2024-01-20 Thread Adrien Monteleone
The Wiki has information on tracefiles. (and crash dumps) Start with the tracefile. Also, running from command line can offer some feedback. Regards, Adrien On 1/20/24 4:33 PM, Fred Tydeman wrote: If there is some trace or dump file that I should be looking for, I do not know what/where it is

Re: [GNC] Compare two sets of accounts?

2024-01-19 Thread Adrien Monteleone
Along with the idea of exporting your present book via CSV, when you get back the file from the accountant, export that book as CSV too. Then do a diff on the CSV files. Those should be less messy to read than the XML. You could then take the diff results as a CSV and import them. Regards, Ad

Re: [GNC] Ssh Xforwarding works for app but not for help

2024-01-19 Thread Adrien Monteleone
If I'm not mistaken, those entries now simply attempt to open a web browser. If your container doesn't have one, then I would expect nothing to happen. Regards, Adrien On 1/19/24 12:41 PM, G McAlister wrote: I'm using Opensuse Leap 15.5 in a Proxmox lxc container to run the gnucash app. I can

Re: [GNC] Liability Balances - All payments disappeared

2024-01-18 Thread Adrien Monteleone
Yes, this is an example where it isn't just the terminology of users, but rather that the UI uses the term 'split' for two different meanings. I too have memo transactions with only one split and no value. Regards, Adrien On 1/18/24 1:45 PM, Stan Brown (using GC 4.14) wrote: Don't forget, cha

Re: [GNC] Liability Balances - All payments disappeared

2024-01-18 Thread Adrien Monteleone
Perhaps. But does that translate well to the Basic View mode when there are 3 or more debits/credits? Regards, Adrien On 1/18/24 1:53 PM, Eric Chapman wrote: FWIW: How about "Simple transactions" (with one debit & one credit) and "Compound transactions" (those with more than one debit or mor

Re: [GNC] Terminology WAS: Liability Balances - All payments disappeared

2024-01-18 Thread Adrien Monteleone
That is how I currently understand it. When I use 'a split' I mean a single debit or credit. When I use 'split transaction' I mean a transaction that has 3 or more combined debits/credits. Regards, Adrien On 1/18/24 1:43 PM, David T. via gnucash-user wrote: The Gnucash community has had thi

Re: [GNC] Liability Balances - All payments disappeared

2024-01-18 Thread Adrien Monteleone
Ah yes, another case of 'split' and I have lots of those! - For the record, Transaction Journal view shows each debit and credit and the Memos for each. Double-Line shows the Notes field and is independent of Transaction Journal view. Regards, Adrien On 1/18/24 1:28 PM, Patrick James w

Re: [GNC] Liability Balances - All payments disappeared

2024-01-18 Thread Adrien Monteleone
Fair enough. We need a new term for one of these things. It is a repeated source of confusion & consternation. Regards, Adrien On 1/18/24 9:54 AM, Michael or Penny Novack wrote: Except I would never refer to a transaction that affect JUST TWO accounts to have any "splits". When I use the term

Re: [GNC] Enhancement: Future sched txn update if updated template.

2024-01-18 Thread Adrien Monteleone
The OP referenced an adjustment for inflation, so it seems like simply upping various amounts. Hence my suggestion to leave the template with the current amounts, and add a variable multiplier which will be prompted by GnuCash. But that suggestion didn't take into account creating transaction

Re: [GNC] Enhancement: Future sched txn update if updated template.

2024-01-18 Thread Adrien Monteleone
Apologies for my confusion. Regards, Adrien On 1/18/24 3:09 AM, David H wrote: I don't think I suggested you thought otherwise but since you've quoted me in your reply you must think that I did. I was simply replying to Gyles comment along the lines of the following. Regards David H. Instead

Re: [GNC] F::Q Interface to GNC for pricing update

2024-01-17 Thread Adrien Monteleone
Indeed yes, see the GnuCash Manual §8.6 Price Editor: https://lists.gnucash.org/docs/C/gnucash-manual/tool-price.html Regards, Adrien On 1/17/24 5:32 PM, Kalpesh Patel wrote: Looking at the data structure returned by F::Q that is consumed by GNC, am I correct in understanding that GNC is curre

Re: [GNC] F::Q Interface to GNC for pricing update

2024-01-17 Thread Adrien Monteleone
I'm pretty sure the answer to that is yes, as I seem to recall this question in the distant past, but things may have changed since then. Regards, Adrien On 1/17/24 5:32 PM, Kalpesh Patel wrote: Looking at the data structure returned by F::Q that is consumed by GNC, am I correct in understandi

Re: [GNC] Enhancement: Future sched txn update if updated template.

2024-01-17 Thread Adrien Monteleone
David, Are these still just scheduled or are they created and in the registers, but simply dated in the future? If they are still scheduled but not created, then changing the template will alter them when they do fire. If they are already created, there is no solution but individual manual

Re: [GNC] Enhancement: Future sched txn update if updated template.

2024-01-17 Thread Adrien Monteleone
You can't. They are already created. The solution is don't create them in advance. Otherwise, you are left with the tedium of manually editing each one individually. I doubt the result of an SX has any link or record at all that it was created that way, much less has any tie to the template

Re: [GNC] Enhancement: Future sched txn update if updated template.

2024-01-17 Thread Adrien Monteleone
I understood the OP referenced already created future transactions. No matter what, those have to be manually and individually edited because they were already created. I can't imagine an auto-updating template being implemented. The solution would be to use a variable, and then not have them

Re: [GNC] Liability Balances - All payments disappeared

2024-01-17 Thread Adrien Monteleone
A little more detail to what Michael is asking for: While viewing the Checking account register, click on View > Transaction Journal. That will show all splits in all transactions. What you should see for each payment is a debit (left column amount) to the respective credit card account, and

Re: [GNC] Enhancement: Future sched txn update if updated template.

2024-01-16 Thread Adrien Monteleone
You can use variables, thus if you alter your templates to use an inflation multiplier, you future proof the template. GnuCash will prompt you for that variable value each time the SX fires. Simply enter your new multiplier as desired. Regards, Adrien On 1/16/24 5:18 PM, David G. Pickett via

Re: [GNC] "Make PDF" button just prints

2024-01-16 Thread Adrien Monteleone
If Win7 is still supported by GnuCash as a target, then I can see keeping it, but Win10+ has had Print to PDF built-in by default. Would it be possible to change the button to 'print' to that device on any OS directly, bypassing Webkit for that purpose? Regards, Adrien On 1/16/24 2:06 PM, Ge

Re: [GNC] "Make PDF" button just prints

2024-01-16 Thread Adrien Monteleone
I think that has something to do with the mess of Webkit versions between Mac, Win, & *nix. If I recall correctly, the button was left for a future fix, but set to bring up the printer dialog for now which can then use the system PDF 'printer'. Since all three operating systems now have this fe

Re: [GNC] Idiot 101 question

2024-01-16 Thread Adrien Monteleone
Chris, It has been a few years since I played with it, but I helped set up WINE for someone precisely for an ancient Epson Scanner. (and that was with an old version of WINE which has come a long way recently) You might be able to ditch that VM. Regards, Adrien On 1/16/24 3:41 AM, Chris Gre

Re: [GNC] Idiot 101 question

2024-01-16 Thread Adrien Monteleone
You can likely skip a few links in that chain with FreeDOS in a VM or another open version of it. Regards, Adrien On 1/16/24 10:07 AM, Fred Tydeman wrote: This is the only way I know to still run 16-bit DOS programs They will NOT run under recent Microsoft Windows (except maybe in DOS Box). Q

Re: [GNC] Deferred Income << the general case is "imputed income"

2024-01-16 Thread Adrien Monteleone
I'm thinking of a case where someone starts using GnuCash either at the point they start taking disbursements or after. I'm about to help a family member in that exact situation. While Deferred Income wasn't tracked along the way, I'll set up the account with the present total as an opening ba

Re: [GNC] Importing from one gnucash file to another

2024-01-16 Thread Adrien Monteleone
I've never used it myself, but I recall a discussion when the feature was added, I think for 4.x but it could have been earlier. Regards, Adrien On 1/16/24 5:16 AM, David H wrote: James, I may be mis-remembering but I seem to recall when importing txns some time ago there was a checkbox or op

Re: [GNC] Idiot 101 question

2024-01-15 Thread Adrien Monteleone
I was referring to the process of turning a running Windows installation into a VM from within that running installation. I know VMWare has such a tool, and I think Virtualbox does as well. (other virtualization solutions might too, and still yet, there might be 3rd party tools to accomplish th

Re: [GNC] Feature request: Import assistant, room for big improvements

2024-01-15 Thread Adrien Monteleone
And I would call 'Amazon' the Description as Payee, and the Memo as the item/reason for a particular split. I use Notes for info pertaining to the entire transaction. Would a multi-line CSV per transaction allow for inserting Memos? Regards, Adrien On 1/15/24 10:17 PM, Derek Atkins wrote: No

Re: [GNC] Deferred Income

2024-01-15 Thread Adrien Monteleone
I'm not familiar with the use case, but if you want income to 'go up' that is, show you received it, then it should be a credit. I'll hazard a guess that since you have a 'Taxable' account, which you are supposed to show receipt of income, then that one should be a credit. If the Deferred Inc

Re: [GNC] How do you record the rounding of your netpay?

2024-01-15 Thread Adrien Monteleone
That sounds like an accrual situation. If they are consistently owing you, then use an asset account. If you are consistently owing them, use a liability account. You could name it 'Payroll Rounding Accrual' or something similar. If the rounding bounces back and forth between asset and liabili

Re: [GNC] how to encode ATM withdrawals with fees

2024-01-14 Thread Adrien Monteleone
It looks like you are missing the Fee JPY split. What you are showing in the splits is that PHP4282.49 = JPY1, but that's not what you listed in 'facts'. That shows PHP4282.29 = JPY10110. I'm guessing your Fee expenses account is in PHP. If so, you have a few choices: 1. Create a Fee JP

Re: [GNC] FAQ (WAS: End of Year?)

2024-01-14 Thread Adrien Monteleone
I agree. I think part of this is UI design choices. It isn't that GnuCash made wrong ones, but rather that folks might be more familiar with other design patterns. These might also be the folks that don't like to read manuals. They are never going away, though some may eventually relent and c

Re: [GNC] register auto-complete

2024-01-13 Thread Adrien Monteleone
That is interesting. Is this only for Descriptions or for Memos & Notes too? *there is no preference. Bugs and kinks are being worked out though. This sounds like a bug, as I doubt that would be intended behavior. (it certainly isn't reasonable to expect, that I can see) Regards, Adrien On

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