Sage Intelligence now allows you to filter your report based on a fiscal period. No more cluttered reports, and no more redundant editing of report layouts to get your desired results!
Before we dive into the new'Up to Period' feature, it is important for you to understand how Sage Intelligence Fiscal Periods work.
Note: Sage Intelligence uses the year within which the Financial Year End date falls. Thus in the above example, your Financial Year is 2019.
So for example, if you create a Sage Intelligence Report that references Period 6, then all transactions occurring between 01/12/2018 and 31/12/2018 will be totaled and displayed in your report per Category Group, Account Category or Account.
Now that you have a better understanding of how Fiscal Period works in Sage Intelligence, you are now ready to explore the new'Up to Period' feature.
When you run a Financial Report in Sage Intelligence, you will be prompted to select filters and settings to base your report values on. You can run the report by clicking on the report name, or by clicking on the Run button in the report's details menu.
Doing so, will open up the filter window, prompting you to select your filters and settings.
If you would like to select an Up to Period filter, simply click on the "Up to Period" drop-down menu.
From this menu, you can select the following:
Initially the Up to Period filter will be left BLANK, meaning that no period filter will be used, and the report will display as per default design.
You can now select the other desired filters and settings from the above dialog and click on Run. Your financial report will generate as per default design.
If you feel that the report is displaying periods that are not relevant at that specific point in time, you can do the following:
2. From the Up to Period drop-down, select the desired period (e.g 6).
3. Click on Calculate.
4. You will now notice that the report only displays periods up to the selected period, 6, leaving you with a more clean and uncluttered financial report.
In the above example, you can see that periods greater than 6 were hidden from the report.
5. You can now select different Up to Periods to remove any unnecessary periods from your report.
Please note that when you export your report to Excel, you can simply unhide the periods that were hidden from your report when you applied the Up to Period filter by simply using Excel's'Unhide' columns feature.
If you have included a Quarter period in your report, bare in mind that the values for that quarter will change according to the Up to Period filter selected.
For example, if you have created the following report, consisting of four columns, Quarter 1, Quarter 2, Quarter 3 and Quarter 4:
And then you select period 5 as an Up to Period, and run the report, the following will be the outcome.
Quarters are defined as the following:
Please note that the Up to Period filter does not affect any calculation column.