
update payables set payment_date=NULL where payment_date="0000-00-00";
update receivables set payment_date=NULL, encachement_date=NULL where (total_price+total_duty)=0 and updated_at < "2011-03-01 04:00:00";

update payings set cutoff_date=NULL,currency_type_code=NULL where updated_at < "2011-03-02";
update receivings as s left join glan.receivings as g on s.id=g.id set s.cutoff_date=g.receivable_date where s.updated_at < "2011-03-02";
