You’re offline. This is a read only version of the page.
Announcements
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
I have the same question (0)
Peter,
I see you entered this transaction in the system to confirm it - that is a great place to start. I am looking at your Currency ID, and was curious if you'd paid close attention to this, as it typically auto-fills with the Functional Exchange rate, so if you're hard coding it in a transaction and it's wrong you might not pick up an error when entering the transaction manually.
Here is a very similar post to yours: community.dynamics.com/.../66128.aspx
I would suggest taking a hard look at your code - is it necessary to specify so much of the information around foreign currency?
Share
Report
All responses (
Answers (
12,931
