Displaying Starting month of FY data in a column in FR Studio
Hi,
I have a report to build with the following logic.
I have account and accounting period in Rows and columns section in FR Studio.
I have a column to display previous Financial year data (Starting month beginning balance).
The financial year starts on Aug month and ends in July month.
Scenario:
If i select accounting period as April 2018 then the column data should display Beginning balance of Aug 2017 (as April 2018 comes under Aug-17 and July-18 financial year).
If i select accounting period as Sept 2018 then the column data should display Beginning balance of Aug 2018 (as Sept 2018 comes under Aug-18 and July-19 financial year).