1. Home
  2. /
  3. Setup Guides
  4. /
  5. Asset Management
  6. /
  7. Setting up DC1 Asset...

Setting up DC1 Asset Management

Related topics

Mandatory entries for the different files and tables involved in the implementation are described in this document, as well as the order in which the tables and files should be completed. For a more thorough explanation of code usage and the operation of the different maintenance programs, see the Panel help.

See also Implementation tips which contains examples of how the setup of depreciations should be done, and the effect that certain parameters have on the system.

What this document contains:

Setup

The setup for an installation of DC1 Asset Management is divided into three major phases:

  1. Activate DC1 Asset Management in Work with companies.
  2. Pre-load tables for DC1 Asset Management.
  3. Establish mandatory data in DC1 Financials and DC1 Asset Management tables/files.

For a description of steps 1 and 2, see the corresponding sections below. For a description of the last step, see the applicable related topics concerning DC1 Financials related tables and files.

Activate DC1 Asset Management

Activation of the DC1 Asset Management application as a separate task can only be done if the DC1 software is already installed and a company (or several companies) is already generated.

For your information, when generating a company in DC1 for the first time, the applications to be used in the company are also activated. For more information, see Company generation.

To activate ASM in a company that is already installed, do as follows:

Program/Panel To do
Work with companies Select the company in which DC1 Asset Management should be activated and click Applications.
Work with companies, All applications Select the AAC application and click Activate.
Work with companies, Application definitions Click OK and exit the routine.

DC1 Asset Management is now activated, but you have to restart the company (select the Change company to work with menu item) to be able to continue with the next section.

Pre-load tables for DC1 Asset Management

Pre-load of tables used in the DC1 Asset Management application as a separate task can only be done if the DC1 software is already installed and a company (or several companies) is already generated.

Program/Panel To do
Update pre-loaded application tables On the Application preload tables update panel, do the following:

  • Enter the DC1 Asset Management application code (AAC).
  • Perform update by clicking OK.

You are now ready to start manually loading data in tables and files. See the Tables/Files section below and the applicable related topics concerning tables and files.

Tables/Files

There are a number of tables and files in DC1 Financials and DC1 Asset Management that need to be initialised before the system can be released for transaction handling in a live environment.

Perform this procedure in the order outlined below.

Table/File To do
Number series table The number series for the following proposal types must be set up:

  • Depreciation proposals
  • Disposal proposals
  • Inventory proposals
Asset number series table Number series must be set up for the following asset types:

  • Active (normal) assets
  • Budget assets
Technical form table If you want to use technical forms, they should be added in this table.
Asset type & group table Define the account groups on asset level. These groups can be used when creating transactions. The groups are also used for sorting and selections.
Depreciation type table This table is preloaded at installation. Go through the preloaded types. Establish new and remove obsolete ones.
Interface type table The interface types for the following types of accounting transactions must be set up:

  • Disposal accounting
  • Depreciation accounting
  • Balance movement

Note: If you want to use an explicit voucher type for assets, then you need to set up the voucher number series and voucher type before.

ASM control file The ASM control file contains basic data that is required in the Asset Management system. The information in this file must be completed during system setup. To establish the data in the ASM control file, read the Basic data section below carefully and decide what parameters are necessary for your organisation. There are three panels in this routine, which are described in the section.
G/L transaction type table The table is preloaded with a proposal on how to control the accounting. You may change the proposal if it does not fit your requirements.
Account code table Establish the accounting rules for the G/L transaction types. The account must exist in the Account file in DC1 Financials.
Acquisition type table Establish the acquisition types to be used in your system.
Acquisition account table Establish the acquisition account definitions to be used for retrieving supplier invoice information from DC1 Financials to DC1 Asset Management.
Asset account group table This table need only to be completed with entries if asset groups are to control the accounting.
Location table Establish the locations in each class to be used in your system. The locations are also used for other purposes than accounting.
Responsible table Establish the responsible signatures to be used in your system. The responsible signatures are also used for other purposes than accounting.
Usage curve table This table need only to be completed if usage curves should be used in depreciations.
Rate curve table This table need only to be completed if percentage curves should be used in depreciations. Note: The economical/technical useful life is used in calculations, so it may not be necessary to establish percentage rules.
Depreciation module table This table is preloaded at installation. Go through the preloaded modules. Establish new and remove obsolete ones.
Depreciation rule table This table is preloaded at installation. Go through the preloaded rules. Establish new and remove obsolete ones.
Variable parameter table This table is preloaded at installation. You can change existing records, but you cannot add new.
Transaction origin table This table is preloaded at installation. You can change existing records, but you cannot add new.
Index table The entries in this table are used to revaluate asset replacement and insurance values. The index technique is also used in the predefined calculation rule for costing depreciation.
Disposal type table The entries in this table are used for disposal of assets. Disposal methods are, e.g., sales or scrapping of an asset. You can define your own methods in order to follow up the reasons for disposal in greater detail.
Insurance company table In this table you can set up the insurance companies in your company.
Insurance policy table The entries in this table are used in the Asset file where entries are made whenever assets are covered by an insurance policy.
Service contract table The entries in this table are used in the Asset file where entries are made whenever assets are covered by a service contract. If DC1 Financials is installed, the service company you enter must exist in the Business partner file. In this case the service company will automatically be added to the Service company table.
Service company table This table contains the service companies your company uses. If DC1 Financials is installed, the companies are added automatically when you enter a service contract in the Service contract table. If DC1 Financials is not installed, you can manually enter service companies in this table. The entries are used in the Asset file, to indicate a service company for each service contract.
Depreciation files If you plan on entering existing assets into the Asset file for which you have already begun calculating depreciation, then use the Accumulated depreciation maintenance function. With this function you can update accumulated depreciations.

Basic data

Information on the following panels must be completed during system setup.

Panel To do
ASM control file maintenance (AACD10001) Complete the following:

    Main depreciation type
    This depreciation type is used in the disposal routine for disposing of depreciated assets. It tells the system which depreciation type to use to reverse balances and calculate profit and loss.
    Actual depreciation year
    This is the accounting year used only in the Asset Management system. The year does not have to be the same as the accounting year in DC1 Financials, thus allowing you to calculate asset depreciation before performing year-end closure.
    Note: The year you enter here cannot be less than the current accounting year in DC1 Financials.
    Economic transaction history
    If you want to save transactions from the previous year after the yearly reorganisation, then set this field to YES. The transactions will be saved in the History file.
    Profit and loss calculation
    You can choose one of three different methods for calculating profit and loss by entering the correct code in this field.

    Method Description
    1 The system calculates and creates profit and loss postings, as well as reverses the balances.
    2 The system only reverses the balances.
    9 The system does not calculate profit and loss, and reversal of balances must be performed manually.

    Profit and loss calculation methods

    Example:

    This example explains the three methods for calculating profit and loss and the impact these methods have on G/L transactions. It uses the scenario described below.

    You acquired a new asset for $100,000.00 in January 2010. In July, you sold it for $50,000.00. The accumulated depreciation when you sold the asset was $25,000.00.

Method 1
The system calculates and performs profit and loss postings, as well as reverses the balances. The following G/L transactions are performed using this method.

Transaction origin and type Debit amount Credit amount
102 ACQ Acquisition balance   100,000.00
111 BAL Depreciation balance 25,000.00  
121 DIS Disposal sales value 50,000.00  
123 DIL Disposal loss 25,000.00  

Method 2
The system only reverses the balances. The following G/L transactions are performed using this method.

Transaction origin and type Debit amount Credit amount
102 ACQ Acquisition balance   100,000.00
111 BAL Depreciation balance 25,000.00  
132 PLA Disposal P/L acquisition 100,000.00  
141 PLD Disposal P/L depreciation   25,000.00

Method 3
The system does not calculate profit and loss, and you must reverse the balances manually. Therefore, there are no G/L transactions created when you use this method.

    Accounting
    In order to generate G/L postings for the disposal transactions, you must set this field to YES. You must also enter an interface type in the field below.
    Interface type
    If you want to transfer disposal transactions to the G/L, you must enter an interface type from the Interface type table in this field. The interface type is used to define how to transfer and update the G/L postings in DC1 Financials. This provides a link to a voucher type and voucher number series.
    Number series
    You must also define the number series that will be used in the Asset Management module. You must define these number series in advance. They are:
  • Depreciation proposal
  • Inventory proposal
  • Disposal proposal
  • Budget asset

Note: For the Depreciation, Inventory and Disposal proposals, choose a number series defined in the Number series table. For Budget asset, choose a number series defined in the Asset number series table.

Calculation constants
If you want to custom define your own calculation rules for calculating depreciation, you can create calculation constants here. The calculation constants can be used as a fixed value e.g., internal interest rate, or a percentage. Constants defined at this level are valid for all assets in the system. You can also define calculation constants for specific asset types and groups in the Asset file. None of the pre-loaded calculation rules use the values established here.
Note: The average user does not need to use this function. Contact your technical support if you want to set up your own calculation rules to calculate depreciation.
ASM control file maintenance (AACD10002)

    Codes for:

    Active asset and Budget asset
    When you set up an asset in the Asset file, you must tell the system if the asset is a budget asset or an active asset. For active assets, the system calculates depreciation and creates transactions.
    Cost centre allowed
    If you want to allow cost centre accounting, set this field to YES. You can then link a cost centre to each asset in the Asset file. Cost centre is used for creating G/L postings for different transactions in Asset Management. In addition, it can be used for sorting selections on Asset Management printouts and enquiries.
    If you do not allow cost centre accounting, the Cost centre field will not be displayed anywhere in the system.
    Cost centre account part
    If cost centre accounting is permitted, you must enter the corresponding account part in DC1 Financials. If no cost centre account part is defined in DC1 Financials you can use which account part you need.
    Project allowed
    If you want to allow project accounting, set this field to YES. A project can then be kept on asset level in the Asset file, which can be used when creating G/L postings for different transactions in Asset Management. In addition, it can be used for sorting selections on Asset Management printouts and enquiries.
    If you do not allow project accounting, then the Project field will not be displayed anywhere in the system.
    Project account part
    If project accounting is permitted, you must enter the number of the account part for the project part. The project account part can be any account part except main and cost centre.

    Wait file origin:

    A/P, A/R, GL
    Set the DC1 Financials functions from which retrieval of transactions should be possible to YES.
ASM control file maintenance (AACD10003)
    Heading locations 1-8
    In these fields, you define the headings for the location classes that are to be used in the Location table and the Asset file. Locations can represent the physical place where the asset is located, e.g., a country or city. In addition, it can be used for financial control.

    Location fields

    Example:
  • Create a location heading for department called Dept.
  • Access the Location table and enter several departments. You can enter a Sales, Marketing and R&D department.
  • Access the Asset file and select an existing asset or create a new one. This asset will be physically located in the Sales department.
  • Note that the heading, Dept, which you created in the ASM control file, is now a field on the Location and user fields maintenance panel.
  • Enter the Sales department location that you created in the Location table, in the Dept field.
    User defined alpha 1-5
    These fields can be used if you need to keep more information about your assets than what the system provides. By completing the Heading and Attribute fields below, you can create up to five user-defined alphanumeric fields that appear on the Location and user fields maintenance panel in the Asset file.
    Heading
    Here, you create your own company headings that are displayed as the field names on the Location and user fields maintenance panel in the Asset file. They appear underneath the heading User defined fields. Each field can be up to 15 characters in length.
    Attribute
    If you want completion of a field to be mandatory, then enter the code for Mandatory as defined in the G/L control file. Leave the field blank for optional entry.

User-defined alpha field

Example:

Your company must keep track of which country assets are manufactured in. In this case, you need to create an alphanumeric field that has mandatory entry in the Asset file.

  • Create a user-defined alpha field called Country origin.
  • Enter the code for Mandatory in the Attribute field.
  • Access the Asset file and select an asset.
  • Note that the user-defined alpha field, Country origin, that you created in the ASM control file is now a field on the Location and user fields maintenance panel.
  • The asset was manufactured in Poland. Enter Poland in the Country origin field. The system does not allow you to skip this field because you have defined it as mandatory in the Attribute field for Country origin in the ASM control file.
    User defined numerical 1-5
    By completing the Heading, Decimals, Type and Attribute fields below, you can also create up to five user-defined numerical fields that appear on the Location and user fields maintenance panel in the Asset file.
    Heading
    Here, you create your own company headings that are displayed as the field names on the Location and user fields maintenance panel in the Asset file. They appear underneath the heading User defined fields. Each field can be up to 15 characters in length.
    Decimals
    Enter the number of decimals for field type 1 (numerical unspecified) and field type 2 (amount). For amounts, the number of decimals automatically defaults to the number of decimals for the system currency. The number of decimals for system currency is defined in the Currency table.
    Type
    Define the type of numeric field by using one of the following codes:
    Code Description Example
    1 Numerical unspecified 1000
    2 Amount (defined as system currency) 1000.54
    3 Date 000101 or 010100 (depending upon system setup)
    4 Period 0001

The system ensures that the numerical value you enter in a specific user-defined numerical field in the Asset file is compatible with the type.

User-defined numeric fields

Example:

When you purchase used assets, it is useful for you to enter the last date when the previous owner routinely maintained these assets. This information is not mandatory.

  • Create a user-defined numeric field called Maint. date.
  • Enter the code 3 in the Type field to indicate that a date must be entered here.
  • Leave the Attribute field blank for optional entry.
  • Access the Asset file and create a new asset or maintain an existing one.
  • Note that the user-defined numerical field Maint. date that you created is now a field on the Location and user fields maintenance panel.
  • Enter a date in the Maint. date field. Note: If you enter a value here, then you must enter a date because you entered the code 3 in the Type field in the ASM control file. If you left the Attribute field for Maint. date blank in the ASM control file, then you may leave this field blank.
    Attribute
    If you want completion of a field to be mandatory, enter the code for Mandatory, as defined in the G/L control file, in the Attribute field. Leave the field blank for optional entry.

Related topics