web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / eConnect exception:a v...
Microsoft Dynamics GP (Archived)

eConnect exception:a valid exchange rate could not be found for document date specified

(0) ShareShare
ReportReport
Posted on by ravi teja 90

when I am processing below purchasing transactions xml to econnect

- <eConnect xmlns:dt="urn:schemas-microsoft-com:datatypes">
- <taPMTransactionType>
- <eConnectProcessInfo>
<ProductName>V1.0</ProductName>
</eConnectProcessInfo>
- <taPMDistribution_Items>
- <taPMDistribution>
<DOCTYPE>1</DOCTYPE>
<VCHRNMBR>0000823</VCHRNMBR>
<VENDORID>MAN110</VENDORID>
<DISTTYPE>6</DISTTYPE>
<ACTNUMST>80-23000-000-00</ACTNUMST>
<DEBITAMT>1101.630000</DEBITAMT>
<CRDTAMNT>0.000000</CRDTAMNT>
<ACTINDX>21042</ACTINDX>
</taPMDistribution>
- <taPMDistribution>
<DOCTYPE>1</DOCTYPE>
<VCHRNMBR>0000823</VCHRNMBR>
<VENDORID>MAN110</VENDORID>
<DISTTYPE>2</DISTTYPE>
<ACTNUMST>01-10025-000-00</ACTNUMST>
<DEBITAMT>0.000000</DEBITAMT>
<CRDTAMNT>9914.670000</CRDTAMNT>
<ACTINDX>21041</ACTINDX>
</taPMDistribution>
- <taPMDistribution>
<DOCTYPE>1</DOCTYPE>
<VCHRNMBR>0000823</VCHRNMBR>
<VENDORID>MAN110</VENDORID>
<DISTTYPE>6</DISTTYPE>
<ACTNUMST>80-23000-000-00</ACTNUMST>
<DEBITAMT>1101.630000</DEBITAMT>
<CRDTAMNT>0.000000</CRDTAMNT>
<ACTINDX>21042</ACTINDX>
</taPMDistribution>
- <taPMDistribution>
<DOCTYPE>1</DOCTYPE>
<VCHRNMBR>0000823</VCHRNMBR>
<VENDORID>MAN110</VENDORID>
<DISTTYPE>6</DISTTYPE>
<ACTNUMST>01-10025-000-00</ACTNUMST>
<DEBITAMT>0.000000</DEBITAMT>
<CRDTAMNT>8813.040000</CRDTAMNT>
<ACTINDX>21041</ACTINDX>
</taPMDistribution>
- <taPMDistribution>
<DOCTYPE>1</DOCTYPE>
<VCHRNMBR>0000823</VCHRNMBR>
<VENDORID>MAN110</VENDORID>
<DISTTYPE>6</DISTTYPE>
<ACTNUMST>80-23000-000-00</ACTNUMST>
<DEBITAMT>1101.630000</DEBITAMT>
<CRDTAMNT>0.000000</CRDTAMNT>
<ACTINDX>21042</ACTINDX>
</taPMDistribution>
- <taPMDistribution>
<DOCTYPE>1</DOCTYPE>
<VCHRNMBR>0000823</VCHRNMBR>
<VENDORID>MAN110</VENDORID>
<DISTTYPE>6</DISTTYPE>
<ACTNUMST>01-10025-000-00</ACTNUMST>
<DEBITAMT>0.000000</DEBITAMT>
<CRDTAMNT>6609.780000</CRDTAMNT>
<ACTINDX>21041</ACTINDX>
</taPMDistribution>
- <taPMDistribution>
<DOCTYPE>1</DOCTYPE>
<VCHRNMBR>0000823</VCHRNMBR>
<VENDORID>MAN110</VENDORID>
<DISTTYPE>6</DISTTYPE>
<ACTNUMST>01-10025-000-00</ACTNUMST>
<DEBITAMT>0.000000</DEBITAMT>
<CRDTAMNT>7711.410000</CRDTAMNT>
<ACTINDX>21041</ACTINDX>
</taPMDistribution>
- <taPMDistribution>
<DOCTYPE>1</DOCTYPE>
<VCHRNMBR>0000823</VCHRNMBR>
<VENDORID>MAN110</VENDORID>
<DISTTYPE>6</DISTTYPE>
<ACTNUMST>01-10025-000-00</ACTNUMST>
<DEBITAMT>0.000000</DEBITAMT>
<CRDTAMNT>1101.630000</CRDTAMNT>
<ACTINDX>21041</ACTINDX>
</taPMDistribution>
- <taPMDistribution>
<DOCTYPE>1</DOCTYPE>
<VCHRNMBR>0000823</VCHRNMBR>
<VENDORID>MAN110</VENDORID>
<DISTTYPE>6</DISTTYPE>
<ACTNUMST>80-23000-000-00</ACTNUMST>
<DEBITAMT>1101.630000</DEBITAMT>
<CRDTAMNT>0.000000</CRDTAMNT>
<ACTINDX>21042</ACTINDX>
</taPMDistribution>
- <taPMDistribution>
<DOCTYPE>1</DOCTYPE>
<VCHRNMBR>0000823</VCHRNMBR>
<VENDORID>MAN110</VENDORID>
<DISTTYPE>6</DISTTYPE>
<ACTNUMST>01-10025-000-00</ACTNUMST>
<DEBITAMT>0.000000</DEBITAMT>
<CRDTAMNT>2203.260000</CRDTAMNT>
<ACTINDX>21041</ACTINDX>
</taPMDistribution>
- <taPMDistribution>
<DOCTYPE>1</DOCTYPE>
<VCHRNMBR>0000823</VCHRNMBR>
<VENDORID>MAN110</VENDORID>
<DISTTYPE>6</DISTTYPE>
<ACTNUMST>01-10025-000-00</ACTNUMST>
<DEBITAMT>0.000000</DEBITAMT>
<CRDTAMNT>3304.890000</CRDTAMNT>
<ACTINDX>21041</ACTINDX>
</taPMDistribution>
- <taPMDistribution>
<DOCTYPE>1</DOCTYPE>
<VCHRNMBR>0000823</VCHRNMBR>
<VENDORID>MAN110</VENDORID>
<DISTTYPE>6</DISTTYPE>
<ACTNUMST>80-23000-000-00</ACTNUMST>
<DEBITAMT>1101.630000</DEBITAMT>
<CRDTAMNT>0.000000</CRDTAMNT>
<ACTINDX>21042</ACTINDX>
</taPMDistribution>
- <taPMDistribution>
<DOCTYPE>1</DOCTYPE>
<VCHRNMBR>0000823</VCHRNMBR>
<VENDORID>MAN110</VENDORID>
<DISTTYPE>6</DISTTYPE>
<ACTNUMST>80-23000-000-00</ACTNUMST>
<DEBITAMT>1101.630000</DEBITAMT>
<CRDTAMNT>0.000000</CRDTAMNT>
<ACTINDX>21042</ACTINDX>
</taPMDistribution>
- <taPMDistribution>
<DOCTYPE>1</DOCTYPE>
<VCHRNMBR>0000823</VCHRNMBR>
<VENDORID>MAN110</VENDORID>
<DISTTYPE>6</DISTTYPE>
<ACTNUMST>80-23000-000-00</ACTNUMST>
<DEBITAMT>1101.630000</DEBITAMT>
<CRDTAMNT>0.000000</CRDTAMNT>
<ACTINDX>21042</ACTINDX>
</taPMDistribution>
- <taPMDistribution>
<DOCTYPE>1</DOCTYPE>
<VCHRNMBR>0000823</VCHRNMBR>
<VENDORID>MAN110</VENDORID>
<DISTTYPE>6</DISTTYPE>
<ACTNUMST>80-23000-000-00</ACTNUMST>
<DEBITAMT>1101.630000</DEBITAMT>
<CRDTAMNT>0.000000</CRDTAMNT>
<ACTINDX>21042</ACTINDX>
</taPMDistribution>
- <taPMDistribution>
<DOCTYPE>1</DOCTYPE>
<VCHRNMBR>0000823</VCHRNMBR>
<VENDORID>MAN110</VENDORID>
<DISTTYPE>6</DISTTYPE>
<ACTNUMST>80-23000-000-00</ACTNUMST>
<DEBITAMT>1101.630000</DEBITAMT>
<CRDTAMNT>0.000000</CRDTAMNT>
<ACTINDX>21042</ACTINDX>
</taPMDistribution>
- <taPMDistribution>
<DOCTYPE>1</DOCTYPE>
<VCHRNMBR>0000823</VCHRNMBR>
<VENDORID>MAN110</VENDORID>
<DISTTYPE>6</DISTTYPE>
<ACTNUMST>01-10025-000-00</ACTNUMST>
<DEBITAMT>0.000000</DEBITAMT>
<CRDTAMNT>4406.520000</CRDTAMNT>
<ACTINDX>21041</ACTINDX>
</taPMDistribution>
- <taPMDistribution>
<DOCTYPE>1</DOCTYPE>
<VCHRNMBR>0000823</VCHRNMBR>
<VENDORID>MAN110</VENDORID>
<DISTTYPE>6</DISTTYPE>
<ACTNUMST>01-10025-000-00</ACTNUMST>
<DEBITAMT>0.000000</DEBITAMT>
<CRDTAMNT>5508.150000</CRDTAMNT>
<ACTINDX>21041</ACTINDX>
</taPMDistribution>
</taPMDistribution_Items>
- <taPMTransactionInsert>
<BACHNUMB>APDBASICS103111</BACHNUMB>
<PSTGDATE>2011-08-31T00:00:00</PSTGDATE>
<VCHNUMWK>0000823</VCHNUMWK>
<VENDORID>MAN110</VENDORID>
<DOCNUMBR>8322</DOCNUMBR>
<DOCTYPE>1</DOCTYPE>
<DOCAMNT>1101.630000</DOCAMNT>
<DOCDATE>2011-08-19T00:00:00</DOCDATE>
<PRCHAMNT>1101.630000</PRCHAMNT>
<CURNCYID>Z-US$</CURNCYID>
<TRXDSCRN>MSO-019</TRXDSCRN>
<CHRGAMNT>1101.630000</CHRGAMNT>
<CREATEDIST>0</CREATEDIST>
</taPMTransactionInsert>
</taPMTransactionType>
</eConnect>

I am getting the econnect exception as below:

Sql procedure error codes returned:

Error Number = 265  Stored Procedure= taPMTransactionInsert  Error Description = An error occurred in the taMCCurrencyValidate proc


Error Number = 9389  Stored Procedure= taMCCurrencyValidate  Error Description = A valid Exchange Rate could not be found for the Document Date specified
Node Identifier Parameters: taMCCurrencyValidate
DOCDATE = 2011-08-19T00:00:00
Related Error Code Parameters for Node : taMCCurrencyValidate
EXGTBLID = Note: This parameter was not passed in, no value for the parameter will be returned.
DOCDATE = 2011-08-19T00:00:00

<taPMTransactionInsert>
  <BACHNUMB>APDBASICS103111</BACHNUMB>
  <PSTGDATE>2011-08-31T00:00:00</PSTGDATE>
  <VCHNUMWK>0000823          </VCHNUMWK>
  <VENDORID>MAN110         </VENDORID>
  <DOCNUMBR>8322                </DOCNUMBR>
  <DOCTYPE>1</DOCTYPE>
  <DOCAMNT>1101.630000</DOCAMNT>
  <DOCDATE>2011-08-19T00:00:00</DOCDATE>
  <PRCHAMNT>1101.630000</PRCHAMNT>
  <CURNCYID>Z-US$          </CURNCYID>
  <TRXDSCRN>MSO-019                       </TRXDSCRN>
  <CHRGAMNT>1101.630000</CHRGAMNT>
  <CREATEDIST>0</CREATEDIST>
</taPMTransactionInsert>

at Microsoft.Dynamics.GP.eConnect.ServiceProxy.CreateTransactionEntity(String connectionString, String xml)
   at Microsoft.Dynamics.GP.eConnect.eConnectMethods.EntityImportImplementation(String connectionString, String sXML, Boolean isTransaction)
   at Microsoft.Dynamics.GP.eConnect.eConnectMethods.ProcessEntityImport(String connectionString, String sXML, Boolean isTransaction)
   at Microsoft.Dynamics.GP.eConnect.eConnectMethods.CreateTransactionEntity(String connectionString, String sXML)

Can any one help me to troubleshoot this issue.
Thanks
Raviteja.


 

*This post is locked for comments

I have the same question (0)
  • Community Member Profile Picture
    Community Member on at

    Make sure that you have an FX rate set up for that date. The easiest way is to manually create a PM transaction and check what is required (what FX Rate table is being used etc.).

    Actually as a good test to see if its a set up issue - try manually entering one of the transactions in the import file.

    Ian.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Congratulations to the February Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans