采购退货单：单价必须填写

五六零网校小于 1 分钟

示例代码

--采购退货单：单价必须填写
 IF @object_type='21'
 begin
 if @transaction_type='A' OR @transaction_type = 'U'
 begin
 if exists(
 SELECT T1.[Price] FROM ORPD T0  INNER JOIN RPD1 T1
 ON T0.[DocEntry] = T1.[DocEntry] WHERE T1.[Price]  is null or  T1.[Price] <=  0 and  T1.[DocEntry]=@list_of_cols_val_tab_del
 )
 begin
 select @error=1
 select @error_message='采购退货单单价必须填写'
 
 end
 end
 end

效果图