SELECT  Panel_Code,Company_Name,MaxExpiry,AvailAmt, IF((MaxExpiry<NOW() && AvailAmt>0),'Lock','UnLock') STATUS  FROM  (SELECT  fpm.`Panel_Code`,IF(FPM.`Payment_Mode`='Credit',1,0) Payment_Mode ,fpm.Panel_ID,FPM.`Company_Name`, IFNULL(MaxExpiry,'2017-01-01') MaxExpiry,   ROUND(IFNULL(BillingAmount,0)) - (IFNULL(imo.PaidAmount,0)) AvailAmt  FROM f_panel_master fpm  INNER JOIN(SELECT SUM(Adjustment) PaidAmount2,SUM(NetAmount) BillingAmount,SUM(GrossAmount)GrossAmount,SUM(DiscountOnTotal) DiscountOnTotal,lt.Panel_ID,lt.LedgertransactionNo   FROM f_ledgertransaction lt  WHERE IsCancel=0  AND DATE(lt.date)>='2017-10-01'  GROUP BY lt.`Panel_ID`) lt ON lt.Panel_ID=fpm.Panel_ID   AND fpm.Payment_mode='Credit'    LEFT JOIN ( SELECT SUM(ino.ReceivedAmt) PaidAmount,ino.Panel_ID FROM invoicemaster_onaccount ino WHERE  IsCancel=0 AND ino.ReceivedDate>='2017-10-01' AND IFNULL(InvoiceNo,'')='' GROUP BY ino.Panel_ID) imo     ON imo.Panel_ID=fpm.Panel_ID  UNION ALL  SELECT fpm.`Panel_Code`,payment_mode, fpm.Panel_ID , CONCAT(fpm.`Company_Name`,'(',fpm.Panel_Code,')')Company_Name, IFNULL(MaxExpiry,'2017-01-01') MaxExpiry ,ROUND( IFNULL(BillingAmount,0)) - (IFNULL(lt.PaidAmount2,0)) AvailAmt   FROM f_panel_master fpm     INNER JOIN(SELECT SUM(Adjustment) PaidAmount2,SUM(NetAmount) BillingAmount, SUM(GrossAmount)GrossAmount,SUM(DiscountOnTotal) DiscountOnTotal,lt.Panel_ID,lt.LedgertransactionNo   FROM f_ledgertransaction lt    WHERE  IsCancel=0  AND DATE(lt.date)>='2017-10-01'    GROUP BY lt.`Panel_ID`) lt ON lt.Panel_ID=fpm.Panel_ID  AND fpm.Payment_mode='Cash' )t ORDER BY Panel_code SELECT  Panel_Code,Company_Name,MaxExpiry,AvailAmt, IF((MaxExpiry<NOW() && AvailAmt>0),'Lock','UnLock') STATUS  FROM  (SELECT  fpm.`Panel_Code`,IF(FPM.`Payment_Mode`='Credit',1,0) Payment_Mode ,fpm.Panel_ID,FPM.`Company_Name`, IFNULL(MaxExpiry,'2017-01-01') MaxExpiry,   ROUND(IFNULL(BillingAmount,0)) - (IFNULL(imo.PaidAmount,0)) AvailAmt  FROM f_panel_master fpm  INNER JOIN(SELECT SUM(Adjustment) PaidAmount2,SUM(NetAmount) BillingAmount,SUM(GrossAmount)GrossAmount,SUM(DiscountOnTotal) DiscountOnTotal,lt.Panel_ID,lt.LedgertransactionNo   FROM f_ledgertransaction lt  WHERE IsCancel=0  AND DATE(lt.date)>='2017-10-01'  GROUP BY lt.`Panel_ID`) lt ON lt.Panel_ID=fpm.Panel_ID   AND fpm.Payment_mode='Credit'    LEFT JOIN ( SELECT SUM(ino.ReceivedAmt) PaidAmount,ino.Panel_ID FROM invoicemaster_onaccount ino WHERE  IsCancel=0 AND ino.ReceivedDate>='2017-10-01' AND IFNULL(InvoiceNo,'')='' GROUP BY ino.Panel_ID) imo     ON imo.Panel_ID=fpm.Panel_ID  UNION ALL  SELECT fpm.`Panel_Code`,payment_mode, fpm.Panel_ID , CONCAT(fpm.`Company_Name`,'(',fpm.Panel_Code,')')Company_Name, IFNULL(MaxExpiry,'2017-01-01') MaxExpiry ,ROUND( IFNULL(BillingAmount,0)) - (IFNULL(lt.PaidAmount2,0)) AvailAmt   FROM f_panel_master fpm     INNER JOIN(SELECT SUM(Adjustment) PaidAmount2,SUM(NetAmount) BillingAmount, SUM(GrossAmount)GrossAmount,SUM(DiscountOnTotal) DiscountOnTotal,lt.Panel_ID,lt.LedgertransactionNo   FROM f_ledgertransaction lt    WHERE  IsCancel=0  AND DATE(lt.date)>='2017-10-01'    GROUP BY lt.`Panel_ID`) lt ON lt.Panel_ID=fpm.Panel_ID  AND fpm.Payment_mode='Cash' )t ORDER BY Panel_code SELECT  Panel_Code,Company_Name,MaxExpiry,AvailAmt, IF((MaxExpiry<NOW() && AvailAmt>0),'Lock','UnLock') STATUS  FROM  (SELECT  fpm.`Panel_Code`,IF(FPM.`Payment_Mode`='Credit',1,0) Payment_Mode ,fpm.Panel_ID,FPM.`Company_Name`, IFNULL(MaxExpiry,'2017-01-01') MaxExpiry,   (IFNULL(imo.PaidAmount,0)) - (ROUND(IFNULL(BillingAmount,0))+ROUND(IFNULL(BillingAmount2,0))) AvailAmt  FROM f_panel_master fpm INNER JOIN (  SELECT PanelID, SUM(netamount) BillingAmount2 FROM invoicemaster WHERE  iscancel=0   GROUP BY PanelID  ) t2  ON t2.PanelID=fpm.Panel_ID   AND fpm.Payment_mode='Credit'    INNER JOIN(SELECT SUM(Adjustment) PaidAmount2,SUM(NetAmount) BillingAmount,SUM(GrossAmount)GrossAmount,SUM(DiscountOnTotal) DiscountOnTotal,lt.Panel_ID,lt.LedgertransactionNo   FROM f_ledgertransaction lt  WHERE IsCancel=0  AND DATE(lt.date)>='2017-10-01' AND IFNULL(lt.InvoiceNo,'')=''  GROUP BY lt.`Panel_ID`) lt ON lt.Panel_ID=fpm.Panel_ID   AND fpm.Payment_mode='Credit'    LEFT JOIN ( SELECT SUM(ino.ReceivedAmt) PaidAmount,ino.Panel_ID FROM invoicemaster_onaccount ino WHERE  IsCancel=0 AND ino.ReceivedDate>='2017-10-01' AND IFNULL(InvoiceNo,'')='' GROUP BY ino.Panel_ID) imo     ON imo.Panel_ID=fpm.Panel_ID  UNION ALL  SELECT fpm.`Panel_Code`,payment_mode, fpm.Panel_ID , CONCAT(fpm.`Company_Name`,'(',fpm.Panel_Code,')')Company_Name, IFNULL(MaxExpiry,'2017-01-01') MaxExpiry ,ROUND( IFNULL(BillingAmount,0)) - (IFNULL(lt.PaidAmount2,0)) AvailAmt   FROM f_panel_master fpm     INNER JOIN(SELECT SUM(Adjustment) PaidAmount2,SUM(NetAmount) BillingAmount, SUM(GrossAmount)GrossAmount,SUM(DiscountOnTotal) DiscountOnTotal,lt.Panel_ID,lt.LedgertransactionNo   FROM f_ledgertransaction lt    WHERE  IsCancel=0  AND DATE(lt.date)>='2017-10-01'    GROUP BY lt.`Panel_ID`) lt ON lt.Panel_ID=fpm.Panel_ID  AND fpm.Payment_mode='Cash' )t ORDER BY Panel_code SELECT  Panel_Code,Company_Name,MaxExpiry,AvailAmt, IF((MaxExpiry<NOW() && AvailAmt>0),'Lock','UnLock') STATUS  FROM  (SELECT  fpm.`Panel_Code`,IF(FPM.`Payment_Mode`='Credit',1,0) Payment_Mode ,fpm.Panel_ID,FPM.`Company_Name`, IFNULL(MaxExpiry,'2017-01-01') MaxExpiry,   (IFNULL(imo.PaidAmount,0)) - (ROUND(IFNULL(BillingAmount,0))+ROUND(IFNULL(BillingAmount2,0))) AvailAmt  FROM f_panel_master fpm INNER JOIN (  SELECT PanelID, SUM(netamount) BillingAmount2 FROM invoicemaster WHERE  iscancel=0   GROUP BY PanelID  ) t2  ON t2.PanelID=fpm.Panel_ID   AND fpm.Payment_mode='Credit'    INNER JOIN(SELECT SUM(Adjustment) PaidAmount2,SUM(NetAmount) BillingAmount,SUM(GrossAmount)GrossAmount,SUM(DiscountOnTotal) DiscountOnTotal,lt.Panel_ID,lt.LedgertransactionNo   FROM f_ledgertransaction lt  WHERE IsCancel=0  AND DATE(lt.date)>='2017-10-01' AND IFNULL(lt.InvoiceNo,'')=''  GROUP BY lt.`Panel_ID`) lt ON lt.Panel_ID=fpm.Panel_ID   AND fpm.Payment_mode='Credit'    LEFT JOIN ( SELECT SUM(ino.ReceivedAmt) PaidAmount,ino.Panel_ID FROM invoicemaster_onaccount ino WHERE  IsCancel=0 AND ino.ReceivedDate>='2017-10-01' AND IFNULL(InvoiceNo,'')='' GROUP BY ino.Panel_ID) imo     ON imo.Panel_ID=fpm.Panel_ID  UNION ALL  SELECT fpm.`Panel_Code`,payment_mode, fpm.Panel_ID , CONCAT(fpm.`Company_Name`,'(',fpm.Panel_Code,')')Company_Name, IFNULL(MaxExpiry,'2017-01-01') MaxExpiry ,ROUND( IFNULL(BillingAmount,0)) - (IFNULL(lt.PaidAmount2,0)) AvailAmt   FROM f_panel_master fpm     INNER JOIN(SELECT SUM(Adjustment) PaidAmount2,SUM(NetAmount) BillingAmount, SUM(GrossAmount)GrossAmount,SUM(DiscountOnTotal) DiscountOnTotal,lt.Panel_ID,lt.LedgertransactionNo   FROM f_ledgertransaction lt    WHERE  IsCancel=0  AND DATE(lt.date)>='2017-10-01'    GROUP BY lt.`Panel_ID`) lt ON lt.Panel_ID=fpm.Panel_ID  AND fpm.Payment_mode='Cash' )t ORDER BY Panel_code SELECT  Panel_Code,Company_Name,MaxExpiry,AvailAmt, IF((MaxExpiry<NOW() && AvailAmt>0),'Lock','UnLock') STATUS  FROM  (SELECT  fpm.`Panel_Code`,IF(FPM.`Payment_Mode`='Credit',1,0) Payment_Mode ,fpm.Panel_ID,FPM.`Company_Name`, IFNULL(MaxExpiry,'2017-01-01') MaxExpiry,   (IFNULL(imo.PaidAmount,0)) - (ROUND(IFNULL(BillingAmount,0))+ROUND(IFNULL(BillingAmount2,0))) AvailAmt  FROM f_panel_master fpm INNER JOIN (  SELECT PanelID, SUM(netamount) BillingAmount2 FROM invoicemaster WHERE  iscancel=0   GROUP BY PanelID  ) t2  ON t2.PanelID=fpm.Panel_ID   AND fpm.Payment_mode='Credit'    INNER JOIN(SELECT SUM(Adjustment) PaidAmount2,SUM(NetAmount) BillingAmount,SUM(GrossAmount)GrossAmount,SUM(DiscountOnTotal) DiscountOnTotal,lt.Panel_ID,lt.LedgertransactionNo   FROM f_ledgertransaction lt  WHERE IsCancel=0  AND DATE(lt.date)>='2017-10-01' AND IFNULL(lt.InvoiceNo,'')=''  GROUP BY lt.`Panel_ID`) lt ON lt.Panel_ID=fpm.Panel_ID   AND fpm.Payment_mode='Credit'    LEFT JOIN ( SELECT SUM(ino.ReceivedAmt) PaidAmount,ino.Panel_ID FROM invoicemaster_onaccount ino WHERE  IsCancel=0 AND ino.ReceivedDate>='2017-10-01' AND IFNULL(InvoiceNo,'')='' GROUP BY ino.Panel_ID) imo     ON imo.Panel_ID=fpm.Panel_ID  UNION ALL  SELECT fpm.`Panel_Code`,payment_mode, fpm.Panel_ID , CONCAT(fpm.`Company_Name`,'(',fpm.Panel_Code,')')Company_Name, IFNULL(MaxExpiry,'2017-01-01') MaxExpiry ,ROUND( IFNULL(BillingAmount,0)) - (IFNULL(lt.PaidAmount2,0)) AvailAmt   FROM f_panel_master fpm     INNER JOIN(SELECT SUM(Adjustment) PaidAmount2,SUM(NetAmount) BillingAmount, SUM(GrossAmount)GrossAmount,SUM(DiscountOnTotal) DiscountOnTotal,lt.Panel_ID,lt.LedgertransactionNo   FROM f_ledgertransaction lt    WHERE  IsCancel=0  AND DATE(lt.date)>='2017-10-01'    GROUP BY lt.`Panel_ID`) lt ON lt.Panel_ID=fpm.Panel_ID  AND fpm.Payment_mode='Cash' )t ORDER BY Panel_code SELECT  Panel_Code,Company_Name,MaxExpiry,AvailAmt, IF((MaxExpiry<NOW() && AvailAmt>0),'Lock','UnLock') STATUS  FROM  (SELECT  fpm.`Panel_Code`,IF(FPM.`Payment_Mode`='Credit',1,0) Payment_Mode ,fpm.Panel_ID,FPM.`Company_Name`, IFNULL(MaxExpiry,'2017-01-01') MaxExpiry,   (IFNULL(imo.PaidAmount,0)) - (ROUND(IFNULL(BillingAmount,0))+ROUND(IFNULL(BillingAmount2,0))) AvailAmt  FROM f_panel_master fpm INNER JOIN (  SELECT PanelID, SUM(netamount) BillingAmount2 FROM invoicemaster WHERE  iscancel=0   GROUP BY PanelID  ) t2  ON t2.PanelID=fpm.Panel_ID   AND fpm.Payment_mode='Credit'    INNER JOIN(SELECT SUM(Adjustment) PaidAmount2,SUM(NetAmount) BillingAmount,SUM(GrossAmount)GrossAmount,SUM(DiscountOnTotal) DiscountOnTotal,lt.Panel_ID,lt.LedgertransactionNo   FROM f_ledgertransaction lt  WHERE IsCancel=0  AND DATE(lt.date)>='2017-10-01' AND IFNULL(lt.InvoiceNo,'')=''  GROUP BY lt.`Panel_ID`) lt ON lt.Panel_ID=fpm.Panel_ID   AND fpm.Payment_mode='Credit'    LEFT JOIN ( SELECT SUM(ino.ReceivedAmt) PaidAmount,ino.Panel_ID FROM invoicemaster_onaccount ino WHERE  IsCancel=0 AND ino.ReceivedDate>='2017-10-01' AND IFNULL(InvoiceNo,'')='' GROUP BY ino.Panel_ID) imo     ON imo.Panel_ID=fpm.Panel_ID  UNION ALL  SELECT fpm.`Panel_Code`,payment_mode, fpm.Panel_ID , CONCAT(fpm.`Company_Name`,'(',fpm.Panel_Code,')')Company_Name, IFNULL(MaxExpiry,'2017-01-01') MaxExpiry ,ROUND( IFNULL(BillingAmount,0)) - (IFNULL(lt.PaidAmount2,0)) AvailAmt   FROM f_panel_master fpm     INNER JOIN(SELECT SUM(Adjustment) PaidAmount2,SUM(NetAmount) BillingAmount, SUM(GrossAmount)GrossAmount,SUM(DiscountOnTotal) DiscountOnTotal,lt.Panel_ID,lt.LedgertransactionNo   FROM f_ledgertransaction lt    WHERE  IsCancel=0  AND DATE(lt.date)>='2017-10-01'    GROUP BY lt.`Panel_ID`) lt ON lt.Panel_ID=fpm.Panel_ID  AND fpm.Payment_mode='Cash' )t ORDER BY Panel_code SELECT  Panel_Code,Company_Name,MaxExpiry,AvailAmt, IF((MaxExpiry<NOW() && AvailAmt>0),'Lock','UnLock') STATUS  FROM  (SELECT  fpm.`Panel_Code`,IF(FPM.`Payment_Mode`='Credit',1,0) Payment_Mode ,fpm.Panel_ID,FPM.`Company_Name`, IFNULL(MaxExpiry,'2017-01-01') MaxExpiry,   (IFNULL(imo.PaidAmount,0)) - (ROUND(IFNULL(BillingAmount,0))+ROUND(IFNULL(BillingAmount2,0))) AvailAmt  FROM f_panel_master fpm INNER JOIN (  SELECT PanelID, SUM(netamount) BillingAmount2 FROM invoicemaster WHERE  iscancel=0   GROUP BY PanelID  ) t2  ON t2.PanelID=fpm.Panel_ID   AND fpm.Payment_mode='Credit'    INNER JOIN(SELECT SUM(Adjustment) PaidAmount2,SUM(NetAmount) BillingAmount,SUM(GrossAmount)GrossAmount,SUM(DiscountOnTotal) DiscountOnTotal,lt.Panel_ID,lt.LedgertransactionNo   FROM f_ledgertransaction lt  WHERE IsCancel=0  AND DATE(lt.date)>='2017-10-01' AND IFNULL(lt.InvoiceNo,'')=''  GROUP BY lt.`Panel_ID`) lt ON lt.Panel_ID=fpm.Panel_ID   AND fpm.Payment_mode='Credit'    LEFT JOIN ( SELECT SUM(ino.ReceivedAmt) PaidAmount,ino.Panel_ID FROM invoicemaster_onaccount ino WHERE  IsCancel=0 AND ino.ReceivedDate>='2017-10-01' AND IFNULL(InvoiceNo,'')='' GROUP BY ino.Panel_ID) imo     ON imo.Panel_ID=fpm.Panel_ID  UNION ALL  SELECT fpm.`Panel_Code`,payment_mode, fpm.Panel_ID , CONCAT(fpm.`Company_Name`,'(',fpm.Panel_Code,')')Company_Name, IFNULL(MaxExpiry,'2017-01-01') MaxExpiry ,ROUND( IFNULL(BillingAmount,0)) - (IFNULL(lt.PaidAmount2,0)) AvailAmt   FROM f_panel_master fpm     INNER JOIN(SELECT SUM(Adjustment) PaidAmount2,SUM(NetAmount) BillingAmount, SUM(GrossAmount)GrossAmount,SUM(DiscountOnTotal) DiscountOnTotal,lt.Panel_ID,lt.LedgertransactionNo   FROM f_ledgertransaction lt    WHERE  IsCancel=0  AND DATE(lt.date)>='2017-10-01'    GROUP BY lt.`Panel_ID`) lt ON lt.Panel_ID=fpm.Panel_ID  AND fpm.Payment_mode='Cash' )t ORDER BY Panel_code SELECT  Panel_Code,Company_Name,MaxExpiry,AvailAmt, IF((MaxExpiry<NOW() && AvailAmt>0),'Lock','UnLock') STATUS  FROM  (SELECT  fpm.`Panel_Code`,IF(FPM.`Payment_Mode`='Credit',1,0) Payment_Mode ,fpm.Panel_ID,FPM.`Company_Name`, IFNULL(MaxExpiry,'2017-01-01') MaxExpiry,   (IFNULL(imo.PaidAmount,0)) - (ROUND(IFNULL(BillingAmount,0))+ROUND(IFNULL(BillingAmount2,0))) AvailAmt  FROM f_panel_master fpm INNER JOIN (  SELECT PanelID, SUM(netamount) BillingAmount2 FROM invoicemaster WHERE  iscancel=0   GROUP BY PanelID  ) t2  ON t2.PanelID=fpm.Panel_ID   AND fpm.Payment_mode='Credit'    INNER JOIN(SELECT SUM(Adjustment) PaidAmount2,SUM(NetAmount) BillingAmount,SUM(GrossAmount)GrossAmount,SUM(DiscountOnTotal) DiscountOnTotal,lt.Panel_ID,lt.LedgertransactionNo   FROM f_ledgertransaction lt  WHERE IsCancel=0  AND DATE(lt.date)>='2017-10-01' AND IFNULL(lt.InvoiceNo,'')=''  GROUP BY lt.`Panel_ID`) lt ON lt.Panel_ID=fpm.Panel_ID   AND fpm.Payment_mode='Credit'    LEFT JOIN ( SELECT SUM(ino.ReceivedAmt) PaidAmount,ino.Panel_ID FROM invoicemaster_onaccount ino WHERE  IsCancel=0 AND ino.ReceivedDate>='2017-10-01' AND IFNULL(InvoiceNo,'')='' GROUP BY ino.Panel_ID) imo     ON imo.Panel_ID=fpm.Panel_ID  UNION ALL  SELECT fpm.`Panel_Code`,payment_mode, fpm.Panel_ID , CONCAT(fpm.`Company_Name`,'(',fpm.Panel_Code,')')Company_Name, IFNULL(MaxExpiry,'2017-01-01') MaxExpiry ,ROUND( IFNULL(BillingAmount,0)) - (IFNULL(lt.PaidAmount2,0)) AvailAmt   FROM f_panel_master fpm     INNER JOIN(SELECT SUM(Adjustment) PaidAmount2,SUM(NetAmount) BillingAmount, SUM(GrossAmount)GrossAmount,SUM(DiscountOnTotal) DiscountOnTotal,lt.Panel_ID,lt.LedgertransactionNo   FROM f_ledgertransaction lt    WHERE  IsCancel=0  AND DATE(lt.date)>='2017-10-01'    GROUP BY lt.`Panel_ID`) lt ON lt.Panel_ID=fpm.Panel_ID  AND fpm.Payment_mode='Cash' )t ORDER BY Panel_code SELECT  Panel_Code,Company_Name,MaxExpiry,AvailAmt, IF((MaxExpiry<NOW() && AvailAmt>0),'Lock','UnLock') STATUS  FROM  (SELECT  fpm.`Panel_Code`,IF(FPM.`Payment_Mode`='Credit',1,0) Payment_Mode ,fpm.Panel_ID,FPM.`Company_Name`, IFNULL(MaxExpiry,'2017-01-01') MaxExpiry,   (IFNULL(imo.PaidAmount,0)) - (ROUND(IFNULL(BillingAmount,0))+ROUND(IFNULL(BillingAmount2,0))) AvailAmt  FROM f_panel_master fpm INNER JOIN (  SELECT PanelID, SUM(netamount) BillingAmount2 FROM invoicemaster WHERE  iscancel=0   GROUP BY PanelID  ) t2  ON t2.PanelID=fpm.Panel_ID   AND fpm.Payment_mode='Credit'    INNER JOIN(SELECT SUM(Adjustment) PaidAmount2,SUM(NetAmount) BillingAmount,SUM(GrossAmount)GrossAmount,SUM(DiscountOnTotal) DiscountOnTotal,lt.Panel_ID,lt.LedgertransactionNo   FROM f_ledgertransaction lt  WHERE IsCancel=0  AND DATE(lt.date)>='2017-10-01' AND IFNULL(lt.InvoiceNo,'')=''  GROUP BY lt.`Panel_ID`) lt ON lt.Panel_ID=fpm.Panel_ID   AND fpm.Payment_mode='Credit'    LEFT JOIN ( SELECT SUM(ino.ReceivedAmt) PaidAmount,ino.Panel_ID FROM invoicemaster_onaccount ino WHERE  IsCancel=0 AND ino.ReceivedDate>='2017-10-01' AND IFNULL(InvoiceNo,'')='' GROUP BY ino.Panel_ID) imo     ON imo.Panel_ID=fpm.Panel_ID  UNION ALL  SELECT fpm.`Panel_Code`,payment_mode, fpm.Panel_ID , CONCAT(fpm.`Company_Name`,'(',fpm.Panel_Code,')')Company_Name, IFNULL(MaxExpiry,'2017-01-01') MaxExpiry ,ROUND( IFNULL(BillingAmount,0)) - (IFNULL(lt.PaidAmount2,0)) AvailAmt   FROM f_panel_master fpm     INNER JOIN(SELECT SUM(Adjustment) PaidAmount2,SUM(NetAmount) BillingAmount, SUM(GrossAmount)GrossAmount,SUM(DiscountOnTotal) DiscountOnTotal,lt.Panel_ID,lt.LedgertransactionNo   FROM f_ledgertransaction lt    WHERE  IsCancel=0  AND DATE(lt.date)>='2017-10-01'    GROUP BY lt.`Panel_ID`) lt ON lt.Panel_ID=fpm.Panel_ID  AND fpm.Payment_mode='Cash' )t ORDER BY Panel_code SELECT  Panel_Code,Company_Name,MaxExpiry,AvailAmt, IF((MaxExpiry<NOW() && AvailAmt>0),'Lock','UnLock') STATUS  FROM  (SELECT  fpm.`Panel_Code`,IF(FPM.`Payment_Mode`='Credit',1,0) Payment_Mode ,fpm.Panel_ID,FPM.`Company_Name`, IFNULL(MaxExpiry,'2017-01-01') MaxExpiry,   (IFNULL(imo.PaidAmount,0)) - (ROUND(IFNULL(BillingAmount,0))+ROUND(IFNULL(BillingAmount2,0))) AvailAmt  FROM f_panel_master fpm INNER JOIN (  SELECT PanelID, SUM(netamount) BillingAmount2 FROM invoicemaster WHERE  iscancel=0   GROUP BY PanelID  ) t2  ON t2.PanelID=fpm.Panel_ID   AND fpm.Payment_mode='Credit'    INNER JOIN(SELECT SUM(Adjustment) PaidAmount2,SUM(NetAmount) BillingAmount,SUM(GrossAmount)GrossAmount,SUM(DiscountOnTotal) DiscountOnTotal,lt.Panel_ID,lt.LedgertransactionNo   FROM f_ledgertransaction lt  WHERE IsCancel=0  AND DATE(lt.date)>='2017-10-01' AND IFNULL(lt.InvoiceNo,'')=''  GROUP BY lt.`Panel_ID`) lt ON lt.Panel_ID=fpm.Panel_ID   AND fpm.Payment_mode='Credit'    LEFT JOIN ( SELECT SUM(ino.ReceivedAmt) PaidAmount,ino.Panel_ID FROM invoicemaster_onaccount ino WHERE  IsCancel=0 AND ino.ReceivedDate>='2017-10-01' AND IFNULL(InvoiceNo,'')='' GROUP BY ino.Panel_ID) imo     ON imo.Panel_ID=fpm.Panel_ID  UNION ALL  SELECT fpm.`Panel_Code`,payment_mode, fpm.Panel_ID , CONCAT(fpm.`Company_Name`,'(',fpm.Panel_Code,')')Company_Name, IFNULL(MaxExpiry,'2017-01-01') MaxExpiry ,ROUND( IFNULL(BillingAmount,0)) - (IFNULL(lt.PaidAmount2,0)) AvailAmt   FROM f_panel_master fpm     INNER JOIN(SELECT SUM(Adjustment) PaidAmount2,SUM(NetAmount) BillingAmount, SUM(GrossAmount)GrossAmount,SUM(DiscountOnTotal) DiscountOnTotal,lt.Panel_ID,lt.LedgertransactionNo   FROM f_ledgertransaction lt    WHERE  IsCancel=0  AND DATE(lt.date)>='2017-10-01'    GROUP BY lt.`Panel_ID`) lt ON lt.Panel_ID=fpm.Panel_ID  AND fpm.Payment_mode='Cash' )t ORDER BY Panel_code SELECT  Panel_Code,Company_Name,MaxExpiry,AvailAmt, IF((MaxExpiry<NOW() && AvailAmt>0),'Lock','UnLock') STATUS  FROM  (SELECT  fpm.`Panel_Code`,IF(FPM.`Payment_Mode`='Credit',1,0) Payment_Mode ,fpm.Panel_ID,FPM.`Company_Name`, IFNULL(MaxExpiry,'2017-01-01') MaxExpiry,   (IFNULL(imo.PaidAmount,0)) - (ROUND(IFNULL(BillingAmount,0))+ROUND(IFNULL(BillingAmount2,0))) AvailAmt  FROM f_panel_master fpm INNER JOIN (  SELECT PanelID, SUM(netamount) BillingAmount2 FROM invoicemaster WHERE  iscancel=0   GROUP BY PanelID  ) t2  ON t2.PanelID=fpm.Panel_ID   AND fpm.Payment_mode='Credit'    INNER JOIN(SELECT SUM(Adjustment) PaidAmount2,SUM(NetAmount) BillingAmount,SUM(GrossAmount)GrossAmount,SUM(DiscountOnTotal) DiscountOnTotal,lt.Panel_ID,lt.LedgertransactionNo   FROM f_ledgertransaction lt  WHERE IsCancel=0  AND DATE(lt.date)>='2017-10-01' AND IFNULL(lt.InvoiceNo,'')=''  GROUP BY lt.`Panel_ID`) lt ON lt.Panel_ID=fpm.Panel_ID   AND fpm.Payment_mode='Credit'    LEFT JOIN ( SELECT SUM(ino.ReceivedAmt) PaidAmount,ino.Panel_ID FROM invoicemaster_onaccount ino WHERE  IsCancel=0 AND ino.ReceivedDate>='2017-10-01' AND IFNULL(InvoiceNo,'')='' GROUP BY ino.Panel_ID) imo     ON imo.Panel_ID=fpm.Panel_ID  UNION ALL  SELECT fpm.`Panel_Code`,payment_mode, fpm.Panel_ID , CONCAT(fpm.`Company_Name`,'(',fpm.Panel_Code,')')Company_Name, IFNULL(MaxExpiry,'2017-01-01') MaxExpiry ,ROUND( IFNULL(BillingAmount,0)) - (IFNULL(lt.PaidAmount2,0)) AvailAmt   FROM f_panel_master fpm     INNER JOIN(SELECT SUM(Adjustment) PaidAmount2,SUM(NetAmount) BillingAmount, SUM(GrossAmount)GrossAmount,SUM(DiscountOnTotal) DiscountOnTotal,lt.Panel_ID,lt.LedgertransactionNo   FROM f_ledgertransaction lt    WHERE  IsCancel=0  AND DATE(lt.date)>='2017-10-01'    GROUP BY lt.`Panel_ID`) lt ON lt.Panel_ID=fpm.Panel_ID  AND fpm.Payment_mode='Cash' )t ORDER BY Panel_code SELECT  Panel_Code,Company_Name,MaxExpiry,AvailAmt, IF((MaxExpiry<NOW() && AvailAmt>0),'Lock','UnLock') STATUS  FROM  (SELECT  fpm.`Panel_Code`,IF(FPM.`Payment_Mode`='Credit',1,0) Payment_Mode ,fpm.Panel_ID,FPM.`Company_Name`, IFNULL(MaxExpiry,'2017-01-01') MaxExpiry,   (IFNULL(imo.PaidAmount,0)) - (ROUND(IFNULL(BillingAmount,0))+ROUND(IFNULL(BillingAmount2,0))) AvailAmt  FROM f_panel_master fpm INNER JOIN (  SELECT PanelID, SUM(netamount) BillingAmount2 FROM invoicemaster WHERE  iscancel=0   GROUP BY PanelID  ) t2  ON t2.PanelID=fpm.Panel_ID   AND fpm.Payment_mode='Credit'    INNER JOIN(SELECT SUM(Adjustment) PaidAmount2,SUM(NetAmount) BillingAmount,SUM(GrossAmount)GrossAmount,SUM(DiscountOnTotal) DiscountOnTotal,lt.Panel_ID,lt.LedgertransactionNo   FROM f_ledgertransaction lt  WHERE IsCancel=0  AND DATE(lt.date)>='2017-10-01' AND IFNULL(lt.InvoiceNo,'')=''  GROUP BY lt.`Panel_ID`) lt ON lt.Panel_ID=fpm.Panel_ID   AND fpm.Payment_mode='Credit'    LEFT JOIN ( SELECT SUM(ino.ReceivedAmt) PaidAmount,ino.Panel_ID FROM invoicemaster_onaccount ino WHERE  IsCancel=0 AND ino.ReceivedDate>='2017-10-01' AND IFNULL(InvoiceNo,'')='' GROUP BY ino.Panel_ID) imo     ON imo.Panel_ID=fpm.Panel_ID  UNION ALL  SELECT fpm.`Panel_Code`,payment_mode, fpm.Panel_ID , CONCAT(fpm.`Company_Name`,'(',fpm.Panel_Code,')')Company_Name, IFNULL(MaxExpiry,'2017-01-01') MaxExpiry ,ROUND( IFNULL(BillingAmount,0)) - (IFNULL(lt.PaidAmount2,0)) AvailAmt   FROM f_panel_master fpm     INNER JOIN(SELECT SUM(Adjustment) PaidAmount2,SUM(NetAmount) BillingAmount, SUM(GrossAmount)GrossAmount,SUM(DiscountOnTotal) DiscountOnTotal,lt.Panel_ID,lt.LedgertransactionNo   FROM f_ledgertransaction lt    WHERE  IsCancel=0  AND DATE(lt.date)>='2017-10-01'    GROUP BY lt.`Panel_ID`) lt ON lt.Panel_ID=fpm.Panel_ID  AND fpm.Payment_mode='Cash' )t ORDER BY Panel_code SELECT  Panel_Code,Company_Name,MaxExpiry,AvailAmt, IF((MaxExpiry<NOW() && AvailAmt>0),'Lock','UnLock') STATUS  FROM  (SELECT  fpm.`Panel_Code`,IF(FPM.`Payment_Mode`='Credit',1,0) Payment_Mode ,fpm.Panel_ID,FPM.`Company_Name`, IFNULL(MaxExpiry,'2017-01-01') MaxExpiry,   (IFNULL(imo.PaidAmount,0)) - (ROUND(IFNULL(BillingAmount,0))+ROUND(IFNULL(BillingAmount2,0))) AvailAmt  FROM f_panel_master fpm INNER JOIN (  SELECT PanelID, SUM(netamount) BillingAmount2 FROM invoicemaster WHERE  iscancel=0   GROUP BY PanelID  ) t2  ON t2.PanelID=fpm.Panel_ID   AND fpm.Payment_mode='Credit'    INNER JOIN(SELECT SUM(Adjustment) PaidAmount2,SUM(NetAmount) BillingAmount,SUM(GrossAmount)GrossAmount,SUM(DiscountOnTotal) DiscountOnTotal,lt.Panel_ID,lt.LedgertransactionNo   FROM f_ledgertransaction lt  WHERE IsCancel=0  AND DATE(lt.date)>='2017-10-01' AND IFNULL(lt.InvoiceNo,'')=''  GROUP BY lt.`Panel_ID`) lt ON lt.Panel_ID=fpm.Panel_ID   AND fpm.Payment_mode='Credit'    LEFT JOIN ( SELECT SUM(ino.ReceivedAmt) PaidAmount,ino.Panel_ID FROM invoicemaster_onaccount ino WHERE  IsCancel=0 AND ino.ReceivedDate>='2017-10-01' AND IFNULL(InvoiceNo,'')='' GROUP BY ino.Panel_ID) imo     ON imo.Panel_ID=fpm.Panel_ID  UNION ALL  SELECT fpm.`Panel_Code`,payment_mode, fpm.Panel_ID , CONCAT(fpm.`Company_Name`,'(',fpm.Panel_Code,')')Company_Name, IFNULL(MaxExpiry,'2017-01-01') MaxExpiry ,ROUND( IFNULL(BillingAmount,0)) - (IFNULL(lt.PaidAmount2,0)) AvailAmt   FROM f_panel_master fpm     INNER JOIN(SELECT SUM(Adjustment) PaidAmount2,SUM(NetAmount) BillingAmount, SUM(GrossAmount)GrossAmount,SUM(DiscountOnTotal) DiscountOnTotal,lt.Panel_ID,lt.LedgertransactionNo   FROM f_ledgertransaction lt    WHERE  IsCancel=0  AND DATE(lt.date)>='2017-10-01'    GROUP BY lt.`Panel_ID`) lt ON lt.Panel_ID=fpm.Panel_ID  AND fpm.Payment_mode='Cash' )t ORDER BY Panel_code SELECT  Panel_Code,Company_Name,MaxExpiry,AvailAmt, IF((MaxExpiry<NOW() && AvailAmt>0),'Lock','UnLock') STATUS  FROM  (SELECT  fpm.`Panel_Code`,IF(FPM.`Payment_Mode`='Credit',1,0) Payment_Mode ,fpm.Panel_ID,FPM.`Company_Name`, IFNULL(MaxExpiry,'2017-01-01') MaxExpiry,   (IFNULL(imo.PaidAmount,0)) - (ROUND(IFNULL(BillingAmount,0))+ROUND(IFNULL(BillingAmount2,0))) AvailAmt  FROM f_panel_master fpm INNER JOIN (  SELECT PanelID, SUM(netamount) BillingAmount2 FROM invoicemaster WHERE  iscancel=0   GROUP BY PanelID  ) t2  ON t2.PanelID=fpm.Panel_ID   AND fpm.Payment_mode='Credit'    INNER JOIN(SELECT SUM(Adjustment) PaidAmount2,SUM(NetAmount) BillingAmount,SUM(GrossAmount)GrossAmount,SUM(DiscountOnTotal) DiscountOnTotal,lt.Panel_ID,lt.LedgertransactionNo   FROM f_ledgertransaction lt  WHERE IsCancel=0  AND DATE(lt.date)>='2017-10-01' AND IFNULL(lt.InvoiceNo,'')=''  GROUP BY lt.`Panel_ID`) lt ON lt.Panel_ID=fpm.Panel_ID   AND fpm.Payment_mode='Credit'    LEFT JOIN ( SELECT SUM(ino.ReceivedAmt) PaidAmount,ino.Panel_ID FROM invoicemaster_onaccount ino WHERE  IsCancel=0 AND ino.ReceivedDate>='2017-10-01' AND IFNULL(InvoiceNo,'')='' GROUP BY ino.Panel_ID) imo     ON imo.Panel_ID=fpm.Panel_ID  UNION ALL  SELECT fpm.`Panel_Code`,payment_mode, fpm.Panel_ID , CONCAT(fpm.`Company_Name`,'(',fpm.Panel_Code,')')Company_Name, IFNULL(MaxExpiry,'2017-01-01') MaxExpiry ,ROUND( IFNULL(BillingAmount,0)) - (IFNULL(lt.PaidAmount2,0)) AvailAmt   FROM f_panel_master fpm     INNER JOIN(SELECT SUM(Adjustment) PaidAmount2,SUM(NetAmount) BillingAmount, SUM(GrossAmount)GrossAmount,SUM(DiscountOnTotal) DiscountOnTotal,lt.Panel_ID,lt.LedgertransactionNo   FROM f_ledgertransaction lt    WHERE  IsCancel=0  AND DATE(lt.date)>='2017-10-01'    GROUP BY lt.`Panel_ID`) lt ON lt.Panel_ID=fpm.Panel_ID  AND fpm.Payment_mode='Cash' )t ORDER BY Panel_code SELECT  Panel_Code,Company_Name,MaxExpiry,AvailAmt, IF((MaxExpiry<NOW() && AvailAmt>0),'Lock','UnLock') STATUS  FROM  (SELECT  fpm.`Panel_Code`,IF(FPM.`Payment_Mode`='Credit',1,0) Payment_Mode ,fpm.Panel_ID,FPM.`Company_Name`, IFNULL(MaxExpiry,'2017-01-01') MaxExpiry,   (IFNULL(imo.PaidAmount,0)) - (ROUND(IFNULL(BillingAmount,0))+ROUND(IFNULL(BillingAmount2,0))) AvailAmt  FROM f_panel_master fpm INNER JOIN (  SELECT PanelID, SUM(netamount) BillingAmount2 FROM invoicemaster WHERE  iscancel=0   GROUP BY PanelID  ) t2  ON t2.PanelID=fpm.Panel_ID   AND fpm.Payment_mode='Credit'    INNER JOIN(SELECT SUM(Adjustment) PaidAmount2,SUM(NetAmount) BillingAmount,SUM(GrossAmount)GrossAmount,SUM(DiscountOnTotal) DiscountOnTotal,lt.Panel_ID,lt.LedgertransactionNo   FROM f_ledgertransaction lt  WHERE IsCancel=0  AND DATE(lt.date)>='2017-10-01' AND IFNULL(lt.InvoiceNo,'')=''  GROUP BY lt.`Panel_ID`) lt ON lt.Panel_ID=fpm.Panel_ID   AND fpm.Payment_mode='Credit'    LEFT JOIN ( SELECT SUM(ino.ReceivedAmt) PaidAmount,ino.Panel_ID FROM invoicemaster_onaccount ino WHERE  IsCancel=0 AND ino.ReceivedDate>='2017-10-01' AND IFNULL(InvoiceNo,'')='' GROUP BY ino.Panel_ID) imo     ON imo.Panel_ID=fpm.Panel_ID  UNION ALL  SELECT fpm.`Panel_Code`,payment_mode, fpm.Panel_ID , CONCAT(fpm.`Company_Name`,'(',fpm.Panel_Code,')')Company_Name, IFNULL(MaxExpiry,'2017-01-01') MaxExpiry ,ROUND( IFNULL(BillingAmount,0)) - (IFNULL(lt.PaidAmount2,0)) AvailAmt   FROM f_panel_master fpm     INNER JOIN(SELECT SUM(Adjustment) PaidAmount2,SUM(NetAmount) BillingAmount, SUM(GrossAmount)GrossAmount,SUM(DiscountOnTotal) DiscountOnTotal,lt.Panel_ID,lt.LedgertransactionNo   FROM f_ledgertransaction lt    WHERE  IsCancel=0  AND DATE(lt.date)>='2017-10-01'    GROUP BY lt.`Panel_ID`) lt ON lt.Panel_ID=fpm.Panel_ID  AND fpm.Payment_mode='Cash' )t ORDER BY Panel_code SELECT  Panel_Code,Company_Name,MaxExpiry,AvailAmt, IF((MaxExpiry<NOW() && AvailAmt>0),'Lock','UnLock') STATUS  FROM  (SELECT  fpm.`Panel_Code`,IF(FPM.`Payment_Mode`='Credit',1,0) Payment_Mode ,fpm.Panel_ID,FPM.`Company_Name`, IFNULL(MaxExpiry,'2017-01-01') MaxExpiry,   (IFNULL(imo.PaidAmount,0)) - (ROUND(IFNULL(BillingAmount,0))+ROUND(IFNULL(BillingAmount2,0))) AvailAmt  FROM f_panel_master fpm INNER JOIN (  SELECT PanelID, SUM(netamount) BillingAmount2 FROM invoicemaster WHERE  iscancel=0   GROUP BY PanelID  ) t2  ON t2.PanelID=fpm.Panel_ID   AND fpm.Payment_mode='Credit'    INNER JOIN(SELECT SUM(Adjustment) PaidAmount2,SUM(NetAmount) BillingAmount,SUM(GrossAmount)GrossAmount,SUM(DiscountOnTotal) DiscountOnTotal,lt.Panel_ID,lt.LedgertransactionNo   FROM f_ledgertransaction lt  WHERE IsCancel=0  AND DATE(lt.date)>='2017-10-01' AND IFNULL(lt.InvoiceNo,'')=''  GROUP BY lt.`Panel_ID`) lt ON lt.Panel_ID=fpm.Panel_ID   AND fpm.Payment_mode='Credit'    LEFT JOIN ( SELECT SUM(ino.ReceivedAmt) PaidAmount,ino.Panel_ID FROM invoicemaster_onaccount ino WHERE  IsCancel=0 AND ino.ReceivedDate>='2017-10-01' AND IFNULL(InvoiceNo,'')='' GROUP BY ino.Panel_ID) imo     ON imo.Panel_ID=fpm.Panel_ID  UNION ALL  SELECT fpm.`Panel_Code`,payment_mode, fpm.Panel_ID , CONCAT(fpm.`Company_Name`,'(',fpm.Panel_Code,')')Company_Name, IFNULL(MaxExpiry,'2017-01-01') MaxExpiry ,ROUND( IFNULL(BillingAmount,0)) - (IFNULL(lt.PaidAmount2,0)) AvailAmt   FROM f_panel_master fpm     INNER JOIN(SELECT SUM(Adjustment) PaidAmount2,SUM(NetAmount) BillingAmount, SUM(GrossAmount)GrossAmount,SUM(DiscountOnTotal) DiscountOnTotal,lt.Panel_ID,lt.LedgertransactionNo   FROM f_ledgertransaction lt    WHERE  IsCancel=0  AND DATE(lt.date)>='2017-10-01'    GROUP BY lt.`Panel_ID`) lt ON lt.Panel_ID=fpm.Panel_ID  AND fpm.Payment_mode='Cash' )t ORDER BY Panel_code SELECT  Panel_Code,Company_Name,MaxExpiry,AvailAmt, IF((MaxExpiry<NOW() && AvailAmt>0),'Lock','UnLock') STATUS  FROM  (SELECT  fpm.`Panel_Code`,IF(FPM.`Payment_Mode`='Credit',1,0) Payment_Mode ,fpm.Panel_ID,FPM.`Company_Name`, IFNULL(MaxExpiry,'2017-01-01') MaxExpiry,   (IFNULL(imo.PaidAmount,0)) - (ROUND(IFNULL(BillingAmount,0))+ROUND(IFNULL(BillingAmount2,0))) AvailAmt  FROM f_panel_master fpm INNER JOIN (  SELECT PanelID, SUM(netamount) BillingAmount2 FROM invoicemaster WHERE  iscancel=0   GROUP BY PanelID  ) t2  ON t2.PanelID=fpm.Panel_ID   AND fpm.Payment_mode='Credit'    INNER JOIN(SELECT SUM(Adjustment) PaidAmount2,SUM(NetAmount) BillingAmount,SUM(GrossAmount)GrossAmount,SUM(DiscountOnTotal) DiscountOnTotal,lt.Panel_ID,lt.LedgertransactionNo   FROM f_ledgertransaction lt  WHERE IsCancel=0  AND DATE(lt.date)>='2017-10-01' AND IFNULL(lt.InvoiceNo,'')=''  GROUP BY lt.`Panel_ID`) lt ON lt.Panel_ID=fpm.Panel_ID   AND fpm.Payment_mode='Credit'    LEFT JOIN ( SELECT SUM(ino.ReceivedAmt) PaidAmount,ino.Panel_ID FROM invoicemaster_onaccount ino WHERE  IsCancel=0 AND ino.ReceivedDate>='2017-10-01' AND IFNULL(InvoiceNo,'')='' GROUP BY ino.Panel_ID) imo     ON imo.Panel_ID=fpm.Panel_ID  UNION ALL  SELECT fpm.`Panel_Code`,payment_mode, fpm.Panel_ID , CONCAT(fpm.`Company_Name`,'(',fpm.Panel_Code,')')Company_Name, IFNULL(MaxExpiry,'2017-01-01') MaxExpiry ,ROUND( IFNULL(BillingAmount,0)) - (IFNULL(lt.PaidAmount2,0)) AvailAmt   FROM f_panel_master fpm     INNER JOIN(SELECT SUM(Adjustment) PaidAmount2,SUM(NetAmount) BillingAmount, SUM(GrossAmount)GrossAmount,SUM(DiscountOnTotal) DiscountOnTotal,lt.Panel_ID,lt.LedgertransactionNo   FROM f_ledgertransaction lt    WHERE  IsCancel=0  AND DATE(lt.date)>='2017-10-01'    GROUP BY lt.`Panel_ID`) lt ON lt.Panel_ID=fpm.Panel_ID  AND fpm.Payment_mode='Cash' )t ORDER BY Panel_code SELECT  Panel_Code,Company_Name,MaxExpiry,AvailAmt, IF((MaxExpiry<NOW() && AvailAmt>0),'Lock','UnLock') STATUS  FROM  (SELECT  fpm.`Panel_Code`,IF(FPM.`Payment_Mode`='Credit',1,0) Payment_Mode ,fpm.Panel_ID,FPM.`Company_Name`, IFNULL(MaxExpiry,'2017-01-01') MaxExpiry,   (IFNULL(imo.PaidAmount,0)) - (ROUND(IFNULL(BillingAmount,0))+ROUND(IFNULL(BillingAmount2,0))) AvailAmt  FROM f_panel_master fpm INNER JOIN (  SELECT PanelID, SUM(netamount) BillingAmount2 FROM invoicemaster WHERE  iscancel=0   GROUP BY PanelID  ) t2  ON t2.PanelID=fpm.Panel_ID   AND fpm.Payment_mode='Credit'    INNER JOIN(SELECT SUM(Adjustment) PaidAmount2,SUM(NetAmount) BillingAmount,SUM(GrossAmount)GrossAmount,SUM(DiscountOnTotal) DiscountOnTotal,lt.Panel_ID,lt.LedgertransactionNo   FROM f_ledgertransaction lt  WHERE IsCancel=0  AND DATE(lt.date)>='2017-10-01' AND IFNULL(lt.InvoiceNo,'')=''  GROUP BY lt.`Panel_ID`) lt ON lt.Panel_ID=fpm.Panel_ID   AND fpm.Payment_mode='Credit'    LEFT JOIN ( SELECT SUM(ino.ReceivedAmt) PaidAmount,ino.Panel_ID FROM invoicemaster_onaccount ino WHERE  IsCancel=0 AND ino.ReceivedDate>='2017-10-01' AND IFNULL(InvoiceNo,'')='' GROUP BY ino.Panel_ID) imo     ON imo.Panel_ID=fpm.Panel_ID  UNION ALL  SELECT fpm.`Panel_Code`,payment_mode, fpm.Panel_ID , CONCAT(fpm.`Company_Name`,'(',fpm.Panel_Code,')')Company_Name, IFNULL(MaxExpiry,'2017-01-01') MaxExpiry ,ROUND( IFNULL(BillingAmount,0)) - (IFNULL(lt.PaidAmount2,0)) AvailAmt   FROM f_panel_master fpm     INNER JOIN(SELECT SUM(Adjustment) PaidAmount2,SUM(NetAmount) BillingAmount, SUM(GrossAmount)GrossAmount,SUM(DiscountOnTotal) DiscountOnTotal,lt.Panel_ID,lt.LedgertransactionNo   FROM f_ledgertransaction lt    WHERE  IsCancel=0  AND DATE(lt.date)>='2017-10-01'    GROUP BY lt.`Panel_ID`) lt ON lt.Panel_ID=fpm.Panel_ID  AND fpm.Payment_mode='Cash' )t ORDER BY Panel_code SELECT  Panel_Code,Company_Name,MaxExpiry,AvailAmt, IF((MaxExpiry<NOW() && AvailAmt>0),'Lock','UnLock') STATUS  FROM  (SELECT  fpm.`Panel_Code`,IF(FPM.`Payment_Mode`='Credit',1,0) Payment_Mode ,fpm.Panel_ID,FPM.`Company_Name`, IFNULL(MaxExpiry,'2017-01-01') MaxExpiry,   (IFNULL(imo.PaidAmount,0)) - (ROUND(IFNULL(BillingAmount,0))+ROUND(IFNULL(BillingAmount2,0))) AvailAmt  FROM f_panel_master fpm INNER JOIN (  SELECT PanelID, SUM(netamount) BillingAmount2 FROM invoicemaster WHERE  iscancel=0   GROUP BY PanelID  ) t2  ON t2.PanelID=fpm.Panel_ID   AND fpm.Payment_mode='Credit'    INNER JOIN(SELECT SUM(Adjustment) PaidAmount2,SUM(NetAmount) BillingAmount,SUM(GrossAmount)GrossAmount,SUM(DiscountOnTotal) DiscountOnTotal,lt.Panel_ID,lt.LedgertransactionNo   FROM f_ledgertransaction lt  WHERE IsCancel=0  AND DATE(lt.date)>='2017-10-01' AND IFNULL(lt.InvoiceNo,'')=''  GROUP BY lt.`Panel_ID`) lt ON lt.Panel_ID=fpm.Panel_ID   AND fpm.Payment_mode='Credit'    LEFT JOIN ( SELECT SUM(ino.ReceivedAmt) PaidAmount,ino.Panel_ID FROM invoicemaster_onaccount ino WHERE  IsCancel=0 AND ino.ReceivedDate>='2017-10-01' AND IFNULL(InvoiceNo,'')='' GROUP BY ino.Panel_ID) imo     ON imo.Panel_ID=fpm.Panel_ID  UNION ALL  SELECT fpm.`Panel_Code`,payment_mode, fpm.Panel_ID , CONCAT(fpm.`Company_Name`,'(',fpm.Panel_Code,')')Company_Name, IFNULL(MaxExpiry,'2017-01-01') MaxExpiry ,ROUND( IFNULL(BillingAmount,0)) - (IFNULL(lt.PaidAmount2,0)) AvailAmt   FROM f_panel_master fpm     INNER JOIN(SELECT SUM(Adjustment) PaidAmount2,SUM(NetAmount) BillingAmount, SUM(GrossAmount)GrossAmount,SUM(DiscountOnTotal) DiscountOnTotal,lt.Panel_ID,lt.LedgertransactionNo   FROM f_ledgertransaction lt    WHERE  IsCancel=0  AND DATE(lt.date)>='2017-10-01'    GROUP BY lt.`Panel_ID`) lt ON lt.Panel_ID=fpm.Panel_ID  AND fpm.Payment_mode='Cash' )t ORDER BY Panel_code SELECT  Panel_Code,Company_Name,MaxExpiry,AvailAmt, IF((MaxExpiry<NOW() && AvailAmt>0),'Lock','UnLock') STATUS  FROM  (SELECT  fpm.`Panel_Code`,IF(FPM.`Payment_Mode`='Credit',1,0) Payment_Mode ,fpm.Panel_ID,FPM.`Company_Name`, IFNULL(MaxExpiry,'2017-01-01') MaxExpiry,   (IFNULL(imo.PaidAmount,0)) - (ROUND(IFNULL(BillingAmount,0))+ROUND(IFNULL(BillingAmount2,0))) AvailAmt  FROM f_panel_master fpm INNER JOIN (  SELECT PanelID, SUM(netamount) BillingAmount2 FROM invoicemaster WHERE  iscancel=0   GROUP BY PanelID  ) t2  ON t2.PanelID=fpm.Panel_ID   AND fpm.Payment_mode='Credit'    INNER JOIN(SELECT SUM(Adjustment) PaidAmount2,SUM(NetAmount) BillingAmount,SUM(GrossAmount)GrossAmount,SUM(DiscountOnTotal) DiscountOnTotal,lt.Panel_ID,lt.LedgertransactionNo   FROM f_ledgertransaction lt  WHERE IsCancel=0  AND DATE(lt.date)>='2017-10-01' AND IFNULL(lt.InvoiceNo,'')=''  GROUP BY lt.`Panel_ID`) lt ON lt.Panel_ID=fpm.Panel_ID   AND fpm.Payment_mode='Credit'    LEFT JOIN ( SELECT SUM(ino.ReceivedAmt) PaidAmount,ino.Panel_ID FROM invoicemaster_onaccount ino WHERE  IsCancel=0 AND ino.ReceivedDate>='2017-10-01' AND IFNULL(InvoiceNo,'')='' GROUP BY ino.Panel_ID) imo     ON imo.Panel_ID=fpm.Panel_ID  UNION ALL  SELECT fpm.`Panel_Code`,payment_mode, fpm.Panel_ID , CONCAT(fpm.`Company_Name`,'(',fpm.Panel_Code,')')Company_Name, IFNULL(MaxExpiry,'2017-01-01') MaxExpiry ,ROUND( IFNULL(BillingAmount,0)) - (IFNULL(lt.PaidAmount2,0)) AvailAmt   FROM f_panel_master fpm     INNER JOIN(SELECT SUM(Adjustment) PaidAmount2,SUM(NetAmount) BillingAmount, SUM(GrossAmount)GrossAmount,SUM(DiscountOnTotal) DiscountOnTotal,lt.Panel_ID,lt.LedgertransactionNo   FROM f_ledgertransaction lt    WHERE  IsCancel=0  AND DATE(lt.date)>='2017-10-01'    GROUP BY lt.`Panel_ID`) lt ON lt.Panel_ID=fpm.Panel_ID  AND fpm.Payment_mode='Cash' )t ORDER BY Panel_code SELECT  Panel_Code,Company_Name,MaxExpiry,AvailAmt, IF((MaxExpiry<NOW() && AvailAmt>0),'Lock','UnLock') STATUS  FROM  (SELECT  fpm.`Panel_Code`,IF(FPM.`Payment_Mode`='Credit',1,0) Payment_Mode ,fpm.Panel_ID,FPM.`Company_Name`, IFNULL(MaxExpiry,'2017-01-01') MaxExpiry,   (IFNULL(imo.PaidAmount,0)) - (ROUND(IFNULL(BillingAmount,0))+ROUND(IFNULL(BillingAmount2,0))) AvailAmt  FROM f_panel_master fpm INNER JOIN (  SELECT PanelID, SUM(netamount) BillingAmount2 FROM invoicemaster WHERE  iscancel=0   GROUP BY PanelID  ) t2  ON t2.PanelID=fpm.Panel_ID   AND fpm.Payment_mode='Credit'    INNER JOIN(SELECT SUM(Adjustment) PaidAmount2,SUM(NetAmount) BillingAmount,SUM(GrossAmount)GrossAmount,SUM(DiscountOnTotal) DiscountOnTotal,lt.Panel_ID,lt.LedgertransactionNo   FROM f_ledgertransaction lt  WHERE IsCancel=0  AND DATE(lt.date)>='2017-10-01' AND IFNULL(lt.InvoiceNo,'')=''  GROUP BY lt.`Panel_ID`) lt ON lt.Panel_ID=fpm.Panel_ID   AND fpm.Payment_mode='Credit'    LEFT JOIN ( SELECT SUM(ino.ReceivedAmt) PaidAmount,ino.Panel_ID FROM invoicemaster_onaccount ino WHERE  IsCancel=0 AND ino.ReceivedDate>='2017-10-01' AND IFNULL(InvoiceNo,'')='' GROUP BY ino.Panel_ID) imo     ON imo.Panel_ID=fpm.Panel_ID  UNION ALL  SELECT fpm.`Panel_Code`,payment_mode, fpm.Panel_ID , CONCAT(fpm.`Company_Name`,'(',fpm.Panel_Code,')')Company_Name, IFNULL(MaxExpiry,'2017-01-01') MaxExpiry ,ROUND( IFNULL(BillingAmount,0)) - (IFNULL(lt.PaidAmount2,0)) AvailAmt   FROM f_panel_master fpm     INNER JOIN(SELECT SUM(Adjustment) PaidAmount2,SUM(NetAmount) BillingAmount, SUM(GrossAmount)GrossAmount,SUM(DiscountOnTotal) DiscountOnTotal,lt.Panel_ID,lt.LedgertransactionNo   FROM f_ledgertransaction lt    WHERE  IsCancel=0  AND DATE(lt.date)>='2017-10-01'    GROUP BY lt.`Panel_ID`) lt ON lt.Panel_ID=fpm.Panel_ID  AND fpm.Payment_mode='Cash' )t ORDER BY Panel_code SELECT  Panel_Code,Company_Name,MaxExpiry,AvailAmt, IF((MaxExpiry<NOW() && AvailAmt>0),'Lock','UnLock') STATUS  FROM  (SELECT  fpm.`Panel_Code`,IF(FPM.`Payment_Mode`='Credit',1,0) Payment_Mode ,fpm.Panel_ID,FPM.`Company_Name`, IFNULL(MaxExpiry,'2017-01-01') MaxExpiry,   (IFNULL(imo.PaidAmount,0)) - (ROUND(IFNULL(BillingAmount,0))+ROUND(IFNULL(BillingAmount2,0))) AvailAmt  FROM f_panel_master fpm INNER JOIN (  SELECT PanelID, SUM(netamount) BillingAmount2 FROM invoicemaster WHERE  iscancel=0   GROUP BY PanelID  ) t2  ON t2.PanelID=fpm.Panel_ID   AND fpm.Payment_mode='Credit'    INNER JOIN(SELECT SUM(Adjustment) PaidAmount2,SUM(NetAmount) BillingAmount,SUM(GrossAmount)GrossAmount,SUM(DiscountOnTotal) DiscountOnTotal,lt.Panel_ID,lt.LedgertransactionNo   FROM f_ledgertransaction lt  WHERE IsCancel=0  AND DATE(lt.date)>='2017-10-01' AND IFNULL(lt.InvoiceNo,'')=''  GROUP BY lt.`Panel_ID`) lt ON lt.Panel_ID=fpm.Panel_ID   AND fpm.Payment_mode='Credit'    LEFT JOIN ( SELECT SUM(ino.ReceivedAmt) PaidAmount,ino.Panel_ID FROM invoicemaster_onaccount ino WHERE  IsCancel=0 AND ino.ReceivedDate>='2017-10-01' AND IFNULL(InvoiceNo,'')='' GROUP BY ino.Panel_ID) imo     ON imo.Panel_ID=fpm.Panel_ID  UNION ALL  SELECT fpm.`Panel_Code`,payment_mode, fpm.Panel_ID , CONCAT(fpm.`Company_Name`,'(',fpm.Panel_Code,')')Company_Name, IFNULL(MaxExpiry,'2017-01-01') MaxExpiry ,ROUND( IFNULL(BillingAmount,0)) - (IFNULL(lt.PaidAmount2,0)) AvailAmt   FROM f_panel_master fpm     INNER JOIN(SELECT SUM(Adjustment) PaidAmount2,SUM(NetAmount) BillingAmount, SUM(GrossAmount)GrossAmount,SUM(DiscountOnTotal) DiscountOnTotal,lt.Panel_ID,lt.LedgertransactionNo   FROM f_ledgertransaction lt    WHERE  IsCancel=0  AND DATE(lt.date)>='2017-10-01'    GROUP BY lt.`Panel_ID`) lt ON lt.Panel_ID=fpm.Panel_ID  AND fpm.Payment_mode='Cash' )t ORDER BY Panel_code SELECT  Panel_Code,Company_Name,MaxExpiry,AvailAmt, IF((MaxExpiry<NOW() && AvailAmt>0),'Lock','UnLock') STATUS  FROM  (SELECT  fpm.`Panel_Code`,IF(FPM.`Payment_Mode`='Credit',1,0) Payment_Mode ,fpm.Panel_ID,FPM.`Company_Name`, IFNULL(MaxExpiry,'2017-01-01') MaxExpiry,   (IFNULL(imo.PaidAmount,0)) - (ROUND(IFNULL(BillingAmount,0))+ROUND(IFNULL(BillingAmount2,0))) AvailAmt  FROM f_panel_master fpm INNER JOIN (  SELECT PanelID, SUM(netamount) BillingAmount2 FROM invoicemaster WHERE  iscancel=0   GROUP BY PanelID  ) t2  ON t2.PanelID=fpm.Panel_ID   AND fpm.Payment_mode='Credit'    INNER JOIN(SELECT SUM(Adjustment) PaidAmount2,SUM(NetAmount) BillingAmount,SUM(GrossAmount)GrossAmount,SUM(DiscountOnTotal) DiscountOnTotal,lt.Panel_ID,lt.LedgertransactionNo   FROM f_ledgertransaction lt  WHERE IsCancel=0  AND DATE(lt.date)>='2017-10-01' AND IFNULL(lt.InvoiceNo,'')=''  GROUP BY lt.`Panel_ID`) lt ON lt.Panel_ID=fpm.Panel_ID   AND fpm.Payment_mode='Credit'    LEFT JOIN ( SELECT SUM(ino.ReceivedAmt) PaidAmount,ino.Panel_ID FROM invoicemaster_onaccount ino WHERE  IsCancel=0 AND ino.ReceivedDate>='2017-10-01' AND IFNULL(InvoiceNo,'')='' GROUP BY ino.Panel_ID) imo     ON imo.Panel_ID=fpm.Panel_ID  UNION ALL  SELECT fpm.`Panel_Code`,payment_mode, fpm.Panel_ID , CONCAT(fpm.`Company_Name`,'(',fpm.Panel_Code,')')Company_Name, IFNULL(MaxExpiry,'2017-01-01') MaxExpiry ,ROUND( IFNULL(BillingAmount,0)) - (IFNULL(lt.PaidAmount2,0)) AvailAmt   FROM f_panel_master fpm     INNER JOIN(SELECT SUM(Adjustment) PaidAmount2,SUM(NetAmount) BillingAmount, SUM(GrossAmount)GrossAmount,SUM(DiscountOnTotal) DiscountOnTotal,lt.Panel_ID,lt.LedgertransactionNo   FROM f_ledgertransaction lt    WHERE  IsCancel=0  AND DATE(lt.date)>='2017-10-01'    GROUP BY lt.`Panel_ID`) lt ON lt.Panel_ID=fpm.Panel_ID  AND fpm.Payment_mode='Cash' )t ORDER BY Panel_code SELECT  Panel_Code,Company_Name,MaxExpiry,AvailAmt, IF((MaxExpiry<NOW() && AvailAmt>0),'Lock','UnLock') STATUS  FROM  (SELECT  fpm.`Panel_Code`,IF(FPM.`Payment_Mode`='Credit',1,0) Payment_Mode ,fpm.Panel_ID,FPM.`Company_Name`, IFNULL(MaxExpiry,'2017-01-01') MaxExpiry,   (IFNULL(imo.PaidAmount,0)) - (ROUND(IFNULL(BillingAmount,0))+ROUND(IFNULL(BillingAmount2,0))) AvailAmt  FROM f_panel_master fpm INNER JOIN (  SELECT PanelID, SUM(netamount) BillingAmount2 FROM invoicemaster WHERE  iscancel=0   GROUP BY PanelID  ) t2  ON t2.PanelID=fpm.Panel_ID   AND fpm.Payment_mode='Credit'    INNER JOIN(SELECT SUM(Adjustment) PaidAmount2,SUM(NetAmount) BillingAmount,SUM(GrossAmount)GrossAmount,SUM(DiscountOnTotal) DiscountOnTotal,lt.Panel_ID,lt.LedgertransactionNo   FROM f_ledgertransaction lt  WHERE IsCancel=0  AND DATE(lt.date)>='2017-10-01' AND IFNULL(lt.InvoiceNo,'')=''  GROUP BY lt.`Panel_ID`) lt ON lt.Panel_ID=fpm.Panel_ID   AND fpm.Payment_mode='Credit'    LEFT JOIN ( SELECT SUM(ino.ReceivedAmt) PaidAmount,ino.Panel_ID FROM invoicemaster_onaccount ino WHERE  IsCancel=0 AND ino.ReceivedDate>='2017-10-01' AND IFNULL(InvoiceNo,'')='' GROUP BY ino.Panel_ID) imo     ON imo.Panel_ID=fpm.Panel_ID  UNION ALL  SELECT fpm.`Panel_Code`,payment_mode, fpm.Panel_ID , CONCAT(fpm.`Company_Name`,'(',fpm.Panel_Code,')')Company_Name, IFNULL(MaxExpiry,'2017-01-01') MaxExpiry ,ROUND( IFNULL(BillingAmount,0)) - (IFNULL(lt.PaidAmount2,0)) AvailAmt   FROM f_panel_master fpm     INNER JOIN(SELECT SUM(Adjustment) PaidAmount2,SUM(NetAmount) BillingAmount, SUM(GrossAmount)GrossAmount,SUM(DiscountOnTotal) DiscountOnTotal,lt.Panel_ID,lt.LedgertransactionNo   FROM f_ledgertransaction lt    WHERE  IsCancel=0  AND DATE(lt.date)>='2017-10-01'    GROUP BY lt.`Panel_ID`) lt ON lt.Panel_ID=fpm.Panel_ID  AND fpm.Payment_mode='Cash' )t ORDER BY Panel_code SELECT  Panel_Code,Company_Name,MaxExpiry,AvailAmt, IF((MaxExpiry<NOW() && AvailAmt>0),'Lock','UnLock') STATUS  FROM  (SELECT  fpm.`Panel_Code`,IF(FPM.`Payment_Mode`='Credit',1,0) Payment_Mode ,fpm.Panel_ID,FPM.`Company_Name`, IFNULL(MaxExpiry,'2017-01-01') MaxExpiry,   (IFNULL(imo.PaidAmount,0)) - (ROUND(IFNULL(BillingAmount,0))+ROUND(IFNULL(BillingAmount2,0))) AvailAmt  FROM f_panel_master fpm INNER JOIN (  SELECT PanelID, SUM(netamount) BillingAmount2 FROM invoicemaster WHERE  iscancel=0   GROUP BY PanelID  ) t2  ON t2.PanelID=fpm.Panel_ID   AND fpm.Payment_mode='Credit'    INNER JOIN(SELECT SUM(Adjustment) PaidAmount2,SUM(NetAmount) BillingAmount,SUM(GrossAmount)GrossAmount,SUM(DiscountOnTotal) DiscountOnTotal,lt.Panel_ID,lt.LedgertransactionNo   FROM f_ledgertransaction lt  WHERE IsCancel=0  AND DATE(lt.date)>='2017-10-01' AND IFNULL(lt.InvoiceNo,'')=''  GROUP BY lt.`Panel_ID`) lt ON lt.Panel_ID=fpm.Panel_ID   AND fpm.Payment_mode='Credit'    LEFT JOIN ( SELECT SUM(ino.ReceivedAmt) PaidAmount,ino.Panel_ID FROM invoicemaster_onaccount ino WHERE  IsCancel=0 AND ino.ReceivedDate>='2017-10-01' AND IFNULL(InvoiceNo,'')='' GROUP BY ino.Panel_ID) imo     ON imo.Panel_ID=fpm.Panel_ID  UNION ALL  SELECT fpm.`Panel_Code`,payment_mode, fpm.Panel_ID , CONCAT(fpm.`Company_Name`,'(',fpm.Panel_Code,')')Company_Name, IFNULL(MaxExpiry,'2017-01-01') MaxExpiry ,ROUND( IFNULL(BillingAmount,0)) - (IFNULL(lt.PaidAmount2,0)) AvailAmt   FROM f_panel_master fpm     INNER JOIN(SELECT SUM(Adjustment) PaidAmount2,SUM(NetAmount) BillingAmount, SUM(GrossAmount)GrossAmount,SUM(DiscountOnTotal) DiscountOnTotal,lt.Panel_ID,lt.LedgertransactionNo   FROM f_ledgertransaction lt    WHERE  IsCancel=0  AND DATE(lt.date)>='2017-10-01'    GROUP BY lt.`Panel_ID`) lt ON lt.Panel_ID=fpm.Panel_ID  AND fpm.Payment_mode='Cash' )t ORDER BY Panel_code SELECT  Panel_Code,Company_Name,MaxExpiry,AvailAmt, IF((MaxExpiry<NOW() && AvailAmt>0),'Lock','UnLock') STATUS  FROM  (SELECT  fpm.`Panel_Code`,IF(FPM.`Payment_Mode`='Credit',1,0) Payment_Mode ,fpm.Panel_ID,FPM.`Company_Name`, IFNULL(MaxExpiry,'2017-01-01') MaxExpiry,   (IFNULL(imo.PaidAmount,0)) - (ROUND(IFNULL(BillingAmount,0))+ROUND(IFNULL(BillingAmount2,0))) AvailAmt  FROM f_panel_master fpm INNER JOIN (  SELECT PanelID, SUM(netamount) BillingAmount2 FROM invoicemaster WHERE  iscancel=0   GROUP BY PanelID  ) t2  ON t2.PanelID=fpm.Panel_ID   AND fpm.Payment_mode='Credit'    INNER JOIN(SELECT SUM(Adjustment) PaidAmount2,SUM(NetAmount) BillingAmount,SUM(GrossAmount)GrossAmount,SUM(DiscountOnTotal) DiscountOnTotal,lt.Panel_ID,lt.LedgertransactionNo   FROM f_ledgertransaction lt  WHERE IsCancel=0  AND DATE(lt.date)>='2017-10-01' AND IFNULL(lt.InvoiceNo,'')=''  GROUP BY lt.`Panel_ID`) lt ON lt.Panel_ID=fpm.Panel_ID   AND fpm.Payment_mode='Credit'    LEFT JOIN ( SELECT SUM(ino.ReceivedAmt) PaidAmount,ino.Panel_ID FROM invoicemaster_onaccount ino WHERE  IsCancel=0 AND ino.ReceivedDate>='2017-10-01' AND IFNULL(InvoiceNo,'')='' GROUP BY ino.Panel_ID) imo     ON imo.Panel_ID=fpm.Panel_ID  UNION ALL  SELECT fpm.`Panel_Code`,payment_mode, fpm.Panel_ID , CONCAT(fpm.`Company_Name`,'(',fpm.Panel_Code,')')Company_Name, IFNULL(MaxExpiry,'2017-01-01') MaxExpiry ,ROUND( IFNULL(BillingAmount,0)) - (IFNULL(lt.PaidAmount2,0)) AvailAmt   FROM f_panel_master fpm     INNER JOIN(SELECT SUM(Adjustment) PaidAmount2,SUM(NetAmount) BillingAmount, SUM(GrossAmount)GrossAmount,SUM(DiscountOnTotal) DiscountOnTotal,lt.Panel_ID,lt.LedgertransactionNo   FROM f_ledgertransaction lt    WHERE  IsCancel=0  AND DATE(lt.date)>='2017-10-01'    GROUP BY lt.`Panel_ID`) lt ON lt.Panel_ID=fpm.Panel_ID  AND fpm.Payment_mode='Cash' )t ORDER BY Panel_code SELECT  Panel_Code,Company_Name,MaxExpiry,AvailAmt, IF((MaxExpiry<NOW() && AvailAmt>0),'Lock','UnLock') STATUS  FROM  (SELECT  fpm.`Panel_Code`,IF(FPM.`Payment_Mode`='Credit',1,0) Payment_Mode ,fpm.Panel_ID,FPM.`Company_Name`, IFNULL(MaxExpiry,'2017-01-01') MaxExpiry,   (IFNULL(imo.PaidAmount,0)) - (ROUND(IFNULL(BillingAmount,0))+ROUND(IFNULL(BillingAmount2,0))) AvailAmt  FROM f_panel_master fpm INNER JOIN (  SELECT PanelID, SUM(netamount) BillingAmount2 FROM invoicemaster WHERE  iscancel=0   GROUP BY PanelID  ) t2  ON t2.PanelID=fpm.Panel_ID   AND fpm.Payment_mode='Credit'    INNER JOIN(SELECT SUM(Adjustment) PaidAmount2,SUM(NetAmount) BillingAmount,SUM(GrossAmount)GrossAmount,SUM(DiscountOnTotal) DiscountOnTotal,lt.Panel_ID,lt.LedgertransactionNo   FROM f_ledgertransaction lt  WHERE IsCancel=0  AND DATE(lt.date)>='2017-10-01' AND IFNULL(lt.InvoiceNo,'')=''  GROUP BY lt.`Panel_ID`) lt ON lt.Panel_ID=fpm.Panel_ID   AND fpm.Payment_mode='Credit'    LEFT JOIN ( SELECT SUM(ino.ReceivedAmt) PaidAmount,ino.Panel_ID FROM invoicemaster_onaccount ino WHERE  IsCancel=0 AND ino.ReceivedDate>='2017-10-01' AND IFNULL(InvoiceNo,'')='' GROUP BY ino.Panel_ID) imo     ON imo.Panel_ID=fpm.Panel_ID  UNION ALL  SELECT fpm.`Panel_Code`,payment_mode, fpm.Panel_ID , CONCAT(fpm.`Company_Name`,'(',fpm.Panel_Code,')')Company_Name, IFNULL(MaxExpiry,'2017-01-01') MaxExpiry ,ROUND( IFNULL(BillingAmount,0)) - (IFNULL(lt.PaidAmount2,0)) AvailAmt   FROM f_panel_master fpm     INNER JOIN(SELECT SUM(Adjustment) PaidAmount2,SUM(NetAmount) BillingAmount, SUM(GrossAmount)GrossAmount,SUM(DiscountOnTotal) DiscountOnTotal,lt.Panel_ID,lt.LedgertransactionNo   FROM f_ledgertransaction lt    WHERE  IsCancel=0  AND DATE(lt.date)>='2017-10-01'    GROUP BY lt.`Panel_ID`) lt ON lt.Panel_ID=fpm.Panel_ID  AND fpm.Payment_mode='Cash' )t ORDER BY Panel_code SELECT  Panel_Code,Company_Name,MaxExpiry,AvailAmt, IF((MaxExpiry<NOW() && AvailAmt>0),'Lock','UnLock') STATUS  FROM  (SELECT  fpm.`Panel_Code`,IF(FPM.`Payment_Mode`='Credit',1,0) Payment_Mode ,fpm.Panel_ID,FPM.`Company_Name`, IFNULL(MaxExpiry,'2017-01-01') MaxExpiry,   (IFNULL(imo.PaidAmount,0)) - (ROUND(IFNULL(BillingAmount,0))+ROUND(IFNULL(BillingAmount2,0))) AvailAmt  FROM f_panel_master fpm INNER JOIN (  SELECT PanelID, SUM(netamount) BillingAmount2 FROM invoicemaster WHERE  iscancel=0   GROUP BY PanelID  ) t2  ON t2.PanelID=fpm.Panel_ID   AND fpm.Payment_mode='Credit'    INNER JOIN(SELECT SUM(Adjustment) PaidAmount2,SUM(NetAmount) BillingAmount,SUM(GrossAmount)GrossAmount,SUM(DiscountOnTotal) DiscountOnTotal,lt.Panel_ID,lt.LedgertransactionNo   FROM f_ledgertransaction lt  WHERE IsCancel=0  AND DATE(lt.date)>='2017-10-01' AND IFNULL(lt.InvoiceNo,'')=''  GROUP BY lt.`Panel_ID`) lt ON lt.Panel_ID=fpm.Panel_ID   AND fpm.Payment_mode='Credit'    LEFT JOIN ( SELECT SUM(ino.ReceivedAmt) PaidAmount,ino.Panel_ID FROM invoicemaster_onaccount ino WHERE  IsCancel=0 AND ino.ReceivedDate>='2017-10-01' AND IFNULL(InvoiceNo,'')='' GROUP BY ino.Panel_ID) imo     ON imo.Panel_ID=fpm.Panel_ID  UNION ALL  SELECT fpm.`Panel_Code`,payment_mode, fpm.Panel_ID , CONCAT(fpm.`Company_Name`,'(',fpm.Panel_Code,')')Company_Name, IFNULL(MaxExpiry,'2017-01-01') MaxExpiry ,ROUND( IFNULL(BillingAmount,0)) - (IFNULL(lt.PaidAmount2,0)) AvailAmt   FROM f_panel_master fpm     INNER JOIN(SELECT SUM(Adjustment) PaidAmount2,SUM(NetAmount) BillingAmount, SUM(GrossAmount)GrossAmount,SUM(DiscountOnTotal) DiscountOnTotal,lt.Panel_ID,lt.LedgertransactionNo   FROM f_ledgertransaction lt    WHERE  IsCancel=0  AND DATE(lt.date)>='2017-10-01'    GROUP BY lt.`Panel_ID`) lt ON lt.Panel_ID=fpm.Panel_ID  AND fpm.Payment_mode='Cash' )t ORDER BY Panel_code SELECT  Panel_Code,Company_Name,MaxExpiry,AvailAmt, IF((MaxExpiry<NOW() && AvailAmt>0),'Lock','UnLock') STATUS  FROM  (SELECT  fpm.`Panel_Code`,IF(FPM.`Payment_Mode`='Credit',1,0) Payment_Mode ,fpm.Panel_ID,FPM.`Company_Name`, IFNULL(MaxExpiry,'2017-01-01') MaxExpiry,   (IFNULL(imo.PaidAmount,0)) - (ROUND(IFNULL(BillingAmount,0))+ROUND(IFNULL(BillingAmount2,0))) AvailAmt  FROM f_panel_master fpm INNER JOIN (  SELECT PanelID, SUM(netamount) BillingAmount2 FROM invoicemaster WHERE  iscancel=0   GROUP BY PanelID  ) t2  ON t2.PanelID=fpm.Panel_ID   AND fpm.Payment_mode='Credit'    INNER JOIN(SELECT SUM(Adjustment) PaidAmount2,SUM(NetAmount) BillingAmount,SUM(GrossAmount)GrossAmount,SUM(DiscountOnTotal) DiscountOnTotal,lt.Panel_ID,lt.LedgertransactionNo   FROM f_ledgertransaction lt  WHERE IsCancel=0  AND DATE(lt.date)>='2017-10-01' AND IFNULL(lt.InvoiceNo,'')=''  GROUP BY lt.`Panel_ID`) lt ON lt.Panel_ID=fpm.Panel_ID   AND fpm.Payment_mode='Credit'    LEFT JOIN ( SELECT SUM(ino.ReceivedAmt) PaidAmount,ino.Panel_ID FROM invoicemaster_onaccount ino WHERE  IsCancel=0 AND ino.ReceivedDate>='2017-10-01' AND IFNULL(InvoiceNo,'')='' GROUP BY ino.Panel_ID) imo     ON imo.Panel_ID=fpm.Panel_ID  UNION ALL  SELECT fpm.`Panel_Code`,payment_mode, fpm.Panel_ID , CONCAT(fpm.`Company_Name`,'(',fpm.Panel_Code,')')Company_Name, IFNULL(MaxExpiry,'2017-01-01') MaxExpiry ,ROUND( IFNULL(BillingAmount,0)) - (IFNULL(lt.PaidAmount2,0)) AvailAmt   FROM f_panel_master fpm     INNER JOIN(SELECT SUM(Adjustment) PaidAmount2,SUM(NetAmount) BillingAmount, SUM(GrossAmount)GrossAmount,SUM(DiscountOnTotal) DiscountOnTotal,lt.Panel_ID,lt.LedgertransactionNo   FROM f_ledgertransaction lt    WHERE  IsCancel=0  AND DATE(lt.date)>='2017-10-01'    GROUP BY lt.`Panel_ID`) lt ON lt.Panel_ID=fpm.Panel_ID  AND fpm.Payment_mode='Cash' )t ORDER BY Panel_code SELECT  Panel_Code,Company_Name,MaxExpiry,AvailAmt, IF((MaxExpiry<NOW() && AvailAmt>0),'Lock','UnLock') STATUS  FROM  (SELECT  fpm.`Panel_Code`,IF(FPM.`Payment_Mode`='Credit',1,0) Payment_Mode ,fpm.Panel_ID,FPM.`Company_Name`, IFNULL(MaxExpiry,'2017-01-01') MaxExpiry,   (IFNULL(imo.PaidAmount,0)) - (ROUND(IFNULL(BillingAmount,0))+ROUND(IFNULL(BillingAmount2,0))) AvailAmt  FROM f_panel_master fpm INNER JOIN (  SELECT PanelID, SUM(netamount) BillingAmount2 FROM invoicemaster WHERE  iscancel=0   GROUP BY PanelID  ) t2  ON t2.PanelID=fpm.Panel_ID   AND fpm.Payment_mode='Credit'    INNER JOIN(SELECT SUM(Adjustment) PaidAmount2,SUM(NetAmount) BillingAmount,SUM(GrossAmount)GrossAmount,SUM(DiscountOnTotal) DiscountOnTotal,lt.Panel_ID,lt.LedgertransactionNo   FROM f_ledgertransaction lt  WHERE IsCancel=0  AND DATE(lt.date)>='2017-10-01' AND IFNULL(lt.InvoiceNo,'')=''  GROUP BY lt.`Panel_ID`) lt ON lt.Panel_ID=fpm.Panel_ID   AND fpm.Payment_mode='Credit'    LEFT JOIN ( SELECT SUM(ino.ReceivedAmt) PaidAmount,ino.Panel_ID FROM invoicemaster_onaccount ino WHERE  IsCancel=0 AND ino.ReceivedDate>='2017-10-01' AND IFNULL(InvoiceNo,'')='' GROUP BY ino.Panel_ID) imo     ON imo.Panel_ID=fpm.Panel_ID  UNION ALL  SELECT fpm.`Panel_Code`,payment_mode, fpm.Panel_ID , CONCAT(fpm.`Company_Name`,'(',fpm.Panel_Code,')')Company_Name, IFNULL(MaxExpiry,'2017-01-01') MaxExpiry ,ROUND( IFNULL(BillingAmount,0)) - (IFNULL(lt.PaidAmount2,0)) AvailAmt   FROM f_panel_master fpm     INNER JOIN(SELECT SUM(Adjustment) PaidAmount2,SUM(NetAmount) BillingAmount, SUM(GrossAmount)GrossAmount,SUM(DiscountOnTotal) DiscountOnTotal,lt.Panel_ID,lt.LedgertransactionNo   FROM f_ledgertransaction lt    WHERE  IsCancel=0  AND DATE(lt.date)>='2017-10-01'    GROUP BY lt.`Panel_ID`) lt ON lt.Panel_ID=fpm.Panel_ID  AND fpm.Payment_mode='Cash' )t ORDER BY Panel_code SELECT  Panel_Code,Company_Name,MaxExpiry,AvailAmt, IF((MaxExpiry<NOW() && AvailAmt>0),'Lock','UnLock') STATUS  FROM  (SELECT  fpm.`Panel_Code`,IF(FPM.`Payment_Mode`='Credit',1,0) Payment_Mode ,fpm.Panel_ID,FPM.`Company_Name`, IFNULL(MaxExpiry,'2017-01-01') MaxExpiry,   (IFNULL(imo.PaidAmount,0)) - (ROUND(IFNULL(BillingAmount,0))+ROUND(IFNULL(BillingAmount2,0))) AvailAmt  FROM f_panel_master fpm INNER JOIN (  SELECT PanelID, SUM(netamount) BillingAmount2 FROM invoicemaster WHERE  iscancel=0   GROUP BY PanelID  ) t2  ON t2.PanelID=fpm.Panel_ID   AND fpm.Payment_mode='Credit'    INNER JOIN(SELECT SUM(Adjustment) PaidAmount2,SUM(NetAmount) BillingAmount,SUM(GrossAmount)GrossAmount,SUM(DiscountOnTotal) DiscountOnTotal,lt.Panel_ID,lt.LedgertransactionNo   FROM f_ledgertransaction lt  WHERE IsCancel=0  AND DATE(lt.date)>='2017-10-01' AND IFNULL(lt.InvoiceNo,'')=''  GROUP BY lt.`Panel_ID`) lt ON lt.Panel_ID=fpm.Panel_ID   AND fpm.Payment_mode='Credit'    LEFT JOIN ( SELECT SUM(ino.ReceivedAmt) PaidAmount,ino.Panel_ID FROM invoicemaster_onaccount ino WHERE  IsCancel=0 AND ino.ReceivedDate>='2017-10-01' AND IFNULL(InvoiceNo,'')='' GROUP BY ino.Panel_ID) imo     ON imo.Panel_ID=fpm.Panel_ID  UNION ALL  SELECT fpm.`Panel_Code`,payment_mode, fpm.Panel_ID , CONCAT(fpm.`Company_Name`,'(',fpm.Panel_Code,')')Company_Name, IFNULL(MaxExpiry,'2017-01-01') MaxExpiry ,ROUND( IFNULL(BillingAmount,0)) - (IFNULL(lt.PaidAmount2,0)) AvailAmt   FROM f_panel_master fpm     INNER JOIN(SELECT SUM(Adjustment) PaidAmount2,SUM(NetAmount) BillingAmount, SUM(GrossAmount)GrossAmount,SUM(DiscountOnTotal) DiscountOnTotal,lt.Panel_ID,lt.LedgertransactionNo   FROM f_ledgertransaction lt    WHERE  IsCancel=0  AND DATE(lt.date)>='2017-10-01'    GROUP BY lt.`Panel_ID`) lt ON lt.Panel_ID=fpm.Panel_ID  AND fpm.Payment_mode='Cash' )t ORDER BY Panel_code SELECT  Panel_Code,Company_Name,MaxExpiry,AvailAmt, IF((MaxExpiry<NOW() && AvailAmt>0),'Lock','UnLock') STATUS  FROM  (SELECT  fpm.`Panel_Code`,IF(FPM.`Payment_Mode`='Credit',1,0) Payment_Mode ,fpm.Panel_ID,FPM.`Company_Name`, IFNULL(MaxExpiry,'2017-01-01') MaxExpiry,   (IFNULL(imo.PaidAmount,0)) - (ROUND(IFNULL(BillingAmount,0))+ROUND(IFNULL(BillingAmount2,0))) AvailAmt  FROM f_panel_master fpm INNER JOIN (  SELECT PanelID, SUM(netamount) BillingAmount2 FROM invoicemaster WHERE  iscancel=0   GROUP BY PanelID  ) t2  ON t2.PanelID=fpm.Panel_ID   AND fpm.Payment_mode='Credit'    INNER JOIN(SELECT SUM(Adjustment) PaidAmount2,SUM(NetAmount) BillingAmount,SUM(GrossAmount)GrossAmount,SUM(DiscountOnTotal) DiscountOnTotal,lt.Panel_ID,lt.LedgertransactionNo   FROM f_ledgertransaction lt  WHERE IsCancel=0  AND DATE(lt.date)>='2017-10-01' AND IFNULL(lt.InvoiceNo,'')=''  GROUP BY lt.`Panel_ID`) lt ON lt.Panel_ID=fpm.Panel_ID   AND fpm.Payment_mode='Credit'    LEFT JOIN ( SELECT SUM(ino.ReceivedAmt) PaidAmount,ino.Panel_ID FROM invoicemaster_onaccount ino WHERE  IsCancel=0 AND ino.ReceivedDate>='2017-10-01' AND IFNULL(InvoiceNo,'')='' GROUP BY ino.Panel_ID) imo     ON imo.Panel_ID=fpm.Panel_ID  UNION ALL  SELECT fpm.`Panel_Code`,payment_mode, fpm.Panel_ID , CONCAT(fpm.`Company_Name`,'(',fpm.Panel_Code,')')Company_Name, IFNULL(MaxExpiry,'2017-01-01') MaxExpiry ,ROUND( IFNULL(BillingAmount,0)) - (IFNULL(lt.PaidAmount2,0)) AvailAmt   FROM f_panel_master fpm     INNER JOIN(SELECT SUM(Adjustment) PaidAmount2,SUM(NetAmount) BillingAmount, SUM(GrossAmount)GrossAmount,SUM(DiscountOnTotal) DiscountOnTotal,lt.Panel_ID,lt.LedgertransactionNo   FROM f_ledgertransaction lt    WHERE  IsCancel=0  AND DATE(lt.date)>='2017-10-01'    GROUP BY lt.`Panel_ID`) lt ON lt.Panel_ID=fpm.Panel_ID  AND fpm.Payment_mode='Cash' )t ORDER BY Panel_code SELECT  Panel_Code,Company_Name,MaxExpiry,AvailAmt, IF((MaxExpiry<NOW() && AvailAmt>0),'Lock','UnLock') STATUS  FROM  (SELECT  fpm.`Panel_Code`,IF(FPM.`Payment_Mode`='Credit',1,0) Payment_Mode ,fpm.Panel_ID,FPM.`Company_Name`, IFNULL(MaxExpiry,'2017-01-01') MaxExpiry,   (IFNULL(imo.PaidAmount,0)) - (ROUND(IFNULL(BillingAmount,0))+ROUND(IFNULL(BillingAmount2,0))) AvailAmt  FROM f_panel_master fpm INNER JOIN (  SELECT PanelID, SUM(netamount) BillingAmount2 FROM invoicemaster WHERE  iscancel=0   GROUP BY PanelID  ) t2  ON t2.PanelID=fpm.Panel_ID   AND fpm.Payment_mode='Credit'    INNER JOIN(SELECT SUM(Adjustment) PaidAmount2,SUM(NetAmount) BillingAmount,SUM(GrossAmount)GrossAmount,SUM(DiscountOnTotal) DiscountOnTotal,lt.Panel_ID,lt.LedgertransactionNo   FROM f_ledgertransaction lt  WHERE IsCancel=0  AND DATE(lt.date)>='2017-10-01' AND IFNULL(lt.InvoiceNo,'')=''  GROUP BY lt.`Panel_ID`) lt ON lt.Panel_ID=fpm.Panel_ID   AND fpm.Payment_mode='Credit'    LEFT JOIN ( SELECT SUM(ino.ReceivedAmt) PaidAmount,ino.Panel_ID FROM invoicemaster_onaccount ino WHERE  IsCancel=0 AND ino.ReceivedDate>='2017-10-01' AND IFNULL(InvoiceNo,'')='' GROUP BY ino.Panel_ID) imo     ON imo.Panel_ID=fpm.Panel_ID  UNION ALL  SELECT fpm.`Panel_Code`,payment_mode, fpm.Panel_ID , CONCAT(fpm.`Company_Name`,'(',fpm.Panel_Code,')')Company_Name, IFNULL(MaxExpiry,'2017-01-01') MaxExpiry ,ROUND( IFNULL(BillingAmount,0)) - (IFNULL(lt.PaidAmount2,0)) AvailAmt   FROM f_panel_master fpm     INNER JOIN(SELECT SUM(Adjustment) PaidAmount2,SUM(NetAmount) BillingAmount, SUM(GrossAmount)GrossAmount,SUM(DiscountOnTotal) DiscountOnTotal,lt.Panel_ID,lt.LedgertransactionNo   FROM f_ledgertransaction lt    WHERE  IsCancel=0  AND DATE(lt.date)>='2017-10-01'    GROUP BY lt.`Panel_ID`) lt ON lt.Panel_ID=fpm.Panel_ID  AND fpm.Payment_mode='Cash' )t ORDER BY Panel_code SELECT  Panel_Code,Company_Name,MaxExpiry,AvailAmt, IF((MaxExpiry<NOW() && AvailAmt>0),'Lock','UnLock') STATUS  FROM  (SELECT  fpm.`Panel_Code`,IF(FPM.`Payment_Mode`='Credit',1,0) Payment_Mode ,fpm.Panel_ID,FPM.`Company_Name`, IFNULL(MaxExpiry,'2017-01-01') MaxExpiry,   (IFNULL(imo.PaidAmount,0)) - (ROUND(IFNULL(BillingAmount,0))+ROUND(IFNULL(BillingAmount2,0))) AvailAmt  FROM f_panel_master fpm INNER JOIN (  SELECT PanelID, SUM(netamount) BillingAmount2 FROM invoicemaster WHERE  iscancel=0   GROUP BY PanelID  ) t2  ON t2.PanelID=fpm.Panel_ID   AND fpm.Payment_mode='Credit'    INNER JOIN(SELECT SUM(Adjustment) PaidAmount2,SUM(NetAmount) BillingAmount,SUM(GrossAmount)GrossAmount,SUM(DiscountOnTotal) DiscountOnTotal,lt.Panel_ID,lt.LedgertransactionNo   FROM f_ledgertransaction lt  WHERE IsCancel=0  AND DATE(lt.date)>='2017-10-01' AND IFNULL(lt.InvoiceNo,'')=''  GROUP BY lt.`Panel_ID`) lt ON lt.Panel_ID=fpm.Panel_ID   AND fpm.Payment_mode='Credit'    LEFT JOIN ( SELECT SUM(ino.ReceivedAmt) PaidAmount,ino.Panel_ID FROM invoicemaster_onaccount ino WHERE  IsCancel=0 AND ino.ReceivedDate>='2017-10-01' AND IFNULL(InvoiceNo,'')='' GROUP BY ino.Panel_ID) imo     ON imo.Panel_ID=fpm.Panel_ID  UNION ALL  SELECT fpm.`Panel_Code`,payment_mode, fpm.Panel_ID , CONCAT(fpm.`Company_Name`,'(',fpm.Panel_Code,')')Company_Name, IFNULL(MaxExpiry,'2017-01-01') MaxExpiry ,ROUND( IFNULL(BillingAmount,0)) - (IFNULL(lt.PaidAmount2,0)) AvailAmt   FROM f_panel_master fpm     INNER JOIN(SELECT SUM(Adjustment) PaidAmount2,SUM(NetAmount) BillingAmount, SUM(GrossAmount)GrossAmount,SUM(DiscountOnTotal) DiscountOnTotal,lt.Panel_ID,lt.LedgertransactionNo   FROM f_ledgertransaction lt    WHERE  IsCancel=0  AND DATE(lt.date)>='2017-10-01'    GROUP BY lt.`Panel_ID`) lt ON lt.Panel_ID=fpm.Panel_ID  AND fpm.Payment_mode='Cash' )t ORDER BY Panel_code SELECT  Panel_Code,Company_Name,MaxExpiry,AvailAmt, IF((MaxExpiry<NOW() && AvailAmt>0),'Lock','UnLock') STATUS  FROM  (SELECT  fpm.`Panel_Code`,IF(FPM.`Payment_Mode`='Credit',1,0) Payment_Mode ,fpm.Panel_ID,FPM.`Company_Name`, IFNULL(MaxExpiry,'2017-01-01') MaxExpiry,   (IFNULL(imo.PaidAmount,0)) - (ROUND(IFNULL(BillingAmount,0))+ROUND(IFNULL(BillingAmount2,0))) AvailAmt  FROM f_panel_master fpm INNER JOIN (  SELECT PanelID, SUM(netamount) BillingAmount2 FROM invoicemaster WHERE  iscancel=0   GROUP BY PanelID  ) t2  ON t2.PanelID=fpm.Panel_ID   AND fpm.Payment_mode='Credit'    INNER JOIN(SELECT SUM(Adjustment) PaidAmount2,SUM(NetAmount) BillingAmount,SUM(GrossAmount)GrossAmount,SUM(DiscountOnTotal) DiscountOnTotal,lt.Panel_ID,lt.LedgertransactionNo   FROM f_ledgertransaction lt  WHERE IsCancel=0  AND DATE(lt.date)>='2017-10-01' AND IFNULL(lt.InvoiceNo,'')=''  GROUP BY lt.`Panel_ID`) lt ON lt.Panel_ID=fpm.Panel_ID   AND fpm.Payment_mode='Credit'    LEFT JOIN ( SELECT SUM(ino.ReceivedAmt) PaidAmount,ino.Panel_ID FROM invoicemaster_onaccount ino WHERE  IsCancel=0 AND ino.ReceivedDate>='2017-10-01' AND IFNULL(InvoiceNo,'')='' GROUP BY ino.Panel_ID) imo     ON imo.Panel_ID=fpm.Panel_ID  UNION ALL  SELECT fpm.`Panel_Code`,payment_mode, fpm.Panel_ID , CONCAT(fpm.`Company_Name`,'(',fpm.Panel_Code,')')Company_Name, IFNULL(MaxExpiry,'2017-01-01') MaxExpiry ,ROUND( IFNULL(BillingAmount,0)) - (IFNULL(lt.PaidAmount2,0)) AvailAmt   FROM f_panel_master fpm     INNER JOIN(SELECT SUM(Adjustment) PaidAmount2,SUM(NetAmount) BillingAmount, SUM(GrossAmount)GrossAmount,SUM(DiscountOnTotal) DiscountOnTotal,lt.Panel_ID,lt.LedgertransactionNo   FROM f_ledgertransaction lt    WHERE  IsCancel=0  AND DATE(lt.date)>='2017-10-01'    GROUP BY lt.`Panel_ID`) lt ON lt.Panel_ID=fpm.Panel_ID  AND fpm.Payment_mode='Cash' )t ORDER BY Panel_code SELECT  Panel_Code,Company_Name,MaxExpiry,AvailAmt, IF((MaxExpiry<NOW() && AvailAmt>0),'Lock','UnLock') STATUS  FROM  (SELECT  fpm.`Panel_Code`,IF(FPM.`Payment_Mode`='Credit',1,0) Payment_Mode ,fpm.Panel_ID,FPM.`Company_Name`, IFNULL(MaxExpiry,'2017-01-01') MaxExpiry,   (IFNULL(imo.PaidAmount,0)) - (ROUND(IFNULL(BillingAmount,0))+ROUND(IFNULL(BillingAmount2,0))) AvailAmt  FROM f_panel_master fpm INNER JOIN (  SELECT PanelID, SUM(netamount) BillingAmount2 FROM invoicemaster WHERE  iscancel=0   GROUP BY PanelID  ) t2  ON t2.PanelID=fpm.Panel_ID   AND fpm.Payment_mode='Credit'    INNER JOIN(SELECT SUM(Adjustment) PaidAmount2,SUM(NetAmount) BillingAmount,SUM(GrossAmount)GrossAmount,SUM(DiscountOnTotal) DiscountOnTotal,lt.Panel_ID,lt.LedgertransactionNo   FROM f_ledgertransaction lt  WHERE IsCancel=0  AND DATE(lt.date)>='2017-10-01' AND IFNULL(lt.InvoiceNo,'')=''  GROUP BY lt.`Panel_ID`) lt ON lt.Panel_ID=fpm.Panel_ID   AND fpm.Payment_mode='Credit'    LEFT JOIN ( SELECT SUM(ino.ReceivedAmt) PaidAmount,ino.Panel_ID FROM invoicemaster_onaccount ino WHERE  IsCancel=0 AND ino.ReceivedDate>='2017-10-01' AND IFNULL(InvoiceNo,'')='' GROUP BY ino.Panel_ID) imo     ON imo.Panel_ID=fpm.Panel_ID  UNION ALL  SELECT fpm.`Panel_Code`,payment_mode, fpm.Panel_ID , CONCAT(fpm.`Company_Name`,'(',fpm.Panel_Code,')')Company_Name, IFNULL(MaxExpiry,'2017-01-01') MaxExpiry ,ROUND( IFNULL(BillingAmount,0)) - (IFNULL(lt.PaidAmount2,0)) AvailAmt   FROM f_panel_master fpm     INNER JOIN(SELECT SUM(Adjustment) PaidAmount2,SUM(NetAmount) BillingAmount, SUM(GrossAmount)GrossAmount,SUM(DiscountOnTotal) DiscountOnTotal,lt.Panel_ID,lt.LedgertransactionNo   FROM f_ledgertransaction lt    WHERE  IsCancel=0  AND DATE(lt.date)>='2017-10-01'    GROUP BY lt.`Panel_ID`) lt ON lt.Panel_ID=fpm.Panel_ID  AND fpm.Payment_mode='Cash' )t ORDER BY Panel_code SELECT  Panel_Code,Company_Name,MaxExpiry,AvailAmt, IF((MaxExpiry<NOW() && AvailAmt>0),'Lock','UnLock') STATUS  FROM  (SELECT  fpm.`Panel_Code`,IF(FPM.`Payment_Mode`='Credit',1,0) Payment_Mode ,fpm.Panel_ID,FPM.`Company_Name`, IFNULL(MaxExpiry,'2017-01-01') MaxExpiry,   (IFNULL(imo.PaidAmount,0)) - (ROUND(IFNULL(BillingAmount,0))+ROUND(IFNULL(BillingAmount2,0))) AvailAmt  FROM f_panel_master fpm INNER JOIN (  SELECT PanelID, SUM(netamount) BillingAmount2 FROM invoicemaster WHERE  iscancel=0   GROUP BY PanelID  ) t2  ON t2.PanelID=fpm.Panel_ID   AND fpm.Payment_mode='Credit'    INNER JOIN(SELECT SUM(Adjustment) PaidAmount2,SUM(NetAmount) BillingAmount,SUM(GrossAmount)GrossAmount,SUM(DiscountOnTotal) DiscountOnTotal,lt.Panel_ID,lt.LedgertransactionNo   FROM f_ledgertransaction lt  WHERE IsCancel=0  AND DATE(lt.date)>='2017-10-01' AND IFNULL(lt.InvoiceNo,'')=''  GROUP BY lt.`Panel_ID`) lt ON lt.Panel_ID=fpm.Panel_ID   AND fpm.Payment_mode='Credit'    LEFT JOIN ( SELECT SUM(ino.ReceivedAmt) PaidAmount,ino.Panel_ID FROM invoicemaster_onaccount ino WHERE  IsCancel=0 AND ino.ReceivedDate>='2017-10-01' AND IFNULL(InvoiceNo,'')='' GROUP BY ino.Panel_ID) imo     ON imo.Panel_ID=fpm.Panel_ID  UNION ALL  SELECT fpm.`Panel_Code`,payment_mode, fpm.Panel_ID , CONCAT(fpm.`Company_Name`,'(',fpm.Panel_Code,')')Company_Name, IFNULL(MaxExpiry,'2017-01-01') MaxExpiry ,ROUND( IFNULL(BillingAmount,0)) - (IFNULL(lt.PaidAmount2,0)) AvailAmt   FROM f_panel_master fpm     INNER JOIN(SELECT SUM(Adjustment) PaidAmount2,SUM(NetAmount) BillingAmount, SUM(GrossAmount)GrossAmount,SUM(DiscountOnTotal) DiscountOnTotal,lt.Panel_ID,lt.LedgertransactionNo   FROM f_ledgertransaction lt    WHERE  IsCancel=0  AND DATE(lt.date)>='2017-10-01'    GROUP BY lt.`Panel_ID`) lt ON lt.Panel_ID=fpm.Panel_ID  AND fpm.Payment_mode='Cash' )t ORDER BY Panel_code SELECT  Panel_Code,Company_Name,MaxExpiry,AvailAmt, IF((MaxExpiry<NOW() && AvailAmt>0),'Lock','UnLock') STATUS  FROM  (SELECT  fpm.`Panel_Code`,IF(FPM.`Payment_Mode`='Credit',1,0) Payment_Mode ,fpm.Panel_ID,FPM.`Company_Name`, IFNULL(MaxExpiry,'2017-01-01') MaxExpiry,   (IFNULL(imo.PaidAmount,0)) - (ROUND(IFNULL(BillingAmount,0))+ROUND(IFNULL(BillingAmount2,0))) AvailAmt  FROM f_panel_master fpm INNER JOIN (  SELECT PanelID, SUM(netamount) BillingAmount2 FROM invoicemaster WHERE  iscancel=0   GROUP BY PanelID  ) t2  ON t2.PanelID=fpm.Panel_ID   AND fpm.Payment_mode='Credit'    INNER JOIN(SELECT SUM(Adjustment) PaidAmount2,SUM(NetAmount) BillingAmount,SUM(GrossAmount)GrossAmount,SUM(DiscountOnTotal) DiscountOnTotal,lt.Panel_ID,lt.LedgertransactionNo   FROM f_ledgertransaction lt  WHERE IsCancel=0  AND DATE(lt.date)>='2017-10-01' AND IFNULL(lt.InvoiceNo,'')=''  GROUP BY lt.`Panel_ID`) lt ON lt.Panel_ID=fpm.Panel_ID   AND fpm.Payment_mode='Credit'    LEFT JOIN ( SELECT SUM(ino.ReceivedAmt) PaidAmount,ino.Panel_ID FROM invoicemaster_onaccount ino WHERE  IsCancel=0 AND ino.ReceivedDate>='2017-10-01' AND IFNULL(InvoiceNo,'')='' GROUP BY ino.Panel_ID) imo     ON imo.Panel_ID=fpm.Panel_ID  UNION ALL  SELECT fpm.`Panel_Code`,payment_mode, fpm.Panel_ID , CONCAT(fpm.`Company_Name`,'(',fpm.Panel_Code,')')Company_Name, IFNULL(MaxExpiry,'2017-01-01') MaxExpiry ,ROUND( IFNULL(BillingAmount,0)) - (IFNULL(lt.PaidAmount2,0)) AvailAmt   FROM f_panel_master fpm     INNER JOIN(SELECT SUM(Adjustment) PaidAmount2,SUM(NetAmount) BillingAmount, SUM(GrossAmount)GrossAmount,SUM(DiscountOnTotal) DiscountOnTotal,lt.Panel_ID,lt.LedgertransactionNo   FROM f_ledgertransaction lt    WHERE  IsCancel=0  AND DATE(lt.date)>='2017-10-01'    GROUP BY lt.`Panel_ID`) lt ON lt.Panel_ID=fpm.Panel_ID  AND fpm.Payment_mode='Cash' )t ORDER BY Panel_code SELECT  Panel_Code,Company_Name,MaxExpiry,AvailAmt, IF((MaxExpiry<NOW() && AvailAmt>0),'Lock','UnLock') STATUS  FROM  (SELECT  fpm.`Panel_Code`,IF(FPM.`Payment_Mode`='Credit',1,0) Payment_Mode ,fpm.Panel_ID,FPM.`Company_Name`, IFNULL(MaxExpiry,'2017-01-01') MaxExpiry,   (IFNULL(imo.PaidAmount,0)) - (ROUND(IFNULL(BillingAmount,0))+ROUND(IFNULL(BillingAmount2,0))) AvailAmt  FROM f_panel_master fpm INNER JOIN (  SELECT PanelID, SUM(netamount) BillingAmount2 FROM invoicemaster WHERE  iscancel=0   GROUP BY PanelID  ) t2  ON t2.PanelID=fpm.Panel_ID   AND fpm.Payment_mode='Credit'    INNER JOIN(SELECT SUM(Adjustment) PaidAmount2,SUM(NetAmount) BillingAmount,SUM(GrossAmount)GrossAmount,SUM(DiscountOnTotal) DiscountOnTotal,lt.Panel_ID,lt.LedgertransactionNo   FROM f_ledgertransaction lt  WHERE IsCancel=0  AND DATE(lt.date)>='2017-10-01' AND IFNULL(lt.InvoiceNo,'')=''  GROUP BY lt.`Panel_ID`) lt ON lt.Panel_ID=fpm.Panel_ID   AND fpm.Payment_mode='Credit'    LEFT JOIN ( SELECT SUM(ino.ReceivedAmt) PaidAmount,ino.Panel_ID FROM invoicemaster_onaccount ino WHERE  IsCancel=0 AND ino.ReceivedDate>='2017-10-01' AND IFNULL(InvoiceNo,'')='' GROUP BY ino.Panel_ID) imo     ON imo.Panel_ID=fpm.Panel_ID  UNION ALL  SELECT fpm.`Panel_Code`,payment_mode, fpm.Panel_ID , CONCAT(fpm.`Company_Name`,'(',fpm.Panel_Code,')')Company_Name, IFNULL(MaxExpiry,'2017-01-01') MaxExpiry ,ROUND( IFNULL(BillingAmount,0)) - (IFNULL(lt.PaidAmount2,0)) AvailAmt   FROM f_panel_master fpm     INNER JOIN(SELECT SUM(Adjustment) PaidAmount2,SUM(NetAmount) BillingAmount, SUM(GrossAmount)GrossAmount,SUM(DiscountOnTotal) DiscountOnTotal,lt.Panel_ID,lt.LedgertransactionNo   FROM f_ledgertransaction lt    WHERE  IsCancel=0  AND DATE(lt.date)>='2017-10-01'    GROUP BY lt.`Panel_ID`) lt ON lt.Panel_ID=fpm.Panel_ID  AND fpm.Payment_mode='Cash' )t ORDER BY Panel_code SELECT  Panel_Code,Company_Name,MaxExpiry,AvailAmt, IF((MaxExpiry<NOW() && AvailAmt>0),'Lock','UnLock') STATUS  FROM  (SELECT  fpm.`Panel_Code`,IF(FPM.`Payment_Mode`='Credit',1,0) Payment_Mode ,fpm.Panel_ID,FPM.`Company_Name`, IFNULL(MaxExpiry,'2017-01-01') MaxExpiry,   (IFNULL(imo.PaidAmount,0)) - (ROUND(IFNULL(BillingAmount,0))+ROUND(IFNULL(BillingAmount2,0))) AvailAmt  FROM f_panel_master fpm INNER JOIN (  SELECT PanelID, SUM(netamount) BillingAmount2 FROM invoicemaster WHERE  iscancel=0   GROUP BY PanelID  ) t2  ON t2.PanelID=fpm.Panel_ID   AND fpm.Payment_mode='Credit'    INNER JOIN(SELECT SUM(Adjustment) PaidAmount2,SUM(NetAmount) BillingAmount,SUM(GrossAmount)GrossAmount,SUM(DiscountOnTotal) DiscountOnTotal,lt.Panel_ID,lt.LedgertransactionNo   FROM f_ledgertransaction lt  WHERE IsCancel=0  AND DATE(lt.date)>='2017-10-01' AND IFNULL(lt.InvoiceNo,'')=''  GROUP BY lt.`Panel_ID`) lt ON lt.Panel_ID=fpm.Panel_ID   AND fpm.Payment_mode='Credit'    LEFT JOIN ( SELECT SUM(ino.ReceivedAmt) PaidAmount,ino.Panel_ID FROM invoicemaster_onaccount ino WHERE  IsCancel=0 AND ino.ReceivedDate>='2017-10-01' AND IFNULL(InvoiceNo,'')='' GROUP BY ino.Panel_ID) imo     ON imo.Panel_ID=fpm.Panel_ID  UNION ALL  SELECT fpm.`Panel_Code`,payment_mode, fpm.Panel_ID , CONCAT(fpm.`Company_Name`,'(',fpm.Panel_Code,')')Company_Name, IFNULL(MaxExpiry,'2017-01-01') MaxExpiry ,ROUND( IFNULL(BillingAmount,0)) - (IFNULL(lt.PaidAmount2,0)) AvailAmt   FROM f_panel_master fpm     INNER JOIN(SELECT SUM(Adjustment) PaidAmount2,SUM(NetAmount) BillingAmount, SUM(GrossAmount)GrossAmount,SUM(DiscountOnTotal) DiscountOnTotal,lt.Panel_ID,lt.LedgertransactionNo   FROM f_ledgertransaction lt    WHERE  IsCancel=0  AND DATE(lt.date)>='2017-10-01'    GROUP BY lt.`Panel_ID`) lt ON lt.Panel_ID=fpm.Panel_ID  AND fpm.Payment_mode='Cash' )t ORDER BY Panel_code SELECT  Panel_Code,Company_Name,MaxExpiry,AvailAmt, IF((MaxExpiry<NOW() && AvailAmt>0),'Lock','UnLock') STATUS  FROM  (SELECT  fpm.`Panel_Code`,IF(FPM.`Payment_Mode`='Credit',1,0) Payment_Mode ,fpm.Panel_ID,FPM.`Company_Name`, IFNULL(MaxExpiry,'2017-01-01') MaxExpiry,   (IFNULL(imo.PaidAmount,0)) - (ROUND(IFNULL(BillingAmount,0))+ROUND(IFNULL(BillingAmount2,0))) AvailAmt  FROM f_panel_master fpm INNER JOIN (  SELECT PanelID, SUM(netamount) BillingAmount2 FROM invoicemaster WHERE  iscancel=0   GROUP BY PanelID  ) t2  ON t2.PanelID=fpm.Panel_ID   AND fpm.Payment_mode='Credit'    INNER JOIN(SELECT SUM(Adjustment) PaidAmount2,SUM(NetAmount) BillingAmount,SUM(GrossAmount)GrossAmount,SUM(DiscountOnTotal) DiscountOnTotal,lt.Panel_ID,lt.LedgertransactionNo   FROM f_ledgertransaction lt  WHERE IsCancel=0  AND DATE(lt.date)>='2017-10-01' AND IFNULL(lt.InvoiceNo,'')=''  GROUP BY lt.`Panel_ID`) lt ON lt.Panel_ID=fpm.Panel_ID   AND fpm.Payment_mode='Credit'    LEFT JOIN ( SELECT SUM(ino.ReceivedAmt) PaidAmount,ino.Panel_ID FROM invoicemaster_onaccount ino WHERE  IsCancel=0 AND ino.ReceivedDate>='2017-10-01' AND IFNULL(InvoiceNo,'')='' GROUP BY ino.Panel_ID) imo     ON imo.Panel_ID=fpm.Panel_ID  UNION ALL  SELECT fpm.`Panel_Code`,payment_mode, fpm.Panel_ID , CONCAT(fpm.`Company_Name`,'(',fpm.Panel_Code,')')Company_Name, IFNULL(MaxExpiry,'2017-01-01') MaxExpiry ,ROUND( IFNULL(BillingAmount,0)) - (IFNULL(lt.PaidAmount2,0)) AvailAmt   FROM f_panel_master fpm     INNER JOIN(SELECT SUM(Adjustment) PaidAmount2,SUM(NetAmount) BillingAmount, SUM(GrossAmount)GrossAmount,SUM(DiscountOnTotal) DiscountOnTotal,lt.Panel_ID,lt.LedgertransactionNo   FROM f_ledgertransaction lt    WHERE  IsCancel=0  AND DATE(lt.date)>='2017-10-01'    GROUP BY lt.`Panel_ID`) lt ON lt.Panel_ID=fpm.Panel_ID  AND fpm.Payment_mode='Cash' )t ORDER BY Panel_code SELECT  Panel_Code,Company_Name,MaxExpiry,AvailAmt, IF((MaxExpiry<NOW() && AvailAmt>0),'Lock','UnLock') STATUS  FROM  (SELECT  fpm.`Panel_Code`,IF(FPM.`Payment_Mode`='Credit',1,0) Payment_Mode ,fpm.Panel_ID,FPM.`Company_Name`, IFNULL(MaxExpiry,'2017-01-01') MaxExpiry,   (IFNULL(imo.PaidAmount,0)) - (ROUND(IFNULL(BillingAmount,0))+ROUND(IFNULL(BillingAmount2,0))) AvailAmt  FROM f_panel_master fpm INNER JOIN (  SELECT PanelID, SUM(netamount) BillingAmount2 FROM invoicemaster WHERE  iscancel=0   GROUP BY PanelID  ) t2  ON t2.PanelID=fpm.Panel_ID   AND fpm.Payment_mode='Credit'    INNER JOIN(SELECT SUM(Adjustment) PaidAmount2,SUM(NetAmount) BillingAmount,SUM(GrossAmount)GrossAmount,SUM(DiscountOnTotal) DiscountOnTotal,lt.Panel_ID,lt.LedgertransactionNo   FROM f_ledgertransaction lt  WHERE IsCancel=0  AND DATE(lt.date)>='2017-10-01' AND IFNULL(lt.InvoiceNo,'')=''  GROUP BY lt.`Panel_ID`) lt ON lt.Panel_ID=fpm.Panel_ID   AND fpm.Payment_mode='Credit'    LEFT JOIN ( SELECT SUM(ino.ReceivedAmt) PaidAmount,ino.Panel_ID FROM invoicemaster_onaccount ino WHERE  IsCancel=0 AND ino.ReceivedDate>='2017-10-01' AND IFNULL(InvoiceNo,'')='' GROUP BY ino.Panel_ID) imo     ON imo.Panel_ID=fpm.Panel_ID  UNION ALL  SELECT fpm.`Panel_Code`,payment_mode, fpm.Panel_ID , CONCAT(fpm.`Company_Name`,'(',fpm.Panel_Code,')')Company_Name, IFNULL(MaxExpiry,'2017-01-01') MaxExpiry ,ROUND( IFNULL(BillingAmount,0)) - (IFNULL(lt.PaidAmount2,0)) AvailAmt   FROM f_panel_master fpm     INNER JOIN(SELECT SUM(Adjustment) PaidAmount2,SUM(NetAmount) BillingAmount, SUM(GrossAmount)GrossAmount,SUM(DiscountOnTotal) DiscountOnTotal,lt.Panel_ID,lt.LedgertransactionNo   FROM f_ledgertransaction lt    WHERE  IsCancel=0  AND DATE(lt.date)>='2017-10-01'    GROUP BY lt.`Panel_ID`) lt ON lt.Panel_ID=fpm.Panel_ID  AND fpm.Payment_mode='Cash' )t ORDER BY Panel_code SELECT  Panel_Code,Company_Name,MaxExpiry,AvailAmt, IF((MaxExpiry<NOW() && AvailAmt>0),'Lock','UnLock') STATUS  FROM  (SELECT  fpm.`Panel_Code`,IF(FPM.`Payment_Mode`='Credit',1,0) Payment_Mode ,fpm.Panel_ID,FPM.`Company_Name`, IFNULL(MaxExpiry,'2017-01-01') MaxExpiry,   (IFNULL(imo.PaidAmount,0)) - (ROUND(IFNULL(BillingAmount,0))+ROUND(IFNULL(BillingAmount2,0))) AvailAmt  FROM f_panel_master fpm INNER JOIN (  SELECT PanelID, SUM(netamount) BillingAmount2 FROM invoicemaster WHERE  iscancel=0   GROUP BY PanelID  ) t2  ON t2.PanelID=fpm.Panel_ID   AND fpm.Payment_mode='Credit'    INNER JOIN(SELECT SUM(Adjustment) PaidAmount2,SUM(NetAmount) BillingAmount,SUM(GrossAmount)GrossAmount,SUM(DiscountOnTotal) DiscountOnTotal,lt.Panel_ID,lt.LedgertransactionNo   FROM f_ledgertransaction lt  WHERE IsCancel=0  AND DATE(lt.date)>='2017-10-01' AND IFNULL(lt.InvoiceNo,'')=''  GROUP BY lt.`Panel_ID`) lt ON lt.Panel_ID=fpm.Panel_ID   AND fpm.Payment_mode='Credit'    LEFT JOIN ( SELECT SUM(ino.ReceivedAmt) PaidAmount,ino.Panel_ID FROM invoicemaster_onaccount ino WHERE  IsCancel=0 AND ino.ReceivedDate>='2017-10-01' AND IFNULL(InvoiceNo,'')='' GROUP BY ino.Panel_ID) imo     ON imo.Panel_ID=fpm.Panel_ID  UNION ALL  SELECT fpm.`Panel_Code`,payment_mode, fpm.Panel_ID , CONCAT(fpm.`Company_Name`,'(',fpm.Panel_Code,')')Company_Name, IFNULL(MaxExpiry,'2017-01-01') MaxExpiry ,ROUND( IFNULL(BillingAmount,0)) - (IFNULL(lt.PaidAmount2,0)) AvailAmt   FROM f_panel_master fpm     INNER JOIN(SELECT SUM(Adjustment) PaidAmount2,SUM(NetAmount) BillingAmount, SUM(GrossAmount)GrossAmount,SUM(DiscountOnTotal) DiscountOnTotal,lt.Panel_ID,lt.LedgertransactionNo   FROM f_ledgertransaction lt    WHERE  IsCancel=0  AND DATE(lt.date)>='2017-10-01'    GROUP BY lt.`Panel_ID`) lt ON lt.Panel_ID=fpm.Panel_ID  AND fpm.Payment_mode='Cash' )t ORDER BY Panel_code SELECT  Panel_Code,Company_Name,MaxExpiry,AvailAmt, IF((MaxExpiry<NOW() && AvailAmt>0),'Lock','UnLock') STATUS  FROM  (SELECT  fpm.`Panel_Code`,IF(FPM.`Payment_Mode`='Credit',1,0) Payment_Mode ,fpm.Panel_ID,FPM.`Company_Name`, IFNULL(MaxExpiry,'2017-01-01') MaxExpiry,   (IFNULL(imo.PaidAmount,0)) - (ROUND(IFNULL(BillingAmount,0))+ROUND(IFNULL(BillingAmount2,0))) AvailAmt  FROM f_panel_master fpm INNER JOIN (  SELECT PanelID, SUM(netamount) BillingAmount2 FROM invoicemaster WHERE  iscancel=0   GROUP BY PanelID  ) t2  ON t2.PanelID=fpm.Panel_ID   AND fpm.Payment_mode='Credit'    INNER JOIN(SELECT SUM(Adjustment) PaidAmount2,SUM(NetAmount) BillingAmount,SUM(GrossAmount)GrossAmount,SUM(DiscountOnTotal) DiscountOnTotal,lt.Panel_ID,lt.LedgertransactionNo   FROM f_ledgertransaction lt  WHERE IsCancel=0  AND DATE(lt.date)>='2017-10-01' AND IFNULL(lt.InvoiceNo,'')=''  GROUP BY lt.`Panel_ID`) lt ON lt.Panel_ID=fpm.Panel_ID   AND fpm.Payment_mode='Credit'    LEFT JOIN ( SELECT SUM(ino.ReceivedAmt) PaidAmount,ino.Panel_ID FROM invoicemaster_onaccount ino WHERE  IsCancel=0 AND ino.ReceivedDate>='2017-10-01' AND IFNULL(InvoiceNo,'')='' GROUP BY ino.Panel_ID) imo     ON imo.Panel_ID=fpm.Panel_ID  UNION ALL  SELECT fpm.`Panel_Code`,payment_mode, fpm.Panel_ID , CONCAT(fpm.`Company_Name`,'(',fpm.Panel_Code,')')Company_Name, IFNULL(MaxExpiry,'2017-01-01') MaxExpiry ,ROUND( IFNULL(BillingAmount,0)) - (IFNULL(lt.PaidAmount2,0)) AvailAmt   FROM f_panel_master fpm     INNER JOIN(SELECT SUM(Adjustment) PaidAmount2,SUM(NetAmount) BillingAmount, SUM(GrossAmount)GrossAmount,SUM(DiscountOnTotal) DiscountOnTotal,lt.Panel_ID,lt.LedgertransactionNo   FROM f_ledgertransaction lt    WHERE  IsCancel=0  AND DATE(lt.date)>='2017-10-01'    GROUP BY lt.`Panel_ID`) lt ON lt.Panel_ID=fpm.Panel_ID  AND fpm.Payment_mode='Cash' )t ORDER BY Panel_code SELECT  Panel_Code,Company_Name,MaxExpiry,AvailAmt, IF((MaxExpiry<NOW() && AvailAmt>0),'Lock','UnLock') STATUS  FROM  (SELECT  fpm.`Panel_Code`,IF(FPM.`Payment_Mode`='Credit',1,0) Payment_Mode ,fpm.Panel_ID,FPM.`Company_Name`, IFNULL(MaxExpiry,'2017-01-01') MaxExpiry,   (IFNULL(imo.PaidAmount,0)) - (ROUND(IFNULL(BillingAmount,0))+ROUND(IFNULL(BillingAmount2,0))) AvailAmt  FROM f_panel_master fpm INNER JOIN (  SELECT PanelID, SUM(netamount) BillingAmount2 FROM invoicemaster WHERE  iscancel=0   GROUP BY PanelID  ) t2  ON t2.PanelID=fpm.Panel_ID   AND fpm.Payment_mode='Credit'    INNER JOIN(SELECT SUM(Adjustment) PaidAmount2,SUM(NetAmount) BillingAmount,SUM(GrossAmount)GrossAmount,SUM(DiscountOnTotal) DiscountOnTotal,lt.Panel_ID,lt.LedgertransactionNo   FROM f_ledgertransaction lt  WHERE IsCancel=0  AND DATE(lt.date)>='2017-10-01' AND IFNULL(lt.InvoiceNo,'')=''  GROUP BY lt.`Panel_ID`) lt ON lt.Panel_ID=fpm.Panel_ID   AND fpm.Payment_mode='Credit'    LEFT JOIN ( SELECT SUM(ino.ReceivedAmt) PaidAmount,ino.Panel_ID FROM invoicemaster_onaccount ino WHERE  IsCancel=0 AND ino.ReceivedDate>='2017-10-01' AND IFNULL(InvoiceNo,'')='' GROUP BY ino.Panel_ID) imo     ON imo.Panel_ID=fpm.Panel_ID  UNION ALL  SELECT fpm.`Panel_Code`,payment_mode, fpm.Panel_ID , CONCAT(fpm.`Company_Name`,'(',fpm.Panel_Code,')')Company_Name, IFNULL(MaxExpiry,'2017-01-01') MaxExpiry ,ROUND( IFNULL(BillingAmount,0)) - (IFNULL(lt.PaidAmount2,0)) AvailAmt   FROM f_panel_master fpm     INNER JOIN(SELECT SUM(Adjustment) PaidAmount2,SUM(NetAmount) BillingAmount, SUM(GrossAmount)GrossAmount,SUM(DiscountOnTotal) DiscountOnTotal,lt.Panel_ID,lt.LedgertransactionNo   FROM f_ledgertransaction lt    WHERE  IsCancel=0  AND DATE(lt.date)>='2017-10-01'    GROUP BY lt.`Panel_ID`) lt ON lt.Panel_ID=fpm.Panel_ID  AND fpm.Payment_mode='Cash' )t ORDER BY Panel_code SELECT  Panel_Code,Company_Name,MaxExpiry,AvailAmt, IF((MaxExpiry<NOW() && AvailAmt>0),'Lock','UnLock') STATUS  FROM  (SELECT  fpm.`Panel_Code`,IF(FPM.`Payment_Mode`='Credit',1,0) Payment_Mode ,fpm.Panel_ID,FPM.`Company_Name`, IFNULL(MaxExpiry,'2017-01-01') MaxExpiry,   (IFNULL(imo.PaidAmount,0)) - (ROUND(IFNULL(BillingAmount,0))+ROUND(IFNULL(BillingAmount2,0))) AvailAmt  FROM f_panel_master fpm INNER JOIN (  SELECT PanelID, SUM(netamount) BillingAmount2 FROM invoicemaster WHERE  iscancel=0   GROUP BY PanelID  ) t2  ON t2.PanelID=fpm.Panel_ID   AND fpm.Payment_mode='Credit'    INNER JOIN(SELECT SUM(Adjustment) PaidAmount2,SUM(NetAmount) BillingAmount,SUM(GrossAmount)GrossAmount,SUM(DiscountOnTotal) DiscountOnTotal,lt.Panel_ID,lt.LedgertransactionNo   FROM f_ledgertransaction lt  WHERE IsCancel=0  AND DATE(lt.date)>='2017-10-01' AND IFNULL(lt.InvoiceNo,'')=''  GROUP BY lt.`Panel_ID`) lt ON lt.Panel_ID=fpm.Panel_ID   AND fpm.Payment_mode='Credit'    LEFT JOIN ( SELECT SUM(ino.ReceivedAmt) PaidAmount,ino.Panel_ID FROM invoicemaster_onaccount ino WHERE  IsCancel=0 AND ino.ReceivedDate>='2017-10-01' AND IFNULL(InvoiceNo,'')='' GROUP BY ino.Panel_ID) imo     ON imo.Panel_ID=fpm.Panel_ID  UNION ALL  SELECT fpm.`Panel_Code`,payment_mode, fpm.Panel_ID , CONCAT(fpm.`Company_Name`,'(',fpm.Panel_Code,')')Company_Name, IFNULL(MaxExpiry,'2017-01-01') MaxExpiry ,ROUND( IFNULL(BillingAmount,0)) - (IFNULL(lt.PaidAmount2,0)) AvailAmt   FROM f_panel_master fpm     INNER JOIN(SELECT SUM(Adjustment) PaidAmount2,SUM(NetAmount) BillingAmount, SUM(GrossAmount)GrossAmount,SUM(DiscountOnTotal) DiscountOnTotal,lt.Panel_ID,lt.LedgertransactionNo   FROM f_ledgertransaction lt    WHERE  IsCancel=0  AND DATE(lt.date)>='2017-10-01'    GROUP BY lt.`Panel_ID`) lt ON lt.Panel_ID=fpm.Panel_ID  AND fpm.Payment_mode='Cash' )t ORDER BY Panel_code SELECT  Panel_Code,Company_Name,MaxExpiry,AvailAmt, IF((MaxExpiry<NOW() && AvailAmt>0),'Lock','UnLock') STATUS  FROM  (SELECT  fpm.`Panel_Code`,IF(FPM.`Payment_Mode`='Credit',1,0) Payment_Mode ,fpm.Panel_ID,FPM.`Company_Name`, IFNULL(MaxExpiry,'2017-01-01') MaxExpiry,   (IFNULL(imo.PaidAmount,0)) - (ROUND(IFNULL(BillingAmount,0))+ROUND(IFNULL(BillingAmount2,0))) AvailAmt  FROM f_panel_master fpm INNER JOIN (  SELECT PanelID, SUM(netamount) BillingAmount2 FROM invoicemaster WHERE  iscancel=0   GROUP BY PanelID  ) t2  ON t2.PanelID=fpm.Panel_ID   AND fpm.Payment_mode='Credit'    INNER JOIN(SELECT SUM(Adjustment) PaidAmount2,SUM(NetAmount) BillingAmount,SUM(GrossAmount)GrossAmount,SUM(DiscountOnTotal) DiscountOnTotal,lt.Panel_ID,lt.LedgertransactionNo   FROM f_ledgertransaction lt  WHERE IsCancel=0  AND DATE(lt.date)>='2017-10-01' AND IFNULL(lt.InvoiceNo,'')=''  GROUP BY lt.`Panel_ID`) lt ON lt.Panel_ID=fpm.Panel_ID   AND fpm.Payment_mode='Credit'    LEFT JOIN ( SELECT SUM(ino.ReceivedAmt) PaidAmount,ino.Panel_ID FROM invoicemaster_onaccount ino WHERE  IsCancel=0 AND ino.ReceivedDate>='2017-10-01' AND IFNULL(InvoiceNo,'')='' GROUP BY ino.Panel_ID) imo     ON imo.Panel_ID=fpm.Panel_ID  UNION ALL  SELECT fpm.`Panel_Code`,payment_mode, fpm.Panel_ID , CONCAT(fpm.`Company_Name`,'(',fpm.Panel_Code,')')Company_Name, IFNULL(MaxExpiry,'2017-01-01') MaxExpiry ,ROUND( IFNULL(BillingAmount,0)) - (IFNULL(lt.PaidAmount2,0)) AvailAmt   FROM f_panel_master fpm     INNER JOIN(SELECT SUM(Adjustment) PaidAmount2,SUM(NetAmount) BillingAmount, SUM(GrossAmount)GrossAmount,SUM(DiscountOnTotal) DiscountOnTotal,lt.Panel_ID,lt.LedgertransactionNo   FROM f_ledgertransaction lt    WHERE  IsCancel=0  AND DATE(lt.date)>='2017-10-01'    GROUP BY lt.`Panel_ID`) lt ON lt.Panel_ID=fpm.Panel_ID  AND fpm.Payment_mode='Cash' )t ORDER BY Panel_code SELECT  Panel_Code,Company_Name,MaxExpiry,AvailAmt, IF((MaxExpiry<NOW() && AvailAmt>0),'Lock','UnLock') STATUS  FROM  (SELECT  fpm.`Panel_Code`,IF(FPM.`Payment_Mode`='Credit',1,0) Payment_Mode ,fpm.Panel_ID,FPM.`Company_Name`, IFNULL(MaxExpiry,'2017-01-01') MaxExpiry,   (IFNULL(imo.PaidAmount,0)) - (ROUND(IFNULL(BillingAmount,0))+ROUND(IFNULL(BillingAmount2,0))) AvailAmt  FROM f_panel_master fpm INNER JOIN (  SELECT PanelID, SUM(netamount) BillingAmount2 FROM invoicemaster WHERE  iscancel=0   GROUP BY PanelID  ) t2  ON t2.PanelID=fpm.Panel_ID   AND fpm.Payment_mode='Credit'    INNER JOIN(SELECT SUM(Adjustment) PaidAmount2,SUM(NetAmount) BillingAmount,SUM(GrossAmount)GrossAmount,SUM(DiscountOnTotal) DiscountOnTotal,lt.Panel_ID,lt.LedgertransactionNo   FROM f_ledgertransaction lt  WHERE IsCancel=0  AND DATE(lt.date)>='2017-10-01' AND IFNULL(lt.InvoiceNo,'')=''  GROUP BY lt.`Panel_ID`) lt ON lt.Panel_ID=fpm.Panel_ID   AND fpm.Payment_mode='Credit'    LEFT JOIN ( SELECT SUM(ino.ReceivedAmt) PaidAmount,ino.Panel_ID FROM invoicemaster_onaccount ino WHERE  IsCancel=0 AND ino.ReceivedDate>='2017-10-01' AND IFNULL(InvoiceNo,'')='' GROUP BY ino.Panel_ID) imo     ON imo.Panel_ID=fpm.Panel_ID  UNION ALL  SELECT fpm.`Panel_Code`,payment_mode, fpm.Panel_ID , CONCAT(fpm.`Company_Name`,'(',fpm.Panel_Code,')')Company_Name, IFNULL(MaxExpiry,'2017-01-01') MaxExpiry ,ROUND( IFNULL(BillingAmount,0)) - (IFNULL(lt.PaidAmount2,0)) AvailAmt   FROM f_panel_master fpm     INNER JOIN(SELECT SUM(Adjustment) PaidAmount2,SUM(NetAmount) BillingAmount, SUM(GrossAmount)GrossAmount,SUM(DiscountOnTotal) DiscountOnTotal,lt.Panel_ID,lt.LedgertransactionNo   FROM f_ledgertransaction lt    WHERE  IsCancel=0  AND DATE(lt.date)>='2017-10-01'    GROUP BY lt.`Panel_ID`) lt ON lt.Panel_ID=fpm.Panel_ID  AND fpm.Payment_mode='Cash' )t ORDER BY Panel_code SELECT  Panel_Code,Company_Name,MaxExpiry,AvailAmt, IF((MaxExpiry<NOW() && AvailAmt>0),'Lock','UnLock') STATUS  FROM  (SELECT  fpm.`Panel_Code`,IF(FPM.`Payment_Mode`='Credit',1,0) Payment_Mode ,fpm.Panel_ID,FPM.`Company_Name`, IFNULL(MaxExpiry,'2017-01-01') MaxExpiry,   (IFNULL(imo.PaidAmount,0)) - (ROUND(IFNULL(BillingAmount,0))+ROUND(IFNULL(BillingAmount2,0))) AvailAmt  FROM f_panel_master fpm INNER JOIN (  SELECT PanelID, SUM(netamount) BillingAmount2 FROM invoicemaster WHERE  iscancel=0   GROUP BY PanelID  ) t2  ON t2.PanelID=fpm.Panel_ID   AND fpm.Payment_mode='Credit'    INNER JOIN(SELECT SUM(Adjustment) PaidAmount2,SUM(NetAmount) BillingAmount,SUM(GrossAmount)GrossAmount,SUM(DiscountOnTotal) DiscountOnTotal,lt.Panel_ID,lt.LedgertransactionNo   FROM f_ledgertransaction lt  WHERE IsCancel=0  AND DATE(lt.date)>='2017-10-01' AND IFNULL(lt.InvoiceNo,'')=''  GROUP BY lt.`Panel_ID`) lt ON lt.Panel_ID=fpm.Panel_ID   AND fpm.Payment_mode='Credit'    LEFT JOIN ( SELECT SUM(ino.ReceivedAmt) PaidAmount,ino.Panel_ID FROM invoicemaster_onaccount ino WHERE  IsCancel=0 AND ino.ReceivedDate>='2017-10-01' AND IFNULL(InvoiceNo,'')='' GROUP BY ino.Panel_ID) imo     ON imo.Panel_ID=fpm.Panel_ID  UNION ALL  SELECT fpm.`Panel_Code`,payment_mode, fpm.Panel_ID , CONCAT(fpm.`Company_Name`,'(',fpm.Panel_Code,')')Company_Name, IFNULL(MaxExpiry,'2017-01-01') MaxExpiry ,ROUND( IFNULL(BillingAmount,0)) - (IFNULL(lt.PaidAmount2,0)) AvailAmt   FROM f_panel_master fpm     INNER JOIN(SELECT SUM(Adjustment) PaidAmount2,SUM(NetAmount) BillingAmount, SUM(GrossAmount)GrossAmount,SUM(DiscountOnTotal) DiscountOnTotal,lt.Panel_ID,lt.LedgertransactionNo   FROM f_ledgertransaction lt    WHERE  IsCancel=0  AND DATE(lt.date)>='2017-10-01'    GROUP BY lt.`Panel_ID`) lt ON lt.Panel_ID=fpm.Panel_ID  AND fpm.Payment_mode='Cash' )t ORDER BY Panel_code SELECT  Panel_Code,Company_Name,MaxExpiry,AvailAmt, IF((MaxExpiry<NOW() && AvailAmt>0),'Lock','UnLock') STATUS  FROM  (SELECT  fpm.`Panel_Code`,IF(FPM.`Payment_Mode`='Credit',1,0) Payment_Mode ,fpm.Panel_ID,FPM.`Company_Name`, IFNULL(MaxExpiry,'2017-01-01') MaxExpiry,   (IFNULL(imo.PaidAmount,0)) - (ROUND(IFNULL(BillingAmount,0))+ROUND(IFNULL(BillingAmount2,0))) AvailAmt  FROM f_panel_master fpm INNER JOIN (  SELECT PanelID, SUM(netamount) BillingAmount2 FROM invoicemaster WHERE  iscancel=0   GROUP BY PanelID  ) t2  ON t2.PanelID=fpm.Panel_ID   AND fpm.Payment_mode='Credit'    INNER JOIN(SELECT SUM(Adjustment) PaidAmount2,SUM(NetAmount) BillingAmount,SUM(GrossAmount)GrossAmount,SUM(DiscountOnTotal) DiscountOnTotal,lt.Panel_ID,lt.LedgertransactionNo   FROM f_ledgertransaction lt  WHERE IsCancel=0  AND DATE(lt.date)>='2017-10-01' AND IFNULL(lt.InvoiceNo,'')=''  GROUP BY lt.`Panel_ID`) lt ON lt.Panel_ID=fpm.Panel_ID   AND fpm.Payment_mode='Credit'    LEFT JOIN ( SELECT SUM(ino.ReceivedAmt) PaidAmount,ino.Panel_ID FROM invoicemaster_onaccount ino WHERE  IsCancel=0 AND ino.ReceivedDate>='2017-10-01' AND IFNULL(InvoiceNo,'')='' GROUP BY ino.Panel_ID) imo     ON imo.Panel_ID=fpm.Panel_ID  UNION ALL  SELECT fpm.`Panel_Code`,payment_mode, fpm.Panel_ID , CONCAT(fpm.`Company_Name`,'(',fpm.Panel_Code,')')Company_Name, IFNULL(MaxExpiry,'2017-01-01') MaxExpiry ,ROUND( IFNULL(BillingAmount,0)) - (IFNULL(lt.PaidAmount2,0)) AvailAmt   FROM f_panel_master fpm     INNER JOIN(SELECT SUM(Adjustment) PaidAmount2,SUM(NetAmount) BillingAmount, SUM(GrossAmount)GrossAmount,SUM(DiscountOnTotal) DiscountOnTotal,lt.Panel_ID,lt.LedgertransactionNo   FROM f_ledgertransaction lt    WHERE  IsCancel=0  AND DATE(lt.date)>='2017-10-01'    GROUP BY lt.`Panel_ID`) lt ON lt.Panel_ID=fpm.Panel_ID  AND fpm.Payment_mode='Cash' )t ORDER BY Panel_code