Exchange Table ID not found
Sql procedure error codes returned:
Error Number = 939 Stored Procedure= taGLTransactionHeaderInsert Error Description = An error occurred in the taMCCurrencyValidate proc
Error Number = 6348 Stored Procedure= taMCCurrencyValidate Error Description = The Exchange Table ID does not exist for the Exchange Date specified
Node Identifier Parameters: taMCCurrencyValidate
Related Error Code Parameters for Node : taMCCurrencyValidate
EXGTBLID = Note: This parameter was not passed in, no value for the parameter will be returned.
EXCHDATE = 2017-4-15
<REFRENCE>A test 2</REFRENCE>
The field ExchangTableID doesn't even show up in the mapping tool as a field selection… ? so how can we pass this by to the SP ?
Thanks in advance for help.
Found the answer.
Reason is: In GP, the system allow to enter a date RANGE for exchange table. This is done by setting an expiration date. So if I add a rate for the 04/12/2017 with an expiration date of 07/12/2017, inside GP itself, I will be able to add transaction every day between april 12th and july 12th…. but eConnect doesn't feel this way. eConnect will only accept transaction for april 12th.. if you want to enter a transaction on, for example, april 20th, you'll have to add 04/20/2017 in the exchange rate table (in GP) despite the expiration date already set would allow transactions for few months (3 months in this exampel).
Oh well, crazy little thing. But I guess it wont happen too much since a real business has to update the exchange rate every day.
If you would like to submit an answer or comment, please sign in to the eOne portal.