Skip to Content
0

STORED PROCEDURE - SBO HANA 9.2 PL4

Mar 09, 2017 at 05:33 PM

25

avatar image
Former Member

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers