Corrections to AP

[Andrew Rowland <..hidden..>]

Hi

I inadvertently posted an AP invoice with an incorrect date. Can someone please tell me the best way to correct this.

The 'Save' button warns of reposting but then fails with:

INSERT INTO ap (invnumber, person_id, 

				entity_credit_account)
			     VALUES (?,    (select  u.entity_id from users u
                 join entity e on(e.id = u.entity_id)
                 where u.username=? and u.entity_id in(select p.entity_id from person p) ), ?)

ERROR:  current transaction is aborted, commands ignored until end of transaction block


Also the 'Delete' Button doesn't work so I can't delete the AP entry:

Error!

DELETE FROM ap WHERE id = ?
ERROR: permission denied for relation ap

I've also tried adding the role lsmb_<companyname>__ap_all - which makes no difference


Thanks

Andrew

------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and 
threat landscape has changed and how IT managers can respond. Discussions 
will include endpoint security, mobile security and the latest in malware 
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/

_______________________________________________
Ledger-smb-users mailing list
..hidden..
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users