76 Fixed Asset Reports Processing Options

This chapter contains these topics:

Section 76.1, "Item by Finance Method (P12421),"
Section 76.2, "Fixed Asset Ledger - Posted (P12420),"
Section 76.3, "Equipment Cost Analysis (P12424),"
Section 76.4, "Fixed Assets Supplemental Data (P12400),"
Section 76.5, "All Item Numbers by Data Type - Alpha/Item Number (P12440),"
Section 76.6, "STAR Specifications Report (P126000A),"
Section 76.7, "Specification Data Report (P12416),"
Section 76.8, "Depreciation Schedule (P12411),"
Section 76.9, "Depreciation Projections (P12860),"
Section 76.10, "F/A to G/L Integrity (P127011),"
Section 76.11, "Unposted F/A Transactions (P12301),"
Section 76.12, "G/L to F/A Balance Integrity Report (P127013),"
Section 76.13, "F/A Account Reconciliation Report (P12435),"
Section 76.14, "F/A Reconciliation Report (P12431),"
Section 76.15, "Fixed Asset Retirements Report (P12432),"
Section 76.16, "Sale of Business Property (P12434),"
Section 76.17, "Depreciation Expense Report (P12430),"
Section 76.18, "Depreciation and Amortization Report (P12433),"
Section 76.19, "Property Tax Worksheet (P12422)."

76.1 Item by Finance Method (P12421)

Processing Option	Processing Options Requiring Further Description
PRINT SELECTION: 1. Identify how to print Asset Number. 1 = Item Number (DEFAULT) 2 = Unit Number 3 = Serial/Tag Number 2. Identify how to print the Amount. blank = Amount w/ commas (DEFAULT) 1 = Amount w/o commas

Processing Option

Processing Options Requiring Further Description

PRINT SELECTION:

1. Identify how to print Asset Number.

1 = Item Number (DEFAULT)

2 = Unit Number

3 = Serial/Tag Number

2. Identify how to print the Amount.

blank = Amount w/ commas (DEFAULT)

1 = Amount w/o commas

76.2 Fixed Asset Ledger - Posted (P12420)

Processing Option	Processing Options Requiring Further Description
PRINT SELECTION: 1. Identify how to print the Amount. blank = Amount w/commas (DEFAULT) 1 = Amount w/o commas

Processing Option

Processing Options Requiring Further Description

PRINT SELECTION:

1. Identify how to print the Amount.

blank = Amount w/commas (DEFAULT)

1 = Amount w/o commas

76.3 Equipment Cost Analysis (P12424)

Processing Option	Processing Options Requiring Further Description
REPORT SELECTION: 1. Identify how to print report. D = Detail Report (DEFAULT) O = Total by Object Account S = Summary Report R = Total by Subsidiary Account
DATE SELECTION: 2. Enter through period or through fiscal date. Leave blank to use current period.
LEDGER TYPE SELECTION: 3. Enter a single ledger type. Leave blank (default) for "AA" ledger.
UNITS SELECTION: 4. Enter a "1" to suppress units from printing on report. Leave blank to print units (default). 5. Identify what Automatic Accounting Instruction to use for units. Y = 'AT00' AAI (DEFAULT) A = 'FMA ' AAI B = 'FMB ' AAI
PRINT SELECTION: 6) Enter a "1" to omit printing assets with zero cost. Leave blank to print all assets (DEFAULT). 7) Identify how to print asset number. 1 = Item Number (DEFAULT) 2 = Unit Number 3 = Serial Number 8) Identify how to print the amounts. blank = Amounts w/ commas (DEFAULT) 1 = Amounts w/o commas

76.4 Fixed Assets Supplemental Data (P12400)

Processing Option	Processing Options Requiring Further Description
PRINT SELECTION: 1. Enter a 'N' to bypass printing text information on the report. Leave blank (default) to print the text.
2. Choose which asset number to print: '1' = Item Number (default). '2' = Unit Number. '3' = Serial Number.

Processing Option

Processing Options Requiring Further Description

PRINT SELECTION:

1. Enter a 'N' to bypass printing text information on the report.

Leave blank (default) to print the text.

2. Choose which asset number to print:

'1' = Item Number (default).

'2' = Unit Number.

'3' = Serial Number.

76.5 All Item Numbers by Data Type - Alpha/Item Number (P12440)

Processing Option	Processing Options Requiring Further Description
PRINT SELECTION: 1. Enter a 'N' to bypass printing text information on the report. Leave blank (default) to print the text.
2. Choose which asset number to print: '1' = Item Number (default). '2' = Unit Number. '3' = Serial Number.

Processing Option

Processing Options Requiring Further Description

PRINT SELECTION:

1. Enter a 'N' to bypass printing text information on the report.

Leave blank (default) to print the text.

2. Choose which asset number to print:

'1' = Item Number (default).

'2' = Unit Number.

'3' = Serial Number.

76.6 STAR Specifications Report (P126000A)

Processing Option	Processing Options Requiring Further Description
COVER PAGE SPECIFICATION:
1. Enter a "1" to include the cover page of the selected versions.

76.7 Specification Data Report (P12416)

Processing Option	Processing Options Requiring Further Description
1. Enter a '1' to display Specification Template. Leave blank to display Specification Data.

76.8 Depreciation Schedule (P12411)

Processing Option	Processing Options Requiring Further Description
AS-OF PERIOD SELECTION: 1. Enter the "as-of" period. Leave blank (default) to use each company's current fiscal period. 2. Enter the "as-of" fiscal year. Leave blank (default) to use each company's current fiscal year.
LEDGER TYPE SELECTION: 3. Enter a single ledger type. Leave blank (default) for all ledger types.
PRINT OPTIONS: 4) Choose one of the following for report sequence: '1' = sequence by Accumulated Depreciation Account (Default). '2' = sequence by Depreciation Expense Account. (NOTE: DREAM Writer sequencing must be consistent with this selection.) 5) Choose one of the following to print on the report: '1' = Item Number (Default). '2' = Unit Number. '3' = Serial Number. 6) Enter a '1' to print all assets. Leave blank (default) to omit printing assets with zero cost. 7) Enter a '1' to suppress commas on all Amount fields. Leave blank (default) to print with commas. 8) Enter a '1' to print Month and Year asset will be fully depreciated. Leave blank (default) to print Remaining Periods.

Processing Option

Processing Options Requiring Further Description

AS-OF PERIOD SELECTION:

1. Enter the "as-of" period.

Leave blank (default) to use each company's current fiscal period.

2. Enter the "as-of" fiscal year.

Leave blank (default) to use each company's current fiscal year.

LEDGER TYPE SELECTION:

3. Enter a single ledger type.

Leave blank (default) for all ledger types.

PRINT OPTIONS:

4) Choose one of the following for report sequence:

'1' = sequence by Accumulated Depreciation Account (Default).

'2' = sequence by Depreciation Expense Account.

(NOTE: DREAM Writer sequencing must be consistent with this selection.)

5) Choose one of the following to print on the report:

'1' = Item Number (Default).

'2' = Unit Number.

'3' = Serial Number.

6) Enter a '1' to print all assets.

Leave blank (default) to omit printing assets with zero cost.

7) Enter a '1' to suppress commas on all Amount fields. Leave blank (default) to print with commas.

8) Enter a '1' to print Month and Year asset will be fully depreciated.

Leave blank (default) to print Remaining Periods.

76.9 Depreciation Projections (P12860)

Processing Option	Processing Options Requiring Further Description
LEDGER SELECTION: 1. Enter the book ledger. Default is 'AA' ledger. 2. Enter the tax ledger.
FISCAL YEAR SELECTION: 3. Enter the begin fiscal year. Default is current fiscal year for company '00000'. 4. Enter the number of years to project depreciation. Default is 3. Maximum is 41 or life of asset, if less.
PRINT SELECTION: 5. Enter report summarization level. 1 = Summary by Company (DEFAULT) 2 = Summary by Depreciation Expense Account and Company 3 = Detail by Asset, and Summary by Depre Expense Acct and Company. 6. Identify how to print asset number. 1 = Item Number (DEFAULT) 2 = Unit Number 3 = Serial/Tag Number 7. Identify how to print Amount fields. blank = Amounts w/ commas (DEFAULT) 1 = Amounts w/o commas

Processing Option

Processing Options Requiring Further Description

LEDGER SELECTION:

1. Enter the book ledger.

Default is 'AA' ledger.

2. Enter the tax ledger.

FISCAL YEAR SELECTION:

3. Enter the begin fiscal year.

Default is current fiscal year for company '00000'.

4. Enter the number of years to project depreciation.

Default is 3. Maximum is 41 or life of asset, if less.

PRINT SELECTION:

5. Enter report summarization level.

1 = Summary by Company (DEFAULT)

2 = Summary by Depreciation Expense Account and Company

3 = Detail by Asset, and Summary by Depre Expense Acct and Company.

6. Identify how to print asset number.

1 = Item Number (DEFAULT)

2 = Unit Number

3 = Serial/Tag Number

7. Identify how to print Amount fields.

blank = Amounts w/ commas (DEFAULT)

1 = Amounts w/o commas

76.10 F/A to G/L Integrity (P127011)

Processing Option	Processing Options Requiring Further Description
REPORTING SELECTION: 1. Enter a '1' to ONLY print those accounts where the Item Balance (F1202) net postings do not equal the Account Balance (F0902) net postings. Leave blank to print all accounts.

Processing Option

Processing Options Requiring Further Description

REPORTING SELECTION:

1. Enter a '1' to ONLY print those accounts where the Item Balance (F1202) net postings do not equal the Account Balance (F0902) net postings.

Leave blank to print all accounts.

76.11 Unposted F/A Transactions (P12301)

Processing Option	Processing Options Requiring Further Description
PRINT SELECTION: 1. Identify how to print Asset Number. 1 = Item Number (DEFAULT) 2 = Unit Number 3 = Serial Number 2. Identify how to print the Amount. blank = Amount w/ commas (DEFAULT) 1 = Amount w/o commas

Processing Option

Processing Options Requiring Further Description

PRINT SELECTION:

1. Identify how to print Asset Number.

1 = Item Number (DEFAULT)

2 = Unit Number

3 = Serial Number

2. Identify how to print the Amount.

blank = Amount w/ commas (DEFAULT)

1 = Amount w/o commas

76.12 G/L to F/A Balance Integrity Report (P127013)

Processing Option	Processing Options Requiring Further Description
REPORTING SELECTION:
1. Enter '1' to ONLY print those accounts where the Item Balance (F1202) net postings do not equal the Account Balance (F0902) net postings. Leave blank to print all accounts.
2. Enter the "as of" date. Leave blank (default) to use each company's current fiscal year and period.
3. Enter '1' to print transaction detail. Leave blank (default) to print balance information only.
LEDGER TYPE SELECTION:
4. Enter a ledger type to specify other than AA. Leave blank (default) for the AA ledger type.
PRINT FORMAT CONTROL:
5. Enter '1' to suppress commas on all amount fields. Leave blank (default) to print with commas.
6. Enter '1' to suppress the code explanation from printing. Leave blank (default) to print the code explanation.

76.13 F/A Account Reconciliation Report (P12435)

Processing Option	Processing Options Requiring Further Description
FISCAL YEAR AND PERIOD SELECTION: 1. Enter the fiscal year you wish to report activity. Leave blank to use current fiscal year. 2. Identify the period you wish to report activity. 01 - 14 = Specific Period A = First Quarter B = Second Quarter C = Third Quarter D = Fourth Quarter blank = Year to Date NOTE: Specific period and quarterly reporting are only allowed with 'AA' ledger type selection for option 3.
LEDGER TYPE SELECTION: 3. Enter the Ledger Type you wish to report activity. If left blank, the 'AA' Ledger Type will be used. NOTE: If a Ledger Type other than 'AA' is entered, option 2 should be left blank to report Year to Date.
PRINT SELECTION: 4. Identify how to print Asset Number. 1 = Item Number (DEFAULT) 2 = Unit Number 3 = Serial Number 5. Identify how to print the Amounts. blank = Amounts w/ commas (DEFAULT) 1 = Amounts w/o commas

Processing Option

Processing Options Requiring Further Description

FISCAL YEAR AND PERIOD SELECTION:

1. Enter the fiscal year you wish to report activity.

Leave blank to use current fiscal year.

2. Identify the period you wish to report activity.

01 - 14 = Specific Period

A = First Quarter

B = Second Quarter

C = Third Quarter

D = Fourth Quarter blank = Year to Date

NOTE: Specific period and quarterly reporting are only allowed with 'AA' ledger type selection for option 3.

LEDGER TYPE SELECTION:

3. Enter the Ledger Type you wish to report activity.

If left blank, the 'AA' Ledger Type will be used.

NOTE: If a Ledger Type other than 'AA' is entered, option 2 should be left blank to report Year to Date.

PRINT SELECTION:

4. Identify how to print Asset Number.

1 = Item Number (DEFAULT)

2 = Unit Number

3 = Serial Number

5. Identify how to print the Amounts.

blank = Amounts w/ commas (DEFAULT)

1 = Amounts w/o commas

76.14 F/A Reconciliation Report (P12431)

Processing Option	Processing Options Requiring Further Description
FISCAL YEAR AND QUARTER SELECTION: 1. Enter the fiscal year you wish to report activity. Leave blank to use current fiscal year. 2. Identify the quarter you wish to report activity. 1 = First Quarter 2 = Second Quarter 3 = Third Quarter 4 = Fourth Quarter blank = Year to Date NOTE: Values of 1, 2, 3, and 4 are only allowed with Ledger Type 'AA' selection for option 3.
LEDGER TYPE SELECTION: 3. Enter the Ledger Type you wish to report activity. If left blank, the 'AA' Ledger Type will be used. NOTE: If a Ledger Type other than 'AA' is entered, option 2 should be left blank to report Year to Date.
PRINT SELECTION: 4. Identify how to print asset number. 1 = Item Number (DEFAULT) 2 = Unit Number 3 = Serial Number 5. Identify how to print the Amounts. blank = Amounts w/ commas (DEFAULT) 1 = Amounts w/o commas

Processing Option

Processing Options Requiring Further Description

FISCAL YEAR AND QUARTER SELECTION:

1. Enter the fiscal year you wish to report activity.

Leave blank to use current fiscal year.

2. Identify the quarter you wish to report activity.

1 = First Quarter

2 = Second Quarter

3 = Third Quarter

4 = Fourth Quarter

blank = Year to Date

NOTE: Values of 1, 2, 3, and 4 are only allowed with Ledger Type 'AA' selection for option 3.

LEDGER TYPE SELECTION:

3. Enter the Ledger Type you wish to report activity.

If left blank, the 'AA' Ledger Type will be used.

NOTE: If a Ledger Type other than 'AA' is entered, option 2 should be left blank to report Year to Date.

PRINT SELECTION:

4. Identify how to print asset number.

1 = Item Number (DEFAULT)

2 = Unit Number

3 = Serial Number

5. Identify how to print the Amounts.

blank = Amounts w/ commas (DEFAULT)

1 = Amounts w/o commas

76.15 Fixed Asset Retirements Report (P12432)

Processing Option	Processing Options Requiring Further Description
FISCAL YEAR AND QUARTER SELECTION: 1. Enter the fiscal year you wish to report activity. Leave blank to use current fiscal year. 2. Identify the quarter you wish to report activity. 1 = First Quarter 2 = Second Quarter 3 = Third Quarter 4 = Fourth Quarter blank = Year to Date
LEDGER TYPE SELECTION: 3. Enter the Ledger Type you wish to report activity. If left blank, the 'AA' Ledger Type will be used. 4. Enter a second comparison Ledger Type. If left blank, no comparison reporting will be done.
PRINT SELECTION: 5. Identify how to print Asset Number. 1 = Item Number (DEFAULT) 2 = Unit Number 3 = Serial Number 6. Identify how to print the Amounts. blank = Amounts w/ commas (DEFAULT) 1 = Amounts w/o commas

Processing Option

Processing Options Requiring Further Description

FISCAL YEAR AND QUARTER SELECTION:

1. Enter the fiscal year you wish to report activity.

Leave blank to use current fiscal year.

2. Identify the quarter you wish to report activity.

1 = First Quarter

2 = Second Quarter

3 = Third Quarter

4 = Fourth Quarter

blank = Year to Date

LEDGER TYPE SELECTION:

3. Enter the Ledger Type you wish to report activity.

If left blank, the 'AA' Ledger Type will be used.

4. Enter a second comparison Ledger Type.

If left blank, no comparison reporting will be done.

PRINT SELECTION:

5. Identify how to print Asset Number.

1 = Item Number (DEFAULT)

2 = Unit Number

3 = Serial Number

6. Identify how to print the Amounts.

blank = Amounts w/ commas (DEFAULT)

1 = Amounts w/o commas

76.16 Sale of Business Property (P12434)

Processing Option	Processing Options Requiring Further Description
FISCAL YEAR SELECTION: 1. Enter the fiscal year. If you leave this option blank, the current fiscal year for the asset will be used.
LEDGER TYPE SELECTION: 2. Enter the ledger type. If you leave this option blank, the 'AA' ledger will be used.
VERSION SELECTION: 3. Choose type of property to report on. 1 = Personal Property 2 = Real Property (DEFAULT)
PRINT SELECTION: 4. Identify how to print asset number. 1 = Item Number (DEFAULT) 2 = Unit Number 3 = Serial Number 5. Identify how to print amount fields. blank = Amounts w/ commas (DEFAULT) 1 = Amounts w/o commas
DEPRECIATION METHODS: 6. Select a UDD Method to be written to the report. This only applies to Real Property.

76.17 Depreciation Expense Report (P12430)

Processing Option	Processing Options Requiring Further Description
DATE SELECTION: 1. Enter the period number and fiscal year. Leave blank to use current period or fiscal year. Period: Year :
LEDGER TYPE SELECTION: 2. Enter the ledger type. If you leave this option blank, the 'AA' ledger will be used.
PRINT SELECTION: 3. Identify how to print Asset Number. 1 = Item Number (DEFAULT) 2 = Unit Number 3 = Serial Number 4. Enter a '1' to print all assets. Leave blank to omit printing assets with no activity. 5. Identify how to print the Amounts. blank = Amounts w/ commas (DEFAULT) 1 = Amounts w/o commas

Processing Option

Processing Options Requiring Further Description

DATE SELECTION:

1. Enter the period number and fiscal year.

Leave blank to use current period or fiscal year.

Period:

Year :

LEDGER TYPE SELECTION:

2. Enter the ledger type.

If you leave this option blank, the 'AA' ledger will be used.

PRINT SELECTION:

3. Identify how to print Asset Number.

1 = Item Number (DEFAULT)

2 = Unit Number

3 = Serial Number

4. Enter a '1' to print all assets.

Leave blank to omit printing assets with no activity.

5. Identify how to print the Amounts.

blank = Amounts w/ commas (DEFAULT)

1 = Amounts w/o commas

76.18 Depreciation and Amortization Report (P12433)

Processing Option	Processing Options Requiring Further Description
PRINT SELECTION: 1. Identify how to print asset number. 1 = Item Number (DEFAULT) 2 = Unit Number 3 = Serial Number

Processing Option

Processing Options Requiring Further Description

PRINT SELECTION:

1. Identify how to print asset number.

1 = Item Number (DEFAULT)

2 = Unit Number

3 = Serial Number

76.19 Property Tax Worksheet (P12422)

Processing Option	Processing Options Requiring Further Description
DATE SELECTION: 1. Enter acquisition cut-off date. If you leave this option blank, assets acquired after its company's current period will not be included on the report. 2. Enter cost "As Of" date. If you leave this option blank, cost will be "As Of" the current period for each asset's company.
ADDITIONAL COST LEDGER SELECTION: 3. Enter an additional ledger type for cost. If you leave this option blank, only the 'AA' ledger type will be used to determine cost.
PRINT SELECTION: 4. Enter a '1' to omit printing assets with zero cost. If you leave this option blank, all selected assets will appear on report. 5. Identify how to print asset number. 1 = Item Number (DEFAULT) 2 = Unit Number 3 = Serial Number

Processing Option

Processing Options Requiring Further Description

DATE SELECTION:

1. Enter acquisition cut-off date.

If you leave this option blank, assets acquired after its company's current period will not be included on the report.

2. Enter cost "As Of" date.

If you leave this option blank, cost will be "As Of" the current period for each asset's company.

ADDITIONAL COST LEDGER SELECTION:

3. Enter an additional ledger type for cost.

If you leave this option blank, only the 'AA' ledger type will be used to determine cost.