Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0010809Openbravo ERP09. Financial managementpublic2009-09-29 11:292011-02-04 09:11
Reporternetworkb 
Assigned Tormorley 
PrioritynormalSeveritymajorReproducibilityalways
StatusnewResolutionopen 
PlatformOS5OS Version
Product Version2.50MP5 
Target Version2.50MP7Fixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0010809: 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
Additional Information
TagsNo tags attached.
Relationships
related to feature request 0003020pi acknowledged eduardo_Argal Left padding in document numbers 
related to backport 00179822.50MP34 closed jecharri The application does not order by document number properly 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2009-09-29 11:29networkbNew Issue
2009-09-29 11:29networkbAssigned To => rafaroda
2009-09-29 13:56rafarodaNote Added: 0020452
2009-09-29 13:56rafarodaStatusnew => feedback
2009-09-29 22:36psarobeAssigned Torafaroda => pjuvara
2009-09-29 22:36psarobeTypedefect => feature request
2009-09-30 09:34networkbStatusfeedback => new
2009-09-30 09:34networkbversion => 2.50MP5
2009-09-30 09:34networkbTarget Version => 2.50MP7
2009-10-05 17:03networkbNote Added: 0020712
2009-10-14 12:53pnudingRelationship addedrelated to 0003020
2009-10-14 12:54pnudingNote Added: 0021003
2009-10-14 12:54pnudingAssigned Topjuvara => networkb
2009-10-30 15:02pnudingAssigned Tonetworkb => pjuvara
2011-02-04 09:11jpabloaeAssigned Topjuvara => rmorley
2011-08-19 08:32jecharriRelationship addedrelated to 0017982

Notes
(0020452)
rafaroda   
2009-09-29 13:56   
Please specify the product and target version.

Thanks.
(0020712)
networkb   
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
(0021003)
pnuding   
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