Affiliated Companies
Affiliated Companies

1. Affiliated Companies

Subject |
In this field you can select the subject that is the affiliated company. You can select only among subjects that are entered in the Subjects register. |
Other Share |
In this field you can select from the drop-down menu other share holders:
1. Non-residents holding 10% or more interest in the company providing information;
3. Other residents.
|
Our Share (%) |
In this field you can enter percentage of the our share. |
Foreign Share (%) |
In this field you can enter percentage of the foreign share. |
Server Type |
In this field you can select from the drop-down menu the type of the server. If can be MS SQL server, ORACLE server or external file. |
Server |
In this field you can select from the drop-down menu the server on which the database is saved. |
Database |
While you are creating a linked server, the program will in this field display databases that are on this server. Select the database for which you would like to prepare a consolidated statement. You cannot select the base until the program allows you the remote access to consolidation. |
Collation |
Choose from drop down menu. |
(Create Linked Server)
|
With a click on this button you will create a link to the selected server. |
(Remove Linked Server)
|
With a click on this button you will remove the link from the selected server. |

(Take Over Doc. Types) |
If you click on this button, the program will display all document types that are used by the selected affiliated company. Since a company can over a certain period create new document types, you can repeat this procedure (before generating the consolidated statement). |
Receivables Account |
This is connected with settings in Administration panel / Financials / Posting. There is an option "Post Payables / Receivables of Affiliates". Issued invoices will be posted to set account for the affiliated companies. |
Payables Account |
This is connected with settings in Administration panel / Financials / Posting. There is an option "Post Payables / Receivables of Affiliates". Received invoices will be posted to set account for the affiliated companies. |
Type of Share |
Choose from drop down menu. |

(Import Document Type from File)
|
By clicking that button, we import the document type for the selected entity. Previously entered document types will be erased before import! Structure of Excel file:
- Subject,
- Document Type,
- Opening (T/F),
- In use (T/F),
- Record Only document (T/F),
- Document Type Name.
|

(Import Chart of Account)
|
By clicking that button, we import the chart of accounts for the selected entity. Previously entered chart of accounts will be erased before import! Structure of Excel file:
- subject,
- account,
- our account,
- type (I - elimination, Z - replacement)
- enabled (T/F).
|
Chart of Accounts |
Choose from drop down menu. Accounts can be set for each chart of accounts in the program separately. The transfer of data will be respected chart of accounts, which is active for a period of consolidating. |
2. Settings

Opening Entry
In this section the program displays a journal entry that is defined in the as opening document type:

Selected |
Select this box if you would like that program will include transactions on this journal entry in the preparation of the consolidation statement. |
Document Type |
Document type that is used by the company for posting. |
Record Only |
This box will be checked if a document type on the selected affiliated company has selected the Record Only option. This information can be a basis for the decision to include the transaction of this journal entry in the creation of the consolidated statement. |
Name |
Name of the document type. |
Affiliate's Journal Entry Doc. Types
List of entries that are used by the selected company:

Selected |
Select this box if you would like that program will include transactions on this journal entry in the preparation of the consolidation statement. |
Document Type |
Document type that is used by the company for posting. |
Record Only |
This box will be checked if a document type on the selected affiliated company has selected the Record Only option. This information can be a basis for the decision to include the transaction of this journal entry in the creation of the consolidated statement. |
Name |
Name of the document type. |
Subsidiary Accounts
In this section the program displays accounts that is used by the selected affiliated company as a subsidiary account:

Account |
The ID of the account that is used by the selected affiliated company. |
Name |
Name of the account. |
3. Accounts to Exchange

Affiliate's Chart of Accounts


(Take Over Chart of Accts.) |
If you click this button, the program will display the chart of accounts that is used by the selected affiliated company. |
Account (affiliate) |
ID of the account that is used by the selected affiliated company. |
Name |
Name of the account that is used by the affiliated company. |
Posting |
Information in this field shows whether if the affiliated company has on the account debit posting, credit posting or both. |
Subject Account |
Information in this field shows whether the account of the affiliated company is defined as a subsidiary account. |
Account (ours) |
If an account of the affiliated company is not defined in your chart of accounts, you can assign him in this field your account. |
 |
If you click this button, the program will save entries to the Account (ours) column. All accounts of the affiliated company to which you have assigned a suitable account of your company will be transferred to the Accounts to Exchange window on the left side below in the panel. |
Replace / Exclude Accounts

In this section are recorded accounts of the selected company, to which you have assigned a suitable account of your company.
Account (affiliate) |
ID of the account that is used by the selected affiliated company. |
Account (ours) |
You account that suits the account of the linked company. |
Name |
Name of the your account. |
Type |
If we choose Replace, program will replace account of affiliated company. If we choose Exclude, it will not be take into account when collecting data form other databases. |
Being Established |
|