0012813: Amount column value mismatches in FIN_Payment & FIN_Payment_Detail

Description

i created a two invoices each of invoice amount for 52.20 euros for BP: Mc Givers.
Then i created Payment document using Make Payment window(Procurement Management || Transactions || Make Payment || Header), by adding a invoice document of payment amount 52.20.

Then i verified the amount column in both the tables FIN_Payment, FIN_Payment_Detail using the below query

select Amount from FIN_Payment where documentno='700000';
Select sum(amount) from FIN_Payment_Detail where FIN_PAYMENT_ID IN (select FIN_PAYMENT_ID from FIN_Payment where documentno='700000');

Both shows the same amount.(52.2)

But later i "Reactivated" the above payment document and added one more purchase invoice of payment amount 52.20(Now there are two lines in lines tab)

Then i executed the below query but i am finding the difference in sum of amount

select Amount from FIN_Payment where documentno='700000'; (Result: 52.2)
Select sum(amount) from FIN_Payment_Detail where FIN_PAYMENT_ID IN (select FIN_PAYMENT_ID from FIN_Payment where documentno='700000'); (Result: 102.4)

Tags

Advance Rec & Payables

Attached Files

Make payment is reactivated and addd one more invoice document.JPG [^] (85,590 bytes) 2010-03-26 07:49

Relationships [ Relation Graph ] [ Dependency Graph ]

Notes
(0026121) gorkaion (developer) 2010-04-13 11:50	when the payment is reactivated all the detail lines will be removed, so this issue will be fixed with spreadsheet's task 633

(0026570) mirurita (developer) 2010-04-22 13:18	Fixed on org.openbravo.advpaymentmngt revision 171:7e15411b4f29 https://code.openbravo.com/erp/pmods/org.openbravo.advpaymentmngt/rev/7e15411b4f29 [^]

(0026748) sureshbabu (reporter) 2010-04-28 11:14	Tested working fine

Issue History
Date Modified	Username	Field	Change
2010-03-26 07:49	sureshbabu	New Issue
2010-03-26 07:49	sureshbabu	File Added: Make payment is reactivated and addd one more invoice document.JPG
2010-03-26 08:01	sureshbabu	Tag Attached: Advance Rec & Payables
2010-03-26 08:01	sureshbabu	Assigned To	=> gorkaion
2010-04-13 11:50	gorkaion	Status	new => scheduled
2010-04-13 11:50	gorkaion	Note Added: 0026121
2010-04-13 11:50	gorkaion	Assigned To	gorkaion => mirurita
2010-04-13 11:50	gorkaion	fix_in_branch	=> pi
2010-04-22 13:18	mirurita	Note Added: 0026570
2010-04-22 13:18	mirurita	Status	scheduled => resolved
2010-04-22 13:18	mirurita	Resolution	open => fixed
2010-04-28 11:14	sureshbabu	Note Added: 0026748
2010-04-28 11:14	sureshbabu	Status	resolved => closed
2010-04-28 11:14	sureshbabu	Fixed in Version	=> 2.50
2010-12-09 16:00	anonymous	sf_bug_id	0 => 3133086