on 04-02-2024 2:43 PM
I am a superuser withing SAL Version 10.0 - Database:HANA. How do I disable the option to add Delivery with no Base Document? ie:Delivery Block
Hi,
Use Transaction Notification to block, try this
IF :object_type = '15' and :transaction_type = 'A'
THEN
BEGIN
IF EXISTS (
select T0."DocEntry" from ODLN T0 inner join DLN1 T1 on T0."DocEntry"=T1."DocEntry"
where T0."DocEntry" = :list_of_cols_val_tab_del
and T0."CANCELED"='N'
and T0."DocType"='I'
and T1."BaseType"=-1
)
THEN
BEGIN
error := 1501;
error_message := N'This Delivery is not linked to Base Document, check again.';
END;
END IF;
END;
END IF;
Hope this helps,
Son Tran
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
8 | |
7 | |
6 | |
6 | |
3 | |
3 | |
3 | |
2 | |
2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.