Cost of Sales Table displays the cost of raw materials, materials, commercial goods and services sold within the period through material transactions.
Cost of Sales Table information is recorded using the "New" option located in General Ledger > Definitions > Financial Statements > Cost of Sales Table browser. Fields on the standard definitions are displayed on the table added according to the main chart of accounts.
The table containing information about the relevant sales period is recorded by clicking the “Apply” button once the related filter properties are set using the “Report” option. The table is displayed on the Cost of Sales Table list with table name and description.
The “Update” option is used on the related definition to change table information. The Cost of Sales Table is printed using the “Print” option. The related form definition is selected and printed.
The relevant definition is selected if more than one table is defined for the Cost of Sales Table. Information transferred to the Cost of Sales Table is read from the balances of related accounts and reflected as amount on the related fields of the Cost of Sales Table Report.
Users may add information to the footnotes used on the Cost of Sales table. The Cost of Sales Table report filter options are:
Filter | Value |
---|---|
Fiscal Year 1 | Used to specify the fiscal year of the table. |
Fiscal Year 2 | Used to specify the fiscal year of the table. |
Fiscal Year 3 | Used to specify the fiscal year of the table. |
Fiscal Year 4 | Used to specify the fiscal year of the table. |
Opening Slip | This filter specifies whether or not lines opening slips will be included in table reports or not. The options are:
|
Report Level | If the definition codes of lines in table definitions are made according to the level structure, various levels of group and sub-group lines and related sub-lines are generated on the report. In addition, there are subtotal and general total, formula and profit/loss lines. |
Calculation | All amounts are calculated and displayed in FC or local currency depending on this filter. Foreign currency amounts are calculated by processing the “Currency Type Exchange Rate" parameter defined in account and account range definitions. |
Reporting Currency Exchange Rate | The filter line used to specify the exchange rate of the reporting currency. |
Listing | This filter specifies whether or not lines with zero amount will be displayed on table reports. The options are:
|
Footnotes Printing | When “Yes” is selected, user defined footnotes are displayed at the end of the table report. |
Corrected Values Printing | The filter option used to list Cost of Sales table values corrected according to inflation. If “Yes" is selected on this filter line, “Local” should be selected on the "Calculation: Local/FC” filter line in order to list corrected values. |
Organizational Unit | This filter is used to specify the org. unit for which the financial statement report will be generated. |
Department Number | This filter is used to specify the department for which the financial statement report will be generated. |
Analysis Dimension Code | This filter allows amount totals on the table to be calculated according to their analysis dimensions while G/L transactions are performed. |
Comparison Type | The field used to specify the comparison type. The options are:
If “Periodic” is selected, the periods specified in fiscal year parameters are compared on the table. |
G/L Slip No | Used to filter financial table records by the G/L slip number. |
Slip Auxiliary Code | Used to filter financial table records by the G/L slip auxiliary code. |
Slip Type | Used to filter financial table records by the G/L slip type. |