0008962: Create Inventory Count List generates duplicate rows

Description

Physical Inventory -> Create Inventory count list generates duplicate rows if a product has Org Specific information defined for multiple organizations.

Steps To Reproduce

1. For a product define Org Specific information for multiple organizations
2. Run Create Inventory Count List process

-> similar lines appear as many times as there is org specific information

Proposed Solution

Only take the Org Specific information from the organization that owns the inventory count list.

See the attached patch.

Tags

OB3-Reviewed

Attached Files

org-specific-from-the-current-org.diff [^] (690 bytes) 2009-05-08 11:23 [Show Content] [Hide Content]

Index: src-db/database/model/functions/M_INVENTORY_LISTCREATE.xml
===================================================================
--- src-db/database/model/functions/M_INVENTORY_LISTCREATE.xml	(revision 14294)
+++ src-db/database/model/functions/M_INVENTORY_LISTCREATE.xml	(working copy)
@@ -226,6 +226,7 @@
         (SELECT M_Locator_ID FROM M_Locator WHERE M_Warehouse_ID=v_Warehouse_ID))
         AND(v_Product_Category_ID IS NULL
         OR p.M_Product_Category_ID=v_Product_Category_ID)
+        AND (o.AD_Org_ID=v_Org_ID OR o.AD_Org_ID IS NULL)  --Take Org specific information only for the current org.
         AND NOT EXISTS
         (SELECT *
         FROM M_InventoryLine l

Relationships [ Relation Graph ] [ Dependency Graph ]

duplicate of	backport	0018350	2.50MP34	closed	xabiermerino	If the product has lines in the org specific the process M_Inventory_listcreate does not work properly
depends on	backport	0008983		closed	gorkaion	Create Inventory Count List generates duplicate rows

Notes
There are no notes attached to this issue.

Issue History
Date Modified	Username	Field	Change
2009-05-08 11:23	villind	New Issue
2009-05-08 11:23	villind	Assigned To	=> rafaroda
2009-05-08 11:23	villind	File Added: org-specific-from-the-current-org.diff
2009-05-08 11:23	villind	OBNetwork customer	=> No
2009-05-08 11:23	villind	Regression testing	=> No
2009-05-11 11:09	psarobe	Status	new => scheduled
2009-05-11 11:09	psarobe	Assigned To	rafaroda => gorkaion
2009-05-11 11:09	psarobe	fix_in_branch	=> pi
2011-10-28 13:23	psarobe	Tag Attached: OB3-Reviewed
2012-04-27 11:54	mirurita	Relationship added	duplicate of 0018350
2012-04-27 11:54	mirurita	Status	scheduled => closed
2012-04-27 11:54	mirurita	Resolution	open => duplicate