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 ('F326130827211','input','1',' MEA1E X CM','TOKO','PM-A','A1E-ZHBF-15-0','AT X BONEKA ANAK CAT VAR CM 8K ','','0.530','1','100.00','554000','0','0','15000','555000','0','0','0','555000','FIT','00420387','A1E','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-09-13', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1E-ZHBF-15-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.530',berat_jual_asli=berat_jual_asli+'0.530',stock_jual='1',berat_akhir=berat_akhir-'0.530',berat_akhir_asli=berat_akhir_asli-'0.530',stock_akhir='0' WHERE tanggal='2026-09-13' AND kode_barang='A1E-ZHBF-15-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 ('F326130827211','2026-09-13','0.530','2026-09-13','08:27:21','PLG0031305','555000','555000','0','555000','555000','input','2026-09-13 08:27:21','F32613082721');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-09-13','F326130827211','2026-09-13','08:27:21','FIT','555000','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-260913-0002','D','2026-09-13','08:27:21','input','PENJUALAN','F326130827211','7369942000','555000','7370497000');
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 ('F326130831261','input','1',' MEE1 XXX L','TOKO','PM-E','E1E-ZGAC-37-0','CC XXX BANGKOK SLEP LG 14 8K ','','0.520','1','100.00','543000','0','0','15000','528000','0','0','0','528000','LIS','00413303','E1E','0','0','-','1','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-09-13', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZGAC-37-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.520',berat_jual_asli=berat_jual_asli+'0.520',stock_jual='1',berat_akhir=berat_akhir-'0.520',berat_akhir_asli=berat_akhir_asli-'0.520',stock_akhir='0' WHERE tanggal='2026-09-13' AND kode_barang='E1E-ZGAC-37-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326130831261','2026-09-13','0.520','2026-09-13','08:31:26','PLG0031306','528000','528000','0','528000','528000','input','2026-09-13 08:31:26','F32613083126');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-09-13','F326130831261','2026-09-13','08:31:26','LIS','528000','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-260913-0003','D','2026-09-13','08:31:26','input','PENJUALAN','F326130831261','7370497000','528000','7371025000');
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 ('F326130832591','input','1',' MIH2 X KH ','TOKO','PM-H','H2I-ZHXG-193-0','KL X SANTA KH 42 9K ','','1.520','1','100.00','1710000','0','0','15000','1710000','0','0','0','1710000','AAT','00417612','H2I','0','0','-','0','1125000');
UPDATE tm_barang SET tgl_last_jual='2026-09-13', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H2I-ZHXG-193-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-09-13' AND kode_barang='H2I-ZHXG-193-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 ('F326130832591','2026-09-13','1.520','2026-09-13','08:33:00','PLG0031307','1710000','1710000','0','1710000','1710000','input','2026-09-13 08:32:59','F32613083259');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-09-13','F326130832591','2026-09-13','08:33:00','AAT','1710000','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-260913-0004','D','2026-09-13','08:33:00','input','PENJUALAN','F326130832591','7371025000','1710000','7372735000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1710000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326130832591' 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 ('F326130832592','input',' 1',' MED1E X YT','TOKO','PM-D','D1E-ZHAE-58-0','LT X SPECTRA CAT YT 8K ','','0.460','1','100.00','481000','0','0','15000','480000','0','5000','0','485000','AAT','00419079','D1E','0','0','-','1','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-09-13', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1E-ZHAE-58-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.460',berat_jual_asli=berat_jual_asli+'0.460',stock_jual='1',berat_akhir=berat_akhir-'0.460',berat_akhir_asli=berat_akhir_asli-'0.460',stock_akhir='0' WHERE tanggal='2026-09-13' AND kode_barang='D1E-ZHAE-58-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 ('F326130832592','2026-09-13','0.460','2026-09-13','08:33:00','PLG0031308','480000','480000','5000','485000','485000','input','2026-09-13 08:32:59','F32613083259');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-09-13','F326130832592','2026-09-13','08:33:00','AAT','485000','5000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260913-0005','D','2026-09-13','08:33:00','input','PENJUALAN','F326130832592','7372735000','485000','7373220000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='485000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326130832592' 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 ('F326130939271','input','1',' MEF3E X HW','TOKO','PM-F','F3E-ZEBH-26-0','GL X TIFF SLEP VAR HW 8K ','','1.500','1','100.00','1567000','0','0','15000','1568000','0','0','0','1568000','LIS','00405244','F3E','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-09-13', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZEBH-26-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.500',berat_jual_asli=berat_jual_asli+'1.500',stock_jual='1',berat_akhir=berat_akhir-'1.500',berat_akhir_asli=berat_akhir_asli-'1.500',stock_akhir='0' WHERE tanggal='2026-09-13' AND kode_barang='F3E-ZEBH-26-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 ('F326130939271','2026-09-13','1.500','2026-09-13','09:39:27','PLG0031309','1568000','1568000','0','1568000','1568000','input','2026-09-13 09:39:27','F32613093927');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-09-13','F326130939271','2026-09-13','09:39:27','LIS','1568000','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-260913-0006','D','2026-09-13','09:39:27','input','PENJUALAN','F326130939271','7373220000','1568000','7374788000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1568000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326130939271' 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 ('F326130939272','input',' 1',' MEE2 X CM ','TOKO','PM-E','E2E-ZGBA-144-0','CC X MODEL MATA CM 10 8K ','','0.760','1','100.00','794000','0','0','15000','795000','0','0','0','795000','LIS','00414626','E2E','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-09-13', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-ZGBA-144-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.760',berat_jual_asli=berat_jual_asli+'0.760',stock_jual='1',berat_akhir=berat_akhir-'0.760',berat_akhir_asli=berat_akhir_asli-'0.760',stock_akhir='0' WHERE tanggal='2026-09-13' AND kode_barang='E2E-ZGBA-144-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 ('F326130939272','2026-09-13','0.760','2026-09-13','09:39:27','PLG0031310','795000','795000','0','795000','795000','input','2026-09-13 09:39:27','F32613093927');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-09-13','F326130939272','2026-09-13','09:39:27','LIS','795000','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-260913-0007','D','2026-09-13','09:39:27','input','PENJUALAN','F326130939272','7374788000','795000','7375583000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='795000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326130939272' 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 ('F326130954581','input','1',' MEA1E X CM','TOKO','PM-A','A1E-ZHAD-136-0','AT X BONEKA ANAK CAT CM 8K ','','0.660','1','100.00','690000','0','0','15000','690000','0','0','0','690000','FIT','00419021','A1E','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-09-13', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1E-ZHAD-136-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.660',berat_jual_asli=berat_jual_asli+'0.660',stock_jual='1',berat_akhir=berat_akhir-'0.660',berat_akhir_asli=berat_akhir_asli-'0.660',stock_akhir='0' WHERE tanggal='2026-09-13' AND kode_barang='A1E-ZHAD-136-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 ('F326130954581','2026-09-13','0.660','2026-09-13','09:54:59','PLG0031311','690000','690000','0','690000','690000','input','2026-09-13 09:54:58','F32613095458');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-09-13','F326130954581','2026-09-13','09:54:59','FIT','690000','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-260913-0008','D','2026-09-13','09:54:59','input','PENJUALAN','F326130954581','7375583000','690000','7376273000');
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 ('F326131024281','input','1',' MEF3E X HW','TOKO','PM-F','F3E-ZGBA-37-0','GL X CASTELI HATI VAR HW 8K ','','1.340','1','100.00','1400000','0','0','15000','1400000','0','0','0','1400000','AAT','00414519','F3E','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-09-13', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZGBA-37-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.340',berat_jual_asli=berat_jual_asli+'1.340',stock_jual='1',berat_akhir=berat_akhir-'1.340',berat_akhir_asli=berat_akhir_asli-'1.340',stock_akhir='0' WHERE tanggal='2026-09-13' AND kode_barang='F3E-ZGBA-37-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 ('F326131024281','2026-09-13','1.340','2026-09-13','10:24:28','PLG0031312','1400000','1400000','0','1400000','1400000','input','2026-09-13 10:24:28','F32613102428');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-09-13','F326131024281','2026-09-13','10:24:28','AAT','1400000','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-260913-0009','D','2026-09-13','10:24:28','input','PENJUALAN','F326131024281','7376273000','1400000','7377673000');
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 ('F326131037031','input','1',' MFE2 KH 10','TOKO','PM-E','E2F-ZIXI-76-0','CC MODEL PAKU MATA VAR KH 10 8K ','','0.370','1','100.00','394000','0','0','15000','395000','0','0','0','395000','SIN','00422613','E2F','0','0','-','0','1065000');
UPDATE tm_barang SET tgl_last_jual='2026-09-13', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2F-ZIXI-76-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-09-13' AND kode_barang='E2F-ZIXI-76-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 ('F326131037031','2026-09-13','0.370','2026-09-13','10:37:04','PLG0031313','395000','395000','0','395000','395000','input','2026-09-13 10:37:03','F32613103703');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-09-13','F326131037031','2026-09-13','10:37:04','SIN','395000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260913-0010','D','2026-09-13','10:37:04','input','PENJUALAN','F326131037031','7377673000','395000','7378068000');
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 ('F326131037481','input','1',' MFE1 KH 14','TOKO','PM-E','E1F-ZIXI-89-0','CC BUNGA CLOVER SLEP KH 14 8K ','','0.360','1','100.00','383000','0','0','15000','383000','0','0','0','383000','SIN','00422627','E1F','0','0','-','0','1065000');
UPDATE tm_barang SET tgl_last_jual='2026-09-13', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1F-ZIXI-89-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.360',berat_jual_asli=berat_jual_asli+'0.360',stock_jual='1',berat_akhir=berat_akhir-'0.360',berat_akhir_asli=berat_akhir_asli-'0.360',stock_akhir='0' WHERE tanggal='2026-09-13' AND kode_barang='E1F-ZIXI-89-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 ('F326131037481','2026-09-13','0.360','2026-09-13','10:37:49','PLG0031314','383000','383000','0','383000','383000','input','2026-09-13 10:37:48','F32613103748');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-09-13','F326131037481','2026-09-13','10:37:49','SIN','383000','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-260913-0011','D','2026-09-13','10:37:49','input','PENJUALAN','F326131037481','7378068000','383000','7378451000');
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 ('F326131051091','input','1',' MEE1E PM 1','TOKO','PM-E','E1E-ZHBE-304-0','CC MODEL SLEP PM 12 8K ','','0.490','1','100.00','512000','0','0','15000','513000','0','0','0','513000','FIT','00420346','E1E','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-09-13', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZHBE-304-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.490',berat_jual_asli=berat_jual_asli+'0.490',stock_jual='1',berat_akhir=berat_akhir-'0.490',berat_akhir_asli=berat_akhir_asli-'0.490',stock_akhir='0' WHERE tanggal='2026-09-13' AND kode_barang='E1E-ZHBE-304-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 ('F326131051091','2026-09-13','0.490','2026-09-13','10:51:10','PLG0031315','513000','513000','0','513000','513000','input','2026-09-13 10:51:09','F32613105109');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-09-13','F326131051091','2026-09-13','10:51:10','FIT','513000','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-260913-0012','D','2026-09-13','10:51:10','input','PENJUALAN','F326131051091','7378451000','513000','7378964000');
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 ('F326131053061','input','1',' MEF3E X UB','TOKO','PM-F','F3E-ZGXG-149-0','GL X RANTAI HOLLOW PLAT POLOS UB 8K','','1.020','1','100.00','1066000','0','0','15000','1066000','0','0','0','1066000','SIN','00412550','F3E','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-09-13', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZGXG-149-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.020',berat_jual_asli=berat_jual_asli+'1.020',stock_jual='1',berat_akhir=berat_akhir-'1.020',berat_akhir_asli=berat_akhir_asli-'1.020',stock_akhir='0' WHERE tanggal='2026-09-13' AND kode_barang='F3E-ZGXG-149-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 ('F326131053061','2026-09-13','1.020','2026-09-13','10:53:06','PLG0031316','1066000','1066000','0','1066000','1066000','input','2026-09-13 10:53:06','F32613105306');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-09-13','F326131053061','2026-09-13','10:53:06','SIN','1066000','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-260913-0013','D','2026-09-13','10:53:06','input','PENJUALAN','F326131053061','7378964000','1066000','7380030000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1066000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326131053061' 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 ('F326131053062','input',' 1',' MFE2F KH 1','TOKO','PM-E','E2F-ZHBI-145-0','CC MODEL PAKU MATA SLEP KH 18 8K ','','0.390','1','100.00','415000','0','0','15000','415000','0','0','0','415000','SIN','00421270','E2F','0','0','-','0','1065000');
UPDATE tm_barang SET tgl_last_jual='2026-09-13', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2F-ZHBI-145-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.390',berat_jual_asli=berat_jual_asli+'0.390',stock_jual='1',berat_akhir=berat_akhir-'0.390',berat_akhir_asli=berat_akhir_asli-'0.390',stock_akhir='0' WHERE tanggal='2026-09-13' AND kode_barang='E2F-ZHBI-145-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 ('F326131053062','2026-09-13','0.390','2026-09-13','10:53:06','PLG0031317','415000','415000','0','415000','415000','input','2026-09-13 10:53:06','F32613105306');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-09-13','F326131053062','2026-09-13','10:53:06','SIN','415000','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-260913-0014','D','2026-09-13','10:53:06','input','PENJUALAN','F326131053062','7380030000','415000','7380445000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='415000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326131053062' 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 ('F326131107391','input','1',' MEE1E LG 2','TOKO','PM-E','E1E-ZHBE-315-0','CC MODEL DAUN SLEP LG 20 8K ','','0.540','1','100.00','564000','0','0','15000','565000','0','0','0','565000','SIN','00420357','E1E','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-09-13', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZHBE-315-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.540',berat_jual_asli=berat_jual_asli+'0.540',stock_jual='1',berat_akhir=berat_akhir-'0.540',berat_akhir_asli=berat_akhir_asli-'0.540',stock_akhir='0' WHERE tanggal='2026-09-13' AND kode_barang='E1E-ZHBE-315-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 ('F326131107391','2026-09-13','0.540','2026-09-13','11:07:40','PLG0031318','565000','565000','0','565000','565000','input','2026-09-13 11:07:39','F32613110739');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-09-13','F326131107391','2026-09-13','11:07:40','SIN','565000','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-260913-0015','D','2026-09-13','11:07:40','input','PENJUALAN','F326131107391','7380445000','565000','7381010000');
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 ('F326131110471','input','1',' MFE1 KH 16','TOKO','PM-E','E1F-ZIXI-91-0','CC BUNGA CLOVER SLEP KH 16 8K ','','0.380','1','100.00','405000','0','0','15000','405000','0','0','0','405000','LIS','00422629','E1F','0','0','-','0','1065000');
UPDATE tm_barang SET tgl_last_jual='2026-09-13', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1F-ZIXI-91-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.380',berat_jual_asli=berat_jual_asli+'0.380',stock_jual='1',berat_akhir=berat_akhir-'0.380',berat_akhir_asli=berat_akhir_asli-'0.380',stock_akhir='0' WHERE tanggal='2026-09-13' AND kode_barang='E1F-ZIXI-91-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 ('F326131110471','2026-09-13','0.380','2026-09-13','11:10:47','PLG0031319','405000','405000','0','405000','405000','input','2026-09-13 11:10:47','F32613111047');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-09-13','F326131110471','2026-09-13','11:10:47','LIS','405000','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-260913-0016','D','2026-09-13','11:10:47','input','PENJUALAN','F326131110471','7381010000','405000','7381415000');
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 ('F326131113561','input','1',' MEF3E HW ','TOKO','PM-F','F3E-ZHBI-161-0','GL CASTELI SPECTRA SLEP HW 8K ','','1.780','1','100.00','1860000','0','0','15000','1860000','0','0','0','1860000','AAT','00421286','F3E','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-09-13', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZHBI-161-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.780',berat_jual_asli=berat_jual_asli+'1.780',stock_jual='1',berat_akhir=berat_akhir-'1.780',berat_akhir_asli=berat_akhir_asli-'1.780',stock_akhir='0' WHERE tanggal='2026-09-13' AND kode_barang='F3E-ZHBI-161-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 ('F326131113561','2026-09-13','1.780','2026-09-13','11:13:56','PLG0031320','1860000','1860000','0','1860000','1860000','input','2026-09-13 11:13:56','F32613111356');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-09-13','F326131113561','2026-09-13','11:13:56','AAT','1860000','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-260913-0017','D','2026-09-13','11:13:56','input','PENJUALAN','F326131113561','7381415000','1860000','7383275000');
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-00020181','X-00020181','AT BONEKA ANAK CAT LG 8K','GR','---','A1E','BELI','BELI001','205000','2026-09-13','0.270','1','kasir','2026-09-13 12:00:31');
DELETE FROM tp_barang WHERE kode_dept = 'X-A1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-A1E','X-00020181','X-00020181');
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-260913-0001','F326170351341','FIT','1','BELI','BELI001','A1E', 'X-00020181', 'AT BONEKA ANAK CAT LG 8K','0.510','0.270','100.00','605000','205000','759259','1045000','1','205000','205000','RUSAK');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.270',berat_beli_asli=berat_beli_asli+'0.270',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.270',berat_akhir_asli=berat_akhir_asli+'0.270',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-09-13' 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-260913-0001','2026-09-13','2026-09-13','12:00:30','FIT','---','0.270','205000','205000','205000','205000','205000','kasir','2026-09-13 12:00:31','FB-260913-0001');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260913-0001','LINDA','BLIMBING PURWANTORO','','','081335969657','kasir','2026-09-13 12:00:31');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-09-13' 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-260913-0018','K','2026-09-13','12:00:30','kasir','PEMBELIAN UMUM','FB-260913-0001','7383275000','205000','7383070000');
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-00020182','X-00020182','AT TINDIK BABY DG 8K','GR','---','A0C','BELI','BELI001','227000','2026-09-13','0.250','1','kasir','2026-09-13 12:00:57');
DELETE FROM tp_barang WHERE kode_dept = 'X-A0C';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-A0C','X-00020182','X-00020182');
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-260913-0002','F326261040392','SIN','1','BELI','BELI001','A0C', 'X-00020182', 'AT TINDIK BABY DG 8K','0.250','0.250','100.00','274000','227000','908000','1005000','1','227000','227000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.250',berat_beli_asli=berat_beli_asli+'0.250',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.250',berat_akhir_asli=berat_akhir_asli+'0.250',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-09-13' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='A0C' 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-260913-0002','2026-09-13','2026-09-13','12:00:56','SIN','---','0.250','227000','227000','227000','227000','227000','kasir','2026-09-13 12:00:57','FB-260913-0002');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260913-0002','TRIWAHYUNI','JERUK PACITAN','','','0859171710494','kasir','2026-09-13 12:00:57');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-09-13' 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-260913-0019','K','2026-09-13','12:00:56','kasir','PEMBELIAN UMUM','FB-260913-0002','7383070000','227000','7382843000');
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-00020183','X-00020183','CC MODEL MATA VAR LG 10 8K','GR','---','E2E','BELI','BELI001','390000','2026-09-13','0.500','1','kasir','2026-09-13 12:01:30');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2E','X-00020183','X-00020183');
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-260913-0003','F325030243152','SIN','1','BELI','BELI001','E2E', 'X-00020183', 'CC MODEL MATA VAR LG 10 8K','0.500','0.500','100.00','420000','390000','780000','1045000','1','390000','390000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.500',berat_beli_asli=berat_beli_asli+'0.500',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.500',berat_akhir_asli=berat_akhir_asli+'0.500',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-09-13' 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-260913-0003','2026-09-13','2026-09-13','12:01:30','SIN','---','0.500','390000','390000','390000','390000','390000','kasir','2026-09-13 12:01:30','FB-260913-0003');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260913-0003','ALIFKA','JATISRONO','','','','kasir','2026-09-13 12:01:30');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-09-13' 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-260913-0020','K','2026-09-13','12:01:30','kasir','PEMBELIAN UMUM','FB-260913-0003','7382843000','390000','7382453000');
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-00020184','X-00020184','KL X NORY UB 42 8K','GR','---','H1E','BELI','BELI001','1875000','2026-09-13','2.020','1','kasir','2026-09-13 12:01:56');
DELETE FROM tp_barang WHERE kode_dept = 'X-H1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-H1E','X-00020184','X-00020184');
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-260913-0004','F326120944001','LIS','1','BELI','BELI001','H1E', 'X-00020184', 'KL X NORY UB 42 8K','2.020','2.020','100.00','2435000','1875000','928218','1045000','1','1875000','1875000','RUSAK');
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-09-13' 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-260913-0004','2026-09-13','2026-09-13','12:01:56','LIS','---','2.020','1875000','1875000','1875000','1875000','1875000','kasir','2026-09-13 12:01:56','FB-260913-0004');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260913-0004','SARYANI','SIGERENG 2/2 BITING','','','','kasir','2026-09-13 12:01:56');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-09-13' 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-260913-0021','K','2026-09-13','12:01:56','kasir','PEMBELIAN UMUM','FB-260913-0004','7382453000','1875000','7380578000');
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-00020185','X-00020185','AT MODEL ITALY PANJANG VAR HW 8K','GR','---','A1F','BELI','BELI001','545000','2026-09-13','0.830','1','kasir','2026-09-13 12:02:23');
DELETE FROM tp_barang WHERE kode_dept = 'X-A1F';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-A1F','X-00020185','X-00020185');
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-260913-0005','F324141030011','LIS','1','BELI','BELI001','A1F', 'X-00020185', 'AT MODEL ITALY PANJANG VAR HW 8K','0.830','0.830','100.00','490000','545000','656627','1065000','1','545000','545000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.830',berat_beli_asli=berat_beli_asli+'0.830',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.830',berat_akhir_asli=berat_akhir_asli+'0.830',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-09-13' 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-260913-0005','2026-09-13','2026-09-13','12:02:22','LIS','---','0.830','545000','545000','545000','545000','545000','kasir','2026-09-13 12:02:23','FB-260913-0005');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260913-0005','SINTA','KENTHENG PURWANTORO','','','','kasir','2026-09-13 12:02:23');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-09-13' 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-260913-0022','K','2026-09-13','12:02:22','kasir','PEMBELIAN UMUM','FB-260913-0005','7380578000','545000','7380033000');
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 ('F326130124571','kasir','1',' MEF1 UB D5','TOKO','PM-F','F1E-ZIAA-173-0','GL OVAL MODEL SLEP UB D56 8K ','','4.420','1','100.00','4619000','0','0','15000','4619000','0','0','0','4619000','SIN','00423311','F1E','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-09-13', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-ZIAA-173-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.420',berat_jual_asli=berat_jual_asli+'4.420',stock_jual='1',berat_akhir=berat_akhir-'4.420',berat_akhir_asli=berat_akhir_asli-'4.420',stock_akhir='0' WHERE tanggal='2026-09-13' AND kode_barang='F1E-ZIAA-173-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 ('F326130124571','2026-09-13','4.420','2026-09-13','13:24:57','PLG0031321','4619000','4619000','0','4619000','4619000','kasir','2026-09-13 13:24:57','F32613012457');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-09-13','F326130124571','2026-09-13','13:24:57','SIN','4619000','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-260913-0023','D','2026-09-13','13:24:57','kasir','PENJUALAN','F326130124571','7380033000','4619000','7384652000');
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 ('F326130135371','kasir','1',' MEA1 X LG ','TOKO','PM-A','A1E-ZGBX-209-0','AT X GYPSY LG 8K','','0.540','1','100.00','564000','0','0','15000','565000','0','0','0','565000','LIS','00414410','A1E','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-09-13', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1E-ZGBX-209-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.540',berat_jual_asli=berat_jual_asli+'0.540',stock_jual='1',berat_akhir=berat_akhir-'0.540',berat_akhir_asli=berat_akhir_asli-'0.540',stock_akhir='0' WHERE tanggal='2026-09-13' AND kode_barang='A1E-ZGBX-209-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 ('F326130135371','2026-09-13','0.540','2026-09-13','13:35:37','PLG0031322','565000','565000','0','565000','565000','kasir','2026-09-13 13:35:37','F32613013537');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-09-13','F326130135371','2026-09-13','13:35:37','LIS','565000','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-260913-0024','D','2026-09-13','13:35:37','kasir','PENJUALAN','F326130135371','7384652000','565000','7385217000');
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-00020186','X-00020186','AT COR 8K','GR','---','A1F','BELI','BELI001','125000','2026-09-13','0.210','1','kasir','2026-09-13 13:44:17');
DELETE FROM tp_barang WHERE kode_dept = 'X-A1F';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-A1F','X-00020186','X-00020186');
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-260913-0006','F323050139421','LIS','1','BELI','BELI001','A1F', 'X-00020186', 'AT COR 8K','0.420','0.210','100.00','192000','125000','595238','1065000','1','125000','125000','RUSAK');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.210',berat_beli_asli=berat_beli_asli+'0.210',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.210',berat_akhir_asli=berat_akhir_asli+'0.210',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-09-13' 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-260913-0006','2026-09-13','2026-09-13','13:44:17','LIS','---','0.210','125000','125000','125000','125000','125000','kasir','2026-09-13 13:44:17','FB-260913-0006');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260913-0006','ANIK','GENENG BULUKERTO','','','','kasir','2026-09-13 13:44:17');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-09-13' 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-260913-0025','K','2026-09-13','13:44:17','kasir','PEMBELIAN UMUM','FB-260913-0006','7385217000','125000','7385092000');
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-00020187','X-00020187','CC BANGKOK SLEP BW 23 8K','GR','---','E1D','BELI','BELI001','960000','2026-09-13','1.010','1','kasir','2026-09-13 13:44:36');
DELETE FROM tp_barang WHERE kode_dept = 'X-E1D';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E1D','X-00020187','X-00020187');
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-260913-0007','F326101035321','AAT','1','BELI','BELI001','E1D', 'X-00020187', 'CC BANGKOK SLEP BW 23 8K','1.010','1.010','100.00','1198000','960000','950495','1035000','1','960000','960000','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-09-13' 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-260913-0007','2026-09-13','2026-09-13','13:44:36','AAT','---','1.010','960000','960000','960000','960000','960000','kasir','2026-09-13 13:44:36','FB-260913-0007');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260913-0007','ISAH','JATISARI PURWANTORO','','','','kasir','2026-09-13 13:44:36');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-09-13' 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-260913-0026','K','2026-09-13','13:44:36','kasir','PEMBELIAN UMUM','FB-260913-0007','7385092000','960000','7384132000');
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 ('F326130206101','kasir','1',' TDE2 X 10 ','TOKO','PT-E','E2TD-ZEBA-15-T','CC X MODEL MATA 10 17K ','','1.260','1','100.00','2394000','0','0','15000','2395000','0','0','0','2395000','LIS','T0079722','E2TD','0','0','-','0','1900000');
UPDATE tm_barang SET tgl_last_jual='2026-09-13', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2TD-ZEBA-15-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.260',berat_jual_asli=berat_jual_asli+'1.260',stock_jual='1',berat_akhir=berat_akhir-'1.260',berat_akhir_asli=berat_akhir_asli-'1.260',stock_akhir='0' WHERE tanggal='2026-09-13' AND kode_barang='E2TD-ZEBA-15-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PT-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 ('F326130206101','2026-09-13','1.260','2026-09-13','14:06:11','PLG0031323','2395000','2395000','0','2395000','2395000','kasir','2026-09-13 14:06:10','F32613020610');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-09-13','F326130206101','2026-09-13','14:06:11','LIS','2395000','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-260913-0027','D','2026-09-13','14:06:11','kasir','PENJUALAN','F326130206101','7384132000','2395000','7386527000');
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 ('F326130221221','kasir','1',' TEE2 X HT ','TOKO','PT-E','E2TE-WKXI-75-T','CC X MODEL MATA HT 10 17K','','1.970','1','100.00','3782000','0','0','15000','3783000','0','10000','0','3793000','SIN','T0050483','E2TE','0','0','-','0','1920000');
UPDATE tm_barang SET tgl_last_jual='2026-09-13', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2TE-WKXI-75-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.970',berat_jual_asli=berat_jual_asli+'1.970',stock_jual='1',berat_akhir=berat_akhir-'1.970',berat_akhir_asli=berat_akhir_asli-'1.970',stock_akhir='0' WHERE tanggal='2026-09-13' AND kode_barang='E2TE-WKXI-75-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PT-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 ('F326130221221','2026-09-13','1.970','2026-09-13','14:21:23','PLG0031324','3783000','3783000','10000','3793000','3793000','kasir','2026-09-13 14:21:22','F32613022122');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-09-13','F326130221221','2026-09-13','14:21:23','SIN','3793000','10000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260913-0028','D','2026-09-13','14:21:23','kasir','PENJUALAN','F326130221221','7386527000','3793000','7390320000');
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-00020188','X-00020188','CC MODEL LINEA VAR HW 15 8K','GR','---','E1E','BELI','BELI001','502000','2026-09-13','0.560','1','kasir','2026-09-13 14:23:06');
DELETE FROM tp_barang WHERE kode_dept = 'X-E1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E1E','X-00020188','X-00020188');
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-260913-0008','F326010114242','FIT','1','BELI','BELI001','E1E', 'X-00020188', 'CC MODEL LINEA VAR HW 15 8K','0.560','0.560','100.00','622000','502000','896429','1045000','1','502000','502000','RUSAK');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.560',berat_beli_asli=berat_beli_asli+'0.560',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.560',berat_akhir_asli=berat_akhir_asli+'0.560',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-09-13' 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-260913-0008','2026-09-13','2026-09-13','14:23:06','FIT','---','0.560','502000','502000','502000','502000','502000','kasir','2026-09-13 14:23:06','FB-260913-0008');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260913-0008','ENDAH','BLIMBING LOR','','','','kasir','2026-09-13 14:23:06');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-09-13' 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-260913-0029','K','2026-09-13','14:23:06','kasir','PEMBELIAN UMUM','FB-260913-0008','7390320000','502000','7389818000');
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-00020189','X-00020189','CC MODEL TINJU BOLA ARESO SLEP HW 13 8K','GR','---','E1E','BELI','BELI001','727000','2026-09-13','0.750','1','kasir','2026-09-13 14:23:06');
DELETE FROM tp_barang WHERE kode_dept = 'X-E1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E1E','X-00020189','X-00020189');
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-260913-0009','F326251012402','FIT','2','BELI','BELI001','E1E', 'X-00020189', 'CC MODEL TINJU BOLA ARESO SLEP HW 13 8K','0.750','0.750','100.00','802000','727000','969333','1045000','1','727000','727000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.750',berat_beli_asli=berat_beli_asli+'0.750',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.750',berat_akhir_asli=berat_akhir_asli+'0.750',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-09-13' 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-260913-0009','2026-09-13','2026-09-13','14:23:06','FIT','---','0.750','727000','727000','727000','727000','727000','kasir','2026-09-13 14:23:06','FB-260913-0008');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260913-0009','ENDAH','BLIMBING','','','','kasir','2026-09-13 14:23:06');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-09-13' 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-260913-0030','K','2026-09-13','14:23:06','kasir','PEMBELIAN UMUM','FB-260913-0009','7389818000','727000','7389091000');
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-00020190','X-00020190','CC MODEL ISYANA SLEP LG 10 8K','GR','---','E1E','BELI','BELI001','402000','2026-09-13','0.450','1','kasir','2026-09-13 14:23:24');
DELETE FROM tp_barang WHERE kode_dept = 'X-E1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E1E','X-00020190','X-00020190');
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-260913-0010','F326210220491','AAT','1','BELI','BELI001','E1E', 'X-00020190', 'CC MODEL ISYANA SLEP LG 10 8K','0.450','0.450','100.00','488000','402000','893333','1045000','1','402000','402000','RUSAK');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.450',berat_beli_asli=berat_beli_asli+'0.450',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.450',berat_akhir_asli=berat_akhir_asli+'0.450',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-09-13' 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-260913-0010','2026-09-13','2026-09-13','14:23:23','AAT','---','0.450','402000','402000','402000','402000','402000','kasir','2026-09-13 14:23:24','FB-260913-0010');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260913-0010','MARTINI','SANGGRONG','','','','kasir','2026-09-13 14:23:24');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-09-13' 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-260913-0031','K','2026-09-13','14:23:23','kasir','PEMBELIAN UMUM','FB-260913-0010','7389091000','402000','7388689000');
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-00020191','X-00020191','AT X HUGGIES BONEKA ANAK CAT LG 8K','GR','---','A1D','BELI','BELI001','705000','2026-09-13','1.000','1','kasir','2026-09-13 14:29:52');
DELETE FROM tp_barang WHERE kode_dept = 'X-A1D';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-A1D','X-00020191','X-00020191');
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-260913-0011','F325180952101','LIS','1','BELI','BELI001','A1D', 'X-00020191', 'AT X HUGGIES BONEKA ANAK CAT LG 8K','1.000','1.000','100.00','730000','705000','705000','1035000','1','705000','705000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.000',berat_beli_asli=berat_beli_asli+'1.000',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.000',berat_akhir_asli=berat_akhir_asli+'1.000',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-09-13' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='A1D' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-260913-0011','2026-09-13','2026-09-13','14:29:52','LIS','---','1.000','705000','705000','705000','705000','705000','kasir','2026-09-13 14:29:52','FB-260913-0011');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260913-0011','DELISA','JENANGAN SAMPUNG','','','','kasir','2026-09-13 14:29:52');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-09-13' 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-260913-0032','K','2026-09-13','14:29:52','kasir','PEMBELIAN UMUM','FB-260913-0011','7388689000','705000','7387984000');
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-00020192','X-00020192','LT COR T 8K','GR','---','D1H','BELI','BELI001','150000','2026-09-13','0.150','1','kasir','2026-09-13 14:53:07');
DELETE FROM tp_barang WHERE kode_dept = 'X-D1H';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-D1H','X-00020192','X-00020192');
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-260913-0012','00403729','SIN','1','BELI','BELI001','D1H', 'X-00020192', 'LT COR T 8K','0.150','0.150','100.00','179000','150000','1000000','1105000','1','150000','150000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.150',berat_beli_asli=berat_beli_asli+'0.150',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.150',berat_akhir_asli=berat_akhir_asli+'0.150',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-09-13' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='D1H' 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-260913-0012','2026-09-13','2026-09-13','14:53:07','SIN','---','0.150','150000','150000','150000','150000','150000','kasir','2026-09-13 14:53:07','FB-260913-0012');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260913-0012','TYA','BADEGAN','','','','kasir','2026-09-13 14:53:07');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-09-13' 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-260913-0033','K','2026-09-13','14:53:07','kasir','PEMBELIAN UMUM','FB-260913-0012','7387984000','150000','7387834000');
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-00020193','X-00020193','GL X GHENIA SLEP UB 8K','GR','---','F3E','BELI','BELI001','440000','2026-09-13','0.480','1','kasir','2026-09-13 14:53:42');
DELETE FROM tp_barang WHERE kode_dept = 'X-F3E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F3E','X-00020193','X-00020193');
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-260913-0013','F326290243551','SIN','1','BELI','BELI001','F3E', 'X-00020193', 'GL X GHENIA SLEP UB 8K','0.480','0.480','100.00','543000','440000','916667','1045000','1','440000','440000','RUSAK');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.480',berat_beli_asli=berat_beli_asli+'0.480',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.480',berat_akhir_asli=berat_akhir_asli+'0.480',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-09-13' 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-260913-0013','2026-09-13','2026-09-13','14:53:41','SIN','---','0.480','440000','440000','440000','440000','440000','kasir','2026-09-13 14:53:42','FB-260913-0013');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260913-0013','RARA','BADEGAN','','','','kasir','2026-09-13 14:53:42');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-09-13' 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-260913-0034','K','2026-09-13','14:53:41','kasir','PEMBELIAN UMUM','FB-260913-0013','7387834000','440000','7387394000');
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260913-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260913-0001';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260913-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260913-0002';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260913-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260913-0003';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260913-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260913-0004';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260913-0005' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260913-0005';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260913-0006' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260913-0006';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260913-0007' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260913-0007';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260913-0008' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260913-0008';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260913-0009' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260913-0009';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260913-0010' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260913-0010';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260913-0011' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260913-0011';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260913-0012' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260913-0012';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260913-0013' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260913-0013';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326130124571' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326130124571' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326130124571';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326130135371' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326130135371' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326130135371';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326130206101' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326130206101' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326130206101';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326130221221' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326130221221' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326130221221';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326130827211' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326130827211' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326130827211';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326130831261' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326130831261' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326130831261';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326130832591' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326130832591' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326130832591';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326130832592' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326130832592' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326130832592';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326130939271' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326130939271' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326130939271';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326130939272' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326130939272' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326130939272';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326130954581' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326130954581' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326130954581';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326131024281' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326131024281' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326131024281';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326131037031' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326131037031' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326131037031';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326131037481' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326131037481' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326131037481';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326131051091' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326131051091' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326131051091';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326131053061' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326131053061' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326131053061';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326131053062' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326131053062' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326131053062';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326131107391' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326131107391' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326131107391';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326131110471' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326131110471' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326131110471';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326131113561' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326131113561' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326131113561';
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-09-14','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2026-08-14';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-09-13';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-09-13';
INSERT INTO tt_barang_saldo (kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_awal,berat_awal_asli,stock_awal,berat_akhir,berat_akhir_asli,stock_akhir) SELECT kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_akhir,berat_akhir_asli,stock_akhir,berat_akhir,berat_akhir_asli,stock_akhir FROM tt_barang_saldo WHERE tanggal='2026-09-13' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-09-13';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-09-13';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-09-13';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-09-13';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202608 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-08';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-08';
UPDATE tt_barang_saldo SET tanggal= '2026-09-14' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-09-13' 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-260914-0001','D','2026-09-14','15:13:53','SYSTEM','SALDO AWAL','SALDO AWAL','0','7387394000','7387394000');
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-260914-0001','D','2026-09-14','15:13:53','BCA','SALDO AWAL','SALDO AWAL','0','740659000','740659000');
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-260914-0001','D','2026-09-14','15:13:53','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-260914-0001','D','2026-09-14','15:13:53','DLL','SALDO AWAL','SALDO AWAL','0','0','0');
UPDATE tp_system SET tgl_system='2026-09-14';