Skip to Content

'TAX Code is NOt Applicable For Two Group Items

Hi

Every One

Bellow Sp is Not Working ,,Any One help to Correct it

if @object_type='18' and @transaction_type='A'

Begin

if exists(SELECT DISTINCT 'TRUE' FROM OPCH T0 INNER JOIN PCH1 T1 ON T0.DocEntry = T1.DocEntry INNER JOIN OITM T2 ON T1.ItemCode = T2.ItemCode WHERE T2.[ItmsGrpCod] IN ('117','110') AND T1.[TaxCode] IS NULL AND T0.[DocType] ='I' AND T1.DocEntry= @list_of_cols_val_tab_del)

Begin

set @error = '-2'

set @error_message = 'TAX Code is NOt Applicable For METAL AND SAND.... '

end

End






----RAMUDU

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • Best Answer
    Jun 04, 2015 at 04:06 AM

    Hi Ramdu,

    Please check this area.

    "AND T1.[TaxCode] IS NULL "


    Please give specific tax codes which is/ are not applicable.


    SAP B1 won't allow to add AP Invoice without tax code.


    Thanks

    Unnikrishnan

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jun 04, 2015 at 05:46 AM

    Hi,

    Please try the below:

    if @object_type='18' and @transaction_type='A'

    Begin

    if exists(SELECT T0.DocEntry

    FROM OPCH T0

    INNER JOIN PCH1 T1 ON T0.DocEntry = T1.DocEntry

    INNER JOIN OITM T2 ON T1.ItemCode = T2.ItemCode

    WHERE T2.[ItmsGrpCod] IN ('117','110')

    AND T1.[VatGroup] <>'ZERO'

    AND T0.[DocType] ='I' AND T0.DocEntry= @list_of_cols_val_tab_del)

    Begin

    set @error = '-2'

    set @error_message = 'TAX Code should be "Zero" For METAL AND SAND... '

    end

    End

    Regards,

    Isaac.

    Add comment
    10|10000 characters needed characters exceeded