A/R Invoice as mandatory in HANA
My Code is
if transaction_type in ('A','U') and object_type = '13'
if exists (SELECT * FROM OINV WHERE (ISNULL(Comments,'')) = '' and OINV.DocEntry = list_of_cols_val_tab_del)
--SELECT Error =11, error_message = 'You have not filled the A/R Invoice Remarks, Kindly Check'
error := 11;
error_message := N'You have not filled the A/R Invoice Remarks, Kindly Check';
Please help with the correct syntax.
Bhanu Pratap Sharma replied
if :object_type='13' and (:transaction_type='A' or :transaction_type='U')
select COUNT(*) into cnt from "OINV" where "DocEntry"=:list_of_cols_val_tab_del and IFNULL("Comments",'')='';
if :cnt>0 then
error := -112;
error_message := 'Enter Remarks';