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-00020780','X-00020780','CC X MODEL DAUN SLEP UB 18 8K','GR','---','E1D','BELI','BELI001','962000','2026-11-08','1.020','1','kasir','2026-11-08 08:49:30'); DELETE FROM tp_barang WHERE kode_dept = 'X-E1D'; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E1D','X-00020780','X-00020780'); 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-261108-0001','F326301058421','SIN','1','BELI','BELI001','E1D', 'X-00020780', 'CC X MODEL DAUN SLEP UB 18 8K','1.020','1.020','100.00','1112000','962000','943137','1005000','1','962000','962000','CUCI'); UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.020',berat_beli_asli=berat_beli_asli+'1.020',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.020',berat_akhir_asli=berat_akhir_asli+'1.020',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-11-08' 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-261108-0001','2026-11-08','2026-11-08','08:49:29','SIN','---','1.020','962000','962000','962000','962000','962000','kasir','2026-11-08 08:49:30','FB-261108-0001'); INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261108-0001','ENDAH','JATISARI BITING','','','085156843844','kasir','2026-11-08 08:49:30'); SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-11-08' 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-261108-0002','K','2026-11-08','08:49:29','kasir','PEMBELIAN UMUM','FB-261108-0001','8100292000','962000','8099330000'); 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-00020781','X-00020781','KL X KOREA UB 44 9K','GR','---','H2I','BELI','BELI001','3140000','2026-11-08','3.030','1','kasir','2026-11-08 08:56:50'); DELETE FROM tp_barang WHERE kode_dept = 'X-H2I'; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-H2I','X-00020781','X-00020781'); 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-261108-0002','F326111033101','LIS','1','BELI','BELI001','H2I', 'X-00020781', 'KL X KOREA UB 44 9K','3.030','3.030','100.00','3425000','3140000','1036304','1105000','1','3140000','3140000','CUCI'); UPDATE tt_barang_saldo SET berat_beli=berat_beli+'3.030',berat_beli_asli=berat_beli_asli+'3.030',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'3.030',berat_akhir_asli=berat_akhir_asli+'3.030',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-11-08' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='H2I' LIMIT 1; INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-261108-0002','2026-11-08','2026-11-08','08:56:50','LIS','---','3.030','3140000','3140000','3140000','3140000','3140000','kasir','2026-11-08 08:56:50','FB-261108-0002'); INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261108-0002','IBU DINI','KISMANTORO','','','','kasir','2026-11-08 08:56:50'); SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-11-08' 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-261108-0003','K','2026-11-08','08:56:50','kasir','PEMBELIAN UMUM','FB-261108-0002','8099330000','3140000','8096190000'); 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 ('F326080910471','kasir','1',' MEF3E X MT','TOKO','PM-F','F3E-ZJAE-212-0','GL X HARLEY SLEP MT 8K ','','5.050','1','100.00','5176000','0','0','15000','5176000','0','0','0','5176000','SIN','00430095','F3E','0','0','-','0','1045000'); UPDATE tm_barang SET tgl_last_jual='2026-11-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZJAE-212-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'5.050',berat_jual_asli=berat_jual_asli+'5.050',stock_jual='1',berat_akhir=berat_akhir-'5.050',berat_akhir_asli=berat_akhir_asli-'5.050',stock_akhir='0' WHERE tanggal='2026-11-08' AND kode_barang='F3E-ZJAE-212-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 ('F326080910471','2026-11-08','5.050','2026-11-08','09:10:48','PLG0032242','5176000','5176000','0','5176000','5176000','kasir','2026-11-08 09:10:47','F32608091047'); 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-11-08','F326080910471','2026-11-08','09:10:48','SIN','5176000','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-261108-0004','D','2026-11-08','09:10:48','kasir','PENJUALAN','F326080910471','8096190000','5176000','8101366000','OPEN'); UPDATE tt_jual_head SET dibayar_rp='5176000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326080910471' 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 ('F326080910472','kasir',' 1',' MFS1F X UB','TOKO','PM-S','S1F-ZIBF-2-0','AS X EXTENTION UB 8K ','','0.350','1','100.00','366000','0','0','15000','366000','0','0','0','366000','SIN','00425620','S1F','0','0','-','0','1045000'); UPDATE tm_barang SET tgl_last_jual='2026-11-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='S1F-ZIBF-2-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-11-08' AND kode_barang='S1F-ZIBF-2-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-S' 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 ('F326080910472','2026-11-08','0.350','2026-11-08','09:10:48','PLG0032243','366000','366000','0','366000','366000','kasir','2026-11-08 09:10:47','F32608091047'); 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-11-08','F326080910472','2026-11-08','09:10:48','SIN','366000','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-261108-0005','D','2026-11-08','09:10:48','kasir','PENJUALAN','F326080910472','8101366000','366000','8101732000','OPEN'); UPDATE tt_jual_head SET dibayar_rp='366000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326080910472' 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 ('F326080925181','kasir','1',' MEF3E X UB','TOKO','PM-F','F3E-ZKXD-75-0','GL X KREPYAK DAUN SPECTRA SLEP UB 8K ','','4.260','1','100.00','4366000','0','0','15000','4367000','0','0','0','4367000','LIS','00433045','F3E','0','0','-','0','1045000'); UPDATE tm_barang SET tgl_last_jual='2026-11-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZKXD-75-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.260',berat_jual_asli=berat_jual_asli+'4.260',stock_jual='1',berat_akhir=berat_akhir-'4.260',berat_akhir_asli=berat_akhir_asli-'4.260',stock_akhir='0' WHERE tanggal='2026-11-08' AND kode_barang='F3E-ZKXD-75-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 ('F326080925181','2026-11-08','4.260','2026-11-08','09:25:18','PLG0032244','4367000','4367000','0','4367000','4367000','kasir','2026-11-08 09:25:18','F32608092518'); 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-11-08','F326080925181','2026-11-08','09:25:18','LIS','4367000','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-261108-0006','D','2026-11-08','09:25:18','kasir','PENJUALAN','F326080925181','8101732000','4367000','8106099000'); 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 ('F326080932271','kasir','1',' MFE1 KH 18','TOKO','PM-E','E1F-ZJXE-383-0','CC MODEL SPECTRA SLEP KH 18 8K ','','0.380','1','100.00','397000','0','0','15000','398000','0','0','0','398000','SIN','00427874','E1F','0','0','-','0','1045000'); UPDATE tm_barang SET tgl_last_jual='2026-11-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1F-ZJXE-383-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.380',berat_jual_asli=berat_jual_asli+'0.380',stock_jual='1',berat_akhir=berat_akhir-'0.380',berat_akhir_asli=berat_akhir_asli-'0.380',stock_akhir='0' WHERE tanggal='2026-11-08' AND kode_barang='E1F-ZJXE-383-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 ('F326080932271','2026-11-08','0.380','2026-11-08','09:32:27','PLG0032245','398000','398000','0','398000','398000','kasir','2026-11-08 09:32:27','F32608093227'); 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-11-08','F326080932271','2026-11-08','09:32:27','SIN','398000','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-261108-0007','D','2026-11-08','09:32:27','kasir','PENJUALAN','F326080932271','8106099000','398000','8106497000'); 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 ('F326080932591','kasir','1',' MFE1 X KH ','TOKO','PM-E','E1F-ZKXE-220-0','CC X MODEL SPECTRA SLEP KH 10 8K ','','0.360','1','100.00','376000','0','0','15000','376000','0','0','0','376000','SIN','00433567','E1F','0','0','-','0','1045000'); UPDATE tm_barang SET tgl_last_jual='2026-11-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1F-ZKXE-220-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.360',berat_jual_asli=berat_jual_asli+'0.360',stock_jual='1',berat_akhir=berat_akhir-'0.360',berat_akhir_asli=berat_akhir_asli-'0.360',stock_akhir='0' WHERE tanggal='2026-11-08' AND kode_barang='E1F-ZKXE-220-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 ('F326080932591','2026-11-08','0.360','2026-11-08','09:33:00','PLG0032246','376000','376000','0','376000','376000','kasir','2026-11-08 09:32:59','F32608093259'); 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-11-08','F326080932591','2026-11-08','09:33:00','SIN','376000','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-261108-0008','D','2026-11-08','09:33:00','kasir','PENJUALAN','F326080932591','8106497000','376000','8106873000'); 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 ('F326080935231','kasir','1',' MFD1 LG ','TOKO','PM-D','D1F-ZIBF-341-0','LT SLOBOK BUNGA SLEP VAR LG 8K ','','0.330','1','100.00','345000','0','0','15000','345000','0','0','0','345000','LIS','00425959','D1F','0','0','-','0','1045000'); UPDATE tm_barang SET tgl_last_jual='2026-11-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1F-ZIBF-341-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.330',berat_jual_asli=berat_jual_asli+'0.330',stock_jual='1',berat_akhir=berat_akhir-'0.330',berat_akhir_asli=berat_akhir_asli-'0.330',stock_akhir='0' WHERE tanggal='2026-11-08' AND kode_barang='D1F-ZIBF-341-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 ('F326080935231','2026-11-08','0.330','2026-11-08','09:35:24','PLG0032247','345000','345000','0','345000','345000','kasir','2026-11-08 09:35:23','F32608093523'); 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-11-08','F326080935231','2026-11-08','09:35:24','LIS','345000','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-261108-0009','D','2026-11-08','09:35:24','kasir','PENJUALAN','F326080935231','8106873000','345000','8107218000'); 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 ('F326080940131','kasir','1',' MDE2 X CM1','TOKO','PM-E','E2D-ZJXH-135-0','CC X MODEL MATA CM 14 8K ','','1.020','1','100.00','1025000','0','0','15000','1025000','0','0','0','1025000','AAT','00428623','E2D','0','0','-','0','1005000'); UPDATE tm_barang SET tgl_last_jual='2026-11-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZJXH-135-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.020',berat_jual_asli=berat_jual_asli+'1.020',stock_jual='1',berat_akhir=berat_akhir-'1.020',berat_akhir_asli=berat_akhir_asli-'1.020',stock_akhir='0' WHERE tanggal='2026-11-08' AND kode_barang='E2D-ZJXH-135-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-E' AND stock_akhir > 0 LIMIT 1; INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326080940131','2026-11-08','1.020','2026-11-08','09:40:14','PLG0032248','1025000','1025000','0','1025000','1025000','kasir','2026-11-08 09:40:13','F32608094013'); 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-11-08','F326080940131','2026-11-08','09:40:14','AAT','1025000','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-261108-0010','D','2026-11-08','09:40:14','kasir','PENJUALAN','F326080940131','8107218000','1025000','8108243000'); 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-00020782','X-00020782','GL COR T 8K','GR','---','F1F','BELI','BELI001','4620000','2026-11-08','6.170','1','kasir','2026-11-08 09:48:05'); DELETE FROM tp_barang WHERE kode_dept = 'X-F1F'; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F1F','X-00020782','X-00020782'); 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-261108-0003','F321250857101','SIN','1','BELI','BELI001','F1F', 'X-00020782', 'GL COR T 8K','6.170','6.170','100.00','2543000','4620000','748784','1045000','1','4620000','4620000','CUCI'); UPDATE tt_barang_saldo SET berat_beli=berat_beli+'6.170',berat_beli_asli=berat_beli_asli+'6.170',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'6.170',berat_akhir_asli=berat_akhir_asli+'6.170',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-11-08' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='F1F' 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-261108-0003','2026-11-08','2026-11-08','09:48:05','SIN','---','6.170','4620000','4620000','4620000','4620000','4620000','kasir','2026-11-08 09:48:05','FB-261108-0003'); INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261108-0003','PIPIN','BADEGAN','','','','kasir','2026-11-08 09:48:05'); SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-11-08' 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-261108-0011','K','2026-11-08','09:48:05','kasir','PEMBELIAN UMUM','FB-261108-0003','8108243000','4620000','8103623000'); 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-00020783','X-00020783','CC WEDDING MATA CM 18 8K','GR','---','E2D','BELI','BELI001','1382000','2026-11-08','1.480','1','kasir','2026-11-08 09:49:51'); DELETE FROM tp_barang WHERE kode_dept = 'X-E2D'; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2D','X-00020783','X-00020783'); 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-261108-0004','F326171043142','AAT','1','BELI','BELI001','E2D', 'X-00020783', 'CC WEDDING MATA CM 18 8K','1.480','1.480','100.00','1725000','1382000','933784','1005000','1','1382000','1382000','CUCI'); UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.480',berat_beli_asli=berat_beli_asli+'1.480',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.480',berat_akhir_asli=berat_akhir_asli+'1.480',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-11-08' 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-261108-0004','2026-11-08','2026-11-08','09:49:51','AAT','---','1.480','1382000','1382000','1382000','1382000','1382000','kasir','2026-11-08 09:49:51','FB-261108-0004'); INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261108-0004','NOVIA INDRAWATI','NGLONGOP SEDAYU SLH','','','085157111989','kasir','2026-11-08 09:49:51'); SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-11-08' 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-261108-0012','K','2026-11-08','09:49:51','kasir','PEMBELIAN UMUM','FB-261108-0004','8103623000','1382000','8102241000'); 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-00020784','X-00020784','GL XX OVAL C MATA UB 56 8K','GR','---','F1E','BELI','BELI001','4280000','2026-11-08','4.860','1','kasir','2026-11-08 09:49:51'); DELETE FROM tp_barang WHERE kode_dept = 'X-F1E'; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F1E','X-00020784','X-00020784'); 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-261108-0005','F326171043141','AAT','2','BELI','BELI001','F1E', 'X-00020784', 'GL XX OVAL C MATA UB 56 8K','4.860','4.860','100.00','5613000','4280000','880658','1045000','1','4280000','4280000','RUSAK'); UPDATE tt_barang_saldo SET berat_beli=berat_beli+'4.860',berat_beli_asli=berat_beli_asli+'4.860',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'4.860',berat_akhir_asli=berat_akhir_asli+'4.860',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-11-08' 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-261108-0005','2026-11-08','2026-11-08','09:49:51','AAT','---','4.860','4280000','4280000','4280000','4280000','4280000','kasir','2026-11-08 09:49:51','FB-261108-0004'); INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261108-0005','NOVIA INDRAWATI','NGLONGOP SEDAYU SLH','','','085157111989','kasir','2026-11-08 09:49:51'); SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-11-08' 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-261108-0013','K','2026-11-08','09:49:51','kasir','PEMBELIAN UMUM','FB-261108-0005','8102241000','4280000','8097961000'); 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-00020785','X-00020785','KL TRIXIE KUPU MATA VAR LG 8K','GR','---','H1E','BELI','BELI001','782000','2026-11-08','0.990','1','kasir','2026-11-08 09:50:59'); DELETE FROM tp_barang WHERE kode_dept = 'X-H1E'; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-H1E','X-00020785','X-00020785'); 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-261108-0006','F326231118091','SIN','1','BELI','BELI001','H1E', 'X-00020785', 'KL TRIXIE KUPU MATA VAR LG 8K','0.990','0.990','100.00','1043000','782000','789899','1045000','1','782000','782000','RUSAK'); UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.990',berat_beli_asli=berat_beli_asli+'0.990',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.990',berat_akhir_asli=berat_akhir_asli+'0.990',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-11-08' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='H1E' LIMIT 1; INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-261108-0006','2026-11-08','2026-11-08','09:50:59','SIN','---','0.990','782000','782000','782000','782000','782000','kasir','2026-11-08 09:50:59','FB-261108-0006'); INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261108-0006','NITA','KARANGAN','','','','kasir','2026-11-08 09:50:59'); SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-11-08' 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-261108-0014','K','2026-11-08','09:50:59','kasir','PEMBELIAN UMUM','FB-261108-0006','8097961000','782000','8097179000'); 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-00020786','X-00020786','LT COR T 8K','GR','---','D1F','BELI','BELI001','407000','2026-11-08','0.430','1','kasir','2026-11-08 09:52:24'); DELETE FROM tp_barang WHERE kode_dept = 'X-D1F'; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-D1F','X-00020786','X-00020786'); 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-261108-0007','00419290','LIS','1','BELI','BELI001','D1F', 'X-00020786', 'LT COR T 8K','0.430','0.430','100.00','467000','407000','946512','1045000','1','407000','407000','CUCI'); UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.430',berat_beli_asli=berat_beli_asli+'0.430',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.430',berat_akhir_asli=berat_akhir_asli+'0.430',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-11-08' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='D1F' 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-261108-0007','2026-11-08','2026-11-08','09:52:23','LIS','---','0.430','407000','407000','407000','407000','407000','kasir','2026-11-08 09:52:24','FB-261108-0007'); INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261108-0007','PIPIT','SAMPUNG','','','','kasir','2026-11-08 09:52:24'); SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-11-08' 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-261108-0015','K','2026-11-08','09:52:23','kasir','PEMBELIAN UMUM','FB-261108-0007','8097179000','407000','8096772000'); 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 ('F326081009401','kasir','1',' MDA1D X YT','TOKO','PM-A','A1D-ZKXD-214-0','AT X TIFF HATI VAR YT 8K ','','1.200','1','100.00','1206000','0','0','15000','1205000','0','0','0','1205000','AAT','00433184','A1D','0','0','-','1','1005000'); UPDATE tm_barang SET tgl_last_jual='2026-11-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1D-ZKXD-214-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.200',berat_jual_asli=berat_jual_asli+'1.200',stock_jual='1',berat_akhir=berat_akhir-'1.200',berat_akhir_asli=berat_akhir_asli-'1.200',stock_akhir='0' WHERE tanggal='2026-11-08' AND kode_barang='A1D-ZKXD-214-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 ('F326081009401','2026-11-08','1.200','2026-11-08','10:09:40','PLG0032249','1205000','1205000','0','1205000','1205000','kasir','2026-11-08 10:09:40','F32608100940'); 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-11-08','F326081009401','2026-11-08','10:09:40','AAT','1205000','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-261108-0016','D','2026-11-08','10:09:40','kasir','PENJUALAN','F326081009401','8096772000','1205000','8097977000'); 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 ('F326081025391','kasir','1',' MEF3 XXX H','TOKO','PM-F','F3E-ZIBF-270-0','GL XXX CASTELI DAUN SLEP HW 8K ','','1.740','1','100.00','1783000','0','0','15000','1730000','0','0','0','1730000','AAT','00425888','F3E','0','0','-','1','1045000'); UPDATE tm_barang SET tgl_last_jual='2026-11-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZIBF-270-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-11-08' AND kode_barang='F3E-ZIBF-270-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 ('F326081025391','2026-11-08','1.740','2026-11-08','10:25:39','PLG0032250','1730000','1730000','0','1730000','1730000','kasir','2026-11-08 10:25:39','F32608102539'); 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-11-08','F326081025391','2026-11-08','10:25:39','AAT','1730000','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-261108-0017','D','2026-11-08','10:25:39','kasir','PENJUALAN','F326081025391','8097977000','1730000','8099707000'); 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 ('F326081028381','kasir','1',' MDE2 X CM ','TOKO','PM-E','E2D-ZIAX-74-0','CC X WEDDING MATA CM 10 8K','','0.850','1','100.00','854000','0','0','15000','855000','0','0','0','855000','LIS','00422878','E2D','0','0','-','0','1005000'); UPDATE tm_barang SET tgl_last_jual='2026-11-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZIAX-74-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-11-08' AND kode_barang='E2D-ZIAX-74-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 ('F326081028381','2026-11-08','0.850','2026-11-08','10:28:38','PLG0032251','855000','855000','0','855000','855000','kasir','2026-11-08 10:28:38','F32608102838'); 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-11-08','F326081028381','2026-11-08','10:28:38','LIS','855000','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-261108-0018','D','2026-11-08','10:28:38','kasir','PENJUALAN','F326081028381','8099707000','855000','8100562000','OPEN'); UPDATE tt_jual_head SET dibayar_rp='855000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326081028381' 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 ('F326081028382','kasir',' 1',' MDE2 10K C','TOKO','PM-E','E2D-ZIBA-281-0','CC WEDDING MATA SLEP CM 26 8K ','','1.520','1','100.00','1528000','0','0','15000','1528000','0','10000','0','1538000','LIS','00424825','E2D','0','0','-','0','1005000'); UPDATE tm_barang SET tgl_last_jual='2026-11-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZIBA-281-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.520',berat_jual_asli=berat_jual_asli+'1.520',stock_jual='1',berat_akhir=berat_akhir-'1.520',berat_akhir_asli=berat_akhir_asli-'1.520',stock_akhir='0' WHERE tanggal='2026-11-08' AND kode_barang='E2D-ZIBA-281-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 ('F326081028382','2026-11-08','1.520','2026-11-08','10:28:38','PLG0032252','1528000','1528000','10000','1538000','1538000','kasir','2026-11-08 10:28:38','F32608102838'); 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-11-08','F326081028382','2026-11-08','10:28:38','LIS','1538000','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-261108-0019','D','2026-11-08','10:28:38','kasir','PENJUALAN','F326081028382','8100562000','1538000','8102100000','OPEN'); UPDATE tt_jual_head SET dibayar_rp='1538000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326081028382' 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 ('F326081041541','kasir','1',' MDE1 X CM ','TOKO','PM-E','E1D-ZIBE-191-0','CC X WEDDING POLOS CM 14 8K ','','1.510','1','100.00','1518000','0','0','15000','1518000','0','0','0','1518000','SIN','00425566','E1D','0','0','-','0','1005000'); UPDATE tm_barang SET tgl_last_jual='2026-11-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-ZIBE-191-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.510',berat_jual_asli=berat_jual_asli+'1.510',stock_jual='1',berat_akhir=berat_akhir-'1.510',berat_akhir_asli=berat_akhir_asli-'1.510',stock_akhir='0' WHERE tanggal='2026-11-08' AND kode_barang='E1D-ZIBE-191-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 ('F326081041541','2026-11-08','1.510','2026-11-08','10:41:55','PLG0032253','1518000','1518000','0','1518000','1518000','kasir','2026-11-08 10:41:54','F32608104154'); 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-11-08','F326081041541','2026-11-08','10:41:55','SIN','1518000','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-261108-0020','D','2026-11-08','10:41:55','kasir','PENJUALAN','F326081041541','8102100000','1518000','8103618000','OPEN'); UPDATE tt_jual_head SET dibayar_rp='1518000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326081041541' 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 ('F326081041542','kasir',' 1',' MDE2 X CM ','TOKO','PM-E','E2D-ZKXE-123-0','CC X WEDDING MATA CM 16 8K ','','0.900','1','100.00','904000','0','0','15000','904000','0','0','0','904000','SIN','00433470','E2D','0','0','-','0','1005000'); UPDATE tm_barang SET tgl_last_jual='2026-11-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZKXE-123-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.900',berat_jual_asli=berat_jual_asli+'0.900',stock_jual='1',berat_akhir=berat_akhir-'0.900',berat_akhir_asli=berat_akhir_asli-'0.900',stock_akhir='0' WHERE tanggal='2026-11-08' AND kode_barang='E2D-ZKXE-123-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 ('F326081041542','2026-11-08','0.900','2026-11-08','10:41:55','PLG0032254','904000','904000','0','904000','904000','kasir','2026-11-08 10:41:54','F32608104154'); 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-11-08','F326081041542','2026-11-08','10:41:55','SIN','904000','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-261108-0021','D','2026-11-08','10:41:55','kasir','PENJUALAN','F326081041542','8103618000','904000','8104522000','OPEN'); UPDATE tt_jual_head SET dibayar_rp='904000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326081041542' 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 ('F326081041543','kasir',' 1',' MDE2 10K C','TOKO','PM-E','E2D-ZIXI-110-0','CC WEDDING MATA CM 14 8K ','','0.850','1','100.00','854000','0','0','15000','855000','0','10000','0','865000','SIN','00422648','E2D','0','0','-','0','1005000'); UPDATE tm_barang SET tgl_last_jual='2026-11-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZIXI-110-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-11-08' AND kode_barang='E2D-ZIXI-110-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 ('F326081041543','2026-11-08','0.850','2026-11-08','10:41:55','PLG0032255','855000','855000','10000','865000','865000','kasir','2026-11-08 10:41:54','F32608104154'); 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-11-08','F326081041543','2026-11-08','10:41:55','SIN','865000','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-261108-0022','D','2026-11-08','10:41:55','kasir','PENJUALAN','F326081041543','8104522000','865000','8105387000','OPEN'); UPDATE tt_jual_head SET dibayar_rp='865000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326081041543' 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 ('F326081047491','kasir','1',' MEF3E X UB','TOKO','PM-F','F3E-ZKXE-36-0','GL X RANTAI HOLLOW P3 POLOS UB 8K ','','1.170','1','100.00','1211000','0','0','15000','1200000','0','0','0','1200000','LIS','00433383','F3E','0','0','-','1','1045000'); UPDATE tm_barang SET tgl_last_jual='2026-11-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZKXE-36-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.170',berat_jual_asli=berat_jual_asli+'1.170',stock_jual='1',berat_akhir=berat_akhir-'1.170',berat_akhir_asli=berat_akhir_asli-'1.170',stock_akhir='0' WHERE tanggal='2026-11-08' AND kode_barang='F3E-ZKXE-36-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 ('F326081047491','2026-11-08','1.170','2026-11-08','10:47:50','PLG0032256','1200000','1200000','0','1200000','1200000','kasir','2026-11-08 10:47:49','F32608104749'); 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-11-08','F326081047491','2026-11-08','10:47:50','LIS','1200000','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-261108-0023','D','2026-11-08','10:47:50','kasir','PENJUALAN','F326081047491','8105387000','1200000','8106587000'); 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-00020787','X-00020787','LT X MODEL MATA CM 8K','GR','---','D2E','BELI','BELI001','520000','2026-11-08','0.540','1','kasir','2026-11-08 10:52:25'); DELETE FROM tp_barang WHERE kode_dept = 'X-D2E'; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-D2E','X-00020787','X-00020787'); 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-261108-0008','F326210237272','AAT','1','BELI','BELI001','D2E', 'X-00020787', 'LT X MODEL MATA CM 8K','0.540','0.540','100.00','561000','520000','962963','1045000','1','520000','520000','CUCI'); UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.540',berat_beli_asli=berat_beli_asli+'0.540',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.540',berat_akhir_asli=berat_akhir_asli+'0.540',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-11-08' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='D2E' 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-261108-0008','2026-11-08','2026-11-08','10:52:25','AAT','---','0.540','520000','520000','520000','520000','520000','kasir','2026-11-08 10:52:25','FB-261108-0008'); INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261108-0008','NIA','BUGELAN','','','','kasir','2026-11-08 10:52:25'); SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-11-08' 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-261108-0024','K','2026-11-08','10:52:25','kasir','PEMBELIAN UMUM','FB-261108-0008','8106587000','520000','8106067000'); 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-00020788','X-00020788','CC X MODEL MATA UB 12 8K','GR','---','E2D','BELI','BELI001','1265000','2026-11-08','1.340','1','kasir','2026-11-08 10:52:25'); DELETE FROM tp_barang WHERE kode_dept = 'X-E2D'; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2D','X-00020788','X-00020788'); 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-261108-0009','F326100258221','AAT','2','BELI','BELI001','E2D', 'X-00020788', 'CC X MODEL MATA UB 12 8K','1.340','1.340','100.00','1662000','1265000','944030','1005000','1','1265000','1265000','CUCI'); UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.340',berat_beli_asli=berat_beli_asli+'1.340',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.340',berat_akhir_asli=berat_akhir_asli+'1.340',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-11-08' 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-261108-0009','2026-11-08','2026-11-08','10:52:25','AAT','---','1.340','1265000','1265000','1265000','1265000','1265000','kasir','2026-11-08 10:52:25','FB-261108-0008'); INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261108-0009','NIA','BUGELAN KISMANTORO','','','085124988382','kasir','2026-11-08 10:52:25'); SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-11-08' 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-261108-0025','K','2026-11-08','10:52:25','kasir','PEMBELIAN UMUM','FB-261108-0009','8106067000','1265000','8104802000'); 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-00020789','X-00020789','KL X NORY KH 44 8K','GR','---','H1E','BELI','BELI001','2945000','2026-11-08','3.060','1','kasir','2026-11-08 10:52:25'); DELETE FROM tp_barang WHERE kode_dept = 'X-H1E'; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-H1E','X-00020789','X-00020789'); 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-261108-0010','F326210237271','AAT','3','BELI','BELI001','H1E', 'X-00020789', 'KL X NORY KH 44 8K','3.060','3.060','100.00','3167000','2945000','962418','1045000','1','2945000','2945000','CUCI'); UPDATE tt_barang_saldo SET berat_beli=berat_beli+'3.060',berat_beli_asli=berat_beli_asli+'3.060',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'3.060',berat_akhir_asli=berat_akhir_asli+'3.060',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-11-08' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='H1E' LIMIT 1; INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-261108-0010','2026-11-08','2026-11-08','10:52:25','AAT','---','3.060','2945000','2945000','2945000','2945000','2945000','kasir','2026-11-08 10:52:25','FB-261108-0008'); INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261108-0010','NIA','BUGELAN','','','','kasir','2026-11-08 10:52:25'); SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-11-08' 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-261108-0026','K','2026-11-08','10:52:25','kasir','PEMBELIAN UMUM','FB-261108-0010','8104802000','2945000','8101857000'); 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-00020790','X-00020790','CC X WEDDING POLOS CM 20 8K','GR','---','E1D','BELI','BELI001','905000','2026-11-08','0.960','1','kasir','2026-11-08 10:52:25'); DELETE FROM tp_barang WHERE kode_dept = 'X-E1D'; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E1D','X-00020790','X-00020790'); 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-261108-0011','F326271004352','AAT','4','BELI','BELI001','E1D', 'X-00020790', 'CC X WEDDING POLOS CM 20 8K','0.960','0.960','100.00','1047000','905000','942708','1005000','1','905000','905000','CUCI'); UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.960',berat_beli_asli=berat_beli_asli+'0.960',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.960',berat_akhir_asli=berat_akhir_asli+'0.960',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-11-08' 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-261108-0011','2026-11-08','2026-11-08','10:52:25','AAT','---','0.960','905000','905000','905000','905000','905000','kasir','2026-11-08 10:52:25','FB-261108-0008'); INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261108-0011','JANTO','BANDAR PACITAN','','','087733568352','kasir','2026-11-08 10:52:25'); SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-11-08' 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-261108-0027','K','2026-11-08','10:52:25','kasir','PEMBELIAN UMUM','FB-261108-0011','8101857000','905000','8100952000'); 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-00020791','X-00020791','GL X CASTELI SPECTRA VAR HW 8K','GR','---','F3E','BELI','BELI001','1425000','2026-11-08','1.480','1','kasir','2026-11-08 10:52:25'); DELETE FROM tp_barang WHERE kode_dept = 'X-F3E'; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F3E','X-00020791','X-00020791'); 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-261108-0012','F326050951391','AAT','5','BELI','BELI001','F3E', 'X-00020791', 'GL X CASTELI SPECTRA VAR HW 8K','1.480','1.480','100.00','1635000','1425000','962838','1045000','1','1425000','1425000','CUCI'); UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.480',berat_beli_asli=berat_beli_asli+'1.480',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.480',berat_akhir_asli=berat_akhir_asli+'1.480',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-11-08' 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-261108-0012','2026-11-08','2026-11-08','10:52:25','AAT','---','1.480','1425000','1425000','1425000','1425000','1425000','kasir','2026-11-08 10:52:25','FB-261108-0008'); INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261108-0012','WIDIA','GUNUNG MIJIL','','','','kasir','2026-11-08 10:52:25'); SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-11-08' 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-261108-0028','K','2026-11-08','10:52:25','kasir','PEMBELIAN UMUM','FB-261108-0012','8100952000','1425000','8099527000'); 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-00020792','X-00020792','AT X GYPSY SLEP LG 8K','GR','---','A1D','BELI','BELI001','1015000','2026-11-08','1.080','1','kasir','2026-11-08 10:52:25'); DELETE FROM tp_barang WHERE kode_dept = 'X-A1D'; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-A1D','X-00020792','X-00020792'); 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-261108-0013','F326021127061','AAT','6','BELI','BELI001','A1D', 'X-00020792', 'AT X GYPSY SLEP LG 8K','1.080','1.080','100.00','1092000','1015000','939815','1005000','1','1015000','1015000','CUCI'); UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.080',berat_beli_asli=berat_beli_asli+'1.080',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.080',berat_akhir_asli=berat_akhir_asli+'1.080',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-11-08' 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-261108-0013','2026-11-08','2026-11-08','10:52:25','AAT','---','1.080','1015000','1015000','1015000','1015000','1015000','kasir','2026-11-08 10:52:25','FB-261108-0008'); INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261108-0013','DESI','POHIJO','','','','kasir','2026-11-08 10:52:25'); SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-11-08' 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-261108-0029','K','2026-11-08','10:52:25','kasir','PEMBELIAN UMUM','FB-261108-0013','8099527000','1015000','8098512000'); UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261108-0013' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261108-0013'; UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261108-0012' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261108-0012'; UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261108-0011' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261108-0011'; UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261108-0010' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261108-0010'; 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-00020793','X-00020793','KL X NORY KH 44 8K','GR','---','H1E','BELI','BELI001','2945000','2026-11-08','3.060','1','kasir','2026-11-08 11:02:11'); DELETE FROM tp_barang WHERE kode_dept = 'X-H1E'; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-H1E','X-00020793','X-00020793'); 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-261108-0010','F326210237271','AAT','1','BELI','BELI001','H1E', 'X-00020793', 'KL X NORY KH 44 8K','3.060','3.060','100.00','3167000','2945000','962418','1045000','1','2945000','2945000','CUCI'); UPDATE tt_barang_saldo SET berat_beli=berat_beli+'3.060',berat_beli_asli=berat_beli_asli+'3.060',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'3.060',berat_akhir_asli=berat_akhir_asli+'3.060',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-11-08' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='H1E' LIMIT 1; INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-261108-0010','2026-11-08','2026-11-08','11:02:11','AAT','---','3.060','2945000','2945000','2945000','2945000','2945000','kasir','2026-11-08 11:02:11','FB-261108-0010'); INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261108-0010','NIA','BUGELAN','','','','kasir','2026-11-08 11:02:11'); SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-11-08' 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-261108-0034','K','2026-11-08','11:02:11','kasir','PEMBELIAN UMUM','FB-261108-0010','8104802000','2945000','8101857000'); 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-00020794','X-00020794','CC X WEDDING POLOS CM 20 8K','GR','---','E1D','BELI','BELI001','905000','2026-11-08','0.960','1','kasir','2026-11-08 11:02:29'); DELETE FROM tp_barang WHERE kode_dept = 'X-E1D'; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E1D','X-00020794','X-00020794'); 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-261108-0011','F326271004352','AAT','1','BELI','BELI001','E1D', 'X-00020794', 'CC X WEDDING POLOS CM 20 8K','0.960','0.960','100.00','1047000','905000','942708','1005000','1','905000','905000','CUCI'); UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.960',berat_beli_asli=berat_beli_asli+'0.960',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.960',berat_akhir_asli=berat_akhir_asli+'0.960',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-11-08' 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-261108-0011','2026-11-08','2026-11-08','11:02:28','AAT','---','0.960','905000','905000','905000','905000','905000','kasir','2026-11-08 11:02:29','FB-261108-0011'); INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261108-0011','JANTO','BANDAR PACITAN','','','087733568352','kasir','2026-11-08 11:02:29'); SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-11-08' 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-261108-0035','K','2026-11-08','11:02:28','kasir','PEMBELIAN UMUM','FB-261108-0011','8101857000','905000','8100952000'); 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-00020795','X-00020795','GL X CASTELI SPECTRA VAR HW 8K','GR','---','F3E','BELI','BELI001','1425000','2026-11-08','1.480','1','kasir','2026-11-08 11:02:51'); DELETE FROM tp_barang WHERE kode_dept = 'X-F3E'; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F3E','X-00020795','X-00020795'); 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-261108-0012','F326050951391','AAT','1','BELI','BELI001','F3E', 'X-00020795', 'GL X CASTELI SPECTRA VAR HW 8K','1.480','1.480','100.00','1635000','1425000','962838','1045000','1','1425000','1425000','CUCI'); UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.480',berat_beli_asli=berat_beli_asli+'1.480',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.480',berat_akhir_asli=berat_akhir_asli+'1.480',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-11-08' 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-261108-0012','2026-11-08','2026-11-08','11:02:50','AAT','---','1.480','1425000','1425000','1425000','1425000','1425000','kasir','2026-11-08 11:02:51','FB-261108-0012'); INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261108-0012','WIDIA','GUNUNG MIJIL','','','','kasir','2026-11-08 11:02:51'); SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-11-08' 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-261108-0036','K','2026-11-08','11:02:50','kasir','PEMBELIAN UMUM','FB-261108-0012','8100952000','1425000','8099527000'); 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-00020796','X-00020796','AT X GYPSY SLEP LG 8K','GR','---','A1D','BELI','BELI001','1015000','2026-11-08','1.080','1','kasir','2026-11-08 11:03:06'); DELETE FROM tp_barang WHERE kode_dept = 'X-A1D'; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-A1D','X-00020796','X-00020796'); 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-261108-0013','F326021127061','AAT','1','BELI','BELI001','A1D', 'X-00020796', 'AT X GYPSY SLEP LG 8K','1.080','1.080','100.00','1092000','1015000','939815','1005000','1','1015000','1015000','CUCI'); UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.080',berat_beli_asli=berat_beli_asli+'1.080',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.080',berat_akhir_asli=berat_akhir_asli+'1.080',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-11-08' 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-261108-0013','2026-11-08','2026-11-08','11:03:05','AAT','---','1.080','1015000','1015000','1015000','1015000','1015000','kasir','2026-11-08 11:03:06','FB-261108-0013'); INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261108-0013','DESI','POHIJO','','','','kasir','2026-11-08 11:03:06'); SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-11-08' 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-261108-0037','K','2026-11-08','11:03:05','kasir','PEMBELIAN UMUM','FB-261108-0013','8099527000','1015000','8098512000'); 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 ('F326081147461','kasir','1',' MEE1 X LG ','TOKO','PM-E','E1E-ZCCA-179-0','CC X MODEL DAUN SLEP LG 12 8K ','','0.470','1','100.00','482000','0','0','15000','482000','0','0','0','482000','SIN','00397403','E1E','0','0','-','0','1045000'); UPDATE tm_barang SET tgl_last_jual='2026-11-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZCCA-179-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.470',berat_jual_asli=berat_jual_asli+'0.470',stock_jual='1',berat_akhir=berat_akhir-'0.470',berat_akhir_asli=berat_akhir_asli-'0.470',stock_akhir='0' WHERE tanggal='2026-11-08' AND kode_barang='E1E-ZCCA-179-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 ('F326081147461','2026-11-08','0.470','2026-11-08','11:47:47','PLG0032257','482000','482000','0','482000','482000','kasir','2026-11-08 11:47:46','F32608114746'); 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-11-08','F326081147461','2026-11-08','11:47:47','SIN','482000','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-261108-0038','D','2026-11-08','11:47:47','kasir','PENJUALAN','F326081147461','8098512000','482000','8098994000'); 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 ('F326081151441','kasir','1',' MEB1 CM ','TOKO','PM-B','B1E-ZKXB-87-0','GW ITALY PANJANG HATI ARESO VAR CM 8K ','','0.730','1','100.00','748000','0','0','15000','748000','0','0','0','748000','LIS','00432607','B1E','0','0','-','0','1045000'); UPDATE tm_barang SET tgl_last_jual='2026-11-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1E-ZKXB-87-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.730',berat_jual_asli=berat_jual_asli+'0.730',stock_jual='1',berat_akhir=berat_akhir-'0.730',berat_akhir_asli=berat_akhir_asli-'0.730',stock_akhir='0' WHERE tanggal='2026-11-08' AND kode_barang='B1E-ZKXB-87-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-B' AND stock_akhir > 0 LIMIT 1; INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326081151441','2026-11-08','0.730','2026-11-08','11:51:44','PLG0032258','748000','748000','0','748000','748000','kasir','2026-11-08 11:51:44','F32608115144'); 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-11-08','F326081151441','2026-11-08','11:51:44','LIS','748000','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-261108-0039','D','2026-11-08','11:51:44','kasir','PENJUALAN','F326081151441','8098994000','748000','8099742000'); 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-00020797','X-00020797','GL MODEL FANCY POLOS HW 8K','GR','---','F3E','BELI','BELI001','1905000','2026-11-08','2.000','1','kasir','2026-11-08 11:53:44'); DELETE FROM tp_barang WHERE kode_dept = 'X-F3E'; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F3E','X-00020797','X-00020797'); 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-261108-0014','F326150211251','AAT','1','BELI','BELI001','F3E', 'X-00020797', 'GL MODEL FANCY POLOS HW 8K','2.000','2.000','100.00','2086000','1905000','952500','1045000','1','1905000','1905000','CUCI'); UPDATE tt_barang_saldo SET berat_beli=berat_beli+'2.000',berat_beli_asli=berat_beli_asli+'2.000',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'2.000',berat_akhir_asli=berat_akhir_asli+'2.000',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-11-08' 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-261108-0014','2026-11-08','2026-11-08','11:53:43','AAT','---','2.000','1905000','1905000','1905000','1905000','1905000','kasir','2026-11-08 11:53:44','FB-261108-0014'); INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261108-0014','JEMINI','PAKIS BARU','','','083845885634','kasir','2026-11-08 11:53:44'); SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-11-08' 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-261108-0040','K','2026-11-08','11:53:43','kasir','PEMBELIAN UMUM','FB-261108-0014','8099742000','1905000','8097837000'); 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-00020798','X-00020798','KL X NORY SEMI KH 48 8K','GR','---','H1E','BELI','BELI001','4822000','2026-11-08','5.010','1','kasir','2026-11-08 11:53:44'); DELETE FROM tp_barang WHERE kode_dept = 'X-H1E'; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-H1E','X-00020798','X-00020798'); 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-261108-0015','F326060928262','AAT','2','BELI','BELI001','H1E', 'X-00020798', 'KL X NORY SEMI KH 48 8K','5.010','5.010','100.00','5311000','4822000','962475','1045000','1','4822000','4822000','CUCI'); UPDATE tt_barang_saldo SET berat_beli=berat_beli+'5.010',berat_beli_asli=berat_beli_asli+'5.010',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'5.010',berat_akhir_asli=berat_akhir_asli+'5.010',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-11-08' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='H1E' LIMIT 1; INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-261108-0015','2026-11-08','2026-11-08','11:53:43','AAT','---','5.010','4822000','4822000','4822000','4822000','4822000','kasir','2026-11-08 11:53:44','FB-261108-0014'); INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261108-0015','SINDI','GAMBIRANOM','','','085728450819','kasir','2026-11-08 11:53:44'); SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-11-08' 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-261108-0041','K','2026-11-08','11:53:43','kasir','PEMBELIAN UMUM','FB-261108-0015','8097837000','4822000','8093015000'); 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 ('F326080119271','kasir','1',' MEE1 LG 14','TOKO','PM-E','E1E-ZDBB-67-0','CC MODEL TINJU BOLA KRAWANG LG 14 8K ','','0.720','1','100.00','738000','0','0','15000','738000','0','0','0','738000','LIS','00400677','E1E','0','0','-','0','1045000'); UPDATE tm_barang SET tgl_last_jual='2026-11-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZDBB-67-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.720',berat_jual_asli=berat_jual_asli+'0.720',stock_jual='1',berat_akhir=berat_akhir-'0.720',berat_akhir_asli=berat_akhir_asli-'0.720',stock_akhir='0' WHERE tanggal='2026-11-08' AND kode_barang='E1E-ZDBB-67-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 ('F326080119271','2026-11-08','0.720','2026-11-08','13:19:27','PLG0032259','738000','738000','0','738000','738000','kasir','2026-11-08 13:19:27','F32608011927'); 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-11-08','F326080119271','2026-11-08','13:19:27','LIS','738000','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-261108-0042','D','2026-11-08','13:19:27','kasir','PENJUALAN','F326080119271','8093015000','738000','8093753000','OPEN'); UPDATE tt_jual_head SET dibayar_rp='738000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326080119271' 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 ('F326080119272','kasir',' 1',' MFE1 X KH ','TOKO','PM-E','E1F-ZJCX-208-0','CC X MODEL SPECTRA SLEP KH 14 8K ','','0.370','1','100.00','387000','0','0','15000','387000','0','0','0','387000','LIS','00432434','E1F','0','0','-','0','1045000'); UPDATE tm_barang SET tgl_last_jual='2026-11-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1F-ZJCX-208-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.370',berat_jual_asli=berat_jual_asli+'0.370',stock_jual='1',berat_akhir=berat_akhir-'0.370',berat_akhir_asli=berat_akhir_asli-'0.370',stock_akhir='0' WHERE tanggal='2026-11-08' AND kode_barang='E1F-ZJCX-208-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 ('F326080119272','2026-11-08','0.370','2026-11-08','13:19:27','PLG0032260','387000','387000','0','387000','387000','kasir','2026-11-08 13:19:27','F32608011927'); 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-11-08','F326080119272','2026-11-08','13:19:27','LIS','387000','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-261108-0043','D','2026-11-08','13:19:27','kasir','PENJUALAN','F326080119272','8093753000','387000','8094140000','OPEN'); UPDATE tt_jual_head SET dibayar_rp='387000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326080119272' 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 ('F326080145231','kasir','1',' MDE2 10K C','TOKO','PM-E','E2D-ZJBX-37-0','CC WEDDING MATA 14 CM 8K ','','1.540','1','100.00','1548000','0','0','15000','1548000','0','10000','0','1558000','LIS','00430636','E2D','0','0','-','0','1005000'); UPDATE tm_barang SET tgl_last_jual='2026-11-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZJBX-37-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.540',berat_jual_asli=berat_jual_asli+'1.540',stock_jual='1',berat_akhir=berat_akhir-'1.540',berat_akhir_asli=berat_akhir_asli-'1.540',stock_akhir='0' WHERE tanggal='2026-11-08' AND kode_barang='E2D-ZJBX-37-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-E' AND stock_akhir > 0 LIMIT 1; INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326080145231','2026-11-08','1.540','2026-11-08','13:45:23','PLG0032261','1548000','1548000','10000','1558000','1558000','kasir','2026-11-08 13:45:23','F32608014523'); 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-11-08','F326080145231','2026-11-08','13:45:23','LIS','1558000','10000'); INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-261108-0044','D','2026-11-08','13:45:23','kasir','PENJUALAN','F326080145231','8094140000','1558000','8095698000'); 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 ('F326080149411','kasir','1',' MDE2 CM 10','TOKO','PM-E','E2D-ZHAX-339-0','CC WEDDING MATA CM 10 8K','','0.850','1','100.00','854000','0','0','15000','855000','0','0','0','855000','AAT','00418484','E2D','0','0','-','0','1005000'); UPDATE tm_barang SET tgl_last_jual='2026-11-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZHAX-339-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-11-08' AND kode_barang='E2D-ZHAX-339-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 ('F326080149411','2026-11-08','0.850','2026-11-08','13:49:41','PLG0032262','855000','855000','0','855000','855000','kasir','2026-11-08 13:49:41','F32608014941'); 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-11-08','F326080149411','2026-11-08','13:49:41','AAT','855000','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-261108-0045','D','2026-11-08','13:49:41','kasir','PENJUALAN','F326080149411','8095698000','855000','8096553000'); 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 ('F326080210061','kasir','1',' MEF3 HW ','TOKO','PM-F','F3E-ZIAF-234-0','GL RANTAI HOLLOW FLIK VAR HW 8K ','','1.740','1','100.00','1783000','0','0','15000','1783000','0','0','0','1783000','SIN','00424069','F3E','0','0','-','0','1045000'); UPDATE tm_barang SET tgl_last_jual='2026-11-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZIAF-234-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-11-08' AND kode_barang='F3E-ZIAF-234-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 ('F326080210061','2026-11-08','1.740','2026-11-08','14:10:06','PLG0032263','1783000','1783000','0','1783000','1783000','kasir','2026-11-08 14:10:06','F32608021006'); 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-11-08','F326080210061','2026-11-08','14:10:06','SIN','1783000','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-261108-0046','D','2026-11-08','14:10:06','kasir','PENJUALAN','F326080210061','8096553000','1783000','8098336000'); 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-00020799','X-00020799','GL OVAL MODEL SPECTRA VAR YT D56 8K','GR','---','F1E','BELI','BELI001','1155000','2026-11-08','1.730','1','kasir','2026-11-08 14:13:16'); DELETE FROM tp_barang WHERE kode_dept = 'X-F1E'; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F1E','X-00020799','X-00020799'); 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-261108-0016','F324061019021','SIN','1','BELI','BELI001','F1E', 'X-00020799', 'GL OVAL MODEL SPECTRA VAR YT D56 8K','1.730','1.730','100.00','975000','1155000','667630','1045000','1','1155000','1155000','CUCI'); UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.730',berat_beli_asli=berat_beli_asli+'1.730',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.730',berat_akhir_asli=berat_akhir_asli+'1.730',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-11-08' 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-261108-0016','2026-11-08','2026-11-08','14:13:15','SIN','---','1.730','1155000','1155000','1155000','1155000','1155000','kasir','2026-11-08 14:13:16','FB-261108-0016'); INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261108-0016','RINA','SLOGOHIMO','','','','kasir','2026-11-08 14:13:16'); SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-11-08' 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-261108-0047','K','2026-11-08','14:13:15','kasir','PEMBELIAN UMUM','FB-261108-0016','8098336000','1155000','8097181000'); 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-00020800','X-00020800','GL X OVAL MODEL MATA VAR UB D56','GR','---','F2E','BELI','BELI001','2333000','2026-11-08','3.230','1','kasir','2026-11-08 14:13:16'); DELETE FROM tp_barang WHERE kode_dept = 'X-F2E'; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F2E','X-00020800','X-00020800'); 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-261108-0017','F324201101151','SIN','2','BELI','BELI001','F2E', 'X-00020800', 'GL X OVAL MODEL MATA VAR UB D56','3.230','3.230','100.00','1977000','2333000','722291','1045000','1','2333000','2333000','CUCI'); UPDATE tt_barang_saldo SET berat_beli=berat_beli+'3.230',berat_beli_asli=berat_beli_asli+'3.230',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'3.230',berat_akhir_asli=berat_akhir_asli+'3.230',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-11-08' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='F2E' LIMIT 1; INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-261108-0017','2026-11-08','2026-11-08','14:13:15','SIN','---','3.230','2333000','2333000','2333000','2333000','2333000','kasir','2026-11-08 14:13:16','FB-261108-0016'); INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261108-0017','LINA','SLOGOHIMO','','','','kasir','2026-11-08 14:13:16'); SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-11-08' 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-261108-0048','K','2026-11-08','14:13:15','kasir','PEMBELIAN UMUM','FB-261108-0017','8097181000','2333000','8094848000'); 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-00020801','X-00020801','CC X MODEL MATA VAR LG 15 8K','GR','---','E2E','BELI','BELI001','615000','2026-11-08','0.960','1','kasir','2026-11-08 14:13:16'); DELETE FROM tp_barang WHERE kode_dept = 'X-E2E'; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2E','X-00020801','X-00020801'); 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-261108-0018','F324201101152','SIN','3','BELI','BELI001','E2E', 'X-00020801', 'CC X MODEL MATA VAR LG 15 8K','0.960','0.960','100.00','578000','615000','640625','1045000','1','615000','615000','CUCI'); UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.960',berat_beli_asli=berat_beli_asli+'0.960',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.960',berat_akhir_asli=berat_akhir_asli+'0.960',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-11-08' 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-261108-0018','2026-11-08','2026-11-08','14:13:15','SIN','---','0.960','615000','615000','615000','615000','615000','kasir','2026-11-08 14:13:16','FB-261108-0016'); INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261108-0018','RINA','SLOGOHIMO','','','','kasir','2026-11-08 14:13:16'); SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-11-08' 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-261108-0049','K','2026-11-08','14:13:15','kasir','PEMBELIAN UMUM','FB-261108-0018','8094848000','615000','8094233000'); 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-00020802','X-00020802','KL X NORY KH 44 8K','GR','---','H1E','BELI','BELI001','2897000','2026-11-08','3.010','1','kasir','2026-11-08 14:13:16'); DELETE FROM tp_barang WHERE kode_dept = 'X-H1E'; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-H1E','X-00020802','X-00020802'); 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-261108-0019','F326050905321','SIN','4','BELI','BELI001','H1E', 'X-00020802', 'KL X NORY KH 44 8K','3.010','3.010','100.00','3235000','2897000','962458','1045000','1','2897000','2897000','CUCI'); UPDATE tt_barang_saldo SET berat_beli=berat_beli+'3.010',berat_beli_asli=berat_beli_asli+'3.010',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'3.010',berat_akhir_asli=berat_akhir_asli+'3.010',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-11-08' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='H1E' LIMIT 1; INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-261108-0019','2026-11-08','2026-11-08','14:13:15','SIN','---','3.010','2897000','2897000','2897000','2897000','2897000','kasir','2026-11-08 14:13:16','FB-261108-0016'); INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261108-0019','RIDHA','PURWANTORO','','','082325271441','kasir','2026-11-08 14:13:16'); SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-11-08' 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-261108-0050','K','2026-11-08','14:13:15','kasir','PEMBELIAN UMUM','FB-261108-0019','8094233000','2897000','8091336000'); 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 ('F326080217471','input','1',' MEH1 X UB ','TOKO','PM-H','H1E-ZJAE-271-0','KL X GUCCI UB 44 8K ','','1.920','1','100.00','1968000','0','0','15000','1968000','0','0','0','1968000','SIN','00430154','H1E','0','0','-','0','1045000'); UPDATE tm_barang SET tgl_last_jual='2026-11-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZJAE-271-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-11-08' AND kode_barang='H1E-ZJAE-271-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 ('F326080217471','2026-11-08','1.920','2026-11-08','14:17:48','PLG0032264','1968000','1968000','0','1968000','1968000','input','2026-11-08 14:17:47','F32608021747'); 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-11-08','F326080217471','2026-11-08','14:17:48','SIN','1968000','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-261108-0051','D','2026-11-08','14:17:48','input','PENJUALAN','F326080217471','8091336000','1968000','8093304000'); 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 ('F326080245001','kasir','1',' MEE2 X CM ','TOKO','PM-E','E2E-ZHCA-68-0','CC X MODEL MATA CM 14 8K ','','0.670','1','100.00','687000','0','0','15000','688000','0','0','0','688000','LIS','00421356','E2E','0','0','-','0','1045000'); UPDATE tm_barang SET tgl_last_jual='2026-11-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-ZHCA-68-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.670',berat_jual_asli=berat_jual_asli+'0.670',stock_jual='1',berat_akhir=berat_akhir-'0.670',berat_akhir_asli=berat_akhir_asli-'0.670',stock_akhir='0' WHERE tanggal='2026-11-08' AND kode_barang='E2E-ZHCA-68-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 ('F326080245001','2026-11-08','0.670','2026-11-08','14:45:00','PLG0032265','688000','688000','0','688000','688000','kasir','2026-11-08 14:45:00','F32608024500'); 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-11-08','F326080245001','2026-11-08','14:45:00','LIS','688000','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-261108-0052','D','2026-11-08','14:45:00','kasir','PENJUALAN','F326080245001','8093304000','688000','8093992000'); UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326080119271' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326080119271' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326080119271'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326080119272' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326080119272' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326080119272'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326080145231' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326080145231' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326080145231'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326080149411' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326080149411' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326080149411'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326080210061' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326080210061' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326080210061'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326080217471' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326080217471' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326080217471'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326080245001' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326080245001' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326080245001'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326080910471' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326080910471' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326080910471'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326080910472' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326080910472' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326080910472'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326080925181' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326080925181' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326080925181'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326080932271' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326080932271' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326080932271'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326080932591' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326080932591' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326080932591'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326080935231' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326080935231' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326080935231'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326080940131' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326080940131' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326080940131'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326081009401' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326081009401' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326081009401'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326081025391' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326081025391' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326081025391'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326081028381' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326081028381' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326081028381'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326081028382' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326081028382' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326081028382'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326081041541' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326081041541' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326081041541'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326081041542' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326081041542' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326081041542'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326081041543' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326081041543' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326081041543'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326081047491' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326081047491' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326081047491'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326081147461' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326081147461' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326081147461'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326081151441' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326081151441' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326081151441'; UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261108-0001' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261108-0001'; UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261108-0002' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261108-0002'; UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261108-0003' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261108-0003'; UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261108-0004' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261108-0004'; UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261108-0005' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261108-0005'; UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261108-0006' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261108-0006'; UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261108-0007' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261108-0007'; UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261108-0008' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261108-0008'; UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261108-0009' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261108-0009'; UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261108-0010' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261108-0010'; UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261108-0011' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261108-0011'; UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261108-0012' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261108-0012'; UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261108-0013' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261108-0013'; UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261108-0014' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261108-0014'; UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261108-0015' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261108-0015'; UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261108-0016' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261108-0016'; UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261108-0017' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261108-0017'; UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261108-0018' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261108-0018'; UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261108-0019' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261108-0019'; INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-11-09','0','0','0','0','0','0'); DELETE FROM th_barang_saldo WHERE tanggal <= '2026-10-09'; INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-11-08'; UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-11-08'; 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-11-08' AND berat_akhir*1 > '0' INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-11-08'; DELETE FROM tt_cash_daily WHERE tanggal <= '2026-11-08'; INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-11-08'; DELETE FROM tt_bank_daily WHERE tanggal <= '2026-11-08'; CREATE TABLE IF NOT EXISTS th_barang_saldo_202610 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-10'; DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-10'; UPDATE tt_barang_saldo SET tanggal= '2026-11-09' WHERE status_close ='OPEN'; DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-11-08' 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-261109-0001','D','2026-11-09','15:12:07','SYSTEM','SALDO AWAL','SALDO AWAL','0','8093992000','8093992000'); 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-261109-0001','D','2026-11-09','15:12:07','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-261109-0001','D','2026-11-09','15:12:07','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-261109-0001','D','2026-11-09','15:12:07','BCA','SALDO AWAL','SALDO AWAL','0','748085000','748085000'); UPDATE tp_system SET tgl_system='2026-11-09';