INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-08-24 ','08:00:49');
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-08-23','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2026-07-23';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-08-22';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-08-22';
INSERT INTO tt_barang_saldo (kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_awal,berat_awal_asli,stock_awal,berat_akhir,berat_akhir_asli,stock_akhir) SELECT kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_akhir,berat_akhir_asli,stock_akhir,berat_akhir,berat_akhir_asli,stock_akhir FROM tt_barang_saldo WHERE tanggal='2026-08-22' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-08-22';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-08-22';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-08-22';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-08-22';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202607 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-07';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-07';
UPDATE tt_barang_saldo SET tanggal= '2026-08-23' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-08-22' OR stock_akhir*1<0  OR kode_lokasi_gudang='' OR kode_lokasi_toko='' OR status_close='CLOS';
UPDATE tp_system SET tgl_system='2026-08-23';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-08-24 ','08:01:24');
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-08-24','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2026-07-24';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-08-23';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-08-23';
INSERT INTO tt_barang_saldo (kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_awal,berat_awal_asli,stock_awal,berat_akhir,berat_akhir_asli,stock_akhir) SELECT kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_akhir,berat_akhir_asli,stock_akhir,berat_akhir,berat_akhir_asli,stock_akhir FROM tt_barang_saldo WHERE tanggal='2026-08-23' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-08-23';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-08-23';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-08-23';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-08-23';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202607 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-07';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-07';
UPDATE tt_barang_saldo SET tanggal= '2026-08-24' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-08-23' OR stock_akhir*1<0  OR kode_lokasi_gudang='' OR kode_lokasi_toko='' OR status_close='CLOS';
UPDATE tp_system SET tgl_system='2026-08-24';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-08-24 ','08:02:18');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-08-24 ','11:37:53');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MTCN-ZHBD-1-0','00031120','FS EX ','CN COR DB SHB ','FUSHION','GR','---','MT','MTCN','TOKO','INPUT1','6077500','2026-08-24','6077500','3.250','100.00','16','0','1870000.00','1','0.045', 'adminpusat','2026-08-24 11:42:55','3.240','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MTCN' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTCN','MTCN-ZHBD-1-0','00031120');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-08-24','MTCN-ZHBD-1-0','MTCN','TOKO','INPUT1','100.00','3.250','3.240','1','3.250','3.240','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MTCN-ZHBD-2-0','00031121','FS EX ','CN COR DB SHB ','FUSHION','GR','---','MT','MTCN','TOKO','INPUT1','8303000','2026-08-24','8303000','4.440','100.00','16','0','1870000.00','1','0.045', 'adminpusat','2026-08-24 11:44:25','4.430','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MTCN' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTCN','MTCN-ZHBD-2-0','00031121');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-08-24','MTCN-ZHBD-2-0','MTCN','TOKO','INPUT1','100.00','4.440','4.430','1','4.440','4.430','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MTCN-ZHBD-3-0','00031122','FS EX ','CN COR DB SHB ','FUSHION','GR','---','MT','MTCN','TOKO','INPUT1','5348500','2026-08-24','5348500','2.860','100.00','16','0','1870000.00','1','0.045', 'adminpusat','2026-08-24 11:46:00','2.850','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MTCN' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTCN','MTCN-ZHBD-3-0','00031122');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-08-24','MTCN-ZHBD-3-0','MTCN','TOKO','INPUT1','100.00','2.860','2.850','1','2.860','2.850','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MTCN-ZHBD-4-0','00031123','FS ','CN COR DB SHB ','FUSHION','GR','---','MT','MTCN','TOKO','INPUT1','10435000','2026-08-24','10435000','5.580','100.00','16','419000','1870000.00','1','0.045', 'adminpusat','2026-08-24 11:48:00','5.570','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MTCN' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTCN','MTCN-ZHBD-4-0','00031123');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-08-24','MTCN-ZHBD-4-0','MTCN','TOKO','INPUT1','100.00','5.580','5.570','1','5.580','5.570','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MTCN-ZHBD-5-0','00031124','FS ','CN COR DB SHB ','FUSHION','GR','---','MT','MTCN','TOKO','INPUT1','6395500','2026-08-24','6395500','3.420','100.00','16','257000','1870000.00','1','0.045', 'adminpusat','2026-08-24 11:49:46','3.410','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MTCN' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTCN','MTCN-ZHBD-5-0','00031124');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-08-24','MTCN-ZHBD-5-0','MTCN','TOKO','INPUT1','100.00','3.420','3.410','1','3.420','3.410','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MTCN-ZHBD-6-0','00031125','FS ','CN COR DB SHB ','FUSHION','GR','---','MT','MTCN','TOKO','INPUT1','6040500','2026-08-24','6040500','3.230','100.00','16','243000','1870000.00','1','0.045', 'adminpusat','2026-08-24 12:00:28','3.220','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MTCN' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTCN','MTCN-ZHBD-6-0','00031125');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-08-24','MTCN-ZHBD-6-0','MTCN','TOKO','INPUT1','100.00','3.230','3.220','1','3.230','3.220','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MTCN-ZHBD-7-0','00031126','FS ','CN COR DB SHB ','FUSHION','GR','---','MT','MTCN','TOKO','INPUT1','5647500','2026-08-24','5647500','3.020','100.00','16','227000','1870000.00','1','0.045', 'adminpusat','2026-08-24 12:01:52','3.010','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MTCN' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTCN','MTCN-ZHBD-7-0','00031126');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-08-24','MTCN-ZHBD-7-0','MTCN','TOKO','INPUT1','100.00','3.020','3.010','1','3.020','3.010','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MTCN-ZHBD-8-0','00031127','FS ','CN COR DB SHB ','FUSHION','GR','---','MT','MTCN','TOKO','INPUT1','6657500','2026-08-24','6657500','3.560','100.00','16','267000','1870000.00','1','0.045', 'adminpusat','2026-08-24 12:04:39','3.550','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MTCN' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTCN','MTCN-ZHBD-8-0','00031127');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-08-24','MTCN-ZHBD-8-0','MTCN','TOKO','INPUT1','100.00','3.560','3.550','1','3.560','3.550','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MTCN-ZHBD-9-0','00031128','FS ','CN COR DB SHB ','FUSHION','GR','---','MT','MTCN','TOKO','INPUT1','5049000','2026-08-24','5049000','2.700','100.00','16','203000','1870000.00','1','0.045', 'adminpusat','2026-08-24 12:06:15','2.690','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MTCN' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTCN','MTCN-ZHBD-9-0','00031128');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-08-24','MTCN-ZHBD-9-0','MTCN','TOKO','INPUT1','100.00','2.700','2.690','1','2.700','2.690','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MTCN-ZHBD-10-0','00031129','FS ','CN COR DB SHB ','FUSHION','GR','---','MT','MTCN','TOKO','INPUT1','5834500','2026-08-24','5834500','3.120','100.00','16','234000','1870000.00','1','0.045', 'adminpusat','2026-08-24 12:07:38','3.110','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MTCN' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTCN','MTCN-ZHBD-10-0','00031129');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-08-24','MTCN-ZHBD-10-0','MTCN','TOKO','INPUT1','100.00','3.120','3.110','1','3.120','3.110','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MTGL-ZHBD-11-0','00031130','FS EX ','GL COR DB SHB ','FUSHION','GR','---','MT','MTGL','TOKO','INPUT1','34165000','2026-08-24','34165000','18.270','100.00','16','0','1870000.00','1','0.045', 'adminpusat','2026-08-24 12:10:55','18.260','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MTGL' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTGL','MTGL-ZHBD-11-0','00031130');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-08-24','MTGL-ZHBD-11-0','MTGL','TOKO','INPUT1','100.00','18.270','18.260','1','18.270','18.260','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MTGL-ZHBD-12-0','00031131','FS EX ','GL COR DB SHB ','FUSHION','GR','---','MT','MTGL','TOKO','INPUT1','51406500','2026-08-24','51406500','27.490','100.00','16','0','1870000.00','1','0.045', 'adminpusat','2026-08-24 12:13:03','27.480','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MTGL' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTGL','MTGL-ZHBD-12-0','00031131');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-08-24','MTGL-ZHBD-12-0','MTGL','TOKO','INPUT1','100.00','27.490','27.480','1','27.490','27.480','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MTKL-ZHBD-13-0','00031132','FS EX ','KL VANESSA DB 44CM KKT PER SHB ','FUSHION','GR','---','MT','MTKL','TOKO','INPUT1','36334500','2026-08-24','36334500','19.430','100.00','16','0','1870000.00','1','0.045', 'adminpusat','2026-08-24 12:18:14','19.420','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MTKL' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTKL','MTKL-ZHBD-13-0','00031132');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-08-24','MTKL-ZHBD-13-0','MTKL','TOKO','INPUT1','100.00','19.430','19.420','1','19.430','19.420','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MTKL-ZHBD-14-0','00031133','FS ','KL VANESSA DB 44CM KKT PER SHB ','FUSHION','GR','---','MT','MTKL','TOKO','INPUT1','36334500','2026-08-24','36334500','19.430','100.00','16','1458000','1870000.00','1','0.045', 'adminpusat','2026-08-24 12:26:59','19.420','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MTKL' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTKL','MTKL-ZHBD-14-0','00031133');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-08-24','MTKL-ZHBD-14-0','MTKL','TOKO','INPUT1','100.00','19.430','19.420','1','19.430','19.420','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MTKL-ZHBD-15-0','00031134','FS EX ','KL VANESSA DB 42CM KKT PER SHB ','FUSHION','GR','---','MT','MTKL','TOKO','INPUT1','30163500','2026-08-24','30163500','16.130','100.00','16','0','1870000.00','1','0.045', 'adminpusat','2026-08-24 12:29:06','16.120','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MTKL' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTKL','MTKL-ZHBD-15-0','00031134');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-08-24','MTKL-ZHBD-15-0','MTKL','TOKO','INPUT1','100.00','16.130','16.120','1','16.130','16.120','1');
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260824-0001','1','MTCN-ZHBD-1-0','1','3.250','3.250','TOKO','INPUT1','TOKO','BKMF');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKMF' WHERE kode_barang='MTCN-ZHBD-1-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-08-24','TOKO','BKMF','MTCN','MTCN-ZHBD-1-0','100.00','1','3.250','3.240','1','3.250','3.240');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'3.250',berat_out_asli=berat_out_asli+'3.240',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-08-24' AND kode_barang='MTCN-ZHBD-1-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260824-0001','2','MTCN-ZHBD-2-0','1','4.440','4.440','TOKO','INPUT1','TOKO','BKMF');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKMF' WHERE kode_barang='MTCN-ZHBD-2-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-08-24','TOKO','BKMF','MTCN','MTCN-ZHBD-2-0','100.00','1','4.440','4.430','1','4.440','4.430');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'4.440',berat_out_asli=berat_out_asli+'4.430',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-08-24' AND kode_barang='MTCN-ZHBD-2-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260824-0001','3','MTCN-ZHBD-3-0','1','2.860','2.860','TOKO','INPUT1','TOKO','BKMF');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKMF' WHERE kode_barang='MTCN-ZHBD-3-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-08-24','TOKO','BKMF','MTCN','MTCN-ZHBD-3-0','100.00','1','2.860','2.850','1','2.860','2.850');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.860',berat_out_asli=berat_out_asli+'2.850',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-08-24' AND kode_barang='MTCN-ZHBD-3-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260824-0001','4','MTCN-ZHBD-4-0','1','5.580','5.580','TOKO','INPUT1','TOKO','BKMF');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKMF' WHERE kode_barang='MTCN-ZHBD-4-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-08-24','TOKO','BKMF','MTCN','MTCN-ZHBD-4-0','100.00','1','5.580','5.570','1','5.580','5.570');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'5.580',berat_out_asli=berat_out_asli+'5.570',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-08-24' AND kode_barang='MTCN-ZHBD-4-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260824-0001','5','MTCN-ZHBD-5-0','1','3.420','3.420','TOKO','INPUT1','TOKO','BKMF');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKMF' WHERE kode_barang='MTCN-ZHBD-5-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-08-24','TOKO','BKMF','MTCN','MTCN-ZHBD-5-0','100.00','1','3.420','3.410','1','3.420','3.410');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'3.420',berat_out_asli=berat_out_asli+'3.410',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-08-24' AND kode_barang='MTCN-ZHBD-5-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260824-0001','6','MTCN-ZHBD-6-0','1','3.230','3.230','TOKO','INPUT1','TOKO','BKMF');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKMF' WHERE kode_barang='MTCN-ZHBD-6-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-08-24','TOKO','BKMF','MTCN','MTCN-ZHBD-6-0','100.00','1','3.230','3.220','1','3.230','3.220');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'3.230',berat_out_asli=berat_out_asli+'3.220',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-08-24' AND kode_barang='MTCN-ZHBD-6-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260824-0001','7','MTCN-ZHBD-7-0','1','3.020','3.020','TOKO','INPUT1','TOKO','BKMF');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKMF' WHERE kode_barang='MTCN-ZHBD-7-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-08-24','TOKO','BKMF','MTCN','MTCN-ZHBD-7-0','100.00','1','3.020','3.010','1','3.020','3.010');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'3.020',berat_out_asli=berat_out_asli+'3.010',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-08-24' AND kode_barang='MTCN-ZHBD-7-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260824-0001','8','MTCN-ZHBD-8-0','1','3.560','3.560','TOKO','INPUT1','TOKO','BKMF');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKMF' WHERE kode_barang='MTCN-ZHBD-8-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-08-24','TOKO','BKMF','MTCN','MTCN-ZHBD-8-0','100.00','1','3.560','3.550','1','3.560','3.550');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'3.560',berat_out_asli=berat_out_asli+'3.550',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-08-24' AND kode_barang='MTCN-ZHBD-8-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260824-0001','9','MTCN-ZHBD-9-0','1','2.700','2.700','TOKO','INPUT1','TOKO','BKMF');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKMF' WHERE kode_barang='MTCN-ZHBD-9-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-08-24','TOKO','BKMF','MTCN','MTCN-ZHBD-9-0','100.00','1','2.700','2.690','1','2.700','2.690');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.700',berat_out_asli=berat_out_asli+'2.690',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-08-24' AND kode_barang='MTCN-ZHBD-9-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260824-0001','10','MTCN-ZHBD-10-0','1','3.120','3.120','TOKO','INPUT1','TOKO','BKMF');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKMF' WHERE kode_barang='MTCN-ZHBD-10-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-08-24','TOKO','BKMF','MTCN','MTCN-ZHBD-10-0','100.00','1','3.120','3.110','1','3.120','3.110');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'3.120',berat_out_asli=berat_out_asli+'3.110',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-08-24' AND kode_barang='MTCN-ZHBD-10-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES('PB-260824-0001','2026-08-24','2026-08-24','12:37','35.18','adminpusat','2026-08-24 12:40:37');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-08-24 ','12:42:15');
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260824-0002','1','MTGL-ZHBD-11-0','1','18.270','18.270','TOKO','INPUT1','TOKO','BKMF');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKMF' WHERE kode_barang='MTGL-ZHBD-11-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-08-24','TOKO','BKMF','MTGL','MTGL-ZHBD-11-0','100.00','1','18.270','18.260','1','18.270','18.260');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'18.270',berat_out_asli=berat_out_asli+'18.260',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-08-24' AND kode_barang='MTGL-ZHBD-11-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260824-0002','2','MTGL-ZHBD-12-0','1','27.490','27.490','TOKO','INPUT1','TOKO','BKMF');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKMF' WHERE kode_barang='MTGL-ZHBD-12-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-08-24','TOKO','BKMF','MTGL','MTGL-ZHBD-12-0','100.00','1','27.490','27.480','1','27.490','27.480');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'27.490',berat_out_asli=berat_out_asli+'27.480',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-08-24' AND kode_barang='MTGL-ZHBD-12-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES('PB-260824-0002','2026-08-24','2026-08-24','12:44','45.76','adminpusat','2026-08-24 12:45:04');
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260824-0003','1','MTCN-ZHBD-1-0','1','3.250','3.250','TOKO','BKMF','TOKO','INPUT1');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='INPUT1' WHERE kode_barang='MTCN-ZHBD-1-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='BKMF';
UPDATE tt_barang_saldo SET stock_in=stock_in+1 ,berat_in= berat_in+'3.250',berat_in_asli=berat_in_asli+'3.240',stock_akhir=stock_akhir+1, berat_akhir=berat_akhir+'3.250',berat_akhir_asli=berat_akhir_asli+'3.240' WHERE tanggal='2026-08-24' AND kode_barang='MTCN-ZHBD-1-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'3.250',berat_out_asli=berat_out_asli+'3.240',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-08-24' AND kode_barang='MTCN-ZHBD-1-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='BKMF' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260824-0003','2','MTCN-ZHBD-2-0','1','4.440','4.440','TOKO','BKMF','TOKO','INPUT1');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='INPUT1' WHERE kode_barang='MTCN-ZHBD-2-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='BKMF';
UPDATE tt_barang_saldo SET stock_in=stock_in+1 ,berat_in= berat_in+'4.440',berat_in_asli=berat_in_asli+'4.430',stock_akhir=stock_akhir+1, berat_akhir=berat_akhir+'4.440',berat_akhir_asli=berat_akhir_asli+'4.430' WHERE tanggal='2026-08-24' AND kode_barang='MTCN-ZHBD-2-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'4.440',berat_out_asli=berat_out_asli+'4.430',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-08-24' AND kode_barang='MTCN-ZHBD-2-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='BKMF' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260824-0003','3','MTCN-ZHBD-3-0','1','2.860','2.860','TOKO','BKMF','TOKO','INPUT1');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='INPUT1' WHERE kode_barang='MTCN-ZHBD-3-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='BKMF';
UPDATE tt_barang_saldo SET stock_in=stock_in+1 ,berat_in= berat_in+'2.860',berat_in_asli=berat_in_asli+'2.850',stock_akhir=stock_akhir+1, berat_akhir=berat_akhir+'2.860',berat_akhir_asli=berat_akhir_asli+'2.850' WHERE tanggal='2026-08-24' AND kode_barang='MTCN-ZHBD-3-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.860',berat_out_asli=berat_out_asli+'2.850',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-08-24' AND kode_barang='MTCN-ZHBD-3-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='BKMF' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260824-0003','4','MTCN-ZHBD-4-0','1','5.580','5.580','TOKO','BKMF','TOKO','INPUT1');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='INPUT1' WHERE kode_barang='MTCN-ZHBD-4-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='BKMF';
UPDATE tt_barang_saldo SET stock_in=stock_in+1 ,berat_in= berat_in+'5.580',berat_in_asli=berat_in_asli+'5.570',stock_akhir=stock_akhir+1, berat_akhir=berat_akhir+'5.580',berat_akhir_asli=berat_akhir_asli+'5.570' WHERE tanggal='2026-08-24' AND kode_barang='MTCN-ZHBD-4-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'5.580',berat_out_asli=berat_out_asli+'5.570',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-08-24' AND kode_barang='MTCN-ZHBD-4-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='BKMF' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260824-0003','5','MTCN-ZHBD-5-0','1','3.420','3.420','TOKO','BKMF','TOKO','INPUT1');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='INPUT1' WHERE kode_barang='MTCN-ZHBD-5-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='BKMF';
UPDATE tt_barang_saldo SET stock_in=stock_in+1 ,berat_in= berat_in+'3.420',berat_in_asli=berat_in_asli+'3.410',stock_akhir=stock_akhir+1, berat_akhir=berat_akhir+'3.420',berat_akhir_asli=berat_akhir_asli+'3.410' WHERE tanggal='2026-08-24' AND kode_barang='MTCN-ZHBD-5-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'3.420',berat_out_asli=berat_out_asli+'3.410',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-08-24' AND kode_barang='MTCN-ZHBD-5-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='BKMF' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260824-0003','6','MTCN-ZHBD-6-0','1','3.230','3.230','TOKO','BKMF','TOKO','INPUT1');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='INPUT1' WHERE kode_barang='MTCN-ZHBD-6-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='BKMF';
UPDATE tt_barang_saldo SET stock_in=stock_in+1 ,berat_in= berat_in+'3.230',berat_in_asli=berat_in_asli+'3.220',stock_akhir=stock_akhir+1, berat_akhir=berat_akhir+'3.230',berat_akhir_asli=berat_akhir_asli+'3.220' WHERE tanggal='2026-08-24' AND kode_barang='MTCN-ZHBD-6-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'3.230',berat_out_asli=berat_out_asli+'3.220',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-08-24' AND kode_barang='MTCN-ZHBD-6-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='BKMF' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260824-0003','7','MTCN-ZHBD-7-0','1','3.020','3.020','TOKO','BKMF','TOKO','INPUT1');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='INPUT1' WHERE kode_barang='MTCN-ZHBD-7-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='BKMF';
UPDATE tt_barang_saldo SET stock_in=stock_in+1 ,berat_in= berat_in+'3.020',berat_in_asli=berat_in_asli+'3.010',stock_akhir=stock_akhir+1, berat_akhir=berat_akhir+'3.020',berat_akhir_asli=berat_akhir_asli+'3.010' WHERE tanggal='2026-08-24' AND kode_barang='MTCN-ZHBD-7-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'3.020',berat_out_asli=berat_out_asli+'3.010',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-08-24' AND kode_barang='MTCN-ZHBD-7-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='BKMF' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260824-0003','8','MTCN-ZHBD-8-0','1','3.560','3.560','TOKO','BKMF','TOKO','INPUT1');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='INPUT1' WHERE kode_barang='MTCN-ZHBD-8-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='BKMF';
UPDATE tt_barang_saldo SET stock_in=stock_in+1 ,berat_in= berat_in+'3.560',berat_in_asli=berat_in_asli+'3.550',stock_akhir=stock_akhir+1, berat_akhir=berat_akhir+'3.560',berat_akhir_asli=berat_akhir_asli+'3.550' WHERE tanggal='2026-08-24' AND kode_barang='MTCN-ZHBD-8-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'3.560',berat_out_asli=berat_out_asli+'3.550',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-08-24' AND kode_barang='MTCN-ZHBD-8-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='BKMF' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260824-0003','9','MTCN-ZHBD-9-0','1','2.700','2.700','TOKO','BKMF','TOKO','INPUT1');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='INPUT1' WHERE kode_barang='MTCN-ZHBD-9-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='BKMF';
UPDATE tt_barang_saldo SET stock_in=stock_in+1 ,berat_in= berat_in+'2.700',berat_in_asli=berat_in_asli+'2.690',stock_akhir=stock_akhir+1, berat_akhir=berat_akhir+'2.700',berat_akhir_asli=berat_akhir_asli+'2.690' WHERE tanggal='2026-08-24' AND kode_barang='MTCN-ZHBD-9-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.700',berat_out_asli=berat_out_asli+'2.690',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-08-24' AND kode_barang='MTCN-ZHBD-9-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='BKMF' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260824-0003','10','MTCN-ZHBD-10-0','1','3.120','3.120','TOKO','BKMF','TOKO','INPUT1');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='INPUT1' WHERE kode_barang='MTCN-ZHBD-10-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='BKMF';
UPDATE tt_barang_saldo SET stock_in=stock_in+1 ,berat_in= berat_in+'3.120',berat_in_asli=berat_in_asli+'3.110',stock_akhir=stock_akhir+1, berat_akhir=berat_akhir+'3.120',berat_akhir_asli=berat_akhir_asli+'3.110' WHERE tanggal='2026-08-24' AND kode_barang='MTCN-ZHBD-10-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'3.120',berat_out_asli=berat_out_asli+'3.110',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-08-24' AND kode_barang='MTCN-ZHBD-10-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='BKMF' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260824-0003','11','MTGL-ZHBD-11-0','1','18.270','18.270','TOKO','BKMF','TOKO','INPUT1');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='INPUT1' WHERE kode_barang='MTGL-ZHBD-11-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='BKMF';
UPDATE tt_barang_saldo SET stock_in=stock_in+1 ,berat_in= berat_in+'18.270',berat_in_asli=berat_in_asli+'18.260',stock_akhir=stock_akhir+1, berat_akhir=berat_akhir+'18.270',berat_akhir_asli=berat_akhir_asli+'18.260' WHERE tanggal='2026-08-24' AND kode_barang='MTGL-ZHBD-11-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'18.270',berat_out_asli=berat_out_asli+'18.260',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-08-24' AND kode_barang='MTGL-ZHBD-11-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='BKMF' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260824-0003','12','MTGL-ZHBD-12-0','1','27.490','27.490','TOKO','BKMF','TOKO','INPUT1');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='INPUT1' WHERE kode_barang='MTGL-ZHBD-12-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='BKMF';
UPDATE tt_barang_saldo SET stock_in=stock_in+1 ,berat_in= berat_in+'27.490',berat_in_asli=berat_in_asli+'27.480',stock_akhir=stock_akhir+1, berat_akhir=berat_akhir+'27.490',berat_akhir_asli=berat_akhir_asli+'27.480' WHERE tanggal='2026-08-24' AND kode_barang='MTGL-ZHBD-12-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'27.490',berat_out_asli=berat_out_asli+'27.480',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-08-24' AND kode_barang='MTGL-ZHBD-12-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='BKMF' AND stock_akhir > 0;
INSERT INTO tt_pindah_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES('PB-260824-0003','2026-08-24','2026-08-24','12:46','80.94','adminpusat','2026-08-24 12:48:40');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-08-24 ','12:54:57');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-08-24 ','13:06:23');
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260824-0004','1','MTCN-ZHBD-1-0','1','3.250','3.250','TOKO','INPUT1','TOKO','BKMF');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKMF' WHERE kode_barang='MTCN-ZHBD-1-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
UPDATE tt_barang_saldo SET stock_in=stock_in+1 ,berat_in= berat_in+'3.250',berat_in_asli=berat_in_asli+'3.240',stock_akhir=stock_akhir+1, berat_akhir=berat_akhir+'3.250',berat_akhir_asli=berat_akhir_asli+'3.240' WHERE tanggal='2026-08-24' AND kode_barang='MTCN-ZHBD-1-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='BKMF';
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'3.250',berat_out_asli=berat_out_asli+'3.240',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-08-24' AND kode_barang='MTCN-ZHBD-1-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260824-0004','2','MTCN-ZHBD-2-0','1','4.440','4.440','TOKO','INPUT1','TOKO','BKMF');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKMF' WHERE kode_barang='MTCN-ZHBD-2-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
UPDATE tt_barang_saldo SET stock_in=stock_in+1 ,berat_in= berat_in+'4.440',berat_in_asli=berat_in_asli+'4.430',stock_akhir=stock_akhir+1, berat_akhir=berat_akhir+'4.440',berat_akhir_asli=berat_akhir_asli+'4.430' WHERE tanggal='2026-08-24' AND kode_barang='MTCN-ZHBD-2-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='BKMF';
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'4.440',berat_out_asli=berat_out_asli+'4.430',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-08-24' AND kode_barang='MTCN-ZHBD-2-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260824-0004','3','MTCN-ZHBD-3-0','1','2.860','2.860','TOKO','INPUT1','TOKO','BKMF');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKMF' WHERE kode_barang='MTCN-ZHBD-3-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
UPDATE tt_barang_saldo SET stock_in=stock_in+1 ,berat_in= berat_in+'2.860',berat_in_asli=berat_in_asli+'2.850',stock_akhir=stock_akhir+1, berat_akhir=berat_akhir+'2.860',berat_akhir_asli=berat_akhir_asli+'2.850' WHERE tanggal='2026-08-24' AND kode_barang='MTCN-ZHBD-3-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='BKMF';
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.860',berat_out_asli=berat_out_asli+'2.850',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-08-24' AND kode_barang='MTCN-ZHBD-3-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260824-0004','4','MTCN-ZHBD-4-0','1','5.580','5.580','TOKO','INPUT1','TOKO','BKMF');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKMF' WHERE kode_barang='MTCN-ZHBD-4-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
UPDATE tt_barang_saldo SET stock_in=stock_in+1 ,berat_in= berat_in+'5.580',berat_in_asli=berat_in_asli+'5.570',stock_akhir=stock_akhir+1, berat_akhir=berat_akhir+'5.580',berat_akhir_asli=berat_akhir_asli+'5.570' WHERE tanggal='2026-08-24' AND kode_barang='MTCN-ZHBD-4-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='BKMF';
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'5.580',berat_out_asli=berat_out_asli+'5.570',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-08-24' AND kode_barang='MTCN-ZHBD-4-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260824-0004','5','MTCN-ZHBD-5-0','1','3.420','3.420','TOKO','INPUT1','TOKO','BKMF');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKMF' WHERE kode_barang='MTCN-ZHBD-5-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
UPDATE tt_barang_saldo SET stock_in=stock_in+1 ,berat_in= berat_in+'3.420',berat_in_asli=berat_in_asli+'3.410',stock_akhir=stock_akhir+1, berat_akhir=berat_akhir+'3.420',berat_akhir_asli=berat_akhir_asli+'3.410' WHERE tanggal='2026-08-24' AND kode_barang='MTCN-ZHBD-5-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='BKMF';
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'3.420',berat_out_asli=berat_out_asli+'3.410',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-08-24' AND kode_barang='MTCN-ZHBD-5-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260824-0004','6','MTCN-ZHBD-6-0','1','3.230','3.230','TOKO','INPUT1','TOKO','BKMF');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKMF' WHERE kode_barang='MTCN-ZHBD-6-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
UPDATE tt_barang_saldo SET stock_in=stock_in+1 ,berat_in= berat_in+'3.230',berat_in_asli=berat_in_asli+'3.220',stock_akhir=stock_akhir+1, berat_akhir=berat_akhir+'3.230',berat_akhir_asli=berat_akhir_asli+'3.220' WHERE tanggal='2026-08-24' AND kode_barang='MTCN-ZHBD-6-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='BKMF';
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'3.230',berat_out_asli=berat_out_asli+'3.220',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-08-24' AND kode_barang='MTCN-ZHBD-6-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260824-0004','7','MTCN-ZHBD-7-0','1','3.020','3.020','TOKO','INPUT1','TOKO','BKMF');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKMF' WHERE kode_barang='MTCN-ZHBD-7-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
UPDATE tt_barang_saldo SET stock_in=stock_in+1 ,berat_in= berat_in+'3.020',berat_in_asli=berat_in_asli+'3.010',stock_akhir=stock_akhir+1, berat_akhir=berat_akhir+'3.020',berat_akhir_asli=berat_akhir_asli+'3.010' WHERE tanggal='2026-08-24' AND kode_barang='MTCN-ZHBD-7-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='BKMF';
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'3.020',berat_out_asli=berat_out_asli+'3.010',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-08-24' AND kode_barang='MTCN-ZHBD-7-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260824-0004','8','MTCN-ZHBD-8-0','1','3.560','3.560','TOKO','INPUT1','TOKO','BKMF');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKMF' WHERE kode_barang='MTCN-ZHBD-8-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
UPDATE tt_barang_saldo SET stock_in=stock_in+1 ,berat_in= berat_in+'3.560',berat_in_asli=berat_in_asli+'3.550',stock_akhir=stock_akhir+1, berat_akhir=berat_akhir+'3.560',berat_akhir_asli=berat_akhir_asli+'3.550' WHERE tanggal='2026-08-24' AND kode_barang='MTCN-ZHBD-8-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='BKMF';
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'3.560',berat_out_asli=berat_out_asli+'3.550',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-08-24' AND kode_barang='MTCN-ZHBD-8-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260824-0004','9','MTCN-ZHBD-9-0','1','2.700','2.700','TOKO','INPUT1','TOKO','BKMF');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKMF' WHERE kode_barang='MTCN-ZHBD-9-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
UPDATE tt_barang_saldo SET stock_in=stock_in+1 ,berat_in= berat_in+'2.700',berat_in_asli=berat_in_asli+'2.690',stock_akhir=stock_akhir+1, berat_akhir=berat_akhir+'2.700',berat_akhir_asli=berat_akhir_asli+'2.690' WHERE tanggal='2026-08-24' AND kode_barang='MTCN-ZHBD-9-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='BKMF';
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.700',berat_out_asli=berat_out_asli+'2.690',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-08-24' AND kode_barang='MTCN-ZHBD-9-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260824-0004','10','MTCN-ZHBD-10-0','1','3.120','3.120','TOKO','INPUT1','TOKO','BKMF');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKMF' WHERE kode_barang='MTCN-ZHBD-10-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
UPDATE tt_barang_saldo SET stock_in=stock_in+1 ,berat_in= berat_in+'3.120',berat_in_asli=berat_in_asli+'3.110',stock_akhir=stock_akhir+1, berat_akhir=berat_akhir+'3.120',berat_akhir_asli=berat_akhir_asli+'3.110' WHERE tanggal='2026-08-24' AND kode_barang='MTCN-ZHBD-10-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='BKMF';
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'3.120',berat_out_asli=berat_out_asli+'3.110',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-08-24' AND kode_barang='MTCN-ZHBD-10-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES('PB-260824-0004','2026-08-24','2026-08-24','13:06','35.18','adminpusat','2026-08-24 13:07:35');
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260824-0005','1','MTGL-ZHBD-11-0','1','18.270','18.270','TOKO','INPUT1','TOKO','BKMF');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKMF' WHERE kode_barang='MTGL-ZHBD-11-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
UPDATE tt_barang_saldo SET stock_in=stock_in+1 ,berat_in= berat_in+'18.270',berat_in_asli=berat_in_asli+'18.260',stock_akhir=stock_akhir+1, berat_akhir=berat_akhir+'18.270',berat_akhir_asli=berat_akhir_asli+'18.260' WHERE tanggal='2026-08-24' AND kode_barang='MTGL-ZHBD-11-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='BKMF';
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'18.270',berat_out_asli=berat_out_asli+'18.260',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-08-24' AND kode_barang='MTGL-ZHBD-11-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260824-0005','2','MTGL-ZHBD-12-0','1','27.490','27.490','TOKO','INPUT1','TOKO','BKMF');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKMF' WHERE kode_barang='MTGL-ZHBD-12-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
UPDATE tt_barang_saldo SET stock_in=stock_in+1 ,berat_in= berat_in+'27.490',berat_in_asli=berat_in_asli+'27.480',stock_akhir=stock_akhir+1, berat_akhir=berat_akhir+'27.490',berat_akhir_asli=berat_akhir_asli+'27.480' WHERE tanggal='2026-08-24' AND kode_barang='MTGL-ZHBD-12-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='BKMF';
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'27.490',berat_out_asli=berat_out_asli+'27.480',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-08-24' AND kode_barang='MTGL-ZHBD-12-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES('PB-260824-0005','2026-08-24','2026-08-24','13:08','45.76','adminpusat','2026-08-24 13:09:10');
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260824-0006','1','MTKL-ZHBD-13-0','1','19.430','19.430','TOKO','INPUT1','TOKO','BKMF');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKMF' WHERE kode_barang='MTKL-ZHBD-13-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-08-24','TOKO','BKMF','MTKL','MTKL-ZHBD-13-0','100.00','1','19.430','19.420','1','19.430','19.420');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'19.430',berat_out_asli=berat_out_asli+'19.420',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-08-24' AND kode_barang='MTKL-ZHBD-13-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260824-0006','2','MTKL-ZHBD-14-0','1','19.430','19.430','TOKO','INPUT1','TOKO','BKMF');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKMF' WHERE kode_barang='MTKL-ZHBD-14-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-08-24','TOKO','BKMF','MTKL','MTKL-ZHBD-14-0','100.00','1','19.430','19.420','1','19.430','19.420');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'19.430',berat_out_asli=berat_out_asli+'19.420',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-08-24' AND kode_barang='MTKL-ZHBD-14-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260824-0006','3','MTKL-ZHBD-15-0','1','16.130','16.130','TOKO','INPUT1','TOKO','BKMF');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKMF' WHERE kode_barang='MTKL-ZHBD-15-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-08-24','TOKO','BKMF','MTKL','MTKL-ZHBD-15-0','100.00','1','16.130','16.120','1','16.130','16.120');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'16.130',berat_out_asli=berat_out_asli+'16.120',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-08-24' AND kode_barang='MTKL-ZHBD-15-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES('PB-260824-0006','2026-08-24','2026-08-24','13:09','54.99','adminpusat','2026-08-24 13:11:23');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-08-24 ','13:15:07');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MTLT-ZHBD-16-0','00031135',' ','BROSS BUNGA SHB ','','GR','---','MT','MTLT','TOKO','INPUT1','5797000','2026-08-24','5797000','3.100','100.00','16','0','1870000.00','1','0.045', 'adminpusat','2026-08-24 13:18:28','3.090','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MTLT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTLT','MTLT-ZHBD-16-0','00031135');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-08-24','MTLT-ZHBD-16-0','MTLT','TOKO','INPUT1','100.00','3.100','3.090','1','3.100','3.090','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MTLT-ZHBD-17-0','00031136',' ','BROSS KUPU SHB ','','GR','---','MT','MTLT','TOKO','INPUT1','5535500','2026-08-24','5535500','2.960','100.00','16','0','1870000.00','1','0.045', 'adminpusat','2026-08-24 13:20:01','2.950','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MTLT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTLT','MTLT-ZHBD-17-0','00031136');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-08-24','MTLT-ZHBD-17-0','MTLT','TOKO','INPUT1','100.00','2.960','2.950','1','2.960','2.950','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MTLT-ZHBD-18-0','00031137',' ','TUSPIN BUNGA SHB ','','GR','---','MT','MTLT','TOKO','INPUT1','6788500','2026-08-24','6788500','3.630','100.00','16','0','1870000.00','1','0.045', 'adminpusat','2026-08-24 13:23:03','3.620','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MTLT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTLT','MTLT-ZHBD-18-0','00031137');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-08-24','MTLT-ZHBD-18-0','MTLT','TOKO','INPUT1','100.00','3.630','3.620','1','3.630','3.620','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MTLT-ZHBD-19-0','00031138',' ','TUSPIN BUNGA SHB ','','GR','---','MT','MTLT','TOKO','INPUT1','6377000','2026-08-24','6377000','3.410','100.00','16','0','1870000.00','1','0.045', 'adminpusat','2026-08-24 13:26:06','3.400','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MTLT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTLT','MTLT-ZHBD-19-0','00031138');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-08-24','MTLT-ZHBD-19-0','MTLT','TOKO','INPUT1','100.00','3.410','3.400','1','3.410','3.400','1');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-08-24 ','13:28:12');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MTLT-ZHBD-20-0','00031139',' ','TUSPIN VC SLP BT MK ','','GR','---','MT','MTLT','TOKO','INPUT1','4675000','2026-08-24','4675000','2.500','100.00','16','0','1870000.00','1','0.045', 'adminpusat','2026-08-24 13:29:38','2.490','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MTLT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTLT','MTLT-ZHBD-20-0','00031139');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-08-24','MTLT-ZHBD-20-0','MTLT','TOKO','INPUT1','100.00','2.500','2.490','1','2.500','2.490','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MTLT-ZHBD-21-0','00031140',' ','LT COR CAT MK ','','GR','---','MT','MTLT','TOKO','INPUT1','2150500','2026-08-24','2150500','1.150','100.00','16','0','1870000.00','1','0.045', 'adminpusat','2026-08-24 13:31:08','1.140','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MTLT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTLT','MTLT-ZHBD-21-0','00031140');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-08-24','MTLT-ZHBD-21-0','MTLT','TOKO','INPUT1','100.00','1.150','1.140','1','1.150','1.140','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MTLT-ZHBD-22-0','00031141',' ','LT COR CAT MK ','','GR','---','MT','MTLT','TOKO','INPUT1','2132000','2026-08-24','2132000','1.140','100.00','16','0','1870000.00','1','0.045', 'adminpusat','2026-08-24 13:33:18','1.130','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MTLT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTLT','MTLT-ZHBD-22-0','00031141');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-08-24','MTLT-ZHBD-22-0','MTLT','TOKO','INPUT1','100.00','1.140','1.130','1','1.140','1.130','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MTLT-ZHBD-23-0','00031142',' ','LT COR CAT MK ','','GR','---','MT','MTLT','TOKO','INPUT1','2300500','2026-08-24','2300500','1.230','100.00','16','0','1870000.00','1','0.045', 'adminpusat','2026-08-24 13:34:13','1.220','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MTLT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTLT','MTLT-ZHBD-23-0','00031142');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-08-24','MTLT-ZHBD-23-0','MTLT','TOKO','INPUT1','100.00','1.230','1.220','1','1.230','1.220','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MTLT-ZHBD-24-0','00031143',' ','LT CAP BT SHB ','','GR','---','MT','MTLT','TOKO','INPUT1','2394000','2026-08-24','2394000','1.280','100.00','16','0','1870000.00','1','0.045', 'adminpusat','2026-08-24 13:39:19','1.270','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MTLT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTLT','MTLT-ZHBD-24-0','00031143');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-08-24','MTLT-ZHBD-24-0','MTLT','TOKO','INPUT1','100.00','1.280','1.270','1','1.280','1.270','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MTLT-ZHBD-25-0','00031144',' ','LT COR BT SLP SHB ','','GR','---','MT','MTLT','TOKO','INPUT1','2394000','2026-08-24','2394000','1.280','100.00','16','0','1870000.00','1','0.045', 'adminpusat','2026-08-24 13:41:09','1.270','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MTLT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTLT','MTLT-ZHBD-25-0','00031144');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-08-24','MTLT-ZHBD-25-0','MTLT','TOKO','INPUT1','100.00','1.280','1.270','1','1.280','1.270','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MTLT-ZHBD-26-0','00031145',' ','LT COR BT HURUF G SHB ','','GR','---','MT','MTLT','TOKO','INPUT1','2524500','2026-08-24','2524500','1.350','100.00','16','0','1870000.00','1','0.045', 'adminpusat','2026-08-24 13:42:16','1.340','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MTLT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTLT','MTLT-ZHBD-26-0','00031145');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-08-24','MTLT-ZHBD-26-0','MTLT','TOKO','INPUT1','100.00','1.350','1.340','1','1.350','1.340','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MTLT-ZHBD-27-0','00031146',' ','LT CAP BT SHB ','','GR','---','MT','MTLT','TOKO','INPUT1','1047500','2026-08-24','1047500','0.560','100.00','16','0','1870000.00','1','0.045', 'adminpusat','2026-08-24 13:43:26','0.550','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MTLT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTLT','MTLT-ZHBD-27-0','00031146');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-08-24','MTLT-ZHBD-27-0','MTLT','TOKO','INPUT1','100.00','0.560','0.550','1','0.560','0.550','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MTLT-ZHBD-28-0','00031147',' ','LT CAP BT SHB ','','GR','---','MT','MTLT','TOKO','INPUT1','1047500','2026-08-24','1047500','0.560','100.00','16','0','1870000.00','1','0.045', 'adminpusat','2026-08-24 13:44:20','0.550','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MTLT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTLT','MTLT-ZHBD-28-0','00031147');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-08-24','MTLT-ZHBD-28-0','MTLT','TOKO','INPUT1','100.00','0.560','0.550','1','0.560','0.550','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MTLT-ZHBD-29-0','00031148',' ','LT CAP BT SHB ','','GR','---','MT','MTLT','TOKO','INPUT1','1066000','2026-08-24','1066000','0.570','100.00','16','0','1870000.00','1','0.045', 'adminpusat','2026-08-24 13:51:37','0.560','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MTLT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTLT','MTLT-ZHBD-29-0','00031148');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-08-24','MTLT-ZHBD-29-0','MTLT','TOKO','INPUT1','100.00','0.570','0.560','1','0.570','0.560','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MTLT-ZHBD-30-0','00031149',' ','LT CAP BT SHB ','','GR','---','MT','MTLT','TOKO','INPUT1','1029000','2026-08-24','1029000','0.550','100.00','16','0','1870000.00','1','0.045', 'adminpusat','2026-08-24 13:52:23','0.540','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MTLT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTLT','MTLT-ZHBD-30-0','00031149');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-08-24','MTLT-ZHBD-30-0','MTLT','TOKO','INPUT1','100.00','0.550','0.540','1','0.550','0.540','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MTLT-ZHBD-31-0','00031150',' ','LT CAP BT SHB ','','GR','---','MT','MTLT','TOKO','INPUT1','1029000','2026-08-24','1029000','0.550','100.00','16','0','1870000.00','1','0.045', 'adminpusat','2026-08-24 13:53:47','0.540','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MTLT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTLT','MTLT-ZHBD-31-0','00031150');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-08-24','MTLT-ZHBD-31-0','MTLT','TOKO','INPUT1','100.00','0.550','0.540','1','0.550','0.540','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MTLT-ZHBD-32-0','00031151',' ','LT CAP PLAT SHB ','','GR','---','MT','MTLT','TOKO','INPUT1','2113500','2026-08-24','2113500','1.130','100.00','16','0','1870000.00','1','0.045', 'adminpusat','2026-08-24 13:55:08','1.120','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MTLT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTLT','MTLT-ZHBD-32-0','00031151');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-08-24','MTLT-ZHBD-32-0','MTLT','TOKO','INPUT1','100.00','1.130','1.120','1','1.130','1.120','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MTLT-ZHBD-33-0','00031152',' ','LT CAP PLAT SHB ','','GR','---','MT','MTLT','TOKO','INPUT1','2281500','2026-08-24','2281500','1.220','100.00','16','0','1870000.00','1','0.045', 'adminpusat','2026-08-24 13:55:57','1.210','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MTLT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTLT','MTLT-ZHBD-33-0','00031152');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-08-24','MTLT-ZHBD-33-0','MTLT','TOKO','INPUT1','100.00','1.220','1.210','1','1.220','1.210','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MTLT-ZHBD-34-0','00031153',' ','LT CAP PLAT SHB ','','GR','---','MT','MTLT','TOKO','INPUT1','2300500','2026-08-24','2300500','1.230','100.00','16','0','1870000.00','1','0.045', 'adminpusat','2026-08-24 13:56:54','1.220','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MTLT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTLT','MTLT-ZHBD-34-0','00031153');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-08-24','MTLT-ZHBD-34-0','MTLT','TOKO','INPUT1','100.00','1.230','1.220','1','1.230','1.220','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MTLT-ZHBD-35-0','00031154','KRW EX ','LT CAP PLAT KRW SHB ','KRW','GR','---','MT','MTLT','TOKO','INPUT1','1608500','2026-08-24','1608500','0.860','100.00','16','0','1870000.00','1','0.045', 'adminpusat','2026-08-24 13:58:26','0.850','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MTLT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTLT','MTLT-ZHBD-35-0','00031154');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-08-24','MTLT-ZHBD-35-0','MTLT','TOKO','INPUT1','100.00','0.860','0.850','1','0.860','0.850','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MTLT-ZHBD-36-0','00031155',' ','LT COR BT HURUF Y SHB ','','GR','---','MT','MTLT','TOKO','INPUT1','2225500','2026-08-24','2225500','1.190','100.00','16','0','1870000.00','1','0.045', 'adminpusat','2026-08-24 13:59:34','1.180','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MTLT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTLT','MTLT-ZHBD-36-0','00031155');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-08-24','MTLT-ZHBD-36-0','MTLT','TOKO','INPUT1','100.00','1.190','1.180','1','1.190','1.180','1');
INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('MTLT-ZHBD-36-0','00031155','00031155','LT COR BT HURUF Y SHB ','LT COR BT HURUF Y SHB','','','2225500','2225500',' 0','0','adminpusat','2026-08-24 14:02:19');
UPDATE tm_barang SET nama_barang='LT COR BT HURUF Y SHB' ,nama_atribut='' ,kode_intern=' EX', kadar_cetak='16.00', potongan='0',tagid='FREETAG',harga_modal='0' WHERE kode_barang='MTLT-ZHBD-36-0' LIMIT 1;
INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('MTLT-ZHBD-27-0','00031146','00031146','LT CAP BT SHB ','LT CAP BT SHB','','','1047500','1047500',' 0','0','adminpusat','2026-08-24 14:02:54');
UPDATE tm_barang SET nama_barang='LT CAP BT SHB' ,nama_atribut='' ,kode_intern=' ', kadar_cetak='16.00', potongan='0',tagid='FREETAG',harga_modal='0' WHERE kode_barang='MTLT-ZHBD-27-0' LIMIT 1;
INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('MTLT-ZHBD-28-0','00031147','00031147','LT CAP BT SHB ','LT CAP BT SHB','','','1047500','1047500',' 0','0','adminpusat','2026-08-24 14:03:58');
UPDATE tm_barang SET nama_barang='LT CAP BT SHB' ,nama_atribut='' ,kode_intern=' ', kadar_cetak='16.00', potongan='0',tagid='FREETAG',harga_modal='0' WHERE kode_barang='MTLT-ZHBD-28-0' LIMIT 1;
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-08-24 ','14:28:45');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MTLT-ZHBD-37-0','00031156','EX ','LT COR TDK BT SMBR PTH BG3 ','','GR','---','MT','MTLT','TOKO','INPUT1','2094500','2026-08-24','2094500','1.120','100.00','16','0','1870000.00','1','0.045', 'adminpusat','2026-08-24 14:30:46','1.110','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MTLT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTLT','MTLT-ZHBD-37-0','00031156');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-08-24','MTLT-ZHBD-37-0','MTLT','TOKO','INPUT1','100.00','1.120','1.110','1','1.120','1.110','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MTLT-ZHBD-38-0','00031157','EX ','LT COR BT SHB ','','GR','---','MT','MTLT','TOKO','INPUT1','4151500','2026-08-24','4151500','2.220','100.00','16','0','1870000.00','1','0.045', 'adminpusat','2026-08-24 14:33:09','2.210','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MTLT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTLT','MTLT-ZHBD-38-0','00031157');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-08-24','MTLT-ZHBD-38-0','MTLT','TOKO','INPUT1','100.00','2.220','2.210','1','2.220','2.210','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MTLT-ZHBD-39-0','00031158','EX ','LT COR BT SHB ','','GR','---','MT','MTLT','TOKO','INPUT1','2543500','2026-08-24','2543500','1.360','100.00','16','0','1870000.00','1','0.045', 'adminpusat','2026-08-24 14:34:21','1.350','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MTLT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTLT','MTLT-ZHBD-39-0','00031158');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-08-24','MTLT-ZHBD-39-0','MTLT','TOKO','INPUT1','100.00','1.360','1.350','1','1.360','1.350','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MTLT-ZHBD-40-0','00031159','EX ','LT COR BT MK ','','GR','---','MT','MTLT','TOKO','INPUT1','3516000','2026-08-24','3516000','1.880','100.00','16','0','1870000.00','1','0.045', 'adminpusat','2026-08-24 14:35:22','1.870','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MTLT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTLT','MTLT-ZHBD-40-0','00031159');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-08-24','MTLT-ZHBD-40-0','MTLT','TOKO','INPUT1','100.00','1.880','1.870','1','1.880','1.870','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MTLT-ZHBD-41-0','00031160','EX ','LT COR BT HURUF L SHB ','','GR','---','MT','MTLT','TOKO','INPUT1','2263000','2026-08-24','2263000','1.210','100.00','16','0','1870000.00','1','0.045', 'adminpusat','2026-08-24 14:37:35','1.200','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MTLT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTLT','MTLT-ZHBD-41-0','00031160');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-08-24','MTLT-ZHBD-41-0','MTLT','TOKO','INPUT1','100.00','1.210','1.200','1','1.210','1.200','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MTLT-ZHBD-42-0','00031161','EX ','LT COR BT HURUF H SHB ','','GR','---','MT','MTLT','TOKO','INPUT1','1889000','2026-08-24','1889000','1.010','100.00','16','0','1870000.00','1','0.045', 'adminpusat','2026-08-24 14:38:48','1.000','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MTLT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTLT','MTLT-ZHBD-42-0','00031161');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-08-24','MTLT-ZHBD-42-0','MTLT','TOKO','INPUT1','100.00','1.010','1.000','1','1.010','1.000','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MTLT-ZHBD-43-0','00031162','EX ','LT COR BT HURUF N SHB ','','GR','---','MT','MTLT','TOKO','INPUT1','2150500','2026-08-24','2150500','1.150','100.00','16','0','1870000.00','1','0.045', 'adminpusat','2026-08-24 14:40:20','1.140','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MTLT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTLT','MTLT-ZHBD-43-0','00031162');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-08-24','MTLT-ZHBD-43-0','MTLT','TOKO','INPUT1','100.00','1.150','1.140','1','1.150','1.140','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MTLT-ZHBD-44-0','00031163','EX ','LT COR BT HURUF M SHB ','','GR','---','MT','MTLT','TOKO','INPUT1','1889000','2026-08-24','1889000','1.010','100.00','16','0','1870000.00','1','0.045', 'adminpusat','2026-08-24 14:41:38','1.000','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MTLT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTLT','MTLT-ZHBD-44-0','00031163');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-08-24','MTLT-ZHBD-44-0','MTLT','TOKO','INPUT1','100.00','1.010','1.000','1','1.010','1.000','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MTLT-ZHBD-45-0','00031164',' ','LT COR BT HURUF T SHB ','','GR','---','MT','MTLT','TOKO','INPUT1','2001000','2026-08-24','2001000','1.070','100.00','16','0','1870000.00','1','0.045', 'adminpusat','2026-08-24 14:44:31','1.060','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MTLT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTLT','MTLT-ZHBD-45-0','00031164');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-08-24','MTLT-ZHBD-45-0','MTLT','TOKO','INPUT1','100.00','1.070','1.060','1','1.070','1.060','1');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-08-24 ','14:46:11');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MTLT-ZHBD-46-0','00031165',' ','LT COR BT HURUF B SHB ','','GR','---','MT','MTLT','TOKO','INPUT1','2581000','2026-08-24','2581000','1.380','100.00','16','0','1870000.00','1','0.045', 'adminpusat','2026-08-24 14:47:51','1.370','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MTLT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTLT','MTLT-ZHBD-46-0','00031165');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-08-24','MTLT-ZHBD-46-0','MTLT','TOKO','INPUT1','100.00','1.380','1.370','1','1.380','1.370','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MTLT-ZHBD-47-0','00031166',' ','LT COR BT CAT UBS ','','GR','---','MT','MTLT','TOKO','INPUT1','2263000','2026-08-24','2263000','1.210','100.00','16','0','1870000.00','1','0.045', 'adminpusat','2026-08-24 14:49:11','1.200','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MTLT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTLT','MTLT-ZHBD-47-0','00031166');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-08-24','MTLT-ZHBD-47-0','MTLT','TOKO','INPUT1','100.00','1.210','1.200','1','1.210','1.200','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MTLT-ZHBD-48-0','00031167',' ','LT COR BT HURUF D SHB ','','GR','---','MT','MTLT','TOKO','INPUT1','2898500','2026-08-24','2898500','1.550','100.00','16','0','1870000.00','1','0.045', 'adminpusat','2026-08-24 14:50:32','1.540','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MTLT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTLT','MTLT-ZHBD-48-0','00031167');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-08-24','MTLT-ZHBD-48-0','MTLT','TOKO','INPUT1','100.00','1.550','1.540','1','1.550','1.540','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MTLT-ZHBD-49-0','00031168',' ','LT COR BT SHB ','','GR','---','MT','MTLT','TOKO','INPUT1','7106000','2026-08-24','7106000','3.800','100.00','16','0','1870000.00','1','0.045', 'adminpusat','2026-08-24 14:51:54','3.790','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MTLT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTLT','MTLT-ZHBD-49-0','00031168');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-08-24','MTLT-ZHBD-49-0','MTLT','TOKO','INPUT1','100.00','3.800','3.790','1','3.800','3.790','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MTLT-ZHBD-50-0','00031169',' ','LT COR BT SHB ','','GR','---','MT','MTLT','TOKO','INPUT1','2244000','2026-08-24','2244000','1.200','100.00','16','0','1870000.00','1','0.045', 'adminpusat','2026-08-24 14:52:49','1.190','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MTLT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTLT','MTLT-ZHBD-50-0','00031169');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-08-24','MTLT-ZHBD-50-0','MTLT','TOKO','INPUT1','100.00','1.200','1.190','1','1.200','1.190','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MTLT-ZHBD-51-0','00031170',' ','LT COR BT MK ','','GR','---','MT','MTLT','TOKO','INPUT1','2487500','2026-08-24','2487500','1.330','100.00','16','0','1870000.00','1','0.045', 'adminpusat','2026-08-24 14:54:00','1.320','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MTLT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTLT','MTLT-ZHBD-51-0','00031170');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-08-24','MTLT-ZHBD-51-0','MTLT','TOKO','INPUT1','100.00','1.330','1.320','1','1.330','1.320','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MTLT-ZHBD-52-0','00031171',' ','LT COR BT MK ','','GR','---','MT','MTLT','TOKO','INPUT1','2581000','2026-08-24','2581000','1.380','100.00','16','0','1870000.00','1','0.045', 'adminpusat','2026-08-24 14:55:12','1.370','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MTLT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTLT','MTLT-ZHBD-52-0','00031171');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-08-24','MTLT-ZHBD-52-0','MTLT','TOKO','INPUT1','100.00','1.380','1.370','1','1.380','1.370','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MTLT-ZHBD-53-0','00031172',' ','LT COR BT CAT SHB ','','GR','---','MT','MTLT','TOKO','INPUT1','1720500','2026-08-24','1720500','0.920','100.00','16','0','1870000.00','1','0.045', 'adminpusat','2026-08-24 14:56:08','0.910','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MTLT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTLT','MTLT-ZHBD-53-0','00031172');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-08-24','MTLT-ZHBD-53-0','MTLT','TOKO','INPUT1','100.00','0.920','0.910','1','0.920','0.910','1');
INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('MTLT-ZHBD-36-0','00031155','00031155','LT COR BT HURUF Y SHB','LT COR BT HURUF Y SHB','','','2225500','2225500',' 0','0','adminpusat','2026-08-24 14:59:23');
UPDATE tm_barang SET nama_barang='LT COR BT HURUF Y SHB' ,nama_atribut='' ,kode_intern='EX', kadar_cetak='16.00', potongan='0',tagid='FREETAG',harga_modal='0' WHERE kode_barang='MTLT-ZHBD-36-0' LIMIT 1;
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-08-24 ','15:47:02');
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260824-0007','1','MTLT-ZHBD-16-0','1','3.100','3.100','TOKO','INPUT1','TOKO','BKLTMT');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKLTMT' WHERE kode_barang='MTLT-ZHBD-16-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-08-24','TOKO','BKLTMT','MTLT','MTLT-ZHBD-16-0','100.00','1','3.100','3.090','1','3.100','3.090');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'3.100',berat_out_asli=berat_out_asli+'3.090',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-08-24' AND kode_barang='MTLT-ZHBD-16-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260824-0007','2','MTLT-ZHBD-17-0','1','2.960','2.960','TOKO','INPUT1','TOKO','BKLTMT');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKLTMT' WHERE kode_barang='MTLT-ZHBD-17-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-08-24','TOKO','BKLTMT','MTLT','MTLT-ZHBD-17-0','100.00','1','2.960','2.950','1','2.960','2.950');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.960',berat_out_asli=berat_out_asli+'2.950',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-08-24' AND kode_barang='MTLT-ZHBD-17-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260824-0007','3','MTLT-ZHBD-18-0','1','3.630','3.630','TOKO','INPUT1','TOKO','BKLTMT');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKLTMT' WHERE kode_barang='MTLT-ZHBD-18-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-08-24','TOKO','BKLTMT','MTLT','MTLT-ZHBD-18-0','100.00','1','3.630','3.620','1','3.630','3.620');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'3.630',berat_out_asli=berat_out_asli+'3.620',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-08-24' AND kode_barang='MTLT-ZHBD-18-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260824-0007','4','MTLT-ZHBD-19-0','1','3.410','3.410','TOKO','INPUT1','TOKO','BKLTMT');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKLTMT' WHERE kode_barang='MTLT-ZHBD-19-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-08-24','TOKO','BKLTMT','MTLT','MTLT-ZHBD-19-0','100.00','1','3.410','3.400','1','3.410','3.400');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'3.410',berat_out_asli=berat_out_asli+'3.400',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-08-24' AND kode_barang='MTLT-ZHBD-19-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260824-0007','5','MTLT-ZHBD-20-0','1','2.500','2.500','TOKO','INPUT1','TOKO','BKLTMT');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKLTMT' WHERE kode_barang='MTLT-ZHBD-20-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-08-24','TOKO','BKLTMT','MTLT','MTLT-ZHBD-20-0','100.00','1','2.500','2.490','1','2.500','2.490');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.500',berat_out_asli=berat_out_asli+'2.490',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-08-24' AND kode_barang='MTLT-ZHBD-20-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260824-0007','6','MTLT-ZHBD-21-0','1','1.150','1.150','TOKO','INPUT1','TOKO','BKLTMT');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKLTMT' WHERE kode_barang='MTLT-ZHBD-21-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-08-24','TOKO','BKLTMT','MTLT','MTLT-ZHBD-21-0','100.00','1','1.150','1.140','1','1.150','1.140');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.150',berat_out_asli=berat_out_asli+'1.140',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-08-24' AND kode_barang='MTLT-ZHBD-21-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260824-0007','7','MTLT-ZHBD-22-0','1','1.140','1.140','TOKO','INPUT1','TOKO','BKLTMT');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKLTMT' WHERE kode_barang='MTLT-ZHBD-22-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-08-24','TOKO','BKLTMT','MTLT','MTLT-ZHBD-22-0','100.00','1','1.140','1.130','1','1.140','1.130');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.140',berat_out_asli=berat_out_asli+'1.130',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-08-24' AND kode_barang='MTLT-ZHBD-22-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260824-0007','8','MTLT-ZHBD-23-0','1','1.230','1.230','TOKO','INPUT1','TOKO','BKLTMT');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKLTMT' WHERE kode_barang='MTLT-ZHBD-23-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-08-24','TOKO','BKLTMT','MTLT','MTLT-ZHBD-23-0','100.00','1','1.230','1.220','1','1.230','1.220');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.230',berat_out_asli=berat_out_asli+'1.220',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-08-24' AND kode_barang='MTLT-ZHBD-23-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260824-0007','9','MTLT-ZHBD-24-0','1','1.280','1.280','TOKO','INPUT1','TOKO','BKLTMT');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKLTMT' WHERE kode_barang='MTLT-ZHBD-24-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-08-24','TOKO','BKLTMT','MTLT','MTLT-ZHBD-24-0','100.00','1','1.280','1.270','1','1.280','1.270');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.280',berat_out_asli=berat_out_asli+'1.270',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-08-24' AND kode_barang='MTLT-ZHBD-24-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260824-0007','10','MTLT-ZHBD-25-0','1','1.280','1.280','TOKO','INPUT1','TOKO','BKLTMT');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKLTMT' WHERE kode_barang='MTLT-ZHBD-25-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-08-24','TOKO','BKLTMT','MTLT','MTLT-ZHBD-25-0','100.00','1','1.280','1.270','1','1.280','1.270');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.280',berat_out_asli=berat_out_asli+'1.270',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-08-24' AND kode_barang='MTLT-ZHBD-25-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260824-0007','11','MTLT-ZHBD-26-0','1','1.350','1.350','TOKO','INPUT1','TOKO','BKLTMT');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKLTMT' WHERE kode_barang='MTLT-ZHBD-26-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-08-24','TOKO','BKLTMT','MTLT','MTLT-ZHBD-26-0','100.00','1','1.350','1.340','1','1.350','1.340');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.350',berat_out_asli=berat_out_asli+'1.340',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-08-24' AND kode_barang='MTLT-ZHBD-26-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260824-0007','12','MTLT-ZHBD-27-0','1','0.560','0.560','TOKO','INPUT1','TOKO','BKLTMT');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKLTMT' WHERE kode_barang='MTLT-ZHBD-27-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-08-24','TOKO','BKLTMT','MTLT','MTLT-ZHBD-27-0','100.00','1','0.560','0.550','1','0.560','0.550');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.560',berat_out_asli=berat_out_asli+'0.550',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-08-24' AND kode_barang='MTLT-ZHBD-27-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260824-0007','13','MTLT-ZHBD-28-0','1','0.560','0.560','TOKO','INPUT1','TOKO','BKLTMT');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKLTMT' WHERE kode_barang='MTLT-ZHBD-28-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-08-24','TOKO','BKLTMT','MTLT','MTLT-ZHBD-28-0','100.00','1','0.560','0.550','1','0.560','0.550');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.560',berat_out_asli=berat_out_asli+'0.550',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-08-24' AND kode_barang='MTLT-ZHBD-28-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260824-0007','14','MTLT-ZHBD-29-0','1','0.570','0.570','TOKO','INPUT1','TOKO','BKLTMT');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKLTMT' WHERE kode_barang='MTLT-ZHBD-29-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-08-24','TOKO','BKLTMT','MTLT','MTLT-ZHBD-29-0','100.00','1','0.570','0.560','1','0.570','0.560');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.570',berat_out_asli=berat_out_asli+'0.560',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-08-24' AND kode_barang='MTLT-ZHBD-29-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260824-0007','15','MTLT-ZHBD-30-0','1','0.550','0.550','TOKO','INPUT1','TOKO','BKLTMT');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKLTMT' WHERE kode_barang='MTLT-ZHBD-30-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-08-24','TOKO','BKLTMT','MTLT','MTLT-ZHBD-30-0','100.00','1','0.550','0.540','1','0.550','0.540');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.550',berat_out_asli=berat_out_asli+'0.540',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-08-24' AND kode_barang='MTLT-ZHBD-30-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260824-0007','16','MTLT-ZHBD-31-0','1','0.550','0.550','TOKO','INPUT1','TOKO','BKLTMT');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKLTMT' WHERE kode_barang='MTLT-ZHBD-31-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-08-24','TOKO','BKLTMT','MTLT','MTLT-ZHBD-31-0','100.00','1','0.550','0.540','1','0.550','0.540');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.550',berat_out_asli=berat_out_asli+'0.540',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-08-24' AND kode_barang='MTLT-ZHBD-31-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260824-0007','17','MTLT-ZHBD-32-0','1','1.130','1.130','TOKO','INPUT1','TOKO','BKLTMT');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKLTMT' WHERE kode_barang='MTLT-ZHBD-32-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-08-24','TOKO','BKLTMT','MTLT','MTLT-ZHBD-32-0','100.00','1','1.130','1.120','1','1.130','1.120');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.130',berat_out_asli=berat_out_asli+'1.120',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-08-24' AND kode_barang='MTLT-ZHBD-32-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260824-0007','18','MTLT-ZHBD-33-0','1','1.220','1.220','TOKO','INPUT1','TOKO','BKLTMT');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKLTMT' WHERE kode_barang='MTLT-ZHBD-33-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-08-24','TOKO','BKLTMT','MTLT','MTLT-ZHBD-33-0','100.00','1','1.220','1.210','1','1.220','1.210');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.220',berat_out_asli=berat_out_asli+'1.210',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-08-24' AND kode_barang='MTLT-ZHBD-33-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260824-0007','19','MTLT-ZHBD-34-0','1','1.230','1.230','TOKO','INPUT1','TOKO','BKLTMT');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKLTMT' WHERE kode_barang='MTLT-ZHBD-34-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-08-24','TOKO','BKLTMT','MTLT','MTLT-ZHBD-34-0','100.00','1','1.230','1.220','1','1.230','1.220');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.230',berat_out_asli=berat_out_asli+'1.220',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-08-24' AND kode_barang='MTLT-ZHBD-34-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260824-0007','20','MTLT-ZHBD-35-0','1','0.860','0.860','TOKO','INPUT1','TOKO','BKLTMT');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKLTMT' WHERE kode_barang='MTLT-ZHBD-35-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-08-24','TOKO','BKLTMT','MTLT','MTLT-ZHBD-35-0','100.00','1','0.860','0.850','1','0.860','0.850');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.860',berat_out_asli=berat_out_asli+'0.850',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-08-24' AND kode_barang='MTLT-ZHBD-35-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260824-0007','21','MTLT-ZHBD-36-0','1','1.190','1.190','TOKO','INPUT1','TOKO','BKLTMT');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKLTMT' WHERE kode_barang='MTLT-ZHBD-36-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-08-24','TOKO','BKLTMT','MTLT','MTLT-ZHBD-36-0','100.00','1','1.190','1.180','1','1.190','1.180');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.190',berat_out_asli=berat_out_asli+'1.180',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-08-24' AND kode_barang='MTLT-ZHBD-36-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260824-0007','22','MTLT-ZHBD-37-0','1','1.120','1.120','TOKO','INPUT1','TOKO','BKLTMT');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKLTMT' WHERE kode_barang='MTLT-ZHBD-37-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-08-24','TOKO','BKLTMT','MTLT','MTLT-ZHBD-37-0','100.00','1','1.120','1.110','1','1.120','1.110');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.120',berat_out_asli=berat_out_asli+'1.110',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-08-24' AND kode_barang='MTLT-ZHBD-37-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260824-0007','23','MTLT-ZHBD-38-0','1','2.220','2.220','TOKO','INPUT1','TOKO','BKLTMT');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKLTMT' WHERE kode_barang='MTLT-ZHBD-38-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-08-24','TOKO','BKLTMT','MTLT','MTLT-ZHBD-38-0','100.00','1','2.220','2.210','1','2.220','2.210');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.220',berat_out_asli=berat_out_asli+'2.210',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-08-24' AND kode_barang='MTLT-ZHBD-38-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260824-0007','24','MTLT-ZHBD-39-0','1','1.360','1.360','TOKO','INPUT1','TOKO','BKLTMT');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKLTMT' WHERE kode_barang='MTLT-ZHBD-39-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-08-24','TOKO','BKLTMT','MTLT','MTLT-ZHBD-39-0','100.00','1','1.360','1.350','1','1.360','1.350');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.360',berat_out_asli=berat_out_asli+'1.350',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-08-24' AND kode_barang='MTLT-ZHBD-39-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260824-0007','25','MTLT-ZHBD-40-0','1','1.880','1.880','TOKO','INPUT1','TOKO','BKLTMT');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKLTMT' WHERE kode_barang='MTLT-ZHBD-40-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-08-24','TOKO','BKLTMT','MTLT','MTLT-ZHBD-40-0','100.00','1','1.880','1.870','1','1.880','1.870');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.880',berat_out_asli=berat_out_asli+'1.870',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-08-24' AND kode_barang='MTLT-ZHBD-40-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260824-0007','26','MTLT-ZHBD-41-0','1','1.210','1.210','TOKO','INPUT1','TOKO','BKLTMT');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKLTMT' WHERE kode_barang='MTLT-ZHBD-41-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-08-24','TOKO','BKLTMT','MTLT','MTLT-ZHBD-41-0','100.00','1','1.210','1.200','1','1.210','1.200');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.210',berat_out_asli=berat_out_asli+'1.200',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-08-24' AND kode_barang='MTLT-ZHBD-41-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260824-0007','27','MTLT-ZHBD-42-0','1','1.010','1.010','TOKO','INPUT1','TOKO','BKLTMT');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKLTMT' WHERE kode_barang='MTLT-ZHBD-42-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-08-24','TOKO','BKLTMT','MTLT','MTLT-ZHBD-42-0','100.00','1','1.010','1.000','1','1.010','1.000');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.010',berat_out_asli=berat_out_asli+'1.000',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-08-24' AND kode_barang='MTLT-ZHBD-42-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260824-0007','28','MTLT-ZHBD-43-0','1','1.150','1.150','TOKO','INPUT1','TOKO','BKLTMT');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKLTMT' WHERE kode_barang='MTLT-ZHBD-43-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-08-24','TOKO','BKLTMT','MTLT','MTLT-ZHBD-43-0','100.00','1','1.150','1.140','1','1.150','1.140');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.150',berat_out_asli=berat_out_asli+'1.140',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-08-24' AND kode_barang='MTLT-ZHBD-43-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260824-0007','29','MTLT-ZHBD-45-0','1','1.070','1.070','TOKO','INPUT1','TOKO','BKLTMT');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKLTMT' WHERE kode_barang='MTLT-ZHBD-45-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-08-24','TOKO','BKLTMT','MTLT','MTLT-ZHBD-45-0','100.00','1','1.070','1.060','1','1.070','1.060');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.070',berat_out_asli=berat_out_asli+'1.060',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-08-24' AND kode_barang='MTLT-ZHBD-45-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260824-0007','30','MTLT-ZHBD-46-0','1','1.380','1.380','TOKO','INPUT1','TOKO','BKLTMT');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKLTMT' WHERE kode_barang='MTLT-ZHBD-46-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-08-24','TOKO','BKLTMT','MTLT','MTLT-ZHBD-46-0','100.00','1','1.380','1.370','1','1.380','1.370');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.380',berat_out_asli=berat_out_asli+'1.370',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-08-24' AND kode_barang='MTLT-ZHBD-46-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260824-0007','31','MTLT-ZHBD-47-0','1','1.210','1.210','TOKO','INPUT1','TOKO','BKLTMT');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKLTMT' WHERE kode_barang='MTLT-ZHBD-47-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-08-24','TOKO','BKLTMT','MTLT','MTLT-ZHBD-47-0','100.00','1','1.210','1.200','1','1.210','1.200');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.210',berat_out_asli=berat_out_asli+'1.200',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-08-24' AND kode_barang='MTLT-ZHBD-47-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260824-0007','32','MTLT-ZHBD-48-0','1','1.550','1.550','TOKO','INPUT1','TOKO','BKLTMT');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKLTMT' WHERE kode_barang='MTLT-ZHBD-48-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-08-24','TOKO','BKLTMT','MTLT','MTLT-ZHBD-48-0','100.00','1','1.550','1.540','1','1.550','1.540');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.550',berat_out_asli=berat_out_asli+'1.540',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-08-24' AND kode_barang='MTLT-ZHBD-48-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260824-0007','33','MTLT-ZHBD-49-0','1','3.800','3.800','TOKO','INPUT1','TOKO','BKLTMT');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKLTMT' WHERE kode_barang='MTLT-ZHBD-49-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-08-24','TOKO','BKLTMT','MTLT','MTLT-ZHBD-49-0','100.00','1','3.800','3.790','1','3.800','3.790');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'3.800',berat_out_asli=berat_out_asli+'3.790',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-08-24' AND kode_barang='MTLT-ZHBD-49-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260824-0007','34','MTLT-ZHBD-50-0','1','1.200','1.200','TOKO','INPUT1','TOKO','BKLTMT');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKLTMT' WHERE kode_barang='MTLT-ZHBD-50-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-08-24','TOKO','BKLTMT','MTLT','MTLT-ZHBD-50-0','100.00','1','1.200','1.190','1','1.200','1.190');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.200',berat_out_asli=berat_out_asli+'1.190',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-08-24' AND kode_barang='MTLT-ZHBD-50-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260824-0007','35','MTLT-ZHBD-51-0','1','1.330','1.330','TOKO','INPUT1','TOKO','BKLTMT');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKLTMT' WHERE kode_barang='MTLT-ZHBD-51-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-08-24','TOKO','BKLTMT','MTLT','MTLT-ZHBD-51-0','100.00','1','1.330','1.320','1','1.330','1.320');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.330',berat_out_asli=berat_out_asli+'1.320',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-08-24' AND kode_barang='MTLT-ZHBD-51-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260824-0007','36','MTLT-ZHBD-52-0','1','1.380','1.380','TOKO','INPUT1','TOKO','BKLTMT');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKLTMT' WHERE kode_barang='MTLT-ZHBD-52-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-08-24','TOKO','BKLTMT','MTLT','MTLT-ZHBD-52-0','100.00','1','1.380','1.370','1','1.380','1.370');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.380',berat_out_asli=berat_out_asli+'1.370',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-08-24' AND kode_barang='MTLT-ZHBD-52-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260824-0007','37','MTLT-ZHBD-53-0','1','0.920','0.920','TOKO','INPUT1','TOKO','BKLTMT');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKLTMT' WHERE kode_barang='MTLT-ZHBD-53-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-08-24','TOKO','BKLTMT','MTLT','MTLT-ZHBD-53-0','100.00','1','0.920','0.910','1','0.920','0.910');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.920',berat_out_asli=berat_out_asli+'0.910',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-08-24' AND kode_barang='MTLT-ZHBD-53-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260824-0007','38','MTLT-ZHBD-44-0','1','1.010','1.010','TOKO','INPUT1','TOKO','BKLTMT');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKLTMT' WHERE kode_barang='MTLT-ZHBD-44-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-08-24','TOKO','BKLTMT','MTLT','MTLT-ZHBD-44-0','100.00','1','1.010','1.000','1','1.010','1.000');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.010',berat_out_asli=berat_out_asli+'1.000',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-08-24' AND kode_barang='MTLT-ZHBD-44-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES('PB-260824-0007','2026-08-24','2026-08-24','15:52','56.25','adminpusat','2026-08-24 15:56:24');