Selisih dengan jurnal

WITH jurnal AS (
    SELECT SUBSTRING(B.doc_date, 1, 6) as date_year_month, B.doc_type_id, A.product_id,
           SUM(CASE WHEN A.sign_journal = 'D' THEN A.gl_amount ELSE -1 * A.gl_amount END) AS amount,
           A.coa_id
    FROM vw_gl_journal_trx_details A
    INNER JOIN gl_journal_trx B ON A.journal_trx_id = B.journal_trx_id
    INNER JOIN m_product C ON C.product_id = A.product_id
    INNER JOIN m_ctgr_product D ON D.ctgr_product_id = C.ctgr_product_id
    INNER JOIN m_group_product E ON E.group_product_id = D.group_product_id AND A.coa_id = E.coa_id
    WHERE SUBSTRING(B.doc_date, 1, 6)  = '201709' AND
          B.tenant_id = 10 AND
          B.ou_bu_id = 10
    GROUP BY SUBSTRING(B.doc_date, 1, 6), B.doc_type_id, A.product_id, A.coa_id
),
summary AS (
    SELECT A.date_year_month as date_year_month, A.doc_type_id , A.product_id, SUM(A.gl_amount) AS amount,
           D.coa_id
    FROM in_summary_monthly_amount A
    INNER JOIN m_product B ON A.product_id = B.product_id
    INNER JOIN m_ctgr_product C ON B.ctgr_product_id = C.ctgr_product_id
    INNER JOIN m_group_product D ON D.group_product_id = C.group_product_id
    WHERE A.date_year_month  = '201709' AND
          A.ou_bu_id = 10 AND
          A.tenant_id = 10 AND
          A.doc_type_id <> -99
    GROUP BY A.date_year_month, A.doc_type_id, A.product_id, D.coa_id
)
SELECT 10, A.date_year_month, A.doc_type_id, A.product_id,
       C.flg_buy_konsinyasi, 'AMOUNT', A.amount, B.amount
--SELECT COUNT(1)
FROM jurnal A
FULL OUTER JOIN summary B ON A.doc_type_id = B.doc_type_id AND
                             A.product_id = B.product_id AND
                             A.date_year_month = B.date_year_month AND
                             A.coa_id = B.coa_id
LEFT JOIN m_product_custom C ON A.product_id = C.product_id
WHERE (A.amount - B.amount is not null AND A.amount - B.amount <> 0)