Date | Base_Amount | Ledger | Status
22-01-2022 | 50 | ALedger |
23-01-2022 | 100 | ALedger |
24-01-2022 | 20 | ALedger |
25-01-2022 | 30 | ALedger |
22-01-2022 | 50 | KLedger |
23-01-2022 | 5000 | KLedger |
24-01-2022 | 20 | KLedger |
25-01-2022 200 | KLedger |
This is table in database and i want to do sum of Base_Amount if ALedger and KLedger of Ledger column Date is same and if sum 0 is then in status column set Reconciled otherwise set unreconciled if sum is other than 0(Zero)