Understanding the ETAFI Interface

You can use localization software and the PC package ETAFI (Etats Financiers) [Financial Reports] to generate all of the Liasse Fiscale reports that are required by French authorities. These reports include Balance Sheet and Income Statements, and many other reports that can be printed directly on the official certified forms.

JD Edwards EnterpriseOne software provides a program that creates a table containing all of the information that is required for the Liasse Fiscale reports. Based on criteria that are specified in the processing options and data selection, the ETAFI Interface reads the account balance information from the General Ledger tables and builds a worktable that is used to import the account balances into the ETAFI PC software. The program also prints a report that shows the number of accounts that were created in the ETAFI table.

The ETAFI Interface - OneWorld ONLY table (F7409FOW) includes this information, where N is the date that you specify in the program's processing options:

• Account number

• Account description

• Balance at fiscal year begin (N)

• Debit and credit amounts

• Balance forward, plus debits and minus credits

• Balance at N-1

• Balance at N-2

• Balance at N-3

If you want to process ledgers in addition to ledger type AA, you can specify up to three ledger types in the processing options.

If you define multiple companies in the data selection, the program creates balances that are consolidated by account across companies.

Note: The record identifier that you specify in the processing options is created if it does not already exist. If you do not specify a record identifier in the processing options, the program uses F7409FOW. Regardless of the record identifier that you specify, if the identifier exists, the data for that identifier is cleared at the beginning of the ETAFI process and then repopulated with the new data.

The first time that you use the ETAFI Interface program, either of these scenarios is possible:

• The company has historical data for multiple fiscal years in the account transaction table.

  When you run the ETAFI Interface program, you select the transactions of the previous fiscal years by specifying the fiscal year and period in the processing options. You can also specify the number of previous fiscal years to process in the processing options. By default, only the specified fiscal year is taken into account. When the program runs, the balance forward amounts of the previous fiscal years are updated directly into ETAFI.

• The company does not have historical data for multiple fiscal years in the account transaction table.

  When you run the ETAFI Interface program, you can import only the balances of the previous fiscal year that are specified in the processing options.

If you already have the own custom interface for fiscal reporting and want to implement the interface program that is provided by JD Edwards EnterpriseOne software, consider these possibilities:

• You select up to three previous fiscal years.

  In this case, all of the adjustments need to have been made on both the JD Edwards EnterpriseOne software and ETAFI sides. If this situation is not the case, you should expect unbalanced accounts and differences in the data.

• You select only the current period using the JD Edwards EnterpriseOne interface.

  The previous fiscal years have already been uploaded into ETAFI through the custom interface.