I have an issue using web services when trying to create a receivables invoice.
The following procedure results in the error "The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value. The statement has been terminated.":
declare @p78 int
set @p78=0
declare @p79 varchar(255)
set @p79=''
exec taRMTransaction @I_vRMDTYPAL=1,@I_vDOCNUMBR='0000001 ',@I_vDOCDATE='2012-05-04 00:00:00:000',@I_vBACHNUMB='1 ',@I_vCUSTNMBR='ANHESAMO ',@I_vDOCAMNT=512.50000,@I_vSLSAMNT=512.50000,@I_vDOCDESCR=default,@I_vADRSCODE=default,@I_vSLPRSNID=default,@I_vSALSTERR=default,@I_vSHIPMTHD=default,@I_vTAXSCHID=default,@I_vCSTPONBR=default,@I_vCOSTAMNT=default,@I_vTRDISAMT=default,@I_vTRDDISCT=default,@I_vFRTAMNT=default,@I_vMISCAMNT=default,@I_vTAXAMNT=0,@I_vBKTSLSAM=default,@I_vBKTFRTAM=default,@I_vBKTMSCAM=default,@I_vCASHAMNT=default,@I_vCBKIDCSH=default,@I_vCASHDATE=default,@I_vDCNUMCSH=default,@I_vCHEKAMNT=default,@I_vCBKIDCHK=default,@I_vCBKIDCRD=default,@I_vCHEKNMBR=default,@I_vCHEKDATE=default,@I_vDCNUMCHK=default,@I_vCRCRDAMT=default,@I_vCRCRDNAM=default,@I_vRCTNCCRD=default,@I_vCRCARDDT=default,@I_vDCNUMCRD=default,@I_vDISCRTND=default,@I_vDISTKNAM=default,@I_vWROFAMNT=default,@I_vPPSAMDED=default,@I_vGSTDSAMT=default,@I_vPYMTRMID=default,@I_vDISAVAMT=default,@I_vDSCDLRAM=default,@I_vDSCPCTAM=default,@I_vLSTUSRED=default,@I_vPTDUSRID=default,@I_vDistRef=default,@I_vBatchCHEKBKID=default,@I_vDUEDATE=default,@I_vDISCDATE=default,@I_vCURNCYID=default,@I_vXCHGRATE=1.0000000,@I_vRATETPID=default,@I_vEXPNDATE=default,@I_vEXCHDATE=default,@I_vEXGTBDSC=default,@I_vEXTBLSRC=default,@I_vRATEEXPR=default,@I_vDYSTINCR=default,@I_vRATEVARC=default,@I_vTRXDTDEF=default,@I_vRTCLCMTD=default,@I_vPRVDSLMT=default,@I_vDATELMTS=default,@I_vTIME1=default,@I_vCOMDLRAM=default,@I_vCOMAPPTO=default,@I_vRequesterTrx=0,@I_vCREATEDIST=0,@I_vUSRDEFND1=default,@I_vUSRDEFND2=default,@I_vUSRDEFND3=default,@I_vUSRDEFND4=default,@I_vUSRDEFND5=default,@O_iErrorState=@p78 output,@oErrString=@p79 output
select @p78, @p79
Exporting the same invoice on a different system does not cause any problems. Does anyone know what I can check to see what might be different between the two or what i can try to resolve the problem?
Thank you.
