I WANT TO CHANGE MY BP CURRENCY MUST BE INR ONLY ... WHAT I SHOULD WROTE THE VALIDATION QUERY..
THIS IS VALIDATION QUERY WHAT I NEED TO CHANGE ANYONE HELP ME
if @object_type ='22' and @transaction_type in ('A','U')
BEGIN
IF EXISTS
( Select * from OPOR a
where a.DocEntry= @list_of_cols_val_tab_del and a.CurSource ='C'
)
Begin
set @error='22'
set @error_message='BP CURRENCY IS MANDATORY '
end
end