Skip to main content

Report: Statement of Accounts

[Created: 14/02/2003 - Updated: 24/10/2005 ]
Description: Report Account Statement Beginning Balance and Transactions
Help: Select a Period (current period if empty) or enter a Account Date Range. You can select an alternative Reporting Hierarchy.

Table: Report Parameters

NameDescriptionHelpTechnical Info
Accounting SchemaRules for accountingAn Accounting Schema defines the rules used in accounting such as costing method, currency and calendarC_AcctSchema_ID
Table Direct
Posting TypeThe type of posted amount for the transactionThe Posting Type indicates the type of amount (Actual, Budget, Reservation, Commitment, Statistical) the transaction.PostingType
List
PeriodPeriod of the CalendarThe Period indicates an exclusive range of dates for a calendar.C_Period_ID
Table
Account DateAccounting DateThe Accounting Date indicates the date to be used on the General Ledger account entries generated from this document. It is also used for any currency conversion.DateAcct
Date
OrganizationOrganizational entity within tenantAn organization is a unit of your tenant or legal entity - examples are store, department. You can share data between organizations.AD_Org_ID
Table Direct
AccountAccount usedThe (natural) account usedAccount_ID
Table
Business PartnerIdentifies a Business PartnerA Business Partner is anyone with whom you transact. This can include Vendor, Customer, Employee or SalespersonC_BPartner_ID
Table Direct
ProductProduct, Service, ItemIdentifies an item which is either purchased or sold in this organization.M_Product_ID
Table Direct
ProjectFinancial ProjectA Project allows you to track and control internal or external activities.C_Project_ID
Table Direct
ActivityBusiness ActivityActivities indicate tasks that are performed and used to utilize Activity based CostingC_Activity_ID
Table Direct
Sales RegionSales coverage regionThe Sales Region indicates a specific area of sales coverage.C_SalesRegion_ID
Table Direct
CampaignMarketing CampaignThe Campaign defines a unique marketing program. Projects can be associated with a pre defined Marketing Campaign. You can then report based on a specific Campaign.C_Campaign_ID
Table Direct
User Element List 1User defined list element #1The user defined element displays the optional elements that have been defined for this account combination.User1_ID
Table
User Element List 2User defined list element #2The user defined element displays the optional elements that have been defined for this account combination.User2_ID
Table
Reporting HierarchyOptional Reporting Hierarchy - If not selected the default hierarchy trees are used.Reporting Hierarchy allows you to select different Hierarchies/Trees for the report.Accounting Segments like Organization, Account, Product may have several hierarchies to accommodate different views on the business.PA_Hierarchy_ID
Table Direct