Re: Gnucash connect to remote 1and1 database server

2017-08-02 Thread Colin Law
What sort of database is it (mysql or whatever)? Can you access it by command line utilities on the PC or a simple GUI app? If so which? Colin On 3 August 2017 at 07:14, Bindiya Maharjan wrote: > > > > Hi all , > > > > I am trying to connect to remote database server without any success. Do you

Re: Scheduled Transaction Help :(

2017-08-02 Thread Colin Law
Can you show us the contents of the template transaction tab? Colin On 3 August 2017 at 01:16, Steve wrote: > I'm running Windows 10, GnuCash Version 2.6.17. > > After using GnuCash for a number of years, I finally am getting around to > using the Scheduled Transaction feature. Previously I wou

Gnucash connect to remote 1and1 database server

2017-08-02 Thread Bindiya Maharjan
Hi all , I am trying to connect to remote database server without any success. Do you guys have any steps or guide for this. Appreciate your help. Thanks ___ gnucash-user mailing list gnucash-user@gnucash.org https://li

Re: Adding quantity to expenses

2017-08-02 Thread Christopher Lam
You can also abuse the Currency feature. Create account called Assets:Cheese (currency CHF sounds appropriate!). Amend its symbol to 'kg'. Transfer from USD $8 in Assets:Bank to 0.8kg in Assets:Cheese, and the commodity editor will pop up ($10 = 1kg). Eating cheese means transferring some kg fro

Re: Methods to Track Gift Cards and Similar Items

2017-08-02 Thread Paul W.
Thanks to all for your guidance, "other hands" methods, and comments. I see that I should use asset accounts as the primary type account to tract these stored-value items. I am a novice at double-entry accounting. I have been using GnuCash for several months to track some of my personal financ

Re: Adding quantity to expenses

2017-08-02 Thread prl
That's what I do for our car fuel purchases, with a note like: 436.9km@38.43l 8.80l/100km (27/30 mpg (US/Imp), for those who still measure things that way ;) ) Manually calculated, but in a standard format, so that if I wanted to extract data to look at things like like averages or trends, or

Re: Scheduled Transaction Help :(

2017-08-02 Thread Steve
I double checked the settings, and mine look correct. As I indicated, although the scheduled transaction SAYS in my screenshot the last occurrence was on 9/1/17, in fact no transaction for it was created on 9/1/17. I did try changing the time to 60 days as you suggested, and ran it, and a transact

Re: Scheduled Transaction Help :(

2017-08-02 Thread Dave H
Hi Steve, This is how I set mine up, I don't bother with the remind in advance as I'm already telling it to create the transaction and notify me when it does and I use Gnucash daily so I don't need a reminder. Your screenshot seems to indicate it thinks it's already created the transaction for 1

Scheduled Transaction Help :(

2017-08-02 Thread Steve
I'm running Windows 10, GnuCash Version 2.6.17. After using GnuCash for a number of years, I finally am getting around to using the Scheduled Transaction feature. Previously I would simply add the upcoming anticipated transactions to the account registry, and then when the date in question hit fo

Re: Adding quantity to expenses

2017-08-02 Thread storyjesse
I agree that the business bills feature might be overkill for what you are wanting to accomplish. Are you aware that you can perform simple calculations in debit/credit fields? If you enter a transaction like this: When you press tab y

Re: population

2017-08-02 Thread John Ralls
> On Aug 2, 2017, at 2:24 PM, Christine Maloney wrote: > > Yes the date and time are correct on the PC, I have windows 7 home premium. > And I got the latest I think Gnucash 2017. I wonder if there is a fix for > this. > > From: Dave H [mailto:hell...@gmail.com] > Sent: Wednesday, August 0

Re: New Report. Suitable for VAT/GST returns.

2017-08-02 Thread Christopher Lam
Report is refined to show multiple tax accounts. This will be useful for e.g. UKVAT normal and EC sales. Tax column names are copied from the Account names. Terminology changed from VAT/GST to generic 'tax' and TaxTables must use 'Input'/'Output' names. Disabled zero-amount cells. Technically it wi

Re: Missing invoice in Business->Customer->Find Invoice

2017-08-02 Thread Derek Atkins
Hi, First, this is a user question, not a developer question -- so should have been asked on gnucash-user. I've re-directed this there. Eric Wheeler writes: > Hello all, > > We have an invoice that cannot be found in the "Business->Customer->Find > Invoice" dialog, neither by invoice number

Re: population

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

Start-date in Estimate-budget-value dialog

2017-08-02 Thread Gour
Hello! I've asked in IRC and it's not clear to me what to put as the start date in the dialog concerning Estimating budget-values for the accounts based from the past history of transactions? For instance, if I have several years of history and want to create a budget for this 2017 year, along wi

RE: population

2017-08-02 Thread Christine Maloney via gnucash-user
Yes the date and time are correct on the PC, I have windows 7 home premium. And I got the latest I think Gnucash 2017. I wonder if there is a fix for this. From: Dave H [mailto:hell...@gmail.com] Sent: Wednesday, August 02, 2017 12:00 PM To: AC ; Christine Maloney ; John Ralls Cc: gnucash-

Re: population

2017-08-02 Thread Dave H
On Wed, 2 Aug 2017 at 8:25 pm, Christine Maloney via gnucash-user < gnucash-user@gnucash.org> wrote: > 13/01/1899 is the exact date. I have downloaded a later version, 2017 and > it > is still doing the same. The date range is amended correctly but the report > still does not show it. > Is the da

Re: gnucash update on debian errors, then stops

2017-08-02 Thread Liz
On Tue, 1 Aug 2017 20:24:24 -0500 John Griessen wrote: > I have not been able to upgrade gnucash for a while now. > > Will there be a usable gnucash in the next debian release? > If not, why not? > > > I still use this version on debian stretch/testing/frozen, soon to be > the new released deb

RE: population

2017-08-02 Thread Christine Maloney via gnucash-user
13/01/1899 is the exact date. I have downloaded a later version, 2017 and it is still doing the same. The date range is amended correctly but the report still does not show it. -Original Message- From: gnucash-user [mailto:gnucash-user-bounces+cmaloney4=talktalk@gnucash.org] On Behalf

Re: Adding quantity to expenses

2017-08-02 Thread Maf. King
On Tuesday, 1 August 2017 14:47:02 BST edamiani wrote: > Hi, I started using GnuCash with the goal of tracking my expenses and > generating reports, but one important thing for me would be storing the > quantity of an expense and automatically generating the resulting expense > from that. For insta

Adding quantity to expenses

2017-08-02 Thread edamiani
Hi, I started using GnuCash with the goal of tracking my expenses and generating reports, but one important thing for me would be storing the quantity of an expense and automatically generating the resulting expense from that. For instance: if I buy 0.8 kg of cheese for $10 the kilogram, I would li