Summarization of Interunit and Intraunit Journal Lines

When you want to reduce the number of journal lines generated by interunit or intraunit processing and find that it is not necessary to maintain separate interunit or intraunit balancing, you can choose to use summarization on the Installation Options, Overall page. In addition, you must either not setup affiliates or deselect affiliates for account, fund or operating unit if you want to summarize interunit or intraunit journal lines.

All non-monetary fields on journal lines must be identical to successfully summarize them. Affiliate must not be used, otherwise journal lines cannot be identical and are not summarized by the system. This requirement enables you to selectively use summarization by specifying affiliates in some Ledger Groups but not in others.

You can use interunit with intraunit summarization together and interunit and intraunit journal lines are not combined. If you specify affiliate for business unit, you can summarize by business unit and not by fund or operating unit. Summarization can be selected at installation or at a later date. If selected at a later date, the result is that there will be additional and perhaps unnecessary journal lines.

Note:

If you are using the Sybase database, there is a limitation of a maximum of 31 columns in a group by clause. For this reason system-generated lines even if sharing the same ChartField combination, will not be grouped or summarized together into a single journal line; but separate detail lines will be created.