Dolibarr ERP & CRM » Bugs » bug #1314 [Bank] num_releve is not incremented correctly in releve.phpLatest modifications
Answer now
Snapshot| Details |
| Submitted by: | damien clochard (daamien) | | Submitted on: | 2014-03-26 15:58 |
| Last Modified On: | 2014-12-23 16:33 | |
| Summary: | [Bank] num_releve is not incremented correctly in releve.php |
| Description: | If you use a basic scheme for naming your "relevés" such as 1,2,3,..,9,10,11, etc. The "relevés" are not following each other correctly
For instance, the two pages below :
https://..../compta/bank/releve.php?account=4&num=9
https://..../compta/bank/releve.php?account=4&num=10
are not related to each other
Instead dolibarr seems to increment using the "alphabetic" order : 1,10,11,12,2,3,4,5,6,7,8,9
This is really confusing. The order I would expect is 1,2,3,4,5,6,7,8,9,10,11,12
The workaround is to add zeros and give a standard size to each num_releve such as : 001,002,...,009,010,011
But that's kind of ugly and you need to update all the rows of llx_bank to fix this afterward.
|
| Step to reproduce bug: | |
| Detected in version: | 3.4.2 | | Category: | Module: Banks and Cash |
| Severity: | 5 - Major | | OS Type/Version: | |
| PHP version: | | | Database type and version: | postgresql |
| Status |
| Status: | Open | | Assigned to: | None |
| Resolution: | Remind | |
Comments- Marcos García 2015-02-15 13:52
- The thing is that it is ordered correctly. This is an alphanumeric sort and not a numeric sort.
Alphanumeric sort is: A,B,C,D,E,F,G...AA,BB,CC,DD. So numbers are ordered the same way here: 1, 2, 3, 11, 22,33.
I don't know which is the preferred way as there can be numeric bank statements and alphanumeric. - damien clochard 2014-12-23 16:33
This is a very bad implicit rule !
If I go on to the rappro.php page, I get this message :
"Utilisez une valeur numérique triable (par exemple YYYYMM):"
Which can be translated as :
"Use a sortable numeric value (for example YYYYMM):"
-----------------------------
This is a problem because the sequence 1,2,3,4,5,etc. is composed of "sortable numeric values"
If you can't sort those sequences correctly, please remove the "for example" part, enforce the YYYYMM format and explain it to the user with a message like this :
"Use a sortable time-based value ( YYYYMM or YYYYMMDD )"
- Marcos García 2014-12-23 16:06
- I am afraid Dolibarr only accepts these two formats (AAAAMM or AAAMMJJ).
|
|
|
|
|
|
|
Alphanumeric sort is: A,B,C,D,E,F,G...AA,BB,CC,DD. So numbers are ordered the same way here: 1, 2, 3, 11, 22,33.
I don't know which is the preferred way as there can be numeric bank statements and alphanumeric.