E JD Edwards EnterpriseOne Fixed Assets Reports

This appendix contains the following topics:

E.1 Fixed Assets Reports

Print and review fixed asset reports to access necessary information to manage the company's fixed assets. You can print these types of fixed assets reports:

  • Asset information reports.

  • Depreciation reports.

  • Integrity reports.

  • Quarterly and year-to-date reports.

E.1.1 Asset Information Reports

You can print asset information reports at any time with the report versions that are included in the JD Edwards EnterpriseOne Fixed Assets system. Use asset information reports to verify the fixed asset information that the system stores in the table F1201.

E.1.2 Depreciation Reports

The JD Edwards EnterpriseOne Fixed Assets system includes depreciation reports that you can use to review selected depreciation information.

E.1.3 Integrity Reports

Run integrity test programs to supplement the internal balancing procedures by locating potential balancing problems and data inconsistencies. Integrity test programs generate reports to help ensure that the JD Edwards EnterpriseOne systems remain in balance. For example, the Asset Account Balances File table (F1202) might be out-of-balance with the general ledger under these circumstances:

  • Journal entries are posted to the general ledger but not to fixed assets, or vice versa.

  • You made changes to the fixed asset (FX) range of accounts in the automatic accounting instructions (AAIs) and did not include an account that might have been previously included in the FX range, or vice versa.

  • You made changes to the general ledger account numbers and have not run the Update Company Number, Business Unit/Object/Subsidiary program (R12802).

  • Asset account records have been purged from the Account Balances table (F0902), but not from table F1202.

You can use integrity reports to identify and correct balance errors immediately. In general, you run integrity reports at least once a week during the conversion process at new installation sites or during a learning period for new users. All other users should run integrity reports on a monthly basis, at a minimum.

Note:

Before you run integrity reports, you must post all fixed asset transaction batches. The system performs integrity tests only on posted records.

E.1.4 Quarterly and Year-to-Date Reports

The JD Edwards EnterpriseOne Fixed Assets system includes quarterly and year-to-date reports that you can print to review selected fixed asset information.

E.2 JD Edwards EnterpriseOne Fixed Assets Reports: A to Z

These tables list the JD Edwards EnterpriseOne Fixed Assets reports, sorted alphanumerically by report ID. This section discusses:

  • Asset information reports.

  • Depreciation reports.

  • Integrity reports.

  • Quarterly and year-to-date reports.

E.2.1 Asset Information Reports

This table lists the asset information reports:

Report ID and Report Name Description Navigation
R12301

Unposted Fixed Asset Transactions

You can print a journal entries report to review a list of all the transactions that have been posted to the general ledger and are eligible to post to fixed assets, but have not yet been posted to fixed assets. Posting G/L to Fixed Assets (G1212), Unposted Fixed Asset Transactions
R12400

Supplemental Data Report by Asset

Use this report to review supplemental information for the JD Edwards EnterpriseOne Fixed Assets system by asset. This report includes this information:
  • Asset number

  • Parent Company

  • Location

  • Type of data

  • Quantity

  • Date information

Note: The report is hard-coded for supplemental database code AM.

Batch and Interactive Version (GH0983), Batch Versions
R12410

Asset Master Schedule

You can print the Asset Master Schedule report to review the information that you enter on the Asset Master Revisions form when you create asset master records. Cost Information & Reports (G1213), Asset Master Schedule
R12420

F/A Transaction Ledger

Use this report to review all of the transactions for an asset, printed by company in the order that they occurred. You can view the asset number, the affected account, a brief explanation, the GL date, a currency and unit amount, and so on for each transaction. The report shows currency and unit totals for each company. Posting G/L to Fixed Assets (G1212), F/A Transaction Ledger
R12421

Assets by Finance Method

To review the information that you entered for assets on the Financing Information form, print the Assets by Finance Method report. Cost Information & Reports (G1213), Assets by Finance Method
R12424

Cost Analysis

You can print this report to review the various costs that are associated with an asset. Cost Information & Reports (G1213), Cost Analysis
R12428

Units of Production

You can print this report to review all of the schedules that you have set up for the Units of Production depreciation method. Advanced Operations (G1231), Units of Production
R12440

Supplemental Data Report by Data Type

Use this report to review supplemental information for the JD Edwards EnterpriseOne Fixed Assets system by data type. This report lists this information:
  • Data type information

  • Asset number

  • Date information

Note: The report is hard-coded for supplemental database code AM.

Batch and Interactive Version (GH0983), Batch Versions
R12460

Location Tracking Report

Use this report to review current, historical, and planned locations for selected assets. This report prints information from the table F1204.

The report information is the same information that you can review on the Work With Locations form.

Transfers, Splits, & Disposals (G1222), Print Location Information
R12800

Post G/L Entries to Assets

This report indicates whether journal entries were successfully posted and identifies any automatic processes that occurred during the post. Posting G/L to Fixed Assets (G1212), Post G/L Entries to Fixed Assets
R12800E

Fixed Assets Detail Error

This report identifies all of the journal entries that were not posted and provides an explanation. The Fixed Assets Detail Error report also identifies any automatic processes that might have occurred during the post. Posting G/L to Fixed Assets (G1212), Post FA Detail Error Report

E.2.2 Depreciation Reports

This table lists the depreciation reports:

Report ID and Report Name Description Navigation
R12002P

Depreciation Defaults

After you set up the depreciation default information, you can generate the Depreciation Default report to review the depreciation values by company, object, and subsidiary. Cost Information & Reports (G1213), Depreciation Defaults Report
R12411

Depreciation Schedule

You can print this report to review a list of assets and their corresponding depreciation expense and net book value amounts for each ledger. You can specify the sequence of this report by depreciation expense account or by accumulated depreciation account as of any date. Cost Information & Reports (G1213), Depreciation Schedule
R12851P

Depreciation Rules

You can print each depreciation rule that you have defined for the JD Edwards EnterpriseOne Fixed Assets system. The Depreciation Rules Report shows this information:
  • Depreciation method

  • Computation method

  • Depreciation information

  • Life months

  • Date from

  • Effective beginning date

Cost Information & Reports (G1213), Depreciation Rules Report
R12854

Spread Pattern

You can print all codes in the spread pattern file with the associated period spread percentages. Cost Information & Reports (G1213), Depreciation Spread Pattern Print

E.2.3 Integrity Reports

This table lists the integrity reports:

Report ID and Report Name Description Navigation
R12301

Unposted Fixed Asset Transactions

Print the Unposted Fixed Asset Transactions report to review the transaction ledger table. Any fixed asset transactions that are within the FX range in the AAIs and are posted to the general ledger, but not to fixed assets, appear on this integrity report. Fixed Asset Integrity Reports (G1224), Unposted Fixed Asset Transactions
R127011

Integrity Test - F/A to G/L

Use this report to compare account records in the Asset Account Balances File table (F1202) to the records in the Account Balances table (F0902). Fixed Asset Integrity Reports (G1224), Fixed Assets to G/L Integrity
R127012

Fixed Asset Transaction Integrity

Print this report to review all of the transactions in the Account Ledger table (F0911) for a specific account during the current fiscal year. The current fiscal year is based on the company that is associated with a particular account.

Before running this report, you must:

  • Post any transactions to the general ledger that have not yet been posted.

  • Post any transactions to fixed assets that have not yet been posted.

Fixed Asset Integrity Reports (G1224), Fixed Asset Transaction Integrity
R127013

Integrity Test - G/L to F/A

You can use this report to compare account records in the general ledger balance table to the records in the fixed assets balance table. You use this report to find transactions that have been posted to the general ledger but have not been posted to the JD Edwards EnterpriseOne Fixed Assets system. If you are in a multicurrency environment, you can run this report over ledgers that reflect alternate currencies. Fixed Asset Integrity Reports (G1224), G/L to Fixed Assets Integrity

E.2.4 Quarterly and Year-to-Date Reports

This table lists the quarterly and year-to-date reports:

Report ID and Report Name Description Navigation
R12422

Property Tax Worksheet

Print the Property Tax Worksheet to review summarized totals for assets by tax entity and year acquired. You can use the Property Tax Worksheet to prepare the property taxes for local governing authorities. The worksheet includes a work area for the tax preparer's notes. Year End Processes (G1225), Property Tax Worksheet
R12430

Depreciation Expense

Print this report to review an asset's current cost, depreciation expense, and net book value for a specific fiscal period, quarter, or year. Quarterly & YTD Fixed Asset Reports (G1223), Depreciation Expense Report
R12431

Fixed Asset Reconciliation

Run this report to help you reconcile a specific asset or all assets for a company. Run this report by asset to review the account activity for an asset's cost and accumulated depreciation. You can use the report to reconcile activity for a particular quarter or the entire fiscal year. Quarterly & YTD Fixed Asset Reports (G1223), Fixed Asset Reconciliation
R12432

Fixed Asset Retirement

Print this report to review the gain or loss on the disposal of an asset for any ledger. Quarterly & YTD Fixed Asset Reports (G1223), F/A Retirements
R12433

Depreciation and Amortization

Print this report to review asset cost and year-to-date depreciation as of the fiscal year that you specify for the report. You might use this report when preparing taxes. The information in the Depreciation and Amortization report can be especially helpful if you need to prepare an IRS Form 4562. Quarterly & YTD Fixed Asset Reports (G1223), Depreciation & Amortization Report
R12434

Sale of Business Property

Print this report to review information about disposed assets. You can print the Sale of Business Property report for personal property or real property. You might want to use these reports when you prepare taxes. The information in the Sale of Business Property report can be especially helpful if you need to prepare an IRS Form 4797. Quarterly & YTD Fixed Asset Reports (G1223), Sale of Business Property
R12435

Account Reconciliation

Print this report to help you reconcile the activity of a specific account or all of the accounts for a company. Quarterly & YTD Fixed Asset Reports (G1223), F/A Account Reconciliation

E.3 JD Edwards EnterpriseOne Fixed Assets Reports: Selected Reports

Some reports include a more detailed description, as well as information about processing options. These reports are listed alphanumerically by report ID in this section.

E.3.1 R12002P - Depreciation Defaults Report

These abbreviated column headings appear in the Depreciation Defaults Report:

Abbreviated Column Heading Description
LT Ledger Type
DM Depreciation Method
DI Depreciation Information
MC Method of Computation

E.3.2 R12301 - Unposted Fixed Asset Transactions Report

The FX range of AAIs identifies the beginning and ending range of asset accounts that can be posted to fixed assets.

The information in the report is the same information that you view on the Work with Unposted Entries form by choosing the Unposted option in the Fixed Asset Post/Passed Code field.

Important:

If you post a journal entry through the batch post process that does not include an asset number, the message No Item Master Record appears on the report. You should create a master record for the asset and attach the new asset number to the journal entry. If you attempt to interactively post a journal entry without an asset number, you receive an error message.

E.3.3 Processing Options for the Unposted Fixed Assets Transactions (R12301) Report

Set these processing options before you run this report.

E.3.3.1 Display

Use these processing options to specify the information that is printed on the report.

Display Asset Number

Specify which number the system prints to identify the asset. Values are:

1: Print the asset number.

2: Print the unit number.

3: Print the serial number.

E.3.4 R12410 - Asset Master Schedule Report

For each asset that you specify, the report lists this information:

  • First three category codes.

  • Parent.

  • Asset, unit, and serial numbers.

  • Responsible business unit.

  • Date acquired.

  • Property tax information.

These abbreviated column headings appear on the Asset Master Schedule Report:

Abbreviated Column Heading Description
Acc Cls Accounting Class
Eqm Cls Equipment Class
Mfg Manufacturer
Mdl Yr Model Year
Use M/H Usage Miles or Hours
ST State

E.3.5 R12411 - Depreciation Schedule

The Depreciation Schedule report shows the balances in the table F1202 without computing depreciation.

You can also use the Depreciation Schedule report after you enter the beginning balances for assets during the conversion process to the JD Edwards EnterpriseOne Fixed Assets system. You can use this report as a tool to review the entries and help you reconcile differences between table F1202 and the Account Balances table (F0902).

The Depreciation Schedule report includes this information:

Report Item Description
Cost The original acquisition cost of the asset.
Accumulated depreciation The accumulated depreciation amount of the asset. This amount is a cumulative amount that is calculated according to the depreciation method that you specify for the asset.
Depreciation expense year to date The amount of depreciation that is charged to the asset thus far this year.
Depreciation expense current The amount of depreciation that is charged to the asset since the last final depreciation. This amount is based on the date that you specify for the report.
Net book value (NBV) The difference between the asset cost and its accumulated depreciation.
Remaining (REM) life The periods remaining until the asset is fully depreciated. If the disposal date of the asset is prior to the date when the asset will be fully depreciated, the system uses the month and year to determine the remaining periods that print on the report.

These abbreviated column headings appear in the Depreciation Schedule Report:

Abbreviated Column Heading Description
LT Ledger Type
DM Depreciation Method
DI Depreciation Information
MC Method of Computation

E.3.6 Processing Options for the Depreciation Schedule (R12411) Report

Set these processing options before you run the report.

E.3.6.1 Defaults

Use these processing options to specify the fiscal periods, fiscal years, and ledger types that print on the report.

1. Period

Specify the as of period. Leave this processing option blank to use each company's current fiscal period.

2. Fiscal Year (4 digits)

Specify the as of fiscal year. Leave this processing option blank to use each company's current fiscal year.

3. Ledger Type

Specify a single ledger type for the depreciation schedule. Leave this processing option blank to include all ledger types.

E.3.6.2 Print

Use these processing options to specify the information that is printed on the report.

1. Identify how to print Asset Number

Specify which number the system prints to identify the asset. Values are:

1: Print the asset number.

2: Print the unit number.

3: Print the serial number.

2. Print Assets

Specify which assets the system prints. Values are:

Blank: Do not print assets with zero cost.

1: Print all assets.

3. Remaining periods or End Date

Specify whether the system prints remaining periods or the end date. Values are:

0: Print remaining periods.

1: Print the month and year in which the asset will be fully depreciated.

E.3.6.3 Process

Use this processing option to specify how the system processes the information for this report.

Sequence

Specify how the system sequences the Depreciation Schedule report (R12411). Values are:

1: Sequence the report by accumulated depreciation account.

2: Sequence the report by depreciation expense account.

E.3.7 R12420 - F/A Transaction Ledger Report

The transactions that print on the F/A Transaction Ledger report come from the table F0911, which stores journal entry audit trails. Unless you specify otherwise, the report includes all asset transactions that have accumulated in the account ledger since the ledger was last summarized.

You can run two versions of this report:

  • Posted: Prints asset transactions that are posted to fixed assets and the general ledger.

  • Unposted: Prints asset transactions that are not posted to fixed assets.

    The transactions are not necessarily posted to the general ledger.

These abbreviated column headings appear in the F/A Transaction Ledger report:

Abbreviated Column Heading Description
Do Ty Document Type
LT Ledger Type
HD Hold Code
PC Posted Code

E.3.8 R12421 - Assets by Finance Method Report

The Assets by Finance Method report includes this information:

  • Asset and parent number

  • Description

  • Lessor, renter, or mortgagor

  • Monthly amount owed

These abbreviated column heading appears in the Assets by Finance Method Report:

Abbreviated Column Heading Description
PO Purchase Order

E.3.9 Processing Options for the Assets by Finance Method (R12421) Report

Set these processing options before you run the report.

E.3.9.1 Print

Use this processing option to specify the information that the system prints on the report.

Asset Number Format

Specify which number the system prints to identify the asset. Values are:

1: Print the asset number.

2: Print the unit number.

3: Print the serial number.

E.3.10 R12422 - Property Tax Worksheet Report

The Property Tax Worksheet displays this asset information:

  • Company number and name.

  • Tax entity address book number and mailing information.

  • Accounting and equipment classes.

  • Asset number.

  • Description.

  • Date acquired.

  • Cost.

E.3.11 Processing Options for the Property Tax Worksheet (R12422) Report

Set these processing options before you generate the property tax worksheet.

E.3.11.1 Display

This processing option enables you to specify the acquisition cutoff date. All assets acquired after this date are not displayed on the report.

1. Acquisition Cutoff Date

Specify the acquisition cutoff date. All assets acquired after this date will not be displayed on the report. If this date is left blank, the acquisition cutoff date will be based on the current period ending date for the asset's company.

E.3.11.2 Process

These processing options enable you to specify the date through which the report should be based, and whether you want an additional ledger type for cost reflected on the report.

1. As Of Date

Specify the date through which the report should be based. If this date is left blank, cost will be based on the current period ending date for the asset's company.

2. Additional Ledger Type

Specify an additional ledger type for cost. If an additional ledger type is specified, the report will reflect the cost of this ledger plus the cost of the AA ledger. If this option is left blank, only the AA ledger will be used to determine the cost.

E.3.11.3 Print

These processing options enable you to specify whether you want the assets with zero cost printed on the report and how you want the asset number printed on the report.

1. Omit Assets with Zero Cost

Specify whether or not you want the assets with zero cost printed on the report. Values are:

Blank: Print all assets on the report.

1: Do not print assets with zero cost on the report.

2. Asset Number Format

Specify how you want the asset number printed on the report. Values are:

1: Asset Number.

2: Unit Number.

3: Serial Number.

E.3.12 R12424 - Cost Analysis Report

Use the Cost Analysis report to measure the operating efficiency and effectiveness of assets, such as equipment. You can analyze these amounts in month-to-date, year-to-date, or inception-to-date increments. The Cost Analysis report includes user-defined totals such as:

  • Net book value

  • Revenue earned

  • Ownership costs

  • Operating costs

Two columns on the report require further explanation:

Column Description
Period-to-Date The amount, in currency or units, charged to the asset in the period that you designate in the Through Date/Period for the report.
Period Unit Cost The amount charged to the asset in the period that you designate in the Through Date/Period for the report, divided by a unit (for example, hours) that you designate in the processing options.

In general, you use data selection on cost center, object account, and subsidiary when running the Cost Analysis report. This data selection helps the system find records faster.

These abbreviated column heading appears in the Cost Analysis Report:

Abbreviated Column Heading Description
ST Subledger Type

E.3.13 Processing Options for the Cost Analysis (R12424) Report

Set these processing options before you run the report.

E.3.13.1 Defaults

These processing options enable you to specify the fiscal periods, fiscal years, and ledger types that print on the report.

1. Period/Date

Specify the fiscal year for the period or date that is defined in the Period/Date field. Enter a four-digit fiscal year in this processing option. If you leave this processing option blank, the system uses the date pattern that is established for default company 00000.

2. Fiscal Year

Specify the fiscal year for the period or date that is defined in the Period/Date field. Enter a four-digit fiscal year in this processing option. If you leave this processing option blank, the system uses the date pattern that is established for default company 00000.

3. Ledger Type

Specify the ledger type for cost summary. If you leave this field blank, the system uses the AA ledger.

E.3.13.2 Process

Use these processing options to specify the format of the information that the system shows on this report.

1. Detail or Summary (Future)

Specify how the system summarizes information on the report. Values are:

D: Detailed report.

O: Summarization by object.

R: Summarization by subsidiary.

S: Summarization by AT AAI.

2. Unit Cost Suppression

Specify whether the system prints the Unit Cost columns. Values are:

Blank: Print the Unit Cost columns.

1: Do not print the Unit Cost columns.

3. Unit Cost AAIs

Identify the AAIs that the system uses for units in the Unit Cost columns when it prints unit cost. Values are:

Y: Use the AT00 AAI.

A: Use the FMA AAI.

B: Use the FMB AAI.

E.3.13.3 Print

These processing options enable you to specify the information that the system includes on the report.

1. Zero Cost Print

Specify which assets the system prints. Values are:

Blank: Do not print assets with zero cost.

1: Print all assets.

2. Asset Number Print

Specify which number the system prints to identify the asset. Values are:

1: Print the asset number.

2: Print the unit number.

3: Print the serial number.

E.3.14 R12428 - Units of Production Report

You can use this report at the job site as a worksheet. For example, you can complete the production and revised unit reserves for the assets and then return the information to the main office.

You can run the Units of Production Report by one of these criteria:

  • Schedule number

  • Ledger type

  • Unit of measure

Run the Units of Production Report to review this information:

Report Item Description
Original units The original estimate of the total number of units in the reserve base.
Prior year revisions The cumulative prior-year adjustments to the original estimated units.
Current year revisions The current year adjustments to the original units.
Units of production prior year The number of units that were produced in all prior years.
Depreciable units An amount that is used to calculate the Current Unit of Production Factor. The system calculates this number by using this formula:

Original Units + Prior Year Revisions + Current Year Revisions - Units of Production Prior Year = Depreciable Units

Units of production year-to-date The number of units that were produced year-to-date is used to calculate the Current Unit of Production Factor.

E.3.15 R12430 - Depreciation Expense Report

The report includes the status and depreciation information for each asset. You can use processing options to specify the ledger types, fiscal years, and fiscal periods that print on the report.

E.3.16 Processing Options for the Depreciation Expense (R12430) Report

Set these processing options to specify the ledger types, fiscal years, and fiscal periods that print on the report.

E.3.16.1 Date

Use these processing options to specify the fiscal years and fiscal periods that print on the report.

1. Period Number

Specify the as of period. Leave this processing option blank to use each company's current fiscal period.

2. Fiscal Year (4 digits)

Specify the as of fiscal year. Leave this processing option blank to use each company's current fiscal year.

E.3.16.2 Ledger Type

Use this processing option to specify the ledger type that prints on the report.

Ledger Type

Specify the ledger type for cost summary. If you leave this field blank, the system uses the AA ledger.

E.3.16.3 Print

Use these processing options to specify the asset information that prints on the report.

1. Asset Number Print

Specify which number the system prints to identify the asset. Values are:

1: Print the asset number.

2: Print the unit number.

3: Print the serial number.

2. Print All Assets

Specify which assets the system prints. Values are:

Blank: Do not print assets with zero cost.

1: Print all assets.

E.3.17 R12431 - Fixed Asset Reconciliation Report

This report will not display all of the details for all types of asset transfers. If values such as Company or Business Unit have been transferred, run the Accounts Reconciliation report (R12435) or the Asset Report Writer (R1200001) to display more detailed transfer information.

The Fixed Asset Reconciliation Report includes this information:

  • Beginning balance

    The beginning balance for the asset cost, accumulated depreciation, and net book value of an asset. The beginning balance for the asset cost and accumulated depreciation amounts are as of the end of the period prior to the quarter or the year that you request for the report. The beginning balance for the net book value equals the asset cost beginning balance less the accumulated depreciation beginning balance.

  • Ending balance

    The ending balance for the asset cost, accumulated depreciation, and net book value of an asset. The ending balance for the asset cost and accumulated depreciation amounts equals the beginning balances plus any additions and transfers in, less any transfers out and disposals. The ending balance for the net book value is the difference between the ending balances for the asset cost and accumulated depreciation.

E.3.18 Processing Options for the Fixed Asset Reconciliation (R12431) Report

Set these processing options before you run the fixed asset reconciliation report.

E.3.18.1 Process

Use these processing options to specify the fiscal year, quarter, and ledger types that print on the report.

1. Fiscal Year

Specify the fiscal year for which the system reports activity. If you leave this processing option blank, the system uses the current fiscal year. Enter a four-digit value (for example, 2006).

2. Quarter

Specify the quarter for which the system reports activity. If you specify any value other than Blank (year-to-date), you must specify ledger type AA in the Ledger Type processing option. Values are:

Blank: Year-to-date.

1: First quarter.

2: Second quarter.

3: Third quarter.

4: Fourth quarter.

3. Ledger Type

Specify the ledger type for the reconciliation report. If you leave this processing option blank, the system uses the AA ledger.

Note:

If you specify a ledger type other than AA, leave the Quarter processing option blank to report year-to-date activity.

E.3.18.2 Print

Use these processing options to specify the format of the asset numbers that print on the report.

Asset Number Format

Specify which number the system prints to identify the asset. Values are:

1: Print the asset number.

2: Print the unit number.

3: Print the serial number.

E.3.19 R12432 - Fixed Asset Retirement Report

You can print asset disposal information for actual amounts for a particular quarter or the entire year. You can also print and compare asset disposal information for two ledger types for an entire year, or any time after depreciation is fully calculated for non-AA ledger types.

The Fixed Asset Retirement Report includes this information:

  • Cost.

    The original asset cost plus any additional costs for the asset through the as of date that you specify for the report.

  • First ledger less second ledger.

    The difference between the gain/loss amount of two ledgers, if you are comparing two ledgers on this report. For example, you can compare the book and federal tax gains and losses.

    Note:

    You can print a Fixed Asset Retirement quarterly report for ledger type AA. You cannot print a quarterly report for non-AA ledger types unless the ledger type's depreciation is fully calculated for the year.

E.3.20 Processing Options for the Fixed Asset Retirements (R12432) Report

Set these processing options before you run the fixed assets retirements report.

E.3.20.1 Process

Use these processing options to specify the fiscal year, quarter, and ledger types that print on the report.

1. Fiscal Year

Specify the fiscal year for which the system reports activity. If you leave this processing option blank, the system uses the current fiscal year. Enter a four-digit value (for example, 2006).

2. Quarter

Specify the quarter for which the system reports activity. If you specify any value other than Blank (year-to-date), you must specify ledger type AA in the Ledger Type processing option. Values are:

Blank: Year-to-date

1: First quarter.

2: Second quarter.

3: Third quarter.

4: Fourth quarter.

3. Ledger Type

Specify the ledger type for the reconciliation report. If you leave this processing option blank, the system uses the AA ledger.

Note:

If you specify a ledger type other than AA, leave the Quarter processing option blank to report year-to-date activity.
4. Second Comparison Ledger Type

Specify a second ledger type to be used for comparison reporting. If you leave this processing option blank, the system does not perform comparison reporting.

E.3.20.2 Print

Use these processing options to specify the format for the asset numbers that print on the report.

Asset Number Format

Specify which number the system prints to identify the asset. Values are:

1: Print the asset number.

2: Print the unit number.

3: Print the serial number.

E.3.21 R12433 - Depreciation and Amortization Report

Print the Depreciation and Amortization report for each ledger type that you use. The fiscal year should be the year for which you want to report depreciation taken. For example, if you are preparing the tax report for 2001, you would use fiscal year 01.

If you transfer an asset to another company during the year, the entire depreciation expense amount for the year is reflected on the new company.

The Depreciation and Amortization report includes this information:

  • Depreciation information (DI)

    A code that you use to specify additional depreciation information. The system uses this code for Investment Tax Credit (ITC) and averaging conventions, such as mid-month (M), mid-quarter (Q), and mid-year (Y).

  • Cost

    The original cost plus any additional costs for the asset through the as of date that you specify for the report.

E.3.22 Processing Options for the Depreciation and Amortization (R12433) Report

Processing options enable you to specify the default processing for programs and reports.

E.3.22.1 Print

Use these processing options to specify the fiscal year to print and how to print the asset numbers on the report.

1. Identify how to print asset number.

Specify how to print the asset number. Values are:

1: Print the item number (default).

2: Print the unit number.

3: Print the serial number.

2. Fiscal Year

Specify the four-digit fiscal year designation. You must always use the year in which the first period ends. For example, a fiscal year beginning October 1, 1998 and ending September 30, 1999 is fiscal year 1998.

E.3.23 R12434 - Sale of Business Property Report

The personal property version of the report includes this information:

Report Element Description
Disposal proceeds The amount received on the sale of the asset. The system determines this amount by the account that you set up in the Disposal Account Rules.
Cost The original cost plus any additional costs for the asset through the fiscal year-end date that you specify for the report.
Section 1245 recapture amount The accumulated depreciation or disposal gain amount, whichever is less (but not less than zero).
Section 291 This field does not apply to personal property.
Section 1231 gain/loss The disposal gain or loss, less the recapture amount for assets disposed of after the first year.
Ordinary gain/loss The disposal gain or loss, less the recapture amount for assets disposed of in the first year.

If you report on personal property, the system calculates the last four amount fields as follows:

  • Recapture amount is accumulated depreciation or disposal gain or loss, whichever is less, but not less than zero.

  • Nothing prints in the Section 291 column.

  • Section 1231 gain/loss is disposal gain or loss, minus the recapture amount for assets not disposed of in the first year.

  • Ordinary gain/loss is disposal gain or loss, minus the recapture amount for assets disposed of in the first year.

If you report on real property, the system calculates the last four amount fields as follows:

  • Recapture amount is accumulated depreciation less what accumulated depreciation would have been if using straight-line, inception-to-date method, or disposal gain or loss, whichever is less, but not less than zero.

  • Section 291 is the amount that would go into the recapture amount if personal property, less what went into recapture amount for real property, is multiplied by 20 percent.

  • Section 1231 gain/loss is disposal gain or loss, minus the recapture amount, and minus Section 291 for the asset that is not disposed of in the first year.

  • Ordinary gain/loss is disposal gain or loss, minus the recapture amount, and minus Section 291 for assets that are disposed of in the first year.

The real property version of the report includes this information:

Report Element Description
Disposal proceeds The amount earned on the sale of the asset. The system determines this amount by the account that you set up in the Disposal Account Rules.
Cost The original cost plus any additional costs for the asset through the fiscal year-end date that you specify for the report.
Accumulated depreciation The amount depreciated for the asset through the fiscal year-end date on the report.
Disposal gain/loss The difference between the asset's disposal proceeds and its net book value.
Section 1250 recapture amount The lesser of these amounts:
  • Accumulated depreciation less the depreciation that would have been available under the straight-line method.

  • Gain.

Section 291 Twenty percent of the excess of:
  • The amount that would be recaptured as ordinary income if such property is under Section 1245.

  • The amount recaptured under Section 1250.

Section 1231 gain/loss The disposal gain or loss, less the recapture amount and less Section 291 for assets not disposed of in the first year.
Ordinary gain/loss The disposal gain or loss, less the recapture amount for assets disposed of in the first year.

E.3.24 Processing Options for the Sale of Business Property (R12434) Report

Set these processing options before you run the sale of business property report.

E.3.24.1 Process

Use these processing options to specify the fiscal year, ledger type, and type of property that print on the report.

1. Fiscal Year (4 digits)

Specify the as of fiscal year. Leave this processing option blank to use each company's current fiscal year.

2. Ledger Type

Specify the ledger type for cost summary. If you leave this field blank, the system uses the AA ledger.

3. Type of Property

Specify the type of property to which the report applies. Values are:

1: Personal property.

2: Real property.

E.3.24.2 Print

Use these processing options to specify the format of the asset numbers that print on the report.

Asset Number Format

Specify which number the system prints to identify the asset. Values are:

1: Print the asset number.

2: Print the unit number.

3: Print the serial number.

E.3.25 R12435 - Account Reconciliation Report

Run this report by account to review each item number within an account. You can use this report to reconcile the account's activity for a particular period, quarter, or fiscal year.

E.3.26 Processing Options for the Account Reconciliation (R12435) Report

Set these processing options before you run the account reconciliation report.

E.3.26.1 Process

Use these processing options to specify the fiscal year, quarter, and ledger types that print on the report.

1. Fiscal Year

Specify the fiscal year for which the system reports activity. If you leave this processing option blank, the system uses the current fiscal year. Enter a four-digit value (for example, 2006).

2. Quarter

Specify the quarter for which the system reports activity. If you specify any value other than Blank (year-to-date), you must specify ledger type AA in the Ledger Type processing option. Values are:

Blank: Year-to-date.

1: First quarter.

2: Second quarter.

3: Third quarter.

4: Fourth quarter.

3. Ledger Type

Specify the ledger type for cost summary. If you leave this field blank, the system uses the AA ledger.

E.3.26.2 Print

Use these processing options to specify the format for the asset numbers that print on the report.

Asset Number Format

Specify which number the system prints to identify the asset. Values are:

1: Print the asset number.

2: Print the unit number.

3: Print the serial number.

E.3.27 R127011 - Fixed Assets to G/L Integrity Report

The system prints any records that are not in balance on the report.

E.3.28 Processing Options for the F/A to G/L Integrity (R127011) Report

Set these processing options before you run the F/A to G/A integrity report.

E.3.28.1 Process

Use these processing options to specify the date and ledger types that print on the report.

1. As of Date

Enter the as of date. Leave this processing option blank to use each company's current period.

Note:

The fiscal year specified in the processing options must match the fiscal year that you specify in data selection.
2. Ledger Type

Specify the ledger type for cost summary. If you leave this field blank, the system uses the AA ledger.

E.3.28.2 Print

Use these processing options to specify the accounts that print on the report.

Print Accounts

Specify which accounts the system prints. Values are:

Blank: Print all accounts.

1: Print only those accounts in which the net postings from the Asset Account Balances table (F1202) do not equal the net postings from the Account Balance table (F0902).

E.3.29 R127012 - Fixed Asset Transaction Integrity Report

Use this transaction report to identify problems and discrepancies between the Asset Account Balances File table (F1202) and the Account Balances table (F0902).

The Fixed Asset Transaction Integrity report includes only those transactions that you have posted to the general ledger or fixed assets. The report does not include fixed asset balances that you entered through the Beginning Balances Setup program if you did not specify supporting transactions, nor does it include summarized depreciation transactions. You can specify summarized transactions when you run the final depreciation for the assets.

The report lists these totals for each account:

  • Total of all transactions.

  • Total of all transactions posted to the general ledger and posted to fixed assets.

  • Total of all transactions posted to the general ledger and unable to post to fixed assets.

  • Total of all transactions posted to the general ledger and not yet posted to fixed assets.

  • Total of all transactions not posted to the general ledger but posted to fixed assets.

  • Total of all transactions not posted to the general ledger and unable to post to fixed assets.

    Note:

    The Fixed Asset Transaction Integrity report prints one line per account ledger record. Use data selections to print only the transactions that you need to review for specific accounts and to keep the size of the report manageable.

These abbreviated column headings appear in the Fixed Asset Transaction Integrity Report:

Abbreviated Column Headings Description
General ledger posted code (G/L P C) A code that indicates whether a transaction has been posted to the general ledger.
Fixed asset pass code (F/A P C) A code that indicates whether a transaction has been posted to fixed assets.

The system does not post transactions with an F/A pass code of P to fixed assets. A transaction can have an F/A pass code of P for these reasons:

  • The transaction has an account number that is not included in the FX range of AAIs. The Identify New Entries program assigns P only to transactions that do not fall within the FX range of the AAIs.

  • You manually changed the pass code to P on Revise Unposted Entries so that the transaction would not post to the Asset Account Balances File table (F1202).


E.3.30 R127013 - G/L to Fixed Assets Integrity Report

This report is the most powerful of the integrity reports. It uses the range of accounts that are defined in the FX AAIs to compare the Account Balances table (F0902) to the Asset Account Balances File table (F1202).

Through processing options, you can:

  • Display transaction detail for exception transactions only.

  • Display year-to-date or inception-to-date balances with transaction detail.

The system also reconciles any out-of-balance accounts on a transaction-by-transaction basis. When the system locates an out-of-balance account, it determines the difference between the balances and then processes each general ledger detail transaction as if it had been posted to fixed assets. A new difference is calculated for each detail transaction, attempting to reduce the difference to zero. The posting codes for each line also print and enable you to determine exactly which transactions are causing the problem.

To identify the exception transactions, the system compares the G/L Post Code with the Passed Code for each detail transaction from the Account Ledger table (F0911). This table shows the comparison and result:

G/L Post Code Passed Code Exception Identification
P * OK
P P Exception
P H Exception
P Blank Exception
Blank * Exception
Blank P These do not cause an imbalance between the Account Balances (F0902) and the Asset Account Balances File (F1202) tables. However, the month-end balances might not be accurate without these postings.
Blank H These do not cause an imbalance between the Account Balances (F0902) and the Asset Account Balances File (F1202) tables. However, the month-end balances might not be accurate without these postings.
Blank Blank These do not cause an imbalance between the Account Balances (F0902) and the Asset Account Balances File (F1202) tables. However, the month-end balances might not be accurate without these postings.

E.3.31 Processing Options for the G/L to F/A Integrity (R127013) Report

Set these processing options before you run the G/L to F/A integrity report.

E.3.31.1 Process

Use these processing options to specify the date and ledger types that print on the report and to specify whether the system compares account balances.

1. As of Date

Specify the as of date. Leave this processing option blank to use each company's current fiscal year and period.

2. Ledger Type

Specify the ledger type for cost summary. If you leave this field blank, the system uses the AA ledger.

3. Account Balances

Specify whether the system compares account balances. Values are:

Blank: Compare inception-to-date account balances.

1: Compare year-to-date account balances.

E.3.31.2 Print

Use these processing options to specify the information that prints on the report.

1. Print Accounts

Specify which accounts the system prints. Values are:

Blank: Print all accounts.

1: Print only those accounts in which the net postings from the Asset Account Balances table (F1202) do not equal the net postings from the Account Balance table (F0902).

2. Print Format

Specify the information that the system prints. Values are:

Blank: Print balance information only.

1: Print transaction detail.

E.3.32 R12800 - Post G/L Entries to Fixed Assets Report

Two informational messages can appear in the Message Area column on this report:

Message Explanation
Asset Number Assigned If you did not assign an asset number to an unposted journal entry, this message indicates that the system has automatically assigned an asset number that is based on the FA (Fixed Assets) range in the AAIs. This step can be done only in the batch post process.
Asset Master Record Created This message indicates that the system created an asset master record and its corresponding balance record for a posted transaction. If you do not create these records for an asset before running the post program, the system automatically creates them under these circumstances:
  • The asset number is blank in the Account Ledger table (F0911).

  • The cost object account falls within the FA range of AAIs.

  • The Post G/L Entries to Assets program runs the post.

The system creates asset masters and balance records that are based on the values, which you enter in Depreciation Account Rules and Ledger Depreciation Rules.


E.3.33 R12800E - Fixed Assets Detail Error Report

Several error messages can appear in the Message Area column on this report:

Message Explanation
Unable to Post - Depreciation Defaults Missing This message indicates that the Depreciation Defaults have not been set up for this ledger type.
Ledger Type Invalid This message indicates that the ledger type does not exist in the Ledger Type Master File table (F0025).
Unable to Post - Record is not in the Item Master Table This message indicates that you did not assign an asset number to an unposted journal entry and the system was unable to assign a number automatically.
Unable to Post - Default Co or Accounts Invalid This message indicates that the company for the asset, cost account, or accumulated depreciation account does not match or that the account for the record is not valid.
Unable to Post - Currency Codes are Different This message indicates that the currency code for the company does not match the currency code for the asset.
Unable to Post - Cost Account Differs from that of Asset This message indicates that the cost account for the record to be posted differs from the cost account assigned to this asset in the Asset Master File table (F1201). You can use a processing option to allow posting of the cost to an account that is different from the account, which is designated in the Asset Master.
Unable to Post - Asset is Disposed This message indicates that the date for disposal of the asset has passed, and you can no longer post to it.

E.3.34 R12851P - Depreciation Rules Report

These abbreviated column headings appear in the Depreciation Rules Report:

Abbreviated Column Heading Description
De Me Depreciation Method
FP Fiscal Date Pattern
Dsp Con Disposal Convention
SA Secondary Account
LY Life Year
OU Over/Under allowed
NA Negative allowed
ED Edit disable