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 ('F326010831511','input','1',' MDE2 CM 16','TOKO','PM-E','E2D-ZJBA-117-0','CC WEDDING MATA CM 16 8K ','','1.070','1','100.00','1059000','0','0','15000','1060000','0','0','0','1060000','LIS','00430754','E2D','0','0','-','0','1000000'); UPDATE tm_barang SET tgl_last_jual='2026-11-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZJBA-117-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.070',berat_jual_asli=berat_jual_asli+'1.070',stock_jual='1',berat_akhir=berat_akhir-'1.070',berat_akhir_asli=berat_akhir_asli-'1.070',stock_akhir='0' WHERE tanggal='2026-11-01' AND kode_barang='E2D-ZJBA-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 ('F326010831511','2026-11-01','1.070','2026-11-01','08:31:51','PLG0032150','1060000','1060000','0','1060000','1060000','input','2026-11-01 08:31:51','F32601083151'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-11-01','F326010831511','2026-11-01','08:31:51','LIS','1060000','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-261101-0002','D','2026-11-01','08:31:51','input','PENJUALAN','F326010831511','8041971000','1060000','8043031000'); 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 ('F326010931301','input','1',' TEH1 X HW ','TOKO','PT-H','H1TE-ZIXD-42-T','KL X ITALY HW 42CM 17K ','','10.080','1','100.00','18749000','0','0','15000','18750000','0','0','0','18750000','SIN','T0083015','H1TE','0','0','-','0','1860000'); UPDATE tm_barang SET tgl_last_jual='2026-11-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1TE-ZIXD-42-T' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'10.080',berat_jual_asli=berat_jual_asli+'10.080',stock_jual='1',berat_akhir=berat_akhir-'10.080',berat_akhir_asli=berat_akhir_asli-'10.080',stock_akhir='0' WHERE tanggal='2026-11-01' AND kode_barang='H1TE-ZIXD-42-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PT-H' AND stock_akhir > 0 LIMIT 1; INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326010931301','2026-11-01','10.080','2026-11-01','09:31:30','PLG0032151','18750000','18750000','0','18750000','18750000','input','2026-11-01 09:31:30','F32601093130'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-11-01','F326010931301','2026-11-01','09:31:30','SIN','18750000','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-261101-0003','D','2026-11-01','09:31:30','input','PENJUALAN','F326010931301','8043031000','18750000','8061781000'); 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 ('F326010950031','input','1',' MEH1 HW 42','TOKO','PM-H','H1E-ZIXI-61-0','KL FLIK HW 42CM 8K ','','6.030','1','100.00','6090000','0','0','15000','6090000','0','0','0','6090000','LIS','00422598','H1E','0','0','-','0','1020000'); UPDATE tm_barang SET tgl_last_jual='2026-11-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZIXI-61-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'6.030',berat_jual_asli=berat_jual_asli+'6.030',stock_jual='1',berat_akhir=berat_akhir-'6.030',berat_akhir_asli=berat_akhir_asli-'6.030',stock_akhir='0' WHERE tanggal='2026-11-01' AND kode_barang='H1E-ZIXI-61-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 ('F326010950031','2026-11-01','6.030','2026-11-01','09:50:04','PLG0032152','6090000','6090000','0','6090000','6090000','input','2026-11-01 09:50:03','F32601095003'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-11-01','F326010950031','2026-11-01','09:50:04','LIS','6090000','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-261101-0004','D','2026-11-01','09:50:04','input','PENJUALAN','F326010950031','8061781000','6090000','8067871000','OPEN'); UPDATE tt_jual_head SET dibayar_rp='6090000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326010950031' 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 ('F326010950032','input',' 1',' MEB1 XXX C','TOKO','PM-B','B1E-ZJXH-53-0','GW XXX MODEL MATA CM PE 8K','','0.720','1','100.00','727000','0','0','15000','705000','0','0','0','705000','LIS','00428541','B1E','0','0','-','1','1020000'); UPDATE tm_barang SET tgl_last_jual='2026-11-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1E-ZJXH-53-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.720',berat_jual_asli=berat_jual_asli+'0.720',stock_jual='1',berat_akhir=berat_akhir-'0.720',berat_akhir_asli=berat_akhir_asli-'0.720',stock_akhir='0' WHERE tanggal='2026-11-01' AND kode_barang='B1E-ZJXH-53-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 ('F326010950032','2026-11-01','0.720','2026-11-01','09:50:04','PLG0032153','705000','705000','0','705000','705000','input','2026-11-01 09:50:03','F32601095003'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-11-01','F326010950032','2026-11-01','09:50:04','LIS','705000','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-261101-0005','D','2026-11-01','09:50:04','input','PENJUALAN','F326010950032','8067871000','705000','8068576000','OPEN'); UPDATE tt_jual_head SET dibayar_rp='705000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326010950032' 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 ('F326010952081','input','1',' MEF3E X UB','TOKO','PM-F','F3E-ZJCX-86-0','GL X SANTA UB 8K ','','0.720','1','100.00','734000','0','0','15000','728000','0','0','0','728000','SIN','00432312','F3E','0','0','-','1','1020000'); UPDATE tm_barang SET tgl_last_jual='2026-11-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZJCX-86-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.720',berat_jual_asli=berat_jual_asli+'0.720',stock_jual='1',berat_akhir=berat_akhir-'0.720',berat_akhir_asli=berat_akhir_asli-'0.720',stock_akhir='0' WHERE tanggal='2026-11-01' AND kode_barang='F3E-ZJCX-86-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 ('F326010952081','2026-11-01','0.720','2026-11-01','09:52:09','PLG0032154','728000','728000','0','728000','728000','input','2026-11-01 09:52:08','F32601095208'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-11-01','F326010952081','2026-11-01','09:52:09','SIN','728000','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-261101-0006','D','2026-11-01','09:52:09','input','PENJUALAN','F326010952081','8068576000','728000','8069304000'); 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-00020703','X-00020703','GL X OVAL C SLEP YT 54 8K','GR','---','F1E','BELI','BELI001','3130000','2026-11-01','3.300','1','kasir','2026-11-01 10:15:51'); DELETE FROM tp_barang WHERE kode_dept = 'X-F1E'; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F1E','X-00020703','X-00020703'); 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-261101-0001','F326190828582','AAT','1','BELI','BELI001','F1E', 'X-00020703', 'GL X OVAL C SLEP YT 54 8K','3.300','3.300','100.00','3498000','3130000','948485','1020000','1','3130000','3130000','CUCI'); UPDATE tt_barang_saldo SET berat_beli=berat_beli+'3.300',berat_beli_asli=berat_beli_asli+'3.300',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'3.300',berat_akhir_asli=berat_akhir_asli+'3.300',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-11-01' 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-261101-0001','2026-11-01','2026-11-01','10:15:50','AAT','---','3.300','3130000','3130000','3130000','3130000','3130000','kasir','2026-11-01 10:15:51','FB-261101-0001'); INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261101-0001','LENA','NAWANGAN PACITAN','','','081233535956','kasir','2026-11-01 10:15:51'); SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-11-01' 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-261101-0007','K','2026-11-01','10:15:50','kasir','PEMBELIAN UMUM','FB-261101-0001','8069304000','3130000','8066174000'); 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-00020704','X-00020704','CC MODEL SPIRAL ARESO SLEP KH 10 8K','GR','---','E1E','BELI','BELI001','385000','2026-11-01','0.410','1','kasir','2026-11-01 10:16:10'); DELETE FROM tp_barang WHERE kode_dept = 'X-E1E'; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E1E','X-00020704','X-00020704'); 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-261101-0002','F326300226561','LIS','1','BELI','BELI001','E1E', 'X-00020704', 'CC MODEL SPIRAL ARESO SLEP KH 10 8K','0.410','0.410','100.00','430000','385000','939024','1020000','1','385000','385000','CUCI'); UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.410',berat_beli_asli=berat_beli_asli+'0.410',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.410',berat_akhir_asli=berat_akhir_asli+'0.410',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-11-01' 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-261101-0002','2026-11-01','2026-11-01','10:16:09','LIS','---','0.410','385000','385000','385000','385000','385000','kasir','2026-11-01 10:16:10','FB-261101-0002'); INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261101-0002','EVA','POHIJO SAMPUNG','','','085336449649','kasir','2026-11-01 10:16:10'); SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-11-01' 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-261101-0008','K','2026-11-01','10:16:09','kasir','PEMBELIAN UMUM','FB-261101-0002','8066174000','385000','8065789000'); 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-00020705','X-00020705','GL ANAK BANGKOK KACA SLEP PM 38 8K','GR','---','F1E','BELI','BELI001','1482000','2026-11-01','1.580','1','kasir','2026-11-01 10:16:24'); DELETE FROM tp_barang WHERE kode_dept = 'X-F1E'; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F1E','X-00020705','X-00020705'); 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-261101-0003','F326300301302','AAT','1','BELI','BELI001','F1E', 'X-00020705', 'GL ANAK BANGKOK KACA SLEP PM 38 8K','1.580','1.580','100.00','1659000','1482000','937975','1020000','1','1482000','1482000','CUCI'); UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.580',berat_beli_asli=berat_beli_asli+'1.580',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.580',berat_akhir_asli=berat_akhir_asli+'1.580',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-11-01' 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-261101-0003','2026-11-01','2026-11-01','10:16:24','AAT','---','1.580','1482000','1482000','1482000','1482000','1482000','kasir','2026-11-01 10:16:24','FB-261101-0003'); INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261101-0003','ATQA','KELORAN JOHO','','','','kasir','2026-11-01 10:16:24'); SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-11-01' 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-261101-0009','K','2026-11-01','10:16:24','kasir','PEMBELIAN UMUM','FB-261101-0003','8065789000','1482000','8064307000'); 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-00020706','X-00020706','CC X MODEL SLEP LG 14 8K','GR','---','E1F','BELI','BELI001','300000','2026-11-01','0.320','1','kasir','2026-11-01 10:19:22'); DELETE FROM tp_barang WHERE kode_dept = 'X-E1F'; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E1F','X-00020706','X-00020706'); 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-261101-0004','F326021149111','SIN','1','BELI','BELI001','E1F', 'X-00020706', 'CC X MODEL SLEP LG 14 8K','0.320','0.320','100.00','341000','300000','937500','1040000','1','300000','300000','CUCI'); UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.320',berat_beli_asli=berat_beli_asli+'0.320',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.320',berat_akhir_asli=berat_akhir_asli+'0.320',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-11-01' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E1F' LIMIT 1; INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-261101-0004','2026-11-01','2026-11-01','10:19:22','SIN','---','0.320','300000','300000','300000','300000','300000','kasir','2026-11-01 10:19:22','FB-261101-0004'); INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261101-0004','RATIH','KISMANTORO','','','081234150371','kasir','2026-11-01 10:19:22'); SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-11-01' 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-261101-0010','K','2026-11-01','10:19:22','kasir','PEMBELIAN UMUM','FB-261101-0004','8064307000','300000','8064007000'); 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 ('F326011033531','kasir','1',' MEH1 X KH ','TOKO','PM-H','H1E-ZHBF-126-0','KL X NORI ANAK KH 34 8K ','','1.610','1','100.00','1626000','0','0','15000','1626000','0','0','0','1626000','SIN','00420498','H1E','0','0','-','0','1020000'); UPDATE tm_barang SET tgl_last_jual='2026-11-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZHBF-126-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.610',berat_jual_asli=berat_jual_asli+'1.610',stock_jual='1',berat_akhir=berat_akhir-'1.610',berat_akhir_asli=berat_akhir_asli-'1.610',stock_akhir='0' WHERE tanggal='2026-11-01' AND kode_barang='H1E-ZHBF-126-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 ('F326011033531','2026-11-01','1.610','2026-11-01','10:33:53','PLG0032155','1626000','1626000','0','1626000','1626000','kasir','2026-11-01 10:33:53','F32601103353'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-11-01','F326011033531','2026-11-01','10:33:53','SIN','1626000','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-261101-0011','D','2026-11-01','10:33:53','kasir','PENJUALAN','F326011033531','8064007000','1626000','8065633000','OPEN'); UPDATE tt_jual_head SET dibayar_rp='1626000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326011033531' 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 ('F326011033532','kasir',' 1',' MED2 X LG ','TOKO','PM-D','D2E-ZJAF-100-0','LT X MODEL HURUF MATA LG A 8K ','','0.560','1','100.00','566000','0','0','15000','566000','0','0','0','566000','SIN','00430279','D2E','0','0','-','0','1020000'); UPDATE tm_barang SET tgl_last_jual='2026-11-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D2E-ZJAF-100-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-11-01' AND kode_barang='D2E-ZJAF-100-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 ('F326011033532','2026-11-01','0.560','2026-11-01','10:33:53','PLG0032156','566000','566000','0','566000','566000','kasir','2026-11-01 10:33:53','F32601103353'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-11-01','F326011033532','2026-11-01','10:33:53','SIN','566000','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-261101-0012','D','2026-11-01','10:33:53','kasir','PENJUALAN','F326011033532','8065633000','566000','8066199000','OPEN'); UPDATE tt_jual_head SET dibayar_rp='566000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326011033532' 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 ('F326011102471','kasir','1',' MEF3E X UB','TOKO','PM-F','F3E-ZIAD-89-0','GL X RANTAI HOLLOW P3 SLEP UB 8K ','','1.010','1','100.00','1020000','0','0','15000','1020000','0','0','0','1020000','LIS','00423449','F3E','0','0','-','0','1020000'); UPDATE tm_barang SET tgl_last_jual='2026-11-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZIAD-89-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.010',berat_jual_asli=berat_jual_asli+'1.010',stock_jual='1',berat_akhir=berat_akhir-'1.010',berat_akhir_asli=berat_akhir_asli-'1.010',stock_akhir='0' WHERE tanggal='2026-11-01' AND kode_barang='F3E-ZIAD-89-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-F' AND stock_akhir > 0 LIMIT 1; INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326011102471','2026-11-01','1.010','2026-11-01','11:02:48','PLG0032157','1020000','1020000','0','1020000','1020000','kasir','2026-11-01 11:02:47','F32601110247'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-11-01','F326011102471','2026-11-01','11:02:48','LIS','1020000','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-261101-0013','D','2026-11-01','11:02:48','kasir','PENJUALAN','F326011102471','8066199000','1020000','8067219000'); 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 ('F326011139391','kasir','1',' MDE1 CM 20','TOKO','PM-E','E1D-ZGBA-319-0','CC COR VELG POLOS 20 CM 8K ','','1.560','1','100.00','1544000','0','0','15000','1545000','0','0','0','1545000','FIT','00414801','E1D','0','0','-','0','1000000'); UPDATE tm_barang SET tgl_last_jual='2026-11-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-ZGBA-319-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.560',berat_jual_asli=berat_jual_asli+'1.560',stock_jual='1',berat_akhir=berat_akhir-'1.560',berat_akhir_asli=berat_akhir_asli-'1.560',stock_akhir='0' WHERE tanggal='2026-11-01' AND kode_barang='E1D-ZGBA-319-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 ('F326011139391','2026-11-01','1.560','2026-11-01','11:39:39','PLG0032158','1545000','1545000','0','1545000','1545000','kasir','2026-11-01 11:39:39','F32601113939'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-11-01','F326011139391','2026-11-01','11:39:39','FIT','1545000','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-261101-0014','D','2026-11-01','11:39:39','kasir','PENJUALAN','F326011139391','8067219000','1545000','8068764000','OPEN'); UPDATE tt_jual_head SET dibayar_rp='1545000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326011139391' 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 ('F326011139392','kasir',' 1',' MDE2 10K C','TOKO','PM-E','E2D-ZJBX-31-0','CC WEDDING MATA 10 CM 8K ','','1.520','1','100.00','1505000','0','0','15000','1505000','0','10000','0','1515000','FIT','00430630','E2D','0','0','-','0','1000000'); UPDATE tm_barang SET tgl_last_jual='2026-11-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZJBX-31-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.520',berat_jual_asli=berat_jual_asli+'1.520',stock_jual='1',berat_akhir=berat_akhir-'1.520',berat_akhir_asli=berat_akhir_asli-'1.520',stock_akhir='0' WHERE tanggal='2026-11-01' AND kode_barang='E2D-ZJBX-31-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 ('F326011139392','2026-11-01','1.520','2026-11-01','11:39:39','PLG0032159','1505000','1505000','10000','1515000','1515000','kasir','2026-11-01 11:39:39','F32601113939'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-11-01','F326011139392','2026-11-01','11:39:39','FIT','1515000','10000'); INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-261101-0015','D','2026-11-01','11:39:39','kasir','PENJUALAN','F326011139392','8068764000','1515000','8070279000','OPEN'); UPDATE tt_jual_head SET dibayar_rp='1515000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326011139392' 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 ('F326011147071','kasir','1',' MEB1 LG PE','TOKO','PM-B','B1E-ZJBH-191-0','GW TUSUK MODEL KUPU MATA LG PE 8K ','','0.600','1','100.00','606000','0','0','15000','605000','0','0','0','605000','FIT','00431958','B1E','0','0','-','1','1020000'); UPDATE tm_barang SET tgl_last_jual='2026-11-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1E-ZJBH-191-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.600',berat_jual_asli=berat_jual_asli+'0.600',stock_jual='1',berat_akhir=berat_akhir-'0.600',berat_akhir_asli=berat_akhir_asli-'0.600',stock_akhir='0' WHERE tanggal='2026-11-01' AND kode_barang='B1E-ZJBH-191-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 ('F326011147071','2026-11-01','0.600','2026-11-01','11:47:08','PLG0032160','605000','605000','0','605000','605000','kasir','2026-11-01 11:47:07','F32601114707'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-11-01','F326011147071','2026-11-01','11:47:08','FIT','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) VALUES ('KM-261101-0016','D','2026-11-01','11:47:08','kasir','PENJUALAN','F326011147071','8070279000','605000','8070884000'); 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 ('F326011237331','kasir','1',' MEF3 HW ','TOKO','PM-F','F3E-ZJBF-89-0','GL FANCY MODEL BOLA ARESO HW 8K ','','2.770','1','100.00','2798000','0','0','15000','2800000','0','0','0','2800000','AAT','00431173','F3E','0','0','-','0','1020000'); UPDATE tm_barang SET tgl_last_jual='2026-11-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZJBF-89-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.770',berat_jual_asli=berat_jual_asli+'2.770',stock_jual='1',berat_akhir=berat_akhir-'2.770',berat_akhir_asli=berat_akhir_asli-'2.770',stock_akhir='0' WHERE tanggal='2026-11-01' AND kode_barang='F3E-ZJBF-89-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-F' AND stock_akhir > 0 LIMIT 1; INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326011237331','2026-11-01','2.770','2026-11-01','12:37:34','PLG0032161','2800000','2800000','0','2800000','2800000','kasir','2026-11-01 12:37:33','F32601123733'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-11-01','F326011237331','2026-11-01','12:37:34','AAT','2800000','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-261101-0017','D','2026-11-01','12:37:34','kasir','PENJUALAN','F326011237331','8070884000','2800000','8073684000'); 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 ('F326011249321','kasir','1',' MFD1 LG ','TOKO','PM-D','D1F-ZEXF-142-0','LT SLOBOK BOLA ARESO LG 8K ','GT P65','0.370','1','100.00','381000','0','0','15000','382000','0','30000','0','412000','LIS','00402527','D1F','0','0','-','0','1040000'); UPDATE tm_barang SET tgl_last_jual='2026-11-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1F-ZEXF-142-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.370',berat_jual_asli=berat_jual_asli+'0.370',stock_jual='1',berat_akhir=berat_akhir-'0.370',berat_akhir_asli=berat_akhir_asli-'0.370',stock_akhir='0' WHERE tanggal='2026-11-01' AND kode_barang='D1F-ZEXF-142-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 ('F326011249321','2026-11-01','0.370','2026-11-01','12:49:33','PLG0032162','382000','382000','30000','412000','412000','kasir','2026-11-01 12:49:32','F32601124932'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-11-01','F326011249321','2026-11-01','12:49:33','LIS','412000','30000'); 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-261101-0018','D','2026-11-01','12:49:33','kasir','PENJUALAN','F326011249321','8073684000','412000','8074096000'); 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-00020707','X-00020707','GL OVAL MODEL AUREL MATA LT D56 8K','GR','---','F2E','BELI','BELI001','1570000','2026-11-01','2.280','1','kasir','2026-11-01 12:53:10'); DELETE FROM tp_barang WHERE kode_dept = 'X-F2E'; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F2E','X-00020707','X-00020707'); 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-261101-0005','F324261019531','AAT','1','BELI','BELI001','F2E', 'X-00020707', 'GL OVAL MODEL AUREL MATA LT D56 8K','2.280','2.280','100.00','1495000','1570000','688596','1020000','1','1570000','1570000','CUCI'); UPDATE tt_barang_saldo SET berat_beli=berat_beli+'2.280',berat_beli_asli=berat_beli_asli+'2.280',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'2.280',berat_akhir_asli=berat_akhir_asli+'2.280',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-11-01' 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-261101-0005','2026-11-01','2026-11-01','12:53:09','AAT','---','2.280','1570000','1570000','1570000','1570000','1570000','kasir','2026-11-01 12:53:10','FB-261101-0005'); INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261101-0005','ANA','KEPUH SOCO SLOGOHIMO','','','','kasir','2026-11-01 12:53:10'); SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-11-01' 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-261101-0019','K','2026-11-01','12:53:09','kasir','PEMBELIAN UMUM','FB-261101-0005','8074096000','1570000','8072526000'); 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-00020708','X-00020708','GL FLIK SLEP UB 8K','GR','---','F3E','BELI','BELI001','1282000','2026-11-01','1.820','1','kasir','2026-11-01 12:53:10'); DELETE FROM tp_barang WHERE kode_dept = 'X-F3E'; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F3E','X-00020708','X-00020708'); 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-261101-0006','F324261019532','AAT','2','BELI','BELI001','F3E', 'X-00020708', 'GL FLIK SLEP UB 8K','1.820','1.820','100.00','1195000','1282000','704396','1020000','1','1282000','1282000','CUCI'); UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.820',berat_beli_asli=berat_beli_asli+'1.820',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.820',berat_akhir_asli=berat_akhir_asli+'1.820',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-11-01' 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-261101-0006','2026-11-01','2026-11-01','12:53:09','AAT','---','1.820','1282000','1282000','1282000','1282000','1282000','kasir','2026-11-01 12:53:10','FB-261101-0005'); INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261101-0006','ANA','KEPUH SOCO SLOGOHIMO','','','','kasir','2026-11-01 12:53:10'); SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-11-01' 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-261101-0020','K','2026-11-01','12:53:09','kasir','PEMBELIAN UMUM','FB-261101-0006','8072526000','1282000','8071244000'); 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 ('F326010115071','kasir','1',' MEF3 HW ','TOKO','PM-F','F3E-ZJBH-171-0','GL HARLEY MODEL DAUN SLEP HW 8K ','','1.740','1','100.00','1757000','0','0','15000','1758000','0','0','0','1758000','FIT','00431937','F3E','0','0','-','0','1020000'); UPDATE tm_barang SET tgl_last_jual='2026-11-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZJBH-171-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.740',berat_jual_asli=berat_jual_asli+'1.740',stock_jual='1',berat_akhir=berat_akhir-'1.740',berat_akhir_asli=berat_akhir_asli-'1.740',stock_akhir='0' WHERE tanggal='2026-11-01' AND kode_barang='F3E-ZJBH-171-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 ('F326010115071','2026-11-01','1.740','2026-11-01','13:15:08','PLG0032163','1758000','1758000','0','1758000','1758000','kasir','2026-11-01 13:15:07','F32601011507'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-11-01','F326010115071','2026-11-01','13:15:08','FIT','1758000','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-261101-0021','D','2026-11-01','13:15:08','kasir','PENJUALAN','F326010115071','8071244000','1758000','8073002000'); 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 ('F326010119321','kasir','1',' MFE1 KH 14','TOKO','PM-E','E1F-ZJBF-211-0','CC MODEL TINJU DAUN SLEP KH 14 8K ','','0.400','1','100.00','412000','0','0','15000','412000','0','0','0','412000','FIT','00431298','E1F','0','0','-','0','1040000'); UPDATE tm_barang SET tgl_last_jual='2026-11-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1F-ZJBF-211-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.400',berat_jual_asli=berat_jual_asli+'0.400',stock_jual='1',berat_akhir=berat_akhir-'0.400',berat_akhir_asli=berat_akhir_asli-'0.400',stock_akhir='0' WHERE tanggal='2026-11-01' AND kode_barang='E1F-ZJBF-211-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 ('F326010119321','2026-11-01','0.400','2026-11-01','13:19:32','PLG0032164','412000','412000','0','412000','412000','kasir','2026-11-01 13:19:32','F32601011932'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-11-01','F326010119321','2026-11-01','13:19:32','FIT','412000','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-261101-0022','D','2026-11-01','13:19:32','kasir','PENJUALAN','F326010119321','8073002000','412000','8073414000'); 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-00020709','X-00020709','GL LEMES 8K','GR','---','F3E','BELI','BELI001','1295000','2026-11-01','1.380','1','kasir','2026-11-01 13:43:38'); DELETE FROM tp_barang WHERE kode_dept = 'X-F3E'; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F3E','X-00020709','X-00020709'); 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-261101-0007','00403424','FIT','1','BELI','BELI001','F3E', 'X-00020709', 'GL LEMES 8K','1.380','1.380','100.00','1450000','1295000','938406','1020000','1','1295000','1295000','CUCI'); UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.380',berat_beli_asli=berat_beli_asli+'1.380',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.380',berat_akhir_asli=berat_akhir_asli+'1.380',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-11-01' 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-261101-0007','2026-11-01','2026-11-01','13:43:37','FIT','---','1.380','1295000','1295000','1295000','1295000','1295000','kasir','2026-11-01 13:43:38','FB-261101-0007'); INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261101-0007','FEBRIANA','BITING PURWANTORO','','','','kasir','2026-11-01 13:43:38'); SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-11-01' 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-261101-0023','K','2026-11-01','13:43:37','kasir','PEMBELIAN UMUM','FB-261101-0007','8073414000','1295000','8072119000'); 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 ('F326010200001','kasir','1',' MEB1 LG PE','TOKO','PM-B','B1E-ZJBH-193-0','GW TUSUK MODEL PITA MATA LG PE 8K ','','0.570','1','100.00','576000','0','0','15000','575000','0','0','0','575000','LIS','00431960','B1E','0','0','-','1','1020000'); UPDATE tm_barang SET tgl_last_jual='2026-11-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1E-ZJBH-193-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.570',berat_jual_asli=berat_jual_asli+'0.570',stock_jual='1',berat_akhir=berat_akhir-'0.570',berat_akhir_asli=berat_akhir_asli-'0.570',stock_akhir='0' WHERE tanggal='2026-11-01' AND kode_barang='B1E-ZJBH-193-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 ('F326010200001','2026-11-01','0.570','2026-11-01','14:00:00','PLG0032165','575000','575000','0','575000','575000','kasir','2026-11-01 14:00:00','F32601020000'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-11-01','F326010200001','2026-11-01','14:00:00','LIS','575000','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-261101-0024','D','2026-11-01','14:00:00','kasir','PENJUALAN','F326010200001','8072119000','575000','8072694000'); 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 ('F326010216041','kasir','1',' MEF3E X YT','TOKO','PM-F','F3E-ZIBE-125-0','GL X CAPELLA SPECTRA VAR YT 8K ','','2.620','1','100.00','2646000','0','0','15000','2646000','0','0','0','2646000','FIT','00425500','F3E','0','0','-','0','1020000'); UPDATE tm_barang SET tgl_last_jual='2026-11-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZIBE-125-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.620',berat_jual_asli=berat_jual_asli+'2.620',stock_jual='1',berat_akhir=berat_akhir-'2.620',berat_akhir_asli=berat_akhir_asli-'2.620',stock_akhir='0' WHERE tanggal='2026-11-01' AND kode_barang='F3E-ZIBE-125-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 ('F326010216041','2026-11-01','2.620','2026-11-01','14:16:04','PLG0032166','2646000','2646000','0','2646000','2646000','kasir','2026-11-01 14:16:04','F32601021604'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-11-01','F326010216041','2026-11-01','14:16:04','FIT','2646000','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-261101-0025','D','2026-11-01','14:16:04','kasir','PENJUALAN','F326010216041','8072694000','2646000','8075340000'); 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-00020710','X-00020710','CC MODEL SNAKE MATA VAR KH 20 8K','GR','---','E2E','BELI','BELI001','422000','2026-11-01','0.460','1','kasir','2026-11-01 14:18:07'); DELETE FROM tp_barang WHERE kode_dept = 'X-E2E'; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2E','X-00020710','X-00020710'); 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-261101-0008','F326300211192','SIN','1','BELI','BELI001','E2E', 'X-00020710', 'CC MODEL SNAKE MATA VAR KH 20 8K','0.460','0.460','100.00','470000','422000','917391','1020000','1','422000','422000','CUCI'); UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.460',berat_beli_asli=berat_beli_asli+'0.460',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.460',berat_akhir_asli=berat_akhir_asli+'0.460',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-11-01' 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-261101-0008','2026-11-01','2026-11-01','14:18:07','SIN','---','0.460','422000','422000','422000','422000','422000','kasir','2026-11-01 14:18:07','FB-261101-0008'); INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261101-0008','PUJI ASTUTI','SUGIHAN BULUKERTO','','','','kasir','2026-11-01 14:18:07'); SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-11-01' 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-261101-0026','K','2026-11-01','14:18:07','kasir','PEMBELIAN UMUM','FB-261101-0008','8075340000','422000','8074918000'); 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-00020711','X-00020711','CC MODEL PAKU MATA KH 18 8K','GR','---','E2E','BELI','BELI001','375000','2026-11-01','0.410','1','kasir','2026-11-01 14:18:07'); DELETE FROM tp_barang WHERE kode_dept = 'X-E2E'; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2E','X-00020711','X-00020711'); 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-261101-0009','F326300211191','SIN','2','BELI','BELI001','E2E', 'X-00020711', 'CC MODEL PAKU MATA KH 18 8K','0.410','0.410','100.00','418000','375000','914634','1020000','1','375000','375000','CUCI'); UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.410',berat_beli_asli=berat_beli_asli+'0.410',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.410',berat_akhir_asli=berat_akhir_asli+'0.410',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-11-01' 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-261101-0009','2026-11-01','2026-11-01','14:18:07','SIN','---','0.410','375000','375000','375000','375000','375000','kasir','2026-11-01 14:18:07','FB-261101-0008'); INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261101-0009','PUJI ASTUTI','SUGIHAN BULUKERTO','','','','kasir','2026-11-01 14:18:07'); SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-11-01' 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-261101-0027','K','2026-11-01','14:18:07','kasir','PEMBELIAN UMUM','FB-261101-0009','8074918000','375000','8074543000'); 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 ('F326010239271','kasir','1',' MDA1 LG ','TOKO','PM-A','A1D-ZJBH-226-0','AT MODEL KUPU MATA VAR LG 8K ','','1.060','1','100.00','1049000','0','0','15000','1050000','0','0','0','1050000','SIN','00431996','A1D','0','0','-','0','1000000'); UPDATE tm_barang SET tgl_last_jual='2026-11-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1D-ZJBH-226-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.060',berat_jual_asli=berat_jual_asli+'1.060',stock_jual='1',berat_akhir=berat_akhir-'1.060',berat_akhir_asli=berat_akhir_asli-'1.060',stock_akhir='0' WHERE tanggal='2026-11-01' AND kode_barang='A1D-ZJBH-226-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-A' AND stock_akhir > 0 LIMIT 1; INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326010239271','2026-11-01','1.060','2026-11-01','14:39:28','PLG0032167','1050000','1050000','0','1050000','1050000','kasir','2026-11-01 14:39:27','F32601023927'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-11-01','F326010239271','2026-11-01','14:39:28','SIN','1050000','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-261101-0028','D','2026-11-01','14:39:28','kasir','PENJUALAN','F326010239271','8074543000','1050000','8075593000'); 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-00020712','X-00020712','AT X HUGGIES KLIP BOLA ARESO UB 8K','GR','---','A1F','BELI','BELI001','1355000','2026-11-01','1.400','1','kasir','2026-11-01 14:45:52'); DELETE FROM tp_barang WHERE kode_dept = 'X-A1F'; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-A1F','X-00020712','X-00020712'); 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-261101-0010','F326250124421','SIN','1','BELI','BELI001','A1F', 'X-00020712', 'AT X HUGGIES KLIP BOLA ARESO UB 8K','1.400','1.400','100.00','1463000','1355000','967857','1040000','1','1355000','1355000','CUCI'); UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.400',berat_beli_asli=berat_beli_asli+'1.400',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.400',berat_akhir_asli=berat_akhir_asli+'1.400',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-11-01' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='A1F' 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-261101-0010','2026-11-01','2026-11-01','14:45:51','SIN','---','1.400','1355000','1355000','1355000','1355000','1355000','kasir','2026-11-01 14:45:52','FB-261101-0010'); INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261101-0010','ZAHRA','KISMANTORO','','','083173371210','kasir','2026-11-01 14:45:52'); SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-11-01' 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-261101-0029','K','2026-11-01','14:45:51','kasir','PEMBELIAN UMUM','FB-261101-0010','8075593000','1355000','8074238000'); UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261101-0001' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261101-0001'; UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261101-0002' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261101-0002'; UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261101-0003' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261101-0003'; UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261101-0004' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261101-0004'; UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261101-0005' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261101-0005'; UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261101-0006' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261101-0006'; UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261101-0007' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261101-0007'; UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261101-0008' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261101-0008'; UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261101-0009' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261101-0009'; UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261101-0010' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261101-0010'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326010115071' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326010115071' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326010115071'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326010119321' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326010119321' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326010119321'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326010200001' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326010200001' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326010200001'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326010216041' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326010216041' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326010216041'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326010239271' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326010239271' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326010239271'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326010831511' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326010831511' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326010831511'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326010931301' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326010931301' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326010931301'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326010950031' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326010950031' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326010950031'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326010950032' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326010950032' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326010950032'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326010952081' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326010952081' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326010952081'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326011033531' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326011033531' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326011033531'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326011033532' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326011033532' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326011033532'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326011102471' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326011102471' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326011102471'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326011139391' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326011139391' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326011139391'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326011139392' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326011139392' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326011139392'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326011147071' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326011147071' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326011147071'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326011237331' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326011237331' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326011237331'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326011249321' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326011249321' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326011249321'; INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-11-02','0','0','0','0','0','0'); DELETE FROM th_barang_saldo WHERE tanggal <= '2026-10-02'; INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-11-01'; UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-11-01'; INSERT INTO tt_barang_saldo (kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_awal,berat_awal_asli,stock_awal,berat_akhir,berat_akhir_asli,stock_akhir) SELECT kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_akhir,berat_akhir_asli,stock_akhir,berat_akhir,berat_akhir_asli,stock_akhir FROM tt_barang_saldo WHERE tanggal='2026-11-01' AND berat_akhir*1 > '0' INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-11-01'; DELETE FROM tt_cash_daily WHERE tanggal <= '2026-11-01'; INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-11-01'; DELETE FROM tt_bank_daily WHERE tanggal <= '2026-11-01'; CREATE TABLE IF NOT EXISTS th_barang_saldo_202610 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-10'; DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-10'; UPDATE tt_barang_saldo SET tanggal= '2026-11-02' WHERE status_close ='OPEN'; DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-11-01' 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-261102-0001','D','2026-11-02','15:10:36','SYSTEM','SALDO AWAL','SALDO AWAL','0','8074238000','8074238000'); 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-261102-0001','D','2026-11-02','15:10:36','BCA','SALDO AWAL','SALDO AWAL','0','748085000','748085000'); 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-261102-0001','D','2026-11-02','15:10:36','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-261102-0001','D','2026-11-02','15:10:36','BRI','SALDO AWAL','SALDO AWAL','0','0','0'); UPDATE tp_system SET tgl_system='2026-11-02';