Openbravo Issue Tracking System - Openbravo ERP | |||||
| View Issue Details | |||||
| ID | Project | Category | View Status | Date Submitted | Last Update |
| 0009277 | Openbravo ERP | 07. Sales management | public | 2009-06-01 19:27 | 2009-07-16 17:55 |
| Reporter | mirurita | ||||
| Assigned To | harikrishnan | ||||
| Priority | normal | Severity | minor | Reproducibility | always |
| Status | closed | Resolution | fixed | ||
| Platform | OS | 20 | OS Version | rPath Linux | |
| Product Version | 2.50 | ||||
| Target Version | Fixed in Version | pi | |||
| Merge Request Status | |||||
| Review Assigned To | |||||
| OBNetwork customer | No | ||||
| Web browser | |||||
| Modules | Core | ||||
| Support ticket | |||||
| 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. | ||||
| Additional Information | |||||
| Tags | No tags attached. | ||||
| Relationships | |||||
| Attached Files | |||||
| 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 | OBNetwork customer | => No | ||
| 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 | ||
| Notes | |||||
|
|
|||||
|
|
||||
|
|
|||||
|
|
||||