sql-ledger-users — SQL-Ledger users

Re: Fw: creating invoices from imported data

[Luca V. <lu...@ye...>]

ok, here I give you the scripts.
They worked with sql-ledger-1.6.6.

There are two different way of insert data:

1. I insert the customers and vendors without
fear of breaking data. I use a script to translate
text data file in sql insert queries. Then I
run the queries via psql.

2. I insert the transactions using SL modules
just like someone using the program via the
mozilla interface.

I'm sorry for some italian documentation and
for my junk programming. The code should be
self explanatory.

In case of need, feel free to ask me.

Luca



Olaf Faaland wrote:
> 
> Hi Luca,
> 
> I have no desire to fill in the tables directly.  I _like_ that there's an
> app that keeps things balanced and prevents me from breaking my data
> accidentally.
> 
> Would you be willing to share your script so I can use it as a starting
> point for mine?
> 
> Either way, thank you for the response.  It sounds like sql-ledger is set up
> so that it was fairly straightforward.
> 
> thanks,
> Olaf
> 
> ----- Original Message -----
> From: "Luca Venturini" <lu...@ye...>
> To: "Olaf Faaland" <ofa...@at...>
> Cc: <sql...@li...>
> Sent: Wednesday, January 30, 2002 8:12 AM
> Subject: Re: Fw: creating invoices from imported data
> 
> > Hi,
> >
> > I spend some time in the last month to import
> > my data from an other system to SL.
> > My data was in the form of a text file for each
> > transaction.
> >
> > I'm not sure that my way was the best one. I
> > produced a perl script that call the SL/* modules.
> > Something like an agent that work for me
> > on SQL-Ledger and input the transactions.
> >
> > Maybe a better way to do it is to fill directly
> > the tables with the data... The fear of db consistence
> > loss was to much
> >
> > Luca
> >

Re: Fw: creating invoices from imported data

[Olaf F. <ofa...@at...>]

Hi Luca,

I have no desire to fill in the tables directly.  I _like_ that there's an
app that keeps things balanced and prevents me from breaking my data
accidentally.

Would you be willing to share your script so I can use it as a starting
point for mine?

Either way, thank you for the response.  It sounds like sql-ledger is set up
so that it was fairly straightforward.

thanks,
Olaf


----- Original Message -----
From: "Luca Venturini" <lu...@ye...>
To: "Olaf Faaland" <ofa...@at...>
Cc: <sql...@li...>
Sent: Wednesday, January 30, 2002 8:12 AM
Subject: Re: Fw: creating invoices from imported data


> Hi,
>
> I spend some time in the last month to import
> my data from an other system to SL.
> My data was in the form of a text file for each
> transaction.
>
> I'm not sure that my way was the best one. I
> produced a perl script that call the SL/* modules.
> Something like an agent that work for me
> on SQL-Ledger and input the transactions.
>
> Maybe a better way to do it is to fill directly
> the tables with the data... The fear of db consistence
> loss was to much
>
> Luca
>

Re: Fw: creating invoices from imported data

[Luca V. <lu...@ye...>]

Hi,

I spend some time in the last month to import
my data from an other system to SL.
My data was in the form of a text file for each
transaction.

I'm not sure that my way was the best one. I
produced a perl script that call the SL/* modules.
Something like an agent that work for me
on SQL-Ledger and input the transactions.

Maybe a better way to do it is to fill directly
the tables with the data... The fear of db consistence
loss was to much

Luca

Re: permission denied

[Cesar V. <da...@et...>]

El Mar 29 Ene 2002 17:54, lee johnson escribi=F3:
> I'm unable to delete/create users now not sure what i've
> done..:(
>
> from admin.pl everything works but trying above gives me:
>
> permission denied: users/members
>

That could mean that you don't chmod the users (and BTW,=20
templates) directory to the user and group who run the=20
webserver (wwwrun/nogroup if SuSE, nobody/nogroup if RedHat=20
derivatives) as per README (!)

man chmod =20

--=20
C=E9sar Villanueva
SuSE Linux C.A.
"First they ignore you. Then they laugh at you.
Then they fight you. Then you win." [Gandhi]=20

permission denied

[lee j. <le...@im...>]

I'm unable to delete/create users now not sure what i've done..:(

from admin.pl everything works but trying above gives me:

permission denied: users/members

thx anyone
lee
-====

Fw: creating invoices from imported data

[Olaf F. <ofa...@at...>]

I should say, that I'm reasonably capable in perl - it's just this =
particular application that I don't know anything about.  I just want to =
know if it's a reasonable project before I start putting in time on it.

Thanks again,
Olaf

----- Original Message -----=20
From: Olaf Faaland=20
To: sql...@li...=20
Sent: Monday, January 28, 2002 9:58 AM
Subject: creating invoices from imported data


Hi,

First, my apologies if this is already addressed somewhere.  I found no =
reference to "import" in the last year's mailing list archives or the =
docs, but then again I may be blind.

I am considering using sql-ledger primarily for A/R.  I get billing data =
from a third party, in a form which could easily be turned into CSV or =
other easily-parsed text file.  I would want to use an import or extend =
sql-ledger to suck in my file, generate a series of invoices with it =
(each of which may have one or many line items), and then print the =
batch of invoices.  Payment entry would be performed by hand using the =
web i/f.

Are there facilities for this in sql-ledger already, that would make =
doing this straightforward?

thanks,
Olaf

What is the difference between orders and invoices?

[Chris K. \(Ski\) <kac...@at...>]

I am setting up SQL Ledger for the first time and playing around with it.
I both sell a service and sell parts.  From playing with SQL Ledger it seems
that:

- orders can be converted into invoices and vice versa

- I cannot post payments to an order

cheers,

ski

creating invoices from imported data

[Olaf F. <ofa...@at...>]

Hi,

First, my apologies if this is already addressed somewhere.  I found no =
reference to "import" in the last year's mailing list archives or the =
docs, but then again I may be blind.

I am considering using sql-ledger primarily for A/R.  I get billing data =
from a third party, in a form which could easily be turned into CSV or =
other easily-parsed text file.  I would want to use an import or extend =
sql-ledger to suck in my file, generate a series of invoices with it =
(each of which may have one or many line items), and then print the =
batch of invoices.  Payment entry would be performed by hand using the =
web i/f.

Are there facilities for this in sql-ledger already, that would make =
doing this straightforward?

thanks,
Olaf

Finnish language translation/port

[Paul S. <zi...@su...>]

Hi

We are thinking on adapting  sql-ledger for our business and are 
actually starting to port it to Finnish. One demand for accounting 
systems particular to Finland is that payments and account statements 
should seamlessly integrate to bank distributed/operated ftp programs. 
In order  not to invent the wheel twice my quesion is :

A) is there anyone translating to Finnish already

B) any knowledge around for the above mentioned integration/has someone 
already started this work as well

Co-operation in these areas would highly be appreciated

Paul

Re: Apache: URL Request TOO Large

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

You can replace the hyper-link with a button. That would eliminate the URL
size limitation.


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, 19 Jan 2002, David Ratte wrote:

> Bring up an assembly in the "Edit Assembly" screen in ic.pl, note that each 
> part number is a hyperlink. Right-click on one of the hyperlinks to "copy url 
> to clipboard" and paste into a windows-notepad or kedit window... thats a 
> lonnnngggg link. because apparently the 'callback' info grows longer for each 
> item on a bill of materials.
> 
> -Dave
> 
> On Friday 18 January 2002 12:43 pm, you wrote:
> > This makes no sense to me.  SL appears to use the POST method in forms, so
> > the form data does not go in the url and its size should be effectively
> > unlimited.
> >
> > It may help if you describe what you do, and the results, in more detail.
> >
> > -- Rod
> >    http://www.sunsetsystems.com/
> >
> > On Friday 18 January 2002 08:36, David Ratte wrote:
> > > Granted this is more of an Apache issue than sql-ledger, but I have a
> > > problem while editiing a component from within a bill-of-materials, only
> > > when the BOM is over a certain size (maybe 15-20 parts or so).
> > >
> > > Basically what happens is that since the screen is basically one big
> > > $form, when you press submit a URL too great to process error occurs.
> > >
> > > So the big question: is there a compile-time option or config file
> > > switch for the MAX URL SIZE? I couldn't find anything on the apache faq
> > > site.
> > >
> > > Thanks
> > > -Dave
> 
> 

Re: Tax Override Bug

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

Taxes are recalculated when you press "Update Form"

To override the amount you change the amount before you post. Of course
the total displayed is incorrect but it will be stored correctly.

There was a bug in 1.8.0 where only the first tax was recalled. Thus
you had to press "Update Form" to recalculate the form. There is patch
on the download page which fixes that.

All the taxes are recalled and displayed as stored. As long as you do not
press "Update Form" the taxes will remain as is.


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 21 Jan 2002, Joe MacDonald wrote:

> I have certain vendors which charge diffferent taxes on different items
> and I would like to be able to override what the tax paid is posted at,
> however the system seems to store it properly but not recall it
> properly.
> 
> For Example:
> 
> There are two taxes:
> GST 7%
> PST 7%
> 
> If I recieve a bill of services for $100 dollars, it would make sence
> that if both taxes were applied I would be paying a total of $114.
> 
> In my scenario, the GST is applied to all $100 which would add $7, and
> the PST is only applied to the first $50 which should add $3.50. This
> should bring the total to $110.50. When I enter in the amounts, and hit
> update form the PST is changed from $3.50 to $7.00 because the rate is
> 7%. if I change it back to $3.50 and then post the transaction it is
> stored properly with a total of $110.50. I can see this by looking at
> the totals in the chart of accounts and by doing a trial balance. When I
> then bring transaction up however, the PST is again modified to show
> $7.00 or 7% of the billed amount.
> 
> Is this a bug? Is there a way around it?
> 
> Any help here would be greatly accepted.
> 
> Thanks
> 
> 

Tax Override Bug

[Joe M. <jam...@hw...>]

I have certain vendors which charge diffferent taxes on different items
and I would like to be able to override what the tax paid is posted at,
however the system seems to store it properly but not recall it
properly.

For Example:

There are two taxes:
GST 7%
PST 7%

If I recieve a bill of services for $100 dollars, it would make sence
that if both taxes were applied I would be paying a total of $114.

In my scenario, the GST is applied to all $100 which would add $7, and
the PST is only applied to the first $50 which should add $3.50. This
should bring the total to $110.50. When I enter in the amounts, and hit
update form the PST is changed from $3.50 to $7.00 because the rate is
7%. if I change it back to $3.50 and then post the transaction it is
stored properly with a total of $110.50. I can see this by looking at
the totals in the chart of accounts and by doing a trial balance. When I
then bring transaction up however, the PST is again modified to show
$7.00 or 7% of the billed amount.

Is this a bug? Is there a way around it?

Any help here would be greatly accepted.

Thanks

-- 
Joe MacDonald
jam...@hw...
Focus Computer Consulting
250-861-3798

Re: Form::format_amount (SQL 1.8.0) Italian

[Jonas S. <jo...@jo...>]

On Sat, 19 Jan 2002 gd...@le... wrote:

> This problem depends to LOCALE on my Server; but if I run APACHE with:
>
>      export LC_CTYPE='en_EN'
>
> the problem is too present.

As far as I know, "en_EN" is incorrect. Instead, use "en_US", "en_GB" or
(preferrably, if what yo want is "do not specify language...") "C".

 - Jonas

-- 
Jonas Smedegaard (+45 40843136)          http://dr.jones.dk/~jonas/
Spiff ApS (= IT-guide dr. Jones ApS)     http://dr.jones.dk/
Debian GNU/Linux developer               http://people.debian.org/~js/

Re: Apache: URL Request TOO Large

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

Bring up an assembly in the "Edit Assembly" screen in ic.pl, note that each 
part number is a hyperlink. Right-click on one of the hyperlinks to "copy url 
to clipboard" and paste into a windows-notepad or kedit window... thats a 
lonnnngggg link. because apparently the 'callback' info grows longer for each 
item on a bill of materials.

-Dave

On Friday 18 January 2002 12:43 pm, you wrote:
> This makes no sense to me.  SL appears to use the POST method in forms, so
> the form data does not go in the url and its size should be effectively
> unlimited.
>
> It may help if you describe what you do, and the results, in more detail.
>
> -- Rod
>    http://www.sunsetsystems.com/
>
> On Friday 18 January 2002 08:36, David Ratte wrote:
> > Granted this is more of an Apache issue than sql-ledger, but I have a
> > problem while editiing a component from within a bill-of-materials, only
> > when the BOM is over a certain size (maybe 15-20 parts or so).
> >
> > Basically what happens is that since the screen is basically one big
> > $form, when you press submit a URL too great to process error occurs.
> >
> > So the big question: is there a compile-time option or config file
> > switch for the MAX URL SIZE? I couldn't find anything on the apache faq
> > site.
> >
> > Thanks
> > -Dave

Form::format_amount (SQL 1.8.0) Italian

[<gd...@le...>]

When I find item from Inventory; from input Customer Invoice , the Price
record is viewed with ",00" truncated.

The method Form::format_amount receive value "$amount" with "," and not ".";
 and conversion are lost.

This problem depends to LOCALE on my Server; but if I run APACHE with:

     export LC_CTYPE='en_EN'

the problem is too present.

To resolve in temporary manner I have change Form.pm to:
______________________________________________________
www:/opt/sql-ledger/SL # diff Form.pm Form.pm~
261a262
>
264,267d264
<
< # GDO change ',' to '.' (LC_LOCALE problems!?!)
<   $amount =~ s/,/./;
< # GDO END
______________________________________________________

Do yo have best solution ?

best regards

Guido brugnara

-- 
ing. Guido Brugnara tel.+39(461)390804 fax.396028
Leader.IT S.r.l.  (Leader Information Technology)
Strada della Pozzata, 41        www.leader.it/srl
38050 Villazzano TRENTO (ITALY)    in...@le...

Re: Apache: URL Request TOO Large

[Chris F. <ch...@fe...>]

On Fri, 18 Jan 2002 11:36:19 -0500  David Ratte wrote:
 +------------------
 | Granted this is more of an Apache issue than sql-ledger, but I have a
 | problem while editiing a component from within a bill-of-materials,
 | only when the BOM is over a certain size (maybe 15-20 parts or so).
 |
 | Basically what happens is that since the screen is basically one big
 | $form, when you press submit a URL too great to process error occurs.
 |
 | So the big question: is there a compile-time option or config file
 | switch for the MAX URL SIZE? I couldn't find anything on the apache
 | faq site.
 +------------------

It looks like sql-ledger uses application/x-www-form-urlencoded format for
form fields which limits the size of the URL to one that will fit into a
HTTP header. These "SHOULD" be less than 78 characters but "MUST" be no
more than 998 characters.  If sql-ledger used multipart/form-data then this
limit would not be an issue.  

--
    Chris Fedde

Re: Apache: URL Request TOO Large

[Rod R. <ro...@su...>]

This makes no sense to me.  SL appears to use the POST method in forms, so 
the form data does not go in the url and its size should be effectively 
unlimited.

It may help if you describe what you do, and the results, in more detail.

-- Rod
   http://www.sunsetsystems.com/

On Friday 18 January 2002 08:36, David Ratte wrote:
> Granted this is more of an Apache issue than sql-ledger, but I have a
> problem while editiing a component from within a bill-of-materials, only
> when the BOM is over a certain size (maybe 15-20 parts or so).
>
> Basically what happens is that since the screen is basically one big
> $form, when you press submit a URL too great to process error occurs.
>
> So the big question: is there a compile-time option or config file
> switch for the MAX URL SIZE? I couldn't find anything on the apache faq
> site.
>
> Thanks
> -Dave

Apache: URL Request TOO Large

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

Granted this is more of an Apache issue than sql-ledger, but I have a problem 
while editiing a component from within a bill-of-materials, only when the BOM 
is over a certain size (maybe 15-20 parts or so).

Basically what happens is that since the screen is basically one big $form, 
when you press submit a URL too great to process error occurs.

So the big question: is there a compile-time option or config file switch for 
the MAX URL SIZE? I couldn't find anything on the apache faq site.

Thanks
-Dave

login.pl problems

[<sql...@st...>]

I am having the following problem (As well as someone else on the list)

[Wed Jan 16 10:08:54 2002] [error] [client xxx.xxx.xxx.xxx] Premature end of script headers: /usr/local/sql-ledger/login.pl
Can't connect(  ), no database driver specified and DBI_DSN env var not set at SL/User.pm line 111
Compilation failed in require at /usr/local/sql-ledger/login.pl line 88.
[Wed Jan 16 10:14:22 2002] [error] [client xxx.xxx.xxx.xxx] Premature end of script headers: /usr/local/sql-ledger/login.pl


This is a new installation. All the admin functions work, but trying to login after creating a user gives the above error.

Could this be from some sort of CASE problem between Pg and pg?

-- 
Stephen Lawrence Jr.

Re: question regarding set up for rental items-Thanks Dieter and Steve

[Ed W. <ew...@rh...>]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Thanks Dieter.  I never thought about doing it this way and hopefully all 
responses to my question will help others too.  

Steve Doerr also posted an excellent reply and instructions, and I'm thanking 
him in this same email--thanks.  Your suggestion is the way 'I should' be 
doing this.

Thanks again to both of you,
- -- 
Ed Wiget
Owner/Senior Network Security Consultant
RHP Studios
"Keeping Your Data Safe!"
http://www.rhpstudios.com
email: ew...@rh...
email2: sec...@rh...
Office: 606-564-0046
Toll Free: 866-G02-RHPS (866-402-7477)
Fax: 606-564-0076

On Wednesday 16 January 2002 03:11 pm, Dieter Simader wrote:
> You could issue a zero amount invoice with a negative quantity (returned
> item). Your customer has a record that he returned the equipment and you
> add the equipment back to inventory.
>
>
> 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 Wed, 16 Jan 2002, Ed Wiget wrote:
> > -----BEGIN PGP SIGNED MESSAGE-----
> > Hash: SHA1
> >
> > We've been using sql ledger for over a year now and its truely been a
> > stable and efficient accounting program.  My accounting knowledge is
> > minimal but the program is simple enough to use and understand for all
> > but one service we offer.  This question should probably be directed to
> > an accountant, but I thought I'd give it a shot here first.
> >
> > The question I have is regarding items we purchase from a vendor and then
> > use as short-term rental merchandise to our customers.  Initially we had
> > this set up (albeit incorrectly) by creating the vendor order and price,
> > recieving the item and adding to our inventory, then billing the item out
> > at the rental rate to our customers (most of the time its a daily rate
> > below the original purchase price).
> >
> > The problem we are having is how do we add the item back into inventory
> > without crediting the customer account once it is returned?
> >
> > Thaks for Your time and help,
> > - --
> > Ed Wiget
> > Owner/Senior Network Security Consultant
> > RHP Studios
> > "Keeping Your Data Safe!"
> > http://www.rhpstudios.com
> > email: ew...@rh...
> > email2: sec...@rh...
> > Office: 606-564-0046
> > Toll Free: 866-G02-RHPS (866-402-7477)
> > Fax: 606-564-0076
> > -----BEGIN PGP SIGNATURE-----
> > Version: GnuPG v1.0.6 (GNU/Linux)
> > Comment: For info see http://www.gnupg.org
> >
> > iD8DBQE8RaE++EoLKxIs7PwRAmIxAJ4p03cVRwX9bhQc5ZN/ux22yZxsqACfQWFt
> > lAw9m5DyUKmKSJ7sSycxFrE=
> > =0c8z
> > -----END PGP SIGNATURE-----


-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.0.6 (GNU/Linux)
Comment: For info see http://www.gnupg.org

iD8DBQE8RuAx+EoLKxIs7PwRApFmAJ0fVX5DV3QtAXkhO2iZgwIfrP82/ACfbMAG
OXCnJ3564/d2KCboLADqrIk=
=ZyFz
-----END PGP SIGNATURE-----

Re: question regarding set up for rental items

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

Hi Ed.

First of all, Dieter's solution is fine since you've already recorded it as
inventory and you're small enough that no bankers or auditors are requiring you
to keep your books in accordance with U.S. GAAP (generally accepted acctg.
principles).

Now for the proper acctg. treatment.  What you have here is an operating lease,
which you should record as a Capital Asset (not inventory), which you will
depreciate, and record the subsequent revenue received from leasing it.

Here's how that would go in SL:
create an acct. under the Capital Assets heading called something like:
18XX - (description of) Equipment Leased to others (check it as an Exp/Asset
item)

Show the purchase of above equip.:
AP -> Add Transaction
fill in pertinet data
select the new Cap Asset next to the amount box
pay for it on purchase or later (whatever applies)

Create a lease revenue acct somewhere under the Sales Revenue heading called:
4XXX - Leased/Rental Equip. Revenue
check this as an income item

Show the rental/leasing of said equip:
AR -> Add Transaction
fill in pertinent data
select your new lease/rental revenue acct. next to the amount box
show receipt of payment on lease or later (whatever applies)

Then you depreciate it as appropriate over the life of the asset:
GL -> Add Transaction
Debit Amort/Deprec. Exp    (appropriate amt.)
Credit Accum. Amort./Deprec.  (appropriate amt.)

No inventory involved.  You can keep track of where stuff is at and depreciation
by asset with a spreadsheet if you need to.

This is just how you would have to record the above activity if you were ever
subject to an audit.

As long as that isn't the case, and you can keep track of things, you can do it
through inventory.  Just keep in mind if you take on partners, sell out, or do
any lending from banks, accountants and lawyers will probably get involved, and
you'll most likely be subject to GAAP for your books.

Hope that helps,
Steve

Ed Wiget wrote:

> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> We've been using sql ledger for over a year now and its truely been a stable
> and efficient accounting program.  My accounting knowledge is minimal but the
> program is simple enough to use and understand for all but one service we
> offer.  This question should probably be directed to an accountant, but I
> thought I'd give it a shot here first.
>
> The question I have is regarding items we purchase from a vendor and then use
> as short-term rental merchandise to our customers.  Initially we had this set
> up (albeit incorrectly) by creating the vendor order and price, recieving the
> item and adding to our inventory, then billing the item out at the rental
> rate to our customers (most of the time its a daily rate below the original
> purchase price).
>
> The problem we are having is how do we add the item back into inventory
> without crediting the customer account once it is returned?
>
> Thaks for Your time and help,
> - --
> Ed Wiget
> Owner/Senior Network Security Consultant
> RHP Studios
> "Keeping Your Data Safe!"
> http://www.rhpstudios.com
> email: ew...@rh...
> email2: sec...@rh...
> Office: 606-564-0046
> Toll Free: 866-G02-RHPS (866-402-7477)
> Fax: 606-564-0076
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG v1.0.6 (GNU/Linux)
> Comment: For info see http://www.gnupg.org
>
> iD8DBQE8RaE++EoLKxIs7PwRAmIxAJ4p03cVRwX9bhQc5ZN/ux22yZxsqACfQWFt
> lAw9m5DyUKmKSJ7sSycxFrE=
> =0c8z
> -----END PGP SIGNATURE-----

Re: question regarding set up for rental items

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

You could issue a zero amount invoice with a negative quantity (returned
item). Your customer has a record that he returned the equipment and you
add the equipment back to inventory.


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 Wed, 16 Jan 2002, Ed Wiget wrote:

> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
> 
> We've been using sql ledger for over a year now and its truely been a stable 
> and efficient accounting program.  My accounting knowledge is minimal but the 
> program is simple enough to use and understand for all but one service we 
> offer.  This question should probably be directed to an accountant, but I 
> thought I'd give it a shot here first.
> 
> The question I have is regarding items we purchase from a vendor and then use 
> as short-term rental merchandise to our customers.  Initially we had this set 
> up (albeit incorrectly) by creating the vendor order and price, recieving the 
> item and adding to our inventory, then billing the item out at the rental 
> rate to our customers (most of the time its a daily rate below the original 
> purchase price).  
> 
> The problem we are having is how do we add the item back into inventory 
> without crediting the customer account once it is returned?
> 
> Thaks for Your time and help,
> - -- 
> Ed Wiget
> Owner/Senior Network Security Consultant
> RHP Studios
> "Keeping Your Data Safe!"
> http://www.rhpstudios.com
> email: ew...@rh...
> email2: sec...@rh...
> Office: 606-564-0046
> Toll Free: 866-G02-RHPS (866-402-7477)
> Fax: 606-564-0076
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG v1.0.6 (GNU/Linux)
> Comment: For info see http://www.gnupg.org
> 
> iD8DBQE8RaE++EoLKxIs7PwRAmIxAJ4p03cVRwX9bhQc5ZN/ux22yZxsqACfQWFt
> lAw9m5DyUKmKSJ7sSycxFrE=
> =0c8z
> -----END PGP SIGNATURE-----
> 
> 

Re: [SLE] Linux Ready for desktop -yes - Zdnet - Suse7.3 review

[<ke...@dk...>]

On Wed, Jan 16, 2002 at 07:59:37PM +0100, Jonas Smedegaard wrote:
> On Wed, 16 Jan 2002, Keld Jørn Simonsen wrote:
> 
> > Somebody told me to try to get sql-ledger into Debian as a package.
> > I will try and see what I can do.
> 
> I am working on that currrently. I'd be quite interested in others doing
> duplicate/better work.

Good! Then I may not have to do it.


>  - Jonas
> 
> P.S.
> 
> Was it Bo Blåbjerg from KaosPilot University perhaps? - I was told he
> contacted you recently, and they run Debian (I maintain their servers).

Yes, Bo contacted me, but it was a Norwegian that asked me to
do something for debian.

Keld

Re: [SLE] Linux Ready for desktop -yes - Zdnet - Suse7.3 review

[Jonas S. <jo...@jo...>]

On Wed, 16 Jan 2002, Keld Jørn Simonsen wrote:

> Somebody told me to try to get sql-ledger into Debian as a package.
> I will try and see what I can do.

I am working on that currrently. I'd be quite interested in others doing
duplicate/better work.

 - Jonas

P.S.

Was it Bo Blåbjerg from KaosPilot University perhaps? - I was told he
contacted you recently, and they run Debian (I maintain their servers).

-- 
Jonas Smedegaard (+45 40843136)          http://dr.jones.dk/~jonas/
Spiff ApS (= IT-guide dr. Jones ApS)     http://dr.jones.dk/
Debian GNU/Linux developer               http://people.debian.org/~js/

Re: [SLE] Linux Ready for desktop -yes - Zdnet - Suse7.3 review

[<ke...@dk...>]

Somebody told me to try to get sql-ledger into Debian as a package.
I will try and see what I can do.

Keld

On Tue, Jan 15, 2002 at 03:02:31PM -0800, Rod Roark wrote:
> On Tuesday 15 January 2002 13:57, tom poe wrote:
> > On Tuesday 15 January 2002 13:15, dids wrote:
> > > http://news.zdnet.co.uk/story/0,,t269-s2102466,00.html
> 
> It's great to see proclamations like this from major publications.  2002 
> might just be The Year of Linux.
> 
> > Hi:  Exactly!  And, when SuSE begins to include "Killer App2002",
> > sql-ledger, the Open Source accounting software, in its distribution,
> > watch out world! Just a thought,
> 
> I'll second that.  SL should really start taking off when enough business 
> get exposure to it, and start creating their own add-ons that feed back 
> into the user base.  Great work Dieter - I predict you'll be famous!
> 
> -- Rod
>    http://www.sunsetsystems.com/
>