Learn more

G/L Accounts

Chart of Accounts

Create Accounts Preview Report

Changing Account Information

Using Create (G/L) Accounts

Before you start

  • Before you create accounts automatically, you should print and examine your chart of accounts carefully to be sure you select an appropriate range of accounts to use as the base accounts and to determine what other criteria you need for creating the new accounts.
  • Note that if an account already exists in your chart of accounts, General Ledger will not overwrite it when you create the new accounts. Also, if your existing chart of accounts contains no accounts with the required segments in the specified range, the program will not create any new accounts.

To automatically create accounts

  1. From the Navigation Pane, go to Setup > Payroll > General Ledger > Create Accounts.
  2. Use the Finders in the From Accounts With Structure Code and Create Accounts With Structure Code fields to select a structure code on which to base the model accounts.
  3. In the Select Account Range area, choose either Account Number, Account Group, or Sort Code-Account Group using the drop-down arrow in the Select By field, then enter the ranges in the From and To fields for that selection.
  4. If you want to review existing accounts along with the accounts to be added, select the Include Existing Accounts option.
  5. Use the table to specify the segments you want to create.
  6. Click Preview. The program displays a message telling you how many preview accounts it created.
  7. Click Close to close the message. The G/L Create Accounts Preview window opens, letting you:
    • Change the accounts before you add them. If your existing chart of accounts contains no accounts with the required segments in the specified range, the program will not create any new accounts.
    • Specify optional field information for the accounts to be created.

      The program assigns to the new accounts the optional accounts fields and optional transaction details fields set for the model accounts using the segment specified in the Default Options From field.

      The Optional Fields column on the preview window indicates whether optional account fields will be assigned to the new account.

      • To view the optional account fields that will be assigned to a new account, highlight the account, then click the Optional Fields button to open the new Preview Account Optional Fields window.
      • To view the transaction details optional fields to be assigned to a new account, highlight the account, then click the Trans. Opt. Fields button to open the Preview Account Transaction Optional Fields window.Use

      the optional fields preview windows to add or delete the optional fields and to change the default values that display. Note that you can add only optional fields that are defined for General Ledger.

  8. To print the preview information, click Print. The Print Create Accounts Preview Information window opens.
    1. Choose sorting options and the range of accounts you want to print. You can sort by Account Number, Segment, or Account Group.
    2. Select whether you want to print subledger or currency information.
    3. Click Print.
    4. Click Close to return to the G/L Create Accounts Preview window.
  9. When you have finished selecting or adjusting the accounts you want to create, click Close to return to the G/L Create Accounts window. In the G/L Create Accounts window, all the fields are now dimmed - you cannot change them. (However, you can click Preview to return to the Preview window.)
  10. Click Process to add the accounts to your chart of accounts.
    • If processing is successful, the program creates the accounts, then displays a message telling you processing has finished and the number of new accounts that were created.
    • Click Close to close the message. You then receive a message asking whether you want to clear the temporary file. You must clear the preview accounts before you can create another set of accounts. If you click No, you are returned to the G/L Create Accounts window, but (as before) all the fields are dimmed.
    • If there is an error in processing the accounts, you are returned to the G/L Create Accounts window, but all fields are dimmed. Click Preview to view and remove any unsuitable accounts, or click Clear to abort the process. Note that some accounts may have been added to your Chart of Accounts.
  11. Click Clear to delete the temporary file so that you can create a different set of accounts in the future.