INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2026-04-06 ','08:11:15');
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-03-14','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2026-02-11';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-03-13';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-03-13';
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-03-13' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-03-13';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-03-13';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-03-13';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-03-13';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202602 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-02';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-02';
UPDATE tt_barang_saldo SET tanggal= '2026-03-14' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-03-13' OR stock_akhir*1<0  OR kode_lokasi_gudang='' OR kode_lokasi_toko='' OR status_close='CLOS';
UPDATE tp_system SET tgl_system='2026-03-14';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2026-04-06 ','08:12:05');
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-03-15','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2026-02-12';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-03-14';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-03-14';
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-03-14' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-03-14';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-03-14';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-03-14';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-03-14';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202602 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-02';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-02';
UPDATE tt_barang_saldo SET tanggal= '2026-03-15' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-03-14' OR stock_akhir*1<0  OR kode_lokasi_gudang='' OR kode_lokasi_toko='' OR status_close='CLOS';
UPDATE tp_system SET tgl_system='2026-03-15';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2026-04-06 ','08:12:27');
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-03-16','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2026-02-13';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-03-15';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-03-15';
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-03-15' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-03-15';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-03-15';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-03-15';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-03-15';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202602 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-02';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-02';
UPDATE tt_barang_saldo SET tanggal= '2026-03-16' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-03-15' OR stock_akhir*1<0  OR kode_lokasi_gudang='' OR kode_lokasi_toko='' OR status_close='CLOS';
UPDATE tp_system SET tgl_system='2026-03-16';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2026-04-06 ','08:12:42');
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-03-17','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2026-02-14';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-03-16';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-03-16';
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-03-16' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-03-16';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-03-16';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-03-16';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-03-16';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202602 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-02';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-02';
UPDATE tt_barang_saldo SET tanggal= '2026-03-17' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-03-16' OR stock_akhir*1<0  OR kode_lokasi_gudang='' OR kode_lokasi_toko='' OR status_close='CLOS';
UPDATE tp_system SET tgl_system='2026-03-17';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2026-04-06 ','08:12:57');
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-03-18','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2026-02-15';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-03-17';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-03-17';
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-03-17' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-03-17';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-03-17';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-03-17';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-03-17';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202602 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-02';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-02';
UPDATE tt_barang_saldo SET tanggal= '2026-03-18' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-03-17' OR stock_akhir*1<0  OR kode_lokasi_gudang='' OR kode_lokasi_toko='' OR status_close='CLOS';
UPDATE tp_system SET tgl_system='2026-03-18';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2026-04-06 ','08:13:18');
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-03-19','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2026-02-16';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-03-18';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-03-18';
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-03-18' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-03-18';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-03-18';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-03-18';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-03-18';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202602 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-02';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-02';
UPDATE tt_barang_saldo SET tanggal= '2026-03-19' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-03-18' OR stock_akhir*1<0  OR kode_lokasi_gudang='' OR kode_lokasi_toko='' OR status_close='CLOS';
UPDATE tp_system SET tgl_system='2026-03-19';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2026-04-06 ','08:13:37');
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-03-20','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2026-02-17';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-03-19';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-03-19';
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-03-19' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-03-19';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-03-19';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-03-19';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-03-19';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202602 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-02';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-02';
UPDATE tt_barang_saldo SET tanggal= '2026-03-20' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-03-19' OR stock_akhir*1<0  OR kode_lokasi_gudang='' OR kode_lokasi_toko='' OR status_close='CLOS';
UPDATE tp_system SET tgl_system='2026-03-20';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2026-04-06 ','08:13:53');
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-03-21','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2026-02-18';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-03-20';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-03-20';
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-03-20' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-03-20';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-03-20';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-03-20';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-03-20';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202602 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-02';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-02';
UPDATE tt_barang_saldo SET tanggal= '2026-03-21' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-03-20' OR stock_akhir*1<0  OR kode_lokasi_gudang='' OR kode_lokasi_toko='' OR status_close='CLOS';
UPDATE tp_system SET tgl_system='2026-03-21';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2026-04-06 ','08:14:11');
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-03-22','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2026-02-19';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-03-21';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-03-21';
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-03-21' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-03-21';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-03-21';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-03-21';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-03-21';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202602 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-02';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-02';
UPDATE tt_barang_saldo SET tanggal= '2026-03-22' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-03-21' OR stock_akhir*1<0  OR kode_lokasi_gudang='' OR kode_lokasi_toko='' OR status_close='CLOS';
UPDATE tp_system SET tgl_system='2026-03-22';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2026-04-06 ','08:14:29');
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-03-23','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2026-02-20';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-03-22';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-03-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-03-22' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-03-22';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-03-22';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-03-22';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-03-22';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202602 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-02';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-02';
UPDATE tt_barang_saldo SET tanggal= '2026-03-23' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-03-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-03-23';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2026-04-06 ','08:14:45');
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-03-24','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2026-02-21';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-03-23';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-03-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-03-23' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-03-23';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-03-23';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-03-23';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-03-23';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202602 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-02';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-02';
UPDATE tt_barang_saldo SET tanggal= '2026-03-24' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-03-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-03-24';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2026-04-06 ','08:15:03');
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-03-25','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2026-02-22';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-03-24';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-03-24';
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-03-24' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-03-24';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-03-24';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-03-24';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-03-24';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202602 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-02';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-02';
UPDATE tt_barang_saldo SET tanggal= '2026-03-25' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-03-24' OR stock_akhir*1<0  OR kode_lokasi_gudang='' OR kode_lokasi_toko='' OR status_close='CLOS';
UPDATE tp_system SET tgl_system='2026-03-25';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2026-04-06 ','08:15:23');
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-03-26','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2026-02-23';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-03-25';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-03-25';
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-03-25' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-03-25';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-03-25';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-03-25';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-03-25';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202602 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-02';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-02';
UPDATE tt_barang_saldo SET tanggal= '2026-03-26' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-03-25' OR stock_akhir*1<0  OR kode_lokasi_gudang='' OR kode_lokasi_toko='' OR status_close='CLOS';
UPDATE tp_system SET tgl_system='2026-03-26';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2026-04-06 ','08:15:41');
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-03-27','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2026-02-24';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-03-26';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-03-26';
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-03-26' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-03-26';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-03-26';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-03-26';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-03-26';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202602 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-02';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-02';
UPDATE tt_barang_saldo SET tanggal= '2026-03-27' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-03-26' OR stock_akhir*1<0  OR kode_lokasi_gudang='' OR kode_lokasi_toko='' OR status_close='CLOS';
UPDATE tp_system SET tgl_system='2026-03-27';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2026-04-06 ','08:16:00');
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-03-28','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2026-02-25';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-03-27';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-03-27';
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-03-27' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-03-27';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-03-27';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-03-27';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-03-27';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202602 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-02';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-02';
UPDATE tt_barang_saldo SET tanggal= '2026-03-28' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-03-27' OR stock_akhir*1<0  OR kode_lokasi_gudang='' OR kode_lokasi_toko='' OR status_close='CLOS';
UPDATE tp_system SET tgl_system='2026-03-28';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2026-04-06 ','08:16:20');
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-03-29','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2026-02-26';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-03-28';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-03-28';
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-03-28' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-03-28';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-03-28';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-03-28';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-03-28';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202602 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-02';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-02';
UPDATE tt_barang_saldo SET tanggal= '2026-03-29' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-03-28' OR stock_akhir*1<0  OR kode_lokasi_gudang='' OR kode_lokasi_toko='' OR status_close='CLOS';
UPDATE tp_system SET tgl_system='2026-03-29';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2026-04-06 ','08:16:36');
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-03-30','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2026-02-27';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-03-29';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-03-29';
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-03-29' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-03-29';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-03-29';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-03-29';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-03-29';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202602 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-02';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-02';
UPDATE tt_barang_saldo SET tanggal= '2026-03-30' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-03-29' OR stock_akhir*1<0  OR kode_lokasi_gudang='' OR kode_lokasi_toko='' OR status_close='CLOS';
UPDATE tp_system SET tgl_system='2026-03-30';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2026-04-06 ','08:16:51');
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-03-31','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2026-02-28';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-03-30';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-03-30';
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-03-30' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-03-30';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-03-30';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-03-30';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-03-30';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202602 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-02';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-02';
UPDATE tt_barang_saldo SET tanggal= '2026-03-31' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-03-30' OR stock_akhir*1<0  OR kode_lokasi_gudang='' OR kode_lokasi_toko='' OR status_close='CLOS';
UPDATE tp_system SET tgl_system='2026-03-31';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2026-04-06 ','08:17:05');
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-04-01','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2026-03-01';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-03-31';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-03-31';
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-03-31' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-03-31';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-03-31';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-03-31';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-03-31';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202602 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-02';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-02';
UPDATE tt_barang_saldo SET tanggal= '2026-04-01' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-03-31' OR stock_akhir*1<0  OR kode_lokasi_gudang='' OR kode_lokasi_toko='' OR status_close='CLOS';
UPDATE tp_system SET tgl_system='2026-04-01';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2026-04-06 ','08:17:21');
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-04-02','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2026-03-02';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-04-01';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-04-01';
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-04-01' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-04-01';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-04-01';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-04-01';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-04-01';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202603 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-03';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-03';
UPDATE tt_barang_saldo SET tanggal= '2026-04-02' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-04-01' OR stock_akhir*1<0  OR kode_lokasi_gudang='' OR kode_lokasi_toko='' OR status_close='CLOS';
UPDATE tp_system SET tgl_system='2026-04-02';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2026-04-06 ','08:17:45');
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-04-03','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2026-03-03';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-04-02';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-04-02';
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-04-02' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-04-02';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-04-02';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-04-02';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-04-02';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202603 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-03';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-03';
UPDATE tt_barang_saldo SET tanggal= '2026-04-03' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-04-02' OR stock_akhir*1<0  OR kode_lokasi_gudang='' OR kode_lokasi_toko='' OR status_close='CLOS';
UPDATE tp_system SET tgl_system='2026-04-03';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2026-04-06 ','08:17:57');
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-04-04','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2026-03-04';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-04-03';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-04-03';
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-04-03' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-04-03';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-04-03';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-04-03';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-04-03';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202603 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-03';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-03';
UPDATE tt_barang_saldo SET tanggal= '2026-04-04' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-04-03' OR stock_akhir*1<0  OR kode_lokasi_gudang='' OR kode_lokasi_toko='' OR status_close='CLOS';
UPDATE tp_system SET tgl_system='2026-04-04';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2026-04-06 ','08:18:08');
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-04-05','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2026-03-05';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-04-04';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-04-04';
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-04-04' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-04-04';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-04-04';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-04-04';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-04-04';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202603 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-03';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-03';
UPDATE tt_barang_saldo SET tanggal= '2026-04-05' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-04-04' OR stock_akhir*1<0  OR kode_lokasi_gudang='' OR kode_lokasi_toko='' OR status_close='CLOS';
UPDATE tp_system SET tgl_system='2026-04-05';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2026-04-06 ','08:18:18');
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-04-06','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2026-03-06';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-04-05';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-04-05';
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-04-05' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-04-05';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-04-05';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-04-05';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-04-05';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202603 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-03';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-03';
UPDATE tt_barang_saldo SET tanggal= '2026-04-06' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-04-05' OR stock_akhir*1<0  OR kode_lokasi_gudang='' OR kode_lokasi_toko='' OR status_close='CLOS';
UPDATE tp_system SET tgl_system='2026-04-06';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2026-04-06 ','08:18:30');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2026-04-06 ','10:31: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-260406-0001','1','LXPER-ZCXB-16-0','1','3.480','3.480','TOKO','LXPER','TOKO','MMPER');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='MMPER' WHERE kode_barang='LXPER-ZCXB-16-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LXPER';
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-04-06','TOKO','MMPER','LXPER','LXPER-ZCXB-16-0','100.00','1','3.480','3.480','1','3.480','3.480');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'3.480',berat_out_asli=berat_out_asli+'3.480',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-04-06' AND kode_barang='LXPER-ZCXB-16-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LXPER' 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-260406-0001','2','LXPER-ZBBC-57-0','1','2.110','2.110','TOKO','LXPER','TOKO','MMPER');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='MMPER' WHERE kode_barang='LXPER-ZBBC-57-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LXPER';
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-04-06','TOKO','MMPER','LXPER','LXPER-ZBBC-57-0','100.00','1','2.110','2.110','1','2.110','2.110');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.110',berat_out_asli=berat_out_asli+'2.110',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-04-06' AND kode_barang='LXPER-ZBBC-57-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LXPER' 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-260406-0001','3','LXPER-ZBAG-21-0','1','1.700','1.700','TOKO','LXPER','TOKO','MMPER');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='MMPER' WHERE kode_barang='LXPER-ZBAG-21-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LXPER';
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-04-06','TOKO','MMPER','LXPER','LXPER-ZBAG-21-0','100.00','1','1.700','1.700','1','1.700','1.700');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.700',berat_out_asli=berat_out_asli+'1.700',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-04-06' AND kode_barang='LXPER-ZBAG-21-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LXPER' 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-260406-0001','4','LXPER-ZBBC-50-0','1','2.410','2.410','TOKO','LXPER','TOKO','MMPER');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='MMPER' WHERE kode_barang='LXPER-ZBBC-50-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LXPER';
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-04-06','TOKO','MMPER','LXPER','LXPER-ZBBC-50-0','100.00','1','2.410','2.410','1','2.410','2.410');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.410',berat_out_asli=berat_out_asli+'2.410',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-04-06' AND kode_barang='LXPER-ZBBC-50-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LXPER' 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-260406-0001','5','LXPER-ZBBC-13-0','1','1.510','1.510','TOKO','LXPER','TOKO','MMPER');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='MMPER' WHERE kode_barang='LXPER-ZBBC-13-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LXPER';
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-04-06','TOKO','MMPER','LXPER','LXPER-ZBBC-13-0','100.00','1','1.510','1.510','1','1.510','1.510');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.510',berat_out_asli=berat_out_asli+'1.510',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-04-06' AND kode_barang='LXPER-ZBBC-13-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LXPER' 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-260406-0001','6','LXPER-ZBBD-32-0','1','1.340','1.340','TOKO','LXPER','TOKO','MMPER');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='MMPER' WHERE kode_barang='LXPER-ZBBD-32-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LXPER';
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-04-06','TOKO','MMPER','LXPER','LXPER-ZBBD-32-0','100.00','1','1.340','1.340','1','1.340','1.340');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.340',berat_out_asli=berat_out_asli+'1.340',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-04-06' AND kode_barang='LXPER-ZBBD-32-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LXPER' 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-260406-0001','7','LXPER-ZBBC-34-0','1','2.800','2.800','TOKO','LXPER','TOKO','MMPER');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='MMPER' WHERE kode_barang='LXPER-ZBBC-34-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LXPER';
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-04-06','TOKO','MMPER','LXPER','LXPER-ZBBC-34-0','100.00','1','2.800','2.800','1','2.800','2.800');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.800',berat_out_asli=berat_out_asli+'2.800',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-04-06' AND kode_barang='LXPER-ZBBC-34-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LXPER' 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-260406-0001','8','LXPER-ZBAG-17-0','1','1.730','1.730','TOKO','LXPER','TOKO','MMPER');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='MMPER' WHERE kode_barang='LXPER-ZBAG-17-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LXPER';
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-04-06','TOKO','MMPER','LXPER','LXPER-ZBAG-17-0','100.00','1','1.730','1.730','1','1.730','1.730');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.730',berat_out_asli=berat_out_asli+'1.730',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-04-06' AND kode_barang='LXPER-ZBAG-17-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LXPER' 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-260406-0001','9','LXPER-ZBBC-56-0','1','2.300','2.300','TOKO','LXPER','TOKO','MMPER');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='MMPER' WHERE kode_barang='LXPER-ZBBC-56-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LXPER';
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-04-06','TOKO','MMPER','LXPER','LXPER-ZBBC-56-0','100.00','1','2.300','2.300','1','2.300','2.300');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.300',berat_out_asli=berat_out_asli+'2.300',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-04-06' AND kode_barang='LXPER-ZBBC-56-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LXPER' 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-260406-0001','10','LXPER-ZCXB-30-0','1','1.240','1.240','TOKO','LXPER','TOKO','MMPER');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='MMPER' WHERE kode_barang='LXPER-ZCXB-30-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LXPER';
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-04-06','TOKO','MMPER','LXPER','LXPER-ZCXB-30-0','100.00','1','1.240','1.240','1','1.240','1.240');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.240',berat_out_asli=berat_out_asli+'1.240',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-04-06' AND kode_barang='LXPER-ZCXB-30-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LXPER' 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-260406-0001','11','LXPER-ZCXB-21-0','1','5.790','5.790','TOKO','LXPER','TOKO','MMPER');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='MMPER' WHERE kode_barang='LXPER-ZCXB-21-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LXPER';
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-04-06','TOKO','MMPER','LXPER','LXPER-ZCXB-21-0','100.00','1','5.790','5.790','1','5.790','5.790');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'5.790',berat_out_asli=berat_out_asli+'5.790',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-04-06' AND kode_barang='LXPER-ZCXB-21-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LXPER' 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-260406-0001','12','LXPER-ZBAH-23-0','1','4.240','4.240','TOKO','LXPER','TOKO','MMPER');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='MMPER' WHERE kode_barang='LXPER-ZBAH-23-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LXPER';
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-04-06','TOKO','MMPER','LXPER','LXPER-ZBAH-23-0','100.00','1','4.240','4.240','1','4.240','4.240');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'4.240',berat_out_asli=berat_out_asli+'4.240',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-04-06' AND kode_barang='LXPER-ZBAH-23-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LXPER' 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-260406-0001','13','LXPER-ZBBC-37-0','1','3.680','3.680','TOKO','LXPER','TOKO','MMPER');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='MMPER' WHERE kode_barang='LXPER-ZBBC-37-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LXPER';
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-04-06','TOKO','MMPER','LXPER','LXPER-ZBBC-37-0','100.00','1','3.680','3.680','1','3.680','3.680');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'3.680',berat_out_asli=berat_out_asli+'3.680',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-04-06' AND kode_barang='LXPER-ZBBC-37-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LXPER' 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-260406-0001','14','LXPER-ZBBC-24-0','1','2.950','2.950','TOKO','LXPER','TOKO','MMPER');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='MMPER' WHERE kode_barang='LXPER-ZBBC-24-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LXPER';
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-04-06','TOKO','MMPER','LXPER','LXPER-ZBBC-24-0','100.00','1','2.950','2.950','1','2.950','2.950');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.950',berat_out_asli=berat_out_asli+'2.950',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-04-06' AND kode_barang='LXPER-ZBBC-24-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LXPER' 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-260406-0001','15','LXPER-ZCXB-28-0','1','2.070','2.070','TOKO','LXPER','TOKO','MMPER');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='MMPER' WHERE kode_barang='LXPER-ZCXB-28-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LXPER';
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-04-06','TOKO','MMPER','LXPER','LXPER-ZCXB-28-0','100.00','1','2.070','2.070','1','2.070','2.070');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.070',berat_out_asli=berat_out_asli+'2.070',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-04-06' AND kode_barang='LXPER-ZCXB-28-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LXPER' 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-260406-0001','16','LXPER-ZCXB-35-0','1','1.210','1.210','TOKO','LXPER','TOKO','MMPER');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='MMPER' WHERE kode_barang='LXPER-ZCXB-35-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LXPER';
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-04-06','TOKO','MMPER','LXPER','LXPER-ZCXB-35-0','100.00','1','1.210','1.210','1','1.210','1.210');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.210',berat_out_asli=berat_out_asli+'1.210',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-04-06' AND kode_barang='LXPER-ZCXB-35-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LXPER' 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-260406-0001','17','LXPER-ZCXB-27-0','1','3.810','3.810','TOKO','LXPER','TOKO','MMPER');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='MMPER' WHERE kode_barang='LXPER-ZCXB-27-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LXPER';
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-04-06','TOKO','MMPER','LXPER','LXPER-ZCXB-27-0','100.00','1','3.810','3.810','1','3.810','3.810');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'3.810',berat_out_asli=berat_out_asli+'3.810',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-04-06' AND kode_barang='LXPER-ZCXB-27-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LXPER' 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-260406-0001','18','LXPER-ZCXB-19-0','1','3.550','3.550','TOKO','LXPER','TOKO','MMPER');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='MMPER' WHERE kode_barang='LXPER-ZCXB-19-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LXPER';
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-04-06','TOKO','MMPER','LXPER','LXPER-ZCXB-19-0','100.00','1','3.550','3.550','1','3.550','3.550');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'3.550',berat_out_asli=berat_out_asli+'3.550',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-04-06' AND kode_barang='LXPER-ZCXB-19-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LXPER' 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-260406-0001','19','LXPER-ZBAG-20-0','1','1.860','1.860','TOKO','LXPER','TOKO','MMPER');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='MMPER' WHERE kode_barang='LXPER-ZBAG-20-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LXPER';
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-04-06','TOKO','MMPER','LXPER','LXPER-ZBAG-20-0','100.00','1','1.860','1.860','1','1.860','1.860');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.860',berat_out_asli=berat_out_asli+'1.860',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-04-06' AND kode_barang='LXPER-ZBAG-20-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LXPER' 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-260406-0001','20','LXPER-ZBAH-27-0','1','4.410','4.410','TOKO','LXPER','TOKO','MMPER');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='MMPER' WHERE kode_barang='LXPER-ZBAH-27-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LXPER';
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-04-06','TOKO','MMPER','LXPER','LXPER-ZBAH-27-0','100.00','1','4.410','4.410','1','4.410','4.410');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'4.410',berat_out_asli=berat_out_asli+'4.410',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-04-06' AND kode_barang='LXPER-ZBAH-27-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LXPER' 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-260406-0001','21','LXPER-ZBAG-11-0','1','4.380','4.380','TOKO','LXPER','TOKO','MMPER');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='MMPER' WHERE kode_barang='LXPER-ZBAG-11-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LXPER';
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-04-06','TOKO','MMPER','LXPER','LXPER-ZBAG-11-0','100.00','1','4.380','4.380','1','4.380','4.380');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'4.380',berat_out_asli=berat_out_asli+'4.380',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-04-06' AND kode_barang='LXPER-ZBAG-11-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LXPER' 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-260406-0001','22','LXPER-ZBAH-28-0','1','2.430','2.430','TOKO','LXPER','TOKO','MMPER');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='MMPER' WHERE kode_barang='LXPER-ZBAH-28-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LXPER';
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-04-06','TOKO','MMPER','LXPER','LXPER-ZBAH-28-0','100.00','1','2.430','2.430','1','2.430','2.430');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.430',berat_out_asli=berat_out_asli+'2.430',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-04-06' AND kode_barang='LXPER-ZBAH-28-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LXPER' 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-260406-0001','23','LXPER-ZBBD-9-0','1','2.530','2.530','TOKO','LXPER','TOKO','MMPER');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='MMPER' WHERE kode_barang='LXPER-ZBBD-9-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LXPER';
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-04-06','TOKO','MMPER','LXPER','LXPER-ZBBD-9-0','100.00','1','2.530','2.530','1','2.530','2.530');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.530',berat_out_asli=berat_out_asli+'2.530',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-04-06' AND kode_barang='LXPER-ZBBD-9-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LXPER' 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-260406-0001','24','LXPER-ZCXB-50-0','1','2.640','2.640','TOKO','LXPER','TOKO','MMPER');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='MMPER' WHERE kode_barang='LXPER-ZCXB-50-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LXPER';
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-04-06','TOKO','MMPER','LXPER','LXPER-ZCXB-50-0','100.00','1','2.640','2.640','1','2.640','2.640');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.640',berat_out_asli=berat_out_asli+'2.640',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-04-06' AND kode_barang='LXPER-ZCXB-50-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LXPER' 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-260406-0001','25','LXPER-ZBBC-16-0','1','1.090','1.090','TOKO','LXPER','TOKO','MMPER');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='MMPER' WHERE kode_barang='LXPER-ZBBC-16-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LXPER';
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-04-06','TOKO','MMPER','LXPER','LXPER-ZBBC-16-0','100.00','1','1.090','1.090','1','1.090','1.090');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.090',berat_out_asli=berat_out_asli+'1.090',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-04-06' AND kode_barang='LXPER-ZBBC-16-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LXPER' 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-260406-0001','26','LXPER-ZBBD-19-0','1','2.210','2.210','TOKO','LXPER','TOKO','MMPER');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='MMPER' WHERE kode_barang='LXPER-ZBBD-19-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LXPER';
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-04-06','TOKO','MMPER','LXPER','LXPER-ZBBD-19-0','100.00','1','2.210','2.210','1','2.210','2.210');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.210',berat_out_asli=berat_out_asli+'2.210',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-04-06' AND kode_barang='LXPER-ZBBD-19-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LXPER' 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-260406-0001','27','LXPER-ZBBC-60-0','1','2.340','2.340','TOKO','LXPER','TOKO','MMPER');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='MMPER' WHERE kode_barang='LXPER-ZBBC-60-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LXPER';
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-04-06','TOKO','MMPER','LXPER','LXPER-ZBBC-60-0','100.00','1','2.340','2.340','1','2.340','2.340');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.340',berat_out_asli=berat_out_asli+'2.340',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-04-06' AND kode_barang='LXPER-ZBBC-60-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LXPER' 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-260406-0001','28','LXPER-ZCXB-20-0','1','3.410','3.410','TOKO','LXPER','TOKO','MMPER');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='MMPER' WHERE kode_barang='LXPER-ZCXB-20-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LXPER';
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-04-06','TOKO','MMPER','LXPER','LXPER-ZCXB-20-0','100.00','1','3.410','3.410','1','3.410','3.410');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'3.410',berat_out_asli=berat_out_asli+'3.410',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-04-06' AND kode_barang='LXPER-ZCXB-20-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LXPER' 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-260406-0001','29','LXPER-ZBAH-20-0','1','3.070','3.070','TOKO','LXPER','TOKO','MMPER');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='MMPER' WHERE kode_barang='LXPER-ZBAH-20-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LXPER';
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-04-06','TOKO','MMPER','LXPER','LXPER-ZBAH-20-0','100.00','1','3.070','3.070','1','3.070','3.070');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'3.070',berat_out_asli=berat_out_asli+'3.070',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-04-06' AND kode_barang='LXPER-ZBAH-20-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LXPER' 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-260406-0001','30','LXPER-ZBAG-6-0','1','0.840','0.840','TOKO','LXPER','TOKO','MMPER');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='MMPER' WHERE kode_barang='LXPER-ZBAG-6-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LXPER';
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-04-06','TOKO','MMPER','LXPER','LXPER-ZBAG-6-0','100.00','1','0.840','0.840','1','0.840','0.840');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.840',berat_out_asli=berat_out_asli+'0.840',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-04-06' AND kode_barang='LXPER-ZBAG-6-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LXPER' 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-260406-0001','31','LXPER-ZBBD-15-0','1','3.630','3.630','TOKO','LXPER','TOKO','MMPER');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='MMPER' WHERE kode_barang='LXPER-ZBBD-15-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LXPER';
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-04-06','TOKO','MMPER','LXPER','LXPER-ZBBD-15-0','100.00','1','3.630','3.630','1','3.630','3.630');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'3.630',berat_out_asli=berat_out_asli+'3.630',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-04-06' AND kode_barang='LXPER-ZBBD-15-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LXPER' 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-260406-0001','32','LXPER-ZCXB-14-0','1','2.700','2.700','TOKO','LXPER','TOKO','MMPER');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='MMPER' WHERE kode_barang='LXPER-ZCXB-14-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LXPER';
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-04-06','TOKO','MMPER','LXPER','LXPER-ZCXB-14-0','100.00','1','2.700','2.700','1','2.700','2.700');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.700',berat_out_asli=berat_out_asli+'2.700',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-04-06' AND kode_barang='LXPER-ZCXB-14-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LXPER' 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-260406-0001','33','LXPER-ZBBD-18-0','1','2.570','2.570','TOKO','LXPER','TOKO','MMPER');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='MMPER' WHERE kode_barang='LXPER-ZBBD-18-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LXPER';
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-04-06','TOKO','MMPER','LXPER','LXPER-ZBBD-18-0','100.00','1','2.570','2.570','1','2.570','2.570');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.570',berat_out_asli=berat_out_asli+'2.570',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-04-06' AND kode_barang='LXPER-ZBBD-18-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LXPER' 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-260406-0001','34','LXPER-ZBAG-13-0','1','3.160','3.160','TOKO','LXPER','TOKO','MMPER');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='MMPER' WHERE kode_barang='LXPER-ZBAG-13-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LXPER';
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-04-06','TOKO','MMPER','LXPER','LXPER-ZBAG-13-0','100.00','1','3.160','3.160','1','3.160','3.160');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'3.160',berat_out_asli=berat_out_asli+'3.160',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-04-06' AND kode_barang='LXPER-ZBAG-13-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LXPER' 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-260406-0001','35','LXPER-ZCXB-22-0','1','4.850','4.850','TOKO','LXPER','TOKO','MMPER');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='MMPER' WHERE kode_barang='LXPER-ZCXB-22-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LXPER';
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-04-06','TOKO','MMPER','LXPER','LXPER-ZCXB-22-0','100.00','1','4.850','4.850','1','4.850','4.850');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'4.850',berat_out_asli=berat_out_asli+'4.850',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-04-06' AND kode_barang='LXPER-ZCXB-22-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LXPER' 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-260406-0001','2026-04-06','2026-04-06','10:51','96.04','input','2026-04-06 10:56:54');
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260406-0001','1','LXPER-ZBAG-6-0','1','0.840','TOKO','MMPER');
DELETE FROM tm_barang_export WHERE kode_barang='LXPER-ZBAG-6-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='LXPER-ZBAG-6-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='LXPER-ZBAG-6-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='LXPER-ZBAG-6-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='LXPER' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='LXPER' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='MMPER';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='MMPER';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='LXPER-ZBAG-6-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='0.840',berat_out_asli='0.840', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'0.840',berat_akhir_asli =berat_akhir_asli-'0.840' WHERE kode_barang='LXPER-ZBAG-6-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260406-0001','2','LXPER-ZBAG-11-0','1','4.380','TOKO','MMPER');
DELETE FROM tm_barang_export WHERE kode_barang='LXPER-ZBAG-11-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='LXPER-ZBAG-11-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='LXPER-ZBAG-11-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='LXPER-ZBAG-11-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='LXPER' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='LXPER' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='MMPER';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='MMPER';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='LXPER-ZBAG-11-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='4.380',berat_out_asli='4.380', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'4.380',berat_akhir_asli =berat_akhir_asli-'4.380' WHERE kode_barang='LXPER-ZBAG-11-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260406-0001','3','LXPER-ZBAG-13-0','1','3.160','TOKO','MMPER');
DELETE FROM tm_barang_export WHERE kode_barang='LXPER-ZBAG-13-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='LXPER-ZBAG-13-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='LXPER-ZBAG-13-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='LXPER-ZBAG-13-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='LXPER' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='LXPER' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='MMPER';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='MMPER';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='LXPER-ZBAG-13-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='3.160',berat_out_asli='3.160', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.160',berat_akhir_asli =berat_akhir_asli-'3.160' WHERE kode_barang='LXPER-ZBAG-13-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260406-0001','4','LXPER-ZBAG-17-0','1','1.730','TOKO','MMPER');
DELETE FROM tm_barang_export WHERE kode_barang='LXPER-ZBAG-17-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='LXPER-ZBAG-17-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='LXPER-ZBAG-17-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='LXPER-ZBAG-17-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='LXPER' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='LXPER' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='MMPER';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='MMPER';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='LXPER-ZBAG-17-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.730',berat_out_asli='1.730', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.730',berat_akhir_asli =berat_akhir_asli-'1.730' WHERE kode_barang='LXPER-ZBAG-17-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260406-0001','5','LXPER-ZBAG-20-0','1','1.860','TOKO','MMPER');
DELETE FROM tm_barang_export WHERE kode_barang='LXPER-ZBAG-20-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='LXPER-ZBAG-20-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='LXPER-ZBAG-20-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='LXPER-ZBAG-20-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='LXPER' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='LXPER' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='MMPER';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='MMPER';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='LXPER-ZBAG-20-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.860',berat_out_asli='1.860', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.860',berat_akhir_asli =berat_akhir_asli-'1.860' WHERE kode_barang='LXPER-ZBAG-20-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260406-0001','6','LXPER-ZBAG-21-0','1','1.700','TOKO','MMPER');
DELETE FROM tm_barang_export WHERE kode_barang='LXPER-ZBAG-21-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='LXPER-ZBAG-21-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='LXPER-ZBAG-21-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='LXPER-ZBAG-21-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='LXPER' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='LXPER' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='MMPER';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='MMPER';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='LXPER-ZBAG-21-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.700',berat_out_asli='1.700', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.700',berat_akhir_asli =berat_akhir_asli-'1.700' WHERE kode_barang='LXPER-ZBAG-21-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260406-0001','7','LXPER-ZBAH-20-0','1','3.070','TOKO','MMPER');
DELETE FROM tm_barang_export WHERE kode_barang='LXPER-ZBAH-20-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='LXPER-ZBAH-20-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='LXPER-ZBAH-20-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='LXPER-ZBAH-20-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='LXPER' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='LXPER' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='MMPER';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='MMPER';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='LXPER-ZBAH-20-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='3.070',berat_out_asli='3.070', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.070',berat_akhir_asli =berat_akhir_asli-'3.070' WHERE kode_barang='LXPER-ZBAH-20-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260406-0001','8','LXPER-ZBAH-23-0','1','4.240','TOKO','MMPER');
DELETE FROM tm_barang_export WHERE kode_barang='LXPER-ZBAH-23-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='LXPER-ZBAH-23-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='LXPER-ZBAH-23-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='LXPER-ZBAH-23-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='LXPER' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='LXPER' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='MMPER';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='MMPER';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='LXPER-ZBAH-23-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='4.240',berat_out_asli='4.240', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'4.240',berat_akhir_asli =berat_akhir_asli-'4.240' WHERE kode_barang='LXPER-ZBAH-23-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260406-0001','9','LXPER-ZBAH-27-0','1','4.410','TOKO','MMPER');
DELETE FROM tm_barang_export WHERE kode_barang='LXPER-ZBAH-27-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='LXPER-ZBAH-27-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='LXPER-ZBAH-27-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='LXPER-ZBAH-27-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='LXPER' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='LXPER' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='MMPER';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='MMPER';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='LXPER-ZBAH-27-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='4.410',berat_out_asli='4.410', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'4.410',berat_akhir_asli =berat_akhir_asli-'4.410' WHERE kode_barang='LXPER-ZBAH-27-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260406-0001','10','LXPER-ZBAH-28-0','1','2.430','TOKO','MMPER');
DELETE FROM tm_barang_export WHERE kode_barang='LXPER-ZBAH-28-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='LXPER-ZBAH-28-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='LXPER-ZBAH-28-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='LXPER-ZBAH-28-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='LXPER' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='LXPER' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='MMPER';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='MMPER';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='LXPER-ZBAH-28-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.430',berat_out_asli='2.430', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.430',berat_akhir_asli =berat_akhir_asli-'2.430' WHERE kode_barang='LXPER-ZBAH-28-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260406-0001','11','LXPER-ZBBC-13-0','1','1.510','TOKO','MMPER');
DELETE FROM tm_barang_export WHERE kode_barang='LXPER-ZBBC-13-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='LXPER-ZBBC-13-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='LXPER-ZBBC-13-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='LXPER-ZBBC-13-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='LXPER' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='LXPER' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='MMPER';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='MMPER';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='LXPER-ZBBC-13-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.510',berat_out_asli='1.510', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.510',berat_akhir_asli =berat_akhir_asli-'1.510' WHERE kode_barang='LXPER-ZBBC-13-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260406-0001','12','LXPER-ZBBC-16-0','1','1.090','TOKO','MMPER');
DELETE FROM tm_barang_export WHERE kode_barang='LXPER-ZBBC-16-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='LXPER-ZBBC-16-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='LXPER-ZBBC-16-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='LXPER-ZBBC-16-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='LXPER' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='LXPER' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='MMPER';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='MMPER';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='LXPER-ZBBC-16-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.090',berat_out_asli='1.090', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.090',berat_akhir_asli =berat_akhir_asli-'1.090' WHERE kode_barang='LXPER-ZBBC-16-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260406-0001','13','LXPER-ZBBC-24-0','1','2.950','TOKO','MMPER');
DELETE FROM tm_barang_export WHERE kode_barang='LXPER-ZBBC-24-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='LXPER-ZBBC-24-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='LXPER-ZBBC-24-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='LXPER-ZBBC-24-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='LXPER' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='LXPER' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='MMPER';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='MMPER';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='LXPER-ZBBC-24-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.950',berat_out_asli='2.950', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.950',berat_akhir_asli =berat_akhir_asli-'2.950' WHERE kode_barang='LXPER-ZBBC-24-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260406-0001','14','LXPER-ZBBC-34-0','1','2.800','TOKO','MMPER');
DELETE FROM tm_barang_export WHERE kode_barang='LXPER-ZBBC-34-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='LXPER-ZBBC-34-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='LXPER-ZBBC-34-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='LXPER-ZBBC-34-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='LXPER' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='LXPER' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='MMPER';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='MMPER';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='LXPER-ZBBC-34-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.800',berat_out_asli='2.800', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.800',berat_akhir_asli =berat_akhir_asli-'2.800' WHERE kode_barang='LXPER-ZBBC-34-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260406-0001','15','LXPER-ZBBC-37-0','1','3.680','TOKO','MMPER');
DELETE FROM tm_barang_export WHERE kode_barang='LXPER-ZBBC-37-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='LXPER-ZBBC-37-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='LXPER-ZBBC-37-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='LXPER-ZBBC-37-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='LXPER' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='LXPER' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='MMPER';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='MMPER';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='LXPER-ZBBC-37-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='3.680',berat_out_asli='3.680', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.680',berat_akhir_asli =berat_akhir_asli-'3.680' WHERE kode_barang='LXPER-ZBBC-37-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260406-0001','16','LXPER-ZBBC-50-0','1','2.410','TOKO','MMPER');
DELETE FROM tm_barang_export WHERE kode_barang='LXPER-ZBBC-50-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='LXPER-ZBBC-50-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='LXPER-ZBBC-50-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='LXPER-ZBBC-50-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='LXPER' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='LXPER' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='MMPER';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='MMPER';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='LXPER-ZBBC-50-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.410',berat_out_asli='2.410', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.410',berat_akhir_asli =berat_akhir_asli-'2.410' WHERE kode_barang='LXPER-ZBBC-50-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260406-0001','17','LXPER-ZBBC-56-0','1','2.300','TOKO','MMPER');
DELETE FROM tm_barang_export WHERE kode_barang='LXPER-ZBBC-56-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='LXPER-ZBBC-56-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='LXPER-ZBBC-56-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='LXPER-ZBBC-56-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='LXPER' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='LXPER' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='MMPER';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='MMPER';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='LXPER-ZBBC-56-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.300',berat_out_asli='2.300', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.300',berat_akhir_asli =berat_akhir_asli-'2.300' WHERE kode_barang='LXPER-ZBBC-56-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260406-0001','18','LXPER-ZBBC-57-0','1','2.110','TOKO','MMPER');
DELETE FROM tm_barang_export WHERE kode_barang='LXPER-ZBBC-57-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='LXPER-ZBBC-57-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='LXPER-ZBBC-57-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='LXPER-ZBBC-57-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='LXPER' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='LXPER' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='MMPER';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='MMPER';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='LXPER-ZBBC-57-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.110',berat_out_asli='2.110', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.110',berat_akhir_asli =berat_akhir_asli-'2.110' WHERE kode_barang='LXPER-ZBBC-57-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260406-0001','19','LXPER-ZBBC-60-0','1','2.340','TOKO','MMPER');
DELETE FROM tm_barang_export WHERE kode_barang='LXPER-ZBBC-60-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='LXPER-ZBBC-60-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='LXPER-ZBBC-60-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='LXPER-ZBBC-60-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='LXPER' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='LXPER' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='MMPER';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='MMPER';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='LXPER-ZBBC-60-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.340',berat_out_asli='2.340', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.340',berat_akhir_asli =berat_akhir_asli-'2.340' WHERE kode_barang='LXPER-ZBBC-60-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260406-0001','20','LXPER-ZBBD-9-0','1','2.530','TOKO','MMPER');
DELETE FROM tm_barang_export WHERE kode_barang='LXPER-ZBBD-9-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='LXPER-ZBBD-9-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='LXPER-ZBBD-9-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='LXPER-ZBBD-9-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='LXPER' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='LXPER' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='MMPER';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='MMPER';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='LXPER-ZBBD-9-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.530',berat_out_asli='2.530', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.530',berat_akhir_asli =berat_akhir_asli-'2.530' WHERE kode_barang='LXPER-ZBBD-9-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260406-0001','21','LXPER-ZBBD-15-0','1','3.630','TOKO','MMPER');
DELETE FROM tm_barang_export WHERE kode_barang='LXPER-ZBBD-15-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='LXPER-ZBBD-15-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='LXPER-ZBBD-15-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='LXPER-ZBBD-15-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='LXPER' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='LXPER' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='MMPER';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='MMPER';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='LXPER-ZBBD-15-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='3.630',berat_out_asli='3.630', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.630',berat_akhir_asli =berat_akhir_asli-'3.630' WHERE kode_barang='LXPER-ZBBD-15-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260406-0001','22','LXPER-ZBBD-18-0','1','2.570','TOKO','MMPER');
DELETE FROM tm_barang_export WHERE kode_barang='LXPER-ZBBD-18-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='LXPER-ZBBD-18-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='LXPER-ZBBD-18-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='LXPER-ZBBD-18-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='LXPER' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='LXPER' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='MMPER';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='MMPER';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='LXPER-ZBBD-18-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.570',berat_out_asli='2.570', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.570',berat_akhir_asli =berat_akhir_asli-'2.570' WHERE kode_barang='LXPER-ZBBD-18-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260406-0001','23','LXPER-ZBBD-19-0','1','2.210','TOKO','MMPER');
DELETE FROM tm_barang_export WHERE kode_barang='LXPER-ZBBD-19-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='LXPER-ZBBD-19-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='LXPER-ZBBD-19-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='LXPER-ZBBD-19-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='LXPER' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='LXPER' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='MMPER';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='MMPER';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='LXPER-ZBBD-19-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.210',berat_out_asli='2.210', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.210',berat_akhir_asli =berat_akhir_asli-'2.210' WHERE kode_barang='LXPER-ZBBD-19-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260406-0001','24','LXPER-ZBBD-32-0','1','1.340','TOKO','MMPER');
DELETE FROM tm_barang_export WHERE kode_barang='LXPER-ZBBD-32-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='LXPER-ZBBD-32-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='LXPER-ZBBD-32-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='LXPER-ZBBD-32-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='LXPER' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='LXPER' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='MMPER';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='MMPER';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='LXPER-ZBBD-32-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.340',berat_out_asli='1.340', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.340',berat_akhir_asli =berat_akhir_asli-'1.340' WHERE kode_barang='LXPER-ZBBD-32-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260406-0001','25','LXPER-ZCXB-14-0','1','2.700','TOKO','MMPER');
DELETE FROM tm_barang_export WHERE kode_barang='LXPER-ZCXB-14-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='LXPER-ZCXB-14-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='LXPER-ZCXB-14-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='LXPER-ZCXB-14-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='LXPER' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='LXPER' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='MMPER';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='MMPER';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='LXPER-ZCXB-14-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.700',berat_out_asli='2.700', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.700',berat_akhir_asli =berat_akhir_asli-'2.700' WHERE kode_barang='LXPER-ZCXB-14-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260406-0001','26','LXPER-ZCXB-16-0','1','3.480','TOKO','MMPER');
DELETE FROM tm_barang_export WHERE kode_barang='LXPER-ZCXB-16-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='LXPER-ZCXB-16-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='LXPER-ZCXB-16-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='LXPER-ZCXB-16-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='LXPER' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='LXPER' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='MMPER';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='MMPER';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='LXPER-ZCXB-16-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='3.480',berat_out_asli='3.480', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.480',berat_akhir_asli =berat_akhir_asli-'3.480' WHERE kode_barang='LXPER-ZCXB-16-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260406-0001','27','LXPER-ZCXB-19-0','1','3.550','TOKO','MMPER');
DELETE FROM tm_barang_export WHERE kode_barang='LXPER-ZCXB-19-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='LXPER-ZCXB-19-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='LXPER-ZCXB-19-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='LXPER-ZCXB-19-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='LXPER' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='LXPER' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='MMPER';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='MMPER';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='LXPER-ZCXB-19-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='3.550',berat_out_asli='3.550', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.550',berat_akhir_asli =berat_akhir_asli-'3.550' WHERE kode_barang='LXPER-ZCXB-19-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260406-0001','28','LXPER-ZCXB-20-0','1','3.410','TOKO','MMPER');
DELETE FROM tm_barang_export WHERE kode_barang='LXPER-ZCXB-20-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='LXPER-ZCXB-20-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='LXPER-ZCXB-20-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='LXPER-ZCXB-20-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='LXPER' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='LXPER' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='MMPER';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='MMPER';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='LXPER-ZCXB-20-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='3.410',berat_out_asli='3.410', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.410',berat_akhir_asli =berat_akhir_asli-'3.410' WHERE kode_barang='LXPER-ZCXB-20-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260406-0001','29','LXPER-ZCXB-21-0','1','5.790','TOKO','MMPER');
DELETE FROM tm_barang_export WHERE kode_barang='LXPER-ZCXB-21-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='LXPER-ZCXB-21-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='LXPER-ZCXB-21-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='LXPER-ZCXB-21-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='LXPER' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='LXPER' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='MMPER';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='MMPER';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='LXPER-ZCXB-21-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='5.790',berat_out_asli='5.790', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'5.790',berat_akhir_asli =berat_akhir_asli-'5.790' WHERE kode_barang='LXPER-ZCXB-21-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260406-0001','30','LXPER-ZCXB-22-0','1','4.850','TOKO','MMPER');
DELETE FROM tm_barang_export WHERE kode_barang='LXPER-ZCXB-22-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='LXPER-ZCXB-22-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='LXPER-ZCXB-22-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='LXPER-ZCXB-22-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='LXPER' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='LXPER' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='MMPER';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='MMPER';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='LXPER-ZCXB-22-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='4.850',berat_out_asli='4.850', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'4.850',berat_akhir_asli =berat_akhir_asli-'4.850' WHERE kode_barang='LXPER-ZCXB-22-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260406-0001','31','LXPER-ZCXB-27-0','1','3.810','TOKO','MMPER');
DELETE FROM tm_barang_export WHERE kode_barang='LXPER-ZCXB-27-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='LXPER-ZCXB-27-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='LXPER-ZCXB-27-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='LXPER-ZCXB-27-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='LXPER' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='LXPER' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='MMPER';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='MMPER';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='LXPER-ZCXB-27-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='3.810',berat_out_asli='3.810', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.810',berat_akhir_asli =berat_akhir_asli-'3.810' WHERE kode_barang='LXPER-ZCXB-27-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260406-0001','32','LXPER-ZCXB-28-0','1','2.070','TOKO','MMPER');
DELETE FROM tm_barang_export WHERE kode_barang='LXPER-ZCXB-28-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='LXPER-ZCXB-28-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='LXPER-ZCXB-28-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='LXPER-ZCXB-28-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='LXPER' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='LXPER' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='MMPER';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='MMPER';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='LXPER-ZCXB-28-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.070',berat_out_asli='2.070', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.070',berat_akhir_asli =berat_akhir_asli-'2.070' WHERE kode_barang='LXPER-ZCXB-28-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260406-0001','33','LXPER-ZCXB-30-0','1','1.240','TOKO','MMPER');
DELETE FROM tm_barang_export WHERE kode_barang='LXPER-ZCXB-30-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='LXPER-ZCXB-30-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='LXPER-ZCXB-30-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='LXPER-ZCXB-30-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='LXPER' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='LXPER' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='MMPER';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='MMPER';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='LXPER-ZCXB-30-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.240',berat_out_asli='1.240', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.240',berat_akhir_asli =berat_akhir_asli-'1.240' WHERE kode_barang='LXPER-ZCXB-30-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260406-0001','34','LXPER-ZCXB-35-0','1','1.210','TOKO','MMPER');
DELETE FROM tm_barang_export WHERE kode_barang='LXPER-ZCXB-35-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='LXPER-ZCXB-35-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='LXPER-ZCXB-35-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='LXPER-ZCXB-35-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='LXPER' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='LXPER' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='MMPER';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='MMPER';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='LXPER-ZCXB-35-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.210',berat_out_asli='1.210', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.210',berat_akhir_asli =berat_akhir_asli-'1.210' WHERE kode_barang='LXPER-ZCXB-35-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260406-0001','35','LXPER-ZCXB-50-0','1','2.640','TOKO','MMPER');
DELETE FROM tm_barang_export WHERE kode_barang='LXPER-ZCXB-50-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='LXPER-ZCXB-50-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='LXPER-ZCXB-50-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='LXPER-ZCXB-50-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='LXPER' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='LXPER' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='MMPER';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='MMPER';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='LXPER-ZCXB-50-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.640',berat_out_asli='2.640', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.640',berat_akhir_asli =berat_akhir_asli-'2.640' WHERE kode_barang='LXPER-ZCXB-50-0' AND stock_akhir ='1';
INSERT INTO tt_export_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date,tujuan_toko) VALUES ('EX-260406-0001','2026-04-06','2026-04-06','11:01','2.640','input','2026-04-06 11:01:03','THIFA');
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-260406-0002','1','LXPER-ZBAH-32-0','1','3.180','3.180','TOKO','LXPER','TOKO','PBDG');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='PBDG' WHERE kode_barang='LXPER-ZBAH-32-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LXPER';
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-04-06','TOKO','PBDG','LXPER','LXPER-ZBAH-32-0','100.00','1','3.180','3.180','1','3.180','3.180');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'3.180',berat_out_asli=berat_out_asli+'3.180',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-04-06' AND kode_barang='LXPER-ZBAH-32-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LXPER' 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-260406-0002','2','LXPER-ZBAG-18-0','1','4.550','4.550','TOKO','LXPER','TOKO','PBDG');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='PBDG' WHERE kode_barang='LXPER-ZBAG-18-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LXPER';
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-04-06','TOKO','PBDG','LXPER','LXPER-ZBAG-18-0','100.00','1','4.550','4.550','1','4.550','4.550');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'4.550',berat_out_asli=berat_out_asli+'4.550',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-04-06' AND kode_barang='LXPER-ZBAG-18-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LXPER' 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-260406-0002','3','LXPER-ZCXB-37-0','1','1.490','1.490','TOKO','LXPER','TOKO','PBDG');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='PBDG' WHERE kode_barang='LXPER-ZCXB-37-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LXPER';
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-04-06','TOKO','PBDG','LXPER','LXPER-ZCXB-37-0','100.00','1','1.490','1.490','1','1.490','1.490');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.490',berat_out_asli=berat_out_asli+'1.490',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-04-06' AND kode_barang='LXPER-ZCXB-37-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LXPER' 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-260406-0002','4','LXPER-ZBBC-9-0','1','1.580','1.580','TOKO','LXPER','TOKO','PBDG');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='PBDG' WHERE kode_barang='LXPER-ZBBC-9-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LXPER';
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-04-06','TOKO','PBDG','LXPER','LXPER-ZBBC-9-0','100.00','1','1.580','1.580','1','1.580','1.580');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.580',berat_out_asli=berat_out_asli+'1.580',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-04-06' AND kode_barang='LXPER-ZBBC-9-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LXPER' 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-260406-0002','5','LXPER-ZCXB-32-0','1','2.280','2.280','TOKO','LXPER','TOKO','PBDG');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='PBDG' WHERE kode_barang='LXPER-ZCXB-32-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LXPER';
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-04-06','TOKO','PBDG','LXPER','LXPER-ZCXB-32-0','100.00','1','2.280','2.280','1','2.280','2.280');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.280',berat_out_asli=berat_out_asli+'2.280',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-04-06' AND kode_barang='LXPER-ZCXB-32-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LXPER' 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-260406-0002','6','LXPER-ZCXB-25-0','1','4.180','4.180','TOKO','LXPER','TOKO','PBDG');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='PBDG' WHERE kode_barang='LXPER-ZCXB-25-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LXPER';
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-04-06','TOKO','PBDG','LXPER','LXPER-ZCXB-25-0','100.00','1','4.180','4.180','1','4.180','4.180');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'4.180',berat_out_asli=berat_out_asli+'4.180',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-04-06' AND kode_barang='LXPER-ZCXB-25-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LXPER' 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-260406-0002','7','LXPER-ZBBC-28-0','1','1.440','1.440','TOKO','LXPER','TOKO','PBDG');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='PBDG' WHERE kode_barang='LXPER-ZBBC-28-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LXPER';
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-04-06','TOKO','PBDG','LXPER','LXPER-ZBBC-28-0','100.00','1','1.440','1.440','1','1.440','1.440');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.440',berat_out_asli=berat_out_asli+'1.440',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-04-06' AND kode_barang='LXPER-ZBBC-28-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LXPER' 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-260406-0002','8','LXPER-ZBAH-14-0','1','1.080','1.080','TOKO','LXPER','TOKO','PBDG');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='PBDG' WHERE kode_barang='LXPER-ZBAH-14-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LXPER';
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-04-06','TOKO','PBDG','LXPER','LXPER-ZBAH-14-0','100.00','1','1.080','1.080','1','1.080','1.080');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.080',berat_out_asli=berat_out_asli+'1.080',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-04-06' AND kode_barang='LXPER-ZBAH-14-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LXPER' 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-260406-0002','9','LXPER-ZBBC-31-0','1','2.780','2.780','TOKO','LXPER','TOKO','PBDG');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='PBDG' WHERE kode_barang='LXPER-ZBBC-31-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LXPER';
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-04-06','TOKO','PBDG','LXPER','LXPER-ZBBC-31-0','100.00','1','2.780','2.780','1','2.780','2.780');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.780',berat_out_asli=berat_out_asli+'2.780',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-04-06' AND kode_barang='LXPER-ZBBC-31-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LXPER' 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-260406-0002','10','LXPER-ZBBD-20-0','1','1.740','1.740','TOKO','LXPER','TOKO','PBDG');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='PBDG' WHERE kode_barang='LXPER-ZBBD-20-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LXPER';
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-04-06','TOKO','PBDG','LXPER','LXPER-ZBBD-20-0','100.00','1','1.740','1.740','1','1.740','1.740');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.740',berat_out_asli=berat_out_asli+'1.740',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-04-06' AND kode_barang='LXPER-ZBBD-20-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LXPER' 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-260406-0002','11','LXPER-ZBBC-67-0','1','2.990','2.990','TOKO','LXPER','TOKO','PBDG');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='PBDG' WHERE kode_barang='LXPER-ZBBC-67-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LXPER';
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-04-06','TOKO','PBDG','LXPER','LXPER-ZBBC-67-0','100.00','1','2.990','2.990','1','2.990','2.990');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.990',berat_out_asli=berat_out_asli+'2.990',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-04-06' AND kode_barang='LXPER-ZBBC-67-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LXPER' 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-260406-0002','12','LXPER-ZBBC-12-0','1','1.410','1.410','TOKO','LXPER','TOKO','PBDG');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='PBDG' WHERE kode_barang='LXPER-ZBBC-12-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LXPER';
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-04-06','TOKO','PBDG','LXPER','LXPER-ZBBC-12-0','100.00','1','1.410','1.410','1','1.410','1.410');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.410',berat_out_asli=berat_out_asli+'1.410',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-04-06' AND kode_barang='LXPER-ZBBC-12-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LXPER' 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-260406-0002','13','LXPER-ZBBC-38-0','1','2.140','2.140','TOKO','LXPER','TOKO','PBDG');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='PBDG' WHERE kode_barang='LXPER-ZBBC-38-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LXPER';
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-04-06','TOKO','PBDG','LXPER','LXPER-ZBBC-38-0','100.00','1','2.140','2.140','1','2.140','2.140');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.140',berat_out_asli=berat_out_asli+'2.140',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-04-06' AND kode_barang='LXPER-ZBBC-38-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LXPER' 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-260406-0002','14','LXPER-ZBAH-16-0','1','3.270','3.270','TOKO','LXPER','TOKO','PBDG');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='PBDG' WHERE kode_barang='LXPER-ZBAH-16-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LXPER';
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-04-06','TOKO','PBDG','LXPER','LXPER-ZBAH-16-0','100.00','1','3.270','3.270','1','3.270','3.270');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'3.270',berat_out_asli=berat_out_asli+'3.270',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-04-06' AND kode_barang='LXPER-ZBAH-16-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LXPER' 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-260406-0002','15','LXPER-ZBBC-49-0','1','2.010','2.010','TOKO','LXPER','TOKO','PBDG');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='PBDG' WHERE kode_barang='LXPER-ZBBC-49-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LXPER';
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-04-06','TOKO','PBDG','LXPER','LXPER-ZBBC-49-0','100.00','1','2.010','2.010','1','2.010','2.010');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.010',berat_out_asli=berat_out_asli+'2.010',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-04-06' AND kode_barang='LXPER-ZBBC-49-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LXPER' 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-260406-0002','16','LXPER-ZBBC-43-0','1','2.510','2.510','TOKO','LXPER','TOKO','PBDG');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='PBDG' WHERE kode_barang='LXPER-ZBBC-43-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LXPER';
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-04-06','TOKO','PBDG','LXPER','LXPER-ZBBC-43-0','100.00','1','2.510','2.510','1','2.510','2.510');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.510',berat_out_asli=berat_out_asli+'2.510',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-04-06' AND kode_barang='LXPER-ZBBC-43-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LXPER' 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-260406-0002','17','LXPER-ZBBD-22-0','1','2.140','2.140','TOKO','LXPER','TOKO','PBDG');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='PBDG' WHERE kode_barang='LXPER-ZBBD-22-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LXPER';
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-04-06','TOKO','PBDG','LXPER','LXPER-ZBBD-22-0','100.00','1','2.140','2.140','1','2.140','2.140');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.140',berat_out_asli=berat_out_asli+'2.140',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-04-06' AND kode_barang='LXPER-ZBBD-22-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LXPER' 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-260406-0002','18','LXPER-ZBAG-9-0','1','1.480','1.480','TOKO','LXPER','TOKO','PBDG');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='PBDG' WHERE kode_barang='LXPER-ZBAG-9-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LXPER';
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-04-06','TOKO','PBDG','LXPER','LXPER-ZBAG-9-0','100.00','1','1.480','1.480','1','1.480','1.480');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.480',berat_out_asli=berat_out_asli+'1.480',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-04-06' AND kode_barang='LXPER-ZBAG-9-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LXPER' 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-260406-0002','19','LXPER-ZBAG-4-0','1','1.580','1.580','TOKO','LXPER','TOKO','PBDG');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='PBDG' WHERE kode_barang='LXPER-ZBAG-4-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LXPER';
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-04-06','TOKO','PBDG','LXPER','LXPER-ZBAG-4-0','100.00','1','1.580','1.580','1','1.580','1.580');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.580',berat_out_asli=berat_out_asli+'1.580',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-04-06' AND kode_barang='LXPER-ZBAG-4-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LXPER' 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-260406-0002','20','LXPER-ZBBC-65-0','1','1.430','1.430','TOKO','LXPER','TOKO','PBDG');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='PBDG' WHERE kode_barang='LXPER-ZBBC-65-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LXPER';
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-04-06','TOKO','PBDG','LXPER','LXPER-ZBBC-65-0','100.00','1','1.430','1.430','1','1.430','1.430');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.430',berat_out_asli=berat_out_asli+'1.430',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-04-06' AND kode_barang='LXPER-ZBBC-65-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LXPER' 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-260406-0002','21','LXPER-ZBBC-71-0','1','2.410','2.410','TOKO','LXPER','TOKO','PBDG');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='PBDG' WHERE kode_barang='LXPER-ZBBC-71-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LXPER';
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-04-06','TOKO','PBDG','LXPER','LXPER-ZBBC-71-0','100.00','1','2.410','2.410','1','2.410','2.410');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.410',berat_out_asli=berat_out_asli+'2.410',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-04-06' AND kode_barang='LXPER-ZBBC-71-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LXPER' 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-260406-0002','22','LXPER-ZBBC-55-0','1','1.930','1.930','TOKO','LXPER','TOKO','PBDG');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='PBDG' WHERE kode_barang='LXPER-ZBBC-55-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LXPER';
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-04-06','TOKO','PBDG','LXPER','LXPER-ZBBC-55-0','100.00','1','1.930','1.930','1','1.930','1.930');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.930',berat_out_asli=berat_out_asli+'1.930',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-04-06' AND kode_barang='LXPER-ZBBC-55-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LXPER' 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-260406-0002','23','LXPER-ZBBC-22-0','1','1.510','1.510','TOKO','LXPER','TOKO','PBDG');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='PBDG' WHERE kode_barang='LXPER-ZBBC-22-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LXPER';
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-04-06','TOKO','PBDG','LXPER','LXPER-ZBBC-22-0','100.00','1','1.510','1.510','1','1.510','1.510');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.510',berat_out_asli=berat_out_asli+'1.510',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-04-06' AND kode_barang='LXPER-ZBBC-22-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LXPER' 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-260406-0002','24','LXPER-ZBBD-25-0','1','1.970','1.970','TOKO','LXPER','TOKO','PBDG');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='PBDG' WHERE kode_barang='LXPER-ZBBD-25-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LXPER';
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-04-06','TOKO','PBDG','LXPER','LXPER-ZBBD-25-0','100.00','1','1.970','1.970','1','1.970','1.970');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.970',berat_out_asli=berat_out_asli+'1.970',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-04-06' AND kode_barang='LXPER-ZBBD-25-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LXPER' 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-260406-0002','25','LXPER-ZBBD-21-0','1','1.180','1.180','TOKO','LXPER','TOKO','PBDG');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='PBDG' WHERE kode_barang='LXPER-ZBBD-21-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LXPER';
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-04-06','TOKO','PBDG','LXPER','LXPER-ZBBD-21-0','100.00','1','1.180','1.180','1','1.180','1.180');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.180',berat_out_asli=berat_out_asli+'1.180',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-04-06' AND kode_barang='LXPER-ZBBD-21-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LXPER' 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-260406-0002','26','LXPER-ZBBC-7-0','1','3.030','3.030','TOKO','LXPER','TOKO','PBDG');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='PBDG' WHERE kode_barang='LXPER-ZBBC-7-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LXPER';
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-04-06','TOKO','PBDG','LXPER','LXPER-ZBBC-7-0','100.00','1','3.030','3.030','1','3.030','3.030');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'3.030',berat_out_asli=berat_out_asli+'3.030',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-04-06' AND kode_barang='LXPER-ZBBC-7-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LXPER' 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-260406-0002','27','LXPER-ZCXB-4-0','1','1.390','1.390','TOKO','LXPER','TOKO','PBDG');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='PBDG' WHERE kode_barang='LXPER-ZCXB-4-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LXPER';
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-04-06','TOKO','PBDG','LXPER','LXPER-ZCXB-4-0','100.00','1','1.390','1.390','1','1.390','1.390');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.390',berat_out_asli=berat_out_asli+'1.390',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-04-06' AND kode_barang='LXPER-ZCXB-4-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LXPER' 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-260406-0002','28','LXPER-ZBAG-5-0','1','0.850','0.850','TOKO','LXPER','TOKO','PBDG');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='PBDG' WHERE kode_barang='LXPER-ZBAG-5-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LXPER';
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-04-06','TOKO','PBDG','LXPER','LXPER-ZBAG-5-0','100.00','1','0.850','0.850','1','0.850','0.850');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.850',berat_out_asli=berat_out_asli+'0.850',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-04-06' AND kode_barang='LXPER-ZBAG-5-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LXPER' 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-260406-0002','29','LXPER-ZBBC-45-0','1','2.370','2.370','TOKO','LXPER','TOKO','PBDG');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='PBDG' WHERE kode_barang='LXPER-ZBBC-45-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LXPER';
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-04-06','TOKO','PBDG','LXPER','LXPER-ZBBC-45-0','100.00','1','2.370','2.370','1','2.370','2.370');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.370',berat_out_asli=berat_out_asli+'2.370',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-04-06' AND kode_barang='LXPER-ZBBC-45-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LXPER' 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-260406-0002','30','LXPER-ZBBC-52-0','1','2.280','2.280','TOKO','LXPER','TOKO','PBDG');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='PBDG' WHERE kode_barang='LXPER-ZBBC-52-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LXPER';
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-04-06','TOKO','PBDG','LXPER','LXPER-ZBBC-52-0','100.00','1','2.280','2.280','1','2.280','2.280');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.280',berat_out_asli=berat_out_asli+'2.280',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-04-06' AND kode_barang='LXPER-ZBBC-52-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LXPER' 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-260406-0002','31','LXPER-ZBBC-11-0','1','1.820','1.820','TOKO','LXPER','TOKO','PBDG');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='PBDG' WHERE kode_barang='LXPER-ZBBC-11-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LXPER';
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-04-06','TOKO','PBDG','LXPER','LXPER-ZBBC-11-0','100.00','1','1.820','1.820','1','1.820','1.820');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.820',berat_out_asli=berat_out_asli+'1.820',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-04-06' AND kode_barang='LXPER-ZBBC-11-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LXPER' 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-260406-0002','32','LXPER-ZBBC-41-0','1','1.860','1.860','TOKO','LXPER','TOKO','PBDG');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='PBDG' WHERE kode_barang='LXPER-ZBBC-41-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LXPER';
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-04-06','TOKO','PBDG','LXPER','LXPER-ZBBC-41-0','100.00','1','1.860','1.860','1','1.860','1.860');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.860',berat_out_asli=berat_out_asli+'1.860',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-04-06' AND kode_barang='LXPER-ZBBC-41-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LXPER' 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-260406-0002','33','LXPER-ZBAH-21-0','1','2.500','2.500','TOKO','LXPER','TOKO','PBDG');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='PBDG' WHERE kode_barang='LXPER-ZBAH-21-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LXPER';
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-04-06','TOKO','PBDG','LXPER','LXPER-ZBAH-21-0','100.00','1','2.500','2.500','1','2.500','2.500');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.500',berat_out_asli=berat_out_asli+'2.500',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-04-06' AND kode_barang='LXPER-ZBAH-21-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LXPER' 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-260406-0002','34','LXPER-ZBAH-15-0','1','1.190','1.190','TOKO','LXPER','TOKO','PBDG');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='PBDG' WHERE kode_barang='LXPER-ZBAH-15-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LXPER';
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-04-06','TOKO','PBDG','LXPER','LXPER-ZBAH-15-0','100.00','1','1.190','1.190','1','1.190','1.190');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.190',berat_out_asli=berat_out_asli+'1.190',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-04-06' AND kode_barang='LXPER-ZBAH-15-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LXPER' 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-260406-0002','35','LXPER-ZBBD-26-0','1','3.940','3.940','TOKO','LXPER','TOKO','PBDG');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='PBDG' WHERE kode_barang='LXPER-ZBBD-26-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LXPER';
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-04-06','TOKO','PBDG','LXPER','LXPER-ZBBD-26-0','100.00','1','3.940','3.940','1','3.940','3.940');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'3.940',berat_out_asli=berat_out_asli+'3.940',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-04-06' AND kode_barang='LXPER-ZBBD-26-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LXPER' 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-260406-0002','36','LXPER-ZBBC-30-0','1','1.670','1.670','TOKO','LXPER','TOKO','PBDG');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='PBDG' WHERE kode_barang='LXPER-ZBBC-30-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LXPER';
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-04-06','TOKO','PBDG','LXPER','LXPER-ZBBC-30-0','100.00','1','1.670','1.670','1','1.670','1.670');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.670',berat_out_asli=berat_out_asli+'1.670',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-04-06' AND kode_barang='LXPER-ZBBC-30-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LXPER' 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-260406-0002','37','LXPER-ZBBC-74-0','1','2.180','2.180','TOKO','LXPER','TOKO','PBDG');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='PBDG' WHERE kode_barang='LXPER-ZBBC-74-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LXPER';
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-04-06','TOKO','PBDG','LXPER','LXPER-ZBBC-74-0','100.00','1','2.180','2.180','1','2.180','2.180');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.180',berat_out_asli=berat_out_asli+'2.180',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-04-06' AND kode_barang='LXPER-ZBBC-74-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LXPER' 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-260406-0002','38','LXPER-ZBBC-25-0','1','3.090','3.090','TOKO','LXPER','TOKO','PBDG');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='PBDG' WHERE kode_barang='LXPER-ZBBC-25-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LXPER';
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-04-06','TOKO','PBDG','LXPER','LXPER-ZBBC-25-0','100.00','1','3.090','3.090','1','3.090','3.090');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'3.090',berat_out_asli=berat_out_asli+'3.090',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-04-06' AND kode_barang='LXPER-ZBBC-25-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LXPER' 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-260406-0002','39','LXPER-ZBBC-32-0','1','1.870','1.870','TOKO','LXPER','TOKO','PBDG');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='PBDG' WHERE kode_barang='LXPER-ZBBC-32-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LXPER';
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-04-06','TOKO','PBDG','LXPER','LXPER-ZBBC-32-0','100.00','1','1.870','1.870','1','1.870','1.870');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.870',berat_out_asli=berat_out_asli+'1.870',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-04-06' AND kode_barang='LXPER-ZBBC-32-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LXPER' 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-260406-0002','40','LXPER-ZBBC-39-0','1','1.440','1.440','TOKO','LXPER','TOKO','PBDG');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='PBDG' WHERE kode_barang='LXPER-ZBBC-39-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LXPER';
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-04-06','TOKO','PBDG','LXPER','LXPER-ZBBC-39-0','100.00','1','1.440','1.440','1','1.440','1.440');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.440',berat_out_asli=berat_out_asli+'1.440',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-04-06' AND kode_barang='LXPER-ZBBC-39-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LXPER' 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-260406-0002','41','LXPER-ZBBC-44-0','1','1.410','1.410','TOKO','LXPER','TOKO','PBDG');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='PBDG' WHERE kode_barang='LXPER-ZBBC-44-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LXPER';
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-04-06','TOKO','PBDG','LXPER','LXPER-ZBBC-44-0','100.00','1','1.410','1.410','1','1.410','1.410');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.410',berat_out_asli=berat_out_asli+'1.410',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-04-06' AND kode_barang='LXPER-ZBBC-44-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LXPER' 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-260406-0002','42','LXPER-ZCXB-7-0','1','1.550','1.550','TOKO','LXPER','TOKO','PBDG');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='PBDG' WHERE kode_barang='LXPER-ZCXB-7-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LXPER';
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-04-06','TOKO','PBDG','LXPER','LXPER-ZCXB-7-0','100.00','1','1.550','1.550','1','1.550','1.550');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.550',berat_out_asli=berat_out_asli+'1.550',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-04-06' AND kode_barang='LXPER-ZCXB-7-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LXPER' 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-260406-0002','43','LXPER-ZCXB-41-0','1','1.500','1.500','TOKO','LXPER','TOKO','PBDG');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='PBDG' WHERE kode_barang='LXPER-ZCXB-41-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LXPER';
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-04-06','TOKO','PBDG','LXPER','LXPER-ZCXB-41-0','100.00','1','1.500','1.500','1','1.500','1.500');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.500',berat_out_asli=berat_out_asli+'1.500',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-04-06' AND kode_barang='LXPER-ZCXB-41-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LXPER' 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-260406-0002','44','LXPER-ZBBC-69-0','1','2.560','2.560','TOKO','LXPER','TOKO','PBDG');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='PBDG' WHERE kode_barang='LXPER-ZBBC-69-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LXPER';
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-04-06','TOKO','PBDG','LXPER','LXPER-ZBBC-69-0','100.00','1','2.560','2.560','1','2.560','2.560');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.560',berat_out_asli=berat_out_asli+'2.560',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-04-06' AND kode_barang='LXPER-ZBBC-69-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LXPER' 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-260406-0002','45','LXPER-ZBBC-17-0','1','3.840','3.840','TOKO','LXPER','TOKO','PBDG');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='PBDG' WHERE kode_barang='LXPER-ZBBC-17-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LXPER';
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-04-06','TOKO','PBDG','LXPER','LXPER-ZBBC-17-0','100.00','1','3.840','3.840','1','3.840','3.840');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'3.840',berat_out_asli=berat_out_asli+'3.840',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-04-06' AND kode_barang='LXPER-ZBBC-17-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LXPER' 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-260406-0002','46','LXPER-ZBAG-22-0','1','1.940','1.940','TOKO','LXPER','TOKO','PBDG');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='PBDG' WHERE kode_barang='LXPER-ZBAG-22-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LXPER';
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-04-06','TOKO','PBDG','LXPER','LXPER-ZBAG-22-0','100.00','1','1.940','1.940','1','1.940','1.940');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.940',berat_out_asli=berat_out_asli+'1.940',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-04-06' AND kode_barang='LXPER-ZBAG-22-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LXPER' 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-260406-0002','47','LXPER-ZCXB-40-0','1','3.880','3.880','TOKO','LXPER','TOKO','PBDG');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='PBDG' WHERE kode_barang='LXPER-ZCXB-40-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LXPER';
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-04-06','TOKO','PBDG','LXPER','LXPER-ZCXB-40-0','100.00','1','3.880','3.880','1','3.880','3.880');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'3.880',berat_out_asli=berat_out_asli+'3.880',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-04-06' AND kode_barang='LXPER-ZCXB-40-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LXPER' 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-260406-0002','48','LXPER-ZCXB-8-0','1','2.110','2.110','TOKO','LXPER','TOKO','PBDG');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='PBDG' WHERE kode_barang='LXPER-ZCXB-8-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LXPER';
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-04-06','TOKO','PBDG','LXPER','LXPER-ZCXB-8-0','100.00','1','2.110','2.110','1','2.110','2.110');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.110',berat_out_asli=berat_out_asli+'2.110',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-04-06' AND kode_barang='LXPER-ZCXB-8-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LXPER' 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-260406-0002','49','LXPER-ZBBC-19-0','1','2.880','2.880','TOKO','LXPER','TOKO','PBDG');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='PBDG' WHERE kode_barang='LXPER-ZBBC-19-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LXPER';
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-04-06','TOKO','PBDG','LXPER','LXPER-ZBBC-19-0','100.00','1','2.880','2.880','1','2.880','2.880');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.880',berat_out_asli=berat_out_asli+'2.880',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-04-06' AND kode_barang='LXPER-ZBBC-19-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LXPER' 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-260406-0002','50','LXPER-ZBBC-61-0','1','1.080','1.080','TOKO','LXPER','TOKO','PBDG');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='PBDG' WHERE kode_barang='LXPER-ZBBC-61-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LXPER';
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-04-06','TOKO','PBDG','LXPER','LXPER-ZBBC-61-0','100.00','1','1.080','1.080','1','1.080','1.080');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.080',berat_out_asli=berat_out_asli+'1.080',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-04-06' AND kode_barang='LXPER-ZBBC-61-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LXPER' 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-260406-0002','51','LXPER-ZCXB-45-0','1','1.120','1.120','TOKO','LXPER','TOKO','PBDG');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='PBDG' WHERE kode_barang='LXPER-ZCXB-45-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LXPER';
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-04-06','TOKO','PBDG','LXPER','LXPER-ZCXB-45-0','100.00','1','1.120','1.120','1','1.120','1.120');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.120',berat_out_asli=berat_out_asli+'1.120',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-04-06' AND kode_barang='LXPER-ZCXB-45-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LXPER' 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-260406-0002','52','LXPER-ZBBC-33-0','1','2.610','2.610','TOKO','LXPER','TOKO','PBDG');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='PBDG' WHERE kode_barang='LXPER-ZBBC-33-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LXPER';
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-04-06','TOKO','PBDG','LXPER','LXPER-ZBBC-33-0','100.00','1','2.610','2.610','1','2.610','2.610');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.610',berat_out_asli=berat_out_asli+'2.610',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-04-06' AND kode_barang='LXPER-ZBBC-33-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LXPER' 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-260406-0002','53','LXPER-ZCXB-34-0','1','1.550','1.550','TOKO','LXPER','TOKO','PBDG');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='PBDG' WHERE kode_barang='LXPER-ZCXB-34-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LXPER';
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-04-06','TOKO','PBDG','LXPER','LXPER-ZCXB-34-0','100.00','1','1.550','1.550','1','1.550','1.550');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.550',berat_out_asli=berat_out_asli+'1.550',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-04-06' AND kode_barang='LXPER-ZCXB-34-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LXPER' 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-260406-0002','54','LXPER-ZCXB-31-0','1','1.380','1.380','TOKO','LXPER','TOKO','PBDG');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='PBDG' WHERE kode_barang='LXPER-ZCXB-31-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LXPER';
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-04-06','TOKO','PBDG','LXPER','LXPER-ZCXB-31-0','100.00','1','1.380','1.380','1','1.380','1.380');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.380',berat_out_asli=berat_out_asli+'1.380',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-04-06' AND kode_barang='LXPER-ZCXB-31-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LXPER' 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-260406-0002','55','LXPER-ZBBD-33-0','1','2.780','2.780','TOKO','LXPER','TOKO','PBDG');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='PBDG' WHERE kode_barang='LXPER-ZBBD-33-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LXPER';
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-04-06','TOKO','PBDG','LXPER','LXPER-ZBBD-33-0','100.00','1','2.780','2.780','1','2.780','2.780');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.780',berat_out_asli=berat_out_asli+'2.780',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-04-06' AND kode_barang='LXPER-ZBBD-33-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LXPER' 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-260406-0002','56','LXPER-ZBBD-13-0','1','1.480','1.480','TOKO','LXPER','TOKO','PBDG');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='PBDG' WHERE kode_barang='LXPER-ZBBD-13-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LXPER';
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-04-06','TOKO','PBDG','LXPER','LXPER-ZBBD-13-0','100.00','1','1.480','1.480','1','1.480','1.480');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.480',berat_out_asli=berat_out_asli+'1.480',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-04-06' AND kode_barang='LXPER-ZBBD-13-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LXPER' 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-260406-0002','57','LXPER-ZCXB-39-0','1','2.400','2.400','TOKO','LXPER','TOKO','PBDG');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='PBDG' WHERE kode_barang='LXPER-ZCXB-39-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LXPER';
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-04-06','TOKO','PBDG','LXPER','LXPER-ZCXB-39-0','100.00','1','2.400','2.400','1','2.400','2.400');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.400',berat_out_asli=berat_out_asli+'2.400',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-04-06' AND kode_barang='LXPER-ZCXB-39-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LXPER' 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-260406-0002','58','LXPER-ZBBC-40-0','1','1.600','1.600','TOKO','LXPER','TOKO','PBDG');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='PBDG' WHERE kode_barang='LXPER-ZBBC-40-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LXPER';
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-04-06','TOKO','PBDG','LXPER','LXPER-ZBBC-40-0','100.00','1','1.600','1.600','1','1.600','1.600');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.600',berat_out_asli=berat_out_asli+'1.600',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-04-06' AND kode_barang='LXPER-ZBBC-40-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LXPER' 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-260406-0002','59','LXPER-ZCXB-44-0','1','2.480','2.480','TOKO','LXPER','TOKO','PBDG');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='PBDG' WHERE kode_barang='LXPER-ZCXB-44-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LXPER';
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-04-06','TOKO','PBDG','LXPER','LXPER-ZCXB-44-0','100.00','1','2.480','2.480','1','2.480','2.480');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.480',berat_out_asli=berat_out_asli+'2.480',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-04-06' AND kode_barang='LXPER-ZCXB-44-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LXPER' 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-260406-0002','60','LXPER-ZBBC-8-0','1','2.140','2.140','TOKO','LXPER','TOKO','PBDG');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='PBDG' WHERE kode_barang='LXPER-ZBBC-8-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LXPER';
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-04-06','TOKO','PBDG','LXPER','LXPER-ZBBC-8-0','100.00','1','2.140','2.140','1','2.140','2.140');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.140',berat_out_asli=berat_out_asli+'2.140',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-04-06' AND kode_barang='LXPER-ZBBC-8-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LXPER' 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-260406-0002','61','LXPER-ZBBC-15-0','1','1.980','1.980','TOKO','LXPER','TOKO','PBDG');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='PBDG' WHERE kode_barang='LXPER-ZBBC-15-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LXPER';
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-04-06','TOKO','PBDG','LXPER','LXPER-ZBBC-15-0','100.00','1','1.980','1.980','1','1.980','1.980');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.980',berat_out_asli=berat_out_asli+'1.980',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-04-06' AND kode_barang='LXPER-ZBBC-15-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LXPER' 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-260406-0002','62','LXPER-ZCXB-1-0','1','1.690','1.690','TOKO','LXPER','TOKO','PBDG');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='PBDG' WHERE kode_barang='LXPER-ZCXB-1-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LXPER';
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-04-06','TOKO','PBDG','LXPER','LXPER-ZCXB-1-0','100.00','1','1.690','1.690','1','1.690','1.690');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.690',berat_out_asli=berat_out_asli+'1.690',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-04-06' AND kode_barang='LXPER-ZCXB-1-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LXPER' 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-260406-0002','63','LXPER-ZBBD-24-0','1','1.700','1.700','TOKO','LXPER','TOKO','PBDG');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='PBDG' WHERE kode_barang='LXPER-ZBBD-24-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LXPER';
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-04-06','TOKO','PBDG','LXPER','LXPER-ZBBD-24-0','100.00','1','1.700','1.700','1','1.700','1.700');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.700',berat_out_asli=berat_out_asli+'1.700',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-04-06' AND kode_barang='LXPER-ZBBD-24-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LXPER' 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-260406-0002','64','LXPER-ZCXB-47-0','1','2.320','2.320','TOKO','LXPER','TOKO','PBDG');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='PBDG' WHERE kode_barang='LXPER-ZCXB-47-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LXPER';
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-04-06','TOKO','PBDG','LXPER','LXPER-ZCXB-47-0','100.00','1','2.320','2.320','1','2.320','2.320');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.320',berat_out_asli=berat_out_asli+'2.320',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-04-06' AND kode_barang='LXPER-ZCXB-47-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LXPER' 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-260406-0002','65','LXPER-ZCXB-12-0','1','2.530','2.530','TOKO','LXPER','TOKO','PBDG');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='PBDG' WHERE kode_barang='LXPER-ZCXB-12-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LXPER';
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-04-06','TOKO','PBDG','LXPER','LXPER-ZCXB-12-0','100.00','1','2.530','2.530','1','2.530','2.530');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.530',berat_out_asli=berat_out_asli+'2.530',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-04-06' AND kode_barang='LXPER-ZCXB-12-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LXPER' 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-260406-0002','66','LXPER-ZBBD-36-0','1','1.500','1.500','TOKO','LXPER','TOKO','PBDG');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='PBDG' WHERE kode_barang='LXPER-ZBBD-36-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LXPER';
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-04-06','TOKO','PBDG','LXPER','LXPER-ZBBD-36-0','100.00','1','1.500','1.500','1','1.500','1.500');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.500',berat_out_asli=berat_out_asli+'1.500',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-04-06' AND kode_barang='LXPER-ZBBD-36-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LXPER' 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-260406-0002','67','LXPER-ZBBC-63-0','1','1.970','1.970','TOKO','LXPER','TOKO','PBDG');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='PBDG' WHERE kode_barang='LXPER-ZBBC-63-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LXPER';
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-04-06','TOKO','PBDG','LXPER','LXPER-ZBBC-63-0','100.00','1','1.970','1.970','1','1.970','1.970');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.970',berat_out_asli=berat_out_asli+'1.970',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-04-06' AND kode_barang='LXPER-ZBBC-63-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LXPER' 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-260406-0002','68','LXPER-ZBBC-23-0','1','2.740','2.740','TOKO','LXPER','TOKO','PBDG');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='PBDG' WHERE kode_barang='LXPER-ZBBC-23-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LXPER';
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-04-06','TOKO','PBDG','LXPER','LXPER-ZBBC-23-0','100.00','1','2.740','2.740','1','2.740','2.740');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.740',berat_out_asli=berat_out_asli+'2.740',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-04-06' AND kode_barang='LXPER-ZBBC-23-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LXPER' 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-260406-0002','69','LXPER-ZBBC-20-0','1','2.070','2.070','TOKO','LXPER','TOKO','PBDG');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='PBDG' WHERE kode_barang='LXPER-ZBBC-20-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LXPER';
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-04-06','TOKO','PBDG','LXPER','LXPER-ZBBC-20-0','100.00','1','2.070','2.070','1','2.070','2.070');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.070',berat_out_asli=berat_out_asli+'2.070',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-04-06' AND kode_barang='LXPER-ZBBC-20-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LXPER' 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-260406-0002','70','LXPER-ZBBD-28-0','1','4.320','4.320','TOKO','LXPER','TOKO','PBDG');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='PBDG' WHERE kode_barang='LXPER-ZBBD-28-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LXPER';
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-04-06','TOKO','PBDG','LXPER','LXPER-ZBBD-28-0','100.00','1','4.320','4.320','1','4.320','4.320');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'4.320',berat_out_asli=berat_out_asli+'4.320',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-04-06' AND kode_barang='LXPER-ZBBD-28-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LXPER' 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-260406-0002','71','LXPER-ZCXB-6-0','1','1.680','1.680','TOKO','LXPER','TOKO','PBDG');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='PBDG' WHERE kode_barang='LXPER-ZCXB-6-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LXPER';
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-04-06','TOKO','PBDG','LXPER','LXPER-ZCXB-6-0','100.00','1','1.680','1.680','1','1.680','1.680');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.680',berat_out_asli=berat_out_asli+'1.680',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-04-06' AND kode_barang='LXPER-ZCXB-6-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LXPER' 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-260406-0002','72','LXPER-ZBBC-58-0','1','1.390','1.390','TOKO','LXPER','TOKO','PBDG');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='PBDG' WHERE kode_barang='LXPER-ZBBC-58-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LXPER';
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-04-06','TOKO','PBDG','LXPER','LXPER-ZBBC-58-0','100.00','1','1.390','1.390','1','1.390','1.390');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.390',berat_out_asli=berat_out_asli+'1.390',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-04-06' AND kode_barang='LXPER-ZBBC-58-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LXPER' 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-260406-0002','73','LXPER-ZBBC-53-0','1','1.760','1.760','TOKO','LXPER','TOKO','PBDG');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='PBDG' WHERE kode_barang='LXPER-ZBBC-53-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LXPER';
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-04-06','TOKO','PBDG','LXPER','LXPER-ZBBC-53-0','100.00','1','1.760','1.760','1','1.760','1.760');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.760',berat_out_asli=berat_out_asli+'1.760',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-04-06' AND kode_barang='LXPER-ZBBC-53-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LXPER' 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-260406-0002','74','LXPER-ZCXB-29-0','1','2.740','2.740','TOKO','LXPER','TOKO','PBDG');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='PBDG' WHERE kode_barang='LXPER-ZCXB-29-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LXPER';
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-04-06','TOKO','PBDG','LXPER','LXPER-ZCXB-29-0','100.00','1','2.740','2.740','1','2.740','2.740');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.740',berat_out_asli=berat_out_asli+'2.740',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-04-06' AND kode_barang='LXPER-ZCXB-29-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LXPER' 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-260406-0002','75','LXPER-ZBBC-47-0','1','2.840','2.840','TOKO','LXPER','TOKO','PBDG');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='PBDG' WHERE kode_barang='LXPER-ZBBC-47-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LXPER';
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-04-06','TOKO','PBDG','LXPER','LXPER-ZBBC-47-0','100.00','1','2.840','2.840','1','2.840','2.840');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.840',berat_out_asli=berat_out_asli+'2.840',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-04-06' AND kode_barang='LXPER-ZBBC-47-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LXPER' 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-260406-0002','76','LXPER-ZBBD-29-0','1','1.550','1.550','TOKO','LXPER','TOKO','PBDG');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='PBDG' WHERE kode_barang='LXPER-ZBBD-29-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LXPER';
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-04-06','TOKO','PBDG','LXPER','LXPER-ZBBD-29-0','100.00','1','1.550','1.550','1','1.550','1.550');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.550',berat_out_asli=berat_out_asli+'1.550',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-04-06' AND kode_barang='LXPER-ZBBD-29-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LXPER' 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-260406-0002','77','LXPER-ZBBC-35-0','1','1.860','1.860','TOKO','LXPER','TOKO','PBDG');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='PBDG' WHERE kode_barang='LXPER-ZBBC-35-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LXPER';
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-04-06','TOKO','PBDG','LXPER','LXPER-ZBBC-35-0','100.00','1','1.860','1.860','1','1.860','1.860');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.860',berat_out_asli=berat_out_asli+'1.860',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-04-06' AND kode_barang='LXPER-ZBBC-35-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LXPER' 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-260406-0002','78','LXPER-ZCXB-23-0','1','3.650','3.650','TOKO','LXPER','TOKO','PBDG');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='PBDG' WHERE kode_barang='LXPER-ZCXB-23-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LXPER';
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-04-06','TOKO','PBDG','LXPER','LXPER-ZCXB-23-0','100.00','1','3.650','3.650','1','3.650','3.650');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'3.650',berat_out_asli=berat_out_asli+'3.650',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-04-06' AND kode_barang='LXPER-ZCXB-23-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LXPER' 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-260406-0002','79','LXPER-ZCXB-38-0','1','1.610','1.610','TOKO','LXPER','TOKO','PBDG');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='PBDG' WHERE kode_barang='LXPER-ZCXB-38-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LXPER';
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-04-06','TOKO','PBDG','LXPER','LXPER-ZCXB-38-0','100.00','1','1.610','1.610','1','1.610','1.610');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.610',berat_out_asli=berat_out_asli+'1.610',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-04-06' AND kode_barang='LXPER-ZCXB-38-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LXPER' 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-260406-0002','80','LXPER-ZBBC-68-0','1','2.510','2.510','TOKO','LXPER','TOKO','PBDG');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='PBDG' WHERE kode_barang='LXPER-ZBBC-68-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LXPER';
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-04-06','TOKO','PBDG','LXPER','LXPER-ZBBC-68-0','100.00','1','2.510','2.510','1','2.510','2.510');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.510',berat_out_asli=berat_out_asli+'2.510',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-04-06' AND kode_barang='LXPER-ZBBC-68-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LXPER' 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-260406-0002','81','LXPER-ZBBD-30-0','1','1.780','1.780','TOKO','LXPER','TOKO','PBDG');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='PBDG' WHERE kode_barang='LXPER-ZBBD-30-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LXPER';
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-04-06','TOKO','PBDG','LXPER','LXPER-ZBBD-30-0','100.00','1','1.780','1.780','1','1.780','1.780');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.780',berat_out_asli=berat_out_asli+'1.780',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-04-06' AND kode_barang='LXPER-ZBBD-30-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LXPER' 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-260406-0002','82','LXPER-ZBBC-27-0','1','1.600','1.600','TOKO','LXPER','TOKO','PBDG');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='PBDG' WHERE kode_barang='LXPER-ZBBC-27-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LXPER';
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-04-06','TOKO','PBDG','LXPER','LXPER-ZBBC-27-0','100.00','1','1.600','1.600','1','1.600','1.600');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.600',berat_out_asli=berat_out_asli+'1.600',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-04-06' AND kode_barang='LXPER-ZBBC-27-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LXPER' 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-260406-0002','2026-04-06','2026-04-06','13:24','175.82','input','2026-04-06 13:33:05');