This function is used to define the loading rules of the various segments.

The checks carried out on the 1099 file by the French Administration are extensive. Compliance with the standard is strict, and Sage X3 does not carry out all the checks. There are web sites that can be used to download checking tools that should be implemented before sending the file to the administration.

Here are a few useful Internet sites:

Prerequisite

SEEREFERTTO Refer to documentation Implementation

Screen management

Entry screen

The header used to identify the parameterization group:

The table specifies the loading rules of the segments to be managed:

  • Meaning (Description),
  • Use (Mandatory/Optional),
  • Nature (Alphanumerical, numerical, date),
  • Length,
  • Loading condition (Formula),
  • Options (Zero accepted, length control).

The classes that can be used in the formulas are the following:

Abbreviation

°Type

Object 

Contents

[M:DIA]

Screen

FTD1

Launching parameters of the generation of the 1099 file

[F:CPY]

Table

COMPANY

Current company (Company table as a parameter of the generation)

[F:FCY]

Table

FACILITY

Issuing site as a parameter of the generation

[F:PRV]

Table

 HONPRV

Service provider against fees

[F:HLN]

Table

 HONLIN

Fees lines coming from the fees extraction

[F:PRM]

Table

PRMDADSU

Extraction parameters of the 1099 file

[F:FTD]

Table

FILTDS

Structure of the 1099 file

[F:FIY]

Table

FISCALYEAR

Financial year

[F:TCY]

Table

TABCOUNTRY

Country

[F:FCD]

Table

FACILITY

Site to which the CRE report is sent

[F:BPD]

Table

BPADDRESS

Address of the site to which the CRE report is sent

[F:AID]

Table

CONTACTCRM

Contact at the site to which the CRE report is sent

[F:FCX]

Table

FACILITY

Reporting site

[F:BPX]

Table

BPADDRESS

Address of the reporting site

[F:AIX]

Table

CONTACTCRM

Contact at the reporting site

[F:FCS]

Table

FACILITY

Headquarters site

[F:BPS]

Table

BPADDRESS

Address of the headquarters site

[F:AIS]

Table

CONTACTCRM

Contact at the headquarters site


The following specific functions can be used:

  • TABLE(NUMERO, VALEUR) : Returns the content of the alphanumerical field 1 (A1) of the NUMERO miscellaneous table for the value of the VALEUR code
  • MENU(NOMZONE): Returns values calculated on the basis of the NOMZONE processed field and its value:

NOMZONE

Result

[F:DFC]TAXWAG

"02" if NOMZONE=1, "01" otherwise

[M:DIA]TEST

"02" if NOMZONE=1, "01" if NOMZONE=2, "01" otherwise

[F:PRM]DENCODCOM

"03" if NOMZONE=1, "05" if NOMZONE=2, "" otherwise

[M:DIA]CNTCODCOM

"0"+NOMZONE if NOMZONE ranging from 1 and 5, "" otherwise






Specific Buttons

Copy

This button makes it possible to recopy the current record to another folder.

Error messages

The only error messages are the generic ones.

Tables used

SEEREFERTTO Refer to documentation Implementation