Consolidation

This window defines the rules for consolidating multiple posting transactions with identical journal number and posting General Ledger account number combination into one, consolidated posting transaction.

Prerequisites

  • No prerequisites.

Rules and Guidelines

  • Consolidation is optional and can be used for generating consolidated posting transactions or for printing purposes only.
  • The consolidation on posting transactions could occur when:-
  • Consolidate Posting Transactions only when reporting on them, yet retain the individual transactions for posting to the General Ledger.
  • Consolidate Posting Transactions for passing to the General Ledger, yet retain the individual transactions for reporting purposes.
  • Consolidate posting transactions both for reporting and posting to the General Ledger.
  • All posting transactions have identical Journal Number and General Ledger account number combinations, there is a matching Consolidation record and these records are consolidated into a single posting transaction by the Close G/L Posting PTD File function.
  • If using the JDE Release 7 product code 22 interface together with the Statistical Record Generation option, the consolidation process cannot be used.

Field Information

Enter the Consolidate Journal Number.

Enter a General Ledger Account number for consolidation or *ALL.

  • *ALL; only those General Ledger accounts not already specified in other Consolidation records for this journal number are covered by this record.

Indicate if the transactions to be consolidated are for printing purposes or not.

Code Description
Y Consolidate when the Open Period File is closed. Consolidation is performed by the Close Open Period File option.
N Do not consolidate.

 

Indicate if the consolidation will be performed or not when posting the Open Period File or the Closed Period File.

Code Description
Y Consolidate when posting the Open Period Fileor the Closed Period File.
N Do not consolidate when posting the Open Period File or the Closed Period File.

 

This field is only relevant to the JDE interface, and consolidates at the User Field 1 level.

Code Description
Y Consolidate at User Field 1, JDE General Ledger users only.
N Do not consolidate at User Field 1. All other General Ledger systems.