Re: [GNC] Transaction Report Preference missing?

2019-01-16 Thread David T. via gnucash-user
-reversed amounts, which means the grand total for all accounts for any specified period would always be $0 thanks to the accounting equation. Bank $100 -$50Income -$100 (subtotal negative)Expense $50Grand total $0 On Thu., 17 Jan. 2019, 00:34 David T. On Jan 16, 2019, at 7:29 PM, David T. via gnucash

Re: [GNC] Tax Issues

2019-01-16 Thread David T. via gnucash-user
This sounds like bug #796687, which had been discussed on gnucash-devel recently.  David On Thu, Jan 17, 2019 at 7:45, John Ralls wrote: > On Jan 16, 2019, at 2:40 PM, Mike stagl wrote: > > For what its worth, I updated to Gnucash 3.4 on both a Debian 9 machine and a > Windows 7

Re: [GNC] "Save Report Configuration" Crashes GnuCash and Tr

2019-01-16 Thread David T. via gnucash-user
AT, journal, etc.) I dunno. > > Unfortunately, I no longer remember the exact issues, but certainly, > correcting the text in the file in my cases, (I could load the entire file in > a text editor) restored access to my data and got the OS to report the real > file size. &g

Re: [GNC] Transaction Report Preference missing?

2019-01-16 Thread David T. via gnucash-user
for any specified period would always be $0 thanks to the accounting equation. Bank $100 -$50Income -$100 (subtotal negative)Expense $50Grand total $0 On Thu., 17 Jan. 2019, 00:34 David T. On Jan 16, 2019, at 7:29 PM, David T. via gnucash-user > wrote: > > Chris, > > Thank y

Re: [GNC] "Save Report Configuration" Crashes GnuCash and Truncates saved-reports-2.8

2019-01-16 Thread David T. via gnucash-user
, David > On Dec 29, 2018, at 9:31 PM, Geert Janssens > wrote: > > Hi David, > > A very disturbing situation to be in. > > I think the first step is to narrow down the possible issues. > > Op zaterdag 29 december 2018 16:18:43 CET schreef David T. via gnucash-user: &

Re: [GNC] Transaction Report Preference missing?

2019-01-16 Thread David T. via gnucash-user
Chris, I do note one issue with the new transaction report: it doesn’t seem to utilize the Sign Reverses option—at least, not that I can see. Cheers, David > On Jan 16, 2019, at 7:29 PM, David T. via gnucash-user > wrote: > > Chris, > > Thank you for the lead. >

Re: [GNC] Transaction Report Preference missing?

2019-01-16 Thread David T. via gnucash-user
t; > Please file a bug, and screenshot a sample report, anonymised; please enable > 'General / Add options summary' to display options used. > > Also, https://bugs.gnucash.org/show_bug.cgi?id=795064 > > Thank you for finding these edge cases. > > C > > > On 16/1

Re: [GNC] Australian Stock Quotes

2019-01-16 Thread David T. via gnucash-user
Norman, Glad to help. In the future, be sure to “Reply All” so that your message gets back to the list. That way, everyone gets to hear the denouement. David > On Jan 16, 2019, at 5:35 PM, Norman Jessup wrote: > > Thanks David, > > This is very helpful > > regards, > > Norman Jessup > >

[GNC] Transaction Report Preference missing?

2019-01-16 Thread David T. via gnucash-user
Hello, Long time user; MacOS Mojave, GnuCash 3.4. I have a saved report I use around this time of year (I call it “W-2 - David”) that shows me the total amounts assigned to a subset of my expense accounts (i.e., my tax expense accounts). The purpose of this report is to allow me to compare my

Re: [GNC] Australian Stock Quotes

2019-01-16 Thread David T. via gnucash-user
Norman, While the “FinanceQuote Update” module might not have been changed since 2010, *Finance Quote* (which actually performs quote retrieval for GnuCash) most certainly has been updated numerous times since then. If you *run* “FinanceQuote Update,” it will … update Finance Quote for you.

Re: [GNC] Copy a month's budget

2019-01-12 Thread David T. via gnucash-user
I’ve said it before: I dislike bottom posting because I have to scroll through everything that has been written on the thread just to get to the single pithy comment that is new. This is especially annoying when attempting to read email on a small screen. I will admit that I prefer bottom

Re: [GNC] Different jobs for vendor or customer?

2019-01-10 Thread David T. via gnucash-user
Andrew, I hope Gnucash will give you years of accounting bliss... I can't answer the first question, since I do not use business features.  The second sounds like you're asking for something like Quicken's Classes, which is a common request that no one has implemented in Gnucash. Yet? Without

Re: [GNC] Tracking Reimbursable Medical Expenses

2019-01-04 Thread David T. via gnucash-user
Of course, one could implement an accounts receivable structure without using the business features. The user would create the appropriate accounts, and add transactions to document things manually.  On Sat, Jan 5, 2019 at 4:14, David Cousens wrote: Aaron, The Answer is yes but to use

Re: [GNC] restoration from backup not working

2019-01-02 Thread David T. via gnucash-user
From within gnucash, use File->Open. Double clicking doesn't work on MacOS. On Thu, Jan 3, 2019 at 12:31, Eliot Rosenbloom wrote: Hey - I want to get rid of the entries I did today (1/2/19) and revert back to my last backup (12/20/18).  When I double click on

Re: [GNC] Tutorial for moving stock between accounts?

2019-01-02 Thread David T. via gnucash-user
Well, now that you have it mostly right, maybe go in to the second account register and see whether you can change the second split price to zero from there, using the same tabbing technique.  On Thu, Jan 3, 2019 at 12:23, Jon Leech wrote: On Wed, Jan 02, 2019 at 05:38:13PM +0530, D

Re: [GNC] Tutorial for moving stock between accounts?

2019-01-01 Thread David T. via gnucash-user
What part of creating a transaction that moves shares from the old account to the new account does not work? It would seem to me that: Old account decrease 100 sharesNew account add shares Would work just fine.  David T. On Tue, Jan 1, 2019 at 14:34, Jon Leech wrote: David Cousens

Re: [GNC] Adding an exchange to the list of exchanges

2018-12-31 Thread David T. via gnucash-user
I am not at my computer to verify, but I understand that this field is a simple text field with a combo box drop down based on prior entries.  In other words, you can type your own entry into the field.  David T. On Tue, Jan 1, 2019 at 8:50, David Cousens wrote: Hi, GnuCash v 3.4. I am

Re: [GNC] Tutorial for moving stock between accounts?

2018-12-31 Thread David T. via gnucash-user
Jon,  David C. makes one suggestion. I would ask whether the destination account is also denominated in the selected stock. If not, then gnucash will convert between different commodities (e.g., between shares of stock and USD). David T. On Tue, Jan 1, 2019 at 7:46, Jon Leech wrote:

Re: [GNC] Location of GnuCash data files

2018-12-31 Thread David T. via gnucash-user
Been done.   https://gnucash.uservoice.com/forums/101223-feature-request/suggestions/1470507-configuration-option-for-backup-location On Mon, Dec 31, 2018 at 23:18, Stephen M. Butler wrote: On 12/31/18 9:29 AM, Stan Brown wrote: > Under "Uddating advice", I believe Finbar Mahon wrote: >

Re: [GNC] Fractional prices

2018-12-30 Thread David T. via gnucash-user
I believe there's a preference for this. Have you set it? On Mon, Dec 31, 2018 at 9:47, Walt Mankowski wrote: On Sat, Jul 21, 2018 at 06:37:56AM -0700, John Ralls wrote: > > > > On Jul 20, 2018, at 11:35 AM, David Jordan > > wrote: > > > > Hi. I have just downloaded v. 3.2. The

Re: [GNC] A DIFFERENT Crash!

2018-12-29 Thread David T. via gnucash-user
w, or a report’s options. > Both will cause this crash. > > I’ll note that this doesn’t address my longstanding troubles with the reports. > > David > >> On Dec 29, 2018, at 8:54 PM, David T. via gnucash-user >> wrote: >> >> Hello, >> >&g

Re: [GNC] Gnucash 3.3

2018-12-29 Thread David T. via gnucash-user
It looks like you have submitted the same message twice. You shouldn’t do that. Try taking a look at https://bugs.gnucash.org/show_bug.cgi?id=796879 to see if the fixes mentioned there help out. David > On Dec 29, 2018, at 9:07 PM, Thomas Hill

Re: [GNC] A DIFFERENT Crash!

2018-12-29 Thread David T. via gnucash-user
options. Both will cause this crash. I’ll note that this doesn’t address my longstanding troubles with the reports. David > On Dec 29, 2018, at 8:54 PM, David T. via gnucash-user > wrote: > > Hello, > > Having just finished sending in my problem with reports crashing GnuCash

[GNC] A DIFFERENT Crash!

2018-12-29 Thread David T. via gnucash-user
Hello, Having just finished sending in my problem with reports crashing GnuCash, I encountered a completely new crash when I attempted to access the preferences while GnuCash was in fullscreen mode. GC3.3, MacOS Mojave. THIS crash at least left some crap behind (giving just the opening portion

[GNC] "Save Report Configuration" Crashes GnuCash and Truncates saved-reports-2.8

2018-12-29 Thread David T. via gnucash-user
Hello, As the subject line notes, I am again encountering a crasher in GnuCash 3.3 on MacOS Mojave when I try to save a report configuration for a report whose settings have changed. Upon restart, I find that the saved reports have been trashed, and the saved-reports-2.8 file is truncated at a

Re: [GNC] Basic Question (I hope) - End of Year Procedure

2018-12-24 Thread David T. via gnucash-user
Apologies.  My mail program ate the link.  wiki.gnucash.org/wiki/Closing_Books On Mon, Dec 24, 2018 at 13:46, David T. via gnucash-user wrote: Hello, Welcome to gnucash, if rather belatedly.  Your question is one that comes up at this time of the year, and can generate quite a bit

Re: [GNC] Basic Question (I hope) - End of Year Procedure

2018-12-24 Thread David T. via gnucash-user
Hello, Welcome to gnucash, if rather belatedly.  Your question is one that comes up at this time of the year, and can generate quite a bit of responses. You should definitely read the wiki page on this subject:  Closing Books - GnuCash | | | | || | | | | | Closing

Re: [GNC] Budget Issue

2018-12-19 Thread David T. via gnucash-user
Peter, Adrien, I will start by saying that I am not a programmer, and am not the person to whom you should go to request software updates to GnuCash. Having said that, I am going to rain on the parade. In my 13 years using Gnucash, I've seen very little developer time or interest in the

Re: [GNC] GNU crashes when any Report is selected

2018-12-10 Thread David T. via gnucash-user
Back in 2017, https://bugs.gnucash.org/show_bug.cgi?id=785580 was filed, in which it was noted that for reasons unspecified, the first report run by GnuCash under Windows was always delayed by something like 30 seconds. That bug (and its

Re: [GNC] Text Files

2018-12-04 Thread David T. via gnucash-user
Your Windows setting is to hide file extensions. You can change that if you prefer. Then you would see the ".log" appended to what you have listed here.  On Tue, Dec 4, 2018 at 15:17, Gareth Davies via gnucash-user wrote: Hi, Maf Strange, in the actual folder it looks like I have shown

Re: [GNC] Text Files

2018-12-04 Thread David T. via gnucash-user
Are you sure the name isn't something like "MyAccounts.201812031234.log"? BTW, I imagine people call you Gareth, not Human. David  On Tue, Dec 4, 2018 at 14:38, Gareth Davies wrote: #yiv7952894253 #yiv7952894253 -- _filtered #yiv7952894253 {panose-1:2 4 5 3 5 4 6 3 2 4;} _filtered

Re: [GNC] Working with compound interest on varying amounts

2018-12-03 Thread David T. via gnucash-user
Hal, Most such calculations are devilishly difficult to represent with 100% accuracy, which is why I have always opted to base my transactions on the statement, rather than try to anticipate what the finance company is going to come up with.  David T  On Mon, Dec 3, 2018 at 12:10, Hal

Re: [GNC] Installation on a Mac

2018-12-03 Thread David T. via gnucash-user
Gerry, I'm curious what installation instructions were confusing? David T On Mon, Dec 3, 2018 at 8:12, Gerry Starnes wrote: Actually I’m a MacHead. =)  The GnuCash installation is not clear and different programs install differently. It doesn’t do the usual “Drag this to Applications”

Re: [GNC] Installation on a Mac

2018-12-02 Thread David T. via gnucash-user
Dave, I'm pretty sure Gerry was not talking about configuration files. His references to folders in Applications suggests that. The terminology he uses suggests he is more familiar with Windows or Linux than the Mac, since (as John notes elsewhere) the only installation one needs to do for

Re: [GNC] How does GnuCash autoassign transactions?

2018-11-28 Thread David T. via gnucash-user
It learns from your choices during import. If you accept the choices it makes, it does it that way the next time. You change it by selecting a different account in the matcher window. Then the matcher learns from your decision. Take a look at:

Re: [GNC] Migrating to iMac from PC

2018-11-28 Thread David T. via gnucash-user
> On Nov 28, 2018, at 4:55 PM, Colin Law wrote: > > On Wed, 28 Nov 2018 at 10:49, Richard Jones > wrote: >> >> Thank you Robert, Michael, Adrien and John for taking the time and trouble >> to answer and explain. >> This migration would require very careful planning, testing and a backup >>

Re: [GNC] Multiple Currency transaction with bank fee

2018-11-19 Thread David T. via gnucash-user
> On Nov 19, 2018, at 2:09 AM, Christian Kluge wrote: > > Am 18.11.2018 um 17:50 schrieb David T. via gnucash-user: >> Hello, >> >> I am a longtime user (GC3.3, Mac OSX) trying to do something new in GnuCash, >> and I ran into a situation that I fou

[GNC] Multiple Currency transaction with bank fee

2018-11-18 Thread David T. via gnucash-user
Hello, I am a longtime user (GC3.3, Mac OSX) trying to do something new in GnuCash, and I ran into a situation that I found rather confusing, and I’d like to share that with the group to see whether I have understood the situation correctly. Basically, I am transferring funds from a US dollar

Re: [GNC] GNC 3.3 CSV Importer Freezing on MacOS

2018-11-04 Thread David T. via gnucash-user
I'm glad you were able to engineer a solution! For what it's worth, you might have had similar success by switching around the edit point-- in other words, once you had recreated your account in the data file, you could have gone in and replaced the new account ID in your data file with the

Re: [GNC] Accidentally Created .LNK file and now my entire GnuCash file is overwritten and I can't get back to work

2018-11-04 Thread David T. via gnucash-user
Gordon, It is so much simpler to just delete the files. They only serve as markers to gnucash to let gnucash itself know if the program is already running.  Renaming the files serves no purpose except to propagate files that aren't meant to last on disk after exiting the program. To suggest

Re: [GNC] gnucash 3.x corrupts data file

2018-11-04 Thread David T. via gnucash-user
Jörg, Frank points you to the spurious date that is likely the source of your trouble. I believe that at some point, the developers put in a data check into the upgrade process, to prevent errors from propagating forward, which would explain the problem arising now. Perhaps you could manually

Re: [GNC] Accidentally Created .LNK file and now my entire G

2018-11-04 Thread David T. via gnucash-user
The Guide does explain this-- in the Basics chapter https://www.gnucash.org/docs/v3/C/gnucash-guide/basics-backup1.html David On Mon, Nov 5, 2018 at 7:42, David T. via gnucash-user wrote: As others explained, the lck and lnk files are created by gnucash to prevent users accidentally

Re: [GNC] GNC 3.3 CSV Importer Freezing on MacOS

2018-11-04 Thread David T. via gnucash-user
While I do not use the importers much these days, I will note that in  https://www.gnucash.org/docs/v3/C/gnucash-guide/basics-backup1.html, there is information regarding the items that are and are not covered by log files.  The reason that log files don't cover these, I believe, had to do with

Re: [GNC] Accidentally Created .LNK file and now my entire GnuCash file is overwritten and I can't get back to work

2018-11-04 Thread David T. via gnucash-user
As others explained, the lck and lnk files are created by gnucash to prevent users accidentally opening the data file on multiple machines. They are zero bytes in size and there is no point in trying to open them up. There is no there there.  On Mon, Nov 5, 2018 at 7:08, GWB wrote:

Re: [GNC] Backup

2018-11-01 Thread David T. via gnucash-user
Wm, I know I am putting myself out here to get royally flamed by you, but... I call BS. You’re trolling here. First off, IT’S A WIKI. YOU of all people should know what that means: volunteers write/edit that content, and OTHER volunteers (read: YOU) can edit those pages to make them

Re: [GNC] GnuCash 3.3 unknown error while retrieving price quotes

2018-10-28 Thread David T. via gnucash-user
Potential tips: “It is possible to change which columns display in the Chart of Accounts. Just locate the triangle at the far right of the column headings, and click it to see the different columns available." “You can set the Security Editor screen to display the Quote Source of a security,

Re: [GNC] Preferences for latest version

2018-10-22 Thread David T. via gnucash-user
Adrien, > On Oct 21, 2018, at 11:08 PM, Adrien Monteleone > wrote: > > * Now for the font name issue... > > I haven’t found a consistent rule here but these are the two that work for me: > > Open FontBook, find your desired font, and click the (i) icon at the top left > to view the font’s

Re: [GNC] Editing, moving customer lists, possible child lists

2018-10-22 Thread David T. via gnucash-user
Indeed. Having just worked through the wiki FAQ language on backups, I would prefer that list advice point to the relevant wiki pages whenever possible, in this case https://wiki.gnucash.org/wiki/Backup . I recommend this approach because such issues in

Re: [GNC] Preferences for latest version

2018-10-22 Thread David T. via gnucash-user
D (mentioned on GTK >> site), and various other meta key combinations. I have no way of knowing the >> element names, unless someone can tell me how this is supposed to work under >> MacOS. I will note that I see the following output after the above command: >> >> Gt

Re: [GNC] Capital losses in Advanced Portfolio Report

2018-10-21 Thread David T. via gnucash-user
Jose, That is likely an error. It is interesting to see that none of the examples has the loss going into an expense account. Thanks for pointing this out. David > On Oct 21, 2018, at 9:28 PM, José A. Fernández Troncoso > wrote: > > Thank you, John and David: > > Using an income acount to

Re: [GNC] Preferences for latest version

2018-10-21 Thread David T. via gnucash-user
> MacOS. I will note that I see the following output after the above command: > > Gtk-Message: 20:22:13.449: Failed to open display (null) > Gtk-Message: 20:22:13.449: Failed to separate connection to default display > > Guidance is welcome. > > Cheers, > Da

Re: [GNC] Capital losses in Advanced Portfolio Report

2018-10-21 Thread David T. via gnucash-user
Jose, Just to be clear, I believe John is pointing out that your capital losses should be recorded in an Income account, rather than an Expense account. David > On Oct 21, 2018, at 8:05 PM, John Ralls wrote: > > That’s because the Advanced Portfolio Report is hard-wired to expect capital >

Re: [GNC] Report Loading GC 3.3

2018-10-21 Thread David T. via gnucash-user
vid T, >>> >>> I hope that is intentional to make GnuCash load faster. Does it save >> time >>> for you? >>> >>> David C >>> >>> On Sun, Oct 21, 2018 at 3:05 AM David T. via gnucash-user < >>> gnucash-user@gnuc

Re: [GNC] Preferences for latest version

2018-10-21 Thread David T. via gnucash-user
will note that I see the following output after the above command: Gtk-Message: 20:22:13.449: Failed to open display (null) Gtk-Message: 20:22:13.449: Failed to separate connection to default display Guidance is welcome. Cheers, David > On Oct 21, 2018, at 1:26 PM, David T. via gnucash-user >

[GNC] Report Loading GC 3.3

2018-10-21 Thread David T. via gnucash-user
Hello, I just noticed that on v.3.3, reports do not load on startup. In version 2.x, all open reports were loaded in the startup process. Now, they only load when the specific tabs are activated. Is this change intentional? David T. ___

Re: [GNC] Preferences for latest version

2018-10-21 Thread David T. via gnucash-user
Adrien, I’ve been following this thread, and decided to try some of it out. I’d like to report that my results have been less than stellar, and just a little bit confusing. I will begin by saying that I am a long time MacOS user, and I am running both 2.6.19 and 3.3 on MacOS Mojave (which

Re: [GNC] Inheritance of Cash

2018-10-11 Thread David T. via gnucash-user
Leo,  Adrien's advice is accurate. Enter the transaction as he suggests, and ask your tax advisor whether you owe tax or not. Gnucash is not an oracle; it won't be able to answer your tax questions.  David On Fri, Oct 12, 2018 at 10:23, Adrien Monteleone wrote: Whatever the

Re: [GNC] Reports with previous year in different Accounts

2018-10-01 Thread David T. via gnucash-user
I don’t know what to tell you on that front. Are *any* files in the location newer? Cheers, David > On Oct 1, 2018, at 6:33 PM, > wrote: > > Hello David, > > I have looked at that location before but notice that the file > “saved-reports-2.4” modification date is earlier in the year.

Re: [GNC] Reports with previous year in different Accounts

2018-09-29 Thread David T. via gnucash-user
Info about file locations is available at https://www.gnucash.org/docs/v3/C/gnucash-guide/basics-migrate-settings.html . David T. > On Sep 29, 2018, at 7:54 PM, > wrote: > > Hello David, tnx for the

Re: [GNC] Reports with previous year in different Accounts

2018-09-29 Thread David T. via gnucash-user
This is a known issue with how GnuCash handles saved reports, and has been around a long time. Your only recoourse is to create separate user logins at the operating system, and log in to each user account when you wish to access a particular GnuCash book and its reports. David T. > On Sep

Re: [GNC] Different Accounting Periods indifferent files

2018-09-21 Thread David T. via gnucash-user
A low tech solution mentioned here in the past is to set up a separate login for the variant accounting period data file.  On Fri, Sep 21, 2018 at 10:28, Geert Janssens wrote: Op vrijdag 21 september 2018 15:59:19 CEST schreef Christopher Lam: > No, this is a system wide preference and

Re: [GNC] Omission from help manual: formulas

2018-09-17 Thread David T. via gnucash-user
OK. Here’s the thing, I looked at the same information that you had, and I provided some explanations for your questions based on that information, so obviously something clicked for me that didn’t for you. It would be a help if you could try to figure out how the wiki could be better written

Re: [GNC] Omission from help manual: formulas

2018-09-17 Thread David T. via gnucash-user
> On Sep 17, 2018, at 11:29 AM, Adrien Monteleone > wrote: > > David & Stan, > > From my experimentation, I think your descriptions are correct. > > Exponents aren’t supported. (yet) Since the email explanations date from 2005, I don’t think this will be added any time soon. > > All

Re: [GNC] Error importing quicken 2017 qif / qfx

2018-09-17 Thread David T. via gnucash-user
> On Sep 17, 2018, at 10:17 AM, cicko wrote: > > GnuCash - User mailing list wrote >> It’s not clear that the OP has determined that the content of their QIF >> file is properly structured ... >> >> The bug to which you refer addresses a very particular aspect of QIF >> import, while the OP

Re: [GNC] Another sort field like 'Class' in Quicken?

2018-09-17 Thread David T. via gnucash-user
Paul, This is a recent addition to the program. Since the documentation is also developed by volunteers (who are not necessarily the same as the people who write the program itself) documentation often lags behind the features. We rely on users like you to provide descriptions of features and

Re: [GNC] Omission from help manual: formulas

2018-09-17 Thread David T. via gnucash-user
17, 2018, at 8:37 AM, David T. via gnucash-user > wrote: > > Stan, > > I neither use formulas nor scheduled transactions, so I can’t comment on the > documentation. Since you do, maybe you could add some information on the wiki > to assist others after you? > >> O

Re: [GNC] Omission from help manual: formulas

2018-09-17 Thread David T. via gnucash-user
Stan, I neither use formulas nor scheduled transactions, so I can’t comment on the documentation. Since you do, maybe you could add some information on the wiki to assist others after you? > On Sep 17, 2018, at 8:05 AM, Stan Brown wrote: > > Thank you for the reply, Frank, but I read that

Re: [GNC] Error importing quicken 2017 qif / qfx

2018-09-17 Thread David T. via gnucash-user
Hello, In fact, the error is quite clear: something in the QIF file is not as the importer expects. As another David has noted, the QIF importer itself is functional, and has worked for many users before you. Unfortunately, in this case, that erro message is not particularly helpful, as your

Re: [GNC] Error importing quicken 2017 qif / qfx

2018-09-17 Thread David T. via gnucash-user
I think it’s a little premature to refer to this bug. It’s not clear that the OP has determined that the content of their QIF file is properly structured and being properly interpreted by the GnuCash importer—and that is a more profitable avenue for them to explore at this time. The bug to

Re: [GNC] Advanced Portfolio Report - Fund managment fees

2018-09-11 Thread David T. via gnucash-user
Whether a gain is taxable or not is a separate issue from whether a sale results in gain, and the usual way (AFAIK) of handling taxed versus untaxed anything is to have separate accounts for each (Income:Realized Gains:Taxable and Income:Realized Gains:Untaxed). Does creating a transaction

Re: [GNC] FinanceQuote install broken on OSX

2018-09-11 Thread David T. via gnucash-user
Take a look at two questions in the FAQ at https://wiki.gnucash.org/wiki/FAQ#Q:_Why_doesn.27t_online_quoting_work.3F Are you using Yahoo!? Do you have an Alphavantage API key? The executables for terminal use are

Re: [GNC] Advanced Portfolio Report - Fund managment fees

2018-09-11 Thread David T. via gnucash-user
While I have no comment on how to get the Advanced Portfolio Report to categorize your fees as such, I will note that when you sell a commodity—regardless of the reason for which you sell it—you will have (in most cases) a capital gain element. The gain is there, even if you immediately turn

[GNC] Date Picker Info

2018-09-10 Thread David T. via gnucash-user
Hello, In the course of looking at documentation improvements, I happened to look at the program code for the date cells in GnuCash, and I discovered that there are several quick keys for setting the date that I was unaware of, and I thought I’d share with the list. Most of us know about

Re: [GNC] register columns

2018-09-10 Thread David T. via gnucash-user
Jim, The short answer is “No, the columns are hard-coded.” If you wanted to change the order, you could, but you’d need to rewrite the code and compile from your modified source. David > On Sep 10, 2018, at 11:24 AM, JIM <9031jbk...@att.net> wrote: > > Is there some way I can change the

Re: [GNC] Reconciliation Question

2018-09-06 Thread David T. via gnucash-user
Assuming that everything else is reconciled,  all you really need to do is add the missing transactions and re-reconcile. Ignore the starting balance, and enter the same closing balance as your last statement.  Those three items will appear in the reconciliation window,  you check them off, 

Re: [GNC] GAU as currency

2018-09-06 Thread David T. via gnucash-user
Of course, Michael, you are right--except for the fact that the ISO currency codes include entries for gold, silver, as well as one or two others, which is what I was referring to. I was anticipating Muhammad's next question. Muhammad, there won't be any way for you to obtain daily prices for a

Re: [GNC] GAU as currency

2018-09-06 Thread David T. via gnucash-user
I am not an expert, but my understanding is that the currency codes are derived from the ISO standards. GAU isn't among those. David On Thu, Sep 6, 2018 at 12:19, Muhammad Bashir Al-Noimi wrote:   Hi,   How can use GAU (gold gram) as a currency in GNC instead of XAU (gold   ounce)?  

Re: [GNC] Chart of Accounts sort order in v3.2 - Help

2018-09-04 Thread David T. via gnucash-user
Alan, > On Sep 4, 2018, at 9:05 AM, Alan Maddocks wrote: > > Hi David, > > Thank you for your prompt reply to my query. > > I can add account codes and sort on them. However, that involves a certain > amount of additional work which wasn’t necessary previously. > > I just don't

Re: [GNC] GC 3.2 Import Price File CSV

2018-09-04 Thread David T. via gnucash-user
Geert, Thanks for looking into this and coming up with a fix. Just out of curiosity, what is the fix that you’ve put in? Cheers, David > On Sep 4, 2018, at 5:34 AM, Geert Janssens wrote: > > Op dinsdag 4 september 2018 10:36:11 CEST schreef Andy Brown via gnucash-user: >> Tried TextEdit.

Re: [GNC] GC 3.2 Import Price File CSV

2018-08-29 Thread David T. via gnucash-user
Geert, I have filed Bug 796833 with both a short csv file from my copy of Excel, and a screenshot of the importer result. Cheers, David > On Aug 29, 2018, at 8:45 AM, Geert Janssens > wrote: > > If you can provide a sample file which you have verified to fail, we may be > able to debug it.

Re: [GNC] macOS gnc 3.2

2018-08-27 Thread David T. via gnucash-user
I never noticed them change. Since moving to 3.2 I haven’t > tried a 2.6.x version again. > > Regards, > Adrien > >> On Aug 27, 2018, at 3:18 PM, David T. via gnucash-user >> wrote: >> >> Just note that if you use 3.x and go back to 2.6.x, the program an

[GNC] Using CSV Importer and Google for Commodity Prices

2018-08-27 Thread David T. via gnucash-user
Hello, I, like many others, have encountered numerous headaches over the last year due to the turmoil around retrieving commodity price quotes. I appreciated being able to retrieve prices on an occasional basis and see, broadly speaking, how my holdings were performing. I bemoaned the loss of

Re: [GNC] macOS gnc 3.2

2018-08-27 Thread David T. via gnucash-user
Just note that if you use 3.x and go back to 2.6.x, the program and your data will still work together, but your key bindings will get changed (Command-S will be Ctrl-S, etc.). It’s a little disconcerting at first. > On Aug 27, 2018, at 4:00 PM, John Ralls wrote: > > It's a personal decision

Re: [GNC] Not Getting Complete Stock Quotes with Price Database Tool

2018-08-24 Thread David T. via gnucash-user
Dan, You are not alone with this problem; numerous users have lamented the ongoing saga of retrieving commodity prices online since Yahoo! decided to pull the plug on its quote system. AlphaVantage has been the solution that everyone here flocked to, and now AlphaVantage is altering its

Re: [GNC] Report: single expense account

2018-08-18 Thread David T. via gnucash-user
Try: 1) View->Filter By 2) Set Start and End Dates 3) Account Report Cheers! David P.S. - Don’t forget to re-set your View settings afterward! > On Aug 18, 2018, at 10:35 AM, Rich Shepard wrote: > > I would like to print a report for a single expense account listing > transactions and total

Re: [GNC] Column widths again

2018-08-18 Thread David T. via gnucash-user
ys off screen. > > Cheerio > > Graham > > On Thu, 16 Aug 2018, 10:53 pm GT-I9070 H, <mailto:gti90...@gmail.com>> wrote: > Em qui, 16 de ago de 2018 às 13:34, David T. via gnucash-user < > gnucash-user@gnucash.org <mailto:gnucash-user@gnucash.org>> escreveu:

Re: [GNC] Links in transaction reports

2018-08-17 Thread David T. via gnucash-user
Well, that certainly puts kinks in the hose! > On Aug 16, 2018, at 11:06 PM, Christopher Lam > wrote: > > From my understanding, adding an option to the 3.x series means that anyone > who upgrades to 3.3, creates a saved-report, and downgrades to 3.2 will > suddenly find the saved-report

Re: [GNC] Links in transaction reports

2018-08-16 Thread David T. via gnucash-user
I don’t understand your assertion that this would be an “incompatible change of options.” The option to remove hyperlinks is available on the Balance Sheet, but not on the Transaction Report. What about that is incompatible? If I were going to put the option anywhere, I’d put it in the same

Re: [GNC] File Format Documentation, v. 2

2018-08-16 Thread David T. via gnucash-user
On Thu, Aug 16, 2018 at 18:53, John C wrote: Please tell the reader the default file format right after installation. regards, John On 8/16/2018 5:06 PM, Adrien Monteleone wrote: > Looks good to me. > > Regards, > Adrien > >> On Aug 16, 2018, at 3:00 PM, David T. via gn

[GNC] File Format Documentation, v. 2

2018-08-16 Thread David T. via gnucash-user
I’ve attempted to incorporate the suggestions that others have made for the section on file storage formats, and I attach the resulting version 2 for further consideration. Keep in mind that this is not meant to be an encyclopedic coverage of the topic; it’s meant to outline the choices. I

Re: [GNC] A way to disable autofill entries? or am I doing it wrong?

2018-08-16 Thread David T. via gnucash-user
For the first, see https://bugs.gnucash.org/show_bug.cgi?id=796734 . This explains the problem and a workaround. It sounds as if your second problem is related to https://bugs.gnucash.org/show_bug.cgi?id=796741

Re: [GNC] Column widths again

2018-08-16 Thread David T. via gnucash-user
Graham, If your problem is specifically that the Balance column is too narrow, then you’ve encountered a Known Idiosyncrasy: the Balance column is a challenge to resize. In fact, the only way I know to get it to resize is to double-click the column heading. This is documented in a note in the

Re: [GNC] Links in transaction reports

2018-08-16 Thread David T. via gnucash-user
Christopher, Is there some reason why the Transaction report doesn’t have the option to display as hyperlinks, as I see for accounts under the Balance Sheet report (Options->Display->Display accounts as hyperlinks)? Forcing a user to edit style sheets to achieve this in one report, while

Re: [GNC] Next release of F::Q

2018-08-16 Thread David T. via gnucash-user
Erik, Thanks for the update—and for your ongoing work to manage this unwieldy beast for the community! David T. > On Aug 16, 2018, at 2:20 AM, Erik Colson wrote: > > Hello all, > > I'm on some extended vacation and will be back home next week. My > intent is to release F::Q from master at

Re: [GNC] File Format Documentation (Bug 777893)

2018-08-15 Thread David T. via gnucash-user
not >>>> have to perform any additional driver installations when I choose either >>>> XML or SQLite. Your note that SQLite is also available in Windows makes it >>>> a clean sweep for availability by default. >>>> >>>> David >>>>

Re: [GNC] File Format Documentation (Bug 777893)

2018-08-15 Thread David T. via gnucash-user
gt;>> On Aug 15, 2018, at 11:27 AM, Derek Atkins wrote: >>> >>> SQLite uses libdbi, too. >>> >>> -derek >>> >>> On Wed, August 15, 2018 1:49 pm, David T. via gnucash-user wrote: >>>> Here is a newer version of the table: >&

Re: [GNC] Installing F::Q on Ubuntu

2018-08-15 Thread David T. via gnucash-user
Tim, Numerous people have reported troubles using AlphaVantage to retrieve quotes recently, with several noting that the site appears to be unreliable (perhaps purposefully so). You don’t mention your GnuCash version; on GC3.2, there is supposedly a user preference slot for the AlphaVantage

Re: [GNC] File Format Documentation (Bug 777893)

2018-08-15 Thread David T. via gnucash-user
As you note, backups are not a germane topic here. I will note that Section 2.6 of the Guide is titled “Backing Up and Recovering Data.” Perhaps that section could include further discourse on data backups. David > On Aug 15, 2018, at 3:04 PM, David Carlson > wrote: > > While file backups

Re: [GNC] File Format Documentation (Bug 777893)

2018-08-15 Thread David T. via gnucash-user
> On Aug 15, 2018, at 1:35 PM, Adrien Monteleone > wrote: > > Looks pretty clear. > > Though I’m noticing sqlite does generate log files too. Note, these are > transaction replay logs from what I understand in case of a crash. As I > believe John Ralls noted, any of these past the last

Re: [GNC] File Format Documentation (Bug 777893)

2018-08-15 Thread David T. via gnucash-user
XML or SQLite. Your note that SQLite is also available in Windows makes it a clean sweep for availability by default. David > On Aug 15, 2018, at 11:27 AM, Derek Atkins wrote: > > SQLite uses libdbi, too. > > -derek > > On Wed, August 15, 2018 1:49 pm, David T. v

  1   2   3   >