Hi,
I am having a problem with the currency conversion. I am using the standard FXRestatment package delivered with AppShell. The script logic is
*RUN_STORED_PROCEDURE=SPRUNCONVERSION([%APP%],[%CATEGORY_SET%],[%CONSOLVIEW_SET%],[GLOBAL],[%SCOPETABLE%],[%LOGTABLE%])
I have also run it as
*RUN_STORED_PROCEDURE=SPRUNCONVERSION([%APP%],[%CATEGORY_SET%],EUR,[GLOBAL],[%SCOPETABLE%],[%LOGTABLE%])
as I am trying to convert a GBP company to EUR. In both cases I get this error message.
SPRunConversion Version 7.5.101
ERROR FX-240 : No Rate Extract From MbrRate
ERROR FX-260 No Rate in Fact corresponding with Rate dimension
I have checked the following:
My Legal app points at my Rate app
I have AVG and END rates for the period I am trying to convert
I have two currency type dimensions, InputCurrency and Consolview. My entity dimension references the Inputcurrency which lists individual currency codes like USD, GBP, EUR etc. My RateEntity dimension references the ConsolView which has LC, reporting currencies (EUR and USD) and group views for my legal consolidation.
EUR is defined in Consol_View as a reporting currency, I have also tried it with a G type currency with the same result
I have run out of ideas of where else to look