Pricing for Export

[Former Member]

Hi all,

our company supplying materials out side of india and for export material we are maintaining the price in USD. the problem is in BI report the values are getting converted to INR and displays, and because of same the final or the total value for the order is missmatching. in R3 and BI. how we can rectify this problem.

Thanks &regards

Ashwini K.

[marcin_milczynski]

Hi,

You should adjust the BI report or create a new BI report showing the prices in document currency instead of local currency. You have correct information in the document, so the problem is on reporting side.

Regards,

Marcin

[Former Member]

HI Marcin,

in BI the scenario is as below.

In BI we are using 2LIS_13_VDITM data source which is taking value from two tables VBRP and VBRK respectively.

from VBRP - Subtotal 1 and from VBRK - Doc. currency (here the currency is USD)

but at the transformation level doc currency is getting converted to static currency and displaying values in INR at report level.

but i want additional field in BI report which has doc currency. how to get this field without disturbing the present settings.

Thanks

Ashwini K.