1. Hapus goods_stock yang goods_stock total_quantity_buy = 0
   
   SELECT *FROM `goods_stock`  where `total_quantity_buy` = 0
    
   buy_seq_no = 00233
   
   Berdsarakan buy_seq_no ini, cari sale_detail. Hapus barang tsb kemudian input lagi 
   sesuai dengan data yg dihapus (reinput).
   
   -------------------------------------------------------------------------------
   

   
   
2. Yakinkan harga buy_detail.unit_buy_price dan buy_detail.discount 
   untuk buy_detail.goods_code yang sama dalam buy.buy_seq_no
   tidak boleh berbeda. Harus sama.
   
   Jalankan sql berikut:
   
   1.	   create temporary table temp (
	  	        buy_seq_no   		char(5),
			goods_code            	varchar(20),
			unit_buy_price  	double unsigned)
	   ;
	   
	   lock tables buy read, buy_detail read;
	   
	   insert into temp
	   select buy.buy_seq_no, buy_detail.goods_code, buy_detail.unit_buy_price
	   from buy_detail, buy 
	   where  buy.supplier_code 	= buy_detail.supplier_code and
		  buy.invoice_no 	= buy_detail.invoice_no
		  
	   group by buy.buy_seq_no, buy_detail.goods_code, buy_detail.unit_buy_price
	   ;
	   
	   
	   select buy_seq_no, goods_code, count(concat(buy_seq_no, goods_code)) as invalid 
	   from temp
	   group by buy_seq_no, goods_code
	   order by invalid desc
	   ;

   Untuk yang Field invalid > 1, buy_detail.unit_buy_price!!!!
   
   Yang Field invalid > 1:
   
	00314 CMP.RB.05   2 
	00618 ACCU.BKS.06 2 
	00500 ACCU.BKS.02 2 
	00351 ACCU.BKS.15 2 

   -------------------------------------------------------------------------------