Keep Comparison Period Scope Field, Column Layout Table
If you specified the Comparison Date Formula and place a check mark in this field, when the program calculates the amount in this column it keeps the period type scope even if the period type selected is different.
For example if the comparison formula is
-CY-1Y-CM
and
you place a checkmark in this field, the program will use the first month in previous year for the amount calculation in this column whatever period type scope selected
you do not place a checkmark in this field, the program will calculate the start date of that period, and use the period type scope from the period type selected, for example if it’s quarter, it will be first quarter in previous year.
Important
Using this field, you can set-up column layouts to show different period scopes, for example:
CY |
Current fiscal year |
CY -CQ |
First quarter of fiscal year |
-CY +1Q -CQ |
Second quarter of fiscal year |
-CY +2Q -CQ |
Third quarter of fiscal year |
-CY +3Q -CQ |
Fourth quarter of fiscal year |
-CY -1Y |
Previous fiscal year |
-CY -1Y -CQ |
First quarter of previous fiscal year |
-CY -1Y +1Q -CQ |
Second quarter of previous fiscal year |
-CY -1Y +2Q -CQ |
Third quarter of previous fiscal year |
-CY -1Y +3Q -CQ |
Fourth quarter of previous fiscal year |
Tip
For more information on how to work with fields and columns, see Work with Data. For assistance in finding specific pages, see Search.
Parent Tables
| Table | Location |
|---|---|
| Column Layout Table | General Ledger |
| Column Layout Table | General Ledger |