Use the Fund Accounting Profile - Translation page to define how the system parses a single full-account string into its organization and account segments. This page allows users to specify, for each ledger type (Expenditure, Revenue, G/L), the number of organization levels, the start and end positions of each segment within the input string, the account-level positions, and the display format (delimiter, placeholder text, and help message). The data entered on this page is stored in the trans_acct table and is used by the system to split and build full account numbers whenever the Full Account Format option is enabled on the Fund Accounting Profile page.
Menu path
From the System Administration menu, select Administration. From the Profiles menu, select Fund Accounting Profile. Select Translation.
Procedure
-
On the Translation page, select the Ledger to configure:
-
E – Expenditure
-
R – Revenue
-
G – G/L
-
-
Select the Number of Organization Levels (1–9). The level labels are retrieved from the Fund Accounting Profile – Titles tab (Fund, plus the orgn titles for each level used). Levels beyond the number selected are hidden, and their positions are set to 0.
-
For each displayed organization level, enter the Start and End positions that correspond to where that segment appears within the full-account input string. For example, if Fund occupies characters 1–3 and Function occupies characters 5–8, enter Start = 1 / End = 3 for Fund and Start = 5 / End = 8 for Function. The system enforces the following rules:
-
Start must be less than or equal to End.
-
Positions cannot be negative.
-
Positions must not overlap with any other segment.
-
Both Start and End must be entered (or both left at zero for unused levels).
-
Positions cannot exceed the specified number of levels.
-
-
In the Account Level section, enter the Title for the first account segment (e.g., "Account" or "Object"), and its Start and End positions. The first account segment is required. If the account is subdivided into two segments (e.g., Object and Sub-Object), enter a title and start/end positions for the second account segment as well. If both account segments are used, both titles are required.
-
Select the Delimiter. The delimiter separates segments in the full-account string and applies to all ledger types.
-
The Format field displays the generated account mask based on the configured positions and delimiter.
-
Enter the Placeholder Text. This is a template string that matches the format length and is shown to users as a guide when entering full account numbers (e.g., FFF-FFFF-OOO-LLL). The length of the placeholder text must match the length of the generated format. If the positions change, the system clears the placeholder text and prompts you to re-enter it.
-
Enter the Help Message. This is the text displayed to users for the Account Number field.
-
Save the record. The system:
-
Inserts or updates the record for the selected ledger type.
-
Updates the delimiter in placeholder text across all three ledger types if the delimiter was changed.
-
If the account component 2 Title field is cleared, the following confirmation message is displayed: "This update will remove account components from the translation setup for all ledger types." On confirmation, the second account segment positions are cleared across all ledger types, and the Placeholder Text for other ledger types is cleared (requiring re-entry).
-
If Full Account Format is already enabled, the system runs the Update Full Account Tables process to rebuild or update full account fields based on the new translation definition.
-
-
Repeat these steps for each ledger type (Expenditure, Revenue, G/L). All three ledger types must have valid translation records before Full Account Format can be enabled.
When exiting the page, if Full Account Format is enabled and any ledger type is missing a translation record or has a mismatch in placeholder text, the following warning message is displayed: "Account number formatting not defined on translation page for [ledger type(s)]."