Re: Preferred Date Format When Importing CSV Files

2017-07-29 Thread David Carlson
It does seem odd that the importer does not default to the same choice that the user has chosen for the data file, even though it is important to allow the user to change it if (s)he has a CSV file with a different choice. David C On Sat, Jul 29, 2017 at 7:36 AM, Jean-David Beyer

GnuCash with bad network connection

2017-07-31 Thread David Carlson
My home Wi-Fi has suddenly developed a bad case of dropouts in spite of a very strong signal. Several times a day various devices need to reconnect. With that background, if GnuCash is in the process of saving the data file (over Wi-Fi) when the dropout happens, GnuCash appears to hang and my

Re: gnucash update on debian errors, then stops

2017-08-01 Thread David Carlson
Is that the new package of release 2.6.17 from getdeb that I just tried to download into Ubuntu and have not had time to test yet? David C On Aug 1, 2017 8:25 PM, "John Griessen" wrote: > I have not been able to upgrade gnucash for a while now. > > Will there be a

Re: Scheduled Transaction Help :(

2017-08-03 Thread David Carlson
Another thing to try that once helped me to fix some old and broken SEx's (android did tat and I can't fix it.) is to enter zero's into every empty acccouunt value box so there are two values in each line. Sounds crazy but it actually worked David C On Aug 3, 2017 2:48 AM, "Steve"

Re: advice on software

2017-08-11 Thread David Carlson
Chris, There is a steep hill to climb to export history from a 'Q' program and import it into GnuCash. Many of GnuCash's current users felt that it was worth the effort to switch. Even if you do not import any history, there is a learning curve to get your account tree set up correctly, etc.

Re: Reporting Repository ?

2017-07-03 Thread David Carlson
Did you look at gti90...@gmail.com answers in the clean CSI export thread? David C On Jul 3, 2017 9:42 AM, "John Ralls" wrote: > > > > On Jul 3, 2017, at 6:38 AM, aegross wrote: > > > > On Mon, Jul 3, 2017 at 12:50 AM, John Ralls-2 [via GnuCash] < > >

Re: Repeating transactions crash Gnucash 2.6.16 and 2.2.17

2017-07-05 Thread David Carlson
When you say you use the transaction again, do you mean that it is scheduled and comes up when running the Since Last Run Assistant? Exactly at what point does it crash? David C On Thu, Jul 6, 2017 at 1:14 AM, Frank wrote: > I'm relatively to gnucash and am looking to

Re: "Point of sale debit or credit (Note: Depends on signage of amount)" appended to transactions in 2.6.17

2017-07-06 Thread David Carlson
Sorry, I am confused about field names. Is that new message in the description field instead of the current data or is it actually in the Notes field where the previous message was prepended to the FI note? David C On Thu, Jul 6, 2017 at 1:26 PM, David Carlson <david.carlson@gmail.

Re: Is there a way to set an account's beginning balance AFTER having created it in GnuCash?

2017-07-28 Thread David Carlson
Bob, The Opening Balance shortcut that you see when creating an account is not functional after the account is created, as you have seen. That shortcut just creates a transaction to offset the opening balance with an entry in Equity:Opening Balances. You can open that account and duplicate any

Re: population

2017-08-02 Thread David Carlson
Christine, It seems that you are the first to report your problem. That is why the developers are asking so many questions about details. Please check the about gnucash screen and tell them the exact release number and build date. David C On Wed, Aug 2, 2017 at 7:24 AM, Christine Maloney via

Re: Help on US Tax Form 8825

2017-08-09 Thread David Carlson
It is curious that this form is not in the list. For tax related accounts that cannot be assigned to the proper form you could just mark the account as tax related without the form assignment, and it will be in the report where you will at least be reminded to include it in your filing. David C

Re: Virtual accounts or line items

2017-08-06 Thread David Carlson
What I do is keep two register views open on the 'parent' account, one 'with sub-accounts' which shows the totals as seen by the bank and one normal register view which shows the amount not dedicated to the 'virtual' sub-account(s). As suggested in the thread that you cited, I do not tell the

Re: Suggestion

2017-08-06 Thread David Carlson
For me the time to move, decrypt, and decompress the data file and generate the register views and report views is so much longer than loading the program that I do not even try to measure that part. David C On Sun, Aug 6, 2017 at 5:50 PM, Greg Feneis wrote: > Also FWIW, I

Re: Virtual accounts or line items

2017-08-06 Thread David Carlson
ike would be for some "real" transactions to > reference the parent account and some to reference the virtual account. > Then when importing the QFX the import process would look in the parent > account and the sub-accounts. > > > On Sun, Aug 6, 2017 at 6:15 PM, David Carlson &

Re: Is there a GC function to separate a multi-split transaction into sepa rate, 2-split transactions?

2017-08-18 Thread David Carlson
Paul, I would not recommend doing that, as it would fill your bank account register with many entries that would be a nightmare to reconcile against your bank statement, but one brute force way to do it would be to duplicate the transaction as many times as necessary, then edit each one to delete

Re: Trial Balance does not include amount of Return of Capital Investment splits

2017-05-18 Thread David Carlson
Chris, It has been several years since I had a similar situation, but I see that GnuCash still has a stock split assistant (Chapter 11, I think of the tutorial) which helps to mash all of the parts of a split into a single transaction. Did you try that? David C On Thu, May 18, 2017 at 3:18 AM,

When does GnuCash create .log files?

2017-05-16 Thread David Carlson
I used to think that GnuCash created .log files periodically when theauto-save interval has passed since the last edit. Now, it seems that GnuCash does a complete file save according to that interval. If that is the case, why have a .log file? David C

Re: List of Equity, Expenses and Liabilities has disappeared

2017-06-12 Thread David Carlson
Are you using View>New Accounts Page to see the list of accounts? David C On Mon, Jun 12, 2017 at 4:37 AM, Jonathan Silvey wrote: > I > ​ ​ > have two problems that may or may not be related. > > First, when I want to go to my main list of assets and liabilities, the

Re: When does GnuCash create .log files?

2017-05-16 Thread David Carlson
none if I do an early save. David C Sent via the Samsung Galaxy S® 5 ACTIVE™, an AT 4G LTE smartphone Original message From: Buddha Buck <blaisepas...@gmail.com> Date: 5/16/17 2:41 PM (GMT-06:00) To: David Carlson <david.carlson@gmail.com>, gnucash-user

Re: Reconciling an account

2017-06-06 Thread David Carlson
I really hate to rain on your parade... Check your Edit>Preferences>Accounts>Reverse Balanced Accounts. I believe the default is labelled Credit, but that means Credit Card, Payable, Liability Equity and Income, and that is probably what is checked in your file. If that is so, then the balance

Re: Website down?

2017-06-08 Thread David Carlson
Must have been intermittent. I was there a couple of days ago too. David C On Jun 8, 2017 10:00 AM, "Maf. King" wrote: > ISTR that I was on it yesterday (or the day before. Looking at the FAQ to > point Edwin in the right direction). of course, I may have found a cache >

Re: Reconciling an account

2017-06-05 Thread David Carlson
I often have duplicate entries appear in transfer accounts when I import transactions resulting from imperfect matching during the import process. While these are usually easy to find and fix, sometimes I make an error and "fix" the wrong transaction or split. If a previously reconciled

Re: Reconciling an account

2017-06-06 Thread David Carlson
Ok, the next thing to do is to go into your register view and look at the running total next to each of the transactions that you show in your images, to see if the value was correctly added or subtracted by GnuCash. Also set the register view to Transaction Journal to see if there are any

Re: Notes column in SingleLine display

2017-06-18 Thread David Carlson
Well, if you read the manual you will find the answer to all your prayers, or at ieast to all the "faults" that you have found so far with GnuCash. Well, there is no way to replace the description with the notes other than to put the text that you want to see in the Description field. Isn't that

Re: Unrealized losses (or gains)

2017-06-18 Thread David Carlson
Alain Follow this link. http://gnucash.1415818.n4.nabble.com/Unrealized-losses-tc4691319.html#a4691532 David C On Jun 18, 2017 1:41 PM, "Kalin KOZHUHAROV" wrote: Hello, On Sun, Jun 18, 2017 at 6:45 PM, Alain Dormoy wrote: > My problem is I had in the past

Re: Transfer query.

2017-06-13 Thread David Carlson
To elaborate on Derek's explanation, all the 'Charges' in your credit card (Liability) account should appear on the right side in the credit card account, and on the left side in the various expense accounts if you 'jump' to the expense accounts. On Tue, Jun 13, 2017 at 11:44 AM, Derek Atkins

Re: Gnucash file is getting long!

2017-06-14 Thread David Carlson
I think that John Ogden has a valid question which should be covered better somewhere in the manual. The short answer, unfortunately, is that there is no way to split out old data to shrink the data file. Also, it is a fact that eventually your file may grow to the point where it taxes your

Re: Reconciling an account

2017-06-05 Thread David Carlson
Wow, now we are getting some well detailed suggestions! I will add a couple: To quickly see if all previous transactions were really reconciled, select View > Filter by .> Status > uncheck Reconciled. If you don't have too many transactions with dates earlier than the bank cleared them, your

Re: nomenclatural clarification - parts of a transaction

2017-09-14 Thread David Carlson
Good call David R, Another point of possible confusion for even long-time users like me is that the column titles will change as the curser moves around in the transaction display, so the user must carefully note the current position of the curser to correctly interpret the column title. David C

Re: [MAINT] Network Work on Code Sunday, Oct 1, 1-4pm EDT

2017-10-06 Thread David Carlson
Derek, Did you try replacing the cable? Low hanging fruit... David C On Fri, Oct 6, 2017 at 8:39 AM, Derek Atkins <warl...@mit.edu> wrote: > David Carlson <david.carlson@gmail.com> writes: > > > Derek, > > > > Is it possible to read event logs and deter

Re: [MAINT] Network Work on Code Sunday, Oct 1, 1-4pm EDT

2017-10-06 Thread David Carlson
; On Fri, October 6, 2017 10:27 am, David Carlson wrote: > > Derek, > > > > Did you try replacing the cable? Low hanging fruit... > > > > David C > > > > On Fri, Oct 6, 2017 at 8:39 AM, Derek Atkins <warl...@mit.edu> wrote: > > > >> Da

Re: only deposits show

2017-10-06 Thread David Carlson
;https://maps.google.com/?q=12454+Auberry+Rd._Clovis,+Ca_=gmail=g>* > *Clovis, Ca > <https://maps.google.com/?q=12454+Auberry+Rd._Clovis,+Ca_=gmail=g>.* > *559.297.8577 <(559)%20297-8577> H* > *559.304.1751 <(559)%20304-1751> C* > > On 10/2/2017 10:11:19 PM, Da

Re: importing

2017-10-07 Thread David Carlson
Frank and David T, I believe that the QIF importer may not work exactly the same way that it did back in the 2.2 series or the 2.4 series or even the 2.6 series before release 2.6.18. If that is the c as e then we really do need someone who is familiar with the way it works now to jump in and

Re: importing

2017-10-07 Thread David Carlson
, 2017 at 6:55 PM, frank raney <frankraney...@gmail.com> wrote: > > > *Frankie Raney* > *If it worked good in 2.2, then maybe I can get that version, try it and > if it works good, then upgrade.* > > On 10/7/2017 4:45:51 PM, David Carlson <david.carlson@gmail.com

Re: only deposits show

2017-10-02 Thread David Carlson
You do not mention important details that are needed to give a definitive answer, but assuming that you followed the a likely path, you exported transactions from your Quicken file in QIF format then imported them into GnuCash in the same format. The QIF format creates a data section for each

Re: simple find transactions report

2017-10-10 Thread David Carlson
ad to translate this to the menu entry > >"edit/find" (not "search") > > > >- elmar > > > >On 10/09/2017 04:16 PM, David Carlson wrote: > >> Geert, > >> > >> Gmail used those ing triple dots to hide yo

Re: command line QIF import

2017-10-15 Thread David Carlson
Not sure about more efficient ways to import via QIF, which, by the way, is reasonably efficient when done in small chunks, but another caveat that has not been raised recently is that as the data file grows it takes longer to do the frequent file saves. In Windows each save for my data file

Re: command line QIF import

2017-10-15 Thread David Carlson
I am not a developer, but I can point out that the QIF importer works in several discrete steps where (roughly) it 1. identifies the 'source' account type and name and tries to associate it to an existing account in the data file. If there is more than one 'source' account in the QIF file it

Re: command line QIF import

2017-10-16 Thread David Carlson
Nelson, It sounds to me like you are unwilling make the effort to "shepherd" your data through the import process. Many of us, including David T are trying to tell you that we have succeeded in completing massive imports from Quicken into GnuCash, but we needed to take several steps to plan our

Re: Account report error for transactions the last 30 days

2017-10-14 Thread David Carlson
I think that what you both are seeing is, in fact, as you have correctly asserted, Garbage In Garbage Out. Normally there are no running totals in search register views because they are an accumulation of transactions over an indeterminate sub set of the entire data set. Then a report derived

Re: Migrate from Moneydance to Gnucash

2017-10-16 Thread David Carlson
I think it is about the same as from Quicken, but perhaps easier because Moneydance is closer to being double entry. If they still have QIF exports ... David C On Oct 16, 2017 8:51 AM, "Roger Miskowicz" wrote: > Is there a recommended procedure for migrating Moneydance

Re: Scheduled transactions

2017-09-25 Thread David Carlson
ate tab. Thanks > > On Sep 25, 2017 2:04 PM, "David Carlson" <david.carlson@gmail.com> > wrote: > >> On the Template tab it is in the upper left as in the register view. >> >> David C >> >> On Mon, Sep 25, 2017 at 12:23 PM, <rmom...@gm

Re: Merging imported transactions

2017-09-25 Thread David Carlson
The OFX import assistant includes a step to match newly imported transactions to existing transactions, as you probably noticed. The problem is that it is error prone and has to be monitored carefully during the import process. I prefer to import a small number of transactions at a time so that

Re: What's the best way to model an electronic funds transfer pull with hold

2017-10-01 Thread David Carlson
Nelson, Just one comment from another user; My banks do not show holds online, or if they do, it is a simple summary of book balance vs available balance. They warn that ACH transfers these-days often clear on the same day. To me, it is too much effort to try to track that, and as others have

Re: [MAINT] Network Work on Code Sunday, Oct 1, 1-4pm EDT

2017-10-02 Thread David Carlson
That might be difficult, as it may be a loose connector or even corrosion inside a cable or connector or component in a power supply or ??? Good luck. David C On Oct 2, 2017 10:42 AM, "Derek Atkins" wrote: > Hi, > > Just a quick follow-up. > > AT did come, and with their help

Re: What's the best way to model "in-flight" transactions?

2017-09-28 Thread David Carlson
I think the answer is "What works best for you." When most of our bank account transactions were checks (cheques in many countries) we entered each check by date and number in the checkbook register. When the bank statement came we compared it to our register, checking off each one that appeared

Re: [MAINT] Network Work on Code Sunday, Oct 1, 1-4pm EDT

2017-10-03 Thread David Carlson
Derek, Is it possible to read event logs and determine that some pieces of equipment are definitely not causing the problem? David C On Oct 3, 2017 10:04 AM, "Derek Atkins" wrote: > GWB writes: > > > So AT's network equipment works when nothing is connected

Re: Budget Slowing Down Windows 10

2017-08-25 Thread David Carlson
monitor tool of some sort that you can run to see > how much memory is being used. Try running that and then the report > and see if you are running out of RAM > > Colin > > On 24 August 2017 at 22:59, David Carlson <david.carlson@gmail.com> > wrote: > > It i

Re: Tax Tables - an illustrated primer?

2017-09-03 Thread David Carlson
In the United States "Sales Tax" is a generic term for taxes that are collected at the point-of-sale and usually turned over to a state, city, county or other government agency by retailers. It is even difficult to make a concise and grammatically correct statement to describe the process. I

Re: Re : Could not obtain the lock

2017-09-02 Thread David Carlson
It sounds like you are starting GnuCash more times than you are shutting it down. GnuCash can open more than one instance at a time, which would cause the same message. Take care to return to the open instance rather than starting a new instance when you return, because it is possible to lose

Re: Re : Re : Could not obtain the lock

2017-09-02 Thread David Carlson
hile I save whatever still needs to be saved and I click on the cross in the upper right corner of my screen (am I missing something?) * *Alain* *De :* David Carlson <david.carlson@gmail.com> *Date :* samedi 2 septembre 2017 12:37 *À :* Alain Dormoy <cag...@free.fr> *Cc :* Colin Law &l

Re: simple find transactions report

2017-10-09 Thread David Carlson
Geert, Gmail used those ing triple dots to hide your reply in my mail folder. Lucky for me I suspected as much when there appeared to be no reply . David C On Mon, Oct 9, 2017 at 2:48 PM, Geert Janssens wrote: > Start with a search from the account hierarchy

Re: importing

2017-10-08 Thread David Carlson
; > *Frankie Raney* > *12454 Auberry Rd. > <https://maps.google.com/?q=12454+Auberry+Rd._Clovis,+Ca_=gmail=g>* > *Clovis, Ca > <https://maps.google.com/?q=12454+Auberry+Rd._Clovis,+Ca_=gmail=g>.* > *559.297.8577 <(559)%20297-8577> H* > *559.304.1751 <(559)%20

Re: importing

2017-10-11 Thread David Carlson
Frank, There is still a problem with Gnucash on your computer because it should not be crashing. It may be somehow related to the account named Trading that GnuCash created. Normally, GnuCash will only create that account for users that know that they want to use a special feature that is there

Re: importing

2017-10-11 Thread David Carlson
I forgot to mention that there is a setting somewhere called "Use Trading Accounts" that turns that feature on or off. I think it is mentioned somewhere in the documentation. David C On Wed, Oct 11, 2017 at 4:07 PM, David Carlson <david.carlson@gmail.com> wrote: > Frank,

Re: importing

2017-10-11 Thread David Carlson
ps.google.com/?q=12454+Auberry+Rd._Clovis,+Ca_=gmail=g>.* > *559.297.8577 <(559)%20297-8577> H* > *559.304.1751 <(559)%20304-1751> C* > > On 10/11/2017 2:14:08 PM, David Carlson <david.carlson@gmail.com> > wrote: > I forgot to mention that there is a se

Re: Customized saved-reports file per gnucash file (i.e. per company)

2017-10-10 Thread David Carlson
There is a section in the GnuCash FAQ about what files are where for the various OS's. IIRC there is a .gnucash directory under ~user or some such which can be copied and pasted into another machine, even under a different OS but that would overwrite whatever is there. Do not try that without

Re: importing

2017-10-12 Thread David Carlson
t; <https://maps.google.com/?q=12454+Auberry+Rd._Clovis,+Ca_=gmail=g>.* > *559.297.8577 <(559)%20297-8577> H* > *559.304.1751 <(559)%20304-1751> C* > > On 10/11/2017 10:00:32 PM, David Carlson <david.carlson@gmail.com> > wrote: > What O S are you installing int

Re: command line QIF import

2017-10-17 Thread David Carlson
John R. Sowden, Could you please elaborate on your assertions that 1. "errors, often based on changing amounts (2 debits, etc.,) are hidden from the user." 2. "A 'preference' switch to allow users who are familiar and comfortable with the 'Intuit Way' to continue, vs. those with accounting

Re: exporting

2017-10-23 Thread David Carlson
Are you having a problem using the Export function or is your problem with reading the output with a spreadsheet program? David C On Mon, Oct 23, 2017 at 3:58 PM, Jonathan Silvey wrote: > Hi, > > I'd like to export a single account to Excel but I can't find Export on

Re: CSV Imports

2017-10-24 Thread David Carlson
Nick, The CSV import assistant in release 2.6 series is not able to import files created by GnuCash. This is a known problem which will be corrected when the 2.8 release comes out. That release will change the data file structure in a way that will not be readable by older releases of GnuCash.

How to install an updated Finance-Quote module in Linux

2017-11-12 Thread David Carlson
I thought I saw instructions somewhere on how to update the Finance-Quote module, but now I cannot find it. The instructions in the GnuCash FAQ are not sufficiently complete for dummies like me. I get an error gnc-fq-update command not found then I do not know what to do next. David C

Re: GNU Cash Transactions - Wiped Out

2017-11-10 Thread David Carlson
Roy, What is the name of your data file and where do you have it stored? If all the accounts are devoid of transactions, are they all present? Did you look for the backups that are mentioned in the online FAQs? David C On Thu, Nov 9, 2017 at 2:39 PM, Roy Molepo wrote:

Re: Slow startup on Windows 10, v2.6.18

2017-11-28 Thread David Carlson
Steve, As far as I know, what you are describing has been the way GnuCash works on Windows for the entire life of the 2.6 series as well as the 2.4 series releases. I am currently using various releases from 2.6.12 on to release 2.6 16 in Windows and Linux and I see the same with files saved in

Re: QIF or QXF file for Quicken to GnuCash migration?

2017-11-25 Thread David Carlson
Is there a way to export data from Quicken in QXF format? On Sat, Nov 25, 2017 at 9:50 AM, Ken Schneider wrote: > On 11/24/2017 05:15 PM, Kenneth Schneider wrote: > >> I did this a few months ago and found it best to do each quicken account >> separately. If the

Re: Could not obtain the lock

2017-11-22 Thread David Carlson
Moira, Do you have similar problems with other files on that computer? Do you check it for malware regularly? It seems a little odd that you were able to place the file there without write permission unless you do have multiple users on that computer. You may need to find an expert that is

Re: Could not obtain the lock

2017-11-22 Thread David Carlson
Moira, You have the attention of several different experienced GnuCash users from various different backgrounds, and we all share your frustration. Your experience does not match that of a typical user. In my opinion there is something unusual about your computer or how you managed to get the

Re: bank entries

2017-11-26 Thread David Carlson
Christine, If you receive income you might deposit it into the bank. If you spend money for groceries, you use cash. If you withdraw money from the bank you transfer from bank to cash. That is what double entry is about. David C, On Sun, Nov 26, 2017 at 6:33 PM, Christine via gnucash-user <

Re: Enhancement Request for GNUcash

2017-12-04 Thread David Carlson
Are you asking for GnuCash to perform magic or just pretend? David C On Dec 5, 2017 12:25 AM, "Jesse Cochran" wrote: > To whom it may concern, > > Given how limited and un-free our monetary system is nowadays, I think > GNUcash would make a great tool for the

Re: A BASH script to help get tax-related data from gnucash

2017-12-16 Thread David Carlson
Could this script be referenced somewhere in the GnuCash WIKI? David C On Sat, Dec 16, 2017 at 3:44 AM, David T. via gnucash-user < gnucash-user@gnucash.org> wrote: > I’m sorry. Your original characterization was vague, and I didn’t > understand what your issue with that report was. I see what

Re: Error in Tip of the Day

2017-12-16 Thread David Carlson
The two bug reports contain different descriptions of the reasoning behind calling it a bug, so I think that it would be appropriate to just leave them cross referenced until the situation is resolved, rather than marking one as a duplicate. David C On Fri, Dec 15, 2017 at 9:25 PM, Daniel

Re: How to find out which securities need to be switched from Yahoo to Alphavantage

2017-11-13 Thread David Carlson
at 11:20 AM, D <sunfis...@yahoo.com> wrote: > See below. > > On November 13, 2017, at 9:02 PM, David Carlson < > david.carlson@gmail.com> wrote: > > >I have been using GnuCash for many years and there are many securities in > >my file that I no longer own,

How to find out which securities need to be switched from Yahoo to Alphavantage

2017-11-13 Thread David Carlson
I have been using GnuCash for many years and there are many securities in my file that I no longer own, but I may or may not have discontinued downloading their prices. In trying to get my Alphavantage source working, it appears that it does not work if there is a mix of some securities changed

Re: Reconciling Manually Downloaded Transactions

2017-11-20 Thread David Carlson
AAK, Yes, that is the way Gnucash behaves when you select the Update + Reconcile option while matching transactions. I rarely use that option for that very reason. I mostly use the Reconcile option. I will get on my soapbox here, since I think that the word Reconcile is not used correctly in

Re: Reconciling Manually Downloaded Transactions

2017-11-20 Thread David Carlson
the file before starting the import. I recommend saving first in every case. David C On Mon, Nov 20, 2017 at 6:57 PM, David Carlson <david.carlson@gmail.com> wrote: > AAK, > > Yes, that is the way Gnucash behaves when you select the Update + > Reconcile option while matchin

Re: Could not obtain the lock

2017-11-21 Thread David Carlson
Moira, The lock file is always in the same folder as the data file and it always has the same name as the data file with the suffix .LCK Unless you are doing something very unusual, the files will be visible in your file explorer as long as you put them somewhere in your user folder on your

Re: Could not obtain the lock

2017-11-21 Thread David Carlson
I believe that others will concur that you do not have write permission in the folder containing that data file. Is your user name User? That is also why GnuCash failed to create a .LCK file. You need to make a new folder on your desktop, call it Moira_GnuCash_Data or similar and use file

Re: Restarting a Scheduled Transaction - possible ?

2017-11-21 Thread David Carlson
AEG, I have succeeded in re-using scheduled transactions but there are some limitations. In your case, I think that using the for some number of occurrences may be what is preventing further use of that SX. I have never used that box. Last Occurred is only settable by the program so once it

Re: Gnucash 2.7 on Windows

2017-11-17 Thread David Carlson
I assume that you know that 2.7 is is a pre-release version, I would call it an alpha or beta version, not for production use. That said, I thought that the developers had updated it so that it did not crash instantly in Windows. Be sure that you have the most recent build. It may be a bit hard

Re: GnuCash skips lines with identical dollar amounts during bank statement import

2017-11-05 Thread David Carlson
Todd, The OFX/QFX import requires a lot of TLC during the import to get everything right. During the verification step it is critical to examine each transaction carefully to be sure that if it is new it gets added, if it matches an existing transaction in your data it is matched to the correct

Re: General Journal - history limit and search

2017-11-01 Thread David Carlson
w. I'll try that tomorrow. Thanks > > On Oct 31, 2017 7:20 PM, "David Carlson" <david.carlson@gmail.com> > wrote: > >> Roger, for your second question, I think that a search in the General >> ledger view should produce it's results in a new results view rather

Re: finance-quote error

2017-11-02 Thread David Carlson
I wonder exactly what "Term of Service" we violated? David C On Thu, Nov 2, 2017 at 6:10 PM, MGC wrote: > The error message I'm getting now says: > > It has come to our attention that this service is being used in violation > of > the Yahoo Terms of Service. As such, the

Re: finance-quote error

2017-11-02 Thread David Carlson
at 7:03 PM, David Carlson <david.carlson@gmail.com> wrote: > I wonder exactly what "Term of Service" we violated? > > David C > > On Thu, Nov 2, 2017 at 6:10 PM, MGC <pis...@gmail.com> wrote: > >> The error message I'm getting now says: >&g

Re: finance-quote error

2017-11-02 Thread David Carlson
I found another program that may still be able to get prices, including historical prices. It just worked a moment ago to get the price of a NYSE stock. It would not be trivial to export tables from that program to import into GnuCash, but maybe someone wants to try... Google "TakeStock2" On

Re: Removal of unnecessary listed Account names

2017-11-09 Thread David Carlson
Where are you seeing the multiple account names? If you actually changed the names in your chart of accounts, there should not be accounts with the old names. Similarly, in the OFX, QIF and CSV imports, you should not see the old account names when matching transactions to existing. You will

Re: How to create an asset with a reduced value compared to my regular currency (dollars)

2017-12-07 Thread David Carlson
Adrian, While I am not an accountant, historically I have used a method similar to that suggested by Adrien. However, I am intrigued by the answer provided by Michael Novack, as it avoids the problem of overstating potentially taxable income without needing to have a group of accounts to

Re: GnuCash: Import CSV File Format

2017-12-07 Thread David Carlson
I don't think that there is a specification beyond the generic CSV format, which is grouping chunks of text separated by commas into groups separated by a carriage return. Check with your favorite spreadsheet program for help. When you want to import a file into GnuCash you then assign 'columns'

Re: What does "Update and Reconcile" update?

2017-12-10 Thread David Carlson
I always save the file just before importing so I can just close without saving after an import if I don't like the result. My experience has been that the U+R function in GnuCash adds something either to the Description or to the Notes line besides changing the date and possibly even the amount

Re: Interesting Discovery in my accounts -- more info...

2017-12-02 Thread David Carlson
Jay, My first thought is that sometime after you closed the books you probably inadvertently entered additional transaction(s) dated before the closing date. Did you make an archive backup then that you can compare to your balances as of that date in your current data? If there were a very

Re: Reconciliation Report

2017-12-03 Thread David Carlson
Adrien, First, the reconciliation window does not have an option to show the results of the reconciliation in a nice format 'Suitable for Framing". Second, it does not have a feature to display results of previous reconciliations, let alone have a way to correct errors in previous

Re: Crashes importing CSV

2017-10-29 Thread David Carlson
Hi Phillip I think that earlier versions would crash if the date format was not correctly selected. I am not sure if that has been fixed in the current release. David C On Oct 29, 2017 12:42 PM, "Phillip Gotobed" wrote: > Hello everyone, > > I've been using gnucash for a

Re: General Journal - history limit and search

2017-10-31 Thread David Carlson
Roger, for your second question, I think that a search in the General ledger view should produce it's results in a new results view rather than the first General Ledger view. However, if I am wrong about that, it should be simple to open a new General Ledger view from the menu. You should not

Re: New User to GnuCash

2017-12-20 Thread David Carlson
Jack Look under Edit>Preferences>Register>Register Defaults>Register Opens in a New Window.. I tink that box should be unchecked by default, but it may have changed. I think that setting goes with the data file, so it may be different in different files. David C On Wed, Dec 20, 2017 at 11:25

Re: [GNC] VISA Debit Card was gnucash-user Digest, Vol 182, Issue 8

2018-05-07 Thread David Carlson
On Mon, May 7, 2018 at 1:32 AM, Karen Stingel wrote: >How does gnc handle the Case of a VISA Debit card? >Technically, this is a BANK account with a VISA enabled card and a >$0.00 Credit Limit >Should it just be created as a normal BANK account type? >

Re: [GNC] Tax Report Options not working

2018-05-08 Thread David Carlson
Tom , Since you are using Windows 10 the issue must be a Windows thing. Are you using the official release or one of the nightly builds? I don't know if the developers would suggest trying one of them for this issue, but I see that there is a May 6 build in the nightly directory. <

Re: [GNC] Data format compatibility between recent versions

2018-05-14 Thread David Carlson
We need clarification on this because I recall seeing that files touched by testing releases in the 2.7 group and 3.0 and 3.1 were changed so they were no longer readable by releases prior to 2.6.21. David C On Mon, May 14, 2018 at 2:45 PM, John Pastore wrote: > I reviewed

Re: [GNC] how do I get different dates for balancing transactions when transferring amounts between two accounts

2018-05-14 Thread David Carlson
We all have our own definition of the the best way to handle these 'float' issues. While most of us simply choose to let the date be technically incorrect in some accounts, others create what I believe are called 'suspense' accounts to serve as containers for the 'float'. Those accounts could be

Re: [GNC] Data format compatibility between recent versions

2018-05-14 Thread David Carlson
; > 6) Days later (just now) copied most recent datafile from #4 back to GNC > 2.6.12 on Ubuntu just to see if prior success had been a fluke. Everything > still looks fine. > > Hope this history is helpful. > > John > > On Mon, May 14, 2018 at 6:22 PM, David Carlson < &

Re: [GNC] Tax Report Options not working

2018-05-07 Thread David Carlson
I cannot say whether version 3.x is different as I have not tried that, but in the 2.6.x versions it is necessary to use the tax report options configuration to assign a tax form, line number and copy number to each tax worthy account individually before it will appear in the Tax report. Since

Re: [GNC] 3.1 + Win10, TIME it takes to SAVE

2018-05-13 Thread David Carlson
That's still better than 2.6.xx releases in Windozezzz David C On Sun, May 13, 2018, 2:36 PM randix wrote: > Saw the SAVE AS issue in 3.1+Win10, but in a quick search, didn't see this > (apologize if I missed it)... > > Using 3.1 + Windows 10, why does it now take

  1   2   3   4   5   6   7   8   9   10   >