Re: [GNC] Impossible to generate reports.
What OS/Distro are you using? -derek Sent using my mobile device. Please excuse any typos. On May 18, 2019 5:36:40 AM cag...@free.fr wrote: Hello. I have been using GC for years to my satisfaction. All of a sudden, I can't generate reports (balance sheet or result acount). The result is NOT a report with zeros, it's merely NO report at all. The page remains blank. This applies to all the folders (let's call them "companies") I'm managing. After searching the help archives, I checked that the currency is set to the one I'm using which is EUR. I was using version 3.2 so I installed 3.5. Still no result. Any help much appreciated. TIA Alain ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Manual Exchange rates
Mahir writes: > Sorry. My bad. I meant to type 1:46.7 for the first exchange rate. > If that is the case, then what is the purpose of the dates on the price > database. Shouldn't it fetch as per the date? > Thanks for you help btw. The transactions in the register are fixed, so those exchanges are at the conversion entered with the transaction. The PriceDB is only used when converting rates in reports (or the Chart of Accounts). For that, the "most recent" or "closest-in-time" is used, depending on the display case. This is because GnuCash is trying to show you the value of your holdings at the date in question. > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. -derek -- Derek Atkins 617-623-3745 de...@ihtfp.com www.ihtfp.com Computer and Internet Security Consultant ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] QFX vs OXR/QXF
Hi, Richard writes: > Both my Quicken 2016 and my bank institutions export to QFX files. But > GnuCash only offers import from OXF/QXF files. Is this a GnuCssh typo > or bug, i.e., misplacement of the "X" in the file extension? It is not a typo. There is a difference between OFX/QFX and QXF. OFX/QFX is the Open Financial eXchange (and a quicken variant). GnuCash can import this. However, QXF is the Quicken eXchange Format, which is their new, proprietary storage format. GnuCash cannot import QXF. Are you sure your bank is exporting QFX and not QXF? Also, could you get quicken to export QIF? Hope this helps, > Thanks, > > Richard > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. -derek -- Derek Atkins 617-623-3745 de...@ihtfp.com www.ihtfp.com Computer and Internet Security Consultant ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Manual Exchange rates
Hi, Mahir writes: > Hi guys, > > I have an issue with how Gnucash fetches exchange rates. > I made an entry on a particular date between two currencies and manually > entered the FX rate in the price editor with the same date. > However the system takes the latest date for the FX rate. How can I correct > this to use only the given date? > > I made an entry between an account in currency SAR and another account with > the same currency on 18/03/2019. My locale currency is LKR. The FX rate on > this day was SAR1 = LKR47. > However prior to this I had an entry dated 21/03/2019 where the FX rate was > @1:47. > In the accounts page as well as any generated reports, it uses the latter > rate for conversion to my locale currency. > Any help on how to make it take the same date? It always tries to use the most recent (or closest-to-date) exchange rate. So of course March 21 will take precendence over March 18. Considering both at 1:47 I don't see the problem. > I tried searching for this on the forum but could not find anything that > solves this issue. > Thanks in advance guys. > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. -derek -- Derek Atkins 617-623-3745 de...@ihtfp.com www.ihtfp.com Computer and Internet Security Consultant ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Import CSV Multi-currency
Hi, boldstripe writes: > Just checking: am I correct in expecting Gnucash 3.5 to have the same problem > with multiple-currency CSV data as Gnucash 3.4? > > The origina bug report is here: > https://bugs.gnucash.org/show_bug.cgi?id=796955 This bug is still open, so I would not expect the status to have changed in the code. > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. -derek -- Derek Atkins 617-623-3745 de...@ihtfp.com www.ihtfp.com Computer and Internet Security Consultant ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Mail formatting
Hi, Eric Coates writes: > > Hi Gert > > For you (and other list recipients) perhaps but ... > > In your response you included my message; on my system I see *bold* > with the letters in bold and /italic/ with the letters in italic - > almost but not quite completely the same as you can see below. (I've > deliberately avoided using quotes marks around the offending texts > fearing they'd get messed with). The bold and italic using star(*) and slash(/) characters is purely an MUA function and has nothing to do with HTML or the list. > And, the message you sent (duplicated below) on the copy I'm looking > at is in blue. The list strips off text/html and only passes text/plain. There is no blue here, because the HTML was stripped. If you're seeing blue, it's a function of your MUA. > Oh well, it's another week and there'll be other challenges. > > Best wishes > > Eric > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. -derek -- Derek Atkins 617-623-3745 de...@ihtfp.com www.ihtfp.com Computer and Internet Security Consultant ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Need help reconciling
Hi, ToddAndMargo via gnucash-user writes: > okay, I am just not understanding. > > In the reconcile window > > 1) I presume "Statement Date" is my statement's closing >date? Correct. > 1) the statement date matches my bank statement Good. > 2) starting balance is 0 (it is not) I assume this is your first time reconciling in GnuCash? If so, that is correct. In general you can safely ignore the starting balance -- if there is a difference it means something "earlier" is not properly reconciled so you will need to click off "extra" stuff. > 3) Ending Balance matches my statement Good. If it doesn't you need to enter in the correct ending balance from your statement. > 4) there is a -$700 reconcile Balance. I presume there is a $700 opening balance in the account? Just reconcile that the first time, too. > I just do not understand Reconciliation is always "from the beginning of time through the end date". This means that the first time you reconcile an account you need to also include the opening balance transaction in the reconcile process. Going forward you wont have to do that, because the starting balance *should* match your account statement. Hope this helps! > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. -derek -- Derek Atkins 617-623-3745 de...@ihtfp.com www.ihtfp.com Computer and Internet Security Consultant ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] importing invoices as paid
Adrien Monteleone writes: > If they are paid, you’d need to have the payment transactions imported > as well. There isn’t any such thing as ‘paid’ with no actual > payment. (as far as I’m aware) You will both have to import the payment transaction, and you will have to *manually* attach the payment to the invoice/customer. There is no importer way to do that. > I don’t know of a way to auto-assign the transactions as being applied > in payment of any particular invoice once they are imported. You might > have to assign those one at a time. (but at least you don’t have to > create the individual transactions) Right. > Perhaps one of the devs familiar with the Business Features can offer > more insight. Nope, nothing more; there is no way to import that metadata at this time. > Regards, > Adrien > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. -derek -- Derek Atkins 617-623-3745 de...@ihtfp.com www.ihtfp.com Computer and Internet Security Consultant ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] undo close?
ToddAndMargo via gnucash-user writes: > On 5/8/19 3:28 AM, Geert Janssens wrote: >> Todd, do you remember which tab was open when you accidentally clicked the >> close button ? Was it a report tab, a register tab or an accounts tab or even >> something else ? > > I was in on of my credit card accounts. But, I checked and > the button is there is all my accounts. Sure, the button is there. It's just supposed to close the tab, which is what it does for me. >> And could you remember the exact message you received after closing that >> specific tab ? I have searched all of the gnucash source code and there's >> really only one message using the word "archive". The message lead me to the >> obscure function I pointed out before. But that doesn't seem to be >> triggerable... > > I don't remember the exact message. Just something to the effect > that it was going to archive my account, which I mistook as > thinking it meant it was go to save the entries I just made > back to the database. I still have no idea how it got to that. As Geert said, that message only appears once in the whole source code, and it's not from an accessible function. > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. -derek -- Derek Atkins 617-623-3745 de...@ihtfp.com www.ihtfp.com Computer and Internet Security Consultant ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Need loan to upgrade my truck
John Ralls writes: >> On May 8, 2019, at 5:43 AM, GeorgeMunday wrote: [snip] > > Dear Mr. Munday, > > Sorry, you've stumbled into the wrong list. We discuss a Free > accounting program called GnuCash here. We emphatically do not offer > financial advice. I am sitting here wondering if the original message was just an elaborate spam email? > Regards, > John Ralls > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. -derek -- Derek Atkins 617-623-3745 de...@ihtfp.com www.ihtfp.com Computer and Internet Security Consultant ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] undo close?
What do you mean archived? -derek Sent using my mobile device. Please excuse any typos. On May 7, 2019 9:45:56 PM ToddAndMargo via gnucash-user wrote: On 5/7/19 5:34 PM, Derek Atkins wrote: So it closed that tab (which is NOT closing the file). It closed and archived ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] undo close?
Hi, On Tue, May 7, 2019 7:38 pm, ToddAndMargo via gnucash-user wrote: >On 5/7/19 5:56 AM, Derek Atkins wrote: > > Which "close" did you accidentally hit, and where did you "hit" it? That attachment answered the "which", but not the "where". What Page/Tab were you on when you clicked it? As I suggested in my previous message (which you edited out in your reply and failed to fully respond to), I suspect you were on the Chart of Accounts page (tab). So it closed that tab (which is NOT closing the file). Hitting View -> New Accounts Page would bring it up again. Did you try that? Thanks, > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. -derek -- Derek Atkins 617-623-3745 de...@ihtfp.com www.ihtfp.com Computer and Internet Security Consultant ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Question about offset entery for inventory
Kebcoinc writes: > I just cannot remember. > When I am entering a transaction for one of my vendors, > I ordered some inventory, > I want to increase the liability for this vendor > What would I decrease to balance? Your inventory asset account. > I'm actually increasing my inventory and increasing my liability Right. If you credit the vendor and debit inventory, it will "increase" both (because a liability is a "negative" account). > Thanks > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. -derek -- Derek Atkins 617-623-3745 de...@ihtfp.com www.ihtfp.com Computer and Internet Security Consultant ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Okay, why won't it let me restore from backup?
ToddAndMargo via gnucash-user writes: > I restore yesterday's file and still get today's booboo You restored the XXX.gnucash file, which is just your data. > Why won't it let me restore from backup? Because you didn't restore the METADATA file, which contains your open tabs. This would be the XXX.gcm file that would need to be restored. > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. -derek -- Derek Atkins 617-623-3745 de...@ihtfp.com www.ihtfp.com Computer and Internet Security Consultant ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] undo close?
Hi, ToddAndMargo via gnucash-user writes: > Hi All, > > If you accidentally hit "Close", is there a way to undo it other > than from backup (which is what I did)? Which "close" did you accidentally hit, and where did you "hit" it? There are several options that come to mind: 1) The "Close Book" Tools-menu item 2) The [x] in the upper corner of the window (usually top-right in the titlebar area). This is the window-manager "close" and can cause GnuCash to exit. 3) The [x] in the tools-icon-row, which closes the current tab In the case of '2', it will close all tabs in the window. If this is the only window you have open, it will exit gnucash. In the case of '3', it depends which window/tab you were in when you hit the button. It SOUNDS like you did '3' in the Chart of Accounts tab. GnuCash *TRIES* to prevent you from doing this, but if you have multiple windows open you can still get it to happen. In this case, going to View -> New Accounts Page will create a new Chart of Accounts tab. Note that there is NOTHING you can do in the GnuCash window to delete your data en-masse. So there is no reason to have to "restore from backup" here. Hope this helps, > Many thanks, > -T > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. -derek -- Derek Atkins 617-623-3745 de...@ihtfp.com www.ihtfp.com Computer and Internet Security Consultant ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Rate column appeared after Balance
Hi, Colin Law writes: > Using 3.5 on Ubuntu , on just one of my Bank accounts a Rate column > has appeared to the right of the Balance column. I can push it off to > the right but it has a habit or re-appearing. I am not aware of > having done anything to make it happen. I imagine it is to do with > exchange rates, but I only use GBP and have checked that the account > is still set to that currency. > > I have looked through the preferences, looked in the manual and > Googled to no avail. > > Any suggestions on why it might have appeared and how to get rid of it? It's always there. It just defaults to 1 pixel wide. You must have accidentally double-clicked in the column or grabbed the rate-column header and dragged it. Just grab the right-side of the header and drag it left to again reduce the column width to 1 pixel. Alas, there is no way to have a "hidden" column in the register code. :( > Colin > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. -derek -- Derek Atkins 617-623-3745 de...@ihtfp.com www.ihtfp.com Computer and Internet Security Consultant ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] GnuCash Wiki Registration restored
Hi, Today it was reported that Wiki new-user registrations were not working. We traced this down to an update to mediawiki without also updating an extension back in February. This presented as an Internal Error whenever someone tried to register for a wiki account. The errant extensions have been updated and the resigration service should now be working. We apologize if you were affected by this outage. -derek -- Derek Atkins 617-623-3745 de...@ihtfp.com www.ihtfp.com Computer and Internet Security Consultant ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] * Unsaved book - Gnucash
Michael, On Thu, May 2, 2019 5:44 pm, Michael Hendry wrote: > > PS Panic over! > > I removed all files created after the last known good .gnucash backup file > - MDH.gnucash.20190502173103.gnucash - to a safe place. > > I then started Gnucash 3.4 in the normal way, and opened this backup file > when prompted for a filename. > > I made a couple of entries, saved as MDH.gnucash and Quit Gnucash. > > This time I was able to open the resulting file with Gnucash 3.5, make an > entry, save and exit in the normal way. > > I’ll keep a careful eye on developments over the next few days. > > Regards, > > Michael Hendry Please keep in mind that on the Mac, double-clicking on a GnuCash file has no effect. It will start GnuCash, but GnuCash will ALWAYS open the last-used file and NOT (necessarily) the one you double-clicked. This is a Mac-specific limitation. > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. -derek -- Derek Atkins 617-623-3745 de...@ihtfp.com www.ihtfp.com Computer and Internet Security Consultant ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Please respond to this request for help!
>> > >>> ___ >>> gnucash-user mailing list >>> gnucash-user@gnucash.org >>> To update your subscription preferences or to unsubscribe: >>> https://lists.gnucash.org/mailman/listinfo/gnucash-user >>> If you are using Nabble or Gmane, please see >>> https://wiki.gnucash.org/wiki/Mailing_Lists for more information. >>> - >>> Please remember to CC this list on all your replies. >>> You can do this by using Reply-To-List or Reply-All. >>> >> > > -- > David H. Jaggar, MRCVS, DC > > Snail mail: > 26th October 2018 to 16th April 2019: > 1217 Cedar Avenue > Boulder > CO 80304 > US of A > Voicemail: > +1 (303) 449-7131 - home > +1 (303) 506-0025 - mobile > E-mail: davidjag...@gmail.com > > 17th April 2019 to 17th October 2019: > Uwch y Don > Church Bay > Rhydwyn, Holyhead > Ynys Môn, Wales > LL65 4HA > The British Isles > > Voicemail: > +44 (1407) 730-146 - home > +44 (7399) 304-685 - mobile > E-mail: davidjag...@gmail.com > > The above also applies to Jenai Services. > This e-mail is sent on behalf of David H. Jaggar, MRCVS, DC. Its contents > are confidential to the intended recipient and may be legally privileged. > If you are not the intended recipient: > 1) you must not disclose, copy, or distribute its contents to any other > person nor use its contents in any way; > 2) please contact David H. Jaggar immediately on (1)303-506-0025 quoting > the name of the sender and the addressee, then delete it from your system. > David H. Jaggar has scanned this e-mail for viruses but does not accept > any > responsibility for viruses once this e-mail has been transmitted. You > should scan attachments (if any) for viruses. > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. > -- Derek Atkins 617-623-3745 de...@ihtfp.com www.ihtfp.com Computer and Internet Security Consultant ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Logging into the forum
Hi, Justin Mathew writes: > Thanks Derek, > > Is there any reason why we do not have an official forum? Or is it > that users are happier with mailing list? > > This is my first mailing list subscription, hence I may not be aware > of those advantages it has over forums (if any). Many reasons... -- 20+ years of history. -- Monitoring a forum is MUCH harder, unless you use email notifications, in which case, might as well START with email. -- SPAM prevention is easier on a mailing list I could continue, but honestly, it's not worth my time.. Search the history to find more discussions about this. -derek -- Derek Atkins 617-623-3745 de...@ihtfp.com www.ihtfp.com Computer and Internet Security Consultant ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Column Width
Hmm. Justin Mathew writes: > GnuCash 3.5 complied from source into Bunsenlabs Helium (Debian Stretch). There was definitely some keyboard issues in 3.3, but it should have been fixed since then. Unless, of course, there's a GTK bug and you're hitting that. There's no reason you should not be able to type a slash in the date column. > Regards, > Justin Mathew > mjus...@protonmail.com -derek -- Derek Atkins 617-623-3745 de...@ihtfp.com www.ihtfp.com Computer and Internet Security Consultant ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Logging into the forum
Hi, On Thu, April 18, 2019 6:22 am, Justin Mathew via gnucash-user wrote: > Hi > > Can't I login to http://gnucash.1415818.n4.nabble.com/ using my email > address subscribed to mailing list and the password provided? I tried and > it didn't work. > > Do I have to register a new account? Nabble is a third-party service not at all connected with the GnuCash project. GnuCash has no forums, just an email list. Nabble takes that list and, in however they do it, provides a web front end. IF you decide to use Nabble's services, you are doing so completely separate from the GnuCash mailing lists. So to answer your question, yes, you need a separate login between Nabble and GnuCash. If you signed up for the GnuCash lists you can NOT use that login at nabble. And if you sign up for nabble, your posts will get moderated until you sign up for the list with GnuCash. Enjoy! > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. -derek -- Derek Atkins 617-623-3745 de...@ihtfp.com www.ihtfp.com Computer and Internet Security Consultant ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Zelle
Oh, and also, please remember to CC the list on all replies. (I didn't notice until after I hit send). -derek On Wed, April 17, 2019 4:04 pm, Derek Atkins wrote: > It depends why they send it to you. > I use Income:Gifts > Unless it's being used for something specific. > > Treat it the same way you would treat them sending you a check or handing > you cash. How would you record that? Well, it all depends on WHY they > are sending you a check or handing you the cash :) > > -derek > > On Wed, April 17, 2019 3:59 pm, Khristine Ann Ramella wrote: >> Yes, but if a friend sends you money do you label it as Income? I just >> used the plain Income category and not what I use for paycheck income so >> they would be separate? >> >> -Original Message- >> From: Derek Atkins >> Sent: Wednesday, April 17, 2019 3:56 PM >> To: Khristine Ann Ramella >> Cc: gnucash-user@gnucash.org >> Subject: Re: [GNC] Zelle >> >> I would just treat it the same way I would treat an ATM or Check -- as a >> direct transfer between Bank and Income or Expense. >> >> -derek >> >> On Wed, April 17, 2019 3:51 pm, Khristine Ann Ramella wrote: >>> How do you categorize Zelle coming into your account from friends and >>> so on? >>> >>> TY >>> >>> I did try to search this topic and was unsuccessful. >>> >>> Sent from Mail<https://go.microsoft.com/fwlink/?LinkId=550986> for >>> Windows >>> 10 >>> >>> ___ >>> gnucash-user mailing list >>> gnucash-user@gnucash.org >>> To update your subscription preferences or to unsubscribe: >>> https://lists.gnucash.org/mailman/listinfo/gnucash-user >>> If you are using Nabble or Gmane, please see >>> https://wiki.gnucash.org/wiki/Mailing_Lists for more information. >>> - >>> Please remember to CC this list on all your replies. >>> You can do this by using Reply-To-List or Reply-All. >>> >> >> >> -- >>Derek Atkins 617-623-3745 >>de...@ihtfp.com www.ihtfp.com >>Computer and Internet Security Consultant >> >> > > > -- >Derek Atkins 617-623-3745 >de...@ihtfp.com www.ihtfp.com >Computer and Internet Security Consultant > > -- Derek Atkins 617-623-3745 de...@ihtfp.com www.ihtfp.com Computer and Internet Security Consultant ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Zelle
I would just treat it the same way I would treat an ATM or Check -- as a direct transfer between Bank and Income or Expense. -derek On Wed, April 17, 2019 3:51 pm, Khristine Ann Ramella wrote: > How do you categorize Zelle coming into your account from friends and so > on? > > TY > > I did try to search this topic and was unsuccessful. > > Sent from Mail<https://go.microsoft.com/fwlink/?LinkId=550986> for Windows > 10 > > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. > -- Derek Atkins 617-623-3745 de...@ihtfp.com www.ihtfp.com Computer and Internet Security Consultant ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Column Width
Justin Mathew writes: > Michael, > >> If you type only DD then to the next field, it will assume the >> current month and year. > > This works. > >> If you type DD/MM and you’ll get the current year. Actually, there is a preference here where if you type DD/MM and tab out, it will choose from a 12-month rolling window to select the year. So right now, on April 17th, 2019, if I type 12/31 it would input 12/31/2018. > I can't type in the character / or - for that matter. What version of GnuCash? What OS/Distro? -derek -- Derek Atkins 617-623-3745 de...@ihtfp.com www.ihtfp.com Computer and Internet Security Consultant ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Column Width
Hi, On Wed, April 17, 2019 6:29 am, Justin Mathew via gnucash-user wrote: > I am wondering about this same thing as well. > > If you expand the width by double clicking on the edge of the column, it > adjusts to it's width but at the expense of the spreadsheet shifting right > of the fold. Yes, and then you can reduce the size of the Description field. The Description field will ALWAYS auto-expand to fill the window size, but it will not auto-reduce. So you need to expand the list beyond the window (so the scrollbar appears) and only then can you reduce the description field size. > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. -derek -- Derek Atkins 617-623-3745 de...@ihtfp.com www.ihtfp.com Computer and Internet Security Consultant ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Unable to import QIF or QFX.
David, David Cousens writes: > Evan, > > You should in principle be able to use either format, QFX or QIF (but Please do not confuse QFX with QXF. They are different. QXF is a Quicken eXchange Format -- it is proprietary and GnuCash cannot read it. QFX is a Quicken version of OFX, but follows the same SGML standard and CAN be imported. > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. -derek -- Derek Atkins 617-623-3745 de...@ihtfp.com www.ihtfp.com Computer and Internet Security Consultant ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Split transaction: more than two off-setting accounts
Rich, Rich Shepard writes: > Derek, > > Thank you. I did not see that in the user guide, nor became aware of using > the tab key by reading messages to the mail list. I am very surprised to hear this is not in the document. I suspect it is, but you missed it. This feature has been around forever. > That's a very useful capability. Indeed. > Best regards, > > Rich > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. -derek -- Derek Atkins 617-623-3745 de...@ihtfp.com www.ihtfp.com Computer and Internet Security Consultant ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Split transaction: more than two off-setting accounts
Rich, On Sat, April 13, 2019 3:10 pm, Rich Shepard wrote: > On Sat, 13 Apr 2019, Christian Kluge wrote: > >> Just change the values in the debit and credit columns. >> As long as the sums of debit and credit don’t match you can add further >> entries. > > Christian, > > That works as long as there are available rows. Two are the default so > when > I want to add two more rows closing and re-opening the transaction > presents > an imbalance row and another one. This provides the needed space. I've not > found a way to add more rows when that transaction is on the bottom of the > gnucash window. > > When the transaction is saved and a new pair of rows is displayed, > clicking > on the split transaction does display a new, blank row. No need to do that. Just tab off the second row (TAB off, don't hit Enter/Return), and Gnucash will create a new row for you. Enter that row. Tab off the end. Poof -- another row. Lather. Rinse. Repeat. Only hit Enter/Return when you are DONE with the whole shebang. > Regards, > > Rich > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. -derek -- Derek Atkins 617-623-3745 de...@ihtfp.com www.ihtfp.com Computer and Internet Security Consultant ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] two lines for every entry
Todd, ToddAndMargo via gnucash-user writes: [snip] > Hi Michael, > > I wrote my own database for my business. All payments > must match all charges. The reports even tell you > what line on what tax form to enter the totals. > It includes invoices and cost of goods sold. So > the "bookkeeping" is already taken care of. > > What I am after is a simple way to keep track of charges > and payments on my credit cards and my check books. > The goal is an easier way to balance against my bank's > statements without the need for white out when I add 2+2 > and get 3. > > I DO NOT CARE about categories and the like. That is > already taken care of in my database, right down to > the line on the tax form. GnuCash does not require you to use specific categories. You could just have a single account, "Expenses", and use that for all charges. So you could have a minimal account tree in GnuCash that looks something like: Assets Bank Liabilities Credit Card Income Expenses Equity Opening Balances Then you could just create transactions from Liabilities:Credit Card to Expenses for all your charges, and Assets:Bank for payments. But honestly, it really sounds like you've already implemented most of what you need already in your database, so you're probably better off just extending your existing database for the additional features you need. Had you started with GnuCash originally I would say something different, but really, using GnuCash for what you want probably is overkill since you've already got most of GnuCash's functionality implemented in your DB. Good Luck! > -T > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. -derek -- Derek Atkins 617-623-3745 de...@ihtfp.com www.ihtfp.com Computer and Internet Security Consultant ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] QFX import matching
Hi, Keith Bellairs writes: > Derek, > > The online banking preference for bayesian matching is checked. The problem is > most obvious, however, when I am importing a qfx file. When I use actions -> > online actions -> get transactions the matching algorithm seems to work. Is > the matching algo supposed to be applied for the File -> Import -> Import OFX/ > QFX case? Is there a separate preference for that case? There is not a separate preference. The process should work the same for OFX/QFX import vs. Online Actions. Indeed, it is the same underlying code. Perhaps the tokenizing is less effective in the OFX/QFX import such that it's not getting good tokens to match on? > Keith -derek > On Thu, Apr 11, 2019 at 11:16 AM Derek Atkins wrote: > > Hi, > > Keith Bellairs writes: > > > Thanks for the hint, David. But its more broken than that. Many/most of > my > > imports match correctly. The groceries one has been manually assigned > > dozens or hundreds of times and the match algo always fails. Do any of > the > > parameters in the preferences make a difference? > > > > The memo field in the imported qfx file is kind of long for this > company: > > BUFFALO M BUFF HARDWICK VT POS PURCHASE/PIN DDA 098894 > > and it is always the same. It has a special character in it. Somehow it > > baffles the import matcher. > > > > Sorry, I forgot the basic info, but the matcher has failed this way for > > (probably) years: > > Gnucash 3.4 > > MacOS 10.14.3 > > Are you sure you have Bayesian Matching turned on in your preferences? > > > Please remember to CC this list on all your replies. > > You can do this by using Reply-To-List or Reply-All. > > -derek > > -- > Derek Atkins 617-623-3745 > de...@ihtfp.com www.ihtfp.com > Computer and Internet Security Consultant > -- Derek Atkins 617-623-3745 de...@ihtfp.com www.ihtfp.com Computer and Internet Security Consultant ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] two lines for every entry
Hi,
ToddAndMargo via gnucash-user writes:
> Hi All,
>
> On a credit card account, when ever I enter a charge and press
> enter, I get a second line with the charge amount entered into
> the payments column. If I delete the payment line, it deletes
> the charge line too.
>
> A
>
> What the h***. ("Heck", what did you think I meant?)
Sounds like you have Auto-Split Ledger or Transaction Journal mode
turned on. Go to View -> Basic Ledger to return to single-line mode.
Another reason you would be in a Transaction Journal mode is if you did
"Open Subaccounts" when trying to open your account register.
Good Luck,
> Many thanks,
> -T
-derek
--
Derek Atkins 617-623-3745
de...@ihtfp.com www.ihtfp.com
Computer and Internet Security Consultant
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.
Re: [GNC] QFX import matching
Hi, Keith Bellairs writes: > Thanks for the hint, David. But its more broken than that. Many/most of my > imports match correctly. The groceries one has been manually assigned > dozens or hundreds of times and the match algo always fails. Do any of the > parameters in the preferences make a difference? > > The memo field in the imported qfx file is kind of long for this company: > BUFFALO M BUFF HARDWICK VT POS PURCHASE/PIN DDA 098894 > and it is always the same. It has a special character in it. Somehow it > baffles the import matcher. > > Sorry, I forgot the basic info, but the matcher has failed this way for > (probably) years: > Gnucash 3.4 > MacOS 10.14.3 Are you sure you have Bayesian Matching turned on in your preferences? > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. -derek -- Derek Atkins 617-623-3745 de...@ihtfp.com www.ihtfp.com Computer and Internet Security Consultant ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Support for .IIF and .QFX formats for Data import
Hi, On Wed, April 10, 2019 12:42 pm, Ken Schneider wrote: > On 4/10/19 6:11 AM, Derek Atkins wrote: >> We do support QFX. It is part of the OFX importer. >> >> We do not support IIF or QXF.. Those are proprietary formats and we have >> no immediate plans to attempt to reverse engineer them. >> >> -derek > > Dazed and confused here. > One line says QFX is supported, the other states QFX is not supported. Look more closely.. QFX is supported. QXF is not. > Ken > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. -derek -- Derek Atkins 617-623-3745 de...@ihtfp.com www.ihtfp.com Computer and Internet Security Consultant ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Please unsubcribe me
HI, On Wed, April 10, 2019 12:30 pm, Teresa wrote: [snip] If you look at the bottom of EVERY MESSAGE FROM THIS LIST: > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. Just click on that URL and remove yourself. Thanks, > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. -derek -- Derek Atkins 617-623-3745 de...@ihtfp.com www.ihtfp.com Computer and Internet Security Consultant ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Support for .IIF and .QFX formats for Data import
We do support QFX. It is part of the OFX importer. We do not support IIF or QXF.. Those are proprietary formats and we have no immediate plans to attempt to reverse engineer them. -derek Sent using my mobile device. Please excuse any typos. On April 10, 2019 5:42:39 AM syed huq via gnucash-user wrote: Hi, My Bank supports .IIF and .QFX formats for Data Import. Your documentations do not show support of these (yet). I have tried the ASCII CSV and I get errors during import. Any plans for these .IIF or .QFX format support ? Syed -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] search
Certainly not if they are in other splits. -derek Sent using my mobile device. Please excuse any typos. On April 7, 2019 2:27:00 PM Jeff Abrahamson wrote: Ah, yes, it didn't occur to me that it wouldn't search through the split memos. Jeff Abrahamson http://p27.eu/jeff/ http://transport-nantes.com/ On 07/04/2019 18:48, John Ralls wrote: Since it works when you search the whole book and fails when you search only one account, I must ask if you put the note in the memo field of the split for the account you're searching? Regards, John Ralls On Apr 7, 2019, at 9:21 AM, Jeff Abrahamson wrote: The list strips images, so information was lost. I have an entry with a memo field containing the word (text string) "=JUSTIFICATIF". J On 07/04/2019 18:05, Jeff Abrahamson wrote: [This is gnucash 2.6.19 on linux. Some day I'll upgrade to 3.x.] I have some transactions in which I've put a reminder that I am missing the bill or receipt so that (ideally) we will chase the person who owes it. But when I do a search for "description, note, or memo contains JUST" or even the full =JUSTIFICATIF, I get an empty result set (despite having checked "new search"). I'm only searching in the account where this happens. I can search for other words in the memo field. Is there something special about the equal sign? Or some other reason this might not be working? (I used the equal sign to make it easy to search for such tags, but that seems not to be working. This is my private hack for not having analytical accounting features.) If I search the entire book (search initiated from the accounts window), I do see results. It's doubly strange that the search is different depending on where I initiated it, given that all the results are in the one bank account. -- Jeff Abrahamson +33 6 24 40 01 57 +44 7920 594 255 http://p27.eu/jeff/ http://transport-nantes.com/ ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All. -- Jeff Abrahamson +33 6 24 40 01 57 +44 7920 594 255 http://p27.eu/jeff/ http://transport-nantes.com/ ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Starting new year
Hi, On Wed, April 3, 2019 8:36 pm, Richard Barmann wrote: > Do you start a new year with a balance from the previous year or with o > balance. None of the above. I archive the data file and just continue using it. > Richard Barmann > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. -derek -- Derek Atkins 617-623-3745 de...@ihtfp.com www.ihtfp.com Computer and Internet Security Consultant ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Where is my opening balance?
Hi, That page is just a shortcut to create a regular transaction from the new account to Equity:Opening Balances. You can just create that regular transaction yourself. -derek On Thu, April 4, 2019 1:03 am, ToddAndMargo via gnucash-user wrote: > Hi All, > > I have noticed that when I create a new account, if I > forget to enter something in opening balance, that > editing the account afterwards does not give me access > to enter an opening balance. > > Bug? Of is it just somewhere I have not looked? Very > frustrating! > > Many thanks, > -T > > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. > -- Derek Atkins 617-623-3745 de...@ihtfp.com www.ihtfp.com Computer and Internet Security Consultant -- Derek Atkins 617-623-3745 de...@ihtfp.com www.ihtfp.com Computer and Internet Security Consultant ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Bills in Gnucash
If this preference is added, it should also remove the A/R and A/P Account type choices! -derek On Mon, April 1, 2019 11:21 pm, David Carlson wrote: > Back in 2014 I used to think that going to Edit > Preferences > Business > and checking Enable Extra Buttons was about enabling business features, > but > I was told then that it is only about adding some un-named buttons on some > menus that were never documented. I agree that there should be a feature > to turn off business features for those of us that don't use them, because > sometimes they cause grief if accidentally or ignorantly activated. > > David Carlson > > On Mon, Apr 1, 2019 at 8:55 PM Adrien Monteleone < > adrien.montele...@lusfiber.net> wrote: > >> Thanks David, >> >> I was looking for that the other day and somehow glanced over it. >> Indeed, >> it is still there in 3.4. (about to install 3.5 shortly) I suppose, >> then, >> since preferences are user rather than book based that’s why the buttons >> were already there. I didn’t try to start GC from a fresh user >> perspective. >> I’d have to try an old copy of 2.6, but I seem to recall this being >> labeled >> as ‘enable business features’ (which also added the special accounts and >> added the Business menu) not just ‘enable extra buttons’, but my memory >> could be faulty. >> >> Regards, >> Adrien >> >> > On Apr 1, 2019, at 7:33 PM, David Carlson >> >> wrote: >> > >> > So far none of you have mentioned going to Edit > Preferences > >> Business >> and checking Enable Extra Buttons. Back in the Release 2.6.xx days that >> was necessary to even see the buttons to create invoices or whatever >> that I >> have never looked for because I was not using them. >> > >> > David Carlson >> > >> > On Mon, Apr 1, 2019 at 5:39 PM Adrien Monteleone < >> adrien.montele...@lusfiber.net> wrote: >> > >> > > On Mar 31, 2019, at 3:35 AM, David T. via gnucash-user < >> gnucash-user@gnucash.org> wrote: >> > > >> > > Oh. Let me go to nabble to figure out that you're replying to my >> post... now, having closed all the spammy windows for super resume... >> > >> > Or just use e-mail instead of Nabble? (or I’m sure something like >> uBlock >> Origin could zap those windows before they come into existence) >> > >> > > Having the new account assistant create a specific set of accounts >> IN >> NO WAY is "enabling business features." It's just a bunch of accounts. >> The >> features are always "enabled." We might as well speak of "enabling" >> double >> entry features in Gnucash when we open a register in transaction view. >> > > It is convenient, to be sure, to have these accounts created for me, >> but this is in no way something in preferences, as was implied in the >> message to which I was responding. >> > > There is NO special setting. To quote Monty Python, there is NO >> severed head beneath the bed. >> > > David T. >> > >> > I just opened a new file, chose the default ‘common accounts’ which >> did >> not include A/R and A/P and sure enough, the “Business” menu is visible >> as >> was the “New Invoice” button. (I didn’t go through the trouble of >> creating >> an invoice or bill and seeing what would happen) >> > >> > This was not always the case, certainly not at some point in the 2.6 >> series. I distinctly remember having to ‘enable business features’ to >> both >> get the Business menu as well as making the New Invoice button visible. >> I >> think doing so also created the special A/R and A/P accounts in my tree. >> > >> > Perhaps the business features which were originally an add-on module >> were finally integrated into the main program at some point. >> > >> > Regards, >> > Adrien >> > ___ >> >> ___ >> gnucash-user mailing list >> gnucash-user@gnucash.org >> To update your subscription preferences or to unsubscribe: >> https://lists.gnucash.org/mailman/listinfo/gnucash-user >> If you are using Nabble or Gmane, please see >> https://wiki.gnucash.org/wiki/Mailing_Lists for more information. >> - >> Please remember to CC this list on all your replies. >> You can do this by using Reply-To-List or Reply-All. >> > > > -- > David Carlson > ___
Re: [GNC] Parent Directories not Reflecting Sub-Directory Totals
Hi, On Mon, April 1, 2019 5:16 am, Dennis Marshall wrote: > Yes, I am looking at the account "tree". But why should I not see the > totals of my investments reflected in the parent directory when I can see > my bank totals reflected in the parent directory of my savings and > checking account? Also, can you clarify what a CUR is? Thanks CUR is "currency". For example, "Total (USD)". The default total column only shows in the account commodity (which may be a currency, or may be a stock or other fund). In this case, different commodities are not rolled up, because you cannot add Apples and Oranges together. The "Total (CUR)" means convert all values to the currency CUR and display that. I'll note, however, that the roll up should occur anyways, but it does require that you have an entry in the PriceDB back to your default currency. Do you have that entry? -derek > On Monday, April 1, 2019, 4:54:24 AM EDT, Derek Atkins > wrote: > > Hi, > > On Mon, April 1, 2019 4:47 am, Dennis Marshall wrote: >> I am having difficulties with some Parent directories not reflecting >> totals from sub-directories. For example, I have an investment account >> set >> up. Sub-directories accurately reflect data entries, but this does not >> show up in the parent directory totals. In addition, I have one account >> in >> a sub directory of 4 items that is not reflected in the total amount of >> the parent directory. What am I missing and how do I go about fixing >> this? >> Thanks. > > Where are you looking to see these totals? I presume in the Chart of > Accounts? You definitely will NOT see it in the parent account register. > > In the CoA, it will show up if you have a Total(CUR) column shown. > > Also, you need at least one entry in the PriceDB. > >> Please remember to CC this list on all your replies. >> You can do this by using Reply-To-List or Reply-All. > > -derek > -- > Derek Atkins 617-623-3745 > de...@ihtfp.com www.ihtfp.com > Computer and Internet Security Consultant > > > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. > -- Derek Atkins 617-623-3745 de...@ihtfp.com www.ihtfp.com Computer and Internet Security Consultant ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Parent Directories not Reflecting Sub-Directory Totals
Hi, On Mon, April 1, 2019 4:47 am, Dennis Marshall wrote: > I am having difficulties with some Parent directories not reflecting > totals from sub-directories. For example, I have an investment account set > up. Sub-directories accurately reflect data entries, but this does not > show up in the parent directory totals. In addition, I have one account in > a sub directory of 4 items that is not reflected in the total amount of > the parent directory. What am I missing and how do I go about fixing this? > Thanks. Where are you looking to see these totals? I presume in the Chart of Accounts? You definitely will NOT see it in the parent account register. In the CoA, it will show up if you have a Total(CUR) column shown. Also, you need at least one entry in the PriceDB. > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. -derek -- Derek Atkins 617-623-3745 de...@ihtfp.com www.ihtfp.com Computer and Internet Security Consultant ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Investment account import
Hi, Joseph Vernice writes: > Thank you, David. I do have many more securities as well. I was just > talking about a single account. I guess I'll just bite the bullet. > > Do you have the being rolled up into a parent account or are they each > a top level account? Generally it would be something like: Assets:Current Assets:: So each of the stock accounts would be a child of the brokerage. You should never have top-level accounts! :) > Thanks, > Joseph -derek > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. > -- Derek Atkins 617-623-3745 de...@ihtfp.com www.ihtfp.com Computer and Internet Security Consultant ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] The Meaning of Split (previously Example of multi-split feature of CSV importer?)
aeg via gnucash-user writes: [snip] > level, so I shall continue to use it for double entry bookkeeping > rather than double split bookkeeping. It is double-entry (even in basic mode) because you are entering both debits and credits. It is still double-entry even if you have 5 splits. This is another "term-of-art". > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. -derek -- Derek Atkins 617-623-3745 de...@ihtfp.com www.ihtfp.com Computer and Internet Security Consultant ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] The Meaning of Split (previously Example of multi-split feature of CSV importer?)
Hi Alan, On Fri, March 22, 2019 3:33 pm, aeg via gnucash-user wrote: > If I might comment on this topic, might thoughts are below Michael's... > [snip] > I agree with Michael's points.A simple transaction consists of just one > split but two parts, and saying (pretending) that a simple transaction has > two splits is misleading. You are confusing the VERB split -- the act of splitting two things into pieces -- and the NOUN split, which are the results of the splitting. While you are correct that a simple transaction has been split(v) only once, that does not imply that it is made of one one split(n). It is absolutely reasonable to use the same word to mean (slightly) different things as a verb and as a noun. It's also quite clear from context (at least most of the time) whether you are using split(v) or split(n). When you say "split the wood in two" you are using split(v), not split(n). Calling each piece of the result a split(n) is perfectly reasonable, which is what GnuCash does. Have you ever heard the term "wine split"? It refers to a 187ml bottle of wine, which is the result of splitting up a 750ml bottle into 4 parts, or a 350ml bottle into two. Are you going to argue that a wine split (which is yet another term-of-art) is wrong and go tilt at the wine industry windmill next? ;-) > I see no problems with the use of terms like 'simple transaction' (with > one split and two parts) or with 'compound transactions' (with 2+ splits > and 3+ parts), but it doesn't make sense to refer to the parts as splits. Why not? split(n) is a perfectly reasonable phrase. And again you are confusing split(v) with split(n), which is going to cause even more confusion. > Why not just use the term 'parts' or 'transaction parts' or even invent a > new word 'transparts'; (after all, GnuCash is a made up word too.) > Just because GnuCash developers previously defined the 'parts' of a > transaction as 'splits' doesn't mean that the definition shouldn't be > changed to make it clearer. The data file contains "Splits". Having different terms in the UI vs the underlying data is a way to cause irreperable brain damage down the road when someone not alive today becomes a developer in a couple decades and tries to mentally map a Foobob to a Split and doesn't understand why the name was changed. Not saying we CAN'T do it, but seriously, how many words in the English language have both a verb and a noun and can mean slightly different things? (cheating answer: many). Have a good weekend! > Kind regards,Alan > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. -derek -- Derek Atkins 617-623-3745 de...@ihtfp.com www.ihtfp.com Computer and Internet Security Consultant ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] import qif
Hi, "Joseph G. Keithley, III via gnucash-user" writes: > Hello, > > I've been slowly converting my Quicken 2016 to GnuCash. Two of my > Quicken accounts don't import. They both span multiple years. I > think I've found why they don't import (incorrect qif headers) . My > problem is, even if I break these accounts into many files of a > handful of transactions each, it still takes hours to import any of > these files because GnuCash spends so much time trying to match > transactions. Is there any way to import a QIF and disable GnuCash > transaction matching. It is much easier to hand edit these two > accounts, since I'll only have to do it once. Thanks in advance. Sorry, no, I know of no way to disable that step without changing the code to skip it (which, of course, you are welcome to do). Sorry, > iii > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. -derek -- Derek Atkins 617-623-3745 de...@ihtfp.com www.ihtfp.com Computer and Internet Security Consultant ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] The Meaning of Split (previously Example of multi-split feature of CSV importer?)
D writes:
> It seems circular to say that there is a distinction between a simple
> and compound transaction, and then say a simple transaction is a
> special case compound transaction. Then we're back at defining the
> difference between, say, a "split" transaction versus a "multi-split"
> transaction, which we're trying to move away from as justifiably
> confusing.
The difference is "exactly 2 splits" vs "more than 2 splits".
Simple tranaction: exactly 2 splits. The basic view mode in the
ledger lets you enter these simply, and the Transfer field shows the
"other" account.
Compound transaction: > 2 splits. The Transfer field shows "Split
Transaction" and you must expand the transaction to see the other
accounts.
Those ARE the definitions. If you don't like them, well, I'm sorry, but
it's like saying you don't like the sky being Blue and would prefer if
it was purple with pink polka dots.
The fact remains, a simple transaction *is* a special case of a compound
transaction as far as the UI is concerned. If you expand a simple
transaction you'll see both splits.
> Calling one a "simple" transaction, and the others "compound" seems
> like enough. Perhaps the explanation of the technical aspects of this
> (i.e., the structure of a two sided simple, as opposed to an n-sided
> {n>2} compound transaction), could use the term "split," as it is
> defined by Gnucash. This would disambiguate the use of the term
> "split," such that it would only be used for this specific case.
I am fine with that approach. In my mind it's always clear, tho, that
"split transaction" implies "compound transaction", and "transaction
splits" are the individual entries that tie the transaction to each
account. But whatever, I've only been using these terms within gnucash
for 20 years now. What do I know? :)
> Regardless, I am still against the "Ledger entry" locution.
Why?
-derek
--
Derek Atkins 617-623-3745
de...@ihtfp.com www.ihtfp.com
Computer and Internet Security Consultant
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.
Re: [GNC] End of year rollover
Adrien Monteleone writes: > For now, the likely best method is exporting and using a spreadsheet > for multi-period comparisons, though I seem to recall a proper > multi-period report is in development. I believe it has been committed to the repository already. If not, there is an open PR about it which implies it should be committed soon. > The multi-column report could fit that bill, but as-is, repeats all of > the account labels which makes things quite cluttered. There is also > no way to see percentages or variances unless you use a > spreadsheet. (or other reporting solution) I agree that some things are best done outside GnuCash, but GnuCash can certainly get you most of the way there. > I find myself looking at odd periods and crossing yearly boundaries > more often than I find myself comparing two monthly or annual > periods. (though I need that too) If I had to close the books each > year, I’d lose that ability, or at least it would be very cumbersome. This would be much harder, I think, if you had separate data files. Especially because GnuCash doesn't like having multiple files open simultaneously. > Regards, > Adrien > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. -- Derek Atkins 617-623-3745 de...@ihtfp.com www.ihtfp.com Computer and Internet Security Consultant ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] End of year rollover
Christian Kluge writes: > Am 21.03.2019 um 21:00 schrieb Derek Atkins: >> >>> At least for me in Germany I can’t think of someone accounting for more >>> than one year and also only on certain circumstances accounting for >>> another period than 01.01. to 31.12. >> >> Here in the US, organizations are free to set up any financial year they >> wish. Many still choose a calendar year, but certainly may are on a >> skewed calendar. Many choose June 30 for the end of the year. I worked >> one place that was Jan 31. >> > > But still it’s just one year. I don't understand your point? These are two orthogonal issues. There is the issue of year start/end, and there is the issue of whether to hold multiple years in a single data file. You seemed to imply that a calendar year was sufficient, and I was pointing out that no, it is not. This is completely separable from the other question of whether to have separate files for each year. > The certain circumstances I mentioned are mainly income tax related: > > The financial for farmers ends at 30.06. and for forestry it can be 28.02. > > A merchant according to German commercial law can choose a financial > year than the calendar year with approval from the tax office. Same here in the US. > However if it’s just a small cash accounting business the financial year > is always the calendar year. "Never say never" :) > And all I’ve said about different financial years doesn’t apply for VAT > which is always reported for the calendar year, which complicates things > even further. FUN! > Kind regards > > Christian Kluge -derek -- Derek Atkins 617-623-3745 de...@ihtfp.com www.ihtfp.com Computer and Internet Security Consultant ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] End of year rollover
On Thu, March 21, 2019 3:51 pm, Christian Kluge wrote: [snip] > I don’t know how to say it, but I think GnuCash might be better off with > a balance carry over method into the next year. Patches always welcome! :) > At least for me in Germany I can’t think of someone accounting for more > than one year and also only on certain circumstances accounting for > another period than 01.01. to 31.12. Here in the US, organizations are free to set up any financial year they wish. Many still choose a calendar year, but certainly may are on a skewed calendar. Many choose June 30 for the end of the year. I worked one place that was Jan 31. > I don’t know whether it would be possible to have an option the gnucash > file for the previous year which would be used comparisson reports. You would have to have GnuCash keep track of multiple files. Search the code history for Gemini. There was, at one point, an attempt at doing this. But really, searching across multiple files is not as straightforward as you would think. > Is there a way to ex- and import the business related things? There is an importer; I do not believe there is an exporter. > If there were the scenario you’ve described would a bit cumbersome but > still doable. > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. -derek -- Derek Atkins 617-623-3745 de...@ihtfp.com www.ihtfp.com Computer and Internet Security Consultant ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] The Meaning of Split (previously Example of multi-split feature of CSV importer?)
"David T. via gnucash-user" writes: > I like the terminology “simple” versus “compound”, but I do not > understand what is meant by a “ two-line simple transaction as a > special case of a compound transaction.” This is what happens you expand a simple transaction (which has only 2 splits) by clicking on the "Show Splits" button, or change the View to Split-ledger or Transaction Journal mode. It will display as a compound transaction but have only two lines (plus the blank spilt line). > David > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. -derek -- Derek Atkins 617-623-3745 de...@ihtfp.com www.ihtfp.com Computer and Internet Security Consultant ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] End of year rollover
Hi, Philip Burg writes: > I would like to close my books at the end of my financial year but > have access to the previous years files, my thoughts were to archive > the file at the end of the year by backing up to a cd/dvd then start > afresh with the new financial year. would this be possible. I am using > windows 10 and Gnucash Version 3.4 Build I.D. 3.4+(2018-12-30) Archiving old books is always a good idea. Restarting at the begining of the year, however, is not necessarily is good idea. Specifically, there is a Close Books feature that zero's out your Income & Expense accounts into Equity, but it doesn't actually DELETE any data. Your other option is to Export the account tree which will create an empty file and then re-open it. The downside is that you will have to reset all your opening balances, and if you use any business features you will need to manually re-enter all that metadata too (customers, vendors, tax tables, etc). I highly ANTI-recommend this approach. Personally, I don't do anything. All the reports handle year-end accounting without doing anything special. I don't mind seeing my income and expense account balances showing lifetime achievements :) But that's just me. Hope this helps, > Regards > > Philip Burg > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. -derek -- Derek Atkins 617-623-3745 de...@ihtfp.com www.ihtfp.com Computer and Internet Security Consultant ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Unable to add prices to some securities
Alan, Alan Taylor writes: > Ah ok … well thank you for your work on a great program. > > Without wanting to start any flame wars, can I ask for your opinion ? > I have been using GnuCash for a long time, 10 years+ and it is an > important program for me. > I could run it on Linux, MacOS or Windows - given the choice of all > three which would you recommend as the best host, purely for GnuCash ? In my opinion (humble or otherwise), I feel that Linux is #1, then MacOS, and then Windows. Windows is by far a second-class citizen; none of the developers actually do main development on Windows, whereas John DOES do main development on Mac. Most devs still use Linux. Of course, just my $0.02, so YMMV. > Brgds/Alan > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. -derek -- Derek Atkins 617-623-3745 de...@ihtfp.com www.ihtfp.com Computer and Internet Security Consultant ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Example of multi-split feature of CSV importer?
Michael Hendry writes: [snip] > Which supports my contention that the use of the term “split” for a > Ledger Entry causes confusion. > > Would anyone think it odd that a different process would be required > when importing a compound transaction than when importing a simple > one? Importing or inputting? Right now it's the same interface, in general. The only difference is whether or not you expand the view to show all the splits. You CAN enter basic (two-split) transactions in the expanded view. Or you can enter them in the basic (one-line) view. Either way works, and for many users the basic view is easier to understand. However, if entering a three-or-more-split (what we call "multi-split", often shortened to "split") transaction, one MUST used the expanded view. > Regards, > > Michael > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. -derek -- Derek Atkins 617-623-3745 de...@ihtfp.com www.ihtfp.com Computer and Internet Security Consultant ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Order of transactions
Adrien Monteleone writes: > I understood that already, but thanks for the detail. > > What doesn’t work is sorting off the part, because the sorting > stops at “.”, correct? Correct. > That’s why you can’t use “:” in the faux timestamp as the sorting will > stop before it gets to the minutes portion, and why you have to use a > 24 hour notation because “a/am” or “p/pm” will be ignored. Indeed. You would need to explitly use an HHMM number in 24-hour format without punctuation. > Regards, > Adrien > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. -derek -- Derek Atkins 617-623-3745 de...@ihtfp.com www.ihtfp.com Computer and Internet Security Consultant ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Unwanted Rate Column on Credit Card Register ???
It's always there on every register. Normally it is only 1 pixel wide. So grab the right side of the header of the column and drag it to the left to reduce it back to 1 pixel wide. The description column will auto increase to fill the space. Double click on the balance header to get it to optimum size. Enjoy. -derek Sent using my mobile device. Please excuse any typos. On March 15, 2019 6:24:40 PM Dave H wrote: For some reason I have a Rate column on the very right of just one of my credit card register windows. Can't figure out why it's there, how it got there, how to get rid of it. It always seems to just contain the value 1. which I don't find very informative :-) Any ideas on how to get rid of it, I've tried minimising it to nothing but it comes back when I reset one on the other columns widths. Thanks, DaveH ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Expense accounts in bills
w up? >> >>> >> >>> Thanks. >> >>> >> >>> David >> >>> -- >> >>> David Whiting >> >> >> >> >> >> ___ >> >> gnucash-user mailing list >> >> gnucash-user@gnucash.org >> >> To update your subscription preferences or to unsubscribe: >> >> https://lists.gnucash.org/mailman/listinfo/gnucash-user >> >> If you are using Nabble or Gmane, please see >> https://wiki.gnucash.org/wiki/Mailing_Lists for more information. >> >> - >> >> Please remember to CC this list on all your replies. >> >> You can do this by using Reply-To-List or Reply-All. >> > >> > >> > >> > -- >> > David Whiting >> > >> >> >> ___ >> gnucash-user mailing list >> gnucash-user@gnucash.org >> To update your subscription preferences or to unsubscribe: >> https://lists.gnucash.org/mailman/listinfo/gnucash-user >> If you are using Nabble or Gmane, please see >> https://wiki.gnucash.org/wiki/Mailing_Lists for more information. >> - >> Please remember to CC this list on all your replies. >> You can do this by using Reply-To-List or Reply-All. > > > > -- > David Whiting > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. > -- Derek Atkins 617-623-3745 de...@ihtfp.com www.ihtfp.com Computer and Internet Security Consultant ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] HELP! No lock!?
I would think just clicking "Open Anyway" would be easier. But glad you got it working :) -derek On Wed, March 13, 2019 2:28 pm, Jack Slater wrote: > Hi Derek - I used Tom's answer: > Simple fix. Close GNUCash. Use File Explorer to navigate to your GC data > folder. Near the bottom you'll see a file with type LCK. Delete it. Open > GC and enjoy. > > On Wed, Mar 13, 2019 at 1:22 PM Derek Atkins wrote: > >> Hi Jack, >> >> >> On Wed, March 13, 2019 2:09 pm, Jack Slater wrote: >> > Just tried to start up GC. Fresh boot of Win 10 PC and I get a message >> > window: >> > >> > "GnuCash could not obtain the lock for C:\" ( etc. file location) >> > >> > option to open read only (wont work for me!),create new file, open >> anyway, >> > quit >> >> First thing to try: Do you have another copy of GnuCash open? >> If NOT... What happens of you try "Open Anyway"? >> >> Here's what's going on. When GnuCash is open, it creates the lock file >> to >> ensure a second copy doesn't grab the file and possibly cause you to >> lose >> data. If you shut down the computer while GnuCash was still running >> then >> GnuCash didn't exit cleanly and, as a result, didn't delete the lock >> file. >> >> The "Open Anyway" option is basically your way to tell GnuCash that this >> is what happened. >> >> So, does that work? >> >> > I need to get that file open it has all my data! >> > >> > I do have a back up. >> >> > Please remember to CC this list on all your replies. >> > You can do this by using Reply-To-List or Reply-All. >> >> -derek >> >> -- >>Derek Atkins 617-623-3745 >>de...@ihtfp.com www.ihtfp.com >>Computer and Internet Security Consultant >> >> > -- Derek Atkins 617-623-3745 de...@ihtfp.com www.ihtfp.com Computer and Internet Security Consultant ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] How to customize the columns shown in the "generic import transaction matcher" (when downloading transactions from my bank) ?
On Wed, March 13, 2019 2:23 pm, a b wrote:
> What a shame! :((
Patches always welcome!
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
-derek
--
Derek Atkins 617-623-3745
de...@ihtfp.com www.ihtfp.com
Computer and Internet Security Consultant
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.
Re: [GNC] HELP! No lock!?
Hi Jack, On Wed, March 13, 2019 2:09 pm, Jack Slater wrote: > Just tried to start up GC. Fresh boot of Win 10 PC and I get a message > window: > > "GnuCash could not obtain the lock for C:\" ( etc. file location) > > option to open read only (wont work for me!),create new file, open anyway, > quit First thing to try: Do you have another copy of GnuCash open? If NOT... What happens of you try "Open Anyway"? Here's what's going on. When GnuCash is open, it creates the lock file to ensure a second copy doesn't grab the file and possibly cause you to lose data. If you shut down the computer while GnuCash was still running then GnuCash didn't exit cleanly and, as a result, didn't delete the lock file. The "Open Anyway" option is basically your way to tell GnuCash that this is what happened. So, does that work? > I need to get that file open it has all my data! > > I do have a back up. > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. -derek -- Derek Atkins 617-623-3745 de...@ihtfp.com www.ihtfp.com Computer and Internet Security Consultant ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Using a mysql database?
Joseph, On Wed, March 13, 2019 8:53 am, Joseph Vernice wrote: > There are no logon credentials for an XML database, Sure there are -- your user account login credentials! Unless, of course, you don't HAVE user login credentials, at which point I would say "there's your problem"! > making it easy for someone to access your data. They would need to break into your computer, first, to access your data! MySQL has a network flair to it, which means that there are probably MORE people who can access that than your laptop/desktop with correct user account settings. >I use a mysql database that requires > credentials to log on. Also, I change the port from the default 3306 to > something else. The port is blocked by my firewall. I can do this only > because the DB server is on my LAN. Note that AFAIK, mysql connections are not encrypted, so someone listening on your network could see your data. Your password is probably secure because I do believe that it uses a hashed value over the wire. But if you're doing it for security only, you're kind of missing the point. :( > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. -derek -- Derek Atkins 617-623-3745 de...@ihtfp.com www.ihtfp.com Computer and Internet Security Consultant ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Finance Quote on Debian
"Patrick Kelly" writes: > How do get finance Quote to work on a Debian 9 system. Everything appears > to be installed, when I click get quotes, the cursor changes to a circle and > never finishes. As if it went off into space and never returns. I have to > force quit GnuCash to get out of it. How many quotes are you trying to download? Alphavantage only lets you get 5 quotes per minute. > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. -derek -- Derek Atkins 617-623-3745 de...@ihtfp.com www.ihtfp.com Computer and Internet Security Consultant ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Order of transactions
Adrien, On Fri, March 8, 2019 2:41 pm, Adrien Monteleone wrote: > I didn’t mean to still be able to sort by the real transaction number, but > if you have one, and you’ve repurposed the NUM field, you’ll likely want a > place to put it just for reference. I simply offered an overview of the > remaining options. Overloading NUM as a time field is pretty much giving > up on using it to hold a real transaction number. (though one user piped > in they used a . format that seems to work, though I don’t see how > with the intervening “.”) As I said, the string field is converted to an integer using the C-language atoi() function and then the sort happens using the numerical value. So the string . with be converted into the number and that will be used to sort. If is 0001, this would be sorted before a of 2. Basically, the conversion for sorting will stop at the first non-numeral character. That's why using . works. Or -. Even A will work (this is all assuming the and are all numerals). So 00011.16298462 will come before 2.294362. If it were a pure string compare, then this would not be the case. > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. -derek -- Derek Atkins 617-623-3745 de...@ihtfp.com www.ihtfp.com Computer and Internet Security Consultant ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Order of transactions
Adrien Monteleone writes: > Yes, that is why I was explaining the abuse of the NUM field as a time > field for sorting and how to do it in a way that works. If you are > doing this, (or instead using 1,2,3,4 ) *and* you want to keep track > of a transaction number, then you’ll have to put it somewhere else so > you can still sort that transaction in the order you want. One obvious > choice for an alternative would be the Action field for that > particular split line. Another would be the Note field. (especially if > the Action field is also otherwise utilized) Another option would be > the Memo field for the split. Yes, if you want to order your transactions in a specific order but then also be able to sort by a transaction number then yes, you would need to do what you suggest and put the default-sort-order into Num, and the transaction number into another field. But why would you want to do that? You could still SEARCH for transaction number even if you overload num with .. But yes, you couldn't sort on the portion -- I just don't see the use case for that. *shrugs* > Regards, > Adrien > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. -derek -- Derek Atkins 617-623-3745 de...@ihtfp.com www.ihtfp.com Computer and Internet Security Consultant ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Default invoice/statement
Hi, writes: > Thanks Derek, > > Good to know the feature has been added to Version 3.x. I take it by current > you mean stable? Still a little reluctant to upgrade as version 2.6.17 is > working for us. If it ain't broke... Version 2.6.17 was released Q3 2017. It is now Q1 (almost Q2) 2019, so it's almost two years old. And yes, 3.4 is the current stable release. > Roger -derek -- Derek Atkins 617-623-3745 de...@ihtfp.com www.ihtfp.com Computer and Internet Security Consultant ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Setting up chart of accounts
Hi, On Thu, March 7, 2019 12:56 pm, Teresa wrote: > I have 25 years experience in Accounting, however never set up a chart > of accounts. > > I just started working for my daughter, who has done everything in excel. > > I have put all the gl accounts in GnuCash, but they all went in as > parent accounts, I new term to me. Have you tried using the default hierarchies that come with GnuCash? That should get up set up quickly, and then you can add or remove accounts as needed to customize to your situation. > My question is, shouldn't these be child accounts? Also, do I set up a > single of each Equity, Liability and Asset accounts as parent accounts > with the beginning balances, and transfer to the child accounts from > there? Well, consider a simple account hierarchy, Expenses:Groceries. In this example, Expenses is a top-level account, and also a parent account. most likely it is also a placeholder account (meaning it cannot hold transactions itself). The Groceries account is a child of Expenses. As you probably know, you generally don't set opening balances on Income and Expense accounts. In GnuCash, SOP is to transfer from Equity:Opening Balances -> to set up the opening balance. So no, you don't generally go from Eq:O-B -> Assets -> Assets:Current Assets -> ... etc, but directly from Eq:O-B to the target. Hope this helps, > Thank you, > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. -derek -- Derek Atkins 617-623-3745 de...@ihtfp.com www.ihtfp.com Computer and Internet Security Consultant ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Default invoice/statement
Hi, Roger Oliver writes: > Is there a way to move the Fancy invoice/statement layout up to replace the > default? Edit -> Preferences -> Business Report for Printing: ... > The default layout does not allow putting a logo on the masthead. I'm using > the last update of version 2 of GnuCash. It's stable and working for us so > haven't seen the need to update. 3.x is current. I'm running 3.4 and verified the preference is there. I don't recall when it was added. > Thanks much, > Roger Oliver > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. -derek -- Derek Atkins 617-623-3745 de...@ihtfp.com www.ihtfp.com Computer and Internet Security Consultant ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Order of transactions
Adrien Monteleone writes: > Lisa, > > I will add to David’s advice that you can use the NUM field other than > a simple 1,2,3,4... > > You might, for example, need or want to keep an actual transaction > number with the transaction. > > For that case, you can put the real transaction number in the Action > or Memo field of the split. There really is no need to do this. The Number field is a string-entry, it will let you input anything you want. The SORTING mechanism from the Num field is a NUMERIC sort; it effectively performs the C-function call atoi() on the contents. This means you could do something like: 1.16274 2.0023 3.172323 And it will sort based on the 1, 2, 3. > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. -derek -- Derek Atkins 617-623-3745 de...@ihtfp.com www.ihtfp.com Computer and Internet Security Consultant ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Optimising migration via qif
Hi, Jonathan Williams writes: > I am trying to migrate from MS Money to GNC using qif files for each account, > and am meeting problems with the importer. It asks me to check many > hundreds of transactions, and if I skip this it results in hundreds of > missing transactions (not duplicates, which would be easier to resolve). > I'm thinking of starting afresh, and some advice would be much appreciated. > I have explored the FAQ and forum but can't find answers I need. > Specifically: > 1) Is it better to set up the CoA before I start, or import first and then > edit accounts later? I assumed the former, but not 100% sure. In my opinion, it is better to set up the CoA and then you can map the QIF Accounts to GnuCash Asset/Liabilities and then QIF Categories and Memo/Payees to GnuCash Income/Expense accounts. If you import and then switch stuff around, the importer will not know about the moves and future mappings will be incorrect. > 2) Is it better to import one account at a time, or all together with > multiple qif files? I have seen both suggested... IMHO, it depends. Sometimes it is better to do it all at once; sometimes it is better to do it piecemeal. I think the best thing is to try it and see. You can always quit without saving to "start over". > 3) Would it help to import, say, one year of data to train the druid and > then the rest? It depends on how consistent your data is. The payee/memo matcher in the QIF importer always works on full strings, so if you have entries like "QuickTrip 1234567" and then "QuickTrip 2345678", the importer will not be able to match them the same. > Thanks in advance for your help. Hope this helps, > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. -derek -- Derek Atkins 617-623-3745 de...@ihtfp.com www.ihtfp.com Computer and Internet Security Consultant ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Fwd: Bonus share entry
The cost may be zero, but the value is not. Maybe just enter them as 0.01? -derek Sent using my mobile device. Please excuse any typos. On March 6, 2019 6:07:28 AM Gnucash Xboxboy Mageia wrote: Hi all, I have some bonus shares that were issued with no cost to me: I am having trouble entering them without a cost. When I put 0 as the cost, on the next line 1 appears, and I am unable to get rid of it. Perhaps I'm doing this the wrong way, and need to be entering them as a share split? In this case, I had 100 shares, and got issued 16 for no cost: so I have 116 in total. Any ideas? Thanks, Xboxboy ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] IRC access
/msg nickserv help register On Tue, March 5, 2019 2:50 pm, David Carlson wrote: > I use Pidgin and I cannot figure out how to register with the nickserv. I > enter > > /server irc.gnome.org > > and nothing happens > > > On Tue, Mar 5, 2019 at 1:40 PM Derek Atkins wrote: > >> Hi, >> >> On Tue, March 5, 2019 2:31 pm, David Carlson wrote: >> > It seems that the IRC channel has changed and now I need a voice. How >> do >> > I >> > do that? >> >> If you read the topic when you join the channel, it specifically says: >> >> * Topic for #gnucash is: Free GPL Personal and Small Business Accounting >> || Moderated mode: To get a voice, register with NickServ and then >> re-join. || Please don't ask to ask, just ask and wait! (Possibly a few >> hours!!) || publicly-logged channel || latest stable: 3.4 || >> www.gnucash.org || wiki.gnucash.org/wiki/ >> >> > Please remember to CC this list on all your replies. >> > You can do this by using Reply-To-List or Reply-All. >> >> -derek >> -- >>Derek Atkins 617-623-3745 >>de...@ihtfp.com www.ihtfp.com >>Computer and Internet Security Consultant >> >> > > -- > David Carlson > -- Derek Atkins 617-623-3745 de...@ihtfp.com www.ihtfp.com Computer and Internet Security Consultant ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] IRC access
Hi, On Tue, March 5, 2019 2:31 pm, David Carlson wrote: > It seems that the IRC channel has changed and now I need a voice. How do > I > do that? If you read the topic when you join the channel, it specifically says: * Topic for #gnucash is: Free GPL Personal and Small Business Accounting || Moderated mode: To get a voice, register with NickServ and then re-join. || Please don't ask to ask, just ask and wait! (Possibly a few hours!!) || publicly-logged channel || latest stable: 3.4 || www.gnucash.org || wiki.gnucash.org/wiki/ > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. -derek -- Derek Atkins 617-623-3745 de...@ihtfp.com www.ihtfp.com Computer and Internet Security Consultant ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] apply coefficient to an account
I would recommend you run the existing P&L report, then take the output, copy it into a spreadsheet, and then add your coefficients there. -derek On Tue, March 5, 2019 10:21 am, Peter Münster wrote: > On Tue, Mar 05 2019, John Ralls wrote: > >> Apply the coefficients how and with what intended result? > > It's just a multiplication. If there is for example 1000€ in an account > and 0.7 must be applied, then there must be 700€ instead of 1000€ in > the report. Our kayak club has a contract with a public organisation, > and we must deliver a report, that shows only a part of the whole > accounting of the club, only the part that concerns the contract. So for > example 75% of the salary, because the employee spends 25% of his time > with tasks, that are not connected to the contract. > > >> Failing there being a report that gets you close enough to what you need >> you >> can customize the P&L report: >> https://wiki.gnucash.org/wiki/Custom_Reports > > Ok. So I need to learn Scheme, Guile and so on? Or can I hire somebody > here on the list, who could do that for me? That would be nice. > > Kind regards, > -- >Peter > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. > -- Derek Atkins 617-623-3745 de...@ihtfp.com www.ihtfp.com Computer and Internet Security Consultant ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] QIF import - Loss of sign
Hi, On Fri, February 22, 2019 8:03 pm, Rustyc wrote: > > Tried posting this yesterday before I was fully "registered" - Hope it > doesn't appear twice. It will, once Liz clears the moderation queue.. Unless Liz recognizes the duplication. :) I wouldn't worry about it. [snip] > In case this is not clear I’ll give actual numbers. The QIF files has > entries such as: > D26/06/18 > T-38.50 > PPAY ANYONE ANZxxxL EGGS 0139314487BILL > ^ > D01/07/18 > T7.31 > PINTEREST > ^ > This shows a deposit (interest) and a withdrawal from the bank account. > When > imported into GnuCash I end up with 4 lines in the “Account” page. Each > transaction is listed twice – once with the amount under Increase and once > with it under Decrease. And all have Account = “Bank account xxx” (under > “transfer”). > > Is this because I specified “Bank Account xxx” somewhere during the import > process? (I was not sure what GC was asking at each stage!). Yes. It means you specified the same GnuCash account as the source and destination of the transaction. I.e., you said "I took $100 from BANK and sent it to BANK". This is probably not what you intended. > Can someone maybe explain in simple terms how to import bank data and use > it > to populate all transactions (rather than entering transactions and then > assigning each transaction to an existing entry)? Yes. Let's say you have a QIF file called 'bank.qif'. GnuCash will assume this is for the QIF Account named 'bank'. All transactions in this file will be associated with 'bank', and then you need to map each transaction to the correct destination account. The Importer will first ask you to map the QIF Account "bank" to some GnuCash (asset) account. So for example, Assets:SunTrust:Checking. There may be other QIF accounts in the file, and those too should map to GnuCash Asset and Liability accounts. Then it will ask you to match the Categories, which you should map to GnuCash Income/Expense accounts. Finally, it will ask you to match the Payee/Memo lines (which is what you have here). These you will also need to map correctly to the Income/Expense accounts. So for example, you should map "INTEREST" to, e.g. Income:Interest and "PAY ANYONE ANZxxxL EGGS 0139314487BILL" to, e.g., Expenses:Groceries. Your mistake is that you mapped each of these payees/memos to the same (bank) account that you mapped bank to. > Also, the manual states that “Debit and Credit” terms can be replaced with > “Deposit and Withdrawal” for newbies. However, Account view shows columns > labelled “Increase and Decrease”. Confusing! The headings are based on the exact account type. If you use a Bank, it will be Deposit and Withdrawal. If it's a credit card, Charge and Payment. Increase and Decrease are for generic Asset accounts. Edit the account in question and check on the account type. > Any help appreciated! Hope this helped, > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. -derek -- Derek Atkins 617-623-3745 de...@ihtfp.com www.ihtfp.com Computer and Internet Security Consultant ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Memorized Transaction List
David Carlson writes: > IIRC, the qif importer is (or was, in the 2.6.x series) somewhat clunky > when it came upon an unknown 'other' account or category. It may have > needed a nudge to place it correctly into the account tree. I don't think > it dumped everything into some imbalance file without giving the user a > chance make a better choice. Fo me, I last used that feature about a > decade ago, so I could be wrong. The QIF import did lazy account creation -- it would only touch your actual account tree at the end, after you click "Finish". The Generic Importer, however, will make account modifications enroute, including creating new accounts. For QIF, new accounts wont get properly mapped into the tree, so you either need to pre-create the gnucash account and map it in the importer, or you need to modify the QIF to read, e.g.: LExpenses:Groceries instead of: LGroceries to properly place it in the tree. > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. -derek -- Derek Atkins 617-623-3745 de...@ihtfp.com www.ihtfp.com Computer and Internet Security Consultant ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Struggling with Quicken import
Hi, dmacklewis writes: > Derek Atkins-3 wrote >> Please remember to CC this list on all your replies. >> You can do this by using Reply-To-List or Reply-All. > > Pardon me for being thick headed, but I can find no place where there is an > option to Reply-To-List or Reply-All. How to do that? > > Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html As you use Nabble, you have a different interface. I honestly don't know what Nabble does, but I SUSPECT the default is "reply-to-list." But I honestly don't know for sure; Nabble is a 3rd party service. -derek -- Derek Atkins 617-623-3745 de...@ihtfp.com www.ihtfp.com Computer and Internet Security Consultant ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Struggling with Quicken import
D via gnucash-user writes: > That is a fair interpretation, since that's what the wiki > says. However, it would appear that the wiki is in need of some > correction. > > I'm not sure, but that wiki language may have resulted from a writer's > misunderstanding of the different import vectors, with one writer > assuming that account structures would be manually entered, while > another assumed that it could happen via an import. > > It may also be that the importer logic changed, but that is less likely. When you import from QIF there are two ways to look at it: 1) You could create an account structure first (e.g. by the File Hierarchy assistant) and then map your QIF accounts to the gnucash structure, or 2) You can let the QIF importer create the new accounts for you. The only problem with #2 is that it will put most of your categories into top-level Expense accounts. So instead of having Expenses:Groceries, your "Groceries" category will get created as a top-level "Groceries" expense account. It was probably unclear in the wiki that option #1 means creating the accounts in gnucash first and then mapping them during the qif import. If you do #2 and then restructure, the QIF import mappings will be wrong if you do a subsequent import. > David T. > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. -derek -- Derek Atkins 617-623-3745 de...@ihtfp.com www.ihtfp.com Computer and Internet Security Consultant ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Struggling with Quicken import
dmacklewis writes: > I have given up trying to create an account structure and then populating it. > Instead I exported one account with transactions of a limited date range and > imported it into GnuCash. I got further this time. The import created the > accounts from the Quicken account/categories, showed the matches for editing > and things were looking pretty good, but the actual import failed and told > me there was a problem with the import. No indication of what the problem > was. I looked at the only log I could find but it was not helpful, at least > there were no error indicators. I don't know how to troubleshoot this. Did you look at the Trace File? https://wiki.gnucash.org/wiki/Tracefile There should have been some error printed. > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. -derek -- Derek Atkins 617-623-3745 de...@ihtfp.com www.ihtfp.com Computer and Internet Security Consultant ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Struggling with Quicken import
You can't. Qif only imports transactions. If you have no transactions then the importer will do nothing. -derek Sent using my mobile device. Please excuse any typos. On February 12, 2019 1:37:28 PM David Carlson wrote: I am not by my Gnucash right now but if I recall, there is a slightly different work path to import accounts without transactions. David Carlson On Tue, Feb 12, 2019, 12:22 PM dmacklewis I installed Gnucash 3.4.1 on MacOS High Sierra 10.13.6 and created a file with one account. I then exported a Quicken Deluxe 2019 QIF file containing just the accounts. The import seems to run but when the page to 'Match QIF accounts with GnuCash accounts' is displayed, it it empty. None of the QIF or GnuCash accounts are listed. The import finishes with no accounts loaded. I tried the same import with GnuCash 2.6.21-3 and got the same results. What am I doing wrong? -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Can't delete security
Hi, Did you uncompress the XML file before trying to open it? -derek On Tue, February 12, 2019 12:27 pm, rsbrux wrote: > @Derek, > Many thanks for your advice. Believe me, I've tried. Unfortunately, it > is a mystery to me why any account should still be using this security. > As mentioned below, I have deleted both the initial transaction and the > investment account I created for the security. I don't know why any > other account should reference it. > > @anyone, > How can I find out which account GnuCash thinks is using this security? > It occurred to me that I might be able to find out by doing a text > search of the GnuCash file, as I have understood that it is XML. > However, I cannot open it in mousepad, as it complains that the encoding > is not UTF-8. > Any hints as to how to proceed would be most welcome. > > -Original Message- > From: Derek Atkins > Sent: Tuesday, February 12, 2019 4:46 PM > To: rsbrux via gnucash-user > Cc: rsbrux > Subject: Re: [GNC] Can't delete security > > Hi, > > rsbrux via gnucash-user writes: > >> Because of the well-known difficulties associated with assigning the >> correct currency to a security, I need to delete and recreate a >> security. I have deleted the initial transaction I created for this >> security, as well as the investment account I created for the >> transaction. Nonetheless, when I try to "Remove" the security from >> the "Security Editor", I get the message: >> >> "That commodity is currently used by at least one of your accounts. >> You may not delete it." >> >> I am using GnuCash 2.6.19 running under Ubuntu Studio 18.04 >> >> How can I correct this? > > Do what it's telling you. Delete the account that is using the commodity. > > GnuCash wont let you delete something that is referenced by another > object. > >> Please remember to CC this list on all your replies. >> You can do this by using Reply-To-List or Reply-All. > > -derek > > -- > Derek Atkins 617-623-3745 > de...@ihtfp.com www.ihtfp.com > Computer and Internet Security Consultant > -- Derek Atkins 617-623-3745 de...@ihtfp.com www.ihtfp.com Computer and Internet Security Consultant ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Importing Quicekn Files
Sorry, yeah QXF != QFX. QFX/OFX is readable. QXF is not. -derek On Tue, February 12, 2019 11:04 am, Dan Black wrote: > QFX is a download format, designed for import of transactions from your > bank into a single Quicken account. ... QXF is an encrypted file transfer > format designed to move entire Quicken databases with multiple accounts > from Windows to Mac or visa versa. > > On February 12, 2019 10:46:36 AM Derek Atkins wrote: > >> David Carlson writes: >> >>> I just peeked at Quicken 2019 and they also have a QXF file format >>> which >>> does not work for GnuCash either. I did not have time to figure out >>> what >>> they do use that format for. For us it is another tree in the forest. >> >> Are you sure? QXF should be readable by the OFX importer. >> >>> David Carlson >> >>> Please remember to CC this list on all your replies. >>> You can do this by using Reply-To-List or Reply-All. >> >> -derek >> >> -- >> Derek Atkins 617-623-3745 >> de...@ihtfp.com www.ihtfp.com >> Computer and Internet Security Consultant >> ___ >> gnucash-user mailing list >> gnucash-user@gnucash.org >> To update your subscription preferences or to unsubscribe: >> https://lists.gnucash.org/mailman/listinfo/gnucash-user >> If you are using Nabble or Gmane, please see >> https://wiki.gnucash.org/wiki/Mailing_Lists for more information. >> - >> Please remember to CC this list on all your replies. >> You can do this by using Reply-To-List or Reply-All. > > > > -- Derek Atkins 617-623-3745 de...@ihtfp.com www.ihtfp.com Computer and Internet Security Consultant ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Can't delete security
Hi, rsbrux via gnucash-user writes: > Because of the well-known difficulties associated with assigning the > correct currency to a security, I need to delete and recreate a > security. I have deleted the initial transaction I created for this > security, as well as the investment account I created for the > transaction. Nonetheless, when I try to "Remove" the security from > the "Security Editor", I get the message: > > "That commodity is currently used by at least one of your > accounts. You may not delete it." > > I am using GnuCash 2.6.19 running under Ubuntu Studio 18.04 > > How can I correct this? Do what it's telling you. Delete the account that is using the commodity. GnuCash wont let you delete something that is referenced by another object. > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. -derek -- Derek Atkins 617-623-3745 de...@ihtfp.com www.ihtfp.com Computer and Internet Security Consultant ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Importing Quicekn Files
David Carlson writes: > I just peeked at Quicken 2019 and they also have a QXF file format which > does not work for GnuCash either. I did not have time to figure out what > they do use that format for. For us it is another tree in the forest. Are you sure? QXF should be readable by the OFX importer. > David Carlson > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. -derek -- Derek Atkins 617-623-3745 de...@ihtfp.com www.ihtfp.com Computer and Internet Security Consultant ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] accrual of property tax payments
Keith Bellairs writes: > My property tax is payable in 4 installments -- August, November, February, > and May. I have tried to set this up with my town as the vendor and 4 > payments. > > When I ran my income statement for last year, I see that the future > liabilities have been posted with the date that the bill was posted, not > the date that the bill is due. So all of my 2019 payments show as tax > expense in 2018. > > Is there a way to have the vendor bills show up dated with the due date > instead of the date posted? See: https://bugs.gnucash.org/show_bug.cgi?id=95700 This is talking about customer invoices, but vendor bills use the same logic. Note the date of the bug report. > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. -derek -- Derek Atkins 617-623-3745 de...@ihtfp.com www.ihtfp.com Computer and Internet Security Consultant ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] SMTP TLS -- Re: Liabilities and Net Worth in Android app
humming.b...@posteo.net writes: > Dear Derek, > > if this email reaches the list, then TLS is working. Considering you sent it to me *and* the list, I have no way to confirm. My tests seem to imply it is working. ;) > Cheers > Chris -derek -- Derek Atkins 617-623-3745 de...@ihtfp.com www.ihtfp.com Computer and Internet Security Consultant ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Gnucash leadership team
"David T. via gnucash-user" writes: > Honestly, the decision is yours. > > I’ve been using GnuCash now for over 13 years. Back then, Derek Atkins > was one of the primary developers, having taken over for another crew > that had carried GnuCash from its early years as xaccountant. He > stepped back, and several others stepped in. So, it’s been through > that process a couple of times anyway already. And I'm still here. Just not as active as before (as you can tell from my 10-day delay in responding ;) > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. -derek -- Derek Atkins 617-623-3745 de...@ihtfp.com www.ihtfp.com Computer and Internet Security Consultant ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] I just need a line feed
Hi, On Thu, February 7, 2019 3:51 pm, Stephen M. Butler wrote: > > I'm slowly learning Scheme. I general a is a decimal 10 or 0x0A in > the ASCII collating sequence. In the Nix world you can use an \n to > represent it. This wont help because it's being parsed by an HTML parser. > Try changing: "For Period Covering %s to %s" > > To: "\nFor Period Covering %s to %s" This will break the translation. You don't want to modify a (_ ...) string. > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. -derek -- Derek Atkins 617-623-3745 de...@ihtfp.com www.ihtfp.com Computer and Internet Security Consultant ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] I just need a line feed
Hi, On Thu, February 7, 2019 3:47 pm, Steve Cohen wrote: > I'm not a developer of gnucash so take this with a grain of salt, but > putting a '\n' where you want the line feed might work. If you're on > windows, you might need to do '\n\r'. Try it, maybe it's a help to you, > but no guarantees. Nope, that's very unlikely to do what you want, because it's processed by an HTML parser and \n means nothing to that. > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. -derek -- Derek Atkins 617-623-3745 de...@ihtfp.com www.ihtfp.com Computer and Internet Security Consultant ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] I just need a line feed
Hi, On Thu, February 7, 2019 3:34 pm, Richard Marmor wrote: [snip] >(gnc:html-document-set-title! > doc (sprintf #f > (string-append "%s %s " <-- add here > (_ "For Period Covering %s to %s")) > company-name report-title > (gnc-print-date start-date-printable) > (gnc-print-date end-date-tp))) >Can someone please tell me how to modify that to insert a line feed >so the report title will appear on two lines as: > [Company Name][Report Title] >For Period Covering [start date] to [end date] >I am not a programmer. I tried reading some of the help information >among the SCM files, but frankly it was all Greek to me. Help would >be appreciated. Have you tried adding at the end of the "%s %s" above? >Thank you! > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. -derek -- Derek Atkins 617-623-3745 de...@ihtfp.com www.ihtfp.com Computer and Internet Security Consultant ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] [MAINT] server upgrade complete
Hi, The server upgrade is complete, and it appears that all services are running normally. Please let me know if you notice any bugs! Thanks! -derek On Sat, February 2, 2019 4:13 pm, Derek Atkins wrote: > Hi, > > Just a reminder that this is planned for tomorrow. I'm still not 100% > sure of the exact timing, but I'll announce on IRC before I start and > will be available on IRC during the process. I'll send mail when the > upgrade is complete! > > -derek > > Derek Atkins writes: > >> Hi, >> >> PLANNED MAINTENANCE >> WHAT: Upgrading Operating System on Code >> WHEN: Feb 3, 2019 1200-2300 US/EST (1700-0400 UTC) >> >> >> tl;dr: I am planning to upgrade the OS on code.gnucash.org on February >> 3, 2019 from 1200-2300 US/EDT (1700-0400 UTC). During this >> time, git master, wiki, email/mailman, and gncbot/irc logs will >> all be unavailable. I'll be on #gnucash IRC for real-time >> updates and notices. >> >> >> Long version: >> >> The GnuCash "everything" server is getting a little long on the tooth, >> and to enable some upgraded build tools I plan to upgrade the server >> from Fedora 25 to Fedora 29. I plan to do this upgrade on Sunday, >> February 3, 2019, starting somewhere around 12:00 noon US/EST (although >> my personal schedule might push that back, hense the long maintenance >> window). I've upgraded a few systems from F25 -> F29 already, some of >> them upgraded in an hour, one system took over 4 hours. >> >> Code has lots of services so I expect it will take a long time to >> upgrade and verify that everything is working. >> >> During the upgrade window code will be unavailable, and the services >> running on code will be unavailable. I will stay on IRC during the >> upgrade to make real-time announcements. >> >> Please let me know if this time frame does not work for you. >> >> Thanks, >> >> -derek > > -- >Derek Atkins 617-623-3745 >de...@ihtfp.com www.ihtfp.com >Computer and Internet Security Consultant > ___ > gnucash-devel mailing list > gnucash-de...@gnucash.org > https://lists.gnucash.org/mailman/listinfo/gnucash-devel > -- Derek Atkins 617-623-3745 de...@ihtfp.com www.ihtfp.com Computer and Internet Security Consultant ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] [MAINT] server upgrade planned Feb 3, 2019 1200-2300 US/EST
Hi, Just a reminder that this is planned for tomorrow. I'm still not 100% sure of the exact timing, but I'll announce on IRC before I start and will be available on IRC during the process. I'll send mail when the upgrade is complete! -derek Derek Atkins writes: > Hi, > > PLANNED MAINTENANCE > WHAT: Upgrading Operating System on Code > WHEN: Feb 3, 2019 1200-2300 US/EST (1700-0400 UTC) > > > tl;dr: I am planning to upgrade the OS on code.gnucash.org on February > 3, 2019 from 1200-2300 US/EDT (1700-0400 UTC). During this > time, git master, wiki, email/mailman, and gncbot/irc logs will > all be unavailable. I'll be on #gnucash IRC for real-time > updates and notices. > > > Long version: > > The GnuCash "everything" server is getting a little long on the tooth, > and to enable some upgraded build tools I plan to upgrade the server > from Fedora 25 to Fedora 29. I plan to do this upgrade on Sunday, > February 3, 2019, starting somewhere around 12:00 noon US/EST (although > my personal schedule might push that back, hense the long maintenance > window). I've upgraded a few systems from F25 -> F29 already, some of > them upgraded in an hour, one system took over 4 hours. > > Code has lots of services so I expect it will take a long time to > upgrade and verify that everything is working. > > During the upgrade window code will be unavailable, and the services > running on code will be unavailable. I will stay on IRC during the > upgrade to make real-time announcements. > > Please let me know if this time frame does not work for you. > > Thanks, > > -derek -- Derek Atkins 617-623-3745 de...@ihtfp.com www.ihtfp.com Computer and Internet Security Consultant ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] SMTP TLS -- Re: Liabilities and Net Worth in Android app
Hi, On Fri, February 1, 2019 4:27 am, Chris wrote: > > PS: I was surprised that the mailing list server does not offer TLS. Of > course the list is open but it would be nice if in 2019 it would be > offered since people like me need to turn off "only send emails to TLS > enabled servers". Strangely, this was half-configured already, but the certificates weren't there. Not sure how that happened, but it's been fixed. Can you try again now and let me know? Thanks, > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. -derek -- Derek Atkins 617-623-3745 de...@ihtfp.com www.ihtfp.com Computer and Internet Security Consultant ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] How to remove unused accounts
Hi, On Fri, January 25, 2019 9:51 am, Lorrie Laskey wrote: > Hi all, > > I have a few old, unused accounts with dollars amounts that are not > accurate that are showing up when doing reports, skewing the data. > > How do I delete the accounts but not the transactions? When you delete an account, GnuCash will ask you what to do with all the transactions in the account. Your choices are basically: * move them into another account, or * move them into Orphan-XXX (where XXX is the currency) There is no way to "mass delete" a bunch of transactions. > Credit card payments were made from my checking account, so deleting the > transactions would remove them from the checking account. Let me ask you a different question here.. Credit card payments were made from your checking account to the CC account -- so if THOSE transactions were correct, then... where is the problem? Is the problem that you did not account for your actual CC charges? What balances are "off"? > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. -derek -- Derek Atkins 617-623-3745 de...@ihtfp.com www.ihtfp.com Computer and Internet Security Consultant ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Check for negative amount in scheduled transaction formula
Hi Ron, Ron Stone writes: > Thanks for this Derek. I'm on a Mac and only see one copy of fin.scm > in the application bundle. Seems any edits to this would be lost at > the next upgrade. Should I be defining another one somewhere under > ~/Library/Application Support/GnuCash or elsewhere? Yes, this file will be over-written at the next upgrade. Creating a new file would require you to get gnucash to load it.. IMHO, you should make the edits to fin.scm now, and then make a patch and submit to to Bugzilla for inclusion in future versions. > Ron -derek > - Original Message - > From: "Derek Atkins" > To: "gnucash dgr9z" > Cc: "Gnucash Users" > Sent: Monday, January 21, 2019 3:16:52 PM > Subject: Re: [GNC] Check for negative amount in scheduled transaction formula > > gnucash.dg...@ncf.ca writes: > >> Hi, >> >> Is it possible to convert negative numbers to 0 in a formula? something like: >> a-b < 0 ? 0 : a-b >> >> If this needs to be defined as a function someplace, what would it >> look like, where would it go, and how would it be called from the >> template? > > Look at fin.scm and copy the functions in there. > >> Many thanks, >> Ron > >> Please remember to CC this list on all your replies. >> You can do this by using Reply-To-List or Reply-All. > > -derek -- Derek Atkins 617-623-3745 de...@ihtfp.com www.ihtfp.com Computer and Internet Security Consultant ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Lost all my transactions on Gnu cash
YAY! Glad you got it working again!! -derek On Tue, January 22, 2019 4:38 pm, Georgina Hunter-Jones wrote: > Oh, I found it! I had given it a different name from the overall name, and > suddenly it popped up. Thank you so much for all your help and patience. I > now have the accounts back and I am going to copy them immediately. Thank > you. > > On Tue, Jan 22, 2019 at 9:35 PM Georgina Hunter-Jones < > helicopterl...@gmail.com> wrote: > >> No, it didn't. I haven't had that since the beginning. I can now get up >> Accounts: Account Summary but not an entries page. >> >> On Tue, Jan 22, 2019 at 9:32 PM Derek Atkins wrote: >> >>> Did it say Read-Only when you when through File->Open? >>> When does it say it is read-only? >>> >>> -derek >>> >>> On Tue, January 22, 2019 4:27 pm, Georgina Hunter-Jones wrote: >>> > Yes, thank you, that worked in that I now have a page with headings >>> and >>> my >>> > accounts in total numbers. For example, the first one is Assets, next >>> > Dehumidifier, then equity, expenses etc and all except Dehumidifier >>> have >>> > totals, but I still can not get into add new inputs. >>> > >>> > On Tue, Jan 22, 2019 at 9:16 PM Derek Atkins wrote: >>> > >>> >> If that's a blank page then that means you have no data open. Did >>> you >>> >> try >>> >> using File -> New File? That might have done it. >>> >> >>> >> Let's start over -- Go to File -> Open and then get to the folder >>> where >>> >> your data file is located and open it. What happens then? >>> >> >>> >> -derek >>> >> >>> >> On Tue, January 22, 2019 4:11 pm, Georgina Hunter-Jones wrote: >>> >> > I tried that but all i get is a blank page with headings. >>> >> > >>> >> > On Tue, 22 Jan 2019 at 21:08, Derek Atkins >>> wrote: >>> >> > >>> >> >> Was it just one account register that was readonly?? Or was it >>> when >>> >> you >>> >> >> opened the file? >>> >> >> >>> >> >> What do you mean by "get back to my accounts"? Are you missing >>> the >>> >> >> Chart >>> >> >> of Accounts Page? If so, use View -> New Accounts Page >>> >> >> >>> >> >> -derek >>> >> >> >>> >> >> On Tue, January 22, 2019 4:04 pm, Georgina Hunter-Jones wrote: >>> >> >> > Ah, it said it was read only a page or so ago. I keep fiddling >>> with >>> >> >> it, >>> >> >> > hoping to get back to my accounts, but I seem to be making it >>> >> worse. >>> >> >> If I >>> >> >> > can get the read only thing back I’ll take a screenshot. Sorry. >>> I’m >>> >> >> > getting >>> >> >> > a bit lost here. >>> >> >> > >>> >> >> > On Tue, 22 Jan 2019 at 21:00, Derek Atkins >>> wrote: >>> >> >> > >>> >> >> >> Hi, >>> >> >> >> >>> >> >> >> So if that didn't work -- how is it telling you that it is >>> >> read-only? >>> >> >> >> Could you supply a screen shot? >>> >> >> >> Maybe a step-by-step of what you do and what happens? >>> >> >> >> >>> >> >> >> I'm at a loss for what else would cause a read-only situation >>> here >>> >> >> >> except, >>> >> >> >> perhaps, you opening a placeholder account. >>> >> >> >> >>> >> >> >> Thanks, >>> >> >> >> >>> >> >> >> -derek >>> >> >> >> >>> >> >> >> On Tue, January 22, 2019 3:55 pm, Georgina Hunter-Jones wrote: >>> >> >> >> > Thanks, sadly it did not work. Sorry that replies are so >>> slow, >>> >> Im >>> >> >> not >>> >> >> >> > always with the old computer. Thanks >>> >> >> >> > >>> >> >> >> > On Tue, Jan 15, 2019 at 2:3
Re: [GNC] Lost all my transactions on Gnu cash
Hi, I'm sorry, I don't understand what you mean by your last sentence, "I can now get up Accounts: Account Summary but not an entries page."? Could you explain further? Maybe with a screen shot? Thanks, -derek On Tue, January 22, 2019 4:35 pm, Georgina Hunter-Jones wrote: > No, it didn't. I haven't had that since the beginning. I can now get up > Accounts: Account Summary but not an entries page. > > On Tue, Jan 22, 2019 at 9:32 PM Derek Atkins wrote: > >> Did it say Read-Only when you when through File->Open? >> When does it say it is read-only? >> >> -derek >> >> On Tue, January 22, 2019 4:27 pm, Georgina Hunter-Jones wrote: >> > Yes, thank you, that worked in that I now have a page with headings >> and >> my >> > accounts in total numbers. For example, the first one is Assets, next >> > Dehumidifier, then equity, expenses etc and all except Dehumidifier >> have >> > totals, but I still can not get into add new inputs. >> > >> > On Tue, Jan 22, 2019 at 9:16 PM Derek Atkins wrote: >> > >> >> If that's a blank page then that means you have no data open. Did >> you >> >> try >> >> using File -> New File? That might have done it. >> >> >> >> Let's start over -- Go to File -> Open and then get to the folder >> where >> >> your data file is located and open it. What happens then? >> >> >> >> -derek >> >> >> >> On Tue, January 22, 2019 4:11 pm, Georgina Hunter-Jones wrote: >> >> > I tried that but all i get is a blank page with headings. >> >> > >> >> > On Tue, 22 Jan 2019 at 21:08, Derek Atkins wrote: >> >> > >> >> >> Was it just one account register that was readonly?? Or was it >> when >> >> you >> >> >> opened the file? >> >> >> >> >> >> What do you mean by "get back to my accounts"? Are you missing >> the >> >> >> Chart >> >> >> of Accounts Page? If so, use View -> New Accounts Page >> >> >> >> >> >> -derek >> >> >> >> >> >> On Tue, January 22, 2019 4:04 pm, Georgina Hunter-Jones wrote: >> >> >> > Ah, it said it was read only a page or so ago. I keep fiddling >> with >> >> >> it, >> >> >> > hoping to get back to my accounts, but I seem to be making it >> >> worse. >> >> >> If I >> >> >> > can get the read only thing back I’ll take a screenshot. Sorry. >> I’m >> >> >> > getting >> >> >> > a bit lost here. >> >> >> > >> >> >> > On Tue, 22 Jan 2019 at 21:00, Derek Atkins >> wrote: >> >> >> > >> >> >> >> Hi, >> >> >> >> >> >> >> >> So if that didn't work -- how is it telling you that it is >> >> read-only? >> >> >> >> Could you supply a screen shot? >> >> >> >> Maybe a step-by-step of what you do and what happens? >> >> >> >> >> >> >> >> I'm at a loss for what else would cause a read-only situation >> here >> >> >> >> except, >> >> >> >> perhaps, you opening a placeholder account. >> >> >> >> >> >> >> >> Thanks, >> >> >> >> >> >> >> >> -derek >> >> >> >> >> >> >> >> On Tue, January 22, 2019 3:55 pm, Georgina Hunter-Jones wrote: >> >> >> >> > Thanks, sadly it did not work. Sorry that replies are so >> slow, >> >> Im >> >> >> not >> >> >> >> > always with the old computer. Thanks >> >> >> >> > >> >> >> >> > On Tue, Jan 15, 2019 at 2:38 PM Georgina Hunter-Jones < >> >> >> >> > helicopterl...@gmail.com> wrote: >> >> >> >> > >> >> >> >> >> Thanks, i’ll Try that. Georgina >> >> >> >> >> >> >> >> >> >> On Tue, Jan 15, 2019 at 2:00 PM Derek Atkins >> >> >> >> wrote: >> >> >> >> >> >> >> >> >> >>> Dear Georgina, >> >> >>
Re: [GNC] Lost all my transactions on Gnu cash
Did it say Read-Only when you when through File->Open? When does it say it is read-only? -derek On Tue, January 22, 2019 4:27 pm, Georgina Hunter-Jones wrote: > Yes, thank you, that worked in that I now have a page with headings and my > accounts in total numbers. For example, the first one is Assets, next > Dehumidifier, then equity, expenses etc and all except Dehumidifier have > totals, but I still can not get into add new inputs. > > On Tue, Jan 22, 2019 at 9:16 PM Derek Atkins wrote: > >> If that's a blank page then that means you have no data open. Did you >> try >> using File -> New File? That might have done it. >> >> Let's start over -- Go to File -> Open and then get to the folder where >> your data file is located and open it. What happens then? >> >> -derek >> >> On Tue, January 22, 2019 4:11 pm, Georgina Hunter-Jones wrote: >> > I tried that but all i get is a blank page with headings. >> > >> > On Tue, 22 Jan 2019 at 21:08, Derek Atkins wrote: >> > >> >> Was it just one account register that was readonly?? Or was it when >> you >> >> opened the file? >> >> >> >> What do you mean by "get back to my accounts"? Are you missing the >> >> Chart >> >> of Accounts Page? If so, use View -> New Accounts Page >> >> >> >> -derek >> >> >> >> On Tue, January 22, 2019 4:04 pm, Georgina Hunter-Jones wrote: >> >> > Ah, it said it was read only a page or so ago. I keep fiddling with >> >> it, >> >> > hoping to get back to my accounts, but I seem to be making it >> worse. >> >> If I >> >> > can get the read only thing back I’ll take a screenshot. Sorry. I’m >> >> > getting >> >> > a bit lost here. >> >> > >> >> > On Tue, 22 Jan 2019 at 21:00, Derek Atkins wrote: >> >> > >> >> >> Hi, >> >> >> >> >> >> So if that didn't work -- how is it telling you that it is >> read-only? >> >> >> Could you supply a screen shot? >> >> >> Maybe a step-by-step of what you do and what happens? >> >> >> >> >> >> I'm at a loss for what else would cause a read-only situation here >> >> >> except, >> >> >> perhaps, you opening a placeholder account. >> >> >> >> >> >> Thanks, >> >> >> >> >> >> -derek >> >> >> >> >> >> On Tue, January 22, 2019 3:55 pm, Georgina Hunter-Jones wrote: >> >> >> > Thanks, sadly it did not work. Sorry that replies are so slow, >> Im >> >> not >> >> >> > always with the old computer. Thanks >> >> >> > >> >> >> > On Tue, Jan 15, 2019 at 2:38 PM Georgina Hunter-Jones < >> >> >> > helicopterl...@gmail.com> wrote: >> >> >> > >> >> >> >> Thanks, i’ll Try that. Georgina >> >> >> >> >> >> >> >> On Tue, Jan 15, 2019 at 2:00 PM Derek Atkins >> >> wrote: >> >> >> >> >> >> >> >>> Dear Georgina, >> >> >> >>> >> >> >> >>> [snip] >> >> >> >>> > Op dinsdag 15 januari 2019 12:52:50 CET schreef Georgina >> >> >> >>> Hunter-Jones: >> >> >> >>> >> Dear Geert, >> >> >> >>> >> Thank you, that helped to a certain extent. I can now see >> >> lines >> >> >> of >> >> >> >>> >> information with the account details. However, it appears >> to >> >> be >> >> >> >>> 'read >> >> >> >>> >> only' >> >> >> >>> >> and I cannot enter any further data. I also cannot see >> >> anything >> >> >> more >> >> >> >>> >> than >> >> >> >>> >> an overall view of the account, ie no dates etc. >> >> >> >>> >> >> >> >> >>> >> Anything I can do to change that? Thank you very much for >> your >> >> >> help >> >> >> >>> so >> >> >> >>> >> far. >> >> >> >
Re: [GNC] Lost all my transactions on Gnu cash
If that's a blank page then that means you have no data open. Did you try using File -> New File? That might have done it. Let's start over -- Go to File -> Open and then get to the folder where your data file is located and open it. What happens then? -derek On Tue, January 22, 2019 4:11 pm, Georgina Hunter-Jones wrote: > I tried that but all i get is a blank page with headings. > > On Tue, 22 Jan 2019 at 21:08, Derek Atkins wrote: > >> Was it just one account register that was readonly?? Or was it when you >> opened the file? >> >> What do you mean by "get back to my accounts"? Are you missing the >> Chart >> of Accounts Page? If so, use View -> New Accounts Page >> >> -derek >> >> On Tue, January 22, 2019 4:04 pm, Georgina Hunter-Jones wrote: >> > Ah, it said it was read only a page or so ago. I keep fiddling with >> it, >> > hoping to get back to my accounts, but I seem to be making it worse. >> If I >> > can get the read only thing back I’ll take a screenshot. Sorry. I’m >> > getting >> > a bit lost here. >> > >> > On Tue, 22 Jan 2019 at 21:00, Derek Atkins wrote: >> > >> >> Hi, >> >> >> >> So if that didn't work -- how is it telling you that it is read-only? >> >> Could you supply a screen shot? >> >> Maybe a step-by-step of what you do and what happens? >> >> >> >> I'm at a loss for what else would cause a read-only situation here >> >> except, >> >> perhaps, you opening a placeholder account. >> >> >> >> Thanks, >> >> >> >> -derek >> >> >> >> On Tue, January 22, 2019 3:55 pm, Georgina Hunter-Jones wrote: >> >> > Thanks, sadly it did not work. Sorry that replies are so slow, Im >> not >> >> > always with the old computer. Thanks >> >> > >> >> > On Tue, Jan 15, 2019 at 2:38 PM Georgina Hunter-Jones < >> >> > helicopterl...@gmail.com> wrote: >> >> > >> >> >> Thanks, i’ll Try that. Georgina >> >> >> >> >> >> On Tue, Jan 15, 2019 at 2:00 PM Derek Atkins >> wrote: >> >> >> >> >> >>> Dear Georgina, >> >> >>> >> >> >>> [snip] >> >> >>> > Op dinsdag 15 januari 2019 12:52:50 CET schreef Georgina >> >> >>> Hunter-Jones: >> >> >>> >> Dear Geert, >> >> >>> >> Thank you, that helped to a certain extent. I can now see >> lines >> >> of >> >> >>> >> information with the account details. However, it appears to >> be >> >> >>> 'read >> >> >>> >> only' >> >> >>> >> and I cannot enter any further data. I also cannot see >> anything >> >> more >> >> >>> >> than >> >> >>> >> an overall view of the account, ie no dates etc. >> >> >>> >> >> >> >>> >> Anything I can do to change that? Thank you very much for your >> >> help >> >> >>> so >> >> >>> >> far. >> >> >>> >> Best wishes, Georgina >> >> >>> >> >> >>> This sounds like it could be a permissions problem, although I'm >> not >> >> >>> familiar enough with MacOS permissions to know how best to fix >> it. >> >> >>> Hopefully a MacOS expert will come in. But it really sounds like >> >> when >> >> >>> you >> >> >>> copied your data file you put it into a directory that your >> current >> >> >>> user >> >> >>> does not have access to write new files. >> >> >>> >> >> >>> Can you try this: >> >> >>> >> >> >>> Make a new folder from the Finder >> >> >>> Copy your data file to the new Folder >> >> >>> Open GnuCash >> >> >>> File -> Open the data file from the new folder >> >> >>> >> >> >>> Does this help? >> >> >>> >> >> >>> >> On Tue, Jan 15, 2019 at 8:31 AM Geert Janssens >> >> >>> >> >> >> >>> >
Re: [GNC] Lost all my transactions on Gnu cash
Was it just one account register that was readonly?? Or was it when you opened the file? What do you mean by "get back to my accounts"? Are you missing the Chart of Accounts Page? If so, use View -> New Accounts Page -derek On Tue, January 22, 2019 4:04 pm, Georgina Hunter-Jones wrote: > Ah, it said it was read only a page or so ago. I keep fiddling with it, > hoping to get back to my accounts, but I seem to be making it worse. If I > can get the read only thing back I’ll take a screenshot. Sorry. I’m > getting > a bit lost here. > > On Tue, 22 Jan 2019 at 21:00, Derek Atkins wrote: > >> Hi, >> >> So if that didn't work -- how is it telling you that it is read-only? >> Could you supply a screen shot? >> Maybe a step-by-step of what you do and what happens? >> >> I'm at a loss for what else would cause a read-only situation here >> except, >> perhaps, you opening a placeholder account. >> >> Thanks, >> >> -derek >> >> On Tue, January 22, 2019 3:55 pm, Georgina Hunter-Jones wrote: >> > Thanks, sadly it did not work. Sorry that replies are so slow, Im not >> > always with the old computer. Thanks >> > >> > On Tue, Jan 15, 2019 at 2:38 PM Georgina Hunter-Jones < >> > helicopterl...@gmail.com> wrote: >> > >> >> Thanks, i’ll Try that. Georgina >> >> >> >> On Tue, Jan 15, 2019 at 2:00 PM Derek Atkins wrote: >> >> >> >>> Dear Georgina, >> >>> >> >>> [snip] >> >>> > Op dinsdag 15 januari 2019 12:52:50 CET schreef Georgina >> >>> Hunter-Jones: >> >>> >> Dear Geert, >> >>> >> Thank you, that helped to a certain extent. I can now see lines >> of >> >>> >> information with the account details. However, it appears to be >> >>> 'read >> >>> >> only' >> >>> >> and I cannot enter any further data. I also cannot see anything >> more >> >>> >> than >> >>> >> an overall view of the account, ie no dates etc. >> >>> >> >> >>> >> Anything I can do to change that? Thank you very much for your >> help >> >>> so >> >>> >> far. >> >>> >> Best wishes, Georgina >> >>> >> >>> This sounds like it could be a permissions problem, although I'm not >> >>> familiar enough with MacOS permissions to know how best to fix it. >> >>> Hopefully a MacOS expert will come in. But it really sounds like >> when >> >>> you >> >>> copied your data file you put it into a directory that your current >> >>> user >> >>> does not have access to write new files. >> >>> >> >>> Can you try this: >> >>> >> >>> Make a new folder from the Finder >> >>> Copy your data file to the new Folder >> >>> Open GnuCash >> >>> File -> Open the data file from the new folder >> >>> >> >>> Does this help? >> >>> >> >>> >> On Tue, Jan 15, 2019 at 8:31 AM Geert Janssens >> >>> >> >> >>> >> >> >>> >> wrote: >> >>> >> > A few other suggestions: >> >>> >> > >> >>> >> > 1. Which files did you transfer ? While that sounds obvious, it >> is >> >>> not >> >>> >> > always >> >>> >> > so. So this question is to ensure you really did copy your >> gnucash >> >>> >> data >> >>> >> > file >> >>> >> > to the older computer. >> >>> >> > >> >>> >> > 2. How have you tried to open your gnucash data file ? It's >> >>> important >> >>> >> to >> >>> >> > realize that on MacOS double-clicking on a random gnucash data >> >>> file >> >>> >> > doesn't >> >>> >> > necessarily mean that file will be opened. GnuCash will always >> >>> reopen >> >>> >> that >> >>> >> > previously last opened file (which may be different from the >> one >> >>> you >> >>> >> > double- >> >>> >> > clicked on). To fix that you can: >> >>> >> > - Start the gnucash application >> >>> >> > - Select File->Open >> >>> >> > - Navigate to your gnucash data file and open it this way >> >>> >> > >> >>> >> > Will that bring your data back ? >> >>> >> > >> >>> >> > Regards, >> >>> >> > >> >>> >> > Geert >> >>> >> >>> > Please remember to CC this list on all your replies. >> >>> > You can do this by using Reply-To-List or Reply-All. >> >>> >> >>> -derek >> >>> >> >>> -- >> >>>Derek Atkins 617-623-3745 >> >>>de...@ihtfp.com www.ihtfp.com >> >>>Computer and Internet Security Consultant >> >>> >> >>> >> > >> >> >> -- >>Derek Atkins 617-623-3745 >>de...@ihtfp.com www.ihtfp.com >>Computer and Internet Security Consultant >> >> > -- Derek Atkins 617-623-3745 de...@ihtfp.com www.ihtfp.com Computer and Internet Security Consultant ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Lost all my transactions on Gnu cash
Hi, So if that didn't work -- how is it telling you that it is read-only? Could you supply a screen shot? Maybe a step-by-step of what you do and what happens? I'm at a loss for what else would cause a read-only situation here except, perhaps, you opening a placeholder account. Thanks, -derek On Tue, January 22, 2019 3:55 pm, Georgina Hunter-Jones wrote: > Thanks, sadly it did not work. Sorry that replies are so slow, Im not > always with the old computer. Thanks > > On Tue, Jan 15, 2019 at 2:38 PM Georgina Hunter-Jones < > helicopterl...@gmail.com> wrote: > >> Thanks, i’ll Try that. Georgina >> >> On Tue, Jan 15, 2019 at 2:00 PM Derek Atkins wrote: >> >>> Dear Georgina, >>> >>> [snip] >>> > Op dinsdag 15 januari 2019 12:52:50 CET schreef Georgina >>> Hunter-Jones: >>> >> Dear Geert, >>> >> Thank you, that helped to a certain extent. I can now see lines of >>> >> information with the account details. However, it appears to be >>> 'read >>> >> only' >>> >> and I cannot enter any further data. I also cannot see anything more >>> >> than >>> >> an overall view of the account, ie no dates etc. >>> >> >>> >> Anything I can do to change that? Thank you very much for your help >>> so >>> >> far. >>> >> Best wishes, Georgina >>> >>> This sounds like it could be a permissions problem, although I'm not >>> familiar enough with MacOS permissions to know how best to fix it. >>> Hopefully a MacOS expert will come in. But it really sounds like when >>> you >>> copied your data file you put it into a directory that your current >>> user >>> does not have access to write new files. >>> >>> Can you try this: >>> >>> Make a new folder from the Finder >>> Copy your data file to the new Folder >>> Open GnuCash >>> File -> Open the data file from the new folder >>> >>> Does this help? >>> >>> >> On Tue, Jan 15, 2019 at 8:31 AM Geert Janssens >>> >> >>> >> >>> >> wrote: >>> >> > A few other suggestions: >>> >> > >>> >> > 1. Which files did you transfer ? While that sounds obvious, it is >>> not >>> >> > always >>> >> > so. So this question is to ensure you really did copy your gnucash >>> >> data >>> >> > file >>> >> > to the older computer. >>> >> > >>> >> > 2. How have you tried to open your gnucash data file ? It's >>> important >>> >> to >>> >> > realize that on MacOS double-clicking on a random gnucash data >>> file >>> >> > doesn't >>> >> > necessarily mean that file will be opened. GnuCash will always >>> reopen >>> >> that >>> >> > previously last opened file (which may be different from the one >>> you >>> >> > double- >>> >> > clicked on). To fix that you can: >>> >> > - Start the gnucash application >>> >> > - Select File->Open >>> >> > - Navigate to your gnucash data file and open it this way >>> >> > >>> >> > Will that bring your data back ? >>> >> > >>> >> > Regards, >>> >> > >>> >> > Geert >>> >>> > Please remember to CC this list on all your replies. >>> > You can do this by using Reply-To-List or Reply-All. >>> >>> -derek >>> >>> -- >>>Derek Atkins 617-623-3745 >>>de...@ihtfp.com www.ihtfp.com >>>Computer and Internet Security Consultant >>> >>> > -- Derek Atkins 617-623-3745 de...@ihtfp.com www.ihtfp.com Computer and Internet Security Consultant ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
