projekt kivitendo

    $acc_cash_where =

      qq| AND (ac.trans_id IN (

            SELECT id

            FROM ar

            WHERE datepaid >= '$form->{fromdate}'

              AND datepaid <= '$form->{todate}'

            UNION

            SELECT id

            FROM ap

            WHERE datepaid >= '$form->{fromdate}'

              AND datepaid <= '$form->{todate}'

            UNION

            SELECT id

            FROM gl

            WHERE transdate >= '$form->{fromdate}'

              AND transdate <= '$form->{todate}'

          )) |;