G/L Options Screen

Sage 300 ERP

Home > Screen Guides > Setup > Options

G/L Options Screen

Open General Ledger > G/L Setup >  Options.

On this tab, you specify settings that determine how accounts are processed in General Ledger.

Generally, you change account settings only after year-end closing.

If you selected the G/L Security option, you can set the default account access to:

  • All Accounts. Allows all Sage 300 ERP users unrestricted access to General Ledger accounts unless you use the G/L Account Permissions screen to set up restrictions.
  • No Accounts. Prevents all Sage 300 ERP users except user ADMIN from seeing accounts and account data in General Ledger and subledger applications unless you use the G/L Account Permissions screen to grant individual access rights to accounts.

    Note: If you select No Accounts, other Sage 300 ERP users cannot enter Accounts Receivable invoices or post transactions unless you assign them permissions.

For more information, see About General Ledger Security and G/L Account Permissions Screen.

This is the account to which the G/L Create New Year screen closes all income and expense accounts that are not specifically assigned to another retained earnings account.

If you use multi-segment account numbers, you can close income and expense accounts by segments, and assign a separate retained earnings account to each segment code, using the G/L Segment Codes screen.

For example, you can do year-end closing by the department segment, and assign a different retained earnings account to each department in your company. If any department lacks a retained earnings account, General Ledger uses the default account you enter on the Account tab of the G/L Options screen.

You can change the default closing account before or after doing year-end closing.

Note: Before you can enter a default closing account, you must set up the chart of accounts. If the Post To Account field is set to Prohibited for an account, you cannot select that account as the default closing account.

If you selected the Multicurrency option, you must also select the type of exchange rate (such as a spot rate or weekly rate) you use most often when converting source currencies to functional currency during transaction entry.

You select the default rate type for General Ledger on the Account tab of the G/L Options screen. You define currencies, rate types, rate tables and exchange rates using the Common Services Currency screens.

You can change the default rate type at any time, and use a different rate type when you enter a transaction.

Functional currency is the currency in which your company keeps its books (also known as the base currency or home currency). The functional currency is usually the currency used in the country where your business has its headquarters.

In Common Services:

  • You use the Company Profile screen to specify the functional currency for the company.
  • You use the Currency Codes screen to define currency codes for the company.

Important! After you select this option, you cannot clear it.

Select this option if you will post quantities (for example, number of pounds, kilograms, shares of stock, or other units of measure), as well as monetary amounts, to your accounts.

When you select this option, you must also enter the largest number of decimal places (up to three) used in any of the units of measure in which you post quantities. Financial and budget information is always stored with the same number of decimal places. This number is determined by the functional (home) currency you define for the company.

After selecting the option, use the Detail tab of the G/L Accounts screen to assign a unit of measure to each account for which you plan to keep quantities. You can then enter and post quantities with monetary transactions for the accounts.

With each account that uses quantities, General Ledger keeps a quantity balance and net change in quantity for each fiscal period, as well as a monetary balance and net change. You can provisionally post quantities as well as monetary amounts.

Important! After you select this option, you cannot clear it.

If you specified multicurrency processing for the company (on the Company Profile screen in Common Services), select this option to use multicurrency accounting for your General Ledger data files.

A multicurrency ledger allows you to enter, import, post, store, and report transactions in more than one currency.

Note: On the G/L Accounts screen, you must select the Multicurrency option for each account that you want to keep separate source currency balances.

This field appears if you selected euro as your functional currency and specified a reporting currency (on the Company Profile screen in Common Services).

You specify a rounding account to ensure that journal entries entered in the reporting currency balance during posting.

Select this option to classify General Ledger accounts using standard groupings such as Cash and Cash Equivalents, Fixed Assets, Cost of Sales, and so on.

If you select this option, you must assign an account group to each account that you add to your ledger.

Note: You must select this option to use the Income Statement and Balance Sheet snapshots in the Sage 300 ERP Portal, or to use the sample reports that come with Financial Reporter. The snapshots and the sample reports rely on the standard set of account groups that come with General Ledger. However, you can use account groups even if you do not use Financial Reporter's standard financial statements or snapshots.

Select this option to grant account level security for your general ledger accounts.

You can assign account access rights to individual users to control which accounts they can view and work with, helping you minimize the risk of unauthorized activities.

You can block off entire account segments or only the most sensitive accounts (for example, Payroll, Sales, Retained Earnings, Common Stock and Preferred Stock).

For more information, see About General Ledger Security.

On this tab, you specify the contact name, telephone number, and fax number for General Ledger.

To change the company name and address, or to change the contact name, telephone number, and fax number at the company level, use the Company Profile screen in Common Services.

On this tab, you specify General Ledger posting options. You can change the options specified here at any time.

Select this option if you want to allow batches to be posted to previous years.

Because you can select or clear this option at any time, you might want to leave it off to ensure that you do not accidentally post to a prior year, such as when you enter an incorrect transaction date.

However, there are some circumstances under which it should be allowed. For example, you may need to post to a prior year to:

  • Enter the last year's closing account balances when you create the General Ledger database in order to set up opening balances for the current year and to enter historical data.
  • Correct errors in prior-year figures.
  • Enter adjustments for a prior year after the year is closed.

Note: General Ledger can post only to an active fiscal year. Fiscal years are set to Active on the Fiscal Calendar screen in Common Services.

Provisional posting is temporary posting. If you select this option, General Ledger lets you post transactions to accounts and produce financial reports that include the provisionally posted transactions.

At a later time, you can discard or edit provisionally posted transactions if necessary, and you can post them again—either provisionally or permanently.

For more information, see About Provisional Posting.

Specify the source code to use as the default on the G/L Journal Entry screen.

Specify the information that General Ledger users can edit in transactions in imported batches (batches created in a non-Sage 300 ERP program, and then imported).

You can allow editing of the following information:

  • All fields
  • Only fiscal year, period, and transaction date
  • No editing

Select this option if you want to strengthen your audit trail.

If you select this option:

  • You must print a listing of each batch and each batch must be free of errors before you can post it.
  • If you edit a batch, you must print another listing of it before posting. You can print batch listings to the print destinations available to you.

If you do not select this option, you can still list a batch before processing it, but the listing is optional.

Specify the number of years (prior to the current year) for which you want to save period balances and net changes for accounts.

Depending on the edition of Sage 300 ERP you use, you can maintain from 7 to 99 years of history, depending on your business requirements and data storage capacity.

When you perform Period End Maintenance, fiscal sets older than the number of years specified are deleted. The G/L Period End Maintenance screen gives you the option of deleting fiscal period balances and net changes that are older than this number of years.

Specify the number of years (prior to the current year) for which you want to keep posted transaction history.

The number of years for which you keep detail must not exceed the number in the Years Of Fiscal Sets field.

If you use Sage 300 Premium ERP, you can keep up to 99 years of transaction detail and fiscal sets. If you use Sage 300 Standard ERP or Sage 300 Advanced ERP, you can keep up to 7 years of transaction detail and fiscal sets.

When you perform Period End Maintenance, transaction details older than the number of years specified are deleted. The G/L Period End Maintenance screen gives you the option of deleting transaction details that are older than this number of years.

Select a budget set if you want to prevent users from entering, deleting, or changing amounts. You can lock a set to prevent anyone from entering budget data into a fiscal set you decided not to use. Or you may want to lock the fiscal set that contains your original budget after the figures for all the accounts are entered.

If you use Sage 300 Premium ERP, you can create up to five sets of budgets for each General Ledger account. (If you use Sage 300 Standard ERP, you can create 2 budget sets; if you use Sage 300 Advanced ERP, you can create 3 budget sets.)

A Budget fiscal set can be locked or unlocked at any time. Locking a Budget fiscal set does not delete it; budget information is saved for the number of years specified in the Years Of Fiscal Sets field on the Posting tab of the G/L Options screen.

On this tab, you identify account number segments to specify which portions of the account number can be used to close the income and expense accounts at year end.

Select the account segment for which you will specify additional information.

For more information, see About Account Segments.

Select the account number structure used most often in your General Ledger account numbers. For example, If you have two account number segments, and most of your account numbers use both segments, you would enter the code for the account number structure that includes both segments.

The default structure code you specify appears on the Detail tab of the G/L Accounts screen when you are adding new accounts, and specifies the format of the account number, unless you assign a different structure.

Use the G/L Account Structures screen to define the account number structures you want to use with General Ledger.

Select the character that will separate the different segments of the account number.

When you enter account numbers throughout the program, you can type the delimiter characters yourself, or let General Ledger automatically insert them for you.

Valid delimiters are - / \ . *

Specify a length from 1 to 15 characters for the segment (excluding the delimiter characters).

Enter a name of up to 60 characters (such as Account, Division, or Region) for the segment.

General Ledger assigns a number to each segment you define.

For each segment you use, you must provide a description, specify length, and specify whether to close income and expense accounts at year end by this segment (for example, by department).

The number of account segments you can have (7 or 10) depends on the Sage 300 ERP edition you use.

You can close different income and expense accounts at year end to different retained earnings accounts.

If you have more than one account segment, the method for closing to different retained earnings accounts is as follows:

  • G/L Options screen. Specify that a segment is used in closing.
  • G/L Segment Codes screen. Define the valid codes (such as department codes) for a segment, then specify the retained earnings account for each code.
  • G/L Accounts screen. Specify the segment you use for closing each account in the account record.

Overview

After setting up your general ledger, you use the G/L Options screen to:

  • Add or change the contact name, telephone number, and fax number for your general ledger.
  • Specify account settings, such as multicurrency, account groups, and default closing account.
  • Turn on G/L Security and specify the default user access to General Ledger accounts.
  • Specify a default source code for journal entries.
  • Specify options for posting, budget sets, history, and statistics.
  • Set up account segments.

Account Tab

On this tab, you specify settings that determine how accounts are processed in General Ledger.

Generally, you change account settings only after year-end closing.

Company Tab

On this tab, you specify the contact name, telephone number, and fax number for General Ledger.

To change the company name and address, or to change the contact name, telephone number, and fax number at the company level, use the Company Profile screen in Common Services.

Note: The Multicurrency option appears on this tab only if you select the Multicurrency option on the Company Profile in Common Services.

Posting Tab

On this tab, you specify General Ledger posting options. You can change the options specified here at any time.

You can:

  • View and change the default budgeting, batch-editing, and posting settings for General Ledger.
  • View the posting information that is maintained by General Ledger.
  • Specify a source code to use as the default for journal entries.

This tab also displays statistical information about batch posting activity for the current fiscal year.

Segments Tab

On this tab, you identify account number segments to specify which portions of the account number can be used to close the income and expense accounts at year end.

You can:

  • Specify the structure code that appears as the default when you add new accounts.
  • Specify during setup which segment in your account numbers represents the account code. You cannot change this setting later.
  • Specify during setup which character you use to separate account segments. (You cannot change this delimiter later.)
  • Define the segments (divisions or portions) you use in your General Ledger account numbers.
Related Topics