Contents x
    Setting Up Transaction Details
    • 6 Minutes to read
    • Print
    • Dark
      Light
    • PDF
    Contents

    Setting Up Transaction Details

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

    Setup a dimension structure to load transactions data (daily data). This is one method of extracting, transforming and loading data from your system to the Planful system. Alternatively, you can use the Data Load Rules functionality to load transactions data.
    You can also load Transaction data using Translations. Information on how to do so is provided below.


    Description of Fields on the Transaction Details Page

    Amount Columns - Specify how many amount columns are required in the Data Load Rules on the Define Overall Rule Settings page.

    • A Single Value creates one amount column.
    • A Debit amount and credit amount create two columns, one for debits and one for credits.

    Source Data - Select the location of the source data. If the source data resides in the On Source segments, select the translation to apply to the transaction as the Translation Data Load field is available for selection as shown below.

    Translation Data Load - Organizations that operate multiple companies with disparate general ledgers using different schemas of chart of accounts require data translations or mappings for the data to be loaded into the Planful suite.

    • Select the translation you would like to apply to the transaction, which copies the structure from the Data Load Rules that you select here (if you use Translations as the source).
    • Remember, a translation, is a way of translating or rendering data. For example, one might translate data from a local currency to a common currency.

    Attribute Type - The Common COA (Chart of Accounts) segment defaults are displayed based on the setup on the Define Financial Segments page accessed by navigating to Maintenance > Administration > Configuration Tasks.

    Attribute Name - Enter the name of the attribute based on the segments defined for the Common COA and attributes setup for those segments. For example, some Common COA names are; Company, Account, and Project. 

    Attribute Data Type - Select this option to associate a data type with a variable character field. Variable character fields have a user-defined length and can hold letters and numbers.

    URL - Select this option to load a reference URL. You can click the URL hyperlink when you view the Transactions Drill-Through reports.

    Attribute length - Enter the maximum amount of characters for the field.

    Loading Transaction Data with Translations

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

    How to 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 > Data Integration > Data Load Rules.
    2. Click the 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.


    On Source Segments (with translations)

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

    1. Navigate to Maintenance > Data Integration > Transaction Details.
    2. Select Amount Columns from the drop-down list.
    3. For Source Data, select On Source Segments (with translations).
    4. Select Translation Data Load from the drop-down list for the Transactions Data Load field.
    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.


    CCOA

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

    1. Navigate to Maintenance > Data Integration > 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.

    How to Create Transaction Data DLR to Load Data?

    1. Navigate to Maintenance > Data Integration > Data Load Rules.
    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.
      If you have selected Transaction Data as a Load Sub Item, click here.
      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.

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

    8. Click Next.
    9. In the Define Overall Rule Settings tab, 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 in the Include in Data File column under Transaction Data V2 Details.  
    10. In the Include in Clear Data column - Select segments/attributes for which you want to clear or retain data by selecting the checkbox.
      Source Data - CCOA

    11. Click Next. 
    12. In the Manipulate Input File tab, modify 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.
    13. Click Next.
    14. In the Define Data Mapping tab, 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.

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

    Asian Characters in Transaction Data Loads

    You can load Transaction data with Chinese, Japanese, Korean, and Malay characters using a Translation or GL Data Data Load Rule. Once loaded, you can view the data in the Dynamic Report Transaction Report by drilling through to transactional data.

    You must contact Planful Support to enable this feature. Once enabled by Support, complete the steps below.

    Note:
    If you try to run Data Load Rules to load Asian characters prior to carrying out the steps below, the Asian characters will display as question marks.

    Complete the following steps:

    1. Contact the Planful Support team to enable this feature.

    2. Access the Transaction Details Setup page by navigating to Maintenance > Data Integration > Transaction Details.

    3. If the user defined attributes are not present in the existing Transaction Details Setup, you must add them using the ‘+’ icon before saving the Transaction Details Setup. Please note that as per the existing behavior, if any changes are made to the Transaction Details Setup screen before saving, then the earlier Transactions loaded are lost.

    4. Asian characters can be loaded to user defined attribute columns only. You cannot load data with Asian characters to segment members. To add a new user defined attribute, click the add ‘+’ icon and select Text for Attribute Data Type. Select the URL to enter a web hyperlink.

    5. For Attribute Length, enter up to a maximum of 4000 characters.

    6. Click Save.

    7. Access the Data Load Rules and load Transaction Data for the GL Data/Translations Data that has been loaded. If using the File Load type, ensure that when the excel load file is saved, the Save As format option is either CSV UTF-8 (Comma delimited) (*.csv) or Unicode Text (*.txt).

    8. Create a Dynamic Report to view the Transaction Report. To view transactional data with Asian characters, double-click, and the Transaction Report displays.

    9. If you are an existing customer and require a migration of the existing Transaction data, then the transaction data needs to be reloaded.
      Make sure you enable Drill Through to Transactions for the Dynamic Report. To do so, click Format and select Transactions.


    Translation Data Load

    To load transaction data with Asian characters using translations, set up a Translations data load rule. For information on how to do so, see the Transaction Details: Loading Transaction Data with Translations topic in this guide.

    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