sql-ledger-users — SQL-Ledger users

RE: session management

[Dr D. <drd...@ho...>]

Whoever comes to the Whitehouse Computer keyboard can very possibly
press the button for 
Full Global Nuclear War. That's why they only let chosen (elected) fools
do that..
Besides, somehow it seems unfair to me to blame Dieter for Microsoft's
well spread security bugs. 
Workaround one: disable the 'remember my password' bit in IE and you are
halfway there..
Workaround two: disable windows and install linux

-----Original Message-----
From: sql...@li...
[mailto:sql...@li...] On Behalf Of
Sergio A. Kessler
Sent: zondag 3 maart 2002 1:58
To: Dieter Simader
Cc: Kenneth Gonsalves; sql...@li...
Subject: Re: session management


/me knocks my embarrased head...

ok, anyway, while we are at it: whoever come to my computer
can log in my name, as the url (with the encrypted passwd)
stay in the browser cache...
(thanks to url completion features in IE, mozilla et al)

I just type "aba" in my browser and he show me many
urls to access sql-ledger bypassing the login dialog,
for example, this:
http://abacus.sql-ledger.org/sql-ledger/menu.pl?path=bin/mozilla&action=
acc_
menu&login=sergio&password=

note the passwd IS there (it's just blank), so skipping the login dialog
is just too easy, even it happened me accidently...

and that can be a big security problem in bussiness...

/sergio

----- Original Message -----
From: "Dieter Simader" <dsi...@sq...>


> There is no session management in SQL-Ledger.
>
> If you have session management than you are not using the official 
> version of SQL-Ledger.
>
> I suggest you complain to whoever added session managment.
>
>
> Dieter Simader    http://www.sql-ledger.org   (780) 472-8161
> DWS Systems Inc.     Accounting Software       Fax: 478-5281
> =========== On a clear disk you can seek forever ===========
>
> On Sat, 2 Mar 2002, Sergio A. Kessler wrote:
>
> > a solution would be to use http auth
> > (wich is a lot more simple than sessions),
> > but dieter is against it  :(
> >
> > /sergio
> >
> > ----- Original Message -----
> > From: "Kenneth Gonsalves" <la...@th...>
> >
> >
> > > hi
> > > problem:
> > > user starts a session on a web based app. connection gets cut. he 
> > > re-establishes connection and tries to login. message - 'already
logged in
> > > get lost'. he has to wait anything upto 30 minutes for his 
> > > previous
> > session
> > > to expire before being able to do his work. any solution for this?

> > > kg
> > >
> > >
> >
> >
>
>
>

Re: session management

[Sergio A. K. <ser...@ho...>]

/me knocks my embarrased head...

ok, anyway, while we are at it: whoever come to my computer
can log in my name, as the url (with the encrypted passwd)
stay in the browser cache...
(thanks to url completion features in IE, mozilla et al)

I just type "aba" in my browser and he show me many
urls to access sql-ledger bypassing the login dialog,
for example, this:
http://abacus.sql-ledger.org/sql-ledger/menu.pl?path=bin/mozilla&action=acc_
menu&login=sergio&password=

note the passwd IS there (it's just blank), so skipping the
login dialog is just too easy, even it happened me accidently...

and that can be a big security problem in bussiness...

/sergio

----- Original Message -----
From: "Dieter Simader" <dsi...@sq...>


> There is no session management in SQL-Ledger.
>
> If you have session management than you are not using the official version
> of SQL-Ledger.
>
> I suggest you complain to whoever added session managment.
>
>
> Dieter Simader    http://www.sql-ledger.org   (780) 472-8161
> DWS Systems Inc.     Accounting Software       Fax: 478-5281
> =========== On a clear disk you can seek forever ===========
>
> On Sat, 2 Mar 2002, Sergio A. Kessler wrote:
>
> > a solution would be to use http auth
> > (wich is a lot more simple than sessions),
> > but dieter is against it  :(
> >
> > /sergio
> >
> > ----- Original Message -----
> > From: "Kenneth Gonsalves" <la...@th...>
> >
> >
> > > hi
> > > problem:
> > > user starts a session on a web based app. connection gets cut. he
> > > re-establishes connection and tries to login. message - 'already
logged in
> > > get lost'. he has to wait anything upto 30 minutes for his previous
> > session
> > > to expire before being able to do his work. any solution for this?
> > > kg
> > >
> > >
> >
> >
>
>
>

Re: session management

[Dieter S. <dsi...@sq...>]

There is no session management in SQL-Ledger.

If you have session management than you are not using the official version
of SQL-Ledger.

I suggest you complain to whoever added session managment.


Dieter Simader    http://www.sql-ledger.org   (780) 472-8161
DWS Systems Inc.     Accounting Software       Fax: 478-5281
=========== On a clear disk you can seek forever ===========

On Sat, 2 Mar 2002, Sergio A. Kessler wrote:

> a solution would be to use http auth
> (wich is a lot more simple than sessions),
> but dieter is against it  :(
> 
> /sergio
> 
> ----- Original Message -----
> From: "Kenneth Gonsalves" <la...@th...>
> 
> 
> > hi
> > problem:
> > user starts a session on a web based app. connection gets cut. he
> > re-establishes connection and tries to login. message - 'already logged in
> > get lost'. he has to wait anything upto 30 minutes for his previous
> session
> > to expire before being able to do his work. any solution for this?
> > kg
> >
> >
> 
> 

Re: session management

[Sergio A. K. <ser...@ho...>]

a solution would be to use http auth
(wich is a lot more simple than sessions),
but dieter is against it  :(

/sergio

----- Original Message -----
From: "Kenneth Gonsalves" <la...@th...>


> hi
> problem:
> user starts a session on a web based app. connection gets cut. he
> re-establishes connection and tries to login. message - 'already logged in
> get lost'. he has to wait anything upto 30 minutes for his previous
session
> to expire before being able to do his work. any solution for this?
> kg
>
>

session management

[Kenneth G. <la...@th...>]

hi
problem:
user starts a session on a web based app. connection gets cut. he 
re-establishes connection and tries to login. message - 'already logged in 
get lost'. he has to wait anything upto 30 minutes for his previous session 
to expire before being able to do his work. any solution for this?
kg

Re: Info for Accountant

[<raa...@ac...>]

Steve,

Thanks for the information.  I keep forgetting I'm the ignorant one and 
the experts really are.  I took a basic book keeping class from Terri and 
showed her my - then - list of accounts.  She looked at them and said they 
looked fine except for the numbering wasn't typical US accounting.  I 
should have hired her then so I could do at home what we were doing in 
class. (It was pure paper based book keeping.  No computers of software 
was used.)

Again thanks.  With April 15th approaching I really need to get my posting 
done.  :-(


Best,
Rod
-- 
             Why is it so easy to throw caution to the wind.
            Shouldn't it be heavier and shaped like an anvil?

                                                           Jon Anderson

Re: Doubtful receivables

[Steve D. <sd...@sw...>]

Hi Phillip.

Philip Reetz wrote:

> Hello,
> I have a small question. Some time I invoiced one of our customers. This
> position now appears in accounts receivables (like it should). Since the
> company ceased to exist, it is very doubtful that a will see any money.
> Therefore I would like to move this invoice from accounts receivables to
> allowance for doubtful accounts. I could make a general ledger entry to
> reflect this change, but I also would like this invoice to disappear from
> the aging report etc.
>
> Is there way to achieve this and if so how?

See my post on Feb. 16 to Jeff Strope re: General questions.  You would only
use allow for doubtful accts. if you've previously accrued for bad debt.  If
not, you can charge the invoice directly to bad debt expense.

>
>
> Thanks a lot. And a big thanks to Dieter for the upgrade. Fixed quite a few
> problems for me.
>
> Ciao,
> Philip
>
> PS: I don't know if I got all the translations right. I hope it is clear
> what I have in mind.
>
> --
> LINET Services
> Linux im Intra- und InterNet
>
> Rebenring 33                                    Tel.:   0531-280 191 71
> 38106 Braunschweig                              Fax:    0531-280 191 72
>
> http://www.linet-services.de
> mailto:in...@li...

Re: Info for Accountant

[Steve D. <sd...@sw...>]

raa...@ac... wrote:

> I'm meeting with an accountant next week to have her help me set up my
> accounts to use in SQL-Ledger.  Since there are still few accountants out
> there that even know of SL I'm going to try to avoid any confusion by
> meeting at her location and go over what has to be done without the
> distraction of learning SL.
>    What I'd like to know - especially from any accountants on the list -
> is what kind of extra infomation I should take with me to make our job
> simpler and more productive.  She has worked for a BIG company that used
> an inhouse accounting system and works with QuickBooks and I believe
> Peachtree so will probably be thinking in those terms.

Just take the default chart of accounts in (US general chart or default chart in the sql/ directory).  You can strip out everything but the acct. #'s and
descriptions for clarity.  Have her use that as a basis for a custom chart.  You can renumber/reorganize the chart as appropriate for the transactions that you'll
have.  Just put the edits back into the format of the default chart and load it in.

>
>
> Where I'm seeing the most chance for problems is in the account linking
> stuff.  I've seen many posts here about it but I still can't seem to get
> my mind wrapped around it.

I've attached a help page for the add accts. screen.  Compare that to the default sql file, and you should be able to get an idea what all those acct. setup
options on the form do in the db.  You can always edit an acct. after the fact.

Good luck,
Steve

>
>
> Any help and ideas are appreciated,
>
> Best,
> Rod
> --
>              Why is it so easy to throw caution to the wind.
>             Shouldn't it be heavier and shaped like an anvil?
>
>                                                            Jon Anderson
>
> [ Note: When replying, please Reply to the list address. This way other members know if the issues have been resolved or not. Thanks! Your List administrator. ]

Doubtful receivables

[Philip R. <p....@li...>]

Hello,
I have a small question. Some time I invoiced one of our customers. This 
position now appears in accounts receivables (like it should). Since the 
company ceased to exist, it is very doubtful that a will see any money. 
Therefore I would like to move this invoice from accounts receivables to 
allowance for doubtful accounts. I could make a general ledger entry to 
reflect this change, but I also would like this invoice to disappear from 
the aging report etc.

Is there way to achieve this and if so how?

Thanks a lot. And a big thanks to Dieter for the upgrade. Fixed quite a few 
problems for me.

Ciao,
Philip

PS: I don't know if I got all the translations right. I hope it is clear 
what I have in mind.


--
LINET Services
Linux im Intra- und InterNet

Rebenring 33                                    Tel.:   0531-280 191 71
38106 Braunschweig                              Fax:    0531-280 191 72

http://www.linet-services.de
mailto:in...@li...

RE: Error when Adding a Service

[Dr D. <drd...@ho...>]

In that case I suggest you can either book it as negative advertising
costs, or open a G/L for 'Various Income' 
And credit that directly from the cheque or the bankstatement. That way
you keep the sales revenue and the 'specials' apart and keep the sales
income versus COG 'clean'. Let me know when Hollywood buys the script
though, you might want to reconsider at that time ;-)

-----Original Message-----
From: alta [mailto:al...@al...] 
Sent: donderdag 28 februari 2002 21:14
To: Dr Default; sql...@li...
Subject: Re: Error when Adding a Service



Paul ...

Your inputs are always of value.

In my case, I consider my writing of articles to be a part of the 
business.  It's a form of advertising that even pays me some.  So, I 
don't really consider it personal, and that's why I am running it 
through sql-ledger.

... Reed


On Thursday 28 February 2002 11:31, you wrote:
> # start offtopic
> Sorry, forgot to post to the list as well..
> I quote one of my educators "A mailing-list is a concept set up to 
> help many instead of one: answers to questions put forward by one are 
> received by the questioner *and* the 'lurkers' on the list. 'lurkers' 
> that say 'hm...aha!' to themselves while reading the emails on the 
> list, while they themselves might not yet have arrived at the question

> at hand or were not yet able to formulate it correctly/completely. 
> Anyway, answers in a mailing-list are more help than privately emailed

> answers." so there you are.. # end offtopic
>
> Reed,
>
> I am not specialized in tax- or general law outside holland.. But in 
> holland, even if you run a one-man company, it would be wise to keep 
> VERY strict track of personal income and expenses on the one hand and 
> of business income and expenses on the other. In case of doubt (or no 
> available 'accounting trail') the tax officers (IRS) will pick 
> whatever you have to pay most taxes on as being what happened. 
> Afterwards you are sure to have a heck of a time to proof anything 
> different, chances of success there are only technical. I figure the 
> IRS anywhere worldwide is likely to have a similar approach ;-((
>
> From an accounting standpoint the same applies, it is allways wise to 
> first analyse the actual situation and afterwards put it in any form 
> of accounting package / scheme. Thus the accounting scheme and the 
> actual 'real life' world are at least compatible.
>
> PS: Mixing 'pleasure' (personal) with business (company) is not a good

> idea to begin with, and fiscally speaking it comes close to an open 
> check to the IRS.. However unpleasant, it is best to keep TWO sets of 
> books: one for the private household and one for the company. Any 
> payments one way or the other between those two entities should be 
> clearly discribed (advance on this years profit, paid cash advance 
> regarding office supplies, etcetera) and if possible be backed up by 
> at least a paper trail and receipts.
>
> Do not let it get you down, and if all else fails, call in a 
> bookkeeper or accountant ;-)
>
> Paul.
>
> -----Original Message-----
> From: alta [mailto:sp...@al...]
> Sent: woensdag 27 februari 2002 18:25
> To: sql...@li...; Dr Default
> Subject: Re: Error when Adding a Service
>
>
>
> Paul ...
>
> Generally, I do not know exactly how much I will be paid for an 
> article until I receive the check, because the amount depends upon the

> edited (final) size of the article and other factors.  In other words,

> I do not send an invoice -- I receive a check of surprise value, and 
> want a simple way to book the income.  My company is a one-person 
> company (me).  Originally, it seemed simple enough to treat the 
> process as a service.  Your comments give me more to think about.  
> Thanks.
>
> ... Reed
>
> On Wednesday 27 February 2002 00:18, you wrote:
> > Reed,
> >
> > I guess you might want to look at your 'WRITING' as another kind of 
> > 'ARTICLE'. Try to imagine selling an existing book that you yourself

> > do not have in stock yet to a customer. You would have to first 
> > place an order for it, buy it and then get it in stock before you 
> > could sell it to the customer, issue a packing slip and get it out 
> > of the stock again. The same goes for your article: IF it is owned 
> > by the company because e.g. your contract says so, or you want the 
> > firm to have the rights for it, in fact the company is buying it 
> > from you AS A PERSON. YOU are the manufacurer of the 'goods'. SO the

> > company should place an order, receive the article and then sell it 
> > to the highest bidder.. However, if you put it in the company like
> > this future rights (for reprints or movies or whatever) will also
> > be in the company. Hope this clarifies the 'There are no
> > purchases invoved in the writing I do'..
> >
> > If it is just to keep track of income, I suggest you think about 
> > this very carefully and maybe take it up with a tax advisor or 
> > bookkeeper. It could be simpler to use a SEPARATE BANK ACCOUNT and 
> > book any income
> >
> > from this kind to a separate ledger 'Private income from writing' 
> > and NOT send out bills on the companies behalf, for as I pointed 
> > out, it seems to me the company is selling something they have not 
> > yet purchased and thus have a negative stock of YOUR articles.. The 
> > difference between COG (cost of goods) and income stays in the 
> > company
> >
> > that way, not in your private account. IF ever a movie or book 
> > should follow, all income is for the company as well, so take that 
> > in mind when negotiating the price, or stipulate in the order 
> > confirmation that this transaction only exists for ONE publishment 
> > in XX magazine in year YY, and etcetera, you get the idea..
> >
> > If the 'via company' route is (still) intended anyway, you should at

> > least make official arrangements as to the fees due to the company 
> > for
> >
> > handling your affairs on the one hand (they would be a sort of 
> > literary agent or publisher, so probably a percentage, 10 to 15% I 
> > guess), and as to the amounts you AS A PERSON are to receive on the 
> > other hand.
> >
> > Once you have this clear in your mind, IF the company stays 
> > involved, the costs would be sale price minus xx%, the income would 
> > be sale price 100%, leaving YOU as a person in the form of A/P for 
> > the (100 - xx) part.
> >
> > Hope this helps, somehow I got the impression you are trying to 
> > solve a problem you might not want to or need to have..
> >
> > Paul
> >
> > -----Original Message-----
> > From: sql...@li...
> > [mailto:sql...@li...] On Behalf Of 
> > alta Sent: dinsdag 26 februari 2002 6:13
> > To: Dieter Simader; sql...@li...
> > Subject: Re: Error when Adding a Service
> >
> >
> >
> > Dieter ...
> >
> > I think I should explain what I am doing in more detail.  Mostly, I 
> > sell books.  All that is working fine.  Occasionally, I write 
> > articles
> >
> > for magazines.  When they pay me, I presume that I should enter 
> > dollars received in a "service" account.  So I tried to setup a 
> > service called "Writing" which is tied to the existing 
> > "4310--Writing account.  (The Add Service form caused the error.)
> >
> > Upon further investigation, I find that the "Writing" service WAS 
> > added.  (Actually 3 were added because I tried 3 times.)  Each time 
> > I attempted to add "Writing" a server error displayed, and the 
> > error_log
> >
> > showed:
> >
> > [error] [client 127.0.0.1] Premature end of script headers: 
> > /usr/local/sql-ledger/ic.pl
> >
> > So, I guess it worked, after all.  However, the reason for the error

> > is still a curiosity.
> >
> > Answers to your questions follow:
> > > You don't have an account number for purchases.
> >
> > I puzzling as to why having an account number for purchases would 
> > have anything to do with a "Writing" service that I provide.  For 
> > the "Writing" service, there are no purchases needed, but I guess a 
> > default needs to be selected in the Add Service form.  I selected 
> > "5010--Purchases", which is flagged with IC_expense.
> >
> > > check that you have at least one account flagged with IC_expense. 
> > > "Setup" -> "List Accounts"
> >
> > The following accounts are flagged with IC_Expense:
> >      5010--Purchases
> >      5100--Freight
> >      5781--Internet
> >
> > > Also go into your preferences and see which account comes up for 
> > > the 'Expense Account'
> >
> > From my preferences, Expense Account: 5040--COGS / Books
> >
> > > On Mon, 25 Feb 2002, alta wrote:
> > > > I get the following error posted to the server log when I 
> > > > attempt to
> > > >
> > > > add a service:
> > > >
> > > > [error] [client 127.0.0.1] Premature end of script headers: 
> > > > /usr/local/sql-ledger/ic.pl
> > > >
> > > > Has anyone else seen this problem?
> > > >
> > > > The details...
> > > >
> > > > I am attempting to add a service called "Writing":
> > > >
> > > > Number: Writing
> > > > Description: Writing
> > > > Unit of measure: hr
> > > > List Price: 0
> > > > Sell Price: 0
> > > > Income: 4310--Writing
> > > > Expense--Purchases
> > > > 2310--GST: not checked
> > > > 2311--PST: not checked
> > > >
> > > > My setup for "4310--Writing":
> > > >
> > > > Account Number: 4310
> > > > Description: Writing
> > > > Account Type: Income, Account
> > > > Is this a summary account to record: no, no, no
> > > > Include in drop-down lists:
> > > >   Receivables: Income
> > > >   Service Items: Income
> > > > Include this account...as taxable? no
> > > >
> > > >
> > > > Your help appreciated ... Reed

-- 
Reed White  -  ALTA RESEARCH  -  www.alta-research.com
Phone: 877-360-2582  -  Email: al...@al...

Re: Error when Adding a Service

[alta <al...@al...>]

Paul ...

Your inputs are always of value.

In my case, I consider my writing of articles to be a part of the 
business.  It's a form of advertising that even pays me some.  So, I 
don't really consider it personal, and that's why I am running it 
through sql-ledger.

... Reed


On Thursday 28 February 2002 11:31, you wrote:
> # start offtopic
> Sorry, forgot to post to the list as well..
> I quote one of my educators "A mailing-list is a concept set up to
> help many instead of one: answers to questions put forward by one
> are received by the questioner *and* the 'lurkers' on the list.
> 'lurkers' that say 'hm...aha!' to themselves while reading the
> emails on the list, while they themselves might not yet have
> arrived at the question at hand or were not yet able to formulate
> it correctly/completely. Anyway, answers in a mailing-list are more
> help than privately emailed answers." so there you are..
> # end offtopic
>
> Reed,
>
> I am not specialized in tax- or general law outside holland.. But
> in holland, even if you run a one-man company, it would be wise to
> keep VERY strict track of personal income and expenses on the one
> hand and of business income and expenses on the other. In case of
> doubt (or no available 'accounting trail') the tax officers (IRS)
> will pick whatever you have to pay most taxes on as being what
> happened. Afterwards you are sure to have a heck of a time to proof
> anything different, chances of success there are only technical. I
> figure the IRS anywhere worldwide is likely to have a similar
> approach ;-((
>
> From an accounting standpoint the same applies, it is allways wise
> to first analyse the actual situation and afterwards put it in any
> form of accounting package / scheme. Thus the accounting scheme and
> the actual 'real life' world are at least compatible.
>
> PS: Mixing 'pleasure' (personal) with business (company) is not a
> good idea to begin with, and fiscally speaking it comes close to an
> open check to the IRS.. However unpleasant, it is best to keep TWO
> sets of books: one for the private household and one for the
> company. Any payments one way or the other between those two
> entities should be clearly discribed (advance on this years profit,
> paid cash advance regarding office supplies, etcetera) and if
> possible be backed up by at least a paper trail and receipts.
>
> Do not let it get you down, and if all else fails, call in a
> bookkeeper or accountant ;-)
>
> Paul.
>
> -----Original Message-----
> From: alta [mailto:sp...@al...]
> Sent: woensdag 27 februari 2002 18:25
> To: sql...@li...; Dr Default
> Subject: Re: Error when Adding a Service
>
>
>
> Paul ...
>
> Generally, I do not know exactly how much I will be paid for an
> article until I receive the check, because the amount depends upon
> the edited (final) size of the article and other factors.  In other
> words, I do not send an invoice -- I receive a check of surprise
> value, and want a simple way to book the income.  My company is a
> one-person company (me).  Originally, it seemed simple enough to
> treat the process as a service.  Your comments give me more to
> think about.  Thanks.
>
> ... Reed
>
> On Wednesday 27 February 2002 00:18, you wrote:
> > Reed,
> >
> > I guess you might want to look at your 'WRITING' as another kind
> > of 'ARTICLE'. Try to imagine selling an existing book that you
> > yourself do not have in stock yet to a customer.
> > You would have to first place an order for it, buy it and then
> > get it in stock before you could sell it to the customer, issue a
> > packing slip and get it out of the stock again.
> > The same goes for your article: IF it is owned by the company
> > because e.g. your contract says so, or you want the firm to have
> > the rights for it, in fact the company is buying it from you AS A
> > PERSON. YOU are the manufacurer of the 'goods'. SO the company
> > should place an order, receive the article and then sell it to
> > the highest bidder.. However, if you put it in the company like
> > this future rights (for reprints or movies or whatever) will also
> > be in the company. Hope this clarifies the 'There are no
> > purchases invoved in the writing I do'..
> >
> > If it is just to keep track of income, I suggest you think about
> > this very carefully and maybe take it up with a tax advisor or
> > bookkeeper. It could be simpler to use a SEPARATE BANK ACCOUNT
> > and book any income
> >
> > from this kind to a separate ledger 'Private income from writing'
> > and NOT send out bills on the companies behalf, for as I pointed
> > out, it seems to me the company is selling something they have
> > not yet purchased and thus have a negative stock of YOUR
> > articles.. The difference between COG (cost of goods) and income
> > stays in the company
> >
> > that way, not in your private account. IF ever a movie or book
> > should follow, all income is for the company as well, so take
> > that in mind when negotiating the price, or stipulate in the
> > order confirmation that this transaction only exists for ONE
> > publishment in XX magazine in year YY, and etcetera, you get the
> > idea..
> >
> > If the 'via company' route is (still) intended anyway, you should
> > at least make official arrangements as to the fees due to the
> > company for
> >
> > handling your affairs on the one hand (they would be a sort of
> > literary agent or publisher, so probably a percentage, 10 to 15%
> > I guess), and as to the amounts you AS A PERSON are to receive on
> > the other hand.
> >
> > Once you have this clear in your mind, IF the company stays
> > involved, the costs would be sale price minus xx%, the income
> > would be sale price 100%, leaving YOU as a person in the form of
> > A/P for the (100 - xx) part.
> >
> > Hope this helps, somehow I got the impression you are trying to
> > solve a problem you might not want to or need to have..
> >
> > Paul
> >
> > -----Original Message-----
> > From: sql...@li...
> > [mailto:sql...@li...] On Behalf
> > Of alta Sent: dinsdag 26 februari 2002 6:13
> > To: Dieter Simader; sql...@li...
> > Subject: Re: Error when Adding a Service
> >
> >
> >
> > Dieter ...
> >
> > I think I should explain what I am doing in more detail.  Mostly,
> > I sell books.  All that is working fine.  Occasionally, I write
> > articles
> >
> > for magazines.  When they pay me, I presume that I should enter
> > dollars received in a "service" account.  So I tried to setup a
> > service called "Writing" which is tied to the existing
> > "4310--Writing account.  (The Add Service form caused the error.)
> >
> > Upon further investigation, I find that the "Writing" service WAS
> > added.  (Actually 3 were added because I tried 3 times.)  Each
> > time I attempted to add "Writing" a server error displayed, and
> > the error_log
> >
> > showed:
> >
> > [error] [client 127.0.0.1] Premature end of script headers:
> > /usr/local/sql-ledger/ic.pl
> >
> > So, I guess it worked, after all.  However, the reason for the
> > error is still a curiosity.
> >
> > Answers to your questions follow:
> > > You don't have an account number for purchases.
> >
> > I puzzling as to why having an account number for purchases would
> > have anything to do with a "Writing" service that I provide.  For
> > the "Writing" service, there are no purchases needed, but I guess
> > a default needs to be selected in the Add Service form.  I
> > selected "5010--Purchases", which is flagged with IC_expense.
> >
> > > check that you have at least one account flagged with
> > > IC_expense. "Setup" -> "List Accounts"
> >
> > The following accounts are flagged with IC_Expense:
> >      5010--Purchases
> >      5100--Freight
> >      5781--Internet
> >
> > > Also go into your preferences and see which account comes up
> > > for the 'Expense Account'
> >
> > From my preferences, Expense Account: 5040--COGS / Books
> >
> > > On Mon, 25 Feb 2002, alta wrote:
> > > > I get the following error posted to the server log when I
> > > > attempt to
> > > >
> > > > add a service:
> > > >
> > > > [error] [client 127.0.0.1] Premature end of script headers:
> > > > /usr/local/sql-ledger/ic.pl
> > > >
> > > > Has anyone else seen this problem?
> > > >
> > > > The details...
> > > >
> > > > I am attempting to add a service called "Writing":
> > > >
> > > > Number: Writing
> > > > Description: Writing
> > > > Unit of measure: hr
> > > > List Price: 0
> > > > Sell Price: 0
> > > > Income: 4310--Writing
> > > > Expense--Purchases
> > > > 2310--GST: not checked
> > > > 2311--PST: not checked
> > > >
> > > > My setup for "4310--Writing":
> > > >
> > > > Account Number: 4310
> > > > Description: Writing
> > > > Account Type: Income, Account
> > > > Is this a summary account to record: no, no, no
> > > > Include in drop-down lists:
> > > >   Receivables: Income
> > > >   Service Items: Income
> > > > Include this account...as taxable? no
> > > >
> > > >
> > > > Your help appreciated ... Reed

-- 
Reed White  -  ALTA RESEARCH  -  www.alta-research.com
Phone: 877-360-2582  -  Email: al...@al...

RE: Error when Adding a Service

[Dr D. <drd...@ho...>]

# start offtopic
Sorry, forgot to post to the list as well.. 
I quote one of my educators "A mailing-list is a concept set up to help
many instead of one: answers to questions put forward by one are
received by the questioner *and* the 'lurkers' on the list. 'lurkers'
that say 'hm...aha!' to themselves while reading the emails on the list,
while they themselves might not yet have arrived at the question at hand
or were not yet able to formulate it correctly/completely. Anyway,
answers in a mailing-list are more help than privately emailed answers."
so there you are.. 
# end offtopic

Reed, 

I am not specialized in tax- or general law outside holland.. But in
holland, even if you run a one-man company, it would be wise to keep
VERY strict track of personal income and expenses on the one hand and of
business income and expenses on the other. In case of doubt (or no
available 'accounting trail') the tax officers (IRS) will pick whatever
you have to pay most taxes on as being what happened. Afterwards you are
sure to have a heck of a time to proof anything different, chances of
success there are only technical. I figure the IRS anywhere worldwide is
likely to have a similar approach ;-((

From an accounting standpoint the same applies, it is allways wise to
first analyse the actual situation and afterwards put it in any form of
accounting package / scheme. Thus the accounting scheme and the actual
'real life' world are at least compatible. 

PS: Mixing 'pleasure' (personal) with business (company) is not a good
idea to begin with, and fiscally speaking it comes close to an open
check to the IRS.. However unpleasant, it is best to keep TWO sets of
books: one for the private household and one for the company. Any
payments one way or the other between those two entities should be
clearly discribed (advance on this years profit, paid cash advance
regarding office supplies, etcetera) and if possible be backed up by at
least a paper trail and receipts. 

Do not let it get you down, and if all else fails, call in a bookkeeper
or accountant ;-)

Paul.

-----Original Message-----
From: alta [mailto:sp...@al...] 
Sent: woensdag 27 februari 2002 18:25
To: sql...@li...; Dr Default
Subject: Re: Error when Adding a Service



Paul ...

Generally, I do not know exactly how much I will be paid for an 
article until I receive the check, because the amount depends upon 
the edited (final) size of the article and other factors.  In other 
words, I do not send an invoice -- I receive a check of surprise 
value, and want a simple way to book the income.  My company is a 
one-person company (me).  Originally, it seemed simple enough to 
treat the process as a service.  Your comments give me more to think 
about.  Thanks.

... Reed

On Wednesday 27 February 2002 00:18, you wrote:
> Reed,
>
> I guess you might want to look at your 'WRITING' as another kind of
> 'ARTICLE'. Try to imagine selling an existing book that you yourself 
> do not have in stock yet to a customer.
> You would have to first place an order for it, buy it and then get
> it in stock before you could sell it to the customer, issue a
> packing slip and get it out of the stock again.
> The same goes for your article: IF it is owned by the company
> because e.g. your contract says so, or you want the firm to have
> the rights for it, in fact the company is buying it from you AS A
> PERSON. YOU are the manufacurer of the 'goods'. SO the company
> should place an order, receive the article and then sell it to the
> highest bidder.. However, if you put it in the company like this
> future rights (for reprints or movies or whatever) will also be in
> the company. Hope this clarifies the 'There are no purchases
> invoved in the writing I do'..
>
> If it is just to keep track of income, I suggest you think about this
> very carefully and maybe take it up with a tax advisor or bookkeeper. 
> It could be simpler to use a SEPARATE BANK ACCOUNT and book any income

> from this kind to a separate ledger 'Private income from writing' and 
> NOT send out bills on the companies behalf, for as I pointed out, it 
> seems to me the company is selling something they have not yet 
> purchased and thus have a negative stock of YOUR articles.. The 
> difference between COG (cost of goods) and income stays in the company

> that way, not in your private account. IF ever a movie or book should 
> follow, all income is for the company as well, so take that in mind 
> when negotiating the price, or stipulate in the order confirmation 
> that this transaction only exists for ONE publishment in XX magazine 
> in year YY, and etcetera, you get the idea..
>
> If the 'via company' route is (still) intended anyway, you should at
> least make official arrangements as to the fees due to the company for

> handling your affairs on the one hand (they would be a sort of 
> literary agent or publisher, so probably a percentage, 10 to 15% I 
> guess), and as to the amounts you AS A PERSON are to receive on the 
> other hand.
>
> Once you have this clear in your mind, IF the company stays involved,
> the costs would be sale price minus xx%, the income would be sale 
> price 100%, leaving YOU as a person in the form of A/P for the (100 - 
> xx) part.
>
> Hope this helps, somehow I got the impression you are trying to solve
> a problem you might not want to or need to have..
>
> Paul
>
> -----Original Message-----
> From: sql...@li...
> [mailto:sql...@li...] On Behalf Of
> alta Sent: dinsdag 26 februari 2002 6:13
> To: Dieter Simader; sql...@li...
> Subject: Re: Error when Adding a Service
>
>
>
> Dieter ...
>
> I think I should explain what I am doing in more detail.  Mostly, I
> sell books.  All that is working fine.  Occasionally, I write articles

> for magazines.  When they pay me, I presume that I should enter 
> dollars received in a "service" account.  So I tried to setup a 
> service called "Writing" which is tied to the existing "4310--Writing 
> account.  (The Add Service form caused the error.)
>
> Upon further investigation, I find that the "Writing" service WAS
> added.  (Actually 3 were added because I tried 3 times.)  Each time I 
> attempted to add "Writing" a server error displayed, and the error_log

> showed:
>
> [error] [client 127.0.0.1] Premature end of script headers:
> /usr/local/sql-ledger/ic.pl
>
> So, I guess it worked, after all.  However, the reason for the error
> is still a curiosity.
>
> Answers to your questions follow:
> > You don't have an account number for purchases.
>
> I puzzling as to why having an account number for purchases would have
> anything to do with a "Writing" service that I provide.  For the 
> "Writing" service, there are no purchases needed, but I guess a 
> default needs to be selected in the Add Service form.  I selected 
> "5010--Purchases", which is flagged with IC_expense.
>
> > check that you have at least one account flagged with IC_expense.
> > "Setup" -> "List Accounts"
>
> The following accounts are flagged with IC_Expense:
>      5010--Purchases
>      5100--Freight
>      5781--Internet
>
> > Also go into your preferences and see which account comes up for the
> > 'Expense Account'
>
> From my preferences, Expense Account: 5040--COGS / Books
>
> > On Mon, 25 Feb 2002, alta wrote:
> > > I get the following error posted to the server log when I attempt
> > > to
> > >
> > > add a service:
> > >
> > > [error] [client 127.0.0.1] Premature end of script headers:
> > > /usr/local/sql-ledger/ic.pl
> > >
> > > Has anyone else seen this problem?
> > >
> > > The details...
> > >
> > > I am attempting to add a service called "Writing":
> > >
> > > Number: Writing
> > > Description: Writing
> > > Unit of measure: hr
> > > List Price: 0
> > > Sell Price: 0
> > > Income: 4310--Writing
> > > Expense--Purchases
> > > 2310--GST: not checked
> > > 2311--PST: not checked
> > >
> > > My setup for "4310--Writing":
> > >
> > > Account Number: 4310
> > > Description: Writing
> > > Account Type: Income, Account
> > > Is this a summary account to record: no, no, no
> > > Include in drop-down lists:
> > >   Receivables: Income
> > >   Service Items: Income
> > > Include this account...as taxable? no
> > >
> > >
> > > Your help appreciated ... Reed

-- 
Reed White  -  ALTA RESEARCH  -  www.alta-research.com
Phone: 877-360-2582  -  Email: al...@al...

Musing: subscription billing?

[Todd E. <te...@ce...>]

I work for a startup which does a lot of subscription billing - $5/month for
this feature, cancel that other one but upgrade to the $20 one, pretty soon
you're talking about some real money.

The problem is that I haven't seen reasonable, inexpensive sofware to handle
and track this and the changes. Would it be worth writing an interface to
sql-ledger to handle this? Or has someone already done it?

Todd

User Login Problem

[Christopher J. <ja...@st...>]

Hi I am new here

I have a problem with Sql-ledger. when i try to login as a user
i get this message: "The Document Contained no Data"
from Netscape. This only happens when logging in as a
user and if the password is correct.

-- 
--Christopher J.

Re: How are you handling variable tax rates?

[David R. <dr...@su...>]

MR,

I'm curious if you don't actually have a different tax account/line item for 
each municipality, how do you keep track of how much is owed to each agency 
at the end of the reporting period?

Although it might be a pain to enter different line items for each tax 
district/city/local govt you might have more clear reporting.

I'm not sure what your application is, but generally you owe the local city 
taxes only if the transaction occurs in a given city - so there should not be 
but a few tax accounts unless you travel to the customer's premises or sell 
at local tradeshows/conventions, etc.

But - thats only my two cents and their all used up!

-Dave Ratte
dr...@su...

On Wednesday 27 February 2002 03:49 pm, you wrote:
> Tax rates are not tied to a login but are tied to the customers, vendors
> and items.
>
>
> Dieter Simader    http://www.sql-ledger.org   (780) 472-8161
> DWS Systems Inc.     Accounting Software       Fax: 478-5281
> =========== On a clear disk you can seek forever ===========
>
> On Tue, 26 Feb 2002, MR wrote:
> > At the moment this is annoying but it may soon move up to a problem I'll
> > have to figure out how to solve.
> >
> > We have a base state tax.  Then each county has its own tax rate.
> > And sometimes the local city has their own tax rate.  The county/local
> > rates can be as low as 0% and as high at 1%
> >
> > Right now, the tax rate is tied to the person entering the data.
> >
> > I can work around this by creating a custom inventory item for each
> > state/county and adding that to every invoice.
> >
> > Has anyone done a customization of the tables to place the tax
> > rate to each customer, rather than to the ppl who enter the data?
> >
> >
> >
> >
> >
> > [ Note: When replying, please Reply to the list address. This way other
> > members know if the issues have been resolved or not. Thanks! Your List
> > administrator. ]

Re: How are you handling variable tax rates?

[Dieter S. <dsi...@sq...>]

Tax rates are not tied to a login but are tied to the customers, vendors
and items.


Dieter Simader    http://www.sql-ledger.org   (780) 472-8161
DWS Systems Inc.     Accounting Software       Fax: 478-5281
=========== On a clear disk you can seek forever ===========

On Tue, 26 Feb 2002, MR wrote:

> At the moment this is annoying but it may soon move up to a problem I'll
> have to figure out how to solve.
> 
> We have a base state tax.  Then each county has its own tax rate.  
> And sometimes the local city has their own tax rate.  The county/local
> rates can be as low as 0% and as high at 1%
> 
> Right now, the tax rate is tied to the person entering the data.  
>  
> I can work around this by creating a custom inventory item for each  
> state/county and adding that to every invoice.
> 
> Has anyone done a customization of the tables to place the tax 
> rate to each customer, rather than to the ppl who enter the data?
>  
>  
> 
> 
> 
> [ Note: When replying, please Reply to the list address. This way other members know if the issues have been resolved or not. Thanks! Your List administrator. ]
> 

Info for Accountant

[<raa...@ac...>]

I'm meeting with an accountant next week to have her help me set up my
accounts to use in SQL-Ledger.  Since there are still few accountants out
there that even know of SL I'm going to try to avoid any confusion by
meeting at her location and go over what has to be done without the 
distraction of learning SL.
   What I'd like to know - especially from any accountants on the list -
is what kind of extra infomation I should take with me to make our job
simpler and more productive.  She has worked for a BIG company that used
an inhouse accounting system and works with QuickBooks and I believe
Peachtree so will probably be thinking in those terms.

Where I'm seeing the most chance for problems is in the account linking
stuff.  I've seen many posts here about it but I still can't seem to get
my mind wrapped around it.

Any help and ideas are appreciated,


Best,
Rod
-- 
             Why is it so easy to throw caution to the wind.
            Shouldn't it be heavier and shaped like an anvil?

                                                           Jon Anderson

RE: Error when Adding a Service

[Dr D. <drd...@ho...>]

Reed, 

I guess you might want to look at your 'WRITING' as another kind of
'ARTICLE'. 
Try to imagine selling an existing book that you yourself do not have in
stock yet to a customer. 
You would have to first place an order for it, buy it and then get it in
stock before you could sell it to the customer, issue a packing slip and
get it out of the stock again.
The same goes for your article: IF it is owned by the company because
e.g. your contract says so, or you want the firm to have the rights for
it, in fact the company is buying it from you AS A PERSON. YOU are the
manufacurer of the 'goods'. SO the company should place an order,
receive the article and then sell it to the highest bidder..
However, if you put it in the company like this future rights (for
reprints or movies or whatever) will also be in the company. Hope this
clarifies the 'There are no purchases invoved in the writing I do'..

If it is just to keep track of income, I suggest you think about this
very carefully and maybe take it up with a tax advisor or bookkeeper. It
could be simpler to use a SEPARATE BANK ACCOUNT and book any income from
this kind to a separate ledger 'Private income from writing' and NOT
send out bills on the companies behalf, for as I pointed out, it seems
to me the company is selling something they have not yet purchased and
thus have a negative stock of YOUR articles.. The difference between COG
(cost of goods) and income stays in the company that way, not in your
private account. IF ever a movie or book should follow, all income is
for the company as well, so take that in mind when negotiating the
price, or stipulate in the order confirmation that this transaction only
exists for ONE publishment in XX magazine in year YY, and etcetera, you
get the idea.. 

If the 'via company' route is (still) intended anyway, you should at
least make official arrangements as to the fees due to the company for
handling your affairs on the one hand (they would be a sort of literary
agent or publisher, so probably a percentage, 10 to 15% I guess), and as
to the amounts you AS A PERSON are to receive on the other hand. 

Once you have this clear in your mind, IF the company stays involved,
the costs would be sale price minus xx%, the income would be sale price
100%, leaving YOU as a person in the form of A/P for the (100 - xx)
part. 

Hope this helps, somehow I got the impression you are trying to solve a
problem you might not want to or need to have..

Paul

-----Original Message-----
From: sql...@li...
[mailto:sql...@li...] On Behalf Of alta
Sent: dinsdag 26 februari 2002 6:13
To: Dieter Simader; sql...@li...
Subject: Re: Error when Adding a Service



Dieter ...

I think I should explain what I am doing in more detail.  Mostly, I 
sell books.  All that is working fine.  Occasionally, I write 
articles for magazines.  When they pay me, I presume that I should 
enter dollars received in a "service" account.  So I tried to setup a 
service called "Writing" which is tied to the existing "4310--Writing 
account.  (The Add Service form caused the error.)

Upon further investigation, I find that the "Writing" service WAS 
added.  (Actually 3 were added because I tried 3 times.)  Each time I 
attempted to add "Writing" a server error displayed, and the 
error_log showed:

[error] [client 127.0.0.1] Premature end of script headers:
/usr/local/sql-ledger/ic.pl

So, I guess it worked, after all.  However, the reason for the error 
is still a curiosity.

Answers to your questions follow:

> You don't have an account number for purchases.

I puzzling as to why having an account number for purchases would 
have anything to do with a "Writing" service that I provide.  For the 
"Writing" service, there are no purchases needed, but I guess a 
default needs to be selected in the Add Service form.  I selected 
"5010--Purchases", which is flagged with IC_expense.

> check that you have at least one account flagged with IC_expense. 
> "Setup" -> "List Accounts"

The following accounts are flagged with IC_Expense:
     5010--Purchases
     5100--Freight
     5781--Internet

> Also go into your preferences and see which account comes up for the 
> 'Expense Account'

From my preferences, Expense Account: 5040--COGS / Books


> On Mon, 25 Feb 2002, alta wrote:
> > I get the following error posted to the server log when I attempt to

> > add a service:
> >
> > [error] [client 127.0.0.1] Premature end of script headers: 
> > /usr/local/sql-ledger/ic.pl
> >
> > Has anyone else seen this problem?
> >
> > The details...
> >
> > I am attempting to add a service called "Writing":
> >
> > Number: Writing
> > Description: Writing
> > Unit of measure: hr
> > List Price: 0
> > Sell Price: 0
> > Income: 4310--Writing
> > Expense--Purchases
> > 2310--GST: not checked
> > 2311--PST: not checked
> >
> > My setup for "4310--Writing":
> >
> > Account Number: 4310
> > Description: Writing
> > Account Type: Income, Account
> > Is this a summary account to record: no, no, no
> > Include in drop-down lists:
> >   Receivables: Income
> >   Service Items: Income
> > Include this account...as taxable? no
> >
> >
> > Your help appreciated ... Reed

-- 
Reed White  -  ALTA RESEARCH  -  www.alta-research.com
Phone: 877-360-2582  -  Email: al...@al...




[ Note: When replying, please Reply to the list address. This way other
members know if the issues have been resolved or not. Thanks! Your List
administrator. ]

How are you handling variable tax rates?

[MR <mtr...@du...>]

At the moment this is annoying but it may soon move up to a problem I'll
have to figure out how to solve.

We have a base state tax.  Then each county has its own tax rate.  
And sometimes the local city has their own tax rate.  The county/local
rates can be as low as 0% and as high at 1%

Right now, the tax rate is tied to the person entering the data.  
 
I can work around this by creating a custom inventory item for each  
state/county and adding that to every invoice.

Has anyone done a customization of the tables to place the tax 
rate to each customer, rather than to the ppl who enter the data?
 
 

custom_rp.pl for csv write of trial balance

[Steve D. <sd...@sw...>]

I've attached a custom_rp.pl that writes the trial balance to a csv
file.  It's for 1.8.x versions since it's in the custom form, but the
changes could be applied to pre 1.8 versions (just edit rp.pl for pre
1.8).

Just stick it in /bin/mozilla and when you check the box it writes the
whole tb for the period entered to a file.  Save the link as
whatever/wherever you want, and open it with a spreadsheet to create
your own reports or do analysis, etc.

I'll eventually do this for the AR, AP, GL, and Inventory reports.

I hope it's useful to everyone.
Steve

manual diff:

lines 114-122 in report function
- new html table row w/ checkbox and link to file

lines 208-246
- new file_trial_balance function

lines 283-294 in generate_trial_balance function
- call new function if box is checked

Tips on inputting data into SQL-Ledger from other programs sought.

[MR <mtr...@du...>]

I'm looking to use automated ways of entering billing data into sql-ledger.
 
After poking about in the perl code, I thought:  Why not use some 
command-line web tools like commline, and I can spec the 'page' to send.
(ftp://ftp.w3.org/pub/old/comline/)
 
But, before I start walking down the primrose path of using a command-line
web tool, I am wondering if anyone else has used such a tool in the past 
to do what I am looking to do?
 
(and I'm going to look at the PDF report work of another user of SQL-Ledger    
and see if it can generate the invoices from history.  Then I might just
make a custom.pl that inputs the billing info right into the sql-ledger    
tables and then do 'history dumps')
 
Has anyone found the gnue.org accounting standards talk interesting?  
Given I don't wake up in the morning, stretch my arms and say "its a nice  
sunshiny day, think I'll code an accounting package" I am more interested  
in using a package and adding small bits, than learning accounting principles
reading standards documents, and THEN writing accounting code.

(I also don't say
"this is as pretty as an airport" and "I look forward to doing more 
business with my local telco/cable company" )
 

Re: Printing checks/Storing check numbers

[Dieter S. <dsi...@sq...>]

The source field is for keeping track of the checknumber.


Dieter Simader    http://www.sql-ledger.org   (780) 472-8161
DWS Systems Inc.     Accounting Software       Fax: 478-5281
=========== On a clear disk you can seek forever ===========

On Tue, 26 Feb 2002, David Fee wrote:

> Any suggestions on printing checks?
> Any way to store the check number in the table somewhere?
> Thanks,
> Dave
> 

Re: Tracking Partial Receipts/Partial Sales Order

[Dieter S. <dsi...@sq...>]

Backorders are coming, I'll probably include them with the 1.8.3 release.

Line items are retrieved in the order they are saved which is exactly the
same order as on screen.


Dieter Simader    http://www.sql-ledger.org   (780) 472-8161
DWS Systems Inc.     Accounting Software       Fax: 478-5281
=========== On a clear disk you can seek forever ===========

On Tue, 26 Feb 2002, David Ratte wrote:

> Has anyone come up with a method to track partial sales orders and or partial 
> receipts - Here's a quick example of what I mean...
> 
> We order 1200 of some part... maybe even a blanket order to complicate things 
> a little further (that is say 100 per month for 12 months...)
> 
> How do we know without manual tracking when the order has been filled.... I 
> do not see a space on the invoice to track "Order Qty", "This Shipment Qty", 
> "Total Shipped Qty"
> 
> I have the same case for inventory receipts. Frequently we have 20-25 items 
> on a purchase order. When they come in, the orders are usually not complete - 
> maybe some line items are missing completely, or shipped in less than order 
> qty. How can I track if a PO is complete?? Right now I have clipboards stuck 
> to the wall and its a totally manual process and getting out of hand quickly!
> 
> Lastly, Isn't it more normal NOT to re-order line items on a PO or SALES 
> ORDER i.e. remove the ORDER BY clause? generally speaking should a PO 
> contract (being a legal document) not be able to change from its original 
> printing?
> 
> Thanks,
> Dave Ratte
> dr...@su...
> 321-254-4201 x 204
> 
> 
> 
> [ Note: When replying, please Reply to the list address. This way other members know if the issues have been resolved or not. Thanks! Your List administrator. ]
> 

Re: Error when Adding a Service

[alta <al...@al...>]

Dieter ...

I think I should explain what I am doing in more detail.  Mostly, I 
sell books.  All that is working fine.  Occasionally, I write 
articles for magazines.  When they pay me, I presume that I should 
enter dollars received in a "service" account.  So I tried to setup a 
service called "Writing" which is tied to the existing "4310--Writing 
account.  (The Add Service form caused the error.)

Upon further investigation, I find that the "Writing" service WAS 
added.  (Actually 3 were added because I tried 3 times.)  Each time I 
attempted to add "Writing" a server error displayed, and the 
error_log showed:

[error] [client 127.0.0.1] Premature end of script headers:
/usr/local/sql-ledger/ic.pl

So, I guess it worked, after all.  However, the reason for the error 
is still a curiosity.

Answers to your questions follow:

> You don't have an account number for purchases.

I puzzling as to why having an account number for purchases would 
have anything to do with a "Writing" service that I provide.  For the 
"Writing" service, there are no purchases needed, but I guess a 
default needs to be selected in the Add Service form.  I selected 
"5010--Purchases", which is flagged with IC_expense.

> check that you have at least one account flagged with IC_expense.
> "Setup" -> "List Accounts"

The following accounts are flagged with IC_Expense:
     5010--Purchases
     5100--Freight
     5781--Internet

> Also go into your preferences and see which account comes up for
> the 'Expense Account'

From my preferences, Expense Account: 5040--COGS / Books


> On Mon, 25 Feb 2002, alta wrote:
> > I get the following error posted to the server log when I attempt
> > to add a service:
> >
> > [error] [client 127.0.0.1] Premature end of script headers:
> > /usr/local/sql-ledger/ic.pl
> >
> > Has anyone else seen this problem?
> >
> > The details...
> >
> > I am attempting to add a service called "Writing":
> >
> > Number: Writing
> > Description: Writing
> > Unit of measure: hr
> > List Price: 0
> > Sell Price: 0
> > Income: 4310--Writing
> > Expense--Purchases
> > 2310--GST: not checked
> > 2311--PST: not checked
> >
> > My setup for "4310--Writing":
> >
> > Account Number: 4310
> > Description: Writing
> > Account Type: Income, Account
> > Is this a summary account to record: no, no, no
> > Include in drop-down lists:
> >   Receivables: Income
> >   Service Items: Income
> > Include this account...as taxable? no
> >
> >
> > Your help appreciated ... Reed

-- 
Reed White  -  ALTA RESEARCH  -  www.alta-research.com
Phone: 877-360-2582  -  Email: al...@al...

Tracking Partial Receipts/Partial Sales Order

[David R. <dr...@su...>]

Has anyone come up with a method to track partial sales orders and or partial 
receipts - Here's a quick example of what I mean...

We order 1200 of some part... maybe even a blanket order to complicate things 
a little further (that is say 100 per month for 12 months...)

How do we know without manual tracking when the order has been filled.... I 
do not see a space on the invoice to track "Order Qty", "This Shipment Qty", 
"Total Shipped Qty"

I have the same case for inventory receipts. Frequently we have 20-25 items 
on a purchase order. When they come in, the orders are usually not complete - 
maybe some line items are missing completely, or shipped in less than order 
qty. How can I track if a PO is complete?? Right now I have clipboards stuck 
to the wall and its a totally manual process and getting out of hand quickly!

Lastly, Isn't it more normal NOT to re-order line items on a PO or SALES 
ORDER i.e. remove the ORDER BY clause? generally speaking should a PO 
contract (being a legal document) not be able to change from its original 
printing?

Thanks,
Dave Ratte
dr...@su...
321-254-4201 x 204