Stored Procedure

Hi experts,

Please teach, give, guide me how to write a SP for following issue:

Alert the user or block document from adding if the target document's total is greater than the base document's total.

Purchase Invoice amount must be same or lesser than Purchase Order amount.

Thank you.