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) = '201704' 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 = '201704' 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
    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);