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 ('F326210801191','input','1',' MJH2 X UB ','TOKO','PM-H','H2J-ZHAI-17-0','KL X MILANO SEMI UB 54 9K ','','4.000','1','100.00','4572000','0','0','15000','4572000','0','0','0','4572000','FIT','00419417','H2J','0','0','-','0','1153000'); UPDATE tm_barang SET tgl_last_jual='2026-10-21', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H2J-ZHAI-17-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.000',berat_jual_asli=berat_jual_asli+'4.000',stock_jual='1',berat_akhir=berat_akhir-'4.000',berat_akhir_asli=berat_akhir_asli-'4.000',stock_akhir='0' WHERE tanggal='2026-10-21' AND kode_barang='H2J-ZHAI-17-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 ('F326210801191','2026-10-21','4.000','2026-10-21','08:01:19','PLG0031984','4572000','4572000','0','4572000','4572000','input','2026-10-21 08:01:19','F32621080119'); 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-21','F326210801191','2026-10-21','08:01:19','FIT','4572000','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-261021-0002','D','2026-10-21','08:01:19','input','PENJUALAN','F326210801191','7939093000','4572000','7943665000'); 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 ('F326210805481','input','1',' MED2E X LG','TOKO','PM-D','D2E-ZABH-50-0','LT X MODEL HURUF MATA LG I 8K ','','0.500','1','100.00','521000','0','0','15000','520000','0','0','0','520000','FIT','00386908','D2E','0','0','-','1','1053000'); UPDATE tm_barang SET tgl_last_jual='2026-10-21', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D2E-ZABH-50-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.500',berat_jual_asli=berat_jual_asli+'0.500',stock_jual='1',berat_akhir=berat_akhir-'0.500',berat_akhir_asli=berat_akhir_asli-'0.500',stock_akhir='0' WHERE tanggal='2026-10-21' AND kode_barang='D2E-ZABH-50-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 ('F326210805481','2026-10-21','0.500','2026-10-21','08:05:48','PLG0031985','520000','520000','0','520000','520000','input','2026-10-21 08:05:48','F32621080548'); 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-21','F326210805481','2026-10-21','08:05:48','FIT','520000','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-261021-0003','D','2026-10-21','08:05:48','input','PENJUALAN','F326210805481','7943665000','520000','7944185000'); 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-20261021-0001','1','E2D-ZJBX-31-0','1','1.520','1.520','TOKO','PMBK-E','TOKO','PM-E'); DELETE FROM tm_barang WHERE kode_barang='E2D-ZJBX-31-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2D-ZJBX-31-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-10-21 08:10:46' WHERE kode_barang='E2D-ZJBX-31-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='E2D-ZJBX-31-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-21 08:10:46','TOKO','PM-E','E2D','E2D-ZJBX-31-0','1','1.520','1.520','1','1.520','1.520','100.00'); DELETE FROM tm_dept WHERE kode_dept='E2D' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E2D' LIMIT 1; DELETE FROM tm_group WHERE kode_group='MD' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MD' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E2D-ZJBX-31-0'; DELETE FROM tm_barang_export WHERE kode_barang='E2D-ZJBX-31-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-20261021-0001','1','E2D-ZJBX-32-0','1','1.530','1.530','TOKO','PMBK-E','TOKO','PM-E'); DELETE FROM tm_barang WHERE kode_barang='E2D-ZJBX-32-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2D-ZJBX-32-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-10-21 08:10:46' WHERE kode_barang='E2D-ZJBX-32-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='E2D-ZJBX-32-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-21 08:10:46','TOKO','PM-E','E2D','E2D-ZJBX-32-0','1','1.530','1.530','1','1.530','1.530','100.00'); DELETE FROM tm_dept WHERE kode_dept='E2D' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E2D' LIMIT 1; DELETE FROM tm_group WHERE kode_group='MD' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MD' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E2D-ZJBX-32-0'; DELETE FROM tm_barang_export WHERE kode_barang='E2D-ZJBX-32-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-20261021-0001','1','E2D-ZJBX-33-0','1','1.530','1.530','TOKO','PMBK-E','TOKO','PM-E'); DELETE FROM tm_barang WHERE kode_barang='E2D-ZJBX-33-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2D-ZJBX-33-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-10-21 08:10:46' WHERE kode_barang='E2D-ZJBX-33-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='E2D-ZJBX-33-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-21 08:10:46','TOKO','PM-E','E2D','E2D-ZJBX-33-0','1','1.530','1.530','1','1.530','1.530','100.00'); DELETE FROM tm_dept WHERE kode_dept='E2D' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E2D' LIMIT 1; DELETE FROM tm_group WHERE kode_group='MD' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MD' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E2D-ZJBX-33-0'; DELETE FROM tm_barang_export WHERE kode_barang='E2D-ZJBX-33-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-20261021-0001','1','E2D-ZJBX-34-0','1','1.530','1.530','TOKO','PMBK-E','TOKO','PM-E'); DELETE FROM tm_barang WHERE kode_barang='E2D-ZJBX-34-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2D-ZJBX-34-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-10-21 08:10:46' WHERE kode_barang='E2D-ZJBX-34-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='E2D-ZJBX-34-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-21 08:10:46','TOKO','PM-E','E2D','E2D-ZJBX-34-0','1','1.530','1.530','1','1.530','1.530','100.00'); DELETE FROM tm_dept WHERE kode_dept='E2D' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E2D' LIMIT 1; DELETE FROM tm_group WHERE kode_group='MD' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MD' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E2D-ZJBX-34-0'; DELETE FROM tm_barang_export WHERE kode_barang='E2D-ZJBX-34-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-20261021-0001','1','E2D-ZJBX-35-0','1','1.530','1.530','TOKO','PMBK-E','TOKO','PM-E'); DELETE FROM tm_barang WHERE kode_barang='E2D-ZJBX-35-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2D-ZJBX-35-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-10-21 08:10:46' WHERE kode_barang='E2D-ZJBX-35-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='E2D-ZJBX-35-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-21 08:10:46','TOKO','PM-E','E2D','E2D-ZJBX-35-0','1','1.530','1.530','1','1.530','1.530','100.00'); DELETE FROM tm_dept WHERE kode_dept='E2D' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E2D' LIMIT 1; DELETE FROM tm_group WHERE kode_group='MD' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MD' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E2D-ZJBX-35-0'; DELETE FROM tm_barang_export WHERE kode_barang='E2D-ZJBX-35-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-20261021-0001','1','E2D-ZJBX-36-0','1','1.500','1.500','TOKO','PMBK-E','TOKO','PM-E'); DELETE FROM tm_barang WHERE kode_barang='E2D-ZJBX-36-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2D-ZJBX-36-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-10-21 08:10:46' WHERE kode_barang='E2D-ZJBX-36-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='E2D-ZJBX-36-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-21 08:10:46','TOKO','PM-E','E2D','E2D-ZJBX-36-0','1','1.500','1.500','1','1.500','1.500','100.00'); DELETE FROM tm_dept WHERE kode_dept='E2D' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E2D' LIMIT 1; DELETE FROM tm_group WHERE kode_group='MD' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MD' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E2D-ZJBX-36-0'; DELETE FROM tm_barang_export WHERE kode_barang='E2D-ZJBX-36-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-20261021-0001','1','E2D-ZJBX-37-0','1','1.540','1.540','TOKO','PMBK-E','TOKO','PM-E'); DELETE FROM tm_barang WHERE kode_barang='E2D-ZJBX-37-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2D-ZJBX-37-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-10-21 08:10:46' WHERE kode_barang='E2D-ZJBX-37-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='E2D-ZJBX-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-21 08:10:46','TOKO','PM-E','E2D','E2D-ZJBX-37-0','1','1.540','1.540','1','1.540','1.540','100.00'); DELETE FROM tm_dept WHERE kode_dept='E2D' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E2D' LIMIT 1; DELETE FROM tm_group WHERE kode_group='MD' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MD' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E2D-ZJBX-37-0'; DELETE FROM tm_barang_export WHERE kode_barang='E2D-ZJBX-37-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-20261021-0001','1','E2D-ZJBX-38-0','1','1.540','1.540','TOKO','PMBK-E','TOKO','PM-E'); DELETE FROM tm_barang WHERE kode_barang='E2D-ZJBX-38-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2D-ZJBX-38-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-10-21 08:10:46' WHERE kode_barang='E2D-ZJBX-38-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='E2D-ZJBX-38-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-21 08:10:46','TOKO','PM-E','E2D','E2D-ZJBX-38-0','1','1.540','1.540','1','1.540','1.540','100.00'); DELETE FROM tm_dept WHERE kode_dept='E2D' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E2D' LIMIT 1; DELETE FROM tm_group WHERE kode_group='MD' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MD' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E2D-ZJBX-38-0'; DELETE FROM tm_barang_export WHERE kode_barang='E2D-ZJBX-38-0'; INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20261021-0001','2026-10-21','08:10','12.220','admpindah','2026-10-21 08:10:46'); 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 ('F326211007161','input','1',' MDE1 X CM ','TOKO','PM-E','E1D-ZHAE-167-0','CC X WEDDING POLOS CM 17 8K ','','1.500','1','100.00','1534000','0','0','15000','1535000','0','0','0','1535000','AAT','00419188','E1D','0','0','-','0','1033000'); UPDATE tm_barang SET tgl_last_jual='2026-10-21', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-ZHAE-167-0' 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-21' AND kode_barang='E1D-ZHAE-167-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 ('F326211007161','2026-10-21','1.500','2026-10-21','10:07:17','PLG0031986','1535000','1535000','0','1535000','1535000','input','2026-10-21 10:07:16','F32621100716'); 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-21','F326211007161','2026-10-21','10:07:17','AAT','1535000','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-261021-0004','D','2026-10-21','10:07:17','input','PENJUALAN','F326211007161','7944185000','1535000','7945720000','OPEN'); UPDATE tt_jual_head SET dibayar_rp='1535000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326211007161' 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 ('F326211007162','input',' 1',' MDE2 10K X','TOKO','PM-E','E2D-ZGAC-105-0','CC X WEDDING MATA CM 18 8K ','','1.980','1','100.00','2026000','0','0','15000','2025000','0','10000','0','2035000','AAT','00413371','E2D','0','0','-','1','1033000'); UPDATE tm_barang SET tgl_last_jual='2026-10-21', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZGAC-105-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.980',berat_jual_asli=berat_jual_asli+'1.980',stock_jual='1',berat_akhir=berat_akhir-'1.980',berat_akhir_asli=berat_akhir_asli-'1.980',stock_akhir='0' WHERE tanggal='2026-10-21' AND kode_barang='E2D-ZGAC-105-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 ('F326211007162','2026-10-21','1.980','2026-10-21','10:07:17','PLG0031987','2025000','2025000','10000','2035000','2035000','input','2026-10-21 10:07:16','F32621100716'); 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-21','F326211007162','2026-10-21','10:07:17','AAT','2035000','10000'); 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-261021-0005','D','2026-10-21','10:07:17','input','PENJUALAN','F326211007162','7945720000','2035000','7947755000','OPEN'); UPDATE tt_jual_head SET dibayar_rp='2035000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326211007162' 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 ('F326211028091','input','1',' MEH1 LG ','TOKO','PM-H','H1E-ZIAD-166-0','KL TRIXIE KUPU MATA VAR LG 8K ','','1.030','1','100.00','1074000','0','0','15000','1075000','0','0','0','1075000','FIT','00423526','H1E','0','0','-','0','1053000'); UPDATE tm_barang SET tgl_last_jual='2026-10-21', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZIAD-166-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.030',berat_jual_asli=berat_jual_asli+'1.030',stock_jual='1',berat_akhir=berat_akhir-'1.030',berat_akhir_asli=berat_akhir_asli-'1.030',stock_akhir='0' WHERE tanggal='2026-10-21' AND kode_barang='H1E-ZIAD-166-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 ('F326211028091','2026-10-21','1.030','2026-10-21','10:28:09','PLG0031988','1075000','1075000','0','1075000','1075000','input','2026-10-21 10:28:09','F32621102809'); 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-21','F326211028091','2026-10-21','10:28:09','FIT','1075000','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-261021-0006','D','2026-10-21','10:28:09','input','PENJUALAN','F326211028091','7947755000','1075000','7948830000'); 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 ('F326211039181','kasir','1',' TFA1 X UB ','TOKO','PT-A','A1TF-XAXC-65-T','AT X MODEL ITALY PANJANG VAR UB ','','1.350','1','100.00','2632000','0','0','15000','2633000','0','0','0','2633000','AAT','T0052910','A1TF','0','0','-','0','1950000'); UPDATE tm_barang SET tgl_last_jual='2026-10-21', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1TF-XAXC-65-T' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.350',berat_jual_asli=berat_jual_asli+'1.350',stock_jual='1',berat_akhir=berat_akhir-'1.350',berat_akhir_asli=berat_akhir_asli-'1.350',stock_akhir='0' WHERE tanggal='2026-10-21' AND kode_barang='A1TF-XAXC-65-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PT-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 ('F326211039181','2026-10-21','1.350','2026-10-21','10:39:19','PLG0031989','2633000','2633000','0','2633000','2633000','kasir','2026-10-21 10:39:18','F32621103918'); 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-21','F326211039181','2026-10-21','10:39:19','AAT','2633000','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-261021-0007','D','2026-10-21','10:39:19','kasir','PENJUALAN','F326211039181','7948830000','2633000','7951463000'); 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 ('F326211049111','kasir','1',' MED1E X UB','TOKO','PM-D','D1E-ZJXH-80-0','LT X MODEL SPECTRA SLEP UB 8K ','','0.510','1','100.00','537000','0','0','15000','532000','0','0','0','532000','SIN','00428568','D1E','0','0','-','1','1053000'); UPDATE tm_barang SET tgl_last_jual='2026-10-21', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1E-ZJXH-80-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-21' AND kode_barang='D1E-ZJXH-80-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 ('F326211049111','2026-10-21','0.510','2026-10-21','10:49:11','PLG0031990','532000','532000','0','532000','532000','kasir','2026-10-21 10:49:11','F32621104911'); 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-21','F326211049111','2026-10-21','10:49:11','SIN','532000','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-261021-0008','D','2026-10-21','10:49:11','kasir','PENJUALAN','F326211049111','7951463000','532000','7951995000','OPEN'); UPDATE tt_jual_head SET dibayar_rp='532000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326211049111' 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 ('F326211049112','kasir',' 1',' MEH1 X KH ','TOKO','PM-H','H1E-ZJXG-221-0','KL X SANTA SLEP KH 42 8K ','','2.010','1','100.00','2117000','0','0','15000','2096000','0','0','0','2096000','SIN','00428463','H1E','0','0','-','1','1053000'); UPDATE tm_barang SET tgl_last_jual='2026-10-21', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZJXG-221-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.010',berat_jual_asli=berat_jual_asli+'2.010',stock_jual='1',berat_akhir=berat_akhir-'2.010',berat_akhir_asli=berat_akhir_asli-'2.010',stock_akhir='0' WHERE tanggal='2026-10-21' AND kode_barang='H1E-ZJXG-221-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 ('F326211049112','2026-10-21','2.010','2026-10-21','10:49:11','PLG0031991','2096000','2096000','0','2096000','2096000','kasir','2026-10-21 10:49:11','F32621104911'); 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-21','F326211049112','2026-10-21','10:49:11','SIN','2096000','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-261021-0009','D','2026-10-21','10:49:11','kasir','PENJUALAN','F326211049112','7951995000','2096000','7954091000','OPEN'); UPDATE tt_jual_head SET dibayar_rp='2096000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326211049112' 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 ('F326211123001','kasir','1',' MDE2 X UB ','TOKO','PM-E','E2D-YGXG-84-0','CC X MODEL SOLITAIRE MATA UB 16 8K ','','1.080','1','100.00','1105000','0','0','15000','1105000','0','10000','0','1115000','LIS','00360069','E2D','0','0','-','0','1033000'); UPDATE tm_barang SET tgl_last_jual='2026-10-21', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-YGXG-84-0' 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-21' AND kode_barang='E2D-YGXG-84-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 ('F326211123001','2026-10-21','1.080','2026-10-21','11:23:01','PLG0031992','1105000','1105000','10000','1115000','1115000','kasir','2026-10-21 11:23:00','F32621112300'); 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-21','F326211123001','2026-10-21','11:23:01','LIS','1115000','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-261021-0010','D','2026-10-21','11:23:01','kasir','PENJUALAN','F326211123001','7954091000','1115000','7955206000'); 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 ('F326211138321','kasir','1',' MEF3E X YT','TOKO','PM-F','F3E-ZIBE-133-0','GL X SANTA DAUN SERUT YT 8K ','','1.870','1','100.00','1950000','0','0','15000','1950000','0','0','0','1950000','SIN','00425508','F3E','0','0','-','0','1053000'); UPDATE tm_barang SET tgl_last_jual='2026-10-21', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZIBE-133-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.870',berat_jual_asli=berat_jual_asli+'1.870',stock_jual='1',berat_akhir=berat_akhir-'1.870',berat_akhir_asli=berat_akhir_asli-'1.870',stock_akhir='0' WHERE tanggal='2026-10-21' AND kode_barang='F3E-ZIBE-133-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 ('F326211138321','2026-10-21','1.870','2026-10-21','11:38:33','PLG0031993','1950000','1950000','0','1950000','1950000','kasir','2026-10-21 11:38:32','F32621113832'); 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-21','F326211138321','2026-10-21','11:38:33','SIN','1950000','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-261021-0011','D','2026-10-21','11:38:33','kasir','PENJUALAN','F326211138321','7955206000','1950000','7957156000'); 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-00020602','X-00020602','KL JEDAR KH 42 9K','GR','---','H2I','BELI','BELI001','965000','2026-10-21','1.200','1','kasir','2026-10-21 11:42:29'); DELETE FROM tp_barang WHERE kode_dept = 'X-H2I'; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-H2I','X-00020602','X-00020602'); 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-261021-0001','F325051004391','SIN','1','BELI','BELI001','H2I', 'X-00020602', 'KL JEDAR KH 42 9K','1.200','1.200','100.00','960000','965000','804167','1133000','1','965000','965000','CUCI'); UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.200',berat_beli_asli=berat_beli_asli+'1.200',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.200',berat_akhir_asli=berat_akhir_asli+'1.200',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-10-21' 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-261021-0001','2026-10-21','2026-10-21','11:42:28','SIN','---','1.200','965000','965000','965000','965000','965000','kasir','2026-10-21 11:42:29','FB-261021-0001'); INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261021-0001','ASIH','NDADAKAN','','','','kasir','2026-10-21 11:42:29'); SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-10-21' 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-261021-0012','K','2026-10-21','11:42:28','kasir','PEMBELIAN UMUM','FB-261021-0001','7957156000','965000','7956191000'); 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-00020603','X-00020603','AT COR 8K','GR','---','A1F','BELI','BELI001','320000','2026-10-21','0.530','1','kasir','2026-10-21 11:43:48'); DELETE FROM tp_barang WHERE kode_dept = 'X-A1F'; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-A1F','X-00020603','X-00020603'); 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-261021-0002','F323031109091','SIN','1','BELI','BELI001','A1F', 'X-00020603', 'AT COR 8K','0.530','0.530','100.00','268000','320000','603774','1073000','1','320000','320000','CUCI'); UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.530',berat_beli_asli=berat_beli_asli+'0.530',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.530',berat_akhir_asli=berat_akhir_asli+'0.530',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-10-21' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='A1F' 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-261021-0002','2026-10-21','2026-10-21','11:43:48','SIN','---','0.530','320000','320000','320000','320000','320000','kasir','2026-10-21 11:43:48','FB-261021-0002'); INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261021-0002','ASIH','DADAGAN','','','','kasir','2026-10-21 11:43:48'); SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-10-21' 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-261021-0013','K','2026-10-21','11:43:48','kasir','PEMBELIAN UMUM','FB-261021-0002','7956191000','320000','7955871000'); 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-00020604','X-00020604','CC MODEL BUNGA ARESO VAR YT 16 17K','GR','---','E1TD','BELI','BELI001','1670000','2026-10-21','1.110','1','kasir','2026-10-21 11:44:11'); DELETE FROM tp_barang WHERE kode_dept = 'X-E1TD'; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E1TD','X-00020604','X-00020604'); 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-261021-0003','F325220221221','LIS','1','BELI','BELI001','E1TD', 'X-00020604', 'CC MODEL BUNGA ARESO VAR YT 16 17K','1.110','1.110','100.00','1763000','1670000','1504505','1910000','1','1670000','1670000','CUCI'); UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.110',berat_beli_asli=berat_beli_asli+'1.110',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.110',berat_akhir_asli=berat_akhir_asli+'1.110',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-10-21' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E1TD' 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-261021-0003','2026-10-21','2026-10-21','11:44:10','LIS','---','1.110','1670000','1670000','1670000','1670000','1670000','kasir','2026-10-21 11:44:11','FB-261021-0003'); INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261021-0003','SRI LESTARI','SUMBER BITING','','','','kasir','2026-10-21 11:44:11'); SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-10-21' 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-261021-0014','K','2026-10-21','11:44:10','kasir','PEMBELIAN UMUM','FB-261021-0003','7955871000','1670000','7954201000'); 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-00020605','X-00020605','GL MODEL VERONA VAR LT 8K','GR','---','F3E','BELI','BELI001','1447000','2026-10-21','1.980','1','kasir','2026-10-21 13:02:41'); DELETE FROM tp_barang WHERE kode_dept = 'X-F3E'; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F3E','X-00020605','X-00020605'); 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-261021-0004','F325220903251','LIS','1','BELI','BELI001','F3E', 'X-00020605', 'GL MODEL VERONA VAR LT 8K','1.980','1.980','100.00','1625000','1447000','730808','1053000','1','1447000','1447000','RUSAK'); 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-21' 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-261021-0004','2026-10-21','2026-10-21','13:02:40','LIS','---','1.980','1447000','1447000','1447000','1447000','1447000','kasir','2026-10-21 13:02:41','FB-261021-0004'); INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261021-0004','SUDARTI','PLOSOREJO KISMANTORO','','','','kasir','2026-10-21 13:02:41'); SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-10-21' 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-261021-0015','K','2026-10-21','13:02:40','kasir','PEMBELIAN UMUM','FB-261021-0004','7954201000','1447000','7952754000'); 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 ('F326210129071','kasir','1',' MEF1 X TD ','TOKO','PM-F','F1E-ZJXG-165-0','GL X OVAL C SLEP TD 65 8K ','','3.880','1','100.00','4086000','0','0','15000','4047000','0','0','0','4047000','SIN','00428407','F1E','0','0','-','1','1053000'); UPDATE tm_barang SET tgl_last_jual='2026-10-21', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-ZJXG-165-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.880',berat_jual_asli=berat_jual_asli+'3.880',stock_jual='1',berat_akhir=berat_akhir-'3.880',berat_akhir_asli=berat_akhir_asli-'3.880',stock_akhir='0' WHERE tanggal='2026-10-21' AND kode_barang='F1E-ZJXG-165-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 ('F326210129071','2026-10-21','3.880','2026-10-21','13:29:07','PLG0031994','4047000','4047000','0','4047000','4047000','kasir','2026-10-21 13:29:07','F32621012907'); 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-21','F326210129071','2026-10-21','13:29:07','SIN','4047000','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-261021-0016','D','2026-10-21','13:29:07','kasir','PENJUALAN','F326210129071','7952754000','4047000','7956801000','OPEN'); UPDATE tt_jual_head SET dibayar_rp='4047000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326210129071' 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 ('F326210129072','kasir',' 1',' MDE2 X LG ','TOKO','PM-E','E2D-ZGCX-165-0','CC X METRO MATA LG 18 8K ','','1.500','1','100.00','1534000','0','0','15000','1534000','0','0','0','1534000','SIN','00416064','E2D','0','0','-','0','1033000'); UPDATE tm_barang SET tgl_last_jual='2026-10-21', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZGCX-165-0' 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-21' AND kode_barang='E2D-ZGCX-165-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 ('F326210129072','2026-10-21','1.500','2026-10-21','13:29:07','PLG0031995','1534000','1534000','0','1534000','1534000','kasir','2026-10-21 13:29:07','F32621012907'); 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-21','F326210129072','2026-10-21','13:29:07','SIN','1534000','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-261021-0017','D','2026-10-21','13:29:07','kasir','PENJUALAN','F326210129072','7956801000','1534000','7958335000','OPEN'); UPDATE tt_jual_head SET dibayar_rp='1534000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326210129072' 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 ('F326210129371','kasir','1',' MEE2 HTM 1','TOKO','PM-E','E2E-ZJXA-99-0','CC PIPA MODEL MATA VAR HTM 16 8K ','','0.500','1','100.00','521000','0','0','15000','521000','0','0','0','521000','SIN','00426732','E2E','0','0','-','0','1053000'); UPDATE tm_barang SET tgl_last_jual='2026-10-21', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-ZJXA-99-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.500',berat_jual_asli=berat_jual_asli+'0.500',stock_jual='1',berat_akhir=berat_akhir-'0.500',berat_akhir_asli=berat_akhir_asli-'0.500',stock_akhir='0' WHERE tanggal='2026-10-21' AND kode_barang='E2E-ZJXA-99-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 ('F326210129371','2026-10-21','0.500','2026-10-21','13:29:38','PLG0031996','521000','521000','0','521000','521000','kasir','2026-10-21 13:29:37','F32621012937'); 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-21','F326210129371','2026-10-21','13:29:38','SIN','521000','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-261021-0018','D','2026-10-21','13:29:38','kasir','PENJUALAN','F326210129371','7958335000','521000','7958856000'); 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-00020606','X-00020606','GW X DAISY MATA LG PE 8K','GR','---','B1D','BELI','BELI001','742000','2026-10-21','1.020','1','kasir','2026-10-21 14:18:59'); DELETE FROM tp_barang WHERE kode_dept = 'X-B1D'; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-B1D','X-00020606','X-00020606'); 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-261021-0005','F325090242491','AAT','1','BELI','BELI001','B1D', 'X-00020606', 'GW X DAISY MATA LG PE 8K','1.020','1.020','100.00','790000','742000','727451','1033000','1','742000','742000','CUCI'); UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.020',berat_beli_asli=berat_beli_asli+'1.020',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.020',berat_akhir_asli=berat_akhir_asli+'1.020',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-10-21' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='B1D' 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-261021-0005','2026-10-21','2026-10-21','14:18:59','AAT','---','1.020','742000','742000','742000','742000','742000','kasir','2026-10-21 14:18:59','FB-261021-0005'); INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261021-0005','JAMI','KEPYAR','','','','kasir','2026-10-21 14:18:59'); SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-10-21' 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-261021-0019','K','2026-10-21','14:18:59','kasir','PEMBELIAN UMUM','FB-261021-0005','7958856000','742000','7958114000'); UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261021-0001' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261021-0001'; UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261021-0002' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261021-0002'; UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261021-0003' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261021-0003'; UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261021-0004' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261021-0004'; UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261021-0005' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261021-0005'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326210129071' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326210129071' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326210129071'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326210129072' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326210129072' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326210129072'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326210129371' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326210129371' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326210129371'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326210801191' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326210801191' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326210801191'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326210805481' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326210805481' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326210805481'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326211007161' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326211007161' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326211007161'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326211007162' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326211007162' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326211007162'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326211028091' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326211028091' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326211028091'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326211039181' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326211039181' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326211039181'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326211049111' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326211049111' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326211049111'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326211049112' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326211049112' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326211049112'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326211123001' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326211123001' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326211123001'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326211138321' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326211138321' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326211138321'; INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-10-22','0','0','0','0','0','0'); DELETE FROM th_barang_saldo WHERE tanggal <= '2026-09-21'; INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-10-21'; UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-10-21'; INSERT INTO tt_barang_saldo (kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_awal,berat_awal_asli,stock_awal,berat_akhir,berat_akhir_asli,stock_akhir) SELECT kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_akhir,berat_akhir_asli,stock_akhir,berat_akhir,berat_akhir_asli,stock_akhir FROM tt_barang_saldo WHERE tanggal='2026-10-21' AND berat_akhir*1 > '0' INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-10-21'; DELETE FROM tt_cash_daily WHERE tanggal <= '2026-10-21'; INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-10-21'; DELETE FROM tt_bank_daily WHERE tanggal <= '2026-10-21'; 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-22' WHERE status_close ='OPEN'; DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-10-21' 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-261022-0001','D','2026-10-22','15:11:02','SYSTEM','SALDO AWAL','SALDO AWAL','0','7958114000','7958114000'); 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-261022-0001','D','2026-10-22','15:11:02','BCA','SALDO AWAL','SALDO AWAL','0','743627000','743627000'); 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-261022-0001','D','2026-10-22','15:11:02','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-261022-0001','D','2026-10-22','15:11:02','DLL','SALDO AWAL','SALDO AWAL','0','0','0'); UPDATE tp_system SET tgl_system='2026-10-22';