Originally posted by mkumarnk
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
This sounds like great advice -- embedding business logic in triggers is a Bad Thing, because it obscures the way the application runs and makes it more difficult to support.