On Mon, Apr 9, 2012 at 9:29 AM, billy akazawa <billy7...@gmail.com> wrote:
> Thanks, Erik, > >> Well the short term solution would be to use psql to log into your >> database and issue >> >> GRANT delete ON gl TO <the-role-you-want-to-be-able-to-delete>; >> >> OK. I did that and now get the following: > > Error!* > *DELETE FROM gl WHERE id = '1'* > * > ERROR: permission denied for relation yearend* > *CONTEXT: SQL statement "delete from yearend where trans_id = old.id"* > PL/pgSQL function "del_yearend" line 3 at SQL statement* > To solve that you need to ru: GRANT delete ON yearend TO <the-role-you-want-to-be-able-to-delete>; The same way like last time: log in through the psql interface. (Note the difference between the first and the second statement is the ON part which names a different table.) However, longer term, would it be an option for you to reverse the >> transaction instead of deleting, BUT: with a report which hides all >> reversed originals and their neutralizing reversal transactions? The effect >> would be a list of GL transactions equal to the one you're seeing today. >> >> Yes, that might work if I could print out the individual accounts in the > general ledger without the corrections as well as the Balance Sheet and P/L > statements. > Exactly, that's the idea. > The difference would be that LedgerSMB would not support deletion anymore, >> which is very important to the good faith accountants of other users will >> have in LedgerSMB. I know, that's not your problem, but if the proposed >> solution above works for you, we can serve both camps with a single >> solution. >> >> A suggestion might be to offer the administrator the option to create an > audit trail (and not allow deletion) or not when he or she sets up the > database. > Many commercial Japanese accounting software systems offer this option (I > used to use PCA Kaikei, which had the option). I would assume the major > corporations choose the audit trail option, while small places like mine > where only one or two people do the accounting don't. > This option is the option we currently support, with the exception that we don't ask the question, but setup without deletion by default. There are a few statements you need to execute through the psql interface to enable it. We're currently finding out which ones exactly. > Thanks for all your help - I really appreciate it! > Billy > Welcome. Don't hesitate to ask more questions if you need to. Bye, Erik.
------------------------------------------------------------------------------ For Developers, A Lot Can Happen In A Second. Boundary is the first to Know...and Tell You. Monitor Your Applications in Ultra-Fine Resolution. Try it FREE! http://p.sf.net/sfu/Boundary-d2dvs2
_______________________________________________ Ledger-smb-users mailing list Ledger-smb-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
