INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261008-0001','1','B1E-ZJXF-283-0','1','0.530','0.530','TOKO','PMBK-B','TOKO','PM-B');
DELETE FROM tm_barang WHERE kode_barang='B1E-ZJXF-283-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='B1E-ZJXF-283-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-B',tgl_last_beli='2026-10-08 07:56:32' WHERE kode_barang='B1E-ZJXF-283-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='B1E-ZJXF-283-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-08 07:56:32','TOKO','PM-B','B1E','B1E-ZJXF-283-0','1','0.530','0.530','1','0.530','0.530','100.00');
DELETE FROM tm_dept WHERE kode_dept='B1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='B1E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='B1E-ZJXF-283-0';
DELETE FROM tm_barang_export WHERE kode_barang='B1E-ZJXF-283-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20261008-0001','2026-10-08','07:56','0.530','admpindah','2026-10-08 07:56:32');
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261008-0001','1','D1E-ZGBI-37-0','1','0.570','0.570','TOKO','PMBK-D','TOKO','PM-D');
DELETE FROM tm_barang WHERE kode_barang='D1E-ZGBI-37-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='D1E-ZGBI-37-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-D',tgl_last_beli='2026-10-08 07:56:54' WHERE kode_barang='D1E-ZGBI-37-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='D1E-ZGBI-37-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-08 07:56:54','TOKO','PM-D','D1E','D1E-ZGBI-37-0','1','0.570','0.570','1','0.570','0.570','100.00');
DELETE FROM tm_dept WHERE kode_dept='D1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='D1E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='D1E-ZGBI-37-0';
DELETE FROM tm_barang_export WHERE kode_barang='D1E-ZGBI-37-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20261008-0001','2026-10-08','07:56','0.570','admpindah','2026-10-08 07:56:54');
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261008-0001','1','E1F-ZICX-15-0','1','0.310','0.310','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E1F-ZICX-15-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1F-ZICX-15-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-10-08 07:57:09' WHERE kode_barang='E1F-ZICX-15-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1F-ZICX-15-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-08 07:57:09','TOKO','PM-E','E1F','E1F-ZICX-15-0','1','0.310','0.310','1','0.310','0.310','100.00');
DELETE FROM tm_dept WHERE kode_dept='E1F' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E1F' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MF' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MF' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E1F-ZICX-15-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1F-ZICX-15-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20261008-0001','2026-10-08','07:57','0.310','admpindah','2026-10-08 07:57:09');
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261008-0001','1','F3E-ZJXF-221-0','1','1.030','1.030','TOKO','PMBK-F','TOKO','PM-F');
DELETE FROM tm_barang WHERE kode_barang='F3E-ZJXF-221-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F3E-ZJXF-221-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-F',tgl_last_beli='2026-10-08 07:57:26' WHERE kode_barang='F3E-ZJXF-221-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F3E-ZJXF-221-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-08 07:57:26','TOKO','PM-F','F3E','F3E-ZJXF-221-0','1','1.030','1.030','1','1.030','1.030','100.00');
DELETE FROM tm_dept WHERE kode_dept='F3E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='F3E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='F3E-ZJXF-221-0';
DELETE FROM tm_barang_export WHERE kode_barang='F3E-ZJXF-221-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261008-0001','1','F1E-ZJXG-172-0','1','3.260','3.260','TOKO','PMBK-F','TOKO','PM-F');
DELETE FROM tm_barang WHERE kode_barang='F1E-ZJXG-172-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F1E-ZJXG-172-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-F',tgl_last_beli='2026-10-08 07:57:26' WHERE kode_barang='F1E-ZJXG-172-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F1E-ZJXG-172-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-08 07:57:26','TOKO','PM-F','F1E','F1E-ZJXG-172-0','1','3.260','3.260','1','3.260','3.260','100.00');
DELETE FROM tm_dept WHERE kode_dept='F1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='F1E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='F1E-ZJXG-172-0';
DELETE FROM tm_barang_export WHERE kode_barang='F1E-ZJXG-172-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261008-0001','1','F2E-ZJXG-174-0','1','6.350','6.350','TOKO','PMBK-F','TOKO','PM-F');
DELETE FROM tm_barang WHERE kode_barang='F2E-ZJXG-174-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F2E-ZJXG-174-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-F',tgl_last_beli='2026-10-08 07:57:26' WHERE kode_barang='F2E-ZJXG-174-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F2E-ZJXG-174-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-08 07:57:26','TOKO','PM-F','F2E','F2E-ZJXG-174-0','1','6.350','6.350','1','6.350','6.350','100.00');
DELETE FROM tm_dept WHERE kode_dept='F2E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='F2E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='F2E-ZJXG-174-0';
DELETE FROM tm_barang_export WHERE kode_barang='F2E-ZJXG-174-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261008-0001','1','F3E-ZJXG-180-0','1','3.170','3.170','TOKO','PMBK-F','TOKO','PM-F');
DELETE FROM tm_barang WHERE kode_barang='F3E-ZJXG-180-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F3E-ZJXG-180-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-F',tgl_last_beli='2026-10-08 07:57:26' WHERE kode_barang='F3E-ZJXG-180-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F3E-ZJXG-180-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-08 07:57:26','TOKO','PM-F','F3E','F3E-ZJXG-180-0','1','3.170','3.170','1','3.170','3.170','100.00');
DELETE FROM tm_dept WHERE kode_dept='F3E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='F3E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='F3E-ZJXG-180-0';
DELETE FROM tm_barang_export WHERE kode_barang='F3E-ZJXG-180-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261008-0001','1','F3E-ZJXG-186-0','1','2.130','2.130','TOKO','PMBK-F','TOKO','PM-F');
DELETE FROM tm_barang WHERE kode_barang='F3E-ZJXG-186-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F3E-ZJXG-186-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-F',tgl_last_beli='2026-10-08 07:57:26' WHERE kode_barang='F3E-ZJXG-186-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F3E-ZJXG-186-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-08 07:57:26','TOKO','PM-F','F3E','F3E-ZJXG-186-0','1','2.130','2.130','1','2.130','2.130','100.00');
DELETE FROM tm_dept WHERE kode_dept='F3E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='F3E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='F3E-ZJXG-186-0';
DELETE FROM tm_barang_export WHERE kode_barang='F3E-ZJXG-186-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261008-0001','1','F3E-ZJXG-195-0','1','3.780','3.780','TOKO','PMBK-F','TOKO','PM-F');
DELETE FROM tm_barang WHERE kode_barang='F3E-ZJXG-195-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F3E-ZJXG-195-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-F',tgl_last_beli='2026-10-08 07:57:26' WHERE kode_barang='F3E-ZJXG-195-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F3E-ZJXG-195-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-08 07:57:26','TOKO','PM-F','F3E','F3E-ZJXG-195-0','1','3.780','3.780','1','3.780','3.780','100.00');
DELETE FROM tm_dept WHERE kode_dept='F3E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='F3E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='F3E-ZJXG-195-0';
DELETE FROM tm_barang_export WHERE kode_barang='F3E-ZJXG-195-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261008-0001','1','F3E-ZJXG-201-0','1','1.730','1.730','TOKO','PMBK-F','TOKO','PM-F');
DELETE FROM tm_barang WHERE kode_barang='F3E-ZJXG-201-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F3E-ZJXG-201-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-F',tgl_last_beli='2026-10-08 07:57:26' WHERE kode_barang='F3E-ZJXG-201-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F3E-ZJXG-201-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-08 07:57:26','TOKO','PM-F','F3E','F3E-ZJXG-201-0','1','1.730','1.730','1','1.730','1.730','100.00');
DELETE FROM tm_dept WHERE kode_dept='F3E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='F3E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='F3E-ZJXG-201-0';
DELETE FROM tm_barang_export WHERE kode_barang='F3E-ZJXG-201-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261008-0001','1','F3E-ZJXG-202-0','1','2.020','2.020','TOKO','PMBK-F','TOKO','PM-F');
DELETE FROM tm_barang WHERE kode_barang='F3E-ZJXG-202-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F3E-ZJXG-202-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-F',tgl_last_beli='2026-10-08 07:57:26' WHERE kode_barang='F3E-ZJXG-202-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F3E-ZJXG-202-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-08 07:57:26','TOKO','PM-F','F3E','F3E-ZJXG-202-0','1','2.020','2.020','1','2.020','2.020','100.00');
DELETE FROM tm_dept WHERE kode_dept='F3E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='F3E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='F3E-ZJXG-202-0';
DELETE FROM tm_barang_export WHERE kode_barang='F3E-ZJXG-202-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261008-0001','1','F3E-ZJXG-212-0','1','1.630','1.630','TOKO','PMBK-F','TOKO','PM-F');
DELETE FROM tm_barang WHERE kode_barang='F3E-ZJXG-212-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F3E-ZJXG-212-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-F',tgl_last_beli='2026-10-08 07:57:26' WHERE kode_barang='F3E-ZJXG-212-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F3E-ZJXG-212-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-08 07:57:26','TOKO','PM-F','F3E','F3E-ZJXG-212-0','1','1.630','1.630','1','1.630','1.630','100.00');
DELETE FROM tm_dept WHERE kode_dept='F3E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='F3E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='F3E-ZJXG-212-0';
DELETE FROM tm_barang_export WHERE kode_barang='F3E-ZJXG-212-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20261008-0001','2026-10-08','07:57','25.100','admpindah','2026-10-08 07:57:25');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F326080836341','input','1',' MEB1E X HW','TOKO','PM-B','B1E-ZHAE-39-0','GW X TIFF MODEL HATI CAT HW 8K ','','0.570','1','100.00','590000','0','0','15000','590000','0','5000','0','595000','FIT','00419060','B1E','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-10-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1E-ZHAE-39-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.570',berat_jual_asli=berat_jual_asli+'0.570',stock_jual='1',berat_akhir=berat_akhir-'0.570',berat_akhir_asli=berat_akhir_asli-'0.570',stock_akhir='0' WHERE tanggal='2026-10-08' AND kode_barang='B1E-ZHAE-39-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-B' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326080836341','2026-10-08','0.570','2026-10-08','08:36:34','PLG0031724','590000','590000','5000','595000','595000','input','2026-10-08 08:36:34','F32608083634');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-08','F326080836341','2026-10-08','08:36:34','FIT','595000','5000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-261008-0002','D','2026-10-08','08:36:34','input','PENJUALAN','F326080836341','7755513000','595000','7756108000');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F326080854571','input','1',' MEF3E KH ','TOKO','PM-F','F3E-ZJXE-350-0','GL ELEZTRA CANDY VAR KH 8K ','','0.700','1','100.00','724000','0','0','15000','725000','0','0','0','725000','FIT','00427841','F3E','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-10-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZJXE-350-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.700',berat_jual_asli=berat_jual_asli+'0.700',stock_jual='1',berat_akhir=berat_akhir-'0.700',berat_akhir_asli=berat_akhir_asli-'0.700',stock_akhir='0' WHERE tanggal='2026-10-08' AND kode_barang='F3E-ZJXE-350-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-F' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326080854571','2026-10-08','0.700','2026-10-08','08:54:58','PLG0031725','725000','725000','0','725000','725000','input','2026-10-08 08:54:57','F32608085457');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-08','F326080854571','2026-10-08','08:54:58','FIT','725000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-261008-0003','D','2026-10-08','08:54:58','input','PENJUALAN','F326080854571','7756108000','725000','7756833000');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F326080859091','input','1',' TDE1 X CM ','TOKO','PT-E','E1TD-ZGBH-42-T','CC X VELG SLEP CM 19 17K ','','1.500','1','100.00','2850000','0','0','15000','2850000','0','0','0','2850000','SIN','T0081642','E1TD','0','0','-','0','1910000');
UPDATE tm_barang SET tgl_last_jual='2026-10-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1TD-ZGBH-42-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.500',berat_jual_asli=berat_jual_asli+'1.500',stock_jual='1',berat_akhir=berat_akhir-'1.500',berat_akhir_asli=berat_akhir_asli-'1.500',stock_akhir='0' WHERE tanggal='2026-10-08' AND kode_barang='E1TD-ZGBH-42-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PT-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326080859091','2026-10-08','1.500','2026-10-08','08:59:10','PLG0031726','2850000','2850000','0','2850000','2850000','input','2026-10-08 08:59:09','F32608085909');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-08','F326080859091','2026-10-08','08:59:10','SIN','2850000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-261008-0004','D','2026-10-08','08:59:10','input','PENJUALAN','F326080859091','7756833000','2850000','7759683000');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F326080909581','input','1',' MEE2 X LG ','TOKO','PM-E','E2E-ZEBE-106-0','CC X BONEKA ANAK CAT MATA LG 8K ','','0.460','1','100.00','476000','0','0','15000','477000','0','0','0','477000','FIT','00404805','E2E','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-10-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-ZEBE-106-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.460',berat_jual_asli=berat_jual_asli+'0.460',stock_jual='1',berat_akhir=berat_akhir-'0.460',berat_akhir_asli=berat_akhir_asli-'0.460',stock_akhir='0' WHERE tanggal='2026-10-08' AND kode_barang='E2E-ZEBE-106-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326080909581','2026-10-08','0.460','2026-10-08','09:09:58','PLG0031727','477000','477000','0','477000','477000','input','2026-10-08 09:09:58','F32608090958');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-08','F326080909581','2026-10-08','09:09:58','FIT','477000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-261008-0005','D','2026-10-08','09:09:58','input','PENJUALAN','F326080909581','7759683000','477000','7760160000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='477000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326080909581' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F326080909582','input',' 1',' MJH2 X KH ','TOKO','PM-H','H2J-ZHAD-101-0','KL X SIEM COBRA ANAK KH 34 9K ','','1.040','1','100.00','1180000','0','0','15000','1180000','0','0','0','1180000','FIT','00418986','H2J','0','0','-','0','1135000');
UPDATE tm_barang SET tgl_last_jual='2026-10-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H2J-ZHAD-101-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.040',berat_jual_asli=berat_jual_asli+'1.040',stock_jual='1',berat_akhir=berat_akhir-'1.040',berat_akhir_asli=berat_akhir_asli-'1.040',stock_akhir='0' WHERE tanggal='2026-10-08' AND kode_barang='H2J-ZHAD-101-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-H' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326080909582','2026-10-08','1.040','2026-10-08','09:09:58','PLG0031728','1180000','1180000','0','1180000','1180000','input','2026-10-08 09:09:58','F32608090958');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-08','F326080909582','2026-10-08','09:09:58','FIT','1180000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-261008-0006','D','2026-10-08','09:09:58','input','PENJUALAN','F326080909582','7760160000','1180000','7761340000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1180000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326080909582' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F326080913291','input','1',' MFE1 KH 12','TOKO','PM-E','E1F-ZICX-15-0','CC MODEL ARESO SLEP KH 12 8K ','','0.310','1','100.00','330000','0','0','15000','328000','0','0','0','328000','AAT','00426424','E1F','0','0','-','1','1065000');
UPDATE tm_barang SET tgl_last_jual='2026-10-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1F-ZICX-15-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.310',berat_jual_asli=berat_jual_asli+'0.310',stock_jual='1',berat_akhir=berat_akhir-'0.310',berat_akhir_asli=berat_akhir_asli-'0.310',stock_akhir='0' WHERE tanggal='2026-10-08' AND kode_barang='E1F-ZICX-15-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326080913291','2026-10-08','0.310','2026-10-08','09:13:30','PLG0031729','328000','328000','0','328000','328000','input','2026-10-08 09:13:29','F32608091329');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-08','F326080913291','2026-10-08','09:13:30','AAT','328000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-261008-0007','D','2026-10-08','09:13:30','input','PENJUALAN','F326080913291','7761340000','328000','7761668000');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F326080921461','input','1',' MGB1G X CM','TOKO','PM-B','B1G-ZIBE-50-0','GW X TUSUK DAISY MATA CM 8K ','','0.220','1','100.00','236000','0','0','15000','235000','0','0','0','235000','SIN','00425425','B1G','0','0','-','1','1075000');
UPDATE tm_barang SET tgl_last_jual='2026-10-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1G-ZIBE-50-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.220',berat_jual_asli=berat_jual_asli+'0.220',stock_jual='1',berat_akhir=berat_akhir-'0.220',berat_akhir_asli=berat_akhir_asli-'0.220',stock_akhir='0' WHERE tanggal='2026-10-08' AND kode_barang='B1G-ZIBE-50-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-B' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326080921461','2026-10-08','0.220','2026-10-08','09:21:46','PLG0031730','235000','235000','0','235000','235000','input','2026-10-08 09:21:46','F32608092146');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-08','F326080921461','2026-10-08','09:21:46','SIN','235000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-261008-0008','D','2026-10-08','09:21:46','input','PENJUALAN','F326080921461','7761668000','235000','7761903000');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F326080927051','input','1',' MDA1D X LG','TOKO','PM-A','A1D-YLAE-33-0','AT X MODEL KLIP MATA LG 8K ','','1.000','1','100.00','1015000','0','0','15000','1015000','0','0','0','1015000','LIS','00381011','A1D','0','0','-','0','1025000');
UPDATE tm_barang SET tgl_last_jual='2026-10-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1D-YLAE-33-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.000',berat_jual_asli=berat_jual_asli+'1.000',stock_jual='1',berat_akhir=berat_akhir-'1.000',berat_akhir_asli=berat_akhir_asli-'1.000',stock_akhir='0' WHERE tanggal='2026-10-08' AND kode_barang='A1D-YLAE-33-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-A' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326080927051','2026-10-08','1.000','2026-10-08','09:27:06','PLG0031731','1015000','1015000','0','1015000','1015000','input','2026-10-08 09:27:05','F32608092705');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-08','F326080927051','2026-10-08','09:27:06','LIS','1015000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-261008-0009','D','2026-10-08','09:27:06','input','PENJUALAN','F326080927051','7761903000','1015000','7762918000');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F326080935421','input','1',' TFE2 X MT ','TOKO','PT-E','E2TF-UFAF-53-T','CC X WEDDING MATA MT 22 ','','3.230','1','100.00','6266000','0','0','15000','6265000','0','0','0','6265000','FIT','T0009249','E2TF','0','0','-','1','1940000');
UPDATE tm_barang SET tgl_last_jual='2026-10-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2TF-UFAF-53-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.230',berat_jual_asli=berat_jual_asli+'3.230',stock_jual='1',berat_akhir=berat_akhir-'3.230',berat_akhir_asli=berat_akhir_asli-'3.230',stock_akhir='0' WHERE tanggal='2026-10-08' AND kode_barang='E2TF-UFAF-53-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PT-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326080935421','2026-10-08','3.230','2026-10-08','09:35:42','PLG0031732','6265000','6265000','0','6265000','6265000','input','2026-10-08 09:35:42','F32608093542');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-08','F326080935421','2026-10-08','09:35:42','FIT','6265000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-261008-0010','D','2026-10-08','09:35:42','input','PENJUALAN','F326080935421','7762918000','6265000','7769183000');
INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00020448','X-00020448','LT COR M 8K','GR','---','D2E','BELI','BELI001','407000','2026-10-08','0.680','1','kasir','2026-10-08 10:26:11');
DELETE FROM tp_barang WHERE kode_dept = 'X-D2E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-D2E','X-00020448','X-00020448');
INSERT INTO tt_beli_detail(no_faktur_beli,no_faktur_ext,sales_id,no_urut,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,nama_barang,berat_nota,berat,kadar,harga_nota,harga_beli,harga_rata,harga_skrg,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-261008-0001','t0018162','AAT','1','BELI','BELI001','D2E', 'X-00020448', 'LT COR M 8K','0.680','0.680','100.00','292000','407000','598529','1045000','1','407000','407000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.680',berat_beli_asli=berat_beli_asli+'0.680',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.680',berat_akhir_asli=berat_akhir_asli+'0.680',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-10-08' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='D2E' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-261008-0001','2026-10-08','2026-10-08','10:26:11','AAT','---','0.680','407000','407000','407000','407000','407000','kasir','2026-10-08 10:26:11','FB-261008-0001');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261008-0001','WAHYU','WONOGIRI','','','','kasir','2026-10-08 10:26:11');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-10-08' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-261008-0011','K','2026-10-08','10:26:11','kasir','PEMBELIAN UMUM','FB-261008-0001','7769183000','407000','7768776000');
INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00020449','X-00020449','KL KADAR 8K','GR','---','H1E','BELI','BELI001','1545000','2026-10-08','1.630','1','kasir','2026-10-08 10:28:42');
DELETE FROM tp_barang WHERE kode_dept = 'X-H1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-H1E','X-00020449','X-00020449');
INSERT INTO tt_beli_detail(no_faktur_beli,no_faktur_ext,sales_id,no_urut,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,nama_barang,berat_nota,berat,kadar,harga_nota,harga_beli,harga_rata,harga_skrg,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-261008-0002','00377706','AAT','1','BELI','BELI001','H1E', 'X-00020449', 'KL KADAR 8K','1.630','1.630','100.00','1680000','1545000','947853','1045000','1','1545000','1545000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.630',berat_beli_asli=berat_beli_asli+'1.630',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.630',berat_akhir_asli=berat_akhir_asli+'1.630',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-10-08' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='H1E' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-261008-0002','2026-10-08','2026-10-08','10:28:42','AAT','---','1.630','1545000','1545000','1545000','1545000','1545000','kasir','2026-10-08 10:28:42','FB-261008-0002');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261008-0002','GENDIS','PACITAN','','','','kasir','2026-10-08 10:28:42');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-10-08' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-261008-0012','K','2026-10-08','10:28:42','kasir','PEMBELIAN UMUM','FB-261008-0002','7768776000','1545000','7767231000');
INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00020450','X-00020450','CC X VELG SLEP OR 18','GR','---','E1TE','BELI','BELI001','1795000','2026-10-08','1.000','1','kasir','2026-10-08 10:29:07');
DELETE FROM tp_barang WHERE kode_dept = 'X-E1TE';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E1TE','X-00020450','X-00020450');
INSERT INTO tt_beli_detail(no_faktur_beli,no_faktur_ext,sales_id,no_urut,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,nama_barang,berat_nota,berat,kadar,harga_nota,harga_beli,harga_rata,harga_skrg,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-261008-0003','F326120846571','SIN','1','BELI','BELI001','E1TE', 'X-00020450', 'CC X VELG SLEP OR 18','1.000','1.000','100.00','2030000','1795000','1795000','1930000','1','1795000','1795000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.000',berat_beli_asli=berat_beli_asli+'1.000',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.000',berat_akhir_asli=berat_akhir_asli+'1.000',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-10-08' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E1TE' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-261008-0003','2026-10-08','2026-10-08','10:29:07','SIN','---','1.000','1795000','1795000','1795000','1795000','1795000','kasir','2026-10-08 10:29:07','FB-261008-0003');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261008-0003','BU YULI','NADI','','','','kasir','2026-10-08 10:29:07');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-10-08' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-261008-0013','K','2026-10-08','10:29:07','kasir','PEMBELIAN UMUM','FB-261008-0003','7767231000','1795000','7765436000');
INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00020451','X-00020451','CC X MODEL MATA TD 10 8K','GR','---','E2D','BELI','BELI001','980000','2026-10-08','1.030','1','kasir','2026-10-08 10:29:32');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2D';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2D','X-00020451','X-00020451');
INSERT INTO tt_beli_detail(no_faktur_beli,no_faktur_ext,sales_id,no_urut,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,nama_barang,berat_nota,berat,kadar,harga_nota,harga_beli,harga_rata,harga_skrg,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-261008-0004','F326271048211','FIT','1','BELI','BELI001','E2D', 'X-00020451', 'CC X MODEL MATA TD 10 8K','1.030','1.030','100.00','1123000','980000','951456','1025000','1','980000','980000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.030',berat_beli_asli=berat_beli_asli+'1.030',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.030',berat_akhir_asli=berat_akhir_asli+'1.030',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-10-08' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E2D' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-261008-0004','2026-10-08','2026-10-08','10:29:32','FIT','---','1.030','980000','980000','980000','980000','980000','kasir','2026-10-08 10:29:32','FB-261008-0004');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261008-0004','WULAN','TINASAT KISMANTORO','','','','kasir','2026-10-08 10:29:32');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-10-08' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-261008-0014','K','2026-10-08','10:29:32','kasir','PEMBELIAN UMUM','FB-261008-0004','7765436000','980000','7764456000');
INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00020452','X-00020452','CC MODEL APEL CAT LG 10 8K','GR','---','E1E','BELI','BELI001','345000','2026-10-08','0.510','1','kasir','2026-10-08 10:30:00');
DELETE FROM tp_barang WHERE kode_dept = 'X-E1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E1E','X-00020452','X-00020452');
INSERT INTO tt_beli_detail(no_faktur_beli,no_faktur_ext,sales_id,no_urut,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,nama_barang,berat_nota,berat,kadar,harga_nota,harga_beli,harga_rata,harga_skrg,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-261008-0005','F324210932021','AAT','1','BELI','BELI001','E1E', 'X-00020452', 'CC MODEL APEL CAT LG 10 8K','0.510','0.510','100.00','335000','345000','676471','1045000','1','345000','345000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.510',berat_beli_asli=berat_beli_asli+'0.510',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.510',berat_akhir_asli=berat_akhir_asli+'0.510',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-10-08' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E1E' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-261008-0005','2026-10-08','2026-10-08','10:29:59','AAT','---','0.510','345000','345000','345000','345000','345000','kasir','2026-10-08 10:30:00','FB-261008-0005');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261008-0005','ANIK','LEMAHDUWUR JOHO','','','','kasir','2026-10-08 10:30:00');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-10-08' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-261008-0015','K','2026-10-08','10:29:59','kasir','PEMBELIAN UMUM','FB-261008-0005','7764456000','345000','7764111000');
INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00020453','X-00020453','LT MODEL MATA UB','GR','---','D2E','BELI','BELI001','1325000','2026-10-08','1.380','1','kasir','2026-10-08 10:30:28');
DELETE FROM tp_barang WHERE kode_dept = 'X-D2E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-D2E','X-00020453','X-00020453');
INSERT INTO tt_beli_detail(no_faktur_beli,no_faktur_ext,sales_id,no_urut,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,nama_barang,berat_nota,berat,kadar,harga_nota,harga_beli,harga_rata,harga_skrg,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-261008-0006','F326230304172','SIN','1','BELI','BELI001','D2E', 'X-00020453', 'LT MODEL MATA UB','1.380','1.380','100.00','1453000','1325000','960145','1045000','1','1325000','1325000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.380',berat_beli_asli=berat_beli_asli+'1.380',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.380',berat_akhir_asli=berat_akhir_asli+'1.380',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-10-08' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='D2E' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-261008-0006','2026-10-08','2026-10-08','10:30:27','SIN','---','1.380','1325000','1325000','1325000','1325000','1325000','kasir','2026-10-08 10:30:28','FB-261008-0006');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261008-0006','DAMIYEM','BUGELAN KISMANTORO','','','','kasir','2026-10-08 10:30:28');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-10-08' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-261008-0016','K','2026-10-08','10:30:27','kasir','PEMBELIAN UMUM','FB-261008-0006','7764111000','1325000','7762786000');
INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00020454','X-00020454','LT X SLOBOK BULAT SLEP BG 8K','GR','---','D1G','BELI','BELI001','332000','2026-10-08','0.340','1','kasir','2026-10-08 10:31:04');
DELETE FROM tp_barang WHERE kode_dept = 'X-D1G';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-D1G','X-00020454','X-00020454');
INSERT INTO tt_beli_detail(no_faktur_beli,no_faktur_ext,sales_id,no_urut,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,nama_barang,berat_nota,berat,kadar,harga_nota,harga_beli,harga_rata,harga_skrg,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-261008-0007','F326050926071','FIT','1','BELI','BELI001','D1G', 'X-00020454', 'LT X SLOBOK BULAT SLEP BG 8K','0.340','0.340','100.00','380000','332000','976471','1075000','1','332000','332000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.340',berat_beli_asli=berat_beli_asli+'0.340',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.340',berat_akhir_asli=berat_akhir_asli+'0.340',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-10-08' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='D1G' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-261008-0007','2026-10-08','2026-10-08','10:31:04','FIT','---','0.340','332000','332000','332000','332000','332000','kasir','2026-10-08 10:31:04','FB-261008-0007');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261008-0007','FARIDA','JOHO','','','085713823708','kasir','2026-10-08 10:31:04');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-10-08' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-261008-0017','K','2026-10-08','10:31:04','kasir','PEMBELIAN UMUM','FB-261008-0007','7762786000','332000','7762454000');
INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00020455','X-00020455','LT X MODEL HURUF MATA LG C','GR','---','D2F','BELI','BELI001','400000','2026-10-08','0.500','1','kasir','2026-10-08 10:31:04');
DELETE FROM tp_barang WHERE kode_dept = 'X-D2F';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-D2F','X-00020455','X-00020455');
INSERT INTO tt_beli_detail(no_faktur_beli,no_faktur_ext,sales_id,no_urut,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,nama_barang,berat_nota,berat,kadar,harga_nota,harga_beli,harga_rata,harga_skrg,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-261008-0008','F325250958341','FIT','2','BELI','BELI001','D2F', 'X-00020455', 'LT X MODEL HURUF MATA LG C','0.500','0.500','100.00','425000','400000','800000','1065000','1','400000','400000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.500',berat_beli_asli=berat_beli_asli+'0.500',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.500',berat_akhir_asli=berat_akhir_asli+'0.500',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-10-08' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='D2F' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-261008-0008','2026-10-08','2026-10-08','10:31:04','FIT','---','0.500','400000','400000','400000','400000','400000','kasir','2026-10-08 10:31:04','FB-261008-0007');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261008-0008','FARIDA','JOHO PURWANTORO','','','','kasir','2026-10-08 10:31:04');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-10-08' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-261008-0018','K','2026-10-08','10:31:04','kasir','PEMBELIAN UMUM','FB-261008-0008','7762454000','400000','7762054000');
INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00020456','X-00020456','GL XX RANTAI HOLLOW P3 SLEP LT 8K','GR','---','F3E','BELI','BELI001','982000','2026-10-08','1.030','1','kasir','2026-10-08 10:41:01');
DELETE FROM tp_barang WHERE kode_dept = 'X-F3E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F3E','X-00020456','X-00020456');
INSERT INTO tt_beli_detail(no_faktur_beli,no_faktur_ext,sales_id,no_urut,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,nama_barang,berat_nota,berat,kadar,harga_nota,harga_beli,harga_rata,harga_skrg,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-261008-0009','F326050104162','LIS','1','BELI','BELI001','F3E', 'X-00020456', 'GL XX RANTAI HOLLOW P3 SLEP LT 8K','1.030','1.030','100.00','1035000','982000','953398','1045000','1','982000','982000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.030',berat_beli_asli=berat_beli_asli+'1.030',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.030',berat_akhir_asli=berat_akhir_asli+'1.030',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-10-08' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='F3E' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-261008-0009','2026-10-08','2026-10-08','10:41:01','LIS','---','1.030','982000','982000','982000','982000','982000','kasir','2026-10-08 10:41:01','FB-261008-0009');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261008-0009','ANISA','NAWANGAN PCT','','','','kasir','2026-10-08 10:41:01');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-10-08' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-261008-0019','K','2026-10-08','10:41:01','kasir','PEMBELIAN UMUM','FB-261008-0009','7762054000','982000','7761072000');
INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00020457','X-00020457','GW X TUSUK MRICAN SLEP AV 8K','GR','---','B1H','BELI','BELI001','257000','2026-10-08','0.260','1','kasir','2026-10-08 10:41:45');
DELETE FROM tp_barang WHERE kode_dept = 'X-B1H';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-B1H','X-00020457','X-00020457');
INSERT INTO tt_beli_detail(no_faktur_beli,no_faktur_ext,sales_id,no_urut,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,nama_barang,berat_nota,berat,kadar,harga_nota,harga_beli,harga_rata,harga_skrg,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-261008-0010','F326061110021','FIT','1','BELI','BELI001','B1H', 'X-00020457', 'GW X TUSUK MRICAN SLEP AV 8K','0.260','0.260','100.00','288000','257000','988462','1095000','1','257000','257000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.260',berat_beli_asli=berat_beli_asli+'0.260',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.260',berat_akhir_asli=berat_akhir_asli+'0.260',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-10-08' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='B1H' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-261008-0010','2026-10-08','2026-10-08','10:41:45','FIT','---','0.260','257000','257000','257000','257000','257000','kasir','2026-10-08 10:41:45','FB-261008-0010');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261008-0010','ASTRID','JANGGIR SUMBER','','','','kasir','2026-10-08 10:41:45');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-10-08' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-261008-0020','K','2026-10-08','10:41:45','kasir','PEMBELIAN UMUM','FB-261008-0010','7761072000','257000','7760815000');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F326081105451','kasir','1',' MDE2D CM 1','TOKO','PM-E','E2D-ZHBA-191-0','CC MODEL MATA SLEP CM 10 8K ','','1.250','1','100.00','1269000','0','0','15000','1270000','0','0','0','1270000','LIS','00419770','E2D','0','0','-','0','1025000');
UPDATE tm_barang SET tgl_last_jual='2026-10-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZHBA-191-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.250',berat_jual_asli=berat_jual_asli+'1.250',stock_jual='1',berat_akhir=berat_akhir-'1.250',berat_akhir_asli=berat_akhir_asli-'1.250',stock_akhir='0' WHERE tanggal='2026-10-08' AND kode_barang='E2D-ZHBA-191-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326081105451','2026-10-08','1.250','2026-10-08','11:05:45','PLG0031733','1270000','1270000','0','1270000','1270000','kasir','2026-10-08 11:05:45','F32608110545');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-08','F326081105451','2026-10-08','11:05:45','LIS','1270000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-261008-0021','D','2026-10-08','11:05:45','kasir','PENJUALAN','F326081105451','7760815000','1270000','7762085000');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F326081118531','kasir','1',' TDE2 X CM ','TOKO','PT-E','E2TD-YLAC-23-T','CC X COR MODEL MATA CM 17K ','olw','1.080','1','100.00','2052000','0','0','15000','2075000','0','10000','0','2085000','SIN','T0075758','E2TD','0','0','-','0','1910000');
UPDATE tm_barang SET tgl_last_jual='2026-10-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2TD-YLAC-23-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.080',berat_jual_asli=berat_jual_asli+'1.080',stock_jual='1',berat_akhir=berat_akhir-'1.080',berat_akhir_asli=berat_akhir_asli-'1.080',stock_akhir='0' WHERE tanggal='2026-10-08' AND kode_barang='E2TD-YLAC-23-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PT-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326081118531','2026-10-08','1.080','2026-10-08','11:18:53','PLG0031734','2075000','2075000','10000','2085000','2085000','kasir','2026-10-08 11:18:53','F32608111853');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-08','F326081118531','2026-10-08','11:18:53','SIN','2085000','10000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-261008-0022','D','2026-10-08','11:18:53','kasir','PENJUALAN','F326081118531','7762085000','2085000','7764170000');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F326081124281','kasir','1',' MGA1G X CM','TOKO','PM-A','A1E-ZIBE-36-0','AT X DAKOCAN ANAK LG 8K','','0.300','1','100.00','310000','0','0','15000','323000','0','0','0','323000','LIS','00425411','A1E','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-10-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1E-ZIBE-36-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.300',berat_jual_asli=berat_jual_asli+'0.300',stock_jual='1',berat_akhir=berat_akhir-'0.300',berat_akhir_asli=berat_akhir_asli-'0.300',stock_akhir='0' WHERE tanggal='2026-10-08' AND kode_barang='A1E-ZIBE-36-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-A' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326081124281','2026-10-08','0.300','2026-10-08','11:24:29','PLG0031735','323000','323000','0','323000','323000','kasir','2026-10-08 11:24:28','F32608112428');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-08','F326081124281','2026-10-08','11:24:29','LIS','323000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-261008-0023','D','2026-10-08','11:24:29','kasir','PENJUALAN','F326081124281','7764170000','323000','7764493000');
INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00020458','X-00020458','GL COR T 8K','GR','---','F1E','BELI','BELI001','1830000','2026-10-08','2.480','1','kasir','2026-10-08 12:44:44');
DELETE FROM tp_barang WHERE kode_dept = 'X-F1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F1E','X-00020458','X-00020458');
INSERT INTO tt_beli_detail(no_faktur_beli,no_faktur_ext,sales_id,no_urut,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,nama_barang,berat_nota,berat,kadar,harga_nota,harga_beli,harga_rata,harga_skrg,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-261008-0011','F321210112591','LIS','1','BELI','BELI001','F1E', 'X-00020458', 'GL COR T 8K','2.480','2.480','100.00','992000','1830000','737903','1045000','1','1830000','1830000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'2.480',berat_beli_asli=berat_beli_asli+'2.480',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'2.480',berat_akhir_asli=berat_akhir_asli+'2.480',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-10-08' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='F1E' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-261008-0011','2026-10-08','2026-10-08','12:44:43','LIS','---','2.480','1830000','1830000','1830000','1830000','1830000','kasir','2026-10-08 12:44:44','FB-261008-0011');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261008-0011','AYUK RIANA','SUMBER GALIH','','','','kasir','2026-10-08 12:44:44');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-10-08' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-261008-0024','K','2026-10-08','12:44:43','kasir','PEMBELIAN UMUM','FB-261008-0011','7764493000','1830000','7762663000');
INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00020459','X-00020459','CC X MODEL MATA CSA 17','GR','---','E2TE','BELI','BELI001','3405000','2026-10-08','2.510','1','kasir','2026-10-08 12:44:44');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2TE';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2TE','X-00020459','X-00020459');
INSERT INTO tt_beli_detail(no_faktur_beli,no_faktur_ext,sales_id,no_urut,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,nama_barang,berat_nota,berat,kadar,harga_nota,harga_beli,harga_rata,harga_skrg,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-261008-0012','F322121205231','LIS','2','BELI','BELI001','E2TE', 'X-00020459', 'CC X MODEL MATA CSA 17','2.510','2.510','100.00','1810000','3405000','1356574','1930000','1','3405000','3405000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'2.510',berat_beli_asli=berat_beli_asli+'2.510',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'2.510',berat_akhir_asli=berat_akhir_asli+'2.510',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-10-08' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E2TE' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-261008-0012','2026-10-08','2026-10-08','12:44:43','LIS','---','2.510','3405000','3405000','3405000','3405000','3405000','kasir','2026-10-08 12:44:44','FB-261008-0011');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261008-0012','AYUK RIANA','SUMBERGALIH','','','','kasir','2026-10-08 12:44:44');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-10-08' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-261008-0025','K','2026-10-08','12:44:43','kasir','PEMBELIAN UMUM','FB-261008-0012','7762663000','3405000','7759258000');
INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00020460','X-00020460','AS EXTENTION DG 8K','GR','---','S1G','BELI','BELI001','195000','2026-10-08','0.200','1','kasir','2026-10-08 12:45:02');
DELETE FROM tp_barang WHERE kode_dept = 'X-S1G';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-S1G','X-00020460','X-00020460');
INSERT INTO tt_beli_detail(no_faktur_beli,no_faktur_ext,sales_id,no_urut,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,nama_barang,berat_nota,berat,kadar,harga_nota,harga_beli,harga_rata,harga_skrg,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-261008-0013','F326050215001','SIN','1','BELI','BELI001','S1G', 'X-00020460', 'AS EXTENTION DG 8K','0.200','0.200','100.00','217000','195000','975000','1075000','1','195000','195000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.200',berat_beli_asli=berat_beli_asli+'0.200',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.200',berat_akhir_asli=berat_akhir_asli+'0.200',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-10-08' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='S1G' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-261008-0013','2026-10-08','2026-10-08','12:45:02','SIN','---','0.200','195000','195000','195000','195000','195000','kasir','2026-10-08 12:45:02','FB-261008-0013');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261008-0013','NINUK','KARANGLO TEGALREJO','','','','kasir','2026-10-08 12:45:02');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-10-08' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-261008-0026','K','2026-10-08','12:45:02','kasir','PEMBELIAN UMUM','FB-261008-0013','7759258000','195000','7759063000');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F326080116191','kasir','1',' MEF1 X UB ','TOKO','PM-F','F1E-ZJXF-196-0','GL X OVAL C SLEP UB 58 8K ','','2.220','1','100.00','2298000','0','0','15000','2298000','0','0','0','2298000','SIN','00428100','F1E','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-10-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-ZJXF-196-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.220',berat_jual_asli=berat_jual_asli+'2.220',stock_jual='1',berat_akhir=berat_akhir-'2.220',berat_akhir_asli=berat_akhir_asli-'2.220',stock_akhir='0' WHERE tanggal='2026-10-08' AND kode_barang='F1E-ZJXF-196-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-F' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326080116191','2026-10-08','2.220','2026-10-08','13:16:19','PLG0031736','2298000','2298000','0','2298000','2298000','kasir','2026-10-08 13:16:19','F32608011619');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-08','F326080116191','2026-10-08','13:16:19','SIN','2298000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-261008-0027','D','2026-10-08','13:16:19','kasir','PENJUALAN','F326080116191','7759063000','2298000','7761361000');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F326080126321','kasir','1',' MEF1 X 56 ','TOKO','PM-F','F1E-ZHAD-68-0','GL X OVAL C GELOMBANG TD 56 8K ','','3.000','1','100.00','3105000','0','0','15000','3105000','0','0','0','3105000','SIN','00418953','F1E','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-10-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-ZHAD-68-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.000',berat_jual_asli=berat_jual_asli+'3.000',stock_jual='1',berat_akhir=berat_akhir-'3.000',berat_akhir_asli=berat_akhir_asli-'3.000',stock_akhir='0' WHERE tanggal='2026-10-08' AND kode_barang='F1E-ZHAD-68-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-F' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326080126321','2026-10-08','3.000','2026-10-08','13:26:33','PLG0031737','3105000','3105000','0','3105000','3105000','kasir','2026-10-08 13:26:32','F32608012632');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-08','F326080126321','2026-10-08','13:26:33','SIN','3105000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-261008-0028','D','2026-10-08','13:26:33','kasir','PENJUALAN','F326080126321','7761361000','3105000','7764466000');
INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00020461','X-00020461','KL X MILANO UB 42 8K','GR','---','H1E','BELI','BELI001','1930000','2026-10-08','2.100','1','kasir','2026-10-08 13:34:54');
DELETE FROM tp_barang WHERE kode_dept = 'X-H1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-H1E','X-00020461','X-00020461');
INSERT INTO tt_beli_detail(no_faktur_beli,no_faktur_ext,sales_id,no_urut,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,nama_barang,berat_nota,berat,kadar,harga_nota,harga_beli,harga_rata,harga_skrg,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-261008-0014','F326121058181','SIN','1','BELI','BELI001','H1E', 'X-00020461', 'KL X MILANO UB 42 8K','2.100','2.100','100.00','2299000','1930000','919048','1045000','1','1930000','1930000','RUSAK');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'2.100',berat_beli_asli=berat_beli_asli+'2.100',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'2.100',berat_akhir_asli=berat_akhir_asli+'2.100',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-10-08' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='H1E' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-261008-0014','2026-10-08','2026-10-08','13:34:53','SIN','---','2.100','1930000','1930000','1930000','1930000','1930000','kasir','2026-10-08 13:34:54','FB-261008-0014');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261008-0014','SUSILO','POJOK PADARANGIN SLOGOHIMO','','','081287333795','kasir','2026-10-08 13:34:54');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-10-08' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-261008-0029','K','2026-10-08','13:34:53','kasir','PEMBELIAN UMUM','FB-261008-0014','7764466000','1930000','7762536000');
INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00020462','X-00020462','AT COR 8K','GR','---','A1E','BELI','BELI001','192000','2026-10-08','0.270','1','kasir','2026-10-08 14:16:17');
DELETE FROM tp_barang WHERE kode_dept = 'X-A1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-A1E','X-00020462','X-00020462');
INSERT INTO tt_beli_detail(no_faktur_beli,no_faktur_ext,sales_id,no_urut,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,nama_barang,berat_nota,berat,kadar,harga_nota,harga_beli,harga_rata,harga_skrg,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-261008-0015','F323060935511','LIS','1','BELI','BELI001','A1E', 'X-00020462', 'AT COR 8K','0.530','0.270','100.00','248000','192000','711111','1045000','1','192000','192000','RUSAK');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.270',berat_beli_asli=berat_beli_asli+'0.270',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.270',berat_akhir_asli=berat_akhir_asli+'0.270',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-10-08' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='A1E' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-261008-0015','2026-10-08','2026-10-08','14:16:17','LIS','---','0.270','192000','192000','192000','192000','192000','kasir','2026-10-08 14:16:17','FB-261008-0015');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261008-0015','AJENG','TINASAT KISMANTORO','','','','kasir','2026-10-08 14:16:17');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-10-08' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-261008-0030','K','2026-10-08','14:16:17','kasir','PEMBELIAN UMUM','FB-261008-0015','7762536000','192000','7762344000');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F326080243061','kasir','1',' MDE1 UB 14','TOKO','PM-E','E1D-ZJXB-283-0','CC MODEL SLEP UB 14 8K ','','1.100','1','100.00','1127000','0','0','15000','1117000','0','0','0','1117000','LIS','00427092','E1D','0','0','-','1','1025000');
UPDATE tm_barang SET tgl_last_jual='2026-10-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-ZJXB-283-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.100',berat_jual_asli=berat_jual_asli+'1.100',stock_jual='1',berat_akhir=berat_akhir-'1.100',berat_akhir_asli=berat_akhir_asli-'1.100',stock_akhir='0' WHERE tanggal='2026-10-08' AND kode_barang='E1D-ZJXB-283-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326080243061','2026-10-08','1.100','2026-10-08','14:43:07','PLG0031738','1117000','1117000','0','1117000','1117000','kasir','2026-10-08 14:43:06','F32608024306');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-08','F326080243061','2026-10-08','14:43:07','LIS','1117000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-261008-0031','D','2026-10-08','14:43:07','kasir','PENJUALAN','F326080243061','7762344000','1117000','7763461000');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F326080244301','kasir','1',' MEE2 5K LG','TOKO','PM-E','E2E-ZDBE-396-0','CC OSROT ANAK BONEKA CAT MATA LG 8K ','','0.510','1','100.00','528000','0','0','15000','528000','0','5000','0','533000','SIN','00401164','E2E','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-10-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-ZDBE-396-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.510',berat_jual_asli=berat_jual_asli+'0.510',stock_jual='1',berat_akhir=berat_akhir-'0.510',berat_akhir_asli=berat_akhir_asli-'0.510',stock_akhir='0' WHERE tanggal='2026-10-08' AND kode_barang='E2E-ZDBE-396-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326080244301','2026-10-08','0.510','2026-10-08','14:44:31','PLG0031739','528000','528000','5000','533000','533000','kasir','2026-10-08 14:44:30','F32608024430');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-08','F326080244301','2026-10-08','14:44:31','SIN','533000','5000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-261008-0032','D','2026-10-08','14:44:31','kasir','PENJUALAN','F326080244301','7763461000','533000','7763994000');
INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00020463','X-00020463','GW TOGE MODEL MATA VAR LG 8K','GR','---','B1F','BELI','BELI001','337000','2026-10-08','0.500','1','kasir','2026-10-08 14:45:10');
DELETE FROM tp_barang WHERE kode_dept = 'X-B1F';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-B1F','X-00020463','X-00020463');
INSERT INTO tt_beli_detail(no_faktur_beli,no_faktur_ext,sales_id,no_urut,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,nama_barang,berat_nota,berat,kadar,harga_nota,harga_beli,harga_rata,harga_skrg,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-261008-0016','F325060859141','SIN','1','BELI','BELI001','B1F', 'X-00020463', 'GW TOGE MODEL MATA VAR LG 8K','0.500','0.500','100.00','363000','337000','674000','1065000','1','337000','337000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.500',berat_beli_asli=berat_beli_asli+'0.500',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.500',berat_akhir_asli=berat_akhir_asli+'0.500',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-10-08' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='B1F' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-261008-0016','2026-10-08','2026-10-08','14:45:10','SIN','---','0.500','337000','337000','337000','337000','337000','kasir','2026-10-08 14:45:10','FB-261008-0016');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261008-0016','NONIEK JINGGA FOUMIDA','NGROTO KISMANTORO','','','','kasir','2026-10-08 14:45:10');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-10-08' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-261008-0033','K','2026-10-08','14:45:10','kasir','PEMBELIAN UMUM','FB-261008-0016','7763994000','337000','7763657000');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F326080253071','kasir','1',' MEF2 XXX P','TOKO','PM-F','F2E-YLAX-204-0','GL XXX PIPA MATA PM 56 8K ','','3.930','1','100.00','4068000','0','0','15000','3950000','0','0','0','3950000','AAT','00380550','F2E','0','0','-','1','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-10-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F2E-YLAX-204-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.930',berat_jual_asli=berat_jual_asli+'3.930',stock_jual='1',berat_akhir=berat_akhir-'3.930',berat_akhir_asli=berat_akhir_asli-'3.930',stock_akhir='0' WHERE tanggal='2026-10-08' AND kode_barang='F2E-YLAX-204-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-F' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326080253071','2026-10-08','3.930','2026-10-08','14:53:07','PLG0031740','3950000','3950000','0','3950000','3950000','kasir','2026-10-08 14:53:07','F32608025307');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-08','F326080253071','2026-10-08','14:53:07','AAT','3950000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-261008-0034','D','2026-10-08','14:53:07','kasir','PENJUALAN','F326080253071','7763657000','3950000','7767607000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='3950000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326080253071' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F326080253072','kasir',' 1',' MDE1 X CM ','TOKO','PM-E','E1D-ZCAI-527-0','CC X WEDDING POLOS CM 14 8K ','','1.480','1','100.00','1502000','0','0','15000','1503000','0','0','0','1503000','AAT','00395925','E1D','0','0','-','0','1025000');
UPDATE tm_barang SET tgl_last_jual='2026-10-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-ZCAI-527-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.480',berat_jual_asli=berat_jual_asli+'1.480',stock_jual='1',berat_akhir=berat_akhir-'1.480',berat_akhir_asli=berat_akhir_asli-'1.480',stock_akhir='0' WHERE tanggal='2026-10-08' AND kode_barang='E1D-ZCAI-527-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326080253072','2026-10-08','1.480','2026-10-08','14:53:07','PLG0031741','1503000','1503000','0','1503000','1503000','kasir','2026-10-08 14:53:07','F32608025307');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-08','F326080253072','2026-10-08','14:53:07','AAT','1503000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-261008-0035','D','2026-10-08','14:53:07','kasir','PENJUALAN','F326080253072','7767607000','1503000','7769110000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1503000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326080253072' LIMIT 1;
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261008-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261008-0001';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261008-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261008-0002';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261008-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261008-0003';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261008-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261008-0004';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261008-0005' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261008-0005';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261008-0006' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261008-0006';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261008-0007' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261008-0007';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261008-0008' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261008-0008';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261008-0009' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261008-0009';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261008-0010' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261008-0010';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261008-0011' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261008-0011';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261008-0012' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261008-0012';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261008-0013' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261008-0013';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261008-0014' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261008-0014';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261008-0015' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261008-0015';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261008-0016' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261008-0016';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326080116191' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326080116191' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326080116191';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326080126321' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326080126321' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326080126321';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326080243061' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326080243061' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326080243061';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326080244301' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326080244301' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326080244301';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326080253071' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326080253071' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326080253071';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326080253072' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326080253072' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326080253072';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326080836341' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326080836341' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326080836341';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326080854571' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326080854571' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326080854571';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326080859091' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326080859091' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326080859091';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326080909581' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326080909581' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326080909581';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326080909582' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326080909582' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326080909582';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326080913291' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326080913291' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326080913291';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326080921461' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326080921461' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326080921461';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326080927051' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326080927051' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326080927051';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326080935421' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326080935421' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326080935421';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326081105451' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326081105451' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326081105451';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326081118531' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326081118531' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326081118531';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326081124281' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326081124281' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326081124281';
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-10-09','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2026-09-08';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-10-08';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-10-08';
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-10-08' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-10-08';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-10-08';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-10-08';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-10-08';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202609 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-09';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-09';
UPDATE tt_barang_saldo SET tanggal= '2026-10-09' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-10-08' OR stock_akhir*1<0  OR kode_lokasi_gudang='' OR kode_lokasi_toko='' OR status_close='CLOS';
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-261009-0001','D','2026-10-09','15:17:19','SYSTEM','SALDO AWAL','SALDO AWAL','0','7769110000','7769110000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-261009-0001','D','2026-10-09','15:17:19','DLL','SALDO AWAL','SALDO AWAL','0','0','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-261009-0001','D','2026-10-09','15:17:19','BRI','SALDO AWAL','SALDO AWAL','0','0','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-261009-0001','D','2026-10-09','15:17:19','BCA','SALDO AWAL','SALDO AWAL','0','743627000','743627000');
UPDATE tp_system SET tgl_system='2026-10-09';