C Import Mass Data into Fixed Assets (Release A9.3 Update)

Several interactive programs can run in batch mode and accept data from a Z file, allowing you to process mass amounts of data from an outside source easily and efficiently using existing programs to validate the data.

You can process any number of records to add, change, or delete. You also have the advantage of:

  • Data selection to limit the records you want to process.

  • Processing options that allow you to choose the version of the interactive program to process the records.

  • Error report printing.

The DREAM Writer program number corresponds to the screen and program number with a Z appended to the end and the file numbers correspond to the program file number with a Z appended to the end. For example, P1230Z corresponds to the Depreciation Expense Allocation program P1230 and F1235Z corresponds to the Asset Warranty File F1235. The following table includes the Fixed Asset Z file processing programs.

Program Program Name Z File Program Z File
P1201 Asset Master Revisions P1201Z F1201Z
P1230 Depreciation Expense Allocations Revisions P1230Z F1230HZ (header) and F1230DZ (detail)
P1235 Warranty Information P1235Z F1235Z
P12010 Fixed Asset Category Codes P12010Z F12010Z
P12012 Fixed Asset Insurance P12012Z F12012Z
P12013 Fixed Asset Financing P12013Z F12013Z

Technical Considerations for Fixed Asset Category Codes

You can set the Require Category Codes processing option to 1 in the Asset Master Information program (P1201) to automatically display the Category Codes program (P12010) when you add an asset. You can then tie the F1201Z and F12010Z records together by the Batch, User, and Transaction Number fields and the system updates the Category Codes associated with the asset when you run the Asset Master - Z File (P1201Z) to add fixed assets.

Navigation

From Fixed Assets (G12), enter 27

From Advanced Operations (G1231), choose Z File Processing

From Fixed Assets Z File Processes (G1201Z), choose an option

Processing Options

See the appropriate set of Z file processing options in Chapter 79, "Z File Processing Options (Release A9.3 Update)."

Data Selection

Do not change the existing data selection. The Processed Y/N field is set to NE Y. This prevents the program from processing records more than once.

You can add additional selections to limit the data.

Data Sequence

Do not change the data sequence.