SELECT pm.InvoicePanelID `Panel_ID`,pm.InvoicePanelID `Panel_Code`,pm.`Company_Name`,
  IFNULL(OpenReceive.receivedAmt,0)-IFNULL(OpenBook.NetAmount,0) OpeningAmount,
 DATE_FORMAT(aa.`Date`,'%d-%b-%y') Date,
  aa.`mrp_rate`, 
 aa.`Amount`, 
		aa.`Type`, aa.`Logistic_charges`,aa.`Stationary_charges` 
    FROM f_panel_master pm 
 LEFT JOIN 
 (SELECT SUM(receivedAmt)receivedAmt,Panel_id 
   FROM `invoicemaster_onaccount` 
  WHERE iscancel=0 AND `ReceivedDate` < '2024-04-01' 
 AND Panel_id in('219')  
  GROUP BY `Panel_id` ) OpenReceive ON OpenReceive.Panel_id=pm.Panel_id 
LEFT JOIN 
  (SELECT SUM(lt.NetAmount)NetAmount,fpm.`invoicepanelid` Panel_id 
  FROM  `f_ledgertransaction` lt 
 INNER JOIN f_panel_master fpm ON fpm.`Panel_id`=lt.`Panel_id` 
  WHERE lt.iscancel=0 AND lt.Date < '2024-04-01 00:00:00' 
 AND fpm.`invoicepanelid` in('219')  
  GROUP BY fpm.`invoicepanelid` ) OpenBook ON OpenBook.Panel_id=pm.Panel_id 
  LEFT JOIN ( 
 SELECT DATE(lt.`Date`)DATE,fpm.`invoicepanelid` Panel_id,  
 ltd.Rate `mrp_rate`,sum((-1) * ltd.`Amount`)Amount, CONCAT( 'TotalBooking','-',DATE(lt.`Date`)) `Type`,0 `Logistic_charges`,0 `Stationary_charges` 
 FROM  `f_ledgertransaction` lt 
 INNER JOIN `f_ledgertnxdetail` ltd ON ltd.`LedgerTransactionNo`=lt.`LedgerTransactionNo`
 INNER JOIN  f_panel_master fpm ON fpm.`Panel_id`=lt.`Panel_id` 
 WHERE lt.iscancel=0  
 AND lt.Date >= '2024-04-01 00:00:00' 
 AND lt.Date <= '2025-02-24 23:59:59' 
 AND fpm.`invoicepanelid` in('219') 
 GROUP BY DATE(lt.Date) 
 UNION ALL 
 SELECT ReceivedDate `Date`, Panel_id, 
 '' `mrp_rate`,`ReceivedAmt` `Amount`, 'ClientPayment' `Type` ,0 `Logistic_charges`,0 `Stationary_charges`  
 FROM `invoicemaster_onaccount` 
 WHERE iscancel=0 AND `ReceivedDate` >= '2024-04-01' AND `ReceivedDate` <= '2025-02-24'
 AND Panel_id in('219') 
 ) aa ON aa.Panel_id=pm.`Panel_ID` 
   WHERE pm.isActive=1 AND pm.invoicepanelid=pm.Panel_ID  
 AND pm.Panel_ID  in('219') 
  ORDER BY pm.`Company_Name`,aa.date,aa.`Type` Desc