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 ('F326180818111','input','1',' MEE2 X LG ','TOKO','PM-E','E2E-ZDBI-117-0','CC X BONEKA ANAK CAT MATA LG 8K ','','0.530','1','100.00','553000','0','0','15000','553000','0','0','0','553000','AAT','00401763','E2E','0','0','-','0','1053000'); UPDATE tm_barang SET tgl_last_jual='2026-10-18', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-ZDBI-117-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.530',berat_jual_asli=berat_jual_asli+'0.530',stock_jual='1',berat_akhir=berat_akhir-'0.530',berat_akhir_asli=berat_akhir_asli-'0.530',stock_akhir='0' WHERE tanggal='2026-10-18' AND kode_barang='E2E-ZDBI-117-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 ('F326180818111','2026-10-18','0.530','2026-10-18','08:18:11','PLG0031935','553000','553000','0','553000','553000','input','2026-10-18 08:18:11','F32618081811'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-18','F326180818111','2026-10-18','08:18:11','AAT','553000','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-261018-0002','D','2026-10-18','08:18:11','input','PENJUALAN','F326180818111','7906303000','553000','7906856000','OPEN'); UPDATE tt_jual_head SET dibayar_rp='553000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326180818111' 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 ('F326180818112','input',' 1',' MEE2 5K LG','TOKO','PM-E','E2E-ZGXA-352-0','CC BONEKA ANAK CAT MATA LG 8K ','','0.520','1','100.00','542000','0','0','15000','542000','0','5000','0','547000','AAT','00411876','E2E','0','0','-','0','1053000'); UPDATE tm_barang SET tgl_last_jual='2026-10-18', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-ZGXA-352-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.520',berat_jual_asli=berat_jual_asli+'0.520',stock_jual='1',berat_akhir=berat_akhir-'0.520',berat_akhir_asli=berat_akhir_asli-'0.520',stock_akhir='0' WHERE tanggal='2026-10-18' AND kode_barang='E2E-ZGXA-352-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 ('F326180818112','2026-10-18','0.520','2026-10-18','08:18:11','PLG0031936','542000','542000','5000','547000','547000','input','2026-10-18 08:18:11','F32618081811'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-18','F326180818112','2026-10-18','08:18:11','AAT','547000','5000'); INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-261018-0003','D','2026-10-18','08:18:11','input','PENJUALAN','F326180818112','7906856000','547000','7907403000','OPEN'); UPDATE tt_jual_head SET dibayar_rp='547000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326180818112' 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 ('F326180833121','input','1',' MEF3E XXX ','TOKO','PM-F','F3E-ZGXI-115-0','GL XXX CASTELI SLEP VAR HW 8K','','1.520','1','100.00','1585000','0','0','15000','1585000','0','0','0','1585000','AAT','00412834','F3E','0','0','-','0','1053000'); UPDATE tm_barang SET tgl_last_jual='2026-10-18', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZGXI-115-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-10-18' AND kode_barang='F3E-ZGXI-115-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 ('F326180833121','2026-10-18','1.520','2026-10-18','08:33:12','PLG0031937','1585000','1585000','0','1585000','1585000','input','2026-10-18 08:33:12','F32618083312'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-18','F326180833121','2026-10-18','08:33:12','AAT','1585000','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-261018-0004','D','2026-10-18','08:33:12','input','PENJUALAN','F326180833121','7907403000','1585000','7908988000'); 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-00020562','X-00020562','KL X TRIXIE SPECTRA HITAM YT 44 8K','GR','---','H1E','BELI','BELI001','1925000','2026-10-18','2.700','1','kasir','2026-10-18 09:14:24'); DELETE FROM tp_barang WHERE kode_dept = 'X-H1E'; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-H1E','X-00020562','X-00020562'); 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-261018-0001','F324201034441','AAT','1','BELI','BELI001','H1E', 'X-00020562', 'KL X TRIXIE SPECTRA HITAM YT 44 8K','2.700','2.700','100.00','1795000','1925000','712963','1053000','1','1925000','1925000','CUCI'); UPDATE tt_barang_saldo SET berat_beli=berat_beli+'2.700',berat_beli_asli=berat_beli_asli+'2.700',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'2.700',berat_akhir_asli=berat_akhir_asli+'2.700',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-10-18' 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-261018-0001','2026-10-18','2026-10-18','09:14:24','AAT','---','2.700','1925000','1925000','1925000','1925000','1925000','kasir','2026-10-18 09:14:24','FB-261018-0001'); INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261018-0001','AMBAR','KARANGAN BADEGAN','','','','kasir','2026-10-18 09:14:24'); SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-10-18' 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-261018-0005','K','2026-10-18','09:14:24','kasir','PEMBELIAN UMUM','FB-261018-0001','7908988000','1925000','7907063000'); 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-00020563','X-00020563','CC X MODEL MATA HITAM AY 14 8K','GR','---','E2D','BELI','BELI001','727000','2026-10-18','1.000','1','kasir','2026-10-18 09:14:24'); DELETE FROM tp_barang WHERE kode_dept = 'X-E2D'; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2D','X-00020563','X-00020563'); 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-261018-0002','F326040116181','AAT','2','BELI','BELI001','E2D', 'X-00020563', 'CC X MODEL MATA HITAM AY 14 8K','1.000','1.000','100.00','1100000','727000','727000','1033000','1','727000','727000','RUSAK'); UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.000',berat_beli_asli=berat_beli_asli+'1.000',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.000',berat_akhir_asli=berat_akhir_asli+'1.000',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-10-18' 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-261018-0002','2026-10-18','2026-10-18','09:14:24','AAT','---','1.000','727000','727000','727000','727000','727000','kasir','2026-10-18 09:14:24','FB-261018-0001'); INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261018-0002','SUSI SUSANTI','BADEGAN','','','','kasir','2026-10-18 09:14:24'); SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-10-18' 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-261018-0006','K','2026-10-18','09:14:24','kasir','PEMBELIAN UMUM','FB-261018-0002','7907063000','727000','7906336000'); 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 ('F326180928191','kasir','1',' MEB1E LG ','TOKO','PM-B','B1E-ZJXE-358-0','GW TIFF MATA VAR LG 8K ','','0.560','1','100.00','584000','0','0','15000','584000','0','0','0','584000','LIS','00427849','B1E','0','0','-','0','1053000'); UPDATE tm_barang SET tgl_last_jual='2026-10-18', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1E-ZJXE-358-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.560',berat_jual_asli=berat_jual_asli+'0.560',stock_jual='1',berat_akhir=berat_akhir-'0.560',berat_akhir_asli=berat_akhir_asli-'0.560',stock_akhir='0' WHERE tanggal='2026-10-18' AND kode_barang='B1E-ZJXE-358-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 ('F326180928191','2026-10-18','0.560','2026-10-18','09:28:20','PLG0031938','584000','584000','0','584000','584000','kasir','2026-10-18 09:28:19','F32618092819'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-18','F326180928191','2026-10-18','09:28:20','LIS','584000','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-261018-0007','D','2026-10-18','09:28:20','kasir','PENJUALAN','F326180928191','7906336000','584000','7906920000','OPEN'); UPDATE tt_jual_head SET dibayar_rp='584000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326180928191' 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 ('F326180928192','kasir',' 1',' MEE1 5K LG','TOKO','PM-E','E1E-ZEBX-224-0','CC BABY PLAT CAT LG 8K ','','0.550','1','100.00','574000','0','0','15000','574000','0','5000','0','579000','LIS','00404502','E1E','0','0','-','0','1053000'); UPDATE tm_barang SET tgl_last_jual='2026-10-18', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZEBX-224-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.550',berat_jual_asli=berat_jual_asli+'0.550',stock_jual='1',berat_akhir=berat_akhir-'0.550',berat_akhir_asli=berat_akhir_asli-'0.550',stock_akhir='0' WHERE tanggal='2026-10-18' AND kode_barang='E1E-ZEBX-224-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 ('F326180928192','2026-10-18','0.550','2026-10-18','09:28:20','PLG0031939','574000','574000','5000','579000','579000','kasir','2026-10-18 09:28:19','F32618092819'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-18','F326180928192','2026-10-18','09:28:20','LIS','579000','5000'); INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-261018-0008','D','2026-10-18','09:28:20','kasir','PENJUALAN','F326180928192','7906920000','579000','7907499000','OPEN'); UPDATE tt_jual_head SET dibayar_rp='579000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326180928192' 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 ('F326180929261','kasir','1',' MEE2 HTM 1','TOKO','PM-E','E2E-ZJXA-93-0','CC PIPA MODEL MATA VAR HTM 18 8K ','','0.500','1','100.00','521000','0','0','15000','522000','0','0','0','522000','LIS','00426726','E2E','0','0','-','0','1053000'); UPDATE tm_barang SET tgl_last_jual='2026-10-18', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-ZJXA-93-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.500',berat_jual_asli=berat_jual_asli+'0.500',stock_jual='1',berat_akhir=berat_akhir-'0.500',berat_akhir_asli=berat_akhir_asli-'0.500',stock_akhir='0' WHERE tanggal='2026-10-18' AND kode_barang='E2E-ZJXA-93-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 ('F326180929261','2026-10-18','0.500','2026-10-18','09:29:26','PLG0031940','522000','522000','0','522000','522000','kasir','2026-10-18 09:29:26','F32618092926'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-18','F326180929261','2026-10-18','09:29:26','LIS','522000','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-261018-0009','D','2026-10-18','09:29:26','kasir','PENJUALAN','F326180929261','7907499000','522000','7908021000'); 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 ('F326180932531','kasir','1',' MDD2D HW ','TOKO','PM-D','D2D-ZGCA-210-0','LT X MODEL MATA BIRU HW 8K ','','1.150','1','100.00','1176000','0','0','15000','1176000','0','9000','0','1185000','AAT','00416296','D2D','0','0','-','0','1033000'); UPDATE tm_barang SET tgl_last_jual='2026-10-18', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D2D-ZGCA-210-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.150',berat_jual_asli=berat_jual_asli+'1.150',stock_jual='1',berat_akhir=berat_akhir-'1.150',berat_akhir_asli=berat_akhir_asli-'1.150',stock_akhir='0' WHERE tanggal='2026-10-18' AND kode_barang='D2D-ZGCA-210-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-D' AND stock_akhir > 0 LIMIT 1; INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326180932531','2026-10-18','1.150','2026-10-18','09:32:53','PLG0031941','1176000','1176000','9000','1185000','1185000','kasir','2026-10-18 09:32:53','F32618093253'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-18','F326180932531','2026-10-18','09:32:53','AAT','1185000','9000'); 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-261018-0010','D','2026-10-18','09:32:53','kasir','PENJUALAN','F326180932531','7908021000','1185000','7909206000'); 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 ('F326180935451','kasir','1',' MEE2 X 5K ','TOKO','PM-E','E2E-ZGAD-10-0','CC X BONEKA ANAK CAT SLEP LG 8K ','','0.630','1','100.00','657000','0','0','15000','658000','0','5000','0','663000','AAT','00413457','E2E','0','0','-','0','1053000'); UPDATE tm_barang SET tgl_last_jual='2026-10-18', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-ZGAD-10-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.630',berat_jual_asli=berat_jual_asli+'0.630',stock_jual='1',berat_akhir=berat_akhir-'0.630',berat_akhir_asli=berat_akhir_asli-'0.630',stock_akhir='0' WHERE tanggal='2026-10-18' AND kode_barang='E2E-ZGAD-10-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 ('F326180935451','2026-10-18','0.630','2026-10-18','09:35:45','PLG0031942','658000','658000','5000','663000','663000','kasir','2026-10-18 09:35:45','F32618093545'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-18','F326180935451','2026-10-18','09:35:45','AAT','663000','5000'); 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-261018-0011','D','2026-10-18','09:35:45','kasir','PENJUALAN','F326180935451','7909206000','663000','7909869000'); 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 ('F326180942301','kasir','1',' MEF3E X UB','TOKO','PM-F','F3E-ZFXH-143-0','GL X SANTA MATA VAR SERUT UB 8K ','','2.070','1','100.00','2159000','0','0','15000','2160000','0','0','0','2160000','FIT','00408004','F3E','0','0','-','0','1053000'); UPDATE tm_barang SET tgl_last_jual='2026-10-18', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZFXH-143-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.070',berat_jual_asli=berat_jual_asli+'2.070',stock_jual='1',berat_akhir=berat_akhir-'2.070',berat_akhir_asli=berat_akhir_asli-'2.070',stock_akhir='0' WHERE tanggal='2026-10-18' AND kode_barang='F3E-ZFXH-143-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 ('F326180942301','2026-10-18','2.070','2026-10-18','09:42:30','PLG0031943','2160000','2160000','0','2160000','2160000','kasir','2026-10-18 09:42:30','F32618094230'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-18','F326180942301','2026-10-18','09:42:30','FIT','2160000','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-261018-0012','D','2026-10-18','09:42:30','kasir','PENJUALAN','F326180942301','7909869000','2160000','7912029000'); 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 ('F326181023431','kasir','1',' MED2E LG ','TOKO','PM-D','D2E-ZFBC-56-0','LT MODEL JANGKAR MATA SLEP LG 8K ','','0.500','1','100.00','521000','0','0','15000','520000','0','0','0','520000','AAT','00409930','D2E','0','0','-','1','1053000'); UPDATE tm_barang SET tgl_last_jual='2026-10-18', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D2E-ZFBC-56-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.500',berat_jual_asli=berat_jual_asli+'0.500',stock_jual='1',berat_akhir=berat_akhir-'0.500',berat_akhir_asli=berat_akhir_asli-'0.500',stock_akhir='0' WHERE tanggal='2026-10-18' AND kode_barang='D2E-ZFBC-56-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 ('F326181023431','2026-10-18','0.500','2026-10-18','10:23:44','PLG0031944','520000','520000','0','520000','520000','kasir','2026-10-18 10:23:43','F32618102343'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-18','F326181023431','2026-10-18','10:23:44','AAT','520000','0'); INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-261018-0013','D','2026-10-18','10:23:44','kasir','PENJUALAN','F326181023431','7912029000','520000','7912549000','OPEN'); UPDATE tt_jual_head SET dibayar_rp='520000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326181023431' 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 ('F326181023432','kasir',' 1',' MEH1 X UB ','TOKO','PM-H','H1E-ZIAI-101-0','KL X MILANO UB 42 8K ','','2.110','1','100.00','2201000','0','0','15000','2200000','0','0','0','2200000','AAT','00424323','H1E','0','0','-','1','1053000'); UPDATE tm_barang SET tgl_last_jual='2026-10-18', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZIAI-101-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.110',berat_jual_asli=berat_jual_asli+'2.110',stock_jual='1',berat_akhir=berat_akhir-'2.110',berat_akhir_asli=berat_akhir_asli-'2.110',stock_akhir='0' WHERE tanggal='2026-10-18' AND kode_barang='H1E-ZIAI-101-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 ('F326181023432','2026-10-18','2.110','2026-10-18','10:23:44','PLG0031945','2200000','2200000','0','2200000','2200000','kasir','2026-10-18 10:23:43','F32618102343'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-18','F326181023432','2026-10-18','10:23:44','AAT','2200000','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-261018-0014','D','2026-10-18','10:23:44','kasir','PENJUALAN','F326181023432','7912549000','2200000','7914749000','OPEN'); UPDATE tt_jual_head SET dibayar_rp='2200000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326181023432' LIMIT 1; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326181023431' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326181023431' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326181023431'; 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 ('F326181026241','kasir','1',' MED2E LG ','TOKO','PM-D','D2E-ZFBC-56-0','LT MODEL JANGKAR MATA SLEP LG 8K ','','0.500','1','100.00','521000','0','0','15000','520000','0','0','0','520000','AAT','00409930','D2E','0','0','-','1','1053000'); UPDATE tm_barang SET tgl_last_jual='2026-10-18', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D2E-ZFBC-56-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.500',berat_jual_asli=berat_jual_asli+'0.500',stock_jual='1',berat_akhir=berat_akhir-'0.500',berat_akhir_asli=berat_akhir_asli-'0.500',stock_akhir='0' WHERE tanggal='2026-10-18' AND kode_barang='D2E-ZFBC-56-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 ('F326181026241','2026-10-18','0.500','2026-10-18','10:26:24','PLG0031946','520000','520000','0','520000','520000','kasir','2026-10-18 10:26:24','F32618102624'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-18','F326181026241','2026-10-18','10:26:24','AAT','520000','0'); INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-261018-0016','D','2026-10-18','10:26:24','kasir','PENJUALAN','F326181026241','7914229000','520000','7914749000'); 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-00020564','X-00020564','GL X OVAL VAR MATA CAT SLEP LT 56 8K','GR','---','F2E','BELI','BELI001','1992000','2026-10-18','2.310','1','kasir','2026-10-18 10:28:08'); DELETE FROM tp_barang WHERE kode_dept = 'X-F2E'; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F2E','X-00020564','X-00020564'); 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-261018-0003','F326061127391','LIS','1','BELI','BELI001','F2E', 'X-00020564', 'GL X OVAL VAR MATA CAT SLEP LT 56 8K','2.350','2.310','100.00','2515000','1992000','862338','1053000','1','1992000','1992000','RUSAK'); UPDATE tt_barang_saldo SET berat_beli=berat_beli+'2.310',berat_beli_asli=berat_beli_asli+'2.310',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'2.310',berat_akhir_asli=berat_akhir_asli+'2.310',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-10-18' 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-261018-0003','2026-10-18','2026-10-18','10:28:08','LIS','---','2.310','1992000','1992000','1992000','1992000','1992000','kasir','2026-10-18 10:28:08','FB-261018-0003'); INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261018-0003','ANNISA','PAGERSARI PWO','','','','kasir','2026-10-18 10:28:08'); SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-10-18' 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-261018-0017','K','2026-10-18','10:28:08','kasir','PEMBELIAN UMUM','FB-261018-0003','7914749000','1992000','7912757000'); 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-00020565','X-00020565','CC X MODEL MATA CM 14 8K','GR','---','E2D','BELI','BELI001','1232000','2026-10-18','1.280','1','kasir','2026-10-18 10:28:22'); DELETE FROM tp_barang WHERE kode_dept = 'X-E2D'; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2D','X-00020565','X-00020565'); 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-261018-0004','F325251015091','AAT','1','BELI','BELI001','E2D', 'X-00020565', 'CC X MODEL MATA CM 14 8K','1.280','1.280','100.00','1325000','1232000','962500','1033000','1','1232000','1232000','CUCI'); UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.280',berat_beli_asli=berat_beli_asli+'1.280',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.280',berat_akhir_asli=berat_akhir_asli+'1.280',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-10-18' 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-261018-0004','2026-10-18','2026-10-18','10:28:22','AAT','---','1.280','1232000','1232000','1232000','1232000','1232000','kasir','2026-10-18 10:28:22','FB-261018-0004'); INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261018-0004','TASYA','BUGELAN KISMANTORO','','','085878169686','kasir','2026-10-18 10:28:22'); SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-10-18' 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-261018-0018','K','2026-10-18','10:28:22','kasir','PEMBELIAN UMUM','FB-261018-0004','7912757000','1232000','7911525000'); 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-00020566','X-00020566','GW X TUSUK DAISY MATA LG 8K','GR','---','B1F','BELI','BELI001','295000','2026-10-18','0.310','1','kasir','2026-10-18 10:28:49'); DELETE FROM tp_barang WHERE kode_dept = 'X-B1F'; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-B1F','X-00020566','X-00020566'); 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-261018-0005','F326301205571','FIT','1','BELI','BELI001','B1F', 'X-00020566', 'GW X TUSUK DAISY MATA LG 8K','0.310','0.310','100.00','328000','295000','951613','1073000','1','295000','295000','CUCI'); UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.310',berat_beli_asli=berat_beli_asli+'0.310',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.310',berat_akhir_asli=berat_akhir_asli+'0.310',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-10-18' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='B1F' 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-261018-0005','2026-10-18','2026-10-18','10:28:48','FIT','---','0.310','295000','295000','295000','295000','295000','kasir','2026-10-18 10:28:49','FB-261018-0005'); INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261018-0005','BELA','BULUKERTO','','','','kasir','2026-10-18 10:28:49'); SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-10-18' 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-261018-0019','K','2026-10-18','10:28:48','kasir','PEMBELIAN UMUM','FB-261018-0005','7911525000','295000','7911230000'); 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-00020567','X-00020567','LT COR T 8K','GR','---','D1F','BELI','BELI001','500000','2026-10-18','0.950','1','kasir','2026-10-18 10:31:33'); DELETE FROM tp_barang WHERE kode_dept = 'X-D1F'; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-D1F','X-00020567','X-00020567'); 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-261018-0006','F321101107001','FIT','1','BELI','BELI001','D1F', 'X-00020567', 'LT COR T 8K','0.950','0.950','100.00','395000','500000','526316','1073000','1','500000','500000','CUCI'); UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.950',berat_beli_asli=berat_beli_asli+'0.950',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.950',berat_akhir_asli=berat_akhir_asli+'0.950',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-10-18' 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-261018-0006','2026-10-18','2026-10-18','10:31:33','FIT','---','0.950','500000','500000','500000','500000','500000','kasir','2026-10-18 10:31:33','FB-261018-0006'); INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261018-0006','YANTI','BULUKERTO','','','','kasir','2026-10-18 10:31:33'); SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-10-18' 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-261018-0020','K','2026-10-18','10:31:33','kasir','PEMBELIAN UMUM','FB-261018-0006','7911230000','500000','7910730000'); 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-00020568','X-00020568','KL POLOS 9K','GR','---','H2I','BELI','BELI001','1510000','2026-10-18','1.980','1','kasir','2026-10-18 10:32:50'); DELETE FROM tp_barang WHERE kode_dept = 'X-H2I'; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-H2I','X-00020568','X-00020568'); 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-261018-0007','F321101107002','FIT','1','BELI','BELI001','H2I', 'X-00020568', 'KL POLOS 9K','2.010','1.980','100.00','895000','1510000','762626','1133000','1','1510000','1510000','CUCI'); UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.980',berat_beli_asli=berat_beli_asli+'1.980',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.980',berat_akhir_asli=berat_akhir_asli+'1.980',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-10-18' 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-261018-0007','2026-10-18','2026-10-18','10:32:50','FIT','---','1.980','1510000','1510000','1510000','1510000','1510000','kasir','2026-10-18 10:32:50','FB-261018-0007'); INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261018-0007','YANTI','BULUKERTO','','','','kasir','2026-10-18 10:32:50'); SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-10-18' 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-261018-0021','K','2026-10-18','10:32:50','kasir','PEMBELIAN UMUM','FB-261018-0007','7910730000','1510000','7909220000'); 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 ('F326181034431','kasir','1',' MFE2 KH 12','TOKO','PM-E','E2F-ZJXA-103-0','CC MODEL MATA VAR KH 12 8K ','','0.350','1','100.00','372000','0','0','15000','373000','0','0','0','373000','LIS','00426736','E2F','0','0','-','0','1073000'); UPDATE tm_barang SET tgl_last_jual='2026-10-18', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2F-ZJXA-103-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-10-18' AND kode_barang='E2F-ZJXA-103-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 ('F326181034431','2026-10-18','0.350','2026-10-18','10:34:44','PLG0031947','373000','373000','0','373000','373000','kasir','2026-10-18 10:34:43','F32618103443'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-18','F326181034431','2026-10-18','10:34:44','LIS','373000','0'); INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-261018-0022','D','2026-10-18','10:34:44','kasir','PENJUALAN','F326181034431','7909220000','373000','7909593000','OPEN'); UPDATE tt_jual_head SET dibayar_rp='373000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326181034431' 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 ('F326181034432','kasir',' 1',' MEE1 KH 12','TOKO','PM-E','E1E-ZJXE-412-0','CC MODEL SLEP KH 12 8K ','','0.520','1','100.00','542000','0','0','15000','542000','0','0','0','542000','LIS','00427903','E1E','0','0','-','0','1053000'); UPDATE tm_barang SET tgl_last_jual='2026-10-18', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZJXE-412-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.520',berat_jual_asli=berat_jual_asli+'0.520',stock_jual='1',berat_akhir=berat_akhir-'0.520',berat_akhir_asli=berat_akhir_asli-'0.520',stock_akhir='0' WHERE tanggal='2026-10-18' AND kode_barang='E1E-ZJXE-412-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 ('F326181034432','2026-10-18','0.520','2026-10-18','10:34:44','PLG0031948','542000','542000','0','542000','542000','kasir','2026-10-18 10:34:43','F32618103443'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-18','F326181034432','2026-10-18','10:34:44','LIS','542000','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-261018-0023','D','2026-10-18','10:34:44','kasir','PENJUALAN','F326181034432','7909593000','542000','7910135000','OPEN'); UPDATE tt_jual_head SET dibayar_rp='542000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326181034432' LIMIT 1; INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00020569','X-00020569','GL XX OVAL C GELOMBANG TD 62 8K','GR','---','F1E','BELI','BELI001','2910000','2026-10-18','2.910','1','kasir','2026-10-18 10:38:05'); DELETE FROM tp_barang WHERE kode_dept = 'X-F1E'; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F1E','X-00020569','X-00020569'); 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-261018-0008','F326191152551','LIS','1','BELI','BELI001','F1E', 'X-00020569', 'GL XX OVAL C GELOMBANG TD 62 8K','2.910','2.910','100.00','3065000','2910000','1000000','1053000','1','2910000','2910000','CUCI'); UPDATE tt_barang_saldo SET berat_beli=berat_beli+'2.910',berat_beli_asli=berat_beli_asli+'2.910',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'2.910',berat_akhir_asli=berat_akhir_asli+'2.910',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-10-18' 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-261018-0008','2026-10-18','2026-10-18','10:38:04','LIS','---','2.910','2910000','2910000','2910000','2910000','2910000','kasir','2026-10-18 10:38:05','FB-261018-0008'); INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261018-0008','FERA','BULUKERTO','','','','kasir','2026-10-18 10:38:05'); SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-10-18' 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-261018-0024','K','2026-10-18','10:38:04','kasir','PEMBELIAN UMUM','FB-261018-0008','7910135000','2910000','7907225000'); 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-00020570','X-00020570','CC X MODEL MATA SLEP VAR CM 16 8K','GR','---','E2D','BELI','BELI001','790000','2026-10-18','0.830','1','kasir','2026-10-18 10:38:23'); DELETE FROM tp_barang WHERE kode_dept = 'X-E2D'; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2D','X-00020570','X-00020570'); 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-261018-0009','F326270914121','FIT','1','BELI','BELI001','E2D', 'X-00020570', 'CC X MODEL MATA SLEP VAR CM 16 8K','0.830','0.830','100.00','850000','790000','951807','1033000','1','790000','790000','CUCI'); UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.830',berat_beli_asli=berat_beli_asli+'0.830',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.830',berat_akhir_asli=berat_akhir_asli+'0.830',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-10-18' 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-261018-0009','2026-10-18','2026-10-18','10:38:22','FIT','---','0.830','790000','790000','790000','790000','790000','kasir','2026-10-18 10:38:23','FB-261018-0009'); INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261018-0009','ARLITA','TENGGER PUHPELEM','','','087812296654','kasir','2026-10-18 10:38:23'); SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-10-18' 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-261018-0025','K','2026-10-18','10:38:22','kasir','PEMBELIAN UMUM','FB-261018-0009','7907225000','790000','7906435000'); 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-00020571','X-00020571','CC COR T 8K','GR','---','E1E','BELI','BELI001','542000','2026-10-18','0.650','1','kasir','2026-10-18 10:39:32'); DELETE FROM tp_barang WHERE kode_dept = 'X-E1E'; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E1E','X-00020571','X-00020571'); 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-261018-0010','00423969','LIS','1','BELI','BELI001','E1E', 'X-00020571', 'CC COR T 8K','0.650','0.650','100.00','678000','542000','833846','1053000','1','542000','542000','RUSAK'); UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.650',berat_beli_asli=berat_beli_asli+'0.650',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.650',berat_akhir_asli=berat_akhir_asli+'0.650',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-10-18' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E1E' LIMIT 1; INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-261018-0010','2026-10-18','2026-10-18','10:39:32','LIS','---','0.650','542000','542000','542000','542000','542000','kasir','2026-10-18 10:39:32','FB-261018-0010'); INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261018-0010','KARNI','KARANGAN BADEGAN','','','','kasir','2026-10-18 10:39:32'); SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-10-18' 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-261018-0026','K','2026-10-18','10:39:32','kasir','PEMBELIAN UMUM','FB-261018-0010','7906435000','542000','7905893000'); 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 ('F326181051501','kasir','1',' MEE2 X CM ','TOKO','PM-E','E2E-YIBD-397-0','CC X MODEL MATA CM 12 8K ','','0.730','1','100.00','761000','0','0','15000','760000','0','0','0','760000','AAT','00370818','E2E','0','0','-','1','1053000'); UPDATE tm_barang SET tgl_last_jual='2026-10-18', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-YIBD-397-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-10-18' AND kode_barang='E2E-YIBD-397-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 ('F326181051501','2026-10-18','0.730','2026-10-18','10:51:50','PLG0031949','760000','760000','0','760000','760000','kasir','2026-10-18 10:51:50','F32618105150'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-18','F326181051501','2026-10-18','10:51:50','AAT','760000','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-261018-0027','D','2026-10-18','10:51:50','kasir','PENJUALAN','F326181051501','7905893000','760000','7906653000'); 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-00020572','X-00020572','AT DAISY MATA CM','GR','---','A1E','BELI','BELI001','270000','2026-10-18','0.500','1','kasir','2026-10-18 10:54:26'); DELETE FROM tp_barang WHERE kode_dept = 'X-A1E'; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-A1E','X-00020572','X-00020572'); 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-261018-0011','F322010954562','AAT','1','BELI','BELI001','A1E', 'X-00020572', 'AT DAISY MATA CM','0.500','0.500','100.00','220000','270000','540000','1053000','1','270000','270000','CUCI'); UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.500',berat_beli_asli=berat_beli_asli+'0.500',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.500',berat_akhir_asli=berat_akhir_asli+'0.500',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-10-18' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='A1E' LIMIT 1; INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-261018-0011','2026-10-18','2026-10-18','10:54:26','AAT','---','0.500','270000','270000','270000','270000','270000','kasir','2026-10-18 10:54:26','FB-261018-0011'); INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261018-0011','UCIK','CINGKLOK GESING','','','','kasir','2026-10-18 10:54:26'); SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-10-18' 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-261018-0028','K','2026-10-18','10:54:26','kasir','PEMBELIAN UMUM','FB-261018-0011','7906653000','270000','7906383000'); 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-00020573','X-00020573','CC MODEL ISYANA SLEP LG 12 8K','GR','---','E1E','BELI','BELI001','530000','2026-10-18','0.550','1','kasir','2026-10-18 10:54:48'); DELETE FROM tp_barang WHERE kode_dept = 'X-E1E'; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E1E','X-00020573','X-00020573'); 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-261018-0012','F326311017331','LIS','1','BELI','BELI001','E1E', 'X-00020573', 'CC MODEL ISYANA SLEP LG 12 8K','0.550','0.550','100.00','578000','530000','963636','1053000','1','530000','530000','CUCI'); UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.550',berat_beli_asli=berat_beli_asli+'0.550',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.550',berat_akhir_asli=berat_akhir_asli+'0.550',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-10-18' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E1E' LIMIT 1; INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-261018-0012','2026-10-18','2026-10-18','10:54:47','LIS','---','0.550','530000','530000','530000','530000','530000','kasir','2026-10-18 10:54:48','FB-261018-0012'); INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261018-0012','BELA','BULUKERTO','','','','kasir','2026-10-18 10:54:48'); SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-10-18' 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-261018-0029','K','2026-10-18','10:54:47','kasir','PEMBELIAN UMUM','FB-261018-0012','7906383000','530000','7905853000'); 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-00020574','X-00020574','GW COR 17K','GR','---','B1TE','BELI','BELI001','1422000','2026-10-18','1.010','1','kasir','2026-10-18 11:12:44'); DELETE FROM tp_barang WHERE kode_dept = 'X-B1TE'; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-B1TE','X-00020574','X-00020574'); 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-261018-0013','F321271032061','FIT','1','BELI','BELI001','B1TE', 'X-00020574', 'GW COR 17K','1.010','1.010','100.00','707000','1422000','1407921','1940000','1','1422000','1422000','CUCI'); UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.010',berat_beli_asli=berat_beli_asli+'1.010',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.010',berat_akhir_asli=berat_akhir_asli+'1.010',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-10-18' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='B1TE' 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-261018-0013','2026-10-18','2026-10-18','11:12:43','FIT','---','1.010','1422000','1422000','1422000','1422000','1422000','kasir','2026-10-18 11:12:44','FB-261018-0013'); INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261018-0013','ANIS','NGROTO WETAN BULUKERTO','','','','kasir','2026-10-18 11:12:44'); SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-10-18' 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-261018-0030','K','2026-10-18','11:12:43','kasir','PEMBELIAN UMUM','FB-261018-0013','7905853000','1422000','7904431000'); 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-00020575','X-00020575','KL KOREA UB 45CM 8K','GR','---','H1E','BELI','BELI001','1790000','2026-10-18','2.000','1','kasir','2026-10-18 11:25:11'); DELETE FROM tp_barang WHERE kode_dept = 'X-H1E'; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-H1E','X-00020575','X-00020575'); 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-261018-0014','F326251104591','FIT','1','BELI','BELI001','H1E', 'X-00020575', 'KL KOREA UB 45CM 8K','2.000','2.000','100.00','2220000','1790000','895000','1053000','1','1790000','1790000','RUSAK'); 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-10-18' 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-261018-0014','2026-10-18','2026-10-18','11:25:11','FIT','---','2.000','1790000','1790000','1790000','1790000','1790000','kasir','2026-10-18 11:25:11','FB-261018-0014'); INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261018-0014','BU DARMINI','LEMAHBANG','','','','kasir','2026-10-18 11:25:11'); SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-10-18' 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-261018-0031','K','2026-10-18','11:25:11','kasir','PEMBELIAN UMUM','FB-261018-0014','7904431000','1790000','7902641000'); 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 ('F326181132591','kasir','1',' MDE2 X AY ','TOKO','PM-E','E2D-ZIAX-64-0','CC X SOLITAIRE MATA AY 16 8K ','','0.860','1','100.00','880000','0','0','15000','880000','0','5000','0','885000','AAT','00422868','E2D','0','0','-','0','1033000'); UPDATE tm_barang SET tgl_last_jual='2026-10-18', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZIAX-64-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.860',berat_jual_asli=berat_jual_asli+'0.860',stock_jual='1',berat_akhir=berat_akhir-'0.860',berat_akhir_asli=berat_akhir_asli-'0.860',stock_akhir='0' WHERE tanggal='2026-10-18' AND kode_barang='E2D-ZIAX-64-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 ('F326181132591','2026-10-18','0.860','2026-10-18','11:32:59','PLG0031950','880000','880000','5000','885000','885000','kasir','2026-10-18 11:32:59','F32618113259'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-18','F326181132591','2026-10-18','11:32:59','AAT','885000','5000'); INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-261018-0032','D','2026-10-18','11:32:59','kasir','PENJUALAN','F326181132591','7902641000','885000','7903526000','OPEN'); UPDATE tt_jual_head SET dibayar_rp='885000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326181132591' 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 ('F326181132592','kasir',' 1',' MEH1 X KH ','TOKO','PM-H','H1E-ZFCX-245-0','KL X SANTA MATA VAR KH 42 8K ','','2.630','1','100.00','2743000','0','0','15000','2745000','0','0','0','2745000','AAT','00411452','H1E','0','0','-','0','1053000'); UPDATE tm_barang SET tgl_last_jual='2026-10-18', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZFCX-245-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.630',berat_jual_asli=berat_jual_asli+'2.630',stock_jual='1',berat_akhir=berat_akhir-'2.630',berat_akhir_asli=berat_akhir_asli-'2.630',stock_akhir='0' WHERE tanggal='2026-10-18' AND kode_barang='H1E-ZFCX-245-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 ('F326181132592','2026-10-18','2.630','2026-10-18','11:32:59','PLG0031951','2745000','2745000','0','2745000','2745000','kasir','2026-10-18 11:32:59','F32618113259'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-18','F326181132592','2026-10-18','11:32:59','AAT','2745000','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-261018-0033','D','2026-10-18','11:32:59','kasir','PENJUALAN','F326181132592','7903526000','2745000','7906271000','OPEN'); UPDATE tt_jual_head SET dibayar_rp='2745000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326181132592' 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 ('F326181139141','kasir','1',' MDE2 10K X','TOKO','PM-E','E2D-ZCBD-127-0','CC X WEDDING MATA CM 20 8K ','','2.230','1','100.00','2281000','0','0','15000','2280000','0','10000','0','2290000','AAT','00396607','E2D','0','0','-','1','1033000'); UPDATE tm_barang SET tgl_last_jual='2026-10-18', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZCBD-127-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.230',berat_jual_asli=berat_jual_asli+'2.230',stock_jual='1',berat_akhir=berat_akhir-'2.230',berat_akhir_asli=berat_akhir_asli-'2.230',stock_akhir='0' WHERE tanggal='2026-10-18' AND kode_barang='E2D-ZCBD-127-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 ('F326181139141','2026-10-18','2.230','2026-10-18','11:39:15','PLG0031952','2280000','2280000','10000','2290000','2290000','kasir','2026-10-18 11:39:14','F32618113914'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-18','F326181139141','2026-10-18','11:39:15','AAT','2290000','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-261018-0034','D','2026-10-18','11:39:15','kasir','PENJUALAN','F326181139141','7906271000','2290000','7908561000'); 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-00020576','X-00020576','AT * MODEL KLIP MATA MERAH LG','GR','---','A1E','BELI','BELI001','730000','2026-10-18','1.110','1','kasir','2026-10-18 12:11:08'); DELETE FROM tp_barang WHERE kode_dept = 'X-A1E'; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-A1E','X-00020576','X-00020576'); 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-261018-0015','F324260806391','LIS','1','BELI','BELI001','A1E', 'X-00020576', 'AT * MODEL KLIP MATA MERAH LG','1.110','1.110','100.00','545000','730000','657658','1053000','1','730000','730000','CUCI'); UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.110',berat_beli_asli=berat_beli_asli+'1.110',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.110',berat_akhir_asli=berat_akhir_asli+'1.110',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-10-18' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='A1E' LIMIT 1; INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-261018-0015','2026-10-18','2026-10-18','12:11:08','LIS','---','1.110','730000','730000','730000','730000','730000','kasir','2026-10-18 12:11:08','FB-261018-0015'); INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261018-0015','NAYARA','PAKISBARU','','','','kasir','2026-10-18 12:11:08'); SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-10-18' 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-261018-0035','K','2026-10-18','12:11:08','kasir','PEMBELIAN UMUM','FB-261018-0015','7908561000','730000','7907831000'); 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 ('F326181214311','kasir','1',' MJH2 X UB ','TOKO','PM-H','H2J-ZIXA-135-0','KL X GUCCI UB 44 9K ','','2.870','1','100.00','3280000','0','0','15000','3280000','0','0','0','3280000','LIS','00421562','H2J','0','0','-','0','1143000'); UPDATE tm_barang SET tgl_last_jual='2026-10-18', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H2J-ZIXA-135-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.870',berat_jual_asli=berat_jual_asli+'2.870',stock_jual='1',berat_akhir=berat_akhir-'2.870',berat_akhir_asli=berat_akhir_asli-'2.870',stock_akhir='0' WHERE tanggal='2026-10-18' AND kode_barang='H2J-ZIXA-135-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 ('F326181214311','2026-10-18','2.870','2026-10-18','12:14:31','PLG0031953','3280000','3280000','0','3280000','3280000','kasir','2026-10-18 12:14:31','F32618121431'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-18','F326181214311','2026-10-18','12:14:31','LIS','3280000','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-261018-0036','D','2026-10-18','12:14:31','kasir','PENJUALAN','F326181214311','7907831000','3280000','7911111000'); 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 ('F326181225401','kasir','1',' MDE1D CM 1','TOKO','PM-E','E1D-YJAH-11-T','CC MODEL SLEP CM 14 8K ','','1.150','1','100.00','1176000','0','0','15000','1175000','0','0','0','1175000','LIS','T0074224','E1D','0','0','-','1','1033000'); UPDATE tm_barang SET tgl_last_jual='2026-10-18', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-YJAH-11-T' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.150',berat_jual_asli=berat_jual_asli+'1.150',stock_jual='1',berat_akhir=berat_akhir-'1.150',berat_akhir_asli=berat_akhir_asli-'1.150',stock_akhir='0' WHERE tanggal='2026-10-18' AND kode_barang='E1D-YJAH-11-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-E' AND stock_akhir > 0 LIMIT 1; INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326181225401','2026-10-18','1.150','2026-10-18','12:25:41','PLG0031954','1175000','1175000','0','1175000','1175000','kasir','2026-10-18 12:25:40','F32618122540'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-18','F326181225401','2026-10-18','12:25:41','LIS','1175000','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-261018-0037','D','2026-10-18','12:25:41','kasir','PENJUALAN','F326181225401','7911111000','1175000','7912286000'); 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-00020577','X-00020577','GL LEMES 8K','GR','---','F3E','BELI','BELI001','2867000','2026-10-18','2.960','1','kasir','2026-10-18 12:27:51'); DELETE FROM tp_barang WHERE kode_dept = 'X-F3E'; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F3E','X-00020577','X-00020577'); 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-261018-0016','00421164','AAT','1','BELI','BELI001','F3E', 'X-00020577', 'GL LEMES 8K','2.960','2.960','100.00','3137000','2867000','968581','1053000','1','2867000','2867000','CUCI'); UPDATE tt_barang_saldo SET berat_beli=berat_beli+'2.960',berat_beli_asli=berat_beli_asli+'2.960',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'2.960',berat_akhir_asli=berat_akhir_asli+'2.960',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-10-18' 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-261018-0016','2026-10-18','2026-10-18','12:27:50','AAT','---','2.960','2867000','2867000','2867000','2867000','2867000','kasir','2026-10-18 12:27:51','FB-261018-0016'); INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261018-0016','LINDA AGUSTIN','JATISRONO WONOGIRI','','','','kasir','2026-10-18 12:27:51'); SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-10-18' 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-261018-0038','K','2026-10-18','12:27:50','kasir','PEMBELIAN UMUM','FB-261018-0016','7912286000','2867000','7909419000'); 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-00020578','X-00020578','GL OVAL MODEL BUNGA CLOVER VAR LT D56 8K','GR','---','F1F','BELI','BELI001','1463000','2026-10-18','2.030','1','kasir','2026-10-18 12:28:51'); DELETE FROM tp_barang WHERE kode_dept = 'X-F1F'; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F1F','X-00020578','X-00020578'); 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-261018-0017','F325260221291','LIS','1','BELI','BELI001','F1F', 'X-00020578', 'GL OVAL MODEL BUNGA CLOVER VAR LT D56 8K','2.030','2.030','100.00','1585000','1463000','720690','1073000','1','1463000','1463000','RUSAK'); UPDATE tt_barang_saldo SET berat_beli=berat_beli+'2.030',berat_beli_asli=berat_beli_asli+'2.030',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'2.030',berat_akhir_asli=berat_akhir_asli+'2.030',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-10-18' 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-261018-0017','2026-10-18','2026-10-18','12:28:50','LIS','---','2.030','1463000','1463000','1463000','1463000','1463000','kasir','2026-10-18 12:28:51','FB-261018-0017'); INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261018-0017','DWI','GELANG KENTHENG','','','','kasir','2026-10-18 12:28:51'); SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-10-18' 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-261018-0039','K','2026-10-18','12:28:50','kasir','PEMBELIAN UMUM','FB-261018-0017','7909419000','1463000','7907956000'); 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-00020579','X-00020579','CC MODEL SLEP HW 15 8K','GR','---','E1E','BELI','BELI001','620000','2026-10-18','0.640','1','kasir','2026-10-18 12:28:51'); DELETE FROM tp_barang WHERE kode_dept = 'X-E1E'; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E1E','X-00020579','X-00020579'); 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-261018-0018','F326020933371','LIS','2','BELI','BELI001','E1E', 'X-00020579', 'CC MODEL SLEP HW 15 8K','0.640','0.640','100.00','680000','620000','968750','1053000','1','620000','620000','CUCI'); UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.640',berat_beli_asli=berat_beli_asli+'0.640',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.640',berat_akhir_asli=berat_akhir_asli+'0.640',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-10-18' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E1E' LIMIT 1; INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-261018-0018','2026-10-18','2026-10-18','12:28:50','LIS','---','0.640','620000','620000','620000','620000','620000','kasir','2026-10-18 12:28:51','FB-261018-0017'); INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261018-0018','DWI','KHENTENG','','','','kasir','2026-10-18 12:28:51'); SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-10-18' 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-261018-0040','K','2026-10-18','12:28:50','kasir','PEMBELIAN UMUM','FB-261018-0018','7907956000','620000','7907336000'); 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-00020580','X-00020580','CC MODEL MATA YT 14 8K','GR','---','E2E','BELI','BELI001','447000','2026-10-18','0.600','1','kasir','2026-10-18 12:28:51'); DELETE FROM tp_barang WHERE kode_dept = 'X-E2E'; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2E','X-00020580','X-00020580'); 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-261018-0019','F325041022481','LIS','3','BELI','BELI001','E2E', 'X-00020580', 'CC MODEL MATA YT 14 8K','0.600','0.600','100.00','482000','447000','745000','1053000','1','447000','447000','CUCI'); UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.600',berat_beli_asli=berat_beli_asli+'0.600',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.600',berat_akhir_asli=berat_akhir_asli+'0.600',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-10-18' 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-261018-0019','2026-10-18','2026-10-18','12:28:50','LIS','---','0.600','447000','447000','447000','447000','447000','kasir','2026-10-18 12:28:51','FB-261018-0017'); INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261018-0019','DWI','KENTHENG','','','','kasir','2026-10-18 12:28:51'); SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-10-18' 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-261018-0041','K','2026-10-18','12:28:50','kasir','PEMBELIAN UMUM','FB-261018-0019','7907336000','447000','7906889000'); 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 ('F326181237361','kasir','1',' MDE2 X MG ','TOKO','PM-E','E2D-ZJAF-177-0','CC X MODEL MATA MG 26 8K ','','1.090','1','100.00','1126000','0','0','15000','1115000','0','0','0','1115000','AAT','00430356','E2D','0','0','-','1','1033000'); UPDATE tm_barang SET tgl_last_jual='2026-10-18', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZJAF-177-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.090',berat_jual_asli=berat_jual_asli+'1.090',stock_jual='1',berat_akhir=berat_akhir-'1.090',berat_akhir_asli=berat_akhir_asli-'1.090',stock_akhir='0' WHERE tanggal='2026-10-18' AND kode_barang='E2D-ZJAF-177-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 ('F326181237361','2026-10-18','1.090','2026-10-18','12:37:36','PLG0031955','1115000','1115000','0','1115000','1115000','kasir','2026-10-18 12:37:36','F32618123736'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-18','F326181237361','2026-10-18','12:37:36','AAT','1115000','0'); INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-261018-0042','D','2026-10-18','12:37:36','kasir','PENJUALAN','F326181237361','7906889000','1115000','7908004000'); 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 ('F326181239251','kasir','1',' MEE1E LG 1','TOKO','PM-E','E1E-ZFXD-361-0','CC MODEL ISYANA SLEP LG 16 8K ','','0.580','1','100.00','605000','0','0','15000','605000','0','0','0','605000','LIS','00407241','E1E','0','0','-','0','1053000'); UPDATE tm_barang SET tgl_last_jual='2026-10-18', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZFXD-361-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.580',berat_jual_asli=berat_jual_asli+'0.580',stock_jual='1',berat_akhir=berat_akhir-'0.580',berat_akhir_asli=berat_akhir_asli-'0.580',stock_akhir='0' WHERE tanggal='2026-10-18' AND kode_barang='E1E-ZFXD-361-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 ('F326181239251','2026-10-18','0.580','2026-10-18','12:39:26','PLG0031956','605000','605000','0','605000','605000','kasir','2026-10-18 12:39:25','F32618123925'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-18','F326181239251','2026-10-18','12:39:26','LIS','605000','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-261018-0043','D','2026-10-18','12:39:26','kasir','PENJUALAN','F326181239251','7908004000','605000','7908609000','OPEN'); UPDATE tt_jual_head SET dibayar_rp='605000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326181239251' 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 ('F326181239252','kasir',' 1',' MEE2 KH 16','TOKO','PM-E','E2E-ZJXE-377-0','CC MODEL SNAKE MATA KH 16 8K ','','0.500','1','100.00','521000','0','0','15000','522000','0','0','0','522000','LIS','00427868','E2E','0','0','-','0','1053000'); UPDATE tm_barang SET tgl_last_jual='2026-10-18', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-ZJXE-377-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.500',berat_jual_asli=berat_jual_asli+'0.500',stock_jual='1',berat_akhir=berat_akhir-'0.500',berat_akhir_asli=berat_akhir_asli-'0.500',stock_akhir='0' WHERE tanggal='2026-10-18' AND kode_barang='E2E-ZJXE-377-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 ('F326181239252','2026-10-18','0.500','2026-10-18','12:39:26','PLG0031957','522000','522000','0','522000','522000','kasir','2026-10-18 12:39:25','F32618123925'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-18','F326181239252','2026-10-18','12:39:26','LIS','522000','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-261018-0044','D','2026-10-18','12:39:26','kasir','PENJUALAN','F326181239252','7908609000','522000','7909131000','OPEN'); UPDATE tt_jual_head SET dibayar_rp='522000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326181239252' 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 ('F326181250331','kasir','1',' MEE1 KH 18','TOKO','PM-E','E1E-ZJXE-399-0','CC MODEL DAU SLEP KH 18 8K ','','0.410','1','100.00','428000','0','0','15000','428000','0','0','0','428000','AAT','00427890','E1E','0','0','-','0','1053000'); UPDATE tm_barang SET tgl_last_jual='2026-10-18', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZJXE-399-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.410',berat_jual_asli=berat_jual_asli+'0.410',stock_jual='1',berat_akhir=berat_akhir-'0.410',berat_akhir_asli=berat_akhir_asli-'0.410',stock_akhir='0' WHERE tanggal='2026-10-18' AND kode_barang='E1E-ZJXE-399-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 ('F326181250331','2026-10-18','0.410','2026-10-18','12:50:34','PLG0031958','428000','428000','0','428000','428000','kasir','2026-10-18 12:50:33','F32618125033'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-18','F326181250331','2026-10-18','12:50:34','AAT','428000','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-261018-0045','D','2026-10-18','12:50:34','kasir','PENJUALAN','F326181250331','7909131000','428000','7909559000','OPEN'); UPDATE tt_jual_head SET dibayar_rp='428000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326181250331' 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 ('F326181250332','kasir',' 1',' MDE1 X MJ ','TOKO','PM-E','E1D-ZGBA-192-0','CC X MODEL SLEP MJ 17 8K ','','0.850','1','100.00','870000','0','0','15000','870000','0','0','0','870000','AAT','00414674','E1D','0','0','-','0','1033000'); UPDATE tm_barang SET tgl_last_jual='2026-10-18', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-ZGBA-192-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-10-18' AND kode_barang='E1D-ZGBA-192-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 ('F326181250332','2026-10-18','0.850','2026-10-18','12:50:34','PLG0031959','870000','870000','0','870000','870000','kasir','2026-10-18 12:50:33','F32618125033'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-18','F326181250332','2026-10-18','12:50:34','AAT','870000','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-261018-0046','D','2026-10-18','12:50:34','kasir','PENJUALAN','F326181250332','7909559000','870000','7910429000','OPEN'); UPDATE tt_jual_head SET dibayar_rp='870000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326181250332' 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 ('F326181250333','kasir',' 1',' MFE2 KH 18','TOKO','PM-E','E2F-ZJXA-109-0','CC MODEL MATA VAR KH 18 8K ','','0.370','1','100.00','393000','0','0','15000','395000','0','0','0','395000','AAT','00426742','E2F','0','0','-','0','1073000'); UPDATE tm_barang SET tgl_last_jual='2026-10-18', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2F-ZJXA-109-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-10-18' AND kode_barang='E2F-ZJXA-109-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 ('F326181250333','2026-10-18','0.370','2026-10-18','12:50:34','PLG0031960','395000','395000','0','395000','395000','kasir','2026-10-18 12:50:33','F32618125033'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-18','F326181250333','2026-10-18','12:50:34','AAT','395000','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-261018-0047','D','2026-10-18','12:50:34','kasir','PENJUALAN','F326181250333','7910429000','395000','7910824000','OPEN'); UPDATE tt_jual_head SET dibayar_rp='395000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326181250333' 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 ('F326181255381','kasir','1',' MEF3E UB ','TOKO','PM-F','F3E-ZGBI-139-0','GL TIFF MATA VAR SERUT SLEP UB 8K ','','1.360','1','100.00','1419000','0','0','15000','1420000','0','0','0','1420000','FIT','00415899','F3E','0','0','-','0','1053000'); UPDATE tm_barang SET tgl_last_jual='2026-10-18', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZGBI-139-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.360',berat_jual_asli=berat_jual_asli+'1.360',stock_jual='1',berat_akhir=berat_akhir-'1.360',berat_akhir_asli=berat_akhir_asli-'1.360',stock_akhir='0' WHERE tanggal='2026-10-18' AND kode_barang='F3E-ZGBI-139-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 ('F326181255381','2026-10-18','1.360','2026-10-18','12:55:39','PLG0031961','1420000','1420000','0','1420000','1420000','kasir','2026-10-18 12:55:38','F32618125538'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-18','F326181255381','2026-10-18','12:55:39','FIT','1420000','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-261018-0048','D','2026-10-18','12:55:39','kasir','PENJUALAN','F326181255381','7910824000','1420000','7912244000'); 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-00020581','X-00020581','CC X MODEL DAUN SLEP PM 12 8K','GR','---','E1D','BELI','BELI001','960000','2026-10-18','1.000','1','kasir','2026-10-18 12:57:36'); DELETE FROM tp_barang WHERE kode_dept = 'X-E1D'; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E1D','X-00020581','X-00020581'); 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-261018-0020','F326301052511','LIS','1','BELI','BELI001','E1D', 'X-00020581', 'CC X MODEL DAUN SLEP PM 12 8K','1.000','1.000','100.00','1100000','960000','960000','1033000','1','960000','960000','CUCI'); UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.000',berat_beli_asli=berat_beli_asli+'1.000',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.000',berat_akhir_asli=berat_akhir_asli+'1.000',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-10-18' 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-261018-0020','2026-10-18','2026-10-18','12:57:36','LIS','---','1.000','960000','960000','960000','960000','960000','kasir','2026-10-18 12:57:36','FB-261018-0020'); INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261018-0020','MURNI','DOHO PUHPELEM','','','','kasir','2026-10-18 12:57:36'); SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-10-18' 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-261018-0049','K','2026-10-18','12:57:36','kasir','PEMBELIAN UMUM','FB-261018-0020','7912244000','960000','7911284000'); 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 ('F326180107411','kasir','1',' MEF3E X UB','TOKO','PM-F','F3E-ZJAF-32-0','GL X TIFF SPECTRA VAR UB 8K ','','1.880','1','100.00','1980000','0','0','15000','1960000','0','0','0','1960000','AAT','00430211','F3E','0','0','-','1','1053000'); UPDATE tm_barang SET tgl_last_jual='2026-10-18', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZJAF-32-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.880',berat_jual_asli=berat_jual_asli+'1.880',stock_jual='1',berat_akhir=berat_akhir-'1.880',berat_akhir_asli=berat_akhir_asli-'1.880',stock_akhir='0' WHERE tanggal='2026-10-18' AND kode_barang='F3E-ZJAF-32-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 ('F326180107411','2026-10-18','1.880','2026-10-18','13:07:41','PLG0031962','1960000','1960000','0','1960000','1960000','kasir','2026-10-18 13:07:41','F32618010741'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-18','F326180107411','2026-10-18','13:07:41','AAT','1960000','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-261018-0050','D','2026-10-18','13:07:41','kasir','PENJUALAN','F326180107411','7911284000','1960000','7913244000'); 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 ('F326180131221','kasir','1',' MEE2 KH 20','TOKO','PM-E','E2E-ZJXE-370-0','CC MODEL SNAKE MATA KH 20 8K ','','0.460','1','100.00','480000','0','0','15000','480000','0','0','0','480000','LIS','00427861','E2E','0','0','-','0','1053000'); UPDATE tm_barang SET tgl_last_jual='2026-10-18', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-ZJXE-370-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.460',berat_jual_asli=berat_jual_asli+'0.460',stock_jual='1',berat_akhir=berat_akhir-'0.460',berat_akhir_asli=berat_akhir_asli-'0.460',stock_akhir='0' WHERE tanggal='2026-10-18' AND kode_barang='E2E-ZJXE-370-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 ('F326180131221','2026-10-18','0.460','2026-10-18','13:31:22','PLG0031963','480000','480000','0','480000','480000','kasir','2026-10-18 13:31:22','F32618013122'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-18','F326180131221','2026-10-18','13:31:22','LIS','480000','0'); INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-261018-0051','D','2026-10-18','13:31:22','kasir','PENJUALAN','F326180131221','7913244000','480000','7913724000','OPEN'); UPDATE tt_jual_head SET dibayar_rp='480000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326180131221' 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 ('F326180131222','kasir',' 1',' MEE1 KH 18','TOKO','PM-E','E1E-ZIAE-285-0','CC MODEL RING 3 SLEP VAR KH 18 8K ','','0.520','1','100.00','542000','0','0','15000','543000','0','0','0','543000','LIS','00423821','E1E','0','0','-','0','1053000'); UPDATE tm_barang SET tgl_last_jual='2026-10-18', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZIAE-285-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.520',berat_jual_asli=berat_jual_asli+'0.520',stock_jual='1',berat_akhir=berat_akhir-'0.520',berat_akhir_asli=berat_akhir_asli-'0.520',stock_akhir='0' WHERE tanggal='2026-10-18' AND kode_barang='E1E-ZIAE-285-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 ('F326180131222','2026-10-18','0.520','2026-10-18','13:31:22','PLG0031964','543000','543000','0','543000','543000','kasir','2026-10-18 13:31:22','F32618013122'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-18','F326180131222','2026-10-18','13:31:22','LIS','543000','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-261018-0052','D','2026-10-18','13:31:22','kasir','PENJUALAN','F326180131222','7913724000','543000','7914267000','OPEN'); UPDATE tt_jual_head SET dibayar_rp='543000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326180131222' LIMIT 1; INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00020582','X-00020582','GL RANTAI HOLLOW SLEP UB 17K','GR','---','F3TE','BELI','BELI001','935000','2026-10-18','0.530','1','kasir','2026-10-18 13:45:21'); DELETE FROM tp_barang WHERE kode_dept = 'X-F3TE'; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F3TE','X-00020582','X-00020582'); 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-261018-0021','F326270936122','AAT','1','BELI','BELI001','F3TE', 'X-00020582', 'GL RANTAI HOLLOW SLEP UB 17K','0.530','0.530','100.00','1018000','935000','1764151','1940000','1','935000','935000','CUCI'); UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.530',berat_beli_asli=berat_beli_asli+'0.530',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.530',berat_akhir_asli=berat_akhir_asli+'0.530',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-10-18' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='F3TE' LIMIT 1; INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-261018-0021','2026-10-18','2026-10-18','13:45:20','AAT','---','0.530','935000','935000','935000','935000','935000','kasir','2026-10-18 13:45:21','FB-261018-0021'); INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261018-0021','ASTUTI','PULUTAN KENTENG','','','','kasir','2026-10-18 13:45:21'); SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-10-18' 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-261018-0053','K','2026-10-18','13:45:20','kasir','PEMBELIAN UMUM','FB-261018-0021','7914267000','935000','7913332000'); 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-00020583','X-00020583','GL X OVAL C SLEP UB 62 8K','GR','---','F1E','BELI','BELI001','4795000','2026-10-18','4.980','1','kasir','2026-10-18 13:47:15'); DELETE FROM tp_barang WHERE kode_dept = 'X-F1E'; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F1E','X-00020583','X-00020583'); 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-261018-0022','F326271130181','AAT','1','BELI','BELI001','F1E', 'X-00020583', 'GL X OVAL C SLEP UB 62 8K','4.980','4.980','100.00','5155000','4795000','962851','1053000','1','4795000','4795000','CUCI'); UPDATE tt_barang_saldo SET berat_beli=berat_beli+'4.980',berat_beli_asli=berat_beli_asli+'4.980',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'4.980',berat_akhir_asli=berat_akhir_asli+'4.980',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-10-18' 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-261018-0022','2026-10-18','2026-10-18','13:47:14','AAT','---','4.980','4795000','4795000','4795000','4795000','4795000','kasir','2026-10-18 13:47:15','FB-261018-0022'); INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261018-0022','NARSI','JANGGLE BULUKERTO','','','081215132044','kasir','2026-10-18 13:47:15'); SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-10-18' 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-261018-0054','K','2026-10-18','13:47:14','kasir','PEMBELIAN UMUM','FB-261018-0022','7913332000','4795000','7908537000'); 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-00020584','X-00020584','CC X RING UNTIR AY 14 8K','GR','---','E1E','BELI','BELI001','500000','2026-10-18','0.520','1','kasir','2026-10-18 13:47:15'); DELETE FROM tp_barang WHERE kode_dept = 'X-E1E'; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E1E','X-00020584','X-00020584'); 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-261018-0023','F326271136121','AAT','2','BELI','BELI001','E1E', 'X-00020584', 'CC X RING UNTIR AY 14 8K','0.520','0.520','100.00','538000','500000','961538','1053000','1','500000','500000','CUCI'); UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.520',berat_beli_asli=berat_beli_asli+'0.520',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.520',berat_akhir_asli=berat_akhir_asli+'0.520',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-10-18' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E1E' LIMIT 1; INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-261018-0023','2026-10-18','2026-10-18','13:47:14','AAT','---','0.520','500000','500000','500000','500000','500000','kasir','2026-10-18 13:47:15','FB-261018-0022'); INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261018-0023','NARSI','JANGGLE BULUKERTO','','','081215132044','kasir','2026-10-18 13:47:15'); SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-10-18' 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-261018-0055','K','2026-10-18','13:47:14','kasir','PEMBELIAN UMUM','FB-261018-0023','7908537000','500000','7908037000'); 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 ('F326180240561','kasir','1',' MEF1 HW D5','TOKO','PM-F','F1E-ZIBA-427-0','GL OVAL MODEL GELOMBANG HW D58 8K ','','1.470','1','100.00','1533000','0','0','15000','1533000','0','0','0','1533000','FIT','00424971','F1E','0','0','-','0','1053000'); UPDATE tm_barang SET tgl_last_jual='2026-10-18', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-ZIBA-427-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.470',berat_jual_asli=berat_jual_asli+'1.470',stock_jual='1',berat_akhir=berat_akhir-'1.470',berat_akhir_asli=berat_akhir_asli-'1.470',stock_akhir='0' WHERE tanggal='2026-10-18' AND kode_barang='F1E-ZIBA-427-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 ('F326180240561','2026-10-18','1.470','2026-10-18','14:40:56','PLG0031965','1533000','1533000','0','1533000','1533000','kasir','2026-10-18 14:40:56','F32618024056'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-18','F326180240561','2026-10-18','14:40:56','FIT','1533000','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-261018-0056','D','2026-10-18','14:40:56','kasir','PENJUALAN','F326180240561','7908037000','1533000','7909570000'); 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-00020585','X-00020585','KL SANTA MODEL HATI VAR HW 8K','GR','---','H1E','BELI','BELI001','1515000','2026-10-18','1.730','1','kasir','2026-10-18 14:45:48'); DELETE FROM tp_barang WHERE kode_dept = 'X-H1E'; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-H1E','X-00020585','X-00020585'); 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-261018-0024','F325110228271','LIS','1','BELI','BELI001','H1E', 'X-00020585', 'KL SANTA MODEL HATI VAR HW 8K','1.730','1.730','100.00','1782000','1515000','875723','1053000','1','1515000','1515000','RUSAK'); 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-10-18' 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-261018-0024','2026-10-18','2026-10-18','14:45:47','LIS','---','1.730','1515000','1515000','1515000','1515000','1515000','kasir','2026-10-18 14:45:48','FB-261018-0024'); INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261018-0024','WULAN','NGROMO','','','','kasir','2026-10-18 14:45:48'); SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-10-18' 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-261018-0057','K','2026-10-18','14:45:47','kasir','PEMBELIAN UMUM','FB-261018-0024','7909570000','1515000','7908055000'); UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261018-0001' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261018-0001'; UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261018-0002' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261018-0002'; UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261018-0003' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261018-0003'; UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261018-0004' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261018-0004'; UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261018-0005' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261018-0005'; UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261018-0006' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261018-0006'; UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261018-0007' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261018-0007'; UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261018-0008' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261018-0008'; UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261018-0009' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261018-0009'; UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261018-0010' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261018-0010'; UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261018-0011' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261018-0011'; UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261018-0012' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261018-0012'; UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261018-0013' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261018-0013'; UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261018-0014' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261018-0014'; UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261018-0015' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261018-0015'; UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261018-0016' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261018-0016'; UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261018-0017' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261018-0017'; UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261018-0018' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261018-0018'; UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261018-0019' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261018-0019'; UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261018-0020' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261018-0020'; UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261018-0021' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261018-0021'; UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261018-0022' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261018-0022'; UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261018-0023' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261018-0023'; UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261018-0024' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261018-0024'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326180107411' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326180107411' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326180107411'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326180131221' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326180131221' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326180131221'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326180131222' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326180131222' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326180131222'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326180240561' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326180240561' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326180240561'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326180818111' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326180818111' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326180818111'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326180818112' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326180818112' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326180818112'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326180833121' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326180833121' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326180833121'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326180928191' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326180928191' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326180928191'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326180928192' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326180928192' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326180928192'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326180929261' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326180929261' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326180929261'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326180932531' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326180932531' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326180932531'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326180935451' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326180935451' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326180935451'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326180942301' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326180942301' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326180942301'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326181023432' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326181023432' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326181023432'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326181026241' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326181026241' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326181026241'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326181034431' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326181034431' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326181034431'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326181034432' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326181034432' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326181034432'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326181051501' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326181051501' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326181051501'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326181132591' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326181132591' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326181132591'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326181132592' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326181132592' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326181132592'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326181139141' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326181139141' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326181139141'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326181214311' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326181214311' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326181214311'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326181225401' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326181225401' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326181225401'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326181237361' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326181237361' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326181237361'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326181239251' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326181239251' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326181239251'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326181239252' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326181239252' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326181239252'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326181250331' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326181250331' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326181250331'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326181250332' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326181250332' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326181250332'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326181250333' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326181250333' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326181250333'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326181255381' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326181255381' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326181255381'; INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-10-19','0','0','0','0','0','0'); DELETE FROM th_barang_saldo WHERE tanggal <= '2026-09-18'; INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-10-18'; UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-10-18'; INSERT INTO tt_barang_saldo (kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_awal,berat_awal_asli,stock_awal,berat_akhir,berat_akhir_asli,stock_akhir) SELECT kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_akhir,berat_akhir_asli,stock_akhir,berat_akhir,berat_akhir_asli,stock_akhir FROM tt_barang_saldo WHERE tanggal='2026-10-18' AND berat_akhir*1 > '0' INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-10-18'; DELETE FROM tt_cash_daily WHERE tanggal <= '2026-10-18'; INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-10-18'; DELETE FROM tt_bank_daily WHERE tanggal <= '2026-10-18'; CREATE TABLE IF NOT EXISTS th_barang_saldo_202609 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-09'; DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-09'; UPDATE tt_barang_saldo SET tanggal= '2026-10-19' WHERE status_close ='OPEN'; DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-10-18' 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-261019-0001','D','2026-10-19','15:10:05','SYSTEM','SALDO AWAL','SALDO AWAL','0','7908055000','7908055000'); 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-261019-0001','D','2026-10-19','15:10:05','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-261019-0001','D','2026-10-19','15:10:05','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-261019-0001','D','2026-10-19','15:10:05','BCA','SALDO AWAL','SALDO AWAL','0','743627000','743627000'); UPDATE tp_system SET tgl_system='2026-10-19';