Error converting data type nvarchar to numeric 'witholding tax' (OWHT)

Advertisement
October 11

Hi Guys.
After I have upgraded my clients 2007 PL 30 database to 8.81 PL05, and running a repair to fix inconsistincies, I am receiveing some error when opening any sales documents.
It takes place when I open a sales document, or browse previous docs. When browsing previous docs, it onlly happens on some of them.
I also receive a different error when viewing sales orders: Error converting data type nvarchar to numeric (CRD2).
Any ideas how to fix it?
It does not limit me from processing and using the rest of the functionality. All calculations with queries in the docs are still working.
Thanks.

Advertisement

Replay

Hi,
Please check Note No. : 1402855 and see if the same applied to the issue mentioned by you.
Kind Regards,
Jitin
SAP Business One Forum Team

View 3 Replies

Saving result from sp_executesql into a variable and using dynamic column name - getting error "Error converting data type varchar to numeric"

October 11

Im getting an error when running a procedure that includes this code. I need to select from a dynamic column name and save the result in a variable, but seem to be having trouble with the values being fed to sp_executesql DECLARE @retval AS DECIMAL(1

View All Replies

CF9, no hotfix, VendorErrorCode 8114, cfprocresult error converting data type

November 30

Hello, everyone. I've got an issue that really has me scratching my head.  Not sure where the issue lies, but I'll explain as best I can. Basically, I _think_ I'm being told that one of the fields in the recordset is not being converted. On one page,

View All Replies

Error converting data when updating table

November 30

Hi, I need to understand why I cannot gat my update to work properly, I have to concat 4 fields (numbers with leading zeros so I can create a new number with leading 1. My field is already set as a bigint but I cannot convert the resulting string pro

View All Replies

Problem with converting data types

November 30

Hi Experts, I am stuck up with a little problem, i need your help i am converting all the data types to CHAR but i am not getting the expected data out......... My code is as below...where do i go wrong... LOOP AT <T_ITAB> ASSIGNING <FIELD>. D

View All Replies

Convert DATE type

November 30

CreateFUNCTION [dbo].[dates](@strDate NVARCHAR(10)) RETURNS Date AS BEGIN DECLARE @strInputDate    VARCHAR(10) DECLARE @strOutPutDate  Date DECLARE @strLen          INT  SELECT @strInputDate = LTRIM(RTRIM(ISNULL(@strDate, SELECT @strLen = LEN(LTRIM(R

View All Replies

No-rounding while converting data type F to Packed

November 30

Hi All, I want to pass value of a variable of data type F to another variable of dtata type P with decimals 3. While converting values decimals are getting rounded to next higher value. Can any one tell me how to retain the actual values,without roun

View All Replies

How to Convert Data types here

November 30

Hi All, My stored proc is as below, create or replace procedure proc_sec_synch ( Begin FOR sec_Update in ( Select SsM_ID , CYCLE_DATE , TARGET_TABLE , COLUMN_NAME , NEW_DATA  , COLUMN_TYPE from PM_OWN.test_synch order by target_table Loop *'Update' |

View All Replies

Convert data

November 30

i m trying to use except to match some columns  select [src] from book5 except select [home_phone] from Lead the src column is float, and the home_phone col is char, i m getting this error  Msg 8114, Level 16, State 5, Line 1 Error converting data ty

View All Replies

Problem accessing basic data types

October 11

Hi, I am a newbie at using JNI so please don't mind if I am asking something trivial. I have a JNI wrapper for a native C code. The C code is a Gtk+ application using GLib library. This library has it's own basic data types. For example, "gchar"

View All Replies

Data type mismatch when inserting into text field

November 30

Hello all, Using VB script and ASP. I have a page that inserts into a field (casenum) in a table (clientsw) in a database. The field (casenum) in the table is data type TEXT : I create a recordset and then an insert statement which the following is p

View All Replies

CAST Not working for me - Arithmetic overflow error converting int to data type numeric - error

October 11

GPM is DECIMAL(5,2) PRICE is DECIMAL(11,4) COST is DECIMAL(7,2) Trying to update the Gross Profit Margin % field and I keep getting the "Arithmetic overflow error converting int to data type numeric" error. UPDATE SMEMODETAIL SET SMD_GPM = (SMD_

View All Replies

Conversion failed when converting the nvarchar value to data type int when returning nvarchar(max) from stored procedure

November 30

Thank you for your help!!!  I've created a stored procedure to return results as xml.  I'm having trouble figuring out why I'm getting the error message "Conversion failed when converting the nvarchar value '<tr>.....' to data type int.    It s

View All Replies

Conversion failed when converting the varchar value to data type int error

November 30

Hi, I am working on a report which is off of survey information and I am using dynamic pivot on multiple columns. I have questions like Did you use this parking tag for more than 250 hours? If yes specify number of hours. and the answers could be No,

View All Replies

Error message: Conversion failed when converting the varchar value 'G001985' to data type int

November 30

Here is my script: select name_id, physican_id, primary_name, last_name, first_name from dbo.tblphysiciannames where (physician_id = 'G001985') How to convet the varchar va;e tp data type int? Thank you for your help. SallyDo you have varchar column

View All Replies

Activation error while changing the data type of a field of a table

October 11

hi friends, i am facing one problem while changing a data type of a field of a table. i just created one table(Yqm32) .i have assigned charcter data type to one field(ztotal_count) .now i want to change this charcter data type to numeric data type.  

View All Replies

How to fix "cannot convert between unicode and non-unicode string data types" :/

November 30

Environment: SQL Server 2008 R2 Introduction:Staging_table is a table where data is being stored from source file. Individual and ind_subject_scores are destination tables. Purpose: To load the data from a source file .csv while SSIS define table  fi

View All Replies

InfoPath - "Schema validation found non-data type errors." at XmlWriter.Close()

November 30

Greetings,  I'm creating a form that allows for emailing attachments however I am having an issue. When I try to attach a file, I get an "Schema validation found non-data type errors." error message. It seems like it's something with the XML str

View All Replies

Error:  A newer version of data type was found than one required

November 30

Hi Experts, we made a changes to a table and then transported the table to the quality system. But a program which is referring to this table, results in dump with the below error message. Error Message>>>>>>>>>>" A newe

View All Replies

Data type conversion from packed to numeric

November 30

Hi Experts, i have a question on data type conversion. My requirement is: i have fields of type packed decimal in my internal table itab. I need to convert the values of packed decimal fields in itab to numeric type. Example: Data: begin of itab occu

View All Replies

Tags:

  1. 1020dead soulision
  2. how to fix error recovery my27
  3. difference in fgi0 and ke30
  4. xai class http
  5. lsmw RV14BTCI
  6. 305500 non oracle exception
  7. fb02 auth objects
  8. CC&B xai
  9. SAP PI CPIC-CALL: ThSAPCMRCV
  10. throughoutrpq
Copyrights 2019 Fcffair BigData Resource, All rights reserved