- 6 Minutes to read
- Print
- DarkLight
- PDF
Translations Setup
- 6 Minutes to read
- Print
- DarkLight
- PDF
Set up Translations to load data that needs to be translated. For example, if your organization operates with multiple companies with disparate general ledgers using different schemas of chart of accounts, data translations or mappings are required for the data to be loaded into the Planful suite.
Translations provide a mechanism for you to map the data from your local chart of accounts of the reporting site (subsidiary or a partner company) with the common reporting chart of accounts used in Planful .
If your entities do not use a Common Chart of Accounts, you must provide data load files with your native chart of accounts. A Translation will be required to map your native chart of accounts used in your source data load file against the Common Chart of Accounts.
Translation Model types include;
Translating all native Source Chart of Accounts to the Common Chart of Accounts.
Translating a single source segment to the Common Chart of Accounts.
Translating source segments to Common Chart of Account Segments with Multiple varying Translations.
With Translation models of type 1 & 2, data load definitions use a single Translation file for mapping. With the Translation model type 3, Data load definitions use multiple Translations to make up the complete COA definition.
Access the Translations Setup page by navigating to Maintenance > Data Integration > Translations Setup .
Description of Fields on the Translation Setup Page
Add
Add a translation to map source and target segments. You can translate the following:
All native Source Chart of Accounts to Common Chart of Accounts.
Single source segment to Common Chart of Accounts
Source segments to Common Chart of Account Segments with Multiple varying Translations
Edit
Edit mapped source and target segments.
Delete
Multiple lines can be deleted at a time by using Shift or Ctrl keys for row selection.
Translation Lines
Add translation lines. You can copy and paste data directly to the grid. Then, click Save.
Translation Lines Report
Run the Translation Lines report. Once complete, you will receive a notice. Download the report and open in Excel.
When you add translation lines in the application, you cannot save the updates if there are any duplicate records. When you click Save after adding the translation lines, the application validates the added records for any errors. If there are any duplicate lines, the application displays an exception report showing the duplicate lines. You can use the Autocorrect and Save option to remove the duplicate lines and save the data.
You can also run the Exception Report from here, which displays missing segments in red as following.
Source Segments
The segments you are translating data from.
Target Segments
The segments you are translating data to.
Data Load Rules
The associated Data Load Rule where the translation is used.
Category
The type of segment; Financial, Currency, etc.
How to Add a Translation
Navigate to Maintenance > DLR > Translations Setup .
On the Translation List page click Add .
On the Translation Add page enter a code to identify the translation.
Enter a name for the translations and pick the category from which you will be translating segments. In the example below, Financial Segments is selected.
For each source segment you select enter the value of the target segment. In the example below, source column 1 in your system maps to the Company segment in Planful.
Select the Enable Description checkbox if you want to add a description column for the selected Source Segments. The Description column will be visible when you drill through in a Dynamic Report with Translations data. You can use the Hide Description option available in the Translation Lines toolbar to hide the Description column.
Save and click the Translation Lines button.
Enter or copy and paste data lines to be translated.
Click Save and navigate to Maintenance > DLR > Data Load Rules .
Add a new Data Load Rule to load Segment members with translations.
On the Define Overall Rule Settings page of the Data Load Rule definition, you will select the translation defined on the Translation page as shown below.
Simplified Translations Lines Option
For translations in data loads, without this option, you have to setup translation line mappings for all segments; even those not being translated. The Simplified Translations Lines feature eliminates the need to define, map, and maintain translations for segments not translated.
In Practice
To better explain this feature, two examples are provided below; one shows how the functionality works when you are not using Simplified Translations Lines and when you are using this functionality.
Without Translation Lines Example
In the translation lines example below, the Account segment is the only segment being translated. Department and Project segments both have a one to one mapping; meaning that no translation is required.
With Simplified Translation Lines
Using this feature, translation lines for the Account segment ONLY need to be maintained as shown below:
Simplified Translations Lines Setup
There is some minor setup required.
When creating your Data Load Rule , select the No Translation for Unmapped Target Segments checkbox (shown in the image below) from the Define Overall Rule Settings step in the Data Load Rule.
Complete the Define Data Mappings step in the Data Load Rule to map the source columns in the file load to the target segments in Planful as they will no longer be translated. There are no changes required to the load file or the existing loading process to use simplified translation lines.
Using Wildcards
The following table provides a list of wildcard characters(used to define complex Translations) allowed when defining Translations along with a description of each
Wildcard Character | Usage Pattern | Action | Description |
---|---|---|---|
% | 123% | Allow | All source segments beginning with 123. |
%123 | Allow | All source segments ending with 123. | |
%123% | Allow | All source segments containing 123. | |
123%% | Deny | More than one ‘%’ not allowed in sequence. | |
? | 123? | Allow | All 4 digit source segments beginning with 123. |
?123 | Allow | All 4 digit source segments ending with 123. | |
?123? | Allow | A 5 digit source segments containing 123 in the middle. | |
123?? | Allow | Multiple ‘?’ are allowed in sequence. All 5 digit source segments beginning with 123. | |
~ | 100~200 | Allow | All source values from 100 to 200 (both numbers inclusive). |
~300 | Deny | ‘~’ is not allowed as the first value in a source definition. | |
500~ | Deny | ‘~’ is not allowed as the last value in a source definition. | |
200~100 | Deny | To value must be > than From value. | |
100~200~300 | Deny | Multiple ‘~’ not allowed in a single source definition. | |
100~~200 | Deny | Multiple ‘~’ not allowed in a sequence. | |
100~?? | Deny | ‘~’ cannot be used with any other wild card character. | |
%~100 | Deny | ‘~’ cannot be used with any other wild card character. | |
% | 100%? or 100?% | Deny | '%’ & ‘?’ cannot be used In a sequence. |
%100? | Allow | All source segments containing 123 in the middle and one character after. | |
?10%1 | Allow | All source segments containing 10 in the middle and one character before and ending in 1. |
If an incorrect combination of wildcard characters is used in Translation Lines, exceptions are generated when you save.
The precedence of wildcard characters for applying Translation Rules is %, , and specific\exact character match. This means the system will first apply % to all applicable Translations, followed by , and exact character match.
Example: 1
Translation lines are defined with wildcard characters as follows.
Source Segment | Target Segment |
10% | 1010 |
1000 ~ 1999 | 2010 |
10? | 3010 |
1050 | 4010 |
In data loads, the source segment is automatically mapped based on the Translations. Each time the Translation Rule is applied, the previous values for Segment Mapping are updated with the latest values.
Source Segment | % Applied | ~ Applied | Applied | Exact Match Applied | Final Target Segment Mapping |
100 | 1010 | 3010 | 3010 | ||
1000 | 1010 | 2010 | 2010 | ||
10000 | 1010 | 1010 | |||
105 | 1010 | 3010 | 3010 | ||
1004 | 1010 | 2010 | 2010 | ||
1050 | 1010 | 2010 | 4010 | 4010 |
Example 2:
Translation lines defined with wildcard character '?':
Source Segment | Sub Account | Target Segment |
101 | 2001 | 1010 |
1?? | ??? | 2010 |
In data loads, the source segment is automatically mapped based on the Translations. In this case, because line #1 is more specific than line #2, Source Segment 101 is mapped to 1010 instead of 2010.
How to Copy and Paste Translation Lines
In Excel, select the line(s) you want to paste in Planful and copy as shown below.
In Planful, add the number of lines you want to paste on the Translation Lines page.
Select the first cell in the first line as shown below.
Perform a CTRL+V. Notice there are now two lines with account 5555 ; the original line and the one just pasted.
Best Practices
Do not use blank spaces and special characters in the mapping.
When creating multiple translations for a data load, preserve the order of the source segments columns across different translations.
All Common Chart of Account segment members used in the Translation should exist in the application. If any segment members are missing, an exception report will be generated highlighting all missing segments.