CT_NEWCAL - Currency conversion issues

[sap_user62]

Hello Friends,

Env bpc standard10.1 on hana

Our consolidation model (YTD), went live around 4 years back. There were no change was made for these rules in the past 4 years. We went live with BW7.5 SP19 upgrade last month. After upgrade, when I ran the month end process for November Close, there were huge differences in currency conversion for PL accounts – in millions.

Raised an SAP note and support team suggested to enable the environment parameter CT_NEWCAL .After including this parameter and running Nov month again the results tied out to penny. [ I did not run all the prior periods again]

Now we are in December close, I see currency conversion difference around 200-300$, I don’t see a clear pattern in either the account or company code which is resulting in this error.

Anomalies

• When the LC and USD values for the current month are zero (no movements for the month) there is a cta generated which causes a difference. But this is not for all cases where the LC and USD are zero.
• There is LC and USD values from the source, but currency conversion is giving small discrepancies like less than few dollars. example if exchange rate is 0.00539 for lkr, the rate calculation is using is 0.005390098(obtained by manual division), the result is a difference of few $ only, but cant pin point on why is it behaving this way. Not all LKR are bad.

Let me know if you any insights on how to solve this.

SELECT(%TIME_PERIOD%,"[ID]",TIME,"OPEN = 'Y'")
*RUN_PROGRAM CURR_CONVERSION
	CATEGORY = %CATEGORY_SET%
	GROUP = %SCOPE_SET%
	TID_RA = %TIME_PERIOD%
// OTHER = [COMPANY = %ENTITY_SET%]
	RATEENTITY = Global
*ENDRUN_PROGRAM

[sap_user62]

Additional Question - in a business rule if there are 3 lines, will new data generated as part of first line, be processed in the same rule in line 2 or line3 if conditions permit.

Is there a commit after each line of the rule or only at the end of the business rule.

[former_member186338]

From the old CURRENCY conversion document:

"INPUTCURRENCY Dimension - Property – MD
This property is used to denote the relationship between current currency and the standard
currency. It can take two values:
😧 Dividend. If Property “MD” does not exist, “D” is default relationship.
M: Multiple. If the rate of a currency to the standard one is a very small number, for example the
Italy lira to USD, we can store the amount in lira equal to 1 USD, and mark it as “M”. This
property can be used to improve accuracy."

[sap_user62]

All the currencies in the inputcurrency dimension are set to M for Multiply Divide property in the system.

[former_member186338]

sap.user62

M for exchange rate 0.00539?? Strange! Try to use D

Can you show sample of your rate table.

[sap_user62]

I have attached a screenshot of Rates tables, we get the data from ECC.

Is it possible for the currency rule to generate a value in F80, if there is no movement for the current month?

[former_member186338]

Please use test environment and compare results of M and D.

Periodic calc may generate records.

[sap_user62]

Thanks Vadim, I will try this out in test.

Periodic calc may generate records - till last month in the system, I have not seen a posting in F80, where the LC is zero.

This is my understanding,

Model is YTD, in business rule Periodic calc is checked for the first 2 entries. So the rule should work on periodic movements only

[LC YTD(current month) - LC YTD(prior month) ] * AVG rate = this should generate zero records as there is no movement in the current month.

Same with the second line too. - no records should be generated. - so F80 should have no posting.

[former_member186338]

sap.user62

[LC YTD(current month) - LC YTD(prior month) ] * AVG rate = this should generate zero records as there is no movement in the current month.

What about prior month?

[sap_user62]

Prior month has movements - so it will generate records for the prior month F80 flow.

F80 flow on YTD basis will have data for the current month, but if run periodic, it should have zero value.

[former_member186338]

sap.user62

Look on sample:

Current period is 4

[sap_user62]

Thanks Vadim,

My scenario is when LC Periodic = 0 for period 4, would your chart be

LC YTD for period 4 will be 38.

then USD periodic also should be 0. as (38-38) *1.4

but on ytd basis USD will be have 50.8 value.

[former_member186338]

sap.user62

Sorry, but not clear!

First you write: "where the LC is zero."

Then: "LC YTD for period 4 will be 38"

Please post a sample table like I have done...