sql-ledger-users — SQL-Ledger users

Re: [SL] Rental Apartments == Parts ??

[Rich S. <rsh...@ap...>]

On Sun, 5 Aug 2007, Michael Hasse wrote:

> Seems to me this might work better using the Projects functionality
> of SL.

   I agree. I had seen the subject line before, but not read the thread until
now. Each vacation unit would be a separate project, with its own number.
If there's the potential for additional property to be managed, then the
project number could have two digits (for example), a decimal point, and
three digits. This would accommodate 99 separate properties, each with a
maximum of 999 units.

>    One could define the apartments as either services or as personnel,
> (not sure which would be more appropriate, probably personnel), and each
> rental period would be a "project".

   The services would be standard rental times; for example, 1 week, 2 weeks,
1 month, 3 months, etc. This makes them consistent and the reporting easier
to track.

Just my 25-cents' worth (inflation, you know).

Rich

-- 
Richard B. Shepard, Ph.D.               |    The Environmental Permitting
Applied Ecosystem Services, Inc.        |          Accelerator(TM)
<http://www.appl-ecosys.com>     Voice: 503-667-4517      Fax: 503-667-8863

Re: [SL] Rental Apartments == Parts ??

[Michael H. <mh...@it...>]

Seems to me this might work better using the Projects functionality  
of SL.
    One could define the apartments as either services or as  
personnel, (not sure which would be more appropriate, probably  
personnel), and each rental period would be a "project".


Thanks,

Michael



On Aug 4, 2007, at 7:09 AM, Bob Gustafson wrote:

> I am attempting to mould sql-ledger into a useful tool to manage a few
> vacation apartments.
>
> I wonder whether anyone else has attempted to interpret a day of
> apartment rental as a mechanical part.
>
> The 'inventory' on each day is the number of unrented apartments. Each
> apartment is a separate part with a part number and price (for one  
> day).
>
> All of the parts (apartments) are sold at midnight, some for zero  
> amount
> (empty apartments).
>
> A new shipment of parts comes in every day at one minute past  
> midnight,
> some of them are already presold (reservations).
>
> Does this make sense?
>
> Has anyone else done it?
>
> Bob G
>
> ---------------------------------------------------------------------- 
> ---
> This SF.net email is sponsored by: Splunk Inc.
> Still grepping through log files to find problems?  Stop.
> Now Search log events and configuration files using AJAX and a  
> browser.
> Download your FREE copy of Splunk now >>  http://get.splunk.com/
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users

[SL] Rental Apartments == Parts ??

[Bob G. <bo...@rc...>]

I am attempting to mould sql-ledger into a useful tool to manage a few
vacation apartments.

I wonder whether anyone else has attempted to interpret a day of
apartment rental as a mechanical part.

The 'inventory' on each day is the number of unrented apartments. Each
apartment is a separate part with a part number and price (for one day).

All of the parts (apartments) are sold at midnight, some for zero amount
(empty apartments).

A new shipment of parts comes in every day at one minute past midnight,
some of them are already presold (reservations).

Does this make sense?

Has anyone else done it?

Bob G

Re: [SL] cacsh->receipt irritation

[Dr E. L. <el...@li...>]

Thanks.

el

on 7/31/07 4:34 PM Dieter Simader said the following:
> On Mon, 30 Jul 2007, Mel Broadhurst wrote:
>
>> Dr Eberhard Lisse wrote:
>>> Hi,
>>>
>>> Open Cash->Receipt, select customer, update.
>>>
>>> Tick some invoices (and update) then change the date, and/or add
>>> to Memo and/or source and/or account.
>>>
>>> The selected invoices are unselected, which, if you do a number of
>>> invoices is indeed quite a nuisance, as far as I am concerned,
>>> because I do not want to have to remember a particular order of
>>> doing things.
>>>
>>> Has anybody noticed this behaviour and if so would it be a bug or
>>> a feature :-)-O (2.8.6).
>>>
>>> greetings, el
>>>
>>    Hi
>>
>> I understand that this change was made by Dieter to accommodate a
>> very large customer of his.  There is no way around this.  After
>> updating the customer, fill in the top part of the screen and then
>> click on update again prior to ticking off any of the invoices.
>> Then tick off the invoices and update again.  What it boils down to
>> is one extra update click.
>
> It's not an extra click but you have to make a selection of the
> accounts before you click.
>
> The way around not having to select the AP account is to edit your
> chart of accounts and get rid of extra accounts you don't need.

-- 
Dr. Eberhard W. Lisse  \        / Obstetrician & Gynaecologist (Saar)
el...@li... el108-ARIN / *     |   Telephone: +264 81 124 6733 (cell)
PO Box 8421             \     /   Please do NOT email to this address
Bachbrecht, Namibia     ;____/        if it is DNS related in ANY way

Re: [SL] cacsh->receipt irritation

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

On Mon, 30 Jul 2007, Mel Broadhurst wrote:

> Dr Eberhard Lisse wrote:
>> Hi,
>>
>> Open Cash->Receipt, select customer, update.
>>
>> Tick some invoices (and update) then change the date, and/or add to Memo
>> and/or source and/or account.
>>
>> The selected invoices are unselected, which, if you do a number of
>> invoices is indeed quite a nuisance, as far as I am concerned, because I
>> do not want to have to remember a particular order of doing things.
>>
>> Has anybody noticed this behaviour and if so would it be a bug or a
>> feature :-)-O (2.8.6).
>>
>> greetings, el
>>
>    Hi
> I understand that this change was made by Dieter to accommodate  a very
> large customer of his. There is no way around this. After updating the
> customer, fill in the top part of the screen and then click on update
> again prior to ticking off any of the invoices. Then tick off the
> invoices and update again.
> What it boils down to is one extra update click.

It's not an extra click but you have to make a selection of the accounts 
before you click.

The way around not having to select the AP account is to edit your chart 
of accounts and get rid of extra accounts you don't need.

[SL] Reporting/searching Internal Notes?

[Michael H. <mh...@it...>]

Hello Everyone,

    Just wondering if anyone is using the Internal Notes portion of  
their invoices?  We would like to start using them for, well,  
internal notes!  But have found that there doesn't seem to be any way  
to search on the field.  We can obviously hit the data on the back  
end with a query but were just wondering if maybe we were simply  
missing it somewhere...?


Thanks!

Michael

Re: [SL] cacsh->receipt irritation

[Dr E. L. <el...@li...>]

Thanks, I was told already it's a feature :-)-O

el

on 7/30/07 10:46 PM Mel Broadhurst said the following:
> Dr Eberhard Lisse wrote:
>> Hi,
>>
>> Open Cash->Receipt, select customer, update.
>>
>> Tick some invoices (and update) then change the date, and/or add to Memo
>> and/or source and/or account.
>>
>> The selected invoices are unselected, which, if you do a number of
>> invoices is indeed quite a nuisance, as far as I am concerned, because I
>> do not want to have to remember a particular order of doing things.
>>
>> Has anybody noticed this behaviour and if so would it be a bug or a
>> feature :-)-O (2.8.6).
>>
>> greetings, el
>>   
>     Hi
> I understand that this change was made by Dieter to accommodate  a very
> large customer of his. There is no way around this. After updating the
> customer, fill in the top part of the screen and then click on update
> again prior to ticking off any of the invoices. Then tick off the
> invoices and update again.
> What it boils down to is one extra update click.
> 
> Regards
> 
> Mel B.
> 
> -------------------------------------------------------------------------
> This SF.net email is sponsored by: Splunk Inc.
> Still grepping through log files to find problems?  Stop.
> Now Search log events and configuration files using AJAX and a browser.
> Download your FREE copy of Splunk now >>  http://get.splunk.com/
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users

-- 
Dr. Eberhard W. Lisse  \        / Obstetrician & Gynaecologist (Saar)
el...@li... el108-ARIN / *     |   Telephone: +264 81 124 6733 (cell)
PO Box 8421             \     /   Please do NOT email to this address
Bachbrecht, Namibia     ;____/        if it is DNS related in ANY way

Re: [SL] cacsh->receipt irritation

[Mel B. <too...@nu...>]

Dr Eberhard Lisse wrote:
> Hi,
>
> Open Cash->Receipt, select customer, update.
>
> Tick some invoices (and update) then change the date, and/or add to Memo
> and/or source and/or account.
>
> The selected invoices are unselected, which, if you do a number of
> invoices is indeed quite a nuisance, as far as I am concerned, because I
> do not want to have to remember a particular order of doing things.
>
> Has anybody noticed this behaviour and if so would it be a bug or a
> feature :-)-O (2.8.6).
>
> greetings, el
>   
    Hi
I understand that this change was made by Dieter to accommodate  a very
large customer of his. There is no way around this. After updating the
customer, fill in the top part of the screen and then click on update
again prior to ticking off any of the invoices. Then tick off the
invoices and update again.
What it boils down to is one extra update click.

Regards

Mel B.

[SL] How do i

[Philip K. M. <pma...@fe...>]

How do I change main currency to other country currency?

Thank you!!

On Friday 27 July 2007 08:18:43 am Dr Eberhard Lisse wrote:
> Hi,
>
> Open Cash->Receipt, select customer, update.
>
> Tick some invoices (and update) then change the date, and/or add to Memo
> and/or source and/or account.
>
> The selected invoices are unselected, which, if you do a number of
> invoices is indeed quite a nuisance, as far as I am concerned, because I
> do not want to have to remember a particular order of doing things.
>
> Has anybody noticed this behaviour and if so would it be a bug or a
> feature :-)-O (2.8.6).
>
> greetings, el

Re: [SL] System for updating user copies of sql-ledger and retaining user fiddles

[Bob G. <bo...@rc...>]

This is more on the subject of Subversion and sql-ledger

Attached is a script for doing sql-ledger version upgrades and keeping
all the files (with your own tweeks too) under version control.

The script follows the block diagram below:

#  /usr/local/sql-ledger          svnrepos (directories below within
repos)
#  ---------------------          ---------------------------------
#      (STEP1)            import
#  vendor v 2.8.5       ->->->->-> /vendor/sql-ledger/current
#
#                            <-<-< /vendor/sql-ledger/current
#                            v
#      (STEP2)          copy | tag
#                            v
#                            >->-> /vendor/sql-ledger/sql-ledger-2.8.5
#
#                            <-<-< /vendor/sql-ledger/sql-ledger-2.8.5
#                            v
#      (STEP3)          copy | to main
#                            v
#                            >->-> /sql-ledger/
#      (STEP4)
#      rm -rf
#                            <-<-< /sql-ledger/
#                        checkout
# /usr/local/sql-ledger  <-<-|
#         |
#         V
# -------------------
# | external update |  (STEP5)
# |   to v 2.8.6    |
# -------------------
#         |
#         V            (STEP6) Backup and inspect the new 2.8.6 update
#         |
# /usr/local/sql-ledger ->->-> 
#                            v
#       (STEP7)        svn_load_dirs
#                            v
#                            >->-> /vendor/sql-ledger/current
#
#                            <-<-< /vendor/sql-ledger/current
#                            v
#                       copy | tag (done as part of above command
#                            v
#                            >->-> /vendor/sql-ledger/sql-ledger-2.8.6
#
#                            <-<-< /vendor/sql-ledger/sql-ledger-2.8.5
#                            v
#                            <-<-< /vendor/sql-ledger/current
#                            v
#       (STEP8)            merge
#                            v
#                            >->-> /sql-ledger/
#
#       (STEP9)           commit


On Thu, 2007-07-12 at 12:45 -0500, Bob Gustafson wrote:
> If you have been tempted to make changes to the sql-ledger code to
> respond to local requirements, using svn as your source code control
> system offers an 'easy' way to handle your changes and the upgrade to
> new versions when they come out.
> 
> This piece of the svn handbook outlines the approach:
> 
> http://svnbook.red-bean.com/nightly/en/svn.advanced.vendorbr.html
> 
> -------------------------------------------------------------------------

Re: [SL] cacsh->receipt irritation

[Dr E. L. <el...@li...>]

Thanks :-)-O

el

on 7/27/07 6:08 PM Dieter Simader said the following:
> On Fri, 27 Jul 2007, Dr Eberhard Lisse wrote:
>
>> Hi,
>>
>> Open Cash->Receipt, select customer, update.
>>
>> Tick some invoices (and update) then change the date, and/or add to
>> Memo and/or source and/or account.
>>
>> The selected invoices are unselected, which, if you do a number of
>> invoices is indeed quite a nuisance, as far as I am concerned,
>> because I do not want to have to remember a particular order of
>> doing things.
>>
>> Has anybody noticed this behaviour and if so would it be a bug or a
>> feature :-)-O (2.8.6).
>
> This is a feature.  Transactions are collected by currency, a
> payment threshold, department, type of business, AP account and due
> dates.

Re: [SL] cacsh->receipt irritation

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

On Fri, 27 Jul 2007, Dr Eberhard Lisse wrote:

> Hi,
>
> Open Cash->Receipt, select customer, update.
>
> Tick some invoices (and update) then change the date, and/or add to Memo
> and/or source and/or account.
>
> The selected invoices are unselected, which, if you do a number of
> invoices is indeed quite a nuisance, as far as I am concerned, because I
> do not want to have to remember a particular order of doing things.
>
> Has anybody noticed this behaviour and if so would it be a bug or a
> feature :-)-O (2.8.6).

This is a feature. Transactions are collected by currency, a payment 
threshold, department, type of business, AP account and due dates.

Re: [SL] Same vendor and customer

[Stuart L. <s-l...@uc...>]

On =E6=9C=A8, 2007-07-26 at 18:51 -0700, Jeff Roberts wrote:
> Hi Stuart
>=20
> Why even set him up as a vendor if it's just a service fee once every=20
> payroll. Just create a "service fee" income account and tick the=20
> Expense/Asset button under Payables. That will make it appear in the=20
> drop down list when you are processing the employees paycheque. Then=20
> simply enter a negative amount on one line of the AP transaction when=20
> you make the guys paycheque and choose the "Service Fee" account. The=20
> transaction will still be posted against all the correct expense=20
> accounts but the service fee will then be left in the bank account
> and=20
> registered as income. Sort of as if he paid it out of his pocket.
> When=20
> you print the AP transaction it will show the Service fee as a
> deduction=20
> from his paycheque so there is no need for an extra invoice/receipt.

Yup, excellent idea. You can tell that I'm not an accountant since I
wouldn't think of making an income account an expense as well. Thanks
very much, Jeff.

--=20
Stuart Luppescu -=3D-=3D- slu <AT> ccsr <DOT> uchicago <DOT> edu
CCSR at U of C ,.;-*^*-;.,  ccsr.uchicago.edu
     (^_^)/    =E6=89=8D=E6=96=87=E3=81=A8=E6=99=BA=E5=A5=88=E7=BE=8E=E3=81=
=AE=E7=88=B6
Thank God I'm an atheist!

[SL] cacsh->receipt irritation

[Dr E. L. <el...@li...>]

Hi,

Open Cash->Receipt, select customer, update.

Tick some invoices (and update) then change the date, and/or add to Memo
and/or source and/or account.

The selected invoices are unselected, which, if you do a number of
invoices is indeed quite a nuisance, as far as I am concerned, because I
do not want to have to remember a particular order of doing things.

Has anybody noticed this behaviour and if so would it be a bug or a
feature :-)-O (2.8.6).

greetings, el
-- 
Dr. Eberhard W. Lisse  \        / Obstetrician & Gynaecologist (Saar)
el...@li... el108-ARIN / *     |   Telephone: +264 81 124 6733 (cell)
PO Box 8421             \     /   Please do NOT email to this address
Bachbrecht, Namibia     ;____/        if it is DNS related in ANY way

Re: [SL] Same vendor and customer

[Jeff R. <je...@jr...>]

Hi Stuart

Why even set him up as a vendor if it's just a service fee once every 
payroll. Just create a "service fee" income account and tick the 
Expense/Asset button under Payables. That will make it appear in the 
drop down list when you are processing the employees paycheque. Then 
simply enter a negative amount on one line of the AP transaction when 
you make the guys paycheque and choose the "Service Fee" account. The 
transaction will still be posted against all the correct expense 
accounts but the service fee will then be left in the bank account and 
registered as income. Sort of as if he paid it out of his pocket. When 
you print the AP transaction it will show the Service fee as a deduction 
from his paycheque so there is no need for an extra invoice/receipt.

Jeff


Stuart Luppescu wrote:
> Hello, Is it impossible to link a vendor account and a customer account?
> We have an employee for whom we are required to withhold child support
> payments. We can also take a service fee from the employee's pay for
> forwarding the child support payments to the state. The service fee is a
> form of income, so we fill out an AR transaction for that. The
> employee's pay is an AP transaction. Unfortunately, it seems that it's
> impossible to link those transactions because the employee as the
> VENDOR, to whom we pay wages, cannot be linked to the employee as the
> CUSTOMER, who pays us the service fee. 
>
> Does anyone know how to get around this problem?
>
> Thanks.
>   

[SL] Same vendor and customer

[Stuart L. <s-l...@uc...>]

Hello, Is it impossible to link a vendor account and a customer account?
We have an employee for whom we are required to withhold child support
payments. We can also take a service fee from the employee's pay for
forwarding the child support payments to the state. The service fee is a
form of income, so we fill out an AR transaction for that. The
employee's pay is an AP transaction. Unfortunately, it seems that it's
impossible to link those transactions because the employee as the
VENDOR, to whom we pay wages, cannot be linked to the employee as the
CUSTOMER, who pays us the service fee. 

Does anyone know how to get around this problem?

Thanks.
-- 
Stuart Luppescu       -=- s-luppescu .at. uchicago.edu
University of Chicago -=- CCSR
www.consortium-chicago.org

Re: [SL] upgrade problem

[Paul T. <pt...@wa...>]

Adam Vande More schreef:
> There's documentation on it somewhere...I think perhaps you replace
> the url of current d/l with the version number you're trying to get.
> However, I'm not quite sure what this will help with since it runs the
> same upgrade scripts either way.  IIRC, there is something borked on a
> some of these upgrades and it either requires editing the script(s),
> or the db.
>   
How about reading the docs in the download itself?
There are upgrade insructions on the download page of SQL-Ledger.

*Upgrading from any version > 1.2.7 to the latest version* Upgrading is 
easy. Load setup.pl from the sql-ledger root directory and select 
Upgrade. The script will lock everyone out and install the new code over 
top. The only thing left to do is to log in to upgrade a dataset.

To upgrade manually load admin.pl and Lock the system. Download the new 
code and untar over top and fix the permissions according to the UPGRADE 
<http://www.sql-ledger.com/source/upgrade/> file in the doc directory. 
Most of the time there is nothing else to be done. Load admin.pl and 
Unlock the system. When a user logs in the Dataset is upgraded 
automatically, you do not have to do anything. If other steps are 
required, i.e template modifications, they will be listed in the UPGRADE 
file.
You *DO NOT* have to install intermediate versions to upgrade to the 
latest version! Intermediate upgrades are done for you.


Almost foolproof it would seem?

Re: [SL] upgrade problem

[Adam V. M. <amv...@gm...>]

There's documentation on it somewhere...I think perhaps you replace
the url of current d/l with the version number you're trying to get.
However, I'm not quite sure what this will help with since it runs the
same upgrade scripts either way.  IIRC, there is something borked on a
some of these upgrades and it either requires editing the script(s),
or the db.

On 7/23/07, Chad Jackson [LJNet Consultants] <ch...@lj...> wrote:
> I agree that this would be the right solution to this type of problem. I
> would also follow this upgrade path if there was place that I could download
> the missing versions, since my last upgrade. Is there an archive of all
> versions somewhere that is accessible.
>
>
>
> -----Original Message-----
> From: sql...@li...
> [mailto:sql...@li...] On Behalf Of Bob
> Gustafson
> Sent: 19 July 2007 08:57 AM
> To: sql...@li...
> Subject: Re: [SL] upgrade problem
>
> Maybe if you take small update steps (i.e., 2.6.27 to 2.7.1 to 2.8.1 to
> 2.8.5 to 2.8.6) you would have better results.
>
> (Those versions are just for example - they may not be the best, or even
> available..)
>
> On Tue, 2007-07-17 at 13:57 +0100, JMC SOFTWARE wrote:
> > Hi
> >
> > Having trouble upgrading 2.6.27 to 2.8.5
> >
> > I keep getting errors
> >
> > *create table cargo (id int not null, trans_id int not null, package
> > text, netweight float4, grossweight float4, volume float4)
> > ERROR: relation "cargo" already exists
> >
> > *I drop the table and goto a few more of the same errors droping tables
> > br, vr, etc
> >
> > Anybody got this upgrade to work and how did they do it.
> >
> > Any help appreciated.
> >
> > Joe*
> > *
> >
> > -------------------------------------------------------------------------
> > This SF.net email is sponsored by DB2 Express
> > Download DB2 Express C - the FREE version of DB2 express and take
> > control of your XML. No limits. Just data. Click to get it now.
> > http://sourceforge.net/powerbar/db2/
> > _______________________________________________
> > sql-ledger-users mailing list
> > sql...@li...
> > https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>
> -------------------------------------------------------------------------
> This SF.net email is sponsored by DB2 Express
> Download DB2 Express C - the FREE version of DB2 express and take
> control of your XML. No limits. Just data. Click to get it now.
> http://sourceforge.net/powerbar/db2/
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>
>
> -------------------------------------------------------------------------
> This SF.net email is sponsored by: Splunk Inc.
> Still grepping through log files to find problems?  Stop.
> Now Search log events and configuration files using AJAX and a browser.
> Download your FREE copy of Splunk now >>  http://get.splunk.com/
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>



-- 
Adam Vande More
Systems Administrator
Mobility Sales

Re: [SL] upgrade problem

[Chad J. [L. Consultants] <ch...@lj...>]

I agree that this would be the right solution to this type of problem. I
would also follow this upgrade path if there was place that I could download
the missing versions, since my last upgrade. Is there an archive of all
versions somewhere that is accessible.



-----Original Message-----
From: sql...@li...
[mailto:sql...@li...] On Behalf Of Bob
Gustafson
Sent: 19 July 2007 08:57 AM
To: sql...@li...
Subject: Re: [SL] upgrade problem

Maybe if you take small update steps (i.e., 2.6.27 to 2.7.1 to 2.8.1 to
2.8.5 to 2.8.6) you would have better results.

(Those versions are just for example - they may not be the best, or even
available..)

On Tue, 2007-07-17 at 13:57 +0100, JMC SOFTWARE wrote:
> Hi
> 
> Having trouble upgrading 2.6.27 to 2.8.5
> 
> I keep getting errors
> 
> *create table cargo (id int not null, trans_id int not null, package
> text, netweight float4, grossweight float4, volume float4)
> ERROR: relation "cargo" already exists
> 
> *I drop the table and goto a few more of the same errors droping tables
> br, vr, etc
> 
> Anybody got this upgrade to work and how did they do it.
> 
> Any help appreciated.
> 
> Joe*
> *
> 
> -------------------------------------------------------------------------
> This SF.net email is sponsored by DB2 Express
> Download DB2 Express C - the FREE version of DB2 express and take
> control of your XML. No limits. Just data. Click to get it now.
> http://sourceforge.net/powerbar/db2/
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users

-------------------------------------------------------------------------
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
_______________________________________________
sql-ledger-users mailing list
sql...@li...
https://lists.sourceforge.net/lists/listinfo/sql-ledger-users

Re: [SL] upgrade problem

[Bob G. <bo...@rc...>]

Maybe if you take small update steps (i.e., 2.6.27 to 2.7.1 to 2.8.1 to
2.8.5 to 2.8.6) you would have better results.

(Those versions are just for example - they may not be the best, or even
available..)

On Tue, 2007-07-17 at 13:57 +0100, JMC SOFTWARE wrote:
> Hi
> 
> Having trouble upgrading 2.6.27 to 2.8.5
> 
> I keep getting errors
> 
> *create table cargo (id int not null, trans_id int not null, package
> text, netweight float4, grossweight float4, volume float4)
> ERROR: relation "cargo" already exists
> 
> *I drop the table and goto a few more of the same errors droping tables
> br, vr, etc
> 
> Anybody got this upgrade to work and how did they do it.
> 
> Any help appreciated.
> 
> Joe*
> *
> 
> -------------------------------------------------------------------------
> This SF.net email is sponsored by DB2 Express
> Download DB2 Express C - the FREE version of DB2 express and take
> control of your XML. No limits. Just data. Click to get it now.
> http://sourceforge.net/powerbar/db2/
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users

[SL] upgrade problem

[JMC S. <in...@jm...>]

Hi

Having trouble upgrading 2.6.27 to 2.8.5

I keep getting errors

*create table cargo (id int not null, trans_id int not null, package
text, netweight float4, grossweight float4, volume float4)
ERROR: relation "cargo" already exists

*I drop the table and goto a few more of the same errors droping tables
br, vr, etc

Anybody got this upgrade to work and how did they do it.

Any help appreciated.

Joe*
*

Re: [SL] Locks removal

[Dirk E. S. <ds...@ca...>]

> On Sat, 14 Jul 2007, Dirk Enrique Seiffert wrote:
>
>> With SQL-Ledger 2.8.5 I have some problems with locked transactions.
>> Some
>> transactions get locked forever: User A posts or edits a transaction,
>> logs
>> out. Next day another user B wants to use or pay the transaction but it
>> does not appear in payables. When B tries to edit the transaction it is
>> locked by A. Workaround is: User B reposts or deleting the lock directly
>> in the database.
>>
>> The admin "remove lock" function shows a "Permission denied" error.
>>
>> Any ideas how to solve this problem?
>
> IIRC you need to be at least a manager.

Thanks! - "Manager" is not good enough but "Administrator" does the job!

I am still wondering for which reason transactions stay locked.

Enrique


-- 
Dirk Enrique Seiffert - Lintec S.A.
Ed. Torre del Reloj - Of. 401
Plaza de los Coches, Centro
Cartagena - Colombia
http://www.lintecsa.com

Re: [SL] Locks removal

[Tom D. <td...@ro...>]

On Sat, 14 Jul 2007, Dirk Enrique Seiffert wrote:

> With SQL-Ledger 2.8.5 I have some problems with locked transactions. Some
> transactions get locked forever: User A posts or edits a transaction, logs
> out. Next day another user B wants to use or pay the transaction but it
> does not appear in payables. When B tries to edit the transaction it is
> locked by A. Workaround is: User B reposts or deleting the lock directly
> in the database.
>
> The admin "remove lock" function shows a "Permission denied" error.
>
> Any ideas how to solve this problem?

IIRC you need to be at least a manager.

Regards,

-- 
Tom Diehl		td...@ro...		Spamtrap address mt...@ro...

[SL] Locks removal

[Dirk E. S. <ds...@ca...>]

With SQL-Ledger 2.8.5 I have some problems with locked transactions. Some
transactions get locked forever: User A posts or edits a transaction, logs
out. Next day another user B wants to use or pay the transaction but it
does not appear in payables. When B tries to edit the transaction it is
locked by A. Workaround is: User B reposts or deleting the lock directly
in the database.

The admin "remove lock" function shows a "Permission denied" error.

Any ideas how to solve this problem?

Thanks

Enrique


-- 
Dirk Enrique Seiffert - Lintec S.A.
Ed. Torre del Reloj - Of. 401
Plaza de los Coches, Centro
Cartagena - Colombia
http://www.lintecsa.com

Re: [SL] Printing Problem - please help! --> RESOLVED

[Mike <lak...@co...>]

Mike wrote:
> Hello,
> 
> I recently switched Linux distros from OpenSUSE 10.2 to Ubuntu 
> 7.04. Finally, today I was able to get SQL-Ledger working 
> again with Ubuntu, but I cannot print. Even though I've 
> followed the steps in the faq for printing, it doesn't print. 
> Printed fine with OpenSUSE!
> 
> I've checked my /var/run/cups/printcap file for the printer 
> name and placed the name properly in the sql-ledger.conf file 
> (just as I did in opensuse) but still, nothing! I've checked 
> using lpstat -v to be sure lpr is properly working, it is. 
> Latex is installed and the "1" is set in the sql-ledger.conf 
> file where needed.
> 
> It's puzzling to me because I had this setup working fine 
> under OpenSUSE and printing perfectly. Anyone have any 
> suggestions?
> 

Kindly disregard my above message. I searched the previous 
emails of this list and found the resolution to my problem 
(something I should have done before posting). Thankfully I 
never delete any of the emails that I get from this list.

Thanks to everyone that helped out ATM Logic back on 
02-15-2006 for the answer!

Mike