Custom Columns - Date Override Tab

Access this feature by opening an existing report (Reports>{Any applicable report}> Custom Columns) or by saving a new one.

Use this tab to override the report date for a custom column.

• For Fixed Dates, the system displays the Opening Balances/From and Ending Balances/Through dates from the Report Setup>Setup tab. Enter a new date range to override that report date. The custom column is based on the date range entered here, while the other columns of the report are based on the dates from the Report Setup>Setup tab. This provides the flexibility to create any date range parameters for a custom column.
• For Rolling Dates, you can select a relative date on which to base the custom column. This relative starting date accommodates the basic requirements of comparing current periods with prior months and years.

Note: You must select the Date Override option on the Custom Column tab in order to use this tab.

 

Column Information: These selections change depending on which report you are running.

• Based On: Select the column type that is being used for Date Override, such as Actual, Budget, Encumbrances, Current Period Balance, Expenses, Payment, Charges, or {User Defined Field Name}.
• Detail: Select the detail for the Based On column, such as Actual, {Budget Version Name}, Encumbrances, Expenses Payments, Charges, {User Defined Field Name}, or Current Period Balance.
  • If you selected a {Budget Version Name}, you need to know the From and To dates covered by that version. The system only displays current period, not year-to-date or total budget versions.
  • If you created a transaction line type UDF as a number or currency, or a Budget transaction line type UDF as a number, the system displays it here.
  • If you selected encumbrances, you must select Encumbrances as Expenditures on the Report Setup>Options tab.

Fixed Dates: Select this option button to change the date range for this column alone.

• From, Through: This is the date range from the Opening Balances/From and Ending Balances/Through dates (Setup tab) or the Total Budget Dates (Options tab). Select new dates to perform a date override.

Rolling Dates: Select this option to have the date override automatically roll based on changing current period dates. This relative date is based on dates entered on the Setup tab.

• Relative To: Select the relative beginning date for the custom column, such as Opening Balances, Current Reporting Year Begins, or From.
  • Opening Balances - The system uses the Opening Balances date from the Setup tab. Select this if creating rolling dates for the periods month or quarter.
  • Current Reporting Year Begins - The system uses the Current Reporting Year Begins date from the Setup tab. Select this if the custom column report dates roll when the report year changes.
  • From - The system uses the From date on the Setup tab.
• Periods: Select the time frame of the roll back—Month, Quarter, Year, or Year to Date. This determines the reporting period of the custom column. By default, the system uses your computer's system date.
  • Month - This period is based on the calendar month and represents the first to last day of the month. It applies to the Opening Balances date and Current Reporting Year Begins date on the Setup tab.
  • Quarter - This period is based on the calendar quarter and represents the first to last day of the quarter: January, February, March; April, May, June; July, August, September; or October, November, December. It applies to the Opening Balances date and Current Reporting Year Begins date on the Setup tab.
  • Year - This period is based on the organization's fiscal year. The duration of the custom column is 12 months. It applies to the Current Reporting Year Begins date on the Setup tab.
  • Year to Date - This period is relative to both the Current Reporting Year Begins date and the Ending Balances date on the Setup tab. It applies to the period from the Current Reporting Year Begins date through Ending Balances date. Consequently, this time frame does not necessarily fit the month, quarter, or year period.
• Rollback: Enter the number of months, quarters, or years in which to roll back. The maximum rollback period is 6 years, 72 months, or 24 quarters.
• Period Reported On Report From, To: The system displays the custom column's report period.

Display Dates in Column Heading: Select this check box to display the dates calculated here in the custom column's heading.