Contents x
    Loading Transaction Data with Translations
    • 2 Minutes to read
    • Print
    • Dark
      Light
    • PDF
    Contents

    Loading Transaction Data with Translations

    • 2 Minutes to read
    • Print
    • Dark
      Light
    • PDF
    Article summary

    Loading Transaction Data with Translations

    To load transactions data using translations, follow the below three steps

    1. Create Translations DLR
    2. Setup Transaction Details 
    3. Create Transaction Data DLR to Load Data

    Create Translations DLR

    Create a Translations Data Load Rule (DLR) by defining data loading settings for translations, enabling you to load transaction data seamlessly.

    Note:
    If Translation data DLR is already created, skip to the Setup Transaction Details steps.
    1. Navigate to Maintenance > DLR > Data Load Rules.
    2. Click New Data Load Rule to define a new translation DLR.
    3. Enter Name and Description.
    4. Select a Load Type from the drop-down list.
    5. For Load Item, select Data from the drop-down list.
    6. For Load Sub Item, select Translations Data from the drop-down list.

    Complete all the required fields on the remaining Data Load Rules steps to create a Translation DLR. Refer to Creating New Data Load Rules for detailed instructions.

    Setup Transaction Details

    Configure transaction details for your data source, either with translations or using the CCOA.

    To set the transaction details with translations, follow the steps below

    1. Navigate to Maintenance > DLR > Transaction Details.
    2. Select Amount Columns from the drop-down list.
    3. For Source Data, select On Source Segments (with translations).
    4. Select a Translation Data Load DLR created from the drop-down list for the Transactions Data Load.
    5. All the translated columns will be shown after the segment columns, including date columns, attributes, and amount columns. Click the plus (+) icon to add more attributes. Select any row and use the options on the right to move the position up or down.
    6. Click Save.


    To set the transaction details with CCOA (GL data), follow the steps below

    1. Navigate to Maintenance > DLR > Transaction Details.
    2. Select Amount Columns from the drop-down list.
    3. For Source Data, select CCOA.
    4. All the translated columns will be shown after the segment columns, including date columns, attributes, and amount columns. Click the plus (+) icon to add more attributes. Select any row and use the options on the right to move the position up or down.
    5. Click Save.

    Create Transaction Data DLR to Load Data

    1. Navigate to Maintenance > DLR > Data Load Rules.

      New Data Load Rule
    2. Click the New Data Load Rule to create a new transaction data DLR.
    3. Enter Name and Description.
    4. Select a Load Type from the drop-down list.
    5. For Load Item, select Data from the drop-down list.
    6. For Load Sub Item, select Transaction Data V2 from the drop-down list.
      Note:
      The Transaction Data Version 2 provides fast and more efficient processing of the Data Load Rule. You cannot rollback to Transactions Data (V1) once you use Transaction Data V2.

      Select Sample Input File

    7. Select file requirements or the structure of the data you are loading.

      Define Overall Rule Settings
    8. Include in Data File - Select Yes if a dimension is not defined within the data file, or select No if you do not want the listed parameters in the data file.
    9. Include in Clear Data - Select segments/attributes for which you want to clear or retain data.
      Source Data - Translations
      Source Data - CCOA

      Manipulate Input File
    10. Manipulate the file or format of the data you are loading. The top pane displays the raw data, and the bottom pane displays the manipulated data.

      Define Data Mappings
    11. Map source data columns (Source Column) to target segments (Maps To). This mapping tells the system where and how your data will display in the columns once the load occurs.
    12. Load Data is the final step in the Load data process. Once the Data File is chosen, click Finish.
      For more information, refer to Creating New Data Load Rules.
    Was this article helpful?
    What's Next

      Planful. 150 Spear Street, Suite 1850, San Francisco, CA 94105

    • Copyright © 2024 Planful. All Rights Reserved.

    Terms of Use - Privacy Policy