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 ]

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 (viewer) 2009-07-03 11:33	Tested working fine

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