INSERT INTO `tbl_acc_details`(`_date`, `description`, `cheque_no`, `payee`, `amount`, `type`, `tag_id`, `account_id`, `transaction_id`, `event`, `is_send`, `account_code`, `location_id`, `cheque_date`, `sent_on`, `log_id`, `created_on`,transaction_code)
select 

date(si.created_on) as _date
,'by api - ' as description
,'' as cheque_no
,c.customer_name as payee
,si.total_discount as amount
,'CR' as `type`
,0 as tag_id
, ( case 
		when ifnull(fa.account,0) > 0 then ifnull(fa.account,'')
        else 240 end 
	) as account_id   
,si.id as transaction_id
,'Sales_cancel' as `event`
,0 as is_send
,( case 
		when ifnull(fa.account,0) > 0 then ifnull(fa.name,'')
        else 'Customers Discount' end 
	) as account_code
,bil.fn_companyCode as location_id  
,now() as cheque_date
,now() as sent_on
,'' as log_id
,now() as created_on
,si.code as transaction_code

from tbl_sale_invoice si 
inner join tbl_branch_inventory_locations bil on bil.id = si.location_id
inner join tbl_customers c on c.customer_id = si.customer_id 
left join tbl_fn_discount_accounts fa on fa.rate = si.discount_rate
where si.total_discount > 0
and si.id = ?

