Maintain ledgers

CUSTADMIN access only

Some Of the nominals and ledgers used in this topic may be different to those in your chart of accounts.

You rarely need a new ledger, because the installation process creates and sets up the existing ledgers. The following example shows how to create a new ledger, using a School Fund ledger. The following sections then show how to add or edit ledger properties.

Create or edit a ledger

  1. Select Maintenance, then select Ledgers from the menu.
  2. The Ledger Maintenance window opens. Select ADD NEW, then select LEDGER.
  3. A <New item> appears in the left-hand panel and automatically selected. Enter a code for the ledger (limited to 12 characters) in Ledger.
  4. Enter a title to help identify the ledger in Title.
  5. Next, enter the required details to create a ledger, as described in the following sections.
  6. When you have completed all the required ledger settings, select SAVE.

Specify ledger types

On the General tab, select the type of ledger from the Type list. This determines how the system uses the ledger. The following options are available:

OPTION

DESCRIPTION

Sales

Select this option if you use the ledger for sales accounts that include customer names and addresses.

Purchase

Select this option if you use the ledger for supplier accounts that include supplier names and addresses.

Assets

Select this option if you use the ledger to record assets.

Analysis

Select this option if you use the ledger to record analysis records.

VAT Multiple

VAT Single

Select the applicable option based on whether each ledger account is a VAT Period for a multiple or single rate system.

Subcontract

Select this option if you use the ledger for subcontractor accounts that include names and addresses.

Define the initial state of documents posted to a ledger

On the General tab, select the initial state of documents posted to the ledger from the Initial State list.

Changing the Initial State of an existing ledger affects all the accounts in the ledger. However, individual accounts can later have their status amended as required.

These options are available:

OPTION

DESCRIPTION

Null

Documents posted to this ledger are not available for allocation.

Open

Documents posted to this ledger are available for allocation (recommended option).

Hold

Documents posted to this ledger have Hold status and are unable to be allocated/paid until they have been moved.

Open External

Only selected for bank ledgers.

Apply account code restrictions

By default, the system applies no restrictions when a user creates an account for this ledger.

On the Settings tab, in the Account range panel, you can specify restrictions for accounts created within the ledger.

Select Unique if any account code entered when creating an account on the ledger must fall within the specified range in From and To.

Enter the range of codes in From and To, for example, A001 - Z100.

Apply ledger validation

On the Settings tab, in the Account Settings panel, you can specify a validation pattern for account codes linked to the ledger, and decide whether users must enter payment terms and bank details when they create accounts.

By default, the system validates the account code so that it contains three characters, followed by up to 9 numbers, followed by three characters.

If required, you can amend the validation of this code to force certain letter/number combinations to suit your needs.

The validation is determined using a regular expression (a sequence of characters that define a search pattern). For more information, search online for regular expressions.

The default expressions for the account code is as follows:

^[A-Z,0-9]{3}[0-9]{3}[A-Z]{3}

The following table lists typical expressions that you can combine to define the validation of the account code. You can combine one or more options by separating each one with a space.

EXPRESSION

DESCRIPTION

/^

Defines the start of the string.

(?=.*[A-z])

Must contain one lowercase or uppercase character.

(?=.*[a-z])

Must contain one lowercase character.

(?=.*[A-Z])

Must contain one uppercase character.

(?=.*[0-9])

Must contain one digit from 0-9.

(?=.*[$@])

Must contain one special character from the list you define in the square brackets [] - in this example the $ and the @ symbol.

\S{6,12}

The code must have a minimum of 6 characters and a maximum of 12. You can change the numbers in the expression to match the minimum and maximum number of characters you need.

$/

Defines the end of the string.

Combining these expressions into a string then determines the minimum requirements of the account code (the expressions can be in any order).

In Pattern, enter any expression that you want to set for the account code. Users must follow it when they create an account on the ledger.

Bank details required - (applicable to SALES and PURCHASE ledgers only) select to make entering bank details mandatory when creating an account for this ledger.

Payment terms required - (applicable to SALES and PURCHASE ledgers only) select to make entering payment terms mandatory when creating an account for this ledger.

Specify the allocation write off

On the Settings tab, in the Allocation Write Off panel you can managed the way the allocation of any values to be written of are handled.

These options are available:

OPTION

DESCRIPTION

Write-off limit

Enter the limit that you can write off in a normal allocation, for example, 5.00. Do not enter any currency symbols, such as £ or $. The system applies this value to both credit and debit entries.

Write-off document

Select the type of document to use for writing off entries. Select Drill (...), then double-click the required document type, that is, ASWO - Write Off (where AS represents the location code of the document) from the Select a document type dialog.

Currency document

Select the document to use for writing off the difference that occurs when the account sums to zero in the account currency but does not sum to zero in the home currency. Select Drill (...), then double-click the required document type, that is, ASGJ - Journal (where AS represents the location code of the document) from the Select a document type dialog.

Specify ledger security

This guidance is only for IRIS Financials Version 7.0.2103 or earlier. If using version 7.0.2223 or later, go to Set security in maintenance screens.

On the Security tab, you can specify the security settings for ledgers. For more information, refer to Overview of Security Roles.

Select Drill (...) in any of the Security fields, then double-click the security role required from the Select a role for dialog. For more information, refer to Applying Security to a Ledger.

Set ledger access levels

By default, the system sets the Access level for a new ledger to 3. You can increase this number to restrict access to the ledger.

Input allowed is selected by default. Deselect it only if you want to prevent users from posting documents to this ledger.

For more information, refer to Applying Security to a Ledger.

Find the nominals linked to a ledger

When a ledger is first created, no nominals are linked to the ledger. When you link a nominal to a ledger, users must select an account from the ledger whenever they select the nominal. For more information, refer to Creating a Nominal.

Create payment/discount terms

For more information, refer to Create or edit payment and discount terms.

Related Topics

  1. Hide ledgers no longer required
  2. Produce a ledger list
  3. Add analysis fields to a ledger
  4. Change the nominal linked to a ledger