Skip to Content
0
Former Member
May 13, 2010 at 12:23 PM

mandatory field

24 Views

how to make the ship to or bill to address is mandatory in business partner. here i pasted my store procedure..

if @transaction_type in ('U') and @object_type = '2'

begin

if (select t0.address from OCRD T0 where T0.cardcode = @list_of_cols_val_tab_del)is null

begin

SET @error = 17

SET @error_message = 'Please ENTER BILL TO STREET '

end

end

its correct....or not?