Re: [GNC] gnucash-4.1.tar.bz2
Hi, On Wed, August 12, 2020 3:09 pm, Bill Suit wrote: > I recently downloaded the subject above. I made the mistake of > untarring it! > What I don't know now is how to install it. Looking for a pointer to how > to > accomplish installing it. You downloaded the source code. To install it, you must first build it. The instructions are all there. Did you perhaps intend to download a built package for your platform? If so, you downloaded the wrong thing. What OS/Platform are you running? > > TIA, Bill > 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] Unplanned network outage for GnuCash Server
Hi All, TL;DR: There was an unplanned network outage for code.gnucash.org for the past 16 hours. I was able to route around the damage and packets are flowing again as of about 18h45 US/EDT. Long version: Sometime around 3:30am US/EDT my network stopped talking to my ISP. Unfortunately I was away on holiday for a quick 2-day lake getaway and the only debugging I could do remotely was that I determined I could not reach any of my machines on my raw ISP network. Once I got home this afternoon I was able to debug it further and determine that a bridge I had put in place between my ONT, Modem, and local devices was no longer properly working. I removed that box and reconnected without it an everything came back up. I do want to place that box back into service, because it allows me to bypass the modem NAT table limits, but for now I will keep the network running without it until I can find the time to track down what changes AT&T made to the configuration that caused it to break. But until I can find the time to do that (which will entail taking the network down), I will keep it up and running as a direct-connect. Sorry for any inconvenience this may have caused. Trust me, it wasn't pleasant for me, either, waking up from 100 miles away to see that the network was down! Have a great morning/evening/rest-of-your-day and happy GnuCashing! -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] Can you move a Liability Account to a "sub-account" in Liabilities?
Hi, Yes, of course. Create Liabilities ABC account then edit each of Liabilities A, .. etc and change the parent. -derek On Thu, July 30, 2020 9:41 am, Fran_3 via gnucash-user wrote: > 3 items listed under Liabilities... > Liability ALiability BLiability Ceach to a different entity but related > based on certain criteria. > We want to setup another Liability account "Liabilities ABC" and then move > the 3 above under it as "sub-accounts" like ... > Liabilities- Liabilities ABC-- Liability A-- Liability B-- Liability C > That way we can see the total of the 3 or each individual total... > The Question: Is there any way to do this without having to delete A, B, > C, and re-creating them under Liabilities ABC ? > Thanks for any 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. > -- 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] At Least One Item error on invoice save
Jon Griffith writes: > I'm analyzing the process of invoicing charged back expenses to a customer > job from vendor bills. > > When I create an invoice for a customer for a job for which there are > pending chargeback invoices, those charges are added to the new invoice. > > When I try to post that invoice, I get an error that at least one item > needs to be added to the invoice before it will post? > > And now, after deleting a charged back item from an invoice, I'm unable to > re-add it without creating a new invoice, which is leaving a trail of > invoices that cannot be deleted. > > Is there a better way? A) You have to attach at least one item to the invoice. B) You can re-use old (empty) invoices instead of creating new ones. Just click the "Edit" button and you can choose a new Customer and/or Job and change any other features of the proto-Invoice in order to re-use it. -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] Charging Back to Customer on Job Isn't Working
HI, On Mon, July 20, 2020 2:41 pm, Jon Griffith wrote: > So, if I create an invoice and 10 items are brought into the invoice, I > can > essentially ignore some and invoice some so the next invoice will pick up > where I left off? Yes. > That's great! It's similar to Quickbooks where there's a scrolling list > of > charges that can be added to a customer invoice...and now, not having the > value calculated by default on the invoice makes more sense. Thanks :) > It would be nice down the line to have a separate "line item" area for > billable charges that we could select from and move to the actual lines in > the invoice...but it all seems to work as is. Understood; I do not recall how it was done. There should have been a grouping of the chargebacks and then the rest of the line items. But it's been almost two decades since I wrote that code. -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] Charging Back to Customer on Job Isn't Working
Hi, The idea is that you may have multiple invoices to the customer, so when you bill back an item, GnuCash gives you the flexibility to choose how and when you actually include the chargeback item on an invoice. You may have a reason not to include a chargeback *immediately*, so it defaults to opt-in as opposed to opt-out. Thanks, -derek On Mon, July 20, 2020 1:55 pm, Jon Griffith wrote: > "Concerning the requirement to mark a line item as invoiced to the > customer, that does seem a bit strange. If you didn't want to invoice > it, you wouldn't have added it in the first place. (unless I'm > misunderstanding how that feature works)" > > Exactly. The process would be: > > - Should this be billed to the customer on this job > - Has it been invoiced to the customer? > > When creating the invoice for the customer, the "Invoiced?" field needs to > be checked before it will be added to the document's totals, but the very > act of creating the invoice IS invoicing, so I would think that a few > things would happen. > > 1. We would start an invoice, but that invoice wouldn't be written to the > database until we saved the invoice. > 2. When we save the invoice, the line items on the invoice would be > marked > "invoiced." Perhaps the existence of this field is to accommodate the > current process given the nature of the data being written to the invoices > table upon creating a new invoice rather than saving the new invoice. > > In any event, it works once you figure it out, and that's the most > important part. I'd hate to get knee deep into this and find out I've > done > a bunch of work that's not going to...well, work. ;). Thanks! > > On Mon, Jul 20, 2020 at 9:14 AM Adrien Monteleone < > adrien.montele...@lusfiber.net> wrote: > >> Ah, I see that I set my preference for the status bar to 'top'. So it >> must do the same for bills and invoices. We're talking about the same >> figures though. >> >> Concerning the requirement to mark a line item as invoiced to the >> customer, that does seem a bit strange. If you didn't want to invoice >> it, you wouldn't have added it in the first place. (unless I'm >> misunderstanding how that feature works) >> >> As for the terminology used, you can file an RFE on Bugzilla and if the >> documentation is lacking, a bug can be filed on that as well. >> >> Regards, >> Adrien >> >> On 7/19/20 3:35 PM, Jon Griffith wrote: >> > The attached image shows the invoice creation process for a customer >> and >> > customer job after creating a bill for this customer's job with a >> single >> > item billable to the customer. >> > >> > Notice at the bottom of the image, the totals are zero. >> > >> > There's no clarity here. I finally figured out that you have to put >> an X >> > in the invoiced column and then press the ENTER button at the top for >> the >> > amount to show up in the invoice calculation. Quite confusing. >> > >> > The `Invoiced ?` field in the vendor bill seems out of place, as it >> leads >> > me to think "has this item been invoiced by the vendor to me" in which >> case >> > I scratch my head because the bill I'm entering IS either the invoice >> or >> > purchase receipt, otherwise I wouldn't be entering it. >> > >> > Am I correct in saying that this field is asking "should we invoice >> the >> > customer for this?" But then it seems like it should be sitting right >> next >> > to the Billable column and be titled "Customer Invoiced?"... >> > >> > Confusing process. >> >> ___ >> 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. >> > > > -- > [image: photo] > *Jon Griffith* > REALTOR®, HomeSmart > > 480-463-4062 | j...@jongriffith.com > > http://realtor.jongriffith.com > 10601 N. Hayden Road, Suite I-100 | @RealScottsdale > <http://facebook.com/realscottsdaleliving> > <http://twitter.com/realscottsdale> > <http://www.youtube.com/realscottsda
Re: [GNC] Bills Due Reminder: Column titled "CN?" is what?
"Credit Note?" -derek On Mon, July 20, 2020 11:29 am, Fran_3 via gnucash-user wrote: > What is the "check box" column titled CN? in the Bills Due Reminder? > Thanks. > > ___ > 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.
[GNC] [MAINT] Unplanned network outage for GnuCash Server
Hi, TL;DR: My ISP's upstream router failed causing my network to go away for the last 36 hours. IPv4 service is back as of 9am US/EDT today. IPv6 service should be back shortly (and and I'm writing this, IPv6 is back). Long version: Around 8pm US/EDT on Sunday, July 12th I noticed that my network had failed. I traced it down to the fact that I couldn't reach my upstream ISP router so I sent email asking for assistance. There was nothing else I could do from my end until I heard back from them. Yesterday I reached out again and was told that the router crashed hard and they were working on replacing it and trying to find a backup configuration as well. That was as of 3am Monday morning. Yesterday evening I noticed that the router was reachable again, but it wasn't routing my network to me, so this morning I reached out yet again, and they were able to re-install my configuration, but they had a bug in the IPv6 config. Still, I noticed email started flowing shortly after 9am. Once they corrected the IPv6 config (which happened while I was typing this in), everything came back up and now appears to be reachable. Because it was only down for 36 hours, no email should be lost, only delayed, and no other local data was lost on the GnuCash server. I'm sorry for any inconvenience this may have caused. Alas, there's not much I can do about an upstream router blowing up. :( Happy GnuCashing y'all. :-D -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] Multi Line Notes
HI, On Fri, July 10, 2020 5:54 pm, Matt Miller wrote: > Is there a way to recover the multiline entry and display mode for these > notes? There never was multi-line entry and display of these fields, so there is nothing to "recover". Keep in mind that while "GnuCash for Android" uses the GnuCash name, it is not something developed or supported by the GnuCash team. Your best bet is to remove all newlines from those fields. Or you can try to convert it to and then maybe the report will insert a line-break. Good Luck, > 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] Gnucash - user
flywire writes: >> This will change when (if) we migrate to mailman3, which includes the >> "hyperkitty" forum-like interface, but at this point in time we do not >> have a timeline for when this will happen. > > mailman3 would put wheels on the sled. I must admit I don't know exactly what you mean by this. :-) > 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] Gnucash - user: Google result
Adrien Monteleone writes: > Maybe so! > > Maybe retitle the Mailman page that way? That would be harder to do and maintain over system upgrades. > 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] 'entries' table content - link with taxtables
"finf...@gmail.com" writes: > Hello All, > > Is it normal that there is a link to taxtable > entries(entries.b_taxtable = taxtables.guid) instead of NULL in > invoice entries which are not taxable? > > It makes a lot of confusions when building SQL queries... If you have a default taxtable set then yes. If the "taxable" flag isn't set then it's not used. > 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] Gnucash - user: Google result
We could make a Wiki page with the title "GnuCash Forum" :-D -derek On Tue, July 7, 2020 11:01 am, Adrien Monteleone wrote: > Nope, it was an attachment. (or supposed to be) I made sure to put it at > the end, and my mail.app is set to ‘attach’ rather than ‘inline’. I > confess, mail.app could have done what it wanted though. It wouldn’t be > the first time. > > But here is the URL: > https://lists.gnucash.org/pipermail/gnucash-user/2015-January/057812.html > > Note my followup message that I realized this is a hit from a list topic > with that term, so there isn’t likely anything to be done about it. > > Regards, > Adrien > > >> On Jul 7, 2020 w28d189, at 9:56 AM, Derek Atkins >> wrote: >> >> Any attachment you may have sent was eaten by the list; it was probably >> an >> HTML-embedded image and not an actual "attachment"? >> >> >> URL? > > > ___ > 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] Gnucash - user: Google result
Adrien, On Tue, July 7, 2020 10:34 am, Adrien Monteleone wrote: [snip] > 3 - 5 (see attachment) Any attachment you may have sent was eaten by the list; it was probably an HTML-embedded image and not an actual "attachment"? > #4 - THIS is a problem. That can be fixed by our webmaster. The page title > apparently is ‘UNOFFICIAL GnuCash Forum’. (emphasis mine) That is going to > turn people away from clicking. URL? > 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] Gnucash - user
Hi, On Tue, July 7, 2020 10:09 am, Adrien Monteleone wrote: > Derek, > > Is there any assistance needed to make that migration or is this more of > an infrastructure question? It's a time and infrastructure question. First I need the time to upgrade code to a newer OS that contains MM3. Then I need to spend the time to get MM3 configured. Then I need to spend the time to migrate from MM2 -> MM3, which includes testing the migration and making sure it all works. Once I migrate ONE list then I should be able to migrate the others. Unfortunately it's not something that can be delegated. > 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] Gnucash - user
Dear Adrian, On Tue, July 7, 2020 2:46 am, Adrian Holbrook wrote: > Liz, I tried to respond to a posting by David Cousens [via GnuCash] and it > was rejected by Nabble. Could you pass on the following - Instead of responding via Nabble, you should just respond via Email. > I have also tried to contact Hugo a number of times. In frustration I have > used a different email address and name and registered again following the > instructions on the gnucashe wiki. I have the same problem. I do not > unders > tand the difference between posting > on the Gnucash list vs posting by Nabble - certainly following the wiki > in > structions forces you to use Nabble. as soon as you register you are sent > an > email to click on and it takes you to the Nabble subscribe form. This has *me* confused. If you subscribe via any link at https://lists.gnucash.org/ then I do not see how you could get an email that would link to Nabble. It sounds like you went in via Nabble the first time and tried to "subscribe" via Nabble. > I > am very confused and would love a simple > process that worked like a normal forum without having to go through > hoops The GnuCash lists are, currently, just that: email lists. The GnuCash mailing lists do not have a forum or any supported forum-like interface. Nabble, a 3rd-party service, tries to present that, but as you've seen they appear to be having... issues.. This will change when (if) we migrate to mailman3, which includes the "hyperkitty" forum-like interface, but at this point in time we do not have a timeline for when this will happen. > 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] Gnucash user Nabble
Hi, On Sun, July 5, 2020 10:20 am, John Ralls wrote: > I'm not the list moderator nor do I have shell access to the mail server, > so I can't help you. Your best recourse is to get on IRC > (https://wiki.gnucash.org/wiki/IRC) and ping warlord. > > Regards, > John Ralls > >> On Jul 5, 2020, at 4:24 AM, J R wrote: >> >> I too sorry for contacting you, I also cannot create a new topic or >> reply also >> 1. I am logged in Where are you "logged in"? >> 2. I am subscribed >> 3. I don't know what Liz and I have in common for this problem, maybe a >> yahoo email? Nope, plenty of Yahoo users are subscribed and can email to the lists just fine. >> 4. Was working a couple of months ago There was some software updated a month or so ago on the GnuCash server, but that should not have made any changes to the email server. >> >> Thank You >> Jimmy R >> mikromal...@yahoo.com >> > 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] Transcation Search & Replace
listsub3 writes: > Is there any functionality to do bulk search & replace on > transactions? My old 2002 Quicken had this feature and it was really > useful to do bulk changes/corrections. There is a bulk search, but the replace must be done manually from the resulting search results window. Sorry. > 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] Bulk moving transactions
Popups are a very inefficient entry method. You already have the Ctrl-T (Enter Transfer) popup if you really want to use pop-ups for entry. -derek On Wed, July 1, 2020 5:05 pm, David Carlson wrote: > Back around the time the register2 rewrite was started I believe that I > suggested replacing the complex register code with a basic data input > pop-up window for the selected transaction or other input requirement such > as stock purchase, or business feature more like one would likely find in > a > database application. I will suggest a similar design change today to > whomever decides to take up this task. Unfortunately, I only know Basic > and Fortran IV, which wouldn't get me very far today, so my help would be > very limited. > > On Wed, Jul 1, 2020 at 3:38 PM Jean Laroche wrote: > >> I started looking at that a little while before 4.0 and stopped because >> no new features could be added. I'm going to re-start, as this strikes >> me as a must-have feature. >> The other elephant in the room is the undo/redo support, but that's for >> another thread >> J. >> >> On 7/1/20 1:32 PM, Derek Atkins wrote: >> > >> > On Wed, July 1, 2020 4:27 pm, Jean Laroche wrote: >> >> Does it not trike you as insane that we have to go through these >> hoops >> >> just to bulk move transactions? Something that should be as simple as >> >> shift-select, right-click, move? >> >> I'm not sure how support for multi-select operations was never >> seriously >> >> looked at. >> > >> > Patches always welcome! >> > >> > Seriously, it's not that easy due to the design and implementation of >> the >> > register. The register-2 rewrite was supposed to make it easier, but >> that >> > effort (started about a decade ago) stalled and never finished, so >> we're >> > still using the same Canvas-based register code. >> > >> >> J. >> > >> >> Please remember to CC this list on all your replies. >> >> You can do this by using Reply-To-List or Reply-All. >> > >> > -derek >> > >> ___ >> 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 > -- 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] Bulk moving transactions
On Wed, July 1, 2020 4:27 pm, Jean Laroche wrote: > Does it not trike you as insane that we have to go through these hoops > just to bulk move transactions? Something that should be as simple as > shift-select, right-click, move? > I'm not sure how support for multi-select operations was never seriously > looked at. Patches always welcome! Seriously, it's not that easy due to the design and implementation of the register. The register-2 rewrite was supposed to make it easier, but that effort (started about a decade ago) stalled and never finished, so we're still using the same Canvas-based register code. > J. > 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] Bulk moving transactions
Hi, On Tue, June 30, 2020 4:46 pm, V. Vatsal via gnucash-user wrote: > Hello, > > I am running GnuCash on Mac. > > Somehow a month’s worth of credit card transactions ended up in the top > level Bank Accounts account. Is there some quick way to move or edit them > to the appropriate credit card account? It’s not possible even to move > them manually, as far as I can tell, without jumping to the corresponding > Expense account for each, and then changing the source account there. There are two ways to go about this: 1) If you can delete the top-level "Bank Accounts" account, then it will ask you where to move the transactions and you can select the correct credit card account. This will move all transactions en-masse and is the only way to do just a mass move. 2) You can open the account, Change the View to Auto Split Ledger or Transaction Journal mode (see the View menu), and then you can change the split that ties each transaction to the Bank account to the credit account. Here you do have to manually fix each one, but you can do it in one place; you don't have to jump to each Expense account to do so. Hope this helps, > Thanks, > > Nike > > 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] GnuCash Question: Posting query regarding Accounts receivable and Bad Debts
Hi, On Wed, June 24, 2020 6:19 am, Carla Ralph wrote: > [snip] > I have 2x customer invoices that keep on coming up as reminders even > though a journal entry has been put through for bad debt. > > > Was not able to process payment to bad debts account from Accounts > Receivable > > so I had to do a Journal Entry from Acc Receivable to Bad debts > > Income:Services > > Assets:AccountsReceivable > > Expenses:Bad Debts > > Please assist me with the correct way to post this in your GnuCash system. > Your assitance is greatly appreciated > > > > Regards, > First, IANAA, but in my opinion the correct way to handle this in GnuCash is to Process Payment and then change the destination account from e.g. Bank to the Expenses:Bad Debts account. > Carla Ralph083 585 6309http://magentagroupsa.co.za/ > 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] Tax tables changing
Hi, On Sat, June 20, 2020 6:55 am, finf...@gmail.com wrote: > I have renamed some of taxtables and see the same old names in my bills > and invoices. > > I also see a lot of records with the same taxtable names in Postgresql > table "taxtables". > > Could some body explain the logics of this table? What is "parent" in it? If you search the archives I'm sure you'll find I've gone through this in excruciating detail in the past. In short, Tax Tables get frozen when an invoice is posted. And future changes to the Tax Tables introduce a Copy-on-Write semantic. The reasoning is that if you post an invoice in 2018 with a 2% tax and then in 2019 that tax changes to 3%, if in 2020 you need to revisit that 2018 invoice you want it to display with 2% tax, not 3% tax. So to solve this problem the tax tables are frozen on posting. When you unpost an invoice with tax-table associations it asks you whether you want to keep the taxes or "unfreeze" them (I forget the terminology). I.e., if you unposted that 2018 invoice and told it to unfreeze, then it would change those taxes from 2% to 3% and the values would change when you re-posted the invoice. Sometimes this may be what you want (e.g. to correct an error in the tax table), but sometimes it may NOT be what you want (e.g. to correct a typing error). The "parent" is a pointer from the frozen tax table to the non-frozen one. So when the 2018 invoice is posted, it freezes and when you change it in 2019 you get a parent/child relationship between them. Hope this helps! > Thank you, > > Dimon. > 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 find UnPosted Bill?
Hi, On Fri, June 19, 2020 12:12 pm, Fran_3 via gnucash-user wrote: > Seems like I ran into this way back but can't remember the solution... > - If a bill is created...- Then the bill tab is closed before it is > "Posted" > it seems it does not appear in... > Business > Vendor > Find Billnor in...Reports > Experimental > Vendor > Report (beta) > So where is it? How to find it and post it? It definitely wont be in the latter if it's not posted. It SHOULD be in the former, unless you are only searching for posted invoices? What search criteria are you using? > 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] Disappearing entries
Carl writes: > Well, as it was supposed to happen, all worked out well. Just changed the > biggest file or the one named below to some generic file name. It works > fineso far. Just be careful when you open GnuCash. It is best to just let GnuCash auto-open the last-used file instead of trying to click on a filemane. When you click on a file to open you're likely to mis-click and not notice that you've opened a backup (which, by default, it stored in the same directory as the main data file). > Thanks, all, You're welcome. Good Luck! > Carl > 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] Will Image Attachments go through the email list server?
The list server will strip out HTML (with embedded images) and only send through the text, but if you actually *attach* the file it'll make it through. -derek On Thu, June 18, 2020 11:56 am, Fran_3 via gnucash-user wrote: > Just wondering if I can include an image file with a post? > Thanks > ___ > 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] Disappearing entries
Hi, On Thu, June 18, 2020 11:48 am, Carl wrote: > Here's the command that's used- gnucash %f Hmm.. This could be part of the issue. %f probably means "filename". So if you click a file it'll open that one directly and not the main file. > Below is the name of my GC file (regardless of the name of the file > below the date and time stamp on the file.on the far right of > the file manager...is current for when I last used the file- June 17 > 2020 at 7 PM > GC January 12 2019.gnucash.20190518080326.gnucash AND... here we have what could be part of your issue. This is a backup file. Specifically, this is a backup file that was generated on May 18, 2019 (at 8:03 am). So at SOME point you started working from a year-old backup file. It's unclear when that happened. But you have most likely forked your data. -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] Disappearing entries
Hi, Carl writes: Okay, so you're on current GnuCash on Linux. Good. > 3) How do you open GnuCash and/or the GnuCash data file? > >I click on a shortcut link on my desktop What, exactly, is the shortcut running? What is the embedded "commandline"? Is it a link to a file or the app directly? (I'm just wondering if, by chance, you're opening a backup file). > 4) How are you shutting down GnuCash? > >I click "Save"if not previously saved and then click the X in the >top left of the GC screen Okay, just making sure you don't shutdown the computer with GnuCash still running. >5) What backend storage method are you using? > >Don't know exactly what that means? Maybe it means where and how is >the gc work file stored? It's local. The question is more, is it XML or SQL? Both could be local. If you run "file /path/to/your/datafile.gnucash" what does it say? If it says 'gzip' then it's XML. > 6) Are you SURE that you're not somehow modifying a reconciled transaction > from the other side? > >Yes, very sure. GnuCash is very unlikely to have lost your data. When these kinds of errors occur, they are ostensibly an PEBKAC issue, either a view that hides the data, a non-default sort that makes data look wrong, opening a backup file instead of the main data file, etc. >Thanks, > >Carl > 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] Disappearing entries
Hi Carl, On Wed, June 17, 2020 7:34 pm, Carl wrote: >Hello all, > >For many years a recurring, but not too frequent, problem has been that >in a credit card account entries will disappear or a previously >reconciled balance will be wrong even though I did nothing to change >the account or the bank account it might be associated with. > >Today, for example, I looked at one of my VISA credit card accounts >(that I rarely use), and to my surprise the balance was $4,350.25 even >though, last week, I had reconciled the account and the balance was >zero. And, no, I hadn't changed any of the other accounts in GC or >imported any transactions so there's no reason from my usage that >could've caused this. > >This same sort of problem has happened enough to make ya' pretty >nervous in thinking, "what surprises am I going to find this time?" > >Any idea how to fix this? > >Thanks, > >Carl Several questions come to mind to help you with this: 1) What version of GnuCash are you using? 2) What OS/Distro are you using? 3) How do you open GnuCash and/or the GnuCash data file? 4) How are you shutting down GnuCash? 5) What backend storage method are you using? 6) Are you SURE that you're not somehow modifying a reconciled transaction from the other side? > 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 data after install
;> ___ >> 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. >> > > <https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail> > Virus-free. > www.avast.com > <https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail> > <#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2> > ___ > 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] New Bill: Bill ID vs Billing ID
Hi, Fran_3 via gnucash-user writes: > In 7.10.1 are the field definitions for a New Bill from a > vendor... two of them are... > > Invoice Info - Invoice ID (optional) - the identification number of > the invoice as emitted by the vendor (IE: the vendor’s internal number > for this invoice). > Billing Info - Billing ID (optional) - the vendor’s ID for the bill > (e.g.: their invoice #). > This is confusing to me as follows... > On Bills we receive from vendors we often find a number on the > document we use to identify it...1 - Vendor's Bill Number The idea is that both you and the other entity might have your own unique identifiers for the Bill or Invoice, so this lets you put them both on. This boils down to "naming is hard". When you send out an Invoice to a customer you have your invoice number on it, but the customer may want something on it (like a PO#). When you receive a Bill from a vendor it will have their invoice# on it, but you might want your own counter for it. This is why there are two cases. These numbers are irrespective of due dates. > 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] Trouble opening ancient files
Thomas Klausner writes: > On Tue, Jun 16, 2020 at 10:22:33AM -0400, Derek Atkins wrote: >> This looks like it might be a GnuCash 1.2 or 1.4 binary datafile. The >> ability to read those old binary files was removed more than a decade ago. >> >> You'll need to import that using something probably as old (new?) as 1.6 >> in order to convert it to XML, but you'll probably need a very old OS in >> order to build it. > > Ok, I didn't find such an old binary. > > Does anyone still have such a binary running, or a Windows 2.0.x exe > somewhere? You MAY be able to find them on sourceforge under the Files section. Either that or you'll need to install an old VM to build 2.0 yourself. Unfortunately the earliest Windows exe I've got is 2.4.0 which is way too new for you. >> [snip] >> > Any suggestions on how to get versions of these files that could be >> > opened by gnucash 3.10? >> >> These later XML files are also relatively old. My guess, you'll >> probably need to start with 1.6 (or maybe even 1.4 for the binary data) >> and then keep on doing File -> Open / File -> Save As to translate the >> data files from version to version: >> >> 1.4 -> 1.6 -> 1.8 (was there a 1.8? I don't recall) -> 2.0 -> 2.2 -> >> 2.4 -> 2.6 -> 3.x >> >> Expect this to take a while. > > Actually, this quite a bit easier than I expected. I downloaded the > Windows 2.2.9 binary and opened the newer file and saved it, then 3.10 > could open it successfully. :) Hmm. Surprised that you could jump from 2.2.9 to 3.10 without any issues! I would have expected that you'd have to hit 2.4 or 2.6 first. > Can you please fix this warning: > > "This file/URL appears to be from a newer version of GnuCash. You must > upgrade your version of GnuCash to work with this data." > > that appeared for this file? You would need to provide a copy of the file in (or possible work with the devs to recreate it) in order to get that warning fixed appropriately. > Thanks, > Thomas > 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] Trouble opening ancient files
Hi, Thomas Klausner writes: > Hi! > > I have been using gnucash for a very long time, and recently I tried > opening some of my first files -- but couldn't. Many old files worked, > but not these two and their related .xac files. > > I see two different symptoms. > > One file has an timestamp from 2002. I don't recognize the file > format, it's a binary format, but gzip cannot unpack it > The error I get from gnucash (3.10) is: > > "No suitable backend was found for /path/to/file." > > A hexdump of the file starts with: > > 00 00 00 0a 00 00 00 04 00 00 00 ab 00 08 00 00 || > 0010 00 09 41 75 73 67 61 62 65 6e 00 00 00 00 04 31 |..Ausgaben.1| > 0020 30 30 00 00 00 00 01 00 00 00 00 01 00 00 00 00 |00..| > 0030 04 46 52 46 00 00 00 00 01 00 00 00 00 00 00 00 |.FRF| > 0040 00 01 00 00 00 05 00 00 00 d6 00 08 00 00 00 06 || > 0050 45 73 73 65 6e 00 00 00 00 04 31 31 30 00 00 00 |Essen.110...| This looks like it might be a GnuCash 1.2 or 1.4 binary datafile. The ability to read those old binary files was removed more than a decade ago. You'll need to import that using something probably as old (new?) as 1.6 in order to convert it to XML, but you'll probably need a very old OS in order to build it. [snip] > Any suggestions on how to get versions of these files that could be > opened by gnucash 3.10? These later XML files are also relatively old. My guess, you'll probably need to start with 1.6 (or maybe even 1.4 for the binary data) and then keep on doing File -> Open / File -> Save As to translate the data files from version to version: 1.4 -> 1.6 -> 1.8 (was there a 1.8? I don't recall) -> 2.0 -> 2.2 -> 2.4 -> 2.6 -> 3.x Expect this to take a while. > Thank you, > Thomas > 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] Upgrade from 2.6 to 4.0
Hi, On Thu, June 11, 2020 10:57 am, Stan Brown wrote: > Thanks for the advice, which I'll follow. > > I imagine that I should open each of my files in 3.x before proceeding > with the upgrade to 4.x; am I right? (That's after making backups, of > course.) Considering there is no 4.x, and the current stable release is 3.11, yes. But even once 4.x is released, one should still stop at 3.11 to open and save before going to 4.x. > 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 View: Tip
Stan, On Thu, June 11, 2020 10:49 am, Stan Brown wrote: > Are you talking abut an actual field called capital-N Notes? I don't see > that in my account registers or when I enter a transaction. I see > Description and Memo, but no Notes. Where should I be looking? View -> Double Line Mode > I tried searching for Notes in the help file, but it returned several > dozen articles. Every one I looked at contained the word Note, but I > couldn't find any occurrences of Notes. Indeed, I don't think it's in the Help file per se (although if you search for "Notes field" there is 1 occurrence which would at least give some indication that it exists, if not how to get to it). > 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] [GNC-dev] [MAINT] Server Downtime to update OS and Virtualization Software
Hi All, I forgot to follow up that this maintenance happened on Sunday morning and everything got updated. I even took the opportunity to perform a minor software update on code (although it is still running a slightly "older" OS version -- upgrading that requires a bit more effort than I wanted to put in on Sunday). Thanks, -derek "Derek Atkins" writes: > Hi, > > I plan to update the VM server hosting code.gnucash.org this Sunday, June > 7, 2020, starting around 0900 US/EDT (1300 UTC). I expect total downtime > to be under an hour. During this outage you will be unable to reach the > wiki, email lists, email list archives, IRC logs, nightly builds, and the > master git repo. > > I will announce progress on IRC before, during, and after the update. > > 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] [MAINT] Server Downtime to update OS and Virtualization Software
Hi, I plan to update the VM server hosting code.gnucash.org this Sunday, June 7, 2020, starting around 0900 US/EDT (1300 UTC). I expect total downtime to be under an hour. During this outage you will be unable to reach the wiki, email lists, email list archives, IRC logs, nightly builds, and the master git repo. I will announce progress on IRC before, during, and after the update. 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.
Re: [GNC] Find function
HI, On Tue, June 2, 2020 12:33 pm, Neil B wrote: > I'm giving the search a name using the "save as" function after the search > is completed. Doesn't do any good, apparently. You'd think it would. > But > I guess not. Thanks for your help. Do you mean File -> Save As? That's saving the whole data file. The only way to "save" a search is to keep the results open. -derek > On Tue, Jun 2, 2020 at 12:26 PM Derek Atkins wrote: > >> Hi, >> >> On Tue, June 2, 2020 12:18 pm, Neil B wrote: >> > After performing a search of an account with Find, I save the search >> in >> > order to preserve a particular set of transactions containing the >> "find" >> > term. When I access the saved record, the entire account comes back >> up. >> > In other words, the Find function is useless as a means of preserving >> a >> > search. Is there another way to save a particular search? >> >> How are you "saving" the search? >> >> I don't think there is a way to save a search, per-se. The best way I >> know is to not close the resulting register with the Find results. >> >> > 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] Find function
Hi, On Tue, June 2, 2020 12:18 pm, Neil B wrote: > After performing a search of an account with Find, I save the search in > order to preserve a particular set of transactions containing the "find" > term. When I access the saved record, the entire account comes back up. > In other words, the Find function is useless as a means of preserving a > search. Is there another way to save a particular search? How are you "saving" the search? I don't think there is a way to save a search, per-se. The best way I know is to not close the resulting register with the Find results. > 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] Adjusting journal column widths
Hi, This is in the FAQ: https://wiki.gnucash.org/wiki/FAQ#Q:_How_do_I_resize_my_register_columns.3F_Why_can_I_not_shrink_the_description_column.3F -derek On Mon, June 1, 2020 1:24 pm, rmom...@gmail.com wrote: > I can adjust the column widths in the journal by double clicking the > header. > I'd like to set the description narrower but can't seem to do it. It > occupies a lot of space that cramps the number columns off the right edge > of > the page, the total or balance column. I tried dragging the right side of > the description column to the left but it just snaps back. > > > > I'm running Version: 3.5, Build ID: 3.5+(2019-03-30) on a Windows 10 PC > > > > Thanks, > > Roger > > ___ > 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] Probl?me export / import dans GNU CASH
Hi, I should just add that the gnucash-user list is an English list; if you want support in French we have the gnucash...@gnucash.org list you can use. Thanks, -derek "Chris Good" writes: > Message: 1 > Date: Fri, 29 May 2020 16:01:37 +0200 > From: BCT > To: "gnucash-user@gnucash.org" > Subject: [GNC] Probl?me export / import dans GNU CASH > Message-ID: > <889c5d198787311429e8375dc54c8...@mwinf5d26.me-wanadoo.net> > Content-Type: text/plain; charset="utf-8" > > Bonjour, > Etant nouveau dans une association qui utilisait votre logiciel, j'ai, pour > rendre service, fait un export des comptes et des transactions en fichier > csv croyant pouvoir importer ces donn?es dans un autre logiciel. Or, ce > nouveau logiciel ne correspond pas ? ce que souhaite l'assoc (trop cher). > Maintenant la comptable essaye ? nouveau d'utiliser GNU CASH et toutes les > transactions, clients et comptes ont disparu. > Je pense donc qu'en exportant les data, votre logiciel efface les data de > GNU CASH. J'essaye donc de remettre les data via les fichiers exports de GNU > CASH mais cela ne fonctionne pas bien. > Le log me dit qu'il y a des erreurs (format de date ou nombre de colonnes) > et donc je n'arrive plus ? importer ces data. > Quelqu'un aurait une id?e sur ce que je pourrais essayer afin de remettre > GNU CASH comme avant l'exportation et donc ne pas re-saisir les comptes et > transactions ?.. gr.. > Merci d'avance. > Jean Luc RICURT > > > Provenance?: Courrier pour Windows 10 > > > Bonjour, > > Avec l'aide de Google Translate (with the help of Google Translate) > > L'exportation ne supprime pas les transactions de GnuCash. Quelque chose > d'autre a dû se produire. > > Regards, > Chris Good > > ___ > 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] Fwd: Wrong running balances in reports
Hi, On Thu, May 28, 2020 10:05 am, Derek Atkins wrote: > Finfort writes: > >> >> >> >> Yes I understand. And I have to open this in something like Excel and >> recalculate it. >> >> What is the problem to do this in GNC after >> >> >> changing of sort order? > > GnuCash does not present a running balance in any sort order; the > balance is 100% based on the default sort order. When you enter a > transaction it computes the balance, and that balance is stored with the > transaction split. If you use a different sort order, the balances are > NOT recomputed, the stored balance is displayed along with the split. One more thing I forgot to add -- You can view partial registers and when you do that, if balances were recomputed, you'd NOT have a complete picture of what's going on. GnuCash would be showing you INCORRECT data if it recomputed the balance when you hide transactions. That's a worse outcome, because you might not even know that you're not seeing all your transactions. Case in point: View -> Filter By... -> Status Then turn off, e.g., reconciled transactions. If the balance were recomputed now, you'd be in BIG TROUBLE. > This is not a bug; this is just how GnuCash works. I.e., it is working > as designed. So, this statement remains true. > 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: Wrong running balances in reports
Finfort writes: > > > > Yes I understand. And I have to open this in something like Excel and > recalculate it. > > What is the problem to do this in GNC after > > > changing of sort order? GnuCash does not present a running balance in any sort order; the balance is 100% based on the default sort order. When you enter a transaction it computes the balance, and that balance is stored with the transaction split. If you use a different sort order, the balances are NOT recomputed, the stored balance is displayed along with the split. This is not a bug; this is just how GnuCash works. I.e., it is working as designed. > 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] Wrong running balances in reports
Hi, "finf...@gmail.com" writes: > Appears in reports when you sorting by date and you have 2 > transactions of the same date. > > Needs recalculation of running balance. > > Example of General Ledger report: > > VAT Output Dr Cr Running Balance > > 31/12/19 O.. LTD €25,080.00-€212,124.82 > > 31/12/19 R.. GMBH €2,926.00-€187,044.82 > (should be 215050.82) > > Total For VAT Output €28,006.00 > > In this example rows should stay vice versa, like in the editable form > to have correct running balance. > > So the form has recalculation of running balance, the report does not have. If you change the sort-order in the register you will also notice the balance is "off" -- the balance is computed based on the default sort order and displayed in whatever view you have. In other words, the balance is ONLY valid in the default sort order, not any other sort order. This is true in reports as well as the register. > 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 "relaunch" Transaction Report Options Window
Of course! Just click the "Options" button in the toolbar. It kind of looks like a wrench. -derek On Tue, May 19, 2020 11:43 am, Fran_3 via gnucash-user wrote: > After I create a "Transaction Report" I often close the "Transaction > Report Options Window"That is the window that allows me to select the date > range, choose what columns to display, etc.And often, after I close the > Options Window... I wish I hadn't as I want to tweak something about the > report. > The Question:While I'm looking at a Transaction Report...And having > already closed the "Transaction Report Options Window" > Is there a way to "Relaunch" the "Transaction Report Options Window" and > tweak the existing report? > Thanks > ___ > 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] Is there a better way enter multi-currency split transaction?
John Ralls writes: > Trading splits are ignored; they don't turn on the ---split > transaction--- flag in the Transfer Account cell. I think what's > causing grief is the no-value Asset:Stock:ABC split. Oh, yeah, you're absolutely right. That extra split in there is what's causing the confusion! > Regards, > John Ralls -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] Report seems to pull wrong amount from transaction
Adrien Monteleone writes: > Originally I was thinking of the setting for GC to determine price by > ‘Most Recent’ or ‘Nearest In Time’, and such, but I see the > Transaction Report doesn’t have it. As indeed it shouldn't. A transaction has a fixed exchange rate, and that's the exchange rate that should be used for that transaction in the transaction report. The only arguable place where an "other" exchange rate should come in during a transaction report is if you have a transaction between X and Y but you're trying to display a report in currency Z. Then the question is, if the transaction from X to Y happens at date D, and you're running the report on date E, what exchange rate should you use for the transaction? Note that I don't think there is one right answer for this 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] Reconciliation "R" column question
Hi, The three* values (at least in English) are n, c, and y. Yes, you may freely swap between n and c in the register. It just causes a recomputation of account balances. I do not believe you can get to 'y' without going through formal reconciliation. I.e., I don't think you can type 'y' in there and have it be accepted, although I admit I've never tried to do that. It would be missing the "reconcile date" metadata for one thing. Hope this helps. -derek * There is also a 'v' (void) status. On Mon, May 18, 2020 9:41 am, Fran_3 via gnucash-user wrote: > In Help 2.94 Reconciliation... "R" column choices are... > n = not cleared the bankc = cleared the bankr = Reconciled > I've got the GnuCash Check Register open in one window and I'm logged on > to the bank in another window looking at recent transactions...I'm trying > to make sure each bank transaction has been entered into GC.I'm not doing > a formal monthly reconciliation... this is just an end of day check up. > > Question 1: May I freely change "n" and "c" back and forth while looking > at the check register?Question 2: I understand that if you enter "r" in > the "R" field it is hard to change back... true? > Thanks for any 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. > -- 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] Is there a better way enter multi-currency split transaction?
Arguably a transaction that has 2 trading account splits and 2 regular account splits should be treated like a regular transaction. -derek Sent using my mobile device. Please excuse any typos. On May 16, 2020 10:07:02 AM John Ralls wrote: On May 16, 2020, at 4:48 AM, Adrien Monteleone wrote: On May 16, 2020 w20d137, at 4:19 AM, Davy Roid wrote: Not sure whether this is a software limitation or there is a better way to do this. For example, the following memorized transaction for recording stock dividend in USD and Dividend Income in EUR Totalal Deposit Withdrawal Asset\Citibank\USD100.00 Trading\Currency\EUR 92.00 Asset\Stock\ABC Income\Dividend 92.00 Trading\Currency\USD 100.00 My experience is the first time I enter this transaction in the Bank's USD account, the exchange rate screen will popup and convert USD 100.00 to EUR 92 in Income\Dividend. All I have to do is to add a dummy split to indicate the relevant stock for this dividend. You could just put the stock as a Memo in one of the relevant splits. I don’t see a need for a dummy split. However, if I re-enter this transaction with USD 50.00 using the memorized transaction feature, only the first split transaction will be updated with "50.00" and I have to manually change the remain 3 figures. Exchange rate windows won't popup to calculate the currency conversion. Hmm... Seems like a bug. If you are entering transaction with two currencies GC will either ask, or make a guess, but I’ve never seen it do neither. What happens if you change the Dividend amount (as if you were entering this for the first time)? Does GC create new Trading or Imbalance splits? Does it alter the existing Trading splits? It's not autofill, that finished when it filled in the transaction with a copy of the other one that matched. It's because if there's more than two splits GnuCash doesn't know how to apportion the changed amount so the edit in basic view changes only the split in the current account. Regards, John Ralls ___ 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] Report seems to pull wrong amount from transaction
Art, Art Chimes writes: > My report apparently uses the number of shares x the price per share > to compute the dollar amount. Possibly the dollar value of the > transaction is not stored in the user's data file but rather is > computed on the fly? The incorrect dollar figure in the report was the Within a transaction, GnuCash stores the # shares and the total value of those shares. The "share price" is a computed value. Having said that, GnuCash also stores a "PriceDB", which contains the various share prices and exchange rates at various points in time. Using this, you can see exactly how much you spent on the purchase of the shares, and then multiplying by the PriceDB entry you can see the current value of those shares. > product of the correct number of shares times an incorrect share > price. But the share price in the account register is correct. So > where is the incorrect share price coming from? My guess is the PriceDB. Or your "Price Source" selection in the report options. The "Weighted Average" is almost always the incorrect choice. [snip] > Anyway, I quickly determined that the incorrect dollar amount entered > was the result of multiplying the number of shares times the share > price on Jan 31 — the closest date in the Price Database. I manually > added the correct share price for Jan. 29. And now the report has the > correct dollar amounts. There you go. :) > Problem solved. But I wonder if I should file an enhancement request > that reports using a calculated value based on a close but not exact > share price should be flagged (with an asterisk and footnote?) as > questionable. It is certainly reasonable to flag a report where the pricedb entries are off by more than a few days. > Thanks all who chipped in to help solve this mystery Great community here! > > 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] warehouse Inventory
HI, Please be sure to CC gnucash-user on all replies using your mailer's reply-to-list or reply-all functionality. This way other people can see your responses and reply with additional insights. On Thu, May 7, 2020 3:31 pm, Muhamad Moghadam wrote: > I need a open source and free accounting tool for Warehouse Inventory, > create customer , create invoice and other features in linux. what is your > suggestion? Well, GnuCash can certainly do the Customer/Invoice and accounting on Linux. It is really the "warehouse inventory" that it doesn't do well. I don't have another suggestion but maybe others do. >> > 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] warehouse Inventory
Hi, On Thu, May 7, 2020 3:15 pm, msm1365 wrote: > Hello Dear, > I need to create warehouse Inventory in gnucash. how to do it? GnuCash really isn't the best tool to use for Warehouse Inventory. While you can make GnuCash keep track of how many widgets you have, and the cost (value) of those widgets, there isn't really a good place to store location or other warehouse-like information. If you MUST use GnuCash, the best way to do it is to create a new stock type for each widget and then a new stock/mutual account for each widget. Then you record your purchase and sale txns just like you would for a stock purchase or sale. It's very cumbersome for lots of items, which is why we recommend you find another tool. > 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 matcher shortcomings, OFX realm (at least)
What if there are no matches? Then the LHS won't be empty. -derek Sent using my mobile device. Please excuse any typos. On May 6, 2020 8:09:03 PM Christopher Lam wrote: Are you discussing qif or ofx. The main difficulty is qif code written 20 years ago and has not modernised. The multi to multi issue will always be very difficult, hence I'd previously imagined a two pane register, qif/ofx on left, existing register on right, and drag and drop to marry up the splits. A successful pairing removes line on both panes out of sight. Matching is complete when the LHS is empty. On Thu, 7 May 2020, 3:39 am David Reiser via gnucash-user, < gnucash-user@gnucash.org> wrote: Overall, yes. But this case presents a many-to-many sorting out vs. the one-to-many resolution in QIF. And none of those unique IDs exist in the gnucash file until the transactions have finished being imported. -- Dave Reiser dbrei...@icloud.com > On May 6, 2020, at 2:50 PM, Jean Laroche wrote: > > QIF is a lot worse the OFX. OFX transactions have a unique ID, which QIF ones don't have... > > On 5/6/20 11:48 AM, David Reiser wrote: >> Thanks, Jean. >> I think the QIF importer has some code that detects multiple possible matches and pops up a “select the right match” dialog/window. Perhaps that can be reworked/incorporated. I don’t use QIF too much, but I think that particular behavior gets triggered in a step a little closer to the final import sequence than the General Matcher window gets to when it has decided it has already identified matches. >> -- >> Dave Reiser >> dbrei...@icloud.com >>> On May 6, 2020, at 2:16 PM, Jean Laroche wrote: >>> >>> I have run into this issue as well! Thanks for looking into it. >>> I'll try to fix it. What should really be done here, I'm guessing is that the matcher should not match several transactions to the same one. This may not be super easy to fix, but I'll take a look. >>> Jean >>> >>> On 5/6/20 11:00 AM, David Reiser via gnucash-user wrote: Michael Fross said: > I have to keep importing the same QFX file over and over until I get > “nothing to import” message. If I don’t, it seems to miss transactions in > the file. Not sure about QIF, but Maybe it’s similar. > > Michael Ok, I’ll split this out into another discussion. The need for multiple attempts at importing the same ofx file to get all the transactions imported is probably a result of a shortcoming in the matcher code when multiple same-dollar-value transactions (or nearly the same if Commercial ATM fee threshold is set to anything greater than 0.00) appear in the ofx file. One very common cause of such cases is vending machine transactions. If you never enter any of the same-value transactions manually, and only import them, then you’ll probably be OK, because the matcher will suggest that all the transactions should be Added rather than matched. If, however, you have even one of the same-value transactions entered manually, and a set of 5 same-value transactions incoming in the import file, the matcher’s default behavior is to display all 5 incoming transactions as having a good candidate match. The problem is that all five of those incoming transactions are pointed at a single transaction in the gnucash file. If you blithely click OK in the Matcher window, the import process matches the first incoming transaction to the existing transaction. Then when the second same-value transaction gets examined, the matcher says “Oh, I already matched that existing transaction, I’ll ignore this one”. And all subsequent same-value transaction that had reported they had a match in the file are ignored because the candidate match is already taken. Matching can be even messier if you have, say, 4 transactions of $2.00 entered in your data file, but 7 $2.00 transactions coming in with the import. The reason sequential imports work is that once a candidate is matched and the import process ends, the next time the import process is launched, that first transaction is no longer a candidate match because it now has an imported transaction ID associated with it (and the transaction ID prevents the incoming transaction from appearing at all anymore), and the matcher moves on (sometimes only one candidate transaction at a time). I did file a bug on this several years ago, but the matcher’s default match identification has not changed. What was added is the ability to double click a transaction in the matcher dialog window to see alternative transactions to match against. If you see multiple transactions in your matcher window with the same dollar value, you must inspect the potential matches for each one and select a different one from the top candidate picked by default for all the same-value transactions. I hope this explanation helps reduce the number of repeat imports you have to use. Dave -- Dave Reiser dbrei...@icloud.com
Re: [GNC] Why R in Reconcile
Try making the column wider. That looks like an 'n' that's being cut off. -derek Sent using my mobile device. Please excuse any typos. On May 6, 2020 7:05:51 PM Bruce Irving wrote: attached Bruce Preach the Gospel wherever you go. If necessary, use words. On Wednesday, May 6, 2020, 4:08:29 PM MDT, Derek Atkins wrote: HI, On Wed, May 6, 2020 5:57 pm, Bruce Irving via gnucash-user wrote: I just finished reinstalling my OS. In the process, I'm now on 3.10.I am curious. Why is the reconcile column filled with R? It makes it more difficult for me to see what has been cleared or reconciled. Can you show a screen shot? In my register is see 'n', 'c', and 'y' in the Reconciled column. Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All. -derek -- Derek Atkins617-623-3745 de...@ihtfp.comwww.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] Why R in Reconcile
HI, On Wed, May 6, 2020 5:57 pm, Bruce Irving via gnucash-user wrote: > I just finished reinstalling my OS. In the process, I'm now on 3.10.I am > curious. Why is the reconcile column filled with R? It makes it more > difficult for me to see what has been cleared or reconciled. Can you show a screen shot? In my register is see 'n', 'c', and 'y' in the Reconciled column. > 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] Change account type by editing XML?
david whiting writes: > Assuming I have understood correctly, this still doesn't allow me to > change the account type. See attached screenshot of the Edit Account > dialogue after having moved an account to the top level. There might be a specific test for AR/AP, in case you have posted invoices -- ensure you have no transactions in there. > 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] Export Transaction Report as pdf Splits Last Line over 2 Pages
Yes, it will.. And will parse tables properly into rows/columns. -derek Sent using my mobile device. Please excuse any typos. On May 2, 2020 7:47:16 AM flywire wrote: Off-topic but will LO calc directly open a HTML file? (It opens in writer and wiki is more about excel.) ___ 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] Export Transaction Report as pdf Splits Last Line over 2 Pages
Yep. Known issue on windows due to webkit. Export to html and then load into browser and convert to pdf from there. -derek Sent using my mobile device. Please excuse any typos. On May 2, 2020 7:24:29 AM flywire wrote: Is exporting Transaction Report as pdf splitting the last line horizontally over 2 pages a known issue? Occurs on 15 of 38 pages viewed in either Chrome or Edge under Win10. ___ 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] Change account type by editing XML?
"Stephen M. Butler" writes: > On 4/29/20 11:25 AM, david whiting wrote: >> Hello, >> >> When I first set up my accounts (for a local club) I knew very little >> about accounting and misinterpreted some information I was given by an >> accountant and ended up creating some sub-accounts in Accounts Receivable. >> I now know that was not the correct thing to do, and I should have created >> these accounts as straight-forward asset accounts. >> >> Using gnucash I cannot change the account type for these accounts. When I >> use ctrl+e on these accounts I only see account type A/Receivable so I >> cannot change them through the GUI. > > When I've had problems changing the account type on an account, I found > that changing the parent first opens up the additional account types to > be used. > > Don't know if that will work for A/R (as I don't utilize them). Indeed, I was going to suggest that you re-parent to make it a top-level account, then you can change the type, and then you can re-parent it wherever you want in the hierarchy. -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] AqBanking for Canadian banks
Nelson writes: > Hello everyone. > > Just wondering if anyone was successful in setting up any Canadian banks for > online banking in GnuCash. Thanks for sharing. Do they support OFX-DC? You can check OFXHome for your bank info? Good Luck, > 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] Why do Imported Transactions NEED to be Matched?
Hi, flywire writes: > Agree that import works in small chunks (as posted previously). Does that > response cover any way of getting GUIDs on the data? The GUIDs are 100% internal to GnuCash and unique per user per object (account, transaction, etc). There is no way to add GUIDs to imports, and even if you did it would never make sense because there is no way your bank or any other entity would know what GUID to use in your personal gnucash database. Just a case in point, even if you and I have the same account name, e.g. Expenses:Groceries, the GUID in my book and the GUID in your book would be different. Having said that, there *ARE* ways to map from textual account name to GUID, and the CSV and QIF importers already do that to some degree. > 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] Mortgage repayment schedule : error while inputting million
Hi, Sorry for the delayed response (I'm still catching up on old emails). Murugan writes: > i am new to this forum. i am trying to create a mortgage repayment schedule > for 2 Million pesos , but the formula is not picking up the value and > showing a zero. can you please let me know what i am doing wrong Can you post a screen shot on what you see? You DO need to manually enter the mortgage amount; it doesn't pull it from the liability balance. > 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] Customer Chargeback
Hi, I don't see any responses to this question; sorry for the delay but I am catching up on 2 months of email.. Marcell Madar writes: > Hi, > > I am trying to use the chargeback function in Gnucash. The chargeback > customer and job are both specified when I create the bill and the > "Billable" column is checked on all items in the bill. However, I cannot see > any option to link this Bill to an Invoice that I send to a customer. > > Could you please help me how the chargeback option works in GnuCash? The way it is supposed to work is when you post Vendor Bills with items marked "Billable", those posted line-items will appear in the Invoice editor for the customer. Then you need to *attach* the items to the invoice by clicking on the first column in the invoice. Hope this helps. > Thank you, > Marcell > 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] Restoring "Unable to save to database" error?
Hi Eric, Sorry to respond to an old message but I didn't see any responses and I am currently catching up on ~2 months of email.. "Eric H. Bowen via gnucash-user" writes: > I've been getting the "Unable to save to database" error whenever I > import and/or save transactions in one of my asset accounts. I haven't > lost any transactions, but it appears that the database which > automatically matches imported transactions (or attempts to) is > corrupted. I'd be perfectly happy to drop the old database and begin > again with a new one, as long as I can keep my previously saved > transactions, but I haven't yet found a (newbie friendly) way to do > this. Any assistance?Eric. Assuming you have not solved this, yet -- have you tried to use File -> Save As to save it to a new database or an XML file? That should at least get you going. Another option is File -> Save As to XML, delete your (SQL?) database, and then File -> Save As back to the SQL database to get it to rebuild. 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] Find or search all expenses in a certain account
Hi, Sorry to respond to an old thread, but I'm catching up on 2 months of emails while I was heads-down on another project.. Gio Bacareza writes: > I'll give it a try. Thanks Adrien > > On Tue, Mar 10, 2020 at 11:41 AM Adrien Monteleone < > adrien.montele...@lusfiber.net> wrote: > >> That was the right criteria. I’m not sure why it isn’t working for you. >> >> Maybe I missed something, but you noted earlier that you have 10 >> transactions that are transfers and are fixed properly. You want to delete >> everything else in AccountA. >> >> Doing a search for ‘everything else’ seems to be overkill. (especially at >> this point) Can’t you just do one of the following: Here's the problem with these approaches. A register is, by definition, the result of a search. Specifically, it is a SPLIT searach where the initial criteria is "split->account == register_account". When you do a FIND from within a register, you are, by definition, limiting your search to the *account splits*. Transfer accounts are, by definition, in *other* splits, not the account splits. The reason is that you get a search query that looks like: Find splits where Split->account == register_account AND ( ... your stuff ... ) So, in short, you can't do what you want from within a register because of the way sub-searches are implemented. The only way to do this search is to start from the CoA and search for transactions' split-accounts that match both A and B. 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] Invoice Date
Adrien, Sorry for the delayed response -- I'm catching up on 2 months of emails while I was heads-down on other projects. Adrien Monteleone writes: > I forgot to mention, if you didn’t notice the ‘date opened’ field in > the pop-up, and you are already in the invoice, click the Edit Invoice > button to change it. The date cannot be changed from the invoice > viewing screen. (this is a known bug) Nope, it's a feature -- working as designed. :) > 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] New User - Unique Transaction Number & Dates
Hi Stan, Sorry to respond to an old message, but I'm catching up on ~2 months of mail when I was heads-down on other projects.. Stan Brown writes: > David, you may be thinking of File » Properties » Accounts » Day > Threshold for Read-Only Transactions (red-line). > > I'm not sure why the developers thought it would be a good idea to do > this as a number of days in the past instead of a date in the past, but > they did. It means that if you want, say, to prevent yourself from > accidentally changing something in last year's transactions, or > accidentally entering a new transaction with last year's date, you have > to change the red-line every single day that you use GnuCash. The idea is that you probably never want to enter transactions more than e.g. 90 days old. The devs decided this is a more common desire than "don't enter last year". If you set a fixed date then you need to remember to change it all the time, whereas with a days-setting you can set it and forget it. If you're someone who enters transactions once a year, then yes, this might be a bit more problematic. If you enter transactions once a week, this makes much more sense. Hope this explains the reasoning. Enjoy! -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] VM (bugfix) Upgrade this weekend
Hi, There is a bug in the current version of Ovirt I'm using that causes a periodic (like once a quarter) ABRT of one of the management services. Therefore, I am planning to upgrade to a new patch release, but that will require rebooting the VM server (and as a result, rebooting code). I plan to do that this weekend. I don't expect the downtime to be more than a few (well, 15-30) minutes. Exact time TBD based on family free time, but I'll chat on IRC before, during, and after. -derek PS: I wonder if it makes sense to get a second CPU server (and a third system to act as an "arbiter") in order to allow real-time VM migration and allow host system upgrades without affecting VM uptime? *ponders* -- 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] notify when new version is available?
On the other hand, implementing it wouldn't be too hard to do. Not everyone updates their systems every day/week, so just knowing there is a more recent version if, for no other reason than to notify their distribution or look there, isn't a BAD thing. I'll note that there are other systems, even with packaging, that notify of updates. This is especially true of cross-platform systems. E.g., Chrome, Firefox.. Even the Unifi Controller software notifies of updates. Granted, I don't consider this a high priority, but a small, click-away popup or corner-notification on app startup seems like a reasonable feature to me. -derek On Tue, April 28, 2020 9:46 am, Geert Janssens wrote: > On platforms with an app store or package manager this doesn't make sense. > It's the > responsibility of those to inform the user of application updates. And on > these platforms it would > be silly for each app to reinvent that wheel. > > I am aware many applications on Windows will notify you when a new release > is available. That > platform doesn't have a strong package manager or app store story. > > Regards, > > Geert > > Op dinsdag 28 april 2020 05:46:39 CEST schreef Ed Love: >> Thanks for moving it somewhere clearer. I'm surprised more people don't >> want this feature, it's bog standard in most programs I use every day. >> >> Thanks for your help! >> >> Ed >> >> On 28/04/2020 7:49 am, Frank H. Ellenberger wrote: >> > Am 27.04.20 um 07:15 schrieb Ed Love: >> >> Is this possible? It would be useful! I checked the FAQ but found >> >> nothing. >> >> >> >> Thanks, >> >> >> >> Ed >> > >> > You should read more precise. The FAQ has several links to >> > https://wiki.gnucash.org/wiki/Mailing_Lists. And there is: >> > * gnucash-announce: a low traffic Announcement list, e.g. for package >> > maintainers. >> > >> > OK, it was hidden in the section >> > https://wiki.gnucash.org/wiki/Mailing_Lists#Mailing_Lists_for_Development_ >> > Topics. I have moved it to >> > https://wiki.gnucash.org/wiki/Mailing_Lists#Announcements >> > >> > And I will revew "Tip of the day" to incorporate it there. >> > >> > How should we the FAQ? >> > >> > Regards >> > Frank >> >> ___ >> 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. > -- 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] Open two files at once
HI, GnuCash doesn't allow multiple data files to be open. Do do what you want you need two instances of GnuCash running in parallel. How you do that is definitely OS specific. I honestly don't know if MacOS allows you to run two instances simultaneously. -derek On Fri, April 24, 2020 10:51 am, Eric Beversluis wrote: > I’m running GnuCash 3.7 on Mac 10.12.6. > > I can’t figure out how to open two files at once. I need to copy entries > from my LLC acct to my personal account, but when I have the LLC GnuCash > file open I can’t get the personal LLC file open. > > What’s the trick? When I click on the file under GnuCash->File, it closes > the first file. WHen I try to open it from the Finder, nothing happens. > > I know I’ve done that in the past, when I was operating on a Linux box. > > Eric Beversluis > Short fiction at www.ericbeversluis.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. > -- 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] Manuals for GnuCash
On Wed, April 15, 2020 2:12 pm, Rich Shepard wrote: > On Wed, 15 Apr 2020, Derek Atkins wrote: > >> It's working for me... https://www.gnucash.org/ > > Derek, > > It's now working for me, too. Perhaps it was restricted from being viewed > at > the time I visited. > >> Just a note that the GnuCash team DOES receive a small royalty fee from >> PACKT publishing for copies of this book that get sold (assuming this is >> the PACKT publishing book). It's not a lot, mind you, but it is >> something. > > But for version 2.4 docs when 3.10 is now current? The book has not been updated, but MOST of the content is still relevant. Certainly all the background and process planning is still relevant, even if the UI has moved on. Maybe we should reach out and see if they want to refresh the book? > 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] Manuals for GnuCash
Hi, On Wed, April 15, 2020 1:34 pm, Rich Shepard wrote: > On Wed, 15 Apr 2020, Edward Bainton wrote: > [snip] > The gnucash web site seems to be down now as I get to look at only > a blank page. It's working for me... https://www.gnucash.org/ > Don't give Amazon your money for that book. Just a note that the GnuCash team DOES receive a small royalty fee from PACKT publishing for copies of this book that get sold (assuming this is the PACKT publishing book). It's not a lot, mind you, but it is something. > HTH, > > 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] Would like to use, but ....
Andrew, PLEASE CC gnucash-user on your replies! -derek On Wed, April 15, 2020 9:24 am, Andrew Ruddle wrote: > > https://www.gnucash.org/download.phtml - towards the bottom has the last > XP version. > > Although page https://www.gnucash.org/offers a link CALLED with > reference to the old version, when you get there [ > https://sourceforge.net/projects/gnucash/files/sourceforge ] sourceforge > have screwed it up so you just get the 7/8/10 one. > > APR > > -Original Message- > From: Derek Atkins [mailto:de...@ihtfp.com] > Sent: 15 April 2020 14:02 > To: Andrew Ruddle > Cc: gnucash-user@gnucash.org > Subject: RE: [GNC] Would like to use, but > > Hi Andrew, > > First, please remember to CC gnucash-user on your replies so that others > may > benefit from the conversation and chime in. You can do this by using the > Reply-To-List or Reply-All functionality in your mailer. > > If you could supply us with the URL of the page that points to WinXP, > there > is a chance that we might be able to fix it. BUt of course it depends if > it > is on a page that we can control or not. No way for us to tell without > knowing the specific page ;) > > Thanks, > > -derek > > On Wed, April 15, 2020 9:02 am, Andrew Ruddle wrote: >> >> I fully recognise and accept that the XP one will be a bit creaky. >> >> After some more poking about, the substance of my problem was / is >> that the Sourceforge link to download the XP version just goes to the >> version for 7, >> 8 & 10 - which explains the funny messages. >> >> I have dropped a line to Sourceforge, but I have little doubt nothing >> will change. >> >> APR >> >> -Original Message- >> From: Derek Atkins [mailto:de...@ihtfp.com] >> Sent: 15 April 2020 13:20 >> To: Andrew Ruddle >> Cc: gnucash-user@gnucash.org >> Subject: Re: [GNC] Would like to use, but >> >> Hi, >> >> On Tue, April 14, 2020 8:00 am, Andrew Ruddle wrote: >>> >>> Greetings >>> >>> I have been very highly recommended to GnuCash, but I am having >>> difficulty getting started. >>> >>> I have downloaded and installed [the XP Vista version on >>> Sourceforge], but when I try to open it all I get is a rather >>> unhelpful message as >> follows : >> >> What version did you download? We have not supported Windows XP for a >> few years already, and all currently supported releases defintely wont >> work on that old platform. The minimum-required version is Windows 7. >> >>> The procedure entry point GetTickCount64 could not be located in the >>> dynamic link library KERNEL32.dll >>> >>> If anyone can either tell me what extra I need to do, or point me to >>> a more reliable download, I shall be very grateful. >> >> You need to upgrade to Win7, or you need to download a VERY OLD (and >> probably very buggy, and DEFINITELY unsupported) version of GnuCash. >> This error message means that the application is trying to call into a >> function that XP doesn't implement or support, which is not surprising >> since XP is almost 20 years old. >> >> Sorry, but you're into unsupported territory by trying to run on XP. >> Even >> Win7 has already expired but we do still support that, barely. >> >> Good Luck, >> >>> Kind Regards >>> Dr. Andrew Ruddle >>> UK >> >>> 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] Would like to use, but ....
Hi Andrew, First, please remember to CC gnucash-user on your replies so that others may benefit from the conversation and chime in. You can do this by using the Reply-To-List or Reply-All functionality in your mailer. If you could supply us with the URL of the page that points to WinXP, there is a chance that we might be able to fix it. BUt of course it depends if it is on a page that we can control or not. No way for us to tell without knowing the specific page ;) Thanks, -derek On Wed, April 15, 2020 9:02 am, Andrew Ruddle wrote: > > I fully recognise and accept that the XP one will be a bit creaky. > > After some more poking about, the substance of my problem was / is that > the > Sourceforge link to download the XP version just goes to the version for > 7, > 8 & 10 - which explains the funny messages. > > I have dropped a line to Sourceforge, but I have little doubt nothing will > change. > > APR > > -Original Message- > From: Derek Atkins [mailto:de...@ihtfp.com] > Sent: 15 April 2020 13:20 > To: Andrew Ruddle > Cc: gnucash-user@gnucash.org > Subject: Re: [GNC] Would like to use, but > > Hi, > > On Tue, April 14, 2020 8:00 am, Andrew Ruddle wrote: >> >> Greetings >> >> I have been very highly recommended to GnuCash, but I am having >> difficulty getting started. >> >> I have downloaded and installed [the XP Vista version on Sourceforge], >> but when I try to open it all I get is a rather unhelpful message as > follows : > > What version did you download? We have not supported Windows XP for a few > years already, and all currently supported releases defintely wont work on > that old platform. The minimum-required version is Windows 7. > >> The procedure entry point GetTickCount64 could not be located in the >> dynamic link library KERNEL32.dll >> >> If anyone can either tell me what extra I need to do, or point me to a >> more reliable download, I shall be very grateful. > > You need to upgrade to Win7, or you need to download a VERY OLD (and > probably very buggy, and DEFINITELY unsupported) version of GnuCash. This > error message means that the application is trying to call into a function > that XP doesn't implement or support, which is not surprising since XP is > almost 20 years old. > > Sorry, but you're into unsupported territory by trying to run on XP. Even > Win7 has already expired but we do still support that, barely. > > Good Luck, > >> Kind Regards >> Dr. Andrew Ruddle >> UK > >> 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] Would like to use, but ....
Hi, On Tue, April 14, 2020 8:00 am, Andrew Ruddle wrote: > > Greetings > > I have been very highly recommended to GnuCash, but I am having difficulty > getting started. > > I have downloaded and installed [the XP Vista version on Sourceforge], but > when I try to open it all I get is a rather unhelpful message as follows : What version did you download? We have not supported Windows XP for a few years already, and all currently supported releases defintely wont work on that old platform. The minimum-required version is Windows 7. > The procedure entry point GetTickCount64 could not be located in the > dynamic > link library KERNEL32.dll > > If anyone can either tell me what extra I need to do, or point me to a > more > reliable download, I shall be very grateful. You need to upgrade to Win7, or you need to download a VERY OLD (and probably very buggy, and DEFINITELY unsupported) version of GnuCash. This error message means that the application is trying to call into a function that XP doesn't implement or support, which is not surprising since XP is almost 20 years old. Sorry, but you're into unsupported territory by trying to run on XP. Even Win7 has already expired but we do still support that, barely. Good Luck, > Kind Regards > Dr. Andrew Ruddle > UK > 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] Debit & Credit headings
Nope. Most likely they are wrong in your mind because you learned them from bank and CC statements, which are *backwards* to you. A Bank account is an Asset to you, but to your bank it's a Liability! So Debits and Credits are backwards between your view and the Bank's view. Please go read the Tutorial and Guide which explains this. -derek On Wed, April 8, 2020 8:44 am, Robert Masding wrote: > They seem to be the wrong way round? Have I done something wrong in the > setup? > > > > *Rob* > > *Robert Masding* > > > > *+44 (0)7707 985 379 +44(0)1392 791 428* > > *Flat 25, Norwood house, Pennsylvania Road, Exeter, EX4 6TR. UK.* > ___ > 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.
[GNC] [MAINT] Unplaned network outage yesterday, April 2, 2020
HI, There was a fiber break in my neighborhood yesterday which took out my network (and others) for multiple hours. It was eventually repaired and everything came back. Not much I could do about it. I called AT&T within 10 minutes to work on getting it repaired, but there was a truck at the site quickly and unrelated to my technician call. Once they repaired the line everything came back and mail started flowing again. Sorry for any inconvenience. -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] Multiple copies of gnucash-user messages from the list
>> >> >> Hi, >> >> >> >> Having some difficulty with my subscription. Looks like I subscribed >> to the list before I became a registered member. I'm getting an >> "original" mailing list message, and a copy that reads "[via GnuCash]" >> next to the author's name. Is there a way to unsubscribe from the [via >> GnuCash] list without unsubscribing completely from the list? Thanks. > > ___ > 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. > -- 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] Fastest ways to enter my transactions into GnuCash ?
Hi, On Fri, February 28, 2020 5:19 am, Long wrote: > Hello, > > I have used GnuCash for few month now, and this is an amazing software. > But > sometimes, i need to enter large amount of transactions into GnuCash. So i > really want to hear some idea from who have experienced with this problem. > > Thank you for spending your time to help me, help GnuCash's users. It depends on if you already have a digital record of the transactions or not. If you do (e.g. a QIF, OFX, ...) then you can import them in, with the caveats that if the bank made a mistake you will never notice it. Otherwise, in my experience the best way to enter transactions is do them as they come in. Entering a few transactions at a time is relatively quick. I tend to do them one account at a time (e.g., put all my Amex transactions together, then all my Visa transactions, etc). There are also many keyboard shortcuts you can use to speed up entry. E.g., if you want to enter Expenses:Auto:Fuel you can literally type: e x : a : f and it will autofill for you. Leverage autofill to help. In general you should never need to use the mouse to enter transactions (once you have the correct account register opened). Hope this helps! Happy GnuCashing. > 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] Is there GnuCash portable ?
There was at one point but it was a third party spin, not built by the Gnucash team. -derek Sent using my mobile device. Please excuse any typos. On February 22, 2020 11:17:51 PM Long wrote: Hello guys, is there GnuCash portable ? No installed required and can run on usb stick ? -- 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] Precision in exchange rate conversion
Paul Abraham writes: > Yes, they're both standard registers (both bank current accounts in fact). Then IMHO this is a bug. That setting should not affect the Rate Column. Please file a bug in Bugzilla. Thanks! > Paul -derek > On 20/02/2020 16:06, Derek Atkins wrote: > > Hi, > > Are you doing this in a standard register or in a Stock/Mutual register? > In a stock/mutual register it has inputs for quantity, amount, and > price-per-unit. In this case, the quantity and amount are stored, and the > price-per-unit is computed. You can enter 2/3 and GnuCash will compute > the 3rd for you, so if we recommend entering in the two stored values. > > In the regular register, however, where you get an "exchange rate dialog", > that's not how it works. In that case it DOES store and use the exchange > rate. So if you have the rate "displayed" as a decimal then it can round > and cause this behavior. If it's stored as a fraction, then you wont have > that behavior. > > It USED to be the case that the "rate" column was hidden and always stored > as a fraction, so this wasn't an issue. I'm not sure when it changed. > > John's message reminded me of this change, but I was unaware that it > affected the rate column (which, IMHO, it should not have since it is > supposed to be a non-visible column in the standard register). > > -derek > > On Thu, February 20, 2020 1:53 pm, Paul Abraham wrote: > >No, sorry, that's not what I meant. I'm sure the fractional >representation, unhelpful though it is, is right*. > >It's the fact that if I set the display setting to decimal, gnucash >tramples on the input value for the converted amount - I enter > 11102.12 >and it changes it to 11102.08. This is what is not very clever - > the >programming here . Display settings shouldn't affect actual data, > and >especially not user entered data (and even more especially not > without >advising the user - it does this silently). > >* ... well, in a sense: The arithmetic is right. But that isn't how >exchange rates work - banks don't start from the original and > converted >values and calculate an absolutely precise ratio between the two. > The >exchange rate comes first. The original value is multiplied by the >exchange rate (which is a decimal value) and then round the result > to >form the converted value. Gnucash's fractional version is a > fiction. > >Regards > >Paul Abraham > >On 20/02/2020 01:01, John Ralls wrote: > >That's not mangling the data, it's presenting the exact value of >11102.12/1975.10, a number that isn't representable as a decimal >without rounding. > >As for the display being clever, of course it isn't, it's a > computer. > >But it you enter the two values 11102.12 and 1975.10 GnuCash > shouldn't >change them, it should just calculate the ratio and present that > as the >price, either exactly as 5 + 61331/98755 or as 5.621041972558352 >rounded to however many decimal places. When I test that, it's > exactly >what I get, see the attached screen shot. Note the exact exchange > rate >in the exchange rate box but the rounded decimal values to the > right of >it. > >Regards, > >John Ralls > > On Feb 19, 2020, at 12:12 PM, Paul Abraham <[1]p...@acasa.org.uk> > wrote: > Hmm. That seems to work, but it certainly isn't what I want. The >exchange rate is now shown as "5 + 61331/98755" which is less > than >helpful - it most certainly is not how real world exchange > rates > are >quoted, and it makes comparison almost impossible! >Why does the display option mangle the data? That isn't very > clever. I >think I'll just stick in a fudge factor as a separate split to > correct >the total though it's a long way from ideal. >Thanks very much for the answer, though. I can stop chasing > moonbeams
Re: [GNC] Precision in exchange rate conversion
Hi, Are you doing this in a standard register or in a Stock/Mutual register? In a stock/mutual register it has inputs for quantity, amount, and price-per-unit. In this case, the quantity and amount are stored, and the price-per-unit is computed. You can enter 2/3 and GnuCash will compute the 3rd for you, so if we recommend entering in the two stored values. In the regular register, however, where you get an "exchange rate dialog", that's not how it works. In that case it DOES store and use the exchange rate. So if you have the rate "displayed" as a decimal then it can round and cause this behavior. If it's stored as a fraction, then you wont have that behavior. It USED to be the case that the "rate" column was hidden and always stored as a fraction, so this wasn't an issue. I'm not sure when it changed. John's message reminded me of this change, but I was unaware that it affected the rate column (which, IMHO, it should not have since it is supposed to be a non-visible column in the standard register). -derek On Thu, February 20, 2020 1:53 pm, Paul Abraham wrote: >No, sorry, that's not what I meant. I'm sure the fractional >representation, unhelpful though it is, is right*. > >It's the fact that if I set the display setting to decimal, gnucash >tramples on the input value for the converted amount - I enter 11102.12 >and it changes it to 11102.08. This is what is not very clever - the >programming here . Display settings shouldn't affect actual data, and >especially not user entered data (and even more especially not without >advising the user - it does this silently). > >* ... well, in a sense: The arithmetic is right. But that isn't how >exchange rates work - banks don't start from the original and converted >values and calculate an absolutely precise ratio between the two. The >exchange rate comes first. The original value is multiplied by the >exchange rate (which is a decimal value) and then round the result to >form the converted value. Gnucash's fractional version is a fiction. > >Regards > >Paul Abraham > >On 20/02/2020 01:01, John Ralls wrote: > >That's not mangling the data, it's presenting the exact value of >11102.12/1975.10, a number that isn't representable as a decimal >without rounding. > >As for the display being clever, of course it isn't, it's a computer. > >But it you enter the two values 11102.12 and 1975.10 GnuCash shouldn't >change them, it should just calculate the ratio and present that as the >price, either exactly as 5 + 61331/98755 or as 5.621041972558352 >rounded to however many decimal places. When I test that, it's exactly >what I get, see the attached screen shot. Note the exact exchange rate >in the exchange rate box but the rounded decimal values to the right of >it. > >Regards, > >John Ralls > > On Feb 19, 2020, at 12:12 PM, Paul Abraham <[1]p...@acasa.org.uk> > wrote: > Hmm. That seems to work, but it certainly isn't what I want. The >exchange rate is now shown as "5 + 61331/98755" which is less than >helpful - it most certainly is not how real world exchange rates > are >quoted, and it makes comparison almost impossible! >Why does the display option mangle the data? That isn't very > clever. I >think I'll just stick in a fudge factor as a separate split to > correct >the total though it's a long way from ideal. >Thanks very much for the answer, though. I can stop chasing > moonbeams >now ;-) > >[cid:part2.62ACF325.60F042A3@acasa.org.uk] > > References > >1. mailto:p...@acasa.org.uk > ___ > 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] Precision in exchange rate conversion
Hi, Paul Abraham writes: >I have real world transaction that involves a transfer from a GBP to a >BRL account but cannot get it to accept either the correct value in BRL >or the actual exchange rate. It insists on truncating the rate to 3 >decimal places (or 4 sig figs?) and adjusting the amount to match, even >though the "Transfer Funds" window suggests it's working to 6 DPs - . >How do I fix this? Details are: >OS: 4.19.102-1-MANJARO >Gnucash version: Version: 3.8 (Build ID: 3.8b+(2019-12-29)) - the >latest in the Manjaro repository. >Amount in GBP: 1975.10 >Amount in BRL: 11102.12 >Exchange Rate: 5.62104 >Gnucash forces exchange rate to 5.621000 resulting in BRL value of >11,102.04 The exchange rate is computed; so ignore that and just enter the correct values for GBP and BRL and ignore what exchange it gnucash claims. >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] [GNC-dev] Fwd: Failed - import of QIF files from Quicken
Hi, Adrien Monteleone writes: > I seem to recall a development goal being to eliminate Scheme code > except for reports. > > This might be a good candidate for just re-writing this in C/C++ with > proper tests and verbose error output and/or logging. > > If someone with the skillset is interested of course. I started a re-write of the QIF importer in C a very very long time ago. That (failed) re-write has long-since been removed from the repo. It turns out that C is not very good at tokenizing and parsing strings. Funny that. I am sure that using std::string in C++ would make it a lot easier to reprogram, but honestly the existing QIF importer is fairly robust and fairly well tested (via time). The real downside of the current implementation is that it doesn't have a test suite where you can throw test-case QIF files at it and ensure you get a reasonable answer. Having said that, whether or not you can actually throw an error with the line number will depend deeply on where it fails. The way the process works is that it reads in the file (line by line) and tokenizes the data. At this point it would be relatively easy to output the line number. Then, after the file is tokenized, it actually goes through and parses the tokens for QIF correctness; most likely THIS is where the failure occurs, but at this point we don't have line numbers any more. So we COULD add a "see line number X" into the qif-file.scm (IIRC), but I doubt that's the stage of the process where the error happens. > Regards, > Adrien -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] Credit Card bill autopay
Hi, Viney Kumar writes: > I have one credit card which has billing cycle of 12th of every month. > Payment is to be done on 1st of every month or 2nd if that is holiday. > Payment is automatically deducted on 1st or 2nd (if 1st is holiday) > > Can I schedule transaction of CC bill Payment every month. Like it picks up > last balance of 12th of every month and Automatically schedules it for > payment from savings account on next 1st of every month. [snip] Your best option is to enter a post-dated transaction. I.e., on the 12th you manually enter the payment for the 1st or 2nd. There is no way to do this in an "Automatic" way because the SX system does not have the ability to look at the account balance as of a particular date. Another thing to keep in mind is that there may be a delay in processing a transaction. Sometimes a CC transaction doesn't hit my CC account for a day or two, so transactions close to the ending date may end up on either side, which I wont know until I see the statement. Also note that when you Reconcile the CC, it will (unless you turn it off) pop up a transfer dialog to enter a payment transaction, and the amount of that transaction is the closing balance of the reconcile. So this is another way to do it. 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] 2.6.15 to 3.4
Hi Doc! You will need to File -> Open the data files in ~/gnucash-data The migration probably did not include your preferences, which is where those lists of files are contained. -derek On Wed, February 12, 2020 2:19 pm, D. R. Evans wrote: > I just installed the current debian stable version (3.4) on a new machine, > and > copied over my ~.gnucash files from an older debian machine running > gnucash > 2.6.15. > > On startup, I got a message about the account files that were in > ~/.gnucash > being moved into the .local hiearchy. > > OK, but now how do I actually see all the accounts and data that I could > see > on the old machine in 2.6.15? None of the old accounts are appearing on > the > initial gnucash screen. > > (If it matters, the actual log files and account data were in a directory > called ~/gnucash-data; a copy of that is also on the new machine.) > > Doc > > -- > Web: http://enginehousebooks.com/drevans > > ___ > 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] GNUCash XML format compatibility
Colin Law writes: > On Mon, 10 Feb 2020 at 15:21, Wirawan Purwanto wrote: >> >> Hi David, thanks for clarification. For every major release (either >> 2.x or 3.x series), is there a guarantee for file format >> compatibility? > > Upwards, yes I believe so. Any migration necessary would be handled > by gnucash itself. There is no guarantee that a 3.x file will work in > 2.x though in practice it may be ok. First, note that we changed the numbering scheme between 2.x and 3.x. This means that 2.0, 2.2, 2.4, and 2.6 are all *major* releases, with minor releases denoted in the third number. Whereas 3.x is the major release and 3.0, 3.1, etc. are all the minor releases. We try to guarantee one-major-release backwards. So e.g. 3.x will be readable by 2.6.21 (the latest 2.6 release), but we don't guarantee anything with older major releases (e.g. 2.4.x). We also try hard to guarantee forward release compatibility, so 3.x should be able to read 2.6, 2.4, and probably even 2.2 (or older) data files. Note, however, that sometimes there are new features that by definition will be incompatible. We also try to make those features optional, so you only make your data file unreadable by older version if you use those new-in-X features. Hope this helps, > 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] [MAINT] Unexpected reboot/downtime of code (gnucash server)
Hi, TL;DR: The Ovirt VM system rebooted last night but the VMs didn't come back up. They are now back up and running normally (and the cause of the lack of restart has been corrected). Long Version: Some of you may have noticed that code was unavailable for the past 12 hours. Apparently the ovirt host rebooted last night around 10:45pm local time and the script to start the VMs on reboot didn't work. I've spent the past 3 hours debugging and determined the problem with the script was that the ovirt engine reports invalid state immediately upon reboot. Specifically, it reports that the storage domains are "up" even when they are not. It corrects itself shortly, but the startup script sees the storage as "up" and then tries to start the VMs (which fail to start). This has been fixed by adding a short delay between when the engine reports as "up" and when the script starts testing for the storage domains. I know this works because it ran from a clean restart of the ovirt host system. Still of concern is why the machine rebooted last night in the first place. I do not have an answer for that, and the logs don't really show anything of substance. I plan to continue to monitor the situation, and I will add some additional debugging in case it decides to reboot itself yet again. But at least if it does, we know the VMs will come back! :) Sorry for the downtime. -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 Not Working
Hi, Alexandra Lucas via gnucash-user writes: > HI, > I'm having trouble getting gnucash to open on my Mac that has the > latest IOS - Catalina 10.15.3. > I click the icon and it bounces like it's going to open but never does > and just disappears. > Can you help? > Thank you! What version of GnuCash? > 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 Checking Transactions: Expense Acct Assignment Question.
Hi, Fran_3 via gnucash-user writes: > Will assigning the Expense Account during import conflict with later > creating a bill and then assigning a checking transaction as payment > for that bill? (Since the Expense Account is normally assigned during > creation of the bill... so this will be kind of backwards... I think) > I hope I made the issue and question clear. At least I gave it my best shot > :-) The short answer is "yes". If you import the check into Bank and always assign the "correct" Expense account, then you will bypass the Bill completely. For Vendors that have a Bill you *MUST* assign the payment to AP, not the appropriate Expense. > 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] Duplicate emails in GnuCash Digests
I remember the duplicate email reception thread, but that didn't talk about the archives and seemed to be an issue with their mailer agent not filtering out the list vs. direct message (which should have the same message IDs). In this case, the issue would be on code alone. I don't see how code would self-duplicate the inbound messages. When I get a bit more time I will go look at the logs and match them up to the digest entries to try to see what's up. My initial guess is that they are being sent to the list twice But I have no data or proof to back that up. -derek On Tue, February 4, 2020 2:49 pm, Geert Janssens wrote: > Derek, > > There was a thread on duplicate mails not so long ago, though I don't > think it was about Digests > and it may have been on gnucash-devel. > > I have noticed mail duplication starting with David T's responses > (sunfish...). I haven't noticed it > with John's replies and obviously not on my own replies. > > Geert > > Op dinsdag 4 februari 2020 20:11:35 CET schreef Derek Atkins: >> Hi Chris, >> This is the first I've heard of this issue. >> I will take a look at it, but I do not have time immediately to do so. >> Have you seen any pattern in the duplication? Certain people, or >> certain sources? Maybe someone who uses nabble or gmane? >> Thanks for reporting. >> -derek >> >> "Chris Good" writes: >> > Hi, >> > >> > For quite a while now (at least several months), there have duplicated >> > emails in the GnuCash digests. >> > For instance, in the email below message 3 is a duplicate of 2, and 6 >> is a >> > duplicate of 5. >> > >> > It doesn't seem to happen all the time but I often notice this for >> emails >> > from D, Geert and John Ralls, although John Ralls' message 4 here is >> not >> > duplicated. >> > >> > I'd really appreciate it if someone could fix this. >> > >> > Regards, >> > Chris Good >> > >> > -Original Message- >> > From: gnucash-user >> > >> > On Behalf Of gnucash-user-requ...@gnucash.org >> > Sent: Saturday, 1 February 2020 4:00 AM >> > To: gnucash-user@gnucash.org >> > Subject: gnucash-user Digest, Vol 202, Issue 74 >> > >> > Send gnucash-user mailing list submissions to >> > >> >gnucash-user@gnucash.org >> > >> > To subscribe or unsubscribe via the World Wide Web, visit >> > >> >https://lists.gnucash.org/mailman/listinfo/gnucash-user >> > >> > or, via email, send a message with subject or body 'help' to >> > >> >gnucash-user-requ...@gnucash.org >> > >> > You can reach the person managing the list at >> > >> >gnucash-user-ow...@gnucash.org >> > >> > When replying, please edit your Subject line so it is more specific >> than >> > "Re: Contents of gnucash-user digest..." >> > >> > Today's Topics: >> >1. Access the Company Name in python (gc...@nailedtotheperch.com) >> >2. Re: Edit number of recently opened books (D) >> >3. Re: Edit number of recently opened books (D) >> >4. Re: Edit number of recently opened books (John Ralls) >> >5. Re: Edit number of recently opened books (D) >> >6. Re: Edit number of recently opened books (D) >> > >> > -- >> > >> > Message: 1 >> > Date: Thu, 30 Jan 2020 17:41:59 -0400 >> > From: gc...@nailedtotheperch.com >> > To: gnucash-user@gnucash.org >> > Subject: [GNC] Access the Company Name in python >> > Message-ID: <76b8557c7e16096b559c3066b5dd7...@nailedtotheperch.com> >> > Content-Type: text/plain; charset=US-ASCII; format=flowed >> > >> > What is the most straight forward way to access (read) the company >> name in >> > python. I can see it the XML, but that seems a little fragile. I'm >> talking >> > about the company name entered in File->Properties->Book >> > Option->Business not a Vendor or Customer Name. >> > >> > Could somebody give me a quick pointer to the module and method. >> > >> > >> > Thanks >> > >> > >> > >> > >> > >> > >> > -- >> > >> > Message: 2 >> > Date: Fri, 31 Jan 2020 08:47:07 +0530 >> > From:
Re: [GNC] Duplicate emails in GnuCash Digests
> 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. > > > -- > > Message: 6 > Date: Fri, 31 Jan 2020 13:10:23 +0530 > From: D > To: John Ralls > Cc: Greg W ,gnucash-user@gnucash.org > Subject: Re: [GNC] Edit number of recently opened books > Message-ID: > Content-Type: text/plain; charset=UTF-8 > > Ok. Thanks. > > On Jan 31, 2020, 08:53, at 08:53, John Ralls wrote: >> >>GnuCash pays no attention at all to that setting. >> >>Regards, >>John Ralls >> >> >>> On Jan 30, 2020, at 7:17 PM, D via gnucash-user >> wrote: >>> >>> Have you tried this: >>> >>> >>https://www.howtogeek.com/231700/how-to-change-the-number-of-recent-ite >>ms-in-os-x/ >>> >>> On Jan 31, 2020, 01:43, at 01:43, Greg W >>wrote: >>>> I've tried searching around and haven't found anywhere that seems to >>>> suggest how to edit then number of recently opened books that show >>up >>>> in >>>> the File menu on OSX: >>>> >>>> [image: Menubar.png] >>>> Can I change that 4 to a 6 or more somehow? >>>> >>>> Thanks, >>>> Greg >>>> >>>> >>>> >>--- >>- >>>> >>>> _______ >>>> 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. > > > -- > > Subject: Digest Footer > > ___ > > 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. > > > -- > > End of gnucash-user Digest, Vol 202, Issue 74 > * > > ___ > 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] [GNC-dev] [MAINT] Server Downtime to relocate hardware, Feb 1, 2020
Hi, I've got my main servers racked, network transitioned, and VM host upgraded. I turned the VM's back on around 23:30 local time. As you can see from this message, code is now passing mail again. I know gncbot is also sitting in IRC. So I'm going to call the server back up and running. If you see any issues please let me know and I'll check it in the morning. I do still have some work to do; the VMs didn't come up on their own and needed some manual intervention. I know why, but I'm going to have to track down how to work around the new issue. :( Unfortunately testing this might require more downtime to ensure it's working. I'll try to schedule that when I can. For now, I'm going to try to get some rest. Happy GnuCashing! -derek On Sat, February 1, 2020 4:58 pm, Derek Atkins wrote: > Hi, > This maintenance is about to begin. > -derek > > On Fri, January 31, 2020 9:52 pm, Derek Atkins wrote: >> Hi, >> Just a reminder that this is scheduled for tomorrow. >> I am expecting the work to start around 4pm US/ET (2100 UTC). >> I will send one more email before I start to turn down servers, and will >> be on >> IRC as much as I can during the work. >> Thanks, >> -derek >> >> "Derek Atkins" writes: >> >>> Hi, >>> >>> TL;DR: I plan to move the hardware that runs code.gnucash.org on the >>> afternoon/evening of February 1, 2020, which will involve some >>> significant >>> downtime as the machine is physically moved and then racked. Expect >>> anywhere from 4-12 hours of downtime for email, wiki, archives, gncbot, >>> and git master. Exact time TBD; real-time updates will go to #gnucash >>> on >>> IRC. >>> >>> >>> Long version: On the afternoon of February 1, 2020 I plan to relocate >>> my >>> hardware to its more permanent location. This will involve significant >>> downtime because I have toL >>> 1) shut down the systems >>> 2) reconfigure the local network at the old location >>> 3) reroute the IPv4 tunnel to the new location (which requires >>> coordination with another entity) >>> 4) physically move the machines from the old location to new location >>> 5) install the new machines in the racks at the new location >>> 6) reconfigure the local network for the tunnel >>> 7) turn on an test >>> >>> I expect this whole process will take at least 4 hours, but probably >>> much >>> longer depending on many variables. However, once it is complete the >>> system will be (back) on a 1Gb fiber with a good-sized UPS for >>> short-to-medium length power outages (which we've had none in the past >>> 2 >>> years). >>> >>> I will send an email about 30 minutes before I begin, and again after >>> the >>> project is complete. I'll remain on IRC in the interim for more >>> real-time >>> updates. >>> >>> During this outage, most gnucash services will be unavailable. This >>> includes: email lists and archives, wiki, git master, IRC gncbot, >>> build >>> services, etc. The web site, www.gnucash.org, will remain available >>> and >>> I >>> will post a news article about the maintenance. >>> >>> DEVS: Please let me know ASAP if there are specific time frames that >>> would adversely affect you. I do have some flexibility in doing this >>> work. >>> >>> Please let me know if you have any questions, comments, or concerns >>> prior >>> to this work. >>> >>> 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 > > -- 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] [GNC-dev] [MAINT] Server Downtime to relocate hardware, Feb 1, 2020
Hi, This maintenance is about to begin. -derek On Fri, January 31, 2020 9:52 pm, Derek Atkins wrote: > Hi, > Just a reminder that this is scheduled for tomorrow. > I am expecting the work to start around 4pm US/ET (2100 UTC). > I will send one more email before I start to turn down servers, and will > be on > IRC as much as I can during the work. > Thanks, > -derek > > "Derek Atkins" writes: > >> Hi, >> >> TL;DR: I plan to move the hardware that runs code.gnucash.org on the >> afternoon/evening of February 1, 2020, which will involve some >> significant >> downtime as the machine is physically moved and then racked. Expect >> anywhere from 4-12 hours of downtime for email, wiki, archives, gncbot, >> and git master. Exact time TBD; real-time updates will go to #gnucash >> on >> IRC. >> >> >> Long version: On the afternoon of February 1, 2020 I plan to relocate >> my >> hardware to its more permanent location. This will involve significant >> downtime because I have toL >> 1) shut down the systems >> 2) reconfigure the local network at the old location >> 3) reroute the IPv4 tunnel to the new location (which requires >> coordination with another entity) >> 4) physically move the machines from the old location to new location >> 5) install the new machines in the racks at the new location >> 6) reconfigure the local network for the tunnel >> 7) turn on an test >> >> I expect this whole process will take at least 4 hours, but probably >> much >> longer depending on many variables. However, once it is complete the >> system will be (back) on a 1Gb fiber with a good-sized UPS for >> short-to-medium length power outages (which we've had none in the past 2 >> years). >> >> I will send an email about 30 minutes before I begin, and again after >> the >> project is complete. I'll remain on IRC in the interim for more >> real-time >> updates. >> >> During this outage, most gnucash services will be unavailable. This >> includes: email lists and archives, wiki, git master, IRC gncbot, build >> services, etc. The web site, www.gnucash.org, will remain available and >> I >> will post a news article about the maintenance. >> >> DEVS: Please let me know ASAP if there are specific time frames that >> would adversely affect you. I do have some flexibility in doing this >> work. >> >> Please let me know if you have any questions, comments, or concerns >> prior >> to this work. >> >> 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] [GNC-dev] [MAINT] Server Downtime to relocate hardware, Feb 1, 2020
Hi, Just a reminder that this is scheduled for tomorrow. I am expecting the work to start around 4pm US/ET (2100 UTC). I will send one more email before I start to turn down servers, and will be on IRC as much as I can during the work. Thanks, -derek "Derek Atkins" writes: > Hi, > > TL;DR: I plan to move the hardware that runs code.gnucash.org on the > afternoon/evening of February 1, 2020, which will involve some significant > downtime as the machine is physically moved and then racked. Expect > anywhere from 4-12 hours of downtime for email, wiki, archives, gncbot, > and git master. Exact time TBD; real-time updates will go to #gnucash on > IRC. > > > Long version: On the afternoon of February 1, 2020 I plan to relocate my > hardware to its more permanent location. This will involve significant > downtime because I have toL > 1) shut down the systems > 2) reconfigure the local network at the old location > 3) reroute the IPv4 tunnel to the new location (which requires > coordination with another entity) > 4) physically move the machines from the old location to new location > 5) install the new machines in the racks at the new location > 6) reconfigure the local network for the tunnel > 7) turn on an test > > I expect this whole process will take at least 4 hours, but probably much > longer depending on many variables. However, once it is complete the > system will be (back) on a 1Gb fiber with a good-sized UPS for > short-to-medium length power outages (which we've had none in the past 2 > years). > > I will send an email about 30 minutes before I begin, and again after the > project is complete. I'll remain on IRC in the interim for more real-time > updates. > > During this outage, most gnucash services will be unavailable. This > includes: email lists and archives, wiki, git master, IRC gncbot, build > services, etc. The web site, www.gnucash.org, will remain available and I > will post a news article about the maintenance. > > DEVS: Please let me know ASAP if there are specific time frames that > would adversely affect you. I do have some flexibility in doing this > work. > > Please let me know if you have any questions, comments, or concerns prior > to this work. > > 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.
Re: [GNC] Unposting an Invoice - Reset Tax Tables Prompt
Hi, Keith Fetterman writes: > Hi, > > I am a newbie with GnuCash invoicing. When I unpost an invoice, I > receive a prompt that says “Reset Tax Tables to Present Values?”. > What happens when I answer either Yes or No? The Tax Tables are Copy-On-Write objects. When you post an Invoice gnucash makes a snapshot copy of that tax table so that if, down the road, you modify the entries it wont affect the results (because invoice tax values are always computed and not stored). Imagine if you went to go reprint an invoice from 2 years ago and it uses today's taxes instead of the taxes from 2 years ago!! So when you unpost the invoice, it asks whether to reset the tax tables. In other words, do you keep the taxes as they were when you first posted the invoice, or should you update them to the current values. If your taxes haven't changed, then the answer doesn't matter. But if you HAVE edited the tax tables, then the answer DOES matter based on why you're unposting. > I searched the GnuCash documentation and searched the mailing list, > but I wasn’t able to find an answers. > > I have always answered Yes, but I would like to know what happens when > I answer Yes or No. Hope the above explanation helps. > Thanks > Keith > 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 Downtime to relocate hardware, Feb 1, 2020
Hi, TL;DR: I plan to move the hardware that runs code.gnucash.org on the afternoon/evening of February 1, 2020, which will involve some significant downtime as the machine is physically moved and then racked. Expect anywhere from 4-12 hours of downtime for email, wiki, archives, gncbot, and git master. Exact time TBD; real-time updates will go to #gnucash on IRC. Long version: On the afternoon of February 1, 2020 I plan to relocate my hardware to its more permanent location. This will involve significant downtime because I have toL 1) shut down the systems 2) reconfigure the local network at the old location 3) reroute the IPv4 tunnel to the new location (which requires coordination with another entity) 4) physically move the machines from the old location to new location 5) install the new machines in the racks at the new location 6) reconfigure the local network for the tunnel 7) turn on an test I expect this whole process will take at least 4 hours, but probably much longer depending on many variables. However, once it is complete the system will be (back) on a 1Gb fiber with a good-sized UPS for short-to-medium length power outages (which we've had none in the past 2 years). I will send an email about 30 minutes before I begin, and again after the project is complete. I'll remain on IRC in the interim for more real-time updates. During this outage, most gnucash services will be unavailable. This includes: email lists and archives, wiki, git master, IRC gncbot, build services, etc. The web site, www.gnucash.org, will remain available and I will post a news article about the maintenance. DEVS: Please let me know ASAP if there are specific time frames that would adversely affect you. I do have some flexibility in doing this work. Please let me know if you have any questions, comments, or concerns prior to this work. 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.
Re: [GNC] FW: Multiple copies of gnucash-user messages from the list
Hi, If you are getting duplicates, then it is because you are in the CC. Like this message, you are in the CC so you will get one copy directly and one through the list server. The 'via GnuCash' is most likely due to people with domains with DMARC rules that would prevent verification unless the >From address is munged. Still, your mailer should be able to notice it's the same message (Duplicate Message-ID header) and only show you one. If you are getting *MORE* than two copies of messages, please let me know! Maybe send me the full headers of the duplicates. Thanks, -derek On Tue, January 21, 2020 11:03 am, Alan wrote: > Hey, is anyone making any progress with this? Getting hundreds of dupe > messages > from this list, filling up my inbox. > > > > Sent: Wednesday, January 01, 2020 11:38 PM > To: 'gnucash-user-ow...@gnucash.org' > Subject: Multiple copies of gnucash-user messages from the list > > > > Hi, > > > > Having some difficulty with my subscription. Looks like I subscribed to > the list > before I became a registered member. I'm getting an "original" mailing > list > message, and a copy that reads "[via GnuCash]" next to the author's name. > Is > there a way to unsubscribe from the [via GnuCash] list without > unsubscribing > completely from the list? Thanks. > > ___ > 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] (no subject)
It's music to my ears! -derek Sent using my mobile device. Please excuse any typos. On January 10, 2020 12:41:31 PM D via gnucash-user wrote: I like your thinking! On January 10, 2020, at 10:26 PM, John Ralls wrote: A# ? On Jan 8, 2020, at 11:42 PM, D via gnucash-user wrote: Bb ___ 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] Tracking designated balances in the total checking account balance?
Hi. Use Subaccounts for each fund. When you reconcile, ensure you check the Include Subaccounts checkbox. -derek Sent using my mobile device. Please excuse any typos. On January 9, 2020 8:05:47 AM Nate Bargmann wrote: The issue I am wrestling with is how to deal with what I will call designated funds that our organization tracks internally but are just part of the one checking account. To explain further. Say there is a total checking balance of $1000.00. Then say there are two standing funds one with $200.00 and the other with $400.00. Conceptually I have: Fund A $200.00 Fund B $400.00 Undesignated$400.00 Total (as the bank statement shows) $1000.00 As deposits and withdrawals are made, in order to keep sync with the bank statement I should just work with the running account total at all times. Initially, I thought I should create and transfer funds to additional Assets accounts, but this doesn't work, as I see it, especially for reconciliations as the checking balance gets reduced accordingly. If I don't track the bank account closely, I'll go insane! I guess the standing funds will need to be tracked outside of GNU Cash, perhaps in a spreadsheet. Their balances will change throughout the year but not so often as to make this method unmanageable. The outgoing Treasurer used Quicken/Quick Books (whichever, I don't know) and he gave me several .qdf-backup files which are naturally not usable by GNU Cash. I'm not sure if he understood my request for an export to .qif. I'm loathe to buy a Windows 10 computer just for this so I'm starting from scratch to get going as quickly as possible and then may try to help him generate a .qif file sometime down the road. I'm not sure how he tracked the standing/designated balances. - Nate -- "The optimist proclaims that we live in the best of all possible worlds. The pessimist fears this is true." Web: https://www.n0nb.us Projects: https://github.com/N0NB GPG fingerprint: 82D6 4F6B 0E67 CD41 F689 BBA6 FB2C 5130 D55A 8819 -- ___ 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.