Menu

#1492 Unallocated payment report omits partially unallocated

Report
closed-remind
9
2010-03-30
2008-09-04
No

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;

Discussion

  • Colin Rooney

    Colin Rooney - 2008-09-04

    Logged In: YES
    user_id=1238223
    Originator: NO

    sounds good to me +1.

    colin

     
  • Armen Rizal (Goodwill)

    It's ok for me.

    Armen

     
  • Carlos Ruiz

    Carlos Ruiz - 2010-03-10

    Showing wrong (incomplete) data to the user.

    Regards,

    Carlos Ruiz

     
  • Carlos Ruiz

    Carlos Ruiz - 2010-03-10
    • milestone: 866265 --> Report
    • priority: 5 --> 9
    • status: open --> open-remind
     
  • Carlos Ruiz

    Carlos Ruiz - 2010-03-11
    • assigned_to: nobody --> phib
     
  • Carlos Ruiz

    Carlos Ruiz - 2010-03-11

    fix wrong directory and script name with revisions 11640 and 11641

     
  • Carlos Ruiz

    Carlos Ruiz - 2010-03-15

    arrived to /release with revision 11665

     
  • Carlos Ruiz

    Carlos Ruiz - 2010-03-15
    • status: open-remind --> pending-remind
     
  • SourceForge Robot

    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).

     
  • SourceForge Robot

    • status: pending-remind --> closed-remind
     

Log in to post a comment.