Adempiere3.4.0/en/ManPageW FinancialReport olh

From ADempiere
Revision as of 19:15, 9 April 2008 by CarlosRuizBot (Talk) (Automated import of articles)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search
This Wiki is read-only for reference purposes to avoid broken links.


Window: Financial Report

Description : Maintain Financial Reports

Help : Financial Reports are the combination of a Report Column Set and Line Set.



Tab: Financial Report

Description :

Help :

Table Name  : PA_Report

ManPageW FinancialReport FinancialReport.png

Fields

Name Description Help Technical Data
Client Client/Tenant for this installation. A Client is a company or a legal entity. You cannot share data between Clients. Tenant is a synonym for Client. AD_Client_ID

NUMBER(10)

TableDir

Organization Organizational entity within client An organization is a unit of your client or legal entity - examples are store, department. You can share data between organizations. AD_Org_ID

NUMBER(10)

TableDir

Accounting Schema Rules for accounting An Accounting Schema defines the rules used in accounting such as costing method, currency and calendar C_AcctSchema_ID

NUMBER(10)

TableDir

Calendar Accounting Calendar Name The Calendar uniquely identifies an accounting calendar. Multiple calendars can be used. For example you may need a standard calendar that runs from Jan 1 to Dec 31 and a fiscal calendar that runs from July 1 to June 30. C_Calendar_ID

NUMBER(10)

TableDir

Name Alphanumeric identifier of the entity The name of an entity (record) is used as an default search option in addition to the search key. The name is up to 60 characters in length. Name

NVARCHAR2(60)

String

Description Optional short description of the record A description is limited to 255 characters. Description

NVARCHAR2(255)

String

Active The record is active in the system There are two methods of making records unavailable in the system: One is to delete the record, the other is to de-activate the record. A de-activated record is not available for selection, but available for reports.

There are two reasons for de-activating and not deleting records: (1) The system requires the record for audit purposes. (2) The record is referenced by other records. E.g., you cannot delete a Business Partner, if there are invoices for this partner record existing. You de-activate the Business Partner and prevent that this record is used for future entries.

IsActive

CHAR(1)

YesNo

Report Line Set PA_ReportLineSet_ID

NUMBER(10)

TableDir

Report Column Set Collection of Columns for Report The Report Column Set identifies the columns used in a Report. PA_ReportColumnSet_ID

NUMBER(10)

TableDir

Jasper Process The Jasper Process used by the printengine if any process defined JasperProcess_ID

NUMBER(10)

Table

List Sources List Report Line Sources List the Source Accounts for Summary Accounts selected ListSources

CHAR(1)

YesNo

List Transactions List the report transactions List the transactions of the report source lines ListTrx

CHAR(1)

YesNo

Create Report Create Financial Report The default period is the current period. You can optionally enter other restrictions. You can select an alternative Reporting Hierarchy. Processing

CHAR(1)

Button

Print Format Data Print Format The print format determines how data is rendered for print. AD_PrintFormat_ID

NUMBER(10)

TableDir

Create Report (Jasper) Create Financial Report (Jasper) The default period is the current period. You can optionally enter other restrictions. You can select an alternative Reporting Hierarchy. JasperProcessing

CHAR(1)

Button