## (BRA) Working with Blocks, Registers, and Records for Ato COTEPE 11 of 2007

This chapter discusses how to:

- Specify blocks, versions, and sequencing for tax reporting.

- Extract data for tax reporting.

- Review records generated by the extraction process.

### Specifying Blocks, Versions, and Sequencing

This section provides an overview of block versions and sequencing and discusses how to:

- Set processing options for Ato Cotepe Block Setup (P76B0730).

- Set processing options for Ato Cotepe 11 - Block C - Fiscal Document (R76B0710).

- Set processing options for Ato Cotepe 11 - Block E - IPI/ICMS Tax Verification (R76B0730).

- Specify block information.

#### Understanding Block Versions and Sequencing

Use the Ato Cotepe Block Setup program to set up the batch programs (UBEs) and versions to run for each block. You set up versions of the programs provided by Oracle, and can also set up versions of the custom programs that you create to generate blocks or populate registers for data that does not reside in J.D. Edwards OneWorld or JD Edwards EnterpriseOne tables.

When you set up the blocks, you must specify the UBE and versions to run for each block, as well as the sequence number in which the system runs the batch programs.

You can access the UBEs for tax reporting from the Ato Cotepe 11 Setup menu (G76B1116) to set up versions with data selection, and set the processing options for the UBEs that have processing options. However, you must run the programs from the Ato Cotepe Administ Process program (P76B0740).

The Ato Cotepe Block Setup program saves data to these tables:

- Ato Cotepe Process (F76B0740)

- Ato Cotepe Process Header (F76B0741)

- Ato Cotepe Process Detail (F76B0742)

Block and Report Sequencing

You must run some UBEs in a specific sequence. For example, you must run the UBEs for block 0 prior to running UBEs for any other blocks, so you must set the sequence number for the UBEs for block 0 at a lower sequence number than for other UBEs. Similarly, you must run the UBE for block 9 after you run the UBEs for all other blocks, including any custom programs that you need to run.

This table shows how you should set up the block and report sequencing for the programs provided by J.D. Edwards OneWorld and JD Edwards EnterpriseOne software:

Block and Block Description | Required? | Program ID | Version | Block Sequence | Report Sequence
0 Block 0 | Y | R76B0700 | ZJDE0001 | 1 | 1
0 Block 0 | Y | R76B0701 | ZJDE0001 | 1 | 2
0 Block 0 | Y | R76B0702 | ZJDE0001 | 1 | 3
0 Block 0 | Y | R76B0703 | ZJDE0001 | 1 | 4
C Clock C | N | R76B0710 | ZJDE0001 | 2 | 1
D Block D | N | R76B0720 | ZJDE0001 | 3 | 1
E Block E | N | R76B0730 | ZJDE0001 | 4 | 1
H Block H | N | R76B0740 | ZJDE0001 | 5 | 1
1 Block | N | R76B0750 | ZJDE0001 | 6 | 1
9 Block 9 | Y | R76B0760 | ZJDE0001 | 7 | 1

Important! You must also enter your custom programs in the Ato Cotepe Block Setup program in the appropriate order. You must sequence the programs so that the four programs for block 0 run first and the Ato Cotepe 11 - Block 9 Control and Join program (R76B0760) is the last program to run.

#### Forms Used to Specify Block Information

Form Name | FormID | Navigation | Usage
Work with Ato Cotepe Blocks Setup | W76B0730A | Ato Cotepe 11 Setup (G76B1116), Ato Cotepe Block Setup | Review and select existing blocks.
Ato Cotepe Blocks Setup Revision | W76B0730B | Click Add on the Work with Ato Cotepe Blocks Setup form. | Set up the block sequence and requirement for a version of the program for the block.

#### Setting Processing Options for Ato Cotepe Block Setup (P76B0730)

Processing options enable you to specify default processing values.

General

ATO Cotepe Version | Enter a value that exists in the Ato Cotepe Version (76B/VC) UDC table to specify the version of Ato COTEPE that you set up.

#### Setting Processing Options for Ato Cotepe 11 - Block C - Fiscal Document (R76B0710)

Processing options enable you to specify default processing values.

General

Report Layout | Enter 1 to print the column titles only once, at the top of the report. Leave this processing option blank to print the column titles at the beginning of the records for each register within the block.

#### Setting Processing Options for Ato Cotepe 11 - Block E - IPI/ICMS Tax Verification (R76B0730)

Processing options enable you to specify default processing values.

General

Report Layout | Enter 1 to print the column titles only once, at the top of the report. Leave this processing option blank to print the column titles at the beginning of the records for each register within the block.

#### Specifying Block Information

Access the Ato Cotepe Blocks Setup Revision form.

Ato Cotepe Version | Enter a value that exists in the Version of Ato Cotepe (76B/VC) UDC table to specify the version to run.
Block | Enter the block number or letter of the block that you set up.
Description | Enter a description of the block.
Block Sequence | Enter the sequence number of the block. You must run the programs for block 0 before running the programs for any other block, and must run the program for block 9 after running the programs for all other blocks.
Required Y/N | Specify whether the block is required. Values are: Y: Required N: Not required.
Report Sequence | Enter the sequence number of the report. Some blocks are populated by more than one program. Use this field to specify the order in which the system runs the programs for blocks populated by multiple programs. If only one program exists for the block, enter 1.
Program ID | Enter the program ID of the report that you run to populate the block.
Version | Enter the version of the report that you specify in the Program ID field.

### Extracting Data for Tax Reporting

This section provides an overview of the administrator process, lists prerequisites, and discusses how to:

- Set processing options for Ato Cotepe Administ Process (P76B0740).

- Add jobs to the queue.

- Add blocks to the jobs.

- Extract data.

#### Understanding the Administrator Process

Use the Ato Cotepe Administ Process program (P76B0740) to run the UBEs for the blocks and extract data for tax reporting. The system displays in the Ato Cotepe Administ Process program the blocks that you set up in the Ato Cotepe Block Setup program.

You can select to run all of the blocks or to run only selected blocks. When you select a block to process, the system:

1. Selects all of the UBEs for the block.

2. Assigns the same job number to all of the UBEs for all of the blocks selected.

3. Uses a status code to indicate whether the records are queued for processing.

   Status codes are: W (waiting), P (in process), D (done), or E (error).

The system includes all records for a job number in the flat file. If you run all of the blocks simultaneously, the system will assign the same job number to all blocks and UBEs. If you process blocks and UBEs separately, you must associate the job number to subsequent blocks and UBEs as you run them. The system groups the registers and records for blocks into a flat file based on the job number associated with block 0. If you run blocks separately from block 0, or re-run the UBEs, you must associate the UBEs to the job number associated with block 0. Failure to assign the correct job number will result in inaccurate reporting.

Note. The system assigns the batch number to the records when you run the Ato Cotepe 11 - Block 9 Control and Join program (R76B0760), so this field is not populated until you run the Ato Cotepe 11 - Block 9 Control and Join program. You use the batch number to locate the records that the system writes to the Text Processor Header table (F007101) and Text Process Detail Table (F007111).

#### Prerequisites

Some blocks require that you complete tasks before you process the records for the block.

- Before you generate records for block C or block E, you must run all of the processes related to reporting fiscal books including:

  - Enter all transactions.

  - Run the Nota Fiscal Conversion program (R76B200A).

  - Run the Integrity Report (R76B0001).

  - Maintain fiscal books records as necessary.

  - Print and review the fiscal books supplementary reports.

  - Generate and review fiscal books.

- Before you generate records for block H:

  - Run the As Of Updating program (R41548).

  - Run the Item Ledger - As Of Record Generation program (R41542).

#### Forms Used to Add Jobs and Blocks and Extract Data

Form Name | FormID | Navigation | Usage
Work With Ato Cotepe | W76B0740A | ATO COTEPE 11 Brazil Elec Reporting (G76B1115), Ato Cotepe Administ Process | Review or select existing records.
Header Ato Cotepe Process | W76B0740C | Click Add on the Work With Ato Cotepe form. | Add a job to the queue for processing.
Ato Cotepe Process Revision | W76B0740B | Select an existing record on the Work With Ato Cotepe form and click Select. | Select the blocks to process and process blocks. Select the blocks, and then select Select/Unselect from the Row menu. The system places a check mark next to all of the required blocks and next to the blocks that you select. The system also changes the value in the Status field to W (waiting). Note. To deselect blocks, click the Select/Unselect option again. To process selected blocks, select Process Blocks from the Form menu.

#### Setting Processing Options for Ato Cotepe Administ Process (P76B0740)

Processing options enable you to set default processing values.

General

Ato Cotepe Version | Enter a value that exists in the Version of Ato Cotepe (76B/VC) to specify the Ato COTEPE version to use.
Legal Company | Specify the reporting company for the tax reporting process. You can specify additional companies by completing Data Selection.
Begin Date | Enter the beginning of the range of dates for which you run the Ato COTEPE process.
End Date | End the end of the range of dates for which you run the Ato COTEPE process.

#### Adding a Job to the Queue

Access the Header Ato Cotepe Process form.

Job Number | The system generates a job number. You can accept the value that the system generates or enter a different number.
Description | Enter a description for the job you create.
Start Effective Date | Enter the beginning of the range of dates for which the system selects records to process.
Ending Effective Date | Enter the end of the range of dates for which the system selects records to process.
Code of Purpose | Enter a value that exists in the Code of Purpose (76B/CO) UDC table to specify why you generate the flat files.

#### Adding Blocks to a Job

Access the Ato Cotepe Process Revision form.

To add blocks to a job:

1. Select the lines for the programs that you want to run.

2. Change the version of the programs to run. (optional)

   The system displays the programs and versions that you set up in the Ato Cotepe Block Setup program. If necessary, you can change the version to run before you select the blocks to run.

3. Select Select/Unselect from the Row menu.

   The system places a check mark next to the programs you selected. The system also places a check mark next to additional programs for the block if you did not select them.

#### Extracting Data

Access the Ato Cotepe Process Revision form.

To extract data, select Process Blocks from the Form menu.

The system processes the selected blocks according to the sequence that you set up in the Ato Cotepe Block Setup program and writes data to the Ato Cotepe Process table (F76B0740) and Electronic Reporting Processing Details table (F76B0511). If you selected to run the program for block 9, the system writes the data from the F76B0740 and F76B0511 tables to the Text Processor Header table (F007101) and Text Process Detail Table (F007111).

### Reviewing Records Generated by the Extraction Process

This section provides an overview of the output files and lists the forms used to review the output files.

#### Understanding the Output Files

You can view the content for the fields in a register in the Ato Cotepe Administ Process program. If you need to make changes to the data in the fields, you must correct the data in the original transaction and then rerun the program that populated the registers for the block. Data for many blocks is based, in part, on data in block 0. If you make changes to data in block 0, verify the data in the registers that use data from these work tables populated by block 0 programs:

- Address Book Brazilian Work File (F76B0520).

- Item Master Brazilian Work File (F76B0521).

- Transaction Nature Brazilian Work File (F76B0522).

- Observation Fiscal Brazilian Work File (F76B0523).

- Generic Item Master Add Info (F704101).

- Item Track Change (F76B0765).

See Also

Fields for Flat Files for Ato COTEPE 11 of 2007

#### Forms Used to Review Output Files

Form Name | FormID | Navigation | Usage
Work With Ato Cotepe | W76B0740A | ATO COTEPE 11 Brazil Elec Reporting (G76B1115), Ato Cotepe Administ Process | Review and select existing processed batches.
Work With Output File | W76B0741A | Select a record and select Control Process from the Row menu. | Review records from the registers used for tax reporting.