This chapter contains the following topics:
This section provides overviews of job setup and the execution process, lists prerequisites, and discusses how to:
Set processing options for FCONT SPED Job Administrator (P76B940).
Set up a job to process data.
Run a job to extract data.
Reprocess a block.
After you set up the blocks and registers in the FCont Initial Block program (R76B838) and the Block Setup program (P76B0730), you use the FCONT SPED Job Administrator program (P76B940) to set up and run jobs to process the data for FCont reporting. You set up a separate job for each book number. Books numbers are associated with book types. You set up the associations between book numbers and book types in the Book Type Definition program (P76B935). You can also set up several ledger types in a book number. Each job will generally include all of the blocks required for SPED FCont for a specified book number, but you can set up a job to generate the records for only selected blocks.
When you click OK to add a job, the system:
Writes data to the FCONT Jobs Header (F76B836), SPED Jobs Header (F76B940), SPED Job Header Blocks (F76B941) and SPED Job Detail Blocks (F76B942) tables using the values that you entered in the FCONT SPED Job Administrator program and values that you set up in the Block Setup program (P76B0730).
Writes one record corresponding to the Job Batch to the SPED Job Batches table (F76B944). Since the FCont file is unique per year, the system only inserts one record with period blank.
The system does not assign a batch number until you run all blocks for the job.
Writes records to the SPED Job Signatories table (F76B945) for the signatories that you set up for the legal company in the Legal Company Constants program (P76B010).
You can modify the signatories information before you run the job.
Writes records to the FCONT Jobs Periodicity (F76B839) table depending on the periodicity detail level:
By Quarter: the system inserts four records, one for each quarter, indicating beginning quarter date and ending quarter date.
By Year: the system inserts one record.
Special Indicator: in this case, for example if the company initiated business this year, you can specify the period from and period to. The system generates the quarters needed.
You can modify certain data for jobs before you run the job:
Job description
To revise the job description, select Header Revision from the Row menu on the SPED Job Inquiry form.
Signatories
When you add a job, the system writes data for the signatories that you set up in the address book record to the F76B945 table. Select Signatories Revision from the Row menu on the SPED Job Inquiry form to modify the signatories.
|
Important: The system enables you to make changes to the signatories after you run a job. However, the system does not update the output files unless you reprocess the blocks in a job. |
If you attempt to delete a job for which records exist in the F76B836 table, the system displays a confirmation message. You can confirm the action to delete the job. If you attempt to delete a job for which no records exist in the F76B836 table, the system deletes the job without asking for a confirmation. When the system deletes a job, it deletes records for the job from all of the related tables.
You run the jobs that you set up from the SPED Job Revision form in the FCONT SPED Job Administrator program. When you run a job, the system completes these tasks for each block in the job:
Reads the job information that is stored in the SPED Jobs table (F76B940) for the block.
The system stores information in the F76B940 table when you set up the jobs.
Reads the periods to process from the SPED Job Batches table (F76B944) and generates the registers for each period.
You can view the most significant details for the completed job in the FCONT SPED Job Administrator program (P76B940). The system assigns the same job number to all of the UBEs for all of the blocks selected.
Populates the SPED Job Output Detail table (F76B943) with the information for the block, period, and registers.
The F76B943 table also includes the text string for the flat file.
Uses a status code to indicate whether the records are queued for processing.
Status codes are: P (in process), D (done), and E (error). These status codes appear in the SPED Job Detail Blocks-UBE table (F76B942) for each UBE in the job that you run. You can view the statuses on the SPED Job Revision form in the FCONT SPED Job Administrator program.
A status code of D (done) appears in the SPED Job Header Blocks table (F76B941) when all of the UBEs in the job have run without error. You can view the status for a job on the SPED Job Inquiry form in the FCONT SPED Job Administrator program.
The system includes all records for a job number in the flat file.
|
Note: The system assigns the batch number to the records when you run the Block 9 Generation program (R76B846), so this field is not populated until you run that program. The Block 9 Generation program also writes the text strings to the Text Processor Header table (F007101) and Text Process Detail Table (F007111). You use the batch number to locate the records that the system writes to the text file processor tables, and use the Text File Processor program (P007101) to copy the text files to the media that you use to submit the files to the government. |
You must run each block in a job separately. Generally, you will review the output for one block before processing the next block because data from a block with a higher sequence is used for processing data in a subsequent block. The system generates a batch for each job. If you run a job that includes four periods, the system generates one batch including the four periods.
Before you set up and run jobs to generate the electronic file to submit for SPED FCont:
Complete all setup.
Post all transactions.
| Form Name | Form ID | Navigation | Usage |
|---|---|---|---|
| SPED Job Inquiry | W76B940A | SPED - FCONT (G76B0930), FCONT SPED Job Administrator | Review and select existing jobs. |
| FCONT Job Header Revision | W76B940L | Click Add on the SPED Job Inquiry form, or select a record and Header Revision option from the Row menu. | Add a job for a book by period and legal company, or modify a job description. |
| FCONT Job Revision | W76B940M | Select a job on the SPED Job Inquiry form and click Select. | Select the blocks and UBEs to run; modify the version to run; and specify whether to show account detail in the output reports for each UBE. |
| SPED Job Signatories Revision | W76B940F | Select a job on the SPED Job Inquiry form and select Signatories revision from the Form menu. | Modify signatories information. |
Processing options enable you to set default processing values.
Access the SPED Job Header Revision form.
Complete these fields, and then click OK.
Job Number
Job Description
Legal Company
SPED Book Number
Century
Fiscal Year
Period From
Period To
File Emissionn Type
Periodicity Detail Level
Period Beginning Indicator
Taxation Method
Quarter Arbitrated
Quarter Taxation Method
On the SPED Job Inquiry form, select the job you created in Step 1, and click Select.
The system displays the block setup from the Block Setup program (P76B0730).
Modify the UBE versions and whether the system shows details or not.
Click OK on the SPED Job Revision form.
The system displays the SPED Job Inquiry form.
Select Signatories Revision from the Row menu.
The system displays the SPED Job Signatories Revision form.
Add or revise signatory information, and then click OK.
The system populates this field with the next number. You can change this number. This field must contain a value.
(Optional) Enter a description of the job.
Specify the company for which you generate the blocks and registers. The company must be set up in the Legal Company Constants program (P76B010).
Enter the book number for which you create the job. The book number must be set up in the Book Type Definition program (P76B935).
Specify the century for which you will generate the records.
Specify the year for which you will generate the records. For example, to specify the year 2009, enter 09.
Indicates the first period for which you will generate records. By default, the system uses a range of period 1 through period 12. You can only modify this information if there is a special indicator associated to the record.
Indicates the last period for which you will generate records. By default, the system uses a range of period 1 through period 12. You can only modify this information if there is a special indicator associated to the record.
You use this field to indicate if the FCONT txt file is an original report or a rectification of an already reported file. You select a value from UDC table 76B/WT.
The system enables this field in the case of rectification type. Otherwise, it is disabled.
You use this field to identify if the registers must be informed by year or detailed by quarter. You select a value from UDC table 76B/PL.
This field identifies the beginning period indicator, and it is informed in the register 0000. You must select a value from UDC table 76B/PB.
Indicates if the taxation method is real, arbitrated real, presumed real (quarterly) or arbitrated presumed real (quarterly). You must select a value from UDC table 76B/TM.
This field is disabled. The system populates the last processed date.
You select the corresponding checkboxes to indicate if each quarter is arbitrated or not.
You specify the taxation method for each quarter. You select values from UDC table 76B/QM.
Enter the address book number of the person who is authorized to sign the SPED accounting electronic file.
Enter a value from the Signatory qualification Codes (76B/SG) UDC table to specify the title of the person who is signing the SPED FCont electronic file. Keep in mind that for this report there must be only 2 signatories: one of them should be an accountant and the other should be a representative of the company such as a director or administrator.
You process each block for a job separately.
Access the SPED Job Revision form.
Select Block 0 and then click Select/Unselect Block from the Row menu.
The system places check marks next to Block 0 and the UBE for block 0. If you select a different block, the system selects all UBEs associated.
|
Note: You can only select one block at a time, and you cannot select independent UBEs (in the case of Block I) but the entire block. |
From the Form menu, select Process.
The system runs the UBE for block 0 and updates the tables associated with the job.
(Optional) Review the output for Block 0.
Click Cancel or OK to return to the SPED Job Inquiry form.
On the SPED Job Inquiry form, select the job that you processed and select Output Revision from the Row menu.
The system displays the SPED Job Output Revision form. You cannot change the data on this form; you can only review it. Use the View Output Text check box to display or hide the text file data.
Click Close to return to the SPED Job Inquiry form.
Correct data in your source tables if necessary.
If you make changes to the source data, reprocess the block before continuing.
Repeat Steps 1–4 for blocks I, J, M, and 9.
|
Note: You can process blocks 0, I and J in different order, but you must process block M after processing block I. Otherwise, the system displays an error message. |
Access the SPED Job Revision form.
You can reprocess a block only if the block status is D (done).
Select the block to reprocess, and select Select/Unselect Block from the Row menu.
The system places a check mark next to the block and the UBEs for the block.
From the Form menu, select Process.
The system reprocesses the selected block.
|
Important: If you reprocess a block (selected the block), you must also reprocess subsequent blocks that use the data that you regenerated. For example, the Block 9 Generation program (R76B846) reads data from blocks 0, I, J and M. |