Reporting Balance Fields
Reporting balances are one of two types of balance record used in Accounting. See Types of Balance Record for more information. |
Here is a description of the custom fields on the Reporting Balance object.
Field | Description | |
---|---|---|
Account | Lookup to the related account In this context, accounts are organizations or people that you conduct business with, such as customers or vendors. Account is a standard Salesforce object. Certinia accounts can be any Account Record Type.. | |
Accounting Book | Lookup to the accounting book associated with this reporting balance. This field is only available if you have enabled the Multi-Book Accounting feature using Feature Console. | |
Balance Update Timestamp | Last modified date on the related budget and balance record. | |
Bank Account | Lookup to the related bank account. | |
Budget and Balance | Lookup to the related budget and balance instance. | |
Cash Flow Exception Hash Code | For internal use only. | |
Company | Company that owns this record. | |
Dimension 1-4 | Lookups to the related analysis dimensions Custom objects that allow you to analyze the activity in your business in additional ways, such as by cost center, project, employee, or any other business entity important to you.. | |
Dual Value | Value in dual currency The currency in which your corporate headquarters reports financial statements. This defaults to, and is normally the same as, the corporate currency.. | |
General Ledger Account | Lookup to the related general ledger account The general ledger will normally include general ledger accounts (GLAs) for items such as income, expenses, assets, liabilities, and reserves.. | |
Home Value | Value in home currency The main working currency of the current company.. | |
Intersect Definition | R | Lookup to the intersect definition used to create this reporting balance. |
Local GLA | Lookup to the local GLA you want to use to store balances, if your org is set up to allow financial reporting to different statutory bodies. Only active local GLAs are available. See What is a Chart of Accounts Structure? for more information. | |
Number of Related Transaction Line Items | For internal use only. | |
Period | Lookup to the related accounting period. You must enter a valid period. | |
Period Number | Formula with the numeric value for the accounting period. | |
Product | Lookup to the related product. | |
Reporting Balance Hash Code | R | For internal use only. Concatenation of Period, Year, Company, GLA, Dimensions, Entity, Intersect Definition and Type fields. Must be unique. If you do something that would result in two or more reporting balance records with the same hash code, the operation will fail. |
Sub-Analysis | Concatenation of the four entity Collective term for the following predefined dimensions within your chart of accounts: account, product, bank account, and tax code. dimensions. | |
Tax Code | Lookup to the related tax code. | |
Type | Type of balance record: Actual, Budget or Cash Flow Exception. Balance records of type Actual are read-only. | |
Year Number | Formula with the numeric value for the financial year. |
Cash Flow Analysis
These are populated using the default values set on the GLAs. They are used to adjust and group data on a statement of cash flows report.
See Setting up a Statement of Cash Flows for examples of how to use these fields.
All fields in this section are Text fields.
Field | |
---|---|
Reclassify Profits | True or false. True indicates that you want to adjust the section in which transactions using this GLA will appear. |
Cash Flow Category | Heading under which a transaction using this GLA will appear on the cash flow report. Example cash flow categories are Investing Activities and Financing Activities. |
Cash Flow Line Summary | Text used to group transactions using this GLA on the statement of cash flows report. This is useful when the value that you want to group by doesn't already exist in your chart of accounts. |
Reporting Balances of type "Cash Flow Exception" have an additional related list that lists all related transaction line items.