B Import Mass Data into General Accounting

A few of the General Accounting 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.

As with all Z file processing programs, the DREAM Writer launches the interactive program which processes the data into the Z file.

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 generally corresponds to the screen and program number with a Z appended to the end. For example, P09012Z corresponds to the Account Category Codes program P09012. The following table includes the General Accounting Z file processing programs.

Program Program Name Z File Program Z File
P09011 Revise Single Account P09011Z F09011Z
P09012 Account Category Codes P09012Z F09012Z
P14101 Detailed Budget by Account P14101Z F14101HZ (header) and F14101DZ (detail)

Technical Considerations for Account Category Codes

You can tie the P09011Z and P09012Z batch processes together. When you add accounts running P09011Z, you can use the control fields to include the account category codes records associated with the account.

Navigation

From General Accounting (G09), enter 27

From G/L Advanced & Technical Operations (G0931), choose Z File Processing/G/L

From General Ledger Z File Processes (G0901Z), choose the appropriate option

Processing Options

See the appropriate set of Z file processing options in Chapter 91, "Z File Processing Options".

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.