Odoo Help


Invoices filtered by create_uid

on 10/25/13, 1:24 PM 2,346 views

I am able to create invoices, but somehow, I can't see them using other users, even if the users have a lot of grants like Financial Manager and HR Manager. However, I can see the invoices when logging as admin user.
This is the query executed:

SELECT account_invoice.id FROM account_invoice WHERE ((account_invoice.create_uid = 11)  AND  (account_invoice.type = 'out_invoice')) AND (account_invoice.company_id IS NULL   OR  (account_invoice.company_id in (1))) ORDER BY account_invoice.id desc  limit 80

It's filtering using the account_invoice.create_uid = [current user] always. I can also see the movements in the journal entries, but I would like to see them there. I would really appreciate your help. Thanks in advance,


Grover Menacho

--Grover Menacho--
| 5 7 8
La Paz, Bolivia
--Grover Menacho--

Odoo Developer

Grover Menacho
On 10/25/13, 5:10 PM

OpenERP doesn't filter invoices by user by default. Did you change some code? or did you installed a thirdparty module? This must not be the normal behavior.

Hi Grover, I am afraid I haven't change the code. I've just installed the application and some modules from OpenERP, and the following 3rd party modules. Web Calendar Tests View Editor OpenERP Web Diagram LinkedIn Integration Web Web Gantt Graph Views Base Kanban Force Invoice Number Account viewer Cancel invoice, check on payment order

on 10/25/13, 7:47 PM

Wow that's really strange. Hmmm... Did you check if the problem persists on another database?

GH Mediacloud, Grover Menacho
on 10/26/13, 12:16 PM

you were right, it must have been some module installed. I re installed everything again and now it's working. Thanks a lot

on 10/26/13, 1:40 PM

About This Community

This platform is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.


Odoo Training Center

Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.

Test it now

Question tools

0 follower(s)


Asked: 10/25/13, 1:24 PM
Seen: 2346 times
Last updated: 3/16/15, 8:10 AM