Table of Contents

Setup

Applies to: img Planner 5 or later.

Overview


img

  1. Selecting Setting Table
    The left area list the different setting tables available for the page. Ticking here will turn on and off the table.
  2. Tables View
    The right area will display the selected tables and allows users to edit content.

Descriptions

Each table and columns are described below.

Key columns used for matching when looking up correct setting is marked (k).

Time: Start and range

This table defines the start date and length for each planning dataset (i.e. Forecast and Budget).

Columns:

  • Start Date
    Read-only columns that shows the start date for current Forecast and Budget dataset. For rolling forecasts (and budget) this date will change every time the dataset is rolled forward.
  • Time: Start and length
    Selection of time range that allows for up to 7 years planning.

DaysOfCreditMethod: Monthly

This is useful to ensure that input from one month will be paid (i.e. due) over 2 months. Setting the value below to true, will distribute the input evenly over 30 days staring from days of credit. This will ensure that the due amounts is distributed between 2 months based on input from one month.

Example: Input dated March 3 and with 15 days due for payment, will cause 50% due in March and 50% due in April.

Columns:

  • Legal Entity (k)
    Legal Entity applicable.
  • Engine (k)
    Engine name.
  • Value
    Value true or false.

Fiscal Calendar Offset

This table is used to define a Fiscal year and periods that is offset from a normal calendar. Leaving this table empty will use the calendar.

Columns:

  • Fiscal start date
    Set to be the date of first day of a Fiscal calendar year.

  • Fiscal Year
    Set to the year number of the Fiscal year that starts on Fiscal Start Month number of months after the Calendar start date. This must be set to the year that the Fiscal year ends or to the Fiscal calendar start year.

Fiscal Calendar is used to set the year, quarter and month in the Time dimension. Time dimension is used to control how data is aggregate on Fiscal year and months.

Example:

Setting "Fiscal Start Date" = 2020-08-01 and "Fiscal Year" = 2021 will set the start period to one for transactions in august and the year will be set to 2021 which is the calendar year of the last day of the Fiscal year.

Setting "Fiscal Start Date" = 2020-01-01 and "Fiscal Year" = 2020 is equivalent to using an empty table.

Source: map Account to Engine

This table maps input accounts to the different posting engines.

Columns:

  • Account:
    Account group or single accounts that will be input to the selected engine.
  • Legal Entity (k)
    Legal Entity applicable.
  • Engine
    Engine name.

Note that one account will only be mapped to one and only one engine.

System: Fallback Accounts

This table maps internal account keys to your accounts. There are already quite a few tables where account use is defined but there will be accounts and in particular balance accounts that are used but not mapped elsewhere. Please check Finance Reports Trial Balance report for accounts that are used but not mapped.

Columns:

  • Acc Key (k)
    The system internal name for the account. This name will be used whenever an account mapping is missing.
  • Legal Entity (k)
    Legal Entity applicable.
  • Account
    Your account to be used.

CurrencyReportID

This table defines the currency to be used as default reporting currency during simulation.

Columns:

  • ID:
    ID must be set to "Finance" for the Planner solution.
  • Currency:
    Currency code (3-character code).
Edit this page