Skip to Content

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

Conversion failed when converting the nvarchar value to data type int. (CINF)

Hi,

When executing stored procedure its showing the error [Microsoft][SQL Server Native Client 10.0][SQL Server]Conversion failed when converting the nvarchar value 'Customer Credit Period Exceeds' to data type int. (CINF)

if @object_type='17' and (@transaction_type in ('U'))

begin

declare @cnt2 int

    set @cnt2=0

    select @cnt2=Count(*) from ORDR P1 where P1.Docentry=@list_of_cols_val_tab_del and

    (Select cast(DATEDIFF(DAY,isnull((select top 1 docdate from OINV where CardCode=P1.CardCode and DocStatus='O'

    and (DocTotal-PaidSum)>1000 order by DocDate),getdate()),P1.DocDate)))>(10+Isnull((select ExtraDays  from octg

    where GroupNum=(select groupnum from OCRD where CardCode=P1.CardCode)),0))

  

    begin

                set @error='10001'

             SET @error_message='Customer Credit Period Exceeds'

                return @error_message

    end

end

Former Member
Not what you were looking for? View more on this topic or Ask a question