51 Set Up Ledger Types for the Annual Close

This chapter contains the topic:

The Annual Close program (P098201) automatically:

  • Creates a new F0902 Account Balance records for the new fiscal year

  • Updates the Balance Forward field and Prior Year Net Posting field with amounts for all ledger types that are selected to be closed.

However, there are some ledgers for which you will need to create UDC values.

51.1 Specifying UDC Values

Navigation

From General Accounting (G09), Enter UDC in the Selection or command line

You access each of the UDC tables in the same way.

From General User Defined Codes

Figure 51-1 System Code screen

Description of Figure 51-1 follows
Description of "Figure 51-1 System Code screen"

  1. Complete the following fields

    • System Code

    • User Defined Codes

  2. Use the Inquiry Action and press Enter.

51.1.1 What You Should Know About

Topic Description
System Code The system code identifies the category of the transaction. For example 09 is the code for General Accounting
User Defined Code The User Defined Codes filed identifies a specific UDC table

Accounts not required to balance (09/LA)

UDC table 09/LA identifies those ledger types which are not required to balance, when posting to GL and for which retained earnings is to be calculated.

From General User Defined Codes

Figure 51-2 General User Defined Codes screen

Description of Figure 51-2 follows
Description of "Figure 51-2 General User Defined Codes screen"

  1. Enter 09 the following field:

    • System Code Field

  2. Enter LA in the following field:

    • User Defined Codes

  3. Use the Inquire action and press Enter.

  4. Access the Detail Area. (F4)

  5. Complete the following fields, as needed:

    • Code

    • Description

    • Special Handling Code

      It is necessary to populate the Special Handling Code field with a non-blank value in the first position in order for the system to calculate retained earnings for that ledger type.

    Note:

    JD Edwards World calculates retained earnings automatically for the AA and AZ ledgers. It is not necessary for you to setup either ledger type in this or the preceding UDC table.
  6. Use the Change or Add action, as needed and press Enter.

Ledger types required to balance (09/LP)

User Defined Code table 09/LP identifies those ledger types, which are required to balance, when you post to GL and for which retained earnings is to be calculated.

Figure 51-3 General User Defined Codes (Ledger Types) screen

Description of Figure 51-3 follows
Description of "Figure 51-3 General User Defined Codes (Ledger Types) screen"

  1. Enter 09 the following field:

    • System Code Field

  2. Enter Lp in the following field:

    • User Defined Codes

  3. Use the Inquire action and press Enter.

  4. Access the Detail Area. (F4)

  5. Complete the following fields, as needed:

    • Code

    • Description

    • Special Handling Code

      It is necessary to populate the Special Handling Code field with a non-blank value in the first position in order for the system to calculate retained earnings for that ledger type.

    Note:

    JD Edwards World calculates retained earnings automatically for the AA and AZ ledgers. It is not necessary for you to setup either ledger type in this or the preceding UDC table.
  6. Use the Change or Add action, as needed and press Enter.

Budget Ledger Types (00/LT)

User Defined Code table 00/LT identifies budget ledger types and controls how the original budget amount field (BORG) is updated. If processing option 2 of the annual close program is populated with a 1, this UDC table is used.

Figure 51-4 General User Defined Codes (Budget Ledger Types) screen

Description of Figure 51-4 follows
Description of "Figure 51-4 General User Defined Codes (Budget Ledger Types) screen"

  1. Enter 00 the following field:

    • System Code Field

  2. Enter LT in the following field:

    • User Defined Codes

  3. Use the Inquire action and press Enter.

  4. Complete the following fields, as needed:

    • Code

    • Description

    • Description - 2

      The value in the first position of the Description-2 field controls how the system updates the original budget amount for the new fiscal year. There are four different values, which you can populate in the first position of Description-2:

Value Explanation
S Does not roll the final (original) budget forward to the BORG field of new fiscal year records.
R Rolls this year's final budget forward to the BORG field of the new fiscal year.
B Rolls this year's final budget forward to the BORG field of new fiscal year and spreads the amount across the Net Posting fields based on the Budget Pattern Code.
Blank Does not roll the budget and does not override the DNS code.