0010089: on 2.40 the pl-function ma_standard_cost_sequence does not compile (call non-existant other pl-function)

Description

The function call to another pl-function: M_GET_PRODUCT_PRICE_DATE were the real function is called GET_PRODUCT_PRICE_DATE (on 2.40).

Tags

No tags attached.

Attached Files

patch_10089.diff [^] (1,027 bytes) 2009-07-28 15:38 [Show Content] [Hide Content]

diff --git a/src-db/database/model/functions/MA_STANDARD_COST_SEQUENCE.xml b/src-db/database/model/functions/MA_STANDARD_COST_SEQUENCE.xml
--- a/src-db/database/model/functions/MA_STANDARD_COST_SEQUENCE.xml
+++ b/src-db/database/model/functions/MA_STANDARD_COST_SEQUENCE.xml
@@ -167,7 +167,7 @@
 
     -- Purchased raw material
     IF (v_No_Cost) THEN
-      SELECT COALESCE(C_CURRENCY_CONVERT(MAX(bl.Price), bl.C_CURRENCY_ID, p_Currency, p_Calcdate, bl.ad_client_id, bl.ad_org_id),M_GET_PRODUCT_PRICE_DATE(MAX(p.AD_CLIENT_ID), MAX(p.M_PRODUCT_ID), p_CalcDate)) INTO v_Cost
+      SELECT COALESCE(C_CURRENCY_CONVERT(MAX(bl.Price), bl.C_CURRENCY_ID, p_Currency, p_Calcdate, bl.ad_client_id, bl.ad_org_id),GET_PRODUCT_PRICE_DATE(MAX(p.AD_CLIENT_ID), MAX(p.M_PRODUCT_ID), p_CalcDate)) INTO v_Cost
       FROM M_Product p LEFT JOIN C_BudgetLine bl ON p.M_Product_ID = bl.M_Product_ID
                                                     AND bl.C_Budget_ID = p_Budget_ID
       WHERE p.M_Product_ID = Cur_UsedProducts.M_Product_ID

Relationships [ Relation Graph ] [ Dependency Graph ]

related to	backport	0007957		closed	rafaroda	Multi currency issues in some processes and tables
has duplicate	defect	0010161		closed	rafaroda	ma_standard_cost_sequence contains a not existing procedure

Notes
(0018661) hgbot (developer) 2009-07-28 16:32	Repository: erp/stable/2.40 Changeset: 626bd8edb61399fd1dc0ac23e275899c763b6be8 Author: Stefan Hühner <stefan.huehner <at> openbravo.com> Date: Tue Jul 28 16:31:10 2009 +0200 URL: http://code.openbravo.com/erp/stable/2.40/rev/626bd8edb61399fd1dc0ac23e275899c763b6be8 [^] Fixed 10089: Fix error in pl-function which was calling another pl with the wrong function name --- M src-db/database/model/functions/MA_STANDARD_COST_SEQUENCE.xml ---

Issue History
Date Modified	Username	Field	Change
2009-07-28 15:31	shuehner	New Issue
2009-07-28 15:31	shuehner	Assigned To	=> rafaroda
2009-07-28 15:32	shuehner	Relationship added	related to 0007957
2009-07-28 15:38	shuehner	File Added: patch_10089.diff
2009-07-28 16:32	hgbot	Checkin
2009-07-28 16:32	hgbot	Note Added: 0018661
2009-07-28 16:32	hgbot	Status	new => resolved
2009-07-28 16:32	hgbot	Resolution	open => fixed
2009-07-28 16:32	hgbot	Fixed in SCM revision	=> http://code.openbravo.com/erp/stable/2.40/rev/626bd8edb61399fd1dc0ac23e275899c763b6be8 [^]
2009-08-03 13:21	rafaroda	Relationship added	has duplicate 0010161
2009-08-20 12:28	plujan	Status	resolved => closed
2009-08-21 00:00	anonymous	sf_bug_id	0 => 2841455