The system validates all values when you click Save in Journal Entry Cross-Cy Excel Integration. No validation occurs until this point.

When creating cross-company posting entries, the accounts, daybooks, sub-accounts, cost centers, and projects you specify must be valid within their associated shared sets for the entity in which the posting is being created. If you specify an invalid value, an error message is displayed.

You can create cross-company postings on the following types of account: Standard, GL Open Item, Bank, Year-End, Fixed Assets, Tax, and System.

The following fields must be entered in Excel for a cross-company posting to be valid. If these mandatory fields are blank, an error is displayed.

The system also ensures that the sum of the postings to the source entity equals the sum of the postings to the target entities.

You can use different currencies when posting to particular entities. The system then ensures that all postings balance. You can also post to entities that have different GL calendar years and GL periods to the source entity.

You can only post to daybooks from the official and management layers. However, daybook layers must be consistent across a posting; that is, postings can be to the official layer or the management layer, but a posting cannot contain a combination of both layers.

At level 3, the system ensures that the year and period entered are valid for the entity in which the cross-company posting occurs. In addition, the Sequence Number field must contain a non-zero value.