Show/Hide All

 Overview

The combination of a main account and subaccounts creates a general ledger account. Use this procedure to create new accounts for a selected main account by copying information from existing accounts.

 Before You Begin

• You must have at least one main account defined for the main account segment, and each account segment after the main account segment must have at least one subaccount defined for it. Also, you must have at least one existing account.

 

To create an account using a main account and existing accounts

1. Select General Ledger Setup menu > Main Account Maintenance.

2. In the Main Account field, select the main account to use as the basis for creating new accounts. For more information, see Main Account Maintenance - Fields.

3. Click Copy.

4. In the Copy Accounts window, the selected main account displays and each account segment description appears in the Select Field column. For more information, see Copy Accounts - Fields.

5. For each account segment in the Select Field column, select an operand and value  for copying account information.

Note Only those accounts that match the entered ranges are used with the selected main account to create new accounts.

6. Click Proceed.

Note  After accounts are created for the selected main account, the main account cannot be deleted.

New accounts are created by replacing the value of the main account in the selected existing accounts with the main account selected in Main Account Maintenance.

The accounts created inherit the following values of the main account:

• Account Group

• Account Category

• Clear Balance setting (if the account is a non-financial account)

• Assigned Rollup Codes

If the main account or any subaccounts used to create the new general ledger account have a status of inactive, the new account's status is inactive. In addition, during the creation process, the system compares the start and end date values of the main account and subaccounts, determines the most restrictive start and end dates, and assigns these dates to the new general ledger account.

 

 Example - Creating accounts based on a main account and existing accounts

The following is a partial list of existing accounts used to illustrate how to create accounts based on a main account and existing accounts. The account structure is "main: city-location-product line-department."

Account Number	Account Description
40000-01-000-010-100	Desk Sales: Irvine-Main-Steelcase-Sales
40000-01-000-010-200	Desk Sales: Irvine-Main-Steelcase-Marketing
40000-01-000-020-100	Desk Sales: Irvine-Main-Miller-Sales
40000-02-000-010-100	Desk Sales: Atlanta-Main-Steelcase-Sales
40000-02-000-020-100	Desk Sales: Atlanta-Main-Miller-Sales
40200-01-000-010-100	Chair Sales: Irvine-Main-Steelcase-Sales
40200-01-000-020-100	Chair Sales: Irvine-Main-Miller-Sales
40300-01-000-010-100	Lighting Sales: Irvine-Main-Steelcase-Sales
40300-01-000-020-100	Lighting Sales: Irvine-Main-Miller-Sales

You added a new main account 40400 (Cabinet Sales). You can create new accounts based on the existing accounts and the new main account 40400. To create new accounts based on existing accounts for main accounts between 4000-40999, all cities, all locations, and all departments for the new main account 40400, enter the following information in the Copy Accounts window.

Select Field	Operand	Values
Main:	Range	40000-40999
City:	All
Location:	All
Product Line:	All
Department	All

Using the existing accounts listed previously, the following new accounts are created:

Account Number	Account Description
40400-01-000-010-100	Cabinet Sales: Irvine-Main-Steelcase-Sales
40400-01-000-010-200	Cabinet Sales: Irvine-Main-Steelcase-Marketing
40400-01-000-020-100	Cabinet Sales: Irvine-Main-Miller-Sales
40400-02-000-010-100	Cabinet Sales: Atlanta-Main-Steelcase-Sales
40400-02-000-020-100	Cabinet Sales: Atlanta-Main-Miller-Sales

These accounts were created by replacing the first segment of all existing accounts listed with 40400. Any duplicates encountered were ignored.

 

 Example - Creating accounts based on a main account and existing accounts

The following is a partial list of existing accounts used to illustrate how to create accounts based on a main account and existing accounts. The account structure is "main: city-location-product line-department."

Account Number	Account Description
40000-01-000-010-100	Desk Sales: Irvine-Main-Steelcase-Sales
40000-01-000-010-200	Desk Sales: Irvine-Main-Steelcase-Marketing
40000-01-000-020-100	Desk Sales: Irvine-Main-Miller-Sales
40000-02-000-010-100	Desk Sales: Atlanta-Main-Steelcase-Sales
40000-02-000-020-100	Desk Sales: Atlanta-Main-Miller-Sales
40200-01-000-010-100	Chair Sales: Irvine-Main-Steelcase-Sales
40200-01-000-020-100	Chair Sales: Irvine-Main-Miller-Sales
40300-01-000-010-100	Lighting Sales: Irvine-Main-Steelcase-Sales
40300-01-000-020-100	Lighting Sales: Irvine-Main-Miller-Sales

To create new accounts for main account 40400 by copying accounts that only exist for main accounts between 40000-40999, all cities, all locations, but only for product line 010 and department 100, enter the following information in the Copy Accounts window.

Select Field	Operand	Value
Main:	Range	40000-40999
City:	All
Location:	All
Product Line:	Equal To	010
Department:	Equal To	100

Using the existing accounts listed previously, the following new accounts are created:

Account Number	Account Description
40400-01-000-010-100	Cabinet Sales: Irvine-Main-Steelcase-Sales
40400-02-000-010-100	Cabinet Sales: Atlanta-Main-Steelcase-Sales