Transfer Journal Entries to GL

Introduction

Transfer Journal Entries to GL process transfers inventory journal entries for a given period into the general ledger. The accounting information for transactions is held in relevant subledger accounting tables. However, they need to be accounted in General Ledger (GL) for proper consolidation by running the "Transfer Journal Entries to GL" concurrent program.

Transfer Journal Entries to GL Program

The Transfer Journal Entries to GL program consists of a subset of parameters used in the Create Accounting program as listed below:

• Ledger
• Process Category
• End Date
• Post in General Ledger
• General Ledger Batch Name

Level of Summarization

The level of summarization that is transferred to GL for the accounting information related to these transactions depends on the value chosen in the subledger accounting options in ledger setup. The possible values are:

No Summarization (Detail), Summarized by GL Date, Group by GL Date, Group by GL Period

If ‘Summary’ is selected, the accounting information pertaining to the transactions is summarized and the summary entries are posted to GL. The advantage of running the process in 'Summary' mode over 'Detail' mode is minimising the posting times. Transferring detail transaction distributions to the general ledger increases general ledger posting times due to the number of records created.

If ‘Detail’ is selected, detailed accounting entries are transferred to GL. In this case, the posting times are larger due to a larger number of records. However, the advantage of this mode is creation of detailed accounting records in GL for every transaction in Inventory.

For summary transfers, this entered date is assigned as the date for summarized transactions for that open period. Current Period This value would default from the ‘Date’ parameter above. This is the open period containing the above date. Description Some appropriate text.

Transfer Journal Entries to GL Report

The Transfer to Journal Entries to GL Report is generated by the Transfer Journal Entries to GL program and lists the following:

• Transfer to GL Summary 
• General Errors

Conclusion

‘Transfer to GL’ process can be run at any time during an open period as a concurrent program or as a part of the period end process. When the process is run with more than one periods open, all the transactions from the earliest open period to the date up to which the process is run (Transfer Date) are considered for Transfer to GL. The transfer involves update/insert on four main tables gl_interface, org_gl_batches, mtl_transaction_accounts & wip_transaction_accounts. The accounting data can then be imported into General Ledger using ‘Journal Import’ program.