Fixed Asset Rotables—Basic Data and Requirements Exercises

IMPORTANT
It is extremely important that you set up and work within your own company to maintain your data integrity. If you work within any other company, your exercises will not function as intended and the data of other students might be affected. Predictable exercise results require that your data is isolated in your own company.  Use the basic data that makes sense for your company, customers, and suppliers in order to approximate the results of this exercise.

Main Exercises

Accounting Basic Data

Introduction: Since a Rotable is an inventory part that rotates through ownership, usage, and maintenance processes, a site, rotable part, and rotable pool must exist before it can be connected to Fixed Assets.  Complete the Rotables - Distribution Basic Data and Requirements Exercise before this exercise.  

Purpose: The purpose of these exercises is to ensure that the correct basic data exists in accounting to create, maintain, and work with a fixed asset rotable part.  If none of the rotable parts are going to be created as fixed assets, then this process is not required.

Set a Code Part up for Fixed Assets Accounting

Windows:
Define Code String

  1. Open the window and populate it.
  2. Verify whether there is a Code Part already set up for FA Accounting.
  3. If not, then enter data similar to the following:
Code Part Internal Name Code Used Code Part Function Logical Code Part
Select one that is not already in use Assets Yes FA accounting Object
  1. Save your changes.

Create Accounts for Rotable Part Pool Assets 

Windows:
Accounts

  1. Query for asset acquisition and depreciation accounts.
  2. Review the existing accounts.
  3. Add accounts as necessary for the Rotable Part Pool Assets for acquisition, depreciation counter posting, and depreciation cost similar to the following:
Account Account Description Acount Type Account Group "Asset" Code Part
1515 Rotable Part Pool Assets Assets 153 Mandatory
1615 Accumulated Depreciation - Rotables Assets 160 Mandatory
8015 Depreciation Cost - Rotables Cost 800 Can
  1. Save your changes.

Create an Acquisition Account for Rotable Part Pool Assets 

Windows:
Acquisition Accounts

  1. Populate the window.
  2. Add your Rotable Part acquisition account if it has not already been added.
  3. Save. 

Select a Book to be used by Fixed Asset Rotable Parts

Windows:
Fixed Assets Books

  1. Open and populate the window.
  2. Determine which book or books will be used for the Fixed Asset Rotable Part Pools and check the Rotable Pool Book check box for the selected book(s).
  3. Save any changes.

Note: The Internal Book (sometimes called the GL Book) will be checked, but other books might also be used for Rotables depending on the way assets are handled for the company.

Create a Depreciation Method to be used by Rotable Pool Objects

Windows:
Depreciation Method

  1. Query for the existing "SL BP" method.
  2. Duplicate the method and rename the method.
  3. Set the Non Depreciable Base Value to 60%.
  4. Save your changes.

Create an Object Group

Windows:
Object Group

  1. Create a new Object Group.
  2. Enter your Rotable Part acquisition account number and save.
  3. In the Base Value Types tab, select a Base Value from the list of values and save.
  4. In the Depreciation Methods and Books tab, create a new line for each book to be used by the Rotable assets.
  5. Select the Rotable Depreciation Method, enter the estimated life for the asset group, and save.
  6. In the field Acquisition Reason, select an acquisition reason from the list of values and save.
  7. Your results should look something like the following:
Object Group Description Account Base Values Tab / Base Value Type Depr Method and Books Tab/ Book Depr Method and Books Tab/ Depreciation Method Depr Method and Books Tab/ Estimated Life
Rotable FA Rotable Part Group 1515 REPL Internal Rotable 0500 (for 5 year life)
  1. Anytime you create a new Object Group, you must go to Posting Control and add the Object Group to any fixed asset posting types that use Object Group as a control type.

Set up Fixed Assets Rotable Posting Control

Windows:
Posting Control

  1. Query for FAP posting types.
  2. Add your new Object Group to the detail of any posting type that uses Object Group as the Control Type.
  3. Save.
  4. Now Query for Posting Types using the Description value "%object%;%asset%" to verify whether the following Posting Types have been set up or not.
  5. Enter the following posting controls if they have not already been set up:
Posting Type Posting Type Desc Code Part Name Control Type Default Value
FAP19 Scrap Pool Object, counter posting, acquisition value Account AC1 9320
FAP20 Scrap Pool Object, counter posting, accumulated depreciation Account AC1 9320
FAP21 Import Pool Object, acquisition value Account AC2 Preposting
FAP22 Import Pool Object, counter posting, acquisition value Account AC1 9310
FAP23 Import Pool Object, accumulated depreciation, balance accounting

This control type should be set up the same way as FAP3.

Same as FAP3 Same as FAP3 Same as FAP3
FAP24 Import Pool Object, counter posting, accumulated depreciation Account AC1 9310
FAP33 Import Pool Object, change net value, balance account Same as FAP3 Same as FAP3 Same as FAP3
FAP34 Import Pool Object, counter posting, change net value Account AC1 9310
M141 Fixed Asset Pool - Part Imported Account AC1 9310
M151 Pre Accounting Fixed Asset Pool - Part Acquired Account AC2 Preposting
M151 Pre Accounting Fixed Asset Pool - Part Acquired Asset AC2 Preposting
  1. Save your changes.