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 ('F326140906591','input','1',' MEF3E XX U','TOKO','PM-F','F3E-ZAXH-250-0','GL XX FLIK ARESPO VAR UB 8K ','','5.750','1','100.00','6440000','0','0','15000','6268000','0','0','0','6268000','SIN','00384336','F3E','0','0','-','1','1130000');
UPDATE tm_barang SET tgl_last_jual='2026-05-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZAXH-250-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'5.750',berat_jual_asli=berat_jual_asli+'5.750',stock_jual='1',berat_akhir=berat_akhir-'5.750',berat_akhir_asli=berat_akhir_asli-'5.750',stock_akhir='0' WHERE tanggal='2026-05-14' AND kode_barang='F3E-ZAXH-250-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 ('F326140906591','2026-05-14','5.750','2026-05-14','09:06:59','PLG0029160','6268000','6268000','0','6268000','6268000','input','2026-05-14 09:06:59','F32614090659');
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-05-14','F326140906591','2026-05-14','09:06:59','SIN','6268000','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-260514-0002','D','2026-05-14','09:06:59','input','PENJUALAN','F326140906591','4988041000','6268000','4994309000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='6268000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326140906591' 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 ('F326140906592','input',' 1',' MHB1 LG ','TOKO','PM-B','B1H-ZDAC-118-0','GW TUSUK MRICAN POLOS LG 8K ','','0.260','1','100.00','307000','0','0','15000','307000','0','0','0','307000','SIN','00399288','B1H','0','0','-','0','1180000');
UPDATE tm_barang SET tgl_last_jual='2026-05-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1H-ZDAC-118-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.260',berat_jual_asli=berat_jual_asli+'0.260',stock_jual='1',berat_akhir=berat_akhir-'0.260',berat_akhir_asli=berat_akhir_asli-'0.260',stock_akhir='0' WHERE tanggal='2026-05-14' AND kode_barang='B1H-ZDAC-118-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-B' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326140906592','2026-05-14','0.260','2026-05-14','09:06:59','PLG0029161','307000','307000','0','307000','307000','input','2026-05-14 09:06:59','F32614090659');
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-05-14','F326140906592','2026-05-14','09:06:59','SIN','307000','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-260514-0003','D','2026-05-14','09:06:59','input','PENJUALAN','F326140906592','4994309000','307000','4994616000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='307000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326140906592' 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-00019098','X-00019098','GL X CAPELLA SLEP HW 8K','GR','---','F3E','BELI','BELI001','1430000','2026-05-14','1.360','1','kasir','2026-05-14 09:32:23');
DELETE FROM tp_barang WHERE kode_dept = 'X-F3E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F3E','X-00019098','X-00019098');
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-260514-0001','F326110235502','AAT','1','BELI','BELI001','F3E', 'X-00019098', 'GL X CAPELLA SLEP HW 8K','1.360','1.360','100.00','1598000','1430000','1051471','1130000','1','1430000','1430000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.360',berat_beli_asli=berat_beli_asli+'1.360',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.360',berat_akhir_asli=berat_akhir_asli+'1.360',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-05-14' 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-260514-0001','2026-05-14','2026-05-14','09:32:22','AAT','---','1.360','1430000','1430000','1430000','1430000','1430000','kasir','2026-05-14 09:32:23','FB-260514-0001');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260514-0001','ENDAH','BLIMBING PURWANTORO','','','085879053968','kasir','2026-05-14 09:32:23');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-05-14' 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-260514-0004','K','2026-05-14','09:32:22','kasir','PEMBELIAN UMUM','FB-260514-0001','4994616000','1430000','4993186000');
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 ('F326140940401','kasir','1',' MDE2 X UB ','TOKO','PM-E','E2D-YIAC-129-0','CC X MODEL MATA UB 11 8K ','','1.870','1','100.00','2057000','0','0','15000','2057000','0','8000','0','2065000','AAT','00369213','E2D','0','0','-','0','1110000');
UPDATE tm_barang SET tgl_last_jual='2026-05-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-YIAC-129-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-05-14' AND kode_barang='E2D-YIAC-129-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 ('F326140940401','2026-05-14','1.870','2026-05-14','09:40:41','PLG0029162','2057000','2057000','8000','2065000','2065000','kasir','2026-05-14 09:40:40','F32614094040');
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-05-14','F326140940401','2026-05-14','09:40:41','AAT','2065000','8000');
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-260514-0005','D','2026-05-14','09:40:41','kasir','PENJUALAN','F326140940401','4993186000','2065000','4995251000');
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 ('F326140957231','kasir','1',' MEF3E X HW','TOKO','PM-F','F3E-ZEXE-105-0','GL X CAPELLA SLEP HW 8K ','','1.200','1','100.00','1344000','0','0','15000','1345000','0','0','0','1345000','AAT','00402278','F3E','0','0','-','0','1130000');
UPDATE tm_barang SET tgl_last_jual='2026-05-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZEXE-105-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.200',berat_jual_asli=berat_jual_asli+'1.200',stock_jual='1',berat_akhir=berat_akhir-'1.200',berat_akhir_asli=berat_akhir_asli-'1.200',stock_akhir='0' WHERE tanggal='2026-05-14' AND kode_barang='F3E-ZEXE-105-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 ('F326140957231','2026-05-14','1.200','2026-05-14','09:57:23','PLG0029163','1345000','1345000','0','1345000','1345000','kasir','2026-05-14 09:57:23','F32614095723');
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-05-14','F326140957231','2026-05-14','09:57:23','AAT','1345000','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-260514-0006','D','2026-05-14','09:57:23','kasir','PENJUALAN','F326140957231','4995251000','1345000','4996596000');
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-00019099','X-00019099','GL X OVAL TINJU MATA UB 54','GR','---','F2E','BELI','BELI001','4300000','2026-05-14','6.210','1','kasir','2026-05-14 09:59:57');
DELETE FROM tp_barang WHERE kode_dept = 'X-F2E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F2E','X-00019099','X-00019099');
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-260514-0002','F324040946121','LIS','1','BELI','BELI001','F2E', 'X-00019099', 'GL X OVAL TINJU MATA UB 54','6.210','6.210','100.00','3075000','4300000','692432','1130000','1','4300000','4300000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'6.210',berat_beli_asli=berat_beli_asli+'6.210',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'6.210',berat_akhir_asli=berat_akhir_asli+'6.210',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-05-14' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='F2E' 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-260514-0002','2026-05-14','2026-05-14','09:59:57','LIS','---','6.210','4300000','4300000','4300000','4300000','4300000','kasir','2026-05-14 09:59:57','FB-260514-0002');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260514-0002','ARIF','PURWANTORO','','','','kasir','2026-05-14 09:59:57');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-05-14' 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-260514-0007','K','2026-05-14','09:59:57','kasir','PEMBELIAN UMUM','FB-260514-0002','4996596000','4300000','4992296000');
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 ('F326141011191','kasir','1',' MDB1 X UB ','TOKO','PM-B','B1D-ZCBD-106-0','GW X MODEL BOLA PASIR UB PE 8K ','','0.960','1','100.00','1056000','0','0','15000','1056000','0','0','0','1056000','SIN','00396586','B1D','0','0','-','0','1110000');
UPDATE tm_barang SET tgl_last_jual='2026-05-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1D-ZCBD-106-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.960',berat_jual_asli=berat_jual_asli+'0.960',stock_jual='1',berat_akhir=berat_akhir-'0.960',berat_akhir_asli=berat_akhir_asli-'0.960',stock_akhir='0' WHERE tanggal='2026-05-14' AND kode_barang='B1D-ZCBD-106-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-B' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326141011191','2026-05-14','0.960','2026-05-14','10:11:20','PLG0029164','1056000','1056000','0','1056000','1056000','kasir','2026-05-14 10:11:19','F32614101119');
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-05-14','F326141011191','2026-05-14','10:11:20','SIN','1056000','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-260514-0008','D','2026-05-14','10:11:20','kasir','PENJUALAN','F326141011191','4992296000','1056000','4993352000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1056000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326141011191' 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 ('F326141011192','kasir',' 1',' MEB1 5K CM','TOKO','PM-B','B1E-ZDBC-215-0','GW TUSUK BUNGA CLOVER CAT CM PE 8K ','','0.530','1','100.00','594000','0','0','15000','595000','0','5000','0','600000','SIN','00400937','B1E','0','0','-','0','1130000');
UPDATE tm_barang SET tgl_last_jual='2026-05-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1E-ZDBC-215-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.530',berat_jual_asli=berat_jual_asli+'0.530',stock_jual='1',berat_akhir=berat_akhir-'0.530',berat_akhir_asli=berat_akhir_asli-'0.530',stock_akhir='0' WHERE tanggal='2026-05-14' AND kode_barang='B1E-ZDBC-215-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-B' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326141011192','2026-05-14','0.530','2026-05-14','10:11:20','PLG0029165','595000','595000','5000','600000','600000','kasir','2026-05-14 10:11:19','F32614101119');
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-05-14','F326141011192','2026-05-14','10:11:20','SIN','600000','5000');
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-260514-0009','D','2026-05-14','10:11:20','kasir','PENJUALAN','F326141011192','4993352000','600000','4993952000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='600000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326141011192' 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 ('F326141011193','kasir',' 1',' MEF3E X LT','TOKO','PM-F','F3E-YGAX-41-0','GL X VERONICA SLEP LT 8K ','','4.170','1','100.00','4670000','0','0','15000','4670000','0','0','0','4670000','SIN','00360435','F3E','0','0','-','0','1130000');
UPDATE tm_barang SET tgl_last_jual='2026-05-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-YGAX-41-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.170',berat_jual_asli=berat_jual_asli+'4.170',stock_jual='1',berat_akhir=berat_akhir-'4.170',berat_akhir_asli=berat_akhir_asli-'4.170',stock_akhir='0' WHERE tanggal='2026-05-14' AND kode_barang='F3E-YGAX-41-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 ('F326141011193','2026-05-14','4.170','2026-05-14','10:11:20','PLG0029166','4670000','4670000','0','4670000','4670000','kasir','2026-05-14 10:11:19','F32614101119');
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-05-14','F326141011193','2026-05-14','10:11:20','SIN','4670000','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-260514-0010','D','2026-05-14','10:11:20','kasir','PENJUALAN','F326141011193','4993952000','4670000','4998622000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='4670000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326141011193' 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 ('F326141022391','kasir','1',' MEF1 TD D5','TOKO','PM-F','F1E-ZCCA-204-0','GL OVAL MODEL C TD D58 8K ','','3.320','1','100.00','3718000','0','0','15000','3718000','0','0','0','3718000','AAT','00397428','F1E','0','0','-','0','1130000');
UPDATE tm_barang SET tgl_last_jual='2026-05-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-ZCCA-204-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.320',berat_jual_asli=berat_jual_asli+'3.320',stock_jual='1',berat_akhir=berat_akhir-'3.320',berat_akhir_asli=berat_akhir_asli-'3.320',stock_akhir='0' WHERE tanggal='2026-05-14' AND kode_barang='F1E-ZCCA-204-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-F' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326141022391','2026-05-14','3.320','2026-05-14','10:22:39','PLG0029167','3718000','3718000','0','3718000','3718000','kasir','2026-05-14 10:22:39','F32614102239');
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-05-14','F326141022391','2026-05-14','10:22:39','AAT','3718000','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-260514-0011','D','2026-05-14','10:22:39','kasir','PENJUALAN','F326141022391','4998622000','3718000','5002340000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='3718000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326141022391' 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 ('F326141022392','kasir',' 1',' MED1 XX CM','TOKO','PM-E','E1D-ZBXF-212-0','CC XX POLOS CM 16 8K','','1.030','1','100.00','1133000','0','0','15000','1122000','0','0','0','1122000','AAT','00388794','E1D','0','0','-','1','1110000');
UPDATE tm_barang SET tgl_last_jual='2026-05-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-ZBXF-212-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-05-14' AND kode_barang='E1D-ZBXF-212-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 ('F326141022392','2026-05-14','1.030','2026-05-14','10:22:39','PLG0029168','1122000','1122000','0','1122000','1122000','kasir','2026-05-14 10:22:39','F32614102239');
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-05-14','F326141022392','2026-05-14','10:22:39','AAT','1122000','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-260514-0012','D','2026-05-14','10:22:39','kasir','PENJUALAN','F326141022392','5002340000','1122000','5003462000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1122000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326141022392' 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 ('F326141023421','kasir','1',' MEF1 X TD ','TOKO','PM-F','F1E-YCBD-3-0','GL X BANGKOK C TD 58 8K ','','5.000','1','100.00','5600000','0','0','15000','5600000','0','0','0','5600000','SIN','00344796','F1E','0','0','-','0','1130000');
UPDATE tm_barang SET tgl_last_jual='2026-05-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-YCBD-3-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'5.000',berat_jual_asli=berat_jual_asli+'5.000',stock_jual='1',berat_akhir=berat_akhir-'5.000',berat_akhir_asli=berat_akhir_asli-'5.000',stock_akhir='0' WHERE tanggal='2026-05-14' AND kode_barang='F1E-YCBD-3-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 ('F326141023421','2026-05-14','5.000','2026-05-14','10:23:43','PLG0029169','5600000','5600000','0','5600000','5600000','kasir','2026-05-14 10:23:42','F32614102342');
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-05-14','F326141023421','2026-05-14','10:23:43','SIN','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-260514-0013','D','2026-05-14','10:23:43','kasir','PENJUALAN','F326141023421','5003462000','5600000','5009062000');
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 ('F326141029051','kasir','1',' MJH2 X UB ','TOKO','PM-H','H2J-ZDAX-40-0','KL X GUCCI ANAK UB 34 9K ','','2.000','1','100.00','2440000','0','0','15000','2440000','0','0','0','2440000','LIS','00398810','H2J','0','0','-','0','1230000');
UPDATE tm_barang SET tgl_last_jual='2026-05-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H2J-ZDAX-40-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.000',berat_jual_asli=berat_jual_asli+'2.000',stock_jual='1',berat_akhir=berat_akhir-'2.000',berat_akhir_asli=berat_akhir_asli-'2.000',stock_akhir='0' WHERE tanggal='2026-05-14' AND kode_barang='H2J-ZDAX-40-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 ('F326141029051','2026-05-14','2.000','2026-05-14','10:29:05','PLG0029170','2440000','2440000','0','2440000','2440000','kasir','2026-05-14 10:29:05','F32614102905');
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-05-14','F326141029051','2026-05-14','10:29:05','LIS','2440000','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-260514-0014','D','2026-05-14','10:29:05','kasir','PENJUALAN','F326141029051','5009062000','2440000','5011502000');
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 ('F326141030011','kasir','1',' MEE1 HTM 1','TOKO','PM-E','E1E-ZEXA-37-0','CC PIPA MODEL DAUN VAR HTM 18 8K ','','0.500','1','100.00','560000','0','0','15000','560000','0','0','0','560000','AAT','00401934','E1E','0','0','-','0','1130000');
UPDATE tm_barang SET tgl_last_jual='2026-05-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZEXA-37-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-05-14' AND kode_barang='E1E-ZEXA-37-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 ('F326141030011','2026-05-14','0.500','2026-05-14','10:30:01','PLG0029171','560000','560000','0','560000','560000','kasir','2026-05-14 10:30:01','F32614103001');
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-05-14','F326141030011','2026-05-14','10:30:01','AAT','560000','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-260514-0015','D','2026-05-14','10:30:01','kasir','PENJUALAN','F326141030011','5011502000','560000','5012062000');
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 ('F326141039211','kasir','1',' MEF3 YT ','TOKO','PM-F','F3E-YDAB-70-0','GL MODEL FANCY VAR YT 8K ','','2.520','1','100.00','2822000','0','0','15000','2823000','0','0','0','2823000','SIN','00349218','F3E','0','0','-','0','1130000');
UPDATE tm_barang SET tgl_last_jual='2026-05-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-YDAB-70-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.520',berat_jual_asli=berat_jual_asli+'2.520',stock_jual='1',berat_akhir=berat_akhir-'2.520',berat_akhir_asli=berat_akhir_asli-'2.520',stock_akhir='0' WHERE tanggal='2026-05-14' AND kode_barang='F3E-YDAB-70-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 ('F326141039211','2026-05-14','2.520','2026-05-14','10:39:22','PLG0029172','2823000','2823000','0','2823000','2823000','kasir','2026-05-14 10:39:21','F32614103921');
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-05-14','F326141039211','2026-05-14','10:39:22','SIN','2823000','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-260514-0016','D','2026-05-14','10:39:22','kasir','PENJUALAN','F326141039211','5012062000','2823000','5014885000');
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 ('F326141043341','kasir','1',' MEA1E X LG','TOKO','PM-A','A1E-ZDBI-15-0','AT X BONEKA ANAK CAT LG 8K ','','0.530','1','100.00','594000','0','0','15000','595000','0','0','0','595000','AAT','00401661','A1E','0','0','-','0','1130000');
UPDATE tm_barang SET tgl_last_jual='2026-05-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1E-ZDBI-15-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.530',berat_jual_asli=berat_jual_asli+'0.530',stock_jual='1',berat_akhir=berat_akhir-'0.530',berat_akhir_asli=berat_akhir_asli-'0.530',stock_akhir='0' WHERE tanggal='2026-05-14' AND kode_barang='A1E-ZDBI-15-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-A' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326141043341','2026-05-14','0.530','2026-05-14','10:43:34','PLG0029173','595000','595000','0','595000','595000','kasir','2026-05-14 10:43:34','F32614104334');
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-05-14','F326141043341','2026-05-14','10:43:34','AAT','595000','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-260514-0017','D','2026-05-14','10:43:34','kasir','PENJUALAN','F326141043341','5014885000','595000','5015480000');
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-00019100','X-00019100','AT TINDIK BABY DG 8K','GR','---','A1E','BELI','BELI001','130000','2026-05-14','0.230','1','kasir','2026-05-14 10:59:45');
DELETE FROM tp_barang WHERE kode_dept = 'X-A1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-A1E','X-00019100','X-00019100');
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-260514-0003','F324081118021','AAT','1','BELI','BELI001','A1E', 'X-00019100', 'AT TINDIK BABY DG 8K','0.520','0.230','100.00','310000','130000','565217','1130000','1','130000','130000','RUSAK');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.230',berat_beli_asli=berat_beli_asli+'0.230',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.230',berat_akhir_asli=berat_akhir_asli+'0.230',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-05-14' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='A1E' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-260514-0003','2026-05-14','2026-05-14','10:59:45','AAT','---','0.230','130000','130000','130000','130000','130000','kasir','2026-05-14 10:59:45','FB-260514-0003');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260514-0003','ZOLA','PENGGUNG NAWANGAN','','','','kasir','2026-05-14 10:59:45');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-05-14' 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-260514-0018','K','2026-05-14','10:59:45','kasir','PEMBELIAN UMUM','FB-260514-0003','5015480000','130000','5015350000');
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 ('F326141110091','kasir','1',' MJH3 X UB ','TOKO','PM-H','H3J-ZDBX-166-0','KL X SANTA MATA VAR UB 42 9K ','','4.100','1','100.00','5002000','0','0','15000','5000000','0','0','0','5000000','AAT','00400103','H3J','0','0','-','1','1230000');
UPDATE tm_barang SET tgl_last_jual='2026-05-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H3J-ZDBX-166-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.100',berat_jual_asli=berat_jual_asli+'4.100',stock_jual='1',berat_akhir=berat_akhir-'4.100',berat_akhir_asli=berat_akhir_asli-'4.100',stock_akhir='0' WHERE tanggal='2026-05-14' AND kode_barang='H3J-ZDBX-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 ('F326141110091','2026-05-14','4.100','2026-05-14','11:10:09','PLG0029174','5000000','5000000','0','5000000','5000000','kasir','2026-05-14 11:10:09','F32614111009');
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-05-14','F326141110091','2026-05-14','11:10:09','AAT','5000000','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-260514-0019','D','2026-05-14','11:10:09','kasir','PENJUALAN','F326141110091','5015350000','5000000','5020350000');
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 ('F326141134301','kasir','1',' MEF3E X UB','TOKO','PM-F','F3E-ZDBG-110-0','GL X MEDAN ARESO VAR UB 8K ','','3.590','1','100.00','4021000','0','0','15000','4020000','0','0','0','4020000','SIN','00401353','F3E','0','0','-','1','1130000');
UPDATE tm_barang SET tgl_last_jual='2026-05-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZDBG-110-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.590',berat_jual_asli=berat_jual_asli+'3.590',stock_jual='1',berat_akhir=berat_akhir-'3.590',berat_akhir_asli=berat_akhir_asli-'3.590',stock_akhir='0' WHERE tanggal='2026-05-14' AND kode_barang='F3E-ZDBG-110-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 ('F326141134301','2026-05-14','3.590','2026-05-14','11:34:30','PLG0029175','4020000','4020000','0','4020000','4020000','kasir','2026-05-14 11:34:30','F32614113430');
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-05-14','F326141134301','2026-05-14','11:34:30','SIN','4020000','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-260514-0020','D','2026-05-14','11:34:30','kasir','PENJUALAN','F326141134301','5020350000','4020000','5024370000');
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 ('F326141143111','kasir','1',' MDA1D X LG','TOKO','PM-A','A1D-XJAI-154-0','AT X BONEKA ANAK KLIP MT CAT LG 8K ','','1.130','1','100.00','1243000','0','0','15000','1243000','0','0','0','1243000','SIN','00322173','A1D','0','0','-','0','1110000');
UPDATE tm_barang SET tgl_last_jual='2026-05-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1D-XJAI-154-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.130',berat_jual_asli=berat_jual_asli+'1.130',stock_jual='1',berat_akhir=berat_akhir-'1.130',berat_akhir_asli=berat_akhir_asli-'1.130',stock_akhir='0' WHERE tanggal='2026-05-14' AND kode_barang='A1D-XJAI-154-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-A' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326141143111','2026-05-14','1.130','2026-05-14','11:43:12','PLG0029176','1243000','1243000','0','1243000','1243000','kasir','2026-05-14 11:43:11','F32614114311');
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-05-14','F326141143111','2026-05-14','11:43:12','SIN','1243000','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-260514-0021','D','2026-05-14','11:43:12','kasir','PENJUALAN','F326141143111','5024370000','1243000','5025613000');
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-00019101','X-00019101','GL OVAL C SLEP TD 56 8K','GR','---','F1E','BELI','BELI001','2640000','2026-05-14','3.280','1','kasir','2026-05-14 11:52:59');
DELETE FROM tp_barang WHERE kode_dept = 'X-F1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F1E','X-00019101','X-00019101');
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-260514-0004','F325011047511','AAT','1','BELI','BELI001','F1E', 'X-00019101', 'GL OVAL C SLEP TD 56 8K','3.280','3.280','100.00','2680000','2640000','804878','1130000','1','2640000','2640000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'3.280',berat_beli_asli=berat_beli_asli+'3.280',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'3.280',berat_akhir_asli=berat_akhir_asli+'3.280',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-05-14' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='F1E' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-260514-0004','2026-05-14','2026-05-14','11:52:58','AAT','---','3.280','2640000','2640000','2640000','2640000','2640000','kasir','2026-05-14 11:52:59','FB-260514-0004');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260514-0004','VIKA','SAYUTAN PARANG','','','','kasir','2026-05-14 11:52:59');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-05-14' 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-260514-0022','K','2026-05-14','11:52:58','kasir','PEMBELIAN UMUM','FB-260514-0004','5025613000','2640000','5022973000');
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-00019102','X-00019102','GW X MRICAN SLEP AV 8K','GR','---','B0C','BELI','BELI001','455000','2026-05-14','0.450','1','kasir','2026-05-14 13:08:50');
DELETE FROM tp_barang WHERE kode_dept = 'X-B0C';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-B0C','X-00019102','X-00019102');
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-260514-0005','F326100801401','SIN','1','BELI','BELI001','B0C', 'X-00019102', 'GW X MRICAN SLEP AV 8K','0.450','0.450','100.00','525000','455000','1011111','1080000','1','455000','455000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.450',berat_beli_asli=berat_beli_asli+'0.450',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.450',berat_akhir_asli=berat_akhir_asli+'0.450',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-05-14' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='B0C' 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-260514-0005','2026-05-14','2026-05-14','13:08:50','SIN','---','0.450','455000','455000','455000','455000','455000','kasir','2026-05-14 13:08:50','FB-260514-0005');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260514-0005','NINING','SEMBUNG SUGIHAN BLO','','','','kasir','2026-05-14 13:08:50');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-05-14' 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-260514-0023','K','2026-05-14','13:08:50','kasir','PEMBELIAN UMUM','FB-260514-0005','5022973000','455000','5022518000');
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-00019103','X-00019103','CC VELG C SLEP CM 17 8K','GR','---','E1D','BELI','BELI001','1050000','2026-05-14','1.030','1','kasir','2026-05-14 13:49:02');
DELETE FROM tp_barang WHERE kode_dept = 'X-E1D';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E1D','X-00019103','X-00019103');
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-260514-0006','F326141130561','SIN','1','BELI','BELI001','E1D', 'X-00019103', 'CC VELG C SLEP CM 17 8K','1.030','1.030','100.00','1263000','1050000','1019417','1110000','1','1050000','1050000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.030',berat_beli_asli=berat_beli_asli+'1.030',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.030',berat_akhir_asli=berat_akhir_asli+'1.030',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-05-14' 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-260514-0006','2026-05-14','2026-05-14','13:49:02','SIN','---','1.030','1050000','1050000','1050000','1050000','1050000','kasir','2026-05-14 13:49:02','FB-260514-0006');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260514-0006','DYAH','TALESAN','','','085786317538','kasir','2026-05-14 13:49:02');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-05-14' 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-260514-0024','K','2026-05-14','13:49:02','kasir','PEMBELIAN UMUM','FB-260514-0006','5022518000','1050000','5021468000');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326140906591' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326140906591' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326140906591';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326140906592' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326140906592' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326140906592';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326140940401' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326140940401' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326140940401';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326140957231' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326140957231' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326140957231';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326141011191' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326141011191' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326141011191';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326141011192' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326141011192' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326141011192';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326141011193' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326141011193' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326141011193';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326141022391' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326141022391' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326141022391';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326141022392' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326141022392' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326141022392';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326141023421' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326141023421' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326141023421';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326141029051' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326141029051' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326141029051';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326141030011' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326141030011' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326141030011';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326141039211' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326141039211' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326141039211';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326141043341' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326141043341' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326141043341';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326141110091' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326141110091' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326141110091';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326141134301' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326141134301' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326141134301';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326141143111' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326141143111' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326141143111';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260514-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260514-0001';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260514-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260514-0002';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260514-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260514-0003';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260514-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260514-0004';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260514-0005' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260514-0005';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260514-0006' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260514-0006';
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-05-15','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2026-04-14';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-05-14';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-05-14';
INSERT INTO tt_barang_saldo (kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_awal,berat_awal_asli,stock_awal,berat_akhir,berat_akhir_asli,stock_akhir) SELECT kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_akhir,berat_akhir_asli,stock_akhir,berat_akhir,berat_akhir_asli,stock_akhir FROM tt_barang_saldo WHERE tanggal='2026-05-14' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-05-14';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-05-14';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-05-14';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-05-14';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202604 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-04';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-04';
UPDATE tt_barang_saldo SET tanggal= '2026-05-15' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-05-14' 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-260515-0001','D','2026-05-15','15:13:03','SYSTEM','SALDO AWAL','SALDO AWAL','0','5021468000','5021468000');
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-260515-0001','D','2026-05-15','15:13:03','BCA','SALDO AWAL','SALDO AWAL','0','712562000','712562000');
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-260515-0001','D','2026-05-15','15:13:03','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-260515-0001','D','2026-05-15','15:13:03','DLL','SALDO AWAL','SALDO AWAL','0','0','0');
UPDATE tp_system SET tgl_system='2026-05-15';