There are two options available:
None
Click this radio button when the entity file is
maintained within the consolidated file and updated in real time. In this
case, work on this entity's records must be done while in the consolidated
file. It cannot be accessed by a remote computer.
Existing File
Click this radio button when the entity's records
are in an individual client file, maintained externally to the consolidated
file. The consolidated file will be updated by batch. Click the Browse button and locate the file and
enter the file path using the Windows Open File dialog.
Notes:
-
Whenever a new
entity is created for a consolidated file with the Existing
File option selected, the path to the external file is stored as
a relative path if a relative path can be determined. This allows consolidated
files and their external entities to be moved as a group from one location
to another, without having to relink all the consolidated files manually.
-
Where a relative
path cannot be determined and the external file is moved, the file path
must be relinked manually.
-
For existing entities,
you can set relative paths by relinking all the files in the hierarchy.
Include Prior, Budget and/or Forecast Balances
Select the appropriate check box if the consolidation
is to include these specific types of balances entered in the individual
client files.
Include Custom Balances
Select this check box to include any custom
balances in the external entity file to the consolidated entity file.
If the custom balance identifier doesn’t exist in the consolidated
entity, then it is created.
Apply Foreign Exchange
To consolidate the foreign exchange balances based
on the foreign exchange rates entered in the individual client files,
click Apply Foreign Exchange.
Exclude zero balance accounts
Select this check box to exclude any accounts from the consolidation in the individual client
files that have zero balances.
An account is considered to have a zero balance if:
-
Its
opening balance is zero;
-
It
has no period balance or other entries posted to it;
-
Its
adjustments add up to zero;
-
It
has no prior year balance in the consolidated file;
-
It
has no forecast year balance in the consolidated file;
-
It
has no budget year balance in the consolidated file;
-
It
has no custom balance in the consolidated file;
-
It
has no adjustments posted to it in the consolidated file;
-
It
was not inserted into the consolidated file;
-
The account is not specified as a rounding
difference account on the Settings
for Reports dialog. Note:
The entity of the rounding difference account is not stored; for example,
if you specify account 100 in the parent entity, account 100 will not
be removed from any external entity, even if its balance is zero.
Enable account synchronization
Select this check box to change account
properties and account annotation between the external entity file and
the consolidated file are merged during batch consolidation. If the same
account was modified in both files, a conflict resolution dialog box opens
where you can choose which file’s property to use.
Unmap new external accounts
Select this check box to have new accounts be brought
in from the external entity with no map number. If this box is cleared, the new accounts will have the same map number they had in the external
entity.
Notes:
-
If you do not want the parent's
account changes to be overridden, ensure that this property is not selected.
-
External files are processed,
one account at a time, and brought into the parent with the account number
used as the unique key during the consolidation.