Anonymous | Login
News | My View | View Issues | Roadmap | Summary

View Issue DetailsJump to Notes ] Issue History ] Print ]
TypeCategorySeverityReproducibilityDate SubmittedLast Update
feature request[Openbravo ERP] 09. Financial managementmajoralways2009-09-29 11:292011-02-04 09:11
ReporternetworkbView Statuspublic 
Assigned Tormorley 
PrioritynormalResolutionopenFixed in Version
StatusnewFix in branchFixed in SCM revision
ProjectionnoneETAnoneTarget Version2.50MP7
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product Version2.50MP5SCM revision 
Review Assigned To
Web browser
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo

0010809: The sequences does not allow to use number as 000001

DescriptionThe sequences does not allow to use number as 000001. Althoug the documentno
are varchar, you are not able to use number as 000001, because the field on the sequence definition window contains numbers.
This is a problem because if you use numbers starting on 1,
and your create some invoices, if you order the invoices using documentno field, you will see the 10 number before 2 what is not correct.
Steps To Reproduce-Create new sequence starting on 1 and assign it to a document type.
-Crate 11 invoices using the document type with the sequence created.
-See the grid on invoices window.
-Order the invoices using the documentno field
-See that the invoices are ordered incorrectly because the invoice 10 appear before the 2,3,... It is because the documentno contain fields as varchar so
to be ordered properly the values should be 01,02...
Proposed SolutionOne posssibility is to add int he sequence definition window a new field where fill a mask. this mask could be used when generating the sequence to generate properly the sequence.
For example for a value 1 with a mask #### the number generated would be 0001
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]
related to feature request 0003020pi acknowledgededuardo_Argal Left padding in document numbers 
related to backport 00179822.50MP34 closedjecharri The application does not order by document number properly 

-  Notes
rafaroda (developer)
2009-09-29 13:56

Please specify the product and target version.

networkb (developer)
2009-10-05 17:03

Hi, why has this bug been classified as a feature request?
The problem is clear, using the sequences the documents generated can not be ordered correctly
pnuding (reporter)
2009-10-14 12:54

Right now Openbravo ERP does not support left padding (adding zeroes on the left of the document number). Added relationship to the main feature request, issue 0003020
Explanation provided to JAL

- Issue History
Date Modified Username Field Change
2009-09-29 11:29 networkb New Issue
2009-09-29 11:29 networkb Assigned To => rafaroda
2009-09-29 13:56 rafaroda Note Added: 0020452
2009-09-29 13:56 rafaroda Status new => feedback
2009-09-29 22:36 psarobe Assigned To rafaroda => pjuvara
2009-09-29 22:36 psarobe Type defect => feature request
2009-09-30 09:34 networkb Status feedback => new
2009-09-30 09:34 networkb version => 2.50MP5
2009-09-30 09:34 networkb Target Version => 2.50MP7
2009-10-05 17:03 networkb Note Added: 0020712
2009-10-14 12:53 pnuding Relationship added related to 0003020
2009-10-14 12:54 pnuding Note Added: 0021003
2009-10-14 12:54 pnuding Assigned To pjuvara => networkb
2009-10-30 15:02 pnuding Assigned To networkb => pjuvara
2011-02-04 09:11 jpabloae Assigned To pjuvara => rmorley
2011-08-19 08:32 jecharri Relationship added related to 0017982

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker