Full syntax is (you asked for it)

SELECT c.store_no, b.store_name, c.entry_date_time, c.transaction_no, a.reference_no, SUM(a.gross_line_amount - a.pos_discount_amount)*a.db_cr_none) as SUM1,a.line_object, SUM(a.gross_line_amount * a.db_cr_none) as SUM2, a.line_action
FROM AUDITWORKS.sv_av_transaction_line a, AUDITWORKS.sv_store b,
AUDITWORKS.sv_av_transaction_header c
WHERE c.transaction_id=a.transaction_id
AND c.store_no=b.store_no
AND c.transaction_date >= '17/09/02')
AND 1=1
AND a.line_action not in 246
GROUP BY c.store_no,b.store_name,c.transaction_date,c.entry_date_time,c.transaction_no,a.reference_no,a.line_ object,a.line_action

I want to add the condtions I described inthe first post to this above syntax.