Configure Settings for the GL Interface

Knowledge Center > Marketplace > App Documentation > Configurable Summary Level GL Interface > Configure Settings for the GL Interface

Configure Settings for the GL Interface

Table of contents

You need to configure the app before it is ready for use.

Procedure

  1. Launch the app instance.
  2. Select the Summary Runs tab and click Settings.
  3. Configure global settings. Global settings will be used as default settings for manual or scheduled summary runs. You can modify these settings when you initiate a summary run or create a schedule. 
    • Days Offset - Enter the number of days offset from the end of the desired accounting period. Use positive numbers to indicate the accounting period is in the future and negative numbers to indicate the accounting period is in the past. 
    • Run Type - Identify run parameters for GL Interface
      • Run for a specific day (default)
      • Run a catch up for each past day in the accounting period
      • Run for the whole accounting period
    • Billing Types - Select all relevant billing types.
    • Cash Types - Select all relevant cash types.
    • Revenue Types - Select all relevant revenue types. 
  4. Configure file transfer settings.
  5. Add filtering SQL statements, or delete statements that you have added previously. 

  6. Configure file mapping settings.gl_connector_file_mapping.png

    • Select the number of columns in the exported file. 

    • Headers - Configure the headers to be used in the exported file. For direct integration with NetSuite, all headers are auto-populated from NetSuite settings.

      • Add new header rows or delete existing header rows as necessary.

      • Select Group column to display data from multiple columns in one transaction line. Only the name in the last header row of each column will be displayed in a grouping.
        Note: Only JournalEntryItem.Amount and JournalEntryItem.AmountHomeCurrency will be summed if the grouping function is utilized.

      • Duplicated headers will cause errors in summary runs.

      • The bottom header row cannot be left blank. 

    • Entry Source - Choose the appropriate header data entry source by toggling through the options of Input, Text, or Custom.

      A custom entry source must be formatted using Liquid.
      Liquid does not strip newlines or return carriages automatically. Place a string to the left of the bar in quotes and the command strip_newlines to the right of the bar. For further information about Liquid templates, please visit https://shopify.github.io/liquid/basics/.
    • Entry - Enter the desired input field. Posting Period and Currency are required fields.
      For integration with NetSuite, ensure the following requirements are met: 
      • Date Fields, Reversal, Start or End date, must match the date formatting configured in NetSuite.
      • Subsidiary, Account, Class and Location entries must contain the associated NetSuite numerical internal ID and the name listed in NetSuite.
  7. Click Update to save the settings.
Last modified

Tags

This page has no custom tags.

Classifications

(not set)