Issue MF-197 Script Perbaikan Data Invoice Auto Generated

--MF-197
--Script Perbaikan Data Invoice Nomor : MEG21.11.0681
--==========================================================================================================
--* Remove Data Allocation Cashbank In AR
--> Update fi_receipt_ar_balance
UPDATE fi_receipt_ar_balance A SET flg_alloc = 'N'
WHERE EXISTS (SELECT 1 FROM fi_allocation_ar B
                WHERE A.receipt_ar_balance_id = B.ref_id
                AND B.doc_no = 'MEG21.11.0680');

--> UPDATE fi_invoice_ar_balance
UPDATE fi_invoice_ar_balance SET flg_payment = 'N' WHERE doc_no = 'MEG21.11.0679';


--> DELETE fi_allocation_ar_cost
DELETE FROM fi_allocation_ar_cost A WHERE EXISTS (SELECT 1 FROM fi_allocation_ar B
                                                        WHERE A.allocation_ar_id = B.allocation_ar_id
                                                        AND B.doc_no = 'MEG21.11.0680');
--> DELETE fi_allocation_ar_invoice
DELETE FROM fi_allocation_ar_invoice A WHERE EXISTS (SELECT 1 FROM fi_allocation_ar B
                                                        WHERE A.allocation_ar_id = B.allocation_ar_id
                                                        AND B.doc_no = 'MEG21.11.0680');
--> DELETE fi_allocation_ar
DELETE FROM fi_allocation_ar WHERE doc_no = 'MEG21.11.0680';

--==========================================================================================================

---* Remove Sales Invoice
--> DELETE sl_invoice_item
DELETE FROM sl_invoice_item A WHERE EXISTS (SELECT 1 FROM sl_invoice B
                                                WHERE A.invoice_id = B.invoice_id
                                                AND B.doc_no = 'MEG21.11.0679');
--> DELETE sl_invoice
DELETE FROM sl_invoice  WHERE doc_no  = 'MEG21.11.0679';

--==========================================================================================================

--* Update Void SO
--> Update sl_so_balance_item
UPDATE sl_so_balance_item A SET qty_cancel = 0, qty_cancel_int = 0
WHERE EXISTS (SELECT 1
                FROM sl_so_item B
                INNER JOIN sl_so C ON B.so_id = C.so_id
                WHERE A.so_item_id = B.so_item_id
                AND C.doc_no = 'MEG-SO21.10.0375');

--> Update sl_so_balance_invoice
UPDATE sl_so_balance_invoice A SET flg_invoice  = 'Y'
WHERE EXISTS (SELECT 1 FROM sl_so B WHERE A.so_id = B.so_id AND B.doc_no = 'MEG-SO21.10.0375');

--> Update sl_so_po_balance_item
UPDATE sl_so_po_balance_item A SET status_item  = 'F'
WHERE EXISTS (SELECT 1 FROM sl_so B WHERE A.so_id = B.so_id AND B.doc_no = 'MEG-SO21.10.0375');



*********

--MF-197
Script Perbaikan Data Invoice Nomor : MEG21.11.1503
--==========================================================================================================
--* Remove Data Allocation Cashbank In AR
--> Update fi_receipt_ar_balance
UPDATE fi_receipt_ar_balance A SET flg_alloc = 'N'
WHERE EXISTS (SELECT 1 FROM fi_allocation_ar B
                WHERE A.receipt_ar_balance_id = B.ref_id
                AND B.doc_no = 'MEG21.11.1502');

--> UPDATE fi_invoice_ar_balance
UPDATE fi_invoice_ar_balance SET flg_payment = 'N' WHERE doc_no = 'MEG21.11.1501';


--> DELETE fi_allocation_ar_cost
DELETE FROM fi_allocation_ar_cost A WHERE EXISTS (SELECT 1 FROM fi_allocation_ar B
                                                        WHERE A.allocation_ar_id = B.allocation_ar_id
                                                        AND B.doc_no = 'MEG21.11.1502');
--> DELETE fi_allocation_ar_invoice
DELETE FROM fi_allocation_ar_invoice A WHERE EXISTS (SELECT 1 FROM fi_allocation_ar B
                                                        WHERE A.allocation_ar_id = B.allocation_ar_id
                                                        AND B.doc_no = 'MEG21.11.1502');
--> DELETE fi_allocation_ar
DELETE FROM fi_allocation_ar WHERE doc_no = 'MEG21.11.1502';

--==========================================================================================================

---* Remove Sales Invoice
--> DELETE sl_invoice_item
DELETE FROM sl_invoice_item A WHERE EXISTS (SELECT 1 FROM sl_invoice B
                                                WHERE A.invoice_id = B.invoice_id
                                                AND B.doc_no = 'MEG21.11.1501');
--> DELETE sl_invoice
DELETE FROM sl_invoice  WHERE doc_no  = 'MEG21.11.1501';

--==========================================================================================================

--* Update Void SO
--> Update sl_so_balance_item
UPDATE sl_so_balance_item A SET qty_cancel = 0, qty_cancel_int = 0
WHERE EXISTS (SELECT 1
                FROM sl_so_item B
                INNER JOIN sl_so C ON B.so_id = C.so_id
                WHERE A.so_item_id = B.so_item_id
                AND C.doc_no = 'MEG-SO21.10.0457');

--> Update sl_so_balance_invoice
UPDATE sl_so_balance_invoice A SET flg_invoice  = 'Y'
WHERE EXISTS (SELECT 1 FROM sl_so B WHERE A.so_id = B.so_id AND B.doc_no = 'MEG-SO21.10.0457');

--> Update sl_so_po_balance_item
UPDATE sl_so_po_balance_item A SET status_item  = 'F'
WHERE EXISTS (SELECT 1 FROM sl_so B WHERE A.so_id = B.so_id AND B.doc_no = 'MEG-SO21.10.0457');