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-20261020-0001','1','B1F-ZIBE-240-0','1','0.350','0.350','TOKO','PMBK-B','TOKO','PM-B'); DELETE FROM tm_barang WHERE kode_barang='B1F-ZIBE-240-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='B1F-ZIBE-240-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-B',tgl_last_beli='2026-10-20 07:58:53' WHERE kode_barang='B1F-ZIBE-240-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='B1F-ZIBE-240-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-20 07:58:53','TOKO','PM-B','B1F','B1F-ZIBE-240-0','1','0.350','0.350','1','0.350','0.350','100.00'); DELETE FROM tm_dept WHERE kode_dept='B1F' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='B1F' 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='B1F-ZIBE-240-0'; DELETE FROM tm_barang_export WHERE kode_barang='B1F-ZIBE-240-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-20261020-0001','1','B1G-ZJXH-60-0','1','0.300','0.300','TOKO','PMBK-B','TOKO','PM-B'); DELETE FROM tm_barang WHERE kode_barang='B1G-ZJXH-60-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='B1G-ZJXH-60-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-B',tgl_last_beli='2026-10-20 07:58:53' WHERE kode_barang='B1G-ZJXH-60-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='B1G-ZJXH-60-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-20 07:58:53','TOKO','PM-B','B1G','B1G-ZJXH-60-0','1','0.300','0.300','1','0.300','0.300','100.00'); DELETE FROM tm_dept WHERE kode_dept='B1G' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='B1G' LIMIT 1; DELETE FROM tm_group WHERE kode_group='MG' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MG' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='B1G-ZJXH-60-0'; DELETE FROM tm_barang_export WHERE kode_barang='B1G-ZJXH-60-0'; INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20261020-0001','2026-10-20','07:58','0.650','admpindah','2026-10-20 07:58:52'); 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-20261020-0001','1','E2E-ZIBE-209-0','1','0.470','0.470','TOKO','PMBK-E','TOKO','PM-E'); DELETE FROM tm_barang WHERE kode_barang='E2E-ZIBE-209-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2E-ZIBE-209-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-10-20 07:59:09' WHERE kode_barang='E2E-ZIBE-209-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='E2E-ZIBE-209-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-20 07:59:09','TOKO','PM-E','E2E','E2E-ZIBE-209-0','1','0.470','0.470','1','0.470','0.470','100.00'); DELETE FROM tm_dept WHERE kode_dept='E2E' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E2E' 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='E2E-ZIBE-209-0'; DELETE FROM tm_barang_export WHERE kode_barang='E2E-ZIBE-209-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-20261020-0001','1','E2E-ZJAE-176-0','1','0.500','0.500','TOKO','PMBK-E','TOKO','PM-E'); DELETE FROM tm_barang WHERE kode_barang='E2E-ZJAE-176-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2E-ZJAE-176-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-10-20 07:59:09' WHERE kode_barang='E2E-ZJAE-176-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='E2E-ZJAE-176-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-20 07:59:09','TOKO','PM-E','E2E','E2E-ZJAE-176-0','1','0.500','0.500','1','0.500','0.500','100.00'); DELETE FROM tm_dept WHERE kode_dept='E2E' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E2E' 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='E2E-ZJAE-176-0'; DELETE FROM tm_barang_export WHERE kode_barang='E2E-ZJAE-176-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-20261020-0001','1','E2E-ZJAE-177-0','1','0.460','0.460','TOKO','PMBK-E','TOKO','PM-E'); DELETE FROM tm_barang WHERE kode_barang='E2E-ZJAE-177-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2E-ZJAE-177-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-10-20 07:59:09' WHERE kode_barang='E2E-ZJAE-177-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='E2E-ZJAE-177-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-20 07:59:09','TOKO','PM-E','E2E','E2E-ZJAE-177-0','1','0.460','0.460','1','0.460','0.460','100.00'); DELETE FROM tm_dept WHERE kode_dept='E2E' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E2E' 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='E2E-ZJAE-177-0'; DELETE FROM tm_barang_export WHERE kode_barang='E2E-ZJAE-177-0'; INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20261020-0001','2026-10-20','07:59','1.430','admpindah','2026-10-20 07:59: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-20261020-0001','1','F1E-YCCX-489-0','1','2.060','2.060','TOKO','PMBK-F','TOKO','PM-F'); DELETE FROM tm_barang WHERE kode_barang='F1E-YCCX-489-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F1E-YCCX-489-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-F',tgl_last_beli='2026-10-20 07:59:28' WHERE kode_barang='F1E-YCCX-489-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='F1E-YCCX-489-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-20 07:59:28','TOKO','PM-F','F1E','F1E-YCCX-489-0','1','2.060','2.060','1','2.060','2.060','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-YCCX-489-0'; DELETE FROM tm_barang_export WHERE kode_barang='F1E-YCCX-489-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-20261020-0001','1','F1E-ZIBE-86-0','1','1.450','1.450','TOKO','PMBK-F','TOKO','PM-F'); DELETE FROM tm_barang WHERE kode_barang='F1E-ZIBE-86-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F1E-ZIBE-86-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-F',tgl_last_beli='2026-10-20 07:59:28' WHERE kode_barang='F1E-ZIBE-86-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='F1E-ZIBE-86-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-20 07:59:28','TOKO','PM-F','F1E','F1E-ZIBE-86-0','1','1.450','1.450','1','1.450','1.450','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-ZIBE-86-0'; DELETE FROM tm_barang_export WHERE kode_barang='F1E-ZIBE-86-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-20261020-0001','1','F1E-ZJAE-84-0','1','3.070','3.070','TOKO','PMBK-F','TOKO','PM-F'); DELETE FROM tm_barang WHERE kode_barang='F1E-ZJAE-84-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F1E-ZJAE-84-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-F',tgl_last_beli='2026-10-20 07:59:28' WHERE kode_barang='F1E-ZJAE-84-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='F1E-ZJAE-84-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-20 07:59:28','TOKO','PM-F','F1E','F1E-ZJAE-84-0','1','3.070','3.070','1','3.070','3.070','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-ZJAE-84-0'; DELETE FROM tm_barang_export WHERE kode_barang='F1E-ZJAE-84-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-20261020-0001','1','F3E-ZJAF-41-0','1','1.380','1.380','TOKO','PMBK-F','TOKO','PM-F'); DELETE FROM tm_barang WHERE kode_barang='F3E-ZJAF-41-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F3E-ZJAF-41-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-F',tgl_last_beli='2026-10-20 07:59:28' WHERE kode_barang='F3E-ZJAF-41-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='F3E-ZJAF-41-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-20 07:59:28','TOKO','PM-F','F3E','F3E-ZJAF-41-0','1','1.380','1.380','1','1.380','1.380','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-ZJAF-41-0'; DELETE FROM tm_barang_export WHERE kode_barang='F3E-ZJAF-41-0'; INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20261020-0001','2026-10-20','07:59','7.960','admpindah','2026-10-20 07:59:27'); 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-20261020-0001','1','H2J-ZJXF-187-0','1','5.010','5.010','TOKO','PMBK-H','TOKO','PM-H'); DELETE FROM tm_barang WHERE kode_barang='H2J-ZJXF-187-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='H2J-ZJXF-187-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-H',tgl_last_beli='2026-10-20 07:59:44' WHERE kode_barang='H2J-ZJXF-187-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='H2J-ZJXF-187-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-20 07:59:44','TOKO','PM-H','H2J','H2J-ZJXF-187-0','1','5.010','5.010','1','5.010','5.010','100.00'); DELETE FROM tm_dept WHERE kode_dept='H2J' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='H2J' LIMIT 1; DELETE FROM tm_group WHERE kode_group='MJ' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MJ' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='H2J-ZJXF-187-0'; DELETE FROM tm_barang_export WHERE kode_barang='H2J-ZJXF-187-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-20261020-0001','1','H1E-ZJXG-225-0','1','2.980','2.980','TOKO','PMBK-H','TOKO','PM-H'); DELETE FROM tm_barang WHERE kode_barang='H1E-ZJXG-225-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='H1E-ZJXG-225-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-H',tgl_last_beli='2026-10-20 07:59:44' WHERE kode_barang='H1E-ZJXG-225-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='H1E-ZJXG-225-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-20 07:59:44','TOKO','PM-H','H1E','H1E-ZJXG-225-0','1','2.980','2.980','1','2.980','2.980','100.00'); DELETE FROM tm_dept WHERE kode_dept='H1E' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='H1E' 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='H1E-ZJXG-225-0'; DELETE FROM tm_barang_export WHERE kode_barang='H1E-ZJXG-225-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-20261020-0001','1','H1E-ZJAE-121-0','1','2.000','2.000','TOKO','PMBK-H','TOKO','PM-H'); DELETE FROM tm_barang WHERE kode_barang='H1E-ZJAE-121-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='H1E-ZJAE-121-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-H',tgl_last_beli='2026-10-20 07:59:44' WHERE kode_barang='H1E-ZJAE-121-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='H1E-ZJAE-121-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-20 07:59:44','TOKO','PM-H','H1E','H1E-ZJAE-121-0','1','2.000','2.000','1','2.000','2.000','100.00'); DELETE FROM tm_dept WHERE kode_dept='H1E' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='H1E' 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='H1E-ZJAE-121-0'; DELETE FROM tm_barang_export WHERE kode_barang='H1E-ZJAE-121-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-20261020-0001','1','H1E-ZJAE-265-0','1','2.030','2.030','TOKO','PMBK-H','TOKO','PM-H'); DELETE FROM tm_barang WHERE kode_barang='H1E-ZJAE-265-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='H1E-ZJAE-265-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-H',tgl_last_beli='2026-10-20 07:59:44' WHERE kode_barang='H1E-ZJAE-265-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='H1E-ZJAE-265-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-20 07:59:44','TOKO','PM-H','H1E','H1E-ZJAE-265-0','1','2.030','2.030','1','2.030','2.030','100.00'); DELETE FROM tm_dept WHERE kode_dept='H1E' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='H1E' 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='H1E-ZJAE-265-0'; DELETE FROM tm_barang_export WHERE kode_barang='H1E-ZJAE-265-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-20261020-0001','1','H1E-ZJAE-273-0','1','2.000','2.000','TOKO','PMBK-H','TOKO','PM-H'); DELETE FROM tm_barang WHERE kode_barang='H1E-ZJAE-273-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='H1E-ZJAE-273-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-H',tgl_last_beli='2026-10-20 07:59:44' WHERE kode_barang='H1E-ZJAE-273-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='H1E-ZJAE-273-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-20 07:59:44','TOKO','PM-H','H1E','H1E-ZJAE-273-0','1','2.000','2.000','1','2.000','2.000','100.00'); DELETE FROM tm_dept WHERE kode_dept='H1E' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='H1E' 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='H1E-ZJAE-273-0'; DELETE FROM tm_barang_export WHERE kode_barang='H1E-ZJAE-273-0'; INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20261020-0001','2026-10-20','07:59','14.020','admpindah','2026-10-20 07:59:44'); 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 ('F326200928261','input','1',' MEF3E UB ','TOKO','PM-F','F3E-ZIBH-415-0','GL RANTAI HOLLOW PLAT POLOS UB 8K ','','4.240','1','100.00','4422000','0','0','15000','4422000','0','0','0','4422000','SIN','00426394','F3E','0','0','-','0','1053000'); UPDATE tm_barang SET tgl_last_jual='2026-10-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZIBH-415-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.240',berat_jual_asli=berat_jual_asli+'4.240',stock_jual='1',berat_akhir=berat_akhir-'4.240',berat_akhir_asli=berat_akhir_asli-'4.240',stock_akhir='0' WHERE tanggal='2026-10-20' AND kode_barang='F3E-ZIBH-415-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 ('F326200928261','2026-10-20','4.240','2026-10-20','09:28:26','PLG0031974','4422000','4422000','0','4422000','4422000','input','2026-10-20 09:28:26','F32620092826'); 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-20','F326200928261','2026-10-20','09:28:26','SIN','4422000','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-261020-0002','D','2026-10-20','09:28:26','input','PENJUALAN','F326200928261','7916090000','4422000','7920512000','OPEN'); UPDATE tt_jual_head SET dibayar_rp='4422000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326200928261' 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 ('F326200928262','input',' 1',' MEF3 HW ','TOKO','PM-F','F3E-YKBI-164-0','GL KAKI HARLEY HW 8K ','','2.100','1','100.00','2190000','0','0','15000','2190000','0','0','0','2190000','SIN','00379130','F3E','0','0','-','0','1053000'); UPDATE tm_barang SET tgl_last_jual='2026-10-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-YKBI-164-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.100',berat_jual_asli=berat_jual_asli+'2.100',stock_jual='1',berat_akhir=berat_akhir-'2.100',berat_akhir_asli=berat_akhir_asli-'2.100',stock_akhir='0' WHERE tanggal='2026-10-20' AND kode_barang='F3E-YKBI-164-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 ('F326200928262','2026-10-20','2.100','2026-10-20','09:28:26','PLG0031975','2190000','2190000','0','2190000','2190000','input','2026-10-20 09:28:26','F32620092826'); 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-20','F326200928262','2026-10-20','09:28:26','SIN','2190000','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-261020-0003','D','2026-10-20','09:28:26','input','PENJUALAN','F326200928262','7920512000','2190000','7922702000','OPEN'); UPDATE tt_jual_head SET dibayar_rp='2190000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326200928262' 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 ('F326200935341','input','1',' MFE1F KH 1','TOKO','PM-E','E1F-ZIBA-285-0','CC MODEL SPECTRA SLEP KH 18 8K ','','0.380','1','100.00','404000','0','0','15000','405000','0','0','0','405000','FIT','00424829','E1F','0','0','-','0','1073000'); UPDATE tm_barang SET tgl_last_jual='2026-10-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1F-ZIBA-285-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.380',berat_jual_asli=berat_jual_asli+'0.380',stock_jual='1',berat_akhir=berat_akhir-'0.380',berat_akhir_asli=berat_akhir_asli-'0.380',stock_akhir='0' WHERE tanggal='2026-10-20' AND kode_barang='E1F-ZIBA-285-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 ('F326200935341','2026-10-20','0.380','2026-10-20','09:35:35','PLG0031976','405000','405000','0','405000','405000','input','2026-10-20 09:35:34','F32620093534'); 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-20','F326200935341','2026-10-20','09:35:35','FIT','405000','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-261020-0004','D','2026-10-20','09:35:35','input','PENJUALAN','F326200935341','7922702000','405000','7923107000'); 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 ('F326200945031','kasir','1',' MDD1D LG ','TOKO','PM-D','D1D-ZBXC-13-0','LT MODEL HATI SLEP LG 8K ','','0.820','1','100.00','839000','0','0','15000','840000','0','0','0','840000','FIT','00387692','D1D','0','0','-','0','1033000'); UPDATE tm_barang SET tgl_last_jual='2026-10-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1D-ZBXC-13-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.820',berat_jual_asli=berat_jual_asli+'0.820',stock_jual='1',berat_akhir=berat_akhir-'0.820',berat_akhir_asli=berat_akhir_asli-'0.820',stock_akhir='0' WHERE tanggal='2026-10-20' AND kode_barang='D1D-ZBXC-13-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-D' 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 ('F326200945031','2026-10-20','0.820','2026-10-20','09:45:04','PLG0031977','840000','840000','0','840000','840000','kasir','2026-10-20 09:45:03','F32620094503'); 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-20','F326200945031','2026-10-20','09:45:04','FIT','840000','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-261020-0005','D','2026-10-20','09:45:04','kasir','PENJUALAN','F326200945031','7923107000','840000','7923947000'); 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-00020590','X-00020590','CC WEDDING MATA CM 16 8K','GR','---','E2D','BELI','BELI001','875000','2026-10-20','0.920','1','kasir','2026-10-20 10:09:26'); DELETE FROM tp_barang WHERE kode_dept = 'X-E2D'; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2D','X-00020590','X-00020590'); 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-261020-0001','F326191149041','FIT','1','BELI','BELI001','E2D', 'X-00020590', 'CC WEDDING MATA CM 16 8K','0.920','0.920','100.00','980000','875000','951087','1033000','1','875000','875000','CUCI'); UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.920',berat_beli_asli=berat_beli_asli+'0.920',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.920',berat_akhir_asli=berat_akhir_asli+'0.920',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-10-20' 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-261020-0001','2026-10-20','2026-10-20','10:09:25','FIT','---','0.920','875000','875000','875000','875000','875000','kasir','2026-10-20 10:09:26','FB-261020-0001'); INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261020-0001','VINDI','TINASAT KISMANTORO','','','085867832938','kasir','2026-10-20 10:09:26'); SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-10-20' 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-261020-0006','K','2026-10-20','10:09:25','kasir','PEMBELIAN UMUM','FB-261020-0001','7923947000','875000','7923072000'); 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-00020591','X-00020591','CC X MODEL METRO MATA LG 16 8K','GR','---','E2D','BELI','BELI001','1027000','2026-10-20','1.070','1','kasir','2026-10-20 10:10:19'); DELETE FROM tp_barang WHERE kode_dept = 'X-E2D'; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2D','X-00020591','X-00020591'); 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-261020-0002','F326100959142','SIN','1','BELI','BELI001','E2D', 'X-00020591', 'CC X MODEL METRO MATA LG 16 8K','1.070','1.070','100.00','1155000','1027000','959813','1033000','1','1027000','1027000','CUCI'); UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.070',berat_beli_asli=berat_beli_asli+'1.070',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.070',berat_akhir_asli=berat_akhir_asli+'1.070',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-10-20' 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-261020-0002','2026-10-20','2026-10-20','10:10:19','SIN','---','1.070','1027000','1027000','1027000','1027000','1027000','kasir','2026-10-20 10:10:19','FB-261020-0002'); INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261020-0002','ZAHRA','KISMANTORO','','','','kasir','2026-10-20 10:10:19'); SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-10-20' 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-261020-0007','K','2026-10-20','10:10:19','kasir','PEMBELIAN UMUM','FB-261020-0002','7923072000','1027000','7922045000'); 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-00020592','X-00020592','CC MODEL ISYANA SLEP LG 14 8K','GR','---','E1E','BELI','BELI001','437000','2026-10-20','0.460','1','kasir','2026-10-20 10:10:19'); DELETE FROM tp_barang WHERE kode_dept = 'X-E1E'; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E1E','X-00020592','X-00020592'); 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-261020-0003','F326271002092','SIN','2','BELI','BELI001','E1E', 'X-00020592', 'CC MODEL ISYANA SLEP LG 14 8K','0.460','0.460','100.00','475000','437000','950000','1053000','1','437000','437000','CUCI'); UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.460',berat_beli_asli=berat_beli_asli+'0.460',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.460',berat_akhir_asli=berat_akhir_asli+'0.460',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-10-20' 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-261020-0003','2026-10-20','2026-10-20','10:10:19','SIN','---','0.460','437000','437000','437000','437000','437000','kasir','2026-10-20 10:10:19','FB-261020-0002'); INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261020-0003','MBAK YANTI','GADUNGAN KISMANTORO','','','','kasir','2026-10-20 10:10:19'); SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-10-20' 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-261020-0008','K','2026-10-20','10:10:19','kasir','PEMBELIAN UMUM','FB-261020-0003','7922045000','437000','7921608000'); 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-00020593','X-00020593','KL X SIEM SINGEL KH 40 9K','GR','---','H2I','BELI','BELI001','1465000','2026-10-20','1.420','1','kasir','2026-10-20 10:10:45'); DELETE FROM tp_barang WHERE kode_dept = 'X-H2I'; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-H2I','X-00020593','X-00020593'); 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-261020-0004','F326020248232','FIT','1','BELI','BELI001','H2I', 'X-00020593', 'KL X SIEM SINGEL KH 40 9K','1.420','1.420','100.00','1575000','1465000','1031690','1133000','1','1465000','1465000','CUCI'); UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.420',berat_beli_asli=berat_beli_asli+'1.420',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.420',berat_akhir_asli=berat_akhir_asli+'1.420',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-10-20' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='H2I' 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-261020-0004','2026-10-20','2026-10-20','10:10:44','FIT','---','1.420','1465000','1465000','1465000','1465000','1465000','kasir','2026-10-20 10:10:45','FB-261020-0004'); INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261020-0004','LENI','BANDAR','','','','kasir','2026-10-20 10:10:45'); SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-10-20' 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-261020-0009','K','2026-10-20','10:10:44','kasir','PEMBELIAN UMUM','FB-261020-0004','7921608000','1465000','7920143000'); 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-00020594','X-00020594','LT COR MODEL SPECTRA HW 8K','GR','---','D1E','BELI','BELI001','570000','2026-10-20','0.590','1','kasir','2026-10-20 10:11:06'); DELETE FROM tp_barang WHERE kode_dept = 'X-D1E'; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-D1E','X-00020594','X-00020594'); 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-261020-0005','F326121216471','FIT','1','BELI','BELI001','D1E', 'X-00020594', 'LT COR MODEL SPECTRA HW 8K','0.590','0.590','100.00','646000','570000','966102','1053000','1','570000','570000','CUCI'); UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.590',berat_beli_asli=berat_beli_asli+'0.590',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.590',berat_akhir_asli=berat_akhir_asli+'0.590',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-10-20' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='D1E' 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-261020-0005','2026-10-20','2026-10-20','10:11:05','FIT','---','0.590','570000','570000','570000','570000','570000','kasir','2026-10-20 10:11:06','FB-261020-0005'); INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261020-0005','DESY','POHIJO SAMPUNG','','','','kasir','2026-10-20 10:11:06'); SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-10-20' 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-261020-0010','K','2026-10-20','10:11:05','kasir','PEMBELIAN UMUM','FB-261020-0005','7920143000','570000','7919573000'); 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 ('F326201027441','kasir','1',' MDE1 HW 18','TOKO','PM-E','E1D-ZGXA-296-0','CC METRO HATI SLEP HW 18 8K ','','1.280','1','100.00','1309000','0','0','15000','1310000','0','0','0','1310000','FIT','00411820','E1D','0','0','-','0','1033000'); UPDATE tm_barang SET tgl_last_jual='2026-10-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-ZGXA-296-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.280',berat_jual_asli=berat_jual_asli+'1.280',stock_jual='1',berat_akhir=berat_akhir-'1.280',berat_akhir_asli=berat_akhir_asli-'1.280',stock_akhir='0' WHERE tanggal='2026-10-20' AND kode_barang='E1D-ZGXA-296-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 ('F326201027441','2026-10-20','1.280','2026-10-20','10:27:44','PLG0031978','1310000','1310000','0','1310000','1310000','kasir','2026-10-20 10:27:44','F32620102744'); 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-20','F326201027441','2026-10-20','10:27:44','FIT','1310000','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-261020-0011','D','2026-10-20','10:27:44','kasir','PENJUALAN','F326201027441','7919573000','1310000','7920883000'); 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-00020595','X-00020595','KL KOREA KH 44 8K','GR','---','H1E','BELI','BELI001','1840000','2026-10-20','2.100','1','kasir','2026-10-20 11:18:11'); DELETE FROM tp_barang WHERE kode_dept = 'X-H1E'; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-H1E','X-00020595','X-00020595'); 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-261020-0006','F326270124061','LIS','1','BELI','BELI001','H1E', 'X-00020595', 'KL KOREA KH 44 8K','2.100','2.100','100.00','2195000','1840000','876190','1053000','1','1840000','1840000','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-20' 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-261020-0006','2026-10-20','2026-10-20','11:18:11','LIS','---','2.100','1840000','1840000','1840000','1840000','1840000','kasir','2026-10-20 11:18:11','FB-261020-0006'); INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261020-0006','NANTA','PAKIS BARU','','','083897627521','kasir','2026-10-20 11:18:11'); SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-10-20' 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-261020-0012','K','2026-10-20','11:18:11','kasir','PEMBELIAN UMUM','FB-261020-0006','7920883000','1840000','7919043000'); 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-00020596','X-00020596','LT X MODEL HURUF MATA LG N 8K','GR','---','D2D','BELI','BELI001','1000000','2026-10-20','1.050','1','kasir','2026-10-20 11:18:11'); DELETE FROM tp_barang WHERE kode_dept = 'X-D2D'; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-D2D','X-00020596','X-00020596'); 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-261020-0007','F326270124063','LIS','2','BELI','BELI001','D2D', 'X-00020596', 'LT X MODEL HURUF MATA LG N 8K','1.050','1.050','100.00','1075000','1000000','952381','1033000','1','1000000','1000000','CUCI'); UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.050',berat_beli_asli=berat_beli_asli+'1.050',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.050',berat_akhir_asli=berat_akhir_asli+'1.050',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-10-20' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='D2D' 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-261020-0007','2026-10-20','2026-10-20','11:18:11','LIS','---','1.050','1000000','1000000','1000000','1000000','1000000','kasir','2026-10-20 11:18:11','FB-261020-0006'); INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261020-0007','NANTA','PAKIS BARU','','','083897627521','kasir','2026-10-20 11:18:11'); SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-10-20' 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-261020-0013','K','2026-10-20','11:18:11','kasir','PEMBELIAN UMUM','FB-261020-0007','7919043000','1000000','7918043000'); 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 ('F326201130151','kasir','1',' TEF1 XX UB','TOKO','PT-F','F1TE-WHAB-128-T','GL XX OVAL MODEL C UB D60 ','','6.860','1','100.00','13240000','0','0','15000','13035000','0','0','0','13035000','LIS','T0047429','F1TE','0','0','-','1','1940000'); UPDATE tm_barang SET tgl_last_jual='2026-10-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1TE-WHAB-128-T' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'6.860',berat_jual_asli=berat_jual_asli+'6.860',stock_jual='1',berat_akhir=berat_akhir-'6.860',berat_akhir_asli=berat_akhir_asli-'6.860',stock_akhir='0' WHERE tanggal='2026-10-20' AND kode_barang='F1TE-WHAB-128-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PT-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 ('F326201130151','2026-10-20','6.860','2026-10-20','11:30:16','PLG0031979','13035000','13035000','0','13035000','13035000','kasir','2026-10-20 11:30:15','F32620113015'); 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-20','F326201130151','2026-10-20','11:30:16','LIS','13035000','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-261020-0014','D','2026-10-20','11:30:16','kasir','PENJUALAN','F326201130151','7918043000','13035000','7931078000','OPEN'); UPDATE tt_jual_head SET dibayar_rp='13035000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326201130151' 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 ('F326201130152','kasir',' 1',' TEE2 X MT ','TOKO','PT-E','E2TE-WKXI-71-T','CC X WEDDING MATA MT 12 ','','2.070','1','100.00','3995000','0','0','15000','3995000','0','0','0','3995000','LIS','T0050479','E2TE','0','0','-','0','1940000'); UPDATE tm_barang SET tgl_last_jual='2026-10-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2TE-WKXI-71-T' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.070',berat_jual_asli=berat_jual_asli+'2.070',stock_jual='1',berat_akhir=berat_akhir-'2.070',berat_akhir_asli=berat_akhir_asli-'2.070',stock_akhir='0' WHERE tanggal='2026-10-20' AND kode_barang='E2TE-WKXI-71-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 ('F326201130152','2026-10-20','2.070','2026-10-20','11:30:16','PLG0031980','3995000','3995000','0','3995000','3995000','kasir','2026-10-20 11:30:15','F32620113015'); 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-20','F326201130152','2026-10-20','11:30:16','LIS','3995000','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-261020-0015','D','2026-10-20','11:30:16','kasir','PENJUALAN','F326201130152','7931078000','3995000','7935073000','OPEN'); UPDATE tt_jual_head SET dibayar_rp='3995000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326201130152' LIMIT 1; 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-00020597','X-00020597','GL ANAK MODEL FANCY VAR LT 8K','GR','---','F3E','BELI','BELI001','1297000','2026-10-20','1.450','1','kasir','2026-10-20 12:16:21'); DELETE FROM tp_barang WHERE kode_dept = 'X-F3E'; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F3E','X-00020597','X-00020597'); 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-261020-0008','F326251125111','FIT','1','BELI','BELI001','F3E', 'X-00020597', 'GL ANAK MODEL FANCY VAR LT 8K','1.500','1.450','100.00','1725000','1297000','894483','1053000','1','1297000','1297000','RUSAK'); UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.450',berat_beli_asli=berat_beli_asli+'1.450',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.450',berat_akhir_asli=berat_akhir_asli+'1.450',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-10-20' 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-261020-0008','2026-10-20','2026-10-20','12:16:20','FIT','---','1.450','1297000','1297000','1297000','1297000','1297000','kasir','2026-10-20 12:16:21','FB-261020-0008'); INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261020-0008','NUNA','GONDANG BULUKERTO','','','','kasir','2026-10-20 12:16:21'); SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-10-20' 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-261020-0016','K','2026-10-20','12:16:20','kasir','PEMBELIAN UMUM','FB-261020-0008','7935073000','1297000','7933776000'); 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-00020598','X-00020598','CC X MODEL MATA HITAM PM 18 8K','GR','---','E2D','BELI','BELI001','1887000','2026-10-20','1.980','1','kasir','2026-10-20 12:16:21'); DELETE FROM tp_barang WHERE kode_dept = 'X-E2D'; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2D','X-00020598','X-00020598'); 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-261020-0009','F326010239031','FIT','2','BELI','BELI001','E2D', 'X-00020598', 'CC X MODEL MATA HITAM PM 18 8K','1.980','1.980','100.00','2030000','1887000','953030','1033000','1','1887000','1887000','CUCI'); UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.980',berat_beli_asli=berat_beli_asli+'1.980',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.980',berat_akhir_asli=berat_akhir_asli+'1.980',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-10-20' 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-261020-0009','2026-10-20','2026-10-20','12:16:20','FIT','---','1.980','1887000','1887000','1887000','1887000','1887000','kasir','2026-10-20 12:16:21','FB-261020-0008'); INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261020-0009','MAK NIK','GONDANG BULUKERTO','','','','kasir','2026-10-20 12:16:21'); SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-10-20' 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-261020-0017','K','2026-10-20','12:16:20','kasir','PEMBELIAN UMUM','FB-261020-0009','7933776000','1887000','7931889000'); 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-00020599','X-00020599','CC X MERTO MATA ROSE LG 16 8K','GR','---','E2D','BELI','BELI001','727000','2026-10-20','0.920','1','kasir','2026-10-20 12:16:21'); DELETE FROM tp_barang WHERE kode_dept = 'X-E2D'; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2D','X-00020599','X-00020599'); 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-261020-0010','F326251125421','FIT','3','BELI','BELI001','E2D', 'X-00020599', 'CC X MERTO MATA ROSE LG 16 8K','0.920','0.920','100.00','1040000','727000','790217','1033000','1','727000','727000','RUSAK'); UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.920',berat_beli_asli=berat_beli_asli+'0.920',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.920',berat_akhir_asli=berat_akhir_asli+'0.920',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-10-20' 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-261020-0010','2026-10-20','2026-10-20','12:16:20','FIT','---','0.920','727000','727000','727000','727000','727000','kasir','2026-10-20 12:16:21','FB-261020-0008'); INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261020-0010','WARNI','GONDANG BLUKERTO','','','','kasir','2026-10-20 12:16:21'); SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-10-20' 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-261020-0018','K','2026-10-20','12:16:20','kasir','PEMBELIAN UMUM','FB-261020-0010','7931889000','727000','7931162000'); 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-00020600','X-00020600','CC MODEL SLEP VAR CM 20 8K','GR','---','E1D','BELI','BELI001','1255000','2026-10-20','1.320','1','kasir','2026-10-20 12:16:21'); DELETE FROM tp_barang WHERE kode_dept = 'X-E1D'; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E1D','X-00020600','X-00020600'); 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-261020-0011','F326170214051','FIT','4','BELI','BELI001','E1D', 'X-00020600', 'CC MODEL SLEP VAR CM 20 8K','1.320','1.320','100.00','1413000','1255000','950758','1033000','1','1255000','1255000','CUCI'); UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.320',berat_beli_asli=berat_beli_asli+'1.320',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.320',berat_akhir_asli=berat_akhir_asli+'1.320',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-10-20' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E1D' 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-261020-0011','2026-10-20','2026-10-20','12:16:20','FIT','---','1.320','1255000','1255000','1255000','1255000','1255000','kasir','2026-10-20 12:16:21','FB-261020-0008'); INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261020-0011','WARNI','GONDANG BULUKERTO','','','','kasir','2026-10-20 12:16:21'); SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-10-20' 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-261020-0019','K','2026-10-20','12:16:20','kasir','PEMBELIAN UMUM','FB-261020-0011','7931162000','1255000','7929907000'); 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-00020601','X-00020601','CC X MODEL MATA CM 12 8K','GR','---','E2D','BELI','BELI001','1200000','2026-10-20','1.250','1','kasir','2026-10-20 12:16:21'); DELETE FROM tp_barang WHERE kode_dept = 'X-E2D'; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2D','X-00020601','X-00020601'); 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-261020-0012','F326290206511','FIT','5','BELI','BELI001','E2D', 'X-00020601', 'CC X MODEL MATA CM 12 8K','1.250','1.250','100.00','1305000','1200000','960000','1033000','1','1200000','1200000','CUCI'); UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.250',berat_beli_asli=berat_beli_asli+'1.250',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.250',berat_akhir_asli=berat_akhir_asli+'1.250',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-10-20' 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-261020-0012','2026-10-20','2026-10-20','12:16:20','FIT','---','1.250','1200000','1200000','1200000','1200000','1200000','kasir','2026-10-20 12:16:21','FB-261020-0008'); INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261020-0012','SELIN','GONDANG BULUKERTO','','','','kasir','2026-10-20 12:16:21'); SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-10-20' 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-261020-0020','K','2026-10-20','12:16:20','kasir','PEMBELIAN UMUM','FB-261020-0012','7929907000','1200000','7928707000'); 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 ('F326201256471','kasir','1',' MEF1 TD 62','TOKO','PM-F','F1E-ZHAX-316-0','GL OVAL C SLEP TD 62 8K ','','5.370','1','100.00','5601000','0','0','15000','5600000','0','0','0','5600000','FIT','00418461','F1E','0','0','-','1','1053000'); UPDATE tm_barang SET tgl_last_jual='2026-10-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-ZHAX-316-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'5.370',berat_jual_asli=berat_jual_asli+'5.370',stock_jual='1',berat_akhir=berat_akhir-'5.370',berat_akhir_asli=berat_akhir_asli-'5.370',stock_akhir='0' WHERE tanggal='2026-10-20' AND kode_barang='F1E-ZHAX-316-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 ('F326201256471','2026-10-20','5.370','2026-10-20','12:56:47','PLG0031981','5600000','5600000','0','5600000','5600000','kasir','2026-10-20 12:56:47','F32620125647'); 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-20','F326201256471','2026-10-20','12:56:47','FIT','5600000','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-261020-0021','D','2026-10-20','12:56:47','kasir','PENJUALAN','F326201256471','7928707000','5600000','7934307000'); 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 ('F326200149341','kasir','1',' MDE2 10K C','TOKO','PM-E','E2D-ZGXD-33-0','CC WEDDING MATA CM 10 8K ','','1.550','1','100.00','1586000','0','0','15000','1586000','0','10000','0','1596000','SIN','00412287','E2D','0','0','-','0','1033000'); UPDATE tm_barang SET tgl_last_jual='2026-10-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZGXD-33-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.550',berat_jual_asli=berat_jual_asli+'1.550',stock_jual='1',berat_akhir=berat_akhir-'1.550',berat_akhir_asli=berat_akhir_asli-'1.550',stock_akhir='0' WHERE tanggal='2026-10-20' AND kode_barang='E2D-ZGXD-33-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 ('F326200149341','2026-10-20','1.550','2026-10-20','13:49:34','PLG0031982','1586000','1586000','10000','1596000','1596000','kasir','2026-10-20 13:49:34','F32620014934'); 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-20','F326200149341','2026-10-20','13:49:34','SIN','1596000','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-261020-0022','D','2026-10-20','13:49:34','kasir','PENJUALAN','F326200149341','7934307000','1596000','7935903000'); 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 ('F326200248541','input','1',' TDE1 X CM ','TOKO','PT-E','E1TD-YLAC-26-T','CC X VELG KACA CM 11 17K ','','1.670','1','100.00','3190000','0','0','15000','3190000','0','0','0','3190000','SIN','T0075761','E1TD','0','0','-','0','1910000'); UPDATE tm_barang SET tgl_last_jual='2026-10-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1TD-YLAC-26-T' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.670',berat_jual_asli=berat_jual_asli+'1.670',stock_jual='1',berat_akhir=berat_akhir-'1.670',berat_akhir_asli=berat_akhir_asli-'1.670',stock_akhir='0' WHERE tanggal='2026-10-20' AND kode_barang='E1TD-YLAC-26-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 ('F326200248541','2026-10-20','1.670','2026-10-20','14:48:55','PLG0031983','3190000','3190000','0','3190000','3190000','input','2026-10-20 14:48:54','F32620024854'); 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-20','F326200248541','2026-10-20','14:48:55','SIN','3190000','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-261020-0023','D','2026-10-20','14:48:55','input','PENJUALAN','F326200248541','7935903000','3190000','7939093000'); UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261020-0001' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261020-0001'; UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261020-0002' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261020-0002'; UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261020-0003' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261020-0003'; UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261020-0004' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261020-0004'; UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261020-0005' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261020-0005'; UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261020-0006' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261020-0006'; UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261020-0007' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261020-0007'; UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261020-0008' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261020-0008'; UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261020-0009' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261020-0009'; UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261020-0010' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261020-0010'; UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261020-0011' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261020-0011'; UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261020-0012' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261020-0012'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326200149341' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326200149341' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326200149341'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326200248541' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326200248541' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326200248541'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326200928261' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326200928261' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326200928261'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326200928262' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326200928262' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326200928262'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326200935341' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326200935341' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326200935341'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326200945031' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326200945031' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326200945031'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326201027441' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326201027441' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326201027441'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326201130151' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326201130151' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326201130151'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326201130152' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326201130152' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326201130152'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326201256471' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326201256471' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326201256471'; INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-10-21','0','0','0','0','0','0'); DELETE FROM th_barang_saldo WHERE tanggal <= '2026-09-20'; INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-10-20'; UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-10-20'; INSERT INTO tt_barang_saldo (kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_awal,berat_awal_asli,stock_awal,berat_akhir,berat_akhir_asli,stock_akhir) SELECT kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_akhir,berat_akhir_asli,stock_akhir,berat_akhir,berat_akhir_asli,stock_akhir FROM tt_barang_saldo WHERE tanggal='2026-10-20' AND berat_akhir*1 > '0' INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-10-20'; DELETE FROM tt_cash_daily WHERE tanggal <= '2026-10-20'; INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-10-20'; DELETE FROM tt_bank_daily WHERE tanggal <= '2026-10-20'; 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-21' WHERE status_close ='OPEN'; DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-10-20' 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-261021-0001','D','2026-10-21','15:09:09','SYSTEM','SALDO AWAL','SALDO AWAL','0','7939093000','7939093000'); 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-261021-0001','D','2026-10-21','15:09:09','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-261021-0001','D','2026-10-21','15:09:09','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-261021-0001','D','2026-10-21','15:09:09','BCA','SALDO AWAL','SALDO AWAL','0','743627000','743627000'); UPDATE tp_system SET tgl_system='2026-10-21';