record

(select zz.barcode, zz.qty_sisa as qty, zz.toko from (

select msk.barcode as barcode_masuk, msk.artcode as artcode_masuk, msk.color as color_masuk, msk.size as size_masuk, msk.qty as qty_masuk, ifnull(klr.barcode, msk.barcode) as barcode, ifnull(klr.artcode, msk.artcode) as artcode, ifnull(klr.color, msk.color) as color, ifnull(klr.size, msk.size) as size, ifnull(klr.qty, 0) as qty_keluar, msk.qty-ifnull(klr.qty, 0) as qty_sisa, msk.toko from (
    select a.barcode, a.artcode, a.color, a.size, sum(a.qty) as qty, a.toko from (
    select autonum as id_transaksi, barcode, artcode, color, size, sum(qty) as qty, toko from nifn_saldo_awal_pos where toko = 'HM2C' group by barcode
    UNION
    select a.id_transaksi, a.barcode, a.artcode, a.color, a.size, sum(a.qty) as qty, b.toko from nifn_trans_klr_barang_detail as a JOIN nifn_trans_klr_barang_master as b ON a.id_transaksi = b.id_masuk where b.toko = 'HM2C' AND a.validated = 1 GROUP BY a.barcode
    UNION
    select a.id_transaksi, a.barcode, a.artcode, a.color, a.size, sum(a.qty) as qty, b.tujuan as toko from nifn_trans_mutasi_pos_detail as a join nifn_trans_mutasi_pos_master as b on a.id_transaksi = b.id_masuk where b.tujuan = 'HM2C'  and a.validated = 1 and b.validated = 1 group by a.barcode
    UNION
    select a.id_transaksi, a.barcode, a.artcode,  a.color, a.size, sum(a.qty) as qty, b.id_cabang as toko from nifn_trans_exchange_detail as a join nifn_trans_exchange_master as b on a.id_transaksi = b.id_transaksi where b.id_cabang = 'HM2C' group by a.barcode
    ) as a group by barcode
) as msk
LEFT JOIN
(
    select a.barcode, a.artcode, a.color, a.size, sum(a.qty) as qty, a.toko from (
    select a.id_transaksi, a.barcode, a.artcode, a.color, a.size, sum(a.qty) as qty, b.pos_toko as toko from nifn_trans_pos_detail as a join nifn_trans_pos_master as b on a.id_transaksi = b.pos_id_transaksi where b.pos_toko = 'HM2C' GROUP BY a.barcode
    UNION
    select a.id_transaksi, a.barcode, a.artcode, a.color, a.size, sum(a.qty) as qty, b.dari as toko from nifn_trans_mutasi_pos_detail as a join nifn_trans_mutasi_pos_master as b on a.id_transaksi = b.id_masuk where b.dari = 'HM2C' group by a.barcode
    UNION
    select a.id_transaksi, a.barcode, a.artcode, a.color, a.size, sum(a.qty) as qty, b.toko from nifn_trans_retur_gudang_detail as a join nifn_trans_retur_gudang_master as b on a.id_transaksi = b.id_retur where b.toko = 'HM2C' group by a.barcode
    ) as a group by barcode
) as klr
ON msk.barcode = klr.barcode

) as zz)