78 Fixed Asset Global Updates Processing Options

This chapter contains these topics:

Section 78.1, "Update of Property Tax Information (P12821),"
Section 78.2, "Update of Depreciation Values (P12822),"
Section 78.3, "Location Code Batch Update (P12810),"
Section 78.4, "Add a Ledger to Selected Assets (P12823),"
Section 78.5, "Add New ACE Ledger (P12QAD1),"
Section 78.6, "Item Balance Repost (P12910),"
Section 78.7, "Purge Item Master and Item Balance Files (P12912)."

78.1 Update of Property Tax Information (P12821)

Processing Option	Processing Options Requiring Further Description
DATE SELECTION: 1. Enter the "As of" date. (MM/DD/YY) The property tax state, tax entity, and tax rate/area of the asset's location on this date will be used to update the Item Master File. If the location is changed on this date, the "to" location, or more current location will be used.

Processing Option

Processing Options Requiring Further Description

DATE SELECTION:

1. Enter the "As of" date. (MM/DD/YY) The property tax state, tax entity, and tax rate/area of the asset's location on this date will be used to update the Item Master File.

If the location is changed on this date, the "to" location, or more current location will be used.

78.2 Update of Depreciation Values (P12822)

Processing Option	Processing Options Requiring Further Description
LEDGER TYPE SELECTION: 1. Enter the ledger you want to update. Leave this option blank to update all ledgers.
FISCAL YEAR SELECTION: 2. Enter the fiscal year you want to update. Leave this option blank to update all fiscal years.
DEPRECIATION INFORMATION UPDATE METHOD: 3) Choose the method of update to the depreciation information values. blank = use respective year's cost account depreciation values. '1' = use current fiscal year's cost account depreciation values. '2' = use the default values. EXAMPLE: If option is blank, 1997 records will be updated with 1997 cost record values, 1998 records will be updated with 1998 cost record values, etc. If current fiscal year is 1998 and option is set to '1', all records, regardless of fiscal year, will be updated with values from 1998 cost record. If option is set to '2', all records selected will be updated with the default values as set up in Item Setup Default Coding. 4) Choose the method of update to the Depreciation Start Date. This only applies if option 3 is set to '2'. blank = Do not change/update. '1' = Update to Date Acquired. '2' = Globally update Depreciation Start Date to date entered in option 5. 5) Enter the date to globally update Depreciation Start Date in all records selected. This only applies if option 4 is set to '2'. If this option is left blank and option 4 is set to '2', no change/update to the Depreciation Start Date will happen.
PRINT SELECTION: 6) Enter '1' to Print report showing the before and after values. Leave blank (default) to not print a report.
PROCESSING MODE: 7) Enter 'P' for Preliminary or 'F' for Final. (DEFAULT is Preliminary)

78.3 Location Code Batch Update (P12810)

Processing Option	Processing Options Requiring Further Description
DATE SELECTION:
1. Enter the 'as of' date to use to update the planned status in the Location History file (F1204).

78.4 Add a Ledger to Selected Assets (P12823)

Processing Option	Processing Options Requiring Further Description
UPDATE SELECTION: 1. Enter the ledger type to be added. 2. Enter the fiscal year for the ledger to be added. Leave blank (default) to create the ledger in the asset's current fiscal year. 3. If the ledger already exists for an asset, enter a '1' to update the depreciation values from the defaults. Leave blank (default) to NOT update any existing records.

Processing Option

Processing Options Requiring Further Description

UPDATE SELECTION:

1. Enter the ledger type to be added.

2. Enter the fiscal year for the ledger to be added.

Leave blank (default) to create the ledger in the asset's current fiscal year.

3. If the ledger already exists for an asset, enter a '1' to update the depreciation values from the defaults.

Leave blank (default) to NOT update any existing records.

78.5 Add New ACE Ledger (P12QAD1)

Processing Option	Processing Options Requiring Further Description
1. Enter the new ACE ledger type to be added. 2. Enter the ledger type to be used for the Federal Tax Basis. 3. Enter the ledger type to be used for the Alternative Minimum Tax (AMT) Basis.

Processing Option

Processing Options Requiring Further Description

1. Enter the new ACE ledger type to be added.

2. Enter the ledger type to be used for the Federal Tax Basis.

3. Enter the ledger type to be used for the Alternative Minimum Tax (AMT) Basis.

78.6 Item Balance Repost (P12910)

Processing Option	Processing Options Requiring Further Description
PRINT SELECTION: 1. Enter a '1' to print differences and update Fixed Asset Balance File. Leave blank (default) to only print the differences between Transaction Ledger file (F0911) and Fixed Asset Balance file (F1202). 2. Identify how to print asset number. 1 = Item Number (DEFAULT) 2 = Unit Number 3 = Serial/Tag Number
PURGE F1202 PERIOD AMOUNTS: 3. Enter a '1' to first clear all period postings in F1202 for selected records prior to reposting. It is HIGHLY recommended that you back up your F1202 file if activating this selection. Note: You MUST verify that XJDE0001 for P129101 is correctly selecting the records you will be reposting. Only AA ledgers will be cleared.

Processing Option

Processing Options Requiring Further Description

PRINT SELECTION:

1. Enter a '1' to print differences and update Fixed Asset Balance File.

Leave blank (default) to only print the differences between Transaction Ledger file (F0911) and Fixed Asset Balance file (F1202).

2. Identify how to print asset number.

1 = Item Number (DEFAULT)

2 = Unit Number

3 = Serial/Tag Number

PURGE F1202 PERIOD AMOUNTS:

3. Enter a '1' to first clear all period postings in F1202 for selected records prior to reposting.

It is HIGHLY recommended that you back up your F1202 file if activating this selection.

Note: You MUST verify that XJDE0001 for P129101 is correctly selecting the records you will be reposting.

Only AA ledgers will be cleared.

78.7 Purge Item Master and Item Balance Files (P12912)

Processing Option	Processing Options Requiring Further Description
PURGE SELECTION OPTIONS:
1. Enter a '1' next to the following files you want to purge: F1201 - Item Master File F1202 - Item Balances File F1301 - Equipment Rental Rate File F1204 - Location History File F1205 - Item Message File F1206 - License Master File F1207 - Maintenance Schedule File F1212 - Parent History File F1307 - Status History File F1308 - Maintenance Loops File F13907 - Associated Service Types Note: If the F1201 File is selected for purge, all related files will also be purged.
2. Enter one of the following: '1' = purge records for assets if the disposal date is less than the current fiscal year. Use this option when purging F1301, F1204, F1205, F1206, F1207, and F1307 only. '2' = purge prior year Item Balance records for selected assets. '3' = do both 1 and 2 above.
3. If purging prior year Item Balance (F1202) records, enter the number of years to retain. (The default and minimum is one year or current year balances.) Note: Be sure the Fixed Asset Annual Close has been run PRIOR to purging last year's Item Balance Records.
PRINT OPTION:
4. Enter one of the following to print on the purge report: '1' = Item Number '2' = Unit Number '3' = Serial/Tag Number