An intersect definition defines the storage of balances within the Certinia general ledger
Central repository for all your business transactions. Each transaction is posted to a general ledger account..
You can choose to either store balances for all combinations of general ledger account The general ledger will normally include general ledger accounts (GLAs) for items such as income, expenses, assets, liabilities, and reserves., entity Collective term for the following predefined dimensions within your chart of accounts: account, product, bank account, and tax code. and 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. that have been used on your transaction line items (the full accounting code A combination of up to six elements: a general ledger account, a single entity and up to four analysis dimensions, as recorded on a specific transaction line item.), or alternatively any other combination of the six elements The elements of a full accounting code consist of a general ledger account, an entity, and up to four analysis dimensions..
The Intersect Definitions tab displays a home page that lets you quickly create and locate your intersect definitions. You can also sort and filter your intersect definitions using standard and custom list views Give you instant access to specific sets of data. In addition to using existing views, you can create custom list views for the items most relevant to you.. In addition, this tab lets you view and edit detailed information on each intersect definition.
For example, if an intersect definition is setup with dimensions 1, 2 and 3 selected, all 3 dimensions must be populated (as a minimum) on the posted document in order for the reporting balance record to be created.
The Intersect Definition object is an organization-level object Custom object that exists across all companies in an organization (org)..
An example intersect definition
For example, posting a sales invoice with one product and one tax code will create a transaction with one account line and two analysis lines, one containing a product and another containing a tax code.
| Intersect Definition Name | Cost Center Analysis |
|---|---|
| Full Accounting Code | |
| General Ledger Account (GLA) |
|
| Entity
|
|
| Dimension 1 (Region) |
|
| Dimension 2 (Manufacturer) | |
| Dimension 3 | |
| Dimension 4 |
The example intersect definition would cause the following balances to be created, and could be used to report on account balances by region.
- GLA + Account + Dimension1
- GLA + Product + Dimension1
- GLA+ TaxCode + Dimension1
The following examples illustrate the effect on your balances of using full accounting code intersect definition compared to one based on GLA/Dim 1.
Intersect definition with full accounting code
| Company | GLA | Dim 1 | Dim 2 | Dim 3 | Dim 4 | Entity | Type | Year | Period | Home Value |
|---|---|---|---|---|---|---|---|---|---|---|
| Merlin Tech Inc. | 1200 - AR | Chicago | Consumer | Sales | Widgets | Actual | 2013 | 1 | 100.00 | |
| Merlin Tech Inc. | 1200 - AR | Chicago | Consumer | Sales | Widgets | Actual | 2013 | 2 | 1500.00 | |
| Merlin Tech Inc. | 1200 - AR | Chicago | Manufacturing | Consulting | EUR | Widgets | Actual | 2014 | 5 | 1500.00 |
| Merlin Tech Inc. | 1200 - AR | Chicago | Manufacturing | Consulting | GBP | Widgets | Actual | 2014 | 5 | 550.00 |
| Merlin Tech Inc. | 1200 - AR | Chicago | Consumer | Sales | Widgets | Budget | 2013 | 1 | 600.00 | |
| Merlin Tech Inc. | 1200 - AR | Chicago | Manufacturing | Consulting | EUR | Widgets | Budget | 2014 | 5 | 3250.00 |
| Merlin Tech Inc. | 1200 - AR | Chicago | Manufacturing | Consulting | GBP | Widgets | Budget | 2014 | 5 | 2000.00 |