Monday, April 22, 2013

Mengubah Kode Rekening Yang Salah (khusus Utip Upah Buruh)

Caranya, buka database SIMPAT kemudian eksekusi script berikut :

UPDATE t_jurnal_detail SET master_id = '40415' 
WHERE kode_rekening LIKE '404.15%' AND master_id <> '40415'; 
UPDATE t_jurnal_detail SET master_id = '40415' 
WHERE kode_rekening LIKE '404.15%' AND master_id <> '40415';

No comments:

Post a Comment