Translations Setup
  • 6 Minutes to read
  • Dark
    Light
  • PDF

Translations Setup

  • Dark
    Light
  • PDF

Article summary

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;

  1. Translating all native Source Chart of Accounts to the Common Chart of Accounts.

  2. Translating a single source segment to the Common Chart of Accounts.

  3. 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.

imagea3jz123hk.png

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.

Sept21ReleaseFPandADuplicateTranslationlinesexception.png

You can also run the Exception Report from here, which displays missing segments in red as following.

coreimage46.png

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

  1. Navigate to Maintenance > DLR > Translations Setup .

  2. On the Translation List page click Add .

  3. On the Translation Add page enter a code to identify the translation.

  4. 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.

  5. 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.

  6. 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.

    DIimagesEnabledescriptionWinter20.png

  7. Save and click the Translation Lines button.

  8. Enter or copy and paste data lines to be translated.

  9. Click Save and navigate to Maintenance > DLR > Data Load Rules .

  10. Add a new Data Load Rule to load Segment members with translations.

  11. 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.

    imagea3jz123hl.png

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.

imagea3jz12346.png

With Simplified Translation Lines

Using this feature, translation lines for the Account segment ONLY need to be maintained as shown below:

imagea3jz12348.png

Simplified Translations Lines Setup

There is some minor setup required.

  1. 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.

    imagea3jz12349.png

  2. 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 SegmentTarget Segment
10%1010
1000 ~ 19992010
10‌?3010
10504010

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~ AppliedAppliedExact Match AppliedFinal Target Segment Mapping
1001010 3010 3010
100010102010  2010
100001010   1010
1051010 3010 3010
100410102010  2010
105010102010 40104010

Example 2:

Translation lines defined with wildcard character ‌'?':

Source SegmentSub AccountTarget Segment
10120011010
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.

trans1.png

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.

trans2.png

Perform a CTRL+V. Notice there are now two lines with account 5555 ; the original line and the one just pasted.

trans3.png

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.


Was this article helpful?