Ledgers
A ledger features setup data associated with a chart of accounts.
The ledger qualifies the general and/or analytical accounting type and contains the management rules connected with the matching and the end-of-year rules.
For general ledgers, the chart of accounts to be used needs to be associated with the ledger. For analytical ledgers (whether they are only analytical or not), dimension types also need to be indicated. A same dimension type code can be used in various ledgers belonging or not to the same model.
A general and analytical chart of accounts can be used in a ledger that is only general, only analytical, or both.
If a link to X3 accounting has been defined in Sage X3 People (Folders (GESADS), Links tab), the function cannot be accessed from Sage X3 People. If you try to access the function, the following warning message is displayed: "This object is managed in X3". From Sage X3 People, you can select the values coming from the X3 folder: analytical dimension, account, etc.
If there is no active link to the X3 accounting, the function can be accessed in Sage X3 People and the data is stored in the Sage X3 People folder.
Prerequisites
Refer to documentation Implementation
Screen management
Entry screen
Block number 1
Ledger (field LED) |
This field displays the code for the current ledger. |
Description (field DESTRA) |
Common title of the current record. |
Identification
Short description (field SHOTRA) |
The short description replaces the standard description when display or print constraints require it. By default the short title, the long title or the column header of a data are recorded (on creation/update) in the connection language of the user.
A user who logs on with this language will view the short description, long description or column header in their connection language if a translation exists. Otherwise, these descriptions will be available in the folder language. The connection language must be defined as a default language for thefolder. |
Legislation (field LEG) |
In multi-legislated folders (where the LEG activity code is active), the Legislation fields are displayed.
If a legislation is entered in the record header, other fields entered must follow any rules applicable to the legislation. If a legislation is not entered in the record header, it might be deduced from another element (such as the company, site, or employee) and again, other fields entered must follow any rules applicable to the legislation. If a multi-legislation group of companies is selected, other fields entered must follow any rules applicable to the legislation of at least one company in the group. Example If you select a group of British (BRI) and French (FRA) legislation companies, you cannot enter a value in a field that is only applicable to the South African (ZAF) legislation. In single legislation folders (where the LEG activity code is not active), the Legislation fields are not displayed. |
Type of accounting
General (field GEN) |
The account core model must necessarily have a general ledger. If the ledger being created is a general ledger, the accounting types Budget, Operating budgets and Commitments cannot be accessed. |
Analytical (field ANA) |
The main analytical ledger must be checked to 'Analytical'. A general ledger can also be checked as 'Analytical'. |
Budget (field BUD) |
A ledger can only manage budgets if it is an analytical ledger. When generating commitments/precommitments, if a manual ledger is associated with an automatic ledger, only the manual ledger is updated. |
Operating budgets (field GDD) |
A ledger can only manage operating budgets if it is an analytical ledger. |
Commitment (field CMM) |
A ledger can manage an account management of type 'Commitments' only if the ledger is analytical. Upon generation of commitments/precommitments, when a manual ledger is associated with an automatic ledger, only the manual ledger is updated. |
Project management (field PJMFLG) |
Click this check box to define this ledger as a Project management ledger.
To track Project management costs analytically at the account core model level, the following conditions must be met:
|
Consolidation (field CSL) |
Select this check box to allow consolidation management. An accounting core model can have several ledgers with this type of accounting. |
Ledger type (field LEDTYPE) |
CoA and dimension types
Chart code (field COA) |
Specify in this field the chart of accounts associated with the ledger. |
No. of dim. types (field DIENBR) |
Specify the number of dimension views of the current ledger. |
field DIE |
Enter the code of the dimension types of the current ledger. |
Management
Balance (field BAL) |
In a journal, the balance represents equal debits and credits in the transaction currency, irrespective of the site. |
Balance by site (field FCYBAL) |
If the chosen balance is to be considered by site, the journal must be balanced site by site. This balance is obtained by using the link accounts defined in the chart of accounts if the need arises. |
Matching (field MTCFLG) |
All general and/or analytical accounts can use matching. |
One dimension required (field DIEDACOBY) |
When this box is checked, it will be mandatory, for instance when entering an entry, to assign at least one dimension view for this ledger. |
Store lines without dimensions (field DIEIPT) |
This option can only be accessed if the option Mandatory dimension view entry is not checked. |
Fiscal year end
Generation type (field GENTYP) |
This option is used within the framework of the fiscal year-end process and it can take the following values:
The fiscal year-end processing function generates at least this Carry Forward Entry journal (GAUFIYEN setup). |
Balanced carryforward (field EQLRANANA) |
If the box balanced CFE is checked, in addition to the carry-forward entry journal, the processing will generate a result establishment entry (GAUFIYRE parameter). For a General Accounting ledger, the balanced CFE is requested. |
Closing document (field ENDVCR) |
When the Closing journal checkbox is checked, a closure document for all accounts is created on the last day of the fiscal year. If the ledger is a general and analytical ledger, the journal closes all accounts and their analytical balances. The automatic journal used to generate the closing entry is determined by means of the GAUFIYCL parameter. |
One entry per account (field ACCVCR) |
When a closing journal will be generated, the fiscal year end processing is likely to create:
When this box is checked, the program will create a closing journal by account. |
Error messages
In addition to the generic error messages, the following messages can appear during the entry :
At least one dimension type must be entered
Chart of accounts incompatible
Impossible to change the chart of accounts or the dimension types
This message displays when a movement is saved for the ledger under modification.