Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0009277 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Openbravo ERP] 07. Sales management | minor | always | 2009-06-01 19:27 | 2009-07-16 17:55 | |||
| Reporter | mirurita | View Status | public | |||||
| Assigned To | harikrishnan | |||||||
| Priority | normal | Resolution | fixed | Fixed in Version | pi | |||
| Status | closed | Fix in branch | Fixed in SCM revision | 683280592d18 | ||||
| Projection | none | ETA | none | Target Version | ||||
| OS | Linux 32 bit | Database | PostgreSQL | Java version | 1.6.0_11 | |||
| OS Version | rPath Linux | Database version | 8.3.5 | Ant version | 1.7.1 | |||
| Product Version | 2.50 | 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 | 0009277: Is not possible to include the same Product/Product Category in two different External Point of Sales | |||||||
| Description | Two different External Point of Sale can't have the same Product Categories or Products included. ERROR: duplicate key value violates unique constraint "c_extposcat_prodcategory_un" ERROR: duplicate key value violates unique constraint "c_extposprod_product_un" | |||||||
| Steps To Reproduce | Go to Sales Management || Setup || External Point of Sales Create the first External POS - search key: epos1 - name: epos1 - Document type: POS Order - add a Business Partner In Product Categories tab add Clothes category and save Create the second External POS - search key: epos2 - name: epos2 - Document type: POS Order - add a Business Partner In Product Categories tab add Clothes category and save The same behavior with included Products. | |||||||
| Proposed Solution | Change the unique constraints c_extposcat_prodcategory_un UNIQUE (m_product_category_id) CONSTRAINT c_extposprod_product_un UNIQUE (m_product_id) including c_externalpos_id field. | |||||||
| Tags | No tags attached. | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
|
 Relationships |
|
Notes |
|
|
(0017755) hgbot (developer) 2009-07-02 11:38 |
Repository: erp/devel/pi Changeset: 683280592d184ce720bd9d54da6c4ef131c0768b Author: Harikrishnan Raja <harikrishnan.raja <at> openbravo.com> Date: Thu Jul 02 15:01:57 2009 +0530 URL: http://code.openbravo.com/erp/devel/pi/rev/683280592d184ce720bd9d54da6c4ef131c0768b [^] Fixes Issue 9277: Is not possible to include the same Product/Product Category in two different External Point of Sales --- M src-db/database/model/tables/C_EXTERNALPOS_CATEGORY.xml M src-db/database/model/tables/C_EXTERNALPOS_PRODUCT.xml --- |
|
(0017777) sureshbabu (reporter) 2009-07-03 11:33 |
Tested working fine |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2009-06-01 19:27 | mirurita | New Issue | |
| 2009-06-01 19:27 | mirurita | Assigned To | => rafaroda |
| 2009-06-05 13:10 | psarobe | Status | new => scheduled |
| 2009-06-05 13:10 | psarobe | fix_in_branch | => pi |
| 2009-06-05 15:32 | rafaroda | Assigned To | rafaroda => sathiyan |
| 2009-06-05 15:32 | rafaroda | fix_in_branch | pi => |
| 2009-06-29 16:50 | sathiyan | Assigned To | sathiyan => harikrishnan |
| 2009-07-02 11:38 | hgbot | Checkin | |
| 2009-07-02 11:38 | hgbot | Note Added: 0017755 | |
| 2009-07-02 11:38 | hgbot | Status | scheduled => resolved |
| 2009-07-02 11:38 | hgbot | Resolution | open => fixed |
| 2009-07-02 11:38 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/devel/pi/rev/683280592d184ce720bd9d54da6c4ef131c0768b [^] |
| 2009-07-03 11:33 | sureshbabu | Status | resolved => closed |
| 2009-07-03 11:33 | sureshbabu | Note Added: 0017777 | |
| 2009-07-03 11:33 | sureshbabu | Fixed in Version | => pi |
| 2009-07-16 17:55 | anonymous | sf_bug_id | 0 => 2822554 |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |