sql-ledger-users — SQL-Ledger users

Re: [SL] Various Problems SL 2.4.11/PGSQL 8.1.3

[Jason K. <ja...@no...>]

Hello.  I am currently trying to fix some problems I am having with SL
2.4.11 on Postgresql 8.1.3 (migrated to another machine with 8.2.0 while
I try and fix it):

1) When I try to print an invoice containing an assembly, I get the
following error:

DBD::Pg::st execute failed: ERROR: column a.oid does not exist
LINE 8: ORDER BY a.oid
^
Error!
SELECT p.partnumber, p.description, p.unit, a.qty, 			pg.partsgroup,
p.partnumber AS sku FROM assembly a JOIN parts p ON (a.parts_id = p.id)
LEFT JOIN partsgroup pg ON (p.partsgroup_id = pg.id) WHERE a.bom = '1'
AND a.id = '10151' ORDER BY a.oid ERROR: column a.oid does not exist
LINE 8: ORDER BY a.oid ^

2) When I create a new inventory item, duplicate inventory items are
sometimes created (and when I add or remove stock of such, it is
duplicated as well).

3) When I create a new invoice, (very) old inventory items and payments
are sometimes shown on the new invoice along with what I have entered,
after the invoice is posted.

I have been reading the SQL-Ledger FAQ, the SQL-Ledger manual, the
Postgresql FAQ and Online Documentation and Googling the internet in
general in an attempt to determine how to fix my SL installation.  I've
especially been paying attention to any information regarding OID's.  I
have also been learning how to do basic querying in Postgresql.

I have looked at the assembly table and it has the following columns:
id   | parts_id | qty | bom | adj
Can I add the missing a.oid column to the table?  If so, how do I
populate it with the correct values?

In the FAQ, it states:

If you already built a dataset without this change (referring to
creating the orderitems, inventory and assembly tables WITH OIDS) you
will get an error when you try to save a PO or assembly.

"ERROR: column "oid" does not exist"

Drop the tables and rebuild WITH OIDS.

I attempted this (even though I can create and save an assembly without
a problem -- I just can't print an invoice that contains an assembly) by
using the COPY TO command to send the contents of each table to file,
dropping each table, creating each table as per the FAQ and then using
the COPY FROM command to repopulate the tables.  This did not help with
my first problem.  I will be testing to see if the second and third
issues are still present or not.

I believe this started (at least the assembly-related issues) when I
attempted to upgrade to SL 2.6.19 a few months ago.  I'm pretty sure I
didn't lock the database prior to untarring the upgrade file (and fixing
the file permissions).  The database was upgraded and I ended up with an
unusable mess!  Since I did not have the time to play around, I restored
a backup of the SQL-Ledger directory and restored a backup of the
database that I had made just prior.  Unfortunately, I don't recall
changing the DROP SEQUENCE entries to SELECT SETVAL entries as per the
FAQ.  Since I don't use assemblies very often, I didn't notice anything
wrong until recently.  The second and third problems that I listed above
didn't show up until much later.

If anyone has any wisdom to share, I would be most appreciative!!  Thanks!

Jason Kay.

[SL] Individual Account Access

[Preston H. <pre...@gm...>]

Hello,

The company I work for has been using SQL-Ledger for some time now.   We
have an employee that we would like to be able to help enter data in some of
our AP accounts.  We do not, however, want them to be able to see all the
data in the AP since there is sensitive information such as payroll there.
Is there a way to limit a user to a set list of accounts?  If so, how would
I go about setting this up?  If this ability is not currently in the
program, for those more familiar than myself with the SQL-Ledger code, how
hard would it be to add this in there?  I know the "how hard would it be to
add" is a hard question to answer, I am really looking for something along
the lines of "It would require a complete security redesign" or "It would
take a couple months" or "It is two lines of Perl code in this file".


Thanks for the help.

Preston Hagar

[SL] upgrade problem

[Omar B. <ob...@ab...>]

Hi All,
when I want to upgrade from version 2.4 to 2.6,
I get the following error when I try to update the data set the first time

Error!
create table recurring (id int, reference text, startdate date, nextdate date, 
enddate date, repeat int2, unit varchar(6), howmany int, payment bool 
default 'f')
ERROR: relation "recurring" already exists


and then when I try to upgrade the dataset again I get the following error

Error!
alter table ar add ponumber text
ERROR: column "ponumber" of relation "ar" already exists


best regards
omar
-- 
-

______________________________________________________________________
This information transmitted is only for the person or entity to which it is
addressed and may contain confidential and/or privileged material. Any
review, retransmission, dissemination or other use of this information, or
taking of any action in reliance upon this information,by person or entities
other than the intended recipient is prohibited. If you received this in
error, please contact the sender and delete the material from any computer.
______________________________________________________________________

Re: [SL] Feature Request

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

Thanks,

but only two of them have (most of the time), one is different always.

el

Asante, Emmanuel [ING-WBK] wrote:
> Eberhard,
> 
> If the three items has a common character in the codes, you can enter
> that character, press enter and you'll get a list of all items with that
> character in. You can then select as many of those items as you want.
> 
> Emmanuel 
> 
> -----Original Message-----
> From: sql...@li...
> [mailto:sql...@li...] On Behalf Of Dr
> Eberhard Lisse
> Sent: Sunday, December 24, 2006 11:33 AM
> To: sql...@li...
> Subject: Re: [SL] Feature Request
> 
> Thank you all for helping me with finding the keys., something I was/am
> not concerned about.
> 
> I want to enter three lines (at least) at a time.
> 
> el
> 
> 
> on 12/24/06 8:02 AM Mel Broadhurst said the following:
>> Dr Eberhard Lisse wrote:
>>
>>> Dieter,
>>>
>>> The majority of invoices I send have three items (at least) and I 
>>> thus need to push the update button several times (with the mouse, as
> 
>>> I haven't yest figured out the keyboard combination for that, on the 
>>> Mac anyway).
>>>
>>> What would it take to make the invoice come up with more than one 
>>> line on the first go, perhaps even configurable through a/the config
> file?
>>> Merry Christmas,
>>>
>>> el
>>>
>>>  
>>>
>>     I never use the update key. After entering the item No. I hit
> enter.
>> If I must change the quantity from the default '1' and or the price, I
> 
>> do so and then hit enter again. This automatically produces a new
> line.
>> Hope this helps.
>>
>> Merry Christmas also
>>
>> Mel B.
>>
>> ----------------------------------------------------------------------
>> --- Take Surveys. Earn Cash. Influence the Future of IT Join 
>> SourceForge.net's Techsay panel and you'll get the chance to share 
>> your opinions on IT & business topics through brief surveys - and earn
> 
>> cash 
>> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEV
>> DEV _______________________________________________
>> sql-ledger-users mailing list
>> sql...@li...
>> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
> 

Re: [SL] Feature Request

[Asante, E. [ING-WBK] <Emm...@bh...>]

Eberhard,

If the three items has a common character in the codes, you can enter
that character, press enter and you'll get a list of all items with that
character in. You can then select as many of those items as you want.

Emmanuel=20

-----Original Message-----
From: sql...@li...
[mailto:sql...@li...] On Behalf Of Dr
Eberhard Lisse
Sent: Sunday, December 24, 2006 11:33 AM
To: sql...@li...
Subject: Re: [SL] Feature Request

Thank you all for helping me with finding the keys., something I was/am
not concerned about.

I want to enter three lines (at least) at a time.

el


on 12/24/06 8:02 AM Mel Broadhurst said the following:
> Dr Eberhard Lisse wrote:
>=20
>> Dieter,
>>
>> The majority of invoices I send have three items (at least) and I=20
>> thus need to push the update button several times (with the mouse, as

>> I haven't yest figured out the keyboard combination for that, on the=20
>> Mac anyway).
>>
>> What would it take to make the invoice come up with more than one=20
>> line on the first go, perhaps even configurable through a/the config
file?
>>
>> Merry Christmas,
>>
>> el
>>
>> =20
>>
>     I never use the update key. After entering the item No. I hit
enter.
> If I must change the quantity from the default '1' and or the price, I

> do so and then hit enter again. This automatically produces a new
line.
> Hope this helps.
>=20
> Merry Christmas also
>=20
> Mel B.
>=20
> ----------------------------------------------------------------------
> --- Take Surveys. Earn Cash. Influence the Future of IT Join=20
> SourceForge.net's Techsay panel and you'll get the chance to share=20
> your opinions on IT & business topics through brief surveys - and earn

> cash=20
> http://www.techsay.com/default.php?page=3Djoin.php&p=3Dsourceforge&CID=
=3DDEV
> DEV _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users

--=20
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

------------------------------------------------------------------------
-
Take Surveys. Earn Cash. Influence the Future of IT Join
SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys - and earn cash
http://www.techsay.com/default.php?page=3Djoin.php&p=3Dsourceforge&CID=
=3DDEVDE
V
_______________________________________________
sql-ledger-users mailing list
sql...@li...
https://lists.sourceforge.net/lists/listinfo/sql-ledger-users


This message and any attached files may contain information that is=
 confidential and/or subject of legal privilege intended only for use by=
 the intended recipient. If you are not the intended recipient or the=
 person responsible for delivering the message to the intended recipient,=
 be advised that you have received this message in error and that any=
 dissemination, copying or use of this message or attachment is strictly=
 forbidden, as is the disclosure of the information therein. If you have=
 received this message in error please notify the sender immediately and=
 delete the message.

Re: [SL] Feature Request

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

Thank you all for helping me with finding the keys., something I was/am
not concerned about.

I want to enter three lines (at least) at a time.

el


on 12/24/06 8:02 AM Mel Broadhurst said the following:
> Dr Eberhard Lisse wrote:
> 
>> Dieter,
>>
>> The majority of invoices I send have three items (at least) and I thus
>> need to push the update button several times (with the mouse, as I
>> haven't yest figured out the keyboard combination for that, on the Mac
>> anyway).
>>
>> What would it take to make the invoice come up with more than one line
>> on the first go, perhaps even configurable through a/the config file?
>>
>> Merry Christmas,
>>
>> el
>>
>>  
>>
>     I never use the update key. After entering the item No. I hit enter.
> If I must change the quantity from the default '1' and or the price, I
> do so and then hit enter again. This automatically produces a new line.
> Hope this helps.
> 
> Merry Christmas also
> 
> Mel B.
> 
> -------------------------------------------------------------------------
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to share your
> opinions on IT & business topics through brief surveys - and earn cash
> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
> _______________________________________________
> 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] Feature Request

[Mel B. <be...@te...>]

Dr Eberhard Lisse wrote:

>Dieter,
>
>The majority of invoices I send have three items (at least) and I thus
>need to push the update button several times (with the mouse, as I
>haven't yest figured out the keyboard combination for that, on the Mac
>anyway).
>
>What would it take to make the invoice come up with more than one line
>on the first go, perhaps even configurable through a/the config file?
>
>Merry Christmas,
>
>el
>
>  
>
    I never use the update key. After entering the item No. I hit enter.
If I must change the quantity from the default '1' and or the price, I
do so and then hit enter again. This automatically produces a new line.
Hope this helps.

Merry Christmas also

Mel B.

Re: [SL] Feature Request

[Stroller <lin...@my...>]

On 24 Dec 2006, at 00:24, Erkki Eilonen wrote:
> =DChel kenal p=E4eval, P, 2006-12-24 kell 00:07, kirjutas Stroller:
>> On 23 Dec 2006, at 05:04, Dr Eberhard Lisse wrote:
>>>
>>> The majority of invoices I send have three items (at least) and I =20=

>>> thus
>>> need to push the update button several times ... I
>>> haven't yest figured out the keyboard combination for that, on =20
>>> the Mac
>>> anyway...
>>
>> Ummm... the keyboard combination is "enter".
>
> Isn't it "alt-u" ?

All I know is that I type "ab" in the box for part number & hit enter =20=

& I get a list of parts ab001, ab002 ... ab999 to choose from. Even =20
if I type ab in the part number field and then press tab until I'm in =20=

the quantity field, then press 3 and enter, the same thing happens.

Stroller.=

Re: [SL] Feature Request

[Erkki E. <er...@it...>]

Isn't it "alt-u" ?

=C3=9Chel kenal p=C3=A4eval, P, 2006-12-24 kell 00:07, kirjutas Stroller:
> On 23 Dec 2006, at 05:04, Dr Eberhard Lisse wrote:
> >
> > The majority of invoices I send have three items (at least) and I thu=
s
> > need to push the update button several times ... I
> > haven't yest figured out the keyboard combination for that, on the Ma=
c
> > anyway...
>=20
> Ummm... the keyboard combination is "enter".
>=20
> Stroller.
>=20
> -----------------------------------------------------------------------=
--
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to share=
 your
> opinions on IT & business topics through brief surveys - and earn cash
> http://www.techsay.com/default.php?page=3Djoin.php&p=3Dsourceforge&CID=3D=
DEVDEV
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
--=20
Erkki Eilonen <er...@it...>
iTech Solutions

Re: [SL] Feature Request

[Stroller <lin...@my...>]

On 23 Dec 2006, at 05:04, Dr Eberhard Lisse wrote:
>
> The majority of invoices I send have three items (at least) and I thus
> need to push the update button several times ... I
> haven't yest figured out the keyboard combination for that, on the Mac
> anyway...

Ummm... the keyboard combination is "enter".

Stroller.

[SL] Error Access Denied!

[Adrian B. <ab...@ph...>]

A new laptop and now a problem. :-(

The details:
Mandriva 2007
Postgres 8.1
Latest SQL-Ledger
Backed up on one computer and restored on new machine

Error message in bowser is:
Error
Access Denied

# tail /var/log/httpd/error_log
[Sat Dec 23 05:05:19 2006] [crit] (20019)DSO load failed: DBD: failed to
initialise
[Sat Dec 23 05:05:19 2006] [crit] (20019)DSO load failed: DBD: can't find
driver for [DBDriver unset]

Is it a permissions problem or a software problem. Either something is
missing or I have forgotten something in the installation.

Adrian

--
Adrian Blake
Molonglo Radio Observatory
1152 Hoskinstown Rd
Bungendore
NSW 2621
Australia
ph 62382262

----------------------------------------------------------------
This message was sent using IMP, the Internet Messaging Program.

[SL] Feature Request

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

Dieter,

The majority of invoices I send have three items (at least) and I thus
need to push the update button several times (with the mouse, as I
haven't yest figured out the keyboard combination for that, on the Mac
anyway).

What would it take to make the invoice come up with more than one line
on the first go, perhaps even configurable through a/the config file?

Merry Christmas,

el

Re: [SL] sql-ledger for publisher?

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

On Fri, 22 Dec 2006, John R. Culleton wrote:

> Has anyone attempted to run a publishing enterprise using sql-ledger?

John,

   No, I haven't. But what I've learned over the past few years is that SL
can be adapted to almost everything. Sometimes we need to translate from our
language into SL's language, but it works.

> The main difference between publishing and other manufacturing or
> retailing is the presence of the author, who is in some respects a vendor
> and in some repects a partner in the enterprise.  The relationship with
> distibutors is also somehat different from regular manufacturing
> situations.

   An example in my service consulting business: I have inventory items for
various types of services. This way I can create an invoice that reflects
the proper amounts (when I billed by the hour). Various travel and work
related expenses are also entered as inventory so they can be 'sold' (or, I
suppose, used as part of an assembly).

   Your authors might also be in your inventory as well as vendors for
payment purposes. There are a lot of very clever people here who can help
you fit your exact needs into the SL syntax. And, of course, Dieter can be
hired to help, too.

Rich

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

[SL] sql-ledger for publisher?

[John R. C. <jo...@we...>]

As a book publisher I can buy specialized packages that cover royalties, 
returns, discounts and so on. But most don't do complete general ledger. 
Therefore I would want to consider sql-ledger instead. Has anyone attempted 
to run a publishing enterprise using sql-ledger?

The main difference between publishing and other manufacturing or retailing is 
the presence  of the author, who is in some respects a vendor and in some 
repects a partner in the enterprise.  The relationship with distibutors is 
also somehat different from regular manufacturing situations.

-- 
John Culleton
Able Indexing and Typesetting
Precision typesetting (tm) at reasonable cost.
Satisfaction guaranteed. 
http://wexfordpress.com

Re: [SL] Web Services

[Erkki E. <er...@it...>]

I have been toying with the idea of implementing a soap based backend
for SL, but I don't have much done yet.

=C3=9Chel kenal p=C3=A4eval, R, 2006-12-22 kell 12:17, kirjutas V Vivek:
> Is XML-RPC based web services in the roadmap of development ?
>=20
> cheers
> Vivek
>=20
> -----------------------------------------------------------------------=
--
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to share=
 your
> opinions on IT & business topics through brief surveys - and earn cash
> http://www.techsay.com/default.php?page=3Djoin.php&p=3Dsourceforge&CID=3D=
DEVDEV
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
--=20
Erkki Eilonen <er...@it...>
iTech Solutions

[SL] Web Services

[V V. <vi...@sr...>]

Is XML-RPC based web services in the roadmap of development ?

cheers
Vivek

[SL] System for Environmental Exchange

[Lane S. <la...@op...>]

Hello,

Has anyone researched an accounting system for trading environmental 
credits?

I have set up a non-profit in California for water credits and will be 
taking on my first transaction in which there could be many small credit 
buyers.

Of course, I am looking for a web-based system where the instruments can 
be displayed, current bid/ask, and account position maintained for the 
individual account holder.

Many thanks if you can share your research in this area.

-- 
Kindest Regards,

Lane Sharman
858-755-2868

[SL] System for Environmental Exchange

[Lane S. <la...@op...>]

Hello,

Has anyone researched an accounting system for trading environmental
credits?

I have set up a non-profit in California for water credits and will be
taking on my first transaction in which there could be many small credit
buyers.

Of course, I am looking for a web-based system where the instruments can
be displayed, current bid/ask, and account position maintained for the
individual account holder.

Many thanks if you can share your research in this area.

-- 
Kindest Regards,

Lane Sharman
858-755-2868

[SL] Attachments P:roblem

[Davin M. <da...@me...>]

I have a problem where many of my clients running Outlook 2000, 2002
find they can see my attached HTML invoice the first time the open the
mail, but when they open it a second time its been removed?

Re: [SL] Automating Transactions

[Bill F. <fa...@po...>]

On Wed, 20 Dec 2006, Bill Faust wrote:

> I am interested in automating a general ledger transaction.  Is there a
> way I can do it as a command line entry?  As an example, say I wished to
> enter the simplest of GL entry, debitting an account for $100, and
> creditting it to another for the same amount.  Could I do that with a
> command line?

Nevermind.  I see exactly this topic addressed in the archives from Sep 
12, 2006.

-- 
Bill Faust
Optim Microwave, Inc.
818-865-8157 x302

[SL] Automating Transactions

[Bill F. <fa...@po...>]

I am interested in automating a general ledger transaction.  Is there a 
way I can do it as a command line entry?  As an example, say I wished to 
enter the simplest of GL entry, debitting an account for $100, and 
creditting it to another for the same amount.  Could I do that with a 
command line?

Thanks,

-- 
Bill Faust
Optim Microwave, Inc.
818-865-8157 x302

[SL] Seasons Best Wishes

[WJ B. <wj...@pa...>]

Merry Xmas and Prosperous New Year to all on list.

Special thanks to the more experienced members who have patiently and 
almost always quickly come up with solutions and suggestions.

Last but not least, a big thank you to the developers and contributors 
who have produced IMHO a fantastic application.

WJ Bundy

Re: [SL] Password Problem

[Ted O. <te...@on...>]

I've seen this as well.  I think it has to do with the '?' in the password. 
Possibly because the '?' is a delimiter in the URL string for variables passed 
in the URL (??)

I changed my password to something without the '?' and the problem went away.

Ted

Davin Menhinick wrote:
> Since upgrading to 2.6.22 there seems to be a problem with my password
> which contains special characters. My password was something like this
> %ah!r?sa.
> 
> If I log in using this password I am immediately prompted for my
> password again. Once entered I get the following error:
> 
> Error!
> 
> action= not defined!
> 
> After that all seems to work except the fancy looking (I think java
> script) menu system looks different, but still seems to work.
> 
> I have changed my password to use only alpha numeric characters to get
> around this problem for now.
> 
> -------------------------------------------------------------------------
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to share your
> opinions on IT & business topics through brief surveys - and earn cash
> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
> 

[SL] Password Problem

[Davin M. <da...@me...>]

Since upgrading to 2.6.22 there seems to be a problem with my password
which contains special characters. My password was something like this
%ah!r?sa.

If I log in using this password I am immediately prompted for my
password again. Once entered I get the following error:

Error!

action= not defined!

After that all seems to work except the fancy looking (I think java
script) menu system looks different, but still seems to work.

I have changed my password to use only alpha numeric characters to get
around this problem for now.

Re: [SL] Server error when adding new item (add part)

[Jonas B. N. <jo...@io...>]

Hi Gloria,

This is quite interesting to me, since I currently have a  
dysfunctional installation of SQL-Ledger. I get internal server error  
everytime I add something to the database.

This is most unfortunate since I am have all my accounting on this  
particular installation.

What version of Apache ar you running?

jonasbn

On 18/12/2006, at 4.20, Gloria Ang wrote:

> Just in case anyone else encountered this problem, we've traced the
> cause of the problem to apache's mod_security.
>
> Adding the following lines to mod_security.conf fixed the problem.
>
> <Location /sql-ledger/>
>      SecFilterEngine Off
> </Location>
>
> ---------------------------------------------------------------------- 
> ---
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to  
> share your
> opinions on IT & business topics through brief surveys - and earn cash
> http://www.techsay.com/default.php? 
> page=join.php&p=sourceforge&CID=DEVDEV
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>