Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

SP For JE

Hi friends,

              If I create journal entry for below 500 rupees it is should be add and it should be a transaction Journal entry . if they will create above 500 rupees it should not be add. block  the entries in SP . but through the journal voucher create a JE for above 500 rupees it is should be add. how we will block this concept . i create a store procdure but it is working all concept . as per above concept how will i create .

if @object_type=N'30' and (@transaction_type=N'A' or @transaction_type=N'U')

begin

 

  IF exists (select LocTotal

   from OJDT O  inner join JDT1 J On  J.TransId = O.TransId

where LocTotal<=500) 

BEGIN

Select @error = -5001,

@error_message = 'JE Amount Should be Below Thousand'

END

end

Former Member
Not what you were looking for? View more on this topic or Ask a question