INSERT INTO FIRM_ADDLESS_DETAIL SELECT BillNo, 'SALE BILL',1,'DISCOUNT',0,'-','%','YES','G','NO','', GrossAmt-NetAmt FROM BILL_DETAIL WHERE NetAmt-GrossAmt<0
INSERT INTO FIRM_ADDLESS_DETAIL SELECT SrNo, 'GREY PURCHASE',1,'DISCOUNT',0,'-','%','YES','G','NO','', GrossAmt-NetAmt FROM GREY_PURCHASE WHERE NetAmt-GrossAmt<0
INSERT INTO FIRM_ADDLESS_DETAIL SELECT SrNo, 'FINISHED PURCHASE',1,'DISCOUNT',0,'-','%','YES','G','NO','', GrossAmt-NetAmt FROM FINISHED_PURCHASE WHERE NetAmt-GrossAmt<0

INSERT INTO FIRM_ADDLESS_DETAIL SELECT BillNo, 'SALE BILL',1,'ADD AMOUNT',0,'+','%','YES','G','NO','', NetAmt-GrossAmt FROM BILL_DETAIL WHERE NetAmt-GrossAmt>0
INSERT INTO FIRM_ADDLESS_DETAIL SELECT SrNo, 'GREY PURCHASE',1,'ADD AMOUNT',0,'+','%','YES','G','NO','', NetAmt-GrossAmt FROM GREY_PURCHASE WHERE NetAmt-GrossAmt>0
INSERT INTO FIRM_ADDLESS_DETAIL SELECT SrNo, 'FINISHED PURCHASE',1,'ADD AMOUNT',0,'+','%','YES','G','NO','', NetAmt-GrossAmt FROM FINISHED_PURCHASE WHERE NetAmt-GrossAmt>0