This chapter contains the following topics:
This section provides an overview of block versions and sequencing and discusses how to:
Set processing options for SPED Fiscal Block Setup (P76B0730).
Set processing options for SPED Fiscal Control Rule Setup (R76B0780).
Set processing options for SPED Fiscal - Block 0 - Address Book (R76B0890).
Set processing options for SPED Fiscal - Block H - Inventory (R76B0840).
Specify block information.
Use the SPED Fiscal 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 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 SPED Fiscal Setup menu (G76B1116) to set up versions with data selection, and set the processing options for the UBEs that have processing options. Block 0 does not have data selection because is generated according information processed by the other blocks. You must run the programs from the SPED Fiscal Administ Process program (P76B0840).
The SPED Fiscal Block Setup program saves data to these tables:
Ato Cotepe Process (F76B0740)
Ato Cotepe Process Header (F76B0741)
Ato Cotepe Process Detail (F76B0742)
You can update the setup manually using the SPED Fiscal Block Setup program, or you can update the setup automatically using the SPED Fiscal Control Rule Setup (R76B0780). You must complete the initial setup up in the SPED Fiscal Block Setup program to establish the order of execution of the UBEs. The SPED Fiscal Control Rule Setup program also updates the SPED Fiscal Rules Control Set Up table (F76B0780).
You must run some UBEs in a specific sequence. You can run blocks C, D, E, G, H and 1 can be run independently. To run block 0, you must run blocks C, D, E, G, H and 1. 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 JD Edwards EnterpriseOne software:
| Block and Block Description | Required? | Program ID | Version | Block Sequence | Report Sequence |
|---|---|---|---|---|---|
| C
Block C |
Y | R76B0810 | ZJDE0001 | 1 | 1 |
| D
Block D |
Y | R76B0820 | ZJDE0001 | 2 | 1 |
| E
Block E |
Y | R76B0830 | ZJDE0001 | 3 | 1 |
| G
Block G |
Y | R76B0870 | ZJDE0001 | 5 | 1 |
| H
Block H |
Y | R76B0840 | ZJDE0001 | 4 | 1 |
| 1
Block |
Y | R76B0850 | ZJDE0001 | 6 | 1 |
| 0
Block 0 |
Y | R76B0890 | ZJDE0001 | 7 | 1 |
| 0
Block 0 |
Y | R76B0891 | ZJDE0001 | 7 | 2 |
| 0
Block 0 |
Y | R76B0892 | ZJDE0001 | 7 | 3 |
| 0
Block 0 |
Y | R76B0893 | ZJDE0001 | 7 | 4 |
| 9
Block 9 |
Y | R76B0860 | ZJDE0001 | 8 | 1 |
|
Important: You must also enter your custom programs in the SPED Fiscal Block Setup program in the appropriate order. |
|
Note: If you run block 9, you can not reprocess any program. If you rerun block C, D, E, H, G or 1, you must rerun block 0. To run block 0, you must previously run blocks C, D, E, G and 1. |
| Form Name | Form ID | Navigation | Usage |
|---|---|---|---|
| Work with Electronic Reporting Blocks Template | W76B0730A | SPED Fiscal Setup (G76B1116), SPED Fiscal Block Setup | Review and select existing blocks. |
| Electronic Reporting Blocks Template Revision | W76B0730B | Click Add on the Work with Electronic Reporting Blocks Template form. | Set up the block sequence and requirement for a version of the program for the block. |
Processing options enable you to specify default processing values.
Specify a value from the UDC table 76B/VC to specify which version of SPED fiscal the system uses.
Processing options enable you to specify default processing values.
Use this processing option to specify whether the system runs the report in proof or final mode.\
Values are:
Blank: Run the report in proof mode. (default)
1: Run the report in final mode.
If you enter 1 in this processing option, the system updates the block setup stored in the Fiscal Rules Table Control (F76B0780) and ATO COTEPE Detail Block Template (F76B0731) tables. These tables contain the definitions of the block to execute, the UBEs that belongs to each block, and their order of execution.
Processing options enable you to specify default processing values.
Specify the line numbers in the address book record to print in the END field of registers 0005, 0100, and 0150. For example, if you want lines 3 and 4 of the address book record to print in the field, enter 34.
If you do not complete this processing option, the system prints lines 1 and 2 of the address book record.
Specify the line numbers in the address book record to print in the NUM field of registers 0005, 0100, and 0150. For example, if you want lines 3 and 4 of the address book record to print in the field, enter 34.
If you do not complete this processing option, the system prints line 3 of the address book record.
Specify the line numbers in the address book record to print in the COMPL field of registers 0005, 0100, and 0150. For example, if you want lines 3 and 4 of the address book record to print in the field, enter 34.
If you do not complete this processing option, the system prints line 4 of the address book record.
Processing options enable you to specify default processing values.
Specify a value from the 00/DT UDC table for the document type of the transaction. The system uses the document type that you specify, the business unit from the Item As Of file (F41112), and the GL Category from the Item Branch/Plant table (F4102) to identify the DMAAI 4122 record from which to obtain the account to write to the COD_CTA field of register H010.
If you do not complete this processing option, the system uses default document type IA.
Access the Electronic Reporting Blocks Template Revision form.
Enter a value that exists in the Version of Ato Cotepe (76B/VC) UDC table to specify the version to run.
Enter the block number or letter of the block that you set up.
Enter a description of the block.
Enter the sequence number of the block.
Specify whether the block is required. Values are:
Y: Required
N: Not required.
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.
Enter the program ID of the report that you run to populate the block.
Enter the version of the report that you specify in the Program ID field.
This section provides an overview of the administrator process, lists prerequisites, and discusses how to:
Set processing options for SPED Fiscal Administ Process (P76B0840).
Create a job.
Run blocks in a job.
Extract data.
Use the SPED Fiscal Administ Process program (P76B0840) 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 SPED Fiscal Block Setup program.
You can select to run all of the blocks or to run only selected blocks. You must run block 0 after running blocks C, D, E, G and 1. You must run block 9 after running all previous blocks. When you select a block to process, the system:
Selects all of the UBEs for the block.
Assigns the same job number to all of the UBEs for all of the blocks selected.
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 for all blocks.
If you reprocess some of the blocks C, D, E, H or G, the system sets block 0 as unprocessed and you must execute it again.
|
Note: The system assigns the batch number to the records when you run the SPED Fiscal - Block 9 Control and Join program (R76B0860), so this field is not populated until you run the SPED Fiscal - 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). |
Some blocks require that you complete tasks before you process the records for the block.
Before you generate records for blocks C, D or E, you must run all of the processes related to reporting fiscal books including:
Enter all transactions.
Run the Nota Fiscal Conversion program (R76B200A).
Maintain fiscal books records as necessary.
Before you generate records for block H:
Run the As Of Updating program (R41548).
Run the Item Ledger - As Of Record Generation program (R41542).
| Form Name | Form ID | Navigation | Usage |
|---|---|---|---|
| Work With SPED Fiscal Process | W76B0840A | SPED Fiscal (G76B1115), SPED Fiscal Administ Process | Review or select existing records. |
| SPED Fiscal Header Process | W76B0840C | Click Add on the Work With SPED Fiscal Process form. | Add a job to the queue for processing. |
| SPED Fiscal Process Revision | W76B0840B | Select an existing record on the Work With SPED Fiscal Process 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. |
Processing options enable you to set default processing values.
Enter a value that exists in the Version of Ato Cotepe (76B/VC) to specify the Ato COTEPE version to use.
Specify the reporting company for the tax reporting process. You can specify additional companies by completing Data Selection.
Enter the beginning of the range of dates for which you run the SPED Fiscal process.
End the end of the range of dates for which you run the SPED Fiscal process.
Access the SPED Fiscal Header Process form.
The system generates a job number. You can accept the value that the system generates or enter a different number.
Enter a description for the job you create.
Enter the beginning of the range of dates for which the system selects records to process.
Enter the end of the range of dates for which the system selects records to process.
Enter a value that exists in the Code of Purpose (76B/CO) UDC table to specify why you generate the flat files.
Access the SPED Fiscal Process Revision form.
To run blocks to a job:
Select the lines for the programs that you want to run.
Change the version of the programs to run. (optional)
The system displays the programs and versions that you set up in the SPED Fiscal Block Setup program. If necessary, you can change the version to run before you select the blocks to run.
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.
Access the SPED Fiscal 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 SPED Fiscal Block Setup program and writes data to the Electronic Reporting Processing Details table (F76B0511) and Electronic Reporting - Tag File table (F6B0512) and the workfiles of blocks C, D, E, G, H and 1. If you specified for the system to run the program for block 9, the system analyzes data from the F76B0780, F76B0511, and F76B0512 tables and writes it to the Text Processor Header (F007101) and Text Process Detail (F007111) tables.
This section provides an overview of the output files and lists the forms used to review the output files.
You can view the content for the fields in a register in the SPED Fiscal 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. The data in block 0 is based on the data generated by other blocks.
| Form Name | Form ID | Navigation | Usage |
|---|---|---|---|
| Work With SPED Fiscal Process | W76B0840A | SPED Fiscal (G76B1115), SPED Fiscal 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. |