The "Unallocated payments" report is based on report view: "C_Payment_v UnAllocated" which has the where clause:
"NOT EXISTS (SELECT * FROM C_AllocationLine al WHERE al.C_Payment_ID=C_Payment_v.C_Payment_ID) AND DocStatus IN ('CO','CL') AND COALESCE(C_Charge_ID,0)=0"
This causes any payment with an associated allocation to be filtered out -- even if the allocation is only for part of the total payment value. So partially unallocated payments don't show up.
I think the where clause should simply be:
"DocStatus IN ('CO','CL') AND IsAllocated='N'"
The isAllocated flag is set when the payment is fully allocated or if the payment is to a charge.
(Historic bugs may have resulted in this flag not being properly set in the past. If this is the case the bad data should be fixed anyway.)
Any objections? Thoughts?
SQL script:
UPDATE AD_ReportView SET WHERECLAUSE = 'DocStatus IN (''CO'',''CL'') AND IsAllocated=''N''' where ad_reportview_id=155;
Logged In: YES
user_id=1238223
Originator: NO
sounds good to me +1.
colin
It's ok for me.
Armen
Showing wrong (incomplete) data to the user.
Regards,
Carlos Ruiz
Trunk
Revision: 11636
http://adempiere.svn.sourceforge.net/adempiere/?rev=11636&view=rev
Author: phib
Date: 2010-03-10 21:49:48 +0000 (Wed, 10 Mar 2010)
fix wrong directory and script name with revisions 11640 and 11641
arrived to /release with revision 11665
This Tracker item was closed automatically by the system. It was
previously set to a Pending status, and the original submitter
did not respond within 14 days (the time period specified by
the administrator of this Tracker).