Table of Contents

Expense

Overview

This page contains settings related to operating expenses.

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

Expense: Accounts

This table identifies the accounts to be used when creating expense transactions.

Columns:

  • Legal Entity (k)
    Legal Entity applicable.
  • Dataset (k)
    Dataset is one of 'Forecast' or 'Budget'. Valid in: img Planner 4 or earlier.
  • Account (k)
    Named group of accounts from Account dimension or individual accounts.
  • SupplierID (k)
    Identify the supplier as criteria when matching setting row.
  • AP
    Account for Account Payables for purchased goods.
  • Discount
    Account for discount.
  • Disc. periodic
    Account for periodic discounts.
  • EPTax
    Account for employment tax.
  • Comments
    Free text string to help document settings.

Expense: Days Of Credit

This table defines the number of days until expenses will be paid.

Columns:

  • Legal Entity (k)
    Legal Entity applicable.
  • Dataset (k)
    Dataset is one of 'Forecast' or 'Budget'. Valid in: img Planner 4 or earlier.
  • Account (k)
    Named group of accounts from Account dimension or individual accounts.
  • SupplierID (k)
    Identify the supplier as criteria when matching setting row.
  • From Date (k)
    The date from which the setting is valid from.
  • Value
    Number of days to payment.
  • Comments
    Free text string to help document settings.

Expense: Accrued

This table is used to define expenses that are accrued for payment at regular terms.

Columns:

  • Legal Entity (k)
    Legal Entity applicable.
  • Dataset (k)
    Dataset is one of 'Forecast' or 'Budget'. Valid in: img Planner 4 or earlier.
  • Account (k)
    Named group of accounts from Account dimension or individual accounts.
  • SupplierID (k)
    Identify the supplier as criteria when matching setting row.
  • From Date (k)
    The date from which the setting is valid from.
  • Term1Start
    Start date for first term.
  • TermLength
    Number of months unless Weeks is set to true below.
  • Weeks:
    Set to true if term length will be defined as number of weeks.
  • PrePaid
    Set to true if payment is in advance before the term.
  • PostingDays
    Number of days between booking and invoice received for payment.
  • Comments
    Free text string to help document settings.

NonCash: Counter Account

Transactions matching these settings (Legal Entity and Account) will be posted as "non-cash". A non-cash transaction means that the input transactions matching LegalEntity and Account will generate a transaction on selected counteraccount only - not involving any payments.

Note that any other functions that would involve this account will be deactivated for this Legal Entity and Account combination.

Columns:

  • Legal Entity (k)
    Legal Entity applicable for setting.
  • Account (k)
    Named account from Account dimension.
  • NCT CAcc
    Counteraccount selected from account dimension.
  • Comments
    Free text string to help document settings.
Edit this page