Re: [GNC] OFX import sometimes loses transaction memos

2019-01-16 Thread David Carlson
ses any restrictions or not at this stage. > > > > David Cousens > > On Wed, 2019-01-16 at 18:19 -0600, David Carlson wrote: > >> > >> > >> On Wed, Jan 16, 2019, 4:36 PM David Cousens wrote: > >>> David > >>> > >&g

Re: [GNC] OFX import sometimes loses transaction memos

2019-01-16 Thread David Carlson
On Wed, Jan 16, 2019, 4:36 PM David Cousens David > > Have you tried examining the file with ofxdump? If you are on Linux, it can > be installed with "sudo apt install ofx". Not sure about how to get it for > WIndows or MacOS. It will dump to stdout whatever ofxdump can determine > about an ofx

[GNC] OFX import sometimes loses transaction memos

2019-01-16 Thread David Carlson
Using GnuCash 2.6.17? in Ubunutu 16.04 I noticed that the OFX importer from time to time will fail to import some, but not all transaction memos for only one of the banks that that are currently active in my data. This bank tends to send lenghthy memos. One of the failed memos had 98 ASCII

Re: [GNC] Formatting reply posts

2019-01-13 Thread David Carlson
Certainly you know how difficult it is to select text on a smartphone. David C On Sun, Jan 13, 2019, 3:01 PM Geert Janssens Op zondag 13 januari 2019 21:30:54 CET schreef Stan Brown: > > The real issue, I'm sorry top say, is that many people are lazy, and > > just start typing wherever their

Re: [GNC] Formatting reply posts

2019-01-12 Thread David Carlson
Unfortunately, gmail seems to force me into top posting by opening up my reply with the previous text at the bottom an d hidden below three dots. Especially on a tablet, where it is difficult to do anything more sophisticated than touchong a virtual keyboard with my thumb hoping I won't need

Re: [GNC] Loan Mortgage repayment assistant problem

2019-01-09 Thread David Carlson
recently found the hp49g+ calculator that i bought about a decade ago and discovered that it can work either in exact or approximate CAS modes, as they describe them. And it still works! David C On Wed, Jan 9, 2019 at 11:31 AM Fred Bone wrote: > On Wednesday, January 9, 2019 at 9:44, David Carl

Re: [GNC] Investment Accounts not Displaying Decimals

2019-01-09 Thread David Carlson
I believe you just have to live with it in release 2.6.21 or several other releases below 3.3. You should be able to manually re save any particular entry in decimal form if it is really bothering you, but why bother if it does not appear that way in reports? David C On Wed, Jan 9, 2019 at 9:52

Re: [GNC] Loan Mortgage repayment assistant problem

2019-01-09 Thread David Carlson
Absolutely, I was not expecting agreement with the bank, I just think the creation of an unbalanced transaction is bad form. David Carlson On Wed, Jan 9, 2019, 9:03 AM John Ralls > > > On Jan 9, 2019, at 6:26 AM, Michael or Penny Novack < > stepbystepf...@comcast.net> wrote: &

Re: [GNC] Loan Mortgage repayment assistant problem

2019-01-09 Thread David Carlson
I have created https://bugs.gnucash.org/show_bug.cgi?id=797032. David C On Wed, Jan 9, 2019 at 2:29 AM David Carlson wrote: > With those numbers payment number 2 has an error. > > David C > > On Wed, Jan 9, 2019 at 2:23 AM David Carlson > wrote: > >> I am wor

Re: [GNC] Loan Mortgage repayment assistant problem

2019-01-09 Thread David Carlson
With those numbers payment number 2 has an error. David C On Wed, Jan 9, 2019 at 2:23 AM David Carlson wrote: > I am working on a test scenario.The interest formula is ipmt( 0.03500 / > 12.00 : i : 180.00 : 172,000.00 : 0 : 0 ), the others have the same numbers > and the 71st payment

Re: [GNC] Loan Mortgage repayment assistant problem

2019-01-09 Thread David Carlson
> > > On Jan 8, 2019, at 5:46 PM, Christopher Lam > wrote: > > > > Well the SCM has numerous references to "round" and "rounding errors" so > it's to be expected. > > > > Please file a bug with example numbers, and hopefully these

Re: [GNC] Loan Mortgage repayment assistant problem

2019-01-08 Thread David Carlson
wrote: > The thee functions are defined in > https://github.com/Gnucash/gnucash/blob/maint/libgnucash/app-utils/fin.scm, > prefixed with gnc: (so gnc:ipmt etc.). > > At line 41ff you'll see that ppmt = pmt - ipmt. > > Regards, > John Ralls > > > > On Jan 8, 2019,

Re: [GNC] Loan Mortgage repayment assistant problem

2019-01-08 Thread David Carlson
. If ipmt were expressed as pmt-ppmt, there would be no imbalance, but one of the other two ways to express all three may be less likely to generate inaccurate results. David C On Mon, Jan 7, 2019 at 10:19 PM John Ralls wrote: > > > > On Jan 7, 2019, at 3:14 PM, David Carlson > w

Re: [GNC] ERROR MESSAGE - NO SUITABLE BACKEND FOUND

2019-01-07 Thread David Carlson
y don’t know. > > I am using Windows 10, home. > > > > Thx Tom. > > > > *From:* David Carlson [mailto:david.carlson@gmail.com] > *Sent:* Monday, January 7, 2019 3:01 PM > *To:* Tom Murphy > *Cc:* Gnucash Users > *Subject:* Re: [GNC] ERROR MESSAGE - NO SUITAB

Re: [GNC] ERROR MESSAGE - NO SUITABLE BACKEND FOUND

2019-01-07 Thread David Carlson
Tom, What version of GnuCash did you update from? David C On Mon, Jan 7, 2019, 6:30 PM Tom Murphy I am using Windows 10 with the latest updates installed. In the > instructions it says the file is saved automatically so I am using whatever > the default is. > > -Original Message- >

Re: [GNC] editing reconciled transactions changes reconcile status

2019-01-07 Thread David Carlson
I wonder if GnuCash follows exactly the same rules for income and expense accounts that it does for asset and liability accounts. I know that I never bother with reconciling income or expense accounts. David C On Mon, Jan 7, 2019 at 5:22 PM Liz wrote: > On Sun, 6 Jan 2019 07:34:35 -0800 >

[GNC] Loan Mortgage repayment assistant problem

2019-01-07 Thread David Carlson
I just had a scheduled transaction that was set up by the loan/mortgage repayment assistant appear with 0.01 Imbalance-USD. I would think that GnuCash should have an accuracy method that would prevent this from happening. Is this a bug? I am using GnuCash 2.6.17 in Ubuntu 16.04 today. David C

Re: [GNC] ERROR MESSAGE - NO SUITABLE BACKEND FOUND

2019-01-07 Thread David Carlson
That normally means that your data is in a database format but GnuCash does not have the correct tools to open it. This can happen after an update. Alas, I do not use a database format but I do know that there are differences depending on which operating system you are using. Let us know which

Re: [GNC] GNU generated report in HTML to XL

2019-01-06 Thread David Carlson
tried to paste into a spreadsheet the resulting cell structure was so bad that it was impossible to clean up to get a decent print anyway. David On Sun, Jan 6, 2019, 9:55 AM Geert Janssens On Thursday, January 3, 2019 5:33:06 PM CET David Carlson wrote: > > I was able to run a quick test

Re: [GNC] Stocks/Equities queries (Australian Based)

2019-01-05 Thread David Carlson
money this would mean also adding all those cash-in and cash-out transactions later. Good Luck David Carlson On Sat, Jan 5, 2019 at 5:29 AM D via gnucash-user wrote: > I'd go further and say that, while it is possible to do as Maf says, it > can be quite confusing to manage, especially

Re: [GNC] Line entry creates incorrect balance

2019-01-04 Thread David Carlson
Ted, This is my initial advice to a new user: First skim through the Help manual up to chapter 6 https://www.gnucash.org/docs.phtml Then start GnuCash following the instructions in chapter 3 and create a test file with a minimal set of accounts. You should consider it to be a throw-away test,

Re: [GNC] GNU generated report in HTML to XL

2019-01-03 Thread David Carlson
paste the data to a new libreoffice calc file I get > only 'paste only' as an option under >edit, and nothing else recognisable > from >insert. > > > > I have tried 'insert sheet' under >insert but only get the option to > insert before or after and then cannot copy

[GNC] GNU generated report in HTML to XL

2019-01-03 Thread David Carlson
I had to paste this message into a different computer that is able send G-Mail, so I hope I got all the good parts... I was able to run a quick test using release 2.6.17 in Ubuntu 16.04 and found that first, when I tried to save a P report in HTML format GnuCash did not append a .html suffix. In

Re: [GNC] GNU generated report in HTML to XL

2019-01-03 Thread David Carlson
n to > > insert before or after and then cannot copy the 'new' sheet into an > > existing one, if I add 'after' > > > > There doesn't seem to be a method of cut and paste directly, afaics. > > > > Thanks, Barry > > > > On 02/01/2019 17:51,

Re: [GNC] GNU generated report in HTML to XL

2019-01-02 Thread David Carlson
Finbar, You may need to first open a new blank spreadsheet then cut and paste from the html document into the spreadsheet rather than trying to directly open HTML with Calc. My experience with LibreOffice Calc is that it will import several different kinds of files. I use it regularly to

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

2019-01-02 Thread David Carlson
to skip all the effort to correctly account for realized gains and losses and just forward your brokers' tax report to your accountant. That is my 2 cents... David Carlson On Wed, Jan 2, 2019 at 6:12 AM D via gnucash-user wrote: > Jon, > > I can't test this right now, since I'm not at m

Re: [GNC] Non-zero starting balance?

2019-01-01 Thread David Carlson
Bo, If you still have copies of your bank statements you can review the register a nd compare the running balances to your statements to see if or when the balances do not match. If there are a few outstanding items at the end of a statement period they should account for any difference. You

Re: [GNC] Balance Sheet Report keeps listing all my individual stocks

2019-01-01 Thread David Carlson
ign currency assets, it would be nice > to have another way to collapse the individual stock accounts, but this > solution will work for the time-being. A new challenge for another day. > > Thanks again! > > Stephen > > > > On Tuesday, January 1, 2019, 5:45:10 PM GMT-5, Dav

Re: [GNC] Balance Sheet Report keeps listing all my individual stocks

2019-01-01 Thread David Carlson
gt; > > Today's Topics: > > 1. Re: Adding an exchange to the list of exchanges (David T.) > 2. Re: Tutorial for moving stock between accounts? (David Carlson) > 3. Re: Tutorial for moving stock between accounts? (David Carlson) > 4. Re: Tutorial for moving stock bet

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

2018-12-31 Thread David Carlson
and purchase are just virtual transactions. This sort of situation might come up in transfers of custodial assets in or out of trusts or other tax favored accounts. David C[arlson] David C[arlson] On Mon, Dec 31, 2018 at 10:09 PM David Carlson wrote: > I forgot to mention that if the value has chan

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

2018-12-31 Thread David Carlson
in the pseudo-purchase transaction. David C[arlson] On Mon, Dec 31, 2018 at 10:00 PM David Carlson wrote: > Now David Cousens, you are confusing me. If you are referring to > re-writing the original purchase transaction to correct an error, and the > cash that is also transferred in that tr

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

2018-12-31 Thread David Carlson
Now David Cousens, you are confusing me. If you are referring to re-writing the original purchase transaction to correct an error, and the cash that is also transferred in that transaction is also corrected to the new brokerage account, then I agree with you. If, however, this is a new

Re: [GNC] Location of GnuCash data files

2018-12-31 Thread David Carlson
The thread GNCupdating advice seems to have answers that could apply to this thread. Adding to both: In the release 2.6.xx family, a simple method to find the last used data file is to start the File > Save as process and see where GnuCash wants to put the new file. Then cancel before actually

Re: [GNC] [GNC-dev] GnuCash 3.4 Released

2018-12-30 Thread David Carlson
Wow, that looks like a lot of progress has been made! Thanks to the developers for their hard work! David C On Sun, Dec 30, 2018 at 2:03 PM John Ralls wrote: > The GnuCash development team announces GnuCash 3.4, the fifth release of > the 3.x stable release series. > > Changes > > Between 3.3

Re: [GNC] How to journal this transaction?

2018-12-30 Thread David Carlson
I would either enter a simple transaction from a/r to expense or use two transactions , one from a/r to cash and one from cash to expense. David C On Sun, Dec 30, 2018, 1:44 PM gn00b Someone owes me $100 (Accounts Receivable). But instead of paying me $100, > they pay for an expense of mine

Re: [GNC] Backspace key stops working

2018-12-30 Thread David Carlson
John requested that users report every detail of your actions leading up to the problem and exactly which keystrokes do not work. So far the developers cannot replicate the problem. A "Same here" comment does not help with diagnosing the problem. David C On Sun, Dec 30, 2018 at 2:09 AM

Re: [GNC] Import qif does not remember account allocation.

2018-12-30 Thread David Carlson
Dave W, Once is enough with the duplicated messages. The previous responses by John and Derek seemed to cover your concerns but since you are asking for elaboration, I as an experienced user can answer your questions #1 & #2. The QIF Import wizard in the GnuCash Releases 2.6.21 and earlier

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

2018-12-29 Thread David Carlson
David T, I am a little bit behind, as I am still using release 2.6.x where x ranges between 16 and 19 depending on which machine I have fired up, so I am still looking at a file named saved-reports-2..4, but I think that it is not too different from your file. I think you are aware that the file

Re: [GNC] Gnucash-created "closing" entries

2018-12-28 Thread David Carlson
Stan, You could try using the Close Books function to create model transactions then duplicate them to get copies that likely do not contain the odd dates. David C On Fri, Dec 28, 2018, 1:37 PM Stan Brown > From: David Cousens > > Subject: Re: [GNC] Basic Question (I hope) - End of Year

Re: [GNC] Getting the date order in a report ?

2018-12-24 Thread David Carlson
I am not sure if this will help. Check that the register sort order is set to date posted. If that does not work please let us know which GnuCash release you are using and your operating system. David C On Mon, Dec 24, 2018, 4:49 AM Finbar Mahon Hello, this is not urgent, just so I don't

Re: [GNC] report filtering

2018-12-20 Thread David Carlson
Paul, If all the transactions are in only one account, start your Edit > Find >Number > Contains ... or Edit > Find > Number > Matches Regex ... operation from that account register. If they are in several accounts, start your Edit > Find >Number > Contains ... or Edit > Find > Number >

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

2018-12-19 Thread David Carlson
Elmer, What thread are you responding to? David C On Wed, Dec 19, 2018, 8:58 AM Elmar I gather this is only in version 3.x? Any hope for us still on version > 2.6.12 ? > > - Elmar > > On 12/18/18 10:58 PM, gnucash-user-requ...@gnucash.org wrote: > > In GnC, click on the Tools menu and then on

Re: [GNC] Export Report to PDF - characters split across pages

2018-12-19 Thread David Carlson
Michael, Try exporting the report to html. David C On Wed, Dec 19, 2018 at 5:31 AM Michael Hendry wrote: > Here is a screen-shot to demonstrate the problem: > > > https://www.dropbox.com/s/mmde3eqphnhabp6/Screenshot%202018-12-19%2011.22.14.png?dl=0 > > The report is readable, but inelegant. >

Re: [GNC] Wildcard in standard report definiton

2018-12-18 Thread David Carlson
a 'wildcard' type of accounts selection, it's a > good entry-level idea for a budding scheme hacker :) > > On 19/12/18 5:42 am, David Carlson wrote: > > On that subject, I would like to see a way to document the current > settings > > of a report, perhaps by including it as an a

Re: [GNC] Wildcard in standard report definiton

2018-12-18 Thread David Carlson
On that subject, I would like to see a way to document the current settings of a report, perhaps by including it as an appendix to the report printout. Then I would like to see a way to export and import settings from one data file to another. David C On Tue, Dec 18, 2018 at 2:58 PM Adrien

Re: [GNC] How do you print the check register?

2018-12-14 Thread David Carlson
Chris, By Check Register do you mean a list of transactions in one ban account? To do that, open the Account window for that bank account, Click on View > Filter By..., choose the date range that you want to print out, then choose Reports > Account Report, and print it out. Note that you may see

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

2018-12-10 Thread David Carlson
l Message- > From: gnucash-user blueyonder.co...@gnucash.org> On Behalf Of Stephen M. Butler > Sent: 10 December 2018 17:47 > To: gnucash-user@gnucash.org > Subject: Re: [GNC] GNU crashes when any Report is selected > > On 12/10/18 4:46 AM, Stan Brown wrote: > > Hi, Arni

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

2018-12-10 Thread David Carlson
hese have worked perfectly for > 11 months. > Best Regards > Arnie > > > > *From:* John Ralls > *Sent:* 10 December 2018 01:17 > *To:* Arnie Reeves > *Cc:* David Carlson ; Gnucash Users < > gnucash-user@gnucash.org> > *Subject:* Re: [GNC] GNU crashes when a

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

2018-12-10 Thread David Carlson
ever I have the same excessive delay waiting for > Reports to open. Do you have any thoughts to correct this please. > > Best Regards > > Arnie > > > > > > > > *From:* John Ralls > *Sent:* 10 December 2018 14:26 > *To:* Arnie Reeves > *Cc:* David Carl

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

2018-12-09 Thread David Carlson
gt; fine) and 3.3 etc. Which is best, and bug free, for my simple home accounts. > > Arnie > > > > > > From: karnd...@blueyonder.co.uk > > Sent: 08 December 2018 21:37 > > To: David Carlson > > Cc: Gnucash Users > > Subject: Re: [GNC] GNU crashes when any Report is

Re: [GNC] Fwd: Transfer column gone?

2018-12-08 Thread David Carlson
Starnes wrote: > As far as I know, I only got one response... to double-click on the dark > column line. Nothing happened with that. > > Gerry > > On Sat, Dec 8, 2018 at 3:57 PM David Carlson > wrote: > >> Gerry, >> >> Which of the three responses was the on

Re: [GNC] Fwd: Transfer column gone?

2018-12-08 Thread David Carlson
Gerry, Which of the three responses was the only one you tried? I personally think John Ralls' has the best chance of working, but as he stated it is very tricky to get the mouse focus into precisely the right spot. If that fails there is another way that requires deleting a file that also

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

2018-12-08 Thread David Carlson
I did forget to mention that I use Gnucash mostly in Ubuntu 16.04 with occasional forays into Windows 7 and rare forays into Windows 10. David C On Sat, Dec 8, 2018, 3:21 PM David Carlson Arnie, > > Did you get a Windows update or have any other significant change to your >

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

2018-12-08 Thread David Carlson
Arnie, Did you get a Windows update or have any other significant change to your computer? Release 2.6.19 itself has not changed, and various 2.6.x releases are still working for me. David C On Sat, Dec 8, 2018, 12:10 PM Arnie Reeves via gnucash-user < gnucash-user@gnucash.org wrote: > I use

Re: [GNC] Fwd: Transfer column gone?

2018-12-06 Thread David Carlson
Just wondering, since there apparently is not a standardized trick to reset all column widths in the view, would toggling between 1 line and double line views or switching between basic ledger auto split ledger or transaction journal views make any difference? David C On Thu, Dec 6, 2018, 11:04

Re: [GNC] How to save Gnucash and Lock file issues

2018-12-04 Thread David Carlson
Another quirk to watch out for is whether Explorer was refreshed after the last file was created. David C On Tue, Dec 4, 2018 at 11:44 AM Adrien Monteleone < adrien.montele...@lusfiber.net> wrote: > True. I forgot about that one. I use sqlite and indeed it is always > inactive. > > Regards, >

Re: [GNC] Text Files

2018-12-04 Thread David Carlson
Gareth, Windows does not show the file extensions in File Explorer unless you change a setting in your Windows preferences. Most of the experienced Windows users, A.K.A. 'Old Fogies' (like me) change that setting early on and forget that some people may not be familiar with it. The extension

Re: [GNC] How to save Gnucash and Lock file issues

2018-12-03 Thread David Carlson
Lorrie, I am away from my computer right now so I cannot confirm the exact wording, but it s something like how often to make backups. I dont remember the default. It may be only 5 minutes, I have it set to 30 minutes but I religiously do manual saves before certain activities such as imports.

Re: [GNC] How to save Gnucash and Lock file issues

2018-12-03 Thread David Carlson
Lorrie, If, at some time in the past you modified that data file with that (short) filename by going into Edit >Preferences > General and selecting 'Retain log/backup files: Never, then no log or backup files will be generated. You did not do that because you do see .log files being generated.

Re: [GNC] Gnucash Backup

2018-12-03 Thread David Carlson
Ian, I think you need to ask your cloud about that. Gnucash doesn't do backups. David C On Mon, Dec 3, 2018, 5:50 PM IanCarol - PC I am using cloud backup service to back up my Gnu data. > I wish to be able to restore to a different PC. How can I do that? > > Ian Waterfield >

Re: [GNC] Text Files

2018-12-03 Thread David Carlson
I think that Windows calls them text files if once you opened one with Notepad. They are constructed with text characters, but they are not exactly human readable. David C On Mon, Dec 3, 2018, 1:39 PM Gareth Davies via gnucash-user < gnucash-user@gnucash.org wrote: > Thanks for the reply D,

Re: [GNC] How to automate $ value on the contra account when editing a transaction

2018-12-03 Thread David Carlson
Interesting idea... I would like to see it implemented as a pop-up dialog asking the user if (s)he would like to update the 'other side' to the same value if it is a simple two line transaction. If the user closes the transaction without responding yes the imbalance amount is entered. David C

Re: [GNC] Can no longer print checks

2018-12-02 Thread David Carlson
ts to pdf and it will print. However, the result is a > blank page. HB > > On 12/2/2018 9:00 AM, David Carlson wrote: > > That behavior is very similar to what you see when the output goes to the > wrong printer. > > Have you tried things like printing to PDF or printing from a

Re: [GNC] Can no longer print checks

2018-12-02 Thread David Carlson
he Pages area is blank. This indicates there are no pages to print > - I think. If I then go ahead and click on print then the print icon shows > up in the bottom tray. But it indicates there are no documents in the cue. > It then goes away after a couple of minutes. > > Thanks, > > HB > >

Re: [GNC] Can no longer print checks

2018-12-01 Thread David Carlson
You can see how old this bug is, I am not sure if you can run IE9 in windows 10. Perhaps someone knows if this work-around can be adapted to WIN 10. On Sun, Dec 2, 2018 at 1:40 AM David Carlson wrote: > HB, > > I found the bug report. Check comment 40. > > https://b

Re: [GNC] Can no longer print checks

2018-12-01 Thread David Carlson
oblems. That may > be my inability to search properly. So if anyone knows the fix that you are > referring to I hope they will give me the location. > > Thanks for the help, > > HB > On 12/1/2018 1:30 PM, David Carlson wrote: > > That looks identical to the same file on

Re: [GNC] Can no longer print checks

2018-12-01 Thread David Carlson
hanks for the help, > > HB > > HB Sidman > 703-938-6700 (O) 703-562-1953 (F) > > On 12/1/2018 11:46 AM, David Carlson wrote: > > I did not address the failure to print problem. That is probably not > related to the .chk files but something else. Can you print r

Re: [GNC] Can no longer print checks

2018-12-01 Thread David Carlson
I did not address the failure to print problem. That is probably not related to the .chk files but something else. Can you print reorts? David C On Sat, Dec 1, 2018 at 10:42 AM David Carlson wrote: > HB, > > Windows always calls *.chk files 'Recovered File Fragments' > &g

Re: [GNC] Can no longer print checks

2018-12-01 Thread David Carlson
HB, Windows always calls *.chk files 'Recovered File Fragments' If the files are in the 'C:\Program Files (x86)\gnucash\share\gnucash\checks' directory they are not fragments but the files that you want, at least for 2.6.x releases of GnuCash in Windows. You can open them (carefully) with

Re: [GNC] Can't lock user???

2018-11-28 Thread David Carlson
Your subject line is misleading. I think you are having issues with Actions > Online Actions > Get Transactions... Is that correct? It would be helpful to know what version GnuCash you are running and your computer OS. David C On Wed, Nov 28, 2018 at 7:37 PM Hook wrote: > I have 3 users

Re: [GNC] How does GnuCash autoassign transactions?

2018-11-28 Thread David Carlson
I just found a discussion about how it is applied in GnuCash: https://wiki.gnucash.org/wiki/Bayes I am not sure if it still applies to release 3.x. David C On Wed, Nov 28, 2018 at 9:47 AM David Carlson wrote: > Joseph, > > If you are looking for a technically detailed answer, Gnu

Re: [GNC] How does GnuCash autoassign transactions?

2018-11-28 Thread David Carlson
Joseph, If you are looking for a technically detailed answer, GnuCash uses a technique called Bayesian matching which is well known in mathematical circles. The success is very dependent on the details of implementation, and GnuCash took steps toward improvement in the 3.x series by using a

Re: [GNC] Trying to use gnucash need to convert .qdf to /qif

2018-11-27 Thread David Carlson
The developers cannot guarantee anything. Many users have had good results, but many of us needed to run tests with about a month's data at a time mostly because Quicken allowed sloppy records that do not import very well. If that is your situation you might be better served to manipulate

Re: [GNC] Moving to Gnucash 3

2018-11-25 Thread David Carlson
; based on what you've read. > > > > > > There are issues, but it's not like gnucash 3.x has suddenly become > > > completely > > > unusable. > > > > > > Regards, > > > > > > Geert > > > > > > Op zondag 25

Re: [GNC] Moving to Gnucash 3

2018-11-24 Thread David Carlson
Paul, You are not the only one that concerned about whether the new releases meet your needs any better than what you used before. A bird in hand is better... I am staying with my favorite 2.6.15 or 2.6.17 until I am satisfied that 3.4 or whatever is sufficiently well debugged to not present

Re: [GNC] Import CSV Multi-currency

2018-11-24 Thread David Carlson
GTI, Whenever there is more than one currency in a transaction GnuCash creates a split to record the exchange between currencies, so there is a separate split line for each currency. When a multi-currency transaction is imported, there will be two split lines, not one. That is an artifact of

Re: [GNC] GnuCash freezes when saving in Windows

2018-11-23 Thread David Carlson
Scott, Sometimes, but not always, it can be useful to open the task manager and look under processes to see if GnuCash is using a lot of CPU time. If it is "frozen" it probably is using a lot of CPU time, but it also uses a lot at other times too. David C On Fri, Nov 23, 2018, 6:40 PM John

Re: [GNC] Import CSV Multi-currency

2018-11-22 Thread David Carlson
2018 às 01:14, David Carlson < > david.carlson@gmail.com> escreveu: > >> GTI, >> >> While I am not addressing the issue you stated in your first post, I do >> expect an import to consider existing multi-split transactions that match >> the amount and ti

Re: [GNC] Import CSV Multi-currency

2018-11-22 Thread David Carlson
nto multi-line requires extensive extra > processing because I have a ton of transactions. > > Em qui, 22 de nov de 2018 às 21:09, David Carlson < > david.carlson@gmail.com> escreveu: > > > I have not used the new CSV importer, so I am not sure whether this > com

Re: [GNC] Import CSV Multi-currency

2018-11-22 Thread David Carlson
I have not used the new CSV importer, so I am not sure whether this comment actually applies to your case... If the new CSV importer is used similarly to the old CSV importer, there is a step in the process to offer an opportunity to match the new transaction to existing transactions if there are

[GNC] Account ID when importing CSV Transactions

2018-11-18 Thread David Carlson
I have been using GnuCash for many years and I am still using release 2.6.17 or similar depending on which computer I am using. I just noticed that when I am importing a CSV transactions file and I get to the step to determine which account to import the transactions into, the list of accounts

Re: [GNC] Could not read the contents of GnuCash: Error opening directory '[path name here]': Permission denied

2018-11-16 Thread David Carlson
There could be several problems, and you may need to do some research to figure out which you are having and how to work around it. First, are you able to open and mount the Veracrypt volume. You will need to have the Veracrypt program installed and running and have your Veracrypt key to succeed

Re: [GNC] order of transactions for mutual funds

2018-11-14 Thread David Carlson
€ capital losses > > I hope it is now easier to understand my initial question. > > Thanks! > > > > El mié., 14 nov. 2018 a las 19:40, David Carlson (< > david.carlson@gmail.com>) escribió: > >> If funds were used to buy a different security f

Re: [GNC] order of transactions for mutual funds

2018-11-14 Thread David Carlson
n't the lots > functionality work for them? I believe that it uses FIFO exclusively... > > David T. > > On November 14, 2018, at 8:23 PM, David Carlson < > david.carlson@gmail.com> wrote: > > I think that Christian is asking a slightly different question. I > inter

Re: [GNC] order of transactions for mutual funds

2018-11-14 Thread David Carlson
I think that Christian is asking a slightly different question. I interpret it that in one parent custodial mutual fund account he purchased Fund A on dates 1, 2 and later then sold some or all of Fund A and bought Fund B in the same custodial account on date 3. Now I am not sure if he needs to

Re: [GNC] How to identify the parent account of any sub-account

2018-11-13 Thread David Carlson
I do not need to file a bug report about a missing highlight since it is only missing in release 2.6.17 and possibly other 2.6.x releases but not in the current 3.3 release. However, judging by recent flurry of emails regarding control over the new (to GnuCash) GTK-3 tools, it may not easy for

[GNC] How to identify the parent account of any sub-account

2018-11-12 Thread David Carlson
I have recently observed that in release 2.6.17 of GnuCash the parent account is not highlighted in the Edit Account window, at least when account colors are used for some accounts. Since release 2.6.17 is no longer supported by the developers, and, in fact, the current release uses a completely

Re: [GNC] (no subject)

2018-11-09 Thread David Carlson
I think that editing the FITID of a transaction in the OFX file will also trigger a 'new' import. David C On Fri, Nov 9, 2018 at 10:38 AM Derek Atkins wrote: > Changing the date on the transaction is not sufficient; GnuCash stores the > unique FITID to match against the OFX file, so it will

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

2018-11-04 Thread David Carlson
I based the estimate to be massive on your comments that you said you lost hundreds of transactions and it will take hours to reconstruct your lost data. If you make a backup every 15 minutes, you should only lose 15 minutes work at most. David C Sun, Nov 4, 2018, 7:56 PM btrib 100

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

2018-11-04 Thread David Carlson
Btrib, I believe the CSV importer in release 3.3 is greatly improved over the old importer. However, being relatively new it probably has a few kinks remaining to be worked out. IT appears that you are trying to do a massive import from old files, possibly without sufficient planning and

Re: [GNC] Backup

2018-11-02 Thread David Carlson
So because Liinux does not use a backslash, that is erroneous? On Fri, Nov 2, 2018 at 11:15 PM Wm via gnucash-user < gnucash-user@gnucash.org> wrote: > On 01/11/2018 09:27, Geert Janssens wrote: > > Op woensdag 31 oktober 2018 17:09:27 CET schreef Wm via gnucash-user: > >> On 31/10/2018 01:24, D

Re: [GNC] Backup

2018-11-02 Thread David Carlson
that is not a constructive comment. David C On Fri, Nov 2, 2018 at 11:00 PM Wm wrote: > On 01/11/2018 09:19, Colin Law wrote: > > On Thu, 1 Nov 2018 at 08:23, Wm via gnucash-user > > wrote: > >> > >> On 31/10/2018 01:24, D via gnucash-user wrote: > >>> Check out

Re: [GNC] delete transactions

2018-11-02 Thread David Carlson
James, Look under File>Properties>Accounts and see if you have set a value for Day Threshold for read only transactions. If so, either increase the number of days or set it to zero to disable it. Then you should be able to edit the transaction to assign an account to any split line or even add

Re: [GNC] Trying to use gnucash need to convert .qdf to /qif

2018-11-02 Thread David Carlson
If I recall correctly QDF format is a proprietary and encrypted format owned by Intuit. The only way to extarct the data is to use the Guicken program to open the file and then export to QIF format. Hang on to Quicken until you have experimented with importing the QIF files into GnuCash to be

Re: [GNC] Backup

2018-11-01 Thread David Carlson
Wm, If you think that link contains incorrect and misleading information, why don't you contact the developers and help them correct it. David C On Thu, Nov 1, 2018 at 3:22 AM Wm via gnucash-user wrote: > On 31/10/2018 01:24, D via gnucash-user wrote: > > Check out

Re: [GNC] int

2018-10-31 Thread David Carlson
I do not think it is possible to make a zero value transaction split line actually show zeros. Years ago I set up a special income account that I called 'zComments' [to make it sort to the bottom] to use as a collector for transactions that were there just as reminders. Since then, GnuCash now

Re: [GNC] Online Banking Upgrade hosed Name and Memo field

2018-10-30 Thread David Carlson
changed credit > unions. Besides this one problem, I'm pretty happy at this one. > > Thanks! > > On Mon, Oct 29, 2018, at 11:41 PM, David Carlson wrote: > > What do you mean by online banking.? Are you actually using the OFX > import? > > If so, just do not use

Re: [GNC] Online Banking Upgrade hosed Name and Memo field

2018-10-29 Thread David Carlson
What do you mean by online banking.? Are you actually using the OFX import? If so, just do not use the option to update the transaction when matching. Then Gnucash leaves the description unchanged. David C On Mon, Oct 29, 2018, 7:49 PM John Ralls wrote: > > > > On Oct 29, 2018, at 5:38 PM,

Re: [GNC] No longer able to reconcile register accounts

2018-10-29 Thread David Carlson
Obviously the solution to your problem is to move to Arizona! David C On Mon, Oct 29, 2018 at 9:09 AM Colin Law wrote: > I am seeing similar problems in the UK running 3.3 on Ubuntu 18.10, from > Ubuntu repo. > The issue occurs if one tries to enter 28/10/18 in the statement date, > which is

Re: [GNC] alpha advantage

2018-10-28 Thread David Carlson
eekend. What list are you talking about that > I should "search?" > > On Sun, Oct 28, 2018 at 9:57 PM David Carlson > wrote: > >> Steven, >> >> AlphaVantage stopped working for those of us with more than a few >> securities several months ago when t

  1   2   3   4   5   6   >