Consolidate G/L Batches
Use this option on the Integration tab of the G/L Integration form 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.
Note:
Consolidation reduces information and blocks drilldown
from G/L
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).
Use
the Create G/L Batch icon to consolidate details from separate transactions
If you selected the On Request Using Create G/L Batch Icon option to create general ledger transactions, you can consolidate transaction details from all transactions for each general ledger account if you choose Consolidate by Account and Fiscal Period or Consolidate by Account, Fiscal Period, and Source.
Consolidate
details within transactions if creating batches during posting or day
end processing
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.
Consolidation choices
You can choose:
-
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.
This option will consolidate details from different transactions if you create transaction batches using the G/L Batch form.
-
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 G/L Batch form.
Note: The posting date for consolidated entries is the last date of the fiscal period.