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 ('F326200935561','input','1',' MDE1 X CM ','TOKO','PM-E','E1D-ZGXA-145-0','CC X MODEL SLEP CM 18 8K ','','1.450','1','100.00','1498000','0','0','15000','1498000','0','0','0','1498000','FIT','00411669','E1D','0','0','-','0','1043000');
UPDATE tm_barang SET tgl_last_jual='2026-09-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-ZGXA-145-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.450',berat_jual_asli=berat_jual_asli+'1.450',stock_jual='1',berat_akhir=berat_akhir-'1.450',berat_akhir_asli=berat_akhir_asli-'1.450',stock_akhir='0' WHERE tanggal='2026-09-20' AND kode_barang='E1D-ZGXA-145-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 ('F326200935561','2026-09-20','1.450','2026-09-20','09:35:56','PLG0031437','1498000','1498000','0','1498000','1498000','input','2026-09-20 09:35:56','F32620093556');
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-09-20','F326200935561','2026-09-20','09:35:56','FIT','1498000','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-260920-0002','D','2026-09-20','09:35:56','input','PENJUALAN','F326200935561','7503486000','1498000','7504984000');
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 ('F326200945401','input','1',' MDE2 X OR ','TOKO','PM-E','E2D-ZFXI-30-0','CC X MODEL MATA OR 12 8K ','','0.960','1','100.00','992000','0','0','15000','992000','0','0','0','992000','FIT','00408097','E2D','0','0','-','0','1043000');
UPDATE tm_barang SET tgl_last_jual='2026-09-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZFXI-30-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-09-20' AND kode_barang='E2D-ZFXI-30-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 ('F326200945401','2026-09-20','0.960','2026-09-20','09:45:41','PLG0031438','992000','992000','0','992000','992000','input','2026-09-20 09:45:40','F32620094540');
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-09-20','F326200945401','2026-09-20','09:45:41','FIT','992000','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-260920-0003','D','2026-09-20','09:45:41','input','PENJUALAN','F326200945401','7504984000','992000','7505976000');
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 ('F326200953241','input','1',' MDE1 XX UB','TOKO','PM-E','E1D-ZEBH-279-0','CC XX MODEL SPECTRA HITAM UB 12 8K ','','1.210','1','100.00','1250000','0','0','15000','1215000','0','0','0','1215000','AAT','00405497','E1D','0','0','-','1','1043000');
UPDATE tm_barang SET tgl_last_jual='2026-09-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-ZEBH-279-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.210',berat_jual_asli=berat_jual_asli+'1.210',stock_jual='1',berat_akhir=berat_akhir-'1.210',berat_akhir_asli=berat_akhir_asli-'1.210',stock_akhir='0' WHERE tanggal='2026-09-20' AND kode_barang='E1D-ZEBH-279-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 ('F326200953241','2026-09-20','1.210','2026-09-20','09:53:24','PLG0031439','1215000','1215000','0','1215000','1215000','input','2026-09-20 09:53:24','F32620095324');
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-09-20','F326200953241','2026-09-20','09:53:24','AAT','1215000','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-260920-0004','D','2026-09-20','09:53:24','input','PENJUALAN','F326200953241','7505976000','1215000','7507191000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1215000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326200953241' 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 ('F326200953242','input',' 1',' MEE1 X LG ','TOKO','PM-E','E1E-ZGXI-347-0','CC X MODEL DAUN SLEP LG 12 8K ','','0.470','1','100.00','495000','0','0','15000','495000','0','0','0','495000','AAT','00413066','E1E','0','0','-','0','1063000');
UPDATE tm_barang SET tgl_last_jual='2026-09-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZGXI-347-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.470',berat_jual_asli=berat_jual_asli+'0.470',stock_jual='1',berat_akhir=berat_akhir-'0.470',berat_akhir_asli=berat_akhir_asli-'0.470',stock_akhir='0' WHERE tanggal='2026-09-20' AND kode_barang='E1E-ZGXI-347-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 ('F326200953242','2026-09-20','0.470','2026-09-20','09:53:24','PLG0031440','495000','495000','0','495000','495000','input','2026-09-20 09:53:24','F32620095324');
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-09-20','F326200953242','2026-09-20','09:53:24','AAT','495000','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-260920-0005','D','2026-09-20','09:53:24','input','PENJUALAN','F326200953242','7507191000','495000','7507686000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='495000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326200953242' 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 ('F326201003071','input','1',' MEF3 X UB ','TOKO','PM-F','F3E-YBBF-69-0','GL X TIFF BONEKA ANAK CAT VAR UB 8K ','','1.830','1','100.00','1927000','0','0','15000','1928000','0','0','0','1928000','FIT','00340461','F3E','0','0','-','0','1063000');
UPDATE tm_barang SET tgl_last_jual='2026-09-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-YBBF-69-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.830',berat_jual_asli=berat_jual_asli+'1.830',stock_jual='1',berat_akhir=berat_akhir-'1.830',berat_akhir_asli=berat_akhir_asli-'1.830',stock_akhir='0' WHERE tanggal='2026-09-20' AND kode_barang='F3E-YBBF-69-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 ('F326201003071','2026-09-20','1.830','2026-09-20','10:03:07','PLG0031441','1928000','1928000','0','1928000','1928000','input','2026-09-20 10:03:07','F32620100307');
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-09-20','F326201003071','2026-09-20','10:03:07','FIT','1928000','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-260920-0006','D','2026-09-20','10:03:07','input','PENJUALAN','F326201003071','7507686000','1928000','7509614000');
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 ('F326201011091','input','1',' MDE2 LG 16','TOKO','PM-E','E2D-ZEXF-135-0','CC MODEL MATA VAR LG 16 8K ','','1.030','1','100.00','1064000','0','0','15000','1065000','0','0','0','1065000','LIS','00402520','E2D','0','0','-','0','1043000');
UPDATE tm_barang SET tgl_last_jual='2026-09-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZEXF-135-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-09-20' AND kode_barang='E2D-ZEXF-135-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 ('F326201011091','2026-09-20','1.030','2026-09-20','10:11:09','PLG0031442','1065000','1065000','0','1065000','1065000','input','2026-09-20 10:11:09','F32620101109');
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-09-20','F326201011091','2026-09-20','10:11:09','LIS','1065000','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-260920-0007','D','2026-09-20','10:11:09','input','PENJUALAN','F326201011091','7509614000','1065000','7510679000');
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 ('F326201020001','input','1',' MDA1D X HW','TOKO','PM-A','A1D-ZIAI-138-0','AT X ITALY SLEP VAR HW 8K ','','1.110','1','100.00','1158000','0','0','15000','1147000','0','0','0','1147000','SIN','00424360','A1D','0','0','-','1','1043000');
UPDATE tm_barang SET tgl_last_jual='2026-09-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1D-ZIAI-138-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.110',berat_jual_asli=berat_jual_asli+'1.110',stock_jual='1',berat_akhir=berat_akhir-'1.110',berat_akhir_asli=berat_akhir_asli-'1.110',stock_akhir='0' WHERE tanggal='2026-09-20' AND kode_barang='A1D-ZIAI-138-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 ('F326201020001','2026-09-20','1.110','2026-09-20','10:20:00','PLG0031443','1147000','1147000','0','1147000','1147000','input','2026-09-20 10:20:00','F32620102000');
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-09-20','F326201020001','2026-09-20','10:20:00','SIN','1147000','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-260920-0008','D','2026-09-20','10:20:00','input','PENJUALAN','F326201020001','7510679000','1147000','7511826000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1147000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326201020001' 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 ('F326201020002','input',' 1',' MEF1 X LG ','TOKO','PM-F','F1E-ZIAI-131-0','GL X OVAL TINJU ARESO SLEP LG 52 8K ','','1.920','1','100.00','2041000','0','0','15000','2022000','0','0','0','2022000','SIN','00424353','F1E','0','0','-','1','1063000');
UPDATE tm_barang SET tgl_last_jual='2026-09-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-ZIAI-131-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.920',berat_jual_asli=berat_jual_asli+'1.920',stock_jual='1',berat_akhir=berat_akhir-'1.920',berat_akhir_asli=berat_akhir_asli-'1.920',stock_akhir='0' WHERE tanggal='2026-09-20' AND kode_barang='F1E-ZIAI-131-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 ('F326201020002','2026-09-20','1.920','2026-09-20','10:20:00','PLG0031444','2022000','2022000','0','2022000','2022000','input','2026-09-20 10:20:00','F32620102000');
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-09-20','F326201020002','2026-09-20','10:20:00','SIN','2022000','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-260920-0009','D','2026-09-20','10:20:00','input','PENJUALAN','F326201020002','7511826000','2022000','7513848000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2022000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326201020002' 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 ('F326201055261','input','1',' MDE2D 10K ','TOKO','PM-E','E2D-ZEBH-116-T','CC WEDDING MATA SLEP CM 16 8K ','','1.560','1','100.00','1612000','0','0','15000','1612000','0','10000','0','1622000','LIS','T0080057','E2D','0','0','-','0','1043000');
UPDATE tm_barang SET tgl_last_jual='2026-09-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZEBH-116-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.560',berat_jual_asli=berat_jual_asli+'1.560',stock_jual='1',berat_akhir=berat_akhir-'1.560',berat_akhir_asli=berat_akhir_asli-'1.560',stock_akhir='0' WHERE tanggal='2026-09-20' AND kode_barang='E2D-ZEBH-116-T' 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 ('F326201055261','2026-09-20','1.560','2026-09-20','10:55:26','PLG0031445','1612000','1612000','10000','1622000','1622000','input','2026-09-20 10:55:26','F32620105526');
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-09-20','F326201055261','2026-09-20','10:55:26','LIS','1622000','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-260920-0010','D','2026-09-20','10:55:26','input','PENJUALAN','F326201055261','7513848000','1622000','7515470000');
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 ('F326201117591','input','1',' TEH1 HW 42','TOKO','PT-H','H1TE-ZGAG-67-T','KL SANTA HW 42 17K ','','2.010','1','100.00','3920000','0','0','15000','3900000','0','0','0','3900000','SIN','T0081290','H1TE','0','0','-','1','1930000');
UPDATE tm_barang SET tgl_last_jual='2026-09-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1TE-ZGAG-67-T' 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-09-20' AND kode_barang='H1TE-ZGAG-67-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PT-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 ('F326201117591','2026-09-20','2.010','2026-09-20','11:17:59','PLG0031446','3900000','3900000','0','3900000','3900000','input','2026-09-20 11:17:59','F32620111759');
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-09-20','F326201117591','2026-09-20','11:17:59','SIN','3900000','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-260920-0011','D','2026-09-20','11:17:59','input','PENJUALAN','F326201117591','7515470000','3900000','7519370000');
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 ('F326201124111','input','1',' MJH2 X KH ','TOKO','PM-H','H2J-ZGXI-131-0','KL X MILANO KH 44 9K ','','4.870','1','100.00','5615000','0','0','15000','5567000','0','0','0','5567000','FIT','00412850','H2J','0','0','-','1','1153000');
UPDATE tm_barang SET tgl_last_jual='2026-09-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H2J-ZGXI-131-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.870',berat_jual_asli=berat_jual_asli+'4.870',stock_jual='1',berat_akhir=berat_akhir-'4.870',berat_akhir_asli=berat_akhir_asli-'4.870',stock_akhir='0' WHERE tanggal='2026-09-20' AND kode_barang='H2J-ZGXI-131-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 ('F326201124111','2026-09-20','4.870','2026-09-20','11:24:12','PLG0031447','5567000','5567000','0','5567000','5567000','input','2026-09-20 11:24:11','F32620112411');
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-09-20','F326201124111','2026-09-20','11:24:12','FIT','5567000','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-260920-0012','D','2026-09-20','11:24:12','input','PENJUALAN','F326201124111','7519370000','5567000','7524937000');
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 ('F326201125581','input','1',' MDE1 CM 24','TOKO','PM-E','E1D-ZGBC-261-0','CC VELG POLOS CM 24 8K ','','1.950','1','100.00','2014000','0','0','15000','2015000','0','0','0','2015000','AAT','00415334','E1D','0','0','-','0','1043000');
UPDATE tm_barang SET tgl_last_jual='2026-09-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-ZGBC-261-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.950',berat_jual_asli=berat_jual_asli+'1.950',stock_jual='1',berat_akhir=berat_akhir-'1.950',berat_akhir_asli=berat_akhir_asli-'1.950',stock_akhir='0' WHERE tanggal='2026-09-20' AND kode_barang='E1D-ZGBC-261-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 ('F326201125581','2026-09-20','1.950','2026-09-20','11:25:59','PLG0031448','2015000','2015000','0','2015000','2015000','input','2026-09-20 11:25:58','F32620112558');
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-09-20','F326201125581','2026-09-20','11:25:59','AAT','2015000','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-260920-0013','D','2026-09-20','11:25:59','input','PENJUALAN','F326201125581','7524937000','2015000','7526952000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2015000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326201125581' 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 ('F326201125582','input',' 1',' MDA1D X PM','TOKO','PM-A','A1D-YGBF-5-0','AT X BANGKOK KLIP SLEP PM 8K ','','1.080','1','100.00','1116000','0','0','15000','1115000','0','0','0','1115000','AAT','00362661','A1D','0','0','-','1','1043000');
UPDATE tm_barang SET tgl_last_jual='2026-09-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1D-YGBF-5-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-09-20' AND kode_barang='A1D-YGBF-5-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 ('F326201125582','2026-09-20','1.080','2026-09-20','11:25:59','PLG0031449','1115000','1115000','0','1115000','1115000','input','2026-09-20 11:25:58','F32620112558');
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-09-20','F326201125582','2026-09-20','11:25:59','AAT','1115000','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-260920-0014','D','2026-09-20','11:25:59','input','PENJUALAN','F326201125582','7526952000','1115000','7528067000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1115000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326201125582' 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 ('F326201129041','input','1',' MIF4I X HW','TOKO','PM-F','F4I-YLAE-89-0','GL X KOREA SLEP HW 9K ','','2.000','1','100.00','2266000','0','0','15000','2266000','0','0','0','2266000','LIS','00381067','F4I','0','0','-','0','1133000');
UPDATE tm_barang SET tgl_last_jual='2026-09-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F4I-YLAE-89-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-09-20' AND kode_barang='F4I-YLAE-89-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 ('F326201129041','2026-09-20','2.000','2026-09-20','11:29:04','PLG0031450','2266000','2266000','0','2266000','2266000','input','2026-09-20 11:29:04','F32620112904');
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-09-20','F326201129041','2026-09-20','11:29:04','LIS','2266000','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-260920-0015','D','2026-09-20','11:29:04','input','PENJUALAN','F326201129041','7528067000','2266000','7530333000');
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 ('F326201130431','input','1',' MEA1E UB ','TOKO','PM-A','A1E-ZHXF-342-0','AT HUGGIES C SLEP UB 8K ','','0.650','1','100.00','684000','0','0','15000','685000','0','0','0','685000','SIN','00417400','A1E','0','0','-','0','1063000');
UPDATE tm_barang SET tgl_last_jual='2026-09-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1E-ZHXF-342-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.650',berat_jual_asli=berat_jual_asli+'0.650',stock_jual='1',berat_akhir=berat_akhir-'0.650',berat_akhir_asli=berat_akhir_asli-'0.650',stock_akhir='0' WHERE tanggal='2026-09-20' AND kode_barang='A1E-ZHXF-342-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 ('F326201130431','2026-09-20','0.650','2026-09-20','11:30:44','PLG0031451','685000','685000','0','685000','685000','input','2026-09-20 11:30:43','F32620113043');
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-09-20','F326201130431','2026-09-20','11:30:44','SIN','685000','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-260920-0016','D','2026-09-20','11:30:44','input','PENJUALAN','F326201130431','7530333000','685000','7531018000');
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-00020255','X-00020255','KL KADAR 8K','GR','---','H1E','BELI','BELI001','2940000','2026-09-20','3.950','1','kasir','2026-09-20 11:46:04');
DELETE FROM tp_barang WHERE kode_dept = 'X-H1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-H1E','X-00020255','X-00020255');
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-260920-0001','F323261103561','FIT','1','BELI','BELI001','H1E', 'X-00020255', 'KL KADAR 8K','3.980','3.950','100.00','1803000','2940000','744304','1063000','1','2940000','2940000','RUSAK');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'3.950',berat_beli_asli=berat_beli_asli+'3.950',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'3.950',berat_akhir_asli=berat_akhir_asli+'3.950',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-09-20' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='H1E' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-260920-0001','2026-09-20','2026-09-20','11:46:03','FIT','---','3.950','2940000','2940000','2940000','2940000','2940000','kasir','2026-09-20 11:46:04','FB-260920-0001');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260920-0001','ERNA','SIDOWAYAH PLOSO','','','','kasir','2026-09-20 11:46:04');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-09-20' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-260920-0017','K','2026-09-20','11:46:03','kasir','PEMBELIAN UMUM','FB-260920-0001','7531018000','2940000','7528078000');
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-00020256','X-00020256','GL X RANTAI HOLLOW P4 SLEP LT 17K','GR','---','F3TE','BELI','BELI001','12322000','2026-09-20','7.850','1','kasir','2026-09-20 11:46:40');
DELETE FROM tp_barang WHERE kode_dept = 'X-F3TE';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F3TE','X-00020256','X-00020256');
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-260920-0002','F324191038282','FIT','1','BELI','BELI001','F3TE', 'X-00020256', 'GL X RANTAI HOLLOW P4 SLEP LT 17K','7.850','7.850','100.00','8125000','12322000','1569682','1930000','1','12322000','12322000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'7.850',berat_beli_asli=berat_beli_asli+'7.850',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'7.850',berat_akhir_asli=berat_akhir_asli+'7.850',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-09-20' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='F3TE' 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-260920-0002','2026-09-20','2026-09-20','11:46:39','FIT','---','7.850','12322000','12322000','12322000','12322000','12322000','kasir','2026-09-20 11:46:40','FB-260920-0002');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260920-0002','NUR AISYAH','BENDO BAKALAN','','','085329927285','kasir','2026-09-20 11:46:40');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-09-20' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-260920-0018','K','2026-09-20','11:46:39','kasir','PEMBELIAN UMUM','FB-260920-0002','7528078000','12322000','7515756000');
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-00020257','X-00020257','CC X MODEL CAT MATA LG 12 8K','GR','---','E2D','BELI','BELI001','1037000','2026-09-20','1.070','1','kasir','2026-09-20 11:47:02');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2D';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2D','X-00020257','X-00020257');
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-260920-0003','F326161058241','AAT','1','BELI','BELI001','E2D', 'X-00020257', 'CC X MODEL CAT MATA LG 12 8K','1.070','1.070','100.00','1136000','1037000','969159','1043000','1','1037000','1037000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.070',berat_beli_asli=berat_beli_asli+'1.070',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.070',berat_akhir_asli=berat_akhir_asli+'1.070',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-09-20' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E2D' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-260920-0003','2026-09-20','2026-09-20','11:47:02','AAT','---','1.070','1037000','1037000','1037000','1037000','1037000','kasir','2026-09-20 11:47:02','FB-260920-0003');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260920-0003','JANIS','KISMANTORO','','','0815607367','kasir','2026-09-20 11:47:02');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-09-20' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-260920-0019','K','2026-09-20','11:47:02','kasir','PEMBELIAN UMUM','FB-260920-0003','7515756000','1037000','7514719000');
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-00020258','X-00020258','CC X VELG C SLEP CM 19','GR','---','E1D','BELI','BELI001','935000','2026-09-20','0.980','1','kasir','2026-09-20 11:47:23');
DELETE FROM tp_barang WHERE kode_dept = 'X-E1D';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E1D','X-00020258','X-00020258');
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-260920-0004','F326100906151','FIT','1','BELI','BELI001','E1D', 'X-00020258', 'CC X VELG C SLEP CM 19','0.980','0.980','100.00','1005000','935000','954082','1043000','1','935000','935000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.980',berat_beli_asli=berat_beli_asli+'0.980',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.980',berat_akhir_asli=berat_akhir_asli+'0.980',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-09-20' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E1D' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-260920-0004','2026-09-20','2026-09-20','11:47:22','FIT','---','0.980','935000','935000','935000','935000','935000','kasir','2026-09-20 11:47:23','FB-260920-0004');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260920-0004','AYUK','KEPYAR','','','','kasir','2026-09-20 11:47:23');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-09-20' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-260920-0020','K','2026-09-20','11:47:22','kasir','PEMBELIAN UMUM','FB-260920-0004','7514719000','935000','7513784000');
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-00020259','X-00020259','CC COR MODEL SPECTRA SLEP 14 KH 8K','GR','---','E1F','BELI','BELI001','350000','2026-09-20','0.360','1','kasir','2026-09-20 11:52:40');
DELETE FROM tp_barang WHERE kode_dept = 'X-E1F';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E1F','X-00020259','X-00020259');
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-260920-0005','F326140930521','SIN','1','BELI','BELI001','E1F', 'X-00020259', 'CC COR MODEL SPECTRA SLEP 14 KH 8K','0.360','0.360','100.00','395000','350000','972222','1073000','1','350000','350000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.360',berat_beli_asli=berat_beli_asli+'0.360',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.360',berat_akhir_asli=berat_akhir_asli+'0.360',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-09-20' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E1F' 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-260920-0005','2026-09-20','2026-09-20','11:52:40','SIN','---','0.360','350000','350000','350000','350000','350000','kasir','2026-09-20 11:52:40','FB-260920-0005');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260920-0005','ARJUNA','KISMANTORO','','','','kasir','2026-09-20 11:52:40');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-09-20' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-260920-0021','K','2026-09-20','11:52:40','kasir','PEMBELIAN UMUM','FB-260920-0005','7513784000','350000','7513434000');
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 ('F326201159581','kasir','1',' MEE2 KH 20','TOKO','PM-E','E2E-ZIAE-289-0','CC MODEL SNAKE MATA VAR KH 20 8K ','','0.480','1','100.00','505000','0','0','15000','505000','0','0','0','505000','LIS','00423825','E2E','0','0','-','0','1063000');
UPDATE tm_barang SET tgl_last_jual='2026-09-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-ZIAE-289-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.480',berat_jual_asli=berat_jual_asli+'0.480',stock_jual='1',berat_akhir=berat_akhir-'0.480',berat_akhir_asli=berat_akhir_asli-'0.480',stock_akhir='0' WHERE tanggal='2026-09-20' AND kode_barang='E2E-ZIAE-289-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 ('F326201159581','2026-09-20','0.480','2026-09-20','11:59:59','PLG0031452','505000','505000','0','505000','505000','kasir','2026-09-20 11:59:58','F32620115958');
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-09-20','F326201159581','2026-09-20','11:59:59','LIS','505000','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-260920-0022','D','2026-09-20','11:59:59','kasir','PENJUALAN','F326201159581','7513434000','505000','7513939000');
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 ('F326201201091','kasir','1',' MDE2 CM 20','TOKO','PM-E','E2D-ZFXF-80-0','CC WEDDING MATA CM 20 8K ','','0.880','1','100.00','909000','0','0','15000','910000','0','0','0','910000','LIS','00407609','E2D','0','0','-','0','1043000');
UPDATE tm_barang SET tgl_last_jual='2026-09-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZFXF-80-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.880',berat_jual_asli=berat_jual_asli+'0.880',stock_jual='1',berat_akhir=berat_akhir-'0.880',berat_akhir_asli=berat_akhir_asli-'0.880',stock_akhir='0' WHERE tanggal='2026-09-20' AND kode_barang='E2D-ZFXF-80-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 ('F326201201091','2026-09-20','0.880','2026-09-20','12:01:09','PLG0031453','910000','910000','0','910000','910000','kasir','2026-09-20 12:01:09','F32620120109');
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-09-20','F326201201091','2026-09-20','12:01:09','LIS','910000','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-260920-0023','D','2026-09-20','12:01:09','kasir','PENJUALAN','F326201201091','7513939000','910000','7514849000');
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 ('F326201210351','kasir','1',' MEB1E X LG','TOKO','PM-B','B1E-ZEXI-74-0','GW X TIFF MATA LG 8K ','','0.550','1','100.00','579000','0','0','15000','580000','0','0','0','580000','LIS','00402895','B1E','0','0','-','0','1063000');
UPDATE tm_barang SET tgl_last_jual='2026-09-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1E-ZEXI-74-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.550',berat_jual_asli=berat_jual_asli+'0.550',stock_jual='1',berat_akhir=berat_akhir-'0.550',berat_akhir_asli=berat_akhir_asli-'0.550',stock_akhir='0' WHERE tanggal='2026-09-20' AND kode_barang='B1E-ZEXI-74-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 ('F326201210351','2026-09-20','0.550','2026-09-20','12:10:36','PLG0031454','580000','580000','0','580000','580000','kasir','2026-09-20 12:10:35','F32620121035');
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-09-20','F326201210351','2026-09-20','12:10:36','LIS','580000','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-260920-0024','D','2026-09-20','12:10:36','kasir','PENJUALAN','F326201210351','7514849000','580000','7515429000');
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-00020260','X-00020260','GW X MODEL MATA CM PE','GR','---','B1E','BELI','BELI001','507000','2026-09-20','0.730','1','kasir','2026-09-20 12:33:50');
DELETE FROM tp_barang WHERE kode_dept = 'X-B1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-B1E','X-00020260','X-00020260');
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-260920-0006','F325050129351','LIS','1','BELI','BELI001','B1E', 'X-00020260', 'GW X MODEL MATA CM PE','0.730','0.730','100.00','645000','507000','694521','1063000','1','507000','507000','RUSAK');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.730',berat_beli_asli=berat_beli_asli+'0.730',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.730',berat_akhir_asli=berat_akhir_asli+'0.730',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-09-20' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='B1E' 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-260920-0006','2026-09-20','2026-09-20','12:33:49','LIS','---','0.730','507000','507000','507000','507000','507000','kasir','2026-09-20 12:33:50','FB-260920-0006');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260920-0006','SEPTYA','SUKOMANGU','','','','kasir','2026-09-20 12:33:50');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-09-20' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-260920-0025','K','2026-09-20','12:33:49','kasir','PEMBELIAN UMUM','FB-260920-0006','7515429000','507000','7514922000');
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 ('F326201238101','kasir','1',' MEF3E X KH','TOKO','PM-F','F3E-YLBI-176-0','GL X SANTA PREMIER SERUT KH 8K ','','2.210','1','100.00','2327000','0','0','15000','2328000','0','0','0','2328000','AAT','00383328','F3E','0','0','-','0','1063000');
UPDATE tm_barang SET tgl_last_jual='2026-09-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-YLBI-176-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.210',berat_jual_asli=berat_jual_asli+'2.210',stock_jual='1',berat_akhir=berat_akhir-'2.210',berat_akhir_asli=berat_akhir_asli-'2.210',stock_akhir='0' WHERE tanggal='2026-09-20' AND kode_barang='F3E-YLBI-176-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 ('F326201238101','2026-09-20','2.210','2026-09-20','12:38:11','PLG0031455','2328000','2328000','0','2328000','2328000','kasir','2026-09-20 12:38:10','F32620123810');
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-09-20','F326201238101','2026-09-20','12:38:11','AAT','2328000','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-260920-0026','D','2026-09-20','12:38:11','kasir','PENJUALAN','F326201238101','7514922000','2328000','7517250000');
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-00020261','X-00020261','AT X COR MODEL ITALY VAR UB 17K','GR','---','A1TD','BELI','BELI001','2340000','2026-09-20','1.310','1','kasir','2026-09-20 12:51:13');
DELETE FROM tp_barang WHERE kode_dept = 'X-A1TD';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-A1TD','X-00020261','X-00020261');
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-260920-0007','F326310924131','AAT','1','BELI','BELI001','A1TD', 'X-00020261', 'AT X COR MODEL ITALY VAR UB 17K','1.310','1.310','100.00','2633000','2340000','1786260','1920000','1','2340000','2340000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.310',berat_beli_asli=berat_beli_asli+'1.310',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.310',berat_akhir_asli=berat_akhir_asli+'1.310',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-09-20' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='A1TD' 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-260920-0007','2026-09-20','2026-09-20','12:51:12','AAT','---','1.310','2340000','2340000','2340000','2340000','2340000','kasir','2026-09-20 12:51:13','FB-260920-0007');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260920-0007','IKA ROSITASARI','SUMBER BITING','','','087782861922','kasir','2026-09-20 12:51:13');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-09-20' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-260920-0027','K','2026-09-20','12:51:12','kasir','PEMBELIAN UMUM','FB-260920-0007','7517250000','2340000','7514910000');
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 ('F326200156371','kasir','1',' MDE2 X PM ','TOKO','PM-E','E2D-ZGAG-101-0','CC X MODEL MATA PM 6 8K ','','0.900','1','100.00','930000','0','0','15000','930000','0','0','0','930000','AAT','00413937','E2D','0','0','-','0','1043000');
UPDATE tm_barang SET tgl_last_jual='2026-09-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZGAG-101-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.900',berat_jual_asli=berat_jual_asli+'0.900',stock_jual='1',berat_akhir=berat_akhir-'0.900',berat_akhir_asli=berat_akhir_asli-'0.900',stock_akhir='0' WHERE tanggal='2026-09-20' AND kode_barang='E2D-ZGAG-101-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 ('F326200156371','2026-09-20','0.900','2026-09-20','13:56:37','PLG0031456','930000','930000','0','930000','930000','kasir','2026-09-20 13:56:37','F32620015637');
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-09-20','F326200156371','2026-09-20','13:56:37','AAT','930000','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-260920-0028','D','2026-09-20','13:56:37','kasir','PENJUALAN','F326200156371','7514910000','930000','7515840000');
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-00020262','X-00020262','CC X MODEL MATA LG 16 8K','GR','---','E2D','BELI','BELI001','865000','2026-09-20','0.960','1','kasir','2026-09-20 14:22:01');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2D';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2D','X-00020262','X-00020262');
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-260920-0008','F325090234461','SIN','1','BELI','BELI001','E2D', 'X-00020262', 'CC X MODEL MATA LG 16 8K','0.960','0.960','100.00','931000','865000','901042','1043000','1','865000','865000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.960',berat_beli_asli=berat_beli_asli+'0.960',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.960',berat_akhir_asli=berat_akhir_asli+'0.960',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-09-20' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E2D' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-260920-0008','2026-09-20','2026-09-20','14:22:01','SIN','---','0.960','865000','865000','865000','865000','865000','kasir','2026-09-20 14:22:01','FB-260920-0008');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260920-0008','ANGEL','KENTHENG 3/8 PULUTAN','','','','kasir','2026-09-20 14:22:01');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-09-20' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-260920-0029','K','2026-09-20','14:22:01','kasir','PEMBELIAN UMUM','FB-260920-0008','7515840000','865000','7514975000');
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-00020263','X-00020263','CC X MODEL MATA UB 16 8K','GR','---','E2D','BELI','BELI001','1092000','2026-09-20','1.210','1','kasir','2026-09-20 14:22:01');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2D';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2D','X-00020263','X-00020263');
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-260920-0009','F325090236211','SIN','2','BELI','BELI001','E2D', 'X-00020263', 'CC X MODEL MATA UB 16 8K','1.210','1.210','100.00','1175000','1092000','902479','1043000','1','1092000','1092000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.210',berat_beli_asli=berat_beli_asli+'1.210',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.210',berat_akhir_asli=berat_akhir_asli+'1.210',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-09-20' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E2D' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-260920-0009','2026-09-20','2026-09-20','14:22:01','SIN','---','1.210','1092000','1092000','1092000','1092000','1092000','kasir','2026-09-20 14:22:01','FB-260920-0008');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260920-0009','ANGEL','KENTHENG 3/8 PULUTAN','','','','kasir','2026-09-20 14:22:01');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-09-20' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-260920-0030','K','2026-09-20','14:22:01','kasir','PEMBELIAN UMUM','FB-260920-0009','7514975000','1092000','7513883000');
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 ('F326200223031','kasir','1',' MDE1 X YS ','TOKO','PM-E','E1D-ZHXC-59-0','CC X VELG KACA SLEP YS 10 8K ','','0.980','1','100.00','1012000','0','0','15000','1013000','0','0','0','1013000','AAT','00416757','E1D','0','0','-','0','1043000');
UPDATE tm_barang SET tgl_last_jual='2026-09-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-ZHXC-59-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.980',berat_jual_asli=berat_jual_asli+'0.980',stock_jual='1',berat_akhir=berat_akhir-'0.980',berat_akhir_asli=berat_akhir_asli-'0.980',stock_akhir='0' WHERE tanggal='2026-09-20' AND kode_barang='E1D-ZHXC-59-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 ('F326200223031','2026-09-20','0.980','2026-09-20','14:23:04','PLG0031457','1013000','1013000','0','1013000','1013000','kasir','2026-09-20 14:23:03','F32620022303');
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-09-20','F326200223031','2026-09-20','14:23:04','AAT','1013000','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-260920-0031','D','2026-09-20','14:23:04','kasir','PENJUALAN','F326200223031','7513883000','1013000','7514896000');
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 ('F326200223511','kasir','1',' MEF3E HW ','TOKO','PM-F','F3E-ZGBX-188-0','GL RANTAI HOLLOW CASTELI SLEP VAR HW 8K ','','1.750','1','100.00','1843000','0','0','15000','1843000','0','0','0','1843000','SIN','00414389','F3E','0','0','-','0','1063000');
UPDATE tm_barang SET tgl_last_jual='2026-09-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZGBX-188-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.750',berat_jual_asli=berat_jual_asli+'1.750',stock_jual='1',berat_akhir=berat_akhir-'1.750',berat_akhir_asli=berat_akhir_asli-'1.750',stock_akhir='0' WHERE tanggal='2026-09-20' AND kode_barang='F3E-ZGBX-188-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 ('F326200223511','2026-09-20','1.750','2026-09-20','14:23:51','PLG0031458','1843000','1843000','0','1843000','1843000','kasir','2026-09-20 14:23:51','F32620022351');
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-09-20','F326200223511','2026-09-20','14:23:51','SIN','1843000','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-260920-0032','D','2026-09-20','14:23:51','kasir','PENJUALAN','F326200223511','7514896000','1843000','7516739000');
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-00020264','X-00020264','GL X TIFF SPECTRA HITAM VAR YT 8K','GR','---','F3E','BELI','BELI001','745000','2026-09-20','1.110','1','kasir','2026-09-20 14:25:13');
DELETE FROM tp_barang WHERE kode_dept = 'X-F3E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F3E','X-00020264','X-00020264');
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-260920-0010','F326101106511','SIN','1','BELI','BELI001','F3E', 'X-00020264', 'GL X TIFF SPECTRA HITAM VAR YT 8K','1.110','1.110','100.00','1160000','745000','671171','1063000','1','745000','745000','RUSAK');
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-09-20' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='F3E' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-260920-0010','2026-09-20','2026-09-20','14:25:13','SIN','---','1.110','745000','745000','745000','745000','745000','kasir','2026-09-20 14:25:13','FB-260920-0010');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260920-0010','IKE','BULUKERTO','','','','kasir','2026-09-20 14:25:13');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-09-20' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-260920-0033','K','2026-09-20','14:25:13','kasir','PEMBELIAN UMUM','FB-260920-0010','7516739000','745000','7515994000');
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-00020265','X-00020265','CC X BANGKOK SLEP BW 12 8K','GR','---','E1E','BELI','BELI001','580000','2026-09-20','0.600','1','kasir','2026-09-20 14:25:49');
DELETE FROM tp_barang WHERE kode_dept = 'X-E1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E1E','X-00020265','X-00020265');
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-260920-0011','F326031135021','AAT','1','BELI','BELI001','E1E', 'X-00020265', 'CC X BANGKOK SLEP BW 12 8K','0.600','0.600','100.00','625000','580000','966667','1063000','1','580000','580000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.600',berat_beli_asli=berat_beli_asli+'0.600',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.600',berat_akhir_asli=berat_akhir_asli+'0.600',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-09-20' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E1E' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-260920-0011','2026-09-20','2026-09-20','14:25:48','AAT','---','0.600','580000','580000','580000','580000','580000','kasir','2026-09-20 14:25:49','FB-260920-0011');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260920-0011','HANA','SAWAHAN PLOSO PWO','','','','kasir','2026-09-20 14:25:49');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-09-20' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-260920-0034','K','2026-09-20','14:25:48','kasir','PEMBELIAN UMUM','FB-260920-0011','7515994000','580000','7515414000');
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260920-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260920-0001';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260920-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260920-0002';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260920-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260920-0003';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260920-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260920-0004';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260920-0005' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260920-0005';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260920-0006' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260920-0006';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260920-0007' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260920-0007';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260920-0008' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260920-0008';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260920-0009' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260920-0009';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260920-0010' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260920-0010';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260920-0011' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260920-0011';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326200156371' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326200156371' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326200156371';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326200223031' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326200223031' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326200223031';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326200223511' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326200223511' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326200223511';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326200935561' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326200935561' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326200935561';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326200945401' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326200945401' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326200945401';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326200953241' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326200953241' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326200953241';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326200953242' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326200953242' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326200953242';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326201003071' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326201003071' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326201003071';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326201011091' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326201011091' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326201011091';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326201020001' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326201020001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326201020001';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326201020002' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326201020002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326201020002';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326201055261' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326201055261' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326201055261';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326201117591' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326201117591' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326201117591';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326201124111' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326201124111' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326201124111';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326201125581' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326201125581' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326201125581';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326201125582' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326201125582' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326201125582';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326201129041' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326201129041' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326201129041';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326201130431' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326201130431' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326201130431';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326201159581' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326201159581' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326201159581';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326201201091' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326201201091' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326201201091';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326201210351' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326201210351' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326201210351';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326201238101' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326201238101' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326201238101';
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-09-21','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2026-08-21';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-09-20';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-09-20';
INSERT INTO tt_barang_saldo (kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_awal,berat_awal_asli,stock_awal,berat_akhir,berat_akhir_asli,stock_akhir) SELECT kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_akhir,berat_akhir_asli,stock_akhir,berat_akhir,berat_akhir_asli,stock_akhir FROM tt_barang_saldo WHERE tanggal='2026-09-20' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-09-20';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-09-20';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-09-20';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-09-20';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202608 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-08';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-08';
UPDATE tt_barang_saldo SET tanggal= '2026-09-21' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-09-20' OR stock_akhir*1<0  OR kode_lokasi_gudang='' OR kode_lokasi_toko='' OR status_close='CLOS';
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260921-0001','D','2026-09-21','15:10:27','SYSTEM','SALDO AWAL','SALDO AWAL','0','7515414000','7515414000');
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-260921-0001','D','2026-09-21','15:10:27','DLL','SALDO AWAL','SALDO AWAL','0','0','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260921-0001','D','2026-09-21','15:10:27','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-260921-0001','D','2026-09-21','15:10:27','BCA','SALDO AWAL','SALDO AWAL','0','743627000','743627000');
UPDATE tp_system SET tgl_system='2026-09-21';