RE: Issues with Jobs and Purchase Orders.
I agree Dave, and getting that done in 100 hours I think is optimistic. Realistically I think it is probably well beyond the scope of “free” software. If the developers ever considered offering a “Pro” version of GnuCash, on a pay per license basis, that might work. NCH gets $70 a copy for theirs, and I think at its core, GnuCash is a better product, But I’m not really familiar with Gnu’s philosophy. Bruce From: drkir...@gmail.com [mailto:drkir...@gmail.com] On Behalf Of Dr. David Kirkby (Kirkby Microwave Ltd) Sent: Monday, May 29, 2017 2:44 PM To: Bruce Danielson Cc: Adrien Monteleone; GNU Cash User Subject: Re: Issues with Jobs and Purchase Orders. On 29 May 2017 at 16:53, Bruce Danielson wrote: I see that clearly Dave as an excellent addition – and quotations are related to purchase orders as invoices are to bills and customers to vendors. Thanks for that bit of insight. Bruce I doubt quotations and/or purchase orders will be added any time soon - if at all. I did offer one of the GnuCash developers a modest sum ($100) if he could add support for quotations, as it would benefit my business. He did not do jobs for money, but someone else who would, had no time to do the job. But the developer estimated adding support for quotations would be 100 hours of work, and I told the amount of money a software developer earned in Silicon Valley was about $500/hour. A simple bit of maths indicates that to pay for this to be developed on a commercial basis ($50,000) , which was far in excess of the $100 I was offering. The developers have a roadmap, https://wiki.gnucash.org/wiki/Roadmap which seems primarily on cleaning up the code. Hence unless there was a substantial amount of money raised, I don't think quotations will be added any time soon, and I'm lead to believe purchase orders would be similar code. If someone could find a GnuCash developer willing to add purchase orders / quotations for a fixed feed, and there was crowdfunding to get it going, conceivably these features could be added. But I don't think this is likely to happen to be honest. Dave ___ gnucash-user mailing list gnucash-user@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: About time in transaction
> On May 28, 2017, at 10:00 AM, Kurt Tsang wrote: > > I'd like to know is it possible input the time in transactions? It's really > important for me to track the history.. > For example "2017-04-01 08:00" paid to McDonal for Food:Breadfast. > > And is it possible have a web version? > Thanks a lot > No to both, sorry. Regards, John Ralls ___ gnucash-user mailing list gnucash-user@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
About time in transaction
I'd like to know is it possible input the time in transactions? It's really important for me to track the history.. For example "2017-04-01 08:00" paid to McDonal for Food:Breadfast. And is it possible have a web version? Thanks a lot iPadから送信 クルト・ソン ___ gnucash-user mailing list gnucash-user@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Newbie account matching
Hi, I had just switched to gnucash from many years of quicken. So, far it works fine. The only problem is account matching. I am not looking into something fancy - the vast majority of our expenses is in less than 10 stores and less than 10 gas stations, everything else I can classify manually. In addition to that there are quirks/bugs per reporting company. I suppose I can easily write a script that will perform proper matching. However, I am using it on win10 and there are no python bindings. Hence I have to write a standalone pre-processor that will read downloaded file, fix the quirks and add explicit account-id string. My current plan is to generate .csv file and then import it. Should I target .qif instead? What strings should I use as account-ids in .csv file? Say if want something to be matched to 'Expenses:Auto:Gas' what string should I use? Should I add any configuration for this to happen? Thank you, Aleksey ___ gnucash-user mailing list gnucash-user@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: Issues with Jobs and Purchase Orders.
On 29 May 2017 at 16:53, Bruce Danielson wrote: > I see that clearly Dave as an excellent addition – and quotations are > related to purchase orders as invoices are to bills and customers to > vendors. > > > > Thanks for that bit of insight. > > > > Bruce > I doubt quotations and/or purchase orders will be added any time soon - if at all. I did offer one of the GnuCash developers a modest sum ($100) if he could add support for quotations, as it would benefit my business. He did not do jobs for money, but someone else who would, had no time to do the job. But the developer estimated adding support for quotations would be 100 hours of work, and I told the amount of money a software developer earned in Silicon Valley was about $500/hour. A simple bit of maths indicates that to pay for this to be developed on a commercial basis ($50,000) , which was far in excess of the $100 I was offering. The developers have a roadmap, https://wiki.gnucash.org/wiki/Roadmap which seems primarily on cleaning up the code. Hence unless there was a substantial amount of money raised, I don't think quotations will be added any time soon, and I'm lead to believe purchase orders would be similar code. *If *someone could find a GnuCash developer willing to add purchase orders / quotations for a fixed feed, and there was crowdfunding to get it going, *conceivably* these features could be added. But I don't think this is likely to happen to be honest. Dave ___ gnucash-user mailing list gnucash-user@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Changing the default field in search
Whenever I use Search, I am usually picking "Value" as the field I am searching for. Is there a way to make Value the default when I choose Search? Andy Pastuszak ___ gnucash-user mailing list gnucash-user@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: Add columns to the Generic import transaction matcher
On Sunday, May 7, 2017 11:28:09 AM EDT reaneyp wrote: > Is there a way that I can add columns to the import matcher? When i import > OFX files from my bank, I'm doing it for several accounts at once. The > dialog box that pops up has a list of all the transactions and one of the > columns is the 'destination' account (for example "Expenses:Auto:Gas"), but > the 'source' account is not there. This makes transfers between accounts > difficult to figure out. I'm actually surprised that it can't figure that > out by itself. Historically (I wrote quite a bit of the initial UI code for the importer and the OFX import code way back), the reason the UX was done this way is that in most cases the transactions involve an expense or revenue account and the additional column would be wasted space. The times it would be useful are, as you pointed out, when you have transfers between two accounts in the same file. It turned out that there were more edge cases than I initially anticipated, and just never got around to writing the code to handle them. Low hanging fruits: - Adding a column should be really trivial as a workaround for now (no logic changes, just boilerplate). - Proper handling of OFX transfers is off course ideal. BUT: - Keep in mind that this assumes that the OFX account numbers match between the accounts. One of the caveats I ran into is that this assumption wasn't always true. - You have to handle the annoying case where this is the first time gnucash sees the second account. -- Benoit Grégoire, ing., PMP, PSM III ___ gnucash-user mailing list gnucash-user@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: Locale issues on OSX
> On May 29, 2017, at 10:09 AM, Axel Essbaum wrote: > > > Can anyone tell me how the language for the date picker is determined in > GnuCash? > > Thanks!! > > - Axel > > -- > Axel Essbaum > a...@essbaum.com > > > >> On 28 May 2017, at 18:56, Axel Essbaum wrote: >> >> >> Hello all, >> >> I just recently upgraded from GC 2.6.3 to GC 2.6.16 and am having locale >> issues under OSX 10.11. >> >> In System Preferences > Language and Region I have Language set to English >> (English at the top of the list) and Region set to Switzerland. Under >> Advanced I have Number separators set to ' with Decimal as . Currency is >> Swiss Franc (CHF). This worked ok in 2.6.3 but in 2.6.16 I am getting >> Number separator . with Decimal as , >> >> I could live with this, except that the calendar (what appears when I click >> on a date) is in French (was in English in 2.6.3)! >> >> Changing the setting for GnuCash > Preferences > Accounts > Default Currency >> has no effect. >> >> Anyone know whatI can do to fix this? >> It's a wrapper around GtkCalendar which uses strftime, which in turn uses LC_TIME. The catch in your case is that it requires a locale defined in /usr/share/locale, and en_CH isn't one of them, so GnuCash goes looking for something that will work, starting with the country. It apparently finds fr_CH first. You can try setting Region to United States and in the advanced sheet change the currency to CHF, but that will probably flip the separators so that thousands is , and decimal is . in places where the number is formatted with LC_NUMERIC instead of LC_MONETARY. Incidentally, Apple's Swiss POSIX locales that has the separator as . instead of ' in LC_MONETARY; they have ' ' (space) as the separator in LC_NUMERIC. Regards, John Ralls ___ gnucash-user mailing list gnucash-user@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: Locale issues on OSX
Can anyone tell me how the language for the date picker is determined in GnuCash? Thanks!! - Axel -- Axel Essbaum a...@essbaum.com > On 28 May 2017, at 18:56, Axel Essbaum wrote: > > > Hello all, > > I just recently upgraded from GC 2.6.3 to GC 2.6.16 and am having locale > issues under OSX 10.11. > > In System Preferences > Language and Region I have Language set to English > (English at the top of the list) and Region set to Switzerland. Under > Advanced I have Number separators set to ' with Decimal as . Currency is > Swiss Franc (CHF). This worked ok in 2.6.3 but in 2.6.16 I am getting Number > separator . with Decimal as , > > I could live with this, except that the calendar (what appears when I click > on a date) is in French (was in English in 2.6.3)! > > Changing the setting for GnuCash > Preferences > Accounts > Default Currency > has no effect. > > Anyone know whatI can do to fix this? > > Thanks!! > > - Axel > > -- > Axel Essbaum > a...@essbaum.com > > > > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > https://lists.gnucash.org/mailman/listinfo/gnucash-user > - > 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 https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
RE: Issues with Jobs and Purchase Orders.
I see that clearly Dave as an excellent addition – and quotations are related to purchase orders as invoices are to bills and customers to vendors. Thanks for that bit of insight. Bruce From: drkir...@gmail.com [mailto:drkir...@gmail.com] On Behalf Of Dr. David Kirkby (Kirkby Microwave Ltd) Sent: Monday, May 29, 2017 4:16 AM To: Bruce Danielson Cc: Adrien Monteleone; GNU Cash User Subject: Re: Issues with Jobs and Purchase Orders. On 28 May 2017 at 23:41, Bruce Danielson wrote: I don't know many businesses that don't use PO's so this would be a great feature to add. And yes vendors might make multiple shipments (and invoices) for a PO - sounds a little like a Job, yes? Personally I don't use purchase orders, but I know a lot of companies do. But I do know of someone who would not use GnuCash because of the lack of this feature. The feature I would like to see most is somewhat related, and that's the ability to generate a quotation, and turn that into an invoice if paid. Apparently such a feature is not on the roadmap. Dave ___ gnucash-user mailing list gnucash-user@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: Issues with Jobs and Purchase Orders.
On 28 May 2017 at 23:41, Bruce Danielson wrote: > > I don't know many businesses that don't use PO's so this would be a great > feature to add. And yes vendors might make multiple shipments (and > invoices) for a PO - sounds a little like a Job, yes? > Personally I don't use purchase orders, but I know a lot of companies do. But I do know of someone who would not use GnuCash because of the lack of this feature. The feature I would like to see most is somewhat related, and that's the ability to generate a quotation, and turn that into an invoice if paid. Apparently such a feature is not on the roadmap. Dave ___ gnucash-user mailing list gnucash-user@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.