how to get first period of the fiscal?

User_U19UV

We need to build an FRS report.

We want to show the First period of the Fiscal year at any given point of time in the report.

Example:

IF we run the report for Mar-22, the report has to display the data for Mar-22 and Jan-22.

IF we run the report for Sep-22, the report has to display the data for Sep-22 and Jan-22.

IF we run the report for Apr-21, the report has to display the data for Apr-21 and Jan-21.

How can we achieve this?

Anand Thota

Hi,

Please find the below image to set it up in HFR as per your requirement. It should simple setup.

Hope this will help

Output

Thanks,

Anand Thota