Re: permission denied for sequence invoice_id

On Wed, Nov 19, 2014 at 12:16 AM, Max van Biezen <..hidden..> wrote:

Hi,

Using 1.4.7 I have a user/sales person that I want to be able to make
quotes (add,change,remove) and to convert them to invoices and to
create invoice directly. This user when clicking save in the invoice
created from the quote gets the error as shown below.

What role to select to allow this user to save/post/send invoices? I
have currently checked:
- base user
- ar invoice create
- ar transaction list
- sales quotation create/delete/list

ar invoice create should be sufficient. It looks like this was omitted though so for now, add ar invoice create voucher.

2014/11/19 08:37:14 - ERROR - Form::_error LedgerSMB/Form.pm (438) --
dbversion: 1.4.7, company: <company_name>
exit at LedgerSMB.pm line 631.
Compilation failed in require at /usr/local/lsmb14/is.pl line 7.
DBD::Pg::db do failed: ERROR: permission denied for sequence
invoice_id_seq at LedgerSMB/IS.pm line 1062.
2014/11/19 08:37:40 - ERROR - Form::_error LedgerSMB/Form.pm (437) -- '
INSERT INTO invoice (description)
VALUES ('Wed Nov 19 08:37:40 201418223')
ERROR: permission denied for sequence invoice_id_seq at
LedgerSMB/IS.pm line 1062

Kind regards,

Max

------------------------------------------------------------------------------
Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server
from Actuate! Instantly Supercharge Your Business Reports and Dashboards
with Interactivity, Sharing, Native Excel Exports, App Integration & more
Get technology previously reserved for billion-dollar corporations, FREE
http://pubads.g.doubleclick.net/gampad/clk?id=157005751&iu=/4140/ostg.clktrk
_______________________________________________
Ledger-smb-users mailing list
..hidden..
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users

Best Wishes,

Chris Travers

Efficito: Hosted Accounting and ERP. Robust and Flexible. No vendor lock-in.

http://www.efficito.com/learn_more

Re: permission denied for sequence invoice_id_seq