Using the following to attempt to push a PM transaction into GP. Getting error " 265 - taPMTransactionInsert An error occurred in the taMCCurrencyValidate proc". If I enter manually into GP I get no error. any ideas?
DECLARE @O_iErrorState NVARCHAR(255)
DECLARE @oErrString NVARCHAR(255)
DECLARE @rc INTEGER
EXECUTE @rc= BOAUS.[dbo].[taPMTransactionInsert] @I_vBACHNUMB='AP091814.50868 ', @I_vVCHNUMWK='00000000000061247', @I_vVENDORID='ANDER003 ', @I_vDOCNUMBR='00000000000061247 ', @I_vDOCTYPE='1', @I_vDOCAMNT='13.05000', @I_vDOCDATE='08/03/2014', @I_vPSTGDATE='09/18/2014', @I_vDUEDATE='01/01/1900', @I_vDSCDLRAM='0.00000', @I_vDISCDATE='01/01/1900', @I_vPRCHAMNT='13.05000', @I_vCHRGAMNT='13.05000', @I_vCASHAMNT='0.00000', @I_vCAMTDATE='01/01/1900', @I_vCHEKAMNT='0.00000', @I_vCHEKDATE='01/01/1900', @I_vCRCRDAMT='0.00000', @I_vCRCARDDT='01/01/1900', @I_vTRDISAMT='0.00000', @I_vTAXAMNT='0.00000', @I_vFRTAMNT='0.00000', @I_vTEN99AMNT='0.00000', @I_vMSCCHAMT='0.00000', @I_vDISAMTAV='0.00000', @I_vDISTKNAM='0.00000', @I_vAPDSTKAM='0.00000', @I_vPOSTEDDT='01/01/1900', @I_vPRCTDISC='0.00', @I_vTax_Date='01/01/1900', @I_vCURNCYID='ZAR ', @I_vXCHGRATE='0.0000000', @I_vEXPNDATE='01/01/1900', @I_vEXCHDATE='01/01/1900', @I_vRATEEXPR='0', @I_vDYSTINCR='0', @I_vRATEVARC='0.0000000', @I_vTRXDTDEF='0', @I_vRTCLCMTD='0', @I_vPRVDSLMT='0', @I_vDATELMTS='0', @I_vTIME1='01/01/1900', @I_vCREATEDIST='0', @I_vRequesterTrx='0', @O_iErrorState='' ,@oErrString=''
PRINT @o_IERRORSTATE
PRINT @oERRSTRING
SELECT * FROM DYNAMICS..TAERRORCODE WHERE ERRORCODE = @rc
*This post is locked for comments