库存收货单:单价必须填写
小于 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