Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0004416Openbravo ERPA. Platformpublic2008-07-15 18:322011-10-28 14:05
Reportergorkaion 
Assigned Toiciordia 
PriorityhighSeverityminorReproducibilityalways
StatusscheduledResolutionopen 
PlatformOS20OS VersionGentoo
Product Version2.40 
Target VersionFixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0004416: Autogenerate Search Key values
DescriptionIn old versions of Openbravo (checked that is working in OB 2.22) you could left null the Search Key (for example in Product window) and the application when the new entry is saved generates a new value.

Looking in the sources and in database everything is prepared, but as the field is mandatory it is not possible to left blank the search key. If we set the field as not mandatory and recompile the sources changes and doesn't generate anything.
Steps To ReproduceGo to Product window and try to enter a new product with null Search Key. You can't because the field is mandatory.

Modify in the Application Dictionary the column Value of the M_Product table and compile the Product window.

Now you can save with a null Search Key but you get a database error because the Value column is mandatory in database.
Proposed SolutionI see 2 possible solutions:

1) enable the possibility of inserting null Search Keys, changing wad to include the code that calls the getDocumentNo method always when it is a Value column, or inserting a rule to set in the html the field as not mandatory so you can left the Search Key null.

2) modify the Search Key fields to be like the DocumentNo fields. So when it is inserted a new record the application suggest a new number ('<000000001>'). I prefer this solution.
Additional Information
Tags250MP1
Relationships
related to defect 00141262.50MP21 closed iciordia A squence created for the value field of the partner is not applied automatically 
depends on backport 0004902 closed shuehner Autogenerate Search Key values 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2008-07-15 18:32gorkaionNew Issue
2008-07-15 18:32gorkaionAssigned To => cromero
2008-07-15 18:32gorkaionsf_bug_id0 => 2018785
2008-07-22 09:02cromeroStatusnew => scheduled
2008-07-22 09:02cromeroAssigned Tocromero => alostale
2008-07-22 09:02cromerofix_in_branch => trunk
2008-12-10 09:58alostaleAssigned Toalostale => iperdomo
2009-01-19 13:06psarobeversion => 2.40
2009-01-19 13:06psarobefix_in_branchtrunk =>
2009-02-03 17:45iperdomoAssigned Toiperdomo => anthony_wolski
2009-04-16 13:23iperdomoAssigned Toanthony_wolski => iperdomo
2009-04-22 10:38psarobePrioritynormal => high
2009-04-23 16:05psarobeTag Attached: 250MP1
2009-11-24 11:43iperdomoAssigned Toiperdomo => shuehner
2010-05-10 17:43shuehnerAssigned Toshuehner => iciordia
2010-08-09 11:34psarobeRelationship addedrelated to 0014126
2011-10-28 14:05iciordiaTypedefect => feature request

There are no notes attached to this issue.