IY and G/L Posting

Inter-Entity will insert entries where a G/L batch will put entities out of balance. If an entry cannot be balanced, an error batch will be created. For example, if you use Account structures which exclude the entity segment or segments. If this is the case, Inter-Entity will ignore these batch entry lines as long as they balance amongst each other. If they do not balance, Inter-Entity will report an error as it will have no way to balance the entity related transactions as they will not balance as a whole either.

When processing between databases Inter-Entity will create un-posted batches in on-line target databases on posting in the source database. Export files are created for remote / off-line databases through the periodic posting function. 

If an entry cannot be sent to the Target database, an error will be created in the Inter-Entity log. Please refer to the Inter-Entity inquiries or Audit Report for details. Once the error has been resolved, run Periodic Processing to process error transactions.

 

How Inter-Entity ascertains what description and reference to use when creating balancing entries in the General Ledger:

On Posting, Inter-Entity applies the following rules:

Rule 1: If a journal entry has more than one line going to the same account then, if the description and reference is the same on all lines use this common description and reference and, if not, use "Consolidated Description" and "Consolidated Reference" respectively. 

Rule 2: All journal entries fall into one of the following 3 categories: 

  • One Debit Entity to Many Credit Entities (1 : m)

In this case use the references and descriptions associated with the credit entries are used for the balancing entries having applied rule 1 above

  • One Credit Entity to Many Debit Entities (1 : m)

In this case use the references and descriptions associated with the debit entries are used for the balancing entries having applied above

  • Many Debit Entities to Many Credit Entities (m : n)

As Inter-Entity cannot in all instances determine which debits and credits are related "Consolidated Description" and Consolidated Reference" are used for the Description and Reference fields respectively.

 

See Also

Generate Inter-Entity Transactions - Overview

Periodic Processing

Inter-Entity Inquiries

Inter-Entity Audit Report