list val monthly closing

[SASA-248]

Buat list validasi yang dilakukan pada func monthly closing
1. gl_closing_ledger
  1. Cek jurnal trx yang belum diposting (gl_journal_trx.status_doc <> 'R')
  2. jumlah debet dan kredit di yearMonth sebelumnya sama
    1. SUM(gl_trial_balance.amount) <> 0 (kalau tidak 0, berarti tidak balance)
  3. total nilai untuk coa Assets dan Liabilities harus sama dengan total nilai untuk coa Costs dan Revenues
    1. SUM(A.amount WHERE A.type_coa IN ('A', 'L')) <> SUM(A.amount WHERE A.type_coa IN ('C', 'R'))
    1. table: tt_sum_gl_trial_balance A

2. i_closing_ledger (POS)
  1. cek data outlet yang belum diproses
    1. (i_outlet_admin_monthly_process.flg_process <> 'Y')

3. in_closing_ledger (inv)
  1. cek transaksi terkait stok yang belum selesai diproses
    1. receive goods (pu_receive_goods.status_doc <> 'R')
    2. delivery order (sl_do.status_doc <> 'R')
    3. inventory (in_inventory.status_doc <> 'R')

4. in_closing_costing_raw_materials
  1. cek data jurnal ledger PURCH, FIN.AP, FIN.AR, CASHBANK yang belum direlease
    1. (gl_journal_trx.status_doc <> 'R')
    2. m_document_journal.ledger_code IN ('PURCH','FIN.AP','FIN.AR','CASHBANK')

5. in_closing_costing_wip

6. in_closing_costing_finish_goods
  1. cek data jurnal ledger PURCH, FIN.AP, FIN.AR, CASHBANK yang belum direlease
    1. (gl_journal_trx.status_doc <> 'R')
    2. m_document_journal.ledger_code IN ('PURCH','FIN.AP','FIN.AR','CASHBANK')

7. cb_closing_ledger
  1. cek transaksi belum selesai diproses
    1. payment order dan RCA (cb_payment_order.status_doc NOT IN ('R', 'V'))
    2. CAS (cb_advance_settle.status_doc <> 'R')
    3. transfer CB (cb_transfer_cashbank.status_doc <> 'R')
    4. CB in dan CB out (cb_in_out_cashbank.status_doc NOT IN ('R', 'V'))

8. pu_closing_ledger
  1. cek transaksi belum selesai diproses
    1. receive goods (pu_receive_goods.status_doc <> 'R')
    2. purch invoice (pu_invoice.status_doc NOT IN ('R', 'M'))
    3. purch internal (pu_po_internal.status_doc <> 'R')

9. sl_closing_ledger
  1. note: ada custom di SASA
  2. cek transaksi belum selesai diproses
    1. DO (sl_do.status_doc <> 'R')
    2. SI (sl_invoice.status_doc <> 'R')
    3. TSI (sl_invoice_temp.status_doc NOT IN ('R', 'V'))
    4. invoice shop in shop (sl_invoice_shop_in_shop.status_doc <> 'R')
    5. SI consignment (sl_invoice_consignment.status_doc <> 'R')
    6. pengiriman (in_pengiriman.status_doc <> 'R')
    7. finalisasi pengiriman (in_finalisasi_pengiriman.status_doc <> 'R')
  3. cek DO temp yang belum dibuatkan DOReceipt
    1. in_log_pengiriman.status_finalisasi IN ('DITOLAK_SEMUA', 'DITERIMA_SEBAGIAN')
    2. and NOT EXISTS in in_do_receipt

10. fi_ap_closing_ledger
  1. cek transaksi belum selesai diproses
    1. invoice ap (fi_invoice_ap.status_doc <> 'R')
    2. PO ap, alloc deb ap (fi_payment_order.status_doc <> 'R')

11. fi_ar_closing_ledger
  1. note: ada custom di SASA
  2. cek data belum selesai proses
    1. invoice ar (fi_invoice_ar.status_doc <> 'R')
    2. PO ar, alloc credit ar, alloc receipt ar (fi_allocation_ar.status_doc <> 'R')
  3. cek receipt ar balance yang belum dialokasi
    1. (fi_receipt_ar_balance.flg_alloc = 'N')
  4. cek receipt ar balance sudah dialokasi lintas bulan
    1. (fi_receipt_ar_balance.flg_alloc = 'Y')
    2. INNER JOIN fi_allocation_ar D WHERE yearMonth <> SUBSTR(D.doc_date,1,6)