Skip to Content
0
Nov 20, 2019 at 12:38 PM

VALIDATION ON JOURNAL VOUCHER ENTRY IN SAP B1 THRU SP NOTIFICATION

693 Views

Dear Expert,

I had created on UDF in Journal Voucher Entry and want to restrict the entry while the UDF is not selected by user.But its not working.

if(@object_type = '30' And (@transaction_type = 'A' OR @transaction_type = 'U')) Begin If Exists (Select 1 From OBTF Where TransId = @list_of_cols_val_tab_del And ISNULL(U_Status,'') = 'Select' ) Begin Select -3334, 'Status Can be change by Manager only' Return End END.

plz assist..

regards,

Pankajk