Skip to Content
author's profile photo Former Member
Former Member

DTW Error -- "Exchange Rate Not Updated"

After resolving my other document loading errors identified by the DTW, I now receive the same error for every record that I try to load for Purchase Invoices, Sales Orders and Sales Invoices. It is…

<b>Exchange rate not updated, ‘USD’ Notice: all records are rollbacked.</b>

Any idea how to fix this? I'm confused since I built the company with both Local and System Currencies as “US Dollar”, the Default Account Currency is the “Local Currency”, and the document load includes the DocCurrency field (set to "USD").

I need to get this data loaded soon. Any help would be greatly appreciated!

Kind Regards,

Scott

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

17 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on May 09, 2005 at 08:13 PM

    Scott,

    1. I think that the GL code is automatically generated upon purchase order data entry. i don't code the GL code into my xml.

    2. I think if you specify the DocType to 'services' rather than goods' you might not get the error of missing item code.

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      an absurd question, when you imported your pricelist (item_prices.xls) you have set the currency value with USD?

      If you haven't this could be the reason of your problem.

      Apologizes if you did it, is for eliminate possibilities

      Regards

      Salvador Biot

  • Posted on May 09, 2005 at 06:19 AM

    Dear Scott You have to make sure that Document Date which Your PO,SO,Invoice A/R want to Upload through DTW , has been defined its currency value based on Document Date.

    For Example If your A/R Invoice date on 9 May you have to input Your Local Currrency Exchange to System Currency on 9 May.

    Hopefully Helps.

    HamdiSy

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on May 09, 2005 at 02:43 PM

    Hamdi, thank you for your response.

    For a multi-currency Company setup, I would usually think to go to the "Define Foreign Currency Exchange Rates" screen to define the LC to SC exchange rate. And, should I have more than 2 currencies defined for the system, then this is where I would define the other exhchange rates as well (even though I'm unsure how to add more currencies beyond the LC and SC). However, I have both the LC and SC set to USD; and, the "Default Account Currency" field on the "Company Details" screen is set to "Local Currency" (not "Multi-Currency"). In this configuration, there is only one column (the day number) defined on the "Exchange Rates" tab. So, I cannot fill in a LC-to-SC exchange rate (which, of course, would have to be 1:1). At this point, I'm assuming the "Define Foreign Currency Exchange Rates" screen is functioning as expected (adding no columns for any currencies since they are all USD); and, it is the Data Transfer Wizard (DTW) that has a bug. I am assuming that the DTW has been programmed to look for an exchange rate in the ORTT table, which has no records defined in it.

    If this is a known bug, I would greatly appreciate someone from SAP acknowledging this fact.

    Scott

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on May 09, 2005 at 02:58 PM

    If it is a bug, might I trick the DTW by loading exchange rate records into the ORTT table for all the dates that I am loading?

    (While I could do this, it is a pain since I have thousands of Purchase Invoice, Sales Order and Sales Invoice documents to load with "DocDate"s that span more than a year.)

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on May 09, 2005 at 03:28 PM

    Hamdi,Scott

    I am receiving the same exception, are you trying to say that I need top specify the <DocRate> or <DocCurrency> in the SOAP message

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on May 09, 2005 at 03:46 PM

    I am using the Data Transfer Wizard, are you using a custom-written program to perform your loading?

    Thus far, I have only added the DocCurrency field to my document loads, setting it to "USD". I have not yet added the DocRate field since the documentation I have says that it is only for Foreign Currencies. Maybe I have to do this anyway????

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on May 09, 2005 at 04:36 PM

    Scott,

    I have developed a web service that imports POs. It's kind of strange because at one time I was able to add w/out using DocCurrency in my SOAP message. I'll try what you recomended. Thanks

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on May 09, 2005 at 05:16 PM

    Please post your results. If successful, I will try the same with the Data Transfer Wizard. Thanks!

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on May 09, 2005 at 05:20 PM

    That didn't seem to work

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on May 09, 2005 at 05:48 PM

    Maybe someone from SAP could respond??? Do they think this is a bug? Any suggestions?

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.