SELECT FormName AS F1, SrNo AS F2, BillNo AS F3, '' AS F4 FROM SCAN_BALANCE_SHEET WHERE (FormName = 'JVM') AND (Status <> 'GREYPUR-BILL') AND (Status <> 'FINPUR-BILL') AND (Status <> 'SALE-BILL') AND (Status <> 'JOB-BILL') AND (Status <> 'GP-BILL') AND (Status <> 'GNPUR-BILL') AND (Status <> 'SALERTN-BILL') AND (Status <> 'GREYRTN-BILL') AND (Status <> 'FINRTN-BILL') AND ((SrNo + ':' + BillNo) IN (SELECT MULTI_JOURNAL_ADDLESS_DETAIL.BkSrNo + ':' + MULTI_JOURNAL_ADDLESS_DETAIL.BkBillNo AS F1 FROM MULTI_JOURNAL_DETAIL INNER JOIN ACCOUNT_MASTER ON MULTI_JOURNAL_DETAIL.BkAccCode = ACCOUNT_MASTER.AccCode INNER JOIN ACCOUNT_TYPES ON ACCOUNT_MASTER.AccType = ACCOUNT_TYPES.AccTypes INNER JOIN MULTI_JOURNAL_ADDLESS_DETAIL ON MULTI_JOURNAL_DETAIL.BkSrNo = MULTI_JOURNAL_ADDLESS_DETAIL.BkSrNo WHERE ((JVType = 'CREDIT NOTE ON SALE') OR (JVType = 'DEBIT NOTE ON SALE')) AND (ACCOUNT_TYPES.FinalApplicable = 'SALE'))) AND (BillNo <> '')