Use the Consolidate G/L Batches setting on the I/C G/L Integration screen to specify whether to combine transaction details for the same general ledger account into a single detail, or send unconsolidated Inventory Control transaction details to General Ledger.
Consolidation reduces the amount of information in the general ledger batch, and results in a shorter G/L Transactions Listing.
Consolidation also:
- Removes transaction-specific information from the Reference and Description fields for each transaction.
- Removes optional field information from transactions.
- Blocks drilldown from G/L transactions to the originating entries in Inventory Control (unless consolidating by account only).
Consolidation Options
Choose one of the following options:
- Do
Not Consolidate. All the details posted in Inventory Control will
be included in the General Ledger transaction batch.
Choose this option if you use optional fields and pass optional field information from I/C transaction details to the G/L transaction details.
- Consolidate
Transaction Details by Account. All the details within a transaction
with the same general ledger account number are combined into one detail
if the G/L Detail Description and the G/L Detail Reference are also the
same. The program will not consolidate details that have a different description
or reference.
Choose this option if you do not use optional fields, but still want to associate general ledger transactions with originating documents (for drilldown or to maintain a manual audit trail).
- Consolidate by Account and Fiscal Period. All the details with the same general ledger account number and fiscal period are combined into one detail.
- Consolidate
by Account, Fiscal Period, and Source. All the details with the
same general ledger account number, fiscal period, and source code are
combined into one detail.
This option will consolidate details from different transactions if you create transaction batches using the I/C Create G/L Batch screen.
Note: The posting date for consolidated entries is the last date of the fiscal period.
If either the Consolidate by Account and Fiscal Period or the Consolidate by Account, Fiscal Period, and Source consolidation option is selected and you create batches of G/L transactions using the I/C Create G/L Batch screen, the program consolidates transaction details from all transactions for each general ledger account.
If you create batches of G/L transactions during posting or day end processing, the program can only consolidate the details within transactions. It cannot consolidate the details from different transactions.