Locked database

classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|

Locked database

Robert Williams-8
For no apparent reason, Gnucash is now unable to open my database,
giving the Question:

       "GnuCash could not obtain the lock for /home/finance/nnn.
 That database may be in use by another user, in which case you should
                         not open the database.
                      What would you like to do?"

I don't want to take the 'Quit' option, so I click on Open Anyway. The
database appears to open to the point where I am informed of pending
scheduled entries, when the whole application immediately closes.

I've tried the third option of Create New File, to get GnuCash running,
and then attempting to open the locked database from there, but the same
thing happens.

Although there are two other accounts on this machine, I am effectively
the only user, and the above scenario happens even if GnuCash is the
first application I attempt to open after a reboot.

Any ideas, please?
--
Bob Williams                  mailto:[hidden email]
Henfield, West Sussex                             Fax to: 0870 051 0048

PGP Key <mailto:[hidden email]?SUBJECT=GET%0xAC251C04>
_______________________________________________
gnucash-user mailing list
[hidden email]
https://lists.gnucash.org/mailman/listinfo/gnucash-user
Reply | Threaded
Open this post in threaded view
|

Re: Locked database

Neil Williams-2
On Wednesday 08 June 2005 7:33 pm, Bob Williams wrote:
> I've tried the third option of Create New File, to get GnuCash running,

Turn off the scheduled transaction processing and then open the file. It
sounds like one of the scheduled transaction records has gone awry. Go to the
Preferences, click on Scheduled Transactions and uncheck the "Run on GnuCash
start" option.

GnuCash locks the data file whilst it is in use and if GnuCash crashes, the
lock remains in place.

--

Neil Williams
=============
http://www.data-freedom.org/
http://www.nosoftwarepatents.com/
http://www.linux.codehelp.co.uk/


_______________________________________________
gnucash-user mailing list
[hidden email]
https://lists.gnucash.org/mailman/listinfo/gnucash-user

attachment0 (196 bytes) Download Attachment
Reply | Threaded
Open this post in threaded view
|

Re: Locked database

Stephan Pouh
In reply to this post by Robert Williams-8
Bob,

When openening teh database gnusach creates 2 files in the directory where
your data file is located to ensure the data is worked on by one instance of
the program only. If GnuCash crashes (I assume that is what happened) there
is no time to delete the files. Delete them and your file is no longer "used
by another user".

They are yourfilename.lck and yourfilename.XXXXX.XXXXX.lnk where X is a
number.

Works for me every time.

Regards,

Stephan

On Sunday 03 July 2005 19:51, [hidden email] wrote:

> Send gnucash-user mailing list submissions to
> [hidden email]
>
> 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
> [hidden email]
>
> You can reach the person managing the list at
> [hidden email]
>
> When replying, please edit your Subject line so it is more specific
> than "Re: Contents of gnucash-user digest..."
>
>
> Today's Topics:
>
>    1. Re: Use case: rebates (Mark G. Woodruff)
>    2. Re: Operation Sugar-Daddy (Jim Sculley)
>    3. Re: Giving up on Gnucash (Jim Sculley)
>    4. finance::quote? (Zep)
>    5. Business Fenctions in the database (Renata Auchimik)
>    6. GnuCash Crash when I try to create a report ([hidden email])
>    7. loans (JBW)
>    8. Dispaly Euro  (Michele Mencacci)
>    9. Currency symbol (Bob Williams)
>   10. Thanks GNUCash (Erik Evenson)
>   11. Locked database (Bob Williams)
>   12. reconciling (Matt Funk)
>   13. GNUCash for member accounting? ([hidden email])
>   14. Printing a Register in a restricted date range (Frances Lowe)
>   15. gnucash how to switch commodity from ROL to RON? (vaida bogdan)
>   16. Re: Use case: rebates (Neil Williams)
>   17. Re: Locked database (Neil Williams)
>   18. Re: Thanks GNUCash (Neil Williams)
>
>
> ----------------------------------------------------------------------
>
> Message: 1
> Date: Sun, 3 Jul 2005 08:48:43 -0700 (PDT)
> From: "Mark G. Woodruff" <[hidden email]>
> Subject: Re: Use case: rebates
> To: [hidden email]
> Cc: "Mark G. Woodruff" <[hidden email]>
> Message-ID: <[hidden email]>
> Content-Type: text/plain; charset=iso-8859-1
>
> --- Neil Williams <[hidden email]> wrote:
> > | * the sales tax paid on it as both part of its
> >
> > cost
> >
> > | basis and as something I can get a report on at
> >
> > the
> >
> > | end of the year
> >
> > capital cost to Assets and the tax to an Expense -
>
> Sales tax isn't an expense, it's part of the cost
> basis, governed by a tax policy.
>
> I suggest a better way to handle it is to have a flag
> indicating whether an item is taxable or not, and then
> allow the user to enter their local sales tax terms.
> If an item is taxable, and the local tax is 5%, then
> any call to obtain an items cost would be mutiplied by
> 1.05.
>
> > | * the terms of the purchase, when the payment will
> >
> > be
> >
> > | due on my credit card
> >
> > That is best done in the reconcile dialog.
>
> That's after the fact.
>
> Terms of credit are established before, or during a
> purchase. That is, if I create a Credit Card account,
> I should be able to enter the terms, e.g.:
>
> 12% annual, payments due the first business of the
> month, new purchases included in the interest
> calculations, cash advances charged 24% annual, etc.
>
> I'd like to know today if I would be better off buying
> this on Credit Card V or Credit Card M. Would I save
> money by buying it on Card V, even though it has a
> higher base interest rate, because I'll be able to pay
> off Card M, which has a cash advance still sitting on
> it?
>
> Credit terms are fairly standardized now. Requires a
> lot of user entry, but only one time. Each time they
> change their terms. :-)
>
> > | * the terms of the rebate
> >
> > A scheduled transaction?
>
> Nope. An Account Receivable. It goes on the book as
> having value.
>
> Accounts Payable (Credit Cards, Notes) and Accounts
> Receivable all have terms. If I buy something on 2/10,
> net 30 (2% discount if paid within 10 days, net if
> paid in 30, 18% annual after that) I need to know
> that. I also need to know if I'm better off paying
> early and getting the discount, or paying another
> account (Card V) and avoiding it's interest
> completely.
>
> > | There seems to be a fundamental difference between
> > | tasks that real people do that need to be modeled
> >
> > in
> >
> > | an accounting program (buying a product at Best
> >
> > Buy or
> >
> > | Circuit City), and how it's handled in an
> >
> > accounting
> >
> > | program. So far, GnuCash is very model-centric.
> >
> > And that is a GOOD THING. It's always good to follow
> > 'best practice'!
>
> Doing the one part of a best practice isn't the same
> as doing the whole.
>
> For example,
>
> GnuCash's Balance Sheets are totally fubar'd. For a
> balance sheet (and double entry accounting) to be
> meaningful, everything must follow the cost principle.
>  If I buy two things today for $1, and sell one
> tomorrow for $0.50, my one thing remaining should
> still be on the books at $1. Market value does not
> belong on a balance sheet (unless an asset is
> impaired, of course)!
>
> > If you approach your accounts as an accountant would
> > do, you will find GnuCash does
> > precisely what your accountant would expect.
>
> GnuCash does some things an accountant would expect,
> and some that are totally wrong. Making the former
> easier to use is helpful; defending the latter is not.
>
> > Not true. Quicken sacrifices 'best practice' on the
> > altar of convenience
> > and you've only just moved from that program, so
> > it's hardly a model for
> > GnuCash!
>
> Didn't suggest it was. Quicken was and is a mess. Yet,
> usability is of essential value. A hammer with a knife
> sharp handle may still elegantly employ the principle
> of leverage, but is useless as a hammer.
>
> Making it easier to do what is right is a noble goal
> for us all.
>
> Mark
>
> __________________________________________________
> Do You Yahoo!?
> Tired of spam?  Yahoo! Mail has the best spam protection around
> http://mail.yahoo.com
>
>
> ------------------------------
>
> Message: 2
> Date: Fri, 22 Apr 2005 18:12:22 -0400
> From: Jim Sculley <[hidden email]>
> Subject: Re: Operation Sugar-Daddy
> To: [hidden email]
> Message-ID: <[hidden email]>
> Content-Type: text/plain; charset=ISO-8859-1; format=flowed
>
> Rod Engelsman wrote:
>  > At this point I am looking at either KMymoney, running MSMoney under
>  > wine, or just chucking it all and going back to Winders.
>
> You may want to have a look at Moneydance.
>
> http://moneydance.com/
>
> Note:  I'm not affiliated with them, I just know of them.
>
> Jim S.
>
> P.S.  I'm currently 'porting' GC to Java as a personal time-wasting
> project.
>
>
>
> ------------------------------
>
> Message: 3
> Date: Sun, 24 Apr 2005 13:46:14 -0400
> From: Jim Sculley <[hidden email]>
> Subject: Re: Giving up on Gnucash
> Cc: [hidden email]
> Message-ID: <[hidden email]>
> Content-Type: text/plain; charset=ISO-8859-1; format=flowed
>
> Neil Williams wrote:
> > On Saturday 23 April 2005 5:47 pm, Stephen Fisher wrote:
> >>Getting X11 up and running is easy. It's on
> >>the OSX disks you install it and done. With openoffice, you download a
> >>.dmg file, run the OSX type installer, click through a few buttons and
> >>done.
> >
> > That's because of Java. You can't compare OOo with any other application,
> > Mac or GNU, only with other Java apps and there aren't that many.
>
> OpenOffice is a C++ app.  It's not written in Java.
>
>
>
>
> ------------------------------
>
> Message: 4
> Date: Fri, 29 Apr 2005 20:00:05 -0400
> From: Zep <[hidden email]>
> Subject: finance::quote?
> To: [hidden email]
> Message-ID: <[hidden email]>
> Content-Type: text/plain; charset=us-ascii
>
>
> I can't seem to make finance::quote work... I've installed
> at least 2 different versions.  using regular cpan install shell,
> download/make locally and the update script included with gnucash.
> At first, perldoc wouldn't give back anything, but now it does..
> the dump-finance-quote script seems to run fine, but gnucash thrusts
> it's fists against the posts and still insists... that it isn't there
> or working.  can you give me some means of forcing it to know that it's
> OK?
> --
>                                              - Zep
>                                       ([hidden email])
>
> my hovercraft is full of eels.
>
>
> ------------------------------
>
> Message: 5
> Date: Wed, 04 May 2005 14:47:41 +0100
> From: Renata Auchimik <[hidden email]>
> Subject: Business Fenctions in the database
> To: [hidden email]
> Message-ID: <[hidden email]>
> Content-Type: text/plain; charset=us-ascii; format=flowed
>
> I am looking for an accounting package that would allow me to
> import/export data freely.
>
> I have heard that not all business functionalities are
> incorporated into the database that drives gnu cash.
> Unfortunately, I could not find detailed information on what is
> outstanding.
>
> Please point me to what is outstanding and need to be
> incorporated into the database.
>
> --
> Kind Regards,
>
> Renata
>
>
> ------------------------------
>
> Message: 6
> Date: Mon, 9 May 2005 12:47:18 -0400
> From: <[hidden email]>
> Subject: GnuCash Crash when I try to create a report
> To: [hidden email]
> Message-ID: <[hidden email]>
> Content-Type: text/plain; charset=us-ascii
>
> Have loaded GnuCash 1.8.9 onto my Mac G3 running OS
> 10.3.9. Works great, except for two problems.
>
> 1. When I try to create a report (or do anything under
> the "report" menu) the program crashes, closing all the
> windows and disappearing.
>
> Since that first happened, I ge an error message when I re-
> open my data file:
>
> 2.  "... can't obtain the lock for <data file>... Do you want to
> continue?" Is this a problem?
>
> Suggestions greatly appreciated,
>
> Bill.
>
>
> ------------------------------
>
> Message: 7
> Date: Mon, 16 May 2005 14:48:32 +1000
> From: JBW <[hidden email]>
> Subject: loans
> To: [hidden email]
> Message-ID: <[hidden email]>
> Content-Type: text/plain; charset=us-ascii; format=flowed
>
> I'm trying to figure out how to handle loans in GnuCash. I've read the
> tutorial but the method described does not really suit me.
> The main problem is that it says Interest should be registered as an
> expense. This however is not the case with me. Interest charges and loan
> repayments are separate transactions of differing values. My expense is
> the loan repayment, not the interest charge.
>
> For example, on the 10th April I want to move $500 from my Asset named
> "Bank Account" to reduce my Liability named "Mortgage Balance". But I
> ALSO want this amount to show up as an Expense named "Mortgage
> Repayment". This little equation has three sides, thus I am having
> trouble dealing with it.
>
> Then on the 20th April I want the Liabilty named "Mortgage Balance" to
> increase by $450 (interest charges levied), but there is not really a
> balancing account that I can see. The balance just increases when the
> interest charge is levied against my mortgage account. There is no
> Expense involved.
>
> Does Equity somehow play a part in handling the transactions in the way
> I want?
> How do I deal with these transactions in the way I want?
>
>
>
>
> ------------------------------
>
> Message: 8
> Date: Mon, 16 May 2005 20:20:02 +0200
> From: Michele Mencacci <[hidden email]>
> Subject: Dispaly Euro
> To: [hidden email]
> Message-ID: <[hidden email]>
> Content-Type: text/plain; charset=ISO-8859-1; format=flowed
>
> Hello there!
> I have gnucash 1.8.9 working (the debian pkg), I downloaded the new one
> and the CVS too, but I am not able to get the
> euro sign, or better in account windows it works, it's only in reports I
> get _00.00.
> During configuration all is ok.....where is the problem?
> For to compile it I got all packages from debian site.
> Greetings
>
>                                    Mike
>
>
> ------------------------------
>
> Message: 9
> Date: Thu, 19 May 2005 16:06:05 +0100
> From: Bob Williams <[hidden email]>
> Subject: Currency symbol
> To: GnuCash mailing list <[hidden email]>
> Message-ID: <1116515165.10255.14.camel@Vigor10>
> Content-Type: text/plain
>
> I'm new to linux and have just started using Gnucash 1.8.8 which is the
> version shipped with SuSE 9.2.
>
> Very pleased with it, and much easier to understand than Microsoft
> Money. However, I'm using the GBP currency (naturally, as I live in UK)
> but the pound sign displays with a capital A in front of it. Moreover,
> the A has a little hat on, in the form of a carat symbol [Shift 6]. This
> is very distracting. Has anyone else come across this problem? Any
> suggestions on how to correct the display?
> --
> Bob Williams
>
> PGP Key <mailto:[hidden email]?SUBJECT=GET%0xAC251C04>
>
>
> ------------------------------
>
> Message: 10
> Date: Sun, 22 May 2005 22:07:09 -0500 (GMT-05:00)
> From: Erik Evenson <[hidden email]>
> Subject: Thanks GNUCash
> To: [hidden email]
> Message-ID:
> <[hidden email]>
>
> Content-Type: text/plain; charset=us-ascii
>
> GNUCash Developers,
>
> Thanks.
>
> For some time now I have been a reasonably happy Quicken 2002 user.  The
> program was adequate and served my needs.  Then Intuit pulled the plug on
> downloading stock quotes in an effort to strong arm me into buying a new
> version.  Perfectly within their rights, but it tweaked me nonetheless.
> Providing stock quotes doesn't cost them a dime.  So I trashed Quicken, the
> last application keeping me from using Linux full time.  I apt-get'ed
> GNUCash on my next Debian boot.
>
> GNUCash is good and the price is right.  Without it, I'd have to buy
> Quicken 2005, which is loaded with ad-ware, perpetuates my need for
> proprietary software, and eventually will "sunset" itself.
>
> What I like about GNUCash:
>
> - It doesn't coddle me.  Strict double-entry accounting is appreciated by
> this MBA.  Keeps me from making mistakes.  There's a reason double-entry
> accounting has been used ever since those monks back in the 1300's invented
> it.
>
> - It's interface is simple and direct -- appreciated by this Engineer.
>
> - It will always be there -- GNUCash has no "sunset."  Quicken's biggest
> problem was that they completed the necessary features in the code years
> ago.  There was just nothing left to add and therefore upgrade to.
>
> What I don't like about GNUCash:
>
> - I would never recommend this program to "normal" users.  First of all,
> they have to use Linux, which is not quite ready for the consumer desktop.
> That, and neither is GNUCash's UI.  Don't get me wrong -- I love it.  But
> there needs to be (maybe) a fork that targets the consumer.
>
> - Flipside of the previous: it doesn't have a command line interface.  Gosh
> that would be nice when I'm ssh-ing into my Debian server box.
>
> - It doesn't run on Cygwin.  I know there is a good reason, but I don't
> know what it is.  If it did run on Cygwin, I could use GNUCash on my
> laptop, which is hopelessly locked into an MS OS.
>
> - A calendar display of balances like Quicken 2002 had.  Gosh, this was key
> to me managing my personal checking account.  I miss it.
>
> Nevertheless, a big thank-you.  If I knew who you were, I'd buy you a beer.
>  I have great hopes for GNUCash's future.
>
>
> ------------------------------
>
> Message: 11
> Date: Wed, 08 Jun 2005 19:33:27 +0100
> From: Bob Williams <[hidden email]>
> Subject: Locked database
> To: GnuCash mailing list <[hidden email]>
> Message-ID: <1118255608.16035.11.camel@Vigor10>
> Content-Type: text/plain
>
> For no apparent reason, Gnucash is now unable to open my database,
> giving the Question:
>
>        "GnuCash could not obtain the lock for /home/finance/nnn.
>  That database may be in use by another user, in which case you should
>                          not open the database.
>                       What would you like to do?"
>
> I don't want to take the 'Quit' option, so I click on Open Anyway. The
> database appears to open to the point where I am informed of pending
> scheduled entries, when the whole application immediately closes.
>
> I've tried the third option of Create New File, to get GnuCash running,
> and then attempting to open the locked database from there, but the same
> thing happens.
>
> Although there are two other accounts on this machine, I am effectively
> the only user, and the above scenario happens even if GnuCash is the
> first application I attempt to open after a reboot.
>
> Any ideas, please?
> --
> Bob Williams                  mailto:[hidden email]
> Henfield, West Sussex                             Fax to: 0870 051 0048
>
> PGP Key <mailto:[hidden email]?SUBJECT=GET%0xAC251C04>
>
>
> ------------------------------
>
> Message: 12
> Date: Fri, 10 Jun 2005 11:40:36 -0600
> From: Matt Funk <[hidden email]>
> Subject: reconciling
> To: [hidden email]
> Message-ID: <[hidden email]>
> Content-Type: text/plain;  charset="us-ascii"
>
> Hi,
>
> i had a (probably pretty simple/stupid) question.
>
> The problem/question is this:
> say that i bought some groceries for $50 where groceries is an expense
> account. And say i pay for it with a check that comes out of my checking
> account.
>
> So far no problem. Both acounts get credited/debited.
> However, say now that i download the account statement from my bank and i
> try to import it to the checking account i have in gnucash.
>
> How does gnucash reconcile the bank statement with the already existing
> entry/entires (done manually) in the checking account account?
>
> or should i wait to credit the checking account and use a temporary account
> (imbalance)?
>
> thanks
> mat
>
>
> ------------------------------
>
> Message: 13
> Date: Sat, 18 Jun 2005 22:30:50 -0500
> From: [hidden email]
> Subject: GNUCash for member accounting?
> To: [hidden email]
> Message-ID:
> <[hidden email]>
>
> Content-Type: text/plain; charset="us-ascii"
>
> I have a simple member accounting task and  wonder if GNUCash can help me.
>
> I am looking for system to handle the income and expenses (about 5 - 10
> transactions a month) of 1000 members.
> All the transactions of these 1000 members are send to me in an XML file.
> This file can easily be converted to CSV or OFX.
>
> My question:
> 1. Can I use GNUCash to import these transaction and post them according
> to the member's account and offset it to a bank account.  If this is
> feasible, how easy or difficult it is to set this up?  Can I create 1000
> accounts by importing a text file?
>
> 2. At the end of the month, I would like to bring the balances of each
> member account to zero(using a script?).  Also I would like to generate a
> text file (preferably XML) with one entry for each member of the credit or
> the charge amount needed to bring the account to zero.
>
> Any suggestions, help would be greatly appreciated.
>
> Thanks in advance
> Norman
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL:
> http://lists.gnucash.org/pipermail/gnucash-user/attachments/20050618/651c1b
>d4/attachment-0001.htm
>
> ------------------------------
>
> Message: 14
> Date: Mon, 20 Jun 2005 10:32:42 -0600
> From: Frances Lowe <[hidden email]>
> Subject: Printing a Register in a restricted date range
> To: [hidden email]
> Message-ID: <[hidden email]>
> Content-Type: text/plain
>
> Dear User,
>
> Please look into the following problem:
>
> I would like to print a Register for  a restricted date range (example:
> a bank register for the month of March).  When I attempt to print, the
> system crashes and gnucash closes down.
>
> Please help with this problem.
>
> Thanks.
> Frances
>
>
>
> ------------------------------
>
> Message: 15
> Date: Sat, 2 Jul 2005 16:29:10 +0000
> From: vaida bogdan <[hidden email]>
> Subject: gnucash how to switch commodity from ROL to RON?
> To: [hidden email]
> Message-ID: <[hidden email]>
> Content-Type: text/plain; charset=ISO-8859-1
>
> I'm facing a little problem using gnucash:
>
> Romania is in the process of switching from ROL to RON commodity. 1
> RON = 10000 ROL. There are 2 problems I'm facing:
>
> 1.
>
> RON doesn't exist yet in the commodity list. When will it be added?
>
> 2.
>
> All my money in gnucash shows in ROL and now I have to switch it to
> RON.  How do I do that?
>
> Please cc me the answer as I'm not subscribed to this list.
>
> Thanks in advance,
>   Vaida Bogdan
>
>
>
> ------------------------------
>
> Message: 16
> Date: Sun, 3 Jul 2005 18:34:19 +0100
> From: Neil Williams <[hidden email]>
> Subject: Re: Use case: rebates
> To: [hidden email]
> Message-ID: <[hidden email]>
> Content-Type: text/plain; charset="iso-8859-1"
>
> On Sunday 03 July 2005 4:48 pm, Mark G. Woodruff wrote:
> > --- Neil Williams <[hidden email]> wrote:
> > > | * the sales tax paid on it as both part of its
> > >
> > > cost
> > >
> > > | basis and as something I can get a report on at
> > >
> > > the
> > >
> > > | end of the year
> > >
> > > capital cost to Assets and the tax to an Expense -
> >
> > Sales tax isn't an expense,
>
> It is in the UK, hence the difficulties of a portable implementation. Only
> larger businesses need to handle VAT calculations. To most UK account
> holders, VAT is an expense - part of the retail price of the item to such
> an extent that if an item is £10 without VAT, the customer is charged
> £11.75 and £11.75 goes into the Expense for that purchase. There is no
> separate sales tax accounting for most people in the UK.
>
> > I suggest a better way to handle it is to have a flag
> > indicating whether an item is taxable or not,
>
> ?? You appear to want inventory management. GnuCash does not do inventory,
> as yet. There is work being done on that.
>
> > Terms of credit are established before, or during a
> > purchase.
>
> Then set it up as a credit agreement?
>
> > That is, if I create a Credit Card account,
> > I should be able to enter the terms, e.g.:
> > 12% annual, payments due the first business of the
> > month, new purchases included in the interest
> > calculations, cash advances charged 24% annual, etc.
>
> Patches are always welcome.
>
> :-)
> :
> > Credit terms are fairly standardized now.
>
> Where? Not in the UK - terms are a minefield of options and changes and are
> changed without notice. You'd need to implement a full versioning system
> that can cope with the account before and after each round of changes to
> the conditions. Entering all that would be far more work than is necessary
> for most users.
>
> I know I don't want to laboriously enter every point change in the interest
> rate of my credit cards. I just pay them off before interest is charged,
> it's far easier!!!!
>
> :-)
> :
> > > | * the terms of the rebate
> > >
> > > A scheduled transaction?
> >
> > Nope. An Account Receivable. It goes on the book as
> > having value.
>
> Yes, an SX that uses A/R.
>
> > Accounts Payable (Credit Cards, Notes) and Accounts
> > Receivable all have terms.
>
> Look at the business objects, bill terms are handled for invoices and bills
> along with the inevitable A/R.
>
> > > And that is a GOOD THING. It's always good to follow
> > > 'best practice'!
> >
> > Doing the one part of a best practice isn't the same
> > as doing the whole.
>
> Make sure you've looked over the business features.
>
> > GnuCash's Balance Sheets are totally fubar'd. For a
> > balance sheet (and double entry accounting) to be
> > meaningful, everything must follow the cost principle.
>
> That's inventory again, isn't it? GnuCash currently uses accounts and
> running balances.
>
> >  If I buy two things today for $1, and sell one
> > tomorrow for $0.50, my one thing remaining should
> > still be on the books at $1.
>
> That's inventory.
>
> If you increase your assets by two transactions of £1 and reduce the assets
> by £0.50, you are left with assets of £1.50.
>
> To get to a value of £1 you need to account for the loss on the sale.
> Currently, you're best doing that by transferring the £0.50 to an Expense
> as a cost. So 50p goes to some form of income and 50p to an expense of some
> kind.
>
> To say that you have two items and that you've sold one item rather than
> had an income of £0.50p, you need inventory. If a grocer buys two apples
> for 10p each and sells one for 40p, he has one apple and 40p in cash. In
> terms of assets, that's 50p. In terms of inventory, it's one apple.
>
> When I invoice a customer, if they don't pay the entire invoice I do not
> want GnuCash telling me that the account is settled in full - the running
> balance of the account is not zero.
>
> > Market value does not
> > belong on a balance sheet (unless an asset is
> > impaired, of course)!
>
> ?? I've got assets for my house and my car. Market value is all I have and
> I need to have that showing up. For UK tax purposes, I implement certain
> depreciation rules for capital allowance that work solely on the original
> purchase price.
>
> > GnuCash does some things an accountant would expect,
> > and some that are totally wrong.
>
> in your humble opinion - I've yet to find GnuCash doing anything that my
> accountant would not have done.
>
> --
>
> Neil Williams
> =============
> http://www.data-freedom.org/
> http://www.nosoftwarepatents.com/
> http://www.linux.codehelp.co.uk/
>
> -------------- next part --------------
> A non-text attachment was scrubbed...
> Name: not available
> Type: application/pgp-signature
> Size: 189 bytes
> Desc: not available
> Url :
> http://lists.gnucash.org/pipermail/gnucash-user/attachments/20050703/f00aef
>cb/attachment-0001.bin
>
> ------------------------------
>
> Message: 17
> Date: Sun, 3 Jul 2005 18:39:10 +0100
> From: Neil Williams <[hidden email]>
> Subject: Re: Locked database
> To: [hidden email]
> Message-ID: <[hidden email]>
> Content-Type: text/plain; charset="iso-8859-1"
>
> On Wednesday 08 June 2005 7:33 pm, Bob Williams wrote:
> > I've tried the third option of Create New File, to get GnuCash running,
>
> Turn off the scheduled transaction processing and then open the file. It
> sounds like one of the scheduled transaction records has gone awry. Go to
> the Preferences, click on Scheduled Transactions and uncheck the "Run on
> GnuCash start" option.
>
> GnuCash locks the data file whilst it is in use and if GnuCash crashes, the
> lock remains in place.
>
> --
>
> Neil Williams
> =============
> http://www.data-freedom.org/
> http://www.nosoftwarepatents.com/
> http://www.linux.codehelp.co.uk/
>
> -------------- next part --------------
> A non-text attachment was scrubbed...
> Name: not available
> Type: application/pgp-signature
> Size: 189 bytes
> Desc: not available
> Url :
> http://lists.gnucash.org/pipermail/gnucash-user/attachments/20050703/d6b31f
>df/attachment-0001.bin
>
> ------------------------------
>
> Message: 18
> Date: Sun, 3 Jul 2005 18:49:06 +0100
> From: Neil Williams <[hidden email]>
> Subject: Re: Thanks GNUCash
> To: Erik Evenson <[hidden email]>
> Cc: [hidden email]
> Message-ID: <[hidden email]>
> Content-Type: text/plain; charset="iso-8859-1"
>
> On Monday 23 May 2005 4:07 am, Erik Evenson wrote:
> > - It doesn't coddle me.  Strict double-entry accounting is appreciated by
> > this MBA.  Keeps me from making mistakes.  There's a reason double-entry
> > accounting has been used ever since those monks back in the 1300's
> > invented it.
> > - It's interface is simple and direct -- appreciated by this Engineer.
> > - It will always be there -- GNUCash has no "sunset."  Quicken's biggest
> > problem was that they completed the necessary features in the code years
> > ago.  There was just nothing left to add and therefore upgrade to.
> >
> > What I don't like about GNUCash:
> >
> > - I would never recommend this program to "normal" users.
> > That, and neither is GNUCash's UI.  Don't get me wrong -- I love it.
>
> Wait for the Gnome2 port - there are a lot of interface changes.
>
> > - Flipside of the previous: it doesn't have a command line interface.
> > Gosh that would be nice when I'm ssh-ing into my Debian server box.
>
> As far as the data is concerned, that too will be fixed with G2. Using a
> generation tool that I'm spinning out from the GnuCash engine, any number
> of command-line utilities can be created that provide access to data
> exported from GnuCash and that modified data can then be re-imported and
> merged into the existing file. Better that than allowing direct access to
> the GnuCash data file where modifications could cause grief elsewhere, this
> way the original data remains intact until and unless the user chooses to
> merge it and then the user has full control over how the new data is merged
> into the old.
>
> > - It doesn't run on Cygwin.  I know there is a good reason, but I don't
> > know what it is.
>
> Again, wait for G2. The current GnuCash uses libraries that are simply too
> old and too varied - we are the last application in Debian to require
> Gnome1.4 after all. There is a good chance that G2 will make such tasks a
> lot easier but this is not a primary goal of the G2 port, it's more of a
> nice by-product and just because G2 becomes available (later this year) it
> does NOT mean that it will miraculously work under Cygwin.
>
> > If it did run on Cygwin, I could use GNUCash on my
> > laptop, which is hopelessly locked into an MS OS.
>
> Unless it's v.new, that may not be the case any longer - one or two bits
> might not be detected and the internal modem is probably best forgotten,
> but do investigate that further by joining your nearest Linux User Group
> and going to http://www.linux-laptop.net - but that's by the by.
>
> > - A calendar display of balances like Quicken 2002 had.  Gosh, this was
> > key to me managing my personal checking account.  I miss it.
>
> So do I but if I remember correctly, someone was talking about developing
> that.
>
> > Nevertheless, a big thank-you.  If I knew who you were, I'd buy you a
> > beer.
>
> Making a donation at SourceForge is the next best thing.
> http://sourceforge.net/projects/gnucash/

--
----------------------------------
this message was brought to you by
Stephan Pouh on Fedora Core 3

_______________________________________________
gnucash-user mailing list
[hidden email]
https://lists.gnucash.org/mailman/listinfo/gnucash-user