Transaction Notification

[Former Member]

Hi All

I want a transaction notification on A/R invoice. Requirement is numbering series always be manual if user select any other series then massage should be come "please choose manual Series.

Thanks & Regard

Areeba Ali

[Former Member · Accepted solution]

Hi Areeba Ali

Try this:

IF @transaction_type='A' AND @Object_type = '13'

BEGIN

IF EXISTS (SELECT T0.DocEntry FROM dbo.OINV T0 WHERE T0.series != 100

AND T0.DocEntry = @list_of_cols_val_tab_del)

Begin

SET @Error = 13

SET @error_message = 'The series has to be Manual.'

End

END

You need to find out what is the manual series number for your A/R Invoice to replace 100

Thanks,

Gordon

[Former Member]

Thanks

Gordon and Rahul

solved

Thanks & Regard

Areeba Ali

[Former Member]

Hi Areeba........

Try this.........

If @object_type='13' and @transaction_type='A'
BEGIN 
If Exists (Select * from [dbo].[OINV] T0 
Where T0.DocEntry = @list_of_cols_val_tab_del and T0.Series>0 And T0.Handwrtten='N' )
BEGIN
Select @error = -1,
@error_message = 'Please Select Appropriate Form Category'
End
End

Regards,

Rahul