180
I'm getting this error when trying to post an invoice transaction using eConnect
Error Posting bill (xxxxx): Sql procedure error codes returned:
Error Number = 696 Stored Procedure taMCCurrencyValidate Error Description = An EXGTBLID default was not found for the CURNCYID and RATETPID - please check the setups in Great Plains
*This post is locked for comments
Hi Wesley,
Did you ever figure out a solution on this issue? I can't seem to get around it.
Any suggestions on what you ended up doing or using as a workaround would be very helpful.
We are not using Multi-currency.
I believe the problem is because the Currency ID being passed is not the same as the Functional Currency, then it tries to go get the Exchange Table ID and Rate Type ID and if it can't find one then it will error out with this error.
Are you passing a Currency ID other than Functional? If so, and you are registered for Multi-Currency, then you need to go through the setup for this currency and verify that you have and exchange table and rate type id set up.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (