Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- --Prepare script
- -- 1. check jurnal item yang butuh OU RC, tapi nilainya -99
- SELECT LEFT(A.journal_date, 6) as month_periode, B.main_acc, B.sub_acc, B.coa_desc, C.group_coa_code, C.flg_sub_rc, C.flg_sub_ou, A.amount
- FROM gl_journal_trx_item A
- INNER JOIN gl_journal_trx X ON A.journal_trx_id = X.journal_trx_id
- INNER JOIN m_coa B ON A.coa_id = B.coa_id
- INNER JOIN m_group_coa C ON B.group_coa_id = C.group_coa_id
- WHERE C.flg_sub_rc = 'Y'
- AND C.flg_sub_rc = 'Y'
- --AND A.journal_date BETWEEN '20210101' AND '20210330'
- AND A.ou_rc_id = -99
- --AND C.group_coa_id NOT IN (28, 62)
- ORDER BY A.journal_date, B.coa_desc;
- -- note: di gl_journal_trx_mapping dan gl_journal_trx_fx tidak ada datanya
- -- 2. Update data -> SET ou_rc_id = 91 (ouId ADMIN dan UMUM)
- BEGIN;
- UPDATE gl_journal_trx_item A SET ou_rc_id = 91
- WHERE EXISTS (
- SELECT 1
- FROM gl_journal_trx X
- INNER JOIN m_coa B ON A.coa_id = B.coa_id
- INNER JOIN m_group_coa C ON B.group_coa_id = C.group_coa_id
- WHERE A.journal_trx_id = X.journal_trx_id
- AND C.flg_sub_rc = 'Y'
- )
- --AND A.journal_date BETWEEN '20210101' AND '20210330'
- AND A.ou_rc_id = -99;
- END;
- --ROLLBACK;
- -- 3. cek kembali data hasil perbaikan, coba download Report Trial Balance
RAW Paste Data