Odoo Help


Sales orders over 999 not visible

on 3/12/14, 11:36 AM 2,353 views

Good day

I am running openerp 7. I have been capturing my quotes for over a year, now however I cannot see any quote over 999. I am approx 1030 but cannot see the latest 30 not matter how i sort or filter etc.

Any feedback welcome


All I can tell you is that the first customer database I checked had 5753 sales orders and I was able to see them all, 80 at time.

Ray Carnes
on 3/12/14, 10:03 PM

Med Said BARA

--Med Said BARA--

| 5 5 7
--Med Said BARA--
Med Said BARA
On 3/12/14, 10:32 PM


Verify in the configuration under Settings --> Technical ---> sequences & Identifiers ---> Sequences the value Number Padding of the Sale Journal Sequence (SAJ) (increase this value).

It seems to me that you are using an old version of v7.0 , if it's true, there is a fix for this issue.

Edit your sale.py file (.../openerp/addons/sales/sale.py), around line 248, change the line _order = "name desc" by _order = 'date_order desc, id desc'.


Update your sale module.

Before doing that, do a backup of your OpenERP installation and your Datbase (Just in case ...).

This is, just a fix, the solution is to update your OpenERP instance.

Hi Thanks for your answer. But no joy. It's very odd, I can search for SO1000 and it will return it for me, but in list view it just wont show anything higher than SO999. I tried padding at 4 and 5 and refreshing but still only SO999 shows

on 3/13/14, 3:52 AM

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

1 follower(s)


Asked: 3/12/14, 11:36 AM
Seen: 2353 times
Last updated: 3/16/15, 8:10 AM