SP For JE
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')
IF exists (select LocTotal
from OJDT O inner join JDT1 J On J.TransId = O.TransId
Select @error = -5001,
@error_message = 'JE Amount Should be Below Thousand'