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 ('F326140805131','input','1',' MEF3E X UB','TOKO','PM-F','F3E-YKBB-205-0','GL X RANTAI HOLLOW P4 SLEP UB 8K ','','4.230','1','100.00','4420000','0','0','15000','4420000','0','0','0','4420000','FIT','00378354','F3E','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-09-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-YKBB-205-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.230',berat_jual_asli=berat_jual_asli+'4.230',stock_jual='1',berat_akhir=berat_akhir-'4.230',berat_akhir_asli=berat_akhir_asli-'4.230',stock_akhir='0' WHERE tanggal='2026-09-14' AND kode_barang='F3E-YKBB-205-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 ('F326140805131','2026-09-14','4.230','2026-09-14','08:05:14','PLG0031325','4420000','4420000','0','4420000','4420000','input','2026-09-14 08:05:13','F32614080513');
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-14','F326140805131','2026-09-14','08:05:14','FIT','4420000','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-260914-0002','D','2026-09-14','08:05:14','input','PENJUALAN','F326140805131','7387394000','4420000','7391814000');
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 ('F326140813551','input','1',' MDE1 X CM ','TOKO','PM-E','E1D-ZGBA-183-0','CC X VELG SLEP CM 18 8K ','','1.050','1','100.00','1076000','0','0','15000','1077000','0','0','0','1077000','FIT','00414665','E1D','0','0','-','0','1035000');
UPDATE tm_barang SET tgl_last_jual='2026-09-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-ZGBA-183-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.050',berat_jual_asli=berat_jual_asli+'1.050',stock_jual='1',berat_akhir=berat_akhir-'1.050',berat_akhir_asli=berat_akhir_asli-'1.050',stock_akhir='0' WHERE tanggal='2026-09-14' AND kode_barang='E1D-ZGBA-183-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 ('F326140813551','2026-09-14','1.050','2026-09-14','08:13:56','PLG0031326','1077000','1077000','0','1077000','1077000','input','2026-09-14 08:13:55','F32614081355');
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-14','F326140813551','2026-09-14','08:13:56','FIT','1077000','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-260914-0003','D','2026-09-14','08:13:56','input','PENJUALAN','F326140813551','7391814000','1077000','7392891000');
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-00020194','X-00020194','GL X RANTAI HOLLOW KH 9K','GR','---','F4I','BELI','BELI001','2162000','2026-09-14','2.050','1','kasir','2026-09-14 08:55:52');
DELETE FROM tp_barang WHERE kode_dept = 'X-F4I';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F4I','X-00020194','X-00020194');
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-260914-0001','F326020244111','FIT','1','BELI','BELI001','F4I', 'X-00020194', 'GL X RANTAI HOLLOW KH 9K','2.050','2.050','100.00','2583000','2162000','1054634','1125000','1','2162000','2162000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'2.050',berat_beli_asli=berat_beli_asli+'2.050',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'2.050',berat_akhir_asli=berat_akhir_asli+'2.050',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-09-14' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='F4I' 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-260914-0001','2026-09-14','2026-09-14','08:55:51','FIT','---','2.050','2162000','2162000','2162000','2162000','2162000','kasir','2026-09-14 08:55:52','FB-260914-0001');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260914-0001','AHMAD','BANDAR PACITAN','','','','kasir','2026-09-14 08:55:52');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-09-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-260914-0004','K','2026-09-14','08:55:51','kasir','PEMBELIAN UMUM','FB-260914-0001','7392891000','2162000','7390729000');
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 ('F326140902501','kasir','1',' MFA1F X LG','TOKO','PM-A','A1F-ZHCA-107-0','AT X DAKOCAN ANAK SLEP LG 8K ','','0.310','1','100.00','330000','0','0','15000','330000','0','0','0','330000','LIS','00421395','A1F','0','0','-','0','1065000');
UPDATE tm_barang SET tgl_last_jual='2026-09-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1F-ZHCA-107-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.310',berat_jual_asli=berat_jual_asli+'0.310',stock_jual='1',berat_akhir=berat_akhir-'0.310',berat_akhir_asli=berat_akhir_asli-'0.310',stock_akhir='0' WHERE tanggal='2026-09-14' AND kode_barang='A1F-ZHCA-107-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 ('F326140902501','2026-09-14','0.310','2026-09-14','09:02:50','PLG0031327','330000','330000','0','330000','330000','kasir','2026-09-14 09:02:50','F32614090250');
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-14','F326140902501','2026-09-14','09:02:50','LIS','330000','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-260914-0005','D','2026-09-14','09:02:50','kasir','PENJUALAN','F326140902501','7390729000','330000','7391059000');
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-00020195','X-00020195','GL X RANTAI HOLLOW P4 SLEP KH 8K','GR','---','F3E','BELI','BELI001','3050000','2026-09-14','3.110','1','kasir','2026-09-14 09:05:00');
DELETE FROM tp_barang WHERE kode_dept = 'X-F3E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F3E','X-00020195','X-00020195');
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-260914-0002','F326190824301','FIT','1','BELI','BELI001','F3E', 'X-00020195', 'GL X RANTAI HOLLOW P4 SLEP KH 8K','3.110','3.110','100.00','3453000','3050000','980707','1045000','1','3050000','3050000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'3.110',berat_beli_asli=berat_beli_asli+'3.110',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'3.110',berat_akhir_asli=berat_akhir_asli+'3.110',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-09-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-260914-0002','2026-09-14','2026-09-14','09:05:00','FIT','---','3.110','3050000','3050000','3050000','3050000','3050000','kasir','2026-09-14 09:05:00','FB-260914-0002');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260914-0002','TINI','KENTENG PURWANTORO','','','','kasir','2026-09-14 09:05:00');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-09-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-260914-0006','K','2026-09-14','09:05:00','kasir','PEMBELIAN UMUM','FB-260914-0002','7391059000','3050000','7388009000');
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-00020196','X-00020196','CC X MODEL MATA LG 10 8K','GR','---','E2D','BELI','BELI001','1010000','2026-09-14','1.050','1','kasir','2026-09-14 09:05:29');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2D';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2D','X-00020196','X-00020196');
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-260914-0003','F326201116021','FIT','1','BELI','BELI001','E2D', 'X-00020196', 'CC X MODEL MATA LG 10 8K','1.050','1.050','100.00','1188000','1010000','961905','1035000','1','1010000','1010000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.050',berat_beli_asli=berat_beli_asli+'1.050',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.050',berat_akhir_asli=berat_akhir_asli+'1.050',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-09-14' 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-260914-0003','2026-09-14','2026-09-14','09:05:29','FIT','---','1.050','1010000','1010000','1010000','1010000','1010000','kasir','2026-09-14 09:05:29','FB-260914-0003');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260914-0003','RIRIH','NAWANGAN PACITAN','','','','kasir','2026-09-14 09:05:29');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-09-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-260914-0007','K','2026-09-14','09:05:29','kasir','PEMBELIAN UMUM','FB-260914-0003','7388009000','1010000','7386999000');
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 ('F326140911351','kasir','1',' MDA1D X LG','TOKO','PM-A','A1D-ZHAE-12-0','AT X GYPSY SLEEP LG 8K ','','0.950','1','100.00','983000','0','0','15000','975000','0','0','0','975000','SIN','00419033','A1D','0','0','-','1','1035000');
UPDATE tm_barang SET tgl_last_jual='2026-09-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1D-ZHAE-12-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.950',berat_jual_asli=berat_jual_asli+'0.950',stock_jual='1',berat_akhir=berat_akhir-'0.950',berat_akhir_asli=berat_akhir_asli-'0.950',stock_akhir='0' WHERE tanggal='2026-09-14' AND kode_barang='A1D-ZHAE-12-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 ('F326140911351','2026-09-14','0.950','2026-09-14','09:11:35','PLG0031328','975000','975000','0','975000','975000','kasir','2026-09-14 09:11:35','F32614091135');
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-14','F326140911351','2026-09-14','09:11:35','SIN','975000','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-260914-0008','D','2026-09-14','09:11:35','kasir','PENJUALAN','F326140911351','7386999000','975000','7387974000');
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 ('F326140913071','kasir','1',' MDE1 CM 14','TOKO','PM-E','E1D-XJBD-333-0','CC POLOS CM 14 8K ','','3.000','1','100.00','3075000','0','0','15000','3075000','0','0','0','3075000','AAT','00323625','E1D','0','0','-','0','1035000');
UPDATE tm_barang SET tgl_last_jual='2026-09-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-XJBD-333-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.000',berat_jual_asli=berat_jual_asli+'3.000',stock_jual='1',berat_akhir=berat_akhir-'3.000',berat_akhir_asli=berat_akhir_asli-'3.000',stock_akhir='0' WHERE tanggal='2026-09-14' AND kode_barang='E1D-XJBD-333-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 ('F326140913071','2026-09-14','3.000','2026-09-14','09:13:07','PLG0031329','3075000','3075000','0','3075000','3075000','kasir','2026-09-14 09:13:07','F32614091307');
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-14','F326140913071','2026-09-14','09:13:07','AAT','3075000','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-260914-0009','D','2026-09-14','09:13:07','kasir','PENJUALAN','F326140913071','7387974000','3075000','7391049000');
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 ('F326141022431','kasir','1',' MIH2 X HW ','TOKO','PM-H','H2I-ZGBA-85-0','KL X SANTA HW 42 8K ','','3.050','1','100.00','3431000','0','0','15000','3431000','0','0','0','3431000','SIN','00414567','H2I','0','0','-','0','1125000');
UPDATE tm_barang SET tgl_last_jual='2026-09-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H2I-ZGBA-85-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.050',berat_jual_asli=berat_jual_asli+'3.050',stock_jual='1',berat_akhir=berat_akhir-'3.050',berat_akhir_asli=berat_akhir_asli-'3.050',stock_akhir='0' WHERE tanggal='2026-09-14' AND kode_barang='H2I-ZGBA-85-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 ('F326141022431','2026-09-14','3.050','2026-09-14','10:22:44','PLG0031330','3431000','3431000','0','3431000','3431000','kasir','2026-09-14 10:22:43','F32614102243');
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-14','F326141022431','2026-09-14','10:22:44','SIN','3431000','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-260914-0010','D','2026-09-14','10:22:44','kasir','PENJUALAN','F326141022431','7391049000','3431000','7394480000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='3431000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326141022431' 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 ('F326141022432','kasir',' 1',' MDD2 X LG ','TOKO','PM-D','D2D-ZBAD-120-0','LT X MODEL BOLA MATA LG 8K ','','1.050','1','100.00','1076000','0','0','15000','1076000','0','0','0','1076000','SIN','00389726','D2D','0','0','-','0','1035000');
UPDATE tm_barang SET tgl_last_jual='2026-09-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D2D-ZBAD-120-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.050',berat_jual_asli=berat_jual_asli+'1.050',stock_jual='1',berat_akhir=berat_akhir-'1.050',berat_akhir_asli=berat_akhir_asli-'1.050',stock_akhir='0' WHERE tanggal='2026-09-14' AND kode_barang='D2D-ZBAD-120-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-D' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326141022432','2026-09-14','1.050','2026-09-14','10:22:44','PLG0031331','1076000','1076000','0','1076000','1076000','kasir','2026-09-14 10:22:43','F32614102243');
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-14','F326141022432','2026-09-14','10:22:44','SIN','1076000','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-260914-0011','D','2026-09-14','10:22:44','kasir','PENJUALAN','F326141022432','7394480000','1076000','7395556000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1076000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326141022432' 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 ('F326141022433','kasir',' 1',' MEF1 X TD ','TOKO','PM-F','F1E-ZHBG-17-0','GL X BANGKOK C SLEP TD 60 8K ','','4.980','1','100.00','5204000','0','0','15000','5204000','0','0','0','5204000','SIN','00420683','F1E','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-09-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-ZHBG-17-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.980',berat_jual_asli=berat_jual_asli+'4.980',stock_jual='1',berat_akhir=berat_akhir-'4.980',berat_akhir_asli=berat_akhir_asli-'4.980',stock_akhir='0' WHERE tanggal='2026-09-14' AND kode_barang='F1E-ZHBG-17-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 ('F326141022433','2026-09-14','4.980','2026-09-14','10:22:44','PLG0031332','5204000','5204000','0','5204000','5204000','kasir','2026-09-14 10:22:43','F32614102243');
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-14','F326141022433','2026-09-14','10:22:44','SIN','5204000','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-260914-0012','D','2026-09-14','10:22:44','kasir','PENJUALAN','F326141022433','7395556000','5204000','7400760000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='5204000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326141022433' 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 ('F326141024491','kasir','1',' MEE2 X BM ','TOKO','PM-E','E2E-XJBF-333-0','CC X MODEL MATA BM 18 8K ','','2.670','1','100.00','2790000','0','0','15000','2790000','0','10000','0','2800000','AAT','00324242','E2E','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-09-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-XJBF-333-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.670',berat_jual_asli=berat_jual_asli+'2.670',stock_jual='1',berat_akhir=berat_akhir-'2.670',berat_akhir_asli=berat_akhir_asli-'2.670',stock_akhir='0' WHERE tanggal='2026-09-14' AND kode_barang='E2E-XJBF-333-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 ('F326141024491','2026-09-14','2.670','2026-09-14','10:24:49','PLG0031333','2790000','2790000','10000','2800000','2800000','kasir','2026-09-14 10:24:49','F32614102449');
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-14','F326141024491','2026-09-14','10:24:49','AAT','2800000','10000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260914-0013','D','2026-09-14','10:24:49','kasir','PENJUALAN','F326141024491','7400760000','2800000','7403560000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2800000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326141024491' 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 ('F326141024492','kasir',' 1',' MDE2 X PM ','TOKO','PM-E','E2D-ZDBX-284-0','CC X MODEL MATA PM 22 8K ','','2.000','1','100.00','2050000','0','0','15000','2050000','0','0','0','2050000','AAT','00400221','E2D','0','0','-','0','1035000');
UPDATE tm_barang SET tgl_last_jual='2026-09-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZDBX-284-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-14' AND kode_barang='E2D-ZDBX-284-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 ('F326141024492','2026-09-14','2.000','2026-09-14','10:24:49','PLG0031334','2050000','2050000','0','2050000','2050000','kasir','2026-09-14 10:24:49','F32614102449');
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-14','F326141024492','2026-09-14','10:24:49','AAT','2050000','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-260914-0014','D','2026-09-14','10:24:49','kasir','PENJUALAN','F326141024492','7403560000','2050000','7405610000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2050000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326141024492' 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 ('F326141031171','kasir','1',' MEA1E X LG','TOKO','PM-A','A1E-XHXE-70-0','AT X MODEL KLIP MT CAT LG 8K ','','0.910','1','100.00','951000','0','0','15000','950000','0','0','0','950000','LIS','00310563','A1E','0','0','-','1','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-09-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1E-XHXE-70-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.910',berat_jual_asli=berat_jual_asli+'0.910',stock_jual='1',berat_akhir=berat_akhir-'0.910',berat_akhir_asli=berat_akhir_asli-'0.910',stock_akhir='0' WHERE tanggal='2026-09-14' AND kode_barang='A1E-XHXE-70-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 ('F326141031171','2026-09-14','0.910','2026-09-14','10:31:18','PLG0031335','950000','950000','0','950000','950000','kasir','2026-09-14 10:31:17','F32614103117');
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-14','F326141031171','2026-09-14','10:31:18','LIS','950000','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-260914-0015','D','2026-09-14','10:31:18','kasir','PENJUALAN','F326141031171','7405610000','950000','7406560000');
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 ('F326141032031','kasir','1',' MEF1 X PM ','TOKO','PM-F','F1E-ZCAH-379-0','GL X BANGKOK HOLLOW LASER PM 58 8K ','','8.110','1','100.00','8475000','0','0','15000','8475000','0','0','0','8475000','AAT','00395334','F1E','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-09-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-ZCAH-379-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'8.110',berat_jual_asli=berat_jual_asli+'8.110',stock_jual='1',berat_akhir=berat_akhir-'8.110',berat_akhir_asli=berat_akhir_asli-'8.110',stock_akhir='0' WHERE tanggal='2026-09-14' AND kode_barang='F1E-ZCAH-379-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 ('F326141032031','2026-09-14','8.110','2026-09-14','10:32:03','PLG0031336','8475000','8475000','0','8475000','8475000','kasir','2026-09-14 10:32:03','F32614103203');
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-14','F326141032031','2026-09-14','10:32:03','AAT','8475000','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-260914-0016','D','2026-09-14','10:32:03','kasir','PENJUALAN','F326141032031','7406560000','8475000','7415035000');
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 ('F326141054341','kasir','1',' MDE2 10K C','TOKO','PM-E','E2D-ZGXD-19-0','CC WEDDING MATA CM 18 8K ','','1.530','1','100.00','1568000','0','0','15000','1568000','0','10000','0','1578000','SIN','00412273','E2D','0','0','-','0','1035000');
UPDATE tm_barang SET tgl_last_jual='2026-09-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZGXD-19-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.530',berat_jual_asli=berat_jual_asli+'1.530',stock_jual='1',berat_akhir=berat_akhir-'1.530',berat_akhir_asli=berat_akhir_asli-'1.530',stock_akhir='0' WHERE tanggal='2026-09-14' AND kode_barang='E2D-ZGXD-19-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 ('F326141054341','2026-09-14','1.530','2026-09-14','10:54:35','PLG0031337','1568000','1568000','10000','1578000','1578000','kasir','2026-09-14 10:54:34','F32614105434');
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-14','F326141054341','2026-09-14','10:54:35','SIN','1578000','10000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260914-0017','D','2026-09-14','10:54:35','kasir','PENJUALAN','F326141054341','7415035000','1578000','7416613000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1578000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326141054341' 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 ('F326141054342','kasir',' 1',' MEE2 5K LG','TOKO','PM-E','E2E-ZDXG-227-0','CC ANAK BONEKA CAT MATA VAR LG 8K ','','0.450','1','100.00','470000','0','0','15000','470000','0','5000','0','475000','SIN','00398405','E2E','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-09-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-ZDXG-227-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.450',berat_jual_asli=berat_jual_asli+'0.450',stock_jual='1',berat_akhir=berat_akhir-'0.450',berat_akhir_asli=berat_akhir_asli-'0.450',stock_akhir='0' WHERE tanggal='2026-09-14' AND kode_barang='E2E-ZDXG-227-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 ('F326141054342','2026-09-14','0.450','2026-09-14','10:54:35','PLG0031338','470000','470000','5000','475000','475000','kasir','2026-09-14 10:54:34','F32614105434');
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-14','F326141054342','2026-09-14','10:54:35','SIN','475000','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-260914-0018','D','2026-09-14','10:54:35','kasir','PENJUALAN','F326141054342','7416613000','475000','7417088000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='475000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326141054342' 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-00020197','X-00020197','AT X BONEKA ANAK CAT CM 8K','GR','---','A1E','BELI','BELI001','420000','2026-09-14','0.440','1','kasir','2026-09-14 10:57:31');
DELETE FROM tp_barang WHERE kode_dept = 'X-A1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-A1E','X-00020197','X-00020197');
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-260914-0004','F326010857241','LIS','1','BELI','BELI001','A1E', 'X-00020197', 'AT X BONEKA ANAK CAT CM 8K','0.440','0.440','100.00','458000','420000','954545','1045000','1','420000','420000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.440',berat_beli_asli=berat_beli_asli+'0.440',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.440',berat_akhir_asli=berat_akhir_asli+'0.440',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-09-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-260914-0004','2026-09-14','2026-09-14','10:57:30','LIS','---','0.440','420000','420000','420000','420000','420000','kasir','2026-09-14 10:57:31','FB-260914-0004');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260914-0004','KALISTA','NGANDONG KEPYAR','','','','kasir','2026-09-14 10:57:31');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-09-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-260914-0019','K','2026-09-14','10:57:30','kasir','PEMBELIAN UMUM','FB-260914-0004','7417088000','420000','7416668000');
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-00020198','X-00020198','CC XXX BANGKOK SLEP BW 12 8K','GR','---','E1E','BELI','BELI001','600000','2026-09-14','0.600','1','kasir','2026-09-14 10:57:49');
DELETE FROM tp_barang WHERE kode_dept = 'X-E1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E1E','X-00020198','X-00020198');
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-260914-0005','F326040913271','FIT','1','BELI','BELI001','E1E', 'X-00020198', 'CC XXX BANGKOK SLEP BW 12 8K','0.600','0.600','100.00','730000','600000','1000000','1045000','1','600000','600000','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-14' 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-260914-0005','2026-09-14','2026-09-14','10:57:48','FIT','---','0.600','600000','600000','600000','600000','600000','kasir','2026-09-14 10:57:49','FB-260914-0005');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260914-0005','DARSI','SENDANG','','','','kasir','2026-09-14 10:57:49');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-09-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-260914-0020','K','2026-09-14','10:57:48','kasir','PEMBELIAN UMUM','FB-260914-0005','7416668000','600000','7416068000');
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-00020199','X-00020199','AT X CLIP BONEKA ANAK CAT SLEP LG 8K','GR','---','A1D','BELI','BELI001','990000','2026-09-14','1.030','1','kasir','2026-09-14 10:58:05');
DELETE FROM tp_barang WHERE kode_dept = 'X-A1D';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-A1D','X-00020199','X-00020199');
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-260914-0006','F326110227372','LIS','1','BELI','BELI001','A1D', 'X-00020199', 'AT X CLIP BONEKA ANAK CAT SLEP LG 8K','1.030','1.030','100.00','1102000','990000','961165','1035000','1','990000','990000','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-09-14' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='A1D' 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-260914-0006','2026-09-14','2026-09-14','10:58:05','LIS','---','1.030','990000','990000','990000','990000','990000','kasir','2026-09-14 10:58:05','FB-260914-0006');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260914-0006','ETI','TALESAN PURWANTORO','','','082232554000','kasir','2026-09-14 10:58:05');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-09-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-260914-0021','K','2026-09-14','10:58:05','kasir','PEMBELIAN UMUM','FB-260914-0006','7416068000','990000','7415078000');
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-00020200','X-00020200','GL SANTA DAUN SERUT YT 8K','GR','---','F3E','BELI','BELI001','2250000','2026-09-14','2.320','1','kasir','2026-09-14 11:36:12');
DELETE FROM tp_barang WHERE kode_dept = 'X-F3E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F3E','X-00020200','X-00020200');
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-260914-0007','F326021240112','LIS','1','BELI','BELI001','F3E', 'X-00020200', 'GL SANTA DAUN SERUT YT 8K','2.320','2.320','100.00','2565000','2250000','969828','1045000','1','2250000','2250000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'2.320',berat_beli_asli=berat_beli_asli+'2.320',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'2.320',berat_akhir_asli=berat_akhir_asli+'2.320',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-09-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-260914-0007','2026-09-14','2026-09-14','11:36:12','LIS','---','2.320','2250000','2250000','2250000','2250000','2250000','kasir','2026-09-14 11:36:12','FB-260914-0007');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260914-0007','WIDI','BLIMBING PURWANTORO','','','','kasir','2026-09-14 11:36:12');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-09-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-260914-0022','K','2026-09-14','11:36:12','kasir','PEMBELIAN UMUM','FB-260914-0007','7415078000','2250000','7412828000');
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-00020201','X-00020201','GL XX OVALC SLEP YT 52 8K','GR','---','F1E','BELI','BELI001','4110000','2026-09-14','4.100','1','kasir','2026-09-14 11:36:36');
DELETE FROM tp_barang WHERE kode_dept = 'X-F1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F1E','X-00020201','X-00020201');
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-260914-0008','F326310232471','SIN','1','BELI','BELI001','F1E', 'X-00020201', 'GL XX OVALC SLEP YT 52 8K','4.100','4.100','100.00','4960000','4110000','1002439','1045000','1','4110000','4110000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'4.100',berat_beli_asli=berat_beli_asli+'4.100',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'4.100',berat_akhir_asli=berat_akhir_asli+'4.100',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-09-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-260914-0008','2026-09-14','2026-09-14','11:36:36','SIN','---','4.100','4110000','4110000','4110000','4110000','4110000','kasir','2026-09-14 11:36:36','FB-260914-0008');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260914-0008','ERNA','BULUKERTO','','','082224101332','kasir','2026-09-14 11:36:36');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-09-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-260914-0023','K','2026-09-14','11:36:36','kasir','PEMBELIAN UMUM','FB-260914-0008','7412828000','4110000','7408718000');
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 ('F326141159051','kasir','1',' MDA1D X UB','TOKO','PM-A','A1D-ZCAI-105-0','AT X ITALY SLEP VAR UB 8K ','','0.850','1','100.00','871000','0','0','15000','872000','0','0','0','872000','LIS','00395501','A1D','0','0','-','0','1035000');
UPDATE tm_barang SET tgl_last_jual='2026-09-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1D-ZCAI-105-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.850',berat_jual_asli=berat_jual_asli+'0.850',stock_jual='1',berat_akhir=berat_akhir-'0.850',berat_akhir_asli=berat_akhir_asli-'0.850',stock_akhir='0' WHERE tanggal='2026-09-14' AND kode_barang='A1D-ZCAI-105-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 ('F326141159051','2026-09-14','0.850','2026-09-14','11:59:05','PLG0031339','872000','872000','0','872000','872000','kasir','2026-09-14 11:59:05','F32614115905');
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-14','F326141159051','2026-09-14','11:59:05','LIS','872000','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-260914-0024','D','2026-09-14','11:59:05','kasir','PENJUALAN','F326141159051','7408718000','872000','7409590000');
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 ('F326141234081','kasir','1',' MFE1 KH 18','TOKO','PM-E','E1F-ZIXI-94-0','CC BUNGA CLOVER SLEP KH 18 8K ','','0.350','1','100.00','373000','0','0','15000','373000','0','0','0','373000','LIS','00422632','E1F','0','0','-','0','1065000');
UPDATE tm_barang SET tgl_last_jual='2026-09-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1F-ZIXI-94-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.350',berat_jual_asli=berat_jual_asli+'0.350',stock_jual='1',berat_akhir=berat_akhir-'0.350',berat_akhir_asli=berat_akhir_asli-'0.350',stock_akhir='0' WHERE tanggal='2026-09-14' AND kode_barang='E1F-ZIXI-94-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 ('F326141234081','2026-09-14','0.350','2026-09-14','12:34:08','PLG0031340','373000','373000','0','373000','373000','kasir','2026-09-14 12:34:08','F32614123408');
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-14','F326141234081','2026-09-14','12:34:08','LIS','373000','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-260914-0025','D','2026-09-14','12:34:08','kasir','PENJUALAN','F326141234081','7409590000','373000','7409963000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='373000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326141234081' 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 ('F326141234082','kasir',' 1',' MEF3 HW ','TOKO','PM-F','F3E-ZCAH-392-0','GL SANTA SERUT BUNGA CLOVER SLEP HW 8K ','','1.740','1','100.00','1818000','0','0','15000','1818000','0','0','0','1818000','LIS','00395347','F3E','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-09-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZCAH-392-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.740',berat_jual_asli=berat_jual_asli+'1.740',stock_jual='1',berat_akhir=berat_akhir-'1.740',berat_akhir_asli=berat_akhir_asli-'1.740',stock_akhir='0' WHERE tanggal='2026-09-14' AND kode_barang='F3E-ZCAH-392-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 ('F326141234082','2026-09-14','1.740','2026-09-14','12:34:08','PLG0031341','1818000','1818000','0','1818000','1818000','kasir','2026-09-14 12:34:08','F32614123408');
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-14','F326141234082','2026-09-14','12:34:08','LIS','1818000','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-260914-0026','D','2026-09-14','12:34:08','kasir','PENJUALAN','F326141234082','7409963000','1818000','7411781000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1818000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326141234082' 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 ('F326141240321','kasir','1',' MDE1 X OR ','TOKO','PM-E','E1D-ZCCA-170-0','CC X VELG POLOS OR 10 8K ','','1.370','1','100.00','1404000','0','0','15000','1405000','0','0','0','1405000','FIT','00397393','E1D','0','0','-','0','1035000');
UPDATE tm_barang SET tgl_last_jual='2026-09-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-ZCCA-170-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.370',berat_jual_asli=berat_jual_asli+'1.370',stock_jual='1',berat_akhir=berat_akhir-'1.370',berat_akhir_asli=berat_akhir_asli-'1.370',stock_akhir='0' WHERE tanggal='2026-09-14' AND kode_barang='E1D-ZCCA-170-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 ('F326141240321','2026-09-14','1.370','2026-09-14','12:40:32','PLG0031342','1405000','1405000','0','1405000','1405000','kasir','2026-09-14 12:40:32','F32614124032');
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-14','F326141240321','2026-09-14','12:40:32','FIT','1405000','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-260914-0027','D','2026-09-14','12:40:32','kasir','PENJUALAN','F326141240321','7411781000','1405000','7413186000');
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 ('F326141241391','kasir','1',' TFA1 X UB ','TOKO','PT-A','A1TF-WLAB-10-T','AT X HATI ARESO ANAK UB ','','0.510','1','100.00','989000','0','0','15000','990000','0','0','0','990000','SIN','T0051697','A1TF','0','0','-','0','1940000');
UPDATE tm_barang SET tgl_last_jual='2026-09-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1TF-WLAB-10-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.510',berat_jual_asli=berat_jual_asli+'0.510',stock_jual='1',berat_akhir=berat_akhir-'0.510',berat_akhir_asli=berat_akhir_asli-'0.510',stock_akhir='0' WHERE tanggal='2026-09-14' AND kode_barang='A1TF-WLAB-10-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PT-A' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326141241391','2026-09-14','0.510','2026-09-14','12:41:40','PLG0031343','990000','990000','0','990000','990000','kasir','2026-09-14 12:41:39','F32614124139');
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-14','F326141241391','2026-09-14','12:41:40','SIN','990000','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-260914-0028','D','2026-09-14','12:41:40','kasir','PENJUALAN','F326141241391','7413186000','990000','7414176000');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326141234082' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326141234082' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326141234082';
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 ('F326140128201','kasir','1',' MEF1 UB D5','TOKO','PM-F','F1E-ZIXI-38-0','GL OVAL MODEL C UB D58 8K ','','2.200','1','100.00','2299000','0','0','15000','2300000','0','0','0','2300000','LIS','00422575','F1E','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-09-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-ZIXI-38-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.200',berat_jual_asli=berat_jual_asli+'2.200',stock_jual='1',berat_akhir=berat_akhir-'2.200',berat_akhir_asli=berat_akhir_asli-'2.200',stock_akhir='0' WHERE tanggal='2026-09-14' AND kode_barang='F1E-ZIXI-38-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 ('F326140128201','2026-09-14','2.200','2026-09-14','13:28:20','PLG0031344','2300000','2300000','0','2300000','2300000','kasir','2026-09-14 13:28:20','F32614012820');
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-14','F326140128201','2026-09-14','13:28:20','LIS','2300000','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-260914-0030','D','2026-09-14','13:28:20','kasir','PENJUALAN','F326140128201','7412358000','2300000','7414658000');
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 ('F326140151271','kasir','1',' MEF1 X CM ','TOKO','PM-F','F1E-ZHBE-19-0','GL X OVAL TINJU DAUN SLEP CM 54 8K','','3.150','1','100.00','3292000','0','0','15000','3290000','0','0','0','3290000','AAT','00420061','F1E','0','0','-','1','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-09-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-ZHBE-19-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.150',berat_jual_asli=berat_jual_asli+'3.150',stock_jual='1',berat_akhir=berat_akhir-'3.150',berat_akhir_asli=berat_akhir_asli-'3.150',stock_akhir='0' WHERE tanggal='2026-09-14' AND kode_barang='F1E-ZHBE-19-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 ('F326140151271','2026-09-14','3.150','2026-09-14','13:51:28','PLG0031345','3290000','3290000','0','3290000','3290000','kasir','2026-09-14 13:51:27','F32614015127');
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-14','F326140151271','2026-09-14','13:51:28','AAT','3290000','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-260914-0031','D','2026-09-14','13:51:28','kasir','PENJUALAN','F326140151271','7414658000','3290000','7417948000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='3290000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326140151271' 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 ('F326140151272','kasir',' 1',' MEE1 LG 14','TOKO','PM-E','E1E-ZGXA-336-0','CC MODEL ISYANA SLEP LG 14 8K ','','0.460','1','100.00','481000','0','0','15000','480000','0','0','0','480000','AAT','00411860','E1E','0','0','-','1','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-09-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZGXA-336-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.460',berat_jual_asli=berat_jual_asli+'0.460',stock_jual='1',berat_akhir=berat_akhir-'0.460',berat_akhir_asli=berat_akhir_asli-'0.460',stock_akhir='0' WHERE tanggal='2026-09-14' AND kode_barang='E1E-ZGXA-336-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 ('F326140151272','2026-09-14','0.460','2026-09-14','13:51:28','PLG0031346','480000','480000','0','480000','480000','kasir','2026-09-14 13:51:27','F32614015127');
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-14','F326140151272','2026-09-14','13:51:28','AAT','480000','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-260914-0032','D','2026-09-14','13:51:28','kasir','PENJUALAN','F326140151272','7417948000','480000','7418428000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='480000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326140151272' 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-00020202','X-00020202','GL X TIFF ARESO VAR HW 8K','GR','---','F3E','BELI','BELI001','1690000','2026-09-14','1.820','1','kasir','2026-09-14 13:55:34');
DELETE FROM tp_barang WHERE kode_dept = 'X-F3E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F3E','X-00020202','X-00020202');
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-260914-0009','F326241239141','AAT','1','BELI','BELI001','F3E', 'X-00020202', 'GL X TIFF ARESO VAR HW 8K','1.820','1.820','100.00','2275000','1690000','928571','1045000','1','1690000','1690000','RUSAK');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.820',berat_beli_asli=berat_beli_asli+'1.820',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.820',berat_akhir_asli=berat_akhir_asli+'1.820',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-09-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-260914-0009','2026-09-14','2026-09-14','13:55:33','AAT','---','1.820','1690000','1690000','1690000','1690000','1690000','kasir','2026-09-14 13:55:34','FB-260914-0009');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260914-0009','SUJILAH','NGROMO NAWANGAN','','','085117440230','kasir','2026-09-14 13:55:34');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-09-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-260914-0033','K','2026-09-14','13:55:33','kasir','PEMBELIAN UMUM','FB-260914-0009','7418428000','1690000','7416738000');
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-00020203','X-00020203','CC X MODEL DAUN SLEP PM 10 8K','GR','---','E1D','BELI','BELI001','962000','2026-09-14','1.000','1','kasir','2026-09-14 13:56:03');
DELETE FROM tp_barang WHERE kode_dept = 'X-E1D';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E1D','X-00020203','X-00020203');
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-260914-0010','F326121049272','SIN','1','BELI','BELI001','E1D', 'X-00020203', 'CC X MODEL DAUN SLEP PM 10 8K','1.000','1.000','100.00','1075000','962000','962000','1035000','1','962000','962000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.000',berat_beli_asli=berat_beli_asli+'1.000',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.000',berat_akhir_asli=berat_akhir_asli+'1.000',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-09-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-260914-0010','2026-09-14','2026-09-14','13:56:02','SIN','---','1.000','962000','962000','962000','962000','962000','kasir','2026-09-14 13:56:03','FB-260914-0010');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260914-0010','SINDY','CRABAK GAMBIRANOM','','','','kasir','2026-09-14 13:56:03');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-09-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-260914-0034','K','2026-09-14','13:56:02','kasir','PEMBELIAN UMUM','FB-260914-0010','7416738000','962000','7415776000');
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-00020204','X-00020204','GL LEMES MODEL DAUN PM 8K','GR','---','F3E','BELI','BELI001','3025000','2026-09-14','3.180','1','kasir','2026-09-14 13:59:54');
DELETE FROM tp_barang WHERE kode_dept = 'X-F3E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F3E','X-00020204','X-00020204');
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-260914-0011','F326200945561','SIN','1','BELI','BELI001','F3E', 'X-00020204', 'GL LEMES MODEL DAUN PM 8K','3.180','3.180','100.00','3290000','3025000','951258','1045000','1','3025000','3025000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'3.180',berat_beli_asli=berat_beli_asli+'3.180',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'3.180',berat_akhir_asli=berat_akhir_asli+'3.180',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-09-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-260914-0011','2026-09-14','2026-09-14','13:59:54','SIN','---','3.180','3025000','3025000','3025000','3025000','3025000','kasir','2026-09-14 13:59:54','FB-260914-0011');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260914-0011','NURUL','NGANDONG KEPYAR','','','088220245260','kasir','2026-09-14 13:59:54');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-09-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-260914-0035','K','2026-09-14','13:59:54','kasir','PEMBELIAN UMUM','FB-260914-0011','7415776000','3025000','7412751000');
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-00020205','X-00020205','CC X MODEL CAT MATA CM 16 8K','GR','---','E2D','BELI','BELI001','990000','2026-09-14','1.030','1','kasir','2026-09-14 13:59:54');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2D';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2D','X-00020205','X-00020205');
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-260914-0012','F326230143391','SIN','2','BELI','BELI001','E2D', 'X-00020205', 'CC X MODEL CAT MATA CM 16 8K','1.030','1.030','100.00','1097000','990000','961165','1035000','1','990000','990000','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-09-14' 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-260914-0012','2026-09-14','2026-09-14','13:59:54','SIN','---','1.030','990000','990000','990000','990000','990000','kasir','2026-09-14 13:59:54','FB-260914-0011');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260914-0012','NURUL','NGANDONG KEPYAR','','','088220245260','kasir','2026-09-14 13:59:54');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-09-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-260914-0036','K','2026-09-14','13:59:54','kasir','PEMBELIAN UMUM','FB-260914-0012','7412751000','990000','7411761000');
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 ('F326140210561','kasir','1',' MDE2 X CM ','TOKO','PM-E','E2D-ZIAX-72-0','CC X WEDDING MATA CM 14 8K ','','1.050','1','100.00','1076000','0','0','15000','1076000','0','0','0','1076000','SIN','00422876','E2D','0','0','-','0','1035000');
UPDATE tm_barang SET tgl_last_jual='2026-09-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZIAX-72-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.050',berat_jual_asli=berat_jual_asli+'1.050',stock_jual='1',berat_akhir=berat_akhir-'1.050',berat_akhir_asli=berat_akhir_asli-'1.050',stock_akhir='0' WHERE tanggal='2026-09-14' AND kode_barang='E2D-ZIAX-72-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 ('F326140210561','2026-09-14','1.050','2026-09-14','14:10:57','PLG0031347','1076000','1076000','0','1076000','1076000','kasir','2026-09-14 14:10:56','F32614021056');
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-14','F326140210561','2026-09-14','14:10:57','SIN','1076000','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-260914-0037','D','2026-09-14','14:10:57','kasir','PENJUALAN','F326140210561','7411761000','1076000','7412837000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1076000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326140210561' 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 ('F326140210562','kasir',' 1',' MEF3 HW ','TOKO','PM-F','F3E-ZIXI-52-0','GL FLIK MODEL COLVER ARESO VAR HW 8K ','','1.920','1','100.00','2006000','0','0','15000','2006000','0','0','0','2006000','SIN','00422589','F3E','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-09-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZIXI-52-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-14' AND kode_barang='F3E-ZIXI-52-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 ('F326140210562','2026-09-14','1.920','2026-09-14','14:10:57','PLG0031348','2006000','2006000','0','2006000','2006000','kasir','2026-09-14 14:10:56','F32614021056');
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-14','F326140210562','2026-09-14','14:10:57','SIN','2006000','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-260914-0038','D','2026-09-14','14:10:57','kasir','PENJUALAN','F326140210562','7412837000','2006000','7414843000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2006000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326140210562' 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 ('F326140210563','kasir',' 1',' MJH2 X UB ','TOKO','PM-H','H2J-ZHBE-27-0','KL X GUCCI UB 44 9K ','','2.050','1','100.00','2347000','0','0','15000','2347000','0','0','0','2347000','SIN','00420069','H2J','0','0','-','0','1145000');
UPDATE tm_barang SET tgl_last_jual='2026-09-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H2J-ZHBE-27-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.050',berat_jual_asli=berat_jual_asli+'2.050',stock_jual='1',berat_akhir=berat_akhir-'2.050',berat_akhir_asli=berat_akhir_asli-'2.050',stock_akhir='0' WHERE tanggal='2026-09-14' AND kode_barang='H2J-ZHBE-27-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 ('F326140210563','2026-09-14','2.050','2026-09-14','14:10:57','PLG0031349','2347000','2347000','0','2347000','2347000','kasir','2026-09-14 14:10:56','F32614021056');
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-14','F326140210563','2026-09-14','14:10:57','SIN','2347000','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-260914-0039','D','2026-09-14','14:10:57','kasir','PENJUALAN','F326140210563','7414843000','2347000','7417190000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2347000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326140210563' 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-00020206','X-00020206','CC ANAK BONEKA CAT MATA LG 8K','GR','---','E2E','BELI','BELI001','465000','2026-09-14','0.480','1','kasir','2026-09-14 14:50:28');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2E','X-00020206','X-00020206');
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-260914-0013','F326120138291','LIS','1','BELI','BELI001','E2E', 'X-00020206', 'CC ANAK BONEKA CAT MATA LG 8K','0.480','0.480','100.00','565000','465000','968750','1045000','1','465000','465000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.480',berat_beli_asli=berat_beli_asli+'0.480',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.480',berat_akhir_asli=berat_akhir_asli+'0.480',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-09-14' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E2E' 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-260914-0013','2026-09-14','2026-09-14','14:50:28','LIS','---','0.480','465000','465000','465000','465000','465000','kasir','2026-09-14 14:50:28','FB-260914-0013');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260914-0013','RATNA','TENGGER PUHPELEM','','','','kasir','2026-09-14 14:50:28');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-09-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-260914-0040','K','2026-09-14','14:50:28','kasir','PEMBELIAN UMUM','FB-260914-0013','7417190000','465000','7416725000');
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 ('F326140315261','kasir','1',' MEF2E UB 5','TOKO','PM-F','F2E-ZHXE-306-0','GL OVAL MODEL MATA SLEP UB 56 8K ','','3.350','1','100.00','3501000','0','0','15000','3501000','0','0','0','3501000','SIN','00417075','F2E','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-09-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F2E-ZHXE-306-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.350',berat_jual_asli=berat_jual_asli+'3.350',stock_jual='1',berat_akhir=berat_akhir-'3.350',berat_akhir_asli=berat_akhir_asli-'3.350',stock_akhir='0' WHERE tanggal='2026-09-14' AND kode_barang='F2E-ZHXE-306-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 ('F326140315261','2026-09-14','3.350','2026-09-14','15:15:26','PLG0031350','3501000','3501000','0','3501000','3501000','kasir','2026-09-14 15:15:26','F32614031526');
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-14','F326140315261','2026-09-14','15:15:26','SIN','3501000','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-260914-0041','D','2026-09-14','15:15:26','kasir','PENJUALAN','F326140315261','7416725000','3501000','7420226000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='3501000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326140315261' 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 ('F326140315262','kasir',' 1',' MDE2 X LG ','TOKO','PM-E','E2D-ZHXA-258-0','CC X MODEL PENITI 2RING MATA LG 10 8K ','','2.220','1','100.00','2275000','0','0','15000','2275000','0','0','0','2275000','SIN','00416556','E2D','0','0','-','0','1035000');
UPDATE tm_barang SET tgl_last_jual='2026-09-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZHXA-258-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.220',berat_jual_asli=berat_jual_asli+'2.220',stock_jual='1',berat_akhir=berat_akhir-'2.220',berat_akhir_asli=berat_akhir_asli-'2.220',stock_akhir='0' WHERE tanggal='2026-09-14' AND kode_barang='E2D-ZHXA-258-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 ('F326140315262','2026-09-14','2.220','2026-09-14','15:15:26','PLG0031351','2275000','2275000','0','2275000','2275000','kasir','2026-09-14 15:15:26','F32614031526');
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-14','F326140315262','2026-09-14','15:15:26','SIN','2275000','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-260914-0042','D','2026-09-14','15:15:26','kasir','PENJUALAN','F326140315262','7420226000','2275000','7422501000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2275000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326140315262' 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 ('F326140315263','kasir',' 1',' MDA1D X UB','TOKO','PM-A','A1D-ZEBG-208-0','AT X HUGGIES HATI VAR UB 8K ','','1.470','1','100.00','1507000','0','0','15000','1507000','0','0','0','1507000','SIN','00405207','A1D','0','0','-','0','1035000');
UPDATE tm_barang SET tgl_last_jual='2026-09-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1D-ZEBG-208-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.470',berat_jual_asli=berat_jual_asli+'1.470',stock_jual='1',berat_akhir=berat_akhir-'1.470',berat_akhir_asli=berat_akhir_asli-'1.470',stock_akhir='0' WHERE tanggal='2026-09-14' AND kode_barang='A1D-ZEBG-208-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 ('F326140315263','2026-09-14','1.470','2026-09-14','15:15:26','PLG0031352','1507000','1507000','0','1507000','1507000','kasir','2026-09-14 15:15:26','F32614031526');
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-14','F326140315263','2026-09-14','15:15:26','SIN','1507000','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-260914-0043','D','2026-09-14','15:15:26','kasir','PENJUALAN','F326140315263','7422501000','1507000','7424008000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1507000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326140315263' 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 ('F326140315264','kasir',' 1',' MEH1 KH 44','TOKO','PM-H','H1E-ZGBC-279-0','KL SIEM COBRA KH 44 8K ','','2.050','1','100.00','2142000','0','0','15000','2142000','0','0','0','2142000','SIN','00415352','H1E','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-09-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZGBC-279-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.050',berat_jual_asli=berat_jual_asli+'2.050',stock_jual='1',berat_akhir=berat_akhir-'2.050',berat_akhir_asli=berat_akhir_asli-'2.050',stock_akhir='0' WHERE tanggal='2026-09-14' AND kode_barang='H1E-ZGBC-279-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 ('F326140315264','2026-09-14','2.050','2026-09-14','15:15:26','PLG0031353','2142000','2142000','0','2142000','2142000','kasir','2026-09-14 15:15:26','F32614031526');
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-14','F326140315264','2026-09-14','15:15:26','SIN','2142000','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-260914-0044','D','2026-09-14','15:15:26','kasir','PENJUALAN','F326140315264','7424008000','2142000','7426150000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2142000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326140315264' 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 ('F326140315265','kasir',' 1',' MDD1D CM ','TOKO','PM-D','D1D-ZHBA-210-0','LT MODEL SLEP CM 8K ','','0.930','1','100.00','953000','0','0','15000','953000','0','0','0','953000','SIN','00419789','D1D','0','0','-','0','1035000');
UPDATE tm_barang SET tgl_last_jual='2026-09-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1D-ZHBA-210-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.930',berat_jual_asli=berat_jual_asli+'0.930',stock_jual='1',berat_akhir=berat_akhir-'0.930',berat_akhir_asli=berat_akhir_asli-'0.930',stock_akhir='0' WHERE tanggal='2026-09-14' AND kode_barang='D1D-ZHBA-210-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-D' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326140315265','2026-09-14','0.930','2026-09-14','15:15:26','PLG0031354','953000','953000','0','953000','953000','kasir','2026-09-14 15:15:26','F32614031526');
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-14','F326140315265','2026-09-14','15:15:26','SIN','953000','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-260914-0045','D','2026-09-14','15:15:26','kasir','PENJUALAN','F326140315265','7426150000','953000','7427103000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='953000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326140315265' LIMIT 1;
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260914-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260914-0001';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260914-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260914-0002';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260914-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260914-0003';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260914-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260914-0004';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260914-0005' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260914-0005';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260914-0006' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260914-0006';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260914-0007' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260914-0007';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260914-0008' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260914-0008';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260914-0009' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260914-0009';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260914-0010' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260914-0010';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260914-0011' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260914-0011';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260914-0012' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260914-0012';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260914-0013' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260914-0013';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326140128201' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326140128201' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326140128201';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326140151271' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326140151271' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326140151271';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326140151272' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326140151272' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326140151272';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326140210561' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326140210561' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326140210561';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326140210562' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326140210562' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326140210562';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326140210563' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326140210563' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326140210563';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326140315261' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326140315261' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326140315261';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326140315262' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326140315262' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326140315262';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326140315263' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326140315263' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326140315263';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326140315264' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326140315264' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326140315264';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326140315265' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326140315265' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326140315265';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326140805131' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326140805131' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326140805131';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326140813551' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326140813551' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326140813551';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326140902501' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326140902501' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326140902501';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326140911351' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326140911351' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326140911351';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326140913071' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326140913071' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326140913071';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326141022431' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326141022431' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326141022431';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326141022432' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326141022432' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326141022432';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326141022433' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326141022433' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326141022433';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326141024491' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326141024491' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326141024491';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326141024492' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326141024492' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326141024492';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326141031171' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326141031171' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326141031171';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326141032031' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326141032031' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326141032031';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326141054341' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326141054341' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326141054341';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326141054342' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326141054342' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326141054342';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326141159051' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326141159051' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326141159051';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326141234081' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326141234081' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326141234081';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326141240321' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326141240321' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326141240321';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326141241391' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326141241391' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326141241391';
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-09-15','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2026-08-15';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-09-14';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-09-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-09-14' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-09-14';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-09-14';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-09-14';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-09-14';
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-15' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-09-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-260915-0001','D','2026-09-15','15:24:58','SYSTEM','SALDO AWAL','SALDO AWAL','0','7427103000','7427103000');
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-260915-0001','D','2026-09-15','15:24:58','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-260915-0001','D','2026-09-15','15:24:58','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-260915-0001','D','2026-09-15','15:24:58','BCA','SALDO AWAL','SALDO AWAL','0','740659000','740659000');
UPDATE tp_system SET tgl_system='2026-09-15';