AR Invoice Import, DTW Error - Exchange rate not Updated

[Former Member]

HI Experts,

I am trying to Import A/R Invoice through DTW and getting the following error

"Exchange rate not Updated ,'USD' Application ....."

I am using minimum data and a sample given below

-

-

-

-

-

-

-

---

RecordKey DocEntry CardCode DiscountPercent DocCurrency DocDate DocDueDate DocNum DocType DocumentSubType

RecordKey DocEntry CardCode DiscountPercent DocCurrency DocDate DocDueDate DocNum DocType DocumentSubType

1 CU00001 0 INR 20090104 20090104 5656006 I --

-

-

-

-

-

-

-

---

Company is having Local currency INR, System Currency USD and Default account currency is INR.

I updated the exchange rate for all available currencies for the past four months, including closing month of last Fin year.

Please advice

Thanks and regards

Ajith G

[former_member187989 · Accepted solution]

Check this link

which may applies in solving issue.

[Former Member]

Hi Ajit,

First to enter the exchange for system date in Server, and then upload the data through DTW.

One point is that in the sample file you had specified the date is 20090104, where as the system date is different due to this the error appears.

In SAP Once you specify the system currency, which is not same as Local Currency, then you need to enter the exchange rates on daily basis based on the System date of the Server and on Posting date.

Hope this helps to resolve your issue.

Regards

Shanker

[Former Member]

Hi All,

Finally I am successful in Importing invoices.

Thanks to all who tried to help me out. Some of the replies are very helpful, even if it is not direct

When I corrected the record key reference , The error changed to "Internal error (-5000)"

Then

The DocType which I put in the Excel template was dDocument_Items. When I replaced this with "I"

System accepted the Invoice.

Thanks a lot for all once again

Regards

Ajith G

[former_member187989]

Uninstall Current DTW version,Reinstall DTW from packages folder of latest patch.

Jeyakanthan

[former_member187989]

hi ajith,

Problem might be with warehouse accounting tab,Check all relevant g/l accounts are defined.

Jeyakanthan

[Former Member]

Hi All,

My error with Exchange rate is now changed to the following

[I did werehouse mapping (Thanks Jayakanthan) and a date correction in the Data]

"Data cannot be empty in one of the Following Tables Doc1, Doc3, Doc10 [INV1.LineNum][line:0]Application defined or Object defined error65171"

I didn't see any tables named Doc1, Doc3 or Doc10

Please help

Thanks and regards

Ajith G

Edited by: Ajith G on Jun 22, 2009 10:57 AM

[former_member187989]

Have u selected correct database while login in DTW ?

Whether same issue occurs in SBO_Demo Database ?

[Former Member]

I tried it in OEC (SBODemoIN). But Error is the result

[Former Member]

Hello Experts,

Any clue to solve this situation?

Thanks

Ajith G.

[former_member187989]

Send me templates to id mentioned in business card.

[Former Member]

Hi Jayakanthan,

Send the template

Ajith G

[former_member187989]

hi ajith, whether ur problem solved ?

[Former Member]

No!!!!!!!!!!!!!!!!!!

Still Struggling.

[former_member187989]

Uninstall DTW,Reinstall DTW from packages folder,I got error before in sales order,

after Reinstalling DTW problem get solved,

[Former Member]

HI All,

I am nswering to all three who posted,

1) I had done Exchange Rate updation. This I mentioned in the first post itself.

2) Customers currency is LC, that is INR

3) I had tried with some other machine, in my network and currently I tried with my machine which is reinstalled last day.

Please Advice

Thanks

Ajith G

[Former Member]

Hi,

What is this customer's currency? Is it LC or FC?

Thanks,

Gordon

[msundararaja_perumal]

Hi,

Ensure first that you have updated exahange rate for USD in exchange rate and indexes which is found under the Administration module.Then try to import.

If issue persists raise a ticket to sap support