Fixed Assets

Overview

This page defines input and settings form fixed assets.

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

FixedAsset

This table is the input table for defining fixed asset balance and depreciation.

You can choose to register assets using the purchase value and purchase date or purchase value and accumulated depreciations up until the opening balance date.

Columns:

• Legal Entity (k)
  Legal Entity applicable.
• Dataset (k)
  Dataset is one of 'Forecast' or 'Budget'. Valid in: Planner 4 or earlier.
• Text (k)
  Name to identify an asset or group of assets.
• Departm. (k)
  Department identifier.
• Account
  Account to post the fixed asset balance amount.
• AssetCost
  Asset purchase value
• Depr. accum
  Accumulated depreciations override amount. This optional and is used with start date is set to opening balance date.
• StartDate
  Booking date for purchase. Alternative set the opening balance date when "Depr. accum" override is used.
• Depr. %
  Deprecation percent.
• ResidualValue
  Residual value. Limit to stop deprecations.
• Declining
  Set to true to depreciate based on balance. When false depreciate linear based on purchase value.
• Y1 = full year
  Set to true to depreciate one full year the first year. Set to false will depreciate from start date.
• Acc Depr.
  Account for depreciations (profit-loss account).
• CAccount
  Counter account for depreciations (balance account).
• Disp. date
  Disposal date.
• Curr.Foreign
  Disposal foreign currency.
• Disposal
  Disposal amount in foreign currency. VAT %
  VAT percent applicable for disposal amount. DaysOfCredit
  Days of credit (i.e. days until payment is received). Acc AgioDis
  Account for agio-disagio. Acc P&L
  Account for profit-loss.
• Comments
  Free text string to help document settings.
• Dim1, ... , Dim4
  Optional dimensions
  

DecliningBalance StopValue

This table defines when depreciation assets will stop.

Columns:

• Legal Entity (k)
  Legal Entity applicable.
• Dataset (k)
  Dataset is one of 'Forecast' or 'Budget'. Valid in: Planner 4 or earlier.
• From Date (k)
  The date from which the setting is valid from.
• StopValue
  The balance limit amount to stop depreciating assets.
• Comments
  Free text string to help document settings.