try
INSERT INTO m_temp
(
cust_id,
invoice_no,
invoice_dt,
unique_id,
po_no,
wo_no,
g_amount,
status,
icode,
isrno,
iqty,
irate,
iamount
)SELECT
t0.cust_id AS cust_id,
t0.invoice_no AS invoice_no,
t0.invoice_dt AS invoice_dt,
t0.padi_no AS unique_id,
t0.po_no AS po_no,
t0.wo_no AS wo_no,
(t0.balance + t0.advance) AS g_amount,
t0.status AS status,
t1.icode AS icode,
t1.srno AS isrno,
t1.qty AS iqty,
t1.rate_per_unit AS irate,
t1.amount AS iamount
FROM
salesinvoice t0 INNER JOIN
padi_det t1 ON t0.padi_no = t1.padi_no INNER JOIN
padi_mast t2 ON t1.padi_no = t2.padi_no
WHERE t0.cust_id = '" & FindCusCode & "' AND t0.status <> 'C'"