GL Setup: Unable To Create SET OF BOOKS Error: "RETAINED EARNINGS SHOULD BE A BALANCE SHEET ACCOUNT" (Doc ID 1037211.6)

Last updated on FEBRUARY 16, 2023

Applies to:

Symptoms

 You are trying to create a new Set of Books as follows:

Responsibility = General Ledger Super User
GUI Navigation = Setup/Financials/Books
GUI Short Form = GLXSTBKS (Set of Books)
APPS Versions  = 10, 11, 11i

  1. You fill in all the required fields in the Set of Books form.

  2. You are in the Accounts section at the bottom of the form.  You enter an account code combination in the 'Retained Earnings' field.

  3. When you try to tab past this field, you receive the following error:

        "Retained earnings account must be a balance sheet account."

  3. You cannot save your Set of Books without a Retained Earnings Account.
     You are unable to navigate past the Retained Earnings field

Additional Information
----------------------
-- This is a new install.
-- There are no other sets of books defined.
-- The value sets and segment values were all manually entered.
-- The Accounting Flexfield successfully compiled.
-- All the segment qualifiers have been properly set.
-- The account segment is an owner's equity account type.
-- Dynamic Insert is set to 'YES.'
-- There are no existing rows in the GL_CODE_COMBINATIONS table.

Changes

 None

Cause