Skip to Content
0
Nov 22, 2018 at 08:58 AM

Block Future Posting Date in Journal Entry in SAP B1 HANA

216 Views

IF @object_type = '30' and @transaction_type in ('A','U')

BEGIN

If EXISTS

(SELECT TransID

FROM OJDT

WHERE DATEDIFF(mm,RefDate,GETDATE()) <= 0 AND TransID = @list_of_cols_val_tab_del

Begin

set @error = 30

set @error_message = 'You are not allowed to add document with Future Posting Period.'

End

END

Can anyone help in converting the above transaction notification to SAP HANA B1 to block future posting in Journal Entry level.