Currency difference in PCA reports

[Former Member]

Dear All,

I am facing an issue in PCA report. When I run t code: S_ALR_87013326 for a particular profit center values are showing in the PrCt currency ie. SAR. Later, if I want to check the company code currency (e.e. EGP) by selecting currency translation and select EGP as currency and choose "default for drill down report. Here the value is showing as below:

Later, come back and check for actual line items, the value is showing different as below:

What I have observed is, I have checked the currency settings. Till 20.05.2014, currency translations was 1 SAR to 1.86 EGP. From 23.05.2014, we have changed the exchange rate as 1 SAR = 1.90 EGP. Today, I checked the profit center report for March 2014, it is converting the local currency (EGP) value with today's currency exchange rate i.e. 1.90. Actually it should be calculated based on 1.86.

How to achieve the above scenario?

Br, Srinivas Salpala

[ajaycwa1981 · Accepted solution]

Hi Srinu

Go to KE84 and create a new form copying it from 8A-PCA001G

Simply change the Key Figure from Pr Ctr Local Curr to HSL (Co Code Curr)

System will display the values as they were posted witout any conversion..

Is this what you wanted?

Br. Ajay M

[Former Member · Accepted solution]

Hi Ajay,

Actually, when we check the report, initially values are in SAR. Later, when the user going for currency translation as shown in the below and select the local currency in EGP and choose "Default to drill down reporting" value is showing is converted with the today's rate i.e. 1.90 and the value is 76,612.90.

But when I come back and double click on the item to check actual line item with "In company local currency" from change layout, value is showing only EGP75,000.

Here, client wants when he checks with the currency translation as shown below, the value the value of SAR40,322.58 should be consider the exchange rate 1.86 (which was there at the time of posting the transaction in the month of March 2014). But its considering the exchange rate as 1.90 which is for today's rate.

How to achieve this?

BR, Srinivas Salpala

[ajaycwa1981 · Accepted solution]

Hi Srinu

Why do you want to convert as long as you wanna see in Comp code curr or Pr Ctr Local Curr?

These values are calculated individually for each transaction and you just need to create another report to see values in Comp Code Curr

The conversion option must be used for any other currency apart from these two..

Thats my understanding..

Br. Ajay M

[Former Member · Accepted solution]

Ajay,

Actually its client requirement. Can't we achieve the above requirement Ajay?

Br, Srinivas  Salpala

Message was edited by: Srinivas Salpala

[Former Member · Accepted solution]

Ajay,

In KE8C t code, we can maintain currency translation keys. For key - 899, if we switch on "Inversion flag" will it be useful?

Inversion flag definition says:

Currency translation: Inversion flag

If you check this field, the currency will be translated using the inverse exchange rate.

Example:
On 1/1/1992, the US dollar cost DM 2.00, and the DM cost USD 0.45. Sales made on this day in dollars are translated into DM when they are posted in the system. If you wish to translate this amount back into the original currency, it can be achieved simply by using the inverse rate 1 / (DM 2.00 / USD) = USD 0.50 / DM which arrives at the exact original amount. To do this, set the 'Invert' flag with 'X'.

Note that you cannot control the exchange rate with this flag. The global Customizing settings for currency conversion are not affected. See also the documentation on exchange rates.

Br, Srinivas  Salpala

[ajaycwa1981 · Accepted solution]

Hi Srinu

This is where you need to educate your client..

They are trying to do a conversion and then they wish to see the same result as Originally posted

Conversion is just a run time conversion where as the actual line items show you data as posted

You will need a separate report and both of them can be visible to you when you execute your S_ALR report.. This is what I have seen companies handling it

Or else, create a new report which shows both values side by side i.e. Pr Ctr Local Curr and Comp Code Currency

Br. Ajay M

[Former Member · Accepted solution]

Hi Ajay,

I have created a new PCA customized report with Com code currency and profit center currency. But whatever amount showing under the com. code currency balance is not matching with the FS10N balance.

Please find the below screens:

Customized profit center report screen:

FS10N report for the particular GL:

BR, Srinivas Salpala

[ajaycwa1981 · Accepted solution]

Hi

This is a different issue

You need to reconcile FBL3N with KE5Z.

Balance sheet accounts flow to PCA only if they are assigned in 3KEH

Br. Ajay M

[Former Member · Accepted solution]

Hi Ajay,

Thank a lot! I will check and update..

BR, Srinivas Salpala

[Former Member · Accepted solution]

Hi Ajay,

I have done the reconciliation for FBL3N and KE5Z. The difference amount is coming from only profit center for 5th period. Remaining all amounts are with other profit centers values are fine which were posted on 3rd period.

What could be the reason with this only one profit center and period 5? When I check the report S_ALR_87013326 - profit center plan/actual value, it is showing different value when compare to FBL3N.

BR, Srinivas Salpala