0005172: Fixed length document sequences - Openbravo Issue Tracking System

Openbravo Issue Tracking System - Openbravo ERP

View Issue Details

Project

Category

View Status

Date Submitted

Last Update

0005172

Openbravo ERP

01. General setup

public

2008-09-23 09:16

2008-09-30 12:40

Reporter

galderromo

Assigned To

cromero

Priority

normal

Severity

major

Reproducibility

N/A

Status

closed

Resolution

duplicate

Platform

OS Version

Gentoo 2.6.24

Product Version

Target Version

Fixed in Version

Merge Request Status

Review Assigned To

OBNetwork customer

Web browser

Modules

Core

Support ticket

Regression level

Regression date

Regression introduced in release

Regression introduced by commit

Triggers an Emergency Pack

Summary

0005172: Fixed length document sequences

Description

Document sequences can be setup with prefixes before and after the sequence. But it is not posible to fix the length of the documentno.

For example, it isn't possible to generate the next sequence:
PRE-0001-A
PRE-0002-A
PRE-0003-A
...

This functionality is very demanded by customer and users.

Steps To Reproduce

Go to sequences window and setup a sequence. Assign the sequence in a document (AP Invoice). Create a new document. The result will be:
PRE-1-A
PRE-2-A
PRE-3-A
...
PRE-10-A
PRE-11-A
...
PRE-100-A
PRE-101-A
...

Proposed Solution

Include two more field on sequence setup "left filling" and "right filling". Then implement lpad and rpad on ad_sequence_next, ad_sequence_doc and ad_sequence_doctype.

Additional Information