Re: [GNC] OFX import file xml tags for accounts

2018-10-26 Thread David Carlson
John, GnuCash is designed to remember those choices after the first import. Sometimes the choices vary, but GnuCash always proposes a choice and gives you a chance to override it. David C On Fri, Oct 26, 2018, 4:20 PM John A Brown wrote: > gnuCash successfully imports OFX file from my bank.

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

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

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] (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] 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
€ 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] 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] PriceQuotes and AlphaVantage assistance request

2018-10-04 Thread David Carlson
nvsoar, You could look at getting some of your prices via yahoo_json instead of Alphavantage. It is near the bottom of the Single Quote source list in the security editor. That works for me with US stocks. David C On Thu, Oct 4, 2018 at 3:56 PM John Ralls wrote: > > > > On 4 Oct 2018, at

Re: [GNC] checking account

2018-10-09 Thread David Carlson
Hi Varda241, It sounds like you are used to seeing the Basic Ledger View with a single line setting. Possibly, the Funds In and Funds Out columns were called On Tue, Oct 9, 2018 at 7:02 PM Varda Rotenberg via gnucash-user < gnucash-user@gnucash.org> wrote: > Had to reinstall gnucash on ubuntu

Re: [GNC] checking account

2018-10-09 Thread David Carlson
Hi Varda241, It sounds like you are used to seeing the Basic Ledger View with a single line setting. Possibly, the Funds In and Funds Out columns were called Deposit and Withdrawal. These features can be changed easily. If you go to the Gnucash.org website and find the Help manual and Tutoria

Re: [GNC] checking account

2018-10-10 Thread David Carlson
ally has SubAccounts. David C On Wed, Oct 10, 2018, 8:19 AM varda241 wrote: > Thanks, but all 3 views still have the same view of 3 or 4 lines. > > > > Sent from my Verizon, Samsung Galaxy smartphone > > > ---- Original message > From: David Carlson

Re: [GNC] Latest Manual?

2018-10-10 Thread David Carlson
That couldn't possibly be junk. It has to be history!!!  David C On Wed, Oct 10, 2018 at 10:50 AM Derek Atkins wrote: > John Ralls writes: > > > When I search using Google for “gnucash manual” I get that docs.phtml > > first, followed by the version 3 pdf for the T, the version 3 pdf > >

Re: [GNC] Scheduled transaction list column for a ount

2018-10-08 Thread David Carlson
Joel, I have not found a way to add columns to that list. What I like to do is append the amount and the "home" or bank account name to each description When I save it. David C On Mon, Oct 8, 2018, 10:59 AM joel_graff wrote: > Is it possible to show the amount of the scheduled transactions

Re: [GNC] Taking an existing transaction and scheduling future repeats

2018-09-03 Thread David Carlson
Right click and schedule has been a feature for a long time. In fact that is my preferred way to do it On Mon, Sep 3, 2018, 3:21 PM Colin Law wrote: > On Mon, 3 Sep 2018 at 21:14, Stan Brown > wrote: > > ... > > I'd like to right-click it and have one of the options be to start the > >

Re: [GNC] Price Editor

2018-09-20 Thread David Carlson
Les, that seems very strange as the price editor should be displaying all the prices that are currently in the data file. Are you using the regular XML data file format or a database format? David C On Thu, Sep 20, 2018 at 4:20 PM Les wrote: > I have noticed that beginning this week

Re: [GNC] problem setting the price of a share

2018-09-19 Thread David Carlson
s prompting I found > them to be unnacceptably slow. > > Regards, > John Ralls > > On Sep 18, 2018, at 11:36 PM, David Carlson > wrote: > > John, > > Did you find a reference to floating point in my last message? If so it > was obsolete or inadvertent, as I k

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

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

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] Date Completion - sliding 12 month window

2019-01-18 Thread David Carlson
Parke, I can tell you that I am using release 2.6.17 in Ubuntu 16.04 with Unity desktop and that setting works for me, but all preferences are very slw to respond, just as file saves are too. When I hover over the radio buttons the text background changes, and If I click the button

Re: [GNC] Trouble entering Fund sale transaction

2019-01-19 Thread David Carlson
On Sat, Jan 19, 2019 at 8:14 PM Michael Matz wrote: > Try entering the number of shares, clear the value for price, entering the > total value and then hit return. GnuCash should then calculate the price. > > Michael > > On Fri, Jan 18, 2019, 5:11 AM Steve Kelem > > I have an account that is

Re: [GNC] OFX import sometimes loses transaction memos

2019-01-17 Thread David Carlson
On Thu, Jan 17, 2019, 1:15 AM Geert Janssens Op donderdag 17 januari 2019 06:33:25 CET schreef David Carlson: > > I think that I need to spend more time examining the transactions that > had > > their memos dropped during import to see if I can find a threshold string > > le

Re: [GNC] Features

2019-01-17 Thread David Carlson
> > > I migrated from Moneydance several years ago, then it was easy to use the QIF format. I think there were some rough edges, possibly involving stocks, so I recommend testing first. Good luck. ___ gnucash-user mailing list gnucash-user@gnucash.org

Re: [GNC] Reconciliation is not adding up correctly - what to do??

2019-01-19 Thread David Carlson
On Sat, Jan 19, 2019, 11:50 AM stephen.m.butler51 < stephen.m.butle...@gmail.com wrote: > My CC is set up as a straight liability account. Reconciliation works > fine with it. > > > Sent from my Verizon, Samsung Galaxy smartphone > Original message From: john_mike < >

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

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

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

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

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