42 Increase the Length of Object Accounts

This chapter contains this topic:

42.1 Increasing the Length of Object Accounts

As your business changes, it might become necessary for you to change the length of your object accounts. JD Edwards World uses a World Writer Report to change the length of your object accounts. After you have made the changes, you will need to update other programs that use your account data.

You can increase the length of your object accounts, but you can not decrease them.

This section includes instructions for the following:

  • Before You Begin

  • Create a World Writer Report Based on the F0901 File

  • Updating the Account Ledger (F0911), Account Balance (F0902) and Item Balances (F1202) Files

  • Updating Additional Files

Before You Begin

Because the account structure is central to the correct operation of JD Edwards World, there are several precautions you must take before making changes to the length of an object account. Before you begin, do the following:

  • Back up your system

  • Test this procedure in an alternate environment prior to implementing in your production environment

  • Verify that no users are signed into the environment and that no jobs are running or waiting to run

  • Run a Trial Balance and/or Simple Balance Sheet and Income Statement and verify balances

  • Run the Companies in Balance report (P097001) and correct any discrepancies

Create a World Writer Report Based on the F0901 File

  1. Create a World Writer Report containing the following criteria:

    • A list of all object accounts

    • The code for multiplying the object number by a multiple of 10. For example, to increase the object account length by 1 digit (from 4 digits to 5 or from 5 digits to 6), multiply it by 10, to increase the object length by 2 digits, multiply it by 100.

    • The code to update the object account to that result. For example, if your object account was 1110 and you multiplied the account by 10, the new object account would be 11100.

  2. Run your report.

Updating the Account Ledger (F0911), Account Balance (F0902) and Item Balances (F1202) Files

After you have updated the Accounts Master, run the following programs to propagate those changes:

  • Run Update BU.Obj.Sub to Jrnl Entries (P09806) to update the Account Ledger (F0911) and Account Balance (F0902) files to the new format.

  • Run Update Co#, BU/Obj/Sub - F1202 (P12802) to update the Item Balances File (F1202) to the new format.

Updating Additional Files

When you change your account structure, you impact many other processes. Depending on the Modules you run, you might have to review and make updates throughout your system, including:

  • Automatic Accounting Instructions (AAIs)

  • DREAM Writer Data Selection for reports that your business runs

  • Bank account information

  • Bank account for unpaid vouchers

  • Supplier Master if Default Expense Accounts are used

  • Customer Master if Default Revenue Accounts are used

  • FASTR and STAR reports

  • Item Master

  • Location Tracking

  • Allocations

For a complete list of the files that you have affected by changing your account structure, inquire on the Data Dictionary item for OBJ, and press F15 to display a cross reference of files which use the data item. The Display field must contain the value F to display files.