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.
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 locate a specific asset, complete the following field:
Item Number (Asset Number)
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)
To review more information, choose Full Detail (F4).
Figure 13-2 Cost Summary (Full Detail) screen
To review the posted transactions for an individual account balance, choose Item Transaction Inq.
Figure 13-3 Item Transaction Inquiry screen
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 |