Page History

There are columns that require date filter and this page will help you understand how date filter works and how you should use it. But before that, the following constant setup will be used to explain each and every filter type. In that way, it will be easier to identify the difference between each filter type.

Fiscal Year setup. 

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.

For all 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.

This is the first year of operation.

Image Removed

This is the 2nd year of operation, which is marked the current year (see the red stamp that shows Current Fiscal Year).

Image Removed

Since we have filter types that cover next year, we have created sample data for the next year.

Image Removed

This is the Row setup.

Image Removed

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 illustrations we will present, all of the mentioned setup will be used and only the Filter Type will change.

Image Removed

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.

See Filter Type Dates and Net Income based on illustrations page to show you a table that lists all the Filter Types and their specific dates of coverage based on the Fiscal Year setup. The Net Income column is also shown to show you example of amount derived for all the illustrations.

1. First is, set the Run Date. By default, this field will show today's date. Change this field as you feel necessary.
   Image Added
2. Add Budget, Calculation, Credit, Credit Units, Debit, Debit Units or Segment Filter column. 
3. In the Filter Type field click the dropdown combobox button. All available filter type, except Custom, will show the Start Date and End Date based on Run Date selected.
   Image Added

...