Odoo Help


This community 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.


Invoices filtered by create_uid

on 10/25/13, 1:24 PM 1,513 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--

Systems Engineer + MBA

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

Your Answer

Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!

About This Community

This community is for professionals and enthusiasts of our products and services. Read Guidelines

Question tools

0 follower(s)


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