0006393: Ability to Auto Increment the Product Reference Code

Description

In Administration -> Stock -> (New Record): Reference
I would like to be able to auto increment this value every time a value is entered in the Name field.

I have tried to modify the REFERENCE column of the PRODUCTS table to INTEGER AUTO_INCREMENT but this returns an error when filling in the Name field.

Error is:
NOT_00_0000
com.openbravo.basic.BasicException:
java.sql.SQLException: Incorrect integer value: " for column 'REFERENCE' at row 1

Steps To Reproduce

create a blank openbravopos database in MySQL
start openbravopos and let it create the database
create 1 product without a reference number
close openbravoPOS
modify the REFERENCE column in the PRODUCTS table to INTEGER AUTO_INCREMENT
reopen openbravoPOS
go back to Admin -> Admin -> Stock -> Products
Add a second product without a reference number
Exception as in the Description.

Proposed Solution

Add an ability to auto increment the reference number

Issue History
Date Modified	Username	Field	Change
2008-12-07 23:02	globeone	New Issue
2008-12-07 23:02	globeone	sf_bug_id	0 => 2404567
2012-11-07 09:40	priyam	Category	01 - General => (No Category)

Relationships [ Relation Graph ] [ Dependency Graph ]

Notes
There are no notes attached to this issue.