跳至主要內容

库存收货单:单价必须填写

五六零网校小于 1 分钟

代码示例

--库存收货单:单价必须填写
IF @object_type='59'
 begin
 if @transaction_type='A' OR @transaction_type = 'U'
 begin
if exists(
SELECT T0.[Price] FROM IGN1 T0  INNER JOIN OIGN T1
 ON T0.[DocEntry] = T1.[DocEntry] WHERE  T0.[Price] is null or T0.[Price]<=0 and T0.[DocEntry]=@list_of_cols_val_tab_del
 )
 begin
 select @error=59-1
 select @error_message='库存收货单单价必须填写'
 
 end
 end
 end