sql-ledger-users — SQL-Ledger users

Re: New User

[Brian C. <bt...@ch...>]

Nick,
Thanks for the suggestion. I commented out the AddHandler cgi-script
.cgi line
and enter the AddHandler cgi-script.pl.

I then used the kill -HUP pid to restart apache. I can access other
un.pl files with no problems. I even tried the
sql-ledger/admin.pl?terminal=lynx and sql-ledger/admin.pl?terminal=lynx.
However, I now get the following message on the browser:

Internal Server Error

The server encountered an internal error or misconfiguration and was
unable to
complete your request.

Please contact the server administrator, yo...@yo... and inform
them of the time
the error occurred, and anything you might have done that may have
caused the error.

More information about this error may be available in the server error
log.

This is what the log file looks like.
var/log/apache_error_log:

[Wed Dec 19 12:47:55 2001] [notice] Apache/1.3.12 (FreeBSD) configured
-- resuming normal operations
[Wed Dec 19 13:00:38 2001] [error] [client 206.2.228.130] Premature end
of script headers: /usr/local/share/apache/htdocs/sql-ledger/admin.pl
Can't locate DBI.pm in @INC (@INC contains:
/usr/libdata/perl/5.00503/mach /usr/libdata/perl/5.00503
/usr/local/lib/perl5/site_perl/5.005/i386-freebsd
/usr/local/lib/perl5/site_perl/5.005 .) at bin/mozilla/admin.pl line 38.
BEGIN failed--compilation aborted at bin/mozilla/admin.pl line 38.

--END of Log --
When using the lynx option the path is /bin/lynx/admin.pl vs
bin/mozilla/admin.pl

In either case I looked at the files and see line 38 is
use DBI

-What is DBI?

Tyge

> 
> At 2001-12-19 01:57:37+0000, Brian Cawthon writes:
> > Hello,
> > I am a new user to sql-ledger.
> > My system is as follows:
> > FreeBSD 4.4 Stable
> > PostgreSQL 7.0.2
> > Apache
> > AOLSERVER 3.4
> > Netscape 4.7
> >
> > I followed the instructions in the doc/README. However, the admin.pl
> > shows up as a text file in my netscape 4.7 browser.
> >
> > path for sql-ledger is:
> > /usr/local/share/apache/htdocs/sql-ledger
> >
> > Here is the apache.conf information I added:
> >   Alias /sql-ledger/ "/usr/local/share/apache/htdocs/sql-ledger/"
> >
> >  <Directory "/usr/local/share/apache/htdocs/sql-ledger">
> >     Options ExecCGI Includes FollowSymlinks
> >   </Directory>
> >
> >  AddHandler cgi-script .cgi
> 
> This should be
> 
> AddHandler cgi-script .pl
> 
> Nick B

Re: New User

[Thomas G. <to...@ad...>]

On Wed, 19 Dec 2001, Nick Barnes wrote:

> >  AddHandler cgi-script .cgi
>=20
> This should be=20
>=20
> AddHandler cgi-script .pl

Nick, you can have more than one, as an FYI.  I use both, .cgi for
production and .pl for test.  I move the src from .pl to .cgi once
I've found (most of) the errors.  ;-)

The thing is, you might like both, should your httpd server run
anything other than sql-ledger as cgi scripts normally end in .cgi

Cheers!

--------------------------------------------------------------------
              Saint Vincent Catholic Medical Centers               =20
--------------------------------------------------------------------
Thomas Good                          tomg@ { admin | q8 } .nrnet.org
Programmer/Analyst                              Phone:  718-818-5528=20
Behavioral Health Services                      Fax:    718-818-5056 =20
Residential Services                            Mobile: 917-282-7359 =20
--------------------------------------------------------------------
/*         Rekordmeister ist nur der FC Bayern M=FCnchen!           */
--------------------------------------------------------------------

Re: Adding PostgreSQL PRIMARY KEY - help

[Thomas G. <to...@ad...>]

On Tue, 18 Dec 2001, Roderick A. Anderson wrote:

> On Tue, 18 Dec 2001, alta wrote:
>=20
> >=20
> > Thanks Thomas ...
> >=20
> > However, your suggestion produced an error.  psql was run from user=20
> > postgres, version 7.1.3-11, with the following results:
> >=20
> > =3D# ALTER TABLE customer ADD CONSTRAINT cs1 UNIQUE (id);
> >=20
> > ERROR:  ALTER TABLE / ADD CONSTRAINT is not implemented for that=20
> > constraint type
> >=20
>=20
> >From the PostgreSQL man page on alter_table
>=20
>        In  the  current  implementation,  only  FOREIGN  KEY con
>        straints can be added to a table. To create  or  remove  a
>        unique constraint, create a unique index (see CREATE INDEX
>        [create_index(l)]).


Yeah, sorry!  I use 7.2 ...

> =09CREATE UNIQUE INDEX cs1_pk ON customer (id);

I suspect this is what really happens when we ADD CONSTRAINT anyway
(in 7.2beta).  I shifted to 7.2 as I was looking for DROP COLUMN, but
it still hasn't been unveiled.  :-(

> Not sure if Dieter's code will trap the error returned if a duplicate ID
> is inserted or updated.

All of Dieter's stuff has a method called 'dberror' invoked at the
end of each dbh->do() or sth->execute() call (perl DBI methods to exec=20
queries...)

If you look through the src you'll see the strings like:
$dbh->do($query) || $form->dberror($query);
This 'dberror' method call is declared in Form.pm (in the SL=20
directory) - for the curious.  It dumps the std $DBI::errstr
(which usually includes the complaint from the backend:
'cannot insert a duplicate key...') as well as a variable called
$msg which is most likely the failed query string.=20

--------------------------------------------------------------------
              Saint Vincent Catholic Medical Centers               =20
--------------------------------------------------------------------
Thomas Good                          tomg@ { admin | q8 } .nrnet.org
Programmer/Analyst                              Phone:  718-818-5528=20
Behavioral Health Services                      Fax:    718-818-5056 =20
Residential Services                            Mobile: 917-282-7359 =20
--------------------------------------------------------------------
/*         Rekordmeister ist nur der FC Bayern M=FCnchen!           */
--------------------------------------------------------------------

Re: New User

[Nick B. <Nic...@po...>]

At 2001-12-19 01:57:37+0000, Brian Cawthon writes:
> Hello,
> I am a new user to sql-ledger.
> My system is as follows:
> FreeBSD 4.4 Stable
> PostgreSQL 7.0.2
> Apache
> AOLSERVER 3.4
> Netscape 4.7
> 
> I followed the instructions in the doc/README. However, the admin.pl
> shows up as a text file in my netscape 4.7 browser.
> 
> path for sql-ledger is:
> /usr/local/share/apache/htdocs/sql-ledger
> 
> Here is the apache.conf information I added:
>   Alias /sql-ledger/ "/usr/local/share/apache/htdocs/sql-ledger/"  
> 
>  <Directory "/usr/local/share/apache/htdocs/sql-ledger">
>     Options ExecCGI Includes FollowSymlinks
>   </Directory>
> 
>  AddHandler cgi-script .cgi

This should be 

AddHandler cgi-script .pl

Nick B

One question

[gemma <ge...@pc...>]

Hello,

I have just installed the progrma sql-ledger and works fine with private=20
web server dnhttpd but when I clik the Administrator password it returns=20
me this message:


  "400 Bad Request

This error was encountered attempting to access the file you requested.

Additional information: Content-length header missing for POST request

------------------------------------------------------------------------
DNHTTPD/0.4.1 at ub002024.grp.pcb.ub.es:8000

someone can say to me how to configure  the files to send  a fine request=
?

Thank you in advanced!

GEMMA
ge...@pc...
--=20

[Linux] Usuario registrado n=BA: 221523
"Si la felicidad consistiese en las satisfacciones del cuerpo, entonces=20
dir=EDamos que los bueyes son felices cuando encuentran hierbas para=20
comer." (Her=E1clito)

Re: Customer Invoice/Post invoice?

[Ilkka ... <gon...@ho...>]

Hi,

Sorry bookkeepers, it gets technical again. Is there a need for separate 
developing mailing list?

>How "not very smooth" is it?  I started to try to get postgresql and
>sql-ledger working on NT 4.0, but I realized I didn't have the
>experience to make that quick and easy, and I wasn't even sure it would
>work.  I might be interested in what you're doing, though.

Well, at least there can be some issues with Postgres. It should not be a 
big job to make it work with Postgres again, but I have a feeling that 
Postgres on Windows is not that popular as it needs the cygwin stuff. Well, 
we'll see ..

Other thing is the Perl (& DBI) installation, but maybe that is almost as 
difficult on Windows as on Linux.

What I would like to see is the same codebase supporting Windows & Linux, 
MySQL & Postgres (how about ODBC?)...and, some kind of build system (a 
script?) that would make installation packages for Windows and Linux 
separately. That would require some (a lot of?) co-operation, but at least 
I'm ready to give it a try.


Ilkka Huotari


_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp.

Re: Permissions on 'users templates users/members'?

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

Rogelio ...

The installation instructions are not 100% accurate.

This worked for me, as root:

chown nobody:nogroup templates users
chmod 777 templates users

I believe execute capability is necessary for directories, contrary 
to intuition.

Also, I altered the permissions of the contents of directory "users", 
but I do not know if that was necessary.

... Reed

On Tuesday 18 December 2001 21:43, you wrote:
> Dieter or anyone... I changed it to what you said... like this
> but still I get a Access denied
>
>
> drw-rw-r--   3 apache   apache       4096 Dec 17 08:31 templates
> drw-rw-r--   2 apache   apache       4096 Dec 18 14:45 users
>
> Rogelio J. Samour

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

Re: Adding PostgreSQL PRIMARY KEY - bingo

[Roderick A. A. <raa...@ti...>]

On Tue, 18 Dec 2001, alta wrote:

> I just installed Version 1.8.  Looks very nice!  However, I think the
> "bin" column is missing from the "part" table...

I must have missed something.  Where is 1.8?  I've only seen 1.6.13 in
the download section.


Cheers,
Rod
-- 
                      Let Accuracy Triumph Over Victory

                                                       Zetetic Institute
                                                        "David's Sling"
                                                         Marc Stiegler

Re: Permissions on 'users templates users/members'?

[Roderick A. A. <raa...@ti...>]

On Tue, 18 Dec 2001, Roger Samour wrote:

> Dieter or anyone... I changed it to what you said... like this
> but still I get a Access denied
> 
> 
> drw-rw-r--   3 apache   apache       4096 Dec 17 08:31 templates
> drw-rw-r--   2 apache   apache       4096 Dec 18 14:45 users

You need the e(x)ecute permission set also so the directory can be
accessed/entered.

	chmod ug+x templates users

I missed the thread leading up to this so I'll just toss in that the
files in these two directories also need to be writeable by the
webserver user (apache).


Cheers,
Rod
-- 
                      Let Accuracy Triumph Over Victory

                                                       Zetetic Institute
                                                        "David's Sling"
                                                         Marc Stiegler

Re: Permissions on 'users templates users/members'?

[Roger S. <rs...@ma...>]

Dieter or anyone... I changed it to what you said... like this
but still I get a Access denied


drw-rw-r--   3 apache   apache       4096 Dec 17 08:31 templates
drw-rw-r--   2 apache   apache       4096 Dec 18 14:45 users

Rogelio J. Samour

Re: Adding PostgreSQL PRIMARY KEY - bingo

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

Roderick ...

Your suggestion works, at least it did on a test table:  Thanks!

     CREATE UNIQUE INDEX cs1_pk ON customer (id);

I just installed Version 1.8.  Looks very nice!  However, I think the
"bin" column is missing from the "part" table...

Regards ... Reed

On Tuesday 18 December 2001 21:26, you wrote:
> On Tue, 18 Dec 2001, alta wrote:
> > Thanks Thomas ...
> >
> > However, your suggestion produced an error.  psql was run from
> > user postgres, version 7.1.3-11, with the following results:
> >
> > =# ALTER TABLE customer ADD CONSTRAINT cs1 UNIQUE (id);
> >
> > ERROR:  ALTER TABLE / ADD CONSTRAINT is not implemented for that
> > constraint type
>
> From the PostgreSQL man page on alter_table
>
>        In  the  current  implementation,  only  FOREIGN  KEY con
>        straints can be added to a table. To create  or  remove  a
>        unique constraint, create a unique index (see CREATE INDEX
>        [create_index(l)]).
>
> Try
>
> 	CREATE UNIQUE INDEX cs1_pk ON customer (id);
>
> Not sure if Dieter's code will trap the error returned if a
> duplicate ID is inserted or updated.
>
>
> Cheers,
> Rod

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

-------------------------------------------------------

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

Re: Adding PostgreSQL PRIMARY KEY - help

[Roderick A. A. <raa...@ti...>]

On Tue, 18 Dec 2001, alta wrote:

> 
> Thanks Thomas ...
> 
> However, your suggestion produced an error.  psql was run from user 
> postgres, version 7.1.3-11, with the following results:
> 
> =# ALTER TABLE customer ADD CONSTRAINT cs1 UNIQUE (id);
> 
> ERROR:  ALTER TABLE / ADD CONSTRAINT is not implemented for that 
> constraint type
> 

From the PostgreSQL man page on alter_table

       In  the  current  implementation,  only  FOREIGN  KEY con
       straints can be added to a table. To create  or  remove  a
       unique constraint, create a unique index (see CREATE INDEX
       [create_index(l)]).

Try 

	CREATE UNIQUE INDEX cs1_pk ON customer (id);

Not sure if Dieter's code will trap the error returned if a duplicate ID
is inserted or updated.


Cheers,
Rod
-- 
                      Let Accuracy Triumph Over Victory

                                                       Zetetic Institute
                                                        "David's Sling"
                                                         Marc Stiegler

Test

[Brian C. <bt...@ch...>]

I send one notice but did not see it posted.
This is a test to verify I am doing things correct.
Tyge

New User

[Brian C. <bt...@ch...>]

Hello,
I am a new user to sql-ledger.
My system is as follows:
FreeBSD 4.4 Stable
PostgreSQL 7.0.2
Apache
AOLSERVER 3.4
Netscape 4.7

I followed the instructions in the doc/README. However, the admin.pl
shows up as a text file in my netscape 4.7 browser.

path for sql-ledger is:
/usr/local/share/apache/htdocs/sql-ledger

Here is the apache.conf information I added:
  Alias /sql-ledger/ "/usr/local/share/apache/htdocs/sql-ledger/"  

 <Directory "/usr/local/share/apache/htdocs/sql-ledger">
    Options ExecCGI Includes FollowSymlinks
  </Directory>

 AddHandler cgi-script .cgi

Can someone point me in the right direction?
Tyge

Re: Adding PostgreSQL PRIMARY KEY - help

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

Thanks Thomas ...

However, your suggestion produced an error.  psql was run from user 
postgres, version 7.1.3-11, with the following results:

=# ALTER TABLE customer ADD CONSTRAINT cs1 UNIQUE (id);

ERROR:  ALTER TABLE / ADD CONSTRAINT is not implemented for that 
constraint type

... Reed

Re: Adding PostgreSQL PRIMARY KEY - help

[Thomas G. <to...@ad...>]

On Tue, 18 Dec 2001, alta wrote:

>=20
> I sometimes get duplicate records, for example when creating a=20
> customer.  I know this should not happen, but it does.
>=20
> To eliminate this problem, I have tried to add a PRIMARY KEY with=20
> psql.  Here's how:
>=20
>     alter table customer add constraint cs1 primary key(id);
>=20
> But, I get this error:
>=20
> "ERROR:  ALTER TABLE / ADD CONSTRAINT is not implemented for that=20
> constraint type."
>=20
> According to documentation (PostgreSQL Essential Reference), the ADD=20
> CONSTRAINT command is supported.

Make it unique:

ALTER TABLE customer ADD CONSTRAINT cs1 UNIQUE (id);

This creates an implicit index named cs1.
Because there is overhead (disk space) with indexes you might get
this operation to do double duty by choosing a field you'd like
to index anyway --- to speed performance.

To block dupes I sometimes make composite indexes:

CREATE UNIQUE INDEX no_dupes ON (patient_id, dept_id, track_id);
This gives me an index **** on the fields that I include in every query ***
anyway and blocks silly user tricks at the same time.

Good luck!  You might want to get a copy of SQL In A Nutshell, published
by O'Reilly.  Great postgres/oracle reference.  Concise but complete.

--------------------------------------------------------------------
              Saint Vincent Catholic Medical Centers               =20
--------------------------------------------------------------------
Thomas Good                          tomg@ { admin | q8 } .nrnet.org
Programmer/Analyst                              Phone:  718-818-5528=20
Behavioral Health Services                      Fax:    718-818-5056 =20
Residential Services                            Mobile: 917-282-7359 =20
--------------------------------------------------------------------
/*         Rekordmeister ist nur der FC Bayern M=FCnchen!           */
--------------------------------------------------------------------

Contribution proposition for document/tutorial

[Pierre-Alexandre L. <sql...@th...>]

Hi folks,

I would be willing to spend some time writing a tutorial/documentation
on the day-to-day usage of sql-ledger. 

However I am not an accountant but I've been running my own business for
2 years now and I consider myslef more of a manager than an accountant
although I have always tried to understand what my accountant was doing.
So I would like to find someone willing to help me and be my
"accountant" buddy to transle the description of management tasks into
"accounting" tasks. 

Anyone interested ? 

Pierre

Adding PostgreSQL PRIMARY KEY - help

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

I sometimes get duplicate records, for example when creating a 
customer.  I know this should not happen, but it does.

To eliminate this problem, I have tried to add a PRIMARY KEY with 
psql.  Here's how:

    alter table customer add constraint cs1 primary key(id);

But, I get this error:

"ERROR:  ALTER TABLE / ADD CONSTRAINT is not implemented for that 
constraint type."

According to documentation (PostgreSQL Essential Reference), the ADD 
CONSTRAINT command is supported.

Other than saving data, deleting the table, re-creating the table 
with the primary key, and restoring data, is there an easy to add a 
primary key (that works)?

... Reed

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

Re: Customer Invoice/Post invoice?

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

This is all you need to change!

Form.pm

    $argv .= "./$script " . $argv;
    exec "c:/perl/bin/perl.exe", $argv;

menu.pl

  $argv = "./menu.pl ".$argv;
  exec "c:/perl/bin/perl.exe", $argv;


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, 18 Dec 2001, Bill Harris wrote:

> "Ilkka ..." wrote:
> 
> > And BTW, I'm still on my way porting Sql-ledger to Windows & MySQL, it's
> > almost ready now. I don't know if you remember me talking about this earlier
> > but I needed to get it working on Windows & MySQL. Maybe that's part of the
> > reason to my problem :-)
> > 
> > There are some other functionality too that I have added - like Javascript
> > things and something else. When it's ready I hope that it can be backported
> > to original version (hopefully not by me :), but anyway if there are people
> > interested, I can give them a copy (of course, with disclaimers - for
> > example the installation procedure is not very smooth).
> 
> How "not very smooth" is it?  I started to try to get postgresql and
> sql-ledger working on NT 4.0, but I realized I didn't have the
> experience to make that quick and easy, and I wasn't even sure it would
> work.  I might be interested in what you're doing, though.
> 
> Bill
> 

Re: Split Booking

[Ned L. <ne...@ma...>]

This is coming in 1.8 isn't it? Dieter, are you going to give us all a
Christmas present? :)

Ned

On Tue, 18 Dec 2001 aer...@te... wrote:

> Yep, splits and the ability to handle partial payments would make it useable
> to me.
>
>
> >Hi
> >
> >The only reason why I am not using sql-ledger is the lack of split
> >booking (I hope this is the correct expression), i.e. the possibility of
> >recording different positions of one invoice in different accounts.
> >
> >Example:
> >
> >Our company buys 4 harddrives. 3 are for resale, one is to be used by
> >ourselves. Consequently the 3 disks have to be recorded as
> >merchandise/trading goods, the other one as computing equipment (or the
> >like) and should not show up in inventory.
> >
> >Another Example:
> >
> >Our company bills a customer. There are two positions: we sold her a HDD
> >and charged her for some services (eg. support). Again both items have
> >to be recorded in different accounts.
> >
> >I cannot see how this can be done with sql-ledger at the moment. If this
> >feature could be implemented in the future, this would make sql-ledger
> >even better :)
> >
> >Any comments?
> >
> >regards,
> >ralph
> >
> >
> >
> >
>

Re: Customer Invoice/Post invoice?

[Bill H. <bil...@fa...>]

"Ilkka ..." wrote:

> And BTW, I'm still on my way porting Sql-ledger to Windows & MySQL, it's
> almost ready now. I don't know if you remember me talking about this earlier
> but I needed to get it working on Windows & MySQL. Maybe that's part of the
> reason to my problem :-)
> 
> There are some other functionality too that I have added - like Javascript
> things and something else. When it's ready I hope that it can be backported
> to original version (hopefully not by me :), but anyway if there are people
> interested, I can give them a copy (of course, with disclaimers - for
> example the installation procedure is not very smooth).

How "not very smooth" is it?  I started to try to get postgresql and
sql-ledger working on NT 4.0, but I realized I didn't have the
experience to make that quick and easy, and I wasn't even sure it would
work.  I might be interested in what you're doing, though.

Bill
-- 
Bill Harris                                  3217 102nd Place SE
Facilitated Systems                          Everett, WA 98208 USA
http://facilitatedsystems.com/               phone: +1 425 337-5541

accno sorting

[Pierre-Alexandre L. <sql...@th...>]

I modified the list_accounts method to sort the records from the chart
table "lexically" on the accno instead of numerically. 

In Belgium, we have accno that are hierarchical eg

710 AAA (heading)
-- 710000 AAA.BBBB (account)
-- 710100 AAA.CCCC (account)

and 710 is not the same as 710000

But when sorted numerically all headers are returned first since they
have the lowest accno value. So I resorted the hash before printing it
using (in [form]/cp.pl)

  # sort $form->{CA}
  my @sorted_ca = sort { $a->{accno} cmp  $b->{accno} } @{$form->{CA}};

 # loop around  
 foreach $ca (@sorted_ca) {
 ...
 }


This change still works for fixed length or zero padded account numbers
of course so I thought it might be of interest.

Since I don't know (yet) all the other places where this type of list or
query is made I thought I would drop this on the mailing list and call
for comments :-)

Pierre

Re: Split Booking

[<aer...@te...>]

Yep, splits and the ability to handle partial payments would make it useable
to me.


>Hi 
>
>The only reason why I am not using sql-ledger is the lack of split
>booking (I hope this is the correct expression), i.e. the possibility of
>recording different positions of one invoice in different accounts. 
>
>Example: 
>
>Our company buys 4 harddrives. 3 are for resale, one is to be used by
>ourselves. Consequently the 3 disks have to be recorded as
>merchandise/trading goods, the other one as computing equipment (or the
>like) and should not show up in inventory. 
>
>Another Example:
>
>Our company bills a customer. There are two positions: we sold her a HDD
>and charged her for some services (eg. support). Again both items have
>to be recorded in different accounts. 
>
>I cannot see how this can be done with sql-ledger at the moment. If this
>feature could be implemented in the future, this would make sql-ledger
>even better :)
>
>Any comments?
>
>regards,
>ralph
>
>
>
>

Re: charttype & category field in chart

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

charttype -> (A)ccount (H)eading

category -> (A)sset
            (L)iability
            E(Q)uity
            (I)ncome
            (E)expense


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 18 Dec 2001, Pierre-Alexandre Losson wrote:

> Could someone help me out on the signification and usage of the
> charttype & category field in the chart table ?
> Thxs,
> Pierre
> 

charttype & category field in chart

[Pierre-Alexandre L. <sql...@th...>]

Could someone help me out on the signification and usage of the
charttype & category field in the chart table ?
Thxs,
Pierre