Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0003494 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| feature request | [Openbravo ERP] 09. Financial management | minor | always | 2008-05-27 23:43 | 2008-12-17 11:09 | |||
| Reporter | user71 | View Status | public | |||||
| Assigned To | rmorley | |||||||
| Priority | normal | Resolution | fixed | Fixed in Version | ||||
| Status | closed | Fix in branch | Fixed in SCM revision | |||||
| Projection | none | ETA | none | Target Version | ||||
| OS | Any | Database | Any | Java version | ||||
| OS Version | Database version | Ant version | ||||||
| Product Version | 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 | 0003494: Left Padding in the Document Number | |||||||
| Description | Due to local regulations the invoice number must be completed with zeros in the middle. I mean, if the invoice number is "100", the prefix is "A-10000-" and there is no sufix; the number would be like this: "A-10000-00000100" I solve this by adding by myself a lpad(8,v_NextNo) in the ad_sequence_doctype SQL function. See the attached file. I think the best solution would by the addition of a new boolean field in the C_DOCTYPE table for indicate if the lpad needs to by applied. Additionally we need two more field to indicate the character filler (in this case is the zero) and the number of positions (in this case 8) Regards, Alfredo | |||||||
| Tags | No tags attached. | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
|
 Relationships |
|
Notes |
|
|
(0003962) pjuvara (reporter) 2008-06-05 16:46 edited on: 2008-06-12 09:26 |
Logged In: YES user_id=1871571 Originator: NO Duplicate of 1556565. |
|
(0007083) user71 2005-06-01 00:00 edited on: 2008-06-12 09:44 |
This bug was originally reported in SourceForge bug tracker and then migrated to Mantis. You can see the original bug report in: https://sourceforge.net/support/tracker.php?aid=1975539 [^] |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2008-12-17 11:09 | pjuvara | Assigned To | user71 => rmorley |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |