Page History
...
This is very important because most of the filter types will be looking into this setup to identify the date filter. See How to Use As Of Date to illustrate how fiscal year setup is used when generating financial reports.
Not only that, how the fiscal year is setup plays a significant role as it will dictate how filter types work, how they can sometimes derive the same result and how they can vary.The The table below will show you the filter types that will result to the same result when Fiscal Year screen has setup like that of the calendar and how it varies if the setup does not start with Jan 1 and end with Dec 31.
Calendar Year | Fiscal Year | ||
|---|---|---|---|
| Starts Jan 1 and ends Dec 31 | Does not necessarily start with Jan 1 and end with Dec 31 Ex: Fiscal Year starts July 1 and ends June 30 | ||
| As Of Fiscal Year | - | ||
| Filter Type - As Of Previous Fiscal Year | Filter Type - As Of Previous Year | will show the same result | will show different result |
| As Of Next Year | will show the same result | will show different result | |
Fiscal Year | - | ||
| Previous Fiscal Year | Previous Year | will show the same result | will show different result
|
| Next Fiscal Year | Next Year | will show the same result | will show different result
|
| Fiscal Year To Date | Year To Date | will show the same result | will show different result |
| Previous Fiscal Year To Date | Last Year To Date | will show the same result | will show different result |
| Next Fiscal Year To Date | - | ||
| - | Last Year Quarter To Date | ||
| - | Last Year Month To Date |
For this illustrationall the illustrations in the topics under this page, the setup we will be using is the same as that of the calendar, where it starts with Jan 1 and ends with Dec 31.
...
Since we have filter types that cover next year, we have created sample data for the next year (2015) after the current year (2014).
This is the Row setup.
This is the Column setup. The Calculation column type will be used. This means that the amount to be shown in this column is to be taken from what was posted to the General Ledger and the Filter Type will dictate the Start and End Date of the transaction to be filtered. For all the illustration illustrations we will present, all of the mentioned setup will be used and only the Filter Type will change.
The As of Date field in the Report Settings screen is used in Filter Type that has As Of within its name. By default, this takes today's date. Note that when this date is changed, that date is saved and that becomes the default date. So next instance Report Settings screen is opened, that same date will be shown.
Another use of As Of Date field is it dictates the current year. If As Of date is not changed, it will take the current fiscal year setup in the Fiscal Year screen. However, once this date was changed, there might be an instance where the current fiscal year will not anymore match that of Fiscal Year screen setup. But this gives flexibility to dynamically dictate the current fiscal year you would like the report to consider without having to modify your Fiscal Year setup or your system date. This will be discussed more on How to dynamically change current fiscal year.
Now that contributing factors had been presented on how Filter Type will work, time to explain each and every Filter type and how it works plus some illustrations. See topics below.
...
Overview
Content Tools