View | Details | Raw Unified | Return to bug 29664
Collapse All | Expand All

(-)a/reports/cash_register_stats.pl (-1 / +6 lines)
Lines 111-116 if ($do_it) { Link Here
111
        LEFT JOIN account_credit_types act ON (al.credit_type_code = act.code)
111
        LEFT JOIN account_credit_types act ON (al.credit_type_code = act.code)
112
        LEFT JOIN account_debit_types adt ON (al.debit_type_code = adt.code)
112
        LEFT JOIN account_debit_types adt ON (al.debit_type_code = adt.code)
113
        WHERE CAST(al.date AS DATE) BETWEEN ? AND ?
113
        WHERE CAST(al.date AS DATE) BETWEEN ? AND ?
114
        AND al.borrowernumber NOT in (
115
        SELECT borrowernumber
116
        FROM accountlines
117
        WHERE debit_type_code = 'VOID'
118
        WHERE credit_type_code = 'VOID'
119
        )
114
        $whereTType
120
        $whereTType
115
        $whereBranchCode
121
        $whereBranchCode
116
        $whereRegister
122
        $whereRegister
117
- 

Return to bug 29664