Re: Printing no longer works on Windows 10 Pro

[David Carlson]

I seem to recall that GnuCash uses a different printing system dialog than
most other windows programs.  Perhaps a developer knows where to look for
this problem.

David C

On Thu, Feb 22, 2018 at 1:49 AM, David Carlson 
wrote:

> When printing checks the same thing happens when clicking on the Print
> button in the check printing box.  There would not be a work-around for
> that.
>
> David C
>
> On Wed, Feb 21, 2018 at 11:16 PM, Greg Feneis  wrote:
>
>> As a work around, perhaps try the Export as PDF function, then print the
>> exported PDF from a PDF viewer?
>>
>>
>> Kind regards,
>>
>> Greg Feneis
>>
>>
>>
>> On Wed, Feb 21, 2018 at 7:19 PM, jeffrey black <
>> beastmaster...@hotmail.com>
>> wrote:
>>
>> > Does anyone have any idea of why version 2.6.19 of GnuCash will no
>> > longer recognize any physical printer hooked to my Windows 10 Pro
>> > computer?  All other windoze programs do, and until today I have been
>> > able to print any GnuCash report on this computer. Split lines and all.
>> > I needed a quick and dirty one page report so didn't do the html export
>> > print or I would not have noticed. It has worked before, I use it to
>> > print tax reports for each month of the year.
>> >
>> > Just to check, I looked on my laptop which has windoze 10 home with
>> > GnuCash 2.6.19, and it recognizes and prints to all of my printers.
>> >
>> > Both computers are running 64 bit versions of windoze, one pro the other
>> > home, and I am using the same data file on both computers (moved the
>> > portable usb drive).
>> >
>> > I have rebooted the computer, unistalled 2.6.19 and reinstalled from a
>> > new download.
>> >
>> > Suggestions (besides dumping windoze, I am down to two legacy apps, then
>> > Hallelujah Unix here I come) ?
>> >
>> > --JEffrey Black M.B.A.
>> >
>> >
>> > ___
>> > 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: Printing no longer works on Windows 10 Pro

[David Carlson]

When printing checks the same thing happens when clicking on the Print
button in the check printing box.  There would not be a work-around for
that.

David C

On Wed, Feb 21, 2018 at 11:16 PM, Greg Feneis  wrote:

> As a work around, perhaps try the Export as PDF function, then print the
> exported PDF from a PDF viewer?
>
>
> Kind regards,
>
> Greg Feneis
>
>
>
> On Wed, Feb 21, 2018 at 7:19 PM, jeffrey black  >
> wrote:
>
> > Does anyone have any idea of why version 2.6.19 of GnuCash will no
> > longer recognize any physical printer hooked to my Windows 10 Pro
> > computer?  All other windoze programs do, and until today I have been
> > able to print any GnuCash report on this computer. Split lines and all.
> > I needed a quick and dirty one page report so didn't do the html export
> > print or I would not have noticed. It has worked before, I use it to
> > print tax reports for each month of the year.
> >
> > Just to check, I looked on my laptop which has windoze 10 home with
> > GnuCash 2.6.19, and it recognizes and prints to all of my printers.
> >
> > Both computers are running 64 bit versions of windoze, one pro the other
> > home, and I am using the same data file on both computers (moved the
> > portable usb drive).
> >
> > I have rebooted the computer, unistalled 2.6.19 and reinstalled from a
> > new download.
> >
> > Suggestions (besides dumping windoze, I am down to two legacy apps, then
> > Hallelujah Unix here I come) ?
> >
> > --JEffrey Black M.B.A.
> >
> >
> > ___
> > 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: Finance-Quote 1.47 Unable to retrieve Currency quotes

[Richard Morris via gnucash-user]

But I wonder - does GNUCash use alphavantage for currencies?

I see this:
"There are 3 types of sources of which the first - currency - is hardcoded
and responsible to fetch ISO currencies. The other two can be selected in
the security editor."
https://www.gnucash.org/docs/v2.6/C/gnucash-help/apas01.html

I'm still having the issue with currencies. How about you Adriano?

And isn't it odd that gnc-fq-dump currency USD EUR (for example) works?

On Tue, Feb 20, 2018 at 12:05 PM, Adriano Baldi 
wrote:

> Hello
>
> Maybe I found something 
>
> https://www.alpha-vantage.community/post/unable-to-get-
> the-response-when-using-currencyexchangerate-api-9654331
>
> we are not alone...
>
> Best regards
>
> Adriano
>
> 2018-02-20 12:47 GMT+01:00 Adriano Baldi :
>
>> Hello Richard
>>
>> After doing countless tests I think that the problem is related to the
>> management of the demands of Alphavantage.
>> But I can not figure out where we are wrong.
>> These are the declared performances:
>>
>> *>> What is the expected server-side performance (e.g., throughput time)
>> for the API service?*
>>
>> *>> Based on the latest instrumentation, the throughput time for our API
>> endpoint is under 500 milliseconds per request at 25% to 75% percentile. *
>>
>> *>> While we are proud to provide free API service with no
>> daily/weekly/monthly call limits, we recommend that API call frequency does
>> not extend far beyond ~1 call per second *
>>
>> *>> so that we can continue to deliver the optimal server-side
>> performance.*
>>
>> So I tried to put a delay between one request and another of 1 or more
>> seconds, with no result.
>> In addition I tried to ensure that for each request was used a different
>> key, randomly chosen among 10 keys, even here without result.
>>
>> I need new idea to test.
>>
>> Best regards
>>
>> Adriano
>>
>>
>> 2018-02-20 9:28 GMT+01:00 Richard Morris :
>>
>>> I have this problem too (starting yesterday). I was going to do a post -
>>> then, late in the day, the problem went away! But now it's back again.
>>>
>>> I wonder if this is a connectivity issue with whatever GNUCash uses for
>>> currency sources? (This is hard-wired I think, and I'm not sure what that
>>> is).
>>>
>>> I'm on Ubuntu too: GnuCash 2.6.17 + Ubuntu 17.10 + Finance::Quote 1.47
>>>
>>>
>>> On Tue, Feb 20, 2018 at 6:09 AM, Adriano Baldi 
>>> wrote:
>>>
 Hello

 I apologize for my poor English.

 I use GnuCash since 2011 and usually I am able to solve this kind of
 problem by myself if necessary modifing the perl files of
 Finance::Quote.
 But now I'm going crazy with this problem.

 I've got this error since february 14 on two different PC with Ubuntu
 14.04
 and 16.04 with GnuCash 2.6.12 and Finance::Quote 1.47.

 Unable to retrieve quotes for these items:
   CURRENCY:XAU
   CURRENCY:XPT
   CURRENCY:XAG
   CURRENCY:NZD
   CURRENCY:CAD
   CURRENCY:AUD
   CURRENCY:CHF
   CURRENCY:CNY
   CURRENCY:RUB
   CURRENCY:DKK
   CURRENCY:NOK
   CURRENCY:GBP
   CURRENCY:USD
   CURRENCY:JPY
 Continue using only the good quotes?

 If I try from the consolle Finance::Quote work fine

 $ gnc-fq-dump currency USD EUR
 1 USD = 0.805969 EUR

 $ gnc-fq-dump currency XAU EUR
 1 XAU = 1085.3924262 EUR

 $ gnc-fq-check
 ("1.47" "adig" "aex" "aiahk" "alphavantage" "amfiindia" "asegr" "asia"
 "asx" "australia" "bamosz" "bet" "bmonesbittburns" "bourso" "brasil"
 "bse"
 "bsero" "canada" "canadamutual" "citywire" "cominvest" "cse" "deka"
 "dutch"
 "dwsfunds" "europe" "fetch_live_currencies" "fidelity" "fidelity_direct"
 "fidelityfixed" "financecanada" "finanzpartner" "finland" "fool"
 "france"
 "ftfunds" "ftportfolios" "ftportfolios_direct" "fundlibrary" "goldmoney"
 "greece" "hex" "hu" "hufund" "hungary" "hustock" "indiamutual"
 "known_currencies" "lerevenu" "maninv" "morningstar" "morningstarjp"
 "mstaruk" "nasdaq" "nyse" "nz" "nzx" "platinum" "romania" "seb_funds"
 "sixfunds" "sixshares" "stockhousecanada_fund" "tdefunds" "tdwaterhouse"
 "tiaacref" "tnetuk" "troweprice" "troweprice_direct" "trustnet" "tsp"
 "tsx"
 "uk_unit_trusts" "ukfunds" "unionfunds" "usa" "usfedbonds" "vanguard"
 "vwd"
 "yahoo" "yahoo_asia" "yahoo_australia" "yahoo_brasil" "yahoo_europe"
 "yahoo_json" "yahoo_nz" "yahoo_yql" "za" "za_unittrusts")

 I don't know if this problem afflict only me (I hope so) or if others
 have
 the same problem.
 The problem afflicts only the currency with continuity, on some stocks I
 can have the problem occasionally, but generally a second download work
 fine.
 I retreive more of 40 stocks from 6 excange with no problem using
 Alphavantage.
 Does anyone have an idea from what can be determined?
 Does anyone have a suggestion to give me to solve this problem?
 Thanks in ad

Re: Language change mystery (John Ralls)

[Roger Oliver]

Original message

You do have an editor: Notepad. It comes with Windows. Just click the Start
menu and then type the name to find it. Once it's visible in the menu bar,
right-click on it and select "run as administrator" to get the privilege
escalation to edit environment.

 

Regards,

John Ralls

 

Results

John,

 

I opened Notepad as administrator and went looking for the environment file
in C:\\Program Files (x86)\gnucash\etc\gnucash. The file shows in explorer
but not in Notepad. A check of the properties doesn't show what kind of file
it is either. 

 

What would happen if I uninstalled and reinstalled the program in the
English environment? I think I've done this before moving to a new computer
and when a laptop crashed.

 

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.

Re: Printing no longer works on Windows 10 Pro

[Greg Feneis]

As a work around, perhaps try the Export as PDF function, then print the
exported PDF from a PDF viewer?


Kind regards,

Greg Feneis



On Wed, Feb 21, 2018 at 7:19 PM, jeffrey black 
wrote:

> Does anyone have any idea of why version 2.6.19 of GnuCash will no
> longer recognize any physical printer hooked to my Windows 10 Pro
> computer?  All other windoze programs do, and until today I have been
> able to print any GnuCash report on this computer. Split lines and all.
> I needed a quick and dirty one page report so didn't do the html export
> print or I would not have noticed. It has worked before, I use it to
> print tax reports for each month of the year.
>
> Just to check, I looked on my laptop which has windoze 10 home with
> GnuCash 2.6.19, and it recognizes and prints to all of my printers.
>
> Both computers are running 64 bit versions of windoze, one pro the other
> home, and I am using the same data file on both computers (moved the
> portable usb drive).
>
> I have rebooted the computer, unistalled 2.6.19 and reinstalled from a
> new download.
>
> Suggestions (besides dumping windoze, I am down to two legacy apps, then
> Hallelujah Unix here I come) ?
>
> --JEffrey Black M.B.A.
>
>
> ___
> 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: Printing no longer works on Windows 10 Pro

[David Carlson]

I wonder if this is the result of a recent Windows update.  I rarely print
from GnuCash but after reading your message I tried to print from release
2.6.18 in Windows 7 and I get "An error occurred during this operation."  I
have 5 different printers set up on this computer and Libre Calc has no
trouble selecting one of them and printing to it.

David C

On Wed, Feb 21, 2018 at 9:19 PM, jeffrey black 
wrote:

> Does anyone have any idea of why version 2.6.19 of GnuCash will no
> longer recognize any physical printer hooked to my Windows 10 Pro
> computer?  All other windoze programs do, and until today I have been
> able to print any GnuCash report on this computer. Split lines and all.
> I needed a quick and dirty one page report so didn't do the html export
> print or I would not have noticed. It has worked before, I use it to
> print tax reports for each month of the year.
>
> Just to check, I looked on my laptop which has windoze 10 home with
> GnuCash 2.6.19, and it recognizes and prints to all of my printers.
>
> Both computers are running 64 bit versions of windoze, one pro the other
> home, and I am using the same data file on both computers (moved the
> portable usb drive).
>
> I have rebooted the computer, unistalled 2.6.19 and reinstalled from a
> new download.
>
> Suggestions (besides dumping windoze, I am down to two legacy apps, then
> Hallelujah Unix here I come) ?
>
> --JEffrey Black M.B.A.
>
>
> ___
> 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.

Printing no longer works on Windows 10 Pro

[jeffrey black]

Does anyone have any idea of why version 2.6.19 of GnuCash will no 
longer recognize any physical printer hooked to my Windows 10 Pro 
computer?  All other windoze programs do, and until today I have been 
able to print any GnuCash report on this computer. Split lines and all.  
I needed a quick and dirty one page report so didn't do the html export 
print or I would not have noticed. It has worked before, I use it to 
print tax reports for each month of the year.

Just to check, I looked on my laptop which has windoze 10 home with 
GnuCash 2.6.19, and it recognizes and prints to all of my printers.

Both computers are running 64 bit versions of windoze, one pro the other 
home, and I am using the same data file on both computers (moved the 
portable usb drive).

I have rebooted the computer, unistalled 2.6.19 and reinstalled from a 
new download.

Suggestions (besides dumping windoze, I am down to two legacy apps, then 
Hallelujah Unix here I come) ?

--JEffrey Black M.B.A.


___
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: How to assign transaction to accounts automatically.

[Michael DeBusk]

On Wed, Feb 21, 2018 at 9:34 AM, Derek Atkins  wrote:

> C) Having said all that, I wholeheartedly agree that pre-processing
>files, when possible, can get you a really great outcome.  But this
>is easier with QIF and OFX-Download, not with OFX-DC.  I don't recall
>what the OP is using.

I've been editing my QIF files for years. It's very easy in vim.

-- 
Home: http://nlphilia.com * Blog: http://nlphilia.net
Registered Linux User #450983 * Ubuntu Counter Project #10548
___
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: Monthly Billings Report ? (How much business did we book/Invoice during month X)

[Adrien Monteleone]

I stand corrected and humbled. Perhaps I should be more careful to verify what 
I read, certainly before passing it along.

Thanks for the lesson.

Regards,
Adrien


> On Feb 21, 2018, at 3:41 PM, Fred Bone  wrote:
> 
> https://en.wikipedia.org/wiki/SQLite#History




___
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: Remove my name from your mailing list.

[Dave H]

Dick,

read the footer (copy below)  that's tacked onto every message - you get to
unsubscribe yourself :-)

Cheers Dave H.
___
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.

On 22 February 2018 at 08:38, Dick Courter  wrote:

>
> --
> Dick Courter ACF CF
> Professional Consulting Forester
> Genetechs
> 503.297.1660
>
> ___
> 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: Reports issues

[Dave H]

Forum/mailing list rules - keep the discussion on the list to allow other
users to offer suggestions/learn from the ongoing discussion.

Check out these recent threads from the mailing list archive as they may
offer some clues...

https://lists.gnucash.org/pipermail/gnucash-user/2018-February/074770.html
https://lists.gnucash.org/pipermail/gnucash-user/2018-February/074959.html
- this one offers a resolution which may be the answer you seek

The archives are at https://lists.gnucash.org/pipermail/gnucash-user/ - you
can search or browse as required.

Cheers Dave H.



On 22 February 2018 at 01:21, Finbar Mahon  wrote:

> Thanks for that, I thought that might be the reason, but it it actually
> says (not responding) and I have to force close it, go through the MS stuff
> about searching for a solution, and then restart.
>
> Maybe a Windows 10 latest release issue?
>
> B
>
> On 21/02/2018 12:03, Dave H wrote:
>
> There have been reports of late that when running reports on windows the
> first time it can take a quite some time and appear like it's hung.  Give
> it more time i.e. some minutes and let it finish.  Apparently subsequent
> report runs are pretty normal after the first time :-)
>
> cheers Dave H.
>
>
> On 21 February 2018 at 01:28, Finbar Mahon  wrote:
>
>> I am trying to generate some reports, to see how it works, as a very new
>> user.
>>
>> I am trying to produce a simple profit and loss. Every time I go to
>> report>profit and loss, it  seems to do some actions and then hangs. If I
>> try to get help or do anything else it stops and says not responding.
>>
>> Am I doing something wrong/
>>
>> ___
>> 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.

Remove my name from your mailing list.

[Dick Courter]

--
Dick Courter ACF CF
Professional Consulting Forester
Genetechs
503.297.1660

___
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: Monthly Billings Report ? (How much business did we book/Invoice during month X)

[Fred Bone]

On 21 February 2018 at 14:04, Adrien Monteleone said:

[...]
> SQLite is a flat-file db using SQL principles. It has some limitations and
> doesn’t work well for all situations. iTunes is probably the most widely
> used app to employ it. (I think it was even designed by Apple especially
> for iTunes, then later released to the public as a general purpose db) 

Er, no ... 
https://en.wikipedia.org/wiki/SQLite#History

___
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.

Upgrading to new laptop, new version?

[Dianna Broughton]

Hi everyone,

 

I'm upgrading to a new laptop after four years. Would you recommend that I
download the latest gnucash version, and then just transfer my gnucach
accounts into it, or keep using what I had (version 2.6.10)?

 

Thank you for your advice!

 

Warmly,
Dianna

___
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: Upgrading to new laptop, new version?

[James Fuller]

Hi,
I am a gnucash user not an authority so you are forewarned :-). I did much the 
same thing in not staying updated.  I finally updated to the current version.  
The update went seamlessly.  My advice would be to update now.  If a problem 
did occur you could always roll back but it isn't likely that any problems 
would pop up. YMMV.

James Fuller


Sent from my iPad

> On Feb 21, 2018, at 12:59 PM, Dianna Broughton  
> wrote:
> 
> Hi everyone,
> 
> 
> 
> I'm upgrading to a new laptop after four years. Would you recommend that I
> download the latest gnucash version, and then just transfer my gnucach
> accounts into it, or keep using what I had (version 2.6.10)?
> 
> 
> 
> Thank you for your advice!
> 
> 
> 
> Warmly,
> Dianna
> 
> ___
> 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: Stock Spin-Out

[Les]

Thanks Tommy for your input.

There was not any information on either the spun-out company or the 
company that did the spin-out. (both companies are Canadian stocks.)


I have sent email to both companies to determine my basis.


On 02/21/2018 11:59 AM, Tommy Trussell wrote:

On Tue, Feb 20, 2018 at 10:02 PM, nvsoar  wrote:

Comment:  It seems to me that a zero cost for the spun off shares is
incorrect if a non-zero basis exists for the pre-spin off shares.  A zero
cost for the new shares will result in a higher than necessary capital gain
when those shares are sold.  The easiest way to determine the new basis for
each of the remaining entities that I have found is to use the cost basis
calculator at the link previously provided.
nvsoar



Usually here in the US, when a company announces a stock spin-off, the
existing shareholders are provided a passel of materials, some of which
include a determination by a tax attorney or the IRS describing how to
calculate the basis of the spun-off shares. You can usually find the
information at the spun-off company's web site (look for a link for
"investor information") or as a document available from the company's stock
transfer agent.

I can imagine that sometimes such information may not be finalized at the
time of spin-off, especially if the IRS objects to some part of it, but my
impression is that these things are almost always pretty much settled
before the time they occur because there's lots of money involved. And
nobody wants any uncertainty when there's lots of money involved...



-
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: Stock Spin-Out

[nvsoar]

On 02/21/18 10:41, Les wrote:

Thanks Tommy for your input.

There was not any information on either the spun-out company or the 
company that did the spin-out. (both companies are Canadian stocks.)


I have sent email to both companies to determine my basis.


On 02/21/2018 11:59 AM, Tommy Trussell wrote:

On Tue, Feb 20, 2018 at 10:02 PM, nvsoar  wrote:

Comment:  It seems to me that a zero cost for the spun off shares is
incorrect if a non-zero basis exists for the pre-spin off shares.  A 
zero
cost for the new shares will result in a higher than necessary 
capital gain
when those shares are sold.  The easiest way to determine the new 
basis for
each of the remaining entities that I have found is to use the cost 
basis

calculator at the link previously provided.
nvsoar



Usually here in the US, when a company announces a stock spin-off, the
existing shareholders are provided a passel of materials, some of which
include a determination by a tax attorney or the IRS describing how to
calculate the basis of the spun-off shares. You can usually find the
information at the spun-off company's web site (look for a link for
"investor information") or as a document available from the company's 
stock

transfer agent.

I can imagine that sometimes such information may not be finalized at 
the
time of spin-off, especially if the IRS objects to some part of it, 
but my

impression is that these things are almost always pretty much settled
before the time they occur because there's lots of money involved. And
nobody wants any uncertainty when there's lots of money involved...
For info - Here is an article that may be useful in understanding the 
rationale of determining the post spin off basis for both remaining 
entities.  The basic idea is that the sum of the post-spinoff market 
value of both entities is the same as the pre-spinoff market value; and 
thus the pre-spin off basis is divided according to the post spin off 
market values.

http://www.spinoffprofiles.com/spinoff-tax-basis-and-tax-treatment

FWIW - I agree with Mr Trussel that in many cases the firm that 
initiates the spin off typically provides the percentages to determine 
the new basis for each of the spun off entities.  When this is not the 
case then the cost basis.com tool or a manual calculation is called 
for.  As far as I know, the IRS has not specified which of the stock 
price figures (open, close, high, low, average for the day) to be used 
for determining market value.

http://www.spinoffprofiles.com/spinoff-tax-basis-and-tax-treatment
nvsoar

___
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: Upgrading to new laptop, new version?

[David Carlson]

You did not mention which operating system that your new laptop will have.

If you are happy with your current release you can download a fresh copy
onto you new laptop from here:
https://sourceforge.net/projects/gnucash/files/
gnucash%20%28stable%29/2.6.10/

Otherwise, you can get the current version from here:
https://www.gnucash.org/download.phtml.

David C



On Wed, Feb 21, 2018 at 1:59 PM, Dianna Broughton 
wrote:

> Hi everyone,
>
>
>
> I'm upgrading to a new laptop after four years. Would you recommend that I
> download the latest gnucash version, and then just transfer my gnucach
> accounts into it, or keep using what I had (version 2.6.10)?
>
>
>
> Thank you for your advice!
>
>
>
> Warmly,
> Dianna
>
> ___
> 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: Language change mystery mysteriously solved

[rmomxtx]

To: Greg Feneis, John Ralls, David Carlson, Derek Atkins

 

Thanks for your help. 

 

I went back and double checked the language settings and there are several,
some I had overlooked. Region/formats was set to Spanish (españa) and
Region/location was set to Mexico. I changed the formats to English and the
location to the US. Next time I opened the program the menus were in
English. 

 

The tabs were still in Spanish. General Ledger was still Libro General. I
closed it and opened the general ledger from the Tools menu and the tab was
renamed in English.

 

I have another computer in Spanish with GnuCash installed for accounting in
our Learning Center in Puebla, Mexico. That program was in English. So I
changed every language setting I could find. Restarting GnuCash produced the
same result in reverse, everything is now in Spanish. Closing and reopening
the customer tab and the General Ledger tab changed the names to clientes
and Libro General.

 

The accounts/cuentas tab remains in the previous language. If I knew how to
close that tab and reopen it I am quite sure the name of the tab would
change appropriately. Would be helpful if someone could coach me on that.

 

I did finally get the Program files (x86)/gnucash/etc/gnucash/environment
opened in Note Pad. Thanks for the tip Greg Feneis as well as the guides
from the rest of you.

 

I think the take away to change languages in an installed version of GnuCash
is to hunt down all the language options and change them to the language you
want the program to show.

 

Appreciate the help. Just one step remaining: how to close and reopen the
accounts tab.

 

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.

Re: Monthly Billings Report ? (How much business did we book/Invoice during month X)

[Adrien Monteleone]

If you need MySQL, you have to install a MySQL server. (on any platform that 
doesn’t have it included) IIS is one way to do that on Windows. You can also 
install a WAMP stack. (Windows, Apache, MySQL, PHP) There are one-click 
installs available online. I would highly recommend installing PhpMyadmin if 
you go that route as it makes database admin a bit easier than the CLI 
interface. (it uses a web browser)

SQLite is a flat-file db using SQL principles. It has some limitations and 
doesn’t work well for all situations. iTunes is probably the most widely used 
app to employ it. (I think it was even designed by Apple especially for iTunes, 
then later released to the public as a general purpose db) One of the main 
limitations is it does not store date/time stamps like MySQL or the XML file. 
So you may have issues there with some otherwise well-formed queries.

You can query the file using SQL, and it has some internal representations that 
are table-like, but it is not the same as MySQL/MariaDb.

It is not a version of MySQL, but you are correct, it does not require a server 
instance. I’m not familiar with its use on Windows, but I’m sure that info 
isn’t hard to find.

PieCash is a Python-like interface to the Gnucash data files. (in whatever 
format they may be) It gives you functions you can use to write Python scripts 
to accomplish your tasks, in this case, retrieving data for custom reporting. 
I’ve yet to experiment with it myself, but it is discussed much here on the 
list. Until Gnucash becomes a proper database application, it is probably the 
easiest path for external reporting, data manipulation, and integration with 
other apps. As far as I understand it, it is not a collection of programs to 
execute. (though some examples may be included) That would be your own custom 
Python scripts I just mentioned. The GitHub link I gave you from ebridges is 
just such an example of some report scripts you can write using PieCash.

Though if you’ve saved in a db format (as opposed to XML) you can certainly 
write SQL statements directly to read the Gnucash tables without using PieCash. 
(just don’t WRITE to those tables!) Again, either via CLI or PhpMyadmin.

You could also write custom XML parsers in some other language if you like, but 
PieCash already has that covered, so it’s probably easiest to not re-invent the 
wheel.

Unfortunately, that’s all I have to offer. If you need more detailed help, I’ll 
have to defer to someone already working with either PieCash or MySQL. (I plan 
to, I just haven’t had the time to dig in yet)


Regards,
Adrien

> On Feb 21, 2018, at 11:12 AM, Fran_3  wrote:
> 
> Re: Converting to MySQL...
> 
> When I develop in MySQL on Windows I install IIS localhost server and 
> MySQL... but that is not practical on other office computers.
> 
> 1 - I'm not familiar with sqLite but a quick Google makes me think it is a 
> way to run MySQL on a local PC without running server software like IIS... 
> right?
> 
> 2 - Or is sqLite a desktop version of MySQL that requires no server?
> 
> 3 - Also, it looks like PieCash is a collection of Python programs... right?
> 
> 4 - And if so then you simply have to have the Python interrupter installed 
> on your machine and then run the appropriate PieCash program after editing in 
> the name and path to the gnuCash file... right?
> 
> Thanks again Adrien.
> 
> Fran3
> 
> 
> 
> 
> 
> 
> On Tuesday, February 20, 2018, 9:54:08 PM EST, Adrien Monteleone 
>  wrote:
> 
> 
> In order to use SQL on the Gnucash data, it needs to be saved in that format. 
> This requires the particular backend drivers (sqlite3, MySQL) be installed 
> already for the format to be available as a choice in the Save As dialog. See 
> the installation notes on the wiki for more info.
> 
> There is no built-in facility for writing queries. You’d have to access the 
> datafile from something else.
> 
> You may be interested in PieCash which allows for accessing either the XML or 
> SQL formatted data file for report writing. 
> https://github.com/sdementen/piecash
> 
> This was also posted to the mailing list recently and is an example of using 
> PieCash: https://github.com/ebridges/accounting-reports
> 
> Before you get started, you’ll want to look over this: 
> https://wiki.gnucash.org/wiki/FAQ#SQL_Database, and 
> https://wiki.gnucash.org/wiki/SQL and mind the warnings never to WRITE to the 
> data file from outside of Gnucash. (at least for the foreseeable future)
> 
> Here’s the SQL table map - yes, it’s ugly: 
> https://wiki.gnucash.org/wiki/images/8/86/Gnucash_erd.png
> 
> Unless you are comfortable with Scheme, or learning a new language, your best 
> bet is definitely to stick with the SQL/PieCash route.
> 
> 
> Regards,
> Adrien
> 
> > On Feb 20, 2018, at 4:59 PM, Fran_3  wrote:
> > 
> > Thanks Adrien,
> > 
> > Regarding custom reports... I do SQL but am having gnuCash save account 
> > files in it's default XML format.
> > 
> > Where would I get a list of the ta

Re: Language change mystery mysteriously solved, p.s.

[rmomxtx]

To: Greg Feneis, John Ralls, David Carlson, Derek Atkins

 

p.s. I checked the preferences after I wrote that last email and discovered
that I needed to chance the currency back to $US under Accounts/Default
currency and Reports/Default currency.

___
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: Closing Book causes Imbalance????

[Geert Janssens]

Yes, this has been requested before and I agree this would make more sense.

Related bug reports with different proposals for a solution:
https://bugzilla.gnome.org/show_bug.cgi?id=105803
https://bugzilla.gnome.org/show_bug.cgi?id=164317
https://bugzilla.gnome.org/show_bug.cgi?id=402289

Geert


Op woensdag 21 februari 2018 15:42:07 CET schreef Derek Atkins:
> Hi,
> 
> replicon  writes:
> 
> [snip]
> 
> >  BTW is there a way to enable a "Always display a warning if there is
> > imbalance" message? There are zero scenarios where it's acceptable to me
> > to
> > create a transaction that results in a "Imbalance-USD" account. Usually, I
> > check at the end of updating my file whether I screwed up and created
> > imbalance, but sometimes I don't notice... I'd like it to just yell at me
> > immediately when I mess up a transaction and create an imbalance, so I
> > don't have to do archaeology later when I notice it I'll never get
> > these 2 hours back.
> 
> A long long time ago, GnuCash would never let you create an imbalanced
> transaction.  If there was an imbalance and you tried to leave the
> transaction, for any reason, it would pop up a modal dialog and tell
> you.  I don't recall if it offered any solutions, other than "OK".
> 
> Then someone had the bright idea to automatically balance it for you.
> And that became "the way".  However I believe they also ripped out the
> old dialog, which means I don't think there is an easy way to set up an
> option to choose which way to go.
> 
> For the record, I would also prefer the dialog.
> 
> FWIW, there are also times when an auto-generated transaction is
> imbalanced.  I've seen it happen with some SX generated data, where the
> P+I != PMT -- off by $0.01 -- which gets put into Imbalance.  I'm not
> sure what the correct behavior is there.
> 
> > 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.

Re: Stock Spin-Out

[Tommy Trussell]

On Tue, Feb 20, 2018 at 10:02 PM, nvsoar  wrote:
>
> Comment:  It seems to me that a zero cost for the spun off shares is
> incorrect if a non-zero basis exists for the pre-spin off shares.  A zero
> cost for the new shares will result in a higher than necessary capital gain
> when those shares are sold.  The easiest way to determine the new basis for
> each of the remaining entities that I have found is to use the cost basis
> calculator at the link previously provided.
> nvsoar
>
>
Usually here in the US, when a company announces a stock spin-off, the
existing shareholders are provided a passel of materials, some of which
include a determination by a tax attorney or the IRS describing how to
calculate the basis of the spun-off shares. You can usually find the
information at the spun-off company's web site (look for a link for
"investor information") or as a document available from the company's stock
transfer agent.

I can imagine that sometimes such information may not be finalized at the
time of spin-off, especially if the IRS objects to some part of it, but my
impression is that these things are almost always pretty much settled
before the time they occur because there's lots of money involved. And
nobody wants any uncertainty when there's lots of money involved...


> -
> 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: Language change mystery (John Ralls)

[rmomxtx]

Original message

You do have an editor: Notepad. It comes with Windows. Just click the Start
menu and then type the name to find it. Once it's visible in the menu bar,
right-click on it and select "run as administrator" to get the privilege
escalation to edit environment.

 

Regards,

John Ralls

 

Results

John,

 

I opened Notepad as administrator and went looking for the environment file
in C:\\Program Files (x86)\gnucash\etc\gnucash. The file shows in explorer
but not in Notepad. A check of the properties doesn't show what kind of file
it is either. 

 

What would happen if I uninstalled and reinstalled the program in the
English environment? I think I've done this before moving to a new computer
and when a laptop crashed.

 

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.

Re: Monthly Billings Report ? (How much business did we book/Invoice during month X)

[Fran_3 via gnucash-user]

 Re: Converting to MySQL...
When I develop in MySQL on Windows I install IIS localhost server and MySQL... 
but that is not practical on other office computers.
1 - I'm not familiar with sqLite but a quick Google makes me think it is a way 
to run MySQL on a local PC without running server software like IIS... right?
2 - Or is sqLite a desktop version of MySQL that requires no server?
3 - Also, it looks like PieCash is a collection of Python programs... right?
4 - And if so then you simply have to have the Python interrupter installed on 
your machine and then run the appropriate PieCash program after editing in the 
name and path to the gnuCash file... right?
Thanks again Adrien.
Fran3





On Tuesday, February 20, 2018, 9:54:08 PM EST, Adrien Monteleone 
 wrote:  
 
 In order to use SQL on the Gnucash data, it needs to be saved in that format. 
This requires the particular backend drivers (sqlite3, MySQL) be installed 
already for the format to be available as a choice in the Save As dialog. See 
the installation notes on the wiki for more info.

There is no built-in facility for writing queries. You’d have to access the 
datafile from something else.

You may be interested in PieCash which allows for accessing either the XML or 
SQL formatted data file for report writing. https://github.com/sdementen/piecash

This was also posted to the mailing list recently and is an example of using 
PieCash: https://github.com/ebridges/accounting-reports

Before you get started, you’ll want to look over this: 
https://wiki.gnucash.org/wiki/FAQ#SQL_Database, and 
https://wiki.gnucash.org/wiki/SQL and mind the warnings never to WRITE to the 
data file from outside of Gnucash. (at least for the foreseeable future)

Here’s the SQL table map - yes, it’s ugly: 
https://wiki.gnucash.org/wiki/images/8/86/Gnucash_erd.png

Unless you are comfortable with Scheme, or learning a new language, your best 
bet is definitely to stick with the SQL/PieCash route.


Regards,
Adrien

> On Feb 20, 2018, at 4:59 PM, Fran_3  wrote:
> 
> Thanks Adrien,
> 
> Regarding custom reports... I do SQL but am having gnuCash save account files 
> in it's default XML format.
> 
> Where would I get a list of the tables in gnuCash and their associated 
> fields/columns?
> 
> Is there a window I can open to just put in an SQL query or what?
> 
> Can I create an SQL query that will query the default XML format file format?
> 
> (I've actually never considered using XML for a full fledged database until I 
> just started using gnuCash and discovered that it uses XML)
> 
> Or do I have all of this wrong?
> 
> thanks again.
> 
> 
> 
> On Tuesday, February 20, 2018, 5:14:38 PM EST, Adrien Monteleone 
>  wrote:
> 
> 
> You could leverage a multi-column report perhaps with a customer report in 
> each column, that will get you invoice & payment detail, but no aggregate 
> totals across all customers. (but each customer would have it’s own total)
> 
> Then there is the P&L/Income Statement, but it will show you revenue by type 
> (account) not by customer. It will have a total however.
> 
> Finally, there is the Customer Report. The Sales column will show what you 
> want. Though you may not need the other columns, the only one you can turn 
> off is the expense column. I’ve yet to figure out where to put costs or 
> markup figures for that report to make much sense. It will report a sales 
> total per customer with a grand total.
> 
> If you want to see revenue by type AND customer with totals, you’ll have to 
> make your own report either with SQL or Scheme.
> 
> All of these reports (as are any others in GnuCash) allow you to set either 
> the date of the report, (such as for a Balance Sheet) or the date range the 
> report covers. There are shortcut date selectors for month, quarter, year and 
> ‘accounting period’ (if your fiscal year differs from the calendar) as well 
> as boxes to let you put in any specific dates you want. You’ll find that 
> under the General tab of any report options.
> 
> 
> Regards,
> Adrien
> 
> > On Feb 20, 2018, at 3:41 PM, Fran_3 via gnucash-user 
> >  wrote:
> > 
> > I'm sure there is a way but I haven't found it yet...
> > How do we run a report to see how much business we booked/invoiced for a 
> > particular month?Total and/or including a list of customers and amounts?
> > Ditto for  a specified period of time... current quarter, last quarter, so 
> > far this year... so far this date last year... etc?
> > Thanks for any help.
> > Fran 3
> 
> > ___
> > 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: Trading Accounts for Securities

[Derek Atkins]

Hi,

Trading accounts do not show you UNREALIZED gains.  They exist to help you
balance out REALIZED gains once you have a sale transaction.

-derek

On Wed, February 21, 2018 12:00 pm, Keith Bellairs wrote:
> I started looking at using trading accounts but I may be missing
> something.
>
> The trading account created by gnucash for a stock shows as a balance the
> number of shares in the account. This is also the balance shown in the
> asset account for that stock.
>
> Transactions for all stocks post to the USD (in my case) trading account.
> So the USD trading account seems to show the aggregate of purchases,
> sales,
> gains. losses etc. of all the stocks - sort of like the amount of money I
> have on the table for trading. But I would rather see the realized gains
> in
> an income account. And I can see the total unrealized gain(loss) in an
> advanced portfolio report.
>
> I had guessed that unrealized gains would somehow be reflected in the
> trading account when the value of the underlying security is updated. In
> that way the trading account would look like the marginable value of my
> stocks. Then I looked at the documentation. The examples only show
> realized
> gains being posted. So again, the actual asset account for a security
> provides me more info. I guess I could manually post unrealized gain to
> the
> trading account each time I look up the price of a security, since the
> Trading Account - USD does not have to match the real amount of cash on
> hand.
>
> In the end I do not see that I get anything from using trading accounts. I
> can see that they would be useful for currency if I had to track the
> exchange rate on every foreign currency transaction. But the IRS lets me
> use an average rate for my CDN income(expense).
>
> Am I using trading accounts wrong?
>
> Keith
> ___
> 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.

Trading Accounts for Securities

[Keith Bellairs]

I started looking at using trading accounts but I may be missing something.

The trading account created by gnucash for a stock shows as a balance the
number of shares in the account. This is also the balance shown in the
asset account for that stock.

Transactions for all stocks post to the USD (in my case) trading account.
So the USD trading account seems to show the aggregate of purchases, sales,
gains. losses etc. of all the stocks - sort of like the amount of money I
have on the table for trading. But I would rather see the realized gains in
an income account. And I can see the total unrealized gain(loss) in an
advanced portfolio report.

I had guessed that unrealized gains would somehow be reflected in the
trading account when the value of the underlying security is updated. In
that way the trading account would look like the marginable value of my
stocks. Then I looked at the documentation. The examples only show realized
gains being posted. So again, the actual asset account for a security
provides me more info. I guess I could manually post unrealized gain to the
trading account each time I look up the price of a security, since the
Trading Account - USD does not have to match the real amount of cash on
hand.

In the end I do not see that I get anything from using trading accounts. I
can see that they would be useful for currency if I had to track the
exchange rate on every foreign currency transaction. But the IRS lets me
use an average rate for my CDN income(expense).

Am I using trading accounts wrong?

Keith
___
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: New File Won't Open

[Les]

Sorry, I am used to using Linux and forget about Mac.  Thanks for the reply.

Les


On 02/21/2018 09:23 AM, Derek Atkins wrote:

Hi,

On Wed, February 21, 2018 10:12 am, Les wrote:

I right click on the new file to open.

Like I said below -- that does not work on the Mac.
GnuCash will always open the last-used file.
You need to use GnuCash's File -> Open to open your new file.

-derek


On 02/21/2018 08:59 AM, Derek Atkins wrote:

HI,

On Wed, February 21, 2018 9:44 am, Les wrote:

I created a new GC file for my Mac.  When I try to open the new file,
it
reverts back the previous file.

How to correct this problem?

How are you trying to open the new file?

On a Mac you cannot double-click a file -- GnuCash does not handle the
Apple Open intent and will always open the last-opened file on a Mac.
So
on a Mac you MUST use File->Open from the menu to select your data file.


Thanks,

Les

-derek


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.

Date Change

[Paul Konnersman]

My earlier reply was addressed to the wrong person.

I think that you will find what you're looking for here:

*MenuBar> File> Accounts> "Day Threshold to Read-Only Transactions (red*
* line)*



*If you enter zero in"Day Threshold" field all transactions will be
available in Read/Write,*
*If you enter the numeral "n" in "Day Threshold" field all transactions
will be available in Read/Write for the last "n" days, but read only if
the transaction date is more than "n" in the past. .And you will only be
able to back-date a transaction "n" days*

Hope this is helpful.

Paul

-- 
*Paul M. Konnersman*
*konners...@gmail.com *
*781-639-0616*
___
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: Re: How to assign transaction to accounts automatically.

[alspachde]

-BEGIN PGP SIGNED MESSAGE-
Hash: SHA256

This would be a nice enhancement. I suspect that for the developers (not
me) there are a lot of issues hidden in this.
I suggest limiting it to keeping the account type the same or at least warn
the user if not.
Your example is for a simple transaction. What should be done with splits?
Is the feature to be limited to changing only one of the splits? Is only
the account to be changed or should changes in descriptions and notes be
allowed? What about the reconciliation field?

Dale
-BEGIN PGP SIGNATURE-
Version: FlowCrypt 5.3.0 Gmail Encryption flowcrypt.com
Comment: Seamlessly send, receive and search encrypted email

wsFcBAEBCAAQBQJajY/0CRBIElv/N0x5XwAAEwkP/3/G9lrQpq0JPWUtcZdQ
6Q91T6MXSjcfMSy/Ew+wgWdd+tx4jQu6G3wgGeyKQy4xesP7UTZw8bEmV5+m
ie+6kzMQD6wlIRqLiDmlQ26uvad1KEfy7bxrDhzXP2GKAk/9gj8ijBvrDPMC
CZIftSSfMjg/KcA/z/CMcP5ocDuzZ7fRK930bRetPxES2wUUNOUZ2V/ku7Wz
YB6Uusd+gSYuglLBzlJZoLWt23kQsiW6yL82KXjn+YtLbOQuIMNAzb1Vs4PS
uT1PykpKVSUiB/xs7cBCPaIPldNS8EWI3YlydExulb8Kh6IWdNThWyTcXMs1
Mq9PWUQuQMbsExTRqtuSbw/hSkKeecVSKzq8y75OzZG3/S4IP2+GfMunHZeS
t3DVN2BGmjXO72vACq+lEtE3UAJhnFFq0k80ktBY0wg+08GCwEDxTW6LsF34
8gTTcBl0nyuVTN5a5Rk1ILjU8/xSzGp/jyqLMbOLAjFLSCOZdyEEFBLSyRDD
Avnrmi3I0Srp5jPirC0acvCFL3Io1cYf5L1nE5uD8Qg+SvlbV7S0Gg4OcOrE
W9ZaSSX65N11CS6jLiEyxBADCOc98xvkNAn+DYW1UkdRyPTT539sCwpA7/rJ
K46UYzfkmXpdbKkzGfaCBkLBU+2c9kzvdqcSWHIr64EO/uCMmoMXxWs97Trk
exgb
=d18B
-END PGP SIGNATURE-


-BEGIN PGP PUBLIC KEY BLOCK-
Version: CryptUp 4.3.6 Gmail Encryption https://cryptup.org
Comment: Seamlessly send, receive and search encrypted email

xsFNBFjfIkUBEAC+IJ+2lfvw7NOBXkkZP6XJNYjd9u2CxSN9Q7xAlztloTdO
Bm4v2c6/+OsUtEaiMr4RNQgqsg7QW69XVHQW82skRslmIU2MHDFpUSBIT6/D
Cf8j1Iwh8qTKXGXCY9Z9RQ2NtEFvgeTvRoDgCuh3BmunGetvZF+482beIS9l
++WvoTMSlJ4H15AsKWa+MMYnU+j5YTHckb/c1knoXdefDae1iqcLvEBGieg2
0+GNcCn/g8TQ/CRfzVBdoW5XNWVaWt1nmG6HX4l82clHmjGR0/7diWX0iek6
HlmQhq9IUuAj5crSsMKhYHNuBEtBZtv7DFd/D/kuo1zT6B6l+11OV6pKYk/x
MDiwwxGMlL+Mr11p/iGxOzynqaIR89/tnJ/xXTa1Dq4BmUymQc2gBI8VxVFE
NCI8xu9qcpQ/6S4BSVs9dIu20EtkkUM/uIFzUfEGZlFX73HK6VzfO1HuOIqD
PUJZlegTLldtI8d+Y+ZrP5+Bs2vghVosXvw75b3K3vTg6plNz6olP7P0Cddy
NbnEec50fkTtAFYuo3y+JT02F5jTKKe0ppyAj97heujqJc1eMYObKhOHYZIk
dUdPA0bZlnUjnUo7KGNJKLrKQA4YGlY/7mQOGW9oCyNrll7B2a5TmHQu63fm
whnhtvh/37OuvD4uFT2pWAoBWW1H/SEHALW5uwARAQABzSJEYWxlIEFsc3Bh
Y2ggPGFsc3BhY2hkZUBnbWFpbC5jb20+wsF1BBABCAApBQJY3yJGBgsJBwgD
AgkQSBJb/zdMeV8EFQgCCgMWAgECGQECGwMCHgEAAGHGD/96Fuqpvieiz9vR
EoM5j2VJM8JcVzR/GGObyFif2dt+ph4+izrRHwhqIfugeNGY7FejrGHPK47Y
no8oaE+KuYQ0CZ/GB/dMVhqhxn/1nvhZ5WseymCOvSKJ5ZVHwAwJTDyct5RW
ErfPQhjaI5MKqkcbY+a4j4T8WhQNAP8BAKVdEvXBkNSsdtGd5Q40KigolkyL
LHGG4jfJi0cicOp+kfeuHNG51tv15FvM0grHFxufldA5LOkBOezWHS0OxEAx
V3SUt7ZJzxR+dkcIuN/jL+BsAM84ineA3yfZqgJ9iRzmB+9luEYCmpC0sx2e
mG4L3aCGYVZJ6RyBrcN9tCtZSAOcs3ogoGNvFIW7kC7t260z9fUHkCQQGyAO
6WLOpxekjVkKyOKtQg+JZX5zKFI04UVgzja3KKpM1kMM2Umdur4/sjTVD6ej
/9liKqxZiHP9gmhECBRrtHdcTs7B5PSRI66exk38EVWyQ4dBfwre1M/k8aRQ
Ug1C/xsJVncEf3BSeidSNPuOM5QcGpJfRpkMUnoLXy5kNFF34fqg83gR0TS4
hV726yPAI0nLVt1xSOcYPiHOau3vIqBDLAgChmmGFVK8w+cJiXrClhKbwAL/
/IL/iC/cle+oY1fsRFD1K0TXeuycxYUXTaDuk06XiJmE9yzwntT3sQ/X61MO
rN9YlqQg9c7BTQRY3yJFARAAphaeT0CRa7+K1GfhJFHv/cMBQxVV3JK8ozPY
UdJtcHrOwnuAgO5KdeDuS+VvXNukUuvP2Q0NQomO0Orm+N9a8JsP6Ud4NpZH
HHzBX7y/fbA5cLaLwC4fd37VhfjiQ6nAJFKZc2SguMTp1oSq9IcXIP3sSKQ1
2NG+7zsI3mgxbL9oRI7ps0K2S9Kpq7TeNUhgD5VOTVDL1nf9+LfIa4DNQ4PM
4DMsPCIqkAFYkjP58eQ9k4O1IqrQC7mWCERJA6FZLfbYSr9iSv3R8D0xkZjw
uDqDXAHmrvKMx1DKd7TSLDcuuF8d1SuoAKM+LlyNEoGgzgMkEJ4/7RIh2Cly
izR+0Kc4JPqMmhlAy8+MR0bA4eUc849nCeftkZa0ndAuUvZj1X68QuPxepFU
hqLv2kPwFCTP7JBqC8WaiCIx1Gk3qLcXKmeVuAC/DbXYtRhqROnOgsD1lW0+
bA3t6Y2oZT7FklZq+o1ewmZtrQEJo1cbU9BXxY2t5zmD8IE2oT+UQeFa5AK7
DquKpkaUOdu4ktF5L4cwAJaSMz8TqEZJ4eImBF4ztMqiZRko75DfEEcaJJIl
X+m07YyiT6N+I6YO33nc6zwdMwjCggTol1b50wXfbZKwyB3boViIb19+Ih/d
wGulMRWLdP0f5I0fmAJzX6naNOpk138dZoY3PFAnNyNreaEAEQEAAcLBXwQY
AQgAEwUCWN8iSgkQSBJb/zdMeV8CGwwAABJKD/4qy1Etp4opkQHEWfGCVUlJ
GT+fafPnLDArcTWvMp53C8LeHRL9ks9obFFe8o5sMASiJa0WLo9G5Z8by2h6
D+AizkDYjxehoO+YjP0S6kr8dp1/mQ0UO6LifJ2yMdNyAoST5QpEDU5dBJV5
LT5s6D+YC5b2n3KraFsjgiesdfWKXV8WnMBrv6pnOKGfTDqRqdifuAU0gQk0
C3ghuVePYo9Bn/PHU8Ph1E1EtmMN3Ma9m+Zl/vbJRqqpgyV0BbP8wfTq03h2
o/1GfhKE59B3WlLH5BD5eA3r5cevg/mVtY01YoZGNAkiDs+2CCotVklPHroR
g8WYMu+pBTyg1B9uCkwVeV5TzG2IKiz+WeHhWiRnL0m3nDsG1unEy1sEQNPs
4lXOX2zknqOmWhIc0FT0F3CjH9cOVH6mQW/1X8fdvnaitRXkfswQ3+l4UUmT
CzDkPY3xJXD0jrKZOl0p4dfyY0+VQJFJlCSiiwXGEJ0oRBQKKx43bePM3rPk
CFW9rUfoqdJmYT79fK616iroq0+zhDI+S3C4N6OlkJCMpqMPjaf671asD21h
gSy01PFANpJdx9lHejLewR8vgjJL922j1XjyHpAJGjnNv1tHa493JUY7NA0I
mtOBiu4gdzm4VT5Wa3/o1ltZxQJz0W2ehj0QuV6zXFMqoagZhBn6oYXqKpZL
kA==
=qtc5
-END PGP PUBLIC KEY BLOCK-
___
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

Re: New File Won't Open

[Derek Atkins]

Hi,

On Wed, February 21, 2018 10:12 am, Les wrote:
> I right click on the new file to open.

Like I said below -- that does not work on the Mac.
GnuCash will always open the last-used file.
You need to use GnuCash's File -> Open to open your new file.

-derek

>
> On 02/21/2018 08:59 AM, Derek Atkins wrote:
>> HI,
>>
>> On Wed, February 21, 2018 9:44 am, Les wrote:
>>> I created a new GC file for my Mac.  When I try to open the new file,
>>> it
>>> reverts back the previous file.
>>>
>>> How to correct this problem?
>> How are you trying to open the new file?
>>
>> On a Mac you cannot double-click a file -- GnuCash does not handle the
>> Apple Open intent and will always open the last-opened file on a Mac.
>> So
>> on a Mac you MUST use File->Open from the menu to select your data file.
>>
>>> Thanks,
>>>
>>> Les
>> -derek
>>
>>> 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: New File Won't Open

[Les]

I right click on the new file to open.


On 02/21/2018 08:59 AM, Derek Atkins wrote:

HI,

On Wed, February 21, 2018 9:44 am, Les wrote:

I created a new GC file for my Mac.  When I try to open the new file, it
reverts back the previous file.

How to correct this problem?

How are you trying to open the new file?

On a Mac you cannot double-click a file -- GnuCash does not handle the
Apple Open intent and will always open the last-opened file on a Mac.  So
on a Mac you MUST use File->Open from the menu to select your data file.


Thanks,

Les

-derek


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.

Re: New File Won't Open

[Derek Atkins]

HI,

On Wed, February 21, 2018 9:44 am, Les wrote:
> I created a new GC file for my Mac.  When I try to open the new file, it
> reverts back the previous file.
>
> How to correct this problem?

How are you trying to open the new file?

On a Mac you cannot double-click a file -- GnuCash does not handle the
Apple Open intent and will always open the last-opened file on a Mac.  So
on a Mac you MUST use File->Open from the menu to select your data file.

>
> Thanks,
>
> Les

-derek

> 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.

New File Won't Open

[Les]

I created a new GC file for my Mac.  When I try to open the new file, it 
reverts back the previous file.


How to correct this problem?

Thanks,

Les

___
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: Closing Book causes Imbalance????

[Derek Atkins]

Hi,

replicon  writes:

[snip]
>  BTW is there a way to enable a "Always display a warning if there is
> imbalance" message? There are zero scenarios where it's acceptable to me to
> create a transaction that results in a "Imbalance-USD" account. Usually, I
> check at the end of updating my file whether I screwed up and created
> imbalance, but sometimes I don't notice... I'd like it to just yell at me
> immediately when I mess up a transaction and create an imbalance, so I don't
> have to do archaeology later when I notice it I'll never get these 2
> hours back.

A long long time ago, GnuCash would never let you create an imbalanced
transaction.  If there was an imbalance and you tried to leave the
transaction, for any reason, it would pop up a modal dialog and tell
you.  I don't recall if it offered any solutions, other than "OK".

Then someone had the bright idea to automatically balance it for you.
And that became "the way".  However I believe they also ripped out the
old dialog, which means I don't think there is an easy way to set up an
option to choose which way to go.

For the record, I would also prefer the dialog.

FWIW, there are also times when an auto-generated transaction is
imbalanced.  I've seen it happen with some SX generated data, where the
P+I != PMT -- off by $0.01 -- which gets put into Imbalance.  I'm not
sure what the correct behavior is there.

> 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, SB '93 MIT EE, SM '95 MIT Media Laboratory
   Member, MIT Student Information Processing Board  (SIPB)
   URL: http://web.mit.edu/warlord/PP-ASEL-IA N1NWH
   warl...@mit.eduPGP key available
___
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: How to assign transaction to accounts automatically.

[Derek Atkins]

jeffrey black  writes:

[snip]
> Derek could probably write a Python script in his sleep to do the
> corrections, if he ever sleeps.  Personally I don't think that he ever
> does sleep (:-))!! His up-time is longer than the servers.  So that is
> not an option.

A) I do sleep (although my Avatar is almost-always-online)
B) I don't do Python -- I think it's a horrible language, and
   specifically whomever thought that syntactic whitespace was a good
   thing should be summarily tarred, feathered, and then shot.
C) Having said all that, I wholeheartedly agree that pre-processing
   files, when possible, can get you a really great outcome.  But this
   is easier with QIF and OFX-Download, not with OFX-DC.  I don't recall
   what the OP is using.
   
-derek
-- 
   Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory
   Member, MIT Student Information Processing Board  (SIPB)
   URL: http://web.mit.edu/warlord/PP-ASEL-IA N1NWH
   warl...@mit.eduPGP key available
___
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: Language change mystery

[rmomxtx]

David,

 

The Windows defender controlled folder access feature is confusing to me. Can’t 
figure out how to add a program to the approved list. For now, I just turned it 
off. I couldn’t find the program file for GnuCash to add it to the list. Not 
sure where it is in the Program Files (x86)/GnuCash. 

 

Thinking back, I’m not sure Windows Defender responded to the accounting entry 
or to something else that GnuCash was doing. I got a message similar to when 
you accidently try to open GnuCash twice or after it shuts down improperly. It 
happened several times.

 

Thanks,

Roger

 

From: David Carlson [mailto:david.carlson@gmail.com] 
Sent: martes, 20 de febrero de 2018 11:01 p. m.
To: John Ralls 
Cc: Roger Oliver ; Derek Atkins ; Gnucash 

Subject: Re: Language change mystery

 

Roger,

Do you have your data file in a user documents folder or sub-folder with full 
read and write privileges?  Windows Defender should not be interfering with 
access to your data file.  If that new Controlled Folder Access feature is that 
fussy...

David C

 

On Tue, Feb 20, 2018 at 9:07 PM, John Ralls mailto:jra...@ceridwen.us> > wrote:



> On Feb 20, 2018, at 12:14 PM, rmom...@gmail.com   
> wrote:
>
> Thanks Derek,
>
> I changed the OS language back to English and restarted the computer,
> several times. This did not change the language back to English.
>
> Windows Defender Controlled Folder Access blocked GnuCash from making
> changes to the data file. At first, it even blocked adding a new
> transaction. I turned off the controlled folder access feature.
>
> I read the instructions at the link. The version of GnuCash I have installed
> is 2.6.18. I tried to follow the instructions to edit the environment file
> at c:\\Program Files\gnucash\etc\gnucash. But I don't have an editor for
> that type of file or an option to open it as administrator. So, I'm not sure
> what to do with that.
>
> Might it work to uninstall and reinstall the program? Does the uninstall
> remove the data files? I have a backup, just a matter of making sure it is
> up to date.
>

You do have an editor: Notepad. It comes with Windows. Just click the Start 
menu and then type the name to find it. Once it’s visible in the menu bar, 
right-click on it and select “run as administrator” to get the privilege 
escalation to edit environment.

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: How to assign transaction to accounts automatically.

[Derek Atkins]

Hans,

On Wed, February 21, 2018 8:49 am, Hans Deragon wrote:
> Thank you all for your quick responses.  It is nice to discover that
> GnuCash's mailing list is very alive.
>
> I am currently shopping for an Open Source personal financial-accounting
> software.  I do not mind the double entry, but it bugs me that I cannot
> reassign accounts at will, easily.

I would rephrase this as "cannot reassign multiple transactions at once". 
You *can* easily reassign a single transaction pretty easily, but if you
want to rebalance your account tree -- you're right, it's much easier to
go from too many accounts to fewer accounts (when you delete an account
you can reassign, en-masse, all of its transactions to another account).

[snip]
> GnuCash seams missing a feature for this kind of scenario.  I would like
> to propose the following feature:
>
>   Search and Replace accounts assignments.
>
>   Dialog box that allows to search for transactions matching
>   their description with a user provided expression and allow
>   to change the accounts to which they are assigned to.
>
>   The feature should support:
>
>   - Normal and extended regular expressions (default normal).
>   - Limit search/reassignments to one or more accounts (default current
> account only).
>   - Limit search/reassignments within a time interval (default -infinty
> to +infinity).
>
> Should I open an issue against GnuCash regarding this feature request?
> Is it something the developers will consider or it goes against the
> philosophy of GnuCash?

I think it's a great idea, and I look forward to your patch or pull
request that implements it!

Welcome to GnuCash!

> Best regards,
> Hans Deragon

-derek

> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

-- 
   Derek Atkins 617-623-3745
   de...@ihtfp.com www.ihtfp.com
   Computer and Internet Security Consultant

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: How to assign transaction to accounts automatically.

[Hans Deragon]

Thank you all for your quick responses.  It is nice to discover that
GnuCash's mailing list is very alive.

I am currently shopping for an Open Source personal financial-accounting
software.  I do not mind the double entry, but it bugs me that I cannot
reassign accounts at will, easily.

Since I am starting, I have only a vague clue of the accounts I want to
create.  I am sure that in a few months, I will want to reassign
transactions to different accounts, go more granular probably.  This is
normal for new users who are discovering the tool.

For instance, one user might start putting all automobile related
transactions under the account "Automobile".  But after a few months of
usage, discovers that it would be preferable to have
"Automobile:Gasoline", "Automobile:Repairs", "Automobile:Lease", etc...
There is no mean in GnuCash to reassign previous transactions with
description "Shell" to "Automobile:Gasoline".  Yet, for me, this kind of
feature is basic and expected from personal financial-accounting software.

GnuCash seams missing a feature for this kind of scenario.  I would like
to propose the following feature:

  Search and Replace accounts assignments.

  Dialog box that allows to search for transactions matching
  their description with a user provided expression and allow
  to change the accounts to which they are assigned to.

  The feature should support:

  - Normal and extended regular expressions (default normal).
  - Limit search/reassignments to one or more accounts (default current
account only).
  - Limit search/reassignments within a time interval (default -infinty
to +infinity).

Should I open an issue against GnuCash regarding this feature request?
Is it something the developers will consider or it goes against the
philosophy of GnuCash?

Best regards,
Hans Deragon

On 2018-02-20 07:39, Hans Deragon wrote:
> Greetings,
> 
> New user here.  I downloaded 500 transactions from my credit card bank
> site, all assigned to 'Imbalanced-CAD'.  Now, how can I set rules to
> automatically assign transactions to a specific account?  For instance,
> any transaction with "^ESSO.*" or "^SHELL.*" must be reassigned to
> Car:Gasoline.  I fail to find that information on the web, except that
> when importing, GnuCash trains itself and does that automatically at the
> next import.
> 
> But what about my 500 transactions that are already imported?  What
> about if one wants to reassign transactions to another account, after a
> month of careful thinking?  Does a user have to go through all
> transactions manually?
> 
> As a workaround, is it possible to convert the GnuCash file into Unicode
> and use scripting languages to manipulate the transactions, then convert
> it back to its binary format?
> 
> Using GnuCash 2.6.12 on Ubuntu 16.04 LTS.
> 
> Best regards,
> Hans Deragon
> 
> 
> 
> ___
> 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.
> 



signature.asc
Description: OpenPGP digital signature
___
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: Closing Book causes Imbalance????

[replicon]

ACK! I figured it out!

I noticed it was choking on a building depreciation transaction.

Looks like just one of my expense accounts, probably due to typo/click-o
when setting it up, had "smallest fraction" set to "1" instead of "Use
Commodity Value".

As a result, the depreciation transaction for the building was rounded up to
the dollar on that expense account. NO imbalance was created by this, and it
didn't throw up a warning, so it was up to me to notice that it did the
wrong thing (which I didn't - it's a basic transaction).

So... I had to fix that account, and then redo the book-closing.

No thanks to GNUCash's crappy error handling, silently creating missing
pennies, and then choking at the end of the year book-closing, silently
creating an Imbalance account instead of blaring an error message.

 BTW is there a way to enable a "Always display a warning if there is
imbalance" message? There are zero scenarios where it's acceptable to me to
create a transaction that results in a "Imbalance-USD" account. Usually, I
check at the end of updating my file whether I screwed up and created
imbalance, but sometimes I don't notice... I'd like it to just yell at me
immediately when I mess up a transaction and create an imbalance, so I don't
have to do archaeology later when I notice it I'll never get these 2
hours back.

*grumble grumble* :D



--
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.

Re: Reports issues

[Dave H]

There have been reports of late that when running reports on windows the
first time it can take a quite some time and appear like it's hung.  Give
it more time i.e. some minutes and let it finish.  Apparently subsequent
report runs are pretty normal after the first time :-)

cheers Dave H.


On 21 February 2018 at 01:28, Finbar Mahon  wrote:

> I am trying to generate some reports, to see how it works, as a very new
> user.
>
> I am trying to produce a simple profit and loss. Every time I go to
> report>profit and loss, it  seems to do some actions and then hangs. If I
> try to get help or do anything else it stops and says not responding.
>
> Am I doing something wrong/
>
> ___
> 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.

Reports issues

[Finbar Mahon]

I am trying to generate some reports, to see how it works, as a very new 
user.


I am trying to produce a simple profit and loss. Every time I go to 
report>profit and loss, it  seems to do some actions and then hangs. If 
I try to get help or do anything else it stops and says not responding.


Am I doing something wrong/

___
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.