How to close the books
Add a rule to prevent data from being changed or deleted.
CREATE RULE acc_trans_delete AS ON DELETE TO acc_trans WHERE old.transdate <= 'date' DO INSTEAD NOTHING;
CREATE RULE acc_trans_input AS ON INSERT TO acc_trans WHERE new.transdate <= 'date' DO INSTEAD NOTHING;
How to setup audit trails
Setup a database user for each user or group of users
and REVOKE DELETE rights for the users or a group. This emulates a
WORM device and forces users to reverse entries.
REVOKE DELETE ON acc_trans FROM username
How to enter beginning balances
Add a GL entry to setup a beginning balance for your accounts.
How to establish a beginning inventory
- add the parts to inventory, this step only describes the part, service
or assembly
- add a vendor invoice to increase the quantity for the parts
What does stock assembly mean
Assemblies are manufactured goods assembled from parts, services and
assemblies. Because you do not buy assemblies you 'stock assemblies' by
adding assembled units to your inventory. The quantity for individual parts
is reduced and the quantity for the assembly increased. To disassemble an
assembly you simply return the parts to inventory by entering a negative
quantity for the number of assemblies to stock.
Mandrake and PostgreSQL problems
Mandrake does not package the DBD-Pg driver.
For installation instruction see section below.
Redhat 7.0 Installation instructions
- Install apache1.3.12-25.i386.rpm
- Install perl5.6.0-9.i386.rpm
- Install postgresql-7.0.2-17.i386.rpm
- Install postgresql-server-7.0.2-17.i386.rpm
- Install postgresql-devel-7.0.2-17.i386.rpm (POSTGRES_INCLUDE)
- tar xvzf DBI-1.14.tar.gz
- cd DBI-1.14
- perl Makefile.PL
- make
- make install
- cd ..
- tar xvzf DBD-Pg-0.95
- cd DBD-Pg-0.95
- export POSTGRES_LIB=/usr/lib/pgsql
- export POSTGRES_INCLUDE=/usr/include/pgsql
- perl Makefile.PL
- make
- make install
- install SQL-Ledger
Some of the applications have newer versions however the installation
instructions remain the same. Just substitute the old version with a newer
version.
Debian Installation
- unpack into /var/www/sql-ledger
- install postgresql (Dselect)
- install libpg-dev (Dselect)
- modify /etc/postgresql/postmaster.init
PGALLOWTCPIP=yes
PGPORT=5432
- create a user for managing SQL-Ledger databases
from root
su postgres
$ createuser
name of user- (create a postgres user who is also a Linux user
this user will be an account manager. Enable this user to create db and users)
- install DBI
perl Makefile.PL
make
make test
login as root
make install
- $ export POSTGRES_INCLUDE=/usr/include/postgresql
- $ export POSTGRES_LIB=/var/lib/postgres
- install DBD-Pg
login as account manager (above)
perl Makefile.PL
make
make test
login as root
make install
- change /etc/apache/httpd.conf and add
AddHandler cgi-script .pl
ScriptAlias /sql-ledger/ /var/www/sql-ledger/
<Directory /var/www/sql-ledger>
Options ExecCGI Includes FollowSymlinks
</Directory>
- restart apache
- From browser enter http://my_domain/sql-ledger/admin.pl
- Login as the postgres user (account manager) you have created (above)
Create a DB
Create users
- then enter http://my_domain/sql-ledger/login.pl
Login as one of the users you have just created
How do get SQL-Ledger working on Win2k
Thanks to Martin Lillepuu for a
writeup about how to install SQL-Ledger
on a Win2k platform.
login.pl has compilation error
This could be because of a missing configuration file in the users directory
check the permission for the users directory.
script not executing, shows in browser instead
Add
AddHandler cgi-script .pl
in your httpd.conf file.
unknown terminal!
The script couldn't figure out which browser you are using
include the terminal variable on the URL
http://localhost/sql-ledger/login.pl?terminal=lynx
Valid terminal variables are (lynx and mozilla)
permission denied
Make sure the web server has write permission to write to the following
- users/
- templates/
- users/members
# chown nobody:nogroup users templates users/members
Database permission denied
The user you entered in the "Database section" must be a valid
database user. Use the same name you used when you created the
database and tables or another special user who has the
rights to access the tables.
html and graphics files don't show up on screen
Enable Includes and FollowSymlinks Options in your httpd.conf file
<Directory /usr/local/www/sql-ledger>
Options ExecCGI Includes FollowSymlinks
</Directory>
Can I use mySQL
Sorry, no. Although transactions are now supported with the InnoDB
table handler the backend would still require a major rewrite to work
with mySQL.
How can I switch the display to a foreign language
Load your preferences and select the language.
Language selection is in accordance to
ISO 3166 standards.
Text shows in English when I use a foreign language
This is because the corresponding hash entry is missing.
Add the missing text in the locale/cc/all or locale/cc/missing
file and run locales.pl to rebuild the individual files.
cc refers to the country code.