You use this program to configure a template that you can use to structure your General Ledger codes.
The program enables you to:
Enabling section analysis, budget analysis and purchase commitment analysis allow you to use the GL Structure Query program to query the balances according to the defined sections.
Field | Description | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|
Structure options | |||||||||||
G/L structure required | Enables the General Ledger structure definition system and allows you to define the structure you require for your General Ledger codes. | ||||||||||
Edit structure |
Select this to change the General Ledger code structure. This option only applies once you have defined a structure. It is not advisable to change a structure once it has been defined. |
||||||||||
Number of sections required |
Indicate the number of sections you want to define for your General Ledger code. For example, if you want to structure your GL code to consist of a branch section, a department section and a ledger account number (code) section, then you enter 3 in this field. |
||||||||||
Analysis options | If you select any of these options, you must use the
Rebuild Analysis function to
build/rebuild the data in the analysis
files.
|
||||||||||
Structure definition |
Allows you to describe how the General Ledger account code is constructed. Structured General Ledger codes can have up to 9 sections.
|
||||||||||
Section |
This indicates the section number. The number of sections enabled depend on the value entered in the Number of sections required field. Each enabled section must be defined before you can save the entire structure. |
||||||||||
Description | Enter the description for the section number. | ||||||||||
Position |
This is automatically updated by the system. Section 1 always commences in position 1. Thereafter, the start position for Section 2 is determined by the Length defined for Section 1 plus the Separator character, if defined. |
||||||||||
Length |
Indicate the number of characters that make up the section. This value cannot be zero. |
||||||||||
Characters allowed | Indicate the type of characters allowed in the
section.
|
||||||||||
Separator required |
Select this to define a character to separate this section from the next section in the ledger code construct. Each separator takes up one character position in the account structure. |
||||||||||
Separator |
Indicate the separator character for the section. Any character can be used. To define the separator as a space, select the Separator required option and then leave this field blank. This field is only enabled if you indicated that a separator is required. |
||||||||||
G/L code section |
Select this to set this section as the General Ledger account number portion of the full ledger code. Only one section can be defined as being the GL code section. |
||||||||||
Maintain | Enables you to define the permissible values for the section. | ||||||||||
Relationships |
Enables you to define the valid sub-sections within each section. No relationships can be defined against the lowest section (the last section number defined) as it has no sub-sections. |
||||||||||
Access | Select this to use the GL Structure Access Maintenance program to define the access rights for operators to post to and/or query the ledger codes. | ||||||||||
Rebuild Analysis |
Rebuilds your General Ledger analysis history tables/files based on your existing General Ledger history and budget tables/files. This only applies if you selected the option Section analysis required. |
||||||||||
Save | Select this to save the information you entered. | ||||||||||
Close | Select this to exit the program. |
You use this function to define the permissible values for each section.
For example:
If your company has three locations (i.e. JNB, LON, and NY) then you could define a section called Location. When you maintain the Location section, you add the values JNB, LON and NY. These are then the only permissible values for the Location section of the account code.
When you select this function, a listview displays the permissible values already defined for the section.
One screen is displayed for sections not defined as the GL code section and a different screen is displayed to maintain the section defined as the GL code section.
This is displayed when you select the Maintain function for a section not defined as the GL code section.
Field | Description | ||||
---|---|---|---|---|---|
Section | This indicates the section description for which you are maintaining the permissible values. | ||||
Change | Select this to change the ledger code template for the highlighted entry. | ||||
Section description (user-defined) |
The description for this field is the description you defined for the section. This indicates a valid value for the section. |
||||
Description | Enter the full description for the value displayed in the previous field. | ||||
Ledger code tag |
Enables you to automatically build the description for the ledger code (General Ledger Codes). When a General Ledger code is created, the description for the ledger code is made up of the descriptions for the valid values of the sections. |
||||
Save | Select this to save the information you entered. | ||||
Cancel | Select this to ignore the information entered for the current value and return to the previous screen. | ||||
Add | Select this to add the values allowed for this section. | ||||
Section description (user-defined) |
The description for this field is the description you defined for the section. Enter a valid value for the section. |
||||
Description | Enter the description for the value entered in the previous field. | ||||
Ledger code tag | The ledger code tag enables you to automatically build the description for the ledger code (General Ledger Codes). | ||||
Save & Close | Save the information entered and returns to the previous screen. | ||||
Save | Saves the information entered without returning to the previous screen. | ||||
Cancel | Ignores the information entered for the current value and returns to the previous screen. | ||||
Delete |
Immediately deletes a permissible value assigned to a section. You cannot delete a section if a ledger code containing the section is already defined (General Ledger Codes). |
||||
Create Sections |
Creates new section codes from your existing ledger codes. The program reads your current General Ledger codes and creates the required sections, together with their separators according to the structure you defined.
|
||||
Close | Returns to the previous screen. The changes you made are automatically saved. |
This is displayed when you select the Maintain function for the section defined as the GL code section.
Field | Description | ||||
---|---|---|---|---|---|
Section | Indicates the ledger code and description for which you are maintaining the permissible values. | ||||
Change | Select this to change the ledger code template for the highlighted entry. | ||||
Add | Select this to add account codes. | ||||
Delete | Use this to immediately delete the template for an account code. | ||||
Create Sections |
Select this to create new section codes from your existing ledger codes (i.e. The ledger codes previously defined using the General Ledger Codes program). The program reads your current General Ledger codes and creates the required sections, together with their separators according to the structure you defined.
|
||||
Close | Returns you to the previous screen. The changes made are automatically saved. |
This is displayed when you select the Add or the Change functions.
Field | Description | ||||||||
---|---|---|---|---|---|---|---|---|---|
Account code | This is the description you defined for the account code section. | ||||||||
Description |
Indicates the description for the Account code. This is displayed throughout the SYSPRO system whenever the ledger code is entered. Only ledger codes created after the description is changed will indicate the new description. Existing ledger code descriptions are not changed. |
||||||||
Group |
Assign the ledger account to a specific ledger group. This provides you with an alternative method of grouping your accounts (other than by account type). It can also be used as a selection and sequencing tool for viewing and printing your ledger accounts. General Ledger Group codes are defined using the GL Groups program. |
||||||||
Tax code |
This entry determines the default tax code assigned to each distribution entry posted from either the AP Invoice Posting program, or the withdrawal function of the Deposits and Withdrawals program. If left blank, then the Deposits and Withdrawals program uses the Default tax codes defined on the Tax tab of the Cash Book Setup program. The Descriptive tax code must be used if defined (Descriptive Tax Codes). In the AP Invoice Posting program, the tax code you entered when processing the Transaction Details is used if the tax code against the ledger code is blank. If the tax code against the ledger code is blank, then the Default tax code defined on the Tax tab of the Accounts Payable Setup program is used. |
||||||||
QST code |
This is displayed if the option: Second tier tax is set to Required (Accounts Payable Setup - Tax tab). This entry determines the default second tier tax code assigned to each distribution entry posted from the AP Invoice Posting program. The tax code can be left blank. If left blank, then the tax code you entered when capturing the Transaction Details is used. Only if that tax code is also blank does is the Default tax code defined on the Tax tab of the Accounts Payable Setup program used. |
||||||||
Revaluation category |
This relates to alternate currency ledgers only. Indicate a revaluation category for the ledger code. Revaluation categories determine how the transactions in the ledger code must be revalued when you select the GL Alternate Currency Valuation program. |
||||||||
Account type |
Classify your ledger codes, providing for balancing controls and flexible reporting.
|
||||||||
Asset |
Select this to define this account code as an asset account. Asset account types are balance sheet accounts and their balances are therefore not transferred to the Retained Earnings account when a Year end is performed (GL Period End). |
||||||||
Capital |
Select this to define this account code as a capital account. Capital account types are balance sheet accounts and their balances are therefore not transferred to the Retained Earnings account when a Year end is performed (GL Period End). |
||||||||
Liability |
Select this to define this account code as a liability account. Liability account types are balance sheet accounts and their balances are therefore not transferred to the Retained Earnings account when a Year end is performed (GL Period End). |
||||||||
Revenue |
Select this to define this account code as a revenue account. Revenue account types are Income Statement (Profit and Loss) accounts. When a year end is performed, (GL Period End), you can select the option Set expense and revenue accounts to zero, to automatically transfer the balances in these account types to the Retained earnings account defined against the company (Company Maintenance - General tab). |
||||||||
Expense |
Select this to define this account code as an expense account. Expense account types are Income Statement (Profit and Loss) accounts. When a year end is performed, (GL Period End), you can select the option "Set expense and revenue accounts to zero", to automatically transfer the balances in these account types to the Retained earnings account defined against the company (Company Maintenance - General tab). |
||||||||
Statistical |
Select this to define this account code as a statistical account. Statistical accounts are used for the analysis of non-financial information within the General Ledger. They do not affect any normal financial accounting processes. Statistical accounts are automatically defined as control accounts by the system to prevent transactions being processed to them from other modules. i.e. Statistical accounts can only be updated from within the General Ledger module. An existing General Ledger account code cannot be re-defined as a statistical account type if:
|
||||||||
Current asset/liability |
You use this to define whether the account is a current or non-current asset or liability. This only applies to an Asset or Liability. Account type. It is important to define these correctly, as the ratio analysis calculations are based on account types. If the ledger code is an Asset account type, then you can select this option to indicate that it is a current asset account. If you do not select this option, then by default, the account is assumed to be a non-current asset. If the ledger code is a Liability account type, then you can select this option to indicate that it is a current liability account. If you do not select this option, then the account is assumed to be a non-current liability by default. |
||||||||
Expense type |
An entry can only be made here if you set the Account type to Expense. The Expense type is used by the Accounts Payable module (if integrated to General Ledger) to determine the category into which purchases are accumulated during expense distribution (refer to AP Invoice Posting). |
||||||||
Merchandise | Select this if the account is used to record merchandise purchases. | ||||||||
Freight | Select this if the account is used to record freight expenses. | ||||||||
Other | Select this if the account is any expense account not related to merchandise or freight. | ||||||||
Options | |||||||||
Control account |
Select this to set the account as a control account. Control accounts represent the transactions that have taken place in the sub ledgers. These accounts are updated by the sub ledgers (Accounts Payable, Accounts Receivable, Cash Book, Inventory, Work in Progress and Fixed Assets), when these sub ledgers are integrated to the General Ledger (General Ledger Integration). This option is automatically enabled for Statistical account types and cannot be changed. |
||||||||
Gain/Loss account |
Select this to set the account as a Gain/Loss account. Gain/Loss accounts relate to the revaluation of alternate currency ledgers. The GL Alternate Currency Valuation program posts variances in revaluation to the Gain/Loss accounts defined in the Revaluation categories (see GL Revaluation Categories). |
||||||||
GL Analysis required |
Select this if you want this ledger code to be subject to account analysis. If you select this option, then analysis information must be entered when processing journals or distribution entries from a sub-ledger to this ledger code. You cannot select this option if you selected the Control account option: When you select this option, you must specify an Analysis category.
If you no longer require GL analysis for a ledger code, then this option must be disabled against that GL code. If you no longer require GL analysis at all, then this option must be disabled against all GL codes. |
||||||||
Analysis category |
Specify the analysis category to use when processing transactions to this ledger code. This is only enabled if you selected the GL Analysis required option. |
||||||||
Statistical | This is only enabled for Statistical account types. | ||||||||
Unit of measure |
This descriptive field indicates the unit of measure in which the statistical data must be measured. It must be defined for all Statistical account types. |
||||||||
Password |
This enables you to prevent the unauthorized manual posting of detail ledger distributions to this account code. This is only available if you selected the setup option: Passwords required for individual ledger accounts (General Ledger Setup - General tab). Defining a password against an account prevents:
The GL Entries Import program ignores any passwords defined against ledger codes (GL Structure Definition or Browse on General Ledger Codes). |
||||||||
Enter new password | Enter up to 4 characters as the password for the account. | ||||||||
Re-enter new password | Enter the same characters entered in the Enter new password field to verify the password. | ||||||||
Clear Password | Removes the password previously assigned to the ledger code. | ||||||||
OK |
Select this to accept your changes and return to the previous screen.
|
||||||||
Cancel | Ignores any changes made and returns to the previous screen. | ||||||||
Integration |
This enables you to define the method of integration for this particular ledger code. This is only available if you selected the setup option: Integration from sub-ledger at ledger code level (General Ledger Setup - general tab). Additionally, the sub-ledger must be linked to General Ledger in detail or summary (General Ledger Integration - General Ledger tab). Integration of the sub-ledgers is defined at sub-ledger level using the General Ledger Integration program, however, you can use this Integration function to define a different integration level for this specific account code only. The integration level you define against an account takes precedence over the integration level defined at sub-ledger level. Defining integration at ledger code level can be useful when the sub-ledger is linked to the General Ledger in detail, but for specific ledger accounts against which postings are made, you only want summary information passed through to the General Ledger (and vice versa). Typically, you would not want to integrate to a control account in detail because of the volume of entries that would be created in the control account. |
||||||||
Sub-ledger integration method |
|
||||||||
OK |
Accepts the integration level you selected and returns to the previous screen.
|
||||||||
Cancel | Leave the integration method unchanged and returns to the previous screen. | ||||||||
Business Processes |
This enables you to define the valid business processes for the account code. By default, transactions relating to all business processes are enabled for a General Ledger account. By defining the business processes against a ledger code, you can ensure that the code is only used for appropriate transactions. When you process a transaction and browse on the ledger code, only the ledger codes enabled for the business process related to the transaction you are processing are displayed. Refer to Customize business process properties for information on how to customize business process properties. |
||||||||
Business process |
This lists the business processes for which the account code can be enabled. You can select up to 10 business processes for the ledger code. |
||||||||
Enable business processes for this ledger code |
Select this to define the business processes you want to enable for the account code. If you select this option, then you must define at least one business process for the ledger code.
|
||||||||
Close | Returns to the previous screen. | ||||||||
Clear fields after each save | Clears the fields you entered when adding a new General Ledger code. | ||||||||
Save & Close |
Save the information entered for the current account code and returns to the previous screen. This is only available when you select the Add function. |
||||||||
Save | Saves the information entered without returning to the previous screen. | ||||||||
Cancel | Ignores the information entered for the current value and returns to the previous screen. |
This enables you to define the sub-sections within each section.
For example, although you may have 5 branches and 10 departments, it is possible that not all departments exist in all 5 branches. You therefore need to indicate which departments exist in which branch.
The lowest section (the last section number defined) has no sub-sections and you can therefore not define any relationships for this section.
When you select the Relationships function, a treeview indicates the hierarchy of the all sections that you defined.
The top level of the treeview indicates the first section that you defined (i.e. Section 1). Each subsequent section defined becomes the child of the previous section and the parent of the next section.
Within each sub-section you can selectively indicate the relationships between the parent and child items by highlighting the section you want to maintain and selecting the Relationship Settings option from the File menu.
By default, all child items are allowed in all sections. For example, if you have three locations (defined as section 1) and within those three locations you have 4 cost centers (defined as section 2), then all cost centers are automatically defined as permissible within each location.
If you select the option: View Disallowed Items from the View menu, then a "no entry" sign is displayed next to a child item to indicate that the child item is not permissible within that parent section.
The relationship you define between a child and its immediate parent is automatically set throughout the system. Therefore, if a parent-child relationship is allowed under one grandparent section, it is allowed for all other grandparent sections. You cannot, for example, define the following:
If you define the relationship between Parent A and Child 1 and Child 2 as Allowed, then this relationship cannot be changed by changing the Grandparents (i.e. Child 1 and Child 2 will always be Allowed for Parent A, regardless of the Grandparents to which the parent is attached). |
Field | Description |
---|---|
All child items are allowed |
This is selected by default and indicates that all child items are allowed for the selected section. While this option is selected, no other options are available, except the OK and Cancel functions. Deselect this to indicate which child items are allowed within the current section. |
Child items | This displays all child items defined under the section. |
Section description (user-defined) |
The description for this field is the description you defined for the section. If the option: Selected items are allowed is selected, then a tick against an item in this list indicates that this child is valid for the parent selected. The parent section code and description are displayed in the title bar of the window. If the option: Selected items are disallowed is selected, then a tick against an item in this list indicates that this child is not valid for the parent selected. The parent section code and description are displayed in the title bar of the window. |
Description | Indicates the full description for the child item (sub-section). |
Selected items are | |
Allowed | Select this to set all the items you ticked to represent the sub-sections allowed for this section. |
Disallowed | Select set all the items you ticked to represent the sub-sections not allowed for this section. |
Select All | Marks all items in the list as valid for the section. |
Unselect All | Marks all items in the list as invalid for the section. |
Date last modified | Displays the date on which the section relationships were last changed. |
By | Displays the code and name of the operator who last modified the section relationships. |
OK | Accepts the relationship definitions selected. |
Cancel | Returns to the previous screen without saving any changes made to the relationships for the section. |
This enables you to rebuild your General Ledger analysis history tables/files based on your existing General Ledger history and budget tables/files.
Field | Description |
---|---|
Number of years to rebuild from history table |
Indicates the number of years for which you want to rebuild the analysis history. It defaults to the number of years defined against the setup option Number of years to retain Summary of history balances (General Ledger Setup - History tab), but you can select to rebuild analysis history for fewer years. |
Rebuild | Rebuilds the history for the number of years you indicated. |
Cancel | Returns to the previous screen without rebuilding the history. |
Electronic Signatures provide security access, transaction logging and event triggering. This enables you to increase control over your system changes.
Access to the following eSignature transactions within this program can be restricted at Operator, Group, Role or Company level. You configure this using the Electronic Signatures program.
eSignature Transaction | Description |
---|---|
GL Section added |
Controls access to the addition of sections in the GL Structure Definition program. |
GL Section changed |
Controls access to the maintenance of sections in the GL Structure Definition program. |
GL Section deleted |
Controls access to the deletion of sections in the GL Structure Definition program. |
GL Ledger code template added |
Controls access to the addition of general ledger code templates in the GL Structure Definition program. |
GL Ledger code template changed |
Controls access to the maintenance of general ledger code templates in the GL Structure Definition program. |
GL Ledger code template deleted |
Controls access to the deletion of general ledger code templates in the GL Structure Definition program. |
When you attempt to post to, or use, a GL code which has not yet been created (General Ledger Codes), the ledger code is automatically created based on the template defined providing:
This applies in any module of the system. If the activity GL Create ledger code from structure is deselected against your operator code, then a 'Ledger code not found' error is displayed and the account is not created.
If a GL code is valid according to the defined structure, it is immediately created in the General Ledger when it is entered in the applicable General Ledger code field. It is created irrespective of whether or not the screen details are saved, providing the activity: GL Create ledger code from structure is enabled against your operator code (Operator Maintenance -Security tab). |