应收发票:必须有来源单据
小于 1 分钟
代码示例
--应收发票:单据来源必须有来源单据
IF @object_type = '13'
BEGIN
IF @transaction_type = 'A'
BEGIN
IF EXISTS (
SELECT T1.[BaseEntry]
FROM OINV T0
INNER JOIN INV1 T1 ON T0.[DocEntry] = T1.[DocEntry]
WHERE T1.[BaseEntry] IS NULL
AND T0.DocEntry = @list_of_cols_val_tab_del
)
BEGIN
SET @error = 131;
SET @error_message = '应收发票必须有来源单据';
END;
END;
END