This chapter contains these topics:
Print cost reports to review and analyze equipment costs and transactions, such as equipment account balances, variances between costs and revenues, and so on.
Printing cost reports consists of the following tasks:
Printing the Equipment Cost Analysis report
Printing the Equipment Variance report
Printing the Transaction Ledger report
Working with Report Writer
Working with World Writer reports
From Equipment/Plant Management (G13), choose Cost Inquiries and Reports
From Cost Inquiries and Reports (G1312), choose Equipment Cost Analysis
You can print the Equipment Cost Analysis report to review account balances for specific pieces of equipment. The report shows acquisition costs, depreciation amounts, revenue and expense amounts, and so on, for the equipment that you specify. You can analyze these amounts in month-to-date, year-to-date, or inception-to-date increments.
You can use processing options to show the equipment usage amounts in units, such as miles or hours. You can review the total units a piece of equipment has accumulated, as well as the per unit cost. The system derives per unit costs by dividing account balances by total accumulated units.
You can choose from three versions of this report:
Version | Description |
---|---|
Detail | Shows account balances for each business unit and object account. |
Summary | Shows interim total amounts only, such as:
|
Object | Shows the summarization of identical object accounts that belong to different business units. |
You can use processing options to determine the ledger type that you want to review. You can also omit items with zero account balances. Using data selections, you can print this report for selected companies, business units, category codes, and so on.
From Equipment/Plant Management (G13), choose Cost Inquiries and Reports
From Cost Inquiries and Reports (G1312), choose Equipment Variance Report
Print the Equipment Variance report to review the total revenues and expenses generated by a piece of equipment, as well as the variance between revenue and expenses.
You can view usage hours and other unit costs for each item that you print. A grand total of revenue, expense, and usage amounts for all items prints at the end of the report.
You can use processing options to define the range of accounts that you want the system to use for calculating amounts. You must define an account range for the Standard Amount column, which represents revenue totals, and for the Actual Amount column, which represents expense totals. You must also specify the accounts from which unit amounts are drawn for the Actual Hours column.
The Estimated Rate, Actual Rate, and Rate Variance columns represent unit costs. The system calculates these unit costs by dividing revenue and expense amounts by actual hours.
Use processing options to specify a date range and indicate whether you want the report to print inception-to-date amounts. If you indicate inception-to-date amounts, the system adds prior year balances to the amounts that are within the date range you specify.
You can print two versions of the Equipment Variance report:
Version | Description |
---|---|
Variance by job | Prints amounts for equipment items that you have assigned to a particular location |
Variance by item | Prints information about the pieces of equipment that you specify |
See Section 58.11, "Equipment Variance Report - by Item (P13400)"
See Section 58.12, "Equipment Variance Report - by Job (P13400)"
From Equipment/Plant Management (G13), choose Cost Inquiries and Reports
From Cost Inquiries and Reports (G1312), choose Transaction Ledger
You can print the Transaction Ledger report to review all the transactions for a piece of equipment. The report prints the transactions by company and in the order that they occurred. You can view the item number, the affected account, a brief explanation, the G/L date, a dollar and unit amount, and so on, for each transaction. The report shows currency and unit totals for each company.
This section contains the following:
The transactions that print on the Transaction Ledger report come from the Account Ledger table (F0911), which stores journal entry audit trails. Unless you specify otherwise, the report includes all equipment transactions that have accumulated in the Account Ledger since the ledger was last summarized.
You can run two versions of this report:
Version | Description |
---|---|
Posted | Prints equipment transactions that are posted to equipment and the general ledger. |
Unposted | Prints equipment transactions that are not posted to equipment. The transactions are not necessarily posted to the general ledger. |
Figure 50-1 Fixed Asset Ledger - Posted report
From Equipment/Plant Management (G13), choose Cost Inquiries and Reports
From Cost Inquiries and Reports (G1312), choose Report Writer
You can use Report Writer to maintain and print various versions of the Spreadsheet Tool for Asset Reporting (STAR). Report Writer performs functions similar to the standard DREAM Writer Version Selection, but you can define your report columns to suit your needs. Report Writer reports on information the system stores in the Item Master table (F1201) and the Item Balances table (F1202).
You can use World Writer reports to access information from all the tables on your system. You can create World Writer reports from any record or table in your database. JD Edwards World provides several predefined reports based on specific tables. In Equipment/Plant Maintenance, these tables are as follows:
License Master (F1206)
Location Tracking (F1204)
Status History (F1307)
Maintenance Schedule (F1207)
You can access several predefined World Writer reports by choosing the following navigation paths:
From the Equipment Information menu (G1311), choose World Writer Reports. The following reports are available:
· License Renewal Report
· Equipment Status History Report
From the Equipment Location Tracking menu (G1314), choose Location World Writer Reports. The following reports are available:
· Equipment Location History Report
· Equipment Location Detail with Remarks Report
· Equipment Location Detail with Audit Trail Report
From the Equipment/Plant Maintenance menu (G1315), choose World Writer. The following reports are available:
· Percent Complete Report - Item
· Percent Complete Report - Unit
· Work Order Status History Report