FISCYEARPER field in ICMR data source

[can_erdogan]

Hey,

We are building IC reconciliation methods/cases for Group Reporting using data source SF_JOURNAL_ENTRIES_02 (Consolidation Journal Entry View). We are able to update the version and consolidation chart of accounts to default values as per client requirements, however the FISCYEARPER is always showing current calendar month/year (i.e. 12/2022).

Is there a way to update the default value setting to read from Global Parameters instead, so that the end-users do not have to change this parameter everytime the report is executed?

Thank you

Can Erdogan

[JoseSuarezBlas]

Same doubt here. Any solution to this?

regards.

[GraceZou]

Unfortunately, mandatory filter fields of data sources in ICMR currently can't read global parameters of Group Reporting.

They can only be set as dynamic values such as $CurrentFiscalYear$, $CurrentFiscalPeriod$ , and $CurrentFiscalYearPeriod$ or specific period values. See Define ICMR Data Sources.