Adjusting multiple assets (Mass Adjustment)

Use the Mass Adjustment method when you need to change many assets. When you make mass changes to asset and asset book information, the system-generated general ledger journal entries are automatically added and cannot be changed or rejected online.

You can select groups of assets to adjust by:

  • Company

  • Location

  • Division

  • Asset group

  • Accounting group

For example, you might change the type, account group or accounting unit group for several assets within the same company, location, or division.

You might use mass adjustments if a corporation has reorganized its General Ledger reporting hierarchy and needs to move all assets currently in Administration to Accounting.

Procedure flowchart: Mass adjustment

Mass adjust assets

  1. Access Mass Adjustment Selections (AM25.1) and define a selection name containing the selections for the mass adjustment.
  2. Select assets for the adjustment. Specify this information:
    Company

    You must select the company affected by the adjustment.

    Company, Lease, Location, Division, Asset Group, Property, Type, Category

    You can select values in one or more of these fields to limit the assets available for selection.

    Select All

    To select all or most of the assets that fit the selection:

    1. Specify Y in the Select All field.

    2. Use the Load form function to display the assets that meet the selection criteria that you specified in the From fields.

    3. Add the mass transfer selection record.

    4. An X appears next to all selected assets.

    5. To deselect any assets that you do not want to include in the transfer, specify N in the Select All field and then specify D in the SC field.

      If more than eight assets meet the selection criteria, you must page down the list and continue to delete the assets that you do not want to transfer.

    6. Click the Change button to accept the revised selection.

      To select only a few of the assets that fit the selection:

    7. Specify N in the Select All field.

    8. Use the Load form function to display the assets that meet the selection criteria that you specified in the From fields.

    9. Specify A in the SC field to mark the assets that you want to transfer.

      If more than eight assets meet the selection criteria, you must page down the list and continue to add the assets that you want to transfer.

    10. Add the transfers.

    11. An X appears next to all selected assets.

    Total

    Click the Total button after you have made the selections to view the number of assets selected and their total cost.

    Filter button

    You can click the Filter button to open the Mass Adjustment Filter subform and limit the assets that display for selection:

    1. Select Yes in the Enable field to enable the filter.

    2. Select the location detail, accounting unit group, accounting unit, or asset list. for which you want to display assets.

    3. Click on the Checkmark (OK) to enable the display.

  3. Define adjustment information.
    1. Access Mass Adjustments (AM125).
    2. Select the Selection Options tab to specify the selection name, defined on AM25.1, the adjustment date, and the date type used.
    3. Select the Asset Adjustments tab to define asset values you want to change. You can change:
      • Work in Process

      • Simulated

      • Tax Exempt

      • Used

      • Type

      • Asset Group

      • Account Group

      • Accounting Unit Group

      • Accounting Unit

      • Depreciation Expense Activity

      • Depreciation Expense Account Category

    4. Use the Asset Book Adjustments tab to define the asset book values you want to change. You can adjust only one book at a time. You can change:
      • Method

      • Life

      • Remaining Life

      • In-Service Date

      • Convention

      • Status

      • Life Years

  4. Verify accuracy of adjustments by running AM125 with N in the Release field.
  5. Change or delete the adjustments.
  6. Release adjustments.
    1. Specify Y in the Release field on the Selection Options tab and select the change form function.
    2. Submit the job.
  7. Process released adjustments using AM170.
    Note: This procedure can transfer journal entries to the General Ledger and to the Strategic Ledger. These journal entries are posted as part of the General Ledger and Strategic Ledger processing cycles.

Related reports and inquiries

To Use
List results of mass adjustment Adjustment Report (AM225)