0019291: Collected field on Project Profitability Report is not recording payments made with APR flow

Description

Collected field on Project Profitability Report is not recording payments made with APR flow. It sums only from C_DEBT_PAYMENT but not from FIN_PAYMENT table.

Steps To Reproduce

We can see in ReportProjectProfitability_data.xsql in the subquery DDD line 177 where calculates the sum of the Collected field. it calls a function C_INVOICE_PERCENTAGE_PAID.xml:

SELECT SUM(C_DB_PERCENTAGE_PAID(DB.C_Debt_Payment_ID)*
      C_Currency_Convert(DB.amount,DB.C_Currency_ID,I.C_Currency_ID,
      now(), null, I.AD_Client_ID, I.AD_Org_ID))/
  (CASE SUM(C_Currency_Convert(DB.amount,DB.C_Currency_ID,I.C_Currency_ID,
      now(), null, I.AD_Client_ID, I.AD_Org_ID)) WHEN 0 THEN to_number(NULL) ELSE SUM(C_Currency_Convert(DB.amount,DB.C_Currency_ID,I.C_Currency_ID,
      now(), null, I.AD_Client_ID, I.AD_Org_ID)) END) INTO v_percentaje
  FROM C_DEBT_PAYMENT DB, C_Invoice I
  WHERE DB.C_Invoice_ID = I.C_Invoice_ID
    AND I.C_INVOICE_ID = p_Invoice_ID;
  RETURN ROUND(v_percentaje,4);
END C_INVOICE_PERCENTAGE_PAID

We realise that only it takes into account the old flow.

Proposed Solution

It is necessary to add the sum from the FIN_PAYMENT table to the current one. The result is the sum from APR flow and the old one

Tags

No tags attached.

Attached Files

Relationships [ Relation Graph ] [ Dependency Graph ]

Notes
(0052203) dmiguelez (developer) 2012-09-18 13:59	This was already solved as paid amount is now a property of Invoice

Issue History
Date Modified	Username	Field	Change
2011-12-13 13:10	VictorVillar	New Issue
2011-12-13 13:10	VictorVillar	Assigned To	=> jonalegriaesarte
2011-12-13 13:10	VictorVillar	Modules	=> Core
2011-12-13 13:10	VictorVillar	Resolution time	=> 1328655600
2011-12-13 13:15	RenateNieuwkoop	Issue Monitored: RenateNieuwkoop
2012-01-24 13:42	jonalegriaesarte	Type	defect => design defect
2012-01-30 17:18	jonalegriaesarte	Target Version	3.0MP8 => 3.0MP9
2012-03-02 12:56	jonalegriaesarte	Target Version	3.0MP9 => 3.0MP10
2012-03-29 16:11	jonalegriaesarte	Target Version	3.0MP10 =>
2012-09-13 10:42	jonalegriaesarte	Assigned To	jonalegriaesarte => dmiguelez
2012-09-18 13:59	dmiguelez	Note Added: 0052203
2012-09-18 13:59	dmiguelez	Status	new => closed
2012-09-18 13:59	dmiguelez	Resolution	open => out of date