cancel
Showing results for 
Search instead for 
Did you mean: 

Block Future Posting Date in Journal Entry in SAP B1 HANA

former_member587886
Participant
0 Kudos

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.

Accepted Solutions (0)

Answers (1)

Answers (1)

former_member587886
Participant
0 Kudos

travkin can you help.