Uplaod JE with the use of DTW with exchange rate

[former_member203816]

Dear Expert,

I want to upload the bulk of Journal Entry with the use of DTW.

But I have issue with Transaction Rate because in a day I have multiple transaction rate.

My Local Currency is Indian Rupees & System Currency is US $.

So when I upload the JE it's calculate the system currency value as per defined rate in exchange rate window in SAP B1.

So I want to defined my exchange rate defined in it self in DTW.

I also use TransRate field in DTW but still same issue.

Thanks & Regards,

Tushar Nathwani

[Former Member]

Hi,

The easiest way to do this is, convert everything in USD in excel, and use usd in front of amount in template and upload, eg: usd 12.6 etc,, the header level exchange rate in Journal entry wont suffice the issues related to multiple currency transactions.

Regards

Venkatesh

[kothandaraman_nagarajan]

Hi Tushar Nathwani,

Please check with SAP notes :

1699325  - Conversion in DTW not uploading properly

Thanks & Regards,

Nagarajan

[former_member203816]

HI Nagarajan,

Thanks..

I will check this & reply the same.

Thanks & Regards,

Tushar Nathwani

[Former Member]

Hi Tushar....

If you need all these details in One Journal Entry where Multiple currecies are dealing with multiple exchange rates then you have to make certain settings for that.

Please check whether you have kept unckecked the Block Multiple Currency Transactions under Document Settings--> Per Document tab--> Journal Entry

I think this will help you out...

Regards,

Rahul