Generating French FEC Audit Files

Set Up FEC Products for Reporting Page

FEC_PRODUCT_TBL

Add or remove products to extract transaction data from and to include in the FEC Audit file.

Set Up FEC Accounts for Reporting Page

FEC_SETUP

Add or remove accounts used to select data extracted into the FEC audit file.

Export FEC Data FRA Page

RUN_FEC_EXPORT

Run the FEC export process to extract data into the FEC Audit file in the prescribed format.

SetID

Select the Set ID to set up the group of accounts.

Exclude Type 8 and 9 Accounts

Select this check box to exclude accounts starting with numbers 8 and 9 from the data load process being entered into the FEC Account table.

Populate from Account

Click the Populate from Account button to load associated data into the FEC Account table. Select this option if the accounts you are reporting are stored in the ACCOUNT ChartField.

Populate from Alternate Account

Click the Populate from Alternate Account button to load associated data into the FEC Account table if a statutory chart of accounts exists. Select this option if the accounts you are reporting are stored in the ALTACCT ChartField.

From Account

Enter the beginning account number to search and display for a range of accounts.

To Account

Select the ending account number to search and display for a range of accounts.

Clear

Click to remove all FEC accounts from the FEC Accounts grid and tables.

Account Type Description

Displays the account type.

Balance Forward

Indicates if the account has carry forward balances.

Move FEC to Others

Select an account from the FEC Accounts grid and click the Move FEC to Others button to move it to the Other Accounts grid. This will exclude the selected accounts from reporting in the FEC File.

Move Others To FEC

Select an account from the Other Accounts grid and click the Move Others To FEC button to move it to the FEC Accounts grid. This will enable the selected accounts for reporting in the FEC File.

Language

Select the language used to extract description information.

Business Unit

Select the general ledger Business Unit from which to export data.

Use Legal Entity

Select this check box to allow multiple GL Business Unit to be grouped into a single legal entity and to extract data from all such business units. This selection will also override any applicable row-level security for a particular GL Business Unit and will allow access to all GL Business Units in the legal entity.

In this case, data will be exported for all GL Business Units that belong to the entered GL Business Unit.

For more information about legal entities, please refer toOrganizational and Legal Categorization of Transactions .

Ledger

Select the ledger from which to export data.

Include Beginning Balances

Select this check box to extract beginning balances from the Beginning Balance Journals.

Beginning balances are assumed to have been established through a Beginning Balance Journal. Beginning balances will always refer to the beginning balance of the first period of the entered Fiscal Year. For more information about Beginning Balance Journals, please refer to Closing Rules - Journal Options Page.

Ledger Code

Enter the ledger code, if applicable.

For more information about Book Codes and Ledger Codes, please refer to Understanding PeopleSoft ChartFieldsEntering and Maintaining ChartField Values

Report By

Select Account or Alternate Account as shown on the FEC Setup Accounts page.

When you report by account, you must have Accounts populated in the FEC Accounts table. Likewise, you must have Alternate Accounts populated in the FEC Accounts table when you report by alternate account.

Fiscal Year

Enter a fiscal year from which to select data.

Detail/Summary

Select Summary only if your company is exempted from reporting transaction details. Otherwise, select Detail.

If you select the Detail option, accounting transactions will be reported from the product accounting transaction tables (and from the Journal tables for transactions entered manually within General Ledger). If the Summary option is chosen, summarized accounting information from the General Ledger Journal tables will be reported for all products.

From Period

Enter a starting accounting period from which to export data.

To Period

Enter an ending accounting period from which to export data.

Extract Data

Select this check box to extract data into staging tables.

You must first extract the data into staging tables, from where it can be exported into the FEC audit file. Selecting this option separately from the Generate File option allows you to distribute the workload over several processes. For example, you can extract the data first for specific products and for specific periods before exporting the data into the FEC audit file, in a different process.

Generate File

Select this check box to extract data from staging tables into an output file.

You must first extract the data into staging tables, from where it can be exported into the FEC audit file. Selecting this option separately from the Extract Data option allows you to distribute the workload over several processes. For example, you can run an individual process that will only export the data from the staging tables after you have previously loaded the data into the staging tables through one or several separate processes.

Include Field Names

Select this check box to include field names in the first line of the final output file.

File Name

Enter a name for the final output file, along with the .CSV suffix, as part of the file name; this action is mandatory. The Process Scheduler determines the path for this file. The file produced by the export process is a delimited file, using the | character as the delimiter. For more information, please refer to “PeopleCode Built-in Functions and Language” in PeopleTools: PeopleCode Language Reference.