Table of Contents

Purchase

Overview

This page contains settings related to purchase of goods for sales or production.

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

Purchase: Accounts

This table identifies which accounts to be used for purchased goods.

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.
  • Product (k)
    Identify product or group of products for which the setting is valid.
  • AP
    Account for Account Payables for purchased goods.
  • Duty
    Account for duty.
  • Comments
    Free text string to help document settings.

When accounts are not specified, Planner will use the internal account key. These will be visible in the trial balance report. Accounts that appear with internal account key names can also be mapped using the System Fallback Account mapping.

Purchase: Days Of Credit

This table define number of days until purchased goods 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.
  • Product (k)
    Identify product or group of products for which the setting is valid.
  • 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.

Purchase: Accrued

Use this table to set up accrued purchase. This is purchased goods that are booked but accrued for payment at later 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.
  • Product (k)
    Identify product or group of products for which the setting is valid.
  • From Date (k)
    The date from which the setting is valid from.
  • Term1Start
    Start date of first term.
  • TermLength
    Number of months unless Weeks is set to true.
  • Weeks
    Set to true if term length is defined as number of weeks.
  • PrePaid
    Set to true if payment is in advance.
  • PostingDays
    Number of days between end of term and invoice booked.
  • 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