Combined Financial Statements

In a Multi-Site environment there are times when you want to combine the data of two or more sites regardless of the hierarchical financial structure or legal financial entities. To allow this, you can take advantage of Multi-Site Groups used in other parts of the system (most often to run reports and utilities).

By creating a Multi-Site Group ID which contains a list of sites which you would like to combine, you can specify this site group when running certain General Ledger reports. These reports are:

General Ledger
Journal Transaction Report
User-Defined Financial Statements
To ensure meaningful reports, the sites must share the same Chart of Accounts format.

Note:

Convert transaction amounts from the other site into its own domestic currency using the exchange rate tables set up in the other site, and
Have a transaction date that is equal to or later than the Effective Date of the exchange rate

Otherwise the conversion cannot be done. If either of the above two conditions is not met you will receive an error message when attempting to output a combined financial statement.

When running combined financial statements where different sites have designated different base currencies, you may specify the translation method to use on each line of the defined financial statement.