Understanding the Sequence Type Setup

You use the FEC Setup by Co-FY program (P74F200) to set up the sequence type based on the company and the fiscal year. The system uses this sequence type while generating the sequential numbering required for FEC Statutory Accounting Audit File. The FEC Setup by Co-FY program also displays the Last Period processed for a company and fiscal year. You cannot modify or delete records after the system has updated the Last Period Processed. The system stores the sequence type and the last period numbered for each company and fiscal year in the Sequence Type by Co-Fiscal Year table (F74F200) and the last sequenced number generated for each company, fiscal period, and the debits and credits amounts in the Last Sequence Number by CO-Fiscal Period table (F74F210).

You can also use this program to review information from previous FEC executions such as the last sequence number used, total debit, and total credit for each company, batch type, and period number. However, you cannot modify this information.

You must define the sequence type in one of these ways:

• Sort by GL Date: If you sort by GL Date, the system generates the sequence number chronologically by fiscal year.

• Sort by Journal Code & GL Date: When you select this option, the system generates the sequence number chronologically by Journal Code. In this case, each journal code possesses its own sequence number by Fiscal Year and the sequence for FEC purpose is created in this way 'Batch type + Sequence Number (ICUT+REG#)'.