[Microsoft][SQL Server Client 10.0][SQL Server]Conversion failed when converting the nvarchar value 'DocEntry'to data type int.(CINF)

[Former Member]

Hi

when adding GRPO ITS SHOWING AN ERROR [Microsoft][SQL Server Client 10.0][SQL Server]Conversion failed when converting the nvarchar value 'DocEntry'to data type int.(CINF)

[Former Member · Accepted solution]

Is there any SP Transaction running ?

[Former Member · Accepted solution]

YES

[Former Member · Accepted solution]

So, you have to check dat ..

Can U plz paste that Over here..

[Former Member · Accepted solution]

if @transaction_type In ('A','U') and @object_type ='17'

--Begin

--If Exists (Select B.ItemCode from ORDR A inner join RDR1 B on A.DocEntry=B.DocEntry where B.TaxCode is Null and A.docEntry=@list_of_key_cols_tab_del )

--Begin

--Set @error =1001

--Set @error_message = 'Tax Code Should not be blank at row Level'

--End

--End

[Former Member · Accepted solution]

Hi Karthik,

Please check below SP Transaction Notification after little amendment.

if @transaction_type In ('A','U') and @object_type ='17'

Begin

If Exists (Select A.DocEntry from ORDR A inner join RDR1 B on A.DocEntry= B.DocEntry where B.TaxCode is Null and A.DocEntry=@list_of_key_cols_tab_del )

Begin

Set @error =1001

Set @error_message = 'Tax Code Should not be blank at row Level'

End

End

Hope this help

--

--

Regards::::

Atul Chakraborty

[Former Member · Accepted solution]

The issue is with your SP only .. I m also getting d same error but on SO screen .. U must  be using the same SP for all MArketing documents ..

[Former Member · Accepted solution]

Plz update this SP :

if @transaction_type In ('A','U') and @object_type ='17'

Begin

If Exists (Select A.DocEntry from ORDR A inner join RDR1 B on A.DocEntry= B.DocEntry where B.TaxCode =' ' and b.DocEntry=@list_of_cols_val_tab_del )

Begin

Set @error =10

Set @error_message = 'Tax Code Should not be blank at row Level'

End

End

[Former Member · Accepted solution]

thanks

[Former Member · Accepted solution]

thanks

[Former Member · Accepted solution]

Plz close the thread by marking correct and helpful answer if you have got ur solution .. If not then update why so ?

[Former Member · Accepted solution]

Thanks for the solution the issue is solved.

[Former Member]

Thanks for the solution the issue is solved.

[Former Member]

Plz close the thread my marking correct and helpful answers for others reference.

[Former Member]

Hi Karthik,

If you got Answer then Close this Thread.

Thanks

--

--

Regards::::

Atul Chakraborty