Hi,

Why u want to use trigger... U can call a simple stored procedure to do the updation of header status after cheking the balance while modifying the receiving qty...(i.e. i balalce is 0 update the status to closed).

Manoj