Change description of gl transaction.

[Arne Hanssen <..hidden..>]

Is it possible to change the description of an entry in the gl table?
Seems like this has change some time ago.  I'm using 1.3.47 and I get 
this error:

# UPDATE gl SET description='Kont. Arne H.' WHERE id='630';

ERROR:  null value in column "person_id" violates not-null constraint
DETAIL:  Failing row contains (630, gl, 16-031, null, UPDATE, 2016-03-27 
17:45:33.702631, null, 2398).
CONTEXT:  SQL statement "INSERT INTO audittrail 
(trans_id,tablename,reference, action, person_id)
values (t_row.id,TG_RELNAME,t_reference, TG_OP, person__get_my_entity_id())"
PL/pgSQL function gl_audit_trail_append() line 19 at SQL statement

The contents is this:

# select * from gl where id='630';

  id  | reference |    description    | transdate  | person_id | notes | 
approved | department_id
-----+-----------+-------------------+------------+-----------+-------+----------+---------------
  630 | 16-031    | Kont. Arnstein I. | 2016-03-11 | |       | t        
|             0
(1 row)

This is not a big deal, I don't bother to make any correction 
transactions from within LSMB for this minor error, but it woud be nice 
to correct this in the db (as I now and then must do for transdate in 
table acc_trans when I forget to set correct date on save/post and 
today's date is used).  I used to correct dates i gl table also, but 
this isn't allowed enymore?

-- 
Vennlig hilsen / Best regards      |\     ___,,--,        _
Arne Hanssen, Senja, Norway        /,`--''        \-,,__,'/
[ Linux counter #102028 @ ]       |,4   ) )_    ) /~-----'
[ http://linuxcounter.net ]------'---^~(_/-_)--(_/_)-------
	


------------------------------------------------------------------------------
Transform Data into Opportunity.
Accelerate data analysis in your applications with
Intel Data Analytics Acceleration Library.
Click to learn more.
http://pubads.g.doubleclick.net/gampad/clk?id=278785351&iu=/4140
_______________________________________________
Ledger-smb-users mailing list
..hidden..
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users