Explaining the General Ledger Integration

Objective

After completing this lesson, you will be able to explain the General Ledger integration

General Ledger Integration

Relationship between general ledger and subledger.

Contract accounting is a subledger that originates from various upstream applications such as convergent invoicing. Instead of individually posting of each subledger document, totals records are transferred to the general ledger. This summarization technique greatly reduces the volume of postings in the general ledger and results in a tremendous performance advantage.

The totals records is the transfer unit for summarized subledger documents. The grouping criteria are company code, posting date, general ledger account, tax and currency.

The reconciliation key lists the totals records to be transferred to the general ledger.

The reconciliation key is automatically determined in the case of mass postings:

  • In lot processing (payment lot, returns lot), the reconciliation key is the key of the lot.
  • In mass runs (payment, dunning, interest), the reconciliation key is YYDDD<Run ID>.

The reconciliation key is manually entered in the case of single postings.

The general ledger transfer is done in 2 steps: closing the reconciliation keys and the transfer of them.

Reconciliation keys are closed and transferred to the general ledger at the end of the day. It's also possible to execute the transfer several times during the day. This is scheduled in the background, so no manual execution is required.

The mass run Transfer Total Records to G/L is also executed automatically and periodically. The mass run posts the total records in the general ledger.

Potential documents of the general ledger and the subledger.

The posting totals of the corresponding documents are recorded per reconciliation key. Once a reconciliation key is closed, no more postings can be completed with it. Accordingly, the posting totals can no longer be changed. A transfer document for general ledger is created from the posting total of each reconciliation key. An item with an amount equal to that of the totals record is generated in the transfer document.

The transfer run posts the total records in the general ledger. Totals records with a different posting date create different general ledger documents.

Transfer a Reconciliation Key to the General Ledger

Business Example

You are responsible for the financial closing and reconciliation activities in your company.

You have to transfer the reconciliation keys from Contract Accounting to the General Ledger.

Note

We recommend, to perform all exercises within one week in the correct sequence. If this is not possible, you should use the recordings instead.

Note

You must assign the business roles from the following table to your user. For more information about roles assignment, see the System Setup Guide.

Business Roles

Business RoleBusiness Role ID
Z_S4C_GENERIC_ROLESAP S/4HANA Cloud Generic Role
BR_APR_ACCOUNTANT_FICAContract Accounting Accountant
BR_APR_MANAGER_FICAContract Accounting Manager
BR_COLL_SPECIALIST_FICAContract Accounting Collections Specialist
BR_CONF_EXPERT_APR_FICAContract Accounting Configuration Expert
BR_ADMIN_APR_FICAContract Accounting Administrator
BR_RECONC_SPEC_APR_FICAContract Accounting Reconciliation Specialst
BR_INVOICING_ADMIN_CINVConvergent Invoicing Administrator
BR_INVOICING_SPEC_CINVConvergent Invoicing Specialist

Note

Whenever ### is used, replace it with your group number.

Note

This exercise is based on the results of the exercise Create a Contract Account.

Exercise Options

To perform this exercise, you have two options:

  1. Watch the simulation: to start the simulation, choose Start Exercise in the figure below.
  2. Perform the steps, as described below.

To perform this exercise, use the information from the following tables:

Header Data

Field NameValue
Document DateToday's Date
Posting DateToday's Date
Document TypeYA General Document
CurrencyEUR

Item Data

Field NameValue
Contract AccountCA_DE_###
Company Code1010
Main Transaction Y600 Other Receivable/Credit
Sub Transaction0020 Other Receivables
Amount800

Account Data

Field NameValue
Business PartnerBP_DE_###
List TypeALL All Items
Line LayoutYN1 Line Item Display - Basic View

Reconciliation Key Data

Field NameValue
Reconciliation Keyyour noted reconciliation key
Test Run / Update Run2 Update Run

Log in to track your progress & complete quizzes