Michael Johnson delivers SQL code to cancel GP contract lines outside of Dynamics GP in his new post.
Cancelling Dynamics GP Contract Lines
Archived post from 2010. Dynamics GP and the links it points to have changed since; check current documentation before relying on version-specific steps.