gnucash-user Digest, Vol 134, Issue 35
George Brown
georgebrown5 at googlemail.com
Tue May 20 12:05:21 EDT 2014
Dear All
I will like to know how we can purchase a cd copy of this software for
massive use in Africa through university programmes
On 20 May 2014 17:02, <gnucash-user-request at gnucash.org> wrote:
> Send gnucash-user mailing list submissions to
> gnucash-user at gnucash.org
>
> To subscribe or unsubscribe via the World Wide Web, visit
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> or, via email, send a message with subject or body 'help' to
> gnucash-user-request at gnucash.org
>
> You can reach the person managing the list at
> gnucash-user-owner at gnucash.org
>
> When replying, please edit your Subject line so it is more specific
> than "Re: Contents of gnucash-user digest..."
>
>
> Today's Topics:
>
> 1. Re: GnuCash - suggestion for possible enhancement (Jim Thompson)
> 2. Re: 2.6.3 from GetDeb crashing on Ubuntu 14.04 (Tommy Trussell)
> 3. GNUCash: Employee Reports (Harmanpreet Singh)
> 4. Re: The server at URL mysql://gnucash@192.168.1.80/gnucash
> experienced an error or encountered bad or corrupt data.
> (Aaron Artmann)
> 5. Can't resize window (AC)
> 6. Re: Can't resize window (Lance Edgar)
> 7. Re: Which report to see movement of cash from specific
> account (Derek Atkins)
>
>
> ----------------------------------------------------------------------
>
> Message: 1
> Date: Mon, 19 May 2014 12:27:59 -0500
> From: Jim Thompson <jthomps6 at gmail.com>
> To: gnucash-user at gnucash.org
> Subject: Re: GnuCash - suggestion for possible enhancement
> Message-ID:
> <
> CAAKmR1js22b_3kC9D7wNb-Qt67ECMy7hHc1hQ-4ib_3fxonz3A at mail.gmail.com>
> Content-Type: text/plain; charset=UTF-8
>
> David C,
>
> Btw... as follow-up
>
> -> having a button in the scheduled transaction editor
> -> window to "Enter the Next Scheduled Transaction Now". That may be
> -> easier to implement. Would that work for you?
>
> This sounds like a worthwhile change. Of course I'm just another user -
> but, if there were a list of possible enhancements to vote on, it would be
> interesting to see how this one would fare among those who vote on
> preferred changes. As you might guess, I'd vote for it.
>
> Thanks again for the suggestions.
>
> Cheers,
> Jim
>
>
>
>
> On Sun, May 11, 2014 at 4:38 PM, Jim Thompson <jthomps6 at gmail.com> wrote:
>
> > Wes,
> >
> > Yep - that's a perfectly acceptable solution.
> >
> > Thanks,
> > Jim
> >
> >
> > On Sun, May 11, 2014 at 3:29 PM, Wes Metz <wes704 at gmail.com> wrote:
> >
> >> I do not manually enter transactions that are scheduled. For those that
> >> have variable amounts, I leave the amount blank in the Scheduled
> >> Transactions Template (an approximate amount would work also). The
> >> transactions are posted 30 days in advance. When the bill comes in, I
> find
> >> the transaction in the register and enter the amount.
> >>
> >> If you are having bills come in before the Scheduled Transactions post,
> >> you could post them more that 10 days in advance.
> >>
> >>
> >> On Sun, May 11, 2014 at 2:38 PM, Jim Thompson <jthomps6 at gmail.com>
> wrote:
> >>
> >>> OK, thanks - I'll try to restate this...
> >>>
> >>> Yep, I've found the very handy ways to create Scheduled Transactions
> and
> >>> the cool editor. I have 10 scheduled trans, found the spiffy ways to
> >>> schedule and the templates - all is well there.
> >>>
> >>> 7 of the 10 transactions have amounts that stay the same for a long
> time.
> >>> 3 of them vary slightly from month to month. I've now learned to make
> >>> the
> >>> templates for those 3 just have a dollar amount. For example: PayeeX
> >>> Monthly: 25 ... $123.00
> >>>
> >>> I've also scheduled the above example to post 10 days early - on the
> 15th
> >>>
> >>> Sometimes I notice the bill for PayeeX before the 15th, with an amount
> of
> >>> 123.45 - so instead of waiting to correct the amount later, I'll enter
> >>> the
> >>> 123.45 now.
> >>>
> >>> What Quicken would do is notice that I'm manually posting PayeeX for
> >>> 123.45
> >>> for the 25th and say, "Is this the scheduled payment for PayeeX on
> 25th?"
> >>> If I say, "yes" ... it knows to skip this month's scheduled entry and
> >>> move
> >>> the scheduled payment to next month. Actually Quicken seems to have a
> >>> bit
> >>> of a fudge factor as well... so (another example) if I post a payment
> for
> >>> June 1, it might say, "is this the payment to XYZ scheduled for June
> 3?"
> >>>
> >>> If I don't manually enter the payment, it will automatically post and
> >>> I'll
> >>> fix it later (at least I have an approximate number, so I can see it
> >>> coming).
> >>>
> >>> GC doesn't seem to notice the manual posting of a scheduled tran the
> way
> >>> that Quicken does... so I get both - the manually entered one and the
> >>> (now
> >>> redundant) automatically scheduled one. If I notice two payments of
> >>> PayeeX
> >>> on the same date (123.45 and 123.00) I can just delete the extra one...
> >>> but
> >>> GC would be a bit more clever if it emulated the Quicken trick and
> >>> figured
> >>> out to not post the extra one (after asking me if I'm posting a
> scheduled
> >>> transaction).
> >>>
> >>> Worth the effort to change GC? One can only put the suggestion out
> there
> >>> and see if it gets some interest and enough votes to make it onto a
> list
> >>> of
> >>> enhancements. Perhaps I should post this to a developer list??
> >>>
> >>> Thanks,
> >>> Jim
> >>>
> >>>
> >>>
> >>> On Sun, May 11, 2014 at 6:25 AM, David Carlson
> >>> <david.carlson.417 at gmail.com>wrote:
> >>>
> >>> > On 5/10/2014 8:27 PM, Tommy Trussell wrote:
> >>> > > On Fri, May 9, 2014 at 12:01 PM, Jim Thompson <jthomps6 at gmail.com>
> >>> > wrote:
> >>> > >
> >>> > >> Both Quicken and GC support Scheduled Transactions, but Quicken
> has
> >>> an
> >>> > >> extra feature I've not seen in GC. When one manually enters a
> >>> > transaction
> >>> > >> which is also scheduled (and not yet automatically entered),
> Quicken
> >>> > pops
> >>> > >> up a window and says something like, "is this the scheduled
> >>> transaction
> >>> > for
> >>> > >> xxxx?" If the user replies with "yes" then Quicken knows that
> >>> scheduled
> >>> > >> event is already taken care of and it skips the scheduled one
> >>> (instead
> >>> > of
> >>> > >> entering it a second time).
> >>> > >>
> >>> > >> The lack of this extra check in GC isn't a major pain - just have
> >>> to be
> >>> > >> aware of it.
> >>> > >>
> >>> > >> Why do I manually enter a scheduled transaction? I've scheduled
> the
> >>> > >> transaction as a reminder, in case I forget to enter a monthly
> >>> bill...
> >>> > but
> >>> > >> these tend to be transactions where the amount can vary a little
> bit
> >>> > each
> >>> > >> month. If I notice the actual bill amount before the automated
> >>> entry,
> >>> > I'll
> >>> > >> just plug it in... otherwise I correct it later. Quicken just
> >>> helped a
> >>> > bit
> >>> > >> by noticing the manual entry might be the scheduled one...
> >>> > >>
> >>> > > Here's a feature you may not have noticed in GnuCash --
> >>> > >
> >>> > > Enter a transaction in your checking or credit account register,
> then
> >>> > click
> >>> > > on it (or any existing transaction) and choose the menu item:
> >>> > >
> >>> > > Actions --> Schedule...
> >>> > >
> >>> > > and you will activate the Schedule Transaction dialog, with all the
> >>> > > information copied from the existing transaction. If you choose
> >>> > Frequency:
> >>> > > "Monthly" (for example) you will notice the scheduled transaction
> >>> > defaults
> >>> > > with a date one month in the future from the selected transaction.
> >>> If you
> >>> > > click the "Advanced..." button you will see that you can then
> modify
> >>> the
> >>> > > parameters to adjust how weekends are handled, or choose a
> different
> >>> day
> >>> > of
> >>> > > the month, etc.
> >>> > >
> >>> > > I know this is "backwards" from what you are used to in Quicken,
> but
> >>> it's
> >>> > > actually a bit easier because it's MUCH easier to assign the credit
> >>> and
> >>> > > debit columns correctly in the "live" register than in the
> Scheduled
> >>> > > Transaction register. (The scheduled transaction register is
> >>> intended to
> >>> > be
> >>> > > a template so it allows you to enter variables or numbers that
> don't
> >>> add
> >>> > > up, so you have to supply the variables or "adjust" the scheduled
> >>> > > transaction after it gets created.
> >>> > >
> >>> > > Give it a try, and you may decide you prefer the "GnuCash way." :-)
> >>> > >
> >>> > >
> >>> > >
> >>> > >> -----
> >>> > >> 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 at 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.
> >>> > >
> >>> >
> >>> > I always use that method to create scheduled transactions in GnuCash
> >>> and
> >>> > I love it.
> >>> >
> >>> > If a transaction that has been created by the "Since Last Run"
> >>> assistant
> >>> > is right clicked and scheduleed, the scheduled transaction opens in
> the
> >>> > Scheduled Transaction editor. This makes it easy to modify settings,
> >>> if
> >>> > desired. I often change some of the text for the next instance, say
> in
> >>> > the memo or description. The only downside is that using that
> >>> procedure
> >>> > does not work if the original transaction is right-clicked.
> >>> >
> >>> > David C
> >>> > _______________________________________________
> >>> > gnucash-user mailing list
> >>> > gnucash-user at 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 at 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.
> >>>
> >>
> >>
> >
>
>
> ------------------------------
>
> Message: 2
> Date: Mon, 19 May 2014 15:40:33 -0500
> From: Tommy Trussell <tommy.trussell at gmail.com>
> To: Colin Law <clanlaw at gmail.com>
> Cc: "gnucash-user at gnucash.org" <gnucash-user at gnucash.org>
> Subject: Re: 2.6.3 from GetDeb crashing on Ubuntu 14.04
> Message-ID:
> <CABNyZMxq3hFV27mRyR6upYipWmQsLGeXDds+TULw0=
> BFrRsksQ at mail.gmail.com>
> Content-Type: text/plain; charset=UTF-8
>
> Just a couple of updates on the original topic of this thread:
>
> 1) As others have noted, the getdeb package 1:2.6.3-1~getdeb3~saucy
> for amd64 Ubuntu 14.04 crashes on exit. I just installed it on a
> newly-upgraded 14.04 system and confirmed it (despite purging and
> other suggested remedies), so I reported the crash to the getdeb
> "package ninjas," and Christoph Korn wrote back confirming the crash.
> Christoph had me install gnucash-dbg and dbg (gnu debugger) and to
> confirm he and I are seeing the same crash. SO that package may get
> updated once he determines the cause.
>
> 2) I volunteered to collect information to prepare to open a SRU
> request to update Ubuntu 14.04 with GnuCash 2.6.3, and I assembled a
> list of bugs and hopefully at least one of them will be easy to test.
> I will create a separate thread on the gnucash-user list for the SRU
> soon. If someone else -- especially someone with more technical
> expertise -- has started that process, too, feel free to write me
> off-list and I will share what I have.
>
> (I remembered a serious issue with transactions being hidden or not
> editable in a 2.6.x version BUT after a lot of searching I think I
> found it and it was fixed in 2.6.1 -- bugzilla #721290. SO unless I am
> mistaken it's not relevant to this proposed SRU.)
>
>
> ------------------------------
>
> Message: 3
> Date: Mon, 19 May 2014 17:15:23 +0530
> From: Harmanpreet Singh <harman052 at gmail.com>
> To: gnucash-user at gnucash.org
> Subject: GNUCash: Employee Reports
> Message-ID:
> <CANyDKBC3Ui3ZZ8o4DHaY7nccoW1=
> GaFCXHmChO+kEhR4_GLuqg at mail.gmail.com>
> Content-Type: text/plain; charset=UTF-8
>
> I just started using GNUCash for my startup business and now facing
> few problems with 'employee reports'.
>
> I want to generate report for each employee that would include all
> types of payments paid to him (monthly salary, conveyance charges)
> right from the date of his joining.
>
> I am aware about the process payment option under Business > Employee
> > Process Payment but I am not sure if it is a correct way to record
> their salaries. Further, I read GNUCash documentation, they said, in
> order to pay employee make a split transaction. If I move as per the
> documentation still am not able to see all payments made to employee.
>
> Please let me know if I am missing or doing something wrong.
>
> Thanks!
> --
> Harmanpreet Singh
> Blog: http://singhharman.wordpress.com/
>
>
> ------------------------------
>
> Message: 4
> Date: Mon, 19 May 2014 21:10:18 -0500
> From: Aaron Artmann <aartmann at comcast.net>
> To: Aaron Artmann <aartmann at comcast.net>
> Cc: gnucash-user at gnucash.org
> Subject: Re: The server at URL mysql://gnucash@192.168.1.80/gnucash
> experienced an error or encountered bad or corrupt data.
> Message-ID:
> <
> CAB4+JhNQu+UsTTgMzCi7GxbjRXzqepSCx0gyWLdM3Qw-DVb9PA at mail.gmail.com>
> Content-Type: text/plain; charset=UTF-8
>
> I just wanted to let everyone know that I have fixed the problem and
> Gnucash is working great for me again. There was an extra column in
> the gnclock table which was messing up Gnucash. I removed it and
> tried to connect again and bam it worked.
>
> Thank you for all your assistance in solving this problem.
>
> Aaron
>
> On Mon, May 12, 2014 at 9:13 AM, Aaron Artmann <aartmann at comcast.net>
> wrote:
> > On May 12, 2014 1:24 AM, "Colin Law" <clanlaw at gmail.com> wrote:
> >>
> >> On 12 May 2014 01:28, Aaron Artmann <aartmann at comcast.net> wrote:
> >> > On Sun, May 11, 2014 at 9:48 AM, Colin Law <clanlaw at gmail.com> wrote:
> >> >> On 11 May 2014 15:25, Aaron Artmann <aartmann at comcast.net> wrote:
> >> >>> ...
> >> >>> I think the problem lies in the database data itself because I can
> >> >>> create new tables and use them but once I import a backup to the
> >> >>> database it becomes not useable. I don't want to restart everything
> >> >>> over again but if I can not get it to work once its imported then I
> am
> >> >>> going to have to. The data was backed up with MySQL Dumper but now
> it
> >> >>> will not work because something with gzopen(). I will have to
> >> >>> research more.
> >> >>>
> >> >>
> >> >> I had not realised you are trying to connect to an existing database.
> >> >> To check GC is ok then open it and (if it does not open with the new
> >> >> accounts file wizard) then use File New to start the wizard and run
> >> >> through accepting he defaults to create a basic set of accounts.
> Then
> >> >> try and save that to the mysql server. That will confirm that GC is
> >> >> ok. Also shut down GC and re-open and check you can access the db
> >> >> again.
> >> >>
> >> >> An easy way to move the data from one mysql server to another
> >> >> (assuming that is what you are trying to do) is to open GC on the old
> >> >> one and then save the file in XML format. Move that file to the new
> >> >> machine and open it in GC there, then save it as mysql to the new
> >> >> server.
> >> >>
> >> >> Colin
> >> >>
> >> >> Colin
> >> >
> >> > I apologize about that, I tried to remember to get everything in to
> >> > the first email. The database was lost because the drive that was in
> >> > the computer died. I had reloaded it and was trying to put the backup
> >> > back in. Then MySQL Dumper didn't work and I figured out how to
> >> > import it via the command line. Still having problems but I did two
> >> > backups that day so I am going to try the other one. GC is able to
> >> > create the tables and other information that it needs within the
> >> > database but when I try and use information I have imported then I get
> >> > that error.
> >>
> >> OK, so the problem is with the data in the db, not with GC itself or
> >> access to the db.
> >>
> >> Colin
> >
> > That is correct. If I have any further questions I will reply to this
> > message.
> >
> > Thanks for your assistance
> >
> > Aaron
>
>
> ------------------------------
>
> Message: 5
> Date: Mon, 19 May 2014 21:09:48 -0700
> From: AC <gnucash at acarver.net>
> To: GnuCash users group <gnucash-user at gnucash.org>
> Subject: Can't resize window
> Message-ID: <537AD58C.7000303 at acarver.net>
> Content-Type: text/plain; charset=ISO-8859-1
>
> I just moved over to a new computer and installed 2.6.3 for Windows on
> it. Then I brought over my data file from the old computer. For some
> reason now the window is oversized horizontally (wider than the monitor)
> and I can't resize it in that direction. I can resize it vertically.
> It looked fine on the old machine which was set for the same screen
> resolution.
>
> I've already done several Google searches and most of them suggest some
> entry in the data file is excessively long preventing the screen from
> resizing. However, I made a quick scan of the file and nothing seems
> out of the ordinary. I currently only have ledgers, nothing else (like
> reports, invoices, etc.)
>
> I'm not sure what else to do to figure out the problem. It's completely
> unusable as is, the window is almost 50% bigger than the screen.
>
>
> ------------------------------
>
> Message: 6
> Date: Tue, 20 May 2014 07:27:56 -0700
> From: Lance Edgar <lance at edbob.org>
> To: AC <gnucash at acarver.net>, GnuCash users group
> <gnucash-user at gnucash.org>
> Subject: Re: Can't resize window
> Message-ID: <537B666C.1000909 at edbob.org>
> Content-Type: text/plain; charset=ISO-8859-1; format=flowed
>
> On 05/19/2014 09:09 PM, AC wrote:
> > I just moved over to a new computer and installed 2.6.3 for Windows on
> > it. Then I brought over my data file from the old computer. For some
> > reason now the window is oversized horizontally (wider than the monitor)
> > and I can't resize it in that direction. I can resize it vertically.
> > It looked fine on the old machine which was set for the same screen
> > resolution.
>
> I can't tell if this will work for your situation or not, but have you
> tried using the keyboard to resize the window horizontally? E.g.
> something like:
>
> ALT+SPACE .. "S" .. RIGHT-ARROW .. LEFT-ARROW-UNTIL-YOU-SEE-THE-EDGE
>
> Lance
>
>
> > I've already done several Google searches and most of them suggest some
> > entry in the data file is excessively long preventing the screen from
> > resizing. However, I made a quick scan of the file and nothing seems
> > out of the ordinary. I currently only have ledgers, nothing else (like
> > reports, invoices, etc.)
> >
> > I'm not sure what else to do to figure out the problem. It's completely
> > unusable as is, the window is almost 50% bigger than the screen.
> > _______________________________________________
> > gnucash-user mailing list
> > gnucash-user at 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.
> >
>
>
> ------------------------------
>
> Message: 7
> Date: Tue, 20 May 2014 11:35:26 -0400
> From: Derek Atkins <warlord at MIT.EDU>
> To: samalex <samalex at gmail.com>
> Cc: gnucash-user at gnucash.org
> Subject: Re: Which report to see movement of cash from specific
> account
> Message-ID: <sjm8upwea4h.fsf at mocana.ihtfp.org>
> Content-Type: text/plain
>
> Hi,
>
> samalex <samalex at gmail.com> writes:
>
> > I understand that transferring money between accounts won't show-up in a
> Cash
> > Flow report, but that's basically what I need though I'm unsure how to
> see
>
> You understand incorrectly. The Cash Flow report exactly shows you the
> flow of cash into and out of a (set of) account(s). Imagine that you
> lay all your accounts on a table and draw a circle around the "chosen"
> set of accounts. The Cash Flow report will show you all transactions
> that cross that line. It will not show you any transactions that are
> purely inside the circle, nor will it show you any tranasctions that are
> purely outside the circle.
>
> SO.. If you want to see how you're spending money from a particular
> account then run a Cash Flow report purely on that single account.
>
> > it. I want a report that has exactly what the Cash Flow report shows for
> > any given account, but I also need it to show monies going into other
> > accounts. Basically I'm trying to compare what's moving into and out of
> my
> > Checking account for the month to see what the difference is. If the
> Cash
> > Flow report would just let me add account transfers it'd be perfect, but
> I
> > see it won't do that by design. Any way to do this in another report?
>
> If you want to see transfers then don't include the other end of the
> transfer account in the Cash Flow account selection.
>
> OR... Are you trying to see your total amount of Income and Expense --
> which would be an Income Statement (Profit & Loss) report.
>
> > Thanks for any suggestions. Thanks.
>
> > 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
> warlord at MIT.EDU PGP key available
>
>
> ------------------------------
>
> Subject: Digest Footer
>
> _______________________________________________
> gnucash-user mailing list
> gnucash-user at gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>
>
> ------------------------------
>
> End of gnucash-user Digest, Vol 134, Issue 35
> *********************************************
>
More information about the gnucash-user
mailing list