Versions Compared

Old Version 19

changes.mady.by.user Rufil Cabangal

Saved on

compared with

New Version 20

changes.mady.by.user Rufil Cabangal

Saved on

Key

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

...

  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 require 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. The following will help you understand how each will compute the date. 

    Note

    Start offset date will define the Start Date. This is always the first day of the month depending on what is selected in the Start Offset date field.

    nd offset date will define the Start Date. This is always the first day of the month depending on what is selected in the Start Offset date field.



  5. 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
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 Modified
  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 Modified
    As for Custom filter type, it will show today's date and you will need to setup the Start and End Dates.
    Image Modified
    Image Modified
    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 Modified
    >As of Date is using today's date. 
    Image Modified
    This is how the report will look like.
    Image Modified
    >As of Date is setup with other dates within the fiscal year
    Image Modified
    Image Modified
    >As of Date is setup with a date that is from previous fiscal year
    Image Modified
    Image Modified
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.
  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.