Reversing entries as opposed to deleting entries (US G.A.A.P.) WAS: pretty cool app,

[Marvin D. <pe...@be...>]

Hi David,

If I am not mistaken, you can setup sql-ledger to force users to reverse 
entries (As opposed to the ability to delete entries) by issuing a REVOKE 
DELETE rights statement for users: 


GRANT SELECT, INSERT, UPDATE, DELETE ON <all the SQL-Ledger tables> TO 
username 

REVOKE DELETE ON acc_trans FROM username 


Take it easy.

PS: I didn't know you were on this list....


On Tuesday 01 January 2002 10:29, you wrote:
> Apart from adding "me too" (Tm AOLusers), I'd like to add that the only
> "problem" I see with using SQL-Ledger, at least for US businesses, is that
> you can delete transactions.  I don't know about Canada, but at least in
> the US, GAAP (Generally Accepted Accounting Practice) is (or at least was)
> that you don't delete transactions, you create reversing entries.  
>
> Ciao,
>
> David A. Bandel