...
Case 1: In such cases, the system generates the name of the column asdescribed in the Header Label for the respective column.
Report Column Set tab |
| Report Parameters |
|
Header Label | Current Month | Year | 2023 |
Print Label | current month | Month | March |
Column Type | Year/ Period |
|
|
Period | Month |
|
|
Select Month | Current Month |
|
|
Report Output will be as follows:
Name of the column | Current Month |
...
EXAMPLE 2: When the user defines only 'header label' field and 'print label' field is kept as blank.
CASE 2.1: In case of Month as a period, the system generates the name of the column with combination of configuration settings on report column set tab for the respective column and report parameters.
Report Column Set tab |
| Report Parameters |
|
Header Label | Current Month | Year | 2023 |
Print Label |
| Month | March |
Column Type | Year/ Period |
|
|
Period | Month |
|
|
Select Month | Current Month |
|
|
Report Output will be as follows:
Name of the column | March-23 |
Note: The System fetches Period/Year name from the Period control window.
...
CASE 2.2: In case of Year as a period, the system generates the name of the column with combination of configuration settings on report column set tab for the respective column and report parameters.
Report Column Set tab |
| Report Parameters |
|
Header Label | Current Year | Year | 2023 |
Print Label |
| Month | March |
Column Type | Year/ Period |
|
|
Period | Year |
|
|
Select Year | Current Year |
|
|
Report Output will be as follows:
Name of the column | 2023 |
Note: The System fetches Period/Year name from the Period control window.
...
CASE 2.3: In case of Accumulation checkbox with Month as a period, the system generates the name of the column with combination of configuration settings on report column set tab for the respective column and report parameters.
Report Column Set tab |
| Report Parameters |
|
Header Label | Current Month | Year | 2023 |
Print Label |
| Month | March |
Column Type | Year/ Period |
|
|
Period | Month |
|
|
Select Month | Next Month |
|
|
Value | 1 |
|
|
Accumulate from start year date to defined period end | True |
|
|
Accumulate from defined period to year end date | False |
|
|
Accumulate beginning balances to defined period | False |
|
|
Report Output will be as follows:
Name of the column | January-23 – April-23 |
Note: Define years in the calendar are: 2020,2021,2022,2023,2024 and 2025.
...
CASE 2.4: In case of Total as period, the system generates the name of the column with combination of configuration settings on report column set tab for the respective column and report parameters.
Report Column Set tab |
| Report Parameters |
|
Header Label | Total | Year | 2023 |
Print Label |
| Month | March |
Column Type | Year/ Period |
|
|
Period | Total |
|
|
Select Year | Previous Year |
|
|
Value | 2 |
|
|
Report Output will be as follows:
Name of the column | 2021-2022 |
Note- 2020, 2021, 2022, 2023, 2024 and 2025 year should be defined in period control.
...
CASE 2.5: In case of Year Range as period, the system generates the name of the column with combination of configuration settings on report column set tab for the respective column and report parameters.
Report Column Set tab |
| Report Parameters |
|
Header Label | Year range | Year | 2023 |
Print Label |
| Month | March |
Column Type | Year/ Period |
|
|
Period | Year Range |
|
|
From Year | Previous Year |
|
|
Value | 2 |
|
|
To year | Next Year |
|
|
Value | 2 |
|
|
Report Output will be as follows:
Name of the column | 2021-2025 |
Note- 2020, 2021, 2022, 2023, 2024 and 2025 year should be defined in period control.
...
CASE 2.6: In case of Year period group as period, the system generates the name of the column with combination of configuration settings on report column set tab for the respective column and report parameters.
Report Column Set tab |
| Report Parameters |
|
Header Label | First Half | Year | 2023 |
Print Label |
| Month | March |
Column Type | Year/ Period |
|
|
Period | Year Period Group |
|
|
Select Year | Current Year |
|
|
Period Group | Half Yearly |
|
|
Type of period group | Fixed |
|
|
Period Group Type | Half1 |
|
|
Accumulated from start year date to defined period end | False
|
|
|
Accumulated from defined period to year end date | False |
|
|
Report Output will be as follows:
Name of the column | January-23 – June-23 |
...