13 Review Asset Costs

This chapter contains the topic:

Review asset costs when you want to see inception-to-date, year-to-date, and month-to-date account balances for individual assets. You can also review the detailed general ledger transactions (F0911 records) that have been posted to the Item Balances table (F1202) for an individual account balance.

13.1 Reviewing Asset Costs

Navigation

From Fixed Assets (g12), choose Cost Information and Reports

From Cost Information and Reports (G1213), choose Cost Summary

Cost accounts, or object accounts, each represent a type of cost. Examples of costs accounts include:

  • Labor

  • Parts

  • Materials

When you review costs by cost accounts, you get a financial perspective of business costs. View costs by cost account when you want to access:

  • All account balances relating to a specific asset

  • Asset acquisition costs, depreciation amounts, revenue, maintenance expense, operating expense, and so on for a specific period

  • Abbreviated income statement and balance sheet information for an asset

To review asset costs

On Cost Summary

Figure 13-1 Cost Summary screen

Description of Figure 13-1 follows
Description of "Figure 13-1 Cost Summary screen"

  1. To locate a specific asset, complete the following field:

    • Item Number (Asset Number)

  2. To specify the costs that you want to review, complete the following optional fields:

    • From Date/Period

    • Through Date/Period

    • Ledger Type

    • Detail/Summary (D/S/O)

    • Units/Unit Cost (Y/A/B)

    • Subledger/Type (*=All)

  3. To review more information, choose Full Detail (F4).

    Figure 13-2 Cost Summary (Full Detail) screen

    Description of Figure 13-2 follows
    Description of "Figure 13-2 Cost Summary (Full Detail) screen"

  4. To review the posted transactions for an individual account balance, choose Item Transaction Inq.

    Figure 13-3 Item Transaction Inquiry screen

    Description of Figure 13-3 follows
    Description of "Figure 13-3 Item Transaction Inquiry screen"

  5. To add or review any generic text notes attached to journal entries, choose Generic Text (F14).

Field Explanation
From Date/Period The beginning date of the range in a search. If you do not specify a beginning date, the system uses the current date.

Form-specific information

The Cost Summary programs are date-sensitive. If you do not specify a beginning date, the system uses the first day of the current fiscal year.

Through Date/Period A number that identifies either a fiscal period (numbers 1 to 14) or an ending date. The screen includes information through this date.

Form-specific information

The Cost Summary programs are date-sensitive.

Detail/Summary (D/S/O) Enter the following values, as needed:

D – No summarization

O – Object account level of summarization when sequencing by object

R – Subsidiary account level of summarization when sequencing by subsidiary

S – Complete summarization by Automatic Accounting Instruction object account

When sequencing by object account, D and O are valid values. S is valid only for Fixed Assets. When sequencing by subsidiary account, D is a valid value. R is valid only for Equipment Management.

Note: To see the transaction ledger for a particular account, do not choose D (No summarization). Note, however, that miles and units always display in a summarized amount.

You define how the system summarizes accounts in the set up of the AT automatic accounting instructions (AAIs).

Units/Unit Cost (Y/A/B) A code that determines whether the system displays amounts or statistical units. You can use statistical units to track equipment information for a piece of equipment. Valid values are:

N – Display currency amounts. This is the default value.

Y – Display statistical units such as hours. The statistical units you define for this code are stored in the AT00 automatic accounting instruction.

A – Display statistical units such as those used to indicate fuel consumption. The statistical units you define for this code are stored in the FMA automatic accounting instruction.

B – Display statistical units such as miles. The statistical units you define for this code are stored in the FMB automatic accounting instruction.

Equipment can accumulate usage amounts based on hours, miles, fuel, and so on. When you display equipment costs by units or unit cost, the first account listed shows the number of units that have accumulated for that piece of equipment. The remaining account balances reflect actual amounts divided by the total units or a per unit cost for each account.

Ledger Type The user defined ledger type code (list 09, type LT) that identifies the account ledger, or book, for the asset. You can maintain as many sets of depreciation books (ledger types) for an asset as you need so you can depreciate an asset in different ways for different purposes. For example, an asset might have a three-year life for tax purposes, but a five-year life for financial statement purposes. Each set of books can have different depreciation methods and depreciation values.

Form-specific information

The system assigns a default ledger type of AA (Actual Amounts) for this field.

Subledger - G/L A code that identifies a detailed auxiliary account within a general ledger account. A subledger can be an equipment item number, an address book number, and so forth. If you enter a subledger, you must also specify the subledger type.

Form-specific information

You can identify work orders as subledgers in your system. Work orders are often the most common subledgers in the Fixed Assets and Equipment/Plant Management systems.

Subledger Type A user defined code (00/ST) that is used with the Subledger field to identify the subledger type and subledger editing. On the User Defined Codes screen, the second line of the description controls how the system performs editing. This is either hard-coded or user defined. For example:

A – Alphanumeric field, do not edit

N – Numeric field, right justify and zero fill

C – Alphanumeric field, right justify and blank fill


13.1.1 What You Should Know About

Topic Description
Detailed transactions Detailed transactions (F0911 records) appear only under the following circumstances:
  • Account balances were not updated directly by a conversion program that did not create detailed transactions to support the balances.

  • Transactions are not summarized by the G/L Summarization program.

Generic text notes You can attach free-form notes to individual documents displayed on Item Transaction Inquiry by using the generic text function. Documents that have notes attached are indicated by a highlighted document number in the Document field.
Open purchase orders You can use the Open Orders function to access Open Order Inquiry to review any open purchase orders.