abirama62

list val monthly closing

Feb 10th, 2021
941
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. [SASA-248]
  2.  
  3. Buat list validasi yang dilakukan pada func monthly closing
  4. 1. gl_closing_ledger
  5.   1. Cek jurnal trx yang belum diposting (gl_journal_trx.status_doc <> 'R')
  6.   2. jumlah debet dan kredit di yearMonth sebelumnya sama
  7.     1. SUM(gl_trial_balance.amount) <> 0 (kalau tidak 0, berarti tidak balance)
  8.   3. total nilai untuk coa Assets dan Liabilities harus sama dengan total nilai untuk coa Costs dan Revenues
  9.     1. SUM(A.amount WHERE A.type_coa IN ('A', 'L')) <> SUM(A.amount WHERE A.type_coa IN ('C', 'R'))
  10.     1. table: tt_sum_gl_trial_balance A
  11.  
  12. 2. i_closing_ledger (POS)
  13.   1. cek data outlet yang belum diproses
  14.     1. (i_outlet_admin_monthly_process.flg_process <> 'Y')
  15.  
  16. 3. in_closing_ledger (inv)
  17.   1. cek transaksi terkait stok yang belum selesai diproses
  18.     1. receive goods (pu_receive_goods.status_doc <> 'R')
  19.     2. delivery order (sl_do.status_doc <> 'R')
  20.     3. inventory (in_inventory.status_doc <> 'R')
  21.  
  22. 4. in_closing_costing_raw_materials
  23.   1. cek data jurnal ledger PURCH, FIN.AP, FIN.AR, CASHBANK yang belum direlease
  24.     1. (gl_journal_trx.status_doc <> 'R')
  25.     2. m_document_journal.ledger_code IN ('PURCH','FIN.AP','FIN.AR','CASHBANK')
  26.  
  27. 5. in_closing_costing_wip
  28.  
  29. 6. in_closing_costing_finish_goods
  30.   1. cek data jurnal ledger PURCH, FIN.AP, FIN.AR, CASHBANK yang belum direlease
  31.     1. (gl_journal_trx.status_doc <> 'R')
  32.     2. m_document_journal.ledger_code IN ('PURCH','FIN.AP','FIN.AR','CASHBANK')
  33.  
  34. 7. cb_closing_ledger
  35.   1. cek transaksi belum selesai diproses
  36.     1. payment order dan RCA (cb_payment_order.status_doc NOT IN ('R', 'V'))
  37.     2. CAS (cb_advance_settle.status_doc <> 'R')
  38.     3. transfer CB (cb_transfer_cashbank.status_doc <> 'R')
  39.     4. CB in dan CB out (cb_in_out_cashbank.status_doc NOT IN ('R', 'V'))
  40.  
  41. 8. pu_closing_ledger
  42.   1. cek transaksi belum selesai diproses
  43.     1. receive goods (pu_receive_goods.status_doc <> 'R')
  44.     2. purch invoice (pu_invoice.status_doc NOT IN ('R', 'M'))
  45.     3. purch internal (pu_po_internal.status_doc <> 'R')
  46.  
  47. 9. sl_closing_ledger
  48.   1. note: ada custom di SASA
  49.   2. cek transaksi belum selesai diproses
  50.     1. DO (sl_do.status_doc <> 'R')
  51.     2. SI (sl_invoice.status_doc <> 'R')
  52.     3. TSI (sl_invoice_temp.status_doc NOT IN ('R', 'V'))
  53.     4. invoice shop in shop (sl_invoice_shop_in_shop.status_doc <> 'R')
  54.     5. SI consignment (sl_invoice_consignment.status_doc <> 'R')
  55.     6. pengiriman (in_pengiriman.status_doc <> 'R')
  56.     7. finalisasi pengiriman (in_finalisasi_pengiriman.status_doc <> 'R')
  57.   3. cek DO temp yang belum dibuatkan DOReceipt
  58.     1. in_log_pengiriman.status_finalisasi IN ('DITOLAK_SEMUA', 'DITERIMA_SEBAGIAN')
  59.     2. and NOT EXISTS in in_do_receipt
  60.  
  61. 10. fi_ap_closing_ledger
  62.   1. cek transaksi belum selesai diproses
  63.     1. invoice ap (fi_invoice_ap.status_doc <> 'R')
  64.     2. PO ap, alloc deb ap (fi_payment_order.status_doc <> 'R')
  65.  
  66. 11. fi_ar_closing_ledger
  67.   1. note: ada custom di SASA
  68.   2. cek data belum selesai proses
  69.     1. invoice ar (fi_invoice_ar.status_doc <> 'R')
  70.     2. PO ar, alloc credit ar, alloc receipt ar (fi_allocation_ar.status_doc <> 'R')
  71.   3. cek receipt ar balance yang belum dialokasi
  72.     1. (fi_receipt_ar_balance.flg_alloc = 'N')
  73.   4. cek receipt ar balance sudah dialokasi lintas bulan
  74.     1. (fi_receipt_ar_balance.flg_alloc = 'Y')
  75.     2. INNER JOIN fi_allocation_ar D WHERE yearMonth <> SUBSTR(D.doc_date,1,6)
RAW Paste Data