Store Procedure required to check Quantity total
Kindly help me in writing Store Procedure, my requirement is to have an validation on Inventory Transfer Form where i have created two udf fields in row level as A & B contains where user enter value which is calculated as A * B that is equal to total Quantity, for ex. (A * B = Quantity).
So i need here a validation check before adding this document, that Field A value multiply by Field B value that should to be total Quantity in case changes made in field A or Field B but not update before saving this document it would result be wrong Quantity total.
To avoid such user entering mistakes a SP is required to check whether the Quantity total is equal to Field A value * Field B value.
Thanking in Advance....