Profit _ Loss Table

Filter

Value

Fiscal Period

It is used to specify fiscal period in which table will be displayed.

• • Starting Report Month*
    
  • Ending Report Month*

Values available to select as Start and End:
Opening
1st month of fiscal year
2nd month of fiscal year...
Last month of fiscal year
1st month of the next fiscal year
This filter works similarly to date range filter in all reports included in administration. The only different is that it works on monthly basis, instead of daily basis.
When start month is selected, start date of report on daily basis corresponds to the first day of the selected month. When End month is selected, end date of report on daily basis corresponds to the last day of the selected month.
Start and end dates are included in calculations. Only opening dates are exceptional. If opening option is selected, only opening slips are considered. End month can not be earlier than start month.
Accounts' amounts are calculated according to date range specified inhere.

Report Level

Equal to ...

This filter works similarly to the same filter included in G/L reports. If definition codes of lines in table definitions are generated in accordance with hierarchical structure, group and sub-group lines and sub-lines related to these lines are generated in report. Sub-total and general total, formula, profit/loss lines are also available.
Leveling
0th Level = sub and general totals, formula, profit/loss lines and lines without sub-lines.
1st level = Lines that are sub-lines of a single line
…
n. level = It is done gradually for lines which are sub-lines of n (number) lines. Level selected in filter shows level of the lowest line to be displayed in table report.
Default of this filter is checked from table parameter definitions.(see Table Parameters)

Calculation

• • Local*
    
  • F. Currency*

According to this parameter, all line amounts are calculated and displayed over local currency or foreign currency. When calculation amount in foreign currency, "Exch. Rate To Use" parameter located in account and account range definitions is considered.
Default of this filter is transferred from table parameter definitions.

Reporting Currency Exchange Rate

Reporting currency exchange rate is specified in this filter line.

Listing

• • All*
    
  • Has Transactions*

Lines with 0 line amount are displayed in table report in accordance with the selected option of this filter.

Table Factor
Equal to...

All calculated line amounts are displayed after they are divided in table factor number.
Default of this filter is taken from table parameter definitions.

Currency
Equal to...

Data of text type entered in here is used when writing currency type and table factor of report in table heading.

Report Heading

General heading displayed when taking table report is entered. It is a text entry field. Default of this filter is taken from table parameter definitions.

Report Sub-Heading

Second heading line displayed when taking table report is entered. It is a text entry field. Default of this filter is taken from table parameter definitions.

Active Group Heading

Heading of Active section displayed when taking table report is entered. It is a text entry field. Default of this filter is taken from table parameter definitions.

Passive Group Heading

Heading of Passive section displayed when taking table report is entered. It is a text entry field. Default of this filter is taken from table parameter definitions.

Table Heading

3rd heading line displayed while taking the table is entered. It is a text entry field.

Print Footnote

• • Yes*
    
  • No*

Footnotes entered by the user in table definitions are printed on the back of table report in accordance with the selected option of this filter.

Printing Restated Values

• • Yes*
    
  • No*

This filter option enables to print list of balance sheet values restated according to inflation. If you select "Yes" option in this filter, "Local" option is selected in Calculation: Local / F. Currency filter line in order to print restated values list.

Adjustment Date

Adjustment date is specified in this filter line.

Division Number

Division on basis of which fiscal table report will be printed is specified in this filter line.

Department Number

Department on basis of which fiscal table report will be printed is specified in this filter line.

Overhead Pool Code
Group
Range

This filter enables to calculate line amounts displayed in table according to overhead pools in which they are saved while performing their G/L transactions.
If overhead pool code is given inhere, monthly totals related to G/L account cards can not be used for amount in local and f. currency.
In this case, G/L transactions are scanned, and debt, credit, debt balance and credit balance totals are calculated over transaction conforming to criteria specified in overhead pool report filter of the transaction.

Comparison Period

It is used to specify comparison period if table is displayed including more than one fiscal period.

Comparison Year

It is used to specify comparison year if table is displayed including more than one fiscal period.