14 Work with the ETAFI Interface

This chapter contains the topic:

Section 14.1, "Working with the ETAFI Interface."

14.1 Working with the ETAFI Interface

Navigation

From EMEA Localizations (G74), choose French Reports

From French Reports (G093151), choose ETAFI Interface

You can use J.D. Edwards localization software and the PC package Etats Financiers Financial Reports (ETAFI) to generate all the liasse fiscale reports that are required by French authorities. These reports include Balance Sheet and Income Statements reports.

J.D. Edwards provides a DREAM Writer program that creates a file containing all the information required for the Liasse Fiscale reports. The program generates the balance sheet and income statement information for the file in the format that is required by the French authorities. The program also prints a report that shows the number of accounts that were created in the ETAFI file.

The ETAFI file includes the following information, where N is the date that you specify in the processing options for the program:

Account number
Account description
Balance at fiscal year end (N)
Debit and credit amounts
Balance forward, plus debits and minus credits
Balance at N-1
Balance at N-2
Balance at N-3

The first time you use the ETAFI Interface program, the following scenarios are possible:

Your company has J.D. Edwards historical data for multiple fiscal years in the account transaction file. 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 also clear the processing option that allows balance forwards. When the program runs, the balance forward amounts of the previous fiscal years are updated directly into ETAFI.
Your company does not have J.D. Edwards historical data for multiple fiscal years in the account transaction file. When you run the ETAFI Interface program, you specify previous fiscal years directly in the processing options.

Note:

The member name that you specify in the DREAM Writer processing options will be created if it does not exist. If you do not specify a member name, the program uses F7409FI. Regardless of the member name that you specify, if the member exists, it will be cleared at the beginning of the ETAFI process and then repopulated with the new data.

14.1.1 Before You Begin

If you want to process ledgers in addition to ledger type AA, verify that you have set up these ledger types on user defined codes file 74/FI. See Section 4.1, "Setting Up User Defined Codes for France."

14.1.2 What You Should Know About

Option	Explanation
Multiple companies	If you define multiple companies in the data selection, the program creates only balances by account.
Existing ETAFI interface	If you already have your own custom ETAFI interface, but you decide to use the interface program that is provided by J.D. Edwards, note the following scenarios: You select up to three previous fiscal years. In this case, all adjustments need to have been made on both the J.D. Edwards and ETAFI sides. If not, you should expect unbalanced accounts and differences in the data. You select only the current period from J.D. Edwards. The previous fiscal years have already been uploaded into ETAFI through the interface.

Option

Explanation

Multiple companies

If you define multiple companies in the data selection, the program creates only balances by account.

Existing ETAFI interface

If you already have your own custom ETAFI interface, but you decide to use the interface program that is provided by J.D. Edwards, note the following scenarios:

You select up to three previous fiscal years. In this case, all adjustments need to have been made on both the J.D. Edwards and ETAFI sides. If not, you should expect unbalanced accounts and differences in the data.

You select only the current period from J.D. Edwards. The previous fiscal years have already been uploaded into ETAFI through the interface.

14.1.3 Processing Options

See Section 33.6, "ETAFI Interface (P7409FI)."