About Segment Codes Setup

See the instructions for setup for the Sage X3 G/L and Sage 100 integration.

This window lets you:

  • Enter a list of valid segment codes for each of the segments you use in account numbers (other than the account segment).
  • Assign a separate retained earnings account for each segment code in the table.

For example, if your account numbers include a department segment, you would use the Segment Codes table to enter the codes and descriptions of each of the departments in your company.

And, if you close income and expense accounts at Year-End by department, you could specify a separate retained earnings account for each department code you add.

How General Ledger uses segment codes

When you add General Ledger account numbers in the G/L Accounts window, the program checks the Segment Codes table to be sure that the segment codes (such as the department numbers) are valid. If a segment code is not valid, General Ledger will not let you add the account. The only segment that is not validated is the account segment.

Adding Segment Codes

Before you start

  • Define the account number segments on the Segments tab of the G/L Options window.
  • List all the codes that are valid for each of the account segments (such as all the department codes). Each code must contain the number of characters specified for the segment on the G/L Options window.
  • For each segment code that closes to a retained earnings account, list the account number of the retained earnings account it uses.

To add segment codes

  1. From the Navigation Pane, go to Setup > Payroll > General Ledger > Segment Codes.
  2. Choose the segment from the drop-down box for which you want to enter valid codes.
    • If you are entering codes for the first time, click in the empty field below the segment selection field (or press Tab twice) to insert the first line in the table.
    • If editing an existing list of codes, click on the line you wish to change (use the vertical scroll bar if the record is not visible), or click in the table and press the Insert key to add a code.
  3. Enter or change the code in the Segment Code column. The code must be the length you specified for the segment.
  4. Press Tab and enter a description.
  5. Press Tab again, and, if applicable, enter the account number of the retained earnings account to which this segment code closes. If this account has the Post To Account field set as Prohibited, you cannot select that account as the closing account.
  6. When you have added all the codes for a segment, click Save.
  7. Print the Segment Codes report from the G/L Reports folder. This report lists the valid codes for each segment and shows the related description and retained earnings account, if any.

Deleting segment codes

You cannot delete a segment code that is being used by an active account.

To delete a line from the segment codes table, select the segment, then select the particular code you want to delete, and press the Delete key.

Additional information

  • The Segment Codes table lists all the valid codes for each account number segment that is defined in the G/L Options window (except the account segment).
  • Do not use the delimiter characters, dash, forward slash, backward slash, star, and period (- / \ * . ) in a segment code.
  • You can assign a different retained earnings account to each code entered for a segment that you use for closing. If you do not enter a retained earnings account for a segment code that you use for closing, G/L closes to the default closing account specified on the Account tab of the G/L Options window.
  • There is no limit to the number of codes that can be valid for each account number segment.