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 ('F326041049501','input','1',' MDE1 X CM ','TOKO','PM-E','E1D-ZDAX-268-0','CC X WEDDING POLOS CM 20 8K ','','1.460','1','100.00','1584000','0','0','15000','1585000','0','0','0','1585000','LIS','00399038','E1D','0','0','-','0','1095000');
UPDATE tm_barang SET tgl_last_jual='2026-05-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-ZDAX-268-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.460',berat_jual_asli=berat_jual_asli+'1.460',stock_jual='1',berat_akhir=berat_akhir-'1.460',berat_akhir_asli=berat_akhir_asli-'1.460',stock_akhir='0' WHERE tanggal='2026-05-04' AND kode_barang='E1D-ZDAX-268-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 ('F326041049501','2026-05-04','1.460','2026-05-04','10:49:50','PLG0028984','1585000','1585000','0','1585000','1585000','input','2026-05-04 10:49:50','F32604104950');
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-05-04','F326041049501','2026-05-04','10:49:50','LIS','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-260504-0002','D','2026-05-04','10:49:50','input','PENJUALAN','F326041049501','4800987000','1585000','4802572000');
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 ('F326041056411','input','1',' TAA0 X DG ','TOKO','PT-A','A0TA-YJBH-63-T','AT X TINDIK BABY DG 17K ','','0.480','1','100.00','926000','0','0','15000','925000','0','0','0','925000','AAT','T0074545','A0TA','0','0','-','1','1930000');
UPDATE tm_barang SET tgl_last_jual='2026-05-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A0TA-YJBH-63-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.480',berat_jual_asli=berat_jual_asli+'0.480',stock_jual='1',berat_akhir=berat_akhir-'0.480',berat_akhir_asli=berat_akhir_asli-'0.480',stock_akhir='0' WHERE tanggal='2026-05-04' AND kode_barang='A0TA-YJBH-63-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PT-A' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326041056411','2026-05-04','0.480','2026-05-04','10:56:41','PLG0028985','925000','925000','0','925000','925000','input','2026-05-04 10:56:41','F32604105641');
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-05-04','F326041056411','2026-05-04','10:56:41','AAT','925000','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-260504-0003','D','2026-05-04','10:56:41','input','PENJUALAN','F326041056411','4802572000','925000','4803497000');
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-00018996','X-00018996','LT X MODEL SPECTRA SLEP UB 8K','GR','---','D1E','BELI','BELI001','502000','2026-05-04','0.520','1','kasir','2026-05-04 11:12:04');
DELETE FROM tp_barang WHERE kode_dept = 'X-D1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-D1E','X-00018996','X-00018996');
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-260504-0001','F325130928021','SIN','1','BELI','BELI001','D1E', 'X-00018996', 'LT X MODEL SPECTRA SLEP UB 8K','0.520','0.520','100.00','540000','502000','965385','1105000','1','502000','502000','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-05-04' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='D1E' 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-260504-0001','2026-05-04','2026-05-04','11:12:03','SIN','---','0.520','502000','502000','502000','502000','502000','kasir','2026-05-04 11:12:04','FB-260504-0001');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260504-0001','DWI VERA','NADI BULUKERTO','','','','kasir','2026-05-04 11:12:04');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-05-04' 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-260504-0004','K','2026-05-04','11:12:03','kasir','PEMBELIAN UMUM','FB-260504-0001','4803497000','502000','4802995000');
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-00018997','X-00018997','GL MODEL FLIK VAR HW 8K','GR','---','F3E','BELI','BELI001','1347000','2026-05-04','1.410','1','kasir','2026-05-04 11:12:04');
DELETE FROM tp_barang WHERE kode_dept = 'X-F3E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F3E','X-00018997','X-00018997');
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-260504-0002','F325130929231','SIN','2','BELI','BELI001','F3E', 'X-00018997', 'GL MODEL FLIK VAR HW 8K','1.410','1.410','100.00','1465000','1347000','955319','1105000','1','1347000','1347000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.410',berat_beli_asli=berat_beli_asli+'1.410',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.410',berat_akhir_asli=berat_akhir_asli+'1.410',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-05-04' 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-260504-0002','2026-05-04','2026-05-04','11:12:03','SIN','---','1.410','1347000','1347000','1347000','1347000','1347000','kasir','2026-05-04 11:12:04','FB-260504-0001');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260504-0002','DWI VERA','NADI BULUKERTO','','','','kasir','2026-05-04 11:12:04');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-05-04' 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-260504-0005','K','2026-05-04','11:12:03','kasir','PEMBELIAN UMUM','FB-260504-0002','4802995000','1347000','4801648000');
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-00018998','X-00018998','KL X GUCCI UB 44 8K','GR','---','H1E','BELI','BELI001','1887000','2026-05-04','1.950','1','kasir','2026-05-04 11:12:04');
DELETE FROM tp_barang WHERE kode_dept = 'X-H1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-H1E','X-00018998','X-00018998');
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-260504-0003','F325130925521','SIN','3','BELI','BELI001','H1E', 'X-00018998', 'KL X GUCCI UB 44 8K','1.950','1.950','100.00','2030000','1887000','967692','1105000','1','1887000','1887000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.950',berat_beli_asli=berat_beli_asli+'1.950',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.950',berat_akhir_asli=berat_akhir_asli+'1.950',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-05-04' 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-260504-0003','2026-05-04','2026-05-04','11:12:03','SIN','---','1.950','1887000','1887000','1887000','1887000','1887000','kasir','2026-05-04 11:12:04','FB-260504-0001');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260504-0003','DWI VERA','NADI BULUKERTO','','','081228001402','kasir','2026-05-04 11:12:04');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-05-04' 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-260504-0006','K','2026-05-04','11:12:03','kasir','PEMBELIAN UMUM','FB-260504-0003','4801648000','1887000','4799761000');
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-00018999','X-00018999','CC X VELG KACA CM 18 8K','GR','---','E1D','BELI','BELI001','1027000','2026-05-04','1.010','1','kasir','2026-05-04 11:13:03');
DELETE FROM tp_barang WHERE kode_dept = 'X-E1D';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E1D','X-00018999','X-00018999');
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-260504-0004','F326160921441','LIS','1','BELI','BELI001','E1D', 'X-00018999', 'CC X VELG KACA CM 18 8K','1.010','1.010','100.00','1178000','1027000','1016832','1095000','1','1027000','1027000','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-05-04' 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-260504-0004','2026-05-04','2026-05-04','11:13:03','LIS','---','1.010','1027000','1027000','1027000','1027000','1027000','kasir','2026-05-04 11:13:03','FB-260504-0004');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260504-0004','DARMI','BITING BADEGAN','','','','kasir','2026-05-04 11:13:03');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-05-04' 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-260504-0007','K','2026-05-04','11:13:03','kasir','PEMBELIAN UMUM','FB-260504-0004','4799761000','1027000','4798734000');
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-00019000','X-00019000','CC X MODEL MATA CM 14 8K','GR','---','E2D','BELI','BELI001','1455000','2026-05-04','1.430','1','kasir','2026-05-04 11:13:31');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2D';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2D','X-00019000','X-00019000');
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-260504-0005','F326231032111','FIT','1','BELI','BELI001','E2D', 'X-00019000', 'CC X MODEL MATA CM 14 8K','1.430','1.430','100.00','1719000','1455000','1017483','1095000','1','1455000','1455000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.430',berat_beli_asli=berat_beli_asli+'1.430',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.430',berat_akhir_asli=berat_akhir_asli+'1.430',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-05-04' 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-260504-0005','2026-05-04','2026-05-04','11:13:31','FIT','---','1.430','1455000','1455000','1455000','1455000','1455000','kasir','2026-05-04 11:13:31','FB-260504-0005');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260504-0005','GALANG SAPUTRA','SAYUTAN 5/2','','','081229241450','kasir','2026-05-04 11:13:31');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-05-04' 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-260504-0008','K','2026-05-04','11:13:31','kasir','PEMBELIAN UMUM','FB-260504-0005','4798734000','1455000','4797279000');
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-00019001','X-00019001','KL TRIXIE SERUT MODEL PITA VAR UB 8K','GR','---','H1E','BELI','BELI001','1515000','2026-05-04','2.020','1','kasir','2026-05-04 11:14:22');
DELETE FROM tp_barang WHERE kode_dept = 'X-H1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-H1E','X-00019001','X-00019001');
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-260504-0006','F325280911401','AAT','1','BELI','BELI001','H1E', 'X-00019001', 'KL TRIXIE SERUT MODEL PITA VAR UB 8K','2.020','2.020','100.00','1500000','1515000','750000','1105000','1','1515000','1515000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'2.020',berat_beli_asli=berat_beli_asli+'2.020',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'2.020',berat_akhir_asli=berat_akhir_asli+'2.020',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-05-04' 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-260504-0006','2026-05-04','2026-05-04','11:14:21','AAT','---','2.020','1515000','1515000','1515000','1515000','1515000','kasir','2026-05-04 11:14:22','FB-260504-0006');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260504-0006','REVA','BANGSRI WATES WETAN','','','','kasir','2026-05-04 11:14:22');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-05-04' 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-260504-0009','K','2026-05-04','11:14:21','kasir','PEMBELIAN UMUM','FB-260504-0006','4797279000','1515000','4795764000');
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-00019002','X-00019002','CC MODEL HATI POLOS LG 14 8K','GR','---','E1G','BELI','BELI001','332000','2026-05-04','0.320','1','kasir','2026-05-04 11:15:25');
DELETE FROM tp_barang WHERE kode_dept = 'X-E1G';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E1G','X-00019002','X-00019002');
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-260504-0007','F326100937471','LIS','1','BELI','BELI001','E1G', 'X-00019002', 'CC MODEL HATI POLOS LG 14 8K','0.320','0.320','100.00','390000','332000','1037500','1155000','1','332000','332000','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-05-04' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E1G' 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-260504-0007','2026-05-04','2026-05-04','11:15:25','LIS','---','0.320','332000','332000','332000','332000','332000','kasir','2026-05-04 11:15:25','FB-260504-0007');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260504-0007','MITA','PUHPELEM','','','082140096146','kasir','2026-05-04 11:15:25');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-05-04' 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-260504-0010','K','2026-05-04','11:15:25','kasir','PEMBELIAN UMUM','FB-260504-0007','4795764000','332000','4795432000');
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-00019003','X-00019003','GL KREPYAK MODEL MEDAN PASIR VAR LG 8K','GR','---','F3E','BELI','BELI001','5800000','2026-05-04','5.650','1','kasir','2026-05-04 11:15:44');
DELETE FROM tp_barang WHERE kode_dept = 'X-F3E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F3E','X-00019003','X-00019003');
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-260504-0008','F326020146251','FIT','1','BELI','BELI001','F3E', 'X-00019003', 'GL KREPYAK MODEL MEDAN PASIR VAR LG 8K','5.650','5.650','100.00','6555000','5800000','1026549','1105000','1','5800000','5800000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'5.650',berat_beli_asli=berat_beli_asli+'5.650',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'5.650',berat_akhir_asli=berat_akhir_asli+'5.650',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-05-04' 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-260504-0008','2026-05-04','2026-05-04','11:15:44','FIT','---','5.650','5800000','5800000','5800000','5800000','5800000','kasir','2026-05-04 11:15:44','FB-260504-0008');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260504-0008','MUJATUN','SUMBER GALIH PURWATORO','','','082322764645','kasir','2026-05-04 11:15:44');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-05-04' 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-260504-0011','K','2026-05-04','11:15:44','kasir','PEMBELIAN UMUM','FB-260504-0008','4795432000','5800000','4789632000');
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-00019004','X-00019004','GL XXX RANTAI HOLLOW KH 8K','GR','---','F3E','BELI','BELI001','2140000','2026-05-04','2.020','1','kasir','2026-05-04 11:16:13');
DELETE FROM tp_barang WHERE kode_dept = 'X-F3E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F3E','X-00019004','X-00019004');
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-260504-0009','F326070252012','LIS','1','BELI','BELI001','F3E', 'X-00019004', 'GL XXX RANTAI HOLLOW KH 8K','2.020','2.020','100.00','2263000','2140000','1059406','1105000','1','2140000','2140000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'2.020',berat_beli_asli=berat_beli_asli+'2.020',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'2.020',berat_akhir_asli=berat_akhir_asli+'2.020',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-05-04' 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-260504-0009','2026-05-04','2026-05-04','11:16:12','LIS','---','2.020','2140000','2140000','2140000','2140000','2140000','kasir','2026-05-04 11:16:13','FB-260504-0009');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260504-0009','LASTRI','MIRICINDE','','','085864347263','kasir','2026-05-04 11:16:13');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-05-04' 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-260504-0012','K','2026-05-04','11:16:12','kasir','PEMBELIAN UMUM','FB-260504-0009','4789632000','2140000','4787492000');
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-00019005','X-00019005','GL X RANTAI HOLLOW P3 SLEP UB 8K','GR','---','F3E','BELI','BELI001','1233000','2026-05-04','1.190','1','kasir','2026-05-04 11:16:35');
DELETE FROM tp_barang WHERE kode_dept = 'X-F3E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F3E','X-00019005','X-00019005');
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-260504-0010','F326260202401','LIS','1','BELI','BELI001','F3E', 'X-00019005', 'GL X RANTAI HOLLOW P3 SLEP UB 8K','1.190','1.190','100.00','1345000','1233000','1036134','1105000','1','1233000','1233000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.190',berat_beli_asli=berat_beli_asli+'1.190',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.190',berat_akhir_asli=berat_akhir_asli+'1.190',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-05-04' 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-260504-0010','2026-05-04','2026-05-04','11:16:34','LIS','---','1.190','1233000','1233000','1233000','1233000','1233000','kasir','2026-05-04 11:16:35','FB-260504-0010');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260504-0010','HANIFA','BULUKERTO','','','088806477219','kasir','2026-05-04 11:16:35');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-05-04' 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-260504-0013','K','2026-05-04','11:16:34','kasir','PEMBELIAN UMUM','FB-260504-0010','4787492000','1233000','4786259000');
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 ('F326041122291','kasir','1',' MEF1 X UB ','TOKO','PM-F','F1E-YLXC-257-0','GL OVAL C SLEP UB 54 8K ','','4.450','1','100.00','4917000','0','0','15000','4918000','0','0','0','4918000','LIS','00379573','F1E','0','0','-','0','1105000');
UPDATE tm_barang SET tgl_last_jual='2026-05-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-YLXC-257-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.450',berat_jual_asli=berat_jual_asli+'4.450',stock_jual='1',berat_akhir=berat_akhir-'4.450',berat_akhir_asli=berat_akhir_asli-'4.450',stock_akhir='0' WHERE tanggal='2026-05-04' AND kode_barang='F1E-YLXC-257-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 ('F326041122291','2026-05-04','4.450','2026-05-04','11:22:30','PLG0028986','4918000','4918000','0','4918000','4918000','kasir','2026-05-04 11:22:29','F32604112229');
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-05-04','F326041122291','2026-05-04','11:22:30','LIS','4918000','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-260504-0014','D','2026-05-04','11:22:30','kasir','PENJUALAN','F326041122291','4786259000','4918000','4791177000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='4918000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326041122291' 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 ('F326041122292','kasir',' 1',' MEB1E X HW','TOKO','PM-B','B1E-YKAE-9-0','GW X ITALY SLEP VAR HW 8K ','','0.600','1','100.00','663000','0','0','15000','663000','0','0','0','663000','LIS','00377417','B1E','0','0','-','0','1105000');
UPDATE tm_barang SET tgl_last_jual='2026-05-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1E-YKAE-9-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-05-04' AND kode_barang='B1E-YKAE-9-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 ('F326041122292','2026-05-04','0.600','2026-05-04','11:22:30','PLG0028987','663000','663000','0','663000','663000','kasir','2026-05-04 11:22:29','F32604112229');
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-05-04','F326041122292','2026-05-04','11:22:30','LIS','663000','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-260504-0015','D','2026-05-04','11:22:30','kasir','PENJUALAN','F326041122292','4791177000','663000','4791840000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='663000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326041122292' 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 ('F326041122293','kasir',' 1',' MEE1 CM 14','TOKO','PM-E','E1E-ZDXG-202-0','CC MODEL DAUN VAR CM 14 8K ','','0.800','1','100.00','884000','0','0','15000','884000','0','0','0','884000','LIS','00398380','E1E','0','0','-','0','1105000');
UPDATE tm_barang SET tgl_last_jual='2026-05-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZDXG-202-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.800',berat_jual_asli=berat_jual_asli+'0.800',stock_jual='1',berat_akhir=berat_akhir-'0.800',berat_akhir_asli=berat_akhir_asli-'0.800',stock_akhir='0' WHERE tanggal='2026-05-04' AND kode_barang='E1E-ZDXG-202-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 ('F326041122293','2026-05-04','0.800','2026-05-04','11:22:30','PLG0028988','884000','884000','0','884000','884000','kasir','2026-05-04 11:22:29','F32604112229');
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-05-04','F326041122293','2026-05-04','11:22:30','LIS','884000','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-260504-0016','D','2026-05-04','11:22:30','kasir','PENJUALAN','F326041122293','4791840000','884000','4792724000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='884000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326041122293' 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 ('F326041129281','kasir','1',' MEH1 UB 42','TOKO','PM-H','H1E-ZCAG-208-0','KL KOREA UB 42 8K ','','1.990','1','100.00','2199000','0','0','15000','2198000','0','0','0','2198000','FIT','00394926','H1E','0','0','-','1','1105000');
UPDATE tm_barang SET tgl_last_jual='2026-05-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZCAG-208-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.990',berat_jual_asli=berat_jual_asli+'1.990',stock_jual='1',berat_akhir=berat_akhir-'1.990',berat_akhir_asli=berat_akhir_asli-'1.990',stock_akhir='0' WHERE tanggal='2026-05-04' AND kode_barang='H1E-ZCAG-208-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 ('F326041129281','2026-05-04','1.990','2026-05-04','11:29:29','PLG0028989','2198000','2198000','0','2198000','2198000','kasir','2026-05-04 11:29:28','F32604112928');
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-05-04','F326041129281','2026-05-04','11:29:29','FIT','2198000','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-260504-0017','D','2026-05-04','11:29:29','kasir','PENJUALAN','F326041129281','4792724000','2198000','4794922000');
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-00019006','X-00019006','KL KOREA UB 45CM 8K','GR','---','H1E','BELI','BELI001','1848000','2026-05-04','1.950','1','kasir','2026-05-04 11:34:08');
DELETE FROM tp_barang WHERE kode_dept = 'X-H1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-H1E','X-00019006','X-00019006');
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-260504-0011','F326100155162','FIT','1','BELI','BELI001','H1E', 'X-00019006', 'KL KOREA UB 45CM 8K','1.950','1.950','100.00','2300000','1848000','947692','1105000','1','1848000','1848000','RUSAK');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.950',berat_beli_asli=berat_beli_asli+'1.950',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.950',berat_akhir_asli=berat_akhir_asli+'1.950',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-05-04' 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-260504-0011','2026-05-04','2026-05-04','11:34:07','FIT','---','1.950','1848000','1848000','1848000','1848000','1848000','kasir','2026-05-04 11:34:08','FB-260504-0011');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260504-0011','NOVITA','SOLO','','','082138555824','kasir','2026-05-04 11:34:08');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-05-04' 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-260504-0018','K','2026-05-04','11:34:07','kasir','PEMBELIAN UMUM','FB-260504-0011','4794922000','1848000','4793074000');
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 ('F326041210121','kasir','1',' MEF3E X PM','TOKO','PM-F','F3E-ZDAX-128-0','GL X KREPYAK DAUN SLEP PM 8K ','','3.010','1','100.00','3326000','0','0','15000','3326000','0','0','0','3326000','SIN','00398898','F3E','0','0','-','0','1105000');
UPDATE tm_barang SET tgl_last_jual='2026-05-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZDAX-128-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.010',berat_jual_asli=berat_jual_asli+'3.010',stock_jual='1',berat_akhir=berat_akhir-'3.010',berat_akhir_asli=berat_akhir_asli-'3.010',stock_akhir='0' WHERE tanggal='2026-05-04' AND kode_barang='F3E-ZDAX-128-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 ('F326041210121','2026-05-04','3.010','2026-05-04','12:10:12','PLG0028990','3326000','3326000','0','3326000','3326000','kasir','2026-05-04 12:10:12','F32604121012');
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-05-04','F326041210121','2026-05-04','12:10:12','SIN','3326000','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-260504-0019','D','2026-05-04','12:10:12','kasir','PENJUALAN','F326041210121','4793074000','3326000','4796400000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='3326000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326041210121' 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 ('F326041210122','kasir',' 1',' MEE1 X LG ','TOKO','PM-E','E1E-ZDBX-329-0','CC X MODEL DAUN LG 20 8K ','','0.500','1','100.00','552000','0','0','15000','552000','0','0','0','552000','SIN','00400266','E1E','0','0','-','0','1105000');
UPDATE tm_barang SET tgl_last_jual='2026-05-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZDBX-329-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-05-04' AND kode_barang='E1E-ZDBX-329-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 ('F326041210122','2026-05-04','0.500','2026-05-04','12:10:12','PLG0028991','552000','552000','0','552000','552000','kasir','2026-05-04 12:10:12','F32604121012');
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-05-04','F326041210122','2026-05-04','12:10:12','SIN','552000','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-260504-0020','D','2026-05-04','12:10:12','kasir','PENJUALAN','F326041210122','4796400000','552000','4796952000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='552000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326041210122' 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-00019007','X-00019007','AT MODEL ARESO SLEP VAR HW 8K','GR','---','A1E','BELI','BELI001','810000','2026-05-04','0.860','1','kasir','2026-05-04 12:54:46');
DELETE FROM tp_barang WHERE kode_dept = 'X-A1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-A1E','X-00019007','X-00019007');
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-260504-0012','F325031148401','LIS','1','BELI','BELI001','A1E', 'X-00019007', 'AT MODEL ARESO SLEP VAR HW 8K','0.860','0.860','100.00','880000','810000','941860','1105000','1','810000','810000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.860',berat_beli_asli=berat_beli_asli+'0.860',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.860',berat_akhir_asli=berat_akhir_asli+'0.860',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-05-04' 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-260504-0012','2026-05-04','2026-05-04','12:54:45','LIS','---','0.860','810000','810000','810000','810000','810000','kasir','2026-05-04 12:54:46','FB-260504-0012');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260504-0012','DWI','LEMAHBANG KISMANTORO','','','082241336986','kasir','2026-05-04 12:54:46');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-05-04' 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-260504-0021','K','2026-05-04','12:54:45','kasir','PEMBELIAN UMUM','FB-260504-0012','4796952000','810000','4796142000');
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-00019008','X-00019008','AT X MODEL ARESO VAR BW 8K','GR','---','A1E','BELI','BELI001','652000','2026-05-04','0.630','1','kasir','2026-05-04 13:04:38');
DELETE FROM tp_barang WHERE kode_dept = 'X-A1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-A1E','X-00019008','X-00019008');
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-260504-0013','F326020254261','AAT','1','BELI','BELI001','A1E', 'X-00019008', 'AT X MODEL ARESO VAR BW 8K','0.630','0.630','100.00','730000','652000','1034921','1105000','1','652000','652000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.630',berat_beli_asli=berat_beli_asli+'0.630',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.630',berat_akhir_asli=berat_akhir_asli+'0.630',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-05-04' 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-260504-0013','2026-05-04','2026-05-04','13:04:37','AAT','---','0.630','652000','652000','652000','652000','652000','kasir','2026-05-04 13:04:38','FB-260504-0013');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260504-0013','SITI','BADEGAN','','','','kasir','2026-05-04 13:04:38');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-05-04' 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-260504-0022','K','2026-05-04','13:04:37','kasir','PEMBELIAN UMUM','FB-260504-0013','4796142000','652000','4795490000');
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-00019009','X-00019009','GL X VERONICA SLEP LT 8K','GR','---','F3E','BELI','BELI001','2062000','2026-05-04','1.990','1','kasir','2026-05-04 13:25:48');
DELETE FROM tp_barang WHERE kode_dept = 'X-F3E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F3E','X-00019009','X-00019009');
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-260504-0014','F326180852001','AAT','1','BELI','BELI001','F3E', 'X-00019009', 'GL X VERONICA SLEP LT 8K','1.990','1.990','100.00','2360000','2062000','1036181','1105000','1','2062000','2062000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.990',berat_beli_asli=berat_beli_asli+'1.990',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.990',berat_akhir_asli=berat_akhir_asli+'1.990',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-05-04' 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-260504-0014','2026-05-04','2026-05-04','13:25:47','AAT','---','1.990','2062000','2062000','2062000','2062000','2062000','kasir','2026-05-04 13:25:48','FB-260504-0014');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260504-0014','BU WATINI','MIRI GEDAWUNG','','','','kasir','2026-05-04 13:25:48');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-05-04' 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-260504-0023','K','2026-05-04','13:25:47','kasir','PEMBELIAN UMUM','FB-260504-0014','4795490000','2062000','4793428000');
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 ('F326040137471','kasir','1',' MDE2 X UB ','TOKO','PM-E','E2D-ZDAX-205-0','CC X MODEL MATA UB 20 8K ','','2.620','1','100.00','2869000','0','0','15000','2843000','0','0','0','2843000','LIS','00398975','E2D','0','0','-','1','1095000');
UPDATE tm_barang SET tgl_last_jual='2026-05-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZDAX-205-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-05-04' AND kode_barang='E2D-ZDAX-205-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 ('F326040137471','2026-05-04','2.620','2026-05-04','13:37:48','PLG0028992','2843000','2843000','0','2843000','2843000','kasir','2026-05-04 13:37:47','F32604013747');
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-05-04','F326040137471','2026-05-04','13:37:48','LIS','2843000','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-260504-0024','D','2026-05-04','13:37:48','kasir','PENJUALAN','F326040137471','4793428000','2843000','4796271000');
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 ('F326040148161','kasir','1',' MDA1 CM ','TOKO','PM-A','A1D-ZBAX-267-0','AT KLIP MODEL DAUN MATA VAR CM 8K ','','1.490','1','100.00','1617000','0','0','15000','1615000','0','0','0','1615000','AAT','00389179','A1D','0','0','-','1','1095000');
UPDATE tm_barang SET tgl_last_jual='2026-05-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1D-ZBAX-267-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.490',berat_jual_asli=berat_jual_asli+'1.490',stock_jual='1',berat_akhir=berat_akhir-'1.490',berat_akhir_asli=berat_akhir_asli-'1.490',stock_akhir='0' WHERE tanggal='2026-05-04' AND kode_barang='A1D-ZBAX-267-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 ('F326040148161','2026-05-04','1.490','2026-05-04','13:48:16','PLG0028993','1615000','1615000','0','1615000','1615000','kasir','2026-05-04 13:48:16','F32604014816');
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-05-04','F326040148161','2026-05-04','13:48:16','AAT','1615000','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-260504-0025','D','2026-05-04','13:48:16','kasir','PENJUALAN','F326040148161','4796271000','1615000','4797886000');
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-00019010','X-00019010','AT KLIP MODEL PAKU MATA VAR UB 8K','GR','---','A1E','BELI','BELI001','810000','2026-05-04','1.230','1','kasir','2026-05-04 14:03:17');
DELETE FROM tp_barang WHERE kode_dept = 'X-A1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-A1E','X-00019010','X-00019010');
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-260504-0015','F324191114461','AAT','1','BELI','BELI001','A1E', 'X-00019010', 'AT KLIP MODEL PAKU MATA VAR UB 8K','1.230','1.230','100.00','810000','810000','658537','1105000','1','810000','810000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.230',berat_beli_asli=berat_beli_asli+'1.230',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.230',berat_akhir_asli=berat_akhir_asli+'1.230',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-05-04' 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-260504-0015','2026-05-04','2026-05-04','14:03:17','AAT','---','1.230','810000','810000','810000','810000','810000','kasir','2026-05-04 14:03:17','FB-260504-0015');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260504-0015','AUREL','BANGSRI','','','','kasir','2026-05-04 14:03:17');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-05-04' 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-260504-0026','K','2026-05-04','14:03:17','kasir','PEMBELIAN UMUM','FB-260504-0015','4797886000','810000','4797076000');
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-00019011','X-00019011','GL X TIFF SLEP VAR HW 8K','GR','---','F3E','BELI','BELI001','1970000','2026-05-04','1.900','1','kasir','2026-05-04 14:18:37');
DELETE FROM tp_barang WHERE kode_dept = 'X-F3E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F3E','X-00019011','X-00019011');
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-260504-0016','F326040221422','LIS','1','BELI','BELI001','F3E', 'X-00019011', 'GL X TIFF SLEP VAR HW 8K','1.900','1.900','100.00','2337000','1970000','1036842','1105000','1','1970000','1970000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.900',berat_beli_asli=berat_beli_asli+'1.900',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.900',berat_akhir_asli=berat_akhir_asli+'1.900',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-05-04' 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-260504-0016','2026-05-04','2026-05-04','14:18:36','LIS','---','1.900','1970000','1970000','1970000','1970000','1970000','kasir','2026-05-04 14:18:37','FB-260504-0016');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260504-0016','TASYA','NAWANGAN PACITAN','','','081316393130','kasir','2026-05-04 14:18:37');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-05-04' 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-260504-0027','K','2026-05-04','14:18:36','kasir','PEMBELIAN UMUM','FB-260504-0016','4797076000','1970000','4795106000');
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260504-0001','1','B1H-ZBAF-257-0','1','0.260','0.260','TOKO','PM-B','TOKO','SBK-B');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='SBK-B' WHERE kode_barang='B1H-ZBAF-257-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='PM-B';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-05-04','TOKO','SBK-B','B1H','B1H-ZBAF-257-0','100.00','1','0.260','0.260','1','0.260','0.260');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.260',berat_out_asli=berat_out_asli+'0.260',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-05-04' AND kode_barang='B1H-ZBAF-257-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='PM-B' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260504-0001','2','B1G-ZDBI-58-0','1','0.270','0.270','TOKO','PM-B','TOKO','SBK-B');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='SBK-B' WHERE kode_barang='B1G-ZDBI-58-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='PM-B';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-05-04','TOKO','SBK-B','B1G','B1G-ZDBI-58-0','100.00','1','0.270','0.270','1','0.270','0.270');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.270',berat_out_asli=berat_out_asli+'0.270',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-05-04' AND kode_barang='B1G-ZDBI-58-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='PM-B' AND stock_akhir > 0;
INSERT INTO tt_pindah_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES('PB-260504-0001','2026-05-04','2026-05-04','14:55','0.53','input','2026-05-04 14:56:02');
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-00019012','X-00019012','KL X MILANO KH 42 9K','GR','---','H2J','BELI','BELI001','2315000','2026-05-04','2.050','1','kasir','2026-05-04 15:01:09');
DELETE FROM tp_barang WHERE kode_dept = 'X-H2J';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-H2J','X-00019012','X-00019012');
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-260504-0017','F326211148191','LIS','1','BELI','BELI001','H2J', 'X-00019012', 'KL X MILANO KH 42 9K','2.050','2.050','100.00','2593000','2315000','1129268','1205000','1','2315000','2315000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'2.050',berat_beli_asli=berat_beli_asli+'2.050',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'2.050',berat_akhir_asli=berat_akhir_asli+'2.050',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-05-04' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='H2J' 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-260504-0017','2026-05-04','2026-05-04','15:01:09','LIS','---','2.050','2315000','2315000','2315000','2315000','2315000','kasir','2026-05-04 15:01:09','FB-260504-0017');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260504-0017','SUGENG','NGANDONG KEPYAR','','','','kasir','2026-05-04 15:01:09');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-05-04' 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-260504-0028','K','2026-05-04','15:01:09','kasir','PEMBELIAN UMUM','FB-260504-0017','4795106000','2315000','4792791000');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326040137471' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326040137471' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326040137471';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326040148161' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326040148161' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326040148161';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326041049501' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326041049501' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326041049501';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326041056411' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326041056411' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326041056411';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326041122291' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326041122291' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326041122291';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326041122292' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326041122292' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326041122292';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326041122293' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326041122293' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326041122293';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326041129281' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326041129281' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326041129281';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326041210121' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326041210121' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326041210121';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326041210122' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326041210122' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326041210122';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260504-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260504-0001';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260504-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260504-0002';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260504-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260504-0003';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260504-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260504-0004';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260504-0005' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260504-0005';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260504-0006' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260504-0006';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260504-0007' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260504-0007';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260504-0008' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260504-0008';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260504-0009' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260504-0009';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260504-0010' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260504-0010';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260504-0011' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260504-0011';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260504-0012' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260504-0012';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260504-0013' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260504-0013';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260504-0014' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260504-0014';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260504-0015' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260504-0015';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260504-0016' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260504-0016';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260504-0017' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260504-0017';
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-05-05','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2026-04-04';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-05-04';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-05-04';
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-05-04' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-05-04';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-05-04';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-05-04';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-05-04';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202604 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-04';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-04';
UPDATE tt_barang_saldo SET tanggal= '2026-05-05' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-05-04' 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-260505-0001','D','2026-05-05','15:31:15','SYSTEM','SALDO AWAL','SALDO AWAL','0','4792791000','4792791000');
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-260505-0001','D','2026-05-05','15:31:15','BCA','SALDO AWAL','SALDO AWAL','0','712182000','712182000');
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-260505-0001','D','2026-05-05','15:31:15','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-260505-0001','D','2026-05-05','15:31:15','DLL','SALDO AWAL','SALDO AWAL','0','0','0');
UPDATE tp_system SET tgl_system='2026-05-05';