Update Pajak KPS-577

UPDATE fi_invoice_ar_balance Z
    SET amount = Z.amount + A.amount
    FROM fi_invoice_ar_balance A
    WHERE Z.invoice_ar_id = 43577
        AND A.invoice_ar_id = 43576

    UPDATE fi_invoice_ar_balance
    SET amount = 0
    WHERE invoice_ar_id = 43576

    UPDATE fi_invoice_tax_ar_balance  Z
    SET tax_amount = Z.amount + A.amount
        gov_tax_amount = Z.gov_tax_amount + A.gov_tax_amount
        gov_base_amount = Z.gov_base_amount + A.gov_base_amount
    FROM fi_invoice_tax_ar_balance A
    WHERE Z.invoice_ar_balance_id = 36886
        AND A.invoice_ar_balance_id = 36885

    UPDATE fi_invoice_tax_ar_balance
    SET tax_amount = 0
        gov_tax_amount = 0
        gov_base_amount = 0
    WHERE invoice_ar_balance_id = 36885

    UPDATE fi_vat_out_for_reporting Z
    SET base_amount = Z.base_amount + A.base_amount
        vat_amount = Z.vat_amount + A.vat_amount
    FROM fi_vat_out_for_reporting A
    WHERE Z.ref_id = 2484
        AND A.ref_id = 2483

    UPDATE fi_vat_out_for_reporting
    SET base_amount = 0
        vat_amount = 0
    FROM fi_vat_out_for_reporting
    WHERE ref_id = 2483