Skip to Content

Migration of Fixed asset - Using Extended template

Hello All,


With this I would like to walk you through the fixed asset migration process using Extended fixed asset migration template. This is continuation of the document

Migration of Fixed asset - Using Default Migration template

Where usage of different templates and when to use extended template.


Prerequisites : (Extended Fixed asset migration template) :


Migration at the end of a fiscal year  (for example, December 31, 2010)

The transfer date can be the end of the last closed fiscal year. Proceed as follows for asset accounting:

  • For migration after closing financial statements, extract only cumulated values from the last year. The cumulated values will be posted with the migration date as valuation date.
  • Remove all master records that are not active.
  • Assets under construction: create a separate fixed asset account (general ledger account) in the legacy system and create a transfer posting from the asset master record to this account.
  • Down payments for assets under construction: create a separate fixed asset account (general ledger account) in the legacy system and create a transfer posting from the asset master record to this account.

Migration during a fiscal year  (for example, August 31, 2010)

The transfer date is in the fiscal year that follows the last closed fiscal year (transfer during the fiscal year). For mid-year migration, all of the business transactions in the legacy system are processed up to the cut-off date.Proceed as follows in asset accounting:

  • Extract the cumulated values from the previous year and the transactions from the current fiscal year (up to the cut-off date). The cumulated asset values (such as acquisitions, retirements, transfer postings, depreciation) from the last closed fiscal year and all transactions (such as such as acquisitions, retirements, transfer postings, depreciation) from the current fiscal year will be transferred.
  • To migrate the asset total values, open all posting periods of the current fiscal year. The current fiscal year is the year of data-transfer-date. Cumulated historical values will be posted with the first day of current fiscal year as valuation date. Current-year postings will be posted with the data-transfer-date as posting date.
  • Remove all master records that are not active.
  • Post all depreciation from the current fiscal year up to and including the cut-off date in your legacy system (if your legacy system allows this).
  • Assets under construction: create a separate fixed asset account (general ledger account) in the legacy system and create a transfer posting from the asset master record to this account.
  • Down payments for assets under construction: create a separate fixed asset account (general ledger account) in the legacy system and create a transfer posting from the asset master record to this account.

Note the following information when filling the migration template:

To create a valid source file, enter your legacy data in the  extended  migration template for fixed assets. You can download the migration template using the Prepare for Data Migration  activity in the  Prepare  phase, or using the Perform Data Extraction  activity in the  Fine-Tune  phase of the  Activity List.

If you use extension fields in the work center views that are associated with this migration object, make sure that all extensions fields have been implemented  before you download the migration template. Otherwise, the extensions fields will not be available int the migration template.

  1. Fill one migration template for each company (migration unit) you migrate : For each company, a complete set of accounting data is migrated as a unit. Therefore, you need one source file per migration object and per company.
  2. Enter each fixed asset that you want to migrate on the  Master Data  sheet : Enter the organizational assignment on this sheet as well. If profit center reporting for the company is active, enter a profit center or a cost center. If a cost center is entered, the program will derive the corresponding profit center from the cost center. This applies as well for segments, if segment reporting is active in the company.
  3. If the asset is a sub-asset, enter the master asset ID in the  Master Inventory ID  field. Note that the master asset ID must be lower than the ID of the sub-asset and it must precede the sub-asset ID in the migration template.
  4. Enter the acquisition date and capitalization date of the asset on the  Set of Books  sheet for every set of books separately. If the asset is handled as a low-value asset in the set of books, enter  X  in the  Low Value Asset  column.
  5. Enter the asset valuation parameters for every valuation view separately on the  Asset Valuation sheet.
  6. Enter all asset movements for every valuation view separately on the  Asset Posting Lines  sheet.
  7. Enter acquisitions as positive amounts and depreciations as negative amounts in the migration template.

Enter the following details, depending on when you migrate:

Migration at the end of a fiscal year  (for example, December 31, 2010)

  • Historical cumulated acquisition :
    • Transaction Type: Migration of Accumulated Values (Last Period Previous Year)
    • Line Item Type: Historical Cost
    • Posting Date and Valuation Date: last day of fiscal year (December 31, 2010)
  • Historical cumulated depreciation
    • Transaction Type: Migration of Accumulated Values (Last Period Previous Year)
    • Line Item Type: Accumulated Depreciation
    • Posting Date and Valuation Date: last day of fiscal year (December 31, 2010)

Migration during a fiscal year  (for example, August 31, 2010)

  • Historical cumulated acquisition
    • Transaction Type: Migration of Accumulated Values (Current Year)
    • Line Item Type: Historical Cost
    • Posting Date and Valuation Date: first day of current fiscal year (January 01, 2010)
  • Historical cumulated depreciation
    • Transaction Type: Migration of Accumulated Values (Current Year)
    • Line Item Type: Accumulated Depreciation
    • Posting Date and Valuation Date: first day of current fiscal year (January 01, 2010)
  • Acquisition during current fiscal year
    • Transaction Type: Acquisition
    • Line Item Type: Historical Costs: Current Year
    • Posting Date and Valuation Date: acquisition date
  • Sum of depreciations during current fiscal year
    • Transaction Type: Periodic Depreciation
    • Line Item Type: Periodic Regular Depreciation
    • Posting Date and Valuation Date: migration date (August 31, 2010)

I hope this document will help you with the fixed asset migration process.

Best of Luck.

Regards,

Harshal Vakil