Versions Compared

Old Version 14

changes.mady.by.user Rufil Cabangal

Saved on

compared with

New Version Current

changes.mady.by.user Marian de Torres

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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.

Children Display
alltrue

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. The following column types will allow you to define date filter.
    1. Beginning Balance
    2. Budget
    3. Credit
    4. Credit Units
    5. Debit
    6. Debit Units
    7. Ending Balance
    8. GL Amounts
    9. GL Trend
    10. Units
  3. Add any of the columns mentioned on #2.  

  4. The Start and End Offset fields will be available. In these fields, define your date filter. 

    1. Start offset date will define the Start Date field. This is always the first day of the month depending on what is selected in the Start Offset date field. This date is computed based on the Run Date set if you are working on Column Designer screen and the As Of Date entered in the Report Settings screen if you are printing/previewing a report. 

    2. End offset date will define the End Date field. This is always the last day of the month depending on what is selected in the End Offset date field. This date is computed based on the Run Date set if you are working on Column Designer screen and the As Of Date entered in the Report Settings screen if you are printing/previewing a report. 

The following will help you understand how each will compute the date. 

Run Date selected is 1/26/2016
As Of Date selected from Report Settings screen is 12/31/2015



Based on Run Date (Column designer screen)Based on As Of Date (Report Settings screen)
Start/End OffsetDescriptionStart DateEnd DateStart DateEnd Date
BOTBeginning of Time1/1/1900-1/1/1900-
BOYBeginning of Year1/1/2016-1/1/2015-
BOY-1yrBeginning of Year minus 1 yr1/1/2015-1/1/2014-
BOY-2yrBeginning of Year minus 2 yrs1/1/2014-1/1/2013-
BOY-3yrBeginning of Year minus 3 yrs1/1/2013-1/1/2012-
BOY-4yrBeginning of Year minus 4 yrs1/1/2012-1/1/2011-
BOY-5yrBeginning of Year minus 5 yrs1/1/2011-1/1/2010-
EOYEnd of Year-12/31/2016-12/31/2015
EOY-1yrEnd of Year minus 1 yr-12/31/2015-12/31/2014
EOY-2yrEnd of Year minus 2 yrs-12/31/2014-12/31/2013
EOY-3yrEnd of Year minus 3 yrs-12/31/2013-12/31/2012
EOY-4yrEnd of Year minus 4 yrs-12/31/2012-12/31/2011
EOY-5yrEnd of Year minus 5 yrs-12/31/2011-12/31/2010
CustomDefaulted to Today's date. You can define specific date here.1/26/20161/26/201612/31/201512/31/2015
0Current Month1/1/20161/31/201612/1/201512/31/2015
1Current Month plus 1 month2/1/20162/29/20161/1/20161/31/2016
2Current Month plus 2 months3/1/20163/31/20162/1/20162/29/2016
3Current Month plus 3 months4/1/20164/30/20163/1/20163/31/2016
4Current Month plus 4 months5/1/20165/31/20164/1/20164/30/2016
5Current Month plus 5 months6/1/20166/30/20165/1/20165/31/2016
6Current Month plus 6 months7/1/20167/31/20166/1/20166/30/2016
7Current Month plus 7 months8/1/20168/31/20167/1/20167/31/2016
8Current Month plus 8 months9/1/20169/30/20168/1/20168/31/2016
9Current Month plus 9 months10/1/201610/31/20169/1/20169/30/2016
10Current Month plus 10 months11/1/201611/30/201610/1/201610/31/2016
11Current Month plus 11 months12/1/201612/31/201611/1/201611/30/2016
12Current Month plus 12 months1/1/20171/31/201712/1/201612/31/2016
24Current Month plus 24 months1/1/20181/31/201812/1/201712/31/2017
-1Current Month minus 1 month12/1/201512/31/201511/1/201511/30/2015
-2Current Month minus 2 months11/1/201511/30/201510/1/201510/31/2015
-3Current Month minus 3 months10/1/201510/31/20159/1/20159/30/2015
-4Current Month minus 4 months9/1/20159/30/20158/1/20158/31/2015
-5Current Month minus 5 months8/1/20158/31/20157/1/20157/31/2015
-6Current Month minus 6 months7/1/20157/31/20156/1/20156/30/2015
-7Current Month minus 7 months6/1/20156/30/20155/1/20155/31/2015
-8Current Month minus 8 months5/1/20155/31/20154/1/20154/30/2015
-9Current Month minus 9 months4/1/20154/30/20153/1/20153/31/2015
-10Current Month minus 10 months3/1/20153/31/20152/1/20152/28/2015
-11Current Month minus 11 months2/1/20152/28/20151/1/20151/31/2015
-12Current Month minus 12 months1/1/20151/31/201512/1/201412/31/2014
-24Current Month minus 24 months1/1/20141/31/201412/1/201312/31/2014
Expand
title18.3

There are columns that require date filter and this page will help you understand how date filter works and how you should use it. 

  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. The following column types will allow you to define date filter.
    1. Beginning Balance
    2. Budget
    3. Credit
    4. Credit Units
    5. Debit
    6. Debit Units
    7. Ending Balance
    8. GL Amounts
    9. GL Trend
    10. Units
  3. Add any of the columns mentioned on #2.  

  4. The Start and End Offset fields will be available. In these fields, define your date filter. 

    1. Start offset date will define the Start Date field. This is always the first day of the month depending on what is selected in the Start Offset date field. This date is computed based on the Run Date set if you are working on Column Designer screen and the As Of Date entered in the Report Settings screen if you are printing/previewing a report. 

    2. End offset date will define the End Date field. This is always the last day of the month depending on what is selected in the End Offset date field. This date is computed based on the Run Date set if you are working on Column Designer screen and the As Of Date entered in the Report Settings screen if you are printing/previewing a report. 

The following will help you understand how each will compute the date. 

Run Date selected is 1/26/2016
As Of Date selected from Report Settings screen is 12/31/2015



Based on Run Date (Column designer screen)Based on As Of Date (Report Settings screen)
Start/End OffsetDescriptionStart DateEnd DateStart DateEnd Date
BOTBeginning of Time1/1/1900-1/1/1900-
BOYBeginning of Year1/1/2016-1/1/2015-
BOY-1yrBeginning of Year minus 1 yr1/1/2015-1/1/2014-
BOY-2yrBeginning of Year minus 2 yrs1/1/2014-1/1/2013-
BOY-3yrBeginning of Year minus 3 yrs1/1/2013-1/1/2012-
BOY-4yrBeginning of Year minus 4 yrs1/1/2012-1/1/2011-
BOY-5yrBeginning of Year minus 5 yrs1/1/2011-1/1/2010-
EOYEnd of Year-12/31/2016-12/31/2015
EOY-1yrEnd of Year minus 1 yr-12/31/2015-12/31/2014
EOY-2yrEnd of Year minus 2 yrs-12/31/2014-12/31/2013
EOY-3yrEnd of Year minus 3 yrs-12/31/2013-12/31/2012
EOY-4yrEnd of Year minus 4 yrs-12/31/2012-12/31/2011
EOY-5yrEnd of Year minus 5 yrs-12/31/2011-12/31/2010
CustomDefaulted to Today's date. You can define specific date here.1/26/20161/26/201612/31/201512/31/2015
0Current Month1/1/20161/31/201612/1/201512/31/2015
1Current Month plus 1 month2/1/20162/29/20161/1/20161/31/2016
2Current Month plus 2 months3/1/20163/31/20162/1/20162/29/2016
3Current Month plus 3 months4/1/20164/30/20163/1/20163/31/2016
4Current Month plus 4 months5/1/20165/31/20164/1/20164/30/2016
5Current Month plus 5 months6/1/20166/30/20165/1/20165/31/2016
6Current Month plus 6 months7/1/20167/31/20166/1/20166/30/2016
7Current Month plus 7 months8/1/20168/31/20167/1/20167/31/2016
8Current Month plus 8 months9/1/20169/30/20168/1/20168/31/2016
9Current Month plus 9 months10/1/201610/31/20169/1/20169/30/2016
10Current Month plus 10 months11/1/201611/30/201610/1/201610/31/2016
11Current Month plus 11 months12/1/201612/31/201611/1/201611/30/2016
12Current Month plus 12 months1/1/20171/31/201712/1/201612/31/2016
24Current Month plus 24 months1/1/20181/31/201812/1/201712/31/2017
-1Current Month minus 1 month12/1/201512/31/201511/1/201511/30/2015
-2Current Month minus 2 months11/1/201511/30/201510/1/201510/31/2015
-3Current Month minus 3 months10/1/201510/31/20159/1/20159/30/2015
-4Current Month minus 4 months9/1/20159/30/20158/1/20158/31/2015
-5Current Month minus 5 months8/1/20158/31/20157/1/20157/31/2015
-6Current Month minus 6 months7/1/20157/31/20156/1/20156/30/2015
-7Current Month minus 7 months6/1/20156/30/20155/1/20155/31/2015
-8Current Month minus 8 months5/1/20155/31/20154/1/20154/30/2015
-9Current Month minus 9 months4/1/20154/30/20153/1/20153/31/2015
-10Current Month minus 10 months3/1/20153/31/20152/1/20152/28/2015
-11Current Month minus 11 months2/1/20152/28/20151/1/20151/31/2015
-12Current Month minus 12 months1/1/20151/31/201512/1/201412/31/2014
-24Current Month minus 24 months1/1/20141/31/201412/1/201312/31/2014
Expand
title15.3 and below

There are columns that require date filter and this page will help you understand how date filter works and how you should use it. 

  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, Ending Balance, GL Trend, Segment Filter or Units column. 
  3. In the Filter Type field click the dropdown combobox button. All available filter types will show a Start and End Dates based on Run Date selected. The Start and End Dates will show you exactly the date range for the selected Filter Type. This helps you visualize the date coverage of the date filter based on the Run Date selected.
    Image Added
    As for Custom filter type, it will show today's date and you will need to setup the Start and End Dates.
    Image Added
    Image Added
    When printing report and you use a column designer with Filter Type setup columns, it will be the As of Date field that is being used as basis for the date filters. 
    Ex: 
    If this is the column designer setup, take note that the first part is using the Caption - Column Name while the 2nd part is using the Caption - Filter Type. 
    Image Added
    >As of Date is using today's date. 
    Image Added
    This is how the report will look like.
    Image Added
    >As of Date is setup with other dates within the fiscal year
    Image Added
    Image Added
    >As of Date is setup with a date that is from previous fiscal year
    Image Added
    Image Added
Expand
title14.4

There are columns that require date filter and this page will help you understand how date filter works and how you should use it. 

  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 types, except Custom, will show the Start Date and End Date based on Run Date selected.
    Image Added

...