[GNC] Bonus share entry

2019-03-06 Thread Xboxboy Mageia
Hi all, I have some bonus shares that were issued with no cost to me: I am having trouble entering them without a cost. When I put 0 as the cost, on the next line 1 appears, and I am unable to get rid of it. Perhaps I'm doing this the wrong way, and need to be entering them as a share split? In

Re: [GNC] Fwd: Bonus share entry

2019-03-06 Thread D via gnucash-user
>>> Please remember to CC this list on all your replies. >>> You can do this by using Reply-To-List or Reply-All. > Hi Derek, > > I've attached a picture, I don't think I'm explaining very well. > > Please see attached. > > What can I do about that imbalance line? > Many tha

Re: [GNC] Splitting a multi-year file

2019-03-06 Thread Andrea Borgia
Il 03/03/19 20:29, Christian Kluge ha scritto: I’d suggest making balance sheets for each year to exported. Afterwards I would use File\Export\Transactions to CSV. There I would select the appropriate time range. I also would export the account structure to CSV. In the one-year-only file I

Re: [GNC] MySQL

2019-03-06 Thread Colin Law
On Wed, 6 Mar 2019 at 21:44, Keith Bellairs wrote: > > Yes I can connect using the mysql command line tool. No, the gnucash db has > not been created. > > But I cannot use the mysqlworkbench shell. It complains about a missing > connector (python?) > > Also, gnc get the "bad data" error even if

Re: [GNC] MySQL

2019-03-06 Thread Keith Bellairs
Yes I can connect using the mysql command line tool. No, the gnucash db has not been created. But I cannot use the mysqlworkbench shell. It complains about a missing connector (python?) Also, gnc get the "bad data" error even if I try to "save as" with a bad password, no password, or no user id.

Re: [GNC] Fwd: Bonus share entry

2019-03-06 Thread Chris Good
-List or Reply-All. > Hi Derek, > > I've attached a picture, I don't think I'm explaining very well. > > Please see attached. > > What can I do about that imbalance line? > Many thanks, > Xboxboy > -- next part -- > A non-text attachment wa

Re: [GNC] MySQL

2019-03-06 Thread Colin Law
On Wed, 6 Mar 2019 at 19:09, Keith Bellairs wrote: > > gnucash.trace is empty. > > Of some interest, I did a Save As to sqlite and it worked. So the xml data is > acceptable to that DB. > > XML -> sqlite OK > XML -> mysql NG > sqlite -> mysql NG > > I tried to do a Save As from the sqlite db to

Re: [GNC] gnucash 3.4 help needed

2019-03-06 Thread Dale Alspach
I am no expert but try putting an absolute path to the source directory in place of ../gnucash-3.4 Dale On 3/6/19 2:00 PM, devlin wrote: > Running Linux Mint 18.3 Cinnamon on this box, and need some help - > > Playing with Gnucash 3.4, and from the page at > >   >

[GNC] gnucash 3.4 help needed

2019-03-06 Thread devlin
Running Linux Mint 18.3 Cinnamon on this box, and need some help - Playing with Gnucash 3.4, and from the page at   [URL="http://https://wiki.gnucash.org/wiki/Building_On_Linux"]https://wiki.gnucash.org/wiki/Building_On_Linux[/URL] I'm confused by these instructions and commands: Open a shell

Re: [GNC] IRC access

2019-03-06 Thread Frank H. Ellenberger
So you are the ideal candidate to do the fine polishing of the page. ;-) Am 06.03.19 um 13:25 schrieb David Carlson: > I like the idea of making the page more useful to persons like me who have > no idea how IRC works yet without 'bloat' or information beyond links to a > few good outside sources

Re: [GNC] MySQL

2019-03-06 Thread Keith Bellairs
gnucash.trace is empty. Of some interest, I did a Save As to sqlite and it worked. So the xml data is acceptable to that DB. XML -> sqlite OK XML -> mysql NG sqlite -> mysql NG I tried to do a Save As from the sqlite db to MySQL. That Save As ground away for a few minutes and then threw the

Re: [GNC] Business Set up

2019-03-06 Thread Adrien Monteleone
You can export and re-import your account structure. I think you’ll have to recreate your business information data, and there is currently no facility to export customers and vendors, but you can import them. So if you manage to create a CSV for your customers and vendors, you can use that

[GNC] Business Set up

2019-03-06 Thread Alan Harris via gnucash-user
I have been using gnucash for several years for our small business.  I would like start fresh due to some errors made several years ago.  Can I copy the current business and zero out the beginning balances or do I need to start from scratch and create a new business?  Can I copy over my current

Re: [GNC] MySQL

2019-03-06 Thread Colin Law
On Wed, 6 Mar 2019 at 15:36, Keith Bellairs wrote: > > Yes, the Save As selection is not grayed out. So I assumed the drivers were > in the Mac package. > > My MySQL instance is up and running. > > But I get a gnc error when I try to do the Save As. > Have a look in the gnucash trace file to see

Re: [GNC] Getting security prices - Funnies

2019-03-06 Thread John Ralls
After installation all of the files are copied to one of the directories in perl's @INC include list. What those directories are depends on the way perl is configured, but if you ran cpan as root then I'd expect them to be in /usr/lib/perl/ or /usr/lib/per5. For non-root installations ~/perl5

Re: [GNC] Fwd: Bonus share entry

2019-03-06 Thread D via gnucash-user
As David says, tab is your friend here. As far as the valuation goes, the additional shares, when added at zero cost to you, will serve to reduce the overall cost basis of the position, which will be reflected in the gain amount when you sell. At least, that's how I understand it. If they are

Re: [GNC] apply coefficient to an account

2019-03-06 Thread Peter Münster
On Wed, Mar 06 2019, elvis wrote: > I have a program in python to add a split like that to a qif file. > [...] > if you are interested let me know. Thanks. But for my usage, it won't work: the split must be done later after importing the bank-files. -- Peter

Re: [GNC] apply coefficient to an account

2019-03-06 Thread Peter Münster
On Tue, Mar 05 2019, Stephen M. Butler wrote: > Oh, are you using a Sqlite data store?  If so, you might be able to > write a query to pull those accounts and apply the percentages.  You > could load the account names and percentages into a new table and drive > the query from there. Thanks,

Re: [GNC] Fwd: Bonus share entry

2019-03-06 Thread Deva -
inues to place 1 in the line below? I've attached an updated pic -- next part -- A non-text attachment was scrubbed... Name: Screenshot_20190306_223604.png Type: image/png Size: 28399 bytes Desc: not available URL: <http://lists.gnucash.org/pipe

Re: [GNC] Fwd: Bonus share entry

2019-03-06 Thread David Carlson
Mageia, There is a trick when manually typing to use the Tab key to traverse the split line to prevent the 1 price from appearing. However, if the bonus shares are a taxable income they should be valued as such so they appear as taxable income at tax time. David Carlson On Wed, Mar 6, 2019 at

Re: [GNC] Fwd: Bonus share entry

2019-03-06 Thread Fred Bone
On Wednesday, March 6, 2019 at 22:38, Gnucash Xboxboy Mageia said: > On Wed, Mar 6, 2019 at 10:22 PM Fred Bone > wrote: > > > On Wednesday, March 6, 2019 at 22:00, Gnucash Xboxboy Mageia said: > > > > [...] > > > Hi Derek, > > > > > > I've attached a picture, I don't think I'm explaining very

Re: [GNC] IRC access

2019-03-06 Thread David Carlson
I like the idea of making the page more useful to persons like me who have no idea how IRC works yet without 'bloat' or information beyond links to a few good outside sources for details beyond basics that is needed to start using the #GnuCash channel. I know that another thing I would like to

Re: [GNC] Fwd: Bonus share entry

2019-03-06 Thread Gnucash Xboxboy Mageia
On Wed, Mar 6, 2019 at 10:22 PM Fred Bone wrote: > On Wednesday, March 6, 2019 at 22:00, Gnucash Xboxboy Mageia said: > > [...] > > Hi Derek, > > > > I've attached a picture, I don't think I'm explaining very well. > > > > Please see attached. > > > > What can I do about that imbalance line? > >

[GNC] Default invoice/statement

2019-03-06 Thread Roger Oliver
Is there a way to move the Fancy invoice/statement layout up to replace the default? The default layout does not allow putting a logo on the masthead. I'm using the last update of version 2 of GnuCash. It's stable and working for us so haven't seen the need to update. Thanks much, Roger Oliver

Re: [GNC] Fwd: Bonus share entry

2019-03-06 Thread Fred Bone
On Wednesday, March 6, 2019 at 22:00, Gnucash Xboxboy Mageia said: [...] > Hi Derek, > > I've attached a picture, I don't think I'm explaining very well. > > Please see attached. > > What can I do about that imbalance line? Delete it, and delete the price and value on the "buy" split.

Re: [GNC] Fwd: Bonus share entry

2019-03-06 Thread Christopher Lam
I wouldn't book this gift of shares as a zero-cost purchase. I'd book it as as a full-priced BUY transaction, but with corresponding account from Income:Gifts rather than Asset:Bank. Because I'm not accountant I don't know what is the tax treatment of this gift and would ensure the Income:Gifts

Re: [GNC] Fwd: Bonus share entry

2019-03-06 Thread Gnucash Xboxboy Mageia
On Wed, Mar 6, 2019 at 9:38 PM Derek Atkins wrote: > The cost may be zero, but the value is not. > Maybe just enter them as 0.01? > > -derek > Sent using my mobile device. Please excuse any typos. > On March 6, 2019 6:07:28 AM Gnucash Xboxboy Mageia > wrote: > > > Hi all, > > I have some bonus

Re: [GNC] Fwd: Bonus share entry

2019-03-06 Thread Derek Atkins
The cost may be zero, but the value is not. Maybe just enter them as 0.01? -derek Sent using my mobile device. Please excuse any typos. On March 6, 2019 6:07:28 AM Gnucash Xboxboy Mageia wrote: Hi all, I have some bonus shares that were issued with no cost to me: I am having trouble

[GNC] Fwd: Bonus share entry

2019-03-06 Thread Gnucash Xboxboy Mageia
Hi all, I have some bonus shares that were issued with no cost to me: I am having trouble entering them without a cost. When I put 0 as the cost, on the next line 1 appears, and I am unable to get rid of it. Perhaps I'm doing this the wrong way, and need to be entering them as a share split? In

Re: [GNC] IRC access

2019-03-06 Thread Frank H. Ellenberger
I am pretty sure the section can be slenderized. You have both not been there, when the attack was waging. I watched lags of several minutes between sending a commnd and seeing its execution. That is the reason why I copied the very first help screens. After setting the moderation flag on the

Re: [GNC] Test email to Mailing List: I've been having Issues Sending to list

2019-03-06 Thread Maf. King
Hi I see it. Maf. On Wednesday, 6 March 2019 10:32:42 GMT Gnucash Xboxboy Mageia wrote: > Hi guys, > just a test email to see if I send to the mailing list: I seem to have been > getting bounced: so I've updated my 'from' address. > > Can one or two kind souls please reply if this comes

[GNC] Test email to Mailing List: I've been having Issues Sending to list

2019-03-06 Thread Gnucash Xboxboy Mageia
Hi guys, just a test email to see if I send to the mailing list: I seem to have been getting bounced: so I've updated my 'from' address. Can one or two kind souls please reply if this comes through on your end? Many thanks, Xboxboy ___ gnucash-user

Re: [GNC] Getting security prices - Funnies

2019-03-06 Thread Eric Coates
John Thanks for the explanations - and the bonus of explaining what the padlock means, the directory belongs (in this case) to root. But, in my ignorance, I don't follow your comment that none of the directories of the form Finance-Quote-1.44-0 are needed after F::Q is installed.

Re: [GNC] apply coefficient to an account

2019-03-06 Thread Liz
On Wed, 6 Mar 2019 17:23:23 +1000 elvis wrote: > Hi Peter, > > I have a program in python to add a split like that to a qif file. > > I had it written to add Australian GST to my transactions after years > of splitting them manually. > > > So I download my bank file, run the program, then