Skip to Content

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

'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

Tags:
replied

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

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question