Re: Problems with entries in Lao language

[John Ralls]

> On Jul 15, 2017, at 12:04 AM, Michael  wrote:
> 
> Hi all,
> 
> On one computer (DELL Vostro 14 3000) entries in Lao language are  pulled 
> apart and therefore not easy to read. The same file opened from an USB stick 
> on another computer (DELL VOSTRO 3550) has no problems. Bot computers are 
> using Windows 10 and the latest version of gnu cash.
> 
> I tried to make all settings for language, region country etc. identical on 
> both computers - still the same result.
> 
> Any idea?

If I understand "pulled apart" correctly it suggests that the two computers are 
using different typefaces one of which may not have lao glyphs. You can check 
the fonts selected on each using the "Select GnuCash Theme" tool in the Start 
menu GnuCash folder.

Regards.
John Ralls

___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Problems with entries in Lao language

[Greg Feneis]

Hi Michael,

Continuing with your idea to confirm the settings are duplicated between
the two computers, you might also want to make sure Windows updates are the
same between the two computers (in as much as possible).  Perhaps the
computer that works as you'd expect it to has an update, that the other
doesn't, or vice versa.

Good luck!

Kind regards,

Greg Feneis

On Sat, Jul 15, 2017 at 12:04 AM, Michael  wrote:

I tried to make all settings for language, region country etc. identical on
> both computers - still the same result.
>
>
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Copying many transactions

[David T. via gnucash-user]

Actually, the dividends DON'T have to go to the fund account. You could 
register the reinvestment as a dividend transaction (to a cash account), 
followed by a buy transaction. That is how I handle these. 
YMMV.
Best, David  

 
 
  On Sat, Jul 15, 2017 at 12:15, azalea4va wrote:   
GnuCash - User mailing list wrote
>  In other words, money comes from the income account (e.g.,
> Income:Dividends) and goes to the brokerage account (Assets:Brokerage) . I
> am not sure you need that second transaction at all.
> ...
> Without the second transaction, things get much simpler.

The dividends MUST go to the fund account, the questions is wether or not to
show them in the brokerage account.  I could just have Income:Dividends ->
Asset:Brokerage:Fund and that would be simpler.  The dividend MUST go to the
fund account because it is buying additional shares of that fund.  But if I
lack the in/out transaction fo the money going through the brokerage fund,
that account no longer matches what I see when I get a listing from the
brokerage company.  Also, by putting that information on the brokerage
account, I have one account that shows all money movement into and out of
that account.

So yes, I do not NEED the second transaction. Having it is a value
judgement.  Do I want simple or am I willing to deal with some complexity to
get a clearer view of what is happening?  Fortunately I was able to automate
the process using the shell script I mentioned in an earlier post,
eliminating much of the manual labor.



--
View this message in context: 
http://gnucash.1415818.n4.nabble.com/Copying-many-transactions-tp4692519p4692692.html
Sent from the GnuCash - User mailing list archive at Nabble.com.
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.
  
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Copying many transactions

[Harry Hall]

Colin,
Wow did not think of the simple way, all up and running on the iMac now.
Much appreciated 
Harry


Sent from my iPhone

> On 15 Jul 2017, at 08:45, Colin Law  wrote:
> 
>> On 15 July 2017 at 08:37, Harry Hall  wrote:
>> Hi
>> New to forum and looking for help.
>> Basically I have a new iMac and my old gnucash cash accounts are on my old 
>> windows 10 PC.
>> I have downloaded gnucash for mac but unable to import the export 
>> transactions files. The account files have came across, i.e. The account and 
>> sub account names but can't get the numbers to import. Is there a quick way ?
> 
> You don't need to export at all, all you need to do is, on the old PC,
> in gnucash run File > Save As and save the accounts file on a usb
> stick or whatever, then put that in the new PC and use File > Open to
> read it from the stick and then File > Save As to save it where you
> want.
> 
> Colin

___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Copying many transactions

[Colin Law]

On 15 July 2017 at 08:37, Harry Hall  wrote:
> Hi
> New to forum and looking for help.
> Basically I have a new iMac and my old gnucash cash accounts are on my old 
> windows 10 PC.
> I have downloaded gnucash for mac but unable to import the export 
> transactions files. The account files have came across, i.e. The account and 
> sub account names but can't get the numbers to import. Is there a quick way ?

You don't need to export at all, all you need to do is, on the old PC,
in gnucash run File > Save As and save the accounts file on a usb
stick or whatever, then put that in the new PC and use File > Open to
read it from the stick and then File > Save As to save it where you
want.

Colin
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Copying many transactions

[Harry Hall]

Hi
New to forum and looking for help.
Basically I have a new iMac and my old gnucash cash accounts are on my old 
windows 10 PC.
I have downloaded gnucash for mac but unable to import the export transactions 
files. The account files have came across, i.e. The account and sub account 
names but can't get the numbers to import. Is there a quick way ?

Also what is a QIF file and how do you create this.

Any advice appreciated.
Thanks Harry


Sent from my iPhone

> On 14 Jul 2017, at 19:34, azalea4va  wrote:
> 
> GnuCash - User mailing list wrote
>> In other words, money comes from the income account (e.g.,
>> Income:Dividends) and goes to the brokerage account (Assets:Brokerage) . I
>> am not sure you need that second transaction at all.
>> ...
>> Without the second transaction, things get much simpler.
> 
> The dividends MUST go to the fund account, the questions is wether or not to
> show them in the brokerage account.  I could just have Income:Dividends ->
> Asset:Brokerage:Fund and that would be simpler.  The dividend MUST go to the
> fund account because it is buying additional shares of that fund.  But if I
> lack the in/out transaction fo the money going through the brokerage fund,
> that account no longer matches what I see when I get a listing from the
> brokerage company.  Also, by putting that information on the brokerage
> account, I have one account that shows all money movement into and out of
> that account.
> 
> So yes, I do not NEED the second transaction. Having it is a value
> judgement.  Do I want simple or am I willing to deal with some complexity to
> get a clearer view of what is happening?  Fortunately I was able to automate
> the process using the shell script I mentioned in an earlier post,
> eliminating much of the manual labor.
> 
> 
> 
> --
> View this message in context: 
> http://gnucash.1415818.n4.nabble.com/Copying-many-transactions-tp4692519p4692692.html
> Sent from the GnuCash - User mailing list archive at Nabble.com.
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Flash Drive

[John Wright]

I am considering a larger drive.  It might be the smarter way to go.


On 07/14/2017 03:55 PM, Robert Heller wrote:

At Fri, 14 Jul 2017 15:10:10 -0500 John Wright  wrote:



I was actually thinking about making a self-booting fedora flash drive
and installing gnucash on that.  I could also install all my other apps
as well and not use my hard drive at all.  Talk about a throw back to
the dark ages.

A self booking flash drive would work.  Better would be real external USB
drive.

It is also possible to get larger (capacity) SSDs.  I have a 128GB SATA SSD in
my laptop.  Bought it on eBay for a not unreasonable price.


John


On 07/14/2017 12:00 PM, David Carlson wrote:

Perhaps this is not sensible, but I once experimented with installing
Gnucash on a USB key configured as a Tails OS with persistent
storage.  That is based on Debian Linux.  It worked, but it was
somewhat clumsy.  The nice thing is that all the data is completely
encrypted and insulated from intruders, "sandboxed" if you will.

David C

On Fri, Jul 14, 2017 at 10:30 AM, Robert Heller mailto:hel...@deepsoft.com>> wrote:

 At Fri, 14 Jul 2017 14:39:17 +0100 Colin Law mailto:clan...@gmail.com>> wrote:

 >
 > On this list you have to use Reply All to reply otherwise the
 message
 > just goes to the previous user (as this did). Forwarding this to the
 > list for information.  Also see reply below.
 >
 > On 14 July 2017 at 12:31, John Wright mailto:minimudd...@gmail.com>> wrote:
 > > Colin,
 > >
 > > Sorry for the confusion.  I what to just run gnucash from the
 flash drive.
 > > Fedora will be installed on the pc and gnucash as well as all
 the gnucash
 > > data will be on the flash drive.
 >
 > To be pedantic you don't want to run gnucash from the flash
 drive, you
 > want to run gnucash from the HDD and write and read the accounts
 file
 > to the removable drive, which should be no problem. Gnucash does not
 > care where you save to and read from. If you want saved reports
 to be
 > on the drive there may be a little more work.

 Most (all?) sensibly setup and configured Linux systems will
 refuse to *run*
 programs on removable media, since that is a massive security risk.

 Also, gnucash is generally dynamicaly linked and depends on
 various [shared]
 libraries that would need to be installed in system places (eg
 /usr/lib[64]/)
 from various dependent packages. So it is unlikely that putting
 *just* the
 gnucash exe file on the flash drive will work. Gnucash itself
 expects to find
 stuff in /usr/share/gnucash, which won't be on the flash drive.
 And also has
 its own pile of .so files in /usr/lib[64]/ that it will need to
 access.  And
 it is likely that gnucash built for, say Ubuntu, may not run *as
 is* under
 fedora, becase of different library versions (and whatnot). You
 really need
 to just install the fedora build of gnucash on the fedora (there
 most likely
 is a gnucash-.rpm out there somewhere, probably in the fedora
 repository, so a 'sudo yum install gnucash' will do everything
 needful.)

 But otherwise, having the *data* files on the thumb drive is a
 perfectly
 sensible thing to do.  And is possible fairly secure as well.

 >
 > Colin
 >
 > >
 > > Thanks.
 > >
 > >
 > > On 07/14/2017 06:04 AM, Colin Law wrote:
 > >>
 > >> On 14 July 2017 at 03:12, ov10fac mailto:ov10...@cox.net>> wrote:
 > >>>
 > >>> Does anyone know if gnucash can be run from a flash drive
 using fedora?
 > >>
 > >> Do you mean you want the program on a flash drive or the data
 file? If
 > >> you want the data file on the flash drive with gnucash
 installed in
 > >> fedora on the PC then that is no problem. If you want to
 install the
 > >> program itself onto the flashdrive, with Fedora on the PC,
 then that
 > >> is more problematic. Or do you mean you want to run Fedora
 itself and
 > >> gnucash from the flash drive?
 > >>
 > >> Colin
 > >
 > >
 > ___
 > gnucash-user mailing list
 > gnucash-user@gnucash.org 
 > https://lists.gnucash.org/mailman/listinfo/gnucash-user
 
 > -
 > Please remember to CC this list on all your replies.
 > You can do this by using Reply-To-List or Reply-All.
 >
 >

 --
 Robert Heller -- 978-544-6933 
 Deepwoods Software-- Custom Software Services
 http://www.deepsoft.com/ -- Linux Administration Services
 hel...@deepsoft.com   -- Webhosting
 Services

 ___
 gnucash-user mailing list
 gnucash-user@gnucash.org 

Re: Flash Drive

[John Wright]

I was actually thinking about making a self-booting fedora flash drive 
and installing gnucash on that.  I could also install all my other apps 
as well and not use my hard drive at all.  Talk about a throw back to 
the dark ages.


John


On 07/14/2017 12:00 PM, David Carlson wrote:
Perhaps this is not sensible, but I once experimented with installing 
Gnucash on a USB key configured as a Tails OS with persistent 
storage.  That is based on Debian Linux.  It worked, but it was 
somewhat clumsy.  The nice thing is that all the data is completely 
encrypted and insulated from intruders, "sandboxed" if you will.


David C

On Fri, Jul 14, 2017 at 10:30 AM, Robert Heller > wrote:


At Fri, 14 Jul 2017 14:39:17 +0100 Colin Law mailto:clan...@gmail.com>> wrote:

>
> On this list you have to use Reply All to reply otherwise the
message
> just goes to the previous user (as this did). Forwarding this to the
> list for information.  Also see reply below.
>
> On 14 July 2017 at 12:31, John Wright mailto:minimudd...@gmail.com>> wrote:
> > Colin,
> >
> > Sorry for the confusion.  I what to just run gnucash from the
flash drive.
> > Fedora will be installed on the pc and gnucash as well as all
the gnucash
> > data will be on the flash drive.
>
> To be pedantic you don't want to run gnucash from the flash
drive, you
> want to run gnucash from the HDD and write and read the accounts
file
> to the removable drive, which should be no problem. Gnucash does not
> care where you save to and read from. If you want saved reports
to be
> on the drive there may be a little more work.

Most (all?) sensibly setup and configured Linux systems will
refuse to *run*
programs on removable media, since that is a massive security risk.

Also, gnucash is generally dynamicaly linked and depends on
various [shared]
libraries that would need to be installed in system places (eg
/usr/lib[64]/)
from various dependent packages. So it is unlikely that putting
*just* the
gnucash exe file on the flash drive will work. Gnucash itself
expects to find
stuff in /usr/share/gnucash, which won't be on the flash drive.
And also has
its own pile of .so files in /usr/lib[64]/ that it will need to
access.  And
it is likely that gnucash built for, say Ubuntu, may not run *as
is* under
fedora, becase of different library versions (and whatnot). You
really need
to just install the fedora build of gnucash on the fedora (there
most likely
is a gnucash-.rpm out there somewhere, probably in the fedora
repository, so a 'sudo yum install gnucash' will do everything
needful.)

But otherwise, having the *data* files on the thumb drive is a
perfectly
sensible thing to do.  And is possible fairly secure as well.

>
> Colin
>
> >
> > Thanks.
> >
> >
> > On 07/14/2017 06:04 AM, Colin Law wrote:
> >>
> >> On 14 July 2017 at 03:12, ov10fac mailto:ov10...@cox.net>> wrote:
> >>>
> >>> Does anyone know if gnucash can be run from a flash drive
using fedora?
> >>
> >> Do you mean you want the program on a flash drive or the data
file? If
> >> you want the data file on the flash drive with gnucash
installed in
> >> fedora on the PC then that is no problem. If you want to
install the
> >> program itself onto the flashdrive, with Fedora on the PC,
then that
> >> is more problematic. Or do you mean you want to run Fedora
itself and
> >> gnucash from the flash drive?
> >>
> >> Colin
> >
> >
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org 
> https://lists.gnucash.org/mailman/listinfo/gnucash-user

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

--
Robert Heller -- 978-544-6933 
Deepwoods Software-- Custom Software Services
http://www.deepsoft.com/ -- Linux Administration Services
hel...@deepsoft.com   -- Webhosting
Services

___
gnucash-user mailing list
gnucash-user@gnucash.org 
https://lists.gnucash.org/mailman/listinfo/gnucash-user

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




___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your repl

Re: Flash Drive

[John Wright]

David,

Yes, in fact I have gotten the error several times.  My first attempt at 
running gnucash from a flash drive went this way. Installed it on the 
hard drive,  then moved all the gnucash files (except libs) to flash 
drive,  added a .desktop file to user/share/applications.  That worked 
ok, but I couldn't find the icon, and all the lib files were still on 
the hard drive.


The reason I want to do this is that the laptop I just purchased has a 
15GB m-stat sshd.  So I really don't have a lot of room to play with.  
Sort of a throwback to the days when everything we ran was stored on 
floppy drives and either a very small hard drive or no hard drive at 
all.  Of course that was way before the internet.


John


On 07/14/2017 01:20 PM, David wrote:


I guess it's lucky that John only wants to load his data from the 
flash drive, then.


John, be aware that GnuCash always tries to load the last file it had 
open; if the folder isn't available when you fire it up, you will 
receive an error. Just be sure the USB stick is inserted and mounted 
before you start GC, and you should be fine.


David




*From:* David Carlson 
*Sent:* Fri Jul 14 22:00:33 GMT+05:00 2017
*To:* Robert Heller 
*Cc:* "gnucash-user@gnucash.org" , John 
Wright 

*Subject:* Re: Flash Drive

Perhaps this is not sensible, but I once experimented with installing
Gnucash on a USB key configured as a Tails OS with persistent storage.
That is based on Debian Linux.  It worked, but it was somewhat clumsy.  The
nice thing is that all the data is completely encrypted and insulated from
intruders, "sandboxed" if you will.

David C

On Fri, Jul 14, 2017 at 10:30 AM, Robert Heller  wrote:

> At Fri, 14 Jul 2017 14:39:17 +0100 Colin Law  wrote:
>
> >
> > On this list you have to use Reply All to reply otherwise the message
> > just goes to the previous user (as this did). Forwarding this to the
> > list for information.  Also see reply below.
> >
> > On 14 July 2017 at 12:31, John Wright  wrote:
> > > Colin,
> > >
> > > Sorry for the confusion.  I what to just run gnucash from the flash
> drive.
> > > Fedora will be installed on the pc and gnucash as well as all the
> gnucash
> > > data will be on the flash drive.
> >
> > To be pedantic you don't want to run gnucash from the flash drive, you
> > want to run gnucash from the HDD and write and read the accounts file
> > to the removable drive, which should be no problem. Gnucash does not
> > care where you save to and read from. If you want saved reports to be
> > on the drive there may be a little more work.
>
> Most (all?) sensibly setup and configured Linux systems will refuse to
> *run*
> programs on removable media, since that is a massive security risk.
>
> Also, gnucash is generally dynamicaly linked and depends on various
> [shared]
> libraries that would need to be installed in system places (eg
> /usr/lib[64]/)
> from various dependent packages. So it is unlikely that putting *just* the
> gnucash exe file on the flash drive will work. Gnucash itself expects to
> find
> stuff in /usr/share/gnucash, which won't be on the flash drive. And also
> has
> its own pile of .so files in /usr/lib[64]/ that it will need to access.
> And
> it is likely that gnucash built for, say Ubuntu, may not run *as is* under
> fedora, becase of different library versions (and whatnot).  You really
> need
> to just install the fedora build of gnucash on the fedora (there most
> likely
> is a gnucash-.rpm out there somewhere, probably in the fedora
> repository, so a 'sudo yum install gnucash' will do everything needful.)
>
> But otherwise, having the *data* files on the thumb drive is a perfectly
> sensible thing to do.  And is possible fairly secure as well.
>
> >
> > Colin
> >
> > >
> > > Thanks.
> > >
> > >
> > > On 07/14/2017 06:04 AM, Colin Law wrote:
> > >>
> > >> On 14 July 2017 at 03:12, ov10fac  wrote:
> > >>>
> > >>> Does anyone know if gnucash can be run from a flash drive using
> fedora?
> > >>
> > >> Do you mean you want the program on a flash drive or the data file? If
> > >> you want the data file on the flash drive with gnucash installed in
> > >> fedora on the PC then that is no problem. If you want to install the
> > >> program itself onto the flashdrive, with Fedora on the PC, then that
> > >> is more problematic. Or do you mean you want to run Fedora itself and
> > >> gnucash from the flash drive?
> > >>
> > >> Colin
> > >
> > >
> >


> > gnucash-user mailing list
> > gnucash-user@gnucash.org
> > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > -
> > Please remember to CC this list on all your replies.
> > You can do this by using Reply-To-List or Reply-All.
> >
> >
>
> --
> Robert Heller -- 978-544-6933
> Deepwoods Software-- Custom Software Services
> http://www.deepsoft.com/  -- Linux Administration Services
> hel.

Re: Flash Drive

[John Wright]

Ok,

Did not know that, thanks.


On 07/14/2017 01:58 PM, Robert Heller wrote:

At Fri, 14 Jul 2017 12:00:33 -0500 David Carlson  
wrote:



Perhaps this is not sensible, but I once experimented with installing
Gnucash on a USB key configured as a Tails OS with persistent storage.
That is based on Debian Linux.  It worked, but it was somewhat clumsy.  The
nice thing is that all the data is completely encrypted and insulated from
intruders, "sandboxed" if you will.

Tails is a "special case" -- it is specificly designed to live on a (possibly
encrypted) flash drive as a "security" feature. "Normal" desktop Linux systems
that have been installed properly on a PC or Laptop hard drive will not let
you run random programs living on random removable media (thumb & optical
drives).  The "default" mount options include "noexec"...  This prevents
someone from breaking your system by offering a "trogan horse" program on such
media or using a break-in program to attack your computer.


David C

On Fri, Jul 14, 2017 at 10:30 AM, Robert Heller  wrote:


At Fri, 14 Jul 2017 14:39:17 +0100 Colin Law  wrote:


On this list you have to use Reply All to reply otherwise the message
just goes to the previous user (as this did). Forwarding this to the
list for information.  Also see reply below.

On 14 July 2017 at 12:31, John Wright  wrote:

Colin,

Sorry for the confusion.  I what to just run gnucash from the flash

drive.

Fedora will be installed on the pc and gnucash as well as all the

gnucash

data will be on the flash drive.

To be pedantic you don't want to run gnucash from the flash drive, you
want to run gnucash from the HDD and write and read the accounts file
to the removable drive, which should be no problem. Gnucash does not
care where you save to and read from. If you want saved reports to be
on the drive there may be a little more work.

Most (all?) sensibly setup and configured Linux systems will refuse to
*run*
programs on removable media, since that is a massive security risk.

Also, gnucash is generally dynamicaly linked and depends on various
[shared]
libraries that would need to be installed in system places (eg
/usr/lib[64]/)
from various dependent packages. So it is unlikely that putting *just* the
gnucash exe file on the flash drive will work. Gnucash itself expects to
find
stuff in /usr/share/gnucash, which won't be on the flash drive. And also
has
its own pile of .so files in /usr/lib[64]/ that it will need to access.
And
it is likely that gnucash built for, say Ubuntu, may not run *as is* under
fedora, becase of different library versions (and whatnot).  You really
need
to just install the fedora build of gnucash on the fedora (there most
likely
is a gnucash-.rpm out there somewhere, probably in the fedora
repository, so a 'sudo yum install gnucash' will do everything needful.)

But otherwise, having the *data* files on the thumb drive is a perfectly
sensible thing to do.  And is possible fairly secure as well.


Colin


Thanks.


On 07/14/2017 06:04 AM, Colin Law wrote:

On 14 July 2017 at 03:12, ov10fac  wrote:

Does anyone know if gnucash can be run from a flash drive using

fedora?

Do you mean you want the program on a flash drive or the data file? If
you want the data file on the flash drive with gnucash installed in
fedora on the PC then that is no problem. If you want to install the
program itself onto the flashdrive, with Fedora on the PC, then that
is more problematic. Or do you mean you want to run Fedora itself and
gnucash from the flash drive?

Colin



___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.



--
Robert Heller -- 978-544-6933
Deepwoods Software-- Custom Software Services
http://www.deepsoft.com/  -- Linux Administration Services
hel...@deepsoft.com   -- Webhosting Services

___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

  


___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Copying many transactions

[azalea4va]

GnuCash - User mailing list wrote
>  In other words, money comes from the income account (e.g.,
> Income:Dividends) and goes to the brokerage account (Assets:Brokerage) . I
> am not sure you need that second transaction at all.
> ...
> Without the second transaction, things get much simpler.

The dividends MUST go to the fund account, the questions is wether or not to
show them in the brokerage account.  I could just have Income:Dividends ->
Asset:Brokerage:Fund and that would be simpler.  The dividend MUST go to the
fund account because it is buying additional shares of that fund.  But if I
lack the in/out transaction fo the money going through the brokerage fund,
that account no longer matches what I see when I get a listing from the
brokerage company.  Also, by putting that information on the brokerage
account, I have one account that shows all money movement into and out of
that account.

So yes, I do not NEED the second transaction. Having it is a value
judgement.  Do I want simple or am I willing to deal with some complexity to
get a clearer view of what is happening?  Fortunately I was able to automate
the process using the shell script I mentioned in an earlier post,
eliminating much of the manual labor.



--
View this message in context: 
http://gnucash.1415818.n4.nabble.com/Copying-many-transactions-tp4692519p4692692.html
Sent from the GnuCash - User mailing list archive at Nabble.com.
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Copying many transactions

[azalea4va]

Derek Atkins wrote
> Your best bet may be to create a QIF file that contains the transactions
> you want and then import that file.

This is essentially what I resorted to.  Since gnucash does not support
export to anything but a CSV file, I wrote a shell script to extract
information from the gnucash xml file and output to a GIF file.  As a shell
script, it was slow as molasses running on a file with 500K transactions,
but it got the job done.




--
View this message in context: 
http://gnucash.1415818.n4.nabble.com/Copying-many-transactions-tp4692519p4692690.html
Sent from the GnuCash - User mailing list archive at Nabble.com.
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Loan/Mortgage payments with "adjusted" principal (eg after an extra principle payment), SOLVED

[azalea4va]

Oops, that should be "principal", not "principle". Forgiveness (for that and
surely others) requested from the spelling police.



--
View this message in context: 
http://gnucash.1415818.n4.nabble.com/Loan-Mortgage-payments-with-adjusted-principle-eg-after-an-extra-principle-payment-SOLVED-tp4692686p4692687.html
Sent from the GnuCash - User mailing list archive at Nabble.com.
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Loan/Mortgage payments with "adjusted" principle (eg after an extra principle payment), SOLVED

[azalea4va]

I recently switched to gnucash and had trouble setting up my mortgage account
because I had made extra principle payments in the past.  I search of this
board revealed others have had the same problem.  So I wrote some scheme
functions that take care of the problem.  This works for situations where
one is paying a constant amount each month, but that amount may be different
from the original monthly payment and/or the principle left is off schedule.

Problem review: gnucash is setup to deal with loans where payments are made
according to the original amoritization schedule.  But if the principle ever
gets out a whack with respect to whatever is determined by that schedule,
gnucash does not correctly compute how a payment gets divided into principle
and interest because the existing gnucash functions assume the balance at
any point are what the original schedule would have, not what the now
adjusted balance is.

There are four "variables in loan calculations: starting principle, interest
rate, term (number of payments), and monthly payment.  Given any 3, the
fourth can be computed.  Given those four values, one can compute how any
month's payment will be split between interest and principle. 

I put into my "home" directory the file "config.user" below with the
necessary functions. I then used the mortgage assistant to create the loan
account.  I specified the balance as the balance currently and the term as
the number of months left required to pay off the loan.  I then went to
Actions->ScheduledTransactions->ScheduledTranasactionsEditor, highlighted
the loan, and clicked on Schedlued->Edit=>TemplateTransaction.  I adjusted
the formulas there accordingly:

pmt( 0.03 / 12.00 : 110 : 15.00 : 0 : 0 )
  became (added the "i" and 1950 arguments)
pmtFixed( 0.03 / 12.00 : i : 110 : 15.00 : 0 : 0 : 1950)

ppmt( 0.03 / 12.00 : i : 110 : 15.00 : 0 : 0 )
  became (added the 1950 argument)
ppmtFixed( 0.03 / 12.00 : i : 110 : 15.00 : 0 : 0 : 1950)

ipmt( 0.03 / 12.00 : i : 110 : 15.00 : 0 : 0 )
  became (added the 1950 argument)
ipmtFixed( 0.03 / 12.00 : i : 110 : 15.00 : 0 : 0 : 1950)

An item of note (from the comment in config.user).

;; In real life, mortgage payments are made in distinct monthly payment. In
gnucash
;; those payments are processed with a precision to the nearest penny.  In
math,
;; they are processed with greater precision.  This can cause function using
pure
;; math to get out of sync (by a penny at a time) with what happens in a
gnucash
;; register.  These differences can be resolved by adjusting the results of
the
;; functions below to the nearest penny and using the recursive function
below
;; to compute the balance at any point (and not the non-recursive one). BUT, 
;; I appear to have found a bug in gnucash.  When one uses the schedule
editor,
;; the editor complains about parsing the functions when recursion is
included.
;; So the solution below uses the non-recursive function for computing
balance
;; after 'payNum' payments.  It has been my experieince (limited) that after
getting
;; everything setup in the schedule editor, I can change config.user to use
the 
;; recursive function and everything runs smoothly.  Just set config.user
back to
;; using balFixed2 temporarily if you ever need to go back into the schedule
editor.

config.user   



--
View this message in context: 
http://gnucash.1415818.n4.nabble.com/Loan-Mortgage-payments-with-adjusted-principle-eg-after-an-extra-principle-payment-SOLVED-tp4692686.html
Sent from the GnuCash - User mailing list archive at Nabble.com.
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Problems with entries in Lao language

[Michael]

Hi all,

On one computer (DELL Vostro 14 3000) entries in Lao language are  
pulled apart and therefore not easy to read. The same file opened from 
an USB stick on another computer (DELL VOSTRO 3550) has no problems. Bot 
computers are using Windows 10 and the latest version of gnu cash.


I tried to make all settings for language, region country etc. identical 
on both computers - still the same result.


Any idea?

Michael

___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.