Script Update Issue Jen-6

-- Sebagai Journal Purchase Invoice
SELECT gl_manage_admin_journal_trx(A.tenant_id, 10, 10, 'AP.PURCH', 'PURCH', f_get_year_month_date(A.doc_date), 'DAILY', '20210616095225', 43)
FROM pu_po A
WHERE doc_no IN ('HGP-2108-00027','HGP-2108-00028','HGP-2108-00029','HGP-2108-00030','HGP-2108-00031')
AND doc_type_id = 160;
--> 5 Rows Data

-- Sebagai Journal Goods Receive
SELECT gl_manage_admin_journal_trx(A.tenant_id, 10, 10, 'STOCK.PURCH', 'PURCH', f_get_year_month_date(A.doc_date), 'DAILY', '20210616095225', 43)
FROM pu_po A
WHERE doc_no IN ('HGP-2108-00027','HGP-2108-00028','HGP-2108-00029','HGP-2108-00030','HGP-2108-00031')
AND doc_type_id = 160;
--> 5 Rows Data

--> fi_invoice_ap_balance
UPDATE fi_invoice_ap_balance SET ou_id = 10
WHERE doc_no IN ('HGP-2108-00027','HGP-2108-00028','HGP-2108-00029','HGP-2108-00030','HGP-2108-00031')
AND doc_type_id = 160;
--> 5 Rows Data

--> fi_summary_monthly_ap
UPDATE fi_summary_monthly_ap A SET ou_id = 10
FROM fi_invoice_ap_balance B
WHERE a.invoice_id = b.invoice_ap_balance_id
AND a.doc_type_id = b.doc_type_id
AND a.doc_type_id = 160
AND b.doc_no IN ('HGP-2108-00027','HGP-2108-00028','HGP-2108-00029','HGP-2108-00030','HGP-2108-00031');
--> 15 Rows Data