Multiple financial companies
In case of multiple financial companies, depending on the required functionality several financial tables from the Financials (tf) package can or must be shared between these financial companies (central invoicing will be discussed later). These table sets assume that the common tables as described for the General Multicompany setup are also shared between the financial companies.
R10000 SL-MF Financial (KT)
This table set contains the financial tables which must be shared between the financial companies in all cases.
R10100 Central Integration Mapping (KT)
In LN, the mapping scheme must always be centralized, in such a way that the mapping scheme must be shared amongst all financial companies present in a certain environment.
If a different mapping is required for certain financial companies for specific transactions, the particular mapping for that company must be set up by entering the financial company number. That means that the tables within this table set must always be shared between all financial companies that are part of the company table in Enterprise Modeling Management (tcemm170).
- Sharing this table does not imply that an integration mapping scheme is valid for all financial companies. If this is also required, in addition to the tables of this table set, the Chart of Accounts must be set up centrally. Therefore, the tables in table set R10200, must be shared also.
- Document Series by Transaction Type (tfgld017) must not be shared. However, the series used in the mapping scheme (tfgld477) must exist in all financial companies, if document numbering / compression data (mapping scheme maintenance) was not set up by financial company.
R10200 Central Chart of Accounts (KT)
This table set contains all tables that must be shared to achieve a central chart of accounts.
R10300 Financial Group Company (KT)
In Financials, you can group financial companies into a financial group. The transactions created between the companies of a group are referred to as intercompany transactions.
This table set contains the tables to be shared between the financial companies that belong to the same group company.
R10400 Central Integration Processing (KT)
For a central logging of financial integration transactions, the tables as specified in this table set must be shared.
R10500 Multicompany Purchase Invoice Matching (KT)
In a multicompany structure in LN purchase invoice matching is possible in any financial company belonging to the same financial group company. To achieve this, the tables of this table set must be shared between the financial companies that belong to the same financial group company.
This table set must also be implemented if receivable invoices reports (tfacp1432m000) are required across companies.
The tables listed in this table set must be shared for companies for which combined multicompany receivable invoice reports must be produced.
R10600 Central Cash Management (KT)
If you use central Cash Management, payments and receipts can be performed in a group company for all financial companies of the group company. This table set contains the tables to be shared for central Cash Management.
If you use payment schedules or receipt schedules, the Bank Relations (tfcmg001) table must also be shared.
R10700 Multicompany Fixed Asset Transfer (KT)
A fixed asset can be transferred from one financial company to another. To achieve this functionality, the tables in this table set must be shared.
R10800 Central Reconciliation Transactions (KT)
We recommend that you do not share the reconciliation transactions tables for the following reasons:
- Reconciliation functionality does not require the data to be present in one physical company, because reconciliation analysis will mainly if not exclusively occur by financial company.
- Reconciliation transactions tables tend to become very large if reconciliation is required for many areas.
However, if in the chosen setup logging of reconciliation transactions has been switched on for only a limited number of reconciliation groups, reconciliation transactions may be shared. Then, the entire set of tables in this table set must be shared. So, if the table size is not an issue, an advantage may be some performance gain in deleting and archiving logistic data that may be linked to reconciliation transactions in various financial companies, such as purchase orders and service orders.
R11000 Central Financial Statements (KT)
Via central financial statements common definitions of the financial statements can be defined and reports across financial companies can be created, for example, to compare budget versus actual across financial companies. To achieve this, the tables of this table set must be shared.
R11100 Central Tax Declaration (KT)
In Financials, you can have one tax declaration for more than one company. Note that this document does not discuss the legal aspects between which financial companies this is allowed. This central tax declaration can be a VAT declaration and/or a withholding tax of social contribution declaration. The central tax declaration will be done for all companies that belong to a specified company set. To achieve this central tax declaration, tables in this table set must be shared between the companies that belong to this table set. It is not required to share the tax analysis tables.
In Cash Management, a tax payment will be created in the company from which the tax declaration is created.
R11200 Centralized Transaction Entry (KT)
You can enter transactions in one financial company for another financial company that belongs to the same group company. To support this, the tables in this table set must be shared between these financial companies.
R11300 Centralized Standard Currency System Reporting (KT)
Several financial reports can be printed across multiple financial companies. Examples of such reports are the Trial Balances. For currency systems other than the standard currency system, these reports are printed in the reference currency. In the standard currency system, you must set up reporting currency groups (tfgld0680m000) to be able to print these reports across multiple financial companies. Setting up reporting currency groups requires that the financial companies share at least one home currency. You must share the corresponding tables that are part of this table set, across these financial companies.
R11400 Centralized Transaction Types (KT)
This table set contains all tables that must be shared to have central transaction types.
R11500 Central Account Match Setup (KT)
This table set contains the tables that must be shared to set up central account matching. To enable central account matching, initialize the account matching setup per company. You can do this from within one company. You can perform the account matching process within the current company only.
If these tables are shared, you can also perform a global update across companies.
R11600 Central Budget Master Data (KT)
This table set contains master data for the setup of budgets. For example, by sharing the budgets and budget accounts, each company can use the same code in its budget structure.
R11700 Central A/P Header Documents (KT)
This table can be shared within a group company. This improves performance of the central payment process. In addition to this, sharing this table enables the view of Cash Forecast by Supplier / Payment Due Date (A/P) across financial companies.
R11800 Central A/R Header Documents (KT)
This table can be shared within a group company. This improves performance of the central direct debit process.
R11900 Central Payment Views (KT)
By sharing the tables of this table set from one company, an authorized user can view and manage the payments of all companies between which these tables are shared.
R12000 Central Receipt Views (KT)
By sharing the tables of this table set from one company, an authorized user can view and manage the (financial) receipts of all companies between which these tables are shared.
R12100 Central Reminder Diary Notes
These tables must be shared for those financial companies for which the reminder diary notes and activities, entered by an A/R credit analyst in one of these companies, must be visible from either of these companies.
R12200 Central Cross Validation Rules
This table set contains all tables that must be shared for central cross validation rules. These rules specify which dimensions apply to what ledger account.
R12300 Central Credit Control
These tables must be shared for those financial companies for which the A/R credit analyst wants to handle central credit collections and create reminder advices for invoices from multiple financial companies.
R12400 Central Aging Analysis
This table set contains all tables that must be shared to perform a central aging analysis for multiple financial companies.
R12500 – Central Received Invoices
Invoices for multiple financial companies that are part of the same financial group company, can be received and scanned centrally in one of these financial companies. Invoice matching and approval is performed in the responsible financial company, unless central purchase invoice matching is implemented. To enable the Central Received Invoices functionality, the tables from this table set must be shared between the financial companies:
The tables in this table set can be shared within a group company. Consequently, a relation with R10300 is available.
R12600 – Central External Invoices
Invoices can be received from external invoicing software such as Basware. These invoices are received in a financial company and from there they are processed to the financial company to which the invoice belongs.
When sharing the tables from this table set, these external invoices can also be viewed and processed in other financial companies.
The tables in this table set can be shared within a group company. Therefore, a relation is present to table set R10300.
R14900 – Maximum Sharing Financials (KT)
This table set contains all tables from the Financials (tf) package that can be shared. Tables that are not part of this table set cannot be shared.
These tables must only be shared if you use multicompany purchase invoice matching:
- Order for Approval (tfacp240)
- Receipts (tfacp245)
- Invoices Related to Purchase Order Lines (tfacp250)
- Invoices Related to Purchase Receipt Lines (tfacp251)
- Purchase Consumptions (tfacp249)
- Invoices Related to Purchase Consumptions (tfacp253)
- Landed Cost Lines History (tfacp239)
- Landed Cost Lines (tfacp244)
- Landed Cost Lines by Invoice (tfacp254)
- The Purchase Invoice Authorizations (tfacp006) table can only be shared between companies that use the same local currency.
- The tables of table set R10500 Multicompany Purchase Invoice Matching (KT) must only be shared if you use multicompany purchase invoice matching.
No sharing between different group companies
These tables cannot be shared between financial companies that belong to different group companies:
| Table | Description |
|---|---|
| tfacp006 | Purchase Invoice Authorizations |
| tfacp014 | Purchase Invoice Payment Authorization |
| tfacp110 | Received Purchase Invoices |
| tfacp111 | Received Invoice Lines |
| tfacp112 | Received Invoice Tax Lines |
| tfacp118 | Defaults for Received, Generated and External Invoices |
| tfacp150 | Received Purchase Invoices History |
| tfacp160 | Received Purchase Invoices History |
| tfacp161 | Received Invoice Lines History |
| tfacp162 | Received Invoice Tax Lines History |
| tfacp206 | Request to Reuse a Supplier Invoice Number |
| tfacp207 | Debit Notes |
| tfacp208 | Commission Invoices |
| tfacp209 | Certificate of Payments |
| tfacp500 | Open Items A/P |
| tfacp505 | Related Purchase Invoices |
| tfacp510 | Purchase Invoice Lines |
| tfacp511 | Purchase Invoice Tax Lines |
| tfacp550 | Open Items A/P History |
| tfacp551 | Payment Schedule History |
| tfacp560 | Purchase Invoice Lines History |
| tfacp561 | Purchase Invoice Tax Lines History |
| tfacp600 | Open Items Payment-related Documents A/P |
| tfacp601 | Invoices/Documents by Payment-related Documents |
| tfacp602 | Open Items Payment - Order Information |
| tfacp700 | External Purchase Invoices |
| tfacp705 | External Invoice Receipts |
| tfacp706 | External Invoice Stage Payments |
| tfacp710 | External Invoice Cost Lines |
| tfacp711 | External Invoice Cost Lines Project |
| tfacp712 | External Invoice Cost Lines PCS Project |
| tfacp713 | External Invoice Cost Lines Service |
| tfacp720 | External Invoice Subcontracting |
| tfacp721 | External Invoice Tax Lines |
| tfacp750 | External Purchase Invoices History |
| tfacp755 | External Invoice Receipts History |
| tfacp756 | External Invoice Stage Payments History |
| tfacp760 | External Invoice Cost Lines History |
| tfacp761 | External Invoice Cost Lines Project History |
| tfacp762 | External Invoice Cost Lines PCS Project History |
| tfacp763 | External Invoice Cost Lines Service History |
| tfacp770 | External Invoice Subcontracting History |
| tfacp771 | External Invoice Tax Lines History |
| tfgld001 | Financial Companies by Group Company |
| tfgld015 | Intercompany Relations |
| tfgld022 | Intercompany Relations by Currency |
| tfgld080 | Reporting Currency Groups |
| tfgld081 | Reporting Currency Group Details |
| tfgld170 | Taxonomies |
| tfgld171 | Taxonomy Accounts |
| tfgld172 | Mappings by Taxonomy Account |
| tfgld173 | Companies by Taxonomy |
| tfgld174 | Taxonomy Errors and Warnings |
| tfgld260 | Cash Flow Information Codes |
| tfgld261 | Cash Flow Information |
| tfgld438 | Transactions split via Operation Management |
Relations between table sets
