Re: no change capabilty for a transaction

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

Hi all,

I mentioned to Keld already that SL has the options available to close th=
e
books. Here is how you do that.

CREATE RULE acc_trans_delete AS ON DELETE TO acc_trans WHERE old.transdat=
e
<=3D 'date' DO INSTEAD NOTHING;
CREATE RULE acc_trans_input AS ON INSERT TO acc_trans WHERE
new.transdate <=3D 'date' DO INSTEAD NOTHING;

This will close the books up to the date you specify!


Dieter Simader    http://www.sql-ledger.org   (780) 472-8161
DWS Systems Inc.     Accounting Software       Fax: 478-5281
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D On a clear disk you can seek forever =3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D

On Sun, 4 Nov 2001, Keld J=F8rn Simonsen wrote:

> On Sun, Nov 04, 2001 at 12:17:25AM -0500, Herb Richter wrote:
> >=20
> > On Sat, 3 Nov 2001, Keld J=F8rn Simonsen wrote:
> >=20
> > > Hi !
> > >
> > > I talked with Dieter about a need for not being
> > > able to change a transaction, once it has been entered.
> > > This is a requirement by Danish law, so it is important
> > > for Danes sql-ledger users to have that capability.
> >=20
> > 	Do you mean that once *any* transaction is entered it cannot be
> > changed?  even if it just needs to be corrected?
>=20
> I think there should be two options:
> 1. to "close" the books once in a while, that is, mark all
> transactions up to a given time as unchangeable. Could be done as
> a global variable per database, that is tested before any
> change of a transaction.
>=20
> 2. To "close" every transaction every time a new one is entered.
> This could also be a global variable per database.
>=20
> I am not sure whether the granularity is good enough.
> Should one be able to close only parts of a database?
> Eg if there were department dependent bookkeeping, then
> only for a certain department.
>=20
> In all cases it should not require administrative privileges,
> but should be available per database, and to the one that does the
> bookkeeping. The privilege should probably be available to people that
> are allowed to change the setup for a database, and available on the
> preferences menu.
>=20
> Kind regards
> Keld
>=20
>=20