Skip to Content
avatar image
Former Member

STORED PROCEDURE - SBO HANA 9.2 PL4

Dear Team,

I have created the following SP to block delivery note unless based on either Sales Order or AR reserve Invoice. It is blocking Delivery notes that are based on AR reserve invoice. Kindly help me troubleshoot the error.

if :object_type='15' and (:transaction_type='A' or :transaction_type='U') then select COUNT(*) into cnt from "ODLN"INNER JOIN DLN1 ON "ODLN"."DocEntry"= "DLN1"."DocEntry" where (("DLN1"."BaseType" <> '17') OR ("DLN1"."BaseType" <>'13'))and "ODLN"."DocEntry"=:list_of_cols_val_tab_del; if :cnt>0 then error := -114; error_message := 'You Cannot Do a Direct Delivery Note,Copy from Sales Order '; end if; end if;

Your assistance is appreciated.

Regards

George Njuguna

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers