Declarations >  Audit >  France >  Processes >  ACCENTFIL interface launch  

Display all Hide all

Use this function to generate accounting entry files.

SEEREFERTTO The operating principles and setup conditions of this interface are described in the documentation of the ACCENTFIL Setup function.

Prerequisites

SEEREFERTTO Refer to documentation Implementation

Screen management

Entry screen

Fields

The following fields are present on this tab :

Block number 1

  • Identifier (field IDT)

Code of the identifier you created during the interface setup (ACCENTFIL Setup function). 

When you enter the identifier, the fields in the Generation, Exports and Options blocks are initialized with the values entered in the setup.
  • field DES

Description of the record.

Generation

  • Destination type (field TYPEXP)
  • Log (field TRC)

The Log box is checked by default. The log file indicates the launching criteria and the number of lines generated.

  • Work directory (field VOLFIL)

For a destination of the 'Server' type, enter the directory in which the files will be generated. The path is the path on the server.

Click on the Selection icon in order to open the list of volumes. In this list, you can select a directory.

Exports

This field is automatically populated according to the identifier.

This field is populated according to the identifier. You can modify the company if needed.

Options

  • File breakdown (field FIYPER)

Full fiscal year

Select this extraction type to generate the accounting entries of a full year.

Period

Select this extraction type to generate the accounting entries of a given period.
  • Fiscal year (field FIYNUM)

Enter the number of the required fiscal year. A blocking message is displayed if a fiscal year not closed has been entered.
  • Fiscal year from (field FIYSTR)

The Fiscal year from and Fiscal year to fields automatically indicate the start and end dates of the fiscal year. You cannot modify these dates.
  • Fiscal year to (field FIYEND)

 
  • Period start (field PERSTR)

Enter the start and end dates for the period. A blocking message is displayed if the a period not closed is entered.

You cannot launch the extraction of several periods at a time. If you want to split the accounting entries by trimester, launch the extraction four times.
  • Period end (field PEREND)

 

Close

 

Result of the processing

1. Once you have entered all the setup fields, click OK to launch the extraction. A window for saving the file opens.

By default, the file is saved in the directory specified in the setup. You can modify the default directory in the file save window.

The syntax of the file name is:

SIREN number of the company, FEC code, date with the format YYYYMMDD and period if you chose the extraction for a given period (i.e. if the period is from March to September, the file name will end with: _0309).

2. Click on Select to extract and save the file. A log of the file opens.

File log

In the file log, the following information is displayed:

  • the setup information of the extraction launch,
  • the number of red recordings, being the number of information contained in the generated file,
  • the path to the generation directory of the file,
  • the date and time of extraction.

Raw file

From the directory, open the raw file (.txt).

The raw file contains the following information:

  • on the first line, the names of the fields defined in the setup, but compliant with the standard,
  • then on each line, the accounting entries. Tabs are used as separators inbetween the values of an accounting entry line.

Entries are sorted in the following order:

  • For the ACCENTFIL pivot: entries are sorted by site (FCYLIN) and then by final number (FNLPSTNUM), then by internal number (ACCNUM) - an internal number is assigned to each accounting entry line.
  • For the ACCENTFILN pivot: entries are sorted by site (FCYLIN) and then by accounting date (ACCDAT), then by document number (NUM) - an internal number is assigned to each accounting entry line.

Excel format file

Open the file with Excel.

The fields names are displayed as column titles and the accounting entry lines are displayed on the lines.

SEEINFOFor amounts, the separator for cents is a coma and not a dot.


Batch task

This function can be run in batch mode. The standard task FAEINT is provided for that purpose.

Error messages

In addition to the generic error messages, the following messages can appear during the entry :

Fiscal year not closed

The FY must be closed for the accounting entries file of this FY to be extracted.

Non-closed Period

The period mus be closed for the accounting entries file of this period to be extracted.

Company registration number of the declaration site not assigned.

Enter the SIREN number of your company.

Tables used

SEEREFERTTO Refer to documentation Implementation