Need HELP IN STORE PROCEDURE

[Former Member]

Hi

If Taxcode in por1 is not equal to por4 table taxcode then document should not get added.

Regards,

Karthik B

[former_member184146 · Accepted solution]

Hi,

     Try this

IF @object_type='22' AND @transaction_type IN ( 'A','U')

begin

IF EXISTS(Select A.DocEntry from OPOR A INNER JOIN  POR1 B ON A.DocEntry=B.DocEntry INNER JOIN POR4 C

ON A.DocEntry=C.DocEntry AND B.DocEntry=C.DocEntry

  WHERE   B.TaxCode<>C.StcCode AND A.DOCENTRY=@list_of_cols_val_tab_del  )

BEGIN

SET @error = 121

SET @error_message = 'Please select the same type of Tax in frieght and Items'

END

END

Regards,

Manish

[Former Member · Accepted solution]

Thank you Manish for the help

Regards,

Karthik