Hi shan you just wanna confirm with you is is the possible that invoice status will be null ? select invoice_status,at_date, at_type, * from txn_invoice_history_header_at a where invoice_no= 'IN24/007592' order by a.at_date desc - Muhammed Azhar Mohamed Maideen, 09/05/2024 04:21 PM