Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0004684Openbravo ERP07. Sales managementpublic2008-08-22 15:572008-12-02 14:23
Reporterdvpson 
Assigned ToAinhoaPagola 
PrioritynormalSeverityminorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version2.40beta 
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
Summary0004684: External Point Of Sales - Product Categories and Products should be unique
DescriptionShould not allow the same Product Categories nor the same Products to be added.

Will cause errors when synching with POS
Steps To Reproduce1. NAVIGATE TO:

Sales Management || Setup || External Point of Sales || External Point of Sales >> Product Categories.

2. CREATE NEW RECORD

3. SELECT A PRODUCT CATEGORY

4. SAVE AND NEW

5. SELECT THE SAME PRODUCT CATEGORY

6. SAVE

You should not be allowed to do this.

REPEAT STEPS FOR PRODUCT.


Proposed SolutionPlace a unique constraint on these fields
Additional Information
TagsNo tags attached.
Relationships
depends on backport 0004919 closed AinhoaPagola External Point Of Sales - Product Categories and Products should be unique 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2008-08-22 15:57dvpsonNew Issue
2008-08-22 15:57dvpsonAssigned To => cromero
2008-08-22 15:57dvpsonsf_bug_id0 => 2067551
2008-08-22 18:26psarobeSeveritymajor => minor
2008-08-22 18:26psarobeStatusnew => scheduled
2008-08-27 20:33dvpsonIssue Monitored: dvpson
2008-10-29 13:11cromeroAssigned Tocromero => AinhoaPagola
2008-10-29 18:18svnbotCheckin
2008-10-29 18:18svnbotNote Added: 0009834
2008-10-29 18:18svnbotStatusscheduled => resolved
2008-10-29 18:18svnbotResolutionopen => fixed
2008-10-29 18:18svnbotsvn_revision => 9401
2008-12-02 14:23krishnaRegression testing => No
2008-12-02 14:23krishnaStatusresolved => closed

Notes
(0009834)
svnbot   
2008-10-29 18:18   
Repository: openbravo
Revision: 9401
Author: AinhoaPagola
Date: 2008-10-29 18:18:27 +0100 (Wed, 29 Oct 2008)

Fixes bug 0004684 External Point of Sales - Added unique constraint to Product Categories and Products.

---
U trunk/src-db/database/model/tables/C_EXTERNALPOS_CATEGORY.xml
U trunk/src-db/database/model/tables/C_EXTERNALPOS_PRODUCT.xml
---

https://dev.openbravo.com/websvn/openbravo/?rev=9401&sc=1 [^]