Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||||||
| ID | ||||||||||||
| 0010809 | ||||||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||||||
| feature request | [Openbravo ERP] 09. Financial management | major | always | 2009-09-29 11:29 | 2011-02-04 09:11 | |||||||
| Reporter | networkb | View Status | public | |||||||||
| Assigned To | rmorley | |||||||||||
| Priority | normal | Resolution | open | Fixed in Version | ||||||||
| Status | new | Fix in branch | Fixed in SCM revision | |||||||||
| Projection | none | ETA | none | Target Version | 2.50MP7 | |||||||
| OS | Any | Database | Any | Java version | ||||||||
| OS Version | Database version | Ant version | ||||||||||
| Product Version | 2.50MP5 | SCM revision | ||||||||||
| Review Assigned To | ||||||||||||
| Web browser | ||||||||||||
| Modules | Core | |||||||||||
| Regression level | ||||||||||||
| Regression date | ||||||||||||
| Regression introduced in release | ||||||||||||
| Regression introduced by commit | ||||||||||||
| Triggers an Emergency Pack | No | |||||||||||
| Summary | 0010809: The sequences does not allow to use number as 000001 | |||||||||||
| Description | The 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 Solution | One 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 | |||||||||||
| Tags | No tags attached. | |||||||||||
| Attached Files | ||||||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
|||||||||||||||
|
|||||||||||||||
 Relationships |
|
Notes |
|
|
(0020452) rafaroda (developer) 2009-09-29 13:56 |
Please specify the product and target version. Thanks. |
|
(0020712) 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 |
|
(0021003) 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 |
|
Notes |
|
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 |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |